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,868 rows where station_code = "NZ0008" 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
9607990 9607990 20260403141040_W06VU NZ0008 2026-04-05T12:06:55.014Z 2026-04-10T12:32:18.822Z
9606183 9606183 20260403160052_EEahF NZ0008 2026-04-04T12:05:48.202Z 2026-04-10T12:32:23.801Z
9605441 9605441 20260403095901_W3AMX NZ0008 2026-04-04T12:02:21.724Z 2026-04-10T12:31:36.052Z
9604110 9604110 20260402155223_FXTs9 NZ0008 2026-04-03T12:05:57.665Z 2026-04-10T12:34:42.498Z
9604031 9604031 20260402151023_VmUp7 NZ0008 2026-04-03T12:05:42.744Z 2026-04-10T12:34:17.994Z
9603993 9603993 20260402143907_B5lO2 NZ0008 2026-04-03T12:05:27.596Z 2026-04-10T12:34:17.095Z
9603962 9603962 20260402142407_XpSWN NZ0008 2026-04-03T12:05:21.151Z 2026-04-10T12:34:16.597Z
9601938 9601938 20260401172833_FtHVX NZ0008 2026-04-02T12:04:14.667Z 2026-04-10T12:35:50.093Z
9601926 9601926 20260401172715_knMjg NZ0008 2026-04-02T12:04:11.945Z 2026-04-10T12:35:49.777Z
9601869 9601869 20260401171732_VGpdb NZ0008 2026-04-02T12:03:59.112Z 2026-04-10T12:35:48.689Z
9601748 9601748 20260401165138_59qoL NZ0008 2026-04-02T12:03:35.106Z 2026-04-10T12:35:46.776Z
9596665 9596665 20260330133902_3CmSE NZ0008 2026-03-31T12:04:40.727Z 2026-04-08T12:43:21.790Z
9596310 9596310 20260330121828_VQl6S NZ0008 2026-03-31T12:04:00.426Z 2026-04-08T12:42:49.263Z
9596149 9596149 20260330112638_1Bu44 NZ0008 2026-03-31T12:03:36.193Z 2026-04-08T12:42:42.536Z
9595894 9595894 20260330094727_IDIvO NZ0008 2026-03-31T12:02:46.343Z 2026-04-08T12:42:35.454Z
9591091 9591091 20260328131357_N1H4y NZ0008 2026-03-29T12:03:49.678Z 2026-04-06T12:39:00.127Z
9590921 9590921 20260328115912_carbD NZ0008 2026-03-29T12:03:29.895Z 2026-04-06T12:38:40.719Z
9587850 9587850 20260327162630_2oZI9 NZ0008 2026-03-28T12:06:32.072Z 2026-04-05T12:34:46.671Z
9587405 9587405 20260327122947_Q6Pf3 NZ0008 2026-03-28T12:05:26.789Z 2026-04-05T12:34:25.320Z
9578514 9578514 20260325120955_nw3zl NZ0008 2026-03-26T12:07:47.930Z 2026-04-03T12:38:06.473Z
9574824 9574824 20260323172326_226mF NZ0008 2026-03-25T12:19:43.872Z 2026-03-31T12:28:42.684Z
9574789 9574789 20260323172153_8lyxE NZ0008 2026-03-25T12:19:41.575Z 2026-03-31T12:28:42.062Z
9573046 9573046 20260324111141_knWbR NZ0008 2026-03-25T12:07:04.397Z 2026-04-02T12:35:53.960Z
9569750 9569750 20260322171558_VQ33V NZ0008 2026-03-24T12:21:58.651Z 2026-03-30T12:30:19.132Z
9569678 9569678 20260322165140_TZ4Yv NZ0008 2026-03-24T12:21:47.329Z 2026-03-30T12:30:15.391Z
9569639 9569639 20260322163658_0gqlz NZ0008 2026-03-24T12:21:36.465Z 2026-03-30T12:30:12.937Z
9569380 9569380 20260322151605_ORnsA NZ0008 2026-03-24T12:20:49.141Z 2026-03-30T12:29:51.721Z
9569266 9569266 20260322143417_mZXSj NZ0008 2026-03-24T12:20:22.868Z 2026-03-30T12:29:43.530Z
9569045 9569045 20260322124859_fSIlP NZ0008 2026-03-24T12:19:31.335Z 2026-03-30T12:29:20.822Z
9568730 9568730 20260323171639_54k6j NZ0008 2026-03-24T12:15:38.712Z 2026-03-31T12:28:41.156Z
9568621 9568621 20260323170509_uiG9a NZ0008 2026-03-24T12:15:24.667Z 2026-03-31T12:28:38.950Z
9568320 9568320 20260323163130_CtSjG NZ0008 2026-03-24T12:14:52.721Z 2026-03-31T12:28:27.306Z
9568115 9568115 20260323161517_OA3No NZ0008 2026-03-24T12:14:35.425Z 2026-03-31T12:28:23.207Z
9567651 9567651 20260323153845_1WRlq NZ0008 2026-03-24T12:13:55.014Z 2026-03-31T12:28:17.212Z
9567555 9567555 20260323152930_F0laS NZ0008 2026-03-24T12:13:46.610Z 2026-03-31T12:28:15.740Z
9567466 9567466 20260323151902_XTcNF NZ0008 2026-03-24T12:13:39.405Z 2026-03-31T12:28:14.398Z
9567440 9567440 20260323151529_6zlBG NZ0008 2026-03-24T12:13:37.525Z 2026-03-31T12:28:14.117Z
9567291 9567291 20260323150251_1d7BW NZ0008 2026-03-24T12:13:20.922Z 2026-03-31T12:28:12.116Z
9567258 9567258 20260323145953_2hO5J NZ0008 2026-03-24T12:13:18.135Z 2026-03-31T12:28:11.414Z
9566912 9566912 20260323142432_wBTRy NZ0008 2026-03-24T12:12:41.829Z 2026-03-31T12:28:05.986Z
9566845 9566845 20260323141854_0cZCK NZ0008 2026-03-24T12:12:32.658Z 2026-03-31T12:28:05.072Z
9566837 9566837 20260323141803_woNU2 NZ0008 2026-03-24T12:12:31.769Z 2026-03-31T12:28:04.922Z
9566757 9566757 20260323141127_sRqMv NZ0008 2026-03-24T12:12:24.209Z 2026-03-31T12:27:56.516Z
9566270 9566270 20260323132143_kHpKp NZ0008 2026-03-24T12:11:33.514Z 2026-03-31T12:27:48.023Z
9566268 9566268 20260323132114_BrZFp NZ0008 2026-03-24T12:11:32.966Z 2026-03-31T12:27:47.942Z
9565745 9565745 20260323123657_4yUP4 NZ0008 2026-03-24T12:10:46.276Z 2026-03-31T12:27:40.617Z
9565221 9565221 20260323115126_nxaHu NZ0008 2026-03-24T12:09:40.502Z 2026-03-31T12:27:31.208Z
9565087 9565087 20260323114324_x2Wvr NZ0008 2026-03-24T12:09:22.923Z 2026-03-31T12:27:22.566Z
9564997 9564997 20260323113439_NWHr2 NZ0008 2026-03-24T12:09:13.638Z 2026-03-31T12:27:20.789Z
9564967 9564967 20260323113308_SN14a NZ0008 2026-03-24T12:09:08.802Z 2026-03-31T12:27:20.110Z
9564891 9564891 20260323111942_elqOd NZ0008 2026-03-24T12:08:58.911Z 2026-03-31T12:27:18.608Z
9564824 9564824 20260323111045_GYv2H NZ0008 2026-03-24T12:08:52.023Z 2026-03-31T12:27:16.065Z
9564702 9564702 20260323110223_3S17n NZ0008 2026-03-24T12:08:36.818Z 2026-03-31T12:27:13.870Z
9564541 9564541 20260323104813_7qWeh NZ0008 2026-03-24T12:08:20.890Z 2026-03-31T12:27:11.260Z
9563851 9563851 20260323092103_XzSuf NZ0008 2026-03-24T12:06:52.143Z 2026-03-31T12:26:58.019Z
9563817 9563817 20260323091610_ZzWfB NZ0008 2026-03-24T12:06:47.055Z 2026-03-31T12:26:57.299Z
9563431 9563431 20260323082053_xlhO7 NZ0008 2026-03-24T12:06:00.578Z 2026-03-31T12:26:43.263Z
9559020 9559020 20260321161955_gHq23 NZ0008 2026-03-23T12:10:51.543Z 2026-03-29T12:20:33.223Z
9558888 9558888 20260321160255_qR0fs NZ0008 2026-03-23T12:10:38.862Z 2026-03-29T12:20:31.446Z
9558838 9558838 20260321155329_BvqXO NZ0008 2026-03-23T12:10:36.580Z 2026-03-29T12:20:30.824Z
9558703 9558703 20260322173155_BU1Mq NZ0008 2026-03-23T12:06:56.263Z 2026-03-30T12:30:20.705Z
9558629 9558629 20260322171443_W0np5 NZ0008 2026-03-23T12:06:52.216Z 2026-03-30T12:30:18.801Z
9558533 9558533 20260322165411_KBnms NZ0008 2026-03-23T12:06:48.269Z 2026-03-30T12:30:16.180Z
9558529 9558529 20260322165411_TJ1SU NZ0008 2026-03-23T12:06:48.170Z 2026-03-30T12:30:16.116Z
9558516 9558516 20260322165315_ryjvP NZ0008 2026-03-23T12:06:47.725Z 2026-03-30T12:30:15.961Z
9558431 9558431 20260322164000_6LAbz NZ0008 2026-03-23T12:06:43.731Z 2026-03-30T12:30:13.584Z
9558254 9558254 20260322161307_nFVf1 NZ0008 2026-03-23T12:06:35.376Z 2026-03-30T12:30:08.971Z
9558116 9558116 20260322155031_vPMmS NZ0008 2026-03-23T12:06:25.758Z 2026-03-30T12:30:05.046Z
9558109 9558109 20260322154737_az89t NZ0008 2026-03-23T12:06:25.220Z 2026-03-30T12:30:04.856Z
9558064 9558064 20260322153900_RK9Kh NZ0008 2026-03-23T12:06:21.787Z 2026-03-30T12:30:03.071Z
9557870 9557870 20260322150840_U7esJ NZ0008 2026-03-23T12:06:13.679Z 2026-03-30T12:29:50.546Z
9557832 9557832 20260322150131_IZoy7 NZ0008 2026-03-23T12:06:12.023Z 2026-03-30T12:29:48.910Z
9557825 9557825 20260322150000_irYpg NZ0008 2026-03-23T12:06:11.439Z 2026-03-30T12:29:48.494Z
9557779 9557779 20260322145517_D5SQS NZ0008 2026-03-23T12:06:09.607Z 2026-03-30T12:29:47.548Z
9557677 9557677 20260322144036_QR8e8 NZ0008 2026-03-23T12:06:04.922Z 2026-03-30T12:29:44.782Z
9557559 9557559 20260322142516_w1mmo NZ0008 2026-03-23T12:05:56.339Z 2026-03-30T12:29:41.907Z
9557536 9557536 20260322142159_flb2J NZ0008 2026-03-23T12:05:55.486Z 2026-03-30T12:29:41.180Z
9557493 9557493 20260322141600_1wAUh NZ0008 2026-03-23T12:05:53.154Z 2026-03-30T12:29:39.856Z
9557324 9557324 20260322133545_NyYsb NZ0008 2026-03-23T12:05:46.128Z 2026-03-30T12:29:34.762Z
9557305 9557305 20260322133316_qGgJD NZ0008 2026-03-23T12:05:45.551Z 2026-03-30T12:29:34.526Z
9557086 9557086 20260322124955_wfuDG NZ0008 2026-03-23T12:05:35.468Z 2026-03-30T12:29:21.014Z
9557067 9557067 20260322124457_TThdt NZ0008 2026-03-23T12:05:34.139Z 2026-03-30T12:29:20.342Z
9557019 9557019 20260322123731_R32Bk NZ0008 2026-03-23T12:05:28.787Z 2026-03-30T12:29:19.151Z
9556949 9556949 20260322121603_oTJ1P NZ0008 2026-03-23T12:05:22.983Z 2026-03-30T12:29:15.808Z
9556739 9556739 20260322112812_wdC01 NZ0008 2026-03-23T12:05:10.192Z 2026-03-30T12:29:09.521Z
9556688 9556688 20260322112234_WzWSY NZ0008 2026-03-23T12:05:07.739Z 2026-03-30T12:29:08.415Z
9556367 9556367 20260322101627_2ifnD NZ0008 2026-03-23T12:04:42.901Z 2026-03-30T12:28:58.796Z
9556162 9556162 20260322092827_BCZpZ NZ0008 2026-03-23T12:04:25.992Z 2026-03-30T12:28:46.351Z
9555889 9555889 20260322083200_pIw4D NZ0008 2026-03-23T12:04:06.177Z 2026-03-30T12:28:38.346Z
9555797 9555797 20260322080443_ZtTem NZ0008 2026-03-23T12:03:55.672Z 2026-03-30T12:28:35.621Z
9555785 9555785 20260322075603_Yee3v NZ0008 2026-03-23T12:03:54.545Z 2026-03-30T12:28:34.965Z
9548356 9548356 20260321145710_mLsKM NZ0008 2026-03-22T12:15:17.965Z 2026-03-29T12:20:25.575Z
9529066 9529066 20260318171125_cHUVx NZ0008 2026-03-20T12:22:51.753Z 2026-03-26T12:38:43.705Z
9528678 9528678 20260318163647_s00Ys NZ0008 2026-03-20T12:22:26.818Z 2026-03-26T12:38:37.611Z
9528569 9528569 20260318162450_0nR3K NZ0008 2026-03-20T12:22:22.457Z 2026-03-26T12:38:36.920Z
9528302 9528302 20260318160259_bm2qE NZ0008 2026-03-20T12:22:11.652Z 2026-03-26T12:38:35.262Z
9528044 9528044 20260318153700_Z5lms NZ0008 2026-03-20T12:21:53.702Z 2026-03-26T12:38:32.823Z
9528018 9528018 20260318153600_GHrPF NZ0008 2026-03-20T12:21:52.968Z 2026-03-26T12:38:32.691Z
9527813 9527813 20260318151727_TeuaI NZ0008 2026-03-20T12:21:45.033Z 2026-03-26T12:38:31.501Z
9527709 9527709 20260318150755_e7gB6 NZ0008 2026-03-20T12:21:39.508Z 2026-03-26T12:38:30.754Z

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