participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
639 rows where station_code = "UK009B" 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 |
---|---|---|---|---|---|
5113625 | 5113625 | 20240915010110_nKTUr | UK009B | 2024-09-18T12:04:35.641Z | 2024-09-19T12:18:50.669Z |
5106452 | 5106452 | 20240913032450_6453s | UK009B | 2024-09-17T12:12:54.325Z | 2024-09-19T12:20:46.085Z |
5106318 | 5106318 | 20240913031823_RqNvZ | UK009B | 2024-09-17T12:12:49.714Z | 2024-09-19T12:20:45.821Z |
5106024 | 5106024 | 20240913030700_wdh3W | UK009B | 2024-09-17T12:12:38.509Z | 2024-09-19T12:20:45.352Z |
5105233 | 5105233 | 20240913023836_Jw8DT | UK009B | 2024-09-17T12:12:03.533Z | 2024-09-19T12:20:44.155Z |
5104895 | 5104895 | 20240913022313_6T24D | UK009B | 2024-09-17T12:11:45.995Z | 2024-09-19T12:20:43.084Z |
5103934 | 5103934 | 20240913014503_RWEvO | UK009B | 2024-09-17T12:11:19.061Z | 2024-09-19T12:20:40.679Z |
5103508 | 5103508 | 20240913013150_914PB | UK009B | 2024-09-17T12:11:00.770Z | 2024-09-19T12:20:40.231Z |
5087723 | 5087723 | 20240912234114_LEKWl | UK009B | 2024-09-16T12:07:19.542Z | 2024-09-19T12:20:35.619Z |
5087664 | 5087664 | 20240912233912_ts3pc | UK009B | 2024-09-16T12:07:12.317Z | 2024-09-19T12:20:35.524Z |
5087602 | 5087602 | 20240912233304_JuYh0 | UK009B | 2024-09-16T12:07:05.774Z | 2024-09-19T12:20:35.485Z |
5087069 | 5087069 | 20240912230658_ySd9Y | UK009B | 2024-09-16T12:06:31.318Z | 2024-09-19T12:20:33.952Z |
5085634 | 5085634 | 20240912213724_fdsSp | UK009B | 2024-09-16T12:04:32.335Z | 2024-09-19T12:20:29.310Z |
5085137 | 5085137 | 20240912205137_2KNZc | UK009B | 2024-09-16T12:03:36.234Z | 2024-09-19T12:20:28.090Z |
5053890 | 5053890 | 20240908014521_2wtJF | UK009B | 2024-09-13T12:16:20.990Z | 2024-09-16T12:21:13.028Z |
5038909 | 5038909 | 20240905223423_8FBd1 | UK009B | 2024-09-12T12:15:06.874Z | 2024-09-14T12:22:59.198Z |
5032262 | 5032262 | 20240907003648_bWkri | UK009B | 2024-09-12T12:06:59.694Z | 2024-09-15T12:21:25.744Z |
5025923 | 5025923 | 20240905014031_3JVly | UK009B | 2024-09-11T12:11:30.660Z | 2024-09-13T12:19:56.213Z |
5024490 | 5024490 | 20240905223423_0z2Bk | UK009B | 2024-09-11T12:03:55.778Z | 2024-09-11T12:16:32.162Z |
5020363 | 5020363 | 20240905014031_GS2Eb | UK009B | 2024-09-10T12:14:21.655Z | 2024-09-10T12:16:55.134Z |
5019843 | 5019843 | 20240905000321_yEKbd | UK009B | 2024-09-10T12:13:36.760Z | 2024-09-13T12:19:54.032Z |
5019310 | 5019310 | 20240904222830_MD1G7 | UK009B | 2024-09-10T12:12:35.719Z | 2024-09-13T12:19:51.357Z |
5019237 | 5019237 | 20240904221635_Tz9pl | UK009B | 2024-09-10T12:12:28.146Z | 2024-09-13T12:19:51.095Z |
4991860 | 4991860 | 20240901032727_Vf2Pc | UK009B | 2024-09-07T12:12:33.538Z | 2024-09-09T12:27:26.149Z |
4991702 | 4991702 | 20240901030142_JuD3P | UK009B | 2024-09-07T12:12:25.034Z | 2024-09-09T12:27:16.133Z |
4990927 | 4990927 | 20240901013444_1pXPY | UK009B | 2024-09-07T12:11:19.798Z | 2024-09-09T12:26:55.444Z |
4990890 | 4990890 | 20240901012831_SlSQZ | UK009B | 2024-09-07T12:11:16.152Z | 2024-09-09T12:26:53.874Z |
4990826 | 4990826 | 20240901011638_Zv7UH | UK009B | 2024-09-07T12:11:11.583Z | 2024-09-09T12:26:46.411Z |
4990791 | 4990791 | 20240901011218_NF4vD | UK009B | 2024-09-07T12:11:08.020Z | 2024-09-09T12:26:42.783Z |
4990721 | 4990721 | 20240901010004_Kdg7P | UK009B | 2024-09-07T12:10:58.882Z | 2024-09-09T12:26:33.374Z |
4990650 | 4990650 | 20240901005024_P7qVQ | UK009B | 2024-09-07T12:10:52.730Z | 2024-09-09T12:26:26.235Z |
4990352 | 4990352 | 20240901000453_psmab | UK009B | 2024-09-07T12:10:25.959Z | 2024-09-09T12:26:17.371Z |
4990075 | 4990075 | 20240831232107_Y35JD | UK009B | 2024-09-07T12:09:58.911Z | 2024-09-09T12:26:10.011Z |
4989999 | 4989999 | 20240831231424_QEMsx | UK009B | 2024-09-07T12:09:54.499Z | 2024-09-09T12:26:08.499Z |
4989835 | 4989835 | 20240831224436_Ad4Ga | UK009B | 2024-09-07T12:09:39.579Z | 2024-09-09T12:25:56.522Z |
4977789 | 4977789 | 20240811234442_tLeq0 | UK009B | 2024-09-06T12:12:23.128Z | 2024-09-06T12:12:23.128Z |
4977540 | 4977540 | 20240811234038_i1gCU | UK009B | 2024-09-06T12:12:19.036Z | 2024-09-06T12:12:19.036Z |
4976519 | 4976519 | 20240811233114_VcW2X | UK009B | 2024-09-06T12:11:35.167Z | 2024-09-06T12:11:35.167Z |
4976312 | 4976312 | 20240811232841_TO3st | UK009B | 2024-09-06T12:11:24.820Z | 2024-09-06T12:11:24.820Z |
4976117 | 4976117 | 20240811232546_hpqNL | UK009B | 2024-09-06T12:11:11.810Z | 2024-09-06T12:11:11.810Z |
4975677 | 4975677 | 20240811232111_AH4Xw | UK009B | 2024-09-06T12:10:47.519Z | 2024-09-06T12:10:47.519Z |
4974346 | 4974346 | 20240811230608_PZB1I | UK009B | 2024-09-05T12:11:23.414Z | 2024-09-06T12:10:25.756Z |
4974155 | 4974155 | 20240811230349_uZATs | UK009B | 2024-09-05T12:11:19.451Z | 2024-09-06T12:10:22.497Z |
4973891 | 4973891 | 20240811230122_qCMek | UK009B | 2024-09-05T12:11:13.734Z | 2024-09-06T12:10:10.432Z |
4275735 | 4275735 | 20240503010715_4qLoq | UK009B | 2024-05-05T12:11:38.616Z | 2024-05-11T12:28:15.822Z |
4275673 | 4275673 | 20240502234909_ek2pY | UK009B | 2024-05-05T12:11:24.356Z | 2024-05-11T12:28:12.486Z |
4275665 | 4275665 | 20240502234057_1qr73 | UK009B | 2024-05-05T12:11:23.070Z | 2024-05-11T12:28:12.019Z |
4275650 | 4275650 | 20240502231256_uMsqb | UK009B | 2024-05-05T12:11:19.908Z | 2024-05-11T12:28:11.194Z |
4247726 | 4247726 | 20240428013110_cBgX0 | UK009B | 2024-04-29T12:09:33.191Z | 2024-05-06T12:21:12.572Z |
4243428 | 4243428 | 20240427015216_Nhhtj | UK009B | 2024-04-28T12:09:11.830Z | 2024-05-05T12:21:46.115Z |
4243261 | 4243261 | 20240426234119_LBRW3 | UK009B | 2024-04-28T12:08:54.347Z | 2024-05-05T12:21:44.051Z |
4243231 | 4243231 | 20240426232714_sBl2r | UK009B | 2024-04-28T12:08:49.473Z | 2024-05-05T12:21:43.778Z |
4240350 | 4240350 | 20240425011254_bwvYR | UK009B | 2024-04-27T12:10:33.670Z | 2024-05-03T12:19:30.955Z |
4240244 | 4240244 | 20240424230531_1wnog | UK009B | 2024-04-27T12:10:19.962Z | 2024-05-03T12:19:30.005Z |
4239907 | 4239907 | 20240426012545_PfMDI | UK009B | 2024-04-27T12:07:34.199Z | 2024-05-04T12:21:23.518Z |
4239738 | 4239738 | 20240425232207_pPOgj | UK009B | 2024-04-27T12:07:06.424Z | 2024-05-04T12:21:22.324Z |
4239709 | 4239709 | 20240425230234_1ye7P | UK009B | 2024-04-27T12:07:03.301Z | 2024-05-04T12:21:22.081Z |
4239694 | 4239694 | 20240425225023_ROV2o | UK009B | 2024-04-27T12:07:01.907Z | 2024-05-04T12:21:21.943Z |
4239676 | 4239676 | 20240425221955_iIwpi | UK009B | 2024-04-27T12:06:59.818Z | 2024-05-04T12:21:21.794Z |
4201195 | 4201195 | 20240417013647_lrn8q | UK009B | 2024-04-18T12:02:59.963Z | 2024-04-25T12:21:14.163Z |
4200455 | 4200455 | 20240416215242_KcAYC | UK009B | 2024-04-18T12:01:30.731Z | 2024-04-25T12:21:00.279Z |
4190448 | 4190448 | 20240415003459_ZAatd | UK009B | 2024-04-16T12:03:46.014Z | 2024-04-23T12:24:46.679Z |
4185762 | 4185762 | 20240414020252_UIcwr | UK009B | 2024-04-15T12:05:09.414Z | 2024-04-22T12:22:21.627Z |
4184534 | 4184534 | 20240413210132_9mFNY | UK009B | 2024-04-15T12:01:57.498Z | 2024-04-22T12:22:07.534Z |
4180158 | 4180158 | 20240413023835_EIeN6 | UK009B | 2024-04-14T12:04:09.764Z | 2024-04-21T12:21:41.626Z |
4179492 | 4179492 | 20240412222151_P5Mq3 | UK009B | 2024-04-14T12:01:52.084Z | 2024-04-21T12:21:29.343Z |
4171544 | 4171544 | 20240410023159_Z2Nqq | UK009B | 2024-04-12T12:07:51.243Z | 2024-04-18T12:21:18.453Z |
4169584 | 4169584 | 20240410014114_QUe2Q | UK009B | 2024-04-11T12:14:52.984Z | 2024-04-18T12:21:15.517Z |
4168974 | 4168974 | 20240410002116_sIpOd | UK009B | 2024-04-11T12:13:57.566Z | 2024-04-18T12:21:12.158Z |
4157074 | 4157074 | 20240407212959_dpYf4 | UK009B | 2024-04-09T12:03:37.828Z | 2024-04-16T12:20:13.286Z |
4157030 | 4157030 | 20240407211406_4VnlS | UK009B | 2024-04-09T12:03:30.880Z | 2024-04-16T12:20:13.116Z |
4154831 | 4154831 | 20240407030059_zTZTa | UK009B | 2024-04-08T12:07:15.640Z | 2024-04-15T12:19:17.326Z |
4154568 | 4154568 | 20240407022123_Y6Vcr | UK009B | 2024-04-08T12:06:50.043Z | 2024-04-15T12:19:16.238Z |
4146826 | 4146826 | 20240405012840_Llhpb | UK009B | 2024-04-06T12:04:38.928Z | 2024-04-13T12:21:23.178Z |
4132931 | 4132931 | 20240401012143_zjmiT | UK009B | 2024-04-02T12:03:53.271Z | 2024-04-09T12:21:12.745Z |
4132850 | 4132850 | 20240331225315_2RpOM | UK009B | 2024-04-02T12:03:22.774Z | 2024-04-09T12:21:11.554Z |
4132713 | 4132713 | 20240331202751_KyHrD | UK009B | 2024-04-02T12:03:01.065Z | 2024-04-09T12:21:10.063Z |
4132712 | 4132712 | 20240331202657_8G483 | UK009B | 2024-04-02T12:02:59.767Z | 2024-04-09T12:21:09.989Z |
4123253 | 4123253 | 20240329230428_yrACB | UK009B | 2024-03-31T12:06:36.088Z | 2024-04-07T12:24:19.286Z |
4078322 | 4078322 | 20240316045600_TNMSE | UK009B | 2024-03-17T12:09:27.134Z | 2024-03-24T12:20:57.172Z |
4075974 | 4075974 | 20240315221818_2Jab9 | UK009B | 2024-03-17T12:07:08.076Z | 2024-03-24T12:20:38.463Z |
4051656 | 4051656 | 20240309005515_9fkst | UK009B | 2024-03-10T12:09:13.871Z | 2024-03-17T12:18:22.230Z |
4051628 | 4051628 | 20240309004010_VGfu2 | UK009B | 2024-03-10T12:09:11.342Z | 2024-03-17T12:18:21.926Z |
4041806 | 4041806 | 20240307051729_krCTP | UK009B | 2024-03-08T14:09:23.273Z | 2024-03-15T12:19:40.045Z |
4019411 | 4019411 | 20240302204843_d39LP | UK009B | 2024-03-04T14:04:15.516Z | 2024-03-11T12:18:30.323Z |
4013098 | 4013098 | 20240301024902_UtC07 | UK009B | 2024-03-02T14:08:17.728Z | 2024-03-09T14:17:47.109Z |
4001844 | 4001844 | 20240224194154_VDsVc | UK009B | 2024-02-26T14:01:04.874Z | 2024-03-04T14:18:48.227Z |
4001502 | 4001502 | 20240224055731_TJG2S | UK009B | 2024-02-25T14:03:33.219Z | 2024-03-03T14:17:39.827Z |
4000664 | 4000664 | 20240223194926_A353f | UK009B | 2024-02-25T14:01:29.250Z | 2024-03-03T14:17:22.663Z |
3995258 | 3995258 | 20240221033907_HYJ0c | UK009B | 2024-02-22T14:06:16.697Z | 2024-02-29T14:14:48.655Z |
3995207 | 3995207 | 20240221024905_IPaTg | UK009B | 2024-02-22T14:06:08.851Z | 2024-02-29T14:14:43.936Z |
3966164 | 3966164 | 20240214051814_Ay927 | UK009B | 2024-02-15T14:08:30.307Z | 2024-02-22T14:24:18.427Z |
3965963 | 3965963 | 20240214035502_EPTYa | UK009B | 2024-02-15T14:08:06.334Z | 2024-02-22T14:24:10.122Z |
3965878 | 3965878 | 20240214031813_kELl1 | UK009B | 2024-02-15T14:07:57.641Z | 2024-02-22T14:24:06.588Z |
3965854 | 3965854 | 20240214031240_cBsHe | UK009B | 2024-02-15T14:07:54.654Z | 2024-02-22T14:24:05.044Z |
3965642 | 3965642 | 20240214014441_ni9fv | UK009B | 2024-02-15T14:07:15.481Z | 2024-02-22T14:23:54.263Z |
3965534 | 3965534 | 20240214004751_ubddM | UK009B | 2024-02-15T14:07:04.069Z | 2024-02-22T14:23:50.488Z |
3965446 | 3965446 | 20240214001434_WcyWr | UK009B | 2024-02-15T14:06:40.028Z | 2024-02-22T14:23:47.626Z |
3957340 | 3957340 | 20240212193838_ewYkn | UK009B | 2024-02-14T14:05:20.933Z | 2024-02-21T14:20:22.661Z |
3939217 | 3939217 | 20240209005138_vglDJ | UK009B | 2024-02-10T14:05:38.500Z | 2024-02-17T14:26:13.905Z |
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);