participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,160 rows where station_code = "UK0027" 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 |
---|---|---|---|---|---|
4976406 | 4976406 | 20240811233001_3zpPA | UK0027 | 2024-09-06T12:11:31.591Z | 2024-09-06T12:11:31.591Z |
4975821 | 4975821 | 20240811232216_RlBhR | UK0027 | 2024-09-06T12:10:50.202Z | 2024-09-06T12:10:50.202Z |
4974365 | 4974365 | 20240811230622_F5qNH | UK0027 | 2024-09-05T12:11:23.785Z | 2024-09-06T12:10:26.058Z |
4973688 | 4973688 | 20240811225912_XMwIC | UK0027 | 2024-09-05T12:11:06.449Z | 2024-09-06T12:10:03.471Z |
4973571 | 4973571 | 20240811225829_Mbtnw | UK0027 | 2024-09-05T12:10:59.765Z | 2024-09-06T12:10:00.491Z |
4971408 | 4971408 | 20240811223458_TCzj4 | UK0027 | 2024-09-05T12:09:43.685Z | 2024-09-06T12:08:52.744Z |
4971044 | 4971044 | 20240811223128_tSqov | UK0027 | 2024-09-05T12:09:36.416Z | 2024-09-06T12:08:48.298Z |
4971030 | 4971030 | 20240811223123_cI3yR | UK0027 | 2024-09-05T12:09:36.187Z | 2024-09-06T12:08:48.098Z |
4970755 | 4970755 | 20240811222826_XWdqA | UK0027 | 2024-09-05T12:09:31.524Z | 2024-09-06T12:08:44.294Z |
4970313 | 4970313 | 20240811222401_R2CHz | UK0027 | 2024-09-05T12:09:24.341Z | 2024-09-06T12:08:37.111Z |
4970079 | 4970079 | 20240811222042_h3R27 | UK0027 | 2024-09-05T12:09:18.503Z | 2024-09-06T12:08:22.116Z |
4968865 | 4968865 | 20240811220335_4e8Hg | UK0027 | 2024-09-05T12:08:28.955Z | 2024-09-06T12:07:37.882Z |
4968589 | 4968589 | 20240811215959_56aTd | UK0027 | 2024-09-05T12:08:22.879Z | 2024-09-06T12:07:32.888Z |
4966657 | 4966657 | 20240811213205_n0ML4 | UK0027 | 2024-09-04T12:07:31.365Z | 2024-09-06T12:06:37.857Z |
4966632 | 4966632 | 20240811213203_owxUX | UK0027 | 2024-09-04T12:07:31.276Z | 2024-09-06T12:06:37.687Z |
4965908 | 4965908 | 20240811212058_Jlq9E | UK0027 | 2024-09-04T12:07:09.589Z | 2024-09-06T12:06:07.975Z |
4965667 | 4965667 | 20240811211745_vCaWd | UK0027 | 2024-09-04T12:07:05.468Z | 2024-09-06T12:06:01.398Z |
4940667 | 4940667 | 20240810231713_ouS6K | UK0027 | 2024-09-01T12:10:40.186Z | 2024-09-06T12:23:38.111Z |
4939476 | 4939476 | 20240810224809_630PS | UK0027 | 2024-09-01T12:09:49.348Z | 2024-09-06T12:23:23.158Z |
4938908 | 4938908 | 20240810223151_63nk1 | UK0027 | 2024-09-01T12:09:31.107Z | 2024-09-06T12:23:07.594Z |
4937949 | 4937949 | 20240810220633_bC3Uy | UK0027 | 2024-09-01T12:08:46.154Z | 2024-09-06T12:22:38.089Z |
4928617 | 4928617 | 20240810024449_PxfxM | UK0027 | 2024-08-31T12:21:30.819Z | 2024-09-02T12:29:13.523Z |
4928103 | 4928103 | 20240810023004_0cEfF | UK0027 | 2024-08-31T12:21:11.365Z | 2024-09-02T12:29:01.545Z |
4921532 | 4921532 | 20240810005741_uX9rZ | UK0027 | 2024-08-30T12:14:14.165Z | 2024-09-02T12:27:04.867Z |
4918720 | 4918720 | 20240809235727_NIS2k | UK0027 | 2024-08-30T12:12:12.504Z | 2024-09-02T12:25:35.423Z |
4918645 | 4918645 | 20240809235538_bg3m1 | UK0027 | 2024-08-30T12:12:08.265Z | 2024-09-02T12:25:34.471Z |
4917886 | 4917886 | 20240809234311_x91Q5 | UK0027 | 2024-08-30T12:11:39.608Z | 2024-09-02T12:25:20.886Z |
4915713 | 4915713 | 20240809225524_ROjT4 | UK0027 | 2024-08-30T12:10:12.610Z | 2024-09-02T12:24:01.268Z |
4915690 | 4915690 | 20240809225511_r9gBV | UK0027 | 2024-08-30T12:10:12.400Z | 2024-09-02T12:24:01.216Z |
4915509 | 4915509 | 20240809225029_U1af4 | UK0027 | 2024-08-30T12:09:57.569Z | 2024-09-02T12:23:57.007Z |
4915119 | 4915119 | 20240809223938_PrdqT | UK0027 | 2024-08-30T12:09:42.657Z | 2024-09-02T12:23:50.577Z |
4914642 | 4914642 | 20240809222415_ysvWs | UK0027 | 2024-08-30T12:09:19.683Z | 2024-09-02T12:23:39.805Z |
4914341 | 4914341 | 20240809221616_uyZwB | UK0027 | 2024-08-30T12:09:07.882Z | 2024-09-02T12:23:25.291Z |
4903877 | 4903877 | 20240808031854_YrOSD | UK0027 | 2024-08-28T12:19:56.645Z | 2024-08-28T12:19:56.645Z |
4903864 | 4903864 | 20240808031836_3t31i | UK0027 | 2024-08-28T12:19:56.545Z | 2024-08-28T12:19:56.545Z |
4903757 | 4903757 | 20240808031338_ZaMSa | UK0027 | 2024-08-28T12:19:54.666Z | 2024-08-28T12:19:54.666Z |
4903632 | 4903632 | 20240808030706_M9rbR | UK0027 | 2024-08-28T12:19:44.188Z | 2024-08-28T12:19:44.188Z |
4903599 | 4903599 | 20240808030536_R97uk | UK0027 | 2024-08-28T12:19:42.944Z | 2024-08-28T12:19:42.944Z |
4903477 | 4903477 | 20240808025749_ritpr | UK0027 | 2024-08-28T12:19:39.748Z | 2024-08-28T12:19:39.748Z |
4903250 | 4903250 | 20240808024706_XLaVj | UK0027 | 2024-08-28T12:19:33.402Z | 2024-08-28T12:19:33.402Z |
4903220 | 4903220 | 20240808024545_rBz0d | UK0027 | 2024-08-28T12:19:32.546Z | 2024-08-28T12:19:32.546Z |
4903081 | 4903081 | 20240808023931_YVOO1 | UK0027 | 2024-08-28T12:19:29.206Z | 2024-08-28T12:19:29.206Z |
4903039 | 4903039 | 20240808023823_yG0nF | UK0027 | 2024-08-28T12:19:28.563Z | 2024-08-28T12:19:28.563Z |
4903000 | 4903000 | 20240808023745_hrIJN | UK0027 | 2024-08-28T12:19:28.060Z | 2024-08-28T12:19:28.060Z |
4902874 | 4902874 | 20240808023231_JrFyc | UK0027 | 2024-08-28T12:19:25.666Z | 2024-08-28T12:19:25.666Z |
4902825 | 4902825 | 20240808023117_MTd7b | UK0027 | 2024-08-28T12:19:25.090Z | 2024-08-28T12:19:25.090Z |
4902623 | 4902623 | 20240808022119_6SLyQ | UK0027 | 2024-08-28T12:19:21.944Z | 2024-08-28T12:19:21.944Z |
4902551 | 4902551 | 20240808021705_p5dRK | UK0027 | 2024-08-28T12:19:20.553Z | 2024-08-28T12:19:20.553Z |
4902514 | 4902514 | 20240808021612_TAWbh | UK0027 | 2024-08-28T12:19:19.765Z | 2024-08-28T12:19:19.765Z |
4902463 | 4902463 | 20240808021405_1Mn3P | UK0027 | 2024-08-28T12:19:18.518Z | 2024-08-28T12:19:18.518Z |
4902445 | 4902445 | 20240808021320_tcOkH | UK0027 | 2024-08-28T12:19:18.218Z | 2024-08-28T12:19:18.218Z |
4902365 | 4902365 | 20240808021017_rIrO3 | UK0027 | 2024-08-28T12:19:16.494Z | 2024-08-28T12:19:16.494Z |
4902198 | 4902198 | 20240808020212_dtOE2 | UK0027 | 2024-08-28T12:19:08.228Z | 2024-08-28T12:19:08.228Z |
4902123 | 4902123 | 20240808015838_9Q5hy | UK0027 | 2024-08-28T12:19:02.053Z | 2024-08-28T12:19:02.053Z |
4901984 | 4901984 | 20240808015501_DL6nb | UK0027 | 2024-08-28T12:18:59.361Z | 2024-08-28T12:18:59.361Z |
4901929 | 4901929 | 20240808015331_b0H4X | UK0027 | 2024-08-28T12:18:58.147Z | 2024-08-28T12:18:58.147Z |
4901868 | 4901868 | 20240808014956_tGIRf | UK0027 | 2024-08-28T12:18:54.473Z | 2024-08-28T12:18:54.473Z |
4901678 | 4901678 | 20240808014309_xvwc6 | UK0027 | 2024-08-28T12:18:48.930Z | 2024-08-28T12:18:48.930Z |
4901589 | 4901589 | 20240808013902_fNvP6 | UK0027 | 2024-08-28T12:18:47.459Z | 2024-08-28T12:18:47.459Z |
4899127 | 4899127 | 20240807223420_Pq6xZ | UK0027 | 2024-08-28T12:17:11.053Z | 2024-08-28T12:17:11.053Z |
4899072 | 4899072 | 20240807223121_akGV2 | UK0027 | 2024-08-28T12:17:04.164Z | 2024-08-28T12:17:04.164Z |
4898910 | 4898910 | 20240807222015_LIQkE | UK0027 | 2024-08-28T12:16:58.079Z | 2024-08-28T12:16:58.079Z |
4898748 | 4898748 | 20240807220355_8aa01 | UK0027 | 2024-08-28T12:16:49.468Z | 2024-08-28T12:16:49.468Z |
4898728 | 4898728 | 20240807220316_xJemH | UK0027 | 2024-08-28T12:16:48.934Z | 2024-08-28T12:16:48.934Z |
4883215 | 4883215 | 20240807023353_ogT2z | UK0027 | 2024-08-20T12:14:50.784Z | 2024-08-27T12:15:54.098Z |
4883129 | 4883129 | 20240807023136_iJUKY | UK0027 | 2024-08-20T12:14:47.549Z | 2024-08-27T12:15:53.149Z |
4882938 | 4882938 | 20240807022751_pG7MM | UK0027 | 2024-08-20T12:14:44.165Z | 2024-08-27T12:15:51.176Z |
4882695 | 4882695 | 20240807021937_OdNCF | UK0027 | 2024-08-20T12:14:36.648Z | 2024-08-27T12:15:37.967Z |
4882305 | 4882305 | 20240807020711_3z6Wi | UK0027 | 2024-08-20T12:14:28.726Z | 2024-08-27T12:15:28.945Z |
4882033 | 4882033 | 20240807015942_NnqGW | UK0027 | 2024-08-20T12:14:24.764Z | 2024-08-27T12:15:25.537Z |
4881847 | 4881847 | 20240807015504_eoshr | UK0027 | 2024-08-20T12:14:21.721Z | 2024-08-27T12:15:22.824Z |
4881029 | 4881029 | 20240807013502_tiXLZ | UK0027 | 2024-08-20T12:13:43.349Z | 2024-08-27T12:14:59.917Z |
4877751 | 4877751 | 20240807001142_OsWH8 | UK0027 | 2024-08-19T12:13:51.651Z | 2024-08-27T12:13:18.513Z |
4877019 | 4877019 | 20240806235313_sVnqE | UK0027 | 2024-08-19T12:13:08.160Z | 2024-08-27T12:12:57.237Z |
4876868 | 4876868 | 20240806234942_6tTZM | UK0027 | 2024-08-19T12:13:04.329Z | 2024-08-27T12:12:53.938Z |
4876047 | 4876047 | 20240806233049_fY5gw | UK0027 | 2024-08-19T12:12:36.654Z | 2024-08-27T12:12:29.399Z |
4875949 | 4875949 | 20240806232811_Qw23Y | UK0027 | 2024-08-19T12:12:31.721Z | 2024-08-27T12:12:28.086Z |
4874130 | 4874130 | 20240806224248_k1hLp | UK0027 | 2024-08-19T12:11:16.675Z | 2024-08-27T12:11:34.022Z |
4873929 | 4873929 | 20240806223733_vzQ0A | UK0027 | 2024-08-19T12:11:11.245Z | 2024-08-27T12:11:27.221Z |
4873409 | 4873409 | 20240806222134_whb3c | UK0027 | 2024-08-19T12:10:46.874Z | 2024-08-27T12:11:08.373Z |
4873342 | 4873342 | 20240806221925_YXuxL | UK0027 | 2024-08-19T12:10:43.196Z | 2024-08-27T12:11:06.614Z |
4872108 | 4872108 | 20240806213006_n2QX1 | UK0027 | 2024-08-19T12:09:49.195Z | 2024-08-27T12:10:18.045Z |
4872061 | 4872061 | 20240806212755_fg0Yj | UK0027 | 2024-08-19T12:09:47.453Z | 2024-08-27T12:10:16.506Z |
4835485 | 4835485 | 20240805014106_Oih67 | UK0027 | 2024-08-15T12:15:25.548Z | 2024-08-17T12:32:09.229Z |
4835244 | 4835244 | 20240805013133_gKChe | UK0027 | 2024-08-15T12:15:18.461Z | 2024-08-17T12:32:05.123Z |
4835236 | 4835236 | 20240805013132_zWMtQ | UK0027 | 2024-08-15T12:15:18.410Z | 2024-08-17T12:32:05.107Z |
4835150 | 4835150 | 20240805012859_tbahO | UK0027 | 2024-08-15T12:15:16.157Z | 2024-08-17T12:32:04.361Z |
4834416 | 4834416 | 20240805005722_Ur5XN | UK0027 | 2024-08-15T12:14:41.128Z | 2024-08-17T12:31:55.915Z |
4834226 | 4834226 | 20240805004953_b1wDR | UK0027 | 2024-08-15T12:14:35.647Z | 2024-08-17T12:31:52.773Z |
4833390 | 4833390 | 20240805001543_6tHDj | UK0027 | 2024-08-15T12:13:57.321Z | 2024-08-17T12:31:34.749Z |
4833270 | 4833270 | 20240805001239_gJuuD | UK0027 | 2024-08-15T12:13:53.269Z | 2024-08-17T12:31:31.559Z |
4832372 | 4832372 | 20240804232829_UslCF | UK0027 | 2024-08-15T12:12:56.799Z | 2024-08-17T12:31:01.943Z |
4832291 | 4832291 | 20240804232531_LqnUD | UK0027 | 2024-08-15T12:12:52.277Z | 2024-08-17T12:31:00.890Z |
4831278 | 4831278 | 20240804222526_F83PZ | UK0027 | 2024-08-15T12:11:33.939Z | 2024-08-17T12:30:22.964Z |
4823846 | 4823846 | 20240803231858_3tgkF | UK0027 | 2024-08-14T12:18:37.876Z | 2024-08-15T12:25:13.553Z |
4823726 | 4823726 | 20240803231208_4scB0 | UK0027 | 2024-08-14T12:18:32.268Z | 2024-08-15T12:25:09.854Z |
4823695 | 4823695 | 20240803231018_cYhiU | UK0027 | 2024-08-14T12:18:30.179Z | 2024-08-15T12:25:08.055Z |
4822798 | 4822798 | 20240803215019_nByGg | UK0027 | 2024-08-14T12:17:29.825Z | 2024-08-15T12:24:36.871Z |
4797230 | 4797230 | 20240802030816_d0EEy | UK0027 | 2024-08-11T12:16:22.848Z | 2024-08-11T12:16:22.848Z |
4797167 | 4797167 | 20240802025814_Bv4lm | UK0027 | 2024-08-11T12:16:20.005Z | 2024-08-11T12:16:20.005Z |
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);