participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,014 rows where station_code = "UK006H" 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 |
---|---|---|---|---|---|
5129214 | 5129214 | 20240917033757_CJFTp | UK006H | 2024-09-19T12:11:23.450Z | 2024-09-19T12:11:23.450Z |
5121834 | 5121834 | 20240914041453_vvmAX | UK006H | 2024-09-18T12:11:01.722Z | 2024-09-19T12:20:02.390Z |
5121601 | 5121601 | 20240914041024_2woyK | UK006H | 2024-09-18T12:10:58.859Z | 2024-09-19T12:20:02.183Z |
5120997 | 5120997 | 20240914034530_hWgsp | UK006H | 2024-09-18T12:10:49.174Z | 2024-09-19T12:20:01.093Z |
5120164 | 5120164 | 20240914030314_4pDAF | UK006H | 2024-09-18T12:10:33.472Z | 2024-09-19T12:19:59.522Z |
5120086 | 5120086 | 20240914025930_rIbm3 | UK006H | 2024-09-18T12:10:31.838Z | 2024-09-19T12:19:59.384Z |
5120043 | 5120043 | 20240914025750_GdHWx | UK006H | 2024-09-18T12:10:31.242Z | 2024-09-19T12:19:59.346Z |
5119817 | 5119817 | 20240914025024_nQ2K2 | UK006H | 2024-09-18T12:10:27.809Z | 2024-09-19T12:19:58.985Z |
5119777 | 5119777 | 20240914024916_13w3A | UK006H | 2024-09-18T12:10:26.896Z | 2024-09-19T12:19:58.940Z |
5119203 | 5119203 | 20240914021729_JiNMy | UK006H | 2024-09-18T12:10:18.502Z | 2024-09-19T12:19:57.386Z |
5119056 | 5119056 | 20240914020701_BM4BI | UK006H | 2024-09-18T12:10:15.477Z | 2024-09-19T12:19:56.996Z |
5117132 | 5117132 | 20240915040416_w2Q9V | UK006H | 2024-09-18T12:07:33.399Z | 2024-09-19T12:19:13.472Z |
5116554 | 5116554 | 20240915033128_ritA0 | UK006H | 2024-09-18T12:07:09.643Z | 2024-09-19T12:19:11.512Z |
5116539 | 5116539 | 20240915033128_j9tT2 | UK006H | 2024-09-18T12:07:09.412Z | 2024-09-19T12:19:11.501Z |
5116373 | 5116373 | 20240915032405_ghSQJ | UK006H | 2024-09-18T12:07:00.268Z | 2024-09-19T12:19:10.748Z |
5115342 | 5115342 | 20240915023356_pxOrG | UK006H | 2024-09-18T12:06:11.611Z | 2024-09-19T12:19:04.061Z |
5113846 | 5113846 | 20240915011543_gYMsi | UK006H | 2024-09-18T12:04:52.719Z | 2024-09-19T12:18:53.294Z |
5113615 | 5113615 | 20240915010050_dCSql | UK006H | 2024-09-18T12:04:35.194Z | 2024-09-19T12:18:50.617Z |
5113511 | 5113511 | 20240915005442_XzKEY | UK006H | 2024-09-18T12:04:25.117Z | 2024-09-19T12:18:49.796Z |
5108051 | 5108051 | 20240913042113_BuZZr | UK006H | 2024-09-17T12:13:29.900Z | 2024-09-19T12:20:47.825Z |
5107242 | 5107242 | 20240913034839_SCz0y | UK006H | 2024-09-17T12:13:11.571Z | 2024-09-19T12:20:46.949Z |
5107183 | 5107183 | 20240913034632_ZaTPh | UK006H | 2024-09-17T12:13:10.502Z | 2024-09-19T12:20:46.899Z |
5106573 | 5106573 | 20240913032848_C8UT3 | UK006H | 2024-09-17T12:12:57.311Z | 2024-09-19T12:20:46.179Z |
5106122 | 5106122 | 20240913031210_yCMrS | UK006H | 2024-09-17T12:12:42.615Z | 2024-09-19T12:20:45.506Z |
5105967 | 5105967 | 20240913030414_3Cc2F | UK006H | 2024-09-17T12:12:34.557Z | 2024-09-19T12:20:45.090Z |
5105347 | 5105347 | 20240913024217_lH8wJ | UK006H | 2024-09-17T12:12:10.507Z | 2024-09-19T12:20:44.309Z |
5105219 | 5105219 | 20240913023759_rrs1U | UK006H | 2024-09-17T12:12:02.849Z | 2024-09-19T12:20:44.137Z |
5105124 | 5105124 | 20240913023157_iEiTZ | UK006H | 2024-09-17T12:11:57.298Z | 2024-09-19T12:20:43.741Z |
5104834 | 5104834 | 20240913022150_GxWTn | UK006H | 2024-09-17T12:11:45.238Z | 2024-09-19T12:20:42.920Z |
5104781 | 5104781 | 20240913022109_NoJDj | UK006H | 2024-09-17T12:11:44.558Z | 2024-09-19T12:20:42.881Z |
5103901 | 5103901 | 20240913014324_nuV16 | UK006H | 2024-09-17T12:11:16.224Z | 2024-09-19T12:20:40.661Z |
5103561 | 5103561 | 20240913013227_p597S | UK006H | 2024-09-17T12:11:03.782Z | 2024-09-19T12:20:40.293Z |
5102715 | 5102715 | 20240914013942_mSflV | UK006H | 2024-09-17T12:07:32.700Z | 2024-09-19T12:19:55.433Z |
5102475 | 5102475 | 20240914012813_hohph | UK006H | 2024-09-17T12:07:15.352Z | 2024-09-19T12:19:54.552Z |
5102411 | 5102411 | 20240914012438_IN3sP | UK006H | 2024-09-17T12:07:07.707Z | 2024-09-19T12:19:54.077Z |
5102398 | 5102398 | 20240914012355_rrY0Z | UK006H | 2024-09-17T12:07:07.330Z | 2024-09-19T12:19:54.057Z |
5102377 | 5102377 | 20240914012318_R4SVA | UK006H | 2024-09-17T12:07:05.965Z | 2024-09-19T12:19:53.915Z |
5101919 | 5101919 | 20240914005527_NzMrf | UK006H | 2024-09-17T12:06:24.077Z | 2024-09-19T12:19:51.861Z |
5101742 | 5101742 | 20240914004422_UBJy3 | UK006H | 2024-09-17T12:06:10.744Z | 2024-09-19T12:19:51.351Z |
5101274 | 5101274 | 20240914001728_IQ32l | UK006H | 2024-09-17T12:05:31.454Z | 2024-09-19T12:19:50.144Z |
5101136 | 5101136 | 20240914000640_Hg5A7 | UK006H | 2024-09-17T12:05:21.705Z | 2024-09-19T12:19:49.851Z |
5101116 | 5101116 | 20240914000512_hOC8P | UK006H | 2024-09-17T12:05:21.078Z | 2024-09-19T12:19:49.821Z |
5100676 | 5100676 | 20240913234140_ATMyu | UK006H | 2024-09-17T12:04:48.901Z | 2024-09-19T12:19:48.527Z |
5099955 | 5099955 | 20240913222709_wt2pr | UK006H | 2024-09-17T12:03:46.100Z | 2024-09-19T12:19:46.608Z |
5097519 | 5097519 | 20240913005218_90IdC | UK006H | 2024-09-16T12:17:13.224Z | 2024-09-19T12:20:38.685Z |
5097365 | 5097365 | 20240913004415_UC5sh | UK006H | 2024-09-16T12:17:11.711Z | 2024-09-19T12:20:38.440Z |
5097222 | 5097222 | 20240913003705_Ox3Ai | UK006H | 2024-09-16T12:17:08.581Z | 2024-09-19T12:20:37.919Z |
5094815 | 5094815 | 20240912042504_aJsKv | UK006H | 2024-09-16T12:14:58.918Z | 2024-09-19T12:21:16.441Z |
5094784 | 5094784 | 20240912042311_R4At9 | UK006H | 2024-09-16T12:14:58.563Z | 2024-09-19T12:21:16.431Z |
5093857 | 5093857 | 20240912033956_1gjgJ | UK006H | 2024-09-16T12:14:26.918Z | 2024-09-19T12:21:15.698Z |
5093587 | 5093587 | 20240912032723_xlJNx | UK006H | 2024-09-16T12:14:21.526Z | 2024-09-19T12:21:15.420Z |
5093290 | 5093290 | 20240912031719_aUVbU | UK006H | 2024-09-16T12:14:14.735Z | 2024-09-19T12:21:15.210Z |
5093127 | 5093127 | 20240912031231_OMnQR | UK006H | 2024-09-16T12:14:11.820Z | 2024-09-19T12:21:14.948Z |
5092348 | 5092348 | 20240912024219_cpqog | UK006H | 2024-09-16T12:13:49.020Z | 2024-09-19T12:21:13.891Z |
5091254 | 5091254 | 20240912020357_rLAAz | UK006H | 2024-09-16T12:12:57.328Z | 2024-09-19T12:21:12.719Z |
5090748 | 5090748 | 20240912014347_878eI | UK006H | 2024-09-16T12:12:33.255Z | 2024-09-19T12:21:11.928Z |
5090654 | 5090654 | 20240912013609_CbRmd | UK006H | 2024-09-16T12:12:27.735Z | 2024-09-19T12:21:11.539Z |
5090505 | 5090505 | 20240912012829_SkQJG | UK006H | 2024-09-16T12:12:22.274Z | 2024-09-19T12:21:11.357Z |
5089633 | 5089633 | 20240912005204_9pMze | UK006H | 2024-09-16T12:11:33.223Z | 2024-09-19T12:21:10.111Z |
5089259 | 5089259 | 20240912003156_oe9n6 | UK006H | 2024-09-16T12:11:18.694Z | 2024-09-19T12:21:09.851Z |
5088433 | 5088433 | 20240913001113_JxY7y | UK006H | 2024-09-16T12:08:00.234Z | 2024-09-19T12:20:36.860Z |
5087657 | 5087657 | 20240912233810_jW2d9 | UK006H | 2024-09-16T12:07:10.456Z | 2024-09-19T12:20:35.523Z |
5087041 | 5087041 | 20240912230420_5B2BW | UK006H | 2024-09-16T12:06:28.270Z | 2024-09-19T12:20:33.606Z |
5086951 | 5086951 | 20240912225814_2ROBV | UK006H | 2024-09-16T12:06:16.132Z | 2024-09-19T12:20:33.177Z |
5086299 | 5086299 | 20240912222630_2oZag | UK006H | 2024-09-16T12:05:30.363Z | 2024-09-19T12:20:30.753Z |
5079787 | 5079787 | 20240911031117_90txk | UK006H | 2024-09-15T12:16:35.676Z | 2024-09-19T12:21:42.615Z |
5079667 | 5079667 | 20240911030729_0VUcO | UK006H | 2024-09-15T12:16:32.645Z | 2024-09-19T12:21:42.553Z |
5076427 | 5076427 | 20240910233551_MCS2b | UK006H | 2024-09-15T12:13:34.266Z | 2024-09-19T12:21:37.208Z |
5075691 | 5075691 | 20240912000134_dmtcU | UK006H | 2024-09-15T12:10:08.535Z | 2024-09-19T12:21:09.428Z |
5075505 | 5075505 | 20240911235200_KlSwZ | UK006H | 2024-09-15T12:09:56.701Z | 2024-09-19T12:21:09.253Z |
5075418 | 5075418 | 20240911234722_jY2wx | UK006H | 2024-09-15T12:09:43.238Z | 2024-09-19T12:21:09.207Z |
5075359 | 5075359 | 20240911234340_IesLY | UK006H | 2024-09-15T12:09:38.393Z | 2024-09-19T12:21:09.157Z |
5074026 | 5074026 | 20240911220835_d4NIX | UK006H | 2024-09-15T12:07:51.983Z | 2024-09-19T12:21:06.860Z |
5073975 | 5073975 | 20240911220054_uLxrM | UK006H | 2024-09-15T12:07:48.136Z | 2024-09-19T12:21:06.504Z |
5073673 | 5073673 | 20240911213846_INXu1 | UK006H | 2024-09-15T12:07:33.125Z | 2024-09-19T12:21:06.147Z |
5073643 | 5073643 | 20240911213738_vMIsy | UK006H | 2024-09-15T12:07:27.074Z | 2024-09-19T12:21:06.121Z |
5073504 | 5073504 | 20240911212759_pF7K3 | UK006H | 2024-09-15T12:07:13.405Z | 2024-09-19T12:21:05.832Z |
5073340 | 5073340 | 20240911211455_QpQHr | UK006H | 2024-09-15T12:07:04.286Z | 2024-09-19T12:21:05.675Z |
5073153 | 5073153 | 20240911210229_g4HKP | UK006H | 2024-09-15T12:06:50.382Z | 2024-09-19T12:21:05.187Z |
5072401 | 5072401 | 20240911200328_z2iCS | UK006H | 2024-09-15T12:05:18.464Z | 2024-09-19T12:21:04.062Z |
5072397 | 5072397 | 20240911200328_XdO41 | UK006H | 2024-09-15T12:05:18.172Z | 2024-09-19T12:21:04.058Z |
5009535 | 5009535 | 20240904013222_LkLAp | UK006H | 2024-09-09T12:07:48.710Z | 2024-09-12T12:19:23.258Z |
5009267 | 5009267 | 20240904010741_DaJDU | UK006H | 2024-09-09T12:07:33.047Z | 2024-09-12T12:19:22.240Z |
5009138 | 5009138 | 20240904005654_3Z7lp | UK006H | 2024-09-09T12:07:26.942Z | 2024-09-12T12:19:21.713Z |
5008028 | 5008028 | 20240903225428_ICDHc | UK006H | 2024-09-09T12:06:19.605Z | 2024-09-12T12:19:15.871Z |
5007187 | 5007187 | 20240903201952_Xwjqc | UK006H | 2024-09-09T12:05:33.302Z | 2024-09-12T12:19:11.972Z |
4973588 | 4973588 | 20240811225834_Ig6fv | UK006H | 2024-09-05T12:11:00.120Z | 2024-09-06T12:10:00.741Z |
4973426 | 4973426 | 20240811225639_96Z4o | UK006H | 2024-09-05T12:10:51.106Z | 2024-09-06T12:09:54.345Z |
4972756 | 4972756 | 20240811225003_tmrxr | UK006H | 2024-09-05T12:10:33.416Z | 2024-09-06T12:09:27.418Z |
4972055 | 4972055 | 20240811224239_C3pIV | UK006H | 2024-09-05T12:10:14.681Z | 2024-09-06T12:09:04.194Z |
4970937 | 4970937 | 20240811222948_Xklqe | UK006H | 2024-09-05T12:09:34.642Z | 2024-09-06T12:08:46.699Z |
4969977 | 4969977 | 20240811221930_NMAyk | UK006H | 2024-09-05T12:09:13.833Z | 2024-09-06T12:08:15.626Z |
4969652 | 4969652 | 20240811221405_u9IsN | UK006H | 2024-09-05T12:08:52.752Z | 2024-09-06T12:07:57.433Z |
4969414 | 4969414 | 20240811221140_LsYbp | UK006H | 2024-09-05T12:08:44.491Z | 2024-09-06T12:07:51.492Z |
4969399 | 4969399 | 20240811221130_8nkU0 | UK006H | 2024-09-05T12:08:44.318Z | 2024-09-06T12:07:51.370Z |
4969357 | 4969357 | 20240811221044_5d3ur | UK006H | 2024-09-05T12:08:43.325Z | 2024-09-06T12:07:50.573Z |
4969048 | 4969048 | 20240811220605_Xvy0A | UK006H | 2024-09-05T12:08:34.300Z | 2024-09-06T12:07:41.908Z |
4968818 | 4968818 | 20240811220259_v8mlt | UK006H | 2024-09-05T12:08:27.618Z | 2024-09-06T12:07:36.703Z |
4968238 | 4968238 | 20240811215555_qcBeL | UK006H | 2024-09-05T12:08:08.768Z | 2024-09-06T12:07:26.891Z |
4968185 | 4968185 | 20240811215525_3t8mv | UK006H | 2024-09-05T12:08:06.058Z | 2024-09-06T12:07:25.917Z |
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);