participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,770 rows where station_code = "NZ000L" 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 |
---|---|---|---|---|---|
5071572 | 5071572 | 20240911171824_83CPO | NZ000L | 2024-09-15T12:02:59.857Z | 2024-09-19T12:21:02.126Z |
5071567 | 5071567 | 20240911171811_7CE60 | NZ000L | 2024-09-15T12:02:59.160Z | 2024-09-19T12:21:02.119Z |
5068991 | 5068991 | 20240910131930_enJaH | NZ000L | 2024-09-14T12:19:23.495Z | 2024-09-18T12:15:26.959Z |
5062053 | 5062053 | 20240909163804_TtS0b | NZ000L | 2024-09-14T12:11:46.876Z | 2024-09-18T12:15:10.351Z |
5061336 | 5061336 | 20240909145008_Zthqj | NZ000L | 2024-09-14T12:10:43.061Z | 2024-09-18T12:15:08.938Z |
5050867 | 5050867 | 20240907161740_OGsUl | NZ000L | 2024-09-13T12:13:50.356Z | 2024-09-16T12:20:58.834Z |
5049911 | 5049911 | 20240909115737_xxiMh | NZ000L | 2024-09-13T12:12:31.304Z | 2024-09-17T12:19:11.811Z |
5045294 | 5045294 | 20240908164923_nTldm | NZ000L | 2024-09-13T12:03:53.437Z | 2024-09-17T12:18:56.337Z |
5044710 | 5044710 | 20240908153125_XXuH0 | NZ000L | 2024-09-13T12:02:49.813Z | 2024-09-17T12:18:54.883Z |
5044241 | 5044241 | 20240908143341_2wobL | NZ000L | 2024-09-13T12:01:44.599Z | 2024-09-17T12:18:53.885Z |
5043235 | 5043235 | 20240907141015_wncDa | NZ000L | 2024-09-12T12:17:25.474Z | 2024-09-16T12:20:55.943Z |
5043156 | 5043156 | 20240907135815_6RpOp | NZ000L | 2024-09-12T12:17:24.221Z | 2024-09-16T12:20:55.679Z |
5041349 | 5041349 | 20240906080200_VX2kY | NZ000L | 2024-09-12T12:16:39.283Z | 2024-09-14T12:23:13.311Z |
5036302 | 5036302 | 20240905131325_vsk1I | NZ000L | 2024-09-12T12:13:33.883Z | 2024-09-14T12:22:52.255Z |
5035725 | 5035725 | 20240907101238_gBA9Q | NZ000L | 2024-09-12T12:12:24.345Z | 2024-09-15T12:21:41.012Z |
5035690 | 5035690 | 20240907100645_pAjam | NZ000L | 2024-09-12T12:12:22.522Z | 2024-09-15T12:21:40.563Z |
5034698 | 5034698 | 20240907074504_RppPP | NZ000L | 2024-09-12T12:11:12.895Z | 2024-09-15T12:21:35.565Z |
5016865 | 5016865 | 20240904150716_adkMj | NZ000L | 2024-09-10T12:08:26.511Z | 2024-09-13T12:19:46.400Z |
5014623 | 5014623 | 20240905131325_SBT47 | NZ000L | 2024-09-10T12:03:34.924Z | 2024-09-11T12:16:31.230Z |
5006590 | 5006590 | 20240903175710_kGqGO | NZ000L | 2024-09-09T12:04:47.833Z | 2024-09-12T12:19:08.986Z |
5006401 | 5006401 | 20240903173247_3ocD0 | NZ000L | 2024-09-09T12:04:37.275Z | 2024-09-12T12:19:08.251Z |
5006102 | 5006102 | 20240903165438_0IVvr | NZ000L | 2024-09-09T12:04:20.791Z | 2024-09-12T12:19:07.637Z |
5005278 | 5005278 | 20240903144620_3fKfJ | NZ000L | 2024-09-09T12:03:33.333Z | 2024-09-12T12:19:05.636Z |
5005270 | 5005270 | 20240903144314_LaPMY | NZ000L | 2024-09-09T12:03:32.795Z | 2024-09-12T12:19:05.616Z |
5005167 | 5005167 | 20240903142200_Hi3aC | NZ000L | 2024-09-09T12:03:24.330Z | 2024-09-12T12:19:05.391Z |
5004859 | 5004859 | 20240903130831_xZUXt | NZ000L | 2024-09-09T12:03:08.291Z | 2024-09-12T12:19:04.357Z |
4995062 | 4995062 | 20240902160810_dJQ3R | NZ000L | 2024-09-08T12:03:13.714Z | 2024-09-11T12:20:41.581Z |
4994569 | 4994569 | 20240902143224_cJrdi | NZ000L | 2024-09-08T12:02:42.844Z | 2024-09-11T12:20:35.115Z |
4994208 | 4994208 | 20240902124757_rBu67 | NZ000L | 2024-09-08T12:02:20.561Z | 2024-09-11T12:20:31.726Z |
4960380 | 4960380 | 20240811162232_zYPcT | NZ000L | 2024-09-04T12:02:29.642Z | 2024-09-06T12:02:06.688Z |
4931722 | 4931722 | 20240810110120_6dKTi | NZ000L | 2024-08-31T12:24:52.596Z | 2024-09-02T12:31:08.646Z |
4931714 | 4931714 | 20240810110042_Bqx9s | NZ000L | 2024-08-31T12:24:51.665Z | 2024-09-02T12:31:08.316Z |
4930806 | 4930806 | 20240810090242_i2KPu | NZ000L | 2024-08-31T12:23:57.974Z | 2024-09-02T12:30:27.074Z |
4930730 | 4930730 | 20240810085403_dgUEv | NZ000L | 2024-08-31T12:23:50.668Z | 2024-09-02T12:30:24.483Z |
4910277 | 4910277 | 20240809175522_UurZE | NZ000L | 2024-08-29T12:06:01.698Z | 2024-09-02T12:20:37.416Z |
4908746 | 4908746 | 20240809160022_6GP0b | NZ000L | 2024-08-29T12:04:24.190Z | 2024-09-02T12:19:25.374Z |
4908399 | 4908399 | 20240809153707_C61qT | NZ000L | 2024-08-29T12:04:03.408Z | 2024-09-02T12:19:12.270Z |
4908364 | 4908364 | 20240809153548_VkLll | NZ000L | 2024-08-29T12:04:01.692Z | 2024-09-02T12:19:11.499Z |
4908105 | 4908105 | 20240809151640_0YFjA | NZ000L | 2024-08-29T12:03:41.928Z | 2024-09-02T12:18:53.811Z |
4907688 | 4907688 | 20240809144237_XwRQH | NZ000L | 2024-08-29T12:03:18.643Z | 2024-09-02T12:18:37.932Z |
4907524 | 4907524 | 20240809142749_eR2zf | NZ000L | 2024-08-29T12:03:07.966Z | 2024-09-02T12:18:32.891Z |
4907308 | 4907308 | 20240809140827_Yfw9T | NZ000L | 2024-08-29T12:02:52.749Z | 2024-09-02T12:18:18.184Z |
4907097 | 4907097 | 20240809134545_Pbxga | NZ000L | 2024-08-29T12:02:39.620Z | 2024-09-02T12:18:08.341Z |
4906573 | 4906573 | 20240809125220_3fruF | NZ000L | 2024-08-29T12:02:01.205Z | 2024-09-02T12:17:42.586Z |
4906436 | 4906436 | 20240809124116_frRkV | NZ000L | 2024-08-29T12:01:52.249Z | 2024-09-02T12:17:37.562Z |
4906328 | 4906328 | 20240809122917_aIe2m | NZ000L | 2024-08-29T12:01:44.483Z | 2024-09-02T12:17:33.547Z |
4905920 | 4905920 | 20240809113534_e18CR | NZ000L | 2024-08-29T12:01:11.668Z | 2024-09-02T12:17:19.739Z |
4905212 | 4905212 | 20240808084745_JJOsI | NZ000L | 2024-08-28T12:21:10.569Z | 2024-08-28T12:21:10.569Z |
4905192 | 4905192 | 20240808084226_aX3Z8 | NZ000L | 2024-08-28T12:21:09.790Z | 2024-08-28T12:21:09.790Z |
4885509 | 4885509 | 20240808102722_wKop3 | NZ000L | 2024-08-28T12:00:46.600Z | 2024-08-30T12:15:36.543Z |
4885288 | 4885288 | 20240808095524_B4RgW | NZ000L | 2024-08-28T12:00:21.362Z | 2024-08-30T12:15:26.939Z |
4866562 | 4866562 | 20240806155653_4k38r | NZ000L | 2024-08-18T12:07:43.241Z | 2024-08-27T12:07:01.788Z |
4866066 | 4866066 | 20240806152845_3Nhi2 | NZ000L | 2024-08-18T12:07:21.921Z | 2024-08-27T12:06:40.378Z |
4865544 | 4865544 | 20240806150548_N5X52 | NZ000L | 2024-08-18T12:07:03.043Z | 2024-08-27T12:06:23.609Z |
4865415 | 4865415 | 20240806145835_mI1e3 | NZ000L | 2024-08-18T12:06:52.195Z | 2024-08-27T12:06:19.085Z |
4864659 | 4864659 | 20240806142800_aXtzE | NZ000L | 2024-08-18T12:06:13.285Z | 2024-08-27T12:05:45.625Z |
4863414 | 4863414 | 20240806132231_i29Ql | NZ000L | 2024-08-18T12:05:12.067Z | 2024-08-27T12:04:53.275Z |
4862702 | 4862702 | 20240806124739_WccnS | NZ000L | 2024-08-18T12:04:37.053Z | 2024-08-27T12:04:26.041Z |
4861966 | 4861966 | 20240806120819_FhWb2 | NZ000L | 2024-08-18T12:04:05.144Z | 2024-08-27T12:03:56.649Z |
4861566 | 4861566 | 20240806114229_Mm6OZ | NZ000L | 2024-08-18T12:03:46.965Z | 2024-08-27T12:03:39.421Z |
4860705 | 4860705 | 20240806105554_2cYOY | NZ000L | 2024-08-18T12:03:03.839Z | 2024-08-27T12:02:59.463Z |
4860450 | 4860450 | 20240806104106_cF98d | NZ000L | 2024-08-18T12:02:46.612Z | 2024-08-27T12:02:46.809Z |
4859884 | 4859884 | 20240806100746_0GHor | NZ000L | 2024-08-18T12:02:18.385Z | 2024-08-27T12:02:20.658Z |
4848731 | 4848731 | 20240805171917_6i3js | NZ000L | 2024-08-17T12:10:54.472Z | 2024-08-19T12:21:39.662Z |
4848253 | 4848253 | 20240805165859_lLBYV | NZ000L | 2024-08-17T12:10:22.293Z | 2024-08-19T12:21:15.459Z |
4847042 | 4847042 | 20240805163918_8aJqr | NZ000L | 2024-08-16T12:10:45.507Z | 2024-08-19T12:21:04.636Z |
4846756 | 4846756 | 20240805162620_ErqSW | NZ000L | 2024-08-16T12:10:31.173Z | 2024-08-19T12:20:59.744Z |
4846252 | 4846252 | 20240805160932_9RA7u | NZ000L | 2024-08-16T12:10:00.197Z | 2024-08-19T12:20:51.192Z |
4845752 | 4845752 | 20240805154650_1A1TB | NZ000L | 2024-08-16T12:09:31.733Z | 2024-08-19T12:20:32.125Z |
4845663 | 4845663 | 20240805154430_Eu7ck | NZ000L | 2024-08-16T12:09:29.108Z | 2024-08-19T12:20:29.401Z |
4845323 | 4845323 | 20240805153146_tDleB | NZ000L | 2024-08-16T12:09:04.197Z | 2024-08-19T12:20:12.296Z |
4844543 | 4844543 | 20240805150538_cckm9 | NZ000L | 2024-08-16T12:08:26.110Z | 2024-08-19T12:19:37.879Z |
4844097 | 4844097 | 20240805145126_9rdad | NZ000L | 2024-08-16T12:07:53.331Z | 2024-08-19T12:19:16.218Z |
4843432 | 4843432 | 20240805142008_9Q1b5 | NZ000L | 2024-08-16T12:07:22.170Z | 2024-08-19T12:18:52.498Z |
4842407 | 4842407 | 20240805133302_5gOh7 | NZ000L | 2024-08-16T12:06:21.987Z | 2024-08-19T12:18:32.691Z |
4842347 | 4842347 | 20240805133150_i1wnk | NZ000L | 2024-08-16T12:06:19.280Z | 2024-08-19T12:18:31.799Z |
4842189 | 4842189 | 20240805132212_wpGe6 | NZ000L | 2024-08-16T12:06:11.430Z | 2024-08-19T12:18:29.177Z |
4842183 | 4842183 | 20240805132141_ikjen | NZ000L | 2024-08-16T12:06:11.185Z | 2024-08-19T12:18:29.061Z |
4841982 | 4841982 | 20240805131240_q4aVg | NZ000L | 2024-08-16T12:06:01.755Z | 2024-08-19T12:18:21.347Z |
4841761 | 4841761 | 20240805125926_oUrE2 | NZ000L | 2024-08-16T12:05:44.554Z | 2024-08-19T12:18:11.298Z |
4841558 | 4841558 | 20240805124712_UZcmm | NZ000L | 2024-08-16T12:05:32.380Z | 2024-08-19T12:18:01.843Z |
4841411 | 4841411 | 20240805123847_2DO8R | NZ000L | 2024-08-16T12:05:25.105Z | 2024-08-19T12:17:54.306Z |
4840265 | 4840265 | 20240805111721_BBhsp | NZ000L | 2024-08-16T12:04:19.859Z | 2024-08-19T12:17:01.867Z |
4840214 | 4840214 | 20240805111521_gz73s | NZ000L | 2024-08-16T12:04:18.081Z | 2024-08-19T12:17:00.999Z |
4839819 | 4839819 | 20240805104626_z7J27 | NZ000L | 2024-08-16T12:03:53.508Z | 2024-08-19T12:16:52.349Z |
4839367 | 4839367 | 20240805101746_kNElr | NZ000L | 2024-08-16T12:03:27.128Z | 2024-08-19T12:16:41.517Z |
4838630 | 4838630 | 20240805091022_ySN5v | NZ000L | 2024-08-16T12:02:32.292Z | 2024-08-19T12:15:55.258Z |
4817091 | 4817091 | 20240803183658_zfpX3 | NZ000L | 2024-08-13T12:14:48.132Z | 2024-08-15T12:23:11.096Z |
4817005 | 4817005 | 20240803182953_FYivL | NZ000L | 2024-08-13T12:14:44.098Z | 2024-08-15T12:23:09.417Z |
4816905 | 4816905 | 20240803182424_JmT5Y | NZ000L | 2024-08-13T12:14:39.590Z | 2024-08-15T12:23:07.894Z |
4816319 | 4816319 | 20240803174914_GNYJ8 | NZ000L | 2024-08-13T12:14:11.915Z | 2024-08-15T12:22:57.345Z |
4815665 | 4815665 | 20240803171644_1zM0h | NZ000L | 2024-08-13T12:13:43.343Z | 2024-08-15T12:22:48.540Z |
4815093 | 4815093 | 20240803165226_S4i8Q | NZ000L | 2024-08-13T12:13:18.416Z | 2024-08-15T12:22:31.724Z |
4814758 | 4814758 | 20240803163958_5SGwc | NZ000L | 2024-08-13T12:13:00.283Z | 2024-08-15T12:22:18.824Z |
4814437 | 4814437 | 20240803162707_pEmPT | NZ000L | 2024-08-13T12:12:44.107Z | 2024-08-15T12:22:06.469Z |
4814215 | 4814215 | 20240803161620_lbm0q | NZ000L | 2024-08-13T12:12:37.300Z | 2024-08-15T12:21:58.679Z |
4813599 | 4813599 | 20240803154906_oDbLB | NZ000L | 2024-08-13T12:12:06.723Z | 2024-08-15T12:21:37.535Z |
4813270 | 4813270 | 20240803153526_u7QcN | NZ000L | 2024-08-13T12:11:46.454Z | 2024-08-15T12:21:28.962Z |
4812686 | 4812686 | 20240803150812_pU5oa | NZ000L | 2024-08-13T12:11:05.555Z | 2024-08-15T12:21:15.500Z |
4812053 | 4812053 | 20240803143933_qRlzn | NZ000L | 2024-08-13T12:10:33.795Z | 2024-08-15T12:21:05.609Z |
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);