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-10-01 21: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 | 5213 | 2025-08-13 22:56:38 | 2025-08-13 22:56:38 |
comet_orbits | 10675 | 2014-02-10 15:54:12 | 2025-09-30 19:01:02 |
identifications | 208447 | 2025-10-01 13:00:23 | 2025-10-01 13:00:23 |
isolated_tracklets | 49209819 | 2025-10-01 21:38:07 | 2025-10-01 21:38:07 |
mp_discoverers | 1969147 | 2025-06-18 21:18:06 | 2025-06-18 21:18:06 |
numbered_comet_identifications | 1098 | 2025-09-08 16:50:25 | 2025-09-08 16:50:25 |
numbered_identifications | 1287478 | 2025-09-08 13:59:53 | 2025-09-08 13:59:53 |
numbered_mps | 847427 | 2011-10-27 01:46:47 | 2025-09-29 16:57:11 |
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 | 492644331 | 2025-10-01 21:32:05 | 2025-10-01 21:32:05 |
orbit_uncertainties | 787193 | 2019-06-03 12:14:45 | 2022-06-02 16:46:34 |
orbits | 1481699 | 2025-10-01 21:32:08 | 2025-10-01 21:32:08 |
radar_observations | 1507 | 2024-12-04 04:59:18 | 2024-12-04 04:59:18 |
Table | Count | Created_at | Updated_at |
neocp_els | 102 | 2025-10-01 06:00:51.529011 | 2025-10-01 21:48:20.111073 |
neocp_events | 290502 | 2025-10-01 21:48:20.355056 | 2025-10-01 21:48:20.355056 |
neocp_obs_archive | 732870 | 2025-10-01 21:48:20.06975 | 2025-10-01 21:48:20.06975 |
neocp_obs | 1299 | 2025-10-01 21:48:20.028963 | 2025-10-01 21:48:20.028963 |
neocp_prev_des | 68303 | 2025-10-01 21:41:48.813539 | 2025-10-01 21:41:48.813539 |
neocp_var | 194195 | 2025-10-01 21:48:20.201893 | 2025-10-01 21:48:20.201893 |
current_identifications | 1991896 | 2025-10-01 21:30:48.685894 | 2025-10-01 21:31:45.486651 |
numbered_identifications | 848253 | 2025-09-18 20:26:39.638099 | 2025-09-18 20:26:39.638099 |
primary_objects | 1509167 | 2025-10-01 21:30:48.6265 | 2025-10-01 21:30:48.6265 |
obs_sbn | 503330110 | 2025-09-30 14:31:18.070659-04 | 2025-10-01 17:47:29.307539-04 |
obs_alterations_deletions | 1376865 | 2025-10-01 15:39:10.08145 | 2025-10-01 15:39:10.08145 |
obs_alterations_redesignations | 4360 | 2025-09-26 14:20:47.258045 | 2025-09-26 14:20:47.258045 |
obs_alterations_unassociations | 467630 | 2025-10-01 17:55:57.955312 | 2025-10-01 17:55:57.955312 |
mpc_orbits | 1463454 | 2021-02-03 23:34:19.930262 | 2025-10-01 21:47:29.307539 |
minor_planet_names | 25808 | 2025-09-08 15:38:40.078114 | 2025-09-29 20:57:11.055096 |
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 | 503329857 | 2025-10-01 20:58:08.974689 | 2025-10-01 21:00:02.8135 |
MPC_mpcsbndb | obs_sbn | 503329888 | 2025-10-01 21:01:23.352122 | 2025-10-01 21:01:47.019763 |
SBN_to_AWS | obs_sbn | 503329891 | 2025-10-01 21:02:00.25 | 2025-10-01 21:02:05.756569 |
MPC_primarydb | current_identifications | 1991892 | 2025-10-01 20:38:57.663634 | 2025-10-01 21:14:47.147394 |
MPC_mpcsbndb | current_identifications | 1991892 | 2025-10-01 20:38:57.663634 | 2025-10-01 21:14:47.920411 |
SBN_to_AWS | current_identifications | 1991892 | 2025-10-01 20:38:57.663634 | 2025-10-01 21:14:48.156014 |
MPC_primarydb | minor_planet_names | 25808 | 2025-09-29 20:57:11.055096 | 2025-10-01 21:14:48.510606 |
MPC_mpcsbndb | minor_planet_names | 25808 | 2025-09-29 20:57:11.055096 | 2025-10-01 21:14:48.643778 |
SBN_to_AWS | minor_planet_names | 25808 | 2025-09-29 20:57:11.055096 | 2025-10-01 21:14:48.746041 |
MPC_primarydb | mpc_orbits | 1463450 | 2025-10-01 21:13:44.724086 | 2025-10-01 21:14:48.846876 |
MPC_mpcsbndb | mpc_orbits | 1463450 | 2025-10-01 21:13:44.724086 | 2025-10-01 21:14:49.622547 |
SBN_to_AWS | mpc_orbits | 1463450 | 2025-10-01 21:13:44.724086 | 2025-10-01 21:14:49.94206 |
MPC_primarydb | numbered_identifications | 848253 | 2025-09-18 20:26:39.638099 | 2025-10-01 21:14:52.382297 |
MPC_mpcsbndb | numbered_identifications | 848253 | 2025-09-18 20:26:39.638099 | 2025-10-01 21:14:52.700315 |
SBN_to_AWS | numbered_identifications | 848253 | 2025-09-18 20:26:39.638099 | 2025-10-01 21:14:52.828792 |
MPC_primarydb | neocp_els | 106 | 2025-10-01 21:12:47.08745 | 2025-10-01 21:14:52.973736 |
MPC_mpcsbndb | neocp_els | 106 | 2025-10-01 21:12:47.08745 | 2025-10-01 21:14:53.077796 |
SBN_to_AWS | neocp_els | 106 | 2025-10-01 21:12:47.08745 | 2025-10-01 21:14:53.161658 |
MPC_primarydb | neocp_events | 290483 | 2025-10-01 21:12:47.178913 | 2025-10-01 21:14:53.252568 |
MPC_mpcsbndb | neocp_events | 290483 | 2025-10-01 21:12:47.178913 | 2025-10-01 21:14:53.606654 |
SBN_to_AWS | neocp_events | 290483 | 2025-10-01 21:12:47.178913 | 2025-10-01 21:14:53.72013 |
MPC_primarydb | neocp_obs | 1406 | 2025-10-01 21:12:47.006152 | 2025-10-01 21:14:53.836285 |
MPC_mpcsbndb | neocp_obs | 1406 | 2025-10-01 21:12:47.006152 | 2025-10-01 21:14:53.93932 |
SBN_to_AWS | neocp_obs | 1406 | 2025-10-01 21:12:47.006152 | 2025-10-01 21:14:54.023736 |
MPC_primarydb | neocp_obs_archive | 732825 | 2025-10-01 21:12:47.034487 | 2025-10-01 21:14:54.11851 |
MPC_mpcsbndb | neocp_obs_archive | 732825 | 2025-10-01 21:12:47.034487 | 2025-10-01 21:14:54.379825 |
SBN_to_AWS | neocp_obs_archive | 732825 | 2025-10-01 21:12:47.034487 | 2025-10-01 21:14:54.50571 |
MPC_primarydb | neocp_prev_des | 68297 | 2025-10-01 19:17:02.31861 | 2025-10-01 21:14:54.645771 |
MPC_mpcsbndb | neocp_prev_des | 68297 | 2025-10-01 19:17:02.31861 | 2025-10-01 21:14:54.7884 |
SBN_to_AWS | neocp_prev_des | 68297 | 2025-10-01 19:17:02.31861 | 2025-10-01 21:14:54.887293 |
MPC_primarydb | neocp_var | 203655 | 2025-10-01 21:12:47.045571 | 2025-10-01 21:14:54.990222 |
MPC_mpcsbndb | neocp_var | 203655 | 2025-10-01 21:12:47.045571 | 2025-10-01 21:14:55.152212 |
SBN_to_AWS | neocp_var | 203655 | 2025-10-01 21:12:47.045571 | 2025-10-01 21:14:55.277615 |
MPC_primarydb | obscodes | 2649 | 2025-09-30 19:50:21.069372 | 2025-10-01 21:14:55.455046 |
MPC_mpcsbndb | obscodes | 2649 | 2025-09-30 19:50:21.069372 | 2025-10-01 21:14:55.605235 |
SBN_to_AWS | obscodes | 2649 | 2025-09-30 19:50:21.069372 | 2025-10-01 21:14:55.689964 |
MPC_primarydb | primary_objects | 1509163 | 2025-10-01 20:38:57.615469 | 2025-10-01 21:14:55.781465 |
MPC_mpcsbndb | primary_objects | 1509163 | 2025-10-01 20:38:57.615469 | 2025-10-01 21:14:56.704833 |
SBN_to_AWS | primary_objects | 1509163 | 2025-10-01 20:38:57.615469 | 2025-10-01 21:14:56.86065 |
MPC_primarydb | obs_alterations_corrections | 0 | 2025-10-01 21:14:57.495052 | |
MPC_mpcsbndb | obs_alterations_corrections | 0 | 2025-10-01 21:14:57.600746 | |
SBN_to_AWS | obs_alterations_corrections | 0 | 2025-10-01 21:14:57.684177 | |
MPC_primarydb | obs_alterations_deletions | 1376865 | 2025-10-01 15:39:10.08145 | 2025-10-01 21:14:57.770982 |
MPC_mpcsbndb | obs_alterations_deletions | 1376865 | 2025-10-01 15:39:10.08145 | 2025-10-01 21:14:59.134167 |
SBN_to_AWS | obs_alterations_deletions | 1376865 | 2025-10-01 15:39:10.08145 | 2025-10-01 21:14:59.262019 |
MPC_primarydb | obs_alterations_redesignations | 4360 | 2025-09-26 14:20:47.258045 | 2025-10-01 21:14:59.411536 |
MPC_mpcsbndb | obs_alterations_redesignations | 4360 | 2025-09-26 14:20:47.258045 | 2025-10-01 21:14:59.52684 |
SBN_to_AWS | obs_alterations_redesignations | 4360 | 2025-09-26 14:20:47.258045 | 2025-10-01 21:14:59.611865 |