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

691 rows where station_code = "DE0017" 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
9254352 9254352 20260123183431_DLGXG DE0017 2026-01-25T14:08:40.020Z 2026-01-29T14:46:11.270Z
9248789 9248789 20260122021017_tuZCU DE0017 2026-01-23T14:13:51.764Z 2026-01-29T14:57:46.709Z
9248727 9248727 20260122015602_qDofP DE0017 2026-01-23T14:13:32.933Z 2026-01-29T14:57:43.298Z
9248672 9248672 20260122013806_kBtpX DE0017 2026-01-23T14:13:24.064Z 2026-01-29T14:57:40.045Z
9248007 9248007 20260121210719_fINHq DE0017 2026-01-23T14:11:42.723Z 2026-01-29T14:56:48.120Z
9243516 9243516 20260121044341_FJo2c DE0017 2026-01-22T14:22:07.791Z 2026-01-29T15:05:16.751Z
9243362 9243362 20260121042137_3idLO DE0017 2026-01-22T14:21:31.995Z 2026-01-29T15:04:56.999Z
9242808 9242808 20260121024856_6CdmM DE0017 2026-01-22T14:19:18.583Z 2026-01-29T15:04:21.759Z
9242746 9242746 20260121023848_SpGKC DE0017 2026-01-22T14:19:06.856Z 2026-01-29T15:04:19.188Z
9242622 9242622 20260121022530_jxr6V DE0017 2026-01-22T14:18:35.737Z 2026-01-29T15:04:14.385Z
9242543 9242543 20260121021130_Af74n DE0017 2026-01-22T14:18:21.040Z 2026-01-29T15:04:05.355Z
9242384 9242384 20260121014217_3GFXV DE0017 2026-01-22T14:17:35.045Z 2026-01-29T15:03:56.290Z
9242137 9242137 20260121003723_9PHk4 DE0017 2026-01-22T14:16:29.565Z 2026-01-29T15:03:32.871Z
9241933 9241933 20260120233805_SMpgb DE0017 2026-01-22T14:15:26.505Z 2026-01-29T15:03:13.226Z
9212997 9212997 20260116014907_hgZAG DE0017 2026-01-17T14:14:53.634Z 2026-01-24T15:11:36.836Z
9212798 9212798 20260116010210_9gtUh DE0017 2026-01-17T14:13:57.897Z 2026-01-24T15:11:27.066Z
9212770 9212770 20260116005533_R3ip3 DE0017 2026-01-17T14:13:45.500Z 2026-01-24T15:11:25.779Z
9212486 9212486 20260115221241_ChjJB DE0017 2026-01-17T14:12:10.754Z 2026-01-24T15:10:57.326Z
9207202 9207202 20260114234731_RkL4Q DE0017 2026-01-16T14:07:39.571Z 2026-01-22T15:03:14.354Z
9202497 9202497 20260114034301_iApOT DE0017 2026-01-15T14:21:31.517Z 2026-01-22T15:09:21.377Z
9201664 9201664 20260114023921_213Mg DE0017 2026-01-15T14:19:15.780Z 2026-01-22T15:09:07.167Z
9201409 9201409 20260114021513_1zZhl DE0017 2026-01-15T14:18:34.780Z 2026-01-22T15:09:03.166Z
9157246 9157246 20260104171555_9NNf0 DE0017 2026-01-06T14:42:08.438Z 2026-01-12T15:13:07.380Z
9150527 9150527 20260105023813_31ZVC DE0017 2026-01-06T14:10:21.203Z 2026-01-13T15:13:38.368Z
9150110 9150110 20260105010259_U1XDV DE0017 2026-01-06T14:08:36.327Z 2026-01-13T15:13:05.013Z
9149551 9149551 20260104214439_kFHM2 DE0017 2026-01-06T14:05:57.834Z 2026-01-13T15:12:17.388Z
9149476 9149476 20260104212113_CHuY7 DE0017 2026-01-06T14:05:38.380Z 2026-01-13T15:12:13.317Z
9149474 9149474 20260104211745_Uxk33 DE0017 2026-01-06T14:05:37.691Z 2026-01-13T15:12:13.154Z
9148995 9148995 20260104182220_AiV8Z DE0017 2026-01-06T14:03:22.805Z 2026-01-13T15:11:37.001Z
9084707 9084707 20251228021047_rTWPX DE0017 2025-12-30T14:36:36.732Z 2025-12-31T14:50:30.883Z
9084668 9084668 20251228020618_nOGKg DE0017 2025-12-30T14:36:24.844Z 2026-01-05T15:08:51.685Z
9083351 9083351 20251227234159_Hfm2b DE0017 2025-12-30T14:32:24.809Z 2026-01-05T15:07:45.625Z
9023894 9023894 20251220230705_rKDx2 DE0017 2025-12-27T15:10:07.590Z 2025-12-29T15:26:24.159Z
9017460 9017460 20251220052227_Q3JOh DE0017 2025-12-27T15:01:22.008Z 2025-12-29T15:23:31.408Z
9017254 9017254 20251220050604_f4JhH DE0017 2025-12-27T15:01:14.842Z 2025-12-27T15:01:14.842Z
8982793 8982793 20251219203407_mR22X DE0017 2025-12-26T14:27:48.124Z 2025-12-28T15:22:16.081Z
8981451 8981451 20251219173659_yxoon DE0017 2025-12-26T14:24:46.422Z 2025-12-28T15:21:53.756Z
8977115 8977115 20251219042028_kXZNr DE0017 2025-12-26T14:11:50.994Z 2025-12-28T15:17:31.016Z
8977104 8977104 20251219041931_F7OZj DE0017 2025-12-26T14:11:48.976Z 2025-12-28T15:17:30.750Z
8976972 8976972 20251219040705_ZdcKb DE0017 2025-12-26T14:11:26.016Z 2025-12-28T15:17:29.646Z
8756167 8756167 20251210040404_h9jYW DE0017 2025-12-13T15:45:02.944Z 2025-12-17T15:29:28.575Z
8742694 8742694 20251210223755_03neQ DE0017 2025-12-13T15:23:04.358Z 2025-12-19T15:13:21.901Z
8742359 8742359 20251210221518_lybgv DE0017 2025-12-13T15:22:19.369Z 2025-12-19T15:13:14.282Z
8741567 8741567 20251210212437_zsTij DE0017 2025-12-13T15:21:10.693Z 2025-12-19T15:12:34.033Z
8740833 8740833 20251210201108_cV1pM DE0017 2025-12-13T15:19:40.937Z 2025-12-19T15:11:54.616Z
8740615 8740615 20251210194350_brqAk DE0017 2025-12-13T15:19:02.319Z 2025-12-19T15:11:47.859Z
8740593 8740593 20251210193954_U9r4i DE0017 2025-12-13T15:19:00.242Z 2025-12-19T15:11:46.931Z
8714574 8714574 20251210052842_f2v0v DE0017 2025-12-11T14:03:14.747Z 2025-12-19T15:05:36.314Z
8713918 8713918 20251210043604_aTsvr DE0017 2025-12-11T14:00:41.479Z 2025-12-19T15:05:19.187Z
8713830 8713830 20251210042937_2nymL DE0017 2025-12-11T14:00:17.668Z 2025-12-19T15:05:15.611Z
8683673 8683673 20251130041802_ilFsJ DE0017 2025-12-04T14:42:48.128Z 2025-12-08T14:56:03.002Z
8683659 8683659 20251130013016_Tuj5h DE0017 2025-12-04T14:40:49.098Z 2025-12-08T14:54:27.743Z
8683654 8683654 20251129235656_BLAUU DE0017 2025-12-04T14:39:58.414Z 2025-12-08T14:53:47.236Z
8683652 8683652 20251129235639_qp53N DE0017 2025-12-04T14:39:58.049Z 2025-12-08T14:53:47.205Z
8683647 8683647 20251129232617_HJnby DE0017 2025-12-04T14:39:36.119Z 2025-12-08T14:53:43.094Z
8683642 8683642 20251129232304_mI07X DE0017 2025-12-04T14:39:35.477Z 2025-12-08T14:53:42.817Z
8683639 8683639 20251129231212_zQi8w DE0017 2025-12-04T14:39:33.766Z 2025-12-08T14:53:41.828Z
8683637 8683637 20251129225207_cJt3t DE0017 2025-12-04T14:39:28.621Z 2025-12-08T14:53:33.273Z
8656663 8656663 20251130050555_msRrC DE0017 2025-12-01T14:28:53.157Z 2025-12-02T14:41:16.024Z
8656607 8656607 20251130050108_aHWhP DE0017 2025-12-01T14:28:47.597Z 2025-12-08T14:56:23.044Z
8656560 8656560 20251130045904_jcquI DE0017 2025-12-01T14:28:45.059Z 2025-12-08T14:56:21.922Z
8656403 8656403 20251130045352_JIu8y DE0017 2025-12-01T14:28:36.544Z 2025-12-08T14:56:11.685Z
8656106 8656106 20251130043725_3Fgyx DE0017 2025-12-01T14:28:03.618Z 2025-12-08T14:56:07.828Z
8656007 8656007 20251130042958_M4Amg DE0017 2025-12-01T14:27:55.924Z 2025-12-08T14:56:05.119Z
8654887 8654887 20251130033745_5fnf6 DE0017 2025-12-01T14:26:09.338Z 2025-12-08T14:55:43.827Z
8653395 8653395 20251130021342_OBhOI DE0017 2025-12-01T14:23:20.897Z 2025-12-02T14:38:53.067Z
8653114 8653114 20251130015852_d9Hw3 DE0017 2025-12-01T14:22:50.802Z 2025-12-08T14:54:51.440Z
8652619 8652619 20251130012447_F4VZS DE0017 2025-12-01T14:21:52.751Z 2025-12-08T14:54:22.178Z
8652462 8652462 20251130011058_qxN14 DE0017 2025-12-01T14:21:27.148Z 2025-12-02T14:38:04.908Z
8651857 8651857 20251130002731_Smw3N DE0017 2025-12-01T14:20:08.058Z 2025-12-08T14:54:03.657Z
8651718 8651718 20251130001333_AGDez DE0017 2025-12-01T14:19:44.856Z 2025-12-08T14:54:01.064Z
8651647 8651647 20251130000751_Nr3N9 DE0017 2025-12-01T14:19:37.937Z 2025-12-08T14:53:51.026Z
8651180 8651180 20251129225914_Yw1ee DE0017 2025-12-01T14:18:18.505Z 2025-12-08T14:53:34.200Z
8650826 8650826 20251129213748_oWesl DE0017 2025-12-01T14:17:16.186Z 2025-12-08T14:53:06.063Z
8643534 8643534 20251128180453_FBCgs DE0017 2025-11-30T14:20:11.416Z 2025-12-07T14:56:03.921Z
8637070 8637070 20251128045555_4UFgZ DE0017 2025-11-29T14:26:48.432Z 2025-12-06T15:03:56.103Z
8637005 8637005 20251128044711_Ay8xm DE0017 2025-11-29T14:26:31.700Z 2025-12-06T15:03:55.424Z
8636929 8636929 20251128043900_G2JQr DE0017 2025-11-29T14:26:21.045Z 2025-12-06T15:03:51.045Z
8636728 8636728 20251128042007_4FO52 DE0017 2025-11-29T14:26:07.846Z 2025-12-06T15:03:38.758Z
8636556 8636556 20251128040047_Ch5U5 DE0017 2025-11-29T14:25:40.359Z 2025-12-06T15:03:29.854Z
8636457 8636457 20251128034710_pwNse DE0017 2025-11-29T14:25:32.063Z 2025-12-06T15:03:19.256Z
8635946 8635946 20251128030133_2ccfr DE0017 2025-11-29T14:24:41.091Z 2025-12-06T15:02:54.481Z
8635232 8635232 20251128015551_W9YXj DE0017 2025-11-29T14:22:52.556Z 2025-12-06T15:02:42.137Z
8634629 8634629 20251128010544_MX3e8 DE0017 2025-11-29T14:21:41.053Z 2025-12-06T15:02:26.434Z
8634300 8634300 20251128003426_3GsJh DE0017 2025-11-29T14:21:10.638Z 2025-12-06T15:01:59.328Z
8633752 8633752 20251127235213_n7Hmg DE0017 2025-11-29T14:20:13.183Z 2025-12-06T15:01:48.341Z
8633590 8633590 20251127233550_ro8Vs DE0017 2025-11-29T14:19:56.715Z 2025-12-06T15:01:45.993Z
8633348 8633348 20251127230628_VPKTr DE0017 2025-11-29T14:19:28.606Z 2025-12-06T15:01:42.980Z
8633341 8633341 20251127230538_zTk32 DE0017 2025-11-29T14:19:27.544Z 2025-12-06T15:01:42.681Z
8632949 8632949 20251127222100_wBUhn DE0017 2025-11-29T14:18:35.901Z 2025-12-06T15:01:35.874Z
8632496 8632496 20251127211401_kkO0W DE0017 2025-11-29T14:17:44.281Z 2025-12-06T15:01:22.920Z
8630707 8630707 20251127170831_c3T7U DE0017 2025-11-29T14:13:30.221Z 2025-12-06T14:59:18.701Z
8630624 8630624 20251127165227_kQvxO DE0017 2025-11-29T14:13:18.227Z 2025-12-06T14:59:14.863Z
8582218 8582218 20251123044551_CZ6dP DE0017 2025-11-24T14:33:23.076Z 2025-12-01T15:22:18.920Z
8582201 8582201 20251123044209_oVjFQ DE0017 2025-11-24T14:33:22.422Z 2025-12-01T15:22:18.575Z
8581899 8581899 20251123025722_LOVHN DE0017 2025-11-24T14:32:44.331Z 2025-12-01T15:21:55.995Z
8581547 8581547 20251123005159_aQ3XY DE0017 2025-11-24T14:31:47.265Z 2025-12-01T15:20:56.804Z
8580351 8580351 20251123035854_nhI2i DE0017 2025-11-24T14:16:49.663Z 2025-12-01T15:22:15.338Z
8579796 8579796 20251123011728_NIyl2 DE0017 2025-11-24T14:15:10.665Z 2025-12-01T15:21:09.655Z
8579605 8579605 20251123002420_WL3kY DE0017 2025-11-24T14:14:46.739Z 2025-12-01T15:20:48.112Z

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