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,367 rows where station_code = "NZ002U" 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
9265774 9265774 20260127155757_J5Gzs NZ002U 2026-01-28T14:11:18.365Z 2026-01-29T14:30:24.672Z
9264913 9264913 20260127133252_jSvsx NZ002U 2026-01-28T14:08:15.309Z 2026-01-29T14:30:24.391Z
9264905 9264905 20260127133220_2X4Ux NZ002U 2026-01-28T14:08:13.891Z 2026-01-29T14:30:24.384Z
9264880 9264880 20260127132716_YPryc NZ002U 2026-01-28T14:08:05.518Z 2026-01-29T14:30:24.319Z
9264855 9264855 20260127132454_8WaNf NZ002U 2026-01-28T14:08:00.107Z 2026-01-29T14:30:24.314Z
9264654 9264654 20260127125215_nrI0r NZ002U 2026-01-28T14:07:03.485Z 2026-01-29T14:30:24.238Z
9264622 9264622 20260127125058_8TElX NZ002U 2026-01-28T14:06:56.030Z 2026-01-29T14:30:24.231Z
9264617 9264617 20260127125055_r0Aj6 NZ002U 2026-01-28T14:06:55.515Z 2026-01-29T14:30:24.230Z
9264506 9264506 20260127123954_225tN NZ002U 2026-01-28T14:06:26.759Z 2026-01-29T14:30:24.190Z
9264467 9264467 20260127122730_DDZNS NZ002U 2026-01-28T14:06:15.244Z 2026-01-29T14:30:21.771Z
9264352 9264352 20260127120513_455vJ NZ002U 2026-01-28T14:05:38.432Z 2026-01-29T14:30:20.875Z
9264345 9264345 20260127120352_RtIUy NZ002U 2026-01-28T14:05:36.075Z 2026-01-29T14:30:20.859Z
9264293 9264293 20260127115738_ITAKh NZ002U 2026-01-28T14:05:20.433Z 2026-01-29T14:30:20.845Z
9264265 9264265 20260127115307_4krVd NZ002U 2026-01-28T14:05:14.014Z 2026-01-29T14:30:20.572Z
9264219 9264219 20260127114125_EjUiq NZ002U 2026-01-28T14:04:59.959Z 2026-01-29T14:30:20.552Z
9264118 9264118 20260127111658_UOTzN NZ002U 2026-01-28T14:04:29.615Z 2026-01-29T14:30:20.055Z
9264097 9264097 20260127111426_upQAh NZ002U 2026-01-28T14:04:24.166Z 2026-01-29T14:30:20.050Z
9264054 9264054 20260127110619_NerYf NZ002U 2026-01-28T14:04:09.136Z 2026-01-29T14:30:20.031Z
9263998 9263998 20260127105024_YLx1O NZ002U 2026-01-28T14:03:51.934Z 2026-01-29T14:30:19.993Z
9263958 9263958 20260127104800_mhf22 NZ002U 2026-01-28T14:03:41.209Z 2026-01-29T14:30:19.977Z
9263924 9263924 20260127104348_gXe72 NZ002U 2026-01-28T14:03:33.434Z 2026-01-29T14:30:19.971Z
9263899 9263899 20260127103840_9dZrt NZ002U 2026-01-28T14:03:27.944Z 2026-01-29T14:30:19.958Z
9263850 9263850 20260127102109_PbRXo NZ002U 2026-01-28T14:03:08.751Z 2026-01-29T14:30:18.962Z
9263841 9263841 20260127102037_vTjcB NZ002U 2026-01-28T14:03:07.212Z 2026-01-29T14:30:18.961Z
9263773 9263773 20260127100953_LvDzC NZ002U 2026-01-28T14:02:42.290Z 2026-01-29T14:30:18.932Z
9263727 9263727 20260127100014_opRhR NZ002U 2026-01-28T14:02:28.131Z 2026-01-29T14:30:18.913Z
9233493 9233493 20260120160225_Rh2oe NZ002U 2026-01-21T14:05:58.222Z 2026-01-29T15:01:23.793Z
9233487 9233487 20260120160042_28aBC NZ002U 2026-01-21T14:05:57.658Z 2026-01-29T15:01:23.666Z
9233482 9233482 20260120155929_obULa NZ002U 2026-01-21T14:05:56.514Z 2026-01-29T15:01:23.430Z
9233471 9233471 20260120155111_wmKq3 NZ002U 2026-01-21T14:05:52.609Z 2026-01-29T15:01:21.773Z
9233455 9233455 20260120154146_2orh3 NZ002U 2026-01-21T14:05:50.019Z 2026-01-29T15:01:20.310Z
9233453 9233453 20260120153453_wj4yt NZ002U 2026-01-21T14:05:49.497Z 2026-01-29T15:01:19.688Z
9233436 9233436 20260120152104_KCokx NZ002U 2026-01-21T14:05:46.354Z 2026-01-29T15:01:17.509Z
9233428 9233428 20260120150917_Q4bY3 NZ002U 2026-01-21T14:05:44.731Z 2026-01-29T15:01:16.024Z
9233421 9233421 20260120150814_ZEpyO NZ002U 2026-01-21T14:05:43.657Z 2026-01-29T15:01:14.258Z
9233412 9233412 20260120150705_05gMm NZ002U 2026-01-21T14:05:42.378Z 2026-01-29T15:01:11.898Z
9233387 9233387 20260120150505_3WaAY NZ002U 2026-01-21T14:05:37.865Z 2026-01-29T15:01:04.369Z
9233382 9233382 20260120150416_QEDO1 NZ002U 2026-01-21T14:05:33.538Z 2026-01-29T15:01:03.899Z
9233376 9233376 20260120150405_pKCdC NZ002U 2026-01-21T14:05:33.104Z 2026-01-29T15:01:03.734Z
9233371 9233371 20260120150218_cAMYB NZ002U 2026-01-21T14:05:32.642Z 2026-01-29T15:01:03.586Z
9233341 9233341 20260120144941_WwEQm NZ002U 2026-01-21T14:05:25.331Z 2026-01-29T15:01:01.551Z
9233324 9233324 20260120144027_C3OIo NZ002U 2026-01-21T14:05:22.006Z 2026-01-29T15:01:00.554Z
9233320 9233320 20260120144017_8TQI7 NZ002U 2026-01-21T14:05:21.322Z 2026-01-29T15:01:00.336Z
9233308 9233308 20260120142917_S4q3f NZ002U 2026-01-21T14:05:18.496Z 2026-01-29T15:00:56.173Z
9233287 9233287 20260120142300_3CAyH NZ002U 2026-01-21T14:05:14.729Z 2026-01-29T15:00:54.860Z
9233272 9233272 20260120141308_MRZHK NZ002U 2026-01-21T14:05:04.649Z 2026-01-29T15:00:53.183Z
9233268 9233268 20260120140845_y8odk NZ002U 2026-01-21T14:05:04.201Z 2026-01-29T15:00:52.796Z
9233234 9233234 20260120135038_nLGmA NZ002U 2026-01-21T14:04:55.359Z 2026-01-29T15:00:51.086Z
9233212 9233212 20260120133809_ODIC9 NZ002U 2026-01-21T14:04:51.786Z 2026-01-29T15:00:49.767Z
9233189 9233189 20260120133526_6xtlI NZ002U 2026-01-21T14:04:49.413Z 2026-01-29T15:00:48.754Z
9233182 9233182 20260120133344_1d3x3 NZ002U 2026-01-21T14:04:48.922Z 2026-01-29T15:00:48.608Z
9233156 9233156 20260120133034_gGoM1 NZ002U 2026-01-21T14:04:45.568Z 2026-01-29T15:00:47.814Z
9233143 9233143 20260120132841_DgyCE NZ002U 2026-01-21T14:04:43.270Z 2026-01-29T15:00:47.129Z
9233138 9233138 20260120132814_inLIv NZ002U 2026-01-21T14:04:42.559Z 2026-01-29T15:00:46.990Z
9233100 9233100 20260120131955_2mPbU NZ002U 2026-01-21T14:04:30.723Z 2026-01-29T15:00:45.185Z
9233061 9233061 20260120131708_12JMl NZ002U 2026-01-21T14:04:21.678Z 2026-01-29T15:00:43.769Z
9232340 9232340 20260120110743_vDroF NZ002U 2026-01-21T14:01:21.889Z 2026-01-29T14:59:26.797Z
9232235 9232235 20260120104733_HlTpx NZ002U 2026-01-21T14:00:56.180Z 2026-01-29T14:59:20.885Z
9232222 9232222 20260120104708_CKYvC NZ002U 2026-01-21T14:00:53.240Z 2026-01-29T14:59:20.558Z
9232083 9232083 20260120101947_eYXo3 NZ002U 2026-01-21T14:00:16.241Z 2026-01-29T14:59:12.081Z
9231779 9231779 20260119094957_sSSef NZ002U 2026-01-20T14:34:18.788Z 2026-01-27T15:06:59.288Z
9227010 9227010 20260119135657_Lp3X5 NZ002U 2026-01-20T14:06:10.977Z 2026-01-28T14:55:46.680Z
9226997 9226997 20260119135406_pz7s6 NZ002U 2026-01-20T14:06:04.891Z 2026-01-28T14:55:46.322Z
9226990 9226990 20260119135211_nuR6Q NZ002U 2026-01-20T14:06:02.911Z 2026-01-28T14:55:46.080Z
9226938 9226938 20260119133216_mch82 NZ002U 2026-01-20T14:05:42.655Z 2026-01-28T14:55:42.973Z
9226859 9226859 20260119132046_1U2TW NZ002U 2026-01-20T14:05:24.796Z 2026-01-28T14:55:32.615Z
9226843 9226843 20260119131600_aVp3x NZ002U 2026-01-20T14:05:18.376Z 2026-01-28T14:55:31.474Z
9226762 9226762 20260119130038_ta5WC NZ002U 2026-01-20T14:04:55.068Z 2026-01-28T14:55:25.928Z
9226748 9226748 20260119125928_caUEQ NZ002U 2026-01-20T14:04:50.980Z 2026-01-28T14:55:25.029Z
9226709 9226709 20260119125123_dmf1U NZ002U 2026-01-20T14:04:39.683Z 2026-01-28T14:55:23.101Z
9226530 9226530 20260119121334_eqfwF NZ002U 2026-01-20T14:03:41.505Z 2026-01-28T14:55:05.857Z
9226443 9226443 20260119120243_R0FeN NZ002U 2026-01-20T14:03:13.888Z 2026-01-28T14:55:00.346Z
9226419 9226419 20260119115855_AY4kH NZ002U 2026-01-20T14:03:06.209Z 2026-01-28T14:54:59.228Z
9225759 9225759 20260118105117_DoZbL NZ002U 2026-01-19T14:30:05.369Z 2026-01-26T15:04:44.068Z
9225720 9225720 20260118104530_m4GSF NZ002U 2026-01-19T14:30:00.080Z 2026-01-26T15:04:42.978Z
9225715 9225715 20260118104528_zWqEI NZ002U 2026-01-19T14:29:59.513Z 2026-01-26T15:04:42.864Z
9225678 9225678 20260118104005_fWG5a NZ002U 2026-01-19T14:29:47.622Z 2026-01-26T15:04:41.656Z
9225655 9225655 20260118103626_SShKS NZ002U 2026-01-19T14:29:42.199Z 2026-01-26T15:04:41.088Z
9225631 9225631 20260118102818_fKpRs NZ002U 2026-01-19T14:29:38.458Z 2026-01-26T15:04:40.418Z
9225595 9225595 20260118102023_IuurW NZ002U 2026-01-19T14:29:31.717Z 2026-01-26T15:04:39.313Z
9225540 9225540 20260118100545_gdU4e NZ002U 2026-01-19T14:29:22.349Z 2026-01-26T15:04:37.549Z
9221746 9221746 20260117153141_PGPlm NZ002U 2026-01-19T14:11:23.291Z 2026-01-26T15:00:01.732Z
9221681 9221681 20260117124621_APOcr NZ002U 2026-01-19T14:09:45.084Z 2026-01-26T14:59:25.197Z
9221555 9221555 20260118155854_Rcf0P NZ002U 2026-01-19T14:08:20.261Z 2026-01-27T15:00:31.474Z
9221512 9221512 20260118154755_DLT2n NZ002U 2026-01-19T14:08:06.128Z 2026-01-27T15:00:28.583Z
9221506 9221506 20260118154724_EyPJa NZ002U 2026-01-19T14:08:05.557Z 2026-01-27T15:00:28.393Z
9221479 9221479 20260118154328_kJLCq NZ002U 2026-01-19T14:08:00.421Z 2026-01-27T15:00:26.164Z
9221474 9221474 20260118154328_IYFi4 NZ002U 2026-01-19T14:07:59.837Z 2026-01-27T15:00:25.764Z
9221452 9221452 20260118154233_fEw6I NZ002U 2026-01-19T14:07:57.005Z 2026-01-27T15:00:23.423Z
9221412 9221412 20260118153543_TVrYf NZ002U 2026-01-19T14:07:51.045Z 2026-01-27T15:00:19.872Z
9221380 9221380 20260118152953_66SF4 NZ002U 2026-01-19T14:07:41.796Z 2026-01-27T15:00:08.270Z
9221375 9221375 20260118152926_3Ar6J NZ002U 2026-01-19T14:07:41.278Z 2026-01-27T15:00:08.053Z
9221368 9221368 20260118152902_TqId3 NZ002U 2026-01-19T14:07:40.691Z 2026-01-27T15:00:07.923Z
9221338 9221338 20260118152258_b6wXz NZ002U 2026-01-19T14:07:31.614Z 2026-01-27T15:00:04.594Z
9221326 9221326 20260118152155_zscvD NZ002U 2026-01-19T14:07:29.924Z 2026-01-27T15:00:03.752Z
9221300 9221300 20260118151602_WrZvN NZ002U 2026-01-19T14:07:24.077Z 2026-01-27T15:00:00.846Z
9221236 9221236 20260118150945_3iJxB NZ002U 2026-01-19T14:07:13.867Z 2026-01-27T14:59:58.300Z
9221228 9221228 20260118150703_KspZ1 NZ002U 2026-01-19T14:07:08.616Z 2026-01-27T14:59:58.045Z
9221205 9221205 20260118150345_Wjm5i NZ002U 2026-01-19T14:07:04.552Z 2026-01-27T14:59:56.982Z
9221138 9221138 20260118145337_GtDDr NZ002U 2026-01-19T14:06:52.288Z 2026-01-27T14:59:54.964Z

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