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-16 05:30:02 (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 | 12712 | 2026-06-15 21:35:01 | 2026-06-15 22:01:02 |
| identifications | 222495 | 2026-06-15 12:16:54 | 2026-06-15 12:16:54 |
| isolated_tracklets | 50757031 | 2026-06-16 05:28:20 | 2026-06-16 05:28: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 | 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 | 524365423 | 2026-06-16 05:09:28 | 2026-06-16 05:09:28 |
| orbit_uncertainties | 787193 | 2019-06-03 12:14:45 | 2022-06-02 16:46:34 |
| orbits | 1564313 | 2026-06-16 05:09:32 | 2026-06-16 05:09:32 |
| radar_observations | 1507 | 2024-12-04 04:59:18 | 2024-12-04 04:59:18 |
| Table | Count | Created_at | Updated_at |
| neocp_els | 28 | 2026-06-13 15:39:53.733887 | 2026-06-16 05:33:28.547658 |
| neocp_events | 326426 | 2026-06-16 05:33:28.735292 | 2026-06-16 05:33:28.735292 |
| neocp_obs_archive | 816048 | 2026-06-16 05:28:31.311003 | 2026-06-16 05:28:31.311003 |
| neocp_obs | 282 | 2026-06-16 05:28:31.305581 | 2026-06-16 05:28:31.305581 |
| neocp_prev_des | 72735 | 2026-06-16 05:08:59.080489 | 2026-06-16 05:08:59.080489 |
| neocp_var | 68671 | 2026-06-16 05:33:28.608803 | 2026-06-16 05:33:28.608803 |
| current_identifications | 2079159 | 2026-06-16 05:08:27.098731 | 2026-06-16 05:09:08.386082 |
| numbered_identifications | 896611 | 2026-06-02 22:27:20.380719 | 2026-06-03 16:22:06.978451 |
| primary_objects | 1589575 | 2026-06-16 05:08:27.035317 | 2026-06-16 05:08:27.035317 |
| obs_sbn | 541071809 | 2026-06-15 13:34:12.355233-04 | 2026-06-16 01:33:22.107344-04 |
| obs_alterations_deletions | 1748008 | 2026-06-16 04:24:19.338431 | 2026-06-16 04:24:19.338431 |
| obs_alterations_redesignations | 5100 | 2026-06-12 04:57:52.114214 | 2026-06-12 04:57:52.114214 |
| obs_alterations_unassociations | 589044 | 2026-06-15 21:27:34.473381 | 2026-06-15 21:27:34.473381 |
| mpc_orbits | 1554874 | 2021-02-04 01:42:01.198059 | 2026-06-16 05:30:12.867616 |
| minor_planet_names | 26233 | 2026-01-12 18:42:40.541646 | 2026-06-09 20:34:29.81277 |
| obscodes | 2708 | 2026-06-15 21:25:35.972736 | 2026-06-15 21:25:35.972736 |
| comet_names | 4380 | 2026-06-15 20:56:35.141471 | 2026-06-15 20:56:35.141471 |
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 | 541071454 | 2026-06-16 05:00:01.075028 | 2026-06-16 05:00:02.228224 |
| MPC_mpcsbndb | obs_sbn | 541071676 | 2026-06-16 05:01:41.920991 | 2026-06-16 05:01:49.200414 |
| SBN_to_AWS | obs_sbn | 541071676 | 2026-06-16 05:01:41.920991 | 2026-06-16 05:03:04.050799 |
| MPC_primarydb | current_identifications | 2079159 | 2026-06-16 05:09:08.386082 | 2026-06-16 05:32:05.065438 |
| MPC_mpcsbndb | current_identifications | 2079159 | 2026-06-16 05:09:08.386082 | 2026-06-16 05:32:13.924231 |
| SBN_to_AWS | current_identifications | 2079159 | 2026-06-16 05:09:08.386082 | 2026-06-16 05:32:14.096544 |
| MPC_primarydb | comet_names | 4380 | 2026-06-15 20:56:35.141471 | 2026-06-16 05:32:14.819623 |
| MPC_mpcsbndb | comet_names | 4380 | 2026-06-15 20:56:35.141471 | 2026-06-16 05:32:14.933359 |
| SBN_to_AWS | comet_names | 4380 | 2026-06-15 20:56:35.141471 | 2026-06-16 05:32:15.019021 |
| MPC_primarydb | minor_planet_names | 26233 | 2026-06-09 20:34:29.81277 | 2026-06-16 05:32:15.113764 |
| MPC_mpcsbndb | minor_planet_names | 26233 | 2026-06-09 20:34:29.81277 | 2026-06-16 05:32:15.3272 |
| SBN_to_AWS | minor_planet_names | 26233 | 2026-06-09 20:34:29.81277 | 2026-06-16 05:32:15.429735 |
| MPC_primarydb | mpc_orbits | 1554874 | 2026-06-16 05:30:12.867616 | 2026-06-16 05:32:15.57327 |
| MPC_mpcsbndb | mpc_orbits | 1554874 | 2026-06-16 05:30:12.867616 | 2026-06-16 05:32:38.309184 |
| SBN_to_AWS | mpc_orbits | 1554874 | 2026-06-16 05:30:12.867616 | 2026-06-16 05:32:38.656559 |
| MPC_primarydb | numbered_identifications | 896611 | 2026-06-03 16:22:06.978451 | 2026-06-16 05:32:42.994903 |
| MPC_mpcsbndb | numbered_identifications | 896611 | 2026-06-03 16:22:06.978451 | 2026-06-16 05:32:43.634259 |
| SBN_to_AWS | numbered_identifications | 896611 | 2026-06-03 16:22:06.978451 | 2026-06-16 05:32:43.766625 |
| MPC_primarydb | neocp_els | 28 | 2026-06-16 05:32:19.39663 | 2026-06-16 05:32:44.050232 |
| MPC_mpcsbndb | neocp_els | 28 | 2026-06-16 05:32:19.39663 | 2026-06-16 05:32:44.158436 |
| SBN_to_AWS | neocp_els | 28 | 2026-06-16 05:32:19.39663 | 2026-06-16 05:32:44.240013 |
| MPC_primarydb | neocp_events | 326424 | 2026-06-16 05:32:19.594527 | 2026-06-16 05:32:44.327378 |
| MPC_mpcsbndb | neocp_events | 326424 | 2026-06-16 05:32:19.594527 | 2026-06-16 05:32:44.799126 |
| SBN_to_AWS | neocp_events | 326424 | 2026-06-16 05:32:19.594527 | 2026-06-16 05:32:44.916445 |
| MPC_primarydb | neocp_obs | 282 | 2026-06-16 05:28:31.305581 | 2026-06-16 05:32:45.073529 |
| MPC_mpcsbndb | neocp_obs | 282 | 2026-06-16 05:28:31.305581 | 2026-06-16 05:32:45.181613 |
| SBN_to_AWS | neocp_obs | 282 | 2026-06-16 05:28:31.305581 | 2026-06-16 05:32:45.263618 |
| MPC_primarydb | neocp_obs_archive | 816048 | 2026-06-16 05:28:31.311003 | 2026-06-16 05:32:45.354601 |
| MPC_mpcsbndb | neocp_obs_archive | 816048 | 2026-06-16 05:28:31.311003 | 2026-06-16 05:32:45.625361 |
| SBN_to_AWS | neocp_obs_archive | 816048 | 2026-06-16 05:28:31.311003 | 2026-06-16 05:32:45.762701 |
| MPC_primarydb | neocp_prev_des | 72735 | 2026-06-16 05:08:59.080489 | 2026-06-16 05:32:45.994285 |
| MPC_mpcsbndb | neocp_prev_des | 72735 | 2026-06-16 05:08:59.080489 | 2026-06-16 05:32:46.152282 |
| SBN_to_AWS | neocp_prev_des | 72735 | 2026-06-16 05:08:59.080489 | 2026-06-16 05:32:46.251019 |
| MPC_primarydb | neocp_var | 68692 | 2026-06-16 05:32:19.4626 | 2026-06-16 05:32:46.367722 |
| MPC_mpcsbndb | neocp_var | 68692 | 2026-06-16 05:32:19.4626 | 2026-06-16 05:32:46.518483 |
| SBN_to_AWS | neocp_var | 68692 | 2026-06-16 05:32:19.4626 | 2026-06-16 05:32:46.623501 |
| MPC_primarydb | obscodes | 2708 | 2026-06-15 21:25:35.972736 | 2026-06-16 05:32:46.763895 |
| MPC_mpcsbndb | obscodes | 2708 | 2026-06-15 21:25:35.972736 | 2026-06-16 05:32:46.911302 |
| SBN_to_AWS | obscodes | 2708 | 2026-06-15 21:25:35.972736 | 2026-06-16 05:32:46.995638 |
| MPC_primarydb | primary_objects | 1589575 | 2026-06-16 05:08:27.035317 | 2026-06-16 05:32:47.086949 |
| MPC_mpcsbndb | primary_objects | 1589575 | 2026-06-16 05:08:27.035317 | 2026-06-16 05:32:48.026593 |
| SBN_to_AWS | primary_objects | 1589575 | 2026-06-16 05:08:27.035317 | 2026-06-16 05:32:48.236267 |
| MPC_primarydb | obs_alterations_corrections | 0 | 2026-06-16 05:32:49.848312 | |
| MPC_mpcsbndb | obs_alterations_corrections | 0 | 2026-06-16 05:32:49.957062 | |
| SBN_to_AWS | obs_alterations_corrections | 0 | 2026-06-16 05:32:50.038222 | |
| MPC_primarydb | obs_alterations_deletions | 1748008 | 2026-06-16 04:24:19.338431 | 2026-06-16 05:32:50.1235 |
| MPC_mpcsbndb | obs_alterations_deletions | 1748008 | 2026-06-16 04:24:19.338431 | 2026-06-16 05:32:51.549275 |
| SBN_to_AWS | obs_alterations_deletions | 1748008 | 2026-06-16 04:24:19.338431 | 2026-06-16 05:32:51.706533 |
| MPC_primarydb | obs_alterations_redesignations | 5100 | 2026-06-12 04:57:52.114214 | 2026-06-16 05:32:52.07167 |
| MPC_mpcsbndb | obs_alterations_redesignations | 5100 | 2026-06-12 04:57:52.114214 | 2026-06-16 05:32:52.190415 |
| SBN_to_AWS | obs_alterations_redesignations | 5100 | 2026-06-12 04:57:52.114214 | 2026-06-16 05:32:52.274776 |
| MPC_primarydb | obs_alterations_unassociations | 589044 | 2026-06-15 21:27:34.473381 | 2026-06-16 05:32:52.365668 |
| MPC_mpcsbndb | obs_alterations_unassociations | 589044 | 2026-06-15 21:27:34.473381 | 2026-06-16 05:32:52.804706 |
| SBN_to_AWS | obs_alterations_unassociations | 589044 | 2026-06-15 21:27:34.473381 | 2026-06-16 05:32:52.932505 |