participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,767 rows where station_code = "UK0081" 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 |
---|---|---|---|---|---|
5470126 | 5470126 | 20241103054419_NnbJZ | UK0081 | 2024-11-04T14:17:49.689Z | 2024-11-08T14:21:15.663Z |
5470123 | 5470123 | 20241103054308_eMbzt | UK0081 | 2024-11-04T14:17:49.552Z | 2024-11-08T14:21:15.642Z |
5469852 | 5469852 | 20241103042853_1Y24P | UK0081 | 2024-11-04T14:17:11.236Z | 2024-11-08T14:21:13.218Z |
5469841 | 5469841 | 20241103042800_AC55h | UK0081 | 2024-11-04T14:17:08.447Z | 2024-11-08T14:21:13.111Z |
5469712 | 5469712 | 20241103040540_Btc2P | UK0081 | 2024-11-04T14:16:54.956Z | 2024-11-08T14:21:12.487Z |
5469665 | 5469665 | 20241103035808_W2KFP | UK0081 | 2024-11-04T14:16:45.129Z | 2024-11-08T14:21:12.076Z |
5469521 | 5469521 | 20241103033920_rkcXw | UK0081 | 2024-11-04T14:16:33.706Z | 2024-11-08T14:21:10.496Z |
5469423 | 5469423 | 20241103032448_Vcowe | UK0081 | 2024-11-04T14:16:26.699Z | 2024-11-08T14:21:09.576Z |
5469090 | 5469090 | 20241103023430_xsiYi | UK0081 | 2024-11-04T14:15:35.554Z | 2024-11-08T14:21:07.004Z |
5468829 | 5468829 | 20241103015307_PJ1hM | UK0081 | 2024-11-04T14:15:06.558Z | 2024-11-08T14:21:04.793Z |
5468459 | 5468459 | 20241103004030_ZQdUz | UK0081 | 2024-11-04T14:14:09.022Z | 2024-11-08T14:21:02.250Z |
5454400 | 5454400 | 20241031041615_61Wzd | UK0081 | 2024-11-02T12:23:05.393Z | 2024-11-08T14:23:22.665Z |
5454257 | 5454257 | 20241031040324_dpJw5 | UK0081 | 2024-11-02T12:22:56.814Z | 2024-11-08T14:23:21.760Z |
5453900 | 5453900 | 20241031031339_umS8g | UK0081 | 2024-11-02T12:22:44.679Z | 2024-11-08T14:23:19.645Z |
5453650 | 5453650 | 20241031023902_a0jn3 | UK0081 | 2024-11-02T12:22:38.277Z | 2024-11-08T14:23:18.385Z |
5453534 | 5453534 | 20241031022111_vQcBF | UK0081 | 2024-11-02T12:22:35.481Z | 2024-11-08T14:23:17.892Z |
5453450 | 5453450 | 20241031021315_oZDxE | UK0081 | 2024-11-02T12:22:33.917Z | 2024-11-08T14:23:17.417Z |
5453422 | 5453422 | 20241031021055_UoP2W | UK0081 | 2024-11-02T12:22:33.364Z | 2024-11-08T14:23:17.323Z |
5453357 | 5453357 | 20241031020457_bU80m | UK0081 | 2024-11-02T12:22:32.395Z | 2024-11-08T14:23:16.931Z |
5443186 | 5443186 | 20241030035529_fAJ88 | UK0081 | 2024-11-01T12:20:21.225Z | 2024-11-07T14:26:49.995Z |
5442827 | 5442827 | 20241030023833_c3TFE | UK0081 | 2024-11-01T12:20:09.943Z | 2024-11-07T14:26:48.504Z |
5442501 | 5442501 | 20241030014123_FrTAM | UK0081 | 2024-11-01T12:19:55.166Z | 2024-11-07T14:26:46.805Z |
5442409 | 5442409 | 20241030012628_V6JAh | UK0081 | 2024-11-01T12:19:46.835Z | 2024-11-07T14:26:46.541Z |
5442192 | 5442192 | 20241030005336_BmHyi | UK0081 | 2024-11-01T12:19:32.936Z | 2024-11-07T14:26:45.534Z |
5441602 | 5441602 | 20241029224525_MUP0M | UK0081 | 2024-11-01T12:18:47.262Z | 2024-11-07T14:26:42.725Z |
5439541 | 5439541 | 20241030200511_gtoF7 | UK0081 | 2024-11-01T12:13:57.615Z | 2024-11-08T14:23:03.886Z |
5433377 | 5433377 | 20241029192659_iJycZ | UK0081 | 2024-10-31T12:22:11.327Z | 2024-11-07T14:26:38.781Z |
5433339 | 5433339 | 20241029191028_ejio4 | UK0081 | 2024-10-31T12:22:08.548Z | 2024-11-07T14:26:38.467Z |
5433316 | 5433316 | 20241029185808_1Jzxs | UK0081 | 2024-10-31T12:22:05.966Z | 2024-11-07T14:26:37.650Z |
5433309 | 5433309 | 20241029185624_GCfHg | UK0081 | 2024-10-31T12:22:05.270Z | 2024-11-07T14:26:37.611Z |
5433302 | 5433302 | 20241029185443_sC80o | UK0081 | 2024-10-31T12:22:04.496Z | 2024-11-07T14:26:37.562Z |
5433282 | 5433282 | 20241029184728_TgDWs | UK0081 | 2024-10-31T12:22:03.784Z | 2024-11-07T14:26:37.505Z |
5432803 | 5432803 | 20241029044141_SAFjr | UK0081 | 2024-10-31T12:21:35.649Z | 2024-11-06T14:27:28.756Z |
5432771 | 5432771 | 20241029043528_Da6eX | UK0081 | 2024-10-31T12:21:34.478Z | 2024-11-06T14:27:28.674Z |
5432743 | 5432743 | 20241029043144_m1QkU | UK0081 | 2024-10-31T12:21:33.349Z | 2024-11-06T14:27:28.603Z |
5432718 | 5432718 | 20241029042507_9iclh | UK0081 | 2024-10-31T12:21:32.414Z | 2024-11-06T14:27:28.557Z |
5421233 | 5421233 | 20241028051521_1mw7Z | UK0081 | 2024-10-30T12:19:44.482Z | 2024-11-05T14:27:17.845Z |
5420658 | 5420658 | 20241028031521_EEVVR | UK0081 | 2024-10-30T12:19:08.577Z | 2024-11-05T14:27:15.983Z |
5420467 | 5420467 | 20241028024502_0Eu80 | UK0081 | 2024-10-30T12:18:53.492Z | 2024-11-05T14:27:15.532Z |
5410367 | 5410367 | 20241027050909_xtLUD | UK0081 | 2024-10-29T12:17:54.388Z | 2024-11-04T14:29:04.465Z |
5410305 | 5410305 | 20241027050536_MnhRh | UK0081 | 2024-10-29T12:17:52.714Z | 2024-11-04T14:29:04.319Z |
5410248 | 5410248 | 20241027050243_o80p7 | UK0081 | 2024-10-29T12:17:51.357Z | 2024-11-04T14:29:04.241Z |
5409980 | 5409980 | 20241027044648_n1grp | UK0081 | 2024-10-29T12:17:45.258Z | 2024-11-04T14:29:03.169Z |
5409777 | 5409777 | 20241027043543_tSNjQ | UK0081 | 2024-10-29T12:17:40.797Z | 2024-11-04T14:29:02.635Z |
5409387 | 5409387 | 20241027041335_UDF30 | UK0081 | 2024-10-29T12:17:19.320Z | 2024-11-04T14:29:01.632Z |
5409264 | 5409264 | 20241027040740_seG2j | UK0081 | 2024-10-29T12:17:14.390Z | 2024-11-04T14:29:01.442Z |
5409229 | 5409229 | 20241027040618_jjlTY | UK0081 | 2024-10-29T12:17:12.920Z | 2024-11-04T14:29:01.385Z |
5409001 | 5409001 | 20241027035343_3617E | UK0081 | 2024-10-29T12:17:01.168Z | 2024-11-04T14:29:00.903Z |
5408927 | 5408927 | 20241027035014_bGBuQ | UK0081 | 2024-10-29T12:16:57.291Z | 2024-11-04T14:29:00.826Z |
5408693 | 5408693 | 20241027033730_VJAL7 | UK0081 | 2024-10-29T12:16:45.513Z | 2024-11-04T14:29:00.308Z |
5408582 | 5408582 | 20241027033052_Lc2ou | UK0081 | 2024-10-29T12:16:37.770Z | 2024-11-04T14:28:59.658Z |
5408540 | 5408540 | 20241027032948_qbAVL | UK0081 | 2024-10-29T12:16:35.279Z | 2024-11-04T14:28:59.609Z |
5408340 | 5408340 | 20241027032227_JLKlZ | UK0081 | 2024-10-29T12:16:23.439Z | 2024-11-04T14:28:59.182Z |
5408207 | 5408207 | 20241027031624_kszb2 | UK0081 | 2024-10-29T12:16:16.352Z | 2024-11-04T14:28:58.995Z |
5407839 | 5407839 | 20241027025501_Stiw7 | UK0081 | 2024-10-29T12:15:48.146Z | 2024-11-04T14:28:58.242Z |
5407807 | 5407807 | 20241027025314_R8OYR | UK0081 | 2024-10-29T12:15:43.436Z | 2024-11-04T14:28:58.167Z |
5407728 | 5407728 | 20241027024946_WWqsY | UK0081 | 2024-10-29T12:15:36.077Z | 2024-11-04T14:28:58.078Z |
5407701 | 5407701 | 20241027024754_Qaknq | UK0081 | 2024-10-29T12:15:34.819Z | 2024-11-04T14:28:58.062Z |
5407584 | 5407584 | 20241027024303_2qGyA | UK0081 | 2024-10-29T12:15:30.761Z | 2024-11-04T14:28:57.903Z |
5407466 | 5407466 | 20241027023808_8npYJ | UK0081 | 2024-10-29T12:15:25.812Z | 2024-11-04T14:28:57.638Z |
5407277 | 5407277 | 20241027022947_3qBvx | UK0081 | 2024-10-29T12:15:19.621Z | 2024-11-04T14:28:57.292Z |
5407204 | 5407204 | 20241027022609_3Mkgb | UK0081 | 2024-10-29T12:15:16.748Z | 2024-11-04T14:28:57.236Z |
5407194 | 5407194 | 20241027022518_F4HLU | UK0081 | 2024-10-29T12:15:16.404Z | 2024-11-04T14:28:57.233Z |
5407125 | 5407125 | 20241027022314_LhLdT | UK0081 | 2024-10-29T12:15:13.642Z | 2024-11-04T14:28:56.964Z |
5406357 | 5406357 | 20241027013011_gE1d1 | UK0081 | 2024-10-29T12:14:03.884Z | 2024-11-04T14:28:55.499Z |
5406334 | 5406334 | 20241027012845_sCCt6 | UK0081 | 2024-10-29T12:14:02.768Z | 2024-11-04T14:28:55.473Z |
5406274 | 5406274 | 20241027012445_t0hXH | UK0081 | 2024-10-29T12:14:00.393Z | 2024-11-04T14:28:55.280Z |
5406149 | 5406149 | 20241027011913_77td8 | UK0081 | 2024-10-29T12:13:53.784Z | 2024-11-04T14:28:55.164Z |
5405092 | 5405092 | 20241027001255_6GNj0 | UK0081 | 2024-10-29T12:12:25.807Z | 2024-11-04T14:28:52.665Z |
5404987 | 5404987 | 20241027000638_V7f3j | UK0081 | 2024-10-29T12:12:14.262Z | 2024-11-04T14:28:52.491Z |
5404966 | 5404966 | 20241027000314_Cu5X5 | UK0081 | 2024-10-29T12:12:11.293Z | 2024-11-04T14:28:52.456Z |
5404824 | 5404824 | 20241026235453_54xEG | UK0081 | 2024-10-29T12:11:59.868Z | 2024-11-04T14:28:52.046Z |
5404767 | 5404767 | 20241026235112_cGdTF | UK0081 | 2024-10-29T12:11:56.679Z | 2024-11-04T14:28:51.918Z |
5404300 | 5404300 | 20241026231449_6Xi5F | UK0081 | 2024-10-29T12:11:06.227Z | 2024-11-04T14:28:50.590Z |
5404293 | 5404293 | 20241026231429_KGRQk | UK0081 | 2024-10-29T12:11:05.328Z | 2024-11-04T14:28:50.584Z |
5404227 | 5404227 | 20241026230949_zMWrR | UK0081 | 2024-10-29T12:11:01.915Z | 2024-11-04T14:28:50.494Z |
5404180 | 5404180 | 20241026230529_7T03z | UK0081 | 2024-10-29T12:10:58.261Z | 2024-11-04T14:28:50.406Z |
5404037 | 5404037 | 20241026225413_BkPuz | UK0081 | 2024-10-29T12:10:49.426Z | 2024-11-04T14:28:50.263Z |
5403870 | 5403870 | 20241026224041_LTkJq | UK0081 | 2024-10-29T12:10:23.364Z | 2024-11-04T14:28:49.917Z |
5403662 | 5403662 | 20241026222201_erkxz | UK0081 | 2024-10-29T12:10:05.878Z | 2024-11-04T14:28:49.420Z |
5403574 | 5403574 | 20241026221317_s5Ke6 | UK0081 | 2024-10-29T12:09:58.699Z | 2024-11-04T14:28:49.236Z |
5403563 | 5403563 | 20241026221026_buSA8 | UK0081 | 2024-10-29T12:09:56.520Z | 2024-11-04T14:28:49.172Z |
5403470 | 5403470 | 20241026220035_klKCF | UK0081 | 2024-10-29T12:09:34.848Z | 2024-11-04T14:28:48.948Z |
5403455 | 5403455 | 20241026215834_ukyPE | UK0081 | 2024-10-29T12:09:32.276Z | 2024-11-04T14:28:48.893Z |
5403449 | 5403449 | 20241026215757_kBLQ3 | UK0081 | 2024-10-29T12:09:32.005Z | 2024-11-04T14:28:48.891Z |
5403114 | 5403114 | 20241026211920_jGGMt | UK0081 | 2024-10-29T12:08:57.959Z | 2024-11-04T14:28:47.723Z |
5402663 | 5402663 | 20241026201150_Jj82D | UK0081 | 2024-10-29T12:07:55.427Z | 2024-11-04T14:28:45.903Z |
5402596 | 5402596 | 20241026200336_D3HhR | UK0081 | 2024-10-29T12:07:46.924Z | 2024-11-04T14:28:45.507Z |
5402434 | 5402434 | 20241026193620_Vpp5i | UK0081 | 2024-10-29T12:07:16.521Z | 2024-11-04T14:28:44.406Z |
5402416 | 5402416 | 20241026193202_GiCOA | UK0081 | 2024-10-29T12:07:13.126Z | 2024-11-04T14:28:44.255Z |
5402372 | 5402372 | 20241026192427_r6rQ2 | UK0081 | 2024-10-29T12:07:06.623Z | 2024-11-04T14:28:44.161Z |
5402284 | 5402284 | 20241026191002_bSMSz | UK0081 | 2024-10-29T12:06:52.753Z | 2024-11-04T14:28:43.601Z |
5402246 | 5402246 | 20241026190545_n6hoR | UK0081 | 2024-10-29T12:06:43.770Z | 2024-11-04T14:28:43.327Z |
5388565 | 5388565 | 20241025052540_acLdf | UK0081 | 2024-10-27T12:22:21.155Z | 2024-11-02T12:28:34.442Z |
5388553 | 5388553 | 20241025052449_nyEAF | UK0081 | 2024-10-27T12:22:20.554Z | 2024-11-02T12:28:34.427Z |
5388547 | 5388547 | 20241025052348_3COqQ | UK0081 | 2024-10-27T12:22:20.407Z | 2024-11-02T12:28:34.422Z |
5388519 | 5388519 | 20241025051605_TiIQZ | UK0081 | 2024-10-27T12:22:18.736Z | 2024-11-02T12:28:34.334Z |
5388423 | 5388423 | 20241025044858_Pdn6Q | UK0081 | 2024-10-27T12:22:13.439Z | 2024-11-02T12:28:34.157Z |
5388357 | 5388357 | 20241025043803_w2WWh | UK0081 | 2024-10-27T12:22:10.703Z | 2024-11-02T12:28:33.975Z |
5356088 | 5356088 | 20241023045517_abnBr | UK0081 | 2024-10-24T12:21:50.373Z | 2024-10-31T12:30:09.796Z |
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);