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 = "NZ0001" 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
9627409 9627409 20260408172820_FBQdS NZ0001 2026-04-09T12:10:52.000Z 2026-04-10T12:14:22.539Z
9627317 9627317 20260408170647_keaHM NZ0001 2026-04-09T12:10:38.891Z 2026-04-10T12:14:22.522Z
9627304 9627304 20260408170259_rdJf1 NZ0001 2026-04-09T12:10:36.053Z 2026-04-10T12:14:22.519Z
9627059 9627059 20260408160651_2Izep NZ0001 2026-04-09T12:09:52.759Z 2026-04-10T12:14:22.472Z
9625888 9625888 20260408122213_8L9LX NZ0001 2026-04-09T12:07:03.672Z 2026-04-10T12:14:22.260Z
9625739 9625739 20260408114200_1j6mP NZ0001 2026-04-09T12:06:33.582Z 2026-04-10T12:14:22.233Z
9625620 9625620 20260408112734_ylcpU NZ0001 2026-04-09T12:06:08.967Z 2026-04-10T12:14:22.214Z
9625164 9625164 20260408094743_t12pr NZ0001 2026-04-09T12:04:33.270Z 2026-04-10T12:14:21.870Z
9625099 9625099 20260408093651_Gq8RC NZ0001 2026-04-09T12:04:15.569Z 2026-04-10T12:14:21.854Z
9624999 9624999 20260408090943_WSjNf NZ0001 2026-04-09T12:03:45.659Z 2026-04-10T12:14:21.829Z
9624907 9624907 20260408085351_C37pd NZ0001 2026-04-09T12:03:24.783Z 2026-04-10T12:14:21.809Z
9624688 9624688 20260408080944_3Jp5J NZ0001 2026-04-09T12:02:31.888Z 2026-04-10T12:14:21.438Z
9616742 9616742 20260402120318_uVVCj NZ0001 2026-04-07T12:19:33.424Z 2026-04-10T12:34:08.585Z
9616734 9616734 20260402100816_Kn5kv NZ0001 2026-04-07T12:19:13.335Z 2026-04-10T12:34:01.524Z
9606166 9606166 20260403155042_ei15y NZ0001 2026-04-04T12:05:42.096Z 2026-04-10T12:32:23.327Z
9605964 9605964 20260403133535_wBVSH NZ0001 2026-04-04T12:04:40.740Z 2026-04-10T12:32:17.157Z
9605608 9605608 20260403105955_Uwtc9 NZ0001 2026-04-04T12:03:02.921Z 2026-04-10T12:31:39.496Z
9605449 9605449 20260403100240_6Z8IO NZ0001 2026-04-04T12:02:23.859Z 2026-04-10T12:31:36.240Z
9605177 9605177 20260403073134_ejzgg NZ0001 2026-04-04T12:01:00.524Z 2026-04-10T12:31:30.107Z
9605157 9605157 20260403072026_mnFbx NZ0001 2026-04-04T12:00:56.990Z 2026-04-10T12:31:29.691Z
9605143 9605143 20260403070757_N55cA NZ0001 2026-04-04T12:00:54.149Z 2026-04-10T12:31:29.438Z
9604154 9604154 20260402161432_SzV9o NZ0001 2026-04-03T12:06:13.187Z 2026-04-10T12:34:43.842Z
9603949 9603949 20260402141859_FeNLS NZ0001 2026-04-03T12:05:18.799Z 2026-04-10T12:34:16.433Z
9603940 9603940 20260402141137_G2Y8J NZ0001 2026-04-03T12:05:16.308Z 2026-04-10T12:34:16.032Z
9603906 9603906 20260402133802_EhNm4 NZ0001 2026-04-03T12:05:04.224Z 2026-04-10T12:34:15.284Z
9603884 9603884 20260402132229_sZO71 NZ0001 2026-04-03T12:04:57.473Z 2026-04-10T12:34:14.327Z
9603762 9603762 20260402121508_2zO6I NZ0001 2026-04-03T12:04:27.809Z 2026-04-10T12:34:09.093Z
9603725 9603725 20260402115833_2GSM3 NZ0001 2026-04-03T12:04:19.111Z 2026-04-10T12:34:08.099Z
9603668 9603668 20260402114312_BQzSm NZ0001 2026-04-03T12:04:01.563Z 2026-04-10T12:34:06.819Z
9603599 9603599 20260402111643_z59fo NZ0001 2026-04-03T12:03:46.070Z 2026-04-10T12:34:05.133Z
9603424 9603424 20260402101012_cdeL5 NZ0001 2026-04-03T12:03:03.045Z 2026-04-10T12:34:01.755Z
9603408 9603408 20260402100450_Kx97g NZ0001 2026-04-03T12:02:51.870Z 2026-04-10T12:34:01.349Z
9603355 9603355 20260402094314_ZXpvO NZ0001 2026-04-03T12:02:42.091Z 2026-04-10T12:34:00.493Z
9603301 9603301 20260402092552_4fVSI NZ0001 2026-04-03T12:02:32.945Z 2026-04-10T12:33:59.510Z
9603291 9603291 20260402092304_WDRGn NZ0001 2026-04-03T12:02:31.284Z 2026-04-10T12:33:59.350Z
9603049 9603049 20260402072118_6UC2M NZ0001 2026-04-03T12:01:35.044Z 2026-04-10T12:33:42.495Z
9602002 9602002 20260401174738_lFJDb NZ0001 2026-04-02T12:04:29.120Z 2026-04-10T12:35:51.496Z
9601935 9601935 20260401172833_Xh76Z NZ0001 2026-04-02T12:04:14.073Z 2026-04-10T12:35:50.039Z
9601782 9601782 20260401170136_BOxRL NZ0001 2026-04-02T12:03:42.229Z 2026-04-10T12:35:47.325Z
9600898 9600898 20260401082631_zLm2p NZ0001 2026-04-02T12:00:54.134Z 2026-04-10T12:35:29.199Z
9596670 9596670 20260330133950_xyYs3 NZ0001 2026-03-31T12:04:41.304Z 2026-04-08T12:43:21.878Z
9596668 9596668 20260330133935_R9Vx4 NZ0001 2026-03-31T12:04:41.022Z 2026-04-08T12:43:21.813Z
9596490 9596490 20260330124918_yBBzc NZ0001 2026-03-31T12:04:24.236Z 2026-04-08T12:43:17.907Z
9596410 9596410 20260330123113_bBNe3 NZ0001 2026-03-31T12:04:11.404Z 2026-04-08T12:42:53.488Z
9596325 9596325 20260330121937_CPXQG NZ0001 2026-03-31T12:04:02.715Z 2026-04-08T12:42:49.759Z
9596294 9596294 20260330121126_Tyred NZ0001 2026-03-31T12:03:57.678Z 2026-04-08T12:42:48.753Z
9596264 9596264 20260330120016_Iqajj NZ0001 2026-03-31T12:03:51.905Z 2026-04-08T12:42:47.850Z
9596122 9596122 20260330111734_cfBZB NZ0001 2026-03-31T12:03:32.145Z 2026-04-08T12:42:41.962Z
9596000 9596000 20260330103519_11V3U NZ0001 2026-03-31T12:03:06.120Z 2026-04-08T12:42:38.160Z
9595943 9595943 20260330101303_l82TU NZ0001 2026-03-31T12:02:57.771Z 2026-04-08T12:42:36.962Z
9595939 9595939 20260330101302_qAxQq NZ0001 2026-03-31T12:02:55.912Z 2026-04-08T12:42:36.920Z
9595889 9595889 20260330094223_U2U88 NZ0001 2026-03-31T12:02:45.665Z 2026-04-08T12:42:35.202Z
9595838 9595838 20260330091854_Gp4vt NZ0001 2026-03-31T12:02:40.133Z 2026-04-08T12:42:34.104Z
9595830 9595830 20260330091130_aQgaq NZ0001 2026-03-31T12:02:38.905Z 2026-04-08T12:42:33.934Z
9591097 9591097 20260328131631_cpFFi NZ0001 2026-03-29T12:03:50.305Z 2026-04-06T12:39:00.453Z
9591085 9591085 20260328131005_p9Q4I NZ0001 2026-03-29T12:03:48.819Z 2026-04-06T12:38:59.574Z
9591079 9591079 20260328130906_jfewM NZ0001 2026-03-29T12:03:48.440Z 2026-04-06T12:38:59.427Z
9591042 9591042 20260328124034_ChOhy NZ0001 2026-03-29T12:03:42.520Z 2026-04-06T12:38:48.171Z
9578573 9578573 20260325122121_11I2N NZ0001 2026-03-26T12:07:57.538Z 2026-04-03T12:38:08.872Z
9573992 9573992 20260324144437_mpboF NZ0001 2026-03-25T12:09:21.958Z 2026-04-02T12:36:33.881Z
9573340 9573340 20260324115323_cQI7Y NZ0001 2026-03-25T12:07:46.307Z 2026-04-02T12:36:05.469Z
9573106 9573106 20260324112152_gvTSS NZ0001 2026-03-25T12:07:12.546Z 2026-04-02T12:35:56.153Z
9573001 9573001 20260324110537_MNlYi NZ0001 2026-03-25T12:06:58.304Z 2026-04-02T12:35:52.282Z
9572608 9572608 20260324093738_D2Dka NZ0001 2026-03-25T12:05:44.833Z 2026-04-02T12:35:31.611Z
9572204 9572204 20260324080440_YtNIS NZ0001 2026-03-25T12:04:15.264Z 2026-04-02T12:35:07.864Z
9569571 9569571 20260322161508_2di0U NZ0001 2026-03-24T12:21:24.540Z 2026-03-30T12:30:09.582Z
9569569 9569569 20260322161503_TBFd2 NZ0001 2026-03-24T12:21:24.257Z 2026-03-30T12:30:09.526Z
9569219 9569219 20260322141513_xst8P NZ0001 2026-03-24T12:20:13.325Z 2026-03-30T12:29:39.683Z
9569128 9569128 20260322133137_wJmyj NZ0001 2026-03-24T12:19:51.194Z 2026-03-30T12:29:34.208Z
9569111 9569111 20260322132747_w3Q79 NZ0001 2026-03-24T12:19:49.788Z 2026-03-30T12:29:33.765Z
9569044 9569044 20260322124859_fSIlP NZ0001 2026-03-24T12:19:31.335Z 2026-03-30T12:29:20.822Z
9568787 9568787 20260322080533_JdECh NZ0001 2026-03-24T12:17:55.736Z 2026-03-30T12:28:35.836Z
9568783 9568783 20260322080411_iolD3 NZ0001 2026-03-24T12:17:54.911Z 2026-03-30T12:28:35.501Z
9568473 9568473 20260323164735_3M3If NZ0001 2026-03-24T12:15:10.349Z 2026-03-31T12:28:29.733Z
9568388 9568388 20260323163959_YljFT NZ0001 2026-03-24T12:15:03.114Z 2026-03-31T12:28:28.637Z
9568337 9568337 20260323163302_LHH1A NZ0001 2026-03-24T12:14:53.979Z 2026-03-31T12:28:27.509Z
9568245 9568245 20260323162439_3kaez NZ0001 2026-03-24T12:14:46.947Z 2026-03-31T12:28:26.366Z
9568229 9568229 20260323162205_1Na2P NZ0001 2026-03-24T12:14:45.322Z 2026-03-31T12:28:26.056Z
9568168 9568168 20260323161710_rmi5k NZ0001 2026-03-24T12:14:39.529Z 2026-03-31T12:28:23.949Z
9567797 9567797 20260323155023_Wdg2G NZ0001 2026-03-24T12:14:09.677Z 2026-03-31T12:28:19.054Z
9567695 9567695 20260323154113_4ed0O NZ0001 2026-03-24T12:13:59.184Z 2026-03-31T12:28:17.556Z
9567457 9567457 20260323151706_YkBVo NZ0001 2026-03-24T12:13:38.512Z 2026-03-31T12:28:14.276Z
9567415 9567415 20260323151428_JffQz NZ0001 2026-03-24T12:13:34.975Z 2026-03-31T12:28:13.859Z
9567357 9567357 20260323150951_bmvNI NZ0001 2026-03-24T12:13:27.410Z 2026-03-31T12:28:13.164Z
9567218 9567218 20260323145344_OUkCC NZ0001 2026-03-24T12:13:14.212Z 2026-03-31T12:28:10.538Z
9567147 9567147 20260323144622_GQ2Dj NZ0001 2026-03-24T12:13:07.126Z 2026-03-31T12:28:09.194Z
9566808 9566808 20260323141532_gs42U NZ0001 2026-03-24T12:12:28.306Z 2026-03-31T12:28:04.552Z
9566716 9566716 20260323140748_7Qwt3 NZ0001 2026-03-24T12:12:21.622Z 2026-03-31T12:27:56.108Z
9566710 9566710 20260323140705_QUAh8 NZ0001 2026-03-24T12:12:21.295Z 2026-03-31T12:27:56.049Z
9566331 9566331 20260323132546_neJoH NZ0001 2026-03-24T12:11:41.335Z 2026-03-31T12:27:48.862Z
9566127 9566127 20260323130829_NO0yl NZ0001 2026-03-24T12:11:23.157Z 2026-03-31T12:27:46.427Z
9566026 9566026 20260323130036_sriXT NZ0001 2026-03-24T12:11:14.122Z 2026-03-31T12:27:45.009Z
9565988 9565988 20260323125609_ZkYDv NZ0001 2026-03-24T12:11:10.680Z 2026-03-31T12:27:44.494Z
9565955 9565955 20260323125458_auhqx NZ0001 2026-03-24T12:11:06.499Z 2026-03-31T12:27:44.035Z
9565926 9565926 20260323125201_K1K3T NZ0001 2026-03-24T12:11:02.017Z 2026-03-31T12:27:43.559Z
9565903 9565903 20260323125032_Q8iSH NZ0001 2026-03-24T12:11:01.022Z 2026-03-31T12:27:43.334Z
9565824 9565824 20260323124241_068kY NZ0001 2026-03-24T12:10:54.984Z 2026-03-31T12:27:42.095Z
9565604 9565604 20260323122450_cGylD NZ0001 2026-03-24T12:10:29.252Z 2026-03-31T12:27:38.149Z
9565500 9565500 20260323121425_RvZC0 NZ0001 2026-03-24T12:10:18.671Z 2026-03-31T12:27:36.684Z
9565316 9565316 20260323120013_b4WYs NZ0001 2026-03-24T12:09:52.716Z 2026-03-31T12:27:33.222Z

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