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

692 rows where station_code = "NZ005H" 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
9270285 9270285 20260128152654_uiTSE NZ005H 2026-01-29T14:11:34.331Z 2026-01-29T14:11:34.331Z
9270187 9270187 20260128150930_SruCA NZ005H 2026-01-29T14:11:13.844Z 2026-01-29T14:11:13.844Z
9270179 9270179 20260128150600_euhRA NZ005H 2026-01-29T14:11:12.373Z 2026-01-29T14:11:12.373Z
9270101 9270101 20260128145550_Vm12h NZ005H 2026-01-29T14:10:50.515Z 2026-01-29T14:10:50.515Z
9270028 9270028 20260128144940_e2VyS NZ005H 2026-01-29T14:10:41.152Z 2026-01-29T14:10:41.152Z
9270005 9270005 20260128144320_iMXI8 NZ005H 2026-01-29T14:10:36.919Z 2026-01-29T14:10:36.919Z
9268885 9268885 20260128113818_Cnj3s NZ005H 2026-01-29T14:05:19.017Z 2026-01-29T14:05:19.017Z
9268713 9268713 20260128110632_gA1tm NZ005H 2026-01-29T14:04:28.814Z 2026-01-29T14:04:28.814Z
9268542 9268542 20260128104340_JbBOn NZ005H 2026-01-29T14:03:37.079Z 2026-01-29T14:03:37.079Z
9268539 9268539 20260128104339_VaQwK NZ005H 2026-01-29T14:03:36.004Z 2026-01-29T14:03:36.004Z
9268489 9268489 20260128103102_L6GPu NZ005H 2026-01-29T14:03:20.839Z 2026-01-29T14:03:20.839Z
9268153 9268153 20260128090540_S3BqB NZ005H 2026-01-29T14:01:25.377Z 2026-01-29T14:01:25.377Z
9265873 9265873 20260127160815_lsoqF NZ005H 2026-01-28T14:11:38.518Z 2026-01-29T14:30:24.705Z
9265601 9265601 20260127153716_6zasJ NZ005H 2026-01-28T14:10:40.082Z 2026-01-29T14:30:24.620Z
9265548 9265548 20260127153108_RbYFU NZ005H 2026-01-28T14:10:30.584Z 2026-01-29T14:30:24.602Z
9265543 9265543 20260127153049_u0CtK NZ005H 2026-01-28T14:10:29.861Z 2026-01-29T14:30:24.602Z
9265278 9265278 20260127145426_Lu5KI NZ005H 2026-01-28T14:09:43.907Z 2026-01-29T14:30:24.520Z
9265171 9265171 20260127142911_la7mv NZ005H 2026-01-28T14:09:19.205Z 2026-01-29T14:30:24.483Z
9265063 9265063 20260127141035_BqQtj NZ005H 2026-01-28T14:08:54.048Z 2026-01-29T14:30:24.429Z
9265058 9265058 20260127141018_ZIJqp NZ005H 2026-01-28T14:08:52.697Z 2026-01-29T14:30:24.428Z
9265028 9265028 20260127135944_bhOiR NZ005H 2026-01-28T14:08:43.587Z 2026-01-29T14:30:24.419Z
9264967 9264967 20260127134306_oHIrl NZ005H 2026-01-28T14:08:25.733Z 2026-01-29T14:30:24.402Z
9264961 9264961 20260127134130_BSqsA NZ005H 2026-01-28T14:08:23.518Z 2026-01-29T14:30:24.400Z
9264732 9264732 20260127130331_Isi2V NZ005H 2026-01-28T14:07:23.930Z 2026-01-29T14:30:24.265Z
9263676 9263676 20260127094509_4WSHG NZ005H 2026-01-28T14:02:09.455Z 2026-01-29T14:30:18.023Z
9227284 9227284 20260119152627_2hyJx NZ005H 2026-01-20T14:07:31.611Z 2026-01-28T14:56:02.367Z
9227192 9227192 20260119150359_uPsWB NZ005H 2026-01-20T14:07:04.999Z 2026-01-28T14:55:56.453Z
9227076 9227076 20260119142340_ZTfMa NZ005H 2026-01-20T14:06:28.006Z 2026-01-28T14:55:50.193Z
9227046 9227046 20260119141315_U2aZO NZ005H 2026-01-20T14:06:19.617Z 2026-01-28T14:55:48.850Z
9192507 9192507 20260112123916_OT2t5 NZ005H 2026-01-13T14:28:31.024Z 2026-01-20T15:26:23.825Z
9192387 9192387 20260112122911_vgAby NZ005H 2026-01-13T14:28:12.709Z 2026-01-20T15:26:20.605Z
9191776 9191776 20260112114519_dya0L NZ005H 2026-01-13T14:26:22.402Z 2026-01-20T15:25:46.695Z
9186847 9186847 20260112155044_yM2GH NZ005H 2026-01-13T14:03:43.356Z 2026-01-21T15:03:02.893Z
9186310 9186310 20260112141555_KdJfX NZ005H 2026-01-13T14:01:21.357Z 2026-01-21T15:02:20.220Z
9173546 9173546 20260109144020_GEUzm NZ005H 2026-01-10T14:17:57.481Z 2026-01-17T15:26:48.566Z
9173251 9173251 20260109132724_5mm0a NZ005H 2026-01-10T14:16:51.945Z 2026-01-17T15:26:24.716Z
9173191 9173191 20260109131924_BSFAW NZ005H 2026-01-10T14:16:38.636Z 2026-01-17T15:26:22.793Z
9172893 9172893 20260109122307_QW7zS NZ005H 2026-01-10T14:15:19.444Z 2026-01-17T15:26:06.832Z
9172548 9172548 20260109110428_r0siZ NZ005H 2026-01-10T14:13:51.038Z 2026-01-17T15:25:40.401Z
9170479 9170479 20260109153026_9lyC2 NZ005H 2026-01-10T14:00:48.734Z 2026-01-18T15:06:24.216Z
9170421 9170421 20260109151252_Cz2ci NZ005H 2026-01-10T14:00:27.466Z 2026-01-18T15:06:20.376Z
9170410 9170410 20260109151139_NnYIR NZ005H 2026-01-10T14:00:24.040Z 2026-01-18T15:06:20.088Z
9169626 9169626 20260108150956_Epa5m NZ005H 2026-01-09T14:14:08.240Z 2026-01-16T15:14:21.140Z
9169476 9169476 20260108144232_m3ox5 NZ005H 2026-01-09T14:13:39.206Z 2026-01-16T15:14:01.595Z
9169454 9169454 20260108143706_BDC6h NZ005H 2026-01-09T14:13:36.442Z 2026-01-16T15:13:59.540Z
9169443 9169443 20260108143004_Y9ZFS NZ005H 2026-01-09T14:13:35.091Z 2026-01-16T15:13:58.950Z
9169415 9169415 20260108142701_a2Kr3 NZ005H 2026-01-09T14:13:31.326Z 2026-01-16T15:13:57.165Z
9169178 9169178 20260108133620_3aC42 NZ005H 2026-01-09T14:12:54.613Z 2026-01-16T15:13:34.065Z
9169158 9169158 20260108133043_F33wt NZ005H 2026-01-09T14:12:52.420Z 2026-01-16T15:13:33.480Z
9168951 9168951 20260108125321_He2d0 NZ005H 2026-01-09T14:12:26.313Z 2026-01-16T15:13:23.066Z
9168889 9168889 20260108123633_79KuA NZ005H 2026-01-09T14:12:17.344Z 2026-01-16T15:13:18.742Z
9168808 9168808 20260108122232_LBaPp NZ005H 2026-01-09T14:12:03.731Z 2026-01-16T15:13:08.343Z
9168787 9168787 20260108121751_F4rk7 NZ005H 2026-01-09T14:12:00.874Z 2026-01-16T15:13:04.598Z
9168777 9168777 20260108121223_y0t2X NZ005H 2026-01-09T14:11:59.559Z 2026-01-16T15:13:03.278Z
9165124 9165124 20260107150803_REdg9 NZ005H 2026-01-08T14:15:29.558Z 2026-01-13T15:05:30.002Z
9165037 9165037 20260107145458_2vuUt NZ005H 2026-01-08T14:15:11.829Z 2026-01-13T15:05:25.035Z
9164925 9164925 20260107144515_I3uyr NZ005H 2026-01-08T14:14:49.316Z 2026-01-13T15:05:19.956Z
9164858 9164858 20260107143211_oXGvE NZ005H 2026-01-08T14:14:31.371Z 2026-01-13T15:05:08.630Z
9164830 9164830 20260107143114_2AiPQ NZ005H 2026-01-08T14:14:28.518Z 2026-01-13T15:05:07.539Z
9164473 9164473 20260107132546_nbRO3 NZ005H 2026-01-08T14:13:17.297Z 2026-01-13T15:04:39.030Z
9164337 9164337 20260107125122_x2xg8 NZ005H 2026-01-08T14:12:46.819Z 2026-01-13T15:04:28.179Z
9161505 9161505 20260106134031_yhX3s NZ005H 2026-01-07T14:16:52.980Z 2026-01-13T15:10:51.304Z
9160977 9160977 20260106100807_wBj7v NZ005H 2026-01-07T14:14:39.415Z 2026-01-13T15:10:11.396Z
9156540 9156540 20260104112644_smN1Y NZ005H 2026-01-06T14:39:57.030Z 2026-01-12T15:12:14.538Z
9153012 9153012 20260105152257_ko00v NZ005H 2026-01-06T14:19:15.784Z 2026-01-13T15:16:51.150Z
9152979 9152979 20260105150406_XGIKS NZ005H 2026-01-06T14:19:08.607Z 2026-01-13T15:16:42.911Z
9152655 9152655 20260105124455_Am5mi NZ005H 2026-01-06T14:18:01.886Z 2026-01-13T15:16:11.637Z
9152651 9152651 20260105124343_DpnoV NZ005H 2026-01-06T14:18:00.750Z 2026-01-13T15:16:11.164Z
9120098 9120098 20251228113835_n2VWR NZ005H 2026-01-01T15:28:15.432Z 2026-01-05T15:11:48.054Z
9096679 9096679 20251227150115_My7Qd NZ005H 2025-12-30T15:07:53.191Z 2026-01-04T15:33:20.419Z
9096615 9096615 20251227145648_8FfPs NZ005H 2025-12-30T15:07:50.454Z 2026-01-04T15:33:18.835Z
9096581 9096581 20251227145443_bZm3R NZ005H 2025-12-30T15:07:48.703Z 2026-01-04T15:33:17.939Z
9096348 9096348 20251227144438_JjMHC NZ005H 2025-12-30T15:07:23.956Z 2026-01-04T15:33:11.769Z
9096306 9096306 20251227144221_34TKZ NZ005H 2025-12-30T15:07:22.760Z 2026-01-04T15:33:10.818Z
9096026 9096026 20251227142450_utoop NZ005H 2025-12-30T15:07:10.951Z 2026-01-04T15:32:51.899Z
9095822 9095822 20251227141158_ZkfQs NZ005H 2025-12-30T15:07:02.323Z 2026-01-04T15:32:44.889Z
9095667 9095667 20251227140426_Q4yRz NZ005H 2025-12-30T15:06:42.856Z 2026-01-04T15:32:40.830Z
9094539 9094539 20251227123356_MBT1y NZ005H 2025-12-30T15:05:28.453Z 2026-01-04T15:31:46.730Z
9094531 9094531 20251227123331_anvF6 NZ005H 2025-12-30T15:05:25.854Z 2026-01-04T15:31:46.374Z
9094255 9094255 20251227120051_h3Eo2 NZ005H 2025-12-30T15:05:07.273Z 2026-01-04T15:31:37.662Z
9093857 9093857 20251227105406_UUMna NZ005H 2025-12-30T15:04:26.965Z 2026-01-04T15:31:13.692Z
9090223 9090223 20251228144358_mZJLE NZ005H 2025-12-30T14:49:53.190Z 2026-01-05T15:13:03.987Z
9090214 9090214 20251228144338_arIpY NZ005H 2025-12-30T14:49:52.804Z 2026-01-05T15:13:03.790Z
9090114 9090114 20251228143740_ygJW4 NZ005H 2025-12-30T14:49:45.367Z 2026-01-05T15:13:01.603Z
9090023 9090023 20251228142608_feN8I NZ005H 2025-12-30T14:49:34.656Z 2026-01-05T15:12:59.531Z
9089781 9089781 20251228134824_mFAE2 NZ005H 2025-12-30T14:49:07.025Z 2026-01-05T15:12:53.545Z
9089738 9089738 20251228134314_7KCH6 NZ005H 2025-12-30T14:49:03.528Z 2026-01-05T15:12:52.558Z
9089312 9089312 20251228130824_V2j3q NZ005H 2025-12-30T14:48:14.667Z 2026-01-05T15:12:28.779Z
9089224 9089224 20251228130343_t7vwv NZ005H 2025-12-30T14:48:07.975Z 2026-01-05T15:12:26.417Z
9088909 9088909 20251228123143_zZjJe NZ005H 2025-12-30T14:47:26.786Z 2026-01-05T15:12:16.126Z
9088336 9088336 20251228113835_NrI2o NZ005H 2025-12-30T14:46:15.244Z 2026-01-05T15:11:48.220Z
9087911 9087911 20251228104816_ZXTj2 NZ005H 2025-12-30T14:45:13.313Z 2026-01-05T15:11:34.679Z
9087817 9087817 20251228103624_AvZZU NZ005H 2025-12-30T14:45:00.097Z 2026-01-05T15:11:31.426Z
9087665 9087665 20251228101242_L9OTt NZ005H 2025-12-30T14:44:42.824Z 2026-01-05T15:11:26.796Z
9087597 9087597 20251228100158_QtGoC NZ005H 2025-12-30T14:44:25.323Z 2025-12-31T14:53:25.221Z
9087577 9087577 20251228095704_EKfYP NZ005H 2025-12-30T14:44:22.434Z 2026-01-05T15:11:12.192Z
9069587 9069587 20251226142136_GTj2r NZ005H 2025-12-29T14:46:16.244Z 2026-01-03T15:40:53.926Z
9069340 9069340 20251226135211_Ngxjj NZ005H 2025-12-29T14:46:01.113Z 2026-01-03T15:40:43.545Z
9069271 9069271 20251226133841_xxygu NZ005H 2025-12-29T14:45:41.629Z 2026-01-03T15:40:40.951Z
9069157 9069157 20251226132642_TKQBW NZ005H 2025-12-29T14:45:31.912Z 2025-12-30T15:21:30.566Z

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