participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,440 rows where station_code = "UK009F" 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 |
---|---|---|---|---|---|
5571072 | 5571072 | 20241120221210_dXYHU | UK009F | 2024-11-22T14:16:21.387Z | 2024-11-22T14:19:22.035Z |
5570485 | 5570485 | 20241120194554_QYP2B | UK009F | 2024-11-22T14:15:35.853Z | 2024-11-22T14:19:21.925Z |
5570469 | 5570469 | 20241120194353_IjoQ8 | UK009F | 2024-11-22T14:15:32.167Z | 2024-11-22T14:19:21.921Z |
5564191 | 5564191 | 20241120023715_A3zgm | UK009F | 2024-11-21T14:17:17.264Z | 2024-11-22T14:21:28.631Z |
5561121 | 5561121 | 20241119182408_zT2Fs | UK009F | 2024-11-21T14:12:25.968Z | 2024-11-22T14:20:21.488Z |
5558580 | 5558580 | 20241120064239_i4uEM | UK009F | 2024-11-21T14:03:44.143Z | 2024-11-22T14:19:21.256Z |
5558341 | 5558341 | 20241120055723_33nTK | UK009F | 2024-11-21T14:03:03.979Z | 2024-11-22T14:19:21.213Z |
5557383 | 5557383 | 20241120044215_wVHOi | UK009F | 2024-11-21T14:00:39.968Z | 2024-11-22T14:19:21.061Z |
5556720 | 5556720 | 20241119013021_N4fkU | UK009F | 2024-11-20T14:11:21.781Z | 2024-11-22T14:22:19.458Z |
5556674 | 5556674 | 20241119010039_aYyq4 | UK009F | 2024-11-20T14:11:12.682Z | 2024-11-22T14:22:19.241Z |
5553435 | 5553435 | 20241118023451_LXT43 | UK009F | 2024-11-19T14:10:34.860Z | 2024-11-22T14:22:53.262Z |
5553197 | 5553197 | 20241118013017_PfBFA | UK009F | 2024-11-19T14:10:08.899Z | 2024-11-22T14:22:51.012Z |
5552576 | 5552576 | 20241117185159_2WzMX | UK009F | 2024-11-19T14:08:41.389Z | 2024-11-22T14:22:42.338Z |
5549520 | 5549520 | 20241118050902_QbpXP | UK009F | 2024-11-19T14:00:12.303Z | 2024-11-22T14:21:49.649Z |
5545744 | 5545744 | 20241117063940_lD4HK | UK009F | 2024-11-18T14:00:50.513Z | 2024-11-22T14:22:25.867Z |
5545729 | 5545729 | 20241117062546_uPzDe | UK009F | 2024-11-18T14:00:47.587Z | 2024-11-22T14:22:25.776Z |
5545598 | 5545598 | 20241117053453_QGSX7 | UK009F | 2024-11-18T14:00:24.020Z | 2024-11-22T14:22:25.020Z |
5544115 | 5544115 | 20241116062043_vZqyf | UK009F | 2024-11-17T14:00:15.076Z | 2024-11-22T14:22:59.550Z |
5536447 | 5536447 | 20241112180543_Ad2Jo | UK009F | 2024-11-14T14:09:58.295Z | 2024-11-21T14:26:00.978Z |
5532386 | 5532386 | 20241112051738_IIUBI | UK009F | 2024-11-13T14:16:41.483Z | 2024-11-20T14:26:22.648Z |
5531968 | 5531968 | 20241112042348_z5Dx3 | UK009F | 2024-11-13T14:16:04.749Z | 2024-11-20T14:26:16.656Z |
5531964 | 5531964 | 20241112042230_TYv1a | UK009F | 2024-11-13T14:16:04.126Z | 2024-11-20T14:26:16.610Z |
5531879 | 5531879 | 20241112041653_4l4wH | UK009F | 2024-11-13T14:16:00.437Z | 2024-11-20T14:26:15.557Z |
5531865 | 5531865 | 20241112041432_S4DEb | UK009F | 2024-11-13T14:15:59.770Z | 2024-11-20T14:26:15.353Z |
5531771 | 5531771 | 20241112040824_KPdxd | UK009F | 2024-11-13T14:15:54.368Z | 2024-11-20T14:26:14.260Z |
5531638 | 5531638 | 20241112035605_t2mNQ | UK009F | 2024-11-13T14:15:47.853Z | 2024-11-20T14:26:12.896Z |
5530799 | 5530799 | 20241112024809_yFlum | UK009F | 2024-11-13T14:14:39.418Z | 2024-11-20T14:26:03.656Z |
5530542 | 5530542 | 20241112022656_riXu1 | UK009F | 2024-11-13T14:14:21.151Z | 2024-11-20T14:26:01.271Z |
5530276 | 5530276 | 20241112020449_mar5o | UK009F | 2024-11-13T14:14:06.254Z | 2024-11-20T14:25:56.442Z |
5530233 | 5530233 | 20241112020059_SdHXc | UK009F | 2024-11-13T14:14:03.831Z | 2024-11-20T14:25:55.876Z |
5530081 | 5530081 | 20241112014030_OYc8J | UK009F | 2024-11-13T14:13:49.964Z | 2024-11-20T14:25:54.126Z |
5528206 | 5528206 | 20241111195356_ZH4PA | UK009F | 2024-11-13T14:10:15.460Z | 2024-11-20T14:25:26.620Z |
5528166 | 5528166 | 20241111194833_ZbZ7V | UK009F | 2024-11-13T14:10:11.654Z | 2024-11-20T14:25:26.252Z |
5524500 | 5524500 | 20241111042202_NRbbe | UK009F | 2024-11-12T14:17:29.433Z | 2024-11-19T14:22:21.733Z |
5524434 | 5524434 | 20241111041227_nuBQU | UK009F | 2024-11-12T14:17:21.338Z | 2024-11-19T14:22:21.312Z |
5524322 | 5524322 | 20241111035409_Wy9eB | UK009F | 2024-11-12T14:17:01.557Z | 2024-11-19T14:22:19.980Z |
5523901 | 5523901 | 20241111024427_9fdwO | UK009F | 2024-11-12T14:16:19.425Z | 2024-11-19T14:22:15.737Z |
5523829 | 5523829 | 20241111023152_3fdtP | UK009F | 2024-11-12T14:16:15.868Z | 2024-11-19T14:22:15.452Z |
5523700 | 5523700 | 20241111020910_0MLbf | UK009F | 2024-11-12T14:16:08.350Z | 2024-11-19T14:22:14.447Z |
5523694 | 5523694 | 20241111020828_eSRNK | UK009F | 2024-11-12T14:16:07.868Z | 2024-11-19T14:22:14.404Z |
5523685 | 5523685 | 20241111020542_xrv5Y | UK009F | 2024-11-12T14:16:07.317Z | 2024-11-19T14:22:14.341Z |
5523674 | 5523674 | 20241111020442_toApF | UK009F | 2024-11-12T14:16:07.083Z | 2024-11-19T14:22:14.317Z |
5523195 | 5523195 | 20241111002938_UOXjm | UK009F | 2024-11-12T14:14:58.191Z | 2024-11-19T14:22:10.480Z |
5523184 | 5523184 | 20241111002356_ZPFoB | UK009F | 2024-11-12T14:14:54.956Z | 2024-11-19T14:22:10.366Z |
5523079 | 5523079 | 20241110235809_NglIF | UK009F | 2024-11-12T14:14:44.406Z | 2024-11-19T14:22:09.852Z |
5522892 | 5522892 | 20241110224352_iqpvU | UK009F | 2024-11-12T14:14:27.511Z | 2024-11-19T14:22:08.677Z |
5522861 | 5522861 | 20241110222649_Th2xS | UK009F | 2024-11-12T14:14:25.072Z | 2024-11-19T14:22:08.034Z |
5522714 | 5522714 | 20241110210802_2BXJA | UK009F | 2024-11-12T14:14:00.458Z | 2024-11-19T14:22:05.390Z |
5522640 | 5522640 | 20241110205011_KHvbN | UK009F | 2024-11-12T14:13:50.393Z | 2024-11-19T14:22:04.888Z |
5522217 | 5522217 | 20241110192649_JLdbE | UK009F | 2024-11-12T14:12:58.769Z | 2024-11-19T14:21:59.576Z |
5522104 | 5522104 | 20241110190658_14grK | UK009F | 2024-11-12T14:12:48.357Z | 2024-11-19T14:21:57.744Z |
5518099 | 5518099 | 20241110055958_WYaYo | UK009F | 2024-11-11T14:15:13.082Z | 2024-11-18T14:26:39.529Z |
5518047 | 5518047 | 20241110054658_9tkDD | UK009F | 2024-11-11T14:15:10.227Z | 2024-11-18T14:26:39.365Z |
5518027 | 5518027 | 20241110054315_T6JfZ | UK009F | 2024-11-11T14:15:09.281Z | 2024-11-18T14:26:39.282Z |
5517949 | 5517949 | 20241110052324_w2RQs | UK009F | 2024-11-11T14:15:04.656Z | 2024-11-18T14:26:39.008Z |
5517930 | 5517930 | 20241110051943_lhhz5 | UK009F | 2024-11-11T14:15:03.734Z | 2024-11-18T14:26:38.956Z |
5517908 | 5517908 | 20241110051441_UbVQO | UK009F | 2024-11-11T14:15:01.099Z | 2024-11-18T14:26:38.867Z |
5517875 | 5517875 | 20241110050616_zTBSz | UK009F | 2024-11-11T14:14:57.828Z | 2024-11-18T14:26:38.727Z |
5517862 | 5517862 | 20241110050429_yEa5k | UK009F | 2024-11-11T14:14:57.396Z | 2024-11-18T14:26:38.691Z |
5517823 | 5517823 | 20241110045347_brLOO | UK009F | 2024-11-11T14:14:54.755Z | 2024-11-18T14:26:38.531Z |
5517794 | 5517794 | 20241110044946_dRAeg | UK009F | 2024-11-11T14:14:52.374Z | 2024-11-18T14:26:38.319Z |
5517791 | 5517791 | 20241110044933_GRRl6 | UK009F | 2024-11-11T14:14:52.290Z | 2024-11-18T14:26:38.313Z |
5517054 | 5517054 | 20241110024033_mlcY8 | UK009F | 2024-11-11T14:13:48.908Z | 2024-11-18T14:26:34.457Z |
5516990 | 5516990 | 20241110023041_H4Ebn | UK009F | 2024-11-11T14:13:40.972Z | 2024-11-18T14:26:34.129Z |
5516817 | 5516817 | 20241110020635_RgsHq | UK009F | 2024-11-11T14:13:24.573Z | 2024-11-18T14:26:33.469Z |
5515607 | 5515607 | 20241109220848_iFt55 | UK009F | 2024-11-11T14:11:17.120Z | 2024-11-18T14:26:27.051Z |
5515580 | 5515580 | 20241109220337_27JYs | UK009F | 2024-11-11T14:11:14.759Z | 2024-11-18T14:26:26.865Z |
5511409 | 5511409 | 20241109060743_HxalI | UK009F | 2024-11-10T14:16:46.595Z | 2024-11-17T14:24:08.680Z |
5511349 | 5511349 | 20241109055240_3HKIl | UK009F | 2024-11-10T14:16:41.956Z | 2024-11-17T14:24:08.128Z |
5511314 | 5511314 | 20241109054340_282U2 | UK009F | 2024-11-10T14:16:39.901Z | 2024-11-17T14:24:07.854Z |
5511220 | 5511220 | 20241109051151_jKLll | UK009F | 2024-11-10T14:16:31.727Z | 2024-11-17T14:24:06.963Z |
5511160 | 5511160 | 20241109044655_T5irZ | UK009F | 2024-11-10T14:16:21.920Z | 2024-11-17T14:24:05.732Z |
5511158 | 5511158 | 20241109044552_WWMb2 | UK009F | 2024-11-10T14:16:21.688Z | 2024-11-17T14:24:05.668Z |
5510989 | 5510989 | 20241109040227_Ev7V3 | UK009F | 2024-11-10T14:16:01.438Z | 2024-11-17T14:24:03.158Z |
5510924 | 5510924 | 20241109035548_Ls1R7 | UK009F | 2024-11-10T14:15:56.441Z | 2024-11-17T14:24:02.596Z |
5510911 | 5510911 | 20241109035352_so5Vq | UK009F | 2024-11-10T14:15:54.201Z | 2024-11-17T14:24:02.488Z |
5510051 | 5510051 | 20241109013749_a2Ba6 | UK009F | 2024-11-10T14:14:31.208Z | 2024-11-17T14:23:52.470Z |
5509737 | 5509737 | 20241109002527_ZB6au | UK009F | 2024-11-10T14:13:55.399Z | 2024-11-17T14:23:48.641Z |
5505484 | 5505484 | 20241108053844_2QztG | UK009F | 2024-11-09T14:16:20.360Z | 2024-11-16T14:28:32.903Z |
5505460 | 5505460 | 20241108052633_zzH9C | UK009F | 2024-11-09T14:16:19.190Z | 2024-11-16T14:28:32.435Z |
5505455 | 5505455 | 20241108052437_KYRgK | UK009F | 2024-11-09T14:16:18.859Z | 2024-11-16T14:28:32.423Z |
5505355 | 5505355 | 20241108044813_3NzrD | UK009F | 2024-11-09T14:16:12.635Z | 2024-11-16T14:28:30.589Z |
5505351 | 5505351 | 20241108044600_UYfjf | UK009F | 2024-11-09T14:16:12.383Z | 2024-11-16T14:28:30.573Z |
5505251 | 5505251 | 20241108041749_wrx3d | UK009F | 2024-11-09T14:15:59.374Z | 2024-11-16T14:28:28.691Z |
5505243 | 5505243 | 20241108041424_W1BUv | UK009F | 2024-11-09T14:15:57.829Z | 2024-11-16T14:28:28.659Z |
5505225 | 5505225 | 20241108041048_IGRME | UK009F | 2024-11-09T14:15:56.984Z | 2024-11-16T14:28:28.593Z |
5505205 | 5505205 | 20241108040753_5jI2Q | UK009F | 2024-11-09T14:15:55.576Z | 2024-11-16T14:28:28.488Z |
5505167 | 5505167 | 20241108040222_xzjPB | UK009F | 2024-11-09T14:15:52.838Z | 2024-11-16T14:28:28.271Z |
5505117 | 5505117 | 20241108035505_T2YjU | UK009F | 2024-11-09T14:15:45.687Z | 2024-11-16T14:28:27.769Z |
5505051 | 5505051 | 20241108034608_H2bJb | UK009F | 2024-11-09T14:15:39.813Z | 2024-11-16T14:28:25.895Z |
5505020 | 5505020 | 20241108033453_r8xar | UK009F | 2024-11-09T14:15:35.052Z | 2024-11-16T14:28:25.768Z |
5504902 | 5504902 | 20241108031606_mlSnt | UK009F | 2024-11-09T14:15:21.659Z | 2024-11-16T14:28:24.632Z |
5504850 | 5504850 | 20241108030702_xpeAr | UK009F | 2024-11-09T14:15:16.079Z | 2024-11-16T14:28:24.173Z |
5504792 | 5504792 | 20241108025904_2C1wQ | UK009F | 2024-11-09T14:15:11.623Z | 2024-11-16T14:28:23.523Z |
5504775 | 5504775 | 20241108025511_HI4Nc | UK009F | 2024-11-09T14:15:10.303Z | 2024-11-16T14:28:23.374Z |
5504643 | 5504643 | 20241108023156_MzMri | UK009F | 2024-11-09T14:15:00.056Z | 2024-11-16T14:28:21.896Z |
5504608 | 5504608 | 20241108022247_Vdo20 | UK009F | 2024-11-09T14:14:56.571Z | 2024-11-16T14:28:21.630Z |
5504590 | 5504590 | 20241108022037_Jw3Ou | UK009F | 2024-11-09T14:14:54.989Z | 2024-11-16T14:28:21.564Z |
5504588 | 5504588 | 20241108022019_Cj2PZ | UK009F | 2024-11-09T14:14:54.697Z | 2024-11-16T14:28:21.561Z |
5504573 | 5504573 | 20241108021725_87aqe | UK009F | 2024-11-09T14:14:52.044Z | 2024-11-16T14:28:21.489Z |
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);