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,700 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
9626880 9626880 20260408152003_zEP9s NZ0010 2026-04-09T12:09:28.872Z 2026-04-10T12:14:22.430Z
9626808 9626808 20260408150916_X5kbW NZ0010 2026-04-09T12:09:14.087Z 2026-04-10T12:14:22.417Z
9626744 9626744 20260408150014_aeKaA NZ0010 2026-04-09T12:09:07.222Z 2026-04-10T12:14:22.407Z
9626695 9626695 20260408145235_R8ocR NZ0010 2026-04-09T12:09:03.315Z 2026-04-10T12:14:22.402Z
9625687 9625687 20260408113557_qBhqC NZ0010 2026-04-09T12:06:17.552Z 2026-04-10T12:14:22.223Z
9604262 9604262 20260402164830_3hKUP NZ0010 2026-04-03T12:06:34.712Z 2026-04-10T12:34:46.492Z
9604241 9604241 20260402164418_TzJel NZ0010 2026-04-03T12:06:29.356Z 2026-04-10T12:34:45.935Z
9601999 9601999 20260401174725_ratek NZ0010 2026-04-02T12:04:28.530Z 2026-04-10T12:35:51.232Z
9601943 9601943 20260401173332_mJY4c NZ0010 2026-04-02T12:04:16.093Z 2026-04-10T12:35:50.213Z
9601890 9601890 20260401171911_iIfWr NZ0010 2026-04-02T12:04:02.835Z 2026-04-10T12:35:49.115Z
9601867 9601867 20260401171700_I3MJn NZ0010 2026-04-02T12:03:58.495Z 2026-04-10T12:35:48.673Z
9601811 9601811 20260401170750_yXTp7 NZ0010 2026-04-02T12:03:48.085Z 2026-04-10T12:35:47.902Z
9601651 9601651 20260401162430_rn2Hm NZ0010 2026-04-02T12:03:22.489Z 2026-04-10T12:35:42.953Z
9601480 9601480 20260401152733_iLuu4 NZ0010 2026-04-02T12:02:54.442Z 2026-04-10T12:35:40.046Z
9599767 9599767 20260331164124_Z0vTI NZ0010 2026-04-01T12:04:45.509Z 2026-04-09T12:47:28.458Z
9599669 9599669 20260331161557_r9Dr5 NZ0010 2026-04-01T12:04:24.098Z 2026-04-09T12:47:13.793Z
9599502 9599502 20260331151722_MFYvr NZ0010 2026-04-01T12:03:49.872Z 2026-04-09T12:46:51.721Z
9599464 9599464 20260331145233_SRJbf NZ0010 2026-04-01T12:03:42.025Z 2026-04-09T12:46:48.044Z
9599330 9599330 20260331140218_22mLR NZ0010 2026-04-01T12:03:13.807Z 2026-04-09T12:46:46.120Z
9598054 9598054 20260330173558_HYxUr NZ0010 2026-03-31T12:07:31.214Z 2026-04-08T12:44:24.392Z
9597943 9597943 20260330172205_69JQ0 NZ0010 2026-03-31T12:07:19.451Z 2026-04-08T12:44:21.294Z
9597319 9597319 20260330160347_SDnzE NZ0010 2026-03-31T12:06:07.976Z 2026-04-08T12:43:40.411Z
9588037 9588037 20260327174953_Y5Gt1 NZ0010 2026-03-28T12:07:00.063Z 2026-04-05T12:35:05.201Z
9587991 9587991 20260327171432_X9dNW NZ0010 2026-03-28T12:06:52.841Z 2026-04-05T12:35:03.032Z
9587988 9587988 20260327171301_3UKyE NZ0010 2026-03-28T12:06:52.531Z 2026-04-05T12:35:02.928Z
9587954 9587954 20260327165849_3iZsm NZ0010 2026-03-28T12:06:47.098Z 2026-04-05T12:35:01.026Z
9587948 9587948 20260327165809_tI3GY NZ0010 2026-03-28T12:06:46.823Z 2026-04-05T12:35:00.917Z
9587863 9587863 20260327162923_jvaD8 NZ0010 2026-03-28T12:06:36.525Z 2026-04-05T12:34:47.291Z
9587818 9587818 20260327161359_MHn63 NZ0010 2026-03-28T12:06:25.260Z 2026-04-05T12:34:45.012Z
9587793 9587793 20260327160432_VsCKC NZ0010 2026-03-28T12:06:21.658Z 2026-04-05T12:34:43.741Z
9587574 9587574 20260327141431_7h25u NZ0010 2026-03-28T12:05:51.055Z 2026-04-05T12:34:32.191Z
9587408 9587408 20260327123113_55RHD NZ0010 2026-03-28T12:05:27.282Z 2026-04-05T12:34:25.489Z
9587373 9587373 20260327122012_tklcf NZ0010 2026-03-28T12:05:22.949Z 2026-04-05T12:34:24.188Z
9587334 9587334 20260327121039_CGoOd NZ0010 2026-03-28T12:05:18.720Z 2026-04-05T12:34:22.453Z
9568733 9568733 20260323171642_v97aK NZ0010 2026-03-24T12:15:38.937Z 2026-03-31T12:28:41.212Z
9568604 9568604 20260323170224_3B3Sd NZ0010 2026-03-24T12:15:21.919Z 2026-03-31T12:28:38.564Z
9568433 9568433 20260323164356_wA2Qa NZ0010 2026-03-24T12:15:06.386Z 2026-03-31T12:28:29.194Z
9568256 9568256 20260323162547_vjSp9 NZ0010 2026-03-24T12:14:48.058Z 2026-03-31T12:28:26.494Z
9567981 9567981 20260323160347_YwISi NZ0010 2026-03-24T12:14:21.307Z 2026-03-31T12:28:21.251Z
9567873 9567873 20260323155501_x9AHW NZ0010 2026-03-24T12:14:14.806Z 2026-03-31T12:28:19.967Z
9567533 9567533 20260323152718_Bts14 NZ0010 2026-03-24T12:13:45.099Z 2026-03-31T12:28:15.384Z
9566858 9566858 20260323142003_2BSch NZ0010 2026-03-24T12:12:33.735Z 2026-03-31T12:28:05.220Z
9566493 9566493 20260323134612_5dh2L NZ0010 2026-03-24T12:11:58.119Z 2026-03-31T12:27:52.827Z
9566433 9566433 20260323133801_jl2n5 NZ0010 2026-03-24T12:11:51.600Z 2026-03-31T12:27:51.874Z
9566276 9566276 20260323132154_KOEEr NZ0010 2026-03-24T12:11:34.542Z 2026-03-31T12:27:48.107Z
9566120 9566120 20260323130741_aQDm3 NZ0010 2026-03-24T12:11:22.712Z 2026-03-31T12:27:46.343Z
9565995 9565995 20260323125616_jDNOH NZ0010 2026-03-24T12:11:11.232Z 2026-03-31T12:27:44.569Z
9565892 9565892 20260323124855_Cwjyu NZ0010 2026-03-24T12:10:59.339Z 2026-03-31T12:27:43.011Z
9565809 9565809 20260323124145_CRMYF NZ0010 2026-03-24T12:10:53.455Z 2026-03-31T12:27:41.789Z
9565795 9565795 20260323124114_lHMD1 NZ0010 2026-03-24T12:10:52.402Z 2026-03-31T12:27:41.618Z
9565776 9565776 20260323124034_2503J NZ0010 2026-03-24T12:10:50.405Z 2026-03-31T12:27:41.228Z
9565080 9565080 20260323114247_uIgyt NZ0010 2026-03-24T12:09:22.036Z 2026-03-31T12:27:22.390Z
9565032 9565032 20260323113837_UJUvx NZ0010 2026-03-24T12:09:17.300Z 2026-03-31T12:27:21.505Z
9565018 9565018 20260323113830_P9b61 NZ0010 2026-03-24T12:09:15.944Z 2026-03-31T12:27:21.195Z
9564783 9564783 20260323110809_pIRyP NZ0010 2026-03-24T12:08:47.394Z 2026-03-31T12:27:15.432Z
9564550 9564550 20260323104934_3PBFz NZ0010 2026-03-24T12:08:22.165Z 2026-03-31T12:27:11.504Z
9564347 9564347 20260323102418_yd1m0 NZ0010 2026-03-24T12:07:53.648Z 2026-03-31T12:27:07.495Z
9563975 9563975 20260323094217_T4Vke NZ0010 2026-03-24T12:07:05.399Z 2026-03-31T12:26:59.970Z
9563513 9563513 20260323082630_JrY3P NZ0010 2026-03-24T12:06:08.959Z 2026-03-31T12:26:45.981Z
9563391 9563391 20260323081226_xPe58 NZ0010 2026-03-24T12:05:55.045Z 2026-03-31T12:26:42.387Z
9559517 9559517 20260321174108_kh2li NZ0010 2026-03-23T12:11:09.009Z 2026-03-29T12:20:40.277Z
9559425 9559425 20260321171626_6W9Sq NZ0010 2026-03-23T12:11:05.470Z 2026-03-29T12:20:39.079Z
9559383 9559383 20260321170802_eBtQu NZ0010 2026-03-23T12:11:03.854Z 2026-03-29T12:20:38.397Z
9559259 9559259 20260321165037_nYV3p NZ0010 2026-03-23T12:10:59.692Z 2026-03-29T12:20:35.934Z
9559256 9559256 20260321165037_zJoSc NZ0010 2026-03-23T12:10:59.531Z 2026-03-29T12:20:35.911Z
9559239 9559239 20260321164907_aPcFd NZ0010 2026-03-23T12:10:58.951Z 2026-03-29T12:20:35.681Z
9559122 9559122 20260321163734_QPS2X NZ0010 2026-03-23T12:10:55.032Z 2026-03-29T12:20:34.271Z
9559062 9559062 20260321162524_d1IMO NZ0010 2026-03-23T12:10:52.967Z 2026-03-29T12:20:33.628Z
9558978 9558978 20260321161435_2pv3w NZ0010 2026-03-23T12:10:49.905Z 2026-03-29T12:20:32.671Z
9558909 9558909 20260321160355_V13s0 NZ0010 2026-03-23T12:10:39.494Z 2026-03-29T12:20:31.667Z
9558849 9558849 20260321155635_PQ07V NZ0010 2026-03-23T12:10:37.103Z 2026-03-29T12:20:31.018Z
9558814 9558814 20260321154914_23qe0 NZ0010 2026-03-23T12:10:34.441Z 2026-03-29T12:20:30.287Z
9548889 9548889 20260321154539_V2mdQ NZ0010 2026-03-22T12:16:08.655Z 2026-03-29T12:20:30.026Z
9548537 9548537 20260321151209_H4Ynh NZ0010 2026-03-22T12:15:33.122Z 2026-03-29T12:20:27.066Z
9548479 9548479 20260321150759_mBYUY NZ0010 2026-03-22T12:15:28.496Z 2026-03-29T12:20:26.693Z
9548319 9548319 20260321145221_vMZsk NZ0010 2026-03-22T12:15:14.919Z 2026-03-29T12:20:25.342Z
9548300 9548300 20260321145132_1zkOc NZ0010 2026-03-22T12:15:11.278Z 2026-03-29T12:20:25.229Z
9548258 9548258 20260321144816_ZlwcY NZ0010 2026-03-22T12:15:07.690Z 2026-03-22T12:27:38.643Z
9547127 9547127 20260321125450_2Pk1V NZ0010 2026-03-22T12:13:03.769Z 2026-03-29T12:20:07.124Z
9547094 9547094 20260321125141_LI5H5 NZ0010 2026-03-22T12:12:58.483Z 2026-03-29T12:20:06.723Z
9546876 9546876 20260321123517_fT2kB NZ0010 2026-03-22T12:12:33.380Z 2026-03-29T12:20:04.935Z
9433768 9433768 20260306114407_h2Md1 NZ0010 2026-03-07T14:09:16.749Z 2026-03-14T12:40:00.731Z
9433096 9433096 20260306095725_sDUXH NZ0010 2026-03-07T14:07:13.517Z 2026-03-14T12:39:52.817Z
9432944 9432944 20260306092947_5wpSW NZ0010 2026-03-07T14:06:43.358Z 2026-03-14T12:39:49.867Z
9432940 9432940 20260306092946_37u1R NZ0010 2026-03-07T14:06:42.945Z 2026-03-14T12:39:49.818Z
9429986 9429986 20260305170243_2w2MV NZ0010 2026-03-06T14:17:50.753Z 2026-03-13T12:35:37.913Z
9429476 9429476 20260305155151_9tQXQ NZ0010 2026-03-06T14:16:16.099Z 2026-03-13T12:35:32.438Z
9429160 9429160 20260305145912_FMn1p NZ0010 2026-03-06T14:15:19.070Z 2026-03-13T12:35:29.651Z
9429118 9429118 20260305145409_CMHpi NZ0010 2026-03-06T14:15:10.941Z 2026-03-13T12:35:29.184Z
9428117 9428117 20260305114929_Fqxrz NZ0010 2026-03-06T14:11:41.181Z 2026-03-13T12:35:05.988Z
9427385 9427385 20260305091649_FVXf2 NZ0010 2026-03-06T14:08:57.921Z 2026-03-13T12:34:58.154Z
9427382 9427382 20260305091643_FlVyG NZ0010 2026-03-06T14:08:56.041Z 2026-03-13T12:34:58.120Z
9427304 9427304 20260305085528_dAJTM NZ0010 2026-03-06T14:08:34.658Z 2026-03-13T12:34:57.253Z
9427264 9427264 20260305084251_bxtkH NZ0010 2026-03-06T14:08:25.323Z 2026-03-13T12:34:56.728Z
9427221 9427221 20260305083518_omT40 NZ0010 2026-03-06T14:08:17.035Z 2026-03-13T12:34:56.421Z
9427136 9427136 20260305080804_dx7XZ NZ0010 2026-03-06T14:07:56.295Z 2026-03-13T12:34:55.536Z
9425179 9425179 20260303170401_5wVNQ NZ0010 2026-03-05T14:14:12.990Z 2026-03-11T12:28:46.888Z
9425139 9425139 20260303164142_qJMdK NZ0010 2026-03-05T14:14:08.419Z 2026-03-11T12:28:46.533Z
9425122 9425122 20260303163735_tdpcf NZ0010 2026-03-05T14:14:06.964Z 2026-03-11T12:28:44.931Z
9425086 9425086 20260303162433_MZI7I NZ0010 2026-03-05T14:14:01.950Z 2026-03-11T12:28:44.603Z

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