participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,920 rows where station_code = "UK006Q" 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 |
---|---|---|---|---|---|
4111055 | 4111055 | 20240323195408_wGppA | UK006Q | 2024-03-25T12:05:16.556Z | 2024-04-01T12:15:58.469Z |
4110819 | 4110819 | 20240324034917_aWdKM | UK006Q | 2024-03-25T12:03:47.705Z | 2024-04-01T12:16:10.416Z |
4086482 | 4086482 | 20240318033709_zXPnG | UK006Q | 2024-03-19T12:08:38.787Z | 2024-03-26T12:21:07.457Z |
4086466 | 4086466 | 20240318033211_x8Ula | UK006Q | 2024-03-19T12:08:36.904Z | 2024-03-26T12:21:07.345Z |
4078426 | 4078426 | 20240316050038_HxsXJ | UK006Q | 2024-03-17T12:09:31.415Z | 2024-03-24T12:20:57.528Z |
4078274 | 4078274 | 20240316045316_W9HO3 | UK006Q | 2024-03-17T12:09:25.479Z | 2024-03-24T12:20:56.972Z |
4078016 | 4078016 | 20240316041409_M0KTI | UK006Q | 2024-03-17T12:09:14.065Z | 2024-03-24T12:20:54.948Z |
4077937 | 4077937 | 20240316035953_s8weh | UK006Q | 2024-03-17T12:09:10.780Z | 2024-03-24T12:20:54.244Z |
4077674 | 4077674 | 20240316033218_gJuxZ | UK006Q | 2024-03-17T12:08:49.901Z | 2024-03-24T12:20:52.651Z |
4077596 | 4077596 | 20240316032217_euISQ | UK006Q | 2024-03-17T12:08:44.045Z | 2024-03-24T12:20:51.883Z |
4077490 | 4077490 | 20240316030902_qOjPz | UK006Q | 2024-03-17T12:08:37.654Z | 2024-03-24T12:20:51.033Z |
4077447 | 4077447 | 20240316030539_Ernp3 | UK006Q | 2024-03-17T12:08:36.244Z | 2024-03-24T12:20:50.872Z |
4077386 | 4077386 | 20240316030056_Qco2g | UK006Q | 2024-03-17T12:08:34.498Z | 2024-03-24T12:20:50.499Z |
4077289 | 4077289 | 20240316024305_lhEdx | UK006Q | 2024-03-17T12:08:31.204Z | 2024-03-24T12:20:48.617Z |
4076741 | 4076741 | 20240316014945_J69yV | UK006Q | 2024-03-17T12:08:06.557Z | 2024-03-24T12:20:46.333Z |
4076686 | 4076686 | 20240316013627_pClSy | UK006Q | 2024-03-17T12:08:03.322Z | 2024-03-24T12:20:46.035Z |
4076394 | 4076394 | 20240316005710_efkI5 | UK006Q | 2024-03-17T12:07:46.332Z | 2024-03-24T12:20:44.357Z |
4076355 | 4076355 | 20240316005017_BdOYb | UK006Q | 2024-03-17T12:07:44.739Z | 2024-03-24T12:20:44.012Z |
4076221 | 4076221 | 20240316000542_JvDA3 | UK006Q | 2024-03-17T12:07:35.980Z | 2024-03-24T12:20:42.403Z |
4076210 | 4076210 | 20240316000052_HyMWj | UK006Q | 2024-03-17T12:07:35.267Z | 2024-03-24T12:20:42.248Z |
4076158 | 4076158 | 20240315234822_io3a9 | UK006Q | 2024-03-17T12:07:27.237Z | 2024-03-24T12:20:41.370Z |
4076105 | 4076105 | 20240315233723_hWG28 | UK006Q | 2024-03-17T12:07:22.722Z | 2024-03-24T12:20:40.996Z |
4076024 | 4076024 | 20240315230500_ad4bY | UK006Q | 2024-03-17T12:07:13.267Z | 2024-03-24T12:20:39.248Z |
4075917 | 4075917 | 20240315213921_dAKnR | UK006Q | 2024-03-17T12:07:02.936Z | 2024-03-24T12:20:37.347Z |
4041774 | 4041774 | 20240307050123_6vtwz | UK006Q | 2024-03-08T14:09:21.473Z | 2024-03-15T12:19:39.723Z |
4041685 | 4041685 | 20240307044158_KKxd9 | UK006Q | 2024-03-08T14:09:14.129Z | 2024-03-15T12:19:38.376Z |
4041121 | 4041121 | 20240307022233_nUxuW | UK006Q | 2024-03-08T14:08:34.114Z | 2024-03-15T12:19:27.124Z |
4040738 | 4040738 | 20240307011226_xowbs | UK006Q | 2024-03-08T14:08:03.747Z | 2024-03-15T12:19:23.068Z |
4040696 | 4040696 | 20240307010603_yJ3kd | UK006Q | 2024-03-08T14:07:58.980Z | 2024-03-15T12:19:22.383Z |
4040443 | 4040443 | 20240307001120_YgfW2 | UK006Q | 2024-03-08T14:07:45.763Z | 2024-03-15T12:19:19.504Z |
4040193 | 4040193 | 20240306225414_Nu9cT | UK006Q | 2024-03-08T14:07:22.640Z | 2024-03-15T12:19:16.303Z |
4035265 | 4035265 | 20240306025113_pN2uU | UK006Q | 2024-03-07T14:07:42.180Z | 2024-03-14T12:25:15.625Z |
4035222 | 4035222 | 20240306024736_lhvvF | UK006Q | 2024-03-07T14:07:39.936Z | 2024-03-14T12:25:14.907Z |
4035159 | 4035159 | 20240306023613_Xn1Vr | UK006Q | 2024-03-07T14:07:35.372Z | 2024-03-14T12:25:13.965Z |
4034891 | 4034891 | 20240306014001_r59Jv | UK006Q | 2024-03-07T14:07:03.786Z | 2024-03-14T12:25:10.465Z |
4034557 | 4034557 | 20240306003421_jEwiN | UK006Q | 2024-03-07T14:06:31.985Z | 2024-03-14T12:25:07.809Z |
4034048 | 4034048 | 20240305222415_x2VmG | UK006Q | 2024-03-07T14:05:48.027Z | 2024-03-14T12:25:01.911Z |
4033636 | 4033636 | 20240305201157_Q4KUJ | UK006Q | 2024-03-07T14:04:58.839Z | 2024-03-14T12:24:58.241Z |
4031572 | 4031572 | 20240305050108_Ni5z3 | UK006Q | 2024-03-06T14:09:22.934Z | 2024-03-13T12:20:58.228Z |
4027167 | 4027167 | 20240304050540_FTduE | UK006Q | 2024-03-05T14:08:59.367Z | 2024-03-12T12:15:35.082Z |
4025715 | 4025715 | 20240304025510_oN329 | UK006Q | 2024-03-05T14:07:22.785Z | 2024-03-12T12:15:29.054Z |
4025615 | 4025615 | 20240304024605_cIVBT | UK006Q | 2024-03-05T14:07:17.861Z | 2024-03-12T12:15:28.340Z |
4025520 | 4025520 | 20240304023136_cPuDC | UK006Q | 2024-03-05T14:07:11.186Z | 2024-03-12T12:15:27.548Z |
4025373 | 4025373 | 20240304022230_8oITx | UK006Q | 2024-03-05T14:07:04.624Z | 2024-03-12T12:15:26.998Z |
4025260 | 4025260 | 20240304021318_vkzCg | UK006Q | 2024-03-05T14:06:51.860Z | 2024-03-12T12:15:26.415Z |
4024428 | 4024428 | 20240304004634_3oeop | UK006Q | 2024-03-05T14:05:32.618Z | 2024-03-12T12:15:22.253Z |
4023805 | 4023805 | 20240303233629_s1jRX | UK006Q | 2024-03-05T14:04:43.341Z | 2024-03-12T12:15:20.134Z |
4013073 | 4013073 | 20240301024428_WSXAv | UK006Q | 2024-03-02T14:08:15.469Z | 2024-03-09T14:17:46.997Z |
4012670 | 4012670 | 20240301013409_IW3Bn | UK006Q | 2024-03-02T14:07:38.292Z | 2024-03-09T14:17:45.928Z |
4004484 | 4004484 | 20240226211939_GGTC4 | UK006Q | 2024-02-28T14:02:41.448Z | 2024-03-06T14:19:36.964Z |
4004411 | 4004411 | 20240226203926_BOUL5 | UK006Q | 2024-02-28T14:02:29.391Z | 2024-03-06T14:19:36.428Z |
4004363 | 4004363 | 20240226201806_J2W21 | UK006Q | 2024-02-28T14:02:21.844Z | 2024-03-06T14:19:35.579Z |
4003463 | 4003463 | 20240226060424_huHQL | UK006Q | 2024-02-27T14:02:55.965Z | 2024-03-05T14:18:55.163Z |
4003383 | 4003383 | 20240226041401_zelrz | UK006Q | 2024-02-27T14:02:45.702Z | 2024-03-05T14:18:54.467Z |
4003265 | 4003265 | 20240226023518_cg3tH | UK006Q | 2024-02-27T14:02:18.562Z | 2024-03-05T14:18:53.299Z |
4001353 | 4001353 | 20240224045211_kuxSI | UK006Q | 2024-02-25T14:03:05.696Z | 2024-03-03T14:17:37.581Z |
3999286 | 3999286 | 20240222204527_WAPoQ | UK006Q | 2024-02-24T14:04:32.412Z | 2024-03-02T14:20:25.836Z |
3999064 | 3999064 | 20240222193700_0bNiu | UK006Q | 2024-02-24T14:04:04.011Z | 2024-03-02T14:20:20.700Z |
3982072 | 3982072 | 20240217053916_H9w7E | UK006Q | 2024-02-18T14:08:12.806Z | 2024-02-25T14:18:58.104Z |
3961869 | 3961869 | 20240213061722_jzKE2 | UK006Q | 2024-02-14T14:15:18.761Z | 2024-02-21T14:20:47.853Z |
3961834 | 3961834 | 20240213060248_h2Pd3 | UK006Q | 2024-02-14T14:15:15.635Z | 2024-02-21T14:20:47.194Z |
3959201 | 3959201 | 20240213042449_SUcKC | UK006Q | 2024-02-14T14:09:09.959Z | 2024-02-21T14:20:42.363Z |
3959140 | 3959140 | 20240213040848_wPcha | UK006Q | 2024-02-14T14:08:57.997Z | 2024-02-21T14:20:41.377Z |
3959043 | 3959043 | 20240213034045_s3PQH | UK006Q | 2024-02-14T14:08:48.105Z | 2024-02-21T14:20:40.355Z |
3958995 | 3958995 | 20240213032933_cp38x | UK006Q | 2024-02-14T14:08:43.524Z | 2024-02-21T14:20:39.354Z |
3958810 | 3958810 | 20240213025159_vweqp | UK006Q | 2024-02-14T14:08:21.403Z | 2024-02-21T14:20:36.560Z |
3958181 | 3958181 | 20240212233229_KYCIN | UK006Q | 2024-02-14T14:07:09.333Z | 2024-02-21T14:20:31.142Z |
3958174 | 3958174 | 20240212232823_WiuZp | UK006Q | 2024-02-14T14:07:07.733Z | 2024-02-21T14:20:30.884Z |
3958167 | 3958167 | 20240212232527_BrV6H | UK006Q | 2024-02-14T14:07:07.154Z | 2024-02-21T14:20:30.816Z |
3958100 | 3958100 | 20240212230437_PevpM | UK006Q | 2024-02-14T14:06:50.936Z | 2024-02-21T14:20:29.349Z |
3952892 | 3952892 | 20240212022508_TlFqo | UK006Q | 2024-02-13T14:06:53.439Z | 2024-02-20T14:25:56.392Z |
3952471 | 3952471 | 20240212005706_Km4dN | UK006Q | 2024-02-13T14:06:23.010Z | 2024-02-20T14:25:49.619Z |
3951983 | 3951983 | 20240211232917_VS8aO | UK006Q | 2024-02-13T14:05:37.844Z | 2024-02-20T14:25:44.761Z |
3951110 | 3951110 | 20240211200511_ZCrM5 | UK006Q | 2024-02-13T14:04:09.099Z | 2024-02-20T14:25:32.566Z |
3947449 | 3947449 | 20240210213135_xftXi | UK006Q | 2024-02-12T14:06:02.497Z | 2024-02-19T14:19:11.838Z |
3947387 | 3947387 | 20240210205802_dnqAp | UK006Q | 2024-02-12T14:05:58.147Z | 2024-02-19T14:19:11.699Z |
3947016 | 3947016 | 20240210192410_lnmdQ | UK006Q | 2024-02-12T14:05:04.955Z | 2024-02-19T14:19:10.573Z |
3946866 | 3946866 | 20240210185514_ceXQE | UK006Q | 2024-02-12T14:04:41.256Z | 2024-02-19T14:19:10.082Z |
3944463 | 3944463 | 20240210062136_mwxKB | UK006Q | 2024-02-11T14:07:54.760Z | 2024-02-18T14:22:18.866Z |
3944437 | 3944437 | 20240210060726_KWgGr | UK006Q | 2024-02-11T14:07:52.785Z | 2024-02-18T14:22:18.789Z |
3944414 | 3944414 | 20240210055417_UJLTB | UK006Q | 2024-02-11T14:07:50.855Z | 2024-02-18T14:22:18.636Z |
3944098 | 3944098 | 20240210033113_VUrFd | UK006Q | 2024-02-11T14:07:11.251Z | 2024-02-18T14:22:16.428Z |
3936091 | 3936091 | 20240208035409_Popn5 | UK006Q | 2024-02-09T14:06:23.046Z | 2024-02-16T14:18:32.765Z |
3935919 | 3935919 | 20240208011615_dRJS9 | UK006Q | 2024-02-09T14:05:56.885Z | 2024-02-16T14:18:30.585Z |
3935913 | 3935913 | 20240208011424_WqU2Q | UK006Q | 2024-02-09T14:05:56.189Z | 2024-02-16T14:18:30.561Z |
3931596 | 3931596 | 20240207050155_5lcGu | UK006Q | 2024-02-08T14:05:10.295Z | 2024-02-15T14:18:38.272Z |
3931592 | 3931592 | 20240207050149_3zZO3 | UK006Q | 2024-02-08T14:05:09.934Z | 2024-02-15T14:18:38.272Z |
3931562 | 3931562 | 20240207044734_kGahT | UK006Q | 2024-02-08T14:05:05.192Z | 2024-02-15T14:18:38.027Z |
3912341 | 3912341 | 20240203024426_qazgW | UK006Q | 2024-02-04T14:03:40.834Z | 2024-02-11T14:23:04.798Z |
3912283 | 3912283 | 20240203022612_KaPcw | UK006Q | 2024-02-04T14:03:30.384Z | 2024-02-11T14:23:01.611Z |
3906407 | 3906407 | 20240201045715_fXMHL | UK006Q | 2024-02-02T14:05:46.243Z | 2024-02-09T14:20:23.034Z |
3905089 | 3905089 | 20240131204906_N0OoO | UK006Q | 2024-02-02T14:01:55.105Z | 2024-02-09T14:19:48.753Z |
3900653 | 3900653 | 20240130193911_6DzRI | UK006Q | 2024-02-01T14:01:13.180Z | 2024-02-08T14:20:03.171Z |
3883626 | 3883626 | 20240124215502_t6nF3 | UK006Q | 2024-01-26T14:00:45.255Z | 2024-02-02T14:19:13.002Z |
3868045 | 3868045 | 20240119064406_pM67q | UK006Q | 2024-01-22T14:07:58.864Z | 2024-01-27T14:20:31.913Z |
3867714 | 3867714 | 20240119062258_WVGFd | UK006Q | 2024-01-22T14:07:42.323Z | 2024-01-27T14:20:25.499Z |
3867474 | 3867474 | 20240119061309_VVmte | UK006Q | 2024-01-22T14:07:36.459Z | 2024-01-27T14:20:23.324Z |
3866899 | 3866899 | 20240119053622_CrHkV | UK006Q | 2024-01-22T14:06:58.933Z | 2024-01-27T14:20:18.905Z |
3866582 | 3866582 | 20240119051652_09KkJ | UK006Q | 2024-01-22T14:06:42.413Z | 2024-01-27T14:20:14.961Z |
3866361 | 3866361 | 20240119050407_31rfQ | UK006Q | 2024-01-22T14:06:26.909Z | 2024-01-27T14:20:12.222Z |
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);