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

7,905 rows where station_code = "NZ0024" 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
9216124 9216124 20260116115308_5c2FQ NZ0024 2026-01-17T14:27:59.626Z 2026-01-24T15:15:34.493Z
9215934 9215934 20260116112639_JLa12 NZ0024 2026-01-17T14:27:17.934Z 2026-01-24T15:15:18.872Z
9215907 9215907 20260116112355_2vP93 NZ0024 2026-01-17T14:27:13.747Z 2026-01-24T15:15:17.234Z
9215711 9215711 20260116105034_j9hrI NZ0024 2026-01-17T14:26:39.591Z 2026-01-24T15:15:10.609Z
9215683 9215683 20260116104609_2Ph7I NZ0024 2026-01-17T14:26:34.608Z 2026-01-24T15:15:09.275Z
9215624 9215624 20260116103738_oX829 NZ0024 2026-01-17T14:26:19.447Z 2026-01-24T15:15:05.660Z
9215477 9215477 20260116102036_AZcoE NZ0024 2026-01-17T14:25:44.605Z 2026-01-24T15:14:59.439Z
9215447 9215447 20260116101418_x3HYJ NZ0024 2026-01-17T14:25:36.235Z 2026-01-24T15:14:52.046Z
9211006 9211006 20260116144439_K2yIw NZ0024 2026-01-17T14:03:47.631Z 2026-01-25T14:57:14.668Z
9210983 9210983 20260116142440_XhPHQ NZ0024 2026-01-17T14:03:41.644Z 2026-01-25T14:57:13.515Z
9210979 9210979 20260116142200_0H2jZ NZ0024 2026-01-17T14:03:40.934Z 2026-01-25T14:57:13.353Z
9210969 9210969 20260116142043_Zj08D NZ0024 2026-01-17T14:03:37.193Z 2026-01-25T14:57:13.060Z
9210958 9210958 20260116141704_pDxd3 NZ0024 2026-01-17T14:03:35.089Z 2026-01-25T14:57:12.824Z
9210940 9210940 20260116141314_L3Sjx NZ0024 2026-01-17T14:03:29.353Z 2026-01-25T14:57:12.422Z
9210933 9210933 20260116141027_xBnMu NZ0024 2026-01-17T14:03:27.945Z 2026-01-25T14:57:12.310Z
9210922 9210922 20260116140709_M1gAa NZ0024 2026-01-17T14:03:25.038Z 2026-01-25T14:57:11.786Z
9210833 9210833 20260116132837_vLocI NZ0024 2026-01-17T14:03:03.197Z 2026-01-25T14:57:09.102Z
9210819 9210819 20260116132513_HHzg1 NZ0024 2026-01-17T14:02:57.955Z 2026-01-25T14:57:08.473Z
9210789 9210789 20260116131648_t42WF NZ0024 2026-01-17T14:02:51.163Z 2026-01-25T14:56:59.029Z
9193151 9193151 20260112134207_sBLwp NZ0024 2026-01-13T14:30:17.658Z 2026-01-20T15:27:01.294Z
9192930 9192930 20260112131609_83TLe NZ0024 2026-01-13T14:29:41.181Z 2026-01-20T15:26:39.683Z
9192825 9192825 20260112130508_QYoSS NZ0024 2026-01-13T14:29:25.621Z 2026-01-20T15:26:34.347Z
9192295 9192295 20260112122127_sLuhN NZ0024 2026-01-13T14:28:01.029Z 2026-01-20T15:26:17.464Z
9192172 9192172 20260112121056_jBYcA NZ0024 2026-01-13T14:27:40.420Z 2026-01-20T15:26:12.032Z
9192161 9192161 20260112121021_We1mq NZ0024 2026-01-13T14:27:38.785Z 2026-01-20T15:26:01.135Z
9192098 9192098 20260112120449_Qhi8y NZ0024 2026-01-13T14:27:25.944Z 2026-01-20T15:25:59.028Z
9192040 9192040 20260112120316_jFjyy NZ0024 2026-01-13T14:27:16.232Z 2026-01-20T15:25:57.570Z
9192017 9192017 20260112120018_aUQJY NZ0024 2026-01-13T14:27:12.157Z 2026-01-20T15:25:56.663Z
9191814 9191814 20260112114619_ck1ge NZ0024 2026-01-13T14:26:29.890Z 2026-01-20T15:25:47.651Z
9191629 9191629 20260112112700_vzZyb NZ0024 2026-01-13T14:25:56.319Z 2026-01-20T15:25:41.275Z
9191378 9191378 20260112110223_9VGt4 NZ0024 2026-01-13T14:25:12.438Z 2026-01-20T15:25:22.699Z
9191200 9191200 20260112104542_QbWc3 NZ0024 2026-01-13T14:24:41.424Z 2026-01-20T15:25:14.463Z
9190978 9190978 20260112102320_Ff4LV NZ0024 2026-01-13T14:24:05.456Z 2026-01-20T15:25:06.404Z
9190632 9190632 20260112093133_VSq2q NZ0024 2026-01-13T14:22:55.347Z 2026-01-20T15:24:41.369Z
9186816 9186816 20260112154526_vo3gp NZ0024 2026-01-13T14:03:37.903Z 2026-01-21T15:03:01.010Z
9186761 9186761 20260112153253_slK0N NZ0024 2026-01-13T14:03:23.259Z 2026-01-21T15:02:56.806Z
9186701 9186701 20260112152422_0oKuD NZ0024 2026-01-13T14:03:10.905Z 2026-01-21T15:02:54.719Z
9186699 9186699 20260112152421_lQdWV NZ0024 2026-01-13T14:03:10.227Z 2026-01-21T15:02:54.708Z
9186697 9186697 20260112152421_Jh1gw NZ0024 2026-01-13T14:03:09.972Z 2026-01-21T15:02:54.672Z
9186689 9186689 20260112152239_40Wvk NZ0024 2026-01-13T14:03:07.274Z 2026-01-21T15:02:53.427Z
9186402 9186402 20260112143139_As91s NZ0024 2026-01-13T14:01:48.326Z 2026-01-21T15:02:28.314Z
9186356 9186356 20260112142617_9K3cH NZ0024 2026-01-13T14:01:36.615Z 2026-01-21T15:02:23.028Z
9186345 9186345 20260112142330_nWK5w NZ0024 2026-01-13T14:01:31.344Z 2026-01-21T15:02:22.606Z
9186314 9186314 20260112141848_7lseZ NZ0024 2026-01-13T14:01:23.497Z 2026-01-21T15:02:20.755Z
9172930 9172930 20260109123101_X3kSk NZ0024 2026-01-10T14:15:28.895Z 2026-01-17T15:26:08.452Z
9169057 9169057 20260108131131_WmicK NZ0024 2026-01-09T14:12:40.500Z 2026-01-16T15:13:27.293Z
9168962 9168962 20260108125352_LB4CM NZ0024 2026-01-09T14:12:27.715Z 2026-01-16T15:13:23.388Z
9168912 9168912 20260108124153_0z76c NZ0024 2026-01-09T14:12:20.586Z 2026-01-16T15:13:20.263Z
9168850 9168850 20260108122909_ObLM9 NZ0024 2026-01-09T14:12:10.837Z 2026-01-16T15:13:16.390Z
9168842 9168842 20260108122816_ta7YQ NZ0024 2026-01-09T14:12:09.933Z 2026-01-16T15:13:16.169Z
9168811 9168811 20260108122356_GGvwe NZ0024 2026-01-09T14:12:04.186Z 2026-01-16T15:13:09.005Z
9168758 9168758 20260108120931_PRGE3 NZ0024 2026-01-09T14:11:57.319Z 2026-01-16T15:13:02.466Z
9168738 9168738 20260108120825_cTZOb NZ0024 2026-01-09T14:11:55.141Z 2026-01-16T15:13:01.791Z
9168701 9168701 20260108120523_tVxa8 NZ0024 2026-01-09T14:11:47.584Z 2026-01-16T15:12:59.384Z
9168678 9168678 20260108115922_XjEve NZ0024 2026-01-09T14:11:44.660Z 2026-01-16T15:12:57.917Z
9168442 9168442 20260108110049_GcdYc NZ0024 2026-01-09T14:11:06.120Z 2026-01-16T15:12:44.964Z
9168112 9168112 20260108095624_1uZ05 NZ0024 2026-01-09T14:10:20.897Z 2026-01-16T15:12:18.977Z
9168089 9168089 20260108095014_jh63S NZ0024 2026-01-09T14:10:18.004Z 2026-01-16T15:12:18.143Z
9168010 9168010 20260108092337_ujiPz NZ0024 2026-01-09T14:10:05.058Z 2026-01-16T15:12:14.367Z
9168003 9168003 20260108092337_FJ8jj NZ0024 2026-01-09T14:10:04.612Z 2026-01-16T15:12:14.197Z
9164245 9164245 20260107124040_Uy6vy NZ0024 2026-01-08T14:12:28.899Z 2026-01-13T15:04:22.678Z
9163891 9163891 20260107110708_nCjiz NZ0024 2026-01-08T14:10:55.635Z 2026-01-13T15:03:45.590Z
9163857 9163857 20260107105139_qpMdm NZ0024 2026-01-08T14:10:47.731Z 2026-01-13T15:03:43.202Z
9163618 9163618 20260107094242_9271j NZ0024 2026-01-08T14:09:55.504Z 2026-01-13T15:03:30.145Z
9156249 9156249 20260104085915_C23xw NZ0024 2026-01-06T14:39:04.447Z 2026-01-12T15:11:59.602Z
9152152 9152152 20260105094654_mw8TZ NZ0024 2026-01-06T14:16:01.591Z 2026-01-13T15:15:32.934Z
9152119 9152119 20260105093052_v2Tnj NZ0024 2026-01-06T14:15:54.044Z 2026-01-13T15:15:31.361Z
9152082 9152082 20260105092013_yplKv NZ0024 2026-01-06T14:15:44.100Z 2026-01-13T15:15:29.462Z
9107011 9107011 20251229115652_Et2R3 NZ0024 2025-12-31T14:38:49.269Z 2026-01-06T15:19:46.142Z
9096286 9096286 20251227144054_yGIyP NZ0024 2025-12-30T15:07:21.975Z 2026-01-04T15:33:10.144Z
9096269 9096269 20251227143933_nwD0c NZ0024 2025-12-30T15:07:21.255Z 2026-01-04T15:33:09.799Z
9094555 9094555 20251227123358_Ye2x6 NZ0024 2025-12-30T15:05:30.013Z 2026-01-04T15:31:56.658Z
9094549 9094549 20251227123357_tAn48 NZ0024 2025-12-30T15:05:29.719Z 2026-01-04T15:31:54.458Z
9094397 9094397 20251227122104_NwhD2 NZ0024 2025-12-30T15:05:14.004Z 2026-01-04T15:31:40.588Z
9094197 9094197 20251227115243_qUlqH NZ0024 2025-12-30T15:05:04.322Z 2026-01-04T15:31:36.214Z
9093946 9093946 20251227111205_5ZY5e NZ0024 2025-12-30T15:04:33.008Z 2026-01-04T15:31:26.888Z
9093903 9093903 20251227110410_U3t9A NZ0024 2025-12-30T15:04:29.966Z 2026-01-04T15:31:14.866Z
9093823 9093823 20251227104902_rfN9P NZ0024 2025-12-30T15:04:24.930Z 2026-01-04T15:31:12.371Z
9093653 9093653 20251227101947_fHUbC NZ0024 2025-12-30T15:04:13.731Z 2026-01-04T15:31:04.757Z
9090577 9090577 20251228154124_1t1fh NZ0024 2025-12-30T14:50:32.219Z 2026-01-05T15:13:30.267Z
9090560 9090560 20251228153530_gvQ5B NZ0024 2025-12-30T14:50:30.511Z 2025-12-31T14:56:02.776Z
9090440 9090440 20251228151325_IEqdR NZ0024 2025-12-30T14:50:18.400Z 2026-01-05T15:13:11.336Z
9090438 9090438 20251228151257_vxVja NZ0024 2025-12-30T14:50:18.104Z 2026-01-05T15:13:11.209Z
9090432 9090432 20251228151001_hIsnL NZ0024 2025-12-30T14:50:17.744Z 2026-01-05T15:13:10.962Z
9090071 9090071 20251228143345_OVVQx NZ0024 2025-12-30T14:49:38.639Z 2026-01-05T15:13:00.698Z
9090063 9090063 20251228143120_sYnsJ NZ0024 2025-12-30T14:49:37.908Z 2025-12-31T14:55:34.135Z
9089941 9089941 20251228141336_kxdS3 NZ0024 2025-12-30T14:49:20.996Z 2026-01-05T15:12:57.645Z
9089631 9089631 20251228133207_piMhm NZ0024 2025-12-30T14:48:48.616Z 2025-12-31T14:55:12.590Z
9089346 9089346 20251228131106_nYaAn NZ0024 2025-12-30T14:48:18.724Z 2025-12-31T14:55:01.938Z
9088377 9088377 20251228114316_5qobY NZ0024 2025-12-30T14:46:19.304Z 2026-01-05T15:11:49.596Z
9082238 9082238 20251229123120_VLDoq NZ0024 2025-12-30T14:28:28.392Z 2026-01-06T15:20:03.386Z
9082219 9082219 20251229122630_JLdiz NZ0024 2025-12-30T14:28:24.947Z 2026-01-06T15:20:02.507Z
9082174 9082174 20251229121327_mTZCu NZ0024 2025-12-30T14:28:14.452Z 2025-12-31T14:38:56.291Z
9082130 9082130 20251229115652_mrKtZ NZ0024 2025-12-30T14:28:04.633Z 2025-12-30T14:53:49.928Z
9082086 9082086 20251229114448_RnUev NZ0024 2025-12-30T14:27:51.080Z 2025-12-31T14:38:45.539Z
9082059 9082059 20251229113340_72BRb NZ0024 2025-12-30T14:27:45.026Z 2026-01-06T15:19:41.980Z
9082019 9082019 20251229111832_iDClR NZ0024 2025-12-30T14:27:36.371Z 2026-01-06T15:19:40.543Z
9082000 9082000 20251229111145_cGTn9 NZ0024 2025-12-30T14:27:33.107Z 2026-01-06T15:19:39.675Z
9081852 9081852 20251229103004_qNUHw NZ0024 2025-12-30T14:26:51.741Z 2026-01-06T15:19:33.304Z
9081731 9081731 20251229094319_brZkW NZ0024 2025-12-30T14:26:19.121Z 2026-01-06T15:19:27.791Z

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