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-05-20 10:30: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 | 5215 | 2026-03-06 22:06:00 | 2026-03-06 22:06:00 |
| comet_orbits | 12627 | 2026-05-19 16:34:15 | 2026-05-19 17:01:02 |
| identifications | 218331 | 2026-04-14 12:33:30 | 2026-04-14 12:33:30 |
| isolated_tracklets | 49958792 | 2026-05-20 10:28:45 | 2026-05-20 10:28:45 |
| 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 | 1333152 | 2026-03-05 21:16:52 | 2026-03-05 21:16:52 |
| numbered_mps | 887103 | 2024-02-21 19:12:24 | 2026-05-07 10:18:37 |
| 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 | 512082822 | 2026-05-20 01:58:42 | 2026-05-20 01:58:42 |
| orbit_uncertainties | 787193 | 2019-06-03 12:14:45 | 2022-06-02 16:46:34 |
| orbits | 1558637 | 2026-05-20 01:58:46 | 2026-05-20 02:01:02 |
| radar_observations | 1507 | 2024-12-04 04:59:18 | 2024-12-04 04:59:18 |
| Table | Count | Created_at | Updated_at |
| neocp_els | 17 | 2026-05-20 10:30:20.755416 | 2026-05-20 10:30:20.755416 |
| neocp_events | 324310 | 2026-05-20 10:30:20.978007 | 2026-05-20 10:30:20.978007 |
| neocp_obs_archive | 811852 | 2026-05-20 10:30:20.30973 | 2026-05-20 10:30:20.30973 |
| neocp_obs | 271 | 2026-05-20 10:30:20.024698 | 2026-05-20 10:30:20.024698 |
| neocp_prev_des | 72473 | 2026-05-20 07:37:33.130662 | 2026-05-20 07:37:33.130662 |
| neocp_var | 45166 | 2026-05-20 10:30:20.396464 | 2026-05-20 10:30:20.396464 |
| current_identifications | 2071279 | 2026-05-20 04:19:21.07026 | 2026-05-20 04:19:21.07026 |
| numbered_identifications | 887936 | 2026-03-24 19:55:09.966554 | 2026-03-24 19:55:09.966554 |
| primary_objects | 1583747 | 2026-05-20 04:19:20.939383 | 2026-05-20 04:19:20.939383 |
| obs_sbn | 539330308 | 2026-05-20 06:24:39.467259-04 | 2026-05-20 06:28:42.937135-04 |
| obs_alterations_deletions | 1490128 | 2026-05-20 09:34:00.758119 | 2026-05-20 09:34:00.758119 |
| obs_alterations_redesignations | 5083 | 2026-04-07 06:22:54.863572 | 2026-04-07 06:22:54.863572 |
| obs_alterations_unassociations | 580242 | 2026-05-20 09:09:22.565182 | 2026-05-20 09:09:22.565182 |
| mpc_orbits | 1548636 | 2026-05-15 01:16:08.020532 | 2026-05-20 10:27:12.248409 |
| minor_planet_names | 26199 | 2026-05-07 14:26:32.139498 | 2026-05-07 14:26:32.139498 |
| obscodes | 2702 | 2026-05-15 19:49:43.167881 | 2026-05-15 19:49:43.167881 |
| comet_names | 4375 | 2026-05-19 15:51:18.61194 | 2026-05-19 15:51:18.61194 |
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 | 539330162 | 2026-05-20 09:58:23.545318 | 2026-05-20 10:00:02.114291 |
| MPC_mpcsbndb | obs_sbn | 539330162 | 2026-05-20 09:58:23.545318 | 2026-05-20 10:00:18.168992 |
| SBN_to_AWS | obs_sbn | 539330162 | 2026-05-20 09:58:23.545318 | 2026-05-20 10:00:41.58656 |
| MPC_primarydb | current_identifications | 2071279 | 2026-05-20 04:19:21.07026 | 2026-05-20 10:16:03.659718 |
| MPC_mpcsbndb | current_identifications | 2071279 | 2026-05-20 04:19:21.07026 | 2026-05-20 10:16:04.63344 |
| SBN_to_AWS | current_identifications | 2071279 | 2026-05-20 04:19:21.07026 | 2026-05-20 10:16:04.77899 |
| MPC_primarydb | comet_names | 4375 | 2026-05-19 15:51:18.61194 | 2026-05-20 10:16:05.158324 |
| MPC_mpcsbndb | comet_names | 4375 | 2026-05-19 15:51:18.61194 | 2026-05-20 10:16:05.268359 |
| SBN_to_AWS | comet_names | 4375 | 2026-05-19 15:51:18.61194 | 2026-05-20 10:16:05.351309 |
| MPC_primarydb | minor_planet_names | 26199 | 2026-05-07 14:26:32.139498 | 2026-05-20 10:16:05.44642 |
| MPC_mpcsbndb | minor_planet_names | 26199 | 2026-05-07 14:26:32.139498 | 2026-05-20 10:16:05.595867 |
| SBN_to_AWS | minor_planet_names | 26199 | 2026-05-07 14:26:32.139498 | 2026-05-20 10:16:05.691233 |
| MPC_primarydb | mpc_orbits | 1548636 | 2026-05-20 10:06:09.87287 | 2026-05-20 10:16:05.832296 |
| MPC_mpcsbndb | mpc_orbits | 1548636 | 2026-05-20 10:06:09.87287 | 2026-05-20 10:16:07.509632 |
| SBN_to_AWS | mpc_orbits | 1548636 | 2026-05-20 10:06:09.87287 | 2026-05-20 10:16:07.768864 |
| MPC_primarydb | numbered_identifications | 887800 | 2026-03-24 19:55:09.966554 | 2026-05-20 10:16:10.230734 |
| MPC_mpcsbndb | numbered_identifications | 887800 | 2026-03-24 19:55:09.966554 | 2026-05-20 10:16:10.608271 |
| SBN_to_AWS | numbered_identifications | 887800 | 2026-03-24 19:55:09.966554 | 2026-05-20 10:16:10.739076 |
| MPC_primarydb | neocp_els | 14 | 2026-05-20 10:04:32.379754 | 2026-05-20 10:16:11.031396 |
| MPC_mpcsbndb | neocp_els | 14 | 2026-05-20 10:04:32.379754 | 2026-05-20 10:16:11.13663 |
| SBN_to_AWS | neocp_els | 14 | 2026-05-20 10:04:32.379754 | 2026-05-20 10:16:11.218759 |
| MPC_primarydb | neocp_events | 324307 | 2026-05-20 10:04:32.67542 | 2026-05-20 10:16:11.308415 |
| MPC_mpcsbndb | neocp_events | 324307 | 2026-05-20 10:04:32.67542 | 2026-05-20 10:16:11.510243 |
| SBN_to_AWS | neocp_events | 324307 | 2026-05-20 10:04:32.67542 | 2026-05-20 10:16:11.622717 |
| MPC_primarydb | neocp_obs | 261 | 2026-05-20 10:04:32.303569 | 2026-05-20 10:16:11.771271 |
| MPC_mpcsbndb | neocp_obs | 261 | 2026-05-20 10:04:32.303569 | 2026-05-20 10:16:11.877241 |
| SBN_to_AWS | neocp_obs | 261 | 2026-05-20 10:04:32.303569 | 2026-05-20 10:16:11.960274 |
| MPC_primarydb | neocp_obs_archive | 811842 | 2026-05-20 10:04:32.338235 | 2026-05-20 10:16:12.053696 |
| MPC_mpcsbndb | neocp_obs_archive | 811842 | 2026-05-20 10:04:32.338235 | 2026-05-20 10:16:12.311013 |
| SBN_to_AWS | neocp_obs_archive | 811842 | 2026-05-20 10:04:32.338235 | 2026-05-20 10:16:12.441314 |
| MPC_primarydb | neocp_prev_des | 72473 | 2026-05-20 07:37:33.130662 | 2026-05-20 10:16:12.673568 |
| MPC_mpcsbndb | neocp_prev_des | 72473 | 2026-05-20 07:37:33.130662 | 2026-05-20 10:16:12.816853 |
| SBN_to_AWS | neocp_prev_des | 72473 | 2026-05-20 07:37:33.130662 | 2026-05-20 10:16:12.914217 |
| MPC_primarydb | neocp_var | 39297 | 2026-05-20 10:04:32.469598 | 2026-05-20 10:16:13.030778 |
| MPC_mpcsbndb | neocp_var | 39297 | 2026-05-20 10:04:32.469598 | 2026-05-20 10:16:13.177377 |
| SBN_to_AWS | neocp_var | 39297 | 2026-05-20 10:04:32.469598 | 2026-05-20 10:16:13.275002 |
| MPC_primarydb | obscodes | 2702 | 2026-05-15 19:49:43.167881 | 2026-05-20 10:16:13.438322 |
| MPC_mpcsbndb | obscodes | 2702 | 2026-05-15 19:49:43.167881 | 2026-05-20 10:16:13.560672 |
| SBN_to_AWS | obscodes | 2702 | 2026-05-15 19:49:43.167881 | 2026-05-20 10:16:13.643731 |
| MPC_primarydb | primary_objects | 1583747 | 2026-05-20 04:19:20.939383 | 2026-05-20 10:16:13.734549 |
| MPC_mpcsbndb | primary_objects | 1583747 | 2026-05-20 04:19:20.939383 | 2026-05-20 10:16:14.236921 |
| SBN_to_AWS | primary_objects | 1583747 | 2026-05-20 04:19:20.939383 | 2026-05-20 10:16:14.41722 |
| MPC_primarydb | obs_alterations_corrections | 0 | 2026-05-20 10:16:16.031109 | |
| MPC_mpcsbndb | obs_alterations_corrections | 0 | 2026-05-20 10:16:16.13674 | |
| SBN_to_AWS | obs_alterations_corrections | 0 | 2026-05-20 10:16:16.218554 | |
| MPC_primarydb | obs_alterations_deletions | 1490128 | 2026-05-20 09:34:00.758119 | 2026-05-20 10:16:16.304384 |
| MPC_mpcsbndb | obs_alterations_deletions | 1490128 | 2026-05-20 09:34:00.758119 | 2026-05-20 10:16:16.824512 |
| SBN_to_AWS | obs_alterations_deletions | 1490128 | 2026-05-20 09:34:00.758119 | 2026-05-20 10:16:16.958495 |
| MPC_primarydb | obs_alterations_redesignations | 5083 | 2026-04-07 06:22:54.863572 | 2026-05-20 10:16:17.212087 |
| MPC_mpcsbndb | obs_alterations_redesignations | 5083 | 2026-04-07 06:22:54.863572 | 2026-05-20 10:16:17.323063 |
| SBN_to_AWS | obs_alterations_redesignations | 5083 | 2026-04-07 06:22:54.863572 | 2026-05-20 10:16:17.407076 |
| MPC_primarydb | obs_alterations_unassociations | 580242 | 2026-05-20 09:09:22.565182 | 2026-05-20 10:16:17.498968 |
| MPC_mpcsbndb | obs_alterations_unassociations | 580242 | 2026-05-20 09:09:22.565182 | 2026-05-20 10:16:17.794781 |
| SBN_to_AWS | obs_alterations_unassociations | 580242 | 2026-05-20 09:09:22.565182 | 2026-05-20 10:16:17.915231 |