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,341 rows where station_code = "DK0002" 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
8666489 8666489 20251201054943_ccqGB DK0002 2025-12-02T14:26:19.419Z 2025-12-06T14:42:23.643Z
8666412 8666412 20251201053644_IqkcJ DK0002 2025-12-02T14:25:59.380Z 2025-12-06T14:42:21.546Z
8666265 8666265 20251201050522_2kE2E DK0002 2025-12-02T14:25:41.462Z 2025-12-06T14:42:16.107Z
8666253 8666253 20251201050120_2rDM6 DK0002 2025-12-02T14:25:39.937Z 2025-12-02T14:25:39.937Z
8666250 8666250 20251201050115_gPJtJ DK0002 2025-12-02T14:25:39.723Z 2025-12-06T14:42:15.452Z
8666223 8666223 20251201045405_9Vpd2 DK0002 2025-12-02T14:25:37.577Z 2025-12-06T14:42:14.819Z
8666175 8666175 20251201044740_qnUG2 DK0002 2025-12-02T14:25:33.142Z 2025-12-02T14:25:33.142Z
8666131 8666131 20251201044047_zgmxS DK0002 2025-12-02T14:25:18.126Z 2025-12-06T14:42:12.739Z
8666064 8666064 20251201042930_6A8Y7 DK0002 2025-12-02T14:25:10.820Z 2025-12-06T14:42:10.980Z
8665988 8665988 20251201041711_A9sDB DK0002 2025-12-02T14:25:02.884Z 2025-12-06T14:42:08.878Z
8665947 8665947 20251201041220_pCVGl DK0002 2025-12-02T14:24:57.759Z 2025-12-06T14:42:07.437Z
8665860 8665860 20251201040323_ynce4 DK0002 2025-12-02T14:24:36.193Z 2025-12-06T14:42:05.287Z
8665812 8665812 20251201040104_nqo61 DK0002 2025-12-02T14:24:31.452Z 2025-12-06T14:42:04.101Z
8665615 8665615 20251201034353_8QF79 DK0002 2025-12-02T14:24:09.286Z 2025-12-06T14:41:41.898Z
8665536 8665536 20251201033257_iGAuP DK0002 2025-12-02T14:23:50.997Z 2025-12-06T14:41:40.111Z
8665456 8665456 20251201032150_HEoP2 DK0002 2025-12-02T14:23:42.950Z 2025-12-06T14:41:37.912Z
8665285 8665285 20251201030127_mkTDy DK0002 2025-12-02T14:23:17.743Z 2025-12-06T14:41:32.833Z
8665250 8665250 20251201025202_QjEPk DK0002 2025-12-02T14:23:12.255Z 2025-12-06T14:41:30.537Z
8665209 8665209 20251201024748_x6pRt DK0002 2025-12-02T14:23:08.307Z 2025-12-06T14:41:29.518Z
8665077 8665077 20251201022621_KcRNr DK0002 2025-12-02T14:22:53.297Z 2025-12-06T14:41:25.085Z
8665060 8665060 20251201022240_Ew2cY DK0002 2025-12-02T14:22:44.258Z 2025-12-06T14:41:21.920Z
8664857 8664857 20251201015157_ClDd9 DK0002 2025-12-02T14:22:13.778Z 2025-12-06T14:41:01.199Z
8664843 8664843 20251201014921_ZcwKW DK0002 2025-12-02T14:22:11.438Z 2025-12-06T14:41:00.781Z
8664706 8664706 20251201013018_cxyRN DK0002 2025-12-02T14:21:56.285Z 2025-12-06T14:40:55.512Z
8647870 8647870 20251129054934_oXVFg DK0002 2025-11-30T14:29:20.050Z 2025-12-06T14:56:50.796Z
8647736 8647736 20251129051630_V9t8J DK0002 2025-11-30T14:28:50.083Z 2025-12-06T14:56:46.056Z
8647535 8647535 20251129044831_a13Bx DK0002 2025-11-30T14:28:33.671Z 2025-12-06T14:56:40.788Z
8647501 8647501 20251129044545_cuSaA DK0002 2025-11-30T14:28:30.668Z 2025-12-06T14:56:40.058Z
8647480 8647480 20251129044200_BwecN DK0002 2025-11-30T14:28:29.109Z 2025-12-06T14:56:39.709Z
8647414 8647414 20251129043238_mz94E DK0002 2025-11-30T14:28:08.681Z 2025-12-06T14:56:38.428Z
8647360 8647360 20251129042736_r00S7 DK0002 2025-11-30T14:28:03.282Z 2025-12-06T14:56:37.464Z
8647221 8647221 20251129040707_zgT3l DK0002 2025-11-30T14:27:51.806Z 2025-12-06T14:56:34.125Z
8647147 8647147 20251129035214_gfKYZ DK0002 2025-11-30T14:27:45.434Z 2025-12-06T14:56:32.848Z
8646985 8646985 20251129032242_WALhi DK0002 2025-11-30T14:27:13.781Z 2025-12-06T14:56:29.282Z
8646836 8646836 20251129030018_3BwCr DK0002 2025-11-30T14:27:01.170Z 2025-12-06T14:56:26.186Z
8646784 8646784 20251129025348_xMceE DK0002 2025-11-30T14:26:57.522Z 2025-12-06T14:56:25.093Z
8646767 8646767 20251129025152_g9MyJ DK0002 2025-11-30T14:26:56.157Z 2025-12-06T14:56:24.870Z
8646656 8646656 20251129023602_GMXeV DK0002 2025-11-30T14:26:37.253Z 2025-12-06T14:56:22.747Z
8646633 8646633 20251129023346_Px3Gr DK0002 2025-11-30T14:26:35.481Z 2025-12-06T14:56:21.725Z
8646625 8646625 20251129023306_P1Tql DK0002 2025-11-30T14:26:34.625Z 2025-12-06T14:56:21.203Z
8646366 8646366 20251129015425_SU4kF DK0002 2025-11-30T14:25:54.192Z 2025-12-06T14:56:02.532Z
8646147 8646147 20251129011240_ymNp2 DK0002 2025-11-30T14:25:16.752Z 2025-12-06T14:55:38.262Z
8625782 8625782 20251126051807_kgvZ3 DK0002 2025-11-28T14:36:30.292Z 2025-12-04T15:11:32.066Z
8625729 8625729 20251126044026_fQlrG DK0002 2025-11-28T14:36:16.317Z 2025-12-04T15:11:24.677Z
8625681 8625681 20251126041449_vwFbQ DK0002 2025-11-28T14:36:06.129Z 2025-12-04T15:10:45.089Z
8625677 8625677 20251126041246_3dHP5 DK0002 2025-11-28T14:36:05.529Z 2025-12-04T15:10:42.114Z
8622901 8622901 20251126220259_7ZSvV DK0002 2025-11-28T14:20:17.213Z 2025-12-05T15:03:19.267Z
8622817 8622817 20251126213943_NgM41 DK0002 2025-11-28T14:20:07.574Z 2025-12-05T15:03:14.347Z
8622714 8622714 20251126204954_RM8Tu DK0002 2025-11-28T14:19:44.142Z 2025-12-05T15:03:05.434Z
8622605 8622605 20251126201503_g2NSZ DK0002 2025-11-28T14:19:28.784Z 2025-12-05T15:03:03.999Z
8582111 8582111 20251123041311_G0RS8 DK0002 2025-11-24T14:33:17.549Z 2025-12-01T15:22:16.545Z
8582089 8582089 20251123040310_pvq7c DK0002 2025-11-24T14:33:16.090Z 2025-12-01T15:22:15.846Z
8581920 8581920 20251123030340_k95D7 DK0002 2025-11-24T14:32:47.089Z 2025-12-01T15:21:58.631Z
8581832 8581832 20251123024342_g7Srl DK0002 2025-11-24T14:32:40.734Z 2025-12-01T15:21:44.532Z
8577508 8577508 20251122181830_32fIN DK0002 2025-11-24T14:08:55.091Z 2025-12-01T15:18:52.274Z
8574317 8574317 20251122054722_eNQb4 DK0002 2025-11-23T14:43:05.772Z 2025-11-23T14:43:05.772Z
8574228 8574228 20251122053310_rgINe DK0002 2025-11-23T14:42:58.022Z 2025-11-30T15:07:03.226Z
8574182 8574182 20251122052204_3hgMn DK0002 2025-11-23T14:42:45.201Z 2025-11-30T15:07:01.678Z
8574179 8574179 20251122052203_NImgq DK0002 2025-11-23T14:42:43.708Z 2025-11-30T15:07:01.626Z
8574174 8574174 20251122052144_U7z3Z DK0002 2025-11-23T14:42:39.046Z 2025-11-30T15:07:01.539Z
8573783 8573783 20251122040923_7MXVK DK0002 2025-11-23T14:41:59.437Z 2025-11-23T14:41:59.437Z
8573020 8573020 20251122021727_sWE82 DK0002 2025-11-23T14:40:40.191Z 2025-11-30T15:06:08.629Z
8572982 8572982 20251122021321_29thu DK0002 2025-11-23T14:40:30.715Z 2025-11-30T15:06:07.941Z
8572147 8572147 20251121234952_4WZTT DK0002 2025-11-23T14:38:03.391Z 2025-11-30T15:05:40.123Z
8572046 8572046 20251121232249_jxmHo DK0002 2025-11-23T14:37:56.562Z 2025-11-30T15:05:34.855Z
8571861 8571861 20251121223338_OAqAj DK0002 2025-11-23T14:37:47.310Z 2025-11-30T15:05:21.202Z
8571836 8571836 20251121221742_6RN2q DK0002 2025-11-23T14:37:45.845Z 2025-11-30T15:05:19.824Z
8571828 8571828 20251121221610_qu6FR DK0002 2025-11-23T14:37:45.679Z 2025-11-30T15:05:19.788Z
8571630 8571630 20251121213801_MXYNe DK0002 2025-11-23T14:37:15.023Z 2025-11-30T15:05:11.553Z
8571309 8571309 20251121201307_L5XqN DK0002 2025-11-23T14:36:09.686Z 2025-11-30T15:04:53.726Z
8571237 8571237 20251121195026_Y2P7C DK0002 2025-11-23T14:36:05.916Z 2025-11-30T15:04:42.854Z
8570999 8570999 20251121182947_H3Zi2 DK0002 2025-11-23T14:35:52.478Z 2025-11-30T15:04:18.909Z
8570855 8570855 20251121174110_STWOR DK0002 2025-11-23T14:35:02.417Z 2025-11-30T15:03:56.739Z
8568671 8568671 20251121053004_ABQV7 DK0002 2025-11-23T14:31:19.088Z 2025-11-29T14:54:47.190Z
8568636 8568636 20251121052817_OkzbX DK0002 2025-11-23T14:31:17.024Z 2025-11-29T14:54:47.148Z
8560495 8560495 20251121045810_1fZBf DK0002 2025-11-22T14:42:53.515Z 2025-11-29T14:54:45.852Z
8560112 8560112 20251121044217_zeE2b DK0002 2025-11-22T14:42:18.110Z 2025-11-29T14:54:45.014Z
8560053 8560053 20251121043734_FH3YX DK0002 2025-11-22T14:42:12.067Z 2025-11-29T14:54:44.947Z
8559947 8559947 20251121043150_i2Nxn DK0002 2025-11-22T14:42:07.728Z 2025-11-29T14:54:44.752Z
8559702 8559702 20251121042253_j5pAy DK0002 2025-11-22T14:42:01.962Z 2025-11-29T14:54:43.315Z
8559615 8559615 20251121041856_DQ7uX DK0002 2025-11-22T14:41:59.969Z 2025-11-29T14:54:43.140Z
8559447 8559447 20251121041131_r5hE5 DK0002 2025-11-22T14:41:56.122Z 2025-11-29T14:54:39.117Z
8559380 8559380 20251121040907_RFM7u DK0002 2025-11-22T14:41:54.370Z 2025-11-29T14:54:38.376Z
8559335 8559335 20251121040648_Hyxj6 DK0002 2025-11-22T14:41:53.715Z 2025-11-29T14:54:37.865Z
8559190 8559190 20251121035707_Ixl8Z DK0002 2025-11-22T14:41:49.383Z 2025-11-29T14:54:37.502Z
8558874 8558874 20251121034417_IiFDZ DK0002 2025-11-22T14:41:24.125Z 2025-11-29T14:54:36.782Z
8558558 8558558 20251121033225_1DBEu DK0002 2025-11-22T14:41:07.673Z 2025-11-29T14:54:36.286Z
8558260 8558260 20251121032123_SRyfl DK0002 2025-11-22T14:41:01.775Z 2025-11-29T14:54:35.709Z
8558142 8558142 20251121031720_aYZka DK0002 2025-11-22T14:40:59.687Z 2025-11-29T14:54:35.375Z
8558109 8558109 20251121031603_EE2OG DK0002 2025-11-22T14:40:59.042Z 2025-11-29T14:54:35.293Z
8557774 8557774 20251121030007_uFB3b DK0002 2025-11-22T14:40:39.429Z 2025-11-29T14:54:34.700Z
8557634 8557634 20251121025452_3K5lR DK0002 2025-11-22T14:40:25.704Z 2025-11-29T14:54:34.415Z
8557522 8557522 20251121025031_7tjFU DK0002 2025-11-22T14:40:13.450Z 2025-11-29T14:54:34.301Z
8557122 8557122 20251121023421_8rRSa DK0002 2025-11-22T14:39:52.397Z 2025-11-29T14:54:33.500Z
8556902 8556902 20251121022009_7ZstU DK0002 2025-11-22T14:39:46.589Z 2025-11-29T14:54:33.143Z
8556856 8556856 20251121021702_7qYjm DK0002 2025-11-22T14:39:45.922Z 2025-11-29T14:54:33.081Z
8556481 8556481 20251121015632_hvIbf DK0002 2025-11-22T14:39:34.429Z 2025-11-29T14:54:32.399Z
8556413 8556413 20251121015210_tvYo2 DK0002 2025-11-22T14:39:32.133Z 2025-11-29T14:54:32.247Z
8555881 8555881 20251121012813_vke1L DK0002 2025-11-22T14:38:54.341Z 2025-11-29T14:54:31.370Z
8555796 8555796 20251121012305_LufPE DK0002 2025-11-22T14:38:51.803Z 2025-11-29T14:54:31.110Z

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