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-28 08: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 | 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 | 49816697 | 2026-02-28 08:18:24 | 2026-02-28 08:18:24 |
| 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 | 502512208 | 2026-02-28 08:14:55 | 2026-02-28 08:14:55 |
| orbit_uncertainties | 787193 | 2019-06-03 12:14:45 | 2022-06-02 16:46:34 |
| orbits | 1535832 | 2026-02-28 08:15:02 | 2026-02-28 08:15:02 |
| radar_observations | 1507 | 2024-12-04 04:59:18 | 2024-12-04 04:59:18 |
| Table | Count | Created_at | Updated_at |
| neocp_els | 101 | 2026-02-24 18:16:05.058456 | 2026-02-28 08:34:08.483944 |
| neocp_events | 313366 | 2026-02-28 08:34:08.652361 | 2026-02-28 08:34:08.652361 |
| neocp_obs_archive | 785071 | 2026-02-28 08:34:08.480666 | 2026-02-28 08:34:08.480666 |
| neocp_obs | 1911 | 2026-02-28 08:34:08.471608 | 2026-02-28 08:34:08.471608 |
| neocp_prev_des | 71239 | 2026-02-28 08:15:07.133101 | 2026-02-28 08:15:07.133101 |
| neocp_var | 197003 | 2026-02-28 08:34:08.521307 | 2026-02-28 08:34:08.521307 |
| current_identifications | 2046060 | 2026-02-28 08:33:35.283307 | 2026-02-28 08:34:05.069739 |
| numbered_identifications | 887935 | 2026-02-27 03:49:38.898045 | 2026-02-27 03:49:38.898045 |
| primary_objects | 1561777 | 2026-02-28 08:33:35.246278 | 2026-02-28 08:33:35.246278 |
| obs_sbn | 530572571 | 2026-02-28 03:27:46.522987-05 | 2026-02-28 03:34:12.071402-05 |
| obs_alterations_deletions | 1493901 | 2026-02-27 22:31:12.177504 | 2026-02-27 22:31:12.177504 |
| obs_alterations_redesignations | 4515 | 2025-12-01 14:51:10.350811 | 2026-02-26 23:34:40.379845 |
| obs_alterations_unassociations | 562749 | 2026-02-28 08:22:02.507133 | 2026-02-28 08:22:02.507133 |
| mpc_orbits | 1518206 | 2026-02-28 08:34:16.916765 | 2026-02-28 08:34:22.372971 |
| minor_planet_names | 25992 | 2011-10-27 06:38:13 | 2026-01-16 00:37:34.652007 |
| obscodes | 2681 | 2026-02-26 23:21:53.289855 | 2026-02-26 23:21:53.289855 |
| 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 | 530567722 | 2026-02-28 07:58:57.93994 | 2026-02-28 08:00:02.018809 |
| MPC_mpcsbndb | obs_sbn | 530567722 | 2026-02-28 07:58:57.93994 | 2026-02-28 08:00:28.443921 |
| SBN_to_AWS | obs_sbn | 530567722 | 2026-02-28 07:58:57.93994 | 2026-02-28 08:00:50.159096 |
| MPC_primarydb | current_identifications | 2046036 | 2026-02-28 07:26:16.875938 | 2026-02-28 08:07:17.863763 |
| MPC_mpcsbndb | current_identifications | 2046036 | 2026-02-28 07:26:16.875938 | 2026-02-28 08:07:18.624222 |
| SBN_to_AWS | current_identifications | 2046036 | 2026-02-28 07:26:16.875938 | 2026-02-28 08:07:18.866518 |
| MPC_primarydb | comet_names | 4364 | 2026-02-25 01:23:59.404633 | 2026-02-28 08:07:20.309243 |
| MPC_mpcsbndb | comet_names | 4364 | 2026-02-25 01:23:59.404633 | 2026-02-28 08:07:20.412813 |
| SBN_to_AWS | comet_names | 4364 | 2026-02-25 01:23:59.404633 | 2026-02-28 08:07:20.495459 |
| MPC_primarydb | minor_planet_names | 25992 | 2026-01-16 00:37:34.652007 | 2026-02-28 08:07:20.587331 |
| MPC_mpcsbndb | minor_planet_names | 25992 | 2026-01-16 00:37:34.652007 | 2026-02-28 08:07:20.741586 |
| SBN_to_AWS | minor_planet_names | 25992 | 2026-01-16 00:37:34.652007 | 2026-02-28 08:07:20.836833 |
| MPC_primarydb | mpc_orbits | 1518182 | 2026-02-28 08:04:09.086416 | 2026-02-28 08:07:20.936261 |
| MPC_mpcsbndb | mpc_orbits | 1518182 | 2026-02-28 08:04:09.086416 | 2026-02-28 08:07:22.524294 |
| SBN_to_AWS | mpc_orbits | 1518182 | 2026-02-28 08:04:09.086416 | 2026-02-28 08:07:22.832601 |
| MPC_primarydb | numbered_identifications | 887935 | 2026-02-27 03:49:38.898045 | 2026-02-28 08:07:25.009972 |
| MPC_mpcsbndb | numbered_identifications | 887935 | 2026-02-27 03:49:38.898045 | 2026-02-28 08:07:25.368956 |
| SBN_to_AWS | numbered_identifications | 887935 | 2026-02-27 03:49:38.898045 | 2026-02-28 08:07:25.501467 |
| MPC_primarydb | neocp_els | 103 | 2026-02-28 08:06:12.886302 | 2026-02-28 08:07:25.735078 |
| MPC_mpcsbndb | neocp_els | 103 | 2026-02-28 08:06:12.886302 | 2026-02-28 08:07:25.836149 |
| SBN_to_AWS | neocp_els | 103 | 2026-02-28 08:06:12.886302 | 2026-02-28 08:07:25.91811 |
| MPC_primarydb | neocp_events | 313355 | 2026-02-28 08:06:13.083301 | 2026-02-28 08:07:26.006555 |
| MPC_mpcsbndb | neocp_events | 313355 | 2026-02-28 08:06:13.083301 | 2026-02-28 08:07:26.193755 |
| SBN_to_AWS | neocp_events | 313355 | 2026-02-28 08:06:13.083301 | 2026-02-28 08:07:26.311972 |
| MPC_primarydb | neocp_obs | 2001 | 2026-02-28 08:06:12.834437 | 2026-02-28 08:07:26.457443 |
| MPC_mpcsbndb | neocp_obs | 2001 | 2026-02-28 08:06:12.834437 | 2026-02-28 08:07:26.557066 |
| SBN_to_AWS | neocp_obs | 2001 | 2026-02-28 08:06:12.834437 | 2026-02-28 08:07:26.64057 |
| MPC_primarydb | neocp_obs_archive | 785042 | 2026-02-28 08:06:12.846616 | 2026-02-28 08:07:26.734717 |
| MPC_mpcsbndb | neocp_obs_archive | 785042 | 2026-02-28 08:06:12.846616 | 2026-02-28 08:07:27.007885 |
| SBN_to_AWS | neocp_obs_archive | 785042 | 2026-02-28 08:06:12.846616 | 2026-02-28 08:07:27.138666 |
| MPC_primarydb | neocp_prev_des | 71236 | 2026-02-28 07:26:47.164367 | 2026-02-28 08:07:27.350332 |
| MPC_mpcsbndb | neocp_prev_des | 71236 | 2026-02-28 07:26:47.164367 | 2026-02-28 08:07:27.489777 |
| SBN_to_AWS | neocp_prev_des | 71236 | 2026-02-28 07:26:47.164367 | 2026-02-28 08:07:27.585628 |
| MPC_primarydb | neocp_var | 199638 | 2026-02-28 08:06:12.9465 | 2026-02-28 08:07:27.69966 |
| MPC_mpcsbndb | neocp_var | 199638 | 2026-02-28 08:06:12.9465 | 2026-02-28 08:07:27.90718 |
| SBN_to_AWS | neocp_var | 199638 | 2026-02-28 08:06:12.9465 | 2026-02-28 08:07:28.027616 |
| MPC_primarydb | obscodes | 2681 | 2026-02-26 23:21:53.289855 | 2026-02-28 08:07:28.463135 |
| MPC_mpcsbndb | obscodes | 2681 | 2026-02-26 23:21:53.289855 | 2026-02-28 08:07:28.599482 |
| SBN_to_AWS | obscodes | 2681 | 2026-02-26 23:21:53.289855 | 2026-02-28 08:07:28.682712 |
| MPC_primarydb | primary_objects | 1561753 | 2026-02-28 07:26:16.819055 | 2026-02-28 08:07:28.775759 |
| MPC_mpcsbndb | primary_objects | 1561753 | 2026-02-28 07:26:16.819055 | 2026-02-28 08:07:29.342131 |
| SBN_to_AWS | primary_objects | 1561753 | 2026-02-28 07:26:16.819055 | 2026-02-28 08:07:29.498273 |
| MPC_primarydb | obs_alterations_corrections | 0 | 2026-02-28 08:07:31.081844 | |
| MPC_mpcsbndb | obs_alterations_corrections | 0 | 2026-02-28 08:07:31.179069 | |
| SBN_to_AWS | obs_alterations_corrections | 0 | 2026-02-28 08:07:31.260708 | |
| MPC_primarydb | obs_alterations_deletions | 1493901 | 2026-02-27 22:31:12.177504 | 2026-02-28 08:07:31.346441 |
| MPC_mpcsbndb | obs_alterations_deletions | 1493901 | 2026-02-27 22:31:12.177504 | 2026-02-28 08:07:31.881628 |
| SBN_to_AWS | obs_alterations_deletions | 1493901 | 2026-02-27 22:31:12.177504 | 2026-02-28 08:07:32.020258 |
| MPC_primarydb | obs_alterations_redesignations | 4515 | 2026-02-26 23:34:40.379845 | 2026-02-28 08:07:32.251597 |
| MPC_mpcsbndb | obs_alterations_redesignations | 4515 | 2026-02-26 23:34:40.379845 | 2026-02-28 08:07:32.352852 |
| SBN_to_AWS | obs_alterations_redesignations | 4515 | 2026-02-26 23:34:40.379845 | 2026-02-28 08:07:32.436065 |
| MPC_primarydb | obs_alterations_unassociations | 562697 | 2026-02-27 22:10:07.61758 | 2026-02-28 08:07:32.524896 |
| MPC_mpcsbndb | obs_alterations_unassociations | 562697 | 2026-02-27 22:10:07.61758 | 2026-02-28 08:07:32.796547 |
| SBN_to_AWS | obs_alterations_unassociations | 562697 | 2026-02-27 22:10:07.61758 | 2026-02-28 08:07:32.921736 |