participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,683 rows where station_code = "UK0070" 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 |
---|---|---|---|---|---|
5524610 | 5524610 | 20241111044557_gKkPg | UK0070 | 2024-11-12T14:17:46.005Z | 2024-11-12T14:18:08.703Z |
5524470 | 5524470 | 20241111041812_Prqwa | UK0070 | 2024-11-12T14:17:23.936Z | 2024-11-12T14:18:08.635Z |
5524240 | 5524240 | 20241111033800_wH1B8 | UK0070 | 2024-11-12T14:16:50.203Z | 2024-11-12T14:18:08.526Z |
5524124 | 5524124 | 20241111031710_X3Wml | UK0070 | 2024-11-12T14:16:34.597Z | 2024-11-12T14:18:08.479Z |
5524042 | 5524042 | 20241111030625_4boNY | UK0070 | 2024-11-12T14:16:29.430Z | 2024-11-12T14:18:08.446Z |
5523970 | 5523970 | 20241111025659_GvLrL | UK0070 | 2024-11-12T14:16:22.947Z | 2024-11-12T14:18:08.416Z |
5523957 | 5523957 | 20241111025407_4R3t7 | UK0070 | 2024-11-12T14:16:22.266Z | 2024-11-12T14:18:08.411Z |
5523893 | 5523893 | 20241111024359_CRZFa | UK0070 | 2024-11-12T14:16:19.141Z | 2024-11-12T14:18:08.387Z |
5523786 | 5523786 | 20241111022313_pWOLK | UK0070 | 2024-11-12T14:16:13.127Z | 2024-11-12T14:18:08.343Z |
5523645 | 5523645 | 20241111015955_0ZC3K | UK0070 | 2024-11-12T14:16:05.698Z | 2024-11-12T14:18:08.286Z |
5523634 | 5523634 | 20241111015817_1WpG3 | UK0070 | 2024-11-12T14:16:04.912Z | 2024-11-12T14:18:08.281Z |
5523605 | 5523605 | 20241111015407_714rZ | UK0070 | 2024-11-12T14:16:03.282Z | 2024-11-12T14:18:08.270Z |
5452864 | 5452864 | 20241101050832_ncjNz | UK0070 | 2024-11-02T12:19:30.691Z | 2024-11-09T14:24:35.150Z |
5452846 | 5452846 | 20241101050417_bFtS2 | UK0070 | 2024-11-02T12:19:29.414Z | 2024-11-09T14:24:34.676Z |
5452836 | 5452836 | 20241101050110_SF9oD | UK0070 | 2024-11-02T12:19:28.475Z | 2024-11-09T14:24:34.483Z |
5452825 | 5452825 | 20241101045726_toVX3 | UK0070 | 2024-11-02T12:19:26.336Z | 2024-11-09T14:24:34.346Z |
5452792 | 5452792 | 20241101043827_zeb82 | UK0070 | 2024-11-02T12:19:22.606Z | 2024-11-09T14:24:33.879Z |
5442505 | 5442505 | 20241030014139_Pyv0T | UK0070 | 2024-11-01T12:19:55.520Z | 2024-11-07T14:26:46.829Z |
5442489 | 5442489 | 20241030013755_U2R8w | UK0070 | 2024-11-01T12:19:54.006Z | 2024-11-07T14:26:46.732Z |
5441802 | 5441802 | 20241029233840_bZxyB | UK0070 | 2024-11-01T12:19:02.672Z | 2024-11-07T14:26:43.348Z |
5441513 | 5441513 | 20241029222823_kOgnn | UK0070 | 2024-11-01T12:18:42.200Z | 2024-11-07T14:26:42.543Z |
5441384 | 5441384 | 20241029215808_7ebEv | UK0070 | 2024-11-01T12:18:30.881Z | 2024-11-07T14:26:41.973Z |
5441322 | 5441322 | 20241029214241_BjRJd | UK0070 | 2024-11-01T12:18:26.274Z | 2024-11-07T14:26:41.695Z |
5441263 | 5441263 | 20241029212256_Vo0R7 | UK0070 | 2024-11-01T12:18:21.954Z | 2024-11-07T14:26:41.416Z |
5433610 | 5433610 | 20241029203124_xpST3 | UK0070 | 2024-10-31T12:22:24.367Z | 2024-11-07T14:26:40.316Z |
5433452 | 5433452 | 20241029200007_RdE4V | UK0070 | 2024-10-31T12:22:16.541Z | 2024-11-07T14:26:39.654Z |
5433423 | 5433423 | 20241029195032_XUZ1b | UK0070 | 2024-10-31T12:22:14.160Z | 2024-11-07T14:26:39.315Z |
5433401 | 5433401 | 20241029194104_5AiTr | UK0070 | 2024-10-31T12:22:12.924Z | 2024-11-07T14:26:39.033Z |
5433246 | 5433246 | 20241029183110_ftBjm | UK0070 | 2024-10-31T12:22:01.529Z | 2024-11-07T14:26:37.201Z |
5410461 | 5410461 | 20241027051425_j4kW6 | UK0070 | 2024-10-29T12:17:56.381Z | 2024-11-04T14:29:04.630Z |
5410314 | 5410314 | 20241027050611_2OoEJ | UK0070 | 2024-10-29T12:17:52.897Z | 2024-11-04T14:29:04.327Z |
5410174 | 5410174 | 20241027045834_ZwIQq | UK0070 | 2024-10-29T12:17:49.860Z | 2024-11-04T14:29:03.984Z |
5410168 | 5410168 | 20241027045832_yZY1r | UK0070 | 2024-10-29T12:17:49.746Z | 2024-11-04T14:29:03.980Z |
5409805 | 5409805 | 20241027043623_HzM20 | UK0070 | 2024-10-29T12:17:41.211Z | 2024-11-04T14:29:02.668Z |
5409667 | 5409667 | 20241027042959_eyu1f | UK0070 | 2024-10-29T12:17:36.363Z | 2024-11-04T14:29:02.061Z |
5409636 | 5409636 | 20241027042855_Q2gDK | UK0070 | 2024-10-29T12:17:34.858Z | 2024-11-04T14:29:02.028Z |
5409475 | 5409475 | 20241027042008_j3uvR | UK0070 | 2024-10-29T12:17:25.662Z | 2024-11-04T14:29:01.853Z |
5409408 | 5409408 | 20241027041648_tdCRo | UK0070 | 2024-10-29T12:17:22.141Z | 2024-11-04T14:29:01.651Z |
5409285 | 5409285 | 20241027040919_Btn7I | UK0070 | 2024-10-29T12:17:14.814Z | 2024-11-04T14:29:01.490Z |
5409015 | 5409015 | 20241027035431_D2JLe | UK0070 | 2024-10-29T12:17:01.422Z | 2024-11-04T14:29:00.936Z |
5408797 | 5408797 | 20241027034349_rxYtc | UK0070 | 2024-10-29T12:16:52.701Z | 2024-11-04T14:29:00.554Z |
5408767 | 5408767 | 20241027034250_M3BSv | UK0070 | 2024-10-29T12:16:49.334Z | 2024-11-04T14:29:00.465Z |
5408523 | 5408523 | 20241027032901_tVlBs | UK0070 | 2024-10-29T12:16:34.284Z | 2024-11-04T14:28:59.593Z |
5408357 | 5408357 | 20241027032326_g33z3 | UK0070 | 2024-10-29T12:16:24.794Z | 2024-11-04T14:28:59.284Z |
5408278 | 5408278 | 20241027032105_aDNOt | UK0070 | 2024-10-29T12:16:20.916Z | 2024-11-04T14:28:59.046Z |
5407924 | 5407924 | 20241027025823_t2lcI | UK0070 | 2024-10-29T12:15:53.598Z | 2024-11-04T14:28:58.412Z |
5407556 | 5407556 | 20241027024201_XOabj | UK0070 | 2024-10-29T12:15:29.111Z | 2024-11-04T14:28:57.867Z |
5407489 | 5407489 | 20241027023847_h52k1 | UK0070 | 2024-10-29T12:15:26.760Z | 2024-11-04T14:28:57.768Z |
5406816 | 5406816 | 20241027020020_ATnTy | UK0070 | 2024-10-29T12:14:44.361Z | 2024-11-04T14:28:56.464Z |
5406789 | 5406789 | 20241027015948_VWc9O | UK0070 | 2024-10-29T12:14:42.191Z | 2024-11-04T14:28:56.383Z |
5406747 | 5406747 | 20241027015752_AmhKr | UK0070 | 2024-10-29T12:14:38.965Z | 2024-11-04T14:28:56.335Z |
5404728 | 5404728 | 20241026234925_gxOAe | UK0070 | 2024-10-29T12:11:55.131Z | 2024-11-04T14:28:51.872Z |
5402748 | 5402748 | 20241026201918_PXVF6 | UK0070 | 2024-10-29T12:08:04.947Z | 2024-11-04T14:28:46.433Z |
5402536 | 5402536 | 20241026195313_LVKHv | UK0070 | 2024-10-29T12:07:34.956Z | 2024-11-04T14:28:45.114Z |
5402305 | 5402305 | 20241026191456_5R3ez | UK0070 | 2024-10-29T12:06:58.354Z | 2024-11-04T14:28:43.688Z |
5399857 | 5399857 | 20241026050719_jKinQ | UK0070 | 2024-10-28T12:20:13.621Z | 2024-11-03T14:27:40.619Z |
5399849 | 5399849 | 20241026050708_CXtIs | UK0070 | 2024-10-28T12:20:13.594Z | 2024-11-03T14:27:40.609Z |
5399789 | 5399789 | 20241026050252_s3bXi | UK0070 | 2024-10-28T12:20:11.121Z | 2024-11-03T14:27:40.512Z |
5399760 | 5399760 | 20241026045955_jisPN | UK0070 | 2024-10-28T12:20:10.386Z | 2024-11-03T14:27:40.420Z |
5399651 | 5399651 | 20241026044435_4xxYx | UK0070 | 2024-10-28T12:20:04.685Z | 2024-11-03T14:27:40.168Z |
5399522 | 5399522 | 20241026043116_8BuFI | UK0070 | 2024-10-28T12:20:01.473Z | 2024-11-03T14:27:39.921Z |
5399368 | 5399368 | 20241026041359_otTl4 | UK0070 | 2024-10-28T12:19:56.418Z | 2024-11-03T14:27:39.550Z |
5399195 | 5399195 | 20241026040028_XM5If | UK0070 | 2024-10-28T12:19:50.958Z | 2024-11-03T14:27:39.208Z |
5399188 | 5399188 | 20241026040020_gCgy8 | UK0070 | 2024-10-28T12:19:50.893Z | 2024-11-03T14:27:39.195Z |
5399146 | 5399146 | 20241026035649_k5UEh | UK0070 | 2024-10-28T12:19:49.857Z | 2024-11-03T14:27:39.132Z |
5399082 | 5399082 | 20241026034919_IsFTH | UK0070 | 2024-10-28T12:19:48.143Z | 2024-11-03T14:27:39.008Z |
5399071 | 5399071 | 20241026034824_qfmVA | UK0070 | 2024-10-28T12:19:47.164Z | 2024-11-03T14:27:38.960Z |
5399002 | 5399002 | 20241026034411_4L5Kh | UK0070 | 2024-10-28T12:19:44.002Z | 2024-11-03T14:27:38.857Z |
5398715 | 5398715 | 20241026032144_Fl0F8 | UK0070 | 2024-10-28T12:19:29.484Z | 2024-11-03T14:27:37.888Z |
5398620 | 5398620 | 20241026031143_qHcTn | UK0070 | 2024-10-28T12:19:24.300Z | 2024-11-03T14:27:36.930Z |
5398424 | 5398424 | 20241026025549_Erkmh | UK0070 | 2024-10-28T12:19:16.641Z | 2024-11-03T14:27:36.358Z |
5395767 | 5395767 | 20241025231004_8fh27 | UK0070 | 2024-10-28T12:16:49.280Z | 2024-11-03T14:27:26.681Z |
5395447 | 5395447 | 20241025224353_22kRG | UK0070 | 2024-10-28T12:16:14.786Z | 2024-11-03T14:27:25.562Z |
5395197 | 5395197 | 20241025221933_ropJh | UK0070 | 2024-10-28T12:16:00.811Z | 2024-11-03T14:27:24.188Z |
5386210 | 5386210 | 20241025001402_yT1g3 | UK0070 | 2024-10-27T12:19:55.054Z | 2024-11-02T12:28:30.840Z |
5386103 | 5386103 | 20241025000419_xZt5U | UK0070 | 2024-10-27T12:19:50.343Z | 2024-11-02T12:28:30.689Z |
5385829 | 5385829 | 20241024233437_a1VlT | UK0070 | 2024-10-27T12:19:27.112Z | 2024-11-02T12:28:30.293Z |
5385760 | 5385760 | 20241024232619_2Ds34 | UK0070 | 2024-10-27T12:19:21.683Z | 2024-11-02T12:28:30.154Z |
5385724 | 5385724 | 20241024232141_Oi2Zp | UK0070 | 2024-10-27T12:19:19.731Z | 2024-11-02T12:28:30.103Z |
5385346 | 5385346 | 20241024222746_uF1qN | UK0070 | 2024-10-27T12:18:46.692Z | 2024-11-02T12:28:29.654Z |
5384964 | 5384964 | 20241024212517_03Ftp | UK0070 | 2024-10-27T12:18:04.429Z | 2024-11-02T12:28:28.796Z |
5384922 | 5384922 | 20241024211616_W44bK | UK0070 | 2024-10-27T12:17:58.882Z | 2024-11-02T12:28:28.703Z |
5384915 | 5384915 | 20241024211518_Va9SZ | UK0070 | 2024-10-27T12:17:58.220Z | 2024-11-02T12:28:28.590Z |
5384366 | 5384366 | 20241024200000_PUGe7 | UK0070 | 2024-10-27T12:16:59.064Z | 2024-11-02T12:28:26.999Z |
5374757 | 5374757 | 20241024024251_GwRNA | UK0070 | 2024-10-26T12:21:00.501Z | 2024-11-01T12:26:59.563Z |
5374722 | 5374722 | 20241024024125_UT62c | UK0070 | 2024-10-26T12:20:59.916Z | 2024-11-01T12:26:59.554Z |
5374669 | 5374669 | 20241024023937_x38BO | UK0070 | 2024-10-26T12:20:56.471Z | 2024-11-01T12:26:59.530Z |
5374164 | 5374164 | 20241024021412_Rwbp5 | UK0070 | 2024-10-26T12:20:38.205Z | 2024-11-01T12:26:58.716Z |
5374059 | 5374059 | 20241024020802_kNfyV | UK0070 | 2024-10-26T12:20:35.665Z | 2024-11-01T12:26:58.683Z |
5373843 | 5373843 | 20241024015618_iuwAa | UK0070 | 2024-10-26T12:20:27.724Z | 2024-11-01T12:26:58.518Z |
5373673 | 5373673 | 20241024014923_lraWd | UK0070 | 2024-10-26T12:20:20.688Z | 2024-11-01T12:26:58.362Z |
5371926 | 5371926 | 20241024002326_Oi3y0 | UK0070 | 2024-10-26T12:18:58.598Z | 2024-11-01T12:26:57.002Z |
5366077 | 5366077 | 20241024000404_lcsbA | UK0070 | 2024-10-25T12:18:15.883Z | 2024-11-01T12:26:56.739Z |
5365585 | 5365585 | 20241023233844_RptUj | UK0070 | 2024-10-25T12:18:01.954Z | 2024-11-01T12:26:56.263Z |
5365532 | 5365532 | 20241023233626_gnTTt | UK0070 | 2024-10-25T12:18:00.006Z | 2024-11-01T12:26:56.188Z |
5365516 | 5365516 | 20241023233557_RJkSf | UK0070 | 2024-10-25T12:17:59.750Z | 2024-11-01T12:26:56.185Z |
5365418 | 5365418 | 20241023233058_X352t | UK0070 | 2024-10-25T12:17:57.553Z | 2024-11-01T12:26:56.086Z |
5365154 | 5365154 | 20241023231704_xp8Dq | UK0070 | 2024-10-25T12:17:47.940Z | 2024-11-01T12:26:55.899Z |
5363870 | 5363870 | 20241023215420_ZIlOn | UK0070 | 2024-10-25T12:16:57.160Z | 2024-11-01T12:26:54.018Z |
5355996 | 5355996 | 20241023044832_GU1gi | UK0070 | 2024-10-24T12:21:46.501Z | 2024-10-31T12:30:09.470Z |
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);