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

643 rows where station_code = "NZ005Q" 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
9270551 9270551 20260128155932_CO6gL NZ005Q 2026-01-29T14:12:44.013Z 2026-01-29T14:12:44.013Z
9270465 9270465 20260128155303_CAD9P NZ005Q 2026-01-29T14:12:20.853Z 2026-01-29T14:12:20.853Z
9270320 9270320 20260128153109_fXf0U NZ005Q 2026-01-29T14:11:44.932Z 2026-01-29T14:11:44.932Z
9270242 9270242 20260128151846_lsS3x NZ005Q 2026-01-29T14:11:22.934Z 2026-01-29T14:11:22.934Z
9270123 9270123 20260128145826_FL3k1 NZ005Q 2026-01-29T14:10:56.336Z 2026-01-29T14:10:56.336Z
9270113 9270113 20260128145749_7U0VU NZ005Q 2026-01-29T14:10:55.223Z 2026-01-29T14:10:55.223Z
9270094 9270094 20260128145328_3tF3D NZ005Q 2026-01-29T14:10:49.242Z 2026-01-29T14:10:49.242Z
9270082 9270082 20260128145210_twfkP NZ005Q 2026-01-29T14:10:47.800Z 2026-01-29T14:10:47.800Z
9270075 9270075 20260128145132_P63LH NZ005Q 2026-01-29T14:10:46.897Z 2026-01-29T14:10:46.897Z
9270058 9270058 20260128145058_UwiZd NZ005Q 2026-01-29T14:10:44.523Z 2026-01-29T14:10:44.523Z
9270016 9270016 20260128144638_PtVA2 NZ005Q 2026-01-29T14:10:38.675Z 2026-01-29T14:10:38.675Z
9269883 9269883 20260128142703_PJa2P NZ005Q 2026-01-29T14:10:04.459Z 2026-01-29T14:10:04.459Z
9269881 9269881 20260128142702_UHgz2 NZ005Q 2026-01-29T14:10:03.763Z 2026-01-29T14:10:03.763Z
9269874 9269874 20260128142546_Xndp1 NZ005Q 2026-01-29T14:09:56.129Z 2026-01-29T14:09:56.129Z
9269816 9269816 20260128141730_5x3RH NZ005Q 2026-01-29T14:09:44.068Z 2026-01-29T14:09:44.068Z
9269805 9269805 20260128141617_Zbcxz NZ005Q 2026-01-29T14:09:42.252Z 2026-01-29T14:09:42.252Z
9269775 9269775 20260128141109_NF318 NZ005Q 2026-01-29T14:09:34.722Z 2026-01-29T14:09:34.722Z
9269733 9269733 20260128140142_UOHoR NZ005Q 2026-01-29T14:09:20.478Z 2026-01-29T14:09:20.478Z
9269637 9269637 20260128134849_8nlgp NZ005Q 2026-01-29T14:08:54.978Z 2026-01-29T14:08:54.978Z
9269570 9269570 20260128133817_uNToG NZ005Q 2026-01-29T14:08:31.096Z 2026-01-29T14:08:31.096Z
9269559 9269559 20260128133318_QJKix NZ005Q 2026-01-29T14:08:29.376Z 2026-01-29T14:08:29.376Z
9269390 9269390 20260128131218_pxkaB NZ005Q 2026-01-29T14:07:49.436Z 2026-01-29T14:07:49.436Z
9269247 9269247 20260128125024_YcajY NZ005Q 2026-01-29T14:07:05.843Z 2026-01-29T14:07:05.843Z
9269238 9269238 20260128124955_12GKs NZ005Q 2026-01-29T14:07:04.531Z 2026-01-29T14:07:04.531Z
9269153 9269153 20260128123825_oxqXU NZ005Q 2026-01-29T14:06:44.230Z 2026-01-29T14:06:44.230Z
9269147 9269147 20260128123800_ejW3Z NZ005Q 2026-01-29T14:06:41.589Z 2026-01-29T14:06:41.589Z
9268938 9268938 20260128114537_9D5ZY NZ005Q 2026-01-29T14:05:37.952Z 2026-01-29T14:05:37.952Z
9261890 9261890 20260126142556_YfAaz NZ005Q 2026-01-27T14:06:16.256Z 2026-01-29T14:33:14.375Z
9257416 9257416 20260125132805_xibL8 NZ005Q 2026-01-26T14:05:30.573Z 2026-01-29T14:37:11.141Z
9253693 9253693 20260124135207_CvXsz NZ005Q 2026-01-25T14:03:59.117Z 2026-01-29T14:41:17.488Z
9253581 9253581 20260124125137_ZjGpA NZ005Q 2026-01-25T14:03:24.283Z 2026-01-29T14:40:59.165Z
9250496 9250496 20260123153552_8292X NZ005Q 2026-01-24T14:03:14.859Z 2026-01-29T14:45:41.051Z
9250462 9250462 20260123151838_HkeeF NZ005Q 2026-01-24T14:03:02.965Z 2026-01-29T14:45:36.982Z
9250460 9250460 20260123151638_LwK3i NZ005Q 2026-01-24T14:03:02.174Z 2026-01-29T14:45:36.687Z
9250315 9250315 20260123124519_X2inu NZ005Q 2026-01-24T14:02:16.565Z 2026-01-29T14:45:15.305Z
9250309 9250309 20260123123801_Bhguo NZ005Q 2026-01-24T14:02:13.054Z 2026-01-29T14:45:14.665Z
9250290 9250290 20260123122131_j4Fcu NZ005Q 2026-01-24T14:02:08.324Z 2026-01-29T14:45:13.251Z
9250277 9250277 20260123120133_NkvfC NZ005Q 2026-01-24T14:02:04.356Z 2026-01-29T14:45:12.328Z
9250266 9250266 20260123115756_24wbU NZ005Q 2026-01-24T14:02:01.732Z 2026-01-29T14:45:11.588Z
9250202 9250202 20260123110336_7DSax NZ005Q 2026-01-24T14:01:39.108Z 2026-01-29T14:45:05.234Z
9250101 9250101 20260123101445_RDCHR NZ005Q 2026-01-24T14:01:08.587Z 2026-01-29T14:44:58.538Z
9250089 9250089 20260123101018_fypz1 NZ005Q 2026-01-24T14:01:04.365Z 2026-01-29T14:44:57.789Z
9250064 9250064 20260123100128_y8yIz NZ005Q 2026-01-24T14:00:56.735Z 2026-01-29T14:44:56.718Z
9250053 9250053 20260123095600_IQyJD NZ005Q 2026-01-24T14:00:52.602Z 2026-01-29T14:44:56.004Z
9249992 9249992 20260123092911_HCx6I NZ005Q 2026-01-24T14:00:30.100Z 2026-01-29T14:44:46.744Z
9249981 9249981 20260123092449_upuBe NZ005Q 2026-01-24T14:00:26.587Z 2026-01-29T14:44:46.140Z
9249967 9249967 20260123091648_ANIq1 NZ005Q 2026-01-24T14:00:22.524Z 2026-01-29T14:44:45.468Z
9249958 9249958 20260123091518_SQrcy NZ005Q 2026-01-24T14:00:20.239Z 2026-01-29T14:44:45.044Z
9249841 9249841 20260122092014_5YeOu NZ005Q 2026-01-23T14:16:21.019Z 2026-01-29T14:59:00.510Z
9246027 9246027 20260122160336_FUvsI NZ005Q 2026-01-23T14:04:23.838Z 2026-01-29T14:50:37.297Z
9246021 9246021 20260122160226_4scZN NZ005Q 2026-01-23T14:04:22.979Z 2026-01-29T14:50:36.674Z
9245981 9245981 20260122155339_2aR35 NZ005Q 2026-01-23T14:04:12.145Z 2026-01-29T14:50:28.325Z
9245976 9245976 20260122155327_mtlF8 NZ005Q 2026-01-23T14:04:11.737Z 2026-01-29T14:50:28.227Z
9245940 9245940 20260122153813_VRtvx NZ005Q 2026-01-23T14:04:05.816Z 2026-01-29T14:50:26.023Z
9245902 9245902 20260122152330_dawHP NZ005Q 2026-01-23T14:03:59.368Z 2026-01-29T14:50:21.519Z
9245896 9245896 20260122152148_WLi7s NZ005Q 2026-01-23T14:03:58.577Z 2026-01-29T14:50:21.259Z
9245821 9245821 20260122144605_KzA1z NZ005Q 2026-01-23T14:03:36.575Z 2026-01-29T14:50:15.029Z
9245792 9245792 20260122143128_w07A8 NZ005Q 2026-01-23T14:03:30.433Z 2026-01-29T14:50:12.795Z
9245790 9245790 20260122143045_sGe9A NZ005Q 2026-01-23T14:03:30.075Z 2026-01-29T14:50:12.632Z
9245762 9245762 20260122141555_H94Vg NZ005Q 2026-01-23T14:03:24.003Z 2026-01-29T14:50:09.792Z
9245752 9245752 20260122141111_NCgUs NZ005Q 2026-01-23T14:03:17.272Z 2026-01-29T14:50:08.312Z
9245667 9245667 20260122133728_Y73CK NZ005Q 2026-01-23T14:02:55.373Z 2026-01-29T14:49:53.768Z
9245641 9245641 20260122133038_EUp5t NZ005Q 2026-01-23T14:02:50.348Z 2026-01-29T14:49:52.653Z
9245532 9245532 20260122125420_6ZVsg NZ005Q 2026-01-23T14:02:17.943Z 2026-01-29T14:49:45.339Z
9245493 9245493 20260122124629_VA26s NZ005Q 2026-01-23T14:02:12.150Z 2026-01-29T14:49:43.695Z
9245484 9245484 20260122124052_aDhUN NZ005Q 2026-01-23T14:02:10.658Z 2026-01-29T14:49:43.354Z
9245449 9245449 20260122122635_DcbyN NZ005Q 2026-01-23T14:01:59.420Z 2026-01-29T14:49:40.187Z
9245393 9245393 20260122121156_GpaFs NZ005Q 2026-01-23T14:01:49.310Z 2026-01-29T14:49:30.237Z
9245362 9245362 20260122115741_LDtoE NZ005Q 2026-01-23T14:01:42.245Z 2026-01-29T14:49:26.474Z
9245357 9245357 20260122115646_M10bY NZ005Q 2026-01-23T14:01:41.160Z 2026-01-29T14:49:25.918Z
9245340 9245340 20260122114909_pnJUW NZ005Q 2026-01-23T14:01:31.416Z 2026-01-29T14:49:24.620Z
9245338 9245338 20260122114843_ELk7Y NZ005Q 2026-01-23T14:01:31.047Z 2026-01-29T14:49:24.454Z
9245239 9245239 20260122112347_VV62y NZ005Q 2026-01-23T14:01:09.898Z 2026-01-29T14:49:17.042Z
9245160 9245160 20260122104447_SuWsM NZ005Q 2026-01-23T14:00:49.834Z 2026-01-29T14:49:10.116Z
9245110 9245110 20260122101441_IZI6m NZ005Q 2026-01-23T14:00:35.520Z 2026-01-29T14:49:01.904Z
9245067 9245067 20260122095145_0k9Ym NZ005Q 2026-01-23T14:00:22.745Z 2026-01-29T14:48:55.685Z
9205928 9205928 20260115125032_oqtzY NZ005Q 2026-01-16T14:00:51.868Z 2026-01-24T15:08:40.558Z
9197288 9197288 20260113104259_ZPqmU NZ005Q 2026-01-14T14:22:15.733Z 2026-01-21T15:06:16.326Z
9197286 9197286 20260113104213_T8p2E NZ005Q 2026-01-14T14:22:15.077Z 2026-01-21T15:06:16.282Z
9197117 9197117 20260113101307_bmk8g NZ005Q 2026-01-14T14:21:33.317Z 2026-01-21T15:06:14.234Z
9196963 9196963 20260113094700_myquS NZ005Q 2026-01-14T14:20:52.145Z 2026-01-21T15:06:11.661Z
9185375 9185375 20260111141033_FQvHL NZ005Q 2026-01-12T14:23:09.296Z 2026-01-19T15:22:27.805Z
9185365 9185365 20260111140830_rpmGX NZ005Q 2026-01-12T14:23:07.251Z 2026-01-19T15:22:23.163Z
9185335 9185335 20260111135705_EpOgf NZ005Q 2026-01-12T14:23:03.000Z 2026-01-19T15:22:06.696Z
9185327 9185327 20260111135640_5Ivej NZ005Q 2026-01-12T14:23:02.632Z 2026-01-19T15:22:06.340Z
9185273 9185273 20260111134418_1Cjnn NZ005Q 2026-01-12T14:22:56.206Z 2026-01-19T15:22:01.940Z
9185260 9185260 20260111134033_L9yFZ NZ005Q 2026-01-12T14:22:53.738Z 2026-01-19T15:22:00.972Z
9185165 9185165 20260111131501_HaDe4 NZ005Q 2026-01-12T14:22:37.181Z 2026-01-19T15:21:53.449Z
9185157 9185157 20260111131356_MYM19 NZ005Q 2026-01-12T14:22:36.065Z 2026-01-19T15:21:52.793Z
9185061 9185061 20260111130314_HYXre NZ005Q 2026-01-12T14:22:20.352Z 2026-01-19T15:21:47.643Z
9185017 9185017 20260111125647_qp2Ow NZ005Q 2026-01-12T14:22:12.065Z 2026-01-19T15:21:45.617Z
9185004 9185004 20260111125558_9jbHB NZ005Q 2026-01-12T14:22:10.918Z 2026-01-19T15:21:45.003Z
9184862 9184862 20260111122900_YXGfJ NZ005Q 2026-01-12T14:21:46.782Z 2026-01-19T15:21:18.916Z
9184729 9184729 20260111121252_Y9HyY NZ005Q 2026-01-12T14:21:27.684Z 2026-01-19T15:21:10.640Z
9184694 9184694 20260111121004_qByka NZ005Q 2026-01-12T14:21:19.799Z 2026-01-19T15:21:09.271Z
9184619 9184619 20260111115823_WrWl2 NZ005Q 2026-01-12T14:21:08.708Z 2026-01-19T15:21:05.816Z
9184390 9184390 20260111112148_0NPKy NZ005Q 2026-01-12T14:20:25.700Z 2026-01-19T15:20:55.494Z
9184383 9184383 20260111112005_cjqJ2 NZ005Q 2026-01-12T14:20:25.140Z 2026-01-19T15:20:55.117Z
9184341 9184341 20260111111416_ML03L NZ005Q 2026-01-12T14:20:17.926Z 2026-01-19T15:20:35.144Z
9184228 9184228 20260111105802_MjWAj NZ005Q 2026-01-12T14:20:03.633Z 2026-01-19T15:20:28.230Z

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