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

9,276 rows where station_code = "NZ004A" 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
9626923 9626923 20260408152241_BA5kc NZ004A 2026-04-09T12:09:32.189Z 2026-04-09T12:09:32.189Z
9626666 9626666 20260408144237_zjV9x NZ004A 2026-04-09T12:08:54.083Z 2026-04-09T12:08:54.083Z
9626653 9626653 20260408143303_7dBgo NZ004A 2026-04-09T12:08:52.336Z 2026-04-09T12:08:52.336Z
9626567 9626567 20260408141710_3DEFL NZ004A 2026-04-09T12:08:41.997Z 2026-04-09T12:08:41.997Z
9626438 9626438 20260408140357_8Aht2 NZ004A 2026-04-09T12:08:21.453Z 2026-04-09T12:08:21.453Z
9626046 9626046 20260408130002_LBWdW NZ004A 2026-04-09T12:07:23.745Z 2026-04-09T12:07:23.745Z
9625781 9625781 20260408114917_tDM7v NZ004A 2026-04-09T12:06:41.924Z 2026-04-09T12:06:41.924Z
9610375 9610375 20260405173141_m5XWm NZ004A 2026-04-06T12:07:25.493Z 2026-04-09T12:36:46.460Z
9610315 9610315 20260405160521_2TUsT NZ004A 2026-04-06T12:06:58.612Z 2026-04-09T12:36:43.668Z
9610306 9610306 20260405160053_rWwmD NZ004A 2026-04-06T12:06:56.573Z 2026-04-09T12:36:43.461Z
9610241 9610241 20260405151543_JmnMl NZ004A 2026-04-06T12:06:34.184Z 2026-04-09T12:36:41.203Z
9610070 9610070 20260405122642_YGHV3 NZ004A 2026-04-06T12:05:29.959Z 2026-04-09T12:36:20.091Z
9610044 9610044 20260405120601_9BMQB NZ004A 2026-04-06T12:05:23.366Z 2026-04-09T12:36:19.242Z
9610001 9610001 20260405114848_zG3Ze NZ004A 2026-04-06T12:05:13.234Z 2026-04-09T12:36:17.469Z
9609661 9609661 20260405090011_WfpiM NZ004A 2026-04-06T12:03:09.042Z 2026-04-09T12:36:03.960Z
9609601 9609601 20260405083501_FghC2 NZ004A 2026-04-06T12:02:51.877Z 2026-04-09T12:36:02.166Z
9609543 9609543 20260405080105_FclrY NZ004A 2026-04-06T12:02:27.445Z 2026-04-09T12:35:58.397Z
9606290 9606290 20260403165751_YUHdA NZ004A 2026-04-04T12:06:16.290Z 2026-04-09T12:42:13.466Z
9606126 9606126 20260403152402_Y0epD NZ004A 2026-04-04T12:05:31.062Z 2026-04-09T12:42:08.815Z
9606035 9606035 20260403143136_O389c NZ004A 2026-04-04T12:05:02.499Z 2026-04-09T12:42:06.551Z
9605670 9605670 20260403112425_8dCqA NZ004A 2026-04-04T12:03:23.448Z 2026-04-09T12:41:29.038Z
9605602 9605602 20260403105451_VP5rQ NZ004A 2026-04-04T12:03:00.912Z 2026-04-09T12:41:27.456Z
9605583 9605583 20260403105318_TNIdg NZ004A 2026-04-04T12:02:57.547Z 2026-04-09T12:41:25.817Z
9605407 9605407 20260403094935_FO1SW NZ004A 2026-04-04T12:02:08.934Z 2026-04-09T12:41:21.744Z
9605194 9605194 20260403073646_hBoro NZ004A 2026-04-04T12:01:03.966Z 2026-04-09T12:41:16.432Z
9605162 9605162 20260403072154_kMxrY NZ004A 2026-04-04T12:00:57.529Z 2026-04-09T12:41:15.854Z
9604346 9604346 20260402171931_IPUY6 NZ004A 2026-04-03T12:06:58.565Z 2026-04-09T12:44:21.156Z
9604340 9604340 20260402171725_tioF6 NZ004A 2026-04-03T12:06:57.227Z 2026-04-09T12:44:20.997Z
9604310 9604310 20260402170516_rKVJK NZ004A 2026-04-03T12:06:49.683Z 2026-04-09T12:44:20.131Z
9604282 9604282 20260402165412_g2vK2 NZ004A 2026-04-03T12:06:37.734Z 2026-04-09T12:44:19.442Z
9604280 9604280 20260402165402_AhgdJ NZ004A 2026-04-03T12:06:37.323Z 2026-04-09T12:44:19.408Z
9604268 9604268 20260402164835_Zh8vX NZ004A 2026-04-03T12:06:35.181Z 2026-04-09T12:44:19.121Z
9604189 9604189 20260402163034_ugqNG NZ004A 2026-04-03T12:06:19.812Z 2026-04-09T12:44:17.754Z
9603761 9603761 20260402121309_Onnyj NZ004A 2026-04-03T12:04:27.247Z 2026-04-09T12:44:08.581Z
9603606 9603606 20260402111824_zuJhb NZ004A 2026-04-03T12:03:47.185Z 2026-04-09T12:44:04.906Z
9603571 9603571 20260402110413_9qfHO NZ004A 2026-04-03T12:03:40.985Z 2026-04-09T12:44:04.140Z
9603435 9603435 20260402101817_1PacD NZ004A 2026-04-03T12:03:04.422Z 2026-04-09T12:43:43.902Z
9601841 9601841 20260401171405_A7jpC NZ004A 2026-04-02T12:03:54.348Z 2026-04-09T12:45:37.008Z
9601756 9601756 20260401165223_pV3dT NZ004A 2026-04-02T12:03:37.431Z 2026-04-09T12:45:35.679Z
9601690 9601690 20260401162922_FCR5B NZ004A 2026-04-02T12:03:27.752Z 2026-04-09T12:45:33.540Z
9601667 9601667 20260401162759_v52so NZ004A 2026-04-02T12:03:25.318Z 2026-04-09T12:45:33.165Z
9600961 9600961 20260401094952_YoTm7 NZ004A 2026-04-02T12:01:08.069Z 2026-04-09T12:45:21.019Z
9599885 9599885 20260331171820_Rx0iW NZ004A 2026-04-01T12:05:10.385Z 2026-04-09T12:47:59.169Z
9599851 9599851 20260331170737_5t8nl NZ004A 2026-04-01T12:05:03.542Z 2026-04-09T12:47:41.040Z
9599829 9599829 20260331170203_LHxFQ NZ004A 2026-04-01T12:04:59.350Z 2026-04-09T12:47:34.840Z
9599788 9599788 20260331164915_gDRGT NZ004A 2026-04-01T12:04:49.810Z 2026-04-09T12:47:30.524Z
9599560 9599560 20260331154506_D0NW8 NZ004A 2026-04-01T12:04:03.150Z 2026-04-09T12:46:58.037Z
9599519 9599519 20260331152349_MehG5 NZ004A 2026-04-01T12:03:55.389Z 2026-04-09T12:46:54.106Z
9599397 9599397 20260331142435_WrtWn NZ004A 2026-04-01T12:03:26.869Z 2026-04-09T12:46:46.980Z
9599371 9599371 20260331141854_5LUWR NZ004A 2026-04-01T12:03:20.872Z 2026-04-09T12:46:46.729Z
9599290 9599290 20260331134239_TOJvN NZ004A 2026-04-01T12:03:04.275Z 2026-04-09T12:46:45.528Z
9598882 9598882 20260331082307_r7Gcq NZ004A 2026-04-01T12:01:24.728Z 2026-04-09T12:46:37.351Z
9596944 9596944 20260330144137_eFzF9 NZ004A 2026-03-31T12:05:20.336Z 2026-04-08T12:43:28.800Z
9594150 9594150 20260328153139_C2hFs NZ004A 2026-03-30T12:08:28.105Z 2026-04-06T12:39:10.194Z
9591609 9591609 20260328172547_sYEqz NZ004A 2026-03-29T12:04:44.695Z 2026-04-06T12:39:25.302Z
9591603 9591603 20260328172516_ovEpc NZ004A 2026-03-29T12:04:44.524Z 2026-04-06T12:39:25.121Z
9591586 9591586 20260328171604_mHbfq NZ004A 2026-03-29T12:04:39.436Z 2026-04-06T12:39:24.287Z
9591575 9591575 20260328171359_LPGCo NZ004A 2026-03-29T12:04:38.195Z 2026-04-06T12:39:23.737Z
9591529 9591529 20260328170302_Fh5xF NZ004A 2026-03-29T12:04:32.779Z 2026-04-06T12:39:19.790Z
9591505 9591505 20260328165745_leTNp NZ004A 2026-03-29T12:04:31.037Z 2026-04-06T12:39:18.807Z
9591475 9591475 20260328164803_R5X8V NZ004A 2026-03-29T12:04:29.046Z 2026-04-06T12:39:17.454Z
9591461 9591461 20260328164424_94lZe NZ004A 2026-03-29T12:04:27.623Z 2026-04-06T12:39:16.793Z
9591433 9591433 20260328163126_NUzUl NZ004A 2026-03-29T12:04:24.532Z 2026-04-06T12:39:15.343Z
9591376 9591376 20260328160734_xSou2 NZ004A 2026-03-29T12:04:19.466Z 2026-04-06T12:39:12.972Z
9591342 9591342 20260328154551_tDPGV NZ004A 2026-03-29T12:04:16.835Z 2026-04-06T12:39:11.593Z
9591266 9591266 20260328150431_xsTl5 NZ004A 2026-03-29T12:04:07.885Z 2026-04-06T12:39:08.308Z
9591256 9591256 20260328150241_7TVSM NZ004A 2026-03-29T12:04:07.008Z 2026-04-06T12:39:07.973Z
9591181 9591181 20260328140024_dU2ig NZ004A 2026-03-29T12:03:58.256Z 2026-04-06T12:39:04.263Z
9591174 9591174 20260328140002_ILpVE NZ004A 2026-03-29T12:03:57.823Z 2026-04-06T12:39:04.048Z
9591157 9591157 20260328135415_2YwWN NZ004A 2026-03-29T12:03:56.405Z 2026-04-06T12:39:03.370Z
9591142 9591142 20260328134610_F2VvI NZ004A 2026-03-29T12:03:54.922Z 2026-04-06T12:39:02.713Z
9591118 9591118 20260328132750_aiO0E NZ004A 2026-03-29T12:03:51.950Z 2026-04-06T12:39:01.625Z
9590660 9590660 20260328103630_Cam4P NZ004A 2026-03-29T12:03:05.173Z 2026-04-06T12:38:29.503Z
9587932 9587932 20260327165603_urAXv NZ004A 2026-03-28T12:06:45.004Z 2026-04-05T12:35:00.123Z
9587925 9587925 20260327165119_OMuho NZ004A 2026-03-28T12:06:44.055Z 2026-04-05T12:34:59.638Z
9587731 9587731 20260327152248_po30Z NZ004A 2026-03-28T12:06:12.971Z 2026-04-05T12:34:38.831Z
9587721 9587721 20260327152019_lYhN9 NZ004A 2026-03-28T12:06:12.161Z 2026-04-05T12:34:38.610Z
9587685 9587685 20260327150556_uY6zo NZ004A 2026-03-28T12:06:07.683Z 2026-04-05T12:34:37.073Z
9587542 9587542 20260327135307_zxXbB NZ004A 2026-03-28T12:05:46.771Z 2026-04-05T12:34:30.783Z
9587529 9587529 20260327134438_d46cu NZ004A 2026-03-28T12:05:45.014Z 2026-04-05T12:34:30.160Z
9587520 9587520 20260327133947_qfVtt NZ004A 2026-03-28T12:05:43.892Z 2026-04-05T12:34:29.755Z
9587457 9587457 20260327125332_XXjqE NZ004A 2026-03-28T12:05:33.341Z 2026-04-05T12:34:27.110Z
9587450 9587450 20260327125112_pSqBF NZ004A 2026-03-28T12:05:32.639Z 2026-04-05T12:34:26.849Z
9587432 9587432 20260327124345_kT3pe NZ004A 2026-03-28T12:05:30.195Z 2026-04-05T12:34:26.171Z
9587428 9587428 20260327124013_oTQhw NZ004A 2026-03-28T12:05:29.723Z 2026-04-05T12:34:26.024Z
9587284 9587284 20260327115901_hJSBx NZ004A 2026-03-28T12:05:11.336Z 2026-04-05T12:34:11.282Z
9587251 9587251 20260327115358_qJMMj NZ004A 2026-03-28T12:05:08.200Z 2026-04-05T12:34:10.094Z
9587233 9587233 20260327114817_GI2N5 NZ004A 2026-03-28T12:05:04.889Z 2026-04-05T12:34:09.414Z
9587145 9587145 20260327112427_DeCQJ NZ004A 2026-03-28T12:04:53.563Z 2026-04-05T12:34:04.106Z
9587130 9587130 20260327112015_CU0LA NZ004A 2026-03-28T12:04:50.925Z 2026-04-05T12:34:03.336Z
9587042 9587042 20260327105656_e8VeU NZ004A 2026-03-28T12:04:39.921Z 2026-04-05T12:33:59.554Z
9587032 9587032 20260327105422_5M5Rl NZ004A 2026-03-28T12:04:38.902Z 2026-04-05T12:33:59.266Z
9587003 9587003 20260327104331_MwoLo NZ004A 2026-03-28T12:04:32.397Z 2026-04-05T12:33:57.996Z
9587000 9587000 20260327104043_mFw06 NZ004A 2026-03-28T12:04:31.118Z 2026-04-05T12:33:57.869Z
9586750 9586750 20260327092355_CUYwb NZ004A 2026-03-28T12:03:55.547Z 2026-04-05T12:33:46.643Z
9586692 9586692 20260327091113_0zQDg NZ004A 2026-03-28T12:03:46.163Z 2026-04-05T12:33:37.655Z
9583591 9583591 20260326162127_0vC4d NZ004A 2026-03-27T12:09:13.468Z 2026-04-04T12:41:26.691Z
9583571 9583571 20260326161803_Rhtm1 NZ004A 2026-03-27T12:09:09.654Z 2026-04-04T12:41:25.370Z
9574842 9574842 20260323172704_w8k3y NZ004A 2026-03-25T12:19:45.737Z 2026-03-31T12:28:43.080Z
9568165 9568165 20260323161658_isVAQ NZ004A 2026-03-24T12:14:39.211Z 2026-03-31T12:28:23.906Z

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