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

3,152 rows where station_code = "NZ0028" 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
9273589 9273589 20260126151653_SZ2B3 NZ0028 2026-01-29T14:33:27.474Z 2026-01-29T14:33:27.474Z
9273585 9273585 20260126111625_qGrFB NZ0028 2026-01-29T14:32:13.686Z 2026-01-29T14:32:13.686Z
9264975 9264975 20260127134602_xgooq NZ0028 2026-01-28T14:08:27.764Z 2026-01-29T14:30:24.403Z
9264909 9264909 20260127133237_X232o NZ0028 2026-01-28T14:08:14.698Z 2026-01-29T14:30:24.385Z
9264716 9264716 20260127130133_nM7I8 NZ0028 2026-01-28T14:07:20.495Z 2026-01-29T14:30:24.262Z
9264582 9264582 20260127124837_AC4Mv NZ0028 2026-01-28T14:06:46.391Z 2026-01-29T14:30:24.224Z
9261961 9261961 20260126145958_HRiJ7 NZ0028 2026-01-27T14:06:47.555Z 2026-01-29T14:33:20.746Z
9233475 9233475 20260120155608_FaUiI NZ0028 2026-01-21T14:05:53.082Z 2026-01-29T15:01:22.847Z
9233440 9233440 20260120152158_lphtt NZ0028 2026-01-21T14:05:47.024Z 2026-01-29T15:01:17.919Z
9233360 9233360 20260120145723_639Y3 NZ0028 2026-01-21T14:05:27.609Z 2026-01-29T15:01:02.612Z
9233303 9233303 20260120142849_dvObi NZ0028 2026-01-21T14:05:17.907Z 2026-01-29T15:00:56.049Z
9233262 9233262 20260120140454_M3XFP NZ0028 2026-01-21T14:05:03.097Z 2026-01-29T15:00:52.384Z
9233259 9233259 20260120140039_gTZVA NZ0028 2026-01-21T14:05:02.572Z 2026-01-29T15:00:52.273Z
9233225 9233225 20260120134551_vAv5R NZ0028 2026-01-21T14:04:54.014Z 2026-01-29T15:00:50.508Z
9227225 9227225 20260119151457_35pUi NZ0028 2026-01-20T14:07:14.733Z 2026-01-28T14:56:00.205Z
9227177 9227177 20260119145744_pLzI3 NZ0028 2026-01-20T14:06:58.483Z 2026-01-28T14:55:55.630Z
9227124 9227124 20260119144109_nrg8d NZ0028 2026-01-20T14:06:41.510Z 2026-01-28T14:55:52.855Z
9227091 9227091 20260119143440_rU3Zl NZ0028 2026-01-20T14:06:34.179Z 2026-01-28T14:55:51.032Z
9227028 9227028 20260119140456_Gx2HV NZ0028 2026-01-20T14:06:15.871Z 2026-01-28T14:55:47.947Z
9227023 9227023 20260119140227_DMAok NZ0028 2026-01-20T14:06:14.568Z 2026-01-28T14:55:47.322Z
9226957 9226957 20260119133930_cJQXs NZ0028 2026-01-20T14:05:51.725Z 2026-01-28T14:55:43.911Z
9226888 9226888 20260119132621_dVfVR NZ0028 2026-01-20T14:05:33.295Z 2026-01-28T14:55:33.897Z
9226657 9226657 20260119123956_sBBpM NZ0028 2026-01-20T14:04:24.880Z 2026-01-28T14:55:20.330Z
9226588 9226588 20260119123031_F2sue NZ0028 2026-01-20T14:04:03.495Z 2026-01-28T14:55:17.060Z
9226538 9226538 20260119121546_353mM NZ0028 2026-01-20T14:03:44.032Z 2026-01-28T14:55:06.436Z
9226430 9226430 20260119120010_qD7Qk NZ0028 2026-01-20T14:03:09.488Z 2026-01-28T14:54:59.760Z
9226415 9226415 20260119115829_3wdHE NZ0028 2026-01-20T14:03:04.979Z 2026-01-28T14:54:59.072Z
9226339 9226339 20260119114748_G3jkU NZ0028 2026-01-20T14:02:33.440Z 2026-01-28T14:54:55.580Z
9226165 9226165 20260119112315_Suv0K NZ0028 2026-01-20T14:01:36.397Z 2026-01-28T14:54:46.335Z
9225667 9225667 20260118103740_7OCDy NZ0028 2026-01-19T14:29:43.162Z 2026-01-26T15:04:41.293Z
9225505 9225505 20260118100024_EDpR3 NZ0028 2026-01-19T14:29:11.949Z 2026-01-26T15:04:36.667Z
9225501 9225501 20260118100024_1iqwD NZ0028 2026-01-19T14:29:09.720Z 2026-01-26T15:04:36.585Z
9221570 9221570 20260118160428_1HoTh NZ0028 2026-01-19T14:08:22.068Z 2026-01-27T15:00:32.204Z
9221391 9221391 20260118153227_ci3xZ NZ0028 2026-01-19T14:07:46.944Z 2026-01-27T15:00:12.059Z
9221351 9221351 20260118152640_SBtpN NZ0028 2026-01-19T14:07:37.531Z 2026-01-27T15:00:06.641Z
9221318 9221318 20260118151950_YpqOm NZ0028 2026-01-19T14:07:27.318Z 2026-01-27T15:00:01.265Z
9221269 9221269 20260118151217_2JNgx NZ0028 2026-01-19T14:07:18.686Z 2026-01-27T14:59:59.549Z
9221209 9221209 20260118150359_nXKSH NZ0028 2026-01-19T14:07:05.877Z 2026-01-27T14:59:57.260Z
9221126 9221126 20260118145231_qp1yK NZ0028 2026-01-19T14:06:50.469Z 2026-01-27T14:59:54.596Z
9221000 9221000 20260118144033_ihu32 NZ0028 2026-01-19T14:06:26.210Z 2026-01-27T14:59:50.388Z
9220983 9220983 20260118143419_gUni7 NZ0028 2026-01-19T14:06:22.530Z 2026-01-27T14:59:49.427Z
9220798 9220798 20260118135227_w3U7v NZ0028 2026-01-19T14:05:42.040Z 2026-01-27T14:59:30.597Z
9220765 9220765 20260118134359_1NJBk NZ0028 2026-01-19T14:05:27.875Z 2026-01-27T14:59:27.591Z
9220670 9220670 20260118132622_Hi1kS NZ0028 2026-01-19T14:05:09.748Z 2026-01-27T14:59:24.512Z
9220211 9220211 20260118122009_Xwqnk NZ0028 2026-01-19T14:03:14.697Z 2026-01-27T14:58:54.811Z
9220128 9220128 20260118121033_J2ycA NZ0028 2026-01-19T14:02:52.082Z 2026-01-27T14:58:51.420Z
9219835 9219835 20260118112841_QUoEd NZ0028 2026-01-19T14:01:10.368Z 2026-01-27T14:58:35.694Z
9219761 9219761 20260118111510_3T30k NZ0028 2026-01-19T14:00:36.108Z 2026-01-27T14:58:29.582Z
9219748 9219748 20260118111244_G7K77 NZ0028 2026-01-19T14:00:30.369Z 2026-01-27T14:58:29.001Z
9217101 9217101 20260117143447_AVMTj NZ0028 2026-01-18T14:04:17.419Z 2026-01-26T14:59:56.489Z
9216980 9216980 20260117135010_21jt5 NZ0028 2026-01-18T14:03:41.445Z 2026-01-26T14:59:50.837Z
9197986 9197986 20260112101906_7PvXW NZ0028 2026-01-14T14:34:10.675Z 2026-01-20T15:25:05.557Z
9193484 9193484 20260113152009_XJ3bh NZ0028 2026-01-14T14:01:44.666Z 2026-01-22T15:06:21.210Z
9193018 9193018 20260112132734_rL3Zu NZ0028 2026-01-13T14:29:59.530Z 2026-01-20T15:26:56.422Z
9192831 9192831 20260112130518_CAx4e NZ0028 2026-01-13T14:29:26.960Z 2026-01-20T15:26:36.063Z
9192438 9192438 20260112123500_o1WIq NZ0028 2026-01-13T14:28:24.286Z 2026-01-20T15:26:22.290Z
9192234 9192234 20260112121437_t9Yp0 NZ0028 2026-01-13T14:27:50.791Z 2026-01-20T15:26:15.528Z
9191409 9191409 20260112110444_wFW1m NZ0028 2026-01-13T14:25:17.102Z 2026-01-13T14:30:51.418Z
9186532 9186532 20260112145151_LyslC NZ0028 2026-01-13T14:02:23.288Z 2026-01-21T15:02:42.730Z
9186373 9186373 20260112142804_Jla3i NZ0028 2026-01-13T14:01:39.572Z 2026-01-21T15:02:23.360Z
9185310 9185310 20260111135411_Wf2xQ NZ0028 2026-01-12T14:23:00.852Z 2026-01-19T15:22:05.438Z
9184915 9184915 20260111123636_NaAjU NZ0028 2026-01-12T14:21:59.283Z 2026-01-19T15:21:31.216Z
9183767 9183767 20260111101209_ltmhF NZ0028 2026-01-12T14:18:45.524Z 2026-01-19T15:20:11.065Z
9179236 9179236 20260111150156_4csX7 NZ0028 2026-01-12T14:00:48.563Z 2026-01-20T15:19:57.477Z
9179104 9179104 20260111141631_IjPVp NZ0028 2026-01-12T14:00:16.265Z 2026-01-20T15:19:30.679Z
9179092 9179092 20260111141512_kMoF4 NZ0028 2026-01-12T14:00:11.646Z 2026-01-20T15:19:30.143Z
9165515 9165515 20260107114326_vCMPJ NZ0028 2026-01-08T14:16:44.184Z 2026-01-13T15:04:00.896Z
9165094 9165094 20260107150506_q1nNa NZ0028 2026-01-08T14:15:24.627Z 2026-01-13T15:05:28.705Z
9161844 9161844 20260105152701_37pZG NZ0028 2026-01-07T14:25:05.817Z 2026-01-13T15:16:54.755Z
9161827 9161827 20260105144019_SizL2 NZ0028 2026-01-07T14:24:55.092Z 2026-01-13T15:16:41.337Z
9161719 9161719 20260105104352_fgKef NZ0028 2026-01-07T14:23:29.054Z 2026-01-13T15:15:43.561Z
9161717 9161717 20260105102142_ovg2v NZ0028 2026-01-07T14:23:23.295Z 2026-01-13T15:15:38.964Z
9156579 9156579 20260104115617_qlkey NZ0028 2026-01-06T14:40:03.725Z 2026-01-12T15:12:16.552Z
9156571 9156571 20260104114423_522yW NZ0028 2026-01-06T14:40:02.182Z 2026-01-12T15:12:16.046Z
9156439 9156439 20260104105112_wkoPT NZ0028 2026-01-06T14:39:37.175Z 2026-01-12T15:12:10.517Z
9152847 9152847 20260105140419_pVYzR NZ0028 2026-01-06T14:18:42.659Z 2026-01-13T15:16:33.620Z
9152464 9152464 20260105114626_GJV58 NZ0028 2026-01-06T14:17:18.653Z 2026-01-13T15:15:59.588Z
9133776 9133776 20260103151657_fS2xh NZ0028 2026-01-04T14:22:47.201Z 2026-01-10T15:03:42.405Z
9133729 9133729 20260103145934_Od5Im NZ0028 2026-01-04T14:22:29.881Z 2026-01-10T15:03:36.819Z
9133562 9133562 20260103133505_sYSxa NZ0028 2026-01-04T14:21:21.449Z 2026-01-10T15:03:09.603Z
9133210 9133210 20260103123324_bXdYF NZ0028 2026-01-04T14:20:08.028Z 2026-01-10T15:02:35.271Z
9133155 9133155 20260103122436_h958o NZ0028 2026-01-04T14:19:58.884Z 2026-01-10T15:02:32.761Z
9133117 9133117 20260103121644_52NlL NZ0028 2026-01-04T14:19:50.333Z 2026-01-10T15:02:28.682Z
9118405 9118405 20251231145842_Q8e3a NZ0028 2026-01-01T14:35:19.622Z 2026-01-08T15:14:36.512Z
9118348 9118348 20251231144020_4Kxkr NZ0028 2026-01-01T14:35:10.278Z 2026-01-08T15:14:24.906Z
9118269 9118269 20251231141258_CQT3Y NZ0028 2026-01-01T14:34:50.757Z 2026-01-08T15:14:18.683Z
9117929 9117929 20251231122904_222AI NZ0028 2026-01-01T14:33:35.612Z 2026-01-08T15:13:45.988Z
9081953 9081953 20251229105620_q9uZJ NZ0028 2025-12-30T14:27:16.821Z 2026-01-06T15:19:37.326Z
9070112 9070112 20251226151635_lrJbR NZ0028 2025-12-29T14:47:06.318Z 2026-01-03T15:41:25.023Z
9069916 9069916 20251226145236_9c2fE NZ0028 2025-12-29T14:46:51.871Z 2025-12-30T15:21:42.691Z
9069627 9069627 20251226142503_NVCL4 NZ0028 2025-12-29T14:46:19.667Z 2026-01-03T15:41:05.500Z
9069529 9069529 20251226141353_bJ2YB NZ0028 2025-12-29T14:46:12.991Z 2025-12-30T15:21:36.592Z
9034915 9034915 20251225143105_6Jp4g NZ0028 2025-12-28T14:31:04.057Z 2026-01-02T15:47:13.621Z
9034824 9034824 20251225141301_kH4yI NZ0028 2025-12-28T14:30:53.410Z 2026-01-02T15:47:11.316Z
9034424 9034424 20251225131958_J0QkR NZ0028 2025-12-28T14:29:42.325Z 2025-12-29T14:58:16.901Z
9034082 9034082 20251225123606_BrXqX NZ0028 2025-12-28T14:28:51.421Z 2025-12-29T14:58:10.431Z
9020920 9020920 20251220132207_o6P3w NZ0028 2025-12-27T15:06:35.992Z 2025-12-27T15:06:35.992Z
9020860 9020860 20251220131431_3mbP1 NZ0028 2025-12-27T15:06:34.439Z 2025-12-29T15:25:32.719Z
9019978 9019978 20251220110757_a0fOH NZ0028 2025-12-27T15:05:07.025Z 2025-12-27T15:05:07.025Z
9012243 9012243 20251221152532_2qdxL NZ0028 2025-12-27T14:49:20.848Z 2025-12-27T14:49:20.848Z

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