2022-05-27 18:30:01 (GMT)
Status of all major tables from MariaDB (mpc_development) and PostgresDB (mpcbeta). 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 |
| close_approaches | 223366 | 2019-05-23 19:22:13 | 2019-05-23 19:22:13 |
| comet_names | 4586 | 2017-03-15 16:46:33 | 2017-03-15 16:46:33 |
| comet_orbit_uncertainties | 1015 | 2019-06-04 12:15:27 | 2019-06-04 12:15:27 |
| comet_orbits | 11583 | 2022-05-24 23:49:29 | 2022-05-25 00:31:08 |
| identifications | 601015 | 2022-05-18 12:06:18 | 2022-05-18 12:06:18 |
| isolated_tracklets | 37885511 | 2022-05-27 15:38:35 | 2022-05-27 15:38:35 |
| mpc_indices | 396 | 2022-05-27 18:30:01 | 2022-05-27 18:30:01 |
| numbered_identifications | 992545 | 2022-04-06 04:57:08 | 2022-04-06 04:57:08 |
| numbered_mps | 614690 | 2011-10-27 01:11:38 | 2022-05-02 20:31:33 |
| 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 | 335211677 | 2022-05-27 14:08:55 | 2022-05-27 14:08:55 |
| orbit_uncertainties | 787203 | 2019-06-05 12:14:32 | 2022-04-06 05:08:53 |
| orbits | 1208218 | 2016-12-30 15:53:00 | 2022-05-27 14:31:03 |
| perturbed_orbits | 175724170 | 2018-09-27 17:20:33 | 2018-09-27 17:20:33 |
| radar_observations | 1507 | 2019-05-30 03:12:41 | 2019-05-30 03:12:41 |
| Table | Count | Created_at | Updated_at |
| neocp_els | 67 | 2022-05-24 12:27:47.860705 | 2022-05-27 16:17:49.722794 |
| neocp_events | 136109 | 2022-05-27 16:17:54.306279 | 2022-05-27 16:17:54.306279 |
| neocp_obs_archive | 368437 | 2022-05-27 16:17:49.712074 | 2022-05-27 16:17:49.712074 |
| neocp_obs | 747 | 2022-05-27 16:17:49.705053 | 2022-05-27 16:17:49.705053 |
| neocp_prev_des | 48035 | 2022-05-27 14:39:54.586211 | 2022-05-27 14:39:54.586211 |
| neocp_var | 128184 | 2022-05-27 16:17:54.288889 | 2022-05-27 16:17:54.288889 |
| current_identifications | 1739280 | 2022-05-27 18:20:23.073459 | 2022-05-27 18:20:42.258355 |
| numbered_identifications | 615294 | 2022-04-04 19:27:12.775535 | 2022-04-04 19:27:12.775535 |
| primary_objects | 1211321 | 2021-09-28 18:55:58.729643 | 2021-09-28 18:55:58.729643 |
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