participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,276 rows where station_code = "UK000J" 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 |
---|---|---|---|---|---|
5134002 | 5134002 | 20240916042901_uCbWJ | UK000J | 2024-09-19T12:17:15.652Z | 2024-09-19T12:17:15.652Z |
5132839 | 5132839 | 20240916022134_cUpiw | UK000J | 2024-09-19T12:16:34.403Z | 2024-09-19T12:16:34.403Z |
5132770 | 5132770 | 20240916021140_2xk3m | UK000J | 2024-09-19T12:16:32.331Z | 2024-09-19T12:16:32.331Z |
5132721 | 5132721 | 20240916020239_yLCLT | UK000J | 2024-09-19T12:16:29.952Z | 2024-09-19T12:16:29.952Z |
5132654 | 5132654 | 20240916015040_7runA | UK000J | 2024-09-19T12:16:25.516Z | 2024-09-19T12:16:25.516Z |
5132456 | 5132456 | 20240916011425_XsHwa | UK000J | 2024-09-19T12:16:13.754Z | 2024-09-19T12:16:13.754Z |
5132353 | 5132353 | 20240916005037_rslEv | UK000J | 2024-09-19T12:16:09.290Z | 2024-09-19T12:16:09.290Z |
5132092 | 5132092 | 20240915231621_OvCW9 | UK000J | 2024-09-19T12:15:49.968Z | 2024-09-19T12:15:49.968Z |
5131562 | 5131562 | 20240915201817_UC1xt | UK000J | 2024-09-19T12:15:09.376Z | 2024-09-19T12:15:09.376Z |
5129819 | 5129819 | 20240917043803_3TXdS | UK000J | 2024-09-19T12:12:07.586Z | 2024-09-19T12:12:07.586Z |
5129708 | 5129708 | 20240917042446_4c0yQ | UK000J | 2024-09-19T12:12:02.430Z | 2024-09-19T12:12:02.430Z |
5129692 | 5129692 | 20240917042320_qWoHt | UK000J | 2024-09-19T12:12:01.420Z | 2024-09-19T12:12:01.420Z |
5129344 | 5129344 | 20240917035057_b0sYZ | UK000J | 2024-09-19T12:11:30.379Z | 2024-09-19T12:11:30.379Z |
5128957 | 5128957 | 20240917030254_NjTz1 | UK000J | 2024-09-19T12:11:09.512Z | 2024-09-19T12:11:09.512Z |
5113678 | 5113678 | 20240915010509_grEkf | UK000J | 2024-09-18T12:04:39.659Z | 2024-09-19T12:18:51.253Z |
5113587 | 5113587 | 20240915010038_yynXa | UK000J | 2024-09-18T12:04:34.530Z | 2024-09-19T12:18:50.527Z |
5112582 | 5112582 | 20240914233034_ABu4f | UK000J | 2024-09-18T12:03:15.498Z | 2024-09-19T12:18:41.527Z |
5110446 | 5110446 | 20240911010346_TXvjR | UK000J | 2024-09-17T12:17:57.870Z | 2024-09-19T12:21:39.378Z |
5107681 | 5107681 | 20240913040801_Pcdtc | UK000J | 2024-09-17T12:13:21.006Z | 2024-09-19T12:20:47.448Z |
5107535 | 5107535 | 20240913035854_mqhvd | UK000J | 2024-09-17T12:13:16.757Z | 2024-09-19T12:20:47.214Z |
5106981 | 5106981 | 20240913034133_xmreC | UK000J | 2024-09-17T12:13:06.308Z | 2024-09-19T12:20:46.740Z |
5106683 | 5106683 | 20240913033222_3oesm | UK000J | 2024-09-17T12:12:59.411Z | 2024-09-19T12:20:46.283Z |
5106631 | 5106631 | 20240913033129_1gPB2 | UK000J | 2024-09-17T12:12:58.663Z | 2024-09-19T12:20:46.218Z |
5106347 | 5106347 | 20240913032043_2RkvF | UK000J | 2024-09-17T12:12:50.864Z | 2024-09-19T12:20:45.980Z |
5105472 | 5105472 | 20240913024739_u4u5T | UK000J | 2024-09-17T12:12:18.598Z | 2024-09-19T12:20:44.595Z |
5105041 | 5105041 | 20240913022812_VdYf6 | UK000J | 2024-09-17T12:11:50.822Z | 2024-09-19T12:20:43.435Z |
5104896 | 5104896 | 20240913022314_jSZQK | UK000J | 2024-09-17T12:11:46.145Z | 2024-09-19T12:20:43.085Z |
5104856 | 5104856 | 20240913022207_0Ph2X | UK000J | 2024-09-17T12:11:45.645Z | 2024-09-19T12:20:43.071Z |
5104750 | 5104750 | 20240913022027_C2wow | UK000J | 2024-09-17T12:11:43.988Z | 2024-09-19T12:20:42.843Z |
5104037 | 5104037 | 20240913015007_8d3gI | UK000J | 2024-09-17T12:11:23.519Z | 2024-09-19T12:20:40.930Z |
5097680 | 5097680 | 20240913005803_2vgkq | UK000J | 2024-09-16T12:17:14.086Z | 2024-09-19T12:20:38.905Z |
5097448 | 5097448 | 20240913004754_J6VyA | UK000J | 2024-09-16T12:17:12.870Z | 2024-09-19T12:20:38.646Z |
5094592 | 5094592 | 20240912041227_HdOPp | UK000J | 2024-09-16T12:14:52.461Z | 2024-09-19T12:21:16.321Z |
5093362 | 5093362 | 20240912031937_Gkdyr | UK000J | 2024-09-16T12:14:16.120Z | 2024-09-19T12:21:15.297Z |
5091815 | 5091815 | 20240912022400_HsYyS | UK000J | 2024-09-16T12:13:25.412Z | 2024-09-19T12:21:13.407Z |
5091595 | 5091595 | 20240912021508_y6TK3 | UK000J | 2024-09-16T12:13:13.004Z | 2024-09-19T12:21:13.247Z |
5091530 | 5091530 | 20240912021305_deW3K | UK000J | 2024-09-16T12:13:09.940Z | 2024-09-19T12:21:13.186Z |
5091382 | 5091382 | 20240912020725_FQmBg | UK000J | 2024-09-16T12:13:03.688Z | 2024-09-19T12:21:12.991Z |
5091325 | 5091325 | 20240912020524_IKQzM | UK000J | 2024-09-16T12:13:00.979Z | 2024-09-19T12:21:12.825Z |
5090795 | 5090795 | 20240912014638_odoCQ | UK000J | 2024-09-16T12:12:36.956Z | 2024-09-19T12:21:12.115Z |
5090709 | 5090709 | 20240912014048_GFvOu | UK000J | 2024-09-16T12:12:31.144Z | 2024-09-19T12:21:11.614Z |
5090583 | 5090583 | 20240912013320_6mPvx | UK000J | 2024-09-16T12:12:26.064Z | 2024-09-19T12:21:11.454Z |
5089307 | 5089307 | 20240912003526_qubeJ | UK000J | 2024-09-16T12:11:20.246Z | 2024-09-19T12:21:09.885Z |
5089058 | 5089058 | 20240912002541_eQh3U | UK000J | 2024-09-16T12:11:14.830Z | 2024-09-19T12:21:09.740Z |
5087987 | 5087987 | 20240912235300_5F02O | UK000J | 2024-09-16T12:07:40.232Z | 2024-09-19T12:20:36.036Z |
5084499 | 5084499 | 20240912194430_NrSca | UK000J | 2024-09-16T12:02:11.211Z | 2024-09-19T12:20:25.922Z |
5078438 | 5078438 | 20240911015724_3nL3x | UK000J | 2024-09-15T12:15:38.828Z | 2024-09-19T12:21:40.393Z |
5078176 | 5078176 | 20240911014225_sNvqF | UK000J | 2024-09-15T12:15:22.596Z | 2024-09-19T12:21:40.042Z |
5077558 | 5077558 | 20240911010340_VShdo | UK000J | 2024-09-15T12:14:52.814Z | 2024-09-19T12:21:39.377Z |
5076808 | 5076808 | 20240911000952_cJB9n | UK000J | 2024-09-15T12:14:05.019Z | 2024-09-19T12:21:37.611Z |
5076786 | 5076786 | 20240911000912_RghS3 | UK000J | 2024-09-15T12:14:03.785Z | 2024-09-19T12:21:37.602Z |
5075458 | 5075458 | 20240911234918_6rQNt | UK000J | 2024-09-15T12:09:49.665Z | 2024-09-19T12:21:09.224Z |
5074538 | 5074538 | 20240911224523_TV37J | UK000J | 2024-09-15T12:08:36.634Z | 2024-09-19T12:21:07.381Z |
5073883 | 5073883 | 20240911215238_YDfOK | UK000J | 2024-09-15T12:07:42.867Z | 2024-09-19T12:21:06.346Z |
5072733 | 5072733 | 20240911203844_IrIeR | UK000J | 2024-09-15T12:06:04.866Z | 2024-09-19T12:21:04.678Z |
5070200 | 5070200 | 20240910224233_3brZu | UK000J | 2024-09-14T12:20:16.722Z | 2024-09-19T12:21:35.907Z |
5060778 | 5060778 | 20240910210544_GOMS6 | UK000J | 2024-09-14T12:09:32.576Z | 2024-09-19T12:21:33.594Z |
5060582 | 5060582 | 20240910204043_LX9k3 | UK000J | 2024-09-14T12:09:10.643Z | 2024-09-19T12:21:33.105Z |
5060329 | 5060329 | 20240910202018_oXD2u | UK000J | 2024-09-14T12:08:39.731Z | 2024-09-19T12:21:32.188Z |
5008518 | 5008518 | 20240903235120_cuTVw | UK000J | 2024-09-09T12:06:51.558Z | 2024-09-12T12:19:18.009Z |
5008141 | 5008141 | 20240903230708_HQQNt | UK000J | 2024-09-09T12:06:28.507Z | 2024-09-12T12:19:16.309Z |
5008002 | 5008002 | 20240903225414_1cKbM | UK000J | 2024-09-09T12:06:19.263Z | 2024-09-12T12:19:15.856Z |
5007793 | 5007793 | 20240903222504_GvKLq | UK000J | 2024-09-09T12:06:08.539Z | 2024-09-12T12:19:14.997Z |
4983093 | 4983093 | 20240812004117_66N37 | UK000J | 2024-09-06T12:15:15.286Z | 2024-09-06T12:15:15.286Z |
4981628 | 4981628 | 20240812002442_AdKGl | UK000J | 2024-09-06T12:14:34.643Z | 2024-09-06T12:14:34.643Z |
4981558 | 4981558 | 20240812002349_NSHDB | UK000J | 2024-09-06T12:14:33.508Z | 2024-09-06T12:14:33.508Z |
4980984 | 4980984 | 20240812001808_r2TMX | UK000J | 2024-09-06T12:14:25.311Z | 2024-09-06T12:14:25.311Z |
4980617 | 4980617 | 20240812001425_S7TA2 | UK000J | 2024-09-06T12:14:08.791Z | 2024-09-06T12:14:08.791Z |
4980555 | 4980555 | 20240812001354_Bl6k3 | UK000J | 2024-09-06T12:14:05.313Z | 2024-09-06T12:14:05.313Z |
4979753 | 4979753 | 20240812000430_Hgrvl | UK000J | 2024-09-06T12:13:27.010Z | 2024-09-06T12:13:27.010Z |
4979471 | 4979471 | 20240812000217_9S523 | UK000J | 2024-09-06T12:13:16.989Z | 2024-09-06T12:13:16.989Z |
4979231 | 4979231 | 20240812000030_F6Ar5 | UK000J | 2024-09-06T12:13:06.117Z | 2024-09-06T12:13:06.117Z |
4978895 | 4978895 | 20240811235626_eMuyG | UK000J | 2024-09-06T12:12:44.856Z | 2024-09-06T12:12:44.856Z |
4978008 | 4978008 | 20240811234710_YwKBZ | UK000J | 2024-09-06T12:12:27.834Z | 2024-09-06T12:12:27.834Z |
4977766 | 4977766 | 20240811234440_P9oNY | UK000J | 2024-09-06T12:12:23.021Z | 2024-09-06T12:12:23.021Z |
4977719 | 4977719 | 20240811234426_UYYsP | UK000J | 2024-09-06T12:12:22.585Z | 2024-09-06T12:12:22.585Z |
4977184 | 4977184 | 20240811233656_8o332 | UK000J | 2024-09-06T12:12:06.540Z | 2024-09-06T12:12:06.540Z |
4975107 | 4975107 | 20240811231452_62Mey | UK000J | 2024-09-05T12:11:39.867Z | 2024-09-06T12:10:37.236Z |
4974727 | 4974727 | 20240811231030_FiguI | UK000J | 2024-09-05T12:11:31.163Z | 2024-09-06T12:10:32.313Z |
4974313 | 4974313 | 20240811230549_hhofh | UK000J | 2024-09-05T12:11:23.150Z | 2024-09-06T12:10:25.502Z |
4973269 | 4973269 | 20240811225526_iIWAG | UK000J | 2024-09-05T12:10:46.443Z | 2024-09-06T12:09:50.811Z |
4972552 | 4972552 | 20240811224748_7ZKj6 | UK000J | 2024-09-05T12:10:28.215Z | 2024-09-06T12:09:18.335Z |
4972170 | 4972170 | 20240811224345_IXjCg | UK000J | 2024-09-05T12:10:18.653Z | 2024-09-06T12:09:05.954Z |
4971662 | 4971662 | 20240811223827_ieSYj | UK000J | 2024-09-05T12:09:53.113Z | 2024-09-06T12:08:56.361Z |
4971405 | 4971405 | 20240811223458_TCzj4 | UK000J | 2024-09-05T12:09:43.685Z | 2024-09-06T12:08:52.744Z |
4971131 | 4971131 | 20240811223219_oC2eZ | UK000J | 2024-09-05T12:09:40.229Z | 2024-09-06T12:08:49.873Z |
4970618 | 4970618 | 20240811222728_ix09N | UK000J | 2024-09-05T12:09:29.691Z | 2024-09-06T12:08:43.049Z |
4969862 | 4969862 | 20240811221812_K1yLB | UK000J | 2024-09-05T12:09:08.566Z | 2024-09-06T12:08:11.797Z |
4969581 | 4969581 | 20240811221328_aLBzh | UK000J | 2024-09-05T12:08:48.774Z | 2024-09-06T12:07:55.246Z |
4967766 | 4967766 | 20240811214924_grVBv | UK000J | 2024-09-05T12:07:47.673Z | 2024-09-06T12:07:08.707Z |
4966770 | 4966770 | 20240811213341_X6r3K | UK000J | 2024-09-04T12:07:34.127Z | 2024-09-06T12:06:47.534Z |
4966754 | 4966754 | 20240811213333_JCIWP | UK000J | 2024-09-04T12:07:34.036Z | 2024-09-06T12:06:47.087Z |
4949356 | 4949356 | 20240811014811_c0IpM | UK000J | 2024-09-02T12:15:43.462Z | 2024-09-06T12:27:32.246Z |
4948213 | 4948213 | 20240811013040_MjPT3 | UK000J | 2024-09-02T12:14:57.707Z | 2024-09-06T12:27:11.676Z |
4947313 | 4947313 | 20240811011626_P2tc4 | UK000J | 2024-09-02T12:14:25.052Z | 2024-09-06T12:26:50.871Z |
4947151 | 4947151 | 20240811011352_3MibO | UK000J | 2024-09-02T12:14:18.845Z | 2024-09-06T12:26:45.925Z |
4946924 | 4946924 | 20240811011045_fUCES | UK000J | 2024-09-02T12:14:12.114Z | 2024-09-06T12:26:40.581Z |
4943082 | 4943082 | 20240811000526_U8F5b | UK000J | 2024-09-02T12:11:42.032Z | 2024-09-06T12:24:38.546Z |
4916014 | 4916014 | 20240809230337_jxdXC | UK000J | 2024-08-30T12:10:27.139Z | 2024-09-02T12:24:08.660Z |
4915937 | 4915937 | 20240809230131_juL0B | UK000J | 2024-08-30T12:10:22.930Z | 2024-09-02T12:24:07.295Z |
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);