Instructions (not for the faint of heart) for replicating the database are posted. Questions/issues related to replication should be directed to Andrei Mamoutkine.
2025-01-20 15:50:02 (GMT)
Status of all major tables from MariaDB (mpc_development) and Postgres database (mpc_sbn). It includes list of all major tables, number of records in each tables, the latest updated record in each table. A color code corresponds to records updated less than 1 day, from 1 to 3 days and older than 3 days. Updated every 5 min. GMT timestamp of update is at the top left of the page.
Source file of data: statusDB.csv
| Table | Count | Created_at | Updated_at |
| close_approaches | 223366 | 2019-05-23 19:22:13 | 2019-05-23 19:22:13 |
| comet_names | 4586 | 2017-03-15 16:46:33 | 2017-03-15 16:46:33 |
| comet_orbit_uncertainties | 1015 | 2019-06-04 12:15:27 | 2019-06-04 12:15:27 |
| comet_orbits | 9665 | 2025-01-18 17:04:01 | 2025-01-18 18:01:02 |
| identifications | 203182 | 2025-01-15 12:21:09 | 2025-01-15 12:21:09 |
| isolated_tracklets | 48083084 | 2025-01-20 15:48:11 | 2025-01-20 15:48:11 |
| mpc_indices | 396 | 2024-07-31 18:00:03 | 2024-07-31 18:00:03 |
| numbered_identifications | 1180140 | 2024-12-03 05:16:03 | 2024-12-03 05:16:03 |
| numbered_mps | 756999 | 2024-07-23 01:32:19 | 2024-12-17 16:05:20 |
| obs_request_observers | 52 | 2019-07-24 16:57:48 | 2019-07-24 16:57:48 |
| obs_request_users | 7 | 2015-12-04 00:25:22 | 2015-12-04 00:25:22 |
| observations | 463580514 | 2025-01-20 15:30:08 | 2025-01-20 15:30:08 |
| orbit_uncertainties | 785438 | 2019-06-05 12:14:34 | 2024-12-03 08:16:15 |
| orbits | 1450586 | 2025-01-20 15:30:25 | 2025-01-20 15:30:25 |
| perturbed_orbits | 175724170 | 2018-09-27 17:20:33 | 2018-09-27 17:20:33 |
| radar_observations | 1507 | 2024-12-04 04:59:18 | 2024-12-04 04:59:18 |
| Table | Count | Created_at | Updated_at |
| neocp_els | 88 | 2025-01-19 06:31:49.845582 | 2025-01-20 15:48:49.803273 |
| neocp_events | 259335 | 2025-01-20 15:53:52.565549 | 2025-01-20 15:53:52.565549 |
| neocp_obs_archive | 659193 | 2025-01-20 15:18:20.380736 | 2025-01-20 15:18:20.380736 |
| neocp_obs | 780 | 2025-01-20 15:18:20.376861 | 2025-01-20 15:18:20.376861 |
| neocp_prev_des | 64183 | 2025-01-20 15:53:52.545294 | 2025-01-20 15:53:52.545294 |
| neocp_var | 170728 | 2025-01-20 15:48:50.622833 | 2025-01-20 15:48:50.622833 |
| current_identifications | 1960554 | 2025-01-20 15:54:14.62187 | 2025-01-20 15:54:14.62187 |
| numbered_identifications | 757793 | 2024-11-26 17:37:39.601776 | 2024-11-26 17:37:39.601776 |
| primary_objects | 1480383 | 2025-01-20 15:54:14.609017 | 2025-01-20 15:54:14.609017 |
| obs_sbn | 475885873 | 2023-05-13 10:52:03.5466-04 | 2025-01-20 10:54:15.719136-05 |
| obs_alterations_deletions | 1314552 | 2025-01-20 15:47:49.862217 | 2025-01-20 15:47:49.862217 |
| obs_alterations_redesignations | 4100 | 2025-01-15 11:52:38.064374 | 2025-01-15 11:52:38.064374 |
| obs_alterations_unassociations | 361276 | 2025-01-20 15:28:53.987235 | 2025-01-20 15:28:53.987235 |
| mpc_orbits | 1430889 | 2021-02-04 02:43:15.210241 | 2025-01-20 15:53:49.611277 |
YYYY-MM-DD - latest record is older than 3 days
YYYY-MM-DD - latest record is older than 1 day
YYYY-MM-DD - latest record is less than 1 day old
| Server | Table | Count | Updated_at | Queried_at |
| MPC_marsden | obs_sbn | 475884305 | 2025-01-20 14:59:13.780854 | 2025-01-20 15:00:02.592538 |
| MPC_mpcsbndb | obs_sbn | 475884370 | 2025-01-20 15:12:28.521831 | 2025-01-20 15:12:35.47828 |
| SBN_to_AWS | obs_sbn | 475884370 | 2025-01-20 15:12:28.521831 | 2025-01-20 15:12:46.780315 |
| MPC_marsden | current_identifications | 1960528 | 2025-01-20 15:12:27.513062 | 2025-01-20 15:13:21.532632 |
| MPC_mpcsbndb | current_identifications | 1960528 | 2025-01-20 15:12:27.513062 | 2025-01-20 15:13:22.620244 |
| SBN_to_AWS | current_identifications | 1960528 | 2025-01-20 15:12:27.513062 | 2025-01-20 15:13:22.787278 |
| MPC_marsden | mpc_orbits | 1430864 | 2025-01-20 15:13:10.185347 | 2025-01-20 15:13:22.992418 |
| MPC_mpcsbndb | mpc_orbits | 1430864 | 2025-01-20 15:13:10.185347 | 2025-01-20 15:13:25.902262 |
| SBN_to_AWS | mpc_orbits | 1430864 | 2025-01-20 15:13:10.185347 | 2025-01-20 15:13:26.122862 |
| MPC_marsden | numbered_identifications | 757793 | 2024-11-26 17:37:39.601776 | 2025-01-20 15:13:26.389746 |
| MPC_mpcsbndb | numbered_identifications | 757793 | 2024-11-26 17:37:39.601776 | 2025-01-20 15:13:26.764065 |
| SBN_to_AWS | numbered_identifications | 757793 | 2024-11-26 17:37:39.601776 | 2025-01-20 15:13:26.892696 |
| MPC_marsden | neocp_els | 90 | 2025-01-20 14:24:17.356217 | 2025-01-20 15:13:27.019324 |
| MPC_mpcsbndb | neocp_els | 90 | 2025-01-20 14:24:17.356217 | 2025-01-20 15:13:27.110732 |
| SBN_to_AWS | neocp_els | 90 | 2025-01-20 14:24:17.356217 | 2025-01-20 15:13:27.192406 |
| MPC_marsden | neocp_events | 259331 | 2025-01-20 14:12:21.700572 | 2025-01-20 15:13:27.27724 |
| MPC_mpcsbndb | neocp_events | 259331 | 2025-01-20 14:12:21.700572 | 2025-01-20 15:13:27.477878 |
| SBN_to_AWS | neocp_events | 259331 | 2025-01-20 14:12:21.700572 | 2025-01-20 15:13:27.586541 |
| MPC_marsden | neocp_obs | 777 | 2025-01-20 14:12:19.779924 | 2025-01-20 15:13:27.689828 |
| MPC_mpcsbndb | neocp_obs | 777 | 2025-01-20 14:12:19.779924 | 2025-01-20 15:13:27.782108 |
| SBN_to_AWS | neocp_obs | 777 | 2025-01-20 14:12:19.779924 | 2025-01-20 15:13:27.864175 |
| MPC_marsden | neocp_obs_archive | 659190 | 2025-01-20 14:12:19.783446 | 2025-01-20 15:13:27.949331 |
| MPC_mpcsbndb | neocp_obs_archive | 659190 | 2025-01-20 14:12:19.783446 | 2025-01-20 15:13:28.167948 |
| SBN_to_AWS | neocp_obs_archive | 659190 | 2025-01-20 14:12:19.783446 | 2025-01-20 15:13:28.285336 |
| MPC_marsden | neocp_prev_des | 64181 | 2025-01-20 13:58:58.60382 | 2025-01-20 15:13:28.409311 |
| MPC_mpcsbndb | neocp_prev_des | 64181 | 2025-01-20 13:58:58.60382 | 2025-01-20 15:13:28.535646 |
| SBN_to_AWS | neocp_prev_des | 64181 | 2025-01-20 13:58:58.60382 | 2025-01-20 15:13:28.634972 |
| MPC_marsden | neocp_var | 172274 | 2025-01-20 14:12:21.63894 | 2025-01-20 15:13:28.72777 |
| MPC_mpcsbndb | neocp_var | 172274 | 2025-01-20 14:12:21.63894 | 2025-01-20 15:13:28.892654 |
| SBN_to_AWS | neocp_var | 172274 | 2025-01-20 14:12:21.63894 | 2025-01-20 15:13:29.009934 |
| MPC_marsden | primary_objects | 1480357 | 2025-01-20 15:12:27.502471 | 2025-01-20 15:13:29.112056 |
| MPC_mpcsbndb | primary_objects | 1480357 | 2025-01-20 15:12:27.502471 | 2025-01-20 15:13:29.771369 |
| SBN_to_AWS | primary_objects | 1480357 | 2025-01-20 15:12:27.502471 | 2025-01-20 15:13:29.932734 |
| MPC_marsden | obs_alterations_corrections | 2025-01-20 15:13:30.102077 | ||
| MPC_mpcsbndb | obs_alterations_corrections | 2025-01-20 15:13:30.193997 | ||
| SBN_to_AWS | obs_alterations_corrections | 2025-01-20 15:13:30.275577 | ||
| MPC_marsden | obs_alterations_deletions | 1314544 | 2025-01-20 11:45:02.736859 | 2025-01-20 15:13:30.361036 |
| MPC_mpcsbndb | obs_alterations_deletions | 1314544 | 2025-01-20 11:45:02.736859 | 2025-01-20 15:13:30.987763 |
| SBN_to_AWS | obs_alterations_deletions | 1314544 | 2025-01-20 11:45:02.736859 | 2025-01-20 15:13:31.110726 |
| MPC_marsden | obs_alterations_redesignations | 4100 | 2025-01-15 11:52:38.064374 | 2025-01-20 15:13:31.250799 |
| MPC_mpcsbndb | obs_alterations_redesignations | 4100 | 2025-01-15 11:52:38.064374 | 2025-01-20 15:13:31.349512 |
| SBN_to_AWS | obs_alterations_redesignations | 4100 | 2025-01-15 11:52:38.064374 | 2025-01-20 15:13:31.433127 |