Skip to content

Instantly share code, notes, and snippets.

@stucka

stucka/cas_cat.csv

Created May 12, 2015 20:34
Show Gist options
  • Save stucka/45a954d33b936a9e8565 to your computer and use it in GitHub Desktop.
Save stucka/45a954d33b936a9e8565 to your computer and use it in GitHub Desktop.
Download ZIP
Vietnam casualty list lookup tables, courtesy of McClatchy Co.
Raw
cas_cat.csv
casualty_category text
ACCIDENT died in an accident
DECLARED DEAD was declared dead
DIED OF WOUNDS died of wounds
HOMICIDE was a homicide victim
ILLNESS died of an illness
KILLED IN ACTION was killed in action
PRESUMED DEAD was presumed dead
SELF-INFLICTED died of self-inflicted causes
Raw
cas_reason.csv
casualty_reason_name text
AIRCRAFT CRASH -- CREW (MC) as a crew member in an aircraft crash
AIRCRAFT CRASH -- PASSENGER (MC) as a passenger in an aircraft crash
ARTILLERY/MORTAR/ROCKET from artillery, mortar or rocket fire
BLUNT FORCE from blunt force
BURNS/SMOKE INHALATION from burns or smoke inhalation
CANCER from cancer
DROWNING from drowning
EXPLOSIVE DEVICE from an explosive device
GRENADE from a grenade
GUNSHOT from a gunshot
HEART RELATED from a heart-related condition
HELICOPTER CRASH -- CREW (MC) as a crew member in a helicopter crash
HELICOPTER CRASH -- PASSENGER (MC) as a passenger in a helicopter crash
INFECTIOUS DISEASE from an infectious disease
LAND MINE from a land mine
MISSILE from a missile
OTHER ACCIDENT in an accident
OTHER WEAPONS from a weapon
SHIP/SUBMARINE ACCIDENT AT SEA (MC) in an accident at sea
SMALL ARMS FIRE from small-arms fire
STROKE from a stroke
UNKNOWN from unknown causes
VEHICLE CRASH (MC) from a vehicle crash
Raw
married.csv
marital_status text
DIVORCED was divorced
MARRIED was married
NEVER MARRIED never married
UNKNOWN was of an unknown marital status
WIDOWED was widowed
Raw
rank.csv
Ranks from: http://www.usna.edu/Commandant/Directives/Admin/Military%20Abbreviations.pdf
Ratings from http://www.navy.mil/navydata/ranks/rates/rates2.html
PSG from somewhere else
AP officialname uppername
1st Lt. 1LT 1LT
1st Sgt. 1SG 1SG
1st Lt. 1stLt 1STLT
1st Sgt. 1stSgt 1STSGT
2nd Lt. 2dLt 2DLT
2nd Lt. 2LT 2LT
2nd Lt. 2ndLt 2NDLT
Airman 1st Class A1C A1C
Airman 2nd Class A2C A2C
Airman 3rd Class A3C A3C
Airman Apprentice AA AA
Airman Apprentice AA AA
Airman Basic AB AB
Adm. ADM ADM
Airman Amn AMN
Airman AN AN
Airman AN AN
Airman Recruit AR AR
Brig. Gen. BG BG
Brig. Gen. BGen BGEN
Brig. Gen. BrigGen BRIGGEN
Constructionman Apprentice CA CA
Cadet CADET CADET
Capt. CAPT CAPT
Capt. Capt CAPT
Capt. Capt CAPT
Command Chief Master Sgt. CCM CCM
Cmdr. CDR CDR
Chief Master Sgt. Of the Air Force CMSAF CMSAF
Chief Master Sgt. CMSgt CMSGT
Constructionman CN CN
Constructionman CN CN
Col. COL COL
Col. Col COL
Cpl. CPL CPL
Cpl. Cpl CPL
Chief Petty Officer CPO CPO
Capt. CPT CPT
Constructionman Recruit CR CR
Command Sgt. Maj. CSM CSM
Chief Warrant Officer 2 CW2 CW2
Chief Warrant Officer 3 CW3 CW3
Chief Warrant Officer 4 CW4 CW4
Chief Warrant Officer 5 CW5 CW5
Chief Warrant Officer 2 CWO2 CWO2
Chief Warrant Officer 3 CWO3 CWO3
Chief Warrant Officer 4 CWO4 CWO4
Chief Warrant Officer 4 CWO-4 CWO-4
Chief Warrant Officer 5 CWO5 CWO5
Dental Apprentice DA DA
Dentalman DN DN
Dental Recruit DR DR
Ensign ENS ENS
Fireman Apprentice FA FA
Fireman FN FN
Fireman Recruit FR FR
Gen. GEN GEN
Gen. Gen GEN
Gen. Gen GEN
Gunnery Sgt. GySgt GYSGT
Hospital Apprentice HA HA
Hospitalman HN HN
Hospital Recruit HR HR
Lt. Cmdr. LCDR LCDR
Lance Cpl. LCpl LCPL
Lt. Cmdr. LT LT
Lt. Col. LTC LTC
Lt. Col. LtCol LTCOL
Lt. Gen. LTG LTG
Lt. Gen. LtGen LTGEN
Lt. j.g. LTJG LTJG
Maj. MAJ MAJ
Maj. Maj MAJ
Maj. Gen. MajGen MAJGEN
Master Chief Petty Officer MCPO MCPO
Master Chief Petty Officer of the Navy MCPON MCPON
Maj. Gen. MG MG
Maj. Gen. MGen MGEN
Master Gunnery Sgt. MGySgt MGYSGT
Master Sgt. MSG MSG
Master Sgt. MSgt MSGT
Pfc. PFC PFC
Petty Officer 1st Class PO1 PO1
Petty Officer 2nd Class PO2 PO2
Petty Officer 3rd Class PO3 PO3
Platoon Sgt. PSG PSG
Pvt. PV1 PV1
Pvt. PV2 PV2
Pvt. Pvt PVT
Rear Adm. RADM RADM
Rear Adm. RDML RDML
Seaman Apprentice SA SA
Senior Chief Petty Officer SCPO SCPO
Sgt. 1st Class SFC SFC
Sgt. Maj. Of the Army SGM SGM
Sgt. SGT SGT
Sgt. Sgt SGT
Sgt. Maj. SgtMaj SGTMAJ
Sgt. Maj. Of the Marine Corps SgtMajMC SGTMAJMC
Sgt. Maj. Of the Army SMA SMA
Senior Master Sgt. SMSgt SMSGT
Seaman SN SN
Spec. 4 SP4 SP4
Spec. 5 SP5 SP5
Spec. 6 SP6 SP6
Spec. SPC SPC
Seaman Recruit SR SR
Senior Airman SrA SRA
Staff Sgt. SSG SSG
Staff Sgt. SSgt SSGT
Tech. Sgt. TSgt TSGT
Vice Adm. VADM VADM
Warrant Officer 1 WO WO
Warrant Officer 1 WO1 WO1
Warrant Officer 1 WO-1 WO-1
Raw
religion.csv
Religion Follower
AMERICAN BAPTIST CHURCHES IN THE USA Baptist
ASSEMBLIES OF GOD Christian
BAPTIST CHURCHES Baptist
BRETHREN CHURCHES Anabaptist
BUDDHISM Buddhist
CATHOLIC CHURCHES (EXCLUDES ROMAN CATHOLIC CHURCH) Catholic
CHRISTIAN CHURCH Christian
CHRISTIAN, NO DENOMINATIONAL PREFERENCE Christian
CHURCH OF CHRIST Christian
CHURCH OF GOD (ANDERSON, IN) Christian
CHURCH OF JESUS CHRIST OF LATTER DAY SAINTS (MORMON) Mormon
CHURCH OF THE NAZARENE Christian
CONGREGATIONAL CHURCHES Christian
EPISCOPAL CHURCH Episcopalian
FIRST CHURCH OF CHRIST, SCIENTIST (CHRISTIAN SCIENCE) Christian Scientist
FRIENDS (QUAKERS) Quaker
ISLAM Muslim
JEHOVAH'S WITNESSES Jehovah's Witness
JUDAISM (JEWISH) Jew
LUTHERAN CHURCHES Lutheran
METHODIST CHURCHES Methodist
NO RELIGIOUS PREFERENCE person with no religious preference
PENTECOSTAL CHURCHES Pentecostal
PRESBYTERIAN CHURCH (USA) Presbyterian
PROTESTANT, NO DENOMINATIONAL PREFERENCE Protestant
PROTESTANT, OTHER CHURCHES Protestant
REFORMED CHURCH IN AMERICA Christian
ROMAN CATHOLIC CHURCH Catholic
SEVENTH DAY ADVENTIST Seventh Day Adventist
SOUTHERN BAPTIST CONVENTION Southern Baptist
UNCLASSIFIED RELIGIONS person with an unclassified religion
UNITARIAN UNIVERSALIST Unitarian
UNITED CHURCH OF CHRIST Protestant
Raw
states.csv
State_name text
AK Alaska
AL Alabama
AR Arkansas
AS American Samoa
AZ Arizona
CA California
CO Colorado
CT Connecticut
CZ Canal Zone
DC Washington, D.C.
DE Delaware
FL Florida
FR foreign nation
GA Georgia
GU Guam
HI Hawaii
IA Iowa
ID Idaho
IL Illinois
IN Indiana
KS Kansas
KY Kentucky
LA Louisiana
MA Massachusetts
MD Maryland
ME Maine
MI Michigan
MN Minnesota
MO Missouri
MS Mississippi
MT Montana
NC North Carolina
ND North Dakota
NE Nebraska
NH New Hampshire
NJ New Jersey
NM New Mexico
NV Nevada
NY New York
OH Ohio
OK Oklahoma
ON Ontario
OR Oregon
PA Pennsylvania
PR Puerto Rico
RI Rhode Island
SC South Carolina
SD South Dakota
TN Tennessee
TX Texas
UT Utah
VA Virginia
VI Virgin Islands
VT Vermont
WA Washington
WI Wisconsin
WV West Virginia
WY Wyoming
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment