participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,315 rows where station_code = "UK0087" 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 |
---|---|---|---|---|---|
5423081 | 5423081 | 20241026034134_v9JPh | UK0087 | 2024-10-30T12:24:20.536Z | 2024-11-03T14:27:38.740Z |
5404784 | 5404784 | 20241026235232_SMQBs | UK0087 | 2024-10-29T12:11:57.674Z | 2024-11-04T14:28:51.938Z |
5404447 | 5404447 | 20241026232650_31hau | UK0087 | 2024-10-29T12:11:27.911Z | 2024-11-04T14:28:51.056Z |
5404266 | 5404266 | 20241026231306_OAwVo | UK0087 | 2024-10-29T12:11:03.760Z | 2024-11-04T14:28:50.560Z |
5404171 | 5404171 | 20241026230351_UeIko | UK0087 | 2024-10-29T12:10:57.482Z | 2024-11-04T14:28:50.393Z |
5403750 | 5403750 | 20241026222751_Myfx3 | UK0087 | 2024-10-29T12:10:11.428Z | 2024-11-04T14:28:49.541Z |
5403735 | 5403735 | 20241026222636_tlNb2 | UK0087 | 2024-10-29T12:10:10.593Z | 2024-11-04T14:28:49.527Z |
5403721 | 5403721 | 20241026222438_cNPbV | UK0087 | 2024-10-29T12:10:09.578Z | 2024-11-04T14:28:49.519Z |
5403239 | 5403239 | 20241026213115_8ypVe | UK0087 | 2024-10-29T12:09:14.918Z | 2024-11-04T14:28:47.992Z |
5403175 | 5403175 | 20241026212537_u5XAq | UK0087 | 2024-10-29T12:09:10.195Z | 2024-11-04T14:28:47.923Z |
5403045 | 5403045 | 20241026210855_8qLR2 | UK0087 | 2024-10-29T12:08:48.384Z | 2024-11-04T14:28:47.607Z |
5402732 | 5402732 | 20241026201716_i6UHU | UK0087 | 2024-10-29T12:08:01.483Z | 2024-11-04T14:28:46.384Z |
5402379 | 5402379 | 20241026192444_MS5ox | UK0087 | 2024-10-29T12:07:07.030Z | 2024-11-04T14:28:44.163Z |
5399568 | 5399568 | 20241026043500_C44VJ | UK0087 | 2024-10-28T12:20:02.615Z | 2024-11-03T14:27:39.991Z |
5399528 | 5399528 | 20241026043202_7qIIt | UK0087 | 2024-10-28T12:20:01.577Z | 2024-11-03T14:27:39.932Z |
5399511 | 5399511 | 20241026043005_k27FB | UK0087 | 2024-10-28T12:20:01.340Z | 2024-11-03T14:27:39.889Z |
5399481 | 5399481 | 20241026042639_GP8u8 | UK0087 | 2024-10-28T12:20:00.499Z | 2024-11-03T14:27:39.842Z |
5399449 | 5399449 | 20241026041841_xDpik | UK0087 | 2024-10-28T12:19:59.745Z | 2024-11-03T14:27:39.733Z |
5399061 | 5399061 | 20241026034810_WHJrz | UK0087 | 2024-10-28T12:19:46.857Z | 2024-11-03T14:27:38.956Z |
5398953 | 5398953 | 20241026034045_2nBij | UK0087 | 2024-10-28T12:19:41.165Z | 2024-11-03T14:27:38.700Z |
5398914 | 5398914 | 20241026033718_i44QH | UK0087 | 2024-10-28T12:19:40.094Z | 2024-11-03T14:27:38.598Z |
5398872 | 5398872 | 20241026033425_gjJXo | UK0087 | 2024-10-28T12:19:38.159Z | 2024-11-03T14:27:38.313Z |
5398846 | 5398846 | 20241026033324_gEwM0 | UK0087 | 2024-10-28T12:19:37.132Z | 2024-11-03T14:27:38.295Z |
5398692 | 5398692 | 20241026031904_5Td7f | UK0087 | 2024-10-28T12:19:28.594Z | 2024-11-03T14:27:37.735Z |
5398552 | 5398552 | 20241026030738_DeqGI | UK0087 | 2024-10-28T12:19:21.433Z | 2024-11-03T14:27:36.778Z |
5398387 | 5398387 | 20241026025206_x3Gy2 | UK0087 | 2024-10-28T12:19:13.637Z | 2024-11-03T14:27:36.226Z |
5397080 | 5397080 | 20241026010055_K6C2S | UK0087 | 2024-10-28T12:18:06.938Z | 2024-11-03T14:27:32.002Z |
5397060 | 5397060 | 20241026005940_zCzpA | UK0087 | 2024-10-28T12:18:05.331Z | 2024-11-03T14:27:31.979Z |
5396758 | 5396758 | 20241026003053_MeuLc | UK0087 | 2024-10-28T12:17:55.143Z | 2024-11-03T14:27:30.859Z |
5387375 | 5387375 | 20241025022722_WDcWu | UK0087 | 2024-10-27T12:21:17.309Z | 2024-11-02T12:28:32.424Z |
5376105 | 5376105 | 20241024034157_QAFA5 | UK0087 | 2024-10-26T12:21:50.525Z | 2024-11-01T12:27:01.390Z |
5375844 | 5375844 | 20241024033229_nKCCg | UK0087 | 2024-10-26T12:21:41.625Z | 2024-11-01T12:27:01.219Z |
5375825 | 5375825 | 20241024033205_Du9An | UK0087 | 2024-10-26T12:21:41.193Z | 2024-11-01T12:27:01.213Z |
5372000 | 5372000 | 20241024002638_wd0xj | UK0087 | 2024-10-26T12:19:02.984Z | 2024-11-01T12:26:57.058Z |
5371927 | 5371927 | 20241024002326_Oi3y0 | UK0087 | 2024-10-26T12:18:58.629Z | 2024-11-01T12:26:57.002Z |
5365539 | 5365539 | 20241023233627_jGoDH | UK0087 | 2024-10-25T12:18:00.090Z | 2024-11-01T12:26:56.189Z |
5364834 | 5364834 | 20241023225538_oJ2XX | UK0087 | 2024-10-25T12:17:36.648Z | 2024-11-01T12:26:55.669Z |
5364775 | 5364775 | 20241023225211_o2Fbj | UK0087 | 2024-10-25T12:17:33.874Z | 2024-11-01T12:26:55.624Z |
5364766 | 5364766 | 20241023225155_QrlvZ | UK0087 | 2024-10-25T12:17:33.291Z | 2024-11-01T12:26:55.612Z |
5361486 | 5361486 | 20241023182105_06emf | UK0087 | 2024-10-25T12:12:45.906Z | 2024-11-01T12:26:50.271Z |
5354693 | 5354693 | 20241023024034_wQM7l | UK0087 | 2024-10-24T12:20:46.954Z | 2024-10-31T12:30:06.250Z |
5354482 | 5354482 | 20241023022801_rMsLw | UK0087 | 2024-10-24T12:20:35.782Z | 2024-10-31T12:30:05.874Z |
5354371 | 5354371 | 20241023022300_79yd7 | UK0087 | 2024-10-24T12:20:30.419Z | 2024-10-31T12:30:05.687Z |
5354349 | 5354349 | 20241023022210_yr3gu | UK0087 | 2024-10-24T12:20:29.466Z | 2024-10-31T12:30:05.678Z |
5354336 | 5354336 | 20241023022049_K9TNm | UK0087 | 2024-10-24T12:20:28.358Z | 2024-10-31T12:30:05.651Z |
5354328 | 5354328 | 20241023022012_SadTm | UK0087 | 2024-10-24T12:20:28.273Z | 2024-10-31T12:30:05.644Z |
5353865 | 5353865 | 20241023015208_aGubm | UK0087 | 2024-10-24T12:19:59.193Z | 2024-10-31T12:30:04.931Z |
5353615 | 5353615 | 20241023013518_YiEj3 | UK0087 | 2024-10-24T12:19:48.567Z | 2024-10-31T12:30:04.421Z |
5353464 | 5353464 | 20241023012649_HXuWG | UK0087 | 2024-10-24T12:19:43.495Z | 2024-10-31T12:30:04.270Z |
5353338 | 5353338 | 20241023012038_XGB2c | UK0087 | 2024-10-24T12:19:39.511Z | 2024-10-31T12:30:04.153Z |
5353219 | 5353219 | 20241023011540_hnKwi | UK0087 | 2024-10-24T12:19:35.978Z | 2024-10-31T12:30:04.019Z |
5352392 | 5352392 | 20241023003100_1HEda | UK0087 | 2024-10-24T12:18:44.071Z | 2024-10-31T12:30:02.588Z |
5352256 | 5352256 | 20241023002227_PfYT6 | UK0087 | 2024-10-24T12:18:34.178Z | 2024-10-31T12:30:02.363Z |
5351742 | 5351742 | 20241022235028_GXpqd | UK0087 | 2024-10-24T12:17:55.712Z | 2024-10-31T12:30:00.857Z |
5351273 | 5351273 | 20241022231251_zOAfy | UK0087 | 2024-10-24T12:17:23.510Z | 2024-10-31T12:29:59.722Z |
5351032 | 5351032 | 20241022224936_Jo6Sy | UK0087 | 2024-10-24T12:17:04.636Z | 2024-10-31T12:29:59.286Z |
5350123 | 5350123 | 20241022211517_a6QHa | UK0087 | 2024-10-24T12:15:23.492Z | 2024-10-31T12:29:57.341Z |
5349840 | 5349840 | 20241022204000_nqPMA | UK0087 | 2024-10-24T12:14:42.556Z | 2024-10-31T12:29:56.763Z |
5349124 | 5349124 | 20241022192710_PksZt | UK0087 | 2024-10-24T12:13:11.545Z | 2024-10-31T12:29:54.607Z |
5348952 | 5348952 | 20241022191151_McGs9 | UK0087 | 2024-10-24T12:12:38.375Z | 2024-10-31T12:29:54.233Z |
5345142 | 5345142 | 20241022051502_d88ED | UK0087 | 2024-10-23T12:19:07.341Z | 2024-10-30T12:26:52.226Z |
5345073 | 5345073 | 20241022051127_dlAqz | UK0087 | 2024-10-23T12:19:04.908Z | 2024-10-30T12:26:52.149Z |
5344873 | 5344873 | 20241022045309_5pwza | UK0087 | 2024-10-23T12:18:54.425Z | 2024-10-30T12:26:51.914Z |
5343854 | 5343854 | 20241022035054_h8CBA | UK0087 | 2024-10-23T12:18:11.021Z | 2024-10-30T12:26:50.650Z |
5343437 | 5343437 | 20241022032915_jzBMU | UK0087 | 2024-10-23T12:17:46.421Z | 2024-10-30T12:26:50.025Z |
5343362 | 5343362 | 20241022032505_2sIKS | UK0087 | 2024-10-23T12:17:44.183Z | 2024-10-30T12:26:49.974Z |
5343190 | 5343190 | 20241022031446_KwAtA | UK0087 | 2024-10-23T12:17:38.310Z | 2024-10-30T12:26:49.549Z |
5342979 | 5342979 | 20241022025724_QVMit | UK0087 | 2024-10-23T12:17:30.268Z | 2024-10-30T12:26:49.103Z |
5342898 | 5342898 | 20241022025216_7mmQC | UK0087 | 2024-10-23T12:17:27.865Z | 2024-10-30T12:26:49.033Z |
5342763 | 5342763 | 20241022024340_2unRV | UK0087 | 2024-10-23T12:17:20.679Z | 2024-10-30T12:26:48.893Z |
5342408 | 5342408 | 20241022022519_lcGRV | UK0087 | 2024-10-23T12:16:51.287Z | 2024-10-30T12:26:48.459Z |
5342043 | 5342043 | 20241022020523_8EOWf | UK0087 | 2024-10-23T12:16:30.777Z | 2024-10-30T12:26:47.883Z |
5341306 | 5341306 | 20241022012524_RPtSb | UK0087 | 2024-10-23T12:15:37.689Z | 2024-10-30T12:26:46.873Z |
5341236 | 5341236 | 20241022012117_mG3KH | UK0087 | 2024-10-23T12:15:32.255Z | 2024-10-30T12:26:46.688Z |
5341191 | 5341191 | 20241022012011_FqyJS | UK0087 | 2024-10-23T12:15:27.808Z | 2024-10-30T12:26:46.656Z |
5341044 | 5341044 | 20241022011038_DXQu3 | UK0087 | 2024-10-23T12:15:14.895Z | 2024-10-30T12:26:46.534Z |
5340891 | 5340891 | 20241022005734_RuObS | UK0087 | 2024-10-23T12:15:01.946Z | 2024-10-30T12:26:46.343Z |
5340769 | 5340769 | 20241022004706_V2n3s | UK0087 | 2024-10-23T12:14:53.278Z | 2024-10-30T12:26:46.277Z |
5340719 | 5340719 | 20241022004432_RAI37 | UK0087 | 2024-10-23T12:14:49.817Z | 2024-10-30T12:26:46.247Z |
5340138 | 5340138 | 20241021234815_2JVuz | UK0087 | 2024-10-23T12:14:20.259Z | 2024-10-30T12:26:45.420Z |
5340120 | 5340120 | 20241021234806_3tpE3 | UK0087 | 2024-10-23T12:14:19.771Z | 2024-10-30T12:26:45.417Z |
5339177 | 5339177 | 20241021220306_BA7Sf | UK0087 | 2024-10-23T12:12:48.614Z | 2024-10-30T12:26:43.761Z |
5339159 | 5339159 | 20241021220114_EuVLt | UK0087 | 2024-10-23T12:12:45.727Z | 2024-10-30T12:26:43.726Z |
5333925 | 5333925 | 20241021014015_YRQ2r | UK0087 | 2024-10-22T12:16:12.548Z | 2024-10-29T12:26:34.693Z |
5327092 | 5327092 | 20241020001747_XObUd | UK0087 | 2024-10-21T12:11:12.228Z | 2024-10-28T12:26:43.416Z |
5320383 | 5320383 | 20241018013412_GwN6t | UK0087 | 2024-10-19T12:05:20.532Z | 2024-10-26T12:27:54.513Z |
5320275 | 5320275 | 20241018011013_vpncD | UK0087 | 2024-10-19T12:04:58.334Z | 2024-10-26T12:27:54.296Z |
5320260 | 5320260 | 20241018010306_DjIjy | UK0087 | 2024-10-19T12:04:56.785Z | 2024-10-26T12:27:54.282Z |
5320144 | 5320144 | 20241018000710_t2e6X | UK0087 | 2024-10-19T12:04:43.313Z | 2024-10-26T12:27:54.090Z |
5319909 | 5319909 | 20241017220231_hPmJx | UK0087 | 2024-10-19T12:04:05.950Z | 2024-10-26T12:27:53.549Z |
5319881 | 5319881 | 20241017214340_SJH4S | UK0087 | 2024-10-19T12:04:02.900Z | 2024-10-26T12:27:53.491Z |
5319642 | 5319642 | 20241017191717_yRHJ7 | UK0087 | 2024-10-19T12:03:28.395Z | 2024-10-26T12:27:52.798Z |
5318714 | 5318714 | 20241017045505_5u0v3 | UK0087 | 2024-10-18T12:04:21.974Z | 2024-10-25T12:24:36.604Z |
5303539 | 5303539 | 20241013031117_JEa96 | UK0087 | 2024-10-14T12:17:27.909Z | 2024-10-21T12:24:18.424Z |
5303449 | 5303449 | 20241013030140_w1tbL | UK0087 | 2024-10-14T12:17:25.157Z | 2024-10-21T12:24:18.042Z |
5301959 | 5301959 | 20241013001927_l289a | UK0087 | 2024-10-14T12:15:45.754Z | 2024-10-21T12:24:03.198Z |
5301653 | 5301653 | 20241012235223_g4dJk | UK0087 | 2024-10-14T12:15:33.704Z | 2024-10-21T12:23:59.718Z |
5301188 | 5301188 | 20241012225107_6d6BM | UK0087 | 2024-10-14T12:15:00.644Z | 2024-10-21T12:23:56.043Z |
5300622 | 5300622 | 20241012210458_ciDZo | UK0087 | 2024-10-14T12:14:19.438Z | 2024-10-21T12:23:50.581Z |
5300047 | 5300047 | 20241012195756_Dq2RW | UK0087 | 2024-10-14T12:13:25.332Z | 2024-10-21T12:23:45.827Z |
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);