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

245 rows where station_code = "US0057" 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
9595827 9595827 20260330090845_223uB US0057 2026-03-31T12:02:38.038Z 2026-04-06T12:30:35.812Z
9586792 9586792 20260327093752_evVQk US0057 2026-03-28T12:04:01.194Z 2026-04-05T12:33:48.664Z
9586775 9586775 20260327093248_V6WF5 US0057 2026-03-28T12:03:59.346Z 2026-04-05T12:33:48.052Z
9586715 9586715 20260327091914_3KznP US0057 2026-03-28T12:03:49.687Z 2026-04-05T12:33:38.866Z
9586706 9586706 20260327091622_Iv5cY US0057 2026-03-28T12:03:48.409Z 2026-04-05T12:33:38.389Z
9586602 9586602 20260327083658_yl4Qk US0057 2026-03-28T12:03:31.735Z 2026-04-05T12:33:32.215Z
9586577 9586577 20260327082710_oSBz3 US0057 2026-03-28T12:03:28.154Z 2026-04-05T12:33:31.177Z
9586416 9586416 20260327072108_fNd6O US0057 2026-03-28T12:03:01.835Z 2026-04-05T12:33:24.434Z
9585946 9585946 20260327031539_vzT92 US0057 2026-03-28T12:01:48.174Z 2026-04-05T12:32:54.091Z
9585749 9585749 20260327022003_aM8wQ US0057 2026-03-28T12:01:11.827Z 2026-04-05T12:32:37.442Z
9583104 9583104 20260326110058_sDAo6 US0057 2026-03-27T12:07:43.756Z 2026-04-04T12:40:49.952Z
9582992 9582992 20260326103302_YxCOR US0057 2026-03-27T12:07:24.094Z 2026-04-04T12:40:39.136Z
9582940 9582940 20260326100249_Zui93 US0057 2026-03-27T12:07:16.445Z 2026-04-04T12:40:36.953Z
9582444 9582444 20260326073255_bvV2H US0057 2026-03-27T12:05:46.759Z 2026-04-04T12:40:01.258Z
9582352 9582352 20260326065844_xwvPx US0057 2026-03-27T12:05:30.213Z 2026-04-04T12:39:52.030Z
9582206 9582206 20260326050155_TTW2r US0057 2026-03-27T12:04:57.327Z 2026-04-04T12:39:41.966Z
9580984 9580984 20260326020503_M0bkH US0057 2026-03-27T12:01:49.448Z 2026-04-04T12:38:37.849Z
9563931 9563931 20260323093549_f8fau US0057 2026-03-24T12:07:01.168Z 2026-03-31T12:26:59.289Z
9563200 9563200 20260323073457_uQ7jN US0057 2026-03-24T12:05:27.860Z 2026-03-31T12:26:38.055Z
9556503 9556503 20260322104622_1K5V8 US0057 2026-03-23T12:04:52.025Z 2026-03-30T12:29:02.854Z
9556476 9556476 20260322104031_qw0s5 US0057 2026-03-23T12:04:50.362Z 2026-03-30T12:29:02.044Z
9556426 9556426 20260322103144_474rp US0057 2026-03-23T12:04:47.152Z 2026-03-30T12:29:00.654Z
9556280 9556280 20260322095524_Dfzvx US0057 2026-03-23T12:04:36.933Z 2026-03-30T12:28:56.321Z
9555969 9555969 20260322085501_8SejU US0057 2026-03-23T12:04:12.968Z 2026-03-30T12:28:40.626Z
9555949 9555949 20260322084833_3JhGp US0057 2026-03-23T12:04:11.272Z 2026-03-30T12:28:40.001Z
9555914 9555914 20260322083635_YSEn7 US0057 2026-03-23T12:04:07.800Z 2026-03-30T12:28:38.952Z
9555789 9555789 20260322075645_vmJgn US0057 2026-03-23T12:03:54.693Z 2026-03-30T12:28:35.035Z
9555784 9555784 20260322075452_bcyYZ US0057 2026-03-23T12:03:54.326Z 2026-03-30T12:28:34.883Z
9555741 9555741 20260322074346_8kDau US0057 2026-03-23T12:03:50.867Z 2026-03-30T12:28:33.638Z
9555730 9555730 20260322074049_7O044 US0057 2026-03-23T12:03:49.844Z 2026-03-30T12:28:33.322Z
9555646 9555646 20260322071909_cLfLM US0057 2026-03-23T12:03:44.264Z 2026-03-30T12:28:31.404Z
9555630 9555630 20260322070456_sIZ8I US0057 2026-03-23T12:03:42.574Z 2026-03-30T12:28:30.785Z
9555587 9555587 20260322065320_90w4o US0057 2026-03-23T12:03:39.708Z 2026-03-30T12:28:30.100Z
9555483 9555483 20260322052246_CUTuB US0057 2026-03-23T12:03:28.966Z 2026-03-30T12:28:27.313Z
9555210 9555210 20260322042022_LRnf3 US0057 2026-03-23T12:03:15.473Z 2026-03-30T12:28:22.968Z
9554888 9554888 20260322034108_YX9sy US0057 2026-03-23T12:02:54.939Z 2026-03-30T12:28:10.986Z
9553881 9553881 20260322022302_EInMn US0057 2026-03-23T12:01:57.118Z 2026-03-30T12:27:54.076Z
9546037 9546037 20260321113152_v4cXL US0057 2026-03-22T12:10:51.760Z 2026-03-29T12:19:46.871Z
9545659 9545659 20260321105705_yRmw8 US0057 2026-03-22T12:09:56.650Z 2026-03-29T12:19:42.200Z
9545647 9545647 20260321105633_TT4g7 US0057 2026-03-22T12:09:55.697Z 2026-03-29T12:19:42.169Z
9544019 9544019 20260321070248_C33Lq US0057 2026-03-22T12:05:29.046Z 2026-03-29T12:19:15.239Z
9543973 9543973 20260321065041_SWcqx US0057 2026-03-22T12:05:19.565Z 2026-03-29T12:19:14.611Z
9543870 9543870 20260321060339_zhKQe US0057 2026-03-22T12:04:59.720Z 2026-03-29T12:19:13.436Z
9543296 9543296 20260321032601_0Z7mL US0057 2026-03-22T12:03:20.225Z 2026-03-29T12:19:05.697Z
9536407 9536407 20260320094631_6MFgV US0057 2026-03-21T12:13:21.157Z 2026-03-28T12:35:01.335Z
9536234 9536234 20260320092642_bm1I9 US0057 2026-03-21T12:12:52.849Z 2026-03-28T12:34:58.772Z
9535782 9535782 20260320083309_T5P0X US0057 2026-03-21T12:11:51.388Z 2026-03-28T12:34:51.124Z
9535683 9535683 20260320081715_fuHuR US0057 2026-03-21T12:11:34.426Z 2026-03-28T12:34:49.103Z
9535362 9535362 20260320071705_nmD1l US0057 2026-03-21T12:10:30.990Z 2026-03-28T12:34:33.670Z
9535255 9535255 20260320063847_kEYoD US0057 2026-03-21T12:10:12.777Z 2026-03-28T12:34:31.279Z
9535235 9535235 20260320062431_Rf9e6 US0057 2026-03-21T12:10:09.021Z 2026-03-28T12:34:30.483Z
9533218 9533218 20260320021428_Lcefw US0057 2026-03-21T12:04:50.090Z 2026-03-28T12:33:50.622Z
9523381 9523381 20260319095421_Sy2ia US0057 2026-03-20T12:11:20.914Z 2026-03-27T12:41:28.341Z
9523002 9523002 20260319091606_XgvHs US0057 2026-03-20T12:10:43.492Z 2026-03-27T12:41:23.892Z
9522071 9522071 20260319053035_k11Qg US0057 2026-03-20T12:08:57.848Z 2026-03-27T12:41:13.305Z
9522036 9522036 20260319051815_XZCRs US0057 2026-03-20T12:08:54.293Z 2026-03-27T12:41:13.040Z
9521983 9521983 20260319050641_Vrv9H US0057 2026-03-20T12:08:48.560Z 2026-03-27T12:41:12.394Z
9521529 9521529 20260319042526_ITuRy US0057 2026-03-20T12:08:10.943Z 2026-03-27T12:40:55.553Z
9513471 9513471 20260318091931_n7eQz US0057 2026-03-19T12:15:25.175Z 2026-03-26T12:37:55.627Z
9512364 9512364 20260318053536_nowFc US0057 2026-03-19T12:12:18.985Z 2026-03-26T12:37:44.425Z
9502748 9502748 20260317055051_K2Bm5 US0057 2026-03-18T12:03:54.977Z 2026-03-25T12:41:58.278Z
9502724 9502724 20260317054059_MDxu6 US0057 2026-03-18T12:03:51.487Z 2026-03-25T12:41:58.046Z
9502551 9502551 20260317043226_9YS7V US0057 2026-03-18T12:03:14.396Z 2026-03-25T12:41:51.060Z
9502238 9502238 20260317024931_zYgkZ US0057 2026-03-18T12:02:02.483Z 2026-03-25T12:41:47.742Z
9451720 9451720 20260310033033_eWZMX US0057 2026-03-11T12:03:39.881Z 2026-03-18T12:39:03.335Z
9451675 9451675 20260310031710_KSa0P US0057 2026-03-11T12:03:33.335Z 2026-03-18T12:39:02.534Z
9443909 9443909 20260308115738_6Cw9N US0057 2026-03-09T12:09:23.849Z 2026-03-16T12:44:13.861Z
9443248 9443248 20260308093010_XM4KA US0057 2026-03-09T12:07:11.195Z 2026-03-16T12:44:02.167Z
9443153 9443153 20260308090458_XNXip US0057 2026-03-09T12:06:58.032Z 2026-03-16T12:44:01.442Z
9443000 9443000 20260308081407_7mYL4 US0057 2026-03-09T12:06:23.624Z 2026-03-16T12:43:59.526Z
9393070 9393070 20260225095409_X9iwp US0057 2026-02-26T14:09:20.420Z 2026-03-05T14:37:27.775Z
9384443 9384443 20260224112749_RU4Wm US0057 2026-02-25T14:05:53.120Z 2026-03-04T14:18:09.376Z
9384346 9384346 20260224110604_jAovl US0057 2026-02-25T14:05:32.333Z 2026-03-04T14:18:06.333Z
9384032 9384032 20260224095928_Z31yU US0057 2026-02-25T14:04:18.190Z 2026-03-04T14:17:59.729Z
9383917 9383917 20260224092623_OMksy US0057 2026-02-25T14:03:49.172Z 2026-03-04T14:17:57.757Z
9383864 9383864 20260224091015_e8tSb US0057 2026-02-25T14:03:32.956Z 2026-03-04T14:17:56.611Z
9383736 9383736 20260224082418_tXDGa US0057 2026-02-25T14:02:59.038Z 2026-03-04T14:17:53.961Z
9383678 9383678 20260224073453_li52u US0057 2026-02-25T14:02:41.589Z 2026-03-04T14:17:53.176Z
9383581 9383581 20260224062347_cWgCI US0057 2026-02-25T14:02:14.450Z 2026-03-04T14:17:51.626Z
9383569 9383569 20260224061252_k53pm US0057 2026-02-25T14:02:12.167Z 2026-03-04T14:17:51.462Z
9383417 9383417 20260224041450_FmCya US0057 2026-02-25T14:01:28.372Z 2026-03-04T14:17:48.615Z
9375701 9375701 20260223120943_6ELm0 US0057 2026-02-24T14:09:44.728Z 2026-03-03T14:31:58.556Z
9375325 9375325 20260223111202_f1Hsz US0057 2026-02-24T14:08:42.263Z 2026-03-03T14:31:44.804Z
9375195 9375195 20260223105212_a4Jx1 US0057 2026-02-24T14:08:17.277Z 2026-03-03T14:31:42.293Z
9374873 9374873 20260223100325_nY88E US0057 2026-02-24T14:07:22.226Z 2026-03-03T14:31:37.502Z
9373504 9373504 20260223031841_m5Cz7 US0057 2026-02-24T14:03:09.058Z 2026-03-03T14:31:04.587Z
9366463 9366463 20260222094823_RLOCF US0057 2026-02-23T14:07:40.150Z 2026-02-24T14:16:21.426Z
9366251 9366251 20260222090848_GMSRl US0057 2026-02-23T14:07:01.006Z 2026-02-24T14:16:08.442Z
9366222 9366222 20260222090549_g2jfk US0057 2026-02-23T14:06:55.929Z 2026-02-24T14:16:07.352Z
9366050 9366050 20260222082633_sL0Mm US0057 2026-02-23T14:06:12.064Z 2026-02-24T14:15:57.947Z
9366018 9366018 20260222081414_6yKrr US0057 2026-02-23T14:06:04.853Z 2026-02-24T14:15:54.737Z
9365918 9365918 20260222072601_GANI6 US0057 2026-02-23T14:05:35.940Z 2026-02-24T14:15:46.650Z
9365805 9365805 20260222062029_ACnT4 US0057 2026-02-23T14:05:11.544Z 2026-02-24T14:15:39.860Z
9365652 9365652 20260222051102_TTlE8 US0057 2026-02-23T14:04:26.775Z 2026-02-24T14:15:27.817Z
9365075 9365075 20260222020116_Gt6GF US0057 2026-02-23T14:01:56.991Z 2026-02-24T14:14:49.114Z
9360767 9360767 20260221120233_YfeNf US0057 2026-02-22T14:08:42.479Z 2026-03-02T14:21:31.295Z
9353894 9353894 20260220115107_e6nOc US0057 2026-02-21T14:05:31.789Z 2026-03-01T14:22:08.537Z
9352863 9352863 20260220092454_CPYTA US0057 2026-02-21T14:03:08.313Z 2026-03-01T14:21:43.358Z
9352840 9352840 20260220092223_cc3y3 US0057 2026-02-21T14:03:04.431Z 2026-03-01T14:21:42.930Z
9352808 9352808 20260220091724_iI8xT US0057 2026-02-21T14:03:00.410Z 2026-03-01T14:21:42.593Z

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