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

3,927 rows where station_code = "NZ005F" 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
9270669 9270669 20260128162011_gc5bC NZ005F 2026-01-29T14:13:15.378Z 2026-01-29T14:13:15.378Z
9270657 9270657 20260128161827_RUhKm NZ005F 2026-01-29T14:13:13.382Z 2026-01-29T14:13:13.382Z
9270444 9270444 20260128154926_vkO37 NZ005F 2026-01-29T14:12:17.090Z 2026-01-29T14:12:17.090Z
9270218 9270218 20260128151739_bP5XR NZ005F 2026-01-29T14:11:20.455Z 2026-01-29T14:11:20.455Z
9269894 9269894 20260128142959_rECRX NZ005F 2026-01-29T14:10:08.475Z 2026-01-29T14:10:08.475Z
9269857 9269857 20260128142513_pM1Rj NZ005F 2026-01-29T14:09:53.441Z 2026-01-29T14:09:53.441Z
9269822 9269822 20260128141744_f0OxR NZ005F 2026-01-29T14:09:45.392Z 2026-01-29T14:09:45.392Z
9269747 9269747 20260128140553_MJ3u3 NZ005F 2026-01-29T14:09:29.126Z 2026-01-29T14:09:29.126Z
9269648 9269648 20260128134907_p25nc NZ005F 2026-01-29T14:08:56.524Z 2026-01-29T14:08:56.524Z
9269548 9269548 20260128133059_jP2i2 NZ005F 2026-01-29T14:08:26.663Z 2026-01-29T14:08:26.663Z
9269456 9269456 20260128131929_igD8S NZ005F 2026-01-29T14:08:02.451Z 2026-01-29T14:08:02.451Z
9269397 9269397 20260128131227_Lkj5j NZ005F 2026-01-29T14:07:50.587Z 2026-01-29T14:07:50.587Z
9268844 9268844 20260128113213_b2rXJ NZ005F 2026-01-29T14:05:09.479Z 2026-01-29T14:05:09.479Z
9268773 9268773 20260128111752_sYej1 NZ005F 2026-01-29T14:04:49.729Z 2026-01-29T14:04:49.729Z
9268607 9268607 20260128105159_IWoAM NZ005F 2026-01-29T14:03:57.719Z 2026-01-29T14:03:57.719Z
9268482 9268482 20260128102751_9NMN3 NZ005F 2026-01-29T14:03:18.269Z 2026-01-29T14:03:18.269Z
9265013 9265013 20260127135451_lMAZO NZ005F 2026-01-28T14:08:38.890Z 2026-01-29T14:30:24.413Z
9265002 9265002 20260127135258_tiLex NZ005F 2026-01-28T14:08:34.732Z 2026-01-29T14:30:24.411Z
9264919 9264919 20260127133528_YuuH2 NZ005F 2026-01-28T14:08:15.938Z 2026-01-29T14:30:24.392Z
9264487 9264487 20260127123149_IgWQy NZ005F 2026-01-28T14:06:19.474Z 2026-01-29T14:30:24.184Z
9264463 9264463 20260127122713_CDimg NZ005F 2026-01-28T14:06:14.103Z 2026-01-29T14:30:21.770Z
9261010 9261010 20260126092030_XKiuK NZ005F 2026-01-27T14:01:22.769Z 2026-01-29T14:31:22.318Z
9257791 9257791 20260125155753_dFe1m NZ005F 2026-01-26T14:07:45.448Z 2026-01-29T14:37:40.121Z
9257459 9257459 20260125135102_KRniU NZ005F 2026-01-26T14:05:45.128Z 2026-01-29T14:37:13.504Z
9257374 9257374 20260125131307_Z3ZYV NZ005F 2026-01-26T14:05:11.044Z 2026-01-29T14:37:08.647Z
9257252 9257252 20260125123438_KniOp NZ005F 2026-01-26T14:04:26.929Z 2026-01-29T14:37:01.641Z
9257091 9257091 20260125115014_7G69R NZ005F 2026-01-26T14:03:38.131Z 2026-01-29T14:36:45.901Z
9256953 9256953 20260125111754_VNZmU NZ005F 2026-01-26T14:02:57.611Z 2026-01-29T14:36:38.130Z
9256624 9256624 20260125093110_ZLqbv NZ005F 2026-01-26T14:00:58.618Z 2026-01-29T14:36:12.248Z
9253896 9253896 20260124153406_TQ3xe NZ005F 2026-01-25T14:04:53.303Z 2026-01-29T14:41:46.262Z
9253878 9253878 20260124153207_MWrad NZ005F 2026-01-25T14:04:47.011Z 2026-01-29T14:41:45.224Z
9253614 9253614 20260124130725_p2oCP NZ005F 2026-01-25T14:03:32.072Z 2026-01-29T14:41:03.833Z
9253595 9253595 20260124125718_ot94p NZ005F 2026-01-25T14:03:27.249Z 2026-01-29T14:41:01.986Z
9253588 9253588 20260124125216_9IYVS NZ005F 2026-01-25T14:03:25.027Z 2026-01-29T14:40:59.332Z
9253520 9253520 20260124122712_RlivI NZ005F 2026-01-25T14:03:07.142Z 2026-01-29T14:40:55.122Z
9253441 9253441 20260124114753_CViNH NZ005F 2026-01-25T14:02:44.089Z 2026-01-29T14:40:50.149Z
9253418 9253418 20260124114039_9JqfQ NZ005F 2026-01-25T14:02:37.794Z 2026-01-29T14:40:48.457Z
9253365 9253365 20260124111319_gZyfm NZ005F 2026-01-25T14:02:16.023Z 2026-01-29T14:40:44.108Z
9253324 9253324 20260124105551_Aft23 NZ005F 2026-01-25T14:02:03.484Z 2026-01-29T14:40:37.434Z
9253236 9253236 20260124102046_4rY2H NZ005F 2026-01-25T14:01:32.879Z 2026-01-29T14:40:29.220Z
9253173 9253173 20260124095404_m3Aif NZ005F 2026-01-25T14:01:06.931Z 2026-01-29T14:40:23.500Z
9250370 9250370 20260123140018_0jfyo NZ005F 2026-01-24T14:02:32.840Z 2026-01-29T14:45:27.351Z
9250014 9250014 20260123093539_o7uEf NZ005F 2026-01-24T14:00:37.796Z 2026-01-29T14:44:47.830Z
9249977 9249977 20260123091907_NbwmR NZ005F 2026-01-24T14:00:25.148Z 2026-01-29T14:44:45.916Z
9249791 9249791 20260122084533_31LJa NZ005F 2026-01-23T14:16:14.598Z 2026-01-29T14:58:55.469Z
9245828 9245828 20260122144829_EfIqW NZ005F 2026-01-23T14:03:37.793Z 2026-01-29T14:50:15.598Z
9245783 9245783 20260122142850_AcyCO NZ005F 2026-01-23T14:03:28.846Z 2026-01-29T14:50:12.010Z
9245614 9245614 20260122132159_3uaaf NZ005F 2026-01-23T14:02:37.418Z 2026-01-29T14:49:50.826Z
9245591 9245591 20260122131408_rZbIv NZ005F 2026-01-23T14:02:29.886Z 2026-01-29T14:49:49.498Z
9245520 9245520 20260122125340_8R2Xt NZ005F 2026-01-23T14:02:16.314Z 2026-01-29T14:49:45.144Z
9216103 9216103 20260116114946_LDPvL NZ005F 2026-01-17T14:27:55.970Z 2026-01-24T15:15:28.139Z
9215445 9215445 20260116101358_SPkIH NZ005F 2026-01-17T14:25:35.678Z 2026-01-24T15:14:51.711Z
9211002 9211002 20260116143622_g784D NZ005F 2026-01-17T14:03:46.041Z 2026-01-25T14:57:14.360Z
9192403 9192403 20260112123129_w5PJA NZ005F 2026-01-13T14:28:15.694Z 2026-01-20T15:26:21.066Z
9192333 9192333 20260112122422_8q5QY NZ005F 2026-01-13T14:28:05.374Z 2026-01-20T15:26:18.734Z
9191157 9191157 20260112104021_xXEin NZ005F 2026-01-13T14:24:34.320Z 2026-01-20T15:25:12.355Z
9190678 9190678 20260112093801_Dkqo2 NZ005F 2026-01-13T14:23:02.407Z 2026-01-20T15:24:42.970Z
9190598 9190598 20260112092622_3aXD0 NZ005F 2026-01-13T14:22:49.429Z 2026-01-20T15:24:40.095Z
9186361 9186361 20260112142617_9K3cH NZ005F 2026-01-13T14:01:36.615Z 2026-01-21T15:02:23.029Z
9185659 9185659 20260111122423_EKyBW NZ005F 2026-01-12T14:25:24.958Z 2026-01-19T15:21:16.686Z
9185392 9185392 20260111093514_Luo7r NZ005F 2026-01-12T14:23:38.363Z 2026-01-19T15:19:41.889Z
9178929 9178929 20260110142913_jkfLL NZ005F 2026-01-11T14:16:04.712Z 2026-01-18T15:11:24.658Z
9178788 9178788 20260110140946_IYRJs NZ005F 2026-01-11T14:15:43.598Z 2026-01-18T15:11:17.074Z
9178719 9178719 20260110134918_Reajm NZ005F 2026-01-11T14:15:35.800Z 2026-01-18T15:11:12.729Z
9178666 9178666 20260110134031_eD3mq NZ005F 2026-01-11T14:15:26.719Z 2026-01-18T15:11:10.601Z
9178625 9178625 20260110133424_gzbSM NZ005F 2026-01-11T14:15:20.792Z 2026-01-18T15:11:08.857Z
9178430 9178430 20260110130817_X2A4A NZ005F 2026-01-11T14:14:52.960Z 2026-01-18T15:10:50.663Z
9178376 9178376 20260110125838_FEauD NZ005F 2026-01-11T14:14:42.540Z 2026-01-18T15:10:47.072Z
9178130 9178130 20260110122157_vw9h9 NZ005F 2026-01-11T14:14:05.391Z 2026-01-18T15:10:35.333Z
9178039 9178039 20260110120231_bhxP3 NZ005F 2026-01-11T14:13:50.075Z 2026-01-18T15:10:22.846Z
9177901 9177901 20260110114123_GOn68 NZ005F 2026-01-11T14:13:28.132Z 2026-01-18T15:10:14.159Z
9177601 9177601 20260110103159_NJg06 NZ005F 2026-01-11T14:12:28.380Z 2026-01-18T15:09:51.294Z
9177520 9177520 20260110100629_RPPWP NZ005F 2026-01-11T14:12:12.887Z 2026-01-18T15:09:46.527Z
9177315 9177315 20260110091749_qgMTI NZ005F 2026-01-11T14:11:36.331Z 2026-01-18T15:09:36.879Z
9174303 9174303 20260110160733_Atdas NZ005F 2026-01-11T14:02:05.273Z 2026-01-19T15:14:53.169Z
9174265 9174265 20260110155736_Ss4lK NZ005F 2026-01-11T14:01:56.968Z 2026-01-19T15:14:46.197Z
9174253 9174253 20260110155632_tTmZw NZ005F 2026-01-11T14:01:55.519Z 2026-01-19T15:14:45.512Z
9174251 9174251 20260110155458_kg6UO NZ005F 2026-01-11T14:01:54.875Z 2026-01-19T15:14:44.735Z
9174160 9174160 20260110154114_zlbk7 NZ005F 2026-01-11T14:01:35.629Z 2026-01-19T15:14:38.029Z
9174066 9174066 20260110152414_8xC8w NZ005F 2026-01-11T14:01:12.576Z 2026-01-19T15:14:33.654Z
9173920 9173920 20260110150202_47M2w NZ005F 2026-01-11T14:00:43.761Z 2026-01-19T15:14:27.312Z
9173916 9173916 20260110150112_IS065 NZ005F 2026-01-11T14:00:41.562Z 2026-01-19T15:14:27.193Z
9173825 9173825 20260110144913_ga1lq NZ005F 2026-01-11T14:00:23.120Z 2026-01-19T15:14:12.434Z
9173809 9173809 20260110144805_FJy3I NZ005F 2026-01-11T14:00:20.704Z 2026-01-19T15:14:12.091Z
9173790 9173790 20260110144631_Z6Zwa NZ005F 2026-01-11T14:00:16.081Z 2026-01-19T15:14:09.931Z
9173429 9173429 20260109140842_cUYYC NZ005F 2026-01-10T14:17:29.708Z 2026-01-17T15:26:42.852Z
9173397 9173397 20260109140201_qONCf NZ005F 2026-01-10T14:17:24.756Z 2026-01-17T15:26:42.023Z
9173381 9173381 20260109135353_Y2y6y NZ005F 2026-01-10T14:17:21.771Z 2026-01-17T15:26:41.472Z
9173333 9173333 20260109134051_CZUG3 NZ005F 2026-01-10T14:17:06.244Z 2026-01-17T15:26:39.272Z
9173288 9173288 20260109133150_u4vEw NZ005F 2026-01-10T14:16:59.294Z 2026-01-17T15:26:36.763Z
9173242 9173242 20260109132608_SQYru NZ005F 2026-01-10T14:16:50.448Z 2026-01-17T15:26:24.403Z
9173162 9173162 20260109131159_vBm27 NZ005F 2026-01-10T14:16:28.215Z 2026-01-17T15:26:21.538Z
9173119 9173119 20260109130135_JdaWY NZ005F 2026-01-10T14:16:13.951Z 2026-01-17T15:26:16.989Z
9173044 9173044 20260109124641_JXr46 NZ005F 2026-01-10T14:15:55.095Z 2026-01-17T15:26:12.795Z
9168763 9168763 20260108120931_PRGE3 NZ005F 2026-01-09T14:11:57.319Z 2026-01-16T15:13:02.466Z
9168102 9168102 20260108095247_pMTiJ NZ005F 2026-01-09T14:10:19.472Z 2026-01-16T15:12:18.564Z
9168063 9168063 20260108094509_L513D NZ005F 2026-01-09T14:10:14.038Z 2026-01-16T15:12:16.993Z
9164034 9164034 20260107114637_a3hiR NZ005F 2026-01-08T14:11:34.737Z 2026-01-13T15:04:01.227Z
9164005 9164005 20260107114120_Ta5NZ NZ005F 2026-01-08T14:11:26.933Z 2026-01-13T15:03:59.375Z
9163962 9163962 20260107112900_T6dcx NZ005F 2026-01-08T14:11:18.451Z 2026-01-13T15:03:56.988Z

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