Giter Club home page Giter Club logo

ca-license-plates's Introduction

California license plates

Warning: this dataset contains vulgar and offensive language (quite a lot of it).

applications.csv is a CSV of 23,463 personalized license plate applications the California DMV received from 2015-2016.

These do NOT represent all applications received by the DMV during that timeframe, only applications that were flagged for additional review by the Review Committee. The file includes the following columns:

  • plate: the personalized license plate combination requested.
  • review_reason_code: Reason code for the application being reviewed (see below for codes).
  • customer_meaning: Meaning of the plate provided by the applicant.
  • reviewer_comments: Comments from DMV reviewers.
  • status: Y means the plate was approved, N means it was denied.

This data was parsed from a set of 458 Excel workbooks that the DMV prepared for someone else's public records request. I received the files as a consolation prize in response to my own related records request, which I was told would cost $2,000 to fulfill otherwise.

Notes

  • In plate combinations, a # character indicates a hand symbol, a $ character indicates the heart symbol, a + character indicates the plus symbol, and a & character indicates the star symbol.
  • Some records are missing reason codes, customer meanings, reviewer comments, and/or statuses.
  • A reviewer comment of "No micro" indicates that a paper application was submitted but was unavailable in the DMV's imaging system.
  • In a few cases the reason code is some other character or word besides Y or N, possibly a typo.
  • I tried to redact any records I found that seemed to include too much personal information about the applicant (about 50 in total).
  • Because the data is parsed from Excel workbooks that are not 100% consistent in structure, there may be some errors.
  • Review reason codes are described as follows:
7(B) When a desired configuration is not available, a letter shall not be substituted for a number, nor shall a number be substituted for a letter, to create another configuration of a similar appearance.
7(D) The department shall refuse any configuration that may carry connotations offensive to good taste and decency, or which would be misleading, based on criteria which includes, but is not limited to, the following:
    1. The configuration has a sexual connotation or is a term of lust or depravity.
    2. The configuration is a vulgar term; a term of contempt, prejudice, or hostility; an insulting or degrading term; a racially degrading term; or an ethnically degrading term.
    3. The configuration is a swear word or term considered profane, obscene, or repulsive.
    4. The configuration has a negative connotation to a specific group.
    5. The configuration misrepresents a law enforcement entity.
    6. The configuration has been deleted from regular series license plates.
    7. The configuration is a foreign or slang word or term, or is a phonetic spelling or mirror image of a word or term falling into the categories described in subdivisions 1. through 6. above.

ca-license-plates's People

Contributors

veltman avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.