participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,817 rows where station_code = "NZ0027" 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 |
---|---|---|---|---|---|
5135164 | 5135164 | 20240916165142_YgVDx | NZ0027 | 2024-09-19T12:18:16.081Z | 2024-09-19T12:18:16.081Z |
5135158 | 5135158 | 20240916164923_2U9kH | NZ0027 | 2024-09-19T12:18:16.003Z | 2024-09-19T12:18:16.003Z |
5135156 | 5135156 | 20240916164850_e62fb | NZ0027 | 2024-09-19T12:18:15.967Z | 2024-09-19T12:18:15.967Z |
5126623 | 5126623 | 20240918165447_pL0cL | NZ0027 | 2024-09-19T12:06:33.828Z | 2024-09-19T12:06:42.238Z |
5123182 | 5123182 | 20240914091327_ytjSO | NZ0027 | 2024-09-18T12:11:41.846Z | 2024-09-19T12:20:08.859Z |
5110364 | 5110364 | 20240913153046_KXFQs | NZ0027 | 2024-09-17T12:15:07.435Z | 2024-09-19T12:20:56.872Z |
5110354 | 5110354 | 20240913152839_54zaP | NZ0027 | 2024-09-17T12:15:06.782Z | 2024-09-19T12:20:56.819Z |
5110313 | 5110313 | 20240913150006_yKBP3 | NZ0027 | 2024-09-17T12:15:04.270Z | 2024-09-19T12:20:56.601Z |
5110296 | 5110296 | 20240913144444_VoneR | NZ0027 | 2024-09-17T12:15:03.635Z | 2024-09-19T12:20:56.538Z |
5110273 | 5110273 | 20240913142349_R4r6X | NZ0027 | 2024-09-17T12:15:02.478Z | 2024-09-19T12:20:56.379Z |
5110260 | 5110260 | 20240913141627_2wWSY | NZ0027 | 2024-09-17T12:15:01.988Z | 2024-09-19T12:20:56.343Z |
5110242 | 5110242 | 20240913135902_7eEDW | NZ0027 | 2024-09-17T12:15:01.310Z | 2024-09-19T12:20:56.265Z |
5083636 | 5083636 | 20240911140225_43sqb | NZ0027 | 2024-09-15T12:18:44.905Z | 2024-09-19T12:21:49.741Z |
5083526 | 5083526 | 20240911134105_3O5uk | NZ0027 | 2024-09-15T12:18:43.322Z | 2024-09-19T12:21:49.635Z |
5083495 | 5083495 | 20240911133217_Di21s | NZ0027 | 2024-09-15T12:18:42.613Z | 2024-09-19T12:21:49.600Z |
5083345 | 5083345 | 20240911130012_RnmXq | NZ0027 | 2024-09-15T12:18:39.965Z | 2024-09-19T12:21:49.491Z |
5083036 | 5083036 | 20240911114929_n5Tb9 | NZ0027 | 2024-09-15T12:18:34.076Z | 2024-09-19T12:21:49.146Z |
5071430 | 5071430 | 20240911165024_dRddc | NZ0027 | 2024-09-15T12:02:31.463Z | 2024-09-19T12:21:01.886Z |
5071420 | 5071420 | 20240911164817_ig2eU | NZ0027 | 2024-09-15T12:02:29.541Z | 2024-09-19T12:21:01.854Z |
5071189 | 5071189 | 20240911161256_HBbxA | NZ0027 | 2024-09-15T12:01:51.878Z | 2024-09-19T12:21:01.192Z |
5071048 | 5071048 | 20240911155106_3SvKa | NZ0027 | 2024-09-15T12:01:29.801Z | 2024-09-19T12:21:00.792Z |
5070702 | 5070702 | 20240911145636_6YCjG | NZ0027 | 2024-09-15T12:00:37.380Z | 2024-09-19T12:21:00.078Z |
5068962 | 5068962 | 20240910131454_QoVGa | NZ0027 | 2024-09-14T12:19:23.314Z | 2024-09-18T12:15:26.905Z |
5068887 | 5068887 | 20240910125515_63LZ7 | NZ0027 | 2024-09-14T12:19:22.593Z | 2024-09-18T12:15:26.784Z |
5068831 | 5068831 | 20240910123743_rwz3Q | NZ0027 | 2024-09-14T12:19:21.855Z | 2024-09-18T12:15:26.722Z |
5068784 | 5068784 | 20240910122412_DRP6e | NZ0027 | 2024-09-14T12:19:21.420Z | 2024-09-18T12:15:26.668Z |
5068723 | 5068723 | 20240910121004_vFTOE | NZ0027 | 2024-09-14T12:19:20.702Z | 2024-09-18T12:15:26.548Z |
5068689 | 5068689 | 20240910120545_36euH | NZ0027 | 2024-09-14T12:19:20.363Z | 2024-09-18T12:15:26.498Z |
5068606 | 5068606 | 20240910115411_kUvSr | NZ0027 | 2024-09-14T12:19:19.248Z | 2024-09-18T12:15:26.387Z |
5068288 | 5068288 | 20240910111757_kB8eG | NZ0027 | 2024-09-14T12:19:11.757Z | 2024-09-18T12:15:25.883Z |
5067864 | 5067864 | 20240910102207_3g0ih | NZ0027 | 2024-09-14T12:19:01.272Z | 2024-09-18T12:15:24.993Z |
5067794 | 5067794 | 20240910101219_cgrAf | NZ0027 | 2024-09-14T12:18:58.639Z | 2024-09-18T12:15:24.903Z |
5067776 | 5067776 | 20240910101124_F14dO | NZ0027 | 2024-09-14T12:18:57.109Z | 2024-09-18T12:15:24.874Z |
5067757 | 5067757 | 20240910101015_xVE2T | NZ0027 | 2024-09-14T12:18:56.301Z | 2024-09-18T12:15:24.844Z |
5067745 | 5067745 | 20240910100827_UjqKG | NZ0027 | 2024-09-14T12:18:55.894Z | 2024-09-18T12:15:24.822Z |
5062262 | 5062262 | 20240909170439_430TV | NZ0027 | 2024-09-14T12:12:02.248Z | 2024-09-18T12:15:10.823Z |
5061513 | 5061513 | 20240909151756_duMp2 | NZ0027 | 2024-09-14T12:10:54.855Z | 2024-09-18T12:15:09.470Z |
5061490 | 5061490 | 20240909151414_ZC6kx | NZ0027 | 2024-09-14T12:10:52.865Z | 2024-09-18T12:15:09.446Z |
5061420 | 5061420 | 20240909150454_2TDy8 | NZ0027 | 2024-09-14T12:10:49.011Z | 2024-09-18T12:15:09.180Z |
5059383 | 5059383 | 20240910173556_xppE6 | NZ0027 | 2024-09-14T12:05:49.997Z | 2024-09-19T12:21:30.708Z |
5059376 | 5059376 | 20240910173517_92TFQ | NZ0027 | 2024-09-14T12:05:49.383Z | 2024-09-19T12:21:30.705Z |
5059274 | 5059274 | 20240910172725_qhfXh | NZ0027 | 2024-09-14T12:05:35.396Z | 2024-09-19T12:21:30.484Z |
5059258 | 5059258 | 20240910172705_vXGV9 | NZ0027 | 2024-09-14T12:05:33.694Z | 2024-09-19T12:21:30.473Z |
5059244 | 5059244 | 20240910172515_14doV | NZ0027 | 2024-09-14T12:05:30.799Z | 2024-09-19T12:21:30.468Z |
5059195 | 5059195 | 20240910172158_Kuytc | NZ0027 | 2024-09-14T12:05:25.458Z | 2024-09-19T12:21:30.420Z |
5059013 | 5059013 | 20240910170805_l0EBq | NZ0027 | 2024-09-14T12:05:06.370Z | 2024-09-19T12:21:30.304Z |
5058996 | 5058996 | 20240910170729_F18PJ | NZ0027 | 2024-09-14T12:05:05.292Z | 2024-09-19T12:21:30.300Z |
5058971 | 5058971 | 20240910170532_1LBmk | NZ0027 | 2024-09-14T12:05:02.916Z | 2024-09-19T12:21:30.283Z |
5058860 | 5058860 | 20240910165304_Fk932 | NZ0027 | 2024-09-14T12:04:40.224Z | 2024-09-19T12:21:30.187Z |
5058839 | 5058839 | 20240910165048_9m8Ax | NZ0027 | 2024-09-14T12:04:37.989Z | 2024-09-19T12:21:30.163Z |
5058824 | 5058824 | 20240910165001_JALdO | NZ0027 | 2024-09-14T12:04:36.517Z | 2024-09-19T12:21:30.156Z |
5058807 | 5058807 | 20240910164855_ki7rd | NZ0027 | 2024-09-14T12:04:34.234Z | 2024-09-19T12:21:30.136Z |
5058426 | 5058426 | 20240910161138_kOQF3 | NZ0027 | 2024-09-14T12:03:40.888Z | 2024-09-19T12:21:29.597Z |
5058408 | 5058408 | 20240910161029_uG0dK | NZ0027 | 2024-09-14T12:03:39.501Z | 2024-09-19T12:21:29.592Z |
5058162 | 5058162 | 20240910154900_Zxd4l | NZ0027 | 2024-09-14T12:03:03.923Z | 2024-09-19T12:21:29.246Z |
5058029 | 5058029 | 20240910153729_9baz6 | NZ0027 | 2024-09-14T12:02:38.653Z | 2024-09-19T12:21:29.020Z |
5057755 | 5057755 | 20240910151036_b9l26 | NZ0027 | 2024-09-14T12:01:53.326Z | 2024-09-19T12:21:28.688Z |
5057727 | 5057727 | 20240910150736_W3gS1 | NZ0027 | 2024-09-14T12:01:49.013Z | 2024-09-19T12:21:28.649Z |
5057680 | 5057680 | 20240910150328_AFb2M | NZ0027 | 2024-09-14T12:01:43.759Z | 2024-09-19T12:21:28.579Z |
5057520 | 5057520 | 20240910144012_Bw0rt | NZ0027 | 2024-09-14T12:01:18.836Z | 2024-09-19T12:21:28.223Z |
5057508 | 5057508 | 20240910143705_vOuEv | NZ0027 | 2024-09-14T12:01:16.769Z | 2024-09-19T12:21:28.088Z |
5057448 | 5057448 | 20240910143110_9PzPC | NZ0027 | 2024-09-14T12:01:04.982Z | 2024-09-19T12:21:27.890Z |
5057397 | 5057397 | 20240910142215_n6yVm | NZ0027 | 2024-09-14T12:00:59.900Z | 2024-09-19T12:21:27.670Z |
5057261 | 5057261 | 20240910140606_Cr8vw | NZ0027 | 2024-09-14T12:00:42.257Z | 2024-09-19T12:21:27.468Z |
5057132 | 5057132 | 20240910134743_mdNeQ | NZ0027 | 2024-09-14T12:00:18.931Z | 2024-09-19T12:21:27.082Z |
5057119 | 5057119 | 20240910134349_YbG7M | NZ0027 | 2024-09-14T12:00:17.533Z | 2024-09-19T12:21:27.043Z |
5050527 | 5050527 | 20240907153411_5Az62 | NZ0027 | 2024-09-13T12:13:35.427Z | 2024-09-16T12:20:57.942Z |
5050234 | 5050234 | 20240907145654_enTIf | NZ0027 | 2024-09-13T12:13:19.876Z | 2024-09-16T12:20:56.800Z |
5050179 | 5050179 | 20240907144600_vGbqD | NZ0027 | 2024-09-13T12:13:15.700Z | 2024-09-16T12:20:56.671Z |
5049103 | 5049103 | 20240909100746_lIx4U | NZ0027 | 2024-09-13T12:11:34.206Z | 2024-09-17T12:19:09.161Z |
5049030 | 5049030 | 20240909094928_342mN | NZ0027 | 2024-09-13T12:11:28.429Z | 2024-09-17T12:19:08.988Z |
5048820 | 5048820 | 20240909091656_sPtYN | NZ0027 | 2024-09-13T12:11:17.323Z | 2024-09-17T12:19:08.412Z |
5045664 | 5045664 | 20240908174110_rEhHb | NZ0027 | 2024-09-13T12:04:39.071Z | 2024-09-17T12:18:56.938Z |
5045575 | 5045575 | 20240908172620_TSNf5 | NZ0027 | 2024-09-13T12:04:23.493Z | 2024-09-17T12:18:56.808Z |
5045566 | 5045566 | 20240908172514_hnR66 | NZ0027 | 2024-09-13T12:04:22.488Z | 2024-09-17T12:18:56.800Z |
5045560 | 5045560 | 20240908172403_IjC3K | NZ0027 | 2024-09-13T12:04:21.276Z | 2024-09-17T12:18:56.795Z |
5045537 | 5045537 | 20240908171833_r64my | NZ0027 | 2024-09-13T12:04:17.573Z | 2024-09-17T12:18:56.747Z |
5045530 | 5045530 | 20240908171733_833xR | NZ0027 | 2024-09-13T12:04:16.967Z | 2024-09-17T12:18:56.743Z |
5045514 | 5045514 | 20240908171600_j2lpd | NZ0027 | 2024-09-13T12:04:15.672Z | 2024-09-17T12:18:56.679Z |
5045416 | 5045416 | 20240908170219_NUU84 | NZ0027 | 2024-09-13T12:04:07.067Z | 2024-09-17T12:18:56.467Z |
5045406 | 5045406 | 20240908170141_8KEga | NZ0027 | 2024-09-13T12:04:06.527Z | 2024-09-17T12:18:56.462Z |
5045350 | 5045350 | 20240908165623_UueuX | NZ0027 | 2024-09-13T12:04:01.521Z | 2024-09-17T12:18:56.395Z |
5045245 | 5045245 | 20240908164235_2wwDa | NZ0027 | 2024-09-13T12:03:46.030Z | 2024-09-17T12:18:56.127Z |
5045225 | 5045225 | 20240908163701_YNoEC | NZ0027 | 2024-09-13T12:03:43.845Z | 2024-09-17T12:18:56.069Z |
5045186 | 5045186 | 20240908162919_o0BNN | NZ0027 | 2024-09-13T12:03:38.463Z | 2024-09-17T12:18:56.022Z |
5045146 | 5045146 | 20240908162546_KDLZ8 | NZ0027 | 2024-09-13T12:03:36.290Z | 2024-09-17T12:18:56.002Z |
5044996 | 5044996 | 20240908160203_IEtN3 | NZ0027 | 2024-09-13T12:03:22.647Z | 2024-09-17T12:18:55.590Z |
5044831 | 5044831 | 20240908154826_ukSNL | NZ0027 | 2024-09-13T12:03:01.302Z | 2024-09-17T12:18:55.261Z |
5044810 | 5044810 | 20240908154604_BhPEe | NZ0027 | 2024-09-13T12:02:59.287Z | 2024-09-17T12:18:55.251Z |
5044717 | 5044717 | 20240908153140_9tPJA | NZ0027 | 2024-09-13T12:02:50.208Z | 2024-09-17T12:18:54.890Z |
5044704 | 5044704 | 20240908153117_O35hS | NZ0027 | 2024-09-13T12:02:49.428Z | 2024-09-17T12:18:54.879Z |
5044681 | 5044681 | 20240908152809_pCCFg | NZ0027 | 2024-09-13T12:02:46.306Z | 2024-09-17T12:18:54.821Z |
5044666 | 5044666 | 20240908152727_c9pAm | NZ0027 | 2024-09-13T12:02:45.177Z | 2024-09-17T12:18:54.815Z |
5044626 | 5044626 | 20240908152508_197Ig | NZ0027 | 2024-09-13T12:02:35.882Z | 2024-09-17T12:18:54.763Z |
5044593 | 5044593 | 20240908152031_GTpU6 | NZ0027 | 2024-09-13T12:02:27.168Z | 2024-09-17T12:18:54.731Z |
5044447 | 5044447 | 20240908150310_DSANo | NZ0027 | 2024-09-13T12:02:12.526Z | 2024-09-17T12:18:54.434Z |
5044210 | 5044210 | 20240908142914_GF8yK | NZ0027 | 2024-09-13T12:01:40.944Z | 2024-09-17T12:18:53.684Z |
5043954 | 5043954 | 20240908134114_u6tqO | NZ0027 | 2024-09-13T12:01:02.961Z | 2024-09-17T12:18:53.116Z |
5043948 | 5043948 | 20240908134037_RmsYc | NZ0027 | 2024-09-13T12:01:02.056Z | 2024-09-17T12:18:53.093Z |
5043320 | 5043320 | 20240907142918_2dPlf | NZ0027 | 2024-09-12T12:17:26.415Z | 2024-09-16T12:20:56.363Z |
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);