participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
11,571 rows where station_code = "HR000G" 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 |
---|---|---|---|---|---|
1949238 | 1949238 | 20221119032358_jdPek | HR000G | 2024-01-05T23:52:30.255Z | 2024-01-05T23:52:30.255Z |
1949213 | 1949213 | 20221119031652_MfNu7 | HR000G | 2024-01-05T23:52:30.252Z | 2024-01-05T23:52:30.252Z |
1949182 | 1949182 | 20221119030828_cV0rP | HR000G | 2024-01-05T23:52:30.246Z | 2024-01-05T23:52:30.246Z |
1949139 | 1949139 | 20221119025806_6tLi2 | HR000G | 2024-01-05T23:52:30.239Z | 2024-01-05T23:52:30.239Z |
1949082 | 1949082 | 20221119025054_rOoZ4 | HR000G | 2024-01-05T23:52:30.232Z | 2024-01-05T23:52:30.232Z |
1949041 | 1949041 | 20221119023936_92Xxj | HR000G | 2024-01-05T23:52:30.226Z | 2024-01-05T23:52:30.226Z |
1948968 | 1948968 | 20221119022222_qZ3wW | HR000G | 2024-01-05T23:52:30.214Z | 2024-01-05T23:52:30.214Z |
1948909 | 1948909 | 20221119021130_3aEvI | HR000G | 2024-01-05T23:52:30.206Z | 2024-01-05T23:52:30.206Z |
1948887 | 1948887 | 20221119020855_Qve1l | HR000G | 2024-01-05T23:52:30.202Z | 2024-01-05T23:52:30.202Z |
1948876 | 1948876 | 20221119020736_lXGvh | HR000G | 2024-01-05T23:52:30.200Z | 2024-01-05T23:52:30.200Z |
1948868 | 1948868 | 20221119020357_rBY9J | HR000G | 2024-01-05T23:52:30.199Z | 2024-01-05T23:52:30.199Z |
1948866 | 1948866 | 20221119020337_Lcm2w | HR000G | 2024-01-05T23:52:30.198Z | 2024-01-05T23:52:30.198Z |
1948849 | 1948849 | 20221119015946_TxjZf | HR000G | 2024-01-05T23:52:30.195Z | 2024-01-05T23:52:30.195Z |
1948642 | 1948642 | 20221119010913_2TD8x | HR000G | 2024-01-05T23:52:30.134Z | 2024-01-05T23:52:30.134Z |
1948636 | 1948636 | 20221119010756_9JlI7 | HR000G | 2024-01-05T23:52:30.132Z | 2024-01-05T23:52:30.132Z |
1948451 | 1948451 | 20221119000608_IAcRU | HR000G | 2024-01-05T23:52:30.067Z | 2024-01-05T23:52:30.067Z |
1948426 | 1948426 | 20221119000334_Y1BpB | HR000G | 2024-01-05T23:52:30.061Z | 2024-01-05T23:52:30.061Z |
1948270 | 1948270 | 20221118230942_GLzUi | HR000G | 2024-01-05T23:52:30.000Z | 2024-01-05T23:52:30.000Z |
1948268 | 1948268 | 20221118230741_pvd2k | HR000G | 2024-01-05T23:52:29.999Z | 2024-01-05T23:52:29.999Z |
1948214 | 1948214 | 20221118224714_X7dVI | HR000G | 2024-01-05T23:52:29.983Z | 2024-01-05T23:52:29.983Z |
1948189 | 1948189 | 20221118224107_asJnA | HR000G | 2024-01-05T23:52:29.976Z | 2024-01-05T23:52:29.976Z |
1948129 | 1948129 | 20221118221643_OK53h | HR000G | 2024-01-05T23:52:29.946Z | 2024-01-05T23:52:29.946Z |
1948110 | 1948110 | 20221118220924_OQm48 | HR000G | 2024-01-05T23:52:29.941Z | 2024-01-05T23:52:29.941Z |
1948077 | 1948077 | 20221118220512_sFRwL | HR000G | 2024-01-05T23:52:29.934Z | 2024-01-05T23:52:29.934Z |
1947967 | 1947967 | 20221118212139_3FwjB | HR000G | 2024-01-05T23:52:29.907Z | 2024-01-05T23:52:29.907Z |
1947931 | 1947931 | 20221118210820_pk0ZJ | HR000G | 2024-01-05T23:52:29.897Z | 2024-01-05T23:52:29.897Z |
1947895 | 1947895 | 20221118205550_3zovl | HR000G | 2024-01-05T23:52:29.869Z | 2024-01-05T23:52:29.869Z |
1947889 | 1947889 | 20221118205421_7NcE1 | HR000G | 2024-01-05T23:52:29.867Z | 2024-01-05T23:52:29.867Z |
1947874 | 1947874 | 20221118204939_oOLBk | HR000G | 2024-01-05T23:52:29.864Z | 2024-01-05T23:52:29.864Z |
1947799 | 1947799 | 20221118202625_sy02Q | HR000G | 2024-01-05T23:52:29.843Z | 2024-01-05T23:52:29.843Z |
1947770 | 1947770 | 20221118201648_sbNsh | HR000G | 2024-01-05T23:52:29.835Z | 2024-01-05T23:52:29.835Z |
1947735 | 1947735 | 20221118195900_SRZvZ | HR000G | 2024-01-05T23:52:29.803Z | 2024-01-05T23:52:29.803Z |
1947631 | 1947631 | 20221118193107_uqTKm | HR000G | 2024-01-05T23:52:29.764Z | 2024-01-05T23:52:29.764Z |
1947508 | 1947508 | 20221118185550_IdrZm | HR000G | 2024-01-05T23:52:29.675Z | 2024-01-05T23:52:29.675Z |
1939365 | 1939365 | 20221117032059_C2rdc | HR000G | 2024-01-05T23:52:24.520Z | 2024-01-05T23:52:24.520Z |
1923721 | 1923721 | 20221112184915_iWi7O | HR000G | 2024-01-05T23:52:13.085Z | 2024-01-05T23:52:13.085Z |
1923640 | 1923640 | 20221112180505_9p4Sk | HR000G | 2024-01-05T23:52:13.076Z | 2024-01-05T23:52:13.076Z |
1922086 | 1922086 | 20221112013604_heJmr | HR000G | 2024-01-05T23:52:11.645Z | 2024-01-05T23:52:11.645Z |
1922079 | 1922079 | 20221112013433_trMki | HR000G | 2024-01-05T23:52:11.644Z | 2024-01-05T23:52:11.644Z |
1922008 | 1922008 | 20221112005955_9HR6X | HR000G | 2024-01-05T23:52:11.633Z | 2024-01-05T23:52:11.633Z |
1921985 | 1921985 | 20221112004429_9HwRl | HR000G | 2024-01-05T23:52:11.630Z | 2024-01-05T23:52:11.630Z |
1921935 | 1921935 | 20221112002837_ewePz | HR000G | 2024-01-05T23:52:11.623Z | 2024-01-05T23:52:11.623Z |
1921236 | 1921236 | 20221111181749_T98FP | HR000G | 2024-01-05T23:52:11.518Z | 2024-01-05T23:52:11.518Z |
1921101 | 1921101 | 20221111170459_DFIuw | HR000G | 2024-01-05T23:52:10.326Z | 2024-01-05T23:52:10.326Z |
1921090 | 1921090 | 20221111163718_cdoJo | HR000G | 2024-01-05T23:52:10.324Z | 2024-01-05T23:52:10.324Z |
1919369 | 1919369 | 20221109005203_2f2Da | HR000G | 2024-01-05T23:52:07.755Z | 2024-01-05T23:52:07.755Z |
1919359 | 1919359 | 20221109004230_t234j | HR000G | 2024-01-05T23:52:07.753Z | 2024-01-05T23:52:07.753Z |
1917512 | 1917512 | 20221108041802_7w03K | HR000G | 2024-01-05T23:52:06.389Z | 2024-01-05T23:52:06.389Z |
1917473 | 1917473 | 20221108035347_Jzr3a | HR000G | 2024-01-05T23:52:06.384Z | 2024-01-05T23:52:06.384Z |
1917469 | 1917469 | 20221108035117_HMu74 | HR000G | 2024-01-05T23:52:06.383Z | 2024-01-05T23:52:06.383Z |
1917471 | 1917471 | 20221108035234_NwanA | HR000G | 2024-01-05T23:52:06.383Z | 2024-01-05T23:52:06.383Z |
1917443 | 1917443 | 20221108033640_RML4v | HR000G | 2024-01-05T23:52:06.379Z | 2024-01-05T23:52:06.379Z |
1917429 | 1917429 | 20221108032837_BCsgG | HR000G | 2024-01-05T23:52:06.377Z | 2024-01-05T23:52:06.377Z |
1917363 | 1917363 | 20221108023844_23l52 | HR000G | 2024-01-05T23:52:06.368Z | 2024-01-05T23:52:06.368Z |
1917305 | 1917305 | 20221108021925_59ED0 | HR000G | 2024-01-05T23:52:06.361Z | 2024-01-05T23:52:06.361Z |
1917288 | 1917288 | 20221108020517_BxTqC | HR000G | 2024-01-05T23:52:06.358Z | 2024-01-05T23:52:06.358Z |
1917282 | 1917282 | 20221108020153_ZBY1w | HR000G | 2024-01-05T23:52:06.357Z | 2024-01-05T23:52:06.357Z |
1917248 | 1917248 | 20221108013504_X3IVx | HR000G | 2024-01-05T23:52:06.353Z | 2024-01-05T23:52:06.353Z |
1917208 | 1917208 | 20221108010420_wLGUl | HR000G | 2024-01-05T23:52:06.347Z | 2024-01-05T23:52:06.347Z |
1917211 | 1917211 | 20221108010529_pGITC | HR000G | 2024-01-05T23:52:06.347Z | 2024-01-05T23:52:06.347Z |
1917154 | 1917154 | 20221108000736_CTXbg | HR000G | 2024-01-05T23:52:06.340Z | 2024-01-05T23:52:06.340Z |
1917152 | 1917152 | 20221108000513_9DqYT | HR000G | 2024-01-05T23:52:06.339Z | 2024-01-05T23:52:06.339Z |
1917115 | 1917115 | 20221107233644_A2H2a | HR000G | 2024-01-05T23:52:06.335Z | 2024-01-05T23:52:06.335Z |
1917083 | 1917083 | 20221107231034_poMSM | HR000G | 2024-01-05T23:52:06.331Z | 2024-01-05T23:52:06.331Z |
1917020 | 1917020 | 20221107212954_ntl8j | HR000G | 2024-01-05T23:52:06.322Z | 2024-01-05T23:52:06.322Z |
1898652 | 1898652 | 20221103022955_dSDsG | HR000G | 2024-01-05T23:51:53.611Z | 2024-01-05T23:51:53.611Z |
1898528 | 1898528 | 20221103014347_5h9ys | HR000G | 2024-01-05T23:51:53.591Z | 2024-01-05T23:51:53.591Z |
1891891 | 1891891 | 20221102030802_TuGFh | HR000G | 2024-01-05T23:51:51.682Z | 2024-01-05T23:51:51.682Z |
1888654 | 1888654 | 20221101175045_Jv96k | HR000G | 2024-01-05T23:51:50.040Z | 2024-01-05T23:51:50.040Z |
1885821 | 1885821 | 20221101042037_L338e | HR000G | 2024-01-05T23:51:49.718Z | 2024-01-05T23:51:49.718Z |
1885552 | 1885552 | 20221101033113_a3PRO | HR000G | 2024-01-05T23:51:49.680Z | 2024-01-05T23:51:49.680Z |
1885334 | 1885334 | 20221101023857_aSn1l | HR000G | 2024-01-05T23:51:49.648Z | 2024-01-05T23:51:49.648Z |
1885199 | 1885199 | 20221101020840_6Agv2 | HR000G | 2024-01-05T23:51:49.628Z | 2024-01-05T23:51:49.628Z |
1885070 | 1885070 | 20221101013256_32vja | HR000G | 2024-01-05T23:51:49.609Z | 2024-01-05T23:51:49.609Z |
1885024 | 1885024 | 20221101012517_bq4J7 | HR000G | 2024-01-05T23:51:49.603Z | 2024-01-05T23:51:49.603Z |
1885017 | 1885017 | 20221101012045_t1agV | HR000G | 2024-01-05T23:51:49.602Z | 2024-01-05T23:51:49.602Z |
1885003 | 1885003 | 20221101011752_jpWbZ | HR000G | 2024-01-05T23:51:49.600Z | 2024-01-05T23:51:49.600Z |
1884998 | 1884998 | 20221101011612_ojlKJ | HR000G | 2024-01-05T23:51:49.599Z | 2024-01-05T23:51:49.599Z |
1884996 | 1884996 | 20221101011527_N8A7D | HR000G | 2024-01-05T23:51:49.598Z | 2024-01-05T23:51:49.598Z |
1884935 | 1884935 | 20221101003524_29ye2 | HR000G | 2024-01-05T23:51:49.588Z | 2024-01-05T23:51:49.588Z |
1884912 | 1884912 | 20221101002227_Yw7sH | HR000G | 2024-01-05T23:51:49.585Z | 2024-01-05T23:51:49.585Z |
1884870 | 1884870 | 20221101000232_B3jRz | HR000G | 2024-01-05T23:51:49.578Z | 2024-01-05T23:51:49.578Z |
1884809 | 1884809 | 20221031233126_Nxu2a | HR000G | 2024-01-05T23:51:49.568Z | 2024-01-05T23:51:49.568Z |
1884800 | 1884800 | 20221031232457_kRRsn | HR000G | 2024-01-05T23:51:49.567Z | 2024-01-05T23:51:49.567Z |
1884767 | 1884767 | 20221031230609_nxaND | HR000G | 2024-01-05T23:51:49.562Z | 2024-01-05T23:51:49.562Z |
1884752 | 1884752 | 20221031225045_Jz37L | HR000G | 2024-01-05T23:51:49.560Z | 2024-01-05T23:51:49.560Z |
1884744 | 1884744 | 20221031224142_pPytW | HR000G | 2024-01-05T23:51:49.558Z | 2024-01-05T23:51:49.558Z |
1884733 | 1884733 | 20221031223133_SDYxM | HR000G | 2024-01-05T23:51:49.556Z | 2024-01-05T23:51:49.556Z |
1884718 | 1884718 | 20221031222611_Q2dx2 | HR000G | 2024-01-05T23:51:49.554Z | 2024-01-05T23:51:49.554Z |
1884713 | 1884713 | 20221031222040_U1kn3 | HR000G | 2024-01-05T23:51:49.553Z | 2024-01-05T23:51:49.553Z |
1884688 | 1884688 | 20221031215529_HFv8F | HR000G | 2024-01-05T23:51:49.549Z | 2024-01-05T23:51:49.549Z |
1884649 | 1884649 | 20221031212859_QpYWt | HR000G | 2024-01-05T23:51:49.543Z | 2024-01-05T23:51:49.543Z |
1884651 | 1884651 | 20221031213015_E6v0Q | HR000G | 2024-01-05T23:51:49.543Z | 2024-01-05T23:51:49.543Z |
1884607 | 1884607 | 20221031204911_pgFAv | HR000G | 2024-01-05T23:51:49.535Z | 2024-01-05T23:51:49.535Z |
1884599 | 1884599 | 20221031203912_qKuNR | HR000G | 2024-01-05T23:51:49.534Z | 2024-01-05T23:51:49.534Z |
1884589 | 1884589 | 20221031203057_3BAor | HR000G | 2024-01-05T23:51:49.533Z | 2024-01-05T23:51:49.533Z |
1884580 | 1884580 | 20221031202452_Go506 | HR000G | 2024-01-05T23:51:49.531Z | 2024-01-05T23:51:49.531Z |
1884548 | 1884548 | 20221031195512_7zUr0 | HR000G | 2024-01-05T23:51:49.526Z | 2024-01-05T23:51:49.526Z |
1884473 | 1884473 | 20221031190125_vHD0F | HR000G | 2024-01-05T23:51:49.514Z | 2024-01-05T23:51:49.514Z |
1884467 | 1884467 | 20221031185825_rY378 | HR000G | 2024-01-05T23:51:49.513Z | 2024-01-05T23:51:49.513Z |
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);