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 = "NZ004D" 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
9626886 9626886 20260408152003_zEP9s NZ004D 2026-04-09T12:09:28.872Z 2026-04-10T12:14:22.430Z
9626610 9626610 20260408142717_n9xEz NZ004D 2026-04-09T12:08:47.301Z 2026-04-10T12:14:22.384Z
9626450 9626450 20260408140410_nN9qX NZ004D 2026-04-09T12:08:22.410Z 2026-04-10T12:14:22.355Z
9626324 9626324 20260408134211_MM8ZF NZ004D 2026-04-09T12:08:00.487Z 2026-04-10T12:14:22.333Z
9626242 9626242 20260408133004_pLbxY NZ004D 2026-04-09T12:07:49.237Z 2026-04-10T12:14:22.322Z
9626237 9626237 20260408133002_JeENp NZ004D 2026-04-09T12:07:48.745Z 2026-04-10T12:14:22.321Z
9625962 9625962 20260408123911_jqkE1 NZ004D 2026-04-09T12:07:12.038Z 2026-04-10T12:14:22.272Z
9625885 9625885 20260408122140_3WEwM NZ004D 2026-04-09T12:07:03.242Z 2026-04-10T12:14:22.259Z
9625882 9625882 20260408122140_Td8Wi NZ004D 2026-04-09T12:07:02.866Z 2026-04-10T12:14:22.259Z
9605306 9605306 20260403083454_rsFFx NZ004D 2026-04-04T12:01:44.083Z 2026-04-10T12:31:33.231Z
9605269 9605269 20260403081817_vxh9u NZ004D 2026-04-04T12:01:29.673Z 2026-04-10T12:31:32.341Z
9601959 9601959 20260401173609_fojTV NZ004D 2026-04-02T12:04:19.697Z 2026-04-10T12:35:50.430Z
9601069 9601069 20260401112324_Wo3Jf NZ004D 2026-04-02T12:01:29.047Z 2026-04-10T12:35:32.630Z
9601025 9601025 20260401103722_HHIDD NZ004D 2026-04-02T12:01:19.187Z 2026-04-10T12:35:31.834Z
9601014 9601014 20260401103037_CmOLl NZ004D 2026-04-02T12:01:17.656Z 2026-04-10T12:35:31.730Z
9600958 9600958 20260401094355_xwVQu NZ004D 2026-04-02T12:01:07.052Z 2026-04-10T12:35:30.606Z
9600930 9600930 20260401090216_isl1b NZ004D 2026-04-02T12:01:00.513Z 2026-04-10T12:35:29.925Z
9599693 9599693 20260331162425_uIf6U NZ004D 2026-04-01T12:04:32.015Z 2026-04-09T12:47:15.483Z
9599659 9599659 20260331161115_f33gL NZ004D 2026-04-01T12:04:22.766Z 2026-04-09T12:47:11.092Z
9599655 9599655 20260331161115_M03cB NZ004D 2026-04-01T12:04:22.405Z 2026-04-09T12:47:09.933Z
9599644 9599644 20260331160942_IeWz5 NZ004D 2026-04-01T12:04:20.416Z 2026-04-09T12:47:08.224Z
9599637 9599637 20260331160703_cF5tk NZ004D 2026-04-01T12:04:18.653Z 2026-04-09T12:47:07.784Z
9596009 9596009 20260330103900_RilRy NZ004D 2026-03-31T12:03:07.743Z 2026-04-08T12:42:38.424Z
9595913 9595913 20260330100255_WERul NZ004D 2026-03-31T12:02:49.481Z 2026-04-08T12:42:35.983Z
9595870 9595870 20260330093312_oX2ZQ NZ004D 2026-03-31T12:02:43.924Z 2026-04-08T12:42:34.942Z
9595836 9595836 20260330091657_vd4bJ NZ004D 2026-03-31T12:02:39.746Z 2026-04-08T12:42:34.047Z
9595748 9595748 20260330082019_aFB1S NZ004D 2026-03-31T12:02:21.946Z 2026-04-08T12:42:31.116Z
9593952 9593952 20260329170445_dq3r8 NZ004D 2026-03-30T12:05:36.736Z 2026-04-07T12:27:40.820Z
9593908 9593908 20260329164208_x4Cfb NZ004D 2026-03-30T12:05:29.213Z 2026-04-07T12:27:39.607Z
9593902 9593902 20260329163843_kP3pQ NZ004D 2026-03-30T12:05:27.990Z 2026-04-07T12:27:39.408Z
9593850 9593850 20260329161342_v6c9t NZ004D 2026-03-30T12:05:16.809Z 2026-04-07T12:27:37.893Z
9593846 9593846 20260329160933_2yj1t NZ004D 2026-03-30T12:05:16.134Z 2026-04-07T12:27:37.692Z
9593765 9593765 20260329150150_7HQ57 NZ004D 2026-03-30T12:05:03.082Z 2026-04-07T12:27:35.196Z
9590644 9590644 20260328103201_FfX61 NZ004D 2026-03-29T12:03:03.653Z 2026-04-06T12:38:28.520Z
9588001 9588001 20260327171644_2U5S2 NZ004D 2026-03-28T12:06:53.510Z 2026-04-05T12:35:03.352Z
9587952 9587952 20260327165809_tI3GY NZ004D 2026-03-28T12:06:46.823Z 2026-04-05T12:35:00.917Z
9587937 9587937 20260327165634_ms4Py NZ004D 2026-03-28T12:06:45.558Z 2026-04-05T12:35:00.358Z
9587909 9587909 20260327164854_cyQ15 NZ004D 2026-03-28T12:06:41.913Z 2026-04-05T12:34:57.923Z
9587884 9587884 20260327163711_GRg7b NZ004D 2026-03-28T12:06:38.909Z 2026-04-05T12:34:48.024Z
9587867 9587867 20260327162923_jvaD8 NZ004D 2026-03-28T12:06:36.525Z 2026-04-05T12:34:47.291Z
9587820 9587820 20260327161359_MHn63 NZ004D 2026-03-28T12:06:25.260Z 2026-04-05T12:34:45.012Z
9572237 9572237 20260324081548_EAYoF NZ004D 2026-03-25T12:04:21.546Z 2026-04-02T12:35:10.045Z
9572227 9572227 20260324081021_Uq5tn NZ004D 2026-03-25T12:04:19.290Z 2026-04-02T12:35:08.369Z
9572216 9572216 20260324080651_8AuFk NZ004D 2026-03-25T12:04:16.616Z 2026-04-02T12:35:08.090Z
9572191 9572191 20260324080237_3jw3E NZ004D 2026-03-25T12:04:11.345Z 2026-04-02T12:35:07.156Z
9568724 9568724 20260323171607_itau3 NZ004D 2026-03-24T12:15:38.221Z 2026-03-31T12:28:41.028Z
9568670 9568670 20260323171007_0yVLb NZ004D 2026-03-24T12:15:29.002Z 2026-03-31T12:28:39.975Z
9568598 9568598 20260323170046_VDNng NZ004D 2026-03-24T12:15:21.170Z 2026-03-31T12:28:38.302Z
9568593 9568593 20260323165920_x6uZe NZ004D 2026-03-24T12:15:20.718Z 2026-03-31T12:28:37.902Z
9568586 9568586 20260323165810_ISrGK NZ004D 2026-03-24T12:15:19.962Z 2026-03-31T12:28:34.502Z
9568439 9568439 20260323164438_ybGB0 NZ004D 2026-03-24T12:15:07.542Z 2026-03-24T12:24:25.458Z
9568298 9568298 20260323162757_mTNGq NZ004D 2026-03-24T12:14:51.175Z 2026-03-31T12:28:26.965Z
9568192 9568192 20260323161833_7eHQT NZ004D 2026-03-24T12:14:42.619Z 2026-03-24T12:24:25.409Z
9568105 9568105 20260323161349_LsigH NZ004D 2026-03-24T12:14:34.237Z 2026-03-31T12:28:22.942Z
9567935 9567935 20260323160125_ZMezI NZ004D 2026-03-24T12:14:18.477Z 2026-03-31T12:28:20.844Z
9564185 9564185 20260323100921_eL450 NZ004D 2026-03-24T12:07:35.877Z 2026-03-31T12:27:04.750Z
9564094 9564094 20260323095742_zXp3i NZ004D 2026-03-24T12:07:24.684Z 2026-03-31T12:27:02.333Z
9563998 9563998 20260323094711_SGEqS NZ004D 2026-03-24T12:07:08.795Z 2026-03-31T12:27:00.578Z
9563816 9563816 20260323091538_bhD9h NZ004D 2026-03-24T12:06:46.455Z 2026-03-31T12:26:57.247Z
9563764 9563764 20260323090727_suD3d NZ004D 2026-03-24T12:06:40.212Z 2026-03-31T12:26:50.512Z
9563684 9563684 20260323090110_AnHvg NZ004D 2026-03-24T12:06:33.691Z 2026-03-31T12:26:49.392Z
9563626 9563626 20260323085159_zfXe2 NZ004D 2026-03-24T12:06:25.556Z 2026-03-31T12:26:48.269Z
9559504 9559504 20260321173327_jJjh2 NZ004D 2026-03-23T12:11:08.337Z 2026-03-29T12:20:40.120Z
9559419 9559419 20260321171419_922fM NZ004D 2026-03-23T12:11:05.188Z 2026-03-29T12:20:38.906Z
9559261 9559261 20260321165037_nYV3p NZ004D 2026-03-23T12:10:59.693Z 2026-03-29T12:20:35.934Z
9559258 9559258 20260321165037_zJoSc NZ004D 2026-03-23T12:10:59.531Z 2026-03-29T12:20:35.911Z
9559146 9559146 20260321164029_f2tpY NZ004D 2026-03-23T12:10:55.559Z 2026-03-29T12:20:34.520Z
9558983 9558983 20260321161435_2pv3w NZ004D 2026-03-23T12:10:49.905Z 2026-03-29T12:20:32.671Z
9558976 9558976 20260321161422_J7d60 NZ004D 2026-03-23T12:10:49.795Z 2026-03-29T12:20:32.643Z
9558823 9558823 20260321154939_Kp8CI NZ004D 2026-03-23T12:10:34.837Z 2026-03-29T12:20:30.445Z
9558784 9558784 20260321135853_meoLX NZ004D 2026-03-23T12:09:52.082Z 2026-03-29T12:20:21.316Z
9558682 9558682 20260322172518_qjFFb NZ004D 2026-03-23T12:06:54.313Z 2026-03-30T12:30:20.154Z
9558621 9558621 20260322170950_KqVUw NZ004D 2026-03-23T12:06:51.549Z 2026-03-30T12:30:18.127Z
9558609 9558609 20260322170831_4Lqo1 NZ004D 2026-03-23T12:06:51.171Z 2026-03-30T12:30:17.971Z
9558470 9558470 20260322164719_tbqyn NZ004D 2026-03-23T12:06:45.812Z 2026-03-30T12:30:14.760Z
9558391 9558391 20260322163158_McZmX NZ004D 2026-03-23T12:06:41.301Z 2026-03-30T12:30:12.051Z
9558198 9558198 20260322160837_WFLKo NZ004D 2026-03-23T12:06:29.279Z 2026-03-30T12:30:07.613Z
9558188 9558188 20260322160311_2aq7N NZ004D 2026-03-23T12:06:28.725Z 2026-03-30T12:30:07.185Z
9558178 9558178 20260322160220_lOV73 NZ004D 2026-03-23T12:06:28.341Z 2026-03-30T12:30:06.759Z
9558060 9558060 20260322153802_897t9 NZ004D 2026-03-23T12:06:21.562Z 2026-03-30T12:30:02.762Z
9550449 9550449 20260320164106_asNfZ NZ004D 2026-03-22T12:25:23.325Z 2026-03-28T12:36:31.207Z
9550437 9550437 20260320163932_CbSUR NZ004D 2026-03-22T12:25:16.093Z 2026-03-28T12:36:31.007Z
9550297 9550297 20260320162821_g3d9q NZ004D 2026-03-22T12:25:07.149Z 2026-03-28T12:36:29.345Z
9550188 9550188 20260320161549_6YEYe NZ004D 2026-03-22T12:25:00.313Z 2026-03-28T12:36:28.000Z
9549991 9549991 20260320155830_qLARL NZ004D 2026-03-22T12:24:41.836Z 2026-03-28T12:36:25.421Z
9549960 9549960 20260320155731_ba2V5 NZ004D 2026-03-22T12:24:40.170Z 2026-03-28T12:36:25.021Z
9549820 9549820 20260320154417_qdlmv NZ004D 2026-03-22T12:24:31.065Z 2026-03-28T12:36:21.946Z
9549118 9549118 20260321173816_etQRE NZ004D 2026-03-22T12:16:35.707Z 2026-03-29T12:20:40.167Z
9549083 9549083 20260321171847_p7Xav NZ004D 2026-03-22T12:16:31.189Z 2026-03-29T12:20:39.222Z
9548996 9548996 20260321163258_oIvYf NZ004D 2026-03-22T12:16:22.831Z 2026-03-29T12:20:34.004Z
9548983 9548983 20260321162503_boScT NZ004D 2026-03-22T12:16:21.710Z 2026-03-29T12:20:33.557Z
9548979 9548979 20260321162354_fjo70 NZ004D 2026-03-22T12:16:21.429Z 2026-03-29T12:20:33.509Z
9548951 9548951 20260321160402_9msqy NZ004D 2026-03-22T12:16:17.456Z 2026-03-29T12:20:31.732Z
9548937 9548937 20260321155507_K1Qq9 NZ004D 2026-03-22T12:16:15.808Z 2026-03-22T12:27:38.786Z
9548835 9548835 20260321153737_gNYHs NZ004D 2026-03-22T12:16:02.311Z 2026-03-29T12:20:29.230Z
9548787 9548787 20260321153409_O7crz NZ004D 2026-03-22T12:15:57.996Z 2026-03-29T12:20:28.823Z
9548767 9548767 20260321153237_P5HqI NZ004D 2026-03-22T12:15:56.165Z 2026-03-29T12:20:28.649Z
9548760 9548760 20260321153229_93JyC NZ004D 2026-03-22T12:15:55.839Z 2026-03-29T12:20:28.601Z
9548757 9548757 20260321153228_P7i1v NZ004D 2026-03-22T12:15:55.634Z 2026-03-29T12:20:28.598Z
9548494 9548494 20260321150935_LaHDE NZ004D 2026-03-22T12:15:29.510Z 2026-03-29T12:20:26.816Z

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