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

814 rows where station_code = "USN004" 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
8687261 8687261 20251204063021_OPEuM USN004 2025-12-05T14:14:32.106Z 2025-12-06T14:22:43.733Z
8683719 8683719 20251204071732_6U9Cs USN004 2025-12-05T14:00:20.716Z 2025-12-06T14:18:00.311Z
8683703 8683703 20251204070114_MmEMe USN004 2025-12-05T14:00:15.613Z 2025-12-06T14:18:00.306Z
8648492 8648492 20251129080725_k0W0v USN004 2025-11-30T14:30:15.503Z 2025-12-06T14:57:45.322Z
8648454 8648454 20251129075948_g5mW2 USN004 2025-11-30T14:30:11.104Z 2025-12-06T14:57:44.250Z
8648261 8648261 20251129071606_rL2R2 USN004 2025-11-30T14:30:00.144Z 2025-12-06T14:57:28.438Z
8648154 8648154 20251129064826_DkUx2 USN004 2025-11-30T14:29:41.068Z 2025-12-06T14:57:16.642Z
8648039 8648039 20251129062917_za2w4 USN004 2025-11-30T14:29:30.631Z 2025-12-06T14:57:08.786Z
8648037 8648037 20251129062909_2ZCDE USN004 2025-11-30T14:29:30.460Z 2025-12-06T14:57:08.602Z
8647357 8647357 20251129042626_BEB2Q USN004 2025-11-30T14:28:03.100Z 2025-12-06T14:56:37.360Z
8647199 8647199 20251129040150_n2dO5 USN004 2025-11-30T14:27:49.274Z 2025-12-06T14:56:33.600Z
8647146 8647146 20251129035100_1RxK6 USN004 2025-11-30T14:27:45.172Z 2025-12-06T14:56:32.791Z
8639578 8639578 20251129112432_RMHLv USN004 2025-11-30T14:05:24.217Z 2025-12-06T14:43:45.004Z
8639575 8639575 20251129112426_7huTl USN004 2025-11-30T14:05:23.785Z 2025-12-06T14:43:44.958Z
8639341 8639341 20251129105530_BKgaH USN004 2025-11-30T14:04:37.631Z 2025-12-06T14:43:39.207Z
8639317 8639317 20251129105359_Rc1q2 USN004 2025-11-30T14:04:33.655Z 2025-12-06T14:43:38.676Z
8638710 8638710 20251129092711_TDgl4 USN004 2025-11-30T14:01:56.888Z 2025-12-06T14:42:58.733Z
8638645 8638645 20251129091705_D9f20 USN004 2025-11-30T14:01:46.949Z 2025-12-06T14:42:57.264Z
8638459 8638459 20251129085011_ZT66y USN004 2025-11-30T14:01:00.442Z 2025-12-06T14:42:51.588Z
8638367 8638367 20251129083325_2ZqLh USN004 2025-11-30T14:00:41.333Z 2025-12-06T14:42:49.099Z
8638363 8638363 20251129083136_95J8P USN004 2025-11-30T14:00:40.479Z 2025-12-06T14:42:48.738Z
8638055 8638055 20251128081445_9cla3 USN004 2025-11-29T14:28:26.839Z 2025-12-06T15:04:07.412Z
8637920 8637920 20251128073221_OtF44 USN004 2025-11-29T14:28:11.977Z 2025-12-06T15:04:05.641Z
8637886 8637886 20251128071740_Mv2tf USN004 2025-11-29T14:27:58.519Z 2025-12-06T15:04:05.316Z
8637883 8637883 20251128071607_Ui6Vn USN004 2025-11-29T14:27:58.284Z 2025-12-06T15:04:05.273Z
8637881 8637881 20251128071512_Z9OFB USN004 2025-11-29T14:27:57.597Z 2025-12-06T15:04:05.248Z
8637853 8637853 20251128065536_W7V9V USN004 2025-11-29T14:27:56.014Z 2025-12-06T15:04:04.981Z
8637805 8637805 20251128064517_oE103 USN004 2025-11-29T14:27:53.460Z 2025-12-06T15:04:04.474Z
8637552 8637552 20251128055143_Webf0 USN004 2025-11-29T14:27:33.699Z 2025-12-06T15:04:01.068Z
8637144 8637144 20251128050719_o2vOT USN004 2025-11-29T14:26:53.491Z 2025-12-06T15:03:56.968Z
8635988 8635988 20251128030403_lvmQ6 USN004 2025-11-29T14:24:43.893Z 2025-12-06T15:02:54.799Z
8635808 8635808 20251128024949_XmfLQ USN004 2025-11-29T14:24:11.256Z 2025-12-06T15:02:52.364Z
8635594 8635594 20251128022845_z0r5u USN004 2025-11-29T14:23:52.114Z 2025-12-06T15:02:46.974Z
8635264 8635264 20251128015831_ec7Km USN004 2025-11-29T14:22:55.858Z 2025-12-06T15:02:42.706Z
8634513 8634513 20251128005450_iUxEt USN004 2025-11-29T14:21:26.288Z 2025-12-06T15:02:08.432Z
8634484 8634484 20251128005319_Ei3C3 USN004 2025-11-29T14:21:23.614Z 2025-12-06T15:02:06.514Z
8627599 8627599 20251128111821_kcGcs USN004 2025-11-29T14:04:02.331Z 2025-12-06T14:51:20.897Z
8627353 8627353 20251128105249_uL1h5 USN004 2025-11-29T14:03:24.159Z 2025-12-06T14:51:16.872Z
8627018 8627018 20251128101301_I25Sj USN004 2025-11-29T14:02:19.244Z 2025-12-06T14:51:11.475Z
8626864 8626864 20251128094838_dUXBm USN004 2025-11-29T14:01:41.391Z 2025-12-06T14:50:53.165Z
8626828 8626828 20251128094314_iIbuQ USN004 2025-11-29T14:01:36.034Z 2025-12-06T14:50:45.447Z
8626821 8626821 20251128094150_l3jdo USN004 2025-11-29T14:01:35.206Z 2025-12-06T14:50:44.961Z
8626597 8626597 20251128091044_KYHQY USN004 2025-11-29T14:01:00.162Z 2025-12-06T14:50:38.782Z
8626565 8626565 20251128090020_j09FS USN004 2025-11-29T14:00:44.677Z 2025-12-06T14:50:36.537Z
8624929 8624929 20251127071310_gClBw USN004 2025-11-28T14:26:01.059Z 2025-12-05T15:05:32.814Z
8624674 8624674 20251127055258_KYwxw USN004 2025-11-28T14:25:17.480Z 2025-12-05T15:05:20.357Z
8624231 8624231 20251127034527_djTuf USN004 2025-11-28T14:24:19.244Z 2025-12-05T15:04:55.649Z
8624193 8624193 20251127033629_XoMM5 USN004 2025-11-28T14:23:58.282Z 2025-12-05T15:04:54.510Z
8623595 8623595 20251127012048_j6afv USN004 2025-11-28T14:22:14.116Z 2025-12-05T15:04:04.137Z
8623504 8623504 20251127005458_9yV98 USN004 2025-11-28T14:22:03.509Z 2025-12-05T15:03:58.056Z
8616908 8616908 20251126071405_NQqHg USN004 2025-11-27T14:31:59.887Z 2025-12-04T15:11:50.997Z
8616894 8616894 20251126070450_ek7Q8 USN004 2025-11-27T14:31:58.084Z 2025-12-04T15:11:50.287Z
8616181 8616181 20251126054505_FzDUL USN004 2025-11-27T14:30:41.321Z 2025-12-04T15:11:36.644Z
8609410 8609410 20251125233903_qyo3k USN004 2025-11-27T14:18:09.498Z 2025-12-04T15:07:54.028Z
8605198 8605198 20251126112053_uNP0D USN004 2025-11-27T14:02:26.169Z 2025-12-05T15:01:12.534Z
8605194 8605194 20251126112042_pIrDV USN004 2025-11-27T14:02:25.565Z 2025-12-05T15:01:12.488Z
8605186 8605186 20251126111914_qTt7E USN004 2025-11-27T14:02:24.017Z 2025-12-05T15:01:12.283Z
8605131 8605131 20251126111154_FC2Pw USN004 2025-11-27T14:02:10.543Z 2025-12-05T15:01:10.997Z
8604921 8604921 20251126101827_BKSS2 USN004 2025-11-27T14:01:08.859Z 2025-12-05T15:01:00.382Z
8604851 8604851 20251126100601_Z8zTz USN004 2025-11-27T14:00:56.109Z 2025-12-05T15:00:57.918Z
8604820 8604820 20251126095501_QRaMM USN004 2025-11-27T14:00:46.922Z 2025-12-05T15:00:56.639Z
8592837 8592837 20251124093236_sKdfh USN004 2025-11-25T14:28:06.378Z 2025-12-02T15:13:07.964Z
8592830 8592830 20251124093206_pfUVK USN004 2025-11-25T14:28:04.610Z 2025-12-02T15:13:07.932Z
8592819 8592819 20251124092848_sZ6aH USN004 2025-11-25T14:28:03.207Z 2025-12-02T15:13:07.748Z
8592215 8592215 20251124060600_5Xsnw USN004 2025-11-25T14:26:03.629Z 2025-12-02T15:13:02.391Z
8590890 8590890 20251124032456_eRJwC USN004 2025-11-25T14:23:00.197Z 2025-12-02T15:12:56.022Z
8590866 8590866 20251124032315_sppf0 USN004 2025-11-25T14:22:57.132Z 2025-12-02T15:12:55.901Z
8583492 8583492 20251124111652_ujZDz USN004 2025-11-25T14:02:15.208Z 2025-12-02T15:05:31.208Z
8583204 8583204 20251124095911_4310m USN004 2025-11-25T14:00:44.664Z 2025-12-02T15:05:26.859Z
8583152 8583152 20251124094800_JUXZo USN004 2025-11-25T14:00:29.774Z 2025-12-02T15:05:26.088Z
8582081 8582081 20251123040239_oIu7T USN004 2025-11-24T14:33:15.654Z 2025-12-01T15:22:15.708Z
8581878 8581878 20251123025350_qwpoq USN004 2025-11-24T14:32:43.399Z 2025-12-01T15:21:52.734Z
8539968 8539968 20251120002204_Rh8yu USN004 2025-11-21T14:35:47.968Z 2025-11-28T14:56:02.643Z
8529272 8529272 20251119062932_e3S3W USN004 2025-11-20T14:44:48.162Z 2025-11-27T15:13:24.695Z
8529124 8529124 20251119055503_vR3kP USN004 2025-11-20T14:44:42.129Z 2025-11-27T15:13:21.997Z
8529107 8529107 20251119055214_JqHNS USN004 2025-11-20T14:44:41.647Z 2025-11-27T15:13:21.954Z
8525319 8525319 20251118102837_fHl2s USN004 2025-11-20T14:36:49.687Z 2025-11-26T15:08:25.137Z
8517565 8517565 20251118111507_26kGl USN004 2025-11-20T14:00:29.328Z 2025-11-27T15:10:40.078Z
8517274 8517274 20251118102921_r9na8 USN004 2025-11-19T14:42:59.916Z 2025-11-26T15:08:25.142Z
8517253 8517253 20251118102532_ep3vQ USN004 2025-11-19T14:42:58.999Z 2025-11-26T15:08:24.103Z
8516979 8516979 20251118092500_Xycfu USN004 2025-11-19T14:42:20.286Z 2025-11-26T15:08:17.121Z
8516955 8516955 20251118092223_Dunfb USN004 2025-11-19T14:42:19.135Z 2025-11-26T15:08:15.433Z
8516928 8516928 20251118091146_9GCdc USN004 2025-11-19T14:42:17.787Z 2025-11-26T15:08:11.430Z
8516898 8516898 20251118090254_HJmVe USN004 2025-11-19T14:42:16.408Z 2025-11-26T15:08:11.308Z
8516811 8516811 20251118083903_c7XlK USN004 2025-11-19T14:42:12.954Z 2025-11-26T15:08:09.446Z
8516773 8516773 20251118082936_waglv USN004 2025-11-19T14:42:11.570Z 2025-11-26T15:08:09.223Z
8516655 8516655 20251118080239_ty3BX USN004 2025-11-19T14:42:07.171Z 2025-11-26T15:08:08.653Z
8516649 8516649 20251118080013_MC3TA USN004 2025-11-19T14:42:07.001Z 2025-11-26T15:08:08.621Z
8516547 8516547 20251118073443_HEeYe USN004 2025-11-19T14:41:46.504Z 2025-11-26T15:08:08.179Z
8516486 8516486 20251118070827_5hTSu USN004 2025-11-19T14:41:35.716Z 2025-11-26T15:08:07.785Z
8516028 8516028 20251118053752_lls7U USN004 2025-11-19T14:40:09.318Z 2025-11-26T15:08:05.763Z
8515731 8515731 20251118045844_zBbxm USN004 2025-11-19T14:39:55.592Z 2025-11-19T14:39:55.592Z
8515584 8515584 20251118044140_FEAHR USN004 2025-11-19T14:39:50.702Z 2025-11-26T15:08:01.803Z
8514579 8514579 20251118023913_nX2Uc USN004 2025-11-19T14:38:20.772Z 2025-11-26T15:07:55.394Z
8513762 8513762 20251118010306_a9FGW USN004 2025-11-19T14:36:29.515Z 2025-11-26T15:07:50.835Z
8500017 8500017 20251116035921_tyBMA USN004 2025-11-18T14:44:07.236Z 2025-11-24T15:05:06.161Z
8498664 8498664 20251117105218_c2UaD USN004 2025-11-18T14:30:47.296Z 2025-11-25T15:11:32.524Z
8498662 8498662 20251117104800_fQsxx USN004 2025-11-18T14:30:47.098Z 2025-11-25T15:11:31.991Z
8498656 8498656 20251117103041_1ZPC3 USN004 2025-11-18T14:30:46.492Z 2025-11-25T15:11:28.208Z
8498653 8498653 20251117102516_cCumS USN004 2025-11-18T14:30:46.241Z 2025-11-25T15:11:28.104Z

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