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

113 rows where station_code = "NZ006Q" 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
9611884 9611884 20260330173107_HwvOp NZ006Q 2026-04-06T12:32:55.141Z 2026-04-08T12:44:23.371Z
9611877 9611877 20260331111151_IS28Q NZ006Q 2026-04-06T12:27:22.506Z 2026-04-09T12:46:40.517Z
9611839 9611839 20260403153651_NlY7g NZ006Q 2026-04-06T12:18:58.108Z 2026-04-10T12:32:22.576Z
9611837 9611837 20260403152705_Lp3MU NZ006Q 2026-04-06T12:18:56.773Z 2026-04-10T12:32:22.376Z
9610350 9610350 20260405165025_2TOzl NZ006Q 2026-04-06T12:07:17.422Z 2026-04-10T12:27:05.057Z
9568645 9568645 20260323170851_5GImj NZ006Q 2026-03-24T12:15:27.377Z 2026-03-31T12:28:39.632Z
9567265 9567265 20260323150023_ZI93q NZ006Q 2026-03-24T12:13:18.737Z 2026-03-31T12:28:11.538Z
9567225 9567225 20260323145412_B4Nj7 NZ006Q 2026-03-24T12:13:14.551Z 2026-03-31T12:28:10.627Z
9565046 9565046 20260323114055_oW2VR NZ006Q 2026-03-24T12:09:18.759Z 2026-03-31T12:27:21.822Z
9564857 9564857 20260323111330_Um8ca NZ006Q 2026-03-24T12:08:54.117Z 2026-03-31T12:27:16.500Z
9559188 9559188 20260321164506_LXLCF NZ006Q 2026-03-23T12:10:57.011Z 2026-03-29T12:20:35.013Z
9558899 9558899 20260321160317_sdAlN NZ006Q 2026-03-23T12:10:39.042Z 2026-03-29T12:20:31.528Z
9557462 9557462 20260322140642_XE1jp NZ006Q 2026-03-23T12:05:51.135Z 2026-03-30T12:29:38.507Z
9557148 9557148 20260322130440_Y3eFi NZ006Q 2026-03-23T12:05:38.690Z 2026-03-30T12:29:30.142Z
9557120 9557120 20260322125728_VKyob NZ006Q 2026-03-23T12:05:37.114Z 2026-03-30T12:29:29.130Z
9556255 9556255 20260322094533_0bn3Z NZ006Q 2026-03-23T12:04:34.266Z 2026-03-30T12:28:54.465Z
9556048 9556048 20260322090750_IB2Bc NZ006Q 2026-03-23T12:04:16.893Z 2026-03-30T12:28:42.531Z
9555681 9555681 20260322072847_cAMFS NZ006Q 2026-03-23T12:03:46.403Z 2026-03-30T12:28:32.139Z
9550410 9550410 20260320163720_xEE2Y NZ006Q 2026-03-22T12:25:13.855Z 2026-03-28T12:36:30.535Z
9548781 9548781 20260321153339_989s7 NZ006Q 2026-03-22T12:15:57.639Z 2026-03-29T12:20:28.810Z
9548602 9548602 20260321151730_UcK5S NZ006Q 2026-03-22T12:15:38.910Z 2026-03-29T12:20:27.459Z
9548183 9548183 20260321143913_UxJoe NZ006Q 2026-03-22T12:15:00.744Z 2026-03-22T12:27:38.627Z
9548031 9548031 20260321142626_9BNlZ NZ006Q 2026-03-22T12:14:46.609Z 2026-03-29T12:20:23.535Z
9548029 9548029 20260321142626_lIPh4 NZ006Q 2026-03-22T12:14:46.549Z 2026-03-29T12:20:23.534Z
9545952 9545952 20260321112624_jPBfH NZ006Q 2026-03-22T12:10:43.055Z 2026-03-29T12:19:46.040Z
9545491 9545491 20260321103947_MZUv3 NZ006Q 2026-03-22T12:09:32.204Z 2026-03-29T12:19:40.565Z
9539776 9539776 20260320164905_8N0SM NZ006Q 2026-03-21T12:20:11.570Z 2026-03-28T12:36:32.173Z
9539721 9539721 20260320162758_WJ4fl NZ006Q 2026-03-21T12:20:05.447Z 2026-03-28T12:36:29.226Z
9539681 9539681 20260320160507_Dkpuu NZ006Q 2026-03-21T12:19:59.934Z 2026-03-28T12:36:26.716Z
9538935 9538935 20260320135747_H25LL NZ006Q 2026-03-21T12:18:36.949Z 2026-03-28T12:35:54.858Z
9538656 9538656 20260320133002_lR8WJ NZ006Q 2026-03-21T12:18:06.540Z 2026-03-21T12:30:06.550Z
9538602 9538602 20260320132239_Fd43F NZ006Q 2026-03-21T12:18:00.701Z 2026-03-21T12:30:06.524Z
9538511 9538511 20260320131501_XkZYK NZ006Q 2026-03-21T12:17:52.910Z 2026-03-28T12:35:49.291Z
9538054 9538054 20260320122844_VPHJC NZ006Q 2026-03-21T12:17:00.599Z 2026-03-21T12:30:06.355Z
9537662 9537662 20260320115411_1btK3 NZ006Q 2026-03-21T12:16:12.792Z 2026-03-28T12:35:28.103Z
9537183 9537183 20260320111242_Lksrh NZ006Q 2026-03-21T12:15:13.561Z 2026-03-28T12:35:22.800Z
9537179 9537179 20260320111242_43Lgc NZ006Q 2026-03-21T12:15:13.297Z 2026-03-28T12:35:22.773Z
9537073 9537073 20260320110308_V10lE NZ006Q 2026-03-21T12:15:01.451Z 2026-03-28T12:35:20.930Z
9536968 9536968 20260320105339_ujGN1 NZ006Q 2026-03-21T12:14:47.914Z 2026-03-28T12:35:19.538Z
9536308 9536308 20260320093145_ymEY3 NZ006Q 2026-03-21T12:13:04.437Z 2026-03-28T12:34:59.460Z
9536256 9536256 20260320092750_HPKxf NZ006Q 2026-03-21T12:12:55.404Z 2026-03-28T12:34:59.013Z
9527720 9527720 20260318150837_Pd4RF NZ006Q 2026-03-20T12:21:40.148Z 2026-03-26T12:38:30.855Z
9527045 9527045 20260318135128_gYmL1 NZ006Q 2026-03-20T12:20:57.062Z 2026-03-26T12:38:25.527Z
9526701 9526701 20260319172200_EtqKY NZ006Q 2026-03-20T12:15:28.400Z 2026-03-27T12:42:29.539Z
9526657 9526657 20260319171321_UwUIZ NZ006Q 2026-03-20T12:15:25.928Z 2026-03-27T12:42:29.021Z
9526527 9526527 20260319165423_8RrZt NZ006Q 2026-03-20T12:15:18.879Z 2026-03-20T12:25:26.446Z
9526469 9526469 20260319164554_svwb6 NZ006Q 2026-03-20T12:15:15.120Z 2026-03-27T12:42:26.470Z
9526424 9526424 20260319163956_ux36X NZ006Q 2026-03-20T12:15:12.792Z 2026-03-27T12:42:26.183Z
9526338 9526338 20260319162847_ga1ir NZ006Q 2026-03-20T12:15:07.428Z 2026-03-20T12:25:26.380Z
9526254 9526254 20260319161459_4NeN0 NZ006Q 2026-03-20T12:14:58.300Z 2026-03-27T12:42:24.302Z
9526195 9526195 20260319161003_MfgZv NZ006Q 2026-03-20T12:14:55.497Z 2026-03-27T12:42:23.838Z
9526192 9526192 20260319161003_NJSo2 NZ006Q 2026-03-20T12:14:55.345Z 2026-03-27T12:42:23.804Z
9526175 9526175 20260319160925_W82g7 NZ006Q 2026-03-20T12:14:54.270Z 2026-03-27T12:42:23.725Z
9526094 9526094 20260319155833_AjJ2C NZ006Q 2026-03-20T12:14:49.531Z 2026-03-27T12:42:23.079Z
9525952 9525952 20260319153435_2By42 NZ006Q 2026-03-20T12:14:42.265Z 2026-03-27T12:42:21.346Z
9525855 9525855 20260319152638_RkXgV NZ006Q 2026-03-20T12:14:38.205Z 2026-03-27T12:42:20.595Z
9525698 9525698 20260319150734_4xUIf NZ006Q 2026-03-20T12:14:25.752Z 2026-03-27T12:42:18.870Z
9525670 9525670 20260319150518_6rN9Q NZ006Q 2026-03-20T12:14:24.975Z 2026-03-27T12:42:18.750Z
9525660 9525660 20260319150518_OcctR NZ006Q 2026-03-20T12:14:24.809Z 2026-03-27T12:42:18.521Z
9525514 9525514 20260319144317_je4di NZ006Q 2026-03-20T12:14:17.184Z 2026-03-27T12:42:04.514Z
9525484 9525484 20260319143936_KliTt NZ006Q 2026-03-20T12:14:15.529Z 2026-03-27T12:42:04.227Z
9525481 9525481 20260319143842_lOTdr NZ006Q 2026-03-20T12:14:15.307Z 2026-03-27T12:42:04.088Z
9525341 9525341 20260319141315_KtTcs NZ006Q 2026-03-20T12:14:08.514Z 2026-03-27T12:42:02.747Z
9525313 9525313 20260319140913_xTUri NZ006Q 2026-03-20T12:14:07.494Z 2026-03-27T12:42:02.619Z
9524807 9524807 20260319123727_wuWWA NZ006Q 2026-03-20T12:13:29.817Z 2026-03-27T12:41:56.715Z
9524800 9524800 20260319123707_zwmKw NZ006Q 2026-03-20T12:13:29.581Z 2026-03-27T12:41:56.656Z
9524582 9524582 20260319121442_GgFbM NZ006Q 2026-03-20T12:13:10.929Z 2026-03-27T12:41:54.460Z
9524112 9524112 20260319112116_lXjbT NZ006Q 2026-03-20T12:12:28.427Z 2026-03-27T12:41:48.761Z
9523975 9523975 20260319111044_feYqr NZ006Q 2026-03-20T12:12:19.955Z 2026-03-27T12:41:47.764Z
9523960 9523960 20260319110810_n4xEB NZ006Q 2026-03-20T12:12:18.293Z 2026-03-27T12:41:47.570Z
9523750 9523750 20260319103837_ZT2Co NZ006Q 2026-03-20T12:11:54.868Z 2026-03-27T12:41:40.461Z
9523361 9523361 20260319095216_35HXe NZ006Q 2026-03-20T12:11:15.856Z 2026-03-27T12:41:27.997Z
9523251 9523251 20260319094148_J9vKs NZ006Q 2026-03-20T12:11:08.073Z 2026-03-27T12:41:27.060Z
9523120 9523120 20260319092754_CMjdy NZ006Q 2026-03-20T12:10:53.677Z 2026-03-27T12:41:25.182Z
9523059 9523059 20260319092339_YXge5 NZ006Q 2026-03-20T12:10:48.800Z 2026-03-27T12:41:24.620Z
9522813 9522813 20260319085745_Ah0sl NZ006Q 2026-03-20T12:10:22.624Z 2026-03-27T12:41:21.826Z
9522466 9522466 20260319075344_Vux3E NZ006Q 2026-03-20T12:09:51.132Z 2026-03-27T12:41:18.495Z
9515272 9515272 20260318131154_M2UtQ NZ006Q 2026-03-19T12:19:30.068Z 2026-03-19T12:27:30.908Z
9515077 9515077 20260318123907_cs2zu NZ006Q 2026-03-19T12:19:00.278Z 2026-03-19T12:27:30.863Z
9514012 9514012 20260318103428_cllKd NZ006Q 2026-03-19T12:16:39.613Z 2026-03-26T12:38:13.380Z
9513807 9513807 20260318100512_QrGM3 NZ006Q 2026-03-19T12:16:14.799Z 2026-03-26T12:38:07.517Z
9512887 9512887 20260318075931_F52o9 NZ006Q 2026-03-19T12:13:47.858Z 2026-03-26T12:37:49.634Z
9505999 9505999 20260317164951_03jQ0 NZ006Q 2026-03-18T12:11:15.098Z 2026-03-25T12:42:32.722Z
9505849 9505849 20260317161357_CMM8y NZ006Q 2026-03-18T12:10:58.454Z 2026-03-25T12:42:31.849Z
9505709 9505709 20260317153526_EgtQj NZ006Q 2026-03-18T12:10:42.304Z 2026-03-25T12:42:30.932Z
9505084 9505084 20260317132121_HndUl NZ006Q 2026-03-18T12:09:30.072Z 2026-03-25T12:42:26.387Z
9505065 9505065 20260317131619_AKwoX NZ006Q 2026-03-18T12:09:27.336Z 2026-03-25T12:42:26.121Z
9505059 9505059 20260317131556_ZhUdS NZ006Q 2026-03-18T12:09:26.960Z 2026-03-25T12:42:26.094Z
9504888 9504888 20260317124144_Elk2o NZ006Q 2026-03-18T12:09:07.809Z 2026-03-25T12:42:25.315Z
9504377 9504377 20260317112841_3Y8Kw NZ006Q 2026-03-18T12:07:53.603Z 2026-03-25T12:42:21.301Z
9504023 9504023 20260317102844_6kmbR NZ006Q 2026-03-18T12:07:00.041Z 2026-03-25T12:42:19.252Z
9503722 9503722 20260317093757_4D6D2 NZ006Q 2026-03-18T12:06:19.743Z 2026-03-25T12:42:17.512Z
9503669 9503669 20260317093000_QglrP NZ006Q 2026-03-18T12:06:12.125Z 2026-03-25T12:42:17.187Z
9503379 9503379 20260317083852_lElO6 NZ006Q 2026-03-18T12:05:29.179Z 2026-03-25T12:42:15.580Z
9491284 9491284 20260315163205_cPLJ0 NZ006Q 2026-03-16T12:20:42.613Z 2026-03-23T12:22:39.096Z
9486509 9486509 20260315074753_ilnK1 NZ006Q 2026-03-16T12:10:09.097Z 2026-03-23T12:22:00.095Z
9482619 9482619 20260314172834_l953r NZ006Q 2026-03-15T12:19:53.093Z 2026-03-22T12:42:48.475Z
9482432 9482432 20260314170652_1t1x3 NZ006Q 2026-03-15T12:19:39.266Z 2026-03-22T12:42:47.968Z
9482063 9482063 20260314162551_i4CXD NZ006Q 2026-03-15T12:18:58.681Z 2026-03-22T12:42:46.569Z
9481967 9481967 20260314161328_Xjbg9 NZ006Q 2026-03-15T12:18:50.329Z 2026-03-22T12:42:46.315Z

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