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

8,298 rows where station_code = "NZ0038" 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
9265930 9265930 20260127161641_h6Dlt NZ0038 2026-01-28T14:11:47.973Z 2026-01-29T14:30:24.739Z
9265744 9265744 20260127155621_aoHav NZ0038 2026-01-28T14:11:13.166Z 2026-01-29T14:30:24.667Z
9265717 9265717 20260127155233_C3MwB NZ0038 2026-01-28T14:11:07.248Z 2026-01-29T14:30:24.660Z
9265708 9265708 20260127155057_QUke8 NZ0038 2026-01-28T14:11:05.189Z 2026-01-29T14:30:24.659Z
9265664 9265664 20260127154615_tYh5o NZ0038 2026-01-28T14:10:54.633Z 2026-01-29T14:30:24.649Z
9265607 9265607 20260127153809_hV2Fm NZ0038 2026-01-28T14:10:43.219Z 2026-01-29T14:30:24.621Z
9265496 9265496 20260127152147_gWM2v NZ0038 2026-01-28T14:10:22.426Z 2026-01-29T14:30:24.592Z
9265431 9265431 20260127151538_gFtgO NZ0038 2026-01-28T14:10:09.835Z 2026-01-29T14:30:24.549Z
9265423 9265423 20260127151344_RXUZW NZ0038 2026-01-28T14:10:08.447Z 2026-01-29T14:30:24.545Z
9265379 9265379 20260127150901_sUNqn NZ0038 2026-01-28T14:10:00.396Z 2026-01-29T14:30:24.538Z
9265304 9265304 20260127145820_CkHm6 NZ0038 2026-01-28T14:09:46.496Z 2026-01-29T14:30:24.523Z
9265260 9265260 20260127145047_Txpiw NZ0038 2026-01-28T14:09:41.508Z 2026-01-29T14:30:24.516Z
9265236 9265236 20260127144508_MtxGy NZ0038 2026-01-28T14:09:35.991Z 2026-01-29T14:30:24.510Z
9265179 9265179 20260127143211_RAO3i NZ0038 2026-01-28T14:09:21.160Z 2026-01-29T14:30:24.494Z
9265068 9265068 20260127141129_zIYpY NZ0038 2026-01-28T14:08:55.540Z 2026-01-29T14:30:24.431Z
9265043 9265043 20260127140351_mWWFn NZ0038 2026-01-28T14:08:48.009Z 2026-01-29T14:30:24.423Z
9265031 9265031 20260127135959_m6FKf NZ0038 2026-01-28T14:08:44.411Z 2026-01-29T14:30:24.420Z
9264988 9264988 20260127134631_Zc36o NZ0038 2026-01-28T14:08:31.188Z 2026-01-29T14:30:24.406Z
9264895 9264895 20260127133025_ubJ1g NZ0038 2026-01-28T14:08:10.776Z 2026-01-29T14:30:24.322Z
9264875 9264875 20260127132705_E4aVD NZ0038 2026-01-28T14:08:04.242Z 2026-01-29T14:30:24.318Z
9264865 9264865 20260127132630_oTfWv NZ0038 2026-01-28T14:08:02.160Z 2026-01-29T14:30:24.316Z
9264822 9264822 20260127131748_9lGOt NZ0038 2026-01-28T14:07:50.620Z 2026-01-29T14:30:24.305Z
9264809 9264809 20260127131635_v2kC7 NZ0038 2026-01-28T14:07:47.979Z 2026-01-29T14:30:24.297Z
9264797 9264797 20260127131346_82HE3 NZ0038 2026-01-28T14:07:42.562Z 2026-01-29T14:30:24.294Z
9264781 9264781 20260127131045_9vP3P NZ0038 2026-01-28T14:07:35.948Z 2026-01-29T14:30:24.290Z
9264770 9264770 20260127130836_mr7xh NZ0038 2026-01-28T14:07:33.265Z 2026-01-29T14:30:24.287Z
9264695 9264695 20260127125753_opHYR NZ0038 2026-01-28T14:07:12.355Z 2026-01-29T14:30:24.256Z
9264659 9264659 20260127125230_pv2zx NZ0038 2026-01-28T14:07:04.279Z 2026-01-29T14:30:24.238Z
9264531 9264531 20260127124257_ioXE8 NZ0038 2026-01-28T14:06:35.476Z 2026-01-29T14:30:24.196Z
9264425 9264425 20260127122028_oUUyb NZ0038 2026-01-28T14:06:04.872Z 2026-01-29T14:30:21.702Z
9264411 9264411 20260127121640_ZPimU NZ0038 2026-01-28T14:05:58.156Z 2026-01-29T14:30:21.199Z
9263888 9263888 20260127103311_eMXx2 NZ0038 2026-01-28T14:03:23.367Z 2026-01-29T14:30:19.955Z
9263828 9263828 20260127101933_NG4HL NZ0038 2026-01-28T14:03:02.241Z 2026-01-29T14:30:18.956Z
9263663 9263663 20260127093800_nh3VY NZ0038 2026-01-28T14:02:04.773Z 2026-01-29T14:30:17.619Z
9227160 9227160 20260119145232_Tuxmm NZ0038 2026-01-20T14:06:51.827Z 2026-01-28T14:55:54.671Z
9227080 9227080 20260119142503_FdEf2 NZ0038 2026-01-20T14:06:28.654Z 2026-01-28T14:55:50.299Z
9227038 9227038 20260119141149_lmLn6 NZ0038 2026-01-20T14:06:18.185Z 2026-01-28T14:55:48.675Z
9227026 9227026 20260119140417_l6qhJ NZ0038 2026-01-20T14:06:15.213Z 2026-01-28T14:55:47.477Z
9226920 9226920 20260119132955_SSsX9 NZ0038 2026-01-20T14:05:38.685Z 2026-01-28T14:55:34.892Z
9226799 9226799 20260119130549_bknzP NZ0038 2026-01-20T14:05:04.211Z 2026-01-28T14:55:28.116Z
9226759 9226759 20260119130018_XFr2C NZ0038 2026-01-20T14:04:53.727Z 2026-01-28T14:55:25.618Z
9226744 9226744 20260119125730_tER5u NZ0038 2026-01-20T14:04:50.265Z 2026-01-28T14:55:24.760Z
9226706 9226706 20260119125042_33w31 NZ0038 2026-01-20T14:04:38.950Z 2026-01-28T14:55:22.935Z
9226617 9226617 20260119123427_xXrdp NZ0038 2026-01-20T14:04:11.177Z 2026-01-28T14:55:18.568Z
9226561 9226561 20260119122121_ibnta NZ0038 2026-01-20T14:03:56.079Z 2026-01-28T14:55:14.795Z
9226541 9226541 20260119121629_x77Na NZ0038 2026-01-20T14:03:45.101Z 2026-01-28T14:55:08.577Z
9226525 9226525 20260119121320_eViSr NZ0038 2026-01-20T14:03:39.885Z 2026-01-28T14:55:05.721Z
9226437 9226437 20260119120153_HyoXT NZ0038 2026-01-20T14:03:12.403Z 2026-01-28T14:55:00.194Z
9226273 9226273 20260119113841_SXPf2 NZ0038 2026-01-20T14:02:10.256Z 2026-01-28T14:54:51.898Z
9226209 9226209 20260119112942_2D2cd NZ0038 2026-01-20T14:01:51.251Z 2026-01-28T14:54:48.421Z
9221435 9221435 20260118153942_7Nnq6 NZ0038 2026-01-19T14:07:54.508Z 2026-01-27T15:00:22.408Z
9221395 9221395 20260118153227_MPt3j NZ0038 2026-01-19T14:07:47.480Z 2026-01-27T15:00:12.776Z
9221321 9221321 20260118152107_I3c09 NZ0038 2026-01-19T14:07:28.453Z 2026-01-27T15:00:03.125Z
9221181 9221181 20260118145913_r4JnJ NZ0038 2026-01-19T14:06:58.910Z 2026-01-27T14:59:56.317Z
9221119 9221119 20260118145156_V3gtY NZ0038 2026-01-19T14:06:49.253Z 2026-01-27T14:59:54.442Z
9221059 9221059 20260118144516_gAaKO NZ0038 2026-01-19T14:06:41.501Z 2026-01-27T14:59:52.339Z
9221028 9221028 20260118144446_Tgc2r NZ0038 2026-01-19T14:06:34.489Z 2026-01-27T14:59:51.769Z
9221023 9221023 20260118144351_PeUzA NZ0038 2026-01-19T14:06:33.176Z 2026-01-27T14:59:51.385Z
9221013 9221013 20260118144241_wUVlA NZ0038 2026-01-19T14:06:27.940Z 2026-01-27T14:59:50.631Z
9220979 9220979 20260118143313_643g3 NZ0038 2026-01-19T14:06:21.401Z 2026-01-27T14:59:49.050Z
9220793 9220793 20260118135107_OHacZ NZ0038 2026-01-19T14:05:37.150Z 2026-01-27T14:59:30.021Z
9220267 9220267 20260118122739_GIKCa NZ0038 2026-01-19T14:03:30.505Z 2026-01-27T14:58:59.037Z
9219541 9219541 20260117105958_54652 NZ0038 2026-01-18T14:16:54.708Z 2026-01-25T14:59:31.233Z
9219531 9219531 20260117105508_HOeBQ NZ0038 2026-01-18T14:16:52.240Z 2026-01-25T14:59:30.970Z
9219494 9219494 20260117104549_hnxEi NZ0038 2026-01-18T14:16:40.446Z 2026-01-25T14:59:29.629Z
9219259 9219259 20260117094612_OpTTw NZ0038 2026-01-18T14:15:43.575Z 2026-01-25T14:59:09.034Z
9219234 9219234 20260117093625_p2HDo NZ0038 2026-01-18T14:15:34.006Z 2026-01-25T14:59:07.969Z
9217195 9217195 20260117151907_RjhUW NZ0038 2026-01-18T14:04:45.516Z 2026-01-26T15:00:00.495Z
9217186 9217186 20260117151251_1478r NZ0038 2026-01-18T14:04:42.724Z 2026-01-26T14:59:59.875Z
9216443 9216443 20260117114916_22puV NZ0038 2026-01-18T14:00:36.720Z 2026-01-26T14:59:14.766Z
9197846 9197846 20260113124954_3P2MT NZ0038 2026-01-14T14:24:36.974Z 2026-01-21T15:06:25.783Z
9192452 9192452 20260112123626_BiyIn NZ0038 2026-01-13T14:28:25.733Z 2026-01-20T15:26:22.668Z
9192339 9192339 20260112122424_ZuF41 NZ0038 2026-01-13T14:28:05.850Z 2026-01-20T15:26:18.830Z
9191947 9191947 20260112115504_F0Ynu NZ0038 2026-01-13T14:26:59.088Z 2026-01-20T15:25:52.891Z
9191729 9191729 20260112113810_9ME7G NZ0038 2026-01-13T14:26:15.571Z 2026-01-20T15:25:44.661Z
9191713 9191713 20260112113737_4wT9f NZ0038 2026-01-13T14:26:14.448Z 2026-01-20T15:25:44.338Z
9191466 9191466 20260112110937_Vk2i8 NZ0038 2026-01-13T14:25:32.868Z 2026-01-20T15:25:35.204Z
9191151 9191151 20260112103957_QTX3b NZ0038 2026-01-13T14:24:33.850Z 2026-01-20T15:25:12.164Z
9191091 9191091 20260112103242_3fm05 NZ0038 2026-01-13T14:24:25.351Z 2026-01-20T15:25:09.790Z
9190767 9190767 20260112095511_S9qKn NZ0038 2026-01-13T14:23:25.454Z 2026-01-20T15:24:47.393Z
9190733 9190733 20260112094632_i13XY NZ0038 2026-01-13T14:23:18.597Z 2026-01-20T15:24:45.725Z
9190722 9190722 20260112094620_zJVeb NZ0038 2026-01-13T14:23:17.017Z 2026-01-20T15:24:45.310Z
9186833 9186833 20260112154814_ioBlx NZ0038 2026-01-13T14:03:41.137Z 2026-01-21T15:03:02.414Z
9186786 9186786 20260112153831_5u5J1 NZ0038 2026-01-13T14:03:30.227Z 2026-01-21T15:02:57.635Z
9186694 9186694 20260112152250_giHjb NZ0038 2026-01-13T14:03:08.857Z 2026-01-21T15:02:53.676Z
9186605 9186605 20260112150609_FWgnf NZ0038 2026-01-13T14:02:41.885Z 2026-01-21T15:02:46.925Z
9186480 9186480 20260112144236_gRArt NZ0038 2026-01-13T14:02:13.627Z 2026-01-21T15:02:35.806Z
9186437 9186437 20260112143618_XUViD NZ0038 2026-01-13T14:01:55.352Z 2026-01-21T15:02:31.586Z
9186399 9186399 20260112143057_BtIiR NZ0038 2026-01-13T14:01:47.378Z 2026-01-21T15:02:28.261Z
9169462 9169462 20260108143807_Glv3O NZ0038 2026-01-09T14:13:37.767Z 2026-01-16T15:14:00.317Z
9169348 9169348 20260108141812_h3D8F NZ0038 2026-01-09T14:13:20.104Z 2026-01-16T15:13:53.828Z
9169227 9169227 20260108134610_Vib8f NZ0038 2026-01-09T14:13:02.678Z 2026-01-16T15:13:39.211Z
9169197 9169197 20260108134127_830Ay NZ0038 2026-01-09T14:12:58.475Z 2026-01-16T15:13:35.182Z
9169188 9169188 20260108133934_3qfsO NZ0038 2026-01-09T14:12:55.910Z 2026-01-16T15:13:34.607Z
9169137 9169137 20260108132621_D5PMq NZ0038 2026-01-09T14:12:49.495Z 2026-01-16T15:13:32.197Z
9169080 9169080 20260108131413_8crKk NZ0038 2026-01-09T14:12:42.909Z 2026-01-16T15:13:28.245Z
9165967 9165967 20260108154936_b1SBa NZ0038 2026-01-09T14:00:37.740Z 2026-01-17T15:22:49.010Z
9165413 9165413 20260107154457_yiYNR NZ0038 2026-01-08T14:16:19.798Z 2026-01-13T15:05:54.055Z
9165107 9165107 20260107150733_rTHQK NZ0038 2026-01-08T14:15:25.863Z 2026-01-13T15:05:29.063Z
9164883 9164883 20260107144015_z7i0e NZ0038 2026-01-08T14:14:38.205Z 2026-01-13T15:05:09.971Z

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