participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,612 rows where station_code = "UK009P" 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 |
---|---|---|---|---|---|
5129754 | 5129754 | 20240917042512_YPcGy | UK009P | 2024-09-19T12:12:02.895Z | 2024-09-19T12:12:02.895Z |
5129643 | 5129643 | 20240917041634_t8e2f | UK009P | 2024-09-19T12:11:57.449Z | 2024-09-19T12:11:57.449Z |
5129490 | 5129490 | 20240917040451_YYTpq | UK009P | 2024-09-19T12:11:44.686Z | 2024-09-19T12:11:44.686Z |
5129470 | 5129470 | 20240917035942_IKy4V | UK009P | 2024-09-19T12:11:41.057Z | 2024-09-19T12:11:41.057Z |
5129299 | 5129299 | 20240917034630_6Zgnr | UK009P | 2024-09-19T12:11:26.313Z | 2024-09-19T12:11:26.313Z |
5129232 | 5129232 | 20240917033849_JFQoF | UK009P | 2024-09-19T12:11:23.654Z | 2024-09-19T12:11:23.654Z |
5129026 | 5129026 | 20240917030907_ZYVJx | UK009P | 2024-09-19T12:11:11.875Z | 2024-09-19T12:11:11.875Z |
5128930 | 5128930 | 20240917025710_dO20e | UK009P | 2024-09-19T12:11:07.994Z | 2024-09-19T12:11:07.994Z |
5128780 | 5128780 | 20240917023459_iFqY0 | UK009P | 2024-09-19T12:11:01.267Z | 2024-09-19T12:11:01.267Z |
5128593 | 5128593 | 20240917020759_7vm3g | UK009P | 2024-09-19T12:10:46.472Z | 2024-09-19T12:10:46.472Z |
5128367 | 5128367 | 20240917013113_7lp2l | UK009P | 2024-09-19T12:10:29.052Z | 2024-09-19T12:10:29.052Z |
5128302 | 5128302 | 20240917012201_PHVbY | UK009P | 2024-09-19T12:10:25.679Z | 2024-09-19T12:10:25.679Z |
5128253 | 5128253 | 20240917010944_y4nji | UK009P | 2024-09-19T12:10:21.932Z | 2024-09-19T12:10:21.932Z |
5127916 | 5127916 | 20240917000505_sC3Ql | UK009P | 2024-09-19T12:09:46.715Z | 2024-09-19T12:09:46.715Z |
5127734 | 5127734 | 20240916231523_C4vek | UK009P | 2024-09-19T12:09:34.971Z | 2024-09-19T12:09:34.971Z |
5127689 | 5127689 | 20240916225232_XdM57 | UK009P | 2024-09-19T12:09:31.439Z | 2024-09-19T12:09:31.439Z |
5127530 | 5127530 | 20240916221624_TycVy | UK009P | 2024-09-19T12:09:17.666Z | 2024-09-19T12:09:17.666Z |
5125159 | 5125159 | 20240918003832_WaDDv | UK009P | 2024-09-19T12:02:24.861Z | 2024-09-19T12:06:41.983Z |
5124930 | 5124930 | 20240917225248_MAb5G | UK009P | 2024-09-19T12:01:48.892Z | 2024-09-19T12:06:41.953Z |
5124917 | 5124917 | 20240917225137_bx5j3 | UK009P | 2024-09-19T12:01:48.044Z | 2024-09-19T12:06:41.952Z |
5124788 | 5124788 | 20240917220112_DZ7h4 | UK009P | 2024-09-19T12:01:35.012Z | 2024-09-19T12:06:41.935Z |
5124762 | 5124762 | 20240917215748_Yi0FR | UK009P | 2024-09-19T12:01:32.616Z | 2024-09-19T12:06:41.932Z |
5124735 | 5124735 | 20240917215625_mMP25 | UK009P | 2024-09-19T12:01:27.849Z | 2024-09-19T12:06:41.929Z |
5124650 | 5124650 | 20240917214200_UAtz1 | UK009P | 2024-09-19T12:01:15.721Z | 2024-09-19T12:06:41.921Z |
5124633 | 5124633 | 20240917213921_D2aqM | UK009P | 2024-09-19T12:01:14.480Z | 2024-09-19T12:06:41.919Z |
5124529 | 5124529 | 20240917205551_GBozT | UK009P | 2024-09-19T12:01:05.529Z | 2024-09-19T12:06:41.907Z |
5124497 | 5124497 | 20240917205233_wgkhd | UK009P | 2024-09-19T12:01:03.106Z | 2024-09-19T12:06:41.904Z |
5124375 | 5124375 | 20240917194406_YeB2s | UK009P | 2024-09-19T12:00:40.906Z | 2024-09-19T12:06:41.884Z |
5122047 | 5122047 | 20240914042919_kBCVX | UK009P | 2024-09-18T12:11:05.171Z | 2024-09-19T12:20:02.713Z |
5121863 | 5121863 | 20240914041723_hHZoX | UK009P | 2024-09-18T12:11:02.358Z | 2024-09-19T12:20:02.447Z |
5121708 | 5121708 | 20240914041223_Y2S4F | UK009P | 2024-09-18T12:10:59.821Z | 2024-09-19T12:20:02.264Z |
5121636 | 5121636 | 20240914041042_HtKAC | UK009P | 2024-09-18T12:10:58.923Z | 2024-09-19T12:20:02.186Z |
5121614 | 5121614 | 20240914041027_ZjFMf | UK009P | 2024-09-18T12:10:58.865Z | 2024-09-19T12:20:02.185Z |
5120903 | 5120903 | 20240914034045_yYbUJ | UK009P | 2024-09-18T12:10:48.587Z | 2024-09-19T12:20:01.026Z |
5120894 | 5120894 | 20240914034036_Sks8h | UK009P | 2024-09-18T12:10:48.453Z | 2024-09-19T12:20:00.998Z |
5120631 | 5120631 | 20240914033018_Ulnqj | UK009P | 2024-09-18T12:10:43.874Z | 2024-09-19T12:20:00.633Z |
5120597 | 5120597 | 20240914032938_hNX3n | UK009P | 2024-09-18T12:10:43.600Z | 2024-09-19T12:20:00.627Z |
5120438 | 5120438 | 20240914032021_0w0mb | UK009P | 2024-09-18T12:10:39.801Z | 2024-09-19T12:20:00.207Z |
5120125 | 5120125 | 20240914030045_kaNSo | UK009P | 2024-09-18T12:10:32.249Z | 2024-09-19T12:19:59.457Z |
5120034 | 5120034 | 20240914025740_w5sTV | UK009P | 2024-09-18T12:10:31.118Z | 2024-09-19T12:19:59.306Z |
5119937 | 5119937 | 20240914025404_Vh24d | UK009P | 2024-09-18T12:10:29.736Z | 2024-09-19T12:19:59.180Z |
5119856 | 5119856 | 20240914025107_tYCQn | UK009P | 2024-09-18T12:10:28.236Z | 2024-09-19T12:19:59.028Z |
5119807 | 5119807 | 20240914025012_cKCvm | UK009P | 2024-09-18T12:10:27.213Z | 2024-09-19T12:19:58.959Z |
5119772 | 5119772 | 20240914024845_eXMdp | UK009P | 2024-09-18T12:10:26.757Z | 2024-09-19T12:19:58.939Z |
5119684 | 5119684 | 20240914024404_FwclT | UK009P | 2024-09-18T12:10:24.054Z | 2024-09-19T12:19:58.732Z |
5119293 | 5119293 | 20240914022153_PDykK | UK009P | 2024-09-18T12:10:19.550Z | 2024-09-19T12:19:57.632Z |
5119122 | 5119122 | 20240914021212_g33OE | UK009P | 2024-09-18T12:10:16.408Z | 2024-09-19T12:19:57.196Z |
5116601 | 5116601 | 20240915033247_BBCVw | UK009P | 2024-09-18T12:07:11.064Z | 2024-09-19T12:19:11.605Z |
5116280 | 5116280 | 20240915031959_WrKJe | UK009P | 2024-09-18T12:06:54.173Z | 2024-09-19T12:19:10.237Z |
5116076 | 5116076 | 20240915030714_6Cyyw | UK009P | 2024-09-18T12:06:37.764Z | 2024-09-19T12:19:08.416Z |
5115993 | 5115993 | 20240915030242_kxnSo | UK009P | 2024-09-18T12:06:33.544Z | 2024-09-19T12:19:08.090Z |
5115545 | 5115545 | 20240915024428_CUS2m | UK009P | 2024-09-18T12:06:17.728Z | 2024-09-19T12:19:05.352Z |
5114793 | 5114793 | 20240915015819_c3g4l | UK009P | 2024-09-18T12:05:34.476Z | 2024-09-19T12:18:59.906Z |
5114771 | 5114771 | 20240915015743_9K7A3 | UK009P | 2024-09-18T12:05:33.745Z | 2024-09-19T12:18:59.867Z |
5114661 | 5114661 | 20240915015312_gJZU1 | UK009P | 2024-09-18T12:05:27.636Z | 2024-09-19T12:18:59.191Z |
5114474 | 5114474 | 20240915014409_HzMIi | UK009P | 2024-09-18T12:05:19.344Z | 2024-09-19T12:18:58.465Z |
5113976 | 5113976 | 20240915012116_1VSgb | UK009P | 2024-09-18T12:04:56.777Z | 2024-09-19T12:18:54.884Z |
5113142 | 5113142 | 20240915002437_TaEq6 | UK009P | 2024-09-18T12:03:58.261Z | 2024-09-19T12:18:47.421Z |
5112577 | 5112577 | 20240914233020_Bsvf4 | UK009P | 2024-09-18T12:03:15.244Z | 2024-09-19T12:18:41.498Z |
5111982 | 5111982 | 20240914214910_80rid | UK009P | 2024-09-18T12:02:34.800Z | 2024-09-19T12:18:35.985Z |
5111656 | 5111656 | 20240914205827_EAv50 | UK009P | 2024-09-18T12:02:09.571Z | 2024-09-19T12:18:32.802Z |
5111371 | 5111371 | 20240914202837_OlHm7 | UK009P | 2024-09-18T12:01:52.739Z | 2024-09-19T12:18:29.612Z |
5111237 | 5111237 | 20240914201314_Fgem2 | UK009P | 2024-09-18T12:01:44.635Z | 2024-09-19T12:18:27.914Z |
5111192 | 5111192 | 20240914201007_8Xvja | UK009P | 2024-09-18T12:01:42.469Z | 2024-09-19T12:18:27.298Z |
5108278 | 5108278 | 20240913043838_875oU | UK009P | 2024-09-17T12:13:34.587Z | 2024-09-19T12:20:47.991Z |
5108239 | 5108239 | 20240913043505_Rm5vC | UK009P | 2024-09-17T12:13:33.708Z | 2024-09-19T12:20:47.964Z |
5108137 | 5108137 | 20240913042438_Vw19F | UK009P | 2024-09-17T12:13:31.027Z | 2024-09-19T12:20:47.861Z |
5107959 | 5107959 | 20240913041532_71dwi | UK009P | 2024-09-17T12:13:26.263Z | 2024-09-19T12:20:47.650Z |
5107947 | 5107947 | 20240913041517_xTvtL | UK009P | 2024-09-17T12:13:26.077Z | 2024-09-19T12:20:47.639Z |
5107808 | 5107808 | 20240913041100_Q8u26 | UK009P | 2024-09-17T12:13:23.960Z | 2024-09-19T12:20:47.560Z |
5107712 | 5107712 | 20240913040843_C1k02 | UK009P | 2024-09-17T12:13:22.109Z | 2024-09-19T12:20:47.477Z |
5107638 | 5107638 | 20240913040635_v4Zh3 | UK009P | 2024-09-17T12:13:20.210Z | 2024-09-19T12:20:47.387Z |
5107517 | 5107517 | 20240913035831_fqGqQ | UK009P | 2024-09-17T12:13:16.408Z | 2024-09-19T12:20:47.195Z |
5107467 | 5107467 | 20240913035738_DTVj0 | UK009P | 2024-09-17T12:13:15.823Z | 2024-09-19T12:20:47.166Z |
5107341 | 5107341 | 20240913035258_hNvZE | UK009P | 2024-09-17T12:13:13.458Z | 2024-09-19T12:20:47.004Z |
5107264 | 5107264 | 20240913034944_bhuPa | UK009P | 2024-09-17T12:13:11.937Z | 2024-09-19T12:20:46.967Z |
5107144 | 5107144 | 20240913034535_Nfjnq | UK009P | 2024-09-17T12:13:09.977Z | 2024-09-19T12:20:46.862Z |
5107056 | 5107056 | 20240913034223_r2lZE | UK009P | 2024-09-17T12:13:08.372Z | 2024-09-19T12:20:46.793Z |
5106881 | 5106881 | 20240913033731_OnzFn | UK009P | 2024-09-17T12:13:03.430Z | 2024-09-19T12:20:46.502Z |
5106713 | 5106713 | 20240913033244_xNwMk | UK009P | 2024-09-17T12:12:59.797Z | 2024-09-19T12:20:46.295Z |
5105867 | 5105867 | 20240913030105_6btNP | UK009P | 2024-09-17T12:12:30.869Z | 2024-09-19T12:20:44.999Z |
5105659 | 5105659 | 20240913025422_EJDL8 | UK009P | 2024-09-17T12:12:24.660Z | 2024-09-19T12:20:44.774Z |
5105611 | 5105611 | 20240913025303_QHYDa | UK009P | 2024-09-17T12:12:23.394Z | 2024-09-19T12:20:44.720Z |
5105442 | 5105442 | 20240913024615_M9Fb2 | UK009P | 2024-09-17T12:12:16.946Z | 2024-09-19T12:20:44.547Z |
5105078 | 5105078 | 20240913022921_1BD9X | UK009P | 2024-09-17T12:11:52.740Z | 2024-09-19T12:20:43.466Z |
5104824 | 5104824 | 20240913022148_1xM2P | UK009P | 2024-09-17T12:11:45.170Z | 2024-09-19T12:20:42.918Z |
5104466 | 5104466 | 20240913021031_fWqnC | UK009P | 2024-09-17T12:11:35.878Z | 2024-09-19T12:20:41.501Z |
5104365 | 5104365 | 20240913020602_8rNYg | UK009P | 2024-09-17T12:11:33.885Z | 2024-09-19T12:20:41.425Z |
5104344 | 5104344 | 20240913020545_oMvux | UK009P | 2024-09-17T12:11:33.793Z | 2024-09-19T12:20:41.419Z |
5104119 | 5104119 | 20240913015317_gHfxB | UK009P | 2024-09-17T12:11:25.834Z | 2024-09-19T12:20:41.039Z |
5103769 | 5103769 | 20240913013928_yELQC | UK009P | 2024-09-17T12:11:10.032Z | 2024-09-19T12:20:40.456Z |
5103635 | 5103635 | 20240913013439_UNbp7 | UK009P | 2024-09-17T12:11:06.422Z | 2024-09-19T12:20:40.386Z |
5103133 | 5103133 | 20240914020248_2qOqR | UK009P | 2024-09-17T12:07:53.250Z | 2024-09-19T12:19:56.674Z |
5103055 | 5103055 | 20240914015933_bjV97 | UK009P | 2024-09-17T12:07:49.212Z | 2024-09-19T12:19:56.472Z |
5103008 | 5103008 | 20240914015702_iHLvl | UK009P | 2024-09-17T12:07:46.811Z | 2024-09-19T12:19:56.322Z |
5102498 | 5102498 | 20240914012836_Z73U5 | UK009P | 2024-09-17T12:07:16.286Z | 2024-09-19T12:19:54.575Z |
5102040 | 5102040 | 20240914010300_bJtOH | UK009P | 2024-09-17T12:06:44.184Z | 2024-09-19T12:19:52.307Z |
5101779 | 5101779 | 20240914004636_HJrEs | UK009P | 2024-09-17T12:06:12.307Z | 2024-09-19T12:19:51.482Z |
5101688 | 5101688 | 20240914004335_fms2t | UK009P | 2024-09-17T12:06:09.045Z | 2024-09-19T12:19:51.280Z |
5101553 | 5101553 | 20240914003434_G09VS | UK009P | 2024-09-17T12:06:00.758Z | 2024-09-19T12:19:50.925Z |
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);