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-18 15:50:02 (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 | 9877 | 2020-02-05 20:51:19 | 2025-02-11 22:01:02 |
identifications | 204278 | 2025-02-18 12:29:43 | 2025-02-18 12:29:43 |
isolated_tracklets | 48232009 | 2025-02-18 15:17:26 | 2025-02-18 15:17:26 |
mp_discoverers | 1937686 | 2014-10-19 04:36:17 | 2025-01-30 01:06:24 |
mpc_indices | 396 | 2025-02-18 15:30:02 | 2025-02-18 15:30: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-12-04 00:54:24 | 2025-02-11 16:12:22 |
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 | 468478969 | 2025-02-18 14:13:21 | 2025-02-18 14:13:21 |
orbit_uncertainties | 785438 | 2019-06-05 12:14:34 | 2024-12-03 08:16:15 |
orbits | 1454112 | 2015-01-08 22:08:35 | 2025-02-18 15:51:58 |
radar_observations | 1507 | 2024-12-04 04:59:18 | 2024-12-04 04:59:18 |
Table | Count | Created_at | Updated_at |
neocp_els | 27 | 2025-01-06 13:25:45.176306 | 2025-02-18 14:10:25.504316 |
neocp_events | 262299 | 2025-02-18 15:52:13.454683 | 2025-02-18 15:52:13.454683 |
neocp_obs_archive | 666792 | 2025-02-18 14:10:25.458955 | 2025-02-18 14:10:25.458955 |
neocp_obs | 536 | 2025-02-18 14:10:25.415472 | 2025-02-18 14:10:25.415472 |
neocp_prev_des | 64563 | 2025-02-18 15:52:13.328798 | 2025-02-18 15:52:13.328798 |
neocp_var | 48625 | 2025-02-18 14:10:40.819446 | 2025-02-18 14:10:40.819446 |
current_identifications | 1963416 | 2025-02-18 14:30:40.716234 | 2025-02-18 14:31:35.44885 |
numbered_identifications | 774710 | 2025-02-06 01:18:26.171581 | 2025-02-06 01:18:26.171581 |
primary_objects | 1482714 | 2025-02-18 14:30:40.649065 | 2025-02-18 14:30:40.649065 |
obs_sbn | 479357829 | 2025-02-18 04:52:49.171514-05 | 2025-02-18 10:52:06.175525-05 |
obs_alterations_deletions | 1315523 | 2025-02-18 00:59:44.679949 | 2025-02-18 00:59:44.679949 |
obs_alterations_redesignations | 4163 | 2025-02-14 11:55:38.39341 | 2025-02-14 11:55:38.39341 |
obs_alterations_unassociations | 365176 | 2025-02-18 12:13:30.139713 | 2025-02-18 12:13:30.139713 |
mpc_orbits | 1430670 | 2021-02-03 22:59:50.245409 | 2025-02-18 15:52:56.24462 |
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 | 479348845 | 2025-02-18 14:57:54.299639 | 2025-02-18 15:00:01.805395 |
MPC_mpcsbndb | obs_sbn | 479348845 | 2025-02-18 14:57:54.299639 | 2025-02-18 15:00:14.187218 |
SBN_to_AWS | obs_sbn | 479348845 | 2025-02-18 14:57:54.299639 | 2025-02-18 15:05:12.209812 |
MPC_primarydb | current_identifications | 1963416 | 2025-02-18 14:31:35.44885 | 2025-02-18 15:10:07.505943 |
MPC_mpcsbndb | current_identifications | 1963416 | 2025-02-18 14:31:35.44885 | 2025-02-18 15:10:07.927459 |
SBN_to_AWS | current_identifications | 1963416 | 2025-02-18 14:31:35.44885 | 2025-02-18 15:10:08.115112 |
MPC_primarydb | mpc_orbits | 1430670 | 2025-02-18 15:10:02.114861 | 2025-02-18 15:10:08.381675 |
MPC_mpcsbndb | mpc_orbits | 1430670 | 2025-02-18 15:10:02.114861 | 2025-02-18 15:10:09.035726 |
SBN_to_AWS | mpc_orbits | 1430670 | 2025-02-18 15:10:02.114861 | 2025-02-18 15:10:09.208716 |
MPC_primarydb | numbered_identifications | 774710 | 2025-02-06 01:18:26.171581 | 2025-02-18 15:10:09.470244 |
MPC_mpcsbndb | numbered_identifications | 774710 | 2025-02-06 01:18:26.171581 | 2025-02-18 15:10:09.876776 |
SBN_to_AWS | numbered_identifications | 774710 | 2025-02-06 01:18:26.171581 | 2025-02-18 15:10:10.008809 |
MPC_primarydb | neocp_els | 27 | 2025-02-18 14:10:25.504316 | 2025-02-18 15:10:10.223836 |
MPC_mpcsbndb | neocp_els | 27 | 2025-02-18 14:10:25.504316 | 2025-02-18 15:10:10.321732 |
SBN_to_AWS | neocp_els | 27 | 2025-02-18 14:10:25.504316 | 2025-02-18 15:10:10.403842 |
MPC_primarydb | neocp_events | 262298 | 2025-02-18 14:10:40.955749 | 2025-02-18 15:10:10.574761 |
MPC_mpcsbndb | neocp_events | 262298 | 2025-02-18 14:10:40.955749 | 2025-02-18 15:10:10.716438 |
SBN_to_AWS | neocp_events | 262298 | 2025-02-18 14:10:40.955749 | 2025-02-18 15:10:10.827525 |
MPC_primarydb | neocp_obs | 536 | 2025-02-18 14:10:25.415472 | 2025-02-18 15:10:11.024517 |
MPC_mpcsbndb | neocp_obs | 536 | 2025-02-18 14:10:25.415472 | 2025-02-18 15:10:11.12165 |
SBN_to_AWS | neocp_obs | 536 | 2025-02-18 14:10:25.415472 | 2025-02-18 15:10:11.203699 |
MPC_primarydb | neocp_obs_archive | 666792 | 2025-02-18 14:10:25.458955 | 2025-02-18 15:10:11.37498 |
MPC_mpcsbndb | neocp_obs_archive | 666792 | 2025-02-18 14:10:25.458955 | 2025-02-18 15:10:11.543911 |
SBN_to_AWS | neocp_obs_archive | 666792 | 2025-02-18 14:10:25.458955 | 2025-02-18 15:10:11.661355 |
MPC_primarydb | neocp_prev_des | 64562 | 2025-02-18 13:35:25.869091 | 2025-02-18 15:10:11.867881 |
MPC_mpcsbndb | neocp_prev_des | 64562 | 2025-02-18 13:35:25.869091 | 2025-02-18 15:10:11.982801 |
SBN_to_AWS | neocp_prev_des | 64562 | 2025-02-18 13:35:25.869091 | 2025-02-18 15:10:12.079085 |
MPC_primarydb | neocp_var | 48625 | 2025-02-18 14:10:40.819446 | 2025-02-18 15:10:12.264717 |
MPC_mpcsbndb | neocp_var | 48625 | 2025-02-18 14:10:40.819446 | 2025-02-18 15:10:12.384732 |
SBN_to_AWS | neocp_var | 48625 | 2025-02-18 14:10:40.819446 | 2025-02-18 15:10:12.484934 |
MPC_primarydb | primary_objects | 1482714 | 2025-02-18 14:30:40.649065 | 2025-02-18 15:10:12.672289 |
MPC_mpcsbndb | primary_objects | 1482714 | 2025-02-18 14:30:40.649065 | 2025-02-18 15:10:12.907017 |
SBN_to_AWS | primary_objects | 1482714 | 2025-02-18 14:30:40.649065 | 2025-02-18 15:10:13.072018 |
MPC_primarydb | obs_alterations_corrections | 0 | 2025-02-18 15:10:13.323859 | |
MPC_mpcsbndb | obs_alterations_corrections | 0 | 2025-02-18 15:10:13.421694 | |
SBN_to_AWS | obs_alterations_corrections | 0 | 2025-02-18 15:10:13.503911 | |
MPC_primarydb | obs_alterations_deletions | 1315523 | 2025-02-18 00:59:44.679949 | 2025-02-18 15:10:13.674906 |
MPC_mpcsbndb | obs_alterations_deletions | 1315523 | 2025-02-18 00:59:44.679949 | 2025-02-18 15:10:13.967544 |
SBN_to_AWS | obs_alterations_deletions | 1315523 | 2025-02-18 00:59:44.679949 | 2025-02-18 15:10:14.088789 |
MPC_primarydb | obs_alterations_redesignations | 4163 | 2025-02-14 11:55:38.39341 | 2025-02-18 15:10:14.297128 |
MPC_mpcsbndb | obs_alterations_redesignations | 4163 | 2025-02-14 11:55:38.39341 | 2025-02-18 15:10:14.398096 |
SBN_to_AWS | obs_alterations_redesignations | 4163 | 2025-02-14 11:55:38.39341 | 2025-02-18 15:10:14.481497 |