participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,513 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 |
---|---|---|---|---|---|
5504911 | 5504911 | 20241108031722_v2DxC | US0023 | 2024-11-09T14:15:23.050Z | 2024-11-09T14:16:28.655Z |
5499552 | 5499552 | 20241108123619_fKdj2 | US0023 | 2024-11-09T14:04:18.374Z | 2024-11-09T14:04:18.374Z |
5499321 | 5499321 | 20241108115706_3iDQ0 | US0023 | 2024-11-09T14:03:45.476Z | 2024-11-09T14:03:45.476Z |
5498902 | 5498902 | 20241108102329_A2ur2 | US0023 | 2024-11-09T14:02:45.189Z | 2024-11-09T14:02:45.189Z |
5498749 | 5498749 | 20241108094958_rTH2M | US0023 | 2024-11-09T14:02:19.554Z | 2024-11-09T14:02:19.554Z |
5497597 | 5497597 | 20241107040831_B3fCA | US0023 | 2024-11-08T14:14:01.717Z | 2024-11-09T14:18:47.061Z |
5493585 | 5493585 | 20241107124213_pc2bN | US0023 | 2024-11-08T14:04:11.593Z | 2024-11-09T14:16:27.666Z |
5493227 | 5493227 | 20241107111944_mm1CA | US0023 | 2024-11-08T14:03:13.420Z | 2024-11-09T14:16:27.563Z |
5492321 | 5492321 | 20241107080829_V6SwY | US0023 | 2024-11-08T14:00:46.893Z | 2024-11-09T14:16:27.344Z |
5485893 | 5485893 | 20241106081928_UVMtD | US0023 | 2024-11-07T14:01:01.966Z | 2024-11-09T14:16:34.121Z |
5485891 | 5485891 | 20241106081822_uOHoy | US0023 | 2024-11-07T14:01:01.583Z | 2024-11-09T14:16:34.059Z |
5485772 | 5485772 | 20241106072412_2YnIh | US0023 | 2024-11-07T14:00:35.563Z | 2024-11-09T14:16:32.098Z |
5485427 | 5485427 | 20241105053359_kQ5jm | US0023 | 2024-11-06T14:18:15.414Z | 2024-11-09T14:21:21.538Z |
5480296 | 5480296 | 20241105121903_2vJ55 | US0023 | 2024-11-06T14:05:10.470Z | 2024-11-09T14:19:22.168Z |
5480251 | 5480251 | 20241105120956_G8nfb | US0023 | 2024-11-06T14:05:03.488Z | 2024-11-09T14:19:21.313Z |
5479392 | 5479392 | 20241105091618_lHZ2A | US0023 | 2024-11-06T14:02:10.452Z | 2024-11-09T14:19:05.499Z |
5471644 | 5471644 | 20241104121654_cGY4V | US0023 | 2024-11-05T14:04:09.515Z | 2024-11-09T14:20:32.365Z |
5471190 | 5471190 | 20241104105940_SqRoB | US0023 | 2024-11-05T14:03:04.474Z | 2024-11-09T14:20:29.040Z |
5471099 | 5471099 | 20241104104659_PSqqu | US0023 | 2024-11-05T14:02:53.190Z | 2024-11-09T14:20:28.424Z |
5459517 | 5459517 | 20241101111151_pQIK4 | US0023 | 2024-11-03T14:12:07.941Z | 2024-11-09T14:23:18.766Z |
5458510 | 5458510 | 20241101083732_teXrU | US0023 | 2024-11-03T14:09:53.421Z | 2024-11-09T14:23:12.754Z |
5456616 | 5456616 | 20241102115117_3jYaH | US0023 | 2024-11-03T14:05:08.268Z | 2024-11-09T14:22:44.698Z |
5456575 | 5456575 | 20241102114619_RidGe | US0023 | 2024-11-03T14:05:01.538Z | 2024-11-09T14:22:44.519Z |
5455284 | 5455284 | 20241102071047_Vky3e | US0023 | 2024-11-03T14:00:26.446Z | 2024-11-09T14:22:34.179Z |
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 |
5389633 | 5389633 | 20241026073456_MOJIX | US0023 | 2024-10-28T12:00:50.094Z | 2024-11-04T14:28:23.323Z |
5389503 | 5389503 | 20241026071117_pElQ4 | US0023 | 2024-10-28T12:00:28.946Z | 2024-11-04T14:28:22.848Z |
5388910 | 5388910 | 20241025062928_H2i2c | US0023 | 2024-10-27T12:22:35.431Z | 2024-11-02T12:28:35.137Z |
5380916 | 5380916 | 20241025120710_yZjWF | US0023 | 2024-10-27T12:06:59.010Z | 2024-11-03T14:27:12.395Z |
5379272 | 5379272 | 20241025081353_92d2u | US0023 | 2024-10-27T12:02:34.550Z | 2024-11-03T14:27:06.667Z |
5379063 | 5379063 | 20241025074851_fo30E | US0023 | 2024-10-27T12:01:57.655Z | 2024-11-03T14:27:05.751Z |
5378360 | 5378360 | 20241024060952_ZRCeb | US0023 | 2024-10-26T12:23:00.744Z | 2024-11-01T12:27:03.879Z |
5369172 | 5369172 | 20241024110418_xtP6I | US0023 | 2024-10-26T12:06:07.725Z | 2024-11-02T12:28:17.660Z |
5369110 | 5369110 | 20241024105709_IWQ0T | US0023 | 2024-10-26T12:05:53.782Z | 2024-11-02T12:28:17.545Z |
5368793 | 5368793 | 20241024101234_7E6Xa | US0023 | 2024-10-26T12:04:40.983Z | 2024-11-02T12:28:16.890Z |
5368361 | 5368361 | 20241024091021_vrVFD | US0023 | 2024-10-26T12:03:20.530Z | 2024-11-02T12:28:15.437Z |
5367810 | 5367810 | 20241024074446_OrezU | US0023 | 2024-10-26T12:01:35.156Z | 2024-11-02T12:28:14.632Z |
5367771 | 5367771 | 20241024073759_9cIPp | US0023 | 2024-10-26T12:01:29.483Z | 2024-11-02T12:28:14.570Z |
5367620 | 5367620 | 20241024071205_nVzed | US0023 | 2024-10-26T12:00:59.474Z | 2024-11-02T12:28:14.196Z |
5367289 | 5367289 | 20241023061416_Ifhog | US0023 | 2024-10-25T12:21:50.292Z | 2024-10-31T12:30:12.277Z |
5366959 | 5366959 | 20241023044945_lrRPx | US0023 | 2024-10-25T12:21:39.106Z | 2024-10-31T12:30:09.590Z |
5366699 | 5366699 | 20241023034155_cL2z8 | US0023 | 2024-10-25T12:21:26.895Z | 2024-10-31T12:30:07.798Z |
5366611 | 5366611 | 20241023030420_5fpDa | US0023 | 2024-10-25T12:21:19.988Z | 2024-10-31T12:30:07.001Z |
5366475 | 5366475 | 20241023021552_UoE9y | US0023 | 2024-10-25T12:21:09.213Z | 2024-10-31T12:30:05.573Z |
5358910 | 5358910 | 20241023121144_V2Fxw | US0023 | 2024-10-25T12:07:14.703Z | 2024-11-01T12:26:44.256Z |
5358504 | 5358504 | 20241023113751_qJx0h | US0023 | 2024-10-25T12:06:24.175Z | 2024-11-01T12:26:43.334Z |
5356771 | 5356771 | 20241023075351_86UZH | US0023 | 2024-10-25T12:01:35.366Z | 2024-11-01T12:26:37.011Z |
5346582 | 5346582 | 20241022121320_nvNkh | US0023 | 2024-10-24T12:05:10.513Z | 2024-10-31T12:29:47.358Z |
5336834 | 5336834 | 20241022090224_HxXBg | US0023 | 2024-10-23T12:03:34.849Z | 2024-10-31T12:29:42.620Z |
5329990 | 5329990 | 20241021111403_0Tskz | US0023 | 2024-10-22T12:05:45.156Z | 2024-10-30T12:26:35.946Z |
5329794 | 5329794 | 20241021105532_h6tPB | US0023 | 2024-10-22T12:05:07.855Z | 2024-10-30T12:26:35.481Z |
5329429 | 5329429 | 20241021101551_MuTUz | US0023 | 2024-10-22T12:04:11.295Z | 2024-10-30T12:26:34.657Z |
5324072 | 5324072 | 20241020083552_ZTF2N | US0023 | 2024-10-21T12:01:36.406Z | 2024-10-29T12:26:28.035Z |
5315363 | 5315363 | 20241015122814_p33RV | US0023 | 2024-10-17T12:04:31.922Z | 2024-10-24T12:27:52.244Z |
5314314 | 5314314 | 20241016122316_C1wRh | US0023 | 2024-10-17T12:02:04.444Z | 2024-10-25T12:24:29.607Z |
5313478 | 5313478 | 20241016073911_uonWw | US0023 | 2024-10-17T12:00:21.569Z | 2024-10-25T12:24:25.148Z |
5312683 | 5312683 | 20241015042746_35N8S | US0023 | 2024-10-16T12:10:54.721Z | 2024-10-23T12:24:52.647Z |
5312137 | 5312137 | 20241015024953_dne0y | US0023 | 2024-10-16T12:10:03.101Z | 2024-10-23T12:24:48.757Z |
5307806 | 5307806 | 20241015110614_UBh9z | US0023 | 2024-10-16T12:02:17.588Z | 2024-10-24T12:27:46.758Z |
5286152 | 5286152 | 20241012075101_G6DFk | US0023 | 2024-10-13T12:01:42.051Z | 2024-10-21T12:22:49.981Z |
5277753 | 5277753 | 20241011084602_1wUvk | US0023 | 2024-10-12T12:04:20.243Z | 2024-10-20T12:23:32.952Z |
5277703 | 5277703 | 20241011083938_65GkM | US0023 | 2024-10-12T12:04:13.867Z | 2024-10-20T12:23:32.164Z |
5264189 | 5264189 | 20241009075201_rEBbr | US0023 | 2024-10-10T12:03:18.021Z | 2024-10-18T12:21:41.793Z |
5257800 | 5257800 | 20241008111628_z9I8t | US0023 | 2024-10-09T12:05:49.917Z | 2024-10-17T12:20:01.496Z |
5257170 | 5257170 | 20241008091011_L18lF | US0023 | 2024-10-09T12:04:36.015Z | 2024-10-17T12:19:59.154Z |
5256923 | 5256923 | 20241008083004_Qrsob | US0023 | 2024-10-09T12:04:05.349Z | 2024-10-17T12:19:57.909Z |
5256139 | 5256139 | 20241008061110_LXANa | US0023 | 2024-10-09T12:02:27.735Z | 2024-10-17T12:19:55.577Z |
5248882 | 5248882 | 20241007070341_1Ojze | US0023 | 2024-10-08T12:03:35.356Z | 2024-10-16T12:21:02.192Z |
5238225 | 5238225 | 20241006081328_QLaHR | US0023 | 2024-10-07T12:03:54.829Z | 2024-10-15T12:28:47.540Z |
5237658 | 5237658 | 20241006053045_HMW2b | US0023 | 2024-10-07T12:02:19.146Z | 2024-10-15T12:28:44.138Z |
5228717 | 5228717 | 20241004072805_1Sw97 | US0023 | 2024-10-06T12:04:19.459Z | 2024-10-13T12:26:11.524Z |
5228440 | 5228440 | 20241004052444_HedIB | US0023 | 2024-10-06T12:03:21.495Z | 2024-10-13T12:26:10.321Z |
5222227 | 5222227 | 20241003122534_UeXRb | US0023 | 2024-10-05T12:15:15.656Z | 2024-10-12T12:25:03.515Z |
5221281 | 5221281 | 20241003093014_xH8eP | US0023 | 2024-10-05T12:13:17.787Z | 2024-10-12T12:25:00.801Z |
5220817 | 5220817 | 20241003075217_v82dj | US0023 | 2024-10-05T12:12:12.194Z | 2024-10-12T12:24:59.475Z |
5220191 | 5220191 | 20241003045330_hrcS6 | US0023 | 2024-10-05T12:10:27.397Z | 2024-10-12T12:24:56.947Z |
5212574 | 5212574 | 20241003031048_2O7Zi | US0023 | 2024-10-04T12:03:23.042Z | 2024-10-12T12:24:54.817Z |
5211709 | 5211709 | 20241003021204_WdMHz | US0023 | 2024-10-04T12:01:17.965Z | 2024-10-12T12:24:53.791Z |
5208418 | 5208418 | 20241002122041_xxRy5 | US0023 | 2024-10-03T12:08:12.678Z | 2024-10-11T12:23:29.497Z |
5202129 | 5202129 | 20241001094307_UT5e0 | US0023 | 2024-10-02T12:05:50.201Z | 2024-10-10T12:24:39.628Z |
5201412 | 5201412 | 20241001064559_RK2dJ | US0023 | 2024-10-02T12:04:20.684Z | 2024-10-10T12:24:35.448Z |
5201266 | 5201266 | 20241001060134_0K2Ss | US0023 | 2024-10-02T12:03:53.928Z | 2024-10-10T12:24:34.398Z |
5200996 | 5200996 | 20241001044615_NyvPV | US0023 | 2024-10-02T12:03:27.989Z | 2024-10-10T12:24:33.268Z |
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);