drop table veterans;

CREATE TABLE veterans (  veteran_id int(25) NOT NULL,  last_name varchar(255) NOT NULL default '',  first_name varchar(255) NOT NULL default '',  date_of_birth date NOT NULL default '0000-00-00',  birthplace varchar(255) NOT NULL default '',  army_entered date NOT NULL default '0000-00-00',  army_discharged date NOT NULL default '0000-00-00',  notes text,  honors text,  resources varchar(255) default NULL,  PRIMARY KEY  (veteran_id)) TYPE=MyISAM;INSERT INTO veterans VALUES (1001,' Aka',' Raymond Y.','1916-12-13','Wailuku, Maui, HI','1941-10-08','1947-05-01','Participated in the Occupation as a liaison for the GHQ, SCAP, to supervise matters related to industrial security and to monitor industrial plants.<BR>Post-service, invovled in the prepartion of Japan&#39;s self-defense law and in numerous hih-level meetins with political leaders of both countries.','Order of the Risin Sun, Gold Rays with Neck Ribbon,,','Autobiography, Questionnaire');INSERT INTO veterans VALUES (1002,' Akune',' Harry Masami','1920-05-20','Turlock, CA','1942-12-01','1946-01-01','The only Nisei linuist to parachute in for an  assault on Correidor, PhilippinesÑwithout any formal parachutist trainin or the proper equipment<BR>',' Military Intellience Hall of Fame ,Paratrooper Bade with Bronze Star?,','Oral History, Questionnaire');INSERT INTO veterans VALUES (1003,' Akune',' Kenjiro','1923-07-03','Turlock, CA','0000-00-00','1945-12-01','<BR>',',,','Oral History');INSERT INTO veterans VALUES (1004,' Ariyasu','MasaruJimmy','1941-06-01','','1940-01-01','0000-00-00','<BR>',' Leion of Merit ,Bronze Star, Combat Infantryman&#39;s Bade ','');INSERT INTO veterans VALUES (1005,' Baerwald',' Hans H.','1927-06-18','Tokyo, Japan','1945-09-10','1949-01-01','<BR>',',,','Autobiography, Questionnaire');INSERT INTO veterans VALUES (1006,' Burden',' Alfred John','1900-11-14','Tokyo, Japan','0000-00-00','1945-01-01','<BR>Also awarded Purple Heart, the Order of Three White Doves',' Silver Star ,Bronze Star, Leion of Merit ','Oral History, Questionnaire, Articles');INSERT INTO veterans VALUES (1007,' Dirks',' Dempster','0000-00-00','','1941-01-01','1946-01-01','<BR>',',,','Autobiography');INSERT INTO veterans VALUES (1008,' Fudenna',' Harold','1918-04-03','Centerville, CA','1941-03-01','1946-01-01','<BR>',',,','Biography');INSERT INTO veterans VALUES (1009,' Furuiye',' Nobuo','1918-04-21','Lafayette, CO','1942-01-12','1945-12-01',' Served as instructor at DLI in Monterey. <BR>',' Purple Heart ,,','Oral History');INSERT INTO veterans VALUES (1010,' Hamano',' Shunji','1913-06-01','Los Aneles, CA','1941-06-01','1945-11-01','<BR>',',,','Questionnaire, Biography');INSERT INTO veterans VALUES (1011,' Hamasaki',' Charlie Hideyoshi','1917-08-05','Los Altos, CA','0000-00-00','1945-01-01','<BR>',' Bronze Star ,,','Oral History, Questionnaire');INSERT INTO veterans VALUES (1012,' Hara',' Minoru Robert','1922-10-24','Terminal Island, CA','1942-11-21','0000-00-00','<BR> Bronze Star with Oak Leaf Cluster; Asiatic-Pacific Medal; Bronze Service Stars; many other medals/honors ',' Combat Infantryman&#39;s Bade ,Bronze Star (see notes),','Oral History, Autobiography, Questionnaire');INSERT INTO veterans VALUES (1013,' Harada',' Raymond Kosaku','1918-05-01','Honolulu, HI','1941-01-01','0000-00-00','<BR>',' Leion of Merit ,various service medals, Armed Forces Reserve Medal ','Oral History');INSERT INTO veterans VALUES (1014,' Hayashi',' Richard Kaoru','1919-01-01','MacDonald Island, CA','1941-06-04','2063-01-31','<BR>',',,','Oral History, Biography');INSERT INTO veterans VALUES (1015,' Hayashida',' Tetsuo','1917-07-31','Berkeley, CA','1944-04-07','1946-01-01','<BR> Bronze Star with Oak Leaf Cluster ',' Bronze Star ,Bronze Star (see notes),','Questionnaire, Biography');INSERT INTO veterans VALUES (1016,' Hazard',' Benjamin H.','1919-10-25','South Lancaster, MA','1942-12-15','1946-07-29','<BR> Bronze Star with Oak Leaf Cluster; Asiatic Pacific Medal; Philippine Liberation Medal ',' Leion of Merit ,Bronze Star (see notes), ROK Presidential Unit Citation ','');INSERT INTO veterans VALUES (1017,' Hia',' Takejiro','1923-04-01','Waipahu, HI','1943-07-01','1946-01-01','<BR>',',,','Oral History, Autobiography');INSERT INTO veterans VALUES (1018,' Hirabayashi',' Grant Jiro','1919-11-09','Kent, WA','1941-12-10','1949-01-01','<BR> Bronze Star with Oak Leaf Cluster; various service medals ',' Combat Infantryman&#39;s Bade ,Distinuished Unit Bade, Bronze Star (see notes) ','Oral History, Questionnaire');INSERT INTO veterans VALUES (1019,' Hirashima',' William','1916-03-20','Summerland, CA','1941-02-01','0000-00-00','<BR>',',,','Oral History');INSERT INTO veterans VALUES (1020,' Kanemoto',' Wayne Masao','1918-03-09','San Jose, CA','0000-00-00','0000-00-00','<BR>',',,','Oral History, Questionnaire');INSERT INTO veterans VALUES (1021,' Komori',' Arthur','1915-01-01','Lihue, HI','1941-03-01','1952-01-01',' Involved in CIC work. <BR>',' Military Intellience Hall of Fame ,Bronze Star,','Biography, Articles');INSERT INTO veterans VALUES (1022,' Koshi',' Geore M.','1911-06-16','Greeley, CO','1942-03-01','0000-00-00','<BR>',',,','');INSERT INTO veterans VALUES (1023,' Kozono',' Ard Aven Kiyoshi','1916-05-12','Yolo, CA','1944-01-01','1946-08-06','<BR>',',,','Autobiography, Questionnaire, Photos, Articles');INSERT INTO veterans VALUES (1024,' Kubo','HoichiBob','1919-07-21','Puukoli, Maui, HI','1941-06-30','1945-11-30','<BR> Bronze Star with Oak Leaf Cluster; Combat Infantryman&#39;s Bade; Good Conduct Medal; American Campain Medal; American Defense Service Medal; plus 3 more medals ',' Distinuished Service Cross ,Bronze Star (see notes), Presidential Unit Citation ','Autobiography, Articles');INSERT INTO veterans VALUES (1025,' Kuwabara',' Henry Hideo','1919-04-01','?, ID','1942-11-01','1963-01-01','<BR>',' British Empire Medal ,,','Oral History, Autobiography');INSERT INTO veterans VALUES (1026,' Masuoka',' Frank Yoshio','1923-03-13','Geyserville, CA','1942-12-01','1970-07-01','<BR>',' Silver Star ,Bronze Star, Purple Heart ','Oral History, Questionnaire');INSERT INTO veterans VALUES (1027,' Matsuda',' Tatsuo','1918-01-26','Watsonville, CA','1941-07-07','1945-11-01','<BR>',' Bronze Star ,Liberty Medal,','Questionnaire, Biography');INSERT INTO veterans VALUES (1028,' Matsui',' Mitsue Kono','0000-00-00','San Francisco, CA','0000-00-00','0000-00-00','Served as secretary to John Aiso, head administrator at the MIS Lanuae School.<BR>',',,','Oral History');INSERT INTO veterans VALUES (1029,' Matsui',' Takashi','1917-01-20','Hood River, OR','0000-00-00','1954-01-01','<BR> Reserve Medal; Overseas Service Medal; American Campain Medal ',' Army of Occupation Medal ,WWII Victory Medal,Order of the Risin Sun, Dual Rays','Oral History, Questionnaire');INSERT INTO veterans VALUES (1030,' Matsumoto',' Roy Hiroshi','1913-05-01','Los Aneles, CA','1942-11-12','1909-05-17','<BR> Bronze Stars with Oak Leaf Clusters; numerous medals ',' Military Intellience Hall of Fame ,Raners Hall of Fame, Leion of Merit ','Oral History, Questionnaire');INSERT INTO veterans VALUES (1031,' Midzuno',' Kiyoshi Robert','1922-03-13','San Francisco, CA','0000-00-00','0000-00-00','<BR>',',,','Autobiography, Questionnaire');INSERT INTO veterans VALUES (1032,' Miyasaki',' Tateshi','1913-09-20','Rexbur, ID','1941-02-01','1945-01-01','<BR> Bronze Star with Oak Leaf Cluster ',' Bronze Star (see notes) ,,','Autobiography');INSERT INTO veterans VALUES (1033,' Mizutari','YukitakaTerry','1920-05-03','Honolulu, HI','1941-01-01','0000-00-00',' Killed in action. <BR>',' Silver Star ,,','');INSERT INTO veterans VALUES (1034,'Mori','TadashiTad','2017-08-01','Fresno, CA','2041-10-28','2045-12-23','<BR>',',,','Oral History, Autobiography');INSERT INTO veterans VALUES (1035,'Morikawa','Eddie','1917-09-01','Sacramento, CA','1944-12-01','1953-05-01','<BR>Korean Service Medal with 5 Bronze Campain Stars','Distinuished Unit Citation,Bronze Star, UN Service Medal ','Biography');INSERT INTO veterans VALUES (1036,'Naano','Patrick N.','2018-11-17','Morro Bay, CA','1942-11-01','1945-12-01','<BR>',',,','Autobiography, Questionnaire');INSERT INTO veterans VALUES (1037,'Naao','Norito','0000-00-00','','1943-01-01','1945-12-01','<BR>',',,','Autobiography');INSERT INTO veterans VALUES (1038,'Naase','SatoshiBud','2016-06-09','San Fernando, CA','1943-11-01','1976-06-01','<BR>',',,','Questionnaire, Biography');INSERT INTO veterans VALUES (1039,'Naata','Mac Nobuo','2019-05-27','Sacramento, CA','2041-02-26','2045-10-09','<BR>Good Conduct Medal; ','Leion of Merit,Bronze Star,','Oral History, Questionnaire, Articles');INSERT INTO veterans VALUES (1040,'Nakahata','Yutaka','0000-00-00','','0000-00-00','0000-00-00','<BR>',',,','Articles');INSERT INTO veterans VALUES (1041,'Nakamoto','Ben I.','2019-03-09','Fresno, CA','1942-03-01','0000-00-00','<BR>','Combat Infantryman&#39;s Bade,Bronze Star with Arrowhead,','Oral History, Questionnaire');INSERT INTO veterans VALUES (1042,'Nakamura','Akira','0000-00-00','','0000-00-00','0000-00-00','<BR>',',,','');INSERT INTO veterans VALUES (1043,'Nakatsu','Dan','0000-00-00','','0000-00-00','0000-00-00','<BR>',',,','');INSERT INTO veterans VALUES (1044,'Neishi','ToraoPat','2017-03-12','Oakland, CA','2042-01-05','0000-00-00','<BR>',',,','Oral History');INSERT INTO veterans VALUES (1045,'Nishio','Frank','0000-00-00','','0000-00-00','0000-00-00','<BR>',',,','');INSERT INTO veterans VALUES (1046,'Nomura','Sho','0000-00-00','','0000-00-00','0000-00-00','<BR>',',,','');INSERT INTO veterans VALUES (1047,'Oda','James','0000-00-00','','0000-00-00','0000-00-00','<BR>',',,','');INSERT INTO veterans VALUES (1048,'Oji','Sukeo','0000-00-00','','0000-00-00','0000-00-00','<BR>',',,','');INSERT INTO veterans VALUES (1049,'Oka','Don','0000-00-00','','0000-00-00','0000-00-00','<BR>',',,','');INSERT INTO veterans VALUES (1050,'Okada','Peter Kazunori','2019-05-23','Los Aneles, CA','1943-01-01','0000-00-00','<BR>Other medals','Good Conduct Medal,WWII Victory Medal,Philippines Liberation Medal?','Questionnaire, Biography');INSERT INTO veterans VALUES (1051,'Okamura','Shinji','0000-00-00','','0000-00-00','0000-00-00','<BR>',',,','');INSERT INTO veterans VALUES (1052,'Okubo','Donald S.','0000-00-00','','0000-00-00','0000-00-00','<BR>','Silver Star,Bronze Star,','Autobiography');INSERT INTO veterans VALUES (1053,'Sameshima','Ko','0000-00-00','','0000-00-00','0000-00-00','<BR>',',,','');INSERT INTO veterans VALUES (1054,'Sankey','Geore Kiyoshi (aka Geore Kiyoshi Yamashiro)','2016-12-09','Kauai, HI','1941-01-01','1969-01-01','<BR>','Leion of Merit,,','Biography');INSERT INTO veterans VALUES (1055,'Sazaki','Haruo','0000-00-00','','0000-00-00','0000-00-00','<BR>',',,','');INSERT INTO veterans VALUES (1056,'Soi','Francis','0000-00-00','','0000-00-00','0000-00-00','<BR>',',,','');INSERT INTO veterans VALUES (1057,'Soyeshima','Ted','0000-00-00','','0000-00-00','0000-00-00','<BR>',',,','');INSERT INTO veterans VALUES (1058,'Suyehiro','Henry','0000-00-00','','0000-00-00','0000-00-00','<BR>',',,','');INSERT INTO veterans VALUES (1059,'Takahashi','Hiroki','0000-00-00','','0000-00-00','0000-00-00','<BR>',',,','');INSERT INTO veterans VALUES (1060,'Takai','Roy','0000-00-00','','0000-00-00','0000-00-00','<BR>',',,','');INSERT INTO veterans VALUES (1061,'Takata','Thomas','0000-00-00','','0000-00-00','0000-00-00','<BR>',',,','');INSERT INTO veterans VALUES (1062,'Tasaki','Toma','0000-00-00','','0000-00-00','0000-00-00','<BR>',',,','');INSERT INTO veterans VALUES (1063,'Tsukiyama','Ted','0000-00-00','','0000-00-00','0000-00-00','<BR>',',,','');INSERT INTO veterans VALUES (1064,'Tsuneishi','Warren','0000-00-00','','0000-00-00','0000-00-00','<BR>',',,','');INSERT INTO veterans VALUES (1065,'Uyehata','Roy','0000-00-00','','0000-00-00','0000-00-00','<BR>',',,','');INSERT INTO veterans VALUES (1066,'Wriht','Euene','0000-00-00','','0000-00-00','0000-00-00','<BR>',',,','');INSERT INTO veterans VALUES (1067,'Yamada','Gordon','0000-00-00','','0000-00-00','0000-00-00','<BR>',',,','');INSERT INTO veterans VALUES (1068,'Yamada','Yoshikazu','2015-05-20','Honokaa, HI','1941-04-01','1946-01-01','<BR>','Leion of Merit,,','Autobiography');INSERT INTO veterans VALUES (1069,'Yoshimura','Akiji','0000-00-00','','0000-00-00','0000-00-00','<BR>',',,','');INSERT INTO veterans VALUES (1070,'Yoshimura','Noboru','0000-00-00','','0000-00-00','0000-00-00','<BR>',',,','');INSERT INTO veterans VALUES (1071,'Yoshiwara','Joe','0000-00-00','','0000-00-00','0000-00-00','<BR>',',,','');

INSERT INTO veterans (veteran_id, last_name, first_name, date_of_birth, birthplace, army_entered, army_discharged, notes, honors) VALUES ('2000', ' Aiso ', ' John ', '1909-12-14', 'Burbank, CA', '1941-0-0', '1941-0-0', ' Elected Jr. High School president, but as a result of parent protests all student government activities were cancelled.  Valedictorian of Hollywood High School.  Attended Brown University and Harvard Law School.   <BR> Worked in Manchuria, then returned to U.S. and was drafted by the Army.  Recruited to become MISLS teacher, and eventually became the lead administrator for the program.   ', ',,');
INSERT INTO veterans (veteran_id, last_name, first_name, date_of_birth, birthplace, army_entered, army_discharged, notes, honors) VALUES ('2001', ' Amioka ', ' Wallace ', '1914-6-28', 'Honolulu, HI', '1944-1-3', '1952-0-0', ' Leader of special team of MIS linguists of Okinawan ancestry.  Participated in the surrender and Occupation of Japan. <BR>', ',,');
INSERT INTO veterans (veteran_id, last_name, first_name, date_of_birth, birthplace, army_entered, army_discharged, notes, honors) VALUES ('2002', 'Fukuhara ', ' Harry ', '-0-', '', '-Camp Savage (2-43 left)', '--', '<BR>', ' Bronze Star (3) ,,');
INSERT INTO veterans (veteran_id, last_name, first_name, date_of_birth, birthplace, army_entered, army_discharged, notes, honors) VALUES ('2003', ' Gosho ', ' Hank ', '1921-2-4', 'Seattle, WA', '1942-11-0', '1945-5-0', ' Sent to Japan with younger brother in 1933.  Both older and younger brother served in the Japanese military.  Father taken by FBI and placed in Justice Department Camp.  Served with Merrill�s Marauders in Burma.   <BR>', ',,');
INSERT INTO veterans (veteran_id, last_name, first_name, date_of_birth, birthplace, army_entered, army_discharged, notes, honors) VALUES ('2028', ' Honda ', ' Ben Sanaye ', '--', ' Fresno, CA ', '1945-9-0', '-0-', '<BR>', ',,');
INSERT INTO veterans (veteran_id, last_name, first_name, date_of_birth, birthplace, army_entered, army_discharged, notes, honors) VALUES ('2037', 'Hurt', 'Haruko Sugi', '15-1-3', 'Parlier, CA', '1944-1-0', '46-9-16', 'One of the first members of the Women&#39;s Army Corps (WAC).<BR>', ',,');
INSERT INTO veterans (veteran_id, last_name, first_name, date_of_birth, birthplace, army_entered, army_discharged, notes, honors) VALUES ('2035', 'Ichikawa', 'Grant', '19-4-17', 'Suisun, CA', '1941-0-0', '--', '<BR>', ',,');
INSERT INTO veterans (veteran_id, last_name, first_name, date_of_birth, birthplace, army_entered, army_discharged, notes, honors) VALUES ('2036', 'Iida', 'Harry Shinichi', '20-7-19', 'San Jose, CA', '1942-11-0', '-1962-', 'Highest Rank:  Major<BR>', 'Silver Star,Bronze Star,');
INSERT INTO veterans (veteran_id, last_name, first_name, date_of_birth, birthplace, army_entered, army_discharged, notes, honors) VALUES ('2026', ' Inoshita ', ' Masaji ', '1919-12-9', ' Fresno, CA ', '1942-12-0', '1946-1-0', 'Volunteered from Gila River, AZ Detention Camp, Awarded British Commendation Medal, Highest Rank:  T/3.  Worked primarily with British troops in Burma.<BR>', ',,');
INSERT INTO veterans (veteran_id, last_name, first_name, date_of_birth, birthplace, army_entered, army_discharged, notes, honors) VALUES ('2004', ' Inouye ', ' Kazuo ', '1919-5-22', ' Kingsburg, CA ', '--', '1945-11-27', ' 2 Bronze Stars,  <BR>', ',,');
INSERT INTO veterans (veteran_id, last_name, first_name, date_of_birth, birthplace, army_entered, army_discharged, notes, honors) VALUES ('2005', ' Inouye ', ' Masato Mas ', '1917-1-17', ' San Luis Obispo, CA ', '1909-5-1', '1909-5-21', ' Graduated from Meiji University in 1939, Attended Yale graduate school of International Relations, Taught Caucasian soldiers at University of Michigan basic Japanese, <BR>  Post-Occupation interpreting, Awarded Legion of Merit for service at the Military Intelligence School, Highest Rank:  Lt. Colonel ', ' Legion of Merit ,,');
INSERT INTO veterans (veteran_id, last_name, first_name, date_of_birth, birthplace, army_entered, army_discharged, notes, honors) VALUES ('2039', 'Inouye', 'Kaoru', '15-12-5', 'Los Gatos, CA', '1944-8-0', '1946-7-0', '<BR>', ',,');
INSERT INTO veterans (veteran_id, last_name, first_name, date_of_birth, birthplace, army_entered, army_discharged, notes, honors) VALUES ('2006', ' Ishida ', ' William Tsuyoshi ', '1917-1-18', ' Lindsey, CA ', '1941-6-10', '1945-12-22', '<BR>', ' Silver Star ,,');
INSERT INTO veterans (veteran_id, last_name, first_name, date_of_birth, birthplace, army_entered, army_discharged, notes, honors) VALUES ('2038', 'Ishikawa', 'Moffett Mitsuo', '18-4-2', 'San Jose, CA', '42-1-14', '1945-11-0', '<BR>', ',,');
INSERT INTO veterans (veteran_id, last_name, first_name, date_of_birth, birthplace, army_entered, army_discharged, notes, honors) VALUES ('2007', ' Ishio ', ' Sunao Phil ', '2018-1-12', 'Berkeley, CA', '-Camp Savage (6-42)', '--', ' Highest rank: Colonel <BR>', ' Bronze Star ,,');
INSERT INTO veterans (veteran_id, last_name, first_name, date_of_birth, birthplace, army_entered, army_discharged, notes, honors) VALUES ('2034', ' Ito ', ' Sueo ', '1919-6-0', ' Kurtistown, HI ', '1944-7-0', '1946-7-0', ' Interpreted War Crimes Trials in Manila and criminal trials in Japan. <BR>', ',,');
INSERT INTO veterans (veteran_id, last_name, first_name, date_of_birth, birthplace, army_entered, army_discharged, notes, honors) VALUES ('2040', 'Ito', 'Shigeo', '-incomplete-', '', '--', '--', '<BR>', ',,');
INSERT INTO veterans (veteran_id, last_name, first_name, date_of_birth, birthplace, army_entered, army_discharged, notes, honors) VALUES ('2008', ' Kadani ', ' Gary Tsuneo ', '2015-11-16', ' San Juan Bautista, CA ', '1941-3-10', '1948-9-00', '<BR>', ',,');
INSERT INTO veterans (veteran_id, last_name, first_name, date_of_birth, birthplace, army_entered, army_discharged, notes, honors) VALUES ('2033', ' Kadomoto ', ' Thomas ', '1917-3-24', ' Phoenix, AZ ', '1941-7-21', '1946-3-26', ' Highest Military rank:  2nd Lt. <BR>', ' Bronze Star ,,');
INSERT INTO veterans (veteran_id, last_name, first_name, date_of_birth, birthplace, army_entered, army_discharged, notes, honors) VALUES ('2041', 'Kai', 'James Tsutomo', '20-2-1', 'Denver, CO', '41-10-7', '0-0-0', '<BR>', ',,');
INSERT INTO veterans (veteran_id, last_name, first_name, date_of_birth, birthplace, army_entered, army_discharged, notes, honors) VALUES ('2009', ' Kaneko ', ' Arthur Masaki ', '1912-10-27', ' Riverside, CA ', '1941-3-7', '1946-3-1', ' Highest Rank:  Lt. Colonel, 1st Class MISLS.  Taught at Camp Savage for 2 years.  Worked for CIA for 27 years. <BR>', ',,');
INSERT INTO veterans (veteran_id, last_name, first_name, date_of_birth, birthplace, army_entered, army_discharged, notes, honors) VALUES ('2047', 'Kanemoto', 'Wayne Masao', '18-3-9', 'San Jose, CA', '1942-7-0', '1946-3-0', 'Finished law school just as eviction began.  Took the Bar exam while in Santa Anita Assembly Center and passed.  First Nisei lawyer in Santa Clara Valley.  Became the  first appointed judge in Northern California.<BR>', ',,');
INSERT INTO veterans (veteran_id, last_name, first_name, date_of_birth, birthplace, army_entered, army_discharged, notes, honors) VALUES ('2042', 'Kasai', 'Mitsugi M.', '18-1-30', 'Milford, Beaver County, UT', '1946-6-0', '73-3-31', '<BR>', ',,');
INSERT INTO veterans (veteran_id, last_name, first_name, date_of_birth, birthplace, army_entered, army_discharged, notes, honors) VALUES ('2048', 'Kawashiri', 'Roy Iwao', '--', '', '41-6-5', '45-9-28', 'MIS First Class graduate.  <BR>', ',,');
INSERT INTO veterans (veteran_id, last_name, first_name, date_of_birth, birthplace, army_entered, army_discharged, notes, honors) VALUES ('2030', ' Kawaye ', ' Don Yoshiaki ', '1918-2-15', 'New Stable, Honokaa, Hawaii', '1941-3-0', '--', '<BR>', ',,');
INSERT INTO veterans (veteran_id, last_name, first_name, date_of_birth, birthplace, army_entered, army_discharged, notes, honors) VALUES ('2031', ' Kayano ', ' Goerge Kenichi ', '1920-2-19', ' San Francisco, CA ', '1941-10-17', '1947-7-14', '<BR>', ',,');
INSERT INTO veterans (veteran_id, last_name, first_name, date_of_birth, birthplace, army_entered, army_discharged, notes, honors) VALUES ('2027', ' Kido ', ' Fumio ', '1924-4-14', ' Hilo, Hawaii ', '1943-3-23', '1946-3-0', ' Worked in Burma as a translator.  After the war ended was dropped by parachute into Mukden, Manchuria where he faced hostile Japanese troops in order to provide medical relief for Allied POWs.   <BR>', ' Soldier&#39;s Medal ,,');
INSERT INTO veterans (veteran_id, last_name, first_name, date_of_birth, birthplace, army_entered, army_discharged, notes, honors) VALUES ('2010', ' Kihara ', ' Shigeya ', '1914-9-11', 'Suisun, CA', '--', '--', ' Kihara was one of the first MISLS civilian language instructors.  Graduated from UC Berkeley, BA - political science, MA international relations. <BR>', ',,');
INSERT INTO veterans (veteran_id, last_name, first_name, date_of_birth, birthplace, army_entered, army_discharged, notes, honors) VALUES ('2049', 'Kimura', 'Rusty', '15-1-19', 'Sacramento, CA', '42-12-5', '1945-0-0', '<BR>', ',,');
INSERT INTO veterans (veteran_id, last_name, first_name, date_of_birth, birthplace, army_entered, army_discharged, notes, honors) VALUES ('2032', ' Kishi ', ' Sherman ', '1945-5-15', ' Livingston, CA ', '1943-9-0', '1946-3-0', '<BR>', ',,');
INSERT INTO veterans (veteran_id, last_name, first_name, date_of_birth, birthplace, army_entered, army_discharged, notes, honors) VALUES ('2011', ' Kishiue ', ' Nobuo Dick ', '1920-5-20', 'Armona, CA', '1941-11-4', '1945-11-12', 'Helped thwart a suicide attack on Saipan.  <BR>', ' Combat Infantryman&#39;s Badge ,,');
INSERT INTO veterans (veteran_id, last_name, first_name, date_of_birth, birthplace, army_entered, army_discharged, notes, honors) VALUES ('2029', ' Kitahara ', ' Kei ', '1920-12-29', ' Reedley, CA ', '1943-1-0', '1946-0-0', ' Highest Rank:  1st Lieutenant <BR>', ',,');
INSERT INTO veterans (veteran_id, last_name, first_name, date_of_birth, birthplace, army_entered, army_discharged, notes, honors) VALUES ('2044', 'Kobayashi', 'Hisao Koby', '15-1-23', 'Brawley, CA', '41-12-2', '1946-2-0', '<BR>', ',,');
INSERT INTO veterans (veteran_id, last_name, first_name, date_of_birth, birthplace, army_entered, army_discharged, notes, honors) VALUES ('2012', ' Komoto ', ' Kazuo ', '1918-11-9', ' Sanger, CA ', '1941-3-10', '1945-0-0', ' Mars Task Force, Injured on New Guinea, Highest Rank, Tech Sergeant <BR> Visited by Mrs. Roosevelt when he was in a hospital on Fiji. ', ',,');
INSERT INTO veterans (veteran_id, last_name, first_name, date_of_birth, birthplace, army_entered, army_discharged, notes, honors) VALUES ('2013', ' Kono ', ' Yeije Gene ', '1920-3-10', ' Fresno, CA ', '1944-11-14', '1950-9-30', ' Highest rank:  1st Lieutenant, Interrogated Japanese POWs returning from Siberian labor camps.   <BR> Contracted tuburculosis while interrogating prisoners forcing him to retire from Army. ', ',,');
INSERT INTO veterans (veteran_id, last_name, first_name, date_of_birth, birthplace, army_entered, army_discharged, notes, honors) VALUES ('2014', ' Koyama ', ' Spady ', '1917-6-4', ' Ferry, WA ', '1942-1-8', '1970-7-16', ' Highest Rank - Colonel, in Vietnam War was Chief of Counter Intelligence, fought Spokane VFW who excluded Nisei veterans. <BR>', ',,');
INSERT INTO veterans (veteran_id, last_name, first_name, date_of_birth, birthplace, army_entered, army_discharged, notes, honors) VALUES ('2046', 'Matui', 'George Shigeo', '15-3-1', 'Long Beach, CA', '1941-2-0', '45-12-10', 'Awareded Bronze Star for cave flushing on Saipan.<BR>', 'Bronze Star,,');
INSERT INTO veterans (veteran_id, last_name, first_name, date_of_birth, birthplace, army_entered, army_discharged, notes, honors) VALUES ('2015', 'Morimitsu ', ' Arthur ', '1912-3-28', ' Sacramento, CA ', '1943-9-0', '1946-1-0', ' Attended UC Berkeley and was working for the Civil Service in Sacramento when the Pacific War began. Volunteered at age 30 for the MIS. Went to Burma and served with Mars Task Force.  <BR>', ' Bronze Star ,Combat Infantryman&#39;s Badge,');
INSERT INTO veterans (veteran_id, last_name, first_name, date_of_birth, birthplace, army_entered, army_discharged, notes, honors) VALUES ('2045', 'Morozumi', 'John', '-illegible-', '', '--', '--', '<BR>', ',,');
INSERT INTO veterans (veteran_id, last_name, first_name, date_of_birth, birthplace, army_entered, army_discharged, notes, honors) VALUES ('2043', 'Myer', 'Allen H.', '25-12-6', 'Chicago, IL', '1944-0-0', '1947-9-0', '<BR>', ',,');
INSERT INTO veterans (veteran_id, last_name, first_name, date_of_birth, birthplace, army_entered, army_discharged, notes, honors) VALUES ('2016', ' Nakamura ', ' George Itsuo ', '1923-11-13', 'Arroyo Grande, CA', '1942-12-0', '1949-0-0', ' Met Mao Tse-tung and ate dinner with leaders of Communist China. Traveled the French � Indo � China area. Crossed the Yellow River by himself to collect information. Helped a downed fighter pilot get back to the U.S.  <BR>', ' Bronze Star ,,');
INSERT INTO veterans (veteran_id, last_name, first_name, date_of_birth, birthplace, army_entered, army_discharged, notes, honors) VALUES ('2017', ' Saiki ', ' Barry ', '1919-6-21', 'Stockton, CA', '1944-11-0', '1966-0-0', ' Participated on in the Occupation.  Worked in CIC and saw his brother, who served as an interpreter for the Japanese military. <BR>', ',,');
INSERT INTO veterans (veteran_id, last_name, first_name, date_of_birth, birthplace, army_entered, army_discharged, notes, honors) VALUES ('2018', ' Sakamoto ', ' Tom ', '1918-3-5', 'San Jose, CA', '1941-2-26', '--', ' In 1934 was sent to Japan and participated in Japanese ROTC.  Part of MISLS first class.  Aboard the U.S.S. Missouri when the official surrender documents were signed.   <BR>', ' Bronze Star ,,');
INSERT INTO veterans (veteran_id, last_name, first_name, date_of_birth, birthplace, army_entered, army_discharged, notes, honors) VALUES ('2019', ' Tagami ', ' Kan ', '1918-2-21', 'Selma, CA', '1941-2-16', '1951-4-0', ' Taught at MISLS for 1 1/2 years.  Served as General MacArthur�s personal interpreter during Occupation.  Met with Emperor of Japan on MacArthur�s orders.   <BR>', ' Combat Infantryman&#39;s Badge ,,');
INSERT INTO veterans (veteran_id, last_name, first_name, date_of_birth, birthplace, army_entered, army_discharged, notes, honors) VALUES ('2020', ' Tanaka ', ' Walter ', '1918-2-19', 'Watsonville, CA', '1941-6-1', '1961-6-1', ' Highest Rank - Major.  Served 20 years in the Army. <BR>', ',,');
INSERT INTO veterans (veteran_id, last_name, first_name, date_of_birth, birthplace, army_entered, army_discharged, notes, honors) VALUES ('2021', ' Tokuno ', ' Shiro ', '--', '', '--', '--', '<BR>', ',,');
INSERT INTO veterans (veteran_id, last_name, first_name, date_of_birth, birthplace, army_entered, army_discharged, notes, honors) VALUES ('2022', ' Uratsu ', ' Gene ', '1917-7-5', 'Berkeley, CA', '1941-3-1', '1962-0-0', ' Studied in Japan for 5 years. Volunteered from Detention Camp.  Taught one year at Camp Savage.  Unarmed, he entered a cave and convinced Japanese soldiers to surrender.  <BR>', ' Bronze Star ,Bronze Star,');
INSERT INTO veterans (veteran_id, last_name, first_name, date_of_birth, birthplace, army_entered, army_discharged, notes, honors) VALUES ('2023', ' Yamamoto ', ' Steve Shizuma ', '1917-8-16', 'San Gabriel, CA', '1941-3-11', '1961-4-0', ' MISLS First Class, Highest Rank - Lieutenant Colonel <BR>', ' Bronze Star ,Bronze Star, Army Commendation Medal ');
INSERT INTO veterans (veteran_id, last_name, first_name, date_of_birth, birthplace, army_entered, army_discharged, notes, honors) VALUES ('2024', ' Yamane ', ' Kazuo ', '1916-12-8', 'Hawaii', '1941-1-0', '1945-0-0', ' Worked at Pentagon and located the Imperial Japanese Army Ordinance.  Sent to Europe to find documents at Japanese Embassy in Berlin. <BR>', ',,');
INSERT INTO veterans (veteran_id, last_name, first_name, date_of_birth, birthplace, army_entered, army_discharged, notes, honors) VALUES ('2025', ' Yempuku ', ' Ralph ', '1914-5-23', '', '-He attended Camp Savage undercoer as part of the OSS.-', '--', ' Was not MIS.  At first they wanted to put him in Japan to do intelligence work during the war, but it was too difficult, so he was sent to Burma. <BR>', ',,');