participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
40 rows where station_code = "RU000Z" sorted by created_at descending
This data as json, copyable, CSV (advanced)
Suggested facets: created_at (date), updated_at (date)
Link | rowid | meteor_unique_trajectory_identifier | station_code | created_at ▲ | updated_at |
---|---|---|---|---|---|
5135230 | 5135230 | 20240916171019_Dt8KR | RU000Z | 2024-09-19T12:18:16.968Z | 2024-09-20T12:14:46.246Z |
5135129 | 5135129 | 20240916163227_c0XtH | RU000Z | 2024-09-19T12:18:15.357Z | 2024-09-20T12:14:44.963Z |
5135027 | 5135027 | 20240916152918_8ujmf | RU000Z | 2024-09-19T12:18:13.010Z | 2024-09-20T12:14:43.146Z |
5134865 | 5134865 | 20240916131148_EEy1K | RU000Z | 2024-09-19T12:18:08.568Z | 2024-09-20T12:14:38.427Z |
5134693 | 5134693 | 20240916111923_Ej8Kg | RU000Z | 2024-09-19T12:18:03.572Z | 2024-09-20T12:14:31.567Z |
5126731 | 5126731 | 20240916184126_Vrh2e | RU000Z | 2024-09-19T12:06:56.302Z | 2024-09-20T12:10:05.245Z |
5124201 | 5124201 | 20240914161028_mCLbS | RU000Z | 2024-09-18T12:12:10.854Z | 2024-09-20T12:19:41.688Z |
5124028 | 5124028 | 20240914135811_mosCV | RU000Z | 2024-09-18T12:12:03.846Z | 2024-09-20T12:19:39.238Z |
5123705 | 5123705 | 20240914111139_ASJ9G | RU000Z | 2024-09-18T12:11:54.588Z | 2024-09-20T12:19:33.282Z |
5110351 | 5110351 | 20240913152539_jzhEv | RU000Z | 2024-09-17T12:15:06.345Z | 2024-09-20T12:21:12.521Z |
5098442 | 5098442 | 20240913171647_WKpmh | RU000Z | 2024-09-17T12:00:36.578Z | 2024-09-20T12:18:00.100Z |
5098410 | 5098410 | 20240913170257_QbAvI | RU000Z | 2024-09-17T12:00:30.053Z | 2024-09-20T12:17:59.377Z |
5084294 | 5084294 | 20240912191236_vi4TR | RU000Z | 2024-09-16T12:01:48.865Z | 2024-09-20T12:19:52.426Z |
5084253 | 5084253 | 20240912190328_N7bcP | RU000Z | 2024-09-16T12:01:42.263Z | 2024-09-20T12:19:51.592Z |
5084232 | 5084232 | 20240912190133_dly1R | RU000Z | 2024-09-16T12:01:37.211Z | 2024-09-20T12:19:51.137Z |
5084230 | 5084230 | 20240912190059_BERmh | RU000Z | 2024-09-16T12:01:36.981Z | 2024-09-20T12:19:51.105Z |
5084080 | 5084080 | 20240912180249_9qvTO | RU000Z | 2024-09-16T12:01:06.096Z | 2024-09-20T12:19:49.320Z |
5083987 | 5083987 | 20240912171842_P4rUi | RU000Z | 2024-09-16T12:00:48.131Z | 2024-09-20T12:19:46.974Z |
5083851 | 5083851 | 20240912161433_ST06r | RU000Z | 2024-09-16T12:00:31.270Z | 2024-09-20T12:19:45.453Z |
5083628 | 5083628 | 20240911140023_VtJrX | RU000Z | 2024-09-15T12:18:44.807Z | 2024-09-19T12:21:49.733Z |
5083469 | 5083469 | 20240911132748_QmjxG | RU000Z | 2024-09-15T12:18:42.408Z | 2024-09-19T12:21:49.594Z |
5071724 | 5071724 | 20240911180159_QJ2wB | RU000Z | 2024-09-15T12:03:20.428Z | 2024-09-20T12:21:22.540Z |
5071244 | 5071244 | 20240911162138_i2cyT | RU000Z | 2024-09-15T12:02:00.521Z | 2024-09-20T12:21:20.115Z |
5070745 | 5070745 | 20240911150521_kCw3T | RU000Z | 2024-09-15T12:00:44.736Z | 2024-09-20T12:21:16.806Z |
5059758 | 5059758 | 20240910184514_8P1we | RU000Z | 2024-09-14T12:07:07.828Z | 2024-09-19T12:21:31.248Z |
5059681 | 5059681 | 20240910183058_2q7bM | RU000Z | 2024-09-14T12:06:44.883Z | 2024-09-19T12:21:31.064Z |
5059671 | 5059671 | 20240910182805_ZRPga | RU000Z | 2024-09-14T12:06:43.688Z | 2024-09-19T12:21:31.058Z |
5059589 | 5059589 | 20240910181432_O6NUc | RU000Z | 2024-09-14T12:06:32.103Z | 2024-09-19T12:21:30.912Z |
5059473 | 5059473 | 20240910174806_2Pm7A | RU000Z | 2024-09-14T12:06:11.593Z | 2024-09-19T12:21:30.818Z |
5059392 | 5059392 | 20240910173631_b0KSm | RU000Z | 2024-09-14T12:05:50.600Z | 2024-09-19T12:21:30.712Z |
5057896 | 5057896 | 20240910152308_kM7GZ | RU000Z | 2024-09-14T12:02:20.986Z | 2024-09-19T12:21:28.914Z |
4870467 | 4870467 | 20240806180105_yXynb | RU000Z | 2024-08-19T12:07:53.696Z | 2024-08-27T12:08:47.363Z |
4869823 | 4869823 | 20240806173318_phPH9 | RU000Z | 2024-08-19T12:07:20.330Z | 2024-08-27T12:08:21.436Z |
4869565 | 4869565 | 20240806172224_HAx9e | RU000Z | 2024-08-19T12:07:12.678Z | 2024-08-27T12:08:12.557Z |
4869234 | 4869234 | 20240806170820_lJ3Z8 | RU000Z | 2024-08-19T12:06:55.874Z | 2024-08-27T12:08:02.051Z |
4869128 | 4869128 | 20240806170209_XM9KX | RU000Z | 2024-08-19T12:06:49.188Z | 2024-08-27T12:07:54.734Z |
4866203 | 4866203 | 20240806153552_DdHhi | RU000Z | 2024-08-18T12:07:26.977Z | 2024-08-27T12:06:48.190Z |
4866138 | 4866138 | 20240806153112_2MMfh | RU000Z | 2024-08-18T12:07:24.240Z | 2024-08-27T12:06:45.264Z |
4864236 | 4864236 | 20240806140800_0qRlY | RU000Z | 2024-08-18T12:05:54.853Z | 2024-08-27T12:05:28.287Z |
4864169 | 4864169 | 20240806140324_APRBp | RU000Z | 2024-08-18T12:05:48.467Z | 2024-08-27T12:05:24.944Z |
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);