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 = "NZ0022" 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
9610029 9610029 20260405120045_iWgur NZ0022 2026-04-06T12:05:20.136Z 2026-04-09T12:36:18.548Z
9609855 9609855 20260405103706_Zp9bv NZ0022 2026-04-06T12:04:20.601Z 2026-04-09T12:36:10.991Z
9609832 9609832 20260405102546_DRgyN NZ0022 2026-04-06T12:04:11.596Z 2026-04-09T12:36:10.253Z
9609811 9609811 20260405101416_3oWbE NZ0022 2026-04-06T12:03:59.933Z 2026-04-09T12:36:09.425Z
9609788 9609788 20260405100041_435f5 NZ0022 2026-04-06T12:03:52.741Z 2026-04-09T12:36:08.302Z
9609763 9609763 20260405094626_En2XN NZ0022 2026-04-06T12:03:46.555Z 2026-04-09T12:36:07.273Z
9609535 9609535 20260405075348_y6SXj NZ0022 2026-04-06T12:02:24.904Z 2026-04-09T12:35:50.123Z
9603319 9603319 20260402093201_mV4Et NZ0022 2026-04-03T12:02:36.294Z 2026-04-09T12:43:24.957Z
9603048 9603048 20260402072027_h2R80 NZ0022 2026-04-03T12:01:34.464Z 2026-04-09T12:43:18.843Z
9600869 9600869 20260401072513_NxiUM NZ0022 2026-04-02T12:00:44.643Z 2026-04-09T12:45:15.269Z
9599936 9599936 20260331173328_Jtnpf NZ0022 2026-04-01T12:05:21.720Z 2026-04-09T12:48:03.303Z
9599928 9599928 20260331172955_0k98m NZ0022 2026-04-01T12:05:19.922Z 2026-04-09T12:48:02.613Z
9599901 9599901 20260331172029_1ZtKf NZ0022 2026-04-01T12:05:12.597Z 2026-04-09T12:47:59.722Z
9599871 9599871 20260331171040_2chwB NZ0022 2026-04-01T12:05:06.592Z 2026-04-09T12:47:56.360Z
9599841 9599841 20260331170702_6IXUu NZ0022 2026-04-01T12:05:02.192Z 2026-04-09T12:47:38.953Z
9599808 9599808 20260331165904_wVgKo NZ0022 2026-04-01T12:04:55.434Z 2026-04-09T12:47:32.951Z
9599796 9599796 20260331165401_efuo4 NZ0022 2026-04-01T12:04:51.917Z 2026-04-09T12:47:32.432Z
9599778 9599778 20260331164704_AR5xa NZ0022 2026-04-01T12:04:48.632Z 2026-04-09T12:47:30.282Z
9598907 9598907 20260331084725_YlZmk NZ0022 2026-04-01T12:01:31.199Z 2026-04-09T12:46:37.794Z
9598876 9598876 20260331081912_jPkQb NZ0022 2026-04-01T12:01:23.203Z 2026-04-09T12:46:37.286Z
9598858 9598858 20260331080102_dEHm0 NZ0022 2026-04-01T12:01:20.277Z 2026-04-09T12:46:36.873Z
9598856 9598856 20260331080102_HsBih NZ0022 2026-04-01T12:01:19.856Z 2026-04-09T12:46:36.872Z
9598850 9598850 20260331080102_cqQB7 NZ0022 2026-04-01T12:01:19.247Z 2026-04-09T12:46:36.847Z
9597927 9597927 20260330171611_NcC6J NZ0022 2026-03-31T12:07:17.837Z 2026-04-08T12:44:20.857Z
9597738 9597738 20260330165520_59I4d NZ0022 2026-03-31T12:06:57.127Z 2026-04-08T12:44:16.512Z
9597699 9597699 20260330165055_BL53F NZ0022 2026-03-31T12:06:53.778Z 2026-04-08T12:44:15.661Z
9597689 9597689 20260330165016_wPxrN NZ0022 2026-03-31T12:06:53.027Z 2026-04-08T12:44:15.526Z
9597640 9597640 20260330164723_rN3HG NZ0022 2026-03-31T12:06:49.704Z 2026-04-08T12:44:12.726Z
9597625 9597625 20260330164620_ci3GE NZ0022 2026-03-31T12:06:48.330Z 2026-04-08T12:44:06.775Z
9597518 9597518 20260330162926_Xqrx4 NZ0022 2026-03-31T12:06:31.900Z 2026-04-08T12:43:44.798Z
9597464 9597464 20260330162215_IMoGS NZ0022 2026-03-31T12:06:26.670Z 2026-04-08T12:43:43.647Z
9597451 9597451 20260330162155_Eru1d NZ0022 2026-03-31T12:06:25.734Z 2026-04-08T12:43:43.480Z
9597344 9597344 20260330160830_sccsM NZ0022 2026-03-31T12:06:12.798Z 2026-04-08T12:43:40.959Z
9597238 9597238 20260330154712_8cA27 NZ0022 2026-03-31T12:06:00.526Z 2026-04-08T12:43:36.822Z
9597093 9597093 20260330151319_aa0Dd NZ0022 2026-03-31T12:05:38.695Z 2026-04-08T12:43:32.766Z
9596978 9596978 20260330145212_y5ZwK NZ0022 2026-03-31T12:05:24.495Z 2026-04-08T12:43:29.477Z
9595000 9595000 20260323151203_GgLiI NZ0022 2026-03-30T12:26:14.745Z 2026-03-31T12:28:13.429Z
9578173 9578173 20260325103917_bLUdS NZ0022 2026-03-26T12:06:54.476Z 2026-04-03T12:37:42.089Z
9578157 9578157 20260325103429_DtlZu NZ0022 2026-03-26T12:06:52.041Z 2026-04-03T12:37:41.583Z
9574791 9574791 20260323172153_xVHpv NZ0022 2026-03-25T12:19:42.016Z 2026-03-31T12:28:42.168Z
9569740 9569740 20260322171222_X21Lk NZ0022 2026-03-24T12:21:57.001Z 2026-03-30T12:30:18.653Z
9569592 9569592 20260322162403_E6Lw8 NZ0022 2026-03-24T12:21:28.703Z 2026-03-30T12:30:10.753Z
9568852 9568852 20260322101825_sZH3i NZ0022 2026-03-24T12:18:33.284Z 2026-03-30T12:28:59.138Z
9568830 9568830 20260322095418_lDCv7 NZ0022 2026-03-24T12:18:26.092Z 2026-03-30T12:28:56.260Z
9568762 9568762 20260323171942_2qvxN NZ0022 2026-03-24T12:15:41.846Z 2026-03-31T12:28:41.639Z
9568608 9568608 20260323170240_9rLoc NZ0022 2026-03-24T12:15:22.403Z 2026-03-31T12:28:38.649Z
9568272 9568272 20260323162644_wW2Zz NZ0022 2026-03-24T12:14:49.656Z 2026-03-31T12:28:26.780Z
9568132 9568132 20260323161604_xztOJ NZ0022 2026-03-24T12:14:36.657Z 2026-03-31T12:28:23.426Z
9568056 9568056 20260323161056_08MI3 NZ0022 2026-03-24T12:14:28.065Z 2026-03-31T12:28:22.456Z
9568032 9568032 20260323160807_MHf3v NZ0022 2026-03-24T12:14:26.360Z 2026-03-31T12:28:21.986Z
9568011 9568011 20260323160635_TNvon NZ0022 2026-03-24T12:14:23.586Z 2026-03-31T12:28:21.604Z
9567729 9567729 20260323154425_DNvXB NZ0022 2026-03-24T12:14:04.352Z 2026-03-31T12:28:17.964Z
9567445 9567445 20260323151616_hGxim NZ0022 2026-03-24T12:13:37.881Z 2026-03-31T12:28:14.212Z
9567400 9567400 20260323151329_arSvd NZ0022 2026-03-24T12:13:31.400Z 2026-03-31T12:28:13.742Z
9567286 9567286 20260323150233_XoN3q NZ0022 2026-03-24T12:13:20.665Z 2026-03-31T12:28:12.054Z
9567151 9567151 20260323144626_r18GB NZ0022 2026-03-24T12:13:08.074Z 2026-03-31T12:28:09.370Z
9567086 9567086 20260323143758_Jo7xf NZ0022 2026-03-24T12:12:58.976Z 2026-03-31T12:28:08.243Z
9567072 9567072 20260323143631_hHo0O NZ0022 2026-03-24T12:12:55.683Z 2026-03-31T12:28:07.910Z
9567051 9567051 20260323143538_TXlfg NZ0022 2026-03-24T12:12:54.132Z 2026-03-31T12:28:07.707Z
9566999 9566999 20260323143145_U3325 NZ0022 2026-03-24T12:12:50.507Z 2026-03-31T12:28:07.083Z
9566973 9566973 20260323143115_VS830 NZ0022 2026-03-24T12:12:47.627Z 2026-03-31T12:28:06.732Z
9566943 9566943 20260323142947_VbjWM NZ0022 2026-03-24T12:12:45.203Z 2026-03-31T12:28:06.316Z
9566747 9566747 20260323140956_EfrCn NZ0022 2026-03-24T12:12:23.566Z 2026-03-31T12:27:56.422Z
9566694 9566694 20260323140621_O2F11 NZ0022 2026-03-24T12:12:20.033Z 2026-03-31T12:27:55.754Z
9566664 9566664 20260323140238_9EgfK NZ0022 2026-03-24T12:12:16.943Z 2026-03-31T12:27:55.252Z
9566634 9566634 20260323135837_xXRFF NZ0022 2026-03-24T12:12:14.001Z 2026-03-31T12:27:54.872Z
9566583 9566583 20260323135557_znGF4 NZ0022 2026-03-24T12:12:09.673Z 2026-03-31T12:27:54.216Z
9566568 9566568 20260323135529_KxwMN NZ0022 2026-03-24T12:12:08.060Z 2026-03-31T12:27:53.887Z
9566459 9566459 20260323133957_in3wd NZ0022 2026-03-24T12:11:53.484Z 2026-03-31T12:27:52.145Z
9566321 9566321 20260323132439_upEXQ NZ0022 2026-03-24T12:11:40.486Z 2026-03-31T12:27:48.778Z
9566257 9566257 20260323131824_E2soM NZ0022 2026-03-24T12:11:32.145Z 2026-03-31T12:27:47.803Z
9565884 9565884 20260323124822_LWRwH NZ0022 2026-03-24T12:10:58.697Z 2026-03-31T12:27:42.866Z
9565688 9565688 20260323123315_wEilM NZ0022 2026-03-24T12:10:39.329Z 2026-03-31T12:27:39.826Z
9565668 9565668 20260323123259_lLOAd NZ0022 2026-03-24T12:10:37.938Z 2026-03-31T12:27:39.577Z
9565528 9565528 20260323121638_rVNBo NZ0022 2026-03-24T12:10:21.268Z 2026-03-31T12:27:37.014Z
9565327 9565327 20260323120107_5HDc2 NZ0022 2026-03-24T12:09:53.819Z 2026-03-31T12:27:33.299Z
9565241 9565241 20260323115258_uB2AR NZ0022 2026-03-24T12:09:42.643Z 2026-03-31T12:27:31.701Z
9565206 9565206 20260323115015_spt3j NZ0022 2026-03-24T12:09:37.639Z 2026-03-31T12:27:30.987Z
9565169 9565169 20260323114800_tHr2m NZ0022 2026-03-24T12:09:32.908Z 2026-03-31T12:27:29.759Z
9565135 9565135 20260323114633_H9SR5 NZ0022 2026-03-24T12:09:28.133Z 2026-03-31T12:27:23.327Z
9565114 9565114 20260323114522_FYf4Z NZ0022 2026-03-24T12:09:26.807Z 2026-03-31T12:27:23.176Z
9564817 9564817 20260323111014_8FDTr NZ0022 2026-03-24T12:08:51.162Z 2026-03-31T12:27:15.931Z
9564803 9564803 20260323110954_7myV4 NZ0022 2026-03-24T12:08:50.190Z 2026-03-31T12:27:15.759Z
9564746 9564746 20260323110626_Gd4tv NZ0022 2026-03-24T12:08:44.585Z 2026-03-31T12:27:14.896Z
9564628 9564628 20260323105824_sMvD4 NZ0022 2026-03-24T12:08:29.800Z 2026-03-31T12:27:12.850Z
9564169 9564169 20260323100710_m2iHe NZ0022 2026-03-24T12:07:33.130Z 2026-03-31T12:27:04.172Z
9564149 9564149 20260323100423_eFg3d NZ0022 2026-03-24T12:07:30.454Z 2026-03-31T12:27:03.514Z
9564053 9564053 20260323095341_ObbNP NZ0022 2026-03-24T12:07:20.068Z 2026-03-31T12:27:01.629Z
9564030 9564030 20260323095058_Voj39 NZ0022 2026-03-24T12:07:14.648Z 2026-03-31T12:27:01.171Z
9563918 9563918 20260323093404_tc7ir NZ0022 2026-03-24T12:07:00.250Z 2026-03-31T12:26:59.128Z
9563777 9563777 20260323090839_YJxys NZ0022 2026-03-24T12:06:42.863Z 2026-03-31T12:26:54.211Z
9563564 9563564 20260323084250_dtfBD NZ0022 2026-03-24T12:06:15.758Z 2026-03-31T12:26:46.924Z
9563525 9563525 20260323082920_o0HCG NZ0022 2026-03-24T12:06:10.537Z 2026-03-31T12:26:46.236Z
9563252 9563252 20260323074718_MAByD NZ0022 2026-03-24T12:05:36.460Z 2026-03-31T12:26:39.293Z
9559464 9559464 20260321172220_2Y4DA NZ0022 2026-03-23T12:11:06.934Z 2026-03-29T12:20:39.605Z
9559339 9559339 20260321165834_FBNWP NZ0022 2026-03-23T12:11:02.277Z 2026-03-29T12:20:37.861Z
9559330 9559330 20260321165728_WYby3 NZ0022 2026-03-23T12:11:01.944Z 2026-03-29T12:20:37.618Z
9559212 9559212 20260321164702_7R4bR NZ0022 2026-03-23T12:10:58.000Z 2026-03-29T12:20:35.308Z
9559163 9559163 20260321164144_2Jb53 NZ0022 2026-03-23T12:10:56.224Z 2026-03-29T12:20:34.794Z
9559068 9559068 20260321162600_fZAY3 NZ0022 2026-03-23T12:10:53.029Z 2026-03-29T12:20:33.634Z

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