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

302 rows where station_code = "BR000R" 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
9774000 9774000 20260423080811_ahaVc BR000R 2026-04-25T12:53:41.290Z 2026-04-30T13:13:45.897Z
9773574 9773574 20260423071734_FmX3H BR000R 2026-04-25T12:52:48.868Z 2026-04-30T13:13:22.066Z
9773302 9773302 20260423063613_V2boZ BR000R 2026-04-25T12:52:08.660Z 2026-04-30T13:12:48.009Z
9772967 9772967 20260423052919_kNFOT BR000R 2026-04-25T12:51:00.041Z 2026-04-30T13:12:40.832Z
9772912 9772912 20260423051149_3qoZi BR000R 2026-04-25T12:50:56.342Z 2026-04-30T13:12:40.186Z
9772795 9772795 20260423043704_pWSmq BR000R 2026-04-25T12:50:37.717Z 2026-04-30T13:12:38.330Z
9772620 9772620 20260423025122_HlOuB BR000R 2026-04-25T12:49:49.634Z 2026-04-30T13:12:25.566Z
9772584 9772584 20260423024126_oW33y BR000R 2026-04-25T12:49:28.452Z 2026-04-30T13:12:11.588Z
9772560 9772560 20260423022559_2E1lL BR000R 2026-04-25T12:49:16.180Z 2026-04-30T13:11:40.586Z
9770559 9770559 20260424033634_qlnyT BR000R 2026-04-25T12:32:16.014Z 2026-05-02T13:12:24.369Z
9739736 9739736 20260422033632_M3g1W BR000R 2026-04-23T12:24:27.512Z 2026-04-30T13:19:56.466Z
9727677 9727677 20260421020605_wZ2nk BR000R 2026-04-22T12:22:52.110Z 2026-04-29T13:21:09.434Z
9721160 9721160 20260420044010_q8OqP BR000R 2026-04-21T12:29:40.081Z 2026-04-28T13:39:28.554Z
9712331 9712331 20260419063739_GhT2S BR000R 2026-04-20T12:27:26.236Z 2026-04-27T13:50:37.976Z
9710841 9710841 20260419023101_AbbK3 BR000R 2026-04-20T12:23:44.182Z 2026-04-27T13:49:21.708Z
9703859 9703859 20260418075248_490GM BR000R 2026-04-19T12:28:17.201Z 2026-04-26T13:13:10.584Z
9681490 9681490 20260415060233_NSre2 BR000R 2026-04-16T12:25:37.282Z 2026-04-23T13:13:07.081Z
9681383 9681383 20260415044253_WOYfT BR000R 2026-04-16T12:25:25.150Z 2026-04-23T13:12:51.282Z
9680715 9680715 20260415013958_ZN3aS BR000R 2026-04-16T12:23:28.918Z 2026-04-23T13:12:22.463Z
9657872 9657872 20260412023133_a04E1 BR000R 2026-04-13T12:28:01.617Z 2026-04-20T13:08:17.883Z
9650338 9650338 20260410013023_SLxCF BR000R 2026-04-12T12:38:07.961Z 2026-04-18T13:03:46.031Z
9637485 9637485 20260409024314_PpiXT BR000R 2026-04-10T12:12:43.994Z 2026-04-17T13:12:19.954Z
9637046 9637046 20260409015500_AgniL BR000R 2026-04-10T12:11:49.103Z 2026-04-17T13:12:12.911Z
9609521 9609521 20260405074905_AHsPA BR000R 2026-04-06T12:02:19.878Z 2026-04-14T13:02:10.143Z
9607393 9607393 20260404083318_s8OVG BR000R 2026-04-05T12:01:57.921Z 2026-04-13T13:21:34.361Z
9600909 9600909 20260401083017_TWEJ4 BR000R 2026-04-02T12:00:56.114Z 2026-04-10T12:35:29.362Z
9595662 9595662 20260330075020_dOHbI BR000R 2026-03-31T12:02:07.442Z 2026-04-08T12:42:28.723Z
9595594 9595594 20260330064807_n7uEi BR000R 2026-03-31T12:01:51.860Z 2026-04-08T12:42:26.436Z
9592947 9592947 20260329040141_gzbCS BR000R 2026-03-30T12:02:24.718Z 2026-04-07T12:26:57.584Z
9592640 9592640 20260329025035_REvaC BR000R 2026-03-30T12:01:29.116Z 2026-04-07T12:26:36.511Z
8767518 8767518 20251212003806_8jtJK BR000R 2025-12-14T15:12:23.821Z 2025-12-20T14:25:26.810Z
8756786 8756786 20251212035102_OwMXZ BR000R 2025-12-14T14:00:38.731Z 2025-12-21T14:17:20.672Z
8738386 8738386 20251212024146_GYhf2 BR000R 2025-12-13T15:02:34.743Z 2025-12-20T14:25:34.966Z
8694795 8694795 20251207070611_uS4RP BR000R 2025-12-08T14:01:23.073Z 2025-12-16T15:09:39.601Z
8694188 8694188 20251206014450_AWwqH BR000R 2025-12-07T14:13:48.308Z 2025-12-14T16:07:08.829Z
8668404 8668404 20251129013544_jWtyO BR000R 2025-12-02T14:47:18.514Z 2025-12-07T14:58:06.353Z
8647457 8647457 20251129043821_4Vsjo BR000R 2025-11-30T14:28:27.331Z 2025-12-07T14:59:05.257Z
8625416 8625416 20251126004102_whO0b BR000R 2025-11-28T14:33:21.982Z 2025-12-04T15:08:04.900Z
8572479 8572479 20251122005444_Hj3GN BR000R 2025-11-23T14:39:27.607Z 2025-11-30T15:05:50.751Z
8551396 8551396 20251119235059_X328o BR000R 2025-11-22T14:27:24.857Z 2025-11-28T14:55:51.382Z
8529324 8529324 20251119065328_HuUT5 BR000R 2025-11-20T14:44:51.101Z 2025-11-27T15:13:26.433Z
8529246 8529246 20251119062119_vwT2K BR000R 2025-11-20T14:44:47.144Z 2025-11-27T15:13:23.338Z
8528898 8528898 20251119052350_NHGn6 BR000R 2025-11-20T14:44:14.412Z 2025-11-27T15:13:16.265Z
8528819 8528819 20251119051205_qrARY BR000R 2025-11-20T14:43:55.571Z 2025-11-27T15:13:13.201Z
8527808 8527808 20251119025411_ZUqOJ BR000R 2025-11-20T14:41:57.748Z 2025-11-27T15:12:31.978Z
8427607 8427607 20251111045609_siX5q BR000R 2025-11-12T14:28:49.357Z 2025-11-19T15:17:57.745Z
8427587 8427587 20251111045436_qXWmL BR000R 2025-11-12T14:28:47.383Z 2025-11-19T15:17:57.521Z
8426700 8426700 20251111033523_UumBf BR000R 2025-11-12T14:26:02.309Z 2025-11-19T15:17:24.769Z
8425860 8425860 20251111021734_vFOU0 BR000R 2025-11-12T14:23:44.029Z 2025-11-19T15:16:48.866Z
8425754 8425754 20251111021142_x4nVk BR000R 2025-11-12T14:23:34.133Z 2025-11-12T14:23:34.133Z
8424642 8424642 20251111003736_kOqB2 BR000R 2025-11-12T14:20:41.444Z 2025-11-19T15:16:20.020Z
8415924 8415924 20251110071904_8Jh2i BR000R 2025-11-11T14:24:44.918Z 2025-11-18T15:21:34.760Z
8413710 8413710 20251110002843_KSjh2 BR000R 2025-11-11T14:18:09.546Z 2025-11-18T15:20:23.639Z
8399079 8399079 20251108072125_P34Px BR000R 2025-11-09T14:17:19.508Z 2025-11-16T15:05:19.797Z
8399055 8399055 20251108071100_eEWp3 BR000R 2025-11-09T14:17:07.339Z 2025-11-16T15:05:19.059Z
8225058 8225058 20251024073351_fgCFr BR000R 2025-10-26T12:43:01.753Z 2025-11-01T13:11:20.984Z
8225038 8225038 20251024073147_EeQVE BR000R 2025-10-26T12:43:01.241Z 2025-11-01T13:11:20.957Z
8224428 8224428 20251024063920_TfC1k BR000R 2025-10-26T12:41:48.408Z 2025-11-01T13:11:19.281Z
8224013 8224013 20251024055429_EuvdH BR000R 2025-10-26T12:41:13.293Z 2025-11-01T13:11:17.974Z
8223327 8223327 20251024051737_859Z9 BR000R 2025-10-26T12:40:37.573Z 2025-11-01T13:11:16.392Z
8223072 8223072 20251024050812_LMeMQ BR000R 2025-10-26T12:40:05.120Z 2025-11-01T13:11:15.723Z
8222250 8222250 20251024044628_2YnrD BR000R 2025-10-26T12:39:43.260Z 2025-11-01T13:11:14.198Z
8222216 8222216 20251024044507_PxqrC BR000R 2025-10-26T12:39:42.331Z 2025-11-01T13:11:14.115Z
8221363 8221363 20251024042333_Cf2HY BR000R 2025-10-26T12:38:21.814Z 2025-11-01T13:11:08.539Z
8202209 8202209 20251023055122_dqkAw BR000R 2025-10-25T12:20:26.119Z 2025-10-31T13:08:54.544Z
8201610 8201610 20251023041536_3vEEr BR000R 2025-10-25T12:18:02.309Z 2025-10-31T13:08:48.905Z
8201196 8201196 20251023031755_49P23 BR000R 2025-10-25T12:15:58.279Z 2025-10-31T13:08:42.833Z
8183035 8183035 20251021064521_JR28W BR000R 2025-10-23T12:31:44.401Z 2025-10-29T13:07:48.566Z
8170297 8170297 20251020073645_rggRT BR000R 2025-10-22T12:39:39.958Z 2025-10-28T13:09:07.258Z
8169987 8169987 20251020070632_qWjTT BR000R 2025-10-22T12:38:47.955Z 2025-10-28T13:09:05.336Z
8169956 8169956 20251020070419_anfhH BR000R 2025-10-22T12:38:45.603Z 2025-10-28T13:09:05.282Z
8169498 8169498 20251020061535_K9Cja BR000R 2025-10-22T12:38:12.041Z 2025-10-28T13:09:01.766Z
8099864 8099864 20251014074744_1WGGx BR000R 2025-10-15T12:20:22.793Z 2025-10-22T13:10:19.763Z
8099791 8099791 20251014071504_tf2XS BR000R 2025-10-15T12:19:55.432Z 2025-10-22T13:10:17.984Z
8067668 8067668 20251005062923_Wps2B BR000R 2025-10-07T12:34:29.622Z 2025-10-13T12:34:15.080Z
8067647 8067647 20251005062129_KvtAq BR000R 2025-10-07T12:34:25.886Z 2025-10-13T12:34:14.387Z
8067507 8067507 20251005051412_Pe3b3 BR000R 2025-10-07T12:34:14.455Z 2025-10-13T12:34:12.569Z
8066486 8066486 20251005033952_hbAVd BR000R 2025-10-07T12:32:58.314Z 2025-10-13T12:33:58.406Z
7959795 7959795 20250924235938_9zCfK BR000R 2025-09-26T12:23:37.615Z 2025-10-03T13:04:05.956Z
7922396 7922396 20250923024258_TQBxc BR000R 2025-09-24T12:31:15.339Z 2025-10-01T13:24:55.019Z
7911018 7911018 20250923075126_IJHV0 BR000R 2025-09-24T12:04:43.662Z 2025-10-02T13:23:20.122Z
7898982 7898982 20250921065800_b12Tg BR000R 2025-09-22T12:07:55.240Z 2025-09-30T13:01:31.686Z
7898962 7898962 20250921060823_dk8Ej BR000R 2025-09-22T12:07:44.478Z 2025-09-30T13:01:25.609Z
7898952 7898952 20250921055809_WKGQV BR000R 2025-09-22T12:07:40.067Z 2025-09-30T13:01:24.481Z
7885984 7885984 20250920071447_BCnjM BR000R 2025-09-21T12:11:11.556Z 2025-09-21T12:11:11.556Z
7885969 7885969 20250920070244_NkFRP BR000R 2025-09-21T12:11:07.508Z 2025-09-21T12:11:07.508Z
7885660 7885660 20250920044812_GZ2C7 BR000R 2025-09-21T12:09:31.602Z 2025-09-21T12:09:31.602Z
7885571 7885571 20250920041621_OHOL2 BR000R 2025-09-21T12:09:12.819Z 2025-09-21T12:09:12.819Z
7885459 7885459 20250920035043_J3zoj BR000R 2025-09-21T12:08:37.548Z 2025-09-21T12:08:37.548Z
7885266 7885266 20250920032419_K8BZa BR000R 2025-09-21T12:07:35.889Z 2025-09-21T12:07:35.889Z
7884844 7884844 20250920025754_3QKbI BR000R 2025-09-21T12:05:43.490Z 2025-09-29T13:02:54.087Z
7857740 7857740 20250917031046_mgVVs BR000R 2025-09-18T12:07:31.072Z 2025-09-25T13:10:46.753Z
7857548 7857548 20250917024450_H3Qu2 BR000R 2025-09-18T12:06:25.924Z 2025-09-25T13:10:43.338Z
7836726 7836726 20250914073410_oEKjk BR000R 2025-09-16T12:24:42.076Z 2025-09-22T13:07:40.494Z
7836677 7836677 20250914072548_ZtODp BR000R 2025-09-16T12:24:28.398Z 2025-09-22T13:07:39.891Z
7821161 7821161 20250913072531_Igo42 BR000R 2025-09-14T12:11:43.084Z 2025-09-21T13:08:57.496Z
7821124 7821124 20250913071610_YYSk2 BR000R 2025-09-14T12:11:36.796Z 2025-09-21T13:08:56.523Z
7800676 7800676 20250910050001_ykpRe BR000R 2025-09-11T12:09:36.763Z 2025-09-18T12:59:38.893Z
7713961 7713961 20250831014250_KddAM BR000R 2025-09-01T12:18:20.056Z 2025-09-08T12:52:30.830Z
7490020 7490020 20250813052822_bGXjb BR000R 2025-08-15T12:55:52.498Z 2025-08-21T12:47:51.508Z

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