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,647 rows where station_code = "NZ002G" 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
9627168 9627168 20260408163258_hmqPW NZ002G 2026-04-09T12:10:12.570Z 2026-04-10T12:14:22.493Z
9627124 9627124 20260408162835_AVKt4 NZ002G 2026-04-09T12:10:07.414Z 2026-04-10T12:14:22.486Z
9627064 9627064 20260408160748_vSEO6 NZ002G 2026-04-09T12:09:53.133Z 2026-04-10T12:14:22.474Z
9627004 9627004 20260408155118_yfZ2Q NZ002G 2026-04-09T12:09:43.984Z 2026-04-10T12:14:22.456Z
9626990 9626990 20260408154616_6zhLG NZ002G 2026-04-09T12:09:42.218Z 2026-04-10T12:14:22.453Z
9626830 9626830 20260408151221_2K693 NZ002G 2026-04-09T12:09:16.544Z 2026-04-10T12:14:22.421Z
9626529 9626529 20260408141137_IWNEi NZ002G 2026-04-09T12:08:38.432Z 2026-04-10T12:14:22.369Z
9624561 9624561 20260408074343_b7WOo NZ002G 2026-04-09T12:01:59.891Z 2026-04-10T12:14:21.410Z
9604389 9604389 20260402174807_Hu4P0 NZ002G 2026-04-03T12:07:14.774Z 2026-04-10T12:34:49.758Z
9604320 9604320 20260402170639_Jj04S NZ002G 2026-04-03T12:06:52.883Z 2026-04-10T12:34:47.952Z
9604213 9604213 20260402163948_za4wn NZ002G 2026-04-03T12:06:24.315Z 2026-04-10T12:34:45.348Z
9604192 9604192 20260402163046_6pqXL NZ002G 2026-04-03T12:06:20.478Z 2026-04-10T12:34:44.973Z
9604106 9604106 20260402155118_mbBQV NZ002G 2026-04-03T12:05:57.152Z 2026-04-10T12:34:42.448Z
9604097 9604097 20260402154113_xCxno NZ002G 2026-04-03T12:05:54.595Z 2026-04-10T12:34:34.945Z
9604052 9604052 20260402152126_Cxc78 NZ002G 2026-04-03T12:05:46.798Z 2026-04-10T12:34:18.557Z
9604044 9604044 20260402151721_JT4Mb NZ002G 2026-04-03T12:05:45.823Z 2026-04-10T12:34:18.385Z
9603955 9603955 20260402142153_45wtx NZ002G 2026-04-03T12:05:20.122Z 2026-04-10T12:34:16.498Z
9603933 9603933 20260402140814_8lGiR NZ002G 2026-04-03T12:05:13.287Z 2026-04-10T12:34:15.959Z
9603921 9603921 20260402134525_UaM0F NZ002G 2026-04-03T12:05:06.212Z 2026-04-10T12:34:15.572Z
9603902 9603902 20260402133104_Ri2Gn NZ002G 2026-04-03T12:04:59.897Z 2026-04-10T12:34:15.195Z
9603818 9603818 20260402125448_S3gaH NZ002G 2026-04-03T12:04:47.739Z 2026-04-10T12:34:10.311Z
9603813 9603813 20260402125202_Ogfyj NZ002G 2026-04-03T12:04:47.111Z 2026-04-10T12:34:10.287Z
9603556 9603556 20260402110233_YKwgA NZ002G 2026-04-03T12:03:39.548Z 2026-04-10T12:34:04.178Z
9603102 9603102 20260402075054_c8N9o NZ002G 2026-04-03T12:01:45.160Z 2026-04-10T12:33:55.770Z
9601769 9601769 20260401165726_bblaX NZ002G 2026-04-02T12:03:39.902Z 2026-04-10T12:35:47.115Z
9601697 9601697 20260401163145_wQScD NZ002G 2026-04-02T12:03:28.538Z 2026-04-10T12:35:43.783Z
9601598 9601598 20260401160129_jmA5q NZ002G 2026-04-02T12:03:13.923Z 2026-04-10T12:35:41.905Z
9601564 9601564 20260401154912_tqnY2 NZ002G 2026-04-02T12:03:06.986Z 2026-04-10T12:35:41.280Z
9601545 9601545 20260401154340_swAGF NZ002G 2026-04-02T12:03:03.632Z 2026-04-10T12:35:40.994Z
9601531 9601531 20260401154117_WY2vt NZ002G 2026-04-02T12:03:01.783Z 2026-04-10T12:35:40.875Z
9601514 9601514 20260401153914_kMBSX NZ002G 2026-04-02T12:02:58.868Z 2026-04-10T12:35:40.513Z
9601492 9601492 20260401153013_LzvFA NZ002G 2026-04-02T12:02:55.776Z 2026-04-10T12:35:40.162Z
9601470 9601470 20260401152502_PG1QQ NZ002G 2026-04-02T12:02:52.569Z 2026-04-10T12:35:39.790Z
9601091 9601091 20260401114452_rXcqV NZ002G 2026-04-02T12:01:32.926Z 2026-04-10T12:35:33.011Z
9601064 9601064 20260401112204_Px9co NZ002G 2026-04-02T12:01:28.499Z 2026-04-10T12:35:32.534Z
9601061 9601061 20260401111149_322Ka NZ002G 2026-04-02T12:01:27.721Z 2026-04-10T12:35:32.479Z
9601059 9601059 20260401111137_Z6pzK NZ002G 2026-04-02T12:01:27.150Z 2026-04-10T12:35:32.417Z
9601016 9601016 20260401103300_Mthp1 NZ002G 2026-04-02T12:01:18.449Z 2026-04-10T12:35:31.805Z
9600256 9600256 20260330172929_7J1lA NZ002G 2026-04-01T12:09:50.190Z 2026-04-08T12:44:23.016Z
9598891 9598891 20260331083614_8IpKC NZ002G 2026-04-01T12:01:26.850Z 2026-04-09T12:46:37.455Z
9598806 9598806 20260331073401_ZpsO1 NZ002G 2026-04-01T12:01:09.857Z 2026-04-09T12:46:36.106Z
9598067 9598067 20260330174038_V1PNZ NZ002G 2026-03-31T12:07:32.734Z 2026-04-08T12:44:24.776Z
9598036 9598036 20260330173330_oCysO NZ002G 2026-03-31T12:07:29.332Z 2026-04-08T12:44:23.968Z
9598012 9598012 20260330173102_ZVpY8 NZ002G 2026-03-31T12:07:27.049Z 2026-04-08T12:44:23.305Z
9597967 9597967 20260330172410_8L6qd NZ002G 2026-03-31T12:07:22.429Z 2026-04-08T12:44:22.060Z
9596940 9596940 20260330144127_izdls NZ002G 2026-03-31T12:05:19.965Z 2026-04-08T12:43:28.622Z
9596897 9596897 20260330142707_7pTH8 NZ002G 2026-03-31T12:05:12.490Z 2026-04-08T12:43:27.370Z
9596695 9596695 20260330134322_QmKUz NZ002G 2026-03-31T12:04:45.087Z 2026-04-08T12:43:22.538Z
9596539 9596539 20260330130841_Jd5xQ NZ002G 2026-03-31T12:04:29.149Z 2026-04-08T12:43:19.280Z
9596537 9596537 20260330130756_gx2tF NZ002G 2026-03-31T12:04:28.785Z 2026-04-08T12:43:19.240Z
9596205 9596205 20260330114512_yFwue NZ002G 2026-03-31T12:03:43.777Z 2026-04-08T12:42:44.129Z
9595979 9595979 20260330102345_QIbeG NZ002G 2026-03-31T12:03:03.438Z 2026-04-08T12:42:37.857Z
9593750 9593750 20260329145135_iy2I1 NZ002G 2026-03-30T12:05:01.056Z 2026-04-07T12:27:34.856Z
9593736 9593736 20260329143752_xR36W NZ002G 2026-03-30T12:04:57.171Z 2026-04-07T12:27:34.381Z
9593679 9593679 20260329133808_YkS3H NZ002G 2026-03-30T12:04:46.018Z 2026-04-07T12:27:18.291Z
9587757 9587757 20260327153533_Xm5Oj NZ002G 2026-03-28T12:06:16.662Z 2026-04-05T12:34:40.608Z
9578602 9578602 20260325123613_JdHuK NZ002G 2026-03-26T12:08:04.505Z 2026-04-03T12:38:10.480Z
9572218 9572218 20260324080908_e3z0h NZ002G 2026-03-25T12:04:17.892Z 2026-04-02T12:35:08.179Z
9572152 9572152 20260324075246_uQoPy NZ002G 2026-03-25T12:04:02.208Z 2026-04-02T12:35:05.519Z
9566337 9566337 20260323132554_wOTjk NZ002G 2026-03-24T12:11:41.694Z 2026-03-31T12:27:48.904Z
9566224 9566224 20260323131601_6h4V2 NZ002G 2026-03-24T12:11:27.920Z 2026-03-31T12:27:47.271Z
9566193 9566193 20260323131146_Bk2uk NZ002G 2026-03-24T12:11:26.380Z 2026-03-31T12:27:46.988Z
9565944 9565944 20260323125319_V9n6h NZ002G 2026-03-24T12:11:05.583Z 2026-03-31T12:27:43.867Z
9565912 9565912 20260323125118_XaBQI NZ002G 2026-03-24T12:11:01.296Z 2026-03-31T12:27:43.409Z
9565857 9565857 20260323124441_Hi2rY NZ002G 2026-03-24T12:10:56.842Z 2026-03-31T12:27:42.430Z
9565764 9565764 20260323124019_71Mhv NZ002G 2026-03-24T12:10:49.066Z 2026-03-31T12:27:40.989Z
9565486 9565486 20260323121300_83ldH NZ002G 2026-03-24T12:10:17.074Z 2026-03-31T12:27:36.345Z
9565394 9565394 20260323120611_xCfb4 NZ002G 2026-03-24T12:10:01.315Z 2026-03-31T12:27:34.349Z
9565360 9565360 20260323120234_KxTjb NZ002G 2026-03-24T12:09:57.240Z 2026-03-31T12:27:33.747Z
9565148 9565148 20260323114735_elIO3 NZ002G 2026-03-24T12:09:30.176Z 2026-03-31T12:27:23.513Z
9564940 9564940 20260323113119_py9l1 NZ002G 2026-03-24T12:09:05.540Z 2026-03-31T12:27:19.627Z
9564766 9564766 20260323110728_3u2Y0 NZ002G 2026-03-24T12:08:45.995Z 2026-03-31T12:27:15.174Z
9564670 9564670 20260323110051_w3scM NZ002G 2026-03-24T12:08:32.936Z 2026-03-31T12:27:13.448Z
9564217 9564217 20260323101317_rJyLk NZ002G 2026-03-24T12:07:38.731Z 2026-03-31T12:27:05.291Z
9564142 9564142 20260323100310_OwuGl NZ002G 2026-03-24T12:07:30.043Z 2026-03-31T12:27:03.428Z
9564113 9564113 20260323100205_a6MJM NZ002G 2026-03-24T12:07:27.728Z 2026-03-31T12:27:03.044Z
9563796 9563796 20260323090948_341Ft NZ002G 2026-03-24T12:06:44.138Z 2026-03-31T12:26:56.771Z
9563741 9563741 20260323090547_2DWVq NZ002G 2026-03-24T12:06:38.435Z 2026-03-31T12:26:50.257Z
9563703 9563703 20260323090133_9PjcU NZ002G 2026-03-24T12:06:35.482Z 2026-03-31T12:26:49.595Z
9563633 9563633 20260323085643_RwKhE NZ002G 2026-03-24T12:06:27.253Z 2026-03-31T12:26:48.489Z
9563607 9563607 20260323085033_hYnDq NZ002G 2026-03-24T12:06:23.450Z 2026-03-31T12:26:47.953Z
9563530 9563530 20260323083021_BbK1M NZ002G 2026-03-24T12:06:11.068Z 2026-03-31T12:26:46.257Z
9563498 9563498 20260323082617_hlJtD NZ002G 2026-03-24T12:06:07.738Z 2026-03-31T12:26:45.297Z
9563463 9563463 20260323082341_xEcKA NZ002G 2026-03-24T12:06:03.746Z 2026-03-31T12:26:43.718Z
9563409 9563409 20260323081505_DbiTB NZ002G 2026-03-24T12:05:56.865Z 2026-03-31T12:26:42.623Z
9563346 9563346 20260323080405_3lRHT NZ002G 2026-03-24T12:05:47.591Z 2026-03-31T12:26:41.199Z
9563321 9563321 20260323075820_sRtam NZ002G 2026-03-24T12:05:44.133Z 2026-03-31T12:26:40.699Z
9563243 9563243 20260323074630_3QJNa NZ002G 2026-03-24T12:05:35.347Z 2026-03-31T12:26:39.167Z
9559523 9559523 20260321174631_McdFO NZ002G 2026-03-23T12:11:09.278Z 2026-03-29T12:20:40.365Z
9559507 9559507 20260321173626_plwGJ NZ002G 2026-03-23T12:11:08.454Z 2026-03-29T12:20:40.132Z
9559483 9559483 20260321172621_AFnkv NZ002G 2026-03-23T12:11:07.405Z 2026-03-29T12:20:39.795Z
9559456 9559456 20260321172103_8Y4Xl NZ002G 2026-03-23T12:11:06.770Z 2026-03-29T12:20:39.567Z
9559345 9559345 20260321165858_u3V5B NZ002G 2026-03-23T12:11:02.524Z 2026-03-29T12:20:37.922Z
9559322 9559322 20260321165639_nXO9D NZ002G 2026-03-23T12:11:01.675Z 2026-03-29T12:20:37.544Z
9559301 9559301 20260321165530_mtQgN NZ002G 2026-03-23T12:11:01.223Z 2026-03-29T12:20:36.373Z
9559219 9559219 20260321164749_rIiB9 NZ002G 2026-03-23T12:10:58.192Z 2026-03-29T12:20:35.395Z
9559118 9559118 20260321163629_KQdvg NZ002G 2026-03-23T12:10:54.789Z 2026-03-29T12:20:34.215Z
9559055 9559055 20260321162513_IukYN NZ002G 2026-03-23T12:10:52.712Z 2026-03-29T12:20:33.558Z
9558873 9558873 20260321155926_BSCv6 NZ002G 2026-03-23T12:10:38.028Z 2026-03-29T12:20:31.287Z
9558808 9558808 20260321154748_PmzNK NZ002G 2026-03-23T12:10:34.034Z 2026-03-29T12:20:30.266Z

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