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,154 rows where station_code = "DK0003" 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
9262726 9262726 20260126013954_XIZDf DK0003 2026-01-27T14:15:02.220Z 2026-01-29T14:38:39.354Z
9243959 9243959 20260121054354_TSsk3 DK0003 2026-01-22T14:23:39.510Z 2026-01-29T15:05:36.486Z
9243941 9243941 20260121053735_lvjxw DK0003 2026-01-22T14:23:37.553Z 2026-01-29T15:05:35.609Z
9243929 9243929 20260121053428_qCM2Y DK0003 2026-01-22T14:23:32.542Z 2026-01-29T15:05:34.889Z
9243589 9243589 20260121045023_a2tft DK0003 2026-01-22T14:22:17.036Z 2026-01-29T15:05:19.080Z
9243460 9243460 20260121043445_JBVOE DK0003 2026-01-22T14:22:00.625Z 2026-01-29T15:05:03.432Z
9243426 9243426 20260121043059_UiX7C DK0003 2026-01-22T14:21:45.450Z 2026-01-29T15:05:01.897Z
9243303 9243303 20260121041155_AI5zK DK0003 2026-01-22T14:21:22.810Z 2026-01-29T15:04:54.709Z
9243093 9243093 20260121034154_TepYM DK0003 2026-01-22T14:20:33.100Z 2026-01-29T15:04:46.289Z
9243037 9243037 20260121033454_2l6gx DK0003 2026-01-22T14:20:22.594Z 2026-01-29T15:04:44.504Z
9243012 9243012 20260121033207_hN7e6 DK0003 2026-01-22T14:20:18.487Z 2026-01-29T15:04:43.536Z
9242979 9242979 20260121032402_YAhp9 DK0003 2026-01-22T14:20:11.495Z 2026-01-29T15:04:39.644Z
9242840 9242840 20260121025820_dez1f DK0003 2026-01-22T14:19:31.539Z 2026-01-29T15:04:23.897Z
9242721 9242721 20260121023704_2Miqu DK0003 2026-01-22T14:19:03.328Z 2026-01-29T15:04:18.382Z
9242631 9242631 20260121022621_E2I0X DK0003 2026-01-22T14:18:38.031Z 2026-01-29T15:04:14.998Z
9242251 9242251 20260121011327_6jHDN DK0003 2026-01-22T14:17:01.546Z 2026-01-29T15:03:38.781Z
9241982 9241982 20260120235046_TpRkw DK0003 2026-01-22T14:15:43.072Z 2026-01-29T15:03:20.642Z
9241947 9241947 20260120234123_3rf7W DK0003 2026-01-22T14:15:29.544Z 2026-01-29T15:03:14.101Z
9241870 9241870 20260120231156_kQuaz DK0003 2026-01-22T14:15:01.195Z 2026-01-29T15:03:07.343Z
9241750 9241750 20260120221328_3WxWf DK0003 2026-01-22T14:14:23.447Z 2026-01-29T15:03:00.685Z
9241731 9241731 20260120215523_FzBLm DK0003 2026-01-22T14:14:18.515Z 2026-01-29T15:02:59.210Z
9241585 9241585 20260120211233_yOUl5 DK0003 2026-01-22T14:13:48.739Z 2026-01-29T15:02:54.048Z
9241544 9241544 20260120205836_yEztG DK0003 2026-01-22T14:13:40.399Z 2026-01-29T15:02:43.318Z
9240949 9240949 20260120183615_9UwUO DK0003 2026-01-22T14:11:01.544Z 2026-01-29T15:02:04.368Z
9237664 9237664 20260120054905_c23uz DK0003 2026-01-21T14:27:15.873Z 2026-01-28T15:01:35.330Z
9237636 9237636 20260120054608_z1IQT DK0003 2026-01-21T14:27:10.574Z 2026-01-28T15:01:34.185Z
9237556 9237556 20260120053543_0wgds DK0003 2026-01-21T14:27:00.185Z 2026-01-28T15:01:31.054Z
9237512 9237512 20260120052657_Cf6OZ DK0003 2026-01-21T14:26:50.405Z 2026-01-28T15:01:29.023Z
9237452 9237452 20260120052015_KDvQB DK0003 2026-01-21T14:26:32.999Z 2026-01-28T15:01:26.425Z
9237362 9237362 20260120050656_kqyP2 DK0003 2026-01-21T14:26:17.643Z 2026-01-28T15:01:21.910Z
9237280 9237280 20260120045735_fE9nU DK0003 2026-01-21T14:25:50.299Z 2026-01-28T15:01:07.642Z
9237276 9237276 20260120045733_nnbf2 DK0003 2026-01-21T14:25:50.000Z 2026-01-28T15:01:07.480Z
9237125 9237125 20260120044015_qSmh7 DK0003 2026-01-21T14:25:19.727Z 2026-01-28T15:00:58.980Z
9237115 9237115 20260120043907_q35CX DK0003 2026-01-21T14:25:18.284Z 2026-01-28T15:00:58.512Z
9236997 9236997 20260120042604_BQOXQ DK0003 2026-01-21T14:24:54.406Z 2026-01-28T15:00:52.938Z
9236877 9236877 20260120041307_Cs3i4 DK0003 2026-01-21T14:24:25.080Z 2026-01-28T15:00:40.360Z
9236828 9236828 20260120040434_t2dEh DK0003 2026-01-21T14:24:19.014Z 2026-01-28T15:00:38.080Z
9236755 9236755 20260120035604_p35jE DK0003 2026-01-21T14:23:54.588Z 2026-01-28T15:00:33.543Z
9236680 9236680 20260120034627_2VFUj DK0003 2026-01-21T14:23:40.881Z 2026-01-28T15:00:29.175Z
9236582 9236582 20260120033613_bxxwB DK0003 2026-01-21T14:23:26.803Z 2026-01-28T15:00:22.375Z
9236345 9236345 20260120030411_cfcJS DK0003 2026-01-21T14:22:25.157Z 2026-01-28T14:59:56.476Z
9236283 9236283 20260120025630_hznIg DK0003 2026-01-21T14:22:15.505Z 2026-01-28T14:59:53.365Z
9236025 9236025 20260120022853_5pb8h DK0003 2026-01-21T14:21:16.743Z 2026-01-28T14:59:41.461Z
9235836 9235836 20260120020639_z8uSB DK0003 2026-01-21T14:20:32.170Z 2026-01-28T14:59:23.574Z
9235713 9235713 20260120015105_1mELq DK0003 2026-01-21T14:20:02.927Z 2026-01-28T14:59:17.090Z
9235695 9235695 20260120014813_7jGgS DK0003 2026-01-21T14:19:59.901Z 2026-01-28T14:59:16.335Z
9235013 9235013 20260120000655_meYq5 DK0003 2026-01-21T14:17:10.493Z 2026-01-28T14:58:25.092Z
9234933 9234933 20260119235300_yrxfa DK0003 2026-01-21T14:16:42.845Z 2026-01-28T14:58:21.289Z
9234774 9234774 20260119232008_ToVMS DK0003 2026-01-21T14:16:02.746Z 2026-01-28T14:58:05.565Z
9234547 9234547 20260119221552_2RX2r DK0003 2026-01-21T14:15:06.132Z 2026-01-28T14:57:53.386Z
9234269 9234269 20260119203215_rBetM DK0003 2026-01-21T14:13:27.939Z 2026-01-28T14:57:26.242Z
9234189 9234189 20260119200056_QV67u DK0003 2026-01-21T14:12:54.526Z 2026-01-28T14:57:20.404Z
9234002 9234002 20260119191058_y4POM DK0003 2026-01-21T14:11:44.459Z 2026-01-28T14:56:57.874Z
9233885 9233885 20260119182909_tBrJJ DK0003 2026-01-21T14:11:10.350Z 2026-01-28T14:56:50.125Z
9233881 9233881 20260119182752_wx80R DK0003 2026-01-21T14:11:04.282Z 2026-01-28T14:56:49.955Z
9233710 9233710 20260119170956_Jhou3 DK0003 2026-01-21T14:10:02.911Z 2026-01-28T14:56:24.289Z
9231022 9231022 20260119054455_G4pVh DK0003 2026-01-20T14:30:56.470Z 2026-01-27T15:05:53.376Z
9230959 9230959 20260119053349_S0K2Z DK0003 2026-01-20T14:30:37.378Z 2026-01-27T15:05:50.136Z
9230937 9230937 20260119053056_ePLUo DK0003 2026-01-20T14:30:31.927Z 2026-01-27T15:05:37.532Z
9230928 9230928 20260119052950_ip1My DK0003 2026-01-20T14:30:30.048Z 2026-01-27T15:05:37.081Z
9230831 9230831 20260119051604_29mfF DK0003 2026-01-20T14:30:00.069Z 2026-01-27T15:05:29.350Z
9230743 9230743 20260119050041_23WY3 DK0003 2026-01-20T14:29:33.574Z 2026-01-27T15:05:23.870Z
9230482 9230482 20260119042530_Psk8V DK0003 2026-01-20T14:28:05.382Z 2026-01-27T15:04:57.250Z
9230378 9230378 20260119041021_6fbzR DK0003 2026-01-20T14:27:31.382Z 2026-01-27T15:04:51.234Z
9230339 9230339 20260119040404_C06Zt DK0003 2026-01-20T14:27:17.688Z 2026-01-27T15:04:49.409Z
9230255 9230255 20260119034624_17qsx DK0003 2026-01-20T14:26:50.612Z 2026-01-27T15:04:44.674Z
9230183 9230183 20260119033752_Pe1bY DK0003 2026-01-20T14:26:26.405Z 2026-01-27T15:04:31.898Z
9230178 9230178 20260119033741_Qw4ax DK0003 2026-01-20T14:26:25.470Z 2026-01-27T15:04:31.711Z
9230135 9230135 20260119033240_n0b9i DK0003 2026-01-20T14:26:12.654Z 2026-01-27T15:04:29.346Z
9229946 9229946 20260119025902_f5bhy DK0003 2026-01-20T14:25:05.240Z 2026-01-27T15:04:16.075Z
9229921 9229921 20260119025620_N83D4 DK0003 2026-01-20T14:25:00.378Z 2026-01-27T15:04:14.918Z
9229917 9229917 20260119025619_64dvv DK0003 2026-01-20T14:24:59.731Z 2026-01-27T15:04:14.802Z
9229826 9229826 20260119024320_bQvRW DK0003 2026-01-20T14:24:28.477Z 2026-01-27T15:03:59.381Z
9229804 9229804 20260119023800_b7NGQ DK0003 2026-01-20T14:24:17.995Z 2026-01-27T15:03:57.460Z
9229783 9229783 20260119023607_aGcy7 DK0003 2026-01-20T14:24:12.655Z 2026-01-27T15:03:56.642Z
9229739 9229739 20260119022722_o43Wf DK0003 2026-01-20T14:24:02.186Z 2026-01-27T15:03:52.538Z
9229684 9229684 20260119021714_VahTL DK0003 2026-01-20T14:23:42.634Z 2026-01-27T15:03:49.391Z
9229677 9229677 20260119021604_4r1bj DK0003 2026-01-20T14:23:41.375Z 2026-01-27T15:03:49.131Z
9229566 9229566 20260119020217_BDbHI DK0003 2026-01-20T14:23:10.524Z 2026-01-27T15:03:42.650Z
9229472 9229472 20260119015034_hsobm DK0003 2026-01-20T14:22:44.869Z 2026-01-27T15:03:27.839Z
9229362 9229362 20260119013625_64Iq4 DK0003 2026-01-20T14:22:14.310Z 2026-01-27T15:03:20.017Z
9229313 9229313 20260119012955_Lek8j DK0003 2026-01-20T14:21:57.380Z 2026-01-27T15:03:17.174Z
9229264 9229264 20260119011517_Bx9es DK0003 2026-01-20T14:21:44.839Z 2026-01-27T15:03:14.300Z
9229052 9229052 20260119004032_ZIGCu DK0003 2026-01-20T14:20:45.282Z 2026-01-27T15:02:51.647Z
9228821 9228821 20260118235903_icoQv DK0003 2026-01-20T14:19:41.404Z 2026-01-27T15:02:37.462Z
9228689 9228689 20260118233336_UsBdN DK0003 2026-01-20T14:18:59.633Z 2026-01-27T15:02:17.338Z
9228596 9228596 20260118230516_DPGED DK0003 2026-01-20T14:18:33.702Z 2026-01-27T15:02:10.161Z
9228255 9228255 20260118210126_b3AbO DK0003 2026-01-20T14:16:55.098Z 2026-01-27T15:01:38.921Z
9228098 9228098 20260118195454_dSehn DK0003 2026-01-20T14:16:03.496Z 2026-01-27T15:01:26.463Z
9227769 9227769 20260118174004_v46nx DK0003 2026-01-20T14:13:56.116Z 2026-01-27T15:00:52.207Z
9208580 9208580 20260115060211_CDFm3 DK0003 2026-01-16T14:13:13.601Z 2026-01-22T15:04:34.287Z
9208501 9208501 20260115054514_UuREz DK0003 2026-01-16T14:12:55.528Z 2026-01-22T15:04:31.800Z
9207138 9207138 20260114222947_n6xFe DK0003 2026-01-16T14:07:18.480Z 2026-01-22T15:03:11.682Z
9188062 9188062 20260111201300_20zJ8 DK0003 2026-01-13T14:10:16.087Z 2026-01-20T15:21:10.833Z
9187748 9187748 20260111184504_fEGVg DK0003 2026-01-13T14:08:43.838Z 2026-01-20T15:20:52.948Z
9187629 9187629 20260111180121_RH5m2 DK0003 2026-01-13T14:08:07.225Z 2026-01-20T15:20:36.753Z
9187486 9187486 20260111172525_LXGt5 DK0003 2026-01-13T14:07:33.114Z 2026-01-20T15:20:30.828Z
9182633 9182633 20260111055933_92K2J DK0003 2026-01-12T14:15:14.874Z 2026-01-19T15:18:52.679Z
9182590 9182590 20260111055233_XqBPL DK0003 2026-01-12T14:15:04.934Z 2026-01-19T15:18:50.525Z
9182569 9182569 20260111054422_5RSrF DK0003 2026-01-12T14:15:01.537Z 2026-01-19T15:18:49.629Z

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