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

4,491 rows where station_code = "NZ005A" 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
9270483 9270483 20260128155510_MXn6P NZ005A 2026-01-29T14:12:24.374Z 2026-01-29T14:12:24.374Z
9270433 9270433 20260128154906_ro3PW NZ005A 2026-01-29T14:12:15.235Z 2026-01-29T14:12:15.235Z
9270380 9270380 20260128154131_rlj7z NZ005A 2026-01-29T14:11:59.680Z 2026-01-29T14:11:59.680Z
9270288 9270288 20260128152704_DYn2z NZ005A 2026-01-29T14:11:38.504Z 2026-01-29T14:11:38.504Z
9270060 9270060 20260128145120_CcYvo NZ005A 2026-01-29T14:10:45.128Z 2026-01-29T14:10:45.128Z
9269980 9269980 20260128143938_xnXY8 NZ005A 2026-01-29T14:10:25.735Z 2026-01-29T14:10:25.735Z
9269908 9269908 20260128143056_p3IzA NZ005A 2026-01-29T14:10:11.134Z 2026-01-29T14:10:11.134Z
9269877 9269877 20260128142646_lcDL8 NZ005A 2026-01-29T14:10:01.575Z 2026-01-29T14:10:01.575Z
9269855 9269855 20260128142513_pM1Rj NZ005A 2026-01-29T14:09:53.441Z 2026-01-29T14:09:53.441Z
9269839 9269839 20260128142148_A834D NZ005A 2026-01-29T14:09:50.993Z 2026-01-29T14:09:50.993Z
9269834 9269834 20260128142116_zcVOx NZ005A 2026-01-29T14:09:48.490Z 2026-01-29T14:09:48.490Z
9269804 9269804 20260128141617_Zbcxz NZ005A 2026-01-29T14:09:42.252Z 2026-01-29T14:09:42.252Z
9269794 9269794 20260128141514_7kUj2 NZ005A 2026-01-29T14:09:39.772Z 2026-01-29T14:09:39.772Z
9269787 9269787 20260128141218_OEj00 NZ005A 2026-01-29T14:09:37.508Z 2026-01-29T14:09:37.508Z
9269785 9269785 20260128141218_4j2jP NZ005A 2026-01-29T14:09:37.054Z 2026-01-29T14:09:37.054Z
9269723 9269723 20260128140001_zsV6V NZ005A 2026-01-29T14:09:17.450Z 2026-01-29T14:09:17.450Z
9269719 9269719 20260128135930_r2KA7 NZ005A 2026-01-29T14:09:12.607Z 2026-01-29T14:09:12.607Z
9269716 9269716 20260128135858_hoNMh NZ005A 2026-01-29T14:09:11.326Z 2026-01-29T14:09:11.326Z
9269665 9269665 20260128135217_SfQeS NZ005A 2026-01-29T14:09:00.801Z 2026-01-29T14:09:00.801Z
9269598 9269598 20260128134313_Z2aSQ NZ005A 2026-01-29T14:08:40.852Z 2026-01-29T14:08:40.852Z
9269504 9269504 20260128132820_eNEjZ NZ005A 2026-01-29T14:08:18.958Z 2026-01-29T14:08:18.958Z
9269471 9269471 20260128132259_3fRsB NZ005A 2026-01-29T14:08:07.644Z 2026-01-29T14:08:07.644Z
9269468 9269468 20260128132146_ULq7K NZ005A 2026-01-29T14:08:07.051Z 2026-01-29T14:08:07.051Z
9269454 9269454 20260128131929_igD8S NZ005A 2026-01-29T14:08:02.451Z 2026-01-29T14:08:02.451Z
9269438 9269438 20260128131834_dSz7j NZ005A 2026-01-29T14:07:59.094Z 2026-01-29T14:07:59.094Z
9269325 9269325 20260128130216_Fn1s4 NZ005A 2026-01-29T14:07:28.166Z 2026-01-29T14:07:28.166Z
9269314 9269314 20260128130214_hRGts NZ005A 2026-01-29T14:07:27.157Z 2026-01-29T14:07:27.157Z
9269255 9269255 20260128125055_xm0Wx NZ005A 2026-01-29T14:07:06.899Z 2026-01-29T14:07:06.899Z
9269158 9269158 20260128123849_2RJ8Q NZ005A 2026-01-29T14:06:45.645Z 2026-01-29T14:06:45.645Z
9269146 9269146 20260128123800_ejW3Z NZ005A 2026-01-29T14:06:41.589Z 2026-01-29T14:06:41.589Z
9269040 9269040 20260128120825_wefbj NZ005A 2026-01-29T14:06:07.842Z 2026-01-29T14:06:07.842Z
9269020 9269020 20260128120155_GoWU7 NZ005A 2026-01-29T14:06:02.687Z 2026-01-29T14:06:02.687Z
9268946 9268946 20260128114555_KtM0i NZ005A 2026-01-29T14:05:39.649Z 2026-01-29T14:05:39.649Z
9268936 9268936 20260128114537_9D5ZY NZ005A 2026-01-29T14:05:37.952Z 2026-01-29T14:05:37.952Z
9268925 9268925 20260128114449_pvHcS NZ005A 2026-01-29T14:05:34.507Z 2026-01-29T14:05:34.507Z
9268866 9268866 20260128113539_0FVko NZ005A 2026-01-29T14:05:14.548Z 2026-01-29T14:05:14.548Z
9268855 9268855 20260128113509_2SkJu NZ005A 2026-01-29T14:05:12.637Z 2026-01-29T14:05:12.637Z
9268746 9268746 20260128111357_o2D7o NZ005A 2026-01-29T14:04:42.095Z 2026-01-29T14:04:42.095Z
9268687 9268687 20260128110153_eQQt2 NZ005A 2026-01-29T14:04:20.894Z 2026-01-29T14:04:20.894Z
9268631 9268631 20260128105623_5AnKe NZ005A 2026-01-29T14:04:06.545Z 2026-01-29T14:04:06.545Z
9268577 9268577 20260128104749_TG8Q6 NZ005A 2026-01-29T14:03:51.297Z 2026-01-29T14:03:51.297Z
9268556 9268556 20260128104611_nbfte NZ005A 2026-01-29T14:03:46.018Z 2026-01-29T14:03:46.018Z
9268554 9268554 20260128104610_sbXVJ NZ005A 2026-01-29T14:03:45.287Z 2026-01-29T14:03:45.287Z
9268428 9268428 20260128101602_UZN3m NZ005A 2026-01-29T14:02:56.228Z 2026-01-29T14:02:56.228Z
9268406 9268406 20260128100702_i9J07 NZ005A 2026-01-29T14:02:50.660Z 2026-01-29T14:02:50.660Z
9268290 9268290 20260128094449_zDRlN NZ005A 2026-01-29T14:02:13.127Z 2026-01-29T14:02:13.127Z
9268236 9268236 20260128092805_QgT11 NZ005A 2026-01-29T14:01:54.439Z 2026-01-29T14:01:54.439Z
9268107 9268107 20260128085003_luQXe NZ005A 2026-01-29T14:01:07.779Z 2026-01-29T14:01:07.779Z
9265964 9265964 20260127162238_kcmMo NZ005A 2026-01-28T14:11:52.537Z 2026-01-29T14:30:24.800Z
9265891 9265891 20260127161107_qq6nU NZ005A 2026-01-28T14:11:41.530Z 2026-01-29T14:30:24.709Z
9261621 9261621 20260126123314_Xda71 NZ005A 2026-01-27T14:04:45.323Z 2026-01-29T14:32:44.343Z
9261158 9261158 20260126100421_hBBXw NZ005A 2026-01-27T14:02:17.105Z 2026-01-29T14:32:00.281Z
9260961 9260961 20260126090158_K2ROp NZ005A 2026-01-27T14:01:09.321Z 2026-01-29T14:31:16.222Z
9257837 9257837 20260125161307_ZHHfr NZ005A 2026-01-26T14:08:04.977Z 2026-01-29T14:37:44.052Z
9257835 9257835 20260125160735_HUvGK NZ005A 2026-01-26T14:08:04.205Z 2026-01-29T14:37:43.920Z
9257624 9257624 20260125150321_tQ2R4 NZ005A 2026-01-26T14:06:48.308Z 2026-01-29T14:37:30.982Z
9257581 9257581 20260125144438_LzLQ4 NZ005A 2026-01-26T14:06:30.225Z 2026-01-29T14:37:28.850Z
9257566 9257566 20260125144111_8EOel NZ005A 2026-01-26T14:06:25.790Z 2026-01-29T14:37:27.995Z
9257502 9257502 20260125140910_XUsod NZ005A 2026-01-26T14:06:01.319Z 2026-01-29T14:37:23.552Z
9257332 9257332 20260125124915_fLWMl NZ005A 2026-01-26T14:04:46.379Z 2026-01-29T14:37:05.866Z
9257310 9257310 20260125124455_7gKAd NZ005A 2026-01-26T14:04:40.174Z 2026-01-29T14:37:04.785Z
9257301 9257301 20260125124305_z13KC NZ005A 2026-01-26T14:04:38.024Z 2026-01-29T14:37:04.348Z
9257098 9257098 20260125115255_PnGU0 NZ005A 2026-01-26T14:03:39.878Z 2026-01-29T14:36:46.532Z
9257019 9257019 20260125113545_ZixjN NZ005A 2026-01-26T14:03:11.337Z 2026-01-29T14:36:41.689Z
9256994 9256994 20260125113245_Dqz3U NZ005A 2026-01-26T14:03:08.137Z 2026-01-29T14:36:40.716Z
9253958 9253958 20260124161332_Yp8bw NZ005A 2026-01-25T14:05:09.688Z 2026-01-29T14:41:54.294Z
9253690 9253690 20260124134745_4cWvu NZ005A 2026-01-25T14:03:58.370Z 2026-01-29T14:41:17.189Z
9252972 9252972 20260123084358_exgLk NZ005A 2026-01-24T14:18:03.254Z 2026-01-29T14:53:45.368Z
9252939 9252939 20260123082924_6dtTA NZ005A 2026-01-24T14:17:56.177Z 2026-01-29T14:53:43.274Z
9250241 9250241 20260123112321_D5BOD NZ005A 2026-01-24T14:01:54.309Z 2026-01-29T14:45:07.649Z
9250070 9250070 20260123100338_KeDHO NZ005A 2026-01-24T14:00:59.124Z 2026-01-29T14:44:57.030Z
9215581 9215581 20260116103238_Kkblr NZ005A 2026-01-17T14:26:11.619Z 2026-01-24T15:15:04.061Z
9215356 9215356 20260116095745_Ht1EX NZ005A 2026-01-17T14:25:15.505Z 2026-01-24T15:14:42.373Z
9215248 9215248 20260116094155_jNBh3 NZ005A 2026-01-17T14:24:56.260Z 2026-01-24T15:14:36.294Z
9215139 9215139 20260116092448_f7kT4 NZ005A 2026-01-17T14:24:34.487Z 2026-01-24T15:14:32.185Z
9215113 9215113 20260116091850_O0Sgh NZ005A 2026-01-17T14:24:27.086Z 2026-01-24T15:14:30.741Z
9215008 9215008 20260116085846_vLSJG NZ005A 2026-01-17T14:24:04.477Z 2026-01-24T15:14:26.580Z
9211038 9211038 20260116150941_MHxXw NZ005A 2026-01-17T14:03:59.332Z 2026-01-25T14:57:16.846Z
9210800 9210800 20260116131737_eiWJ3 NZ005A 2026-01-17T14:02:53.312Z 2026-01-25T14:57:03.131Z
9210777 9210777 20260116131554_RMyON NZ005A 2026-01-17T14:02:45.960Z 2026-01-25T14:56:55.585Z
9210678 9210678 20260116125513_EWvVn NZ005A 2026-01-17T14:02:18.340Z 2026-01-25T14:56:52.292Z
9210428 9210428 20260116121932_gwNnD NZ005A 2026-01-17T14:00:55.224Z 2026-01-25T14:56:43.052Z
9210421 9210421 20260116121836_oN3Ty NZ005A 2026-01-17T14:00:53.159Z 2026-01-25T14:56:42.719Z
9210405 9210405 20260116121736_42w3y NZ005A 2026-01-17T14:00:43.129Z 2026-01-25T14:56:42.082Z
9210381 9210381 20260116121214_Tnl16 NZ005A 2026-01-17T14:00:37.441Z 2026-01-25T14:56:41.374Z
9210370 9210370 20260116121031_8g8LW NZ005A 2026-01-17T14:00:32.835Z 2026-01-25T14:56:41.083Z
9210353 9210353 20260116120729_fi76W NZ005A 2026-01-17T14:00:26.238Z 2026-01-25T14:56:40.616Z
9193091 9193091 20260112133603_2D2cY NZ005A 2026-01-13T14:30:08.756Z 2026-01-20T15:26:59.105Z
9193072 9193072 20260112133347_ngRIv NZ005A 2026-01-13T14:30:06.147Z 2026-01-20T15:26:58.176Z
9193068 9193068 20260112133317_VxCye NZ005A 2026-01-13T14:30:05.716Z 2026-01-20T15:26:58.088Z
9193010 9193010 20260112132644_mTgHd NZ005A 2026-01-13T14:29:58.415Z 2026-01-20T15:26:56.088Z
9192995 9192995 20260112132426_8ezkS NZ005A 2026-01-13T14:29:55.424Z 2026-01-20T15:26:53.928Z
9190925 9190925 20260112101555_yaI5D NZ005A 2026-01-13T14:23:56.424Z 2026-01-20T15:25:03.969Z
9190682 9190682 20260112093856_bXpjo NZ005A 2026-01-13T14:23:04.045Z 2026-01-20T15:24:43.289Z
9190481 9190481 20260112091114_QvvC7 NZ005A 2026-01-13T14:22:23.083Z 2026-01-20T15:24:34.940Z
9190358 9190358 20260112085251_MyBLg NZ005A 2026-01-13T14:21:55.785Z 2026-01-20T15:24:19.234Z
9187191 9187191 20260111153703_dLQM3 NZ005A 2026-01-13T14:06:03.939Z 2026-01-20T15:20:06.890Z
9186308 9186308 20260112141325_9WUWb NZ005A 2026-01-13T14:01:20.084Z 2026-01-21T15:02:19.420Z
9185957 9185957 20260111140122_8NZjP NZ005A 2026-01-12T14:26:23.510Z 2026-01-19T15:22:08.147Z
9185850 9185850 20260111132548_aOfDb NZ005A 2026-01-12T14:26:07.830Z 2026-01-19T15:21:57.160Z

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