* 修改類型 0表示crowdsourcing記錄，1表示新增，2表示整體覆寫（完整替換現有記錄，主要用於 code 表修改），3表示修改，4表示刪除，8表示記錄新增提案，9表示記錄修改提案
* 狀態 0代表是專業用戶修改的記錄，1代表crowdsourcing記錄並且已插入數據庫。
|
潘廷試 Pan Tingshi
|
BIOG_MAIN |
| 欄位 |
內容 |
| c_surname_chn |
潘 |
| c_surname |
Pan |
| c_mingzi_chn |
廷試 |
| c_mingzi |
Tingshi |
| c_surname_proper |
(null) |
| c_mingzi_proper |
(null) |
| c_surname_rm |
(null) |
| c_mingzi_rm |
(null) |
| c_name_chn |
潘廷試 |
| c_name |
Pan Tingshi |
| c_name_proper |
|
| c_name_rm |
|
| c_female |
0 |
| c_ethnicity_code |
(null) |
| c_dy |
19 |
| c_birthyear |
(null) |
| c_by_nh_code |
(null) |
| c_by_nh_year |
(null) |
| c_by_range |
(null) |
| c_by_intercalary |
0 |
| c_by_month |
(null) |
| c_by_day |
(null) |
| c_by_day_gz |
(null) |
| c_deathyear |
(null) |
| c_dy_nh_code |
(null) |
| c_dy_nh_year |
(null) |
| c_dy_range |
(null) |
| c_dy_intercalary |
0 |
| c_dy_month |
(null) |
| c_dy_day |
(null) |
| c_dy_day_gz |
(null) |
| c_index_year |
(null) |
| c_death_age |
(null) |
| c_death_age_range |
-1 |
| c_fl_earliest_year |
(null) |
| c_fl_ey_nh_code |
(null) |
| c_fl_ey_nh_year |
(null) |
| c_fl_ey_notes |
(null) |
| c_fl_latest_year |
(null) |
| c_fl_ly_nh_code |
(null) |
| c_fl_ly_nh_year |
(null) |
| c_fl_ly_notes |
(null) |
| c_choronym_code |
(null) |
| c_household_status_code |
(null) |
| c_notes |
(null) |
| c_modified_by |
陶恒 |
| c_modified_date |
20251214 |
| 欄位 |
原本的 |
修改後 |
目前資料 |
| c_female |
(null) |
0 |
0 |
| c_dy |
(null) |
19 |
19 |
| c_by_intercalary |
(null) |
0 |
0 |
| c_dy_intercalary |
(null) |
0 |
0 |
| c_death_age_range |
(null) |
-1 |
-1 |
| c_modified_by |
(null) |
陶恒 |
陶恒 |
| c_modified_date |
(null) |
20251214 |
20251214 |
|
697041
|
3-修改
|
陶恒 |
2025-12-14 11:41:34 |
2025-12-14 11:41:34 |
0 |
|
潘廷試 Pan Tingshi
|
BIOG_MAIN |
| 欄位 |
內容 |
| c_personid |
697041 |
| c_name_chn |
潘廷試 |
| c_created_by |
陶恒 |
| c_created_date |
20251214 |
| c_surname_chn |
潘 |
| c_surname |
Pan |
| c_mingzi_chn |
廷試 |
| c_mingzi |
Tingshi |
| c_name |
Pan Tingshi |
|
697041
|
1-新增
|
陶恒 |
2025-12-14 11:41:28 |
2025-12-14 11:41:28 |
0 |
|
王洵 Wang Xun
|
BIOG_MAIN |
| 欄位 |
內容 |
| c_surname_chn |
王 |
| c_surname |
Wang |
| c_mingzi_chn |
洵 |
| c_mingzi |
Xun |
| c_surname_proper |
(null) |
| c_mingzi_proper |
(null) |
| c_surname_rm |
(null) |
| c_mingzi_rm |
(null) |
| c_name_chn |
王洵 |
| c_name |
Wang Xun |
| c_name_proper |
|
| c_name_rm |
|
| c_female |
0 |
| c_ethnicity_code |
(null) |
| c_dy |
15 |
| c_birthyear |
(null) |
| c_by_nh_code |
(null) |
| c_by_nh_year |
(null) |
| c_by_range |
(null) |
| c_by_intercalary |
0 |
| c_by_month |
(null) |
| c_by_day |
(null) |
| c_by_day_gz |
(null) |
| c_deathyear |
(null) |
| c_dy_nh_code |
(null) |
| c_dy_nh_year |
(null) |
| c_dy_range |
(null) |
| c_dy_intercalary |
0 |
| c_dy_month |
(null) |
| c_dy_day |
(null) |
| c_dy_day_gz |
(null) |
| c_index_year |
(null) |
| c_death_age |
(null) |
| c_death_age_range |
-1 |
| c_fl_earliest_year |
(null) |
| c_fl_ey_nh_code |
(null) |
| c_fl_ey_nh_year |
(null) |
| c_fl_ey_notes |
(null) |
| c_fl_latest_year |
(null) |
| c_fl_ly_nh_code |
(null) |
| c_fl_ly_nh_year |
(null) |
| c_fl_ly_notes |
(null) |
| c_choronym_code |
(null) |
| c_household_status_code |
(null) |
| c_notes |
(null) |
| c_modified_by |
Qi Xinghai |
| c_modified_date |
20251214 |
| 欄位 |
原本的 |
修改後 |
目前資料 |
| c_female |
(null) |
0 |
0 |
| c_dy |
(null) |
15 |
15 |
| c_by_intercalary |
(null) |
0 |
0 |
| c_dy_intercalary |
(null) |
0 |
0 |
| c_death_age_range |
(null) |
-1 |
-1 |
| c_modified_by |
(null) |
Qi Xinghai |
Qi Xinghai |
| c_modified_date |
(null) |
20251214 |
20251214 |
|
697040
|
3-修改
|
Qi Xinghai |
2025-12-14 11:41:25 |
2025-12-14 11:41:25 |
0 |
|
陳咨稷 Chen Ziji
|
BIOG_MAIN |
| 欄位 |
內容 |
| c_surname_chn |
陳 |
| c_surname |
Chen |
| c_mingzi_chn |
咨稷 |
| c_mingzi |
Ziji |
| c_surname_proper |
(null) |
| c_mingzi_proper |
(null) |
| c_surname_rm |
(null) |
| c_mingzi_rm |
(null) |
| c_name_chn |
陳咨稷 |
| c_name |
Chen Ziji |
| c_name_proper |
|
| c_name_rm |
|
| c_female |
0 |
| c_ethnicity_code |
(null) |
| c_dy |
19 |
| c_birthyear |
(null) |
| c_by_nh_code |
(null) |
| c_by_nh_year |
(null) |
| c_by_range |
(null) |
| c_by_intercalary |
0 |
| c_by_month |
(null) |
| c_by_day |
(null) |
| c_by_day_gz |
(null) |
| c_deathyear |
(null) |
| c_dy_nh_code |
(null) |
| c_dy_nh_year |
(null) |
| c_dy_range |
(null) |
| c_dy_intercalary |
0 |
| c_dy_month |
(null) |
| c_dy_day |
(null) |
| c_dy_day_gz |
(null) |
| c_index_year |
(null) |
| c_death_age |
(null) |
| c_death_age_range |
-1 |
| c_fl_earliest_year |
(null) |
| c_fl_ey_nh_code |
(null) |
| c_fl_ey_nh_year |
(null) |
| c_fl_ey_notes |
(null) |
| c_fl_latest_year |
(null) |
| c_fl_ly_nh_code |
(null) |
| c_fl_ly_nh_year |
(null) |
| c_fl_ly_notes |
(null) |
| c_choronym_code |
(null) |
| c_household_status_code |
(null) |
| c_notes |
(null) |
| c_modified_by |
劉慧楠 |
| c_modified_date |
20251214 |
| 欄位 |
原本的 |
修改後 |
目前資料 |
| c_female |
(null) |
0 |
0 |
| c_dy |
(null) |
19 |
19 |
| c_by_intercalary |
(null) |
0 |
0 |
| c_dy_intercalary |
(null) |
0 |
0 |
| c_death_age_range |
(null) |
-1 |
-1 |
| c_modified_by |
(null) |
劉慧楠 |
劉慧楠 |
| c_modified_date |
(null) |
20251214 |
20251214 |
|
697039
|
3-修改
|
劉慧楠 |
2025-12-14 11:41:23 |
2025-12-14 11:41:23 |
0 |
|
王洵 Wang Xun
|
BIOG_MAIN |
| 欄位 |
內容 |
| c_personid |
697040 |
| c_name_chn |
王洵 |
| c_created_by |
Qi Xinghai |
| c_created_date |
20251214 |
| c_surname_chn |
王 |
| c_surname |
Wang |
| c_mingzi_chn |
洵 |
| c_mingzi |
Xun |
| c_name |
Wang Xun |
|
697040
|
1-新增
|
Qi Xinghai |
2025-12-14 11:41:16 |
2025-12-14 11:41:16 |
0 |
|
陳咨稷 Chen Ziji
|
BIOG_MAIN |
| 欄位 |
內容 |
| c_personid |
697039 |
| c_name_chn |
陳咨稷 |
| c_created_by |
劉慧楠 |
| c_created_date |
20251214 |
| c_surname_chn |
陳 |
| c_surname |
Chen |
| c_mingzi_chn |
咨稷 |
| c_mingzi |
Ziji |
| c_name |
Chen Ziji |
|
697039
|
1-新增
|
劉慧楠 |
2025-12-14 11:41:09 |
2025-12-14 11:41:09 |
0 |
|
王澣 Wang Huan
|
KIN_DATA |
| 欄位 |
內容 |
| c_kin_code |
62 |
| c_kin_id |
696905 |
| c_source |
64847 |
| c_pages |
159 王九言墓志 |
| c_notes |
(null) |
| c_autogen_notes |
(null) |
| c_personid |
697038 |
| c_created_by |
Qi Xinghai |
| c_created_date |
20251214 |
|
697038-696905-62
|
1-新增
|
Qi Xinghai |
2025-12-14 11:40:24 |
2025-12-14 11:40:24 |
0 |
|
陳睿謨 Chen Ruimo
|
BIOG_SOURCE_DATA |
| 欄位 |
內容 |
| c_textid |
39136 |
| c_pages |
lgid=152159-lgid=152160 |
| c_notes |
(null) |
| c_main_source |
0 |
| c_self_bio |
1 |
| c_personid |
61729 |
| c_modified_by |
劉慧楠 |
| c_modified_date |
2025-12-14T03:40:16.674019Z |
| 欄位 |
原本的 |
修改後 |
目前資料 |
| c_pages |
lgid=152159 |
lgid=152159-lgid=152160 |
(未取得) |
| c_modified_by |
(null) |
劉慧楠 |
(未取得) |
| c_modified_date |
(null) |
2025-12-14T03:40:16.674019Z |
(未取得) |
|
61729-39136-lgid=152159-lgid=152160
|
3-修改
|
劉慧楠 |
2025-12-14 11:40:16 |
2025-12-14 11:40:16 |
0 |
|
陳睿謨 Chen Ruimo
|
POSTED_TO_OFFICE_DATA |
| 欄位 |
內容 |
| c_sequence |
7 |
| c_office_id |
72516 |
| c_inst_code |
0 |
| c_source |
39136 |
| c_pages |
lgid=152160 |
| c_firstyear |
(null) |
| c_fy_nh_code |
(null) |
| c_fy_nh_year |
(null) |
| c_fy_range |
(null) |
| c_fy_intercalary |
0 |
| c_fy_month |
(null) |
| c_fy_day |
(null) |
| c_fy_day_gz |
(null) |
| c_lastyear |
(null) |
| c_ly_nh_code |
(null) |
| c_ly_nh_year |
(null) |
| c_ly_range |
(null) |
| c_ly_intercalary |
0 |
| c_ly_month |
(null) |
| c_ly_day |
(null) |
| c_ly_day_gz |
(null) |
| c_appt_code |
(null) |
| c_assume_office_code |
0 |
| c_office_category_id |
(null) |
| c_notes |
(null) |
| c_dy |
19 |
| c_inst_name_code |
0 |
| c_posting_id |
2103007 |
| c_personid |
61729 |
| c_created_by |
劉慧楠 |
| c_created_date |
20251214 |
|
72516-2103007
|
1-新增
|
劉慧楠 |
2025-12-14 11:39:35 |
2025-12-14 11:39:35 |
0 |
|
陳睿謨 Chen Ruimo
|
POSTED_TO_ADDR_DATA |
| 欄位 |
內容 |
| rows |
[{"c_personid":61729,"c_posting_id":2103007,"c_office_id":72516,"c_addr_id":0}] |
| 欄位 |
原本的 |
修改後 |
目前資料 |
| 人物 ID |
61729
|
61729
|
61729
|
| 官名 ID |
72516
|
72516
|
72516
|
| Posting ID |
2103007
|
2103007
|
2103007
|
| 地址 ID |
原本的 |
修改後 |
目前資料 |
| 0 |
—
|
0 [未詳]
|
0 [未詳]
|
|
72516-2103007
|
1-新增
|
劉慧楠 |
2025-12-14 11:39:35 |
2025-12-14 11:39:35 |
0 |
|
王澣 Wang Huan
|
BIOG_SOURCE_DATA |
| 欄位 |
內容 |
| c_textid |
64847 |
| c_pages |
159 王九言墓志 |
| c_notes |
(null) |
| c_main_source |
1 |
| c_self_bio |
0 |
| c_personid |
697038 |
| c_created_by |
Qi Xinghai |
| c_created_date |
2025-12-14T03:39:32.011942Z |
|
697038-64847-159 王九言墓志
|
1-新增
|
Qi Xinghai |
2025-12-14 11:39:32 |
2025-12-14 11:39:32 |
0 |
|
王澣 Wang Huan
|
BIOG_MAIN |
| 欄位 |
內容 |
| c_surname_chn |
王 |
| c_surname |
Wang |
| c_mingzi_chn |
澣 |
| c_mingzi |
Huan |
| c_surname_proper |
(null) |
| c_mingzi_proper |
(null) |
| c_surname_rm |
(null) |
| c_mingzi_rm |
(null) |
| c_name_chn |
王澣 |
| c_name |
Wang Huan |
| c_name_proper |
|
| c_name_rm |
|
| c_female |
0 |
| c_ethnicity_code |
(null) |
| c_dy |
15 |
| c_birthyear |
(null) |
| c_by_nh_code |
(null) |
| c_by_nh_year |
(null) |
| c_by_range |
(null) |
| c_by_intercalary |
0 |
| c_by_month |
(null) |
| c_by_day |
(null) |
| c_by_day_gz |
(null) |
| c_deathyear |
(null) |
| c_dy_nh_code |
(null) |
| c_dy_nh_year |
(null) |
| c_dy_range |
(null) |
| c_dy_intercalary |
0 |
| c_dy_month |
(null) |
| c_dy_day |
(null) |
| c_dy_day_gz |
(null) |
| c_index_year |
(null) |
| c_death_age |
(null) |
| c_death_age_range |
-1 |
| c_fl_earliest_year |
(null) |
| c_fl_ey_nh_code |
(null) |
| c_fl_ey_nh_year |
(null) |
| c_fl_ey_notes |
(null) |
| c_fl_latest_year |
(null) |
| c_fl_ly_nh_code |
(null) |
| c_fl_ly_nh_year |
(null) |
| c_fl_ly_notes |
(null) |
| c_choronym_code |
(null) |
| c_household_status_code |
(null) |
| c_notes |
(null) |
| c_modified_by |
Qi Xinghai |
| c_modified_date |
20251214 |
| 欄位 |
原本的 |
修改後 |
目前資料 |
| c_mingzi |
澣 |
Huan |
Huan |
| c_name |
Wang 澣 |
Wang Huan |
Wang Huan |
| c_female |
(null) |
0 |
0 |
| c_dy |
(null) |
15 |
15 |
| c_by_intercalary |
(null) |
0 |
0 |
| c_dy_intercalary |
(null) |
0 |
0 |
| c_death_age_range |
(null) |
-1 |
-1 |
| c_modified_by |
(null) |
Qi Xinghai |
Qi Xinghai |
| c_modified_date |
(null) |
20251214 |
20251214 |
|
697038
|
3-修改
|
Qi Xinghai |
2025-12-14 11:39:12 |
2025-12-14 11:39:12 |
0 |
|
王澣 Wang Huan
|
BIOG_MAIN |
| 欄位 |
內容 |
| c_personid |
697038 |
| c_name_chn |
王澣 |
| c_created_by |
Qi Xinghai |
| c_created_date |
20251214 |
| c_surname_chn |
王 |
| c_surname |
Wang |
| c_mingzi_chn |
澣 |
| c_mingzi |
澣 |
| c_name |
Wang 澣 |
|
697038
|
1-新增
|
Qi Xinghai |
2025-12-14 11:38:47 |
2025-12-14 11:38:47 |
0 |
|
王柱 Wang Zhu
|
POSTED_TO_OFFICE_DATA |
| 欄位 |
內容 |
| c_sequence |
0 |
| c_office_id |
71029 |
| c_inst_code |
0 |
| c_source |
57941 |
| c_pages |
lgid=1160900 |
| c_firstyear |
(null) |
| c_fy_nh_code |
(null) |
| c_fy_nh_year |
(null) |
| c_fy_range |
(null) |
| c_fy_intercalary |
0 |
| c_fy_month |
(null) |
| c_fy_day |
(null) |
| c_fy_day_gz |
(null) |
| c_lastyear |
(null) |
| c_ly_nh_code |
(null) |
| c_ly_nh_year |
(null) |
| c_ly_range |
(null) |
| c_ly_intercalary |
0 |
| c_ly_month |
(null) |
| c_ly_day |
(null) |
| c_ly_day_gz |
(null) |
| c_appt_code |
(null) |
| c_assume_office_code |
(null) |
| c_office_category_id |
(null) |
| c_notes |
(null) |
| c_dy |
19 |
| c_inst_name_code |
0 |
| c_posting_id |
2103006 |
| c_personid |
577109 |
| c_created_by |
陶恒 |
| c_created_date |
20251214 |
|
71029-2103006
|
1-新增
|
陶恒 |
2025-12-14 11:38:05 |
2025-12-14 11:38:05 |
0 |
|
王柱 Wang Zhu
|
POSTED_TO_ADDR_DATA |
| 欄位 |
內容 |
| rows |
[{"c_personid":577109,"c_posting_id":2103006,"c_office_id":71029,"c_addr_id":300319}] |
| 欄位 |
原本的 |
修改後 |
目前資料 |
| 人物 ID |
577109
|
577109
|
577109
|
| 官名 ID |
71029
|
71029
|
71029
|
| Posting ID |
2103006
|
2103006
|
2103006
|
| 地址 ID |
原本的 |
修改後 |
目前資料 |
| 300319 |
—
|
300319 新安衛
|
300319 新安衛
|
|
71029-2103006
|
1-新增
|
陶恒 |
2025-12-14 11:38:05 |
2025-12-14 11:38:05 |
0 |
|
王柱 Wang Zhu
|
BIOG_SOURCE_DATA |
| 欄位 |
內容 |
| c_textid |
57941 |
| c_pages |
lgid=1160900 |
| c_notes |
(null) |
| c_main_source |
1 |
| c_self_bio |
1 |
| c_personid |
577109 |
| c_created_by |
陶恒 |
| c_created_date |
2025-12-14T03:37:12.007228Z |
|
577109-57941-lgid=1160900
|
1-新增
|
陶恒 |
2025-12-14 11:37:12 |
2025-12-14 11:37:12 |
0 |
|
王泌 Wang Mi
|
KIN_DATA |
| 欄位 |
內容 |
| c_kin_code |
62 |
| c_kin_id |
696905 |
| c_source |
64847 |
| c_pages |
159 王九言墓志 |
| c_notes |
(null) |
| c_autogen_notes |
(null) |
| c_personid |
697037 |
| c_created_by |
Qi Xinghai |
| c_created_date |
20251214 |
|
697037-696905-62
|
1-新增
|
Qi Xinghai |
2025-12-14 11:35:14 |
2025-12-14 11:35:14 |
0 |
|
應朝卿 Ying Chaoqing
|
POSTED_TO_OFFICE_DATA |
| 欄位 |
內容 |
| c_sequence |
5 |
| c_office_id |
72162 |
| c_inst_code |
0 |
| c_source |
38685 |
| c_pages |
lgid=356641 |
| c_firstyear |
(null) |
| c_fy_nh_code |
(null) |
| c_fy_nh_year |
(null) |
| c_fy_range |
(null) |
| c_fy_intercalary |
0 |
| c_fy_month |
(null) |
| c_fy_day |
(null) |
| c_fy_day_gz |
(null) |
| c_lastyear |
(null) |
| c_ly_nh_code |
(null) |
| c_ly_nh_year |
(null) |
| c_ly_range |
(null) |
| c_ly_intercalary |
0 |
| c_ly_month |
(null) |
| c_ly_day |
(null) |
| c_ly_day_gz |
(null) |
| c_appt_code |
(null) |
| c_assume_office_code |
(null) |
| c_office_category_id |
(null) |
| c_notes |
(null) |
| c_dy |
19 |
| c_inst_name_code |
0 |
| c_posting_id |
2103005 |
| c_personid |
387254 |
| c_created_by |
張軒銘 |
| c_created_date |
20251214 |
|
72162-2103005
|
1-新增
|
張軒銘 |
2025-12-14 11:35:12 |
2025-12-14 11:35:12 |
0 |
|
應朝卿 Ying Chaoqing
|
POSTED_TO_ADDR_DATA |
| 欄位 |
內容 |
| rows |
[{"c_personid":387254,"c_posting_id":2103005,"c_office_id":72162,"c_addr_id":4622}] |
| 欄位 |
原本的 |
修改後 |
目前資料 |
| 人物 ID |
387254
|
387254
|
387254
|
| 官名 ID |
72162
|
72162
|
72162
|
| Posting ID |
2103005
|
2103005
|
2103005
|
| 地址 ID |
原本的 |
修改後 |
目前資料 |
| 4622 |
—
|
4622 揚州府
|
4622 揚州府
|
|
72162-2103005
|
1-新增
|
張軒銘 |
2025-12-14 11:35:12 |
2025-12-14 11:35:12 |
0 |
|
王泌 Wang Mi
|
BIOG_SOURCE_DATA |
| 欄位 |
內容 |
| c_textid |
64847 |
| c_pages |
159 王九言墓志 |
| c_notes |
(null) |
| c_main_source |
1 |
| c_self_bio |
0 |
| c_personid |
697037 |
| c_created_by |
Qi Xinghai |
| c_created_date |
2025-12-14T03:34:50.489081Z |
|
697037-64847-159 王九言墓志
|
1-新增
|
Qi Xinghai |
2025-12-14 11:34:50 |
2025-12-14 11:34:50 |
0 |