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

>10,000 rows count all where station_code = "US005Y" 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
9273484 9273484 20260128063027_AwiQh US005Y 2026-01-29T14:29:59.389Z 2026-01-29T14:30:25.823Z
9273395 9273395 20260128060437_NHH21 US005Y 2026-01-29T14:29:39.519Z 2026-01-29T14:30:25.802Z
9272523 9272523 20260128022854_dIiEJ US005Y 2026-01-29T14:27:05.344Z 2026-01-29T14:30:25.372Z
9267959 9267959 20260127072113_U8v1o US005Y 2026-01-28T14:24:01.439Z 2026-01-29T14:35:59.477Z
9267950 9267950 20260127071122_V83xy US005Y 2026-01-28T14:23:59.638Z 2026-01-29T14:35:58.587Z
9267947 9267947 20260127070649_CAT2f US005Y 2026-01-28T14:23:59.207Z 2026-01-29T14:35:58.322Z
9267940 9267940 20260127070522_6Dgjg US005Y 2026-01-28T14:23:57.894Z 2026-01-29T14:35:57.569Z
9267928 9267928 20260127065632_OaZgj US005Y 2026-01-28T14:23:55.074Z 2026-01-29T14:35:54.570Z
9267918 9267918 20260127065209_oriww US005Y 2026-01-28T14:23:53.060Z 2026-01-29T14:35:53.994Z
9267900 9267900 20260127064359_Tzn0C US005Y 2026-01-28T14:23:49.087Z 2026-01-29T14:35:52.148Z
9267896 9267896 20260127064350_FgMQj US005Y 2026-01-28T14:23:47.548Z 2026-01-29T14:35:51.651Z
9267891 9267891 20260127063328_TajzL US005Y 2026-01-28T14:23:46.581Z 2026-01-29T14:35:51.188Z
9267812 9267812 20260127051222_wXdp2 US005Y 2026-01-28T14:23:24.987Z 2026-01-29T14:35:45.154Z
9267784 9267784 20260127045633_qvgRj US005Y 2026-01-28T14:23:18.009Z 2026-01-29T14:35:42.974Z
9264826 9264826 20260127131857_Tdm2T US005Y 2026-01-28T14:07:52.049Z 2026-01-29T14:30:24.307Z
9264783 9264783 20260127131127_AsAtK US005Y 2026-01-28T14:07:36.800Z 2026-01-29T14:30:24.291Z
9264698 9264698 20260127125809_fQ2NY US005Y 2026-01-28T14:07:13.201Z 2026-01-29T14:30:24.257Z
9264624 9264624 20260127125107_s2Ks7 US005Y 2026-01-28T14:06:56.657Z 2026-01-29T14:30:24.231Z
9264544 9264544 20260127124426_9Y4iY US005Y 2026-01-28T14:06:38.326Z 2026-01-29T14:30:24.208Z
9264542 9264542 20260127124417_Upory US005Y 2026-01-28T14:06:37.825Z 2026-01-29T14:30:24.207Z
9264435 9264435 20260127122113_PMZqg US005Y 2026-01-28T14:06:07.922Z 2026-01-29T14:30:21.707Z
9264418 9264418 20260127121839_p2gc2 US005Y 2026-01-28T14:06:02.653Z 2026-01-29T14:30:21.200Z
9264386 9264386 20260127121107_soiH4 US005Y 2026-01-28T14:05:47.962Z 2026-01-29T14:30:21.192Z
9264314 9264314 20260127120035_ej3b2 US005Y 2026-01-28T14:05:27.657Z 2026-01-29T14:30:20.852Z
9264301 9264301 20260127115821_ku3WO US005Y 2026-01-28T14:05:22.724Z 2026-01-29T14:30:20.848Z
9264288 9264288 20260127115701_voqkT US005Y 2026-01-28T14:05:19.889Z 2026-01-29T14:30:20.578Z
9264256 9264256 20260127114936_x05ee US005Y 2026-01-28T14:05:12.112Z 2026-01-29T14:30:20.570Z
9264243 9264243 20260127114707_Vp2nh US005Y 2026-01-28T14:05:07.250Z 2026-01-29T14:30:20.566Z
9264197 9264197 20260127113620_OXvm3 US005Y 2026-01-28T14:04:55.754Z 2026-01-29T14:30:20.539Z
9264190 9264190 20260127113521_0IzB9 US005Y 2026-01-28T14:04:54.453Z 2026-01-29T14:30:20.538Z
9264184 9264184 20260127113438_HtGm2 US005Y 2026-01-28T14:04:52.452Z 2026-01-29T14:30:20.535Z
9264182 9264182 20260127113320_RkiUb US005Y 2026-01-28T14:04:51.633Z 2026-01-29T14:30:20.535Z
9264142 9264142 20260127112028_XO9hR US005Y 2026-01-28T14:04:36.874Z 2026-01-29T14:30:20.072Z
9264092 9264092 20260127111409_FHwix US005Y 2026-01-28T14:04:22.318Z 2026-01-29T14:30:20.050Z
9264079 9264079 20260127111130_fNJBS US005Y 2026-01-28T14:04:17.681Z 2026-01-29T14:30:20.045Z
9264024 9264024 20260127105928_A2317 US005Y 2026-01-28T14:03:59.686Z 2026-01-29T14:30:20.004Z
9263986 9263986 20260127104912_mnIJk US005Y 2026-01-28T14:03:47.049Z 2026-01-29T14:30:19.985Z
9263912 9263912 20260127104049_wPArJ US005Y 2026-01-28T14:03:30.209Z 2026-01-29T14:30:19.967Z
9263905 9263905 20260127104020_uLc0X US005Y 2026-01-28T14:03:28.703Z 2026-01-29T14:30:19.958Z
9263863 9263863 20260127102400_kG7Q3 US005Y 2026-01-28T14:03:12.862Z 2026-01-29T14:30:19.509Z
9263836 9263836 20260127102037_Cn026 US005Y 2026-01-28T14:03:05.054Z 2026-01-29T14:30:18.960Z
9263812 9263812 20260127101639_3mJYP US005Y 2026-01-28T14:02:55.466Z 2026-01-29T14:30:18.947Z
9263766 9263766 20260127100901_lXV89 US005Y 2026-01-28T14:02:40.499Z 2026-01-29T14:30:18.931Z
9263738 9263738 20260127100208_mz3lx US005Y 2026-01-28T14:02:32.636Z 2026-01-29T14:30:18.923Z
9263714 9263714 20260127095421_mgABw US005Y 2026-01-28T14:02:24.573Z 2026-01-29T14:30:18.035Z
9263686 9263686 20260127094916_1TZbW US005Y 2026-01-28T14:02:15.058Z 2026-01-29T14:30:18.029Z
9263657 9263657 20260127093727_t0yRT US005Y 2026-01-28T14:02:01.955Z 2026-01-29T14:30:17.617Z
9263648 9263648 20260127093548_oVIuq US005Y 2026-01-28T14:01:58.425Z 2026-01-29T14:30:17.613Z
9263624 9263624 20260127092852_wDLLe US005Y 2026-01-28T14:01:47.991Z 2026-01-29T14:30:16.599Z
9263537 9263537 20260127090411_DIOrO US005Y 2026-01-28T14:01:15.829Z 2026-01-29T14:30:16.555Z
9263511 9263511 20260127084631_XUidf US005Y 2026-01-28T14:01:05.104Z 2026-01-29T14:30:16.547Z
9263485 9263485 20260127083458_KF97R US005Y 2026-01-28T14:00:55.164Z 2026-01-29T14:30:16.524Z
9263469 9263469 20260127081831_Cc4GR US005Y 2026-01-28T14:00:48.294Z 2026-01-29T14:30:16.519Z
9263444 9263444 20260127080155_zKqKK US005Y 2026-01-28T14:00:37.368Z 2026-01-29T14:30:16.506Z
9263440 9263440 20260127075833_RMSKN US005Y 2026-01-28T14:00:35.203Z 2026-01-29T14:30:16.505Z
9263412 9263412 20260127073953_mHTRG US005Y 2026-01-28T14:00:21.614Z 2026-01-29T14:30:16.490Z
9263132 9263132 20260126073520_cCZRx US005Y 2026-01-27T14:17:09.490Z 2026-01-29T14:39:18.496Z
9263102 9263102 20260126071800_QiGi7 US005Y 2026-01-27T14:17:03.613Z 2026-01-29T14:39:16.637Z
9263091 9263091 20260126070535_DMKWs US005Y 2026-01-27T14:16:57.033Z 2026-01-29T14:39:16.070Z
9263046 9263046 20260126064631_s6mn6 US005Y 2026-01-27T14:16:45.448Z 2026-01-29T14:39:11.798Z
9263042 9263042 20260126064111_AVu2e US005Y 2026-01-27T14:16:44.217Z 2026-01-29T14:39:11.439Z
9262989 9262989 20260126055347_4PDn2 US005Y 2026-01-27T14:16:24.755Z 2026-01-29T14:39:08.148Z
9262945 9262945 20260126052049_FYbDh US005Y 2026-01-27T14:16:13.875Z 2026-01-29T14:39:05.396Z
9262869 9262869 20260126040312_CBiMc US005Y 2026-01-27T14:15:48.675Z 2026-01-29T14:38:57.652Z
9262825 9262825 20260126033406_nRiPQ US005Y 2026-01-27T14:15:35.732Z 2026-01-29T14:38:50.904Z
9261808 9261808 20260126133231_LDgNc US005Y 2026-01-27T14:05:45.454Z 2026-01-29T14:33:04.346Z
9261798 9261798 20260126132513_EUJR4 US005Y 2026-01-27T14:05:42.858Z 2026-01-29T14:33:03.405Z
9261631 9261631 20260126123458_1ietI US005Y 2026-01-27T14:04:47.150Z 2026-01-29T14:32:44.961Z
9261617 9261617 20260126123305_0s3Kh US005Y 2026-01-27T14:04:44.617Z 2026-01-29T14:32:44.152Z
9261558 9261558 20260126121407_SM51w US005Y 2026-01-27T14:04:21.074Z 2026-01-29T14:32:39.823Z
9261548 9261548 20260126121349_EtfeI US005Y 2026-01-27T14:04:18.663Z 2026-01-29T14:32:39.224Z
9261521 9261521 20260126120651_6YFN7 US005Y 2026-01-27T14:04:11.323Z 2026-01-29T14:32:37.632Z
9261519 9261519 20260126120629_wLMkd US005Y 2026-01-27T14:04:10.580Z 2026-01-29T14:32:37.487Z
9261443 9261443 20260126114149_8K90j US005Y 2026-01-27T14:03:44.725Z 2026-01-29T14:32:24.987Z
9261417 9261417 20260126113139_vvalA US005Y 2026-01-27T14:03:39.963Z 2026-01-29T14:32:23.670Z
9261390 9261390 20260126112311_26F5O US005Y 2026-01-27T14:03:33.307Z 2026-01-29T14:32:15.678Z
9261280 9261280 20260126105757_nQzSd US005Y 2026-01-27T14:02:59.752Z 2026-01-29T14:32:09.775Z
9261270 9261270 20260126105500_n346K US005Y 2026-01-27T14:02:56.534Z 2026-01-29T14:32:09.209Z
9261243 9261243 20260126104526_x0Z9w US005Y 2026-01-27T14:02:47.503Z 2026-01-29T14:32:07.141Z
9260979 9260979 20260126090928_zC6ih US005Y 2026-01-27T14:01:14.263Z 2026-01-29T14:31:17.140Z
9260975 9260975 20260126090856_2OlPI US005Y 2026-01-27T14:01:13.529Z 2026-01-29T14:31:16.972Z
9260930 9260930 20260126084829_rCg4n US005Y 2026-01-27T14:00:56.247Z 2026-01-29T14:31:14.358Z
9260919 9260919 20260126084210_AiuDx US005Y 2026-01-27T14:00:51.333Z 2026-01-29T14:31:13.746Z
9260914 9260914 20260126083818_r5LJf US005Y 2026-01-27T14:00:49.193Z 2026-01-29T14:31:13.415Z
9260860 9260860 20260126082034_ln2ct US005Y 2026-01-27T14:00:32.314Z 2026-01-29T14:31:01.399Z
9260816 9260816 20260126075848_VUdpS US005Y 2026-01-27T14:00:20.148Z 2026-01-29T14:30:36.855Z
9260728 9260728 20260125075056_rY3sw US005Y 2026-01-26T14:23:10.107Z 2026-01-29T14:44:38.021Z
9260724 9260724 20260125074035_3FKhn US005Y 2026-01-26T14:23:09.744Z 2026-01-29T14:44:37.908Z
9260721 9260721 20260125073823_AUKzH US005Y 2026-01-26T14:23:09.359Z 2026-01-29T14:44:37.759Z
9260703 9260703 20260125072414_wU3Sm US005Y 2026-01-26T14:23:06.232Z 2026-01-29T14:44:36.625Z
9260696 9260696 20260125071817_Qg3t7 US005Y 2026-01-26T14:23:04.542Z 2026-01-29T14:44:36.133Z
9260687 9260687 20260125070839_ebkvQ US005Y 2026-01-26T14:23:03.121Z 2026-01-29T14:44:35.651Z
9260679 9260679 20260125065709_7puSE US005Y 2026-01-26T14:23:01.567Z 2026-01-29T14:44:35.338Z
9260646 9260646 20260125061755_tMSMZ US005Y 2026-01-26T14:22:46.687Z 2026-01-29T14:44:33.365Z
9260640 9260640 20260125061227_8ruuy US005Y 2026-01-26T14:22:42.472Z 2026-01-29T14:44:32.963Z
9260580 9260580 20260125053701_GOhhg US005Y 2026-01-26T14:22:27.785Z 2026-01-29T14:44:28.658Z
9260476 9260476 20260125044335_klkIg US005Y 2026-01-26T14:21:56.313Z 2026-01-29T14:44:17.277Z
9260431 9260431 20260125042237_w03UG US005Y 2026-01-26T14:21:48.115Z 2026-01-29T14:44:12.562Z
9260407 9260407 20260125041612_u3PyQ US005Y 2026-01-26T14:21:35.817Z 2026-01-29T14:44:10.916Z
9257445 9257445 20260125133756_TTbKT US005Y 2026-01-26T14:05:39.607Z 2026-01-29T14:37:12.730Z

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