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

5,225 rows where station_code = "DE0013" 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
9262627 9262627 20260125215130_04BpD DE0013 2026-01-27T14:14:29.094Z 2026-01-29T14:38:29.601Z
9260447 9260447 20260125043026_Vonvm DE0013 2026-01-26T14:21:51.119Z 2026-01-29T14:44:13.635Z
9258983 9258983 20260124181713_zSPnc DE0013 2026-01-26T14:15:18.897Z 2026-01-29T14:42:22.121Z
9258908 9258908 20260124175419_u2Mqc DE0013 2026-01-26T14:14:58.835Z 2026-01-29T14:42:18.320Z
9258847 9258847 20260124173353_hONVV DE0013 2026-01-26T14:14:42.928Z 2026-01-29T14:42:14.901Z
9256498 9256498 20260118222201_ioICw DE0013 2026-01-25T14:46:51.448Z 2026-01-27T15:02:01.041Z
9256496 9256496 20260118221606_rnx5e DE0013 2026-01-25T14:46:51.007Z 2026-01-27T15:02:00.620Z
9256493 9256493 20260120054913_7nHgz DE0013 2026-01-25T14:42:37.834Z 2026-01-28T15:01:35.400Z
9256459 9256459 20260119204512_znKiY DE0013 2026-01-25T14:38:30.775Z 2026-01-28T14:57:28.958Z
9256455 9256455 20260119172841_agiq3 DE0013 2026-01-25T14:37:32.118Z 2026-01-28T14:56:28.669Z
9256447 9256447 20260122042140_4b6dZ DE0013 2026-01-25T14:27:36.132Z 2026-01-29T14:58:19.164Z
9256445 9256445 20260121231146_pj92n DE0013 2026-01-25T14:26:30.891Z 2026-01-29T14:57:15.435Z
9256441 9256441 20260121193557_afAba DE0013 2026-01-25T14:25:41.351Z 2026-01-29T14:56:34.446Z
9182713 9182713 20260111061840_kExgy DE0013 2026-01-12T14:15:29.792Z 2026-01-19T15:18:56.412Z
9182703 9182703 20260111061514_iZZ5H DE0013 2026-01-12T14:15:27.856Z 2026-01-19T15:18:55.946Z
9182650 9182650 20260111060110_dmmLA DE0013 2026-01-12T14:15:19.884Z 2026-01-19T15:18:53.894Z
9182641 9182641 20260111060020_8jYhm DE0013 2026-01-12T14:15:16.451Z 2026-01-19T15:18:53.255Z
9182533 9182533 20260111053727_U2hFb DE0013 2026-01-12T14:14:52.736Z 2026-01-19T15:18:48.530Z
9182496 9182496 20260111053238_RWfQ7 DE0013 2026-01-12T14:14:45.930Z 2026-01-19T15:18:44.612Z
9182398 9182398 20260111052108_thmCb DE0013 2026-01-12T14:14:28.097Z 2026-01-19T15:18:30.998Z
9182373 9182373 20260111051202_fOGMw DE0013 2026-01-12T14:14:17.198Z 2026-01-19T15:18:29.829Z
9182291 9182291 20260111045726_rQGvr DE0013 2026-01-12T14:14:02.939Z 2026-01-19T15:18:24.352Z
9182137 9182137 20260111042913_tg7eq DE0013 2026-01-12T14:13:27.057Z 2026-01-19T15:18:17.258Z
9182052 9182052 20260111040546_2XhFz DE0013 2026-01-12T14:13:04.707Z 2026-01-19T15:18:13.586Z
9181761 9181761 20260111030418_XPnXP DE0013 2026-01-12T14:12:04.600Z 2026-01-19T15:17:47.724Z
9181478 9181478 20260111015543_ThavK DE0013 2026-01-12T14:10:55.496Z 2026-01-19T15:17:21.046Z
9181397 9181397 20260111013757_pTT3s DE0013 2026-01-12T14:10:39.591Z 2026-01-19T15:17:16.332Z
9181270 9181270 20260111011231_nPHO0 DE0013 2026-01-12T14:10:12.486Z 2026-01-19T15:17:10.580Z
9181159 9181159 20260111003722_C8Tvk DE0013 2026-01-12T14:09:47.959Z 2026-01-19T15:17:05.920Z
9181156 9181156 20260111003712_lWla1 DE0013 2026-01-12T14:09:47.308Z 2026-01-19T15:17:05.789Z
9180972 9180972 20260110233759_amw8g DE0013 2026-01-12T14:09:06.928Z 2026-01-19T15:16:42.631Z
9180914 9180914 20260110232338_gEDQT DE0013 2026-01-12T14:08:52.778Z 2026-01-19T15:16:38.765Z
9180884 9180884 20260110231014_PrI2j DE0013 2026-01-12T14:08:45.450Z 2026-01-19T15:16:37.407Z
9180882 9180882 20260110230847_AUaqC DE0013 2026-01-12T14:08:44.757Z 2026-01-19T15:16:37.218Z
9171878 9171878 20260109041704_eQyOD DE0013 2026-01-10T14:10:13.174Z 2026-01-17T15:24:39.935Z
9162233 9162233 20260107010155_6qUKc DE0013 2026-01-08T14:03:50.904Z 2026-01-13T15:01:48.250Z
9162211 9162211 20260107003607_blnsJ DE0013 2026-01-08T14:03:35.663Z 2026-01-13T15:01:46.098Z
9162172 9162172 20260106235707_aCxNx DE0013 2026-01-08T14:03:20.133Z 2026-01-13T15:01:42.083Z
9162132 9162132 20260106223755_CWD8v DE0013 2026-01-08T14:03:07.386Z 2026-01-13T15:01:39.078Z
9162115 9162115 20260106214143_r7DID DE0013 2026-01-08T14:03:01.761Z 2026-01-13T15:01:37.092Z
9162092 9162092 20260106205956_s3jYR DE0013 2026-01-08T14:02:47.093Z 2026-01-13T15:01:35.039Z
9162083 9162083 20260106203953_dYDBz DE0013 2026-01-08T14:02:41.903Z 2026-01-13T15:01:34.128Z
9162078 9162078 20260106202428_1Kfwe DE0013 2026-01-08T14:02:40.320Z 2026-01-13T15:01:33.557Z
9162053 9162053 20260106192231_bRLWa DE0013 2026-01-08T14:02:21.829Z 2026-01-13T15:01:29.027Z
9149783 9149783 20260104233437_3h2LT DE0013 2026-01-06T14:07:10.653Z 2026-01-13T15:12:39.090Z
9149733 9149733 20260104231743_C1kPi DE0013 2026-01-06T14:06:55.124Z 2026-01-13T15:12:36.111Z
9149504 9149504 20260104213249_v6EcT DE0013 2026-01-06T14:05:45.927Z 2026-01-13T15:12:14.778Z
9149281 9149281 20260104195627_TX1Sp DE0013 2026-01-06T14:04:47.379Z 2026-01-13T15:11:55.024Z
9130609 9130609 20260103034750_HHU5S DE0013 2026-01-04T14:10:54.662Z 2026-01-10T14:59:25.278Z
9129778 9129778 20260103003733_htO4W DE0013 2026-01-04T14:06:20.953Z 2026-01-10T14:58:12.345Z
9126878 9126878 20260102011810_C84g3 DE0013 2026-01-03T14:07:13.339Z 2026-01-09T14:49:08.429Z
9124396 9124396 20251231061856_3amoH DE0013 2026-01-02T14:45:21.083Z 2026-01-08T15:11:51.799Z
9123644 9123644 20251231024055_F8cJp DE0013 2026-01-02T14:32:56.720Z 2026-01-08T15:07:52.735Z
9123221 9123221 20251230215234_dg3I7 DE0013 2026-01-02T14:21:51.130Z 2026-01-08T15:04:51.685Z
9119697 9119697 20251230184241_16TLL DE0013 2026-01-01T14:56:50.971Z 2026-01-07T15:13:10.003Z
9116519 9116519 20251231061856_2G0uJ DE0013 2026-01-01T14:28:18.040Z 2026-01-01T14:57:54.872Z
9115620 9115620 20251231051910_yK39Y DE0013 2026-01-01T14:25:56.752Z 2026-01-08T15:10:57.589Z
9115519 9115519 20251231051233_uWf5C DE0013 2026-01-01T14:25:39.048Z 2026-01-08T15:10:51.135Z
9114447 9114447 20251231041751_D0wcF DE0013 2026-01-01T14:22:33.443Z 2026-01-08T15:09:48.840Z
9113884 9113884 20251231035316_TaNzE DE0013 2026-01-01T14:20:42.493Z 2026-01-08T15:09:13.967Z
9113531 9113531 20251231033452_34bbo DE0013 2026-01-01T14:19:25.190Z 2026-01-08T15:08:48.405Z
9113375 9113375 20251231032557_tNiSv DE0013 2026-01-01T14:18:40.623Z 2026-01-08T15:08:41.885Z
9113279 9113279 20251231032026_3dpgL DE0013 2026-01-01T14:18:17.700Z 2026-01-08T15:08:38.013Z
9112987 9112987 20251231030432_PBWkt DE0013 2026-01-01T14:17:01.593Z 2026-01-08T15:08:16.605Z
9112927 9112927 20251231030010_4P32Y DE0013 2026-01-01T14:16:49.291Z 2026-01-08T15:08:14.184Z
9112594 9112594 20251231024055_vEEyB DE0013 2026-01-01T14:15:41.056Z 2026-01-01T14:57:52.220Z
9112028 9112028 20251231015756_c4syt DE0013 2026-01-01T14:13:37.017Z 2026-01-08T15:07:14.299Z
9111893 9111893 20251231015121_LGKrr DE0013 2026-01-01T14:13:12.858Z 2026-01-08T15:07:08.701Z
9111301 9111301 20251231010031_xlUcS DE0013 2026-01-01T14:10:54.816Z 2026-01-08T15:06:27.981Z
9111217 9111217 20251231005031_AWaFd DE0013 2026-01-01T14:10:33.745Z 2026-01-08T15:06:21.673Z
9110899 9110899 20251231001618_KUKSf DE0013 2026-01-01T14:09:18.932Z 2026-01-08T15:05:59.970Z
9110835 9110835 20251231000656_y3W56 DE0013 2026-01-01T14:08:58.251Z 2026-01-08T15:05:55.381Z
9110589 9110589 20251230233306_QGkG1 DE0013 2026-01-01T14:07:57.934Z 2026-01-08T15:05:40.681Z
9109968 9109968 20251230215234_nJjHo DE0013 2026-01-01T14:05:03.039Z 2026-01-08T15:04:52.046Z
9109932 9109932 20251230213637_QSqNB DE0013 2026-01-01T14:04:50.746Z 2026-01-08T15:04:48.791Z
9109891 9109891 20251230211248_cp3TO DE0013 2026-01-01T14:04:26.302Z 2026-01-08T15:04:43.605Z
9109879 9109879 20251230211039_G8Vl3 DE0013 2026-01-01T14:04:24.344Z 2026-01-08T15:04:43.142Z
9109779 9109779 20251230205149_nmo2x DE0013 2026-01-01T14:03:47.623Z 2026-01-08T15:04:28.578Z
9109557 9109557 20251230195446_BED3O DE0013 2026-01-01T14:01:38.140Z 2026-01-08T15:03:59.854Z
9104170 9104170 20251230053505_1maNd DE0013 2025-12-31T14:20:31.781Z 2026-01-07T15:09:33.320Z
9103976 9103976 20251230052348_TAOeJ DE0013 2025-12-31T14:19:56.118Z 2026-01-07T15:09:17.682Z
9103900 9103900 20251230051450_IPa2l DE0013 2025-12-31T14:19:39.683Z 2026-01-07T15:09:14.445Z
9103876 9103876 20251230051324_Jj8PK DE0013 2025-12-31T14:19:35.742Z 2026-01-07T15:09:13.347Z
9103710 9103710 20251230045357_stxjr DE0013 2025-12-31T14:18:56.681Z 2026-01-07T15:09:05.601Z
9103693 9103693 20251230045302_1GxGH DE0013 2025-12-31T14:18:53.773Z 2026-01-07T15:09:05.038Z
9103620 9103620 20251230044625_DgmhI DE0013 2025-12-31T14:18:31.096Z 2026-01-07T15:09:00.214Z
9103505 9103505 20251230043509_jz0Ky DE0013 2025-12-31T14:18:01.546Z 2026-01-07T15:08:47.513Z
9103480 9103480 20251230043248_7Gyw5 DE0013 2025-12-31T14:17:58.519Z 2026-01-07T15:08:46.268Z
9103197 9103197 20251230040620_yas1A DE0013 2025-12-31T14:16:52.417Z 2026-01-07T15:08:31.579Z
9103075 9103075 20251230035420_YrG9t DE0013 2025-12-31T14:16:22.194Z 2026-01-07T15:08:17.969Z
9102778 9102778 20251230033341_YLpZx DE0013 2025-12-31T14:15:19.977Z 2026-01-07T15:08:05.690Z
9102595 9102595 20251230031553_xJFHO DE0013 2025-12-31T14:14:32.208Z 2026-01-07T15:07:45.521Z
9102503 9102503 20251230030836_BNNIG DE0013 2025-12-31T14:14:09.241Z 2026-01-07T15:07:42.388Z
9102200 9102200 20251230023513_0E7pt DE0013 2025-12-31T14:12:40.156Z 2026-01-07T15:07:18.294Z
9102144 9102144 20251230022924_LKsA8 DE0013 2025-12-31T14:12:24.293Z 2026-01-07T15:07:14.423Z
9102052 9102052 20251230022008_vYF3L DE0013 2025-12-31T14:11:53.637Z 2026-01-07T15:07:09.349Z
9102037 9102037 20251230021914_OlUxP DE0013 2025-12-31T14:11:51.037Z 2026-01-07T15:07:08.766Z
9102019 9102019 20251230021714_Aflx8 DE0013 2025-12-31T14:11:45.284Z 2026-01-07T15:07:08.099Z
9101714 9101714 20251230012127_U9BgR DE0013 2025-12-31T14:10:07.589Z 2026-01-07T15:06:43.024Z
9101698 9101698 20251230011953_z7HPR DE0013 2025-12-31T14:10:01.737Z 2026-01-07T15:06:42.215Z

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