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

8,400 rows where station_code = "US002X" 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
9268039 9268039 20260128081215_7aDDk US002X 2026-01-29T14:00:39.783Z 2026-01-29T14:00:39.783Z
9267975 9267975 20260128070407_ZHxNs US002X 2026-01-29T14:00:08.895Z 2026-01-29T14:00:08.895Z
9267934 9267934 20260127065957_e3az4 US002X 2026-01-28T14:23:56.585Z 2026-01-29T14:35:55.170Z
9264237 9264237 20260127114601_LMUKa US002X 2026-01-28T14:05:05.022Z 2026-01-29T14:30:20.556Z
9264235 9264235 20260127114548_NmgI5 US002X 2026-01-28T14:05:04.356Z 2026-01-29T14:30:20.555Z
9264214 9264214 20260127114109_uTcE3 US002X 2026-01-28T14:04:59.347Z 2026-01-29T14:30:20.552Z
9264166 9264166 20260127112956_0BDKL US002X 2026-01-28T14:04:46.482Z 2026-01-29T14:30:20.510Z
9264138 9264138 20260127112021_Fsetp US002X 2026-01-28T14:04:34.890Z 2026-01-29T14:30:20.071Z
9263810 9263810 20260127101553_ik2Tg US002X 2026-01-28T14:02:54.622Z 2026-01-29T14:30:18.946Z
9263654 9263654 20260127093716_nSkP3 US002X 2026-01-28T14:02:01.062Z 2026-01-29T14:30:17.617Z
9263635 9263635 20260127093126_lAB7Q US002X 2026-01-28T14:01:53.608Z 2026-01-29T14:30:16.609Z
9263628 9263628 20260127093052_XZRcB US002X 2026-01-28T14:01:50.788Z 2026-01-29T14:30:16.601Z
9263551 9263551 20260127091046_tYUuf US002X 2026-01-28T14:01:21.942Z 2026-01-29T14:30:16.567Z
9249818 9249818 20260122090203_CxMfh US002X 2026-01-23T14:16:18.586Z 2026-01-29T14:58:59.326Z
9249712 9249712 20260122072801_3FTwZ US002X 2026-01-23T14:15:59.494Z 2026-01-29T14:58:50.990Z
9249616 9249616 20260122060634_mvwS6 US002X 2026-01-23T14:15:48.024Z 2026-01-29T14:58:46.991Z
9245379 9245379 20260122120452_gdUwV US002X 2026-01-23T14:01:46.327Z 2026-01-29T14:49:29.462Z
9245348 9245348 20260122115523_dSjeT US002X 2026-01-23T14:01:39.978Z 2026-01-29T14:49:25.287Z
9245262 9245262 20260122113034_5vOjL US002X 2026-01-23T14:01:14.760Z 2026-01-29T14:49:19.264Z
9245117 9245117 20260122101723_9O28i US002X 2026-01-23T14:00:40.529Z 2026-01-29T14:49:02.627Z
9245096 9245096 20260122100933_ZphUh US002X 2026-01-23T14:00:31.701Z 2026-01-29T14:49:00.908Z
9245085 9245085 20260122100031_ILXFO US002X 2026-01-23T14:00:27.628Z 2026-01-29T14:48:57.024Z
9245026 9245026 20260122092516_2DhDL US002X 2026-01-23T14:00:10.907Z 2026-01-29T14:48:52.153Z
9238567 9238567 20260120090358_m7UOo US002X 2026-01-21T14:29:58.197Z 2026-01-28T15:02:39.053Z
9238538 9238538 20260120085522_HFdFJ US002X 2026-01-21T14:29:54.733Z 2026-01-28T15:02:37.672Z
9238536 9238536 20260120085454_LAPAj US002X 2026-01-21T14:29:54.340Z 2026-01-28T15:02:37.535Z
9238527 9238527 20260120085237_cZIZU US002X 2026-01-21T14:29:53.491Z 2026-01-28T15:02:37.172Z
9238258 9238258 20260120081145_OsCo4 US002X 2026-01-21T14:29:02.912Z 2026-01-28T15:02:16.322Z
9238245 9238245 20260120080821_S54k8 US002X 2026-01-21T14:28:59.991Z 2026-01-28T15:02:15.701Z
9238113 9238113 20260120072605_TCtxC US002X 2026-01-21T14:28:43.056Z 2026-01-28T15:02:07.911Z
9238112 9238112 20260120072457_qh30x US002X 2026-01-21T14:28:42.698Z 2026-01-28T15:02:07.785Z
9237998 9237998 20260120065248_3uOup US002X 2026-01-21T14:28:14.307Z 2026-01-28T15:02:02.418Z
9237779 9237779 20260120060332_0L9LR US002X 2026-01-21T14:27:37.455Z 2026-01-28T15:01:41.697Z
9237337 9237337 20260120050529_oqZTO US002X 2026-01-21T14:26:01.397Z 2026-01-28T15:01:20.282Z
9237011 9237011 20260120042738_ON6u6 US002X 2026-01-21T14:24:56.971Z 2026-01-28T15:00:53.738Z
9236916 9236916 20260120041855_5oJkb US002X 2026-01-21T14:24:29.597Z 2026-01-28T15:00:48.755Z
9236902 9236902 20260120041620_f94wV US002X 2026-01-21T14:24:28.275Z 2026-01-28T15:00:47.276Z
9236511 9236511 20260120032908_VDPwr US002X 2026-01-21T14:23:01.362Z 2026-01-28T15:00:06.346Z
9232835 9232835 20260120123439_SnCNP US002X 2026-01-21T14:03:23.725Z 2026-01-29T15:00:18.668Z
9232790 9232790 20260120122832_4gCd3 US002X 2026-01-21T14:03:16.712Z 2026-01-29T15:00:14.420Z
9232778 9232778 20260120122721_I0FJT US002X 2026-01-21T14:03:13.779Z 2026-01-29T15:00:04.426Z
9232537 9232537 20260120114533_E3xPS US002X 2026-01-21T14:02:16.587Z 2026-01-29T14:59:49.270Z
9232445 9232445 20260120112917_2G8La US002X 2026-01-21T14:01:54.209Z 2026-01-29T14:59:42.915Z
9232188 9232188 20260120103941_nUgzX US002X 2026-01-21T14:00:43.440Z 2026-01-29T14:59:18.899Z
9232156 9232156 20260120103203_F2GYm US002X 2026-01-21T14:00:35.408Z 2026-01-29T14:59:16.769Z
9232063 9232063 20260120101614_aZh2G US002X 2026-01-21T14:00:10.532Z 2026-01-29T14:59:04.967Z
9232016 9232016 20260119104041_uSyVi US002X 2026-01-20T14:35:11.239Z 2026-01-27T15:07:12.573Z
9231987 9231987 20260119103433_ja9WZ US002X 2026-01-20T14:35:01.650Z 2026-01-27T15:07:09.640Z
9231960 9231960 20260119102625_xTVB1 US002X 2026-01-20T14:34:55.391Z 2026-01-27T15:07:08.058Z
9231952 9231952 20260119102046_IpBaM US002X 2026-01-20T14:34:53.279Z 2026-01-27T15:07:07.321Z
9231850 9231850 20260119100351_IaCqg US002X 2026-01-20T14:34:31.634Z 2026-01-27T15:07:02.437Z
9231814 9231814 20260119095722_bGIul US002X 2026-01-20T14:34:24.879Z 2026-01-27T15:07:00.833Z
9231714 9231714 20260119093743_9YDFh US002X 2026-01-20T14:34:01.219Z 2026-01-27T15:06:56.589Z
9231683 9231683 20260119092907_QTyGu US002X 2026-01-20T14:33:54.427Z 2026-01-27T15:06:52.620Z
9231666 9231666 20260119091742_EU9kd US002X 2026-01-20T14:33:49.742Z 2026-01-27T15:06:43.455Z
9231642 9231642 20260119091333_QeOqD US002X 2026-01-20T14:33:43.810Z 2026-01-27T15:06:42.114Z
9231601 9231601 20260119090041_7Vxca US002X 2026-01-20T14:33:30.704Z 2026-01-27T15:06:39.679Z
9231492 9231492 20260119082216_hfw22 US002X 2026-01-20T14:33:03.525Z 2026-01-27T15:06:32.539Z
9231404 9231404 20260119075425_nHKLh US002X 2026-01-20T14:32:39.578Z 2026-01-27T15:06:28.061Z
9231347 9231347 20260119072631_H3hXh US002X 2026-01-20T14:32:26.880Z 2026-01-27T15:06:25.209Z
9231325 9231325 20260119072224_VhKcp US002X 2026-01-20T14:32:22.172Z 2026-01-27T15:06:23.859Z
9231317 9231317 20260119071738_SQOZZ US002X 2026-01-20T14:32:20.184Z 2026-01-27T15:06:23.295Z
9231228 9231228 20260119064003_fwJJt US002X 2026-01-20T14:31:55.527Z 2026-01-27T15:06:07.954Z
9231185 9231185 20260119062701_VWV5M US002X 2026-01-20T14:31:47.415Z 2026-01-27T15:06:04.269Z
9231129 9231129 20260119060853_tWwIt US002X 2026-01-20T14:31:27.124Z 2026-01-27T15:06:00.148Z
9230751 9230751 20260119050053_RJp8g US002X 2026-01-20T14:29:35.528Z 2026-01-27T15:05:24.209Z
9230532 9230532 20260119043056_TZiki US002X 2026-01-20T14:28:24.838Z 2026-01-27T15:05:01.646Z
9230500 9230500 20260119042738_mUtAh US002X 2026-01-20T14:28:11.490Z 2026-01-27T15:04:59.798Z
9226557 9226557 20260119122004_04P4I US002X 2026-01-20T14:03:54.275Z 2026-01-28T14:55:14.519Z
9226245 9226245 20260119113320_bg7sT US002X 2026-01-20T14:02:01.931Z 2026-01-28T14:54:50.181Z
9226177 9226177 20260119112351_0RkKo US002X 2026-01-20T14:01:40.669Z 2026-01-28T14:54:47.169Z
9226156 9226156 20260119111924_iwooG US002X 2026-01-20T14:01:32.213Z 2026-01-28T14:54:45.351Z
9226036 9226036 20260119105232_WF0al US002X 2026-01-20T14:00:35.705Z 2026-01-28T14:54:29.852Z
9226022 9226022 20260119104902_xxIIR US002X 2026-01-20T14:00:27.630Z 2026-01-28T14:54:29.107Z
9225793 9225793 20260118105806_JieXB US002X 2026-01-19T14:30:17.333Z 2026-01-26T15:04:45.152Z
9225782 9225782 20260118105542_Hi5sr US002X 2026-01-19T14:30:10.527Z 2026-01-26T15:04:44.843Z
9225772 9225772 20260118105335_PBnXB US002X 2026-01-19T14:30:08.092Z 2026-01-26T15:04:44.499Z
9225570 9225570 20260118101442_65plP US002X 2026-01-19T14:29:26.766Z 2026-01-26T15:04:38.482Z
9225479 9225479 20260118095602_39QY9 US002X 2026-01-19T14:29:05.095Z 2026-01-26T15:04:35.937Z
9225388 9225388 20260118093433_xc4nQ US002X 2026-01-19T14:28:50.963Z 2026-01-26T15:04:32.949Z
9225377 9225377 20260118093138_ga42x US002X 2026-01-19T14:28:48.445Z 2026-01-26T15:04:32.342Z
9225323 9225323 20260118091020_Cblyc US002X 2026-01-19T14:28:30.667Z 2026-01-26T15:04:30.578Z
9225320 9225320 20260118090943_eRl3v US002X 2026-01-19T14:28:30.196Z 2026-01-26T15:04:30.479Z
9225249 9225249 20260118085127_2Z1k8 US002X 2026-01-19T14:28:15.491Z 2026-01-26T15:04:13.416Z
9225147 9225147 20260118082139_LHHX3 US002X 2026-01-19T14:27:49.280Z 2026-01-26T15:04:06.447Z
9224975 9224975 20260118070413_b9Tru US002X 2026-01-19T14:27:03.419Z 2026-01-26T15:03:57.072Z
9224747 9224747 20260118055903_chXH8 US002X 2026-01-19T14:25:50.924Z 2026-01-26T15:03:47.656Z
9224718 9224718 20260118054950_laHIq US002X 2026-01-19T14:25:42.325Z 2026-01-26T15:03:46.607Z
9224707 9224707 20260118054608_WlvSp US002X 2026-01-19T14:25:39.776Z 2026-01-26T15:03:46.274Z
9224220 9224220 20260118035608_TUJRk US002X 2026-01-19T14:23:27.291Z 2026-01-26T15:03:09.379Z
9223573 9223573 20260118012819_KPrvq US002X 2026-01-19T14:20:00.758Z 2026-01-26T15:02:15.069Z
9223452 9223452 20260118004856_GF32o US002X 2026-01-19T14:19:23.866Z 2026-01-26T15:02:07.396Z
9220123 9220123 20260118120919_rRqJS US002X 2026-01-19T14:02:50.770Z 2026-01-27T14:58:50.880Z
9220008 9220008 20260118114903_H2njo US002X 2026-01-19T14:02:08.609Z 2026-01-27T14:58:45.190Z
9219772 9219772 20260118111622_d33UX US002X 2026-01-19T14:00:42.240Z 2026-01-27T14:58:30.344Z
9219121 9219121 20260117080507_TiVcm US002X 2026-01-18T14:15:04.113Z 2026-01-25T14:59:02.467Z
9219102 9219102 20260117075704_5n6Bk US002X 2026-01-18T14:14:59.832Z 2026-01-25T14:59:01.895Z
9219070 9219070 20260117072734_2GjJr US002X 2026-01-18T14:14:51.295Z 2026-01-25T14:59:00.763Z
9219054 9219054 20260117071550_s7DkQ US002X 2026-01-18T14:14:45.473Z 2026-01-25T14:58:59.828Z
9218985 9218985 20260117065207_DV9AB US002X 2026-01-18T14:14:30.387Z 2026-01-25T14:58:57.455Z

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