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,630 rows where station_code = "DK000T" 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
8666748 8666748 20251130225300_BdxhI DK000T 2025-12-02T14:27:19.997Z 2025-12-05T14:34:40.572Z
8666520 8666520 20251201060305_3pdHQ DK000T 2025-12-02T14:26:22.508Z 2025-12-05T14:37:01.078Z
8666502 8666502 20251201055759_otpMH DK000T 2025-12-02T14:26:20.261Z 2025-12-02T14:26:20.261Z
8666457 8666457 20251201054344_37vy4 DK000T 2025-12-02T14:26:15.507Z 2025-12-05T14:36:58.952Z
8666454 8666454 20251201054322_e3yQf DK000T 2025-12-02T14:26:15.174Z 2025-12-05T14:36:58.878Z
8666434 8666434 20251201053858_wrs7Z DK000T 2025-12-02T14:26:08.606Z 2025-12-05T14:36:58.129Z
8666370 8666370 20251201052345_u34HM DK000T 2025-12-02T14:25:53.892Z 2025-12-05T14:36:55.742Z
8666295 8666295 20251201050912_3tvJX DK000T 2025-12-02T14:25:43.450Z 2025-12-05T14:36:53.392Z
8666174 8666174 20251201044628_Lgn0S DK000T 2025-12-02T14:25:32.764Z 2025-12-05T14:36:35.130Z
8666171 8666171 20251201044518_IAcnn DK000T 2025-12-02T14:25:32.435Z 2025-12-05T14:36:34.922Z
8666162 8666162 20251201044336_3nCme DK000T 2025-12-02T14:25:31.413Z 2025-12-05T14:36:34.632Z
8666146 8666146 20251201044144_8cNje DK000T 2025-12-02T14:25:22.709Z 2025-12-05T14:36:34.124Z
8666144 8666144 20251201044142_zGza2 DK000T 2025-12-02T14:25:19.598Z 2025-12-05T14:36:34.066Z
8666138 8666138 20251201044102_M0Bwf DK000T 2025-12-02T14:25:18.512Z 2025-12-05T14:36:33.499Z
8666108 8666108 20251201043820_xEDIL DK000T 2025-12-02T14:25:15.016Z 2025-12-05T14:36:32.583Z
8666061 8666061 20251201042847_U5hd7 DK000T 2025-12-02T14:25:10.120Z 2025-12-05T14:36:29.694Z
8665985 8665985 20251201041631_sAJKC DK000T 2025-12-02T14:25:02.124Z 2025-12-05T14:36:25.915Z
8665912 8665912 20251201041023_6fWVu DK000T 2025-12-02T14:24:54.707Z 2025-12-05T14:36:23.958Z
8665857 8665857 20251201040310_FhAs1 DK000T 2025-12-02T14:24:35.382Z 2025-12-05T14:36:21.558Z
8665854 8665854 20251201040310_DMZbc DK000T 2025-12-02T14:24:35.101Z 2025-12-05T14:36:21.453Z
8665811 8665811 20251201040100_slBFT DK000T 2025-12-02T14:24:31.007Z 2025-12-05T14:36:20.156Z
8665772 8665772 20251201035652_orVxy DK000T 2025-12-02T14:24:27.115Z 2025-12-05T14:36:18.648Z
8665568 8665568 20251201033518_oSwjC DK000T 2025-12-02T14:23:55.225Z 2025-12-05T14:36:12.011Z
8665368 8665368 20251201031241_ACdIk DK000T 2025-12-02T14:23:35.168Z 2025-12-05T14:35:53.774Z
8665341 8665341 20251201030857_vRV6Q DK000T 2025-12-02T14:23:32.707Z 2025-12-05T14:35:52.742Z
8665277 8665277 20251201025854_iaN33 DK000T 2025-12-02T14:23:16.372Z 2025-12-05T14:35:48.315Z
8665249 8665249 20251201025133_jW6Kc DK000T 2025-12-02T14:23:12.024Z 2025-12-05T14:35:47.243Z
8665230 8665230 20251201024954_3S2KP DK000T 2025-12-02T14:23:10.727Z 2025-12-05T14:35:46.945Z
8665208 8665208 20251201024743_GvVAZ DK000T 2025-12-02T14:23:08.047Z 2025-12-05T14:35:45.888Z
8665123 8665123 20251201023411_tU7de DK000T 2025-12-02T14:22:58.585Z 2025-12-05T14:35:43.127Z
8665050 8665050 20251201022111_w087R DK000T 2025-12-02T14:22:42.181Z 2025-12-05T14:35:40.732Z
8664943 8664943 20251201020645_iRVfW DK000T 2025-12-02T14:22:29.711Z 2025-12-05T14:35:37.065Z
8664915 8664915 20251201020326_lihGg DK000T 2025-12-02T14:22:26.524Z 2025-12-05T14:35:36.235Z
8664874 8664874 20251201015438_USLql DK000T 2025-12-02T14:22:15.455Z 2025-12-05T14:35:34.383Z
8664834 8664834 20251201014613_lVRdM DK000T 2025-12-02T14:22:09.998Z 2025-12-05T14:35:23.268Z
8664806 8664806 20251201014245_fX3Zr DK000T 2025-12-02T14:22:06.970Z 2025-12-05T14:35:18.725Z
8664793 8664793 20251201013809_CHtUp DK000T 2025-12-02T14:22:05.003Z 2025-12-05T14:35:17.998Z
8664557 8664557 20251201005705_4krAL DK000T 2025-12-02T14:21:21.853Z 2025-12-05T14:35:08.518Z
8664473 8664473 20251201003839_6pSaW DK000T 2025-12-02T14:21:09.916Z 2025-12-05T14:35:05.564Z
8664466 8664466 20251201003527_9vFUL DK000T 2025-12-02T14:21:08.668Z 2025-12-05T14:35:05.143Z
8664398 8664398 20251201001513_pncLt DK000T 2025-12-02T14:20:59.294Z 2025-12-05T14:35:02.869Z
8664384 8664384 20251201001324_hA2Se DK000T 2025-12-02T14:20:57.962Z 2025-12-05T14:35:02.527Z
8664255 8664255 20251130235141_eA6op DK000T 2025-12-02T14:20:35.069Z 2025-12-05T14:34:58.640Z
8664218 8664218 20251130234428_kQszb DK000T 2025-12-02T14:20:30.432Z 2025-12-05T14:34:57.002Z
8664151 8664151 20251130232607_NdSno DK000T 2025-12-02T14:20:11.499Z 2025-12-05T14:34:54.415Z
8664039 8664039 20251130230942_tzEU8 DK000T 2025-12-02T14:19:59.500Z 2025-12-05T14:34:42.900Z
8664022 8664022 20251130230307_Daa4y DK000T 2025-12-02T14:19:56.748Z 2025-12-05T14:34:42.102Z
8664017 8664017 20251130230228_AFp0G DK000T 2025-12-02T14:19:56.344Z 2025-12-05T14:34:41.977Z
8664001 8664001 20251130225901_esRwg DK000T 2025-12-02T14:19:46.659Z 2025-12-05T14:34:41.370Z
8663980 8663980 20251130225301_6ZWSS DK000T 2025-12-02T14:19:44.441Z 2025-12-05T14:34:40.698Z
8663973 8663973 20251130225119_nICec DK000T 2025-12-02T14:19:43.325Z 2025-12-05T14:34:40.208Z
8663938 8663938 20251130224128_9sLWJ DK000T 2025-12-02T14:19:38.106Z 2025-12-05T14:34:38.475Z
8663799 8663799 20251130220643_zSBaq DK000T 2025-12-02T14:19:11.048Z 2025-12-05T14:34:32.557Z
8647907 8647907 20251129060044_OO7DU DK000T 2025-11-30T14:29:22.588Z 2025-12-05T14:52:50.352Z
8647905 8647905 20251129060038_OhQ8e DK000T 2025-11-30T14:29:22.487Z 2025-12-05T14:52:50.309Z
8647812 8647812 20251129053548_ftPXw DK000T 2025-11-30T14:29:00.863Z 2025-12-05T14:52:48.240Z
8647735 8647735 20251129051614_HURY4 DK000T 2025-11-30T14:28:49.741Z 2025-12-05T14:52:46.534Z
8647697 8647697 20251129050949_oNM6G DK000T 2025-11-30T14:28:45.540Z 2025-12-05T14:52:45.774Z
8647619 8647619 20251129045828_GBhR7 DK000T 2025-11-30T14:28:39.553Z 2025-12-05T14:52:44.107Z
8647596 8647596 20251129045528_gR7ph DK000T 2025-11-30T14:28:37.870Z 2025-12-05T14:52:43.640Z
8647592 8647592 20251129045359_Hgt2l DK000T 2025-11-30T14:28:37.454Z 2025-12-05T14:52:43.510Z
8647566 8647566 20251129045140_cLmiw DK000T 2025-11-30T14:28:35.798Z 2025-12-05T14:52:42.923Z
8647351 8647351 20251129042613_7PN4K DK000T 2025-11-30T14:28:02.011Z 2025-12-05T14:52:38.138Z
8647299 8647299 20251129041722_MkU32 DK000T 2025-11-30T14:27:57.334Z 2025-12-05T14:52:37.110Z
8647175 8647175 20251129035704_2cfoV DK000T 2025-11-30T14:27:47.661Z 2025-12-05T14:52:34.725Z
8647074 8647074 20251129033657_gNrLZ DK000T 2025-11-30T14:27:24.230Z 2025-12-05T14:52:32.225Z
8646885 8646885 20251129030653_BcHKB DK000T 2025-11-30T14:27:04.631Z 2025-12-05T14:51:56.201Z
8646536 8646536 20251129021832_EfhYx DK000T 2025-11-30T14:26:07.926Z 2025-12-05T14:51:44.024Z
8646358 8646358 20251129015031_ehSwa DK000T 2025-11-30T14:25:53.361Z 2025-12-05T14:51:40.172Z
8623245 8623245 20251126233023_d25GV DK000T 2025-11-28T14:21:22.822Z 2025-12-05T15:03:40.343Z
8623213 8623213 20251126232142_W3owO DK000T 2025-11-28T14:21:05.890Z 2025-12-05T15:03:38.316Z
8623178 8623178 20251126231234_JRtR5 DK000T 2025-11-28T14:21:01.384Z 2025-12-05T15:03:36.392Z
8623172 8623172 20251126231127_ARGqp DK000T 2025-11-28T14:21:00.864Z 2025-12-05T15:03:36.262Z
8623165 8623165 20251126230901_Ae5Kn DK000T 2025-11-28T14:21:00.075Z 2025-12-05T15:03:36.175Z
8623077 8623077 20251126224433_aNg5u DK000T 2025-11-28T14:20:49.509Z 2025-12-05T15:03:27.569Z
8623047 8623047 20251126223531_mr53F DK000T 2025-11-28T14:20:32.695Z 2025-12-05T15:03:26.672Z
8623013 8623013 20251126222757_GYpE7 DK000T 2025-11-28T14:20:28.864Z 2025-12-05T15:03:25.124Z
8622998 8622998 20251126222453_tY1Xg DK000T 2025-11-28T14:20:26.347Z 2025-12-05T15:03:24.642Z
8622985 8622985 20251126222220_ZeNZK DK000T 2025-11-28T14:20:25.525Z 2025-12-05T15:03:24.475Z
8622712 8622712 20251126204952_jd86c DK000T 2025-11-28T14:19:43.875Z 2025-12-05T15:03:05.375Z
8622677 8622677 20251126204052_9i4pM DK000T 2025-11-28T14:19:40.557Z 2025-12-05T15:03:04.872Z
8622672 8622672 20251126203610_DTVih DK000T 2025-11-28T14:19:40.229Z 2025-12-05T15:03:04.808Z
8622652 8622652 20251126203100_TCJQI DK000T 2025-11-28T14:19:38.009Z 2025-12-05T15:03:04.604Z
8622634 8622634 20251126202338_zEFM3 DK000T 2025-11-28T14:19:35.623Z 2025-12-05T15:03:04.310Z
8622631 8622631 20251126202234_bZpzG DK000T 2025-11-28T14:19:35.290Z 2025-12-05T15:03:04.288Z
8622623 8622623 20251126201701_TqhPN DK000T 2025-11-28T14:19:34.374Z 2025-12-05T15:03:04.150Z
8622599 8622599 20251126201415_IdoXl DK000T 2025-11-28T14:19:27.745Z 2025-12-05T15:03:03.922Z
8622570 8622570 20251126200005_nQHGs DK000T 2025-11-28T14:19:23.826Z 2025-12-05T15:03:03.598Z
8622557 8622557 20251126195451_QQ9Fj DK000T 2025-11-28T14:19:21.194Z 2025-12-05T15:03:03.447Z
8622504 8622504 20251126193926_yZ2GX DK000T 2025-11-28T14:19:00.828Z 2025-12-05T15:03:02.543Z
8622461 8622461 20251126192602_FyH5i DK000T 2025-11-28T14:18:54.665Z 2025-12-05T15:03:00.525Z
8585682 8585682 20251123173014_Rx3ph DK000T 2025-11-25T14:10:34.604Z 2025-12-02T15:10:08.511Z
8581893 8581893 20251123025626_kJAhW DK000T 2025-11-24T14:32:43.933Z 2025-12-01T15:21:55.265Z
8580650 8580650 20251123051427_pkIML DK000T 2025-11-24T14:17:32.546Z 2025-12-01T15:22:21.212Z
8580639 8580639 20251123051154_xMidE DK000T 2025-11-24T14:17:30.975Z 2025-12-01T15:22:20.983Z
8580636 8580636 20251123050910_vzTjF DK000T 2025-11-24T14:17:30.673Z 2025-12-01T15:22:20.907Z
8580605 8580605 20251123045903_2UDPv DK000T 2025-11-24T14:17:26.073Z 2025-12-01T15:22:20.113Z
8580513 8580513 20251123044106_7BNWm DK000T 2025-11-24T14:17:16.619Z 2025-12-01T15:22:18.518Z
8580451 8580451 20251123042337_htvRA DK000T 2025-11-24T14:17:01.416Z 2025-12-01T15:22:17.382Z
8580437 8580437 20251123042100_g2hKP DK000T 2025-11-24T14:16:58.454Z 2025-12-01T15:22:16.955Z

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