participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,332 rows where station_code = "UK003V" sorted by created_at descending
This data as json, copyable, CSV (advanced)
Suggested facets: created_at (date), updated_at (date)
Link | rowid | meteor_unique_trajectory_identifier | station_code | created_at ▲ | updated_at |
---|---|---|---|---|---|
5573082 | 5573082 | 20241121035002_69YPk | UK003V | 2024-11-22T14:19:09.072Z | 2024-11-22T14:19:22.446Z |
5572932 | 5572932 | 20241121032635_cO6Rd | UK003V | 2024-11-22T14:18:59.440Z | 2024-11-22T14:19:22.416Z |
5572814 | 5572814 | 20241121031300_3mR8C | UK003V | 2024-11-22T14:18:51.295Z | 2024-11-22T14:19:22.395Z |
5572795 | 5572795 | 20241121031028_Ai9WK | UK003V | 2024-11-22T14:18:50.579Z | 2024-11-22T14:19:22.393Z |
5572584 | 5572584 | 20241121024503_D9vow | UK003V | 2024-11-22T14:18:38.303Z | 2024-11-22T14:19:22.356Z |
5570825 | 5570825 | 20241120210944_0hZ3p | UK003V | 2024-11-22T14:16:07.852Z | 2024-11-22T14:19:21.989Z |
5570415 | 5570415 | 20241120193416_khYO0 | UK003V | 2024-11-22T14:15:21.069Z | 2024-11-22T14:19:21.914Z |
5566540 | 5566540 | 20241121063234_xtDo9 | UK003V | 2024-11-22T14:03:09.080Z | 2024-11-22T14:03:09.080Z |
5565975 | 5565975 | 20241121051237_AK4hA | UK003V | 2024-11-22T14:01:30.411Z | 2024-11-22T14:01:30.411Z |
5565910 | 5565910 | 20241121050445_yaVE2 | UK003V | 2024-11-22T14:01:23.110Z | 2024-11-22T14:01:23.110Z |
5562950 | 5562950 | 20241120003434_BjLPD | UK003V | 2024-11-21T14:15:30.010Z | 2024-11-22T14:21:06.970Z |
5562903 | 5562903 | 20241120002615_NrxiU | UK003V | 2024-11-21T14:15:26.917Z | 2024-11-22T14:21:05.925Z |
5562387 | 5562387 | 20241119233339_OtG0Y | UK003V | 2024-11-21T14:14:46.319Z | 2024-11-22T14:20:57.025Z |
5562291 | 5562291 | 20241119231956_clME5 | UK003V | 2024-11-21T14:14:40.899Z | 2024-11-22T14:20:55.369Z |
5561669 | 5561669 | 20241119212819_WQebg | UK003V | 2024-11-21T14:13:42.196Z | 2024-11-22T14:20:42.687Z |
5561498 | 5561498 | 20241119205006_29Yyd | UK003V | 2024-11-21T14:13:21.910Z | 2024-11-22T14:20:38.967Z |
5561226 | 5561226 | 20241119191028_3W14y | UK003V | 2024-11-21T14:12:42.073Z | 2024-11-22T14:20:26.936Z |
5558299 | 5558299 | 20241120055255_bP7R8 | UK003V | 2024-11-21T14:02:57.944Z | 2024-11-22T14:19:21.206Z |
5539285 | 5539285 | 20241114060528_DAWFu | UK003V | 2024-11-15T14:00:35.480Z | 2024-11-22T14:23:42.857Z |
5539085 | 5539085 | 20241113054130_DJc5z | UK003V | 2024-11-14T14:14:12.860Z | 2024-11-21T14:26:31.592Z |
5539064 | 5539064 | 20241113053957_pLRG6 | UK003V | 2024-11-14T14:14:10.721Z | 2024-11-21T14:26:31.109Z |
5538873 | 5538873 | 20241113050727_LpapR | UK003V | 2024-11-14T14:14:01.609Z | 2024-11-21T14:26:29.352Z |
5538688 | 5538688 | 20241113043713_PUQid | UK003V | 2024-11-14T14:13:49.488Z | 2024-11-21T14:26:28.532Z |
5538598 | 5538598 | 20241113041944_Ee73k | UK003V | 2024-11-14T14:13:42.745Z | 2024-11-21T14:26:27.538Z |
5538561 | 5538561 | 20241113041119_ZHTFp | UK003V | 2024-11-14T14:13:38.350Z | 2024-11-21T14:26:27.181Z |
5538468 | 5538468 | 20241113035159_Abn6O | UK003V | 2024-11-14T14:13:30.693Z | 2024-11-21T14:26:26.419Z |
5538417 | 5538417 | 20241113033557_C8i2h | UK003V | 2024-11-14T14:13:24.834Z | 2024-11-21T14:26:25.356Z |
5538380 | 5538380 | 20241113032356_a8MWM | UK003V | 2024-11-14T14:13:21.838Z | 2024-11-21T14:26:25.070Z |
5538291 | 5538291 | 20241113030008_XM86Y | UK003V | 2024-11-14T14:13:11.500Z | 2024-11-21T14:26:22.937Z |
5538280 | 5538280 | 20241113025758_ZPn9w | UK003V | 2024-11-14T14:13:11.199Z | 2024-11-21T14:26:22.931Z |
5538274 | 5538274 | 20241113025758_bmRB2 | UK003V | 2024-11-14T14:13:11.035Z | 2024-11-21T14:26:22.921Z |
5538157 | 5538157 | 20241113022508_i8ut7 | UK003V | 2024-11-14T14:12:57.806Z | 2024-11-21T14:26:21.150Z |
5538106 | 5538106 | 20241113021337_7mcqI | UK003V | 2024-11-14T14:12:51.488Z | 2024-11-21T14:26:20.749Z |
5538083 | 5538083 | 20241113020732_i633r | UK003V | 2024-11-14T14:12:49.964Z | 2024-11-21T14:26:20.617Z |
5538010 | 5538010 | 20241113015329_3WC07 | UK003V | 2024-11-14T14:12:42.857Z | 2024-11-21T14:26:18.701Z |
5537953 | 5537953 | 20241113013949_H3wRs | UK003V | 2024-11-14T14:12:39.641Z | 2024-11-21T14:26:17.473Z |
5537854 | 5537854 | 20241113010729_aO6Qh | UK003V | 2024-11-14T14:12:33.825Z | 2024-11-21T14:26:16.489Z |
5537763 | 5537763 | 20241113002918_3G6Oh | UK003V | 2024-11-14T14:12:28.941Z | 2024-11-21T14:26:15.846Z |
5537740 | 5537740 | 20241113002640_zoxQw | UK003V | 2024-11-14T14:12:27.635Z | 2024-11-21T14:26:15.621Z |
5537598 | 5537598 | 20241112235151_4134Z | UK003V | 2024-11-14T14:12:16.014Z | 2024-11-21T14:26:14.925Z |
5537506 | 5537506 | 20241112232800_3a4Pm | UK003V | 2024-11-14T14:12:01.018Z | 2024-11-21T14:26:13.982Z |
5537408 | 5537408 | 20241112224431_2OAw7 | UK003V | 2024-11-14T14:11:45.733Z | 2024-11-21T14:26:12.738Z |
5537285 | 5537285 | 20241112215518_GtoU4 | UK003V | 2024-11-14T14:11:31.159Z | 2024-11-21T14:26:10.825Z |
5536703 | 5536703 | 20241112185549_DGuC7 | UK003V | 2024-11-14T14:10:28.950Z | 2024-11-21T14:26:05.041Z |
5532913 | 5532913 | 20241113061609_7upYM | UK003V | 2024-11-14T14:00:31.211Z | 2024-11-22T14:24:06.031Z |
5532875 | 5532875 | 20241113061059_UAHHs | UK003V | 2024-11-14T14:00:26.816Z | 2024-11-22T14:24:05.803Z |
5532377 | 5532377 | 20241112051525_phoF9 | UK003V | 2024-11-13T14:16:40.833Z | 2024-11-20T14:26:22.580Z |
5531785 | 5531785 | 20241112040906_atty8 | UK003V | 2024-11-13T14:15:55.054Z | 2024-11-20T14:26:14.329Z |
5531606 | 5531606 | 20241112035218_z6aT8 | UK003V | 2024-11-13T14:15:46.570Z | 2024-11-20T14:26:12.711Z |
5531194 | 5531194 | 20241112032055_uNFXm | UK003V | 2024-11-13T14:15:23.531Z | 2024-11-20T14:26:08.517Z |
5530834 | 5530834 | 20241112025134_ZroNL | UK003V | 2024-11-13T14:14:42.787Z | 2024-11-20T14:26:03.975Z |
5530426 | 5530426 | 20241112021620_3ziRH | UK003V | 2024-11-13T14:14:14.989Z | 2024-11-20T14:25:58.913Z |
5529962 | 5529962 | 20241112012939_pQEH8 | UK003V | 2024-11-13T14:13:30.364Z | 2024-11-20T14:25:51.638Z |
5529928 | 5529928 | 20241112012444_EhUIF | UK003V | 2024-11-13T14:13:24.940Z | 2024-11-20T14:25:51.075Z |
5529818 | 5529818 | 20241112010642_KPmD6 | UK003V | 2024-11-13T14:13:13.225Z | 2024-11-20T14:25:48.592Z |
5529809 | 5529809 | 20241112010555_hes3A | UK003V | 2024-11-13T14:13:12.749Z | 2024-11-20T14:25:48.477Z |
5529536 | 5529536 | 20241112003131_73v1t | UK003V | 2024-11-13T14:12:56.939Z | 2024-11-20T14:25:46.174Z |
5529243 | 5529243 | 20241111235422_pEPUG | UK003V | 2024-11-13T14:12:15.667Z | 2024-11-20T14:25:42.178Z |
5529171 | 5529171 | 20241111234114_YHhpC | UK003V | 2024-11-13T14:12:10.909Z | 2024-11-20T14:25:41.281Z |
5529134 | 5529134 | 20241111233330_7GbMl | UK003V | 2024-11-13T14:12:08.020Z | 2024-11-20T14:25:40.456Z |
5528776 | 5528776 | 20241111223808_qpVMP | UK003V | 2024-11-13T14:11:25.763Z | 2024-11-20T14:25:35.646Z |
5528392 | 5528392 | 20241111203839_MVcp4 | UK003V | 2024-11-13T14:10:34.817Z | 2024-11-20T14:25:29.948Z |
5524841 | 5524841 | 20241111060139_9Aydi | UK003V | 2024-11-12T14:18:03.293Z | 2024-11-19T14:22:24.294Z |
5503364 | 5503364 | 20241107215624_gBsNC | UK003V | 2024-11-09T14:12:54.464Z | 2024-11-16T14:28:06.717Z |
5503331 | 5503331 | 20241107214204_ICsm9 | UK003V | 2024-11-09T14:12:50.081Z | 2024-11-16T14:28:06.058Z |
5503319 | 5503319 | 20241107213713_Ft7ZV | UK003V | 2024-11-09T14:12:48.874Z | 2024-11-16T14:28:05.884Z |
5503310 | 5503310 | 20241107213306_zsLBv | UK003V | 2024-11-09T14:12:47.063Z | 2024-11-16T14:28:05.828Z |
5503296 | 5503296 | 20241107212843_7OYe3 | UK003V | 2024-11-09T14:12:45.426Z | 2024-11-16T14:28:05.766Z |
5421188 | 5421188 | 20241028050212_Dor6U | UK003V | 2024-10-30T12:19:41.116Z | 2024-11-05T14:27:17.698Z |
5410695 | 5410695 | 20241027052903_M1m7L | UK003V | 2024-10-29T12:18:02.744Z | 2024-11-04T14:29:05.236Z |
5410487 | 5410487 | 20241027051501_HxJlR | UK003V | 2024-10-29T12:17:56.913Z | 2024-11-04T14:29:04.646Z |
5409153 | 5409153 | 20241027040324_piW2n | UK003V | 2024-10-29T12:17:09.260Z | 2024-11-04T14:29:01.228Z |
5409035 | 5409035 | 20241027035615_DQS0F | UK003V | 2024-10-29T12:17:02.070Z | 2024-11-04T14:29:00.952Z |
5408967 | 5408967 | 20241027035141_O3X66 | UK003V | 2024-10-29T12:16:58.445Z | 2024-11-04T14:29:00.879Z |
5408605 | 5408605 | 20241027033204_cQPv8 | UK003V | 2024-10-29T12:16:39.108Z | 2024-11-04T14:28:59.674Z |
5408561 | 5408561 | 20241027033030_vnuBv | UK003V | 2024-10-29T12:16:36.124Z | 2024-11-04T14:28:59.618Z |
5407439 | 5407439 | 20241027023700_3iYrH | UK003V | 2024-10-29T12:15:24.742Z | 2024-11-04T14:28:57.570Z |
5406982 | 5406982 | 20241027021544_5IMa5 | UK003V | 2024-10-29T12:15:04.259Z | 2024-11-04T14:28:56.748Z |
5406521 | 5406521 | 20241027014237_CZ3Fi | UK003V | 2024-10-29T12:14:17.407Z | 2024-11-04T14:28:55.822Z |
5405822 | 5405822 | 20241027010123_llt5F | UK003V | 2024-10-29T12:13:20.070Z | 2024-11-04T14:28:54.406Z |
5405648 | 5405648 | 20241027005213_mQwjZ | UK003V | 2024-10-29T12:13:07.403Z | 2024-11-04T14:28:53.747Z |
5402049 | 5402049 | 20241026183503_zAyMj | UK003V | 2024-10-29T12:06:10.572Z | 2024-11-04T14:28:41.855Z |
5400074 | 5400074 | 20241026053607_D5Hb6 | UK003V | 2024-10-28T12:20:21.764Z | 2024-11-03T14:27:41.266Z |
5399981 | 5399981 | 20241026051859_o7xBp | UK003V | 2024-10-28T12:20:18.080Z | 2024-11-03T14:27:40.945Z |
5399966 | 5399966 | 20241026051807_R1307 | UK003V | 2024-10-28T12:20:17.648Z | 2024-11-03T14:27:40.899Z |
5399783 | 5399783 | 20241026050217_EV6q3 | UK003V | 2024-10-28T12:20:11.091Z | 2024-11-03T14:27:40.510Z |
5399767 | 5399767 | 20241026050042_xy1sv | UK003V | 2024-10-28T12:20:10.595Z | 2024-11-03T14:27:40.484Z |
5399669 | 5399669 | 20241026044705_5Z03f | UK003V | 2024-10-28T12:20:05.637Z | 2024-11-03T14:27:40.216Z |
5399540 | 5399540 | 20241026043330_T2J2E | UK003V | 2024-10-28T12:20:01.760Z | 2024-11-03T14:27:39.943Z |
5399339 | 5399339 | 20241026041140_R376e | UK003V | 2024-10-28T12:19:55.327Z | 2024-11-03T14:27:39.506Z |
5399217 | 5399217 | 20241026040219_cdA3y | UK003V | 2024-10-28T12:19:51.594Z | 2024-11-03T14:27:39.253Z |
5399045 | 5399045 | 20241026034658_XAPTn | UK003V | 2024-10-28T12:19:45.704Z | 2024-11-03T14:27:38.944Z |
5398754 | 5398754 | 20241026032600_aDLHv | UK003V | 2024-10-28T12:19:31.368Z | 2024-11-03T14:27:37.986Z |
5398746 | 5398746 | 20241026032516_wFRR8 | UK003V | 2024-10-28T12:19:30.214Z | 2024-11-03T14:27:37.966Z |
5398740 | 5398740 | 20241026032349_hdf7j | UK003V | 2024-10-28T12:19:30.069Z | 2024-11-03T14:27:37.942Z |
5398723 | 5398723 | 20241026032150_7NVzB | UK003V | 2024-10-28T12:19:29.672Z | 2024-11-03T14:27:37.899Z |
5398687 | 5398687 | 20241026031900_tYto2 | UK003V | 2024-10-28T12:19:28.487Z | 2024-11-03T14:27:37.732Z |
5397508 | 5397508 | 20241026013556_PAgLj | UK003V | 2024-10-28T12:18:25.871Z | 2024-11-03T14:27:33.292Z |
5397471 | 5397471 | 20241026013248_pQQM4 | UK003V | 2024-10-28T12:18:24.430Z | 2024-11-03T14:27:33.141Z |
5397448 | 5397448 | 20241026013125_od88K | UK003V | 2024-10-28T12:18:23.018Z | 2024-11-03T14:27:33.026Z |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE participating_station ( meteor_unique_trajectory_identifier text NOT NULL, station_code text NOT NULL, created_at datetime NOT NULL DEFAULT ( strftime( '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc' ) ), updated_at datetime NOT NULL DEFAULT ( strftime( '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc' ) ), FOREIGN KEY (meteor_unique_trajectory_identifier) REFERENCES meteor (unique_trajectory_identifier), FOREIGN KEY (station_code) REFERENCES station (code), UNIQUE (meteor_unique_trajectory_identifier, station_code) ON CONFLICT IGNORE ); CREATE INDEX participating_station_station_code_covering_index ON participating_station (station_code, meteor_unique_trajectory_identifier); CREATE INDEX participating_station_created_at_index ON participating_station (created_at); CREATE INDEX participating_station_updated_at_index ON participating_station (updated_at);