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

>10,000 rows count all where station_code = "NZ0011" 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
9627514 9627514 20260408181058_GkgWr NZ0011 2026-04-09T12:11:14.173Z 2026-04-10T12:14:22.557Z
9627503 9627503 20260408180916_gJhUa NZ0011 2026-04-09T12:11:13.287Z 2026-04-10T12:14:22.556Z
9627463 9627463 20260408174436_G7aaK NZ0011 2026-04-09T12:11:07.066Z 2026-04-10T12:14:22.548Z
9627412 9627412 20260408172838_Ze8Lg NZ0011 2026-04-09T12:10:52.594Z 2026-04-10T12:14:22.539Z
9627398 9627398 20260408172416_jCUbx NZ0011 2026-04-09T12:10:49.033Z 2026-04-10T12:14:22.536Z
9627390 9627390 20260408172312_KCUAf NZ0011 2026-04-09T12:10:47.855Z 2026-04-10T12:14:22.535Z
9627380 9627380 20260408172254_JS23O NZ0011 2026-04-09T12:10:46.768Z 2026-04-10T12:14:22.534Z
9627352 9627352 20260408172029_833D3 NZ0011 2026-04-09T12:10:44.304Z 2026-04-10T12:14:22.530Z
9627298 9627298 20260408170229_8W3sT NZ0011 2026-04-09T12:10:34.660Z 2026-04-10T12:14:22.518Z
9627205 9627205 20260408164303_EqSyC NZ0011 2026-04-09T12:10:19.347Z 2026-04-10T12:14:22.502Z
9627051 9627051 20260408160037_JCu3t NZ0011 2026-04-09T12:09:51.441Z 2026-04-10T12:14:22.469Z
9626934 9626934 20260408152540_3YIIF NZ0011 2026-04-09T12:09:34.324Z 2026-04-10T12:14:22.437Z
9626889 9626889 20260408152007_KugoQ NZ0011 2026-04-09T12:09:29.466Z 2026-04-10T12:14:22.431Z
9626869 9626869 20260408151826_v24O3 NZ0011 2026-04-09T12:09:22.855Z 2026-04-10T12:14:22.428Z
9626865 9626865 20260408151825_a2V3N NZ0011 2026-04-09T12:09:22.516Z 2026-04-10T12:14:22.427Z
9626754 9626754 20260408150057_LMDae NZ0011 2026-04-09T12:09:08.138Z 2026-04-10T12:14:22.408Z
9626722 9626722 20260408145835_07Tki NZ0011 2026-04-09T12:09:06.015Z 2026-04-10T12:14:22.405Z
9626596 9626596 20260408142333_OvmFx NZ0011 2026-04-09T12:08:45.422Z 2026-04-10T12:14:22.381Z
9626519 9626519 20260408141016_HBv0S NZ0011 2026-04-09T12:08:37.124Z 2026-04-10T12:14:22.367Z
9626344 9626344 20260408134518_5I4ut NZ0011 2026-04-09T12:08:11.193Z 2026-04-10T12:14:22.337Z
9626321 9626321 20260408134211_MM8ZF NZ0011 2026-04-09T12:08:00.487Z 2026-04-10T12:14:22.333Z
9626262 9626262 20260408133449_Ms12M NZ0011 2026-04-09T12:07:51.364Z 2026-04-10T12:14:22.325Z
9626203 9626203 20260408132408_ZFIkc NZ0011 2026-04-09T12:07:45.966Z 2026-04-10T12:14:22.317Z
9626015 9626015 20260408125302_jhkCp NZ0011 2026-04-09T12:07:18.774Z 2026-04-10T12:14:22.281Z
9625970 9625970 20260408124303_BJAHm NZ0011 2026-04-09T12:07:13.093Z 2026-04-10T12:14:22.273Z
9625629 9625629 20260408113027_MNEOJ NZ0011 2026-04-09T12:06:10.150Z 2026-04-10T12:14:22.216Z
9625624 9625624 20260408112759_rKwnG NZ0011 2026-04-09T12:06:09.490Z 2026-04-10T12:14:22.215Z
9625110 9625110 20260408093920_5EJRJ NZ0011 2026-04-09T12:04:17.779Z 2026-04-10T12:14:21.857Z
9624785 9624785 20260408082800_ijHIh NZ0011 2026-04-09T12:02:55.718Z 2026-04-10T12:14:21.463Z
9624768 9624768 20260408082643_xwDhp NZ0011 2026-04-09T12:02:52.995Z 2026-04-10T12:14:21.459Z
9624532 9624532 20260408073244_K0Mj1 NZ0011 2026-04-09T12:01:53.138Z 2026-04-10T12:14:21.400Z
9613227 9613227 20260405101433_2EHxM NZ0011 2026-04-07T12:05:11.917Z 2026-04-10T12:26:25.273Z
9612704 9612704 20260406153823_eg96f NZ0011 2026-04-07T12:02:35.791Z 2026-04-10T12:22:16.279Z
9612475 9612475 20260406122139_Q7Z7g NZ0011 2026-04-07T12:01:56.924Z 2026-04-10T12:22:10.055Z
9612355 9612355 20260406100752_wO4zS NZ0011 2026-04-07T12:01:34.916Z 2026-04-10T12:22:05.674Z
9612347 9612347 20260406100501_7r99L NZ0011 2026-04-07T12:01:34.034Z 2026-04-10T12:22:05.530Z
9612331 9612331 20260406095631_6S3Eo NZ0011 2026-04-07T12:01:31.959Z 2026-04-10T12:22:05.193Z
9612289 9612289 20260406093300_aelvK NZ0011 2026-04-07T12:01:24.639Z 2026-04-10T12:22:03.729Z
9612188 9612188 20260406075442_bKQSm NZ0011 2026-04-07T12:01:02.891Z 2026-04-10T12:22:00.694Z
9611864 9611864 20260401094218_k5PgO NZ0011 2026-04-06T12:24:25.146Z 2026-04-10T12:35:30.557Z
9611861 9611861 20260401091834_AY3K3 NZ0011 2026-04-06T12:24:23.753Z 2026-04-10T12:35:30.202Z
9611852 9611852 20260402082534_5pY3M NZ0011 2026-04-06T12:21:41.499Z 2026-04-10T12:33:57.078Z
9610338 9610338 20260405163137_SiQ8g NZ0011 2026-04-06T12:07:09.021Z 2026-04-10T12:27:04.667Z
9610298 9610298 20260405155913_3RCOD NZ0011 2026-04-06T12:06:55.065Z 2026-04-10T12:27:03.437Z
9610187 9610187 20260405142053_LH0Ys NZ0011 2026-04-06T12:06:16.696Z 2026-04-10T12:26:59.527Z
9610076 9610076 20260405124220_wDPrk NZ0011 2026-04-06T12:05:35.953Z 2026-04-10T12:26:34.454Z
9609991 9609991 20260405114044_n11OU NZ0011 2026-04-06T12:05:11.359Z 2026-04-10T12:26:32.039Z
9609975 9609975 20260405113719_pSvj3 NZ0011 2026-04-06T12:05:04.551Z 2026-04-10T12:26:31.525Z
9605219 9605219 20260403080310_KUrLw NZ0011 2026-04-04T12:01:15.621Z 2026-04-10T12:31:31.134Z
9603640 9603640 20260402113038_g836e NZ0011 2026-04-03T12:03:53.748Z 2026-04-10T12:34:06.003Z
9603245 9603245 20260402090308_Lk247 NZ0011 2026-04-03T12:02:17.293Z 2026-04-10T12:33:58.652Z
9601977 9601977 20260401174005_t7MuQ NZ0011 2026-04-02T12:04:23.109Z 2026-04-10T12:35:50.716Z
9601871 9601871 20260401171810_gAbbO NZ0011 2026-04-02T12:03:59.631Z 2026-04-10T12:35:48.756Z
9600915 9600915 20260401084304_atvlA NZ0011 2026-04-02T12:00:57.733Z 2026-04-10T12:35:29.555Z
9599979 9599979 20260331175019_2saWQ NZ0011 2026-04-01T12:05:29.519Z 2026-04-09T12:48:04.112Z
9599424 9599424 20260331143047_mIP6F NZ0011 2026-04-01T12:03:32.643Z 2026-04-09T12:46:47.327Z
9599232 9599232 20260331130727_AaDW3 NZ0011 2026-04-01T12:02:49.773Z 2026-04-09T12:46:44.468Z
9599015 9599015 20260331104109_82qz3 NZ0011 2026-04-01T12:02:02.925Z 2026-04-09T12:46:39.926Z
9598933 9598933 20260331091845_WZGy0 NZ0011 2026-04-01T12:01:38.616Z 2026-04-09T12:46:38.341Z
9598818 9598818 20260331073846_9FxR6 NZ0011 2026-04-01T12:01:12.276Z 2026-04-09T12:46:36.309Z
9598050 9598050 20260330173535_EDIOf NZ0011 2026-03-31T12:07:30.718Z 2026-04-08T12:44:24.335Z
9597385 9597385 20260330161316_p9Yu2 NZ0011 2026-03-31T12:06:17.924Z 2026-04-08T12:43:41.843Z
9597340 9597340 20260330160725_XJy2d NZ0011 2026-03-31T12:06:12.439Z 2026-04-08T12:43:40.861Z
9597258 9597258 20260330155253_MJtdN NZ0011 2026-03-31T12:06:02.200Z 2026-04-08T12:43:37.158Z
9597205 9597205 20260330153440_UNbZs NZ0011 2026-03-31T12:05:54.427Z 2026-04-08T12:43:35.564Z
9597025 9597025 20260330150212_F2OkH NZ0011 2026-03-31T12:05:31.420Z 2026-04-08T12:43:30.845Z
9597003 9597003 20260330145455_cGLga NZ0011 2026-03-31T12:05:28.378Z 2026-04-08T12:43:30.121Z
9596997 9596997 20260330145410_f2vUx NZ0011 2026-03-31T12:05:27.162Z 2026-04-08T12:43:29.892Z
9596836 9596836 20260330141112_EWA2Q NZ0011 2026-03-31T12:05:03.423Z 2026-04-08T12:43:25.546Z
9596740 9596740 20260330135226_Mehu2 NZ0011 2026-03-31T12:04:52.306Z 2026-04-08T12:43:23.431Z
9596722 9596722 20260330134754_4mW0h NZ0011 2026-03-31T12:04:48.642Z 2026-04-08T12:43:23.060Z
9596662 9596662 20260330133759_enM4j NZ0011 2026-03-31T12:04:40.281Z 2026-04-08T12:43:21.720Z
9596278 9596278 20260330120343_y2Y5k NZ0011 2026-03-31T12:03:55.249Z 2026-04-08T12:42:48.252Z
9595910 9595910 20260330100221_AAmW3 NZ0011 2026-03-31T12:02:49.019Z 2026-04-08T12:42:35.948Z
9595865 9595865 20260330093233_7AGCo NZ0011 2026-03-31T12:02:43.623Z 2026-04-08T12:42:34.861Z
9595852 9595852 20260330092932_x9Irn NZ0011 2026-03-31T12:02:42.502Z 2026-04-08T12:42:34.611Z
9595718 9595718 20260330081245_RFZDR NZ0011 2026-03-31T12:02:17.493Z 2026-04-08T12:42:30.351Z
9591101 9591101 20260328131733_YW8lL NZ0011 2026-03-29T12:03:50.500Z 2026-04-06T12:39:00.683Z
9591093 9591093 20260328131415_7LPrb NZ0011 2026-03-29T12:03:49.954Z 2026-04-06T12:39:00.219Z
9591053 9591053 20260328125006_XHUCE NZ0011 2026-03-29T12:03:45.774Z 2026-04-06T12:38:48.683Z
9591022 9591022 20260328122748_2VSAl NZ0011 2026-03-29T12:03:40.217Z 2026-04-06T12:38:47.031Z
9588185 9588185 20260326160811_ZwBtW NZ0011 2026-03-28T12:10:13.575Z 2026-04-04T12:41:25.042Z
9588181 9588181 20260326154904_jm9Nu NZ0011 2026-03-28T12:10:10.450Z 2026-04-04T12:41:22.951Z
9583585 9583585 20260326162123_Oj0xO NZ0011 2026-03-27T12:09:11.901Z 2026-04-04T12:41:26.542Z
9583506 9583506 20260326154124_mTzrM NZ0011 2026-03-27T12:09:01.337Z 2026-04-04T12:41:21.821Z
9583478 9583478 20260326152156_SCbr0 NZ0011 2026-03-27T12:08:55.243Z 2026-04-04T12:41:19.525Z
9583472 9583472 20260326151902_I3Xwj NZ0011 2026-03-27T12:08:54.195Z 2026-03-27T12:08:54.195Z
9579350 9579350 20260324173641_Ak4PL NZ0011 2026-03-26T12:13:09.845Z 2026-04-02T12:37:01.865Z
9579344 9579344 20260324172333_ojcfh NZ0011 2026-03-26T12:13:07.054Z 2026-04-02T12:37:01.081Z
9579342 9579342 20260324172144_ljqqK NZ0011 2026-03-26T12:13:06.399Z 2026-04-02T12:37:00.805Z
9579340 9579340 20260324171453_zqssq NZ0011 2026-03-26T12:13:05.137Z 2026-04-02T12:37:00.225Z
9579337 9579337 20260324170836_TPwnx NZ0011 2026-03-26T12:13:02.841Z 2026-04-02T12:36:59.342Z
9579335 9579335 20260324165536_O9MzA NZ0011 2026-03-26T12:12:56.220Z 2026-04-02T12:36:50.421Z
9579329 9579329 20260324165200_bm8SF NZ0011 2026-03-26T12:12:53.229Z 2026-04-02T12:36:49.954Z
9579320 9579320 20260324163306_VOmF0 NZ0011 2026-03-26T12:12:50.319Z 2026-04-02T12:36:48.627Z
9579318 9579318 20260324163151_tnnx8 NZ0011 2026-03-26T12:12:49.639Z 2026-04-02T12:36:48.298Z
9579315 9579315 20260324161846_kCLJd NZ0011 2026-03-26T12:12:44.410Z 2026-04-02T12:36:45.294Z
9579313 9579313 20260324161747_SuXK6 NZ0011 2026-03-26T12:12:43.940Z 2026-04-02T12:36:44.951Z
9579307 9579307 20260324160242_kZVje NZ0011 2026-03-26T12:12:40.687Z 2026-04-02T12:36:43.597Z
9579303 9579303 20260324155609_FrNr8 NZ0011 2026-03-26T12:12:38.869Z 2026-04-02T12:36:42.584Z

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