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,832 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
9610566 9610566 20260404203621_olCxU DK0009 2026-04-06T12:10:10.105Z 2026-04-07T12:15:18.055Z
9610546 9610546 20260404202146_g6ztS DK0009 2026-04-06T12:10:06.270Z 2026-04-07T12:15:15.587Z
9610446 9610446 20260404190631_0gktO DK0009 2026-04-06T12:09:33.344Z 2026-04-07T12:15:09.258Z
9606766 9606766 20260402204717_qFHH0 DK0009 2026-04-04T12:11:32.790Z 2026-04-07T12:20:15.877Z
9604583 9604583 20260401213611_D5Z8M DK0009 2026-04-03T12:10:46.512Z 2026-04-07T12:21:44.345Z
9602771 9602771 20260402031240_plszV DK0009 2026-04-03T12:00:32.896Z 2026-04-07T12:18:43.926Z
9602766 9602766 20260402031010_m8yJ7 DK0009 2026-04-03T12:00:31.453Z 2026-04-07T12:18:43.712Z
9602757 9602757 20260402030135_BEZWy DK0009 2026-04-03T12:00:29.037Z 2026-04-07T12:18:43.294Z
9602671 9602671 20260401020613_32Lsv DK0009 2026-04-02T12:09:48.857Z 2026-04-07T12:23:40.454Z
9602612 9602612 20260401002419_sI9YK DK0009 2026-04-02T12:09:32.088Z 2026-04-07T12:23:37.561Z
9602523 9602523 20260331222931_Ji72o DK0009 2026-04-02T12:09:11.969Z 2026-04-07T12:23:34.941Z
9602487 9602487 20260331215158_WCCrW DK0009 2026-04-02T12:09:04.026Z 2026-04-07T12:23:33.961Z
9602470 9602470 20260331212853_yizIt DK0009 2026-04-02T12:09:00.709Z 2026-04-07T12:23:33.366Z
9602410 9602410 20260331205420_SWE7U DK0009 2026-04-02T12:08:45.113Z 2026-04-07T12:23:30.702Z
9602403 9602403 20260331204945_1xZod DK0009 2026-04-02T12:08:43.042Z 2026-04-07T12:23:30.129Z
9602394 9602394 20260331204716_Ep39F DK0009 2026-04-02T12:08:42.099Z 2026-04-07T12:23:29.946Z
9602359 9602359 20260331202025_PTUUz DK0009 2026-04-02T12:08:33.813Z 2026-04-07T12:23:28.663Z
9602324 9602324 20260331195411_zfHAy DK0009 2026-04-02T12:08:25.203Z 2026-04-07T12:23:27.235Z
9600805 9600805 20260401030722_2tPC8 DK0009 2026-04-02T12:00:22.822Z 2026-04-07T12:20:36.239Z
9600789 9600789 20260401025359_HAJRq DK0009 2026-04-02T12:00:18.112Z 2026-04-07T12:20:35.559Z
9600371 9600371 20260330205501_3XNH5 DK0009 2026-04-01T12:10:29.162Z 2026-04-07T12:26:01.651Z
9600367 9600367 20260330204841_13C9p DK0009 2026-04-01T12:10:27.684Z 2026-04-07T12:26:01.340Z
9594861 9594861 20260329004617_DBhPI DK0009 2026-03-30T12:10:28.203Z 2026-04-06T12:40:18.554Z
9594809 9594809 20260329003401_9X4rC DK0009 2026-03-30T12:10:21.163Z 2026-04-06T12:40:16.487Z
9594737 9594737 20260329001902_kwxO6 DK0009 2026-03-30T12:10:14.730Z 2026-04-06T12:40:14.334Z
9594650 9594650 20260328234542_cD61B DK0009 2026-03-30T12:10:03.780Z 2026-04-06T12:40:02.735Z
9594590 9594590 20260328232048_qv6YR DK0009 2026-03-30T12:09:55.099Z 2026-04-06T12:40:00.553Z
9594576 9594576 20260328231146_yUIVv DK0009 2026-03-30T12:09:53.072Z 2026-04-06T12:39:59.942Z
9594418 9594418 20260328221944_JiU1p DK0009 2026-03-30T12:09:32.744Z 2026-04-06T12:39:51.956Z
9592602 9592602 20260329024600_41E0l DK0009 2026-03-30T12:01:25.757Z 2026-04-07T12:26:36.014Z
9588494 9588494 20260326232423_v98sM DK0009 2026-03-28T12:11:16.493Z 2026-04-04T12:42:16.521Z
9585919 9585919 20260327030900_serrG DK0009 2026-03-28T12:01:45.260Z 2026-04-05T12:32:52.889Z
9585837 9585837 20260327024710_cPGaR DK0009 2026-03-28T12:01:30.784Z 2026-04-05T12:32:48.605Z
9585605 9585605 20260327015419_WkhMG DK0009 2026-03-28T12:00:46.630Z 2026-04-05T12:32:30.011Z
9585409 9585409 20260327005403_pnuAW DK0009 2026-03-28T12:00:15.388Z 2026-04-05T12:32:20.021Z
9570869 9570869 20260322230441_i4Guw DK0009 2026-03-24T12:23:57.339Z 2026-03-30T12:30:50.875Z
9570690 9570690 20260322223201_20NMe DK0009 2026-03-24T12:23:38.362Z 2026-03-30T12:30:47.877Z
9570448 9570448 20260322212856_XSOrY DK0009 2026-03-24T12:23:18.067Z 2026-03-30T12:30:43.285Z
9570400 9570400 20260322210938_vjMO9 DK0009 2026-03-24T12:23:09.770Z 2026-03-30T12:30:41.915Z
9570164 9570164 20260322193545_UHIJO DK0009 2026-03-24T12:22:44.421Z 2026-03-30T12:30:28.980Z
9562735 9562735 20260323030743_2uq3L DK0009 2026-03-24T12:03:53.985Z 2026-03-31T12:26:24.472Z
9562534 9562534 20260323022945_uph2K DK0009 2026-03-24T12:03:21.146Z 2026-03-31T12:26:13.606Z
9562209 9562209 20260323015004_u7p9n DK0009 2026-03-24T12:02:28.529Z 2026-03-31T12:26:03.984Z
9562178 9562178 20260323014150_ddUSR DK0009 2026-03-24T12:02:22.684Z 2026-03-31T12:26:02.917Z
9562161 9562161 20260323013938_eOWQ2 DK0009 2026-03-24T12:02:20.106Z 2026-03-31T12:26:02.597Z
9561887 9561887 20260323005247_gv3lA DK0009 2026-03-24T12:01:31.489Z 2026-03-31T12:25:55.681Z
9561812 9561812 20260323004716_2RMvl DK0009 2026-03-24T12:01:22.429Z 2026-03-31T12:25:54.164Z
9561653 9561653 20260323001956_k3QPz DK0009 2026-03-24T12:00:50.440Z 2026-03-31T12:25:49.732Z
9561626 9561626 20260323001514_Z2LJu DK0009 2026-03-24T12:00:43.325Z 2026-03-31T12:25:49.018Z
9561294 9561294 20260321231856_01Gve DK0009 2026-03-23T12:12:15.849Z 2026-03-29T12:21:06.235Z
9560072 9560072 20260321202958_85f31 DK0009 2026-03-23T12:11:37.288Z 2026-03-29T12:20:57.748Z
9559861 9559861 20260321200336_Vi6FH DK0009 2026-03-23T12:11:32.529Z 2026-03-29T12:20:56.162Z
9559665 9559665 20260321191547_X1TkY DK0009 2026-03-23T12:11:26.008Z 2026-03-29T12:20:42.481Z
9559629 9559629 20260321185141_BfD8v DK0009 2026-03-23T12:11:16.170Z 2026-03-29T12:20:42.195Z
9554744 9554744 20260322033244_AP0m3 DK0009 2026-03-23T12:02:48.881Z 2026-03-30T12:28:08.205Z
9554180 9554180 20260322024658_04Ij4 DK0009 2026-03-23T12:02:18.757Z 2026-03-30T12:27:59.922Z
9553452 9553452 20260322014258_3iah5 DK0009 2026-03-23T12:01:30.717Z 2026-03-30T12:27:41.288Z
9553177 9553177 20260322012315_lZxfc DK0009 2026-03-23T12:01:18.469Z 2026-03-30T12:27:36.154Z
9553077 9553077 20260322010913_UR2K2 DK0009 2026-03-23T12:01:11.995Z 2026-03-30T12:27:34.572Z
9552716 9552716 20260322003542_4Zm0k DK0009 2026-03-23T12:00:45.597Z 2026-03-30T12:27:28.833Z
9552435 9552435 20260322000646_04N3v DK0009 2026-03-23T12:00:24.161Z 2026-03-30T12:27:23.988Z
9552416 9552416 20260322000548_aE52u DK0009 2026-03-23T12:00:23.118Z 2026-03-30T12:27:23.805Z
9542041 9542041 20260319223747_ZScEC DK0009 2026-03-21T12:29:37.385Z 2026-03-27T12:42:44.568Z
9541785 9541785 20260319214439_wZzVt DK0009 2026-03-21T12:29:22.079Z 2026-03-27T12:42:41.724Z
9541678 9541678 20260319212636_iq1h1 DK0009 2026-03-21T12:29:16.395Z 2026-03-27T12:42:40.810Z
9541647 9541647 20260319211648_RbR6W DK0009 2026-03-21T12:29:14.348Z 2026-03-27T12:42:40.456Z
9541555 9541555 20260319210335_umPOv DK0009 2026-03-21T12:29:10.265Z 2026-03-27T12:42:38.718Z
9541434 9541434 20260319203511_k2RCe DK0009 2026-03-21T12:28:56.022Z 2026-03-27T12:42:37.578Z
9541401 9541401 20260319203206_y8i2t DK0009 2026-03-21T12:28:54.069Z 2026-03-27T12:42:37.258Z
9533989 9533989 20260320031527_EZY3p DK0009 2026-03-21T12:06:51.049Z 2026-03-28T12:34:03.240Z
9533052 9533052 20260320015342_H8OZ5 DK0009 2026-03-21T12:04:19.111Z 2026-03-28T12:33:48.149Z
9531143 9531143 20260318223646_t0AlY DK0009 2026-03-20T12:24:59.280Z 2026-03-26T12:39:17.743Z
9530861 9530861 20260318215424_Km2ZH DK0009 2026-03-20T12:24:49.843Z 2026-03-26T12:39:16.258Z
9530143 9530143 20260318201633_BqTIk DK0009 2026-03-20T12:24:03.190Z 2026-03-26T12:39:09.704Z
9529950 9529950 20260318194457_CcijX DK0009 2026-03-20T12:23:51.194Z 2026-03-26T12:39:07.708Z
9520238 9520238 20260319030601_GdHy1 DK0009 2026-03-20T12:06:01.742Z 2026-03-27T12:40:40.872Z
9519709 9519709 20260319023142_YA8CL DK0009 2026-03-20T12:04:57.903Z 2026-03-27T12:40:34.666Z
9518731 9518731 20260319012124_t0gfA DK0009 2026-03-20T12:03:12.059Z 2026-03-27T12:40:13.038Z
9518683 9518683 20260319011754_ASUB2 DK0009 2026-03-20T12:03:06.494Z 2026-03-27T12:40:12.652Z
9518319 9518319 20260319004905_I8DLR DK0009 2026-03-20T12:02:17.669Z 2026-03-27T12:40:08.319Z
9517787 9517787 20260319000234_RaXLl DK0009 2026-03-20T12:01:16.200Z 2026-03-27T12:40:03.255Z
9517580 9517580 20260318234245_QM2xJ DK0009 2026-03-20T12:00:46.411Z 2026-03-27T12:40:01.109Z
9517478 9517478 20260318233119_m6Br3 DK0009 2026-03-20T12:00:28.791Z 2026-03-27T12:40:00.089Z
9517210 9517210 20260317225548_YOgY8 DK0009 2026-03-19T12:27:19.833Z 2026-03-25T12:43:09.380Z
9516584 9516584 20260317211420_Gmd3p DK0009 2026-03-19T12:26:31.339Z 2026-03-25T12:43:03.626Z
9510325 9510325 20260318024530_GAznY DK0009 2026-03-19T12:07:23.046Z 2026-03-26T12:37:11.576Z
9507675 9507675 20260317233458_MVVBn DK0009 2026-03-19T12:00:58.021Z 2026-03-26T12:36:52.577Z
9507289 9507289 20260316205656_FIRVl DK0009 2026-03-18T12:20:10.130Z 2026-03-24T12:41:44.075Z
9501958 9501958 20260317003825_UKDMR DK0009 2026-03-18T12:00:51.645Z 2026-03-25T12:41:44.225Z
9501940 9501940 20260317002156_lTE2R DK0009 2026-03-18T12:00:48.524Z 2026-03-25T12:41:44.103Z
9501876 9501876 20260316235557_p1GUk DK0009 2026-03-18T12:00:33.225Z 2026-03-25T12:41:43.460Z
9501828 9501828 20260316231850_kIFXx DK0009 2026-03-18T12:00:20.984Z 2026-03-25T12:41:42.944Z
9501244 9501244 20260315213855_OZUkn DK0009 2026-03-17T12:24:45.186Z 2026-03-23T12:22:43.745Z
9500869 9500869 20260315195158_CbOAR DK0009 2026-03-17T12:24:06.545Z 2026-03-23T12:22:42.154Z
9500792 9500792 20260315192302_h06lk DK0009 2026-03-17T12:23:51.768Z 2026-03-23T12:22:41.507Z
9493817 9493817 20260316004326_aIa1s DK0009 2026-03-17T12:02:09.151Z 2026-03-24T12:40:42.206Z
9464290 9464290 20260312041428_TMjun DK0009 2026-03-13T12:06:48.900Z 2026-03-20T12:36:36.395Z
9464119 9464119 20260312033641_BLktc DK0009 2026-03-13T12:06:20.374Z 2026-03-20T12:36:30.586Z
9456231 9456231 20260309222441_RnRQG DK0009 2026-03-11T12:15:52.722Z 2026-03-17T12:42:59.450Z
9456000 9456000 20260309212352_CGsLX DK0009 2026-03-11T12:15:24.427Z 2026-03-17T12:42:45.913Z

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