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

1,515 rows where station_code = "NZ0067" 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
9627461 9627461 20260408174414_nn4WA NZ0067 2026-04-09T12:11:06.429Z 2026-04-10T12:14:22.547Z
9627432 9627432 20260408173511_7SU5B NZ0067 2026-04-09T12:10:55.412Z 2026-04-10T12:14:22.542Z
9627420 9627420 20260408173153_MfoTi NZ0067 2026-04-09T12:10:53.821Z 2026-04-10T12:14:22.541Z
9627311 9627311 20260408170513_b8DKm NZ0067 2026-04-09T12:10:37.276Z 2026-04-10T12:14:22.520Z
9627130 9627130 20260408162835_NQVcg NZ0067 2026-04-09T12:10:07.968Z 2026-04-10T12:14:22.487Z
9627072 9627072 20260408160946_sHGTd NZ0067 2026-04-09T12:09:53.577Z 2026-04-10T12:14:22.475Z
9627068 9627068 20260408160748_vSEO6 NZ0067 2026-04-09T12:09:53.133Z 2026-04-10T12:14:22.474Z
9627047 9627047 20260408160026_MiQLl NZ0067 2026-04-09T12:09:50.500Z 2026-04-10T12:14:22.467Z
9626573 9626573 20260408141812_tUVGG NZ0067 2026-04-09T12:08:42.954Z 2026-04-10T12:14:22.376Z
9626433 9626433 20260408140305_DX31f NZ0067 2026-04-09T12:08:20.897Z 2026-04-10T12:14:22.353Z
9626428 9626428 20260408140245_FnvFc NZ0067 2026-04-09T12:08:20.354Z 2026-04-10T12:14:22.352Z
9626313 9626313 20260408134144_QSqyi NZ0067 2026-04-09T12:07:58.119Z 2026-04-10T12:14:22.332Z
9626299 9626299 20260408134009_hnk83 NZ0067 2026-04-09T12:07:56.226Z 2026-04-10T12:14:22.330Z
9626285 9626285 20260408133803_CCnSr NZ0067 2026-04-09T12:07:55.243Z 2026-04-10T12:14:22.329Z
9626220 9626220 20260408132621_ALeQP NZ0067 2026-04-09T12:07:47.336Z 2026-04-10T12:14:22.319Z
9626097 9626097 20260408131043_Nm3Ei NZ0067 2026-04-09T12:07:34.801Z 2026-04-10T12:14:22.295Z
9626081 9626081 20260408130736_EaLyR NZ0067 2026-04-09T12:07:33.353Z 2026-04-10T12:14:22.293Z
9626070 9626070 20260408130332_G0aHx NZ0067 2026-04-09T12:07:31.346Z 2026-04-10T12:14:22.291Z
9625917 9625917 20260408122428_yYO1J NZ0067 2026-04-09T12:07:06.718Z 2026-04-10T12:14:22.263Z
9625753 9625753 20260408114406_NSYyw NZ0067 2026-04-09T12:06:35.477Z 2026-04-10T12:14:22.234Z
9625725 9625725 20260408113953_g9cA3 NZ0067 2026-04-09T12:06:24.521Z 2026-04-10T12:14:22.229Z
9625681 9625681 20260408113421_md17c NZ0067 2026-04-09T12:06:16.959Z 2026-04-10T12:14:22.223Z
9625266 9625266 20260408101250_cNIAS NZ0067 2026-04-09T12:04:56.259Z 2026-04-10T12:14:21.892Z
9624977 9624977 20260408090642_c4Q06 NZ0067 2026-04-09T12:03:38.581Z 2026-04-10T12:14:21.825Z
9624744 9624744 20260408082019_CRZGz NZ0067 2026-04-09T12:02:47.561Z 2026-04-10T12:14:21.451Z
9624529 9624529 20260408073200_3T3xb NZ0067 2026-04-09T12:01:52.558Z 2026-04-10T12:14:21.400Z
9624508 9624508 20260408072337_ZFqsp NZ0067 2026-04-09T12:01:47.279Z 2026-04-10T12:14:21.393Z
9603816 9603816 20260402125202_Ogfyj NZ0067 2026-04-03T12:04:47.111Z 2026-04-10T12:34:10.287Z
9603423 9603423 20260402101004_dRR3j NZ0067 2026-04-03T12:03:02.500Z 2026-04-10T12:34:01.725Z
9600182 9600182 20260330074519_oR2qv NZ0067 2026-04-01T12:07:12.367Z 2026-04-08T12:42:28.501Z
9587826 9587826 20260327161842_QZgmW NZ0067 2026-03-28T12:06:28.191Z 2026-04-05T12:34:45.365Z
9587824 9587824 20260327161553_DJRft NZ0067 2026-03-28T12:06:27.774Z 2026-04-05T12:34:45.271Z
9580199 9580199 20260323150413_EQ8Kj NZ0067 2026-03-26T12:18:56.455Z 2026-03-31T12:28:12.417Z
9580186 9580186 20260323124441_eYKZh NZ0067 2026-03-26T12:18:12.126Z 2026-03-31T12:27:42.376Z
9578747 9578747 20260325140034_1esxC NZ0067 2026-03-26T12:08:23.975Z 2026-04-03T12:38:30.034Z
9574859 9574859 20260323172906_wLz36 NZ0067 2026-03-25T12:19:47.720Z 2026-03-31T12:28:43.520Z
9574851 9574851 20260323172805_UtOIQ NZ0067 2026-03-25T12:19:46.831Z 2026-03-31T12:28:43.292Z
9574754 9574754 20260323170130_ndkAA NZ0067 2026-03-25T12:19:15.959Z 2026-03-31T12:28:38.441Z
9574703 9574703 20260323144537_nc1Kp NZ0067 2026-03-25T12:16:32.033Z 2026-03-31T12:28:08.972Z
9574701 9574701 20260323141254_aw3JP NZ0067 2026-03-25T12:15:58.408Z 2026-03-31T12:28:01.105Z
9574699 9574699 20260323135606_1SUnR NZ0067 2026-03-25T12:15:48.969Z 2026-03-31T12:27:54.323Z
9574697 9574697 20260323134947_OGLbw NZ0067 2026-03-25T12:15:46.158Z 2026-03-31T12:27:53.306Z
9574682 9574682 20260323125303_WPFOf NZ0067 2026-03-25T12:15:20.675Z 2026-03-31T12:27:43.759Z
9574663 9574663 20260323112426_uedy3 NZ0067 2026-03-25T12:14:29.273Z 2026-03-31T12:27:19.107Z
9574493 9574493 20260324171826_UG3Vy NZ0067 2026-03-25T12:10:45.320Z 2026-04-02T12:37:00.527Z
9574487 9574487 20260324171714_HG3jM NZ0067 2026-03-25T12:10:44.546Z 2026-04-02T12:37:00.409Z
9573902 9573902 20260324141904_79eFw NZ0067 2026-03-25T12:09:08.596Z 2026-04-02T12:36:31.086Z
9573872 9573872 20260324141239_E9kTY NZ0067 2026-03-25T12:09:04.470Z 2026-04-02T12:36:30.084Z
9573851 9573851 20260324140636_9spCF NZ0067 2026-03-25T12:09:01.793Z 2026-04-02T12:36:29.521Z
9573738 9573738 20260324133821_7EPau NZ0067 2026-03-25T12:08:41.289Z 2026-04-02T12:36:25.619Z
9573517 9573517 20260324123449_Xs85z NZ0067 2026-03-25T12:08:12.051Z 2026-04-02T12:36:12.260Z
9572941 9572941 20260324105815_etOp6 NZ0067 2026-03-25T12:06:47.041Z 2026-04-02T12:35:44.297Z
9572863 9572863 20260324104237_gKeVP NZ0067 2026-03-25T12:06:32.932Z 2026-04-02T12:35:41.646Z
9572860 9572860 20260324104237_6pjgU NZ0067 2026-03-25T12:06:32.414Z 2026-04-02T12:35:41.577Z
9572763 9572763 20260324100856_0uUIp NZ0067 2026-03-25T12:06:13.507Z 2026-04-02T12:35:37.365Z
9572716 9572716 20260324095938_dvM3z NZ0067 2026-03-25T12:06:06.271Z 2026-04-02T12:35:35.786Z
9572621 9572621 20260324093948_lOc2E NZ0067 2026-03-25T12:05:47.344Z 2026-04-02T12:35:32.153Z
9572554 9572554 20260324092747_POa5P NZ0067 2026-03-25T12:05:33.203Z 2026-04-02T12:35:29.703Z
9572480 9572480 20260324091219_Otc21 NZ0067 2026-03-25T12:05:18.324Z 2026-04-02T12:35:26.515Z
9568752 9568752 20260323171850_2b8hD NZ0067 2026-03-24T12:15:40.837Z 2026-03-24T12:24:25.521Z
9568720 9568720 20260323171550_tRe5h NZ0067 2026-03-24T12:15:37.694Z 2026-03-31T12:28:40.995Z
9568660 9568660 20260323170927_rxUTW NZ0067 2026-03-24T12:15:28.373Z 2026-03-31T12:28:39.778Z
9568495 9568495 20260323164846_YhIzd NZ0067 2026-03-24T12:15:11.350Z 2026-03-31T12:28:29.911Z
9568353 9568353 20260323163354_3Fvvj NZ0067 2026-03-24T12:14:56.316Z 2026-03-31T12:28:27.872Z
9568202 9568202 20260323161839_prQeF NZ0067 2026-03-24T12:14:43.482Z 2026-03-31T12:28:24.491Z
9567838 9567838 20260323155257_wrHWS NZ0067 2026-03-24T12:14:12.860Z 2026-03-31T12:28:19.698Z
9567804 9567804 20260323155028_DncHT NZ0067 2026-03-24T12:14:10.007Z 2026-03-24T12:24:25.345Z
9567776 9567776 20260323154835_eMZfc NZ0067 2026-03-24T12:14:07.927Z 2026-03-31T12:28:18.653Z
9567774 9567774 20260323154835_bQ1D3 NZ0067 2026-03-24T12:14:07.785Z 2026-03-25T12:21:38.251Z
9567693 9567693 20260323154109_57vQ2 NZ0067 2026-03-24T12:13:58.736Z 2026-03-31T12:28:17.513Z
9567386 9567386 20260323151234_aQyia NZ0067 2026-03-24T12:13:29.872Z 2026-03-24T12:24:25.270Z
9567335 9567335 20260323150741_MMc8q NZ0067 2026-03-24T12:13:24.412Z 2026-03-25T12:21:38.156Z
9567106 9567106 20260323144114_4mqtl NZ0067 2026-03-24T12:13:01.016Z 2026-03-31T12:28:08.528Z
9566883 9566883 20260323142154_I9ItD NZ0067 2026-03-24T12:12:38.904Z 2026-03-31T12:28:05.603Z
9566687 9566687 20260323140445_JtaKd NZ0067 2026-03-24T12:12:19.019Z 2026-03-25T12:21:37.979Z
9566683 9566683 20260323140402_HVTsV NZ0067 2026-03-24T12:12:18.118Z 2026-03-31T12:27:55.457Z
9566675 9566675 20260323140300_wQGdS NZ0067 2026-03-24T12:12:17.298Z 2026-03-31T12:27:55.313Z
9566579 9566579 20260323135542_3f34o NZ0067 2026-03-24T12:12:08.875Z 2026-03-31T12:27:54.042Z
9566374 9566374 20260323132958_RjIsV NZ0067 2026-03-24T12:11:44.816Z 2026-03-31T12:27:49.682Z
9566349 9566349 20260323132756_g3eAa NZ0067 2026-03-24T12:11:42.890Z 2026-03-31T12:27:49.137Z
9566344 9566344 20260323132704_i3DA4 NZ0067 2026-03-24T12:11:42.057Z 2026-03-31T12:27:48.978Z
9565947 9565947 20260323125319_V9n6h NZ0067 2026-03-24T12:11:05.583Z 2026-03-31T12:27:43.867Z
9565935 9565935 20260323125302_Xs5uX NZ0067 2026-03-24T12:11:03.540Z 2026-03-31T12:27:43.720Z
9565902 9565902 20260323125006_09q34 NZ0067 2026-03-24T12:11:00.524Z 2026-03-31T12:27:43.313Z
9565864 9565864 20260323124441_Hi2rY NZ0067 2026-03-24T12:10:56.842Z 2026-03-31T12:27:42.430Z
9565848 9565848 20260323124426_aC2HQ NZ0067 2026-03-24T12:10:56.108Z 2026-03-31T12:27:42.344Z
9565767 9565767 20260323124019_71Mhv NZ0067 2026-03-24T12:10:49.066Z 2026-03-31T12:27:40.989Z
9565488 9565488 20260323121300_83ldH NZ0067 2026-03-24T12:10:17.074Z 2026-03-31T12:27:36.345Z
9565265 9565265 20260323115601_cV2aH NZ0067 2026-03-24T12:09:46.492Z 2026-03-31T12:27:32.214Z
9564876 9564876 20260323111856_Ad2n3 NZ0067 2026-03-24T12:08:56.845Z 2026-03-31T12:27:17.079Z
9564313 9564313 20260323102340_yekP3 NZ0067 2026-03-24T12:07:51.348Z 2026-03-31T12:27:07.033Z
9564221 9564221 20260323101317_rJyLk NZ0067 2026-03-24T12:07:38.731Z 2026-03-31T12:27:05.292Z
9564152 9564152 20260323100427_3nkft NZ0067 2026-03-24T12:07:30.820Z 2026-03-31T12:27:03.627Z
9563826 9563826 20260323091736_zQvnb NZ0067 2026-03-24T12:06:48.862Z 2026-03-31T12:26:57.391Z
9563705 9563705 20260323090133_9PjcU NZ0067 2026-03-24T12:06:35.482Z 2026-03-31T12:26:49.595Z
9563325 9563325 20260323075820_sRtam NZ0067 2026-03-24T12:05:44.158Z 2026-03-31T12:26:40.699Z
9558348 9558348 20260322162618_h32J4 NZ0067 2026-03-23T12:06:39.651Z 2026-03-30T12:30:11.292Z
9558270 9558270 20260322161524_gaLoQ NZ0067 2026-03-23T12:06:36.030Z 2026-03-30T12:30:09.691Z
9558164 9558164 20260322155835_KHtfw NZ0067 2026-03-23T12:06:27.790Z 2026-03-30T12:30:06.431Z
9558152 9558152 20260322155804_bK8oX NZ0067 2026-03-23T12:06:27.117Z 2026-03-30T12:30:06.143Z

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