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

2,114 rows where station_code = "NZ0069" 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
9627474 9627474 20260408175410_RK3La NZ0069 2026-04-09T12:11:08.714Z 2026-04-10T12:14:22.550Z
9627371 9627371 20260408172202_FOVxe NZ0069 2026-04-09T12:10:46.022Z 2026-04-10T12:14:22.532Z
9627188 9627188 20260408163852_sy4g3 NZ0069 2026-04-09T12:10:15.897Z 2026-04-10T12:14:22.498Z
9627162 9627162 20260408163241_KySn5 NZ0069 2026-04-09T12:10:11.654Z 2026-04-10T12:14:22.491Z
9627153 9627153 20260408163240_UXUIE NZ0069 2026-04-09T12:10:11.120Z 2026-04-10T12:14:22.491Z
9627147 9627147 20260408163142_9RTsp NZ0069 2026-04-09T12:10:10.486Z 2026-04-10T12:14:22.490Z
9627099 9627099 20260408161642_8YsDl NZ0069 2026-04-09T12:10:03.241Z 2026-04-10T12:14:22.480Z
9626686 9626686 20260408145102_XVN7W NZ0069 2026-04-09T12:08:56.407Z 2026-04-10T12:14:22.400Z
9626659 9626659 20260408143700_iIVB6 NZ0069 2026-04-09T12:08:52.799Z 2026-04-10T12:14:22.393Z
9626621 9626621 20260408142750_XnW6t NZ0069 2026-04-09T12:08:47.880Z 2026-04-10T12:14:22.385Z
9626383 9626383 20260408135117_dxeCo NZ0069 2026-04-09T12:08:14.130Z 2026-04-10T12:14:22.342Z
9626240 9626240 20260408133002_JeENp NZ0069 2026-04-09T12:07:48.745Z 2026-04-10T12:14:22.321Z
9626140 9626140 20260408131605_ULKaC NZ0069 2026-04-09T12:07:40.413Z 2026-04-10T12:14:22.308Z
9625786 9625786 20260408114917_sG553 NZ0069 2026-04-09T12:06:42.456Z 2026-04-10T12:14:22.241Z
9625736 9625736 20260408114122_1trxe NZ0069 2026-04-09T12:06:32.957Z 2026-04-10T12:14:22.232Z
9625659 9625659 20260408113310_6Vpsp NZ0069 2026-04-09T12:06:13.954Z 2026-04-10T12:14:22.219Z
9625586 9625586 20260408112131_eypXT NZ0069 2026-04-09T12:06:02.062Z 2026-04-10T12:14:22.207Z
9625239 9625239 20260408100611_zdLOv NZ0069 2026-04-09T12:04:46.404Z 2026-04-10T12:14:21.885Z
9624996 9624996 20260408090930_fhu9Y NZ0069 2026-04-09T12:03:44.278Z 2026-04-10T12:14:21.828Z
9624707 9624707 20260408081230_VcZbX NZ0069 2026-04-09T12:02:33.275Z 2026-04-10T12:14:21.440Z
9624669 9624669 20260408080524_fdxk8 NZ0069 2026-04-09T12:02:26.579Z 2026-04-10T12:14:21.432Z
9624652 9624652 20260408080248_tKGvD NZ0069 2026-04-09T12:02:24.076Z 2026-04-10T12:14:21.428Z
9601391 9601391 20260401150038_c0Y2m NZ0069 2026-04-02T12:02:38.389Z 2026-04-10T12:35:38.237Z
9600261 9600261 20260330173607_oILY1 NZ0069 2026-04-01T12:09:53.949Z 2026-04-08T12:44:24.500Z
9600255 9600255 20260330172409_dBZjV NZ0069 2026-04-01T12:09:47.686Z 2026-04-08T12:44:21.984Z
9600186 9600186 20260330080756_ysF2Z NZ0069 2026-04-01T12:07:15.962Z 2026-04-08T12:42:29.966Z
9599759 9599759 20260331163845_qZCrv NZ0069 2026-04-01T12:04:43.576Z 2026-04-09T12:47:23.315Z
9599335 9599335 20260331140218_kGYWA NZ0069 2026-04-01T12:03:14.239Z 2026-04-09T12:46:46.124Z
9587796 9587796 20260327160432_VsCKC NZ0069 2026-03-28T12:06:21.658Z 2026-04-05T12:34:43.741Z
9587792 9587792 20260327160013_OB3ik NZ0069 2026-03-28T12:06:21.316Z 2026-04-05T12:34:42.522Z
9587589 9587589 20260327142102_Kz3r0 NZ0069 2026-03-28T12:05:51.808Z 2026-04-05T12:34:32.542Z
9578711 9578711 20260325134731_W8gBa NZ0069 2026-03-26T12:08:18.542Z 2026-04-03T12:38:18.032Z
9574916 9574916 20260323173647_Q7Yw8 NZ0069 2026-03-25T12:19:51.944Z 2026-03-31T12:28:44.227Z
9574894 9574894 20260323173246_KDNki NZ0069 2026-03-25T12:19:50.099Z 2026-03-31T12:28:43.881Z
9574547 9574547 20260324174216_J947r NZ0069 2026-03-25T12:10:53.065Z 2026-04-02T12:37:02.259Z
9574449 9574449 20260324170729_kvbmc NZ0069 2026-03-25T12:10:38.692Z 2026-04-02T12:36:59.084Z
9574443 9574443 20260324170720_HRfNW NZ0069 2026-03-25T12:10:37.694Z 2026-04-02T12:36:58.836Z
9574371 9574371 20260324163808_fXkxJ NZ0069 2026-03-25T12:10:24.736Z 2026-04-02T12:36:49.141Z
9573883 9573883 20260324141546_fut4V NZ0069 2026-03-25T12:09:06.175Z 2026-04-02T12:36:30.584Z
9573807 9573807 20260324134828_nCdyn NZ0069 2026-03-25T12:08:48.323Z 2026-04-02T12:36:27.475Z
9573800 9573800 20260324134825_f99z1 NZ0069 2026-03-25T12:08:47.764Z 2026-04-02T12:36:27.407Z
9573780 9573780 20260324134310_Ag2G1 NZ0069 2026-03-25T12:08:44.777Z 2026-04-02T12:36:26.608Z
9573747 9573747 20260324133846_0nTb8 NZ0069 2026-03-25T12:08:41.677Z 2026-04-02T12:36:25.697Z
9573728 9573728 20260324133504_Vnlad NZ0069 2026-03-25T12:08:40.339Z 2026-04-02T12:36:25.327Z
9573560 9573560 20260324124600_xGaLi NZ0069 2026-03-25T12:08:17.906Z 2026-04-02T12:36:14.580Z
9573044 9573044 20260324110946_GM3w3 NZ0069 2026-03-25T12:07:03.930Z 2026-04-02T12:35:53.756Z
9572758 9572758 20260324100554_laoOw NZ0069 2026-03-25T12:06:12.430Z 2026-04-02T12:35:37.052Z
9572737 9572737 20260324100454_VkAeP NZ0069 2026-03-25T12:06:10.224Z 2026-04-02T12:35:36.614Z
9572314 9572314 20260324083159_QW61h NZ0069 2026-03-25T12:04:38.322Z 2026-04-02T12:35:13.550Z
9567995 9567995 20260323160426_RvsE9 NZ0069 2026-03-24T12:14:22.020Z 2026-03-31T12:28:21.336Z
9567920 9567920 20260323160013_3pYIm NZ0069 2026-03-24T12:14:17.540Z 2026-03-31T12:28:20.649Z
9567817 9567817 20260323155136_nbHDo NZ0069 2026-03-24T12:14:10.998Z 2026-03-31T12:28:19.357Z
9567788 9567788 20260323154926_gAiuH NZ0069 2026-03-24T12:14:08.611Z 2026-03-31T12:28:18.841Z
9567727 9567727 20260323154346_2aj3W NZ0069 2026-03-24T12:14:01.388Z 2026-03-31T12:28:17.882Z
9567637 9567637 20260323153806_JUSCV NZ0069 2026-03-24T12:13:53.987Z 2026-03-31T12:28:16.997Z
9567568 9567568 20260323153117_7bNA1 NZ0069 2026-03-24T12:13:47.688Z 2026-03-31T12:28:15.940Z
9567540 9567540 20260323152718_Bts14 NZ0069 2026-03-24T12:13:45.099Z 2026-03-31T12:28:15.384Z
9567424 9567424 20260323151441_WBbgZ NZ0069 2026-03-24T12:13:35.602Z 2026-03-31T12:28:13.922Z
9567319 9567319 20260323150547_nRc9G NZ0069 2026-03-24T12:13:22.566Z 2026-03-31T12:28:12.628Z
9567165 9567165 20260323144657_u5IiS NZ0069 2026-03-24T12:13:08.822Z 2026-03-31T12:28:09.458Z
9566962 9566962 20260323143048_Paa42 NZ0069 2026-03-24T12:12:46.532Z 2026-03-31T12:28:06.524Z
9566770 9566770 20260323141209_hhPJ9 NZ0069 2026-03-24T12:12:24.940Z 2026-03-31T12:27:56.708Z
9566521 9566521 20260323134747_5s7CQ NZ0069 2026-03-24T12:12:01.612Z 2026-03-31T12:27:53.155Z
9566451 9566451 20260323133915_3PeW5 NZ0069 2026-03-24T12:11:52.733Z 2026-03-31T12:27:52.026Z
9566438 9566438 20260323133801_jl2n5 NZ0069 2026-03-24T12:11:51.600Z 2026-03-31T12:27:51.875Z
9566315 9566315 20260323132428_2KCmJ NZ0069 2026-03-24T12:11:39.531Z 2026-03-31T12:27:48.641Z
9566245 9566245 20260323131731_fzDLn NZ0069 2026-03-24T12:11:30.021Z 2026-03-31T12:27:47.577Z
9566222 9566222 20260323131540_m3qo3 NZ0069 2026-03-24T12:11:27.486Z 2026-03-31T12:27:47.185Z
9566186 9566186 20260323131133_Fay8Y NZ0069 2026-03-24T12:11:26.066Z 2026-03-31T12:27:46.976Z
9566150 9566150 20260323130935_kwiJZ NZ0069 2026-03-24T12:11:24.049Z 2026-03-31T12:27:46.661Z
9566001 9566001 20260323125616_jDNOH NZ0069 2026-03-24T12:11:11.232Z 2026-03-31T12:27:44.569Z
9565793 9565793 20260323124114_Ag3HU NZ0069 2026-03-24T12:10:51.989Z 2026-03-31T12:27:41.496Z
9564958 9564958 20260323113238_IHmmp NZ0069 2026-03-24T12:09:07.146Z 2026-03-31T12:27:19.841Z
9564605 9564605 20260323105452_DB04I NZ0069 2026-03-24T12:08:26.869Z 2026-03-31T12:27:12.278Z
9564422 9564422 20260323103305_fxoOo NZ0069 2026-03-24T12:08:02.785Z 2026-03-31T12:27:08.755Z
9564398 9564398 20260323103121_P3LA1 NZ0069 2026-03-24T12:08:01.224Z 2026-03-31T12:27:08.575Z
9563978 9563978 20260323094217_T4Vke NZ0069 2026-03-24T12:07:05.399Z 2026-03-31T12:26:59.970Z
9563909 9563909 20260323093335_1mPDI NZ0069 2026-03-24T12:06:59.118Z 2026-03-31T12:26:58.910Z
9563901 9563901 20260323093334_EC23Y NZ0069 2026-03-24T12:06:58.892Z 2026-03-31T12:26:58.871Z
9563729 9563729 20260323090401_Eu8h0 NZ0069 2026-03-24T12:06:36.675Z 2026-03-31T12:26:49.844Z
9563665 9563665 20260323090012_QHcha NZ0069 2026-03-24T12:06:30.691Z 2026-03-31T12:26:49.012Z
9563644 9563644 20260323085648_ykPTn NZ0069 2026-03-24T12:06:28.031Z 2026-03-31T12:26:48.544Z
9563602 9563602 20260323084942_RUoqQ NZ0069 2026-03-24T12:06:22.857Z 2026-03-31T12:26:47.853Z
9563401 9563401 20260323081226_xPe58 NZ0069 2026-03-24T12:05:55.109Z 2026-03-31T12:26:42.388Z
9563218 9563218 20260323074310_SGHdw NZ0069 2026-03-24T12:05:31.304Z 2026-03-31T12:26:38.574Z
9558664 9558664 20260322172110_VvVhJ NZ0069 2026-03-23T12:06:53.729Z 2026-03-30T12:30:19.882Z
9558325 9558325 20260322162034_wew4a NZ0069 2026-03-23T12:06:38.401Z 2026-03-30T12:30:10.539Z
9558311 9558311 20260322161953_11G8M NZ0069 2026-03-23T12:06:37.961Z 2026-03-30T12:30:10.431Z
9558290 9558290 20260322161627_IDh1x NZ0069 2026-03-23T12:06:36.807Z 2026-03-30T12:30:10.060Z
9558089 9558089 20260322154311_z33Ij NZ0069 2026-03-23T12:06:23.127Z 2026-03-30T12:30:03.999Z
9558028 9558028 20260322153354_i2WGv NZ0069 2026-03-23T12:06:20.225Z 2026-03-30T12:29:54.660Z
9550997 9550997 20260320173739_nNqP2 NZ0069 2026-03-22T12:26:03.716Z 2026-03-28T12:36:38.773Z
9550267 9550267 20260320162600_r5F5q NZ0069 2026-03-22T12:25:05.293Z 2026-03-28T12:36:28.962Z
9549679 9549679 20260320152558_sp3iB NZ0069 2026-03-22T12:24:22.112Z 2026-03-28T12:36:10.293Z
9549069 9549069 20260321171009_vQig3 NZ0069 2026-03-22T12:16:29.634Z 2026-03-29T12:20:38.552Z
9549066 9549066 20260321170134_NoGXb NZ0069 2026-03-22T12:16:29.338Z 2026-03-29T12:20:38.011Z
9549029 9549029 20260321164902_775At NZ0069 2026-03-22T12:16:26.470Z 2026-03-29T12:20:35.654Z
9548985 9548985 20260321162503_boScT NZ0069 2026-03-22T12:16:21.710Z 2026-03-29T12:20:33.557Z
9548964 9548964 20260321161024_DqRIQ NZ0069 2026-03-22T12:16:18.789Z 2026-03-29T12:20:32.430Z
9548958 9548958 20260321160551_kz5n6 NZ0069 2026-03-22T12:16:17.972Z 2026-03-29T12:20:31.940Z

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