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-06-27 09: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 | 5227 | 2026-06-03 09:27:00 | 2026-06-03 09:27:00 |
| comet_orbits | 12721 | 2026-06-25 21:55:05 | 2026-06-25 21:55:05 |
| identifications | 222811 | 2026-06-26 12:22:20 | 2026-06-26 12:22:20 |
| isolated_tracklets | 50769220 | 2026-06-27 09:28:15 | 2026-06-27 09:28:15 |
| 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 | 2011-10-28 17:37:34 | 2026-06-05 18:04: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 | 524378103 | 2026-06-27 06:28:03 | 2026-06-27 06:28:03 |
| orbit_uncertainties | 787193 | 2019-06-03 12:14:45 | 2022-06-02 16:46:34 |
| orbits | 1568409 | 2026-06-27 06:12:26 | 2026-06-27 07: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 | 39 | 2026-06-25 10:42:05.272275 | 2026-06-27 09:42:28.826871 |
| neocp_events | 327919 | 2026-06-27 09:43:20.17726 | 2026-06-27 09:43:20.17726 |
| neocp_obs_archive | 818931 | 2026-06-27 09:42:28.771777 | 2026-06-27 09:42:28.771777 |
| neocp_obs | 387 | 2026-06-27 09:42:28.766385 | 2026-06-27 09:42:28.766385 |
| neocp_prev_des | 72929 | 2026-06-27 09:43:20.131592 | 2026-06-27 09:43:20.131592 |
| neocp_var | 89994 | 2026-06-27 09:42:28.86874 | 2026-06-27 09:42:28.86874 |
| current_identifications | 2082978 | 2026-06-27 09:42:38.954862 | 2026-06-27 09:43:30.185231 |
| numbered_identifications | 896611 | 2026-06-02 22:27:20.380719 | 2026-06-03 16:22:06.978451 |
| primary_objects | 1593157 | 2026-06-27 09:42:38.924846 | 2026-06-27 09:42:38.924846 |
| obs_sbn | 542140321 | 2026-06-25 07:26:43.928952-04 | 2026-06-27 05:43:31.188322-04 |
| obs_alterations_deletions | 1820041 | 2026-06-26 18:14:32.675166 | 2026-06-26 18:14:32.675166 |
| obs_alterations_redesignations | 5137 | 2026-06-25 20:30:09.644732 | 2026-06-25 20:30:09.644732 |
| obs_alterations_unassociations | 591581 | 2026-06-27 09:32:28.685215 | 2026-06-27 09:32:28.685215 |
| mpc_orbits | 1558485 | 2026-06-27 09:43:03.798806 | 2026-06-27 09:43:04.070977 |
| minor_planet_names | 26233 | 2026-01-12 18:42:40.541646 | 2026-06-09 20:34:29.81277 |
| obscodes | 2710 | 2019-05-25 00:11:28.713477 | 2026-06-27 01:35:59.390103 |
| comet_names | 4380 | 2026-06-15 20:56:35.141471 | 2026-06-15 20:56:35.141471 |
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 | 542140267 | 2026-06-27 08:26:27.695582 | 2026-06-27 09:00:02.600919 |
| MPC_mpcsbndb | obs_sbn | 542140267 | 2026-06-27 08:26:27.695582 | 2026-06-27 09:00:23.892425 |
| SBN_to_AWS | obs_sbn | 542140267 | 2026-06-27 08:26:27.695582 | 2026-06-27 09:00:48.841029 |
| MPC_primarydb | current_identifications | 2082974 | 2026-06-27 07:41:53.41235 | 2026-06-27 09:30:48.685607 |
| MPC_mpcsbndb | current_identifications | 2082974 | 2026-06-27 07:41:53.41235 | 2026-06-27 09:30:49.734094 |
| SBN_to_AWS | current_identifications | 2082974 | 2026-06-27 07:41:53.41235 | 2026-06-27 09:30:49.88849 |
| MPC_primarydb | comet_names | 4380 | 2026-06-15 20:56:35.141471 | 2026-06-27 09:30:50.636057 |
| MPC_mpcsbndb | comet_names | 4380 | 2026-06-15 20:56:35.141471 | 2026-06-27 09:30:50.74328 |
| SBN_to_AWS | comet_names | 4380 | 2026-06-15 20:56:35.141471 | 2026-06-27 09:30:50.825388 |
| MPC_primarydb | minor_planet_names | 26233 | 2026-06-09 20:34:29.81277 | 2026-06-27 09:30:50.918501 |
| MPC_mpcsbndb | minor_planet_names | 26233 | 2026-06-09 20:34:29.81277 | 2026-06-27 09:30:51.069505 |
| SBN_to_AWS | minor_planet_names | 26233 | 2026-06-09 20:34:29.81277 | 2026-06-27 09:30:51.164689 |
| MPC_primarydb | mpc_orbits | 1558481 | 2026-06-27 09:16:27.144655 | 2026-06-27 09:30:51.305811 |
| MPC_mpcsbndb | mpc_orbits | 1558481 | 2026-06-27 09:16:27.144655 | 2026-06-27 09:30:52.995047 |
| SBN_to_AWS | mpc_orbits | 1558481 | 2026-06-27 09:16:27.144655 | 2026-06-27 09:30:53.246534 |
| MPC_primarydb | numbered_identifications | 896611 | 2026-06-03 16:22:06.978451 | 2026-06-27 09:30:57.218414 |
| MPC_mpcsbndb | numbered_identifications | 896611 | 2026-06-03 16:22:06.978451 | 2026-06-27 09:30:57.565131 |
| SBN_to_AWS | numbered_identifications | 896611 | 2026-06-03 16:22:06.978451 | 2026-06-27 09:30:57.689103 |
| MPC_primarydb | neocp_els | 40 | 2026-06-27 09:12:28.901324 | 2026-06-27 09:30:57.979569 |
| MPC_mpcsbndb | neocp_els | 40 | 2026-06-27 09:12:28.901324 | 2026-06-27 09:30:58.081192 |
| SBN_to_AWS | neocp_els | 40 | 2026-06-27 09:12:28.901324 | 2026-06-27 09:30:58.162417 |
| MPC_primarydb | neocp_events | 327915 | 2026-06-27 09:12:28.8925 | 2026-06-27 09:30:58.251358 |
| MPC_mpcsbndb | neocp_events | 327915 | 2026-06-27 09:12:28.8925 | 2026-06-27 09:30:58.446575 |
| SBN_to_AWS | neocp_events | 327915 | 2026-06-27 09:12:28.8925 | 2026-06-27 09:30:58.557049 |
| MPC_primarydb | neocp_obs | 397 | 2026-06-27 09:12:28.881797 | 2026-06-27 09:30:58.707155 |
| MPC_mpcsbndb | neocp_obs | 397 | 2026-06-27 09:12:28.881797 | 2026-06-27 09:30:58.808811 |
| SBN_to_AWS | neocp_obs | 397 | 2026-06-27 09:12:28.881797 | 2026-06-27 09:30:58.890316 |
| MPC_primarydb | neocp_obs_archive | 818921 | 2026-06-27 09:12:28.888155 | 2026-06-27 09:30:58.982114 |
| MPC_mpcsbndb | neocp_obs_archive | 818921 | 2026-06-27 09:12:28.888155 | 2026-06-27 09:30:59.229721 |
| SBN_to_AWS | neocp_obs_archive | 818921 | 2026-06-27 09:12:28.888155 | 2026-06-27 09:30:59.352744 |
| MPC_primarydb | neocp_prev_des | 72928 | 2026-06-27 06:27:25.058904 | 2026-06-27 09:30:59.58627 |
| MPC_mpcsbndb | neocp_prev_des | 72928 | 2026-06-27 06:27:25.058904 | 2026-06-27 09:30:59.72523 |
| SBN_to_AWS | neocp_prev_des | 72928 | 2026-06-27 06:27:25.058904 | 2026-06-27 09:30:59.820576 |
| MPC_primarydb | neocp_var | 91994 | 2026-06-27 09:12:28.931115 | 2026-06-27 09:30:59.937043 |
| MPC_mpcsbndb | neocp_var | 91994 | 2026-06-27 09:12:28.931115 | 2026-06-27 09:31:00.08917 |
| SBN_to_AWS | neocp_var | 91994 | 2026-06-27 09:12:28.931115 | 2026-06-27 09:31:00.1944 |
| MPC_primarydb | obscodes | 2710 | 2026-06-27 01:35:59.390103 | 2026-06-27 09:31:00.353755 |
| MPC_mpcsbndb | obscodes | 2710 | 2026-06-27 01:35:59.390103 | 2026-06-27 09:31:00.468327 |
| SBN_to_AWS | obscodes | 2710 | 2026-06-27 01:35:59.390103 | 2026-06-27 09:31:00.550192 |
| MPC_primarydb | primary_objects | 1593153 | 2026-06-27 07:41:25.239039 | 2026-06-27 09:31:00.641121 |
| MPC_mpcsbndb | primary_objects | 1593153 | 2026-06-27 07:41:25.239039 | 2026-06-27 09:31:01.108469 |
| SBN_to_AWS | primary_objects | 1593153 | 2026-06-27 07:41:25.239039 | 2026-06-27 09:31:01.283343 |
| MPC_primarydb | obs_alterations_corrections | 0 | 2026-06-27 09:31:02.912465 | |
| MPC_mpcsbndb | obs_alterations_corrections | 0 | 2026-06-27 09:31:03.014522 | |
| SBN_to_AWS | obs_alterations_corrections | 0 | 2026-06-27 09:31:03.09536 | |
| MPC_primarydb | obs_alterations_deletions | 1820041 | 2026-06-26 18:14:32.675166 | 2026-06-27 09:31:03.180086 |
| MPC_mpcsbndb | obs_alterations_deletions | 1820041 | 2026-06-26 18:14:32.675166 | 2026-06-27 09:31:03.820944 |
| SBN_to_AWS | obs_alterations_deletions | 1820041 | 2026-06-26 18:14:32.675166 | 2026-06-27 09:31:03.962949 |
| MPC_primarydb | obs_alterations_redesignations | 5137 | 2026-06-25 20:30:09.644732 | 2026-06-27 09:31:04.196994 |
| MPC_mpcsbndb | obs_alterations_redesignations | 5137 | 2026-06-25 20:30:09.644732 | 2026-06-27 09:31:04.305748 |
| SBN_to_AWS | obs_alterations_redesignations | 5137 | 2026-06-25 20:30:09.644732 | 2026-06-27 09:31:04.388228 |
| MPC_primarydb | obs_alterations_unassociations | 591576 | 2026-06-27 06:16:04.931148 | 2026-06-27 09:31:04.478809 |
| MPC_mpcsbndb | obs_alterations_unassociations | 591576 | 2026-06-27 06:16:04.931148 | 2026-06-27 09:31:04.778355 |
| SBN_to_AWS | obs_alterations_unassociations | 591576 | 2026-06-27 06:16:04.931148 | 2026-06-27 09:31:04.896257 |