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

1,557 rows where station_code = "US002E" 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
8691399 8691399 20251205051511_Hm37A US002E 2025-12-06T14:17:40.548Z 2025-12-06T14:18:01.104Z
8683723 8683723 20251204072421_Sltvs US002E 2025-12-05T14:00:21.770Z 2025-12-06T14:18:00.312Z
8683707 8683707 20251204070427_U9ivS US002E 2025-12-05T14:00:17.035Z 2025-12-06T14:18:00.308Z
8683695 8683695 20251204070013_LCxXL US002E 2025-12-05T14:00:14.150Z 2025-12-06T14:18:00.305Z
8677598 8677598 20251203105859_PohwV US002E 2025-12-04T14:01:55.079Z 2025-12-06T14:19:43.138Z
8677469 8677469 20251203101605_HCHXV US002E 2025-12-04T14:01:20.620Z 2025-12-06T14:19:30.860Z
8677460 8677460 20251203101017_kkJeS US002E 2025-12-04T14:01:19.143Z 2025-12-06T14:19:30.355Z
8677360 8677360 20251203091700_Bv00v US002E 2025-12-04T14:00:54.557Z 2025-12-06T14:19:19.498Z
8677349 8677349 20251203091059_c1yhV US002E 2025-12-04T14:00:52.381Z 2025-12-06T14:19:18.820Z
8666557 8666557 20251201071232_sZghn US002E 2025-12-02T14:26:27.866Z 2025-12-06T14:42:43.293Z
8666554 8666554 20251201071047_afyQh US002E 2025-12-02T14:26:27.418Z 2025-12-06T14:42:43.231Z
8666549 8666549 20251201063216_hZGzO US002E 2025-12-02T14:26:26.474Z 2025-12-06T14:42:41.783Z
8666546 8666546 20251201062853_TC28F US002E 2025-12-02T14:26:26.169Z 2025-12-06T14:42:41.130Z
8666429 8666429 20251201053843_2Dl3f US002E 2025-12-02T14:26:03.809Z 2025-12-06T14:42:21.995Z
8658753 8658753 20251201110214_DCA7c US002E 2025-12-02T14:00:35.812Z 2025-12-06T14:30:39.527Z
8658751 8658751 20251201102240_vSUjO US002E 2025-12-02T14:00:35.220Z 2025-12-06T14:30:25.743Z
8658749 8658749 20251201102136_sAMRb US002E 2025-12-02T14:00:34.714Z 2025-12-06T14:30:25.414Z
8658739 8658739 20251201095706_Lt3Y2 US002E 2025-12-02T14:00:32.176Z 2025-12-06T14:30:16.844Z
8658704 8658704 20251201083057_IOSEy US002E 2025-12-02T14:00:21.614Z 2025-12-06T14:29:55.842Z
8658702 8658702 20251201080931_FJkbo US002E 2025-12-02T14:00:20.835Z 2025-12-06T14:29:53.736Z
8648273 8648273 20251129071816_09Oam US002E 2025-11-30T14:30:00.699Z 2025-12-06T14:57:29.178Z
8648009 8648009 20251129062109_wXtqO US002E 2025-11-30T14:29:28.837Z 2025-12-06T14:57:06.441Z
8648007 8648007 20251129061825_9nfRg US002E 2025-11-30T14:29:28.604Z 2025-12-06T14:57:06.369Z
8647788 8647788 20251129053031_lAlUa US002E 2025-11-30T14:28:54.168Z 2025-12-06T14:56:47.982Z
8647704 8647704 20251129051158_fXQLa US002E 2025-11-30T14:28:46.299Z 2025-12-06T14:56:44.672Z
8647613 8647613 20251129045825_B8F4L US002E 2025-11-30T14:28:39.336Z 2025-12-06T14:56:42.133Z
8647561 8647561 20251129045131_38F0I US002E 2025-11-30T14:28:35.702Z 2025-12-06T14:56:41.256Z
8647466 8647466 20251129043917_jIx8D US002E 2025-11-30T14:28:27.952Z 2025-12-06T14:56:39.521Z
8647033 8647033 20251129033002_apfCy US002E 2025-11-30T14:27:21.307Z 2025-12-06T14:56:30.564Z
8646452 8646452 20251129020740_L08uy US002E 2025-11-30T14:26:00.429Z 2025-12-06T14:56:08.382Z
8639040 8639040 20251129101942_AbiJx US002E 2025-11-30T14:03:34.742Z 2025-12-06T14:43:08.873Z
8638700 8638700 20251129092603_R1SnI US002E 2025-11-30T14:01:55.602Z 2025-12-06T14:42:58.608Z
8638381 8638381 20251129083547_ijq7G US002E 2025-11-30T14:00:45.089Z 2025-12-06T14:42:49.521Z
8638248 8638248 20251129080929_MBSrI US002E 2025-11-30T14:00:11.735Z 2025-12-06T14:42:45.687Z
8638075 8638075 20251128081846_70D2G US002E 2025-11-29T14:28:28.583Z 2025-12-06T15:04:07.607Z
8638035 8638035 20251128081139_nWYmo US002E 2025-11-29T14:28:25.898Z 2025-12-06T15:04:07.284Z
8637767 8637767 20251128063217_qTnRr US002E 2025-11-29T14:27:48.881Z 2025-12-06T15:04:03.964Z
8626993 8626993 20251128101035_RJyz6 US002E 2025-11-29T14:02:14.797Z 2025-12-06T14:51:10.936Z
8626694 8626694 20251128092112_bfgHD US002E 2025-11-29T14:01:11.671Z 2025-12-06T14:50:40.812Z
8626651 8626651 20251128091521_4OBXk US002E 2025-11-29T14:01:06.653Z 2025-12-06T14:50:39.745Z
8626572 8626572 20251128090250_jg1RX US002E 2025-11-29T14:00:46.019Z 2025-12-06T14:50:37.043Z
8624214 8624214 20251127034128_hsmcQ US002E 2025-11-28T14:24:01.521Z 2025-12-05T15:04:55.099Z
8592842 8592842 20251124093426_uCsUB US002E 2025-11-25T14:28:07.306Z 2025-12-02T15:13:08.041Z
8591894 8591894 20251124051319_FOffJ US002E 2025-11-25T14:25:18.527Z 2025-12-02T15:13:00.895Z
8591779 8591779 20251124045622_fkAlx US002E 2025-11-25T14:25:07.517Z 2025-12-02T15:13:00.477Z
8591749 8591749 20251124045046_gyk8g US002E 2025-11-25T14:25:03.958Z 2025-12-02T15:13:00.314Z
8591021 8591021 20251124033745_1AY5q US002E 2025-11-25T14:23:17.014Z 2025-12-02T15:12:56.700Z
8589079 8589079 20251124010024_IJPxR US002E 2025-11-25T14:18:58.836Z 2025-12-02T15:12:04.623Z
8589058 8589058 20251124005751_lI28S US002E 2025-11-25T14:18:56.733Z 2025-12-02T15:12:04.486Z
8588945 8588945 20251124004702_VFG4g US002E 2025-11-25T14:18:48.564Z 2025-12-02T15:12:03.023Z
8588697 8588697 20251124002257_g9T1a US002E 2025-11-25T14:18:09.580Z 2025-12-02T15:11:50.083Z
8588027 8588027 20251123231347_E5XWX US002E 2025-11-25T14:16:36.343Z 2025-12-02T15:11:24.178Z
8584055 8584055 20251123104309_Adfy8 US002E 2025-11-25T14:05:10.968Z 2025-12-02T15:09:45.703Z
8583010 8583010 20251123093953_mk0Td US002E 2025-11-24T14:34:44.919Z 2025-12-01T15:22:30.728Z
8582988 8582988 20251123092946_WKACm US002E 2025-11-24T14:34:41.367Z 2025-12-01T15:22:30.404Z
8582840 8582840 20251123085210_KFe2T US002E 2025-11-24T14:34:33.220Z 2025-12-01T15:22:28.495Z
8582692 8582692 20251123075824_a83wk US002E 2025-11-24T14:34:25.487Z 2025-12-01T15:22:26.582Z
8582643 8582643 20251123073536_7xzGY US002E 2025-11-24T14:34:23.427Z 2025-12-01T15:22:26.147Z
8582535 8582535 20251123065432_WoEDD US002E 2025-11-24T14:33:53.033Z 2025-12-01T15:22:24.959Z
8582532 8582532 20251123065418_sZa3Y US002E 2025-11-24T14:33:52.805Z 2025-12-01T15:22:24.940Z
8582459 8582459 20251123062657_voNep US002E 2025-11-24T14:33:38.556Z 2025-12-01T15:22:24.165Z
8582281 8582281 20251123051221_3qc4v US002E 2025-11-24T14:33:27.300Z 2025-12-01T15:22:21.032Z
8582214 8582214 20251123044526_7ajm3 US002E 2025-11-24T14:33:23.014Z 2025-12-01T15:22:18.891Z
8582163 8582163 20251123042632_83y5E US002E 2025-11-24T14:33:20.408Z 2025-12-01T15:22:17.655Z
8582041 8582041 20251123035204_myJ3c US002E 2025-11-24T14:33:13.362Z 2025-12-01T15:22:14.759Z
8581881 8581881 20251123025546_tzJSm US002E 2025-11-24T14:32:43.641Z 2025-12-01T15:21:55.168Z
8581735 8581735 20251123015845_WP4og US002E 2025-11-24T14:32:35.077Z 2025-12-01T15:21:21.050Z
8581550 8581550 20251123005259_Js19M US002E 2025-11-24T14:31:48.708Z 2025-12-01T15:20:57.003Z
8581446 8581446 20251122235638_bhhxU US002E 2025-11-24T14:31:35.249Z 2025-12-01T15:20:29.458Z
8554047 8554047 20251120065723_JrQP5 US002E 2025-11-22T14:34:41.111Z 2025-11-28T14:58:44.775Z
8541549 8541549 20251120023135_eRiRk US002E 2025-11-21T14:37:22.000Z 2025-11-28T14:56:52.169Z
8539625 8539625 20251119235333_YDTfM US002E 2025-11-21T14:35:37.178Z 2025-11-28T14:55:51.639Z
8539125 8539125 20251119230803_Y2nHz US002E 2025-11-21T14:34:47.465Z 2025-11-28T14:55:44.184Z
8525401 8525401 20251118104633_fJqaH US002E 2025-11-20T14:36:55.472Z 2025-11-26T15:08:28.233Z
8525399 8525399 20251118104624_ljrS7 US002E 2025-11-20T14:36:55.403Z 2025-11-26T15:08:28.227Z
8525361 8525361 20251118104001_6vEkV US002E 2025-11-20T14:36:53.588Z 2025-11-26T15:08:26.035Z
8517049 8517049 20251118093637_ly4mg US002E 2025-11-19T14:42:24.181Z 2025-11-26T15:08:19.764Z
8516998 8516998 20251118092830_zM6Lk US002E 2025-11-19T14:42:21.772Z 2025-11-26T15:08:17.229Z
8516937 8516937 20251118091427_aSjlj US002E 2025-11-19T14:42:18.256Z 2025-11-26T15:08:11.638Z
8516901 8516901 20251118090407_6hqZ7 US002E 2025-11-19T14:42:16.527Z 2025-11-26T15:08:11.328Z
8516879 8516879 20251118085631_MuoQa US002E 2025-11-19T14:42:15.756Z 2025-11-26T15:08:10.770Z
8516790 8516790 20251118083139_qHrAL US002E 2025-11-19T14:42:12.124Z 2025-11-26T15:08:09.337Z
8516720 8516720 20251118081629_U2ncP US002E 2025-11-19T14:42:09.426Z 2025-11-26T15:08:08.910Z
8516698 8516698 20251118081213_W2Rn3 US002E 2025-11-19T14:42:08.631Z 2025-11-26T15:08:08.881Z
8516656 8516656 20251118080427_2v5vf US002E 2025-11-19T14:42:07.256Z 2025-11-26T15:08:08.667Z
8516618 8516618 20251118075405_CV4rx US002E 2025-11-19T14:42:05.394Z 2025-11-26T15:08:08.481Z
8516550 8516550 20251118073836_M5h3Y US002E 2025-11-19T14:41:46.789Z 2025-11-26T15:08:08.214Z
8516500 8516500 20251118071616_N7Q2G US002E 2025-11-19T14:41:39.011Z 2025-11-26T15:08:07.920Z
8516481 8516481 20251118070812_VEhzu US002E 2025-11-19T14:41:35.636Z 2025-11-26T15:08:07.747Z
8498645 8498645 20251117100755_u0is4 US002E 2025-11-18T14:30:45.516Z 2025-11-25T15:11:27.197Z
8498622 8498622 20251117094858_R06tf US002E 2025-11-18T14:30:41.962Z 2025-11-25T15:11:24.731Z
8498518 8498518 20251117075108_fpPxt US002E 2025-11-18T14:30:30.639Z 2025-11-25T15:11:13.460Z
8498513 8498513 20251117074606_VtQA7 US002E 2025-11-18T14:30:30.291Z 2025-11-25T15:11:13.202Z
8498491 8498491 20251117073335_5D6oR US002E 2025-11-18T14:30:28.454Z 2025-11-25T15:11:12.168Z
8497915 8497915 20251117055640_H1kzq US002E 2025-11-18T14:29:37.452Z 2025-11-25T15:10:56.704Z
8496964 8496964 20251117050325_KCKZ9 US002E 2025-11-18T14:28:30.989Z 2025-11-25T15:10:29.477Z
8495815 8495815 20251117041107_K1hg8 US002E 2025-11-18T14:26:50.642Z 2025-11-25T15:10:03.764Z
8483915 8483915 20251115091003_lr828 US002E 2025-11-17T14:32:04.951Z 2025-11-23T15:19:20.475Z
8483497 8483497 20251115083638_VNU8K US002E 2025-11-17T14:31:48.188Z 2025-11-23T15:18:57.080Z
8483468 8483468 20251115083343_au8B3 US002E 2025-11-17T14:31:46.524Z 2025-11-23T15:18:55.870Z

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