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

528 rows where station_code = "US004E" 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
8638056 8638056 20251128081547_hrNQn US004E 2025-11-29T14:28:26.972Z 2025-12-05T15:00:45.379Z
8637963 8637963 20251128074026_s2LRv US004E 2025-11-29T14:28:20.359Z 2025-12-05T15:00:38.584Z
8637914 8637914 20251128072934_UdtbH US004E 2025-11-29T14:28:06.843Z 2025-12-05T15:00:34.478Z
8637848 8637848 20251128065218_tUFiV US004E 2025-11-29T14:27:55.501Z 2025-12-05T15:00:32.072Z
8637785 8637785 20251128064050_C6t2K US004E 2025-11-29T14:27:52.137Z 2025-12-05T15:00:27.178Z
8637256 8637256 20251128052101_sK6Q2 US004E 2025-11-29T14:27:01.500Z 2025-12-05T14:59:39.397Z
8637179 8637179 20251128051204_kaKDW US004E 2025-11-29T14:26:56.599Z 2025-12-05T14:59:38.352Z
8636538 8636538 20251128035557_azUk6 US004E 2025-11-29T14:25:38.099Z 2025-12-05T14:59:25.644Z
8627534 8627534 20251128111132_4xMQV US004E 2025-11-29T14:03:55.417Z 2025-12-05T14:47:01.535Z
8626715 8626715 20251128092701_F2Akm US004E 2025-11-29T14:01:18.367Z 2025-12-05T14:46:17.379Z
8626530 8626530 20251128085512_7mC3b US004E 2025-11-29T14:00:38.847Z 2025-12-05T14:46:12.573Z
8582884 8582884 20251123090429_Xhrtp US004E 2025-11-24T14:34:35.531Z 2025-12-01T15:22:29.110Z
8582873 8582873 20251123090221_g7re5 US004E 2025-11-24T14:34:34.993Z 2025-12-01T15:22:28.891Z
8582748 8582748 20251123081945_TVd2X US004E 2025-11-24T14:34:28.881Z 2025-12-01T15:22:27.473Z
8582392 8582392 20251123060006_czrlk US004E 2025-11-24T14:33:33.242Z 2025-12-01T15:22:23.113Z
8582011 8582011 20251123033811_H66WR US004E 2025-11-24T14:33:04.311Z 2025-12-01T15:22:13.878Z
8500444 8500444 20251116085805_leTbA US004E 2025-11-18T14:46:19.000Z 2025-11-24T15:05:41.895Z
8500167 8500167 20251116075453_2SgY3 US004E 2025-11-18T14:45:35.344Z 2025-11-24T15:05:35.081Z
8500152 8500152 20251116075144_cagpF US004E 2025-11-18T14:45:34.662Z 2025-11-24T15:05:34.755Z
8500040 8500040 20251116072131_2Ejpq US004E 2025-11-18T14:45:28.165Z 2025-11-24T15:05:30.561Z
8482224 8482224 20251116055000_lmjzr US004E 2025-11-17T14:22:54.995Z 2025-11-24T15:05:22.354Z
8480873 8480873 20251116003520_DX9L0 US004E 2025-11-17T14:19:20.452Z 2025-11-24T15:04:56.828Z
8461022 8461022 20251114082852_MwqAm US004E 2025-11-15T14:23:27.988Z 2025-11-22T15:23:00.804Z
8460426 8460426 20251114065731_rnZcS US004E 2025-11-15T14:22:05.689Z 2025-11-22T15:22:37.002Z
8459644 8459644 20251114041809_Oi8kL US004E 2025-11-15T14:20:10.917Z 2025-11-22T15:22:07.650Z
8452036 8452036 20251113103131_xe8T2 US004E 2025-11-14T14:27:23.171Z 2025-11-21T15:13:39.227Z
8448890 8448890 20251113004012_OnbjL US004E 2025-11-14T14:18:50.165Z 2025-11-21T15:11:40.566Z
8370466 8370466 20251104021024_nKROx US004E 2025-11-05T14:11:09.780Z 2025-11-12T15:10:41.307Z
8357821 8357821 20251102071645_PB2f8 US004E 2025-11-03T14:43:44.115Z 2025-11-10T15:09:59.274Z
8338719 8338719 20251031091310_J35rZ US004E 2025-11-02T14:33:11.325Z 2025-11-08T15:17:09.887Z
8327558 8327558 20251030112305_jLO5S US004E 2025-11-01T12:37:29.035Z 2025-11-07T15:19:03.236Z
8326477 8326477 20251030094505_OLnhT US004E 2025-11-01T12:35:34.794Z 2025-11-07T15:18:07.004Z
8326350 8326350 20251030093413_wFp9r US004E 2025-11-01T12:35:27.727Z 2025-11-07T15:17:51.582Z
8326043 8326043 20251030085934_y4Tls US004E 2025-11-01T12:35:12.801Z 2025-11-07T15:17:40.080Z
8325707 8325707 20251030081415_3jrsR US004E 2025-11-01T12:34:23.205Z 2025-11-07T15:17:28.427Z
8325475 8325475 20251030075207_LQ0l3 US004E 2025-11-01T12:34:11.140Z 2025-11-07T15:17:22.947Z
8325467 8325467 20251030074940_iAqaf US004E 2025-11-01T12:34:10.658Z 2025-11-07T15:17:22.814Z
8324722 8324722 20251030062021_TLA2h US004E 2025-11-01T12:33:00.382Z 2025-11-07T15:17:12.182Z
8323311 8323311 20251030044932_ofyau US004E 2025-11-01T12:30:32.389Z 2025-11-07T15:15:56.315Z
8227069 8227069 20251024101449_sxZRv US004E 2025-10-26T12:45:21.454Z 2025-11-01T13:11:28.313Z
8225021 8225021 20251024072951_DxvOX US004E 2025-10-26T12:43:00.631Z 2025-11-01T13:11:20.926Z
8224984 8224984 20251024072753_3yDJM US004E 2025-10-26T12:42:59.412Z 2025-11-01T13:11:20.869Z
8222707 8222707 20251024045640_af6S2 US004E 2025-10-26T12:39:54.391Z 2025-11-01T13:11:14.813Z
8216150 8216150 20251024015634_gjcZp US004E 2025-10-26T12:31:50.092Z 2025-11-01T13:10:30.738Z
8204762 8204762 20251023111848_tYKD3 US004E 2025-10-25T12:28:05.207Z 2025-10-31T13:09:14.724Z
8204708 8204708 20251023111122_wHHlJ US004E 2025-10-25T12:27:59.494Z 2025-10-31T13:09:14.434Z
8204414 8204414 20251023104217_MaT7n US004E 2025-10-25T12:27:21.970Z 2025-10-31T13:09:06.731Z
8204368 8204368 20251023103823_8XN9D US004E 2025-10-25T12:27:17.545Z 2025-10-31T13:09:06.478Z
8204230 8204230 20251023102524_32AJB US004E 2025-10-25T12:26:43.894Z 2025-10-31T13:09:05.837Z
8203736 8203736 20251023093644_FfapX US004E 2025-10-25T12:25:33.884Z 2025-10-31T13:09:02.471Z
8203567 8203567 20251023091628_imjbr US004E 2025-10-25T12:25:02.673Z 2025-10-31T13:09:01.202Z
8203480 8203480 20251023091017_bCd75 US004E 2025-10-25T12:24:42.417Z 2025-10-31T13:08:59.913Z
8203079 8203079 20251023082219_4fFN4 US004E 2025-10-25T12:23:21.438Z 2025-10-31T13:08:58.885Z
8203060 8203060 20251023082012_hdPva US004E 2025-10-25T12:23:17.476Z 2025-10-31T13:08:58.727Z
8202750 8202750 20251023072738_7KLQn US004E 2025-10-25T12:22:26.465Z 2025-10-31T13:08:56.716Z
8201207 8201207 20251023031928_HrC1g US004E 2025-10-25T12:16:01.484Z 2025-10-31T13:08:43.480Z
8201141 8201141 20251023025927_TuuNr US004E 2025-10-25T12:15:35.079Z 2025-10-31T13:08:41.500Z
8186624 8186624 20251021111414_IeUDq US004E 2025-10-23T12:38:12.845Z 2025-10-29T13:08:16.415Z
8186280 8186280 20251021105056_a4tpd US004E 2025-10-23T12:37:13.001Z 2025-10-29T13:08:15.245Z
8185921 8185921 20251021102012_7xmV6 US004E 2025-10-23T12:36:32.944Z 2025-10-29T13:08:13.513Z
8185405 8185405 20251021095152_WaSJi US004E 2025-10-23T12:36:16.513Z 2025-10-29T13:08:07.862Z
8185171 8185171 20251021093314_JRg0M US004E 2025-10-23T12:36:07.293Z 2025-10-29T13:08:03.470Z
8184658 8184658 20251021090031_O42eB US004E 2025-10-23T12:34:45.096Z 2025-10-29T13:07:58.032Z
8184602 8184602 20251021085627_WivO3 US004E 2025-10-23T12:34:42.535Z 2025-10-29T13:07:57.245Z
8184330 8184330 20251021083629_pUwQH US004E 2025-10-23T12:34:31.430Z 2025-10-29T13:07:56.139Z
8184289 8184289 20251021083337_67ptJ US004E 2025-10-23T12:34:29.474Z 2025-10-29T13:07:55.882Z
8183602 8183602 20251021074128_2T9mh US004E 2025-10-23T12:33:04.304Z 2025-10-29T13:07:51.185Z
8172268 8172268 20251020095705_06o3U US004E 2025-10-22T12:42:16.140Z 2025-10-28T13:09:24.926Z
8172240 8172240 20251020095506_FaCrv US004E 2025-10-22T12:42:14.876Z 2025-10-28T13:09:24.616Z
8171986 8171986 20251020094032_GfnGE US004E 2025-10-22T12:42:01.671Z 2025-10-28T13:09:19.737Z
8171984 8171984 20251020094029_MNjib US004E 2025-10-22T12:42:01.379Z 2025-10-28T13:09:19.734Z
8171786 8171786 20251020092740_uD26n US004E 2025-10-22T12:41:31.467Z 2025-10-28T13:09:17.991Z
8171502 8171502 20251020090919_1g3tR US004E 2025-10-22T12:40:53.864Z 2025-10-28T13:09:15.270Z
8170928 8170928 20251020082600_q24j0 US004E 2025-10-22T12:40:34.344Z 2025-10-28T13:09:11.001Z
8170881 8170881 20251020082150_37USN US004E 2025-10-22T12:40:32.805Z 2025-10-28T13:09:10.112Z
8170775 8170775 20251020081435_3P1Bq US004E 2025-10-22T12:40:15.296Z 2025-10-28T13:09:09.159Z
8168896 8168896 20251020044756_6r8cn US004E 2025-10-22T12:36:43.759Z 2025-10-28T13:08:59.567Z
8168582 8168582 20251020040547_5r59C US004E 2025-10-22T12:36:16.447Z 2025-10-28T13:08:57.466Z
8168509 8168509 20251020035836_3YPhq US004E 2025-10-22T12:35:47.874Z 2025-10-28T13:08:56.155Z
8168404 8168404 20251020034617_mxdzt US004E 2025-10-22T12:35:37.602Z 2025-10-28T13:08:54.905Z
8166902 8166902 20251020014043_385Xt US004E 2025-10-22T12:32:18.595Z 2025-10-28T13:08:27.725Z
8166170 8166170 20251020002752_Wzo7q US004E 2025-10-22T12:30:05.725Z 2025-10-28T13:08:15.561Z
8136922 8136922 20251018090439_WGVHz US004E 2025-10-19T12:20:33.602Z 2025-10-26T13:16:17.664Z
8136844 8136844 20251018085523_zaDnu US004E 2025-10-19T12:20:28.547Z 2025-10-26T13:16:17.313Z
8134394 8134394 20251018043037_wwC8e US004E 2025-10-19T12:15:37.062Z 2025-10-26T13:15:55.761Z
8123685 8123685 20251017040227_dSzsl US004E 2025-10-18T12:27:08.066Z 2025-10-25T13:29:11.104Z
8122817 8122817 20251017023647_Ipzcg US004E 2025-10-18T12:24:47.020Z 2025-10-25T13:28:52.921Z
8099576 8099576 20251014054240_Ks1QF US004E 2025-10-15T12:19:27.551Z 2025-10-22T13:10:14.553Z
8093194 8093194 20251013031632_E3pfO US004E 2025-10-14T12:12:42.867Z 2025-10-21T13:09:42.861Z
8092588 8092588 20251013004340_5X2CH US004E 2025-10-14T12:11:01.059Z 2025-10-21T13:09:25.931Z
8089093 8089093 20251012102319_ii3FU US004E 2025-10-13T12:15:22.452Z 2025-10-20T13:04:11.190Z
8088814 8088814 20251012090837_b3Ygd US004E 2025-10-13T12:14:58.594Z 2025-10-20T13:04:06.355Z
8088754 8088754 20251012084933_nWSU2 US004E 2025-10-13T12:14:27.786Z 2025-10-20T13:04:05.803Z
8088593 8088593 20251012081112_ixKb9 US004E 2025-10-13T12:14:04.860Z 2025-10-20T13:04:04.050Z
8088374 8088374 20251012065814_Gd3Jj US004E 2025-10-13T12:13:20.888Z 2025-10-20T13:04:00.514Z
8088263 8088263 20251012061456_3k5cc US004E 2025-10-13T12:13:07.630Z 2025-10-20T13:03:57.197Z
8088230 8088230 20251012055248_HZ2UP US004E 2025-10-13T12:13:05.003Z 2025-10-20T13:03:56.499Z
8080088 8080088 20251010093935_D1MrE US004E 2025-10-11T12:14:21.343Z 2025-10-18T13:00:28.199Z
8080084 8080084 20251010093933_g4tYD US004E 2025-10-11T12:14:18.872Z 2025-10-18T13:00:28.188Z
8079861 8079861 20251010084655_8hOZq US004E 2025-10-11T12:13:40.407Z 2025-10-18T13:00:25.691Z

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