Instructions (not for the faint of heart) for replicating the database are posted. Questions/issues related to replication should be directed to Andrei Mamoutkine.
2026-08-19 16: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 | 5227 | 2026-06-03 09:27:00 | 2026-06-03 09:27:00 |
| comet_orbits | 12794 | 2026-08-13 21:20:44 | 2026-08-13 22:01:03 |
| identifications | 223187 | 2026-07-14 12:33:56 | 2026-07-14 12:33:56 |
| isolated_tracklets | 50789979 | 2026-08-18 19:48:20 | 2026-08-18 19:48:20 |
| mp_discoverers | 1969147 | 2025-06-18 21:18:06 | 2025-06-18 21:18:06 |
| numbered_comet_identifications | 1295 | 2026-06-03 09:12:00 | 2026-06-03 09:12:00 |
| numbered_identifications | 1342746 | 2026-06-03 02:55:41 | 2026-06-03 02:55:41 |
| numbered_mps | 895910 | 2026-06-03 02:57:32 | 2026-08-17 14:54:31 |
| 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 | 524424745 | 2026-08-19 15:11:03 | 2026-08-19 15:11:03 |
| orbit_uncertainties | 787193 | 2019-06-03 12:14:45 | 2022-06-02 16:46:34 |
| orbits | 1573491 | 2026-08-19 15:11:07 | 2026-08-19 16: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 | 53 | 2026-08-19 14:42:59.198497 | 2026-08-19 16:21:15.036348 |
| neocp_events | 333329 | 2026-08-19 16:20:44.094253 | 2026-08-19 16:20:44.094253 |
| neocp_obs_archive | 828256 | 2026-08-19 16:20:44.086726 | 2026-08-19 16:20:44.086726 |
| neocp_obs | 658 | 2026-08-19 16:20:44.078499 | 2026-08-19 16:20:44.078499 |
| neocp_prev_des | 73568 | 2026-08-19 15:09:58.424963 | 2026-08-19 15:09:58.424963 |
| neocp_var | 124875 | 2026-08-19 16:20:44.158389 | 2026-08-19 16:20:44.158389 |
| current_identifications | 2088262 | 2026-08-19 15:08:49.503981 | 2026-08-19 15:10:24.806141 |
| numbered_identifications | 896611 | 2026-06-02 22:27:20.380719 | 2026-06-03 16:22:06.978451 |
| primary_objects | 1597905 | 2026-08-19 15:08:49.459455 | 2026-08-19 15:08:49.459455 |
| obs_sbn | 546620634 | 2026-08-19 02:18:03.298608-04 | 2026-08-19 12:33:51.99901-04 |
| obs_alterations_deletions | 2068461 | 2026-08-19 16:34:13.189583 | 2026-08-19 16:34:13.189583 |
| obs_alterations_redesignations | 5194 | 2026-08-12 19:41:29.142496 | 2026-08-12 19:41:29.142496 |
| obs_alterations_unassociations | 601153 | 2026-08-19 10:10:19.782949 | 2026-08-19 10:10:19.782949 |
| mpc_orbits | 1563569 | 2021-02-04 01:29:14.827683 | 2026-08-19 16:34:14.887 |
| minor_planet_names | 26623 | 2024-08-15 18:31:11.706972 | 2026-08-17 18:54:31.231141 |
| obscodes | 2717 | 2026-08-14 19:43:59.64199 | 2026-08-14 19:43:59.64199 |
| comet_names | 4389 | 2026-08-07 13:39:18.93276 | 2026-08-07 13:39:18.93276 |
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 | 546585179 | 2026-08-19 16:00:01.838995 | 2026-08-19 16:00:02.626546 |
| MPC_mpcsbndb | obs_sbn | 546585609 | 2026-08-19 16:00:35.467955 | 2026-08-19 16:00:36.249241 |
| SBN_to_AWS | obs_sbn | 546586455 | 2026-08-19 16:01:38.156511 | 2026-08-19 16:01:40.209421 |
| MPC_primarydb | current_identifications | 2088262 | 2026-08-19 15:10:24.806141 | 2026-08-19 16:16:41.599288 |
| MPC_mpcsbndb | current_identifications | 2088262 | 2026-08-19 15:10:24.806141 | 2026-08-19 16:16:44.415297 |
| SBN_to_AWS | current_identifications | 2088262 | 2026-08-19 15:10:24.806141 | 2026-08-19 16:16:44.575194 |
| MPC_primarydb | comet_names | 4389 | 2026-08-07 13:39:18.93276 | 2026-08-19 16:16:44.765178 |
| MPC_mpcsbndb | comet_names | 4389 | 2026-08-07 13:39:18.93276 | 2026-08-19 16:16:44.85601 |
| SBN_to_AWS | comet_names | 4389 | 2026-08-07 13:39:18.93276 | 2026-08-19 16:16:44.932559 |
| MPC_primarydb | minor_planet_names | 26623 | 2026-08-17 18:54:31.231141 | 2026-08-19 16:16:45.011507 |
| MPC_mpcsbndb | minor_planet_names | 26623 | 2026-08-17 18:54:31.231141 | 2026-08-19 16:16:45.194672 |
| SBN_to_AWS | minor_planet_names | 26623 | 2026-08-17 18:54:31.231141 | 2026-08-19 16:16:45.290213 |
| MPC_primarydb | mpc_orbits | 1563569 | 2026-08-19 16:16:44.053008 | 2026-08-19 16:16:45.373087 |
| MPC_mpcsbndb | mpc_orbits | 1563569 | 2026-08-19 16:17:22.308416 | 2026-08-19 16:17:23.96679 |
| SBN_to_AWS | mpc_orbits | 1563569 | 2026-08-19 16:17:22.308416 | 2026-08-19 16:17:24.62441 |
| MPC_primarydb | numbered_identifications | 896611 | 2026-06-03 16:22:06.978451 | 2026-08-19 16:17:25.012721 |
| MPC_mpcsbndb | numbered_identifications | 896611 | 2026-06-03 16:22:06.978451 | 2026-08-19 16:17:25.495932 |
| SBN_to_AWS | numbered_identifications | 896611 | 2026-06-03 16:22:06.978451 | 2026-08-19 16:17:25.624511 |
| MPC_primarydb | neocp_els | 53 | 2026-08-19 15:37:11.457083 | 2026-08-19 16:17:25.755005 |
| MPC_mpcsbndb | neocp_els | 53 | 2026-08-19 15:37:11.457083 | 2026-08-19 16:17:25.852986 |
| SBN_to_AWS | neocp_els | 53 | 2026-08-19 15:37:11.457083 | 2026-08-19 16:17:25.928427 |
| MPC_primarydb | neocp_events | 333328 | 2026-08-19 15:37:11.44243 | 2026-08-19 16:17:26.005352 |
| MPC_mpcsbndb | neocp_events | 333328 | 2026-08-19 15:37:11.44243 | 2026-08-19 16:17:26.267653 |
| SBN_to_AWS | neocp_events | 333328 | 2026-08-19 15:37:11.44243 | 2026-08-19 16:17:26.377004 |
| MPC_primarydb | neocp_obs | 655 | 2026-08-19 15:37:11.405998 | 2026-08-19 16:17:26.476374 |
| MPC_mpcsbndb | neocp_obs | 655 | 2026-08-19 15:37:11.405998 | 2026-08-19 16:17:26.576817 |
| SBN_to_AWS | neocp_obs | 655 | 2026-08-19 15:37:11.405998 | 2026-08-19 16:17:26.652985 |
| MPC_primarydb | neocp_obs_archive | 828253 | 2026-08-19 15:37:11.430818 | 2026-08-19 16:17:26.732639 |
| MPC_mpcsbndb | neocp_obs_archive | 828253 | 2026-08-19 15:37:11.430818 | 2026-08-19 16:17:27.060377 |
| SBN_to_AWS | neocp_obs_archive | 828253 | 2026-08-19 15:37:11.430818 | 2026-08-19 16:17:27.201182 |
| MPC_primarydb | neocp_prev_des | 73568 | 2026-08-19 15:09:58.424963 | 2026-08-19 16:17:27.327696 |
| MPC_mpcsbndb | neocp_prev_des | 73568 | 2026-08-19 15:09:58.424963 | 2026-08-19 16:17:27.481038 |
| SBN_to_AWS | neocp_prev_des | 73568 | 2026-08-19 15:09:58.424963 | 2026-08-19 16:17:27.57153 |
| MPC_primarydb | neocp_var | 124832 | 2026-08-19 15:37:11.530534 | 2026-08-19 16:17:27.656508 |
| MPC_mpcsbndb | neocp_var | 124832 | 2026-08-19 15:37:11.530534 | 2026-08-19 16:17:27.838542 |
| SBN_to_AWS | neocp_var | 124832 | 2026-08-19 15:37:11.530534 | 2026-08-19 16:17:27.956337 |
| MPC_primarydb | obscodes | 2717 | 2026-08-14 19:43:59.64199 | 2026-08-19 16:17:28.042081 |
| MPC_mpcsbndb | obscodes | 2717 | 2026-08-14 19:43:59.64199 | 2026-08-19 16:17:28.21275 |
| SBN_to_AWS | obscodes | 2717 | 2026-08-14 19:43:59.64199 | 2026-08-19 16:17:28.290534 |
| MPC_primarydb | primary_objects | 1597905 | 2026-08-19 15:08:49.459455 | 2026-08-19 16:17:28.369247 |
| MPC_mpcsbndb | primary_objects | 1597905 | 2026-08-19 15:08:49.459455 | 2026-08-19 16:17:29.426323 |
| SBN_to_AWS | primary_objects | 1597905 | 2026-08-19 15:08:49.459455 | 2026-08-19 16:17:29.632756 |
| MPC_primarydb | obs_alterations_corrections | 0 | 2026-08-19 16:17:29.819027 | |
| MPC_mpcsbndb | obs_alterations_corrections | 0 | 2026-08-19 16:17:29.912006 | |
| SBN_to_AWS | obs_alterations_corrections | 0 | 2026-08-19 16:17:29.986012 | |
| MPC_primarydb | obs_alterations_deletions | 2062686 | 2026-08-19 16:17:29.067663 | 2026-08-19 16:17:30.06317 |
| MPC_mpcsbndb | obs_alterations_deletions | 2062691 | 2026-08-19 16:17:29.134985 | 2026-08-19 16:17:31.003654 |
| SBN_to_AWS | obs_alterations_deletions | 2062691 | 2026-08-19 16:17:29.134985 | 2026-08-19 16:17:31.14054 |
| MPC_primarydb | obs_alterations_redesignations | 5194 | 2026-08-12 19:41:29.142496 | 2026-08-19 16:17:31.31594 |
| MPC_mpcsbndb | obs_alterations_redesignations | 5194 | 2026-08-12 19:41:29.142496 | 2026-08-19 16:17:31.41933 |
| SBN_to_AWS | obs_alterations_redesignations | 5194 | 2026-08-12 19:41:29.142496 | 2026-08-19 16:17:31.496104 |
| MPC_primarydb | obs_alterations_unassociations | 601153 | 2026-08-19 10:10:19.782949 | 2026-08-19 16:17:31.585617 |
| MPC_mpcsbndb | obs_alterations_unassociations | 601153 | 2026-08-19 10:10:19.782949 | 2026-08-19 16:17:32.177071 |
| SBN_to_AWS | obs_alterations_unassociations | 601153 | 2026-08-19 10:10:19.782949 | 2026-08-19 16:17:32.296113 |