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.
- 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.
- 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.
- Animal Violence: Crimes involving animal violence. This includes the crimes of cruelty to animals, dog fighting, and dog attacks.
- Arson: Crimes of arson or attempted arson of a building, vehicle, or habitation.
- 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.”
- 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.”
- 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.
- Computer Crimes: Nonsexual crimes like breaching computer security, installing tracking devices, or intercepting electronic communication.
- 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.-
- 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.
- 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.
- 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.
- 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.
- 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.
- Gambling: Gambling, promotion of gambling, possession of gambling devices, or illegally keeping a place of gambling.
- 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.
- 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.
- Kidnapping: Kidnapping or otherwise preventing someone from leaving an enclosed area. The most common crimes are false imprisonment, aggravated kidnapping, or kidnapping.
- 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.
- 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.
- Murder: Direct loss of human life. The most common crimes are for involuntary manslaughter, murder, capital murder, and intoxicated manslaughter with a vehicle.
- 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.
- 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.
- 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.
- Pollution: Crimes involving pollution. This includes crimes like unlawful transportation of chemicals, illegal disposal of litter, water pollution, dumping, and illegal dumping.-
- 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.
- 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).
- Theft/Fraud: Instances of theft. These crimes include theft of a vehicle or other valuables, theft by receiving, and theft of trade secrets.
- Traffic Offense: Traffic violations like driving while license is suspended, unauthorized use of a motor vehicle, reckless driving, and expired inspections.
- 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.

