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

7,791 rows where station_code = "NZ002Y" 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
9270603 9270603 20260128161109_LTH7i NZ002Y 2026-01-29T14:12:56.257Z 2026-01-29T14:12:56.257Z
9270595 9270595 20260128160924_ImpKX NZ002Y 2026-01-29T14:12:54.171Z 2026-01-29T14:12:54.171Z
9270580 9270580 20260128160739_zNFmK NZ002Y 2026-01-29T14:12:51.501Z 2026-01-29T14:12:51.501Z
9270529 9270529 20260128155810_jrsJ2 NZ002Y 2026-01-29T14:12:32.576Z 2026-01-29T14:12:32.576Z
9270367 9270367 20260128153946_TGSio NZ002Y 2026-01-29T14:11:57.274Z 2026-01-29T14:11:57.274Z
9270349 9270349 20260128153515_AWUyr NZ002Y 2026-01-29T14:11:50.702Z 2026-01-29T14:11:50.702Z
9269970 9269970 20260128143811_ng788 NZ002Y 2026-01-29T14:10:22.306Z 2026-01-29T14:10:22.306Z
9269830 9269830 20260128141926_LvMGz NZ002Y 2026-01-29T14:09:47.761Z 2026-01-29T14:09:47.761Z
9269740 9269740 20260128140416_T2Hrq NZ002Y 2026-01-29T14:09:23.117Z 2026-01-29T14:09:23.117Z
9269707 9269707 20260128135822_M3cpk NZ002Y 2026-01-29T14:09:09.232Z 2026-01-29T14:09:09.232Z
9269603 9269603 20260128134414_rKAJp NZ002Y 2026-01-29T14:08:42.613Z 2026-01-29T14:08:42.613Z
9269589 9269589 20260128133957_4qAYK NZ002Y 2026-01-29T14:08:39.122Z 2026-01-29T14:08:39.122Z
9269535 9269535 20260128132957_wbiNU NZ002Y 2026-01-29T14:08:24.504Z 2026-01-29T14:08:24.504Z
9269366 9269366 20260128130749_wrvYi NZ002Y 2026-01-29T14:07:35.246Z 2026-01-29T14:07:35.246Z
9269334 9269334 20260128130314_zWEtF NZ002Y 2026-01-29T14:07:29.237Z 2026-01-29T14:07:29.237Z
9269221 9269221 20260128124612_os2YS NZ002Y 2026-01-29T14:07:02.451Z 2026-01-29T14:07:02.451Z
9269116 9269116 20260128123216_Fz1qU NZ002Y 2026-01-29T14:06:35.360Z 2026-01-29T14:06:35.360Z
9269101 9269101 20260128122733_ITjjZ NZ002Y 2026-01-29T14:06:31.308Z 2026-01-29T14:06:31.308Z
9269032 9269032 20260128120703_n3uZT NZ002Y 2026-01-29T14:06:06.582Z 2026-01-29T14:06:06.582Z
9268967 9268967 20260128115534_M1CTq NZ002Y 2026-01-29T14:05:46.081Z 2026-01-29T14:05:46.081Z
9268836 9268836 20260128113134_Nce10 NZ002Y 2026-01-29T14:05:07.926Z 2026-01-29T14:05:07.926Z
9268711 9268711 20260128110632_gA1tm NZ002Y 2026-01-29T14:04:28.814Z 2026-01-29T14:04:28.814Z
9268464 9268464 20260128102439_wotx8 NZ002Y 2026-01-29T14:03:14.836Z 2026-01-29T14:03:14.836Z
9268157 9268157 20260128090605_Onh32 NZ002Y 2026-01-29T14:01:26.245Z 2026-01-29T14:01:26.245Z
9268101 9268101 20260128084859_j6pD3 NZ002Y 2026-01-29T14:01:06.100Z 2026-01-29T14:01:06.100Z
9265439 9265439 20260127151627_2nLxx NZ002Y 2026-01-28T14:10:11.220Z 2026-01-29T14:30:24.550Z
9265282 9265282 20260127145528_93wPr NZ002Y 2026-01-28T14:09:44.610Z 2026-01-29T14:30:24.520Z
9265157 9265157 20260127142558_4O8Ww NZ002Y 2026-01-28T14:09:15.044Z 2026-01-29T14:30:24.470Z
9264978 9264978 20260127134612_glDix NZ002Y 2026-01-28T14:08:28.522Z 2026-01-29T14:30:24.404Z
9264960 9264960 20260127134130_BSqsA NZ002Y 2026-01-28T14:08:23.517Z 2026-01-29T14:30:24.400Z
9264933 9264933 20260127133931_GDtEN NZ002Y 2026-01-28T14:08:19.042Z 2026-01-29T14:30:24.395Z
9264721 9264721 20260127130158_393A7 NZ002Y 2026-01-28T14:07:21.212Z 2026-01-29T14:30:24.263Z
9264676 9264676 20260127125436_LiB0z NZ002Y 2026-01-28T14:07:07.997Z 2026-01-29T14:30:24.252Z
9264627 9264627 20260127125112_hPvbC NZ002Y 2026-01-28T14:06:57.295Z 2026-01-29T14:30:24.232Z
9264591 9264591 20260127124904_B4bCv NZ002Y 2026-01-28T14:06:47.822Z 2026-01-29T14:30:24.225Z
9264484 9264484 20260127123056_ivTDl NZ002Y 2026-01-28T14:06:18.741Z 2026-01-29T14:30:24.183Z
9250470 9250470 20260123152446_abE3b NZ002Y 2026-01-24T14:03:07.134Z 2026-01-29T14:45:37.743Z
9250079 9250079 20260123100651_90ewM NZ002Y 2026-01-24T14:01:02.147Z 2026-01-29T14:44:57.449Z
9186351 9186351 20260112142501_Cms3c NZ002Y 2026-01-13T14:01:34.912Z 2026-01-21T15:02:22.699Z
9186131 9186131 20260112135258_TFn3J NZ002Y 2026-01-13T14:00:27.000Z 2026-01-21T15:02:12.346Z
9185455 9185455 20260111111229_IGNy2 NZ002Y 2026-01-12T14:24:57.068Z 2026-01-19T15:20:33.401Z
9185453 9185453 20260111111213_P7EqN NZ002Y 2026-01-12T14:24:55.827Z 2026-01-19T15:20:33.286Z
9183549 9183549 20260111094228_JC0lr NZ002Y 2026-01-12T14:18:06.536Z 2026-01-19T15:19:45.456Z
9183477 9183477 20260111093408_JsZII NZ002Y 2026-01-12T14:17:53.634Z 2026-01-12T14:17:53.634Z
9170547 9170547 20260109154121_Yk3Cq NZ002Y 2026-01-10T14:01:13.816Z 2026-01-18T15:06:27.553Z
9169483 9169483 20260108144324_USJMB NZ002Y 2026-01-09T14:13:40.565Z 2026-01-16T15:14:02.067Z
9169285 9169285 20260108140304_Ezk2a NZ002Y 2026-01-09T14:13:11.456Z 2026-01-16T15:13:49.218Z
9169175 9169175 20260108133620_3aC42 NZ002Y 2026-01-09T14:12:54.613Z 2026-01-16T15:13:34.065Z
9169046 9169046 20260108131039_W92nV NZ002Y 2026-01-09T14:12:39.734Z 2026-01-16T15:13:27.073Z
9168950 9168950 20260108125321_He2d0 NZ002Y 2026-01-09T14:12:26.313Z 2026-01-16T15:13:23.066Z
9168805 9168805 20260108122232_LBaPp NZ002Y 2026-01-09T14:12:03.731Z 2026-01-16T15:13:08.343Z
9168774 9168774 20260108121223_y0t2X NZ002Y 2026-01-09T14:11:59.559Z 2026-01-16T15:13:03.278Z
9165274 9165274 20260107152401_7mbW3 NZ002Y 2026-01-08T14:15:55.315Z 2026-01-13T15:05:38.041Z
9165164 9165164 20260107151320_Rl3sm NZ002Y 2026-01-08T14:15:35.031Z 2026-01-13T15:05:31.999Z
9164828 9164828 20260107143114_2AiPQ NZ002Y 2026-01-08T14:14:28.518Z 2026-01-13T15:05:07.539Z
9164544 9164544 20260107134146_fhKyF NZ002Y 2026-01-08T14:13:33.432Z 2026-01-13T15:04:51.079Z
9164470 9164470 20260107132546_nbRO3 NZ002Y 2026-01-08T14:13:17.297Z 2026-01-13T15:04:39.030Z
9164455 9164455 20260107132212_1z1BX NZ002Y 2026-01-08T14:13:14.885Z 2026-01-13T15:04:38.332Z
9164335 9164335 20260107125122_x2xg8 NZ002Y 2026-01-08T14:12:46.819Z 2026-01-13T15:04:28.179Z
9164331 9164331 20260107125002_OX9Fi NZ002Y 2026-01-08T14:12:46.301Z 2026-01-13T15:04:27.840Z
9160863 9160863 20260106091642_jQtPj NZ002Y 2026-01-07T14:14:09.802Z 2026-01-13T15:09:57.093Z
9148433 9148433 20251231153410_0QHbq NZ002Y 2026-01-05T14:49:53.063Z 2026-01-08T15:14:46.844Z
9118531 9118531 20251231153613_wPkBC NZ002Y 2026-01-01T14:35:49.866Z 2026-01-08T15:14:47.500Z
9105309 9105309 20251230103625_spep7 NZ002Y 2025-12-31T14:24:38.459Z 2026-01-07T15:10:41.725Z
9096936 9096936 20251227151928_yR162 NZ002Y 2025-12-30T15:08:04.392Z 2026-01-04T15:33:28.212Z
9096363 9096363 20251227144507_wPdiB NZ002Y 2025-12-30T15:07:24.861Z 2026-01-04T15:33:12.276Z
9096176 9096176 20251227143456_W2B9V NZ002Y 2025-12-30T15:07:16.857Z 2026-01-04T15:32:55.369Z
9095915 9095915 20251227141729_GH5El NZ002Y 2025-12-30T15:07:05.663Z 2026-01-04T15:32:46.713Z
9095885 9095885 20251227141553_hT75S NZ002Y 2025-12-30T15:07:04.523Z 2026-01-04T15:32:46.115Z
9095570 9095570 20251227140008_OnVgL NZ002Y 2025-12-30T15:06:38.177Z 2026-01-04T15:32:37.945Z
9095362 9095362 20251227134539_4heis NZ002Y 2025-12-30T15:06:29.785Z 2026-01-04T15:32:32.854Z
9095343 9095343 20251227134500_Qx9Dh NZ002Y 2025-12-30T15:06:29.251Z 2026-01-04T15:32:32.441Z
9095268 9095268 20251227134115_rxAh2 NZ002Y 2025-12-30T15:06:26.525Z 2026-01-04T15:32:30.385Z
9094900 9094900 20251227131206_48SHp NZ002Y 2025-12-30T15:05:56.474Z 2026-01-04T15:32:08.281Z
9094534 9094534 20251227123342_ONthA NZ002Y 2025-12-30T15:05:27.284Z 2026-01-04T15:31:46.579Z
9093886 9093886 20251227110037_0eVsp NZ002Y 2025-12-30T15:04:29.236Z 2026-01-04T15:31:14.623Z
9093847 9093847 20251227105225_IIvxG NZ002Y 2025-12-30T15:04:26.347Z 2026-01-04T15:31:13.289Z
9093717 9093717 20251227103334_Rcopp NZ002Y 2025-12-30T15:04:18.563Z 2026-01-04T15:31:07.366Z
9093606 9093606 20251227101138_wBl4f NZ002Y 2025-12-30T15:03:59.504Z 2025-12-30T15:03:59.504Z
9093561 9093561 20251227095846_6UNgl NZ002Y 2025-12-30T15:03:55.076Z 2026-01-04T15:31:02.088Z
9093532 9093532 20251227094433_RiDE3 NZ002Y 2025-12-30T15:03:51.410Z 2026-01-04T15:31:00.862Z
9093466 9093466 20251227091241_nrZPX NZ002Y 2025-12-30T15:03:46.888Z 2026-01-04T15:30:58.574Z
9093457 9093457 20251227090803_o7WR2 NZ002Y 2025-12-30T15:03:46.360Z 2025-12-30T15:03:46.360Z
9090466 9090466 20251228151627_ZZlpu NZ002Y 2025-12-30T14:50:20.593Z 2025-12-31T14:55:56.221Z
9090391 9090391 20251228150707_L72mZ NZ002Y 2025-12-30T14:50:14.537Z 2026-01-05T15:13:09.641Z
9090149 9090149 20251228144043_HY42l NZ002Y 2025-12-30T14:49:47.979Z 2026-01-05T15:13:02.564Z
9089879 9089879 20251228140522_4brOZ NZ002Y 2025-12-30T14:49:14.583Z 2026-01-05T15:12:55.930Z
9089802 9089802 20251228135237_PetWh NZ002Y 2025-12-30T14:49:09.365Z 2026-01-05T15:12:54.313Z
9089564 9089564 20251228132348_vdZ7J NZ002Y 2025-12-30T14:48:41.893Z 2026-01-05T15:12:47.912Z
9089366 9089366 20251228131159_DHY6N NZ002Y 2025-12-30T14:48:20.624Z 2026-01-05T15:12:30.384Z
9089307 9089307 20251228130824_V2j3q NZ002Y 2025-12-30T14:48:14.667Z 2026-01-05T15:12:28.779Z
9087728 9087728 20251228102214_7E2dW NZ002Y 2025-12-30T14:44:49.709Z 2026-01-05T15:11:28.274Z
9087570 9087570 20251228095635_5uezH NZ002Y 2025-12-30T14:44:22.016Z 2026-01-05T15:11:12.057Z
9070169 9070169 20251226152532_1mZZ0 NZ002Y 2025-12-29T14:47:22.237Z 2026-01-03T15:41:35.946Z
9069803 9069803 20251226143959_YCrll NZ002Y 2025-12-29T14:46:43.457Z 2026-01-03T15:41:12.354Z
9069599 9069599 20251226142245_AXkQk NZ002Y 2025-12-29T14:46:17.091Z 2025-12-30T15:21:37.589Z
9069521 9069521 20251226141304_dky7s NZ002Y 2025-12-29T14:46:12.409Z 2026-01-03T15:40:52.208Z
9069445 9069445 20251226140439_Mz3Zq NZ002Y 2025-12-29T14:46:07.477Z 2026-01-03T15:40:48.326Z
9069350 9069350 20251226135233_L32nD NZ002Y 2025-12-29T14:46:02.007Z 2026-01-03T15:40:43.649Z
9069216 9069216 20251226133451_cZYR2 NZ002Y 2025-12-29T14:45:37.649Z 2026-01-03T15:40:39.911Z

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