participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,191 rows where station_code = "UK005R" 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 |
---|---|---|---|---|---|
5573263 | 5573263 | 20241121041724_bXf48 | UK005R | 2024-11-22T14:19:19.120Z | 2024-11-22T14:19:22.479Z |
5573211 | 5573211 | 20241121040848_INmfo | UK005R | 2024-11-22T14:19:15.883Z | 2024-11-22T14:19:22.470Z |
5573162 | 5573162 | 20241121040121_YZ7j7 | UK005R | 2024-11-22T14:19:13.477Z | 2024-11-22T14:19:22.462Z |
5572855 | 5572855 | 20241121031731_cYwHC | UK005R | 2024-11-22T14:18:53.808Z | 2024-11-22T14:19:22.403Z |
5572806 | 5572806 | 20241121031034_qdsCo | UK005R | 2024-11-22T14:18:50.670Z | 2024-11-22T14:19:22.394Z |
5572670 | 5572670 | 20241121025509_RJJJy | UK005R | 2024-11-22T14:18:42.006Z | 2024-11-22T14:19:22.371Z |
5572568 | 5572568 | 20241121024048_3C2bw | UK005R | 2024-11-22T14:18:37.008Z | 2024-11-22T14:19:22.353Z |
5572452 | 5572452 | 20241121022237_Tlv1x | UK005R | 2024-11-22T14:18:27.329Z | 2024-11-22T14:19:22.331Z |
5572446 | 5572446 | 20241121022232_xsGYa | UK005R | 2024-11-22T14:18:27.095Z | 2024-11-22T14:19:22.330Z |
5571994 | 5571994 | 20241121011632_a8n6M | UK005R | 2024-11-22T14:17:51.252Z | 2024-11-22T14:19:22.238Z |
5571904 | 5571904 | 20241121010356_rToig | UK005R | 2024-11-22T14:17:46.160Z | 2024-11-22T14:19:22.219Z |
5571803 | 5571803 | 20241121004851_TRVwJ | UK005R | 2024-11-22T14:17:40.410Z | 2024-11-22T14:19:22.198Z |
5571650 | 5571650 | 20241121002657_1awaK | UK005R | 2024-11-22T14:17:32.326Z | 2024-11-22T14:19:22.166Z |
5571498 | 5571498 | 20241120235835_v5gs3 | UK005R | 2024-11-22T14:17:11.734Z | 2024-11-22T14:19:22.138Z |
5571355 | 5571355 | 20241120232750_70g2P | UK005R | 2024-11-22T14:16:56.563Z | 2024-11-22T14:19:22.109Z |
5570535 | 5570535 | 20241120195812_8qUqN | UK005R | 2024-11-22T14:15:41.546Z | 2024-11-22T14:19:21.933Z |
5566495 | 5566495 | 20241121062353_hNJMf | UK005R | 2024-11-22T14:03:01.122Z | 2024-11-22T14:03:01.122Z |
5566463 | 5566463 | 20241121061639_X12AV | UK005R | 2024-11-22T14:02:57.080Z | 2024-11-22T14:02:57.080Z |
5566425 | 5566425 | 20241121061119_eGqDS | UK005R | 2024-11-22T14:02:53.394Z | 2024-11-22T14:02:53.394Z |
5566375 | 5566375 | 20241121060544_GSnyo | UK005R | 2024-11-22T14:02:37.679Z | 2024-11-22T14:02:37.679Z |
5566340 | 5566340 | 20241121060207_aXcBg | UK005R | 2024-11-22T14:02:29.622Z | 2024-11-22T14:02:29.622Z |
5566287 | 5566287 | 20241121055518_jMCEU | UK005R | 2024-11-22T14:02:22.023Z | 2024-11-22T14:02:22.023Z |
5566282 | 5566282 | 20241121055510_Sy06k | UK005R | 2024-11-22T14:02:21.583Z | 2024-11-22T14:02:21.583Z |
5566192 | 5566192 | 20241121054451_Urxar | UK005R | 2024-11-22T14:02:10.814Z | 2024-11-22T14:02:10.814Z |
5566110 | 5566110 | 20241121053354_mEpsr | UK005R | 2024-11-22T14:01:50.952Z | 2024-11-22T14:01:50.952Z |
5566103 | 5566103 | 20241121053319_CKTQh | UK005R | 2024-11-22T14:01:50.071Z | 2024-11-22T14:01:50.071Z |
5565977 | 5565977 | 20241121051237_AK4hA | UK005R | 2024-11-22T14:01:30.411Z | 2024-11-22T14:01:30.411Z |
5565918 | 5565918 | 20241121050547_nEQlT | UK005R | 2024-11-22T14:01:23.928Z | 2024-11-22T14:01:23.928Z |
5565822 | 5565822 | 20241121045144_hL0gM | UK005R | 2024-11-22T14:01:01.607Z | 2024-11-22T14:01:01.607Z |
5565599 | 5565599 | 20241121042442_fkZOm | UK005R | 2024-11-22T14:00:23.332Z | 2024-11-22T14:00:23.332Z |
5562403 | 5562403 | 20241119233359_JQ5Mm | UK005R | 2024-11-21T14:14:46.663Z | 2024-11-22T14:20:57.050Z |
5561620 | 5561620 | 20241119211607_cKtxU | UK005R | 2024-11-21T14:13:35.393Z | 2024-11-22T14:20:42.176Z |
5558387 | 5558387 | 20241120060139_ItavS | UK005R | 2024-11-21T14:03:10.710Z | 2024-11-22T14:19:21.222Z |
5558241 | 5558241 | 20241120054816_x3Man | UK005R | 2024-11-21T14:02:51.234Z | 2024-11-22T14:19:21.198Z |
5557763 | 5557763 | 20241120051038_yMa33 | UK005R | 2024-11-21T14:01:41.771Z | 2024-11-22T14:19:21.124Z |
5553849 | 5553849 | 20241118043210_0wg1a | UK005R | 2024-11-19T14:11:29.961Z | 2024-11-22T14:22:56.554Z |
5553841 | 5553841 | 20241118043106_1VkeE | UK005R | 2024-11-19T14:11:29.563Z | 2024-11-22T14:22:56.527Z |
5553831 | 5553831 | 20241118042805_u5gTX | UK005R | 2024-11-19T14:11:29.429Z | 2024-11-22T14:22:56.522Z |
5553750 | 5553750 | 20241118041028_xfN3L | UK005R | 2024-11-19T14:11:24.785Z | 2024-11-22T14:22:56.010Z |
5553693 | 5553693 | 20241118035358_ATYeW | UK005R | 2024-11-19T14:11:17.446Z | 2024-11-22T14:22:55.399Z |
5549770 | 5549770 | 20241118062319_3Nzqa | UK005R | 2024-11-19T14:00:48.680Z | 2024-11-22T14:21:52.542Z |
5549757 | 5549757 | 20241118062132_rFGs3 | UK005R | 2024-11-19T14:00:46.664Z | 2024-11-22T14:21:52.422Z |
5549748 | 5549748 | 20241118061423_uWWqo | UK005R | 2024-11-19T14:00:42.894Z | 2024-11-22T14:21:52.106Z |
5549702 | 5549702 | 20241118060401_es1Kz | UK005R | 2024-11-19T14:00:37.098Z | 2024-11-22T14:21:51.435Z |
5549683 | 5549683 | 20241118055949_t3asF | UK005R | 2024-11-19T14:00:33.993Z | 2024-11-22T14:21:51.187Z |
5549618 | 5549618 | 20241118054148_PVq8b | UK005R | 2024-11-19T14:00:26.467Z | 2024-11-22T14:21:50.779Z |
5549528 | 5549528 | 20241118051226_vO1gK | UK005R | 2024-11-19T14:00:13.724Z | 2024-11-22T14:21:49.846Z |
5538895 | 5538895 | 20241113051124_vpql3 | UK005R | 2024-11-14T14:14:02.371Z | 2024-11-21T14:26:29.586Z |
5538874 | 5538874 | 20241113050727_LpapR | UK005R | 2024-11-14T14:14:01.609Z | 2024-11-21T14:26:29.352Z |
5538832 | 5538832 | 20241113050401_Eta2K | UK005R | 2024-11-14T14:13:59.501Z | 2024-11-21T14:26:28.887Z |
5538816 | 5538816 | 20241113050222_3NP22 | UK005R | 2024-11-14T14:13:59.043Z | 2024-11-21T14:26:28.826Z |
5538753 | 5538753 | 20241113045057_AJKZo | UK005R | 2024-11-14T14:13:55.028Z | 2024-11-21T14:26:28.686Z |
5538647 | 5538647 | 20241113043055_i67rf | UK005R | 2024-11-14T14:13:46.344Z | 2024-11-21T14:26:28.336Z |
5538633 | 5538633 | 20241113042557_pYeSq | UK005R | 2024-11-14T14:13:45.361Z | 2024-11-21T14:26:28.219Z |
5538609 | 5538609 | 20241113042208_LjRsO | UK005R | 2024-11-14T14:13:43.751Z | 2024-11-21T14:26:27.569Z |
5538442 | 5538442 | 20241113034532_VSQct | UK005R | 2024-11-14T14:13:27.517Z | 2024-11-21T14:26:25.799Z |
5538412 | 5538412 | 20241113033452_oR2lm | UK005R | 2024-11-14T14:13:24.637Z | 2024-11-21T14:26:25.328Z |
5538303 | 5538303 | 20241113030255_HB3iZ | UK005R | 2024-11-14T14:13:12.608Z | 2024-11-21T14:26:22.944Z |
5538292 | 5538292 | 20241113030008_XM86Y | UK005R | 2024-11-14T14:13:11.500Z | 2024-11-21T14:26:22.937Z |
5538287 | 5538287 | 20241113025950_8fcG0 | UK005R | 2024-11-14T14:13:11.410Z | 2024-11-21T14:26:22.934Z |
5538265 | 5538265 | 20241113025629_5llqs | UK005R | 2024-11-14T14:13:10.509Z | 2024-11-21T14:26:22.862Z |
5538107 | 5538107 | 20241113021337_7mcqI | UK005R | 2024-11-14T14:12:51.488Z | 2024-11-21T14:26:20.749Z |
5537895 | 5537895 | 20241113012407_uWvwx | UK005R | 2024-11-14T14:12:36.037Z | 2024-11-21T14:26:16.683Z |
5537653 | 5537653 | 20241112235923_Zevg3 | UK005R | 2024-11-14T14:12:22.817Z | 2024-11-21T14:26:15.086Z |
5537630 | 5537630 | 20241112235604_ShkYw | UK005R | 2024-11-14T14:12:19.876Z | 2024-11-21T14:26:15.012Z |
5537458 | 5537458 | 20241112230844_uAZ2y | UK005R | 2024-11-14T14:11:51.682Z | 2024-11-21T14:26:13.198Z |
5537356 | 5537356 | 20241112221911_YAsVa | UK005R | 2024-11-14T14:11:39.989Z | 2024-11-21T14:26:11.366Z |
5537345 | 5537345 | 20241112221404_b22TI | UK005R | 2024-11-14T14:11:39.556Z | 2024-11-21T14:26:11.361Z |
5537301 | 5537301 | 20241112215747_NtRyR | UK005R | 2024-11-14T14:11:32.828Z | 2024-11-21T14:26:11.050Z |
5532915 | 5532915 | 20241113061632_z4wI8 | UK005R | 2024-11-14T14:00:31.481Z | 2024-11-22T14:24:06.032Z |
5532904 | 5532904 | 20241113061426_7gVDc | UK005R | 2024-11-14T14:00:30.384Z | 2024-11-22T14:24:06.017Z |
5532862 | 5532862 | 20241113060543_3nI2r | UK005R | 2024-11-14T14:00:24.668Z | 2024-11-22T14:24:05.700Z |
5532062 | 5532062 | 20241112043353_oKPOV | UK005R | 2024-11-13T14:16:13.947Z | 2024-11-20T14:26:18.316Z |
5531715 | 5531715 | 20241112040338_cI8Mw | UK005R | 2024-11-13T14:15:52.129Z | 2024-11-20T14:26:13.648Z |
5531468 | 5531468 | 20241112034119_BoEq1 | UK005R | 2024-11-13T14:15:41.355Z | 2024-11-20T14:26:11.592Z |
5531319 | 5531319 | 20241112033156_0t4kw | UK005R | 2024-11-13T14:15:34.345Z | 2024-11-20T14:26:10.348Z |
5531224 | 5531224 | 20241112032331_7iYBG | UK005R | 2024-11-13T14:15:26.780Z | 2024-11-20T14:26:08.636Z |
5530837 | 5530837 | 20241112025134_ZroNL | UK005R | 2024-11-13T14:14:42.787Z | 2024-11-20T14:26:03.976Z |
5530712 | 5530712 | 20241112023922_4EdFv | UK005R | 2024-11-13T14:14:30.132Z | 2024-11-20T14:26:02.841Z |
5530620 | 5530620 | 20241112023534_pgkp6 | UK005R | 2024-11-13T14:14:25.040Z | 2024-11-20T14:26:02.015Z |
5530088 | 5530088 | 20241112014224_kW3VR | UK005R | 2024-11-13T14:13:50.987Z | 2024-11-20T14:25:54.275Z |
5529810 | 5529810 | 20241112010555_hes3A | UK005R | 2024-11-13T14:13:12.749Z | 2024-11-20T14:25:48.477Z |
5529789 | 5529789 | 20241112010512_cEo2D | UK005R | 2024-11-13T14:13:11.379Z | 2024-11-20T14:25:48.235Z |
5529638 | 5529638 | 20241112004728_86541 | UK005R | 2024-11-13T14:13:03.670Z | 2024-11-20T14:25:46.957Z |
5529436 | 5529436 | 20241112002058_xt98l | UK005R | 2024-11-13T14:12:47.850Z | 2024-11-20T14:25:44.713Z |
5529392 | 5529392 | 20241112001025_rj4KX | UK005R | 2024-11-13T14:12:32.896Z | 2024-11-20T14:25:44.111Z |
5529135 | 5529135 | 20241111233330_7GbMl | UK005R | 2024-11-13T14:12:08.020Z | 2024-11-20T14:25:40.456Z |
5528566 | 5528566 | 20241111213746_VCiBJ | UK005R | 2024-11-13T14:11:07.276Z | 2024-11-20T14:25:32.368Z |
5524651 | 5524651 | 20241111045913_LiPy6 | UK005R | 2024-11-12T14:17:50.966Z | 2024-11-19T14:22:23.201Z |
5524550 | 5524550 | 20241111043227_1WVim | UK005R | 2024-11-12T14:17:39.810Z | 2024-11-19T14:22:22.150Z |
5524535 | 5524535 | 20241111042825_tL4Sr | UK005R | 2024-11-12T14:17:37.052Z | 2024-11-19T14:22:22.070Z |
5523741 | 5523741 | 20241111021610_16WMk | UK005R | 2024-11-12T14:16:10.510Z | 2024-11-19T14:22:14.715Z |
5523570 | 5523570 | 20241111014728_hLSS0 | UK005R | 2024-11-12T14:16:01.144Z | 2024-11-19T14:22:13.410Z |
5462059 | 5462059 | 20241101225343_PEqrH | UK005R | 2024-11-03T14:16:55.194Z | 2024-11-10T14:26:31.456Z |
5461980 | 5461980 | 20241101223150_DmZq3 | UK005R | 2024-11-03T14:16:50.371Z | 2024-11-10T14:26:31.127Z |
5429223 | 5429223 | 20241028190109_8ONZf | UK005R | 2024-10-31T12:16:13.705Z | 2024-11-06T14:27:15.553Z |
5410653 | 5410653 | 20241027052553_C9o85 | UK005R | 2024-10-29T12:18:02.170Z | 2024-11-04T14:29:05.201Z |
5410125 | 5410125 | 20241027045507_S3k7g | UK005R | 2024-10-29T12:17:48.435Z | 2024-11-04T14:29:03.799Z |
5409999 | 5409999 | 20241027044732_8VXYk | UK005R | 2024-10-29T12:17:45.663Z | 2024-11-04T14:29:03.248Z |
5409960 | 5409960 | 20241027044421_dpcfG | UK005R | 2024-10-29T12:17:44.940Z | 2024-11-04T14:29:03.110Z |
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);