participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,671 rows where station_code = "UK00AE" 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 |
---|---|---|---|---|---|
5454895 | 5454895 | 20241031054114_Yq36M | UK00AE | 2024-11-02T12:23:26.111Z | 2024-11-08T14:23:26.147Z |
5454813 | 5454813 | 20241031052254_7f3pm | UK00AE | 2024-11-02T12:23:23.935Z | 2024-11-08T14:23:25.801Z |
5454787 | 5454787 | 20241031051641_voIyP | UK00AE | 2024-11-02T12:23:23.145Z | 2024-11-08T14:23:25.649Z |
5454667 | 5454667 | 20241031045333_pVNad | UK00AE | 2024-11-02T12:23:16.023Z | 2024-11-08T14:23:24.674Z |
5454635 | 5454635 | 20241031044754_d7Wih | UK00AE | 2024-11-02T12:23:15.003Z | 2024-11-08T14:23:24.510Z |
5454453 | 5454453 | 20241031042452_8OtK6 | UK00AE | 2024-11-02T12:23:06.442Z | 2024-11-08T14:23:23.040Z |
5454435 | 5454435 | 20241031042131_rR3z1 | UK00AE | 2024-11-02T12:23:06.242Z | 2024-11-08T14:23:22.969Z |
5454294 | 5454294 | 20241031040613_ySWkU | UK00AE | 2024-11-02T12:22:58.978Z | 2024-11-08T14:23:22.048Z |
5454272 | 5454272 | 20241031040417_rKXbw | UK00AE | 2024-11-02T12:22:57.452Z | 2024-11-08T14:23:21.969Z |
5454203 | 5454203 | 20241031035545_lYDGS | UK00AE | 2024-11-02T12:22:54.431Z | 2024-11-08T14:23:21.340Z |
5454134 | 5454134 | 20241031034503_tpHBa | UK00AE | 2024-11-02T12:22:51.601Z | 2024-11-08T14:23:20.655Z |
5453157 | 5453157 | 20241031014541_JbXG3 | UK00AE | 2024-11-02T12:22:28.314Z | 2024-11-08T14:23:16.102Z |
5444511 | 5444511 | 20241031012717_yV29g | UK00AE | 2024-11-01T12:21:20.534Z | 2024-11-08T14:23:15.777Z |
5444417 | 5444417 | 20241031011842_qmR1B | UK00AE | 2024-11-01T12:21:16.924Z | 2024-11-08T14:23:15.387Z |
5443845 | 5443845 | 20241031002027_qulJ4 | UK00AE | 2024-11-01T12:20:54.046Z | 2024-11-08T14:23:12.726Z |
5440980 | 5440980 | 20241030233139_XmOp1 | UK00AE | 2024-11-01T12:16:05.406Z | 2024-11-08T14:23:11.494Z |
5440964 | 5440964 | 20241030233030_DIGlF | UK00AE | 2024-11-01T12:16:04.425Z | 2024-11-08T14:23:11.355Z |
5440940 | 5440940 | 20241030232703_ldx0J | UK00AE | 2024-11-01T12:16:02.898Z | 2024-11-08T14:23:11.200Z |
5440860 | 5440860 | 20241030231617_rOR0p | UK00AE | 2024-11-01T12:15:55.201Z | 2024-11-08T14:23:10.835Z |
5440838 | 5440838 | 20241030231422_zBdcA | UK00AE | 2024-11-01T12:15:53.961Z | 2024-11-08T14:23:10.805Z |
5440612 | 5440612 | 20241030223312_rdKXI | UK00AE | 2024-11-01T12:15:39.028Z | 2024-11-08T14:23:10.014Z |
5440604 | 5440604 | 20241030223145_gdtLg | UK00AE | 2024-11-01T12:15:38.813Z | 2024-11-08T14:23:09.991Z |
5440599 | 5440599 | 20241030223112_2scyg | UK00AE | 2024-11-01T12:15:38.649Z | 2024-11-08T14:23:09.976Z |
5440544 | 5440544 | 20241030222632_XdSPO | UK00AE | 2024-11-01T12:15:36.325Z | 2024-11-08T14:23:09.885Z |
5440267 | 5440267 | 20241030214934_ROcwb | UK00AE | 2024-11-01T12:15:07.824Z | 2024-11-08T14:23:08.488Z |
5440242 | 5440242 | 20241030214604_HKiF0 | UK00AE | 2024-11-01T12:15:04.198Z | 2024-11-08T14:23:08.188Z |
5440000 | 5440000 | 20241030210438_SsIqy | UK00AE | 2024-11-01T12:14:43.632Z | 2024-11-08T14:23:06.692Z |
5439980 | 5439980 | 20241030210032_W42aY | UK00AE | 2024-11-01T12:14:41.987Z | 2024-11-08T14:23:06.586Z |
5439919 | 5439919 | 20241030204924_7dTfz | UK00AE | 2024-11-01T12:14:38.265Z | 2024-11-08T14:23:06.124Z |
5439679 | 5439679 | 20241030201856_P1upf | UK00AE | 2024-11-01T12:14:08.182Z | 2024-11-08T14:23:04.934Z |
5439588 | 5439588 | 20241030201130_sH7Xc | UK00AE | 2024-11-01T12:14:00.773Z | 2024-11-08T14:23:04.239Z |
5439381 | 5439381 | 20241030194941_C27WM | UK00AE | 2024-11-01T12:13:46.080Z | 2024-11-08T14:23:03.205Z |
5432264 | 5432264 | 20241029030351_NdA84 | UK00AE | 2024-10-31T12:21:15.826Z | 2024-11-06T14:27:26.407Z |
5432149 | 5432149 | 20241029024835_OiDUJ | UK00AE | 2024-10-31T12:21:07.067Z | 2024-11-06T14:27:26.117Z |
5432115 | 5432115 | 20241029024404_qdDwu | UK00AE | 2024-10-31T12:21:03.310Z | 2024-11-06T14:27:25.982Z |
5432104 | 5432104 | 20241029024259_2NTwA | UK00AE | 2024-10-31T12:21:02.681Z | 2024-11-06T14:27:25.966Z |
5431410 | 5431410 | 20241029010638_1djT3 | UK00AE | 2024-10-31T12:20:06.200Z | 2024-11-06T14:27:23.523Z |
5431307 | 5431307 | 20241029005343_qcx7Y | UK00AE | 2024-10-31T12:19:52.928Z | 2024-11-06T14:27:23.247Z |
5431281 | 5431281 | 20241029004958_s14Vx | UK00AE | 2024-10-31T12:19:50.109Z | 2024-11-06T14:27:23.117Z |
5431277 | 5431277 | 20241029004744_P6BoN | UK00AE | 2024-10-31T12:19:49.713Z | 2024-11-06T14:27:23.109Z |
5431192 | 5431192 | 20241029004019_hqxaa | UK00AE | 2024-10-31T12:19:44.969Z | 2024-11-06T14:27:22.943Z |
5422840 | 5422840 | 20241026182846_BKp4a | UK00AE | 2024-10-30T12:21:39.645Z | 2024-11-04T14:28:41.676Z |
5417769 | 5417769 | 20241027191218_36ro4 | UK00AE | 2024-10-30T12:14:26.874Z | 2024-11-05T14:27:08.205Z |
5417389 | 5417389 | 20241027182423_uZC1j | UK00AE | 2024-10-30T12:13:36.314Z | 2024-11-05T14:27:07.156Z |
5410178 | 5410178 | 20241027045834_ZwIQq | UK00AE | 2024-10-29T12:17:49.860Z | 2024-11-04T14:29:03.984Z |
5409933 | 5409933 | 20241027044239_eUWQD | UK00AE | 2024-10-29T12:17:44.176Z | 2024-11-04T14:29:02.941Z |
5409867 | 5409867 | 20241027043852_w2XyA | UK00AE | 2024-10-29T12:17:42.690Z | 2024-11-04T14:29:02.825Z |
5409751 | 5409751 | 20241027043354_Z88pE | UK00AE | 2024-10-29T12:17:40.111Z | 2024-11-04T14:29:02.540Z |
5409746 | 5409746 | 20241027043331_VxE3m | UK00AE | 2024-10-29T12:17:39.900Z | 2024-11-04T14:29:02.428Z |
5409373 | 5409373 | 20241027041313_2xtwb | UK00AE | 2024-10-29T12:17:18.481Z | 2024-11-04T14:29:01.604Z |
5409067 | 5409067 | 20241027035806_e0jiW | UK00AE | 2024-10-29T12:17:04.412Z | 2024-11-04T14:29:01.026Z |
5409024 | 5409024 | 20241027035545_CacHo | UK00AE | 2024-10-29T12:17:01.736Z | 2024-11-04T14:29:00.940Z |
5409017 | 5409017 | 20241027035431_D2JLe | UK00AE | 2024-10-29T12:17:01.422Z | 2024-11-04T14:29:00.936Z |
5408922 | 5408922 | 20241027034956_e8IYl | UK00AE | 2024-10-29T12:16:57.132Z | 2024-11-04T14:29:00.824Z |
5408860 | 5408860 | 20241027034647_9Rrkv | UK00AE | 2024-10-29T12:16:55.008Z | 2024-11-04T14:29:00.733Z |
5407941 | 5407941 | 20241027025839_GLXBN | UK00AE | 2024-10-29T12:15:54.213Z | 2024-11-04T14:28:58.515Z |
5407775 | 5407775 | 20241027025204_lUWIS | UK00AE | 2024-10-29T12:15:40.168Z | 2024-11-04T14:28:58.140Z |
5407511 | 5407511 | 20241027023954_3TMor | UK00AE | 2024-10-29T12:15:27.771Z | 2024-11-04T14:28:57.810Z |
5407300 | 5407300 | 20241027023036_BfjWF | UK00AE | 2024-10-29T12:15:20.142Z | 2024-11-04T14:28:57.298Z |
5407230 | 5407230 | 20241027022720_ekEnm | UK00AE | 2024-10-29T12:15:17.885Z | 2024-11-04T14:28:57.254Z |
5407154 | 5407154 | 20241027022404_742y8 | UK00AE | 2024-10-29T12:15:14.952Z | 2024-11-04T14:28:57.110Z |
5407039 | 5407039 | 20241027021751_ZtfmF | UK00AE | 2024-10-29T12:15:09.757Z | 2024-11-04T14:28:56.791Z |
5406585 | 5406585 | 20241027014709_n6cY3 | UK00AE | 2024-10-29T12:14:22.810Z | 2024-11-04T14:28:55.890Z |
5406219 | 5406219 | 20241027012219_osdwy | UK00AE | 2024-10-29T12:13:57.539Z | 2024-11-04T14:28:55.219Z |
5406213 | 5406213 | 20241027012210_xx3By | UK00AE | 2024-10-29T12:13:57.376Z | 2024-11-04T14:28:55.210Z |
5406157 | 5406157 | 20241027011941_us5rC | UK00AE | 2024-10-29T12:13:54.080Z | 2024-11-04T14:28:55.168Z |
5406080 | 5406080 | 20241027011419_PO33W | UK00AE | 2024-10-29T12:13:50.498Z | 2024-11-04T14:28:54.974Z |
5405987 | 5405987 | 20241027011146_1oNZQ | UK00AE | 2024-10-29T12:13:44.803Z | 2024-11-04T14:28:54.819Z |
5405914 | 5405914 | 20241027010720_Zw4Tl | UK00AE | 2024-10-29T12:13:32.374Z | 2024-11-04T14:28:54.601Z |
5405882 | 5405882 | 20241027010546_fxSH3 | UK00AE | 2024-10-29T12:13:27.709Z | 2024-11-04T14:28:54.559Z |
5405686 | 5405686 | 20241027005316_bssPK | UK00AE | 2024-10-29T12:13:09.536Z | 2024-11-04T14:28:53.898Z |
5405662 | 5405662 | 20241027005228_PfhNB | UK00AE | 2024-10-29T12:13:08.385Z | 2024-11-04T14:28:53.878Z |
5405613 | 5405613 | 20241027004849_9hCG4 | UK00AE | 2024-10-29T12:13:04.574Z | 2024-11-04T14:28:53.710Z |
5405511 | 5405511 | 20241027003956_3XpyO | UK00AE | 2024-10-29T12:12:59.591Z | 2024-11-04T14:28:53.580Z |
5405498 | 5405498 | 20241027003919_0vBKq | UK00AE | 2024-10-29T12:12:59.199Z | 2024-11-04T14:28:53.564Z |
5405481 | 5405481 | 20241027003841_rQvnl | UK00AE | 2024-10-29T12:12:58.479Z | 2024-11-04T14:28:53.547Z |
5405468 | 5405468 | 20241027003741_xfioa | UK00AE | 2024-10-29T12:12:57.470Z | 2024-11-04T14:28:53.528Z |
5405341 | 5405341 | 20241027002907_1x3el | UK00AE | 2024-10-29T12:12:50.167Z | 2024-11-04T14:28:53.294Z |
5405292 | 5405292 | 20241027002707_xYNQt | UK00AE | 2024-10-29T12:12:48.269Z | 2024-11-04T14:28:53.254Z |
5405045 | 5405045 | 20241027001005_sYxuw | UK00AE | 2024-10-29T12:12:19.220Z | 2024-11-04T14:28:52.617Z |
5404940 | 5404940 | 20241027000206_GcvvA | UK00AE | 2024-10-29T12:12:08.794Z | 2024-11-04T14:28:52.436Z |
5404614 | 5404614 | 20241026234047_H30uQ | UK00AE | 2024-10-29T12:11:46.007Z | 2024-11-04T14:28:51.410Z |
5404402 | 5404402 | 20241026232310_huiNO | UK00AE | 2024-10-29T12:11:18.993Z | 2024-11-04T14:28:50.851Z |
5404088 | 5404088 | 20241026225640_Mx9Bw | UK00AE | 2024-10-29T12:10:52.615Z | 2024-11-04T14:28:50.320Z |
5404017 | 5404017 | 20241026225307_zY5cN | UK00AE | 2024-10-29T12:10:48.284Z | 2024-11-04T14:28:50.242Z |
5403751 | 5403751 | 20241026222751_Myfx3 | UK00AE | 2024-10-29T12:10:11.428Z | 2024-11-04T14:28:49.541Z |
5403672 | 5403672 | 20241026222240_C47Zp | UK00AE | 2024-10-29T12:10:06.535Z | 2024-11-04T14:28:49.438Z |
5403658 | 5403658 | 20241026222121_uQvh2 | UK00AE | 2024-10-29T12:10:05.187Z | 2024-11-04T14:28:49.400Z |
5403636 | 5403636 | 20241026221849_qC8hl | UK00AE | 2024-10-29T12:10:03.494Z | 2024-11-04T14:28:49.373Z |
5403437 | 5403437 | 20241026215616_gM3Z8 | UK00AE | 2024-10-29T12:09:30.127Z | 2024-11-04T14:28:48.821Z |
5403279 | 5403279 | 20241026213540_6RNrh | UK00AE | 2024-10-29T12:09:18.338Z | 2024-11-04T14:28:48.259Z |
5403075 | 5403075 | 20241026211518_74PqD | UK00AE | 2024-10-29T12:08:52.434Z | 2024-11-04T14:28:47.680Z |
5402817 | 5402817 | 20241026202902_ZJYYP | UK00AE | 2024-10-29T12:08:17.949Z | 2024-11-04T14:28:46.630Z |
5402750 | 5402750 | 20241026201918_PXVF6 | UK00AE | 2024-10-29T12:08:04.947Z | 2024-11-04T14:28:46.433Z |
5402560 | 5402560 | 20241026195701_XebLJ | UK00AE | 2024-10-29T12:07:42.287Z | 2024-11-04T14:28:45.290Z |
5402486 | 5402486 | 20241026194441_2luwM | UK00AE | 2024-10-29T12:07:23.515Z | 2024-11-04T14:28:44.772Z |
5402308 | 5402308 | 20241026191456_5R3ez | UK00AE | 2024-10-29T12:06:58.376Z | 2024-11-04T14:28:43.688Z |
5402240 | 5402240 | 20241026190525_zPSdF | UK00AE | 2024-10-29T12:06:43.391Z | 2024-11-04T14:28:43.326Z |
5402126 | 5402126 | 20241026184707_7buar | UK00AE | 2024-10-29T12:06:28.717Z | 2024-11-04T14:28:42.411Z |
5402016 | 5402016 | 20241026182437_Npo1r | UK00AE | 2024-10-29T12:06:04.080Z | 2024-11-04T14:28:41.575Z |
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);