participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
27 rows where meteor_unique_trajectory_identifier = "20240806212755_fg0Yj" 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 |
---|---|---|---|---|---|
4872061 | 4872061 | 20240806212755_fg0Yj | UK0027 | 2024-08-19T12:09:47.453Z | 2024-08-27T12:10:16.506Z |
4872062 | 4872062 | 20240806212755_fg0Yj | UK0030 | 2024-08-19T12:09:47.453Z | 2024-08-27T12:10:16.506Z |
4872063 | 4872063 | 20240806212755_fg0Yj | UK0031 | 2024-08-19T12:09:47.453Z | 2024-08-27T12:10:16.506Z |
4872064 | 4872064 | 20240806212755_fg0Yj | UK0035 | 2024-08-19T12:09:47.453Z | 2024-08-27T12:10:16.506Z |
4872065 | 4872065 | 20240806212755_fg0Yj | UK003A | 2024-08-19T12:09:47.453Z | 2024-08-27T12:10:16.506Z |
4872066 | 4872066 | 20240806212755_fg0Yj | UK003X | 2024-08-19T12:09:47.453Z | 2024-08-27T12:10:16.506Z |
4872067 | 4872067 | 20240806212755_fg0Yj | UK004D | 2024-08-19T12:09:47.453Z | 2024-08-27T12:10:16.506Z |
4872068 | 4872068 | 20240806212755_fg0Yj | UK004N | 2024-08-19T12:09:47.453Z | 2024-08-27T12:10:16.506Z |
4872069 | 4872069 | 20240806212755_fg0Yj | UK005L | 2024-08-19T12:09:47.453Z | 2024-08-27T12:10:16.506Z |
4872070 | 4872070 | 20240806212755_fg0Yj | UK005V | 2024-08-19T12:09:47.453Z | 2024-08-27T12:10:16.506Z |
4872071 | 4872071 | 20240806212755_fg0Yj | UK006L | 2024-08-19T12:09:47.453Z | 2024-08-27T12:10:16.506Z |
4872072 | 4872072 | 20240806212755_fg0Yj | UK007P | 2024-08-19T12:09:47.453Z | 2024-08-27T12:10:16.506Z |
4872073 | 4872073 | 20240806212755_fg0Yj | UK0086 | 2024-08-19T12:09:47.453Z | 2024-08-27T12:10:16.506Z |
4872074 | 4872074 | 20240806212755_fg0Yj | UK0099 | 2024-08-19T12:09:47.453Z | 2024-08-27T12:10:16.506Z |
4872075 | 4872075 | 20240806212755_fg0Yj | UK009D | 2024-08-19T12:09:47.453Z | 2024-08-27T12:10:16.506Z |
4872076 | 4872076 | 20240806212755_fg0Yj | UK009P | 2024-08-19T12:09:47.453Z | 2024-08-27T12:10:16.506Z |
4872077 | 4872077 | 20240806212755_fg0Yj | UK00B0 | 2024-08-19T12:09:47.453Z | 2024-08-27T12:10:16.506Z |
4872078 | 4872078 | 20240806212755_fg0Yj | UK00B1 | 2024-08-19T12:09:47.453Z | 2024-08-27T12:10:16.506Z |
4872079 | 4872079 | 20240806212755_fg0Yj | UK00BF | 2024-08-19T12:09:47.453Z | 2024-08-27T12:10:16.506Z |
4872080 | 4872080 | 20240806212755_fg0Yj | UK00C1 | 2024-08-19T12:09:47.453Z | 2024-08-27T12:10:16.506Z |
4872081 | 4872081 | 20240806212755_fg0Yj | UK00C2 | 2024-08-19T12:09:47.453Z | 2024-08-27T12:10:16.506Z |
4872060 | 4872060 | 20240806212755_fg0Yj | UK0026 | 2024-08-19T12:09:47.452Z | 2024-08-27T12:10:16.506Z |
4872056 | 4872056 | 20240806212755_fg0Yj | UK000S | 2024-08-19T12:09:47.451Z | 2024-08-27T12:10:16.506Z |
4872057 | 4872057 | 20240806212755_fg0Yj | UK000U | 2024-08-19T12:09:47.451Z | 2024-08-27T12:10:16.506Z |
4872058 | 4872058 | 20240806212755_fg0Yj | UK001L | 2024-08-19T12:09:47.451Z | 2024-08-27T12:10:16.506Z |
4872059 | 4872059 | 20240806212755_fg0Yj | UK001Z | 2024-08-19T12:09:47.451Z | 2024-08-27T12:10:16.506Z |
4872055 | 4872055 | 20240806212755_fg0Yj | UK000J | 2024-08-19T12:09:47.436Z | 2024-08-27T12:10:16.506Z |
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);