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 = "US0008" 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
9609797 9609797 20260405100824_5ebnz US0008 2026-04-06T12:03:54.785Z 2026-04-06T12:03:54.785Z
9609753 9609753 20260405094257_0WrLv US0008 2026-04-06T12:03:44.214Z 2026-04-06T12:03:44.214Z
9609745 9609745 20260405094002_gSmVV US0008 2026-04-06T12:03:38.464Z 2026-04-06T12:03:38.464Z
9609739 9609739 20260405093637_lOPqf US0008 2026-04-06T12:03:37.045Z 2026-04-06T12:03:37.045Z
9609735 9609735 20260405093636_vX7Da US0008 2026-04-06T12:03:36.227Z 2026-04-06T12:03:36.227Z
9609644 9609644 20260405085801_l2Ppr US0008 2026-04-06T12:03:03.111Z 2026-04-06T12:03:03.111Z
9609509 9609509 20260405073625_c7zc3 US0008 2026-04-06T12:02:15.752Z 2026-04-06T12:02:15.752Z
9609503 9609503 20260405073437_l18Rj US0008 2026-04-06T12:02:06.147Z 2026-04-06T12:02:06.147Z
9609415 9609415 20260405060751_8cE9M US0008 2026-04-06T12:01:41.808Z 2026-04-06T12:01:41.808Z
9609358 9609358 20260405050709_dlNGh US0008 2026-04-06T12:01:23.615Z 2026-04-06T12:01:23.615Z
9609347 9609347 20260405050144_0cTIv US0008 2026-04-06T12:01:21.079Z 2026-04-06T12:01:21.079Z
9607570 9607570 20260404105946_JzcFX US0008 2026-04-05T12:02:57.495Z 2026-04-06T12:16:14.465Z
9607565 9607565 20260404105806_UgLCu US0008 2026-04-05T12:02:56.963Z 2026-04-06T12:16:14.464Z
9607518 9607518 20260404101747_vQiRT US0008 2026-04-05T12:02:45.040Z 2026-04-06T12:16:14.455Z
9607462 9607462 20260404093557_F26go US0008 2026-04-05T12:02:23.806Z 2026-04-06T12:16:14.443Z
9607445 9607445 20260404091818_Orl30 US0008 2026-04-05T12:02:19.253Z 2026-04-06T12:16:14.439Z
9607441 9607441 20260404091817_d73Ru US0008 2026-04-05T12:02:18.711Z 2026-04-06T12:16:14.438Z
9607185 9607185 20260404042848_gsW8M US0008 2026-04-05T12:00:47.728Z 2026-04-06T12:16:14.380Z
9607122 9607122 20260404034456_IASLq US0008 2026-04-05T12:00:31.008Z 2026-04-06T12:16:14.367Z
9607076 9607076 20260404032658_3mG32 US0008 2026-04-05T12:00:20.909Z 2026-04-06T12:16:14.355Z
9607066 9607066 20260404032353_hBfv5 US0008 2026-04-05T12:00:19.845Z 2026-04-06T12:16:14.354Z
9605705 9605705 20260403113257_An0mN US0008 2026-04-04T12:03:31.642Z 2026-04-06T12:18:13.971Z
9605480 9605480 20260403101139_KnHK0 US0008 2026-04-04T12:02:30.550Z 2026-04-06T12:17:55.119Z
9603580 9603580 20260402110912_zDc3B US0008 2026-04-03T12:03:42.848Z 2026-04-06T12:22:14.646Z
9603520 9603520 20260402104627_4ogtB US0008 2026-04-03T12:03:19.679Z 2026-04-06T12:22:07.806Z
9603478 9603478 20260402103153_wwDQr US0008 2026-04-03T12:03:11.282Z 2026-04-06T12:22:04.841Z
9603347 9603347 20260402093846_1Oljq US0008 2026-04-03T12:02:40.551Z 2026-04-06T12:21:55.144Z
9603272 9603272 20260402091237_dYcqj US0008 2026-04-03T12:02:28.705Z 2026-04-06T12:21:50.387Z
9603258 9603258 20260402091021_33BUH US0008 2026-04-03T12:02:26.205Z 2026-04-06T12:21:49.658Z
9603256 9603256 20260402090448_WDe52 US0008 2026-04-03T12:02:25.230Z 2026-04-06T12:21:49.483Z
9603249 9603249 20260402090427_2sc2v US0008 2026-04-03T12:02:18.972Z 2026-04-06T12:21:49.300Z
9603158 9603158 20260402081852_MqZgg US0008 2026-04-03T12:02:00.371Z 2026-04-06T12:21:40.549Z
9603073 9603073 20260402073643_NA8HY US0008 2026-04-03T12:01:40.492Z 2026-04-06T12:21:32.607Z
9603034 9603034 20260402070814_qwJA7 US0008 2026-04-03T12:01:32.618Z 2026-04-06T12:21:29.539Z
9603012 9603012 20260402061718_3WbYn US0008 2026-04-03T12:01:30.136Z 2026-04-06T12:21:26.731Z
9602992 9602992 20260402051847_yaj4c US0008 2026-04-03T12:01:25.541Z 2026-04-06T12:21:25.242Z
9602925 9602925 20260402040352_kY5je US0008 2026-04-03T12:01:12.844Z 2026-04-06T12:21:21.233Z
9602846 9602846 20260402033713_Lwjve US0008 2026-04-03T12:00:55.487Z 2026-04-06T12:21:16.209Z
9598990 9598990 20260331102426_EPzVJ US0008 2026-04-01T12:01:56.623Z 2026-04-06T12:27:14.237Z
9598910 9598910 20260331084856_ceQAt US0008 2026-04-01T12:01:32.008Z 2026-04-06T12:27:06.090Z
9598747 9598747 20260331042437_swn5w US0008 2026-04-01T12:00:51.790Z 2026-04-06T12:26:55.559Z
9593478 9593478 20260329111108_rmlTA US0008 2026-03-30T12:04:06.540Z 2026-04-06T12:35:21.071Z
9593398 9593398 20260329101014_2VmD3 US0008 2026-03-30T12:03:50.904Z 2026-04-06T12:35:16.633Z
9593352 9593352 20260329093726_TqCnF US0008 2026-03-30T12:03:41.769Z 2026-04-06T12:35:13.754Z
9593324 9593324 20260329091900_dc6Rg US0008 2026-03-30T12:03:37.005Z 2026-04-06T12:35:12.212Z
9593217 9593217 20260329080303_IA3ru US0008 2026-03-30T12:03:17.910Z 2026-04-06T12:34:56.906Z
9593197 9593197 20260329075221_8s10a US0008 2026-03-30T12:03:15.545Z 2026-04-06T12:34:55.828Z
9593134 9593134 20260329065018_01LAU US0008 2026-03-30T12:03:03.729Z 2026-04-06T12:34:52.319Z
9593132 9593132 20260329064930_m7V9U US0008 2026-03-30T12:03:03.223Z 2026-04-06T12:34:52.182Z
9593063 9593063 20260329050046_IiEMI US0008 2026-03-30T12:02:48.851Z 2026-04-06T12:34:48.432Z
9590960 9590960 20260328120614_CLMvL US0008 2026-03-29T12:03:33.156Z 2026-04-06T12:38:42.298Z
9590885 9590885 20260328114419_TLz4j US0008 2026-03-29T12:03:26.635Z 2026-04-06T12:38:39.005Z
9590862 9590862 20260328113516_jnEbT US0008 2026-03-29T12:03:24.339Z 2026-04-06T12:38:37.717Z
9590789 9590789 20260328111612_Dqj2N US0008 2026-03-29T12:03:17.981Z 2026-04-06T12:38:34.851Z
9590739 9590739 20260328110325_jwhUe US0008 2026-03-29T12:03:12.054Z 2026-04-06T12:38:32.372Z
9590674 9590674 20260328104118_NI94H US0008 2026-03-29T12:03:06.530Z 2026-04-06T12:38:30.114Z
9590531 9590531 20260328095215_nH5gL US0008 2026-03-29T12:02:52.054Z 2026-04-06T12:38:22.826Z
9590359 9590359 20260328083117_JnGab US0008 2026-03-29T12:02:28.982Z 2026-04-06T12:38:03.063Z
9590271 9590271 20260328080005_Bx2Ue US0008 2026-03-29T12:02:21.258Z 2026-04-06T12:37:59.213Z
9590106 9590106 20260328055650_1zalK US0008 2026-03-29T12:02:01.172Z 2026-04-06T12:37:51.050Z
9589586 9589586 20260328034751_2q2hy US0008 2026-03-29T12:01:26.651Z 2026-04-06T12:37:28.000Z
9589199 9589199 20260328024713_11yu3 US0008 2026-03-29T12:00:51.205Z 2026-04-06T12:37:06.952Z
9587277 9587277 20260327115856_1yNoQ US0008 2026-03-28T12:05:10.940Z 2026-04-05T12:34:11.148Z
9587182 9587182 20260327113801_wIALI US0008 2026-03-28T12:04:57.367Z 2026-04-05T12:34:05.568Z
9586890 9586890 20260327100549_G8TP6 US0008 2026-03-28T12:04:18.000Z 2026-04-05T12:33:53.136Z
9586879 9586879 20260327100355_qbq22 US0008 2026-03-28T12:04:16.609Z 2026-04-05T12:33:52.790Z
9586786 9586786 20260327093606_B2IL8 US0008 2026-03-28T12:04:00.743Z 2026-04-05T12:33:48.543Z
9586722 9586722 20260327091954_yVnNk US0008 2026-03-28T12:03:50.866Z 2026-04-05T12:33:39.200Z
9586374 9586374 20260327065235_fCq5v US0008 2026-03-28T12:02:56.580Z 2026-04-05T12:33:22.731Z
9586354 9586354 20260327063829_RTSuO US0008 2026-03-28T12:02:53.382Z 2026-04-05T12:33:21.915Z
9586330 9586330 20260327062742_ZPBtY US0008 2026-03-28T12:02:50.808Z 2026-04-05T12:33:20.992Z
9586208 9586208 20260327045746_h7SAH US0008 2026-03-28T12:02:31.913Z 2026-04-05T12:33:08.222Z
9585723 9585723 20260327021519_EoV8J US0008 2026-03-28T12:01:07.349Z 2026-04-05T12:32:36.354Z
9583012 9583012 20260326103513_4VU5d US0008 2026-03-27T12:07:26.100Z 2026-04-04T12:40:39.650Z
9583006 9583006 20260326103432_nyjAG US0008 2026-03-27T12:07:25.676Z 2026-04-04T12:40:39.572Z
9582932 9582932 20260326100224_F81e9 US0008 2026-03-27T12:07:15.849Z 2026-04-04T12:40:36.810Z
9582903 9582903 20260326095908_MtF28 US0008 2026-03-27T12:07:11.023Z 2026-04-04T12:40:35.842Z
9582825 9582825 20260326094238_wJnTC US0008 2026-03-27T12:06:56.301Z 2026-04-04T12:40:30.856Z
9582335 9582335 20260326065156_0Mvnc US0008 2026-03-27T12:05:26.596Z 2026-04-04T12:39:51.198Z
9582226 9582226 20260326053200_jEwkD US0008 2026-03-27T12:05:01.697Z 2026-04-04T12:39:43.416Z
9582216 9582216 20260326051832_ZbXmm US0008 2026-03-27T12:04:59.059Z 2026-04-04T12:39:42.594Z
9582025 9582025 20260326042233_iyaPs US0008 2026-03-27T12:04:25.915Z 2026-04-04T12:39:35.185Z
9581907 9581907 20260326041053_Y2R2o US0008 2026-03-27T12:04:07.478Z 2026-04-04T12:39:30.984Z
9578456 9578456 20260325115411_osAHb US0008 2026-03-26T12:07:40.934Z 2026-04-03T12:38:04.282Z
9578216 9578216 20260325104744_anCDV US0008 2026-03-26T12:07:00.627Z 2026-04-03T12:37:43.534Z
9578184 9578184 20260325104102_2zo09 US0008 2026-03-26T12:06:57.123Z 2026-04-03T12:37:42.643Z
9578119 9578119 20260325101018_eLMxa US0008 2026-03-26T12:06:46.879Z 2026-04-03T12:37:38.006Z
9578093 9578093 20260325095928_zWDFb US0008 2026-03-26T12:06:43.961Z 2026-04-03T12:37:36.834Z
9578080 9578080 20260325095410_8oMYD US0008 2026-03-26T12:06:42.103Z 2026-04-03T12:37:36.230Z
9578053 9578053 20260325094510_eTMIs US0008 2026-03-26T12:06:39.233Z 2026-04-03T12:37:35.337Z
9578029 9578029 20260325093447_rD26O US0008 2026-03-26T12:06:36.356Z 2026-04-03T12:37:34.443Z
9578007 9578007 20260325092914_Ib9td US0008 2026-03-26T12:06:32.415Z 2026-04-03T12:37:33.738Z
9577988 9577988 20260325092607_b5GPp US0008 2026-03-26T12:06:30.943Z 2026-04-03T12:37:33.332Z
9577968 9577968 20260325092446_6iFHo US0008 2026-03-26T12:06:28.793Z 2026-04-03T12:37:32.792Z
9577951 9577951 20260325092346_ZIhnB US0008 2026-03-26T12:06:25.648Z 2026-04-03T12:37:32.311Z
9577916 9577916 20260325091353_XjBoO US0008 2026-03-26T12:06:20.602Z 2026-04-03T12:37:30.885Z
9577906 9577906 20260325091240_QMqiq US0008 2026-03-26T12:06:19.280Z 2026-04-03T12:37:30.598Z
9577898 9577898 20260325091229_XUfY5 US0008 2026-03-26T12:06:18.721Z 2026-04-03T12:37:30.508Z
9577828 9577828 20260325085415_F1E3w US0008 2026-03-26T12:06:10.280Z 2026-04-03T12:37:28.525Z
9577820 9577820 20260325085316_W6lO2 US0008 2026-03-26T12:06:09.910Z 2026-04-03T12:37:28.402Z

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