participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
7,118 rows where station_code = "UK0049" 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 |
---|---|---|---|---|---|
5570725 | 5570725 | 20241120204514_HVW3O | UK0049 | 2024-11-22T14:16:02.159Z | 2024-11-22T14:19:21.969Z |
5570634 | 5570634 | 20241120203251_HWYlT | UK0049 | 2024-11-22T14:15:57.632Z | 2024-11-22T14:19:21.954Z |
5570520 | 5570520 | 20241120195158_3BrVc | UK0049 | 2024-11-22T14:15:39.536Z | 2024-11-22T14:19:21.930Z |
5570285 | 5570285 | 20241120191243_506qi | UK0049 | 2024-11-22T14:15:06.113Z | 2024-11-22T14:19:21.892Z |
5570187 | 5570187 | 20241120185713_mtXmt | UK0049 | 2024-11-22T14:14:58.453Z | 2024-11-22T14:19:21.877Z |
5570086 | 5570086 | 20241120183900_LW6X4 | UK0049 | 2024-11-22T14:14:49.911Z | 2024-11-22T14:19:21.858Z |
5565396 | 5565396 | 20241120042225_8BGbB | UK0049 | 2024-11-21T14:18:47.729Z | 2024-11-22T14:21:46.413Z |
5565350 | 5565350 | 20241120042057_k2nGT | UK0049 | 2024-11-21T14:18:47.112Z | 2024-11-22T14:21:46.150Z |
5565261 | 5565261 | 20241120040846_SL1dO | UK0049 | 2024-11-21T14:18:44.025Z | 2024-11-22T14:21:44.777Z |
5565073 | 5565073 | 20241120035033_dxUny | UK0049 | 2024-11-21T14:18:28.415Z | 2024-11-22T14:21:41.341Z |
5565040 | 5565040 | 20241120034535_3lqSv | UK0049 | 2024-11-21T14:18:23.436Z | 2024-11-22T14:21:40.520Z |
5565005 | 5565005 | 20241120034414_5Vdek | UK0049 | 2024-11-21T14:18:18.844Z | 2024-11-22T14:21:40.215Z |
5564816 | 5564816 | 20241120032910_W8T1X | UK0049 | 2024-11-21T14:18:05.332Z | 2024-11-22T14:21:36.725Z |
5564737 | 5564737 | 20241120032435_BeM9o | UK0049 | 2024-11-21T14:18:01.528Z | 2024-11-22T14:21:36.186Z |
5564613 | 5564613 | 20241120031418_BG2qX | UK0049 | 2024-11-21T14:17:53.180Z | 2024-11-22T14:21:34.417Z |
5564467 | 5564467 | 20241120025859_ZV0li | UK0049 | 2024-11-21T14:17:39.476Z | 2024-11-22T14:21:32.607Z |
5564283 | 5564283 | 20241120024505_XOhp6 | UK0049 | 2024-11-21T14:17:24.408Z | 2024-11-22T14:21:29.994Z |
5563881 | 5563881 | 20241120021216_RHPRj | UK0049 | 2024-11-21T14:16:53.430Z | 2024-11-22T14:21:24.453Z |
5563704 | 5563704 | 20241120015822_YKFTE | UK0049 | 2024-11-21T14:16:35.202Z | 2024-11-22T14:21:21.216Z |
5563428 | 5563428 | 20241120012913_QvcuA | UK0049 | 2024-11-21T14:16:05.912Z | 2024-11-22T14:21:15.511Z |
5563310 | 5563310 | 20241120011610_KC4wl | UK0049 | 2024-11-21T14:15:52.391Z | 2024-11-22T14:21:12.603Z |
5562724 | 5562724 | 20241120000532_pwCAX | UK0049 | 2024-11-21T14:15:18.357Z | 2024-11-22T14:21:03.004Z |
5562033 | 5562033 | 20241119224744_802o7 | UK0049 | 2024-11-21T14:14:21.086Z | 2024-11-22T14:20:51.813Z |
5561917 | 5561917 | 20241119222847_AIU57 | UK0049 | 2024-11-21T14:14:13.752Z | 2024-11-22T14:20:49.364Z |
5561817 | 5561817 | 20241119221347_AOuoL | UK0049 | 2024-11-21T14:14:08.333Z | 2024-11-22T14:20:47.066Z |
5561579 | 5561579 | 20241119210932_5YHL8 | UK0049 | 2024-11-21T14:13:29.792Z | 2024-11-22T14:20:41.218Z |
5543958 | 5543958 | 20241115045627_vtm52 | UK0049 | 2024-11-16T14:07:45.300Z | 2024-11-22T14:24:02.833Z |
5543805 | 5543805 | 20241115033915_IJjFG | UK0049 | 2024-11-16T14:07:15.740Z | 2024-11-22T14:24:01.673Z |
5543785 | 5543785 | 20241115033447_LcW2S | UK0049 | 2024-11-16T14:07:13.631Z | 2024-11-22T14:24:01.513Z |
5543747 | 5543747 | 20241115031639_RPIDC | UK0049 | 2024-11-16T14:07:07.700Z | 2024-11-22T14:24:01.121Z |
5543701 | 5543701 | 20241115030201_DwSZR | UK0049 | 2024-11-16T14:07:03.356Z | 2024-11-22T14:24:00.856Z |
5543644 | 5543644 | 20241115024147_dcgI8 | UK0049 | 2024-11-16T14:06:57.947Z | 2024-11-22T14:24:00.553Z |
5543564 | 5543564 | 20241115021248_6cJCk | UK0049 | 2024-11-16T14:06:43.583Z | 2024-11-22T14:24:00.037Z |
5543495 | 5543495 | 20241115014728_6SQi4 | UK0049 | 2024-11-16T14:06:31.983Z | 2024-11-22T14:23:59.724Z |
5543454 | 5543454 | 20241115012859_dQ8jg | UK0049 | 2024-11-16T14:06:23.773Z | 2024-11-22T14:23:59.371Z |
5538916 | 5538916 | 20241113051934_M42Hp | UK0049 | 2024-11-14T14:14:03.933Z | 2024-11-21T14:26:29.745Z |
5538901 | 5538901 | 20241113051255_7jmJi | UK0049 | 2024-11-14T14:14:03.149Z | 2024-11-21T14:26:29.662Z |
5538786 | 5538786 | 20241113045737_fbZsB | UK0049 | 2024-11-14T14:13:57.570Z | 2024-11-21T14:26:28.753Z |
5532399 | 5532399 | 20241112051837_2jsja | UK0049 | 2024-11-13T14:16:42.683Z | 2024-11-20T14:26:22.712Z |
5531456 | 5531456 | 20241112034035_XVcr2 | UK0049 | 2024-11-13T14:15:40.505Z | 2024-11-20T14:26:11.374Z |
5531173 | 5531173 | 20241112031935_CrCLa | UK0049 | 2024-11-13T14:15:22.131Z | 2024-11-20T14:26:08.418Z |
5529753 | 5529753 | 20241112010220_38bUj | UK0049 | 2024-11-13T14:13:09.319Z | 2024-11-20T14:25:47.933Z |
5529596 | 5529596 | 20241112004025_fXG6X | UK0049 | 2024-11-13T14:13:00.854Z | 2024-11-20T14:25:46.710Z |
5529567 | 5529567 | 20241112003619_p22Xe | UK0049 | 2024-11-13T14:12:58.641Z | 2024-11-20T14:25:46.298Z |
5529421 | 5529421 | 20241112001740_942rh | UK0049 | 2024-11-13T14:12:43.388Z | 2024-11-20T14:25:44.621Z |
5523891 | 5523891 | 20241111024359_CRZFa | UK0049 | 2024-11-12T14:16:19.141Z | 2024-11-19T14:22:15.717Z |
5523687 | 5523687 | 20241111020651_DowG7 | UK0049 | 2024-11-12T14:16:07.506Z | 2024-11-19T14:22:14.353Z |
5451324 | 5451324 | 20241031233234_fSZI5 | UK0049 | 2024-11-02T12:16:53.309Z | 2024-11-09T14:24:23.073Z |
5441688 | 5441688 | 20241029231105_493rL | UK0049 | 2024-11-01T12:18:53.156Z | 2024-11-07T14:26:43.009Z |
5441685 | 5441685 | 20241029231033_zoQCL | UK0049 | 2024-11-01T12:18:52.973Z | 2024-11-07T14:26:42.995Z |
5441327 | 5441327 | 20241029214306_w3mEN | UK0049 | 2024-11-01T12:18:26.434Z | 2024-11-07T14:26:41.722Z |
5441238 | 5441238 | 20241029211820_bMcvI | UK0049 | 2024-11-01T12:18:20.598Z | 2024-11-07T14:26:41.357Z |
5433609 | 5433609 | 20241029203124_xpST3 | UK0049 | 2024-10-31T12:22:24.367Z | 2024-11-07T14:26:40.316Z |
5433450 | 5433450 | 20241029200007_RdE4V | UK0049 | 2024-10-31T12:22:16.504Z | 2024-11-07T14:26:39.654Z |
5410828 | 5410828 | 20241027053957_mtQzN | UK0049 | 2024-10-29T12:18:05.850Z | 2024-11-04T14:29:05.637Z |
5410515 | 5410515 | 20241027051622_VhkyR | UK0049 | 2024-10-29T12:17:57.451Z | 2024-11-04T14:29:04.714Z |
5405514 | 5405514 | 20241027004003_eZt4a | UK0049 | 2024-10-29T12:12:59.731Z | 2024-11-04T14:28:53.581Z |
5404252 | 5404252 | 20241026231208_R2WjD | UK0049 | 2024-10-29T12:11:03.268Z | 2024-11-04T14:28:50.555Z |
5404051 | 5404051 | 20241026225453_4WnQH | UK0049 | 2024-10-29T12:10:51.012Z | 2024-11-04T14:28:50.276Z |
5404026 | 5404026 | 20241026225341_GOqcS | UK0049 | 2024-10-29T12:10:48.642Z | 2024-11-04T14:28:50.252Z |
5402609 | 5402609 | 20241026200426_Gll2y | UK0049 | 2024-10-29T12:07:48.002Z | 2024-11-04T14:28:45.609Z |
5398713 | 5398713 | 20241026032144_Fl0F8 | UK0049 | 2024-10-28T12:19:29.458Z | 2024-11-03T14:27:37.888Z |
5375112 | 5375112 | 20241024025802_BV4G9 | UK0049 | 2024-10-26T12:21:13.284Z | 2024-11-01T12:27:00.290Z |
5375069 | 5375069 | 20241024025537_CS2hK | UK0049 | 2024-10-26T12:21:11.705Z | 2024-11-01T12:27:00.177Z |
5363771 | 5363771 | 20241023214253_PZ3o9 | UK0049 | 2024-10-25T12:16:43.570Z | 2024-11-01T12:26:53.617Z |
5362067 | 5362067 | 20241023190539_Ouoa3 | UK0049 | 2024-10-25T12:13:49.216Z | 2024-11-01T12:26:50.940Z |
5361986 | 5361986 | 20241023190036_00FD1 | UK0049 | 2024-10-25T12:13:44.342Z | 2024-11-01T12:26:50.795Z |
5361187 | 5361187 | 20241023175734_6kieZ | UK0049 | 2024-10-25T12:12:26.423Z | 2024-11-01T12:26:49.504Z |
5350818 | 5350818 | 20241022223042_hb7b9 | UK0049 | 2024-10-24T12:16:37.648Z | 2024-10-31T12:29:58.825Z |
5349786 | 5349786 | 20241022203516_BW3tR | UK0049 | 2024-10-24T12:14:38.623Z | 2024-10-31T12:29:56.320Z |
5349159 | 5349159 | 20241022192955_7MJqp | UK0049 | 2024-10-24T12:13:14.097Z | 2024-10-31T12:29:54.658Z |
5349054 | 5349054 | 20241022192304_PlB0X | UK0049 | 2024-10-24T12:13:02.722Z | 2024-10-31T12:29:54.521Z |
5345118 | 5345118 | 20241022051333_sQ9AW | UK0049 | 2024-10-23T12:19:06.931Z | 2024-10-30T12:26:52.195Z |
5344892 | 5344892 | 20241022045500_VUDx2 | UK0049 | 2024-10-23T12:18:56.785Z | 2024-10-30T12:26:51.945Z |
5341684 | 5341684 | 20241022014847_1INSJ | UK0049 | 2024-10-23T12:16:06.998Z | 2024-10-30T12:26:47.337Z |
5341162 | 5341162 | 20241022011843_iroM2 | UK0049 | 2024-10-23T12:15:26.223Z | 2024-10-30T12:26:46.643Z |
5340654 | 5340654 | 20241022004025_2PaPq | UK0049 | 2024-10-23T12:14:46.240Z | 2024-10-30T12:26:46.116Z |
5340341 | 5340341 | 20241022000721_oL2fK | UK0049 | 2024-10-23T12:14:29.232Z | 2024-10-30T12:26:45.690Z |
5339825 | 5339825 | 20241021232029_SrKrb | UK0049 | 2024-10-23T12:13:53.687Z | 2024-10-30T12:26:44.982Z |
5338755 | 5338755 | 20241021203128_qi1CO | UK0049 | 2024-10-23T12:11:51.755Z | 2024-10-30T12:26:42.750Z |
5332575 | 5332575 | 20241020205604_qP5pS | UK0049 | 2024-10-22T12:13:38.211Z | 2024-10-29T12:26:33.562Z |
5332529 | 5332529 | 20241020202900_7tKwZ | UK0049 | 2024-10-22T12:13:24.791Z | 2024-10-29T12:26:33.473Z |
5332396 | 5332396 | 20241020192545_Y8zS5 | UK0049 | 2024-10-22T12:12:52.906Z | 2024-10-29T12:26:33.071Z |
5319665 | 5319665 | 20241017194312_RU3Rs | UK0049 | 2024-10-19T12:03:30.220Z | 2024-10-26T12:27:52.819Z |
5318695 | 5318695 | 20241017044034_FvMCu | UK0049 | 2024-10-18T12:04:17.809Z | 2024-10-25T12:24:36.560Z |
5318537 | 5318537 | 20241017034535_Z6FFH | UK0049 | 2024-10-18T12:03:57.867Z | 2024-10-25T12:24:36.157Z |
5318455 | 5318455 | 20241017032922_NtvEm | UK0049 | 2024-10-18T12:03:49.891Z | 2024-10-25T12:24:35.629Z |
5317540 | 5317540 | 20241017053503_0VUuX | UK0049 | 2024-10-18T12:00:07.890Z | 2024-10-26T12:27:50.180Z |
5304294 | 5304294 | 20241013043412_GIyEV | UK0049 | 2024-10-14T12:17:47.373Z | 2024-10-21T12:24:24.633Z |
5304219 | 5304219 | 20241013042909_C9c2o | UK0049 | 2024-10-14T12:17:45.024Z | 2024-10-21T12:24:24.439Z |
5304062 | 5304062 | 20241013040732_CG2G4 | UK0049 | 2024-10-14T12:17:41.971Z | 2024-10-21T12:24:23.052Z |
5303965 | 5303965 | 20241013035459_N2JK7 | UK0049 | 2024-10-14T12:17:39.316Z | 2024-10-21T12:24:22.245Z |
5301348 | 5301348 | 20241012231259_q3vuf | UK0049 | 2024-10-14T12:15:21.466Z | 2024-10-21T12:23:57.827Z |
5300754 | 5300754 | 20241012213828_O9Om7 | UK0049 | 2024-10-14T12:14:26.095Z | 2024-10-21T12:23:52.330Z |
5300498 | 5300498 | 20241012204431_nb2N3 | UK0049 | 2024-10-14T12:14:11.477Z | 2024-10-21T12:23:49.533Z |
5294853 | 5294853 | 20241013050121_WCoLn | UK0049 | 2024-10-14T12:00:27.875Z | 2024-10-22T12:24:06.106Z |
5294764 | 5294764 | 20241013044512_l3gc1 | UK0049 | 2024-10-14T12:00:18.252Z | 2024-10-22T12:24:05.229Z |
5290978 | 5290978 | 20241011193039_geCQQ | UK0049 | 2024-10-13T12:13:48.235Z | 2024-10-20T12:24:23.442Z |
5285493 | 5285493 | 20241011040005_aq9Be | UK0049 | 2024-10-12T12:18:11.360Z | 2024-10-19T12:28:02.931Z |
5285377 | 5285377 | 20241011035339_QlKnb | UK0049 | 2024-10-12T12:18:07.533Z | 2024-10-19T12:28:02.327Z |
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);