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 = "US000P" 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
8691386 8691386 20251205051253_04mS7 US000P 2025-12-06T14:17:33.382Z 2025-12-06T14:18:01.101Z
8690958 8690958 20251205023308_QTail US000P 2025-12-06T14:15:59.914Z 2025-12-06T14:18:00.999Z
8690851 8690851 20251205020507_Ws6Fp US000P 2025-12-06T14:15:41.129Z 2025-12-06T14:18:00.972Z
8681165 8681165 20251203023128_Pm9aO US000P 2025-12-04T14:13:58.883Z 2025-12-06T14:27:51.821Z
8681114 8681114 20251203022502_LcX7i US000P 2025-12-04T14:13:52.478Z 2025-12-06T14:27:49.946Z
8674840 8674840 20251202032947_eSjao US000P 2025-12-03T14:22:28.478Z 2025-12-06T14:34:20.464Z
8674634 8674634 20251202030206_bBYAv US000P 2025-12-03T14:22:09.878Z 2025-12-06T14:34:14.371Z
8674120 8674120 20251202012952_PB0jq US000P 2025-12-03T14:20:57.084Z 2025-12-06T14:33:58.705Z
8674004 8674004 20251202010351_HxDJc US000P 2025-12-03T14:20:43.057Z 2025-12-06T14:33:44.626Z
8673958 8673958 20251202004850_5PgNh US000P 2025-12-03T14:20:26.138Z 2025-12-06T14:33:43.265Z
8671811 8671811 20251201130150_YbVy0 US000P 2025-12-03T14:13:51.314Z 2025-12-06T14:31:20.527Z
8669998 8669998 20251202124244_G5f88 US000P 2025-12-03T14:06:27.362Z 2025-12-06T14:24:30.100Z
8669978 8669978 20251202123912_19HbO US000P 2025-12-03T14:06:14.183Z 2025-12-06T14:24:28.995Z
8669858 8669858 20251202121807_ULrQw US000P 2025-12-03T14:05:50.595Z 2025-12-06T14:24:23.484Z
8669819 8669819 20251202121307_55Kvw US000P 2025-12-03T14:05:34.811Z 2025-12-06T14:24:21.692Z
8669655 8669655 20251202115230_2DKoi US000P 2025-12-03T14:04:52.265Z 2025-12-06T14:24:13.092Z
8669434 8669434 20251202111052_LXnqK US000P 2025-12-03T14:03:42.784Z 2025-12-06T14:23:53.996Z
8669418 8669418 20251202111003_8ICMq US000P 2025-12-03T14:03:40.938Z 2025-12-06T14:23:53.325Z
8669403 8669403 20251202110825_uQWgH US000P 2025-12-03T14:03:35.603Z 2025-12-06T14:23:52.293Z
8669328 8669328 20251202105316_BjqPJ US000P 2025-12-03T14:03:22.486Z 2025-12-06T14:23:49.195Z
8669322 8669322 20251202105314_L3CIu US000P 2025-12-03T14:03:22.121Z 2025-12-06T14:23:49.077Z
8669263 8669263 20251202104140_FaflD US000P 2025-12-03T14:03:05.128Z 2025-12-06T14:23:46.555Z
8669216 8669216 20251202103258_91rWs US000P 2025-12-03T14:02:52.687Z 2025-12-06T14:23:40.442Z
8668972 8668972 20251202094106_2Hl5u US000P 2025-12-03T14:01:46.006Z 2025-12-06T14:23:23.554Z
8668884 8668884 20251202091722_2vcNx US000P 2025-12-03T14:01:31.510Z 2025-12-06T14:23:16.137Z
8668842 8668842 20251202090942_SEcey US000P 2025-12-03T14:01:25.876Z 2025-12-06T14:23:13.819Z
8668801 8668801 20251202090130_NgKpG US000P 2025-12-03T14:01:20.238Z 2025-12-06T14:23:10.340Z
8668626 8668626 20251202080225_SUWVV US000P 2025-12-03T14:00:36.438Z 2025-12-06T14:22:58.001Z
8668480 8668480 20251129063248_trJ3t US000P 2025-12-02T14:49:13.273Z 2025-12-06T14:57:10.790Z
8668470 8668470 20251129060605_0MdY7 US000P 2025-12-02T14:48:51.703Z 2025-12-06T14:56:58.538Z
8668415 8668415 20251129020453_dQek2 US000P 2025-12-02T14:47:21.976Z 2025-12-06T14:56:06.181Z
8668399 8668399 20251129005734_tnCtI US000P 2025-12-02T14:47:11.957Z 2025-12-06T14:55:29.033Z
8668113 8668113 20251130060215_ACPj5 US000P 2025-12-02T14:42:01.190Z 2025-12-06T14:50:21.942Z
8668109 8668109 20251130060156_rw6jM US000P 2025-12-02T14:42:01.071Z 2025-12-06T14:50:21.913Z
8668049 8668049 20251130054543_XNtL1 US000P 2025-12-02T14:41:32.457Z 2025-12-06T14:50:01.390Z
8668027 8668027 20251130054102_wDPHd US000P 2025-12-02T14:41:30.723Z 2025-12-06T14:49:55.442Z
8667983 8667983 20251130053435_wiCLz US000P 2025-12-02T14:41:26.421Z 2025-12-06T14:49:45.964Z
8667921 8667921 20251130050901_T03P7 US000P 2025-12-02T14:41:17.850Z 2025-12-06T14:49:39.919Z
8667741 8667741 20251130034503_96eYf US000P 2025-12-02T14:40:13.559Z 2025-12-06T14:48:51.617Z
8667714 8667714 20251130032841_iL03E US000P 2025-12-02T14:39:51.022Z 2025-12-06T14:48:47.395Z
8667404 8667404 20251130010112_iJQvq US000P 2025-12-02T14:37:59.112Z 2025-12-06T14:47:33.479Z
8660551 8660551 20251130130248_P57MK US000P 2025-12-02T14:08:15.292Z 2025-12-06T14:37:18.714Z
8660444 8660444 20251130125216_8Rqxp US000P 2025-12-02T14:07:51.278Z 2025-12-06T14:37:16.007Z
8660420 8660420 20251130125103_vUZvR US000P 2025-12-02T14:07:48.458Z 2025-12-06T14:37:15.652Z
8660327 8660327 20251130122858_THO1g US000P 2025-12-02T14:07:23.544Z 2025-12-06T14:37:00.279Z
8660307 8660307 20251130122642_hIYQX US000P 2025-12-02T14:07:18.510Z 2025-12-06T14:36:59.581Z
8659873 8659873 20251130112416_t2Z53 US000P 2025-12-02T14:05:39.606Z 2025-12-06T14:36:45.280Z
8659775 8659775 20251130111443_AjF56 US000P 2025-12-02T14:05:16.504Z 2025-12-06T14:36:41.796Z
8659715 8659715 20251130110736_M8eJX US000P 2025-12-02T14:05:06.942Z 2025-12-06T14:36:40.344Z
8659655 8659655 20251130110133_cP52n US000P 2025-12-02T14:04:45.740Z 2025-12-06T14:36:28.392Z
8659415 8659415 20251130102207_us14c US000P 2025-12-02T14:03:50.112Z 2025-12-06T14:36:17.596Z
8659291 8659291 20251130100356_myCln US000P 2025-12-02T14:03:23.393Z 2025-12-06T14:36:13.319Z
8659279 8659279 20251130100311_YWghn US000P 2025-12-02T14:03:22.260Z 2025-12-06T14:36:13.050Z
8659061 8659061 20251130092622_9gkFw US000P 2025-12-02T14:02:24.441Z 2025-12-06T14:36:04.646Z
8658284 8658284 20251129074749_233ur US000P 2025-12-01T14:46:36.532Z 2025-12-06T14:57:39.391Z
8658276 8658276 20251129064750_IOS41 US000P 2025-12-01T14:46:29.598Z 2025-12-06T14:57:16.401Z
8658272 8658272 20251129063934_JrsQU US000P 2025-12-01T14:46:28.462Z 2025-12-06T14:57:13.677Z
8658267 8658267 20251129060832_yLte1 US000P 2025-12-01T14:46:04.751Z 2025-12-06T14:56:59.768Z
8658263 8658263 20251129060432_FW7Dd US000P 2025-12-01T14:45:59.228Z 2025-12-06T14:56:58.203Z
8658261 8658261 20251129054728_ljk2F US000P 2025-12-01T14:45:56.726Z 2025-12-06T14:56:50.429Z
8658245 8658245 20251129031427_JZCST US000P 2025-12-01T14:45:04.080Z 2025-12-06T14:56:28.082Z
8658240 8658240 20251129023820_OgBR8 US000P 2025-12-01T14:44:55.618Z 2025-12-06T14:56:23.352Z
8648795 8648795 20251129124315_6yWZi US000P 2025-12-01T14:06:42.697Z 2025-12-06T14:43:58.180Z
8648793 8648793 20251129124153_DcBVc US000P 2025-12-01T14:06:37.132Z 2025-12-06T14:43:57.862Z
8648772 8648772 20251129122359_d4NiW US000P 2025-12-01T14:06:07.525Z 2025-12-06T14:43:54.132Z
8648750 8648750 20251129114507_iJxOt US000P 2025-12-01T14:05:10.501Z 2025-12-06T14:43:48.503Z
8648724 8648724 20251129103943_aIkKy US000P 2025-12-01T14:03:10.443Z 2025-12-06T14:43:36.180Z
8648692 8648692 20251129084314_sYUyW US000P 2025-12-01T14:00:29.968Z 2025-12-06T14:42:50.587Z
8648690 8648690 20251129084239_u2hwu US000P 2025-12-01T14:00:29.224Z 2025-12-06T14:42:50.539Z
8648389 8648389 20251129074209_BUJqu US000P 2025-11-30T14:30:07.639Z 2025-12-06T14:57:36.597Z
8648005 8648005 20251129061823_ed0ii US000P 2025-11-30T14:29:28.441Z 2025-12-06T14:57:06.143Z
8647310 8647310 20251129041955_nIB5l US000P 2025-11-30T14:27:58.935Z 2025-12-06T14:56:36.480Z
8647262 8647262 20251129041321_Yt4pQ US000P 2025-11-30T14:27:54.171Z 2025-12-06T14:56:35.132Z
8640083 8640083 20251129124624_P5aem US000P 2025-11-30T14:07:02.795Z 2025-12-06T14:43:58.569Z
8640035 8640035 20251129124153_F2Qh0 US000P 2025-11-30T14:06:56.567Z 2025-12-06T14:43:57.846Z
8639991 8639991 20251129123614_jSDTQ US000P 2025-11-30T14:06:49.551Z 2025-11-30T14:06:49.551Z
8639684 8639684 20251129114138_JZzSQ US000P 2025-11-30T14:05:45.648Z 2025-12-06T14:43:48.347Z
8639463 8639463 20251129110817_2wkvA US000P 2025-11-30T14:05:04.550Z 2025-12-06T14:43:42.428Z
8638377 8638377 20251129083500_pE1Gf US000P 2025-11-30T14:00:43.878Z 2025-12-06T14:42:49.395Z
8638067 8638067 20251128081755_LSnmu US000P 2025-11-29T14:28:27.701Z 2025-12-06T15:04:07.550Z
8637984 8637984 20251128074922_4x1eC US000P 2025-11-29T14:28:21.997Z 2025-12-06T15:04:06.518Z
8637816 8637816 20251128064600_LcSJF US000P 2025-11-29T14:27:53.778Z 2025-12-06T15:04:04.543Z
8637686 8637686 20251128061240_vP509 US000P 2025-11-29T14:27:42.656Z 2025-12-06T15:04:02.857Z
8637634 8637634 20251128060127_t7UkJ US000P 2025-11-29T14:27:38.369Z 2025-12-06T15:04:01.915Z
8637540 8637540 20251128054912_f5ifI US000P 2025-11-29T14:27:33.028Z 2025-12-06T15:04:00.978Z
8637525 8637525 20251128054750_r37O3 US000P 2025-11-29T14:27:32.459Z 2025-12-06T15:04:00.833Z
8637310 8637310 20251128052813_JRfer US000P 2025-11-29T14:27:04.670Z 2025-12-06T15:03:58.925Z
8636528 8636528 20251128035546_74YDH US000P 2025-11-29T14:25:37.508Z 2025-12-06T15:03:24.892Z
8628327 8628327 20251128123440_dLxbz US000P 2025-11-29T14:05:52.567Z 2025-12-06T14:51:40.945Z
8628161 8628161 20251128122331_s5FTF US000P 2025-11-29T14:05:37.182Z 2025-12-06T14:51:34.732Z
8628140 8628140 20251128121827_vTXox US000P 2025-11-29T14:05:33.736Z 2025-12-06T14:51:34.140Z
8627156 8627156 20251128102945_pNaK6 US000P 2025-11-29T14:02:50.985Z 2025-12-06T14:51:13.688Z
8626924 8626924 20251128095841_NGUdV US000P 2025-11-29T14:02:04.761Z 2025-12-06T14:51:09.044Z
8626835 8626835 20251128094417_cxQA4 US000P 2025-11-29T14:01:37.142Z 2025-12-06T14:50:46.108Z
8626605 8626605 20251128091115_43Ah1 US000P 2025-11-29T14:01:01.737Z 2025-12-06T14:50:38.909Z
8626485 8626485 20251128084802_9rEiG US000P 2025-11-29T14:00:32.940Z 2025-12-06T14:50:34.731Z
8626449 8626449 20251128084213_zxgrw US000P 2025-11-29T14:00:20.747Z 2025-12-06T14:50:34.218Z
8626316 8626316 20251126085343_YHn4q US000P 2025-11-28T14:38:47.841Z 2025-12-04T15:12:15.181Z
8626306 8626306 20251126084906_n2GPh US000P 2025-11-28T14:38:43.670Z 2025-12-04T15:12:14.183Z
8626273 8626273 20251126084057_mXRPG US000P 2025-11-28T14:38:29.668Z 2025-12-04T15:12:10.249Z

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