participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
270 rows where station_code = "DE000Z" 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 |
---|---|---|---|---|---|
4954364 | 4954364 | 20240811025906_0RsX1 | DE000Z | 2024-09-03T12:18:12.569Z | 2024-09-06T12:28:58.350Z |
4953868 | 4953868 | 20240811024719_iT5TJ | DE000Z | 2024-09-03T12:18:02.556Z | 2024-09-06T12:28:40.701Z |
4953513 | 4953513 | 20240811023954_uhqQm | DE000Z | 2024-09-03T12:17:44.432Z | 2024-09-06T12:28:28.520Z |
4953509 | 4953509 | 20240811023954_HWlEH | DE000Z | 2024-09-03T12:17:44.292Z | 2024-09-06T12:28:28.336Z |
4953451 | 4953451 | 20240811023835_L2F2U | DE000Z | 2024-09-03T12:17:41.666Z | 2024-09-06T12:28:26.680Z |
4953324 | 4953324 | 20240811023617_4zo1n | DE000Z | 2024-09-03T12:17:34.330Z | 2024-09-06T12:28:23.494Z |
4953121 | 4953121 | 20240811023324_82xit | DE000Z | 2024-09-03T12:17:19.909Z | 2024-09-06T12:28:19.323Z |
4952731 | 4952731 | 20240811022633_IEw9X | DE000Z | 2024-09-03T12:17:04.842Z | 2024-09-06T12:28:07.675Z |
4952611 | 4952611 | 20240811022451_d6SDq | DE000Z | 2024-09-03T12:17:02.899Z | 2024-09-06T12:28:06.268Z |
4952398 | 4952398 | 20240811022103_rK5fX | DE000Z | 2024-09-03T12:16:56.977Z | 2024-09-06T12:27:59.685Z |
4950799 | 4950799 | 20240811021157_5dtvP | DE000Z | 2024-09-02T12:16:36.333Z | 2024-09-06T12:27:50.010Z |
4950637 | 4950637 | 20240811021014_9Iy2P | DE000Z | 2024-09-02T12:16:33.070Z | 2024-09-06T12:27:46.643Z |
4950630 | 4950630 | 20240811021010_EkHAm | DE000Z | 2024-09-02T12:16:32.981Z | 2024-09-06T12:27:46.629Z |
4950277 | 4950277 | 20240811020436_c9Fk5 | DE000Z | 2024-09-02T12:16:19.946Z | 2024-09-06T12:27:42.843Z |
4950163 | 4950163 | 20240811020204_9uf2k | DE000Z | 2024-09-02T12:16:10.666Z | 2024-09-06T12:27:41.492Z |
4950152 | 4950152 | 20240811020132_9re6d | DE000Z | 2024-09-02T12:16:10.198Z | 2024-09-06T12:27:41.366Z |
4949979 | 4949979 | 20240811015859_z7wzo | DE000Z | 2024-09-02T12:16:01.372Z | 2024-09-06T12:27:39.548Z |
4949794 | 4949794 | 20240811015536_iM0qO | DE000Z | 2024-09-02T12:15:55.007Z | 2024-09-06T12:27:37.688Z |
4949648 | 4949648 | 20240811015317_A8ePZ | DE000Z | 2024-09-02T12:15:51.447Z | 2024-09-06T12:27:36.077Z |
4949354 | 4949354 | 20240811014807_Sg6gP | DE000Z | 2024-09-02T12:15:43.427Z | 2024-09-06T12:27:32.212Z |
4949332 | 4949332 | 20240811014755_Y1it9 | DE000Z | 2024-09-02T12:15:43.030Z | 2024-09-06T12:27:32.011Z |
4949254 | 4949254 | 20240811014643_WT1gg | DE000Z | 2024-09-02T12:15:41.311Z | 2024-09-06T12:27:31.184Z |
4948794 | 4948794 | 20240811014025_Br95T | DE000Z | 2024-09-02T12:15:18.103Z | 2024-09-06T12:27:26.831Z |
4948680 | 4948680 | 20240811013816_GW1B4 | DE000Z | 2024-09-02T12:15:10.596Z | 2024-09-06T12:27:23.264Z |
4948515 | 4948515 | 20240811013445_qpCqs | DE000Z | 2024-09-02T12:15:03.513Z | 2024-09-06T12:27:18.198Z |
4948201 | 4948201 | 20240811013016_yByKE | DE000Z | 2024-09-02T12:14:57.379Z | 2024-09-06T12:27:11.146Z |
4947828 | 4947828 | 20240811012529_idkli | DE000Z | 2024-09-02T12:14:48.319Z | 2024-09-06T12:27:02.998Z |
4947755 | 4947755 | 20240811012355_cDXIf | DE000Z | 2024-09-02T12:14:46.580Z | 2024-09-06T12:27:01.107Z |
4947716 | 4947716 | 20240811012305_5b13h | DE000Z | 2024-09-02T12:14:45.247Z | 2024-09-06T12:26:59.671Z |
4947067 | 4947067 | 20240811011248_zwXGV | DE000Z | 2024-09-02T12:14:15.929Z | 2024-09-06T12:26:44.026Z |
4946898 | 4946898 | 20240811010942_16bIb | DE000Z | 2024-09-02T12:14:11.105Z | 2024-09-06T12:26:39.211Z |
4946881 | 4946881 | 20240811010915_34tRI | DE000Z | 2024-09-02T12:14:10.586Z | 2024-09-06T12:26:38.707Z |
4946571 | 4946571 | 20240811010255_34BOG | DE000Z | 2024-09-02T12:14:01.032Z | 2024-09-06T12:26:26.858Z |
4946297 | 4946297 | 20240811005916_r6KDh | DE000Z | 2024-09-02T12:13:47.583Z | 2024-09-06T12:26:20.292Z |
4946064 | 4946064 | 20240811005603_9bMEP | DE000Z | 2024-09-02T12:13:34.499Z | 2024-09-06T12:26:13.450Z |
4946052 | 4946052 | 20240811005602_kM2eA | DE000Z | 2024-09-02T12:13:34.337Z | 2024-09-06T12:26:13.420Z |
4945429 | 4945429 | 20240811004551_uFU8V | DE000Z | 2024-09-02T12:13:17.007Z | 2024-09-06T12:25:54.971Z |
4945358 | 4945358 | 20240811004451_Iip7M | DE000Z | 2024-09-02T12:13:15.818Z | 2024-09-06T12:25:53.915Z |
4945305 | 4945305 | 20240811004409_OlLLL | DE000Z | 2024-09-02T12:13:14.346Z | 2024-09-06T12:25:51.848Z |
4945212 | 4945212 | 20240811004226_Gr6LR | DE000Z | 2024-09-02T12:13:11.919Z | 2024-09-06T12:25:49.014Z |
4945108 | 4945108 | 20240811004114_xqbLC | DE000Z | 2024-09-02T12:13:09.853Z | 2024-09-06T12:25:46.974Z |
4944365 | 4944365 | 20240811002838_8pXg0 | DE000Z | 2024-09-02T12:12:29.425Z | 2024-09-06T12:25:20.013Z |
4944343 | 4944343 | 20240811002758_3NYjQ | DE000Z | 2024-09-02T12:12:28.303Z | 2024-09-06T12:25:19.001Z |
4944008 | 4944008 | 20240811002038_HKwUb | DE000Z | 2024-09-02T12:12:18.284Z | 2024-09-06T12:25:08.912Z |
4943978 | 4943978 | 20240811002004_nrMP0 | DE000Z | 2024-09-02T12:12:16.305Z | 2024-09-06T12:25:07.288Z |
4943697 | 4943697 | 20240811001548_ac88n | DE000Z | 2024-09-02T12:12:05.111Z | 2024-09-06T12:25:01.535Z |
4943662 | 4943662 | 20240811001512_lUuyf | DE000Z | 2024-09-02T12:12:03.772Z | 2024-09-06T12:25:00.989Z |
4943649 | 4943649 | 20240811001502_w2FlZ | DE000Z | 2024-09-02T12:12:02.714Z | 2024-09-06T12:25:00.530Z |
4943633 | 4943633 | 20240811001458_IBk81 | DE000Z | 2024-09-02T12:12:02.289Z | 2024-09-06T12:25:00.119Z |
4943469 | 4943469 | 20240811001212_1dHMW | DE000Z | 2024-09-02T12:11:51.452Z | 2024-09-06T12:24:51.467Z |
4943394 | 4943394 | 20240811001049_3QCAM | DE000Z | 2024-09-02T12:11:49.532Z | 2024-09-06T12:24:47.042Z |
4943118 | 4943118 | 20240811000554_dLgKm | DE000Z | 2024-09-02T12:11:42.511Z | 2024-09-06T12:24:38.912Z |
4943115 | 4943115 | 20240811000547_AWLNx | DE000Z | 2024-09-02T12:11:42.467Z | 2024-09-06T12:24:38.879Z |
4942930 | 4942930 | 20240811000125_4mhbC | DE000Z | 2024-09-02T12:11:37.763Z | 2024-09-06T12:24:33.766Z |
4942825 | 4942825 | 20240810235734_LP8CY | DE000Z | 2024-09-02T12:11:34.114Z | 2024-09-06T12:24:30.858Z |
4942785 | 4942785 | 20240810235702_c9Y8d | DE000Z | 2024-09-02T12:11:33.070Z | 2024-09-06T12:24:29.517Z |
4942751 | 4942751 | 20240810235629_d7saY | DE000Z | 2024-09-02T12:11:32.549Z | 2024-09-06T12:24:29.181Z |
4942527 | 4942527 | 20240810235323_ZtyCU | DE000Z | 2024-09-02T12:11:16.669Z | 2024-09-06T12:24:20.253Z |
4942497 | 4942497 | 20240810235314_krBsJ | DE000Z | 2024-09-02T12:11:16.126Z | 2024-09-06T12:24:19.041Z |
4942434 | 4942434 | 20240810235204_uJFi6 | DE000Z | 2024-09-02T12:11:12.417Z | 2024-09-06T12:24:16.257Z |
4942192 | 4942192 | 20240810234741_0R4b2 | DE000Z | 2024-09-02T12:11:05.170Z | 2024-09-06T12:24:09.127Z |
4942050 | 4942050 | 20240810234510_Wsmqc | DE000Z | 2024-09-02T12:11:01.181Z | 2024-09-06T12:24:04.729Z |
4941724 | 4941724 | 20240810233828_0q0Wh | DE000Z | 2024-09-02T12:10:44.040Z | 2024-09-06T12:23:52.241Z |
4941630 | 4941630 | 20240810233646_WjKlA | DE000Z | 2024-09-02T12:10:38.385Z | 2024-09-06T12:23:51.264Z |
4941614 | 4941614 | 20240810233629_2P9rC | DE000Z | 2024-09-02T12:10:37.642Z | 2024-09-06T12:23:51.065Z |
4941494 | 4941494 | 20240810233421_lO2Xu | DE000Z | 2024-09-02T12:10:31.838Z | 2024-09-06T12:23:49.101Z |
4941268 | 4941268 | 20240810232941_NDsnw | DE000Z | 2024-09-02T12:10:24.025Z | 2024-09-06T12:23:45.412Z |
4940926 | 4940926 | 20240810232152_2acnw | DE000Z | 2024-09-01T12:10:46.225Z | 2024-09-06T12:23:41.246Z |
4940866 | 4940866 | 20240810232025_ptFHa | DE000Z | 2024-09-01T12:10:44.746Z | 2024-09-06T12:23:40.423Z |
4940744 | 4940744 | 20240810231822_YrXhD | DE000Z | 2024-09-01T12:10:42.143Z | 2024-09-06T12:23:39.135Z |
4940432 | 4940432 | 20240810231203_nxDaT | DE000Z | 2024-09-01T12:10:27.706Z | 2024-09-06T12:23:35.004Z |
4940414 | 4940414 | 20240810231149_qBgNr | DE000Z | 2024-09-01T12:10:27.517Z | 2024-09-06T12:23:34.967Z |
4940039 | 4940039 | 20240810230311_2u0MY | DE000Z | 2024-09-01T12:10:15.936Z | 2024-09-06T12:23:30.311Z |
4940000 | 4940000 | 20240810230227_s7KnV | DE000Z | 2024-09-01T12:10:14.785Z | 2024-09-06T12:23:29.862Z |
4939877 | 4939877 | 20240810225916_S2FmZ | DE000Z | 2024-09-01T12:10:11.746Z | 2024-09-06T12:23:28.620Z |
4939493 | 4939493 | 20240810224813_ctjwx | DE000Z | 2024-09-01T12:09:49.615Z | 2024-09-06T12:23:23.329Z |
4939378 | 4939378 | 20240810224502_QR2aZ | DE000Z | 2024-09-01T12:09:46.417Z | 2024-09-06T12:23:21.899Z |
4939305 | 4939305 | 20240810224216_afUOf | DE000Z | 2024-09-01T12:09:44.097Z | 2024-09-06T12:23:20.941Z |
4939281 | 4939281 | 20240810224146_bVAVe | DE000Z | 2024-09-01T12:09:43.185Z | 2024-09-06T12:23:20.458Z |
4939168 | 4939168 | 20240810223903_dD2sg | DE000Z | 2024-09-01T12:09:39.430Z | 2024-09-06T12:23:15.564Z |
4938971 | 4938971 | 20240810223336_b9RMR | DE000Z | 2024-09-01T12:09:33.093Z | 2024-09-06T12:23:09.272Z |
4938937 | 4938937 | 20240810223249_HC7Fi | DE000Z | 2024-09-01T12:09:31.780Z | 2024-09-06T12:23:08.132Z |
4938841 | 4938841 | 20240810223035_HE4zU | DE000Z | 2024-09-01T12:09:27.471Z | 2024-09-06T12:23:05.241Z |
4938422 | 4938422 | 20240810221936_rzOzz | DE000Z | 2024-09-01T12:09:06.273Z | 2024-09-06T12:22:51.698Z |
4938291 | 4938291 | 20240810221541_9oRgi | DE000Z | 2024-09-01T12:09:02.889Z | 2024-09-06T12:22:49.553Z |
4938180 | 4938180 | 20240810221154_hD2SG | DE000Z | 2024-09-01T12:08:58.729Z | 2024-09-06T12:22:44.759Z |
4938150 | 4938150 | 20240810221120_DwP94 | DE000Z | 2024-09-01T12:08:57.891Z | 2024-09-06T12:22:44.352Z |
4938142 | 4938142 | 20240810221112_jXjXK | DE000Z | 2024-09-01T12:08:57.548Z | 2024-09-06T12:22:44.133Z |
4938051 | 4938051 | 20240810220936_AGnne | DE000Z | 2024-09-01T12:08:54.283Z | 2024-09-06T12:22:41.606Z |
4937864 | 4937864 | 20240810220321_bsyOP | DE000Z | 2024-09-01T12:08:40.427Z | 2024-09-06T12:22:35.103Z |
4937624 | 4937624 | 20240810215553_m3mwO | DE000Z | 2024-09-01T12:08:30.374Z | 2024-09-06T12:22:24.434Z |
4937584 | 4937584 | 20240810215447_DuNMx | DE000Z | 2024-09-01T12:08:28.700Z | 2024-09-06T12:22:21.597Z |
4937441 | 4937441 | 20240810215014_ZKb8W | DE000Z | 2024-09-01T12:08:17.024Z | 2024-09-06T12:22:15.268Z |
4937320 | 4937320 | 20240810214629_CDeOi | DE000Z | 2024-09-01T12:08:09.629Z | 2024-09-06T12:22:07.981Z |
4937207 | 4937207 | 20240810214255_1PImM | DE000Z | 2024-09-01T12:08:05.789Z | 2024-09-06T12:22:03.621Z |
4937186 | 4937186 | 20240810214222_azh3C | DE000Z | 2024-09-01T12:08:04.892Z | 2024-09-06T12:22:02.501Z |
4936998 | 4936998 | 20240810213654_OtlNC | DE000Z | 2024-09-01T12:07:59.155Z | 2024-09-06T12:21:55.702Z |
4936889 | 4936889 | 20240810213349_3O0R6 | DE000Z | 2024-09-01T12:07:52.502Z | 2024-09-06T12:21:51.827Z |
4936812 | 4936812 | 20240810213129_Ct6Hn | DE000Z | 2024-09-01T12:07:47.170Z | 2024-09-06T12:21:47.662Z |
4936806 | 4936806 | 20240810213128_vkd6c | DE000Z | 2024-09-01T12:07:46.964Z | 2024-09-06T12:21:47.446Z |
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);