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

3,842 rows where station_code = "US0061" 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
9272521 9272521 20260128022509_5sXus US0061 2026-01-29T14:27:04.674Z 2026-01-29T14:30:25.371Z
9267808 9267808 20260127050813_HcHlj US0061 2026-01-28T14:23:23.908Z 2026-01-29T14:35:44.829Z
9264851 9264851 20260127132425_OkbOx US0061 2026-01-28T14:07:59.583Z 2026-01-29T14:30:24.313Z
9264397 9264397 20260127121239_edrgA US0061 2026-01-28T14:05:51.129Z 2026-01-29T14:30:21.195Z
9264364 9264364 20260127120658_q42L7 US0061 2026-01-28T14:05:41.628Z 2026-01-29T14:30:20.877Z
9264342 9264342 20260127120351_VT9k9 US0061 2026-01-28T14:05:35.225Z 2026-01-29T14:30:20.859Z
9264262 9264262 20260127115218_Al96a US0061 2026-01-28T14:05:13.426Z 2026-01-29T14:30:20.571Z
9264163 9264163 20260127112809_6jTPC US0061 2026-01-28T14:04:44.580Z 2026-01-29T14:30:20.508Z
9264089 9264089 20260127111245_7qsaA US0061 2026-01-28T14:04:20.083Z 2026-01-29T14:30:20.048Z
9263935 9263935 20260127104421_UZP03 US0061 2026-01-28T14:03:35.087Z 2026-01-29T14:30:19.972Z
9263815 9263815 20260127101751_plcRP US0061 2026-01-28T14:02:56.281Z 2026-01-29T14:30:18.947Z
9263593 9263593 20260127092200_GeoEi US0061 2026-01-28T14:01:37.918Z 2026-01-29T14:30:16.585Z
9263492 9263492 20260127083647_jZ6zg US0061 2026-01-28T14:00:57.239Z 2026-01-29T14:30:16.525Z
9263456 9263456 20260127081215_u3DCo US0061 2026-01-28T14:00:41.981Z 2026-01-29T14:30:16.509Z
9263447 9263447 20260127080419_n8U8K US0061 2026-01-28T14:00:38.507Z 2026-01-29T14:30:16.507Z
9263436 9263436 20260127075804_k1J23 US0061 2026-01-28T14:00:34.184Z 2026-01-29T14:30:16.504Z
9263061 9263061 20260126065456_yaeB0 US0061 2026-01-27T14:16:48.137Z 2026-01-29T14:39:12.445Z
9262964 9262964 20260126053220_AbtNQ US0061 2026-01-27T14:16:17.195Z 2026-01-29T14:39:06.536Z
9261277 9261277 20260126105732_K4m2o US0061 2026-01-27T14:02:58.098Z 2026-01-29T14:32:09.536Z
9261032 9261032 20260126093317_Yp2LL US0061 2026-01-27T14:01:31.159Z 2026-01-29T14:31:29.998Z
9260926 9260926 20260126084719_zPRCm US0061 2026-01-27T14:00:53.498Z 2026-01-29T14:31:14.064Z
9260863 9260863 20260126082441_fR2dA US0061 2026-01-27T14:00:33.558Z 2026-01-29T14:31:02.145Z
9260716 9260716 20260125073521_jgFPa US0061 2026-01-26T14:23:08.671Z 2026-01-29T14:44:37.491Z
9257430 9257430 20260125133237_Sz2Su US0061 2026-01-26T14:05:35.290Z 2026-01-29T14:37:11.973Z
9257418 9257418 20260125132951_afCuR US0061 2026-01-26T14:05:31.268Z 2026-01-29T14:37:11.269Z
9257316 9257316 20260125124536_qUPNj US0061 2026-01-26T14:04:41.633Z 2026-01-29T14:37:05.147Z
9257308 9257308 20260125124411_2gyzN US0061 2026-01-26T14:04:39.528Z 2026-01-29T14:37:04.674Z
9257236 9257236 20260125122952_APS0P US0061 2026-01-26T14:04:18.667Z 2026-01-29T14:37:00.772Z
9257104 9257104 20260125115311_DPoB1 US0061 2026-01-26T14:03:40.492Z 2026-01-29T14:36:46.698Z
9256888 9256888 20260125105800_LsjIU US0061 2026-01-26T14:02:33.408Z 2026-01-29T14:36:34.292Z
9256681 9256681 20260125095832_tKXWZ US0061 2026-01-26T14:01:20.421Z 2026-01-29T14:36:16.014Z
9256649 9256649 20260125094651_BOGYM US0061 2026-01-26T14:01:09.940Z 2026-01-29T14:36:14.029Z
9256607 9256607 20260125092713_sfAYy US0061 2026-01-26T14:00:55.986Z 2026-01-29T14:36:11.780Z
9256557 9256557 20260125084628_cLYLk US0061 2026-01-26T14:00:30.951Z 2026-01-29T14:36:08.151Z
9256540 9256540 20260125083751_9MKw2 US0061 2026-01-26T14:00:25.477Z 2026-01-29T14:36:07.202Z
9256512 9256512 20260125081557_YEVm7 US0061 2026-01-26T14:00:13.719Z 2026-01-29T14:36:02.053Z
9256409 9256409 20260124081835_NK1OY US0061 2026-01-25T14:16:57.687Z 2026-01-29T14:48:48.070Z
9256021 9256021 20260124054438_mRRaC US0061 2026-01-25T14:15:35.160Z 2026-01-29T14:48:18.692Z
9255703 9255703 20260124043628_czxtS US0061 2026-01-25T14:14:26.788Z 2026-01-29T14:47:53.045Z
9253404 9253404 20260124113300_E9w5r US0061 2026-01-25T14:02:33.879Z 2026-01-29T14:40:47.150Z
9244322 9244322 20260121073645_XuUTl US0061 2026-01-22T14:25:09.542Z 2026-01-29T15:06:01.331Z
9244210 9244210 20260121064757_P2sjA US0061 2026-01-22T14:24:36.997Z 2026-01-29T15:05:56.012Z
9242929 9242929 20260121031711_BOvLE US0061 2026-01-22T14:19:53.218Z 2026-01-29T15:04:30.332Z
9239775 9239775 20260121122029_0g7jA US0061 2026-01-22T14:03:05.185Z 2026-01-29T14:54:40.976Z
9239650 9239650 20260121113121_QH70N US0061 2026-01-22T14:02:25.931Z 2026-01-29T14:54:33.625Z
9239635 9239635 20260121112609_ONFlu US0061 2026-01-22T14:02:20.521Z 2026-01-29T14:54:33.003Z
9239600 9239600 20260121111454_dnUBI US0061 2026-01-22T14:02:07.811Z 2026-01-29T14:54:31.310Z
9239391 9239391 20260121103857_DublD US0061 2026-01-22T14:01:17.013Z 2026-01-29T14:54:13.022Z
9238711 9238711 20260120093720_IaNAz US0061 2026-01-21T14:30:26.515Z 2026-01-28T15:02:47.207Z
9238668 9238668 20260120092514_1nD3O US0061 2026-01-21T14:30:11.182Z 2026-01-28T15:02:43.529Z
9238406 9238406 20260120083515_GQ4GW US0061 2026-01-21T14:29:30.824Z 2026-01-28T15:02:32.408Z
9238279 9238279 20260120081523_XEQdv US0061 2026-01-21T14:29:05.522Z 2026-01-28T15:02:17.786Z
9238229 9238229 20260120080452_Bs92W US0061 2026-01-21T14:28:58.092Z 2026-01-28T15:02:15.017Z
9238137 9238137 20260120073437_Jzb8l US0061 2026-01-21T14:28:46.594Z 2026-01-28T15:02:09.451Z
9238088 9238088 20260120071736_hd4nJ US0061 2026-01-21T14:28:29.693Z 2026-01-28T15:02:06.811Z
9235788 9235788 20260120015915_WZRta US0061 2026-01-21T14:20:14.942Z 2026-01-28T14:59:20.887Z
9232873 9232873 20260120124413_glBT8 US0061 2026-01-21T14:03:37.709Z 2026-01-29T15:00:21.750Z
9232858 9232858 20260120124217_Z4o1g US0061 2026-01-21T14:03:29.892Z 2026-01-29T15:00:20.842Z
9232848 9232848 20260120123757_wXNke US0061 2026-01-21T14:03:27.423Z 2026-01-29T15:00:19.811Z
9232506 9232506 20260120114013_X2J4v US0061 2026-01-21T14:02:05.636Z 2026-01-29T14:59:47.587Z
9232295 9232295 20260120105919_xualT US0061 2026-01-21T14:01:09.640Z 2026-01-29T14:59:23.987Z
9232289 9232289 20260120105907_tp3aL US0061 2026-01-21T14:01:08.935Z 2026-01-29T14:59:23.880Z
9232276 9232276 20260120105650_SoyHR US0061 2026-01-21T14:01:04.753Z 2026-01-29T14:59:22.693Z
9232274 9232274 20260120105603_9j8Bw US0061 2026-01-21T14:01:03.950Z 2026-01-29T14:59:22.578Z
9231910 9231910 20260119101403_PkYtv US0061 2026-01-20T14:34:45.649Z 2026-01-27T15:07:05.230Z
9231886 9231886 20260119100938_vMjC7 US0061 2026-01-20T14:34:42.580Z 2026-01-27T15:07:04.187Z
9231805 9231805 20260119095545_VsBln US0061 2026-01-20T14:34:22.917Z 2026-01-27T15:07:00.427Z
9231787 9231787 20260119095201_2YBw4 US0061 2026-01-20T14:34:19.998Z 2026-01-27T15:06:59.626Z
9231738 9231738 20260119094332_vXCPT US0061 2026-01-20T14:34:08.531Z 2026-01-27T15:06:57.617Z
9231620 9231620 20260119090624_zJTWH US0061 2026-01-20T14:33:35.664Z 2026-01-27T15:06:41.023Z
9231407 9231407 20260119075428_T1mlX US0061 2026-01-20T14:32:40.107Z 2026-01-27T15:06:28.161Z
9231379 9231379 20260119074303_kOev9 US0061 2026-01-20T14:32:33.559Z 2026-01-27T15:06:26.858Z
9231277 9231277 20260119070126_noWxZ US0061 2026-01-20T14:32:08.258Z 2026-01-27T15:06:11.278Z
9231116 9231116 20260119060626_21OZ2 US0061 2026-01-20T14:31:23.688Z 2026-01-27T15:05:59.341Z
9231073 9231073 20260119055629_aeLOL US0061 2026-01-20T14:31:08.252Z 2026-01-27T15:05:56.558Z
9226954 9226954 20260119133922_8AsM2 US0061 2026-01-20T14:05:50.807Z 2026-01-28T14:55:43.779Z
9226250 9226250 20260119113328_YtmGB US0061 2026-01-20T14:02:03.538Z 2026-01-28T14:54:50.384Z
9226227 9226227 20260119113114_36ESg US0061 2026-01-20T14:01:58.266Z 2026-01-28T14:54:49.594Z
9226075 9226075 20260119110135_vDbG0 US0061 2026-01-20T14:00:57.558Z 2026-01-28T14:54:33.447Z
9225769 9225769 20260118105256_K8HQ7 US0061 2026-01-19T14:30:07.197Z 2026-01-26T15:04:44.340Z
9225444 9225444 20260118094618_FIVos US0061 2026-01-19T14:28:58.371Z 2026-01-26T15:04:34.501Z
9225420 9225420 20260118094213_3w2HN US0061 2026-01-19T14:28:54.971Z 2026-01-26T15:04:33.809Z
9225123 9225123 20260118080055_W89q6 US0061 2026-01-19T14:27:44.976Z 2026-01-26T15:04:05.472Z
9225085 9225085 20260118073031_rpofH US0061 2026-01-19T14:27:28.994Z 2026-01-26T15:04:01.154Z
9225071 9225071 20260118072736_8kEkX US0061 2026-01-19T14:27:25.947Z 2026-01-26T15:04:00.710Z
9225059 9225059 20260118072358_ufcb4 US0061 2026-01-19T14:27:23.951Z 2026-01-26T15:04:00.231Z
9224798 9224798 20260118060504_pdM37 US0061 2026-01-19T14:26:04.721Z 2026-01-26T15:03:49.361Z
9220612 9220612 20260118131354_bo2jn US0061 2026-01-19T14:04:55.577Z 2026-01-27T14:59:22.228Z
9220512 9220512 20260118130356_CRwrU US0061 2026-01-19T14:04:31.106Z 2026-01-27T14:59:18.550Z
9220498 9220498 20260118130005_VYX3Q US0061 2026-01-19T14:04:26.981Z 2026-01-27T14:59:17.583Z
9220241 9220241 20260118122338_gw6oe US0061 2026-01-19T14:03:24.255Z 2026-01-27T14:58:56.272Z
9220135 9220135 20260118121224_yHgKo US0061 2026-01-19T14:02:54.364Z 2026-01-27T14:58:51.817Z
9219524 9219524 20260117105230_vM3ra US0061 2026-01-18T14:16:50.642Z 2026-01-25T14:59:30.710Z
9219162 9219162 20260117083436_3QQAn US0061 2026-01-18T14:15:17.832Z 2026-01-25T14:59:04.416Z
9219072 9219072 20260117073225_wxSeI US0061 2026-01-18T14:14:51.810Z 2026-01-25T14:59:00.805Z
9218967 9218967 20260117064651_OImGh US0061 2026-01-18T14:14:25.370Z 2026-01-25T14:58:56.814Z
9218894 9218894 20260117062157_g2pw3 US0061 2026-01-18T14:14:06.446Z 2026-01-25T14:58:54.750Z
9216742 9216742 20260117125249_nJeIc US0061 2026-01-18T14:02:21.740Z 2026-01-26T14:59:25.681Z
9216713 9216713 20260117124322_2V6Z8 US0061 2026-01-18T14:02:12.498Z 2026-01-26T14:59:24.848Z
9216557 9216557 20260117121217_rVB59 US0061 2026-01-18T14:01:21.553Z 2026-01-26T14:59:18.787Z

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