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-03-11 22:00: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 | 5215 | 2026-03-06 22:06:00 | 2026-03-06 22:06:00 |
| comet_orbits | 12030 | 2021-10-19 05:20:25 | 2026-03-07 23:01:17 |
| identifications | 218003 | 2026-03-11 12:26:56 | 2026-03-11 12:26:56 |
| isolated_tracklets | 49825645 | 2026-03-11 20:58:27 | 2026-03-11 20:58:27 |
| 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 | 1333152 | 2026-03-05 21:16:52 | 2026-03-05 21:16:52 |
| numbered_mps | 887103 | 2026-03-05 21:21:22 | 2026-03-05 21:21: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 | 511993624 | 2026-03-11 18:00:19 | 2026-03-11 18:00:19 |
| orbit_uncertainties | 787193 | 2019-06-03 12:14:45 | 2022-06-02 16:46:34 |
| orbits | 1534688 | 2015-03-13 15:17:26 | 2026-03-11 22: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 | 66 | 2026-03-10 15:23:33.766216 | 2026-03-11 21:28:46.718488 |
| neocp_events | 314914 | 2026-03-11 21:28:46.947067 | 2026-03-11 21:28:46.947067 |
| neocp_obs_archive | 788617 | 2026-03-11 21:28:46.677022 | 2026-03-11 21:28:46.677022 |
| neocp_obs | 1286 | 2026-03-11 21:28:46.636265 | 2026-03-11 21:28:46.636265 |
| neocp_prev_des | 71406 | 2026-03-11 20:20:04.394898 | 2026-03-11 20:20:04.394898 |
| neocp_var | 123200 | 2026-03-11 21:28:46.810495 | 2026-03-11 21:28:46.810495 |
| current_identifications | 2047439 | 2020-07-30 16:09:53.526138 | 2026-03-11 21:47:06.772051 |
| numbered_identifications | 887935 | 2026-02-27 03:49:38.898045 | 2026-02-27 03:49:38.898045 |
| primary_objects | 1560081 | 2026-03-11 20:42:05.207943 | 2026-03-11 20:42:05.207943 |
| obs_sbn | 531348397 | 2026-03-11 17:40:07.713449-04 | 2026-03-11 17:41:13.777729-04 |
| obs_alterations_deletions | 1494538 | 2026-03-11 21:38:16.908785 | 2026-03-11 21:38:16.908785 |
| obs_alterations_redesignations | 4519 | 2026-03-11 20:59:36.169991 | 2026-03-11 20:59:36.169991 |
| obs_alterations_unassociations | 563608 | 2026-03-11 20:23:57.76007 | 2026-03-11 20:23:57.76007 |
| mpc_orbits | 1517110 | 2021-02-04 00:38:10.800077 | 2026-03-11 21:41:13.777729 |
| minor_planet_names | 25992 | 2011-10-27 06:38:13 | 2026-01-16 00:37:34.652007 |
| obscodes | 2684 | 2026-03-11 15:22:01.984382 | 2026-03-11 15:22:01.984382 |
| comet_names | 4364 | 2026-02-25 01:23:59.404633 | 2026-02-25 01:23:59.404633 |
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 | 531348424 | 2026-03-11 20:59:39.48828 | 2026-03-11 21:00:02.328005 |
| MPC_mpcsbndb | obs_sbn | 531348424 | 2026-03-11 20:59:39.48828 | 2026-03-11 21:00:15.160277 |
| SBN_to_AWS | obs_sbn | 531348424 | 2026-03-11 20:59:39.48828 | 2026-03-11 21:00:39.977883 |
| MPC_primarydb | current_identifications | 2047439 | 2026-03-11 20:48:57.224434 | 2026-03-11 21:09:54.633642 |
| MPC_mpcsbndb | current_identifications | 2047439 | 2026-03-11 20:48:57.224434 | 2026-03-11 21:09:55.428672 |
| SBN_to_AWS | current_identifications | 2047439 | 2026-03-11 20:48:57.224434 | 2026-03-11 21:09:55.681923 |
| MPC_primarydb | comet_names | 4364 | 2026-02-25 01:23:59.404633 | 2026-03-11 21:09:57.157499 |
| MPC_mpcsbndb | comet_names | 4364 | 2026-02-25 01:23:59.404633 | 2026-03-11 21:09:57.262812 |
| SBN_to_AWS | comet_names | 4364 | 2026-02-25 01:23:59.404633 | 2026-03-11 21:09:57.34627 |
| MPC_primarydb | minor_planet_names | 25992 | 2026-01-16 00:37:34.652007 | 2026-03-11 21:09:57.441717 |
| MPC_mpcsbndb | minor_planet_names | 25992 | 2026-01-16 00:37:34.652007 | 2026-03-11 21:09:57.588735 |
| SBN_to_AWS | minor_planet_names | 25992 | 2026-01-16 00:37:34.652007 | 2026-03-11 21:09:57.687756 |
| MPC_primarydb | mpc_orbits | 1517110 | 2026-03-11 21:09:16.81251 | 2026-03-11 21:09:57.825453 |
| MPC_mpcsbndb | mpc_orbits | 1517110 | 2026-03-11 21:09:16.81251 | 2026-03-11 21:12:23.20263 |
| SBN_to_AWS | mpc_orbits | 1517110 | 2026-03-11 21:09:16.81251 | 2026-03-11 21:12:23.534647 |
| MPC_primarydb | numbered_identifications | 887935 | 2026-02-27 03:49:38.898045 | 2026-03-11 21:12:27.786514 |
| MPC_mpcsbndb | numbered_identifications | 887935 | 2026-02-27 03:49:38.898045 | 2026-03-11 21:12:28.619349 |
| SBN_to_AWS | numbered_identifications | 887935 | 2026-02-27 03:49:38.898045 | 2026-03-11 21:12:28.752425 |
| MPC_primarydb | neocp_els | 66 | 2026-03-11 20:54:47.444164 | 2026-03-11 21:12:28.987535 |
| MPC_mpcsbndb | neocp_els | 66 | 2026-03-11 20:54:47.444164 | 2026-03-11 21:12:29.093695 |
| SBN_to_AWS | neocp_els | 66 | 2026-03-11 20:54:47.444164 | 2026-03-11 21:12:29.176473 |
| MPC_primarydb | neocp_events | 314913 | 2026-03-11 20:54:47.669469 | 2026-03-11 21:12:29.266606 |
| MPC_mpcsbndb | neocp_events | 314913 | 2026-03-11 20:54:47.669469 | 2026-03-11 21:12:29.533748 |
| SBN_to_AWS | neocp_events | 314913 | 2026-03-11 20:54:47.669469 | 2026-03-11 21:12:29.652746 |
| MPC_primarydb | neocp_obs | 1284 | 2026-03-11 20:54:47.361279 | 2026-03-11 21:12:29.80054 |
| MPC_mpcsbndb | neocp_obs | 1284 | 2026-03-11 20:54:47.361279 | 2026-03-11 21:12:29.906967 |
| SBN_to_AWS | neocp_obs | 1284 | 2026-03-11 20:54:47.361279 | 2026-03-11 21:12:29.990451 |
| MPC_primarydb | neocp_obs_archive | 788615 | 2026-03-11 20:54:47.402885 | 2026-03-11 21:12:30.084182 |
| MPC_mpcsbndb | neocp_obs_archive | 788615 | 2026-03-11 20:54:47.402885 | 2026-03-11 21:12:30.504555 |
| SBN_to_AWS | neocp_obs_archive | 788615 | 2026-03-11 20:54:47.402885 | 2026-03-11 21:12:30.635554 |
| MPC_primarydb | neocp_prev_des | 71406 | 2026-03-11 20:20:04.394898 | 2026-03-11 21:12:30.852535 |
| MPC_mpcsbndb | neocp_prev_des | 71406 | 2026-03-11 20:20:04.394898 | 2026-03-11 21:12:31.010334 |
| SBN_to_AWS | neocp_prev_des | 71406 | 2026-03-11 20:20:04.394898 | 2026-03-11 21:12:31.109319 |
| MPC_primarydb | neocp_var | 123210 | 2026-03-11 20:54:47.533929 | 2026-03-11 21:12:31.224866 |
| MPC_mpcsbndb | neocp_var | 123210 | 2026-03-11 20:54:47.533929 | 2026-03-11 21:12:31.391894 |
| SBN_to_AWS | neocp_var | 123210 | 2026-03-11 20:54:47.533929 | 2026-03-11 21:12:31.505541 |
| MPC_primarydb | obscodes | 2684 | 2026-03-11 15:22:01.984382 | 2026-03-11 21:12:31.673159 |
| MPC_mpcsbndb | obscodes | 2684 | 2026-03-11 15:22:01.984382 | 2026-03-11 21:12:31.794666 |
| SBN_to_AWS | obscodes | 2684 | 2026-03-11 15:22:01.984382 | 2026-03-11 21:12:31.878473 |
| MPC_primarydb | primary_objects | 1560081 | 2026-03-11 20:42:05.207943 | 2026-03-11 21:12:31.973013 |
| MPC_mpcsbndb | primary_objects | 1560081 | 2026-03-11 20:42:05.207943 | 2026-03-11 21:12:33.598932 |
| SBN_to_AWS | primary_objects | 1560081 | 2026-03-11 20:42:05.207943 | 2026-03-11 21:12:33.763476 |
| MPC_primarydb | obs_alterations_corrections | 0 | 2026-03-11 21:12:35.391636 | |
| MPC_mpcsbndb | obs_alterations_corrections | 0 | 2026-03-11 21:12:35.495572 | |
| SBN_to_AWS | obs_alterations_corrections | 0 | 2026-03-11 21:12:35.577869 | |
| MPC_primarydb | obs_alterations_deletions | 1494487 | 2026-03-11 21:12:11.414692 | 2026-03-11 21:12:35.665828 |
| MPC_mpcsbndb | obs_alterations_deletions | 1494487 | 2026-03-11 21:12:11.414692 | 2026-03-11 21:12:37.474437 |
| SBN_to_AWS | obs_alterations_deletions | 1494487 | 2026-03-11 21:12:11.414692 | 2026-03-11 21:12:37.610893 |
| MPC_primarydb | obs_alterations_redesignations | 4519 | 2026-03-11 20:59:36.169991 | 2026-03-11 21:12:37.845605 |
| MPC_mpcsbndb | obs_alterations_redesignations | 4519 | 2026-03-11 20:59:36.169991 | 2026-03-11 21:12:37.96465 |
| SBN_to_AWS | obs_alterations_redesignations | 4519 | 2026-03-11 20:59:36.169991 | 2026-03-11 21:12:38.048201 |
| MPC_primarydb | obs_alterations_unassociations | 563608 | 2026-03-11 20:23:57.76007 | 2026-03-11 21:12:38.138807 |
| MPC_mpcsbndb | obs_alterations_unassociations | 563608 | 2026-03-11 20:23:57.76007 | 2026-03-11 21:12:38.661395 |
| SBN_to_AWS | obs_alterations_unassociations | 563608 | 2026-03-11 20:23:57.76007 | 2026-03-11 21:12:38.7905 |