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,522 rows where station_code = "NL0017" 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
9610707 9610707 20260404211603_xCj14 NL0017 2026-04-06T12:10:48.832Z 2026-04-06T12:16:14.639Z
9606965 9606965 20260403011606_2ret2 NL0017 2026-04-04T12:12:34.021Z 2026-04-06T12:23:59.537Z
9604794 9604794 20260402004120_8WHdf NL0017 2026-04-03T12:11:33.212Z 2026-04-06T12:26:19.337Z
9604783 9604783 20260402003517_3mGSp NL0017 2026-04-03T12:11:31.822Z 2026-04-06T12:26:18.811Z
9604747 9604747 20260402001902_MZIEW NL0017 2026-04-03T12:11:25.528Z 2026-04-06T12:26:15.269Z
9604539 9604539 20260401200257_5JmpS NL0017 2026-04-03T12:10:17.174Z 2026-04-06T12:25:53.979Z
9602427 9602427 20260331210253_XeLVR NL0017 2026-04-02T12:08:48.201Z 2026-04-06T12:29:07.586Z
9602372 9602372 20260331203355_478Cq NL0017 2026-04-02T12:08:35.774Z 2026-04-06T12:29:03.561Z
9602347 9602347 20260331200654_wj7Dw NL0017 2026-04-02T12:08:29.098Z 2026-04-06T12:29:00.660Z
9600648 9600648 20260331003130_oneOX NL0017 2026-04-01T12:11:24.713Z 2026-04-06T12:33:43.966Z
9600560 9600560 20260330233303_4xy0y NL0017 2026-04-01T12:11:10.741Z 2026-04-06T12:33:34.418Z
9600427 9600427 20260330214923_RkZ9s NL0017 2026-04-01T12:10:44.271Z 2026-04-06T12:33:25.087Z
9600351 9600351 20260330203732_GrwR1 NL0017 2026-04-01T12:10:23.304Z 2026-04-06T12:33:18.721Z
9594971 9594971 20260329010951_3eoM6 NL0017 2026-03-30T12:10:41.898Z 2026-04-06T12:40:21.801Z
9594945 9594945 20260329010625_KVtgN NL0017 2026-03-30T12:10:40.188Z 2026-04-06T12:40:21.228Z
9594893 9594893 20260329005717_Gj1xt NL0017 2026-03-30T12:10:32.314Z 2026-04-06T12:40:19.811Z
9594537 9594537 20260328225438_TTVmI NL0017 2026-03-30T12:09:46.968Z 2026-04-06T12:39:56.266Z
9594454 9594454 20260328222532_Nd37J NL0017 2026-03-30T12:09:37.016Z 2026-04-06T12:39:52.856Z
9592918 9592918 20260329035549_SKGAC NL0017 2026-03-30T12:02:19.570Z 2026-04-06T12:34:40.537Z
9592669 9592669 20260329025604_xpSdb NL0017 2026-03-30T12:01:34.522Z 2026-04-06T12:34:20.270Z
9592480 9592480 20260329021637_RhpXs NL0017 2026-03-30T12:01:05.187Z 2026-04-06T12:34:12.095Z
9592478 9592478 20260329021403_F6y2Y NL0017 2026-03-30T12:01:04.506Z 2026-04-06T12:34:11.927Z
9592401 9592401 20260329020233_3urRE NL0017 2026-03-30T12:00:53.113Z 2026-04-06T12:34:09.115Z
9592316 9592316 20260329015043_8LhUS NL0017 2026-03-30T12:00:39.724Z 2026-04-06T12:34:00.200Z
9592251 9592251 20260329013057_qnvgD NL0017 2026-03-30T12:00:28.586Z 2026-04-06T12:33:55.260Z
9592195 9592195 20260329012015_PLrPS NL0017 2026-03-30T12:00:21.371Z 2026-04-06T12:33:53.294Z
9588581 9588581 20260326235948_9MaIy NL0017 2026-03-28T12:11:25.124Z 2026-04-04T12:42:20.079Z
9586000 9586000 20260327032608_DuYDC NL0017 2026-03-28T12:01:55.845Z 2026-04-05T12:32:55.903Z
9585974 9585974 20260327032133_hRVqU NL0017 2026-03-28T12:01:54.311Z 2026-04-05T12:32:55.377Z
9585964 9585964 20260327031841_qxLEm NL0017 2026-03-28T12:01:52.428Z 2026-04-05T12:32:54.813Z
9585823 9585823 20260327024216_11GS6 NL0017 2026-03-28T12:01:28.123Z 2026-04-05T12:32:47.605Z
9585745 9585745 20260327021909_0w3T8 NL0017 2026-03-28T12:01:10.857Z 2026-04-05T12:32:37.195Z
9585647 9585647 20260327020214_FWWM3 NL0017 2026-03-28T12:00:53.516Z 2026-04-05T12:32:31.727Z
9585495 9585495 20260327012101_2EiQ9 NL0017 2026-03-28T12:00:30.407Z 2026-04-05T12:32:23.962Z
9585461 9585461 20260327010511_whLpo NL0017 2026-03-28T12:00:24.256Z 2026-04-05T12:32:22.292Z
9581992 9581992 20260326042033_v1mna NL0017 2026-03-27T12:04:21.071Z 2026-04-04T12:39:34.053Z
9580470 9580470 20260326005105_E35cj NL0017 2026-03-27T12:00:32.298Z 2026-04-04T12:38:11.092Z
9580441 9580441 20260326004903_ad8O8 NL0017 2026-03-27T12:00:29.743Z 2026-04-04T12:38:10.479Z
9579490 9579490 20260324205756_kbHz2 NL0017 2026-03-26T12:13:48.482Z 2026-04-02T12:37:12.352Z
9576966 9576966 20260325032959_vDKHn NL0017 2026-03-26T12:03:46.633Z 2026-04-03T12:36:27.290Z
9576917 9576917 20260325032518_cr80Z NL0017 2026-03-26T12:03:38.818Z 2026-04-03T12:36:25.557Z
9575499 9575499 20260323224923_rsav4 NL0017 2026-03-25T12:21:16.369Z 2026-03-31T12:29:00.208Z
9571056 9571056 20260322234137_9BaGC NL0017 2026-03-24T12:24:17.310Z 2026-03-30T12:30:54.503Z
9570924 9570924 20260322231244_Uxn7f NL0017 2026-03-24T12:24:01.990Z 2026-03-30T12:30:52.100Z
9570511 9570511 20260322214425_zTNkP NL0017 2026-03-24T12:23:22.843Z 2026-03-30T12:30:44.438Z
9570362 9570362 20260322204625_xxUTo NL0017 2026-03-24T12:23:04.356Z 2026-03-30T12:30:40.847Z
9570003 9570003 20260322184945_EgZgT NL0017 2026-03-24T12:22:27.100Z 2026-03-30T12:30:26.153Z
9562191 9562191 20260323014711_0b5cK NL0017 2026-03-24T12:02:24.970Z 2026-03-31T12:26:03.392Z
9561102 9561102 20260321225934_2dPts NL0017 2026-03-23T12:12:11.662Z 2026-03-29T12:21:05.177Z
9560931 9560931 20260321223642_dXnNm NL0017 2026-03-23T12:12:07.807Z 2026-03-29T12:21:04.000Z
9554978 9554978 20260322035044_PdnVZ NL0017 2026-03-23T12:02:59.926Z 2026-03-30T12:28:12.541Z
9554664 9554664 20260322032353_ZM9ma NL0017 2026-03-23T12:02:44.854Z 2026-03-30T12:28:06.915Z
9553266 9553266 20260322012857_9gMwq NL0017 2026-03-23T12:01:21.857Z 2026-03-30T12:27:38.644Z
9553099 9553099 20260322011121_25J05 NL0017 2026-03-23T12:01:13.030Z 2026-03-30T12:27:34.856Z
9552960 9552960 20260322010017_GFoUW NL0017 2026-03-23T12:01:03.770Z 2026-03-30T12:27:32.969Z
9552051 9552051 20260320224253_BRJko NL0017 2026-03-22T12:27:24.573Z 2026-03-28T12:37:05.995Z
9551829 9551829 20260320215207_BtoNe NL0017 2026-03-22T12:27:05.345Z 2026-03-28T12:37:02.604Z
9551793 9551793 20260320213533_UPiCe NL0017 2026-03-22T12:27:03.087Z 2026-03-28T12:37:02.197Z
9551286 9551286 20260320191015_zPQor NL0017 2026-03-22T12:26:23.425Z 2026-03-28T12:36:41.886Z
9551176 9551176 20260320184424_EhxNH NL0017 2026-03-22T12:26:15.447Z 2026-03-28T12:36:40.687Z
9542763 9542763 20260321012102_LE7tr NL0017 2026-03-22T12:01:32.861Z 2026-03-29T12:18:58.011Z
9541988 9541988 20260319222333_o2bqL NL0017 2026-03-21T12:29:33.621Z 2026-03-27T12:42:43.829Z
9541965 9541965 20260319221530_JSBrL NL0017 2026-03-21T12:29:32.167Z 2026-03-27T12:42:43.467Z
9541790 9541790 20260319214456_uU7kG NL0017 2026-03-21T12:29:22.324Z 2026-03-27T12:42:41.759Z
9532962 9532962 20260320014305_hOfHA NL0017 2026-03-21T12:04:07.506Z 2026-03-28T12:33:47.131Z
9532402 9532402 20260320005158_rfNYY NL0017 2026-03-21T12:02:36.295Z 2026-03-28T12:33:29.742Z
9531161 9531161 20260318223736_MQ3Wf NL0017 2026-03-20T12:25:00.011Z 2026-03-26T12:39:17.870Z
9530681 9530681 20260318212345_vW6Xb NL0017 2026-03-20T12:24:35.578Z 2026-03-26T12:39:14.766Z
9530638 9530638 20260318211841_jVcKD NL0017 2026-03-20T12:24:33.451Z 2026-03-26T12:39:14.498Z
9530348 9530348 20260318204026_8UqXH NL0017 2026-03-20T12:24:19.013Z 2026-03-26T12:39:11.399Z
9529597 9529597 20260318185757_cFbOQ NL0017 2026-03-20T12:23:20.391Z 2026-03-26T12:39:04.698Z
9521122 9521122 20260319035420_P0a93 NL0017 2026-03-20T12:07:32.749Z 2026-03-27T12:40:51.803Z
9520947 9520947 20260319034520_NjuYH NL0017 2026-03-20T12:07:16.555Z 2026-03-27T12:40:49.231Z
9520013 9520013 20260319024751_4FwtH NL0017 2026-03-20T12:05:32.335Z 2026-03-27T12:40:38.007Z
9519984 9519984 20260319024649_OsyPH NL0017 2026-03-20T12:05:28.825Z 2026-03-27T12:40:37.642Z
9519638 9519638 20260319022404_TJAO4 NL0017 2026-03-20T12:04:48.510Z 2026-03-27T12:40:33.622Z
9519603 9519603 20260319022101_e9qyw NL0017 2026-03-20T12:04:42.832Z 2026-03-27T12:40:33.028Z
9519410 9519410 20260319020835_Nau6y NL0017 2026-03-20T12:04:26.368Z 2026-03-27T12:40:30.903Z
9518882 9518882 20260319013145_ga8Gu NL0017 2026-03-20T12:03:32.703Z 2026-03-27T12:40:16.099Z
9518747 9518747 20260319012220_ilAK4 NL0017 2026-03-20T12:03:13.396Z 2026-03-27T12:40:13.232Z
9518561 9518561 20260319010815_TrHM3 NL0017 2026-03-20T12:02:49.112Z 2026-03-27T12:40:11.302Z
9518260 9518260 20260319004717_oYrHC NL0017 2026-03-20T12:02:13.527Z 2026-03-27T12:40:07.993Z
9518015 9518015 20260319002214_bsR12 NL0017 2026-03-20T12:01:43.322Z 2026-03-27T12:40:05.485Z
9517181 9517181 20260317225008_gVabX NL0017 2026-03-19T12:27:16.826Z 2026-03-25T12:43:09.101Z
9516442 9516442 20260317205423_2kKEG NL0017 2026-03-19T12:26:12.966Z 2026-03-25T12:42:59.052Z
9516396 9516396 20260317204504_o9mxX NL0017 2026-03-19T12:26:07.381Z 2026-03-25T12:42:57.919Z
9515989 9515989 20260317193956_Pq7gH NL0017 2026-03-19T12:25:26.260Z 2026-03-25T12:42:45.283Z
9515956 9515956 20260317193719_p26kp NL0017 2026-03-19T12:25:23.529Z 2026-03-25T12:42:44.543Z
9511726 9511726 20260318041347_8PJfN NL0017 2026-03-19T12:10:51.071Z 2026-03-26T12:37:39.197Z
9511401 9511401 20260318034958_XOqbf NL0017 2026-03-19T12:10:06.717Z 2026-03-26T12:37:36.625Z
9511360 9511360 20260318034750_9xvfk NL0017 2026-03-19T12:10:01.579Z 2026-03-26T12:37:36.279Z
9511262 9511262 20260318034230_lBv9B NL0017 2026-03-19T12:09:49.050Z 2026-03-26T12:37:32.414Z
9511125 9511125 20260318033706_KfO4Y NL0017 2026-03-19T12:09:31.081Z 2026-03-26T12:37:23.235Z
9510801 9510801 20260318031620_n1JHq NL0017 2026-03-19T12:08:42.843Z 2026-03-26T12:37:16.785Z
9510051 9510051 20260318023118_tH9Zp NL0017 2026-03-19T12:06:49.416Z 2026-03-26T12:37:09.613Z
9509546 9509546 20260318015720_QZKV0 NL0017 2026-03-19T12:05:38.396Z 2026-03-26T12:37:06.337Z
9509432 9509432 20260318014833_p7Wzr NL0017 2026-03-19T12:05:17.769Z 2026-03-26T12:37:05.419Z
9508026 9508026 20260318000722_Wlprj NL0017 2026-03-19T12:01:56.587Z 2026-03-26T12:36:55.085Z
9507906 9507906 20260317235406_wm6kM NL0017 2026-03-19T12:01:38.442Z 2026-03-26T12:36:54.320Z
9507666 9507666 20260317233212_okeI7 NL0017 2026-03-19T12:00:54.229Z 2026-03-26T12:36:52.221Z

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