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 = "NZ0003" 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
9265581 9265581 20260127153611_lNANC NZ0003 2026-01-28T14:10:37.945Z 2026-01-29T14:30:24.617Z
9265568 9265568 20260127153528_VrpvT NZ0003 2026-01-28T14:10:36.892Z 2026-01-29T14:30:24.615Z
9265331 9265331 20260127150222_iuENo NZ0003 2026-01-28T14:09:50.998Z 2026-01-29T14:30:24.528Z
9265313 9265313 20260127145919_aJhxp NZ0003 2026-01-28T14:09:48.403Z 2026-01-29T14:30:24.525Z
9264067 9264067 20260127110817_1LwRD NZ0003 2026-01-28T14:04:13.416Z 2026-01-29T14:30:20.036Z
9264065 9264065 20260127110800_KZZuU NZ0003 2026-01-28T14:04:12.699Z 2026-01-29T14:30:20.035Z
9264004 9264004 20260127105202_76qmf NZ0003 2026-01-28T14:03:53.614Z 2026-01-29T14:30:19.995Z
9263974 9263974 20260127104823_JqZd8 NZ0003 2026-01-28T14:03:43.531Z 2026-01-29T14:30:19.979Z
9263961 9263961 20260127104802_eT4n6 NZ0003 2026-01-28T14:03:42.070Z 2026-01-29T14:30:19.977Z
9263953 9263953 20260127104800_mhf22 NZ0003 2026-01-28T14:03:41.162Z 2026-01-29T14:30:19.976Z
9233463 9233463 20260120154236_tEiwI NZ0003 2026-01-21T14:05:52.050Z 2026-01-29T15:01:20.664Z
9233451 9233451 20260120153453_wj4yt NZ0003 2026-01-21T14:05:49.497Z 2026-01-29T15:01:19.688Z
9233443 9233443 20260120152423_svazu NZ0003 2026-01-21T14:05:48.049Z 2026-01-29T15:01:18.822Z
9233426 9233426 20260120150917_Q4bY3 NZ0003 2026-01-21T14:05:44.731Z 2026-01-29T15:01:16.024Z
9233415 9233415 20260120150814_ZEpyO NZ0003 2026-01-21T14:05:43.657Z 2026-01-29T15:01:14.258Z
9233399 9233399 20260120150617_q5tKr NZ0003 2026-01-21T14:05:41.414Z 2026-01-29T15:01:08.195Z
9233373 9233373 20260120150405_pKCdC NZ0003 2026-01-21T14:05:33.104Z 2026-01-29T15:01:03.734Z
9233345 9233345 20260120144948_ieMyv NZ0003 2026-01-21T14:05:25.762Z 2026-01-29T15:01:01.653Z
9233337 9233337 20260120144941_WwEQm NZ0003 2026-01-21T14:05:25.331Z 2026-01-29T15:01:01.551Z
9233304 9233304 20260120142917_S4q3f NZ0003 2026-01-21T14:05:18.496Z 2026-01-29T15:00:56.173Z
9233291 9233291 20260120142608_s1PEI NZ0003 2026-01-21T14:05:16.084Z 2026-01-29T15:00:55.623Z
9233135 9233135 20260120132814_inLIv NZ0003 2026-01-21T14:04:42.559Z 2026-01-29T15:00:46.990Z
9233095 9233095 20260120131955_2mPbU NZ0003 2026-01-21T14:04:30.722Z 2026-01-29T15:00:45.185Z
9233093 9233093 20260120131954_GpSN5 NZ0003 2026-01-21T14:04:30.081Z 2026-01-29T15:00:45.096Z
9233055 9233055 20260120131708_12JMl NZ0003 2026-01-21T14:04:21.677Z 2026-01-29T15:00:43.769Z
9233046 9233046 20260120131417_bJv3O NZ0003 2026-01-21T14:04:19.939Z 2026-01-29T15:00:43.126Z
9233014 9233014 20260120130622_9lms3 NZ0003 2026-01-21T14:04:14.491Z 2026-01-29T15:00:35.986Z
9232963 9232963 20260120125920_qxuFu NZ0003 2026-01-21T14:03:58.486Z 2026-01-29T15:00:32.628Z
9232926 9232926 20260120125208_GMvUb NZ0003 2026-01-21T14:03:49.283Z 2026-01-29T15:00:27.315Z
9232879 9232879 20260120124537_Rceom NZ0003 2026-01-21T14:03:38.779Z 2026-01-29T15:00:22.317Z
9232811 9232811 20260120123156_a51Gp NZ0003 2026-01-21T14:03:20.122Z 2026-01-29T15:00:16.475Z
9232570 9232570 20260120115055_DbScp NZ0003 2026-01-21T14:02:25.636Z 2026-01-29T14:59:51.603Z
9232553 9232553 20260120114821_ukgAx NZ0003 2026-01-21T14:02:21.433Z 2026-01-29T14:59:50.466Z
9231992 9231992 20260119103636_BxDww NZ0003 2026-01-20T14:35:02.839Z 2026-01-27T15:07:10.129Z
9231942 9231942 20260119101908_63Wus NZ0003 2026-01-20T14:34:51.828Z 2026-01-27T15:07:06.955Z
9227352 9227352 20260119155555_33WwV NZ0003 2026-01-20T14:07:55.187Z 2026-01-28T14:56:16.314Z
9227232 9227232 20260119151614_8A5O4 NZ0003 2026-01-20T14:07:17.478Z 2026-01-28T14:56:00.457Z
9227223 9227223 20260119151433_j68Bq NZ0003 2026-01-20T14:07:13.998Z 2026-01-28T14:56:00.064Z
9227200 9227200 20260119150803_PGbCS NZ0003 2026-01-20T14:07:07.576Z 2026-01-28T14:55:57.222Z
9227189 9227189 20260119150159_LLcyh NZ0003 2026-01-20T14:07:04.152Z 2026-01-28T14:55:56.326Z
9227132 9227132 20260119144436_1t3v9 NZ0003 2026-01-20T14:06:43.658Z 2026-01-28T14:55:53.328Z
9227126 9227126 20260119144213_ZsSVa NZ0003 2026-01-20T14:06:42.268Z 2026-01-28T14:55:52.955Z
9227099 9227099 20260119143635_HvOQC NZ0003 2026-01-20T14:06:36.261Z 2026-01-28T14:55:51.697Z
9227094 9227094 20260119143609_saPFA NZ0003 2026-01-20T14:06:35.620Z 2026-01-28T14:55:51.570Z
9227040 9227040 20260119141219_9H7fJ NZ0003 2026-01-20T14:06:18.860Z 2026-01-28T14:55:48.726Z
9226922 9226922 20260119133048_LmqBm NZ0003 2026-01-20T14:05:39.389Z 2026-01-28T14:55:37.679Z
9226892 9226892 20260119132729_iYDBn NZ0003 2026-01-20T14:05:34.734Z 2026-01-28T14:55:34.160Z
9226870 9226870 20260119132123_BysQX NZ0003 2026-01-20T14:05:28.808Z 2026-01-28T14:55:33.180Z
9226831 9226831 20260119131505_ZZgg3 NZ0003 2026-01-20T14:05:15.093Z 2026-01-28T14:55:31.099Z
9226821 9226821 20260119131230_gUela NZ0003 2026-01-20T14:05:10.374Z 2026-01-28T14:55:30.242Z
9226817 9226817 20260119131138_3G9eq NZ0003 2026-01-20T14:05:09.133Z 2026-01-28T14:55:29.994Z
9226783 9226783 20260119130401_fjIeM NZ0003 2026-01-20T14:05:01.341Z 2026-01-28T14:55:27.431Z
9226745 9226745 20260119125928_caUEQ NZ0003 2026-01-20T14:04:50.980Z 2026-01-28T14:55:25.029Z
9226707 9226707 20260119125123_dmf1U NZ0003 2026-01-20T14:04:39.683Z 2026-01-28T14:55:23.100Z
9226690 9226690 20260119124612_4oTtP NZ0003 2026-01-20T14:04:34.953Z 2026-01-28T14:55:22.419Z
9226676 9226676 20260119124250_BsIrO NZ0003 2026-01-20T14:04:30.126Z 2026-01-28T14:55:21.674Z
9226659 9226659 20260119124036_wOYkn NZ0003 2026-01-20T14:04:25.405Z 2026-01-28T14:55:20.515Z
9226652 9226652 20260119123921_eWnQw NZ0003 2026-01-20T14:04:24.104Z 2026-01-28T14:55:20.162Z
9226644 9226644 20260119123742_uQgD3 NZ0003 2026-01-20T14:04:22.649Z 2026-01-28T14:55:19.897Z
9226591 9226591 20260119123035_Uw6Jf NZ0003 2026-01-20T14:04:04.955Z 2026-01-28T14:55:17.268Z
9226576 9226576 20260119122830_fSK5P NZ0003 2026-01-20T14:04:01.350Z 2026-01-28T14:55:16.535Z
9226549 9226549 20260119121907_qRxHt NZ0003 2026-01-20T14:03:52.332Z 2026-01-28T14:55:14.093Z
9226527 9226527 20260119121334_eqfwF NZ0003 2026-01-20T14:03:41.505Z 2026-01-28T14:55:05.856Z
9226517 9226517 20260119121311_j25aw NZ0003 2026-01-20T14:03:39.081Z 2026-01-28T14:55:05.629Z
9226490 9226490 20260119121104_KeIB7 NZ0003 2026-01-20T14:03:30.131Z 2026-01-28T14:55:04.108Z
9226470 9226470 20260119120710_eDhRA NZ0003 2026-01-20T14:03:25.894Z 2026-01-28T14:55:03.314Z
9226441 9226441 20260119120243_R0FeN NZ0003 2026-01-20T14:03:13.888Z 2026-01-28T14:55:00.346Z
9226416 9226416 20260119115855_AY4kH NZ0003 2026-01-20T14:03:06.209Z 2026-01-28T14:54:59.228Z
9226411 9226411 20260119115822_tC3r1 NZ0003 2026-01-20T14:03:04.024Z 2026-01-28T14:54:58.941Z
9226378 9226378 20260119115344_2G3pA NZ0003 2026-01-20T14:02:53.191Z 2026-01-28T14:54:57.491Z
9226332 9226332 20260119114717_JOwKe NZ0003 2026-01-20T14:02:31.782Z 2026-01-28T14:54:55.289Z
9226324 9226324 20260119114712_Lf6iv NZ0003 2026-01-20T14:02:30.078Z 2026-01-28T14:54:55.011Z
9226204 9226204 20260119112903_utl0Z NZ0003 2026-01-20T14:01:49.390Z 2026-01-28T14:54:48.197Z
9226148 9226148 20260119111749_cPkxX NZ0003 2026-01-20T14:01:29.327Z 2026-01-28T14:54:38.996Z
9226116 9226116 20260119110957_8JBvQ NZ0003 2026-01-20T14:01:13.916Z 2026-01-28T14:54:35.545Z
9225815 9225815 20260118110421_NgH8V NZ0003 2026-01-19T14:30:26.814Z 2026-01-26T15:04:46.276Z
9225684 9225684 20260118104055_RKYhb NZ0003 2026-01-19T14:29:48.115Z 2026-01-26T15:04:41.780Z
9225660 9225660 20260118103638_T934F NZ0003 2026-01-19T14:29:42.665Z 2026-01-26T15:04:41.214Z
9221574 9221574 20260118160502_jAW2p NZ0003 2026-01-19T14:08:22.701Z 2026-01-27T15:00:32.490Z
9221501 9221501 20260118154724_EyPJa NZ0003 2026-01-19T14:08:05.557Z 2026-01-27T15:00:28.393Z
9221436 9221436 20260118154128_gZ99N NZ0003 2026-01-19T14:07:55.107Z 2026-01-27T15:00:22.593Z
9221259 9221259 20260118151157_3808c NZ0003 2026-01-19T14:07:18.001Z 2026-01-27T14:59:59.410Z
9221219 9221219 20260118150640_DZjgf NZ0003 2026-01-19T14:07:08.115Z 2026-01-27T14:59:57.884Z
9221159 9221159 20260118145625_e1h2n NZ0003 2026-01-19T14:06:55.516Z 2026-01-27T14:59:55.660Z
9221147 9221147 20260118145458_gyn86 NZ0003 2026-01-19T14:06:54.241Z 2026-01-27T14:59:55.381Z
9221103 9221103 20260118145050_sQftc NZ0003 2026-01-19T14:06:48.627Z 2026-01-27T14:59:53.981Z
9221092 9221092 20260118144939_inmyf NZ0003 2026-01-19T14:06:47.405Z 2026-01-27T14:59:53.685Z
9221060 9221060 20260118144520_Agr0W NZ0003 2026-01-19T14:06:42.576Z 2026-01-27T14:59:52.520Z
9221047 9221047 20260118144515_RGKEr NZ0003 2026-01-19T14:06:40.889Z 2026-01-27T14:59:52.186Z
9220972 9220972 20260118143131_TepML NZ0003 2026-01-19T14:06:19.998Z 2026-01-27T14:59:48.640Z
9220933 9220933 20260118142035_xktFO NZ0003 2026-01-19T14:06:13.098Z 2026-01-27T14:59:46.923Z
9220920 9220920 20260118141928_evlir NZ0003 2026-01-19T14:06:11.611Z 2026-01-27T14:59:46.379Z
9220849 9220849 20260118140648_iJ6B3 NZ0003 2026-01-19T14:05:52.309Z 2026-01-27T14:59:32.647Z
9220842 9220842 20260118140622_AXuTI NZ0003 2026-01-19T14:05:51.554Z 2026-01-27T14:59:32.466Z
9220774 9220774 20260118134823_EJlBD NZ0003 2026-01-19T14:05:34.389Z 2026-01-27T14:59:28.140Z
9220747 9220747 20260118133953_1Dn0r NZ0003 2026-01-19T14:05:24.883Z 2026-01-27T14:59:26.859Z
9220733 9220733 20260118133925_b8xdj NZ0003 2026-01-19T14:05:23.816Z 2026-01-27T14:59:26.612Z
9220659 9220659 20260118132430_RsiYy NZ0003 2026-01-19T14:05:08.271Z 2026-01-27T14:59:24.323Z
9220574 9220574 20260118131106_KxF3I NZ0003 2026-01-19T14:04:51.076Z 2026-01-27T14:59:21.275Z
9220535 9220535 20260118130708_rPxc2 NZ0003 2026-01-19T14:04:40.369Z 2026-01-27T14:59:19.801Z

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