participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,944 rows where station_code = "UK009X" 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 |
---|---|---|---|---|---|
5571042 | 5571042 | 20241120220312_WEWGf | UK009X | 2024-11-22T14:16:19.626Z | 2024-11-22T14:19:22.028Z |
5570959 | 5570959 | 20241120214510_L7U2r | UK009X | 2024-11-22T14:16:14.289Z | 2024-11-22T14:19:22.014Z |
5570937 | 5570937 | 20241120213513_nQmOG | UK009X | 2024-11-22T14:16:13.059Z | 2024-11-22T14:19:22.009Z |
5570918 | 5570918 | 20241120212848_7f5rS | UK009X | 2024-11-22T14:16:11.888Z | 2024-11-22T14:19:22.004Z |
5570849 | 5570849 | 20241120211447_BufIS | UK009X | 2024-11-22T14:16:09.245Z | 2024-11-22T14:19:21.994Z |
5570786 | 5570786 | 20241120205538_nEafF | UK009X | 2024-11-22T14:16:05.461Z | 2024-11-22T14:19:21.980Z |
5570578 | 5570578 | 20241120201758_3vL8p | UK009X | 2024-11-22T14:15:49.684Z | 2024-11-22T14:19:21.942Z |
5570573 | 5570573 | 20241120201455_6XGSk | UK009X | 2024-11-22T14:15:48.817Z | 2024-11-22T14:19:21.941Z |
5570405 | 5570405 | 20241120193252_DUphZ | UK009X | 2024-11-22T14:15:19.707Z | 2024-11-22T14:19:21.911Z |
5570330 | 5570330 | 20241120191917_DM5DF | UK009X | 2024-11-22T14:15:10.244Z | 2024-11-22T14:19:21.899Z |
5569971 | 5569971 | 20241120181410_o3L1o | UK009X | 2024-11-22T14:14:42.078Z | 2024-11-22T14:19:21.840Z |
5569746 | 5569746 | 20241120171459_3QQkf | UK009X | 2024-11-22T14:14:03.691Z | 2024-11-22T14:19:21.796Z |
5569742 | 5569742 | 20241120171437_25JBB | UK009X | 2024-11-22T14:14:03.175Z | 2024-11-22T14:19:21.796Z |
5565423 | 5565423 | 20241120042433_C2xaF | UK009X | 2024-11-21T14:18:48.609Z | 2024-11-22T14:21:46.617Z |
5564757 | 5564757 | 20241120032508_85llB | UK009X | 2024-11-21T14:18:02.258Z | 2024-11-22T14:21:36.304Z |
5564605 | 5564605 | 20241120031253_qkosb | UK009X | 2024-11-21T14:17:52.426Z | 2024-11-22T14:21:34.019Z |
5564567 | 5564567 | 20241120030951_osvKU | UK009X | 2024-11-21T14:17:49.722Z | 2024-11-22T14:21:33.538Z |
5564270 | 5564270 | 20241120024353_oE1nG | UK009X | 2024-11-21T14:17:23.639Z | 2024-11-22T14:21:29.858Z |
5564091 | 5564091 | 20241120022802_6GTcR | UK009X | 2024-11-21T14:17:08.765Z | 2024-11-22T14:21:26.899Z |
5563660 | 5563660 | 20241120015608_UE65W | UK009X | 2024-11-21T14:16:32.286Z | 2024-11-22T14:21:20.393Z |
5563298 | 5563298 | 20241120011442_i4Per | UK009X | 2024-11-21T14:15:51.805Z | 2024-11-22T14:21:12.545Z |
5563262 | 5563262 | 20241120011253_E45wm | UK009X | 2024-11-21T14:15:48.601Z | 2024-11-22T14:21:11.842Z |
5562891 | 5562891 | 20241120002403_0EGvs | UK009X | 2024-11-21T14:15:26.386Z | 2024-11-22T14:21:05.895Z |
5562811 | 5562811 | 20241120001505_2Vhud | UK009X | 2024-11-21T14:15:23.326Z | 2024-11-22T14:21:05.039Z |
5562751 | 5562751 | 20241120000736_tfowD | UK009X | 2024-11-21T14:15:19.848Z | 2024-11-22T14:21:03.392Z |
5562636 | 5562636 | 20241119235932_FwDVt | UK009X | 2024-11-21T14:15:14.486Z | 2024-11-22T14:21:01.389Z |
5562561 | 5562561 | 20241119235220_5tkYJ | UK009X | 2024-11-21T14:15:08.657Z | 2024-11-22T14:21:00.351Z |
5562431 | 5562431 | 20241119233622_oWshd | UK009X | 2024-11-21T14:14:49.067Z | 2024-11-22T14:20:57.456Z |
5562412 | 5562412 | 20241119233416_5D2o4 | UK009X | 2024-11-21T14:14:47.168Z | 2024-11-22T14:20:57.147Z |
5561387 | 5561387 | 20241119202305_Re2iE | UK009X | 2024-11-21T14:13:12.054Z | 2024-11-22T14:20:34.226Z |
5561292 | 5561292 | 20241119193503_71U1L | UK009X | 2024-11-21T14:13:01.036Z | 2024-11-22T14:20:30.050Z |
5561203 | 5561203 | 20241119190315_fEy3y | UK009X | 2024-11-21T14:12:36.132Z | 2024-11-22T14:20:26.162Z |
5558418 | 5558418 | 20241120060314_22QhC | UK009X | 2024-11-21T14:03:13.513Z | 2024-11-22T14:19:21.226Z |
5558335 | 5558335 | 20241120055637_J45jA | UK009X | 2024-11-21T14:03:03.071Z | 2024-11-22T14:19:21.212Z |
5558259 | 5558259 | 20241120054954_SUK0A | UK009X | 2024-11-21T14:02:52.628Z | 2024-11-22T14:19:21.200Z |
5558143 | 5558143 | 20241120054046_2VdIJ | UK009X | 2024-11-21T14:02:35.908Z | 2024-11-22T14:19:21.184Z |
5557949 | 5557949 | 20241120052450_WNgq4 | UK009X | 2024-11-21T14:02:07.259Z | 2024-11-22T14:19:21.150Z |
5557909 | 5557909 | 20241120052236_GwnrA | UK009X | 2024-11-21T14:02:02.847Z | 2024-11-22T14:19:21.145Z |
5557838 | 5557838 | 20241120051721_wS6c8 | UK009X | 2024-11-21T14:01:53.811Z | 2024-11-22T14:19:21.136Z |
5557751 | 5557751 | 20241120051025_5i2Zl | UK009X | 2024-11-21T14:01:39.363Z | 2024-11-22T14:19:21.122Z |
5557689 | 5557689 | 20241120050451_2LZXa | UK009X | 2024-11-21T14:01:30.810Z | 2024-11-22T14:19:21.112Z |
5557684 | 5557684 | 20241120050450_0csWC | UK009X | 2024-11-21T14:01:30.512Z | 2024-11-22T14:19:21.111Z |
5557589 | 5557589 | 20241120045909_ut2Fp | UK009X | 2024-11-21T14:01:17.183Z | 2024-11-22T14:19:21.096Z |
5557555 | 5557555 | 20241120045644_TX4xS | UK009X | 2024-11-21T14:01:10.181Z | 2024-11-22T14:19:21.090Z |
5557409 | 5557409 | 20241120044403_gbtcp | UK009X | 2024-11-21T14:00:43.795Z | 2024-11-22T14:19:21.064Z |
5557340 | 5557340 | 20241120043939_s6VBt | UK009X | 2024-11-21T14:00:34.235Z | 2024-11-22T14:19:21.055Z |
5557332 | 5557332 | 20241120043934_HcyN3 | UK009X | 2024-11-21T14:00:33.562Z | 2024-11-22T14:19:21.054Z |
5532404 | 5532404 | 20241112051837_2jsja | UK009X | 2024-11-13T14:16:42.683Z | 2024-11-20T14:26:22.712Z |
5532296 | 5532296 | 20241112050358_klfDw | UK009X | 2024-11-13T14:16:34.962Z | 2024-11-20T14:26:21.704Z |
5532227 | 5532227 | 20241112045305_LtPMK | UK009X | 2024-11-13T14:16:28.513Z | 2024-11-20T14:26:21.157Z |
5532182 | 5532182 | 20241112044732_7W4pb | UK009X | 2024-11-13T14:16:25.057Z | 2024-11-20T14:26:20.701Z |
5532146 | 5532146 | 20241112044133_I1sd1 | UK009X | 2024-11-13T14:16:21.999Z | 2024-11-20T14:26:20.269Z |
5532128 | 5532128 | 20241112043915_pK3NG | UK009X | 2024-11-13T14:16:20.319Z | 2024-11-20T14:26:19.004Z |
5532071 | 5532071 | 20241112043421_M6RBh | UK009X | 2024-11-13T14:16:15.125Z | 2024-11-20T14:26:18.346Z |
5531988 | 5531988 | 20241112042519_3bfzU | UK009X | 2024-11-13T14:16:06.805Z | 2024-11-20T14:26:16.798Z |
5531837 | 5531837 | 20241112041146_T8WGv | UK009X | 2024-11-13T14:15:57.497Z | 2024-11-20T14:26:15.008Z |
5531690 | 5531690 | 20241112040005_ItT5h | UK009X | 2024-11-13T14:15:50.803Z | 2024-11-20T14:26:13.469Z |
5531495 | 5531495 | 20241112034353_DB8Q3 | UK009X | 2024-11-13T14:15:42.783Z | 2024-11-20T14:26:11.830Z |
5531407 | 5531407 | 20241112033816_BmM3Q | UK009X | 2024-11-13T14:15:37.913Z | 2024-11-20T14:26:11.157Z |
5531247 | 5531247 | 20241112032517_MOtZC | UK009X | 2024-11-13T14:15:31.493Z | 2024-11-20T14:26:09.472Z |
5531029 | 5531029 | 20241112030741_feUNx | UK009X | 2024-11-13T14:15:04.738Z | 2024-11-20T14:26:06.511Z |
5530962 | 5530962 | 20241112030248_G2ZE8 | UK009X | 2024-11-13T14:14:55.364Z | 2024-11-20T14:26:05.676Z |
5530940 | 5530940 | 20241112030112_UmMcE | UK009X | 2024-11-13T14:14:52.423Z | 2024-11-20T14:26:05.382Z |
5530683 | 5530683 | 20241112023745_kV3Kb | UK009X | 2024-11-13T14:14:27.576Z | 2024-11-20T14:26:02.577Z |
5530495 | 5530495 | 20241112022351_Itng3 | UK009X | 2024-11-13T14:14:18.755Z | 2024-11-20T14:26:00.822Z |
5530364 | 5530364 | 20241112021157_40HCh | UK009X | 2024-11-13T14:14:11.232Z | 2024-11-20T14:25:57.998Z |
5530316 | 5530316 | 20241112020725_fPTJd | UK009X | 2024-11-13T14:14:08.326Z | 2024-11-20T14:25:56.883Z |
5530287 | 5530287 | 20241112020545_lXy0h | UK009X | 2024-11-13T14:14:06.998Z | 2024-11-20T14:25:56.572Z |
5530169 | 5530169 | 20241112015313_GLukE | UK009X | 2024-11-13T14:13:59.695Z | 2024-11-20T14:25:55.076Z |
5530125 | 5530125 | 20241112014805_Jumwk | UK009X | 2024-11-13T14:13:57.762Z | 2024-11-20T14:25:54.704Z |
5529035 | 5529035 | 20241111232117_C4C2i | UK009X | 2024-11-13T14:11:59.377Z | 2024-11-20T14:25:38.866Z |
5528975 | 5528975 | 20241111231428_hCFoY | UK009X | 2024-11-13T14:11:52.084Z | 2024-11-20T14:25:38.160Z |
5528926 | 5528926 | 20241111230750_pSgUc | UK009X | 2024-11-13T14:11:40.519Z | 2024-11-20T14:25:37.478Z |
5528885 | 5528885 | 20241111230042_PtACV | UK009X | 2024-11-13T14:11:35.266Z | 2024-11-20T14:25:36.954Z |
5528705 | 5528705 | 20241111222216_5ZdLE | UK009X | 2024-11-13T14:11:18.524Z | 2024-11-20T14:25:34.046Z |
5528686 | 5528686 | 20241111221721_NtnjA | UK009X | 2024-11-13T14:11:16.572Z | 2024-11-20T14:25:33.644Z |
5528649 | 5528649 | 20241111220506_ierLj | UK009X | 2024-11-13T14:11:12.821Z | 2024-11-20T14:25:33.188Z |
5528478 | 5528478 | 20241111210357_NUDQ3 | UK009X | 2024-11-13T14:10:47.550Z | 2024-11-20T14:25:31.047Z |
5524227 | 5524227 | 20241111033600_jnmbM | UK009X | 2024-11-12T14:16:48.686Z | 2024-11-19T14:22:18.971Z |
5450138 | 5450138 | 20241031180216_JQZvz | UK009X | 2024-11-02T12:14:38.256Z | 2024-11-09T14:24:13.868Z |
5439936 | 5439936 | 20241030205129_85znC | UK009X | 2024-11-01T12:14:39.269Z | 2024-11-08T14:23:06.366Z |
5439922 | 5439922 | 20241030204940_C2ZBS | UK009X | 2024-11-01T12:14:38.340Z | 2024-11-08T14:23:06.154Z |
5439647 | 5439647 | 20241030201626_7c4l2 | UK009X | 2024-11-01T12:14:06.201Z | 2024-11-08T14:23:04.522Z |
5432863 | 5432863 | 20241029050040_xToHS | UK009X | 2024-10-31T12:21:37.025Z | 2024-11-06T14:27:29.037Z |
5432219 | 5432219 | 20241029025525_l1g9X | UK009X | 2024-10-31T12:21:13.218Z | 2024-11-06T14:27:26.262Z |
5432171 | 5432171 | 20241029025202_RtKH8 | UK009X | 2024-10-31T12:21:09.206Z | 2024-11-06T14:27:26.163Z |
5432131 | 5432131 | 20241029024614_J3YN8 | UK009X | 2024-10-31T12:21:04.941Z | 2024-11-06T14:27:26.043Z |
5432082 | 5432082 | 20241029024034_XmGd7 | UK009X | 2024-10-31T12:21:01.761Z | 2024-11-06T14:27:25.949Z |
5431992 | 5431992 | 20241029022804_Yz6ui | UK009X | 2024-10-31T12:20:55.483Z | 2024-11-06T14:27:25.666Z |
5431964 | 5431964 | 20241029022331_FpLSu | UK009X | 2024-10-31T12:20:53.893Z | 2024-11-06T14:27:25.625Z |
5431056 | 5431056 | 20241029002011_PCWyY | UK009X | 2024-10-31T12:19:31.383Z | 2024-11-06T14:27:22.628Z |
5429958 | 5429958 | 20241028203339_CSxt5 | UK009X | 2024-10-31T12:17:17.999Z | 2024-11-06T14:27:18.130Z |
5429902 | 5429902 | 20241028202124_q7N2Y | UK009X | 2024-10-31T12:17:12.240Z | 2024-11-06T14:27:18.015Z |
5423063 | 5423063 | 20241026015012_Pkuv1 | UK009X | 2024-10-30T12:24:15.941Z | 2024-11-03T14:27:33.846Z |
5423030 | 5423030 | 20241025232609_Dzovd | UK009X | 2024-10-30T12:24:08.451Z | 2024-11-03T14:27:27.775Z |
5418447 | 5418447 | 20241027205006_i2C22 | UK009X | 2024-10-30T12:15:42.262Z | 2024-11-05T14:27:10.045Z |
5417698 | 5417698 | 20241027190231_u4h2Z | UK009X | 2024-10-30T12:14:14.117Z | 2024-11-05T14:27:08.086Z |
5410744 | 5410744 | 20241027053338_M6zDp | UK009X | 2024-10-29T12:18:04.018Z | 2024-11-04T14:29:05.375Z |
5410645 | 5410645 | 20241027052531_2yEQL | UK009X | 2024-10-29T12:18:01.853Z | 2024-11-04T14:29:05.187Z |
5410538 | 5410538 | 20241027051649_kMZ98 | UK009X | 2024-10-29T12:17:57.728Z | 2024-11-04T14:29:04.736Z |
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);