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-03-12 05: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 | 12030 | 2021-10-19 05:20:25 | 2026-03-07 23:01:17 |
| identifications | 218003 | 2026-03-11 12:26:56 | 2026-03-11 12:26:56 |
| isolated_tracklets | 49825774 | 2026-03-12 05:28:14 | 2026-03-12 05:28:14 |
| 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 | 2026-03-05 21:21:22 | 2026-03-05 21:21:22 |
| 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 | 511993739 | 2026-03-12 00:49:34 | 2026-03-12 00:49:34 |
| orbit_uncertainties | 787193 | 2019-06-03 12:14:45 | 2022-06-02 16:46:34 |
| orbits | 1534693 | 2026-03-12 00:47:27 | 2026-03-12 01: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 | 63 | 2026-03-11 23:10:23.113646 | 2026-03-12 05:30:30.77165 |
| neocp_events | 314963 | 2026-03-12 05:30:30.994739 | 2026-03-12 05:30:30.994739 |
| neocp_obs_archive | 788761 | 2026-03-12 05:30:30.729438 | 2026-03-12 05:30:30.729438 |
| neocp_obs | 1268 | 2026-03-12 05:30:30.686712 | 2026-03-12 05:30:30.686712 |
| neocp_prev_des | 71412 | 2026-03-12 04:36:55.598934 | 2026-03-12 04:36:55.598934 |
| neocp_var | 115035 | 2026-03-12 05:30:30.860362 | 2026-03-12 05:30:30.860362 |
| current_identifications | 2047449 | 2026-03-12 04:36:20.847561 | 2026-03-12 04:36:20.847561 |
| numbered_identifications | 887935 | 2026-02-27 03:49:38.898045 | 2026-02-27 03:49:38.898045 |
| primary_objects | 1560091 | 2026-03-12 04:36:20.761817 | 2026-03-12 04:36:20.761817 |
| obs_sbn | 531370481 | 2026-03-12 01:28:40.504533-04 | 2026-03-12 01:29:08.13723-04 |
| obs_alterations_deletions | 1494591 | 2026-03-12 05:14:34.681171 | 2026-03-12 05:14:34.681171 |
| obs_alterations_redesignations | 4519 | 2026-03-11 20:59:36.169991 | 2026-03-11 20:59:36.169991 |
| obs_alterations_unassociations | 563620 | 2026-03-12 05:25:08.544138 | 2026-03-12 05:25:08.544138 |
| mpc_orbits | 1517122 | 2026-03-09 05:46:38.052553 | 2026-03-12 05:29:08.13723 |
| minor_planet_names | 25992 | 2011-10-27 06:38:13 | 2026-01-16 00:37:34.652007 |
| obscodes | 2684 | 2026-03-11 15:22:01.984382 | 2026-03-11 15:22:01.984382 |
| comet_names | 4364 | 2026-02-25 01:23:59.404633 | 2026-02-25 01:23:59.404633 |
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 | 531370451 | 2026-03-12 04:57:08.717415 | 2026-03-12 05:00:02.221987 |
| MPC_mpcsbndb | obs_sbn | 531370451 | 2026-03-12 04:57:08.717415 | 2026-03-12 05:00:14.179454 |
| SBN_to_AWS | obs_sbn | 531370451 | 2026-03-12 04:57:08.717415 | 2026-03-12 05:00:39.479273 |
| MPC_primarydb | current_identifications | 2047449 | 2026-03-12 04:36:20.847561 | 2026-03-12 05:10:18.215901 |
| MPC_mpcsbndb | current_identifications | 2047449 | 2026-03-12 04:36:20.847561 | 2026-03-12 05:10:20.586667 |
| SBN_to_AWS | current_identifications | 2047449 | 2026-03-12 04:36:20.847561 | 2026-03-12 05:10:20.823192 |
| MPC_primarydb | comet_names | 4364 | 2026-02-25 01:23:59.404633 | 2026-03-12 05:10:22.324121 |
| MPC_mpcsbndb | comet_names | 4364 | 2026-02-25 01:23:59.404633 | 2026-03-12 05:10:22.429123 |
| SBN_to_AWS | comet_names | 4364 | 2026-02-25 01:23:59.404633 | 2026-03-12 05:10:22.516533 |
| MPC_primarydb | minor_planet_names | 25992 | 2026-01-16 00:37:34.652007 | 2026-03-12 05:10:22.615172 |
| MPC_mpcsbndb | minor_planet_names | 25992 | 2026-01-16 00:37:34.652007 | 2026-03-12 05:10:22.821744 |
| SBN_to_AWS | minor_planet_names | 25992 | 2026-01-16 00:37:34.652007 | 2026-03-12 05:10:22.923635 |
| MPC_primarydb | mpc_orbits | 1517122 | 2026-03-12 05:08:03.856424 | 2026-03-12 05:10:23.064817 |
| MPC_mpcsbndb | mpc_orbits | 1517122 | 2026-03-12 05:08:03.856424 | 2026-03-12 05:10:25.108475 |
| SBN_to_AWS | mpc_orbits | 1517122 | 2026-03-12 05:08:03.856424 | 2026-03-12 05:10:25.443085 |
| MPC_primarydb | numbered_identifications | 887935 | 2026-02-27 03:49:38.898045 | 2026-03-12 05:10:30.117364 |
| MPC_mpcsbndb | numbered_identifications | 887935 | 2026-02-27 03:49:38.898045 | 2026-03-12 05:10:31.276229 |
| SBN_to_AWS | numbered_identifications | 887935 | 2026-02-27 03:49:38.898045 | 2026-03-12 05:10:31.410789 |
| MPC_primarydb | neocp_els | 63 | 2026-03-12 05:08:09.965819 | 2026-03-12 05:10:31.645254 |
| MPC_mpcsbndb | neocp_els | 63 | 2026-03-12 05:08:09.965819 | 2026-03-12 05:10:31.74818 |
| SBN_to_AWS | neocp_els | 63 | 2026-03-12 05:08:09.965819 | 2026-03-12 05:10:31.834971 |
| MPC_primarydb | neocp_events | 314957 | 2026-03-12 05:08:10.182086 | 2026-03-12 05:10:31.928432 |
| MPC_mpcsbndb | neocp_events | 314957 | 2026-03-12 05:08:10.182086 | 2026-03-12 05:10:32.200568 |
| SBN_to_AWS | neocp_events | 314957 | 2026-03-12 05:08:10.182086 | 2026-03-12 05:10:32.317363 |
| MPC_primarydb | neocp_obs | 1254 | 2026-03-12 05:08:09.883581 | 2026-03-12 05:10:32.463923 |
| MPC_mpcsbndb | neocp_obs | 1254 | 2026-03-12 05:08:09.883581 | 2026-03-12 05:10:32.567624 |
| SBN_to_AWS | neocp_obs | 1254 | 2026-03-12 05:08:09.883581 | 2026-03-12 05:10:32.654776 |
| MPC_primarydb | neocp_obs_archive | 788745 | 2026-03-12 05:08:09.924647 | 2026-03-12 05:10:32.749504 |
| MPC_mpcsbndb | neocp_obs_archive | 788745 | 2026-03-12 05:08:09.924647 | 2026-03-12 05:10:33.025929 |
| SBN_to_AWS | neocp_obs_archive | 788745 | 2026-03-12 05:08:09.924647 | 2026-03-12 05:10:33.150971 |
| MPC_primarydb | neocp_prev_des | 71412 | 2026-03-12 04:36:55.598934 | 2026-03-12 05:10:33.371537 |
| MPC_mpcsbndb | neocp_prev_des | 71412 | 2026-03-12 04:36:55.598934 | 2026-03-12 05:10:33.508931 |
| SBN_to_AWS | neocp_prev_des | 71412 | 2026-03-12 04:36:55.598934 | 2026-03-12 05:10:33.609901 |
| MPC_primarydb | neocp_var | 114822 | 2026-03-12 05:08:10.050095 | 2026-03-12 05:10:33.730359 |
| MPC_mpcsbndb | neocp_var | 114822 | 2026-03-12 05:08:10.050095 | 2026-03-12 05:10:33.904911 |
| SBN_to_AWS | neocp_var | 114822 | 2026-03-12 05:08:10.050095 | 2026-03-12 05:10:34.02263 |
| MPC_primarydb | obscodes | 2684 | 2026-03-11 15:22:01.984382 | 2026-03-12 05:10:34.280667 |
| MPC_mpcsbndb | obscodes | 2684 | 2026-03-11 15:22:01.984382 | 2026-03-12 05:10:34.426907 |
| SBN_to_AWS | obscodes | 2684 | 2026-03-11 15:22:01.984382 | 2026-03-12 05:10:34.514425 |
| MPC_primarydb | primary_objects | 1560091 | 2026-03-12 04:36:20.761817 | 2026-03-12 05:10:34.614222 |
| MPC_mpcsbndb | primary_objects | 1560091 | 2026-03-12 04:36:20.761817 | 2026-03-12 05:10:36.095038 |
| SBN_to_AWS | primary_objects | 1560091 | 2026-03-12 04:36:20.761817 | 2026-03-12 05:10:36.244384 |
| MPC_primarydb | obs_alterations_corrections | 0 | 2026-03-12 05:10:37.887206 | |
| MPC_mpcsbndb | obs_alterations_corrections | 0 | 2026-03-12 05:10:37.988712 | |
| SBN_to_AWS | obs_alterations_corrections | 0 | 2026-03-12 05:10:38.074428 | |
| MPC_primarydb | obs_alterations_deletions | 1494589 | 2026-03-12 03:57:53.525349 | 2026-03-12 05:10:38.163937 |
| MPC_mpcsbndb | obs_alterations_deletions | 1494589 | 2026-03-12 03:57:53.525349 | 2026-03-12 05:10:39.521823 |
| SBN_to_AWS | obs_alterations_deletions | 1494589 | 2026-03-12 03:57:53.525349 | 2026-03-12 05:10:39.656762 |
| MPC_primarydb | obs_alterations_redesignations | 4519 | 2026-03-11 20:59:36.169991 | 2026-03-12 05:10:39.892536 |
| MPC_mpcsbndb | obs_alterations_redesignations | 4519 | 2026-03-11 20:59:36.169991 | 2026-03-12 05:10:40.01535 |
| SBN_to_AWS | obs_alterations_redesignations | 4519 | 2026-03-11 20:59:36.169991 | 2026-03-12 05:10:40.102584 |
| MPC_primarydb | obs_alterations_unassociations | 563612 | 2026-03-12 04:18:43.909497 | 2026-03-12 05:10:40.199062 |
| MPC_mpcsbndb | obs_alterations_unassociations | 563612 | 2026-03-12 04:18:43.909497 | 2026-03-12 05:10:40.76126 |
| SBN_to_AWS | obs_alterations_unassociations | 563612 | 2026-03-12 04:18:43.909497 | 2026-03-12 05:10:40.884186 |