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-07-16 04:40: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 | 12757 | 2014-02-10 15:54:13 | 2026-07-15 22:01:02 |
| identifications | 223187 | 2026-07-14 12:33:56 | 2026-07-14 12:33:56 |
| isolated_tracklets | 50778508 | 2026-07-16 04:38:18 | 2026-07-16 04:38:18 |
| 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-27 02:52:10 | 2026-07-09 11:09:42 |
| 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 | 524393983 | 2026-07-16 04:33:17 | 2026-07-16 04:33:17 |
| orbit_uncertainties | 787193 | 2019-06-03 12:14:45 | 2022-06-02 16:46:34 |
| orbits | 1568472 | 2026-07-16 04:33:21 | 2026-07-16 04:33:21 |
| radar_observations | 1507 | 2024-12-04 04:59:18 | 2024-12-04 04:59:18 |
| Table | Count | Created_at | Updated_at |
| neocp_els | 23 | 2026-07-15 07:19:02.953236 | 2026-07-16 04:33:33.10323 |
| neocp_events | 329104 | 2026-07-16 04:33:33.094466 | 2026-07-16 04:33:33.094466 |
| neocp_obs_archive | 821258 | 2026-07-16 04:33:33.051436 | 2026-07-16 04:33:33.051436 |
| neocp_obs | 231 | 2026-07-16 04:33:33.010769 | 2026-07-16 04:33:33.010769 |
| neocp_prev_des | 73077 | 2026-07-16 04:32:41.961127 | 2026-07-16 04:32:41.961127 |
| neocp_var | 59627 | 2026-07-16 04:33:33.193549 | 2026-07-16 04:33:33.193549 |
| current_identifications | 2083142 | 2026-07-16 04:32:00.071235 | 2026-07-16 04:32:53.289156 |
| numbered_identifications | 896611 | 2026-06-02 22:27:20.380719 | 2026-06-03 16:22:06.978451 |
| primary_objects | 1593224 | 2026-07-16 04:32:00.023234 | 2026-07-16 04:32:00.023234 |
| obs_sbn | 543382631 | 2026-07-16 00:46:08.555742-04 | 2026-07-16 00:47:09.553553-04 |
| obs_alterations_deletions | 1821851 | 2026-07-16 00:14:25.039644 | 2026-07-16 00:14:25.039644 |
| obs_alterations_redesignations | 5137 | 2026-06-25 20:30:09.644732 | 2026-06-25 20:30:09.644732 |
| obs_alterations_unassociations | 593860 | 2026-07-16 02:10:11.053345 | 2026-07-16 02:10:11.053345 |
| mpc_orbits | 1558583 | 2026-06-17 21:36:37.26148 | 2026-07-16 04:47:09.553553 |
| minor_planet_names | 26548 | 2026-07-09 15:11:02.596597 | 2026-07-09 15:11:02.596597 |
| obscodes | 2712 | 2019-05-25 00:11:28.243774 | 2026-07-16 03:40:54.246635 |
| comet_names | 4385 | 2026-07-15 21:30:14.120474 | 2026-07-15 21:30:14.120474 |
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 | 543382572 | 2026-07-16 03:48:13.898817 | 2026-07-16 04:00:02.015185 |
| MPC_mpcsbndb | obs_sbn | 543382567 | 2026-07-16 03:48:13.898817 | 2026-07-16 04:00:19.237158 |
| SBN_to_AWS | obs_sbn | 543382567 | 2026-07-16 03:48:13.898817 | 2026-07-16 04:00:55.482723 |
| MPC_primarydb | current_identifications | 2083141 | 2026-07-16 04:29:59.507396 | 2026-07-16 04:31:49.52226 |
| MPC_mpcsbndb | current_identifications | 2083141 | 2026-07-16 04:29:59.507396 | 2026-07-16 04:31:50.478733 |
| SBN_to_AWS | current_identifications | 2083141 | 2026-07-16 04:29:59.507396 | 2026-07-16 04:31:50.613374 |
| MPC_primarydb | comet_names | 4385 | 2026-07-15 21:30:14.120474 | 2026-07-16 04:31:51.326599 |
| MPC_mpcsbndb | comet_names | 4385 | 2026-07-15 21:30:14.120474 | 2026-07-16 04:31:51.415606 |
| SBN_to_AWS | comet_names | 4385 | 2026-07-15 21:30:14.120474 | 2026-07-16 04:31:51.483663 |
| MPC_primarydb | minor_planet_names | 26548 | 2026-07-09 15:11:02.596597 | 2026-07-16 04:31:51.56143 |
| MPC_mpcsbndb | minor_planet_names | 26548 | 2026-07-09 15:11:02.596597 | 2026-07-16 04:31:51.694634 |
| SBN_to_AWS | minor_planet_names | 26548 | 2026-07-09 15:11:02.596597 | 2026-07-16 04:31:51.776183 |
| MPC_primarydb | mpc_orbits | 1558582 | 2026-07-16 04:29:33.55102 | 2026-07-16 04:31:51.908533 |
| MPC_mpcsbndb | mpc_orbits | 1558582 | 2026-07-16 04:29:33.55102 | 2026-07-16 04:31:53.868343 |
| SBN_to_AWS | mpc_orbits | 1558582 | 2026-07-16 04:29:33.55102 | 2026-07-16 04:31:54.127857 |
| MPC_primarydb | numbered_identifications | 896611 | 2026-06-03 16:22:06.978451 | 2026-07-16 04:31:56.069969 |
| MPC_mpcsbndb | numbered_identifications | 896611 | 2026-06-03 16:22:06.978451 | 2026-07-16 04:31:56.366792 |
| SBN_to_AWS | numbered_identifications | 896611 | 2026-06-03 16:22:06.978451 | 2026-07-16 04:31:56.476443 |
| MPC_primarydb | neocp_els | 24 | 2026-07-16 03:33:28.281316 | 2026-07-16 04:31:56.755965 |
| MPC_mpcsbndb | neocp_els | 24 | 2026-07-16 03:33:28.281316 | 2026-07-16 04:31:56.843871 |
| SBN_to_AWS | neocp_els | 24 | 2026-07-16 03:33:28.281316 | 2026-07-16 04:31:56.911607 |
| MPC_primarydb | neocp_events | 329102 | 2026-07-16 04:29:48.040181 | 2026-07-16 04:31:56.985867 |
| MPC_mpcsbndb | neocp_events | 329102 | 2026-07-16 04:29:48.040181 | 2026-07-16 04:31:57.172837 |
| SBN_to_AWS | neocp_events | 329102 | 2026-07-16 04:29:48.040181 | 2026-07-16 04:31:57.267469 |
| MPC_primarydb | neocp_obs | 238 | 2026-07-16 03:33:28.207771 | 2026-07-16 04:31:57.399189 |
| MPC_mpcsbndb | neocp_obs | 238 | 2026-07-16 03:33:28.207771 | 2026-07-16 04:31:57.487485 |
| SBN_to_AWS | neocp_obs | 238 | 2026-07-16 03:33:28.207771 | 2026-07-16 04:31:57.555769 |
| MPC_primarydb | neocp_obs_archive | 821255 | 2026-07-16 03:33:28.214755 | 2026-07-16 04:31:57.631756 |
| MPC_mpcsbndb | neocp_obs_archive | 821255 | 2026-07-16 03:33:28.214755 | 2026-07-16 04:31:57.848777 |
| SBN_to_AWS | neocp_obs_archive | 821255 | 2026-07-16 03:33:28.214755 | 2026-07-16 04:31:57.953714 |
| MPC_primarydb | neocp_prev_des | 73076 | 2026-07-16 04:29:47.947764 | 2026-07-16 04:31:58.176255 |
| MPC_mpcsbndb | neocp_prev_des | 73076 | 2026-07-16 04:29:47.947764 | 2026-07-16 04:31:58.303819 |
| SBN_to_AWS | neocp_prev_des | 73076 | 2026-07-16 04:29:47.947764 | 2026-07-16 04:31:58.386364 |
| MPC_primarydb | neocp_var | 61627 | 2026-07-16 03:33:28.316398 | 2026-07-16 04:31:58.488951 |
| MPC_mpcsbndb | neocp_var | 61627 | 2026-07-16 03:33:28.316398 | 2026-07-16 04:31:58.621189 |
| SBN_to_AWS | neocp_var | 61627 | 2026-07-16 03:33:28.316398 | 2026-07-16 04:31:58.714151 |
| MPC_primarydb | obscodes | 2712 | 2026-07-16 03:40:54.246635 | 2026-07-16 04:31:58.884615 |
| MPC_mpcsbndb | obscodes | 2712 | 2026-07-16 03:40:54.246635 | 2026-07-16 04:31:58.988905 |
| SBN_to_AWS | obscodes | 2712 | 2026-07-16 03:40:54.246635 | 2026-07-16 04:31:59.057953 |
| MPC_primarydb | primary_objects | 1593223 | 2026-07-16 04:29:06.460913 | 2026-07-16 04:31:59.135229 |
| MPC_mpcsbndb | primary_objects | 1593223 | 2026-07-16 04:29:06.460913 | 2026-07-16 04:31:59.646536 |
| SBN_to_AWS | primary_objects | 1593223 | 2026-07-16 04:29:06.460913 | 2026-07-16 04:31:59.798377 |
| MPC_primarydb | obs_alterations_corrections | 0 | 2026-07-16 04:32:01.39432 | |
| MPC_mpcsbndb | obs_alterations_corrections | 0 | 2026-07-16 04:32:01.481803 | |
| SBN_to_AWS | obs_alterations_corrections | 0 | 2026-07-16 04:32:01.548899 | |
| MPC_primarydb | obs_alterations_deletions | 1821851 | 2026-07-16 00:14:25.039644 | 2026-07-16 04:32:01.620374 |
| MPC_mpcsbndb | obs_alterations_deletions | 1821851 | 2026-07-16 00:14:25.039644 | 2026-07-16 04:32:02.243372 |
| SBN_to_AWS | obs_alterations_deletions | 1821851 | 2026-07-16 00:14:25.039644 | 2026-07-16 04:32:02.357101 |
| MPC_primarydb | obs_alterations_redesignations | 5137 | 2026-06-25 20:30:09.644732 | 2026-07-16 04:32:02.579644 |
| MPC_mpcsbndb | obs_alterations_redesignations | 5137 | 2026-06-25 20:30:09.644732 | 2026-07-16 04:32:02.679542 |
| SBN_to_AWS | obs_alterations_redesignations | 5137 | 2026-06-25 20:30:09.644732 | 2026-07-16 04:32:02.748698 |
| MPC_primarydb | obs_alterations_unassociations | 593860 | 2026-07-16 02:10:11.053345 | 2026-07-16 04:32:02.825457 |
| MPC_mpcsbndb | obs_alterations_unassociations | 593860 | 2026-07-16 02:10:11.053345 | 2026-07-16 04:32:03.108744 |
| SBN_to_AWS | obs_alterations_unassociations | 593860 | 2026-07-16 02:10:11.053345 | 2026-07-16 04:32:03.212247 |