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,110 rows where station_code = "NZ005N" 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
9627459 9627459 20260408174414_nn4WA NZ005N 2026-04-09T12:11:06.429Z 2026-04-10T12:14:22.547Z
9627265 9627265 20260408165527_8dPXj NZ005N 2026-04-09T12:10:29.778Z 2026-04-10T12:14:22.511Z
9627160 9627160 20260408163241_KySn5 NZ005N 2026-04-09T12:10:11.654Z 2026-04-10T12:14:22.491Z
9627152 9627152 20260408163240_UXUIE NZ005N 2026-04-09T12:10:11.120Z 2026-04-10T12:14:22.491Z
9627145 9627145 20260408163142_9RTsp NZ005N 2026-04-09T12:10:10.486Z 2026-04-10T12:14:22.490Z
9627030 9627030 20260408155625_0Ii5K NZ005N 2026-04-09T12:09:47.045Z 2026-04-10T12:14:22.463Z
9626963 9626963 20260408153818_FlMFB NZ005N 2026-04-09T12:09:37.801Z 2026-04-10T12:14:22.445Z
9626904 9626904 20260408152027_3dIMF NZ005N 2026-04-09T12:09:30.246Z 2026-04-10T12:14:22.432Z
9626877 9626877 20260408151859_aAtyq NZ005N 2026-04-09T12:09:23.265Z 2026-04-10T12:14:22.429Z
9626833 9626833 20260408151221_2K693 NZ005N 2026-04-09T12:09:16.544Z 2026-04-10T12:14:22.421Z
9626736 9626736 20260408145937_cCcwm NZ005N 2026-04-09T12:09:06.386Z 2026-04-10T12:14:22.406Z
9626657 9626657 20260408143700_iIVB6 NZ005N 2026-04-09T12:08:52.799Z 2026-04-10T12:14:22.393Z
9626515 9626515 20260408140944_e22Oe NZ005N 2026-04-09T12:08:35.995Z 2026-04-10T12:14:22.365Z
9626499 9626499 20260408140637_HKvFL NZ005N 2026-04-09T12:08:28.079Z 2026-04-10T12:14:22.362Z
9626470 9626470 20260408140456_iPY4W NZ005N 2026-04-09T12:08:23.877Z 2026-04-10T12:14:22.358Z
9626460 9626460 20260408140441_Ol7Ah NZ005N 2026-04-09T12:08:23.394Z 2026-04-10T12:14:22.357Z
9626417 9626417 20260408140002_A5O4N NZ005N 2026-04-09T12:08:18.507Z 2026-04-10T12:14:22.350Z
9626284 9626284 20260408133803_CCnSr NZ005N 2026-04-09T12:07:55.243Z 2026-04-10T12:14:22.329Z
9626249 9626249 20260408133101_IEur3 NZ005N 2026-04-09T12:07:49.606Z 2026-04-10T12:14:22.323Z
9626219 9626219 20260408132621_ALeQP NZ005N 2026-04-09T12:07:47.336Z 2026-04-10T12:14:22.319Z
9626167 9626167 20260408132125_MkxD3 NZ005N 2026-04-09T12:07:43.476Z 2026-04-10T12:14:22.313Z
9626164 9626164 20260408132116_VNZZ2 NZ005N 2026-04-09T12:07:43.051Z 2026-04-10T12:14:22.312Z
9626150 9626150 20260408131849_5nvwW NZ005N 2026-04-09T12:07:41.284Z 2026-04-10T12:14:22.310Z
9626138 9626138 20260408131605_ULKaC NZ005N 2026-04-09T12:07:40.413Z 2026-04-10T12:14:22.308Z
9625265 9625265 20260408101250_cNIAS NZ005N 2026-04-09T12:04:56.244Z 2026-04-10T12:14:21.892Z
9604402 9604402 20260402180014_G2taW NZ005N 2026-04-03T12:07:17.803Z 2026-04-10T12:34:50.108Z
9604390 9604390 20260402174807_Hu4P0 NZ005N 2026-04-03T12:07:14.774Z 2026-04-10T12:34:49.758Z
9604370 9604370 20260402173146_7AGjl NZ005N 2026-04-03T12:07:05.994Z 2026-04-10T12:34:49.225Z
9604344 9604344 20260402171742_aMcwA NZ005N 2026-04-03T12:06:57.702Z 2026-04-10T12:34:48.644Z
9604315 9604315 20260402170600_I23S3 NZ005N 2026-04-03T12:06:51.002Z 2026-04-10T12:34:47.693Z
9604194 9604194 20260402163046_6pqXL NZ005N 2026-04-03T12:06:20.478Z 2026-04-10T12:34:44.973Z
9604170 9604170 20260402162436_36pjz NZ005N 2026-04-03T12:06:16.106Z 2026-04-10T12:34:44.336Z
9604149 9604149 20260402161052_xql8j NZ005N 2026-04-03T12:06:11.965Z 2026-04-10T12:34:43.665Z
9604129 9604129 20260402160605_HAJ7B NZ005N 2026-04-03T12:06:02.954Z 2026-04-10T12:34:42.903Z
9604108 9604108 20260402155118_mbBQV NZ005N 2026-04-03T12:05:57.152Z 2026-04-10T12:34:42.448Z
9604099 9604099 20260402154113_xCxno NZ005N 2026-04-03T12:05:54.596Z 2026-04-10T12:34:34.945Z
9604065 9604065 20260402152537_zxg53 NZ005N 2026-04-03T12:05:47.750Z 2026-04-10T12:34:18.700Z
9604061 9604061 20260402152310_n2dlN NZ005N 2026-04-03T12:05:47.246Z 2026-04-10T12:34:18.594Z
9604055 9604055 20260402152126_Cxc78 NZ005N 2026-04-03T12:05:46.798Z 2026-04-10T12:34:18.557Z
9604046 9604046 20260402151721_JT4Mb NZ005N 2026-04-03T12:05:45.823Z 2026-04-10T12:34:18.385Z
9604038 9604038 20260402151133_lynUf NZ005N 2026-04-03T12:05:44.427Z 2026-04-10T12:34:18.153Z
9604016 9604016 20260402145921_1XmFb NZ005N 2026-04-03T12:05:33.651Z 2026-04-10T12:34:17.528Z
9603998 9603998 20260402144357_8tQJQ NZ005N 2026-04-03T12:05:28.156Z 2026-04-10T12:34:17.233Z
9603975 9603975 20260402143023_WBCF4 NZ005N 2026-04-03T12:05:23.690Z 2026-04-10T12:34:16.808Z
9603935 9603935 20260402140814_8lGiR NZ005N 2026-04-03T12:05:13.287Z 2026-04-10T12:34:15.959Z
9603923 9603923 20260402134525_UaM0F NZ005N 2026-04-03T12:05:06.212Z 2026-04-10T12:34:15.572Z
9603914 9603914 20260402134124_unipW NZ005N 2026-04-03T12:05:05.209Z 2026-04-10T12:34:15.409Z
9603857 9603857 20260402131213_SxGJa NZ005N 2026-04-03T12:04:53.470Z 2026-04-10T12:34:10.996Z
9603815 9603815 20260402125202_Ogfyj NZ005N 2026-04-03T12:04:47.111Z 2026-04-10T12:34:10.287Z
9603789 9603789 20260402122833_aGvcf NZ005N 2026-04-03T12:04:34.510Z 2026-04-10T12:34:09.816Z
9603781 9603781 20260402122629_NI5S1 NZ005N 2026-04-03T12:04:33.367Z 2026-04-10T12:34:09.677Z
9603625 9603625 20260402112525_YzZoK NZ005N 2026-04-03T12:03:50.950Z 2026-04-10T12:34:05.672Z
9603548 9603548 20260402110012_MAN5w NZ005N 2026-04-03T12:03:28.531Z 2026-04-10T12:34:03.954Z
9603388 9603388 20260402095324_ZRw5x NZ005N 2026-04-03T12:02:47.239Z 2026-04-10T12:34:01.032Z
9603300 9603300 20260402092546_lD3kh NZ005N 2026-04-03T12:02:32.404Z 2026-04-10T12:33:59.436Z
9603121 9603121 20260402075738_2M3Mk NZ005N 2026-04-03T12:01:53.573Z 2026-04-10T12:33:56.128Z
9603089 9603089 20260402074543_3kDyC NZ005N 2026-04-03T12:01:42.951Z 2026-04-10T12:33:55.424Z
9601968 9601968 20260401173739_YOkvn NZ005N 2026-04-02T12:04:20.960Z 2026-04-10T12:35:50.532Z
9601854 9601854 20260401171518_EUtzP NZ005N 2026-04-02T12:03:56.298Z 2026-04-10T12:35:48.509Z
9601790 9601790 20260401170140_TgfBI NZ005N 2026-04-02T12:03:43.276Z 2026-04-10T12:35:47.463Z
9601730 9601730 20260401164640_RUcxD NZ005N 2026-04-02T12:03:32.761Z 2026-04-10T12:35:46.447Z
9601699 9601699 20260401163145_wQScD NZ005N 2026-04-02T12:03:28.538Z 2026-04-10T12:35:43.783Z
9601631 9601631 20260401161347_u0ict NZ005N 2026-04-02T12:03:19.146Z 2026-04-10T12:35:42.464Z
9601567 9601567 20260401154912_tqnY2 NZ005N 2026-04-02T12:03:06.986Z 2026-04-10T12:35:41.280Z
9601533 9601533 20260401154117_WY2vt NZ005N 2026-04-02T12:03:01.783Z 2026-04-10T12:35:40.875Z
9601522 9601522 20260401153959_JkoP1 NZ005N 2026-04-02T12:02:59.756Z 2026-04-10T12:35:40.644Z
9601495 9601495 20260401153013_LzvFA NZ005N 2026-04-02T12:02:55.776Z 2026-04-10T12:35:40.162Z
9601459 9601459 20260401152401_SZ5gD NZ005N 2026-04-02T12:02:50.702Z 2026-04-10T12:35:39.475Z
9601436 9601436 20260401151831_NjUXB NZ005N 2026-04-02T12:02:46.829Z 2026-04-10T12:35:38.993Z
9601413 9601413 20260401150709_kZt4B NZ005N 2026-04-02T12:02:43.296Z 2026-04-10T12:35:38.602Z
9601405 9601405 20260401150401_QxncL NZ005N 2026-04-02T12:02:40.972Z 2026-04-10T12:35:38.433Z
9601342 9601342 20260401143418_mNKKV NZ005N 2026-04-02T12:02:28.652Z 2026-04-10T12:35:37.275Z
9601322 9601322 20260401141640_IGKy2 NZ005N 2026-04-02T12:02:24.956Z 2026-04-10T12:35:36.868Z
9601280 9601280 20260401134651_Wy3dP NZ005N 2026-04-02T12:02:14.240Z 2026-04-10T12:35:36.078Z
9601241 9601241 20260401133113_dlNTk NZ005N 2026-04-02T12:02:06.618Z 2026-04-10T12:35:35.440Z
9601206 9601206 20260401130920_FbTP2 NZ005N 2026-04-02T12:01:59.212Z 2026-04-10T12:35:34.843Z
9601201 9601201 20260401130834_9svZV NZ005N 2026-04-02T12:01:58.017Z 2026-04-10T12:35:34.737Z
9601133 9601133 20260401122600_4nfpw NZ005N 2026-04-02T12:01:42.118Z 2026-04-10T12:35:33.637Z
9601125 9601125 20260401120957_aAIK2 NZ005N 2026-04-02T12:01:40.472Z 2026-04-10T12:35:33.483Z
9601093 9601093 20260401114452_rXcqV NZ005N 2026-04-02T12:01:32.926Z 2026-04-10T12:35:33.011Z
9601084 9601084 20260401113021_3aWSG NZ005N 2026-04-02T12:01:30.752Z 2026-04-10T12:35:32.867Z
9601066 9601066 20260401112204_Px9co NZ005N 2026-04-02T12:01:28.499Z 2026-04-10T12:35:32.534Z
9601062 9601062 20260401111149_322Ka NZ005N 2026-04-02T12:01:27.721Z 2026-04-10T12:35:32.479Z
9601042 9601042 20260401104704_92pZi NZ005N 2026-04-02T12:01:22.177Z 2026-04-10T12:35:32.060Z
9601018 9601018 20260401103300_Mthp1 NZ005N 2026-04-02T12:01:18.449Z 2026-04-10T12:35:31.805Z
9600987 9600987 20260401101458_eJkgR NZ005N 2026-04-02T12:01:12.607Z 2026-04-10T12:35:31.142Z
9600883 9600883 20260401073621_2dxqu NZ005N 2026-04-02T12:00:48.199Z 2026-04-10T12:35:28.689Z
9599950 9599950 20260331174311_RVcOo NZ005N 2026-04-01T12:05:23.782Z 2026-04-09T12:48:03.549Z
9599608 9599608 20260331160127_FOvoX NZ005N 2026-04-01T12:04:14.286Z 2026-04-09T12:47:06.148Z
9599453 9599453 20260331144449_6SaO2 NZ005N 2026-04-01T12:03:39.564Z 2026-04-09T12:46:47.757Z
9599409 9599409 20260331142536_HtJLb NZ005N 2026-04-01T12:03:28.751Z 2026-04-09T12:46:47.111Z
9599368 9599368 20260331141817_hp4i5 NZ005N 2026-04-01T12:03:19.829Z 2026-04-09T12:46:46.602Z
9599312 9599312 20260331135348_ISFWS NZ005N 2026-04-01T12:03:09.103Z 2026-04-09T12:46:45.813Z
9599294 9599294 20260331134413_WGTbX NZ005N 2026-04-01T12:03:04.761Z 2026-04-09T12:46:45.582Z
9599161 9599161 20260331121441_23cUR NZ005N 2026-04-01T12:02:35.265Z 2026-04-09T12:46:42.595Z
9599144 9599144 20260331120413_5lJdH NZ005N 2026-04-01T12:02:31.266Z 2026-04-09T12:46:42.412Z
9599140 9599140 20260331120317_LHS2w NZ005N 2026-04-01T12:02:30.538Z 2026-04-09T12:46:42.357Z
9599109 9599109 20260331114831_Aot5t NZ005N 2026-04-01T12:02:24.291Z 2026-04-09T12:46:41.710Z
9599101 9599101 20260331114005_3tW02 NZ005N 2026-04-01T12:02:22.042Z 2026-04-09T12:46:41.430Z
9599097 9599097 20260331113619_kG23B NZ005N 2026-04-01T12:02:20.674Z 2026-04-09T12:46:41.366Z

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