Socrata

Close
Author
IET Team
Description
Blight Violation Notices (BVN), or Blight Tickets, that have been issued to property owners who have violated City of Detroit ordinances that govern how property owners must maintain the exterior of their property. Blight Tickets are issued by city inspectors, police officers, neighborhood city hall managers and other city officials who investigate complaints of blight and are managed by the Department of Administrative Hearings.
Category
Property & Parcels
Tags
blight, violations, tickets
Rating
Current value: 0 out of 5
Data Provided By
Department of Administrative Hearings
License
Public Domain
This view cannot be displayed
This view is currently private. You can preview it, but you will need to make it public before people will be able to see it.
Size
  • 500x425

  • 760x646

  • 950x808

Custom Size

425x425 is the minimum size

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

Ticket ID
ticket_id
Ticket Number
ticket_number
Agency Name
agency_name
Inspector Name
inspector_name
Violator Name
violator_name
Violator ID
violator_id
Violation Street Number
violation_street_number
Violation Street Name
violation_street_name
Violation Zip Code
violation_zip_code
Mailing Address Street Number
mailing_address_str_number
Mailing Address Street Name
mailing_address_str_name
Mailing Address City
city
Mailing Address State
state
Mailing Address Zip Code
zip_code
Mailing Address Non-USA Code
non_us_str_code
Mailing Address Country
country
Violation Date
violation_date
Ticket Issued Time
ticket_issued_time
Hearing Date
hearing_date
Hearing Time
hearing_time
Violation Code
violation_code
Violation Description
violation_description
Disposition
disposition
Fine Amount
fine_amount
Admin Fee
admin_fee
State Fee
state_fee
Late Fee
late_fee
Discount Amount
discount_amount
Clean Up Cost
clean_up_cost
Judgment Amount (Total Due)
judgment_amount
Payment Amount (Sum of All Payments)
payment_amount
Balance Due
balance_due
Payment Date (Most Recent)
payment_date
Payment Status
payment_status
Collection Status
collection_status
Violation Address
violation_address
Violation Parcel ID
parcelno
Violation Latitude
latitude
Violation Longitude
longitude
Violation Location
location
Zip Codes
:@computed_region_y6sr_nt2p
Counties
:@computed_region_47m5_mdaf
Scout Car Areas
:@computed_region_5esb_gjfg
Detroit Neighborhoods
:@computed_region_d6uh_frh4
City Council Districts
:@computed_region_gscg_8e47
Hardest Hit Fund Areas
:@computed_region_rzav_7efk

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

OData V4 Endpoint:

OData V2 Endpoint:

You are viewing a mobile version of this dataset. To access the full dataset, tap here.