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-07-16 14: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 | 5206 | 2025-04-09 15:30:27 | 2025-04-09 15:30:27 |
comet_orbits | 10019 | 2025-07-14 19:21:27 | 2025-07-14 20:01:02 |
identifications | 206919 | 2025-07-14 12:28:23 | 2025-07-14 12:28:23 |
isolated_tracklets | 48743689 | 2025-07-16 14:18:11 | 2025-07-16 14:18:11 |
mp_discoverers | 1969147 | 2025-06-18 21:18:06 | 2025-06-18 21:18:06 |
numbered_comet_identifications | 1091 | 2025-06-24 16:23:23 | 2025-06-24 16:23:23 |
numbered_identifications | 1241797 | 2025-06-22 19:43:06 | 2025-06-22 19:43:06 |
numbered_mps | 811552 | 2018-05-31 01:04:45 | 2025-07-08 10:13:12 |
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 | 483003222 | 2025-07-16 13:46:35 | 2025-07-16 13:46:35 |
orbit_uncertainties | 787193 | 2019-06-03 12:14:45 | 2022-06-02 16:46:34 |
orbits | 1471511 | 2015-01-08 22:04:32 | 2025-07-16 14: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 | 32 | 2025-07-16 13:45:27.220571 | 2025-07-16 14:14:20.742894 |
neocp_events | 278228 | 2025-07-16 14:14:20.90933 | 2025-07-16 14:14:20.90933 |
neocp_obs_archive | 706763 | 2025-07-16 14:14:20.738578 | 2025-07-16 14:14:20.738578 |
neocp_obs | 278 | 2025-07-16 14:14:20.720329 | 2025-07-16 14:14:20.720329 |
neocp_prev_des | 66612 | 2025-07-16 13:47:08.026781 | 2025-07-16 13:47:08.026781 |
neocp_var | 63188 | 2025-07-16 14:14:20.774997 | 2025-07-16 14:14:20.774997 |
current_identifications | 1981077 | 2025-07-16 14:13:00.937704 | 2025-07-16 14:13:42.077907 |
numbered_identifications | 812353 | 2025-07-02 20:42:14.240799 | 2025-07-02 21:10:12.477554 |
primary_objects | 1499084 | 2025-07-16 14:13:00.905199 | 2025-07-16 14:13:00.905199 |
obs_sbn | 494462470 | 2025-07-16 10:09:03.512961-04 | 2025-07-16 10:18:09.944162-04 |
obs_alterations_deletions | 1359773 | 2025-07-16 11:36:28.170009 | 2025-07-16 11:36:28.170009 |
obs_alterations_redesignations | 4254 | 2025-05-21 17:18:42.682759 | 2025-06-13 07:10:58.084417 |
obs_alterations_unassociations | 420629 | 2025-07-16 00:10:05.546381 | 2025-07-16 00:10:05.546381 |
mpc_orbits | 1451910 | 2025-07-16 14:13:33.768177 | 2025-07-16 14:13:37.839589 |
minor_planet_names | 25565 | 2018-03-04 02:26:16 | 2025-07-08 14:12:32.989 |
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 | 494462464 | 2025-07-16 13:58:19.314469 | 2025-07-16 14:00:02.844204 |
MPC_mpcsbndb | obs_sbn | 494462464 | 2025-07-16 13:58:19.314469 | 2025-07-16 14:00:34.309906 |
SBN_to_AWS | obs_sbn | 494462464 | 2025-07-16 13:58:19.314469 | 2025-07-16 14:00:48.192775 |
MPC_primarydb | current_identifications | 1981077 | 2025-07-16 14:13:00.937704 | 2025-07-16 14:13:13.711429 |
MPC_mpcsbndb | current_identifications | 1981077 | 2025-07-16 14:13:00.937704 | 2025-07-16 14:13:14.402389 |
SBN_to_AWS | current_identifications | 1981077 | 2025-07-16 14:13:00.937704 | 2025-07-16 14:13:14.601088 |
MPC_primarydb | minor_planet_names | 25565 | 2025-07-08 14:12:32.989 | 2025-07-16 14:13:14.846425 |
MPC_mpcsbndb | minor_planet_names | 25565 | 2025-07-08 14:12:32.989 | 2025-07-16 14:13:14.998732 |
SBN_to_AWS | minor_planet_names | 25565 | 2025-07-08 14:12:32.989 | 2025-07-16 14:13:15.10677 |
MPC_primarydb | mpc_orbits | 1451909 | 2025-07-16 14:09:14.190533 | 2025-07-16 14:13:15.205804 |
MPC_mpcsbndb | mpc_orbits | 1451909 | 2025-07-16 14:09:14.190533 | 2025-07-16 14:13:16.109883 |
SBN_to_AWS | mpc_orbits | 1451909 | 2025-07-16 14:09:14.190533 | 2025-07-16 14:13:16.371167 |
MPC_primarydb | numbered_identifications | 812353 | 2025-07-02 21:10:12.477554 | 2025-07-16 14:13:16.674243 |
MPC_mpcsbndb | numbered_identifications | 812353 | 2025-07-02 21:10:12.477554 | 2025-07-16 14:13:17.138437 |
SBN_to_AWS | numbered_identifications | 812353 | 2025-07-02 21:10:12.477554 | 2025-07-16 14:13:17.2748 |
MPC_primarydb | neocp_els | 32 | 2025-07-16 13:45:27.220571 | 2025-07-16 14:13:17.412778 |
MPC_mpcsbndb | neocp_els | 32 | 2025-07-16 13:45:27.220571 | 2025-07-16 14:13:17.524743 |
SBN_to_AWS | neocp_els | 32 | 2025-07-16 13:45:27.220571 | 2025-07-16 14:13:17.615634 |
MPC_primarydb | neocp_events | 278227 | 2025-07-16 13:47:08.052203 | 2025-07-16 14:13:17.709845 |
MPC_mpcsbndb | neocp_events | 278227 | 2025-07-16 13:47:08.052203 | 2025-07-16 14:13:17.912255 |
SBN_to_AWS | neocp_events | 278227 | 2025-07-16 13:47:08.052203 | 2025-07-16 14:13:18.033346 |
MPC_primarydb | neocp_obs | 277 | 2025-07-16 13:45:27.151463 | 2025-07-16 14:13:18.146318 |
MPC_mpcsbndb | neocp_obs | 277 | 2025-07-16 13:45:27.151463 | 2025-07-16 14:13:18.255554 |
SBN_to_AWS | neocp_obs | 277 | 2025-07-16 13:45:27.151463 | 2025-07-16 14:13:18.346705 |
MPC_primarydb | neocp_obs_archive | 706762 | 2025-07-16 13:45:27.160236 | 2025-07-16 14:13:18.441061 |
MPC_mpcsbndb | neocp_obs_archive | 706762 | 2025-07-16 13:45:27.160236 | 2025-07-16 14:13:18.727446 |
SBN_to_AWS | neocp_obs_archive | 706762 | 2025-07-16 13:45:27.160236 | 2025-07-16 14:13:18.853814 |
MPC_primarydb | neocp_prev_des | 66612 | 2025-07-16 13:47:08.026781 | 2025-07-16 14:13:18.987019 |
MPC_mpcsbndb | neocp_prev_des | 66612 | 2025-07-16 13:47:08.026781 | 2025-07-16 14:13:19.134895 |
SBN_to_AWS | neocp_prev_des | 66612 | 2025-07-16 13:47:08.026781 | 2025-07-16 14:13:19.241464 |
MPC_primarydb | neocp_var | 63188 | 2025-07-16 13:45:27.169185 | 2025-07-16 14:13:19.342435 |
MPC_mpcsbndb | neocp_var | 63188 | 2025-07-16 13:45:27.169185 | 2025-07-16 14:13:19.492013 |
SBN_to_AWS | neocp_var | 63188 | 2025-07-16 13:45:27.169185 | 2025-07-16 14:13:19.607496 |
MPC_primarydb | obscodes | 2627 | 2025-07-15 13:53:07.724401 | 2025-07-16 14:13:19.708119 |
MPC_mpcsbndb | obscodes | 2627 | 2025-07-15 13:53:07.724401 | 2025-07-16 14:13:19.845384 |
SBN_to_AWS | obscodes | 2627 | 2025-07-15 13:53:07.724401 | 2025-07-16 14:13:19.937054 |
MPC_primarydb | primary_objects | 1499084 | 2025-07-16 14:13:00.905199 | 2025-07-16 14:13:20.074519 |
MPC_mpcsbndb | primary_objects | 1499084 | 2025-07-16 14:13:00.905199 | 2025-07-16 14:13:20.584351 |
SBN_to_AWS | primary_objects | 1499084 | 2025-07-16 14:13:00.905199 | 2025-07-16 14:13:20.748532 |
MPC_primarydb | obs_alterations_corrections | 0 | 2025-07-16 14:13:20.985056 | |
MPC_mpcsbndb | obs_alterations_corrections | 0 | 2025-07-16 14:13:21.093634 | |
SBN_to_AWS | obs_alterations_corrections | 0 | 2025-07-16 14:13:21.183528 | |
MPC_primarydb | obs_alterations_deletions | 1359773 | 2025-07-16 11:36:28.170009 | 2025-07-16 14:13:21.277723 |
MPC_mpcsbndb | obs_alterations_deletions | 1359773 | 2025-07-16 11:36:28.170009 | 2025-07-16 14:13:21.785008 |
SBN_to_AWS | obs_alterations_deletions | 1359773 | 2025-07-16 11:36:28.170009 | 2025-07-16 14:13:21.918664 |
MPC_primarydb | obs_alterations_redesignations | 4254 | 2025-06-13 07:10:58.084417 | 2025-07-16 14:13:22.065305 |
MPC_mpcsbndb | obs_alterations_redesignations | 4254 | 2025-06-13 07:10:58.084417 | 2025-07-16 14:13:22.178626 |
SBN_to_AWS | obs_alterations_redesignations | 4254 | 2025-06-13 07:10:58.084417 | 2025-07-16 14:13:22.269998 |