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,454 rows where station_code = "NZ0010" 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
9233409 9233409 20260120150705_05gMm NZ0010 2026-01-21T14:05:42.378Z 2026-01-29T15:01:11.898Z
9233394 9233394 20260120150532_9fu79 NZ0010 2026-01-21T14:05:40.433Z 2026-01-29T15:01:04.668Z
9233010 9233010 20260120130527_qUxmB NZ0010 2026-01-21T14:04:13.385Z 2026-01-29T15:00:35.745Z
9232976 9232976 20260120130048_2OL0J NZ0010 2026-01-21T14:04:03.780Z 2026-01-29T15:00:33.966Z
9232901 9232901 20260120124742_Aop6F NZ0010 2026-01-21T14:03:42.877Z 2026-01-29T15:00:23.808Z
9232513 9232513 20260120114116_U8sXM NZ0010 2026-01-21T14:02:06.726Z 2026-01-29T14:59:48.123Z
9227375 9227375 20260119155801_NUdt8 NZ0010 2026-01-20T14:07:59.565Z 2026-01-28T14:56:17.470Z
9227357 9227357 20260119155607_TnfXr NZ0010 2026-01-20T14:07:56.735Z 2026-01-28T14:56:16.448Z
9227238 9227238 20260119151615_ubGUg NZ0010 2026-01-20T14:07:18.234Z 2026-01-28T14:56:00.581Z
9227217 9227217 20260119151354_9JM8c NZ0010 2026-01-20T14:07:12.355Z 2026-01-28T14:55:59.662Z
9227213 9227213 20260119151255_da2S4 NZ0010 2026-01-20T14:07:10.604Z 2026-01-28T14:55:59.128Z
9225481 9225481 20260118095619_5qygP NZ0010 2026-01-19T14:29:05.517Z 2026-01-26T15:04:36.024Z
9225450 9225450 20260118094724_rhjj0 NZ0010 2026-01-19T14:28:59.994Z 2026-01-26T15:04:34.771Z
9221534 9221534 20260118155142_J1Aw1 NZ0010 2026-01-19T14:08:13.353Z 2026-01-27T15:00:30.223Z
9221421 9221421 20260118153813_K3WLU NZ0010 2026-01-19T14:07:52.545Z 2026-01-27T15:00:21.373Z
9221396 9221396 20260118153356_lBb7i NZ0010 2026-01-19T14:07:48.185Z 2026-01-27T15:00:14.903Z
9221355 9221355 20260118152656_uP1wX NZ0010 2026-01-19T14:07:38.869Z 2026-01-27T15:00:07.325Z
9221250 9221250 20260118151121_0suAv NZ0010 2026-01-19T14:07:16.296Z 2026-01-27T14:59:59.036Z
9221194 9221194 20260118150134_0UFPy NZ0010 2026-01-19T14:07:02.666Z 2026-01-27T14:59:56.798Z
9221182 9221182 20260118150031_vgRpo NZ0010 2026-01-19T14:06:59.412Z 2026-01-27T14:59:56.417Z
9221177 9221177 20260118145751_rnNYM NZ0010 2026-01-19T14:06:57.512Z 2026-01-27T14:59:56.128Z
9221175 9221175 20260118145747_13lHV NZ0010 2026-01-19T14:06:56.759Z 2026-01-27T14:59:55.959Z
9221100 9221100 20260118145011_RfLKc NZ0010 2026-01-19T14:06:47.974Z 2026-01-27T14:59:53.802Z
9220964 9220964 20260118143034_fbi72 NZ0010 2026-01-19T14:06:18.721Z 2026-01-27T14:59:48.397Z
9220902 9220902 20260118141721_ZDA0i NZ0010 2026-01-19T14:06:03.705Z 2026-01-27T14:59:34.505Z
9220823 9220823 20260118135842_IcXiB NZ0010 2026-01-19T14:05:46.773Z 2026-01-27T14:59:31.588Z
9220801 9220801 20260118135416_fTSuJ NZ0010 2026-01-19T14:05:42.758Z 2026-01-27T14:59:30.790Z
9220745 9220745 20260118133933_j0kZk NZ0010 2026-01-19T14:05:24.376Z 2026-01-27T14:59:26.741Z
9220712 9220712 20260118133323_5wGhP NZ0010 2026-01-19T14:05:17.965Z 2026-01-27T14:59:25.615Z
9187043 9187043 20260111145102_mt3bv NZ0010 2026-01-13T14:05:06.611Z 2026-01-20T15:19:55.043Z
9186852 9186852 20260112155148_k8rVY NZ0010 2026-01-13T14:03:44.906Z 2026-01-21T15:03:04.558Z
9186723 9186723 20260112152747_3vlo2 NZ0010 2026-01-13T14:03:15.283Z 2026-01-21T15:02:55.756Z
9186668 9186668 20260112151701_g9xNN NZ0010 2026-01-13T14:03:02.459Z 2026-01-21T15:02:51.133Z
9186656 9186656 20260112151507_j7siK NZ0010 2026-01-13T14:02:58.281Z 2026-01-21T15:02:49.785Z
9186649 9186649 20260112151439_GqIqQ NZ0010 2026-01-13T14:02:52.093Z 2026-01-21T15:02:49.222Z
9186628 9186628 20260112151335_FmbWF NZ0010 2026-01-13T14:02:47.164Z 2026-01-21T15:02:48.722Z
9186550 9186550 20260112145715_JszZo NZ0010 2026-01-13T14:02:31.474Z 2026-01-21T15:02:44.400Z
9186504 9186504 20260112144900_5NVs0 NZ0010 2026-01-13T14:02:18.507Z 2026-01-21T15:02:38.989Z
9186497 9186497 20260112144521_jyzBc NZ0010 2026-01-13T14:02:16.779Z 2026-01-21T15:02:37.696Z
9185300 9185300 20260111135249_LS6qu NZ0010 2026-01-12T14:22:59.850Z 2026-01-19T15:22:05.191Z
9185287 9185287 20260111134850_qIE14 NZ0010 2026-01-12T14:22:57.894Z 2026-01-19T15:22:03.665Z
9185275 9185275 20260111134650_A4cSg NZ0010 2026-01-12T14:22:56.594Z 2026-01-19T15:22:02.320Z
9185201 9185201 20260111132550_K9GFu NZ0010 2026-01-12T14:22:43.975Z 2026-01-19T15:21:57.272Z
9185102 9185102 20260111130758_ElNAo NZ0010 2026-01-12T14:22:28.758Z 2026-01-19T15:21:49.495Z
9185025 9185025 20260111125737_bB6AW NZ0010 2026-01-12T14:22:12.949Z 2026-01-19T15:21:46.042Z
9183720 9183720 20260111100547_l4AT2 NZ0010 2026-01-12T14:18:39.311Z 2026-01-19T15:20:09.520Z
9179225 9179225 20260111145515_fLN05 NZ0010 2026-01-12T14:00:45.405Z 2026-01-20T15:19:56.045Z
9178832 9178832 20260110141706_vm8gN NZ0010 2026-01-11T14:15:48.743Z 2026-01-18T15:11:19.237Z
9178816 9178816 20260110141451_AhDOy NZ0010 2026-01-11T14:15:47.372Z 2026-01-18T15:11:18.523Z
9178809 9178809 20260110141255_2k5EI NZ0010 2026-01-11T14:15:46.027Z 2026-01-18T15:11:17.913Z
9178695 9178695 20260110134619_P0imH NZ0010 2026-01-11T14:15:33.798Z 2026-01-18T15:11:11.819Z
9177942 9177942 20260110114751_W37mz NZ0010 2026-01-11T14:13:37.012Z 2026-01-18T15:10:15.761Z
9174194 9174194 20260110155113_wIDop NZ0010 2026-01-11T14:01:44.733Z 2026-01-19T15:14:41.352Z
9174167 9174167 20260110154603_rjlWW NZ0010 2026-01-11T14:01:38.085Z 2026-01-19T15:14:39.195Z
9173985 9173985 20260110151415_AqqKj NZ0010 2026-01-11T14:00:55.450Z 2026-01-19T15:14:30.619Z
9173921 9173921 20260110150230_t1Kbe NZ0010 2026-01-11T14:00:44.218Z 2026-01-19T15:14:27.475Z
9173830 9173830 20260110144917_2ehmP NZ0010 2026-01-11T14:00:24.449Z 2026-01-19T15:14:12.638Z
9168222 9168222 20260108101944_mjuw4 NZ0010 2026-01-09T14:10:37.648Z 2026-01-16T15:12:24.086Z
9164484 9164484 20260107132845_Sy0hV NZ0010 2026-01-08T14:13:23.560Z 2026-01-13T15:04:40.141Z
9164404 9164404 20260107130952_fG8So NZ0010 2026-01-08T14:13:03.663Z 2026-01-13T15:04:33.471Z
9164322 9164322 20260107124819_jmtkZ NZ0010 2026-01-08T14:12:45.008Z 2026-01-13T15:04:26.702Z
9164236 9164236 20260107123906_R1BfK NZ0010 2026-01-08T14:12:27.175Z 2026-01-13T15:04:22.123Z
9164105 9164105 20260107120823_mUdTO NZ0010 2026-01-08T14:11:56.852Z 2026-01-13T15:04:06.096Z
9164078 9164078 20260107120214_xPoDt NZ0010 2026-01-08T14:11:51.724Z 2026-01-13T15:04:03.749Z
9164054 9164054 20260107115410_t2X2b NZ0010 2026-01-08T14:11:43.007Z 2026-01-13T15:04:02.557Z
9133673 9133673 20260103143246_56Oxj NZ0010 2026-01-04T14:22:05.128Z 2026-01-10T15:03:25.426Z
9096808 9096808 20251227150820_YaGoF NZ0010 2025-12-30T15:07:57.929Z 2026-01-04T15:33:25.267Z
9096784 9096784 20251227150711_In5kb NZ0010 2025-12-30T15:07:57.084Z 2026-01-04T15:33:23.392Z
9096636 9096636 20251227145756_BiBG2 NZ0010 2025-12-30T15:07:51.481Z 2026-01-04T15:33:19.522Z
9096390 9096390 20251227144755_QVjM4 NZ0010 2025-12-30T15:07:25.783Z 2026-01-04T15:33:13.116Z
9096003 9096003 20251227142421_x1fOd NZ0010 2025-12-30T15:07:09.786Z 2026-01-04T15:32:49.790Z
9095963 9095963 20251227142100_3CWOU NZ0010 2025-12-30T15:07:08.163Z 2026-01-04T15:32:48.348Z
9095482 9095482 20251227135213_45iIB NZ0010 2025-12-30T15:06:34.515Z 2026-01-04T15:32:35.707Z
9095208 9095208 20251227133636_i2h5p NZ0010 2025-12-30T15:06:24.825Z 2025-12-30T15:06:24.825Z
9094944 9094944 20251227131726_f88Pi NZ0010 2025-12-30T15:05:58.583Z 2026-01-04T15:32:10.064Z
9094619 9094619 20251227124257_Spk6o NZ0010 2025-12-30T15:05:42.163Z 2026-01-04T15:31:59.235Z
9094371 9094371 20251227121910_jVaLI NZ0010 2025-12-30T15:05:13.000Z 2026-01-04T15:31:40.250Z
9094336 9094336 20251227121134_TOZNy NZ0010 2025-12-30T15:05:10.950Z 2025-12-30T15:05:10.950Z
9094286 9094286 20251227120706_err4w NZ0010 2025-12-30T15:05:08.848Z 2026-01-04T15:31:38.771Z
9093665 9093665 20251227102104_6Y3Y9 NZ0010 2025-12-30T15:04:14.068Z 2026-01-04T15:31:05.052Z
9093643 9093643 20251227101854_I2opB NZ0010 2025-12-30T15:04:13.282Z 2026-01-04T15:31:04.676Z
9093632 9093632 20251227101600_jTNDQ NZ0010 2025-12-30T15:04:12.995Z 2026-01-04T15:31:04.500Z
9093541 9093541 20251227094910_Pkf42 NZ0010 2025-12-30T15:03:53.030Z 2025-12-30T15:03:53.030Z
9090327 9090327 20251228145701_3ocNI NZ0010 2025-12-30T14:50:01.329Z 2026-01-05T15:13:08.019Z
9090320 9090320 20251228145540_lXbL2 NZ0010 2025-12-30T14:50:00.807Z 2026-01-05T15:13:07.856Z
9090312 9090312 20251228145511_tSXAp NZ0010 2025-12-30T14:50:00.421Z 2026-01-05T15:13:07.786Z
9090299 9090299 20251228145148_3IPBe NZ0010 2025-12-30T14:49:59.061Z 2026-01-05T15:13:07.459Z
9090259 9090259 20251228144937_lUYzz NZ0010 2025-12-30T14:49:55.964Z 2026-01-05T15:13:04.851Z
9040871 9040871 20251224141843_13I7d NZ0010 2025-12-28T14:43:03.660Z 2026-01-01T15:56:10.860Z
9040777 9040777 20251224141138_n323i NZ0010 2025-12-28T14:42:55.021Z 2026-01-01T15:55:53.454Z
9040743 9040743 20251224140725_T13nl NZ0010 2025-12-28T14:42:38.959Z 2026-01-01T15:55:53.217Z
9040645 9040645 20251224140317_Y5K4O NZ0010 2025-12-28T14:42:27.196Z 2026-01-01T15:55:52.413Z
9039693 9039693 20251224125343_nVmhr NZ0010 2025-12-28T14:41:23.755Z 2026-01-01T15:55:41.149Z
9039564 9039564 20251224124439_oLA8d NZ0010 2025-12-28T14:41:17.954Z 2025-12-29T15:06:03.929Z
9039526 9039526 20251224124140_CnX6F NZ0010 2025-12-28T14:41:04.398Z 2026-01-01T15:55:39.448Z
9039467 9039467 20251224123231_QPoq1 NZ0010 2025-12-28T14:40:57.419Z 2026-01-01T15:55:38.687Z
9039463 9039463 20251224123212_GQ62V NZ0010 2025-12-28T14:40:56.730Z 2026-01-01T15:55:38.634Z
9039454 9039454 20251224123201_Q1EVK NZ0010 2025-12-28T14:40:55.556Z 2026-01-01T15:55:38.569Z
9039325 9039325 20251224122131_r4yfY NZ0010 2025-12-28T14:40:45.150Z 2026-01-01T15:55:36.745Z
9039238 9039238 20251224121049_rETI3 NZ0010 2025-12-28T14:40:39.461Z 2026-01-01T15:55:35.855Z

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