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-18 22: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 | 222575 | 2026-06-18 12:17:05 | 2026-06-18 12:17:05 |
| isolated_tracklets | 50758287 | 2026-06-18 22:28:19 | 2026-06-18 22:28:19 |
| 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 | 524368480 | 2026-06-18 21:36:55 | 2026-06-18 21:36:55 |
| orbit_uncertainties | 787193 | 2019-06-03 12:14:45 | 2022-06-02 16:46:34 |
| orbits | 1564336 | 2026-06-18 21:37:00 | 2026-06-18 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 | 27 | 2026-06-18 08:56:55.594618 | 2026-06-18 21:28:27.10411 |
| neocp_events | 326741 | 2026-06-18 21:36:26.597932 | 2026-06-18 21:36:26.597932 |
| neocp_obs_archive | 816690 | 2026-06-18 21:28:27.022403 | 2026-06-18 21:28:27.022403 |
| neocp_obs | 212 | 2026-06-18 21:28:26.980583 | 2026-06-18 21:28:26.980583 |
| neocp_prev_des | 72780 | 2026-06-18 21:36:26.50613 | 2026-06-18 21:36:26.50613 |
| neocp_var | 66492 | 2026-06-18 21:28:27.194379 | 2026-06-18 21:28:27.194379 |
| current_identifications | 2079212 | 2026-06-18 21:35:53.336763 | 2026-06-18 21:36:34.805172 |
| numbered_identifications | 896611 | 2026-06-02 22:27:20.380719 | 2026-06-03 16:22:06.978451 |
| primary_objects | 1589601 | 2026-06-18 21:35:53.30886 | 2026-06-18 21:35:53.30886 |
| obs_sbn | 541201220 | 2026-06-18 18:20:21.507163-04 | 2026-06-18 18:28:17.68154-04 |
| obs_alterations_deletions | 1797519 | 2026-06-18 20:53:27.770648 | 2026-06-18 20:53:27.770648 |
| obs_alterations_redesignations | 5100 | 2026-06-12 04:57:52.114214 | 2026-06-12 04:57:52.114214 |
| obs_alterations_unassociations | 589343 | 2026-06-18 20:12:21.417205 | 2026-06-18 20:12:21.417205 |
| mpc_orbits | 1554905 | 2024-12-21 20:11:03.055774 | 2026-06-18 22:26:22.806432 |
| minor_planet_names | 26233 | 2026-01-12 18:42:40.541646 | 2026-06-09 20:34:29.81277 |
| obscodes | 2708 | 2019-05-25 00:11:26.580525 | 2026-06-18 16:17:11.118592 |
| 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 | 541201144 | 2026-06-18 21:58:13.187443 | 2026-06-18 22:00:02.383622 |
| MPC_mpcsbndb | obs_sbn | 541201144 | 2026-06-18 21:58:13.187443 | 2026-06-18 22:00:20.66789 |
| SBN_to_AWS | obs_sbn | 541201144 | 2026-06-18 21:58:13.187443 | 2026-06-18 22:00:44.390364 |
| MPC_primarydb | current_identifications | 2079212 | 2026-06-18 21:36:34.805172 | 2026-06-18 22:30:15.899828 |
| MPC_mpcsbndb | current_identifications | 2079212 | 2026-06-18 21:36:34.805172 | 2026-06-18 22:30:16.75128 |
| SBN_to_AWS | current_identifications | 2079212 | 2026-06-18 21:36:34.805172 | 2026-06-18 22:30:16.907152 |
| MPC_primarydb | comet_names | 4380 | 2026-06-15 20:56:35.141471 | 2026-06-18 22:30:17.628265 |
| MPC_mpcsbndb | comet_names | 4380 | 2026-06-15 20:56:35.141471 | 2026-06-18 22:30:17.738789 |
| SBN_to_AWS | comet_names | 4380 | 2026-06-15 20:56:35.141471 | 2026-06-18 22:30:17.820648 |
| MPC_primarydb | minor_planet_names | 26233 | 2026-06-09 20:34:29.81277 | 2026-06-18 22:30:17.914302 |
| MPC_mpcsbndb | minor_planet_names | 26233 | 2026-06-09 20:34:29.81277 | 2026-06-18 22:30:18.053696 |
| SBN_to_AWS | minor_planet_names | 26233 | 2026-06-09 20:34:29.81277 | 2026-06-18 22:30:18.146718 |
| MPC_primarydb | mpc_orbits | 1554905 | 2026-06-18 22:26:22.806432 | 2026-06-18 22:30:18.289063 |
| MPC_mpcsbndb | mpc_orbits | 1554905 | 2026-06-18 22:26:22.806432 | 2026-06-18 22:30:19.835297 |
| SBN_to_AWS | mpc_orbits | 1554905 | 2026-06-18 22:26:22.806432 | 2026-06-18 22:30:20.192938 |
| MPC_primarydb | numbered_identifications | 896611 | 2026-06-03 16:22:06.978451 | 2026-06-18 22:30:24.84304 |
| MPC_mpcsbndb | numbered_identifications | 896611 | 2026-06-03 16:22:06.978451 | 2026-06-18 22:30:25.109669 |
| SBN_to_AWS | numbered_identifications | 896611 | 2026-06-03 16:22:06.978451 | 2026-06-18 22:30:25.237867 |
| MPC_primarydb | neocp_els | 26 | 2026-06-18 15:14:17.877123 | 2026-06-18 22:30:25.529352 |
| MPC_mpcsbndb | neocp_els | 26 | 2026-06-18 15:14:17.877123 | 2026-06-18 22:30:25.636096 |
| SBN_to_AWS | neocp_els | 26 | 2026-06-18 15:14:17.877123 | 2026-06-18 22:30:25.717034 |
| MPC_primarydb | neocp_events | 326741 | 2026-06-18 21:36:26.597932 | 2026-06-18 22:30:25.806262 |
| MPC_mpcsbndb | neocp_events | 326741 | 2026-06-18 21:36:26.597932 | 2026-06-18 22:30:25.974073 |
| SBN_to_AWS | neocp_events | 326741 | 2026-06-18 21:36:26.597932 | 2026-06-18 22:30:26.08691 |
| MPC_primarydb | neocp_obs | 196 | 2026-06-18 15:14:17.753736 | 2026-06-18 22:30:26.238333 |
| MPC_mpcsbndb | neocp_obs | 196 | 2026-06-18 15:14:17.753736 | 2026-06-18 22:30:26.346022 |
| SBN_to_AWS | neocp_obs | 196 | 2026-06-18 15:14:17.753736 | 2026-06-18 22:30:26.427496 |
| MPC_primarydb | neocp_obs_archive | 816690 | 2026-06-18 21:28:27.022403 | 2026-06-18 22:30:26.518299 |
| MPC_mpcsbndb | neocp_obs_archive | 816690 | 2026-06-18 21:28:27.022403 | 2026-06-18 22:30:26.708957 |
| SBN_to_AWS | neocp_obs_archive | 816690 | 2026-06-18 21:28:27.022403 | 2026-06-18 22:30:26.836713 |
| MPC_primarydb | neocp_prev_des | 72780 | 2026-06-18 21:36:26.50613 | 2026-06-18 22:30:27.065316 |
| MPC_mpcsbndb | neocp_prev_des | 72780 | 2026-06-18 21:36:26.50613 | 2026-06-18 22:30:27.201741 |
| SBN_to_AWS | neocp_prev_des | 72780 | 2026-06-18 21:36:26.50613 | 2026-06-18 22:30:27.296974 |
| MPC_primarydb | neocp_var | 64492 | 2026-06-18 15:14:17.967654 | 2026-06-18 22:30:27.412713 |
| MPC_mpcsbndb | neocp_var | 64492 | 2026-06-18 15:14:17.967654 | 2026-06-18 22:30:27.558198 |
| SBN_to_AWS | neocp_var | 64492 | 2026-06-18 15:14:17.967654 | 2026-06-18 22:30:27.662354 |
| MPC_primarydb | obscodes | 2708 | 2026-06-18 16:17:11.118592 | 2026-06-18 22:30:27.799241 |
| MPC_mpcsbndb | obscodes | 2708 | 2026-06-18 16:17:11.118592 | 2026-06-18 22:30:27.918041 |
| SBN_to_AWS | obscodes | 2708 | 2026-06-18 16:17:11.118592 | 2026-06-18 22:30:28.000421 |
| MPC_primarydb | primary_objects | 1589601 | 2026-06-18 21:35:53.30886 | 2026-06-18 22:30:28.09092 |
| MPC_mpcsbndb | primary_objects | 1589601 | 2026-06-18 21:35:53.30886 | 2026-06-18 22:30:28.536325 |
| SBN_to_AWS | primary_objects | 1589601 | 2026-06-18 21:35:53.30886 | 2026-06-18 22:30:28.71869 |
| MPC_primarydb | obs_alterations_corrections | 0 | 2026-06-18 22:30:30.320203 | |
| MPC_mpcsbndb | obs_alterations_corrections | 0 | 2026-06-18 22:30:30.428362 | |
| SBN_to_AWS | obs_alterations_corrections | 0 | 2026-06-18 22:30:30.508712 | |
| MPC_primarydb | obs_alterations_deletions | 1797519 | 2026-06-18 20:53:27.770648 | 2026-06-18 22:30:30.594208 |
| MPC_mpcsbndb | obs_alterations_deletions | 1797519 | 2026-06-18 20:53:27.770648 | 2026-06-18 22:30:31.042013 |
| SBN_to_AWS | obs_alterations_deletions | 1797519 | 2026-06-18 20:53:27.770648 | 2026-06-18 22:30:31.185925 |
| MPC_primarydb | obs_alterations_redesignations | 5100 | 2026-06-12 04:57:52.114214 | 2026-06-18 22:30:31.574115 |
| MPC_mpcsbndb | obs_alterations_redesignations | 5100 | 2026-06-12 04:57:52.114214 | 2026-06-18 22:30:31.685447 |
| SBN_to_AWS | obs_alterations_redesignations | 5100 | 2026-06-12 04:57:52.114214 | 2026-06-18 22:30:31.768126 |
| MPC_primarydb | obs_alterations_unassociations | 589343 | 2026-06-18 20:12:21.417205 | 2026-06-18 22:30:31.858418 |
| MPC_mpcsbndb | obs_alterations_unassociations | 589343 | 2026-06-18 20:12:21.417205 | 2026-06-18 22:30:32.091156 |
| SBN_to_AWS | obs_alterations_unassociations | 589343 | 2026-06-18 20:12:21.417205 | 2026-06-18 22:30:32.209968 |