participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,178 rows where station_code = "UK0084" 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 |
---|---|---|---|---|---|
5570718 | 5570718 | 20241120204514_Gn3OO | UK0084 | 2024-11-22T14:16:02.086Z | 2024-11-22T14:19:21.968Z |
5570656 | 5570656 | 20241120203519_UOyrq | UK0084 | 2024-11-22T14:15:58.967Z | 2024-11-22T14:19:21.958Z |
5570513 | 5570513 | 20241120195158_Mn4p4 | UK0084 | 2024-11-22T14:15:39.340Z | 2024-11-22T14:19:21.929Z |
5570428 | 5570428 | 20241120193535_42Yk1 | UK0084 | 2024-11-22T14:15:24.920Z | 2024-11-22T14:19:21.916Z |
5570356 | 5570356 | 20241120192342_xkjrh | UK0084 | 2024-11-22T14:15:14.782Z | 2024-11-22T14:19:21.903Z |
5570320 | 5570320 | 20241120191836_cAJXO | UK0084 | 2024-11-22T14:15:09.226Z | 2024-11-22T14:19:21.897Z |
5570278 | 5570278 | 20241120191243_3Vaop | UK0084 | 2024-11-22T14:15:05.925Z | 2024-11-22T14:19:21.891Z |
5570179 | 5570179 | 20241120185712_yPfSh | UK0084 | 2024-11-22T14:14:57.935Z | 2024-11-22T14:19:21.876Z |
5570104 | 5570104 | 20241120184222_IUXzY | UK0084 | 2024-11-22T14:14:52.572Z | 2024-11-22T14:19:21.863Z |
5569737 | 5569737 | 20241120171139_2oIHL | UK0084 | 2024-11-22T14:14:02.244Z | 2024-11-22T14:19:21.795Z |
5565441 | 5565441 | 20241120042605_p4qsS | UK0084 | 2024-11-21T14:18:49.326Z | 2024-11-22T14:21:47.207Z |
5565393 | 5565393 | 20241120042225_W7WOn | UK0084 | 2024-11-21T14:18:47.695Z | 2024-11-22T14:21:46.348Z |
5565384 | 5565384 | 20241120042154_CgFDk | UK0084 | 2024-11-21T14:18:47.606Z | 2024-11-22T14:21:46.317Z |
5565256 | 5565256 | 20241120040804_SWrf7 | UK0084 | 2024-11-21T14:18:43.938Z | 2024-11-22T14:21:44.746Z |
5565195 | 5565195 | 20241120040149_KhDGt | UK0084 | 2024-11-21T14:18:39.785Z | 2024-11-22T14:21:43.560Z |
5565116 | 5565116 | 20241120035257_J2769 | UK0084 | 2024-11-21T14:18:31.286Z | 2024-11-22T14:21:41.812Z |
5565103 | 5565103 | 20241120035155_3WpX0 | UK0084 | 2024-11-21T14:18:30.467Z | 2024-11-22T14:21:41.712Z |
5565077 | 5565077 | 20241120035033_rvX54 | UK0084 | 2024-11-21T14:18:28.545Z | 2024-11-22T14:21:41.348Z |
5564943 | 5564943 | 20241120034020_MOrjs | UK0084 | 2024-11-21T14:18:15.876Z | 2024-11-22T14:21:39.682Z |
5564820 | 5564820 | 20241120032910_W8T1X | UK0084 | 2024-11-21T14:18:05.332Z | 2024-11-22T14:21:36.725Z |
5564640 | 5564640 | 20241120031503_WJmj2 | UK0084 | 2024-11-21T14:17:54.762Z | 2024-11-22T14:21:34.535Z |
5564521 | 5564521 | 20241120030621_d77nL | UK0084 | 2024-11-21T14:17:45.392Z | 2024-11-22T14:21:33.142Z |
5564416 | 5564416 | 20241120025525_6qRmA | UK0084 | 2024-11-21T14:17:33.315Z | 2024-11-22T14:21:31.329Z |
5564225 | 5564225 | 20241120024052_kYeBY | UK0084 | 2024-11-21T14:17:20.741Z | 2024-11-22T14:21:29.099Z |
5563965 | 5563965 | 20241120021837_v7SIt | UK0084 | 2024-11-21T14:17:00.542Z | 2024-11-22T14:21:25.655Z |
5563855 | 5563855 | 20241120021031_93Qqm | UK0084 | 2024-11-21T14:16:51.122Z | 2024-11-22T14:21:23.988Z |
5563828 | 5563828 | 20241120020726_vPyv1 | UK0084 | 2024-11-21T14:16:46.959Z | 2024-11-22T14:21:23.619Z |
5563821 | 5563821 | 20241120020655_3NYjF | UK0084 | 2024-11-21T14:16:46.563Z | 2024-11-22T14:21:23.585Z |
5563598 | 5563598 | 20241120015033_n2fMe | UK0084 | 2024-11-21T14:16:26.527Z | 2024-11-22T14:21:19.611Z |
5563348 | 5563348 | 20241120011855_dEI5d | UK0084 | 2024-11-21T14:15:56.921Z | 2024-11-22T14:21:13.225Z |
5563305 | 5563305 | 20241120011610_3tbmH | UK0084 | 2024-11-21T14:15:52.136Z | 2024-11-22T14:21:12.594Z |
5563136 | 5563136 | 20241120005608_vrAC0 | UK0084 | 2024-11-21T14:15:37.746Z | 2024-11-22T14:21:09.935Z |
5562985 | 5562985 | 20241120003609_uhhB1 | UK0084 | 2024-11-21T14:15:30.769Z | 2024-11-22T14:21:07.463Z |
5562914 | 5562914 | 20241120002653_BemJs | UK0084 | 2024-11-21T14:15:27.238Z | 2024-11-22T14:21:06.057Z |
5562872 | 5562872 | 20241120002212_gdRA8 | UK0084 | 2024-11-21T14:15:25.765Z | 2024-11-22T14:21:05.739Z |
5562694 | 5562694 | 20241120000409_kYvs2 | UK0084 | 2024-11-21T14:15:17.226Z | 2024-11-22T14:21:02.583Z |
5562608 | 5562608 | 20241119235419_2P6k1 | UK0084 | 2024-11-21T14:15:13.426Z | 2024-11-22T14:21:00.869Z |
5562593 | 5562593 | 20241119235343_TDzSP | UK0084 | 2024-11-21T14:15:11.885Z | 2024-11-22T14:21:00.776Z |
5562524 | 5562524 | 20241119234756_nCND0 | UK0084 | 2024-11-21T14:15:05.449Z | 2024-11-22T14:20:59.797Z |
5562478 | 5562478 | 20241119234242_ZQWbH | UK0084 | 2024-11-21T14:14:57.041Z | 2024-11-22T14:20:59.189Z |
5562392 | 5562392 | 20241119233355_M5NSf | UK0084 | 2024-11-21T14:14:46.585Z | 2024-11-22T14:20:57.045Z |
5562310 | 5562310 | 20241119232137_3GQfx | UK0084 | 2024-11-21T14:14:41.530Z | 2024-11-22T14:20:55.702Z |
5562170 | 5562170 | 20241119230641_5rV61 | UK0084 | 2024-11-21T14:14:30.420Z | 2024-11-22T14:20:53.737Z |
5562031 | 5562031 | 20241119224743_I1DXK | UK0084 | 2024-11-21T14:14:20.881Z | 2024-11-22T14:20:51.789Z |
5561952 | 5561952 | 20241119223856_VpJYd | UK0084 | 2024-11-21T14:14:16.772Z | 2024-11-22T14:20:50.521Z |
5561580 | 5561580 | 20241119210932_5YHL8 | UK0084 | 2024-11-21T14:13:29.792Z | 2024-11-22T14:20:41.218Z |
5561352 | 5561352 | 20241119200723_WXxVe | UK0084 | 2024-11-21T14:13:08.153Z | 2024-11-22T14:20:33.103Z |
5561297 | 5561297 | 20241119193819_yqJjA | UK0084 | 2024-11-21T14:13:02.085Z | 2024-11-22T14:20:30.286Z |
5561265 | 5561265 | 20241119192510_RqJVD | UK0084 | 2024-11-21T14:12:54.288Z | 2024-11-22T14:20:29.211Z |
5561251 | 5561251 | 20241119191937_qsgCK | UK0084 | 2024-11-21T14:12:49.022Z | 2024-11-22T14:20:28.673Z |
5558426 | 5558426 | 20241120060333_SdPOj | UK0084 | 2024-11-21T14:03:14.171Z | 2024-11-22T14:19:21.227Z |
5558331 | 5558331 | 20241120055630_DMmN3 | UK0084 | 2024-11-21T14:03:02.470Z | 2024-11-22T14:19:21.211Z |
5558270 | 5558270 | 20241120055119_VSAgS | UK0084 | 2024-11-21T14:02:54.086Z | 2024-11-22T14:19:21.202Z |
5557735 | 5557735 | 20241120050906_tLQZv | UK0084 | 2024-11-21T14:01:36.682Z | 2024-11-22T14:19:21.119Z |
5557451 | 5557451 | 20241120044648_7bLRm | UK0084 | 2024-11-21T14:00:55.081Z | 2024-11-22T14:19:21.073Z |
5557399 | 5557399 | 20241120044342_nhoYI | UK0084 | 2024-11-21T14:00:42.855Z | 2024-11-22T14:19:21.063Z |
5557389 | 5557389 | 20241120044308_9vebT | UK0084 | 2024-11-21T14:00:41.014Z | 2024-11-22T14:19:21.061Z |
5552833 | 5552833 | 20241117221941_0tjPA | UK0084 | 2024-11-19T14:09:23.659Z | 2024-11-22T14:22:47.606Z |
5552757 | 5552757 | 20241117211315_hww5Z | UK0084 | 2024-11-19T14:09:07.959Z | 2024-11-22T14:22:46.418Z |
5545051 | 5545051 | 20241115225356_P7Abs | UK0084 | 2024-11-17T14:03:41.387Z | 2024-11-22T14:23:35.593Z |
5545020 | 5545020 | 20241115222019_CnKzT | UK0084 | 2024-11-17T14:03:37.879Z | 2024-11-22T14:23:35.229Z |
5544986 | 5544986 | 20241115205916_XR6ly | UK0084 | 2024-11-17T14:03:33.662Z | 2024-11-22T14:23:35.000Z |
5544981 | 5544981 | 20241115205424_SXqOm | UK0084 | 2024-11-17T14:03:33.345Z | 2024-11-22T14:23:34.990Z |
5541191 | 5541191 | 20241113192257_1cxL2 | UK0084 | 2024-11-15T14:06:52.366Z | 2024-11-22T14:24:16.453Z |
5532307 | 5532307 | 20241112050446_Dc39M | UK0084 | 2024-11-13T14:16:35.925Z | 2024-11-20T14:26:21.750Z |
5532171 | 5532171 | 20241112044706_a7zrw | UK0084 | 2024-11-13T14:16:24.226Z | 2024-11-20T14:26:20.546Z |
5532020 | 5532020 | 20241112042835_iiSrA | UK0084 | 2024-11-13T14:16:10.658Z | 2024-11-20T14:26:17.327Z |
5531768 | 5531768 | 20241112040804_KiYVV | UK0084 | 2024-11-13T14:15:54.201Z | 2024-11-20T14:26:14.216Z |
5530597 | 5530597 | 20241112023233_jsGnK | UK0084 | 2024-11-13T14:14:24.311Z | 2024-11-20T14:26:01.922Z |
5530346 | 5530346 | 20241112021013_KyJUS | UK0084 | 2024-11-13T14:14:10.024Z | 2024-11-20T14:25:57.341Z |
5529765 | 5529765 | 20241112010340_l9Aae | UK0084 | 2024-11-13T14:13:09.732Z | 2024-11-20T14:25:48.059Z |
5529598 | 5529598 | 20241112004025_fXG6X | UK0084 | 2024-11-13T14:13:00.854Z | 2024-11-20T14:25:46.710Z |
5529569 | 5529569 | 20241112003619_p22Xe | UK0084 | 2024-11-13T14:12:58.667Z | 2024-11-20T14:25:46.298Z |
5529495 | 5529495 | 20241112002642_JXaBI | UK0084 | 2024-11-13T14:12:54.534Z | 2024-11-20T14:25:45.701Z |
5528979 | 5528979 | 20241111231447_IIVBr | UK0084 | 2024-11-13T14:11:53.819Z | 2024-11-20T14:25:38.297Z |
5528503 | 5528503 | 20241111211303_x7UIP | UK0084 | 2024-11-13T14:10:55.438Z | 2024-11-20T14:25:31.422Z |
5528382 | 5528382 | 20241111203653_Ye3aN | UK0084 | 2024-11-13T14:10:33.537Z | 2024-11-20T14:25:29.112Z |
5527791 | 5527791 | 20241111183552_z0leG | UK0084 | 2024-11-13T14:09:09.502Z | 2024-11-20T14:25:20.462Z |
5527715 | 5527715 | 20241111182151_Z6dWd | UK0084 | 2024-11-13T14:08:58.436Z | 2024-11-20T14:25:18.405Z |
5527653 | 5527653 | 20241111180530_cSU0J | UK0084 | 2024-11-13T14:08:51.699Z | 2024-11-20T14:25:16.375Z |
5527627 | 5527627 | 20241111175441_VCFg9 | UK0084 | 2024-11-13T14:08:47.907Z | 2024-11-20T14:25:15.179Z |
5522478 | 5522478 | 20241110200908_USWpF | UK0084 | 2024-11-12T14:13:20.658Z | 2024-11-19T14:22:02.644Z |
5439800 | 5439800 | 20241030203329_rxcN1 | UK0084 | 2024-11-01T12:14:30.824Z | 2024-11-08T14:23:05.829Z |
5418652 | 5418652 | 20241027212852_RtTLT | UK0084 | 2024-10-30T12:15:57.514Z | 2024-11-05T14:27:10.899Z |
5418523 | 5418523 | 20241027210514_Cb2Xp | UK0084 | 2024-10-30T12:15:47.456Z | 2024-11-05T14:27:10.380Z |
5418456 | 5418456 | 20241027205050_PTTRx | UK0084 | 2024-10-30T12:15:42.593Z | 2024-11-05T14:27:10.071Z |
5418442 | 5418442 | 20241027204732_GoU2f | UK0084 | 2024-10-30T12:15:41.537Z | 2024-11-05T14:27:10.030Z |
5418315 | 5418315 | 20241027202158_k4DnE | UK0084 | 2024-10-30T12:15:24.869Z | 2024-11-05T14:27:09.618Z |
5418137 | 5418137 | 20241027195810_mEubV | UK0084 | 2024-10-30T12:14:58.852Z | 2024-11-05T14:27:09.260Z |
5418114 | 5418114 | 20241027195635_XPV1a | UK0084 | 2024-10-30T12:14:55.436Z | 2024-11-05T14:27:09.139Z |
5417768 | 5417768 | 20241027191218_36ro4 | UK0084 | 2024-10-30T12:14:26.874Z | 2024-11-05T14:27:08.205Z |
5417734 | 5417734 | 20241027190638_dJXFk | UK0084 | 2024-10-30T12:14:22.249Z | 2024-11-05T14:27:08.137Z |
5417596 | 5417596 | 20241027185016_b34gl | UK0084 | 2024-10-30T12:13:57.564Z | 2024-11-05T14:27:07.699Z |
5417344 | 5417344 | 20241027181706_YFUT0 | UK0084 | 2024-10-30T12:13:33.209Z | 2024-11-05T14:27:06.985Z |
5410831 | 5410831 | 20241027053957_mtQzN | UK0084 | 2024-10-29T12:18:05.850Z | 2024-11-04T14:29:05.637Z |
5410689 | 5410689 | 20241027052902_7v9sz | UK0084 | 2024-10-29T12:18:02.714Z | 2024-11-04T14:29:05.234Z |
5410669 | 5410669 | 20241027052601_vi3x0 | UK0084 | 2024-10-29T12:18:02.217Z | 2024-11-04T14:29:05.206Z |
5410663 | 5410663 | 20241027052555_zl4gO | UK0084 | 2024-10-29T12:18:02.211Z | 2024-11-04T14:29:05.203Z |
5410517 | 5410517 | 20241027051622_VhkyR | UK0084 | 2024-10-29T12:17:57.451Z | 2024-11-04T14:29:04.714Z |
5410483 | 5410483 | 20241027051501_nfgiN | UK0084 | 2024-10-29T12:17:56.886Z | 2024-11-04T14:29:04.643Z |
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);