home / gmn_data_store / participating_station

Menu
  • Dashboards

participating_station

Each row represents a station recording a meteor sighting.

Data license: CC BY 4.0 license · Data source: Global Meteor Network

312 rows where station_code = "US0043" sorted by created_at descending

✎ View and edit SQL

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
7037481 7037481 20250705074054_0U6Ja US0043 2025-07-06T12:03:06.861Z 2025-07-14T12:45:24.794Z
7037439 7037439 20250705073127_WhCx7 US0043 2025-07-06T12:03:01.270Z 2025-07-14T12:45:23.658Z
7037203 7037203 20250705063313_Gz4xC US0043 2025-07-06T12:02:09.433Z 2025-07-14T12:45:14.780Z
7027323 7027323 20250703072819_mQkEK US0043 2025-07-04T12:07:39.955Z 2025-07-12T12:57:25.898Z
7027187 7027187 20250703061322_7dwaq US0043 2025-07-04T12:07:01.746Z 2025-07-12T12:57:21.341Z
7027162 7027162 20250703060522_L9bU5 US0043 2025-07-04T12:06:57.345Z 2025-07-12T12:57:20.387Z
7027118 7027118 20250703050949_Zi84N US0043 2025-07-04T12:06:49.460Z 2025-07-12T12:57:19.040Z
6972686 6972686 20250625063506_3zivG US0043 2025-06-26T12:16:29.605Z 2025-07-03T13:01:48.859Z
6964226 6964226 20250624044839_qCgpP US0043 2025-06-25T12:15:46.057Z 2025-07-02T12:48:58.434Z
6956434 6956434 20250623062648_I7ihi US0043 2025-06-24T12:22:33.620Z 2025-07-01T12:53:33.995Z
6955906 6955906 20250623031150_Vn3tn US0043 2025-06-24T12:21:15.849Z 2025-07-01T12:53:22.181Z
6937199 6937199 20250621054628_bB4Fb US0043 2025-06-22T12:16:45.426Z 2025-06-29T12:36:48.396Z
6861773 6861773 20250605073418_fqUr1 US0043 2025-06-06T12:08:20.623Z 2025-06-13T12:27:23.056Z
6858273 6858273 20250604042332_KOrR1 US0043 2025-06-05T12:05:48.225Z 2025-06-12T12:24:50.399Z
6561196 6561196 20250424033537_Vt32G US0043 2025-04-25T12:21:14.076Z 2025-05-02T12:35:02.195Z
6531669 6531669 20250421072936_cTrpU US0043 2025-04-22T12:02:01.701Z 2025-04-30T12:40:50.973Z
6496548 6496548 20250410091215_cE8Gz US0043 2025-04-11T12:05:01.234Z 2025-04-18T12:22:21.191Z
6491432 6491432 20250409074242_3GzOa US0043 2025-04-10T12:06:22.226Z 2025-04-17T12:23:05.254Z
6443575 6443575 20250402002951_efsQT US0043 2025-04-03T12:05:19.336Z 2025-04-10T12:26:24.754Z
6408657 6408657 20250328050630_tRC3P US0043 2025-03-29T12:13:23.331Z 2025-04-05T13:04:37.912Z
6408596 6408596 20250328042423_jCKeF US0043 2025-03-29T12:13:07.098Z 2025-04-05T13:04:35.398Z
6407607 6407607 20250328005449_9OO3D US0043 2025-03-29T12:08:45.888Z 2025-04-05T13:03:22.191Z
6400463 6400463 20250327084907_FeX3T US0043 2025-03-28T12:12:45.836Z 2025-04-04T12:48:09.621Z
6368125 6368125 20250322081540_Q33AV US0043 2025-03-23T12:11:29.119Z 2025-03-30T13:08:29.612Z
6345214 6345214 20250319050224_Fqu0w US0043 2025-03-20T12:17:40.341Z 2025-03-27T13:10:18.241Z
6312230 6312230 20250311080155_jc0zL US0043 2025-03-13T12:16:55.972Z 2025-03-19T12:37:52.061Z
6309768 6309768 20250312082846_MigNL US0043 2025-03-13T12:07:29.890Z 2025-03-20T12:43:53.967Z
6295860 6295860 20250309085649_AFzHh US0043 2025-03-10T12:15:36.592Z 2025-03-17T12:41:38.084Z
6295544 6295544 20250309074405_ys4rN US0043 2025-03-10T12:14:32.325Z 2025-03-17T12:41:03.909Z
6295055 6295055 20250309044737_0FnYn US0043 2025-03-10T12:13:00.731Z 2025-03-17T12:40:37.612Z
6176723 6176723 20250226103505_NMqKt US0043 2025-02-27T14:19:45.078Z 2025-03-06T14:53:21.275Z
6175372 6175372 20250226065838_BvTOV US0043 2025-02-27T14:15:21.634Z 2025-03-06T14:52:08.089Z
6175181 6175181 20250226060114_zp65R US0043 2025-02-27T14:14:36.920Z 2025-03-06T14:51:56.602Z
6175061 6175061 20250226052811_CSnoZ US0043 2025-02-27T14:14:12.232Z 2025-03-06T14:51:51.339Z
6139477 6139477 20250222101359_GrBm3 US0043 2025-02-23T14:17:51.026Z 2025-03-02T15:35:55.496Z
6138557 6138557 20250222073845_0TAfe US0043 2025-02-23T14:14:45.785Z 2025-03-02T15:34:58.670Z
6138173 6138173 20250222053713_mA5B1 US0043 2025-02-23T14:13:26.303Z 2025-03-02T15:34:23.501Z
6137378 6137378 20250222020338_S1BZN US0043 2025-02-23T14:10:00.045Z 2025-03-02T15:33:01.699Z
6128445 6128445 20250221064953_53S8L US0043 2025-02-22T14:12:25.313Z 2025-03-01T15:27:54.028Z
6123361 6123361 20250220102208_ruAUv US0043 2025-02-21T14:13:43.319Z 2025-02-28T15:27:55.148Z
6097944 6097944 20250211095912_cgfgA US0043 2025-02-12T14:04:24.277Z 2025-02-19T14:32:20.187Z
6097867 6097867 20250211084745_EFhvZ US0043 2025-02-12T14:03:59.375Z 2025-02-19T14:32:14.504Z
6089379 6089379 20250208102521_Eex2P US0043 2025-02-09T14:04:18.939Z 2025-02-16T14:20:46.963Z
6089104 6089104 20250208084707_6TP2M US0043 2025-02-09T14:03:25.680Z 2025-02-16T14:20:32.543Z
6073048 6073048 20250205081938_TdNJh US0043 2025-02-07T14:25:59.736Z 2025-02-13T14:35:08.160Z
6072983 6072983 20250205080051_wxqAt US0043 2025-02-07T14:25:55.739Z 2025-02-13T14:35:05.738Z
6072722 6072722 20250205061959_22eTP US0043 2025-02-07T14:25:15.945Z 2025-02-13T14:34:56.808Z
6072150 6072150 20250205052903_gZ2YV US0043 2025-02-07T14:24:47.542Z 2025-02-13T14:34:28.434Z
6064541 6064541 20250206062720_fEqab US0043 2025-02-07T14:10:11.689Z 2025-02-14T14:28:11.867Z
6007136 6007136 20250128044330_BWwhW US0043 2025-01-29T14:03:34.624Z 2025-02-06T14:44:52.032Z
6006210 6006210 20250127004112_4cdKV US0043 2025-01-28T14:19:51.911Z 2025-02-04T14:33:46.161Z
6002475 6002475 20250127104530_s1Aag US0043 2025-01-28T14:09:09.513Z 2025-02-05T14:38:56.123Z
6001930 6001930 20250127093103_MfgXS US0043 2025-01-28T14:07:36.102Z 2025-02-05T14:38:46.986Z
6001613 6001613 20250127084330_TKXsy US0043 2025-01-28T14:06:29.785Z 2025-02-05T14:38:43.280Z
6000311 6000311 20250127042016_083DU US0043 2025-01-28T14:02:49.910Z 2025-02-05T14:38:24.723Z
5992642 5992642 20250125072912_92k2t US0043 2025-01-26T14:05:41.115Z 2025-02-03T14:34:30.342Z
5992417 5992417 20250125062340_4G6Ul US0043 2025-01-26T14:04:52.248Z 2025-02-03T14:34:27.043Z
5991951 5991951 20250125051919_lQ7f3 US0043 2025-01-26T14:03:33.022Z 2025-02-03T14:34:20.531Z
5991613 5991613 20250125040434_AO8bw US0043 2025-01-26T14:02:36.458Z 2025-02-03T14:34:16.026Z
5987021 5987021 20250124074308_nY5dj US0043 2025-01-25T14:03:04.449Z 2025-02-02T14:36:41.927Z
5986894 5986894 20250124070312_pjiFs US0043 2025-01-25T14:02:37.161Z 2025-02-02T14:36:40.661Z
5986798 5986798 20250124062942_P6f4I US0043 2025-01-25T14:02:09.659Z 2025-02-02T14:36:39.446Z
5986563 5986563 20250124043202_qDETu US0043 2025-01-25T14:01:04.617Z 2025-02-02T14:36:36.019Z
5970777 5970777 20250116042459_ngbMQ US0043 2025-01-22T14:32:05.999Z 2025-01-24T14:32:37.794Z
5970239 5970239 20250116005059_dXRVp US0043 2025-01-22T14:31:40.756Z 2025-01-24T14:32:30.870Z
5953033 5953033 20250116103351_bwqWD US0043 2025-01-17T14:02:29.077Z 2025-01-25T14:39:12.258Z
5946117 5946117 20250112075925_9Bzc7 US0043 2025-01-13T14:00:16.866Z 2025-01-21T14:17:57.091Z
5943096 5943096 20250110102124_LqaYS US0043 2025-01-11T14:02:28.961Z 2025-01-19T14:18:21.852Z
5942871 5942871 20250110093641_aVEvm US0043 2025-01-11T14:01:26.457Z 2025-01-19T14:18:15.158Z
5939713 5939713 20250108101422_BeO5n US0043 2025-01-10T14:08:03.555Z 2025-01-17T14:15:49.864Z
5937651 5937651 20250108071400_cKHy7 US0043 2025-01-09T14:22:07.365Z 2025-01-16T14:24:25.952Z
5937542 5937542 20250108055552_z5LZ3 US0043 2025-01-09T14:21:55.177Z 2025-01-16T14:24:11.717Z
5937519 5937519 20250108053143_7PNtO US0043 2025-01-09T14:21:51.885Z 2025-01-16T14:24:07.207Z
5937470 5937470 20250108050106_mG2NB US0043 2025-01-09T14:21:45.749Z 2025-01-16T14:23:48.337Z
5937460 5937460 20250108045009_5YoII US0043 2025-01-09T14:21:45.109Z 2025-01-16T14:23:46.049Z
5937174 5937174 20250108023254_93kyi US0043 2025-01-09T14:20:59.771Z 2025-01-16T14:22:50.416Z
5922391 5922391 20250104053653_lH34w US0043 2025-01-06T14:23:05.718Z 2025-01-12T14:30:58.903Z
5910279 5910279 20250103051259_2YYxA US0043 2025-01-05T14:31:24.093Z 2025-01-11T14:42:59.153Z
5904922 5904922 20250103064004_Ryx8L US0043 2025-01-05T14:22:53.232Z 2025-01-11T14:44:13.648Z
5904281 5904281 20250103062705_1FMJ6 US0043 2025-01-05T14:22:20.809Z 2025-01-11T14:44:00.114Z
5900494 5900494 20250103051250_Q044G US0043 2025-01-05T14:19:13.410Z 2025-01-11T14:42:59.119Z
5863920 5863920 20241227090643_LT0aB US0043 2024-12-28T14:18:35.161Z 2025-01-04T14:42:47.182Z
5862470 5862470 20241227030824_pOk2E US0043 2024-12-28T14:13:53.092Z 2025-01-04T14:41:55.474Z
5855223 5855223 20241226000251_Mh814 US0043 2024-12-27T14:05:40.834Z 2025-01-03T14:28:23.089Z
5853499 5853499 20241225100921_Q5Wju US0043 2024-12-26T14:10:24.257Z 2025-01-02T14:34:28.689Z
5806627 5806627 20241215101912_C6hM7 US0043 2024-12-17T14:09:07.798Z 2024-12-23T14:41:39.510Z
5806623 5806623 20241215101738_6B0xV US0043 2024-12-17T14:09:05.656Z 2024-12-23T14:41:39.492Z
5806564 5806564 20241215094717_j2cN3 US0043 2024-12-17T14:08:55.269Z 2024-12-23T14:41:38.606Z
5806472 5806472 20241215090702_qp1ik US0043 2024-12-17T14:08:43.162Z 2024-12-23T14:41:37.486Z
5800091 5800091 20241214104622_s3YPp US0043 2024-12-16T14:14:24.607Z 2024-12-22T14:29:43.959Z
5800082 5800082 20241214104545_KZPbO US0043 2024-12-16T14:14:24.483Z 2024-12-22T14:29:43.875Z
5799970 5799970 20241214103800_NwLrO US0043 2024-12-16T14:14:14.191Z 2024-12-22T14:29:38.591Z
5799815 5799815 20241214103303_V9i9q US0043 2024-12-16T14:14:06.401Z 2024-12-22T14:29:33.553Z
5799684 5799684 20241214102824_gfSbH US0043 2024-12-16T14:14:01.002Z 2024-12-22T14:29:29.728Z
5798839 5798839 20241214094555_p3F7M US0043 2024-12-16T14:13:14.393Z 2024-12-22T14:28:59.333Z
5798780 5798780 20241214094202_LIUSe US0043 2024-12-16T14:13:09.332Z 2024-12-22T14:28:57.098Z
5795685 5795685 20241214090359_2TNNc US0043 2024-12-15T14:10:13.526Z 2024-12-22T14:28:32.200Z
5795595 5795595 20241214085933_uEBqY US0043 2024-12-15T14:10:11.872Z 2024-12-22T14:28:29.421Z
5795142 5795142 20241214083435_CUPNS US0043 2024-12-15T14:09:57.748Z 2024-12-22T14:28:15.103Z
5795088 5795088 20241214083230_hInBZ US0043 2024-12-15T14:09:53.267Z 2024-12-22T14:28:14.176Z

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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);
Powered by Datasette · Queries took 1.2ms · Data license: CC BY 4.0 license · Data source: Global Meteor Network