participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all sorted by created_at descending
This data as json, copyable, CSV (advanced)
Suggested facets: station_code, created_at (date), updated_at (date)
Link | rowid | meteor_unique_trajectory_identifier | station_code | created_at ▲ | updated_at |
---|---|---|---|---|---|
5412632 | 5412632 | 20241025063623_FDlt2 | US003R | 2024-10-29T12:23:36.548Z | 2024-10-29T12:23:36.548Z |
5412631 | 5412631 | 20241025063623_FDlt2 | US003M | 2024-10-29T12:23:36.548Z | 2024-10-29T12:23:36.548Z |
5412630 | 5412630 | 20241025063623_FDlt2 | US0035 | 2024-10-29T12:23:36.548Z | 2024-10-29T12:23:36.548Z |
5412629 | 5412629 | 20241025063616_kIPWe | US003P | 2024-10-29T12:23:36.475Z | 2024-10-29T12:23:36.475Z |
5412628 | 5412628 | 20241025063616_kIPWe | US003N | 2024-10-29T12:23:36.475Z | 2024-10-29T12:23:36.475Z |
5412627 | 5412627 | 20241025063616_kIPWe | US0037 | 2024-10-29T12:23:36.475Z | 2024-10-29T12:23:36.475Z |
5412626 | 5412626 | 20241025063321_7Tw08 | US003R | 2024-10-29T12:23:36.439Z | 2024-10-29T12:23:36.439Z |
5412625 | 5412625 | 20241025063321_7Tw08 | US003N | 2024-10-29T12:23:36.439Z | 2024-10-29T12:23:36.439Z |
5412624 | 5412624 | 20241025063321_7Tw08 | US0038 | 2024-10-29T12:23:36.439Z | 2024-10-29T12:23:36.439Z |
5412623 | 5412623 | 20241025063321_7Tw08 | US0035 | 2024-10-29T12:23:36.439Z | 2024-10-29T12:23:36.439Z |
5412622 | 5412622 | 20241025063313_8vxjC | US003N | 2024-10-29T12:23:36.436Z | 2024-10-29T12:23:36.436Z |
5412621 | 5412621 | 20241025063313_8vxjC | US0036 | 2024-10-29T12:23:36.436Z | 2024-10-29T12:23:36.436Z |
5412620 | 5412620 | 20241025063121_56dN6 | US003R | 2024-10-29T12:23:36.416Z | 2024-10-29T12:23:36.416Z |
5412619 | 5412619 | 20241025063121_56dN6 | US003M | 2024-10-29T12:23:36.416Z | 2024-10-29T12:23:36.416Z |
5412618 | 5412618 | 20241025063121_56dN6 | US0038 | 2024-10-29T12:23:36.416Z | 2024-10-29T12:23:36.416Z |
5412617 | 5412617 | 20241025062559_Q2Dx2 | US003N | 2024-10-29T12:23:36.386Z | 2024-10-29T12:23:36.386Z |
5412616 | 5412616 | 20241025062559_Q2Dx2 | US0038 | 2024-10-29T12:23:36.386Z | 2024-10-29T12:23:36.386Z |
5412615 | 5412615 | 20241025062559_Q2Dx2 | US0035 | 2024-10-29T12:23:36.386Z | 2024-10-29T12:23:36.386Z |
5412614 | 5412614 | 20241025062547_GNcnY | US003N | 2024-10-29T12:23:36.369Z | 2024-10-29T12:23:36.369Z |
5412613 | 5412613 | 20241025062547_GNcnY | US0038 | 2024-10-29T12:23:36.369Z | 2024-10-29T12:23:36.369Z |
5412612 | 5412612 | 20241025062153_6HXsR | US003P | 2024-10-29T12:23:36.350Z | 2024-10-29T12:23:36.350Z |
5412611 | 5412611 | 20241025062153_6HXsR | US003N | 2024-10-29T12:23:36.350Z | 2024-10-29T12:23:36.350Z |
5412610 | 5412610 | 20241025062153_6HXsR | US0038 | 2024-10-29T12:23:36.350Z | 2024-10-29T12:23:36.350Z |
5412609 | 5412609 | 20241025061933_zPPLw | US003R | 2024-10-29T12:23:36.292Z | 2024-10-29T12:23:36.292Z |
5412608 | 5412608 | 20241025061933_zPPLw | US0035 | 2024-10-29T12:23:36.292Z | 2024-10-29T12:23:36.292Z |
5412607 | 5412607 | 20241025061816_QuViH | US003P | 2024-10-29T12:23:36.055Z | 2024-10-29T12:23:36.055Z |
5412606 | 5412606 | 20241025061816_QuViH | US0037 | 2024-10-29T12:23:36.054Z | 2024-10-29T12:23:36.054Z |
5412605 | 5412605 | 20241025061625_rdc43 | US003R | 2024-10-29T12:23:36.040Z | 2024-10-29T12:23:36.040Z |
5412604 | 5412604 | 20241025061625_rdc43 | US003N | 2024-10-29T12:23:36.040Z | 2024-10-29T12:23:36.040Z |
5412603 | 5412603 | 20241025061625_rdc43 | US0038 | 2024-10-29T12:23:36.040Z | 2024-10-29T12:23:36.040Z |
5412602 | 5412602 | 20241025061625_rdc43 | US0035 | 2024-10-29T12:23:36.040Z | 2024-10-29T12:23:36.040Z |
5412601 | 5412601 | 20241025061306_hhZIl | US003P | 2024-10-29T12:23:35.948Z | 2024-10-29T12:23:35.948Z |
5412600 | 5412600 | 20241025061306_hhZIl | US0038 | 2024-10-29T12:23:35.948Z | 2024-10-29T12:23:35.948Z |
5412599 | 5412599 | 20241025061058_u2o2H | US003N | 2024-10-29T12:23:35.895Z | 2024-10-29T12:23:35.895Z |
5412598 | 5412598 | 20241025061058_u2o2H | US003M | 2024-10-29T12:23:35.895Z | 2024-10-29T12:23:35.895Z |
5412597 | 5412597 | 20241025061058_u2o2H | US0039 | 2024-10-29T12:23:35.895Z | 2024-10-29T12:23:35.895Z |
5412596 | 5412596 | 20241025061058_u2o2H | US0036 | 2024-10-29T12:23:35.895Z | 2024-10-29T12:23:35.895Z |
5412595 | 5412595 | 20241025061058_u2o2H | US0035 | 2024-10-29T12:23:35.894Z | 2024-10-29T12:23:35.894Z |
5412594 | 5412594 | 20241025060806_WTblc | US003R | 2024-10-29T12:23:35.789Z | 2024-10-29T12:23:35.789Z |
5412593 | 5412593 | 20241025060806_WTblc | US003M | 2024-10-29T12:23:35.789Z | 2024-10-29T12:23:35.789Z |
5412592 | 5412592 | 20241025060806_WTblc | US0035 | 2024-10-29T12:23:35.789Z | 2024-10-29T12:23:35.789Z |
5412591 | 5412591 | 20241025055231_hvklo | US003N | 2024-10-29T12:23:35.237Z | 2024-10-29T12:23:35.237Z |
5412590 | 5412590 | 20241025055231_hvklo | US0039 | 2024-10-29T12:23:35.237Z | 2024-10-29T12:23:35.237Z |
5412589 | 5412589 | 20241025055231_hvklo | US0038 | 2024-10-29T12:23:35.237Z | 2024-10-29T12:23:35.237Z |
5412588 | 5412588 | 20241025054714_2uWGY | US003R | 2024-10-29T12:23:35.113Z | 2024-10-29T12:23:35.113Z |
5412587 | 5412587 | 20241025054714_2uWGY | US003N | 2024-10-29T12:23:35.113Z | 2024-10-29T12:23:35.113Z |
5412586 | 5412586 | 20241025054714_2uWGY | US003M | 2024-10-29T12:23:35.113Z | 2024-10-29T12:23:35.113Z |
5412585 | 5412585 | 20241025054714_2uWGY | US0039 | 2024-10-29T12:23:35.113Z | 2024-10-29T12:23:35.113Z |
5412584 | 5412584 | 20241025054714_2uWGY | US0038 | 2024-10-29T12:23:35.113Z | 2024-10-29T12:23:35.113Z |
5412583 | 5412583 | 20241025054714_2uWGY | US0035 | 2024-10-29T12:23:35.113Z | 2024-10-29T12:23:35.113Z |
5412582 | 5412582 | 20241025054710_7hob3 | US003N | 2024-10-29T12:23:35.106Z | 2024-10-29T12:23:35.106Z |
5412581 | 5412581 | 20241025054710_7hob3 | US0036 | 2024-10-29T12:23:35.106Z | 2024-10-29T12:23:35.106Z |
5412580 | 5412580 | 20241025054703_HKwSn | US003R | 2024-10-29T12:23:35.103Z | 2024-10-29T12:23:35.103Z |
5412579 | 5412579 | 20241025054703_HKwSn | US003M | 2024-10-29T12:23:35.103Z | 2024-10-29T12:23:35.103Z |
5412578 | 5412578 | 20241025054703_HKwSn | US0035 | 2024-10-29T12:23:35.103Z | 2024-10-29T12:23:35.103Z |
5412577 | 5412577 | 20241025053857_4plpG | US003R | 2024-10-29T12:23:34.893Z | 2024-10-29T12:23:34.893Z |
5412576 | 5412576 | 20241025053857_4plpG | US003M | 2024-10-29T12:23:34.893Z | 2024-10-29T12:23:34.893Z |
5412575 | 5412575 | 20241025053857_4plpG | US0038 | 2024-10-29T12:23:34.893Z | 2024-10-29T12:23:34.893Z |
5412574 | 5412574 | 20241025053857_4plpG | US0035 | 2024-10-29T12:23:34.893Z | 2024-10-29T12:23:34.893Z |
5412573 | 5412573 | 20241025053041_Jlwnl | US003P | 2024-10-29T12:23:34.771Z | 2024-10-29T12:23:34.771Z |
5412572 | 5412572 | 20241025053041_Jlwnl | US003N | 2024-10-29T12:23:34.771Z | 2024-10-29T12:23:34.771Z |
5412571 | 5412571 | 20241025053041_Jlwnl | US0039 | 2024-10-29T12:23:34.771Z | 2024-10-29T12:23:34.771Z |
5412570 | 5412570 | 20241025053041_Jlwnl | US0038 | 2024-10-29T12:23:34.771Z | 2024-10-29T12:23:34.771Z |
5412569 | 5412569 | 20241025052841_3SNME | US003P | 2024-10-29T12:23:34.759Z | 2024-10-29T12:23:34.759Z |
5412568 | 5412568 | 20241025052841_3SNME | US0037 | 2024-10-29T12:23:34.759Z | 2024-10-29T12:23:34.759Z |
5412567 | 5412567 | 20241025052755_j2mzK | US003N | 2024-10-29T12:23:34.752Z | 2024-10-29T12:23:34.752Z |
5412566 | 5412566 | 20241025052755_j2mzK | US003M | 2024-10-29T12:23:34.752Z | 2024-10-29T12:23:34.752Z |
5412565 | 5412565 | 20241025052755_j2mzK | US0035 | 2024-10-29T12:23:34.752Z | 2024-10-29T12:23:34.752Z |
5412564 | 5412564 | 20241025052618_Dnlnr | US003N | 2024-10-29T12:23:34.675Z | 2024-10-29T12:23:34.675Z |
5412563 | 5412563 | 20241025052618_Dnlnr | US0039 | 2024-10-29T12:23:34.675Z | 2024-10-29T12:23:34.675Z |
5412562 | 5412562 | 20241025052618_Dnlnr | US0038 | 2024-10-29T12:23:34.675Z | 2024-10-29T12:23:34.675Z |
5412561 | 5412561 | 20241025052426_Q7kU1 | US003N | 2024-10-29T12:23:34.468Z | 2024-10-29T12:23:34.468Z |
5412560 | 5412560 | 20241025052426_Q7kU1 | US0036 | 2024-10-29T12:23:34.468Z | 2024-10-29T12:23:34.468Z |
5412559 | 5412559 | 20241025052417_7wxmG | US003M | 2024-10-29T12:23:34.464Z | 2024-10-29T12:23:34.464Z |
5412558 | 5412558 | 20241025052417_7wxmG | US0035 | 2024-10-29T12:23:34.464Z | 2024-10-29T12:23:34.464Z |
5412557 | 5412557 | 20241025052244_KJ12i | US003Q | 2024-10-29T12:23:34.205Z | 2024-10-29T12:23:34.205Z |
5412556 | 5412556 | 20241025052244_KJ12i | US003M | 2024-10-29T12:23:34.205Z | 2024-10-29T12:23:34.205Z |
5412555 | 5412555 | 20241025052244_KJ12i | US0035 | 2024-10-29T12:23:34.205Z | 2024-10-29T12:23:34.205Z |
5412554 | 5412554 | 20241025045804_VMQfF | US003N | 2024-10-29T12:23:33.317Z | 2024-10-29T12:23:33.317Z |
5412553 | 5412553 | 20241025045804_VMQfF | US0039 | 2024-10-29T12:23:33.317Z | 2024-10-29T12:23:33.317Z |
5412552 | 5412552 | 20241025045659_zXDva | US003R | 2024-10-29T12:23:33.309Z | 2024-10-29T12:23:33.309Z |
5412551 | 5412551 | 20241025045659_zXDva | US003N | 2024-10-29T12:23:33.309Z | 2024-10-29T12:23:33.309Z |
5412550 | 5412550 | 20241025045659_zXDva | US003M | 2024-10-29T12:23:33.309Z | 2024-10-29T12:23:33.309Z |
5412549 | 5412549 | 20241025045659_zXDva | US0039 | 2024-10-29T12:23:33.309Z | 2024-10-29T12:23:33.309Z |
5412548 | 5412548 | 20241025045659_zXDva | US0038 | 2024-10-29T12:23:33.309Z | 2024-10-29T12:23:33.309Z |
5412547 | 5412547 | 20241025045659_zXDva | US0035 | 2024-10-29T12:23:33.309Z | 2024-10-29T12:23:33.309Z |
5412546 | 5412546 | 20241025045320_EOXIi | US003P | 2024-10-29T12:23:33.259Z | 2024-10-29T12:23:33.259Z |
5412545 | 5412545 | 20241025045320_EOXIi | US003N | 2024-10-29T12:23:33.259Z | 2024-10-29T12:23:33.259Z |
5412544 | 5412544 | 20241025045320_EOXIi | US0039 | 2024-10-29T12:23:33.259Z | 2024-10-29T12:23:33.259Z |
5412543 | 5412543 | 20241025045320_EOXIi | US0038 | 2024-10-29T12:23:33.259Z | 2024-10-29T12:23:33.259Z |
5412542 | 5412542 | 20241025044959_lExp0 | US003R | 2024-10-29T12:23:33.208Z | 2024-10-29T12:23:33.208Z |
5412541 | 5412541 | 20241025044959_lExp0 | US003M | 2024-10-29T12:23:33.208Z | 2024-10-29T12:23:33.208Z |
5412540 | 5412540 | 20241025044959_lExp0 | US0035 | 2024-10-29T12:23:33.208Z | 2024-10-29T12:23:33.208Z |
5412539 | 5412539 | 20241025044554_5xO3k | US003N | 2024-10-29T12:23:33.065Z | 2024-10-29T12:23:33.065Z |
5412538 | 5412538 | 20241025044554_5xO3k | US0039 | 2024-10-29T12:23:33.065Z | 2024-10-29T12:23:33.065Z |
5412537 | 5412537 | 20241025044554_5xO3k | US0036 | 2024-10-29T12:23:33.065Z | 2024-10-29T12:23:33.065Z |
5412536 | 5412536 | 20241025044010_DRf9N | US003R | 2024-10-29T12:23:33.004Z | 2024-10-29T12:23:33.004Z |
5412535 | 5412535 | 20241025044010_DRf9N | US003Q | 2024-10-29T12:23:33.004Z | 2024-10-29T12:23:33.004Z |
5412534 | 5412534 | 20241025044010_DRf9N | US003M | 2024-10-29T12:23:33.004Z | 2024-10-29T12:23:33.004Z |
5412533 | 5412533 | 20241025044010_DRf9N | US0035 | 2024-10-29T12:23:33.004Z | 2024-10-29T12:23:33.004Z |
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);