-
Notifications
You must be signed in to change notification settings - Fork 52
Dataset: OATH Hearings
Maxwell Austensen edited this page Oct 7, 2019
·
1 revision
The oath_hearings dataset can be added to NYCDB by running:
nycdb --download oath_hearings
nycdb --load oath_hearings
The dataset comes from the NYC open data portal's OATH Hearings Division Case Status dataset.
The OATH Hearings Division Case Status dataset contains information about alleged public safety and quality of life violations that are filed and adjudicated through the City’s administrative law court, the NYC Office of Administrative Trials and Hearings (OATH) and provides information about the infraction charged, decision outcome, payments, amounts and fees relating to the case. The summonses listed in this dataset are issued and filed at the OATH Hearings Division by City enforcement agencies.
OATH hearings from this dataset can also be connected to records in the ECB Violations dataset to get additional information about the violation. For more details on how to do this, see this example query.
You can download the data dictionary XLSX.
Click to Expand the Data Dictionary
| column_name | data_type | description |
|---|---|---|
| ticketnumber | text | A unique identifier for the summons (This number can be used to find the asociated violation record in the ECB Violations dataset, where the same field is called ecbviolationnumber) |
| violationdate | date | The date on which the alleged violation indicated on the summons occurred |
| violationtime | time without time zone | The time of day at which the alleged violation indicated on the summons occurred |
| issuingagency | text | A governmental agency authorized to issue summonses for violations of City rules and regulations |
| respondentfirstname | text | The first name of the person or company name to whom or which the summons was issued |
| respondentlastname | text | The last name of the person to whom the summons was issued |
| balancedue | numeric | The balance of the monetary penalty owed by the respondent |
| violationlocationborough | text | One of the five boroughs of New York City (Brooklyn, Bronx, Manhattan, Queens and Staten Island) in which the alleged violation occurred |
| violationlocationblockno | integer | The block number of the location where the alleged violation occurred |
| violationlocationlotno | integer | The lot number of the location where the alleged violation occurred |
| violationlocationhouse | text | The number of the house, building or structure where the alleged violation occurred |
| violationlocationstreetname | text | The name of the street on which the alleged violation occurred |
| violationlocationfloor | text | The floor of the house, building or structure where the alleged violation occurrred |
| violationlocationcity | text | Name of the City, town or community where the alleged violation occurred |
| violationlocationzipcode | char(5) | The zip code of the address where the alleged violation occurred |
| violationlocationstatename | text | The State in which the alleged violation occurred |
| respondentaddressborough | text | The borough in which the respondent lives or is located |
| respondentaddresshouse | text | The house number of the address at which the respondent lives or is located |
| respondentaddressstreetname | text | The name of the street on which the respondent lives or is located |
| respondentaddresscity | text | The city in which the respondent lives or is located |
| respondentaddresszipcode | char(5) | The zip code of the address where the respondent lives or is located |
| respondentaddressstatename | text | The State in which the respondent lives or is located |
| hearingstatus | text | Hearing status |
| hearingresult | text | Outcome or result of the hearing |
| scheduledhearinglocation | text | The location or address at which the hearing will occur |
| hearingdate | date | The date on which the hearing will occur |
| hearingtime | time without time zone | The time at which the hearing will occur |
| decisionlocationborough | text | The borough in which the decision was rendered |
| decisiondate | date | The date on which the decision was rendered |
| totalviolationamount | numeric | The monetary amount associated with the violation |
| violationdetails | text | Violation details include: section/rule of law, OATH code, penalty amount and idenfifying information of the employee of the enforcement agency |
| datejudgmentdocketed | date | The date on which the judgment was docketed |
| respondentaddressorfacilitynumberforfdnyanddobtickets | text | The address of the respondent |
| penaltyimposed | numeric | The actual penalty the respondent is required to pay |
| paidamount | numeric | The total amount paid by the respondent |
| additionalpenaltiesorlatefees | numeric | Monetary penalties which are levied in addition to the original penalty amount and which may include a fee for payments made after the payment due date. |
| compliancestatus | text | Indicates whether the respondent has taken measures to address the summons |
| violationdescription | text | Premises where the violation allegedly occurred |
| charge1code | text | The OATH Code for the first charge noted |
| charge1codesection | text | The law or City regulations for the first charge noted |
| charge1codedescription | text | A short categorical description for the first charge noted |
| charge1infractionamount | numeric | The monetary amount associated with the first charge noted |
| charge2code | text | The OATH Code for the second charge noted |
| charge2codesection | text | The law or City regulations for the second charge noted |
| charge2codedescription | text | A short categorical description for the second charge noted |
| charge2infractionamount | numeric | The monetary amount associated with the second charge noted |
| charge3code | text | The OATH Code for the third charge noted |
| charge3codesection | text | The law or City regulations for the third charge noted |
| charge3codedescription | text | A short categorical description for the third charge noted |
| charge3infractionamount | numeric | The monetary amount associated with the third charge noted |
| charge4code | text | The OATH Code for the fourth charge noted |
| charge4codesection | text | The law or City regulations for the fourth charge noted |
| charge4codedescription | text | A short categorical description for the fourth charge noted |
| charge4infractionamount | numeric | The monetary amount associated with the fourth charge noted |
| charge5code | text | The OATH Code for the fifth charge noted |
| charge5codesection | text | The law or City regulations for the fifth charge noted |
| charge5codedescription | text | A short categorical description for the fifth charge noted |
| charge5infractionamount | numeric | The monetary amount associated with the fifth charge noted |
| charge6code | text | The OATH Code for the sixth charge noted |
| charge6codesection | text | The law or City regulations for the sixth charge noted |
| charge6codedescription | text | A short categorical description for the sixth charge noted |
| charge6infractionamount | numeric | The monetary amount associated with the sixth charge noted |
| charge7code | text | The OATH Code for the seventh charge noted |
| charge7codesection | text | The law or City regulations for the seventh charge noted |
| charge7codedescription | text | A short categorical description for the seventh charge noted |
| charge7infractionamount | numeric | The monetary amount associated with the seventh charge noted |
| charge8code | text | The OATH Code for the eighth charge noted |
| charge8codesection | text | The law or City regulations for the eighth charge noted |
| charge8codedescription | text | A short categorical description for the eighth charge noted |
| charge8infractionamount | numeric | The monetary amount associated with the eighth charge noted |
| charge9code | text | The OATH Code for the ninth charge noted |
| charge9codesection | text | The law or City regulations for the ninth charge noted |
| charge9codedescription | text | A short categorical description for the ninth charge noted |
| charge9infractionamount | numeric | The monetary amount associated with the ninth charge noted |
| charge10code | text | The OATH Code for the tenth charge noted |
| charge10codesection | text | The law or City regulations for the tenth charge noted |
| charge10codedescription | text | A short categorical description for the tenth charge noted |
| charge10infractionamount | numeric | The monetary amount associated with the tenth charge noted |
| bbl | char(10) | A combination of three numeric codes--a 1-digit borough number, a block number (up to 5 digits) and a lot number (up to 4 digits)--designated and modified by the Department of Finance (DOF). BBLs are used by various city agencies to identify real estate for taxes, zoning, construction, and other purposes |
This dataset has the following tables:
-
oath_hearingsis the only table in this dataset.
Following are some useful SQL queries related to the dataset.