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-09-08 18: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 | 12822 | 2025-01-03 03:38:23 | 2026-09-08 16:01:03 |
| identifications | 223187 | 2026-07-14 12:33:56 | 2026-07-14 12:33:56 |
| isolated_tracklets | 50790163 | 2026-09-08 04:18:18 | 2026-09-08 04:18:18 |
| 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 | 2024-07-23 01:31:54 | 2026-09-08 14:17:55 |
| 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 | 524452724 | 2026-09-08 15:57:11 | 2026-09-08 15:57:11 |
| orbit_uncertainties | 787193 | 2019-06-03 12:14:45 | 2022-06-02 16:46:34 |
| orbits | 1578203 | 2025-06-15 12:47:49 | 2026-09-08 13:01:54 |
| radar_observations | 1507 | 2024-12-04 04:59:18 | 2024-12-04 04:59:18 |
| Table | Count | Created_at | Updated_at |
| neocp_els | 86 | 2026-09-08 18:22:05.788909 | 2026-09-08 18:22:05.788909 |
| neocp_events | 335817 | 2026-09-08 18:22:05.900866 | 2026-09-08 18:22:05.900866 |
| neocp_obs_archive | 832664 | 2026-09-08 18:22:05.655334 | 2026-09-08 18:22:05.655334 |
| neocp_obs | 993 | 2026-09-08 18:22:05.614262 | 2026-09-08 18:22:05.614262 |
| neocp_prev_des | 73849 | 2026-09-08 15:28:17.153415 | 2026-09-08 15:28:17.153415 |
| neocp_var | 188101 | 2026-09-08 18:22:05.744641 | 2026-09-08 18:22:05.744641 |
| current_identifications | 2093307 | 2026-09-08 17:36:56.53838 | 2026-09-08 17:37:41.989431 |
| numbered_identifications | 896611 | 2026-06-02 22:27:20.380719 | 2026-06-03 16:22:06.978451 |
| primary_objects | 1602803 | 2026-09-08 17:36:56.511318 | 2026-09-08 17:36:56.511318 |
| obs_sbn | 552425601 | 2026-09-08 14:20:13.949836-04 | 2026-09-08 14:21:08.572875-04 |
| obs_alterations_deletions | 2971142 | 2026-09-08 14:58:04.500351 | 2026-09-08 14:58:04.500351 |
| obs_alterations_redesignations | 5218 | 2026-08-25 19:50:31.030107 | 2026-08-25 19:50:31.030107 |
| obs_alterations_unassociations | 605241 | 2026-09-08 18:10:09.298381 | 2026-09-08 18:10:09.298381 |
| mpc_orbits | 1568594 | 2021-02-04 01:44:08.029857 | 2026-09-08 18:21:08.572875 |
| minor_planet_names | 26688 | 2026-09-08 18:18:47.376887 | 2026-09-08 18:18:47.376887 |
| obscodes | 2722 | 2019-05-25 00:11:29.955971 | 2026-09-05 17:21:54.242782 |
| comet_names | 4392 | 2026-08-25 17:00:02.297019 | 2026-08-25 17:00:02.297019 |
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 | 552425593 | 2026-09-08 17:37:17.105749 | 2026-09-08 18:00:02.245593 |
| MPC_mpcsbndb | obs_sbn | 552425593 | 2026-09-08 17:37:17.105749 | 2026-09-08 18:00:15.058648 |
| SBN_to_AWS | obs_sbn | 552425593 | 2026-09-08 17:37:17.105749 | 2026-09-08 18:00:39.204366 |
| MPC_primarydb | current_identifications | 2093307 | 2026-09-08 17:37:41.989431 | 2026-09-08 18:09:12.209824 |
| MPC_mpcsbndb | current_identifications | 2093307 | 2026-09-08 17:37:41.989431 | 2026-09-08 18:09:12.913371 |
| SBN_to_AWS | current_identifications | 2093307 | 2026-09-08 17:37:41.989431 | 2026-09-08 18:09:13.067563 |
| MPC_primarydb | comet_names | 4392 | 2026-08-25 17:00:02.297019 | 2026-09-08 18:09:13.842954 |
| MPC_mpcsbndb | comet_names | 4392 | 2026-08-25 17:00:02.297019 | 2026-09-08 18:09:13.954831 |
| SBN_to_AWS | comet_names | 4392 | 2026-08-25 17:00:02.297019 | 2026-09-08 18:09:14.049112 |
| MPC_primarydb | minor_planet_names | 26623 | 2026-08-17 18:54:31.231141 | 2026-09-08 18:09:14.154619 |
| MPC_mpcsbndb | minor_planet_names | 26623 | 2026-08-17 18:54:31.231141 | 2026-09-08 18:09:14.315093 |
| SBN_to_AWS | minor_planet_names | 26623 | 2026-08-17 18:54:31.231141 | 2026-09-08 18:09:14.424158 |
| MPC_primarydb | mpc_orbits | 1568594 | 2026-09-08 18:08:23.856534 | 2026-09-08 18:09:14.631612 |
| MPC_mpcsbndb | mpc_orbits | 1568594 | 2026-09-08 18:08:23.856534 | 2026-09-08 18:09:16.208134 |
| SBN_to_AWS | mpc_orbits | 1568594 | 2026-09-08 18:08:23.856534 | 2026-09-08 18:09:16.470839 |
| MPC_primarydb | numbered_identifications | 896611 | 2026-06-03 16:22:06.978451 | 2026-09-08 18:09:21.386359 |
| MPC_mpcsbndb | numbered_identifications | 896611 | 2026-06-03 16:22:06.978451 | 2026-09-08 18:09:21.675187 |
| SBN_to_AWS | numbered_identifications | 896611 | 2026-06-03 16:22:06.978451 | 2026-09-08 18:09:21.806578 |
| MPC_primarydb | neocp_els | 85 | 2026-09-08 15:34:17.93822 | 2026-09-08 18:09:22.121399 |
| MPC_mpcsbndb | neocp_els | 85 | 2026-09-08 15:34:17.93822 | 2026-09-08 18:09:22.231937 |
| SBN_to_AWS | neocp_els | 85 | 2026-09-08 15:34:17.93822 | 2026-09-08 18:09:22.325627 |
| MPC_primarydb | neocp_events | 335814 | 2026-09-08 15:34:18.124642 | 2026-09-08 18:09:22.426956 |
| MPC_mpcsbndb | neocp_events | 335814 | 2026-09-08 15:34:18.124642 | 2026-09-08 18:09:22.616354 |
| SBN_to_AWS | neocp_events | 335814 | 2026-09-08 15:34:18.124642 | 2026-09-08 18:09:22.733605 |
| MPC_primarydb | neocp_obs | 988 | 2026-09-08 14:03:57.772967 | 2026-09-08 18:09:22.899764 |
| MPC_mpcsbndb | neocp_obs | 988 | 2026-09-08 14:03:57.772967 | 2026-09-08 18:09:23.010936 |
| SBN_to_AWS | neocp_obs | 988 | 2026-09-08 14:03:57.772967 | 2026-09-08 18:09:23.105292 |
| MPC_primarydb | neocp_obs_archive | 832659 | 2026-09-08 14:03:57.813404 | 2026-09-08 18:09:23.210093 |
| MPC_mpcsbndb | neocp_obs_archive | 832659 | 2026-09-08 14:03:57.813404 | 2026-09-08 18:09:23.434496 |
| SBN_to_AWS | neocp_obs_archive | 832659 | 2026-09-08 14:03:57.813404 | 2026-09-08 18:09:23.561388 |
| MPC_primarydb | neocp_prev_des | 73849 | 2026-09-08 15:28:17.153415 | 2026-09-08 18:09:23.814422 |
| MPC_mpcsbndb | neocp_prev_des | 73849 | 2026-09-08 15:28:17.153415 | 2026-09-08 18:09:23.973459 |
| SBN_to_AWS | neocp_prev_des | 73849 | 2026-09-08 15:28:17.153415 | 2026-09-08 18:09:24.081953 |
| MPC_primarydb | neocp_var | 186179 | 2026-09-08 15:34:17.993186 | 2026-09-08 18:09:24.21192 |
| MPC_mpcsbndb | neocp_var | 186179 | 2026-09-08 15:34:17.993186 | 2026-09-08 18:09:24.388967 |
| SBN_to_AWS | neocp_var | 186179 | 2026-09-08 15:34:17.993186 | 2026-09-08 18:09:24.506576 |
| MPC_primarydb | obscodes | 2722 | 2026-09-05 17:21:54.242782 | 2026-09-08 18:09:24.70217 |
| MPC_mpcsbndb | obscodes | 2722 | 2026-09-05 17:21:54.242782 | 2026-09-08 18:09:24.828771 |
| SBN_to_AWS | obscodes | 2722 | 2026-09-05 17:21:54.242782 | 2026-09-08 18:09:24.923122 |
| MPC_primarydb | primary_objects | 1602803 | 2026-09-08 17:36:56.511318 | 2026-09-08 18:09:25.025739 |
| MPC_mpcsbndb | primary_objects | 1602803 | 2026-09-08 17:36:56.511318 | 2026-09-08 18:09:25.431271 |
| SBN_to_AWS | primary_objects | 1602803 | 2026-09-08 17:36:56.511318 | 2026-09-08 18:09:25.593744 |
| MPC_primarydb | obs_alterations_corrections | 0 | 2026-09-08 18:09:27.249396 | |
| MPC_mpcsbndb | obs_alterations_corrections | 0 | 2026-09-08 18:09:27.36044 | |
| SBN_to_AWS | obs_alterations_corrections | 0 | 2026-09-08 18:09:27.45372 | |
| MPC_primarydb | obs_alterations_deletions | 2971142 | 2026-09-08 14:58:04.500351 | 2026-09-08 18:09:27.550812 |
| MPC_mpcsbndb | obs_alterations_deletions | 2971142 | 2026-09-08 14:58:04.500351 | 2026-09-08 18:09:28.146631 |
| SBN_to_AWS | obs_alterations_deletions | 2971142 | 2026-09-08 14:58:04.500351 | 2026-09-08 18:09:28.301649 |
| MPC_primarydb | obs_alterations_redesignations | 5218 | 2026-08-25 19:50:31.030107 | 2026-09-08 18:09:28.706704 |
| MPC_mpcsbndb | obs_alterations_redesignations | 5218 | 2026-08-25 19:50:31.030107 | 2026-09-08 18:09:28.820045 |
| SBN_to_AWS | obs_alterations_redesignations | 5218 | 2026-08-25 19:50:31.030107 | 2026-09-08 18:09:28.914849 |
| MPC_primarydb | obs_alterations_unassociations | 605236 | 2026-09-08 14:56:03.822942 | 2026-09-08 18:09:29.018321 |
| MPC_mpcsbndb | obs_alterations_unassociations | 605236 | 2026-09-08 14:56:03.822942 | 2026-09-08 18:09:29.271479 |
| SBN_to_AWS | obs_alterations_unassociations | 605236 | 2026-09-08 14:56:03.822942 | 2026-09-08 18:09:29.400229 |