participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
30 rows where meteor_unique_trajectory_identifier = "20240911225634_ecAQr" sorted by created_at descending
This data as json, copyable, CSV (advanced)
Suggested facets: created_at, updated_at, created_at (date), updated_at (date)
Link | rowid | meteor_unique_trajectory_identifier | station_code | created_at ▲ | updated_at |
---|---|---|---|---|---|
5074685 | 5074685 | 20240911225634_ecAQr | UK001Z | 2024-09-15T12:08:45.197Z | 2024-09-19T12:21:07.619Z |
5074686 | 5074686 | 20240911225634_ecAQr | UK0026 | 2024-09-15T12:08:45.197Z | 2024-09-19T12:21:07.619Z |
5074687 | 5074687 | 20240911225634_ecAQr | UK0030 | 2024-09-15T12:08:45.197Z | 2024-09-19T12:21:07.619Z |
5074688 | 5074688 | 20240911225634_ecAQr | UK0031 | 2024-09-15T12:08:45.197Z | 2024-09-19T12:21:07.619Z |
5074689 | 5074689 | 20240911225634_ecAQr | UK0050 | 2024-09-15T12:08:45.197Z | 2024-09-19T12:21:07.619Z |
5074690 | 5074690 | 20240911225634_ecAQr | UK0070 | 2024-09-15T12:08:45.197Z | 2024-09-19T12:21:07.619Z |
5074691 | 5074691 | 20240911225634_ecAQr | UK007A | 2024-09-15T12:08:45.197Z | 2024-09-19T12:21:07.619Z |
5074692 | 5074692 | 20240911225634_ecAQr | UK007P | 2024-09-15T12:08:45.197Z | 2024-09-19T12:21:07.619Z |
5074693 | 5074693 | 20240911225634_ecAQr | UK0084 | 2024-09-15T12:08:45.197Z | 2024-09-19T12:21:07.619Z |
5074694 | 5074694 | 20240911225634_ecAQr | UK008J | 2024-09-15T12:08:45.197Z | 2024-09-19T12:21:07.619Z |
5074695 | 5074695 | 20240911225634_ecAQr | UK008W | 2024-09-15T12:08:45.197Z | 2024-09-19T12:21:07.619Z |
5074696 | 5074696 | 20240911225634_ecAQr | UK008X | 2024-09-15T12:08:45.197Z | 2024-09-19T12:21:07.619Z |
5074697 | 5074697 | 20240911225634_ecAQr | UK009D | 2024-09-15T12:08:45.197Z | 2024-09-19T12:21:07.619Z |
5074698 | 5074698 | 20240911225634_ecAQr | UK009G | 2024-09-15T12:08:45.197Z | 2024-09-19T12:21:07.619Z |
5074699 | 5074699 | 20240911225634_ecAQr | UK009K | 2024-09-15T12:08:45.197Z | 2024-09-19T12:21:07.619Z |
5074700 | 5074700 | 20240911225634_ecAQr | UK009S | 2024-09-15T12:08:45.197Z | 2024-09-19T12:21:07.619Z |
5074701 | 5074701 | 20240911225634_ecAQr | UK009T | 2024-09-15T12:08:45.197Z | 2024-09-19T12:21:07.619Z |
5074702 | 5074702 | 20240911225634_ecAQr | UK00AE | 2024-09-15T12:08:45.197Z | 2024-09-19T12:21:07.619Z |
5074703 | 5074703 | 20240911225634_ecAQr | UK00AT | 2024-09-15T12:08:45.197Z | 2024-09-19T12:21:07.619Z |
5074704 | 5074704 | 20240911225634_ecAQr | UK00B0 | 2024-09-15T12:08:45.197Z | 2024-09-19T12:21:07.619Z |
5074705 | 5074705 | 20240911225634_ecAQr | UK00B2 | 2024-09-15T12:08:45.197Z | 2024-09-19T12:21:07.619Z |
5074706 | 5074706 | 20240911225634_ecAQr | UK00BD | 2024-09-15T12:08:45.197Z | 2024-09-19T12:21:07.619Z |
5074707 | 5074707 | 20240911225634_ecAQr | UK00BF | 2024-09-15T12:08:45.197Z | 2024-09-19T12:21:07.619Z |
5074708 | 5074708 | 20240911225634_ecAQr | UK00BL | 2024-09-15T12:08:45.197Z | 2024-09-19T12:21:07.620Z |
5074709 | 5074709 | 20240911225634_ecAQr | UK00BW | 2024-09-15T12:08:45.197Z | 2024-09-19T12:21:07.620Z |
5074680 | 5074680 | 20240911225634_ecAQr | IE0004 | 2024-09-15T12:08:45.196Z | 2024-09-19T12:21:07.619Z |
5074681 | 5074681 | 20240911225634_ecAQr | UK0006 | 2024-09-15T12:08:45.196Z | 2024-09-19T12:21:07.619Z |
5074682 | 5074682 | 20240911225634_ecAQr | UK000S | 2024-09-15T12:08:45.196Z | 2024-09-19T12:21:07.619Z |
5074683 | 5074683 | 20240911225634_ecAQr | UK001L | 2024-09-15T12:08:45.196Z | 2024-09-19T12:21:07.619Z |
5074684 | 5074684 | 20240911225634_ecAQr | UK001S | 2024-09-15T12:08:45.196Z | 2024-09-19T12:21:07.619Z |
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);