participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,832 rows where station_code = "UK0021" 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 |
---|---|---|---|---|---|
5600586 | 5600586 | 20241125052100_N4iPg | UK0021 | 2024-11-26T14:02:34.412Z | 2024-11-26T14:02:34.412Z |
5582306 | 5582306 | 20241122031952_FtHi5 | UK0021 | 2024-11-23T14:21:02.233Z | 2024-11-26T14:25:25.604Z |
5582237 | 5582237 | 20241122031348_mNjvu | UK0021 | 2024-11-23T14:21:00.053Z | 2024-11-26T14:25:25.050Z |
5582104 | 5582104 | 20241122030339_Pd1Ge | UK0021 | 2024-11-23T14:20:56.748Z | 2024-11-26T14:25:24.001Z |
5582096 | 5582096 | 20241122030317_s34JB | UK0021 | 2024-11-23T14:20:56.358Z | 2024-11-26T14:25:23.963Z |
5581952 | 5581952 | 20241122024956_usMWP | UK0021 | 2024-11-23T14:20:51.764Z | 2024-11-26T14:25:20.666Z |
5579968 | 5579968 | 20241121234036_uco7W | UK0021 | 2024-11-23T14:18:58.548Z | 2024-11-26T14:25:02.110Z |
5579526 | 5579526 | 20241121225640_NyW4d | UK0021 | 2024-11-23T14:18:33.478Z | 2024-11-26T14:24:58.932Z |
5574528 | 5574528 | 20241122055802_hdeyV | UK0021 | 2024-11-23T14:03:38.363Z | 2024-11-26T14:22:23.592Z |
5574200 | 5574200 | 20241122052106_bIfnm | UK0021 | 2024-11-23T14:02:43.576Z | 2024-11-26T14:22:17.569Z |
5573913 | 5573913 | 20241122045235_tqH00 | UK0021 | 2024-11-23T14:01:55.915Z | 2024-11-26T14:22:13.246Z |
5573393 | 5573393 | 20241122041547_S37Ds | UK0021 | 2024-11-23T14:00:27.872Z | 2024-11-26T14:22:02.602Z |
5573331 | 5573331 | 20241122040908_F7IsG | UK0021 | 2024-11-23T14:00:18.609Z | 2024-11-26T14:22:01.041Z |
5564905 | 5564905 | 20241120033817_asmSZ | UK0021 | 2024-11-21T14:18:14.909Z | 2024-11-26T14:27:52.345Z |
5563770 | 5563770 | 20241120020314_AMufm | UK0021 | 2024-11-21T14:16:42.836Z | 2024-11-26T14:27:45.872Z |
5563668 | 5563668 | 20241120015644_giLEd | UK0021 | 2024-11-21T14:16:33.528Z | 2024-11-26T14:27:45.490Z |
5563174 | 5563174 | 20241120010105_xVmDW | UK0021 | 2024-11-21T14:15:39.483Z | 2024-11-26T14:27:43.385Z |
5562828 | 5562828 | 20241120001600_9AOY8 | UK0021 | 2024-11-21T14:15:24.242Z | 2024-11-26T14:27:39.650Z |
5562753 | 5562753 | 20241120000746_pB3Xa | UK0021 | 2024-11-21T14:15:20.055Z | 2024-11-26T14:27:39.243Z |
5562666 | 5562666 | 20241120000303_2SduA | UK0021 | 2024-11-21T14:15:15.997Z | 2024-11-26T14:27:38.538Z |
5562352 | 5562352 | 20241119232929_K8iSJ | UK0021 | 2024-11-21T14:14:44.396Z | 2024-11-26T14:27:36.812Z |
5562237 | 5562237 | 20241119231549_CoOTg | UK0021 | 2024-11-21T14:14:35.477Z | 2024-11-26T14:27:36.164Z |
5561947 | 5561947 | 20241119223851_JbdP9 | UK0021 | 2024-11-21T14:14:16.576Z | 2024-11-26T14:27:34.076Z |
5561561 | 5561561 | 20241119210548_J3uZS | UK0021 | 2024-11-21T14:13:27.864Z | 2024-11-26T14:27:30.410Z |
5561429 | 5561429 | 20241119203139_2INyv | UK0021 | 2024-11-21T14:13:16.113Z | 2024-11-26T14:27:28.846Z |
5561216 | 5561216 | 20241119190741_vW3o2 | UK0021 | 2024-11-21T14:12:39.931Z | 2024-11-26T14:27:26.483Z |
5561194 | 5561194 | 20241119190059_FVj91 | UK0021 | 2024-11-21T14:12:35.434Z | 2024-11-26T14:27:26.147Z |
5532522 | 5532522 | 20241112053337_REb4U | UK0021 | 2024-11-13T14:16:57.162Z | 2024-11-20T14:26:24.159Z |
5532103 | 5532103 | 20241112043735_pBBKM | UK0021 | 2024-11-13T14:16:18.856Z | 2024-11-20T14:26:18.780Z |
5531581 | 5531581 | 20241112035022_hGz7c | UK0021 | 2024-11-13T14:15:45.508Z | 2024-11-20T14:26:12.559Z |
5531214 | 5531214 | 20241112032236_6P91s | UK0021 | 2024-11-13T14:15:25.738Z | 2024-11-20T14:26:08.602Z |
5531137 | 5531137 | 20241112031712_YTnrt | UK0021 | 2024-11-13T14:15:19.272Z | 2024-11-20T14:26:08.278Z |
5531017 | 5531017 | 20241112030622_QnfGG | UK0021 | 2024-11-13T14:15:02.415Z | 2024-11-20T14:26:06.193Z |
5530916 | 5530916 | 20241112025947_puJ4C | UK0021 | 2024-11-13T14:14:50.900Z | 2024-11-20T14:26:05.298Z |
5530313 | 5530313 | 20241112020725_fPTJd | UK0021 | 2024-11-13T14:14:08.326Z | 2024-11-20T14:25:56.883Z |
5530297 | 5530297 | 20241112020617_U3VI4 | UK0021 | 2024-11-13T14:14:07.612Z | 2024-11-20T14:25:56.756Z |
5530294 | 5530294 | 20241112020617_m1lKB | UK0021 | 2024-11-13T14:14:07.518Z | 2024-11-20T14:25:56.747Z |
5530244 | 5530244 | 20241112020153_75BbG | UK0021 | 2024-11-13T14:14:04.463Z | 2024-11-20T14:25:56.108Z |
5529912 | 5529912 | 20241112012027_6oqRk | UK0021 | 2024-11-13T14:13:21.958Z | 2024-11-20T14:25:50.952Z |
5529722 | 5529722 | 20241112010024_SfLKs | UK0021 | 2024-11-13T14:13:07.995Z | 2024-11-20T14:25:47.713Z |
5522987 | 5522987 | 20241110232553_IiCx6 | UK0021 | 2024-11-12T14:14:36.337Z | 2024-11-19T14:22:09.393Z |
5454873 | 5454873 | 20241031053726_wXM6h | UK0021 | 2024-11-02T12:23:25.648Z | 2024-11-08T14:23:26.075Z |
5454737 | 5454737 | 20241031050500_snRO7 | UK0021 | 2024-11-02T12:23:19.516Z | 2024-11-08T14:23:25.424Z |
5452949 | 5452949 | 20241101054003_bbWVg | UK0021 | 2024-11-02T12:19:36.554Z | 2024-11-09T14:24:36.872Z |
5452910 | 5452910 | 20241101052245_jl134 | UK0021 | 2024-11-02T12:19:33.126Z | 2024-11-09T14:24:35.903Z |
5452886 | 5452886 | 20241101051531_axaJO | UK0021 | 2024-11-02T12:19:31.823Z | 2024-11-09T14:24:35.621Z |
5452801 | 5452801 | 20241101044003_8c103 | UK0021 | 2024-11-02T12:19:23.221Z | 2024-11-09T14:24:34.079Z |
5452619 | 5452619 | 20241101035404_Ngj4b | UK0021 | 2024-11-02T12:19:05.772Z | 2024-11-09T14:24:32.121Z |
5452185 | 5452185 | 20241101022004_o9au3 | UK0021 | 2024-11-02T12:18:24.830Z | 2024-11-09T14:24:28.732Z |
5451991 | 5451991 | 20241101014214_o2cky | UK0021 | 2024-11-02T12:18:09.868Z | 2024-11-09T14:24:27.526Z |
5444149 | 5444149 | 20241031005305_TVn3d | UK0021 | 2024-11-01T12:21:07.852Z | 2024-11-08T14:23:14.026Z |
5444107 | 5444107 | 20241031004829_rhEIx | UK0021 | 2024-11-01T12:21:06.148Z | 2024-11-08T14:23:13.977Z |
5443891 | 5443891 | 20241031002552_F3uSb | UK0021 | 2024-11-01T12:20:55.866Z | 2024-11-08T14:23:13.032Z |
5443690 | 5443690 | 20241031000525_nXwxN | UK0021 | 2024-11-01T12:20:46.488Z | 2024-11-08T14:23:11.997Z |
5440650 | 5440650 | 20241030224044_Z0Yo1 | UK0021 | 2024-11-01T12:15:41.922Z | 2024-11-08T14:23:10.209Z |
5440168 | 5440168 | 20241030213458_HYUD6 | UK0021 | 2024-11-01T12:14:55.711Z | 2024-11-08T14:23:07.632Z |
5432995 | 5432995 | 20241029053857_6mRdw | UK0021 | 2024-10-31T12:21:42.430Z | 2024-11-06T14:27:29.499Z |
5432953 | 5432953 | 20241029052507_3nkkl | UK0021 | 2024-10-31T12:21:40.927Z | 2024-11-06T14:27:29.384Z |
5432939 | 5432939 | 20241029052043_dbTmn | UK0021 | 2024-10-31T12:21:40.616Z | 2024-11-06T14:27:29.357Z |
5432806 | 5432806 | 20241029044145_TUeLS | UK0021 | 2024-10-31T12:21:35.724Z | 2024-11-06T14:27:28.769Z |
5432760 | 5432760 | 20241029043347_TblI5 | UK0021 | 2024-10-31T12:21:34.000Z | 2024-11-06T14:27:28.647Z |
5432620 | 5432620 | 20241029040459_4YUnB | UK0021 | 2024-10-31T12:21:28.977Z | 2024-11-06T14:27:28.249Z |
5432386 | 5432386 | 20241029032504_Xkoph | UK0021 | 2024-10-31T12:21:20.430Z | 2024-11-06T14:27:26.791Z |
5431936 | 5431936 | 20241029021750_StPdA | UK0021 | 2024-10-31T12:20:51.236Z | 2024-11-06T14:27:25.517Z |
5431862 | 5431862 | 20241029020801_bANOy | UK0021 | 2024-10-31T12:20:45.303Z | 2024-11-06T14:27:25.136Z |
5431832 | 5431832 | 20241029020239_aubsc | UK0021 | 2024-10-31T12:20:42.936Z | 2024-11-06T14:27:25.030Z |
5431420 | 5431420 | 20241029010913_jPlpb | UK0021 | 2024-10-31T12:20:06.896Z | 2024-11-06T14:27:23.594Z |
5431373 | 5431373 | 20241029010154_qDyQx | UK0021 | 2024-10-31T12:20:03.128Z | 2024-11-06T14:27:23.376Z |
5431358 | 5431358 | 20241029010056_VfAnq | UK0021 | 2024-10-31T12:20:01.862Z | 2024-11-06T14:27:23.357Z |
5421075 | 5421075 | 20241028042854_soFKn | UK0021 | 2024-10-30T12:19:35.017Z | 2024-11-05T14:27:17.266Z |
5407574 | 5407574 | 20241027024232_Dr9SH | UK0021 | 2024-10-29T12:15:30.259Z | 2024-11-04T14:28:57.899Z |
5407340 | 5407340 | 20241027023200_UU4kf | UK0021 | 2024-10-29T12:15:21.440Z | 2024-11-04T14:28:57.351Z |
5407267 | 5407267 | 20241027022903_412Uj | UK0021 | 2024-10-29T12:15:19.265Z | 2024-11-04T14:28:57.285Z |
5407163 | 5407163 | 20241027022434_c23ut | UK0021 | 2024-10-29T12:15:15.487Z | 2024-11-04T14:28:57.130Z |
5406250 | 5406250 | 20241027012357_3kuD2 | UK0021 | 2024-10-29T12:13:59.470Z | 2024-11-04T14:28:55.258Z |
5406046 | 5406046 | 20241027011309_Rq9zL | UK0021 | 2024-10-29T12:13:49.103Z | 2024-11-04T14:28:54.901Z |
5405709 | 5405709 | 20241027005421_2BXHF | UK0021 | 2024-10-29T12:13:10.550Z | 2024-11-04T14:28:53.926Z |
5405702 | 5405702 | 20241027005421_5oB1l | UK0021 | 2024-10-29T12:13:10.325Z | 2024-11-04T14:28:53.923Z |
5405426 | 5405426 | 20241027003316_GPrPl | UK0021 | 2024-10-29T12:12:55.430Z | 2024-11-04T14:28:53.467Z |
5403328 | 5403328 | 20241026214139_mQhTZ | UK0021 | 2024-10-29T12:09:22.232Z | 2024-11-04T14:28:48.365Z |
5403206 | 5403206 | 20241026212934_XBX7g | UK0021 | 2024-10-29T12:09:13.090Z | 2024-11-04T14:28:47.964Z |
5403030 | 5403030 | 20241026210717_OBaqF | UK0021 | 2024-10-29T12:08:45.866Z | 2024-11-04T14:28:47.449Z |
5402368 | 5402368 | 20241026192324_A5y8Y | UK0021 | 2024-10-29T12:07:06.205Z | 2024-11-04T14:28:44.137Z |
5402340 | 5402340 | 20241026191856_UCJ35 | UK0021 | 2024-10-29T12:07:02.338Z | 2024-11-04T14:28:43.765Z |
5402248 | 5402248 | 20241026190615_7Ca0D | UK0021 | 2024-10-29T12:06:44.434Z | 2024-11-04T14:28:43.331Z |
5401897 | 5401897 | 20241026180251_29qWN | UK0021 | 2024-10-29T12:05:46.284Z | 2024-11-04T14:28:40.847Z |
5400187 | 5400187 | 20241026055149_UUsPW | UK0021 | 2024-10-28T12:20:25.699Z | 2024-11-03T14:27:41.524Z |
5400081 | 5400081 | 20241026053722_jV2o3 | UK0021 | 2024-10-28T12:20:21.857Z | 2024-11-03T14:27:41.269Z |
5399929 | 5399929 | 20241026051303_oyNEc | UK0021 | 2024-10-28T12:20:17.129Z | 2024-11-03T14:27:40.870Z |
5399839 | 5399839 | 20241026050603_vQtw8 | UK0021 | 2024-10-28T12:20:13.190Z | 2024-11-03T14:27:40.601Z |
5399610 | 5399610 | 20241026043919_ErU0z | UK0021 | 2024-10-28T12:20:04.032Z | 2024-11-03T14:27:40.081Z |
5399532 | 5399532 | 20241026043233_5buxY | UK0021 | 2024-10-28T12:20:01.657Z | 2024-11-03T14:27:39.939Z |
5399245 | 5399245 | 20241026040459_FIVN3 | UK0021 | 2024-10-28T12:19:52.437Z | 2024-11-03T14:27:39.281Z |
5399064 | 5399064 | 20241026034824_FPicK | UK0021 | 2024-10-28T12:19:47.012Z | 2024-11-03T14:27:38.959Z |
5399036 | 5399036 | 20241026034611_eikYZ | UK0021 | 2024-10-28T12:19:45.243Z | 2024-11-03T14:27:38.913Z |
5398991 | 5398991 | 20241026034400_Lpq47 | UK0021 | 2024-10-28T12:19:43.828Z | 2024-11-03T14:27:38.817Z |
5398833 | 5398833 | 20241026033213_krvse | UK0021 | 2024-10-28T12:19:35.778Z | 2024-11-03T14:27:38.274Z |
5398804 | 5398804 | 20241026033023_Mpcd8 | UK0021 | 2024-10-28T12:19:34.063Z | 2024-11-03T14:27:38.138Z |
5398704 | 5398704 | 20241026032054_37ald | UK0021 | 2024-10-28T12:19:28.928Z | 2024-11-03T14:27:37.872Z |
5398282 | 5398282 | 20241026024202_MvdrU | UK0021 | 2024-10-28T12:19:09.367Z | 2024-11-03T14:27:35.832Z |
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);