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-03-12 15:50: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 | 9917 | 2025-02-07 23:25:28 | 2025-03-06 20:01:03 |
| identifications | 205015 | 2025-03-12 12:33:01 | 2025-03-12 12:33:01 |
| isolated_tracklets | 48362511 | 2025-03-12 14:56:50 | 2025-03-12 14:56:50 |
| mp_discoverers | 1937686 | 2014-10-19 04:36:17 | 2025-01-30 01:06:24 |
| numbered_comet_identifications | 1084 | 2025-02-24 11:40:13 | 2025-02-24 11:40:13 |
| numbered_identifications | 1199480 | 2025-02-07 17:43:41 | 2025-02-07 17:43:41 |
| numbered_mps | 773916 | 2025-02-07 19:44:28 | 2025-02-25 19:54:56 |
| 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 | 470529735 | 2025-03-12 15:49:15 | 2025-03-12 15:49:15 |
| orbit_uncertainties | 785438 | 2019-06-05 12:14:34 | 2024-12-03 08:16:15 |
| orbits | 1457082 | 2025-03-12 15:46:19 | 2025-03-12 15:46:19 |
| radar_observations | 1507 | 2024-12-04 04:59:18 | 2024-12-04 04:59:18 |
| Table | Count | Created_at | Updated_at |
| neocp_els | 35 | 2025-03-10 04:34:30.144394 | 2025-03-12 11:38:24.684198 |
| neocp_events | 266314 | 2025-03-12 15:46:19.495717 | 2025-03-12 15:46:19.495717 |
| neocp_obs_archive | 676854 | 2025-03-12 15:44:03.223739 | 2025-03-12 15:44:03.223739 |
| neocp_obs | 360 | 2025-03-12 11:26:45.683412 | 2025-03-12 11:26:45.683412 |
| neocp_prev_des | 65099 | 2025-03-12 15:46:19.464829 | 2025-03-12 15:46:19.464829 |
| neocp_var | 57034 | 2025-03-12 11:38:24.710154 | 2025-03-12 11:38:24.710154 |
| current_identifications | 1966876 | 2025-03-12 15:45:37.632038 | 2025-03-12 15:46:36.746323 |
| numbered_identifications | 774710 | 2025-02-06 01:18:26.171581 | 2025-02-06 01:18:26.171581 |
| primary_objects | 1485816 | 2025-03-12 15:45:37.599775 | 2025-03-12 15:45:37.599775 |
| obs_sbn | 482915274 | 2025-03-06 05:41:12.51706-05 | 2025-03-12 11:56:23.143816-04 |
| obs_alterations_deletions | 1316366 | 2025-03-12 14:36:55.786459 | 2025-03-12 14:36:55.786459 |
| obs_alterations_redesignations | 4208 | 2025-03-06 19:22:03.650961 | 2025-03-06 19:22:03.650961 |
| obs_alterations_unassociations | 376868 | 2025-03-12 14:37:25.709809 | 2025-03-12 14:37:25.709809 |
| mpc_orbits | 1435754 | 2025-03-12 15:45:59.494701 | 2025-03-12 15:45:59.494701 |
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 | 482915229 | 2025-03-12 14:57:43.722641 | 2025-03-12 15:00:01.685507 |
| MPC_mpcsbndb | obs_sbn | 482915229 | 2025-03-12 14:57:43.722641 | 2025-03-12 15:00:13.808367 |
| SBN_to_AWS | obs_sbn | 482915229 | 2025-03-12 14:57:43.722641 | 2025-03-12 15:00:48.399275 |
| MPC_primarydb | current_identifications | 1966875 | 2025-03-12 12:33:54.934685 | 2025-03-12 15:01:22.401369 |
| MPC_mpcsbndb | current_identifications | 1966875 | 2025-03-12 12:33:54.934685 | 2025-03-12 15:01:22.928937 |
| SBN_to_AWS | current_identifications | 1966875 | 2025-03-12 12:33:54.934685 | 2025-03-12 15:01:23.129626 |
| MPC_primarydb | mpc_orbits | 1435753 | 2025-03-12 14:54:42.366877 | 2025-03-12 15:01:23.385398 |
| MPC_mpcsbndb | mpc_orbits | 1435753 | 2025-03-12 14:54:42.366877 | 2025-03-12 15:01:24.463724 |
| SBN_to_AWS | mpc_orbits | 1435753 | 2025-03-12 14:54:42.366877 | 2025-03-12 15:01:24.762557 |
| MPC_primarydb | numbered_identifications | 774710 | 2025-02-06 01:18:26.171581 | 2025-03-12 15:01:25.115282 |
| MPC_mpcsbndb | numbered_identifications | 774710 | 2025-02-06 01:18:26.171581 | 2025-03-12 15:01:25.426397 |
| SBN_to_AWS | numbered_identifications | 774710 | 2025-02-06 01:18:26.171581 | 2025-03-12 15:01:25.572285 |
| MPC_primarydb | neocp_els | 34 | 2025-03-12 11:38:24.684198 | 2025-03-12 15:01:25.792409 |
| MPC_mpcsbndb | neocp_els | 34 | 2025-03-12 11:38:24.684198 | 2025-03-12 15:01:25.894764 |
| SBN_to_AWS | neocp_els | 34 | 2025-03-12 11:38:24.684198 | 2025-03-12 15:01:25.977491 |
| MPC_primarydb | neocp_events | 266312 | 2025-03-12 13:03:36.625769 | 2025-03-12 15:01:26.147734 |
| MPC_mpcsbndb | neocp_events | 266312 | 2025-03-12 13:03:36.625769 | 2025-03-12 15:01:26.326876 |
| SBN_to_AWS | neocp_events | 266312 | 2025-03-12 13:03:36.625769 | 2025-03-12 15:01:26.44276 |
| MPC_primarydb | neocp_obs | 347 | 2025-03-12 11:26:45.683412 | 2025-03-12 15:01:26.639784 |
| MPC_mpcsbndb | neocp_obs | 347 | 2025-03-12 11:26:45.683412 | 2025-03-12 15:01:26.744587 |
| SBN_to_AWS | neocp_obs | 347 | 2025-03-12 11:26:45.683412 | 2025-03-12 15:01:26.827616 |
| MPC_primarydb | neocp_obs_archive | 676851 | 2025-03-12 11:26:45.691561 | 2025-03-12 15:01:26.999402 |
| MPC_mpcsbndb | neocp_obs_archive | 676851 | 2025-03-12 11:26:45.691561 | 2025-03-12 15:01:27.226536 |
| SBN_to_AWS | neocp_obs_archive | 676851 | 2025-03-12 11:26:45.691561 | 2025-03-12 15:01:27.35405 |
| MPC_primarydb | neocp_prev_des | 65098 | 2025-03-12 13:03:36.592872 | 2025-03-12 15:01:27.557871 |
| MPC_mpcsbndb | neocp_prev_des | 65098 | 2025-03-12 13:03:36.592872 | 2025-03-12 15:01:27.699233 |
| SBN_to_AWS | neocp_prev_des | 65098 | 2025-03-12 13:03:36.592872 | 2025-03-12 15:01:27.798489 |
| MPC_primarydb | neocp_var | 55034 | 2025-03-12 11:38:24.710154 | 2025-03-12 15:01:27.984528 |
| MPC_mpcsbndb | neocp_var | 55034 | 2025-03-12 11:38:24.710154 | 2025-03-12 15:01:28.126056 |
| SBN_to_AWS | neocp_var | 55034 | 2025-03-12 11:38:24.710154 | 2025-03-12 15:01:28.234739 |
| MPC_primarydb | primary_objects | 1485815 | 2025-03-12 11:47:25.459868 | 2025-03-12 15:01:28.424424 |
| MPC_mpcsbndb | primary_objects | 1485815 | 2025-03-12 11:47:25.459868 | 2025-03-12 15:01:28.910209 |
| SBN_to_AWS | primary_objects | 1485815 | 2025-03-12 11:47:25.459868 | 2025-03-12 15:01:29.107728 |
| MPC_primarydb | obs_alterations_corrections | 0 | 2025-03-12 15:01:29.337068 | |
| MPC_mpcsbndb | obs_alterations_corrections | 0 | 2025-03-12 15:01:29.440617 | |
| SBN_to_AWS | obs_alterations_corrections | 0 | 2025-03-12 15:01:29.522562 | |
| MPC_primarydb | obs_alterations_deletions | 1316366 | 2025-03-12 14:36:55.786459 | 2025-03-12 15:01:29.694944 |
| MPC_mpcsbndb | obs_alterations_deletions | 1316366 | 2025-03-12 14:36:55.786459 | 2025-03-12 15:01:30.144532 |
| SBN_to_AWS | obs_alterations_deletions | 1316366 | 2025-03-12 14:36:55.786459 | 2025-03-12 15:01:30.271926 |
| MPC_primarydb | obs_alterations_redesignations | 4208 | 2025-03-06 19:22:03.650961 | 2025-03-12 15:01:30.482041 |
| MPC_mpcsbndb | obs_alterations_redesignations | 4208 | 2025-03-06 19:22:03.650961 | 2025-03-12 15:01:30.588661 |
| SBN_to_AWS | obs_alterations_redesignations | 4208 | 2025-03-06 19:22:03.650961 | 2025-03-12 15:01:30.672641 |