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-09-23 08: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 | 5227 | 2026-06-03 09:27:00 | 2026-06-03 09:27:00 |
| comet_orbits | 12831 | 2025-01-03 03:38:23 | 2026-09-21 14:01:02 |
| identifications | 223187 | 2026-07-14 12:33:56 | 2026-07-14 12:33:56 |
| isolated_tracklets | 50790663 | 2026-09-22 11:18:18 | 2026-09-22 11:18: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 | 2026-06-03 02:57:19 | 2026-09-08 14:26:32 |
| 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 | 524472923 | 2026-09-23 04:08:35 | 2026-09-23 04:08:35 |
| orbit_uncertainties | 787193 | 2019-06-03 12:14:45 | 2022-06-02 16:46:34 |
| orbits | 1581963 | 2026-09-23 04:08:51 | 2026-09-23 05: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 | 91 | 2026-09-19 14:32:07.56108 | 2026-09-23 08:29:32.13995 |
| neocp_events | 339990 | 2026-09-23 08:29:32.098285 | 2026-09-23 08:29:32.098285 |
| neocp_obs_archive | 840401 | 2026-09-23 08:29:32.094674 | 2026-09-23 08:29:32.094674 |
| neocp_obs | 1369 | 2026-09-23 08:29:32.053563 | 2026-09-23 08:29:32.053563 |
| neocp_prev_des | 74340 | 2026-09-23 07:07:15.735495 | 2026-09-23 07:07:15.735495 |
| neocp_var | 192074 | 2026-09-23 08:29:32.229361 | 2026-09-23 08:29:32.229361 |
| current_identifications | 2097513 | 2026-09-23 08:53:57.016751 | 2026-09-23 08:53:57.016751 |
| numbered_identifications | 896611 | 2026-06-02 22:27:20.380719 | 2026-06-03 16:22:06.978451 |
| primary_objects | 1607009 | 2026-09-23 08:53:56.996165 | 2026-09-23 08:53:56.996165 |
| obs_sbn | 554974688 | 2026-09-13 16:32:37.844845-04 | 2026-09-23 04:53:59.800682-04 |
| obs_alterations_deletions | 3453759 | 2026-09-22 18:29:22.020368 | 2026-09-22 18:29:22.020368 |
| obs_alterations_redesignations | 5218 | 2026-08-25 19:50:31.030107 | 2026-08-25 19:50:31.030107 |
| obs_alterations_unassociations | 606129 | 2026-09-23 02:11:19.719441 | 2026-09-23 02:11:19.719441 |
| mpc_orbits | 1572823 | 2026-09-23 08:53:38.415168 | 2026-09-23 08:53:48.977766 |
| minor_planet_names | 26688 | 2011-10-28 10:08:52 | 2026-09-08 18:26:32.060609 |
| obscodes | 2726 | 2026-09-18 23:14:07.818373 | 2026-09-18 23:14:07.818373 |
| comet_names | 4394 | 2026-09-18 13:50:23.180345 | 2026-09-18 13:50:23.180345 |
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 | 554974616 | 2026-09-23 07:59:19.646496 | 2026-09-23 08:00:02.096259 |
| MPC_mpcsbndb | obs_sbn | 554974616 | 2026-09-23 07:59:19.646496 | 2026-09-23 08:00:14.222992 |
| SBN_to_AWS | obs_sbn | 554974616 | 2026-09-23 07:59:19.646496 | 2026-09-23 08:00:54.324658 |
| MPC_primarydb | current_identifications | 2097486 | 2026-09-23 08:12:05.172864 | 2026-09-23 08:12:49.528231 |
| MPC_mpcsbndb | current_identifications | 2097486 | 2026-09-23 08:12:05.172864 | 2026-09-23 08:12:50.321732 |
| SBN_to_AWS | current_identifications | 2097486 | 2026-09-23 08:12:05.172864 | 2026-09-23 08:12:50.486152 |
| MPC_primarydb | comet_names | 4394 | 2026-09-18 13:50:23.180345 | 2026-09-23 08:12:51.274844 |
| MPC_mpcsbndb | comet_names | 4394 | 2026-09-18 13:50:23.180345 | 2026-09-23 08:12:51.389227 |
| SBN_to_AWS | comet_names | 4394 | 2026-09-18 13:50:23.180345 | 2026-09-23 08:12:51.482671 |
| MPC_primarydb | minor_planet_names | 26688 | 2026-09-08 18:26:32.060609 | 2026-09-23 08:12:51.585712 |
| MPC_mpcsbndb | minor_planet_names | 26688 | 2026-09-08 18:26:32.060609 | 2026-09-23 08:12:51.741558 |
| SBN_to_AWS | minor_planet_names | 26688 | 2026-09-08 18:26:32.060609 | 2026-09-23 08:12:51.859245 |
| MPC_primarydb | mpc_orbits | 1572796 | 2026-09-23 08:12:02.289613 | 2026-09-23 08:12:52.065411 |
| MPC_mpcsbndb | mpc_orbits | 1572796 | 2026-09-23 08:12:02.289613 | 2026-09-23 08:12:53.875148 |
| SBN_to_AWS | mpc_orbits | 1572796 | 2026-09-23 08:12:02.289613 | 2026-09-23 08:12:54.173189 |
| MPC_primarydb | numbered_identifications | 896611 | 2026-06-03 16:22:06.978451 | 2026-09-23 08:12:57.452783 |
| MPC_mpcsbndb | numbered_identifications | 896611 | 2026-06-03 16:22:06.978451 | 2026-09-23 08:12:57.750371 |
| SBN_to_AWS | numbered_identifications | 896611 | 2026-06-03 16:22:06.978451 | 2026-09-23 08:12:57.894693 |
| MPC_primarydb | neocp_els | 91 | 2026-09-23 08:03:26.036346 | 2026-09-23 08:12:58.197228 |
| MPC_mpcsbndb | neocp_els | 91 | 2026-09-23 08:03:26.036346 | 2026-09-23 08:12:58.3087 |
| SBN_to_AWS | neocp_els | 91 | 2026-09-23 08:03:26.036346 | 2026-09-23 08:12:58.400749 |
| MPC_primarydb | neocp_events | 339989 | 2026-09-23 08:03:25.995195 | 2026-09-23 08:12:58.498163 |
| MPC_mpcsbndb | neocp_events | 339989 | 2026-09-23 08:03:25.995195 | 2026-09-23 08:12:58.683331 |
| SBN_to_AWS | neocp_events | 339989 | 2026-09-23 08:03:25.995195 | 2026-09-23 08:12:58.811766 |
| MPC_primarydb | neocp_obs | 1366 | 2026-09-23 08:03:25.912978 | 2026-09-23 08:12:58.981643 |
| MPC_mpcsbndb | neocp_obs | 1366 | 2026-09-23 08:03:25.912978 | 2026-09-23 08:12:59.093503 |
| SBN_to_AWS | neocp_obs | 1366 | 2026-09-23 08:03:25.912978 | 2026-09-23 08:12:59.187247 |
| MPC_primarydb | neocp_obs_archive | 840398 | 2026-09-23 08:03:25.954185 | 2026-09-23 08:12:59.299558 |
| MPC_mpcsbndb | neocp_obs_archive | 840398 | 2026-09-23 08:03:25.954185 | 2026-09-23 08:12:59.511207 |
| SBN_to_AWS | neocp_obs_archive | 840398 | 2026-09-23 08:03:25.954185 | 2026-09-23 08:12:59.687837 |
| MPC_primarydb | neocp_prev_des | 74340 | 2026-09-23 07:07:15.735495 | 2026-09-23 08:12:59.951849 |
| MPC_mpcsbndb | neocp_prev_des | 74340 | 2026-09-23 07:07:15.735495 | 2026-09-23 08:13:00.097371 |
| SBN_to_AWS | neocp_prev_des | 74340 | 2026-09-23 07:07:15.735495 | 2026-09-23 08:13:00.208786 |
| MPC_primarydb | neocp_var | 192053 | 2026-09-23 08:03:26.127962 | 2026-09-23 08:13:00.335544 |
| MPC_mpcsbndb | neocp_var | 192053 | 2026-09-23 08:03:26.127962 | 2026-09-23 08:13:00.533779 |
| SBN_to_AWS | neocp_var | 192053 | 2026-09-23 08:03:26.127962 | 2026-09-23 08:13:00.654698 |
| MPC_primarydb | obscodes | 2726 | 2026-09-18 23:14:07.818373 | 2026-09-23 08:13:00.902582 |
| MPC_mpcsbndb | obscodes | 2726 | 2026-09-18 23:14:07.818373 | 2026-09-23 08:13:01.028508 |
| SBN_to_AWS | obscodes | 2726 | 2026-09-18 23:14:07.818373 | 2026-09-23 08:13:01.122889 |
| MPC_primarydb | primary_objects | 1606982 | 2026-09-23 08:12:05.110346 | 2026-09-23 08:13:01.223536 |
| MPC_mpcsbndb | primary_objects | 1606982 | 2026-09-23 08:12:05.110346 | 2026-09-23 08:13:01.610053 |
| SBN_to_AWS | primary_objects | 1606982 | 2026-09-23 08:12:05.110346 | 2026-09-23 08:13:01.829093 |
| MPC_primarydb | obs_alterations_corrections | 0 | 2026-09-23 08:13:03.527458 | |
| MPC_mpcsbndb | obs_alterations_corrections | 0 | 2026-09-23 08:13:03.639213 | |
| SBN_to_AWS | obs_alterations_corrections | 0 | 2026-09-23 08:13:03.730172 | |
| MPC_primarydb | obs_alterations_deletions | 3453759 | 2026-09-22 18:29:22.020368 | 2026-09-23 08:13:03.825518 |
| MPC_mpcsbndb | obs_alterations_deletions | 3453759 | 2026-09-22 18:29:22.020368 | 2026-09-23 08:13:04.500412 |
| SBN_to_AWS | obs_alterations_deletions | 3453759 | 2026-09-22 18:29:22.020368 | 2026-09-23 08:13:04.694113 |
| MPC_primarydb | obs_alterations_redesignations | 5218 | 2026-08-25 19:50:31.030107 | 2026-09-23 08:13:05.082158 |
| MPC_mpcsbndb | obs_alterations_redesignations | 5218 | 2026-08-25 19:50:31.030107 | 2026-09-23 08:13:05.198245 |
| SBN_to_AWS | obs_alterations_redesignations | 5218 | 2026-08-25 19:50:31.030107 | 2026-09-23 08:13:05.292523 |
| MPC_primarydb | obs_alterations_unassociations | 606129 | 2026-09-23 02:11:19.719441 | 2026-09-23 08:13:05.393324 |
| MPC_mpcsbndb | obs_alterations_unassociations | 606129 | 2026-09-23 02:11:19.719441 | 2026-09-23 08:13:05.632493 |
| SBN_to_AWS | obs_alterations_unassociations | 606129 | 2026-09-23 02:11:19.719441 | 2026-09-23 08:13:05.774847 |