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

4,433 rows where station_code = "US003R" 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
8686990 8686990 20251204001518_uIYG5 US003R 2025-12-05T14:13:20.114Z 2025-12-06T14:22:22.536Z
8684151 8684151 20251204105530_gRmup US003R 2025-12-05T14:02:02.838Z 2025-12-06T14:18:00.428Z
8683678 8683678 20251204063605_dJGpu US003R 2025-12-05T14:00:08.192Z 2025-12-06T14:18:00.296Z
8674199 8674199 20251202014533_l8gGs US003R 2025-12-03T14:21:08.781Z 2025-12-06T14:34:01.147Z
8670385 8670385 20251201081417_DIE3P US003R 2025-12-03T14:08:28.546Z 2025-12-06T14:29:53.938Z
8658691 8658691 20251201075343_kpbrh US003R 2025-12-02T14:00:17.562Z 2025-12-06T14:29:52.975Z
8647321 8647321 20251129042106_oTwPE US003R 2025-11-30T14:27:59.413Z 2025-12-06T14:56:36.729Z
8646674 8646674 20251129023816_bFE95 US003R 2025-11-30T14:26:39.059Z 2025-12-06T14:56:23.165Z
8638800 8638800 20251129094421_pj6EN US003R 2025-11-30T14:02:27.887Z 2025-12-06T14:43:01.165Z
8638793 8638793 20251129094227_WRmLI US003R 2025-11-30T14:02:23.336Z 2025-12-06T14:43:00.929Z
8638106 8638106 20251128082705_873xZ US003R 2025-11-29T14:28:30.290Z 2025-12-06T15:04:08.045Z
8638047 8638047 20251128081217_WlxUn US003R 2025-11-29T14:28:26.292Z 2025-12-06T15:04:07.331Z
8638040 8638040 20251128081159_Tluft US003R 2025-11-29T14:28:26.089Z 2025-12-06T15:04:07.317Z
8637962 8637962 20251128073945_Eicjk US003R 2025-11-29T14:28:20.109Z 2025-12-06T15:04:06.201Z
8637888 8637888 20251128071957_g96DC US003R 2025-11-29T14:27:58.637Z 2025-12-06T15:04:05.351Z
8637184 8637184 20251128051208_QiN2I US003R 2025-11-29T14:26:56.820Z 2025-12-06T15:03:57.367Z
8626883 8626883 20251128095259_2aJ23 US003R 2025-11-29T14:01:50.630Z 2025-12-06T14:51:01.304Z
8626877 8626877 20251128095202_iGkqs US003R 2025-11-29T14:01:49.880Z 2025-12-06T14:51:00.054Z
8626839 8626839 20251128094426_1xa2X US003R 2025-11-29T14:01:38.243Z 2025-12-06T14:50:47.052Z
8626769 8626769 20251128093311_gqtpQ US003R 2025-11-29T14:01:28.110Z 2025-12-06T14:50:41.988Z
8626656 8626656 20251128091533_V9n9L US003R 2025-11-29T14:01:07.083Z 2025-12-06T14:50:39.783Z
8626510 8626510 20251128085109_5jvjg US003R 2025-11-29T14:00:35.062Z 2025-12-06T14:50:35.009Z
8626427 8626427 20251128083530_5Of2g US003R 2025-11-29T14:00:17.439Z 2025-12-06T14:50:33.776Z
8624220 8624220 20251127034416_EhE3f US003R 2025-11-28T14:24:06.084Z 2025-12-05T15:04:55.252Z
8624126 8624126 20251127031417_6H8A7 US003R 2025-11-28T14:23:50.067Z 2025-12-05T15:04:46.265Z
8623808 8623808 20251127020542_i5Kvh US003R 2025-11-28T14:22:55.188Z 2025-12-05T15:04:18.037Z
8592814 8592814 20251124092837_Ekkmi US003R 2025-11-25T14:28:02.791Z 2025-11-25T14:28:12.982Z
8592786 8592786 20251124092410_wu9CG US003R 2025-11-25T14:27:48.834Z 2025-12-02T15:13:07.456Z
8592722 8592722 20251124091106_534iq US003R 2025-11-25T14:27:32.005Z 2025-12-02T15:13:06.796Z
8592659 8592659 20251124085318_emfS2 US003R 2025-11-25T14:27:24.842Z 2025-12-02T15:13:06.099Z
8592650 8592650 20251124085141_ne7Hm US003R 2025-11-25T14:27:24.040Z 2025-12-02T15:13:06.062Z
8592500 8592500 20251124080544_eC6eE US003R 2025-11-25T14:26:52.558Z 2025-12-02T15:13:04.631Z
8592425 8592425 20251124073313_H2GW5 US003R 2025-11-25T14:26:42.409Z 2025-12-02T15:13:04.042Z
8592400 8592400 20251124071837_fjLw2 US003R 2025-11-25T14:26:40.166Z 2025-12-02T15:13:03.808Z
8592372 8592372 20251124070552_WCtNs US003R 2025-11-25T14:26:36.467Z 2025-12-02T15:13:03.612Z
8592367 8592367 20251124070526_ESyJN US003R 2025-11-25T14:26:35.924Z 2025-12-02T15:13:03.591Z
8592339 8592339 20251124065315_ZUk7w US003R 2025-11-25T14:26:32.680Z 2025-12-02T15:13:03.355Z
8592160 8592160 20251124055516_94z0a US003R 2025-11-25T14:25:57.871Z 2025-12-02T15:13:02.115Z
8592096 8592096 20251124054716_N9lfB US003R 2025-11-25T14:25:52.091Z 2025-12-02T15:13:01.877Z
8591965 8591965 20251124052450_cZXB5 US003R 2025-11-25T14:25:27.051Z 2025-12-02T15:13:01.224Z
8591888 8591888 20251124051256_rXJ3c US003R 2025-11-25T14:25:17.725Z 2025-12-02T15:13:00.859Z
8591729 8591729 20251124044842_pjWby US003R 2025-11-25T14:25:01.597Z 2025-12-02T15:13:00.152Z
8591300 8591300 20251124040155_7TLCP US003R 2025-11-25T14:23:51.283Z 2025-12-02T15:12:57.783Z
8591080 8591080 20251124034515_tyHoo US003R 2025-11-25T14:23:34.841Z 2025-12-02T15:12:57.020Z
8590895 8590895 20251124032552_vVdEx US003R 2025-11-25T14:23:00.777Z 2025-12-02T15:12:56.034Z
8590826 8590826 20251124031720_hNQzN US003R 2025-11-25T14:22:52.920Z 2025-12-02T15:12:55.667Z
8590603 8590603 20251124025535_6sLsY US003R 2025-11-25T14:22:16.727Z 2025-12-02T15:12:52.740Z
8589310 8589310 20251124012337_OBp5f US003R 2025-11-25T14:19:37.699Z 2025-12-02T15:12:18.663Z
8589056 8589056 20251124005718_Ijz9E US003R 2025-11-25T14:18:56.403Z 2025-12-02T15:12:04.387Z
8588889 8588889 20251124004118_vcMTD US003R 2025-11-25T14:18:39.899Z 2025-12-02T15:11:58.490Z
8588253 8588253 20251123233506_53iE3 US003R 2025-11-25T14:17:08.720Z 2025-12-02T15:11:38.763Z
8588157 8588157 20251123232850_WbjGI US003R 2025-11-25T14:16:59.214Z 2025-12-02T15:11:33.023Z
8584135 8584135 20251123110342_teeqX US003R 2025-11-25T14:05:26.020Z 2025-12-02T15:09:46.386Z
8583986 8583986 20251123102940_EfwSb US003R 2025-11-25T14:04:48.998Z 2025-12-02T15:09:44.868Z
8583969 8583969 20251123102757_PDxrD US003R 2025-11-25T14:04:44.391Z 2025-12-02T15:09:44.708Z
8583340 8583340 20251124103717_oaeBo US003R 2025-11-25T14:01:23.381Z 2025-12-02T15:05:28.971Z
8583271 8583271 20251124101242_vRMKx US003R 2025-11-25T14:01:08.854Z 2025-12-02T15:05:27.847Z
8583111 8583111 20251124093623_5puAl US003R 2025-11-25T14:00:15.685Z 2025-12-02T15:05:25.364Z
8582890 8582890 20251123090513_YW9hh US003R 2025-11-24T14:34:35.725Z 2025-12-01T15:22:29.163Z
8582803 8582803 20251123083701_0Qf7f US003R 2025-11-24T14:34:31.343Z 2025-12-01T15:22:28.108Z
8582735 8582735 20251123081523_YDrqq US003R 2025-11-24T14:34:27.778Z 2025-12-01T15:22:27.225Z
8582652 8582652 20251123073649_AXc7A US003R 2025-11-24T14:34:23.721Z 2025-12-01T15:22:26.202Z
8582597 8582597 20251123071355_Pe43X US003R 2025-11-24T14:34:20.722Z 2025-12-01T15:22:25.718Z
8581909 8581909 20251123030020_3BHVS US003R 2025-11-24T14:32:46.391Z 2025-12-01T15:21:57.272Z
8581592 8581592 20251123010725_4IbEj US003R 2025-11-24T14:32:09.584Z 2025-12-01T15:21:00.507Z
8525244 8525244 20251118075625_NsWfR US003R 2025-11-20T14:35:04.410Z 2025-11-26T15:08:08.521Z
8525230 8525230 20251118045834_WqY2r US003R 2025-11-20T14:32:54.248Z 2025-11-26T15:08:03.802Z
8517176 8517176 20251118101240_nYFK0 US003R 2025-11-19T14:42:55.577Z 2025-11-26T15:08:23.460Z
8517146 8517146 20251118100454_R0Q4d US003R 2025-11-19T14:42:47.846Z 2025-11-26T15:08:23.352Z
8517060 8517060 20251118093914_giqjz US003R 2025-11-19T14:42:24.666Z 2025-11-26T15:08:20.037Z
8517009 8517009 20251118093052_qWvER US003R 2025-11-19T14:42:22.010Z 2025-11-26T15:08:17.535Z
8516869 8516869 20251118085125_YVArr US003R 2025-11-19T14:42:15.061Z 2025-11-26T15:08:10.599Z
8516833 8516833 20251118084234_AGort US003R 2025-11-19T14:42:13.920Z 2025-11-26T15:08:09.654Z
8516760 8516760 20251118082608_RV6N2 US003R 2025-11-19T14:42:11.186Z 2025-11-26T15:08:09.170Z
8516628 8516628 20251118075625_FJX3a US003R 2025-11-19T14:42:05.958Z 2025-11-19T14:42:05.958Z
8516609 8516609 20251118075145_UWHcC US003R 2025-11-19T14:41:59.985Z 2025-11-26T15:08:08.432Z
8516309 8516309 20251118061807_AdDLa US003R 2025-11-19T14:40:48.761Z 2025-11-26T15:08:06.853Z
8516266 8516266 20251118060948_H3AdV US003R 2025-11-19T14:40:42.013Z 2025-11-26T15:08:06.670Z
8515763 8515763 20251118050457_BjHBg US003R 2025-11-19T14:39:56.990Z 2025-11-26T15:08:04.038Z
8515726 8515726 20251118045833_ItpJ2 US003R 2025-11-19T14:39:55.399Z 2025-11-26T15:08:03.801Z
8515690 8515690 20251118045412_bxvx0 US003R 2025-11-19T14:39:54.053Z 2025-11-26T15:08:02.412Z
8515133 8515133 20251118034751_tanKf US003R 2025-11-19T14:38:48.344Z 2025-11-26T15:07:59.071Z
8514625 8514625 20251118024343_oMW2a US003R 2025-11-19T14:38:22.027Z 2025-11-26T15:07:55.733Z
8514519 8514519 20251118022853_Imy7a US003R 2025-11-19T14:38:17.766Z 2025-11-26T15:07:54.857Z
8514377 8514377 20251118021248_x8TnI US003R 2025-11-19T14:38:00.734Z 2025-11-26T15:07:54.176Z
8514149 8514149 20251118015028_eUON6 US003R 2025-11-19T14:37:14.615Z 2025-11-26T15:07:53.003Z
8513799 8513799 20251118010602_I07Rf US003R 2025-11-19T14:36:30.641Z 2025-11-26T15:07:50.983Z
8513034 8513034 20251117234543_7yGsQ US003R 2025-11-19T14:35:36.558Z 2025-11-26T15:07:47.407Z
8500048 8500048 20251116072420_2uQtr US003R 2025-11-18T14:45:28.573Z 2025-11-24T15:05:30.701Z
8498616 8498616 20251117094456_wSXiW US003R 2025-11-18T14:30:40.512Z 2025-11-18T14:30:40.512Z
8498547 8498547 20251117081753_Udmwc US003R 2025-11-18T14:30:32.840Z 2025-11-25T15:11:14.663Z
8498475 8498475 20251117072034_bc3J5 US003R 2025-11-18T14:30:27.056Z 2025-11-25T15:11:11.527Z
8497886 8497886 20251117055549_2MOai US003R 2025-11-18T14:29:36.306Z 2025-11-25T15:10:55.991Z
8496872 8496872 20251117045943_s1LLG US003R 2025-11-18T14:28:09.110Z 2025-11-25T15:10:21.577Z
8496545 8496545 20251117044221_5za41 US003R 2025-11-18T14:27:45.643Z 2025-11-25T15:10:17.181Z
8496039 8496039 20251117042042_DGyXm US003R 2025-11-18T14:27:02.004Z 2025-11-25T15:10:06.288Z
8495556 8495556 20251117035558_ajHjf US003R 2025-11-18T14:26:19.723Z 2025-11-25T15:09:55.388Z
8482841 8482841 20251115070829_mUCpH US003R 2025-11-17T14:30:47.280Z 2025-11-23T15:18:29.844Z
8471042 8471042 20251115063237_0ZW0Q US003R 2025-11-16T14:24:00.096Z 2025-11-23T15:18:21.910Z
8470996 8470996 20251115062425_PbtzZ US003R 2025-11-16T14:23:57.481Z 2025-11-23T15:18:21.132Z

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