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

3,353 rows where station_code = "US005D" 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
8687262 8687262 20251204063221_bZn3S US005D 2025-12-05T14:14:32.648Z 2025-12-05T14:14:35.671Z
8687046 8687046 20251204021727_E8R9T US005D 2025-12-05T14:13:43.565Z 2025-12-05T14:14:35.587Z
8684461 8684461 20251204124350_R5goV US005D 2025-12-05T14:03:24.704Z 2025-12-05T14:03:24.704Z
8684282 8684282 20251204115503_kpnog US005D 2025-12-05T14:02:36.489Z 2025-12-05T14:02:36.489Z
8684203 8684203 20251204112014_axgEq US005D 2025-12-05T14:02:10.195Z 2025-12-05T14:02:10.195Z
8684185 8684185 20251204111708_daM3p US005D 2025-12-05T14:02:08.117Z 2025-12-05T14:02:08.117Z
8684183 8684183 20251204111337_1KdIM US005D 2025-12-05T14:02:07.426Z 2025-12-05T14:02:07.426Z
8684091 8684091 20251204103638_92O7i US005D 2025-12-05T14:01:50.348Z 2025-12-05T14:01:50.348Z
8683985 8683985 20251204095957_sUrXE US005D 2025-12-05T14:01:27.425Z 2025-12-05T14:01:27.425Z
8683972 8683972 20251204095025_EZfvu US005D 2025-12-05T14:01:23.696Z 2025-12-05T14:01:23.696Z
8683968 8683968 20251204094851_Qk352 US005D 2025-12-05T14:01:23.037Z 2025-12-05T14:01:23.037Z
8683872 8683872 20251204090730_3u9j1 US005D 2025-12-05T14:00:57.621Z 2025-12-05T14:00:57.621Z
8683868 8683868 20251204090722_X4SUH US005D 2025-12-05T14:00:56.416Z 2025-12-05T14:00:56.416Z
8683836 8683836 20251204085636_EA4TN US005D 2025-12-05T14:00:50.781Z 2025-12-05T14:00:50.781Z
8683827 8683827 20251204084634_4cZjJ US005D 2025-12-05T14:00:48.862Z 2025-12-05T14:00:48.862Z
8683788 8683788 20251204080920_I2mq3 US005D 2025-12-05T14:00:37.986Z 2025-12-05T14:00:37.986Z
8683727 8683727 20251204072520_Uowbb US005D 2025-12-05T14:00:22.233Z 2025-12-05T14:00:22.233Z
8683712 8683712 20251204070615_lwRO3 US005D 2025-12-05T14:00:18.174Z 2025-12-05T14:00:18.174Z
8683132 8683132 20251203062929_P5m4g US005D 2025-12-04T14:18:36.123Z 2025-12-05T14:23:08.320Z
8682479 8682479 20251203053922_ndpv5 US005D 2025-12-04T14:17:17.567Z 2025-12-05T14:22:40.183Z
8680999 8680999 20251203021130_ReuDv US005D 2025-12-04T14:13:31.900Z 2025-12-05T14:21:10.488Z
8678443 8678443 20251202125830_ade5F US005D 2025-12-04T14:06:49.165Z 2025-12-05T14:18:09.188Z
8677423 8677423 20251203094906_KqrCU US005D 2025-12-04T14:01:09.554Z 2025-12-05T14:14:34.836Z
8677354 8677354 20251203091152_eVk4t US005D 2025-12-04T14:00:53.326Z 2025-12-05T14:14:34.811Z
8677260 8677260 20251203080344_GGqmN US005D 2025-12-04T14:00:31.112Z 2025-12-05T14:14:34.779Z
8677253 8677253 20251203075858_SNGvT US005D 2025-12-04T14:00:30.302Z 2025-12-05T14:14:34.778Z
8677135 8677135 20251202070059_y9cE6 US005D 2025-12-03T14:26:20.998Z 2025-12-05T14:29:22.504Z
8677114 8677114 20251202065254_J1sVJ US005D 2025-12-03T14:26:18.988Z 2025-12-05T14:29:21.567Z
8677104 8677104 20251202065203_V5ymX US005D 2025-12-03T14:26:18.426Z 2025-12-05T14:29:21.318Z
8676565 8676565 20251202060223_hbOxr US005D 2025-12-03T14:25:19.311Z 2025-12-05T14:29:07.959Z
8676395 8676395 20251202055129_CYbMg US005D 2025-12-03T14:25:11.037Z 2025-12-05T14:28:55.876Z
8676085 8676085 20251202053516_BhIMD US005D 2025-12-03T14:24:41.336Z 2025-12-05T14:28:48.309Z
8675817 8675817 20251202051536_A2QSn US005D 2025-12-03T14:24:16.654Z 2025-12-05T14:28:41.282Z
8674536 8674536 20251202024317_AYyR1 US005D 2025-12-03T14:21:46.161Z 2025-12-05T14:27:54.645Z
8671427 8671427 20251201121740_3rDYE US005D 2025-12-03T14:12:27.206Z 2025-12-05T14:24:28.482Z
8671309 8671309 20251201115710_do1lB US005D 2025-12-03T14:12:06.997Z 2025-12-05T14:24:23.229Z
8671141 8671141 20251201112221_I0GRX US005D 2025-12-03T14:11:25.787Z 2025-12-05T14:24:14.749Z
8671019 8671019 20251201110347_NxWnP US005D 2025-12-03T14:11:05.725Z 2025-12-05T14:24:02.948Z
8670659 8670659 20251201095405_itx7Z US005D 2025-12-03T14:09:40.299Z 2025-12-05T14:23:43.840Z
8670129 8670129 20251202131601_FXEA2 US005D 2025-12-03T14:07:00.012Z 2025-12-05T14:18:13.865Z
8670066 8670066 20251202125918_CRdWw US005D 2025-12-03T14:06:39.589Z 2025-12-05T14:18:09.313Z
8670008 8670008 20251202124552_seGuy US005D 2025-12-03T14:06:28.878Z 2025-12-05T14:18:05.338Z
8669985 8669985 20251202124056_fLT6x US005D 2025-12-03T14:06:21.601Z 2025-12-05T14:18:03.971Z
8669954 8669954 20251202123338_9v8S2 US005D 2025-12-03T14:06:07.968Z 2025-12-05T14:17:59.817Z
8669866 8669866 20251202121847_scK0k US005D 2025-12-03T14:05:52.224Z 2025-12-05T14:17:52.920Z
8669799 8669799 20251202121243_U8UB0 US005D 2025-12-03T14:05:28.932Z 2025-12-05T14:17:48.882Z
8669614 8669614 20251202114220_biAw9 US005D 2025-12-03T14:04:42.485Z 2025-12-05T14:17:35.440Z
8669603 8669603 20251202114119_TAIce US005D 2025-12-03T14:04:40.696Z 2025-12-05T14:17:34.960Z
8669524 8669524 20251202112636_35H4d US005D 2025-12-03T14:04:19.109Z 2025-12-05T14:17:28.310Z
8669394 8669394 20251202110626_1F9rF US005D 2025-12-03T14:03:33.882Z 2025-12-05T14:17:18.229Z
8669372 8669372 20251202110159_hVBvV US005D 2025-12-03T14:03:29.029Z 2025-12-05T14:17:16.404Z
8669288 8669288 20251202104544_ce81Y US005D 2025-12-03T14:03:16.675Z 2025-12-05T14:17:03.709Z
8668977 8668977 20251202094326_3AYoL US005D 2025-12-03T14:01:52.254Z 2025-12-05T14:16:33.857Z
8668738 8668738 20251202084428_xMun3 US005D 2025-12-03T14:00:59.438Z 2025-12-05T14:15:09.304Z
8668701 8668701 20251202082838_1lNxj US005D 2025-12-03T14:00:53.207Z 2025-12-05T14:15:02.936Z
8668656 8668656 20251202081103_fojjm US005D 2025-12-03T14:00:44.439Z 2025-12-05T14:14:51.127Z
8668538 8668538 20251202072906_pdzIg US005D 2025-12-03T14:00:16.449Z 2025-12-05T14:14:38.840Z
8668521 8668521 20251202072429_GhJVG US005D 2025-12-03T14:00:12.880Z 2025-12-05T14:14:38.141Z
8668160 8668160 20251130062329_CwsC9 US005D 2025-12-02T14:42:06.549Z 2025-12-05T14:45:59.566Z
8667768 8667768 20251130035328_stNJf US005D 2025-12-02T14:40:18.660Z 2025-12-05T14:44:31.345Z
8667459 8667459 20251130013834_2D2Oh US005D 2025-12-02T14:38:19.254Z 2025-12-05T14:42:55.062Z
8667426 8667426 20251130011752_dEkdn US005D 2025-12-02T14:38:07.707Z 2025-12-05T14:42:47.073Z
8659065 8659065 20251130092735_CjLkD US005D 2025-12-02T14:02:25.834Z 2025-12-05T14:29:51.708Z
8658879 8658879 20251130084628_fT7oR US005D 2025-12-02T14:01:21.887Z 2025-12-05T14:29:33.809Z
8658849 8658849 20251130083633_8TAGw US005D 2025-12-02T14:01:11.925Z 2025-12-05T14:29:32.453Z
8648345 8648345 20251129073252_VtCmN US005D 2025-11-30T14:30:05.215Z 2025-12-05T14:53:15.755Z
8648284 8648284 20251129071855_YJcyv US005D 2025-11-30T14:30:01.633Z 2025-12-05T14:53:04.771Z
8647894 8647894 20251129055608_moBnP US005D 2025-11-30T14:29:21.565Z 2025-12-05T14:52:50.081Z
8638636 8638636 20251129091652_S39c3 US005D 2025-11-30T14:01:45.858Z 2025-12-05T14:37:38.026Z
8638014 8638014 20251128080203_IMii3 US005D 2025-11-29T14:28:24.723Z 2025-12-05T15:00:43.140Z
8637873 8637873 20251128070519_wqNkE US005D 2025-11-29T14:27:56.791Z 2025-12-05T15:00:33.033Z
8637833 8637833 20251128064909_jssQL US005D 2025-11-29T14:27:54.551Z 2025-12-05T15:00:30.735Z
8637384 8637384 20251128053509_j2by3 US005D 2025-11-29T14:27:11.509Z 2025-12-05T14:59:48.906Z
8628887 8628887 20251128131748_DrXa2 US005D 2025-11-29T14:07:27.779Z 2025-12-05T14:47:51.483Z
8628836 8628836 20251128131250_dbnQ7 US005D 2025-11-29T14:07:13.083Z 2025-12-05T14:47:50.914Z
8628722 8628722 20251128130604_Xgjnf US005D 2025-11-29T14:07:00.080Z 2025-12-05T14:47:49.006Z
8628381 8628381 20251128124028_34dyA US005D 2025-11-29T14:06:06.177Z 2025-12-05T14:47:42.043Z
8628097 8628097 20251128121411_1r6FB US005D 2025-11-29T14:05:20.587Z 2025-12-05T14:47:14.002Z
8628015 8628015 20251128120531_9qCFl US005D 2025-11-29T14:05:06.784Z 2025-12-05T14:47:12.073Z
8627881 8627881 20251128114828_JFXXK US005D 2025-11-29T14:04:43.732Z 2025-12-05T14:47:07.798Z
8627745 8627745 20251128113439_BQB0Z US005D 2025-11-29T14:04:26.072Z 2025-12-05T14:47:05.662Z
8627738 8627738 20251128113401_jcuLw US005D 2025-11-29T14:04:24.713Z 2025-12-05T14:47:05.521Z
8627576 8627576 20251128111530_D7yO5 US005D 2025-11-29T14:04:00.556Z 2025-12-05T14:47:02.405Z
8627346 8627346 20251128105230_UzpR3 US005D 2025-11-29T14:03:23.101Z 2025-12-05T14:46:57.976Z
8627290 8627290 20251128104538_wjLFe US005D 2025-11-29T14:03:17.115Z 2025-12-05T14:46:56.830Z
8626812 8626812 20251128093950_2YuLD US005D 2025-11-29T14:01:33.968Z 2025-12-05T14:46:21.226Z
8625479 8625479 20251126015136_ACRBN US005D 2025-11-28T14:33:45.978Z 2025-12-04T15:09:22.610Z
8624924 8624924 20251127071242_sus5y US005D 2025-11-28T14:26:00.700Z 2025-12-05T15:05:32.785Z
8624820 8624820 20251127064319_RcCQl US005D 2025-11-28T14:25:32.323Z 2025-12-05T15:05:28.859Z
8624757 8624757 20251127062914_f5Hfw US005D 2025-11-28T14:25:25.958Z 2025-12-05T15:05:27.083Z
8624668 8624668 20251127055110_RPN8M US005D 2025-11-28T14:25:17.056Z 2025-12-05T15:05:20.044Z
8624344 8624344 20251127041932_lt7Pz US005D 2025-11-28T14:24:30.367Z 2025-12-05T15:04:59.636Z
8624033 8624033 20251127025415_23Eek US005D 2025-11-28T14:23:39.594Z 2025-12-05T15:04:39.873Z
8618356 8618356 20251127120852_PBZME US005D 2025-11-28T14:04:20.326Z 2025-12-05T14:54:13.892Z
8617964 8617964 20251127110050_xEPa3 US005D 2025-11-28T14:02:56.216Z 2025-12-05T14:54:07.048Z
8612522 8612522 20251126023452_CCI5v US005D 2025-11-27T14:24:17.477Z 2025-12-04T15:09:31.332Z
8601785 8601785 20251125041632_9pqvH US005D 2025-11-26T14:24:43.309Z 2025-12-02T15:09:24.542Z
8600383 8600383 20251125025736_AofTF US005D 2025-11-26T14:22:29.003Z 2025-12-02T15:08:43.061Z
8599790 8599790 20251125022337_ZuDjp US005D 2025-11-26T14:21:29.534Z 2025-12-02T15:08:32.133Z
8502185 8502185 20251117125648_oTwVk US005D 2025-11-19T14:01:43.533Z 2025-11-26T15:06:06.955Z

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