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

>10,000 rows count all where station_code = "NZ003K" 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
9270608 9270608 20260128161118_KgkcD NZ003K 2026-01-29T14:13:00.519Z 2026-01-29T14:13:00.519Z
9270533 9270533 20260128155834_Keb5C NZ003K 2026-01-29T14:12:33.054Z 2026-01-29T14:12:33.054Z
9270512 9270512 20260128155718_xgOeL NZ003K 2026-01-29T14:12:30.241Z 2026-01-29T14:12:30.241Z
9270471 9270471 20260128155401_BBA12 NZ003K 2026-01-29T14:12:22.512Z 2026-01-29T14:12:22.512Z
9270368 9270368 20260128153946_TGSio NZ003K 2026-01-29T14:11:57.274Z 2026-01-29T14:11:57.274Z
9270350 9270350 20260128153515_AWUyr NZ003K 2026-01-29T14:11:50.702Z 2026-01-29T14:11:50.702Z
9270226 9270226 20260128151823_VRFwi NZ003K 2026-01-29T14:11:21.944Z 2026-01-29T14:11:21.944Z
9270161 9270161 20260128150401_XksET NZ003K 2026-01-29T14:11:09.020Z 2026-01-29T14:11:09.020Z
9270096 9270096 20260128145328_uNRbn NZ003K 2026-01-29T14:10:49.511Z 2026-01-29T14:10:49.511Z
9270066 9270066 20260128145132_veUaf NZ003K 2026-01-29T14:10:46.230Z 2026-01-29T14:10:46.230Z
9270049 9270049 20260128145058_Zs3KN NZ003K 2026-01-29T14:10:44.121Z 2026-01-29T14:10:44.121Z
9270003 9270003 20260128144314_V16gn NZ003K 2026-01-29T14:10:35.209Z 2026-01-29T14:10:35.209Z
9269972 9269972 20260128143811_ng788 NZ003K 2026-01-29T14:10:22.307Z 2026-01-29T14:10:22.307Z
9269915 9269915 20260128143111_NQ0MP NZ003K 2026-01-29T14:10:12.905Z 2026-01-29T14:10:12.905Z
9269777 9269777 20260128141109_epgSC NZ003K 2026-01-29T14:09:35.501Z 2026-01-29T14:09:35.501Z
9268982 9268982 20260128115724_ugQy8 NZ003K 2026-01-29T14:05:50.769Z 2026-01-29T14:05:50.769Z
9268940 9268940 20260128114537_WAaQc NZ003K 2026-01-29T14:05:38.564Z 2026-01-29T14:05:38.564Z
9268831 9268831 20260128113126_dyStx NZ003K 2026-01-29T14:05:06.749Z 2026-01-29T14:05:06.749Z
9268798 9268798 20260128112346_slCn0 NZ003K 2026-01-29T14:04:57.202Z 2026-01-29T14:04:57.202Z
9268733 9268733 20260128111252_AIIBl NZ003K 2026-01-29T14:04:39.891Z 2026-01-29T14:04:39.891Z
9268685 9268685 20260128110153_eQQt2 NZ003K 2026-01-29T14:04:20.894Z 2026-01-29T14:04:20.894Z
9268620 9268620 20260128105457_GNwYo NZ003K 2026-01-29T14:04:01.749Z 2026-01-29T14:04:01.749Z
9268596 9268596 20260128105018_OurHo NZ003K 2026-01-29T14:03:55.383Z 2026-01-29T14:03:55.383Z
9268581 9268581 20260128104749_ShV71 NZ003K 2026-01-29T14:03:52.066Z 2026-01-29T14:03:52.066Z
9268189 9268189 20260128091759_jb60b NZ003K 2026-01-29T14:01:37.012Z 2026-01-29T14:01:37.012Z
9268158 9268158 20260128090605_Onh32 NZ003K 2026-01-29T14:01:26.245Z 2026-01-29T14:01:26.245Z
9268124 9268124 20260128085629_3JhDE NZ003K 2026-01-29T14:01:14.743Z 2026-01-29T14:01:14.743Z
9268122 9268122 20260128085507_ls7AK NZ003K 2026-01-29T14:01:13.470Z 2026-01-29T14:01:13.470Z
9265502 9265502 20260127152202_zxsrm NZ003K 2026-01-28T14:10:23.788Z 2026-01-29T14:30:24.594Z
9265488 9265488 20260127152137_HLKtJ NZ003K 2026-01-28T14:10:21.771Z 2026-01-29T14:30:24.591Z
9263950 9263950 20260127104752_ZqSGf NZ003K 2026-01-28T14:03:39.808Z 2026-01-29T14:30:19.975Z
9263944 9263944 20260127104534_Yr0Ww NZ003K 2026-01-28T14:03:37.962Z 2026-01-29T14:30:19.974Z
9263749 9263749 20260127100710_m3WNy NZ003K 2026-01-28T14:02:36.196Z 2026-01-29T14:30:18.926Z
9261212 9261212 20260126102736_7PB3U NZ003K 2026-01-27T14:02:35.286Z 2026-01-29T14:32:04.690Z
9261072 9261072 20260126094451_0AVmy NZ003K 2026-01-27T14:01:45.957Z 2026-01-29T14:31:45.418Z
9257754 9257754 20260125154815_gsrET NZ003K 2026-01-26T14:07:36.771Z 2026-01-29T14:37:37.976Z
9257714 9257714 20260125153847_RA4Qy NZ003K 2026-01-26T14:07:23.727Z 2026-01-29T14:37:36.580Z
9257706 9257706 20260125153102_iGspV NZ003K 2026-01-26T14:07:21.750Z 2026-01-29T14:37:36.111Z
9257669 9257669 20260125152213_qqs8v NZ003K 2026-01-26T14:07:09.866Z 2026-01-29T14:37:33.974Z
9257616 9257616 20260125145944_D78SC NZ003K 2026-01-26T14:06:46.078Z 2026-01-29T14:37:30.550Z
9257614 9257614 20260125145848_jphKZ NZ003K 2026-01-26T14:06:44.992Z 2026-01-29T14:37:30.477Z
9257604 9257604 20260125145502_nqIRL NZ003K 2026-01-26T14:06:37.275Z 2026-01-29T14:37:29.887Z
9257233 9257233 20260125122919_jJwQL NZ003K 2026-01-26T14:04:17.919Z 2026-01-29T14:37:00.641Z
9257230 9257230 20260125122837_dfUQp NZ003K 2026-01-26T14:04:17.110Z 2026-01-29T14:37:00.461Z
9253916 9253916 20260124154436_r0kkY NZ003K 2026-01-25T14:04:58.615Z 2026-01-29T14:41:48.050Z
9253909 9253909 20260124154346_LpfZy NZ003K 2026-01-25T14:04:57.351Z 2026-01-29T14:41:47.709Z
9253863 9253863 20260124152200_Ra8rc NZ003K 2026-01-25T14:04:44.642Z 2026-01-29T14:41:43.902Z
9253840 9253840 20260124150951_3qzWv NZ003K 2026-01-25T14:04:38.219Z 2026-01-29T14:41:41.155Z
9253828 9253828 20260124150446_Hu2Y5 NZ003K 2026-01-25T14:04:34.520Z 2026-01-29T14:41:39.982Z
9253412 9253412 20260124113930_ddoX5 NZ003K 2026-01-25T14:02:37.214Z 2026-01-29T14:40:48.285Z
9253262 9253262 20260124103606_pqSE6 NZ003K 2026-01-25T14:01:42.791Z 2026-01-29T14:40:31.154Z
9250459 9250459 20260123151638_LwK3i NZ003K 2026-01-24T14:03:02.174Z 2026-01-29T14:45:36.687Z
9250233 9250233 20260123111558_k22rS NZ003K 2026-01-24T14:01:51.005Z 2026-01-29T14:45:07.165Z
9250218 9250218 20260123110951_YlPlw NZ003K 2026-01-24T14:01:44.101Z 2026-01-29T14:45:06.367Z
9250169 9250169 20260123105616_2tflF NZ003K 2026-01-24T14:01:32.765Z 2026-01-29T14:45:03.429Z
9250050 9250050 20260123095558_ef9bN NZ003K 2026-01-24T14:00:51.625Z 2026-01-29T14:44:55.880Z
9249997 9249997 20260123093316_7BJgT NZ003K 2026-01-24T14:00:32.090Z 2026-01-29T14:44:46.994Z
9249991 9249991 20260123092911_HCx6I NZ003K 2026-01-24T14:00:30.100Z 2026-01-29T14:44:46.744Z
9249970 9249970 20260123091737_43Em6 NZ003K 2026-01-24T14:00:23.511Z 2026-01-29T14:44:45.667Z
9249965 9249965 20260123091648_fAe5z NZ003K 2026-01-24T14:00:21.690Z 2026-01-29T14:44:45.307Z
9249949 9249949 20260123090940_2X4Ky NZ003K 2026-01-24T14:00:17.004Z 2026-01-29T14:44:44.516Z
9249930 9249930 20260123090048_ClSi7 NZ003K 2026-01-24T14:00:09.682Z 2026-01-29T14:44:41.295Z
9216037 9216037 20260116114356_Hdfiv NZ003K 2026-01-17T14:27:41.684Z 2026-01-24T15:15:24.090Z
9216020 9216020 20260116114229_FV35x NZ003K 2026-01-17T14:27:39.715Z 2026-01-24T15:15:23.779Z
9215983 9215983 20260116113603_oljgm NZ003K 2026-01-17T14:27:33.084Z 2026-01-24T15:15:22.602Z
9215929 9215929 20260116112559_LY2xf NZ003K 2026-01-17T14:27:17.295Z 2026-01-24T15:15:18.658Z
9215811 9215811 20260116110340_joqYP NZ003K 2026-01-17T14:26:59.147Z 2026-01-24T15:15:14.102Z
9215613 9215613 20260116103533_PMQmE NZ003K 2026-01-17T14:26:16.654Z 2026-01-24T15:15:05.002Z
9215457 9215457 20260116101733_uS2zg NZ003K 2026-01-17T14:25:37.781Z 2026-01-24T15:14:55.394Z
9215333 9215333 20260116095604_YrrMl NZ003K 2026-01-17T14:25:13.799Z 2026-01-24T15:14:41.893Z
9215240 9215240 20260116094145_cnX8X NZ003K 2026-01-17T14:24:55.145Z 2026-01-24T15:14:36.045Z
9215175 9215175 20260116093501_IfKgu NZ003K 2026-01-17T14:24:40.475Z 2026-01-24T15:14:34.173Z
9215150 9215150 20260116092810_J39yd NZ003K 2026-01-17T14:24:36.659Z 2026-01-24T15:14:32.793Z
9215130 9215130 20260116092034_KJrIY NZ003K 2026-01-17T14:24:31.386Z 2026-01-24T15:14:31.526Z
9215107 9215107 20260116091850_O0Sgh NZ003K 2026-01-17T14:24:27.086Z 2026-01-24T15:14:30.741Z
9215073 9215073 20260116090743_kuXCZ NZ003K 2026-01-17T14:24:16.073Z 2026-01-24T15:14:28.855Z
9214925 9214925 20260116084652_kHJ9g NZ003K 2026-01-17T14:23:48.186Z 2026-01-24T15:14:23.166Z
9211104 9211104 20260116155859_irmm4 NZ003K 2026-01-17T14:04:22.165Z 2026-01-25T14:57:21.272Z
9211081 9211081 20260116154448_aYqyV NZ003K 2026-01-17T14:04:13.588Z 2026-01-25T14:57:19.557Z
9211062 9211062 20260116152915_qcVdc NZ003K 2026-01-17T14:04:07.342Z 2026-01-25T14:57:18.414Z
9211059 9211059 20260116152825_LTqQU NZ003K 2026-01-17T14:04:06.665Z 2026-01-25T14:57:18.259Z
9211043 9211043 20260116151326_6wf3r NZ003K 2026-01-17T14:04:02.160Z 2026-01-25T14:57:17.290Z
9211032 9211032 20260116150859_A1B6L NZ003K 2026-01-17T14:03:57.593Z 2026-01-25T14:57:16.683Z
9211020 9211020 20260116150220_hmJN3 NZ003K 2026-01-17T14:03:53.827Z 2026-01-25T14:57:16.055Z
9211016 9211016 20260116145839_S3Wqo NZ003K 2026-01-17T14:03:52.437Z 2026-01-25T14:57:15.762Z
9211008 9211008 20260116144722_rYeaI NZ003K 2026-01-17T14:03:49.329Z 2026-01-25T14:57:14.919Z
9210948 9210948 20260116141511_oVYGD NZ003K 2026-01-17T14:03:30.095Z 2026-01-25T14:57:12.486Z
9210928 9210928 20260116140722_DsQW1 NZ003K 2026-01-17T14:03:26.403Z 2026-01-25T14:57:11.850Z
9210905 9210905 20260116140008_8v9MU NZ003K 2026-01-17T14:03:22.328Z 2026-01-25T14:57:11.411Z
9210889 9210889 20260116134803_vbHZ5 NZ003K 2026-01-17T14:03:15.951Z 2026-01-25T14:57:10.611Z
9210875 9210875 20260116134524_cO7N5 NZ003K 2026-01-17T14:03:13.372Z 2026-01-25T14:57:10.340Z
9210864 9210864 20260116134256_gDljO NZ003K 2026-01-17T14:03:12.032Z 2026-01-25T14:57:10.043Z
9210857 9210857 20260116134055_EAftL NZ003K 2026-01-17T14:03:11.268Z 2026-01-25T14:57:09.966Z
9210840 9210840 20260116132942_As8Bd NZ003K 2026-01-17T14:03:05.089Z 2026-01-25T14:57:09.301Z
9210784 9210784 20260116131643_WKFKy NZ003K 2026-01-17T14:02:49.915Z 2026-01-25T14:56:55.831Z
9210726 9210726 20260116130332_JsSdQ NZ003K 2026-01-17T14:02:31.432Z 2026-01-25T14:56:53.773Z
9210713 9210713 20260116130106_Slg2X NZ003K 2026-01-17T14:02:28.348Z 2026-01-25T14:56:53.401Z
9210691 9210691 20260116125631_TD9DO NZ003K 2026-01-17T14:02:22.729Z 2026-01-25T14:56:52.764Z
9210625 9210625 20260116124451_lhYkr NZ003K 2026-01-17T14:02:02.938Z 2026-01-25T14:56:49.564Z
9210616 9210616 20260116124227_GK1Gd NZ003K 2026-01-17T14:01:59.641Z 2026-01-25T14:56:49.068Z

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