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

2,229 rows where station_code = "DK0009" 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
8666746 8666746 20251130225300_BdxhI DK0009 2025-12-02T14:27:19.997Z 2025-12-06T14:40:18.618Z
8666501 8666501 20251201055759_otpMH DK0009 2025-12-02T14:26:20.260Z 2025-12-02T14:26:20.260Z
8666455 8666455 20251201054344_37vy4 DK0009 2025-12-02T14:26:15.507Z 2025-12-06T14:42:22.752Z
8666308 8666308 20251201051020_OCltT DK0009 2025-12-02T14:25:45.059Z 2025-12-02T14:25:45.059Z
8666168 8666168 20251201044518_IAcnn DK0009 2025-12-02T14:25:32.435Z 2025-12-06T14:42:13.957Z
8666159 8666159 20251201044336_3nCme DK0009 2025-12-02T14:25:31.412Z 2025-12-06T14:42:13.739Z
8666142 8666142 20251201044142_zGza2 DK0009 2025-12-02T14:25:19.598Z 2025-12-06T14:42:13.185Z
8665922 8665922 20251201041114_g9jCE DK0009 2025-12-02T14:24:55.748Z 2025-12-06T14:42:07.099Z
8665910 8665910 20251201041023_6fWVu DK0009 2025-12-02T14:24:54.707Z 2025-12-06T14:42:06.853Z
8665585 8665585 20251201033946_Og7F2 DK0009 2025-12-02T14:23:56.941Z 2025-12-06T14:41:41.091Z
8665528 8665528 20251201033129_jOk4v DK0009 2025-12-02T14:23:49.868Z 2025-12-06T14:41:39.843Z
8665314 8665314 20251201030712_vpb8o DK0009 2025-12-02T14:23:25.562Z 2025-12-06T14:41:34.594Z
8665275 8665275 20251201025854_iaN33 DK0009 2025-12-02T14:23:16.372Z 2025-12-06T14:41:31.705Z
8665256 8665256 20251201025632_93TVe DK0009 2025-12-02T14:23:13.138Z 2025-12-06T14:41:30.803Z
8665142 8665142 20251201023549_9rOzo DK0009 2025-12-02T14:23:00.131Z 2025-12-06T14:41:27.858Z
8665068 8665068 20251201022427_nkGBo DK0009 2025-12-02T14:22:44.887Z 2025-12-06T14:41:24.597Z
8665042 8665042 20251201022027_aeZnW DK0009 2025-12-02T14:22:40.625Z 2025-12-06T14:41:11.350Z
8665010 8665010 20251201021648_UIQD5 DK0009 2025-12-02T14:22:36.493Z 2025-12-06T14:41:06.453Z
8664996 8664996 20251201021459_5S9BJ DK0009 2025-12-02T14:22:34.810Z 2025-12-06T14:41:05.001Z
8664896 8664896 20251201020005_IQli6 DK0009 2025-12-02T14:22:24.046Z 2025-12-06T14:41:02.299Z
8664804 8664804 20251201014245_fX3Zr DK0009 2025-12-02T14:22:06.970Z 2025-12-06T14:40:58.236Z
8664770 8664770 20251201013522_XUmxb DK0009 2025-12-02T14:22:03.064Z 2025-12-06T14:40:57.034Z
8664500 8664500 20251201004238_oxZyy DK0009 2025-12-02T14:21:13.597Z 2025-12-06T14:40:48.864Z
8664380 8664380 20251201001324_hA2Se DK0009 2025-12-02T14:20:57.962Z 2025-12-06T14:40:45.642Z
8664284 8664284 20251130235850_EIyKC DK0009 2025-12-02T14:20:39.186Z 2025-12-06T14:40:43.488Z
8664253 8664253 20251130235141_eA6op DK0009 2025-12-02T14:20:35.069Z 2025-12-06T14:40:42.679Z
8664019 8664019 20251130230307_Daa4y DK0009 2025-12-02T14:19:56.748Z 2025-12-06T14:40:19.927Z
8663979 8663979 20251130225301_6ZWSS DK0009 2025-12-02T14:19:44.441Z 2025-12-06T14:40:18.680Z
8663815 8663815 20251130220918_RWGx8 DK0009 2025-12-02T14:19:21.180Z 2025-12-06T14:40:12.354Z
8663790 8663790 20251130220520_ZSYzy DK0009 2025-12-02T14:19:09.861Z 2025-12-06T14:40:11.413Z
8647807 8647807 20251129053521_eOIv7 DK0009 2025-11-30T14:28:59.841Z 2025-12-06T14:56:48.357Z
8623331 8623331 20251127000055_2idI3 DK0009 2025-11-28T14:21:31.824Z 2025-12-05T15:03:43.520Z
8623321 8623321 20251126235752_qCdrg DK0009 2025-11-28T14:21:30.873Z 2025-12-05T15:03:43.136Z
8623192 8623192 20251126231734_51fX1 DK0009 2025-11-28T14:21:03.960Z 2025-12-05T15:03:37.875Z
8623175 8623175 20251126231234_JRtR5 DK0009 2025-11-28T14:21:01.384Z 2025-12-05T15:03:36.392Z
8623168 8623168 20251126231127_ARGqp DK0009 2025-11-28T14:21:00.864Z 2025-12-05T15:03:36.262Z
8623166 8623166 20251126231042_3TCRN DK0009 2025-11-28T14:21:00.442Z 2025-12-05T15:03:36.235Z
8623121 8623121 20251126225700_CyU9H DK0009 2025-11-28T14:20:54.926Z 2025-12-05T15:03:30.414Z
8623094 8623094 20251126225253_3OprB DK0009 2025-11-28T14:20:51.959Z 2025-12-05T15:03:28.382Z
8623037 8623037 20251126223309_qjVzy DK0009 2025-11-28T14:20:31.864Z 2025-12-05T15:03:26.071Z
8623024 8623024 20251126223135_JqGrT DK0009 2025-11-28T14:20:30.489Z 2025-12-05T15:03:25.888Z
8622994 8622994 20251126222453_tY1Xg DK0009 2025-11-28T14:20:26.347Z 2025-12-05T15:03:24.641Z
8622974 8622974 20251126221950_eZGvi DK0009 2025-11-28T14:20:24.551Z 2025-12-05T15:03:21.137Z
8622969 8622969 20251126221838_f4Eog DK0009 2025-11-28T14:20:23.966Z 2025-12-05T15:03:20.970Z
8622880 8622880 20251126215707_WWEIN DK0009 2025-11-28T14:20:14.942Z 2025-12-05T15:03:17.327Z
8622846 8622846 20251126214814_UotPg DK0009 2025-11-28T14:20:10.592Z 2025-12-05T15:03:16.405Z
8622822 8622822 20251126214032_mQb8j DK0009 2025-11-28T14:20:08.066Z 2025-12-05T15:03:15.354Z
8622808 8622808 20251126213530_IfzDg DK0009 2025-11-28T14:19:55.479Z 2025-12-05T15:03:11.726Z
8622803 8622803 20251126213106_F2il4 DK0009 2025-11-28T14:19:54.714Z 2025-12-05T15:03:11.474Z
8622619 8622619 20251126201701_TqhPN DK0009 2025-11-28T14:19:34.374Z 2025-12-05T15:03:04.150Z
8622600 8622600 20251126201425_Rt2HT DK0009 2025-11-28T14:19:27.996Z 2025-12-05T15:03:03.967Z
8622567 8622567 20251126200005_nQHGs DK0009 2025-11-28T14:19:23.826Z 2025-12-05T15:03:03.598Z
8622514 8622514 20251126194133_N5Ikc DK0009 2025-11-28T14:19:02.192Z 2025-12-05T15:03:02.792Z
8622393 8622393 20251126190300_uRJlg DK0009 2025-11-28T14:18:46.713Z 2025-12-05T15:02:56.311Z
8582294 8582294 20251123051833_YVdUx DK0009 2025-11-24T14:33:27.912Z 2025-12-01T15:22:21.321Z
8582240 8582240 20251123045330_nwB9W DK0009 2025-11-24T14:33:24.960Z 2025-12-01T15:22:19.798Z
8582238 8582238 20251123045244_ZLLyn DK0009 2025-11-24T14:33:24.656Z 2025-12-01T15:22:19.715Z
8581915 8581915 20251123030233_tq2F2 DK0009 2025-11-24T14:32:46.847Z 2025-12-01T15:21:58.523Z
8581890 8581890 20251123025626_kJAhW DK0009 2025-11-24T14:32:43.933Z 2025-12-01T15:21:55.265Z
8581502 8581502 20251123002043_TSZ69 DK0009 2025-11-24T14:31:41.639Z 2025-12-01T15:20:45.532Z
8581492 8581492 20251123001620_qA4rS DK0009 2025-11-24T14:31:40.813Z 2025-12-01T15:20:43.456Z
8581347 8581347 20251122231414_O0DCm DK0009 2025-11-24T14:31:27.814Z 2025-12-01T15:20:14.424Z
8578854 8578854 20251122213934_u03DY DK0009 2025-11-24T14:12:51.160Z 2025-12-01T15:19:53.952Z
8578729 8578729 20251122212041_9zFMF DK0009 2025-11-24T14:12:34.706Z 2025-12-01T15:19:50.962Z
8577871 8577871 20251122190619_wZnd6 DK0009 2025-11-24T14:10:04.242Z 2025-12-01T15:19:01.053Z
8577451 8577451 20251122181037_wJLDy DK0009 2025-11-24T14:08:38.795Z 2025-12-01T15:18:50.651Z
8577418 8577418 20251122180525_5KK8E DK0009 2025-11-24T14:08:33.981Z 2025-12-01T15:18:49.215Z
8577030 8577030 20251122170738_L3X2l DK0009 2025-11-24T14:07:22.850Z 2025-12-01T15:18:42.648Z
8572937 8572937 20251122020543_Qciwl DK0009 2025-11-23T14:40:10.428Z 2025-11-30T15:06:06.908Z
8571348 8571348 20251121202014_Dqw3m DK0009 2025-11-23T14:36:12.458Z 2025-11-30T15:04:54.637Z
8568321 8568321 20251121051355_SRFGs DK0009 2025-11-23T14:31:03.982Z 2025-11-29T14:54:46.520Z
8568199 8568199 20251121050606_uGEAI DK0009 2025-11-23T14:30:57.715Z 2025-11-29T14:54:46.326Z
8567292 8567292 20251122051404_sdpFI DK0009 2025-11-23T14:19:25.471Z 2025-11-30T15:06:59.089Z
8567279 8567279 20251122050726_UWWf7 DK0009 2025-11-23T14:19:24.429Z 2025-11-30T15:06:58.207Z
8567239 8567239 20251122044612_UTq38 DK0009 2025-11-23T14:19:19.851Z 2025-11-30T15:06:51.329Z
8567213 8567213 20251122043916_9r5hL DK0009 2025-11-23T14:19:11.378Z 2025-11-30T15:06:49.482Z
8567177 8567177 20251122042910_Q5mZL DK0009 2025-11-23T14:19:04.923Z 2025-11-30T15:06:47.811Z
8566907 8566907 20251122025537_YktNK DK0009 2025-11-23T14:18:02.827Z 2025-11-30T15:06:16.074Z
8566883 8566883 20251122025050_qi3ps DK0009 2025-11-23T14:17:51.846Z 2025-11-30T15:06:13.902Z
8566847 8566847 20251122023924_Ki5EN DK0009 2025-11-23T14:17:44.354Z 2025-11-23T14:17:44.354Z
8566834 8566834 20251122023545_uoSq6 DK0009 2025-11-23T14:17:41.121Z 2025-11-30T15:06:11.274Z
8566801 8566801 20251122022832_sH7RV DK0009 2025-11-23T14:17:34.646Z 2025-11-30T15:06:09.561Z
8566788 8566788 20251122022454_wadFz DK0009 2025-11-23T14:17:32.211Z 2025-11-30T15:06:09.022Z
8566773 8566773 20251122021721_6scTq DK0009 2025-11-23T14:17:29.465Z 2025-11-30T15:06:08.627Z
8566762 8566762 20251122021450_LbY2j DK0009 2025-11-23T14:17:18.340Z 2025-11-30T15:06:08.148Z
8566724 8566724 20251122020146_Jp7yr DK0009 2025-11-23T14:17:10.635Z 2025-11-30T15:06:06.550Z
8566721 8566721 20251122020033_B8ipI DK0009 2025-11-23T14:17:10.325Z 2025-11-30T15:06:06.504Z
8566655 8566655 20251122014131_7eQ5M DK0009 2025-11-23T14:16:58.732Z 2025-11-30T15:05:58.300Z
8566554 8566554 20251122011136_4Ky3S DK0009 2025-11-23T14:16:34.106Z 2025-11-30T15:05:51.833Z
8566525 8566525 20251122010145_vKGr1 DK0009 2025-11-23T14:16:30.155Z 2025-11-30T15:05:51.275Z
8566509 8566509 20251122005634_vRCvw DK0009 2025-11-23T14:16:27.671Z 2025-11-30T15:05:50.894Z
8566498 8566498 20251122005128_vsDmp DK0009 2025-11-23T14:16:25.771Z 2025-11-30T15:05:50.674Z
8566496 8566496 20251122005125_NLNvG DK0009 2025-11-23T14:16:25.431Z 2025-11-30T15:05:50.643Z
8566468 8566468 20251122004255_3nBCU DK0009 2025-11-23T14:16:14.339Z 2025-11-30T15:05:49.535Z
8566463 8566463 20251122004224_q0TOd DK0009 2025-11-23T14:16:13.689Z 2025-11-30T15:05:49.520Z
8566355 8566355 20251122001711_O1J2o DK0009 2025-11-23T14:15:58.208Z 2025-11-30T15:05:42.891Z
8566282 8566282 20251121235605_nZMxN DK0009 2025-11-23T14:15:40.524Z 2025-11-30T15:05:40.958Z
8566260 8566260 20251121235023_RUm6W DK0009 2025-11-23T14:15:37.225Z 2025-11-30T15:05:40.156Z
8566218 8566218 20251121233554_rzMYP DK0009 2025-11-23T14:15:30.878Z 2025-11-23T14:15:30.878Z
8566210 8566210 20251121233405_OmagN DK0009 2025-11-23T14:15:29.455Z 2025-11-30T15:05:37.090Z

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