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

423 rows where station_code = "NZ007E" 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
9627506 9627506 20260408180916_gJhUa NZ007E 2026-04-09T12:11:13.287Z 2026-04-10T12:14:22.556Z
9627497 9627497 20260408180547_U8eLI NZ007E 2026-04-09T12:11:11.906Z 2026-04-10T12:14:22.554Z
9627483 9627483 20260408175942_U762o NZ007E 2026-04-09T12:11:10.411Z 2026-04-10T12:14:22.552Z
9627466 9627466 20260408174436_G7aaK NZ007E 2026-04-09T12:11:07.066Z 2026-04-10T12:14:22.548Z
9627416 9627416 20260408172838_Ze8Lg NZ007E 2026-04-09T12:10:52.594Z 2026-04-10T12:14:22.539Z
9627394 9627394 20260408172312_KCUAf NZ007E 2026-04-09T12:10:47.855Z 2026-04-10T12:14:22.535Z
9627384 9627384 20260408172254_JS23O NZ007E 2026-04-09T12:10:46.768Z 2026-04-10T12:14:22.534Z
9627355 9627355 20260408172029_833D3 NZ007E 2026-04-09T12:10:44.304Z 2026-04-10T12:14:22.530Z
9627282 9627282 20260408165928_HB1zj NZ007E 2026-04-09T12:10:32.362Z 2026-04-10T12:14:22.515Z
9627274 9627274 20260408165644_iHwD2 NZ007E 2026-04-09T12:10:30.907Z 2026-04-10T12:14:22.513Z
9627080 9627080 20260408161013_Cnn3D NZ007E 2026-04-09T12:09:54.009Z 2026-04-10T12:14:22.476Z
9627044 9627044 20260408160000_LNU1W NZ007E 2026-04-09T12:09:50.001Z 2026-04-10T12:14:22.466Z
9626267 9626267 20260408133449_Ms12M NZ007E 2026-04-09T12:07:51.364Z 2026-04-10T12:14:22.325Z
9626244 9626244 20260408133004_pLbxY NZ007E 2026-04-09T12:07:49.237Z 2026-04-10T12:14:22.322Z
9625975 9625975 20260408124303_BJAHm NZ007E 2026-04-09T12:07:13.094Z 2026-04-10T12:14:22.273Z
9625887 9625887 20260408122140_3WEwM NZ007E 2026-04-09T12:07:03.242Z 2026-04-10T12:14:22.259Z
9625634 9625634 20260408113027_MNEOJ NZ007E 2026-04-09T12:06:10.150Z 2026-04-10T12:14:22.216Z
9625326 9625326 20260408102432_EW0jP NZ007E 2026-04-09T12:05:08.230Z 2026-04-10T12:14:21.904Z
9625201 9625201 20260408095409_3TPqA NZ007E 2026-04-09T12:04:38.537Z 2026-04-10T12:14:21.877Z
9625115 9625115 20260408093929_PyyDp NZ007E 2026-04-09T12:04:18.299Z 2026-04-10T12:14:21.858Z
9624791 9624791 20260408082800_ijHIh NZ007E 2026-04-09T12:02:55.718Z 2026-04-10T12:14:21.463Z
9624782 9624782 20260408082800_YT69J NZ007E 2026-04-09T12:02:55.167Z 2026-04-10T12:14:21.462Z
9624771 9624771 20260408082643_xwDhp NZ007E 2026-04-09T12:02:53.007Z 2026-04-10T12:14:21.459Z
9613229 9613229 20260405101433_2EHxM NZ007E 2026-04-07T12:05:11.917Z 2026-04-10T12:26:25.273Z
9612351 9612351 20260406100501_7r99L NZ007E 2026-04-07T12:01:34.034Z 2026-04-10T12:22:05.530Z
9611825 9611825 20260403095038_B1nBb NZ007E 2026-04-06T12:17:48.346Z 2026-04-10T12:31:35.318Z
9610301 9610301 20260405155913_3RCOD NZ007E 2026-04-06T12:06:55.065Z 2026-04-10T12:27:03.437Z
9610188 9610188 20260405142053_LH0Ys NZ007E 2026-04-06T12:06:16.696Z 2026-04-10T12:26:59.527Z
9610078 9610078 20260405124220_wDPrk NZ007E 2026-04-06T12:05:35.953Z 2026-04-10T12:26:34.454Z
9609977 9609977 20260405113719_pSvj3 NZ007E 2026-04-06T12:05:04.582Z 2026-04-10T12:26:31.525Z
9602013 9602013 20260401174852_Cooq3 NZ007E 2026-04-02T12:04:30.804Z 2026-04-10T12:35:52.395Z
9601037 9601037 20260401104644_g8YHd NZ007E 2026-04-02T12:01:21.505Z 2026-04-10T12:35:31.971Z
9600992 9600992 20260401101538_qkWkF NZ007E 2026-04-02T12:01:13.715Z 2026-04-10T12:35:31.262Z
9599761 9599761 20260331163948_rzAax NZ007E 2026-04-01T12:04:43.985Z 2026-04-09T12:47:23.446Z
9599596 9599596 20260331155911_CEH78 NZ007E 2026-04-01T12:04:11.836Z 2026-04-09T12:47:04.058Z
9599565 9599565 20260331154554_jMEdL NZ007E 2026-04-01T12:04:03.935Z 2026-04-09T12:46:58.434Z
9599234 9599234 20260331130727_AaDW3 NZ007E 2026-04-01T12:02:49.773Z 2026-04-09T12:46:44.468Z
9598052 9598052 20260330173535_EDIOf NZ007E 2026-03-31T12:07:30.718Z 2026-04-08T12:44:24.335Z
9596010 9596010 20260330103900_RilRy NZ007E 2026-03-31T12:03:07.743Z 2026-04-08T12:42:38.424Z
9595860 9595860 20260330092932_VvmCM NZ007E 2026-03-31T12:02:42.718Z 2026-03-31T12:02:42.718Z
9595775 9595775 20260330083505_z0Nq1 NZ007E 2026-03-31T12:02:27.532Z 2026-04-08T12:42:31.825Z
9595719 9595719 20260330081245_RFZDR NZ007E 2026-03-31T12:02:17.522Z 2026-04-08T12:42:30.351Z
9591096 9591096 20260328131415_7LPrb NZ007E 2026-03-29T12:03:49.954Z 2026-04-06T12:39:00.219Z
9583509 9583509 20260326154124_mTzrM NZ007E 2026-03-27T12:09:01.337Z 2026-04-04T12:41:21.821Z
9583456 9583456 20260326150834_kqMFm NZ007E 2026-03-27T12:08:51.558Z 2026-03-27T12:08:51.558Z
9579349 9579349 20260324172919_VnKOd NZ007E 2026-03-26T12:13:07.818Z 2026-04-02T12:37:01.258Z
9579239 9579239 20260324141517_AjU37 NZ007E 2026-03-26T12:12:11.745Z 2026-04-02T12:36:30.411Z
9579138 9579138 20260324105411_TcUad NZ007E 2026-03-26T12:11:10.642Z 2026-04-02T12:35:43.882Z
9579127 9579127 20260324100614_S2UDF NZ007E 2026-03-26T12:11:01.494Z 2026-04-02T12:35:37.151Z
9579124 9579124 20260324100238_AqEAw NZ007E 2026-03-26T12:10:59.982Z 2026-04-02T12:35:36.024Z
9578739 9578739 20260325135834_xNIMd NZ007E 2026-03-26T12:08:22.225Z 2026-04-03T12:38:27.466Z
9578729 9578729 20260325135621_5we26 NZ007E 2026-03-26T12:08:20.944Z 2026-04-03T12:38:24.958Z
9578681 9578681 20260325132426_ZERll NZ007E 2026-03-26T12:08:14.309Z 2026-04-03T12:38:16.780Z
9578651 9578651 20260325130602_n2QRa NZ007E 2026-03-26T12:08:09.845Z 2026-04-03T12:38:15.276Z
9578354 9578354 20260325112452_1BVap NZ007E 2026-03-26T12:07:23.284Z 2026-04-03T12:37:59.678Z
9574920 9574920 20260323173823_DVxJB NZ007E 2026-03-25T12:19:52.232Z 2026-03-31T12:28:44.250Z
9574873 9574873 20260323173126_NEK1R NZ007E 2026-03-25T12:19:48.603Z 2026-03-31T12:28:43.656Z
9574847 9574847 20260323172727_WMHpQ NZ007E 2026-03-25T12:19:46.055Z 2026-03-31T12:28:43.168Z
9574788 9574788 20260323172128_NjB5P NZ007E 2026-03-25T12:19:41.250Z 2026-03-31T12:28:41.997Z
9574536 9574536 20260324173927_zA8pk NZ007E 2026-03-25T12:10:52.335Z 2026-04-02T12:37:02.048Z
9574518 9574518 20260324173201_Kdwi6 NZ007E 2026-03-25T12:10:48.743Z 2026-04-02T12:37:01.406Z
9574514 9574514 20260324172919_5UQXz NZ007E 2026-03-25T12:10:48.312Z 2026-03-25T12:10:48.312Z
9574511 9574511 20260324172333_BUm5w NZ007E 2026-03-25T12:10:47.800Z 2026-04-02T12:37:00.997Z
9574392 9574392 20260324165159_28Nu0 NZ007E 2026-03-25T12:10:29.129Z 2026-04-02T12:36:49.842Z
9574381 9574381 20260324164727_GR6wp NZ007E 2026-03-25T12:10:26.204Z 2026-04-02T12:36:49.634Z
9574362 9574362 20260324163600_2yJQx NZ007E 2026-03-25T12:10:23.852Z 2026-04-02T12:36:48.913Z
9574240 9574240 20260324160242_yHiGf NZ007E 2026-03-25T12:10:04.364Z 2026-04-02T12:36:43.488Z
9574156 9574156 20260324153025_3l2bx NZ007E 2026-03-25T12:09:49.829Z 2026-04-02T12:36:40.632Z
9573967 9573967 20260324144159_bUdYe NZ007E 2026-03-25T12:09:19.163Z 2026-04-02T12:36:33.304Z
9573959 9573959 20260324143740_KgEGZ NZ007E 2026-03-25T12:09:16.828Z 2026-03-25T12:09:16.828Z
9573948 9573948 20260324143554_WAAtI NZ007E 2026-03-25T12:09:15.662Z 2026-04-02T12:36:32.787Z
9573907 9573907 20260324141933_YPRU3 NZ007E 2026-03-25T12:09:09.232Z 2026-04-02T12:36:31.170Z
9573879 9573879 20260324141510_I9hvi NZ007E 2026-03-25T12:09:05.582Z 2026-03-25T12:09:05.582Z
9573594 9573594 20260324125654_229Qc NZ007E 2026-03-25T12:08:24.267Z 2026-04-02T12:36:15.686Z
9573523 9573523 20260324123541_dG7k9 NZ007E 2026-03-25T12:08:12.656Z 2026-04-02T12:36:12.375Z
9572900 9572900 20260324104802_wz3j4 NZ007E 2026-03-25T12:06:40.051Z 2026-04-02T12:35:42.989Z
9572578 9572578 20260324093240_ew1uc NZ007E 2026-03-25T12:05:37.329Z 2026-04-02T12:35:30.443Z
9572360 9572360 20260324084139_HtwsF NZ007E 2026-03-25T12:04:49.465Z 2026-04-02T12:35:21.196Z
9572286 9572286 20260324082925_nDyxV NZ007E 2026-03-25T12:04:34.758Z 2026-04-02T12:35:12.532Z
9569541 9569541 20260322160943_Lt26u NZ007E 2026-03-24T12:21:20.138Z 2026-03-30T12:30:08.053Z
9569499 9569499 20260322155633_q97Jv NZ007E 2026-03-24T12:21:14.350Z 2026-03-30T12:30:05.973Z
9569363 9569363 20260322150615_JvI2R NZ007E 2026-03-24T12:20:45.333Z 2026-03-30T12:29:50.166Z
9569224 9569224 20260322141617_jUOxU NZ007E 2026-03-24T12:20:13.837Z 2026-03-30T12:29:39.896Z
9569108 9569108 20260322132657_hLSM2 NZ007E 2026-03-24T12:19:49.276Z 2026-03-30T12:29:33.703Z
9569008 9569008 20260322122214_5w5zD NZ007E 2026-03-24T12:19:22.529Z 2026-03-30T12:29:17.061Z
9568791 9568791 20260322082114_e20Jn NZ007E 2026-03-24T12:17:59.033Z 2026-03-30T12:28:37.307Z
9568754 9568754 20260323171850_2b8hD NZ007E 2026-03-24T12:15:40.837Z 2026-03-24T12:24:25.521Z
9568750 9568750 20260323171850_HUrxV NZ007E 2026-03-24T12:15:40.607Z 2026-03-24T12:24:25.520Z
9568743 9568743 20260323171650_68v7I NZ007E 2026-03-24T12:15:39.803Z 2026-03-31T12:28:41.353Z
9568701 9568701 20260323171422_fRq2u NZ007E 2026-03-24T12:15:35.963Z 2026-03-24T12:24:25.511Z
9568639 9568639 20260323170800_AoiYo NZ007E 2026-03-24T12:15:26.164Z 2026-03-31T12:28:39.364Z
9568577 9568577 20260323165658_3fp3o NZ007E 2026-03-24T12:15:19.340Z 2026-03-24T12:24:25.484Z
9568564 9568564 20260323165343_bo4VP NZ007E 2026-03-24T12:15:17.613Z 2026-03-31T12:28:30.691Z
9568533 9568533 20260323165246_FZFhv NZ007E 2026-03-24T12:15:15.346Z 2026-03-24T12:24:25.476Z
9568455 9568455 20260323164637_5WCXw NZ007E 2026-03-24T12:15:08.888Z 2026-03-31T12:28:29.478Z
9568188 9568188 20260323161825_x8wYa NZ007E 2026-03-24T12:14:41.970Z 2026-03-31T12:28:24.279Z
9568052 9568052 20260323160841_EbafN NZ007E 2026-03-24T12:14:27.250Z 2026-03-31T12:28:22.272Z
9567885 9567885 20260323155651_FjKDz NZ007E 2026-03-24T12:14:15.414Z 2026-03-24T12:24:25.357Z
9567616 9567616 20260323153558_YQAIW NZ007E 2026-03-24T12:13:52.297Z 2026-03-24T12:24:25.311Z
9567594 9567594 20260323153446_FYmYt NZ007E 2026-03-24T12:13:49.934Z 2026-03-31T12:28:16.231Z

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