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

6,668 rows where station_code = "US000V" 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
9268613 9268613 20260128105403_iv3iq US000V 2026-01-29T14:03:59.270Z 2026-01-29T14:03:59.270Z
9267904 9267904 20260127064417_IMC18 US000V 2026-01-28T14:23:50.093Z 2026-01-29T14:35:52.831Z
9267806 9267806 20260127050813_HcHlj US000V 2026-01-28T14:23:23.908Z 2026-01-29T14:35:44.829Z
9264537 9264537 20260127124358_QuAu3 US000V 2026-01-28T14:06:36.692Z 2026-01-29T14:30:24.206Z
9264447 9264447 20260127122406_CuDgK US000V 2026-01-28T14:06:10.292Z 2026-01-29T14:30:21.766Z
9264443 9264443 20260127122350_MaFiP US000V 2026-01-28T14:06:09.505Z 2026-01-29T14:30:21.765Z
9264379 9264379 20260127120901_Y0Q1M US000V 2026-01-28T14:05:45.694Z 2026-01-29T14:30:21.189Z
9264338 9264338 20260127120324_r3zO4 US000V 2026-01-28T14:05:34.453Z 2026-01-29T14:30:20.858Z
9264329 9264329 20260127120130_oEeIf US000V 2026-01-28T14:05:32.259Z 2026-01-29T14:30:20.855Z
9264253 9264253 20260127114936_RU2rg US000V 2026-01-28T14:05:11.561Z 2026-01-29T14:30:20.569Z
9264195 9264195 20260127113559_TO37H US000V 2026-01-28T14:04:55.101Z 2026-01-29T14:30:20.538Z
9264170 9264170 20260127113133_8D2LQ US000V 2026-01-28T14:04:48.060Z 2026-01-29T14:30:20.512Z
9264010 9264010 20260127105422_P1qLT US000V 2026-01-28T14:03:55.918Z 2026-01-29T14:30:19.997Z
9263970 9263970 20260127104816_tIY63 US000V 2026-01-28T14:03:42.759Z 2026-01-29T14:30:19.978Z
9263860 9263860 20260127102315_gef2t US000V 2026-01-28T14:03:12.083Z 2026-01-29T14:30:19.507Z
9263769 9263769 20260127100926_6EyCs US000V 2026-01-28T14:02:41.396Z 2026-01-29T14:30:18.932Z
9263759 9263759 20260127100851_f7Gbg US000V 2026-01-28T14:02:38.973Z 2026-01-29T14:30:18.927Z
9263494 9263494 20260127083749_PAjlg US000V 2026-01-28T14:00:58.068Z 2026-01-29T14:30:16.526Z
9263413 9263413 20260127074327_iDrM0 US000V 2026-01-28T14:00:22.898Z 2026-01-29T14:30:16.490Z
9263398 9263398 20260127073809_OaS2b US000V 2026-01-28T14:00:15.950Z 2026-01-29T14:30:16.478Z
9260664 9260664 20260125063218_MNySC US000V 2026-01-26T14:22:50.035Z 2026-01-29T14:44:34.343Z
9260549 9260549 20260125052011_A4PG6 US000V 2026-01-26T14:22:10.362Z 2026-01-29T14:44:26.066Z
9260334 9260334 20260125034720_HOHZd US000V 2026-01-26T14:21:19.415Z 2026-01-29T14:44:06.434Z
9257441 9257441 20260125133658_J22Ag US000V 2026-01-26T14:05:38.328Z 2026-01-29T14:37:12.552Z
9257225 9257225 20260125122610_Q4qHo US000V 2026-01-26T14:04:16.186Z 2026-01-29T14:37:00.266Z
9257185 9257185 20260125121902_Febm0 US000V 2026-01-26T14:04:05.004Z 2026-01-29T14:36:53.472Z
9257151 9257151 20260125121025_aHpIn US000V 2026-01-26T14:03:56.703Z 2026-01-29T14:36:51.178Z
9257105 9257105 20260125115325_oNFaR US000V 2026-01-26T14:03:41.075Z 2026-01-29T14:36:46.883Z
9257101 9257101 20260125115311_DPoB1 US000V 2026-01-26T14:03:40.492Z 2026-01-29T14:36:46.698Z
9257054 9257054 20260125114514_JQXXX US000V 2026-01-26T14:03:29.258Z 2026-01-29T14:36:43.854Z
9256929 9256929 20260125110844_9hKN1 US000V 2026-01-26T14:02:49.476Z 2026-01-29T14:36:36.912Z
9256923 9256923 20260125110747_xvDRz US000V 2026-01-26T14:02:44.344Z 2026-01-29T14:36:36.442Z
9256906 9256906 20260125110317_C4WNP US000V 2026-01-26T14:02:39.663Z 2026-01-29T14:36:35.579Z
9256902 9256902 20260125110304_bs3xw US000V 2026-01-26T14:02:37.885Z 2026-01-29T14:36:35.147Z
9256898 9256898 20260125110101_DfQcx US000V 2026-01-26T14:02:35.743Z 2026-01-29T14:36:34.718Z
9256880 9256880 20260125105731_vkb7v US000V 2026-01-26T14:02:31.895Z 2026-01-29T14:36:33.923Z
9256715 9256715 20260125100804_5xCY5 US000V 2026-01-26T14:01:36.080Z 2026-01-29T14:36:18.138Z
9256636 9256636 20260125093840_1aeBf US000V 2026-01-26T14:01:04.621Z 2026-01-29T14:36:13.237Z
9256625 9256625 20260125093343_hiXf2 US000V 2026-01-26T14:00:59.531Z 2026-01-29T14:36:12.469Z
9256612 9256612 20260125093105_znZGX US000V 2026-01-26T14:00:57.630Z 2026-01-29T14:36:12.035Z
9256596 9256596 20260125091117_SYwWK US000V 2026-01-26T14:00:49.245Z 2026-01-29T14:36:11.166Z
9256594 9256594 20260125090800_5BLS4 US000V 2026-01-26T14:00:48.130Z 2026-01-29T14:36:10.959Z
9256519 9256519 20260125083014_vtnEK US000V 2026-01-26T14:00:17.661Z 2026-01-29T14:36:06.116Z
9256499 9256499 20260125081237_1ToOE US000V 2026-01-26T14:00:10.252Z 2026-01-29T14:36:01.454Z
9244676 9244676 20260121094002_vjF2j US000V 2026-01-22T14:26:29.716Z 2026-01-29T15:06:30.570Z
9239645 9239645 20260121112916_SOXmz US000V 2026-01-22T14:02:24.304Z 2026-01-29T14:54:33.471Z
9239336 9239336 20260121102909_PK0Jd US000V 2026-01-22T14:01:00.997Z 2026-01-29T14:54:09.703Z
9239324 9239324 20260121102651_ZYq3Z US000V 2026-01-22T14:00:57.779Z 2026-01-29T14:54:08.489Z
9239300 9239300 20260121102351_82lPY US000V 2026-01-22T14:00:50.980Z 2026-01-29T14:54:06.725Z
9239265 9239265 20260121101900_f1we1 US000V 2026-01-22T14:00:41.927Z 2026-01-29T14:54:05.014Z
9238870 9238870 20260120100336_dZ9qh US000V 2026-01-21T14:30:45.093Z 2026-01-28T15:03:04.973Z
9238774 9238774 20260120094605_yIY6l US000V 2026-01-21T14:30:32.284Z 2026-01-28T15:02:49.793Z
9238516 9238516 20260120085126_nTAht US000V 2026-01-21T14:29:52.381Z 2026-01-28T15:02:36.721Z
9238276 9238276 20260120081508_G7S7R US000V 2026-01-21T14:29:05.149Z 2026-01-28T15:02:17.665Z
9238269 9238269 20260120081253_JKPNT US000V 2026-01-21T14:29:04.510Z 2026-01-28T15:02:17.319Z
9238231 9238231 20260120080522_P2rjC US000V 2026-01-21T14:28:58.329Z 2026-01-28T15:02:15.126Z
9238115 9238115 20260120072614_pSlWy US000V 2026-01-21T14:28:43.424Z 2026-01-28T15:02:08.036Z
9237042 9237042 20260120042951_W38m3 US000V 2026-01-21T14:25:00.985Z 2026-01-28T15:00:55.299Z
9236757 9236757 20260120035606_2YiX8 US000V 2026-01-21T14:23:56.030Z 2026-01-28T15:00:33.685Z
9233199 9233199 20260120133536_0gfIR US000V 2026-01-21T14:04:50.345Z 2026-01-29T15:00:48.890Z
9232698 9232698 20260120121124_MSJVh US000V 2026-01-21T14:02:54.514Z 2026-01-29T14:59:57.677Z
9232660 9232660 20260120120525_3NhW0 US000V 2026-01-21T14:02:43.424Z 2026-01-29T14:59:55.882Z
9232652 9232652 20260120120350_Ptjb6 US000V 2026-01-21T14:02:41.958Z 2026-01-29T14:59:54.978Z
9232577 9232577 20260120115154_cGuIN US000V 2026-01-21T14:02:26.578Z 2026-01-29T14:59:51.733Z
9232472 9232472 20260120113324_n0TQ0 US000V 2026-01-21T14:01:59.850Z 2026-01-29T14:59:45.503Z
9232291 9232291 20260120105919_xualT US000V 2026-01-21T14:01:09.637Z 2026-01-29T14:59:23.987Z
9197789 9197789 20260113123614_WB1ui US000V 2026-01-14T14:24:25.106Z 2026-01-21T15:06:24.719Z
9197692 9197692 20260113121004_miVF2 US000V 2026-01-14T14:24:02.442Z 2026-01-21T15:06:22.975Z
9197662 9197662 20260113120425_SJ3XG US000V 2026-01-14T14:23:55.927Z 2026-01-21T15:06:21.750Z
9197494 9197494 20260113112549_fuoJ3 US000V 2026-01-14T14:23:07.085Z 2026-01-21T15:06:19.148Z
9197279 9197279 20260113104115_H5kZa US000V 2026-01-14T14:22:13.029Z 2026-01-21T15:06:16.199Z
9196951 9196951 20260113094543_hAGGb US000V 2026-01-14T14:20:49.862Z 2026-01-21T15:06:11.253Z
9196884 9196884 20260113092725_3DOlf US000V 2026-01-14T14:20:28.292Z 2026-01-21T15:06:03.619Z
9196715 9196715 20260113084120_23hlw US000V 2026-01-14T14:19:44.899Z 2026-01-21T15:05:36.908Z
9196606 9196606 20260113075309_v9BR5 US000V 2026-01-14T14:19:10.076Z 2026-01-21T15:05:35.217Z
9196396 9196396 20260113065255_NQxFu US000V 2026-01-14T14:18:10.626Z 2026-01-21T15:05:32.630Z
9196253 9196253 20260113054459_Kg4uA US000V 2026-01-14T14:17:24.213Z 2026-01-21T15:05:30.390Z
9196095 9196095 20260113043359_Rq2uq US000V 2026-01-14T14:16:32.935Z 2026-01-21T15:05:27.183Z
9195990 9195990 20260113034921_A6ejT US000V 2026-01-14T14:15:58.153Z 2026-01-21T15:05:03.857Z
9195752 9195752 20260113024109_jY9Eu US000V 2026-01-14T14:14:45.101Z 2026-01-21T15:04:46.967Z
9195664 9195664 20260113021316_Kvaul US000V 2026-01-14T14:14:18.889Z 2026-01-21T15:04:45.356Z
9193294 9193294 20260113132020_w3i6B US000V 2026-01-14T14:00:13.138Z 2026-01-22T15:06:06.496Z
9192511 9192511 20260112123932_VdNt0 US000V 2026-01-13T14:28:32.173Z 2026-01-20T15:26:24.028Z
9192191 9192191 20260112121144_K9ELO US000V 2026-01-13T14:27:41.470Z 2026-01-20T15:26:13.627Z
9191659 9191659 20260112113240_h251q US000V 2026-01-13T14:26:05.093Z 2026-01-20T15:25:42.465Z
9191393 9191393 20260112110312_fLGE4 US000V 2026-01-13T14:25:15.518Z 2026-01-20T15:25:23.522Z
9190804 9190804 20260112100030_f2uY6 US000V 2026-01-13T14:23:31.464Z 2026-01-20T15:24:50.097Z
9190564 9190564 20260112092332_QdWqf US000V 2026-01-13T14:22:46.164Z 2026-01-20T15:24:39.364Z
9190330 9190330 20260112084759_WYgkH US000V 2026-01-13T14:21:48.915Z 2026-01-20T15:24:18.215Z
9190275 9190275 20260112083627_mXgor US000V 2026-01-13T14:21:35.349Z 2026-01-20T15:24:14.546Z
9190037 9190037 20260112073750_hsvT2 US000V 2026-01-13T14:20:29.273Z 2026-01-20T15:24:04.150Z
9189927 9189927 20260112070140_Voz1I US000V 2026-01-13T14:19:59.827Z 2026-01-20T15:23:48.252Z
9189851 9189851 20260112063713_lB0zR US000V 2026-01-13T14:19:38.838Z 2026-01-20T15:23:42.954Z
9189717 9189717 20260112060119_pmqnf US000V 2026-01-13T14:19:00.081Z 2026-01-20T15:23:36.920Z
9185221 9185221 20260111132847_y8oa7 US000V 2026-01-12T14:22:46.625Z 2026-01-19T15:21:58.517Z
9185184 9185184 20260111132039_nvC6N US000V 2026-01-12T14:22:40.093Z 2026-01-19T15:21:55.505Z
9185167 9185167 20260111131712_LXMXE US000V 2026-01-12T14:22:37.449Z 2026-01-19T15:21:53.747Z
9185106 9185106 20260111130807_3mWnD US000V 2026-01-12T14:22:29.112Z 2026-01-19T15:21:49.609Z
9185034 9185034 20260111125754_cPjZv US000V 2026-01-12T14:22:14.658Z 2026-01-19T15:21:46.344Z
9184791 9184791 20260111122015_YQY3A US000V 2026-01-12T14:21:35.845Z 2026-01-19T15:21:13.808Z

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