participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,929 rows where station_code = "HR000F" 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 |
---|---|---|---|---|---|
1919384 | 1919384 | 20221109010258_1Sw2J | HR000F | 2024-01-05T23:52:07.756Z | 2024-01-05T23:52:07.756Z |
1919181 | 1919181 | 20221108215019_slxi0 | HR000F | 2024-01-05T23:52:07.734Z | 2024-01-05T23:52:07.734Z |
1919148 | 1919148 | 20221108212149_2IDBh | HR000F | 2024-01-05T23:52:07.730Z | 2024-01-05T23:52:07.730Z |
1919137 | 1919137 | 20221108210628_r9u7v | HR000F | 2024-01-05T23:52:07.729Z | 2024-01-05T23:52:07.729Z |
1917468 | 1917468 | 20221108035050_UBwEb | HR000F | 2024-01-05T23:52:06.383Z | 2024-01-05T23:52:06.383Z |
1917338 | 1917338 | 20221108022941_jgZuw | HR000F | 2024-01-05T23:52:06.365Z | 2024-01-05T23:52:06.365Z |
1917287 | 1917287 | 20221108020406_c30VL | HR000F | 2024-01-05T23:52:06.358Z | 2024-01-05T23:52:06.358Z |
1917263 | 1917263 | 20221108013539_ACDH3 | HR000F | 2024-01-05T23:52:06.354Z | 2024-01-05T23:52:06.354Z |
1917218 | 1917218 | 20221108011901_QbBJE | HR000F | 2024-01-05T23:52:06.348Z | 2024-01-05T23:52:06.348Z |
1917071 | 1917071 | 20221107223451_lmaRB | HR000F | 2024-01-05T23:52:06.329Z | 2024-01-05T23:52:06.329Z |
1917038 | 1917038 | 20221107220136_Zy7Ex | HR000F | 2024-01-05T23:52:06.325Z | 2024-01-05T23:52:06.325Z |
1917027 | 1917027 | 20221107214436_Zouru | HR000F | 2024-01-05T23:52:06.323Z | 2024-01-05T23:52:06.323Z |
1916999 | 1916999 | 20221107203111_3vWCr | HR000F | 2024-01-05T23:52:06.319Z | 2024-01-05T23:52:06.319Z |
1916945 | 1916945 | 20221107181227_Yz5nN | HR000F | 2024-01-05T23:52:06.309Z | 2024-01-05T23:52:06.309Z |
1893131 | 1893131 | 20221102041834_Qh7qO | HR000F | 2024-01-05T23:51:51.785Z | 2024-01-05T23:51:51.785Z |
1892835 | 1892835 | 20221102040023_gRaSh | HR000F | 2024-01-05T23:51:51.758Z | 2024-01-05T23:51:51.758Z |
1885574 | 1885574 | 20221101033901_3jR2K | HR000F | 2024-01-05T23:51:49.684Z | 2024-01-05T23:51:49.684Z |
1885524 | 1885524 | 20221101032403_srrNc | HR000F | 2024-01-05T23:51:49.676Z | 2024-01-05T23:51:49.676Z |
1885402 | 1885402 | 20221101025138_XRar6 | HR000F | 2024-01-05T23:51:49.659Z | 2024-01-05T23:51:49.659Z |
1885026 | 1885026 | 20221101012601_vCjCw | HR000F | 2024-01-05T23:51:49.603Z | 2024-01-05T23:51:49.603Z |
1884866 | 1884866 | 20221101000138_noPzP | HR000F | 2024-01-05T23:51:49.578Z | 2024-01-05T23:51:49.578Z |
1884787 | 1884787 | 20221031231359_5l7aj | HR000F | 2024-01-05T23:51:49.565Z | 2024-01-05T23:51:49.565Z |
1884716 | 1884716 | 20221031222515_nDQq3 | HR000F | 2024-01-05T23:51:49.554Z | 2024-01-05T23:51:49.554Z |
1884660 | 1884660 | 20221031213257_lPgNx | HR000F | 2024-01-05T23:51:49.545Z | 2024-01-05T23:51:49.545Z |
1884633 | 1884633 | 20221031211149_hSlir | HR000F | 2024-01-05T23:51:49.540Z | 2024-01-05T23:51:49.540Z |
1884570 | 1884570 | 20221031201120_qdQbh | HR000F | 2024-01-05T23:51:49.530Z | 2024-01-05T23:51:49.530Z |
1884466 | 1884466 | 20221031185716_2XyGf | HR000F | 2024-01-05T23:51:49.512Z | 2024-01-05T23:51:49.512Z |
1884449 | 1884449 | 20221031184224_HcZc4 | HR000F | 2024-01-05T23:51:49.510Z | 2024-01-05T23:51:49.510Z |
1884423 | 1884423 | 20221031182235_fETQd | HR000F | 2024-01-05T23:51:48.223Z | 2024-01-05T23:51:48.223Z |
1884410 | 1884410 | 20221031180619_3WYZu | HR000F | 2024-01-05T23:51:48.221Z | 2024-01-05T23:51:48.221Z |
1879668 | 1879668 | 20221031041153_l6b1R | HR000F | 2024-01-05T23:51:47.350Z | 2024-01-05T23:51:47.350Z |
1878829 | 1878829 | 20221031030253_Bs2Dl | HR000F | 2024-01-05T23:51:47.258Z | 2024-01-05T23:51:47.258Z |
1878519 | 1878519 | 20221031023229_Gqdqa | HR000F | 2024-01-05T23:51:47.219Z | 2024-01-05T23:51:47.219Z |
1877916 | 1877916 | 20221031011927_BQba1 | HR000F | 2024-01-05T23:51:47.143Z | 2024-01-05T23:51:47.143Z |
1877722 | 1877722 | 20221031005245_LT6BE | HR000F | 2024-01-05T23:51:47.118Z | 2024-01-05T23:51:47.118Z |
1877677 | 1877677 | 20221031004830_nBQ1H | HR000F | 2024-01-05T23:51:47.113Z | 2024-01-05T23:51:47.113Z |
1877530 | 1877530 | 20221031002803_1WnUo | HR000F | 2024-01-05T23:51:47.092Z | 2024-01-05T23:51:47.092Z |
1877303 | 1877303 | 20221031000002_58QYL | HR000F | 2024-01-05T23:51:47.059Z | 2024-01-05T23:51:47.059Z |
1877170 | 1877170 | 20221030233922_xJcTV | HR000F | 2024-01-05T23:51:47.044Z | 2024-01-05T23:51:47.044Z |
1876811 | 1876811 | 20221030225553_jZ4Sl | HR000F | 2024-01-05T23:51:47.001Z | 2024-01-05T23:51:47.001Z |
1876516 | 1876516 | 20221030221205_O1Cjw | HR000F | 2024-01-05T23:51:46.959Z | 2024-01-05T23:51:46.959Z |
1876380 | 1876380 | 20221030214442_7nBM9 | HR000F | 2024-01-05T23:51:46.940Z | 2024-01-05T23:51:46.940Z |
1876248 | 1876248 | 20221030212717_4MRB4 | HR000F | 2024-01-05T23:51:46.923Z | 2024-01-05T23:51:46.923Z |
1875529 | 1875529 | 20221030182823_awwE0 | HR000F | 2024-01-05T23:51:46.824Z | 2024-01-05T23:51:46.824Z |
1875513 | 1875513 | 20221030182454_oArUO | HR000F | 2024-01-05T23:51:45.369Z | 2024-01-05T23:51:45.369Z |
1875484 | 1875484 | 20221030181739_8p4yI | HR000F | 2024-01-05T23:51:45.362Z | 2024-01-05T23:51:45.362Z |
1875326 | 1875326 | 20221030170357_o4Pd5 | HR000F | 2024-01-05T23:51:45.324Z | 2024-01-05T23:51:45.324Z |
1869776 | 1869776 | 20221030033415_36Guu | HR000F | 2024-01-05T23:51:43.113Z | 2024-01-05T23:51:43.113Z |
1869730 | 1869730 | 20221030032956_tk2wZ | HR000F | 2024-01-05T23:51:43.102Z | 2024-01-05T23:51:43.102Z |
1869122 | 1869122 | 20221030022516_MVxDA | HR000F | 2024-01-05T23:51:42.941Z | 2024-01-05T23:51:42.941Z |
1868717 | 1868717 | 20221030015030_2KOZT | HR000F | 2024-01-05T23:51:42.841Z | 2024-01-05T23:51:42.841Z |
1868654 | 1868654 | 20221030014456_Q93zH | HR000F | 2024-01-05T23:51:42.824Z | 2024-01-05T23:51:42.824Z |
1868478 | 1868478 | 20221030013304_0k33D | HR000F | 2024-01-05T23:51:42.782Z | 2024-01-05T23:51:42.782Z |
1867943 | 1867943 | 20221030002729_vDJXh | HR000F | 2024-01-05T23:51:42.647Z | 2024-01-05T23:51:42.647Z |
1867856 | 1867856 | 20221030001732_LczDX | HR000F | 2024-01-05T23:51:42.624Z | 2024-01-05T23:51:42.624Z |
1867735 | 1867735 | 20221029235225_noIUV | HR000F | 2024-01-05T23:51:42.591Z | 2024-01-05T23:51:42.591Z |
1867672 | 1867672 | 20221029233858_79Cis | HR000F | 2024-01-05T23:51:42.571Z | 2024-01-05T23:51:42.571Z |
1867395 | 1867395 | 20221029220851_8qMoK | HR000F | 2024-01-05T23:51:42.459Z | 2024-01-05T23:51:42.459Z |
1867294 | 1867294 | 20221029213821_fz3KK | HR000F | 2024-01-05T23:51:42.422Z | 2024-01-05T23:51:42.422Z |
1867056 | 1867056 | 20221029201429_wEy3C | HR000F | 2024-01-05T23:51:42.327Z | 2024-01-05T23:51:42.327Z |
1866977 | 1866977 | 20221029193508_5OxfA | HR000F | 2024-01-05T23:51:42.296Z | 2024-01-05T23:51:42.296Z |
1866958 | 1866958 | 20221029192404_tTevr | HR000F | 2024-01-05T23:51:42.288Z | 2024-01-05T23:51:42.288Z |
1861017 | 1861017 | 20221029030822_Zd7Sc | HR000F | 2024-01-05T23:51:39.022Z | 2024-01-05T23:51:39.022Z |
1860703 | 1860703 | 20221029021549_tbXF8 | HR000F | 2024-01-05T23:51:38.925Z | 2024-01-05T23:51:38.925Z |
1853355 | 1853355 | 20221028003241_9VbDO | HR000F | 2024-01-05T23:51:34.658Z | 2024-01-05T23:51:34.658Z |
1853282 | 1853282 | 20221028002044_kutQN | HR000F | 2024-01-05T23:51:34.640Z | 2024-01-05T23:51:34.640Z |
1853033 | 1853033 | 20221027233719_PNiGO | HR000F | 2024-01-05T23:51:34.569Z | 2024-01-05T23:51:34.569Z |
1852541 | 1852541 | 20221027205503_sJW4m | HR000F | 2024-01-05T23:51:34.421Z | 2024-01-05T23:51:34.421Z |
1852298 | 1852298 | 20221027192354_4dTjr | HR000F | 2024-01-05T23:51:34.356Z | 2024-01-05T23:51:34.356Z |
1852029 | 1852029 | 20221027180545_heSTJ | HR000F | 2024-01-05T23:51:32.506Z | 2024-01-05T23:51:32.506Z |
1851960 | 1851960 | 20221027173953_wasoh | HR000F | 2024-01-05T23:51:32.496Z | 2024-01-05T23:51:32.496Z |
1846917 | 1846917 | 20221027011547_sa0O0 | HR000F | 2024-01-05T23:51:31.864Z | 2024-01-05T23:51:31.864Z |
1846073 | 1846073 | 20221026225700_4UphG | HR000F | 2024-01-05T23:51:31.748Z | 2024-01-05T23:51:31.748Z |
1846058 | 1846058 | 20221026225418_yAmHu | HR000F | 2024-01-05T23:51:31.746Z | 2024-01-05T23:51:31.746Z |
1845440 | 1845440 | 20221026205206_1LLb2 | HR000F | 2024-01-05T23:51:31.666Z | 2024-01-05T23:51:31.666Z |
1844899 | 1844899 | 20221026180055_GN6VO | HR000F | 2024-01-05T23:51:30.279Z | 2024-01-05T23:51:30.279Z |
1844885 | 1844885 | 20221026175526_raZMp | HR000F | 2024-01-05T23:51:30.276Z | 2024-01-05T23:51:30.276Z |
1826267 | 1826267 | 20221024233805_laNiF | HR000F | 2024-01-05T23:51:26.253Z | 2024-01-05T23:51:26.253Z |
1824331 | 1824331 | 20221024175450_1w1hD | HR000F | 2024-01-05T23:51:24.436Z | 2024-01-05T23:51:24.436Z |
1800864 | 1800864 | 20221020223622_JhVWS | HR000F | 2024-01-05T23:51:17.593Z | 2024-01-05T23:51:17.593Z |
1800546 | 1800546 | 20221020202041_H1Gz0 | HR000F | 2024-01-05T23:51:17.555Z | 2024-01-05T23:51:17.555Z |
1800461 | 1800461 | 20221020193200_TnBmZ | HR000F | 2024-01-05T23:51:17.545Z | 2024-01-05T23:51:17.545Z |
1788218 | 1788218 | 20221019025255_amJqT | HR000F | 2024-01-05T23:51:13.567Z | 2024-01-05T23:51:13.567Z |
1787759 | 1787759 | 20221019020155_KC8ty | HR000F | 2024-01-05T23:51:13.506Z | 2024-01-05T23:51:13.506Z |
1787518 | 1787518 | 20221019012901_MKNOg | HR000F | 2024-01-05T23:51:13.473Z | 2024-01-05T23:51:13.473Z |
1786976 | 1786976 | 20221018235157_mddHJ | HR000F | 2024-01-05T23:51:13.402Z | 2024-01-05T23:51:13.402Z |
1786975 | 1786975 | 20221018235105_6AEQf | HR000F | 2024-01-05T23:51:13.401Z | 2024-01-05T23:51:13.401Z |
1786797 | 1786797 | 20221018232028_s9LiF | HR000F | 2024-01-05T23:51:13.376Z | 2024-01-05T23:51:13.376Z |
1786645 | 1786645 | 20221018225010_03nr3 | HR000F | 2024-01-05T23:51:13.353Z | 2024-01-05T23:51:13.353Z |
1786369 | 1786369 | 20221018211954_FlBvC | HR000F | 2024-01-05T23:51:13.311Z | 2024-01-05T23:51:13.311Z |
1786240 | 1786240 | 20221018203131_StkGL | HR000F | 2024-01-05T23:51:13.292Z | 2024-01-05T23:51:13.292Z |
1785934 | 1785934 | 20221018190038_uN1ui | HR000F | 2024-01-05T23:51:13.245Z | 2024-01-05T23:51:13.245Z |
1780980 | 1780980 | 20221018021211_ax93T | HR000F | 2024-01-05T23:51:11.343Z | 2024-01-05T23:51:11.343Z |
1780602 | 1780602 | 20221018014142_KSzLJ | HR000F | 2024-01-05T23:51:11.300Z | 2024-01-05T23:51:11.300Z |
1779766 | 1779766 | 20221018002206_ihJ3z | HR000F | 2024-01-05T23:51:11.207Z | 2024-01-05T23:51:11.207Z |
1778415 | 1778415 | 20221017212410_eqL63 | HR000F | 2024-01-05T23:51:11.057Z | 2024-01-05T23:51:11.057Z |
1778078 | 1778078 | 20221017200911_AEhmR | HR000F | 2024-01-05T23:51:11.016Z | 2024-01-05T23:51:11.016Z |
1777714 | 1777714 | 20221017182251_PlOdp | HR000F | 2024-01-05T23:51:10.972Z | 2024-01-05T23:51:10.972Z |
1777710 | 1777710 | 20221017182133_H39ls | HR000F | 2024-01-05T23:51:10.971Z | 2024-01-05T23:51:10.971Z |
1777676 | 1777676 | 20221017180603_tC5i9 | HR000F | 2024-01-05T23:51:10.966Z | 2024-01-05T23:51:10.966Z |
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);