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,764 rows where station_code = "DE0011" 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
9267771 9267771 20260127045259_PUCvz DE0011 2026-01-28T14:23:15.036Z 2026-01-29T14:35:41.798Z
9259557 9259557 20260124212614_YX8Or DE0011 2026-01-26T14:17:27.550Z 2026-01-29T14:43:05.936Z
9259401 9259401 20260124204122_yEX32 DE0011 2026-01-26T14:16:53.340Z 2026-01-29T14:42:51.397Z
9259330 9259330 20260124202733_1vjH4 DE0011 2026-01-26T14:16:32.965Z 2026-01-29T14:42:48.356Z
9258827 9258827 20260124172016_41X8M DE0011 2026-01-26T14:14:34.169Z 2026-01-29T14:42:13.027Z
9249586 9249586 20260122060057_Spg3R DE0011 2026-01-23T14:15:45.763Z 2026-01-29T14:58:46.121Z
9249412 9249412 20260122051133_XPMap DE0011 2026-01-23T14:15:19.388Z 2026-01-29T14:58:29.342Z
9249378 9249378 20260122050447_359VU DE0011 2026-01-23T14:15:14.990Z 2026-01-29T14:58:27.858Z
9249338 9249338 20260122045719_1iZmC DE0011 2026-01-23T14:15:12.281Z 2026-01-29T14:58:26.682Z
9249224 9249224 20260122041625_ZPrzu DE0011 2026-01-23T14:14:58.230Z 2026-01-29T14:58:18.341Z
9249194 9249194 20260122040355_fnXP4 DE0011 2026-01-23T14:14:49.207Z 2026-01-29T14:58:16.200Z
9248960 9248960 20260122025511_G2eQj DE0011 2026-01-23T14:14:13.024Z 2026-01-29T14:57:56.698Z
9248886 9248886 20260122023547_3IIm5 DE0011 2026-01-23T14:14:02.865Z 2026-01-29T14:57:52.942Z
9248770 9248770 20260122020425_mi8B5 DE0011 2026-01-23T14:13:46.655Z 2026-01-29T14:57:45.917Z
9248741 9248741 20260122015844_486AT DE0011 2026-01-23T14:13:36.578Z 2026-01-29T14:57:44.284Z
9248573 9248573 20260122004658_wiPzP DE0011 2026-01-23T14:13:06.980Z 2026-01-29T14:57:33.908Z
9248488 9248488 20260122001007_KHAAq DE0011 2026-01-23T14:12:54.652Z 2026-01-29T14:57:23.268Z
9248474 9248474 20260122000404_E1xMy DE0011 2026-01-23T14:12:52.852Z 2026-01-29T14:57:22.693Z
9248041 9248041 20260121211358_tPC3o DE0011 2026-01-23T14:11:46.527Z 2026-01-29T14:56:51.990Z
9247842 9247842 20260121200523_cqZqE DE0011 2026-01-23T14:11:14.765Z 2026-01-29T14:56:40.224Z
9247561 9247561 20260121190114_7Ygow DE0011 2026-01-23T14:10:28.462Z 2026-01-29T14:56:14.443Z
9247524 9247524 20260121185112_5DSk7 DE0011 2026-01-23T14:10:23.627Z 2026-01-29T14:56:12.801Z
9244814 9244814 20260119225535_H9wx2 DE0011 2026-01-22T14:32:17.733Z 2026-01-28T14:57:59.706Z
9244059 9244059 20260121060510_TQ181 DE0011 2026-01-22T14:24:03.233Z 2026-01-29T15:05:50.195Z
9243966 9243966 20260121054506_7n4ul DE0011 2026-01-22T14:23:40.485Z 2026-01-29T15:05:36.906Z
9243877 9243877 20260121052908_N6S21 DE0011 2026-01-22T14:23:24.686Z 2026-01-29T15:05:30.917Z
9243840 9243840 20260121052444_qeubU DE0011 2026-01-22T14:23:20.560Z 2026-01-29T15:05:29.594Z
9243606 9243606 20260121045127_zeuSF DE0011 2026-01-22T14:22:22.033Z 2026-01-29T15:05:19.682Z
9243313 9243313 20260121041225_pjyZJ DE0011 2026-01-22T14:21:24.916Z 2026-01-29T15:04:55.142Z
9243228 9243228 20260121040047_sYDJV DE0011 2026-01-22T14:21:00.080Z 2026-01-29T15:04:51.545Z
9242885 9242885 20260121030755_pNNju DE0011 2026-01-22T14:19:39.421Z 2026-01-29T15:04:28.049Z
9242873 9242873 20260121030712_R5Gqp DE0011 2026-01-22T14:19:37.721Z 2026-01-29T15:04:25.604Z
9242869 9242869 20260121030403_0U5Uj DE0011 2026-01-22T14:19:36.903Z 2026-01-29T15:04:25.315Z
9242856 9242856 20260121025912_r6UST DE0011 2026-01-22T14:19:33.206Z 2026-01-29T15:04:24.383Z
9242788 9242788 20260121024351_ux69F DE0011 2026-01-22T14:19:13.550Z 2026-01-29T15:04:20.992Z
9242488 9242488 20260121020446_QkdW2 DE0011 2026-01-22T14:18:01.794Z 2026-01-29T15:04:01.039Z
9242456 9242456 20260121015254_IZuuI DE0011 2026-01-22T14:17:53.882Z 2026-01-29T15:03:59.377Z
9242339 9242339 20260121013306_NDyRZ DE0011 2026-01-22T14:17:23.822Z 2026-01-29T15:03:45.021Z
9241811 9241811 20260120224304_Xxl2y DE0011 2026-01-22T14:14:47.485Z 2026-01-29T15:03:03.818Z
9241742 9241742 20260120220717_YhWZK DE0011 2026-01-22T14:14:21.451Z 2026-01-29T15:03:00.259Z
9241533 9241533 20260120205437_1feOJ DE0011 2026-01-22T14:13:34.053Z 2026-01-29T15:02:42.790Z
9241347 9241347 20260120200422_22voU DE0011 2026-01-22T14:12:45.918Z 2026-01-29T15:02:32.891Z
9241203 9241203 20260120192604_7IB1I DE0011 2026-01-22T14:12:07.964Z 2026-01-29T15:02:26.742Z
9237522 9237522 20260120052845_wuoDm DE0011 2026-01-21T14:26:51.362Z 2026-01-21T14:31:13.844Z
9237393 9237393 20260120051121_DjveA DE0011 2026-01-21T14:26:24.336Z 2026-01-28T15:01:23.443Z
9237383 9237383 20260120050853_7EQgJ DE0011 2026-01-21T14:26:22.770Z 2026-01-28T15:01:22.875Z
9237233 9237233 20260120045309_OiM8k DE0011 2026-01-21T14:25:44.477Z 2026-01-28T15:01:05.169Z
9237110 9237110 20260120043846_S4vfh DE0011 2026-01-21T14:25:17.902Z 2026-01-28T15:00:58.381Z
9236955 9236955 20260120042232_0g0oH DE0011 2026-01-21T14:24:35.521Z 2026-01-28T15:00:50.555Z
9236848 9236848 20260120040552_SgiHl DE0011 2026-01-21T14:24:21.229Z 2026-01-28T15:00:38.948Z
9236647 9236647 20260120034351_ivKMz DE0011 2026-01-21T14:23:37.061Z 2026-01-28T15:00:27.351Z
9236389 9236389 20260120030919_4gdVN DE0011 2026-01-21T14:22:33.184Z 2026-01-28T14:59:57.983Z
9236267 9236267 20260120025411_MJqBr DE0011 2026-01-21T14:22:13.223Z 2026-01-28T14:59:52.637Z
9235900 9235900 20260120021539_cWLsm DE0011 2026-01-21T14:20:42.259Z 2026-01-28T14:59:26.878Z
9235795 9235795 20260120015947_dgFSi DE0011 2026-01-21T14:20:17.249Z 2026-01-28T14:59:21.226Z
9235691 9235691 20260120014808_Lh1O6 DE0011 2026-01-21T14:19:59.301Z 2026-01-28T14:59:16.209Z
9235615 9235615 20260120013840_AUnN9 DE0011 2026-01-21T14:19:35.739Z 2026-01-28T14:59:12.488Z
9235355 9235355 20260120010017_pKq41 DE0011 2026-01-21T14:18:40.910Z 2026-01-28T14:58:50.826Z
9235215 9235215 20260120004339_R724E DE0011 2026-01-21T14:17:55.801Z 2026-01-28T14:58:43.876Z
9235213 9235213 20260120004338_M83Zh DE0011 2026-01-21T14:17:55.425Z 2026-01-28T14:58:43.740Z
9235205 9235205 20260120004331_Ufgqc DE0011 2026-01-21T14:17:54.786Z 2026-01-28T14:58:43.457Z
9235151 9235151 20260120003717_8I8UB DE0011 2026-01-21T14:17:45.767Z 2026-01-28T14:58:33.092Z
9234908 9234908 20260119234809_X4C3E DE0011 2026-01-21T14:16:38.649Z 2026-01-28T14:58:20.087Z
9234814 9234814 20260119233159_3Qn3L DE0011 2026-01-21T14:16:14.015Z 2026-01-28T14:58:14.799Z
9234680 9234680 20260119225535_ceViG DE0011 2026-01-21T14:15:41.484Z 2026-01-28T14:57:59.550Z
9234595 9234595 20260119223209_vc4yZ DE0011 2026-01-21T14:15:15.102Z 2026-01-28T14:57:55.785Z
9234037 9234037 20260119192117_z7jqo DE0011 2026-01-21T14:11:58.316Z 2026-01-28T14:57:00.383Z
9233889 9233889 20260119183030_m0qVt DE0011 2026-01-21T14:11:12.366Z 2026-01-21T14:31:10.298Z
9233823 9233823 20260119180748_6hhxD DE0011 2026-01-21T14:10:45.494Z 2026-01-28T14:56:43.908Z
9230762 9230762 20260119050227_xQiTT DE0011 2026-01-20T14:29:38.352Z 2026-01-27T15:05:24.984Z
9230335 9230335 20260119040253_DubWH DE0011 2026-01-20T14:27:16.670Z 2026-01-27T15:04:49.317Z
9230171 9230171 20260119033628_K4vlP DE0011 2026-01-20T14:26:24.101Z 2026-01-27T15:04:31.390Z
9230150 9230150 20260119033410_WD7c2 DE0011 2026-01-20T14:26:19.068Z 2026-01-27T15:04:30.395Z
9230076 9230076 20260119032235_jAXdz DE0011 2026-01-20T14:25:48.681Z 2026-01-27T15:04:24.117Z
9229867 9229867 20260119024631_jLXfI DE0011 2026-01-20T14:24:41.586Z 2026-01-27T15:04:11.532Z
9229230 9229230 20260119011100_UvDmR DE0011 2026-01-20T14:21:38.442Z 2026-01-27T15:03:12.893Z
9228947 9228947 20260119002331_0442Z DE0011 2026-01-20T14:20:16.366Z 2026-01-27T15:02:44.400Z
9228703 9228703 20260118233719_J6Jdy DE0011 2026-01-20T14:19:07.571Z 2026-01-27T15:02:18.136Z
9228574 9228574 20260118225726_agOlG DE0011 2026-01-20T14:18:27.758Z 2026-01-27T15:02:08.717Z
9228240 9228240 20260118205100_L2znM DE0011 2026-01-20T14:16:50.598Z 2026-01-27T15:01:35.786Z
9228178 9228178 20260118202508_riqLv DE0011 2026-01-20T14:16:31.062Z 2026-01-27T15:01:31.882Z
9228079 9228079 20260118194616_lGKJI DE0011 2026-01-20T14:15:53.991Z 2026-01-27T15:01:24.520Z
9227990 9227990 20260118190417_F3cuE DE0011 2026-01-20T14:15:20.762Z 2026-01-27T15:01:09.856Z
9218441 9218441 20260117035346_CW8Pc DE0011 2026-01-18T14:12:07.557Z 2026-01-25T14:58:25.584Z
9217930 9217930 20260116204922_UzYdz DE0011 2026-01-18T14:09:38.106Z 2026-01-25T14:57:52.322Z
9217745 9217745 20260116192651_on754 DE0011 2026-01-18T14:08:46.179Z 2026-01-25T14:57:46.267Z
9214095 9214095 20260116053326_pbxFh DE0011 2026-01-17T14:20:02.417Z 2026-01-24T15:13:05.606Z
9213825 9213825 20260116044719_NDn29 DE0011 2026-01-17T14:18:42.371Z 2026-01-24T15:12:48.037Z
9212790 9212790 20260116010025_IkoCX DE0011 2026-01-17T14:13:55.837Z 2026-01-24T15:11:26.791Z
9212533 9212533 20260115225139_FwgFU DE0011 2026-01-17T14:12:33.081Z 2026-01-24T15:11:01.513Z
9212124 9212124 20260115191943_rjyGK DE0011 2026-01-17T14:10:05.111Z 2026-01-24T15:10:25.075Z
9188348 9188348 20260111224938_hgmI1 DE0011 2026-01-13T14:11:51.281Z 2026-01-20T15:21:35.679Z
9162706 9162706 20260107041554_hNh1S DE0011 2026-01-08T14:06:33.008Z 2026-01-13T15:02:35.590Z
9158470 9158470 20260105223734_5t0ia DE0011 2026-01-07T14:06:12.573Z 2026-01-13T15:07:23.970Z
9150706 9150706 20260105031446_EZdxQ DE0011 2026-01-06T14:11:04.142Z 2026-01-13T15:13:50.020Z
9150689 9150689 20260105030953_LTXec DE0011 2026-01-06T14:11:01.253Z 2026-01-13T15:13:49.162Z
9150633 9150633 20260105030020_zewVJ DE0011 2026-01-06T14:10:47.516Z 2026-01-13T15:13:44.883Z
9150624 9150624 20260105025938_dkTiL DE0011 2026-01-06T14:10:45.446Z 2026-01-13T15:13:44.351Z
9150581 9150581 20260105025014_1RJ3G DE0011 2026-01-06T14:10:34.562Z 2026-01-13T15:13:42.540Z
9150409 9150409 20260105020736_d929F DE0011 2026-01-06T14:09:54.207Z 2026-01-13T15:13:23.831Z

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