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,250 rows where station_code = "DE0009" 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
9259556 9259556 20260124212614_YX8Or DE0009 2026-01-26T14:17:27.550Z 2026-01-29T14:43:05.936Z
9259329 9259329 20260124202733_1vjH4 DE0009 2026-01-26T14:16:32.965Z 2026-01-29T14:42:48.356Z
9249585 9249585 20260122060057_Spg3R DE0009 2026-01-23T14:15:45.763Z 2026-01-29T14:58:46.120Z
9249377 9249377 20260122050447_359VU DE0009 2026-01-23T14:15:14.990Z 2026-01-29T14:58:27.858Z
9249251 9249251 20260122042422_jd1HL DE0009 2026-01-23T14:15:03.348Z 2026-01-29T14:58:19.859Z
9249227 9249227 20260122041708_mmld4 DE0009 2026-01-23T14:15:00.913Z 2026-01-29T14:58:18.454Z
9249223 9249223 20260122041625_ZPrzu DE0009 2026-01-23T14:14:58.230Z 2026-01-29T14:58:18.341Z
9248959 9248959 20260122025511_G2eQj DE0009 2026-01-23T14:14:13.024Z 2026-01-29T14:57:56.698Z
9248916 9248916 20260122024209_PMqSN DE0009 2026-01-23T14:14:06.560Z 2026-01-29T14:57:54.656Z
9248885 9248885 20260122023547_3IIm5 DE0009 2026-01-23T14:14:02.865Z 2026-01-29T14:57:52.942Z
9248572 9248572 20260122004658_wiPzP DE0009 2026-01-23T14:13:06.980Z 2026-01-29T14:57:33.908Z
9248571 9248571 20260122004657_HkoEu DE0009 2026-01-23T14:13:06.105Z 2026-01-29T14:57:28.495Z
9248487 9248487 20260122001007_KHAAq DE0009 2026-01-23T14:12:54.652Z 2026-01-29T14:57:23.268Z
9248456 9248456 20260121235012_ry0kX DE0009 2026-01-23T14:12:49.929Z 2026-01-29T14:57:19.657Z
9248350 9248350 20260121230452_MOo5J DE0009 2026-01-23T14:12:37.527Z 2026-01-29T14:57:15.091Z
9248152 9248152 20260121215304_P0VAG DE0009 2026-01-23T14:12:08.562Z 2026-01-29T14:57:05.436Z
9247673 9247673 20260121192543_cvGql DE0009 2026-01-23T14:10:43.143Z 2026-01-29T14:56:22.541Z
9247560 9247560 20260121190114_7Ygow DE0009 2026-01-23T14:10:28.462Z 2026-01-29T14:56:14.443Z
9247251 9247251 20260121174432_10TmP DE0009 2026-01-23T14:09:31.039Z 2026-01-29T14:55:52.025Z
9244058 9244058 20260121060510_TQ181 DE0009 2026-01-22T14:24:03.233Z 2026-01-29T15:05:50.195Z
9243965 9243965 20260121054506_7n4ul DE0009 2026-01-22T14:23:40.485Z 2026-01-29T15:05:36.906Z
9243605 9243605 20260121045127_zeuSF DE0009 2026-01-22T14:22:22.033Z 2026-01-29T15:05:19.682Z
9241810 9241810 20260120224304_Xxl2y DE0009 2026-01-22T14:14:47.485Z 2026-01-29T15:03:03.818Z
9241532 9241532 20260120205437_1feOJ DE0009 2026-01-22T14:13:34.025Z 2026-01-29T15:02:42.790Z
9237651 9237651 20260120054713_V3UWQ DE0009 2026-01-21T14:27:11.627Z 2026-01-28T15:01:34.526Z
9237392 9237392 20260120051121_DjveA DE0009 2026-01-21T14:26:24.336Z 2026-01-28T15:01:23.443Z
9237381 9237381 20260120050853_zNOFV DE0009 2026-01-21T14:26:21.382Z 2026-01-28T15:01:22.714Z
9237232 9237232 20260120045309_OiM8k DE0009 2026-01-21T14:25:44.477Z 2026-01-28T15:01:05.169Z
9236954 9236954 20260120042232_0g0oH DE0009 2026-01-21T14:24:35.521Z 2026-01-28T15:00:50.555Z
9236847 9236847 20260120040552_SgiHl DE0009 2026-01-21T14:24:21.229Z 2026-01-28T15:00:38.948Z
9235899 9235899 20260120021539_cWLsm DE0009 2026-01-21T14:20:42.259Z 2026-01-28T14:59:26.878Z
9235690 9235690 20260120014808_Lh1O6 DE0009 2026-01-21T14:19:59.301Z 2026-01-28T14:59:16.209Z
9235614 9235614 20260120013840_AUnN9 DE0009 2026-01-21T14:19:35.739Z 2026-01-28T14:59:12.488Z
9235354 9235354 20260120010017_pKq41 DE0009 2026-01-21T14:18:40.910Z 2026-01-28T14:58:50.826Z
9235150 9235150 20260120003717_8I8UB DE0009 2026-01-21T14:17:45.767Z 2026-01-28T14:58:33.092Z
9234813 9234813 20260119233159_3Qn3L DE0009 2026-01-21T14:16:14.015Z 2026-01-28T14:58:14.799Z
9234036 9234036 20260119192117_z7jqo DE0009 2026-01-21T14:11:58.316Z 2026-01-28T14:57:00.383Z
9228573 9228573 20260118225726_agOlG DE0009 2026-01-20T14:18:27.758Z 2026-01-27T15:02:08.717Z
9228081 9228081 20260118194616_GtLe5 DE0009 2026-01-20T14:15:55.387Z 2026-01-27T15:01:24.757Z
9218857 9218857 20260117061032_er0Ee DE0009 2026-01-18T14:13:59.446Z 2026-01-25T14:58:53.734Z
9217708 9217708 20260116191704_ii2UC DE0009 2026-01-18T14:08:37.921Z 2026-01-25T14:57:45.064Z
9214094 9214094 20260116053326_pbxFh DE0009 2026-01-17T14:20:02.417Z 2026-01-24T15:13:05.606Z
9213824 9213824 20260116044719_NDn29 DE0009 2026-01-17T14:18:42.371Z 2026-01-24T15:12:48.036Z
9181598 9181598 20260111022343_S0643 DE0009 2026-01-12T14:11:24.132Z 2026-01-19T15:17:39.357Z
9151043 9151043 20260105042934_MbIiS DE0009 2026-01-06T14:12:26.347Z 2026-01-13T15:14:16.268Z
9150688 9150688 20260105030953_LTXec DE0009 2026-01-06T14:11:01.253Z 2026-01-13T15:13:49.162Z
9147445 9147445 20260104055039_AJEjQ DE0009 2026-01-05T14:24:10.882Z 2026-01-12T15:10:57.139Z
9144927 9144927 20260104025859_sx6iA DE0009 2026-01-05T14:19:43.484Z 2026-01-12T15:07:19.532Z
9144831 9144831 20260104025539_gN3Gv DE0009 2026-01-05T14:19:37.871Z 2026-01-12T15:07:18.123Z
9144730 9144730 20260104025258_WeMpi DE0009 2026-01-05T14:19:32.139Z 2026-01-12T15:07:14.281Z
9142338 9142338 20260104013130_9quK2 DE0009 2026-01-05T14:15:59.318Z 2026-01-12T15:05:40.491Z
9128072 9128072 20260102061022_KwupT DE0009 2026-01-03T14:13:10.103Z 2026-01-09T14:50:22.578Z
9123556 9123556 20251231020423_4vlJr DE0009 2026-01-02T14:30:59.183Z 2026-01-08T15:07:18.149Z
9112380 9112380 20251231022315_UeMO2 DE0009 2026-01-01T14:14:54.553Z 2026-01-08T15:07:40.667Z
9112079 9112079 20251231020421_E9XWt DE0009 2026-01-01T14:13:55.435Z 2026-01-08T15:07:17.944Z
9111849 9111849 20251231014837_GodCW DE0009 2026-01-01T14:13:02.574Z 2026-01-08T15:07:06.552Z
9111846 9111846 20251231014834_YkQT1 DE0009 2026-01-01T14:13:01.865Z 2026-01-08T15:07:06.331Z
9111809 9111809 20251231014520_8Mngi DE0009 2026-01-01T14:12:54.495Z 2026-01-08T15:07:04.773Z
9111701 9111701 20251231013623_PrNop DE0009 2026-01-01T14:12:31.280Z 2026-01-08T15:06:53.154Z
9111182 9111182 20251231004734_aI1G4 DE0009 2026-01-01T14:10:24.618Z 2026-01-08T15:06:19.865Z
9110944 9110944 20251231002112_XNe5g DE0009 2026-01-01T14:09:28.449Z 2026-01-08T15:06:07.922Z
9110794 9110794 20251231000214_h7sFP DE0009 2026-01-01T14:08:46.142Z 2026-01-08T15:05:50.959Z
9110699 9110699 20251230235129_SxFYs DE0009 2026-01-01T14:08:27.031Z 2026-01-08T15:05:45.907Z
9110562 9110562 20251230233033_e8dOo DE0009 2026-01-01T14:07:51.791Z 2026-01-08T15:05:31.717Z
9110502 9110502 20251230232013_Cyhxe DE0009 2026-01-01T14:07:31.843Z 2026-01-08T15:05:28.026Z
9109425 9109425 20251230193502_81o7R DE0009 2026-01-01T14:00:24.943Z 2026-01-08T15:03:48.348Z
9104528 9104528 20251230060330_odsTV DE0009 2025-12-31T14:21:31.909Z 2026-01-07T15:09:46.577Z
9099532 9099532 20251225021933_Erq3t DE0009 2025-12-30T15:27:01.817Z 2026-01-02T15:43:34.370Z
9098474 9098474 20251227191004_0VJjX DE0009 2025-12-30T15:10:31.658Z 2026-01-04T15:35:04.764Z
9091558 9091558 20251228192307_eM1UF DE0009 2025-12-30T14:52:50.274Z 2026-01-05T15:14:17.612Z
9091398 9091398 20251228184734_oFHIg DE0009 2025-12-30T14:52:34.976Z 2026-01-05T15:14:11.461Z
9086155 9086155 20251228043049_y3k1S DE0009 2025-12-30T14:40:24.458Z 2026-01-05T15:09:57.397Z
9083142 9083142 20251227230349_DDuzU DE0009 2025-12-30T14:31:46.524Z 2026-01-05T15:07:38.503Z
9081241 9081241 20251229060859_yavzd DE0009 2025-12-30T14:24:17.735Z 2026-01-06T15:18:55.566Z
9081185 9081185 20251229055813_vssER DE0009 2025-12-30T14:24:03.177Z 2026-01-06T15:18:53.694Z
9081136 9081136 20251229055119_bKw15 DE0009 2025-12-30T14:23:55.606Z 2026-01-06T15:18:52.420Z
9080802 9080802 20251229050749_c9PZY DE0009 2025-12-30T14:22:41.860Z 2026-01-06T15:18:30.598Z
9080677 9080677 20251229050008_vZ3Qa DE0009 2025-12-30T14:22:11.106Z 2026-01-06T15:18:24.594Z
9080005 9080005 20251229040607_wD06G DE0009 2025-12-30T14:19:21.589Z 2026-01-06T15:17:47.928Z
9079901 9079901 20251229035527_qJjgm DE0009 2025-12-30T14:18:53.523Z 2026-01-06T15:17:43.711Z
9079376 9079376 20251229031422_dhW9W DE0009 2025-12-30T14:16:51.482Z 2026-01-06T15:17:11.268Z
9079356 9079356 20251229031236_7rvUN DE0009 2025-12-30T14:16:47.295Z 2026-01-06T15:17:10.431Z
9079130 9079130 20251229025624_2uI3I DE0009 2025-12-30T14:15:53.982Z 2026-01-06T15:17:01.786Z
9077322 9077322 20251229001804_BEyhN DE0009 2025-12-30T14:07:34.395Z 2026-01-06T15:15:25.906Z
9076409 9076409 20251228220822_iXZxI DE0009 2025-12-30T14:03:25.124Z 2026-01-06T15:14:32.130Z
9076164 9076164 20251228211819_JsIT9 DE0009 2025-12-30T14:02:02.284Z 2026-01-06T15:14:16.707Z
9076005 9076005 20251228204743_DtGhg DE0009 2025-12-30T14:01:00.740Z 2026-01-06T15:14:09.818Z
9074334 9074334 20251225194211_lZIw7 DE0009 2025-12-29T15:00:47.261Z 2026-01-02T15:48:29.541Z
9072165 9072165 20251226203337_r3e07 DE0009 2025-12-29T14:50:26.986Z 2025-12-30T15:23:21.196Z
9071339 9071339 20251226182854_cabu9 DE0009 2025-12-29T14:49:24.621Z 2026-01-03T15:42:48.900Z
9071208 9071208 20251226180628_VRGBD DE0009 2025-12-29T14:49:00.477Z 2025-12-30T15:22:32.988Z
9065285 9065285 20251226050427_ZbLhV DE0009 2025-12-29T14:38:24.182Z 2026-01-03T15:36:50.689Z
9065151 9065151 20251226045549_tFdBP DE0009 2025-12-29T14:38:03.633Z 2026-01-03T15:36:46.222Z
9064413 9064413 20251226040914_ByXE4 DE0009 2025-12-29T14:36:50.763Z 2026-01-03T15:36:13.123Z
9063723 9063723 20251226032934_XChoP DE0009 2025-12-29T14:35:50.528Z 2026-01-03T15:35:37.085Z
9063502 9063502 20251226031758_irGWO DE0009 2025-12-29T14:35:27.352Z 2026-01-03T15:35:21.574Z
9062632 9062632 20251226022821_qvLj3 DE0009 2025-12-29T14:33:45.725Z 2026-01-03T15:34:37.535Z
9061591 9061591 20251226011216_9IAok DE0009 2025-12-29T14:31:37.870Z 2026-01-03T15:33:43.410Z
9061142 9061142 20251226003700_xG4M2 DE0009 2025-12-29T14:30:47.612Z 2026-01-03T15:33:28.110Z
9059556 9059556 20251225223028_tn0hq DE0009 2025-12-29T14:27:24.913Z 2026-01-03T15:32:04.206Z

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