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 = "NZ000Z" 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
9567717 9567717 20260323154311_TjbPh NZ000Z 2026-03-24T12:14:00.941Z 2026-03-31T12:28:17.847Z
9567126 9567126 20260323144217_3KQHy NZ000Z 2026-03-24T12:13:02.442Z 2026-03-31T12:28:08.806Z
9566621 9566621 20260323135820_akcWL NZ000Z 2026-03-24T12:12:13.601Z 2026-03-31T12:27:54.782Z
9566605 9566605 20260323135654_jZLhc NZ000Z 2026-03-24T12:12:11.944Z 2026-03-31T12:27:54.533Z
9566357 9566357 20260323132914_dvqm3 NZ000Z 2026-03-24T12:11:43.617Z 2026-03-31T12:27:49.440Z
9565685 9565685 20260323123315_wEilM NZ000Z 2026-03-24T12:10:39.329Z 2026-03-31T12:27:39.826Z
9565627 9565627 20260323122710_MQ4F9 NZ000Z 2026-03-24T12:10:32.475Z 2026-03-31T12:27:38.701Z
9565572 9565572 20260323122038_k2I2D NZ000Z 2026-03-24T12:10:24.906Z 2026-03-31T12:27:37.587Z
9565193 9565193 20260323114946_cQAJN NZ000Z 2026-03-24T12:09:36.013Z 2026-03-31T12:27:30.694Z
9565103 9565103 20260323114518_Mor4O NZ000Z 2026-03-24T12:09:25.865Z 2026-03-31T12:27:23.049Z
9564724 9564724 20260323110406_QiIYT NZ000Z 2026-03-24T12:08:39.585Z 2026-03-31T12:27:14.326Z
9564717 9564717 20260323110406_4tYnQ NZ000Z 2026-03-24T12:08:39.186Z 2026-03-31T12:27:14.295Z
9564435 9564435 20260323103450_YoGH5 NZ000Z 2026-03-24T12:08:04.709Z 2026-03-31T12:27:09.075Z
9558691 9558691 20260322172835_RqpX2 NZ000Z 2026-03-23T12:06:54.721Z 2026-03-30T12:30:20.448Z
9558652 9558652 20260322171904_TQbjV NZ000Z 2026-03-23T12:06:53.172Z 2026-03-30T12:30:19.506Z
9558409 9558409 20260322163504_GjKrU NZ000Z 2026-03-23T12:06:42.296Z 2026-03-30T12:30:12.707Z
9558297 9558297 20260322161815_Da8tS NZ000Z 2026-03-23T12:06:37.232Z 2026-03-30T12:30:10.179Z
9558293 9558293 20260322161706_gqad2 NZ000Z 2026-03-23T12:06:37.008Z 2026-03-23T12:12:22.875Z
9558206 9558206 20260322160928_41yjQ NZ000Z 2026-03-23T12:06:29.639Z 2026-03-30T12:30:07.879Z
9558190 9558190 20260322160330_h63Cj NZ000Z 2026-03-23T12:06:28.882Z 2026-03-30T12:30:07.288Z
9558174 9558174 20260322160042_P53NC NZ000Z 2026-03-23T12:06:28.230Z 2026-03-30T12:30:06.717Z
9558104 9558104 20260322154636_aSec7 NZ000Z 2026-03-23T12:06:23.869Z 2026-03-30T12:30:04.707Z
9558093 9558093 20260322154504_L8nmS NZ000Z 2026-03-23T12:06:23.378Z 2026-03-30T12:30:04.224Z
9557430 9557430 20260322135830_F2CTW NZ000Z 2026-03-23T12:05:49.966Z 2026-03-30T12:29:37.543Z
9557308 9557308 20260322133354_LPTEK NZ000Z 2026-03-23T12:05:45.742Z 2026-03-30T12:29:34.652Z
9556758 9556758 20260322113428_QYF81 NZ000Z 2026-03-23T12:05:11.571Z 2026-03-30T12:29:10.327Z
9556648 9556648 20260322111555_AVNRE NZ000Z 2026-03-23T12:05:04.751Z 2026-03-30T12:29:06.981Z
9556597 9556597 20260322111249_xFdJf NZ000Z 2026-03-23T12:04:59.313Z 2026-03-30T12:29:05.958Z
9556492 9556492 20260322104414_8umzW NZ000Z 2026-03-23T12:04:51.397Z 2026-03-30T12:29:02.562Z
9556390 9556390 20260322102312_mDGGt NZ000Z 2026-03-23T12:04:44.495Z 2026-03-30T12:28:59.599Z
9556299 9556299 20260322095944_m3eCz NZ000Z 2026-03-23T12:04:38.239Z 2026-03-30T12:28:56.964Z
9556165 9556165 20260322092926_F3pgM NZ000Z 2026-03-23T12:04:26.274Z 2026-03-30T12:28:46.442Z
9556122 9556122 20260322092127_gQR7y NZ000Z 2026-03-23T12:04:22.719Z 2026-03-30T12:28:45.473Z
9556115 9556115 20260322092104_Mt2Le NZ000Z 2026-03-23T12:04:22.478Z 2026-03-30T12:28:45.400Z
9556014 9556014 20260322090314_3Yy5H NZ000Z 2026-03-23T12:04:15.346Z 2026-03-30T12:28:41.753Z
9555978 9555978 20260322085946_6j3KR NZ000Z 2026-03-23T12:04:13.933Z 2026-03-30T12:28:41.047Z
9550757 9550757 20260320171036_i2VyV NZ000Z 2026-03-22T12:25:42.418Z 2026-03-28T12:36:35.845Z
9550611 9550611 20260320165602_kjeXh NZ000Z 2026-03-22T12:25:33.184Z 2026-03-28T12:36:33.388Z
9550418 9550418 20260320163724_SUU35 NZ000Z 2026-03-22T12:25:14.241Z 2026-03-28T12:36:30.569Z
9550411 9550411 20260320163722_OMLjI NZ000Z 2026-03-22T12:25:14.034Z 2026-03-28T12:36:30.545Z
9550195 9550195 20260320161850_Kblfj NZ000Z 2026-03-22T12:25:01.227Z 2026-03-28T12:36:28.184Z
9550064 9550064 20260320160525_eoRk2 NZ000Z 2026-03-22T12:24:53.561Z 2026-03-28T12:36:26.830Z
9549973 9549973 20260320155822_NQyjL NZ000Z 2026-03-22T12:24:41.346Z 2026-03-28T12:36:25.306Z
9549860 9549860 20260320154915_tv3K0 NZ000Z 2026-03-22T12:24:33.274Z 2026-03-28T12:36:22.790Z
9549852 9549852 20260320154911_NyHdg NZ000Z 2026-03-22T12:24:33.036Z 2026-03-28T12:36:22.759Z
9549847 9549847 20260320154825_GKqee NZ000Z 2026-03-22T12:24:32.592Z 2026-03-28T12:36:22.427Z
9549728 9549728 20260320153236_F0IfS NZ000Z 2026-03-22T12:24:25.523Z 2026-03-28T12:36:17.329Z
9549681 9549681 20260320152620_GYv7P NZ000Z 2026-03-22T12:24:22.444Z 2026-03-28T12:36:12.894Z
9549517 9549517 20260320150833_Y3sWJ NZ000Z 2026-03-22T12:24:06.601Z 2026-03-28T12:36:05.563Z
9549406 9549406 20260320145550_Yzzrk NZ000Z 2026-03-22T12:23:57.675Z 2026-03-28T12:36:03.277Z
9549334 9549334 20260320144851_oOH3g NZ000Z 2026-03-22T12:23:52.981Z 2026-03-28T12:36:01.570Z
9548813 9548813 20260321153539_E0kpK NZ000Z 2026-03-22T12:16:00.427Z 2026-03-29T12:20:29.053Z
9548706 9548706 20260321152928_lbukM NZ000Z 2026-03-22T12:15:52.014Z 2026-03-29T12:20:28.262Z
9548608 9548608 20260321151756_nQ5zt NZ000Z 2026-03-22T12:15:39.806Z 2026-03-22T12:27:38.715Z
9548548 9548548 20260321151342_rWgxu NZ000Z 2026-03-22T12:15:34.072Z 2026-03-29T12:20:27.166Z
9548508 9548508 20260321151019_73Xc3 NZ000Z 2026-03-22T12:15:30.772Z 2026-03-29T12:20:26.885Z
9548144 9548144 20260321143740_rcNbG NZ000Z 2026-03-22T12:14:57.029Z 2026-03-29T12:20:24.227Z
9547494 9547494 20260321133323_Agok4 NZ000Z 2026-03-22T12:13:47.112Z 2026-03-29T12:20:09.867Z
9547380 9547380 20260321132238_3JiIm NZ000Z 2026-03-22T12:13:32.920Z 2026-03-29T12:20:09.167Z
9546904 9546904 20260321123943_Qwh9w NZ000Z 2026-03-22T12:12:38.867Z 2026-03-22T12:27:38.351Z
9546885 9546885 20260321123600_ztcZd NZ000Z 2026-03-22T12:12:37.166Z 2026-03-29T12:20:05.051Z
9546835 9546835 20260321123042_F9hh7 NZ000Z 2026-03-22T12:12:29.534Z 2026-03-22T12:27:38.336Z
9546566 9546566 20260321120940_ZKaNp NZ000Z 2026-03-22T12:12:00.705Z 2026-03-29T12:20:02.351Z
9544481 9544481 20260321084416_qqP8p NZ000Z 2026-03-22T12:06:59.192Z 2026-03-29T12:19:30.394Z
9540525 9540525 20260319161154_HLbDj NZ000Z 2026-03-21T12:27:09.934Z 2026-03-27T12:42:23.873Z
9540372 9540372 20260319152750_3JdJA NZ000Z 2026-03-21T12:26:55.621Z 2026-03-27T12:42:20.776Z
9538951 9538951 20260320135815_4c6XP NZ000Z 2026-03-21T12:18:38.881Z 2026-03-28T12:35:55.059Z
9538562 9538562 20260320132038_pJ6QD NZ000Z 2026-03-21T12:17:56.907Z 2026-03-28T12:35:50.044Z
9538478 9538478 20260320130942_23cwk NZ000Z 2026-03-21T12:17:49.091Z 2026-03-28T12:35:48.753Z
9538412 9538412 20260320130045_ZkIeh NZ000Z 2026-03-21T12:17:39.344Z 2026-03-28T12:35:48.200Z
9538362 9538362 20260320125335_Ckn33 NZ000Z 2026-03-21T12:17:34.346Z 2026-03-28T12:35:47.415Z
9538305 9538305 20260320125046_yRIgA NZ000Z 2026-03-21T12:17:28.074Z 2026-03-28T12:35:45.438Z
9538223 9538223 20260320124242_uo7Tb NZ000Z 2026-03-21T12:17:21.261Z 2026-03-28T12:35:36.076Z
9538198 9538198 20260320124028_AwvJW NZ000Z 2026-03-21T12:17:15.913Z 2026-03-28T12:35:35.758Z
9538067 9538067 20260320122958_ZuPsJ NZ000Z 2026-03-21T12:17:02.390Z 2026-03-28T12:35:34.371Z
9538007 9538007 20260320122353_hFw2e NZ000Z 2026-03-21T12:16:57.112Z 2026-03-28T12:35:33.562Z
9537977 9537977 20260320121927_239Om NZ000Z 2026-03-21T12:16:53.408Z 2026-03-28T12:35:33.010Z
9537873 9537873 20260320120916_crASc NZ000Z 2026-03-21T12:16:36.975Z 2026-03-28T12:35:30.136Z
9537851 9537851 20260320120731_lZCKa NZ000Z 2026-03-21T12:16:34.794Z 2026-03-28T12:35:30.004Z
9537635 9537635 20260320115224_Rp06b NZ000Z 2026-03-21T12:16:09.091Z 2026-03-28T12:35:27.935Z
9537409 9537409 20260320113531_GCrvH NZ000Z 2026-03-21T12:15:42.135Z 2026-03-21T12:30:06.155Z
9537128 9537128 20260320111013_jyjVu NZ000Z 2026-03-21T12:15:08.539Z 2026-03-28T12:35:22.000Z
9536981 9536981 20260320105614_BSZzt NZ000Z 2026-03-21T12:14:50.309Z 2026-03-28T12:35:19.919Z
9536796 9536796 20260320103316_DT41j NZ000Z 2026-03-21T12:14:25.369Z 2026-03-28T12:35:16.414Z
9536756 9536756 20260320102945_mrUuB NZ000Z 2026-03-21T12:14:15.905Z 2026-03-28T12:35:15.444Z
9536699 9536699 20260320102050_iUmhy NZ000Z 2026-03-21T12:14:08.179Z 2026-03-21T12:30:05.929Z
9536664 9536664 20260320101529_bTe3i NZ000Z 2026-03-21T12:14:03.063Z 2026-03-28T12:35:05.152Z
9536027 9536027 20260320090138_c5E5w NZ000Z 2026-03-21T12:12:24.876Z 2026-03-28T12:34:55.678Z
9535828 9535828 20260320083538_5oPgj NZ000Z 2026-03-21T12:11:58.739Z 2026-03-28T12:34:51.928Z
9535596 9535596 20260320080546_92oVk NZ000Z 2026-03-21T12:11:17.132Z 2026-03-28T12:34:47.557Z
9535569 9535569 20260320080127_GDjex NZ000Z 2026-03-21T12:11:12.480Z 2026-03-28T12:34:46.945Z
9528666 9528666 20260318163610_UlM0p NZ000Z 2026-03-20T12:22:26.450Z 2026-03-26T12:38:37.522Z
9528342 9528342 20260318160805_XdjZX NZ000Z 2026-03-20T12:22:13.525Z 2026-03-26T12:38:35.599Z
9528137 9528137 20260318154642_BdInp NZ000Z 2026-03-20T12:21:57.111Z 2026-03-26T12:38:34.184Z
9528065 9528065 20260318154112_NQKlv NZ000Z 2026-03-20T12:21:54.555Z 2026-03-26T12:38:32.945Z
9528026 9528026 20260318153656_aISzz NZ000Z 2026-03-20T12:21:53.349Z 2026-03-26T12:38:32.761Z
9527867 9527867 20260318152217_L8FFI NZ000Z 2026-03-20T12:21:47.082Z 2026-03-26T12:38:31.864Z
9527555 9527555 20260318145459_Dgky3 NZ000Z 2026-03-20T12:21:24.669Z 2026-03-26T12:38:29.591Z
9527452 9527452 20260318144249_xFH9I NZ000Z 2026-03-20T12:21:18.428Z 2026-03-26T12:38:28.713Z
9527440 9527440 20260318144048_DCErG NZ000Z 2026-03-20T12:21:17.770Z 2026-03-26T12:38:28.628Z

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