participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,725 rows where station_code = "HR000T" 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 |
---|---|---|---|---|---|
1949603 | 1949603 | 20221119043300_gVfDO | HR000T | 2024-01-05T23:52:30.304Z | 2024-01-05T23:52:30.304Z |
1948953 | 1948953 | 20221119022122_GBpGe | HR000T | 2024-01-05T23:52:30.213Z | 2024-01-05T23:52:30.213Z |
1948511 | 1948511 | 20221119003007_xyyN3 | HR000T | 2024-01-05T23:52:30.082Z | 2024-01-05T23:52:30.082Z |
1948355 | 1948355 | 20221118234217_6qO3d | HR000T | 2024-01-05T23:52:30.040Z | 2024-01-05T23:52:30.040Z |
1948279 | 1948279 | 20221118231635_I4Jwi | HR000T | 2024-01-05T23:52:30.003Z | 2024-01-05T23:52:30.003Z |
1947802 | 1947802 | 20221118202716_W7vSE | HR000T | 2024-01-05T23:52:29.844Z | 2024-01-05T23:52:29.844Z |
1947780 | 1947780 | 20221118202034_vV4en | HR000T | 2024-01-05T23:52:29.838Z | 2024-01-05T23:52:29.838Z |
1947716 | 1947716 | 20221118195338_52IwJ | HR000T | 2024-01-05T23:52:29.796Z | 2024-01-05T23:52:29.796Z |
1898592 | 1898592 | 20221103020402_sBGfa | HR000T | 2024-01-05T23:51:53.601Z | 2024-01-05T23:51:53.601Z |
1893227 | 1893227 | 20221102042511_g8eLz | HR000T | 2024-01-05T23:51:51.794Z | 2024-01-05T23:51:51.794Z |
1893133 | 1893133 | 20221102041834_Qh7qO | HR000T | 2024-01-05T23:51:51.785Z | 2024-01-05T23:51:51.785Z |
1892829 | 1892829 | 20221102035957_JdbSz | HR000T | 2024-01-05T23:51:51.757Z | 2024-01-05T23:51:51.757Z |
1888611 | 1888611 | 20221101171143_tgk6U | HR000T | 2024-01-05T23:51:50.033Z | 2024-01-05T23:51:50.033Z |
1885954 | 1885954 | 20221101044832_xjlrK | HR000T | 2024-01-05T23:51:49.735Z | 2024-01-05T23:51:49.735Z |
1885636 | 1885636 | 20221101035039_bA4IM | HR000T | 2024-01-05T23:51:49.693Z | 2024-01-05T23:51:49.693Z |
1885028 | 1885028 | 20221101012601_vCjCw | HR000T | 2024-01-05T23:51:49.603Z | 2024-01-05T23:51:49.603Z |
1884956 | 1884956 | 20221101004857_lW5iL | HR000T | 2024-01-05T23:51:49.592Z | 2024-01-05T23:51:49.592Z |
1884868 | 1884868 | 20221101000138_noPzP | HR000T | 2024-01-05T23:51:49.578Z | 2024-01-05T23:51:49.578Z |
1884771 | 1884771 | 20221031230710_1KkcG | HR000T | 2024-01-05T23:51:49.563Z | 2024-01-05T23:51:49.563Z |
1884622 | 1884622 | 20221031205826_29C94 | HR000T | 2024-01-05T23:51:49.538Z | 2024-01-05T23:51:49.538Z |
1884546 | 1884546 | 20221031195216_X0FnF | HR000T | 2024-01-05T23:51:49.525Z | 2024-01-05T23:51:49.525Z |
1884533 | 1884533 | 20221031194030_QTeKE | HR000T | 2024-01-05T23:51:49.523Z | 2024-01-05T23:51:49.523Z |
1884425 | 1884425 | 20221031182235_fETQd | HR000T | 2024-01-05T23:51:48.223Z | 2024-01-05T23:51:48.223Z |
1884406 | 1884406 | 20221031180309_NeNgw | HR000T | 2024-01-05T23:51:48.220Z | 2024-01-05T23:51:48.220Z |
1884356 | 1884356 | 20221031172841_er6GG | HR000T | 2024-01-05T23:51:48.211Z | 2024-01-05T23:51:48.211Z |
1879691 | 1879691 | 20221031041451_A1hfx | HR000T | 2024-01-05T23:51:47.353Z | 2024-01-05T23:51:47.353Z |
1879474 | 1879474 | 20221031035601_7ox9G | HR000T | 2024-01-05T23:51:47.328Z | 2024-01-05T23:51:47.328Z |
1878583 | 1878583 | 20221031024327_aDmiP | HR000T | 2024-01-05T23:51:47.228Z | 2024-01-05T23:51:47.228Z |
1878293 | 1878293 | 20221031020339_RqrnQ | HR000T | 2024-01-05T23:51:47.192Z | 2024-01-05T23:51:47.192Z |
1878077 | 1878077 | 20221031013948_8VVAS | HR000T | 2024-01-05T23:51:47.164Z | 2024-01-05T23:51:47.164Z |
1878068 | 1878068 | 20221031013934_3J8C1 | HR000T | 2024-01-05T23:51:47.163Z | 2024-01-05T23:51:47.163Z |
1877993 | 1877993 | 20221031013109_1qio2 | HR000T | 2024-01-05T23:51:47.153Z | 2024-01-05T23:51:47.153Z |
1877771 | 1877771 | 20221031010128_PhH29 | HR000T | 2024-01-05T23:51:47.125Z | 2024-01-05T23:51:47.125Z |
1877745 | 1877745 | 20221031005735_3AK19 | HR000T | 2024-01-05T23:51:47.122Z | 2024-01-05T23:51:47.122Z |
1877679 | 1877679 | 20221031004830_nBQ1H | HR000T | 2024-01-05T23:51:47.113Z | 2024-01-05T23:51:47.113Z |
1877602 | 1877602 | 20221031004032_P21za | HR000T | 2024-01-05T23:51:47.103Z | 2024-01-05T23:51:47.103Z |
1877539 | 1877539 | 20221031002920_h50Rq | HR000T | 2024-01-05T23:51:47.093Z | 2024-01-05T23:51:47.093Z |
1877293 | 1877293 | 20221030235834_MDeLc | HR000T | 2024-01-05T23:51:47.058Z | 2024-01-05T23:51:47.058Z |
1877058 | 1877058 | 20221030232854_2tjuJ | HR000T | 2024-01-05T23:51:47.034Z | 2024-01-05T23:51:47.034Z |
1876942 | 1876942 | 20221030231721_oQgsp | HR000T | 2024-01-05T23:51:47.021Z | 2024-01-05T23:51:47.021Z |
1876571 | 1876571 | 20221030222129_VA2mp | HR000T | 2024-01-05T23:51:46.968Z | 2024-01-05T23:51:46.968Z |
1876529 | 1876529 | 20221030221409_Cla9z | HR000T | 2024-01-05T23:51:46.961Z | 2024-01-05T23:51:46.961Z |
1876494 | 1876494 | 20221030221023_zUoT4 | HR000T | 2024-01-05T23:51:46.956Z | 2024-01-05T23:51:46.956Z |
1876381 | 1876381 | 20221030214458_Xwn2B | HR000T | 2024-01-05T23:51:46.940Z | 2024-01-05T23:51:46.940Z |
1875955 | 1875955 | 20221030202426_7J9mx | HR000T | 2024-01-05T23:51:46.882Z | 2024-01-05T23:51:46.882Z |
1875946 | 1875946 | 20221030202256_h2NYz | HR000T | 2024-01-05T23:51:46.880Z | 2024-01-05T23:51:46.880Z |
1875909 | 1875909 | 20221030201611_UCYgi | HR000T | 2024-01-05T23:51:46.875Z | 2024-01-05T23:51:46.875Z |
1875911 | 1875911 | 20221030201645_cMvBl | HR000T | 2024-01-05T23:51:46.875Z | 2024-01-05T23:51:46.875Z |
1875902 | 1875902 | 20221030201416_sHYXq | HR000T | 2024-01-05T23:51:46.874Z | 2024-01-05T23:51:46.874Z |
1875775 | 1875775 | 20221030192614_vPMRu | HR000T | 2024-01-05T23:51:46.856Z | 2024-01-05T23:51:46.856Z |
1875587 | 1875587 | 20221030184025_qg9d7 | HR000T | 2024-01-05T23:51:46.831Z | 2024-01-05T23:51:46.831Z |
1875389 | 1875389 | 20221030174254_7vCDO | HR000T | 2024-01-05T23:51:45.343Z | 2024-01-05T23:51:45.343Z |
1870189 | 1870189 | 20221030041024_z8o3W | HR000T | 2024-01-05T23:51:43.218Z | 2024-01-05T23:51:43.218Z |
1870005 | 1870005 | 20221030035359_Nnv0x | HR000T | 2024-01-05T23:51:43.176Z | 2024-01-05T23:51:43.176Z |
1868271 | 1868271 | 20221030011353_Jm9A8 | HR000T | 2024-01-05T23:51:42.733Z | 2024-01-05T23:51:42.733Z |
1868163 | 1868163 | 20221030005933_TeO26 | HR000T | 2024-01-05T23:51:42.705Z | 2024-01-05T23:51:42.705Z |
1867914 | 1867914 | 20221030002554_1OWCq | HR000T | 2024-01-05T23:51:42.638Z | 2024-01-05T23:51:42.638Z |
1867883 | 1867883 | 20221030002241_RT52y | HR000T | 2024-01-05T23:51:42.631Z | 2024-01-05T23:51:42.631Z |
1867846 | 1867846 | 20221030001617_9oYeE | HR000T | 2024-01-05T23:51:42.621Z | 2024-01-05T23:51:42.621Z |
1867590 | 1867590 | 20221029231643_TArmT | HR000T | 2024-01-05T23:51:42.539Z | 2024-01-05T23:51:42.539Z |
1867397 | 1867397 | 20221029220851_8qMoK | HR000T | 2024-01-05T23:51:42.459Z | 2024-01-05T23:51:42.459Z |
1867332 | 1867332 | 20221029214816_2e3sI | HR000T | 2024-01-05T23:51:42.434Z | 2024-01-05T23:51:42.434Z |
1867134 | 1867134 | 20221029204603_Pdb5U | HR000T | 2024-01-05T23:51:42.356Z | 2024-01-05T23:51:42.356Z |
1867094 | 1867094 | 20221029203234_uVJF2 | HR000T | 2024-01-05T23:51:42.343Z | 2024-01-05T23:51:42.343Z |
1866960 | 1866960 | 20221029192404_tTevr | HR000T | 2024-01-05T23:51:42.288Z | 2024-01-05T23:51:42.288Z |
1866823 | 1866823 | 20221029173041_22f3C | HR000T | 2024-01-05T23:51:40.367Z | 2024-01-05T23:51:40.367Z |
1866807 | 1866807 | 20221029170503_LWzPW | HR000T | 2024-01-05T23:51:40.363Z | 2024-01-05T23:51:40.363Z |
1861224 | 1861224 | 20221029034254_oXIF4 | HR000T | 2024-01-05T23:51:39.082Z | 2024-01-05T23:51:39.082Z |
1861164 | 1861164 | 20221029032739_ltxZf | HR000T | 2024-01-05T23:51:39.064Z | 2024-01-05T23:51:39.064Z |
1861159 | 1861159 | 20221029032640_xSc3D | HR000T | 2024-01-05T23:51:39.063Z | 2024-01-05T23:51:39.063Z |
1861152 | 1861152 | 20221029032547_aD1Yk | HR000T | 2024-01-05T23:51:39.061Z | 2024-01-05T23:51:39.061Z |
1861024 | 1861024 | 20221029030911_MofDA | HR000T | 2024-01-05T23:51:39.024Z | 2024-01-05T23:51:39.024Z |
1860713 | 1860713 | 20221029022141_mdUh0 | HR000T | 2024-01-05T23:51:38.928Z | 2024-01-05T23:51:38.928Z |
1852906 | 1852906 | 20221027230615_LlD6Z | HR000T | 2024-01-05T23:51:34.529Z | 2024-01-05T23:51:34.529Z |
1852701 | 1852701 | 20221027215408_pIRii | HR000T | 2024-01-05T23:51:34.468Z | 2024-01-05T23:51:34.468Z |
1852660 | 1852660 | 20221027213011_BkSdQ | HR000T | 2024-01-05T23:51:34.455Z | 2024-01-05T23:51:34.455Z |
1852592 | 1852592 | 20221027211455_Ks6UH | HR000T | 2024-01-05T23:51:34.436Z | 2024-01-05T23:51:34.436Z |
1852349 | 1852349 | 20221027194635_XoKJ3 | HR000T | 2024-01-05T23:51:34.370Z | 2024-01-05T23:51:34.370Z |
1851993 | 1851993 | 20221027175023_kzB2b | HR000T | 2024-01-05T23:51:32.500Z | 2024-01-05T23:51:32.500Z |
1851922 | 1851922 | 20221027172302_V26tE | HR000T | 2024-01-05T23:51:32.490Z | 2024-01-05T23:51:32.490Z |
1848355 | 1848355 | 20221027042640_mFMzu | HR000T | 2024-01-05T23:51:32.069Z | 2024-01-05T23:51:32.069Z |
1848350 | 1848350 | 20221027042547_tQc1t | HR000T | 2024-01-05T23:51:32.067Z | 2024-01-05T23:51:32.067Z |
1848284 | 1848284 | 20221027041726_xMeCy | HR000T | 2024-01-05T23:51:32.058Z | 2024-01-05T23:51:32.058Z |
1847606 | 1847606 | 20221027024106_m2soD | HR000T | 2024-01-05T23:51:31.964Z | 2024-01-05T23:51:31.964Z |
1847382 | 1847382 | 20221027020910_III2C | HR000T | 2024-01-05T23:51:31.930Z | 2024-01-05T23:51:31.930Z |
1847270 | 1847270 | 20221027015830_QC2hH | HR000T | 2024-01-05T23:51:31.916Z | 2024-01-05T23:51:31.916Z |
1847034 | 1847034 | 20221027013108_2j4wL | HR000T | 2024-01-05T23:51:31.883Z | 2024-01-05T23:51:31.883Z |
1846449 | 1846449 | 20221026235105_NuPT7 | HR000T | 2024-01-05T23:51:31.796Z | 2024-01-05T23:51:31.796Z |
1846378 | 1846378 | 20221026233827_9w2zE | HR000T | 2024-01-05T23:51:31.788Z | 2024-01-05T23:51:31.788Z |
1846382 | 1846382 | 20221026233915_Xgvcn | HR000T | 2024-01-05T23:51:31.788Z | 2024-01-05T23:51:31.788Z |
1845441 | 1845441 | 20221026205206_1LLb2 | HR000T | 2024-01-05T23:51:31.666Z | 2024-01-05T23:51:31.666Z |
1845385 | 1845385 | 20221026203325_om11F | HR000T | 2024-01-05T23:51:31.660Z | 2024-01-05T23:51:31.660Z |
1844883 | 1844883 | 20221026175523_rAMqu | HR000T | 2024-01-05T23:51:30.276Z | 2024-01-05T23:51:30.276Z |
1844835 | 1844835 | 20221026171745_3BG2r | HR000T | 2024-01-05T23:51:30.263Z | 2024-01-05T23:51:30.263Z |
1838967 | 1838967 | 20221026012542_gskjO | HR000T | 2024-01-05T23:51:29.367Z | 2024-01-05T23:51:29.367Z |
1824935 | 1824935 | 20221024204512_HW7b6 | HR000T | 2024-01-05T23:51:26.119Z | 2024-01-05T23:51:26.119Z |
1819211 | 1819211 | 20221023212703_57RoK | HR000T | 2024-01-05T23:51:23.780Z | 2024-01-05T23:51:23.780Z |
1800880 | 1800880 | 20221020224225_5I2Cr | HR000T | 2024-01-05T23:51:17.595Z | 2024-01-05T23:51:17.595Z |
1800703 | 1800703 | 20221020213716_bcJvl | HR000T | 2024-01-05T23:51:17.574Z | 2024-01-05T23:51:17.574Z |
1800612 | 1800612 | 20221020210050_UabFG | HR000T | 2024-01-05T23:51:17.563Z | 2024-01-05T23:51:17.563Z |
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);