participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,064 rows where station_code = "UK005L" 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 |
---|---|---|---|---|---|
5454803 | 5454803 | 20241031052205_JIlLt | UK005L | 2024-11-02T12:23:23.808Z | 2024-11-08T14:23:25.710Z |
5454709 | 5454709 | 20241031045757_G6kk1 | UK005L | 2024-11-02T12:23:17.859Z | 2024-11-08T14:23:24.842Z |
5454489 | 5454489 | 20241031042951_5e20c | UK005L | 2024-11-02T12:23:07.644Z | 2024-11-08T14:23:23.366Z |
5454451 | 5454451 | 20241031042452_8OtK6 | UK005L | 2024-11-02T12:23:06.442Z | 2024-11-08T14:23:23.040Z |
5454442 | 5454442 | 20241031042334_BOe6j | UK005L | 2024-11-02T12:23:06.321Z | 2024-11-08T14:23:22.986Z |
5454292 | 5454292 | 20241031040613_ySWkU | UK005L | 2024-11-02T12:22:58.978Z | 2024-11-08T14:23:22.048Z |
5454229 | 5454229 | 20241031040034_0yq9j | UK005L | 2024-11-02T12:22:55.564Z | 2024-11-08T14:23:21.657Z |
5454200 | 5454200 | 20241031035545_lYDGS | UK005L | 2024-11-02T12:22:54.431Z | 2024-11-08T14:23:21.340Z |
5453896 | 5453896 | 20241031031334_8gypc | UK005L | 2024-11-02T12:22:44.494Z | 2024-11-08T14:23:19.644Z |
5453717 | 5453717 | 20241031025145_MAqQw | UK005L | 2024-11-02T12:22:41.024Z | 2024-11-08T14:23:18.906Z |
5453690 | 5453690 | 20241031024549_qgc5L | UK005L | 2024-11-02T12:22:40.554Z | 2024-11-08T14:23:18.697Z |
5453485 | 5453485 | 20241031021533_suTNg | UK005L | 2024-11-02T12:22:34.496Z | 2024-11-08T14:23:17.588Z |
5453475 | 5453475 | 20241031021532_ZYF4X | UK005L | 2024-11-02T12:22:34.408Z | 2024-11-08T14:23:17.584Z |
5453465 | 5453465 | 20241031021433_C3sav | UK005L | 2024-11-02T12:22:34.207Z | 2024-11-08T14:23:17.537Z |
5453410 | 5453410 | 20241031020958_T3SLL | UK005L | 2024-11-02T12:22:33.187Z | 2024-11-08T14:23:17.307Z |
5453276 | 5453276 | 20241031015617_QfTxY | UK005L | 2024-11-02T12:22:30.862Z | 2024-11-08T14:23:16.289Z |
5453251 | 5453251 | 20241031015350_Le1BT | UK005L | 2024-11-02T12:22:30.428Z | 2024-11-08T14:23:16.230Z |
5453240 | 5453240 | 20241031015324_KqijA | UK005L | 2024-11-02T12:22:30.218Z | 2024-11-08T14:23:16.209Z |
5453219 | 5453219 | 20241031015201_UuaOJ | UK005L | 2024-11-02T12:22:30.017Z | 2024-11-08T14:23:16.184Z |
5453048 | 5453048 | 20241031013102_nc4av | UK005L | 2024-11-02T12:22:24.860Z | 2024-11-08T14:23:15.792Z |
5451042 | 5451042 | 20241031222536_0BJ2K | UK005L | 2024-11-02T12:16:32.122Z | 2024-11-09T14:24:21.010Z |
5451021 | 5451021 | 20241031221943_QGEpT | UK005L | 2024-11-02T12:16:30.748Z | 2024-11-09T14:24:20.804Z |
5450981 | 5450981 | 20241031220904_J3V2E | UK005L | 2024-11-02T12:16:27.200Z | 2024-11-09T14:24:20.428Z |
5450687 | 5450687 | 20241031202009_3L1qa | UK005L | 2024-11-02T12:15:44.746Z | 2024-11-09T14:24:17.569Z |
5450684 | 5450684 | 20241031201954_YpS98 | UK005L | 2024-11-02T12:15:44.477Z | 2024-11-09T14:24:17.535Z |
5450378 | 5450378 | 20241031190445_FF8eC | UK005L | 2024-11-02T12:15:08.306Z | 2024-11-09T14:24:15.771Z |
5450353 | 5450353 | 20241031185544_Gn3Xu | UK005L | 2024-11-02T12:15:01.008Z | 2024-11-09T14:24:15.683Z |
5444477 | 5444477 | 20241031012455_BVFLH | UK005L | 2024-11-01T12:21:19.633Z | 2024-11-08T14:23:15.710Z |
5432947 | 5432947 | 20241029052349_N2K4C | UK005L | 2024-10-31T12:21:40.843Z | 2024-11-06T14:27:29.374Z |
5410628 | 5410628 | 20241027052423_dD6oi | UK005L | 2024-10-29T12:17:59.829Z | 2024-11-04T14:29:05.126Z |
5410444 | 5410444 | 20241027051311_2TBK8 | UK005L | 2024-10-29T12:17:55.799Z | 2024-11-04T14:29:04.601Z |
5410200 | 5410200 | 20241027045939_2YCSm | UK005L | 2024-10-29T12:17:50.640Z | 2024-11-04T14:29:04.040Z |
5410179 | 5410179 | 20241027045842_zgaZJ | UK005L | 2024-10-29T12:17:50.045Z | 2024-11-04T14:29:03.987Z |
5410167 | 5410167 | 20241027045832_yZY1r | UK005L | 2024-10-29T12:17:49.746Z | 2024-11-04T14:29:03.980Z |
5410048 | 5410048 | 20241027044921_a0NsN | UK005L | 2024-10-29T12:17:46.601Z | 2024-11-04T14:29:03.633Z |
5409695 | 5409695 | 20241027043055_OcZwY | UK005L | 2024-10-29T12:17:38.061Z | 2024-11-04T14:29:02.157Z |
5409680 | 5409680 | 20241027043024_nzHgl | UK005L | 2024-10-29T12:17:37.562Z | 2024-11-04T14:29:02.149Z |
5409665 | 5409665 | 20241027042959_eyu1f | UK005L | 2024-10-29T12:17:36.363Z | 2024-11-04T14:29:02.061Z |
5409594 | 5409594 | 20241027042736_61ERe | UK005L | 2024-10-29T12:17:32.048Z | 2024-11-04T14:29:01.970Z |
5409505 | 5409505 | 20241027042230_ZaRyf | UK005L | 2024-10-29T12:17:27.029Z | 2024-11-04T14:29:01.919Z |
5409188 | 5409188 | 20241027040511_pf95o | UK005L | 2024-10-29T12:17:10.694Z | 2024-11-04T14:29:01.357Z |
5409170 | 5409170 | 20241027040355_02mPc | UK005L | 2024-10-29T12:17:09.544Z | 2024-11-04T14:29:01.235Z |
5409156 | 5409156 | 20241027040324_piW2n | UK005L | 2024-10-29T12:17:09.260Z | 2024-11-04T14:29:01.228Z |
5403749 | 5403749 | 20241026222751_Myfx3 | UK005L | 2024-10-29T12:10:11.428Z | 2024-11-04T14:28:49.541Z |
5403406 | 5403406 | 20241026215414_l20z6 | UK005L | 2024-10-29T12:09:27.764Z | 2024-11-04T14:28:48.729Z |
5402969 | 5402969 | 20241026205452_q5fGv | UK005L | 2024-10-29T12:08:41.010Z | 2024-11-04T14:28:47.222Z |
5402737 | 5402737 | 20241026201728_El9Yn | UK005L | 2024-10-29T12:08:02.355Z | 2024-11-04T14:28:46.424Z |
5402073 | 5402073 | 20241026184122_v3ec2 | UK005L | 2024-10-29T12:06:22.027Z | 2024-11-04T14:28:42.139Z |
5400179 | 5400179 | 20241026055029_ulbyN | UK005L | 2024-10-28T12:20:25.562Z | 2024-11-03T14:27:41.457Z |
5399984 | 5399984 | 20241026051859_o7xBp | UK005L | 2024-10-28T12:20:18.080Z | 2024-11-03T14:27:40.945Z |
5399923 | 5399923 | 20241026051244_7DCHG | UK005L | 2024-10-28T12:20:17.051Z | 2024-11-03T14:27:40.809Z |
5399835 | 5399835 | 20241026050544_xSz35 | UK005L | 2024-10-28T12:20:12.985Z | 2024-11-03T14:27:40.596Z |
5399798 | 5399798 | 20241026050403_3BBeh | UK005L | 2024-10-28T12:20:11.433Z | 2024-11-03T14:27:40.530Z |
5399788 | 5399788 | 20241026050252_s3bXi | UK005L | 2024-10-28T12:20:11.121Z | 2024-11-03T14:27:40.512Z |
5399711 | 5399711 | 20241026045313_jRIYs | UK005L | 2024-10-28T12:20:08.464Z | 2024-11-03T14:27:40.307Z |
5399583 | 5399583 | 20241026043612_3F26A | UK005L | 2024-10-28T12:20:03.245Z | 2024-11-03T14:27:40.016Z |
5399565 | 5399565 | 20241026043500_C44VJ | UK005L | 2024-10-28T12:20:02.615Z | 2024-11-03T14:27:39.991Z |
5399545 | 5399545 | 20241026043334_KwyFm | UK005L | 2024-10-28T12:20:01.764Z | 2024-11-03T14:27:39.944Z |
5399521 | 5399521 | 20241026043116_8BuFI | UK005L | 2024-10-28T12:20:01.473Z | 2024-11-03T14:27:39.921Z |
5399392 | 5399392 | 20241026041435_RzvOD | UK005L | 2024-10-28T12:19:57.883Z | 2024-11-03T14:27:39.596Z |
5399187 | 5399187 | 20241026040020_gCgy8 | UK005L | 2024-10-28T12:19:50.893Z | 2024-11-03T14:27:39.195Z |
5399167 | 5399167 | 20241026035758_sfM3v | UK005L | 2024-10-28T12:19:50.312Z | 2024-11-03T14:27:39.167Z |
5399047 | 5399047 | 20241026034658_XAPTn | UK005L | 2024-10-28T12:19:45.704Z | 2024-11-03T14:27:38.944Z |
5398903 | 5398903 | 20241026033659_pKDuf | UK005L | 2024-10-28T12:19:39.733Z | 2024-11-03T14:27:38.385Z |
5398671 | 5398671 | 20241026031742_FQSWC | UK005L | 2024-10-28T12:19:27.809Z | 2024-11-03T14:27:37.575Z |
5398614 | 5398614 | 20241026031125_WjZLQ | UK005L | 2024-10-28T12:19:23.982Z | 2024-11-03T14:27:36.922Z |
5398545 | 5398545 | 20241026030600_My2El | UK005L | 2024-10-28T12:19:21.085Z | 2024-11-03T14:27:36.769Z |
5398453 | 5398453 | 20241026025844_MMiX6 | UK005L | 2024-10-28T12:19:17.672Z | 2024-11-03T14:27:36.382Z |
5398219 | 5398219 | 20241026023545_0ejDj | UK005L | 2024-10-28T12:19:06.610Z | 2024-11-03T14:27:35.703Z |
5398059 | 5398059 | 20241026022147_4ba2X | UK005L | 2024-10-28T12:18:59.333Z | 2024-11-03T14:27:35.247Z |
5397951 | 5397951 | 20241026021014_cfCL9 | UK005L | 2024-10-28T12:18:52.125Z | 2024-11-03T14:27:34.693Z |
5397852 | 5397852 | 20241026020225_ICukr | UK005L | 2024-10-28T12:18:48.222Z | 2024-11-03T14:27:34.330Z |
5397845 | 5397845 | 20241026020215_MFn0G | UK005L | 2024-10-28T12:18:48.156Z | 2024-11-03T14:27:34.321Z |
5397826 | 5397826 | 20241026020036_vb16F | UK005L | 2024-10-28T12:18:46.071Z | 2024-11-03T14:27:34.279Z |
5397592 | 5397592 | 20241026014214_3AXVd | UK005L | 2024-10-28T12:18:29.389Z | 2024-11-03T14:27:33.437Z |
5397561 | 5397561 | 20241026014028_nsl8j | UK005L | 2024-10-28T12:18:27.973Z | 2024-11-03T14:27:33.405Z |
5397217 | 5397217 | 20241026011130_jf8xS | UK005L | 2024-10-28T12:18:11.604Z | 2024-11-03T14:27:32.206Z |
5396905 | 5396905 | 20241026004441_kvqiH | UK005L | 2024-10-28T12:17:59.023Z | 2024-11-03T14:27:31.304Z |
5396790 | 5396790 | 20241026003433_Cd2Uw | UK005L | 2024-10-28T12:17:55.717Z | 2024-11-03T14:27:30.910Z |
5396746 | 5396746 | 20241026002953_Eyd7d | UK005L | 2024-10-28T12:17:54.983Z | 2024-11-03T14:27:30.839Z |
5396674 | 5396674 | 20241026002116_XRsiY | UK005L | 2024-10-28T12:17:52.635Z | 2024-11-03T14:27:30.596Z |
5396597 | 5396597 | 20241026001602_UM8eL | UK005L | 2024-10-28T12:17:50.704Z | 2024-11-03T14:27:30.426Z |
5396524 | 5396524 | 20241026000936_a8GSi | UK005L | 2024-10-28T12:17:48.737Z | 2024-11-03T14:27:30.057Z |
5396484 | 5396484 | 20241026000712_K7xmw | UK005L | 2024-10-28T12:17:45.763Z | 2024-11-03T14:27:29.968Z |
5396479 | 5396479 | 20241026000636_1MjHf | UK005L | 2024-10-28T12:17:45.605Z | 2024-11-03T14:27:29.966Z |
5396262 | 5396262 | 20241025235121_itbwD | UK005L | 2024-10-28T12:17:29.212Z | 2024-11-03T14:27:29.129Z |
5395870 | 5395870 | 20241025231656_HM7e3 | UK005L | 2024-10-28T12:17:02.129Z | 2024-11-03T14:27:27.445Z |
5395648 | 5395648 | 20241025230135_dTi3N | UK005L | 2024-10-28T12:16:35.750Z | 2024-11-03T14:27:26.329Z |
5395593 | 5395593 | 20241025225743_SQKAS | UK005L | 2024-10-28T12:16:30.636Z | 2024-11-03T14:27:26.084Z |
5395549 | 5395549 | 20241025225221_nNHnq | UK005L | 2024-10-28T12:16:26.190Z | 2024-11-03T14:27:25.739Z |
5395446 | 5395446 | 20241025224353_22kRG | UK005L | 2024-10-28T12:16:14.786Z | 2024-11-03T14:27:25.562Z |
5395070 | 5395070 | 20241025220556_KUWr1 | UK005L | 2024-10-28T12:15:55.315Z | 2024-11-03T14:27:23.895Z |
5394709 | 5394709 | 20241025211310_cCCIa | UK005L | 2024-10-28T12:15:16.475Z | 2024-11-03T14:27:22.376Z |
5394320 | 5394320 | 20241025201520_prI48 | UK005L | 2024-10-28T12:14:23.034Z | 2024-11-03T14:27:20.875Z |
5393915 | 5393915 | 20241025191051_L2hsK | UK005L | 2024-10-28T12:13:52.548Z | 2024-11-03T14:27:19.051Z |
5393773 | 5393773 | 20241025184059_YG5nQ | UK005L | 2024-10-28T12:13:18.024Z | 2024-11-03T14:27:18.143Z |
5377396 | 5377396 | 20241024044850_zVkJe | UK005L | 2024-10-26T12:22:36.416Z | 2024-11-01T12:27:02.417Z |
5377062 | 5377062 | 20241024043153_FJeby | UK005L | 2024-10-26T12:22:25.496Z | 2024-11-01T12:27:02.169Z |
5377052 | 5377052 | 20241024043043_5fhx2 | UK005L | 2024-10-26T12:22:25.195Z | 2024-11-01T12:27:02.166Z |
5377007 | 5377007 | 20241024042920_lmsLU | UK005L | 2024-10-26T12:22:22.838Z | 2024-11-01T12:27:02.124Z |
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);