WISCONSIN: 1959-2017 (5.4 MILLION RECORDS)



Wisconsin is a U.S. state. This statewide dataset includes about 5.4 million criminal charges spanning 1959 to 2017, drawn from Wisconsin’s circuit court records. Note: unlike the other jurisdictions here, Wisconsin’s data is still being finalized and is not yet part of the live CRD dashboard.

Field Type Description % Present
case.date date date case is filed 100%
case.status string case status code 100%
case.bond double current bond amount set 0%
case.code string current offense code 97%
case.literal string current offense code literal 97%
case.degree string level and degree of current offense 0%
case.uid string unique case/incident identifier 100%
case.trialtype factor case trial type (Bench / Jury) 1.1%
case.courtnr integer court number 86.3%
case.attorney boolean True if case/def has attorney 100%
case.publicdef boolean True if case/def has public defender 0%
def.uid string defendant’s unique system person ID (SPN number) 100%
def.race string defendant race 83.2%
def.ethnicity string defendant ethnicity 0%
def.gender string defendant gender 98%
def.dob date defendant date of birth (year & month) 99.5%
def.citizenship string defendant citizenship status 0%
def.language string defendant language 0%
att.literal string attorney connection to the case 0%
file.date Date charge/offense date it was filed 100%
off.date date date of the offense 94.5%
off.county string county where def is arrested 100%
off.bond double bond amount at time of offense/arrest 0%
off.code string offense code at time of offense/arrest 100%
off.uid string charge/offense Unique Identifier 100%
off.nr string charge/offense sequential number (mostly) 100%
off.statute string charge/offense statute 100%
off.literal string offense literal at time of offense/arrest 97.1%
off.degree string level and degree of complaint offense 97%
arrest.date date arrest date 0%
arrest.agency string arresting agency 0%
gj.date date date of grand jury action 0%
gj.status string defendant status at time of grand jury action 0%
gj.action string grand jury action code 0%
gj.courtnr string grand jury court 0%
gj.offcode string offense at time of grand jury action 0%
gj.offliteral string grand jury offense code literal 0%
gj.offdegree string level and degree of grand jury offense 0%
gj.bond double bond amount at time of grand jury action 0%
disp.date date date of disposition 95.8%
disp.code string offense code at disposition 0%
disp.statute string disposition statute 0%
disp.county string county where case is disposed (mostly NYC) 100%
disp.plea string details of the def plea 0%
disp.literal string details of disposition 92.9%
calc.age double defendant age at the time of case filed or the arrest date 99.5%
calc.race string standardized race including Hispanic ethnicity based on surname 83.4%
calc.gender string missing/unknown genders, use given name to determine gender 98.1%
calc.broad string standardized broad crime category 99.8%
calc.detailed string standardized detailed crime category 99.2%
calc.disp string standardized disposition 100%
calc.degree string Inferred felony/misd when not given 90.3%
calc.year integer the year the case is filed 100%

This categorization scheme was created by two Harvard-trained lawyers (Pablo Ormachea and Sarah Isgur), who worked closely with the team’s programmers to work through thousands of different crime labels across multiple counties in multiple states. Ultimately, the collaboration resulted in 30+ useful, meaningful categories that address changing definitions over time. For instance, in Harris County, there is no longer a crime called “rape”; today, those crimes would be called “sexual assault.” Here are details of each crime category, illustrated with representative crimes.

  1. Alcohol-Driving: Driving a vehicle on land, sea, or air with an open container or while intoxicated beyond the legal limit. Importantly, the legal limit has been gradually reduced from 1977 until today’s legal limit of 0.08 blood alcohol content. The vast majority of accusations in this category are for driving while intoxicated on the first offense, second offense, and third offense.
  2. Alcohol-Other: Alcohol violations that do not involve driving a vehicle. This includes the crimes of public intoxication, violation of age-restrictions, and other crimes violating the Texas Alcohol Beverage Code.
  3. Animal Violence: Crimes involving animal violence. This includes the crimes of cruelty to animals, dog fighting, and dog attacks.
  4. Arson: Crimes of arson or attempted arson of a building, vehicle, or habitation.
  5. Assault-Nonsexual: Nonsexual crimes of violence both with and without a weapon. The most common crimes are assault of a family member, aggravated assault with a deadly weapon, and aggravated robbery with a deadly weapon. One important caveat: If the crime label means the victim is indisputably a child, then the crime has been categorized as “Crimes Against Children” instead of “Assault-Nonsexual.”
  6. Burglary: Burglary or attempted burglary of a habitation, building, or vehicle. The most common crimes are Burglary of a Habitation with Theft, Burglary with Intent to Commit Theft, and Burglary of a Building. If the crime label makes it clear that the burglary had the intent to commit a sexual felony rather than theft, then the crime has been placed within the category of “Sexual Assault” and not “Burglary.”
  7. Child Sex Crimes: Sexually related crimes against children. To be in this category, the sexual crime had to be indisputably against a person aged 17 or younger. Crimes include Aggravated Sexual Assault of a Child Under 14, Sexual Assault of a Child of 14 to 17 years of Age, Sexual Assault of a Child, and Indecency of Touching a Child’s Genitals, and Possession of Child Pornography.
  8. Computer Crimes: Nonsexual crimes like breaching computer security, installing tracking devices, or intercepting electronic communication.
  9. Controlled Substances-Marijuana: Possession, manufacture, or delivery of marijuana. This category is overwhelmingly dominated by possession of 0-2 ounces of marijuana. The second most frequent crime is possession of 4 ounces to 5 pounds of marijuana.-
  10. Controlled Substances-Other: Possession, manufacture, or delivery of other controlled substances. Two of the three most common crimes are for possession of under 1 gram or for possession of 1-4 grams of a controlled substance from Texas penalty group 1, which includes opiates and other substances known as acid, crack, cocaine, ecstasy, or heroin. More information about Texas penalty groups can be found here. Texas did not always categorize controlled substances into penalty groups, which explains why the second most common crime is delivery of under 28 grams of crack.
  11. Crimes Against Children: Crimes against children. The most common crimes are for endangering a child, intentionally causing a bodily injury to a child under 15, and recklessly causing a bodily injury to a child.
  12. Crimes by Public Servants: Crimes committed by public servants such as police officers or government clerks. The majority of instances are for investigating a police officer’s discharge of his or her firearm. The second most common crime type is for attempting to tamper with government records.
  13. Evading/Resisting/Escaping: Evading, resisting, or escaping official custody. The most common crimes are for evading arrest with a motor vehicle, evading detention, and resisting a search during an arrest.
  14. Fraud, Forgery, or Impersonation: Credit card fraud, fraudulently creating, altering, or using a document, or fraudulently impersonating another person. The most common crimes are for credit card fraud, forgery of a document, credit or debit card abuse, and forging a government instrument.
  15. Gambling: Gambling, promotion of gambling, possession of gambling devices, or illegally keeping a place of gambling.
  16. Guns-Unlawful Possession/Conduct: Unlawful possession or carry of a firearm, reckless conduct of a firearm, and other crimes related to illegal ownership or use of a firearm. The most common crimes are for a convicted felon illegally possessing a weapon, carrying a weapon in an unlawful place, or possession of a prohibited firearm.
  17. Harassment/Stalking: Crimes related to harassing or stalking another individual. The most common crimes are violation of a protective order, threatening to injure a person, or harassing communication.
  18. Kidnapping: Kidnapping or otherwise preventing someone from leaving an enclosed area. The most common crimes are false imprisonment, aggravated kidnapping, or kidnapping.
  19. Licensing: Failure to comply with licensing requirements or taxes related to licensing. The most common crimes are failure to pay state taxes for controlled substances, serving a non-licensed beverage, or violating the terms of a liquor license.
  20. Low Level Crime: Not all crimes fit easily within another category. This contains highly infrequent, nonviolent, and nonsexual crimes like violating ordinances, election laws, possessing criminal instruments, or soliciting ground transportation.
  21. Murder: Direct loss of human life. The most common crimes are for involuntary manslaughter, murder, capital murder, and intoxicated manslaughter with a vehicle.
  22. Obstructing: Obstructing the proper functioning and procedures of the criminal process. The most common crimes are for reporting a false alarm, tampering or fabricating evidence, retaliation, tampering with government records, or otherwise interfering with the duties of a public servant.
  23. Organized Crime: Organized criminal activity like money laundering or increasing gang membership. The most common crimes are for Engaging in Organized Criminal Activity, Endless Chain Scheme, and money laundering between $200,000 and $100,000.
  24. Parole Violation: Parole-related violations like failing to provide accurate information to a parole officer, failure to comply with sex offender registration requirements, or jumping bail.
  25. Pollution: Crimes involving pollution. This includes crimes like unlawful transportation of chemicals, illegal disposal of litter, water pollution, dumping, and illegal dumping.-
  26. Sexual Assault: Sexual crimes that make direct use of force. As stated above, Texas no longer uses the term “rape,” as that crime is now considered a form of “sexual assault.” The most common crimes are for aggravated sexual assault, aggravated rape, burglary of a habitation with a rape, and sexual assault.
  27. Sexual Non-Assault: Sexual crimes that do not make direct use of force. This includes the crimes of prostitution, promoting obscene material, indecent exposure, sale of obscene material, or prohibited sexual conduct (like incest, bigamy, or once-outlawed homosexual conduct).
  28. Theft/Fraud: Instances of theft. These crimes include theft of a vehicle or other valuables, theft by receiving, and theft of trade secrets.
  29. Traffic Offense: Traffic violations like driving while license is suspended, unauthorized use of a motor vehicle, reckless driving, and expired inspections.
  30. Trespass: Property rights violations. The vast majority of these crimes are for criminal mischief (such as graffiti) or trespassing on another’s property. This differs critically from burglary in that the defendant is not accused of attempting to steal any physical or electronic item of value.

Privacy Preference Center