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 = "NZ002W" 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
9626954 9626954 20260408153621_u6jtP NZ002W 2026-04-09T12:09:37.456Z 2026-04-10T12:14:22.444Z
9609656 9609656 20260405090005_lJeAC NZ002W 2026-04-06T12:03:08.357Z 2026-04-10T12:26:20.649Z
9606369 9606369 20260403173655_21tkI NZ002W 2026-04-04T12:06:36.876Z 2026-04-10T12:32:28.734Z
9605852 9605852 20260403121936_QF7B4 NZ002W 2026-04-04T12:04:08.660Z 2026-04-10T12:31:48.496Z
9605347 9605347 20260403085430_fOXwc NZ002W 2026-04-04T12:01:52.005Z 2026-04-10T12:31:33.938Z
9603364 9603364 20260402094402_mDEZA NZ002W 2026-04-03T12:02:43.146Z 2026-04-10T12:34:00.658Z
9603322 9603322 20260402093201_mV4Et NZ002W 2026-04-03T12:02:36.294Z 2026-04-10T12:33:59.944Z
9603237 9603237 20260402090108_ffPqb NZ002W 2026-04-03T12:02:15.512Z 2026-04-10T12:33:58.453Z
9601672 9601672 20260401162823_h7yI8 NZ002W 2026-04-02T12:03:26.117Z 2026-04-10T12:35:43.434Z
9600999 9600999 20260401101911_Nys7D NZ002W 2026-04-02T12:01:15.252Z 2026-04-10T12:35:31.431Z
9600871 9600871 20260401072513_NxiUM NZ002W 2026-04-02T12:00:44.665Z 2026-04-10T12:35:24.398Z
9599391 9599391 20260331142425_nwm3D NZ002W 2026-04-01T12:03:26.136Z 2026-04-09T12:46:46.943Z
9599152 9599152 20260331121306_vaill NZ002W 2026-04-01T12:02:32.926Z 2026-04-09T12:46:42.498Z
9599128 9599128 20260331115610_lEonM NZ002W 2026-04-01T12:02:28.402Z 2026-04-09T12:46:42.089Z
9598822 9598822 20260331074010_p6EmH NZ002W 2026-04-01T12:01:13.052Z 2026-04-09T12:46:36.405Z
9597424 9597424 20260330161719_kEaqM NZ002W 2026-03-31T12:06:22.375Z 2026-04-08T12:43:42.689Z
9597366 9597366 20260330161126_EogyG NZ002W 2026-03-31T12:06:14.484Z 2026-04-08T12:43:41.416Z
9597309 9597309 20260330155942_0hf2c NZ002W 2026-03-31T12:06:06.807Z 2026-04-08T12:43:40.229Z
9597243 9597243 20260330154712_8cA27 NZ002W 2026-03-31T12:06:00.526Z 2026-04-08T12:43:36.822Z
9597189 9597189 20260330153333_2KGJs NZ002W 2026-03-31T12:05:52.191Z 2026-04-08T12:43:35.100Z
9597162 9597162 20260330152955_kMiWr NZ002W 2026-03-31T12:05:49.779Z 2026-04-08T12:43:34.742Z
9597115 9597115 20260330151847_UR6A0 NZ002W 2026-03-31T12:05:41.195Z 2026-04-08T12:43:33.155Z
9597072 9597072 20260330150918_N258C NZ002W 2026-03-31T12:05:36.785Z 2026-04-08T12:43:32.063Z
9597046 9597046 20260330150633_o8278 NZ002W 2026-03-31T12:05:34.045Z 2026-04-08T12:43:31.537Z
9596829 9596829 20260330141104_arupn NZ002W 2026-03-31T12:05:02.449Z 2026-04-08T12:43:25.374Z
9596765 9596765 20260330135651_3Tgyx NZ002W 2026-03-31T12:04:55.199Z 2026-04-08T12:43:23.931Z
9596465 9596465 20260330124353_1ktyM NZ002W 2026-03-31T12:04:19.439Z 2026-04-08T12:43:13.620Z
9596407 9596407 20260330123106_J17nD NZ002W 2026-03-31T12:04:11.014Z 2026-04-08T12:42:53.480Z
9596356 9596356 20260330122307_furic NZ002W 2026-03-31T12:04:05.279Z 2026-04-08T12:42:50.234Z
9596317 9596317 20260330121858_Nnfrt NZ002W 2026-03-31T12:04:01.325Z 2026-04-08T12:42:49.390Z
9596132 9596132 20260330112241_1h68t NZ002W 2026-03-31T12:03:33.735Z 2026-04-08T12:42:42.170Z
9595646 9595646 20260330073807_ZR39V NZ002W 2026-03-31T12:02:04.372Z 2026-04-08T12:42:28.154Z
9591533 9591533 20260328170336_60pxZ NZ002W 2026-03-29T12:04:33.217Z 2026-04-06T12:39:21.813Z
9591518 9591518 20260328170111_Yz7yH NZ002W 2026-03-29T12:04:31.982Z 2026-04-06T12:39:19.350Z
9587943 9587943 20260327165715_txHlc NZ002W 2026-03-28T12:06:46.188Z 2026-04-05T12:35:00.612Z
9587821 9587821 20260327161522_2dGTu NZ002W 2026-03-28T12:06:25.983Z 2026-04-05T12:34:45.144Z
9587600 9587600 20260327142800_ZIpzu NZ002W 2026-03-28T12:05:53.575Z 2026-04-05T12:34:33.149Z
9569606 9569606 20260322162403_oKvs3 NZ002W 2026-03-24T12:21:28.898Z 2026-03-30T12:30:10.763Z
9569596 9569596 20260322162403_E6Lw8 NZ002W 2026-03-24T12:21:28.703Z 2026-03-30T12:30:10.753Z
9567088 9567088 20260323143758_Jo7xf NZ002W 2026-03-24T12:12:58.976Z 2026-03-31T12:28:08.243Z
9567053 9567053 20260323143538_TXlfg NZ002W 2026-03-24T12:12:54.132Z 2026-03-31T12:28:07.708Z
9566571 9566571 20260323135529_KxwMN NZ002W 2026-03-24T12:12:08.060Z 2026-03-31T12:27:53.887Z
9566323 9566323 20260323132439_upEXQ NZ002W 2026-03-24T12:11:40.486Z 2026-03-31T12:27:48.778Z
9566259 9566259 20260323131824_E2soM NZ002W 2026-03-24T12:11:32.145Z 2026-03-31T12:27:47.803Z
9566080 9566080 20260323130357_UEPV8 NZ002W 2026-03-24T12:11:19.319Z 2026-03-31T12:27:45.892Z
9565798 9565798 20260323124139_W92J9 NZ002W 2026-03-24T12:10:52.789Z 2026-03-31T12:27:41.665Z
9565548 9565548 20260323121841_M6XmO NZ002W 2026-03-24T12:10:23.094Z 2026-03-31T12:27:37.336Z
9565530 9565530 20260323121638_rVNBo NZ002W 2026-03-24T12:10:21.268Z 2026-03-31T12:27:37.014Z
9564984 9564984 20260323113402_UVMCh NZ002W 2026-03-24T12:09:11.848Z 2026-03-31T12:27:20.332Z
9564726 9564726 20260323110406_QiIYT NZ002W 2026-03-24T12:08:39.585Z 2026-03-31T12:27:14.326Z
9564719 9564719 20260323110406_4tYnQ NZ002W 2026-03-24T12:08:39.186Z 2026-03-31T12:27:14.295Z
9563194 9563194 20260323073130_wl0s7 NZ002W 2026-03-24T12:05:27.259Z 2026-03-31T12:26:37.920Z
9558862 9558862 20260321155800_MpzyV NZ002W 2026-03-23T12:10:37.522Z 2026-03-29T12:20:31.108Z
9550714 9550714 20260320170515_k3M8C NZ002W 2026-03-22T12:25:39.235Z 2026-03-28T12:36:35.356Z
9550685 9550685 20260320165943_a7IOz NZ002W 2026-03-22T12:25:36.398Z 2026-03-28T12:36:34.349Z
9550615 9550615 20260320165602_kjeXh NZ002W 2026-03-22T12:25:33.184Z 2026-03-28T12:36:33.388Z
9550561 9550561 20260320165124_Z35YP NZ002W 2026-03-22T12:25:30.444Z 2026-03-28T12:36:32.709Z
9550371 9550371 20260320163344_24Ox5 NZ002W 2026-03-22T12:25:11.969Z 2026-03-28T12:36:30.063Z
9550309 9550309 20260320162941_zQDYb NZ002W 2026-03-22T12:25:07.886Z 2026-03-28T12:36:29.438Z
9550237 9550237 20260320162303_hTtmZ NZ002W 2026-03-22T12:25:03.383Z 2026-03-28T12:36:28.583Z
9550112 9550112 20260320160853_5ginC NZ002W 2026-03-22T12:24:55.876Z 2026-03-28T12:36:27.153Z
9549561 9549561 20260320151436_qBRpE NZ002W 2026-03-22T12:24:09.663Z 2026-03-28T12:36:06.202Z
9549420 9549420 20260320145628_KmWeg NZ002W 2026-03-22T12:23:58.244Z 2026-03-28T12:36:03.426Z
9549408 9549408 20260320145550_Yzzrk NZ002W 2026-03-22T12:23:57.675Z 2026-03-28T12:36:03.277Z
9549165 9549165 20260320084948_DYnLC NZ002W 2026-03-22T12:19:46.745Z 2026-03-28T12:34:54.424Z
9546306 9546306 20260321115036_IqHc5 NZ002W 2026-03-22T12:11:27.777Z 2026-03-29T12:19:49.253Z
9540076 9540076 20260319124650_VFY76 NZ002W 2026-03-21T12:26:01.878Z 2026-03-27T12:41:57.811Z
9539976 9539976 20260319120014_Jhpds NZ002W 2026-03-21T12:25:41.512Z 2026-03-27T12:41:53.207Z
9538707 9538707 20260320133732_zVqdJ NZ002W 2026-03-21T12:18:12.594Z 2026-03-28T12:35:51.766Z
9538568 9538568 20260320132038_pJ6QD NZ002W 2026-03-21T12:17:56.907Z 2026-03-28T12:35:50.044Z
9538490 9538490 20260320131151_wqWpG NZ002W 2026-03-21T12:17:51.091Z 2026-03-28T12:35:48.957Z
9538204 9538204 20260320124059_SVMMf NZ002W 2026-03-21T12:17:16.529Z 2026-03-28T12:35:35.880Z
9537952 9537952 20260320121827_8D3G0 NZ002W 2026-03-21T12:16:51.667Z 2026-03-28T12:35:32.590Z
9537783 9537783 20260320120227_gP9e5 NZ002W 2026-03-21T12:16:28.221Z 2026-03-28T12:35:29.290Z
9537216 9537216 20260320111619_DwAoD NZ002W 2026-03-21T12:15:18.744Z 2026-03-28T12:35:23.241Z
9537126 9537126 20260320110841_CR1GO NZ002W 2026-03-21T12:15:08.121Z 2026-03-28T12:35:21.954Z
9536997 9536997 20260320105648_b42aS NZ002W 2026-03-21T12:14:51.219Z 2026-03-28T12:35:20.039Z
9536901 9536901 20260320104330_ZQBi1 NZ002W 2026-03-21T12:14:38.782Z 2026-03-28T12:35:18.549Z
9536830 9536830 20260320103643_uECh9 NZ002W 2026-03-21T12:14:29.404Z 2026-03-28T12:35:17.000Z
9536199 9536199 20260320092235_glOT5 NZ002W 2026-03-21T12:12:47.877Z 2026-03-28T12:34:58.504Z
9536099 9536099 20260320091200_N1NYE NZ002W 2026-03-21T12:12:36.484Z 2026-03-28T12:34:57.476Z
9536081 9536081 20260320091018_FWERJ NZ002W 2026-03-21T12:12:34.339Z 2026-03-28T12:34:57.291Z
9529084 9529084 20260318171218_K3gF0 NZ002W 2026-03-20T12:22:52.529Z 2026-03-26T12:38:45.130Z
9528897 9528897 20260318165400_xamhp NZ002W 2026-03-20T12:22:35.492Z 2026-03-26T12:38:38.838Z
9528758 9528758 20260318164217_e3mbT NZ002W 2026-03-20T12:22:30.227Z 2026-03-26T12:38:37.967Z
9528560 9528560 20260318162342_XnxVc NZ002W 2026-03-20T12:22:22.024Z 2026-03-26T12:38:36.836Z
9528504 9528504 20260318162104_pvydN NZ002W 2026-03-20T12:22:20.279Z 2026-03-26T12:38:36.631Z
9528470 9528470 20260318161800_0gFSr NZ002W 2026-03-20T12:22:18.483Z 2026-03-26T12:38:36.415Z
9527861 9527861 20260318152202_pg3bG NZ002W 2026-03-20T12:21:46.887Z 2026-03-26T12:38:31.820Z
9527687 9527687 20260318150605_3t6ww NZ002W 2026-03-20T12:21:38.331Z 2026-03-26T12:38:30.527Z
9526959 9526959 20260318134035_tQDGg NZ002W 2026-03-20T12:20:46.817Z 2026-03-26T12:38:24.981Z
9526925 9526925 20260318133615_c2Uk3 NZ002W 2026-03-20T12:20:45.023Z 2026-03-26T12:38:24.653Z
9526758 9526758 20260318084949_CLZhg NZ002W 2026-03-20T12:18:32.717Z 2026-03-26T12:37:53.747Z
9526586 9526586 20260319170330_wd02s NZ002W 2026-03-20T12:15:22.063Z 2026-03-27T12:42:28.051Z
9526375 9526375 20260319163329_jJWN2 NZ002W 2026-03-20T12:15:10.251Z 2026-03-27T12:42:25.595Z
9526316 9526316 20260319162647_E6XbR NZ002W 2026-03-20T12:15:06.111Z 2026-03-27T12:42:25.102Z
9526159 9526159 20260319160918_i9eOB NZ002W 2026-03-20T12:14:52.914Z 2026-03-27T12:42:23.621Z
9525988 9525988 20260319154024_TXulM NZ002W 2026-03-20T12:14:43.703Z 2026-03-27T12:42:21.707Z
9525871 9525871 20260319152839_bSzhO NZ002W 2026-03-20T12:14:39.795Z 2026-03-27T12:42:20.833Z
9525782 9525782 20260319151701_sgREx NZ002W 2026-03-20T12:14:33.571Z 2026-03-27T12:42:19.738Z

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