participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,135 rows where station_code = "UK0062" 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 |
---|---|---|---|---|---|
5537575 | 5537575 | 20241112234215_B37CO | UK0062 | 2024-11-14T14:12:11.756Z | 2024-11-21T14:26:14.520Z |
5530531 | 5530531 | 20241112022626_2VeHV | UK0062 | 2024-11-13T14:14:20.641Z | 2024-11-20T14:26:01.230Z |
5529755 | 5529755 | 20241112010220_38bUj | UK0062 | 2024-11-13T14:13:09.320Z | 2024-11-20T14:25:47.933Z |
5529568 | 5529568 | 20241112003619_p22Xe | UK0062 | 2024-11-13T14:12:58.641Z | 2024-11-20T14:25:46.298Z |
5441328 | 5441328 | 20241029214306_w3mEN | UK0062 | 2024-11-01T12:18:26.434Z | 2024-11-07T14:26:41.722Z |
5433620 | 5433620 | 20241029203219_4XbNW | UK0062 | 2024-10-31T12:22:24.830Z | 2024-11-07T14:26:40.352Z |
5432055 | 5432055 | 20241029023701_J8Bq7 | UK0062 | 2024-10-31T12:20:59.292Z | 2024-11-06T14:27:25.840Z |
5364988 | 5364988 | 20241023230909_sS6uO | UK0062 | 2024-10-25T12:17:42.910Z | 2024-11-01T12:26:55.820Z |
5352580 | 5352580 | 20241023004041_4dHYN | UK0062 | 2024-10-24T12:18:58.617Z | 2024-10-31T12:30:02.917Z |
5350168 | 5350168 | 20241022211823_gDLt4 | UK0062 | 2024-10-24T12:15:26.260Z | 2024-10-31T12:29:57.468Z |
5349546 | 5349546 | 20241022201105_8ICUw | UK0062 | 2024-10-24T12:13:57.064Z | 2024-10-31T12:29:55.769Z |
5304345 | 5304345 | 20241013043847_UlC77 | UK0062 | 2024-10-14T12:17:48.351Z | 2024-10-21T12:24:24.852Z |
5302012 | 5302012 | 20241013002224_eRH7f | UK0062 | 2024-10-14T12:15:47.476Z | 2024-10-21T12:24:03.459Z |
5294915 | 5294915 | 20241013050709_7uQDd | UK0062 | 2024-10-14T12:00:37.293Z | 2024-10-22T12:24:06.601Z |
5294908 | 5294908 | 20241013050703_j4vez | UK0062 | 2024-10-14T12:00:36.885Z | 2024-10-22T12:24:06.538Z |
5294783 | 5294783 | 20241013044824_htWkL | UK0062 | 2024-10-14T12:00:20.624Z | 2024-10-22T12:24:05.461Z |
5285007 | 5285007 | 20241011032625_ayKOD | UK0062 | 2024-10-12T12:17:49.008Z | 2024-10-19T12:27:59.467Z |
5282980 | 5282980 | 20241011002407_fH39O | UK0062 | 2024-10-12T12:16:16.525Z | 2024-10-19T12:27:48.095Z |
5276821 | 5276821 | 20241011051233_4KQ8Q | UK0062 | 2024-10-12T12:01:49.178Z | 2024-10-20T12:23:14.171Z |
5276178 | 5276178 | 20241011042352_PKaPh | UK0062 | 2024-10-12T12:00:35.944Z | 2024-10-20T12:23:06.525Z |
5263014 | 5263014 | 20241008025654_7pPQb | UK0062 | 2024-10-09T12:16:35.789Z | 2024-10-16T12:21:21.181Z |
5255442 | 5255442 | 20241008042548_mRKc0 | UK0062 | 2024-10-09T12:01:13.038Z | 2024-10-17T12:19:52.301Z |
5255309 | 5255309 | 20241008040819_JR59P | UK0062 | 2024-10-09T12:00:59.510Z | 2024-10-17T12:19:51.723Z |
5253965 | 5253965 | 20241007011202_Fhbqs | UK0062 | 2024-10-08T12:13:55.921Z | 2024-10-15T12:29:12.557Z |
5247048 | 5247048 | 20241005013453_4a2h6 | UK0062 | 2024-10-07T12:18:50.208Z | 2024-10-13T12:26:25.660Z |
5247019 | 5247019 | 20241005013137_8kYPV | UK0062 | 2024-10-07T12:18:49.929Z | 2024-10-13T12:26:25.633Z |
5246995 | 5246995 | 20241005013002_fz82O | UK0062 | 2024-10-07T12:18:49.735Z | 2024-10-13T12:26:25.627Z |
5243877 | 5243877 | 20241005185024_skftG | UK0062 | 2024-10-07T12:14:13.817Z | 2024-10-14T12:24:32.173Z |
5240033 | 5240033 | 20241005045703_jEwlz | UK0062 | 2024-10-07T12:07:37.294Z | 2024-10-14T12:24:21.128Z |
5239101 | 5239101 | 20241005032727_I9njA | UK0062 | 2024-10-07T12:05:49.448Z | 2024-10-14T12:24:18.279Z |
5239042 | 5239042 | 20241005032200_LOmXb | UK0062 | 2024-10-07T12:05:40.094Z | 2024-10-14T12:24:18.047Z |
5236505 | 5236505 | 20241005010027_28E2T | UK0062 | 2024-10-06T12:17:36.084Z | 2024-10-13T12:26:25.158Z |
5227015 | 5227015 | 20241004005254_Mei70 | UK0062 | 2024-10-05T12:21:08.882Z | 2024-10-12T12:25:12.327Z |
5226212 | 5226212 | 20241003235605_3D3R8 | UK0062 | 2024-10-05T12:20:33.198Z | 2024-10-12T12:25:11.385Z |
5218502 | 5218502 | 20241004034507_euYCG | UK0062 | 2024-10-05T12:04:30.055Z | 2024-10-13T12:26:08.659Z |
5218105 | 5218105 | 20241004031605_GLoKC | UK0062 | 2024-10-05T12:03:29.680Z | 2024-10-13T12:26:07.872Z |
5217307 | 5217307 | 20241004021722_u9294 | UK0062 | 2024-10-05T12:01:05.973Z | 2024-10-13T12:26:06.750Z |
5217220 | 5217220 | 20241004021207_8qYJ2 | UK0062 | 2024-10-05T12:00:55.288Z | 2024-10-13T12:26:06.617Z |
5216868 | 5216868 | 20241003013251_WUNHd | UK0062 | 2024-10-04T12:13:52.323Z | 2024-10-11T12:23:37.853Z |
5216647 | 5216647 | 20241003011243_FX0xJ | UK0062 | 2024-10-04T12:13:35.580Z | 2024-10-11T12:23:37.621Z |
5215651 | 5215651 | 20241002235008_Mjk9G | UK0062 | 2024-10-04T12:12:11.808Z | 2024-10-11T12:23:35.702Z |
5215636 | 5215636 | 20241002234825_D2rzq | UK0062 | 2024-10-04T12:12:10.501Z | 2024-10-11T12:23:35.665Z |
5214601 | 5214601 | 20241002215911_3yl1O | UK0062 | 2024-10-04T12:10:34.224Z | 2024-10-11T12:23:33.930Z |
5214334 | 5214334 | 20241002212444_YheZs | UK0062 | 2024-10-04T12:10:01.398Z | 2024-10-11T12:23:33.369Z |
5211442 | 5211442 | 20241003014957_DP70Z | UK0062 | 2024-10-04T12:00:33.237Z | 2024-10-12T12:24:53.494Z |
5186459 | 5186459 | 20240929040927_L9aQE | UK0062 | 2024-09-30T12:06:54.841Z | 2024-10-07T12:21:20.641Z |
5186436 | 5186436 | 20240929040228_E3w90 | UK0062 | 2024-09-30T12:06:51.873Z | 2024-10-07T12:21:20.613Z |
5185319 | 5185319 | 20240929021552_rsQdK | UK0062 | 2024-09-30T12:04:02.795Z | 2024-10-07T12:21:17.582Z |
5185273 | 5185273 | 20240929021302_PAUjl | UK0062 | 2024-09-30T12:03:54.537Z | 2024-10-07T12:21:17.532Z |
5181005 | 5181005 | 20240927195744_KrevP | UK0062 | 2024-09-29T12:14:31.578Z | 2024-10-05T12:29:04.043Z |
5179462 | 5179462 | 20240928041133_x0frY | UK0062 | 2024-09-29T12:08:06.324Z | 2024-10-06T12:28:04.053Z |
5177405 | 5177405 | 20240928013859_BvSPI | UK0062 | 2024-09-29T12:04:14.458Z | 2024-10-06T12:27:55.006Z |
5176714 | 5176714 | 20240928005335_drJkj | UK0062 | 2024-09-29T12:02:51.610Z | 2024-10-06T12:27:52.172Z |
5133934 | 5133934 | 20240916041901_tzT48 | UK0062 | 2024-09-19T12:17:13.754Z | 2024-09-24T12:15:52.626Z |
5133699 | 5133699 | 20240916035130_ixNe7 | UK0062 | 2024-09-19T12:17:05.534Z | 2024-09-24T12:15:50.704Z |
5132939 | 5132939 | 20240916023025_7bUPG | UK0062 | 2024-09-19T12:16:38.045Z | 2024-09-24T12:15:46.265Z |
5132698 | 5132698 | 20240916015931_Bis2O | UK0062 | 2024-09-19T12:16:28.585Z | 2024-09-24T12:15:44.738Z |
5129717 | 5129717 | 20240917042446_4c0yQ | UK0062 | 2024-09-19T12:12:02.430Z | 2024-09-25T12:22:32.512Z |
5129373 | 5129373 | 20240917035455_GRAvj | UK0062 | 2024-09-19T12:11:34.191Z | 2024-09-25T12:22:30.537Z |
5128859 | 5128859 | 20240917024843_8lfcr | UK0062 | 2024-09-19T12:11:04.080Z | 2024-09-25T12:22:27.320Z |
5128698 | 5128698 | 20240917022511_pyqVJ | UK0062 | 2024-09-19T12:10:57.603Z | 2024-09-25T12:22:26.559Z |
5128206 | 5128206 | 20240917010746_jVw0C | UK0062 | 2024-09-19T12:10:20.294Z | 2024-09-25T12:22:23.910Z |
5120537 | 5120537 | 20240914032754_uE9bi | UK0062 | 2024-09-18T12:10:42.964Z | 2024-09-22T12:17:57.374Z |
5116036 | 5116036 | 20240915030422_BjdsF | UK0062 | 2024-09-18T12:06:35.055Z | 2024-09-23T12:16:20.226Z |
5115833 | 5115833 | 20240915025433_9ZS2s | UK0062 | 2024-09-18T12:06:26.622Z | 2024-09-23T12:16:19.728Z |
5115800 | 5115800 | 20240915025401_fOiNa | UK0062 | 2024-09-18T12:06:24.113Z | 2024-09-23T12:16:19.642Z |
5115687 | 5115687 | 20240915024901_cfo4B | UK0062 | 2024-09-18T12:06:21.189Z | 2024-09-23T12:16:18.483Z |
5115563 | 5115563 | 20240915024434_7N2Sy | UK0062 | 2024-09-18T12:06:17.830Z | 2024-09-23T12:16:17.490Z |
5114832 | 5114832 | 20240915020037_79AML | UK0062 | 2024-09-18T12:05:36.392Z | 2024-09-23T12:16:14.364Z |
5114621 | 5114621 | 20240915015225_PAl02 | UK0062 | 2024-09-18T12:05:25.859Z | 2024-09-23T12:16:13.822Z |
5112979 | 5112979 | 20240915001109_JKPUo | UK0062 | 2024-09-18T12:03:49.881Z | 2024-09-23T12:16:06.797Z |
5108192 | 5108192 | 20240913042950_cRSgj | UK0062 | 2024-09-17T12:13:32.481Z | 2024-09-21T12:16:37.342Z |
5108015 | 5108015 | 20240913042031_D9G3s | UK0062 | 2024-09-17T12:13:28.326Z | 2024-09-21T12:16:36.931Z |
5107765 | 5107765 | 20240913040937_NdYVv | UK0062 | 2024-09-17T12:13:23.553Z | 2024-09-21T12:16:36.547Z |
5107662 | 5107662 | 20240913040748_x4tvX | UK0062 | 2024-09-17T12:13:20.791Z | 2024-09-21T12:16:35.988Z |
5106546 | 5106546 | 20240913032846_X30ef | UK0062 | 2024-09-17T12:12:57.187Z | 2024-09-21T12:16:33.847Z |
5106238 | 5106238 | 20240913031554_OvOOU | UK0062 | 2024-09-17T12:12:45.346Z | 2024-09-21T12:16:33.025Z |
5105312 | 5105312 | 20240913024136_GZ2H1 | UK0062 | 2024-09-17T12:12:09.274Z | 2024-09-21T12:16:30.324Z |
5104653 | 5104653 | 20240913021814_1HhV8 | UK0062 | 2024-09-17T12:11:41.919Z | 2024-09-21T12:16:28.664Z |
5103367 | 5103367 | 20240913012914_waADd | UK0062 | 2024-09-17T12:10:55.282Z | 2024-09-21T12:16:24.820Z |
5103296 | 5103296 | 20240913012428_vJUXK | UK0062 | 2024-09-17T12:10:49.746Z | 2024-09-21T12:16:24.711Z |
5098292 | 5098292 | 20240913012412_Zi2Wf | UK0062 | 2024-09-16T12:17:22.217Z | 2024-09-21T12:16:24.701Z |
5097691 | 5097691 | 20240913005803_2vgkq | UK0062 | 2024-09-16T12:17:14.086Z | 2024-09-21T12:16:22.473Z |
5097609 | 5097609 | 20240913005648_SR4Vi | UK0062 | 2024-09-16T12:17:13.628Z | 2024-09-21T12:16:21.722Z |
5097405 | 5097405 | 20240913004545_EcmoU | UK0062 | 2024-09-16T12:17:12.255Z | 2024-09-21T12:16:20.485Z |
5094839 | 5094839 | 20240912042556_x1sh4 | UK0062 | 2024-09-16T12:14:59.343Z | 2024-09-20T12:21:56.005Z |
5093730 | 5093730 | 20240912033357_uP31N | UK0062 | 2024-09-16T12:14:24.686Z | 2024-09-20T12:21:54.062Z |
5093375 | 5093375 | 20240912031937_Gkdyr | UK0062 | 2024-09-16T12:14:16.120Z | 2024-09-20T12:21:53.383Z |
5093218 | 5093218 | 20240912031506_uvmvL | UK0062 | 2024-09-16T12:14:13.426Z | 2024-09-20T12:21:53.028Z |
5092852 | 5092852 | 20240912030003_9J4oV | UK0062 | 2024-09-16T12:14:05.558Z | 2024-09-20T12:21:51.843Z |
5092112 | 5092112 | 20240912023649_Dol26 | UK0062 | 2024-09-16T12:13:40.936Z | 2024-09-20T12:21:49.780Z |
5090441 | 5090441 | 20240912012524_QDmYC | UK0062 | 2024-09-16T12:12:20.295Z | 2024-09-20T12:21:44.997Z |
5090133 | 5090133 | 20240912011204_ejuB8 | UK0062 | 2024-09-16T12:12:01.658Z | 2024-09-20T12:21:44.561Z |
5090098 | 5090098 | 20240912011104_GijBU | UK0062 | 2024-09-16T12:12:00.422Z | 2024-09-20T12:21:44.556Z |
5088489 | 5088489 | 20240913001319_oXjVZ | UK0062 | 2024-09-16T12:08:05.627Z | 2024-09-21T12:16:18.415Z |
5088186 | 5088186 | 20240913000137_JRvC6 | UK0062 | 2024-09-16T12:07:47.876Z | 2024-09-21T12:16:17.672Z |
5088070 | 5088070 | 20240912235528_jrW6p | UK0062 | 2024-09-16T12:07:43.160Z | 2024-09-21T12:16:17.505Z |
5086670 | 5086670 | 20240912224522_DWUEI | UK0062 | 2024-09-16T12:05:57.448Z | 2024-09-21T12:16:11.219Z |
5086044 | 5086044 | 20240912220603_XiyJ3 | UK0062 | 2024-09-16T12:05:11.244Z | 2024-09-21T12:16:09.286Z |
5085995 | 5085995 | 20240912220424_PZfPX | UK0062 | 2024-09-16T12:05:09.848Z | 2024-09-21T12:16:09.233Z |
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);