participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,362 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 |
---|---|---|---|---|---|
5505484 | 5505484 | 20241108053844_2QztG | UK009F | 2024-11-09T14:16:20.360Z | 2024-11-09T14:16:28.797Z |
5505460 | 5505460 | 20241108052633_zzH9C | UK009F | 2024-11-09T14:16:19.190Z | 2024-11-09T14:16:28.790Z |
5505455 | 5505455 | 20241108052437_KYRgK | UK009F | 2024-11-09T14:16:18.859Z | 2024-11-09T14:16:28.789Z |
5505355 | 5505355 | 20241108044813_3NzrD | UK009F | 2024-11-09T14:16:12.635Z | 2024-11-09T14:16:28.764Z |
5505351 | 5505351 | 20241108044600_UYfjf | UK009F | 2024-11-09T14:16:12.383Z | 2024-11-09T14:16:28.762Z |
5505251 | 5505251 | 20241108041749_wrx3d | UK009F | 2024-11-09T14:15:59.374Z | 2024-11-09T14:16:28.736Z |
5505243 | 5505243 | 20241108041424_W1BUv | UK009F | 2024-11-09T14:15:57.829Z | 2024-11-09T14:16:28.734Z |
5505225 | 5505225 | 20241108041048_IGRME | UK009F | 2024-11-09T14:15:56.984Z | 2024-11-09T14:16:28.730Z |
5505205 | 5505205 | 20241108040753_5jI2Q | UK009F | 2024-11-09T14:15:55.576Z | 2024-11-09T14:16:28.725Z |
5505167 | 5505167 | 20241108040222_xzjPB | UK009F | 2024-11-09T14:15:52.838Z | 2024-11-09T14:16:28.717Z |
5505117 | 5505117 | 20241108035505_T2YjU | UK009F | 2024-11-09T14:15:45.687Z | 2024-11-09T14:16:28.705Z |
5505051 | 5505051 | 20241108034608_H2bJb | UK009F | 2024-11-09T14:15:39.813Z | 2024-11-09T14:16:28.689Z |
5505020 | 5505020 | 20241108033453_r8xar | UK009F | 2024-11-09T14:15:35.052Z | 2024-11-09T14:16:28.681Z |
5504902 | 5504902 | 20241108031606_mlSnt | UK009F | 2024-11-09T14:15:21.659Z | 2024-11-09T14:16:28.653Z |
5504850 | 5504850 | 20241108030702_xpeAr | UK009F | 2024-11-09T14:15:16.079Z | 2024-11-09T14:16:28.641Z |
5504792 | 5504792 | 20241108025904_2C1wQ | UK009F | 2024-11-09T14:15:11.623Z | 2024-11-09T14:16:28.627Z |
5504775 | 5504775 | 20241108025511_HI4Nc | UK009F | 2024-11-09T14:15:10.303Z | 2024-11-09T14:16:28.622Z |
5504643 | 5504643 | 20241108023156_MzMri | UK009F | 2024-11-09T14:15:00.056Z | 2024-11-09T14:16:28.590Z |
5504608 | 5504608 | 20241108022247_Vdo20 | UK009F | 2024-11-09T14:14:56.571Z | 2024-11-09T14:16:28.581Z |
5504590 | 5504590 | 20241108022037_Jw3Ou | UK009F | 2024-11-09T14:14:54.989Z | 2024-11-09T14:16:28.577Z |
5504588 | 5504588 | 20241108022019_Cj2PZ | UK009F | 2024-11-09T14:14:54.697Z | 2024-11-09T14:16:28.576Z |
5504573 | 5504573 | 20241108021725_87aqe | UK009F | 2024-11-09T14:14:52.044Z | 2024-11-09T14:16:28.572Z |
5504469 | 5504469 | 20241108020216_eQiKH | UK009F | 2024-11-09T14:14:41.460Z | 2024-11-09T14:16:28.546Z |
5504416 | 5504416 | 20241108015557_PhuYv | UK009F | 2024-11-09T14:14:35.773Z | 2024-11-09T14:16:28.532Z |
5504171 | 5504171 | 20241108010929_4JKov | UK009F | 2024-11-09T14:14:11.439Z | 2024-11-09T14:16:28.467Z |
5504159 | 5504159 | 20241108010817_ICglE | UK009F | 2024-11-09T14:14:09.932Z | 2024-11-09T14:16:28.464Z |
5504138 | 5504138 | 20241108010133_3vAZa | UK009F | 2024-11-09T14:14:07.085Z | 2024-11-09T14:16:28.458Z |
5503980 | 5503980 | 20241108003154_smrvZ | UK009F | 2024-11-09T14:13:56.281Z | 2024-11-09T14:16:28.418Z |
5503929 | 5503929 | 20241108001719_WqVMu | UK009F | 2024-11-09T14:13:51.817Z | 2024-11-09T14:16:28.400Z |
5503865 | 5503865 | 20241108000343_qQ6tX | UK009F | 2024-11-09T14:13:48.636Z | 2024-11-09T14:16:28.372Z |
5503854 | 5503854 | 20241107235828_SOYa0 | UK009F | 2024-11-09T14:13:48.126Z | 2024-11-09T14:16:28.368Z |
5503852 | 5503852 | 20241107235826_cbOYW | UK009F | 2024-11-09T14:13:48.061Z | 2024-11-09T14:16:28.367Z |
5503850 | 5503850 | 20241107235800_ktSU3 | UK009F | 2024-11-09T14:13:47.819Z | 2024-11-09T14:16:28.366Z |
5503804 | 5503804 | 20241107235131_Kwb3o | UK009F | 2024-11-09T14:13:45.373Z | 2024-11-09T14:16:28.351Z |
5503772 | 5503772 | 20241107234728_aZRsF | UK009F | 2024-11-09T14:13:43.758Z | 2024-11-09T14:16:28.344Z |
5503720 | 5503720 | 20241107233732_88RBY | UK009F | 2024-11-09T14:13:40.774Z | 2024-11-09T14:16:28.331Z |
5503592 | 5503592 | 20241107225923_H2f5R | UK009F | 2024-11-09T14:13:22.388Z | 2024-11-09T14:16:28.297Z |
5503464 | 5503464 | 20241107222616_9UkQ2 | UK009F | 2024-11-09T14:13:08.298Z | 2024-11-09T14:16:28.266Z |
5503349 | 5503349 | 20241107215130_q1ZBk | UK009F | 2024-11-09T14:12:52.581Z | 2024-11-09T14:16:28.224Z |
5503284 | 5503284 | 20241107212208_gzbrF | UK009F | 2024-11-09T14:12:44.057Z | 2024-11-09T14:16:28.208Z |
5503210 | 5503210 | 20241107205909_I0hMS | UK009F | 2024-11-09T14:12:34.754Z | 2024-11-09T14:16:28.191Z |
5503132 | 5503132 | 20241107204533_P3dLc | UK009F | 2024-11-09T14:12:26.830Z | 2024-11-09T14:16:28.174Z |
5502446 | 5502446 | 20241107183440_lozEh | UK009F | 2024-11-09T14:11:22.743Z | 2024-11-09T14:16:28.029Z |
5502365 | 5502365 | 20241107181411_cPs1B | UK009F | 2024-11-09T14:11:13.892Z | 2024-11-09T14:16:28.013Z |
5502268 | 5502268 | 20241107175308_63hi3 | UK009F | 2024-11-09T14:11:07.039Z | 2024-11-09T14:16:27.994Z |
4795276 | 4795276 | 20240802011942_WuXIN | UK009F | 2024-08-11T12:15:20.363Z | 2024-08-11T12:15:20.363Z |
4786491 | 4786491 | 20240802010342_WRP1k | UK009F | 2024-08-10T12:17:03.372Z | 2024-08-11T12:15:06.117Z |
4786442 | 4786442 | 20240802005946_V4PXl | UK009F | 2024-08-10T12:17:00.232Z | 2024-08-11T12:15:05.436Z |
4786086 | 4786086 | 20240802004538_zUDDF | UK009F | 2024-08-10T12:16:37.703Z | 2024-08-11T12:14:58.137Z |
4779852 | 4779852 | 20240801012011_1VCim | UK009F | 2024-08-07T12:14:43.426Z | 2024-08-10T12:21:40.601Z |
4779605 | 4779605 | 20240801005516_TZKvU | UK009F | 2024-08-07T12:14:33.873Z | 2024-08-10T12:21:34.142Z |
4779567 | 4779567 | 20240801005205_2jiPd | UK009F | 2024-08-07T12:14:32.819Z | 2024-08-10T12:21:32.453Z |
4778710 | 4778710 | 20240731232937_18014 | UK009F | 2024-08-07T12:13:57.445Z | 2024-08-10T12:21:12.888Z |
4778703 | 4778703 | 20240731232844_fM1PW | UK009F | 2024-08-07T12:13:56.838Z | 2024-08-10T12:21:12.777Z |
4771183 | 4771183 | 20240731005906_qg0QU | UK009F | 2024-08-06T12:14:11.717Z | 2024-08-08T12:25:20.078Z |
4762107 | 4762107 | 20240731014930_MXrNo | UK009F | 2024-08-06T12:01:54.564Z | 2024-08-10T12:17:36.706Z |
4760001 | 4760001 | 20240730231912_3U11M | UK009F | 2024-08-05T12:15:44.045Z | 2024-08-08T12:24:22.407Z |
4759993 | 4759993 | 20240730231851_slvwl | UK009F | 2024-08-05T12:15:43.670Z | 2024-08-08T12:24:22.296Z |
4759607 | 4759607 | 20240730225915_RJsYr | UK009F | 2024-08-05T12:15:30.918Z | 2024-08-08T12:24:07.633Z |
4716507 | 4716507 | 20240728014048_kx3Ts | UK009F | 2024-07-30T12:07:45.798Z | 2024-08-05T12:19:48.724Z |
4361112 | 4361112 | 20240517011750_CJG2t | UK009F | 2024-05-25T12:03:22.908Z | 2024-05-25T12:09:10.574Z |
4360979 | 4360979 | 20240517003051_Fzytt | UK009F | 2024-05-25T12:03:16.388Z | 2024-05-25T12:09:10.557Z |
4360914 | 4360914 | 20240517000214_akXfJ | UK009F | 2024-05-25T12:03:11.558Z | 2024-05-25T12:09:10.547Z |
4275801 | 4275801 | 20240503021254_iVldy | UK009F | 2024-05-05T12:11:54.469Z | 2024-05-11T12:28:19.282Z |
4275736 | 4275736 | 20240503010715_4qLoq | UK009F | 2024-05-05T12:11:38.617Z | 2024-05-11T12:28:15.822Z |
4275666 | 4275666 | 20240502234057_1qr73 | UK009F | 2024-05-05T12:11:23.070Z | 2024-05-11T12:28:12.019Z |
4275651 | 4275651 | 20240502231256_uMsqb | UK009F | 2024-05-05T12:11:19.934Z | 2024-05-11T12:28:11.194Z |
4275646 | 4275646 | 20240502231017_7TBPF | UK009F | 2024-05-05T12:11:18.986Z | 2024-05-11T12:28:10.895Z |
4275640 | 4275640 | 20240502230117_dccZ3 | UK009F | 2024-05-05T12:11:16.355Z | 2024-05-11T12:28:09.734Z |
4275617 | 4275617 | 20240502220926_U3o3O | UK009F | 2024-05-05T12:11:11.411Z | 2024-05-11T12:28:08.132Z |
4266660 | 4266660 | 20240502020842_8AgDF | UK009F | 2024-05-03T12:08:27.812Z | 2024-05-10T12:23:49.525Z |
4266620 | 4266620 | 20240502014821_jxecz | UK009F | 2024-05-03T12:08:23.491Z | 2024-05-10T12:23:48.641Z |
4257451 | 4257451 | 20240430012604_MQLeA | UK009F | 2024-05-01T12:13:36.626Z | 2024-05-08T12:25:01.573Z |
4257376 | 4257376 | 20240430011855_O7Q66 | UK009F | 2024-05-01T12:13:33.366Z | 2024-05-08T12:25:01.148Z |
4247742 | 4247742 | 20240428014654_Bqaq2 | UK009F | 2024-04-29T12:09:35.086Z | 2024-05-06T12:21:12.713Z |
4247727 | 4247727 | 20240428013110_cBgX0 | UK009F | 2024-04-29T12:09:33.198Z | 2024-05-06T12:21:12.572Z |
4247454 | 4247454 | 20240427224430_SWlJZ | UK009F | 2024-04-29T12:08:54.599Z | 2024-05-06T12:21:09.468Z |
4247390 | 4247390 | 20240427222408_v09lx | UK009F | 2024-04-29T12:08:49.654Z | 2024-05-06T12:21:08.255Z |
4243262 | 4243262 | 20240426234119_LBRW3 | UK009F | 2024-04-28T12:08:54.347Z | 2024-05-05T12:21:44.051Z |
4240245 | 4240245 | 20240424230531_1wnog | UK009F | 2024-04-27T12:10:19.962Z | 2024-05-03T12:19:30.005Z |
4240199 | 4240199 | 20240424215920_W8PmI | UK009F | 2024-04-27T12:10:13.839Z | 2024-05-03T12:19:29.494Z |
4239908 | 4239908 | 20240426012545_PfMDI | UK009F | 2024-04-27T12:07:34.199Z | 2024-05-04T12:21:23.518Z |
4238635 | 4238635 | 20240425023248_cZ878 | UK009F | 2024-04-27T12:03:50.018Z | 2024-05-04T12:21:15.556Z |
4237404 | 4237404 | 20240422222922_mW37P | UK009F | 2024-04-26T12:11:47.694Z | 2024-04-30T12:17:55.180Z |
4235560 | 4235560 | 20240423025019_LDjCX | UK009F | 2024-04-26T12:04:40.795Z | 2024-05-02T12:22:26.166Z |
4235550 | 4235550 | 20240423024840_47cMU | UK009F | 2024-04-26T12:04:40.007Z | 2024-05-02T12:22:26.052Z |
4235542 | 4235542 | 20240423024830_937dV | UK009F | 2024-04-26T12:04:38.901Z | 2024-05-02T12:22:25.950Z |
4235487 | 4235487 | 20240423023156_7ha3s | UK009F | 2024-04-26T12:04:34.414Z | 2024-05-02T12:22:25.328Z |
4235160 | 4235160 | 20240423010437_ig6EO | UK009F | 2024-04-26T12:03:41.657Z | 2024-05-02T12:22:21.859Z |
4235070 | 4235070 | 20240423003132_1L7ow | UK009F | 2024-04-26T12:03:27.340Z | 2024-05-02T12:22:20.766Z |
4235060 | 4235060 | 20240423002330_lgi8p | UK009F | 2024-04-26T12:03:25.942Z | 2024-05-02T12:22:20.610Z |
4218242 | 4218242 | 20240419014628_BZKa9 | UK009F | 2024-04-20T12:14:24.622Z | 2024-04-27T12:20:09.443Z |
4199569 | 4199569 | 20240416031028_Ts52L | UK009F | 2024-04-17T12:12:57.695Z | 2024-04-24T12:23:30.991Z |
4199517 | 4199517 | 20240416030532_D694j | UK009F | 2024-04-17T12:12:53.052Z | 2024-04-24T12:23:30.270Z |
4172098 | 4172098 | 20240410034755_58OCt | UK009F | 2024-04-12T12:08:48.777Z | 2024-04-18T12:21:22.084Z |
4172094 | 4172094 | 20240410034701_d5J3g | UK009F | 2024-04-12T12:08:48.213Z | 2024-04-18T12:21:22.029Z |
4171901 | 4171901 | 20240410031543_3JSxd | UK009F | 2024-04-12T12:08:32.183Z | 2024-04-18T12:21:20.882Z |
4171820 | 4171820 | 20240410030536_Vs4cs | UK009F | 2024-04-12T12:08:20.444Z | 2024-04-18T12:21:20.458Z |
4171545 | 4171545 | 20240410023159_Z2Nqq | UK009F | 2024-04-12T12:07:51.255Z | 2024-04-18T12:21:18.453Z |
4171448 | 4171448 | 20240410022413_ogtG3 | UK009F | 2024-04-12T12:07:45.850Z | 2024-04-18T12:21:18.127Z |
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);