participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,999 rows where station_code = "UK009D" 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 |
---|---|---|---|---|---|
5561888 | 5561888 | 20241119222438_Tnv3d | UK009D | 2024-11-21T14:14:12.526Z | 2024-11-22T14:20:48.989Z |
5561239 | 5561239 | 20241119191505_pRdrh | UK009D | 2024-11-21T14:12:43.756Z | 2024-11-22T14:20:27.219Z |
5561214 | 5561214 | 20241119190437_nD0So | UK009D | 2024-11-21T14:12:38.709Z | 2024-11-22T14:20:26.382Z |
5561164 | 5561164 | 20241119184525_tI2zK | UK009D | 2024-11-21T14:12:31.902Z | 2024-11-22T14:20:23.804Z |
5561159 | 5561159 | 20241119184414_dOlOi | UK009D | 2024-11-21T14:12:31.238Z | 2024-11-22T14:20:23.519Z |
5552600 | 5552600 | 20241117190908_k2bam | UK009D | 2024-11-19T14:08:44.227Z | 2024-11-22T14:22:42.667Z |
5548465 | 5548465 | 20241116234211_yCkmu | UK009D | 2024-11-18T14:09:17.208Z | 2024-11-22T14:23:13.400Z |
5544019 | 5544019 | 20241115051409_LH2tB | UK009D | 2024-11-16T14:07:49.263Z | 2024-11-22T14:24:02.955Z |
5543975 | 5543975 | 20241115050148_onbCh | UK009D | 2024-11-16T14:07:46.115Z | 2024-11-22T14:24:02.862Z |
5543944 | 5543944 | 20241115044629_YrXeG | UK009D | 2024-11-16T14:07:43.367Z | 2024-11-22T14:24:02.671Z |
5543812 | 5543812 | 20241115034012_nWmIM | UK009D | 2024-11-16T14:07:17.088Z | 2024-11-22T14:24:01.685Z |
5543787 | 5543787 | 20241115033447_LcW2S | UK009D | 2024-11-16T14:07:13.631Z | 2024-11-22T14:24:01.513Z |
5543625 | 5543625 | 20241115023831_ccU2s | UK009D | 2024-11-16T14:06:57.041Z | 2024-11-22T14:24:00.520Z |
5543607 | 5543607 | 20241115022653_8LRO6 | UK009D | 2024-11-16T14:06:55.220Z | 2024-11-22T14:24:00.350Z |
5543553 | 5543553 | 20241115020124_PBJHy | UK009D | 2024-11-16T14:06:40.513Z | 2024-11-22T14:23:59.992Z |
5543512 | 5543512 | 20241115015212_Wh8vE | UK009D | 2024-11-16T14:06:34.055Z | 2024-11-22T14:23:59.819Z |
5543319 | 5543319 | 20241115001013_3w5J3 | UK009D | 2024-11-16T14:06:05.468Z | 2024-11-22T14:23:58.171Z |
5543203 | 5543203 | 20241114230055_krM5u | UK009D | 2024-11-16T14:05:43.374Z | 2024-11-22T14:23:57.446Z |
5543199 | 5543199 | 20241114225455_FEefJ | UK009D | 2024-11-16T14:05:42.967Z | 2024-11-22T14:23:57.437Z |
5543195 | 5543195 | 20241114225317_12wdV | UK009D | 2024-11-16T14:05:42.592Z | 2024-11-22T14:23:57.424Z |
5543190 | 5543190 | 20241114224614_1E58K | UK009D | 2024-11-16T14:05:41.779Z | 2024-11-22T14:23:57.408Z |
5543149 | 5543149 | 20241114215307_Lw0As | UK009D | 2024-11-16T14:05:37.277Z | 2024-11-22T14:23:57.210Z |
5543141 | 5543141 | 20241114214953_HFqqh | UK009D | 2024-11-16T14:05:36.885Z | 2024-11-22T14:23:57.176Z |
5543110 | 5543110 | 20241114204122_0sfkc | UK009D | 2024-11-16T14:05:32.343Z | 2024-11-22T14:23:56.932Z |
5543104 | 5543104 | 20241114203346_WQZQO | UK009D | 2024-11-16T14:05:31.713Z | 2024-11-22T14:23:56.883Z |
5543096 | 5543096 | 20241114201252_Q3DIG | UK009D | 2024-11-16T14:05:31.030Z | 2024-11-22T14:23:56.862Z |
5543091 | 5543091 | 20241114200356_zTzyC | UK009D | 2024-11-16T14:05:30.459Z | 2024-11-22T14:23:56.830Z |
5543073 | 5543073 | 20241114194418_eLFlK | UK009D | 2024-11-16T14:05:29.064Z | 2024-11-22T14:23:56.742Z |
5543064 | 5543064 | 20241114193924_FabPq | UK009D | 2024-11-16T14:05:28.808Z | 2024-11-22T14:23:56.736Z |
5543056 | 5543056 | 20241114193307_2Bthu | UK009D | 2024-11-16T14:05:28.131Z | 2024-11-22T14:23:56.700Z |
5543031 | 5543031 | 20241114181349_8BQNO | UK009D | 2024-11-16T14:05:22.784Z | 2024-11-22T14:23:56.216Z |
5543023 | 5543023 | 20241114180515_GzMJN | UK009D | 2024-11-16T14:05:20.796Z | 2024-11-22T14:23:56.182Z |
5543009 | 5543009 | 20241114175945_p2U3D | UK009D | 2024-11-16T14:05:15.940Z | 2024-11-22T14:23:56.080Z |
5542996 | 5542996 | 20241114173758_8ntN1 | UK009D | 2024-11-16T14:05:14.254Z | 2024-11-22T14:23:55.900Z |
5542104 | 5542104 | 20241115053721_8Shvn | UK009D | 2024-11-16T14:00:11.188Z | 2024-11-22T14:23:23.082Z |
5541193 | 5541193 | 20241113192257_1cxL2 | UK009D | 2024-11-15T14:06:52.401Z | 2024-11-22T14:24:16.453Z |
5541185 | 5541185 | 20241113185414_ZHH2T | UK009D | 2024-11-15T14:06:51.355Z | 2024-11-22T14:24:16.340Z |
5536479 | 5536479 | 20241112181134_vf2eH | UK009D | 2024-11-14T14:10:02.632Z | 2024-11-21T14:26:01.279Z |
5536402 | 5536402 | 20241112175513_QDsaD | UK009D | 2024-11-14T14:09:50.420Z | 2024-11-21T14:26:00.756Z |
5532274 | 5532274 | 20241112050121_a3oAt | UK009D | 2024-11-13T14:16:32.601Z | 2024-11-20T14:26:21.527Z |
5532252 | 5532252 | 20241112045757_YnuNA | UK009D | 2024-11-13T14:16:31.520Z | 2024-11-20T14:26:21.433Z |
5532173 | 5532173 | 20241112044706_a7zrw | UK009D | 2024-11-13T14:16:24.226Z | 2024-11-20T14:26:20.546Z |
5532140 | 5532140 | 20241112044031_RkQTF | UK009D | 2024-11-13T14:16:21.530Z | 2024-11-20T14:26:20.179Z |
5532053 | 5532053 | 20241112043258_UXP2k | UK009D | 2024-11-13T14:16:13.633Z | 2024-11-20T14:26:18.302Z |
5531855 | 5531855 | 20241112041322_XybJW | UK009D | 2024-11-13T14:15:59.016Z | 2024-11-20T14:26:15.276Z |
5531819 | 5531819 | 20241112041125_125iz | UK009D | 2024-11-13T14:15:56.686Z | 2024-11-20T14:26:14.807Z |
5531777 | 5531777 | 20241112040839_JoyPT | UK009D | 2024-11-13T14:15:54.537Z | 2024-11-20T14:26:14.263Z |
5531623 | 5531623 | 20241112035341_s7QvV | UK009D | 2024-11-13T14:15:46.809Z | 2024-11-20T14:26:12.784Z |
5531544 | 5531544 | 20241112034808_rwUyy | UK009D | 2024-11-13T14:15:44.226Z | 2024-11-20T14:26:12.138Z |
5531506 | 5531506 | 20241112034419_bJZx1 | UK009D | 2024-11-13T14:15:43.042Z | 2024-11-20T14:26:11.844Z |
5531394 | 5531394 | 20241112033532_Ma1gr | UK009D | 2024-11-13T14:15:37.357Z | 2024-11-20T14:26:11.091Z |
5531339 | 5531339 | 20241112033237_gdkef | UK009D | 2024-11-13T14:15:34.805Z | 2024-11-20T14:26:10.408Z |
5531314 | 5531314 | 20241112033136_R6Kik | UK009D | 2024-11-13T14:15:34.155Z | 2024-11-20T14:26:10.346Z |
5531287 | 5531287 | 20241112032840_FEDCd | UK009D | 2024-11-13T14:15:32.780Z | 2024-11-20T14:26:09.975Z |
5531073 | 5531073 | 20241112031046_6Vq24 | UK009D | 2024-11-13T14:15:08.496Z | 2024-11-20T14:26:06.993Z |
5531050 | 5531050 | 20241112030839_CPtWJ | UK009D | 2024-11-13T14:15:06.454Z | 2024-11-20T14:26:06.661Z |
5531038 | 5531038 | 20241112030802_n5bl3 | UK009D | 2024-11-13T14:15:05.876Z | 2024-11-20T14:26:06.585Z |
5530906 | 5530906 | 20241112025906_IKv9G | UK009D | 2024-11-13T14:14:49.862Z | 2024-11-20T14:26:05.154Z |
5530828 | 5530828 | 20241112025105_NcacU | UK009D | 2024-11-13T14:14:42.372Z | 2024-11-20T14:26:03.929Z |
5530661 | 5530661 | 20241112023707_fc7t3 | UK009D | 2024-11-13T14:14:26.711Z | 2024-11-20T14:26:02.506Z |
5530309 | 5530309 | 20241112020721_64kxi | UK009D | 2024-11-13T14:14:08.048Z | 2024-11-20T14:25:56.826Z |
5529240 | 5529240 | 20241111235359_tFAp4 | UK009D | 2024-11-13T14:12:15.403Z | 2024-11-20T14:25:42.167Z |
5528464 | 5528464 | 20241111210042_hTxoQ | UK009D | 2024-11-13T14:10:45.494Z | 2024-11-20T14:25:30.893Z |
5528418 | 5528418 | 20241111204538_MRfoP | UK009D | 2024-11-13T14:10:36.174Z | 2024-11-20T14:25:30.263Z |
5528358 | 5528358 | 20241111203017_dj3Vd | UK009D | 2024-11-13T14:10:30.253Z | 2024-11-20T14:25:28.943Z |
5528178 | 5528178 | 20241111195013_L5dlR | UK009D | 2024-11-13T14:10:13.126Z | 2024-11-20T14:25:26.352Z |
5527783 | 5527783 | 20241111183458_jLD38 | UK009D | 2024-11-13T14:09:08.795Z | 2024-11-20T14:25:20.394Z |
5527688 | 5527688 | 20241111181438_cjI2H | UK009D | 2024-11-13T14:08:55.235Z | 2024-11-20T14:25:17.982Z |
5527610 | 5527610 | 20241111174851_Ot6zQ | UK009D | 2024-11-13T14:08:45.135Z | 2024-11-20T14:25:14.676Z |
5522886 | 5522886 | 20241110224051_Nc3ai | UK009D | 2024-11-12T14:14:26.874Z | 2024-11-19T14:22:08.579Z |
5522866 | 5522866 | 20241110222950_270OM | UK009D | 2024-11-12T14:14:25.459Z | 2024-11-19T14:22:08.429Z |
5522819 | 5522819 | 20241110215855_ROI8f | UK009D | 2024-11-12T14:14:21.112Z | 2024-11-19T14:22:06.999Z |
5522818 | 5522818 | 20241110215832_fhMCu | UK009D | 2024-11-12T14:14:20.920Z | 2024-11-19T14:22:06.989Z |
5522815 | 5522815 | 20241110215735_IYwFB | UK009D | 2024-11-12T14:14:20.611Z | 2024-11-19T14:22:06.634Z |
5522580 | 5522580 | 20241110203910_1YS0C | UK009D | 2024-11-12T14:13:40.000Z | 2024-11-19T14:22:04.293Z |
5522479 | 5522479 | 20241110200908_USWpF | UK009D | 2024-11-12T14:13:20.683Z | 2024-11-19T14:22:02.644Z |
5454805 | 5454805 | 20241031052205_JIlLt | UK009D | 2024-11-02T12:23:23.808Z | 2024-11-08T14:23:25.710Z |
5454786 | 5454786 | 20241031051641_voIyP | UK009D | 2024-11-02T12:23:23.145Z | 2024-11-08T14:23:25.649Z |
5454701 | 5454701 | 20241031045640_7NiVI | UK009D | 2024-11-02T12:23:17.136Z | 2024-11-08T14:23:24.775Z |
5454629 | 5454629 | 20241031044726_r5oo3 | UK009D | 2024-11-02T12:23:14.830Z | 2024-11-08T14:23:24.494Z |
5454490 | 5454490 | 20241031042951_5e20c | UK009D | 2024-11-02T12:23:07.644Z | 2024-11-08T14:23:23.366Z |
5454432 | 5454432 | 20241031042124_kcvkD | UK009D | 2024-11-02T12:23:06.223Z | 2024-11-08T14:23:22.962Z |
5454353 | 5454353 | 20241031041153_nz3u5 | UK009D | 2024-11-02T12:23:03.450Z | 2024-11-08T14:23:22.472Z |
5454298 | 5454298 | 20241031040629_135U2 | UK009D | 2024-11-02T12:22:59.134Z | 2024-11-08T14:23:22.053Z |
5454202 | 5454202 | 20241031035545_lYDGS | UK009D | 2024-11-02T12:22:54.431Z | 2024-11-08T14:23:21.340Z |
5454179 | 5454179 | 20241031035318_t8OWR | UK009D | 2024-11-02T12:22:53.876Z | 2024-11-08T14:23:20.978Z |
5454087 | 5454087 | 20241031034058_92XpZ | UK009D | 2024-11-02T12:22:50.489Z | 2024-11-08T14:23:20.310Z |
5453897 | 5453897 | 20241031031334_8gypc | UK009D | 2024-11-02T12:22:44.494Z | 2024-11-08T14:23:19.644Z |
5453855 | 5453855 | 20241031031012_yDb94 | UK009D | 2024-11-02T12:22:43.823Z | 2024-11-08T14:23:19.585Z |
5453778 | 5453778 | 20241031025835_68J4T | UK009D | 2024-11-02T12:22:42.472Z | 2024-11-08T14:23:19.036Z |
5453758 | 5453758 | 20241031025706_ga8U4 | UK009D | 2024-11-02T12:22:42.045Z | 2024-11-08T14:23:18.990Z |
5453756 | 5453756 | 20241031025647_ldDz8 | UK009D | 2024-11-02T12:22:41.985Z | 2024-11-08T14:23:18.989Z |
5453594 | 5453594 | 20241031022824_5Eolw | UK009D | 2024-11-02T12:22:36.686Z | 2024-11-08T14:23:18.170Z |
5453486 | 5453486 | 20241031021533_suTNg | UK009D | 2024-11-02T12:22:34.496Z | 2024-11-08T14:23:17.588Z |
5453476 | 5453476 | 20241031021532_ZYF4X | UK009D | 2024-11-02T12:22:34.408Z | 2024-11-08T14:23:17.584Z |
5453466 | 5453466 | 20241031021433_C3sav | UK009D | 2024-11-02T12:22:34.207Z | 2024-11-08T14:23:17.537Z |
5453411 | 5453411 | 20241031020958_T3SLL | UK009D | 2024-11-02T12:22:33.187Z | 2024-11-08T14:23:17.307Z |
5453372 | 5453372 | 20241031020641_vwfG0 | UK009D | 2024-11-02T12:22:32.794Z | 2024-11-08T14:23:17.225Z |
5453328 | 5453328 | 20241031020301_PjpLB | UK009D | 2024-11-02T12:22:31.868Z | 2024-11-08T14:23:16.735Z |
5453315 | 5453315 | 20241031020151_O3cL5 | UK009D | 2024-11-02T12:22:31.753Z | 2024-11-08T14:23:16.590Z |
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);