participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,357 rows where station_code = "UK00C2" 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 |
---|---|---|---|---|---|
5592562 | 5592562 | 20241121045945_ouaxF | UK00C2 | 2024-11-24T14:21:22.296Z | 2024-11-26T14:23:56.081Z |
5577056 | 5577056 | 20241121050931_82Uv1 | UK00C2 | 2024-11-23T14:11:38.690Z | 2024-11-26T14:23:56.754Z |
5571328 | 5571328 | 20241120232301_ZMPgO | UK00C2 | 2024-11-22T14:16:50.965Z | 2024-11-26T14:26:33.759Z |
5570905 | 5570905 | 20241120212632_JUKPN | UK00C2 | 2024-11-22T14:16:11.547Z | 2024-11-26T14:26:31.061Z |
5570877 | 5570877 | 20241120212115_35f2Q | UK00C2 | 2024-11-22T14:16:10.211Z | 2024-11-26T14:26:30.843Z |
5569983 | 5569983 | 20241120181954_9HX3x | UK00C2 | 2024-11-22T14:14:43.000Z | 2024-11-26T14:26:13.012Z |
5569922 | 5569922 | 20241120180013_MqnBA | UK00C2 | 2024-11-22T14:14:35.939Z | 2024-11-26T14:26:11.996Z |
5566388 | 5566388 | 20241121060606_65Gk6 | UK00C2 | 2024-11-22T14:02:41.242Z | 2024-11-26T14:24:02.989Z |
5566157 | 5566157 | 20241121053849_Z9KBN | UK00C2 | 2024-11-22T14:02:00.493Z | 2024-11-26T14:23:59.865Z |
5566135 | 5566135 | 20241121053536_Q3APM | UK00C2 | 2024-11-22T14:01:54.909Z | 2024-11-26T14:23:58.724Z |
5566031 | 5566031 | 20241121051947_BwInO | UK00C2 | 2024-11-22T14:01:35.596Z | 2024-11-26T14:23:57.504Z |
5565967 | 5565967 | 20241121051140_OiM9E | UK00C2 | 2024-11-22T14:01:29.451Z | 2024-11-26T14:23:56.881Z |
5565934 | 5565934 | 20241121050746_5xofn | UK00C2 | 2024-11-22T14:01:26.100Z | 2024-11-26T14:23:56.699Z |
5565890 | 5565890 | 20241121050112_dNvFA | UK00C2 | 2024-11-22T14:01:20.450Z | 2024-11-26T14:23:56.257Z |
5565789 | 5565789 | 20241121044616_2EVD2 | UK00C2 | 2024-11-22T14:00:56.644Z | 2024-11-26T14:23:54.630Z |
5565743 | 5565743 | 20241121044108_gQ3ph | UK00C2 | 2024-11-22T14:00:50.319Z | 2024-11-26T14:23:53.931Z |
5565736 | 5565736 | 20241121044026_v3TXF | UK00C2 | 2024-11-22T14:00:49.112Z | 2024-11-26T14:23:53.848Z |
5537920 | 5537920 | 20241113013029_VWXBv | UK00C2 | 2024-11-14T14:12:37.724Z | 2024-11-21T14:26:17.010Z |
5537918 | 5537918 | 20241113012738_hJjMf | UK00C2 | 2024-11-14T14:12:37.591Z | 2024-11-21T14:26:17.010Z |
5537697 | 5537697 | 20241113000858_Jj3Bz | UK00C2 | 2024-11-14T14:12:24.823Z | 2024-11-21T14:26:15.368Z |
5532347 | 5532347 | 20241112050937_NTM9D | UK00C2 | 2024-11-13T14:16:38.189Z | 2024-11-20T14:26:22.131Z |
5532293 | 5532293 | 20241112050357_WxRtB | UK00C2 | 2024-11-13T14:16:34.794Z | 2024-11-20T14:26:21.681Z |
5532291 | 5532291 | 20241112050342_1hHEj | UK00C2 | 2024-11-13T14:16:33.629Z | 2024-11-20T14:26:21.655Z |
5531914 | 5531914 | 20241112041842_BlWJ7 | UK00C2 | 2024-11-13T14:16:02.218Z | 2024-11-20T14:26:15.870Z |
5531874 | 5531874 | 20241112041629_rUXJu | UK00C2 | 2024-11-13T14:16:00.227Z | 2024-11-20T14:26:15.547Z |
5531867 | 5531867 | 20241112041449_HMyW7 | UK00C2 | 2024-11-13T14:15:59.879Z | 2024-11-20T14:26:15.403Z |
5531832 | 5531832 | 20241112041143_R3moY | UK00C2 | 2024-11-13T14:15:57.132Z | 2024-11-20T14:26:14.826Z |
5531714 | 5531714 | 20241112040225_GW8rP | UK00C2 | 2024-11-13T14:15:51.875Z | 2024-11-20T14:26:13.639Z |
5531486 | 5531486 | 20241112034250_dh6hj | UK00C2 | 2024-11-13T14:15:42.071Z | 2024-11-20T14:26:11.794Z |
5531381 | 5531381 | 20241112033443_DYKqa | UK00C2 | 2024-11-13T14:15:36.515Z | 2024-11-20T14:26:10.669Z |
5530632 | 5530632 | 20241112023545_0eS32 | UK00C2 | 2024-11-13T14:14:25.277Z | 2024-11-20T14:26:02.037Z |
5530573 | 5530573 | 20241112023002_IkDdS | UK00C2 | 2024-11-13T14:14:23.169Z | 2024-11-20T14:26:01.699Z |
5530216 | 5530216 | 20241112015638_erhNb | UK00C2 | 2024-11-13T14:14:01.796Z | 2024-11-20T14:25:55.435Z |
5530207 | 5530207 | 20241112015624_bQ2kV | UK00C2 | 2024-11-13T14:14:01.612Z | 2024-11-20T14:25:55.419Z |
5529776 | 5529776 | 20241112010401_prPM4 | UK00C2 | 2024-11-13T14:13:10.277Z | 2024-11-20T14:25:48.167Z |
5529705 | 5529705 | 20241112005723_2IXdj | UK00C2 | 2024-11-13T14:13:06.959Z | 2024-11-20T14:25:47.590Z |
5529551 | 5529551 | 20241112003309_h83EA | UK00C2 | 2024-11-13T14:12:57.381Z | 2024-11-20T14:25:46.242Z |
5529209 | 5529209 | 20241111234636_3VaMv | UK00C2 | 2024-11-13T14:12:13.516Z | 2024-11-20T14:25:41.814Z |
5528801 | 5528801 | 20241111224051_ddHlY | UK00C2 | 2024-11-13T14:11:27.134Z | 2024-11-20T14:25:36.058Z |
5528717 | 5528717 | 20241111222347_vW3J9 | UK00C2 | 2024-11-13T14:11:19.536Z | 2024-11-20T14:25:34.215Z |
5528121 | 5528121 | 20241111194059_nvd3a | UK00C2 | 2024-11-13T14:09:56.018Z | 2024-11-20T14:25:25.339Z |
5527881 | 5527881 | 20241111185021_I690c | UK00C2 | 2024-11-13T14:09:29.964Z | 2024-11-20T14:25:22.519Z |
5527753 | 5527753 | 20241111182803_wiDr2 | UK00C2 | 2024-11-13T14:09:02.315Z | 2024-11-20T14:25:19.657Z |
5410716 | 5410716 | 20241027053054_BwOEC | UK00C2 | 2024-10-29T12:18:03.158Z | 2024-11-04T14:29:05.285Z |
5410685 | 5410685 | 20241027052755_rMIxt | UK00C2 | 2024-10-29T12:18:02.339Z | 2024-11-04T14:29:05.213Z |
5410303 | 5410303 | 20241027050526_99QyE | UK00C2 | 2024-10-29T12:17:52.648Z | 2024-11-04T14:29:04.317Z |
5409856 | 5409856 | 20241027043844_8Mukd | UK00C2 | 2024-10-29T12:17:42.453Z | 2024-11-04T14:29:02.818Z |
5408477 | 5408477 | 20241027032805_oUwqC | UK00C2 | 2024-10-29T12:16:32.322Z | 2024-11-04T14:28:59.554Z |
5402785 | 5402785 | 20241026202414_l3re5 | UK00C2 | 2024-10-29T12:08:07.947Z | 2024-11-04T14:28:46.520Z |
5402662 | 5402662 | 20241026201132_k0xJF | UK00C2 | 2024-10-29T12:07:54.923Z | 2024-11-04T14:28:45.893Z |
5402290 | 5402290 | 20241026191011_L8XOc | UK00C2 | 2024-10-29T12:06:53.435Z | 2024-11-04T14:28:43.603Z |
5402282 | 5402282 | 20241026190926_Fh2Md | UK00C2 | 2024-10-29T12:06:52.250Z | 2024-11-04T14:28:43.595Z |
5402244 | 5402244 | 20241026190525_zPSdF | UK00C2 | 2024-10-29T12:06:43.391Z | 2024-11-04T14:28:43.326Z |
5399483 | 5399483 | 20241026042639_GP8u8 | UK00C2 | 2024-10-28T12:20:00.499Z | 2024-11-03T14:27:39.842Z |
5397064 | 5397064 | 20241026005940_zCzpA | UK00C2 | 2024-10-28T12:18:05.368Z | 2024-11-03T14:27:31.979Z |
5396783 | 5396783 | 20241026003248_AGjxn | UK00C2 | 2024-10-28T12:17:55.540Z | 2024-11-03T14:27:30.888Z |
5396761 | 5396761 | 20241026003053_MeuLc | UK00C2 | 2024-10-28T12:17:55.169Z | 2024-11-03T14:27:30.859Z |
5395574 | 5395574 | 20241025225522_2pqft | UK00C2 | 2024-10-28T12:16:28.107Z | 2024-11-03T14:27:26.062Z |
5395394 | 5395394 | 20241025223936_PELed | UK00C2 | 2024-10-28T12:16:11.998Z | 2024-11-03T14:27:25.423Z |
5386060 | 5386060 | 20241024235843_Q5yg6 | UK00C2 | 2024-10-27T12:19:48.103Z | 2024-11-02T12:28:30.650Z |
5384907 | 5384907 | 20241024211439_22Biw | UK00C2 | 2024-10-27T12:17:57.669Z | 2024-11-02T12:28:28.584Z |
5384889 | 5384889 | 20241024211249_NEU7H | UK00C2 | 2024-10-27T12:17:55.842Z | 2024-11-02T12:28:28.574Z |
5383393 | 5383393 | 20241024181717_Ad8DM | UK00C2 | 2024-10-27T12:15:23.016Z | 2024-11-02T12:28:25.102Z |
5378083 | 5378083 | 20241024052606_xa2xB | UK00C2 | 2024-10-26T12:22:54.219Z | 2024-11-01T12:27:03.276Z |
5378052 | 5378052 | 20241024052525_uw2Cu | UK00C2 | 2024-10-26T12:22:53.740Z | 2024-11-01T12:27:03.265Z |
5377853 | 5377853 | 20241024051448_9475l | UK00C2 | 2024-10-26T12:22:48.464Z | 2024-11-01T12:27:03.088Z |
5377777 | 5377777 | 20241024050923_2pBoi | UK00C2 | 2024-10-26T12:22:46.808Z | 2024-11-01T12:27:02.814Z |
5375826 | 5375826 | 20241024033205_Du9An | UK00C2 | 2024-10-26T12:21:41.193Z | 2024-11-01T12:27:01.213Z |
5363481 | 5363481 | 20241023210916_nDzBE | UK00C2 | 2024-10-25T12:16:15.220Z | 2024-11-01T12:26:53.317Z |
5362836 | 5362836 | 20241023200401_L3Kru | UK00C2 | 2024-10-25T12:15:11.628Z | 2024-11-01T12:26:52.472Z |
5351503 | 5351503 | 20241022233349_XN0Bl | UK00C2 | 2024-10-24T12:17:36.528Z | 2024-10-31T12:30:00.475Z |
5351134 | 5351134 | 20241022230019_4RhpW | UK00C2 | 2024-10-24T12:17:14.821Z | 2024-10-31T12:29:59.517Z |
5350127 | 5350127 | 20241022211517_a6QHa | UK00C2 | 2024-10-24T12:15:23.492Z | 2024-10-31T12:29:57.341Z |
5349228 | 5349228 | 20241022193507_jCC3J | UK00C2 | 2024-10-24T12:13:19.921Z | 2024-10-31T12:29:54.917Z |
5349031 | 5349031 | 20241022192054_ZIjDR | UK00C2 | 2024-10-24T12:12:55.376Z | 2024-10-31T12:29:54.506Z |
5348956 | 5348956 | 20241022191151_McGs9 | UK00C2 | 2024-10-24T12:12:38.403Z | 2024-10-31T12:29:54.233Z |
5338797 | 5338797 | 20241021203922_CRu6n | UK00C2 | 2024-10-23T12:11:56.409Z | 2024-10-30T12:26:42.801Z |
5321612 | 5321612 | 20241018052442_vDBsX | UK00C2 | 2024-10-19T12:07:53.966Z | 2024-10-26T12:27:57.052Z |
5321406 | 5321406 | 20241018044734_XmrLl | UK00C2 | 2024-10-19T12:07:22.497Z | 2024-10-26T12:27:56.610Z |
5321372 | 5321372 | 20241018044336_IY9t2 | UK00C2 | 2024-10-19T12:07:15.869Z | 2024-10-26T12:27:56.567Z |
5321323 | 5321323 | 20241018043156_XsDnQ | UK00C2 | 2024-10-19T12:07:12.036Z | 2024-10-26T12:27:56.505Z |
5321206 | 5321206 | 20241018040547_4qIhU | UK00C2 | 2024-10-19T12:07:01.102Z | 2024-10-26T12:27:56.347Z |
5321084 | 5321084 | 20241018034059_Hz0eg | UK00C2 | 2024-10-19T12:06:41.579Z | 2024-10-26T12:27:56.100Z |
5320920 | 5320920 | 20241018031308_V9rwA | UK00C2 | 2024-10-19T12:06:21.072Z | 2024-10-26T12:27:55.756Z |
5320799 | 5320799 | 20241018024500_EVmYQ | UK00C2 | 2024-10-19T12:06:10.900Z | 2024-10-26T12:27:55.362Z |
5320757 | 5320757 | 20241018023509_Rmn7M | UK00C2 | 2024-10-19T12:05:58.730Z | 2024-10-26T12:27:55.197Z |
5300645 | 5300645 | 20241012211041_NokBC | UK00C2 | 2024-10-14T12:14:20.052Z | 2024-10-21T12:23:50.820Z |
5300626 | 5300626 | 20241012210458_ciDZo | UK00C2 | 2024-10-14T12:14:19.439Z | 2024-10-21T12:23:50.581Z |
5291831 | 5291831 | 20241011220341_3Fnc3 | UK00C2 | 2024-10-13T12:15:17.736Z | 2024-10-20T12:24:36.782Z |
5291519 | 5291519 | 20241011211356_LgoOw | UK00C2 | 2024-10-13T12:14:42.420Z | 2024-10-20T12:24:32.505Z |
5291066 | 5291066 | 20241011195136_cCv15 | UK00C2 | 2024-10-13T12:13:54.529Z | 2024-10-20T12:24:24.848Z |
5290744 | 5290744 | 20241011184949_W3lRe | UK00C2 | 2024-10-13T12:13:14.198Z | 2024-10-20T12:24:19.775Z |
5290685 | 5290685 | 20241011183853_4MNX8 | UK00C2 | 2024-10-13T12:13:05.442Z | 2024-10-20T12:24:18.734Z |
5285440 | 5285440 | 20241011035716_Z39su | UK00C2 | 2024-10-12T12:18:10.027Z | 2024-10-19T12:28:02.713Z |
5282852 | 5282852 | 20241010235805_ZKdJE | UK00C2 | 2024-10-12T12:16:08.025Z | 2024-10-19T12:27:46.941Z |
5282820 | 5282820 | 20241010235036_Mlr1O | UK00C2 | 2024-10-12T12:16:05.309Z | 2024-10-19T12:27:46.733Z |
5282542 | 5282542 | 20241010221439_WRua3 | UK00C2 | 2024-10-12T12:15:43.643Z | 2024-10-19T12:27:44.647Z |
5282488 | 5282488 | 20241010215827_BE5h5 | UK00C2 | 2024-10-12T12:15:37.117Z | 2024-10-19T12:27:44.097Z |
5276879 | 5276879 | 20241011051543_oke7I | UK00C2 | 2024-10-12T12:01:58.554Z | 2024-10-20T12:23:14.888Z |
5276364 | 5276364 | 20241011043444_v7YDU | UK00C2 | 2024-10-12T12:00:56.675Z | 2024-10-20T12:23:08.309Z |
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);