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,529 rows where station_code = "DE0007" 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
8681159 8681159 20251203022913_L2Teb DE0007 2025-12-04T14:13:58.132Z 2025-12-05T14:21:19.050Z
8681127 8681127 20251203022656_AO57t DE0007 2025-12-04T14:13:54.827Z 2025-12-05T14:21:17.708Z
8681010 8681010 20251203021210_TyzrD DE0007 2025-12-04T14:13:33.163Z 2025-12-05T14:21:11.011Z
8666832 8666832 20251201041333_aKC3l DE0007 2025-12-02T14:28:13.203Z 2025-12-05T14:36:25.018Z
8666462 8666462 20251201054432_5agFB DE0007 2025-12-02T14:26:16.046Z 2025-12-05T14:36:59.134Z
8666446 8666446 20251201054241_23cdK DE0007 2025-12-02T14:26:14.518Z 2025-12-05T14:36:58.785Z
8666439 8666439 20251201054037_RmJF7 DE0007 2025-12-02T14:26:12.527Z 2025-12-05T14:36:58.451Z
8666395 8666395 20251201053317_5IxxD DE0007 2025-12-02T14:25:56.561Z 2025-12-05T14:36:57.170Z
8666366 8666366 20251201052250_BUGIL DE0007 2025-12-02T14:25:53.452Z 2025-12-05T14:36:55.652Z
8666358 8666358 20251201052148_liFHQ DE0007 2025-12-02T14:25:52.561Z 2025-12-05T14:36:55.353Z
8666333 8666333 20251201051611_tMZ7z DE0007 2025-12-02T14:25:48.025Z 2025-12-05T14:36:54.528Z
8666241 8666241 20251201045919_Tk5xu DE0007 2025-12-02T14:25:39.108Z 2025-12-05T14:36:50.551Z
8666236 8666236 20251201045518_fy047 DE0007 2025-12-02T14:25:38.701Z 2025-12-05T14:36:47.539Z
8665917 8665917 20251201041111_nAqt9 DE0007 2025-12-02T14:24:55.422Z 2025-12-05T14:36:24.141Z
8665749 8665749 20251201035429_22Zh2 DE0007 2025-12-02T14:24:24.786Z 2025-12-05T14:36:17.987Z
8665743 8665743 20251201035358_wPTuF DE0007 2025-12-02T14:24:24.067Z 2025-12-05T14:36:17.718Z
8665729 8665729 20251201035154_PaoJ2 DE0007 2025-12-02T14:24:22.490Z 2025-12-05T14:36:17.372Z
8665691 8665691 20251201035042_2FHf4 DE0007 2025-12-02T14:24:20.125Z 2025-12-05T14:36:16.225Z
8665660 8665660 20251201034809_O712O DE0007 2025-12-02T14:24:17.069Z 2025-12-05T14:36:15.264Z
8665629 8665629 20251201034444_3cYrH DE0007 2025-12-02T14:24:14.121Z 2025-12-05T14:36:14.494Z
8665507 8665507 20251201032932_W2yoW DE0007 2025-12-02T14:23:47.938Z 2025-12-05T14:36:09.964Z
8665480 8665480 20251201032346_2Ffst DE0007 2025-12-02T14:23:45.332Z 2025-12-05T14:36:08.849Z
8665278 8665278 20251201025929_3xewr DE0007 2025-12-02T14:23:16.728Z 2025-12-05T14:35:48.411Z
8663932 8663932 20251130224027_GXGJn DE0007 2025-12-02T14:19:37.279Z 2025-12-05T14:34:38.011Z
8613837 8613837 20251126033702_2LOZQ DE0007 2025-11-27T14:26:51.049Z 2025-12-04T15:09:52.547Z
8613581 8613581 20251126032440_Sgw3m DE0007 2025-11-27T14:26:15.881Z 2025-12-04T15:09:49.483Z
8574297 8574297 20251122054408_jLnJH DE0007 2025-11-23T14:43:04.815Z 2025-11-30T15:07:04.602Z
8573901 8573901 20251122043538_x1ZJp DE0007 2025-11-23T14:42:06.114Z 2025-11-30T15:06:48.832Z
8573835 8573835 20251122041944_loTO4 DE0007 2025-11-23T14:42:02.475Z 2025-11-23T14:42:02.475Z
8573779 8573779 20251122040905_8c6YU DE0007 2025-11-23T14:41:59.250Z 2025-11-30T15:06:37.555Z
8573732 8573732 20251122040005_tqaoE DE0007 2025-11-23T14:41:56.702Z 2025-11-30T15:06:36.577Z
8573540 8573540 20251122032849_ecHAj DE0007 2025-11-23T14:41:16.161Z 2025-11-30T15:06:30.518Z
8573407 8573407 20251122030819_u5zI3 DE0007 2025-11-23T14:41:10.467Z 2025-11-30T15:06:22.507Z
8573387 8573387 20251122030349_lYoIA DE0007 2025-11-23T14:41:09.254Z 2025-11-30T15:06:19.903Z
8573138 8573138 20251122023315_4ciJb DE0007 2025-11-23T14:40:45.861Z 2025-11-30T15:06:10.620Z
8572423 8572423 20251122004209_JtX07 DE0007 2025-11-23T14:39:12.922Z 2025-11-30T15:05:49.500Z
8572354 8572354 20251122003134_zZ6ZX DE0007 2025-11-23T14:38:58.617Z 2025-11-30T15:05:47.579Z
8572067 8572067 20251121233049_ugzN2 DE0007 2025-11-23T14:37:57.536Z 2025-11-30T15:05:36.500Z
8571701 8571701 20251121215111_fO3KU DE0007 2025-11-23T14:37:40.457Z 2025-11-30T15:05:14.552Z
8571555 8571555 20251121211608_0fVjl DE0007 2025-11-23T14:36:54.128Z 2025-11-30T15:05:10.039Z
8571509 8571509 20251121210216_yaagH DE0007 2025-11-23T14:36:45.722Z 2025-11-30T15:05:07.558Z
8571503 8571503 20251121210046_hqUA6 DE0007 2025-11-23T14:36:44.095Z 2025-11-30T15:05:07.523Z
8571345 8571345 20251121201900_e91GU DE0007 2025-11-23T14:36:12.138Z 2025-11-30T15:04:54.445Z
8571314 8571314 20251121201314_dl3ef DE0007 2025-11-23T14:36:09.733Z 2025-11-30T15:04:53.737Z
8571168 8571168 20251121193155_M3Fw6 DE0007 2025-11-23T14:36:01.712Z 2025-11-30T15:04:34.264Z
8571066 8571066 20251121184922_gLGr3 DE0007 2025-11-23T14:35:56.000Z 2025-11-30T15:04:25.493Z
8570894 8570894 20251121174553_2lduD DE0007 2025-11-23T14:35:06.965Z 2025-11-30T15:03:57.708Z
8548526 8548526 20251120210012_wDZxY DE0007 2025-11-22T14:17:12.600Z 2025-11-29T14:54:22.794Z
8547509 8547509 20251120195723_4Sv63 DE0007 2025-11-22T14:15:14.411Z 2025-11-29T14:54:20.212Z
8525624 8525624 20251118181120_cEP1z DE0007 2025-11-20T14:37:11.770Z 2025-11-27T15:11:28.981Z
8520459 8520459 20251118192756_Iivb0 DE0007 2025-11-20T14:09:59.476Z 2025-11-27T15:11:33.418Z
8509793 8509793 20251118032953_k53TW DE0007 2025-11-19T14:20:31.636Z 2025-11-26T15:07:58.094Z
8509503 8509503 20251118025335_3pY8R DE0007 2025-11-19T14:19:49.703Z 2025-11-26T15:07:56.251Z
8508789 8508789 20251118013346_Evr1o DE0007 2025-11-19T14:18:12.822Z 2025-11-26T15:07:52.171Z
8508785 8508785 20251118013345_f6rKY DE0007 2025-11-19T14:18:12.421Z 2025-11-26T15:07:52.164Z
8508565 8508565 20251118011652_HvOdt DE0007 2025-11-19T14:17:56.484Z 2025-11-26T15:07:51.343Z
8508487 8508487 20251118010756_O6j4Z DE0007 2025-11-19T14:17:50.646Z 2025-11-26T15:07:51.020Z
8508435 8508435 20251118010159_Ixk5R DE0007 2025-11-19T14:17:35.350Z 2025-11-26T15:07:50.773Z
8508348 8508348 20251118005237_51ITp DE0007 2025-11-19T14:17:24.838Z 2025-11-26T15:07:50.403Z
8508229 8508229 20251118004357_2RFb4 DE0007 2025-11-19T14:17:13.089Z 2025-11-26T15:07:49.871Z
8507811 8507811 20251117235948_A12J3 DE0007 2025-11-19T14:16:08.586Z 2025-11-26T15:07:48.047Z
8507762 8507762 20251117235535_sA6FE DE0007 2025-11-19T14:16:01.900Z 2025-11-26T15:07:47.747Z
8507537 8507537 20251117233217_mBt0l DE0007 2025-11-19T14:15:26.983Z 2025-11-26T15:07:46.849Z
8507082 8507082 20251117224143_qhvbw DE0007 2025-11-19T14:14:21.048Z 2025-11-26T15:07:44.837Z
8506838 8506838 20251117222044_0UM3P DE0007 2025-11-19T14:13:46.578Z 2025-11-26T15:07:43.594Z
8504859 8504859 20251117192928_IY5TN DE0007 2025-11-19T14:08:57.594Z 2025-11-26T15:07:34.337Z
8504430 8504430 20251117185638_KZrwR DE0007 2025-11-19T14:08:01.660Z 2025-11-26T15:07:20.353Z
8481632 8481632 20251116034151_to9iA DE0007 2025-11-17T14:21:27.516Z 2025-11-24T15:05:05.084Z
8458460 8458460 20251114001813_e4D32 DE0007 2025-11-15T14:16:52.581Z 2025-11-22T15:21:03.724Z
8450510 8450510 20251113044050_XHEh2 DE0007 2025-11-14T14:23:33.502Z 2025-11-21T15:12:42.785Z
8449943 8449943 20251113032255_A6qZY DE0007 2025-11-14T14:22:03.227Z 2025-11-21T15:12:24.911Z
8449924 8449924 20251113032019_2ff4P DE0007 2025-11-14T14:22:00.379Z 2025-11-21T15:12:23.360Z
8449848 8449848 20251113031118_MTbUb DE0007 2025-11-14T14:21:45.887Z 2025-11-21T15:12:20.970Z
8449680 8449680 20251113024457_3ThQw DE0007 2025-11-14T14:21:08.947Z 2025-11-21T15:12:12.564Z
8440013 8440013 20251112050921_dbPxS DE0007 2025-11-13T14:28:00.670Z 2025-11-20T15:25:39.982Z
8439562 8439562 20251112040548_9SLka DE0007 2025-11-13T14:26:45.269Z 2025-11-20T15:25:28.336Z
8439127 8439127 20251112031722_GRC62 DE0007 2025-11-13T14:25:47.863Z 2025-11-20T15:25:08.611Z
8439083 8439083 20251112031132_sNR2f DE0007 2025-11-13T14:25:30.360Z 2025-11-20T15:25:04.080Z
8439064 8439064 20251112030846_mw0ho DE0007 2025-11-13T14:25:27.891Z 2025-11-20T15:25:01.052Z
8438768 8438768 20251112023802_tOIF9 DE0007 2025-11-13T14:24:40.982Z 2025-11-20T15:24:47.222Z
8437983 8437983 20251112010652_8Dvgd DE0007 2025-11-13T14:22:25.369Z 2025-11-20T15:24:05.173Z
8437388 8437388 20251111235720_JWWgQ DE0007 2025-11-13T14:21:00.928Z 2025-11-20T15:23:29.684Z
8437351 8437351 20251111235309_zYt7V DE0007 2025-11-13T14:20:54.669Z 2025-11-20T15:23:28.645Z
8436693 8436693 20251111222025_mAwbY DE0007 2025-11-13T14:18:55.900Z 2025-11-20T15:22:59.584Z
8436451 8436451 20251111214200_rDGrD DE0007 2025-11-13T14:18:14.466Z 2025-11-20T15:22:51.312Z
8435503 8435503 20251111194217_Vx7zv DE0007 2025-11-13T14:15:39.232Z 2025-11-20T15:22:21.634Z
8435136 8435136 20251111191352_jwCfI DE0007 2025-11-13T14:14:35.487Z 2025-11-20T15:22:04.714Z
8414687 8414687 20251110033116_qCInB DE0007 2025-11-11T14:21:29.287Z 2025-11-18T15:21:11.459Z
8389410 8389410 20251106205305_1bM9R DE0007 2025-11-08T14:06:54.412Z 2025-11-15T14:59:38.150Z
8389055 8389055 20251106190414_kq6HR DE0007 2025-11-08T14:04:58.824Z 2025-11-15T14:59:29.179Z
8386072 8386072 20251106022647_nBx8N DE0007 2025-11-07T14:09:27.740Z 2025-11-14T15:08:34.179Z
8386032 8386032 20251106022123_aMjNB DE0007 2025-11-07T14:09:21.331Z 2025-11-14T15:08:32.890Z
8385453 8385453 20251106000056_bx458 DE0007 2025-11-07T14:06:48.236Z 2025-11-14T15:08:12.759Z
8385318 8385318 20251105230340_aoH50 DE0007 2025-11-07T14:06:11.257Z 2025-11-14T15:08:07.593Z
8385026 8385026 20251105205526_CghyO DE0007 2025-11-07T14:04:53.277Z 2025-11-14T15:07:51.181Z
8384886 8384886 20251105191005_1SuI5 DE0007 2025-11-07T14:04:16.334Z 2025-11-14T15:07:46.840Z
8381398 8381398 20251105050234_ajDie DE0007 2025-11-06T14:14:59.574Z 2025-11-13T15:15:29.047Z
8381127 8381127 20251105040337_2DN5d DE0007 2025-11-06T14:14:02.168Z 2025-11-13T15:15:18.267Z
8379963 8379963 20251105000956_B3tOX DE0007 2025-11-06T14:09:56.562Z 2025-11-13T15:14:34.049Z
8379349 8379349 20251104214732_uVYHt DE0007 2025-11-06T14:07:28.785Z 2025-11-13T15:14:10.334Z

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