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

1,010 rows where station_code = "NZ005S" 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
9627418 9627418 20260408173148_fX0LX NZ005S 2026-04-09T12:10:53.250Z 2026-04-10T12:14:22.540Z
9626825 9626825 20260408151127_vUi7r NZ005S 2026-04-09T12:09:15.520Z 2026-04-10T12:14:22.419Z
9626637 9626637 20260408142931_5cmpk NZ005S 2026-04-09T12:08:49.349Z 2026-04-10T12:14:22.386Z
9626583 9626583 20260408141927_XTSfV NZ005S 2026-04-09T12:08:43.911Z 2026-04-10T12:14:22.378Z
9626389 9626389 20260408135137_b16BV NZ005S 2026-04-09T12:08:14.568Z 2026-04-10T12:14:22.343Z
9626032 9626032 20260408125512_xK8AB NZ005S 2026-04-09T12:07:21.837Z 2026-04-10T12:14:22.284Z
9626010 9626010 20260408125115_hqAYh NZ005S 2026-04-09T12:07:17.646Z 2026-04-10T12:14:22.280Z
9626003 9626003 20260408125013_KQmJi NZ005S 2026-04-09T12:07:17.194Z 2026-04-10T12:14:22.279Z
9625989 9625989 20260408124658_tPeHd NZ005S 2026-04-09T12:07:15.194Z 2026-04-10T12:14:22.276Z
9625863 9625863 20260408121527_PejoW NZ005S 2026-04-09T12:07:00.864Z 2026-04-10T12:14:22.256Z
9625804 9625804 20260408115527_0zcu3 NZ005S 2026-04-09T12:06:46.909Z 2026-04-10T12:14:22.245Z
9606284 9606284 20260403165034_UiWo2 NZ005S 2026-04-04T12:06:14.740Z 2026-04-10T12:32:26.536Z
9606207 9606207 20260403161856_8Wy0C NZ005S 2026-04-04T12:05:58.632Z 2026-04-10T12:32:24.739Z
9606196 9606196 20260403160820_5ZceG NZ005S 2026-04-04T12:05:56.463Z 2026-04-10T12:32:24.296Z
9605987 9605987 20260403134016_cRu2p NZ005S 2026-04-04T12:04:46.388Z 2026-04-10T12:32:18.016Z
9605567 9605567 20260403104947_AKUUi NZ005S 2026-04-04T12:02:55.645Z 2026-04-10T12:31:38.854Z
9605542 9605542 20260403103731_3opx2 NZ005S 2026-04-04T12:02:50.343Z 2026-04-10T12:31:38.251Z
9604327 9604327 20260402171259_iP2xp NZ005S 2026-04-03T12:06:54.248Z 2026-04-10T12:34:48.085Z
9604138 9604138 20260402160820_p9Lxe NZ005S 2026-04-03T12:06:04.405Z 2026-04-10T12:34:43.226Z
9604127 9604127 20260402155939_y384F NZ005S 2026-04-03T12:06:02.218Z 2026-04-10T12:34:42.810Z
9604072 9604072 20260402152548_pqJSJ NZ005S 2026-04-03T12:05:48.772Z 2026-04-10T12:34:18.789Z
9604070 9604070 20260402152548_o3S1M NZ005S 2026-04-03T12:05:48.332Z 2026-04-10T12:34:18.713Z
9604007 9604007 20260402145412_BtDRc NZ005S 2026-04-03T12:05:29.775Z 2026-04-10T12:34:17.357Z
9603827 9603827 20260402125853_RXjwE NZ005S 2026-04-03T12:04:48.914Z 2026-04-10T12:34:10.529Z
9603803 9603803 20260402124416_Z5NIY NZ005S 2026-04-03T12:04:43.088Z 2026-04-10T12:34:10.009Z
9603616 9603616 20260402112321_MSKgt NZ005S 2026-04-03T12:03:49.294Z 2026-04-10T12:34:05.403Z
9603462 9603462 20260402103053_PO3fS NZ005S 2026-04-03T12:03:09.796Z 2026-04-10T12:34:02.520Z
9603136 9603136 20260402075939_psLYX NZ005S 2026-04-03T12:01:55.815Z 2026-04-10T12:33:56.480Z
9601887 9601887 20260401171908_JEhJX NZ005S 2026-04-02T12:04:02.208Z 2026-04-10T12:35:49.037Z
9601762 9601762 20260401165502_FbSIC NZ005S 2026-04-02T12:03:38.540Z 2026-04-10T12:35:47.036Z
9601648 9601648 20260401162229_9JZQJ NZ005S 2026-04-02T12:03:21.467Z 2026-04-10T12:35:42.800Z
9601264 9601264 20260401133728_4u9HE NZ005S 2026-04-02T12:02:09.843Z 2026-04-10T12:35:35.735Z
9601246 9601246 20260401133221_QEUgc NZ005S 2026-04-02T12:02:07.188Z 2026-04-10T12:35:35.488Z
9601144 9601144 20260401122906_aIXOf NZ005S 2026-04-02T12:01:44.831Z 2026-04-10T12:35:33.938Z
9601087 9601087 20260401114047_63ujR NZ005S 2026-04-02T12:01:31.202Z 2026-04-10T12:35:32.891Z
9598021 9598021 20260330173219_nNik9 NZ005S 2026-03-31T12:07:27.744Z 2026-04-08T12:44:23.513Z
9597865 9597865 20260330171139_5Xc6L NZ005S 2026-03-31T12:07:08.930Z 2026-04-08T12:44:19.361Z
9597590 9597590 20260330163822_Lw9j7 NZ005S 2026-03-31T12:06:41.419Z 2026-04-08T12:43:54.475Z
9597552 9597552 20260330163508_LY0Ss NZ005S 2026-03-31T12:06:36.528Z 2026-04-08T12:43:49.352Z
9597527 9597527 20260330162927_KWbfg NZ005S 2026-03-31T12:06:32.415Z 2026-04-08T12:43:44.905Z
9597396 9597396 20260330161326_82ooU NZ005S 2026-03-31T12:06:18.917Z 2026-04-08T12:43:42.068Z
9597289 9597289 20260330155717_I6LjG NZ005S 2026-03-31T12:06:05.123Z 2026-04-08T12:43:37.809Z
9597202 9597202 20260330153427_ibjC9 NZ005S 2026-03-31T12:05:53.854Z 2026-04-08T12:43:35.488Z
9597159 9597159 20260330152909_L1NZh NZ005S 2026-03-31T12:05:49.105Z 2026-04-08T12:43:34.574Z
9597132 9597132 20260330152214_0rEUJ NZ005S 2026-03-31T12:05:42.530Z 2026-04-08T12:43:33.407Z
9597128 9597128 20260330152213_UuCdY NZ005S 2026-03-31T12:05:42.239Z 2026-04-08T12:43:33.359Z
9596896 9596896 20260330142659_m9cY2 NZ005S 2026-03-31T12:05:11.389Z 2026-04-08T12:43:27.224Z
9596725 9596725 20260330134824_g97mI NZ005S 2026-03-31T12:04:50.481Z 2026-04-08T12:43:23.103Z
9596256 9596256 20260330115843_sdXFK NZ005S 2026-03-31T12:03:50.943Z 2026-04-08T12:42:47.602Z
9596234 9596234 20260330115302_OzS9S NZ005S 2026-03-31T12:03:48.383Z 2026-04-08T12:42:47.080Z
9596186 9596186 20260330113926_22ahT NZ005S 2026-03-31T12:03:41.052Z 2026-04-08T12:42:43.523Z
9596121 9596121 20260330111624_jLBjz NZ005S 2026-03-31T12:03:31.660Z 2026-04-08T12:42:41.948Z
9595679 9595679 20260330075656_QqsKt NZ005S 2026-03-31T12:02:11.042Z 2026-04-08T12:42:29.253Z
9590179 9590179 20260328071946_BlAfZ NZ005S 2026-03-29T12:02:09.534Z 2026-04-06T12:37:54.796Z
9587407 9587407 20260327122947_Q6Pf3 NZ005S 2026-03-28T12:05:26.808Z 2026-04-05T12:34:25.320Z
9587304 9587304 20260327120135_BBC7C NZ005S 2026-03-28T12:05:13.990Z 2026-04-05T12:34:12.309Z
9587288 9587288 20260327115945_ctFSL NZ005S 2026-03-28T12:05:12.134Z 2026-04-05T12:34:11.558Z
9586422 9586422 20260327072440_8jf32 NZ005S 2026-03-28T12:03:02.652Z 2026-04-05T12:33:24.702Z
9577960 9577960 20260325092416_xdyW1 NZ005S 2026-03-26T12:06:26.733Z 2026-04-03T12:37:32.555Z
9573248 9573248 20260324114038_rDKIJ NZ005S 2026-03-25T12:07:32.752Z 2026-04-02T12:36:01.065Z
9572603 9572603 20260324093637_l92P9 NZ005S 2026-03-25T12:05:43.278Z 2026-04-02T12:35:31.340Z
9568698 9568698 20260323171344_63Oif NZ005S 2026-03-24T12:15:35.622Z 2026-03-31T12:28:40.656Z
9568527 9568527 20260323165231_123Sd NZ005S 2026-03-24T12:15:14.671Z 2026-03-24T12:24:25.474Z
9568446 9568446 20260323164518_q66vJ NZ005S 2026-03-24T12:15:07.800Z 2026-03-31T12:28:29.305Z
9568239 9568239 20260323162229_2ZfIc NZ005S 2026-03-24T12:14:45.893Z 2026-03-31T12:28:26.154Z
9568153 9568153 20260323161625_a3P0L NZ005S 2026-03-24T12:14:37.895Z 2026-03-31T12:28:23.685Z
9568047 9568047 20260323160837_BAN5Q NZ005S 2026-03-24T12:14:26.879Z 2026-03-31T12:28:22.209Z
9567846 9567846 20260323155330_GLy3N NZ005S 2026-03-24T12:14:13.453Z 2026-03-31T12:28:19.764Z
9567757 9567757 20260323154611_cDrcQ NZ005S 2026-03-24T12:14:06.326Z 2026-03-31T12:28:18.321Z
9567435 9567435 20260323151503_1GCJf NZ005S 2026-03-24T12:13:36.505Z 2026-03-31T12:28:14.060Z
9567198 9567198 20260323145159_sSRCO NZ005S 2026-03-24T12:13:11.925Z 2026-03-31T12:28:10.170Z
9567187 9567187 20260323145043_7o5mM NZ005S 2026-03-24T12:13:11.297Z 2026-03-31T12:28:10.098Z
9567146 9567146 20260323144553_h3o2p NZ005S 2026-03-24T12:13:06.740Z 2026-03-31T12:28:09.123Z
9566784 9566784 20260323141256_jMoyP NZ005S 2026-03-24T12:12:25.982Z 2026-03-31T12:28:03.232Z
9566764 9566764 20260323141139_ELVY4 NZ005S 2026-03-24T12:12:24.502Z 2026-03-31T12:27:56.574Z
9566612 9566612 20260323135716_MBAYd NZ005S 2026-03-24T12:12:12.441Z 2026-03-31T12:27:54.621Z
9566388 9566388 20260323133246_2FC7I NZ005S 2026-03-24T12:11:46.166Z 2026-03-31T12:27:50.039Z
9566114 9566114 20260323130700_2PcbG NZ005S 2026-03-24T12:11:21.758Z 2026-03-31T12:27:46.216Z
9565897 9565897 20260323124948_QIhKB NZ005S 2026-03-24T12:10:59.717Z 2026-03-31T12:27:43.079Z
9565823 9565823 20260323124227_h8S2O NZ005S 2026-03-24T12:10:54.583Z 2026-03-31T12:27:42.012Z
9565713 9565713 20260323123457_0MlXP NZ005S 2026-03-24T12:10:42.708Z 2026-03-31T12:27:40.000Z
9565612 9565612 20260323122541_CDEaE NZ005S 2026-03-24T12:10:30.328Z 2026-03-31T12:27:38.300Z
9565602 9565602 20260323122444_Kfs4F NZ005S 2026-03-24T12:10:28.815Z 2026-03-31T12:27:38.124Z
9565580 9565580 20260323122102_lcr9x NZ005S 2026-03-24T12:10:25.295Z 2026-03-31T12:27:37.628Z
9565468 9565468 20260323121104_yYBFx NZ005S 2026-03-24T12:10:13.350Z 2026-03-31T12:27:35.870Z
9565313 9565313 20260323120013_w2bW9 NZ005S 2026-03-24T12:09:51.836Z 2026-03-31T12:27:33.078Z
9565220 9565220 20260323115125_C7DT3 NZ005S 2026-03-24T12:09:40.176Z 2026-03-31T12:27:31.144Z
9565079 9565079 20260323114237_1RCTy NZ005S 2026-03-24T12:09:21.617Z 2026-03-31T12:27:22.272Z
9565057 9565057 20260323114132_ARxtH NZ005S 2026-03-24T12:09:19.850Z 2026-03-31T12:27:22.026Z
9564969 9564969 20260323113308_SN14a NZ005S 2026-03-24T12:09:08.802Z 2026-03-31T12:27:20.110Z
9564788 9564788 20260323110816_eA5gT NZ005S 2026-03-24T12:08:47.875Z 2026-03-31T12:27:15.478Z
9564781 9564781 20260323110745_y1Oft NZ005S 2026-03-24T12:08:46.799Z 2026-03-31T12:27:15.320Z
9564744 9564744 20260323110614_HY9RJ NZ005S 2026-03-24T12:08:44.219Z 2026-03-31T12:27:14.771Z
9564740 9564740 20260323110432_RbgE7 NZ005S 2026-03-24T12:08:42.970Z 2026-03-31T12:27:14.637Z
9564283 9564283 20260323102042_5hD3f NZ005S 2026-03-24T12:07:47.519Z 2026-03-31T12:27:06.578Z
9564208 9564208 20260323101101_Onld7 NZ005S 2026-03-24T12:07:37.452Z 2026-03-31T12:27:05.026Z
9564133 9564133 20260323100237_OXCns NZ005S 2026-03-24T12:07:28.641Z 2026-03-31T12:27:03.193Z
9564067 9564067 20260323095645_yCdvk NZ005S 2026-03-24T12:07:21.523Z 2026-03-31T12:27:01.874Z
9564028 9564028 20260323095056_pqPtd NZ005S 2026-03-24T12:07:13.975Z 2026-03-31T12:27:01.114Z
9563989 9563989 20260323094513_jmPIO NZ005S 2026-03-24T12:07:07.055Z 2026-03-31T12:27:00.242Z

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