The first database I’d like to discuss is the OPA or Online Public Access database at NARA (the National Archives). They are currently overhauling this site, and there are frequent down-times. These are usually listed right on the search page. The National Archives are furiously attempting to digitize access to millions of records. Unfortunately, the search function is still clunky and almost all documents are not viewable from the site. However! Knowing of the existence of a document about a person can be wonderful. Be warned, I did not start with an easy one. This one often requires the use of TWO websites.

My human had a great uncle, Paul Cuozzo, who died in the Korean War. She had already found some amazing information through another website (another story for another day.) However, plugging his name into the OPA database reveals:

Korean War Extract Data File, as of April 29, 2008 , 06/28/1950 – 03/10/1954

National Archives Identifier: 2240988
Creator(s): Department of Defense. Office of the Under Secretary of Defense for Personnel and Readiness. Defense Human Resources Activity. Defense Manpower Data Center. (1997 – )
DISP|||||| O-2262850|V|L|ACTIVE – GUARD/RESERVE|CUOZZO PAUL A|A|ARMY|2LT|O01|1542|INFANTRY
Now I know the Archives identifier and following further, I can search ARC (The Archival Research Catalog) with that identifier number. It brings me to a card catalog page:

Korean War Extract Data File, as of April 29, 2008 , 06/28/1950 – 03/10/1954

ARC Identifier 2240988

File Unit from Record Group 330: Records of the Office of the Secretary of Defense, 1921 – 2008

Creator(s): Department of Defense. Office of the Under Secretary of Defense for Personnel and Readiness. Defense Human Resources Activity. Defense Manpower Data Center. (1997 – ) (Most Recent)
Department of Defense. Washington Headquarters Services. Directorate for Information Operations and Reports. Statistical Information Analysis Division. (ca. 1997 – ) (Predecessor)
Type(s) of Archival Materials: Data Files
Contact(s): Electronic and Special Media Records Services Division (NWME), National Archives at College Park, 8601 Adelphi Road, College Park, MD, 20740-6001. PHONE: 301-837-0470; FAX: 301-837-3681; EMAIL:cer@nara.gov.
Coverage Dates: 06/28/1950 – 03/10/1954
Date Note: Although the agency created this file starting in about 2001, it concerns records of military personnel who died as a result of the Korean War from 1950 through 1954.
Part Of: Series: Defense Casualty Analysis System (DCAS) Extract Files, compiled ca. 2001 – 04/29/2008, documenting the period 06/28/1950 – 05/28/2006
Access Restriction(s): Unrestricted
Use Restriction(s): Unrestricted
Online Resource: Access to Archival Databases (AAD) system
Online Resource URL: http://aad.archives.gov/aad/fielded-search.jsp?dt=2512&tf=F&cat=WR27&bc=,sl
Online Resource Note: This file can be searched online via the Access to Archival Databases (AAD) system.
Variant Control Number(s): Download Display Identifier: DDI
XMIS Number: 099292
This is the agency electronic documentation file.
XMIS Number: 099293
This is the data file.
Ooh, did you see the “Online Resource URL”? I did! So I can click that and it takes me to ANOTHER database! *Whee*!
Go to that, and search for Cuozzo brings this result:
View Record SERVICE NUMBER MEMBER NAME MEMBER SERVICE CODE MEMBER BIRTHDATE HOME OF RECORD CITY HOME OF RECORD COUNTY HOME OF RECORD STATE CODE INCIDENT OR DEATH DATE CASUALTY CATEGORY
sort low to high sort low to high sort low to high sort low to high sort low to high sort low to high sort low to high sort low to high sort low to high
View O-2262850 CUOZZO PAUL A Army 19180000 NEW YORK KINGS NEW YORK 04/06/1951 KILLED IN ACTION
Well, now I know his service number, which is very helpful if dealing with the military.
If you click “view record” on the left, this is what you get:
Field Title Value Meaning
SERVICE NUMBER O-2262850 O-2262850
MEMBER COMPONENT CODE V Reserve
PERSON TYPE NAME CODE L ACTIVE – GUARD/RESERVE
PERSON TYPE NAME ACTIVE – GUARD/RESERVE ACTIVE – GUARD/RESERVE
MEMBER NAME CUOZZO PAUL A CUOZZO PAUL A
MEMBER SERVICE CODE A Army
MEMBER SERVICE NAME ARMY ARMY
MEMBER RANK OR RATE 2LT SECOND LIEUTENANT
MEMBER PAYGRADE O01 OFFICER
MEMBER OCCUPATION CODE 1542 1542
MEMBER OCCUPATION NAME INFANTRY UNIT COMMANDER INFANTRY UNIT COMMANDER
MEMBER BIRTHDATE 19180000 19180000
MEMBER’S GENDER M Male
HOME OF RECORD CITY NEW YORK NEW YORK
HOME OF RECORD COUNTY KINGS KINGS
HOME OF RECORD COUNTRY CODE US UNITED STATES
HOME OF RECORD STATE CODE NY NEW YORK
STATE OR PROVINCE NAME NEW YORK NEW YORK
MARITAL NAME UNKNOWN UNKNOWN
RELIGION SHORT NAME
RELIGION CODE
RACE NAME WHITE WHITE
ETHNIC SHORT NAME NOT SPECIFIED NOT SPECIFIED
RACE OMB NAME WHITE WHITE
ETHNIC GROUP NAME UNKNOWN UNKNOWN
CASUALTY CIRCUMSTANCES
CASUALTY CITY
CASUALTY STATE OR PROVINCE CODE
CASUALTY COUNTRY/OVER WATER CODE KS REPUBLIC OF KOREA
REGION NAME ASIA ASIA
COUNTRY/OVER WATER NAME REPUBLIC OF KOREA REPUBLIC OF KOREA
MEMBER UNIT 21 INF 24 DIV 21 INF 24 DIV
DUTY CODE Z UNKNOWN
PROCESS DATE 19990101 01/01/1999
INCIDENT OR DEATH DATE 19510406 04/06/1951
YEAR OF DEATH 1951 1951
WAR OR CONFLICT CODE K Korean War
OPERATION INCIDENT TYPE CODE C COMBAT
OPERATION/INCIDENT NAME KOREAN WAR KOREAN WAR
LOCATION NAME KOREA KOREA
CLOSURE DATE 19510406 04/06/1951
AIRCRAFT TYPE
HOSTILE OR NON-HOSTILE DEATH INDICATOR H Hostile Death
CASUALTY TYPE NAME DECEASED DECEASED
CASUALTY CATEGORY KILLED IN ACTION KILLED IN ACTION
CASUALTY REASON NAME
CASUALTY CAT. SHORT NAME
REMAINS RECOVERED Y Body Remains Recovered
CASUALTY CLOSURE NAME BURIED – UNKNOWN DISP BURIED – UNKNOWN DISP
VIETNAM WALL ROW AND PANEL INDICATOR
INCIDENT CATEGORY
INCIDENT CASUALTY CATEGORY DATE
INCIDENT CASUALTY CAT. SHORT NAME
INCIDENT HOSTILE OR INCIDENT NON-HOSTILE DEATH
INCIDENT AIRCRAFT TYPE
And voila, yummy juicy information. This makes me want to eat tuna.
Anyway, stay tuned for news & more databases. Keep trying with OPA! It’s hit or miss, but when you do find something, it’s delicious, like birds.
Mucho Fishies.
Genealogy Kitty