About this Dataset

DOF Scofftow Case Information

ScoffTow Case Information

Why is this data collected? - To keep track of vehicles that have been booted or towed due to non-payment of judgment debt. How is this data collected? - DOF received notification whenever a vehicle is Booted or towed by the Sheriff's Department or the Marshal's Office. What does each record represent? - Each row represents a single ScoffTow case. How can this data be used? - To view salient information pertaining to each scfftow case. What are the idiosyncrasies or limitations of the data to be aware of? - Information is only accurate up to the time of collection.
Organization: City of New York
Last updated: 2020-11-10T17:04:48.274417
Tags: case-number-primary-key, plate-state-type, scofftow, towing

Tables

Table 1

@usgov.city_of_new_york_dof_scofftow_case_information.table_1

34.83 MB
1,256,622 rows
16 columns

CREATE TABLE table_1 (
  "case_number" BIGINT,
  "case_status" VARCHAR,
  "license_plate_number" VARCHAR,
  "license_plate_issuing_state" VARCHAR,
  "license_plate_type" VARCHAR,
  "judgment_amount" DOUBLE,
  "boot_date" TIMESTAMP,
  "tow_y_n" VARCHAR  -- Tow (Y/N),
  "tow_date" TIMESTAMP,
  "redeemed_y_n" VARCHAR  -- Redeemed (Y/N),
  "redemption_date" TIMESTAMP,
  "total_amount_owed" DOUBLE,
  "total_amount_collected" DOUBLE,
  "auctioned_y_n" VARCHAR  -- Auctioned (Y/N),
  "auction_date" TIMESTAMP,
  "auction_amount" DOUBLE
);