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

4,354 rows where station_code = "DE0008" 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
9259400 9259400 20260124204122_yEX32 DE0008 2026-01-26T14:16:53.340Z 2026-01-29T14:42:51.397Z
9258826 9258826 20260124172016_41X8M DE0008 2026-01-26T14:14:34.155Z 2026-01-29T14:42:13.027Z
9249411 9249411 20260122051133_XPMap DE0008 2026-01-23T14:15:19.388Z 2026-01-29T14:58:29.342Z
9249342 9249342 20260122045720_rN3K2 DE0008 2026-01-23T14:15:12.530Z 2026-01-29T14:58:26.825Z
9249337 9249337 20260122045719_1iZmC DE0008 2026-01-23T14:15:12.281Z 2026-01-29T14:58:26.682Z
9249193 9249193 20260122040355_fnXP4 DE0008 2026-01-23T14:14:49.207Z 2026-01-29T14:58:16.200Z
9248958 9248958 20260122025511_G2eQj DE0008 2026-01-23T14:14:13.024Z 2026-01-29T14:57:56.698Z
9248769 9248769 20260122020425_mi8B5 DE0008 2026-01-23T14:13:46.655Z 2026-01-29T14:57:45.917Z
9248755 9248755 20260122020054_D3Hdf DE0008 2026-01-23T14:13:38.607Z 2026-01-29T14:57:45.222Z
9248697 9248697 20260122014458_7zWGq DE0008 2026-01-23T14:13:27.763Z 2026-01-29T14:57:41.571Z
9248473 9248473 20260122000404_E1xMy DE0008 2026-01-23T14:12:52.852Z 2026-01-29T14:57:22.693Z
9248455 9248455 20260121235012_ry0kX DE0008 2026-01-23T14:12:49.929Z 2026-01-29T14:57:19.657Z
9248040 9248040 20260121211358_tPC3o DE0008 2026-01-23T14:11:46.526Z 2026-01-29T14:56:51.990Z
9247841 9247841 20260121200523_cqZqE DE0008 2026-01-23T14:11:14.765Z 2026-01-29T14:56:40.224Z
9247559 9247559 20260121190114_7Ygow DE0008 2026-01-23T14:10:28.462Z 2026-01-29T14:56:14.443Z
9247523 9247523 20260121185112_5DSk7 DE0008 2026-01-23T14:10:23.627Z 2026-01-29T14:56:12.801Z
9247250 9247250 20260121174432_10TmP DE0008 2026-01-23T14:09:31.030Z 2026-01-29T14:55:52.025Z
9243876 9243876 20260121052908_N6S21 DE0008 2026-01-22T14:23:24.686Z 2026-01-29T15:05:30.917Z
9243839 9243839 20260121052444_qeubU DE0008 2026-01-22T14:23:20.560Z 2026-01-29T15:05:29.594Z
9243604 9243604 20260121045127_zeuSF DE0008 2026-01-22T14:22:22.033Z 2026-01-29T15:05:19.682Z
9243312 9243312 20260121041225_pjyZJ DE0008 2026-01-22T14:21:24.916Z 2026-01-29T15:04:55.142Z
9242868 9242868 20260121030403_0U5Uj DE0008 2026-01-22T14:19:36.903Z 2026-01-29T15:04:25.315Z
9242787 9242787 20260121024351_ux69F DE0008 2026-01-22T14:19:13.550Z 2026-01-29T15:04:20.992Z
9242487 9242487 20260121020446_QkdW2 DE0008 2026-01-22T14:18:01.794Z 2026-01-29T15:04:01.039Z
9242455 9242455 20260121015254_IZuuI DE0008 2026-01-22T14:17:53.882Z 2026-01-29T15:03:59.377Z
9242375 9242375 20260121014035_3JTi2 DE0008 2026-01-22T14:17:30.152Z 2026-01-29T15:03:53.765Z
9242338 9242338 20260121013306_NDyRZ DE0008 2026-01-22T14:17:23.822Z 2026-01-29T15:03:45.021Z
9241741 9241741 20260120220717_YhWZK DE0008 2026-01-22T14:14:21.451Z 2026-01-29T15:03:00.259Z
9241346 9241346 20260120200422_22voU DE0008 2026-01-22T14:12:45.918Z 2026-01-29T15:02:32.891Z
9241202 9241202 20260120192604_7IB1I DE0008 2026-01-22T14:12:07.941Z 2026-01-29T15:02:26.742Z
9237521 9237521 20260120052845_wuoDm DE0008 2026-01-21T14:26:51.362Z 2026-01-21T14:31:13.844Z
9237492 9237492 20260120052429_P27Zt DE0008 2026-01-21T14:26:47.138Z 2026-01-28T15:01:28.234Z
9237217 9237217 20260120045201_V8AjY DE0008 2026-01-21T14:25:42.474Z 2026-01-28T15:01:03.334Z
9237214 9237214 20260120045201_bLYMU DE0008 2026-01-21T14:25:42.182Z 2026-01-28T15:01:03.241Z
9237203 9237203 20260120045010_er2V4 DE0008 2026-01-21T14:25:32.293Z 2026-01-28T15:01:02.605Z
9237109 9237109 20260120043846_S4vfh DE0008 2026-01-21T14:25:17.902Z 2026-01-28T15:00:58.381Z
9237040 9237040 20260120042914_ppLXv DE0008 2026-01-21T14:25:00.558Z 2026-01-28T15:00:55.138Z
9236953 9236953 20260120042232_0g0oH DE0008 2026-01-21T14:24:35.521Z 2026-01-28T15:00:50.555Z
9236388 9236388 20260120030919_4gdVN DE0008 2026-01-21T14:22:33.184Z 2026-01-28T14:59:57.983Z
9236266 9236266 20260120025411_MJqBr DE0008 2026-01-21T14:22:13.223Z 2026-01-28T14:59:52.637Z
9235909 9235909 20260120021627_bzS9X DE0008 2026-01-21T14:20:43.946Z 2026-01-28T14:59:28.398Z
9235794 9235794 20260120015947_dgFSi DE0008 2026-01-21T14:20:17.249Z 2026-01-28T14:59:21.226Z
9235410 9235410 20260120010718_qw8DC DE0008 2026-01-21T14:18:49.401Z 2026-01-28T14:58:53.562Z
9235210 9235210 20260120004338_du8KG DE0008 2026-01-21T14:17:55.140Z 2026-01-28T14:58:43.602Z
9235034 9235034 20260120001645_xaiFF DE0008 2026-01-21T14:17:14.175Z 2026-01-28T14:58:26.023Z
9234747 9234747 20260119231440_2bAsz DE0008 2026-01-21T14:15:58.315Z 2026-01-28T14:58:04.213Z
9234035 9234035 20260119192117_z7jqo DE0008 2026-01-21T14:11:58.270Z 2026-01-28T14:57:00.383Z
9229229 9229229 20260119011100_UvDmR DE0008 2026-01-20T14:21:38.442Z 2026-01-27T15:03:12.893Z
9228946 9228946 20260119002331_0442Z DE0008 2026-01-20T14:20:16.366Z 2026-01-27T15:02:44.400Z
9228702 9228702 20260118233719_J6Jdy DE0008 2026-01-20T14:19:07.571Z 2026-01-27T15:02:18.136Z
9228631 9228631 20260118231755_tj04w DE0008 2026-01-20T14:18:45.014Z 2026-01-27T15:02:11.871Z
9228370 9228370 20260118215708_AyoZ7 DE0008 2026-01-20T14:17:27.334Z 2026-01-27T15:01:56.810Z
9228239 9228239 20260118205100_L2znM DE0008 2026-01-20T14:16:50.598Z 2026-01-27T15:01:35.786Z
9228177 9228177 20260118202508_riqLv DE0008 2026-01-20T14:16:31.062Z 2026-01-27T15:01:31.882Z
9228078 9228078 20260118194616_lGKJI DE0008 2026-01-20T14:15:53.991Z 2026-01-27T15:01:24.520Z
9227989 9227989 20260118190417_F3cuE DE0008 2026-01-20T14:15:20.737Z 2026-01-27T15:01:09.856Z
9217929 9217929 20260116204922_UzYdz DE0008 2026-01-18T14:09:38.106Z 2026-01-25T14:57:52.322Z
9217744 9217744 20260116192651_on754 DE0008 2026-01-18T14:08:46.179Z 2026-01-25T14:57:46.267Z
9211688 9211688 20260115171801_3VUSB DE0008 2026-01-17T14:07:58.208Z 2026-01-24T15:09:46.586Z
9182598 9182598 20260111055308_3E3X1 DE0008 2026-01-12T14:15:06.393Z 2026-01-19T15:18:50.827Z
9182489 9182489 20260111053011_y5H4q DE0008 2026-01-12T14:14:44.277Z 2026-01-19T15:18:42.318Z
9181769 9181769 20260111030531_ckBRk DE0008 2026-01-12T14:12:05.666Z 2026-01-19T15:17:47.927Z
9151092 9151092 20260105044126_gDtTJ DE0008 2026-01-06T14:12:35.097Z 2026-01-13T15:14:18.738Z
9150770 9150770 20260105032728_y4k4L DE0008 2026-01-06T14:11:19.558Z 2026-01-13T15:14:00.114Z
9150495 9150495 20260105023006_NiASw DE0008 2026-01-06T14:10:14.284Z 2026-01-13T15:13:35.800Z
9144926 9144926 20260104025859_sx6iA DE0008 2026-01-05T14:19:43.484Z 2026-01-12T15:07:19.532Z
9144771 9144771 20260104025346_RfJGx DE0008 2026-01-05T14:19:34.345Z 2026-01-12T15:07:16.627Z
9143544 9143544 20260104021528_BNnbU DE0008 2026-01-05T14:17:49.942Z 2026-01-12T15:06:26.605Z
9143365 9143365 20260104020705_eEuxS DE0008 2026-01-05T14:17:25.493Z 2026-01-12T15:06:20.923Z
9142337 9142337 20260104013130_9quK2 DE0008 2026-01-05T14:15:59.318Z 2026-01-12T15:05:40.491Z
9139700 9139700 20260103234051_MW5oi DE0008 2026-01-05T14:11:58.092Z 2026-01-12T15:03:46.860Z
9138689 9138689 20260103224049_IU0mR DE0008 2026-01-05T14:10:28.780Z 2026-01-12T15:02:57.045Z
9118734 9118734 20251230052718_bEiwR DE0008 2026-01-01T14:49:13.672Z 2026-01-07T15:09:19.693Z
9112647 9112647 20251231024425_d5dzj DE0008 2026-01-01T14:15:52.698Z 2026-01-08T15:08:01.595Z
9112379 9112379 20251231022315_UeMO2 DE0008 2026-01-01T14:14:54.553Z 2026-01-08T15:07:40.667Z
9111848 9111848 20251231014837_GodCW DE0008 2026-01-01T14:13:02.574Z 2026-01-08T15:07:06.552Z
9111845 9111845 20251231014834_YkQT1 DE0008 2026-01-01T14:13:01.865Z 2026-01-08T15:07:06.331Z
9111805 9111805 20251231014509_31no7 DE0008 2026-01-01T14:12:53.892Z 2026-01-08T15:07:04.641Z
9110910 9110910 20251231001749_fj1yU DE0008 2026-01-01T14:09:21.440Z 2026-01-08T15:06:03.675Z
9110185 9110185 20251230222857_RB7o8 DE0008 2026-01-01T14:06:14.497Z 2026-01-08T15:05:11.357Z
9109797 9109797 20251230205456_LlWz3 DE0008 2026-01-01T14:03:53.591Z 2026-01-08T15:04:29.894Z
9109720 9109720 20251230203038_3EWRa DE0008 2026-01-01T14:03:09.860Z 2026-01-08T15:04:24.499Z
9109547 9109547 20251230195359_rb6gj DE0008 2026-01-01T14:01:33.623Z 2026-01-08T15:03:59.112Z
9109424 9109424 20251230193502_81o7R DE0008 2026-01-01T14:00:24.918Z 2026-01-08T15:03:48.348Z
9104035 9104035 20251230052718_ZcaQF DE0008 2025-12-31T14:20:04.037Z 2026-01-07T15:09:19.836Z
9099709 9099709 20251225053239_cOVOa DE0008 2025-12-30T15:30:57.545Z 2026-01-02T15:45:26.866Z
9098869 9098869 20251227201450_8GKsC DE0008 2025-12-30T15:11:12.571Z 2026-01-04T15:35:30.371Z
9098375 9098375 20251227185719_8U4mV DE0008 2025-12-30T15:10:25.837Z 2026-01-04T15:34:58.835Z
9093247 9093247 20251227045713_PKDLk DE0008 2025-12-30T15:02:29.833Z 2026-01-04T15:29:42.575Z
9093024 9093024 20251227040955_cNFdB DE0008 2025-12-30T15:01:43.744Z 2026-01-04T15:28:48.755Z
9092649 9092649 20251227020750_LGEYV DE0008 2025-12-30T14:59:40.849Z 2026-01-04T15:26:46.904Z
9083965 9083965 20251228005643_zQpYf DE0008 2025-12-30T14:34:24.440Z 2026-01-05T15:08:22.771Z
9083246 9083246 20251227232553_jikAb DE0008 2025-12-30T14:32:03.798Z 2026-01-05T15:07:42.019Z
9083219 9083219 20251227231853_2nNWU DE0008 2025-12-30T14:31:59.335Z 2026-01-05T15:07:41.262Z
9083191 9083191 20251227231601_SVOVQ DE0008 2025-12-30T14:31:55.048Z 2025-12-30T14:53:54.034Z
9081101 9081101 20251229054441_jP5mJ DE0008 2025-12-30T14:23:50.764Z 2026-01-06T15:18:51.349Z
9081035 9081035 20251229053325_SJSlP DE0008 2025-12-30T14:23:31.709Z 2026-01-06T15:18:48.915Z
9080753 9080753 20251229050531_K2FvE DE0008 2025-12-30T14:22:27.344Z 2026-01-06T15:18:27.646Z
9080237 9080237 20251229042455_dtQn4 DE0008 2025-12-30T14:20:24.636Z 2026-01-06T15:17:57.532Z
9079900 9079900 20251229035527_qJjgm DE0008 2025-12-30T14:18:53.523Z 2026-01-06T15:17:43.711Z

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