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-24 22:10: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 | 12802 | 2025-01-03 03:38:23 | 2026-08-21 21:01:02 |
| identifications | 223187 | 2026-07-14 12:33:56 | 2026-07-14 12:33:56 |
| isolated_tracklets | 50790006 | 2026-08-24 17:18:20 | 2026-08-24 17:18: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 | 524430490 | 2026-08-24 21:38:42 | 2026-08-24 21:38:42 |
| orbit_uncertainties | 787193 | 2019-06-03 12:14:45 | 2022-06-02 16:46:34 |
| orbits | 1574359 | 2026-08-24 21:38:47 | 2026-08-24 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 | 62 | 2026-08-22 05:14:21.093096 | 2026-08-24 21:11:54.268018 |
| neocp_events | 334030 | 2026-08-24 21:37:42.094887 | 2026-08-24 21:37:42.094887 |
| neocp_obs_archive | 829435 | 2026-08-24 21:11:54.25138 | 2026-08-24 21:11:54.25138 |
| neocp_obs | 830 | 2026-08-24 21:11:54.234842 | 2026-08-24 21:11:54.234842 |
| neocp_prev_des | 73644 | 2026-08-24 21:37:42.046965 | 2026-08-24 21:37:42.046965 |
| neocp_var | 140885 | 2026-08-24 21:11:54.3031 | 2026-08-24 21:11:54.3031 |
| current_identifications | 2089352 | 2026-08-24 22:12:25.544112 | 2026-08-24 22:13:37.831917 |
| numbered_identifications | 896611 | 2026-06-02 22:27:20.380719 | 2026-06-03 16:22:06.978451 |
| primary_objects | 1598900 | 2026-08-24 22:12:25.507979 | 2026-08-24 22:12:25.507979 |
| obs_sbn | 547264809 | 2026-08-24 16:18:02.849573-04 | 2026-08-24 18:13:46.251958-04 |
| obs_alterations_deletions | 2150711 | 2026-08-24 22:13:50.935021 | 2026-08-24 22:13:50.935021 |
| obs_alterations_redesignations | 5194 | 2026-08-12 19:41:29.142496 | 2026-08-12 19:41:29.142496 |
| obs_alterations_unassociations | 601771 | 2026-08-24 19:52:03.172127 | 2026-08-24 19:52:03.172127 |
| mpc_orbits | 1564631 | 2021-02-03 23:32:10.321556 | 2026-08-24 22:13:51.581359 |
| 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 | 4390 | 2026-08-19 21:28:36.239316 | 2026-08-19 21:28:36.239316 |
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 | 547202705 | 2026-08-24 21:00:01.665926 | 2026-08-24 21:00:02.355594 |
| MPC_mpcsbndb | obs_sbn | 547203084 | 2026-08-24 21:00:24.927435 | 2026-08-24 21:00:26.534541 |
| SBN_to_AWS | obs_sbn | 547207852 | 2026-08-24 21:06:29.701808 | 2026-08-24 21:06:30.954596 |
| MPC_primarydb | current_identifications | 2089338 | 2026-08-24 21:21:15.755041 | 2026-08-24 21:21:29.662964 |
| MPC_mpcsbndb | current_identifications | 2089338 | 2026-08-24 21:21:15.755041 | 2026-08-24 21:21:30.558316 |
| SBN_to_AWS | current_identifications | 2089338 | 2026-08-24 21:21:15.755041 | 2026-08-24 21:21:30.707025 |
| MPC_primarydb | comet_names | 4390 | 2026-08-19 21:28:36.239316 | 2026-08-24 21:21:30.900081 |
| MPC_mpcsbndb | comet_names | 4390 | 2026-08-19 21:28:36.239316 | 2026-08-24 21:21:30.996599 |
| SBN_to_AWS | comet_names | 4390 | 2026-08-19 21:28:36.239316 | 2026-08-24 21:21:31.07759 |
| MPC_primarydb | minor_planet_names | 26623 | 2026-08-17 18:54:31.231141 | 2026-08-24 21:21:31.160512 |
| MPC_mpcsbndb | minor_planet_names | 26623 | 2026-08-17 18:54:31.231141 | 2026-08-24 21:21:31.302791 |
| SBN_to_AWS | minor_planet_names | 26623 | 2026-08-17 18:54:31.231141 | 2026-08-24 21:21:31.397345 |
| MPC_primarydb | mpc_orbits | 1564617 | 2026-08-24 21:21:30.194483 | 2026-08-24 21:21:31.486285 |
| MPC_mpcsbndb | mpc_orbits | 1564617 | 2026-08-24 21:21:32.644672 | 2026-08-24 21:21:33.561878 |
| SBN_to_AWS | mpc_orbits | 1564617 | 2026-08-24 21:21:31.429925 | 2026-08-24 21:21:33.95994 |
| MPC_primarydb | numbered_identifications | 896611 | 2026-06-03 16:22:06.978451 | 2026-08-24 21:21:34.29338 |
| MPC_mpcsbndb | numbered_identifications | 896611 | 2026-06-03 16:22:06.978451 | 2026-08-24 21:21:34.635467 |
| SBN_to_AWS | numbered_identifications | 896611 | 2026-06-03 16:22:06.978451 | 2026-08-24 21:21:34.754721 |
| MPC_primarydb | neocp_els | 62 | 2026-08-24 21:11:54.268018 | 2026-08-24 21:21:34.886562 |
| MPC_mpcsbndb | neocp_els | 62 | 2026-08-24 21:11:54.268018 | 2026-08-24 21:21:34.97525 |
| SBN_to_AWS | neocp_els | 62 | 2026-08-24 21:11:54.268018 | 2026-08-24 21:21:35.064356 |
| MPC_primarydb | neocp_events | 334029 | 2026-08-24 21:11:54.254946 | 2026-08-24 21:21:35.146697 |
| MPC_mpcsbndb | neocp_events | 334029 | 2026-08-24 21:11:54.254946 | 2026-08-24 21:21:35.350661 |
| SBN_to_AWS | neocp_events | 334029 | 2026-08-24 21:11:54.254946 | 2026-08-24 21:21:35.456484 |
| MPC_primarydb | neocp_obs | 830 | 2026-08-24 21:11:54.234842 | 2026-08-24 21:21:35.561298 |
| MPC_mpcsbndb | neocp_obs | 830 | 2026-08-24 21:11:54.234842 | 2026-08-24 21:21:35.655166 |
| SBN_to_AWS | neocp_obs | 830 | 2026-08-24 21:11:54.234842 | 2026-08-24 21:21:35.735473 |
| MPC_primarydb | neocp_obs_archive | 829435 | 2026-08-24 21:11:54.25138 | 2026-08-24 21:21:35.817977 |
| MPC_mpcsbndb | neocp_obs_archive | 829435 | 2026-08-24 21:11:54.25138 | 2026-08-24 21:21:36.07823 |
| SBN_to_AWS | neocp_obs_archive | 829435 | 2026-08-24 21:11:54.25138 | 2026-08-24 21:21:36.197907 |
| MPC_primarydb | neocp_prev_des | 73643 | 2026-08-24 19:37:17.180081 | 2026-08-24 21:21:36.328526 |
| MPC_mpcsbndb | neocp_prev_des | 73643 | 2026-08-24 19:37:17.180081 | 2026-08-24 21:21:36.527627 |
| SBN_to_AWS | neocp_prev_des | 73643 | 2026-08-24 19:37:17.180081 | 2026-08-24 21:21:36.622895 |
| MPC_primarydb | neocp_var | 140885 | 2026-08-24 21:11:54.3031 | 2026-08-24 21:21:36.713268 |
| MPC_mpcsbndb | neocp_var | 140885 | 2026-08-24 21:11:54.3031 | 2026-08-24 21:21:36.881761 |
| SBN_to_AWS | neocp_var | 140885 | 2026-08-24 21:11:54.3031 | 2026-08-24 21:21:36.985019 |
| MPC_primarydb | obscodes | 2717 | 2026-08-14 19:43:59.64199 | 2026-08-24 21:21:37.077078 |
| MPC_mpcsbndb | obscodes | 2717 | 2026-08-14 19:43:59.64199 | 2026-08-24 21:21:37.1984 |
| SBN_to_AWS | obscodes | 2717 | 2026-08-14 19:43:59.64199 | 2026-08-24 21:21:37.279149 |
| MPC_primarydb | primary_objects | 1598886 | 2026-08-24 21:20:23.565645 | 2026-08-24 21:21:37.362051 |
| MPC_mpcsbndb | primary_objects | 1598886 | 2026-08-24 21:20:23.565645 | 2026-08-24 21:21:38.094964 |
| SBN_to_AWS | primary_objects | 1598886 | 2026-08-24 21:20:23.565645 | 2026-08-24 21:21:38.254638 |
| MPC_primarydb | obs_alterations_corrections | 0 | 2026-08-24 21:21:38.446454 | |
| MPC_mpcsbndb | obs_alterations_corrections | 0 | 2026-08-24 21:21:38.542734 | |
| SBN_to_AWS | obs_alterations_corrections | 0 | 2026-08-24 21:21:38.622408 | |
| MPC_primarydb | obs_alterations_deletions | 2142783 | 2026-08-24 21:21:35.523959 | 2026-08-24 21:21:38.706312 |
| MPC_mpcsbndb | obs_alterations_deletions | 2142783 | 2026-08-24 21:21:35.523959 | 2026-08-24 21:21:39.404277 |
| SBN_to_AWS | obs_alterations_deletions | 2142783 | 2026-08-24 21:21:35.523959 | 2026-08-24 21:21:39.530865 |
| MPC_primarydb | obs_alterations_redesignations | 5194 | 2026-08-12 19:41:29.142496 | 2026-08-24 21:21:39.721113 |
| MPC_mpcsbndb | obs_alterations_redesignations | 5194 | 2026-08-12 19:41:29.142496 | 2026-08-24 21:21:39.819504 |
| SBN_to_AWS | obs_alterations_redesignations | 5194 | 2026-08-12 19:41:29.142496 | 2026-08-24 21:21:39.900926 |
| MPC_primarydb | obs_alterations_unassociations | 601771 | 2026-08-24 19:52:03.172127 | 2026-08-24 21:21:39.984665 |
| MPC_mpcsbndb | obs_alterations_unassociations | 601771 | 2026-08-24 19:52:03.172127 | 2026-08-24 21:21:40.314908 |
| SBN_to_AWS | obs_alterations_unassociations | 601771 | 2026-08-24 19:52:03.172127 | 2026-08-24 21:21:40.43008 |