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-02-21 13: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 | 5202 | 2017-03-15 16:46:33 | 2025-02-02 03:55:25 |
| comet_orbits | 9885 | 2023-09-20 23:40:01 | 2025-02-20 22:01:04 |
| identifications | 204356 | 2025-02-21 12:59:38 | 2025-02-21 12:59:38 |
| isolated_tracklets | 48250301 | 2025-02-21 13:25:50 | 2025-02-21 13:25:50 |
| mp_discoverers | 1937686 | 2014-10-19 04:36:17 | 2025-01-30 01:06:24 |
| mpc_indices | 396 | 2025-02-21 13:00:02 | 2025-02-21 13:00:02 |
| numbered_comet_identifications | 1075 | 2024-10-16 07:14:24 | 2024-10-16 07:14:24 |
| numbered_identifications | 1199480 | 2025-02-07 17:43:41 | 2025-02-07 17:43:41 |
| numbered_mps | 773916 | 2024-10-05 11:53:30 | 2025-02-18 16:23:45 |
| 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 | 468483567 | 2025-02-20 22:16:07 | 2025-02-20 22:16:07 |
| orbit_uncertainties | 785438 | 2019-06-05 12:14:34 | 2024-12-03 08:16:15 |
| orbits | 1454195 | 2025-02-20 22:10:07 | 2025-02-20 23: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 | 114 | 2025-02-21 11:37:45.698478 | 2025-02-21 13:21:22.473722 |
| neocp_events | 262905 | 2025-02-21 13:20:11.511207 | 2025-02-21 13:20:11.511207 |
| neocp_obs_archive | 668693 | 2025-02-21 13:17:54.20311 | 2025-02-21 13:17:54.20311 |
| neocp_obs | 1641 | 2025-02-21 13:17:54.114922 | 2025-02-21 13:17:54.114922 |
| neocp_prev_des | 64598 | 2025-02-21 12:42:44.999043 | 2025-02-21 12:42:44.999043 |
| neocp_var | 210517 | 2025-02-21 13:20:11.332027 | 2025-02-21 13:20:11.332027 |
| current_identifications | 1963553 | 2020-07-30 16:16:19.011889 | 2025-02-21 13:00:11.895872 |
| numbered_identifications | 774710 | 2025-02-06 01:18:26.171581 | 2025-02-06 01:18:26.171581 |
| primary_objects | 1482815 | 2025-02-21 11:25:07.220729 | 2025-02-21 11:25:07.220729 |
| obs_sbn | 479711513 | 2025-02-21 08:15:39.929533-05 | 2025-02-21 08:33:22.371816-05 |
| obs_alterations_deletions | 1315591 | 2025-02-21 01:59:23.158862 | 2025-02-21 01:59:23.158862 |
| obs_alterations_redesignations | 4163 | 2025-02-14 11:55:38.39341 | 2025-02-14 11:55:38.39341 |
| obs_alterations_unassociations | 365569 | 2025-02-21 00:13:41.333917 | 2025-02-21 00:13:41.333917 |
| mpc_orbits | 1431276 | 2021-02-04 01:50:38.36343 | 2025-02-21 13:02:38.722047 |
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 | 479707102 | 2025-02-21 12:58:51.627549 | 2025-02-21 13:00:01.93267 |
| MPC_mpcsbndb | obs_sbn | 479707102 | 2025-02-21 12:57:53.515893 | 2025-02-21 13:00:09.283042 |
| SBN_to_AWS | obs_sbn | 479707102 | 2025-02-21 12:57:53.515893 | 2025-02-21 13:04:55.522801 |
| MPC_primarydb | current_identifications | 1963553 | 2025-02-21 13:00:11.895872 | 2025-02-21 13:09:36.055009 |
| MPC_mpcsbndb | current_identifications | 1963553 | 2025-02-21 13:00:11.895872 | 2025-02-21 13:09:36.509979 |
| SBN_to_AWS | current_identifications | 1963553 | 2025-02-21 13:00:11.895872 | 2025-02-21 13:09:36.717754 |
| MPC_primarydb | mpc_orbits | 1431276 | 2025-02-21 13:02:38.722047 | 2025-02-21 13:09:36.991766 |
| MPC_mpcsbndb | mpc_orbits | 1431276 | 2025-02-21 13:02:38.722047 | 2025-02-21 13:09:37.850546 |
| SBN_to_AWS | mpc_orbits | 1431276 | 2025-02-21 13:02:38.722047 | 2025-02-21 13:09:38.037371 |
| MPC_primarydb | numbered_identifications | 774710 | 2025-02-06 01:18:26.171581 | 2025-02-21 13:09:38.29147 |
| MPC_mpcsbndb | numbered_identifications | 774710 | 2025-02-06 01:18:26.171581 | 2025-02-21 13:09:38.517898 |
| SBN_to_AWS | numbered_identifications | 774710 | 2025-02-06 01:18:26.171581 | 2025-02-21 13:09:38.65083 |
| MPC_primarydb | neocp_els | 111 | 2025-02-21 13:03:51.364234 | 2025-02-21 13:09:38.869839 |
| MPC_mpcsbndb | neocp_els | 111 | 2025-02-21 13:03:51.364234 | 2025-02-21 13:09:38.970387 |
| SBN_to_AWS | neocp_els | 111 | 2025-02-21 13:03:51.364234 | 2025-02-21 13:09:39.05257 |
| MPC_primarydb | neocp_events | 262896 | 2025-02-21 13:06:06.834996 | 2025-02-21 13:09:39.220673 |
| MPC_mpcsbndb | neocp_events | 262896 | 2025-02-21 13:06:06.834996 | 2025-02-21 13:09:39.41543 |
| SBN_to_AWS | neocp_events | 262896 | 2025-02-21 13:06:06.834996 | 2025-02-21 13:09:39.527276 |
| MPC_primarydb | neocp_obs | 1612 | 2025-02-21 13:03:51.18786 | 2025-02-21 13:09:39.724327 |
| MPC_mpcsbndb | neocp_obs | 1612 | 2025-02-21 13:03:51.18786 | 2025-02-21 13:09:39.825184 |
| SBN_to_AWS | neocp_obs | 1612 | 2025-02-21 13:03:51.18786 | 2025-02-21 13:09:39.908291 |
| MPC_primarydb | neocp_obs_archive | 668664 | 2025-02-21 13:03:51.275963 | 2025-02-21 13:09:40.077272 |
| MPC_mpcsbndb | neocp_obs_archive | 668664 | 2025-02-21 13:03:51.275963 | 2025-02-21 13:09:40.244296 |
| SBN_to_AWS | neocp_obs_archive | 668664 | 2025-02-21 13:03:51.275963 | 2025-02-21 13:09:40.363664 |
| MPC_primarydb | neocp_prev_des | 64598 | 2025-02-21 12:42:44.999043 | 2025-02-21 13:09:40.569989 |
| MPC_mpcsbndb | neocp_prev_des | 64598 | 2025-02-21 12:42:44.999043 | 2025-02-21 13:09:40.68567 |
| SBN_to_AWS | neocp_prev_des | 64598 | 2025-02-21 12:42:44.999043 | 2025-02-21 13:09:40.782795 |
| MPC_primarydb | neocp_var | 204451 | 2025-02-21 13:06:06.63165 | 2025-02-21 13:09:40.967314 |
| MPC_mpcsbndb | neocp_var | 204451 | 2025-02-21 13:06:06.63165 | 2025-02-21 13:09:41.116244 |
| SBN_to_AWS | neocp_var | 204451 | 2025-02-21 13:06:06.63165 | 2025-02-21 13:09:41.231179 |
| MPC_primarydb | primary_objects | 1482814 | 2025-02-21 11:25:07.220729 | 2025-02-21 13:09:41.437098 |
| MPC_mpcsbndb | primary_objects | 1482814 | 2025-02-21 11:25:07.220729 | 2025-02-21 13:09:41.715654 |
| SBN_to_AWS | primary_objects | 1482814 | 2025-02-21 11:25:07.220729 | 2025-02-21 13:09:41.883325 |
| MPC_primarydb | obs_alterations_corrections | 0 | 2025-02-21 13:09:42.131894 | |
| MPC_mpcsbndb | obs_alterations_corrections | 0 | 2025-02-21 13:09:42.232205 | |
| SBN_to_AWS | obs_alterations_corrections | 0 | 2025-02-21 13:09:42.314198 | |
| MPC_primarydb | obs_alterations_deletions | 1315591 | 2025-02-21 01:59:23.158862 | 2025-02-21 13:09:42.483553 |
| MPC_mpcsbndb | obs_alterations_deletions | 1315591 | 2025-02-21 01:59:23.158862 | 2025-02-21 13:09:42.772026 |
| SBN_to_AWS | obs_alterations_deletions | 1315591 | 2025-02-21 01:59:23.158862 | 2025-02-21 13:09:42.896077 |
| MPC_primarydb | obs_alterations_redesignations | 4163 | 2025-02-14 11:55:38.39341 | 2025-02-21 13:09:43.103785 |
| MPC_mpcsbndb | obs_alterations_redesignations | 4163 | 2025-02-14 11:55:38.39341 | 2025-02-21 13:09:43.2087 |
| SBN_to_AWS | obs_alterations_redesignations | 4163 | 2025-02-14 11:55:38.39341 | 2025-02-21 13:09:43.291374 |