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-06-09 22:20: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 | 12710 | 2014-02-10 15:54:06 | 2026-06-09 21:01:02 |
| identifications | 222341 | 2026-06-09 12:53:55 | 2026-06-09 12:53:55 |
| isolated_tracklets | 50752708 | 2026-06-09 21:18:17 | 2026-06-09 21:18:17 |
| 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 | 2011-10-28 17:37:34 | 2026-06-05 18:04:37 |
| 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 | 524360880 | 2026-06-09 21:07:00 | 2026-06-09 21:07:00 |
| orbit_uncertainties | 787193 | 2019-06-03 12:14:45 | 2022-06-02 16:46:34 |
| orbits | 1563153 | 2026-06-09 21:07:03 | 2026-06-09 22: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 | 17 | 2026-06-09 10:14:05.814493 | 2026-06-09 22:21:13.209875 |
| neocp_events | 325725 | 2026-06-09 22:21:13.168298 | 2026-06-09 22:21:13.168298 |
| neocp_obs_archive | 814692 | 2026-06-09 22:21:13.126889 | 2026-06-09 22:21:13.126889 |
| neocp_obs | 176 | 2026-06-09 22:21:13.085145 | 2026-06-09 22:21:13.085145 |
| neocp_prev_des | 72656 | 2026-06-09 22:06:19.429922 | 2026-06-09 22:06:19.429922 |
| neocp_var | 46000 | 2026-06-09 22:21:13.253914 | 2026-06-09 22:21:13.253914 |
| current_identifications | 2079018 | 2026-06-09 22:05:45.731908 | 2026-06-09 22:05:45.731908 |
| numbered_identifications | 896611 | 2026-06-02 22:27:20.380719 | 2026-06-03 16:22:06.978451 |
| primary_objects | 1589522 | 2026-06-09 22:05:45.533934 | 2026-06-09 22:05:45.533934 |
| obs_sbn | 540487344 | 2026-06-07 06:29:21.226531-04 | 2026-06-09 18:10:07.873445-04 |
| obs_alterations_deletions | 1719346 | 2026-06-09 21:53:43.445443 | 2026-06-09 21:53:43.445443 |
| obs_alterations_redesignations | 5090 | 2026-06-07 11:57:46.499225 | 2026-06-07 11:57:46.499225 |
| obs_alterations_unassociations | 588543 | 2026-06-09 22:10:07.690406 | 2026-06-09 22:10:07.690406 |
| mpc_orbits | 1554801 | 2021-02-04 00:42:49.783136 | 2026-06-09 22:23:49.933538 |
| minor_planet_names | 26233 | 2026-01-12 18:42:40.541646 | 2026-06-09 20:34:29.81277 |
| obscodes | 2704 | 2026-06-05 19:58:18.609462 | 2026-06-05 19:58:18.609462 |
| comet_names | 4379 | 2026-06-09 19:49:19.732214 | 2026-06-09 19:49:19.732214 |
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 | 540485071 | 2026-06-09 20:59:57.722186 | 2026-06-09 21:00:02.892171 |
| MPC_mpcsbndb | obs_sbn | 540485074 | 2026-06-09 21:00:15.355946 | 2026-06-09 21:00:22.033235 |
| SBN_to_AWS | obs_sbn | 540485074 | 2026-06-09 21:01:07.983775 | 2026-06-09 21:01:08.425489 |
| MPC_primarydb | current_identifications | 2079016 | 2026-06-09 21:06:38.270864 | 2026-06-09 21:29:49.905108 |
| MPC_mpcsbndb | current_identifications | 2079016 | 2026-06-09 21:06:38.270864 | 2026-06-09 21:29:50.964571 |
| SBN_to_AWS | current_identifications | 2079016 | 2026-06-09 21:06:38.270864 | 2026-06-09 21:29:51.132711 |
| MPC_primarydb | comet_names | 4379 | 2026-06-09 19:49:19.732214 | 2026-06-09 21:29:51.853483 |
| MPC_mpcsbndb | comet_names | 4379 | 2026-06-09 19:49:19.732214 | 2026-06-09 21:29:51.96097 |
| SBN_to_AWS | comet_names | 4379 | 2026-06-09 19:49:19.732214 | 2026-06-09 21:29:52.042961 |
| MPC_primarydb | minor_planet_names | 26233 | 2026-06-09 20:34:29.81277 | 2026-06-09 21:29:52.133429 |
| MPC_mpcsbndb | minor_planet_names | 26233 | 2026-06-09 20:34:29.81277 | 2026-06-09 21:29:52.292137 |
| SBN_to_AWS | minor_planet_names | 26233 | 2026-06-09 20:34:29.81277 | 2026-06-09 21:29:52.400652 |
| MPC_primarydb | mpc_orbits | 1554799 | 2026-06-09 21:29:38.597129 | 2026-06-09 21:29:52.540867 |
| MPC_mpcsbndb | mpc_orbits | 1554799 | 2026-06-09 21:29:42.05737 | 2026-06-09 21:29:54.404043 |
| SBN_to_AWS | mpc_orbits | 1554799 | 2026-06-09 21:29:42.05737 | 2026-06-09 21:29:54.933806 |
| MPC_primarydb | numbered_identifications | 896611 | 2026-06-03 16:22:06.978451 | 2026-06-09 21:29:57.610233 |
| MPC_mpcsbndb | numbered_identifications | 896611 | 2026-06-03 16:22:06.978451 | 2026-06-09 21:29:57.979503 |
| SBN_to_AWS | numbered_identifications | 896611 | 2026-06-03 16:22:06.978451 | 2026-06-09 21:29:58.114653 |
| MPC_primarydb | neocp_els | 18 | 2026-06-09 21:28:05.572104 | 2026-06-09 21:29:58.402335 |
| MPC_mpcsbndb | neocp_els | 18 | 2026-06-09 21:28:05.572104 | 2026-06-09 21:29:58.508513 |
| SBN_to_AWS | neocp_els | 18 | 2026-06-09 21:28:05.572104 | 2026-06-09 21:29:58.58944 |
| MPC_primarydb | neocp_events | 325719 | 2026-06-09 21:28:05.549795 | 2026-06-09 21:29:58.675121 |
| MPC_mpcsbndb | neocp_events | 325719 | 2026-06-09 21:28:05.549795 | 2026-06-09 21:29:58.882363 |
| SBN_to_AWS | neocp_events | 325719 | 2026-06-09 21:28:05.549795 | 2026-06-09 21:29:58.998529 |
| MPC_primarydb | neocp_obs | 177 | 2026-06-09 21:28:05.490942 | 2026-06-09 21:29:59.145367 |
| MPC_mpcsbndb | neocp_obs | 177 | 2026-06-09 21:28:05.490942 | 2026-06-09 21:29:59.255097 |
| SBN_to_AWS | neocp_obs | 177 | 2026-06-09 21:28:05.490942 | 2026-06-09 21:29:59.3355 |
| MPC_primarydb | neocp_obs_archive | 814675 | 2026-06-09 21:28:05.532217 | 2026-06-09 21:29:59.425374 |
| MPC_mpcsbndb | neocp_obs_archive | 814675 | 2026-06-09 21:28:05.532217 | 2026-06-09 21:29:59.680164 |
| SBN_to_AWS | neocp_obs_archive | 814675 | 2026-06-09 21:28:05.532217 | 2026-06-09 21:29:59.816289 |
| MPC_primarydb | neocp_prev_des | 72655 | 2026-06-09 21:06:28.254632 | 2026-06-09 21:30:00.050849 |
| MPC_mpcsbndb | neocp_prev_des | 72655 | 2026-06-09 21:06:28.254632 | 2026-06-09 21:30:00.195584 |
| SBN_to_AWS | neocp_prev_des | 72655 | 2026-06-09 21:06:28.254632 | 2026-06-09 21:30:00.29583 |
| MPC_primarydb | neocp_var | 48000 | 2026-06-09 21:28:05.66138 | 2026-06-09 21:30:00.410561 |
| MPC_mpcsbndb | neocp_var | 48000 | 2026-06-09 21:28:05.66138 | 2026-06-09 21:30:00.558936 |
| SBN_to_AWS | neocp_var | 48000 | 2026-06-09 21:28:05.66138 | 2026-06-09 21:30:00.661163 |
| MPC_primarydb | obscodes | 2704 | 2026-06-05 19:58:18.609462 | 2026-06-09 21:30:00.774525 |
| MPC_mpcsbndb | obscodes | 2704 | 2026-06-05 19:58:18.609462 | 2026-06-09 21:30:00.909543 |
| SBN_to_AWS | obscodes | 2704 | 2026-06-05 19:58:18.609462 | 2026-06-09 21:30:01.022007 |
| MPC_primarydb | primary_objects | 1589520 | 2026-06-09 21:05:49.175426 | 2026-06-09 21:30:01.110533 |
| MPC_mpcsbndb | primary_objects | 1589520 | 2026-06-09 21:05:49.175426 | 2026-06-09 21:30:01.898724 |
| SBN_to_AWS | primary_objects | 1589520 | 2026-06-09 21:05:49.175426 | 2026-06-09 21:30:02.120869 |
| MPC_primarydb | obs_alterations_corrections | 0 | 2026-06-09 21:30:03.765495 | |
| MPC_mpcsbndb | obs_alterations_corrections | 0 | 2026-06-09 21:30:03.873943 | |
| SBN_to_AWS | obs_alterations_corrections | 0 | 2026-06-09 21:30:03.954012 | |
| MPC_primarydb | obs_alterations_deletions | 1713376 | 2026-06-09 21:30:02.175315 | 2026-06-09 21:30:04.037814 |
| MPC_mpcsbndb | obs_alterations_deletions | 1713385 | 2026-06-09 21:30:02.175315 | 2026-06-09 21:30:04.645832 |
| SBN_to_AWS | obs_alterations_deletions | 1713376 | 2026-06-09 21:30:02.175315 | 2026-06-09 21:30:04.8077 |
| MPC_primarydb | obs_alterations_redesignations | 5090 | 2026-06-07 11:57:46.499225 | 2026-06-09 21:30:05.163126 |
| MPC_mpcsbndb | obs_alterations_redesignations | 5090 | 2026-06-07 11:57:46.499225 | 2026-06-09 21:30:05.275322 |
| SBN_to_AWS | obs_alterations_redesignations | 5090 | 2026-06-07 11:57:46.499225 | 2026-06-09 21:30:05.357889 |
| MPC_primarydb | obs_alterations_unassociations | 588521 | 2026-06-09 19:42:23.250359 | 2026-06-09 21:30:05.455716 |
| MPC_mpcsbndb | obs_alterations_unassociations | 588521 | 2026-06-09 19:42:23.250359 | 2026-06-09 21:30:05.759887 |
| SBN_to_AWS | obs_alterations_unassociations | 588521 | 2026-06-09 19:42:23.250359 | 2026-06-09 21:30:05.882735 |