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

7,034 rows where station_code = "NZ004E" 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
9265547 9265547 20260127153108_RbYFU NZ004E 2026-01-28T14:10:30.584Z 2026-01-29T14:30:24.602Z
9265542 9265542 20260127153049_u0CtK NZ004E 2026-01-28T14:10:29.861Z 2026-01-29T14:30:24.602Z
9265530 9265530 20260127152456_Q0Fiy NZ004E 2026-01-28T14:10:27.839Z 2026-01-29T14:30:24.599Z
9265416 9265416 20260127151322_HdmZP NZ004E 2026-01-28T14:10:07.887Z 2026-01-29T14:30:24.545Z
9265371 9265371 20260127150841_zSENq NZ004E 2026-01-28T14:09:58.928Z 2026-01-29T14:30:24.536Z
9265356 9265356 20260127150347_nR1xQ NZ004E 2026-01-28T14:09:54.487Z 2026-01-29T14:30:24.532Z
9265323 9265323 20260127145939_RvdEC NZ004E 2026-01-28T14:09:49.746Z 2026-01-29T14:30:24.526Z
9245718 9245718 20260122140107_X3La2 NZ004E 2026-01-23T14:03:06.662Z 2026-01-29T14:49:59.717Z
9245621 9245621 20260122132329_Jrwzb NZ004E 2026-01-23T14:02:39.093Z 2026-01-29T14:49:51.393Z
9233425 9233425 20260120150845_Vg1Fb NZ004E 2026-01-21T14:05:44.219Z 2026-01-29T15:01:15.811Z
9233388 9233388 20260120150505_3WaAY NZ004E 2026-01-21T14:05:37.865Z 2026-01-29T15:01:04.369Z
9233332 9233332 20260120144608_PsTUz NZ004E 2026-01-21T14:05:23.804Z 2026-01-29T15:01:00.896Z
9233246 9233246 20260120135237_s7SB8 NZ004E 2026-01-21T14:04:57.154Z 2026-01-29T15:00:51.474Z
9233150 9233150 20260120132905_xKGEM NZ004E 2026-01-21T14:04:44.542Z 2026-01-29T15:00:47.360Z
9233147 9233147 20260120132900_IV463 NZ004E 2026-01-21T14:04:43.873Z 2026-01-29T15:00:47.214Z
9232686 9232686 20260120121025_j0Idv NZ004E 2026-01-21T14:02:52.755Z 2026-01-29T14:59:57.303Z
9232659 9232659 20260120120522_Khvj3 NZ004E 2026-01-21T14:02:42.990Z 2026-01-29T14:59:55.459Z
9232545 9232545 20260120114631_W5zIB NZ004E 2026-01-21T14:02:19.170Z 2026-01-29T14:59:49.698Z
9232485 9232485 20260120113709_HcIdP NZ004E 2026-01-21T14:02:01.643Z 2026-01-29T14:59:46.143Z
9231846 9231846 20260119100315_zJEB1 NZ004E 2026-01-20T14:34:30.935Z 2026-01-27T15:07:02.169Z
9227195 9227195 20260119150417_SjNrT NZ004E 2026-01-20T14:07:05.683Z 2026-01-28T14:55:56.545Z
9227186 9227186 20260119150007_P860V NZ004E 2026-01-20T14:07:02.787Z 2026-01-28T14:55:56.090Z
9227119 9227119 20260119143903_jjuoK NZ004E 2026-01-20T14:06:40.444Z 2026-01-28T14:55:52.363Z
9227075 9227075 20260119142340_ZTfMa NZ004E 2026-01-20T14:06:28.006Z 2026-01-28T14:55:50.193Z
9226979 9226979 20260119134700_GhO7q NZ004E 2026-01-20T14:06:00.704Z 2026-01-28T14:55:45.449Z
9226939 9226939 20260119133216_mch82 NZ004E 2026-01-20T14:05:42.655Z 2026-01-28T14:55:42.973Z
9226727 9226727 20260119125459_kKVoq NZ004E 2026-01-20T14:04:47.156Z 2026-01-28T14:55:24.139Z
9226349 9226349 20260119114929_sSHkG NZ004E 2026-01-20T14:02:37.172Z 2026-01-28T14:54:56.057Z
9226346 9226346 20260119114911_wvbYg NZ004E 2026-01-20T14:02:36.274Z 2026-01-28T14:54:55.923Z
9226268 9226268 20260119113755_8ouw8 NZ004E 2026-01-20T14:02:08.266Z 2026-01-28T14:54:51.482Z
9225652 9225652 20260118103506_lsR5p NZ004E 2026-01-19T14:29:41.760Z 2026-01-26T15:04:40.985Z
9221498 9221498 20260118154556_ujOQJ NZ004E 2026-01-19T14:08:04.437Z 2026-01-27T15:00:27.965Z
9221407 9221407 20260118153521_R6yEo NZ004E 2026-01-19T14:07:50.492Z 2026-01-27T15:00:19.400Z
9221377 9221377 20260118152926_3Ar6J NZ004E 2026-01-19T14:07:41.278Z 2026-01-27T15:00:08.053Z
9221348 9221348 20260118152542_7pDKU NZ004E 2026-01-19T14:07:34.990Z 2026-01-27T15:00:05.968Z
9221339 9221339 20260118152258_b6wXz NZ004E 2026-01-19T14:07:31.614Z 2026-01-27T15:00:04.594Z
9221327 9221327 20260118152155_zscvD NZ004E 2026-01-19T14:07:29.924Z 2026-01-27T15:00:03.752Z
9221301 9221301 20260118151602_WrZvN NZ004E 2026-01-19T14:07:24.077Z 2026-01-27T15:00:00.846Z
9221258 9221258 20260118151156_YfZS3 NZ004E 2026-01-19T14:07:17.541Z 2026-01-27T14:59:59.289Z
9221238 9221238 20260118150945_3iJxB NZ004E 2026-01-19T14:07:13.867Z 2026-01-27T14:59:58.300Z
9221229 9221229 20260118150703_KspZ1 NZ004E 2026-01-19T14:07:08.616Z 2026-01-27T14:59:58.045Z
9221188 9221188 20260118150045_6uiDC NZ004E 2026-01-19T14:06:59.967Z 2026-01-27T14:59:56.540Z
9220773 9220773 20260118134633_OsyuT NZ004E 2026-01-19T14:05:32.033Z 2026-01-27T14:59:28.025Z
9220718 9220718 20260118133329_CtGvF NZ004E 2026-01-19T14:05:18.565Z 2026-01-27T14:59:25.724Z
9220694 9220694 20260118132913_vbHrx NZ004E 2026-01-19T14:05:15.776Z 2026-01-27T14:59:25.136Z
9220641 9220641 20260118131719_K3v82 NZ004E 2026-01-19T14:05:02.929Z 2026-01-27T14:59:23.718Z
9220523 9220523 20260118130558_2I78f NZ004E 2026-01-19T14:04:33.715Z 2026-01-27T14:59:19.081Z
9220381 9220381 20260118124401_61lqG NZ004E 2026-01-19T14:03:58.604Z 2026-01-27T14:59:12.485Z
9220286 9220286 20260118123027_JBG1x NZ004E 2026-01-19T14:03:35.645Z 2026-01-27T14:58:59.894Z
9220059 9220059 20260118115842_axlQ1 NZ004E 2026-01-19T14:02:24.080Z 2026-01-27T14:58:47.893Z
9219957 9219957 20260118114338_DS6YN NZ004E 2026-01-19T14:01:53.186Z 2026-01-27T14:58:43.763Z
9219931 9219931 20260118114155_KutRT NZ004E 2026-01-19T14:01:46.313Z 2026-01-27T14:58:42.571Z
9219838 9219838 20260118113013_WfSDc NZ004E 2026-01-19T14:01:11.556Z 2026-01-27T14:58:35.857Z
9193136 9193136 20260112134027_KO0Gd NZ004E 2026-01-13T14:30:13.914Z 2026-01-20T15:27:00.450Z
9193076 9193076 20260112133428_bBmh3 NZ004E 2026-01-13T14:30:06.553Z 2026-01-20T15:26:58.348Z
9192958 9192958 20260112131915_nD7gu NZ004E 2026-01-13T14:29:47.224Z 2026-01-20T15:26:42.464Z
9192670 9192670 20260112125315_kTFJF NZ004E 2026-01-13T14:29:01.690Z 2026-01-20T15:26:29.586Z
9192536 9192536 20260112124054_fsJLV NZ004E 2026-01-13T14:28:35.398Z 2026-01-20T15:26:24.829Z
9192506 9192506 20260112123916_OT2t5 NZ004E 2026-01-13T14:28:31.024Z 2026-01-20T15:26:23.825Z
9192470 9192470 20260112123658_Oci5c NZ004E 2026-01-13T14:28:26.693Z 2026-01-20T15:26:22.922Z
9192328 9192328 20260112122352_0Dx2r NZ004E 2026-01-13T14:28:04.799Z 2026-01-20T15:26:18.596Z
9192308 9192308 20260112122142_wLTkP NZ004E 2026-01-13T14:28:02.574Z 2026-01-20T15:26:17.844Z
9192220 9192220 20260112121311_eR8Vi NZ004E 2026-01-13T14:27:45.371Z 2026-01-20T15:26:14.867Z
9192218 9192218 20260112121300_Y4sb3 NZ004E 2026-01-13T14:27:44.816Z 2026-01-20T15:26:14.780Z
9192116 9192116 20260112120638_xnBl0 NZ004E 2026-01-13T14:27:28.056Z 2026-01-20T15:25:59.603Z
9191992 9191992 20260112115817_Xitcx NZ004E 2026-01-13T14:27:08.753Z 2026-01-20T15:25:54.557Z
9191912 9191912 20260112115044_0zbtr NZ004E 2026-01-13T14:26:49.792Z 2026-01-20T15:25:51.180Z
9191541 9191541 20260112111858_4Hxmg NZ004E 2026-01-13T14:25:43.065Z 2026-01-20T15:25:37.934Z
9191353 9191353 20260112110038_i7tWN NZ004E 2026-01-13T14:25:08.175Z 2026-01-20T15:25:21.667Z
9191347 9191347 20260112105935_NjaGl NZ004E 2026-01-13T14:25:06.966Z 2026-01-20T15:25:21.350Z
9191132 9191132 20260112103632_V6dTn NZ004E 2026-01-13T14:24:31.429Z 2026-01-20T15:25:11.521Z
9190700 9190700 20260112094301_XPKN3 NZ004E 2026-01-13T14:23:08.883Z 2026-01-20T15:24:44.449Z
9186563 9186563 20260112145811_63QxV NZ004E 2026-01-13T14:02:33.103Z 2026-01-21T15:02:44.479Z
9186327 9186327 20260112142040_LpQdY NZ004E 2026-01-13T14:01:26.372Z 2026-01-21T15:02:22.016Z
9186321 9186321 20260112141942_gTgya NZ004E 2026-01-13T14:01:24.474Z 2026-01-21T15:02:21.727Z
9186297 9186297 20260112141125_7S1mF NZ004E 2026-01-13T14:01:16.050Z 2026-01-21T15:02:18.348Z
9186256 9186256 20260112140404_UIpY5 NZ004E 2026-01-13T14:01:01.806Z 2026-01-21T15:02:15.356Z
9186240 9186240 20260112140052_p1K3F NZ004E 2026-01-13T14:00:56.153Z 2026-01-21T15:02:14.728Z
9178965 9178965 20260110143644_IOyA3 NZ004E 2026-01-11T14:16:08.409Z 2026-01-18T15:11:28.452Z
9178076 9178076 20260110121020_hdXJW NZ004E 2026-01-11T14:13:55.989Z 2026-01-18T15:10:30.449Z
9177935 9177935 20260110114647_Id1hx NZ004E 2026-01-11T14:13:35.782Z 2026-01-18T15:10:15.363Z
9174164 9174164 20260110154145_kOYq1 NZ004E 2026-01-11T14:01:37.000Z 2026-01-19T15:14:38.260Z
9174130 9174130 20260110153614_s5m1j NZ004E 2026-01-11T14:01:29.258Z 2026-01-19T15:14:36.757Z
9174085 9174085 20260110152737_nOlkd NZ004E 2026-01-11T14:01:17.918Z 2026-01-19T15:14:34.699Z
9174068 9174068 20260110152521_LZin6 NZ004E 2026-01-11T14:01:13.125Z 2026-01-19T15:14:33.815Z
9168521 9168521 20260108111449_507rX NZ004E 2026-01-09T14:11:19.385Z 2026-01-16T15:12:49.375Z
9168344 9168344 20260108104403_ugTf3 NZ004E 2026-01-09T14:10:54.033Z 2026-01-16T15:12:31.734Z
9165123 9165123 20260107150803_REdg9 NZ004E 2026-01-08T14:15:29.558Z 2026-01-13T15:05:30.002Z
9165036 9165036 20260107145458_2vuUt NZ004E 2026-01-08T14:15:11.829Z 2026-01-13T15:05:25.035Z
9165001 9165001 20260107145125_PeX3n NZ004E 2026-01-08T14:15:07.071Z 2026-01-13T15:05:23.291Z
9164972 9164972 20260107144844_CZji0 NZ004E 2026-01-08T14:14:56.004Z 2026-01-13T15:05:22.168Z
9164869 9164869 20260107143341_u70GK NZ004E 2026-01-08T14:14:36.538Z 2026-01-13T15:05:09.214Z
9164857 9164857 20260107143211_oXGvE NZ004E 2026-01-08T14:14:31.371Z 2026-01-13T15:05:08.630Z
9164549 9164549 20260107134310_ZhxEs NZ004E 2026-01-08T14:13:34.209Z 2026-01-13T15:04:51.299Z
9164424 9164424 20260107131121_JnTiT NZ004E 2026-01-08T14:13:06.756Z 2026-01-13T15:04:34.124Z
9164234 9164234 20260107123807_K3bWh NZ004E 2026-01-08T14:12:26.541Z 2026-01-13T15:04:21.852Z
9161648 9161648 20260106151639_L2SKi NZ004E 2026-01-07T14:17:35.659Z 2026-01-13T15:11:10.431Z
9161576 9161576 20260106143540_3afel NZ004E 2026-01-07T14:17:11.230Z 2026-01-13T15:10:57.832Z
9161519 9161519 20260106135527_z6bsJ NZ004E 2026-01-07T14:16:56.287Z 2026-01-13T15:10:52.545Z
9160940 9160940 20260106095729_s2lSi NZ004E 2026-01-07T14:14:26.563Z 2026-01-13T15:10:01.853Z

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