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,933 rows where station_code = "NZ000N" 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
9627502 9627502 20260408180916_gJhUa NZ000N 2026-04-09T12:11:13.287Z 2026-04-10T12:14:22.556Z
9627411 9627411 20260408172838_Ze8Lg NZ000N 2026-04-09T12:10:52.594Z 2026-04-10T12:14:22.539Z
9627397 9627397 20260408172416_jCUbx NZ000N 2026-04-09T12:10:49.033Z 2026-04-10T12:14:22.536Z
9627389 9627389 20260408172312_KCUAf NZ000N 2026-04-09T12:10:47.855Z 2026-04-10T12:14:22.535Z
9627379 9627379 20260408172254_JS23O NZ000N 2026-04-09T12:10:46.768Z 2026-04-10T12:14:22.534Z
9627351 9627351 20260408172029_833D3 NZ000N 2026-04-09T12:10:44.304Z 2026-04-10T12:14:22.530Z
9627335 9627335 20260408171843_bpQvF NZ000N 2026-04-09T12:10:42.190Z 2026-04-10T12:14:22.526Z
9627319 9627319 20260408170815_Ab6Fi NZ000N 2026-04-09T12:10:39.381Z 2026-04-10T12:14:22.523Z
9627297 9627297 20260408170229_8W3sT NZ000N 2026-04-09T12:10:34.660Z 2026-04-10T12:14:22.518Z
9627280 9627280 20260408165928_HB1zj NZ000N 2026-04-09T12:10:32.362Z 2026-04-10T12:14:22.515Z
9627241 9627241 20260408165055_39J3T NZ000N 2026-04-09T12:10:22.770Z 2026-04-10T12:14:22.508Z
9627074 9627074 20260408161013_Cnn3D NZ000N 2026-04-09T12:09:54.008Z 2026-04-10T12:14:22.475Z
9626393 9626393 20260408135205_Bz4jq NZ000N 2026-04-09T12:08:15.019Z 2026-04-10T12:14:22.344Z
9626353 9626353 20260408134611_001nn NZ000N 2026-04-09T12:08:12.165Z 2026-04-10T12:14:22.339Z
9624972 9624972 20260408090640_Zy2Y6 NZ000N 2026-04-09T12:03:38.011Z 2026-04-10T12:14:21.824Z
9624932 9624932 20260408085819_IpgNb NZ000N 2026-04-09T12:03:29.404Z 2026-04-10T12:14:21.815Z
9624784 9624784 20260408082800_ijHIh NZ000N 2026-04-09T12:02:55.718Z 2026-04-10T12:14:21.463Z
9624780 9624780 20260408082800_YT69J NZ000N 2026-04-09T12:02:55.167Z 2026-04-10T12:14:21.462Z
9624767 9624767 20260408082643_xwDhp NZ000N 2026-04-09T12:02:52.976Z 2026-04-10T12:14:21.459Z
9612536 9612536 20260406134458_yJSi0 NZ000N 2026-04-07T12:02:06.594Z 2026-04-10T12:22:12.030Z
9612346 9612346 20260406100501_7r99L NZ000N 2026-04-07T12:01:34.034Z 2026-04-10T12:22:05.530Z
9612288 9612288 20260406093300_aelvK NZ000N 2026-04-07T12:01:24.639Z 2026-04-10T12:22:03.729Z
9612194 9612194 20260406080413_8mk8Q NZ000N 2026-04-07T12:01:03.723Z 2026-04-10T12:22:00.843Z
9612147 9612147 20260406073259_2oHZX NZ000N 2026-04-07T12:00:56.809Z 2026-04-10T12:21:59.556Z
9601921 9601921 20260401172654_jSkej NZ000N 2026-04-02T12:04:10.864Z 2026-04-10T12:35:49.726Z
9601898 9601898 20260401172013_huF29 NZ000N 2026-04-02T12:04:05.473Z 2026-04-10T12:35:49.235Z
9601818 9601818 20260401170812_94G7R NZ000N 2026-04-02T12:03:49.992Z 2026-04-10T12:35:48.059Z
9601720 9601720 20260401164120_S8QDF NZ000N 2026-04-02T12:03:31.534Z 2026-04-10T12:35:46.339Z
9601714 9601714 20260401163915_1SQGa NZ000N 2026-04-02T12:03:30.864Z 2026-04-10T12:35:46.191Z
9601640 9601640 20260401162051_sQJrz NZ000N 2026-04-02T12:03:20.486Z 2026-04-10T12:35:42.707Z
9588737 9588737 20260325115019_xDISg NZ000N 2026-03-28T12:14:21.218Z 2026-04-03T12:38:03.434Z
9588173 9588173 20260326151526_ogse6 NZ000N 2026-03-28T12:10:07.111Z 2026-04-04T12:41:15.241Z
9588165 9588165 20260326143101_Q7u7F NZ000N 2026-03-28T12:10:00.916Z 2026-04-04T12:41:09.011Z
9583763 9583763 20260326175017_kh6pK NZ000N 2026-03-27T12:09:42.240Z 2026-04-04T12:41:37.752Z
9583719 9583719 20260326172728_BsSsJ NZ000N 2026-03-27T12:09:35.143Z 2026-04-04T12:41:33.101Z
9583669 9583669 20260326170540_eQeC3 NZ000N 2026-03-27T12:09:27.686Z 2026-04-04T12:41:30.477Z
9583584 9583584 20260326162123_Oj0xO NZ000N 2026-03-27T12:09:11.901Z 2026-04-04T12:41:26.542Z
9583505 9583505 20260326154124_mTzrM NZ000N 2026-03-27T12:09:01.337Z 2026-04-04T12:41:21.821Z
9583477 9583477 20260326152156_SCbr0 NZ000N 2026-03-27T12:08:55.243Z 2026-04-04T12:41:19.525Z
9583471 9583471 20260326151902_I3Xwj NZ000N 2026-03-27T12:08:54.195Z 2026-03-27T12:08:54.195Z
9583459 9583459 20260326150902_M3HIg NZ000N 2026-03-27T12:08:52.023Z 2026-04-04T12:41:13.328Z
9583454 9583454 20260326150834_kqMFm NZ000N 2026-03-27T12:08:51.540Z 2026-03-27T12:08:51.540Z
9583448 9583448 20260326150144_CxX1C NZ000N 2026-03-27T12:08:49.025Z 2026-04-04T12:41:12.733Z
9580182 9580182 20260323120321_U2sPt NZ000N 2026-03-26T12:17:56.139Z 2026-03-31T12:27:33.864Z
9580169 9580169 20260323080547_Acg0m NZ000N 2026-03-26T12:16:48.338Z 2026-03-31T12:26:41.800Z
9578859 9578859 20260325151512_jgS9o NZ000N 2026-03-26T12:08:42.417Z 2026-04-03T12:38:36.494Z
9578842 9578842 20260325151247_5fQHz NZ000N 2026-03-26T12:08:40.272Z 2026-04-03T12:38:35.811Z
9578751 9578751 20260325141327_eSuIv NZ000N 2026-03-26T12:08:24.792Z 2026-04-03T12:38:30.591Z
9578730 9578730 20260325135622_CkNho NZ000N 2026-03-26T12:08:21.174Z 2026-04-03T12:38:25.667Z
9578721 9578721 20260325135603_Wdo14 NZ000N 2026-03-26T12:08:20.155Z 2026-04-03T12:38:20.484Z
9578695 9578695 20260325133118_6j3Oc NZ000N 2026-03-26T12:08:16.090Z 2026-04-03T12:38:17.267Z
9578683 9578683 20260325132426_5TeZn NZ000N 2026-03-26T12:08:14.553Z 2026-04-03T12:38:16.850Z
9578649 9578649 20260325130602_n2QRa NZ000N 2026-03-26T12:08:09.845Z 2026-04-03T12:38:15.275Z
9578632 9578632 20260325124650_uO5Ap NZ000N 2026-03-26T12:08:07.690Z 2026-04-03T12:38:13.826Z
9578356 9578356 20260325112452_7a8gF NZ000N 2026-03-26T12:07:23.562Z 2026-04-03T12:37:59.776Z
9574882 9574882 20260323173246_KDNki NZ000N 2026-03-25T12:19:50.098Z 2026-03-31T12:28:43.881Z
9574479 9574479 20260324171453_dvlYL NZ000N 2026-03-25T12:10:43.364Z 2026-04-02T12:37:00.137Z
9574388 9574388 20260324165159_28Nu0 NZ000N 2026-03-25T12:10:29.129Z 2026-04-02T12:36:49.842Z
9573965 9573965 20260324144159_bUdYe NZ000N 2026-03-25T12:09:19.163Z 2026-04-02T12:36:33.304Z
9573945 9573945 20260324143554_WAAtI NZ000N 2026-03-25T12:09:15.662Z 2026-04-02T12:36:32.787Z
9573904 9573904 20260324141933_YPRU3 NZ000N 2026-03-25T12:09:09.232Z 2026-04-02T12:36:31.170Z
9573876 9573876 20260324141510_I9hvi NZ000N 2026-03-25T12:09:05.582Z 2026-03-25T12:09:05.582Z
9573750 9573750 20260324133922_3v2b3 NZ000N 2026-03-25T12:08:42.162Z 2026-04-02T12:36:25.805Z
9573591 9573591 20260324125654_229Qc NZ000N 2026-03-25T12:08:24.266Z 2026-04-02T12:36:15.685Z
9573519 9573519 20260324123541_dG7k9 NZ000N 2026-03-25T12:08:12.655Z 2026-04-02T12:36:12.375Z
9573307 9573307 20260324114730_La3Rp NZ000N 2026-03-25T12:07:41.678Z 2026-04-02T12:36:03.827Z
9573223 9573223 20260324113845_j6ALX NZ000N 2026-03-25T12:07:30.841Z 2026-04-02T12:36:00.682Z
9572550 9572550 20260324092747_POa5P NZ000N 2026-03-25T12:05:33.203Z 2026-04-02T12:35:29.703Z
9572435 9572435 20260324090316_PgJUP NZ000N 2026-03-25T12:05:09.557Z 2026-04-02T12:35:24.865Z
9572411 9572411 20260324085907_BbKp4 NZ000N 2026-03-25T12:05:00.765Z 2026-04-02T12:35:23.496Z
9572371 9572371 20260324085008_EUDK9 NZ000N 2026-03-25T12:04:52.416Z 2026-04-02T12:35:22.021Z
9572356 9572356 20260324084139_HtwsF NZ000N 2026-03-25T12:04:49.429Z 2026-04-02T12:35:21.196Z
9572299 9572299 20260324083112_fgtdK NZ000N 2026-03-25T12:04:37.298Z 2026-04-02T12:35:13.344Z
9572284 9572284 20260324082925_nDyxV NZ000N 2026-03-25T12:04:34.735Z 2026-04-02T12:35:12.532Z
9568558 9568558 20260323165343_bo4VP NZ000N 2026-03-24T12:15:17.612Z 2026-03-31T12:28:30.691Z
9568519 9568519 20260323165205_5dgIe NZ000N 2026-03-24T12:15:13.906Z 2026-03-31T12:28:30.269Z
9568451 9568451 20260323164637_5WCXw NZ000N 2026-03-24T12:15:08.888Z 2026-03-31T12:28:29.478Z
9568252 9568252 20260323162545_HxAyq NZ000N 2026-03-24T12:14:47.726Z 2026-03-31T12:28:26.480Z
9568185 9568185 20260323161825_x8wYa NZ000N 2026-03-24T12:14:41.970Z 2026-03-31T12:28:24.278Z
9568048 9568048 20260323160841_EbafN NZ000N 2026-03-24T12:14:27.250Z 2026-03-31T12:28:22.272Z
9567764 9567764 20260323154827_M1NEG NZ000N 2026-03-24T12:14:07.279Z 2026-03-31T12:28:18.452Z
9567680 9567680 20260323154022_warqk NZ000N 2026-03-24T12:13:57.857Z 2026-03-31T12:28:17.406Z
9567589 9567589 20260323153446_FYmYt NZ000N 2026-03-24T12:13:49.934Z 2026-03-31T12:28:16.231Z
9567480 9567480 20260323152131_UeSCX NZ000N 2026-03-24T12:13:40.412Z 2026-03-31T12:28:14.521Z
9567305 9567305 20260323150425_2VQQd NZ000N 2026-03-24T12:13:22.208Z 2026-03-31T12:28:12.498Z
9567207 9567207 20260323145333_O2ZwA NZ000N 2026-03-24T12:13:13.603Z 2026-03-31T12:28:10.333Z
9566927 9566927 20260323142636_ct73g NZ000N 2026-03-24T12:12:43.590Z 2026-03-31T12:28:06.135Z
9566897 9566897 20260323142404_4ZWIl NZ000N 2026-03-24T12:12:40.659Z 2026-03-31T12:28:05.870Z
9566851 9566851 20260323141856_i8W28 NZ000N 2026-03-24T12:12:33.102Z 2026-03-31T12:28:05.147Z
9566648 9566648 20260323135939_LOet4 NZ000N 2026-03-24T12:12:15.296Z 2026-03-31T12:27:55.040Z
9566453 9566453 20260323133947_uGtYD NZ000N 2026-03-24T12:11:53.108Z 2026-03-31T12:27:52.069Z
9566414 9566414 20260323133525_pc4sf NZ000N 2026-03-24T12:11:49.715Z 2026-03-31T12:27:50.514Z
9566392 9566392 20260323133249_EU1Hm NZ000N 2026-03-24T12:11:46.543Z 2026-03-31T12:27:50.120Z
9566205 9566205 20260323131347_GKOl3 NZ000N 2026-03-24T12:11:26.755Z 2026-03-31T12:27:47.048Z
9565982 9565982 20260323125559_3U2nZ NZ000N 2026-03-24T12:11:08.111Z 2026-03-31T12:27:44.393Z
9565730 9565730 20260323123602_UYahN NZ000N 2026-03-24T12:10:44.732Z 2026-03-31T12:27:40.341Z
9565556 9565556 20260323121947_ci7P2 NZ000N 2026-03-24T12:10:23.767Z 2026-03-31T12:27:37.454Z
9565427 9565427 20260323120843_RiAFs NZ000N 2026-03-24T12:10:06.402Z 2026-03-31T12:27:35.093Z
9565251 9565251 20260323115427_JH0sz NZ000N 2026-03-24T12:09:43.946Z 2026-03-31T12:27:31.903Z
9565092 9565092 20260323114442_qkHhO NZ000N 2026-03-24T12:09:23.999Z 2026-03-31T12:27:22.737Z

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