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

255 rows where station_code = "NZ006B" 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
9627101 9627101 20260408161642_8YsDl NZ006B 2026-04-09T12:10:03.241Z 2026-04-10T12:14:22.480Z
9627069 9627069 20260408160748_vSEO6 NZ006B 2026-04-09T12:09:53.133Z 2026-04-10T12:14:22.474Z
9626994 9626994 20260408154616_6zhLG NZ006B 2026-04-09T12:09:42.218Z 2026-04-10T12:14:22.453Z
9626988 9626988 20260408154607_KedkO NZ006B 2026-04-09T12:09:41.733Z 2026-04-10T12:14:22.452Z
9626906 9626906 20260408152027_3dIMF NZ006B 2026-04-09T12:09:30.246Z 2026-04-10T12:14:22.432Z
9626421 9626421 20260408140002_A5O4N NZ006B 2026-04-09T12:08:18.507Z 2026-04-10T12:14:22.350Z
9626222 9626222 20260408132621_ALeQP NZ006B 2026-04-09T12:07:47.336Z 2026-04-10T12:14:22.319Z
9626141 9626141 20260408131605_ULKaC NZ006B 2026-04-09T12:07:40.413Z 2026-04-10T12:14:22.308Z
9625918 9625918 20260408122428_yYO1J NZ006B 2026-04-09T12:07:06.718Z 2026-04-10T12:14:22.263Z
9625737 9625737 20260408114122_1trxe NZ006B 2026-04-09T12:06:32.957Z 2026-04-10T12:14:22.232Z
9625462 9625462 20260408105649_OcGbV NZ006B 2026-04-09T12:05:36.369Z 2026-04-10T12:14:21.929Z
9624922 9624922 20260408085700_YJ2Xt NZ006B 2026-04-09T12:03:27.918Z 2026-04-10T12:14:21.813Z
9612254 9612254 20260406091217_9hNwf NZ006B 2026-04-07T12:01:13.916Z 2026-04-10T12:22:02.647Z
9599952 9599952 20260331174311_RVcOo NZ006B 2026-04-01T12:05:23.782Z 2026-04-09T12:48:03.549Z
9599846 9599846 20260331170719_3n3jR NZ006B 2026-04-01T12:05:02.601Z 2026-04-09T12:47:39.540Z
9599613 9599613 20260331160129_cKG3J NZ006B 2026-04-01T12:04:14.607Z 2026-04-09T12:47:06.163Z
9588744 9588744 20260325131015_c7jp9 NZ006B 2026-03-28T12:14:36.886Z 2026-04-03T12:38:15.579Z
9588742 9588742 20260325123613_vEBPq NZ006B 2026-03-28T12:14:33.505Z 2026-04-03T12:38:10.592Z
9588732 9588732 20260325095912_Uj2nT NZ006B 2026-03-28T12:13:58.247Z 2026-04-03T12:37:36.732Z
9579243 9579243 20260324141904_TvCdk NZ006B 2026-03-26T12:12:13.052Z 2026-04-02T12:36:31.007Z
9579215 9579215 20260324133504_Vnlad NZ006B 2026-03-26T12:12:00.592Z 2026-04-02T12:36:25.327Z
9574905 9574905 20260323173558_E2u8H NZ006B 2026-03-25T12:19:51.236Z 2026-03-25T12:21:38.580Z
9574896 9574896 20260323173246_KDNki NZ006B 2026-03-25T12:19:50.099Z 2026-03-31T12:28:43.881Z
9567894 9567894 20260323155730_q2dbA NZ006B 2026-03-24T12:14:16.003Z 2026-03-31T12:28:20.157Z
9567871 9567871 20260323155458_6yA6u NZ006B 2026-03-24T12:14:14.485Z 2026-03-31T12:28:19.935Z
9567859 9567859 20260323155450_aCGvc NZ006B 2026-03-24T12:14:14.095Z 2026-03-31T12:28:19.907Z
9567610 9567610 20260323153521_jZ8Df NZ006B 2026-03-24T12:13:51.469Z 2026-03-31T12:28:16.686Z
9567282 9567282 20260323150139_IoFXh NZ006B 2026-03-24T12:13:20.023Z 2026-03-24T12:24:25.250Z
9566676 9566676 20260323140300_wQGdS NZ006B 2026-03-24T12:12:17.298Z 2026-03-31T12:27:55.313Z
9565774 9565774 20260323124026_H6Gvn NZ006B 2026-03-24T12:10:49.932Z 2026-03-31T12:27:41.164Z
9565704 9565704 20260323123329_fg2cq NZ006B 2026-03-24T12:10:40.104Z 2026-03-31T12:27:39.877Z
9565520 9565520 20260323121457_H8YWB NZ006B 2026-03-24T12:10:20.078Z 2026-03-31T12:27:36.905Z
9564676 9564676 20260323110051_w3scM NZ006B 2026-03-24T12:08:32.936Z 2026-03-31T12:27:13.448Z
9564474 9564474 20260323103847_ywS2H NZ006B 2026-03-24T12:08:09.883Z 2026-03-31T12:27:09.646Z
9564411 9564411 20260323103245_FD0oV NZ006B 2026-03-24T12:08:02.370Z 2026-03-31T12:27:08.670Z
9564222 9564222 20260323101317_rJyLk NZ006B 2026-03-24T12:07:38.731Z 2026-03-31T12:27:05.292Z
9563800 9563800 20260323090948_341Ft NZ006B 2026-03-24T12:06:44.138Z 2026-03-31T12:26:56.771Z
9563794 9563794 20260323090900_EYuHx NZ006B 2026-03-24T12:06:43.788Z 2026-03-31T12:26:56.721Z
9563731 9563731 20260323090401_Eu8h0 NZ006B 2026-03-24T12:06:36.675Z 2026-03-31T12:26:49.844Z
9563706 9563706 20260323090133_9PjcU NZ006B 2026-03-24T12:06:35.482Z 2026-03-31T12:26:49.595Z
9563502 9563502 20260323082617_hlJtD NZ006B 2026-03-24T12:06:07.738Z 2026-03-31T12:26:45.297Z
9563350 9563350 20260323080405_3lRHT NZ006B 2026-03-24T12:05:47.591Z 2026-03-31T12:26:41.199Z
9556205 9556205 20260322093255_SAnxG NZ006B 2026-03-23T12:04:28.453Z 2026-03-30T12:28:47.326Z
9549475 9549475 20260320150240_UWbyc NZ006B 2026-03-22T12:24:01.944Z 2026-03-28T12:36:04.586Z
9549100 9549100 20260321172103_SAD2o NZ006B 2026-03-22T12:16:32.857Z 2026-03-29T12:20:39.561Z
9549071 9549071 20260321171009_vQig3 NZ006B 2026-03-22T12:16:29.634Z 2026-03-29T12:20:38.552Z
9546663 9546663 20260321121628_PW4x6 NZ006B 2026-03-22T12:12:11.930Z 2026-03-29T12:20:03.083Z
9546424 9546424 20260321115939_YbG4B NZ006B 2026-03-22T12:11:41.987Z 2026-03-29T12:20:01.012Z
9546007 9546007 20260321113027_yNALr NZ006B 2026-03-22T12:10:48.658Z 2026-03-29T12:19:46.658Z
9545776 9545776 20260321110623_AtTky NZ006B 2026-03-22T12:10:15.008Z 2026-03-29T12:19:43.162Z
9545728 9545728 20260321110050_tfSrv NZ006B 2026-03-22T12:10:06.366Z 2026-03-29T12:19:42.812Z
9545445 9545445 20260321103622_27iJw NZ006B 2026-03-22T12:09:26.696Z 2026-03-29T12:19:40.259Z
9544795 9544795 20260321092402_HDHUa NZ006B 2026-03-22T12:07:50.166Z 2026-03-29T12:19:34.037Z
9544661 9544661 20260321090722_yMofA NZ006B 2026-03-22T12:07:26.200Z 2026-03-29T12:19:32.270Z
9544467 9544467 20260321084310_HrP8G NZ006B 2026-03-22T12:06:54.804Z 2026-03-29T12:19:30.144Z
9539574 9539574 20260320152521_2fxZG NZ006B 2026-03-21T12:19:45.839Z 2026-03-28T12:36:09.914Z
9539463 9539463 20260320145109_FcQLD NZ006B 2026-03-21T12:19:35.014Z 2026-03-28T12:36:01.795Z
9538938 9538938 20260320135754_BQ0ck NZ006B 2026-03-21T12:18:37.378Z 2026-03-28T12:35:54.918Z
9538761 9538761 20260320134318_PDMEq NZ006B 2026-03-21T12:18:19.867Z 2026-03-28T12:35:52.124Z
9538759 9538759 20260320134318_Wfgwg NZ006B 2026-03-21T12:18:19.463Z 2026-03-28T12:35:52.089Z
9538529 9538529 20260320131657_d0XcB NZ006B 2026-03-21T12:17:54.408Z 2026-03-21T12:30:06.505Z
9538270 9538270 20260320124658_g2lV1 NZ006B 2026-03-21T12:17:25.598Z 2026-03-28T12:35:43.785Z
9537095 9537095 20260320110528_ltOL7 NZ006B 2026-03-21T12:15:04.361Z 2026-03-28T12:35:21.318Z
9536735 9536735 20260320102255_2M3Ub NZ006B 2026-03-21T12:14:12.349Z 2026-03-28T12:35:12.849Z
9536158 9536158 20260320091939_D8BL1 NZ006B 2026-03-21T12:12:43.911Z 2026-03-28T12:34:58.297Z
9535850 9535850 20260320083626_37A8X NZ006B 2026-03-21T12:12:02.256Z 2026-03-28T12:34:52.428Z
9528928 9528928 20260318165623_MSmxq NZ006B 2026-03-20T12:22:37.546Z 2026-03-26T12:38:39.147Z
9528904 9528904 20260318165406_KZeAT NZ006B 2026-03-20T12:22:35.685Z 2026-03-26T12:38:38.883Z
9528585 9528585 20260318162525_kmqV2 NZ006B 2026-03-20T12:22:23.086Z 2026-03-26T12:38:37.035Z
9528515 9528515 20260318162108_B2jjB NZ006B 2026-03-20T12:22:20.475Z 2026-03-26T12:38:36.643Z
9528272 9528272 20260318155618_324gv NZ006B 2026-03-20T12:22:02.559Z 2026-03-26T12:38:35.001Z
9528057 9528057 20260318153745_D0WQe NZ006B 2026-03-20T12:21:54.042Z 2026-03-26T12:38:32.879Z
9527906 9527906 20260318152352_u74H3 NZ006B 2026-03-20T12:21:47.560Z 2026-03-26T12:38:31.939Z
9527614 9527614 20260318150119_6Rm7x NZ006B 2026-03-20T12:21:34.226Z 2026-03-26T12:38:29.975Z
9527331 9527331 20260318143054_s375u NZ006B 2026-03-20T12:21:12.056Z 2026-03-26T12:38:27.798Z
9527147 9527147 20260318140603_PxjJM NZ006B 2026-03-20T12:21:01.741Z 2026-03-26T12:38:26.318Z
9527060 9527060 20260318135312_uxQue NZ006B 2026-03-20T12:20:57.594Z 2026-03-26T12:38:25.671Z
9526979 9526979 20260318134355_jwlNS NZ006B 2026-03-20T12:20:47.674Z 2026-03-26T12:38:25.075Z
9515234 9515234 20260318130717_62rnG NZ006B 2026-03-19T12:19:24.087Z 2026-03-26T12:38:22.842Z
9515186 9515186 20260318125533_mYGuE NZ006B 2026-03-19T12:19:16.052Z 2026-03-26T12:38:22.360Z
9515050 9515050 20260318123336_fDd0i NZ006B 2026-03-19T12:18:56.503Z 2026-03-26T12:38:21.475Z
9514977 9514977 20260318122327_22EVf NZ006B 2026-03-19T12:18:45.761Z 2026-03-26T12:38:20.904Z
9514755 9514755 20260318120207_j30cr NZ006B 2026-03-19T12:18:16.788Z 2026-03-26T12:38:19.094Z
9514593 9514593 20260318114310_RsEM7 NZ006B 2026-03-19T12:17:53.304Z 2026-03-26T12:38:17.570Z
9514250 9514250 20260318110159_f2oE2 NZ006B 2026-03-19T12:17:01.057Z 2026-03-26T12:38:14.847Z
9514142 9514142 20260318105316_24YiK NZ006B 2026-03-19T12:16:52.200Z 2026-03-26T12:38:14.224Z
9514020 9514020 20260318103449_bVs4J NZ006B 2026-03-19T12:16:40.009Z 2026-03-26T12:38:13.399Z
9513992 9513992 20260318103216_Vr3nX NZ006B 2026-03-19T12:16:36.916Z 2026-03-26T12:38:13.159Z
9490815 9490815 20260315153529_0S40m NZ006B 2026-03-16T12:19:49.029Z 2026-03-23T12:22:37.689Z
9490670 9490670 20260315152140_vtrCk NZ006B 2026-03-16T12:19:30.145Z 2026-03-23T12:22:37.200Z
9489631 9489631 20260315133340_MeWw7 NZ006B 2026-03-16T12:17:30.296Z 2026-03-23T12:22:34.397Z
9489274 9489274 20260315130301_0X2EV NZ006B 2026-03-16T12:16:50.858Z 2026-03-23T12:22:33.643Z
9489017 9489017 20260315124024_2WATd NZ006B 2026-03-16T12:16:17.772Z 2026-03-23T12:22:32.896Z
9488898 9488898 20260315123241_nQZE3 NZ006B 2026-03-16T12:16:03.440Z 2026-03-23T12:22:32.621Z
9488630 9488630 20260315120522_X2rnP NZ006B 2026-03-16T12:15:31.825Z 2026-03-23T12:22:31.651Z
9488449 9488449 20260315115345_OIBZA NZ006B 2026-03-16T12:15:13.287Z 2026-03-23T12:22:30.456Z
9488392 9488392 20260315114749_yZbct NZ006B 2026-03-16T12:15:03.175Z 2026-03-23T12:22:27.912Z
9488176 9488176 20260315112214_Vz8J5 NZ006B 2026-03-16T12:14:34.845Z 2026-03-23T12:22:24.881Z
9487957 9487957 20260315110104_evvr8 NZ006B 2026-03-16T12:14:05.163Z 2026-03-23T12:22:23.077Z
9487726 9487726 20260315104303_I2Cau NZ006B 2026-03-16T12:13:33.388Z 2026-03-23T12:22:20.688Z

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