{"id":29,"date":"2012-10-24T17:02:30","date_gmt":"2012-10-24T17:02:30","guid":{"rendered":"http:\/\/www.brattykitty.com\/?p=29"},"modified":"2012-10-24T17:02:30","modified_gmt":"2012-10-24T17:02:30","slug":"databases-i-love-national","status":"publish","type":"post","link":"http:\/\/www.brattykitty.com\/?p=29","title":{"rendered":"Databases I Love – National"},"content":{"rendered":"

The first database I’d like to discuss is the OPA or Online Public Access database<\/a> 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.<\/p>\n

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:<\/p>\n

Korean War Extract Data File, as of April 29, 2008 , 06\/28\/1950 – 03\/10\/1954<\/a><\/p>\n

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

Korean War Extract Data File, as of April 29, 2008\u00a0, 06\/28\/1950 – 03\/10\/1954<\/em><\/strong><\/p>\n

ARC Identifier 2240988<\/strong><\/p>\n

File Unit from Record Group 330: Records of the Office of the Secretary of Defense, 1921 – 2008<\/p>\n\n\n\n\n\n
Creator(s):<\/th>\nDepartment of Defense. Office of the Under Secretary of Defense for Personnel and Readiness. Defense Human Resources Activity. Defense Manpower Data Center. (1997 – ) (Most Recent)<\/a>
\nDepartment of Defense. Washington Headquarters Services. Directorate for Information Operations and Reports. Statistical Information Analysis Division. (ca. 1997 – ) (Predecessor)<\/a><\/td>\n<\/tr>\n
Type(s) of Archival Materials:<\/th>\nData Files<\/td>\n<\/tr>\n
Contact(s):<\/th>\nElectronic 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<\/a>.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
<\/div>\n\n\n\n\n\n\n\n
Coverage Dates:<\/a><\/th>\n06\/28\/1950 – 03\/10\/1954<\/td>\n<\/tr>\n
Date Note:<\/th>\nAlthough 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.<\/td>\n<\/tr>\n
Part Of:<\/th>\nSeries:\u00a0Defense Casualty Analysis System (DCAS) Extract Files, compiled ca. 2001 – 04\/29\/2008, documenting the period 06\/28\/1950 – 05\/28\/2006<\/a><\/td>\n<\/tr>\n
Access Restriction(s):<\/th>\nUnrestricted<\/td>\n<\/tr>\n
Use Restriction(s):<\/th>\nUnrestricted<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
<\/div>\n\n\n\n\n\n
Online Resource:<\/th>\nAccess to Archival Databases (AAD) system<\/td>\n<\/tr>\n
Online Resource URL:<\/th>\nhttp:\/\/aad.archives.gov\/aad\/fielded-search.jsp?dt=2512&tf=F&cat=WR27&bc=,sl<\/a><\/td>\n<\/tr>\n
Online Resource Note:<\/th>\nThis file can be searched online via the Access to Archival Databases (AAD) system.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
<\/div>\n\n\n\n
Variant Control Number(s):<\/th>\nDownload Display Identifier: DDI
\nXMIS Number: 099292
\nThis is the agency electronic documentation file.
\nXMIS Number: 099293
\nThis is the data file.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
<\/div>\n
Ooh, did you see the “Online Resource URL”? I did! So I can click that and it takes me to ANOTHER database! *Whee*!<\/div>\n
<\/div>\n
Go to that, and search for Cuozzo brings this result:<\/div>\n
<\/div>\n
\n\n\n\n\n\n\n
View Record<\/th>\nSERVICE NUMBER<\/th>\nMEMBER NAME<\/th>\nMEMBER SERVICE CODE<\/th>\nMEMBER BIRTHDATE<\/th>\nHOME OF RECORD CITY<\/th>\nHOME OF RECORD COUNTY<\/th>\nHOME OF RECORD STATE CODE<\/th>\nINCIDENT OR DEATH DATE<\/th>\nCASUALTY CATEGORY<\/th>\n<\/tr>\n
<\/td>\n\"sort<\/a><\/td>\n\"sort<\/a><\/td>\n\"sort<\/a><\/td>\n\"sort<\/a><\/td>\n\"sort<\/a><\/td>\n\"sort<\/a><\/td>\n\"sort<\/a><\/td>\n\"sort<\/a><\/td>\n\"sort<\/a><\/td>\n<\/tr>\n<\/thead>\n
\"View\"<\/a><\/td>\nO-2262850<\/td>\nCUOZZO PAUL A<\/td>\nArmy<\/td>\n19180000<\/td>\nNEW YORK<\/td>\nKINGS<\/td>\nNEW YORK<\/td>\n04\/06\/1951<\/td>\nKILLED IN ACTION<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
<\/div>\n
Well, now I know his service number, which is very helpful if dealing with the military.<\/div>\n
<\/div>\n
If you click “view record” on the left, this is what you get:<\/div>\n
<\/div>\n
<\/div>\n
\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Field Title<\/th>\nValue<\/th>\nMeaning<\/th>\n<\/tr>\n
SERVICE NUMBER<\/a><\/td>\nO-2262850<\/td>\nO-2262850<\/td>\n<\/tr>\n
MEMBER COMPONENT CODE<\/a><\/td>\nV<\/td>\nReserve<\/td>\n<\/tr>\n
PERSON TYPE NAME CODE<\/a><\/td>\nL<\/td>\nACTIVE – GUARD\/RESERVE<\/td>\n<\/tr>\n
PERSON TYPE NAME<\/a><\/td>\nACTIVE – GUARD\/RESERVE<\/td>\nACTIVE – GUARD\/RESERVE<\/td>\n<\/tr>\n
MEMBER NAME<\/a><\/td>\nCUOZZO PAUL A<\/td>\nCUOZZO PAUL A<\/td>\n<\/tr>\n
MEMBER SERVICE CODE<\/a><\/td>\nA<\/td>\nArmy<\/td>\n<\/tr>\n
MEMBER SERVICE NAME<\/a><\/td>\nARMY<\/td>\nARMY<\/td>\n<\/tr>\n
MEMBER RANK OR RATE<\/a><\/td>\n2LT<\/td>\nSECOND LIEUTENANT<\/td>\n<\/tr>\n
MEMBER PAYGRADE<\/a><\/td>\nO01<\/td>\nOFFICER<\/td>\n<\/tr>\n
MEMBER OCCUPATION CODE<\/a><\/td>\n1542<\/td>\n1542<\/td>\n<\/tr>\n
MEMBER OCCUPATION NAME<\/a><\/td>\nINFANTRY UNIT COMMANDER<\/td>\nINFANTRY UNIT COMMANDER<\/td>\n<\/tr>\n
MEMBER BIRTHDATE<\/a><\/td>\n19180000<\/td>\n19180000<\/td>\n<\/tr>\n
MEMBER’S GENDER<\/a><\/td>\nM<\/td>\nMale<\/td>\n<\/tr>\n
HOME OF RECORD CITY<\/a><\/td>\nNEW YORK<\/td>\nNEW YORK<\/td>\n<\/tr>\n
HOME OF RECORD COUNTY<\/a><\/td>\nKINGS<\/td>\nKINGS<\/td>\n<\/tr>\n
HOME OF RECORD COUNTRY CODE<\/a><\/td>\nUS<\/td>\nUNITED STATES<\/td>\n<\/tr>\n
HOME OF RECORD STATE CODE<\/a><\/td>\nNY<\/td>\nNEW YORK<\/td>\n<\/tr>\n
STATE OR PROVINCE NAME<\/a><\/td>\nNEW YORK<\/td>\nNEW YORK<\/td>\n<\/tr>\n
MARITAL NAME<\/a><\/td>\nUNKNOWN<\/td>\nUNKNOWN<\/td>\n<\/tr>\n
RELIGION SHORT NAME<\/a><\/td>\n<\/td>\n<\/td>\n<\/tr>\n
RELIGION CODE<\/a><\/td>\n<\/td>\n<\/td>\n<\/tr>\n
RACE NAME<\/a><\/td>\nWHITE<\/td>\nWHITE<\/td>\n<\/tr>\n
ETHNIC SHORT NAME<\/a><\/td>\nNOT SPECIFIED<\/td>\nNOT SPECIFIED<\/td>\n<\/tr>\n
RACE OMB NAME<\/a><\/td>\nWHITE<\/td>\nWHITE<\/td>\n<\/tr>\n
ETHNIC GROUP NAME<\/a><\/td>\nUNKNOWN<\/td>\nUNKNOWN<\/td>\n<\/tr>\n
CASUALTY CIRCUMSTANCES<\/a><\/td>\n<\/td>\n<\/td>\n<\/tr>\n
CASUALTY CITY<\/a><\/td>\n<\/td>\n<\/td>\n<\/tr>\n
CASUALTY STATE OR PROVINCE CODE<\/a><\/td>\n<\/td>\n<\/td>\n<\/tr>\n
CASUALTY COUNTRY\/OVER WATER CODE<\/a><\/td>\nKS<\/td>\nREPUBLIC OF KOREA<\/td>\n<\/tr>\n
REGION NAME<\/a><\/td>\nASIA<\/td>\nASIA<\/td>\n<\/tr>\n
COUNTRY\/OVER WATER NAME<\/a><\/td>\nREPUBLIC OF KOREA<\/td>\nREPUBLIC OF KOREA<\/td>\n<\/tr>\n
MEMBER UNIT<\/a><\/td>\n21 INF 24 DIV<\/td>\n21 INF 24 DIV<\/td>\n<\/tr>\n
DUTY CODE<\/a><\/td>\nZ<\/td>\nUNKNOWN<\/td>\n<\/tr>\n
PROCESS DATE<\/a><\/td>\n19990101<\/td>\n01\/01\/1999<\/td>\n<\/tr>\n
INCIDENT OR DEATH DATE<\/a><\/td>\n19510406<\/td>\n04\/06\/1951<\/td>\n<\/tr>\n
YEAR OF DEATH<\/a><\/td>\n1951<\/td>\n1951<\/td>\n<\/tr>\n
WAR OR CONFLICT CODE<\/a><\/td>\nK<\/td>\nKorean War<\/td>\n<\/tr>\n
OPERATION INCIDENT TYPE CODE<\/a><\/td>\nC<\/td>\nCOMBAT<\/td>\n<\/tr>\n
OPERATION\/INCIDENT NAME<\/a><\/td>\nKOREAN WAR<\/td>\nKOREAN WAR<\/td>\n<\/tr>\n
LOCATION NAME<\/a><\/td>\nKOREA<\/td>\nKOREA<\/td>\n<\/tr>\n
CLOSURE DATE<\/a><\/td>\n19510406<\/td>\n04\/06\/1951<\/td>\n<\/tr>\n
AIRCRAFT TYPE<\/a><\/td>\n<\/td>\n<\/td>\n<\/tr>\n
HOSTILE OR NON-HOSTILE DEATH INDICATOR<\/a><\/td>\nH<\/td>\nHostile Death<\/td>\n<\/tr>\n
CASUALTY TYPE NAME<\/a><\/td>\nDECEASED<\/td>\nDECEASED<\/td>\n<\/tr>\n
CASUALTY CATEGORY<\/a><\/td>\nKILLED IN ACTION<\/td>\nKILLED IN ACTION<\/td>\n<\/tr>\n
CASUALTY REASON NAME<\/a><\/td>\n<\/td>\n<\/td>\n<\/tr>\n
CASUALTY CAT. SHORT NAME<\/a><\/td>\n<\/td>\n<\/td>\n<\/tr>\n
REMAINS RECOVERED<\/a><\/td>\nY<\/td>\nBody Remains Recovered<\/td>\n<\/tr>\n
CASUALTY CLOSURE NAME<\/a><\/td>\nBURIED – UNKNOWN DISP<\/td>\nBURIED – UNKNOWN DISP<\/td>\n<\/tr>\n
VIETNAM WALL ROW AND PANEL INDICATOR<\/a><\/td>\n<\/td>\n<\/td>\n<\/tr>\n
INCIDENT CATEGORY<\/a><\/td>\n<\/td>\n<\/td>\n<\/tr>\n
INCIDENT CASUALTY CATEGORY DATE<\/a><\/td>\n<\/td>\n<\/td>\n<\/tr>\n
INCIDENT CASUALTY CAT. SHORT NAME<\/a><\/td>\n<\/td>\n<\/td>\n<\/tr>\n
INCIDENT HOSTILE OR INCIDENT NON-HOSTILE DEATH<\/a><\/td>\n<\/td>\n<\/td>\n<\/tr>\n
INCIDENT AIRCRAFT TYPE<\/a><\/td>\n<\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
<\/div>\n
And voila, yummy juicy information. This makes me want to eat tuna.<\/div>\n
<\/div>\n
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.<\/div>\n
<\/div>\n
Mucho Fishies.<\/div>\n
<\/div>\n
Genealogy Kitty<\/div>\n","protected":false},"excerpt":{"rendered":"

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 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[3,4],"tags":[],"_links":{"self":[{"href":"http:\/\/www.brattykitty.com\/index.php?rest_route=\/wp\/v2\/posts\/29"}],"collection":[{"href":"http:\/\/www.brattykitty.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.brattykitty.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.brattykitty.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.brattykitty.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=29"}],"version-history":[{"count":1,"href":"http:\/\/www.brattykitty.com\/index.php?rest_route=\/wp\/v2\/posts\/29\/revisions"}],"predecessor-version":[{"id":30,"href":"http:\/\/www.brattykitty.com\/index.php?rest_route=\/wp\/v2\/posts\/29\/revisions\/30"}],"wp:attachment":[{"href":"http:\/\/www.brattykitty.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=29"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.brattykitty.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=29"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.brattykitty.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=29"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}