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