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-06-21 20: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 | 9983 | 2025-06-11 14:46:23 | 2025-06-11 15:01:03 |
| identifications | 206013 | 2025-05-22 12:15:03 | 2025-05-22 12:15:03 |
| isolated_tracklets | 48703104 | 2025-06-21 19:58:18 | 2025-06-21 19:58:18 |
| mp_discoverers | 1969147 | 2025-06-18 21:18:06 | 2025-06-18 21:18:06 |
| numbered_comet_identifications | 1087 | 2025-04-05 10:20:36 | 2025-04-05 10:20:36 |
| numbered_identifications | 1221099 | 2025-04-04 17:20:59 | 2025-04-04 17:20:59 |
| numbered_mps | 793066 | 2016-02-25 15:16:09 | 2025-06-17 11:36:57 |
| 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 | 478391798 | 2025-06-21 14:17:09 | 2025-06-21 14:17:09 |
| orbit_uncertainties | 787193 | 2019-06-03 12:14:45 | 2022-06-02 16:46:34 |
| orbits | 1469399 | 2015-01-08 22:00:15 | 2025-06-21 15: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 | 43 | 2025-06-20 10:59:08.979059 | 2025-06-21 20:28:27.025223 |
| neocp_events | 276103 | 2025-06-21 20:28:27.15107 | 2025-06-21 20:28:27.15107 |
| neocp_obs_archive | 701240 | 2025-06-21 20:28:27.022169 | 2025-06-21 20:28:27.022169 |
| neocp_obs | 309 | 2025-06-21 20:28:27.014557 | 2025-06-21 20:28:27.014557 |
| neocp_prev_des | 66329 | 2025-06-21 13:35:49.6787 | 2025-06-21 13:35:49.6787 |
| neocp_var | 83376 | 2025-06-21 20:28:27.05695 | 2025-06-21 20:28:27.05695 |
| current_identifications | 1978053 | 2025-06-21 17:18:29.871848 | 2025-06-21 17:19:13.924674 |
| numbered_identifications | 812352 | 2025-06-12 13:48:54.938864 | 2025-06-12 13:48:54.938864 |
| primary_objects | 1496503 | 2025-06-21 17:18:29.836052 | 2025-06-21 17:18:29.836052 |
| obs_sbn | 491995161 | 2024-09-27 07:49:04.262455-04 | 2025-06-21 16:30:51.374687-04 |
| obs_alterations_deletions | 1358502 | 2025-06-21 13:38:07.985051 | 2025-06-21 13:38:07.985051 |
| obs_alterations_redesignations | 4254 | 2025-05-21 17:18:42.682759 | 2025-06-13 07:10:58.084417 |
| obs_alterations_unassociations | 414748 | 2025-06-21 00:11:12.645595 | 2025-06-21 00:11:12.645595 |
| mpc_orbits | 1449073 | 2021-02-03 23:13:06.929857 | 2025-06-21 20:33:21.122281 |
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 | 491988367 | 2025-06-21 18:55:40.30642 | 2025-06-21 19:00:02.46538 |
| MPC_mpcsbndb | obs_sbn | 491988367 | 2025-06-21 18:55:40.30642 | 2025-06-21 19:00:25.337542 |
| SBN_to_AWS | obs_sbn | 491988371 | 2025-06-21 19:01:00.611862 | 2025-06-21 19:01:02.36249 |
| MPC_primarydb | current_identifications | 1978053 | 2025-06-21 17:19:13.924674 | 2025-06-21 19:52:15.647981 |
| MPC_mpcsbndb | current_identifications | 1978053 | 2025-06-21 17:19:13.924674 | 2025-06-21 19:52:16.222215 |
| SBN_to_AWS | current_identifications | 1978053 | 2025-06-21 17:19:13.924674 | 2025-06-21 19:52:16.458264 |
| MPC_primarydb | minor_planet_names | 25520 | 2025-06-17 15:36:56.506336 | 2025-06-21 19:52:16.976037 |
| MPC_mpcsbndb | minor_planet_names | 25520 | 2025-06-17 15:36:56.506336 | 2025-06-21 19:52:17.115636 |
| SBN_to_AWS | minor_planet_names | 25520 | 2025-06-17 15:36:56.506336 | 2025-06-21 19:52:17.213675 |
| MPC_primarydb | mpc_orbits | 1449073 | 2025-06-21 19:52:15.588442 | 2025-06-21 19:52:17.314986 |
| MPC_mpcsbndb | mpc_orbits | 1449073 | 2025-06-21 19:52:15.588442 | 2025-06-21 19:52:18.084315 |
| SBN_to_AWS | mpc_orbits | 1449073 | 2025-06-21 19:52:15.588442 | 2025-06-21 19:52:18.30817 |
| MPC_primarydb | numbered_identifications | 812352 | 2025-06-12 13:48:54.938864 | 2025-06-21 19:52:19.366367 |
| MPC_mpcsbndb | numbered_identifications | 812352 | 2025-06-12 13:48:54.938864 | 2025-06-21 19:52:19.68174 |
| SBN_to_AWS | numbered_identifications | 812352 | 2025-06-12 13:48:54.938864 | 2025-06-21 19:52:19.810961 |
| MPC_primarydb | neocp_els | 43 | 2025-06-21 17:56:04.293505 | 2025-06-21 19:52:19.956156 |
| MPC_mpcsbndb | neocp_els | 43 | 2025-06-21 17:56:04.293505 | 2025-06-21 19:52:20.059948 |
| SBN_to_AWS | neocp_els | 43 | 2025-06-21 17:56:04.293505 | 2025-06-21 19:52:20.143088 |
| MPC_primarydb | neocp_events | 276102 | 2025-06-21 17:56:04.305013 | 2025-06-21 19:52:20.231791 |
| MPC_mpcsbndb | neocp_events | 276102 | 2025-06-21 17:56:04.305013 | 2025-06-21 19:52:20.407365 |
| SBN_to_AWS | neocp_events | 276102 | 2025-06-21 17:56:04.305013 | 2025-06-21 19:52:20.520932 |
| MPC_primarydb | neocp_obs | 305 | 2025-06-21 17:55:46.34448 | 2025-06-21 19:52:20.635888 |
| MPC_mpcsbndb | neocp_obs | 305 | 2025-06-21 17:55:46.34448 | 2025-06-21 19:52:20.738702 |
| SBN_to_AWS | neocp_obs | 305 | 2025-06-21 17:55:46.34448 | 2025-06-21 19:52:20.823008 |
| MPC_primarydb | neocp_obs_archive | 701236 | 2025-06-21 17:55:46.350568 | 2025-06-21 19:52:20.915545 |
| MPC_mpcsbndb | neocp_obs_archive | 701236 | 2025-06-21 17:55:46.350568 | 2025-06-21 19:52:21.154813 |
| SBN_to_AWS | neocp_obs_archive | 701236 | 2025-06-21 17:55:46.350568 | 2025-06-21 19:52:21.274847 |
| MPC_primarydb | neocp_prev_des | 66329 | 2025-06-21 13:35:49.6787 | 2025-06-21 19:52:21.423034 |
| MPC_mpcsbndb | neocp_prev_des | 66329 | 2025-06-21 13:35:49.6787 | 2025-06-21 19:52:21.560719 |
| SBN_to_AWS | neocp_prev_des | 66329 | 2025-06-21 13:35:49.6787 | 2025-06-21 19:52:21.659563 |
| MPC_primarydb | neocp_var | 84975 | 2025-06-21 17:55:46.355947 | 2025-06-21 19:52:21.762913 |
| MPC_mpcsbndb | neocp_var | 84975 | 2025-06-21 17:55:46.355947 | 2025-06-21 19:52:21.91136 |
| SBN_to_AWS | neocp_var | 84975 | 2025-06-21 17:55:46.355947 | 2025-06-21 19:52:22.01971 |
| MPC_primarydb | obscodes | 2621 | 2025-06-16 14:52:15.298386 | 2025-06-21 19:52:22.125335 |
| MPC_mpcsbndb | obscodes | 2621 | 2025-06-16 14:52:15.298386 | 2025-06-21 19:52:22.248776 |
| SBN_to_AWS | obscodes | 2621 | 2025-06-16 14:52:15.298386 | 2025-06-21 19:52:22.332887 |
| MPC_primarydb | primary_objects | 1496503 | 2025-06-21 17:18:29.836052 | 2025-06-21 19:52:22.422697 |
| MPC_mpcsbndb | primary_objects | 1496503 | 2025-06-21 17:18:29.836052 | 2025-06-21 19:52:22.902717 |
| SBN_to_AWS | primary_objects | 1496503 | 2025-06-21 17:18:29.836052 | 2025-06-21 19:52:23.053349 |
| MPC_primarydb | obs_alterations_corrections | 0 | 2025-06-21 19:52:23.645536 | |
| MPC_mpcsbndb | obs_alterations_corrections | 0 | 2025-06-21 19:52:23.749453 | |
| SBN_to_AWS | obs_alterations_corrections | 0 | 2025-06-21 19:52:23.833158 |