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,676 rows where station_code = "NZ004E" 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
9627039 9627039 20260408155912_Qh7XS NZ004E 2026-04-09T12:09:48.704Z 2026-04-10T12:14:22.465Z
9626824 9626824 20260408151127_vUi7r NZ004E 2026-04-09T12:09:15.520Z 2026-04-10T12:14:22.419Z
9626753 9626753 20260408150034_9lPVv NZ004E 2026-04-09T12:09:07.691Z 2026-04-10T12:14:22.408Z
9605565 9605565 20260403104947_AKUUi NZ004E 2026-04-04T12:02:55.614Z 2026-04-10T12:31:38.854Z
9604379 9604379 20260402173830_JC4XO NZ004E 2026-04-03T12:07:11.764Z 2026-04-10T12:34:49.476Z
9604207 9604207 20260402163136_gmMrI NZ004E 2026-04-03T12:06:22.638Z 2026-04-10T12:34:45.226Z
9604131 9604131 20260402160611_fEl7H NZ004E 2026-04-03T12:06:03.466Z 2026-04-10T12:34:43.060Z
9604068 9604068 20260402152548_o3S1M NZ004E 2026-04-03T12:05:48.318Z 2026-04-10T12:34:18.713Z
9601906 9601906 20260401172134_WmK9t NZ004E 2026-04-02T12:04:07.526Z 2026-04-10T12:35:49.410Z
9601815 9601815 20260401170800_I50XR NZ004E 2026-04-02T12:03:49.327Z 2026-04-10T12:35:48.030Z
9601803 9601803 20260401170552_cMeF5 NZ004E 2026-04-02T12:03:45.087Z 2026-04-10T12:35:47.653Z
9601760 9601760 20260401165502_FbSIC NZ004E 2026-04-02T12:03:38.539Z 2026-04-10T12:35:47.036Z
9601705 9601705 20260401163151_8vGpK NZ004E 2026-04-02T12:03:28.938Z 2026-04-10T12:35:43.853Z
9601562 9601562 20260401154830_LvW3i NZ004E 2026-04-02T12:03:06.316Z 2026-04-10T12:35:41.196Z
9601381 9601381 20260401145820_DcnGM NZ004E 2026-04-02T12:02:37.495Z 2026-04-10T12:35:38.122Z
9601355 9601355 20260401144850_npoiq NZ004E 2026-04-02T12:02:31.667Z 2026-04-10T12:35:37.579Z
9601331 9601331 20260401141806_rtnBD NZ004E 2026-04-02T12:02:26.426Z 2026-04-10T12:35:37.034Z
9601283 9601283 20260401134708_inAPQ NZ004E 2026-04-02T12:02:15.361Z 2026-04-10T12:35:36.138Z
9601233 9601233 20260401132607_peUHL NZ004E 2026-04-02T12:02:04.442Z 2026-04-10T12:35:35.297Z
9601210 9601210 20260401131310_bjdyT NZ004E 2026-04-02T12:02:00.362Z 2026-04-10T12:35:34.944Z
9601136 9601136 20260401122727_xHVx9 NZ004E 2026-04-02T12:01:42.813Z 2026-04-10T12:35:33.686Z
9601108 9601108 20260401115445_t2Izk NZ004E 2026-04-02T12:01:37.204Z 2026-04-10T12:35:33.262Z
9601104 9601104 20260401114822_6ng2m NZ004E 2026-04-02T12:01:35.779Z 2026-04-10T12:35:33.187Z
9601050 9601050 20260401110521_k2gEy NZ004E 2026-04-02T12:01:25.128Z 2026-04-10T12:35:32.295Z
9599923 9599923 20260331172752_sZBRr NZ004E 2026-04-01T12:05:18.817Z 2026-04-09T12:48:01.744Z
9599895 9599895 20260331171830_2352K NZ004E 2026-04-01T12:05:11.758Z 2026-04-09T12:47:59.665Z
9599784 9599784 20260331164910_4F21P NZ004E 2026-04-01T12:04:49.265Z 2026-04-09T12:47:30.443Z
9599569 9599569 20260331154827_2gDRh NZ004E 2026-04-01T12:04:04.781Z 2026-04-09T12:46:59.055Z
9596556 9596556 20260330131302_Un1MB NZ004E 2026-03-31T12:04:30.540Z 2026-04-08T12:43:19.507Z
9596528 9596528 20260330130202_R35KY NZ004E 2026-03-31T12:04:27.724Z 2026-04-08T12:43:18.982Z
9596361 9596361 20260330122308_nETOa NZ004E 2026-03-31T12:04:05.612Z 2026-04-08T12:42:50.355Z
9595929 9595929 20260330101147_t6xvn NZ004E 2026-03-31T12:02:53.122Z 2026-04-08T12:42:36.493Z
9594007 9594007 20260329173954_Nj7QQ NZ004E 2026-03-30T12:05:48.632Z 2026-04-07T12:27:42.452Z
9593876 9593876 20260329162339_063l1 NZ004E 2026-03-30T12:05:21.585Z 2026-04-07T12:27:38.649Z
9593868 9593868 20260329162039_GE9EG NZ004E 2026-03-30T12:05:20.199Z 2026-04-07T12:27:38.458Z
9593769 9593769 20260329150406_7L5Kn NZ004E 2026-03-30T12:05:03.445Z 2026-04-07T12:27:35.272Z
9593760 9593760 20260329150120_7DWR8 NZ004E 2026-03-30T12:05:02.379Z 2026-04-07T12:27:35.083Z
9593727 9593727 20260329142450_wcRGK NZ004E 2026-03-30T12:04:54.845Z 2026-04-07T12:27:33.884Z
9593709 9593709 20260329141338_X9r2f NZ004E 2026-03-30T12:04:52.419Z 2026-04-07T12:27:33.425Z
9593684 9593684 20260329134923_Xcfpu NZ004E 2026-03-30T12:04:47.037Z 2026-04-07T12:27:19.562Z
9593676 9593676 20260329133420_yalN2 NZ004E 2026-03-30T12:04:45.391Z 2026-04-07T12:27:17.389Z
9590890 9590890 20260328114538_v3ggc NZ004E 2026-03-29T12:03:27.356Z 2026-04-06T12:38:39.250Z
9590550 9590550 20260328095918_73VNY NZ004E 2026-03-29T12:02:53.704Z 2026-04-06T12:38:23.618Z
9588019 9588019 20260327173005_26k6d NZ004E 2026-03-28T12:06:56.969Z 2026-04-05T12:35:04.419Z
9587930 9587930 20260327165555_Lo3B3 NZ004E 2026-03-28T12:06:44.680Z 2026-04-05T12:34:59.925Z
9587923 9587923 20260327165107_KJH1A NZ004E 2026-03-28T12:06:43.718Z 2026-04-05T12:34:59.492Z
9572275 9572275 20260324082548_xGSqk NZ004E 2026-03-25T12:04:31.465Z 2026-04-02T12:35:11.969Z
9568675 9568675 20260323171056_DBb0S NZ004E 2026-03-24T12:15:32.219Z 2026-03-31T12:28:40.076Z
9568625 9568625 20260323170606_XfaJt NZ004E 2026-03-24T12:15:24.917Z 2026-03-24T12:24:25.494Z
9568579 9568579 20260323165716_hKZ2A NZ004E 2026-03-24T12:15:19.663Z 2026-03-31T12:28:33.314Z
9568444 9568444 20260323164518_q66vJ NZ004E 2026-03-24T12:15:07.800Z 2026-03-31T12:28:29.305Z
9568342 9568342 20260323163304_19P6m NZ004E 2026-03-24T12:14:55.133Z 2026-03-31T12:28:27.573Z
9568124 9568124 20260323161537_ATFcY NZ004E 2026-03-24T12:14:36.229Z 2026-03-31T12:28:23.362Z
9568025 9568025 20260323160722_zfcXZ NZ004E 2026-03-24T12:14:24.672Z 2026-03-31T12:28:21.821Z
9567849 9567849 20260323155356_sBKs1 NZ004E 2026-03-24T12:14:13.746Z 2026-03-31T12:28:19.816Z
9564523 9564523 20260323104429_oQIHU NZ004E 2026-03-24T12:08:18.014Z 2026-03-31T12:27:10.877Z
9564457 9564457 20260323103548_pWHNE NZ004E 2026-03-24T12:08:08.313Z 2026-03-31T12:27:09.434Z
9564367 9564367 20260323102756_xTrxM NZ004E 2026-03-24T12:07:56.730Z 2026-03-31T12:27:07.909Z
9564080 9564080 20260323095701_Km72a NZ004E 2026-03-24T12:07:23.265Z 2026-03-31T12:27:02.081Z
9564026 9564026 20260323095056_pqPtd NZ004E 2026-03-24T12:07:13.975Z 2026-03-31T12:27:01.114Z
9563993 9563993 20260323094658_rIMzh NZ004E 2026-03-24T12:07:08.154Z 2026-03-31T12:27:00.456Z
9563882 9563882 20260323092620_WQa2U NZ004E 2026-03-24T12:06:55.711Z 2026-03-31T12:26:58.553Z
9563831 9563831 20260323091831_Mtk8o NZ004E 2026-03-24T12:06:49.295Z 2026-03-31T12:26:57.447Z
9559491 9559491 20260321172852_96VWO NZ004E 2026-03-23T12:11:07.794Z 2026-03-29T12:20:39.936Z
9559374 9559374 20260321170617_DA4tu NZ004E 2026-03-23T12:11:03.545Z 2026-03-29T12:20:38.294Z
9559153 9559153 20260321164036_5tUMH NZ004E 2026-03-23T12:10:55.876Z 2026-03-29T12:20:34.613Z
9559141 9559141 20260321164010_Fv0GL NZ004E 2026-03-23T12:10:55.420Z 2026-03-29T12:20:34.504Z
9559092 9559092 20260321163006_dw9Ud NZ004E 2026-03-23T12:10:53.836Z 2026-03-29T12:20:33.938Z
9559032 9559032 20260321162035_5xCca NZ004E 2026-03-23T12:10:51.980Z 2026-03-29T12:20:33.306Z
9559002 9559002 20260321161542_s88j8 NZ004E 2026-03-23T12:10:50.566Z 2026-03-29T12:20:32.934Z
9558887 9558887 20260321160252_v0Wb3 NZ004E 2026-03-23T12:10:38.849Z 2026-03-29T12:20:31.415Z
9558445 9558445 20260322164401_rPCv3 NZ004E 2026-03-23T12:06:44.699Z 2026-03-30T12:30:14.230Z
9558075 9558075 20260322154127_q2qh2 NZ004E 2026-03-23T12:06:22.605Z 2026-03-30T12:30:03.634Z
9558046 9558046 20260322153600_y373w NZ004E 2026-03-23T12:06:21.097Z 2026-03-30T12:30:02.546Z
9558009 9558009 20260322153213_PVH8V NZ004E 2026-03-23T12:06:19.550Z 2026-03-30T12:29:54.333Z
9550913 9550913 20260320172223_N4kme NZ004E 2026-03-22T12:25:57.894Z 2026-03-28T12:36:37.560Z
9550721 9550721 20260320170519_J4iqn NZ004E 2026-03-22T12:25:39.510Z 2026-03-28T12:36:35.413Z
9550663 9550663 20260320165807_M2iAa NZ004E 2026-03-22T12:25:35.133Z 2026-03-28T12:36:33.925Z
9550264 9550264 20260320162530_qqCgc NZ004E 2026-03-22T12:25:05.098Z 2026-03-28T12:36:28.923Z
9550100 9550100 20260320160837_hfYTU NZ004E 2026-03-22T12:24:55.413Z 2026-03-28T12:36:27.113Z
9550058 9550058 20260320160415_JvhbJ NZ004E 2026-03-22T12:24:52.547Z 2026-03-28T12:36:26.541Z
9549786 9549786 20260320153941_Qr9ub NZ004E 2026-03-22T12:24:29.246Z 2026-03-28T12:36:21.449Z
9549784 9549784 20260320153924_hc8u3 NZ004E 2026-03-22T12:24:29.112Z 2026-03-28T12:36:21.422Z
9549659 9549659 20260320152425_Wv5lK NZ004E 2026-03-22T12:24:21.378Z 2026-03-28T12:36:09.285Z
9549085 9549085 20260321171928_eDC5M NZ004E 2026-03-22T12:16:31.380Z 2026-03-29T12:20:39.288Z
9548923 9548923 20260321155113_n3bCk NZ004E 2026-03-22T12:16:14.012Z 2026-03-24T12:28:04.929Z
9548850 9548850 20260321154017_KCk3c NZ004E 2026-03-22T12:16:03.045Z 2026-03-29T12:20:29.382Z
9548738 9548738 20260321153119_4weqC NZ004E 2026-03-22T12:15:54.276Z 2026-03-29T12:20:28.542Z
9548490 9548490 20260321150915_UW2aV NZ004E 2026-03-22T12:15:29.196Z 2026-03-29T12:20:26.778Z
9548457 9548457 20260321150625_XG7i3 NZ004E 2026-03-22T12:15:26.627Z 2026-03-29T12:20:26.579Z
9548128 9548128 20260321143608_lPxaI NZ004E 2026-03-22T12:14:55.783Z 2026-03-29T12:20:24.191Z
9548091 9548091 20260321143126_Yv0Mq NZ004E 2026-03-22T12:14:52.578Z 2026-03-29T12:20:23.920Z
9548073 9548073 20260321142913_ooK3h NZ004E 2026-03-22T12:14:50.377Z 2026-03-29T12:20:23.815Z
9548025 9548025 20260321142613_zyn6a NZ004E 2026-03-22T12:14:46.013Z 2026-03-29T12:20:23.426Z
9548013 9548013 20260321142510_H1LLV NZ004E 2026-03-22T12:14:44.334Z 2026-03-29T12:20:23.289Z
9547980 9547980 20260321142036_Gzs8I NZ004E 2026-03-22T12:14:39.512Z 2026-03-29T12:20:23.133Z
9547976 9547976 20260321142018_14G3S NZ004E 2026-03-22T12:14:39.233Z 2026-03-29T12:20:23.109Z
9547973 9547973 20260321141938_YjxCp NZ004E 2026-03-22T12:14:38.454Z 2026-03-29T12:20:23.014Z
9547966 9547966 20260321141854_yXEyG NZ004E 2026-03-22T12:14:37.765Z 2026-03-29T12:20:22.922Z
9547962 9547962 20260321141840_mpD4M NZ004E 2026-03-22T12:14:37.203Z 2026-03-29T12:20:22.882Z

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