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 = "USL00Q" 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
8671904 8671904 20251201131620_m3byj USL00Q 2025-12-03T14:14:07.914Z 2025-12-06T14:31:27.769Z
8671858 8671858 20251201130925_5hA83 USL00Q 2025-12-03T14:14:00.958Z 2025-12-06T14:31:23.866Z
8671835 8671835 20251201130414_3k5iO USL00Q 2025-12-03T14:13:54.450Z 2025-12-06T14:31:21.413Z
8671800 8671800 20251201130112_2phFI USL00Q 2025-12-03T14:13:49.369Z 2025-12-06T14:31:20.095Z
8671736 8671736 20251201125429_NZ3SK USL00Q 2025-12-03T14:13:33.610Z 2025-12-06T14:31:17.953Z
8671524 8671524 20251201123019_tF8m3 USL00Q 2025-12-03T14:12:54.570Z 2025-12-06T14:31:09.877Z
8671244 8671244 20251201114449_rDkt1 USL00Q 2025-12-03T14:11:53.799Z 2025-12-06T14:30:48.669Z
8671228 8671228 20251201114206_VyM6H USL00Q 2025-12-03T14:11:51.985Z 2025-12-06T14:30:48.291Z
8671223 8671223 20251201113852_yf2er USL00Q 2025-12-03T14:11:48.661Z 2025-12-06T14:30:47.893Z
8671208 8671208 20251201113402_l4XZF USL00Q 2025-12-03T14:11:46.096Z 2025-12-06T14:30:47.338Z
8671088 8671088 20251201111059_X8UoZ USL00Q 2025-12-03T14:11:14.027Z 2025-12-06T14:30:42.974Z
8671073 8671073 20251201111044_GegC4 USL00Q 2025-12-03T14:11:12.890Z 2025-12-06T14:30:42.518Z
8671066 8671066 20251201110952_smuqN USL00Q 2025-12-03T14:11:11.658Z 2025-12-06T14:30:41.936Z
8671031 8671031 20251201110555_Py9Yh USL00Q 2025-12-03T14:11:07.830Z 2025-12-06T14:30:40.478Z
8671021 8671021 20251201110424_Rfy3e USL00Q 2025-12-03T14:11:06.270Z 2025-12-06T14:30:40.078Z
8671013 8671013 20251201110251_mSGHy USL00Q 2025-12-03T14:11:04.786Z 2025-12-06T14:30:39.765Z
8671008 8671008 20251201110116_5vbrg USL00Q 2025-12-03T14:11:03.033Z 2025-12-06T14:30:39.375Z
8671004 8671004 20251201110113_trUkS USL00Q 2025-12-03T14:11:02.654Z 2025-12-06T14:30:39.275Z
8670940 8670940 20251201105014_Xg7xd USL00Q 2025-12-03T14:10:47.237Z 2025-12-06T14:30:37.241Z
8670911 8670911 20251201104505_2DlZ1 USL00Q 2025-12-03T14:10:41.679Z 2025-12-06T14:30:35.031Z
8670843 8670843 20251201103110_IMeea USL00Q 2025-12-03T14:10:31.254Z 2025-12-06T14:30:27.029Z
8670786 8670786 20251201101316_VsA2X USL00Q 2025-12-03T14:10:06.533Z 2025-12-06T14:30:22.015Z
8670771 8670771 20251201101022_9NCKW USL00Q 2025-12-03T14:10:02.717Z 2025-12-06T14:30:21.258Z
8670673 8670673 20251201095526_pTOgs USL00Q 2025-12-03T14:09:43.783Z 2025-12-06T14:30:15.701Z
8670621 8670621 20251201094534_pN7bc USL00Q 2025-12-03T14:09:34.075Z 2025-12-06T14:30:12.381Z
8670480 8670480 20251201090401_7U22d USL00Q 2025-12-03T14:08:57.942Z 2025-12-06T14:29:59.721Z
8670398 8670398 20251201083510_czGo4 USL00Q 2025-12-03T14:08:31.957Z 2025-12-06T14:29:56.357Z
8670390 8670390 20251201082812_vkr5g USL00Q 2025-12-03T14:08:29.238Z 2025-12-06T14:29:54.094Z
8670371 8670371 20251201074500_uy9gt USL00Q 2025-12-03T14:08:22.460Z 2025-12-06T14:29:52.381Z
8668323 8668323 20251130072311_zjsNC USL00Q 2025-12-02T14:42:19.250Z 2025-12-06T14:50:30.440Z
8668311 8668311 20251130071723_YlJvM USL00Q 2025-12-02T14:42:18.089Z 2025-12-06T14:50:30.153Z
8668278 8668278 20251130070645_EL7Ay USL00Q 2025-12-02T14:42:16.155Z 2025-12-06T14:50:29.344Z
8668248 8668248 20251130065457_RZ8DD USL00Q 2025-12-02T14:42:14.450Z 2025-12-06T14:50:28.555Z
8668205 8668205 20251130064022_qiJvN USL00Q 2025-12-02T14:42:11.243Z 2025-12-06T14:50:26.656Z
8668193 8668193 20251130063318_2dsj7 USL00Q 2025-12-02T14:42:09.641Z 2025-12-06T14:50:26.054Z
8668173 8668173 20251130063043_Zt7Ue USL00Q 2025-12-02T14:42:08.349Z 2025-12-06T14:50:25.587Z
8668155 8668155 20251130062106_9JaKp USL00Q 2025-12-02T14:42:05.803Z 2025-12-06T14:50:24.657Z
8668148 8668148 20251130061739_B7kz6 USL00Q 2025-12-02T14:42:04.924Z 2025-12-06T14:50:23.994Z
8668140 8668140 20251130061609_ZpgSP USL00Q 2025-12-02T14:42:04.446Z 2025-12-06T14:50:23.700Z
8667964 8667964 20251130052932_OKQaO USL00Q 2025-12-02T14:41:24.321Z 2025-12-06T14:49:44.690Z
8667935 8667935 20251130051356_86ss1 USL00Q 2025-12-02T14:41:20.016Z 2025-12-06T14:49:42.363Z
8667930 8667930 20251130051128_ofC9B USL00Q 2025-12-02T14:41:19.229Z 2025-12-06T14:49:41.931Z
8667880 8667880 20251130045033_qztpv USL00Q 2025-12-02T14:41:09.243Z 2025-12-06T14:49:33.759Z
8667819 8667819 20251130041706_wpyv4 USL00Q 2025-12-02T14:40:29.706Z 2025-12-06T14:49:27.514Z
8667794 8667794 20251130040617_3mIG7 USL00Q 2025-12-02T14:40:24.530Z 2025-12-06T14:49:24.748Z
8667650 8667650 20251130030535_kwHA3 USL00Q 2025-12-02T14:39:35.348Z 2025-12-06T14:48:39.379Z
8666907 8666907 20251201070740_Kn23W USL00Q 2025-12-02T14:30:42.736Z 2025-12-06T14:42:43.020Z
8666828 8666828 20251201040811_vIWLQ USL00Q 2025-12-02T14:28:11.243Z 2025-12-06T14:42:06.506Z
8660614 8660614 20251130131533_aixdk USL00Q 2025-12-02T14:08:31.112Z 2025-12-06T14:37:20.252Z
8660565 8660565 20251130130418_fEV2v USL00Q 2025-12-02T14:08:17.736Z 2025-12-06T14:37:19.052Z
8660533 8660533 20251130130214_PgbvN USL00Q 2025-12-02T14:08:14.013Z 2025-12-06T14:37:18.558Z
8660526 8660526 20251130130154_bDCqN USL00Q 2025-12-02T14:08:13.125Z 2025-12-06T14:37:18.369Z
8660517 8660517 20251130130107_gi8kR USL00Q 2025-12-02T14:08:12.259Z 2025-12-06T14:37:18.217Z
8660459 8660459 20251130125254_SCGUT USL00Q 2025-12-02T14:07:54.937Z 2025-12-06T14:37:16.429Z
8660404 8660404 20251130124919_9Z1cy USL00Q 2025-12-02T14:07:46.876Z 2025-12-06T14:37:15.422Z
8660318 8660318 20251130122750_aJplu USL00Q 2025-12-02T14:07:20.895Z 2025-12-06T14:36:59.996Z
8660312 8660312 20251130122721_EblSW USL00Q 2025-12-02T14:07:19.475Z 2025-12-06T14:36:59.772Z
8660282 8660282 20251130122247_cgoeD USL00Q 2025-12-02T14:07:13.301Z 2025-12-06T14:36:58.923Z
8660244 8660244 20251130121206_02VSx USL00Q 2025-12-02T14:07:01.198Z 2025-12-06T14:36:57.801Z
8660214 8660214 20251130120621_Kfz4u USL00Q 2025-12-02T14:06:56.509Z 2025-12-06T14:36:56.879Z
8660166 8660166 20251130120130_rj2GU USL00Q 2025-12-02T14:06:47.118Z 2025-12-06T14:36:54.146Z
8660156 8660156 20251130115947_mgBC1 USL00Q 2025-12-02T14:06:45.105Z 2025-12-06T14:36:53.962Z
8660150 8660150 20251130115935_E61e7 USL00Q 2025-12-02T14:06:43.826Z 2025-12-06T14:36:53.803Z
8660066 8660066 20251130115127_ohskF USL00Q 2025-12-02T14:06:24.590Z 2025-12-06T14:36:51.708Z
8660046 8660046 20251130114816_veHVf USL00Q 2025-12-02T14:06:21.551Z 2025-12-06T14:36:51.230Z
8660023 8660023 20251130114307_Raxf2 USL00Q 2025-12-02T14:06:15.313Z 2025-12-06T14:36:50.329Z
8659994 8659994 20251130113818_JvxX9 USL00Q 2025-12-02T14:06:01.787Z 2025-12-06T14:36:49.420Z
8659938 8659938 20251130113126_ttX0z USL00Q 2025-12-02T14:05:51.904Z 2025-12-06T14:36:47.745Z
8659901 8659901 20251130112820_1WqxH USL00Q 2025-12-02T14:05:46.261Z 2025-12-06T14:36:46.815Z
8659785 8659785 20251130111501_n532O USL00Q 2025-12-02T14:05:17.903Z 2025-12-06T14:36:41.953Z
8659723 8659723 20251130110813_GV9LQ USL00Q 2025-12-02T14:05:08.368Z 2025-12-06T14:36:40.488Z
8659634 8659634 20251130105808_kiOSY USL00Q 2025-12-02T14:04:41.608Z 2025-12-06T14:36:25.865Z
8659611 8659611 20251130105444_Pmooo USL00Q 2025-12-02T14:04:38.343Z 2025-12-06T14:36:25.145Z
8659554 8659554 20251130104723_x64xq USL00Q 2025-12-02T14:04:26.421Z 2025-12-06T14:36:23.277Z
8659488 8659488 20251130103359_smGGV USL00Q 2025-12-02T14:04:08.315Z 2025-12-06T14:36:20.450Z
8659478 8659478 20251130103327_03u2E USL00Q 2025-12-02T14:04:06.390Z 2025-12-06T14:36:20.007Z
8659425 8659425 20251130102602_TN4Ef USL00Q 2025-12-02T14:03:51.627Z 2025-12-06T14:36:17.853Z
8659378 8659378 20251130101705_CcW2Q USL00Q 2025-12-02T14:03:45.105Z 2025-12-06T14:36:16.794Z
8659375 8659375 20251130101649_2OR3e USL00Q 2025-12-02T14:03:44.372Z 2025-12-06T14:36:16.738Z
8659360 8659360 20251130101453_r8nRk USL00Q 2025-12-02T14:03:37.155Z 2025-12-06T14:36:16.101Z
8659358 8659358 20251130101424_8JArf USL00Q 2025-12-02T14:03:36.682Z 2025-12-06T14:36:15.911Z
8659344 8659344 20251130101242_l4VV7 USL00Q 2025-12-02T14:03:33.643Z 2025-12-06T14:36:15.445Z
8659313 8659313 20251130100813_3Fv3y USL00Q 2025-12-02T14:03:27.712Z 2025-12-06T14:36:13.978Z
8659295 8659295 20251130100407_R2RLO USL00Q 2025-12-02T14:03:23.904Z 2025-12-06T14:36:13.347Z
8659268 8659268 20251130100155_uj0Ux USL00Q 2025-12-02T14:03:19.550Z 2025-12-06T14:36:12.717Z
8659251 8659251 20251130095856_HQszw USL00Q 2025-12-02T14:03:14.848Z 2025-12-06T14:36:12.302Z
8659197 8659197 20251130094432_kHa12 USL00Q 2025-12-02T14:02:54.414Z 2025-12-06T14:36:10.404Z
8659166 8659166 20251130094120_RTD7J USL00Q 2025-12-02T14:02:47.724Z 2025-12-06T14:36:09.259Z
8659154 8659154 20251130094111_PiZu7 USL00Q 2025-12-02T14:02:46.506Z 2025-12-06T14:36:09.051Z
8659134 8659134 20251130093754_PW3XH USL00Q 2025-12-02T14:02:42.946Z 2025-12-06T14:36:08.384Z
8659067 8659067 20251130092843_82rsv USL00Q 2025-12-02T14:02:26.569Z 2025-12-06T14:36:05.136Z
8659035 8659035 20251130092014_BPJdl USL00Q 2025-12-02T14:02:19.225Z 2025-12-06T14:36:03.523Z
8658994 8658994 20251130091614_gHAv2 USL00Q 2025-12-02T14:02:04.685Z 2025-12-06T14:36:02.158Z
8658973 8658973 20251130090838_C2H0N USL00Q 2025-12-02T14:01:58.076Z 2025-12-06T14:36:00.954Z
8658949 8658949 20251130090110_3UETS USL00Q 2025-12-02T14:01:47.099Z 2025-12-06T14:35:58.537Z
8658819 8658819 20251130082248_6nwkc USL00Q 2025-12-02T14:01:00.016Z 2025-12-06T14:35:42.105Z
8658815 8658815 20251130081725_yXcra USL00Q 2025-12-02T14:00:58.440Z 2025-12-06T14:35:42.026Z
8658800 8658800 20251130081035_ZocBM USL00Q 2025-12-02T14:00:54.585Z 2025-12-06T14:35:41.667Z
8658784 8658784 20251130080608_QrqDc USL00Q 2025-12-02T14:00:50.806Z 2025-12-06T14:35:41.143Z
8658778 8658778 20251130080352_gkWV1 USL00Q 2025-12-02T14:00:48.619Z 2025-12-06T14:35:40.853Z

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