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

2,626 rows where station_code = "NZ004Z" 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
8685074 8685074 20251204151227_2Wu8k NZ004Z 2025-12-05T14:05:35.096Z 2025-12-05T14:05:35.096Z
8672887 8672887 20251201153439_jGO7f NZ004Z 2025-12-03T14:16:51.408Z 2025-12-05T14:25:45.675Z
8672837 8672837 20251201152736_RWtdh NZ004Z 2025-12-03T14:16:39.542Z 2025-12-05T14:25:43.480Z
8672780 8672780 20251201151710_btAML NZ004Z 2025-12-03T14:16:26.144Z 2025-12-05T14:25:41.723Z
8672654 8672654 20251201150015_QilO6 NZ004Z 2025-12-03T14:16:03.306Z 2025-12-05T14:25:37.518Z
8672536 8672536 20251201144205_AsgTj NZ004Z 2025-12-03T14:15:51.160Z 2025-12-05T14:25:33.591Z
8672501 8672501 20251201143855_1YA3L NZ004Z 2025-12-03T14:15:40.954Z 2025-12-05T14:25:32.185Z
8672442 8672442 20251201142956_dMCQ3 NZ004Z 2025-12-03T14:15:34.966Z 2025-12-05T14:25:30.305Z
8671967 8671967 20251201133052_5YKWn NZ004Z 2025-12-03T14:14:18.366Z 2025-12-05T14:25:02.218Z
8671872 8671872 20251201130948_ZTCc2 NZ004Z 2025-12-03T14:14:02.471Z 2025-12-05T14:24:57.536Z
8671467 8671467 20251201122229_DM6j8 NZ004Z 2025-12-03T14:12:42.029Z 2025-12-05T14:24:30.380Z
8671369 8671369 20251201120626_Pfc2A NZ004Z 2025-12-03T14:12:16.107Z 2025-12-05T14:24:25.741Z
8671096 8671096 20251201111121_n40qe NZ004Z 2025-12-03T14:11:14.432Z 2025-12-05T14:24:05.447Z
8670996 8670996 20251201110003_Z9ZLj NZ004Z 2025-12-03T14:11:01.561Z 2025-12-05T14:23:58.738Z
8661508 8661508 20251130153841_jFCor NZ004Z 2025-12-02T14:11:42.008Z 2025-12-05T14:32:05.647Z
8661487 8661487 20251130153329_Yi1NE NZ004Z 2025-12-02T14:11:37.956Z 2025-12-05T14:32:04.941Z
8661483 8661483 20251130153231_BLNSu NZ004Z 2025-12-02T14:11:37.518Z 2025-12-05T14:32:04.891Z
8661006 8661006 20251130142608_Xa5CC NZ004Z 2025-12-02T14:09:58.813Z 2025-12-05T14:31:45.882Z
8660932 8660932 20251130141436_YDUYO NZ004Z 2025-12-02T14:09:45.705Z 2025-12-05T14:31:43.280Z
8660883 8660883 20251130140828_7KT5B NZ004Z 2025-12-02T14:09:35.461Z 2025-12-05T14:31:40.928Z
8660797 8660797 20251130135258_WRUsX NZ004Z 2025-12-02T14:09:12.758Z 2025-12-05T14:31:25.886Z
8660658 8660658 20251130132530_J21xm NZ004Z 2025-12-02T14:08:41.286Z 2025-12-05T14:31:18.248Z
8640630 8640630 20251129151012_0MYF3 NZ004Z 2025-11-30T14:08:58.894Z 2025-12-05T14:39:22.616Z
8640352 8640352 20251129135219_99wZU NZ004Z 2025-11-30T14:08:05.790Z 2025-12-05T14:39:10.976Z
8640322 8640322 20251129134510_nM3al NZ004Z 2025-11-30T14:07:57.750Z 2025-12-05T14:39:10.112Z
8640306 8640306 20251129133734_J2PTP NZ004Z 2025-11-30T14:07:49.520Z 2025-12-05T14:39:09.279Z
8640251 8640251 20251129131522_j3Qfa NZ004Z 2025-11-30T14:07:37.672Z 2025-12-05T14:39:06.599Z
8639480 8639480 20251129110938_FSPPH NZ004Z 2025-11-30T14:05:06.956Z 2025-12-05T14:38:23.116Z
8619688 8619688 20251126104653_Cdf5z NZ004Z 2025-11-28T14:09:58.498Z 2025-12-05T15:01:04.642Z
8604610 8604610 20251124092224_x65tV NZ004Z 2025-11-26T14:37:31.575Z 2025-12-02T15:13:07.266Z
8595226 8595226 20251124143616_EBYXI NZ004Z 2025-11-26T14:10:20.848Z 2025-12-02T15:05:45.398Z
8595052 8595052 20251124135136_Ge79N NZ004Z 2025-11-26T14:09:45.244Z 2025-12-02T15:05:40.439Z
8594568 8594568 20251124115109_3owDd NZ004Z 2025-11-26T14:07:26.181Z 2025-12-02T15:05:33.282Z
8594466 8594466 20251124112648_hQuQV NZ004Z 2025-11-26T14:07:02.053Z 2025-12-02T15:05:32.106Z
8594363 8594363 20251124105616_IjCdW NZ004Z 2025-11-26T14:06:07.360Z 2025-12-02T15:05:29.965Z
8585030 8585030 20251123142136_2W56S NZ004Z 2025-11-25T14:08:24.765Z 2025-12-02T15:09:53.280Z
8584801 8584801 20251123132954_ah6vR NZ004Z 2025-11-25T14:07:41.038Z 2025-12-02T15:09:51.915Z
8584683 8584683 20251123130411_Lt7uR NZ004Z 2025-11-25T14:07:14.903Z 2025-12-02T15:09:51.194Z
8584646 8584646 20251123125329_tCOTs NZ004Z 2025-11-25T14:07:10.126Z 2025-12-02T15:09:50.967Z
8584292 8584292 20251123113746_QTpgR NZ004Z 2025-11-25T14:05:50.242Z 2025-12-02T15:09:47.563Z
8584238 8584238 20251123112318_HETeL NZ004Z 2025-11-25T14:05:43.757Z 2025-12-02T15:09:47.207Z
8584101 8584101 20251123105909_VYOIW NZ004Z 2025-11-25T14:05:19.576Z 2025-12-02T15:09:46.159Z
8583833 8583833 20251123095236_1v19i NZ004Z 2025-11-25T14:04:10.531Z 2025-12-02T15:09:43.050Z
8563304 8563304 20251121154556_DBqKW NZ004Z 2025-11-23T14:07:57.601Z 2025-11-30T15:03:37.437Z
8563262 8563262 20251121153909_rl3HH NZ004Z 2025-11-23T14:07:52.599Z 2025-11-30T15:03:37.057Z
8563026 8563026 20251121150822_6gdr2 NZ004Z 2025-11-23T14:07:05.707Z 2025-11-30T15:03:34.777Z
8562360 8562360 20251121141012_YJ09s NZ004Z 2025-11-23T14:05:27.890Z 2025-11-30T15:03:28.038Z
8561588 8561588 20251121123057_kvcpB NZ004Z 2025-11-23T14:03:07.626Z 2025-11-30T15:03:03.446Z
8554101 8554101 20251120082021_ay2wN NZ004Z 2025-11-22T14:34:45.689Z 2025-11-28T14:58:46.355Z
8544691 8544691 20251120152633_2pAL1 NZ004Z 2025-11-22T14:08:37.955Z 2025-11-29T14:53:49.428Z
8544674 8544674 20251120152558_yZaIW NZ004Z 2025-11-22T14:08:35.830Z 2025-11-29T14:53:49.406Z
8544416 8544416 20251120151227_Rgfdb NZ004Z 2025-11-22T14:07:54.877Z 2025-11-29T14:53:46.361Z
8544248 8544248 20251120150014_So2Rh NZ004Z 2025-11-22T14:07:19.657Z 2025-11-29T14:53:43.021Z
8543670 8543670 20251120141347_Gd72O NZ004Z 2025-11-22T14:05:48.325Z 2025-11-29T14:53:28.144Z
8543442 8543442 20251120135400_zbglk NZ004Z 2025-11-22T14:05:13.883Z 2025-11-29T14:53:25.768Z
8543176 8543176 20251120133137_akwEG NZ004Z 2025-11-22T14:04:18.624Z 2025-11-29T14:53:19.073Z
8542744 8542744 20251120124802_1JMSi NZ004Z 2025-11-22T14:03:03.644Z 2025-11-29T14:53:14.864Z
8542727 8542727 20251120124559_gozRd NZ004Z 2025-11-22T14:03:01.494Z 2025-11-29T14:53:14.818Z
8542645 8542645 20251120123533_86Fn1 NZ004Z 2025-11-22T14:02:44.963Z 2025-11-29T14:53:14.003Z
8542514 8542514 20251120122157_6aNbc NZ004Z 2025-11-22T14:02:22.214Z 2025-11-29T14:53:12.637Z
8542384 8542384 20251120120759_4FF5n NZ004Z 2025-11-22T14:01:57.630Z 2025-11-29T14:53:11.128Z
8542201 8542201 20251120114329_OyoQ8 NZ004Z 2025-11-22T14:01:32.341Z 2025-11-29T14:53:06.915Z
8530948 8530948 20251119132402_rezd5 NZ004Z 2025-11-21T14:03:33.373Z 2025-11-28T14:53:27.333Z
8530594 8530594 20251119122753_QpR65 NZ004Z 2025-11-21T14:02:11.263Z 2025-11-28T14:53:17.715Z
8530181 8530181 20251119111228_61tbn NZ004Z 2025-11-21T14:00:44.389Z 2025-11-28T14:53:02.697Z
8530056 8530056 20251119105141_rfsQ4 NZ004Z 2025-11-21T14:00:15.229Z 2025-11-28T14:52:55.456Z
8529733 8529733 20251119103619_0Ks48 NZ004Z 2025-11-20T14:45:26.607Z 2025-11-27T15:13:38.437Z
8529727 8529727 20251119103442_juwd6 NZ004Z 2025-11-20T14:45:24.528Z 2025-11-20T14:45:24.528Z
8501241 8501241 20251116103859_P3FCO NZ004Z 2025-11-18T14:47:18.110Z 2025-11-24T15:06:26.745Z
8501217 8501217 20251116103454_uXZWP NZ004Z 2025-11-18T14:47:17.025Z 2025-11-24T15:06:26.314Z
8500776 8500776 20251116094543_Y34Xh NZ004Z 2025-11-18T14:46:36.289Z 2025-11-24T15:05:59.634Z
8500639 8500639 20251116092752_3xvq6 NZ004Z 2025-11-18T14:46:27.293Z 2025-11-24T15:05:54.099Z
8500622 8500622 20251116092543_gZJaU NZ004Z 2025-11-18T14:46:26.229Z 2025-11-24T15:05:53.884Z
8500490 8500490 20251116090442_KlQnC NZ004Z 2025-11-18T14:46:21.045Z 2025-11-24T15:05:45.770Z
8487526 8487526 20251116125932_h2Giz NZ004Z 2025-11-18T14:03:35.345Z 2025-11-25T15:06:16.875Z
8486974 8486974 20251116120007_wSE2H NZ004Z 2025-11-18T14:01:31.766Z 2025-11-25T15:06:01.827Z
8486902 8486902 20251116115017_I32Cj NZ004Z 2025-11-18T14:01:13.222Z 2025-11-25T15:06:01.240Z
8484978 8484978 20251115101851_9LrpZ NZ004Z 2025-11-17T14:33:04.561Z 2025-11-23T15:19:52.580Z
8477440 8477440 20251115153249_bFqs3 NZ004Z 2025-11-17T14:11:11.678Z 2025-11-24T15:03:36.880Z
8476852 8476852 20251115150336_VS8wb NZ004Z 2025-11-17T14:09:53.918Z 2025-11-24T15:03:14.725Z
8476275 8476275 20251115143847_XYgWE NZ004Z 2025-11-17T14:08:33.647Z 2025-11-24T15:03:09.997Z
8476086 8476086 20251115143007_UQnZh NZ004Z 2025-11-17T14:08:04.893Z 2025-11-24T15:03:06.871Z
8476047 8476047 20251115142900_UVFMh NZ004Z 2025-11-17T14:08:00.965Z 2025-11-24T15:03:06.725Z
8475353 8475353 20251115135113_jnk7j NZ004Z 2025-11-17T14:06:30.419Z 2025-11-24T15:03:01.752Z
8475183 8475183 20251115134218_n2fdg NZ004Z 2025-11-17T14:06:04.858Z 2025-11-24T15:03:00.810Z
8475086 8475086 20251115133731_tyWff NZ004Z 2025-11-17T14:05:56.707Z 2025-11-24T15:03:00.099Z
8474519 8474519 20251115130944_JLWMV NZ004Z 2025-11-17T14:04:44.805Z 2025-11-24T15:02:56.752Z
8474457 8474457 20251115130707_fuzsc NZ004Z 2025-11-17T14:04:39.477Z 2025-11-24T15:02:56.443Z
8474215 8474215 20251115125133_S0j5h NZ004Z 2025-11-17T14:04:01.820Z 2025-11-24T15:02:54.732Z
8474008 8474008 20251115124127_NqG3c NZ004Z 2025-11-17T14:03:29.994Z 2025-11-24T15:02:53.524Z
8473500 8473500 20251115121656_OEtJF NZ004Z 2025-11-17T14:02:14.463Z 2025-11-24T15:02:39.289Z
8473054 8473054 20251115115431_uTwgt NZ004Z 2025-11-17T14:01:05.516Z 2025-11-24T15:02:27.813Z
8472177 8472177 20251114105612_02JDS NZ004Z 2025-11-16T14:33:04.202Z 2025-11-22T15:24:05.556Z
8471774 8471774 20251114095430_Jou4d NZ004Z 2025-11-16T14:31:58.705Z 2025-11-22T15:23:36.980Z
8471732 8471732 20251114094821_3NdJ7 NZ004Z 2025-11-16T14:31:56.768Z 2025-11-22T15:23:35.998Z
8471621 8471621 20251114093105_egsFm NZ004Z 2025-11-16T14:31:26.962Z 2025-11-22T15:23:29.657Z
8471587 8471587 20251114092833_VsPRS NZ004Z 2025-11-16T14:31:26.205Z 2025-11-22T15:23:29.066Z
8471580 8471580 20251114092832_Kt43s NZ004Z 2025-11-16T14:31:26.138Z 2025-11-22T15:23:28.976Z
8464243 8464243 20251114142954_rKbll NZ004Z 2025-11-16T14:05:43.343Z 2025-11-23T15:16:15.384Z
8464049 8464049 20251114141252_pNku8 NZ004Z 2025-11-16T14:05:10.724Z 2025-11-23T15:16:09.355Z

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