participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,069 rows where station_code = "UK002Y" sorted by created_at descending
This data as json, copyable, CSV (advanced)
Suggested facets: updated_at (date)
Link | rowid | meteor_unique_trajectory_identifier | station_code | created_at ▲ | updated_at |
---|---|---|---|---|---|
5000930 | 5000930 | 20240902030346_i3bo4 | UK002Y | 2024-09-08T12:16:02.721Z | 2024-09-10T12:19:30.681Z |
5000803 | 5000803 | 20240902024734_wDdmL | UK002Y | 2024-09-08T12:15:45.745Z | 2024-09-10T12:19:29.682Z |
5000275 | 5000275 | 20240902015708_rtauo | UK002Y | 2024-09-08T12:15:18.190Z | 2024-09-10T12:19:26.516Z |
5000080 | 5000080 | 20240902013116_aQEu5 | UK002Y | 2024-09-08T12:15:08.365Z | 2024-09-10T12:19:24.880Z |
5000000 | 5000000 | 20240902012235_E1KY1 | UK002Y | 2024-09-08T12:14:55.547Z | 2024-09-10T12:19:24.198Z |
4999903 | 4999903 | 20240902011004_QjNCt | UK002Y | 2024-09-08T12:14:49.810Z | 2024-09-10T12:19:23.953Z |
4999795 | 4999795 | 20240902005852_wZRjV | UK002Y | 2024-09-08T12:14:45.159Z | 2024-09-10T12:19:22.500Z |
4999680 | 4999680 | 20240902004723_djJLo | UK002Y | 2024-09-08T12:14:41.058Z | 2024-09-10T12:19:21.776Z |
4999397 | 4999397 | 20240902001705_nqHeG | UK002Y | 2024-09-08T12:14:17.102Z | 2024-09-10T12:19:18.983Z |
4990054 | 4990054 | 20240831231757_nrIYv | UK002Y | 2024-09-07T12:09:57.204Z | 2024-09-09T12:26:09.539Z |
4988581 | 4988581 | 20240901210842_my113 | UK002Y | 2024-09-07T12:07:42.036Z | 2024-09-10T12:19:14.714Z |
4983401 | 4983401 | 20240812004413_huzix | UK002Y | 2024-09-06T12:15:31.344Z | 2024-09-06T12:15:31.344Z |
4982861 | 4982861 | 20240812003845_PnxZ1 | UK002Y | 2024-09-06T12:15:04.962Z | 2024-09-06T12:15:04.962Z |
4982441 | 4982441 | 20240812003333_vqd0p | UK002Y | 2024-09-06T12:14:50.832Z | 2024-09-06T12:14:50.832Z |
4982355 | 4982355 | 20240812003251_LdkSd | UK002Y | 2024-09-06T12:14:49.987Z | 2024-09-06T12:14:49.987Z |
4981903 | 4981903 | 20240812002811_0vnFA | UK002Y | 2024-09-06T12:14:39.958Z | 2024-09-06T12:14:39.958Z |
4980898 | 4980898 | 20240812001655_bA2WW | UK002Y | 2024-09-06T12:14:23.627Z | 2024-09-06T12:14:23.627Z |
4980880 | 4980880 | 20240812001652_41pqF | UK002Y | 2024-09-06T12:14:22.786Z | 2024-09-06T12:14:22.786Z |
4980843 | 4980843 | 20240812001626_iY4r3 | UK002Y | 2024-09-06T12:14:20.284Z | 2024-09-06T12:14:20.284Z |
4980679 | 4980679 | 20240812001446_C3USk | UK002Y | 2024-09-06T12:14:11.312Z | 2024-09-06T12:14:11.312Z |
4980369 | 4980369 | 20240812001125_0vwox | UK002Y | 2024-09-06T12:13:56.402Z | 2024-09-06T12:13:56.402Z |
4980018 | 4980018 | 20240812000721_cTnKJ | UK002Y | 2024-09-06T12:13:42.512Z | 2024-09-06T12:13:42.512Z |
4979898 | 4979898 | 20240812000558_i1zmv | UK002Y | 2024-09-06T12:13:34.138Z | 2024-09-06T12:13:34.138Z |
4979840 | 4979840 | 20240812000524_hNjLi | UK002Y | 2024-09-06T12:13:31.806Z | 2024-09-06T12:13:31.806Z |
4979463 | 4979463 | 20240812000216_zqGPD | UK002Y | 2024-09-06T12:13:16.914Z | 2024-09-06T12:13:16.914Z |
4978596 | 4978596 | 20240811235244_t1ME3 | UK002Y | 2024-09-06T12:12:36.681Z | 2024-09-06T12:12:36.681Z |
4978536 | 4978536 | 20240811235220_BVEkn | UK002Y | 2024-09-06T12:12:35.740Z | 2024-09-06T12:12:35.740Z |
4977405 | 4977405 | 20240811233912_egTBt | UK002Y | 2024-09-06T12:12:14.631Z | 2024-09-06T12:12:14.631Z |
4977073 | 4977073 | 20240811233559_zXG3e | UK002Y | 2024-09-06T12:12:02.965Z | 2024-09-06T12:12:02.965Z |
4976184 | 4976184 | 20240811232643_cCz2f | UK002Y | 2024-09-06T12:11:15.834Z | 2024-09-06T12:11:15.834Z |
4975438 | 4975438 | 20240811231820_O561R | UK002Y | 2024-09-05T12:11:49.789Z | 2024-09-06T12:10:41.568Z |
4975219 | 4975219 | 20240811231615_3BVik | UK002Y | 2024-09-05T12:11:41.733Z | 2024-09-06T12:10:38.591Z |
4974516 | 4974516 | 20240811230747_3PjIe | UK002Y | 2024-09-05T12:11:25.830Z | 2024-09-06T12:10:27.631Z |
4974001 | 4974001 | 20240811230225_86QiN | UK002Y | 2024-09-05T12:11:16.043Z | 2024-09-06T12:10:14.847Z |
4973379 | 4973379 | 20240811225624_Laf1M | UK002Y | 2024-09-05T12:10:50.294Z | 2024-09-06T12:09:53.692Z |
4972685 | 4972685 | 20240811224922_fmJMa | UK002Y | 2024-09-05T12:10:31.640Z | 2024-09-06T12:09:23.637Z |
4971258 | 4971258 | 20240811223315_NNpr2 | UK002Y | 2024-09-05T12:09:41.682Z | 2024-09-06T12:08:50.990Z |
4970710 | 4970710 | 20240811222807_vhrD5 | UK002Y | 2024-09-05T12:09:31.250Z | 2024-09-06T12:08:44.129Z |
4968289 | 4968289 | 20240811215636_PF0ok | UK002Y | 2024-09-05T12:08:11.876Z | 2024-09-06T12:07:27.642Z |
4967450 | 4967450 | 20240811214450_j4IGT | UK002Y | 2024-09-05T12:07:39.686Z | 2024-09-06T12:07:00.377Z |
4966909 | 4966909 | 20240811213603_OjOjI | UK002Y | 2024-09-05T12:07:23.291Z | 2024-09-06T12:06:50.048Z |
4965893 | 4965893 | 20240811212055_RvOTD | UK002Y | 2024-09-04T12:07:09.507Z | 2024-09-06T12:06:07.897Z |
4965265 | 4965265 | 20240811211136_G3cZr | UK002Y | 2024-09-04T12:06:53.153Z | 2024-09-06T12:05:52.442Z |
4954992 | 4954992 | 20240811032203_nHGds | UK002Y | 2024-09-03T12:18:33.670Z | 2024-09-06T12:29:14.356Z |
4954879 | 4954879 | 20240811031538_kN33Z | UK002Y | 2024-09-03T12:18:24.118Z | 2024-09-06T12:29:10.901Z |
4954775 | 4954775 | 20240811031117_7K7mc | UK002Y | 2024-09-03T12:18:20.302Z | 2024-09-06T12:29:07.895Z |
4954530 | 4954530 | 20240811030345_2Si2e | UK002Y | 2024-09-03T12:18:15.649Z | 2024-09-06T12:29:02.810Z |
4954107 | 4954107 | 20240811025225_KHENt | UK002Y | 2024-09-03T12:18:07.821Z | 2024-09-06T12:28:50.296Z |
4954044 | 4954044 | 20240811025003_7Gwit | UK002Y | 2024-09-03T12:18:06.431Z | 2024-09-06T12:28:47.458Z |
4954013 | 4954013 | 20240811024932_iQq2M | UK002Y | 2024-09-03T12:18:05.654Z | 2024-09-06T12:28:46.374Z |
4953815 | 4953815 | 20240811024641_45AeJ | UK002Y | 2024-09-03T12:18:00.863Z | 2024-09-06T12:28:39.311Z |
4953623 | 4953623 | 20240811024208_YeZLo | UK002Y | 2024-09-03T12:17:51.953Z | 2024-09-06T12:28:33.177Z |
4953573 | 4953573 | 20240811024053_YcNXu | UK002Y | 2024-09-03T12:17:48.902Z | 2024-09-06T12:28:31.020Z |
4953550 | 4953550 | 20240811024035_933s3 | UK002Y | 2024-09-03T12:17:47.056Z | 2024-09-06T12:28:30.251Z |
4953256 | 4953256 | 20240811023505_JqgVw | UK002Y | 2024-09-03T12:17:29.002Z | 2024-09-06T12:28:21.963Z |
4952182 | 4952182 | 20240811021717_uXrcF | UK002Y | 2024-09-03T12:16:51.503Z | 2024-09-06T12:27:53.295Z |
4950764 | 4950764 | 20240811021133_bM8sD | UK002Y | 2024-09-02T12:16:35.652Z | 2024-09-06T12:27:49.413Z |
4950118 | 4950118 | 20240811020102_yhMKm | UK002Y | 2024-09-02T12:16:08.429Z | 2024-09-06T12:27:41.028Z |
4949341 | 4949341 | 20240811014807_l1u0Y | UK002Y | 2024-09-02T12:15:43.312Z | 2024-09-06T12:27:32.154Z |
4948995 | 4948995 | 20240811014352_jLlMF | UK002Y | 2024-09-02T12:15:28.127Z | 2024-09-06T12:27:28.768Z |
4948155 | 4948155 | 20240811012942_yXKaa | UK002Y | 2024-09-02T12:14:56.357Z | 2024-09-06T12:27:10.305Z |
4948127 | 4948127 | 20240811012914_WoHa3 | UK002Y | 2024-09-02T12:14:55.544Z | 2024-09-06T12:27:08.454Z |
4947988 | 4947988 | 20240811012731_9zfDm | UK002Y | 2024-09-02T12:14:52.208Z | 2024-09-06T12:27:06.021Z |
4947590 | 4947590 | 20240811012123_mVV80 | UK002Y | 2024-09-02T12:14:39.711Z | 2024-09-06T12:26:55.568Z |
4947503 | 4947503 | 20240811012011_4Hps3 | UK002Y | 2024-09-02T12:14:35.674Z | 2024-09-06T12:26:54.105Z |
4947397 | 4947397 | 20240811011803_gWgUj | UK002Y | 2024-09-02T12:14:28.778Z | 2024-09-06T12:26:52.368Z |
4947302 | 4947302 | 20240811011626_ZH9qk | UK002Y | 2024-09-02T12:14:24.535Z | 2024-09-06T12:26:50.773Z |
4947239 | 4947239 | 20240811011506_slbJN | UK002Y | 2024-09-02T12:14:20.408Z | 2024-09-06T12:26:47.470Z |
4947092 | 4947092 | 20240811011302_rZx2n | UK002Y | 2024-09-02T12:14:16.295Z | 2024-09-06T12:26:44.474Z |
4946642 | 4946642 | 20240811010402_SkBhy | UK002Y | 2024-09-02T12:14:02.390Z | 2024-09-06T12:26:29.143Z |
4946343 | 4946343 | 20240811005959_h0114 | UK002Y | 2024-09-02T12:13:50.089Z | 2024-09-06T12:26:21.458Z |
4946229 | 4946229 | 20240811005841_s5kHi | UK002Y | 2024-09-02T12:13:43.056Z | 2024-09-06T12:26:18.740Z |
4945845 | 4945845 | 20240811005214_DmSlG | UK002Y | 2024-09-02T12:13:26.832Z | 2024-09-06T12:26:06.730Z |
4945803 | 4945803 | 20240811005142_oYUJy | UK002Y | 2024-09-02T12:13:26.116Z | 2024-09-06T12:26:05.731Z |
4945503 | 4945503 | 20240811004716_JMQ5m | UK002Y | 2024-09-02T12:13:19.214Z | 2024-09-06T12:25:57.393Z |
4945042 | 4945042 | 20240811004014_p4kBJ | UK002Y | 2024-09-02T12:13:07.046Z | 2024-09-06T12:25:45.530Z |
4944760 | 4944760 | 20240811003521_sbylM | UK002Y | 2024-09-02T12:12:45.109Z | 2024-09-06T12:25:35.934Z |
4944225 | 4944225 | 20240811002527_RqsYg | UK002Y | 2024-09-02T12:12:25.531Z | 2024-09-06T12:25:16.146Z |
4943927 | 4943927 | 20240811001938_j49VU | UK002Y | 2024-09-02T12:12:14.739Z | 2024-09-06T12:25:06.472Z |
4943911 | 4943911 | 20240811001906_26Uud | UK002Y | 2024-09-02T12:12:13.958Z | 2024-09-06T12:25:06.111Z |
4943834 | 4943834 | 20240811001758_ZD4qH | UK002Y | 2024-09-02T12:12:10.462Z | 2024-09-06T12:25:04.562Z |
4943709 | 4943709 | 20240811001552_zlWm0 | UK002Y | 2024-09-02T12:12:05.273Z | 2024-09-06T12:25:01.690Z |
4943352 | 4943352 | 20240811001012_gEhgI | UK002Y | 2024-09-02T12:11:48.650Z | 2024-09-06T12:24:46.466Z |
4943218 | 4943218 | 20240811000819_u0F32 | UK002Y | 2024-09-02T12:11:45.000Z | 2024-09-06T12:24:41.454Z |
4942335 | 4942335 | 20240810234942_hdkt1 | UK002Y | 2024-09-02T12:11:09.072Z | 2024-09-06T12:24:13.288Z |
4942238 | 4942238 | 20240810234832_W6aho | UK002Y | 2024-09-02T12:11:06.311Z | 2024-09-06T12:24:10.467Z |
4942111 | 4942111 | 20240810234607_SlMux | UK002Y | 2024-09-02T12:11:02.796Z | 2024-09-06T12:24:07.586Z |
4941756 | 4941756 | 20240810233922_SeRYd | UK002Y | 2024-09-02T12:10:45.546Z | 2024-09-06T12:23:52.901Z |
4940993 | 4940993 | 20240810232406_C745Q | UK002Y | 2024-09-01T12:10:47.955Z | 2024-09-06T12:23:41.957Z |
4940692 | 4940692 | 20240810231730_7PC9Z | UK002Y | 2024-09-01T12:10:40.921Z | 2024-09-06T12:23:38.466Z |
4940652 | 4940652 | 20240810231704_cQAyU | UK002Y | 2024-09-01T12:10:39.750Z | 2024-09-06T12:23:37.842Z |
4940390 | 4940390 | 20240810231108_2Wqns | UK002Y | 2024-09-01T12:10:26.772Z | 2024-09-06T12:23:34.520Z |
4939951 | 4939951 | 20240810230139_FWbN3 | UK002Y | 2024-09-01T12:10:13.963Z | 2024-09-06T12:23:29.414Z |
4939622 | 4939622 | 20240810225137_aMIFV | UK002Y | 2024-09-01T12:09:56.821Z | 2024-09-06T12:23:25.372Z |
4939131 | 4939131 | 20240810223822_0w8XT | UK002Y | 2024-09-01T12:09:38.374Z | 2024-09-06T12:23:14.254Z |
4939103 | 4939103 | 20240810223749_r7WOv | UK002Y | 2024-09-01T12:09:37.606Z | 2024-09-06T12:23:13.697Z |
4938870 | 4938870 | 20240810223114_0TfpW | UK002Y | 2024-09-01T12:09:30.341Z | 2024-09-06T12:23:06.777Z |
4938398 | 4938398 | 20240810221925_JpysN | UK002Y | 2024-09-01T12:09:05.995Z | 2024-09-06T12:22:51.466Z |
4938330 | 4938330 | 20240810221729_42pPg | UK002Y | 2024-09-01T12:09:04.208Z | 2024-09-06T12:22:50.252Z |
4938262 | 4938262 | 20240810221450_AlooF | UK002Y | 2024-09-01T12:09:01.962Z | 2024-09-06T12:22:48.705Z |
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);