participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,680 rows where station_code = "UK006A" 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 |
---|---|---|---|---|---|
4981522 | 4981522 | 20240812002312_oXaMJ | UK006A | 2024-09-06T12:14:32.972Z | 2024-09-06T12:14:32.972Z |
4981145 | 4981145 | 20240812001900_xzS3S | UK006A | 2024-09-06T12:14:26.935Z | 2024-09-06T12:14:26.935Z |
4979686 | 4979686 | 20240812000338_E4dDH | UK006A | 2024-09-06T12:13:22.536Z | 2024-09-06T12:13:22.536Z |
4967038 | 4967038 | 20240811213814_xsYDO | UK006A | 2024-09-05T12:07:28.966Z | 2024-09-06T12:06:52.207Z |
4965835 | 4965835 | 20240811212021_2roik | UK006A | 2024-09-04T12:07:08.933Z | 2024-09-06T12:06:07.310Z |
4954972 | 4954972 | 20240811032026_3M83Q | UK006A | 2024-09-03T12:18:31.454Z | 2024-09-06T12:29:13.527Z |
4954932 | 4954932 | 20240811031715_f7uFJ | UK006A | 2024-09-03T12:18:27.731Z | 2024-09-06T12:29:12.638Z |
4954910 | 4954910 | 20240811031620_ceuwN | UK006A | 2024-09-03T12:18:25.563Z | 2024-09-06T12:29:11.559Z |
4954869 | 4954869 | 20240811031322_olvjF | UK006A | 2024-09-03T12:18:23.445Z | 2024-09-06T12:29:10.761Z |
4954831 | 4954831 | 20240811031223_vUbpq | UK006A | 2024-09-03T12:18:21.265Z | 2024-09-06T12:29:09.879Z |
4954719 | 4954719 | 20240811030929_xaHqk | UK006A | 2024-09-03T12:18:19.473Z | 2024-09-06T12:29:06.961Z |
4954648 | 4954648 | 20240811030750_f2m33 | UK006A | 2024-09-03T12:18:18.573Z | 2024-09-06T12:29:05.895Z |
4954610 | 4954610 | 20240811030610_CLwBQ | UK006A | 2024-09-03T12:18:17.666Z | 2024-09-06T12:29:04.850Z |
4954548 | 4954548 | 20240811030427_5rRQd | UK006A | 2024-09-03T12:18:16.305Z | 2024-09-06T12:29:03.152Z |
4954498 | 4954498 | 20240811030313_JLQZK | UK006A | 2024-09-03T12:18:14.690Z | 2024-09-06T12:29:01.825Z |
4954160 | 4954160 | 20240811025308_370z3 | UK006A | 2024-09-03T12:18:08.573Z | 2024-09-06T12:28:51.840Z |
4953676 | 4953676 | 20240811024254_ZcJc1 | UK006A | 2024-09-03T12:17:53.398Z | 2024-09-06T12:28:34.316Z |
4953664 | 4953664 | 20240811024240_FD3tD | UK006A | 2024-09-03T12:17:53.231Z | 2024-09-06T12:28:34.293Z |
4952916 | 4952916 | 20240811022850_0iS2Z | UK006A | 2024-09-03T12:17:09.059Z | 2024-09-06T12:28:12.475Z |
4952741 | 4952741 | 20240811022639_3mPQD | UK006A | 2024-09-03T12:17:04.961Z | 2024-09-06T12:28:07.800Z |
4952053 | 4952053 | 20240811021514_cDlDb | UK006A | 2024-09-03T12:16:43.720Z | 2024-09-06T12:27:52.089Z |
4950320 | 4950320 | 20240811020513_vP9ze | UK006A | 2024-09-02T12:16:22.046Z | 2024-09-06T12:27:43.196Z |
4949945 | 4949945 | 20240811015814_tzC33 | UK006A | 2024-09-02T12:16:00.650Z | 2024-09-06T12:27:39.142Z |
4949758 | 4949758 | 20240811015503_3iBVz | UK006A | 2024-09-02T12:15:53.852Z | 2024-09-06T12:27:37.230Z |
4949555 | 4949555 | 20240811015147_PhIcr | UK006A | 2024-09-02T12:15:49.165Z | 2024-09-06T12:27:34.871Z |
4949528 | 4949528 | 20240811015133_BISAa | UK006A | 2024-09-02T12:15:48.303Z | 2024-09-06T12:27:34.397Z |
4949459 | 4949459 | 20240811015011_nHkBM | UK006A | 2024-09-02T12:15:46.465Z | 2024-09-06T12:27:33.496Z |
4949211 | 4949211 | 20240811014633_1OBJZ | UK006A | 2024-09-02T12:15:40.399Z | 2024-09-06T12:27:30.710Z |
4945636 | 4945636 | 20240811004857_7u9a2 | UK006A | 2024-09-02T12:13:21.571Z | 2024-09-06T12:26:00.243Z |
4945093 | 4945093 | 20240811004106_ZS9Ps | UK006A | 2024-09-02T12:13:09.452Z | 2024-09-06T12:25:46.652Z |
4921241 | 4921241 | 20240810005017_4t2XU | UK006A | 2024-08-30T12:14:00.644Z | 2024-09-02T12:26:54.297Z |
4903727 | 4903727 | 20240808031202_OtHtF | UK006A | 2024-08-28T12:19:50.634Z | 2024-08-28T12:19:50.634Z |
4903592 | 4903592 | 20240808030531_tz3lz | UK006A | 2024-08-28T12:19:42.410Z | 2024-08-28T12:19:42.410Z |
4903405 | 4903405 | 20240808025415_yR32o | UK006A | 2024-08-28T12:19:38.391Z | 2024-08-28T12:19:38.391Z |
4903087 | 4903087 | 20240808023931_YVOO1 | UK006A | 2024-08-28T12:19:29.206Z | 2024-08-28T12:19:29.206Z |
4903021 | 4903021 | 20240808023752_YmpoE | UK006A | 2024-08-28T12:19:28.145Z | 2024-08-28T12:19:28.145Z |
4902924 | 4902924 | 20240808023442_hkMcP | UK006A | 2024-08-28T12:19:26.259Z | 2024-08-28T12:19:26.259Z |
4902831 | 4902831 | 20240808023117_MTd7b | UK006A | 2024-08-28T12:19:25.090Z | 2024-08-28T12:19:25.090Z |
4902746 | 4902746 | 20240808022656_qR7eG | UK006A | 2024-08-28T12:19:23.796Z | 2024-08-28T12:19:23.796Z |
4902661 | 4902661 | 20240808022240_7dYAz | UK006A | 2024-08-28T12:19:22.532Z | 2024-08-28T12:19:22.532Z |
4902601 | 4902601 | 20240808021916_iUXg1 | UK006A | 2024-08-28T12:19:21.483Z | 2024-08-28T12:19:21.483Z |
4902557 | 4902557 | 20240808021705_p5dRK | UK006A | 2024-08-28T12:19:20.553Z | 2024-08-28T12:19:20.553Z |
4902449 | 4902449 | 20240808021320_tcOkH | UK006A | 2024-08-28T12:19:18.218Z | 2024-08-28T12:19:18.218Z |
4902147 | 4902147 | 20240808020021_rh2ml | UK006A | 2024-08-28T12:19:04.652Z | 2024-08-28T12:19:04.652Z |
4902000 | 4902000 | 20240808015525_2BNVU | UK006A | 2024-08-28T12:18:59.629Z | 2024-08-28T12:18:59.629Z |
4901873 | 4901873 | 20240808014956_tGIRf | UK006A | 2024-08-28T12:18:54.473Z | 2024-08-28T12:18:54.473Z |
4901830 | 4901830 | 20240808014858_uH2uk | UK006A | 2024-08-28T12:18:52.873Z | 2024-08-28T12:18:52.873Z |
4901651 | 4901651 | 20240808014203_uJpsd | UK006A | 2024-08-28T12:18:48.393Z | 2024-08-28T12:18:48.393Z |
4901595 | 4901595 | 20240808013902_fNvP6 | UK006A | 2024-08-28T12:18:47.459Z | 2024-08-28T12:18:47.459Z |
4901390 | 4901390 | 20240808012632_s93XF | UK006A | 2024-08-28T12:18:43.152Z | 2024-08-28T12:18:43.152Z |
4882130 | 4882130 | 20240807020209_v2jvK | UK006A | 2024-08-20T12:14:25.476Z | 2024-08-27T12:15:26.136Z |
4881936 | 4881936 | 20240807015646_jY6tc | UK006A | 2024-08-20T12:14:23.175Z | 2024-08-27T12:15:24.155Z |
4881783 | 4881783 | 20240807015303_3JYJe | UK006A | 2024-08-20T12:14:20.170Z | 2024-08-27T12:15:21.381Z |
4881391 | 4881391 | 20240807014412_cqDFh | UK006A | 2024-08-20T12:14:05.353Z | 2024-08-27T12:15:12.357Z |
4881192 | 4881192 | 20240807014000_C2mFc | UK006A | 2024-08-20T12:13:52.276Z | 2024-08-27T12:15:04.037Z |
4881033 | 4881033 | 20240807013502_tiXLZ | UK006A | 2024-08-20T12:13:43.350Z | 2024-08-27T12:14:59.917Z |
4880608 | 4880608 | 20240807012505_5saYF | UK006A | 2024-08-20T12:13:30.651Z | 2024-08-27T12:14:47.699Z |
4880235 | 4880235 | 20240807011521_2JLcV | UK006A | 2024-08-20T12:13:21.051Z | 2024-08-27T12:14:38.348Z |
4879253 | 4879253 | 20240807004909_Iqlwt | UK006A | 2024-08-20T12:12:46.395Z | 2024-08-27T12:14:08.426Z |
4879081 | 4879081 | 20240807004648_vGNdo | UK006A | 2024-08-19T12:14:39.570Z | 2024-08-27T12:14:06.147Z |
4878307 | 4878307 | 20240807002508_NcC07 | UK006A | 2024-08-19T12:14:08.766Z | 2024-08-27T12:13:39.547Z |
4878210 | 4878210 | 20240807002216_wOPH0 | UK006A | 2024-08-19T12:14:06.840Z | 2024-08-27T12:13:37.721Z |
4877337 | 4877337 | 20240807000008_iozLO | UK006A | 2024-08-19T12:13:18.618Z | 2024-08-27T12:13:09.020Z |
4877311 | 4877311 | 20240806235931_XHDfZ | UK006A | 2024-08-19T12:13:17.923Z | 2024-08-27T12:13:08.478Z |
4875998 | 4875998 | 20240806232822_ZX12R | UK006A | 2024-08-19T12:12:32.764Z | 2024-08-27T12:12:28.283Z |
4874722 | 4874722 | 20240806225545_g8Gsa | UK006A | 2024-08-19T12:11:43.444Z | 2024-08-27T12:11:51.791Z |
4874524 | 4874524 | 20240806225116_Q5Rbb | UK006A | 2024-08-19T12:11:28.881Z | 2024-08-27T12:11:47.146Z |
4874510 | 4874510 | 20240806225116_yvdO0 | UK006A | 2024-08-19T12:11:28.803Z | 2024-08-27T12:11:47.049Z |
4873937 | 4873937 | 20240806223733_vzQ0A | UK006A | 2024-08-19T12:11:11.245Z | 2024-08-27T12:11:27.221Z |
4873612 | 4873612 | 20240806222603_6yVIF | UK006A | 2024-08-19T12:10:57.206Z | 2024-08-27T12:11:16.947Z |
4873418 | 4873418 | 20240806222134_whb3c | UK006A | 2024-08-19T12:10:46.874Z | 2024-08-27T12:11:08.373Z |
4873296 | 4873296 | 20240806221747_WCuyR | UK006A | 2024-08-19T12:10:41.848Z | 2024-08-27T12:11:05.544Z |
4873173 | 4873173 | 20240806221425_t76n3 | UK006A | 2024-08-19T12:10:37.934Z | 2024-08-27T12:10:59.797Z |
4872667 | 4872667 | 20240806215451_OR5D2 | UK006A | 2024-08-19T12:10:12.524Z | 2024-08-27T12:10:44.824Z |
4871943 | 4871943 | 20240806212038_RI4Wt | UK006A | 2024-08-19T12:09:33.132Z | 2024-08-27T12:10:11.314Z |
4871819 | 4871819 | 20240806211401_7WOH6 | UK006A | 2024-08-19T12:09:28.051Z | 2024-08-27T12:10:04.718Z |
4835629 | 4835629 | 20240805014659_odyAo | UK006A | 2024-08-15T12:15:33.351Z | 2024-08-17T12:32:14.243Z |
4835473 | 4835473 | 20240805014022_bYs5B | UK006A | 2024-08-15T12:15:25.287Z | 2024-08-17T12:32:08.993Z |
4785007 | 4785007 | 20240801235626_TZadj | UK006A | 2024-08-10T12:15:40.184Z | 2024-08-11T12:14:39.588Z |
4784848 | 4784848 | 20240801234943_TKxH7 | UK006A | 2024-08-10T12:15:29.779Z | 2024-08-11T12:14:37.559Z |
4771259 | 4771259 | 20240731010139_TRWi9 | UK006A | 2024-08-06T12:14:12.608Z | 2024-08-08T12:25:20.925Z |
4771102 | 4771102 | 20240731005606_Lzjwf | UK006A | 2024-08-06T12:14:10.035Z | 2024-08-08T12:25:18.802Z |
4770905 | 4770905 | 20240731004638_U9XvZ | UK006A | 2024-08-06T12:14:05.688Z | 2024-08-08T12:25:16.318Z |
4770835 | 4770835 | 20240731004244_dUSy4 | UK006A | 2024-08-06T12:14:04.902Z | 2024-08-08T12:25:15.628Z |
4770676 | 4770676 | 20240731003435_FM2a8 | UK006A | 2024-08-06T12:14:03.364Z | 2024-08-08T12:25:14.005Z |
4770348 | 4770348 | 20240731001930_b3Rtt | UK006A | 2024-08-06T12:13:58.362Z | 2024-08-08T12:25:07.374Z |
4762700 | 4762700 | 20240731022823_70orh | UK006A | 2024-08-06T12:02:59.246Z | 2024-08-10T12:17:53.286Z |
4761839 | 4761839 | 20240731013429_8GPA3 | UK006A | 2024-08-06T12:01:08.718Z | 2024-08-10T12:17:27.981Z |
4761753 | 4761753 | 20240731013101_2OcdG | UK006A | 2024-08-06T12:01:00.177Z | 2024-08-10T12:17:26.672Z |
4761661 | 4761661 | 20240731012555_RWKmk | UK006A | 2024-08-06T12:00:47.625Z | 2024-08-10T12:17:23.248Z |
4761174 | 4761174 | 20240731000941_E6ieT | UK006A | 2024-08-05T12:16:27.310Z | 2024-08-08T12:24:59.954Z |
4760973 | 4760973 | 20240731000040_J82p5 | UK006A | 2024-08-05T12:16:20.563Z | 2024-08-08T12:24:53.686Z |
4760145 | 4760145 | 20240730232615_YZ5nB | UK006A | 2024-08-05T12:15:49.137Z | 2024-08-08T12:24:26.887Z |
4760045 | 4760045 | 20240730232215_2jD3g | UK006A | 2024-08-05T12:15:46.592Z | 2024-08-08T12:24:24.168Z |
4759504 | 4759504 | 20240730225254_21Z6p | UK006A | 2024-08-05T12:15:27.572Z | 2024-08-08T12:24:04.069Z |
4759457 | 4759457 | 20240730225158_2NAjr | UK006A | 2024-08-05T12:15:26.615Z | 2024-08-08T12:24:03.735Z |
4746092 | 4746092 | 20240730025222_bc420 | UK006A | 2024-08-04T12:08:09.792Z | 2024-08-08T12:18:28.889Z |
4745993 | 4745993 | 20240730024537_7Z4gU | UK006A | 2024-08-04T12:08:06.347Z | 2024-08-08T12:18:26.624Z |
4745937 | 4745937 | 20240730024324_yX5mf | UK006A | 2024-08-04T12:08:04.654Z | 2024-08-08T12:18:24.280Z |
4745859 | 4745859 | 20240730023833_4wpWH | UK006A | 2024-08-04T12:08:01.771Z | 2024-08-08T12:18:22.748Z |
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);