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

>10,000 rows count all where station_code = "NZ0004" 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
9270658 9270658 20260128161832_Ke2nk NZ0004 2026-01-29T14:13:13.867Z 2026-01-29T14:13:13.867Z
9270566 9270566 20260128160159_c3uzd NZ0004 2026-01-29T14:12:47.477Z 2026-01-29T14:12:47.477Z
9270558 9270558 20260128160044_dqWE9 NZ0004 2026-01-29T14:12:45.890Z 2026-01-29T14:12:45.890Z
9270548 9270548 20260128155932_CO6gL NZ0004 2026-01-29T14:12:44.013Z 2026-01-29T14:12:44.013Z
9270527 9270527 20260128155810_jrsJ2 NZ0004 2026-01-29T14:12:32.576Z 2026-01-29T14:12:32.576Z
9270518 9270518 20260128155725_QiqHE NZ0004 2026-01-29T14:12:31.209Z 2026-01-29T14:12:31.209Z
9270409 9270409 20260128154541_1Prlx NZ0004 2026-01-29T14:12:10.746Z 2026-01-29T14:12:10.746Z
9270377 9270377 20260128154057_3uPDJ NZ0004 2026-01-29T14:11:59.041Z 2026-01-29T14:11:59.041Z
9270363 9270363 20260128153945_SwLuL NZ0004 2026-01-29T14:11:53.947Z 2026-01-29T14:11:53.947Z
9270302 9270302 20260128152958_BZ6Ef NZ0004 2026-01-29T14:11:42.487Z 2026-01-29T14:11:42.487Z
9270207 9270207 20260128151450_TaQn7 NZ0004 2026-01-29T14:11:19.425Z 2026-01-29T14:11:19.425Z
9270168 9270168 20260128150446_ms3dz NZ0004 2026-01-29T14:11:10.233Z 2026-01-29T14:11:10.233Z
9270119 9270119 20260128145826_FL3k1 NZ0004 2026-01-29T14:10:56.336Z 2026-01-29T14:10:56.336Z
9270087 9270087 20260128145240_Z8QvE NZ0004 2026-01-29T14:10:48.839Z 2026-01-29T14:10:48.839Z
9270061 9270061 20260128145132_mLJuB NZ0004 2026-01-29T14:10:45.722Z 2026-01-29T14:10:45.722Z
9270020 9270020 20260128144848_RziO7 NZ0004 2026-01-29T14:10:39.651Z 2026-01-29T14:10:39.651Z
9269964 9269964 20260128143811_iUD6O NZ0004 2026-01-29T14:10:21.600Z 2026-01-29T14:10:21.600Z
9269949 9269949 20260128143550_dGTa3 NZ0004 2026-01-29T14:10:18.992Z 2026-01-29T14:10:18.992Z
9269633 9269633 20260128134849_8nlgp NZ0004 2026-01-29T14:08:54.978Z 2026-01-29T14:08:54.978Z
9269606 9269606 20260128134414_zlQ5x NZ0004 2026-01-29T14:08:43.020Z 2026-01-29T14:08:43.020Z
9269586 9269586 20260128133957_4hu56 NZ0004 2026-01-29T14:08:38.017Z 2026-01-29T14:08:38.017Z
9269531 9269531 20260128132957_sW7vn NZ0004 2026-01-29T14:08:23.995Z 2026-01-29T14:08:23.995Z
9269442 9269442 20260128131858_P1520 NZ0004 2026-01-29T14:08:00.535Z 2026-01-29T14:08:00.535Z
9269332 9269332 20260128130314_zWEtF NZ0004 2026-01-29T14:07:29.236Z 2026-01-29T14:07:29.236Z
9269219 9269219 20260128124612_os2YS NZ0004 2026-01-29T14:07:02.451Z 2026-01-29T14:07:02.451Z
9269191 9269191 20260128124431_5czQ3 NZ0004 2026-01-29T14:06:56.507Z 2026-01-29T14:06:56.507Z
9269073 9269073 20260128121804_ueZO8 NZ0004 2026-01-29T14:06:18.700Z 2026-01-29T14:06:18.700Z
9269012 9269012 20260128120025_AtZ2M NZ0004 2026-01-29T14:06:00.903Z 2026-01-29T14:06:00.903Z
9268973 9268973 20260128115614_cnuyq NZ0004 2026-01-29T14:05:47.234Z 2026-01-29T14:05:47.234Z
9268643 9268643 20260128105716_3GD9X NZ0004 2026-01-29T14:04:09.659Z 2026-01-29T14:04:09.659Z
9268461 9268461 20260128102439_9DUhV NZ0004 2026-01-29T14:03:14.128Z 2026-01-29T14:03:14.128Z
9268155 9268155 20260128090605_Onh32 NZ0004 2026-01-29T14:01:26.245Z 2026-01-29T14:01:26.245Z
9265874 9265874 20260127160938_6SM1C NZ0004 2026-01-28T14:11:39.037Z 2026-01-29T14:30:24.705Z
9265760 9265760 20260127155706_BnQKw NZ0004 2026-01-28T14:11:16.657Z 2026-01-29T14:30:24.670Z
9265653 9265653 20260127154547_YG9En NZ0004 2026-01-28T14:10:52.685Z 2026-01-29T14:30:24.647Z
9265520 9265520 20260127152412_R6Al1 NZ0004 2026-01-28T14:10:26.665Z 2026-01-29T14:30:24.598Z
9265205 9265205 20260127143813_jAAVj NZ0004 2026-01-28T14:09:28.287Z 2026-01-29T14:30:24.502Z
9265154 9265154 20260127142558_4O8Ww NZ0004 2026-01-28T14:09:15.044Z 2026-01-29T14:30:24.470Z
9265135 9265135 20260127142429_Y6wcY NZ0004 2026-01-28T14:09:11.806Z 2026-01-29T14:30:24.458Z
9265104 9265104 20260127141917_ZSLMQ NZ0004 2026-01-28T14:09:03.458Z 2026-01-29T14:30:24.449Z
9265005 9265005 20260127135434_KyL2j NZ0004 2026-01-28T14:08:36.003Z 2026-01-29T14:30:24.412Z
9264992 9264992 20260127134852_M5uJ3 NZ0004 2026-01-28T14:08:32.378Z 2026-01-29T14:30:24.408Z
9264977 9264977 20260127134612_glDix NZ0004 2026-01-28T14:08:28.522Z 2026-01-29T14:30:24.404Z
9264939 9264939 20260127133939_hO4Lu NZ0004 2026-01-28T14:08:19.702Z 2026-01-29T14:30:24.396Z
9264930 9264930 20260127133931_GDtEN NZ0004 2026-01-28T14:08:19.042Z 2026-01-29T14:30:24.395Z
9264791 9264791 20260127131331_3w6cC NZ0004 2026-01-28T14:07:41.956Z 2026-01-29T14:30:24.293Z
9264719 9264719 20260127130158_393A7 NZ0004 2026-01-28T14:07:21.212Z 2026-01-29T14:30:24.263Z
9264675 9264675 20260127125436_LiB0z NZ0004 2026-01-28T14:07:07.997Z 2026-01-29T14:30:24.252Z
9264599 9264599 20260127125004_UaSrf NZ0004 2026-01-28T14:06:50.158Z 2026-01-29T14:30:24.227Z
9264588 9264588 20260127124904_B4bCv NZ0004 2026-01-28T14:06:47.822Z 2026-01-29T14:30:24.225Z
9264482 9264482 20260127123056_ivTDl NZ0004 2026-01-28T14:06:18.741Z 2026-01-29T14:30:24.183Z
9264477 9264477 20260127123044_tCmto NZ0004 2026-01-28T14:06:18.097Z 2026-01-29T14:30:24.182Z
9253073 9253073 20260124090320_smfHl NZ0004 2026-01-25T14:00:31.935Z 2026-01-29T14:40:13.695Z
9250402 9250402 20260123142447_FIl8G NZ0004 2026-01-24T14:02:44.747Z 2026-01-29T14:45:31.190Z
9250019 9250019 20260123094252_JZqcz NZ0004 2026-01-24T14:00:40.555Z 2026-01-29T14:44:52.041Z
9250015 9250015 20260123093931_mMa42 NZ0004 2026-01-24T14:00:38.659Z 2026-01-29T14:44:47.960Z
9246004 9246004 20260122155849_ba4dt NZ0004 2026-01-23T14:04:19.427Z 2026-01-29T14:50:29.245Z
9245999 9245999 20260122155705_ZG3x9 NZ0004 2026-01-23T14:04:15.731Z 2026-01-29T14:50:29.145Z
9245793 9245793 20260122143512_FAkPy NZ0004 2026-01-23T14:03:30.890Z 2026-01-29T14:50:12.872Z
9245325 9245325 20260122114806_IM1QI NZ0004 2026-01-23T14:01:30.173Z 2026-01-29T14:49:24.156Z
9245302 9245302 20260122114321_bLoMa NZ0004 2026-01-23T14:01:24.381Z 2026-01-29T14:49:22.699Z
9245170 9245170 20260122105258_5qnnd NZ0004 2026-01-23T14:00:51.833Z 2026-01-29T14:49:10.939Z
9245150 9245150 20260122103820_WZ40d NZ0004 2026-01-23T14:00:48.388Z 2026-01-29T14:49:05.243Z
9245052 9245052 20260122094442_sdP8v NZ0004 2026-01-23T14:00:18.615Z 2026-01-29T14:48:54.116Z
9227003 9227003 20260119135620_4YteU NZ0004 2026-01-20T14:06:10.327Z 2026-01-28T14:55:46.577Z
9226948 9226948 20260119133501_O31EQ NZ0004 2026-01-20T14:05:49.218Z 2026-01-28T14:55:43.429Z
9226945 9226945 20260119133440_DkgIT NZ0004 2026-01-20T14:05:48.340Z 2026-01-28T14:55:43.252Z
9226789 9226789 20260119130417_m79fR NZ0004 2026-01-20T14:05:02.028Z 2026-01-28T14:55:27.547Z
9226760 9226760 20260119130035_uFOic NZ0004 2026-01-20T14:04:54.356Z 2026-01-28T14:55:25.744Z
9226114 9226114 20260119110851_9BTwI NZ0004 2026-01-20T14:01:12.927Z 2026-01-28T14:54:35.399Z
9219601 9219601 20260117111632_DgLbc NZ0004 2026-01-18T14:17:07.206Z 2026-01-25T14:59:33.102Z
9185451 9185451 20260111111213_P7EqN NZ0004 2026-01-12T14:24:55.827Z 2026-01-19T15:20:33.285Z
9185161 9185161 20260111131447_bdBWH NZ0004 2026-01-12T14:22:36.838Z 2026-01-19T15:21:53.314Z
9184881 9184881 20260111123256_CTe7P NZ0004 2026-01-12T14:21:49.642Z 2026-01-19T15:21:19.990Z
9184271 9184271 20260111110248_uLwRY NZ0004 2026-01-12T14:20:09.203Z 2026-01-19T15:20:31.191Z
9183697 9183697 20260111100208_tmsDU NZ0004 2026-01-12T14:18:35.255Z 2026-01-19T15:20:08.704Z
9183538 9183538 20260111094053_gGNJw NZ0004 2026-01-12T14:18:04.397Z 2026-01-19T15:19:45.035Z
9183263 9183263 20260111090630_U4q88 NZ0004 2026-01-12T14:17:18.875Z 2026-01-19T15:19:33.688Z
9178465 9178465 20260110131156_G9bCa NZ0004 2026-01-11T14:14:57.266Z 2026-01-18T15:10:52.095Z
9173589 9173589 20260109145741_Y26Ut NZ0004 2026-01-10T14:18:11.829Z 2026-01-17T15:26:53.612Z
9173318 9173318 20260109133828_f1tC4 NZ0004 2026-01-10T14:17:04.621Z 2026-01-17T15:26:38.897Z
9173313 9173313 20260109133820_3hYI3 NZ0004 2026-01-10T14:17:03.979Z 2026-01-17T15:26:38.611Z
9170444 9170444 20260109152220_8x6rX NZ0004 2026-01-10T14:00:36.832Z 2026-01-18T15:06:21.727Z
9169646 9169646 20260108151430_258fm NZ0004 2026-01-09T14:14:13.551Z 2026-01-16T15:14:22.818Z
9169445 9169445 20260108143539_NcJxg NZ0004 2026-01-09T14:13:35.525Z 2026-01-16T15:13:59.288Z
9169357 9169357 20260108141832_CDzR5 NZ0004 2026-01-09T14:13:21.484Z 2026-01-16T15:13:54.264Z
9169044 9169044 20260108131039_W92nV NZ0004 2026-01-09T14:12:39.734Z 2026-01-16T15:13:27.073Z
9168993 9168993 20260108125740_ouiXk NZ0004 2026-01-09T14:12:32.904Z 2026-01-16T15:13:25.010Z
9168979 9168979 20260108125653_1bOqN NZ0004 2026-01-09T14:12:31.202Z 2026-01-16T15:13:24.462Z
9168919 9168919 20260108124220_LxKO4 NZ0004 2026-01-09T14:12:21.522Z 2026-01-16T15:13:20.523Z
9168804 9168804 20260108122232_LBaPp NZ0004 2026-01-09T14:12:03.731Z 2026-01-16T15:13:08.343Z
9168215 9168215 20260108101621_1CHEN NZ0004 2026-01-09T14:10:37.176Z 2026-01-16T15:12:23.755Z
9165927 9165927 20260108153917_qh4cp NZ0004 2026-01-09T14:00:23.916Z 2026-01-17T15:22:44.588Z
9165388 9165388 20260107153846_IjMws NZ0004 2026-01-08T14:16:16.540Z 2026-01-13T15:05:51.681Z
9165378 9165378 20260107153712_7KzvO NZ0004 2026-01-08T14:16:15.543Z 2026-01-13T15:05:51.099Z
9165364 9165364 20260107153439_OmEkA NZ0004 2026-01-08T14:16:14.394Z 2026-01-13T15:05:50.201Z
9165310 9165310 20260107152637_7enTO NZ0004 2026-01-08T14:16:04.191Z 2026-01-13T15:05:39.638Z
9165272 9165272 20260107152401_7mbW3 NZ0004 2026-01-08T14:15:55.315Z 2026-01-13T15:05:38.041Z
9164916 9164916 20260107144459_KruhZ NZ0004 2026-01-08T14:14:48.645Z 2026-01-13T15:05:19.543Z
9164896 9164896 20260107144227_Ugwe9 NZ0004 2026-01-08T14:14:45.359Z 2026-01-13T15:05:10.804Z

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