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

8,224 rows where station_code = "NZ0032" 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
8383264 8383264 20251104082929_WwXdL NZ0032 2025-11-06T14:26:49.336Z 2025-11-12T15:11:20.581Z
8378090 8378090 20251104142905_PY6UV NZ0032 2025-11-06T14:02:49.027Z 2025-11-13T15:13:13.965Z
8378082 8378082 20251104142809_tkxZL NZ0032 2025-11-06T14:02:47.316Z 2025-11-13T15:13:13.693Z
8377193 8377193 20251103124649_gPD5t NZ0032 2025-11-05T14:38:11.933Z 2025-11-11T15:09:30.783Z
8376991 8376991 20251103121428_Z6QDI NZ0032 2025-11-05T14:37:40.491Z 2025-11-11T15:09:18.506Z
8368036 8368036 20251103134057_xE2bJ NZ0032 2025-11-05T14:01:09.550Z 2025-11-12T15:08:30.336Z
8367996 8367996 20251103133335_80CVx NZ0032 2025-11-05T14:01:00.051Z 2025-11-12T15:08:29.862Z
8367992 8367992 20251103133255_RQAhL NZ0032 2025-11-05T14:00:59.344Z 2025-11-12T15:08:29.801Z
8367945 8367945 20251103132638_bEyt7 NZ0032 2025-11-05T14:00:49.239Z 2025-11-12T15:08:28.967Z
8367875 8367875 20251103131436_atmmC NZ0032 2025-11-05T14:00:33.514Z 2025-11-12T15:08:28.013Z
8367869 8367869 20251103131325_4QbFD NZ0032 2025-11-05T14:00:32.350Z 2025-11-12T15:08:27.931Z
8367858 8367858 20251103131110_OBvTn NZ0032 2025-11-05T14:00:30.417Z 2025-11-12T15:08:27.803Z
8367828 8367828 20251103130651_qcERu NZ0032 2025-11-05T14:00:26.480Z 2025-11-12T15:08:27.586Z
8367498 8367498 20251102123315_QGc3I NZ0032 2025-11-04T14:37:24.070Z 2025-11-10T15:10:47.171Z
8367115 8367115 20251102115705_FRea3 NZ0032 2025-11-04T14:36:36.622Z 2025-11-10T15:10:39.505Z
8360794 8360794 20251102155243_wz4Q0 NZ0032 2025-11-04T14:05:52.469Z 2025-11-11T15:02:36.683Z
8360215 8360215 20251102150259_KHUnf NZ0032 2025-11-04T14:03:46.798Z 2025-11-11T15:02:29.168Z
8360187 8360187 20251102150025_9aZ6w NZ0032 2025-11-04T14:03:42.936Z 2025-11-11T15:02:28.801Z
8360177 8360177 20251102145932_tV9MZ NZ0032 2025-11-04T14:03:41.618Z 2025-11-11T15:02:28.632Z
8360107 8360107 20251102145224_Jmg1m NZ0032 2025-11-04T14:03:24.906Z 2025-11-11T15:02:27.759Z
8359976 8359976 20251102143632_S7Air NZ0032 2025-11-04T14:02:59.649Z 2025-11-11T15:02:25.927Z
8359890 8359890 20251102142223_Yp8Rv NZ0032 2025-11-04T14:02:31.847Z 2025-11-11T15:02:24.659Z
8359810 8359810 20251102141319_zRU92 NZ0032 2025-11-04T14:02:14.118Z 2025-11-11T15:02:23.223Z
8359552 8359552 20251102132815_hhT8n NZ0032 2025-11-04T14:01:13.967Z 2025-11-11T15:02:19.823Z
8359543 8359543 20251102132643_Vbi0G NZ0032 2025-11-04T14:01:12.140Z 2025-11-11T15:02:19.694Z
8359439 8359439 20251102130631_Zl1uG NZ0032 2025-11-04T14:00:43.044Z 2025-11-11T15:02:17.976Z
8348351 8348351 20251101150608_14Ny8 NZ0032 2025-11-03T14:02:36.034Z 2025-11-10T15:03:06.793Z
8347907 8347907 20251101133500_aQWT5 NZ0032 2025-11-03T14:00:34.791Z 2025-11-10T15:02:14.563Z
8329747 8329747 20251031161244_60q7h NZ0032 2025-11-02T14:03:49.917Z 2025-11-09T14:58:13.577Z
8329586 8329586 20251031154418_9q3o1 NZ0032 2025-11-02T14:03:22.258Z 2025-11-09T14:58:11.770Z
8329461 8329461 20251031152947_iSk9d NZ0032 2025-11-02T14:02:54.853Z 2025-11-09T14:58:10.297Z
8329396 8329396 20251031152014_6ydBS NZ0032 2025-11-02T14:02:46.384Z 2025-11-09T14:58:09.605Z
8328295 8328295 20251030124231_re1bi NZ0032 2025-11-01T12:38:33.572Z 2025-11-07T15:19:13.415Z
8328216 8328216 20251030123324_iOG36 NZ0032 2025-11-01T12:38:28.428Z 2025-11-07T15:19:12.320Z
8327890 8327890 20251030120102_RQFqQ NZ0032 2025-11-01T12:38:13.855Z 2025-11-07T15:19:07.924Z
8327829 8327829 20251030115502_cjUC3 NZ0032 2025-11-01T12:38:08.779Z 2025-11-07T15:19:07.229Z
8327485 8327485 20251030111757_ZixIF NZ0032 2025-11-01T12:37:25.191Z 2025-11-07T15:19:00.659Z
8327027 8327027 20251030103421_zzgTl NZ0032 2025-11-01T12:36:35.101Z 2025-11-07T15:18:42.513Z
8327015 8327015 20251030103253_PsxGF NZ0032 2025-11-01T12:36:34.612Z 2025-11-07T15:18:41.967Z
8326660 8326660 20251030100046_k2gTY NZ0032 2025-11-01T12:36:04.124Z 2025-11-07T15:18:15.587Z
8326459 8326459 20251030094342_8Q9lm NZ0032 2025-11-01T12:35:33.754Z 2025-11-07T15:18:03.420Z
8326386 8326386 20251030093756_7d4ym NZ0032 2025-11-01T12:35:29.547Z 2025-11-07T15:17:58.859Z
8326382 8326382 20251030093755_BcOeW NZ0032 2025-11-01T12:35:29.400Z 2025-11-07T15:17:57.759Z
8325752 8325752 20251030081839_fz2tP NZ0032 2025-11-01T12:34:24.645Z 2025-11-07T15:17:28.944Z
8325684 8325684 20251030081300_oXq0t NZ0032 2025-11-01T12:34:21.332Z 2025-11-07T15:17:28.126Z
8316184 8316184 20251030160156_QSAHq NZ0032 2025-11-01T12:04:41.115Z 2025-11-08T15:10:23.614Z
8316086 8316086 20251030154950_Lnb8r NZ0032 2025-11-01T12:04:20.791Z 2025-11-08T15:10:19.173Z
8316072 8316072 20251030154904_Hi1Fj NZ0032 2025-11-01T12:04:19.269Z 2025-11-08T15:10:15.357Z
8316062 8316062 20251030154619_z9d1D NZ0032 2025-11-01T12:04:17.962Z 2025-11-08T15:10:14.415Z
8316060 8316060 20251030154600_ja32m NZ0032 2025-11-01T12:04:17.638Z 2025-11-08T15:10:14.379Z
8316050 8316050 20251030154240_HCuuS NZ0032 2025-11-01T12:04:15.752Z 2025-11-08T15:10:10.575Z
8316029 8316029 20251030153940_PdrqB NZ0032 2025-11-01T12:04:12.042Z 2025-11-08T15:10:06.620Z
8315962 8315962 20251030153520_QDfur NZ0032 2025-11-01T12:03:51.644Z 2025-11-08T15:10:04.266Z
8315893 8315893 20251030152720_RvGef NZ0032 2025-11-01T12:03:38.141Z 2025-11-08T15:10:00.304Z
8315879 8315879 20251030152555_dEPDx NZ0032 2025-11-01T12:03:36.683Z 2025-11-08T15:09:59.794Z
8315829 8315829 20251030152139_euas6 NZ0032 2025-11-01T12:03:30.379Z 2025-11-08T15:09:58.309Z
8315803 8315803 20251030151812_dj73D NZ0032 2025-11-01T12:03:26.184Z 2025-11-08T15:09:57.183Z
8315743 8315743 20251030150907_17fPO NZ0032 2025-11-01T12:03:18.140Z 2025-11-08T15:09:55.888Z
8315707 8315707 20251030150600_gJzB1 NZ0032 2025-11-01T12:03:03.569Z 2025-11-08T15:09:54.786Z
8315574 8315574 20251030145235_Sj8jd NZ0032 2025-11-01T12:02:38.703Z 2025-11-08T15:09:51.341Z
8315558 8315558 20251030144949_pNIe7 NZ0032 2025-11-01T12:02:36.693Z 2025-11-08T15:09:50.505Z
8315485 8315485 20251030143958_skc5Y NZ0032 2025-11-01T12:02:21.575Z 2025-11-08T15:09:48.571Z
8315225 8315225 20251030135839_swsoN NZ0032 2025-11-01T12:01:21.333Z 2025-11-08T15:09:27.903Z
8315067 8315067 20251030132634_1Ld24 NZ0032 2025-11-01T12:00:50.130Z 2025-11-08T15:09:08.521Z
8315061 8315061 20251030132457_4yVh4 NZ0032 2025-11-01T12:00:49.062Z 2025-11-08T15:09:08.161Z
8315018 8315018 20251030131444_kclT4 NZ0032 2025-11-01T12:00:41.288Z 2025-11-08T15:09:05.291Z
8314988 8314988 20251030131039_eFoSA NZ0032 2025-11-01T12:00:35.007Z 2025-11-08T15:09:02.758Z
8314928 8314928 20251030125602_mI4cF NZ0032 2025-11-01T12:00:18.452Z 2025-11-08T15:08:57.964Z
8309726 8309726 20251029124439_hcqSJ NZ0032 2025-10-31T12:31:40.081Z 2025-11-06T15:16:54.013Z
8309712 8309712 20251029124244_BraTK NZ0032 2025-10-31T12:31:39.391Z 2025-11-06T15:16:52.933Z
8309540 8309540 20251029122528_LsioH NZ0032 2025-10-31T12:31:28.227Z 2025-11-06T15:16:44.115Z
8308533 8308533 20251029111105_LEgyT NZ0032 2025-10-31T12:29:45.296Z 2025-11-06T15:16:12.130Z
8308499 8308499 20251029110753_p1Ehn NZ0032 2025-10-31T12:29:35.341Z 2025-11-06T15:16:08.622Z
8306479 8306479 20251029080940_vd2QY NZ0032 2025-10-31T12:25:12.554Z 2025-11-06T15:15:10.287Z
8303026 8303026 20251029161643_PRaab NZ0032 2025-10-31T12:05:26.786Z 2025-11-07T15:09:23.910Z
8303008 8303008 20251029161254_GnIcY NZ0032 2025-10-31T12:05:24.528Z 2025-11-07T15:09:23.579Z
8302981 8302981 20251029160835_Jv1l9 NZ0032 2025-10-31T12:05:21.128Z 2025-11-07T15:09:23.219Z
8302969 8302969 20251029160735_FdDib NZ0032 2025-10-31T12:05:19.744Z 2025-11-07T15:09:23.071Z
8302822 8302822 20251029155619_JBhKj NZ0032 2025-10-31T12:04:58.252Z 2025-11-07T15:09:21.640Z
8302800 8302800 20251029155241_RYpmU NZ0032 2025-10-31T12:04:55.092Z 2025-11-07T15:09:21.267Z
8302743 8302743 20251029154552_krTje NZ0032 2025-10-31T12:04:47.766Z 2025-11-07T15:09:20.642Z
8302627 8302627 20251029153411_MZ7n0 NZ0032 2025-10-31T12:04:23.380Z 2025-11-07T15:09:19.062Z
8302452 8302452 20251029151431_19RmB NZ0032 2025-10-31T12:03:59.123Z 2025-11-07T15:09:16.728Z
8302372 8302372 20251029150646_p7Typ NZ0032 2025-10-31T12:03:42.818Z 2025-11-07T15:09:15.721Z
8302336 8302336 20251029150511_oNRBq NZ0032 2025-10-31T12:03:39.984Z 2025-11-07T15:09:15.355Z
8302323 8302323 20251029150426_a0jp4 NZ0032 2025-10-31T12:03:37.123Z 2025-11-07T15:09:15.043Z
8302249 8302249 20251029145820_ymVR5 NZ0032 2025-10-31T12:03:22.130Z 2025-11-07T15:09:13.809Z
8302233 8302233 20251029145644_KoEc0 NZ0032 2025-10-31T12:03:19.111Z 2025-11-07T15:09:13.422Z
8302171 8302171 20251029145133_Act6P NZ0032 2025-10-31T12:03:11.527Z 2025-11-07T15:09:12.749Z
8301829 8301829 20251029142516_9RQhk NZ0032 2025-10-31T12:02:18.679Z 2025-11-07T15:09:08.566Z
8301457 8301457 20251029135126_yFata NZ0032 2025-10-31T12:01:24.382Z 2025-11-07T15:08:44.761Z
8301438 8301438 20251029135047_lnb8i NZ0032 2025-10-31T12:01:22.162Z 2025-11-07T15:08:44.342Z
8301359 8301359 20251029134351_zmpRe NZ0032 2025-10-31T12:01:12.605Z 2025-11-07T15:08:41.856Z
8301332 8301332 20251029134051_vNyMF NZ0032 2025-10-31T12:01:10.105Z 2025-11-07T15:08:38.272Z
8301252 8301252 20251029133156_Jzr2i NZ0032 2025-10-31T12:00:54.279Z 2025-11-07T15:08:34.817Z
8301228 8301228 20251029132945_ngRtP NZ0032 2025-10-31T12:00:50.758Z 2025-11-07T15:08:32.470Z
8301164 8301164 20251029132125_9f67X NZ0032 2025-10-31T12:00:42.885Z 2025-11-07T15:08:23.645Z
8300999 8300999 20251029125317_X33r2 NZ0032 2025-10-31T12:00:15.051Z 2025-11-07T15:08:02.512Z
8294445 8294445 20251028103551_cVqm0 NZ0032 2025-10-30T12:41:02.533Z 2025-11-05T15:24:30.317Z
8294213 8294213 20251028102130_Ho32i NZ0032 2025-10-30T12:40:53.995Z 2025-11-05T15:24:21.612Z

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