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

676 rows where station_code = "DK0005" 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
8666437 8666437 20251201054005_BhmyJ DK0005 2025-12-02T14:26:11.846Z 2025-12-06T14:42:22.267Z
8666425 8666425 20251201053827_xERGJ DK0005 2025-12-02T14:26:01.453Z 2025-12-02T14:26:01.453Z
8666414 8666414 20251201053644_IqkcJ DK0005 2025-12-02T14:25:59.380Z 2025-12-06T14:42:21.546Z
8666304 8666304 20251201051002_Ft6nv DK0005 2025-12-02T14:25:44.318Z 2025-12-06T14:42:16.756Z
8666139 8666139 20251201044128_Ii2Nt DK0005 2025-12-02T14:25:18.877Z 2025-12-06T14:42:13.010Z
8666016 8666016 20251201042455_IEJ2V DK0005 2025-12-02T14:25:06.419Z 2025-12-06T14:42:09.741Z
8665872 8665872 20251201040417_2x3g2 DK0005 2025-12-02T14:24:37.668Z 2025-12-06T14:42:05.808Z
8665863 8665863 20251201040323_ynce4 DK0005 2025-12-02T14:24:36.193Z 2025-12-06T14:42:05.287Z
8665390 8665390 20251201031525_Qy1Tq DK0005 2025-12-02T14:23:37.024Z 2025-12-06T14:41:36.731Z
8665265 8665265 20251201025715_df7DG DK0005 2025-12-02T14:23:15.132Z 2025-12-06T14:41:31.407Z
8664919 8664919 20251201020504_uTuni DK0005 2025-12-02T14:22:27.270Z 2025-12-06T14:41:03.134Z
8664858 8664858 20251201015157_ClDd9 DK0005 2025-12-02T14:22:13.778Z 2025-12-06T14:41:01.199Z
8664744 8664744 20251201013402_Dbp1K DK0005 2025-12-02T14:22:00.600Z 2025-12-06T14:40:56.223Z
8663853 8663853 20251130222015_NLtQC DK0005 2025-12-02T14:19:26.179Z 2025-12-06T14:40:13.132Z
8647758 8647758 20251129052041_8VSxp DK0005 2025-11-30T14:28:51.914Z 2025-12-06T14:56:46.572Z
8647564 8647564 20251129045140_cLmiw DK0005 2025-11-30T14:28:35.798Z 2025-12-06T14:56:41.295Z
8647536 8647536 20251129044831_a13Bx DK0005 2025-11-30T14:28:33.671Z 2025-12-06T14:56:40.788Z
8647148 8647148 20251129035214_gfKYZ DK0005 2025-11-30T14:27:45.434Z 2025-12-06T14:56:32.848Z
8647142 8647142 20251129035047_frXDS DK0005 2025-11-30T14:27:44.969Z 2025-12-06T14:56:32.731Z
8646837 8646837 20251129030018_3BwCr DK0005 2025-11-30T14:27:01.170Z 2025-12-06T14:56:26.187Z
8622648 8622648 20251126203100_TCJQI DK0005 2025-11-28T14:19:38.009Z 2025-12-05T15:03:04.604Z
8622547 8622547 20251126195147_GY7i4 DK0005 2025-11-28T14:19:08.507Z 2025-12-05T15:03:03.274Z
8574318 8574318 20251122054722_eNQb4 DK0005 2025-11-23T14:43:05.772Z 2025-11-23T14:43:05.772Z
8574292 8574292 20251122054350_Zwz2O DK0005 2025-11-23T14:43:04.705Z 2025-11-23T14:43:04.705Z
8574211 8574211 20251122052554_EH7IJ DK0005 2025-11-23T14:42:49.489Z 2025-11-30T15:07:02.551Z
8573980 8573980 20251122045341_HlH05 DK0005 2025-11-23T14:42:09.955Z 2025-11-30T15:06:54.354Z
8573485 8573485 20251122032043_3PkFe DK0005 2025-11-23T14:41:13.900Z 2025-11-30T15:06:28.318Z
8572806 8572806 20251122014353_Yiq2M DK0005 2025-11-23T14:39:45.005Z 2025-11-23T14:39:45.005Z
8572793 8572793 20251122014303_cq3Lt DK0005 2025-11-23T14:39:44.354Z 2025-11-23T14:39:44.354Z
8572703 8572703 20251122013146_Azhed DK0005 2025-11-23T14:39:39.445Z 2025-11-30T15:05:55.716Z
8572585 8572585 20251122011332_iTuxd DK0005 2025-11-23T14:39:33.005Z 2025-11-30T15:05:52.359Z
8572580 8572580 20251122011303_qLfaW DK0005 2025-11-23T14:39:32.590Z 2025-11-30T15:05:52.333Z
8572072 8572072 20251121233226_WCwJ0 DK0005 2025-11-23T14:37:57.801Z 2025-11-30T15:05:37.044Z
8571877 8571877 20251121223759_fBmK6 DK0005 2025-11-23T14:37:48.314Z 2025-11-30T15:05:24.279Z
8571854 8571854 20251121223112_Cyetm DK0005 2025-11-23T14:37:46.741Z 2025-11-30T15:05:20.527Z
8571837 8571837 20251121221742_6RN2q DK0005 2025-11-23T14:37:45.845Z 2025-11-30T15:05:19.824Z
8571632 8571632 20251121213801_MXYNe DK0005 2025-11-23T14:37:15.023Z 2025-11-30T15:05:11.553Z
8571207 8571207 20251121194012_XsAfZ DK0005 2025-11-23T14:36:03.585Z 2025-11-30T15:04:39.540Z
8570898 8570898 20251121174808_VPNWJ DK0005 2025-11-23T14:35:08.993Z 2025-11-30T15:03:59.129Z
8570812 8570812 20251121170950_larl0 DK0005 2025-11-23T14:34:43.703Z 2025-11-30T15:03:43.716Z
8568637 8568637 20251121052817_OkzbX DK0005 2025-11-23T14:31:17.057Z 2025-11-29T14:54:47.148Z
8567724 8567724 20251121015431_o8pri DK0005 2025-11-23T14:27:23.333Z 2025-11-29T14:54:32.362Z
8560036 8560036 20251121043622_Dj3FT DK0005 2025-11-22T14:42:11.463Z 2025-11-22T14:42:11.463Z
8559993 8559993 20251121043402_KsuhQ DK0005 2025-11-22T14:42:08.669Z 2025-11-29T14:54:44.873Z
8559717 8559717 20251121042349_nfAJO DK0005 2025-11-22T14:42:02.180Z 2025-11-29T14:54:43.724Z
8559154 8559154 20251121035550_UZr1V DK0005 2025-11-22T14:41:48.690Z 2025-11-29T14:54:37.376Z
8558144 8558144 20251121031720_aYZka DK0005 2025-11-22T14:40:59.687Z 2025-11-29T14:54:35.375Z
8557994 8557994 20251121031033_wFhYe DK0005 2025-11-22T14:40:55.187Z 2025-11-29T14:54:35.028Z
8557548 8557548 20251121025222_H5NTZ DK0005 2025-11-22T14:40:21.978Z 2025-11-29T14:54:34.369Z
8557380 8557380 20251121024716_fkZ1o DK0005 2025-11-22T14:40:03.514Z 2025-11-29T14:54:34.108Z
8557324 8557324 20251121024514_ol443 DK0005 2025-11-22T14:40:00.919Z 2025-11-29T14:54:33.821Z
8556859 8556859 20251121021702_7qYjm DK0005 2025-11-22T14:39:45.922Z 2025-11-29T14:54:33.081Z
8556853 8556853 20251121021635_VaBET DK0005 2025-11-22T14:39:45.674Z 2025-11-29T14:54:33.060Z
8556129 8556129 20251121013908_3PwAv DK0005 2025-11-22T14:39:03.064Z 2025-11-29T14:54:31.850Z
8555820 8555820 20251121012414_mIJgd DK0005 2025-11-22T14:38:52.562Z 2025-11-29T14:54:31.239Z
8551211 8551211 20251121002941_HMPIz DK0005 2025-11-22T14:22:18.775Z 2025-11-22T14:22:18.775Z
8550961 8550961 20251121001334_HaLHP DK0005 2025-11-22T14:21:52.200Z 2025-11-29T14:54:27.906Z
8550600 8550600 20251120235505_2frPR DK0005 2025-11-22T14:21:17.012Z 2025-11-22T14:21:17.012Z
8550598 8550598 20251120235505_T6Xyc DK0005 2025-11-22T14:21:16.584Z 2025-11-22T14:21:16.584Z
8550469 8550469 20251120234518_3Ha0s DK0005 2025-11-22T14:20:56.982Z 2025-11-29T14:54:26.994Z
8550435 8550435 20251120234217_E1r2T DK0005 2025-11-22T14:20:55.058Z 2025-11-29T14:54:26.904Z
8550258 8550258 20251120233126_v8mvR DK0005 2025-11-22T14:20:29.706Z 2025-11-22T14:20:29.706Z
8549134 8549134 20251120215727_a9k2m DK0005 2025-11-22T14:18:23.320Z 2025-11-29T14:54:24.087Z
8547390 8547390 20251120194549_okSeY DK0005 2025-11-22T14:14:57.553Z 2025-11-29T14:54:19.825Z
8535976 8535976 20251120031752_fQLph DK0005 2025-11-21T14:17:21.331Z 2025-11-28T14:57:14.891Z
8535756 8535756 20251120025120_KxONS DK0005 2025-11-21T14:16:54.375Z 2025-11-28T14:57:00.051Z
8524477 8524477 20251119035022_bLFI9 DK0005 2025-11-20T14:20:54.602Z 2025-11-27T15:12:56.316Z
8524100 8524100 20251119030926_i5bMO DK0005 2025-11-20T14:20:06.977Z 2025-11-27T15:12:39.173Z
8523538 8523538 20251119021745_Jwij6 DK0005 2025-11-20T14:18:44.450Z 2025-11-27T15:12:22.339Z
8523231 8523231 20251119014407_kIH3C DK0005 2025-11-20T14:17:59.309Z 2025-11-27T15:12:10.446Z
8510252 8510252 20251118041850_GdB3F DK0005 2025-11-19T14:21:30.000Z 2025-11-26T15:08:00.595Z
8510220 8510220 20251118041523_R25yf DK0005 2025-11-19T14:21:27.313Z 2025-11-26T15:08:00.502Z
8508484 8508484 20251118010641_9nbBe DK0005 2025-11-19T14:17:50.180Z 2025-11-26T15:07:51.018Z
8507531 8507531 20251117233208_NTkrq DK0005 2025-11-19T14:15:26.561Z 2025-11-26T15:07:46.848Z
8506984 8506984 20251117223354_VAX6f DK0005 2025-11-19T14:14:13.196Z 2025-11-26T15:07:44.488Z
8504736 8504736 20251117191901_ZJSpi DK0005 2025-11-19T14:08:35.023Z 2025-11-26T15:07:30.745Z
8504596 8504596 20251117190846_SlZNQ DK0005 2025-11-19T14:08:24.369Z 2025-11-26T15:07:29.543Z
8503711 8503711 20251117175308_T7hrS DK0005 2025-11-19T14:06:04.627Z 2025-11-26T15:06:44.883Z
8497077 8497077 20251117051132_y2ElB DK0005 2025-11-18T14:28:36.705Z 2025-11-25T15:10:29.829Z
8495616 8495616 20251117040059_s9grN DK0005 2025-11-18T14:26:25.949Z 2025-11-25T15:09:57.353Z
8495606 8495606 20251117035912_na9sS DK0005 2025-11-18T14:26:22.420Z 2025-11-25T15:09:55.793Z
8494959 8494959 20251117032132_krJrK DK0005 2025-11-18T14:25:21.098Z 2025-11-25T15:09:42.610Z
8494883 8494883 20251117031626_G21UA DK0005 2025-11-18T14:25:01.861Z 2025-11-25T15:09:41.616Z
8494405 8494405 20251117024551_tn2Lh DK0005 2025-11-18T14:24:11.447Z 2025-11-25T15:09:35.874Z
8493592 8493592 20251117015312_whkxt DK0005 2025-11-18T14:22:31.314Z 2025-11-25T15:09:20.024Z
8491809 8491809 20251116231531_1ijvu DK0005 2025-11-18T14:18:21.875Z 2025-11-25T15:08:42.106Z
8491633 8491633 20251116225245_B6sfj DK0005 2025-11-18T14:17:53.508Z 2025-11-25T15:08:40.882Z
8491499 8491499 20251116224041_P4S2P DK0005 2025-11-18T14:17:36.500Z 2025-11-18T14:17:36.500Z
8491454 8491454 20251116223445_iLxKp DK0005 2025-11-18T14:17:32.206Z 2025-11-25T15:08:37.613Z
8491326 8491326 20251116221848_VcXwQ DK0005 2025-11-18T14:17:05.286Z 2025-11-25T15:08:36.722Z
8491272 8491272 20251116220814_S4yV8 DK0005 2025-11-18T14:16:58.880Z 2025-11-25T15:08:35.670Z
8481931 8481931 20251116044135_36JEM DK0005 2025-11-17T14:22:09.905Z 2025-11-24T15:05:15.199Z
8481918 8481918 20251116044110_WPYN0 DK0005 2025-11-17T14:22:09.023Z 2025-11-24T15:05:15.055Z
8481680 8481680 20251116035148_a0Oz8 DK0005 2025-11-17T14:21:32.833Z 2025-11-24T15:05:05.522Z
8481268 8481268 20251116022235_rsT2d DK0005 2025-11-17T14:20:34.302Z 2025-11-24T15:05:01.668Z
8481184 8481184 20251116020440_ane41 DK0005 2025-11-17T14:20:10.616Z 2025-11-24T15:04:59.837Z
8480406 8480406 20251115211315_T1o21 DK0005 2025-11-17T14:18:03.672Z 2025-11-24T15:04:52.517Z
8470518 8470518 20251115051016_yj0Y3 DK0005 2025-11-16T14:22:59.290Z 2025-11-23T15:18:13.678Z
8470485 8470485 20251115050638_fbpC2 DK0005 2025-11-16T14:22:56.033Z 2025-11-23T15:18:12.778Z
8470252 8470252 20251115044042_lHJnV DK0005 2025-11-16T14:22:15.289Z 2025-11-23T15:18:01.673Z

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