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

5,764 rows where station_code = "NZ005B" 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
9626714 9626714 20260408145701_2nicF NZ005B 2026-04-09T12:09:04.817Z 2026-04-09T12:09:04.817Z
9626691 9626691 20260408145105_MKEO4 NZ005B 2026-04-09T12:09:00.879Z 2026-04-09T12:09:00.879Z
9626605 9626605 20260408142549_2FWPA NZ005B 2026-04-09T12:08:46.057Z 2026-04-09T12:08:46.057Z
9626556 9626556 20260408141557_2hEVb NZ005B 2026-04-09T12:08:41.191Z 2026-04-09T12:08:41.191Z
9626525 9626525 20260408141101_v3tnU NZ005B 2026-04-09T12:08:38.006Z 2026-04-09T12:08:38.006Z
9626477 9626477 20260408140535_hNkNu NZ005B 2026-04-09T12:08:25.248Z 2026-04-09T12:08:25.248Z
9626232 9626232 20260408132815_T3EqC NZ005B 2026-04-09T12:07:48.356Z 2026-04-09T12:07:48.356Z
9626025 9626025 20260408125330_Gs3Yz NZ005B 2026-04-09T12:07:20.904Z 2026-04-09T12:07:20.904Z
9625992 9625992 20260408124716_QX8Jr NZ005B 2026-04-09T12:07:15.863Z 2026-04-09T12:07:15.863Z
9625911 9625911 20260408122416_l582Q NZ005B 2026-04-09T12:07:06.238Z 2026-04-09T12:07:06.238Z
9625841 9625841 20260408120415_jlKuX NZ005B 2026-04-09T12:06:53.652Z 2026-04-09T12:06:53.652Z
9610174 9610174 20260405141019_LpleS NZ005B 2026-04-06T12:06:09.172Z 2026-04-09T12:36:38.320Z
9610164 9610164 20260405140355_tA1gt NZ005B 2026-04-06T12:06:07.330Z 2026-04-09T12:36:38.049Z
9607299 9607299 20260404070954_5e2WL NZ005B 2026-04-05T12:01:28.789Z 2026-04-09T12:39:18.405Z
9607292 9607292 20260404070643_c0Fzc NZ005B 2026-04-05T12:01:26.655Z 2026-04-09T12:39:18.177Z
9606329 9606329 20260403170553_HgyTd NZ005B 2026-04-04T12:06:24.977Z 2026-04-09T12:42:14.276Z
9606327 9606327 20260403170553_rETno NZ005B 2026-04-04T12:06:24.577Z 2026-04-09T12:42:14.182Z
9606233 9606233 20260403163133_nC8Cg NZ005B 2026-04-04T12:06:07.198Z 2026-04-09T12:42:12.058Z
9606174 9606174 20260403155517_2FSlK NZ005B 2026-04-04T12:05:45.608Z 2026-04-09T12:42:10.206Z
9606172 9606172 20260403155336_KFai1 NZ005B 2026-04-04T12:05:45.037Z 2026-04-09T12:42:10.120Z
9606119 9606119 20260403152135_48mpR NZ005B 2026-04-04T12:05:30.013Z 2026-04-09T12:42:08.726Z
9606086 9606086 20260403150145_a8Dgb NZ005B 2026-04-04T12:05:21.656Z 2026-04-09T12:42:07.857Z
9606083 9606083 20260403145957_eIkqp NZ005B 2026-04-04T12:05:18.275Z 2026-04-09T12:42:07.793Z
9606079 9606079 20260403145326_7HOsA NZ005B 2026-04-04T12:05:16.837Z 2026-04-09T12:42:07.680Z
9606066 9606066 20260403144658_aiXWT NZ005B 2026-04-04T12:05:11.858Z 2026-04-09T12:42:07.404Z
9605995 9605995 20260403135124_U51ao NZ005B 2026-04-04T12:04:52.512Z 2026-04-09T12:42:05.594Z
9605991 9605991 20260403135118_jzx6m NZ005B 2026-04-04T12:04:52.069Z 2026-04-09T12:42:05.492Z
9605973 9605973 20260403133815_gQ7sC NZ005B 2026-04-04T12:04:43.991Z 2026-04-09T12:42:05.272Z
9605935 9605935 20260403131812_0aVMH NZ005B 2026-04-04T12:04:31.284Z 2026-04-09T12:42:04.184Z
9605919 9605919 20260403131014_or8fY NZ005B 2026-04-04T12:04:27.106Z 2026-04-09T12:42:03.787Z
9605916 9605916 20260403130954_5u0Ln NZ005B 2026-04-04T12:04:26.657Z 2026-04-09T12:42:03.746Z
9605878 9605878 20260403123506_T3ZT3 NZ005B 2026-04-04T12:04:17.034Z 2026-04-09T12:42:03.032Z
9605831 9605831 20260403121113_v6k9J NZ005B 2026-04-04T12:04:04.069Z 2026-04-09T12:41:58.886Z
9605825 9605825 20260403121054_rURBB NZ005B 2026-04-04T12:04:02.971Z 2026-04-09T12:41:54.930Z
9605748 9605748 20260403115142_sV4jJ NZ005B 2026-04-04T12:03:41.608Z 2026-04-09T12:41:30.708Z
9605564 9605564 20260403104923_fLNj4 NZ005B 2026-04-04T12:02:55.075Z 2026-04-09T12:41:25.219Z
9603740 9603740 20260402115953_d45Gu NZ005B 2026-04-03T12:04:21.311Z 2026-04-09T12:44:07.957Z
9603674 9603674 20260402114438_rbvUZ NZ005B 2026-04-03T12:04:02.578Z 2026-04-09T12:44:06.617Z
9603176 9603176 20260402083213_10JeP NZ005B 2026-04-03T12:02:03.300Z 2026-04-09T12:43:22.321Z
9599835 9599835 20260331170652_ye1F7 NZ005B 2026-04-01T12:05:00.903Z 2026-04-09T12:47:36.510Z
9599772 9599772 20260331164613_McdfA NZ005B 2026-04-01T12:04:46.912Z 2026-04-09T12:47:30.119Z
9599343 9599343 20260331140311_YXpJs NZ005B 2026-04-01T12:03:15.239Z 2026-04-09T12:46:46.235Z
9599138 9599138 20260331120242_aV4IU NZ005B 2026-04-01T12:02:29.989Z 2026-04-09T12:46:42.323Z
9599078 9599078 20260331113049_aXJrh NZ005B 2026-04-01T12:02:16.407Z 2026-04-09T12:46:41.070Z
9599058 9599058 20260331111704_HoDNl NZ005B 2026-04-01T12:02:13.304Z 2026-04-09T12:46:40.714Z
9597947 9597947 20260330172207_0DZ9j NZ005B 2026-03-31T12:07:19.844Z 2026-04-08T12:44:21.405Z
9597908 9597908 20260330171427_umtz3 NZ005B 2026-03-31T12:07:15.217Z 2026-04-08T12:44:20.287Z
9597854 9597854 20260330170922_DZp0u NZ005B 2026-03-31T12:07:07.351Z 2026-04-08T12:44:19.034Z
9597803 9597803 20260330170028_jyxGM NZ005B 2026-03-31T12:07:01.909Z 2026-04-08T12:44:17.792Z
9597794 9597794 20260330170026_JG2ns NZ005B 2026-03-31T12:07:01.255Z 2026-04-08T12:44:17.619Z
9597783 9597783 20260330165841_Oe3TU NZ005B 2026-03-31T12:06:59.939Z 2026-04-08T12:44:17.270Z
9597770 9597770 20260330165826_7Z2Qx NZ005B 2026-03-31T12:06:59.182Z 2026-04-08T12:44:16.971Z
9597616 9597616 20260330164454_1g1Nv NZ005B 2026-03-31T12:06:47.261Z 2026-04-08T12:44:05.332Z
9597483 9597483 20260330162516_EibAr NZ005B 2026-03-31T12:06:28.114Z 2026-04-08T12:43:44.003Z
9597468 9597468 20260330162233_fLFFC NZ005B 2026-03-31T12:06:27.074Z 2026-04-08T12:43:43.738Z
9597439 9597439 20260330161735_Ic4Ly NZ005B 2026-03-31T12:06:23.367Z 2026-04-08T12:43:42.990Z
9597431 9597431 20260330161719_xWNQU NZ005B 2026-03-31T12:06:22.667Z 2026-04-08T12:43:42.727Z
9597354 9597354 20260330161105_TZx4Z NZ005B 2026-03-31T12:06:13.669Z 2026-04-08T12:43:41.270Z
9597305 9597305 20260330155913_5tGyX NZ005B 2026-03-31T12:06:06.492Z 2026-04-08T12:43:38.077Z
9597295 9597295 20260330155830_4uDIo NZ005B 2026-03-31T12:06:05.684Z 2026-04-08T12:43:37.906Z
9597271 9597271 20260330155414_f0N2t NZ005B 2026-03-31T12:06:03.435Z 2026-04-08T12:43:37.457Z
9597251 9597251 20260330154846_wRr3t NZ005B 2026-03-31T12:06:00.908Z 2026-04-08T12:43:36.914Z
9597197 9597197 20260330153401_I3UWK NZ005B 2026-03-31T12:05:52.995Z 2026-04-08T12:43:35.295Z
9597174 9597174 20260330153214_AXq2w NZ005B 2026-03-31T12:05:50.777Z 2026-04-08T12:43:34.854Z
9596996 9596996 20260330145359_ce7GV NZ005B 2026-03-31T12:05:26.814Z 2026-04-08T12:43:29.841Z
9596970 9596970 20260330144952_3G4iJ NZ005B 2026-03-31T12:05:22.836Z 2026-04-08T12:43:29.180Z
9596964 9596964 20260330144712_FiZQm NZ005B 2026-03-31T12:05:22.408Z 2026-04-08T12:43:29.117Z
9596863 9596863 20260330141904_27w2Z NZ005B 2026-03-31T12:05:06.501Z 2026-04-08T12:43:26.476Z
9596845 9596845 20260330141538_R3PMN NZ005B 2026-03-31T12:05:04.254Z 2026-04-08T12:43:25.869Z
9596581 9596581 20260330131622_0WSd0 NZ005B 2026-03-31T12:04:32.394Z 2026-04-08T12:43:19.861Z
9596470 9596470 20260330124406_O8WK2 NZ005B 2026-03-31T12:04:19.743Z 2026-04-08T12:43:15.320Z
9596449 9596449 20260330123831_L1ULH NZ005B 2026-03-31T12:04:16.917Z 2026-04-08T12:43:12.004Z
9596436 9596436 20260330123634_i3cD9 NZ005B 2026-03-31T12:04:15.895Z 2026-04-08T12:43:04.504Z
9596425 9596425 20260330123255_21z3k NZ005B 2026-03-31T12:04:13.157Z 2026-04-08T12:42:58.023Z
9596400 9596400 20260330122814_3EYwZ NZ005B 2026-03-31T12:04:09.857Z 2026-04-08T12:42:51.072Z
9596322 9596322 20260330121908_rPg3g NZ005B 2026-03-31T12:04:02.013Z 2026-04-08T12:42:49.643Z
9596193 9596193 20260330114124_2MsoS NZ005B 2026-03-31T12:03:42.241Z 2026-04-08T12:42:43.769Z
9596147 9596147 20260330112448_WMeET NZ005B 2026-03-31T12:03:35.719Z 2026-04-08T12:42:42.459Z
9596050 9596050 20260330105018_BEBMW NZ005B 2026-03-31T12:03:14.224Z 2026-04-08T12:42:39.544Z
9595968 9595968 20260330101802_3rqYu NZ005B 2026-03-31T12:03:01.301Z 2026-04-08T12:42:37.422Z
9595960 9595960 20260330101552_71OCh NZ005B 2026-03-31T12:03:00.393Z 2026-04-08T12:42:37.344Z
9595958 9595958 20260330101551_9L6rQ NZ005B 2026-03-31T12:03:00.067Z 2026-04-08T12:42:37.269Z
9591499 9591499 20260328165257_Wco1q NZ005B 2026-03-29T12:04:30.506Z 2026-04-06T12:39:18.489Z
9591403 9591403 20260328162026_tx4ct NZ005B 2026-03-29T12:04:21.681Z 2026-04-06T12:39:14.184Z
9591193 9591193 20260328141442_Ik27B NZ005B 2026-03-29T12:03:59.447Z 2026-04-06T12:39:04.843Z
9590920 9590920 20260328115652_nk481 NZ005B 2026-03-29T12:03:29.686Z 2026-04-06T12:38:40.620Z
9590728 9590728 20260328105501_Px9as NZ005B 2026-03-29T12:03:11.143Z 2026-04-06T12:38:31.841Z
9590721 9590721 20260328105500_qyoAB NZ005B 2026-03-29T12:03:10.977Z 2026-04-06T12:38:31.717Z
9590585 9590585 20260328101009_yq45L NZ005B 2026-03-29T12:02:57.447Z 2026-04-06T12:38:25.667Z
9590366 9590366 20260328083756_GTrDo NZ005B 2026-03-29T12:02:29.268Z 2026-04-06T12:38:03.197Z
9590313 9590313 20260328080804_DGEVr NZ005B 2026-03-29T12:02:24.326Z 2026-04-06T12:38:00.807Z
9565642 9565642 20260323123006_0QEpc NZ005B 2026-03-24T12:10:35.270Z 2026-03-31T12:27:39.111Z
9564388 9564388 20260323103055_tpVmq NZ005B 2026-03-24T12:08:00.681Z 2026-03-31T12:27:08.480Z
9563137 9563137 20260323071400_BA7PL NZ005B 2026-03-24T12:05:12.646Z 2026-03-31T12:26:35.969Z
9550166 9550166 20260320161417_vyuQw NZ005B 2026-03-22T12:24:59.490Z 2026-03-28T12:36:27.829Z
9549827 9549827 20260320154529_GDGau NZ005B 2026-03-22T12:24:31.679Z 2026-03-28T12:36:22.026Z
9549760 9549760 20260320153506_1WqjJ NZ005B 2026-03-22T12:24:27.354Z 2026-03-28T12:36:20.036Z
9549691 9549691 20260320152706_VP9oy NZ005B 2026-03-22T12:24:23.009Z 2026-03-28T12:36:13.352Z
9549575 9549575 20260320151450_hkRqC NZ005B 2026-03-22T12:24:10.305Z 2026-03-28T12:36:06.352Z
9548544 9548544 20260321151342_W4XYt NZ005B 2026-03-22T12:15:33.825Z 2026-03-29T12:20:27.134Z

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