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,701 rows where station_code = "US002P" 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
8682631 8682631 20251203055428_MvOx6 US002P 2025-12-04T14:17:45.730Z 2025-12-06T14:29:19.971Z
8682354 8682354 20251203052119_KjYFM US002P 2025-12-04T14:16:58.918Z 2025-12-06T14:28:55.994Z
8677546 8677546 20251203103923_2pSG6 US002P 2025-12-04T14:01:41.578Z 2025-12-06T14:19:37.382Z
8677525 8677525 20251203103424_wCwmt US002P 2025-12-04T14:01:35.026Z 2025-12-06T14:19:35.957Z
8677498 8677498 20251203102630_lXnbx US002P 2025-12-04T14:01:26.929Z 2025-12-06T14:19:33.072Z
8677454 8677454 20251203100839_wgzc0 US002P 2025-12-04T14:01:18.009Z 2025-12-06T14:19:29.703Z
8677398 8677398 20251203093723_4sswu US002P 2025-12-04T14:01:02.588Z 2025-12-06T14:19:22.831Z
8677340 8677340 20251203085557_iuPPS US002P 2025-12-04T14:00:50.244Z 2025-12-06T14:19:17.882Z
8677322 8677322 20251203084349_0oil5 US002P 2025-12-04T14:00:46.836Z 2025-12-06T14:19:11.478Z
8677289 8677289 20251203082259_p3SuO US002P 2025-12-04T14:00:37.964Z 2025-12-06T14:18:53.225Z
8677266 8677266 20251203080514_5e3bi US002P 2025-12-04T14:00:32.146Z 2025-12-06T14:18:43.931Z
8677224 8677224 20251203072847_0WyrD US002P 2025-12-04T14:00:24.851Z 2025-12-06T14:18:17.931Z
8677180 8677180 20251203070101_z0sbm US002P 2025-12-04T14:00:15.808Z 2025-12-06T14:18:07.600Z
8677169 8677169 20251203065655_ZX7WA US002P 2025-12-04T14:00:13.306Z 2025-12-06T14:18:05.415Z
8676948 8676948 20251202063359_t8nRs US002P 2025-12-03T14:25:57.725Z 2025-12-06T14:35:31.613Z
8676818 8676818 20251202062719_tK9Za US002P 2025-12-03T14:25:51.747Z 2025-12-06T14:35:29.352Z
8676543 8676543 20251202060122_Iur7h US002P 2025-12-03T14:25:17.718Z 2025-12-06T14:35:23.343Z
8669686 8669686 20251202115749_hQVqS US002P 2025-12-03T14:05:09.558Z 2025-12-06T14:24:15.130Z
8669681 8669681 20251202115705_nT5bG US002P 2025-12-03T14:05:02.626Z 2025-12-06T14:24:14.576Z
8669568 8669568 20251202113352_A3flL US002P 2025-12-03T14:04:34.047Z 2025-12-06T14:24:03.014Z
8669334 8669334 20251202105404_FrEPk US002P 2025-12-03T14:03:23.897Z 2025-12-06T14:23:49.531Z
8669293 8669293 20251202104743_7EAxX US002P 2025-12-03T14:03:17.736Z 2025-12-06T14:23:47.798Z
8669182 8669182 20251202102931_FkR55 US002P 2025-12-03T14:02:48.869Z 2025-12-06T14:23:39.296Z
8669107 8669107 20251202101300_E2pBM US002P 2025-12-03T14:02:27.897Z 2025-12-06T14:23:32.716Z
8668930 8668930 20251202092824_qDlyg US002P 2025-12-03T14:01:37.410Z 2025-12-06T14:23:21.874Z
8668914 8668914 20251202092428_FdgBe US002P 2025-12-03T14:01:35.769Z 2025-12-06T14:23:21.528Z
8668715 8668715 20251202083809_FpHW6 US002P 2025-12-03T14:00:55.600Z 2025-12-06T14:23:06.502Z
8668629 8668629 20251202080230_HbtK3 US002P 2025-12-03T14:00:36.915Z 2025-12-06T14:22:58.201Z
8668591 8668591 20251202075019_bxuj4 US002P 2025-12-03T14:00:30.577Z 2025-12-06T14:22:56.367Z
8637390 8637390 20251128053550_ZEudB US002P 2025-11-29T14:27:11.876Z 2025-12-06T15:03:59.576Z
8634569 8634569 20251128005912_63Y5y US002P 2025-11-29T14:21:34.148Z 2025-12-06T15:02:21.353Z
8627472 8627472 20251128110330_m2QqE US002P 2025-11-29T14:03:41.210Z 2025-12-06T14:51:18.723Z
8627444 8627444 20251128110024_Xfeda US002P 2025-11-29T14:03:33.742Z 2025-12-06T14:51:18.062Z
8626916 8626916 20251128095829_i7rO8 US002P 2025-11-29T14:02:03.971Z 2025-12-06T14:51:08.544Z
8626829 8626829 20251128094340_K6eEC US002P 2025-11-29T14:01:36.357Z 2025-12-06T14:50:45.884Z
8626337 8626337 20251126085728_LVu6o US002P 2025-11-28T14:38:49.631Z 2025-12-04T15:12:16.441Z
8626280 8626280 20251126084312_UTE3f US002P 2025-11-28T14:38:30.951Z 2025-12-04T15:12:10.587Z
8626209 8626209 20251126081446_KBS97 US002P 2025-11-28T14:38:09.938Z 2025-12-04T15:12:00.543Z
8626173 8626173 20251126080450_yGIEN US002P 2025-11-28T14:38:01.995Z 2025-12-04T15:11:56.045Z
8625777 8625777 20251126051422_O3LlP US002P 2025-11-28T14:36:29.442Z 2025-12-04T15:11:31.482Z
8625612 8625612 20251126033734_rur9i US002P 2025-11-28T14:35:22.833Z 2025-12-04T15:09:52.781Z
8624321 8624321 20251127041357_JWmeb US002P 2025-11-28T14:24:27.984Z 2025-12-05T15:04:59.130Z
8619576 8619576 20251126102852_stlD0 US002P 2025-11-28T14:09:30.016Z 2025-12-05T15:01:02.139Z
8617114 8617114 20251126084142_um36K US002P 2025-11-27T14:32:36.450Z 2025-11-27T14:32:47.173Z
8617019 8617019 20251126081750_HQppd US002P 2025-11-27T14:32:09.496Z 2025-12-04T15:12:01.257Z
8616990 8616990 20251126075920_U25Q8 US002P 2025-11-27T14:32:04.718Z 2025-12-04T15:11:53.881Z
8615761 8615761 20251126051758_RaxjU US002P 2025-11-27T14:30:09.336Z 2025-12-04T15:11:31.959Z
8613900 8613900 20251126033925_aiA70 US002P 2025-11-27T14:26:55.609Z 2025-12-04T15:09:53.367Z
8605114 8605114 20251126110609_lNXig US002P 2025-11-27T14:02:02.790Z 2025-12-05T15:01:10.064Z
8605085 8605085 20251126105736_BepnD US002P 2025-11-27T14:01:53.022Z 2025-12-05T15:01:08.756Z
8605053 8605053 20251126105329_08P4Y US002P 2025-11-27T14:01:46.213Z 2025-12-05T15:01:06.342Z
8605022 8605022 20251126104628_snEPp US002P 2025-11-27T14:01:40.609Z 2025-12-05T15:01:04.577Z
8604938 8604938 20251126102239_ZRwOg US002P 2025-11-27T14:01:13.310Z 2025-12-05T15:01:00.896Z
8604770 8604770 20251126092700_xg97Y US002P 2025-11-27T14:00:32.886Z 2025-12-05T15:00:53.204Z
8604732 8604732 20251126091651_176BC US002P 2025-11-27T14:00:25.087Z 2025-12-05T15:00:50.336Z
8604211 8604211 20251125090202_73vfX US002P 2025-11-26T14:28:41.579Z 2025-12-02T15:09:40.273Z
8593575 8593575 20251125120125_ORR3Y US002P 2025-11-26T14:02:40.759Z 2025-12-04T15:05:20.289Z
8593408 8593408 20251125111503_hpN8g US002P 2025-11-26T14:01:58.210Z 2025-12-04T15:05:17.267Z
8593219 8593219 20251125103843_3bxIq US002P 2025-11-26T14:01:19.340Z 2025-12-04T15:05:13.548Z
8593174 8593174 20251125103029_foAmy US002P 2025-11-26T14:01:12.574Z 2025-12-04T15:05:12.903Z
8593107 8593107 20251125101144_alV97 US002P 2025-11-26T14:00:52.594Z 2025-12-04T15:05:11.478Z
8584224 8584224 20251123111828_Qn8q0 US002P 2025-11-25T14:05:41.830Z 2025-12-02T15:09:47.100Z
8584164 8584164 20251123110938_Q7HW2 US002P 2025-11-25T14:05:35.528Z 2025-12-02T15:09:46.653Z
8584024 8584024 20251123103704_RAiSO US002P 2025-11-25T14:05:04.893Z 2025-12-02T15:09:45.377Z
8582943 8582943 20251123091703_ezdbO US002P 2025-11-24T14:34:38.508Z 2025-12-01T15:22:29.850Z
8582934 8582934 20251123091259_o6Xqn US002P 2025-11-24T14:34:38.077Z 2025-12-01T15:22:29.747Z
8582721 8582721 20251123080819_MwY0e US002P 2025-11-24T14:34:27.055Z 2025-12-01T15:22:27.002Z
8582678 8582678 20251123075137_UEKx3 US002P 2025-11-24T14:34:25.014Z 2025-12-01T15:22:26.476Z
8582661 8582661 20251123074050_wqRuj US002P 2025-11-24T14:34:24.128Z 2025-12-01T15:22:26.321Z
8581743 8581743 20251123020252_dOiyr US002P 2025-11-24T14:32:35.710Z 2025-12-01T15:21:27.375Z
8581699 8581699 20251123014513_NpQbi US002P 2025-11-24T14:32:32.591Z 2025-12-01T15:21:15.730Z
8581566 8581566 20251123005539_x3fUf US002P 2025-11-24T14:31:59.208Z 2025-12-01T15:20:58.522Z
8581159 8581159 20251122095642_w4Yr4 US002P 2025-11-24T14:29:36.557Z 2025-11-30T15:07:21.974Z
8581098 8581098 20251122094233_m9yiy US002P 2025-11-24T14:29:32.259Z 2025-11-30T15:07:21.297Z
8580998 8580998 20251122092149_GvII2 US002P 2025-11-24T14:29:13.344Z 2025-11-30T15:07:19.168Z
8580981 8580981 20251122091615_vL3U2 US002P 2025-11-24T14:29:10.967Z 2025-11-30T15:07:19.046Z
8580856 8580856 20251122081906_D2I6s US002P 2025-11-24T14:29:00.182Z 2025-11-30T15:07:12.511Z
8580840 8580840 20251122080613_n0E7I US002P 2025-11-24T14:28:58.858Z 2025-11-30T15:07:12.234Z
8580832 8580832 20251122080345_zvwWe US002P 2025-11-24T14:28:58.240Z 2025-11-30T15:07:12.122Z
8580797 8580797 20251122074420_rbEYr US002P 2025-11-24T14:28:55.859Z 2025-11-30T15:07:11.612Z
8580792 8580792 20251122074305_9EQE3 US002P 2025-11-24T14:28:55.668Z 2025-11-30T15:07:11.539Z
8580784 8580784 20251122072957_OAKRi US002P 2025-11-24T14:28:55.087Z 2025-11-30T15:07:11.392Z
8580782 8580782 20251122072854_LqXOa US002P 2025-11-24T14:28:54.895Z 2025-11-30T15:07:11.375Z
8580764 8580764 20251122072054_cekXE US002P 2025-11-24T14:28:53.681Z 2025-11-30T15:07:11.243Z
8575150 8575150 20251122114914_lrBDX US002P 2025-11-24T14:02:21.373Z 2025-12-01T15:17:57.107Z
8575042 8575042 20251122112800_OGGpN US002P 2025-11-24T14:01:54.397Z 2025-12-01T15:17:49.555Z
8574810 8574810 20251122104739_6ie5y US002P 2025-11-24T14:01:05.837Z 2025-12-01T15:17:28.008Z
8574699 8574699 20251122102710_3ERfP US002P 2025-11-24T14:00:40.313Z 2025-12-01T15:17:23.760Z
8574622 8574622 20251122101356_XobqM US002P 2025-11-24T14:00:20.113Z 2025-12-01T15:17:16.836Z
8574616 8574616 20251122101154_v3YZx US002P 2025-11-24T14:00:18.178Z 2025-12-01T15:17:16.436Z
8574395 8574395 20251122061950_f5MTe US002P 2025-11-23T14:43:25.437Z 2025-11-30T15:07:07.980Z
8574375 8574375 20251122061105_1mkF8 US002P 2025-11-23T14:43:17.093Z 2025-11-30T15:07:07.694Z
8574373 8574373 20251122061047_exjI1 US002P 2025-11-23T14:43:16.756Z 2025-11-30T15:07:07.692Z
8574234 8574234 20251122053413_7VaRx US002P 2025-11-23T14:42:59.302Z 2025-11-30T15:07:03.296Z
8573843 8573843 20251122042327_z6oGo US002P 2025-11-23T14:42:03.106Z 2025-11-30T15:06:44.459Z
8572858 8572858 20251122015132_NquEK US002P 2025-11-23T14:39:47.330Z 2025-11-30T15:06:04.601Z
8510916 8510916 20251117045324_BYLL4 US002P 2025-11-19T14:29:50.279Z 2025-11-25T15:10:20.850Z
8501726 8501726 20251117111446_WVfU3 US002P 2025-11-19T14:00:13.988Z 2025-11-26T15:05:53.737Z
8501390 8501390 20251116105404_az2K5 US002P 2025-11-18T14:47:22.542Z 2025-11-24T15:06:30.507Z
8501280 8501280 20251116104232_wdZ5g US002P 2025-11-18T14:47:18.967Z 2025-11-24T15:06:27.989Z

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