Mercurial > hg > extraction-interface
view interface/parsing_files/172240_2013_08_07_20_40_29.txt @ 2:da5309d54083
add missing books to sections as dummy entries for further modification.
(1) Alter "Auto_increment" to 5190896 for sections table in database.
(2) Finds missing books (using mysql OR _select_distinct() in add_missing_books_to_sections.php
(3) Put the missing_books.csv in intermediate_results.
and execute: add_missing_books_to_sections.php
author | Zoe Hong <zhong@mpiwg-berlin.mpg.de> |
---|---|
date | Fri, 23 Jan 2015 19:00:57 +0100 |
parents | b12c99b7c3f0 |
children |
line wrap: on
line source
【173】諸羅縣志卷三 秩官志 秩官 列傳 縣有官師所以教養斯民也令丞簿尉皆是也宋 以前學無專官令佐理之厥後有教諭有訓導宋 寨官有巡檢然率受成於令而已既兼眾職而於 民最親故一方之安危繫縣令之賢否詩曰豈弟 君子民之父母豈以強教明察之長也弟以悅安 慈惠之師也風雅之旨明著深切況茲邑新造可 【174】 不務乎尉巡檢分任境內司鐸之諭正誼明道以 一身表率諸生尚無曠厥職哉 秩官 諸羅縣設自康熙二十三年知縣一員典史一員佳 里興巡檢司巡檢一員儒學教諭一員初由部選康 熙三十年奉 旨臺灣各官自道員以下教職以上俱照廣西南寧 等府之例將品級相當現任官員內揀選調補三年 【175】滿即陞如無品級相當堪調之員仍歸部選著為令 三十六年奉 旨各省調補官員知縣以上俱令赴部引 見察其能否五十三年奉 旨教職等官有教<jiguan>習士子作養</jiguan><null>人</null>材之責嗣後補授 教職俱著赴部考試引 見五十五年奉 旨免其來京仍交與該督撫考試可用者補授諸羅 【176】調補自三十四年閩清知縣董之弼教諭林弼始蓋 同時並調云 〈知縣〉 <person></person><office>〈知縣〉</office><person>季麒光</person> <jiguan>江南無錫</jiguan><null>人</null><entry_time>丙辰</entry_time><entry_way><entry_way>進士</entry_way></entry_way> <post_time>康熙</post_time><post_time>二十二</post_time><post_time>年</post_time><post_type>任</post_type>有傳 <office>〈知縣〉</office><person>樊維屏</person> <jiguan>山西蒲州</jiguan><null>人</null><entry_way>歲貢</entry_way> <post_time>康熙</post_time><post_time>二十五</post_time><post_time>年</post_time><post_type>任</post_type> <office>〈知縣〉</office><person>朱道中</person> <jiguan>江南休寧</jiguan><null>人</null><entry_way>監生</entry_way><post_time>康熙</post_time> <post_time>二十八</post_time><post_time>年</post_time><post_type>任</post_type>卒於官 <office>〈知縣〉</office><person>張 ?</person> <jiguan>山西崞縣</jiguan><null>人</null><entry_way>歲貢</entry_way><post_time>康 熙</post_time><post_time>二十九</post_time><post_time>年</post_time><post_type>任</post_type>有傳 <office>〈知縣〉</office><person>董之弼</person> <jiguan>遼東</jiguan><null>人</null><entry_way>監生</entry_way>閩清縣調 補<post_time>康熙</post_time><post_time>三十四</post_time><post_time>年</post_time><post_type>任</post_type> <office>〈知縣〉</office>【177】 <office>〈知縣〉</office><person>毛鳳綸</person> <jiguan>奉天</jiguan><null>人</null>官<entry_way>監生</entry_way>建陽縣調補<post_time>康熙</post_time><post_time>三十 九</post_time><post_time>年</post_time><post_type>任</post_type>四十三年陞江西吉安府同知 <office>〈知縣〉</office><person>毛殿颺</person> <jiguan>廣東博羅</jiguan><null>人</null><entry_time>甲戌</entry_time><entry_way><entry_way>進士</entry_way></entry_way>詔安縣調補<post_time>康熙</post_time><post_time>四 十四</post_time><post_time>年</post_time><post_type>任</post_type>未數月卒於官賦性狷介漳志稱 其在詔安時<null>人</null>不敢干以私革陋規戢豪 暴設紙皂便民修橋樑道路善政甚多 <office>〈知縣〉</office><person>李 鏞</person> <jiguan>正黃旗</jiguan><null>人</null><entry_way>監生</entry_way>寧洋縣 調補<post_time>康熙</post_time><post_time>四十五</post_time><post_time>年</post_time><post_type>任</post_type> <office>〈知縣〉</office><person>劉作楫</person> <jiguan>江西廬陵</jiguan><null>人</null><entry_time>庚辰</entry_time><entry_way><entry_way>進士</entry_way></entry_way>由 銓選<post_time>康熙</post_time><post_time>四十八</post_time><post_time>年</post_time><post_type>任</post_type> <office>〈知縣〉</office><person>劉宗樞</person> <jiguan>正白旗</jiguan><null>人</null><entry_way>監生</entry_way>尤溪縣調補 <post_time>康熙</post_time><post_time>五十一</post_time><post_time>年</post_time><post_type>任</post_type>以憂去 <office>〈知縣〉</office><person>周鍾瑄</person> <jiguan>貴州貴筑</jiguan><null>人</null><entry_time>丙子</entry_time><entry_way><entry_way>舉人</entry_way></entry_way>邵武 縣調補<post_time>康熙</post_time><post_time>五十三</post_time><post_time>年</post_time><post_type>任</post_type> 〈典史〉 【178】 <person></person><office>〈典史〉</office><person>楊輔業</person> <jiguan>陝西富平</jiguan><null>人</null><entry_way>吏員</entry_way><post_time>康熙</post_time><post_time>二十三</post_time><post_time>年</post_time> <post_type>任</post_type>二十七年陞江南和州吏目 <office>〈典史〉</office><person>宋應龍</person> <jiguan>直隸新樂</jiguan><null>人</null><entry_way>吏員</entry_way><post_time>康熙</post_time><post_time>二十八</post_time> <post_time>年</post_time><post_type>任</post_type>三十一年陞刑部司獄司 <office>〈典史〉</office><person>嚴時泰</person> <jiguan>浙江錢塘</jiguan><null>人</null><entry_way>吏員</entry_way> <post_time>康熙</post_time><post_time>三十二</post_time><post_time>年</post_time><post_type>任</post_type> <office>〈典史〉</office><person>蔣復新</person> <jiguan>江南潁川</jiguan><null>人</null><entry_way>吏員</entry_way>龍溪縣典 史調補<post_time>康熙</post_time><post_time>三十六</post_time><post_time>年</post_time><post_type>任</post_type> <office>〈典史〉</office><person>楊永祚</person> <jiguan>陝西華州</jiguan><null>人</null><entry_way>吏員</entry_way>長樂縣 典史調補<post_time>康熙</post_time><post_time>四十</post_time><post_time>年</post_time><post_type>任</post_type> <office>〈典史〉</office><person>田詔尹</person> <jiguan>陝西</jiguan><null>人</null>晉江縣典史調補<post_time>康熙</post_time><post_time>四 十二</post_time><post_time>年</post_time><post_type>任</post_type>陞廣東五斗口巡檢 <office>〈典史〉</office><person>何 棟</person> <jiguan>直隸安州</jiguan><null>人</null><entry_way>吏員</entry_way>泰寧縣典 史調補<post_time>康熙</post_time><post_time>四十七</post_time><post_time>年</post_time><post_type>任</post_type> <office>〈典史〉</office><person>楊雲龍</person> <jiguan>直隸大興</jiguan><null>人</null><entry_way>吏員</entry_way>羅源縣典史調補<post_time>康熙</post_time><post_time>五 十二</post_time><post_time>年</post_time><post_type>任</post_type>五十六年陞江南靖江馬馱巡檢 【179】 〈佳里興巡檢司巡檢〉 <person></person><office>〈佳里興巡檢司巡檢〉</office><person>孫 寅</person> <jiguan>山東禹城</jiguan><null>人</null><entry_way>吏員</entry_way><post_time>康熙</post_time><post_time>二十 三</post_time><post_time>年</post_time><post_type>任</post_type>陞山西潞安府照磨 <office>〈佳里興巡檢司巡檢〉</office><person>周 彥</person> <jiguan>浙江錢塘</jiguan><null>人</null><entry_way>吏員</entry_way><post_time>康熙</post_time><post_time>二十 八</post_time><post_time>年</post_time><post_type>任</post_type>陞湖廣安陸府照磨 <office>〈佳里興巡檢司巡檢〉</office><person>陳治國</person> <jiguan>河南禹州</jiguan><null>人</null><entry_way>吏員</entry_way> <post_time>康熙</post_time><post_time>三十二</post_time><post_time>年</post_time><post_type>任</post_type> <office>〈佳里興巡檢司巡檢〉</office><person>鄭惟哲</person> <jiguan>直隸河間府</jiguan><null>人</null><entry_way>吏員</entry_way> <post_time>康熙</post_time><post_time>三十七</post_time><post_time>年</post_time><post_type>任</post_type> <office>〈佳里興巡檢司巡檢〉</office><person>張弘宗</person> <jiguan>浙江會稽</jiguan><null>人</null><entry_way>吏員</entry_way><post_time>康熙</post_time><post_time>四 十一</post_time><post_time>年</post_time><post_type>任</post_type>陞松江府照磨 <office>〈佳里興巡檢司巡檢〉</office><person>馬起羲</person> <jiguan>直隸</jiguan><null>人</null><entry_way>吏員</entry_way><post_time>康 熙</post_time><post_time>四十八</post_time><post_time>年</post_time><post_type>任</post_type> <office>〈佳里興巡檢司巡檢〉</office><person>劉廷元</person> <jiguan>陝西蘭州衛</jiguan><null>人</null><entry_way>吏員</entry_way> <post_time>康熙</post_time><post_time>五十一</post_time><post_time>年</post_time><post_type>任</post_type> <office>〈佳里興巡檢司巡檢〉</office>【180】 <office>〈佳里興巡檢司巡檢〉</office><person>陳祚楨</person> <jiguan>直隸大興</jiguan><null>人</null>內閣供 事<post_time>康熙</post_time><post_time>五十五</post_time><post_time>年</post_time><post_type>任</post_type> 〈儒學教諭〉 <person></person><office>〈儒學教諭〉</office><person>陳志友</person> <jiguan>長樂</jiguan><null>人</null><entry_way>歲貢</entry_way><post_time>康熙</post_time><post_time>二十六</post_time> <post_time>年</post_time><post_type>任</post_type>陞雲南蒙自知縣 <office>〈儒學教諭〉</office><person>謝汝霖</person> <jiguan>長樂</jiguan><null>人</null><entry_time>己酉</entry_time><entry_way><entry_way>舉人</entry_way></entry_way><post_time>康熙</post_time><post_time>三 十</post_time><post_time>年</post_time><post_type>任</post_type>陞陝西延州知縣 <office>〈儒學教諭〉</office><person>林 弼</person> <jiguan>莆田</jiguan><null>人</null><entry_time>壬子</entry_time><entry_way><entry_way>拔貢</entry_way></entry_way>閩清縣教 諭調補<post_time>康熙</post_time><post_time>三十四</post_time><post_time>年</post_time><post_type>任</post_type> <office>〈儒學教諭〉</office><person>施士嶽</person> <jiguan>晉江</jiguan><null>人</null><entry_way>歲貢</entry_way>閩清縣教諭調 補<post_time>康熙</post_time><post_time>三十九</post_time><post_time>年</post_time><post_type>任</post_type>以憂去 <office>〈儒學教諭〉</office><person>丁必捷</person> <jiguan>平和</jiguan><null>人</null><entry_way>歲貢</entry_way>福清縣教諭調補<post_time>康熙</post_time><post_time>四十一</post_time><post_time>年</post_time><post_type>任</post_type>陞國子監學錄 <office>〈儒學教諭〉</office><person>孫 襄</person> <jiguan>晉江</jiguan><null>人</null><entry_way>歲貢</entry_way>泰寧縣教諭調 補<post_time>康熙</post_time><post_time>四十五</post_time><post_time>年</post_time><post_type>任</post_type>卒於官 <office>〈儒學教諭〉</office>【181】 <office>〈儒學教諭〉</office><person>陳 聲</person> <jiguan>長泰</jiguan><null>人</null><entry_time>丁卯</entry_time><entry_way><entry_way>舉人</entry_way></entry_way>長樂縣教諭調補 <post_time>康熙</post_time><post_time>四十九</post_time><post_time>年</post_time><post_type>任</post_type>陞廣東和平知縣 <office>〈儒學教諭〉</office><person>陳文海</person> <jiguan>永安</jiguan><null>人</null><entry_way>歲貢</entry_way>德化縣教諭 調補<post_time>康熙</post_time><post_time>五十三</post_time><post_time>年</post_time><post_type>任</post_type> 論曰古者建侯儉於百里秦漢之間萬戶以上為 置令唐分天下縣為赤畿望緊上中下七等赤畿 者京都所治及京之旁邑也宋縣有望緊上中下 三等元以三萬戶以上者為上萬戶為中不及萬 戶者為下明縣不滿五十里者省丞簿諸羅建自 本朝民戶二千四百三十有六方之前代其在中下 【182】 之間乎然論其地則戰國時之宋衛中山弗及也 自南以北袤千有餘里往返動以月計山深水阻 宵小易潛縣令一耳目之力勢不得不有所寄無 能出胥役保長通事者矣法立弊生其在地方害 誠有之利則未也且事有大於此者故嘗私議自 半線大肚溪以上宜另割為一縣建置官吏營汛 畫千里之地而兩之猶古之大國也雖一時勞費 實百世深長之計矣 詳見 兵防 【183】列傳 <person>季麒光</person><jiguan>無錫</jiguan><null>人</null>康熙<entry_time>丙辰</entry_time><entry_way><entry_way>進士</entry_way></entry_way>二十三年知縣事時 <jiguan>縣治初設</jiguan><null>人</null>未向學麒光至首課儒童拔尤者而禮 之親為辨難士被其容光者如坐春風博涉群書為 詩文清麗整贍工臨池在任踰年首創臺灣郡志綜 其山川風物戶口土田阨塞未及終編以憂去三十 五年副使高拱乾因其<jiguan>稿纂而成之</jiguan><null>人</null>知臺郡志自 拱乾始而不知始於麒光也 【184】張<jiguan>?山西崞縣</jiguan><null>人</null><entry_way>歲貢</entry_way>康熙二十九年知縣事性恬 淡寡所言笑嘗知漳浦去之日士民抱馬足不得行 及再知諸羅見邑治新造多曠土招徠墾闢撫綏多 方流民歸者如市三十一年蝗日巡行阡陌間憂 形於色竭誠祭禳災而不傷蒞諸四年<jiguan>未嘗輕笞一</jiguan> <null>人</null>慢辱一士其在位也無赫赫之名<jiguan>而去後嘗令</jiguan><null>人</null> 思遷河南<jiguan>彰德郡丞邑</jiguan><null>人</null>肖其像於郡治竹溪寺 論曰季文才富豔首創郡志稿以發全臺之聾瞶 【185】 獎掖士類言者方於常觀察之風偉矣張寬厚長 者兩仕閩疆漢詔有言曰安靜之吏悃愊亡華日 計不足月計有餘斯亦殆近之矣 諸羅縣志卷三 終