participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
9,148 rows where station_code = "NZ0001" 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 |
---|---|---|---|---|---|
5557249 | 5557249 | 20241117150344_e0XZa | NZ0001 | 2024-11-20T14:14:15.968Z | 2024-11-21T14:21:36.699Z |
5557245 | 5557245 | 20241117144826_PGxfO | NZ0001 | 2024-11-20T14:14:11.472Z | 2024-11-21T14:21:35.464Z |
5557241 | 5557241 | 20241117124603_eO155 | NZ0001 | 2024-11-20T14:13:51.523Z | 2024-11-21T14:21:27.010Z |
5557238 | 5557238 | 20241117100955_ltobG | NZ0001 | 2024-11-20T14:13:21.544Z | 2024-11-21T14:21:15.692Z |
5556234 | 5556234 | 20241118134020_6vEoy | NZ0001 | 2024-11-20T14:09:12.499Z | 2024-11-21T14:19:53.163Z |
5556232 | 5556232 | 20241118114637_eX9Ss | NZ0001 | 2024-11-20T14:08:45.810Z | 2024-11-21T14:19:37.228Z |
5544818 | 5544818 | 20241116154903_3LeJJ | NZ0001 | 2024-11-17T14:02:13.842Z | 2024-11-21T14:22:40.942Z |
5544680 | 5544680 | 20241116142114_7ngEL | NZ0001 | 2024-11-17T14:01:50.706Z | 2024-11-21T14:22:38.927Z |
5544613 | 5544613 | 20241116130900_QLefj | NZ0001 | 2024-11-17T14:01:41.029Z | 2024-11-21T14:22:37.490Z |
5544601 | 5544601 | 20241116125855_b6agx | NZ0001 | 2024-11-17T14:01:39.561Z | 2024-11-21T14:22:37.402Z |
5542877 | 5542877 | 20241115152540_XbgrG | NZ0001 | 2024-11-16T14:02:53.557Z | 2024-11-21T14:23:36.269Z |
5542844 | 5542844 | 20241115142216_4yIi8 | NZ0001 | 2024-11-16T14:02:45.172Z | 2024-11-21T14:23:35.639Z |
5542828 | 5542828 | 20241115125602_02Axs | NZ0001 | 2024-11-16T14:02:42.269Z | 2024-11-21T14:23:35.399Z |
5542814 | 5542814 | 20241115124619_WQ70N | NZ0001 | 2024-11-16T14:02:40.549Z | 2024-11-21T14:23:35.245Z |
5542758 | 5542758 | 20241115122044_FnN9e | NZ0001 | 2024-11-16T14:02:27.306Z | 2024-11-21T14:23:34.638Z |
5542740 | 5542740 | 20241115121533_4iLtt | NZ0001 | 2024-11-16T14:02:19.875Z | 2024-11-21T14:23:34.088Z |
5542727 | 5542727 | 20241115121142_ovLlG | NZ0001 | 2024-11-16T14:02:18.471Z | 2024-11-21T14:23:34.022Z |
5542383 | 5542383 | 20241115090314_2zy17 | NZ0001 | 2024-11-16T14:01:07.084Z | 2024-11-21T14:23:26.312Z |
5542079 | 5542079 | 20241112153314_MWwq8 | NZ0001 | 2024-11-15T14:11:29.582Z | 2024-11-21T14:25:56.449Z |
5541087 | 5541087 | 20241114150854_2v0jg | NZ0001 | 2024-11-15T14:05:03.517Z | 2024-11-21T14:24:19.224Z |
5536071 | 5536071 | 20241112153343_qcYWI | NZ0001 | 2024-11-14T14:09:10.117Z | 2024-11-21T14:25:56.455Z |
5536029 | 5536029 | 20241112152650_9DoIl | NZ0001 | 2024-11-14T14:09:07.688Z | 2024-11-21T14:25:56.199Z |
5536026 | 5536026 | 20241112152527_wXdXH | NZ0001 | 2024-11-14T14:09:07.395Z | 2024-11-21T14:25:56.178Z |
5535971 | 5535971 | 20241112150814_ibpL8 | NZ0001 | 2024-11-14T14:09:03.203Z | 2024-11-21T14:25:55.669Z |
5535914 | 5535914 | 20241112145300_6BRlM | NZ0001 | 2024-11-14T14:08:58.800Z | 2024-11-21T14:25:54.582Z |
5535840 | 5535840 | 20241112143645_LI5lF | NZ0001 | 2024-11-14T14:08:53.934Z | 2024-11-21T14:25:53.792Z |
5535827 | 5535827 | 20241112143443_1CPV3 | NZ0001 | 2024-11-14T14:08:52.991Z | 2024-11-21T14:25:53.699Z |
5535778 | 5535778 | 20241112142019_pCsnN | NZ0001 | 2024-11-14T14:08:49.206Z | 2024-11-21T14:25:53.075Z |
5535712 | 5535712 | 20241112135537_tZeGS | NZ0001 | 2024-11-14T14:08:31.424Z | 2024-11-21T14:25:51.598Z |
5535705 | 5535705 | 20241112135038_Ym7eD | NZ0001 | 2024-11-14T14:08:27.614Z | 2024-11-21T14:25:51.376Z |
5535689 | 5535689 | 20241112134234_6L38B | NZ0001 | 2024-11-14T14:08:22.901Z | 2024-11-21T14:25:51.170Z |
5535663 | 5535663 | 20241112133513_J3Z4d | NZ0001 | 2024-11-14T14:08:17.958Z | 2024-11-21T14:25:50.887Z |
5535661 | 5535661 | 20241112133440_V2vp2 | NZ0001 | 2024-11-14T14:08:17.535Z | 2024-11-21T14:25:50.880Z |
5535634 | 5535634 | 20241112131829_OQEE1 | NZ0001 | 2024-11-14T14:08:12.211Z | 2024-11-21T14:25:50.761Z |
5535542 | 5535542 | 20241112124725_B8ZBT | NZ0001 | 2024-11-14T14:08:03.744Z | 2024-11-21T14:25:49.597Z |
5535502 | 5535502 | 20241112123942_EZlet | NZ0001 | 2024-11-14T14:08:00.785Z | 2024-11-21T14:25:48.691Z |
5535438 | 5535438 | 20241112122616_h42am | NZ0001 | 2024-11-14T14:07:56.423Z | 2024-11-21T14:25:48.374Z |
5535140 | 5535140 | 20241112114411_NtXMB | NZ0001 | 2024-11-14T14:07:18.363Z | 2024-11-21T14:25:44.170Z |
5527113 | 5527113 | 20241112110141_a90sS | NZ0001 | 2024-11-13T14:05:03.697Z | 2024-11-21T14:25:41.356Z |
5526906 | 5526906 | 20241112102824_hdlqQ | NZ0001 | 2024-11-13T14:04:30.943Z | 2024-11-21T14:25:39.609Z |
5526904 | 5526904 | 20241112102816_2pkS2 | NZ0001 | 2024-11-13T14:04:30.352Z | 2024-11-21T14:25:39.603Z |
5526821 | 5526821 | 20241112102010_KOLSU | NZ0001 | 2024-11-13T14:04:15.136Z | 2024-11-21T14:25:38.834Z |
5526474 | 5526474 | 20241112092648_6PBGq | NZ0001 | 2024-11-13T14:03:17.049Z | 2024-11-21T14:25:35.741Z |
5526450 | 5526450 | 20241112092214_P1I9V | NZ0001 | 2024-11-13T14:03:07.518Z | 2024-11-21T14:25:35.521Z |
5514459 | 5514459 | 20241110160712_vGzZi | NZ0001 | 2024-11-11T14:06:42.094Z | 2024-11-19T14:21:48.827Z |
5514376 | 5514376 | 20241110154035_5SObG | NZ0001 | 2024-11-11T14:06:33.782Z | 2024-11-19T14:21:46.909Z |
5514198 | 5514198 | 20241110150618_Nznfz | NZ0001 | 2024-11-11T14:06:20.092Z | 2024-11-19T14:21:44.792Z |
5514173 | 5514173 | 20241110145819_Tkha3 | NZ0001 | 2024-11-11T14:06:18.651Z | 2024-11-19T14:21:44.624Z |
5514106 | 5514106 | 20241110142948_B86h3 | NZ0001 | 2024-11-11T14:06:11.730Z | 2024-11-19T14:21:43.673Z |
5514076 | 5514076 | 20241110141724_Mpq1G | NZ0001 | 2024-11-11T14:06:03.198Z | 2024-11-19T14:21:43.252Z |
5514052 | 5514052 | 20241110135925_QJcKu | NZ0001 | 2024-11-11T14:05:57.805Z | 2024-11-19T14:21:42.577Z |
5494138 | 5494138 | 20241107154650_kFQPR | NZ0001 | 2024-11-08T14:05:25.520Z | 2024-11-16T14:27:48.280Z |
5494131 | 5494131 | 20241107154310_a2QEw | NZ0001 | 2024-11-08T14:05:24.990Z | 2024-11-16T14:27:48.205Z |
5494116 | 5494116 | 20241107154129_MVkyF | NZ0001 | 2024-11-08T14:05:24.208Z | 2024-11-16T14:27:48.100Z |
5494086 | 5494086 | 20241107153213_82BIj | NZ0001 | 2024-11-08T14:05:21.610Z | 2024-11-16T14:27:46.722Z |
5494039 | 5494039 | 20241107152133_HnM3i | NZ0001 | 2024-11-08T14:05:17.331Z | 2024-11-16T14:27:45.529Z |
5493900 | 5493900 | 20241107143110_nDiJL | NZ0001 | 2024-11-08T14:04:50.990Z | 2024-11-16T14:27:42.919Z |
5493835 | 5493835 | 20241107140238_YqDuP | NZ0001 | 2024-11-08T14:04:42.918Z | 2024-11-16T14:27:42.100Z |
5493820 | 5493820 | 20241107135756_X59io | NZ0001 | 2024-11-08T14:04:41.924Z | 2024-11-16T14:27:41.729Z |
5493781 | 5493781 | 20241107134159_649GK | NZ0001 | 2024-11-08T14:04:38.483Z | 2024-11-16T14:27:40.988Z |
5493748 | 5493748 | 20241107131741_lWwml | NZ0001 | 2024-11-08T14:04:34.287Z | 2024-11-16T14:27:40.071Z |
5493641 | 5493641 | 20241107125213_FyK27 | NZ0001 | 2024-11-08T14:04:24.999Z | 2024-11-16T14:27:37.946Z |
5493636 | 5493636 | 20241107125040_2jJkF | NZ0001 | 2024-11-08T14:04:24.361Z | 2024-11-16T14:27:37.773Z |
5493556 | 5493556 | 20241107123322_3Aapq | NZ0001 | 2024-11-08T14:04:04.465Z | 2024-11-16T14:27:35.966Z |
5493541 | 5493541 | 20241107123139_VfRW2 | NZ0001 | 2024-11-08T14:04:01.912Z | 2024-11-16T14:27:35.611Z |
5492873 | 5492873 | 20241107101355_mLsyw | NZ0001 | 2024-11-08T14:02:21.377Z | 2024-11-16T14:27:30.091Z |
5492870 | 5492870 | 20241107101142_m2FGJ | NZ0001 | 2024-11-08T14:02:20.744Z | 2024-11-16T14:27:30.044Z |
5492859 | 5492859 | 20241107100852_j3KxK | NZ0001 | 2024-11-08T14:02:17.969Z | 2024-11-16T14:27:29.809Z |
5492789 | 5492789 | 20241107095645_dtYz1 | NZ0001 | 2024-11-08T14:02:06.068Z | 2024-11-16T14:27:28.788Z |
5492750 | 5492750 | 20241107094929_qCXB2 | NZ0001 | 2024-11-08T14:02:01.764Z | 2024-11-16T14:27:28.555Z |
5474012 | 5474012 | 20241103153816_PqRmN | NZ0001 | 2024-11-05T14:10:00.324Z | 2024-11-12T14:27:50.448Z |
5473938 | 5473938 | 20241103152407_7vZ2d | NZ0001 | 2024-11-05T14:09:54.673Z | 2024-11-12T14:27:50.236Z |
5473751 | 5473751 | 20241103145905_d7U6T | NZ0001 | 2024-11-05T14:09:41.347Z | 2024-11-12T14:27:49.991Z |
5472174 | 5472174 | 20241104135917_cexZC | NZ0001 | 2024-11-05T14:05:24.132Z | 2024-11-13T14:27:25.834Z |
5472059 | 5472059 | 20241104133244_aHgHH | NZ0001 | 2024-11-05T14:05:03.313Z | 2024-11-13T14:27:25.675Z |
5472046 | 5472046 | 20241104133031_r3GnU | NZ0001 | 2024-11-05T14:05:01.677Z | 2024-11-13T14:27:25.657Z |
5471083 | 5471083 | 20241104104510_bzSVH | NZ0001 | 2024-11-05T14:02:50.096Z | 2024-11-13T14:27:23.629Z |
5470887 | 5470887 | 20241104095959_mnTUE | NZ0001 | 2024-11-05T14:02:11.916Z | 2024-11-13T14:27:23.109Z |
5470546 | 5470546 | 20241104084238_37vP9 | NZ0001 | 2024-11-05T14:01:04.067Z | 2024-11-13T14:27:22.348Z |
5461134 | 5461134 | 20241101160827_ihXAP | NZ0001 | 2024-11-03T14:14:45.325Z | 2024-11-10T14:26:26.822Z |
5461108 | 5461108 | 20241101155832_reQuJ | NZ0001 | 2024-11-03T14:14:43.836Z | 2024-11-10T14:26:26.755Z |
5461041 | 5461041 | 20241101153944_OZJqU | NZ0001 | 2024-11-03T14:14:40.640Z | 2024-11-10T14:26:26.586Z |
5457999 | 5457999 | 20241102155636_8kwKV | NZ0001 | 2024-11-03T14:08:31.680Z | 2024-11-11T14:22:37.883Z |
5457947 | 5457947 | 20241102154543_mK3Ai | NZ0001 | 2024-11-03T14:08:23.368Z | 2024-11-11T14:22:37.355Z |
5457479 | 5457479 | 20241102143636_lVjUJ | NZ0001 | 2024-11-03T14:07:30.467Z | 2024-11-11T14:22:34.872Z |
5457342 | 5457342 | 20241102141803_mzm9G | NZ0001 | 2024-11-03T14:07:09.326Z | 2024-11-11T14:22:34.319Z |
5457221 | 5457221 | 20241102135352_hy7vN | NZ0001 | 2024-11-03T14:06:57.321Z | 2024-11-11T14:22:33.759Z |
5457199 | 5457199 | 20241102134615_AgDp9 | NZ0001 | 2024-11-03T14:06:45.025Z | 2024-11-11T14:22:33.389Z |
5457082 | 5457082 | 20241102132901_Ovdqn | NZ0001 | 2024-11-03T14:06:31.631Z | 2024-11-11T14:22:32.708Z |
5457036 | 5457036 | 20241102131624_aqizm | NZ0001 | 2024-11-03T14:06:25.773Z | 2024-11-11T14:22:32.457Z |
5457021 | 5457021 | 20241102131349_jRGe8 | NZ0001 | 2024-11-03T14:06:23.152Z | 2024-11-11T14:22:32.371Z |
5456955 | 5456955 | 20241102125953_3FZLr | NZ0001 | 2024-11-03T14:06:09.072Z | 2024-11-11T14:22:32.218Z |
5456935 | 5456935 | 20241102125426_pisRm | NZ0001 | 2024-11-03T14:06:06.127Z | 2024-11-11T14:22:32.134Z |
5456930 | 5456930 | 20241102125355_GxCR0 | NZ0001 | 2024-11-03T14:06:04.827Z | 2024-11-11T14:22:32.131Z |
5456913 | 5456913 | 20241102125052_JPiDK | NZ0001 | 2024-11-03T14:06:00.448Z | 2024-11-11T14:22:32.060Z |
5456664 | 5456664 | 20241102120107_jR9qp | NZ0001 | 2024-11-03T14:05:16.608Z | 2024-11-11T14:22:30.345Z |
5456180 | 5456180 | 20241102103630_aeOeX | NZ0001 | 2024-11-03T14:03:43.425Z | 2024-11-11T14:22:27.056Z |
5456038 | 5456038 | 20241102101058_RxPhS | NZ0001 | 2024-11-03T14:03:10.624Z | 2024-11-11T14:22:25.897Z |
5455992 | 5455992 | 20241102100142_8u3hO | NZ0001 | 2024-11-03T14:03:03.475Z | 2024-11-11T14:22:25.396Z |
5455931 | 5455931 | 20241102094810_p3GT0 | NZ0001 | 2024-11-03T14:02:49.645Z | 2024-11-11T14:22:24.918Z |
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);