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,559 rows where station_code = "NZ0025" 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
9627504 9627504 20260408180916_gJhUa NZ0025 2026-04-09T12:11:13.287Z 2026-04-10T12:14:22.556Z
9627495 9627495 20260408180547_U8eLI NZ0025 2026-04-09T12:11:11.906Z 2026-04-10T12:14:22.554Z
9627467 9627467 20260408175344_DDEyy NZ0025 2026-04-09T12:11:07.438Z 2026-04-10T12:14:22.549Z
9627464 9627464 20260408174436_G7aaK NZ0025 2026-04-09T12:11:07.066Z 2026-04-10T12:14:22.548Z
9627413 9627413 20260408172838_Ze8Lg NZ0025 2026-04-09T12:10:52.594Z 2026-04-10T12:14:22.539Z
9627406 9627406 20260408172605_4Nn3J NZ0025 2026-04-09T12:10:51.604Z 2026-04-10T12:14:22.538Z
9627399 9627399 20260408172416_jCUbx NZ0025 2026-04-09T12:10:49.033Z 2026-04-10T12:14:22.536Z
9627392 9627392 20260408172312_KCUAf NZ0025 2026-04-09T12:10:47.855Z 2026-04-10T12:14:22.535Z
9627382 9627382 20260408172254_JS23O NZ0025 2026-04-09T12:10:46.768Z 2026-04-10T12:14:22.534Z
9627353 9627353 20260408172029_833D3 NZ0025 2026-04-09T12:10:44.304Z 2026-04-10T12:14:22.530Z
9627336 9627336 20260408171843_bpQvF NZ0025 2026-04-09T12:10:42.190Z 2026-04-10T12:14:22.526Z
9627299 9627299 20260408170229_8W3sT NZ0025 2026-04-09T12:10:34.660Z 2026-04-10T12:14:22.518Z
9627281 9627281 20260408165928_HB1zj NZ0025 2026-04-09T12:10:32.362Z 2026-04-10T12:14:22.515Z
9627273 9627273 20260408165644_iHwD2 NZ0025 2026-04-09T12:10:30.907Z 2026-04-10T12:14:22.513Z
9627224 9627224 20260408164621_UHSul NZ0025 2026-04-09T12:10:20.912Z 2026-04-10T12:14:22.505Z
9627206 9627206 20260408164303_EqSyC NZ0025 2026-04-09T12:10:19.347Z 2026-04-10T12:14:22.502Z
9627180 9627180 20260408163714_2korx NZ0025 2026-04-09T12:10:14.571Z 2026-04-10T12:14:22.495Z
9627041 9627041 20260408160000_LNU1W NZ0025 2026-04-09T12:09:50.001Z 2026-04-10T12:14:22.466Z
9625114 9625114 20260408093929_PyyDp NZ0025 2026-04-09T12:04:18.299Z 2026-04-10T12:14:21.858Z
9624923 9624923 20260408085732_MH4yP NZ0025 2026-04-09T12:03:28.389Z 2026-04-10T12:14:21.813Z
9624916 9624916 20260408085626_YUhUQ NZ0025 2026-04-09T12:03:26.992Z 2026-04-10T12:14:21.812Z
9624786 9624786 20260408082800_ijHIh NZ0025 2026-04-09T12:02:55.718Z 2026-04-10T12:14:21.463Z
9624769 9624769 20260408082643_xwDhp NZ0025 2026-04-09T12:02:52.995Z 2026-04-10T12:14:21.459Z
9617372 9617372 20260407141659_B95JD NZ0025 2026-04-08T12:03:15.982Z 2026-04-10T12:17:09.792Z
9617361 9617361 20260407141009_7W2PF NZ0025 2026-04-08T12:03:13.447Z 2026-04-10T12:17:09.324Z
9612476 9612476 20260406122139_Q7Z7g NZ0025 2026-04-07T12:01:56.924Z 2026-04-10T12:22:10.055Z
9612356 9612356 20260406100752_wO4zS NZ0025 2026-04-07T12:01:34.916Z 2026-04-10T12:22:05.674Z
9612348 9612348 20260406100501_7r99L NZ0025 2026-04-07T12:01:34.034Z 2026-04-10T12:22:05.530Z
9612329 9612329 20260406095003_ugCGK NZ0025 2026-04-07T12:01:31.497Z 2026-04-10T12:22:05.060Z
9612290 9612290 20260406093300_aelvK NZ0025 2026-04-07T12:01:24.639Z 2026-04-10T12:22:03.729Z
9612149 9612149 20260406073259_2oHZX NZ0025 2026-04-07T12:00:56.822Z 2026-04-10T12:21:59.556Z
9611873 9611873 20260401174852_KgiyX NZ0025 2026-04-06T12:25:42.703Z 2026-04-10T12:35:51.992Z
9601900 9601900 20260401172013_huF29 NZ0025 2026-04-02T12:04:05.473Z 2026-04-10T12:35:49.235Z
9601872 9601872 20260401171810_gAbbO NZ0025 2026-04-02T12:03:59.631Z 2026-04-10T12:35:48.756Z
9588205 9588205 20260326164002_s6jGP NZ0025 2026-03-28T12:10:18.449Z 2026-04-04T12:41:28.529Z
9588189 9588189 20260326162457_cvruA NZ0025 2026-03-28T12:10:15.391Z 2026-04-04T12:41:26.914Z
9588187 9588187 20260326162001_NaDPl NZ0025 2026-03-28T12:10:14.500Z 2026-04-04T12:41:26.103Z
9588183 9588183 20260326154955_Z833J NZ0025 2026-03-28T12:10:10.976Z 2026-04-04T12:41:23.101Z
9583586 9583586 20260326162123_Oj0xO NZ0025 2026-03-27T12:09:11.901Z 2026-04-04T12:41:26.542Z
9583507 9583507 20260326154124_mTzrM NZ0025 2026-03-27T12:09:01.337Z 2026-04-04T12:41:21.821Z
9583479 9583479 20260326152156_SCbr0 NZ0025 2026-03-27T12:08:55.243Z 2026-04-04T12:41:19.525Z
9583460 9583460 20260326150902_M3HIg NZ0025 2026-03-27T12:08:52.023Z 2026-04-04T12:41:13.328Z
9583455 9583455 20260326150834_kqMFm NZ0025 2026-03-27T12:08:51.540Z 2026-03-27T12:08:51.540Z
9579354 9579354 20260324174858_FlGLp NZ0025 2026-03-26T12:13:12.057Z 2026-04-02T12:37:02.867Z
9578861 9578861 20260325151512_vaYrz NZ0025 2026-03-26T12:08:42.681Z 2026-04-03T12:38:36.618Z
9578853 9578853 20260325151431_hULBz NZ0025 2026-03-26T12:08:41.839Z 2026-04-03T12:38:36.309Z
9578740 9578740 20260325135843_nlu2H NZ0025 2026-03-26T12:08:22.535Z 2026-04-03T12:38:29.045Z
9578738 9578738 20260325135834_xNIMd NZ0025 2026-03-26T12:08:22.225Z 2026-04-03T12:38:27.466Z
9578725 9578725 20260325135621_5we26 NZ0025 2026-03-26T12:08:20.891Z 2026-04-03T12:38:24.958Z
9578717 9578717 20260325134747_bihBo NZ0025 2026-03-26T12:08:19.518Z 2026-04-03T12:38:18.239Z
9578691 9578691 20260325133118_fGqly NZ0025 2026-03-26T12:08:15.793Z 2026-04-03T12:38:17.197Z
9578680 9578680 20260325132426_ZERll NZ0025 2026-03-26T12:08:14.309Z 2026-04-03T12:38:16.780Z
9578652 9578652 20260325130623_rUh2V NZ0025 2026-03-26T12:08:10.377Z 2026-04-03T12:38:15.347Z
9578489 9578489 20260325120100_bwLX8 NZ0025 2026-03-26T12:07:44.388Z 2026-04-03T12:38:05.451Z
9578435 9578435 20260325115020_9NEC2 NZ0025 2026-03-26T12:07:37.615Z 2026-04-03T12:38:03.531Z
9578352 9578352 20260325112452_1BVap NZ0025 2026-03-26T12:07:23.284Z 2026-04-03T12:37:59.678Z
9578328 9578328 20260325112039_CB3rD NZ0025 2026-03-26T12:07:19.897Z 2026-04-03T12:37:58.764Z
9574534 9574534 20260324173927_zA8pk NZ0025 2026-03-25T12:10:52.335Z 2026-04-02T12:37:02.048Z
9574516 9574516 20260324173201_Kdwi6 NZ0025 2026-03-25T12:10:48.743Z 2026-04-02T12:37:01.406Z
9574512 9574512 20260324172919_5UQXz NZ0025 2026-03-25T12:10:48.311Z 2026-03-25T12:10:48.311Z
9574508 9574508 20260324172333_BUm5w NZ0025 2026-03-25T12:10:47.800Z 2026-04-02T12:37:00.997Z
9574389 9574389 20260324165159_28Nu0 NZ0025 2026-03-25T12:10:29.129Z 2026-04-02T12:36:49.842Z
9574379 9574379 20260324164727_GR6wp NZ0025 2026-03-25T12:10:26.204Z 2026-04-02T12:36:49.634Z
9574360 9574360 20260324163600_2yJQx NZ0025 2026-03-25T12:10:23.852Z 2026-04-02T12:36:48.913Z
9574357 9574357 20260324163307_jZKsQ NZ0025 2026-03-25T12:10:23.492Z 2026-04-02T12:36:48.762Z
9574340 9574340 20260324163151_dKqWD NZ0025 2026-03-25T12:10:22.107Z 2026-04-02T12:36:48.216Z
9574329 9574329 20260324163121_c2rm1 NZ0025 2026-03-25T12:10:19.803Z 2026-04-02T12:36:47.983Z
9574030 9574030 20260324145723_HQYZL NZ0025 2026-03-25T12:09:28.589Z 2026-04-02T12:36:35.403Z
9574020 9574020 20260324145155_JbKhA NZ0025 2026-03-25T12:09:27.602Z 2026-04-02T12:36:34.730Z
9573957 9573957 20260324143740_KgEGZ NZ0025 2026-03-25T12:09:16.828Z 2026-03-25T12:09:16.828Z
9573946 9573946 20260324143554_WAAtI NZ0025 2026-03-25T12:09:15.662Z 2026-04-02T12:36:32.787Z
9573937 9573937 20260324143043_v9jQH NZ0025 2026-03-25T12:09:14.477Z 2026-04-02T12:36:32.326Z
9573926 9573926 20260324142636_S6Lhq NZ0025 2026-03-25T12:09:12.524Z 2026-03-25T12:09:12.524Z
9573905 9573905 20260324141933_YPRU3 NZ0025 2026-03-25T12:09:09.232Z 2026-04-02T12:36:31.170Z
9573877 9573877 20260324141510_I9hvi NZ0025 2026-03-25T12:09:05.582Z 2026-03-25T12:09:05.582Z
9573752 9573752 20260324133922_3v2b3 NZ0025 2026-03-25T12:08:42.162Z 2026-04-02T12:36:25.805Z
9573657 9573657 20260324131638_2p2ZZ NZ0025 2026-03-25T12:08:34.512Z 2026-04-02T12:36:17.843Z
9573592 9573592 20260324125654_229Qc NZ0025 2026-03-25T12:08:24.266Z 2026-04-02T12:36:15.686Z
9573520 9573520 20260324123541_dG7k9 NZ0025 2026-03-25T12:08:12.656Z 2026-04-02T12:36:12.375Z
9573507 9573507 20260324122907_v2T7w NZ0025 2026-03-25T12:08:10.901Z 2026-04-02T12:36:11.959Z
9572576 9572576 20260324093240_ew1uc NZ0025 2026-03-25T12:05:37.316Z 2026-04-02T12:35:30.443Z
9569539 9569539 20260322160943_Lt26u NZ0025 2026-03-24T12:21:20.138Z 2026-03-30T12:30:08.053Z
9568520 9568520 20260323165205_5dgIe NZ0025 2026-03-24T12:15:13.906Z 2026-03-31T12:28:30.269Z
9568453 9568453 20260323164637_5WCXw NZ0025 2026-03-24T12:15:08.888Z 2026-03-31T12:28:29.478Z
9568296 9568296 20260323162757_mTNGq NZ0025 2026-03-24T12:14:51.175Z 2026-03-31T12:28:26.965Z
9568186 9568186 20260323161825_x8wYa NZ0025 2026-03-24T12:14:41.970Z 2026-03-31T12:28:24.279Z
9568143 9568143 20260323161610_qji4I NZ0025 2026-03-24T12:14:37.136Z 2026-03-31T12:28:23.505Z
9568093 9568093 20260323161232_y62UU NZ0025 2026-03-24T12:14:30.397Z 2026-03-31T12:28:22.760Z
9568049 9568049 20260323160841_EbafN NZ0025 2026-03-24T12:14:27.250Z 2026-03-31T12:28:22.272Z
9567744 9567744 20260323154454_YfUc7 NZ0025 2026-03-24T12:14:05.643Z 2026-03-31T12:28:18.220Z
9567665 9567665 20260323153854_y6QmU NZ0025 2026-03-24T12:13:56.560Z 2026-03-24T12:24:25.319Z
9567596 9567596 20260323153446_ghC3l NZ0025 2026-03-24T12:13:50.360Z 2026-03-31T12:28:16.309Z
9567591 9567591 20260323153446_FYmYt NZ0025 2026-03-24T12:13:49.934Z 2026-03-31T12:28:16.231Z
9567565 9567565 20260323153117_7bNA1 NZ0025 2026-03-24T12:13:47.688Z 2026-03-31T12:28:15.940Z
9567529 9567529 20260323152646_deCFy NZ0025 2026-03-24T12:13:44.639Z 2026-03-31T12:28:15.342Z
9567308 9567308 20260323150425_2VQQd NZ0025 2026-03-24T12:13:22.208Z 2026-03-31T12:28:12.498Z
9567209 9567209 20260323145333_O2ZwA NZ0025 2026-03-24T12:13:13.603Z 2026-03-31T12:28:10.333Z
9567199 9567199 20260323145205_9gT8d NZ0025 2026-03-24T12:13:12.347Z 2026-03-31T12:28:10.255Z
9566959 9566959 20260323143048_Paa42 NZ0025 2026-03-24T12:12:46.532Z 2026-03-31T12:28:06.524Z
9566899 9566899 20260323142404_4ZWIl NZ0025 2026-03-24T12:12:40.659Z 2026-03-31T12:28:05.870Z

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