participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
657 rows where station_code = "UK008R" 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 |
---|---|---|---|---|---|
5131751 | 5131751 | 20240915210151_Sr0y2 | UK008R | 2024-09-19T12:15:19.358Z | 2024-09-19T12:15:19.358Z |
5131663 | 5131663 | 20240915204248_C1soO | UK008R | 2024-09-19T12:15:13.133Z | 2024-09-19T12:15:13.133Z |
5129579 | 5129579 | 20240917041057_tYJFJ | UK008R | 2024-09-19T12:11:50.066Z | 2024-09-19T12:11:50.066Z |
5129556 | 5129556 | 20240917040933_iY0nJ | UK008R | 2024-09-19T12:11:48.950Z | 2024-09-19T12:11:48.950Z |
5125128 | 5125128 | 20240918002313_H3bmi | UK008R | 2024-09-19T12:02:21.960Z | 2024-09-19T12:06:41.980Z |
5125031 | 5125031 | 20240917233909_ymj8R | UK008R | 2024-09-19T12:01:57.860Z | 2024-09-19T12:06:41.963Z |
5111717 | 5111717 | 20240914210533_16Roy | UK008R | 2024-09-18T12:02:12.829Z | 2024-09-19T12:18:33.612Z |
5105418 | 5105418 | 20240913024438_A3Icx | UK008R | 2024-09-17T12:12:14.337Z | 2024-09-19T12:20:44.404Z |
5105251 | 5105251 | 20240913023921_qXE37 | UK008R | 2024-09-17T12:12:06.187Z | 2024-09-19T12:20:44.172Z |
5105204 | 5105204 | 20240913023724_m32ag | UK008R | 2024-09-17T12:12:02.440Z | 2024-09-19T12:20:44.116Z |
5098289 | 5098289 | 20240913012342_xbVDy | UK008R | 2024-09-16T12:17:22.169Z | 2024-09-19T12:20:39.993Z |
5098210 | 5098210 | 20240913012229_VBFfc | UK008R | 2024-09-16T12:17:21.644Z | 2024-09-19T12:20:39.864Z |
5080549 | 5080549 | 20240911041020_8vWd5 | UK008R | 2024-09-15T12:17:06.980Z | 2024-09-19T12:21:43.337Z |
5080474 | 5080474 | 20240911040112_OPIB1 | UK008R | 2024-09-15T12:17:04.590Z | 2024-09-19T12:21:43.299Z |
5078063 | 5078063 | 20240911013727_PoSG8 | UK008R | 2024-09-15T12:15:18.354Z | 2024-09-19T12:21:39.938Z |
5078025 | 5078025 | 20240911013542_KlSCM | UK008R | 2024-09-15T12:15:17.074Z | 2024-09-19T12:21:39.917Z |
5077199 | 5077199 | 20240911003228_gFOeF | UK008R | 2024-09-15T12:14:29.795Z | 2024-09-19T12:21:38.510Z |
5077086 | 5077086 | 20240911002313_RtlB3 | UK008R | 2024-09-15T12:14:22.651Z | 2024-09-19T12:21:38.203Z |
5076767 | 5076767 | 20240911000740_vuM1u | UK008R | 2024-09-15T12:14:01.045Z | 2024-09-19T12:21:37.560Z |
5064931 | 5064931 | 20240910023346_oR88C | UK008R | 2024-09-14T12:16:10.644Z | 2024-09-18T12:15:17.804Z |
5026407 | 5026407 | 20240905032403_0OeEs | UK008R | 2024-09-11T12:12:27.032Z | 2024-09-13T12:19:58.145Z |
5026320 | 5026320 | 20240905030313_cyuW4 | UK008R | 2024-09-11T12:12:16.122Z | 2024-09-13T12:19:57.631Z |
5020863 | 5020863 | 20240905032403_P22v3 | UK008R | 2024-09-10T12:15:05.462Z | 2024-09-10T12:16:55.261Z |
5020774 | 5020774 | 20240905030313_3zRsd | UK008R | 2024-09-10T12:15:00.611Z | 2024-09-10T12:16:55.238Z |
4997870 | 4997870 | 20240903013802_xPa5n | UK008R | 2024-09-08T12:06:54.419Z | 2024-09-11T12:21:09.593Z |
4991904 | 4991904 | 20240901033805_MrSAR | UK008R | 2024-09-07T12:12:37.025Z | 2024-09-09T12:27:30.459Z |
4991849 | 4991849 | 20240901032518_2qWAY | UK008R | 2024-09-07T12:12:32.593Z | 2024-09-09T12:27:24.809Z |
4991043 | 4991043 | 20240901015158_hbts2 | UK008R | 2024-09-07T12:11:31.575Z | 2024-09-09T12:26:58.754Z |
4990569 | 4990569 | 20240901003956_NpvWG | UK008R | 2024-09-07T12:10:47.199Z | 2024-09-09T12:26:23.649Z |
4990536 | 4990536 | 20240901002931_eHkeb | UK008R | 2024-09-07T12:10:44.484Z | 2024-09-09T12:26:22.932Z |
4990324 | 4990324 | 20240901000238_qPXVr | UK008R | 2024-09-07T12:10:20.869Z | 2024-09-09T12:26:16.570Z |
4989904 | 4989904 | 20240831225415_fFbM1 | UK008R | 2024-09-07T12:09:46.714Z | 2024-09-09T12:26:05.630Z |
4946061 | 4946061 | 20240811005603_FXdrv | UK008R | 2024-09-02T12:13:34.398Z | 2024-09-06T12:26:13.430Z |
4945581 | 4945581 | 20240811004814_daxIN | UK008R | 2024-09-02T12:13:20.561Z | 2024-09-06T12:25:59.474Z |
4945248 | 4945248 | 20240811004314_SbD3q | UK008R | 2024-09-02T12:13:13.226Z | 2024-09-06T12:25:50.917Z |
4928524 | 4928524 | 20240810024233_E04Vx | UK008R | 2024-08-31T12:21:25.502Z | 2024-09-02T12:29:12.021Z |
4928120 | 4928120 | 20240810023007_xtYDT | UK008R | 2024-08-31T12:21:11.558Z | 2024-09-02T12:29:01.792Z |
4926351 | 4926351 | 20240810014720_j3VB0 | UK008R | 2024-08-31T12:19:36.407Z | 2024-09-02T12:27:46.377Z |
4923283 | 4923283 | 20240810013746_3VDNa | UK008R | 2024-08-30T12:15:20.989Z | 2024-09-02T12:27:39.894Z |
4922275 | 4922275 | 20240810011343_8GSxU | UK008R | 2024-08-30T12:14:46.372Z | 2024-09-02T12:27:24.935Z |
4922172 | 4922172 | 20240810011114_xNvKc | UK008R | 2024-08-30T12:14:41.689Z | 2024-09-02T12:27:23.447Z |
4921552 | 4921552 | 20240810005743_2ZZDP | UK008R | 2024-08-30T12:14:14.456Z | 2024-09-02T12:27:05.306Z |
4921334 | 4921334 | 20240810005214_Oz30g | UK008R | 2024-08-30T12:14:05.576Z | 2024-09-02T12:26:55.938Z |
4920480 | 4920480 | 20240810003409_FyzXO | UK008R | 2024-08-30T12:13:29.963Z | 2024-09-02T12:26:26.410Z |
4920367 | 4920367 | 20240810003152_odiLr | UK008R | 2024-08-30T12:13:17.299Z | 2024-09-02T12:26:22.104Z |
4919576 | 4919576 | 20240810001454_sXZUW | UK008R | 2024-08-30T12:12:48.944Z | 2024-09-02T12:25:54.089Z |
4919236 | 4919236 | 20240810000723_7TWyy | UK008R | 2024-08-30T12:12:36.088Z | 2024-09-02T12:25:44.371Z |
4918179 | 4918179 | 20240809234714_2sbR5 | UK008R | 2024-08-30T12:11:54.934Z | 2024-09-02T12:25:27.245Z |
4917597 | 4917597 | 20240809233649_EHE2p | UK008R | 2024-08-30T12:11:28.265Z | 2024-09-02T12:25:07.419Z |
4915899 | 4915899 | 20240809230017_9IktF | UK008R | 2024-08-30T12:10:21.541Z | 2024-09-02T12:24:06.693Z |
4915470 | 4915470 | 20240809224850_X5CL0 | UK008R | 2024-08-30T12:09:55.264Z | 2024-09-02T12:23:56.236Z |
4914882 | 4914882 | 20240809223218_I9sZ4 | UK008R | 2024-08-30T12:09:34.585Z | 2024-09-02T12:23:46.851Z |
4901451 | 4901451 | 20240808012745_u4kJJ | UK008R | 2024-08-28T12:18:44.013Z | 2024-08-28T12:18:44.013Z |
4879611 | 4879611 | 20240807005902_mjNbl | UK008R | 2024-08-20T12:12:57.309Z | 2024-08-27T12:14:17.175Z |
4879023 | 4879023 | 20240807004541_52bqo | UK008R | 2024-08-19T12:14:34.580Z | 2024-08-27T12:14:04.145Z |
4877056 | 4877056 | 20240806235348_diiNQ | UK008R | 2024-08-19T12:13:08.536Z | 2024-08-27T12:12:57.571Z |
4876778 | 4876778 | 20240806234721_UCxLm | UK008R | 2024-08-19T12:13:01.322Z | 2024-08-27T12:12:49.658Z |
4824823 | 4824823 | 20240804002203_uyOxT | UK008R | 2024-08-14T12:19:33.682Z | 2024-08-15T12:25:37.728Z |
4824494 | 4824494 | 20240803235714_uXdfz | UK008R | 2024-08-14T12:19:12.838Z | 2024-08-15T12:25:28.540Z |
4823599 | 4823599 | 20240803230120_1JL2v | UK008R | 2024-08-14T12:18:25.112Z | 2024-08-15T12:25:04.455Z |
4823547 | 4823547 | 20240803225730_ylFLj | UK008R | 2024-08-14T12:18:22.407Z | 2024-08-15T12:25:02.245Z |
4823465 | 4823465 | 20240803225203_5X8sT | UK008R | 2024-08-14T12:18:16.921Z | 2024-08-15T12:24:58.578Z |
4806250 | 4806250 | 20240803014218_jqZYp | UK008R | 2024-08-12T12:18:37.809Z | 2024-08-13T12:17:35.029Z |
4771190 | 4771190 | 20240731005925_DYCpH | UK008R | 2024-08-06T12:14:11.800Z | 2024-08-08T12:25:20.137Z |
4770425 | 4770425 | 20240731002414_CYuuS | UK008R | 2024-08-06T12:14:00.210Z | 2024-08-08T12:25:09.947Z |
4761965 | 4761965 | 20240731014231_GwC7J | UK008R | 2024-08-06T12:01:24.385Z | 2024-08-10T12:17:31.556Z |
4761712 | 4761712 | 20240731012908_NNb7m | UK008R | 2024-08-06T12:00:56.327Z | 2024-08-10T12:17:25.842Z |
4761010 | 4761010 | 20240731000207_kYkCI | UK008R | 2024-08-05T12:16:21.489Z | 2024-08-08T12:24:54.515Z |
4760521 | 4760521 | 20240730234212_XK35v | UK008R | 2024-08-05T12:16:02.323Z | 2024-08-08T12:24:37.877Z |
4744972 | 4744972 | 20240730020701_z2IB5 | UK008R | 2024-08-04T12:07:01.927Z | 2024-08-08T12:18:06.255Z |
4744505 | 4744505 | 20240730015121_UMgGL | UK008R | 2024-08-04T12:06:30.865Z | 2024-08-08T12:17:54.235Z |
4716600 | 4716600 | 20240728014357_OqYGP | UK008R | 2024-07-30T12:07:58.034Z | 2024-08-05T12:19:49.229Z |
4716270 | 4716270 | 20240728013328_22oVE | UK008R | 2024-07-30T12:07:20.466Z | 2024-08-05T12:19:47.364Z |
4706244 | 4706244 | 20240727233804_Y5yJ6 | UK008R | 2024-07-29T12:03:04.163Z | 2024-08-05T12:19:33.315Z |
4705895 | 4705895 | 20240727232248_fX9pB | UK008R | 2024-07-29T12:02:30.659Z | 2024-08-05T12:19:31.249Z |
4698613 | 4698613 | 20240727011922_pUIbD | UK008R | 2024-07-28T12:05:50.561Z | 2024-08-04T12:19:16.052Z |
4373015 | 4373015 | 20240521003927_qdffF | UK008R | 2024-05-27T12:05:48.020Z | 2024-05-29T12:13:33.539Z |
4275727 | 4275727 | 20240503005958_icG0H | UK008R | 2024-05-05T12:11:36.630Z | 2024-05-11T12:28:15.313Z |
4256491 | 4256491 | 20240429011831_iUtnA | UK008R | 2024-05-01T12:12:35.945Z | 2024-05-07T12:18:49.794Z |
4247795 | 4247795 | 20240428022443_8126g | UK008R | 2024-04-29T12:09:39.633Z | 2024-05-06T12:21:13.239Z |
4247757 | 4247757 | 20240428015403_9tJkR | UK008R | 2024-04-29T12:09:36.074Z | 2024-05-06T12:21:12.760Z |
4247708 | 4247708 | 20240428011223_YA25X | UK008R | 2024-04-29T12:09:29.868Z | 2024-05-06T12:21:12.354Z |
4239766 | 4239766 | 20240425234805_wz9mJ | UK008R | 2024-04-27T12:07:11.745Z | 2024-05-04T12:21:22.591Z |
4190214 | 4190214 | 20240414234858_Nz00u | UK008R | 2024-04-16T12:03:13.650Z | 2024-04-23T12:24:44.087Z |
4185878 | 4185878 | 20240414022449_6Pp65 | UK008R | 2024-04-15T12:05:22.276Z | 2024-04-22T12:22:23.120Z |
4185527 | 4185527 | 20240414012535_etPM2 | UK008R | 2024-04-15T12:04:36.451Z | 2024-04-22T12:22:19.599Z |
4185441 | 4185441 | 20240414011323_50cHl | UK008R | 2024-04-15T12:04:26.610Z | 2024-04-22T12:22:18.664Z |
4185394 | 4185394 | 20240414010553_6n23A | UK008R | 2024-04-15T12:04:18.194Z | 2024-04-22T12:22:18.073Z |
4179953 | 4179953 | 20240413014414_lFu9t | UK008R | 2024-04-14T12:03:29.230Z | 2024-04-21T12:21:38.788Z |
4179923 | 4179923 | 20240413013144_T2Orl | UK008R | 2024-04-14T12:03:23.808Z | 2024-04-21T12:21:37.966Z |
4179812 | 4179812 | 20240413005651_7KXPG | UK008R | 2024-04-14T12:03:01.117Z | 2024-04-21T12:21:35.050Z |
4179553 | 4179553 | 20240412225720_3N6lO | UK008R | 2024-04-14T12:02:08.157Z | 2024-04-21T12:21:30.743Z |
4179465 | 4179465 | 20240412220909_c8Bnm | UK008R | 2024-04-14T12:01:43.039Z | 2024-04-21T12:21:28.323Z |
4175444 | 4175444 | 20240412022109_7HPf3 | UK008R | 2024-04-13T12:06:00.710Z | 2024-04-20T12:25:28.847Z |
4171447 | 4171447 | 20240410022413_ogtG3 | UK008R | 2024-04-12T12:07:45.850Z | 2024-04-18T12:21:18.127Z |
4171072 | 4171072 | 20240411034824_dHtj5 | UK008R | 2024-04-12T12:04:47.821Z | 2024-04-19T12:13:20.420Z |
4170978 | 4170978 | 20240411030115_pwVNx | UK008R | 2024-04-12T12:04:31.482Z | 2024-04-19T12:13:19.983Z |
4170505 | 4170505 | 20240410224024_2NWiZ | UK008R | 2024-04-12T12:02:46.091Z | 2024-04-19T12:13:18.362Z |
4166743 | 4166743 | 20240410001330_AlfRO | UK008R | 2024-04-11T12:05:59.796Z | 2024-04-18T12:21:11.561Z |
4166724 | 4166724 | 20240410001056_XifW3 | UK008R | 2024-04-11T12:05:57.730Z | 2024-04-18T12:21:11.336Z |
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);