participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
8,736 rows where station_code = "NZ002F" sorted by created_at descending
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 |
---|---|---|---|---|---|
5461089 | 5461089 | 20241101155123_9XI4Y | NZ002F | 2024-11-03T14:14:42.728Z | 2024-11-03T14:19:33.669Z |
5461049 | 5461049 | 20241101154128_zW33u | NZ002F | 2024-11-03T14:14:40.885Z | 2024-11-03T14:19:33.662Z |
5461006 | 5461006 | 20241101153246_hcqyv | NZ002F | 2024-11-03T14:14:38.629Z | 2024-11-03T14:19:33.653Z |
5460991 | 5460991 | 20241101153112_n1XkE | NZ002F | 2024-11-03T14:14:38.112Z | 2024-11-03T14:19:33.651Z |
5460975 | 5460975 | 20241101153007_2yk6p | NZ002F | 2024-11-03T14:14:37.663Z | 2024-11-03T14:19:33.649Z |
5460972 | 5460972 | 20241101152930_GSOfO | NZ002F | 2024-11-03T14:14:37.536Z | 2024-11-03T14:19:33.648Z |
5460868 | 5460868 | 20241101151353_N5Wqr | NZ002F | 2024-11-03T14:14:32.054Z | 2024-11-03T14:19:33.627Z |
5460858 | 5460858 | 20241101151259_NxOQk | NZ002F | 2024-11-03T14:14:31.736Z | 2024-11-03T14:19:33.626Z |
5460707 | 5460707 | 20241101145528_4YPI3 | NZ002F | 2024-11-03T14:14:16.324Z | 2024-11-03T14:19:33.600Z |
5460700 | 5460700 | 20241101145449_jqFX9 | NZ002F | 2024-11-03T14:14:15.643Z | 2024-11-03T14:19:33.599Z |
5460636 | 5460636 | 20241101144040_RXJQm | NZ002F | 2024-11-03T14:14:06.358Z | 2024-11-03T14:19:33.587Z |
5460565 | 5460565 | 20241101143106_qtY0v | NZ002F | 2024-11-03T14:13:59.491Z | 2024-11-03T14:19:33.576Z |
5460504 | 5460504 | 20241101142400_YKS2W | NZ002F | 2024-11-03T14:13:53.161Z | 2024-11-03T14:19:33.563Z |
5460466 | 5460466 | 20241101141438_ugjn3 | NZ002F | 2024-11-03T14:13:47.036Z | 2024-11-03T14:19:33.553Z |
5460438 | 5460438 | 20241101141017_I4qe2 | NZ002F | 2024-11-03T14:13:44.409Z | 2024-11-03T14:19:33.546Z |
5460397 | 5460397 | 20241101140208_ewttj | NZ002F | 2024-11-03T14:13:41.656Z | 2024-11-03T14:19:33.537Z |
5460327 | 5460327 | 20241101134828_DYXWV | NZ002F | 2024-11-03T14:13:36.131Z | 2024-11-03T14:19:33.524Z |
5460292 | 5460292 | 20241101133737_sVi6L | NZ002F | 2024-11-03T14:13:33.771Z | 2024-11-03T14:19:33.516Z |
5460267 | 5460267 | 20241101132534_wfX83 | NZ002F | 2024-11-03T14:13:31.694Z | 2024-11-03T14:19:33.510Z |
5460247 | 5460247 | 20241101132125_qXYBq | NZ002F | 2024-11-03T14:13:30.925Z | 2024-11-03T14:19:33.507Z |
5460212 | 5460212 | 20241101131052_8rnJ9 | NZ002F | 2024-11-03T14:13:28.149Z | 2024-11-03T14:19:33.499Z |
5460147 | 5460147 | 20241101125604_u3Jlp | NZ002F | 2024-11-03T14:13:24.815Z | 2024-11-03T14:19:33.487Z |
5460124 | 5460124 | 20241101124920_7i25f | NZ002F | 2024-11-03T14:13:22.735Z | 2024-11-03T14:19:33.481Z |
5460101 | 5460101 | 20241101124324_WctV5 | NZ002F | 2024-11-03T14:13:21.109Z | 2024-11-03T14:19:33.476Z |
5460091 | 5460091 | 20241101124238_9R1uA | NZ002F | 2024-11-03T14:13:20.743Z | 2024-11-03T14:19:33.475Z |
5459956 | 5459956 | 20241101122254_UO8Le | NZ002F | 2024-11-03T14:12:57.542Z | 2024-11-03T14:19:33.453Z |
5459825 | 5459825 | 20241101115828_NIMEh | NZ002F | 2024-11-03T14:12:38.529Z | 2024-11-03T14:19:33.425Z |
5459707 | 5459707 | 20241101114020_X1Xqt | NZ002F | 2024-11-03T14:12:29.787Z | 2024-11-03T14:19:33.402Z |
5459313 | 5459313 | 20241101104118_8THNr | NZ002F | 2024-11-03T14:11:41.682Z | 2024-11-03T14:19:33.318Z |
5459266 | 5459266 | 20241101103234_Wp6ON | NZ002F | 2024-11-03T14:11:35.709Z | 2024-11-03T14:19:33.307Z |
5458972 | 5458972 | 20241101095141_Z1D6U | NZ002F | 2024-11-03T14:10:53.709Z | 2024-11-03T14:19:33.242Z |
5458942 | 5458942 | 20241101094759_9IkNq | NZ002F | 2024-11-03T14:10:51.343Z | 2024-11-03T14:19:33.236Z |
5458078 | 5458078 | 20241102161324_A3jPd | NZ002F | 2024-11-03T14:08:45.782Z | 2024-11-03T14:08:45.782Z |
5458066 | 5458066 | 20241102160843_bD9F1 | NZ002F | 2024-11-03T14:08:41.279Z | 2024-11-03T14:08:41.279Z |
5458035 | 5458035 | 20241102160151_d8sB2 | NZ002F | 2024-11-03T14:08:35.724Z | 2024-11-03T14:08:35.724Z |
5458006 | 5458006 | 20241102155706_L20RQ | NZ002F | 2024-11-03T14:08:32.311Z | 2024-11-03T14:08:32.311Z |
5457935 | 5457935 | 20241102154132_dcGLQ | NZ002F | 2024-11-03T14:08:22.032Z | 2024-11-03T14:08:22.032Z |
5457855 | 5457855 | 20241102153007_SrxYn | NZ002F | 2024-11-03T14:08:16.364Z | 2024-11-03T14:08:16.364Z |
5457841 | 5457841 | 20241102152926_XHf3m | NZ002F | 2024-11-03T14:08:15.801Z | 2024-11-03T14:08:15.801Z |
5457790 | 5457790 | 20241102152343_h095y | NZ002F | 2024-11-03T14:08:11.161Z | 2024-11-03T14:08:11.161Z |
5457768 | 5457768 | 20241102152213_8wMcP | NZ002F | 2024-11-03T14:08:03.284Z | 2024-11-03T14:08:03.284Z |
5457737 | 5457737 | 20241102151710_MMdus | NZ002F | 2024-11-03T14:07:55.670Z | 2024-11-03T14:07:55.670Z |
5457577 | 5457577 | 20241102144851_ZrS5o | NZ002F | 2024-11-03T14:07:41.430Z | 2024-11-03T14:07:41.430Z |
5457523 | 5457523 | 20241102144002_1MQYq | NZ002F | 2024-11-03T14:07:35.791Z | 2024-11-03T14:07:35.791Z |
5457505 | 5457505 | 20241102143925_Cr90B | NZ002F | 2024-11-03T14:07:34.838Z | 2024-11-03T14:07:34.838Z |
5457407 | 5457407 | 20241102142500_a8LzN | NZ002F | 2024-11-03T14:07:16.125Z | 2024-11-03T14:07:16.125Z |
5457389 | 5457389 | 20241102142258_jjoS1 | NZ002F | 2024-11-03T14:07:12.854Z | 2024-11-03T14:07:12.854Z |
5457331 | 5457331 | 20241102141223_EFJfo | NZ002F | 2024-11-03T14:07:08.267Z | 2024-11-03T14:07:08.267Z |
5457310 | 5457310 | 20241102140851_qypTV | NZ002F | 2024-11-03T14:07:06.053Z | 2024-11-03T14:07:06.053Z |
5457297 | 5457297 | 20241102140702_7qVaC | NZ002F | 2024-11-03T14:07:04.443Z | 2024-11-03T14:07:04.443Z |
5457178 | 5457178 | 20241102134329_Uwyjf | NZ002F | 2024-11-03T14:06:43.198Z | 2024-11-03T14:06:43.198Z |
5457137 | 5457137 | 20241102133627_IUEWk | NZ002F | 2024-11-03T14:06:37.887Z | 2024-11-03T14:06:37.887Z |
5457131 | 5457131 | 20241102133554_qO7Ox | NZ002F | 2024-11-03T14:06:37.164Z | 2024-11-03T14:06:37.164Z |
5456963 | 5456963 | 20241102130246_U7qz2 | NZ002F | 2024-11-03T14:06:12.459Z | 2024-11-03T14:06:12.459Z |
5456868 | 5456868 | 20241102124251_uKvOJ | NZ002F | 2024-11-03T14:05:51.699Z | 2024-11-03T14:05:51.699Z |
5456852 | 5456852 | 20241102124012_Jim5W | NZ002F | 2024-11-03T14:05:49.785Z | 2024-11-03T14:05:49.785Z |
5456816 | 5456816 | 20241102123142_E3OAP | NZ002F | 2024-11-03T14:05:44.945Z | 2024-11-03T14:05:44.945Z |
5456736 | 5456736 | 20241102121212_KeABw | NZ002F | 2024-11-03T14:05:35.092Z | 2024-11-03T14:05:35.092Z |
5456715 | 5456715 | 20241102120827_Rr9OP | NZ002F | 2024-11-03T14:05:32.847Z | 2024-11-03T14:05:32.847Z |
5456686 | 5456686 | 20241102120433_6bsW9 | NZ002F | 2024-11-03T14:05:25.033Z | 2024-11-03T14:05:25.033Z |
5456532 | 5456532 | 20241102113951_2CLCV | NZ002F | 2024-11-03T14:04:56.384Z | 2024-11-03T14:04:56.384Z |
5438070 | 5438070 | 20241030161832_psvXU | NZ002F | 2024-11-01T12:10:55.952Z | 2024-11-03T14:22:41.453Z |
5438023 | 5438023 | 20241030161514_WN21s | NZ002F | 2024-11-01T12:10:52.738Z | 2024-11-03T14:22:41.255Z |
5437857 | 5437857 | 20241030155158_0Arm4 | NZ002F | 2024-11-01T12:10:31.960Z | 2024-11-03T14:22:40.773Z |
5437755 | 5437755 | 20241030153935_3f3Sx | NZ002F | 2024-11-01T12:10:17.273Z | 2024-11-03T14:22:40.478Z |
5437745 | 5437745 | 20241030153854_tMkSL | NZ002F | 2024-11-01T12:10:16.698Z | 2024-11-03T14:22:40.461Z |
5437706 | 5437706 | 20241030153718_NsIZJ | NZ002F | 2024-11-01T12:10:13.908Z | 2024-11-03T14:22:40.369Z |
5437702 | 5437702 | 20241030153717_QRTrv | NZ002F | 2024-11-01T12:10:13.094Z | 2024-11-03T14:22:40.331Z |
5437508 | 5437508 | 20241030151624_uR1Nl | NZ002F | 2024-11-01T12:09:56.015Z | 2024-11-03T14:22:39.804Z |
5437491 | 5437491 | 20241030151325_eqPyf | NZ002F | 2024-11-01T12:09:53.173Z | 2024-11-03T14:22:39.749Z |
5437260 | 5437260 | 20241030144859_RgHt4 | NZ002F | 2024-11-01T12:09:18.525Z | 2024-11-03T14:22:38.950Z |
5437253 | 5437253 | 20241030144817_rvTRr | NZ002F | 2024-11-01T12:09:17.947Z | 2024-11-03T14:22:38.946Z |
5437206 | 5437206 | 20241030144231_yst8D | NZ002F | 2024-11-01T12:09:14.396Z | 2024-11-03T14:22:38.879Z |
5437138 | 5437138 | 20241030143200_5It3R | NZ002F | 2024-11-01T12:09:08.443Z | 2024-11-03T14:22:38.703Z |
5437072 | 5437072 | 20241030142516_Wm4pW | NZ002F | 2024-11-01T12:08:49.858Z | 2024-11-03T14:22:38.500Z |
5437019 | 5437019 | 20241030142100_EFkSy | NZ002F | 2024-11-01T12:08:44.784Z | 2024-11-03T14:22:38.353Z |
5436952 | 5436952 | 20241030141101_4gKui | NZ002F | 2024-11-01T12:08:38.007Z | 2024-11-03T14:22:38.156Z |
5436734 | 5436734 | 20241030134323_PPJvA | NZ002F | 2024-11-01T12:08:09.091Z | 2024-11-03T14:22:37.597Z |
5436726 | 5436726 | 20241030134155_2oITy | NZ002F | 2024-11-01T12:08:08.412Z | 2024-11-03T14:22:37.592Z |
5436714 | 5436714 | 20241030134114_1Ts75 | NZ002F | 2024-11-01T12:08:07.252Z | 2024-11-03T14:22:37.548Z |
5436687 | 5436687 | 20241030133735_9NUq3 | NZ002F | 2024-11-01T12:08:05.747Z | 2024-11-03T14:22:37.489Z |
5436483 | 5436483 | 20241030131244_ii5GL | NZ002F | 2024-11-01T12:07:45.341Z | 2024-11-03T14:22:36.824Z |
5436376 | 5436376 | 20241030125843_TreLy | NZ002F | 2024-11-01T12:07:24.621Z | 2024-11-03T14:22:36.384Z |
5436371 | 5436371 | 20241030125818_eFAc0 | NZ002F | 2024-11-01T12:07:24.288Z | 2024-11-03T14:22:36.383Z |
5436344 | 5436344 | 20241030125638_3LoLq | NZ002F | 2024-11-01T12:07:22.073Z | 2024-11-03T14:22:36.337Z |
5436119 | 5436119 | 20241030123031_j2jkT | NZ002F | 2024-11-01T12:06:49.456Z | 2024-11-03T14:22:35.366Z |
5435727 | 5435727 | 20241030115321_hzex2 | NZ002F | 2024-11-01T12:05:49.187Z | 2024-11-03T14:22:33.872Z |
5435668 | 5435668 | 20241030114847_iCsLM | NZ002F | 2024-11-01T12:05:44.611Z | 2024-11-03T14:22:33.488Z |
5435605 | 5435605 | 20241030114421_Bdulh | NZ002F | 2024-11-01T12:05:39.146Z | 2024-11-03T14:22:33.314Z |
5435481 | 5435481 | 20241030113344_hHiN2 | NZ002F | 2024-11-01T12:05:14.857Z | 2024-11-03T14:22:32.859Z |
5435468 | 5435468 | 20241030113213_zezcB | NZ002F | 2024-11-01T12:05:14.042Z | 2024-11-03T14:22:32.814Z |
5435444 | 5435444 | 20241030112955_H2h8Z | NZ002F | 2024-11-01T12:05:11.160Z | 2024-11-03T14:22:32.723Z |
5435384 | 5435384 | 20241030112330_2dKCU | NZ002F | 2024-11-01T12:05:04.294Z | 2024-11-03T14:22:32.435Z |
5427613 | 5427613 | 20241028152220_lrijr | NZ002F | 2024-10-31T12:13:41.044Z | 2024-11-03T14:24:48.119Z |
5427607 | 5427607 | 20241028152212_pTRSV | NZ002F | 2024-10-31T12:13:40.796Z | 2024-11-03T14:24:48.109Z |
5427121 | 5427121 | 20241028143203_JRYu6 | NZ002F | 2024-10-31T12:13:10.448Z | 2024-11-03T14:24:45.830Z |
5427059 | 5427059 | 20241028142717_HQ134 | NZ002F | 2024-10-31T12:13:02.469Z | 2024-11-03T14:24:45.728Z |
5427019 | 5427019 | 20241028142318_ee3fX | NZ002F | 2024-10-31T12:12:53.366Z | 2024-11-03T14:24:45.662Z |
5426947 | 5426947 | 20241028141438_shewT | NZ002F | 2024-10-31T12:12:42.310Z | 2024-11-03T14:24:45.471Z |
5426829 | 5426829 | 20241028140243_DWnAm | NZ002F | 2024-10-31T12:12:30.678Z | 2024-11-03T14:24:45.249Z |
Advanced export
JSON shape: default, array, newline-delimited
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);