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 = "US0005" 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
9273502 9273502 20260128064426_8Ft6G US0005 2026-01-29T14:30:02.157Z 2026-01-29T14:30:25.826Z
9273263 9273263 20260128052038_Mpkmy US0005 2026-01-29T14:29:14.206Z 2026-01-29T14:30:25.779Z
9273250 9273250 20260128051613_9ZgdK US0005 2026-01-29T14:29:12.271Z 2026-01-29T14:30:25.776Z
9273102 9273102 20260128044425_3CTO5 US0005 2026-01-29T14:28:45.076Z 2026-01-29T14:30:25.750Z
9272608 9272608 20260128024837_lP2Wj US0005 2026-01-29T14:27:14.305Z 2026-01-29T14:30:25.382Z
9272554 9272554 20260128023543_eULBT US0005 2026-01-29T14:27:10.241Z 2026-01-29T14:30:25.377Z
9272494 9272494 20260128021654_67fuE US0005 2026-01-29T14:26:56.207Z 2026-01-29T14:30:25.355Z
9272323 9272323 20260128013639_kU1Zz US0005 2026-01-29T14:26:25.937Z 2026-01-29T14:30:25.329Z
9269270 9269270 20260128125445_wdnpj US0005 2026-01-29T14:07:14.232Z 2026-01-29T14:07:14.232Z
9269256 9269256 20260128125211_hYp2M US0005 2026-01-29T14:07:07.500Z 2026-01-29T14:07:07.500Z
9269185 9269185 20260128124411_qywlz US0005 2026-01-29T14:06:55.407Z 2026-01-29T14:06:55.407Z
9269161 9269161 20260128123904_gQygD US0005 2026-01-29T14:06:46.603Z 2026-01-29T14:06:46.603Z
9268977 9268977 20260128115722_ZUbXC US0005 2026-01-29T14:05:50.181Z 2026-01-29T14:05:50.181Z
9268959 9268959 20260128115128_kJH2q US0005 2026-01-29T14:05:43.532Z 2026-01-29T14:05:43.532Z
9268816 9268816 20260128112845_q64w5 US0005 2026-01-29T14:05:01.202Z 2026-01-29T14:05:01.202Z
9268435 9268435 20260128102034_spKib US0005 2026-01-29T14:03:01.775Z 2026-01-29T14:03:01.775Z
9268434 9268434 20260128101807_JUgKb US0005 2026-01-29T14:03:00.999Z 2026-01-29T14:03:00.999Z
9268380 9268380 20260128100457_e2MFa US0005 2026-01-29T14:02:44.306Z 2026-01-29T14:02:44.306Z
9268362 9268362 20260128100142_mLVvr US0005 2026-01-29T14:02:40.987Z 2026-01-29T14:02:40.987Z
9268349 9268349 20260128095908_gza9V US0005 2026-01-29T14:02:37.124Z 2026-01-29T14:02:37.124Z
9268297 9268297 20260128094458_Ofbsl US0005 2026-01-29T14:02:15.216Z 2026-01-29T14:02:15.216Z
9268253 9268253 20260128093126_yU3c1 US0005 2026-01-29T14:02:03.835Z 2026-01-29T14:02:03.835Z
9268161 9268161 20260128090613_a5jpf US0005 2026-01-29T14:01:28.049Z 2026-01-29T14:01:28.049Z
9268092 9268092 20260128084740_vMNlA US0005 2026-01-29T14:01:04.058Z 2026-01-29T14:01:04.058Z
9268065 9268065 20260128082928_e9T0P US0005 2026-01-29T14:00:51.668Z 2026-01-29T14:00:51.668Z
9268050 9268050 20260128082402_Ct1h3 US0005 2026-01-29T14:00:45.176Z 2026-01-29T14:00:45.176Z
9268042 9268042 20260128081330_RlBXd US0005 2026-01-29T14:00:40.673Z 2026-01-29T14:00:40.673Z
9268012 9268012 20260128074326_S9d27 US0005 2026-01-29T14:00:25.677Z 2026-01-29T14:00:25.677Z
9267778 9267778 20260127045559_WWzfs US0005 2026-01-28T14:23:16.642Z 2026-01-29T14:35:42.511Z
9264812 9264812 20260127131643_ijM9r US0005 2026-01-28T14:07:48.667Z 2026-01-29T14:30:24.298Z
9264805 9264805 20260127131529_BJr9d US0005 2026-01-28T14:07:45.450Z 2026-01-29T14:30:24.296Z
9264639 9264639 20260127125131_xJuA7 US0005 2026-01-28T14:06:59.063Z 2026-01-29T14:30:24.234Z
9264613 9264613 20260127125036_TaQp8 US0005 2026-01-28T14:06:54.538Z 2026-01-29T14:30:24.229Z
9264572 9264572 20260127124802_qrxec US0005 2026-01-28T14:06:43.757Z 2026-01-29T14:30:24.222Z
9264549 9264549 20260127124523_CQHF7 US0005 2026-01-28T14:06:38.950Z 2026-01-29T14:30:24.209Z
9264319 9264319 20260127120104_35rk4 US0005 2026-01-28T14:05:29.194Z 2026-01-29T14:30:20.853Z
9264268 9264268 20260127115319_ZWxb1 US0005 2026-01-28T14:05:14.582Z 2026-01-29T14:30:20.573Z
9264228 9264228 20260127114332_U2iQS US0005 2026-01-28T14:05:03.117Z 2026-01-29T14:30:20.554Z
9264108 9264108 20260127111522_qBaT9 US0005 2026-01-28T14:04:28.088Z 2026-01-29T14:30:20.054Z
9263866 9263866 20260127102439_LtKJE US0005 2026-01-28T14:03:13.721Z 2026-01-29T14:30:19.509Z
9263786 9263786 20260127101138_QtUeP US0005 2026-01-28T14:02:47.597Z 2026-01-29T14:30:18.937Z
9263719 9263719 20260127095531_c76rc US0005 2026-01-28T14:02:26.616Z 2026-01-29T14:30:18.476Z
9263620 9263620 20260127092601_iOCRD US0005 2026-01-28T14:01:46.613Z 2026-01-29T14:30:16.599Z
9263588 9263588 20260127092048_sSHj6 US0005 2026-01-28T14:01:36.287Z 2026-01-29T14:30:16.584Z
9263481 9263481 20260127082923_S38uX US0005 2026-01-28T14:00:53.208Z 2026-01-29T14:30:16.523Z
9263428 9263428 20260127075344_ifGiB US0005 2026-01-28T14:00:30.679Z 2026-01-29T14:30:16.502Z
9263399 9263399 20260127073857_wZCaQ US0005 2026-01-28T14:00:17.550Z 2026-01-29T14:30:16.483Z
9263135 9263135 20260126073626_abmH3 US0005 2026-01-27T14:17:09.997Z 2026-01-29T14:39:18.668Z
9262995 9262995 20260126055408_5TP5m US0005 2026-01-27T14:16:25.283Z 2026-01-29T14:39:08.282Z
9262981 9262981 20260126054805_SulTu US0005 2026-01-27T14:16:23.713Z 2026-01-29T14:39:07.821Z
9262951 9262951 20260126052700_vAJ6z US0005 2026-01-27T14:16:15.032Z 2026-01-29T14:39:05.806Z
9262947 9262947 20260126052621_bZlYO US0005 2026-01-27T14:16:14.476Z 2026-01-29T14:39:05.624Z
9262912 9262912 20260126045113_HjpZo US0005 2026-01-27T14:16:06.366Z 2026-01-29T14:39:01.195Z
9261765 9261765 20260126131234_VCvYL US0005 2026-01-27T14:05:29.249Z 2026-01-29T14:32:56.575Z
9261755 9261755 20260126131017_S22kj US0005 2026-01-27T14:05:24.596Z 2026-01-29T14:32:55.489Z
9261710 9261710 20260126125755_8GZ8g US0005 2026-01-27T14:05:13.844Z 2026-01-29T14:32:50.865Z
9261602 9261602 20260126122803_jWymq US0005 2026-01-27T14:04:39.979Z 2026-01-29T14:32:42.774Z
9261524 9261524 20260126120712_nhrn4 US0005 2026-01-27T14:04:12.125Z 2026-01-29T14:32:37.833Z
9261451 9261451 20260126114417_3F3np US0005 2026-01-27T14:03:46.668Z 2026-01-29T14:32:25.463Z
9261423 9261423 20260126113315_AIYl3 US0005 2026-01-27T14:03:40.478Z 2026-01-29T14:32:23.882Z
9261405 9261405 20260126112752_FHCoS US0005 2026-01-27T14:03:37.377Z 2026-01-29T14:32:16.533Z
9261375 9261375 20260126111829_wFvGm US0005 2026-01-27T14:03:26.755Z 2026-01-29T14:32:14.545Z
9261345 9261345 20260126111035_WXaVx US0005 2026-01-27T14:03:15.993Z 2026-01-29T14:32:12.789Z
9261339 9261339 20260126111027_33jl6 US0005 2026-01-27T14:03:15.351Z 2026-01-29T14:32:12.644Z
9261294 9261294 20260126110200_MNCOa US0005 2026-01-27T14:03:06.709Z 2026-01-29T14:32:10.596Z
9261260 9261260 20260126104941_ZLe4A US0005 2026-01-27T14:02:52.446Z 2026-01-29T14:32:08.765Z
9261251 9261251 20260126104815_F1tVU US0005 2026-01-27T14:02:50.089Z 2026-01-29T14:32:08.306Z
9261230 9261230 20260126103502_mXg2e US0005 2026-01-27T14:02:42.293Z 2026-01-29T14:32:05.958Z
9261219 9261219 20260126103351_RsFJn US0005 2026-01-27T14:02:40.682Z 2026-01-29T14:32:05.569Z
9261160 9261160 20260126100543_iJ2p8 US0005 2026-01-27T14:02:17.885Z 2026-01-29T14:32:00.489Z
9261146 9261146 20260126100127_mL8RT US0005 2026-01-27T14:02:12.759Z 2026-01-29T14:31:59.405Z
9261122 9261122 20260126095558_01R3O US0005 2026-01-27T14:02:01.819Z 2026-01-29T14:31:57.839Z
9261107 9261107 20260126095332_GrZPv US0005 2026-01-27T14:01:54.820Z 2026-01-29T14:31:56.857Z
9261066 9261066 20260126094328_bT506 US0005 2026-01-27T14:01:44.163Z 2026-01-29T14:31:43.330Z
9261045 9261045 20260126093731_zXB6d US0005 2026-01-27T14:01:38.065Z 2026-01-29T14:31:33.110Z
9261012 9261012 20260126092151_qErEp US0005 2026-01-27T14:01:23.529Z 2026-01-29T14:31:23.205Z
9260986 9260986 20260126091245_Hic3T US0005 2026-01-27T14:01:15.950Z 2026-01-29T14:31:17.529Z
9260983 9260983 20260126091003_phXVg US0005 2026-01-27T14:01:15.077Z 2026-01-29T14:31:17.289Z
9260876 9260876 20260126082740_DBZy1 US0005 2026-01-27T14:00:35.706Z 2026-01-29T14:31:04.032Z
9260843 9260843 20260126081127_YMZ6I US0005 2026-01-27T14:00:27.798Z 2026-01-29T14:30:52.193Z
9260834 9260834 20260126080739_voaXN US0005 2026-01-27T14:00:25.542Z 2026-01-29T14:30:44.970Z
9252960 9252960 20260123083908_wuCGc US0005 2026-01-24T14:18:00.445Z 2026-01-29T14:53:44.783Z
9252935 9252935 20260123082711_OWRL7 US0005 2026-01-24T14:17:53.028Z 2026-01-29T14:53:43.054Z
9252833 9252833 20260123064734_BU8it US0005 2026-01-24T14:17:27.023Z 2026-01-29T14:53:36.322Z
9252802 9252802 20260123063519_eFxYK US0005 2026-01-24T14:17:14.215Z 2026-01-29T14:53:33.544Z
9252789 9252789 20260123062808_8lL1T US0005 2026-01-24T14:17:09.808Z 2026-01-29T14:53:25.293Z
9252748 9252748 20260123060439_dzHNf US0005 2026-01-24T14:17:00.309Z 2026-01-29T14:53:22.650Z
9252713 9252713 20260123053555_LfPi0 US0005 2026-01-24T14:16:53.380Z 2026-01-29T14:53:18.010Z
9252645 9252645 20260123045817_49C9q US0005 2026-01-24T14:16:32.865Z 2026-01-29T14:53:13.360Z
9252401 9252401 20260123025252_ZKjRY US0005 2026-01-24T14:15:26.350Z 2026-01-29T14:52:50.945Z
9252380 9252380 20260123024204_YdfDy US0005 2026-01-24T14:15:19.112Z 2026-01-29T14:52:48.085Z
9249764 9249764 20260122082602_yaSL3 US0005 2026-01-23T14:16:12.105Z 2026-01-29T14:58:54.369Z
9249702 9249702 20260122071237_wZEU4 US0005 2026-01-23T14:15:57.127Z 2026-01-29T14:58:50.311Z
9249698 9249698 20260122070914_Kd1tO US0005 2026-01-23T14:15:56.556Z 2026-01-29T14:58:50.148Z
9249328 9249328 20260122045115_RVJ8w US0005 2026-01-23T14:15:11.219Z 2026-01-29T14:58:26.273Z
9249197 9249197 20260122040607_defWn US0005 2026-01-23T14:14:50.123Z 2026-01-29T14:58:16.533Z
9248933 9248933 20260122025035_Fybv8 US0005 2026-01-23T14:14:08.175Z 2026-01-29T14:57:55.367Z
9245476 9245476 20260122123900_YVN0x US0005 2026-01-23T14:02:06.589Z 2026-01-29T14:49:42.905Z
9245432 9245432 20260122122401_Ked8x US0005 2026-01-23T14:01:56.426Z 2026-01-29T14:49:39.389Z
9245255 9245255 20260122112547_zYegG US0005 2026-01-23T14:01:13.282Z 2026-01-29T14:49:18.442Z

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