participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
16,805 rows where station_code = "USL00H" 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 |
---|---|---|---|---|---|
2371822 | 2371822 | 20230409115624_7Ul79 | USL00H | 2024-01-05T23:56:45.151Z | 2024-01-05T23:56:45.151Z |
2371740 | 2371740 | 20230409112749_DXmNQ | USL00H | 2024-01-05T23:56:45.116Z | 2024-01-05T23:56:45.116Z |
2371718 | 2371718 | 20230409112055_0OjbV | USL00H | 2024-01-05T23:56:45.107Z | 2024-01-05T23:56:45.107Z |
2371709 | 2371709 | 20230409111522_3Pnxw | USL00H | 2024-01-05T23:56:45.103Z | 2024-01-05T23:56:45.103Z |
2371690 | 2371690 | 20230409110359_fPJuT | USL00H | 2024-01-05T23:56:45.096Z | 2024-01-05T23:56:45.096Z |
2371679 | 2371679 | 20230409105458_baCPI | USL00H | 2024-01-05T23:56:45.071Z | 2024-01-05T23:56:45.071Z |
2371660 | 2371660 | 20230409104338_RyL1l | USL00H | 2024-01-05T23:56:45.061Z | 2024-01-05T23:56:45.061Z |
2371631 | 2371631 | 20230409102858_ZhGAR | USL00H | 2024-01-05T23:56:43.550Z | 2024-01-05T23:56:43.550Z |
2371621 | 2371621 | 20230409102452_nd39V | USL00H | 2024-01-05T23:56:43.548Z | 2024-01-05T23:56:43.548Z |
2371539 | 2371539 | 20230409090925_NBdke | USL00H | 2024-01-05T23:56:43.501Z | 2024-01-05T23:56:43.501Z |
2371522 | 2371522 | 20230409085718_VisQ7 | USL00H | 2024-01-05T23:56:43.497Z | 2024-01-05T23:56:43.497Z |
2371435 | 2371435 | 20230409074435_TlYRs | USL00H | 2024-01-05T23:56:43.462Z | 2024-01-05T23:56:43.462Z |
2368813 | 2368813 | 20230407121535_ynDrI | USL00H | 2024-01-05T23:56:41.693Z | 2024-01-05T23:56:41.693Z |
2368807 | 2368807 | 20230407121247_Ga2De | USL00H | 2024-01-05T23:56:41.692Z | 2024-01-05T23:56:41.692Z |
2368771 | 2368771 | 20230407115619_oyQXy | USL00H | 2024-01-05T23:56:41.687Z | 2024-01-05T23:56:41.687Z |
2368758 | 2368758 | 20230407114406_E3wpn | USL00H | 2024-01-05T23:56:41.686Z | 2024-01-05T23:56:41.686Z |
2368740 | 2368740 | 20230407112851_OC0A8 | USL00H | 2024-01-05T23:56:41.684Z | 2024-01-05T23:56:41.684Z |
2368722 | 2368722 | 20230407111852_23UjP | USL00H | 2024-01-05T23:56:41.682Z | 2024-01-05T23:56:41.682Z |
2368699 | 2368699 | 20230407110610_FOxXi | USL00H | 2024-01-05T23:56:41.679Z | 2024-01-05T23:56:41.679Z |
2368688 | 2368688 | 20230407105629_0AwNO | USL00H | 2024-01-05T23:56:41.678Z | 2024-01-05T23:56:41.678Z |
2368651 | 2368651 | 20230407101637_9ZxiF | USL00H | 2024-01-05T23:56:41.672Z | 2024-01-05T23:56:41.672Z |
2368614 | 2368614 | 20230407092200_LHXeB | USL00H | 2024-01-05T23:56:40.530Z | 2024-01-05T23:56:40.530Z |
2368521 | 2368521 | 20230407080304_LXbfu | USL00H | 2024-01-05T23:56:40.520Z | 2024-01-05T23:56:40.520Z |
2368437 | 2368437 | 20230407064633_hWDID | USL00H | 2024-01-05T23:56:40.511Z | 2024-01-05T23:56:40.511Z |
2368401 | 2368401 | 20230407053611_tJr2J | USL00H | 2024-01-05T23:56:40.507Z | 2024-01-05T23:56:40.507Z |
2368359 | 2368359 | 20230407044205_HHu2w | USL00H | 2024-01-05T23:56:40.503Z | 2024-01-05T23:56:40.503Z |
2368325 | 2368325 | 20230407041511_GIv35 | USL00H | 2024-01-05T23:56:40.501Z | 2024-01-05T23:56:40.501Z |
2367439 | 2367439 | 20230406112628_WnS3T | USL00H | 2024-01-05T23:56:40.408Z | 2024-01-05T23:56:40.408Z |
2367445 | 2367445 | 20230406112947_SE0J8 | USL00H | 2024-01-05T23:56:40.408Z | 2024-01-05T23:56:40.408Z |
2367437 | 2367437 | 20230406112230_8MAYv | USL00H | 2024-01-05T23:56:40.407Z | 2024-01-05T23:56:40.407Z |
2367398 | 2367398 | 20230406102852_Oli8y | USL00H | 2024-01-05T23:56:40.403Z | 2024-01-05T23:56:40.403Z |
2367389 | 2367389 | 20230406102816_rU8vi | USL00H | 2024-01-05T23:56:40.402Z | 2024-01-05T23:56:40.402Z |
2367368 | 2367368 | 20230406095413_tnuGY | USL00H | 2024-01-05T23:56:40.400Z | 2024-01-05T23:56:40.400Z |
2367362 | 2367362 | 20230406095233_wYXqT | USL00H | 2024-01-05T23:56:40.399Z | 2024-01-05T23:56:40.399Z |
2367344 | 2367344 | 20230406092236_20IXP | USL00H | 2024-01-05T23:56:40.396Z | 2024-01-05T23:56:40.396Z |
2367287 | 2367287 | 20230406065418_56dj0 | USL00H | 2024-01-05T23:56:39.288Z | 2024-01-05T23:56:39.288Z |
2367298 | 2367298 | 20230406072632_Y1Y1J | USL00H | 2024-01-05T23:56:39.288Z | 2024-01-05T23:56:39.288Z |
2367283 | 2367283 | 20230406064941_by1s8 | USL00H | 2024-01-05T23:56:39.287Z | 2024-01-05T23:56:39.287Z |
2367272 | 2367272 | 20230406054106_vEAo4 | USL00H | 2024-01-05T23:56:39.286Z | 2024-01-05T23:56:39.286Z |
2367258 | 2367258 | 20230406043845_W3dgi | USL00H | 2024-01-05T23:56:39.284Z | 2024-01-05T23:56:39.284Z |
2366847 | 2366847 | 20230405120026_AObBO | USL00H | 2024-01-05T23:56:39.232Z | 2024-01-05T23:56:39.232Z |
2366798 | 2366798 | 20230405113419_3Iavl | USL00H | 2024-01-05T23:56:39.227Z | 2024-01-05T23:56:39.227Z |
2366718 | 2366718 | 20230405105554_VfHBN | USL00H | 2024-01-05T23:56:39.218Z | 2024-01-05T23:56:39.218Z |
2366694 | 2366694 | 20230405104901_ThBWm | USL00H | 2024-01-05T23:56:39.215Z | 2024-01-05T23:56:39.215Z |
2366675 | 2366675 | 20230405101911_L6vzX | USL00H | 2024-01-05T23:56:39.213Z | 2024-01-05T23:56:39.213Z |
2366646 | 2366646 | 20230405094959_Anis0 | USL00H | 2024-01-05T23:56:39.209Z | 2024-01-05T23:56:39.209Z |
2366587 | 2366587 | 20230405085350_gboaD | USL00H | 2024-01-05T23:56:38.102Z | 2024-01-05T23:56:38.102Z |
2366449 | 2366449 | 20230405063350_qDldv | USL00H | 2024-01-05T23:56:38.088Z | 2024-01-05T23:56:38.088Z |
2366421 | 2366421 | 20230405054850_Gg8MN | USL00H | 2024-01-05T23:56:38.085Z | 2024-01-05T23:56:38.085Z |
2366425 | 2366425 | 20230405055557_dGQlg | USL00H | 2024-01-05T23:56:38.085Z | 2024-01-05T23:56:38.085Z |
2366378 | 2366378 | 20230405041810_pi2nK | USL00H | 2024-01-05T23:56:38.081Z | 2024-01-05T23:56:38.081Z |
2365341 | 2365341 | 20230404075955_vb2eW | USL00H | 2024-01-05T23:56:36.851Z | 2024-01-05T23:56:36.851Z |
2363533 | 2363533 | 20230403114236_nQpuJ | USL00H | 2024-01-05T23:56:36.668Z | 2024-01-05T23:56:36.668Z |
2363539 | 2363539 | 20230403114449_rHn3Z | USL00H | 2024-01-05T23:56:36.668Z | 2024-01-05T23:56:36.668Z |
2363450 | 2363450 | 20230403111751_kM7yz | USL00H | 2024-01-05T23:56:36.660Z | 2024-01-05T23:56:36.660Z |
2363441 | 2363441 | 20230403111528_UUW3x | USL00H | 2024-01-05T23:56:36.659Z | 2024-01-05T23:56:36.659Z |
2363433 | 2363433 | 20230403111013_W7vEs | USL00H | 2024-01-05T23:56:36.658Z | 2024-01-05T23:56:36.658Z |
2363385 | 2363385 | 20230403103823_UZwPR | USL00H | 2024-01-05T23:56:36.653Z | 2024-01-05T23:56:36.653Z |
2363389 | 2363389 | 20230403103903_gaxwk | USL00H | 2024-01-05T23:56:36.653Z | 2024-01-05T23:56:36.653Z |
2363362 | 2363362 | 20230403101946_Wnu9A | USL00H | 2024-01-05T23:56:36.650Z | 2024-01-05T23:56:36.650Z |
2363332 | 2363332 | 20230403095943_imeM1 | USL00H | 2024-01-05T23:56:36.647Z | 2024-01-05T23:56:36.647Z |
2363259 | 2363259 | 20230403085737_zDcan | USL00H | 2024-01-05T23:56:36.638Z | 2024-01-05T23:56:36.638Z |
2363217 | 2363217 | 20230403083530_hkwlD | USL00H | 2024-01-05T23:56:36.633Z | 2024-01-05T23:56:36.633Z |
2363187 | 2363187 | 20230403082354_W9003 | USL00H | 2024-01-05T23:56:36.629Z | 2024-01-05T23:56:36.629Z |
2363152 | 2363152 | 20230403075205_z5yeR | USL00H | 2024-01-05T23:56:35.481Z | 2024-01-05T23:56:35.481Z |
2363040 | 2363040 | 20230403052820_ethyI | USL00H | 2024-01-05T23:56:35.467Z | 2024-01-05T23:56:35.467Z |
2363025 | 2363025 | 20230403051141_ljNyK | USL00H | 2024-01-05T23:56:35.466Z | 2024-01-05T23:56:35.466Z |
2361073 | 2361073 | 20230402120455_bRqbM | USL00H | 2024-01-05T23:56:35.266Z | 2024-01-05T23:56:35.266Z |
2361059 | 2361059 | 20230402120017_ORN4f | USL00H | 2024-01-05T23:56:35.265Z | 2024-01-05T23:56:35.265Z |
2361051 | 2361051 | 20230402115556_aJqZJ | USL00H | 2024-01-05T23:56:35.264Z | 2024-01-05T23:56:35.264Z |
2361015 | 2361015 | 20230402114751_86B3S | USL00H | 2024-01-05T23:56:35.260Z | 2024-01-05T23:56:35.260Z |
2361005 | 2361005 | 20230402114331_FDPCT | USL00H | 2024-01-05T23:56:35.259Z | 2024-01-05T23:56:35.259Z |
2360988 | 2360988 | 20230402113842_d22dM | USL00H | 2024-01-05T23:56:35.257Z | 2024-01-05T23:56:35.257Z |
2360959 | 2360959 | 20230402113152_GWXwN | USL00H | 2024-01-05T23:56:35.254Z | 2024-01-05T23:56:35.254Z |
2360946 | 2360946 | 20230402112600_faSPp | USL00H | 2024-01-05T23:56:35.253Z | 2024-01-05T23:56:35.253Z |
2360952 | 2360952 | 20230402112829_WFuUu | USL00H | 2024-01-05T23:56:35.253Z | 2024-01-05T23:56:35.253Z |
2360910 | 2360910 | 20230402111418_iIXYf | USL00H | 2024-01-05T23:56:35.249Z | 2024-01-05T23:56:35.249Z |
2360907 | 2360907 | 20230402111334_JdDKo | USL00H | 2024-01-05T23:56:35.248Z | 2024-01-05T23:56:35.248Z |
2360841 | 2360841 | 20230402104829_zv25w | USL00H | 2024-01-05T23:56:35.243Z | 2024-01-05T23:56:35.243Z |
2360792 | 2360792 | 20230402102349_5C3zg | USL00H | 2024-01-05T23:56:35.239Z | 2024-01-05T23:56:35.239Z |
2360708 | 2360708 | 20230402092743_AcV7Z | USL00H | 2024-01-05T23:56:35.229Z | 2024-01-05T23:56:35.229Z |
2360632 | 2360632 | 20230402084022_1Q8DC | USL00H | 2024-01-05T23:56:35.219Z | 2024-01-05T23:56:35.219Z |
2360607 | 2360607 | 20230402082238_3E68n | USL00H | 2024-01-05T23:56:35.216Z | 2024-01-05T23:56:35.216Z |
2360591 | 2360591 | 20230402080603_O6AuA | USL00H | 2024-01-05T23:56:35.214Z | 2024-01-05T23:56:35.214Z |
2360578 | 2360578 | 20230402075430_qaX7z | USL00H | 2024-01-05T23:56:35.212Z | 2024-01-05T23:56:35.212Z |
2360519 | 2360519 | 20230402064406_OXtfU | USL00H | 2024-01-05T23:56:34.045Z | 2024-01-05T23:56:34.045Z |
2360515 | 2360515 | 20230402063744_q1nVw | USL00H | 2024-01-05T23:56:34.044Z | 2024-01-05T23:56:34.044Z |
2360481 | 2360481 | 20230402054517_3m4Ch | USL00H | 2024-01-05T23:56:34.041Z | 2024-01-05T23:56:34.041Z |
2359798 | 2359798 | 20230401114438_pos27 | USL00H | 2024-01-05T23:56:33.954Z | 2024-01-05T23:56:33.954Z |
2359753 | 2359753 | 20230401112209_iel9D | USL00H | 2024-01-05T23:56:33.950Z | 2024-01-05T23:56:33.950Z |
2359540 | 2359540 | 20230401102518_k3PEJ | USL00H | 2024-01-05T23:56:33.929Z | 2024-01-05T23:56:33.929Z |
2359485 | 2359485 | 20230401101138_arnLt | USL00H | 2024-01-05T23:56:33.925Z | 2024-01-05T23:56:33.925Z |
2359399 | 2359399 | 20230401093115_0hwPK | USL00H | 2024-01-05T23:56:33.917Z | 2024-01-05T23:56:33.917Z |
2359363 | 2359363 | 20230401091958_xuOJ2 | USL00H | 2024-01-05T23:56:33.914Z | 2024-01-05T23:56:33.914Z |
2359302 | 2359302 | 20230401084036_kYQS3 | USL00H | 2024-01-05T23:56:33.908Z | 2024-01-05T23:56:33.908Z |
2359267 | 2359267 | 20230401081919_fZlUu | USL00H | 2024-01-05T23:56:33.904Z | 2024-01-05T23:56:33.904Z |
2359237 | 2359237 | 20230401073653_DpQFQ | USL00H | 2024-01-05T23:56:33.900Z | 2024-01-05T23:56:33.900Z |
2359226 | 2359226 | 20230401071611_fdSDs | USL00H | 2024-01-05T23:56:32.787Z | 2024-01-05T23:56:32.787Z |
2359210 | 2359210 | 20230401065337_g8KbY | USL00H | 2024-01-05T23:56:32.785Z | 2024-01-05T23:56:32.785Z |
2359185 | 2359185 | 20230401062337_nPf5T | USL00H | 2024-01-05T23:56:32.783Z | 2024-01-05T23:56:32.783Z |
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);