participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,374 rows where station_code = "UK007J" 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 |
---|---|---|---|---|---|
6031691 | 6031691 | 20250201011632_xtxLB | UK007J | 2025-02-02T14:02:29.564Z | 2025-02-09T14:58:12.578Z |
6031228 | 6031228 | 20250131234718_UuIvQ | UK007J | 2025-02-02T14:00:29.451Z | 2025-02-09T14:57:47.310Z |
6029811 | 6029811 | 20250130175823_iL9D2 | UK007J | 2025-02-01T14:20:42.520Z | 2025-02-08T15:11:50.347Z |
6024871 | 6024871 | 20250129225705_aHuDW | UK007J | 2025-01-31T14:20:23.288Z | 2025-02-07T14:59:09.716Z |
6024796 | 6024796 | 20250129223647_27HkU | UK007J | 2025-01-31T14:20:18.105Z | 2025-02-07T14:59:07.715Z |
6024349 | 6024349 | 20250129200225_tf993 | UK007J | 2025-01-31T14:19:13.426Z | 2025-02-07T14:58:50.260Z |
6024260 | 6024260 | 20250129192201_FBNWA | UK007J | 2025-01-31T14:18:50.677Z | 2025-02-07T14:58:45.750Z |
6024166 | 6024166 | 20250129184516_mepMI | UK007J | 2025-01-31T14:18:21.918Z | 2025-02-07T14:58:41.228Z |
6021975 | 6021975 | 20250130062642_xB6BA | UK007J | 2025-01-31T14:08:47.131Z | 2025-02-08T15:09:54.415Z |
6021945 | 6021945 | 20250130062506_n2Dsg | UK007J | 2025-01-31T14:08:45.099Z | 2025-02-08T15:09:53.513Z |
6021882 | 6021882 | 20250130061812_Bm8Vd | UK007J | 2025-01-31T14:08:40.977Z | 2025-02-08T15:09:51.208Z |
6021373 | 6021373 | 20250130053543_jeQi2 | UK007J | 2025-01-31T14:07:48.521Z | 2025-02-08T15:09:36.420Z |
6021285 | 6021285 | 20250130052742_QJETM | UK007J | 2025-01-31T14:07:42.356Z | 2025-02-08T15:09:34.587Z |
6021094 | 6021094 | 20250130051130_nFOBG | UK007J | 2025-01-31T14:07:19.700Z | 2025-02-08T15:09:28.628Z |
6020975 | 6020975 | 20250130050304_kBd5V | UK007J | 2025-01-31T14:07:08.021Z | 2025-02-08T15:09:25.655Z |
6020957 | 6020957 | 20250130050248_XrV6l | UK007J | 2025-01-31T14:07:07.297Z | 2025-02-08T15:09:25.524Z |
6020175 | 6020175 | 20250130040635_623QD | UK007J | 2025-01-31T14:05:34.498Z | 2025-02-08T15:09:03.709Z |
6020065 | 6020065 | 20250130035603_QwT7J | UK007J | 2025-01-31T14:05:16.870Z | 2025-02-08T15:08:59.055Z |
6020022 | 6020022 | 20250130035035_R0R9T | UK007J | 2025-01-31T14:05:07.163Z | 2025-02-08T15:08:57.471Z |
6019969 | 6019969 | 20250130034544_cry2K | UK007J | 2025-01-31T14:05:02.029Z | 2025-02-08T15:08:56.194Z |
6019934 | 6019934 | 20250130034318_vnYj2 | UK007J | 2025-01-31T14:04:57.473Z | 2025-02-08T15:08:54.705Z |
6019858 | 6019858 | 20250130033258_4TQpV | UK007J | 2025-01-31T14:04:41.011Z | 2025-02-08T15:08:50.422Z |
6019767 | 6019767 | 20250130032652_8uCsN | UK007J | 2025-01-31T14:04:32.018Z | 2025-02-08T15:08:48.154Z |
6019550 | 6019550 | 20250130031200_lD7Me | UK007J | 2025-01-31T14:04:01.858Z | 2025-02-08T15:08:41.591Z |
6018813 | 6018813 | 20250130015908_n4ce8 | UK007J | 2025-01-31T14:02:21.707Z | 2025-02-08T15:08:12.514Z |
6018726 | 6018726 | 20250130014901_ifnrP | UK007J | 2025-01-31T14:02:02.060Z | 2025-02-08T15:08:09.506Z |
6018605 | 6018605 | 20250130012602_nRI2W | UK007J | 2025-01-31T14:01:41.713Z | 2025-02-08T15:08:06.059Z |
6018540 | 6018540 | 20250130012118_kBoI4 | UK007J | 2025-01-31T14:01:30.033Z | 2025-02-08T15:08:04.744Z |
6018531 | 6018531 | 20250130011940_GS3uT | UK007J | 2025-01-31T14:01:27.895Z | 2025-02-08T15:08:04.502Z |
5999235 | 5999235 | 20250126012420_73LN7 | UK007J | 2025-01-27T14:18:34.387Z | 2025-02-03T14:34:59.315Z |
5999197 | 5999197 | 20250126011031_zy4lY | UK007J | 2025-01-27T14:18:30.448Z | 2025-02-03T14:34:58.979Z |
5995430 | 5995430 | 20250126044623_xa3ev | UK007J | 2025-01-27T14:04:01.647Z | 2025-02-04T14:33:27.763Z |
5995382 | 5995382 | 20250126044157_HxL3f | UK007J | 2025-01-27T14:03:52.657Z | 2025-02-04T14:33:27.598Z |
5995380 | 5995380 | 20250126044106_ZP3ax | UK007J | 2025-01-27T14:03:52.084Z | 2025-02-04T14:33:27.584Z |
5995374 | 5995374 | 20250126043918_LPZe2 | UK007J | 2025-01-27T14:03:51.087Z | 2025-02-04T14:33:27.522Z |
5995119 | 5995119 | 20250126034948_1vbHD | UK007J | 2025-01-27T14:02:52.471Z | 2025-02-04T14:33:26.223Z |
5995029 | 5995029 | 20250126033457_fZ0ND | UK007J | 2025-01-27T14:02:31.835Z | 2025-02-04T14:33:25.656Z |
5994937 | 5994937 | 20250126031750_dpzVM | UK007J | 2025-01-27T14:02:15.229Z | 2025-02-04T14:33:25.240Z |
5994648 | 5994648 | 20250126022514_DZDlT | UK007J | 2025-01-27T14:01:18.315Z | 2025-02-04T14:33:24.131Z |
5994594 | 5994594 | 20250126021921_TJ7rj | UK007J | 2025-01-27T14:01:09.441Z | 2025-02-04T14:33:23.944Z |
5994542 | 5994542 | 20250126021455_iX8eG | UK007J | 2025-01-27T14:00:57.220Z | 2025-02-04T14:33:23.737Z |
5994286 | 5994286 | 20250125014612_knheC | UK007J | 2025-01-26T14:14:29.261Z | 2025-02-02T14:37:33.285Z |
5994268 | 5994268 | 20250125013757_tLf2Y | UK007J | 2025-01-26T14:14:24.922Z | 2025-02-02T14:37:32.830Z |
5994258 | 5994258 | 20250125013642_HAznI | UK007J | 2025-01-26T14:14:22.456Z | 2025-02-02T14:37:32.469Z |
5994254 | 5994254 | 20250125013642_NWyHV | UK007J | 2025-01-26T14:14:21.798Z | 2025-02-02T14:37:32.359Z |
5994197 | 5994197 | 20250125011055_px62v | UK007J | 2025-01-26T14:14:11.497Z | 2025-02-02T14:37:31.139Z |
5994048 | 5994048 | 20250124235914_hF3co | UK007J | 2025-01-26T14:13:50.499Z | 2025-02-02T14:37:28.555Z |
5993976 | 5993976 | 20250124231500_0Y2HI | UK007J | 2025-01-26T14:13:24.213Z | 2025-02-02T14:37:27.595Z |
5992568 | 5992568 | 20250125065337_pD12y | UK007J | 2025-01-26T14:05:14.263Z | 2025-02-03T14:34:28.752Z |
5992560 | 5992560 | 20250125065222_HJ6v6 | UK007J | 2025-01-26T14:05:12.964Z | 2025-02-03T14:34:28.567Z |
5992290 | 5992290 | 20250125061004_VCuaU | UK007J | 2025-01-26T14:04:31.611Z | 2025-02-03T14:34:25.209Z |
5991873 | 5991873 | 20250125050407_hX24K | UK007J | 2025-01-26T14:03:23.353Z | 2025-02-03T14:34:19.862Z |
5991646 | 5991646 | 20250125041233_8e3xn | UK007J | 2025-01-26T14:02:42.994Z | 2025-02-03T14:34:16.538Z |
5991420 | 5991420 | 20250125034847_8E8sF | UK007J | 2025-01-26T14:02:10.540Z | 2025-02-03T14:34:14.276Z |
5991347 | 5991347 | 20250125033927_sdtA3 | UK007J | 2025-01-26T14:02:01.994Z | 2025-02-03T14:34:12.863Z |
5991098 | 5991098 | 20250125024337_xMGOP | UK007J | 2025-01-26T14:00:57.782Z | 2025-02-03T14:34:09.221Z |
5991079 | 5991079 | 20250125023930_oUeyU | UK007J | 2025-01-26T14:00:52.944Z | 2025-02-03T14:34:08.945Z |
5986142 | 5986142 | 20250123021439_n0Vkj | UK007J | 2025-01-24T14:19:15.127Z | 2025-01-31T14:35:46.318Z |
5986034 | 5986034 | 20250123013622_oqH6U | UK007J | 2025-01-24T14:18:52.267Z | 2025-01-31T14:35:44.727Z |
5970092 | 5970092 | 20250115225130_H4B0E | UK007J | 2025-01-22T14:31:31.683Z | 2025-01-24T14:32:28.107Z |
5969979 | 5969979 | 20250115210158_62f3G | UK007J | 2025-01-22T14:31:21.118Z | 2025-01-24T14:32:25.969Z |
5969698 | 5969698 | 20250115185231_9V8tY | UK007J | 2025-01-22T14:31:03.000Z | 2025-01-24T14:32:23.574Z |
5969576 | 5969576 | 20250115175928_bVC32 | UK007J | 2025-01-22T14:30:51.228Z | 2025-01-24T14:32:22.406Z |
5969557 | 5969557 | 20250115175201_0A45E | UK007J | 2025-01-22T14:30:49.807Z | 2025-01-24T14:32:22.236Z |
5968794 | 5968794 | 20250117041836_lAxSQ | UK007J | 2025-01-22T14:29:53.863Z | 2025-01-25T14:40:22.993Z |
5966190 | 5966190 | 20250118233103_qVHG5 | UK007J | 2025-01-22T14:23:49.602Z | 2025-01-27T14:46:36.179Z |
5966164 | 5966164 | 20250118231514_fAMUp | UK007J | 2025-01-22T14:23:47.291Z | 2025-01-27T14:46:35.499Z |
5966128 | 5966128 | 20250118225737_ph5gH | UK007J | 2025-01-22T14:23:43.989Z | 2025-01-27T14:46:34.394Z |
5957468 | 5957468 | 20250119065532_qikxo | UK007J | 2025-01-20T14:01:28.488Z | 2025-01-28T14:35:17.575Z |
5952574 | 5952574 | 20250116064646_wvJkU | UK007J | 2025-01-17T14:00:48.193Z | 2025-01-25T14:38:59.764Z |
5951512 | 5951512 | 20250114045044_QUwmZ | UK007J | 2025-01-15T14:07:09.983Z | 2025-01-22T14:34:01.482Z |
5937221 | 5937221 | 20250108025621_4jKIu | UK007J | 2025-01-09T14:21:09.132Z | 2025-01-16T14:22:58.495Z |
5936444 | 5936444 | 20250108062945_UnYUk | UK007J | 2025-01-09T14:18:50.950Z | 2025-01-16T14:24:20.315Z |
5936334 | 5936334 | 20250108061025_QT7Id | UK007J | 2025-01-09T14:18:43.704Z | 2025-01-16T14:24:16.819Z |
5936283 | 5936283 | 20250108060500_DdxKX | UK007J | 2025-01-09T14:18:41.235Z | 2025-01-16T14:24:15.091Z |
5935923 | 5935923 | 20250108051845_XfZRL | UK007J | 2025-01-09T14:18:11.293Z | 2025-01-16T14:23:58.339Z |
5935798 | 5935798 | 20250108050307_g60bW | UK007J | 2025-01-09T14:17:59.023Z | 2025-01-16T14:23:48.957Z |
5935760 | 5935760 | 20250108045627_7UGys | UK007J | 2025-01-09T14:17:56.106Z | 2025-01-16T14:23:47.730Z |
5935340 | 5935340 | 20250108042125_x0o3L | UK007J | 2025-01-09T14:17:37.994Z | 2025-01-16T14:23:35.800Z |
5935251 | 5935251 | 20250108040839_03LkW | UK007J | 2025-01-09T14:17:28.173Z | 2025-01-16T14:23:32.916Z |
5935183 | 5935183 | 20250108040056_RfdRw | UK007J | 2025-01-09T14:17:19.248Z | 2025-01-16T14:23:30.864Z |
5935145 | 5935145 | 20250108035624_Of8No | UK007J | 2025-01-09T14:17:14.700Z | 2025-01-16T14:23:29.582Z |
5935071 | 5935071 | 20250108034631_4nOfl | UK007J | 2025-01-09T14:17:08.318Z | 2025-01-16T14:23:26.922Z |
5934902 | 5934902 | 20250108032647_jSEsi | UK007J | 2025-01-09T14:16:55.184Z | 2025-01-16T14:23:11.329Z |
5934880 | 5934880 | 20250108032533_fMLDV | UK007J | 2025-01-09T14:16:54.262Z | 2025-01-16T14:23:09.406Z |
5934762 | 5934762 | 20250108030617_XxSKL | UK007J | 2025-01-09T14:16:44.866Z | 2025-01-16T14:23:03.233Z |
5934730 | 5934730 | 20250108030432_d3XJF | UK007J | 2025-01-09T14:16:37.391Z | 2025-01-16T14:23:02.271Z |
5934475 | 5934475 | 20250108023524_31rfa | UK007J | 2025-01-09T14:16:07.757Z | 2025-01-16T14:22:52.008Z |
5934458 | 5934458 | 20250108023445_bWQtO | UK007J | 2025-01-09T14:16:06.970Z | 2025-01-16T14:22:51.420Z |
5934407 | 5934407 | 20250108023211_siVZJ | UK007J | 2025-01-09T14:16:04.408Z | 2025-01-16T14:22:49.965Z |
5934358 | 5934358 | 20250108022654_QhTcS | UK007J | 2025-01-09T14:16:01.253Z | 2025-01-16T14:22:48.909Z |
5934090 | 5934090 | 20250108015918_upoxY | UK007J | 2025-01-09T14:15:29.911Z | 2025-01-16T14:22:35.377Z |
5934055 | 5934055 | 20250108015403_1OteD | UK007J | 2025-01-09T14:15:26.320Z | 2025-01-16T14:22:27.654Z |
5933459 | 5933459 | 20250108004826_wq3Bm | UK007J | 2025-01-09T14:14:23.432Z | 2025-01-16T14:22:09.894Z |
5933425 | 5933425 | 20250108004543_ttzNH | UK007J | 2025-01-09T14:14:20.481Z | 2025-01-16T14:22:09.044Z |
5933104 | 5933104 | 20250108000743_fK5wq | UK007J | 2025-01-09T14:13:43.777Z | 2025-01-16T14:21:46.055Z |
5932715 | 5932715 | 20250107225439_v2lJG | UK007J | 2025-01-09T14:13:01.999Z | 2025-01-16T14:21:31.311Z |
5932602 | 5932602 | 20250107222307_tHKXA | UK007J | 2025-01-09T14:12:52.247Z | 2025-01-16T14:21:27.545Z |
5932509 | 5932509 | 20250107215308_silXC | UK007J | 2025-01-09T14:12:30.698Z | 2025-01-16T14:21:24.343Z |
5932295 | 5932295 | 20250107211959_nrg3I | UK007J | 2025-01-09T14:12:10.877Z | 2025-01-16T14:21:13.151Z |
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);