participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
8,398 rows where station_code = "UK007B" 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 |
---|---|---|---|---|---|
5129768 | 5129768 | 20240917042607_3EGWz | UK007B | 2024-09-19T12:12:03.110Z | 2024-09-19T12:12:03.110Z |
5129720 | 5129720 | 20240917042446_4c0yQ | UK007B | 2024-09-19T12:12:02.430Z | 2024-09-19T12:12:02.430Z |
5129376 | 5129376 | 20240917035455_GRAvj | UK007B | 2024-09-19T12:11:34.191Z | 2024-09-19T12:11:34.191Z |
5128861 | 5128861 | 20240917024843_8lfcr | UK007B | 2024-09-19T12:11:04.080Z | 2024-09-19T12:11:04.080Z |
5128745 | 5128745 | 20240917023112_gpYjQ | UK007B | 2024-09-19T12:10:59.755Z | 2024-09-19T12:10:59.755Z |
5128719 | 5128719 | 20240917022613_J2bup | UK007B | 2024-09-19T12:10:58.950Z | 2024-09-19T12:10:58.950Z |
5128700 | 5128700 | 20240917022511_pyqVJ | UK007B | 2024-09-19T12:10:57.603Z | 2024-09-19T12:10:57.603Z |
5128434 | 5128434 | 20240917014244_XuzZ7 | UK007B | 2024-09-19T12:10:34.656Z | 2024-09-19T12:10:34.656Z |
5128135 | 5128135 | 20240917004738_p3zvx | UK007B | 2024-09-19T12:10:08.468Z | 2024-09-19T12:10:08.468Z |
5127859 | 5127859 | 20240916235248_llpFg | UK007B | 2024-09-19T12:09:44.085Z | 2024-09-19T12:09:44.085Z |
5127705 | 5127705 | 20240916230311_Q2lOj | UK007B | 2024-09-19T12:09:33.078Z | 2024-09-19T12:09:33.078Z |
5125769 | 5125769 | 20240918034841_65Fh3 | UK007B | 2024-09-19T12:04:03.467Z | 2024-09-19T12:06:42.083Z |
5125180 | 5125180 | 20240918005946_jvyfD | UK007B | 2024-09-19T12:02:27.452Z | 2024-09-19T12:06:41.987Z |
5125093 | 5125093 | 20240918001214_9mGsq | UK007B | 2024-09-19T12:02:16.794Z | 2024-09-19T12:06:41.976Z |
5124749 | 5124749 | 20240917215732_2fFnj | UK007B | 2024-09-19T12:01:32.185Z | 2024-09-19T12:06:41.931Z |
5124321 | 5124321 | 20240917193253_dDDn1 | UK007B | 2024-09-19T12:00:34.149Z | 2024-09-19T12:06:41.877Z |
5122071 | 5122071 | 20240914043057_QqBh3 | UK007B | 2024-09-18T12:11:05.320Z | 2024-09-19T12:20:02.721Z |
5121977 | 5121977 | 20240914042323_4l1UM | UK007B | 2024-09-18T12:11:03.681Z | 2024-09-19T12:20:02.557Z |
5121694 | 5121694 | 20240914041211_gzgsf | UK007B | 2024-09-18T12:10:59.392Z | 2024-09-19T12:20:02.218Z |
5121681 | 5121681 | 20240914041207_LDHts | UK007B | 2024-09-18T12:10:59.349Z | 2024-09-19T12:20:02.212Z |
5121388 | 5121388 | 20240914035911_Tv6J3 | UK007B | 2024-09-18T12:10:54.723Z | 2024-09-19T12:20:01.708Z |
5120964 | 5120964 | 20240914034301_pu1Yj | UK007B | 2024-09-18T12:10:48.930Z | 2024-09-19T12:20:01.080Z |
5120756 | 5120756 | 20240914033443_UEKyt | UK007B | 2024-09-18T12:10:46.590Z | 2024-09-19T12:20:00.852Z |
5120289 | 5120289 | 20240914031222_xXJ8R | UK007B | 2024-09-18T12:10:36.715Z | 2024-09-19T12:19:59.849Z |
5119834 | 5119834 | 20240914025103_D1BGx | UK007B | 2024-09-18T12:10:28.191Z | 2024-09-19T12:19:59.015Z |
5119733 | 5119733 | 20240914024608_v3ZnX | UK007B | 2024-09-18T12:10:24.624Z | 2024-09-19T12:19:58.797Z |
5119468 | 5119468 | 20240914023600_2u6WP | UK007B | 2024-09-18T12:10:21.526Z | 2024-09-19T12:19:58.286Z |
5117464 | 5117464 | 20240915043603_zgEHc | UK007B | 2024-09-18T12:07:42.150Z | 2024-09-19T12:19:15.157Z |
5117442 | 5117442 | 20240915043339_hFYBo | UK007B | 2024-09-18T12:07:41.651Z | 2024-09-19T12:19:15.101Z |
5117261 | 5117261 | 20240915041543_32kqX | UK007B | 2024-09-18T12:07:36.388Z | 2024-09-19T12:19:14.055Z |
5117233 | 5117233 | 20240915041438_lwds4 | UK007B | 2024-09-18T12:07:35.964Z | 2024-09-19T12:19:13.959Z |
5116933 | 5116933 | 20240915035106_fqa3m | UK007B | 2024-09-18T12:07:26.453Z | 2024-09-19T12:19:12.803Z |
5116844 | 5116844 | 20240915034432_PyZhQ | UK007B | 2024-09-18T12:07:22.646Z | 2024-09-19T12:19:12.458Z |
5114623 | 5114623 | 20240915015225_PAl02 | UK007B | 2024-09-18T12:05:25.859Z | 2024-09-19T12:18:59.081Z |
5114530 | 5114530 | 20240915014649_fdMaf | UK007B | 2024-09-18T12:05:20.940Z | 2024-09-19T12:18:58.750Z |
5114261 | 5114261 | 20240915013416_YFd5H | UK007B | 2024-09-18T12:05:09.097Z | 2024-09-19T12:18:57.332Z |
5113811 | 5113811 | 20240915011405_FkSd0 | UK007B | 2024-09-18T12:04:51.278Z | 2024-09-19T12:18:52.849Z |
5113203 | 5113203 | 20240915003144_fsUq3 | UK007B | 2024-09-18T12:04:02.988Z | 2024-09-19T12:18:47.997Z |
5112982 | 5112982 | 20240915001109_JKPUo | UK007B | 2024-09-18T12:03:49.893Z | 2024-09-19T12:18:46.235Z |
5112957 | 5112957 | 20240915001108_I3lqt | UK007B | 2024-09-18T12:03:49.751Z | 2024-09-19T12:18:46.054Z |
5112564 | 5112564 | 20240914232945_zEWSh | UK007B | 2024-09-18T12:03:14.838Z | 2024-09-19T12:18:41.478Z |
5111423 | 5111423 | 20240914203608_z6s2s | UK007B | 2024-09-18T12:01:55.865Z | 2024-09-19T12:18:30.113Z |
5108168 | 5108168 | 20240913042923_2WrGD | UK007B | 2024-09-17T12:13:31.955Z | 2024-09-19T12:20:47.895Z |
5108098 | 5108098 | 20240913042319_y99Cu | UK007B | 2024-09-17T12:13:30.489Z | 2024-09-19T12:20:47.844Z |
5107917 | 5107917 | 20240913041500_M9G1b | UK007B | 2024-09-17T12:13:25.945Z | 2024-09-19T12:20:47.637Z |
5107006 | 5107006 | 20240913034207_pu92q | UK007B | 2024-09-17T12:13:07.004Z | 2024-09-19T12:20:46.771Z |
5106898 | 5106898 | 20240913033804_6bAi1 | UK007B | 2024-09-17T12:13:03.762Z | 2024-09-19T12:20:46.510Z |
5106599 | 5106599 | 20240913032918_4RKKo | UK007B | 2024-09-17T12:12:57.692Z | 2024-09-19T12:20:46.192Z |
5106550 | 5106550 | 20240913032846_X30ef | UK007B | 2024-09-17T12:12:57.187Z | 2024-09-19T12:20:46.174Z |
5106378 | 5106378 | 20240913032242_sbkqL | UK007B | 2024-09-17T12:12:51.635Z | 2024-09-19T12:20:46.013Z |
5106217 | 5106217 | 20240913031545_H3ROi | UK007B | 2024-09-17T12:12:45.166Z | 2024-09-19T12:20:45.669Z |
5106043 | 5106043 | 20240913030733_lQoMo | UK007B | 2024-09-17T12:12:39.062Z | 2024-09-19T12:20:45.361Z |
5105994 | 5105994 | 20240913030537_DRrA0 | UK007B | 2024-09-17T12:12:35.358Z | 2024-09-19T12:20:45.114Z |
5105950 | 5105950 | 20240913030350_8635I | UK007B | 2024-09-17T12:12:34.439Z | 2024-09-19T12:20:45.079Z |
5105759 | 5105759 | 20240913025646_YLUy6 | UK007B | 2024-09-17T12:12:28.512Z | 2024-09-19T12:20:44.868Z |
5105673 | 5105673 | 20240913025456_vtBVi | UK007B | 2024-09-17T12:12:25.624Z | 2024-09-19T12:20:44.791Z |
5105410 | 5105410 | 20240913024434_fjOjP | UK007B | 2024-09-17T12:12:13.288Z | 2024-09-19T12:20:44.397Z |
5104923 | 5104923 | 20240913022403_dPyMy | UK007B | 2024-09-17T12:11:46.678Z | 2024-09-19T12:20:43.117Z |
5104657 | 5104657 | 20240913021814_1HhV8 | UK007B | 2024-09-17T12:11:41.919Z | 2024-09-19T12:20:42.659Z |
5104622 | 5104622 | 20240913021743_J37Pr | UK007B | 2024-09-17T12:11:41.383Z | 2024-09-19T12:20:42.648Z |
5103870 | 5103870 | 20240913014238_YhbsR | UK007B | 2024-09-17T12:11:14.493Z | 2024-09-19T12:20:40.639Z |
5103849 | 5103849 | 20240913014220_6dD5N | UK007B | 2024-09-17T12:11:13.377Z | 2024-09-19T12:20:40.626Z |
5103692 | 5103692 | 20240913013553_ejHYY | UK007B | 2024-09-17T12:11:07.997Z | 2024-09-19T12:20:40.422Z |
5103666 | 5103666 | 20240913013551_Kikf3 | UK007B | 2024-09-17T12:11:07.705Z | 2024-09-19T12:20:40.420Z |
5103146 | 5103146 | 20240914020250_Sndae | UK007B | 2024-09-17T12:07:53.955Z | 2024-09-19T12:19:56.688Z |
5103043 | 5103043 | 20240914015933_3CQ1x | UK007B | 2024-09-17T12:07:49.006Z | 2024-09-19T12:19:56.471Z |
5103033 | 5103033 | 20240914015856_LMlsd | UK007B | 2024-09-17T12:07:48.567Z | 2024-09-19T12:19:56.460Z |
5102876 | 5102876 | 20240914015121_iTk33 | UK007B | 2024-09-17T12:07:41.705Z | 2024-09-19T12:19:56.019Z |
5102693 | 5102693 | 20240914013752_rN9a2 | UK007B | 2024-09-17T12:07:31.646Z | 2024-09-19T12:19:55.406Z |
5102529 | 5102529 | 20240914013033_3gEnZ | UK007B | 2024-09-17T12:07:19.202Z | 2024-09-19T12:19:54.725Z |
5102246 | 5102246 | 20240914011310_txDH5 | UK007B | 2024-09-17T12:06:55.815Z | 2024-09-19T12:19:53.092Z |
5102208 | 5102208 | 20240914011210_ADSRA | UK007B | 2024-09-17T12:06:54.706Z | 2024-09-19T12:19:52.884Z |
5101693 | 5101693 | 20240914004336_GtBY7 | UK007B | 2024-09-17T12:06:09.317Z | 2024-09-19T12:19:51.297Z |
5101656 | 5101656 | 20240914004134_epWXK | UK007B | 2024-09-17T12:06:07.005Z | 2024-09-19T12:19:51.178Z |
5101615 | 5101615 | 20240914003907_SgXcF | UK007B | 2024-09-17T12:06:05.143Z | 2024-09-19T12:19:51.103Z |
5101315 | 5101315 | 20240914001913_y13qc | UK007B | 2024-09-17T12:05:34.809Z | 2024-09-19T12:19:50.251Z |
5100824 | 5100824 | 20240913234635_px7iK | UK007B | 2024-09-17T12:04:58.035Z | 2024-09-19T12:19:48.798Z |
5100689 | 5100689 | 20240913234141_y3H1k | UK007B | 2024-09-17T12:04:49.115Z | 2024-09-19T12:19:48.530Z |
5100461 | 5100461 | 20240913232718_Rbr4s | UK007B | 2024-09-17T12:04:34.781Z | 2024-09-19T12:19:48.005Z |
5100408 | 5100408 | 20240913232608_kE3Yo | UK007B | 2024-09-17T12:04:33.087Z | 2024-09-19T12:19:47.957Z |
5099608 | 5099608 | 20240913213959_saTlk | UK007B | 2024-09-17T12:03:12.987Z | 2024-09-19T12:19:45.453Z |
5099165 | 5099165 | 20240913203235_ylaZt | UK007B | 2024-09-17T12:02:24.404Z | 2024-09-19T12:19:43.666Z |
5098295 | 5098295 | 20240913012412_Zi2Wf | UK007B | 2024-09-16T12:17:22.217Z | 2024-09-19T12:20:39.998Z |
5097866 | 5097866 | 20240913010724_qMWhj | UK007B | 2024-09-16T12:17:16.296Z | 2024-09-19T12:20:39.151Z |
5097694 | 5097694 | 20240913005803_2vgkq | UK007B | 2024-09-16T12:17:14.086Z | 2024-09-19T12:20:38.905Z |
5097656 | 5097656 | 20240913005751_S5ImR | UK007B | 2024-09-16T12:17:13.916Z | 2024-09-19T12:20:38.877Z |
5097611 | 5097611 | 20240913005648_SR4Vi | UK007B | 2024-09-16T12:17:13.629Z | 2024-09-19T12:20:38.836Z |
5097461 | 5097461 | 20240913004754_J6VyA | UK007B | 2024-09-16T12:17:12.870Z | 2024-09-19T12:20:38.647Z |
5097430 | 5097430 | 20240913004659_0vszY | UK007B | 2024-09-16T12:17:12.615Z | 2024-09-19T12:20:38.620Z |
5097245 | 5097245 | 20240913003830_3xJ2D | UK007B | 2024-09-16T12:17:09.370Z | 2024-09-19T12:20:38.022Z |
5094843 | 5094843 | 20240912042556_x1sh4 | UK007B | 2024-09-16T12:14:59.344Z | 2024-09-19T12:21:16.447Z |
5094615 | 5094615 | 20240912041229_dzmcA | UK007B | 2024-09-16T12:14:52.550Z | 2024-09-19T12:21:16.331Z |
5094440 | 5094440 | 20240912040131_YK5u3 | UK007B | 2024-09-16T12:14:45.110Z | 2024-09-19T12:21:16.122Z |
5094327 | 5094327 | 20240912035726_MvYSU | UK007B | 2024-09-16T12:14:41.442Z | 2024-09-19T12:21:16.072Z |
5094301 | 5094301 | 20240912035629_1DRY6 | UK007B | 2024-09-16T12:14:40.987Z | 2024-09-19T12:21:16.065Z |
5094291 | 5094291 | 20240912035559_0hO85 | UK007B | 2024-09-16T12:14:40.816Z | 2024-09-19T12:21:16.061Z |
5094240 | 5094240 | 20240912035411_JoaMv | UK007B | 2024-09-16T12:14:39.795Z | 2024-09-19T12:21:16.030Z |
5093378 | 5093378 | 20240912031937_Gkdyr | UK007B | 2024-09-16T12:14:16.120Z | 2024-09-19T12:21:15.298Z |
5092831 | 5092831 | 20240912025929_NdeEe | UK007B | 2024-09-16T12:14:05.056Z | 2024-09-19T12:21:14.600Z |
5092762 | 5092762 | 20240912025622_elS9Z | UK007B | 2024-09-16T12:14:03.522Z | 2024-09-19T12:21:14.528Z |
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);