Scott Randolph, Orange County Tax Collector

200 S. Orange Ave.

SunTrustTower Bldg., Suite 1500

Orlando, FL32801

DELINQUENT REAL ESTATE TAX DATA

Data must be imported into a database to be easily readable. The file is too large to be imported into most spreadsheets, including EXCEL.

File is updated once a week for payments made the preceding Friday.

Comma Delimited:Variable record length

Format:ASCII

Field Number/Description / *Data Type / Format/Notes
  1. Certificate Year
/ Integer / YYYY
  1. Certificate Number
/ Alpha / 7 digits
  1. Certificate Sequence
/ Integer / 1 digit
  1. Parcel Number
/ Alpha / 15 digits
  1. Tax Deed Year
/ Integer / YYYY
  1. Tax Deed Number
/ Alpha / 7 digits
  1. Tax Deed Sequence
/ Integer / 1 digit
  1. Tax Deed Status
/ Alpha
  1. Tax Year
/ Integer / YYYY
  1. Status Code
/ Alpha
  1. Mill Code
/ Integer
  1. City Code
/ Alpha
  1. Installment Code
/ Alpha / “Y” = Installment Account
  1. Gross Taxes
/ Money
  1. Certificate Face Value
/ Money
  1. Total Value
/ Money
  1. Exempt Value
/ Money
  1. Taxable Value
/ Money
  1. Owner Name 1
/ Alpha
  1. Owner Name 2
/ Alpha
  1. Owner Name 3
/ Alpha
  1. Owner Name 4
/ Alpha
  1. Owner Name 5
/ Alpha
  1. Owner Address1
/ Alpha
  1. Owner Address2
/ Alpha
  1. Owner Address3
/ Alpha
  1. Owner Address4
/ Alpha
  1. Owner Address5
/ Alpha
  1. Legal Description
/ Alpha
  1. Payoff Date
/ Date / MM/DD/YYYY
  1. Payoff Amount Due
/ Money
  1. Payoff Interest
/ Money
  1. Payoff Amount Due Next Month
/ Money
  1. Payoff Interest Next Month
/ Money
  1. Payoff Interest Percentage
/ Money
  1. Payment Date
/ Date / MM/DD/YYYY
  1. Payment Code
/ Alpha / “P” = Paid
“R” = Redeemed
“S” = Surrendered
“C” = Canceled
  1. Validation Number
/ Alpha
  1. Bidder Number
/ Integer
  1. Buyer Name1
/ Alpha
  1. Buyer Name2
/ Alpha
  1. Certificate Issue Date
/ Date / MM/DD/YYYY
  1. Certificate Purchase Date
/ Date / MM/DD/YYYY
  1. Tax Deed Application Date
/ Date / MM/DD/YYYY
  1. Tax Deed Redemption Date
/ Date / MM/DD/YYYY
  1. Property Use Code
/ Integer / As defined at
  1. Situs Street Number
/ Alpha / 5 digits
  1. Situs Street Direction
/ Alpha / 2 digits
  1. Situs Street Name
/ Alpha / 25 digits
  1. Situs Street Type
/ Alpha / 4 digits
  1. Situs Suite
/ Alpha / 7 digits
  1. Situs Citiy
/ Alpha / 50 digits
  1. Situs Zip Code
/ Alpha / 16digits

*Data Types:

  • Integer:(whole number) data from -2^31 (-2,147,483,648) through 2^31 - 1 (2,147,483,647).
  • Money: monetary data values from -2^63 (-922,337,203,685,477.5808) through 2^63 - 1 (+922,337,203,685,477.5807). A decimal point and 2 significant digits are displayed.
  • Alpha: variable-length non-Unicode (ASCII) data with a maximum of 8,000 characters.
  • Date: date and time data from January 1, 1753, through December 31, 9999.

Current as of 02/15/2011