Instructions (not for the faint of heart) for replicating the database are posted. Questions/issues related to replication should be directed to Andrei Mamoutkine.
2026-02-27 04:20:01 (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 |
| comet_names | 5214 | 2025-10-23 17:12:59 | 2025-10-23 17:12:59 |
| comet_orbits | 11220 | 2026-02-19 16:33:17 | 2026-02-19 17:01:02 |
| identifications | 211641 | 2026-01-14 12:15:20 | 2026-01-14 12:15:20 |
| isolated_tracklets | 49812199 | 2026-02-27 04:18:27 | 2026-02-27 04:18:27 |
| mp_discoverers | 1969147 | 2025-06-18 21:18:06 | 2025-06-18 21:18:06 |
| numbered_comet_identifications | 1292 | 2025-10-23 16:03:49 | 2025-10-23 16:03:49 |
| numbered_identifications | 1319125 | 2025-10-22 17:46:28 | 2025-10-22 17:46:28 |
| numbered_mps | 875150 | 2011-10-28 09:36:11 | 2026-01-12 14:34:38 |
| 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 | 502510587 | 2026-02-27 02:47:41 | 2026-02-27 02:47:41 |
| orbit_uncertainties | 787193 | 2019-06-03 12:14:45 | 2022-06-02 16:46:34 |
| orbits | 1535752 | 2026-02-27 02:07:56 | 2026-02-27 03:01:05 |
| radar_observations | 1507 | 2024-12-04 04:59:18 | 2024-12-04 04:59:18 |
| Table | Count | Created_at | Updated_at |
| neocp_els | 107 | 2026-02-03 15:31:03.146684 | 2026-02-27 04:21:48.252083 |
| neocp_events | 313046 | 2026-02-27 04:18:04.980961 | 2026-02-27 04:18:04.980961 |
| neocp_obs_archive | 784304 | 2026-02-27 04:14:07.01062 | 2026-02-27 04:14:07.01062 |
| neocp_obs | 1821 | 2026-02-27 04:14:06.998855 | 2026-02-27 04:14:06.998855 |
| neocp_prev_des | 71208 | 2026-02-27 04:18:04.919944 | 2026-02-27 04:18:04.919944 |
| neocp_var | 205730 | 2026-02-27 04:14:07.142457 | 2026-02-27 04:14:07.142457 |
| current_identifications | 2045955 | 2026-02-27 04:17:08.054322 | 2026-02-27 04:17:08.054322 |
| numbered_identifications | 887935 | 2026-02-27 03:49:38.898045 | 2026-02-27 03:49:38.898045 |
| primary_objects | 1561673 | 2026-02-27 04:17:07.922806 | 2026-02-27 04:17:07.922806 |
| obs_sbn | 530435137 | 2026-02-26 23:15:07.590422-05 | 2026-02-26 23:18:22.96546-05 |
| obs_alterations_deletions | 1493867 | 2026-02-27 03:44:49.312805 | 2026-02-27 03:44:49.312805 |
| obs_alterations_redesignations | 4515 | 2025-12-01 14:51:10.350811 | 2026-02-26 23:34:40.379845 |
| obs_alterations_unassociations | 562242 | 2026-02-26 22:10:07.038195 | 2026-02-26 22:10:07.038195 |
| mpc_orbits | 1518095 | 2021-02-03 22:57:53.94585 | 2026-02-27 04:22:35.234138 |
| minor_planet_names | 25992 | 2011-10-27 06:38:13 | 2026-01-16 00:37:34.652007 |
| obscodes | 2681 | 2026-02-26 23:21:53.289855 | 2026-02-26 23:21:53.289855 |
| comet_names | 4364 | 2026-02-25 01:23:59.404633 | 2026-02-25 01:23:59.404633 |
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_primarydb | obs_sbn | 530435112 | 2026-02-27 03:48:17.220687 | 2026-02-27 04:00:02.463248 |
| MPC_mpcsbndb | obs_sbn | 530435112 | 2026-02-27 03:48:17.220687 | 2026-02-27 04:00:19.14122 |
| SBN_to_AWS | obs_sbn | 530435112 | 2026-02-27 03:48:17.220687 | 2026-02-27 04:00:42.38761 |
| MPC_primarydb | current_identifications | 2045954 | 2026-02-27 03:49:38.8747 | 2026-02-27 04:09:06.187847 |
| MPC_mpcsbndb | current_identifications | 2045954 | 2026-02-27 03:49:38.8747 | 2026-02-27 04:09:06.996736 |
| SBN_to_AWS | current_identifications | 2045954 | 2026-02-27 03:49:38.8747 | 2026-02-27 04:09:07.24467 |
| MPC_primarydb | comet_names | 4364 | 2026-02-25 01:23:59.404633 | 2026-02-27 04:09:08.705314 |
| MPC_mpcsbndb | comet_names | 4364 | 2026-02-25 01:23:59.404633 | 2026-02-27 04:09:08.815041 |
| SBN_to_AWS | comet_names | 4364 | 2026-02-25 01:23:59.404633 | 2026-02-27 04:09:08.898368 |
| MPC_primarydb | minor_planet_names | 25992 | 2026-01-16 00:37:34.652007 | 2026-02-27 04:09:08.99183 |
| MPC_mpcsbndb | minor_planet_names | 25992 | 2026-01-16 00:37:34.652007 | 2026-02-27 04:09:09.16276 |
| SBN_to_AWS | minor_planet_names | 25992 | 2026-01-16 00:37:34.652007 | 2026-02-27 04:09:09.260388 |
| MPC_primarydb | mpc_orbits | 1518094 | 2026-02-27 04:07:55.052476 | 2026-02-27 04:09:09.35804 |
| MPC_mpcsbndb | mpc_orbits | 1518094 | 2026-02-27 04:07:55.052476 | 2026-02-27 04:09:11.048 |
| SBN_to_AWS | mpc_orbits | 1518094 | 2026-02-27 04:07:55.052476 | 2026-02-27 04:09:11.434949 |
| MPC_primarydb | numbered_identifications | 887935 | 2026-02-27 03:49:38.898045 | 2026-02-27 04:09:15.347769 |
| MPC_mpcsbndb | numbered_identifications | 887935 | 2026-02-27 03:49:38.898045 | 2026-02-27 04:09:15.685179 |
| SBN_to_AWS | numbered_identifications | 887935 | 2026-02-27 03:49:38.898045 | 2026-02-27 04:09:15.824532 |
| MPC_primarydb | neocp_els | 108 | 2026-02-27 04:02:17.569581 | 2026-02-27 04:09:16.062498 |
| MPC_mpcsbndb | neocp_els | 108 | 2026-02-27 04:02:17.569581 | 2026-02-27 04:09:16.170166 |
| SBN_to_AWS | neocp_els | 108 | 2026-02-27 04:02:17.569581 | 2026-02-27 04:09:16.252453 |
| MPC_primarydb | neocp_events | 313044 | 2026-02-27 04:02:17.804439 | 2026-02-27 04:09:16.341574 |
| MPC_mpcsbndb | neocp_events | 313044 | 2026-02-27 04:02:17.804439 | 2026-02-27 04:09:16.536877 |
| SBN_to_AWS | neocp_events | 313044 | 2026-02-27 04:02:17.804439 | 2026-02-27 04:09:16.656948 |
| MPC_primarydb | neocp_obs | 1847 | 2026-02-27 04:02:17.558392 | 2026-02-27 04:09:16.796144 |
| MPC_mpcsbndb | neocp_obs | 1847 | 2026-02-27 04:02:17.558392 | 2026-02-27 04:09:16.906363 |
| SBN_to_AWS | neocp_obs | 1847 | 2026-02-27 04:02:17.558392 | 2026-02-27 04:09:16.989653 |
| MPC_primarydb | neocp_obs_archive | 784301 | 2026-02-27 04:02:17.56661 | 2026-02-27 04:09:17.0821 |
| MPC_mpcsbndb | neocp_obs_archive | 784301 | 2026-02-27 04:02:17.56661 | 2026-02-27 04:09:17.348252 |
| SBN_to_AWS | neocp_obs_archive | 784301 | 2026-02-27 04:02:17.56661 | 2026-02-27 04:09:17.487253 |
| MPC_primarydb | neocp_prev_des | 71207 | 2026-02-27 02:46:57.932242 | 2026-02-27 04:09:17.698243 |
| MPC_mpcsbndb | neocp_prev_des | 71207 | 2026-02-27 02:46:57.932242 | 2026-02-27 04:09:17.842627 |
| SBN_to_AWS | neocp_prev_des | 71207 | 2026-02-27 02:46:57.932242 | 2026-02-27 04:09:17.939524 |
| MPC_primarydb | neocp_var | 207730 | 2026-02-27 04:02:17.673259 | 2026-02-27 04:09:18.05327 |
| MPC_mpcsbndb | neocp_var | 207730 | 2026-02-27 04:02:17.673259 | 2026-02-27 04:09:18.245812 |
| SBN_to_AWS | neocp_var | 207730 | 2026-02-27 04:02:17.673259 | 2026-02-27 04:09:18.376114 |
| MPC_primarydb | obscodes | 2681 | 2026-02-26 23:21:53.289855 | 2026-02-27 04:09:18.579111 |
| MPC_mpcsbndb | obscodes | 2681 | 2026-02-26 23:21:53.289855 | 2026-02-27 04:09:18.705837 |
| SBN_to_AWS | obscodes | 2681 | 2026-02-26 23:21:53.289855 | 2026-02-27 04:09:18.788992 |
| MPC_primarydb | primary_objects | 1561672 | 2026-02-27 02:46:22.489167 | 2026-02-27 04:09:18.880714 |
| MPC_mpcsbndb | primary_objects | 1561672 | 2026-02-27 02:46:22.489167 | 2026-02-27 04:09:19.40615 |
| SBN_to_AWS | primary_objects | 1561672 | 2026-02-27 02:46:22.489167 | 2026-02-27 04:09:19.568372 |
| MPC_primarydb | obs_alterations_corrections | 0 | 2026-02-27 04:09:21.127713 | |
| MPC_mpcsbndb | obs_alterations_corrections | 0 | 2026-02-27 04:09:21.234822 | |
| SBN_to_AWS | obs_alterations_corrections | 0 | 2026-02-27 04:09:21.31689 | |
| MPC_primarydb | obs_alterations_deletions | 1493867 | 2026-02-27 03:44:49.312805 | 2026-02-27 04:09:21.402992 |
| MPC_mpcsbndb | obs_alterations_deletions | 1493867 | 2026-02-27 03:44:49.312805 | 2026-02-27 04:09:22.075271 |
| SBN_to_AWS | obs_alterations_deletions | 1493867 | 2026-02-27 03:44:49.312805 | 2026-02-27 04:09:22.219194 |
| MPC_primarydb | obs_alterations_redesignations | 4515 | 2026-02-26 23:34:40.379845 | 2026-02-27 04:09:22.456462 |
| MPC_mpcsbndb | obs_alterations_redesignations | 4515 | 2026-02-26 23:34:40.379845 | 2026-02-27 04:09:22.572296 |
| SBN_to_AWS | obs_alterations_redesignations | 4515 | 2026-02-26 23:34:40.379845 | 2026-02-27 04:09:22.655841 |
| MPC_primarydb | obs_alterations_unassociations | 562242 | 2026-02-26 22:10:07.038195 | 2026-02-27 04:09:22.745413 |
| MPC_mpcsbndb | obs_alterations_unassociations | 562242 | 2026-02-26 22:10:07.038195 | 2026-02-27 04:09:23.044397 |
| SBN_to_AWS | obs_alterations_unassociations | 562242 | 2026-02-26 22:10:07.038195 | 2026-02-27 04:09:23.174993 |