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

6,096 rows where station_code = "NZ000T" 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
9453885 9453885 20260310145535_0AJqM NZ000T 2026-03-11T12:08:23.364Z 2026-03-18T12:39:41.351Z
9453802 9453802 20260310143936_Aeg10 NZ000T 2026-03-11T12:08:13.020Z 2026-03-18T12:39:40.606Z
9453783 9453783 20260310143550_J0D3I NZ000T 2026-03-11T12:08:11.207Z 2026-03-18T12:39:40.382Z
9453740 9453740 20260310142907_X1eAL NZ000T 2026-03-11T12:08:06.710Z 2026-03-18T12:39:39.940Z
9453636 9453636 20260310141306_JsQjn NZ000T 2026-03-11T12:07:57.231Z 2026-03-18T12:39:38.894Z
9453373 9453373 20260310133325_yQSNc NZ000T 2026-03-11T12:07:28.183Z 2026-03-18T12:39:25.343Z
9453347 9453347 20260310132759_lCsLc NZ000T 2026-03-11T12:07:25.526Z 2026-03-18T12:39:22.925Z
9453291 9453291 20260310131546_BZ8TM NZ000T 2026-03-11T12:07:18.051Z 2026-03-18T12:39:22.436Z
9453280 9453280 20260310131532_rP2rn NZ000T 2026-03-11T12:07:16.749Z 2026-03-18T12:39:22.198Z
9453273 9453273 20260310131526_VA9x4 NZ000T 2026-03-11T12:07:16.087Z 2026-03-18T12:39:22.142Z
9452667 9452667 20260310105428_Axcev NZ000T 2026-03-11T12:05:54.729Z 2026-03-18T12:39:14.807Z
9452642 9452642 20260310104549_ioKI5 NZ000T 2026-03-11T12:05:49.021Z 2026-03-18T12:39:14.488Z
9452620 9452620 20260310104350_Kqmoj NZ000T 2026-03-11T12:05:47.469Z 2026-03-18T12:39:14.365Z
9452203 9452203 20260310084357_MOwNf NZ000T 2026-03-11T12:04:58.130Z 2026-03-18T12:39:10.743Z
9452193 9452193 20260310083907_31aUb NZ000T 2026-03-11T12:04:55.269Z 2026-03-18T12:39:10.649Z
9452159 9452159 20260310082403_Qm7Kp NZ000T 2026-03-11T12:04:50.695Z 2026-03-18T12:39:10.127Z
9450000 9450000 20260309172420_JHN2I NZ000T 2026-03-10T12:14:28.365Z 2026-03-17T12:42:33.241Z
9449993 9449993 20260309171935_NO84P NZ000T 2026-03-10T12:14:26.994Z 2026-03-17T12:42:33.201Z
9449959 9449959 20260309171219_OXpwM NZ000T 2026-03-10T12:14:23.043Z 2026-03-17T12:42:32.826Z
9449954 9449954 20260309171044_esUiv NZ000T 2026-03-10T12:14:22.180Z 2026-03-17T12:42:32.761Z
9449850 9449850 20260309164532_203kf NZ000T 2026-03-10T12:14:05.629Z 2026-03-17T12:42:31.998Z
9449823 9449823 20260309164408_qk6OP NZ000T 2026-03-10T12:14:02.113Z 2026-03-17T12:42:31.836Z
9449786 9449786 20260309163606_EH6TC NZ000T 2026-03-10T12:13:55.429Z 2026-03-17T12:42:31.590Z
9449755 9449755 20260309163031_lJ8Km NZ000T 2026-03-10T12:13:48.134Z 2026-03-17T12:42:31.241Z
9449735 9449735 20260309162517_JDk90 NZ000T 2026-03-10T12:13:45.350Z 2026-03-17T12:42:31.029Z
9449693 9449693 20260309161748_PRLpM NZ000T 2026-03-10T12:13:40.732Z 2026-03-17T12:42:30.743Z
9449659 9449659 20260309160857_SnW36 NZ000T 2026-03-10T12:13:36.143Z 2026-03-17T12:42:30.495Z
9449645 9449645 20260309160802_HLQNx NZ000T 2026-03-10T12:13:34.889Z 2026-03-17T12:42:30.450Z
9449437 9449437 20260309151112_ShTUd NZ000T 2026-03-10T12:12:57.888Z 2026-03-17T12:42:28.766Z
9449425 9449425 20260309150453_me2u4 NZ000T 2026-03-10T12:12:55.630Z 2026-03-17T12:42:28.672Z
9449356 9449356 20260309143733_w2B5m NZ000T 2026-03-10T12:12:39.521Z 2026-03-17T12:42:27.957Z
9449335 9449335 20260309142956_iDRbo NZ000T 2026-03-10T12:12:37.135Z 2026-03-17T12:42:27.812Z
9449327 9449327 20260309142424_7iUjg NZ000T 2026-03-10T12:12:35.951Z 2026-03-17T12:42:27.748Z
9449314 9449314 20260309141749_iRRiB NZ000T 2026-03-10T12:12:34.145Z 2026-03-17T12:42:27.637Z
9449293 9449293 20260309141434_sL5sQ NZ000T 2026-03-10T12:12:31.615Z 2026-03-17T12:42:27.542Z
9449262 9449262 20260309140048_edJ1X NZ000T 2026-03-10T12:12:26.172Z 2026-03-17T12:42:27.172Z
9449223 9449223 20260309134429_V0GBA NZ000T 2026-03-10T12:12:19.333Z 2026-03-17T12:42:26.886Z
9449194 9449194 20260309133900_mfDLv NZ000T 2026-03-10T12:12:14.032Z 2026-03-17T12:42:26.747Z
9449163 9449163 20260309133113_BtEk8 NZ000T 2026-03-10T12:12:08.748Z 2026-03-17T12:42:26.499Z
9449123 9449123 20260309131507_ORQfO NZ000T 2026-03-10T12:12:02.385Z 2026-03-17T12:42:26.216Z
9449114 9449114 20260309131303_OjWzP NZ000T 2026-03-10T12:12:00.819Z 2026-03-17T12:42:26.141Z
9449061 9449061 20260309125609_ybTqk NZ000T 2026-03-10T12:11:49.333Z 2026-03-17T12:42:25.516Z
9449021 9449021 20260309124343_NN36X NZ000T 2026-03-10T12:11:42.300Z 2026-03-17T12:42:25.237Z
9448924 9448924 20260309122253_QGMDw NZ000T 2026-03-10T12:11:25.005Z 2026-03-17T12:42:24.494Z
9448744 9448744 20260309114238_x5XVZ NZ000T 2026-03-10T12:10:49.476Z 2026-03-17T12:42:22.522Z
9448710 9448710 20260309113534_nQU5J NZ000T 2026-03-10T12:10:42.644Z 2026-03-17T12:42:22.131Z
9448618 9448618 20260309111849_d5mj7 NZ000T 2026-03-10T12:10:26.253Z 2026-03-17T12:42:21.142Z
9448436 9448436 20260309104751_COBmL NZ000T 2026-03-10T12:09:52.608Z 2026-03-17T12:42:19.820Z
9448182 9448182 20260309100715_YsXhY NZ000T 2026-03-10T12:09:07.125Z 2026-03-17T12:42:04.473Z
9448168 9448168 20260309100511_4JEMt NZ000T 2026-03-10T12:09:05.893Z 2026-03-17T12:42:04.287Z
9448132 9448132 20260309100021_6pCVI NZ000T 2026-03-10T12:08:57.618Z 2026-03-17T12:42:00.448Z
9447783 9447783 20260309084922_e22NR NZ000T 2026-03-10T12:07:48.294Z 2026-03-17T12:41:56.666Z
9438925 9438925 20260307115828_11CzD NZ000T 2026-03-08T12:09:01.708Z 2026-03-15T12:41:36.847Z
9438916 9438916 20260307115436_wyXxH NZ000T 2026-03-08T12:09:00.172Z 2026-03-15T12:41:36.766Z
9438885 9438885 20260307115012_syMgt NZ000T 2026-03-08T12:08:51.677Z 2026-03-15T12:41:36.407Z
9438299 9438299 20260307095938_8EIkZ NZ000T 2026-03-08T12:07:02.150Z 2026-03-15T12:41:30.783Z
9438290 9438290 20260307095727_7LrLH NZ000T 2026-03-08T12:07:00.754Z 2026-03-15T12:41:30.768Z
9438186 9438186 20260307093311_CyuPD NZ000T 2026-03-08T12:06:45.032Z 2026-03-15T12:41:30.093Z
9438173 9438173 20260307093058_50C4W NZ000T 2026-03-08T12:06:43.080Z 2026-03-15T12:41:29.948Z
9438165 9438165 20260307093035_ZQXIM NZ000T 2026-03-08T12:06:42.087Z 2026-03-15T12:41:29.896Z
9435490 9435490 20260306163130_exBhu NZ000T 2026-03-07T14:15:24.534Z 2026-03-14T12:40:35.314Z
9435466 9435466 20260306162532_c43sy NZ000T 2026-03-07T14:15:18.195Z 2026-03-14T12:40:34.894Z
9435452 9435452 20260306162424_p2b3d NZ000T 2026-03-07T14:15:15.507Z 2026-03-14T12:40:34.691Z
9435415 9435415 20260306161745_XXBTF NZ000T 2026-03-07T14:15:06.166Z 2026-03-14T12:40:33.833Z
9435407 9435407 20260306161328_2X2HX NZ000T 2026-03-07T14:15:02.288Z 2026-03-14T12:40:33.585Z
9435350 9435350 20260306160444_6R4p7 NZ000T 2026-03-07T14:14:48.089Z 2026-03-14T12:40:32.435Z
9435170 9435170 20260306154012_WogW5 NZ000T 2026-03-07T14:14:15.546Z 2026-03-14T12:40:30.755Z
9433577 9433577 20260306111609_jTPPi NZ000T 2026-03-07T14:08:42.318Z 2026-03-14T12:39:58.358Z
9433257 9433257 20260306102926_AvY8x NZ000T 2026-03-07T14:07:44.843Z 2026-03-14T12:39:55.551Z
9432948 9432948 20260306093007_nqjpR NZ000T 2026-03-07T14:06:44.059Z 2026-03-14T12:39:50.033Z
9424232 9424232 20260304155357_DUOMS NZ000T 2026-03-05T14:07:36.204Z 2026-03-12T12:33:11.879Z
9424161 9424161 20260304154024_UkNnS NZ000T 2026-03-05T14:07:25.287Z 2026-03-12T12:33:10.766Z
9424153 9424153 20260304153823_uWp1u NZ000T 2026-03-05T14:07:23.300Z 2026-03-12T12:33:10.552Z
9424135 9424135 20260304152510_UKArm NZ000T 2026-03-05T14:07:19.873Z 2026-03-12T12:33:10.050Z
9424084 9424084 20260304150809_YNpGe NZ000T 2026-03-05T14:07:10.633Z 2026-03-12T12:33:09.314Z
9424016 9424016 20260304143950_n2PWV NZ000T 2026-03-05T14:06:56.999Z 2026-03-12T12:33:07.610Z
9424014 9424014 20260304143903_RCoXW NZ000T 2026-03-05T14:06:56.519Z 2026-03-12T12:33:07.565Z
9423980 9423980 20260304142201_9grrq NZ000T 2026-03-05T14:06:51.721Z 2026-03-12T12:33:06.808Z
9423220 9423220 20260304084052_E0GBM NZ000T 2026-03-05T14:04:10.121Z 2026-03-12T12:32:53.451Z
9417794 9417794 20260302165607_PrXE9 NZ000T 2026-03-03T14:06:57.954Z 2026-03-10T12:36:35.129Z
9417656 9417656 20260302163547_TrOnt NZ000T 2026-03-03T14:06:40.982Z 2026-03-10T12:36:33.436Z
9417640 9417640 20260302163147_Y2NsE NZ000T 2026-03-03T14:06:39.824Z 2026-03-10T12:36:33.333Z
9417486 9417486 20260302154234_8BsLs NZ000T 2026-03-03T14:06:18.527Z 2026-03-10T12:36:30.255Z
9417366 9417366 20260302152133_2M59T NZ000T 2026-03-03T14:06:04.257Z 2026-03-10T12:36:28.319Z
9417265 9417265 20260302145101_COWP1 NZ000T 2026-03-03T14:05:48.703Z 2026-03-10T12:36:26.873Z
9417248 9417248 20260302144554_vilp4 NZ000T 2026-03-03T14:05:45.594Z 2026-03-10T12:36:26.530Z
9417119 9417119 20260302141237_kFRoa NZ000T 2026-03-03T14:05:32.320Z 2026-03-10T12:36:24.640Z
9417051 9417051 20260302134309_WUUU1 NZ000T 2026-03-03T14:05:21.383Z 2026-03-10T12:36:23.320Z
9417016 9417016 20260302133305_D1R8y NZ000T 2026-03-03T14:05:15.175Z 2026-03-10T12:36:22.782Z
9416985 9416985 20260302131941_IMWDX NZ000T 2026-03-03T14:05:11.338Z 2026-03-10T12:36:22.227Z
9416683 9416683 20260302115901_rhI02 NZ000T 2026-03-03T14:04:24.426Z 2026-03-10T12:36:17.211Z
9416653 9416653 20260302115215_RDVYb NZ000T 2026-03-03T14:04:18.717Z 2026-03-10T12:36:16.646Z
9414124 9414124 20260301155631_xEbmG NZ000T 2026-03-02T14:04:08.923Z 2026-03-09T12:40:41.051Z
9414122 9414122 20260301155631_4k7b7 NZ000T 2026-03-02T14:04:08.741Z 2026-03-09T12:40:40.888Z
9413905 9413905 20260301150744_KaA4f NZ000T 2026-03-02T14:03:52.285Z 2026-03-09T12:40:28.938Z
9413849 9413849 20260301145217_pz2Jn NZ000T 2026-03-02T14:03:47.330Z 2026-03-09T12:40:26.928Z
9413653 9413653 20260301133844_rpiHb NZ000T 2026-03-02T14:03:36.694Z 2026-03-09T12:40:23.020Z
9411718 9411718 20260227120702_2m4U8 NZ000T 2026-03-01T14:07:10.307Z 2026-03-07T14:48:47.750Z
9411258 9411258 20260228151314_cbORv NZ000T 2026-03-01T14:04:36.528Z 2026-03-08T12:42:30.823Z
9407172 9407172 20260226124050_4OQ3b NZ000T 2026-02-28T14:20:28.708Z 2026-03-06T14:44:46.102Z

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