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-10-12 22:00: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 | 5227 | 2026-06-03 09:27:00 | 2026-06-03 09:27:00 |
| comet_orbits | 12845 | 2014-02-10 15:54:12 | 2026-10-09 18:01:03 |
| identifications | 223187 | 2026-07-14 12:33:56 | 2026-07-14 12:33:56 |
| isolated_tracklets | 50790977 | 2026-10-12 21:08:50 | 2026-10-12 21:08:50 |
| mp_discoverers | 1969147 | 2025-06-18 21:18:06 | 2025-06-18 21:18:06 |
| numbered_comet_identifications | 1295 | 2026-06-03 09:12:00 | 2026-06-03 09:12:00 |
| numbered_identifications | 1342746 | 2026-06-03 02:55:41 | 2026-06-03 02:55:41 |
| numbered_mps | 895910 | 2026-06-03 02:57:19 | 2026-09-08 14:26:32 |
| 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 | 524497764 | 2026-10-12 21:43:26 | 2026-10-12 21:43:26 |
| orbit_uncertainties | 787193 | 2019-06-03 12:14:45 | 2022-06-02 16:46:34 |
| orbits | 1587403 | 2026-10-12 21:43:35 | 2026-10-12 22: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 | 107 | 2026-10-11 16:20:03.117997 | 2026-10-12 21:56:17.391901 |
| neocp_events | 343863 | 2026-10-12 21:56:17.309219 | 2026-10-12 21:56:17.309219 |
| neocp_obs_archive | 847826 | 2026-10-12 21:56:17.300808 | 2026-10-12 21:56:17.300808 |
| neocp_obs | 1395 | 2026-10-12 21:56:17.261705 | 2026-10-12 21:56:17.261705 |
| neocp_prev_des | 74796 | 2026-10-12 21:39:48.022001 | 2026-10-12 21:39:48.022001 |
| neocp_var | 198324 | 2026-10-12 21:56:28.300787 | 2026-10-12 21:56:28.300787 |
| current_identifications | 2102882 | 2026-10-12 21:38:11.16576 | 2026-10-12 21:40:47.636268 |
| numbered_identifications | 896611 | 2026-06-02 22:27:20.380719 | 2026-06-03 16:22:06.978451 |
| primary_objects | 1612378 | 2026-10-12 21:37:47.548678 | 2026-10-12 21:37:47.548678 |
| obs_sbn | 557927549 | 2026-10-12 12:52:27.665014-04 | 2026-10-12 18:03:49.508185-04 |
| obs_alterations_deletions | 3461452 | 2026-10-12 20:06:59.16845 | 2026-10-12 20:06:59.16845 |
| obs_alterations_redesignations | 5218 | 2026-08-25 19:50:31.030107 | 2026-08-25 19:50:31.030107 |
| obs_alterations_unassociations | 608225 | 2026-10-12 18:12:59.991246 | 2026-10-12 18:12:59.991246 |
| mpc_orbits | 1578267 | 2021-02-04 01:00:51.614356 | 2026-10-12 22:04:08.385772 |
| minor_planet_names | 26688 | 2011-10-28 10:08:52 | 2026-09-08 18:26:32.060609 |
| obscodes | 2732 | 2026-10-09 15:41:17.672021 | 2026-10-09 15:41:17.672021 |
| comet_names | 4397 | 2026-10-08 15:56:24.808096 | 2026-10-08 15:59:07.78986 |
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 | 557900781 | 2026-10-12 20:59:59.748894 | 2026-10-12 21:00:01.958251 |
| MPC_mpcsbndb | obs_sbn | 557901130 | 2026-10-12 21:00:35.803734 | 2026-10-12 21:00:38.62434 |
| SBN_to_AWS | obs_sbn | 557901779 | 2026-10-12 21:01:26.753815 | 2026-10-12 21:01:32.664347 |
| MPC_primarydb | current_identifications | 2102880 | 2026-10-12 19:55:32.230122 | 2026-10-12 21:14:57.32984 |
| MPC_mpcsbndb | current_identifications | 2102880 | 2026-10-12 19:55:32.230122 | 2026-10-12 21:14:59.803423 |
| SBN_to_AWS | current_identifications | 2102880 | 2026-10-12 19:55:32.230122 | 2026-10-12 21:15:00.028607 |
| MPC_primarydb | comet_names | 4397 | 2026-10-08 15:59:07.78986 | 2026-10-12 21:15:00.79991 |
| MPC_mpcsbndb | comet_names | 4397 | 2026-10-08 15:59:07.78986 | 2026-10-12 21:15:00.9381 |
| SBN_to_AWS | comet_names | 4397 | 2026-10-08 15:59:07.78986 | 2026-10-12 21:15:01.027506 |
| MPC_primarydb | minor_planet_names | 26688 | 2026-09-08 18:26:32.060609 | 2026-10-12 21:15:01.131364 |
| MPC_mpcsbndb | minor_planet_names | 26688 | 2026-09-08 18:26:32.060609 | 2026-10-12 21:15:01.392794 |
| SBN_to_AWS | minor_planet_names | 26688 | 2026-09-08 18:26:32.060609 | 2026-10-12 21:15:01.51013 |
| MPC_primarydb | mpc_orbits | 1578265 | 2026-10-12 21:14:58.138758 | 2026-10-12 21:15:01.711695 |
| MPC_mpcsbndb | mpc_orbits | 1578265 | 2026-10-12 21:16:02.613589 | 2026-10-12 21:16:04.276833 |
| SBN_to_AWS | mpc_orbits | 1578265 | 2026-10-12 21:16:02.613589 | 2026-10-12 21:16:04.741791 |
| MPC_primarydb | numbered_identifications | 896611 | 2026-06-03 16:22:06.978451 | 2026-10-12 21:16:06.913242 |
| MPC_mpcsbndb | numbered_identifications | 896611 | 2026-06-03 16:22:06.978451 | 2026-10-12 21:16:07.29803 |
| SBN_to_AWS | numbered_identifications | 896611 | 2026-06-03 16:22:06.978451 | 2026-10-12 21:16:07.430171 |
| MPC_primarydb | neocp_els | 108 | 2026-10-12 21:13:41.875045 | 2026-10-12 21:16:07.728302 |
| MPC_mpcsbndb | neocp_els | 108 | 2026-10-12 21:13:41.875045 | 2026-10-12 21:16:07.831589 |
| SBN_to_AWS | neocp_els | 108 | 2026-10-12 21:13:41.875045 | 2026-10-12 21:16:07.905432 |
| MPC_primarydb | neocp_events | 343855 | 2026-10-12 21:13:41.821897 | 2026-10-12 21:16:07.983496 |
| MPC_mpcsbndb | neocp_events | 343855 | 2026-10-12 21:13:41.821897 | 2026-10-12 21:16:08.174547 |
| SBN_to_AWS | neocp_events | 343855 | 2026-10-12 21:13:41.821897 | 2026-10-12 21:16:08.301376 |
| MPC_primarydb | neocp_obs | 1396 | 2026-10-12 21:13:41.775032 | 2026-10-12 21:16:08.456007 |
| MPC_mpcsbndb | neocp_obs | 1396 | 2026-10-12 21:13:41.775032 | 2026-10-12 21:16:08.55783 |
| SBN_to_AWS | neocp_obs | 1396 | 2026-10-12 21:13:41.775032 | 2026-10-12 21:16:08.631881 |
| MPC_primarydb | neocp_obs_archive | 847810 | 2026-10-12 21:13:41.806242 | 2026-10-12 21:16:08.718251 |
| MPC_mpcsbndb | neocp_obs_archive | 847810 | 2026-10-12 21:13:41.806242 | 2026-10-12 21:16:08.986241 |
| SBN_to_AWS | neocp_obs_archive | 847810 | 2026-10-12 21:13:41.806242 | 2026-10-12 21:16:09.120983 |
| MPC_primarydb | neocp_prev_des | 74795 | 2026-10-12 19:20:08.002373 | 2026-10-12 21:16:09.369113 |
| MPC_mpcsbndb | neocp_prev_des | 74795 | 2026-10-12 19:20:08.002373 | 2026-10-12 21:16:09.510277 |
| SBN_to_AWS | neocp_prev_des | 74795 | 2026-10-12 19:20:08.002373 | 2026-10-12 21:16:09.598404 |
| MPC_primarydb | neocp_var | 200293 | 2026-10-12 21:13:41.966219 | 2026-10-12 21:16:09.709221 |
| MPC_mpcsbndb | neocp_var | 200293 | 2026-10-12 21:13:41.966219 | 2026-10-12 21:16:09.902786 |
| SBN_to_AWS | neocp_var | 200293 | 2026-10-12 21:13:41.966219 | 2026-10-12 21:16:10.007472 |
| MPC_primarydb | obscodes | 2732 | 2026-10-09 15:41:17.672021 | 2026-10-12 21:16:10.215545 |
| MPC_mpcsbndb | obscodes | 2732 | 2026-10-09 15:41:17.672021 | 2026-10-12 21:16:10.359596 |
| SBN_to_AWS | obscodes | 2732 | 2026-10-09 15:41:17.672021 | 2026-10-12 21:16:10.443084 |
| MPC_primarydb | primary_objects | 1612376 | 2026-10-12 19:54:28.655824 | 2026-10-12 21:16:10.532516 |
| MPC_mpcsbndb | primary_objects | 1612376 | 2026-10-12 19:54:28.655824 | 2026-10-12 21:16:11.290156 |
| SBN_to_AWS | primary_objects | 1612376 | 2026-10-12 19:54:28.655824 | 2026-10-12 21:16:11.521522 |
| MPC_primarydb | obs_alterations_corrections | 0 | 2026-10-12 21:16:13.156204 | |
| MPC_mpcsbndb | obs_alterations_corrections | 0 | 2026-10-12 21:16:13.2936 | |
| SBN_to_AWS | obs_alterations_corrections | 0 | 2026-10-12 21:16:13.398621 | |
| MPC_primarydb | obs_alterations_deletions | 3461452 | 2026-10-12 20:06:59.16845 | 2026-10-12 21:16:13.485444 |
| MPC_mpcsbndb | obs_alterations_deletions | 3461452 | 2026-10-12 20:06:59.16845 | 2026-10-12 21:16:25.505293 |
| SBN_to_AWS | obs_alterations_deletions | 3461452 | 2026-10-12 20:06:59.16845 | 2026-10-12 21:16:25.742027 |
| MPC_primarydb | obs_alterations_redesignations | 5218 | 2026-08-25 19:50:31.030107 | 2026-10-12 21:16:26.107736 |
| MPC_mpcsbndb | obs_alterations_redesignations | 5218 | 2026-08-25 19:50:31.030107 | 2026-10-12 21:16:26.242609 |
| SBN_to_AWS | obs_alterations_redesignations | 5218 | 2026-08-25 19:50:31.030107 | 2026-10-12 21:16:26.334823 |
| MPC_primarydb | obs_alterations_unassociations | 608225 | 2026-10-12 18:12:59.991246 | 2026-10-12 21:16:26.429849 |
| MPC_mpcsbndb | obs_alterations_unassociations | 608225 | 2026-10-12 18:12:59.991246 | 2026-10-12 21:16:26.773877 |
| SBN_to_AWS | obs_alterations_unassociations | 608225 | 2026-10-12 18:12:59.991246 | 2026-10-12 21:16:26.901825 |