participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
765 rows where station_code = "NZ0059" 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 |
---|---|---|---|---|---|
5135353 | 5135353 | 20240915125448_x274o | NZ0059 | 2024-09-19T12:19:29.103Z | 2024-09-19T12:19:29.103Z |
5135241 | 5135241 | 20240916171421_XhZ0i | NZ0059 | 2024-09-19T12:18:17.048Z | 2024-09-19T12:18:17.048Z |
5135068 | 5135068 | 20240916160344_MKQ83 | NZ0059 | 2024-09-19T12:18:13.963Z | 2024-09-19T12:18:13.963Z |
5134969 | 5134969 | 20240916145304_CTGGb | NZ0059 | 2024-09-19T12:18:11.466Z | 2024-09-19T12:18:11.466Z |
5134904 | 5134904 | 20240916135525_Z6iN1 | NZ0059 | 2024-09-19T12:18:09.373Z | 2024-09-19T12:18:09.373Z |
5134886 | 5134886 | 20240916133710_uwbJj | NZ0059 | 2024-09-19T12:18:08.946Z | 2024-09-19T12:18:08.946Z |
5134881 | 5134881 | 20240916132228_p8QOw | NZ0059 | 2024-09-19T12:18:08.828Z | 2024-09-19T12:18:08.828Z |
5134858 | 5134858 | 20240916130045_LtOEN | NZ0059 | 2024-09-19T12:18:08.303Z | 2024-09-19T12:18:08.303Z |
5134800 | 5134800 | 20240916115313_3RNGt | NZ0059 | 2024-09-19T12:18:06.733Z | 2024-09-19T12:18:06.733Z |
5130989 | 5130989 | 20240917171341_LmhH3 | NZ0059 | 2024-09-19T12:14:02.947Z | 2024-09-19T12:14:02.947Z |
5130874 | 5130874 | 20240917160325_LBEb3 | NZ0059 | 2024-09-19T12:13:54.727Z | 2024-09-19T12:13:54.727Z |
5130834 | 5130834 | 20240917154710_1PhnL | NZ0059 | 2024-09-19T12:13:52.730Z | 2024-09-19T12:13:52.730Z |
5130617 | 5130617 | 20240917135052_c7ReJ | NZ0059 | 2024-09-19T12:13:39.927Z | 2024-09-19T12:13:39.927Z |
5130615 | 5130615 | 20240917135037_LZH3Y | NZ0059 | 2024-09-19T12:13:39.683Z | 2024-09-19T12:13:39.683Z |
5130586 | 5130586 | 20240917133031_jih73 | NZ0059 | 2024-09-19T12:13:37.584Z | 2024-09-19T12:13:37.584Z |
5130574 | 5130574 | 20240917132035_OBCZm | NZ0059 | 2024-09-19T12:13:36.893Z | 2024-09-19T12:13:36.893Z |
5130569 | 5130569 | 20240917131631_KLH2S | NZ0059 | 2024-09-19T12:13:36.314Z | 2024-09-19T12:13:36.314Z |
5130507 | 5130507 | 20240917123511_vZbaY | NZ0059 | 2024-09-19T12:13:28.224Z | 2024-09-19T12:13:28.224Z |
5130486 | 5130486 | 20240917122200_3s6QL | NZ0059 | 2024-09-19T12:13:23.854Z | 2024-09-19T12:13:23.854Z |
5130472 | 5130472 | 20240917121825_7mh2O | NZ0059 | 2024-09-19T12:13:20.611Z | 2024-09-19T12:13:20.611Z |
5130328 | 5130328 | 20240917112511_z8x35 | NZ0059 | 2024-09-19T12:13:00.587Z | 2024-09-19T12:13:00.587Z |
5126610 | 5126610 | 20240918161808_fP94f | NZ0059 | 2024-09-19T12:06:32.585Z | 2024-09-19T12:06:42.235Z |
5126605 | 5126605 | 20240918161143_c494k | NZ0059 | 2024-09-19T12:06:31.886Z | 2024-09-19T12:06:42.234Z |
5126562 | 5126562 | 20240918145434_43HH7 | NZ0059 | 2024-09-19T12:06:20.803Z | 2024-09-19T12:06:42.226Z |
5126560 | 5126560 | 20240918145154_2VI2o | NZ0059 | 2024-09-19T12:06:20.333Z | 2024-09-19T12:06:42.225Z |
5126533 | 5126533 | 20240918135833_Tij2D | NZ0059 | 2024-09-19T12:06:11.672Z | 2024-09-19T12:06:42.219Z |
5126465 | 5126465 | 20240918120209_sphou | NZ0059 | 2024-09-19T12:06:00.680Z | 2024-09-19T12:06:42.205Z |
5126397 | 5126397 | 20240918112157_h0CfC | NZ0059 | 2024-09-19T12:05:53.654Z | 2024-09-19T12:06:42.194Z |
5126311 | 5126311 | 20240918104114_tbAIJ | NZ0059 | 2024-09-19T12:05:38.691Z | 2024-09-19T12:06:42.178Z |
5118791 | 5118791 | 20240915110851_tXILP | NZ0059 | 2024-09-18T12:09:03.314Z | 2024-09-19T12:19:25.501Z |
5110224 | 5110224 | 20240913134418_dW6tL | NZ0059 | 2024-09-17T12:15:00.277Z | 2024-09-19T12:20:56.160Z |
5096797 | 5096797 | 20240912114544_kaAl9 | NZ0059 | 2024-09-16T12:16:34.926Z | 2024-09-19T12:21:23.738Z |
5096442 | 5096442 | 20240912105120_xVAHa | NZ0059 | 2024-09-16T12:16:23.567Z | 2024-09-19T12:21:22.324Z |
5096014 | 5096014 | 20240912094250_vwsXo | NZ0059 | 2024-09-16T12:16:05.517Z | 2024-09-19T12:21:20.976Z |
5095794 | 5095794 | 20240912090421_0gyBG | NZ0059 | 2024-09-16T12:15:58.410Z | 2024-09-19T12:21:20.234Z |
5095539 | 5095539 | 20240912080125_nQjFm | NZ0059 | 2024-09-16T12:15:46.269Z | 2024-09-19T12:21:18.855Z |
5083752 | 5083752 | 20240911142025_Gvgl5 | NZ0059 | 2024-09-15T12:18:45.998Z | 2024-09-19T12:21:49.903Z |
5083732 | 5083732 | 20240911141357_oQZ5s | NZ0059 | 2024-09-15T12:18:45.823Z | 2024-09-19T12:21:49.878Z |
5083702 | 5083702 | 20240911141237_RD29c | NZ0059 | 2024-09-15T12:18:45.613Z | 2024-09-19T12:21:49.813Z |
5083659 | 5083659 | 20240911140535_ePwgN | NZ0059 | 2024-09-15T12:18:45.137Z | 2024-09-19T12:21:49.754Z |
5083407 | 5083407 | 20240911131102_lrO7L | NZ0059 | 2024-09-15T12:18:40.773Z | 2024-09-19T12:21:49.551Z |
5083222 | 5083222 | 20240911123205_S5ZtW | NZ0059 | 2024-09-15T12:18:37.045Z | 2024-09-19T12:21:49.416Z |
5083174 | 5083174 | 20240911121552_82g3C | NZ0059 | 2024-09-15T12:18:36.420Z | 2024-09-19T12:21:49.363Z |
5083121 | 5083121 | 20240911121028_MXLyK | NZ0059 | 2024-09-15T12:18:35.918Z | 2024-09-19T12:21:49.350Z |
5083006 | 5083006 | 20240911114456_W9yPa | NZ0059 | 2024-09-15T12:18:32.705Z | 2024-09-19T12:21:49.087Z |
5082933 | 5082933 | 20240911112834_bM5Cf | NZ0059 | 2024-09-15T12:18:31.328Z | 2024-09-19T12:21:48.914Z |
5082858 | 5082858 | 20240911111353_3x4qu | NZ0059 | 2024-09-15T12:18:27.327Z | 2024-09-19T12:21:48.775Z |
5082845 | 5082845 | 20240911111221_qNjP9 | NZ0059 | 2024-09-15T12:18:27.157Z | 2024-09-19T12:21:48.771Z |
5082719 | 5082719 | 20240911104923_dsqdV | NZ0059 | 2024-09-15T12:18:23.497Z | 2024-09-19T12:21:48.444Z |
5082436 | 5082436 | 20240911100830_QV58Q | NZ0059 | 2024-09-15T12:18:15.066Z | 2024-09-19T12:21:47.958Z |
5082091 | 5082091 | 20240911092010_ZVchJ | NZ0059 | 2024-09-15T12:18:02.710Z | 2024-09-19T12:21:47.175Z |
5082024 | 5082024 | 20240911091414_jCjeJ | NZ0059 | 2024-09-15T12:17:59.560Z | 2024-09-19T12:21:47.052Z |
5081578 | 5081578 | 20240911080540_Ymyhg | NZ0059 | 2024-09-15T12:17:38.205Z | 2024-09-19T12:21:45.791Z |
5081210 | 5081210 | 20240911065550_MQwav | NZ0059 | 2024-09-15T12:17:26.878Z | 2024-09-19T12:21:44.758Z |
5071545 | 5071545 | 20240911171337_yw9RE | NZ0059 | 2024-09-15T12:02:52.317Z | 2024-09-19T12:21:02.088Z |
5071482 | 5071482 | 20240911170112_dVBhL | NZ0059 | 2024-09-15T12:02:39.153Z | 2024-09-19T12:21:01.984Z |
5071468 | 5071468 | 20240911165925_vtakP | NZ0059 | 2024-09-15T12:02:38.324Z | 2024-09-19T12:21:01.979Z |
5071425 | 5071425 | 20240911164943_SR1c4 | NZ0059 | 2024-09-15T12:02:30.332Z | 2024-09-19T12:21:01.861Z |
5071372 | 5071372 | 20240911164318_AAAMh | NZ0059 | 2024-09-15T12:02:23.583Z | 2024-09-19T12:21:01.772Z |
5071350 | 5071350 | 20240911163754_mA82Q | NZ0059 | 2024-09-15T12:02:20.872Z | 2024-09-19T12:21:01.747Z |
5071334 | 5071334 | 20240911163458_c56NI | NZ0059 | 2024-09-15T12:02:19.028Z | 2024-09-19T12:21:01.438Z |
5071322 | 5071322 | 20240911163309_l5WfF | NZ0059 | 2024-09-15T12:02:17.746Z | 2024-09-19T12:21:01.416Z |
5071305 | 5071305 | 20240911163018_ZZDQK | NZ0059 | 2024-09-15T12:02:12.330Z | 2024-09-19T12:21:01.397Z |
5071280 | 5071280 | 20240911162831_lJuLK | NZ0059 | 2024-09-15T12:02:09.264Z | 2024-09-19T12:21:01.373Z |
5071209 | 5071209 | 20240911161540_yRq8h | NZ0059 | 2024-09-15T12:01:53.997Z | 2024-09-19T12:21:01.214Z |
5071186 | 5071186 | 20240911161251_27b8X | NZ0059 | 2024-09-15T12:01:51.490Z | 2024-09-19T12:21:01.190Z |
5071177 | 5071177 | 20240911161222_NsSHD | NZ0059 | 2024-09-15T12:01:50.588Z | 2024-09-19T12:21:01.177Z |
5071160 | 5071160 | 20240911160928_8PJS9 | NZ0059 | 2024-09-15T12:01:48.914Z | 2024-09-19T12:21:01.129Z |
5071079 | 5071079 | 20240911155640_UKLUe | NZ0059 | 2024-09-15T12:01:36.001Z | 2024-09-19T12:21:00.861Z |
5070924 | 5070924 | 20240911152839_gHyjA | NZ0059 | 2024-09-15T12:01:09.641Z | 2024-09-19T12:21:00.590Z |
5070794 | 5070794 | 20240911151107_YuJST | NZ0059 | 2024-09-15T12:00:51.239Z | 2024-09-19T12:21:00.280Z |
5070711 | 5070711 | 20240911145718_lPqqw | NZ0059 | 2024-09-15T12:00:39.369Z | 2024-09-19T12:21:00.087Z |
5070638 | 5070638 | 20240911144354_kf5Dp | NZ0059 | 2024-09-15T12:00:27.310Z | 2024-09-19T12:20:59.628Z |
5070615 | 5070615 | 20240911144038_E5p2u | NZ0059 | 2024-09-15T12:00:24.057Z | 2024-09-19T12:20:59.383Z |
5070572 | 5070572 | 20240911143411_mTJIv | NZ0059 | 2024-09-15T12:00:19.839Z | 2024-09-19T12:20:59.291Z |
5070533 | 5070533 | 20240911142732_nxYl4 | NZ0059 | 2024-09-15T12:00:15.335Z | 2024-09-19T12:20:59.215Z |
5070484 | 5070484 | 20240908070916_ym6Rw | NZ0059 | 2024-09-14T12:21:54.024Z | 2024-09-16T12:21:18.098Z |
5068995 | 5068995 | 20240910132007_Ch14F | NZ0059 | 2024-09-14T12:19:23.556Z | 2024-09-18T12:15:26.970Z |
5068905 | 5068905 | 20240910125746_iCMhv | NZ0059 | 2024-09-14T12:19:22.792Z | 2024-09-18T12:15:26.809Z |
5066740 | 5066740 | 20240910081105_3lfKk | NZ0059 | 2024-09-14T12:18:09.809Z | 2024-09-18T12:15:22.648Z |
5062364 | 5062364 | 20240909171606_cy2Os | NZ0059 | 2024-09-14T12:12:13.864Z | 2024-09-18T12:15:11.026Z |
5062309 | 5062309 | 20240909170900_S8H1k | NZ0059 | 2024-09-14T12:12:08.267Z | 2024-09-18T12:15:10.843Z |
5062083 | 5062083 | 20240909164306_32URo | NZ0059 | 2024-09-14T12:11:48.058Z | 2024-09-18T12:15:10.362Z |
5061028 | 5061028 | 20240909135343_1eN3x | NZ0059 | 2024-09-14T12:10:06.914Z | 2024-09-18T12:15:07.841Z |
5058500 | 5058500 | 20240910161718_xRabQ | NZ0059 | 2024-09-14T12:03:48.017Z | 2024-09-19T12:21:29.648Z |
5057808 | 5057808 | 20240910151537_7223P | NZ0059 | 2024-09-14T12:02:09.026Z | 2024-09-19T12:21:28.825Z |
5057598 | 5057598 | 20240910145401_tV3CM | NZ0059 | 2024-09-14T12:01:30.128Z | 2024-09-19T12:21:28.421Z |
5057519 | 5057519 | 20240910143954_DwBMJ | NZ0059 | 2024-09-14T12:01:18.521Z | 2024-09-19T12:21:28.222Z |
5057393 | 5057393 | 20240910142153_LU79w | NZ0059 | 2024-09-14T12:00:59.481Z | 2024-09-19T12:21:27.663Z |
5057068 | 5057068 | 20240908120639_kjcCP | NZ0059 | 2024-09-13T12:17:44.390Z | 2024-09-16T12:21:28.728Z |
5056801 | 5056801 | 20240908112737_SYtf5 | NZ0059 | 2024-09-13T12:17:39.484Z | 2024-09-16T12:21:27.340Z |
5056664 | 5056664 | 20240908105933_4bjzU | NZ0059 | 2024-09-13T12:17:36.864Z | 2024-09-16T12:21:26.469Z |
5056542 | 5056542 | 20240908103949_Ddpak | NZ0059 | 2024-09-13T12:17:34.826Z | 2024-09-16T12:21:25.796Z |
5056215 | 5056215 | 20240908095542_rGEpG | NZ0059 | 2024-09-13T12:17:28.519Z | 2024-09-16T12:21:23.858Z |
5056044 | 5056044 | 20240908093308_t3tMF | NZ0059 | 2024-09-13T12:17:26.940Z | 2024-09-16T12:21:23.054Z |
5056031 | 5056031 | 20240908093217_wVjhL | NZ0059 | 2024-09-13T12:17:26.840Z | 2024-09-16T12:21:23.044Z |
5056013 | 5056013 | 20240908093159_uUkBt | NZ0059 | 2024-09-13T12:17:26.730Z | 2024-09-16T12:21:23.025Z |
5055911 | 5055911 | 20240908091604_x07n9 | NZ0059 | 2024-09-13T12:17:25.438Z | 2024-09-16T12:21:22.569Z |
5055702 | 5055702 | 20240908084217_CF8g1 | NZ0059 | 2024-09-13T12:17:20.436Z | 2024-09-16T12:21:21.654Z |
5055673 | 5055673 | 20240908083650_35w2F | NZ0059 | 2024-09-13T12:17:19.686Z | 2024-09-16T12:21:21.486Z |
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);