participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
7,046 rows where station_code = "UK0025" 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 |
---|---|---|---|---|---|
5454259 | 5454259 | 20241031040354_hkiBg | UK0025 | 2024-11-02T12:22:56.908Z | 2024-11-08T14:23:21.765Z |
5454062 | 5454062 | 20241031033821_PBtx3 | UK0025 | 2024-11-02T12:22:49.869Z | 2024-11-08T14:23:20.229Z |
5453980 | 5453980 | 20241031032441_Gyu6L | UK0025 | 2024-11-02T12:22:46.779Z | 2024-11-08T14:23:19.826Z |
5453835 | 5453835 | 20241031030755_6KDsY | UK0025 | 2024-11-02T12:22:43.461Z | 2024-11-08T14:23:19.263Z |
5453339 | 5453339 | 20241031020400_pjgDD | UK0025 | 2024-11-02T12:22:32.081Z | 2024-11-08T14:23:16.773Z |
5453264 | 5453264 | 20241031015500_oTEaF | UK0025 | 2024-11-02T12:22:30.566Z | 2024-11-08T14:23:16.282Z |
5453184 | 5453184 | 20241031014900_5Hnfu | UK0025 | 2024-11-02T12:22:29.301Z | 2024-11-08T14:23:16.145Z |
5444497 | 5444497 | 20241031012628_qILci | UK0025 | 2024-11-01T12:21:20.487Z | 2024-11-08T14:23:15.758Z |
5444440 | 5444440 | 20241031012200_Jm3Wr | UK0025 | 2024-11-01T12:21:18.129Z | 2024-11-08T14:23:15.594Z |
5444380 | 5444380 | 20241031011512_wIvKY | UK0025 | 2024-11-01T12:21:15.126Z | 2024-11-08T14:23:15.210Z |
5444350 | 5444350 | 20241031011055_yg9YQ | UK0025 | 2024-11-01T12:21:13.729Z | 2024-11-08T14:23:14.617Z |
5444184 | 5444184 | 20241031005630_k22LO | UK0025 | 2024-11-01T12:21:08.370Z | 2024-11-08T14:23:14.070Z |
5444119 | 5444119 | 20241031004941_pD2Nm | UK0025 | 2024-11-01T12:21:06.666Z | 2024-11-08T14:23:13.991Z |
5444065 | 5444065 | 20241031004354_dLm70 | UK0025 | 2024-11-01T12:21:04.380Z | 2024-11-08T14:23:13.777Z |
5444045 | 5444045 | 20241031004148_suqGe | UK0025 | 2024-11-01T12:21:03.312Z | 2024-11-08T14:23:13.616Z |
5443993 | 5443993 | 20241031003623_LZIfw | UK0025 | 2024-11-01T12:21:00.891Z | 2024-11-08T14:23:13.444Z |
5443785 | 5443785 | 20241031001540_C7KQu | UK0025 | 2024-11-01T12:20:51.491Z | 2024-11-08T14:23:12.451Z |
5443692 | 5443692 | 20241031000525_nXwxN | UK0025 | 2024-11-01T12:20:46.488Z | 2024-11-08T14:23:11.997Z |
5440954 | 5440954 | 20241030233013_klOD0 | UK0025 | 2024-11-01T12:16:04.317Z | 2024-11-08T14:23:11.331Z |
5440881 | 5440881 | 20241030231813_X4ksq | UK0025 | 2024-11-01T12:15:56.966Z | 2024-11-08T14:23:10.863Z |
5440863 | 5440863 | 20241030231622_fZXTr | UK0025 | 2024-11-01T12:15:55.684Z | 2024-11-08T14:23:10.838Z |
5440798 | 5440798 | 20241030230826_lrVfR | UK0025 | 2024-11-01T12:15:52.092Z | 2024-11-08T14:23:10.739Z |
5440747 | 5440747 | 20241030230026_oWN2D | UK0025 | 2024-11-01T12:15:48.625Z | 2024-11-08T14:23:10.609Z |
5440722 | 5440722 | 20241030225503_aqQ4K | UK0025 | 2024-11-01T12:15:47.550Z | 2024-11-08T14:23:10.531Z |
5440651 | 5440651 | 20241030224044_Z0Yo1 | UK0025 | 2024-11-01T12:15:41.922Z | 2024-11-08T14:23:10.209Z |
5440458 | 5440458 | 20241030221503_tYKjD | UK0025 | 2024-11-01T12:15:31.934Z | 2024-11-08T14:23:09.517Z |
5440205 | 5440205 | 20241030214320_2wrRa | UK0025 | 2024-11-01T12:14:58.114Z | 2024-11-08T14:23:07.709Z |
5440141 | 5440141 | 20241030213007_kgq9c | UK0025 | 2024-11-01T12:14:53.913Z | 2024-11-08T14:23:07.574Z |
5440007 | 5440007 | 20241030210651_l7aCB | UK0025 | 2024-11-01T12:14:44.262Z | 2024-11-08T14:23:06.789Z |
5432960 | 5432960 | 20241029052633_da7Oy | UK0025 | 2024-10-31T12:21:41.144Z | 2024-11-06T14:27:29.395Z |
5432827 | 5432827 | 20241029045056_1DtDu | UK0025 | 2024-10-31T12:21:36.195Z | 2024-11-06T14:27:28.835Z |
5432807 | 5432807 | 20241029044145_TUeLS | UK0025 | 2024-10-31T12:21:35.724Z | 2024-11-06T14:27:28.769Z |
5432485 | 5432485 | 20241029034015_qC56m | UK0025 | 2024-10-31T12:21:24.195Z | 2024-11-06T14:27:27.610Z |
5432475 | 5432475 | 20241029033808_4b9aN | UK0025 | 2024-10-31T12:21:23.922Z | 2024-11-06T14:27:27.602Z |
5432447 | 5432447 | 20241029033626_Xd2Vh | UK0025 | 2024-10-31T12:21:22.881Z | 2024-11-06T14:27:27.499Z |
5432395 | 5432395 | 20241029032606_zoc4V | UK0025 | 2024-10-31T12:21:20.709Z | 2024-11-06T14:27:26.805Z |
5430985 | 5430985 | 20241029001206_1NNQs | UK0025 | 2024-10-31T12:19:25.507Z | 2024-11-06T14:27:22.404Z |
5430713 | 5430713 | 20241028232751_u1sYA | UK0025 | 2024-10-31T12:18:54.432Z | 2024-11-06T14:27:21.156Z |
5430697 | 5430697 | 20241028232451_2y3Ux | UK0025 | 2024-10-31T12:18:53.366Z | 2024-11-06T14:27:21.094Z |
5430650 | 5430650 | 20241028231504_u7rvA | UK0025 | 2024-10-31T12:18:46.548Z | 2024-11-06T14:27:20.944Z |
5430613 | 5430613 | 20241028231203_O9CJ4 | UK0025 | 2024-10-31T12:18:43.161Z | 2024-11-06T14:27:20.702Z |
5422978 | 5422978 | 20241027011550_xMiev | UK0025 | 2024-10-30T12:22:35.750Z | 2024-11-04T14:28:55.116Z |
5421212 | 5421212 | 20241028050700_D2Alj | UK0025 | 2024-10-30T12:19:43.242Z | 2024-11-05T14:27:17.791Z |
5410746 | 5410746 | 20241027053357_oQ1Ry | UK0025 | 2024-10-29T12:18:04.086Z | 2024-11-04T14:29:05.376Z |
5410568 | 5410568 | 20241027051839_CHur0 | UK0025 | 2024-10-29T12:17:58.376Z | 2024-11-04T14:29:04.981Z |
5410460 | 5410460 | 20241027051425_j4kW6 | UK0025 | 2024-10-29T12:17:56.381Z | 2024-11-04T14:29:04.630Z |
5410385 | 5410385 | 20241027051052_4qk7q | UK0025 | 2024-10-29T12:17:55.061Z | 2024-11-04T14:29:04.493Z |
5408809 | 5408809 | 20241027034408_gEJys | UK0025 | 2024-10-29T12:16:53.312Z | 2024-11-04T14:29:00.559Z |
5406439 | 5406439 | 20241027013754_krzSl | UK0025 | 2024-10-29T12:14:09.697Z | 2024-11-04T14:28:55.705Z |
5406435 | 5406435 | 20241027013747_3HORs | UK0025 | 2024-10-29T12:14:09.554Z | 2024-11-04T14:28:55.703Z |
5406261 | 5406261 | 20241027012412_L73YV | UK0025 | 2024-10-29T12:13:59.720Z | 2024-11-04T14:28:55.270Z |
5406228 | 5406228 | 20241027012253_zpjxk | UK0025 | 2024-10-29T12:13:58.236Z | 2024-11-04T14:28:55.230Z |
5406200 | 5406200 | 20241027012125_S2pCb | UK0025 | 2024-10-29T12:13:57.098Z | 2024-11-04T14:28:55.205Z |
5406047 | 5406047 | 20241027011309_Rq9zL | UK0025 | 2024-10-29T12:13:49.103Z | 2024-11-04T14:28:54.901Z |
5406014 | 5406014 | 20241027011214_RRwA9 | UK0025 | 2024-10-29T12:13:48.051Z | 2024-11-04T14:28:54.885Z |
5405144 | 5405144 | 20241027001553_rKOVQ | UK0025 | 2024-10-29T12:12:32.800Z | 2024-11-04T14:28:52.726Z |
5405082 | 5405082 | 20241027001237_FwTiD | UK0025 | 2024-10-29T12:12:24.161Z | 2024-11-04T14:28:52.662Z |
5405063 | 5405063 | 20241027001145_y2Fmy | UK0025 | 2024-10-29T12:12:22.362Z | 2024-11-04T14:28:52.653Z |
5404674 | 5404674 | 20241026234317_3YANw | UK0025 | 2024-10-29T12:11:50.014Z | 2024-11-04T14:28:51.508Z |
5404235 | 5404235 | 20241026231116_rTsn3 | UK0025 | 2024-10-29T12:11:02.883Z | 2024-11-04T14:28:50.549Z |
5404214 | 5404214 | 20241026230945_88JPM | UK0025 | 2024-10-29T12:11:01.102Z | 2024-11-04T14:28:50.460Z |
5404123 | 5404123 | 20241026230041_5n5Mx | UK0025 | 2024-10-29T12:10:54.861Z | 2024-11-04T14:28:50.344Z |
5403999 | 5403999 | 20241026225239_Xz8bw | UK0025 | 2024-10-29T12:10:46.897Z | 2024-11-04T14:28:50.194Z |
5403689 | 5403689 | 20241026222336_MH2h4 | UK0025 | 2024-10-29T12:10:07.836Z | 2024-11-04T14:28:49.488Z |
5402944 | 5402944 | 20241026204844_fz5J3 | UK0025 | 2024-10-29T12:08:37.848Z | 2024-11-04T14:28:47.014Z |
5402928 | 5402928 | 20241026204806_7euYi | UK0025 | 2024-10-29T12:08:36.807Z | 2024-11-04T14:28:46.995Z |
5402917 | 5402917 | 20241026204627_2JJ8H | UK0025 | 2024-10-29T12:08:36.208Z | 2024-11-04T14:28:46.986Z |
5402709 | 5402709 | 20241026201613_ywkCu | UK0025 | 2024-10-29T12:07:59.186Z | 2024-11-04T14:28:46.309Z |
5402599 | 5402599 | 20241026200406_4C2r1 | UK0025 | 2024-10-29T12:07:47.306Z | 2024-11-04T14:28:45.521Z |
5402449 | 5402449 | 20241026193916_qskDx | UK0025 | 2024-10-29T12:07:19.739Z | 2024-11-04T14:28:44.496Z |
5402249 | 5402249 | 20241026190615_7Ca0D | UK0025 | 2024-10-29T12:06:44.434Z | 2024-11-04T14:28:43.331Z |
5402193 | 5402193 | 20241026185632_mtqOR | UK0025 | 2024-10-29T12:06:36.406Z | 2024-11-04T14:28:42.832Z |
5402165 | 5402165 | 20241026185249_IzSe8 | UK0025 | 2024-10-29T12:06:33.414Z | 2024-11-04T14:28:42.737Z |
5402080 | 5402080 | 20241026184157_1G8ta | UK0025 | 2024-10-29T12:06:22.836Z | 2024-11-04T14:28:42.218Z |
5401907 | 5401907 | 20241026180359_eJ4Zk | UK0025 | 2024-10-29T12:05:47.749Z | 2024-11-04T14:28:40.900Z |
5398335 | 5398335 | 20241026024511_5Z2kz | UK0025 | 2024-10-28T12:19:11.032Z | 2024-11-03T14:27:35.901Z |
5397735 | 5397735 | 20241026015229_oB2QR | UK0025 | 2024-10-28T12:18:38.055Z | 2024-11-03T14:27:34.023Z |
5397723 | 5397723 | 20241026015142_CA3ZU | UK0025 | 2024-10-28T12:18:37.135Z | 2024-11-03T14:27:33.961Z |
5397361 | 5397361 | 20241026012222_WSwIo | UK0025 | 2024-10-28T12:18:18.065Z | 2024-11-03T14:27:32.746Z |
5397274 | 5397274 | 20241026011415_9WWx2 | UK0025 | 2024-10-28T12:18:14.034Z | 2024-11-03T14:27:32.478Z |
5397201 | 5397201 | 20241026011031_Y5RWE | UK0025 | 2024-10-28T12:18:11.123Z | 2024-11-03T14:27:32.186Z |
5397016 | 5397016 | 20241026005613_TUfdc | UK0025 | 2024-10-28T12:18:02.928Z | 2024-11-03T14:27:31.742Z |
5396950 | 5396950 | 20241026004908_Zli4t | UK0025 | 2024-10-28T12:18:00.467Z | 2024-11-03T14:27:31.525Z |
5396565 | 5396565 | 20241026001255_Kh7YX | UK0025 | 2024-10-28T12:17:49.945Z | 2024-11-03T14:27:30.275Z |
5396552 | 5396552 | 20241026001135_GXhzF | UK0025 | 2024-10-28T12:17:49.520Z | 2024-11-03T14:27:30.184Z |
5396243 | 5396243 | 20241025235025_MO6ez | UK0025 | 2024-10-28T12:17:28.610Z | 2024-11-03T14:27:29.038Z |
5396131 | 5396131 | 20241025234202_0QjA7 | UK0025 | 2024-10-28T12:17:19.993Z | 2024-11-03T14:27:28.605Z |
5396119 | 5396119 | 20241025234132_irMl3 | UK0025 | 2024-10-28T12:17:19.242Z | 2024-11-03T14:27:28.601Z |
5395219 | 5395219 | 20241025222152_3TpN2 | UK0025 | 2024-10-28T12:16:01.583Z | 2024-11-03T14:27:24.313Z |
5395111 | 5395111 | 20241025221201_43A9u | UK0025 | 2024-10-28T12:15:57.218Z | 2024-11-03T14:27:24.031Z |
5372994 | 5372994 | 20241024011749_rCm1h | UK0025 | 2024-10-26T12:19:51.635Z | 2024-11-01T12:26:58.060Z |
5372899 | 5372899 | 20241024011316_F3AUU | UK0025 | 2024-10-26T12:19:47.281Z | 2024-11-01T12:26:58.017Z |
5372585 | 5372585 | 20241024005617_2LQAM | UK0025 | 2024-10-26T12:19:31.724Z | 2024-11-01T12:26:57.735Z |
5372358 | 5372358 | 20241024004528_VR2Xg | UK0025 | 2024-10-26T12:19:21.855Z | 2024-11-01T12:26:57.415Z |
5372084 | 5372084 | 20241024003151_2FxSv | UK0025 | 2024-10-26T12:19:07.048Z | 2024-11-01T12:26:57.087Z |
5366390 | 5366390 | 20241024001839_HLbL8 | UK0025 | 2024-10-25T12:18:25.436Z | 2024-11-01T12:26:56.929Z |
5365939 | 5365939 | 20241023235755_P2gsf | UK0025 | 2024-10-25T12:18:10.787Z | 2024-11-01T12:26:56.498Z |
5365271 | 5365271 | 20241023232348_6XBuG | UK0025 | 2024-10-25T12:17:53.538Z | 2024-11-01T12:26:56.012Z |
5362050 | 5362050 | 20241023190447_m93hj | UK0025 | 2024-10-25T12:13:48.107Z | 2024-11-01T12:26:50.918Z |
5352892 | 5352892 | 20241023005516_T5mKQ | UK0025 | 2024-10-24T12:19:23.726Z | 2024-10-31T12:30:03.512Z |
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);