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,073 rows where station_code = "BR0002" 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
8666552 8666552 20251201065837_XUH50 BR0002 2025-12-02T14:26:27.088Z 2025-12-09T14:59:48.352Z
8666067 8666067 20251201042940_U7rcl BR0002 2025-12-02T14:25:11.135Z 2025-12-09T14:59:36.964Z
8658166 8658166 20251130070651_6qiGq BR0002 2025-12-01T14:35:09.154Z 2025-12-08T14:56:48.663Z
8658162 8658162 20251130070206_AJ80u BR0002 2025-12-01T14:35:05.023Z 2025-12-08T14:56:48.486Z
8658096 8658096 20251130063649_ibE4k BR0002 2025-12-01T14:34:54.348Z 2025-12-08T14:56:46.669Z
8657924 8657924 20251130061925_grC1A BR0002 2025-12-01T14:34:46.481Z 2025-12-08T14:56:44.604Z
8657406 8657406 20251130054228_ATQTD BR0002 2025-12-01T14:34:22.529Z 2025-12-08T14:56:39.340Z
8656959 8656959 20251130052143_FteN1 BR0002 2025-12-01T14:33:50.636Z 2025-12-08T14:56:35.468Z
8656346 8656346 20251130045109_C4YIg BR0002 2025-12-01T14:28:22.089Z 2025-12-08T14:56:11.100Z
8656262 8656262 20251130044542_kGc5w BR0002 2025-12-01T14:28:14.454Z 2025-12-08T14:56:09.833Z
8655628 8655628 20251130041019_gnBil BR0002 2025-12-01T14:27:18.845Z 2025-12-01T14:27:18.845Z
8655588 8655588 20251130040815_P5ng2 BR0002 2025-12-01T14:27:12.880Z 2025-12-08T14:56:00.869Z
8654637 8654637 20251130032403_fGMhM BR0002 2025-12-01T14:25:39.689Z 2025-12-08T14:55:40.695Z
8654496 8654496 20251130031834_KlQdU BR0002 2025-12-01T14:25:29.972Z 2025-12-08T14:55:28.165Z
8654224 8654224 20251130030442_wDAMn BR0002 2025-12-01T14:24:59.892Z 2025-12-08T14:55:09.105Z
8654090 8654090 20251130025727_tdVKz BR0002 2025-12-01T14:24:50.359Z 2025-12-08T14:55:07.353Z
8653614 8653614 20251130023025_SCeet BR0002 2025-12-01T14:23:47.925Z 2025-12-08T14:54:59.666Z
8652610 8652610 20251130012327_kvhuU BR0002 2025-12-01T14:21:51.577Z 2025-12-08T14:54:21.965Z
8647817 8647817 20251129053747_6IhOl BR0002 2025-11-30T14:29:02.199Z 2025-12-07T14:59:20.269Z
8647240 8647240 20251129041144_n2n9Z BR0002 2025-11-30T14:27:52.885Z 2025-12-07T14:58:32.295Z
8647151 8647151 20251129035239_ywec7 BR0002 2025-11-30T14:27:45.583Z 2025-12-07T14:58:30.346Z
8647085 8647085 20251129033808_nEV6t BR0002 2025-11-30T14:27:28.921Z 2025-12-07T14:58:28.540Z
8646990 8646990 20251129032351_6ydkO BR0002 2025-11-30T14:27:14.187Z 2025-12-07T14:58:24.716Z
8646691 8646691 20251129023832_3ecLv BR0002 2025-11-30T14:26:40.290Z 2025-12-07T14:58:17.237Z
8646588 8646588 20251129022631_Y6Jxt BR0002 2025-11-30T14:26:14.055Z 2025-12-07T14:58:14.303Z
8646581 8646581 20251129022527_nbFhi BR0002 2025-11-30T14:26:13.401Z 2025-12-07T14:58:14.105Z
8646492 8646492 20251129021118_zq3Z5 BR0002 2025-11-30T14:26:04.504Z 2025-12-07T14:58:11.986Z
8646454 8646454 20251129020745_MOj0i BR0002 2025-11-30T14:26:00.797Z 2025-12-07T14:58:10.829Z
8645938 8645938 20251129003139_0V2Kg BR0002 2025-11-30T14:24:57.315Z 2025-12-07T14:57:23.104Z
8440375 8440375 20251112061716_aXG7J BR0002 2025-11-13T14:28:49.685Z 2025-11-20T15:25:49.231Z
8439989 8439989 20251112050601_kRtkA BR0002 2025-11-13T14:27:53.947Z 2025-11-20T15:25:39.796Z
8439563 8439563 20251112040632_SrizI BR0002 2025-11-13T14:26:45.603Z 2025-11-20T15:25:28.352Z
8439001 8439001 20251112030203_NOJL3 BR0002 2025-11-13T14:25:19.410Z 2025-11-13T14:25:19.410Z
8438760 8438760 20251112023648_j6qnn BR0002 2025-11-13T14:24:37.790Z 2025-11-20T15:24:47.008Z
8438694 8438694 20251112022935_kYQu9 BR0002 2025-11-13T14:24:31.316Z 2025-11-20T15:24:45.738Z
8438007 8438007 20251112010853_r9uu3 BR0002 2025-11-13T14:22:30.871Z 2025-11-20T15:24:08.693Z
8437805 8437805 20251112004641_jk427 BR0002 2025-11-13T14:22:07.641Z 2025-11-20T15:23:54.424Z
8426880 8426880 20251111035136_HM3Dr BR0002 2025-11-12T14:26:32.151Z 2025-11-19T15:17:29.167Z
8415281 8415281 20251110045313_03NuP BR0002 2025-11-11T14:23:04.608Z 2025-11-18T15:21:24.845Z
8415049 8415049 20251110041726_Iunor BR0002 2025-11-11T14:22:24.952Z 2025-11-18T15:21:17.991Z
8414943 8414943 20251110040414_3EOuV BR0002 2025-11-11T14:22:10.275Z 2025-11-18T15:21:14.932Z
8414720 8414720 20251110033528_NyuyW BR0002 2025-11-11T14:21:33.505Z 2025-11-18T15:21:12.620Z
8414612 8414612 20251110031752_Cbyav BR0002 2025-11-11T14:21:20.620Z 2025-11-18T15:21:10.087Z
8414201 8414201 20251110015516_Ablq0 BR0002 2025-11-11T14:19:56.393Z 2025-11-18T15:20:47.893Z
8274923 8274923 20251027054224_mq3X3 BR0002 2025-10-29T12:26:44.034Z 2025-11-04T15:45:51.788Z
8225040 8225040 20251024073222_fy9vN BR0002 2025-10-26T12:43:01.287Z 2025-11-01T13:11:20.967Z
8224703 8224703 20251024070127_1g112 BR0002 2025-10-26T12:42:35.330Z 2025-11-01T13:11:19.962Z
8224164 8224164 20251024060944_uQTV1 BR0002 2025-10-26T12:41:19.446Z 2025-11-01T13:11:18.500Z
8224042 8224042 20251024055813_sfXiz BR0002 2025-10-26T12:41:14.244Z 2025-11-01T13:11:18.027Z
8223359 8223359 20251024051841_nxKFR BR0002 2025-10-26T12:40:48.306Z 2025-11-01T13:11:16.549Z
8223091 8223091 20251024050818_VKZZT BR0002 2025-10-26T12:40:05.223Z 2025-11-01T13:11:15.752Z
8222723 8222723 20251024045803_GVGxa BR0002 2025-10-26T12:39:55.044Z 2025-11-01T13:11:14.881Z
8222373 8222373 20251024045008_2OGCO BR0002 2025-10-26T12:39:46.209Z 2025-11-01T13:11:14.375Z
8221927 8221927 20251024043916_LdKLG BR0002 2025-10-26T12:39:16.709Z 2025-11-01T13:11:12.217Z
8220631 8220631 20251024040608_fwaJp BR0002 2025-10-26T12:37:57.448Z 2025-11-01T13:11:04.724Z
8220008 8220008 20251024034845_QtlD3 BR0002 2025-10-26T12:37:11.077Z 2025-11-01T13:11:00.917Z
8219987 8219987 20251024034707_QLoWh BR0002 2025-10-26T12:37:09.854Z 2025-11-01T13:10:59.823Z
8218916 8218916 20251024031622_SVG2g BR0002 2025-10-26T12:35:30.904Z 2025-11-01T13:10:52.854Z
8217049 8217049 20251024022440_YdtEJ BR0002 2025-10-26T12:33:21.850Z 2025-11-01T13:10:40.110Z
8216025 8216025 20251024015007_JYnxh BR0002 2025-10-26T12:31:43.419Z 2025-11-01T13:10:27.570Z
8213910 8213910 20251024002635_EPR4A BR0002 2025-10-26T12:28:15.419Z 2025-11-01T13:10:18.781Z
8213166 8213166 20251023234711_AX67x BR0002 2025-10-26T12:26:54.574Z 2025-11-01T13:10:16.128Z
8202597 8202597 20251023070414_2Au20 BR0002 2025-10-25T12:21:45.123Z 2025-10-31T13:08:55.877Z
8202381 8202381 20251023062917_vxIo1 BR0002 2025-10-25T12:21:02.571Z 2025-10-31T13:08:55.119Z
8202294 8202294 20251023061107_5OtFR BR0002 2025-10-25T12:20:51.001Z 2025-10-31T13:08:54.852Z
8201741 8201741 20251023043635_vIItu BR0002 2025-10-25T12:18:41.019Z 2025-10-31T13:08:50.090Z
8201673 8201673 20251023042456_gLOkr BR0002 2025-10-25T12:18:14.867Z 2025-10-31T13:08:49.425Z
8201622 8201622 20251023041721_Q3SWY BR0002 2025-10-25T12:18:04.312Z 2025-10-31T13:08:48.966Z
8201512 8201512 20251023040215_4k3tQ BR0002 2025-10-25T12:17:29.325Z 2025-10-31T13:08:46.827Z
8201459 8201459 20251023035440_56AyW BR0002 2025-10-25T12:17:18.606Z 2025-10-31T13:08:46.184Z
8200997 8200997 20251023022839_7M3JX BR0002 2025-10-25T12:14:58.828Z 2025-10-31T13:08:39.434Z
8200101 8200101 20251022230427_BCpiS BR0002 2025-10-25T12:10:36.309Z 2025-10-31T13:08:25.982Z
8200099 8200099 20251022230406_nrXse BR0002 2025-10-25T12:10:35.927Z 2025-10-31T13:08:25.963Z
8195427 8195427 20251022072818_gLJCi BR0002 2025-10-24T12:31:52.270Z 2025-10-30T13:13:41.174Z
8195330 8195330 20251022071710_xlqVZ BR0002 2025-10-24T12:31:28.378Z 2025-10-30T13:13:40.825Z
8195234 8195234 20251022070257_P1Vf8 BR0002 2025-10-24T12:31:20.270Z 2025-10-30T13:13:39.573Z
8195182 8195182 20251022065441_uyASA BR0002 2025-10-24T12:31:15.245Z 2025-10-30T13:13:39.437Z
8195132 8195132 20251022064711_LGnCJ BR0002 2025-10-24T12:31:11.663Z 2025-10-30T13:13:39.160Z
8194925 8194925 20251022061849_4pjE2 BR0002 2025-10-24T12:30:58.819Z 2025-10-30T13:13:37.217Z
8194877 8194877 20251022060905_IXEDv BR0002 2025-10-24T12:30:53.122Z 2025-10-30T13:13:37.044Z
8194868 8194868 20251022060513_ZK58P BR0002 2025-10-24T12:30:48.835Z 2025-10-30T13:13:37.007Z
8194706 8194706 20251022054337_NNC7c BR0002 2025-10-24T12:30:13.759Z 2025-10-30T13:13:34.878Z
8194569 8194569 20251022052944_65RwG BR0002 2025-10-24T12:30:05.318Z 2025-10-30T13:13:34.275Z
8194567 8194567 20251022052927_yeIer BR0002 2025-10-24T12:30:05.254Z 2025-10-30T13:13:34.269Z
8194434 8194434 20251022051635_R3gUX BR0002 2025-10-24T12:29:57.399Z 2025-10-30T13:13:34.042Z
8194285 8194285 20251022050425_9zGK2 BR0002 2025-10-24T12:29:30.489Z 2025-10-30T13:13:33.134Z
8194246 8194246 20251022050209_96TL1 BR0002 2025-10-24T12:29:22.423Z 2025-10-30T13:13:32.975Z
8193981 8193981 20251022044301_KwHrI BR0002 2025-10-24T12:29:03.237Z 2025-10-30T13:13:32.226Z
8192226 8192226 20251022023726_MgRyy BR0002 2025-10-24T12:25:35.846Z 2025-10-30T13:13:20.057Z
8191597 8191597 20251022015114_0sKTH BR0002 2025-10-24T12:24:28.778Z 2025-10-30T13:13:14.816Z
8191072 8191072 20251022011011_D5ZkK BR0002 2025-10-24T12:23:17.527Z 2025-10-30T13:13:10.283Z
8183605 8183605 20251021074149_hifLJ BR0002 2025-10-23T12:33:04.670Z 2025-10-29T13:07:51.315Z
8183517 8183517 20251021073540_5xpxQ BR0002 2025-10-23T12:33:00.112Z 2025-10-29T13:07:51.047Z
8183289 8183289 20251021071546_CV0GJ BR0002 2025-10-23T12:32:18.449Z 2025-10-29T13:07:50.443Z
8183009 8183009 20251021064309_4ECKA BR0002 2025-10-23T12:31:43.261Z 2025-10-29T13:07:48.378Z
8182755 8182755 20251021061405_t5FfY BR0002 2025-10-23T12:31:29.448Z 2025-10-29T13:07:46.177Z
8182748 8182748 20251021061316_2RD39 BR0002 2025-10-23T12:31:29.062Z 2025-10-29T13:07:46.139Z
8182661 8182661 20251021060120_GxT6l BR0002 2025-10-23T12:31:04.537Z 2025-10-29T13:07:45.834Z
8182653 8182653 20251021055903_Xn7K1 BR0002 2025-10-23T12:31:03.464Z 2025-10-29T13:07:45.778Z
8182647 8182647 20251021055733_u9uVb BR0002 2025-10-23T12:31:02.726Z 2025-10-29T13:07:45.766Z

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