participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,144 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 |
---|---|---|---|---|---|
5573094 | 5573094 | 20241121035059_30wDC | UK001M | 2024-11-22T14:19:09.648Z | 2024-11-22T14:19:22.448Z |
5570819 | 5570819 | 20241120210719_C65VE | UK001M | 2024-11-22T14:16:07.267Z | 2024-11-22T14:19:21.988Z |
5569873 | 5569873 | 20241120175338_OvrqZ | UK001M | 2024-11-22T14:14:29.346Z | 2024-11-22T14:19:21.821Z |
5569807 | 5569807 | 20241120173541_2oF5y | UK001M | 2024-11-22T14:14:15.966Z | 2024-11-22T14:19:21.810Z |
5565983 | 5565983 | 20241121051340_k1tqs | UK001M | 2024-11-22T14:01:31.251Z | 2024-11-22T14:01:31.251Z |
5565806 | 5565806 | 20241121044955_3mri5 | UK001M | 2024-11-22T14:01:00.224Z | 2024-11-22T14:01:00.224Z |
5565763 | 5565763 | 20241121044239_CWd9f | UK001M | 2024-11-22T14:00:53.957Z | 2024-11-22T14:00:53.957Z |
5562279 | 5562279 | 20241119231951_0jSkf | UK001M | 2024-11-21T14:14:40.153Z | 2024-11-22T14:20:55.279Z |
5562259 | 5562259 | 20241119231747_w28Oy | UK001M | 2024-11-21T14:14:39.043Z | 2024-11-22T14:20:54.881Z |
5562247 | 5562247 | 20241119231605_1Ydoh | UK001M | 2024-11-21T14:14:36.362Z | 2024-11-22T14:20:54.546Z |
5562215 | 5562215 | 20241119231045_6WxJN | UK001M | 2024-11-21T14:14:33.036Z | 2024-11-22T14:20:54.299Z |
5561767 | 5561767 | 20241119220538_WX4WN | UK001M | 2024-11-21T14:14:03.174Z | 2024-11-22T14:20:45.792Z |
5561083 | 5561083 | 20241119180238_2olzW | UK001M | 2024-11-21T14:12:21.282Z | 2024-11-22T14:20:19.633Z |
5539202 | 5539202 | 20241114054926_Xmt1K | UK001M | 2024-11-15T14:00:21.797Z | 2024-11-22T14:23:42.443Z |
5538785 | 5538785 | 20241113045737_fbZsB | UK001M | 2024-11-14T14:13:57.570Z | 2024-11-21T14:26:28.753Z |
5538739 | 5538739 | 20241113044941_tQ0Jl | UK001M | 2024-11-14T14:13:54.506Z | 2024-11-21T14:26:28.683Z |
5538693 | 5538693 | 20241113043723_ZCTg3 | UK001M | 2024-11-14T14:13:49.514Z | 2024-11-21T14:26:28.533Z |
5538667 | 5538667 | 20241113043335_qvs8L | UK001M | 2024-11-14T14:13:48.284Z | 2024-11-21T14:26:28.471Z |
5538570 | 5538570 | 20241113041428_0fg1l | UK001M | 2024-11-14T14:13:39.332Z | 2024-11-21T14:26:27.221Z |
5538458 | 5538458 | 20241113034947_B0ak3 | UK001M | 2024-11-14T14:13:30.023Z | 2024-11-21T14:26:26.102Z |
5538259 | 5538259 | 20241113025605_X0M11 | UK001M | 2024-11-14T14:13:10.384Z | 2024-11-21T14:26:22.836Z |
5537966 | 5537966 | 20241113014523_eBPlx | UK001M | 2024-11-14T14:12:40.534Z | 2024-11-21T14:26:17.912Z |
5532844 | 5532844 | 20241113060316_oQQWv | UK001M | 2024-11-14T14:00:23.109Z | 2024-11-22T14:24:05.651Z |
5532629 | 5532629 | 20241112054445_tbzXW | UK001M | 2024-11-13T14:17:04.347Z | 2024-11-20T14:26:25.282Z |
5532607 | 5532607 | 20241112054358_jkDzG | UK001M | 2024-11-13T14:17:03.114Z | 2024-11-20T14:26:25.117Z |
5532050 | 5532050 | 20241112043258_UXP2k | UK001M | 2024-11-13T14:16:13.633Z | 2024-11-20T14:26:18.302Z |
5531325 | 5531325 | 20241112033227_bLjY4 | UK001M | 2024-11-13T14:15:34.531Z | 2024-11-20T14:26:10.368Z |
5531033 | 5531033 | 20241112030802_n5bl3 | UK001M | 2024-11-13T14:15:05.876Z | 2024-11-20T14:26:06.585Z |
5531012 | 5531012 | 20241112030602_T89rQ | UK001M | 2024-11-13T14:15:01.667Z | 2024-11-20T14:26:06.169Z |
5530903 | 5530903 | 20241112025906_IKv9G | UK001M | 2024-11-13T14:14:49.862Z | 2024-11-20T14:26:05.154Z |
5530474 | 5530474 | 20241112022232_8mADr | UK001M | 2024-11-13T14:14:17.789Z | 2024-11-20T14:26:00.649Z |
5530303 | 5530303 | 20241112020711_GV1ij | UK001M | 2024-11-13T14:14:07.897Z | 2024-11-20T14:25:56.816Z |
5530069 | 5530069 | 20241112013942_3ikrN | UK001M | 2024-11-13T14:13:48.124Z | 2024-11-20T14:25:54.060Z |
5529949 | 5529949 | 20241112012839_shM0z | UK001M | 2024-11-13T14:13:27.937Z | 2024-11-20T14:25:51.344Z |
5502913 | 5502913 | 20241107201119_PL4Hl | UK001M | 2024-11-09T14:12:12.183Z | 2024-11-16T14:28:00.654Z |
5502356 | 5502356 | 20241107181208_tvGs8 | UK001M | 2024-11-09T14:11:12.992Z | 2024-11-16T14:27:54.437Z |
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 |
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);