participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
7,875 rows where station_code = "UK001Z" 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 |
---|---|---|---|---|---|
5569882 | 5569882 | 20241120175338_khRPy | UK001Z | 2024-11-22T14:14:29.587Z | 2024-11-22T14:19:21.822Z |
5565471 | 5565471 | 20241120042920_9KRta | UK001Z | 2024-11-21T14:18:50.199Z | 2024-11-22T14:21:47.482Z |
5565375 | 5565375 | 20241120042149_x4jjK | UK001Z | 2024-11-21T14:18:47.561Z | 2024-11-22T14:21:46.292Z |
5564951 | 5564951 | 20241120034200_cwBGQ | UK001Z | 2024-11-21T14:18:16.312Z | 2024-11-22T14:21:39.753Z |
5564815 | 5564815 | 20241120032910_W8T1X | UK001Z | 2024-11-21T14:18:05.332Z | 2024-11-22T14:21:36.725Z |
5564652 | 5564652 | 20241120031615_kBSKe | UK001Z | 2024-11-21T14:17:55.348Z | 2024-11-22T14:21:34.929Z |
5564537 | 5564537 | 20241120030745_3Svql | UK001Z | 2024-11-21T14:17:47.420Z | 2024-11-22T14:21:33.414Z |
5564427 | 5564427 | 20241120025723_V3rfT | UK001Z | 2024-11-21T14:17:35.025Z | 2024-11-22T14:21:31.776Z |
5564324 | 5564324 | 20241120024821_HgXM0 | UK001Z | 2024-11-21T14:17:27.541Z | 2024-11-22T14:21:30.498Z |
5564240 | 5564240 | 20241120024056_lXHGV | UK001Z | 2024-11-21T14:17:21.434Z | 2024-11-22T14:21:29.289Z |
5564231 | 5564231 | 20241120024052_F3pwJ | UK001Z | 2024-11-21T14:17:21.119Z | 2024-11-22T14:21:29.276Z |
5564206 | 5564206 | 20241120023920_fbF9f | UK001Z | 2024-11-21T14:17:18.872Z | 2024-11-22T14:21:28.962Z |
5564053 | 5564053 | 20241120022621_zVcIL | UK001Z | 2024-11-21T14:17:07.231Z | 2024-11-22T14:21:26.753Z |
5563927 | 5563927 | 20241120021657_hKzAn | UK001Z | 2024-11-21T14:16:59.251Z | 2024-11-22T14:21:25.537Z |
5563787 | 5563787 | 20241120020425_FHfTL | UK001Z | 2024-11-21T14:16:43.969Z | 2024-11-22T14:21:22.950Z |
5563696 | 5563696 | 20241120015822_Gtn1C | UK001Z | 2024-11-21T14:16:34.990Z | 2024-11-22T14:21:21.210Z |
5563662 | 5563662 | 20241120015610_nhvlD | UK001Z | 2024-11-21T14:16:32.527Z | 2024-11-22T14:21:20.440Z |
5563597 | 5563597 | 20241120015033_n2fMe | UK001Z | 2024-11-21T14:16:26.527Z | 2024-11-22T14:21:19.611Z |
5563482 | 5563482 | 20241120013358_SqA4s | UK001Z | 2024-11-21T14:16:10.410Z | 2024-11-22T14:21:16.718Z |
5563399 | 5563399 | 20241120012646_wTCjj | UK001Z | 2024-11-21T14:16:02.461Z | 2024-11-22T14:21:14.911Z |
5563353 | 5563353 | 20241120011935_0sJJ1 | UK001Z | 2024-11-21T14:15:58.463Z | 2024-11-22T14:21:13.509Z |
5563102 | 5563102 | 20241120005255_SpSvv | UK001Z | 2024-11-21T14:15:36.930Z | 2024-11-22T14:21:09.646Z |
5563040 | 5563040 | 20241120004451_7pxI9 | UK001Z | 2024-11-21T14:15:32.581Z | 2024-11-22T14:21:07.941Z |
5563029 | 5563029 | 20241120004428_2z2J3 | UK001Z | 2024-11-21T14:15:32.277Z | 2024-11-22T14:21:07.925Z |
5563001 | 5563001 | 20241120003931_y0m2p | UK001Z | 2024-11-21T14:15:31.480Z | 2024-11-22T14:21:07.671Z |
5562983 | 5562983 | 20241120003609_uhhB1 | UK001Z | 2024-11-21T14:15:30.769Z | 2024-11-22T14:21:07.463Z |
5562882 | 5562882 | 20241120002358_gYo9I | UK001Z | 2024-11-21T14:15:26.176Z | 2024-11-22T14:21:05.877Z |
5562693 | 5562693 | 20241120000409_kYvs2 | UK001Z | 2024-11-21T14:15:17.226Z | 2024-11-22T14:21:02.583Z |
5562300 | 5562300 | 20241119232023_Fqa4N | UK001Z | 2024-11-21T14:14:41.402Z | 2024-11-22T14:20:55.637Z |
5562196 | 5562196 | 20241119230919_uMTyK | UK001Z | 2024-11-21T14:14:31.654Z | 2024-11-22T14:20:53.891Z |
5562186 | 5562186 | 20241119230853_SBsHs | UK001Z | 2024-11-21T14:14:31.459Z | 2024-11-22T14:20:53.868Z |
5561910 | 5561910 | 20241119222847_Ty2v9 | UK001Z | 2024-11-21T14:14:13.547Z | 2024-11-22T14:20:49.251Z |
5561885 | 5561885 | 20241119222438_Tnv3d | UK001Z | 2024-11-21T14:14:12.526Z | 2024-11-22T14:20:48.989Z |
5561794 | 5561794 | 20241119221150_0MOWD | UK001Z | 2024-11-21T14:14:06.889Z | 2024-11-22T14:20:46.649Z |
5561515 | 5561515 | 20241119205123_zBptH | UK001Z | 2024-11-21T14:13:23.591Z | 2024-11-22T14:20:39.451Z |
5561508 | 5561508 | 20241119205046_pkfsv | UK001Z | 2024-11-21T14:13:22.755Z | 2024-11-22T14:20:39.073Z |
5561395 | 5561395 | 20241119202412_a7HnE | UK001Z | 2024-11-21T14:13:12.975Z | 2024-11-22T14:20:34.466Z |
5561333 | 5561333 | 20241119195831_mzQ2r | UK001Z | 2024-11-21T14:13:06.728Z | 2024-11-22T14:20:32.368Z |
5561235 | 5561235 | 20241119191505_pRdrh | UK001Z | 2024-11-21T14:12:43.756Z | 2024-11-22T14:20:27.218Z |
5561223 | 5561223 | 20241119190822_B6L3e | UK001Z | 2024-11-21T14:12:41.403Z | 2024-11-22T14:20:26.893Z |
5561160 | 5561160 | 20241119184525_tI2zK | UK001Z | 2024-11-21T14:12:31.896Z | 2024-11-22T14:20:23.804Z |
5558539 | 5558539 | 20241120062705_PX2o4 | UK001Z | 2024-11-21T14:03:33.631Z | 2024-11-22T14:19:21.249Z |
5558428 | 5558428 | 20241120060344_X64I7 | UK001Z | 2024-11-21T14:03:14.601Z | 2024-11-22T14:19:21.227Z |
5558064 | 5558064 | 20241120053426_zGDiR | UK001Z | 2024-11-21T14:02:26.215Z | 2024-11-22T14:19:21.172Z |
5557794 | 5557794 | 20241120051207_YjHDn | UK001Z | 2024-11-21T14:01:46.550Z | 2024-11-22T14:19:21.129Z |
5557649 | 5557649 | 20241120050344_jlK41 | UK001Z | 2024-11-21T14:01:26.020Z | 2024-11-22T14:19:21.105Z |
5557482 | 5557482 | 20241120045025_1uRA1 | UK001Z | 2024-11-21T14:00:59.537Z | 2024-11-22T14:19:21.078Z |
5552597 | 5552597 | 20241117190908_k2bam | UK001Z | 2024-11-19T14:08:44.186Z | 2024-11-22T14:22:42.667Z |
5543648 | 5543648 | 20241115024254_rW6gI | UK001Z | 2024-11-16T14:06:58.263Z | 2024-11-22T14:24:00.574Z |
5543641 | 5543641 | 20241115024147_dcgI8 | UK001Z | 2024-11-16T14:06:57.947Z | 2024-11-22T14:24:00.553Z |
5543551 | 5543551 | 20241115020124_PBJHy | UK001Z | 2024-11-16T14:06:40.513Z | 2024-11-22T14:23:59.992Z |
5543358 | 5543358 | 20241115003749_VDPMs | UK001Z | 2024-11-16T14:06:08.948Z | 2024-11-22T14:23:58.389Z |
5543334 | 5543334 | 20241115001812_9T6B2 | UK001Z | 2024-11-16T14:06:07.272Z | 2024-11-22T14:23:58.308Z |
5543282 | 5543282 | 20241114234951_Rx6zR | UK001Z | 2024-11-16T14:06:00.250Z | 2024-11-22T14:23:57.911Z |
5543266 | 5543266 | 20241114233508_gu9X1 | UK001Z | 2024-11-16T14:05:56.617Z | 2024-11-22T14:23:57.825Z |
5543117 | 5543117 | 20241114210121_IYEN3 | UK001Z | 2024-11-16T14:05:33.192Z | 2024-11-22T14:23:56.974Z |
5543103 | 5543103 | 20241114203346_WQZQO | UK001Z | 2024-11-16T14:05:31.713Z | 2024-11-22T14:23:56.883Z |
5543089 | 5543089 | 20241114200356_zTzyC | UK001Z | 2024-11-16T14:05:30.459Z | 2024-11-22T14:23:56.830Z |
5543069 | 5543069 | 20241114194418_eLFlK | UK001Z | 2024-11-16T14:05:29.064Z | 2024-11-22T14:23:56.742Z |
5543007 | 5543007 | 20241114175945_p2U3D | UK001Z | 2024-11-16T14:05:15.922Z | 2024-11-22T14:23:56.080Z |
5541190 | 5541190 | 20241113192257_1cxL2 | UK001Z | 2024-11-15T14:06:52.346Z | 2024-11-22T14:24:16.453Z |
5536477 | 5536477 | 20241112181134_vf2eH | UK001Z | 2024-11-14T14:10:02.632Z | 2024-11-21T14:26:01.279Z |
5536399 | 5536399 | 20241112175513_QDsaD | UK001Z | 2024-11-14T14:09:50.419Z | 2024-11-21T14:26:00.756Z |
5536394 | 5536394 | 20241112175323_kbKfV | UK001Z | 2024-11-14T14:09:50.010Z | 2024-11-21T14:26:00.743Z |
5532700 | 5532700 | 20241112055354_42gIk | UK001Z | 2024-11-13T14:17:10.755Z | 2024-11-20T14:26:25.716Z |
5532571 | 5532571 | 20241112054003_CYDB2 | UK001Z | 2024-11-13T14:17:01.191Z | 2024-11-20T14:26:24.886Z |
5532483 | 5532483 | 20241112052906_9PnEE | UK001Z | 2024-11-13T14:16:52.457Z | 2024-11-20T14:26:23.918Z |
5532414 | 5532414 | 20241112051905_73Gir | UK001Z | 2024-11-13T14:16:43.359Z | 2024-11-20T14:26:22.752Z |
5532333 | 5532333 | 20241112050905_2DNAF | UK001Z | 2024-11-13T14:16:37.771Z | 2024-11-20T14:26:22.105Z |
5532168 | 5532168 | 20241112044706_a7zrw | UK001Z | 2024-11-13T14:16:24.226Z | 2024-11-20T14:26:20.546Z |
5532139 | 5532139 | 20241112044031_RkQTF | UK001Z | 2024-11-13T14:16:21.530Z | 2024-11-20T14:26:20.179Z |
5531940 | 5531940 | 20241112042132_TEyhF | UK001Z | 2024-11-13T14:16:03.174Z | 2024-11-20T14:26:16.386Z |
5531895 | 5531895 | 20241112041724_cVsNG | UK001Z | 2024-11-13T14:16:01.149Z | 2024-11-20T14:26:15.753Z |
5531653 | 5531653 | 20241112035730_bPtix | UK001Z | 2024-11-13T14:15:48.836Z | 2024-11-20T14:26:13.038Z |
5531620 | 5531620 | 20241112035341_s7QvV | UK001Z | 2024-11-13T14:15:46.809Z | 2024-11-20T14:26:12.784Z |
5531541 | 5531541 | 20241112034808_rwUyy | UK001Z | 2024-11-13T14:15:44.226Z | 2024-11-20T14:26:12.138Z |
5531454 | 5531454 | 20241112034035_XVcr2 | UK001Z | 2024-11-13T14:15:40.505Z | 2024-11-20T14:26:11.374Z |
5531326 | 5531326 | 20241112033227_bLjY4 | UK001Z | 2024-11-13T14:15:34.531Z | 2024-11-20T14:26:10.368Z |
5530792 | 5530792 | 20241112024803_EztuA | UK001Z | 2024-11-13T14:14:39.179Z | 2024-11-20T14:26:03.654Z |
5530552 | 5530552 | 20241112022802_FuL6p | UK001Z | 2024-11-13T14:14:22.041Z | 2024-11-20T14:26:01.607Z |
5529905 | 5529905 | 20241112011946_3iYkA | UK001Z | 2024-11-13T14:13:21.647Z | 2024-11-20T14:25:50.891Z |
5529460 | 5529460 | 20241112002229_B12OI | UK001Z | 2024-11-13T14:12:52.604Z | 2024-11-20T14:25:45.233Z |
5529236 | 5529236 | 20241111235359_tFAp4 | UK001Z | 2024-11-13T14:12:15.403Z | 2024-11-20T14:25:42.167Z |
5528790 | 5528790 | 20241111223955_eiMuP | UK001Z | 2024-11-13T14:11:26.827Z | 2024-11-20T14:25:35.852Z |
5528691 | 5528691 | 20241111221949_Zqnei | UK001Z | 2024-11-13T14:11:17.567Z | 2024-11-20T14:25:33.947Z |
5528461 | 5528461 | 20241111210042_hTxoQ | UK001Z | 2024-11-13T14:10:45.493Z | 2024-11-20T14:25:30.893Z |
5528190 | 5528190 | 20241111195116_hgeZP | UK001Z | 2024-11-13T14:10:14.119Z | 2024-11-20T14:25:26.481Z |
5528083 | 5528083 | 20241111192903_FNn9i | UK001Z | 2024-11-13T14:09:48.463Z | 2024-11-20T14:25:24.837Z |
5527686 | 5527686 | 20241111181438_cjI2H | UK001Z | 2024-11-13T14:08:55.235Z | 2024-11-20T14:25:17.982Z |
5527609 | 5527609 | 20241111174851_Ot6zQ | UK001Z | 2024-11-13T14:08:45.135Z | 2024-11-20T14:25:14.676Z |
5527582 | 5527582 | 20241111174131_whKT2 | UK001Z | 2024-11-13T14:08:42.605Z | 2024-11-20T14:25:14.274Z |
5525632 | 5525632 | 20241112055817_qiwej | UK001Z | 2024-11-13T14:00:10.420Z | 2024-11-21T14:25:24.410Z |
5522817 | 5522817 | 20241110215832_fhMCu | UK001Z | 2024-11-12T14:14:20.920Z | 2024-11-19T14:22:06.989Z |
5522765 | 5522765 | 20241110212231_RkFv3 | UK001Z | 2024-11-12T14:14:12.079Z | 2024-11-19T14:22:06.100Z |
5522697 | 5522697 | 20241110210500_6AfDd | UK001Z | 2024-11-12T14:13:58.424Z | 2024-11-19T14:22:05.340Z |
5522608 | 5522608 | 20241110204404_zPSL8 | UK001Z | 2024-11-12T14:13:45.663Z | 2024-11-19T14:22:04.598Z |
5522477 | 5522477 | 20241110200908_USWpF | UK001Z | 2024-11-12T14:13:20.651Z | 2024-11-19T14:22:02.644Z |
5454268 | 5454268 | 20241031040417_rKXbw | UK001Z | 2024-11-02T12:22:57.452Z | 2024-11-08T14:23:21.968Z |
5454198 | 5454198 | 20241031035545_lYDGS | UK001Z | 2024-11-02T12:22:54.431Z | 2024-11-08T14:23:21.340Z |
5454084 | 5454084 | 20241031034058_92XpZ | UK001Z | 2024-11-02T12:22:50.489Z | 2024-11-08T14:23:20.310Z |
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);