participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
34 rows where meteor_unique_trajectory_identifier = "20240913005803_2vgkq" sorted by created_at descending
This data as json, copyable, CSV (advanced)
Suggested facets: created_at, created_at (date), updated_at (date)
Link | rowid | meteor_unique_trajectory_identifier | station_code | created_at ▲ | updated_at |
---|---|---|---|---|---|
5097708 | 5097708 | 20240913005803_2vgkq | UK00AT | 2024-09-16T12:17:14.087Z | 2024-09-21T12:16:22.473Z |
5097709 | 5097709 | 20240913005803_2vgkq | UK00B1 | 2024-09-16T12:17:14.087Z | 2024-09-21T12:16:22.473Z |
5097710 | 5097710 | 20240913005803_2vgkq | UK00BH | 2024-09-16T12:17:14.087Z | 2024-09-21T12:16:22.473Z |
5097711 | 5097711 | 20240913005803_2vgkq | UK00C2 | 2024-09-16T12:17:14.087Z | 2024-09-21T12:16:22.473Z |
5097712 | 5097712 | 20240913005803_2vgkq | UK00CC | 2024-09-16T12:17:14.087Z | 2024-09-21T12:16:22.473Z |
5097679 | 5097679 | 20240913005803_2vgkq | IE0004 | 2024-09-16T12:17:14.086Z | 2024-09-21T12:16:22.473Z |
5097680 | 5097680 | 20240913005803_2vgkq | UK000J | 2024-09-16T12:17:14.086Z | 2024-09-21T12:16:22.473Z |
5097681 | 5097681 | 20240913005803_2vgkq | UK000S | 2024-09-16T12:17:14.086Z | 2024-09-21T12:16:22.473Z |
5097682 | 5097682 | 20240913005803_2vgkq | UK002F | 2024-09-16T12:17:14.086Z | 2024-09-21T12:16:22.473Z |
5097683 | 5097683 | 20240913005803_2vgkq | UK002W | 2024-09-16T12:17:14.086Z | 2024-09-21T12:16:22.473Z |
5097684 | 5097684 | 20240913005803_2vgkq | UK0031 | 2024-09-16T12:17:14.086Z | 2024-09-21T12:16:22.473Z |
5097685 | 5097685 | 20240913005803_2vgkq | UK0035 | 2024-09-16T12:17:14.086Z | 2024-09-21T12:16:22.473Z |
5097686 | 5097686 | 20240913005803_2vgkq | UK003X | 2024-09-16T12:17:14.086Z | 2024-09-21T12:16:22.473Z |
5097687 | 5097687 | 20240913005803_2vgkq | UK004L | 2024-09-16T12:17:14.086Z | 2024-09-21T12:16:22.473Z |
5097688 | 5097688 | 20240913005803_2vgkq | UK004N | 2024-09-16T12:17:14.086Z | 2024-09-21T12:16:22.473Z |
5097689 | 5097689 | 20240913005803_2vgkq | UK005M | 2024-09-16T12:17:14.086Z | 2024-09-21T12:16:22.473Z |
5097690 | 5097690 | 20240913005803_2vgkq | UK005V | 2024-09-16T12:17:14.086Z | 2024-09-21T12:16:22.473Z |
5097691 | 5097691 | 20240913005803_2vgkq | UK0062 | 2024-09-16T12:17:14.086Z | 2024-09-21T12:16:22.473Z |
5097692 | 5097692 | 20240913005803_2vgkq | UK006B | 2024-09-16T12:17:14.086Z | 2024-09-21T12:16:22.473Z |
5097693 | 5097693 | 20240913005803_2vgkq | UK006L | 2024-09-16T12:17:14.086Z | 2024-09-21T12:16:22.473Z |
5097694 | 5097694 | 20240913005803_2vgkq | UK007B | 2024-09-16T12:17:14.086Z | 2024-09-21T12:16:22.473Z |
5097695 | 5097695 | 20240913005803_2vgkq | UK008F | 2024-09-16T12:17:14.086Z | 2024-09-21T12:16:22.473Z |
5097696 | 5097696 | 20240913005803_2vgkq | UK008J | 2024-09-16T12:17:14.086Z | 2024-09-21T12:16:22.473Z |
5097697 | 5097697 | 20240913005803_2vgkq | UK0098 | 2024-09-16T12:17:14.086Z | 2024-09-21T12:16:22.473Z |
5097698 | 5097698 | 20240913005803_2vgkq | UK0099 | 2024-09-16T12:17:14.086Z | 2024-09-21T12:16:22.473Z |
5097699 | 5097699 | 20240913005803_2vgkq | UK009J | 2024-09-16T12:17:14.086Z | 2024-09-21T12:16:22.473Z |
5097700 | 5097700 | 20240913005803_2vgkq | UK009L | 2024-09-16T12:17:14.086Z | 2024-09-21T12:16:22.473Z |
5097701 | 5097701 | 20240913005803_2vgkq | UK009S | 2024-09-16T12:17:14.086Z | 2024-09-21T12:16:22.473Z |
5097702 | 5097702 | 20240913005803_2vgkq | UK00A0 | 2024-09-16T12:17:14.086Z | 2024-09-21T12:16:22.473Z |
5097703 | 5097703 | 20240913005803_2vgkq | UK00A4 | 2024-09-16T12:17:14.086Z | 2024-09-21T12:16:22.473Z |
5097704 | 5097704 | 20240913005803_2vgkq | UK00AE | 2024-09-16T12:17:14.086Z | 2024-09-21T12:16:22.473Z |
5097705 | 5097705 | 20240913005803_2vgkq | UK00AG | 2024-09-16T12:17:14.086Z | 2024-09-21T12:16:22.473Z |
5097706 | 5097706 | 20240913005803_2vgkq | UK00AL | 2024-09-16T12:17:14.086Z | 2024-09-21T12:16:22.473Z |
5097707 | 5097707 | 20240913005803_2vgkq | UK00AN | 2024-09-16T12:17:14.086Z | 2024-09-21T12:16:22.473Z |
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);