participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,092 rows where station_code = "UK0033" 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 |
---|---|---|---|---|---|
2250457 | 2250457 | 20230130185241_PFZP9 | UK0033 | 2024-01-05T23:54:51.830Z | 2024-01-05T23:54:51.830Z |
2249198 | 2249198 | 20230130060539_OWIkp | UK0033 | 2024-01-05T23:54:50.544Z | 2024-01-05T23:54:50.544Z |
2249127 | 2249127 | 20230130055352_KhYvp | UK0033 | 2024-01-05T23:54:50.537Z | 2024-01-05T23:54:50.537Z |
2249083 | 2249083 | 20230130054817_N6Nzv | UK0033 | 2024-01-05T23:54:50.533Z | 2024-01-05T23:54:50.533Z |
2248397 | 2248397 | 20230130030140_7Cbdr | UK0033 | 2024-01-05T23:54:50.455Z | 2024-01-05T23:54:50.455Z |
2245013 | 2245013 | 20230128213813_fkszD | UK0033 | 2024-01-05T23:54:48.880Z | 2024-01-05T23:54:48.880Z |
2235681 | 2235681 | 20230126054743_n49HB | UK0033 | 2024-01-05T23:54:43.852Z | 2024-01-05T23:54:43.852Z |
2235331 | 2235331 | 20230126044823_3vHWQ | UK0033 | 2024-01-05T23:54:43.785Z | 2024-01-05T23:54:43.785Z |
2235259 | 2235259 | 20230126043515_5KLik | UK0033 | 2024-01-05T23:54:43.773Z | 2024-01-05T23:54:43.773Z |
2235207 | 2235207 | 20230126043149_tjN97 | UK0033 | 2024-01-05T23:54:43.764Z | 2024-01-05T23:54:43.764Z |
2234085 | 2234085 | 20230126004520_W7zo8 | UK0033 | 2024-01-05T23:54:43.563Z | 2024-01-05T23:54:43.563Z |
2233866 | 2233866 | 20230125234039_udlqx | UK0033 | 2024-01-05T23:54:43.520Z | 2024-01-05T23:54:43.520Z |
2233516 | 2233516 | 20230125204358_qwThO | UK0033 | 2024-01-05T23:54:43.441Z | 2024-01-05T23:54:43.441Z |
2228720 | 2228720 | 20230124053211_KYN32 | UK0033 | 2024-01-05T23:54:39.126Z | 2024-01-05T23:54:39.126Z |
2228339 | 2228339 | 20230124040614_adSzZ | UK0033 | 2024-01-05T23:54:38.930Z | 2024-01-05T23:54:38.930Z |
2228304 | 2228304 | 20230124040031_3K2xS | UK0033 | 2024-01-05T23:54:38.907Z | 2024-01-05T23:54:38.907Z |
2227813 | 2227813 | 20230124014758_Kf3CK | UK0033 | 2024-01-05T23:54:38.619Z | 2024-01-05T23:54:38.619Z |
2227715 | 2227715 | 20230124012020_YAoO1 | UK0033 | 2024-01-05T23:54:38.571Z | 2024-01-05T23:54:38.571Z |
2227654 | 2227654 | 20230124010243_37iac | UK0033 | 2024-01-05T23:54:38.549Z | 2024-01-05T23:54:38.549Z |
2227619 | 2227619 | 20230124004607_TZIL3 | UK0033 | 2024-01-05T23:54:38.534Z | 2024-01-05T23:54:38.534Z |
2227581 | 2227581 | 20230124003705_Jgvt6 | UK0033 | 2024-01-05T23:54:38.511Z | 2024-01-05T23:54:38.511Z |
2227374 | 2227374 | 20230123231716_p1MAW | UK0033 | 2024-01-05T23:54:38.416Z | 2024-01-05T23:54:38.416Z |
2226068 | 2226068 | 20230123042351_l19qv | UK0033 | 2024-01-05T23:54:36.351Z | 2024-01-05T23:54:36.351Z |
2225791 | 2225791 | 20230123030023_UjCRp | UK0033 | 2024-01-05T23:54:36.271Z | 2024-01-05T23:54:36.271Z |
2219201 | 2219201 | 20230121052557_NsMGm | UK0033 | 2024-01-05T23:54:31.617Z | 2024-01-05T23:54:31.617Z |
2218788 | 2218788 | 20230121044442_s83we | UK0033 | 2024-01-05T23:54:31.523Z | 2024-01-05T23:54:31.523Z |
2218579 | 2218579 | 20230121042411_gkCdW | UK0033 | 2024-01-05T23:54:31.464Z | 2024-01-05T23:54:31.464Z |
2218562 | 2218562 | 20230121042208_yT3GR | UK0033 | 2024-01-05T23:54:31.456Z | 2024-01-05T23:54:31.456Z |
2218116 | 2218116 | 20230121034233_533bo | UK0033 | 2024-01-05T23:54:31.253Z | 2024-01-05T23:54:31.253Z |
2217320 | 2217320 | 20230121015933_AANn3 | UK0033 | 2024-01-05T23:54:30.984Z | 2024-01-05T23:54:30.984Z |
2217130 | 2217130 | 20230121012816_Qkcnq | UK0033 | 2024-01-05T23:54:30.942Z | 2024-01-05T23:54:30.942Z |
2217095 | 2217095 | 20230121012454_kGa6Z | UK0033 | 2024-01-05T23:54:30.937Z | 2024-01-05T23:54:30.937Z |
2216807 | 2216807 | 20230121002653_jVAFi | UK0033 | 2024-01-05T23:54:30.876Z | 2024-01-05T23:54:30.876Z |
2216751 | 2216751 | 20230121001805_EJUEj | UK0033 | 2024-01-05T23:54:30.866Z | 2024-01-05T23:54:30.866Z |
2216486 | 2216486 | 20230120230239_qiQRg | UK0033 | 2024-01-05T23:54:30.811Z | 2024-01-05T23:54:30.811Z |
2216356 | 2216356 | 20230120223939_hTPUg | UK0033 | 2024-01-05T23:54:30.785Z | 2024-01-05T23:54:30.785Z |
2216279 | 2216279 | 20230120221148_JGIVN | UK0033 | 2024-01-05T23:54:30.755Z | 2024-01-05T23:54:30.755Z |
2216246 | 2216246 | 20230120220134_3jFZi | UK0033 | 2024-01-05T23:54:30.746Z | 2024-01-05T23:54:30.746Z |
2215780 | 2215780 | 20230120201829_fK8vC | UK0033 | 2024-01-05T23:54:30.625Z | 2024-01-05T23:54:30.625Z |
2215760 | 2215760 | 20230120201252_0o1Qg | UK0033 | 2024-01-05T23:54:30.622Z | 2024-01-05T23:54:30.622Z |
2215543 | 2215543 | 20230120192115_uymcE | UK0033 | 2024-01-05T23:54:30.574Z | 2024-01-05T23:54:30.574Z |
2214086 | 2214086 | 20230120061809_LOIRd | UK0033 | 2024-01-05T23:54:28.535Z | 2024-01-05T23:54:28.535Z |
2211005 | 2211005 | 20230119215147_50JoC | UK0033 | 2024-01-05T23:54:27.777Z | 2024-01-05T23:54:27.777Z |
2210844 | 2210844 | 20230119203237_iLaT0 | UK0033 | 2024-01-05T23:54:27.711Z | 2024-01-05T23:54:27.711Z |
2210598 | 2210598 | 20230119181558_Tx8K8 | UK0033 | 2024-01-05T23:54:27.598Z | 2024-01-05T23:54:27.598Z |
2208826 | 2208826 | 20230119064321_sQTDW | UK0033 | 2024-01-05T23:54:25.066Z | 2024-01-05T23:54:25.066Z |
2204051 | 2204051 | 20230118042423_g4CP6 | UK0033 | 2024-01-05T23:54:21.978Z | 2024-01-05T23:54:21.978Z |
2203574 | 2203574 | 20230118025415_NEfir | UK0033 | 2024-01-05T23:54:21.942Z | 2024-01-05T23:54:21.942Z |
2202979 | 2202979 | 20230118011543_sYgLS | UK0033 | 2024-01-05T23:54:21.890Z | 2024-01-05T23:54:21.890Z |
2202970 | 2202970 | 20230118011326_jI5Lq | UK0033 | 2024-01-05T23:54:21.889Z | 2024-01-05T23:54:21.889Z |
2202921 | 2202921 | 20230118005734_PGgru | UK0033 | 2024-01-05T23:54:21.885Z | 2024-01-05T23:54:21.885Z |
2202366 | 2202366 | 20230117222023_sJEUl | UK0033 | 2024-01-05T23:54:21.834Z | 2024-01-05T23:54:21.834Z |
2202061 | 2202061 | 20230117204421_cZ7uG | UK0033 | 2024-01-05T23:54:21.809Z | 2024-01-05T23:54:21.809Z |
2201856 | 2201856 | 20230117190908_CwALX | UK0033 | 2024-01-05T23:54:21.789Z | 2024-01-05T23:54:21.789Z |
2201821 | 2201821 | 20230117185341_Ho2Rf | UK0033 | 2024-01-05T23:54:21.787Z | 2024-01-05T23:54:21.787Z |
2201733 | 2201733 | 20230117175125_ZXMFl | UK0033 | 2024-01-05T23:54:21.775Z | 2024-01-05T23:54:21.775Z |
2201083 | 2201083 | 20230117054342_0wvnn | UK0033 | 2024-01-05T23:54:20.526Z | 2024-01-05T23:54:20.526Z |
2200487 | 2200487 | 20230117042030_HcsbT | UK0033 | 2024-01-05T23:54:20.472Z | 2024-01-05T23:54:20.472Z |
2199890 | 2199890 | 20230117021941_DHeYL | UK0033 | 2024-01-05T23:54:20.418Z | 2024-01-05T23:54:20.418Z |
2199896 | 2199896 | 20230117022115_J3Nh1 | UK0033 | 2024-01-05T23:54:20.418Z | 2024-01-05T23:54:20.418Z |
2199825 | 2199825 | 20230117020401_uve32 | UK0033 | 2024-01-05T23:54:20.411Z | 2024-01-05T23:54:20.411Z |
2199482 | 2199482 | 20230117002648_YtioZ | UK0033 | 2024-01-05T23:54:20.379Z | 2024-01-05T23:54:20.379Z |
2199443 | 2199443 | 20230117001342_G3rsW | UK0033 | 2024-01-05T23:54:20.375Z | 2024-01-05T23:54:20.375Z |
2198713 | 2198713 | 20230116192858_9MLZF | UK0033 | 2024-01-05T23:54:20.308Z | 2024-01-05T23:54:20.308Z |
2198537 | 2198537 | 20230116180436_HGTdc | UK0033 | 2024-01-05T23:54:20.289Z | 2024-01-05T23:54:20.289Z |
2198504 | 2198504 | 20230116174611_DSDY5 | UK0033 | 2024-01-05T23:54:20.285Z | 2024-01-05T23:54:20.285Z |
2197920 | 2197920 | 20230116033829_ijEEY | UK0033 | 2024-01-05T23:54:19.031Z | 2024-01-05T23:54:19.031Z |
2195360 | 2195360 | 20230114182208_cC2ed | UK0033 | 2024-01-05T23:54:16.466Z | 2024-01-05T23:54:16.466Z |
2194366 | 2194366 | 20230113180341_cIy03 | UK0033 | 2024-01-05T23:54:15.235Z | 2024-01-05T23:54:15.235Z |
2191682 | 2191682 | 20230112195440_cezzi | UK0033 | 2024-01-05T23:54:14.973Z | 2024-01-05T23:54:14.973Z |
2191550 | 2191550 | 20230112182430_H1R5F | UK0033 | 2024-01-05T23:54:13.809Z | 2024-01-05T23:54:13.809Z |
2191547 | 2191547 | 20230112182340_QAAt2 | UK0033 | 2024-01-05T23:54:13.808Z | 2024-01-05T23:54:13.808Z |
2189318 | 2189318 | 20230111063346_VTezb | UK0033 | 2024-01-05T23:54:12.434Z | 2024-01-05T23:54:12.434Z |
2188982 | 2188982 | 20230111042517_XZHX3 | UK0033 | 2024-01-05T23:54:12.402Z | 2024-01-05T23:54:12.402Z |
2188916 | 2188916 | 20230111035823_hYQBQ | UK0033 | 2024-01-05T23:54:12.395Z | 2024-01-05T23:54:12.395Z |
2188844 | 2188844 | 20230111034015_sJAWo | UK0033 | 2024-01-05T23:54:12.389Z | 2024-01-05T23:54:12.389Z |
2188718 | 2188718 | 20230111030511_1zOIv | UK0033 | 2024-01-05T23:54:12.376Z | 2024-01-05T23:54:12.376Z |
2187208 | 2187208 | 20230109230847_dX7df | UK0033 | 2024-01-05T23:54:11.060Z | 2024-01-05T23:54:11.060Z |
2187179 | 2187179 | 20230109230008_HfRLD | UK0033 | 2024-01-05T23:54:11.058Z | 2024-01-05T23:54:11.058Z |
2187126 | 2187126 | 20230109222840_A59q5 | UK0033 | 2024-01-05T23:54:11.054Z | 2024-01-05T23:54:11.054Z |
2186844 | 2186844 | 20230109183345_HTClD | UK0033 | 2024-01-05T23:54:09.895Z | 2024-01-05T23:54:09.895Z |
2183681 | 2183681 | 20230106070446_7bJAV | UK0033 | 2024-01-05T23:54:06.198Z | 2024-01-05T23:54:06.198Z |
2183355 | 2183355 | 20230106050107_WO3UB | UK0033 | 2024-01-05T23:54:06.167Z | 2024-01-05T23:54:06.167Z |
2178903 | 2178903 | 20230102212451_aoERh | UK0033 | 2024-01-05T23:54:02.043Z | 2024-01-05T23:54:02.043Z |
2178802 | 2178802 | 20230102210313_C9Xhh | UK0033 | 2024-01-05T23:54:02.033Z | 2024-01-05T23:54:02.033Z |
2177830 | 2177830 | 20230102071030_vENBd | UK0033 | 2024-01-05T23:54:01.920Z | 2024-01-05T23:54:01.920Z |
2177806 | 2177806 | 20230102070521_oFy0B | UK0033 | 2024-01-05T23:54:01.918Z | 2024-01-05T23:54:01.918Z |
2177733 | 2177733 | 20230102065059_bmDet | UK0033 | 2024-01-05T23:54:01.911Z | 2024-01-05T23:54:01.911Z |
2177716 | 2177716 | 20230102064403_0dUcB | UK0033 | 2024-01-05T23:54:01.909Z | 2024-01-05T23:54:01.909Z |
2177704 | 2177704 | 20230102064232_EIXz1 | UK0033 | 2024-01-05T23:54:01.908Z | 2024-01-05T23:54:01.908Z |
2177685 | 2177685 | 20230102063711_VghxI | UK0033 | 2024-01-05T23:54:01.906Z | 2024-01-05T23:54:01.906Z |
2177648 | 2177648 | 20230102063440_xsDUj | UK0033 | 2024-01-05T23:54:01.904Z | 2024-01-05T23:54:01.904Z |
2177553 | 2177553 | 20230102062751_sZUGK | UK0033 | 2024-01-05T23:54:01.895Z | 2024-01-05T23:54:01.895Z |
2177454 | 2177454 | 20230102060925_tpKaz | UK0033 | 2024-01-05T23:54:01.887Z | 2024-01-05T23:54:01.887Z |
2177436 | 2177436 | 20230102060650_YDEmg | UK0033 | 2024-01-05T23:54:01.885Z | 2024-01-05T23:54:01.885Z |
2177327 | 2177327 | 20230102054652_1XyNh | UK0033 | 2024-01-05T23:54:01.875Z | 2024-01-05T23:54:01.875Z |
2177308 | 2177308 | 20230102054354_psq2N | UK0033 | 2024-01-05T23:54:01.874Z | 2024-01-05T23:54:01.874Z |
2176505 | 2176505 | 20230102020020_LxChB | UK0033 | 2024-01-05T23:54:01.788Z | 2024-01-05T23:54:01.788Z |
2164508 | 2164508 | 20221227041839_9Cadg | UK0033 | 2024-01-05T23:53:53.469Z | 2024-01-05T23:53:53.469Z |
2163899 | 2163899 | 20221227030923_bFhkv | UK0033 | 2024-01-05T23:53:53.411Z | 2024-01-05T23:53:53.411Z |
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);