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-02-24 14:30: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 | 5214 | 2025-10-23 17:12:59 | 2025-10-23 17:12:59 |
| comet_orbits | 11220 | 2026-02-19 16:33:17 | 2026-02-19 17:01:02 |
| identifications | 211641 | 2026-01-14 12:15:20 | 2026-01-14 12:15:20 |
| isolated_tracklets | 49794816 | 2026-02-24 14:08:19 | 2026-02-24 14:08:19 |
| mp_discoverers | 1969147 | 2025-06-18 21:18:06 | 2025-06-18 21:18:06 |
| numbered_comet_identifications | 1292 | 2025-10-23 16:03:49 | 2025-10-23 16:03:49 |
| numbered_identifications | 1319125 | 2025-10-22 17:46:28 | 2025-10-22 17:46:28 |
| numbered_mps | 875150 | 2011-10-28 09:36:11 | 2026-01-12 14:34:38 |
| 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 | 502507015 | 2026-02-24 13:51:49 | 2026-02-24 13:51:49 |
| orbit_uncertainties | 787193 | 2019-06-03 12:14:45 | 2022-06-02 16:46:34 |
| orbits | 1535421 | 2026-02-24 13:51:53 | 2026-02-24 14:01:03 |
| radar_observations | 1507 | 2024-12-04 04:59:18 | 2024-12-04 04:59:18 |
| Table | Count | Created_at | Updated_at |
| neocp_els | 92 | 2026-02-24 14:29:11.966213 | 2026-02-24 14:29:11.966213 |
| neocp_events | 312450 | 2026-02-24 14:29:12.054591 | 2026-02-24 14:29:12.054591 |
| neocp_obs_archive | 782280 | 2026-02-24 14:29:11.896835 | 2026-02-24 14:29:11.896835 |
| neocp_obs | 1367 | 2026-02-24 14:29:11.883788 | 2026-02-24 14:29:11.883788 |
| neocp_prev_des | 71136 | 2026-02-24 13:56:49.480672 | 2026-02-24 13:56:49.480672 |
| neocp_var | 175151 | 2026-02-24 14:29:11.910362 | 2026-02-24 14:29:11.910362 |
| current_identifications | 2045601 | 2026-02-24 14:04:34.030375 | 2026-02-24 14:04:34.030375 |
| numbered_identifications | 875981 | 2026-02-11 03:01:35.42883 | 2026-02-11 03:01:35.42883 |
| primary_objects | 1561319 | 2026-02-24 14:04:33.990149 | 2026-02-24 14:04:33.990149 |
| obs_sbn | 530023400 | 2026-02-24 08:21:11.560597-05 | 2026-02-24 09:33:38.752225-05 |
| obs_alterations_deletions | 1492355 | 2026-02-24 10:21:44.453736 | 2026-02-24 10:21:44.453736 |
| obs_alterations_redesignations | 4515 | 2026-01-03 19:19:15.911342 | 2026-01-03 19:19:15.911342 |
| obs_alterations_unassociations | 559462 | 2026-02-24 14:10:11.333353 | 2026-02-24 14:10:11.333353 |
| mpc_orbits | 1517698 | 2021-02-04 00:58:56.07807 | 2026-02-24 14:33:44.540711 |
| minor_planet_names | 25992 | 2011-10-27 06:38:13 | 2026-01-16 00:37:34.652007 |
| obscodes | 2679 | 2026-02-17 16:33:00.104295 | 2026-02-17 16:33:00.104295 |
| comet_names | 4282 | 2025-12-11 19:53:04.596625 | 2026-02-18 17:43:57.991089 |
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 | 529979942 | 2026-02-24 14:00:01.331069 | 2026-02-24 14:00:02.155383 |
| MPC_mpcsbndb | obs_sbn | 529980299 | 2026-02-24 14:00:18.990635 | 2026-02-24 14:00:19.728455 |
| SBN_to_AWS | obs_sbn | 529980780 | 2026-02-24 14:00:41.864883 | 2026-02-24 14:00:43.500728 |
| MPC_primarydb | current_identifications | 2045601 | 2026-02-24 14:04:34.030375 | 2026-02-24 14:05:35.562821 |
| MPC_mpcsbndb | current_identifications | 2045601 | 2026-02-24 14:04:34.030375 | 2026-02-24 14:05:36.189799 |
| SBN_to_AWS | current_identifications | 2045601 | 2026-02-24 14:04:34.030375 | 2026-02-24 14:05:36.42599 |
| MPC_primarydb | comet_names | 4282 | 2026-02-18 17:43:57.991089 | 2026-02-24 14:05:36.695551 |
| MPC_mpcsbndb | comet_names | 4282 | 2026-02-18 17:43:57.991089 | 2026-02-24 14:05:36.796577 |
| SBN_to_AWS | comet_names | 4282 | 2026-02-18 17:43:57.991089 | 2026-02-24 14:05:36.882875 |
| MPC_primarydb | minor_planet_names | 25992 | 2026-01-16 00:37:34.652007 | 2026-02-24 14:05:36.97389 |
| MPC_mpcsbndb | minor_planet_names | 25992 | 2026-01-16 00:37:34.652007 | 2026-02-24 14:05:37.131038 |
| SBN_to_AWS | minor_planet_names | 25992 | 2026-01-16 00:37:34.652007 | 2026-02-24 14:05:37.232161 |
| MPC_primarydb | mpc_orbits | 1517698 | 2026-02-24 14:05:36.256419 | 2026-02-24 14:05:37.327203 |
| MPC_mpcsbndb | mpc_orbits | 1517698 | 2026-02-24 14:05:38.289241 | 2026-02-24 14:05:38.959469 |
| SBN_to_AWS | mpc_orbits | 1517698 | 2026-02-24 14:05:37.530813 | 2026-02-24 14:05:39.479971 |
| MPC_primarydb | numbered_identifications | 875981 | 2026-02-11 03:01:35.42883 | 2026-02-24 14:05:41.235795 |
| MPC_mpcsbndb | numbered_identifications | 875981 | 2026-02-11 03:01:35.42883 | 2026-02-24 14:05:41.618801 |
| SBN_to_AWS | numbered_identifications | 875981 | 2026-02-11 03:01:35.42883 | 2026-02-24 14:05:41.778955 |
| MPC_primarydb | neocp_els | 91 | 2026-02-24 13:32:44.504603 | 2026-02-24 14:05:41.928416 |
| MPC_mpcsbndb | neocp_els | 91 | 2026-02-24 13:32:44.504603 | 2026-02-24 14:05:42.027585 |
| SBN_to_AWS | neocp_els | 91 | 2026-02-24 13:32:44.504603 | 2026-02-24 14:05:42.113394 |
| MPC_primarydb | neocp_events | 312448 | 2026-02-24 13:56:49.513847 | 2026-02-24 14:05:42.215321 |
| MPC_mpcsbndb | neocp_events | 312448 | 2026-02-24 13:56:49.513847 | 2026-02-24 14:05:42.403156 |
| SBN_to_AWS | neocp_events | 312448 | 2026-02-24 13:56:49.513847 | 2026-02-24 14:05:42.524961 |
| MPC_primarydb | neocp_obs | 1359 | 2026-02-24 13:30:52.116111 | 2026-02-24 14:05:42.64635 |
| MPC_mpcsbndb | neocp_obs | 1359 | 2026-02-24 13:30:52.116111 | 2026-02-24 14:05:42.755604 |
| SBN_to_AWS | neocp_obs | 1359 | 2026-02-24 13:30:52.116111 | 2026-02-24 14:05:42.84318 |
| MPC_primarydb | neocp_obs_archive | 782272 | 2026-02-24 13:30:52.129031 | 2026-02-24 14:05:42.937022 |
| MPC_mpcsbndb | neocp_obs_archive | 782272 | 2026-02-24 13:30:52.129031 | 2026-02-24 14:05:43.181771 |
| SBN_to_AWS | neocp_obs_archive | 782272 | 2026-02-24 13:30:52.129031 | 2026-02-24 14:05:43.325796 |
| MPC_primarydb | neocp_prev_des | 71136 | 2026-02-24 13:56:49.480672 | 2026-02-24 14:05:43.464626 |
| MPC_mpcsbndb | neocp_prev_des | 71136 | 2026-02-24 13:56:49.480672 | 2026-02-24 14:05:43.597806 |
| SBN_to_AWS | neocp_prev_des | 71136 | 2026-02-24 13:56:49.480672 | 2026-02-24 14:05:43.701038 |
| MPC_primarydb | neocp_var | 173151 | 2026-02-24 13:32:44.658644 | 2026-02-24 14:05:43.798251 |
| MPC_mpcsbndb | neocp_var | 173151 | 2026-02-24 13:32:44.658644 | 2026-02-24 14:05:43.971227 |
| SBN_to_AWS | neocp_var | 173151 | 2026-02-24 13:32:44.658644 | 2026-02-24 14:05:44.105111 |
| MPC_primarydb | obscodes | 2679 | 2026-02-17 16:33:00.104295 | 2026-02-24 14:05:44.232326 |
| MPC_mpcsbndb | obscodes | 2679 | 2026-02-17 16:33:00.104295 | 2026-02-24 14:05:44.348809 |
| SBN_to_AWS | obscodes | 2679 | 2026-02-17 16:33:00.104295 | 2026-02-24 14:05:44.436065 |
| MPC_primarydb | primary_objects | 1561319 | 2026-02-24 14:04:33.990149 | 2026-02-24 14:05:44.52682 |
| MPC_mpcsbndb | primary_objects | 1561319 | 2026-02-24 14:04:33.990149 | 2026-02-24 14:05:45.08135 |
| SBN_to_AWS | primary_objects | 1561319 | 2026-02-24 14:04:33.990149 | 2026-02-24 14:05:45.252367 |
| MPC_primarydb | obs_alterations_corrections | 0 | 2026-02-24 14:05:45.440315 | |
| MPC_mpcsbndb | obs_alterations_corrections | 0 | 2026-02-24 14:05:45.536964 | |
| SBN_to_AWS | obs_alterations_corrections | 0 | 2026-02-24 14:05:45.622929 | |
| MPC_primarydb | obs_alterations_deletions | 1492355 | 2026-02-24 10:21:44.453736 | 2026-02-24 14:05:45.71551 |
| MPC_mpcsbndb | obs_alterations_deletions | 1492355 | 2026-02-24 10:21:44.453736 | 2026-02-24 14:05:46.206821 |
| SBN_to_AWS | obs_alterations_deletions | 1492355 | 2026-02-24 10:21:44.453736 | 2026-02-24 14:05:46.348357 |
| MPC_primarydb | obs_alterations_redesignations | 4515 | 2026-01-03 19:19:15.911342 | 2026-02-24 14:05:46.501589 |
| MPC_mpcsbndb | obs_alterations_redesignations | 4515 | 2026-01-03 19:19:15.911342 | 2026-02-24 14:05:46.600272 |
| SBN_to_AWS | obs_alterations_redesignations | 4515 | 2026-01-03 19:19:15.911342 | 2026-02-24 14:05:46.687141 |
| MPC_primarydb | obs_alterations_unassociations | 559339 | 2026-02-24 10:16:31.109894 | 2026-02-24 14:05:46.776359 |
| MPC_mpcsbndb | obs_alterations_unassociations | 559339 | 2026-02-24 10:16:31.109894 | 2026-02-24 14:05:47.052114 |
| SBN_to_AWS | obs_alterations_unassociations | 559339 | 2026-02-24 10:16:31.109894 | 2026-02-24 14:05:47.181781 |