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-04-22 14:00: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 | 5215 | 2026-03-06 22:06:00 | 2026-03-06 22:06:00 |
| comet_orbits | 12623 | 2026-04-21 18:01:07 | 2026-04-21 18:01:07 |
| identifications | 218331 | 2026-04-14 12:33:30 | 2026-04-14 12:33:30 |
| isolated_tracklets | 49916608 | 2026-04-22 13:58:14 | 2026-04-22 13:58:14 |
| mp_discoverers | 1969147 | 2025-06-18 21:18:06 | 2025-06-18 21:18:06 |
| numbered_comet_identifications | 1292 | 2025-10-23 16:03:49 | 2025-10-23 16:03:49 |
| numbered_identifications | 1333152 | 2026-03-05 21:16:52 | 2026-03-05 21:16:52 |
| numbered_mps | 887103 | 2025-10-23 01:12:58 | 2026-04-13 15:07:38 |
| 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 | 512054290 | 2026-04-22 12:12:43 | 2026-04-22 12:12:43 |
| orbit_uncertainties | 787193 | 2019-06-03 12:14:45 | 2022-06-02 16:46:34 |
| orbits | 1538033 | 2025-10-22 15:40:03 | 2026-04-22 13:01:26 |
| radar_observations | 1507 | 2024-12-04 04:59:18 | 2024-12-04 04:59:18 |
| Table | Count | Created_at | Updated_at |
| neocp_els | 33 | 2026-04-22 13:50:21.582277 | 2026-04-22 13:50:21.582277 |
| neocp_events | 321571 | 2026-04-22 13:50:21.739975 | 2026-04-22 13:50:21.739975 |
| neocp_obs_archive | 805200 | 2026-04-22 13:50:21.47695 | 2026-04-22 13:50:21.47695 |
| neocp_obs | 566 | 2026-04-22 13:50:21.400954 | 2026-04-22 13:50:21.400954 |
| neocp_prev_des | 72101 | 2026-04-22 11:36:30.32074 | 2026-04-22 11:36:30.32074 |
| neocp_var | 73257 | 2026-04-22 13:50:21.526875 | 2026-04-22 13:50:21.526875 |
| current_identifications | 2050906 | 2026-04-22 13:26:47.023342 | 2026-04-22 13:27:18.508789 |
| numbered_identifications | 887936 | 2026-03-24 19:55:09.966554 | 2026-03-24 19:55:09.966554 |
| primary_objects | 1563374 | 2026-04-22 13:26:46.978388 | 2026-04-22 13:26:46.978388 |
| obs_sbn | 536429317 | 2026-04-22 09:55:09.349227-04 | 2026-04-22 09:58:12.124418-04 |
| obs_alterations_deletions | 1506520 | 2026-04-22 11:57:36.215473 | 2026-04-22 11:57:36.215473 |
| obs_alterations_redesignations | 5083 | 2026-04-07 06:22:54.863572 | 2026-04-07 06:22:54.863572 |
| obs_alterations_unassociations | 570111 | 2026-04-22 13:50:44.436039 | 2026-04-22 13:50:44.436039 |
| mpc_orbits | 1528059 | 2022-07-11 15:05:04.614873 | 2026-04-22 13:46:10.551329 |
| minor_planet_names | 26164 | 2011-10-27 09:47:03 | 2026-04-13 19:07:36.584479 |
| obscodes | 2692 | 2026-04-21 20:39:03.511199 | 2026-04-21 20:39:03.511199 |
| comet_names | 4372 | 2026-03-31 18:21:22.998027 | 2026-03-31 18:21:22.998027 |
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 | 536396585 | 2026-04-22 13:00:01.67268 | 2026-04-22 13:00:02.546371 |
| MPC_mpcsbndb | obs_sbn | 536396881 | 2026-04-22 13:00:23.494387 | 2026-04-22 13:00:24.518528 |
| SBN_to_AWS | obs_sbn | 536397499 | 2026-04-22 13:01:14.703225 | 2026-04-22 13:01:16.422361 |
| MPC_primarydb | current_identifications | 2050902 | 2026-04-22 11:36:40.208403 | 2026-04-22 13:11:53.562264 |
| MPC_mpcsbndb | current_identifications | 2050902 | 2026-04-22 11:36:40.208403 | 2026-04-22 13:11:54.640275 |
| SBN_to_AWS | current_identifications | 2050902 | 2026-04-22 11:36:40.208403 | 2026-04-22 13:11:54.87576 |
| MPC_primarydb | comet_names | 4372 | 2026-03-31 18:21:22.998027 | 2026-04-22 13:11:55.262205 |
| MPC_mpcsbndb | comet_names | 4372 | 2026-03-31 18:21:22.998027 | 2026-04-22 13:11:55.370609 |
| SBN_to_AWS | comet_names | 4372 | 2026-03-31 18:21:22.998027 | 2026-04-22 13:11:55.452855 |
| MPC_primarydb | minor_planet_names | 26164 | 2026-04-13 19:07:36.584479 | 2026-04-22 13:11:55.559526 |
| MPC_mpcsbndb | minor_planet_names | 26164 | 2026-04-13 19:07:36.584479 | 2026-04-22 13:11:55.718579 |
| SBN_to_AWS | minor_planet_names | 26164 | 2026-04-13 19:07:36.584479 | 2026-04-22 13:11:55.815054 |
| MPC_primarydb | mpc_orbits | 1528055 | 2026-04-22 13:11:55.005532 | 2026-04-22 13:11:55.998138 |
| MPC_mpcsbndb | mpc_orbits | 1528055 | 2026-04-22 13:11:57.857187 | 2026-04-22 13:11:58.530992 |
| SBN_to_AWS | mpc_orbits | 1528055 | 2026-04-22 13:11:57.086469 | 2026-04-22 13:11:58.915058 |
| MPC_primarydb | numbered_identifications | 887862 | 2026-03-24 19:55:09.966554 | 2026-04-22 13:12:02.164286 |
| MPC_mpcsbndb | numbered_identifications | 887862 | 2026-03-24 19:55:09.966554 | 2026-04-22 13:12:02.583912 |
| SBN_to_AWS | numbered_identifications | 887862 | 2026-03-24 19:55:09.966554 | 2026-04-22 13:12:02.718746 |
| MPC_primarydb | neocp_els | 31 | 2026-04-22 11:56:28.552684 | 2026-04-22 13:12:03.280157 |
| MPC_mpcsbndb | neocp_els | 31 | 2026-04-22 11:56:28.552684 | 2026-04-22 13:12:03.38914 |
| SBN_to_AWS | neocp_els | 31 | 2026-04-22 11:56:28.552684 | 2026-04-22 13:12:03.470868 |
| MPC_primarydb | neocp_events | 321569 | 2026-04-22 11:56:28.772196 | 2026-04-22 13:12:03.598279 |
| MPC_mpcsbndb | neocp_events | 321569 | 2026-04-22 11:56:28.772196 | 2026-04-22 13:12:03.818401 |
| SBN_to_AWS | neocp_events | 321569 | 2026-04-22 11:56:28.772196 | 2026-04-22 13:12:03.934046 |
| MPC_primarydb | neocp_obs | 561 | 2026-04-22 11:56:28.469993 | 2026-04-22 13:12:04.185963 |
| MPC_mpcsbndb | neocp_obs | 561 | 2026-04-22 11:56:28.469993 | 2026-04-22 13:12:04.296386 |
| SBN_to_AWS | neocp_obs | 561 | 2026-04-22 11:56:28.469993 | 2026-04-22 13:12:04.38107 |
| MPC_primarydb | neocp_obs_archive | 805195 | 2026-04-22 11:56:28.511177 | 2026-04-22 13:12:04.479318 |
| MPC_mpcsbndb | neocp_obs_archive | 805195 | 2026-04-22 11:56:28.511177 | 2026-04-22 13:12:04.769006 |
| SBN_to_AWS | neocp_obs_archive | 805195 | 2026-04-22 11:56:28.511177 | 2026-04-22 13:12:04.913838 |
| MPC_primarydb | neocp_prev_des | 72101 | 2026-04-22 11:36:30.32074 | 2026-04-22 13:12:05.134306 |
| MPC_mpcsbndb | neocp_prev_des | 72101 | 2026-04-22 11:36:30.32074 | 2026-04-22 13:12:05.284103 |
| SBN_to_AWS | neocp_prev_des | 72101 | 2026-04-22 11:36:30.32074 | 2026-04-22 13:12:05.381394 |
| MPC_primarydb | neocp_var | 69257 | 2026-04-22 11:56:28.637823 | 2026-04-22 13:12:05.530344 |
| MPC_mpcsbndb | neocp_var | 69257 | 2026-04-22 11:56:28.637823 | 2026-04-22 13:12:05.705025 |
| SBN_to_AWS | neocp_var | 69257 | 2026-04-22 11:56:28.637823 | 2026-04-22 13:12:05.811323 |
| MPC_primarydb | obscodes | 2692 | 2026-04-21 20:39:03.511199 | 2026-04-22 13:12:05.938054 |
| MPC_mpcsbndb | obscodes | 2692 | 2026-04-21 20:39:03.511199 | 2026-04-22 13:12:06.064763 |
| SBN_to_AWS | obscodes | 2692 | 2026-04-21 20:39:03.511199 | 2026-04-22 13:12:06.148462 |
| MPC_primarydb | primary_objects | 1563370 | 2026-04-22 11:35:57.410233 | 2026-04-22 13:12:06.249149 |
| MPC_mpcsbndb | primary_objects | 1563370 | 2026-04-22 11:35:57.410233 | 2026-04-22 13:12:06.892761 |
| SBN_to_AWS | primary_objects | 1563370 | 2026-04-22 11:35:57.410233 | 2026-04-22 13:12:07.343205 |
| MPC_primarydb | obs_alterations_corrections | 0 | 2026-04-22 13:12:08.906462 | |
| MPC_mpcsbndb | obs_alterations_corrections | 0 | 2026-04-22 13:12:09.020565 | |
| SBN_to_AWS | obs_alterations_corrections | 0 | 2026-04-22 13:12:09.103448 | |
| MPC_primarydb | obs_alterations_deletions | 1506520 | 2026-04-22 11:57:36.215473 | 2026-04-22 13:12:09.191822 |
| MPC_mpcsbndb | obs_alterations_deletions | 1506520 | 2026-04-22 11:57:36.215473 | 2026-04-22 13:12:09.782827 |
| SBN_to_AWS | obs_alterations_deletions | 1506520 | 2026-04-22 11:57:36.215473 | 2026-04-22 13:12:09.926195 |
| MPC_primarydb | obs_alterations_redesignations | 5083 | 2026-04-07 06:22:54.863572 | 2026-04-22 13:12:10.155032 |
| MPC_mpcsbndb | obs_alterations_redesignations | 5083 | 2026-04-07 06:22:54.863572 | 2026-04-22 13:12:10.272547 |
| SBN_to_AWS | obs_alterations_redesignations | 5083 | 2026-04-07 06:22:54.863572 | 2026-04-22 13:12:10.356902 |
| MPC_primarydb | obs_alterations_unassociations | 570096 | 2026-04-22 09:50:04.962652 | 2026-04-22 13:12:10.481858 |
| MPC_mpcsbndb | obs_alterations_unassociations | 570096 | 2026-04-22 09:50:04.962652 | 2026-04-22 13:12:10.870567 |
| SBN_to_AWS | obs_alterations_unassociations | 570096 | 2026-04-22 09:50:04.962652 | 2026-04-22 13:12:11.002302 |