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-26 09: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 | 12721 | 2026-06-25 21:55:05 | 2026-06-25 21:55:05 |
| identifications | 222673 | 2026-06-25 12:19:02 | 2026-06-25 12:19:02 |
| isolated_tracklets | 50768730 | 2026-06-26 08:28:15 | 2026-06-26 08: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 | 524376817 | 2026-06-26 08:36:57 | 2026-06-26 08:36:57 |
| orbit_uncertainties | 787193 | 2019-06-03 12:14:45 | 2022-06-02 16:46:34 |
| orbits | 1568421 | 2026-06-26 08:37:05 | 2026-06-26 09: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 | 40 | 2026-06-26 08:32:50.191602 | 2026-06-26 08:47:49.926928 |
| neocp_events | 327828 | 2026-06-26 08:47:49.886011 | 2026-06-26 08:47:49.886011 |
| neocp_obs_archive | 818788 | 2026-06-26 08:47:49.844483 | 2026-06-26 08:47:49.844483 |
| neocp_obs | 370 | 2026-06-26 08:47:49.803824 | 2026-06-26 08:47:49.803824 |
| neocp_prev_des | 72920 | 2026-06-26 08:36:23.646806 | 2026-06-26 08:36:23.646806 |
| neocp_var | 91655 | 2026-06-26 08:47:50.018719 | 2026-06-26 08:47:50.018719 |
| current_identifications | 2082910 | 2026-06-26 08:56:31.222501 | 2026-06-26 08:56:59.461396 |
| numbered_identifications | 896611 | 2026-06-02 22:27:20.380719 | 2026-06-03 16:22:06.978451 |
| primary_objects | 1593184 | 2026-06-26 08:56:31.162143 | 2026-06-26 08:56:31.162143 |
| obs_sbn | 542078369 | 2026-06-25 09:52:04.216145-04 | 2026-06-26 04:56:33.893584-04 |
| obs_alterations_deletions | 1798503 | 2026-06-25 23:12:49.73527 | 2026-06-25 23:12:49.73527 |
| obs_alterations_redesignations | 5137 | 2026-06-25 20:30:09.644732 | 2026-06-25 20:30:09.644732 |
| obs_alterations_unassociations | 591513 | 2026-06-26 05:25:37.180333 | 2026-06-26 05:25:37.180333 |
| mpc_orbits | 1558510 | 2026-06-26 08:57:10.281012 | 2026-06-26 08:57:16.082059 |
| minor_planet_names | 26233 | 2026-01-12 18:42:40.541646 | 2026-06-09 20:34:29.81277 |
| obscodes | 2710 | 2026-06-25 19:43:39.507183 | 2026-06-25 19:43:39.507183 |
| 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 | 542077208 | 2026-06-26 07:55:36.292309 | 2026-06-26 08:00:02.429063 |
| MPC_mpcsbndb | obs_sbn | 542077208 | 2026-06-26 07:55:36.292309 | 2026-06-26 08:00:20.379952 |
| SBN_to_AWS | obs_sbn | 542077208 | 2026-06-26 07:55:36.292309 | 2026-06-26 08:00:44.271159 |
| MPC_primarydb | current_identifications | 2082907 | 2026-06-26 08:21:22.502434 | 2026-06-26 08:30:31.305925 |
| MPC_mpcsbndb | current_identifications | 2082907 | 2026-06-26 08:21:22.502434 | 2026-06-26 08:30:32.112955 |
| SBN_to_AWS | current_identifications | 2082907 | 2026-06-26 08:21:22.502434 | 2026-06-26 08:30:32.268275 |
| MPC_primarydb | comet_names | 4380 | 2026-06-15 20:56:35.141471 | 2026-06-26 08:30:33.020878 |
| MPC_mpcsbndb | comet_names | 4380 | 2026-06-15 20:56:35.141471 | 2026-06-26 08:30:33.126033 |
| SBN_to_AWS | comet_names | 4380 | 2026-06-15 20:56:35.141471 | 2026-06-26 08:30:33.209807 |
| MPC_primarydb | minor_planet_names | 26233 | 2026-06-09 20:34:29.81277 | 2026-06-26 08:30:33.30497 |
| MPC_mpcsbndb | minor_planet_names | 26233 | 2026-06-09 20:34:29.81277 | 2026-06-26 08:30:33.443671 |
| SBN_to_AWS | minor_planet_names | 26233 | 2026-06-09 20:34:29.81277 | 2026-06-26 08:30:33.540785 |
| MPC_primarydb | mpc_orbits | 1558507 | 2026-06-26 08:21:45.245639 | 2026-06-26 08:30:33.684776 |
| MPC_mpcsbndb | mpc_orbits | 1558507 | 2026-06-26 08:21:45.245639 | 2026-06-26 08:30:35.296753 |
| SBN_to_AWS | mpc_orbits | 1558507 | 2026-06-26 08:21:45.245639 | 2026-06-26 08:30:35.628771 |
| MPC_primarydb | numbered_identifications | 896611 | 2026-06-03 16:22:06.978451 | 2026-06-26 08:30:40.508328 |
| MPC_mpcsbndb | numbered_identifications | 896611 | 2026-06-03 16:22:06.978451 | 2026-06-26 08:30:40.778998 |
| SBN_to_AWS | numbered_identifications | 896611 | 2026-06-03 16:22:06.978451 | 2026-06-26 08:30:40.904596 |
| MPC_primarydb | neocp_els | 40 | 2026-06-26 08:06:54.166941 | 2026-06-26 08:30:41.198173 |
| MPC_mpcsbndb | neocp_els | 40 | 2026-06-26 08:06:54.166941 | 2026-06-26 08:30:41.301025 |
| SBN_to_AWS | neocp_els | 40 | 2026-06-26 08:06:54.166941 | 2026-06-26 08:30:41.383727 |
| MPC_primarydb | neocp_events | 327824 | 2026-06-26 08:06:54.126152 | 2026-06-26 08:30:41.475311 |
| MPC_mpcsbndb | neocp_events | 327824 | 2026-06-26 08:06:54.126152 | 2026-06-26 08:30:41.643802 |
| SBN_to_AWS | neocp_events | 327824 | 2026-06-26 08:06:54.126152 | 2026-06-26 08:30:41.753239 |
| MPC_primarydb | neocp_obs | 417 | 2026-06-26 08:06:54.04338 | 2026-06-26 08:30:41.911845 |
| MPC_mpcsbndb | neocp_obs | 417 | 2026-06-26 08:06:54.04338 | 2026-06-26 08:30:42.014989 |
| SBN_to_AWS | neocp_obs | 417 | 2026-06-26 08:06:54.04338 | 2026-06-26 08:30:42.098284 |
| MPC_primarydb | neocp_obs_archive | 818780 | 2026-06-26 08:06:54.084367 | 2026-06-26 08:30:42.191994 |
| MPC_mpcsbndb | neocp_obs_archive | 818780 | 2026-06-26 08:06:54.084367 | 2026-06-26 08:30:42.380966 |
| SBN_to_AWS | neocp_obs_archive | 818780 | 2026-06-26 08:06:54.084367 | 2026-06-26 08:30:42.506544 |
| MPC_primarydb | neocp_prev_des | 72919 | 2026-06-26 01:06:18.759731 | 2026-06-26 08:30:42.737389 |
| MPC_mpcsbndb | neocp_prev_des | 72919 | 2026-06-26 01:06:18.759731 | 2026-06-26 08:30:42.873132 |
| SBN_to_AWS | neocp_prev_des | 72919 | 2026-06-26 01:06:18.759731 | 2026-06-26 08:30:42.971832 |
| MPC_primarydb | neocp_var | 91655 | 2026-06-26 08:06:54.258139 | 2026-06-26 08:30:43.090035 |
| MPC_mpcsbndb | neocp_var | 91655 | 2026-06-26 08:06:54.258139 | 2026-06-26 08:30:43.240776 |
| SBN_to_AWS | neocp_var | 91655 | 2026-06-26 08:06:54.258139 | 2026-06-26 08:30:43.348455 |
| MPC_primarydb | obscodes | 2710 | 2026-06-25 19:43:39.507183 | 2026-06-26 08:30:43.522283 |
| MPC_mpcsbndb | obscodes | 2710 | 2026-06-25 19:43:39.507183 | 2026-06-26 08:30:43.639586 |
| SBN_to_AWS | obscodes | 2710 | 2026-06-25 19:43:39.507183 | 2026-06-26 08:30:43.724087 |
| MPC_primarydb | primary_objects | 1593181 | 2026-06-26 08:21:22.470063 | 2026-06-26 08:30:43.817094 |
| MPC_mpcsbndb | primary_objects | 1593181 | 2026-06-26 08:21:22.470063 | 2026-06-26 08:30:44.249752 |
| SBN_to_AWS | primary_objects | 1593181 | 2026-06-26 08:21:22.470063 | 2026-06-26 08:30:44.432452 |
| MPC_primarydb | obs_alterations_corrections | 0 | 2026-06-26 08:30:46.080954 | |
| MPC_mpcsbndb | obs_alterations_corrections | 0 | 2026-06-26 08:30:46.182705 | |
| SBN_to_AWS | obs_alterations_corrections | 0 | 2026-06-26 08:30:46.265347 | |
| MPC_primarydb | obs_alterations_deletions | 1798503 | 2026-06-25 23:12:49.73527 | 2026-06-26 08:30:46.352307 |
| MPC_mpcsbndb | obs_alterations_deletions | 1798503 | 2026-06-25 23:12:49.73527 | 2026-06-26 08:30:46.782059 |
| SBN_to_AWS | obs_alterations_deletions | 1798503 | 2026-06-25 23:12:49.73527 | 2026-06-26 08:30:46.912898 |
| MPC_primarydb | obs_alterations_redesignations | 5137 | 2026-06-25 20:30:09.644732 | 2026-06-26 08:30:47.303861 |
| MPC_mpcsbndb | obs_alterations_redesignations | 5137 | 2026-06-25 20:30:09.644732 | 2026-06-26 08:30:47.409721 |
| SBN_to_AWS | obs_alterations_redesignations | 5137 | 2026-06-25 20:30:09.644732 | 2026-06-26 08:30:47.494229 |
| MPC_primarydb | obs_alterations_unassociations | 591513 | 2026-06-26 05:25:37.180333 | 2026-06-26 08:30:47.587342 |
| MPC_mpcsbndb | obs_alterations_unassociations | 591513 | 2026-06-26 05:25:37.180333 | 2026-06-26 08:30:47.825209 |
| SBN_to_AWS | obs_alterations_unassociations | 591513 | 2026-06-26 05:25:37.180333 | 2026-06-26 08:30:47.948011 |