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-11-03 07:40: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 |
| comet_names | 5214 | 2025-10-23 17:12:59 | 2025-10-23 17:12:59 |
| comet_orbits | 10780 | 2013-03-09 18:03:04 | 2025-10-28 23:01:03 |
| identifications | 209593 | 2025-11-02 12:27:10 | 2025-11-02 12:27:10 |
| isolated_tracklets | 49380708 | 2025-11-03 07:37:40 | 2025-11-03 07:37:40 |
| 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 | 2025-10-23 01:12:58 | 2025-10-23 01:12:58 |
| 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 | 496620189 | 2025-11-03 02:21:24 | 2025-11-03 02:21:24 |
| orbit_uncertainties | 787193 | 2019-06-03 12:14:45 | 2022-06-02 16:46:34 |
| orbits | 1488426 | 2025-11-03 02:21:29 | 2025-11-03 03:01:03 |
| radar_observations | 1507 | 2024-12-04 04:59:18 | 2024-12-04 04:59:18 |
| Table | Count | Created_at | Updated_at |
| neocp_els | 47 | 2025-10-24 17:16:52.974938 | 2025-11-03 07:21:14.050375 |
| neocp_events | 295526 | 2025-11-03 06:31:35.243211 | 2025-11-03 06:31:35.243211 |
| neocp_obs_archive | 744380 | 2025-11-03 06:31:34.972221 | 2025-11-03 06:31:34.972221 |
| neocp_obs | 466 | 2025-11-03 06:31:34.931382 | 2025-11-03 06:31:34.931382 |
| neocp_prev_des | 68991 | 2025-11-03 02:21:30.826917 | 2025-11-03 02:21:30.826917 |
| neocp_var | 88096 | 2025-11-03 06:31:35.104251 | 2025-11-03 06:31:35.104251 |
| current_identifications | 1998427 | 2025-11-03 07:36:31.591133 | 2025-11-03 07:36:58.599422 |
| numbered_identifications | 875979 | 2025-10-20 21:02:31.305341 | 2025-10-20 21:02:31.305341 |
| primary_objects | 1515113 | 2025-11-03 07:36:31.554488 | 2025-11-03 07:36:31.554488 |
| obs_sbn | 508667392 | 2025-11-03 02:43:03.65775-05 | 2025-11-03 02:43:12.193896-05 |
| obs_alterations_deletions | 1381708 | 2025-11-02 20:44:36.458885 | 2025-11-02 20:44:36.458885 |
| obs_alterations_redesignations | 4376 | 2025-10-28 11:51:18.063401 | 2025-10-28 11:51:18.063401 |
| obs_alterations_unassociations | 484535 | 2025-11-03 02:42:03.254423 | 2025-11-03 02:42:03.254423 |
| mpc_orbits | 1469856 | 2021-02-04 01:35:02.096076 | 2025-11-03 07:43:12.193896 |
| minor_planet_names | 25808 | 2018-03-04 02:26:16 | 2025-10-29 21:23:06.689327 |
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 | 508661079 | 2025-11-03 06:59:10.137308 | 2025-11-03 07:00:02.87822 |
| MPC_mpcsbndb | obs_sbn | 508661079 | 2025-11-03 06:59:10.137308 | 2025-11-03 07:00:28.603658 |
| SBN_to_AWS | obs_sbn | 508661079 | 2025-11-03 06:59:10.137308 | 2025-11-03 07:00:53.361523 |
| MPC_primarydb | current_identifications | 1998426 | 2025-11-03 07:16:54.462036 | 2025-11-03 07:27:49.749863 |
| MPC_mpcsbndb | current_identifications | 1998426 | 2025-11-03 07:16:54.462036 | 2025-11-03 07:27:50.421135 |
| SBN_to_AWS | current_identifications | 1998426 | 2025-11-03 07:16:54.462036 | 2025-11-03 07:27:50.633597 |
| MPC_primarydb | minor_planet_names | 25808 | 2025-10-29 21:23:06.689327 | 2025-11-03 07:27:51.046862 |
| MPC_mpcsbndb | minor_planet_names | 25808 | 2025-10-29 21:23:06.689327 | 2025-11-03 07:27:51.198761 |
| SBN_to_AWS | minor_planet_names | 25808 | 2025-10-29 21:23:06.689327 | 2025-11-03 07:27:51.29878 |
| MPC_primarydb | mpc_orbits | 1469855 | 2025-11-03 07:27:51.366074 | 2025-11-03 07:27:51.399414 |
| MPC_mpcsbndb | mpc_orbits | 1469855 | 2025-11-03 07:27:52.513349 | 2025-11-03 07:27:53.411038 |
| SBN_to_AWS | mpc_orbits | 1469855 | 2025-11-03 07:27:52.265729 | 2025-11-03 07:27:53.725265 |
| MPC_primarydb | numbered_identifications | 875979 | 2025-10-20 21:02:31.305341 | 2025-11-03 07:27:56.285243 |
| MPC_mpcsbndb | numbered_identifications | 875979 | 2025-10-20 21:02:31.305341 | 2025-11-03 07:27:56.660658 |
| SBN_to_AWS | numbered_identifications | 875979 | 2025-10-20 21:02:31.305341 | 2025-11-03 07:27:56.786632 |
| MPC_primarydb | neocp_els | 47 | 2025-11-03 07:21:14.050375 | 2025-11-03 07:27:56.958779 |
| MPC_mpcsbndb | neocp_els | 47 | 2025-11-03 07:21:14.050375 | 2025-11-03 07:27:57.070406 |
| SBN_to_AWS | neocp_els | 47 | 2025-11-03 07:21:14.050375 | 2025-11-03 07:27:57.151706 |
| MPC_primarydb | neocp_events | 295526 | 2025-11-03 06:31:35.243211 | 2025-11-03 07:27:57.240073 |
| MPC_mpcsbndb | neocp_events | 295526 | 2025-11-03 06:31:35.243211 | 2025-11-03 07:27:57.442488 |
| SBN_to_AWS | neocp_events | 295526 | 2025-11-03 06:31:35.243211 | 2025-11-03 07:27:57.557471 |
| MPC_primarydb | neocp_obs | 466 | 2025-11-03 06:31:34.931382 | 2025-11-03 07:27:57.673923 |
| MPC_mpcsbndb | neocp_obs | 466 | 2025-11-03 06:31:34.931382 | 2025-11-03 07:27:57.787628 |
| SBN_to_AWS | neocp_obs | 466 | 2025-11-03 06:31:34.931382 | 2025-11-03 07:27:57.869955 |
| MPC_primarydb | neocp_obs_archive | 744380 | 2025-11-03 06:31:34.972221 | 2025-11-03 07:27:57.960115 |
| MPC_mpcsbndb | neocp_obs_archive | 744380 | 2025-11-03 06:31:34.972221 | 2025-11-03 07:27:58.227113 |
| SBN_to_AWS | neocp_obs_archive | 744380 | 2025-11-03 06:31:34.972221 | 2025-11-03 07:27:58.358726 |
| MPC_primarydb | neocp_prev_des | 68991 | 2025-11-03 02:21:30.826917 | 2025-11-03 07:27:58.503894 |
| MPC_mpcsbndb | neocp_prev_des | 68991 | 2025-11-03 02:21:30.826917 | 2025-11-03 07:27:58.652987 |
| SBN_to_AWS | neocp_prev_des | 68991 | 2025-11-03 02:21:30.826917 | 2025-11-03 07:27:58.750411 |
| MPC_primarydb | neocp_var | 88096 | 2025-11-03 06:31:35.104251 | 2025-11-03 07:27:58.853749 |
| MPC_mpcsbndb | neocp_var | 88096 | 2025-11-03 06:31:35.104251 | 2025-11-03 07:27:59.032383 |
| SBN_to_AWS | neocp_var | 88096 | 2025-11-03 06:31:35.104251 | 2025-11-03 07:27:59.143258 |
| MPC_primarydb | obscodes | 2659 | 2025-10-29 18:29:05.113904 | 2025-11-03 07:27:59.296412 |
| MPC_mpcsbndb | obscodes | 2659 | 2025-10-29 18:29:05.113904 | 2025-11-03 07:27:59.427555 |
| SBN_to_AWS | obscodes | 2659 | 2025-10-29 18:29:05.113904 | 2025-11-03 07:27:59.509273 |
| MPC_primarydb | primary_objects | 1515112 | 2025-11-03 07:16:27.673996 | 2025-11-03 07:27:59.611232 |
| MPC_mpcsbndb | primary_objects | 1515112 | 2025-11-03 07:16:27.673996 | 2025-11-03 07:28:00.092011 |
| SBN_to_AWS | primary_objects | 1515112 | 2025-11-03 07:16:27.673996 | 2025-11-03 07:28:00.261641 |
| MPC_primarydb | obs_alterations_corrections | 0 | 2025-11-03 07:28:00.803395 | |
| MPC_mpcsbndb | obs_alterations_corrections | 0 | 2025-11-03 07:28:00.919738 | |
| SBN_to_AWS | obs_alterations_corrections | 0 | 2025-11-03 07:28:01.011582 | |
| MPC_primarydb | obs_alterations_deletions | 1381708 | 2025-11-02 20:44:36.458885 | 2025-11-03 07:28:01.099051 |
| MPC_mpcsbndb | obs_alterations_deletions | 1381708 | 2025-11-02 20:44:36.458885 | 2025-11-03 07:28:01.629111 |
| SBN_to_AWS | obs_alterations_deletions | 1381708 | 2025-11-02 20:44:36.458885 | 2025-11-03 07:28:01.754872 |
| MPC_primarydb | obs_alterations_redesignations | 4376 | 2025-10-28 11:51:18.063401 | 2025-11-03 07:28:01.904047 |
| MPC_mpcsbndb | obs_alterations_redesignations | 4376 | 2025-10-28 11:51:18.063401 | 2025-11-03 07:28:02.052727 |
| SBN_to_AWS | obs_alterations_redesignations | 4376 | 2025-10-28 11:51:18.063401 | 2025-11-03 07:28:02.138739 |