participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,030 rows where station_code = "HR000R" 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 |
---|---|---|---|---|---|
619545 | 619545 | 20210612002231_4DpqV | HR000R | 2024-01-05T23:33:45.346Z | 2024-01-05T23:33:45.346Z |
616575 | 616575 | 20210609003357_8HWJR | HR000R | 2024-01-05T23:33:42.489Z | 2024-01-05T23:33:42.489Z |
616538 | 616538 | 20210609001246_jOr6a | HR000R | 2024-01-05T23:33:42.485Z | 2024-01-05T23:33:42.485Z |
616442 | 616442 | 20210608234208_nuFyL | HR000R | 2024-01-05T23:33:42.473Z | 2024-01-05T23:33:42.473Z |
615229 | 615229 | 20210607233652_IGN30 | HR000R | 2024-01-05T23:33:40.900Z | 2024-01-05T23:33:40.900Z |
615082 | 615082 | 20210607214123_JQljY | HR000R | 2024-01-05T23:33:40.881Z | 2024-01-05T23:33:40.881Z |
613334 | 613334 | 20210604230625_UFIZw | HR000R | 2024-01-05T23:33:36.597Z | 2024-01-05T23:33:36.597Z |
613316 | 613316 | 20210604225443_AxQS7 | HR000R | 2024-01-05T23:33:36.595Z | 2024-01-05T23:33:36.595Z |
613284 | 613284 | 20210604224003_aZUXG | HR000R | 2024-01-05T23:33:36.591Z | 2024-01-05T23:33:36.591Z |
612773 | 612773 | 20210604003808_sZgg2 | HR000R | 2024-01-05T23:33:35.154Z | 2024-01-05T23:33:35.154Z |
612764 | 612764 | 20210604003220_Vm2hn | HR000R | 2024-01-05T23:33:35.153Z | 2024-01-05T23:33:35.153Z |
612758 | 612758 | 20210604003148_Xddiu | HR000R | 2024-01-05T23:33:35.152Z | 2024-01-05T23:33:35.152Z |
612367 | 612367 | 20210603205142_hAlKs | HR000R | 2024-01-05T23:33:35.104Z | 2024-01-05T23:33:35.104Z |
612151 | 612151 | 20210603013316_axiax | HR000R | 2024-01-05T23:33:33.966Z | 2024-01-05T23:33:33.966Z |
612127 | 612127 | 20210603010404_r1nno | HR000R | 2024-01-05T23:33:33.963Z | 2024-01-05T23:33:33.963Z |
611928 | 611928 | 20210602224333_sxLZR | HR000R | 2024-01-05T23:33:33.937Z | 2024-01-05T23:33:33.937Z |
611897 | 611897 | 20210602220228_zGgFy | HR000R | 2024-01-05T23:33:33.933Z | 2024-01-05T23:33:33.933Z |
610962 | 610962 | 20210602001741_0kghP | HR000R | 2024-01-05T23:33:32.269Z | 2024-01-05T23:33:32.269Z |
610890 | 610890 | 20210601234040_dyeCj | HR000R | 2024-01-05T23:33:32.258Z | 2024-01-05T23:33:32.258Z |
610771 | 610771 | 20210601225446_n00ti | HR000R | 2024-01-05T23:33:32.243Z | 2024-01-05T23:33:32.243Z |
610752 | 610752 | 20210601224551_YAKjh | HR000R | 2024-01-05T23:33:32.240Z | 2024-01-05T23:33:32.240Z |
608321 | 608321 | 20210530012419_d6eis | HR000R | 2024-01-05T23:33:27.598Z | 2024-01-05T23:33:27.598Z |
608328 | 608328 | 20210530012658_Llc2Q | HR000R | 2024-01-05T23:33:27.598Z | 2024-01-05T23:33:27.598Z |
608207 | 608207 | 20210530000914_o057G | HR000R | 2024-01-05T23:33:27.581Z | 2024-01-05T23:33:27.581Z |
608190 | 608190 | 20210530000317_mTObS | HR000R | 2024-01-05T23:33:27.579Z | 2024-01-05T23:33:27.579Z |
608156 | 608156 | 20210529234728_MWx0k | HR000R | 2024-01-05T23:33:27.574Z | 2024-01-05T23:33:27.574Z |
608134 | 608134 | 20210529234100_HhQsi | HR000R | 2024-01-05T23:33:27.571Z | 2024-01-05T23:33:27.571Z |
607429 | 607429 | 20210528212950_ntDFb | HR000R | 2024-01-05T23:33:26.323Z | 2024-01-05T23:33:26.323Z |
607400 | 607400 | 20210528210400_8Ih9x | HR000R | 2024-01-05T23:33:26.319Z | 2024-01-05T23:33:26.319Z |
607389 | 607389 | 20210528205722_qAeXB | HR000R | 2024-01-05T23:33:26.318Z | 2024-01-05T23:33:26.318Z |
607353 | 607353 | 20210528201035_3EpFs | HR000R | 2024-01-05T23:33:26.313Z | 2024-01-05T23:33:26.313Z |
606628 | 606628 | 20210526201231_kzuTt | HR000R | 2024-01-05T23:33:23.418Z | 2024-01-05T23:33:23.418Z |
559248 | 559248 | 20210405023229_xkzAf | HR000R | 2024-01-05T23:31:49.703Z | 2024-01-05T23:31:49.703Z |
559179 | 559179 | 20210405012450_xPiN0 | HR000R | 2024-01-05T23:31:49.693Z | 2024-01-05T23:31:49.693Z |
559056 | 559056 | 20210405000353_BVQg6 | HR000R | 2024-01-05T23:31:49.675Z | 2024-01-05T23:31:49.675Z |
559026 | 559026 | 20210404233822_P2x0C | HR000R | 2024-01-05T23:31:49.671Z | 2024-01-05T23:31:49.671Z |
557746 | 557746 | 20210403203714_wIONZ | HR000R | 2024-01-05T23:31:48.364Z | 2024-01-05T23:31:48.364Z |
557674 | 557674 | 20210403191406_q16oP | HR000R | 2024-01-05T23:31:46.900Z | 2024-01-05T23:31:46.900Z |
556332 | 556332 | 20210401000033_f8Lxq | HR000R | 2024-01-05T23:31:44.121Z | 2024-01-05T23:31:44.121Z |
556223 | 556223 | 20210331211638_1CQ3A | HR000R | 2024-01-05T23:31:44.105Z | 2024-01-05T23:31:44.105Z |
556135 | 556135 | 20210331192036_UJyfQ | HR000R | 2024-01-05T23:31:44.094Z | 2024-01-05T23:31:44.094Z |
556118 | 556118 | 20210331191418_jvvYC | HR000R | 2024-01-05T23:31:44.091Z | 2024-01-05T23:31:44.091Z |
553100 | 553100 | 20210324031611_oKviv | HR000R | 2024-01-05T23:31:32.991Z | 2024-01-05T23:31:32.991Z |
552524 | 552524 | 20210323023940_GTTDs | HR000R | 2024-01-05T23:31:31.538Z | 2024-01-05T23:31:31.538Z |
552481 | 552481 | 20210323015313_JVnV5 | HR000R | 2024-01-05T23:31:31.532Z | 2024-01-05T23:31:31.532Z |
552452 | 552452 | 20210323010018_yf2Pz | HR000R | 2024-01-05T23:31:31.528Z | 2024-01-05T23:31:31.528Z |
552426 | 552426 | 20210322235138_54h06 | HR000R | 2024-01-05T23:31:31.524Z | 2024-01-05T23:31:31.524Z |
552422 | 552422 | 20210322234522_oXq2X | HR000R | 2024-01-05T23:31:31.523Z | 2024-01-05T23:31:31.523Z |
552410 | 552410 | 20210322223102_pwuEg | HR000R | 2024-01-05T23:31:31.521Z | 2024-01-05T23:31:31.521Z |
552399 | 552399 | 20210322210142_XaJFx | HR000R | 2024-01-05T23:31:31.519Z | 2024-01-05T23:31:31.519Z |
552381 | 552381 | 20210322194701_i22eW | HR000R | 2024-01-05T23:31:31.517Z | 2024-01-05T23:31:31.517Z |
551880 | 551880 | 20210322032831_U3fb3 | HR000R | 2024-01-05T23:31:29.952Z | 2024-01-05T23:31:29.952Z |
550916 | 550916 | 20210321035304_hw4P0 | HR000R | 2024-01-05T23:31:28.710Z | 2024-01-05T23:31:28.710Z |
550827 | 550827 | 20210321024853_jilt3 | HR000R | 2024-01-05T23:31:28.699Z | 2024-01-05T23:31:28.699Z |
550798 | 550798 | 20210321023303_3Q5ML | HR000R | 2024-01-05T23:31:28.695Z | 2024-01-05T23:31:28.695Z |
550688 | 550688 | 20210321002616_4GEV5 | HR000R | 2024-01-05T23:31:28.679Z | 2024-01-05T23:31:28.679Z |
547918 | 547918 | 20210319035259_Vwkrd | HR000R | 2024-01-05T23:31:25.790Z | 2024-01-05T23:31:25.790Z |
547839 | 547839 | 20210319033345_89lAB | HR000R | 2024-01-05T23:31:25.780Z | 2024-01-05T23:31:25.780Z |
547761 | 547761 | 20210319031703_bXUyf | HR000R | 2024-01-05T23:31:25.771Z | 2024-01-05T23:31:25.771Z |
547675 | 547675 | 20210319024932_ZIm25 | HR000R | 2024-01-05T23:31:25.761Z | 2024-01-05T23:31:25.761Z |
547655 | 547655 | 20210319024354_UBoTV | HR000R | 2024-01-05T23:31:25.759Z | 2024-01-05T23:31:25.759Z |
547597 | 547597 | 20210319022130_JTiYO | HR000R | 2024-01-05T23:31:25.752Z | 2024-01-05T23:31:25.752Z |
547490 | 547490 | 20210319011818_wVFdw | HR000R | 2024-01-05T23:31:25.739Z | 2024-01-05T23:31:25.739Z |
547387 | 547387 | 20210319001946_VscsE | HR000R | 2024-01-05T23:31:25.726Z | 2024-01-05T23:31:25.726Z |
547268 | 547268 | 20210318230631_600Tf | HR000R | 2024-01-05T23:31:25.710Z | 2024-01-05T23:31:25.710Z |
547262 | 547262 | 20210318230620_nCH8P | HR000R | 2024-01-05T23:31:25.709Z | 2024-01-05T23:31:25.709Z |
547170 | 547170 | 20210318213958_3VGDA | HR000R | 2024-01-05T23:31:25.697Z | 2024-01-05T23:31:25.697Z |
545733 | 545733 | 20210317194338_evLlK | HR000R | 2024-01-05T23:31:23.978Z | 2024-01-05T23:31:23.978Z |
545083 | 545083 | 20210317040330_PeALl | HR000R | 2024-01-05T23:31:22.531Z | 2024-01-05T23:31:22.531Z |
545019 | 545019 | 20210317031518_4elO6 | HR000R | 2024-01-05T23:31:22.524Z | 2024-01-05T23:31:22.524Z |
545011 | 545011 | 20210317031203_MbaGO | HR000R | 2024-01-05T23:31:22.523Z | 2024-01-05T23:31:22.523Z |
544985 | 544985 | 20210317024759_29NyK | HR000R | 2024-01-05T23:31:22.520Z | 2024-01-05T23:31:22.520Z |
544954 | 544954 | 20210317023107_3k4Ao | HR000R | 2024-01-05T23:31:22.516Z | 2024-01-05T23:31:22.516Z |
544899 | 544899 | 20210317015754_3PGkU | HR000R | 2024-01-05T23:31:22.509Z | 2024-01-05T23:31:22.509Z |
544906 | 544906 | 20210317015811_Zom8a | HR000R | 2024-01-05T23:31:22.509Z | 2024-01-05T23:31:22.509Z |
544866 | 544866 | 20210317014210_wGyTl | HR000R | 2024-01-05T23:31:22.505Z | 2024-01-05T23:31:22.505Z |
544804 | 544804 | 20210317005619_Yr0Dq | HR000R | 2024-01-05T23:31:22.496Z | 2024-01-05T23:31:22.496Z |
544685 | 544685 | 20210316231305_7vFpT | HR000R | 2024-01-05T23:31:22.478Z | 2024-01-05T23:31:22.478Z |
544605 | 544605 | 20210316222500_yrGMO | HR000R | 2024-01-05T23:31:22.468Z | 2024-01-05T23:31:22.468Z |
544589 | 544589 | 20210316221124_2lNP8 | HR000R | 2024-01-05T23:31:22.466Z | 2024-01-05T23:31:22.466Z |
544545 | 544545 | 20210316214028_E50tQ | HR000R | 2024-01-05T23:31:22.459Z | 2024-01-05T23:31:22.459Z |
543896 | 543896 | 20210316035230_t5JVe | HR000R | 2024-01-05T23:31:21.255Z | 2024-01-05T23:31:21.255Z |
543838 | 543838 | 20210316032432_XMCoF | HR000R | 2024-01-05T23:31:21.248Z | 2024-01-05T23:31:21.248Z |
543794 | 543794 | 20210316030220_Ordo1 | HR000R | 2024-01-05T23:31:21.243Z | 2024-01-05T23:31:21.243Z |
543753 | 543753 | 20210316023241_fJjlm | HR000R | 2024-01-05T23:31:21.238Z | 2024-01-05T23:31:21.238Z |
543759 | 543759 | 20210316023534_IxFno | HR000R | 2024-01-05T23:31:21.238Z | 2024-01-05T23:31:21.238Z |
543709 | 543709 | 20210316020708_OGbqd | HR000R | 2024-01-05T23:31:21.233Z | 2024-01-05T23:31:21.233Z |
543674 | 543674 | 20210316015642_Sj0hz | HR000R | 2024-01-05T23:31:21.230Z | 2024-01-05T23:31:21.230Z |
543665 | 543665 | 20210316015105_WjNhy | HR000R | 2024-01-05T23:31:21.229Z | 2024-01-05T23:31:21.229Z |
543495 | 543495 | 20210316003902_qF3aa | HR000R | 2024-01-05T23:31:21.208Z | 2024-01-05T23:31:21.208Z |
543223 | 543223 | 20210315200012_dYBH1 | HR000R | 2024-01-05T23:31:21.171Z | 2024-01-05T23:31:21.171Z |
543220 | 543220 | 20210315195753_I4uVr | HR000R | 2024-01-05T23:31:21.170Z | 2024-01-05T23:31:21.170Z |
541762 | 541762 | 20210313015254_ebfjF | HR000R | 2024-01-05T23:31:16.277Z | 2024-01-05T23:31:16.277Z |
540625 | 540625 | 20210310211709_LUSdM | HR000R | 2024-01-05T23:31:13.634Z | 2024-01-05T23:31:13.634Z |
538287 | 538287 | 20210307203830_YN3Yv | HR000R | 2024-01-05T23:31:09.357Z | 2024-01-05T23:31:09.357Z |
538202 | 538202 | 20210307180025_52oyj | HR000R | 2024-01-05T23:31:09.345Z | 2024-01-05T23:31:09.345Z |
537548 | 537548 | 20210307031638_UqdwW | HR000R | 2024-01-05T23:31:07.777Z | 2024-01-05T23:31:07.777Z |
537400 | 537400 | 20210307020913_HDbZ8 | HR000R | 2024-01-05T23:31:07.757Z | 2024-01-05T23:31:07.757Z |
537347 | 537347 | 20210307013755_lL5qg | HR000R | 2024-01-05T23:31:07.752Z | 2024-01-05T23:31:07.752Z |
537302 | 537302 | 20210307011028_dVxjS | HR000R | 2024-01-05T23:31:07.746Z | 2024-01-05T23:31:07.746Z |
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);