participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,489 rows where station_code = "HR001S" 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 |
---|---|---|---|---|---|
3435009 | 3435009 | 20231119184258_bOsTF | HR001S | 2024-01-06T00:04:31.423Z | 2024-01-06T00:04:31.423Z |
3434786 | 3434786 | 20231119182025_5M3Y2 | HR001S | 2024-01-06T00:04:31.404Z | 2024-01-06T00:04:31.404Z |
3434696 | 3434696 | 20231119181355_WZtyz | HR001S | 2024-01-06T00:04:31.396Z | 2024-01-06T00:04:31.396Z |
3434600 | 3434600 | 20231119180910_7eyR8 | HR001S | 2024-01-06T00:04:31.388Z | 2024-01-06T00:04:31.388Z |
3434166 | 3434166 | 20231119172952_u4vNr | HR001S | 2024-01-06T00:04:31.352Z | 2024-01-06T00:04:31.352Z |
3433980 | 3433980 | 20231119170833_DoQiF | HR001S | 2024-01-06T00:04:31.336Z | 2024-01-06T00:04:31.336Z |
3428862 | 3428862 | 20231119015814_RtIjs | HR001S | 2024-01-06T00:04:30.798Z | 2024-01-06T00:04:30.798Z |
3428655 | 3428655 | 20231119014325_OAndr | HR001S | 2024-01-06T00:04:30.780Z | 2024-01-06T00:04:30.780Z |
3428034 | 3428034 | 20231119004943_U9E1w | HR001S | 2024-01-06T00:04:30.725Z | 2024-01-06T00:04:30.725Z |
3427642 | 3427642 | 20231118235947_vH2zf | HR001S | 2024-01-06T00:04:30.686Z | 2024-01-06T00:04:30.686Z |
3427421 | 3427421 | 20231118232925_5v9Vx | HR001S | 2024-01-06T00:04:30.665Z | 2024-01-06T00:04:30.665Z |
3427155 | 3427155 | 20231118224916_6toU6 | HR001S | 2024-01-06T00:04:30.636Z | 2024-01-06T00:04:30.636Z |
3426916 | 3426916 | 20231118220612_3V3Lq | HR001S | 2024-01-06T00:04:29.240Z | 2024-01-06T00:04:29.240Z |
3426769 | 3426769 | 20231118213203_L1RNQ | HR001S | 2024-01-06T00:04:29.222Z | 2024-01-06T00:04:29.222Z |
3426695 | 3426695 | 20231118210735_saBBc | HR001S | 2024-01-06T00:04:29.212Z | 2024-01-06T00:04:29.212Z |
3426596 | 3426596 | 20231118204309_5DofV | HR001S | 2024-01-06T00:04:29.199Z | 2024-01-06T00:04:29.199Z |
3426353 | 3426353 | 20231118195816_zPVcq | HR001S | 2024-01-06T00:04:29.173Z | 2024-01-06T00:04:29.173Z |
3426355 | 3426355 | 20231118195853_8twdr | HR001S | 2024-01-06T00:04:29.173Z | 2024-01-06T00:04:29.173Z |
3426244 | 3426244 | 20231118194531_HllfN | HR001S | 2024-01-06T00:04:29.160Z | 2024-01-06T00:04:29.160Z |
3425750 | 3425750 | 20231118183745_tS1N0 | HR001S | 2024-01-06T00:04:29.106Z | 2024-01-06T00:04:29.106Z |
3425681 | 3425681 | 20231118183124_hbTiv | HR001S | 2024-01-06T00:04:29.099Z | 2024-01-06T00:04:29.099Z |
3421350 | 3421350 | 20231118042231_ZPlqC | HR001S | 2024-01-06T00:04:28.635Z | 2024-01-06T00:04:28.635Z |
3421186 | 3421186 | 20231118035006_ouB4o | HR001S | 2024-01-06T00:04:28.615Z | 2024-01-06T00:04:28.615Z |
3421028 | 3421028 | 20231118032125_n8CoZ | HR001S | 2024-01-06T00:04:28.595Z | 2024-01-06T00:04:28.595Z |
3420362 | 3420362 | 20231118012018_dzFSq | HR001S | 2024-01-06T00:04:28.511Z | 2024-01-06T00:04:28.511Z |
3420349 | 3420349 | 20231118011723_Eg1lC | HR001S | 2024-01-06T00:04:28.509Z | 2024-01-06T00:04:28.509Z |
3420035 | 3420035 | 20231117235634_WUHH2 | HR001S | 2024-01-06T00:04:28.472Z | 2024-01-06T00:04:28.472Z |
3420001 | 3420001 | 20231117235041_gPBeA | HR001S | 2024-01-06T00:04:28.467Z | 2024-01-06T00:04:28.467Z |
3419989 | 3419989 | 20231117234536_Okemh | HR001S | 2024-01-06T00:04:28.466Z | 2024-01-06T00:04:28.466Z |
3419890 | 3419890 | 20231117225744_wPeuw | HR001S | 2024-01-06T00:04:28.452Z | 2024-01-06T00:04:28.452Z |
3419884 | 3419884 | 20231117225314_luTkO | HR001S | 2024-01-06T00:04:27.187Z | 2024-01-06T00:04:27.187Z |
3419809 | 3419809 | 20231117222234_a0fhF | HR001S | 2024-01-06T00:04:27.176Z | 2024-01-06T00:04:27.176Z |
3419773 | 3419773 | 20231117215658_UXlN2 | HR001S | 2024-01-06T00:04:27.170Z | 2024-01-06T00:04:27.170Z |
3408463 | 3408463 | 20231116042815_LwlBk | HR001S | 2024-01-06T00:04:24.458Z | 2024-01-06T00:04:24.458Z |
3408411 | 3408411 | 20231116041146_D0ibh | HR001S | 2024-01-06T00:04:24.450Z | 2024-01-06T00:04:24.450Z |
3408369 | 3408369 | 20231116035243_5qgiE | HR001S | 2024-01-06T00:04:24.445Z | 2024-01-06T00:04:24.445Z |
3408350 | 3408350 | 20231116034716_IprEL | HR001S | 2024-01-06T00:04:24.442Z | 2024-01-06T00:04:24.442Z |
3408314 | 3408314 | 20231116033614_kynVQ | HR001S | 2024-01-06T00:04:24.437Z | 2024-01-06T00:04:24.437Z |
3408216 | 3408216 | 20231116031451_mUooc | HR001S | 2024-01-06T00:04:24.422Z | 2024-01-06T00:04:24.422Z |
3408193 | 3408193 | 20231116030647_VhX2t | HR001S | 2024-01-06T00:04:24.420Z | 2024-01-06T00:04:24.420Z |
3408150 | 3408150 | 20231116030037_VlkLn | HR001S | 2024-01-06T00:04:24.415Z | 2024-01-06T00:04:24.415Z |
3408114 | 3408114 | 20231116025203_AKEfx | HR001S | 2024-01-06T00:04:24.410Z | 2024-01-06T00:04:24.410Z |
3408100 | 3408100 | 20231116024756_zsKTK | HR001S | 2024-01-06T00:04:24.408Z | 2024-01-06T00:04:24.408Z |
3408040 | 3408040 | 20231116023224_IMs5J | HR001S | 2024-01-06T00:04:24.401Z | 2024-01-06T00:04:24.401Z |
3407838 | 3407838 | 20231116014500_G2IEI | HR001S | 2024-01-06T00:04:24.372Z | 2024-01-06T00:04:24.372Z |
3407542 | 3407542 | 20231116003811_4y8FU | HR001S | 2024-01-06T00:04:24.331Z | 2024-01-06T00:04:24.331Z |
3407418 | 3407418 | 20231116000443_rHJpd | HR001S | 2024-01-06T00:04:24.315Z | 2024-01-06T00:04:24.315Z |
3407396 | 3407396 | 20231116000217_2Rmv4 | HR001S | 2024-01-06T00:04:24.312Z | 2024-01-06T00:04:24.312Z |
3407344 | 3407344 | 20231115235003_VtiVA | HR001S | 2024-01-06T00:04:24.305Z | 2024-01-06T00:04:24.305Z |
3407325 | 3407325 | 20231115234303_mPM9D | HR001S | 2024-01-06T00:04:24.303Z | 2024-01-06T00:04:24.303Z |
3407299 | 3407299 | 20231115234007_ynmNV | HR001S | 2024-01-06T00:04:24.299Z | 2024-01-06T00:04:24.299Z |
3407258 | 3407258 | 20231115233157_Es3OR | HR001S | 2024-01-06T00:04:24.294Z | 2024-01-06T00:04:24.294Z |
3407158 | 3407158 | 20231115230454_h4pH6 | HR001S | 2024-01-06T00:04:22.970Z | 2024-01-06T00:04:22.970Z |
3380565 | 3380565 | 20231113043945_1cDeu | HR001S | 2024-01-06T00:04:17.699Z | 2024-01-06T00:04:17.699Z |
3380433 | 3380433 | 20231113040102_xoypR | HR001S | 2024-01-06T00:04:17.681Z | 2024-01-06T00:04:17.681Z |
3380437 | 3380437 | 20231113040350_dO5hl | HR001S | 2024-01-06T00:04:17.681Z | 2024-01-06T00:04:17.681Z |
3380258 | 3380258 | 20231113031316_mrJl0 | HR001S | 2024-01-06T00:04:17.655Z | 2024-01-06T00:04:17.655Z |
3380222 | 3380222 | 20231113030238_zgblf | HR001S | 2024-01-06T00:04:17.650Z | 2024-01-06T00:04:17.650Z |
3380098 | 3380098 | 20231113023555_pkq1F | HR001S | 2024-01-06T00:04:17.629Z | 2024-01-06T00:04:17.629Z |
3379963 | 3379963 | 20231113015529_t1csn | HR001S | 2024-01-06T00:04:17.610Z | 2024-01-06T00:04:17.610Z |
3379926 | 3379926 | 20231113013444_IoR6W | HR001S | 2024-01-06T00:04:17.603Z | 2024-01-06T00:04:17.603Z |
3379806 | 3379806 | 20231113002704_GQbDT | HR001S | 2024-01-06T00:04:17.582Z | 2024-01-06T00:04:17.582Z |
3379779 | 3379779 | 20231113000905_0IIaG | HR001S | 2024-01-06T00:04:17.578Z | 2024-01-06T00:04:17.578Z |
3379238 | 3379238 | 20231111224348_2gFl8 | HR001S | 2024-01-06T00:04:16.200Z | 2024-01-06T00:04:16.200Z |
3379147 | 3379147 | 20231111223128_BVj09 | HR001S | 2024-01-06T00:04:16.190Z | 2024-01-06T00:04:16.190Z |
3379142 | 3379142 | 20231111223111_EvRka | HR001S | 2024-01-06T00:04:16.189Z | 2024-01-06T00:04:16.189Z |
3378898 | 3378898 | 20231111220507_MBvuR | HR001S | 2024-01-06T00:04:16.163Z | 2024-01-06T00:04:16.163Z |
3378849 | 3378849 | 20231111215402_5m8WZ | HR001S | 2024-01-06T00:04:16.157Z | 2024-01-06T00:04:16.157Z |
3378686 | 3378686 | 20231111211420_fNf3B | HR001S | 2024-01-06T00:04:16.133Z | 2024-01-06T00:04:16.133Z |
3378616 | 3378616 | 20231111210317_8ctKF | HR001S | 2024-01-06T00:04:16.125Z | 2024-01-06T00:04:16.125Z |
3378458 | 3378458 | 20231111204023_xYktW | HR001S | 2024-01-06T00:04:16.106Z | 2024-01-06T00:04:16.106Z |
3378266 | 3378266 | 20231111201149_l8yRH | HR001S | 2024-01-06T00:04:16.087Z | 2024-01-06T00:04:16.087Z |
3377646 | 3377646 | 20231111185220_8hml3 | HR001S | 2024-01-06T00:04:16.026Z | 2024-01-06T00:04:16.026Z |
3377408 | 3377408 | 20231111182836_ZR9ap | HR001S | 2024-01-06T00:04:16.004Z | 2024-01-06T00:04:16.004Z |
3377289 | 3377289 | 20231111181531_N0noe | HR001S | 2024-01-06T00:04:15.994Z | 2024-01-06T00:04:15.994Z |
3376995 | 3376995 | 20231111174313_5yHCF | HR001S | 2024-01-06T00:04:15.969Z | 2024-01-06T00:04:15.969Z |
3376628 | 3376628 | 20231111165340_gccGd | HR001S | 2024-01-06T00:04:15.933Z | 2024-01-06T00:04:15.933Z |
3350701 | 3350701 | 20231109033949_OQiBP | HR001S | 2024-01-06T00:04:10.028Z | 2024-01-06T00:04:10.028Z |
3350552 | 3350552 | 20231109032308_sEN61 | HR001S | 2024-01-06T00:04:09.997Z | 2024-01-06T00:04:09.997Z |
3349073 | 3349073 | 20231108234544_s4vBk | HR001S | 2024-01-06T00:04:07.996Z | 2024-01-06T00:04:07.996Z |
3348990 | 3348990 | 20231108232614_tVpkt | HR001S | 2024-01-06T00:04:07.960Z | 2024-01-06T00:04:07.960Z |
3348946 | 3348946 | 20231108231104_s48CK | HR001S | 2024-01-06T00:04:07.942Z | 2024-01-06T00:04:07.942Z |
3348734 | 3348734 | 20231108222904_TzIPT | HR001S | 2024-01-06T00:04:07.855Z | 2024-01-06T00:04:07.855Z |
3348728 | 3348728 | 20231108222251_hasnT | HR001S | 2024-01-06T00:04:07.853Z | 2024-01-06T00:04:07.853Z |
3348587 | 3348587 | 20231108212808_yQ9fb | HR001S | 2024-01-06T00:04:07.790Z | 2024-01-06T00:04:07.790Z |
3348471 | 3348471 | 20231108204642_yFrt3 | HR001S | 2024-01-06T00:04:07.745Z | 2024-01-06T00:04:07.745Z |
3348423 | 3348423 | 20231108203553_3giQU | HR001S | 2024-01-06T00:04:07.725Z | 2024-01-06T00:04:07.725Z |
3348022 | 3348022 | 20231108192717_9Ngv9 | HR001S | 2024-01-06T00:04:07.534Z | 2024-01-06T00:04:07.534Z |
3347858 | 3347858 | 20231108184658_1Wycv | HR001S | 2024-01-06T00:04:07.470Z | 2024-01-06T00:04:07.470Z |
3347851 | 3347851 | 20231108184540_SgkiI | HR001S | 2024-01-06T00:04:07.467Z | 2024-01-06T00:04:07.467Z |
3347547 | 3347547 | 20231108174345_51Mjp | HR001S | 2024-01-06T00:04:07.357Z | 2024-01-06T00:04:07.357Z |
3347445 | 3347445 | 20231108171528_XMTee | HR001S | 2024-01-06T00:04:07.305Z | 2024-01-06T00:04:07.305Z |
3341621 | 3341621 | 20231108005158_2yOCR | HR001S | 2024-01-06T00:04:04.917Z | 2024-01-06T00:04:04.917Z |
3341562 | 3341562 | 20231108003820_1TAwV | HR001S | 2024-01-06T00:04:04.901Z | 2024-01-06T00:04:04.901Z |
3341487 | 3341487 | 20231108002109_FpfBa | HR001S | 2024-01-06T00:04:03.039Z | 2024-01-06T00:04:03.039Z |
3341333 | 3341333 | 20231107234849_cpxw2 | HR001S | 2024-01-06T00:04:03.004Z | 2024-01-06T00:04:03.004Z |
3341320 | 3341320 | 20231107234527_n9Hpg | HR001S | 2024-01-06T00:04:03.001Z | 2024-01-06T00:04:03.001Z |
3341284 | 3341284 | 20231107233632_G7bdy | HR001S | 2024-01-06T00:04:02.993Z | 2024-01-06T00:04:02.993Z |
3341174 | 3341174 | 20231107230428_ycVbO | HR001S | 2024-01-06T00:04:02.963Z | 2024-01-06T00:04:02.963Z |
3341051 | 3341051 | 20231107222948_VXu3Z | HR001S | 2024-01-06T00:04:02.932Z | 2024-01-06T00:04:02.932Z |
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);