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-21 21: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-21 17:48:38 | 2025-07-21 18:01:02 |
identifications | 206919 | 2025-07-14 12:28:23 | 2025-07-14 12:28:23 |
isolated_tracklets | 48751936 | 2025-07-21 21:28:42 | 2025-07-21 21:28:42 |
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 | 483007012 | 2025-07-21 17:48:34 | 2025-07-21 17:48:34 |
orbit_uncertainties | 787193 | 2019-06-03 12:14:45 | 2022-06-02 16:46:34 |
orbits | 1471588 | 2018-01-25 20:30:17 | 2025-07-21 15: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 | 46 | 2025-07-21 06:25:12.865452 | 2025-07-21 21:06:21.625641 |
neocp_events | 278687 | 2025-07-21 21:06:21.807095 | 2025-07-21 21:06:21.807095 |
neocp_obs_archive | 707885 | 2025-07-21 21:06:21.622397 | 2025-07-21 21:06:21.622397 |
neocp_obs | 366 | 2025-07-21 21:06:21.614395 | 2025-07-21 21:06:21.614395 |
neocp_prev_des | 66661 | 2025-07-21 20:24:05.481941 | 2025-07-21 20:24:05.481941 |
neocp_var | 90076 | 2025-07-21 21:06:21.667052 | 2025-07-21 21:06:21.667052 |
current_identifications | 1981152 | 2025-07-21 16:20:00.498264 | 2025-07-21 16:20:00.498264 |
numbered_identifications | 812353 | 2025-07-02 20:42:14.240799 | 2025-07-02 21:10:12.477554 |
primary_objects | 1499159 | 2025-07-21 16:20:00.47158 | 2025-07-21 16:20:00.47158 |
obs_sbn | 494762746 | 2025-07-21 17:11:04.652684-04 | 2025-07-21 17:18:31.568784-04 |
obs_alterations_deletions | 1359951 | 2025-07-21 17:46:15.217605 | 2025-07-21 17:46:15.217605 |
obs_alterations_redesignations | 4254 | 2025-05-21 17:18:42.682759 | 2025-06-13 07:10:58.084417 |
obs_alterations_unassociations | 421021 | 2025-07-21 17:46:34.538737 | 2025-07-21 17:46:34.538737 |
mpc_orbits | 1452022 | 2025-07-21 21:12:54.05527 | 2025-07-21 21:12:54.05527 |
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 | 494762681 | 2025-07-21 20:25:34.636211 | 2025-07-21 21:00:02.894857 |
MPC_mpcsbndb | obs_sbn | 494762681 | 2025-07-21 20:25:34.636211 | 2025-07-21 21:00:21.728263 |
SBN_to_AWS | obs_sbn | 494762687 | 2025-07-21 21:00:24.550146 | 2025-07-21 21:00:34.362556 |
MPC_primarydb | current_identifications | 1981150 | 2025-07-21 16:20:00.498264 | 2025-07-21 21:13:05.419722 |
MPC_mpcsbndb | current_identifications | 1981150 | 2025-07-21 16:20:00.498264 | 2025-07-21 21:13:06.070893 |
SBN_to_AWS | current_identifications | 1981150 | 2025-07-21 16:20:00.498264 | 2025-07-21 21:13:06.253065 |
MPC_primarydb | minor_planet_names | 25565 | 2025-07-08 14:12:32.989 | 2025-07-21 21:13:06.458114 |
MPC_mpcsbndb | minor_planet_names | 25565 | 2025-07-08 14:12:32.989 | 2025-07-21 21:13:06.614787 |
SBN_to_AWS | minor_planet_names | 25565 | 2025-07-08 14:12:32.989 | 2025-07-21 21:13:06.713383 |
MPC_primarydb | mpc_orbits | 1452022 | 2025-07-21 21:12:54.05527 | 2025-07-21 21:13:06.806878 |
MPC_mpcsbndb | mpc_orbits | 1452022 | 2025-07-21 21:12:54.05527 | 2025-07-21 21:13:07.756454 |
SBN_to_AWS | mpc_orbits | 1452022 | 2025-07-21 21:12:54.05527 | 2025-07-21 21:13:07.943034 |
MPC_primarydb | numbered_identifications | 812353 | 2025-07-02 21:10:12.477554 | 2025-07-21 21:13:08.228956 |
MPC_mpcsbndb | numbered_identifications | 812353 | 2025-07-02 21:10:12.477554 | 2025-07-21 21:13:08.567162 |
SBN_to_AWS | numbered_identifications | 812353 | 2025-07-02 21:10:12.477554 | 2025-07-21 21:13:08.696963 |
MPC_primarydb | neocp_els | 46 | 2025-07-21 21:06:21.625641 | 2025-07-21 21:13:08.82836 |
MPC_mpcsbndb | neocp_els | 46 | 2025-07-21 21:06:21.625641 | 2025-07-21 21:13:08.933317 |
SBN_to_AWS | neocp_els | 46 | 2025-07-21 21:06:21.625641 | 2025-07-21 21:13:09.017873 |
MPC_primarydb | neocp_events | 278687 | 2025-07-21 21:06:21.807095 | 2025-07-21 21:13:09.105214 |
MPC_mpcsbndb | neocp_events | 278687 | 2025-07-21 21:06:21.807095 | 2025-07-21 21:13:09.299523 |
SBN_to_AWS | neocp_events | 278687 | 2025-07-21 21:06:21.807095 | 2025-07-21 21:13:09.414119 |
MPC_primarydb | neocp_obs | 366 | 2025-07-21 21:06:21.614395 | 2025-07-21 21:13:09.518892 |
MPC_mpcsbndb | neocp_obs | 366 | 2025-07-21 21:06:21.614395 | 2025-07-21 21:13:09.621233 |
SBN_to_AWS | neocp_obs | 366 | 2025-07-21 21:06:21.614395 | 2025-07-21 21:13:09.706411 |
MPC_primarydb | neocp_obs_archive | 707885 | 2025-07-21 21:06:21.622397 | 2025-07-21 21:13:09.794121 |
MPC_mpcsbndb | neocp_obs_archive | 707885 | 2025-07-21 21:06:21.622397 | 2025-07-21 21:13:10.053378 |
SBN_to_AWS | neocp_obs_archive | 707885 | 2025-07-21 21:06:21.622397 | 2025-07-21 21:13:10.173222 |
MPC_primarydb | neocp_prev_des | 66661 | 2025-07-21 20:24:05.481941 | 2025-07-21 21:13:10.300276 |
MPC_mpcsbndb | neocp_prev_des | 66661 | 2025-07-21 20:24:05.481941 | 2025-07-21 21:13:10.439624 |
SBN_to_AWS | neocp_prev_des | 66661 | 2025-07-21 20:24:05.481941 | 2025-07-21 21:13:10.540868 |
MPC_primarydb | neocp_var | 90076 | 2025-07-21 21:06:21.667052 | 2025-07-21 21:13:10.634897 |
MPC_mpcsbndb | neocp_var | 90076 | 2025-07-21 21:06:21.667052 | 2025-07-21 21:13:10.79171 |
SBN_to_AWS | neocp_var | 90076 | 2025-07-21 21:06:21.667052 | 2025-07-21 21:13:10.910458 |
MPC_primarydb | obscodes | 2627 | 2025-07-21 19:53:43.239983 | 2025-07-21 21:13:11.005239 |
MPC_mpcsbndb | obscodes | 2627 | 2025-07-21 19:53:43.239983 | 2025-07-21 21:13:11.134455 |
SBN_to_AWS | obscodes | 2627 | 2025-07-21 19:53:43.239983 | 2025-07-21 21:13:11.219493 |
MPC_primarydb | primary_objects | 1499159 | 2025-07-21 16:20:00.47158 | 2025-07-21 21:13:11.306922 |
MPC_mpcsbndb | primary_objects | 1499159 | 2025-07-21 16:20:00.47158 | 2025-07-21 21:13:11.817227 |
SBN_to_AWS | primary_objects | 1499159 | 2025-07-21 16:20:00.47158 | 2025-07-21 21:13:11.966544 |
MPC_primarydb | obs_alterations_corrections | 0 | 2025-07-21 21:13:12.196417 | |
MPC_mpcsbndb | obs_alterations_corrections | 0 | 2025-07-21 21:13:12.298407 | |
SBN_to_AWS | obs_alterations_corrections | 0 | 2025-07-21 21:13:12.382911 | |
MPC_primarydb | obs_alterations_deletions | 1359951 | 2025-07-21 17:46:15.217605 | 2025-07-21 21:13:12.470504 |
MPC_mpcsbndb | obs_alterations_deletions | 1359951 | 2025-07-21 17:46:15.217605 | 2025-07-21 21:13:12.951225 |
SBN_to_AWS | obs_alterations_deletions | 1359951 | 2025-07-21 17:46:15.217605 | 2025-07-21 21:13:13.077635 |
MPC_primarydb | obs_alterations_redesignations | 4254 | 2025-06-13 07:10:58.084417 | 2025-07-21 21:13:13.216871 |
MPC_mpcsbndb | obs_alterations_redesignations | 4254 | 2025-06-13 07:10:58.084417 | 2025-07-21 21:13:13.329544 |
SBN_to_AWS | obs_alterations_redesignations | 4254 | 2025-06-13 07:10:58.084417 | 2025-07-21 21:13:13.415336 |