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,647 rows where station_code = "NZ001A" 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
9305756 9305756 20260208160756_pux1D NZ001A 2026-02-09T14:13:32.205Z 2026-02-16T14:53:18.848Z
9305746 9305746 20260208160711_r592Q NZ001A 2026-02-09T14:13:30.379Z 2026-02-16T14:53:17.555Z
9305459 9305459 20260208145144_hb7je NZ001A 2026-02-09T14:12:13.938Z 2026-02-16T14:52:36.304Z
9305438 9305438 20260208144818_tJsGm NZ001A 2026-02-09T14:12:08.871Z 2026-02-16T14:52:34.192Z
9305416 9305416 20260208143749_djuHA NZ001A 2026-02-09T14:12:02.523Z 2026-02-16T14:52:26.731Z
9305393 9305393 20260208143138_jsPgi NZ001A 2026-02-09T14:11:55.543Z 2026-02-16T14:52:24.745Z
9305368 9305368 20260208141919_Noz2R NZ001A 2026-02-09T14:11:48.554Z 2026-02-16T14:52:20.085Z
9305215 9305215 20260208131808_Mu61p NZ001A 2026-02-09T14:11:12.780Z 2026-02-16T14:52:05.822Z
9305184 9305184 20260208130925_6xjMf NZ001A 2026-02-09T14:11:04.398Z 2026-02-16T14:51:59.038Z
9305117 9305117 20260208125525_r5Ev3 NZ001A 2026-02-09T14:10:49.247Z 2026-02-16T14:51:51.846Z
9304464 9304464 20260208104604_T4ZF2 NZ001A 2026-02-09T14:08:02.107Z 2026-02-16T14:50:48.318Z
9301333 9301333 20260207162647_7G5D3 NZ001A 2026-02-08T14:12:47.462Z 2026-02-16T14:59:01.511Z
9299198 9299198 20260207090133_1ALi9 NZ001A 2026-02-08T14:04:04.157Z 2026-02-16T14:56:13.665Z
9295952 9295952 20260206105619_k3fTr NZ001A 2026-02-07T14:06:30.239Z 2026-02-15T14:57:06.712Z
9295830 9295830 20260206104139_9pBtf NZ001A 2026-02-07T14:05:58.642Z 2026-02-15T14:57:00.738Z
9295258 9295258 20260206085537_y3TV8 NZ001A 2026-02-07T14:03:11.921Z 2026-02-15T14:56:14.593Z
9293720 9293720 20260205151512_ok3Yv NZ001A 2026-02-06T14:11:03.196Z 2026-02-14T15:04:59.684Z
9293662 9293662 20260205144210_6LRwp NZ001A 2026-02-06T14:10:46.905Z 2026-02-14T15:04:54.244Z
9293530 9293530 20260205135114_LxrzJ NZ001A 2026-02-06T14:10:06.836Z 2026-02-14T15:04:39.026Z
9293501 9293501 20260205134349_IMn2f NZ001A 2026-02-06T14:09:58.793Z 2026-02-14T15:04:37.041Z
9290418 9290418 20260204140352_3USU0 NZ001A 2026-02-05T14:09:44.786Z 2026-02-13T14:55:45.049Z
9290399 9290399 20260204135922_r2u0w NZ001A 2026-02-05T14:09:39.724Z 2026-02-13T14:55:43.170Z
9290381 9290381 20260204135358_PiamT NZ001A 2026-02-05T14:09:35.650Z 2026-02-13T14:55:39.062Z
9290359 9290359 20260204134117_TgA1S NZ001A 2026-02-05T14:09:27.821Z 2026-02-13T14:55:37.057Z
9290329 9290329 20260204133240_jbxMN NZ001A 2026-02-05T14:09:20.157Z 2026-02-13T14:55:35.264Z
9290297 9290297 20260204132606_VQ6Ji NZ001A 2026-02-05T14:09:12.230Z 2026-02-13T14:55:32.735Z
9290280 9290280 20260204131754_42xzM NZ001A 2026-02-05T14:09:07.477Z 2026-02-13T14:55:31.073Z
9290163 9290163 20260204124819_iRuV3 NZ001A 2026-02-05T14:08:31.832Z 2026-02-13T14:55:16.764Z
9289832 9289832 20260204113500_tggz5 NZ001A 2026-02-05T14:06:55.918Z 2026-02-13T14:54:41.831Z
9289553 9289553 20260204103508_z5yId NZ001A 2026-02-05T14:05:37.443Z 2026-02-13T14:54:14.475Z
9289516 9289516 20260204102741_Z8DIS NZ001A 2026-02-05T14:05:24.324Z 2026-02-13T14:54:11.389Z
9289462 9289462 20260204101730_QlyfA NZ001A 2026-02-05T14:05:04.212Z 2026-02-13T14:54:07.153Z
9289222 9289222 20260204091624_eXOM2 NZ001A 2026-02-05T14:03:43.956Z 2026-02-13T14:53:42.820Z
9289158 9289158 20260204090540_rvViA NZ001A 2026-02-05T14:03:20.378Z 2026-02-13T14:53:37.420Z
9286630 9286630 20260202110008_KjC2I NZ001A 2026-02-03T14:02:11.706Z 2026-02-11T14:50:12.772Z
9274159 9274159 20260129104925_ORSFJ NZ001A 2026-01-30T14:03:07.870Z 2026-02-07T14:49:42.983Z
9265928 9265928 20260127161641_h6Dlt NZ001A 2026-01-28T14:11:47.973Z 2026-02-05T14:47:34.590Z
9265829 9265829 20260127160237_Y4po0 NZ001A 2026-01-28T14:11:28.979Z 2026-02-05T14:47:30.140Z
9265714 9265714 20260127155233_C3MwB NZ001A 2026-01-28T14:11:07.248Z 2026-02-05T14:47:16.708Z
9265605 9265605 20260127153809_hV2Fm NZ001A 2026-01-28T14:10:43.219Z 2026-02-05T14:47:09.713Z
9265493 9265493 20260127152147_gWM2v NZ001A 2026-01-28T14:10:22.421Z 2026-02-05T14:47:04.910Z
9265420 9265420 20260127151344_RXUZW NZ001A 2026-01-28T14:10:08.447Z 2026-02-05T14:47:00.632Z
9265234 9265234 20260127144508_MtxGy NZ001A 2026-01-28T14:09:35.991Z 2026-02-05T14:46:46.146Z
9265072 9265072 20260127141229_L2JrK NZ001A 2026-01-28T14:08:56.273Z 2026-02-05T14:46:35.484Z
9265030 9265030 20260127135959_m6FKf NZ001A 2026-01-28T14:08:44.411Z 2026-02-05T14:46:32.548Z
9264987 9264987 20260127134631_Zc36o NZ001A 2026-01-28T14:08:31.188Z 2026-02-05T14:46:29.531Z
9264864 9264864 20260127132630_oTfWv NZ001A 2026-01-28T14:08:02.160Z 2026-02-05T14:46:16.865Z
9264821 9264821 20260127131748_9lGOt NZ001A 2026-01-28T14:07:50.620Z 2026-02-05T14:46:13.311Z
9264808 9264808 20260127131635_v2kC7 NZ001A 2026-01-28T14:07:47.979Z 2026-02-05T14:46:12.737Z
9264209 9264209 20260127113923_6fYC8 NZ001A 2026-01-28T14:04:58.170Z 2026-02-05T14:45:23.448Z
9256964 9256964 20260125112059_iyoAY NZ001A 2026-01-26T14:03:00.055Z 2026-02-03T14:43:42.808Z
9219341 9219341 20260117100140_xhF53 NZ001A 2026-01-18T14:15:59.742Z 2026-01-25T14:59:11.059Z
9217194 9217194 20260117151907_RjhUW NZ001A 2026-01-18T14:04:45.516Z 2026-01-26T15:00:00.495Z
9217185 9217185 20260117151251_1478r NZ001A 2026-01-18T14:04:42.724Z 2026-01-26T14:59:59.866Z
9216490 9216490 20260117120121_FtRlL NZ001A 2026-01-18T14:00:58.136Z 2026-01-26T14:59:16.482Z
9192962 9192962 20260112132019_l1y3R NZ001A 2026-01-13T14:29:48.163Z 2026-01-20T15:26:45.667Z
9192797 9192797 20260112130237_lU0OC NZ001A 2026-01-13T14:29:19.886Z 2026-01-20T15:26:33.753Z
9192546 9192546 20260112124231_3ixSu NZ001A 2026-01-13T14:28:37.252Z 2026-01-20T15:26:25.334Z
9192336 9192336 20260112122424_ZuF41 NZ001A 2026-01-13T14:28:05.850Z 2026-01-20T15:26:18.830Z
9186831 9186831 20260112154814_ioBlx NZ001A 2026-01-13T14:03:41.137Z 2026-01-21T15:03:02.414Z
9186807 9186807 20260112154332_S8dmu NZ001A 2026-01-13T14:03:35.077Z 2026-01-21T15:03:00.632Z
9186478 9186478 20260112144236_gRArt NZ001A 2026-01-13T14:02:13.627Z 2026-01-21T15:02:35.806Z
9186397 9186397 20260112143057_BtIiR NZ001A 2026-01-13T14:01:47.378Z 2026-01-21T15:02:28.261Z
9186215 9186215 20260112140010_vi2S2 NZ001A 2026-01-13T14:00:52.349Z 2026-01-21T15:02:13.376Z
9186182 9186182 20260112135757_HLpiP NZ001A 2026-01-13T14:00:43.397Z 2026-01-21T15:02:12.907Z
9156555 9156555 20260104113707_QGGlI NZ001A 2026-01-06T14:40:00.087Z 2026-01-12T15:12:15.383Z
9152908 9152908 20260105141936_Eql2v NZ001A 2026-01-06T14:18:51.659Z 2026-01-13T15:16:36.682Z
9097033 9097033 20251227152427_7DeRA NZ001A 2025-12-30T15:08:20.271Z 2026-01-04T15:33:30.205Z
9096657 9096657 20251227145901_TY9HJ NZ001A 2025-12-30T15:07:52.013Z 2026-01-04T15:33:19.863Z
9096318 9096318 20251227144321_W9CPP NZ001A 2025-12-30T15:07:23.331Z 2026-01-04T15:33:11.201Z
9095997 9095997 20251227142406_Hd2IU NZ001A 2025-12-30T15:07:09.680Z 2026-01-04T15:32:49.565Z
9095749 9095749 20251227140826_djAEf NZ001A 2025-12-30T15:06:47.743Z 2026-01-04T15:32:42.932Z
9095548 9095548 20251227135611_5WhqZ NZ001A 2025-12-30T15:06:36.537Z 2026-01-04T15:32:37.037Z
9095542 9095542 20251227135520_APT2u NZ001A 2025-12-30T15:06:36.248Z 2026-01-04T15:32:36.765Z
9095395 9095395 20251227134738_TkL3f NZ001A 2025-12-30T15:06:31.085Z 2026-01-04T15:32:33.665Z
9095220 9095220 20251227133711_Ow0n3 NZ001A 2025-12-30T15:06:25.069Z 2026-01-04T15:32:18.582Z
9095058 9095058 20251227132720_0JiHm NZ001A 2025-12-30T15:06:04.082Z 2026-01-04T15:32:14.797Z
9094762 9094762 20251227125855_YfjpT NZ001A 2025-12-30T15:05:49.567Z 2025-12-30T15:05:49.567Z
9094588 9094588 20251227123718_Cgegq NZ001A 2025-12-30T15:05:40.902Z 2026-01-04T15:31:58.321Z
9094148 9094148 20251227114313_cRc26 NZ001A 2025-12-30T15:05:00.891Z 2025-12-30T15:05:00.891Z
9046811 9046811 20251223151040_hBNTy NZ001A 2025-12-28T14:55:39.042Z 2025-12-28T14:55:39.042Z
9046741 9046741 20251223145835_7MjKr NZ001A 2025-12-28T14:55:36.032Z 2025-12-31T15:43:30.872Z
9046468 9046468 20251223135452_xJcrc NZ001A 2025-12-28T14:54:57.785Z 2025-12-31T15:43:07.053Z
9046426 9046426 20251223134408_5y0zc NZ001A 2025-12-28T14:54:55.728Z 2025-12-28T14:54:55.728Z
9046414 9046414 20251223134024_2iTNW NZ001A 2025-12-28T14:54:54.698Z 2025-12-31T15:43:04.800Z
9046386 9046386 20251223132852_5onEv NZ001A 2025-12-28T14:54:53.532Z 2025-12-31T15:43:04.354Z
9046177 9046177 20251223124521_g7dhO NZ001A 2025-12-28T14:54:42.803Z 2025-12-28T14:54:42.803Z
9046151 9046151 20251223123909_x92UG NZ001A 2025-12-28T14:54:41.933Z 2025-12-31T15:43:01.137Z
9045979 9045979 20251223115749_bAfba NZ001A 2025-12-28T14:54:19.545Z 2025-12-31T15:42:57.474Z
9045913 9045913 20251223114838_rH3eL NZ001A 2025-12-28T14:54:08.386Z 2025-12-31T15:42:56.626Z
9021596 9021596 20251220151329_mFuFe NZ001A 2025-12-27T15:07:10.964Z 2025-12-29T15:25:50.538Z
9021582 9021582 20251220151240_bCGaD NZ001A 2025-12-27T15:07:09.053Z 2025-12-29T15:25:49.918Z
9021403 9021403 20251220144449_fXN7m NZ001A 2025-12-27T15:06:50.620Z 2025-12-29T15:25:39.793Z
9021390 9021390 20251220144244_Q0dNy NZ001A 2025-12-27T15:06:50.338Z 2025-12-29T15:25:39.668Z
9021327 9021327 20251220143221_pDtds NZ001A 2025-12-27T15:06:48.510Z 2025-12-29T15:25:38.735Z
9021303 9021303 20251220142619_2ZFt9 NZ001A 2025-12-27T15:06:47.825Z 2025-12-29T15:25:38.261Z
9021281 9021281 20251220142300_7XZWo NZ001A 2025-12-27T15:06:47.132Z 2025-12-27T15:06:47.132Z
9021264 9021264 20251220142051_efABK NZ001A 2025-12-27T15:06:45.936Z 2025-12-29T15:25:37.803Z
9020689 9020689 20251220130109_N0Vhw NZ001A 2025-12-27T15:06:30.166Z 2025-12-29T15:25:22.070Z
9020668 9020668 20251220125913_7xATr NZ001A 2025-12-27T15:06:29.513Z 2025-12-27T15:06:29.513Z

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