participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
24 rows where meteor_unique_trajectory_identifier = "20240302213047_CaErd" 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 |
---|---|---|---|---|---|
4019501 | 4019501 | 20240302213047_CaErd | UK008B | 2024-03-04T14:04:23.746Z | 2024-03-11T12:18:31.530Z |
4019502 | 4019502 | 20240302213047_CaErd | UK008W | 2024-03-04T14:04:23.746Z | 2024-03-11T12:18:31.530Z |
4019503 | 4019503 | 20240302213047_CaErd | UK009A | 2024-03-04T14:04:23.746Z | 2024-03-11T12:18:31.530Z |
4019504 | 4019504 | 20240302213047_CaErd | UK009G | 2024-03-04T14:04:23.746Z | 2024-03-11T12:18:31.530Z |
4019505 | 4019505 | 20240302213047_CaErd | UK009V | 2024-03-04T14:04:23.746Z | 2024-03-11T12:18:31.530Z |
4019506 | 4019506 | 20240302213047_CaErd | UK009W | 2024-03-04T14:04:23.746Z | 2024-03-11T12:18:31.530Z |
4019507 | 4019507 | 20240302213047_CaErd | UK00A5 | 2024-03-04T14:04:23.746Z | 2024-03-11T12:18:31.530Z |
4019508 | 4019508 | 20240302213047_CaErd | UK00AG | 2024-03-04T14:04:23.746Z | 2024-03-11T12:18:31.530Z |
4019509 | 4019509 | 20240302213047_CaErd | UK00AP | 2024-03-04T14:04:23.746Z | 2024-03-11T12:18:31.530Z |
4019510 | 4019510 | 20240302213047_CaErd | UK00AT | 2024-03-04T14:04:23.746Z | 2024-03-11T12:18:31.530Z |
4019511 | 4019511 | 20240302213047_CaErd | UK00B2 | 2024-03-04T14:04:23.746Z | 2024-03-11T12:18:31.530Z |
4019499 | 4019499 | 20240302213047_CaErd | UK007V | 2024-03-04T14:04:23.734Z | 2024-03-11T12:18:31.530Z |
4019500 | 4019500 | 20240302213047_CaErd | UK0084 | 2024-03-04T14:04:23.734Z | 2024-03-11T12:18:31.530Z |
4019494 | 4019494 | 20240302213047_CaErd | UK0031 | 2024-03-04T14:04:23.721Z | 2024-03-11T12:18:31.530Z |
4019495 | 4019495 | 20240302213047_CaErd | UK003D | 2024-03-04T14:04:23.721Z | 2024-03-11T12:18:31.530Z |
4019496 | 4019496 | 20240302213047_CaErd | UK003M | 2024-03-04T14:04:23.721Z | 2024-03-11T12:18:31.530Z |
4019497 | 4019497 | 20240302213047_CaErd | UK007B | 2024-03-04T14:04:23.721Z | 2024-03-11T12:18:31.530Z |
4019498 | 4019498 | 20240302213047_CaErd | UK007L | 2024-03-04T14:04:23.721Z | 2024-03-11T12:18:31.530Z |
4019488 | 4019488 | 20240302213047_CaErd | UK0001 | 2024-03-04T14:04:23.703Z | 2024-03-11T12:18:31.530Z |
4019489 | 4019489 | 20240302213047_CaErd | UK0006 | 2024-03-04T14:04:23.703Z | 2024-03-11T12:18:31.530Z |
4019490 | 4019490 | 20240302213047_CaErd | UK000F | 2024-03-04T14:04:23.703Z | 2024-03-11T12:18:31.530Z |
4019491 | 4019491 | 20240302213047_CaErd | UK000S | 2024-03-04T14:04:23.703Z | 2024-03-11T12:18:31.530Z |
4019492 | 4019492 | 20240302213047_CaErd | UK001Z | 2024-03-04T14:04:23.703Z | 2024-03-11T12:18:31.530Z |
4019493 | 4019493 | 20240302213047_CaErd | UK002Q | 2024-03-04T14:04:23.703Z | 2024-03-11T12:18:31.530Z |
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);