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

>10,000 rows count all where station_code = "NZ0017" 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
9627362 9627362 20260408172132_1RKti NZ0017 2026-04-09T12:10:45.614Z 2026-04-09T12:10:45.614Z
9627360 9627360 20260408172120_iQHNr NZ0017 2026-04-09T12:10:45.133Z 2026-04-09T12:10:45.133Z
9627356 9627356 20260408172036_MxAhB NZ0017 2026-04-09T12:10:44.731Z 2026-04-09T12:10:44.731Z
9627347 9627347 20260408172026_lcLnM NZ0017 2026-04-09T12:10:43.906Z 2026-04-09T12:10:43.906Z
9627322 9627322 20260408170820_6tmf5 NZ0017 2026-04-09T12:10:39.807Z 2026-04-09T12:10:39.807Z
9627283 9627283 20260408170052_nvM0x NZ0017 2026-04-09T12:10:33.080Z 2026-04-09T12:10:33.080Z
9627270 9627270 20260408165613_CMrTs NZ0017 2026-04-09T12:10:30.483Z 2026-04-09T12:10:30.483Z
9627236 9627236 20260408165037_xjY0u NZ0017 2026-04-09T12:10:22.058Z 2026-04-09T12:10:22.058Z
9627189 9627189 20260408164006_glniQ NZ0017 2026-04-09T12:10:16.312Z 2026-04-09T12:10:16.312Z
9627134 9627134 20260408163031_5ejkB NZ0017 2026-04-09T12:10:08.923Z 2026-04-09T12:10:08.923Z
9627131 9627131 20260408163028_Dq3Ev NZ0017 2026-04-09T12:10:08.447Z 2026-04-09T12:10:08.447Z
9627090 9627090 20260408161544_hSYnA NZ0017 2026-04-09T12:10:02.715Z 2026-04-09T12:10:02.715Z
9627054 9627054 20260408160115_TUaln NZ0017 2026-04-09T12:09:51.814Z 2026-04-09T12:09:51.814Z
9627037 9627037 20260408155836_06pzT NZ0017 2026-04-09T12:09:48.220Z 2026-04-09T12:09:48.220Z
9626919 9626919 20260408152241_BA5kc NZ0017 2026-04-09T12:09:32.189Z 2026-04-09T12:09:32.189Z
9626838 9626838 20260408151319_pisqf NZ0017 2026-04-09T12:09:17.650Z 2026-04-09T12:09:17.650Z
9626789 9626789 20260408150546_TREVH NZ0017 2026-04-09T12:09:11.769Z 2026-04-09T12:09:11.769Z
9626781 9626781 20260408150357_FkMEG NZ0017 2026-04-09T12:09:10.693Z 2026-04-09T12:09:10.693Z
9626772 9626772 20260408150342_7YVaY NZ0017 2026-04-09T12:09:10.208Z 2026-04-09T12:09:10.208Z
9626715 9626715 20260408145835_881v2 NZ0017 2026-04-09T12:09:05.457Z 2026-04-09T12:09:05.457Z
9626650 9626650 20260408143303_7dBgo NZ0017 2026-04-09T12:08:52.336Z 2026-04-09T12:08:52.336Z
9626643 9626643 20260408143219_8T7vR NZ0017 2026-04-09T12:08:50.782Z 2026-04-09T12:08:50.782Z
9626562 9626562 20260408141710_3DEFL NZ0017 2026-04-09T12:08:41.997Z 2026-04-09T12:08:41.997Z
9626480 9626480 20260408140549_675cc NZ0017 2026-04-09T12:08:25.859Z 2026-04-09T12:08:25.859Z
9626454 9626454 20260408140421_cD5Fo NZ0017 2026-04-09T12:08:22.938Z 2026-04-09T12:08:22.938Z
9626402 9626402 20260408135554_7TgxX NZ0017 2026-04-09T12:08:16.387Z 2026-04-09T12:08:16.387Z
9626304 9626304 20260408134018_S283M NZ0017 2026-04-09T12:07:57.505Z 2026-04-09T12:07:57.505Z
9626268 9626268 20260408133530_bEXeQ NZ0017 2026-04-09T12:07:53.397Z 2026-04-09T12:07:53.397Z
9626168 9626168 20260408132204_GRcum NZ0017 2026-04-09T12:07:43.980Z 2026-04-09T12:07:43.980Z
9626042 9626042 20260408130002_LBWdW NZ0017 2026-04-09T12:07:23.745Z 2026-04-09T12:07:23.745Z
9626027 9626027 20260408125417_MO3Ty NZ0017 2026-04-09T12:07:21.393Z 2026-04-09T12:07:21.393Z
9625902 9625902 20260408122303_JDVGy NZ0017 2026-04-09T12:07:05.266Z 2026-04-09T12:07:05.266Z
9625855 9625855 20260408121143_Vq21L NZ0017 2026-04-09T12:06:59.898Z 2026-04-09T12:06:59.898Z
9625842 9625842 20260408120619_q2sYu NZ0017 2026-04-09T12:06:58.750Z 2026-04-09T12:06:58.750Z
9625779 9625779 20260408114917_tDM7v NZ0017 2026-04-09T12:06:41.924Z 2026-04-09T12:06:41.924Z
9625759 9625759 20260408114436_59HbH NZ0017 2026-04-09T12:06:36.715Z 2026-04-09T12:06:36.715Z
9625636 9625636 20260408113032_w5iGq NZ0017 2026-04-09T12:06:10.720Z 2026-04-09T12:06:10.720Z
9625560 9625560 20260408112003_Htv2R NZ0017 2026-04-09T12:05:58.916Z 2026-04-09T12:05:58.916Z
9625531 9625531 20260408111105_wEroA NZ0017 2026-04-09T12:05:47.707Z 2026-04-09T12:05:47.707Z
9625511 9625511 20260408110625_0WNfT NZ0017 2026-04-09T12:05:43.137Z 2026-04-09T12:05:43.137Z
9625499 9625499 20260408110054_GjnNe NZ0017 2026-04-09T12:05:40.844Z 2026-04-09T12:05:40.844Z
9625486 9625486 20260408105924_F44vD NZ0017 2026-04-09T12:05:39.436Z 2026-04-09T12:05:39.436Z
9625448 9625448 20260408105510_rCj9N NZ0017 2026-04-09T12:05:34.781Z 2026-04-09T12:05:34.781Z
9625373 9625373 20260408104213_3faOL NZ0017 2026-04-09T12:05:17.675Z 2026-04-09T12:05:17.675Z
9625276 9625276 20260408101423_Pj8k5 NZ0017 2026-04-09T12:04:57.825Z 2026-04-09T12:04:57.825Z
9625262 9625262 20260408101120_a0Ptc NZ0017 2026-04-09T12:04:55.670Z 2026-04-09T12:04:55.670Z
9625207 9625207 20260408095559_oefHN NZ0017 2026-04-09T12:04:39.503Z 2026-04-09T12:04:39.503Z
9625061 9625061 20260408092750_ejlko NZ0017 2026-04-09T12:04:05.316Z 2026-04-09T12:04:05.316Z
9625045 9625045 20260408092333_p6qZG NZ0017 2026-04-09T12:04:00.678Z 2026-04-09T12:04:00.678Z
9624944 9624944 20260408090019_2RRiu NZ0017 2026-04-09T12:03:31.525Z 2026-04-09T12:03:31.525Z
9624912 9624912 20260408085431_02zC6 NZ0017 2026-04-09T12:03:25.776Z 2026-04-09T12:03:25.776Z
9610376 9610376 20260405173240_OEVWb NZ0017 2026-04-06T12:07:26.242Z 2026-04-09T12:36:46.630Z
9610368 9610368 20260405172047_zztRa NZ0017 2026-04-06T12:07:23.048Z 2026-04-09T12:36:46.086Z
9610287 9610287 20260405155337_NZHs8 NZ0017 2026-04-06T12:06:52.991Z 2026-04-09T12:36:43.070Z
9610235 9610235 20260405150718_Wslqd NZ0017 2026-04-06T12:06:31.910Z 2026-04-09T12:36:40.815Z
9610230 9610230 20260405150121_r7kG6 NZ0017 2026-04-06T12:06:27.986Z 2026-04-09T12:36:40.654Z
9610205 9610205 20260405143855_CmMhJ NZ0017 2026-04-06T12:06:21.356Z 2026-04-09T12:36:39.445Z
9610203 9610203 20260405143412_Q3O3j NZ0017 2026-04-06T12:06:20.615Z 2026-04-09T12:36:39.390Z
9610201 9610201 20260405143246_Cudcv NZ0017 2026-04-06T12:06:19.738Z 2026-04-09T12:36:39.270Z
9610196 9610196 20260405142658_vWvVW NZ0017 2026-04-06T12:06:18.610Z 2026-04-09T12:36:39.085Z
9610185 9610185 20260405141753_jeaq6 NZ0017 2026-04-06T12:06:15.878Z 2026-04-09T12:36:38.762Z
9610086 9610086 20260405124923_jZEjY NZ0017 2026-04-06T12:05:38.824Z 2026-04-09T12:36:20.901Z
9610065 9610065 20260405122642_YGHV3 NZ0017 2026-04-06T12:05:29.959Z 2026-04-09T12:36:20.091Z
9610062 9610062 20260405122215_3O4Qh NZ0017 2026-04-06T12:05:29.183Z 2026-04-09T12:36:19.997Z
9609854 9609854 20260405103706_Zp9bv NZ0017 2026-04-06T12:04:20.601Z 2026-04-09T12:36:10.991Z
9609807 9609807 20260405101127_xbUgk NZ0017 2026-04-06T12:03:58.349Z 2026-04-09T12:36:09.243Z
9609805 9609805 20260405101111_hF6CC NZ0017 2026-04-06T12:03:57.491Z 2026-04-09T12:36:09.146Z
9609764 9609764 20260405094626_42aHd NZ0017 2026-04-06T12:03:47.058Z 2026-04-09T12:36:07.366Z
9609761 9609761 20260405094626_En2XN NZ0017 2026-04-06T12:03:46.555Z 2026-04-09T12:36:07.273Z
9609748 9609748 20260405094053_q90XG NZ0017 2026-04-06T12:03:39.221Z 2026-04-09T12:36:06.772Z
9609695 9609695 20260405092057_L5VX2 NZ0017 2026-04-06T12:03:22.544Z 2026-04-09T12:36:05.149Z
9609662 9609662 20260405090011_xd3vM NZ0017 2026-04-06T12:03:09.473Z 2026-04-09T12:36:04.024Z
9609597 9609597 20260405083414_pDJnn NZ0017 2026-04-06T12:02:50.967Z 2026-04-09T12:36:02.075Z
9609573 9609573 20260405082540_zzZeD NZ0017 2026-04-06T12:02:41.235Z 2026-04-09T12:36:01.483Z
9603657 9603657 20260402113606_ZIoxh NZ0017 2026-04-03T12:03:59.645Z 2026-04-09T12:44:06.092Z
9603562 9603562 20260402110412_IWCCb NZ0017 2026-04-03T12:03:40.688Z 2026-04-09T12:44:04.053Z
9603512 9603512 20260402104540_FnOYq NZ0017 2026-04-03T12:03:18.968Z 2026-04-09T12:43:58.588Z
9603506 9603506 20260402104155_TRust NZ0017 2026-04-03T12:03:17.624Z 2026-04-09T12:43:56.244Z
9603497 9603497 20260402103715_33LOI NZ0017 2026-04-03T12:03:14.754Z 2026-04-09T12:43:55.184Z
9603463 9603463 20260402103117_pzx8f NZ0017 2026-04-03T12:03:10.367Z 2026-04-09T12:43:49.733Z
9603429 9603429 20260402101815_vBYie NZ0017 2026-04-03T12:03:04.005Z 2026-04-09T12:43:43.838Z
9603397 9603397 20260402100002_C281N NZ0017 2026-04-03T12:02:48.990Z 2026-04-04T12:12:47.589Z
9603377 9603377 20260402094633_02o3e NZ0017 2026-04-03T12:02:44.482Z 2026-04-09T12:43:30.774Z
9603359 9603359 20260402094359_3TDJX NZ0017 2026-04-03T12:02:42.613Z 2026-04-09T12:43:25.548Z
9603329 9603329 20260402093506_fYj9Y NZ0017 2026-04-03T12:02:37.857Z 2026-04-09T12:43:25.105Z
9603235 9603235 20260402090108_ffPqb NZ0017 2026-04-03T12:02:15.512Z 2026-04-09T12:43:23.634Z
9603225 9603225 20260402085325_9bhoT NZ0017 2026-04-03T12:02:13.215Z 2026-04-09T12:43:23.427Z
9603198 9603198 20260402084146_xVpOT NZ0017 2026-04-03T12:02:07.370Z 2026-04-09T12:43:22.872Z
9603047 9603047 20260402072027_h2R80 NZ0017 2026-04-03T12:01:34.446Z 2026-04-09T12:43:18.843Z
9601722 9601722 20260401164425_Zkk57 NZ0017 2026-04-02T12:03:32.039Z 2026-04-09T12:45:34.126Z
9601686 9601686 20260401162922_FCR5B NZ0017 2026-04-02T12:03:27.742Z 2026-04-09T12:45:33.540Z
9601612 9601612 20260401160914_8s6Lz NZ0017 2026-04-02T12:03:16.523Z 2026-04-09T12:45:32.200Z
9601576 9601576 20260401155459_QJ638 NZ0017 2026-04-02T12:03:10.708Z 2026-04-09T12:45:31.536Z
9601193 9601193 20260401130129_HQE2o NZ0017 2026-04-02T12:01:56.864Z 2026-04-09T12:45:24.733Z
9601029 9601029 20260401103856_8LgmW NZ0017 2026-04-02T12:01:19.957Z 2026-04-09T12:45:22.209Z
9600960 9600960 20260401094952_YoTm7 NZ0017 2026-04-02T12:01:08.069Z 2026-04-09T12:45:21.019Z
9600948 9600948 20260401092501_cfslz NZ0017 2026-04-02T12:01:03.578Z 2026-04-09T12:45:20.610Z
9600920 9600920 20260401084628_0nXSn NZ0017 2026-04-02T12:00:58.784Z 2026-04-09T12:45:20.219Z
9600901 9600901 20260401082709_RvU7r NZ0017 2026-04-02T12:00:54.969Z 2026-04-09T12:45:19.809Z
9600888 9600888 20260401075014_OlqoU NZ0017 2026-04-02T12:00:50.642Z 2026-04-09T12:45:18.309Z

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