NEW YORK CITY, NY: 1977-2013 (9.8 MILLION RECORDS)



New York City is the most populous city in the United States. This dataset includes about 9.8 million cases spanning 1977 to 2013, based on the most serious charge in each case, provided by the New York State Division of Criminal Justice Services.

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

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