participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,571 rows where station_code = "US0023" 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 |
---|---|---|---|---|---|
5568133 | 5568133 | 20241121115403_Nv0Qt | US0023 | 2024-11-22T14:08:11.654Z | 2024-11-22T14:08:11.654Z |
5567847 | 5567847 | 20241121111924_g2D9C | US0023 | 2024-11-22T14:07:23.361Z | 2024-11-22T14:07:23.361Z |
5567757 | 5567757 | 20241121110001_8eQPK | US0023 | 2024-11-22T14:07:12.589Z | 2024-11-22T14:07:12.589Z |
5567565 | 5567565 | 20241121103502_v2a6X | US0023 | 2024-11-22T14:06:31.827Z | 2024-11-22T14:06:31.827Z |
5567405 | 5567405 | 20241121101228_9VS2Y | US0023 | 2024-11-22T14:06:10.824Z | 2024-11-22T14:06:10.824Z |
5566578 | 5566578 | 20241121065042_3I92z | US0023 | 2024-11-22T14:03:14.031Z | 2024-11-22T14:03:14.031Z |
5560506 | 5560506 | 20241120130240_2TuEV | US0023 | 2024-11-21T14:08:58.931Z | 2024-11-22T14:19:21.674Z |
5559192 | 5559192 | 20241120093637_u9CUy | US0023 | 2024-11-21T14:05:34.527Z | 2024-11-22T14:19:21.382Z |
5558976 | 5558976 | 20241120090140_tf32I | US0023 | 2024-11-21T14:04:56.527Z | 2024-11-22T14:19:21.340Z |
5558949 | 5558949 | 20241120085622_EhJk7 | US0023 | 2024-11-21T14:04:51.891Z | 2024-11-22T14:19:21.333Z |
5554920 | 5554920 | 20241119110318_EPpTi | US0023 | 2024-11-20T14:03:48.497Z | 2024-11-22T14:19:53.985Z |
5554753 | 5554753 | 20241119102501_5701r | US0023 | 2024-11-20T14:03:11.754Z | 2024-11-22T14:19:50.771Z |
5554581 | 5554581 | 20241119094158_N5qb5 | US0023 | 2024-11-20T14:02:32.348Z | 2024-11-22T14:19:44.390Z |
5554395 | 5554395 | 20241119084252_V1tKt | US0023 | 2024-11-20T14:01:52.970Z | 2024-11-22T14:19:39.528Z |
5554354 | 5554354 | 20241119082429_Rhh3J | US0023 | 2024-11-20T14:01:44.705Z | 2024-11-22T14:19:38.106Z |
5554017 | 5554017 | 20241119052749_KZrMU | US0023 | 2024-11-20T14:00:24.743Z | 2024-11-22T14:19:26.929Z |
5554005 | 5554005 | 20241119052312_GQxzl | US0023 | 2024-11-20T14:00:22.597Z | 2024-11-22T14:19:26.770Z |
5553358 | 5553358 | 20241118021005_3VuPP | US0023 | 2024-11-19T14:10:22.404Z | 2024-11-22T14:22:52.403Z |
5553218 | 5553218 | 20241118014020_2jvwv | US0023 | 2024-11-19T14:10:10.331Z | 2024-11-22T14:22:51.157Z |
5551202 | 5551202 | 20241118124454_eUfAy | US0023 | 2024-11-19T14:04:06.382Z | 2024-11-22T14:22:09.194Z |
5551024 | 5551024 | 20241118121153_BSxS3 | US0023 | 2024-11-19T14:03:47.343Z | 2024-11-22T14:22:07.716Z |
5550936 | 5550936 | 20241118115346_QQb6J | US0023 | 2024-11-19T14:03:32.441Z | 2024-11-22T14:22:06.974Z |
5550520 | 5550520 | 20241118103737_UgvUh | US0023 | 2024-11-19T14:02:29.497Z | 2024-11-22T14:22:03.671Z |
5550506 | 5550506 | 20241118103601_AGHhO | US0023 | 2024-11-19T14:02:28.377Z | 2024-11-22T14:22:03.584Z |
5550294 | 5550294 | 20241118100048_wir6F | US0023 | 2024-11-19T14:02:06.425Z | 2024-11-22T14:22:00.873Z |
5550059 | 5550059 | 20241118092217_cbGsg | US0023 | 2024-11-19T14:01:31.561Z | 2024-11-22T14:21:57.648Z |
5549908 | 5549908 | 20241118084218_XwQ6O | US0023 | 2024-11-19T14:01:12.941Z | 2024-11-22T14:21:55.021Z |
5549903 | 5549903 | 20241118083708_4Y1j5 | US0023 | 2024-11-19T14:01:12.292Z | 2024-11-22T14:21:54.885Z |
5549668 | 5549668 | 20241118055554_g13Og | US0023 | 2024-11-19T14:00:32.398Z | 2024-11-22T14:21:51.088Z |
5549613 | 5549613 | 20241118053851_MBFDq | US0023 | 2024-11-19T14:00:25.887Z | 2024-11-22T14:21:50.765Z |
5540698 | 5540698 | 20241114115140_OD92j | US0023 | 2024-11-15T14:04:18.264Z | 2024-11-22T14:23:52.098Z |
5539233 | 5539233 | 20241114055337_2j3rl | US0023 | 2024-11-15T14:00:25.993Z | 2024-11-22T14:23:42.568Z |
5538639 | 5538639 | 20241113042624_wliWS | US0023 | 2024-11-14T14:13:45.451Z | 2024-11-21T14:26:28.221Z |
5535283 | 5535283 | 20241112120356_azJ9C | US0023 | 2024-11-14T14:07:45.529Z | 2024-11-21T14:25:45.479Z |
5534488 | 5534488 | 20241113122239_II7d2 | US0023 | 2024-11-14T14:04:28.382Z | 2024-11-22T14:24:14.153Z |
5534334 | 5534334 | 20241113114637_MJWXh | US0023 | 2024-11-14T14:04:16.032Z | 2024-11-22T14:24:13.477Z |
5534320 | 5534320 | 20241113114218_JOkHt | US0023 | 2024-11-14T14:04:13.289Z | 2024-11-22T14:24:13.394Z |
5534315 | 5534315 | 20241113114119_r3UDa | US0023 | 2024-11-14T14:04:11.753Z | 2024-11-22T14:24:13.382Z |
5534148 | 5534148 | 20241113110915_M6Ooa | US0023 | 2024-11-14T14:03:40.388Z | 2024-11-22T14:24:12.554Z |
5534063 | 5534063 | 20241113105328_3JB43 | US0023 | 2024-11-14T14:03:30.981Z | 2024-11-22T14:24:12.177Z |
5527035 | 5527035 | 20241112105041_tq0VK | US0023 | 2024-11-13T14:04:54.102Z | 2024-11-21T14:25:40.762Z |
5526420 | 5526420 | 20241112091734_3zlCq | US0023 | 2024-11-13T14:02:58.203Z | 2024-11-21T14:25:34.815Z |
5519665 | 5519665 | 20241111122357_42fiv | US0023 | 2024-11-12T14:04:42.433Z | 2024-11-20T14:24:55.072Z |
5519421 | 5519421 | 20241111112049_sT4Wn | US0023 | 2024-11-12T14:03:58.277Z | 2024-11-20T14:24:49.955Z |
5518321 | 5518321 | 20241111070444_ihn9t | US0023 | 2024-11-12T14:00:34.341Z | 2024-11-20T14:24:32.130Z |
5517703 | 5517703 | 20241110043303_Y4OhD | US0023 | 2024-11-11T14:14:46.004Z | 2024-11-18T14:26:37.918Z |
5517676 | 5517676 | 20241110042701_r4Wes | US0023 | 2024-11-11T14:14:44.042Z | 2024-11-18T14:26:37.774Z |
5513904 | 5513904 | 20241110124106_h6ZGe | US0023 | 2024-11-11T14:05:37.764Z | 2024-11-19T14:21:39.616Z |
5513368 | 5513368 | 20241110112245_e7aIg | US0023 | 2024-11-11T14:04:32.717Z | 2024-11-19T14:21:33.596Z |
5511280 | 5511280 | 20241109053140_B72GP | US0023 | 2024-11-10T14:16:37.641Z | 2024-11-17T14:24:07.701Z |
5507542 | 5507542 | 20241109114728_UPtMo | US0023 | 2024-11-10T14:05:30.863Z | 2024-11-18T14:26:11.792Z |
5507340 | 5507340 | 20241109111719_2WHkE | US0023 | 2024-11-10T14:04:53.981Z | 2024-11-18T14:26:09.941Z |
5507314 | 5507314 | 20241109111043_ZzhNe | US0023 | 2024-11-10T14:04:49.585Z | 2024-11-18T14:26:09.616Z |
5507070 | 5507070 | 20241109102354_IlkO8 | US0023 | 2024-11-10T14:04:12.056Z | 2024-11-18T14:26:06.621Z |
5506880 | 5506880 | 20241109095319_z5uUA | US0023 | 2024-11-10T14:03:39.212Z | 2024-11-18T14:26:03.296Z |
5506753 | 5506753 | 20241109093139_UwSyp | US0023 | 2024-11-10T14:03:15.518Z | 2024-11-18T14:26:02.069Z |
5506567 | 5506567 | 20241109090128_rF3Bj | US0023 | 2024-11-10T14:02:34.945Z | 2024-11-18T14:26:00.607Z |
5506133 | 5506133 | 20241109074414_ILXo1 | US0023 | 2024-11-10T14:01:19.162Z | 2024-11-18T14:25:56.779Z |
5504911 | 5504911 | 20241108031722_v2DxC | US0023 | 2024-11-09T14:15:23.050Z | 2024-11-16T14:28:24.838Z |
5499552 | 5499552 | 20241108123619_fKdj2 | US0023 | 2024-11-09T14:04:18.374Z | 2024-11-17T14:23:12.990Z |
5499321 | 5499321 | 20241108115706_3iDQ0 | US0023 | 2024-11-09T14:03:45.476Z | 2024-11-17T14:23:09.428Z |
5498902 | 5498902 | 20241108102329_A2ur2 | US0023 | 2024-11-09T14:02:45.189Z | 2024-11-17T14:23:01.314Z |
5498749 | 5498749 | 20241108094958_rTH2M | US0023 | 2024-11-09T14:02:19.554Z | 2024-11-17T14:22:59.540Z |
5497597 | 5497597 | 20241107040831_B3fCA | US0023 | 2024-11-08T14:14:01.717Z | 2024-11-15T14:25:04.918Z |
5493585 | 5493585 | 20241107124213_pc2bN | US0023 | 2024-11-08T14:04:11.593Z | 2024-11-16T14:27:36.480Z |
5493227 | 5493227 | 20241107111944_mm1CA | US0023 | 2024-11-08T14:03:13.420Z | 2024-11-16T14:27:33.064Z |
5492321 | 5492321 | 20241107080829_V6SwY | US0023 | 2024-11-08T14:00:46.893Z | 2024-11-16T14:27:24.038Z |
5485893 | 5485893 | 20241106081928_UVMtD | US0023 | 2024-11-07T14:01:01.966Z | 2024-11-15T14:24:24.052Z |
5485891 | 5485891 | 20241106081822_uOHoy | US0023 | 2024-11-07T14:01:01.583Z | 2024-11-15T14:24:23.998Z |
5485772 | 5485772 | 20241106072412_2YnIh | US0023 | 2024-11-07T14:00:35.563Z | 2024-11-15T14:24:23.202Z |
5485427 | 5485427 | 20241105053359_kQ5jm | US0023 | 2024-11-06T14:18:15.414Z | 2024-11-13T14:27:42.286Z |
5480296 | 5480296 | 20241105121903_2vJ55 | US0023 | 2024-11-06T14:05:10.470Z | 2024-11-14T14:23:03.707Z |
5480251 | 5480251 | 20241105120956_G8nfb | US0023 | 2024-11-06T14:05:03.488Z | 2024-11-14T14:23:03.285Z |
5479392 | 5479392 | 20241105091618_lHZ2A | US0023 | 2024-11-06T14:02:10.452Z | 2024-11-14T14:22:58.775Z |
5471644 | 5471644 | 20241104121654_cGY4V | US0023 | 2024-11-05T14:04:09.515Z | 2024-11-13T14:27:24.893Z |
5471190 | 5471190 | 20241104105940_SqRoB | US0023 | 2024-11-05T14:03:04.474Z | 2024-11-13T14:27:23.859Z |
5471099 | 5471099 | 20241104104659_PSqqu | US0023 | 2024-11-05T14:02:53.190Z | 2024-11-13T14:27:23.659Z |
5459517 | 5459517 | 20241101111151_pQIK4 | US0023 | 2024-11-03T14:12:07.941Z | 2024-11-10T14:26:19.560Z |
5458510 | 5458510 | 20241101083732_teXrU | US0023 | 2024-11-03T14:09:53.421Z | 2024-11-10T14:26:14.108Z |
5456616 | 5456616 | 20241102115117_3jYaH | US0023 | 2024-11-03T14:05:08.268Z | 2024-11-11T14:22:30.107Z |
5456575 | 5456575 | 20241102114619_RidGe | US0023 | 2024-11-03T14:05:01.538Z | 2024-11-11T14:22:29.820Z |
5455284 | 5455284 | 20241102071047_Vky3e | US0023 | 2024-11-03T14:00:26.446Z | 2024-11-11T14:22:20.018Z |
5448156 | 5448156 | 20241031124945_w9qwb | US0023 | 2024-11-02T12:10:07.600Z | 2024-11-09T14:24:03.583Z |
5447214 | 5447214 | 20241031111956_EjvuE | US0023 | 2024-11-02T12:07:30.657Z | 2024-11-09T14:23:58.408Z |
5445723 | 5445723 | 20241031083920_bJ3m9 | US0023 | 2024-11-02T12:02:56.509Z | 2024-11-09T14:23:51.167Z |
5445404 | 5445404 | 20241031075845_2GqXz | US0023 | 2024-11-02T12:01:59.421Z | 2024-11-09T14:23:49.955Z |
5442923 | 5442923 | 20241030025633_tFmH5 | US0023 | 2024-11-01T12:20:12.852Z | 2024-11-07T14:26:48.932Z |
5435048 | 5435048 | 20241030104321_BRA28 | US0023 | 2024-11-01T12:04:03.855Z | 2024-11-08T14:22:49.000Z |
5432591 | 5432591 | 20241029035722_CQy23 | US0023 | 2024-10-31T12:21:28.023Z | 2024-11-06T14:27:28.146Z |
5423397 | 5423397 | 20241029101439_YKbsn | US0023 | 2024-10-31T12:01:22.377Z | 2024-11-07T14:26:25.634Z |
5421910 | 5421910 | 20241028115834_XKU91 | US0023 | 2024-10-30T12:20:17.802Z | 2024-11-06T14:27:08.840Z |
5414084 | 5414084 | 20241027110300_R13fG | US0023 | 2024-10-30T12:06:35.230Z | 2024-11-05T14:26:59.134Z |
5413821 | 5413821 | 20241027103122_hNdOz | US0023 | 2024-10-30T12:05:52.425Z | 2024-11-05T14:26:58.388Z |
5413490 | 5413490 | 20241028100804_irQyk | US0023 | 2024-10-30T12:03:17.574Z | 2024-11-06T14:27:06.127Z |
5412807 | 5412807 | 20241028073847_eaiW3 | US0023 | 2024-10-30T12:00:44.970Z | 2024-11-06T14:27:02.767Z |
5412798 | 5412798 | 20241028073633_TUYx4 | US0023 | 2024-10-30T12:00:42.264Z | 2024-11-06T14:27:02.655Z |
5401112 | 5401112 | 20241027071111_ZwULS | US0023 | 2024-10-29T12:00:34.916Z | 2024-11-05T14:26:50.157Z |
5399467 | 5399467 | 20241026042201_BehST | US0023 | 2024-10-28T12:20:00.004Z | 2024-11-03T14:27:39.824Z |
5390563 | 5390563 | 20241026100640_MsvWL | US0023 | 2024-10-28T12:03:27.098Z | 2024-11-04T14:28:29.484Z |
5389750 | 5389750 | 20241026075646_PCNOU | US0023 | 2024-10-28T12:01:09.897Z | 2024-11-04T14:28:24.236Z |
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);