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

8,296 rows where station_code = "NZ003T" 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
9270613 9270613 20260128161136_FokLJ NZ003T 2026-01-29T14:13:01.264Z 2026-01-29T14:13:01.264Z
9270557 9270557 20260128160044_dja87 NZ003T 2026-01-29T14:12:45.380Z 2026-01-29T14:12:45.380Z
9270553 9270553 20260128160013_kQeZa NZ003T 2026-01-29T14:12:44.726Z 2026-01-29T14:12:44.726Z
9270503 9270503 20260128155652_L2ia3 NZ003T 2026-01-29T14:12:27.512Z 2026-01-29T14:12:27.512Z
9270500 9270500 20260128155625_jB3oL NZ003T 2026-01-29T14:12:26.824Z 2026-01-29T14:12:26.824Z
9270212 9270212 20260128151451_E2TrT NZ003T 2026-01-29T14:11:19.875Z 2026-01-29T14:11:19.875Z
9269982 9269982 20260128144046_Nifj7 NZ003T 2026-01-29T14:10:26.415Z 2026-01-29T14:10:26.415Z
9269655 9269655 20260128135113_OedGd NZ003T 2026-01-29T14:08:58.707Z 2026-01-29T14:08:58.707Z
9269609 9269609 20260128134446_Esoun NZ003T 2026-01-29T14:08:48.607Z 2026-01-29T14:08:48.607Z
9269466 9269466 20260128132125_RSkDW NZ003T 2026-01-29T14:08:06.517Z 2026-01-29T14:08:06.517Z
9269352 9269352 20260128130403_wXb5d NZ003T 2026-01-29T14:07:31.573Z 2026-01-29T14:07:31.573Z
9269340 9269340 20260128130321_RQd97 NZ003T 2026-01-29T14:07:29.785Z 2026-01-29T14:07:29.785Z
9269171 9269171 20260128124051_OVAqF NZ003T 2026-01-29T14:06:52.262Z 2026-01-29T14:06:52.262Z
9269133 9269133 20260128123639_BS7ro NZ003T 2026-01-29T14:06:39.215Z 2026-01-29T14:06:39.215Z
9269125 9269125 20260128123339_7z2N3 NZ003T 2026-01-29T14:06:37.377Z 2026-01-29T14:06:37.377Z
9269111 9269111 20260128123111_85Vqu NZ003T 2026-01-29T14:06:33.200Z 2026-01-29T14:06:33.200Z
9269086 9269086 20260128122129_nvF6V NZ003T 2026-01-29T14:06:26.367Z 2026-01-29T14:06:26.367Z
9268638 9268638 20260128105656_jGQcw NZ003T 2026-01-29T14:04:08.485Z 2026-01-29T14:04:08.485Z
9265726 9265726 20260127155337_IfKU8 NZ003T 2026-01-28T14:11:09.322Z 2026-01-29T14:30:24.662Z
9265665 9265665 20260127154615_tYh5o NZ003T 2026-01-28T14:10:54.633Z 2026-01-29T14:30:24.649Z
9265641 9265641 20260127154417_E2tmH NZ003T 2026-01-28T14:10:49.405Z 2026-01-29T14:30:24.639Z
9265380 9265380 20260127150901_sUNqn NZ003T 2026-01-28T14:10:00.396Z 2026-01-29T14:30:24.538Z
9265261 9265261 20260127145047_Txpiw NZ003T 2026-01-28T14:09:41.508Z 2026-01-29T14:30:24.516Z
9265237 9265237 20260127144508_MtxGy NZ003T 2026-01-28T14:09:35.991Z 2026-01-29T14:30:24.510Z
9265180 9265180 20260127143211_RAO3i NZ003T 2026-01-28T14:09:21.160Z 2026-01-29T14:30:24.494Z
9265073 9265073 20260127141229_L2JrK NZ003T 2026-01-28T14:08:56.273Z 2026-01-29T14:30:24.431Z
9264896 9264896 20260127133025_ubJ1g NZ003T 2026-01-28T14:08:10.776Z 2026-01-29T14:30:24.322Z
9264871 9264871 20260127132646_m23Dn NZ003T 2026-01-28T14:08:02.955Z 2026-01-29T14:30:24.317Z
9264866 9264866 20260127132630_oTfWv NZ003T 2026-01-28T14:08:02.160Z 2026-01-29T14:30:24.316Z
9264714 9264714 20260127130108_8MRZu NZ003T 2026-01-28T14:07:19.830Z 2026-01-29T14:30:24.261Z
9264706 9264706 20260127130012_2eXHN NZ003T 2026-01-28T14:07:17.432Z 2026-01-29T14:30:24.259Z
9264696 9264696 20260127125753_opHYR NZ003T 2026-01-28T14:07:12.355Z 2026-01-29T14:30:24.256Z
9264504 9264504 20260127123930_o3LhO NZ003T 2026-01-28T14:06:25.879Z 2026-01-29T14:30:24.189Z
9264426 9264426 20260127122028_oUUyb NZ003T 2026-01-28T14:06:04.872Z 2026-01-29T14:30:21.702Z
9264412 9264412 20260127121640_ZPimU NZ003T 2026-01-28T14:05:58.156Z 2026-01-29T14:30:21.199Z
9264246 9264246 20260127114821_t3gAp NZ003T 2026-01-28T14:05:09.139Z 2026-01-29T14:30:20.567Z
9264210 9264210 20260127113923_6fYC8 NZ003T 2026-01-28T14:04:58.183Z 2026-01-29T14:30:20.550Z
9263664 9263664 20260127093800_nh3VY NZ003T 2026-01-28T14:02:04.794Z 2026-01-29T14:30:17.619Z
9250420 9250420 20260123143149_SWGGw NZ003T 2026-01-24T14:02:51.296Z 2026-01-29T14:45:32.585Z
9250397 9250397 20260123141820_sjboN NZ003T 2026-01-24T14:02:41.197Z 2026-01-29T14:45:30.624Z
9250380 9250380 20260123140426_cCBmB NZ003T 2026-01-24T14:02:35.797Z 2026-01-29T14:45:28.275Z
9250365 9250365 20260123135622_NhReq NZ003T 2026-01-24T14:02:31.125Z 2026-01-29T14:45:27.041Z
9238956 9238956 20260118122315_y8iR3 NZ003T 2026-01-21T14:33:55.336Z 2026-01-27T14:58:56.161Z
9238954 9238954 20260118121417_HTDf2 NZ003T 2026-01-21T14:33:48.900Z 2026-01-27T14:58:52.841Z
9173296 9173296 20260109133543_C0MYo NZ003T 2026-01-10T14:17:00.597Z 2026-01-17T15:26:37.229Z
9173258 9173258 20260109132829_yVeRm NZ003T 2026-01-10T14:16:53.079Z 2026-01-17T15:26:25.111Z
9172818 9172818 20260109120254_n8lgf NZ003T 2026-01-10T14:14:56.276Z 2026-01-17T15:26:03.583Z
9169667 9169667 20260108151944_QDgcS NZ003T 2026-01-09T14:14:16.893Z 2026-01-16T15:14:23.958Z
9169608 9169608 20260108150845_YXRJN NZ003T 2026-01-09T14:14:05.965Z 2026-01-16T15:14:20.164Z
9169589 9169589 20260108150412_tk22Y NZ003T 2026-01-09T14:14:03.035Z 2026-01-16T15:14:18.669Z
9169463 9169463 20260108143807_Glv3O NZ003T 2026-01-09T14:13:37.767Z 2026-01-16T15:14:00.317Z
9169198 9169198 20260108134127_830Ay NZ003T 2026-01-09T14:12:58.475Z 2026-01-16T15:13:35.182Z
9169147 9169147 20260108132801_aEeFO NZ003T 2026-01-09T14:12:50.943Z 2026-01-16T15:13:32.821Z
9169138 9169138 20260108132621_D5PMq NZ003T 2026-01-09T14:12:49.495Z 2026-01-16T15:13:32.197Z
9169081 9169081 20260108131413_8crKk NZ003T 2026-01-09T14:12:42.909Z 2026-01-16T15:13:28.245Z
9168583 9168583 20260108112715_ptLH6 NZ003T 2026-01-09T14:11:26.804Z 2026-01-16T15:12:52.129Z
9168157 9168157 20260108100553_2hI8U NZ003T 2026-01-09T14:10:28.741Z 2026-01-16T15:12:21.395Z
9168128 9168128 20260108100015_yQQyN NZ003T 2026-01-09T14:10:23.159Z 2026-01-16T15:12:20.009Z
9165317 9165317 20260107152755_EaZM4 NZ003T 2026-01-08T14:16:05.011Z 2026-01-13T15:05:39.837Z
9165240 9165240 20260107152126_bEm7J NZ003T 2026-01-08T14:15:45.219Z 2026-01-13T15:05:36.452Z
9165108 9165108 20260107150733_rTHQK NZ003T 2026-01-08T14:15:25.863Z 2026-01-13T15:05:29.063Z
9164851 9164851 20260107143143_9jnEH NZ003T 2026-01-08T14:14:30.116Z 2026-01-13T15:05:08.068Z
9164838 9164838 20260107143115_r3snj NZ003T 2026-01-08T14:14:29.066Z 2026-01-13T15:05:07.731Z
9164287 9164287 20260107124424_Oeh4k NZ003T 2026-01-08T14:12:34.153Z 2026-01-13T15:04:24.422Z
9164219 9164219 20260107123542_BxIez NZ003T 2026-01-08T14:12:23.386Z 2026-01-13T15:04:20.871Z
9164171 9164171 20260107122417_IpMDU NZ003T 2026-01-08T14:12:11.979Z 2026-01-13T15:04:10.764Z
9164085 9164085 20260107120317_v68Rf NZ003T 2026-01-08T14:11:53.106Z 2026-01-13T15:04:04.254Z
9164062 9164062 20260107115828_jFap0 NZ003T 2026-01-08T14:11:48.381Z 2026-01-13T15:04:02.995Z
9163997 9163997 20260107113834_FqUxx NZ003T 2026-01-08T14:11:26.232Z 2026-01-13T15:03:59.036Z
9163884 9163884 20260107110317_QTgAM NZ003T 2026-01-08T14:10:53.441Z 2026-01-13T15:03:44.537Z
9163632 9163632 20260107094244_HYOdj NZ003T 2026-01-08T14:09:57.501Z 2026-01-13T15:03:30.408Z
9157040 9157040 20260104144740_Y1a28 NZ003T 2026-01-06T14:41:29.654Z 2026-01-12T15:12:48.211Z
9156944 9156944 20260104141716_P3YZZ NZ003T 2026-01-06T14:41:17.089Z 2026-01-12T15:12:44.358Z
9156933 9156933 20260104141331_XtBHd NZ003T 2026-01-06T14:41:16.393Z 2026-01-12T15:12:44.049Z
9156896 9156896 20260104135549_iiuu2 NZ003T 2026-01-06T14:41:10.465Z 2026-01-12T15:12:41.854Z
9156882 9156882 20260104135447_uxF0V NZ003T 2026-01-06T14:41:07.908Z 2026-01-12T15:12:41.138Z
9156799 9156799 20260104131810_W3Pv2 NZ003T 2026-01-06T14:40:50.434Z 2026-01-12T15:12:37.750Z
9156576 9156576 20260104115158_qOT1n NZ003T 2026-01-06T14:40:03.247Z 2026-01-12T15:12:16.446Z
9156560 9156560 20260104114316_SXKrv NZ003T 2026-01-06T14:40:00.823Z 2026-01-12T15:12:15.641Z
9156519 9156519 20260104112318_URSoE NZ003T 2026-01-06T14:39:48.888Z 2026-01-12T15:12:13.900Z
9156489 9156489 20260104111438_SAMDc NZ003T 2026-01-06T14:39:43.967Z 2026-01-12T15:12:12.503Z
9156421 9156421 20260104104321_NTJZV NZ003T 2026-01-06T14:39:34.390Z 2026-01-12T15:12:09.529Z
9156363 9156363 20260104095804_6TWpB NZ003T 2026-01-06T14:39:21.189Z 2026-01-12T15:12:06.704Z
9156337 9156337 20260104094616_RcGg7 NZ003T 2026-01-06T14:39:16.732Z 2026-01-12T15:12:05.645Z
9156275 9156275 20260104091009_20M4v NZ003T 2026-01-06T14:39:07.842Z 2026-01-12T15:12:03.238Z
9153060 9153060 20260105155414_Na9kK NZ003T 2026-01-06T14:19:27.471Z 2026-01-13T15:16:56.802Z
9153046 9153046 20260105154306_UBZZL NZ003T 2026-01-06T14:19:25.385Z 2026-01-13T15:16:56.219Z
9152990 9152990 20260105150918_XSUkN NZ003T 2026-01-06T14:19:10.513Z 2026-01-13T15:16:43.254Z
9152962 9152962 20260105145115_abep3 NZ003T 2026-01-06T14:19:05.257Z 2026-01-13T15:16:42.021Z
9152840 9152840 20260105135349_ztWC3 NZ003T 2026-01-06T14:18:40.829Z 2026-01-13T15:16:32.779Z
9152824 9152824 20260105133720_khcWo NZ003T 2026-01-06T14:18:36.488Z 2026-01-13T15:16:30.632Z
9152786 9152786 20260105132531_B10Rs NZ003T 2026-01-06T14:18:29.492Z 2026-01-13T15:16:28.960Z
9152781 9152781 20260105132336_d9RC8 NZ003T 2026-01-06T14:18:29.139Z 2026-01-13T15:16:28.810Z
9152629 9152629 20260105123721_GR5DH NZ003T 2026-01-06T14:17:54.791Z 2026-01-13T15:16:08.540Z
9152251 9152251 20260105102302_2PCaU NZ003T 2026-01-06T14:16:25.391Z 2026-01-13T15:15:39.195Z
9152195 9152195 20260105095948_YUQiw NZ003T 2026-01-06T14:16:11.301Z 2026-01-13T15:15:35.414Z
9152089 9152089 20260105092028_ZS2B5 NZ003T 2026-01-06T14:15:44.765Z 2026-01-13T15:15:29.621Z
9133159 9133159 20260103122509_iWsLB NZ003T 2026-01-04T14:19:59.910Z 2026-01-10T15:02:33.295Z
9133135 9133135 20260103122221_z91WM NZ003T 2026-01-04T14:19:55.445Z 2026-01-10T15:02:30.515Z
9118282 9118282 20251231142103_NT8d7 NZ003T 2026-01-01T14:34:53.549Z 2026-01-08T15:14:19.575Z

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