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,786 rows where station_code = "DE0006" 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
9249572 9249572 20260122055125_lZ3G1 DE0006 2026-01-23T14:15:43.786Z 2026-01-29T14:58:45.182Z
9249542 9249542 20260122053921_6VE3Y DE0006 2026-01-23T14:15:40.730Z 2026-01-29T14:58:43.825Z
9249322 9249322 20260122044705_JErFp DE0006 2026-01-23T14:15:10.228Z 2026-01-29T14:58:25.734Z
9249300 9249300 20260122044035_yfy6L DE0006 2026-01-23T14:15:08.238Z 2026-01-29T14:58:22.261Z
9249280 9249280 20260122043722_66heM DE0006 2026-01-23T14:15:06.640Z 2026-01-29T14:58:21.592Z
9248977 9248977 20260122030100_6tzwx DE0006 2026-01-23T14:14:14.891Z 2026-01-29T14:58:02.801Z
9248777 9248777 20260122020822_U3SE0 DE0006 2026-01-23T14:13:50.804Z 2026-01-29T14:57:46.373Z
9248666 9248666 20260122013709_jgqsX DE0006 2026-01-23T14:13:23.300Z 2026-01-29T14:57:39.790Z
9248583 9248583 20260122005157_lgTHK DE0006 2026-01-23T14:13:12.179Z 2026-01-29T14:57:35.412Z
9248516 9248516 20260122002510_FAmPn DE0006 2026-01-23T14:12:58.006Z 2026-01-29T14:57:24.528Z
9248317 9248317 20260121225256_SQYx9 DE0006 2026-01-23T14:12:29.705Z 2026-01-29T14:57:13.583Z
9248154 9248154 20260121215455_y8pBF DE0006 2026-01-23T14:12:09.048Z 2026-01-29T14:57:05.663Z
9247864 9247864 20260121201729_CP2MA DE0006 2026-01-23T14:11:16.939Z 2026-01-29T14:56:41.237Z
9247672 9247672 20260121192543_cvGql DE0006 2026-01-23T14:10:43.143Z 2026-01-29T14:56:22.541Z
9247589 9247589 20260121190928_7CUgL DE0006 2026-01-23T14:10:32.408Z 2026-01-29T14:56:16.110Z
9242872 9242872 20260121030712_R5Gqp DE0006 2026-01-22T14:19:37.721Z 2026-01-29T15:04:25.604Z
9242855 9242855 20260121025912_r6UST DE0006 2026-01-22T14:19:33.178Z 2026-01-29T15:04:24.383Z
9237190 9237190 20260120044748_Fikmz DE0006 2026-01-21T14:25:30.397Z 2026-01-28T15:01:01.926Z
9237171 9237171 20260120044646_fpxa5 DE0006 2026-01-21T14:25:27.914Z 2026-01-28T15:01:01.112Z
9237096 9237096 20260120043643_S8jwX DE0006 2026-01-21T14:25:16.349Z 2026-01-28T15:00:58.015Z
9236603 9236603 20260120034000_1mI2U DE0006 2026-01-21T14:23:30.752Z 2026-01-28T15:00:24.260Z
9236002 9236002 20260120022646_2VV04 DE0006 2026-01-21T14:21:13.043Z 2026-01-28T14:59:32.424Z
9235830 9235830 20260120020549_fxxEK DE0006 2026-01-21T14:20:30.911Z 2026-01-28T14:59:23.081Z
9235793 9235793 20260120015947_dgFSi DE0006 2026-01-21T14:20:17.249Z 2026-01-28T14:59:21.226Z
9234918 9234918 20260119235000_NCze4 DE0006 2026-01-21T14:16:41.248Z 2026-01-28T14:58:20.812Z
9234047 9234047 20260119192343_SCXbr DE0006 2026-01-21T14:12:01.042Z 2026-01-28T14:57:00.971Z
9229202 9229202 20260119010541_VtiJb DE0006 2026-01-20T14:21:31.566Z 2026-01-27T15:03:11.374Z
9229002 9229002 20260119003314_2376l DE0006 2026-01-20T14:20:34.058Z 2026-01-27T15:02:47.365Z
9228945 9228945 20260119002331_0442Z DE0006 2026-01-20T14:20:16.366Z 2026-01-27T15:02:44.400Z
9228895 9228895 20260119001539_tXnw0 DE0006 2026-01-20T14:20:03.278Z 2026-01-27T15:02:41.544Z
9228818 9228818 20260118235845_UBKLR DE0006 2026-01-20T14:19:40.805Z 2026-01-27T15:02:37.324Z
9181821 9181821 20260111032046_JizUr DE0006 2026-01-12T14:12:14.396Z 2026-01-19T15:17:50.090Z
9144925 9144925 20260104025859_sx6iA DE0006 2026-01-05T14:19:43.484Z 2026-01-12T15:07:19.532Z
9138579 9138579 20260103223342_yI2Y1 DE0006 2026-01-05T14:10:20.998Z 2026-01-12T15:02:53.209Z
9138357 9138357 20260103222051_PkI2x DE0006 2026-01-05T14:09:52.153Z 2026-01-12T15:02:47.304Z
9130576 9130576 20260103034325_C3Jam DE0006 2026-01-04T14:10:46.133Z 2026-01-10T14:59:22.965Z
9113628 9113628 20251231033957_GzoPh DE0006 2026-01-01T14:19:47.952Z 2026-01-08T15:08:54.475Z
9112558 9112558 20251231023705_uuRXW DE0006 2026-01-01T14:15:31.348Z 2026-01-08T15:07:51.973Z
9111700 9111700 20251231013623_PrNop DE0006 2026-01-01T14:12:31.279Z 2026-01-08T15:06:53.154Z
9111070 9111070 20251231003434_TspNU DE0006 2026-01-01T14:10:02.131Z 2026-01-08T15:06:14.139Z
9110757 9110757 20251230235610_ftbtA DE0006 2026-01-01T14:08:39.396Z 2026-01-08T15:05:49.353Z
9110250 9110250 20251230224122_1undO DE0006 2026-01-01T14:06:29.963Z 2026-01-08T15:05:14.831Z
9109313 9109313 20251227202938_6h2z8 DE0006 2025-12-31T15:21:05.843Z 2026-01-04T15:35:32.965Z
9104532 9104532 20251230060417_jQtUo DE0006 2025-12-31T14:21:33.442Z 2026-01-07T15:09:46.840Z
9104511 9104511 20251230060241_shXq3 DE0006 2025-12-31T14:21:29.403Z 2026-01-07T15:09:45.365Z
9099604 9099604 20251225033516_Irdnc DE0006 2025-12-30T15:28:45.833Z 2026-01-02T15:44:16.632Z
9099595 9099595 20251225032020_4IoCr DE0006 2025-12-30T15:28:09.207Z 2026-01-02T15:44:11.863Z
9099037 9099037 20251225220948_7NN0B DE0006 2025-12-30T15:11:53.247Z 2026-01-03T15:31:54.552Z
9098931 9098931 20251227202938_AaWoP DE0006 2025-12-30T15:11:16.848Z 2026-01-04T15:35:33.054Z
9098374 9098374 20251227185719_8U4mV DE0006 2025-12-30T15:10:25.837Z 2026-01-04T15:34:58.835Z
9097961 9097961 20251227175155_KtQiL DE0006 2025-12-30T15:09:43.461Z 2026-01-04T15:34:27.545Z
9092807 9092807 20251227030229_UAgi9 DE0006 2025-12-30T15:00:38.627Z 2026-01-04T15:27:38.582Z
9092778 9092778 20251227024907_4kyMG DE0006 2025-12-30T15:00:28.954Z 2026-01-04T15:27:31.449Z
9092734 9092734 20251227023423_Nw43p DE0006 2025-12-30T15:00:02.112Z 2026-01-04T15:27:05.975Z
9090985 9090985 20251228173453_objU5 DE0006 2025-12-30T14:51:33.801Z 2026-01-05T15:13:46.869Z
9090804 9090804 20251228165803_vdmhH DE0006 2025-12-30T14:51:06.342Z 2026-01-05T15:13:38.844Z
9084009 9084009 20251228010055_cD3DQ DE0006 2025-12-30T14:34:29.528Z 2026-01-05T15:08:24.832Z
9082948 9082948 20251227221539_wP3rB DE0006 2025-12-30T14:31:12.771Z 2025-12-30T14:53:53.905Z
9082818 9082818 20251227214942_ewMQY DE0006 2025-12-30T14:30:44.608Z 2026-01-05T15:07:20.090Z
9082713 9082713 20251227213301_G5lD7 DE0006 2025-12-30T14:30:20.133Z 2026-01-05T15:07:15.747Z
9081114 9081114 20251229054601_gaCr4 DE0006 2025-12-30T14:23:52.801Z 2026-01-06T15:18:51.755Z
9080912 9080912 20251229051853_ZzH83 DE0006 2025-12-30T14:23:04.064Z 2026-01-06T15:18:44.211Z
9080819 9080819 20251229050838_k5C2O DE0006 2025-12-30T14:22:45.093Z 2026-01-06T15:18:31.325Z
9080150 9080150 20251229041811_a26qq DE0006 2025-12-30T14:20:02.330Z 2026-01-06T15:17:53.623Z
9080010 9080010 20251229040638_t80ou DE0006 2025-12-30T14:19:22.921Z 2026-01-06T15:17:48.034Z
9079737 9079737 20251229033959_pZWWn DE0006 2025-12-30T14:18:13.893Z 2026-01-06T15:17:37.005Z
9079584 9079584 20251229032912_Cgshb DE0006 2025-12-30T14:17:41.189Z 2026-01-06T15:17:18.520Z
9079491 9079491 20251229032148_aQnSx DE0006 2025-12-30T14:17:18.538Z 2026-01-06T15:17:15.096Z
9078826 9078826 20251229023249_e0EIS DE0006 2025-12-30T14:14:36.585Z 2026-01-06T15:16:42.962Z
9078807 9078807 20251229023029_clQTt DE0006 2025-12-30T14:14:33.277Z 2025-12-31T14:34:31.774Z
9078538 9078538 20251229020844_57W3T DE0006 2025-12-30T14:13:23.817Z 2026-01-06T15:16:31.224Z
9078383 9078383 20251229015432_EjhCL DE0006 2025-12-30T14:12:46.072Z 2026-01-06T15:16:17.121Z
9078128 9078128 20251229013315_MIsPz DE0006 2025-12-30T14:11:36.141Z 2026-01-06T15:16:06.087Z
9077971 9077971 20251229012009_MBq2l DE0006 2025-12-30T14:10:43.486Z 2026-01-06T15:16:00.832Z
9077842 9077842 20251229011056_mJhfQ DE0006 2025-12-30T14:09:51.613Z 2026-01-06T15:15:55.263Z
9077273 9077273 20251229001230_ZMKVz DE0006 2025-12-30T14:07:21.370Z 2026-01-06T15:15:24.091Z
9077118 9077118 20251228234921_Z71nG DE0006 2025-12-30T14:06:37.683Z 2026-01-06T15:15:08.780Z
9077034 9077034 20251228233707_UVow9 DE0006 2025-12-30T14:06:10.596Z 2026-01-06T15:15:04.107Z
9076953 9076953 20251228232831_3Yz8m DE0006 2025-12-30T14:05:53.872Z 2026-01-06T15:15:01.557Z
9076778 9076778 20251228230548_TYYfe DE0006 2025-12-30T14:05:02.997Z 2026-01-06T15:14:54.018Z
9075162 9075162 20251225211209_qTGUc DE0006 2025-12-29T15:01:31.124Z 2026-01-02T15:48:45.643Z
9072516 9072516 20251226211121_jlKnt DE0006 2025-12-29T14:51:01.504Z 2026-01-03T15:44:08.464Z
9072289 9072289 20251226204718_LOvvP DE0006 2025-12-29T14:50:32.762Z 2026-01-03T15:44:01.154Z
9071944 9071944 20251226195627_c9H92 DE0006 2025-12-29T14:50:16.006Z 2026-01-03T15:43:33.936Z
9071798 9071798 20251226193231_oSlNu DE0006 2025-12-29T14:49:52.527Z 2026-01-03T15:43:26.662Z
9071677 9071677 20251226191224_bHhP6 DE0006 2025-12-29T14:49:42.526Z 2026-01-03T15:43:09.385Z
9065612 9065612 20251226052011_3QAq6 DE0006 2025-12-29T14:38:44.128Z 2026-01-03T15:37:02.021Z
9065125 9065125 20251226045252_C9ClI DE0006 2025-12-29T14:38:01.124Z 2025-12-29T14:51:15.317Z
9064938 9064938 20251226044523_r27It DE0006 2025-12-29T14:37:49.323Z 2026-01-03T15:36:31.986Z
9064922 9064922 20251226044236_c1Ih6 DE0006 2025-12-29T14:37:47.706Z 2026-01-03T15:36:31.075Z
9064262 9064262 20251226040046_5KDzY DE0006 2025-12-29T14:36:42.141Z 2026-01-03T15:35:56.389Z
9064248 9064248 20251226035959_1S9RT DE0006 2025-12-29T14:36:40.351Z 2026-01-03T15:35:55.734Z
9064224 9064224 20251226035614_GB89E DE0006 2025-12-29T14:36:36.617Z 2026-01-03T15:35:54.800Z
9064087 9064087 20251226034826_wztks DE0006 2025-12-29T14:36:15.102Z 2026-01-03T15:35:49.764Z
9063478 9063478 20251226031654_D17qW DE0006 2025-12-29T14:35:25.536Z 2026-01-03T15:35:20.918Z
9063147 9063147 20251226025657_Cb9uG DE0006 2025-12-29T14:34:44.913Z 2026-01-03T15:35:05.855Z
9063047 9063047 20251226025203_6DP2d DE0006 2025-12-29T14:34:38.797Z 2026-01-03T15:35:02.415Z
9062587 9062587 20251226022536_9KtL2 DE0006 2025-12-29T14:33:39.813Z 2026-01-03T15:34:35.979Z
9062569 9062569 20251226022302_381L9 DE0006 2025-12-29T14:33:37.544Z 2026-01-03T15:34:35.398Z
9062066 9062066 20251226014709_KTGJk DE0006 2025-12-29T14:32:42.088Z 2026-01-03T15:34:07.290Z

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