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

1,256 rows where station_code = "DK000B" 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
8164078 8164078 20251019175518_mAdxf DK000B 2025-10-22T12:23:09.360Z 2025-10-28T13:07:37.051Z
8147015 8147015 20251019042947_bDaMb DK000B 2025-10-20T12:23:58.396Z 2025-10-27T13:10:46.450Z
8146937 8146937 20251019041837_PErvk DK000B 2025-10-20T12:23:49.571Z 2025-10-27T13:10:45.613Z
8146860 8146860 20251019041028_TK5Jg DK000B 2025-10-20T12:23:41.659Z 2025-10-27T13:10:45.493Z
8146834 8146834 20251019040820_jmvw5 DK000B 2025-10-20T12:23:39.486Z 2025-10-27T13:10:45.458Z
8146769 8146769 20251019040325_qRNCz DK000B 2025-10-20T12:23:33.321Z 2025-10-27T13:10:45.133Z
8146413 8146413 20251019033013_4JuCw DK000B 2025-10-20T12:22:21.717Z 2025-10-27T13:10:40.517Z
8146299 8146299 20251019031910_UAiwZ DK000B 2025-10-20T12:22:02.086Z 2025-10-27T13:10:36.968Z
8146283 8146283 20251019031806_iJZed DK000B 2025-10-20T12:22:00.916Z 2025-10-27T13:10:35.523Z
8146277 8146277 20251019031751_EuYNK DK000B 2025-10-20T12:22:00.315Z 2025-10-27T13:10:35.512Z
8146266 8146266 20251019031659_FXWFk DK000B 2025-10-20T12:21:59.338Z 2025-10-27T13:10:35.473Z
8146259 8146259 20251019031632_5wgnz DK000B 2025-10-20T12:21:58.881Z 2025-10-27T13:10:35.399Z
8146205 8146205 20251019031308_QdyYv DK000B 2025-10-20T12:21:54.130Z 2025-10-27T13:10:35.281Z
8146077 8146077 20251019030335_u1QTu DK000B 2025-10-20T12:21:42.500Z 2025-10-27T13:10:34.242Z
8145982 8145982 20251019025727_tbSZg DK000B 2025-10-20T12:21:22.962Z 2025-10-27T13:10:33.664Z
8145922 8145922 20251019025415_efC3M DK000B 2025-10-20T12:21:14.672Z 2025-10-27T13:10:33.354Z
8145747 8145747 20251019024116_sQLSw DK000B 2025-10-20T12:20:55.637Z 2025-10-27T13:10:30.277Z
8145729 8145729 20251019023956_IzOH5 DK000B 2025-10-20T12:20:39.363Z 2025-10-27T13:10:29.881Z
8145100 8145100 20251019015522_kaw4N DK000B 2025-10-20T12:19:09.425Z 2025-10-27T13:10:20.799Z
8144578 8144578 20251019011802_LCVKM DK000B 2025-10-20T12:17:43.056Z 2025-10-27T13:10:13.739Z
8144492 8144492 20251019011039_dgbI0 DK000B 2025-10-20T12:17:32.392Z 2025-10-27T13:10:12.137Z
8144382 8144382 20251019010317_LvQdo DK000B 2025-10-20T12:17:08.273Z 2025-10-27T13:10:11.895Z
8144269 8144269 20251019005228_vpuD3 DK000B 2025-10-20T12:16:53.570Z 2025-10-27T13:10:11.368Z
8144072 8144072 20251019003333_YEilc DK000B 2025-10-20T12:16:18.900Z 2025-10-27T13:10:10.216Z
8143746 8143746 20251019000025_HTYHG DK000B 2025-10-20T12:15:11.926Z 2025-10-27T13:10:06.992Z
8143482 8143482 20251018233032_dcAaN DK000B 2025-10-20T12:14:26.652Z 2025-10-27T13:10:04.255Z
8143285 8143285 20251018231023_PyxHM DK000B 2025-10-20T12:13:46.608Z 2025-10-27T13:10:03.675Z
8143023 8143023 20251018224621_9J9nc DK000B 2025-10-20T12:13:04.789Z 2025-10-27T13:10:02.645Z
8142811 8142811 20251018222400_s1h5i DK000B 2025-10-20T12:12:17.159Z 2025-10-27T13:10:02.117Z
8123878 8123878 20251017043315_GpE9e DK000B 2025-10-18T12:27:52.905Z 2025-10-25T13:29:14.050Z
8123710 8123710 20251017040534_AXG0V DK000B 2025-10-18T12:27:10.218Z 2025-10-25T13:29:11.459Z
8123644 8123644 20251017035835_IkzQZ DK000B 2025-10-18T12:27:03.268Z 2025-10-25T13:29:10.695Z
8123475 8123475 20251017034057_3jWXK DK000B 2025-10-18T12:26:28.598Z 2025-10-25T13:29:09.109Z
8123365 8123365 20251017033136_nCYE0 DK000B 2025-10-18T12:26:16.247Z 2025-10-25T13:29:07.951Z
8123229 8123229 20251017032028_DkrHs DK000B 2025-10-18T12:26:03.798Z 2025-10-25T13:29:06.454Z
8123178 8123178 20251017031534_kZH89 DK000B 2025-10-18T12:25:45.413Z 2025-10-25T13:29:05.953Z
8123157 8123157 20251017031317_CTH8P DK000B 2025-10-18T12:25:38.908Z 2025-10-25T13:29:05.545Z
8122638 8122638 20251017021511_JlbmG DK000B 2025-10-18T12:24:25.949Z 2025-10-25T13:28:42.873Z
8122629 8122629 20251017021405_ySQJl DK000B 2025-10-18T12:24:24.983Z 2025-10-25T13:28:42.744Z
8122503 8122503 20251017020224_H1bQE DK000B 2025-10-18T12:23:52.886Z 2025-10-25T13:28:35.786Z
8122500 8122500 20251017020218_UESAr DK000B 2025-10-18T12:23:52.589Z 2025-10-25T13:28:35.689Z
8122397 8122397 20251017015148_SsqCw DK000B 2025-10-18T12:23:40.653Z 2025-10-25T13:28:30.196Z
8122378 8122378 20251017015001_5MxV8 DK000B 2025-10-18T12:23:36.712Z 2025-10-25T13:28:29.115Z
8122054 8122054 20251017011419_YL9UT DK000B 2025-10-18T12:22:20.109Z 2025-10-25T13:28:11.111Z
8122032 8122032 20251017010929_e3aI8 DK000B 2025-10-18T12:22:17.350Z 2025-10-25T13:28:10.818Z
8121894 8121894 20251017004707_IVFkT DK000B 2025-10-18T12:21:51.869Z 2025-10-25T13:28:07.133Z
8121456 8121456 20251016235240_wu2Mr DK000B 2025-10-18T12:20:32.332Z 2025-10-25T13:27:35.437Z
8121440 8121440 20251016234827_L0kf1 DK000B 2025-10-18T12:20:16.085Z 2025-10-25T13:27:34.002Z
8120411 8120411 20251016201753_kPqy7 DK000B 2025-10-18T12:16:35.412Z 2025-10-25T13:26:24.901Z
8120377 8120377 20251016201056_K5j2w DK000B 2025-10-18T12:16:30.982Z 2025-10-25T13:26:22.591Z
8120341 8120341 20251016200530_JEOQt DK000B 2025-10-18T12:16:24.169Z 2025-10-25T13:26:21.199Z
8119770 8119770 20251016185114_qS5he DK000B 2025-10-18T12:14:16.354Z 2025-10-25T13:25:51.467Z
8112834 8112834 20251016034838_4xiB8 DK000B 2025-10-17T12:13:36.350Z 2025-10-24T13:16:48.883Z
8112192 8112192 20251016024250_pW3is DK000B 2025-10-17T12:11:57.694Z 2025-10-24T13:16:38.713Z
8112103 8112103 20251016023352_4P0PA DK000B 2025-10-17T12:11:45.618Z 2025-10-24T13:16:37.435Z
8112081 8112081 20251016023030_QakC0 DK000B 2025-10-17T12:11:42.820Z 2025-10-24T13:16:37.101Z
8112052 8112052 20251016022701_LyaGa DK000B 2025-10-17T12:11:40.448Z 2025-10-24T13:16:35.613Z
8111760 8111760 20251016015332_luoVT DK000B 2025-10-17T12:11:01.208Z 2025-10-24T13:16:27.962Z
8111580 8111580 20251016012848_FiPdl DK000B 2025-10-17T12:10:37.713Z 2025-10-24T13:16:23.825Z
8111250 8111250 20251016004607_ie6YR DK000B 2025-10-17T12:09:43.488Z 2025-10-24T13:16:17.033Z
8111052 8111052 20251016001749_BGNiq DK000B 2025-10-17T12:09:24.199Z 2025-10-24T13:16:13.238Z
8110959 8110959 20251016000046_0BGN1 DK000B 2025-10-17T12:09:06.063Z 2025-10-24T13:16:08.712Z
8110906 8110906 20251015234919_OT5ME DK000B 2025-10-17T12:08:51.976Z 2025-10-24T13:16:08.132Z
8110874 8110874 20251015234324_2e2tl DK000B 2025-10-17T12:08:44.525Z 2025-10-24T13:16:07.896Z
8104900 8104900 20251015031135_1z2jz DK000B 2025-10-16T12:17:41.312Z 2025-10-23T13:08:59.106Z
8104066 8104066 20251015004618_ckORh DK000B 2025-10-16T12:14:39.550Z 2025-10-23T13:08:40.782Z
8104039 8104039 20251015004117_NOPnv DK000B 2025-10-16T12:14:33.675Z 2025-10-23T13:08:40.313Z
8103924 8103924 20251015001515_3BILT DK000B 2025-10-16T12:14:14.458Z 2025-10-23T13:08:37.732Z
8103886 8103886 20251015000615_pBL0w DK000B 2025-10-16T12:13:57.537Z 2025-10-23T13:08:35.295Z
8103863 8103863 20251015000006_Gy5XG DK000B 2025-10-16T12:13:52.153Z 2025-10-23T13:08:34.995Z
8103773 8103773 20251014234551_Wi6ad DK000B 2025-10-16T12:13:37.670Z 2025-10-23T13:08:32.386Z
8103758 8103758 20251014234259_Tx3c1 DK000B 2025-10-16T12:13:35.301Z 2025-10-23T13:08:32.322Z
8103742 8103742 20251014233831_NXmGW DK000B 2025-10-16T12:13:32.005Z 2025-10-23T13:08:30.408Z
8103640 8103640 20251014230600_JEBJg DK000B 2025-10-16T12:13:00.971Z 2025-10-23T13:08:25.128Z
8103621 8103621 20251014230129_OLkIT DK000B 2025-10-16T12:12:57.747Z 2025-10-23T13:08:24.862Z
8103619 8103619 20251014230120_VVGuv DK000B 2025-10-16T12:12:57.327Z 2025-10-23T13:08:24.858Z
8103596 8103596 20251014225321_22KzH DK000B 2025-10-16T12:12:53.703Z 2025-10-23T13:08:24.780Z
8103396 8103396 20251014220059_t3hLD DK000B 2025-10-16T12:11:59.384Z 2025-10-23T13:08:23.292Z
8103345 8103345 20251014214911_hrPXO DK000B 2025-10-16T12:11:50.329Z 2025-10-23T13:08:23.142Z
8103343 8103343 20251014214847_LEzgG DK000B 2025-10-16T12:11:49.832Z 2025-10-23T13:08:23.136Z
8103147 8103147 20251014205334_UnIup DK000B 2025-10-16T12:11:10.275Z 2025-10-23T13:08:19.132Z
8102928 8102928 20251014193247_7LYTE DK000B 2025-10-16T12:10:06.440Z 2025-10-23T13:08:10.907Z
8102911 8102911 20251014192759_FL8Wa DK000B 2025-10-16T12:10:03.378Z 2025-10-23T13:08:10.730Z
8093423 8093423 20251013043157_wU37y DK000B 2025-10-14T12:13:25.318Z 2025-10-21T13:09:48.131Z
8093280 8093280 20251013033706_QmOIf DK000B 2025-10-14T12:12:53.618Z 2025-10-21T13:09:46.651Z
8093201 8093201 20251013031758_9lTzj DK000B 2025-10-14T12:12:43.535Z 2025-10-21T13:09:42.896Z
8093188 8093188 20251013031419_08FtJ DK000B 2025-10-14T12:12:41.894Z 2025-10-21T13:09:42.855Z
8093173 8093173 20251013031323_zIBLu DK000B 2025-10-14T12:12:40.521Z 2025-10-21T13:09:42.402Z
8093110 8093110 20251013030035_d186L DK000B 2025-10-14T12:12:34.194Z 2025-10-21T13:09:35.788Z
8093049 8093049 20251013024059_G7Kbk DK000B 2025-10-14T12:12:13.446Z 2025-10-21T13:09:34.224Z
8093008 8093008 20251013022550_HwhrN DK000B 2025-10-14T12:12:05.893Z 2025-10-21T13:09:34.033Z
8092922 8092922 20251013020357_NIW13 DK000B 2025-10-14T12:11:56.392Z 2025-10-21T13:09:32.182Z
8092859 8092859 20251013015102_U4jN3 DK000B 2025-10-14T12:11:50.659Z 2025-10-21T13:09:28.173Z
8092849 8092849 20251013014804_YHwEW DK000B 2025-10-14T12:11:49.585Z 2025-10-21T13:09:28.092Z
8092839 8092839 20251013014604_huzDr DK000B 2025-10-14T12:11:48.705Z 2025-10-21T13:09:27.971Z
8092798 8092798 20251013013334_aElhy DK000B 2025-10-14T12:11:44.549Z 2025-10-21T13:09:27.595Z
8092788 8092788 20251013013052_bjXDz DK000B 2025-10-14T12:11:43.167Z 2025-10-21T13:09:27.516Z
8092656 8092656 20251013010022_J3CU3 DK000B 2025-10-14T12:11:07.856Z 2025-10-21T13:09:26.283Z
8092634 8092634 20251013005449_yOton DK000B 2025-10-14T12:11:05.317Z 2025-10-21T13:09:26.200Z
8092589 8092589 20251013004428_Vodf4 DK000B 2025-10-14T12:11:01.252Z 2025-10-21T13:09:25.952Z

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