Instructions (not for the faint of heart) for replicating the database are posted. Questions/issues related to replication should be directed to Andrei Mamoutkine.
2025-05-31 22:50: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 | 5206 | 2025-04-09 15:30:27 | 2025-04-09 15:30:27 |
comet_orbits | 9978 | 2025-05-27 17:46:53 | 2025-05-27 18:01:03 |
identifications | 206013 | 2025-05-22 12:15:03 | 2025-05-22 12:15:03 |
isolated_tracklets | 48665604 | 2025-05-31 22:39:48 | 2025-05-31 22:39:48 |
mp_discoverers | 1937677 | 2014-10-19 04:36:17 | 2025-01-30 01:06:24 |
numbered_comet_identifications | 1087 | 2025-04-05 10:20:36 | 2025-04-05 10:20:36 |
numbered_identifications | 1221099 | 2025-04-04 17:20:59 | 2025-04-04 17:20:59 |
numbered_mps | 793066 | 2019-05-24 00:33:02 | 2025-05-28 16:38:01 |
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 | 478378272 | 2025-05-31 16:02:43 | 2025-05-31 16:02:43 |
orbit_uncertainties | 787193 | 2019-06-03 12:14:45 | 2022-06-02 16:46:34 |
orbits | 1467511 | 2020-08-13 23:47:11 | 2025-05-31 17: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 | 59 | 2025-05-30 13:14:04.017584 | 2025-05-31 21:48:22.673271 |
neocp_events | 274882 | 2025-05-31 21:48:22.837119 | 2025-05-31 21:48:22.837119 |
neocp_obs_archive | 698608 | 2025-05-31 21:48:22.669785 | 2025-05-31 21:48:22.669785 |
neocp_obs | 457 | 2025-05-31 21:48:22.66186 | 2025-05-31 21:48:22.66186 |
neocp_prev_des | 66169 | 2025-05-31 15:49:31.822312 | 2025-05-31 15:49:31.822312 |
neocp_var | 115214 | 2025-05-31 21:48:22.708935 | 2025-05-31 21:48:22.708935 |
current_identifications | 1976997 | 2025-05-31 20:24:52.555408 | 2025-05-31 20:25:41.197185 |
numbered_identifications | 793862 | 2025-03-31 20:41:42.296919 | 2025-03-31 20:41:42.296919 |
primary_objects | 1495449 | 2025-05-31 20:24:52.528296 | 2025-05-31 20:24:52.528296 |
obs_sbn | 490733965 | 2025-05-31 12:06:32.364194-04 | 2025-05-31 18:48:55.791702-04 |
obs_alterations_deletions | 1358318 | 2025-05-31 13:05:36.706633 | 2025-05-31 13:05:36.706633 |
obs_alterations_redesignations | 4254 | 2025-05-27 01:34:46.695928 | 2025-05-27 01:34:46.695928 |
obs_alterations_unassociations | 411561 | 2025-05-31 12:26:13.633907 | 2025-05-31 12:26:13.633907 |
mpc_orbits | 1447925 | 2021-02-04 00:15:41.929432 | 2025-05-31 22:43:10.636706 |
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 | 490726414 | 2025-05-31 21:48:10.054925 | 2025-05-31 22:00:02.482285 |
MPC_mpcsbndb | obs_sbn | 490726414 | 2025-05-31 21:48:10.054925 | 2025-05-31 22:00:23.5298 |
SBN_to_AWS | obs_sbn | 490726414 | 2025-05-31 21:48:10.054925 | 2025-05-31 22:00:37.87887 |
MPC_primarydb | current_identifications | 1976997 | 2025-05-31 20:25:41.197185 | 2025-05-31 22:30:49.88774 |
MPC_mpcsbndb | current_identifications | 1976997 | 2025-05-31 20:25:41.197185 | 2025-05-31 22:30:50.535637 |
SBN_to_AWS | current_identifications | 1976997 | 2025-05-31 20:25:41.197185 | 2025-05-31 22:30:50.761521 |
MPC_primarydb | mpc_orbits | 1447925 | 2025-05-31 22:26:22.368259 | 2025-05-31 22:30:51.294448 |
MPC_mpcsbndb | mpc_orbits | 1447925 | 2025-05-31 22:26:22.368259 | 2025-05-31 22:30:52.675463 |
SBN_to_AWS | mpc_orbits | 1447925 | 2025-05-31 22:26:22.368259 | 2025-05-31 22:30:52.892281 |
MPC_primarydb | numbered_identifications | 793862 | 2025-03-31 20:41:42.296919 | 2025-05-31 22:30:53.941297 |
MPC_mpcsbndb | numbered_identifications | 793862 | 2025-03-31 20:41:42.296919 | 2025-05-31 22:30:54.274537 |
SBN_to_AWS | numbered_identifications | 793862 | 2025-03-31 20:41:42.296919 | 2025-05-31 22:30:54.404851 |
MPC_primarydb | neocp_els | 59 | 2025-05-31 21:48:22.673271 | 2025-05-31 22:30:54.551439 |
MPC_mpcsbndb | neocp_els | 59 | 2025-05-31 21:48:22.673271 | 2025-05-31 22:30:54.654387 |
SBN_to_AWS | neocp_els | 59 | 2025-05-31 21:48:22.673271 | 2025-05-31 22:30:54.741776 |
MPC_primarydb | neocp_events | 274882 | 2025-05-31 21:48:22.837119 | 2025-05-31 22:30:54.835359 |
MPC_mpcsbndb | neocp_events | 274882 | 2025-05-31 21:48:22.837119 | 2025-05-31 22:30:55.027501 |
SBN_to_AWS | neocp_events | 274882 | 2025-05-31 21:48:22.837119 | 2025-05-31 22:30:55.141112 |
MPC_primarydb | neocp_obs | 457 | 2025-05-31 21:48:22.66186 | 2025-05-31 22:30:55.261036 |
MPC_mpcsbndb | neocp_obs | 457 | 2025-05-31 21:48:22.66186 | 2025-05-31 22:30:55.363441 |
SBN_to_AWS | neocp_obs | 457 | 2025-05-31 21:48:22.66186 | 2025-05-31 22:30:55.451244 |
MPC_primarydb | neocp_obs_archive | 698608 | 2025-05-31 21:48:22.669785 | 2025-05-31 22:30:55.547257 |
MPC_mpcsbndb | neocp_obs_archive | 698608 | 2025-05-31 21:48:22.669785 | 2025-05-31 22:30:55.793344 |
SBN_to_AWS | neocp_obs_archive | 698608 | 2025-05-31 21:48:22.669785 | 2025-05-31 22:30:55.921302 |
MPC_primarydb | neocp_prev_des | 66169 | 2025-05-31 15:49:31.822312 | 2025-05-31 22:30:56.062669 |
MPC_mpcsbndb | neocp_prev_des | 66169 | 2025-05-31 15:49:31.822312 | 2025-05-31 22:30:56.192229 |
SBN_to_AWS | neocp_prev_des | 66169 | 2025-05-31 15:49:31.822312 | 2025-05-31 22:30:56.294139 |
MPC_primarydb | neocp_var | 115214 | 2025-05-31 21:48:22.708935 | 2025-05-31 22:30:56.401358 |
MPC_mpcsbndb | neocp_var | 115214 | 2025-05-31 21:48:22.708935 | 2025-05-31 22:30:56.554535 |
SBN_to_AWS | neocp_var | 115214 | 2025-05-31 21:48:22.708935 | 2025-05-31 22:30:56.6804 |
MPC_primarydb | obscodes | 2620 | 2025-05-28 16:17:07.34923 | 2025-05-31 22:30:56.808207 |
MPC_mpcsbndb | obscodes | 2620 | 2025-05-28 16:17:07.34923 | 2025-05-31 22:30:56.939455 |
SBN_to_AWS | obscodes | 2620 | 2025-05-28 16:17:07.34923 | 2025-05-31 22:30:57.027786 |
MPC_primarydb | primary_objects | 1495449 | 2025-05-31 20:24:52.528296 | 2025-05-31 22:30:57.121773 |
MPC_mpcsbndb | primary_objects | 1495449 | 2025-05-31 20:24:52.528296 | 2025-05-31 22:30:57.589994 |
SBN_to_AWS | primary_objects | 1495449 | 2025-05-31 20:24:52.528296 | 2025-05-31 22:30:57.74892 |
MPC_primarydb | obs_alterations_corrections | 0 | 2025-05-31 22:30:58.377266 | |
MPC_mpcsbndb | obs_alterations_corrections | 0 | 2025-05-31 22:30:58.479457 | |
SBN_to_AWS | obs_alterations_corrections | 0 | 2025-05-31 22:30:58.566408 | |
MPC_primarydb | obs_alterations_deletions | 1358318 | 2025-05-31 13:05:36.706633 | 2025-05-31 22:30:58.657513 |
MPC_mpcsbndb | obs_alterations_deletions | 1358318 | 2025-05-31 13:05:36.706633 | 2025-05-31 22:30:59.147722 |
SBN_to_AWS | obs_alterations_deletions | 1358318 | 2025-05-31 13:05:36.706633 | 2025-05-31 22:30:59.274351 |