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-10-16 22:40: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 | 12845 | 2025-01-03 03:38:20 | 2026-10-14 22:01:05 |
| identifications | 223187 | 2026-07-14 12:33:56 | 2026-07-14 12:33:56 |
| isolated_tracklets | 50791006 | 2026-10-16 14:08:17 | 2026-10-16 14:08: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 | 2026-06-03 02:57:19 | 2026-09-08 14:26:32 |
| 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 | 524504861 | 2026-10-16 22:09:27 | 2026-10-16 22:09:27 |
| orbit_uncertainties | 787193 | 2019-06-03 12:14:45 | 2022-06-02 16:46:34 |
| orbits | 1588592 | 2026-10-16 22:09:32 | 2026-10-16 22: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 | 76 | 2026-10-16 07:26:19.421982 | 2026-10-16 22:43:31.765605 |
| neocp_events | 344894 | 2026-10-16 22:43:31.718861 | 2026-10-16 22:43:31.718861 |
| neocp_obs_archive | 849997 | 2026-10-16 22:43:31.712552 | 2026-10-16 22:43:31.712552 |
| neocp_obs | 1810 | 2026-10-16 22:43:31.712552 | 2026-10-16 22:43:31.712552 |
| neocp_prev_des | 74902 | 2026-10-16 22:38:05.485017 | 2026-10-16 22:38:05.485017 |
| neocp_var | 134684 | 2026-10-16 22:43:31.850844 | 2026-10-16 22:43:31.850844 |
| current_identifications | 2104014 | 2026-10-16 22:43:48.255852 | 2026-10-16 22:43:48.255852 |
| numbered_identifications | 896611 | 2026-06-02 22:27:20.380719 | 2026-06-03 16:22:06.978451 |
| primary_objects | 1613510 | 2026-10-16 22:43:48.192344 | 2026-10-16 22:43:48.192344 |
| obs_sbn | 558813459 | 2026-10-12 09:26:57.657582-04 | 2026-10-16 18:43:51.430854-04 |
| obs_alterations_deletions | 3461628 | 2026-10-16 18:16:16.083808 | 2026-10-16 18:16:16.083808 |
| obs_alterations_redesignations | 5218 | 2026-08-25 19:50:31.030107 | 2026-08-25 19:50:31.030107 |
| obs_alterations_unassociations | 608509 | 2026-10-16 18:10:09.797567 | 2026-10-16 18:10:09.797567 |
| mpc_orbits | 1579417 | 2026-10-16 22:43:30.47488 | 2026-10-16 22:43:48.115046 |
| minor_planet_names | 26688 | 2011-10-28 10:08:52 | 2026-09-08 18:26:32.060609 |
| obscodes | 2734 | 2026-10-16 19:01:46.048825 | 2026-10-16 19:01:46.048825 |
| comet_names | 4397 | 2026-10-08 15:56:24.808096 | 2026-10-08 15:59:07.78986 |
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 | 558813172 | 2026-10-16 21:59:23.307147 | 2026-10-16 22:00:02.10181 |
| MPC_mpcsbndb | obs_sbn | 558813176 | 2026-10-16 22:00:09.034193 | 2026-10-16 22:00:19.02586 |
| SBN_to_AWS | obs_sbn | 558813176 | 2026-10-16 22:00:55.136791 | 2026-10-16 22:00:59.608847 |
| MPC_primarydb | current_identifications | 2103997 | 2026-10-16 22:11:27.559046 | 2026-10-16 22:14:39.010043 |
| MPC_mpcsbndb | current_identifications | 2103997 | 2026-10-16 22:11:27.559046 | 2026-10-16 22:14:39.756485 |
| SBN_to_AWS | current_identifications | 2103997 | 2026-10-16 22:11:27.559046 | 2026-10-16 22:14:39.922809 |
| MPC_primarydb | comet_names | 4397 | 2026-10-08 15:59:07.78986 | 2026-10-16 22:14:40.71557 |
| MPC_mpcsbndb | comet_names | 4397 | 2026-10-08 15:59:07.78986 | 2026-10-16 22:14:40.825164 |
| SBN_to_AWS | comet_names | 4397 | 2026-10-08 15:59:07.78986 | 2026-10-16 22:14:40.91866 |
| MPC_primarydb | minor_planet_names | 26688 | 2026-09-08 18:26:32.060609 | 2026-10-16 22:14:41.0228 |
| MPC_mpcsbndb | minor_planet_names | 26688 | 2026-09-08 18:26:32.060609 | 2026-10-16 22:14:41.169074 |
| SBN_to_AWS | minor_planet_names | 26688 | 2026-09-08 18:26:32.060609 | 2026-10-16 22:14:41.281318 |
| MPC_primarydb | mpc_orbits | 1579401 | 2026-10-16 22:12:01.263333 | 2026-10-16 22:14:41.488943 |
| MPC_mpcsbndb | mpc_orbits | 1579401 | 2026-10-16 22:12:01.263333 | 2026-10-16 22:14:47.707722 |
| SBN_to_AWS | mpc_orbits | 1579401 | 2026-10-16 22:12:01.263333 | 2026-10-16 22:14:48.061609 |
| MPC_primarydb | numbered_identifications | 896611 | 2026-06-03 16:22:06.978451 | 2026-10-16 22:14:51.45272 |
| MPC_mpcsbndb | numbered_identifications | 896611 | 2026-06-03 16:22:06.978451 | 2026-10-16 22:14:51.737198 |
| SBN_to_AWS | numbered_identifications | 896611 | 2026-06-03 16:22:06.978451 | 2026-10-16 22:14:51.885541 |
| MPC_primarydb | neocp_els | 76 | 2026-10-16 22:09:16.245407 | 2026-10-16 22:14:52.186855 |
| MPC_mpcsbndb | neocp_els | 76 | 2026-10-16 22:09:16.245407 | 2026-10-16 22:14:52.298388 |
| SBN_to_AWS | neocp_els | 76 | 2026-10-16 22:09:16.245407 | 2026-10-16 22:14:52.391115 |
| MPC_primarydb | neocp_events | 344885 | 2026-10-16 22:09:16.401943 | 2026-10-16 22:14:52.490649 |
| MPC_mpcsbndb | neocp_events | 344885 | 2026-10-16 22:09:16.401943 | 2026-10-16 22:14:52.671779 |
| SBN_to_AWS | neocp_events | 344885 | 2026-10-16 22:09:16.401943 | 2026-10-16 22:14:52.809586 |
| MPC_primarydb | neocp_obs | 1810 | 2026-10-16 22:09:16.132783 | 2026-10-16 22:14:52.981437 |
| MPC_mpcsbndb | neocp_obs | 1810 | 2026-10-16 22:09:16.132783 | 2026-10-16 22:14:53.092777 |
| SBN_to_AWS | neocp_obs | 1810 | 2026-10-16 22:09:16.132783 | 2026-10-16 22:14:53.188259 |
| MPC_primarydb | neocp_obs_archive | 849976 | 2026-10-16 22:09:16.132783 | 2026-10-16 22:14:53.292759 |
| MPC_mpcsbndb | neocp_obs_archive | 849976 | 2026-10-16 22:09:16.132783 | 2026-10-16 22:14:53.505184 |
| SBN_to_AWS | neocp_obs_archive | 849976 | 2026-10-16 22:09:16.132783 | 2026-10-16 22:14:53.656805 |
| MPC_primarydb | neocp_prev_des | 74901 | 2026-10-16 22:07:34.602606 | 2026-10-16 22:14:53.928286 |
| MPC_mpcsbndb | neocp_prev_des | 74901 | 2026-10-16 22:07:34.602606 | 2026-10-16 22:14:54.072768 |
| SBN_to_AWS | neocp_prev_des | 74901 | 2026-10-16 22:07:34.602606 | 2026-10-16 22:14:54.181113 |
| MPC_primarydb | neocp_var | 134684 | 2026-10-16 22:09:16.192681 | 2026-10-16 22:14:54.309876 |
| MPC_mpcsbndb | neocp_var | 134684 | 2026-10-16 22:09:16.192681 | 2026-10-16 22:14:54.489362 |
| SBN_to_AWS | neocp_var | 134684 | 2026-10-16 22:09:16.192681 | 2026-10-16 22:14:54.608979 |
| MPC_primarydb | obscodes | 2734 | 2026-10-16 19:01:46.048825 | 2026-10-16 22:14:54.811623 |
| MPC_mpcsbndb | obscodes | 2734 | 2026-10-16 19:01:46.048825 | 2026-10-16 22:14:54.936461 |
| SBN_to_AWS | obscodes | 2734 | 2026-10-16 19:01:46.048825 | 2026-10-16 22:14:55.030542 |
| MPC_primarydb | primary_objects | 1613493 | 2026-10-16 22:09:47.353695 | 2026-10-16 22:14:55.131028 |
| MPC_mpcsbndb | primary_objects | 1613493 | 2026-10-16 22:09:47.353695 | 2026-10-16 22:14:55.50384 |
| SBN_to_AWS | primary_objects | 1613493 | 2026-10-16 22:09:47.353695 | 2026-10-16 22:14:55.726754 |
| MPC_primarydb | obs_alterations_corrections | 0 | 2026-10-16 22:14:57.410482 | |
| MPC_mpcsbndb | obs_alterations_corrections | 0 | 2026-10-16 22:14:57.520124 | |
| SBN_to_AWS | obs_alterations_corrections | 0 | 2026-10-16 22:14:57.611966 | |
| MPC_primarydb | obs_alterations_deletions | 3461628 | 2026-10-16 18:16:16.083808 | 2026-10-16 22:14:57.707789 |
| MPC_mpcsbndb | obs_alterations_deletions | 3461628 | 2026-10-16 18:16:16.083808 | 2026-10-16 22:14:58.315757 |
| SBN_to_AWS | obs_alterations_deletions | 3461628 | 2026-10-16 18:16:16.083808 | 2026-10-16 22:14:58.503515 |
| MPC_primarydb | obs_alterations_redesignations | 5218 | 2026-08-25 19:50:31.030107 | 2026-10-16 22:14:58.878017 |
| MPC_mpcsbndb | obs_alterations_redesignations | 5218 | 2026-08-25 19:50:31.030107 | 2026-10-16 22:14:58.990676 |
| SBN_to_AWS | obs_alterations_redesignations | 5218 | 2026-08-25 19:50:31.030107 | 2026-10-16 22:14:59.085264 |
| MPC_primarydb | obs_alterations_unassociations | 608509 | 2026-10-16 18:10:09.797567 | 2026-10-16 22:14:59.186588 |
| MPC_mpcsbndb | obs_alterations_unassociations | 608509 | 2026-10-16 18:10:09.797567 | 2026-10-16 22:14:59.45731 |
| SBN_to_AWS | obs_alterations_unassociations | 608509 | 2026-10-16 18:10:09.797567 | 2026-10-16 22:14:59.58922 |