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-04-10 13: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 | 5206 | 2025-04-09 15:30:27 | 2025-04-09 15:30:27 |
| comet_orbits | 9925 | 2025-04-08 23:18:57 | 2025-04-09 00:01:02 |
| identifications | 205417 | 2025-04-10 12:44:28 | 2025-04-10 12:44:28 |
| isolated_tracklets | 48525733 | 2025-04-10 13:48:17 | 2025-04-10 13:48:17 |
| mp_discoverers | 1937686 | 2014-10-19 04:36:17 | 2025-01-30 01:06:24 |
| 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 | 2024-05-27 15:32:06 | 2025-04-09 16:54:43 |
| 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 | 472647928 | 2025-04-10 12:45:42 | 2025-04-10 12:45:42 |
| orbit_uncertainties | 785438 | 2019-06-05 12:14:34 | 2024-12-03 08:16:15 |
| orbits | 1460514 | 2024-02-15 01:46:40 | 2025-04-10 13:01:10 |
| radar_observations | 1507 | 2024-12-04 04:59:18 | 2024-12-04 04:59:18 |
| Table | Count | Created_at | Updated_at |
| neocp_els | 18 | 2025-04-09 09:18:46.031592 | 2025-04-10 10:06:30.824396 |
| neocp_events | 270258 | 2025-04-10 10:06:30.996457 | 2025-04-10 10:06:30.996457 |
| neocp_obs_archive | 686798 | 2025-04-10 10:06:30.821581 | 2025-04-10 10:06:30.821581 |
| neocp_obs | 142 | 2025-04-10 10:06:30.81428 | 2025-04-10 10:06:30.81428 |
| neocp_prev_des | 65605 | 2025-04-10 05:36:25.063279 | 2025-04-10 05:36:25.063279 |
| neocp_var | 34911 | 2025-04-10 10:06:30.863155 | 2025-04-10 10:06:30.863155 |
| current_identifications | 1969915 | 2025-04-10 13:00:15.917497 | 2025-04-10 13:01:00.595786 |
| numbered_identifications | 793862 | 2025-03-31 20:41:42.296919 | 2025-03-31 20:41:42.296919 |
| primary_objects | 1488663 | 2025-04-10 13:00:15.886548 | 2025-04-10 13:00:15.886548 |
| obs_sbn | 485943294 | 2025-04-10 09:47:03.494174-04 | 2025-04-10 09:48:15.700492-04 |
| obs_alterations_deletions | 1346529 | 2025-04-09 16:33:47.968439 | 2025-04-09 16:33:47.968439 |
| obs_alterations_redesignations | 4241 | 2025-04-08 21:16:07.998777 | 2025-04-08 21:16:07.998777 |
| obs_alterations_unassociations | 390008 | 2025-04-10 00:10:07.859524 | 2025-04-10 00:10:07.859524 |
| mpc_orbits | 1438963 | 2022-02-18 17:32:19.50506 | 2025-04-10 13:15:51.440974 |
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 | 485413653 | 2025-04-02 13:58:14.468007 | 2025-04-02 14:00:02.63463 |
| MPC_mpcsbndb | obs_sbn | 485413653 | 2025-04-02 13:58:14.468007 | 2025-04-02 14:00:19.022326 |
| SBN_to_AWS | obs_sbn | 485413653 | 2025-04-02 14:00:32.963992 | 2025-04-02 14:00:50.418394 |
| MPC_primarydb | current_identifications | 1969145 | 2025-04-02 14:01:18.497679 | 2025-04-02 14:01:21.985225 |
| MPC_mpcsbndb | current_identifications | 1969145 | 2025-04-02 14:01:18.497679 | 2025-04-02 14:01:22.518795 |
| SBN_to_AWS | current_identifications | 1969145 | 2025-04-02 14:01:18.497679 | 2025-04-02 14:01:22.788569 |
| MPC_primarydb | mpc_orbits | 1438268 | 2025-04-02 14:01:10.611273 | 2025-04-02 14:01:23.089318 |
| MPC_mpcsbndb | mpc_orbits | 1438268 | 2025-04-02 14:01:10.611273 | 2025-04-02 14:01:24.241342 |
| SBN_to_AWS | mpc_orbits | 1438268 | 2025-04-02 14:01:10.611273 | 2025-04-02 14:01:24.555628 |
| MPC_primarydb | numbered_identifications | 793862 | 2025-03-31 20:41:42.296919 | 2025-04-02 14:01:24.910719 |
| MPC_mpcsbndb | numbered_identifications | 793862 | 2025-03-31 20:41:42.296919 | 2025-04-02 14:01:25.208489 |
| SBN_to_AWS | numbered_identifications | 793862 | 2025-03-31 20:41:42.296919 | 2025-04-02 14:01:25.352732 |
| MPC_primarydb | neocp_els | 56 | 2025-04-02 11:57:50.866149 | 2025-04-02 14:01:25.56372 |
| MPC_mpcsbndb | neocp_els | 56 | 2025-04-02 11:57:50.866149 | 2025-04-02 14:01:25.669396 |
| SBN_to_AWS | neocp_els | 56 | 2025-04-02 11:57:50.866149 | 2025-04-02 14:01:25.757588 |
| MPC_primarydb | neocp_events | 269482 | 2025-04-02 12:20:04.563327 | 2025-04-02 14:01:25.930109 |
| MPC_mpcsbndb | neocp_events | 269482 | 2025-04-02 12:20:04.563327 | 2025-04-02 14:01:26.106286 |
| SBN_to_AWS | neocp_events | 269482 | 2025-04-02 12:20:04.563327 | 2025-04-02 14:01:26.2262 |
| MPC_primarydb | neocp_obs | 554 | 2025-04-02 11:57:50.807383 | 2025-04-02 14:01:26.420988 |
| MPC_mpcsbndb | neocp_obs | 554 | 2025-04-02 11:57:50.807383 | 2025-04-02 14:01:26.525546 |
| SBN_to_AWS | neocp_obs | 554 | 2025-04-02 11:57:50.807383 | 2025-04-02 14:01:26.613971 |
| MPC_primarydb | neocp_obs_archive | 684975 | 2025-04-02 11:57:50.815698 | 2025-04-02 14:01:26.78627 |
| MPC_mpcsbndb | neocp_obs_archive | 684975 | 2025-04-02 11:57:50.815698 | 2025-04-02 14:01:26.987543 |
| SBN_to_AWS | neocp_obs_archive | 684975 | 2025-04-02 11:57:50.815698 | 2025-04-02 14:01:27.144414 |
| MPC_primarydb | neocp_prev_des | 65512 | 2025-04-02 12:20:04.468264 | 2025-04-02 14:01:27.349012 |
| MPC_mpcsbndb | neocp_prev_des | 65512 | 2025-04-02 12:20:04.468264 | 2025-04-02 14:01:27.48774 |
| SBN_to_AWS | neocp_prev_des | 65512 | 2025-04-02 12:20:04.468264 | 2025-04-02 14:01:27.594103 |
| MPC_primarydb | neocp_var | 108841 | 2025-04-02 11:57:50.823898 | 2025-04-02 14:01:27.782174 |
| MPC_mpcsbndb | neocp_var | 108841 | 2025-04-02 11:57:50.823898 | 2025-04-02 14:01:27.950456 |
| SBN_to_AWS | neocp_var | 108841 | 2025-04-02 11:57:50.823898 | 2025-04-02 14:01:28.088324 |
| MPC_primarydb | primary_objects | 1488074 | 2025-04-02 14:00:30.861812 | 2025-04-02 14:01:28.292331 |
| MPC_mpcsbndb | primary_objects | 1488074 | 2025-04-02 14:00:30.861812 | 2025-04-02 14:01:28.67692 |
| SBN_to_AWS | primary_objects | 1488074 | 2025-04-02 14:00:30.861812 | 2025-04-02 14:01:28.895704 |
| MPC_primarydb | obs_alterations_corrections | 0 | 2025-04-02 14:01:29.126433 | |
| MPC_mpcsbndb | obs_alterations_corrections | 0 | 2025-04-02 14:01:29.229104 | |
| SBN_to_AWS | obs_alterations_corrections | 0 | 2025-04-02 14:01:29.316718 | |
| MPC_primarydb | obs_alterations_deletions | 1346470 | 2025-04-02 13:16:00.113824 | 2025-04-02 14:01:29.488784 |
| MPC_mpcsbndb | obs_alterations_deletions | 1346470 | 2025-04-02 13:16:00.113824 | 2025-04-02 14:01:29.870859 |
| SBN_to_AWS | obs_alterations_deletions | 1346470 | 2025-04-02 13:16:00.113824 | 2025-04-02 14:01:30.01007 |
| MPC_primarydb | obs_alterations_redesignations | 4208 | 2025-04-01 03:37:11.953767 | 2025-04-02 14:01:30.22107 |
| MPC_mpcsbndb | obs_alterations_redesignations | 4208 | 2025-04-01 03:37:11.953767 | 2025-04-02 14:01:30.326363 |
| SBN_to_AWS | obs_alterations_redesignations | 4208 | 2025-04-01 03:37:11.953767 | 2025-04-02 14:01:30.415923 |