Instructions (not for the faint of heart) for replicating the database are posted. Questions/issues related to replication should be directed to Andrei Mamoutkine.
2025-11-29 20:50: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 | 5214 | 2025-10-23 17:12:59 | 2025-10-23 17:12:59 |
| comet_orbits | 11198 | 2025-02-07 23:25:28 | 2025-11-26 00:01:10 |
| identifications | 210979 | 2025-11-29 12:20:01 | 2025-11-29 12:20:01 |
| isolated_tracklets | 49554491 | 2025-11-29 20:47:32 | 2025-11-29 20:47:32 |
| 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 | 1319125 | 2025-10-22 17:46:28 | 2025-10-22 17:46:28 |
| numbered_mps | 875150 | 2025-10-23 01:12:58 | 2025-11-19 17:03:38 |
| 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 | 502391102 | 2025-11-29 20:37:28 | 2025-11-29 20:37:28 |
| orbit_uncertainties | 787193 | 2019-06-03 12:14:45 | 2022-06-02 16:46:34 |
| orbits | 1495997 | 2025-11-29 20:37:32 | 2025-11-29 20:37:32 |
| radar_observations | 1507 | 2024-12-04 04:59:18 | 2024-12-04 04:59:18 |
| Table | Count | Created_at | Updated_at |
| neocp_els | 150 | 2025-11-29 08:36:26.360825 | 2025-11-29 20:50:43.679918 |
| neocp_events | 299361 | 2025-11-29 20:50:43.85246 | 2025-11-29 20:50:43.85246 |
| neocp_obs_archive | 753464 | 2025-11-29 20:50:43.673483 | 2025-11-29 20:50:43.673483 |
| neocp_obs | 1492 | 2025-11-29 20:50:43.659047 | 2025-11-29 20:50:43.659047 |
| neocp_prev_des | 69459 | 2025-11-29 20:37:46.311264 | 2025-11-29 20:37:46.311264 |
| neocp_var | 290885 | 2025-11-29 20:50:43.714672 | 2025-11-29 20:50:43.714672 |
| current_identifications | 2006183 | 2025-11-29 20:53:42.175336 | 2025-11-29 20:53:42.175336 |
| numbered_identifications | 875979 | 2025-10-20 21:02:31.305341 | 2025-10-20 21:02:31.305341 |
| primary_objects | 1522214 | 2025-11-29 20:53:42.148986 | 2025-11-29 20:53:42.148986 |
| obs_sbn | 514120168 | 2025-11-29 08:47:27.833052-05 | 2025-11-29 15:53:45.12592-05 |
| obs_alterations_deletions | 1387344 | 2025-11-29 13:28:10.333627 | 2025-11-29 13:28:10.333627 |
| obs_alterations_redesignations | 4426 | 2025-11-23 14:47:23.199793 | 2025-11-23 14:47:23.199793 |
| obs_alterations_unassociations | 526313 | 2025-11-29 20:32:35.679457 | 2025-11-29 20:32:35.679457 |
| mpc_orbits | 1478109 | 2025-11-29 20:53:23.642188 | 2025-11-29 20:53:31.966466 |
| minor_planet_names | 25881 | 2015-06-03 22:57:34 | 2025-11-19 22:03:16.504632 |
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 | 514088131 | 2025-11-29 20:00:01.250507 | 2025-11-29 20:00:02.058212 |
| MPC_mpcsbndb | obs_sbn | 514088328 | 2025-11-29 20:00:22.016471 | 2025-11-29 20:00:22.734352 |
| SBN_to_AWS | obs_sbn | 514088781 | 2025-11-29 20:01:06.973902 | 2025-11-29 20:01:09.058306 |
| MPC_primarydb | current_identifications | 2006161 | 2025-11-29 20:10:15.898133 | 2025-11-29 20:10:33.405618 |
| MPC_mpcsbndb | current_identifications | 2006161 | 2025-11-29 20:10:15.898133 | 2025-11-29 20:10:34.204135 |
| SBN_to_AWS | current_identifications | 2006161 | 2025-11-29 20:10:15.898133 | 2025-11-29 20:10:34.491859 |
| MPC_primarydb | minor_planet_names | 25881 | 2025-11-19 22:03:16.504632 | 2025-11-29 20:10:34.959026 |
| MPC_mpcsbndb | minor_planet_names | 25881 | 2025-11-19 22:03:16.504632 | 2025-11-29 20:10:35.129699 |
| SBN_to_AWS | minor_planet_names | 25881 | 2025-11-19 22:03:16.504632 | 2025-11-29 20:10:35.232642 |
| MPC_primarydb | mpc_orbits | 1478088 | 2025-11-29 20:10:35.206172 | 2025-11-29 20:10:35.333549 |
| MPC_mpcsbndb | mpc_orbits | 1478088 | 2025-11-29 20:10:37.051682 | 2025-11-29 20:10:38.525349 |
| SBN_to_AWS | mpc_orbits | 1478088 | 2025-11-29 20:10:36.950399 | 2025-11-29 20:10:39.017465 |
| MPC_primarydb | numbered_identifications | 875979 | 2025-10-20 21:02:31.305341 | 2025-11-29 20:10:41.995397 |
| MPC_mpcsbndb | numbered_identifications | 875979 | 2025-10-20 21:02:31.305341 | 2025-11-29 20:10:42.381345 |
| SBN_to_AWS | numbered_identifications | 875979 | 2025-10-20 21:02:31.305341 | 2025-11-29 20:10:42.526 |
| MPC_primarydb | neocp_els | 150 | 2025-11-29 20:07:24.730389 | 2025-11-29 20:10:42.674311 |
| MPC_mpcsbndb | neocp_els | 150 | 2025-11-29 20:07:24.730389 | 2025-11-29 20:10:42.774578 |
| SBN_to_AWS | neocp_els | 150 | 2025-11-29 20:07:24.730389 | 2025-11-29 20:10:42.856465 |
| MPC_primarydb | neocp_events | 299350 | 2025-11-29 20:07:24.891582 | 2025-11-29 20:10:42.944203 |
| MPC_mpcsbndb | neocp_events | 299350 | 2025-11-29 20:07:24.891582 | 2025-11-29 20:10:43.130926 |
| SBN_to_AWS | neocp_events | 299350 | 2025-11-29 20:07:24.891582 | 2025-11-29 20:10:43.25053 |
| MPC_primarydb | neocp_obs | 1482 | 2025-11-29 20:07:24.717268 | 2025-11-29 20:10:43.369726 |
| MPC_mpcsbndb | neocp_obs | 1482 | 2025-11-29 20:07:24.717268 | 2025-11-29 20:10:43.472122 |
| SBN_to_AWS | neocp_obs | 1482 | 2025-11-29 20:07:24.717268 | 2025-11-29 20:10:43.554498 |
| MPC_primarydb | neocp_obs_archive | 753434 | 2025-11-29 20:07:24.72704 | 2025-11-29 20:10:43.644223 |
| MPC_mpcsbndb | neocp_obs_archive | 753434 | 2025-11-29 20:07:24.72704 | 2025-11-29 20:10:43.888354 |
| SBN_to_AWS | neocp_obs_archive | 753434 | 2025-11-29 20:07:24.72704 | 2025-11-29 20:10:44.027291 |
| MPC_primarydb | neocp_prev_des | 69458 | 2025-11-29 19:04:27.817525 | 2025-11-29 20:10:44.184797 |
| MPC_mpcsbndb | neocp_prev_des | 69458 | 2025-11-29 19:04:27.817525 | 2025-11-29 20:10:44.329043 |
| SBN_to_AWS | neocp_prev_des | 69458 | 2025-11-29 19:04:27.817525 | 2025-11-29 20:10:44.430337 |
| MPC_primarydb | neocp_var | 291047 | 2025-11-29 20:07:24.765294 | 2025-11-29 20:10:44.529563 |
| MPC_mpcsbndb | neocp_var | 291047 | 2025-11-29 20:07:24.765294 | 2025-11-29 20:10:44.721691 |
| SBN_to_AWS | neocp_var | 291047 | 2025-11-29 20:07:24.765294 | 2025-11-29 20:10:44.858275 |
| MPC_primarydb | obscodes | 2662 | 2025-11-26 17:50:15.357439 | 2025-11-29 20:10:45.312489 |
| MPC_mpcsbndb | obscodes | 2662 | 2025-11-26 17:50:15.357439 | 2025-11-29 20:10:45.428993 |
| SBN_to_AWS | obscodes | 2662 | 2025-11-26 17:50:15.357439 | 2025-11-29 20:10:45.519794 |
| MPC_primarydb | primary_objects | 1522193 | 2025-11-29 20:09:37.505653 | 2025-11-29 20:10:45.612758 |
| MPC_mpcsbndb | primary_objects | 1522193 | 2025-11-29 20:09:37.505653 | 2025-11-29 20:10:46.314807 |
| SBN_to_AWS | primary_objects | 1522193 | 2025-11-29 20:09:37.505653 | 2025-11-29 20:10:46.546828 |
| MPC_primarydb | obs_alterations_corrections | 0 | 2025-11-29 20:10:47.262234 | |
| MPC_mpcsbndb | obs_alterations_corrections | 0 | 2025-11-29 20:10:47.362357 | |
| SBN_to_AWS | obs_alterations_corrections | 0 | 2025-11-29 20:10:47.443938 | |
| MPC_primarydb | obs_alterations_deletions | 1387344 | 2025-11-29 13:28:10.333627 | 2025-11-29 20:10:47.536932 |
| MPC_mpcsbndb | obs_alterations_deletions | 1387344 | 2025-11-29 13:28:10.333627 | 2025-11-29 20:10:48.049135 |
| SBN_to_AWS | obs_alterations_deletions | 1387344 | 2025-11-29 13:28:10.333627 | 2025-11-29 20:10:48.186294 |
| MPC_primarydb | obs_alterations_redesignations | 4426 | 2025-11-23 14:47:23.199793 | 2025-11-29 20:10:48.33601 |
| MPC_mpcsbndb | obs_alterations_redesignations | 4426 | 2025-11-23 14:47:23.199793 | 2025-11-29 20:10:48.443647 |
| SBN_to_AWS | obs_alterations_redesignations | 4426 | 2025-11-23 14:47:23.199793 | 2025-11-29 20:10:48.527249 |