participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,851 rows where station_code = "UK006L" 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 |
---|---|---|---|---|---|
5442571 | 5442571 | 20241030015428_Xhofa | UK006L | 2024-11-01T12:20:02.099Z | 2024-11-07T14:26:47.034Z |
5442504 | 5442504 | 20241030014139_Pyv0T | UK006L | 2024-11-01T12:19:55.520Z | 2024-11-07T14:26:46.829Z |
5442488 | 5442488 | 20241030013755_U2R8w | UK006L | 2024-11-01T12:19:54.006Z | 2024-11-07T14:26:46.732Z |
5442381 | 5442381 | 20241030012250_8Y633 | UK006L | 2024-11-01T12:19:45.362Z | 2024-11-07T14:26:46.472Z |
5442172 | 5442172 | 20241030004725_xcHIm | UK006L | 2024-11-01T12:19:31.791Z | 2024-11-07T14:26:45.252Z |
5441512 | 5441512 | 20241029222823_kOgnn | UK006L | 2024-11-01T12:18:42.200Z | 2024-11-07T14:26:42.543Z |
5441383 | 5441383 | 20241029215808_7ebEv | UK006L | 2024-11-01T12:18:30.881Z | 2024-11-07T14:26:41.973Z |
5441262 | 5441262 | 20241029212256_Vo0R7 | UK006L | 2024-11-01T12:18:21.936Z | 2024-11-07T14:26:41.416Z |
5433649 | 5433649 | 20241029203618_4yN3D | UK006L | 2024-10-31T12:22:26.106Z | 2024-11-07T14:26:40.486Z |
5433621 | 5433621 | 20241029203219_4XbNW | UK006L | 2024-10-31T12:22:24.830Z | 2024-11-07T14:26:40.352Z |
5410735 | 5410735 | 20241027053323_lW3XN | UK006L | 2024-10-29T12:18:03.825Z | 2024-11-04T14:29:05.370Z |
5410313 | 5410313 | 20241027050611_2OoEJ | UK006L | 2024-10-29T12:17:52.897Z | 2024-11-04T14:29:04.327Z |
5410033 | 5410033 | 20241027044841_4kzLR | UK006L | 2024-10-29T12:17:46.303Z | 2024-11-04T14:29:03.620Z |
5409930 | 5409930 | 20241027044239_eUWQD | UK006L | 2024-10-29T12:17:44.176Z | 2024-11-04T14:29:02.941Z |
5409666 | 5409666 | 20241027042959_eyu1f | UK006L | 2024-10-29T12:17:36.363Z | 2024-11-04T14:29:02.061Z |
5409578 | 5409578 | 20241027042713_LUPXj | UK006L | 2024-10-29T12:17:31.751Z | 2024-11-04T14:29:01.964Z |
5409559 | 5409559 | 20241027042427_Knc8I | UK006L | 2024-10-29T12:17:30.271Z | 2024-11-04T14:29:01.954Z |
5409079 | 5409079 | 20241027035918_Ss0G2 | UK006L | 2024-10-29T12:17:05.048Z | 2024-11-04T14:29:01.037Z |
5409022 | 5409022 | 20241027035545_CacHo | UK006L | 2024-10-29T12:17:01.736Z | 2024-11-04T14:29:00.940Z |
5409014 | 5409014 | 20241027035431_D2JLe | UK006L | 2024-10-29T12:17:01.422Z | 2024-11-04T14:29:00.936Z |
5408956 | 5408956 | 20241027035107_0eFoe | UK006L | 2024-10-29T12:16:58.101Z | 2024-11-04T14:29:00.868Z |
5408473 | 5408473 | 20241027032805_oUwqC | UK006L | 2024-10-29T12:16:32.322Z | 2024-11-04T14:28:59.554Z |
5408403 | 5408403 | 20241027032534_834Qh | UK006L | 2024-10-29T12:16:26.787Z | 2024-11-04T14:28:59.321Z |
5407923 | 5407923 | 20241027025823_t2lcI | UK006L | 2024-10-29T12:15:53.598Z | 2024-11-04T14:28:58.412Z |
5407914 | 5407914 | 20241027025819_JBq2F | UK006L | 2024-10-29T12:15:52.334Z | 2024-11-04T14:28:58.350Z |
5407813 | 5407813 | 20241027025321_OXV63 | UK006L | 2024-10-29T12:15:44.351Z | 2024-11-04T14:28:58.170Z |
5406815 | 5406815 | 20241027020020_ATnTy | UK006L | 2024-10-29T12:14:44.361Z | 2024-11-04T14:28:56.464Z |
5403720 | 5403720 | 20241026222438_cNPbV | UK006L | 2024-10-29T12:10:09.578Z | 2024-11-04T14:28:49.519Z |
5403629 | 5403629 | 20241026221838_IxpdU | UK006L | 2024-10-29T12:10:03.126Z | 2024-11-04T14:28:49.363Z |
5403174 | 5403174 | 20241026212537_u5XAq | UK006L | 2024-10-29T12:09:10.195Z | 2024-11-04T14:28:47.923Z |
5402703 | 5402703 | 20241026201529_DEP2K | UK006L | 2024-10-29T12:07:58.721Z | 2024-11-04T14:28:46.257Z |
5402535 | 5402535 | 20241026195313_LVKHv | UK006L | 2024-10-29T12:07:34.956Z | 2024-11-04T14:28:45.114Z |
5402386 | 5402386 | 20241026192525_OezW0 | UK006L | 2024-10-29T12:07:07.723Z | 2024-11-04T14:28:44.171Z |
5402239 | 5402239 | 20241026190525_zPSdF | UK006L | 2024-10-29T12:06:43.391Z | 2024-11-04T14:28:43.326Z |
5402005 | 5402005 | 20241026182338_ydLlA | UK006L | 2024-10-29T12:06:03.309Z | 2024-11-04T14:28:41.538Z |
5401856 | 5401856 | 20241026175055_TH2Ez | UK006L | 2024-10-29T12:05:35.110Z | 2024-11-04T14:28:40.325Z |
5399759 | 5399759 | 20241026045955_jisPN | UK006L | 2024-10-28T12:20:10.386Z | 2024-11-03T14:27:40.420Z |
5399524 | 5399524 | 20241026043137_gyN99 | UK006L | 2024-10-28T12:20:01.528Z | 2024-11-03T14:27:39.924Z |
5399425 | 5399425 | 20241026041809_cA3bD | UK006L | 2024-10-28T12:19:59.420Z | 2024-11-03T14:27:39.701Z |
5399135 | 5399135 | 20241026035622_sp3tt | UK006L | 2024-10-28T12:19:49.755Z | 2024-11-03T14:27:39.117Z |
5399070 | 5399070 | 20241026034824_qfmVA | UK006L | 2024-10-28T12:19:47.164Z | 2024-11-03T14:27:38.960Z |
5399001 | 5399001 | 20241026034411_4L5Kh | UK006L | 2024-10-28T12:19:44.002Z | 2024-11-03T14:27:38.857Z |
5398996 | 5398996 | 20241026034411_0wBnx | UK006L | 2024-10-28T12:19:43.957Z | 2024-11-03T14:27:38.856Z |
5398913 | 5398913 | 20241026033718_i44QH | UK006L | 2024-10-28T12:19:40.094Z | 2024-11-03T14:27:38.598Z |
5386124 | 5386124 | 20241025000537_Cq512 | UK006L | 2024-10-27T12:19:51.819Z | 2024-11-02T12:28:30.720Z |
5386102 | 5386102 | 20241025000419_xZt5U | UK006L | 2024-10-27T12:19:50.343Z | 2024-11-02T12:28:30.689Z |
5386056 | 5386056 | 20241024235843_Q5yg6 | UK006L | 2024-10-27T12:19:48.103Z | 2024-11-02T12:28:30.650Z |
5385614 | 5385614 | 20241024230701_C7QsB | UK006L | 2024-10-27T12:19:10.410Z | 2024-11-02T12:28:29.969Z |
5385601 | 5385601 | 20241024230638_5CmbA | UK006L | 2024-10-27T12:19:09.131Z | 2024-11-02T12:28:29.955Z |
5384914 | 5384914 | 20241024211518_Va9SZ | UK006L | 2024-10-27T12:17:58.219Z | 2024-11-02T12:28:28.590Z |
5384441 | 5384441 | 20241024200826_IOL3Z | UK006L | 2024-10-27T12:17:04.595Z | 2024-11-02T12:28:27.199Z |
5384113 | 5384113 | 20241024193725_FmTJ2 | UK006L | 2024-10-27T12:16:47.685Z | 2024-11-02T12:28:26.760Z |
5376326 | 5376326 | 20241024035140_ZaP1s | UK006L | 2024-10-26T12:21:56.829Z | 2024-11-01T12:27:01.501Z |
5376226 | 5376226 | 20241024034600_ZpLqH | UK006L | 2024-10-26T12:21:53.772Z | 2024-11-01T12:27:01.463Z |
5375295 | 5375295 | 20241024030538_9FgdS | UK006L | 2024-10-26T12:21:18.800Z | 2024-11-01T12:27:00.475Z |
5375255 | 5375255 | 20241024030431_3DhCb | UK006L | 2024-10-26T12:21:17.443Z | 2024-11-01T12:27:00.462Z |
5374904 | 5374904 | 20241024024853_lWliO | UK006L | 2024-10-26T12:21:05.626Z | 2024-11-01T12:27:00.033Z |
5374590 | 5374590 | 20241024023607_67m4j | UK006L | 2024-10-26T12:20:54.339Z | 2024-11-01T12:26:59.514Z |
5374225 | 5374225 | 20241024021750_X2we2 | UK006L | 2024-10-26T12:20:41.001Z | 2024-11-01T12:26:58.780Z |
5374128 | 5374128 | 20241024021155_kMemI | UK006L | 2024-10-26T12:20:37.598Z | 2024-11-01T12:26:58.707Z |
5374105 | 5374105 | 20241024021042_HOMDd | UK006L | 2024-10-26T12:20:37.260Z | 2024-11-01T12:26:58.702Z |
5373358 | 5373358 | 20241024013422_30UCm | UK006L | 2024-10-26T12:20:08.815Z | 2024-11-01T12:26:58.233Z |
5373092 | 5373092 | 20241024012325_PAj8G | UK006L | 2024-10-26T12:19:56.812Z | 2024-11-01T12:26:58.129Z |
5372597 | 5372597 | 20241024005702_M2t2U | UK006L | 2024-10-26T12:19:32.598Z | 2024-11-01T12:26:57.743Z |
5372504 | 5372504 | 20241024005211_tPOKk | UK006L | 2024-10-26T12:19:27.739Z | 2024-11-01T12:26:57.495Z |
5372422 | 5372422 | 20241024004706_dydDR | UK006L | 2024-10-26T12:19:23.809Z | 2024-11-01T12:26:57.446Z |
5372371 | 5372371 | 20241024004555_QQJE9 | UK006L | 2024-10-26T12:19:22.584Z | 2024-11-01T12:26:57.421Z |
5366076 | 5366076 | 20241024000404_lcsbA | UK006L | 2024-10-25T12:18:15.883Z | 2024-11-01T12:26:56.739Z |
5365815 | 5365815 | 20241023235018_4DCSI | UK006L | 2024-10-25T12:18:07.984Z | 2024-11-01T12:26:56.439Z |
5365584 | 5365584 | 20241023233844_RptUj | UK006L | 2024-10-25T12:18:01.954Z | 2024-11-01T12:26:56.263Z |
5365538 | 5365538 | 20241023233627_jGoDH | UK006L | 2024-10-25T12:18:00.090Z | 2024-11-01T12:26:56.189Z |
5365531 | 5365531 | 20241023233626_gnTTt | UK006L | 2024-10-25T12:18:00.006Z | 2024-11-01T12:26:56.188Z |
5365417 | 5365417 | 20241023233058_X352t | UK006L | 2024-10-25T12:17:57.553Z | 2024-11-01T12:26:56.086Z |
5365036 | 5365036 | 20241023231114_Ts9Tg | UK006L | 2024-10-25T12:17:44.039Z | 2024-11-01T12:26:55.833Z |
5364823 | 5364823 | 20241023225513_K57i2 | UK006L | 2024-10-25T12:17:36.428Z | 2024-11-01T12:26:55.660Z |
5364765 | 5364765 | 20241023225155_QrlvZ | UK006L | 2024-10-25T12:17:33.291Z | 2024-11-01T12:26:55.612Z |
5364168 | 5364168 | 20241023221129_lpCVC | UK006L | 2024-10-25T12:17:11.154Z | 2024-11-01T12:26:54.593Z |
5363869 | 5363869 | 20241023215420_ZIlOn | UK006L | 2024-10-25T12:16:57.160Z | 2024-11-01T12:26:54.018Z |
5363418 | 5363418 | 20241023210152_WWW2n | UK006L | 2024-10-25T12:16:08.132Z | 2024-11-01T12:26:53.278Z |
5355159 | 5355159 | 20241023031903_cTQir | UK006L | 2024-10-24T12:21:09.334Z | 2024-10-31T12:30:07.359Z |
5355047 | 5355047 | 20241023030701_rfYld | UK006L | 2024-10-24T12:21:01.341Z | 2024-10-31T12:30:07.137Z |
5355028 | 5355028 | 20241023030534_0PDED | UK006L | 2024-10-24T12:21:00.489Z | 2024-10-31T12:30:07.014Z |
5354717 | 5354717 | 20241023024226_DHtHm | UK006L | 2024-10-24T12:20:47.542Z | 2024-10-31T12:30:06.264Z |
5354240 | 5354240 | 20241023021358_2J6NX | UK006L | 2024-10-24T12:20:24.359Z | 2024-10-31T12:30:05.541Z |
5354156 | 5354156 | 20241023020742_7ETNL | UK006L | 2024-10-24T12:20:18.992Z | 2024-10-31T12:30:05.452Z |
5354127 | 5354127 | 20241023020633_Rlp9P | UK006L | 2024-10-24T12:20:17.672Z | 2024-10-31T12:30:05.411Z |
5354079 | 5354079 | 20241023020308_rUaMf | UK006L | 2024-10-24T12:20:13.898Z | 2024-10-31T12:30:05.334Z |
5353881 | 5353881 | 20241023015237_mjsSc | UK006L | 2024-10-24T12:20:00.332Z | 2024-10-31T12:30:05.028Z |
5353683 | 5353683 | 20241023014011_q6ldL | UK006L | 2024-10-24T12:19:53.273Z | 2024-10-31T12:30:04.662Z |
5353406 | 5353406 | 20241023012400_3EFHC | UK006L | 2024-10-24T12:19:41.621Z | 2024-10-31T12:30:04.227Z |
5353123 | 5353123 | 20241023010845_AOj5E | UK006L | 2024-10-24T12:19:32.869Z | 2024-10-31T12:30:03.843Z |
5353017 | 5353017 | 20241023010201_HrdXJ | UK006L | 2024-10-24T12:19:29.387Z | 2024-10-31T12:30:03.680Z |
5352515 | 5352515 | 20241023003708_nejWy | UK006L | 2024-10-24T12:18:54.102Z | 2024-10-31T12:30:02.849Z |
5352015 | 5352015 | 20241023000640_a9waM | UK006L | 2024-10-24T12:18:14.110Z | 2024-10-31T12:30:01.644Z |
5351850 | 5351850 | 20241022235556_MdGgg | UK006L | 2024-10-24T12:18:05.062Z | 2024-10-31T12:30:01.047Z |
5351792 | 5351792 | 20241022235323_qxw4M | UK006L | 2024-10-24T12:17:59.919Z | 2024-10-31T12:30:00.931Z |
5351741 | 5351741 | 20241022235028_GXpqd | UK006L | 2024-10-24T12:17:55.712Z | 2024-10-31T12:30:00.856Z |
5350444 | 5350444 | 20241022215115_EfpSs | UK006L | 2024-10-24T12:15:46.145Z | 2024-10-31T12:29:58.191Z |
5349900 | 5349900 | 20241022204612_3wFUQ | UK006L | 2024-10-24T12:14:47.120Z | 2024-10-31T12:29:56.878Z |
5349502 | 5349502 | 20241022200627_zYj9s | UK006L | 2024-10-24T12:13:52.686Z | 2024-10-31T12:29:55.621Z |
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);