participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,110 rows where station_code = "UK001M" 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 |
---|---|---|---|---|---|
5502913 | 5502913 | 20241107201119_PL4Hl | UK001M | 2024-11-09T14:12:12.183Z | 2024-11-12T14:24:41.573Z |
5502356 | 5502356 | 20241107181208_tvGs8 | UK001M | 2024-11-09T14:11:12.992Z | 2024-11-12T14:24:32.986Z |
5410442 | 5410442 | 20241027051311_2TBK8 | UK001M | 2024-10-29T12:17:55.799Z | 2024-11-04T14:29:04.601Z |
5409723 | 5409723 | 20241027043228_0ugNh | UK001M | 2024-10-29T12:17:39.447Z | 2024-11-04T14:29:02.186Z |
5409633 | 5409633 | 20241027042855_Q2gDK | UK001M | 2024-10-29T12:17:34.857Z | 2024-11-04T14:29:02.028Z |
5409592 | 5409592 | 20241027042736_61ERe | UK001M | 2024-10-29T12:17:32.048Z | 2024-11-04T14:29:01.970Z |
5409113 | 5409113 | 20241027040102_nW2s3 | UK001M | 2024-10-29T12:17:07.063Z | 2024-11-04T14:29:01.174Z |
5400177 | 5400177 | 20241026055029_ulbyN | UK001M | 2024-10-28T12:20:25.562Z | 2024-11-03T14:27:41.457Z |
5400166 | 5400166 | 20241026054809_zM12p | UK001M | 2024-10-28T12:20:25.275Z | 2024-11-03T14:27:41.451Z |
5400000 | 5400000 | 20241026052135_PHSHr | UK001M | 2024-10-28T12:20:18.638Z | 2024-11-03T14:27:41.089Z |
5399630 | 5399630 | 20241026044309_h5TB7 | UK001M | 2024-10-28T12:20:04.558Z | 2024-11-03T14:27:40.147Z |
5399581 | 5399581 | 20241026043612_3F26A | UK001M | 2024-10-28T12:20:03.245Z | 2024-11-03T14:27:40.016Z |
5399156 | 5399156 | 20241026035716_6rBv0 | UK001M | 2024-10-28T12:19:49.926Z | 2024-11-03T14:27:39.156Z |
5398990 | 5398990 | 20241026034400_Lpq47 | UK001M | 2024-10-28T12:19:43.827Z | 2024-11-03T14:27:38.817Z |
5398611 | 5398611 | 20241026031125_WjZLQ | UK001M | 2024-10-28T12:19:23.982Z | 2024-11-03T14:27:36.922Z |
5398273 | 5398273 | 20241026024009_1HiTy | UK001M | 2024-10-28T12:19:08.743Z | 2024-11-03T14:27:35.765Z |
5398231 | 5398231 | 20241026023612_bYtns | UK001M | 2024-10-28T12:19:06.875Z | 2024-11-03T14:27:35.713Z |
5398201 | 5398201 | 20241026023518_Pb2rd | UK001M | 2024-10-28T12:19:06.174Z | 2024-11-03T14:27:35.689Z |
5397537 | 5397537 | 20241026013856_tI2Qi | UK001M | 2024-10-28T12:18:26.608Z | 2024-11-03T14:27:33.355Z |
5397515 | 5397515 | 20241026013634_Y12Y2 | UK001M | 2024-10-28T12:18:26.203Z | 2024-11-03T14:27:33.341Z |
5397434 | 5397434 | 20241026012948_c3LLv | UK001M | 2024-10-28T12:18:21.760Z | 2024-11-03T14:27:32.916Z |
5397304 | 5397304 | 20241026011647_366dY | UK001M | 2024-10-28T12:18:15.447Z | 2024-11-03T14:27:32.558Z |
5397289 | 5397289 | 20241026011559_UY7D1 | UK001M | 2024-10-28T12:18:14.304Z | 2024-11-03T14:27:32.515Z |
5397090 | 5397090 | 20241026010144_xnoUD | UK001M | 2024-10-28T12:18:07.543Z | 2024-11-03T14:27:32.018Z |
5396745 | 5396745 | 20241026002953_Eyd7d | UK001M | 2024-10-28T12:17:54.983Z | 2024-11-03T14:27:30.839Z |
5396568 | 5396568 | 20241026001258_Lw5wB | UK001M | 2024-10-28T12:17:49.982Z | 2024-11-03T14:27:30.277Z |
5396360 | 5396360 | 20241025235922_nVCp2 | UK001M | 2024-10-28T12:17:36.147Z | 2024-11-03T14:27:29.633Z |
5396029 | 5396029 | 20241025233229_x2J1l | UK001M | 2024-10-28T12:17:13.966Z | 2024-11-03T14:27:28.150Z |
5395716 | 5395716 | 20241025230615_IuOX4 | UK001M | 2024-10-28T12:16:42.683Z | 2024-11-03T14:27:26.533Z |
5395713 | 5395713 | 20241025230615_qljax | UK001M | 2024-10-28T12:16:42.548Z | 2024-11-03T14:27:26.532Z |
5395645 | 5395645 | 20241025230135_dTi3N | UK001M | 2024-10-28T12:16:35.750Z | 2024-11-03T14:27:26.329Z |
5394303 | 5394303 | 20241025201327_IOq2Y | UK001M | 2024-10-28T12:14:21.294Z | 2024-11-03T14:27:20.753Z |
5393770 | 5393770 | 20241025184040_Z21Xk | UK001M | 2024-10-28T12:13:17.128Z | 2024-11-03T14:27:18.096Z |
5378190 | 5378190 | 20241024053517_0jG65 | UK001M | 2024-10-26T12:22:57.678Z | 2024-11-01T12:27:03.390Z |
5378030 | 5378030 | 20241024052459_lJHZ0 | UK001M | 2024-10-26T12:22:53.148Z | 2024-11-01T12:27:03.261Z |
5378010 | 5378010 | 20241024052354_1d37O | UK001M | 2024-10-26T12:22:52.879Z | 2024-11-01T12:27:03.225Z |
5377879 | 5377879 | 20241024051622_xtA1l | UK001M | 2024-10-26T12:22:49.131Z | 2024-11-01T12:27:03.151Z |
5377499 | 5377499 | 20241024045426_pDInZ | UK001M | 2024-10-26T12:22:38.801Z | 2024-11-01T12:27:02.474Z |
5377474 | 5377474 | 20241024045244_jb0zO | UK001M | 2024-10-26T12:22:38.184Z | 2024-11-01T12:27:02.453Z |
5377409 | 5377409 | 20241024044914_4gTUl | UK001M | 2024-10-26T12:22:36.746Z | 2024-11-01T12:27:02.423Z |
5377274 | 5377274 | 20241024044140_E7Tdv | UK001M | 2024-10-26T12:22:32.959Z | 2024-11-01T12:27:02.343Z |
5376872 | 5376872 | 20241024042015_KWw0a | UK001M | 2024-10-26T12:22:15.232Z | 2024-11-01T12:27:01.902Z |
5376806 | 5376806 | 20241024041817_noLtw | UK001M | 2024-10-26T12:22:13.747Z | 2024-11-01T12:27:01.861Z |
5376607 | 5376607 | 20241024040422_P39eb | UK001M | 2024-10-26T12:22:06.225Z | 2024-11-01T12:27:01.615Z |
5376572 | 5376572 | 20241024040235_3hs32 | UK001M | 2024-10-26T12:22:05.264Z | 2024-11-01T12:27:01.605Z |
5376337 | 5376337 | 20241024035152_wesRX | UK001M | 2024-10-26T12:21:58.170Z | 2024-11-01T12:27:01.505Z |
5375949 | 5375949 | 20241024033628_qDXac | UK001M | 2024-10-26T12:21:44.845Z | 2024-11-01T12:27:01.284Z |
5375917 | 5375917 | 20241024033544_kOag5 | UK001M | 2024-10-26T12:21:44.249Z | 2024-11-01T12:27:01.266Z |
5375773 | 5375773 | 20241024032921_OsMJN | UK001M | 2024-10-26T12:21:39.523Z | 2024-11-01T12:27:01.193Z |
5375739 | 5375739 | 20241024032718_aUP9h | UK001M | 2024-10-26T12:21:38.304Z | 2024-11-01T12:27:01.176Z |
5375628 | 5375628 | 20241024032153_huDPG | UK001M | 2024-10-26T12:21:34.011Z | 2024-11-01T12:27:01.140Z |
5375618 | 5375618 | 20241024032135_UFAkt | UK001M | 2024-10-26T12:21:33.633Z | 2024-11-01T12:27:01.111Z |
5375264 | 5375264 | 20241024030449_9OTyN | UK001M | 2024-10-26T12:21:17.573Z | 2024-11-01T12:27:00.465Z |
5375205 | 5375205 | 20241024030215_VfHhO | UK001M | 2024-10-26T12:21:16.799Z | 2024-11-01T12:27:00.440Z |
5375075 | 5375075 | 20241024025541_1r68J | UK001M | 2024-10-26T12:21:11.876Z | 2024-11-01T12:27:00.179Z |
5375036 | 5375036 | 20241024025433_hQfI2 | UK001M | 2024-10-26T12:21:10.371Z | 2024-11-01T12:27:00.124Z |
5374915 | 5374915 | 20241024024947_GcJ02 | UK001M | 2024-10-26T12:21:05.968Z | 2024-11-01T12:27:00.038Z |
5374707 | 5374707 | 20241024024109_drQ9C | UK001M | 2024-10-26T12:20:59.615Z | 2024-11-01T12:26:59.550Z |
5374465 | 5374465 | 20241024022845_3wcmN | UK001M | 2024-10-26T12:20:50.073Z | 2024-11-01T12:26:59.398Z |
5374044 | 5374044 | 20241024020727_3eHyC | UK001M | 2024-10-26T12:20:35.340Z | 2024-11-01T12:26:58.655Z |
5373867 | 5373867 | 20241024015738_Sic7H | UK001M | 2024-10-26T12:20:28.873Z | 2024-11-01T12:26:58.540Z |
5373858 | 5373858 | 20241024015712_2vFr7 | UK001M | 2024-10-26T12:20:28.203Z | 2024-11-01T12:26:58.535Z |
5373671 | 5373671 | 20241024014923_lraWd | UK001M | 2024-10-26T12:20:20.688Z | 2024-11-01T12:26:58.362Z |
5373587 | 5373587 | 20241024014551_VwJbV | UK001M | 2024-10-26T12:20:17.833Z | 2024-11-01T12:26:58.333Z |
5373230 | 5373230 | 20241024012846_SbUmr | UK001M | 2024-10-26T12:20:02.451Z | 2024-11-01T12:26:58.186Z |
5372682 | 5372682 | 20241024010322_kVX3t | UK001M | 2024-10-26T12:19:38.294Z | 2024-11-01T12:26:57.810Z |
5366234 | 5366234 | 20241024001003_5c7Rn | UK001M | 2024-10-25T12:18:19.784Z | 2024-11-01T12:26:56.814Z |
5365683 | 5365683 | 20241023234303_n85aa | UK001M | 2024-10-25T12:18:04.881Z | 2024-11-01T12:26:56.352Z |
5365137 | 5365137 | 20241023231628_o67Ak | UK001M | 2024-10-25T12:17:47.410Z | 2024-11-01T12:26:55.891Z |
5364562 | 5364562 | 20241023223827_J5uPO | UK001M | 2024-10-25T12:17:24.991Z | 2024-11-01T12:26:55.220Z |
5363617 | 5363617 | 20241023212822_0pzHN | UK001M | 2024-10-25T12:16:28.680Z | 2024-11-01T12:26:53.470Z |
5363235 | 5363235 | 20241023203900_2msb3 | UK001M | 2024-10-25T12:15:43.745Z | 2024-11-01T12:26:52.986Z |
5356123 | 5356123 | 20241023050324_cND3d | UK001M | 2024-10-24T12:21:53.407Z | 2024-10-31T12:30:10.504Z |
5355652 | 5355652 | 20241023035936_o2f9X | UK001M | 2024-10-24T12:21:29.981Z | 2024-10-31T12:30:08.385Z |
5355579 | 5355579 | 20241023035249_C4g77 | UK001M | 2024-10-24T12:21:26.679Z | 2024-10-31T12:30:08.079Z |
5355527 | 5355527 | 20241023034754_cdyQK | UK001M | 2024-10-24T12:21:25.336Z | 2024-10-31T12:30:08.041Z |
5354887 | 5354887 | 20241023025339_ErT7v | UK001M | 2024-10-24T12:20:55.756Z | 2024-10-31T12:30:06.682Z |
5354672 | 5354672 | 20241023023943_qXqMV | UK001M | 2024-10-24T12:20:46.133Z | 2024-10-31T12:30:06.228Z |
5354191 | 5354191 | 20241023021006_6Y4el | UK001M | 2024-10-24T12:20:21.263Z | 2024-10-31T12:30:05.499Z |
5353161 | 5353161 | 20241023011157_367UV | UK001M | 2024-10-24T12:19:34.403Z | 2024-10-31T12:30:03.897Z |
5352604 | 5352604 | 20241023004138_JFJ2m | UK001M | 2024-10-24T12:19:00.545Z | 2024-10-31T12:30:02.987Z |
5352560 | 5352560 | 20241023003850_3x73X | UK001M | 2024-10-24T12:18:57.245Z | 2024-10-31T12:30:02.891Z |
5351326 | 5351326 | 20241022231716_bwxF0 | UK001M | 2024-10-24T12:17:26.837Z | 2024-10-31T12:30:00.206Z |
5350948 | 5350948 | 20241022224416_BN5Tk | UK001M | 2024-10-24T12:16:54.926Z | 2024-10-31T12:29:59.141Z |
5350844 | 5350844 | 20241022223309_DGhEa | UK001M | 2024-10-24T12:16:41.492Z | 2024-10-31T12:29:58.848Z |
5350800 | 5350800 | 20241022222942_PwnI1 | UK001M | 2024-10-24T12:16:34.114Z | 2024-10-31T12:29:58.804Z |
5350790 | 5350790 | 20241022222933_dHIFA | UK001M | 2024-10-24T12:16:33.557Z | 2024-10-31T12:29:58.792Z |
5350138 | 5350138 | 20241022211610_kIL1X | UK001M | 2024-10-24T12:15:24.280Z | 2024-10-31T12:29:57.374Z |
5349728 | 5349728 | 20241022203049_BBkkZ | UK001M | 2024-10-24T12:14:33.713Z | 2024-10-31T12:29:56.196Z |
5349569 | 5349569 | 20241022201251_uOkGO | UK001M | 2024-10-24T12:13:59.753Z | 2024-10-31T12:29:55.824Z |
5349385 | 5349385 | 20241022195112_b8Ak2 | UK001M | 2024-10-24T12:13:34.132Z | 2024-10-31T12:29:55.169Z |
5345295 | 5345295 | 20241022053321_gj1lR | UK001M | 2024-10-23T12:19:13.253Z | 2024-10-30T12:26:52.429Z |
5345187 | 5345187 | 20241022052218_12oa1 | UK001M | 2024-10-23T12:19:09.790Z | 2024-10-30T12:26:52.285Z |
5335134 | 5335134 | 20241021040053_bypM8 | UK001M | 2024-10-22T12:17:59.833Z | 2024-10-29T12:26:35.996Z |
5307876 | 5307876 | 20241014052630_13AMa | UK001M | 2024-10-16T12:02:31.152Z | 2024-10-23T12:24:09.426Z |
5307871 | 5307871 | 20241014052024_q2yo3 | UK001M | 2024-10-16T12:02:28.527Z | 2024-10-23T12:24:09.226Z |
5304280 | 5304280 | 20241013043347_XCxnN | UK001M | 2024-10-14T12:17:47.037Z | 2024-10-21T12:24:24.597Z |
5292772 | 5292772 | 20241012002036_b4VMA | UK001M | 2024-10-13T12:16:30.655Z | 2024-10-20T12:24:51.013Z |
5292711 | 5292711 | 20241012001317_oPJeR | UK001M | 2024-10-13T12:16:25.948Z | 2024-10-20T12:24:49.453Z |
5292624 | 5292624 | 20241011235643_uuQ7k | UK001M | 2024-10-13T12:16:17.839Z | 2024-10-20T12:24:48.480Z |
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);