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 = "BE0001" 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
9255527 9255527 20260124040313_a0sBw BE0001 2026-01-25T14:13:51.048Z 2026-01-29T14:47:36.263Z
9249619 9249619 20260122060651_22W1P BE0001 2026-01-23T14:15:48.586Z 2026-01-29T14:58:47.241Z
9249570 9249570 20260122055125_lZ3G1 BE0001 2026-01-23T14:15:43.786Z 2026-01-29T14:58:45.182Z
9249538 9249538 20260122053921_6VE3Y BE0001 2026-01-23T14:15:40.729Z 2026-01-29T14:58:43.825Z
9249513 9249513 20260122053409_m1sh3 BE0001 2026-01-23T14:15:37.814Z 2026-01-29T14:58:42.728Z
9249483 9249483 20260122053027_h8UGI BE0001 2026-01-23T14:15:34.555Z 2026-01-29T14:58:41.546Z
9249405 9249405 20260122051019_2RiAI BE0001 2026-01-23T14:15:18.963Z 2026-01-29T14:58:29.193Z
9249321 9249321 20260122044705_JErFp BE0001 2026-01-23T14:15:10.228Z 2026-01-29T14:58:25.734Z
9249309 9249309 20260122044414_rrlUO BE0001 2026-01-23T14:15:09.401Z 2026-01-29T14:58:23.070Z
9249296 9249296 20260122044035_yfy6L BE0001 2026-01-23T14:15:08.238Z 2026-01-29T14:58:22.261Z
9249278 9249278 20260122043722_66heM BE0001 2026-01-23T14:15:06.640Z 2026-01-29T14:58:21.592Z
9249248 9249248 20260122042422_jd1HL BE0001 2026-01-23T14:15:03.348Z 2026-01-29T14:58:19.859Z
9249113 9249113 20260122034226_Xy7En BE0001 2026-01-23T14:14:37.099Z 2026-01-29T14:58:13.462Z
9249055 9249055 20260122032352_PJjr6 BE0001 2026-01-23T14:14:31.140Z 2026-01-29T14:58:10.987Z
9248909 9248909 20260122024204_y1Aea BE0001 2026-01-23T14:14:06.263Z 2026-01-29T14:57:54.494Z
9248881 9248881 20260122023547_3IIm5 BE0001 2026-01-23T14:14:02.865Z 2026-01-29T14:57:52.942Z
9248667 9248667 20260122013746_9lOGV BE0001 2026-01-23T14:13:23.591Z 2026-01-29T14:57:39.916Z
9248581 9248581 20260122005157_lgTHK BE0001 2026-01-23T14:13:12.179Z 2026-01-29T14:57:35.412Z
9248569 9248569 20260122004657_HkoEu BE0001 2026-01-23T14:13:06.105Z 2026-01-29T14:57:28.495Z
9248564 9248564 20260122004233_DIqf8 BE0001 2026-01-23T14:13:05.173Z 2026-01-29T14:57:26.741Z
9248515 9248515 20260122002510_FAmPn BE0001 2026-01-23T14:12:58.006Z 2026-01-29T14:57:24.528Z
9248451 9248451 20260121235012_ry0kX BE0001 2026-01-23T14:12:49.928Z 2026-01-29T14:57:19.657Z
9248349 9248349 20260121230452_MOo5J BE0001 2026-01-23T14:12:37.527Z 2026-01-29T14:57:15.091Z
9248240 9248240 20260121222905_SXr2A BE0001 2026-01-23T14:12:18.626Z 2026-01-29T14:57:09.759Z
9248180 9248180 20260121220445_L20gK BE0001 2026-01-23T14:12:12.179Z 2026-01-29T14:57:07.452Z
9248153 9248153 20260121215455_y8pBF BE0001 2026-01-23T14:12:09.048Z 2026-01-29T14:57:05.663Z
9248127 9248127 20260121214116_aRRXj BE0001 2026-01-23T14:12:05.942Z 2026-01-29T14:56:55.853Z
9247863 9247863 20260121201729_CP2MA BE0001 2026-01-23T14:11:16.938Z 2026-01-29T14:56:41.237Z
9247671 9247671 20260121192543_cvGql BE0001 2026-01-23T14:10:43.143Z 2026-01-29T14:56:22.540Z
9247588 9247588 20260121190928_7CUgL BE0001 2026-01-23T14:10:32.408Z 2026-01-29T14:56:16.110Z
9247525 9247525 20260121185353_ScHxK BE0001 2026-01-23T14:10:24.039Z 2026-01-29T14:56:12.967Z
9247469 9247469 20260121184044_V2UzF BE0001 2026-01-23T14:10:09.408Z 2026-01-29T14:56:10.811Z
9247379 9247379 20260121181536_xcwAU BE0001 2026-01-23T14:09:57.289Z 2026-01-29T14:56:06.491Z
9247300 9247300 20260121175536_GiC0o BE0001 2026-01-23T14:09:38.133Z 2026-01-29T14:56:02.908Z
9239037 9239037 20260118025807_xXFM8 BE0001 2026-01-21T14:43:56.633Z 2026-01-26T15:02:43.088Z
9239035 9239035 20260118022321_2TM4a BE0001 2026-01-21T14:43:48.605Z 2026-01-26T15:02:35.540Z
9224820 9224820 20260118060949_7bJFk BE0001 2026-01-19T14:26:16.730Z 2026-01-26T15:03:50.170Z
9224786 9224786 20260118060420_uO8D3 BE0001 2026-01-19T14:26:02.948Z 2026-01-26T15:03:49.107Z
9224737 9224737 20260118055642_qrEx6 BE0001 2026-01-19T14:25:47.623Z 2026-01-26T15:03:47.321Z
9224595 9224595 20260118051625_jRfES BE0001 2026-01-19T14:25:08.162Z 2026-01-26T15:03:26.852Z
9224507 9224507 20260118050545_F8MhL BE0001 2026-01-19T14:24:41.259Z 2026-01-26T15:03:21.768Z
9224478 9224478 20260118045550_2b8Jz BE0001 2026-01-19T14:24:35.606Z 2026-01-26T15:03:20.632Z
9224418 9224418 20260118043950_C1vX2 BE0001 2026-01-19T14:24:19.327Z 2026-01-26T15:03:18.150Z
9224274 9224274 20260118041034_I3mgt BE0001 2026-01-19T14:23:41.423Z 2026-01-26T15:03:11.510Z
9224182 9224182 20260118034443_XzQuE BE0001 2026-01-19T14:23:12.371Z 2026-01-26T15:03:07.893Z
9224104 9224104 20260118032557_CKK8E BE0001 2026-01-19T14:22:50.114Z 2026-01-26T15:03:04.198Z
9224068 9224068 20260118032003_ir6PX BE0001 2026-01-19T14:22:37.301Z 2026-01-26T15:02:49.815Z
9223845 9223845 20260118023230_GO513 BE0001 2026-01-19T14:21:23.308Z 2026-01-26T15:02:38.415Z
9223455 9223455 20260118004922_yUfFA BE0001 2026-01-19T14:19:25.263Z 2026-01-26T15:02:07.585Z
9222893 9222893 20260117211817_ZnOAu BE0001 2026-01-19T14:16:43.110Z 2026-01-26T15:01:24.947Z
9222071 9222071 20260117180117_NP2fT BE0001 2026-01-19T14:13:07.308Z 2026-01-26T15:00:36.941Z
9218440 9218440 20260117035346_CW8Pc BE0001 2026-01-18T14:12:07.546Z 2026-01-25T14:58:25.584Z
9148773 9148773 20260104172440_RQgWF BE0001 2026-01-06T14:02:18.013Z 2026-01-13T15:11:18.759Z
9130176 9130176 20260103022740_pNO1s BE0001 2026-01-04T14:08:48.165Z 2026-01-10T14:58:50.858Z
9129878 9129878 20260103011810_APJ2u BE0001 2026-01-04T14:06:59.086Z 2026-01-10T14:58:21.861Z
9128073 9128073 20260102061052_wooIx BE0001 2026-01-03T14:13:10.774Z 2026-01-09T14:50:22.833Z
9128070 9128070 20260102061022_KwupT BE0001 2026-01-03T14:13:10.103Z 2026-01-09T14:50:22.578Z
9127522 9127522 20260102042509_BZHhg BE0001 2026-01-03T14:10:40.206Z 2026-01-09T14:49:57.128Z
9124157 9124157 20251231050144_NKuZW BE0001 2026-01-02T14:41:59.764Z 2026-01-08T15:10:44.027Z
9124152 9124152 20251231050100_3bDHI BE0001 2026-01-02T14:41:57.598Z 2026-01-08T15:10:43.288Z
9124047 9124047 20251231043208_UM5mQ BE0001 2026-01-02T14:40:12.718Z 2026-01-08T15:10:10.536Z
9123499 9123499 20251231013943_E1MRJ BE0001 2026-01-02T14:29:32.810Z 2026-01-08T15:06:54.542Z
9123423 9123423 20251231004340_xko1c BE0001 2026-01-02T14:27:31.206Z 2026-01-08T15:06:18.811Z
9123300 9123300 20251230225336_LbNIM BE0001 2026-01-02T14:24:00.996Z 2026-01-08T15:05:19.029Z
9123246 9123246 20251230221646_ec0ZI BE0001 2026-01-02T14:22:37.948Z 2026-01-08T15:05:00.377Z
9115984 9115984 20251231053814_uox25 BE0001 2026-01-01T14:26:54.932Z 2026-01-08T15:11:19.749Z
9115861 9115861 20251231053159_72sBk BE0001 2026-01-01T14:26:41.312Z 2026-01-08T15:11:15.345Z
9115571 9115571 20251231051613_J8TG1 BE0001 2026-01-01T14:25:48.780Z 2026-01-08T15:10:55.938Z
9115443 9115443 20251231050641_8ew3y BE0001 2026-01-01T14:25:22.963Z 2026-01-08T15:10:47.780Z
9115356 9115356 20251231050144_1s33v BE0001 2026-01-01T14:25:12.513Z 2026-01-08T15:10:44.209Z
9115325 9115325 20251231045900_8E5RC BE0001 2026-01-01T14:25:03.967Z 2026-01-08T15:10:42.521Z
9115023 9115023 20251231044246_jRUKd BE0001 2026-01-01T14:24:10.250Z 2026-01-08T15:10:19.974Z
9114805 9114805 20251231043208_rNSrb BE0001 2026-01-01T14:23:37.338Z 2026-01-01T14:57:53.827Z
9114772 9114772 20251231043020_iYyT4 BE0001 2026-01-01T14:23:31.416Z 2026-01-08T15:10:09.527Z
9114436 9114436 20251231041644_A2pes BE0001 2026-01-01T14:22:30.822Z 2026-01-08T15:09:48.080Z
9113667 9113667 20251231034309_DuI0U BE0001 2026-01-01T14:20:03.662Z 2026-01-08T15:08:56.904Z
9113651 9113651 20251231034204_Dguz9 BE0001 2026-01-01T14:19:54.286Z 2026-01-08T15:08:55.745Z
9113626 9113626 20251231033957_GzoPh BE0001 2026-01-01T14:19:47.952Z 2026-01-08T15:08:54.475Z
9113409 9113409 20251231032714_8e4ue BE0001 2026-01-01T14:18:47.028Z 2026-01-08T15:08:43.434Z
9113228 9113228 20251231031702_Akt28 BE0001 2026-01-01T14:18:01.044Z 2026-01-08T15:08:35.459Z
9112893 9112893 20251231025745_MLjo7 BE0001 2026-01-01T14:16:38.292Z 2026-01-08T15:08:12.737Z
9112796 9112796 20251231025241_vz8vb BE0001 2026-01-01T14:16:21.933Z 2026-01-08T15:08:08.288Z
9112090 9112090 20251231020513_79Dz8 BE0001 2026-01-01T14:13:57.929Z 2026-01-01T14:57:51.709Z
9112020 9112020 20251231015651_fyJxJ BE0001 2026-01-01T14:13:34.647Z 2026-01-08T15:07:13.648Z
9111989 9111989 20251231015431_3csqu BE0001 2026-01-01T14:13:29.026Z 2026-01-08T15:07:12.090Z
9111853 9111853 20251231014909_anSZ2 BE0001 2026-01-01T14:13:04.430Z 2026-01-08T15:07:06.855Z
9111829 9111829 20251231014741_H32WP BE0001 2026-01-01T14:12:58.764Z 2026-01-08T15:07:05.839Z
9111816 9111816 20251231014528_zU5i5 BE0001 2026-01-01T14:12:55.831Z 2026-01-08T15:07:05.245Z
9111807 9111807 20251231014520_8Mngi BE0001 2026-01-01T14:12:54.495Z 2026-01-08T15:07:04.773Z
9111378 9111378 20251231010717_gnThZ BE0001 2026-01-01T14:11:19.537Z 2026-01-08T15:06:38.069Z
9111355 9111355 20251231010507_Xrclx BE0001 2026-01-01T14:11:15.238Z 2026-01-08T15:06:36.600Z
9111026 9111026 20251231003048_NqPgW BE0001 2026-01-01T14:09:50.347Z 2026-01-01T14:57:50.493Z
9110949 9110949 20251231002136_GKv7E BE0001 2026-01-01T14:09:29.832Z 2026-01-01T14:57:50.367Z
9110249 9110249 20251230224122_1undO BE0001 2026-01-01T14:06:29.962Z 2026-01-08T15:05:14.831Z
9110206 9110206 20251230223255_rLjax BE0001 2026-01-01T14:06:19.827Z 2026-01-01T14:57:49.327Z
9110089 9110089 20251230221647_Mmttr BE0001 2026-01-01T14:05:47.037Z 2026-01-08T15:05:00.623Z
9106856 9106856 20251229005744_gqbNC BE0001 2025-12-31T14:33:03.674Z 2026-01-06T15:15:40.470Z
9104548 9104548 20251230060720_al2na BE0001 2025-12-31T14:21:36.111Z 2026-01-07T15:09:47.510Z
9099284 9099284 20251226200535_sjpJ4 BE0001 2025-12-30T15:23:17.322Z 2026-01-03T15:43:37.473Z
9098879 9098879 20251227201902_Sz1U0 BE0001 2025-12-30T15:11:13.554Z 2025-12-30T15:11:13.554Z

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