Name: Shovels Data Dictionary
Creator: Shovels

Field	Description	Type	Source
ADDITION	TRUE if the permit adds new square feet	Boolean	Created by Shovels
ADDRESS_ID	The Shovels geo_ID of the address	String	Created by Shovels
ADU	TRUE if the permit is a secondary unit, cottage, in-law suite, or accessory dwelling unit	Boolean	Created by Shovels
APN	Parcel number	String	Enhanced by Shovels
APPLICANT_CITY	Contact info for the applicant	String	Provided by jurisdiction
APPLICANT_EMAIL	Contact info for the applicant	String	Provided by jurisdiction
APPLICANT_NAME	Contact info for the applicant	String	Provided by jurisdiction
APPLICANT_PHONE	Contact info for the applicant	String	Provided by jurisdiction
APPLICANT_STATE	Contact info for the applicant	String	Provided by jurisdiction
APPLICANT_STREET	Contact info for the applicant	String	Provided by jurisdiction
APPLICANT_ZIPCODE	Contact info for the applicant	String	Provided by jurisdiction
APPROVAL_DURATION	The number of days between the file date and the issue date	Integer	Created by Shovels
BATHROOM	TRUE if the permit involved a bathroom	Boolean	Created by Shovels
BATTERY	TRUE if the permit involved a battery	Boolean	Created by Shovels
CBSA	The CBSA value (also known as MSA)	String	Enhanced by Shovels
CBSA_FIPS	The CBSA FIPS code	String	Enhanced by Shovels
CITY	The city name	String	Enhanced by Shovels
CITY_ID	The geo_ID of the city	String	Created by Shovels
CONSTRUCTION_DURATION	The number of days between the issue date and the final date	Integer	Created by Shovels
CONTRACTOR_GROUP_ID	The higher level group ID of the contractor	String	Created by Shovels
CONTRACTOR_ID	The Shovels ID of the individual contractor	String	Created by Shovels
COUNTY	The county name	String	Enhanced by Shovels
COUNTY_FIPS	The county FIPS code	String	Enhanced by Shovels
COUNTY_ID	The geo_ID of the county	String	Created by Shovels
DEMOLITION	TRUE if the permit involved any demolition	Boolean	Created by Shovels
DESCRIPTION	The long-form description of the permit according to the jurisdiction	String	Provided by jurisdiction
DESCRIPTION_DERIVED	Plain-English summary of each permit's raw description	String	Created by Shovels
ELECTRIC_METER	TRUE if the permit involved an electrical meter	Boolean	Created by Shovels
ELECTRICAL	TRUE if any of the work on the permit was electrical	Boolean	Created by Shovels
END_DATE	The latest date on the permit	Date	Created by Shovels
EV_CHARGER	TRUE if the permit involved an EV charger	Boolean	Created by Shovels
FEES	The permit fees collected by the jurisdiction	Integer	Provided by jurisdiction
FILE_DATE	The date the permit application was filed	Date	Enhanced by Shovels
FINAL_DATE	The date the permit was completed	Date	Enhanced by Shovels
FIRE_SPRINKLER	TRUE if the permit involved a fire sprinkler	Boolean	Created by Shovels
GAS	TRUE if the permit involved gas	Boolean	Created by Shovels
GENERATOR	TRUE if the permit involved a generator	Boolean	Created by Shovels
GRADING	TRUE if the permit involved grading	Boolean	Created by Shovels
HEAT_PUMP	TRUE if the permit involved a mini-split, heat pump, or related technology	Boolean	Created by Shovels
HVAC	TRUE if the permit involved heating, ventilation, or air conditioning	Boolean	Created by Shovels
ID	The Shovels ID of the permit	String	Created by Shovels
INSPECTION_PASS_RATE	The ratio of the passed inspections to the total inspections on the permit	Float	Created by Shovels
INSPECTION_PASSED	TRUE if any inspections passed on the permit	Boolean	Created by Shovels
ISSUE_DATE	The date the permit application was approved	Date	Enhanced by Shovels
JOB_VALUE	The job value reported on the permit	Integer	Provided by jurisdiction
JURISDICTION	The name of the permit jurisdiction	String	Enhanced by Shovels
JURISDICTION_ID	The geo_ID of the permit jurisdiction	String	Created by Shovels
KITCHEN	TRUE if the permit involved a kitchen	Boolean	Created by Shovels
LAT	The latitude of the permit address	Integer	Enhanced by Shovels
LONG	The longitude of the permit address	Integer	Enhanced by Shovels
NEW_CONSTRUCTION	TRUE if the permit included any new construction	Boolean	Created by Shovels
OWNER_CITY	Contact info for the owner according to the permit	String	Provided by jurisdiction
OWNER_EMAIL	Contact info for the owner according to the permit	String	Provided by jurisdiction
OWNER_NAME	Contact info for the owner according to the permit	String	Provided by jurisdiction
OWNER_PHONE	Contact info for the owner according to the permit	String	Provided by jurisdiction
OWNER_STATE	Contact info for the owner according to the permit	String	Provided by jurisdiction
OWNER_STREET	Contact info for the owner according to the permit	String	Provided by jurisdiction
OWNER_ZIPCODE	Contact info for the owner according to the permit	String	Provided by jurisdiction
PERMIT_NUMBER	The jurisdiction permit number. Note, this is pass-through by the jurisdiction, so it is theoretically possible that one jurisdiction has the same permit number as another jurisdiction even if they are referencing different permits. We recommend using the Shovels ID to differentiate between unique permits	String	Provided by jurisdiction
PLUMBING	TRUE if the permit involved any type of plumbing	Boolean	Created by Shovels
POOL_AND_HOT_TUB	TRUE if the permit involved a pool or hot tub	Boolean	Created by Shovels
PROPERTY_ASSESS_MARKET_VALUE	The market value of the property	Integer	Enhanced by Shovels (third party)
PROPERTY_BUILDING_AREA	The total building area in square feet	Integer	Enhanced by Shovels (third party)
PROPERTY_CENSUS_TRACT	The census tract number	String	Enhanced by Shovels (third party)
PROPERTY_CONGRESSIONAL_DISTRICT	The number of the congressional district	String	Enhanced by Shovels (third party)
PROPERTY_LEGAL_OWNER	The owner according to the tax assessor	String	Enhanced by Shovels (third party)
PROPERTY_LOT_SIZE	The total lot size in square feet	Integer	Enhanced by Shovels (third party)
PROPERTY_OWNER_TYPE	The type of entity the owner is according to the tax assessor	String	Enhanced by Shovels (third party)
PROPERTY_STORY_COUNT	The number of stories on the property	Integer	Enhanced by Shovels (third party)
PROPERTY_TYPE	The type of property according to the tax assessor	String	Enhanced by Shovels (third party)
PROPERTY_TYPE_DETAIL	The subtype of property according to the tax assessor	String	Enhanced by Shovels (third party)
PROPERTY_UNIT_COUNT	The number of units on the property	Integer	Enhanced by Shovels (third party)
PROPERTY_YEAR_BUILT	The year the property was constructed	Integer	Enhanced by Shovels (third party)
REMODEL	TRUE if the permit involved a remodel	Boolean	Created by Shovels
ROOFING	TRUE if the permit involved roofing	Boolean	Created by Shovels
SOLAR	TRUE if the permit involved solar	Boolean	Created by Shovels
START_DATE	The earliest date on the permit	Date	Created by Shovels
STATE	The two-character state abbreviation	String	Enhanced by Shovels
STATE_FIPS	The state FIPS code	String	Enhanced by Shovels
STATUS	The permit status (final, in_review, in_active, or active)	String	Enhanced by Shovels
STREET	The street name	String	Enhanced by Shovels
STREET_NO	The street number	String	Enhanced by Shovels
SUBTYPE	The subtype of the permit according to the jurisdiction	String	Provided by jurisdiction
TAGS	List of permit categories (tags) associated with the permit	Array	Enhanced by Shovels
TOTAL_DURATION	The number of days between the start date and the end date	Integer	Created by Shovels
TYPE	The type of the permit according to the jurisdiction	String	Provided by jurisdiction
WATER_HEATER	TRUE if the permit involved a water heater	Boolean	Created by Shovels
WINDOW_DOOR	TRUE if the permit involved windows or doors	Boolean	Created by Shovels
ZIPCODE	The five-digit ZIP code	String	Enhanced by Shovels
ZIPCODE_EXT	The four-digit ZIP code extension	String	Enhanced by Shovels

Category	Description
ADDITION	Increase in square footage of an existing property.
ADU	Construction of a secondary living unit on a residential property.
BATHROOM	Any work on bathroom facilities or utilities.
BATTERY	Battery systems related to sustainability projects.
DEMOLITION	Removal or destruction of an existing structure or part of a structure.
ELECTRIC_METER	Permit explicitly for new or replaced electric meter.
ELECTRICAL	Includes electrical work. Subtags: EV_CHARGER, SOLAR, BATTERY, ELECTRIC_METER
EV_CHARGER	Installation of an electric vehicle charging system.
FIRE_SPRINKLER	Installation, repair or maintenance of a fire sprinkler
GAS	Installation, repair, or maintenance of gas lines, meters, appliances, or gas-related systems.
GENERATOR	Installation or replacement of a generator.
GRADING	Construction work that includes leveling or reshaping terrain to prepare a site for building.
HEAT_PUMP	Installation or replacement of a heat pump system.
HVAC	Heating, ventilation, and air conditioning systems. Subtag: HEAT_PUMP
KITCHEN	Any work on kitchen facilities or utilities.
NEW_CONSTRUCTION	Building entirely new homes or buildings. Examples: new office building, new single-family dwelling (SFD), new warehouse construction.
PLUMBING	Plumbing work including installation, repair, or maintenance of piping, fixtures, and systems. Subtag: WATER_HEATER
POOL_AND_HOT_TUB	Construction, installation, or repair of swimming pools, hot tubs, or spas.
REMODEL	Improve property aesthetic or functionality but without structural changes or expansions
ROOFING	Installation, replacement, or repair of a roof.
SOLAR	Installation of solar photovoltaic or solar thermal systems.
WATER_HEATER	Installation or replacement of a water heater.

Field	Description	Type	Source
ADDRESS_ID	The Shovels geo_ID of the contractor address	String	Created by Shovels
AVG_CONSTRUCTION_DURATION	Average construction duration in days across all permits pulled by the contractor	Integer	Created by Shovels
AVG_INSPECTION_PASS_RATE	Average inspection pass rate across all permits pulled by the contractor	Integer	Created by Shovels
AVG_JOB_VALUE	Average job values from the permits pulled by the contractor	Integer	Enhanced by Shovels
BIZ_NAME	The business name of the contractor	String	Provided by jurisdiction
BIZ_NAME_2	The second part of the contractor business name as offered by some authorities	String	Provided by jurisdiction
BIZ_TYPE	The type of business: JointVenture, Corporation, Partnership, Limited Liability, Sole Owner	String	Enhanced by Shovels
CITY	The city of the contractor's address	String	Enhanced by Shovels
CLASSIFICATION	The type of licenses issued to the contractor	String	Enhanced by Shovels
CLASSIFICATION_DERIVED	Standardized classification derived from official classification, pipe-separated. The unique values are concrete_and_paving, demolition_and_excavation, electrical, fencing_and_glazing, framing_and_carpentry, general_building_contractor, general_engineering_contractor, hvac, landscaping_and_outdoor_work, other, plumbing, roofing, and specialty_trades.	String	Created by Shovels
COUNTY	The county of the contractor's address	String	Enhanced by Shovels
DBA	"Doing Business As" (DBA) name associated with a contractor or business as recorded on a permit	String	Enhanced by Shovels
EMAIL	Email addresses associated with a contractor. Emails are separated by commas and ordered by frequency.	String	Provided by jurisdiction
EMPLOYEE_COUNT	The employee range of the contractor as provided by public social media records: 1 to 10, 11 to 25, 26 to 50, 51 to 100, 101 to 250, 251 to 500, 501 to 1000, 1001 to 5000, 5001 to 10000, 10000+	String	Enhanced by Shovels
FIRST_SEEN_DATE	Date contractor first appeared in Shovels data	Date	Created by Shovels
GROUP_ID	Identifies that a contractor likely shares a common parent company	String	Enhanced by Shovels
ID	The unique persistent Shovels ID that joins to Permits on contractor_id	String	Created by Shovels
IS_REPRESENTATIVE	Represents the contractor group (GROUP_ID)	String	Created by Shovels
JURISDICTION	The jurisdiction of the contractor's address	String	Created by Shovels
LATLNG	The latitude and longitude of the contractor's address	String	Enhanced by Shovels
LICENSE	The ID of the license	String	Enhanced by Shovels
LICENSE_ACT_DATE	The date the license was activated	Date	Enhanced by Shovels
LICENSE_EXP_DATE	The expiration date of the license	Date	Enhanced by Shovels
LICENSE_INACT_DATE	The date the license was inactivated	Date	Enhanced by Shovels
LICENSE_ISSUE_DATE	The date the license was issued	Date	Enhanced by Shovels
LICENSE_ISSUE_STATE	The state that issued the license	String	Enhanced by Shovels
LINKEDIN_URL	Contractor business LinkedIn profile URL	String	Enhanced by Shovels
NAICS	The NAICS code	String	Enhanced by Shovels
NAME	The person name associated with the contractor business, if available	String	Provided by jurisdiction
PERMIT_COUNT	Number of permits pulled by the contractor	Integer	Enhanced by Shovels
PHONE	Phone numbers associated with a contractor. Numbers are separated by commas and ordered by frequency.	String	Provided by jurisdiction
PRIMARY_EMAIL	The most relevant email address of the contractor, based on the most recent permits (issued in the last year). If multiple such numbers exist, the one appearing most frequently is selected.	String	Enhanced by Shovels
PRIMARY_INDUSTRY	The industry of the contractor as provided by public social media records	String	Enhanced by Shovels
PRIMARY_PHONE	The most relevant phone number of the contractor, based on the most recent permits (issued in the last year). If multiple such numbers exist, the one appearing most frequently is selected.	String	Enhanced by Shovels
RATING	The 5-star rating on their Google Maps profile	Integer	Enhanced by Shovels
REVENUE	The revenue range of the contractor as provided by public social media records	String	Enhanced by Shovels
REVIEW_COUNT	The number of reviews on their Google Maps profile	Integer	Enhanced by Shovels
SIC	The SIC code	String	Enhanced by Shovels
STATE	The two-character state code of the contractor's address	String	Enhanced by Shovels
STATUS	Contractor's license status, derived from the official state license files. Possible values are active and inactive	String	Enhanced by Shovels
STATUS_DETAILED	This field provides a more specific view of a contractor's license status and is derived from the official state license data. It is only populated for contractors who hold a license; unlicensed contractors will have this field blank. Possible values are: active, inactive, active_conditional, expired, retired, suspended, revoked, pending.	String	Enhanced by Shovels
STATUS_TALLY	The summary of all status counts for contractors' work. Available statuses: active, final, unknown, inactive, in_review.	String	Provided by jurisdiction
STREET	The name of the street of the contractor's address	String	Enhanced by Shovels
STREET_NO	The number of the street of the contractor's address	String	Enhanced by Shovels
TAG_TALLY	The summary of all tag counts for contractors' work.	String	Created by Shovels
TOTAL_JOB_VALUE	Total job values across all the permits pulled by the contractor	Integer	Enhanced by Shovels
WEBSITE	The website domain for the contractor's business	String	Enhanced by Shovels
ZIPCODE	The zip code of the contractor's address	String	Enhanced by Shovels
ZIPCODE_EXT	The +4 of the zipcode	String	Enhanced by Shovels

Field	Description	Type	Source
NAME	Individual person name associated with the contractor license	String	Provided by state
BIZ_NAME	Primary business name of the contractor	String	Provided by state
BIZ_NAME_2	Secondary or alternate business name	String	Provided by state
DBA	Doing Business As name	String	Provided by state
BIZ_TYPE	Type of business entity	String	Provided by state
LICENSE	License number or identifier	String	Provided by state
CLASSIFICATION	Official license classification from issuing authority	String	Provided by state
CLASSIFICATION_DERIVED	Standardized classification derived from official classification, pipe-separated. The unique values are concrete_and_paving, demolition_and_excavation, electrical, fencing_and_glazing, framing_and_carpentry, general_building_contractor, general_engineering_contractor, hvac, landscaping_and_outdoor_work, other, plumbing, roofing, and specialty_trades.	String	Created by Shovels
STATUS	Current status of the license	String	Provided by state
STATUS_DETAILED	Detailed status information	String	Provided by state
LICENSE_ISSUE_DATE	Date when license was originally issued	Date	Provided by state
LICENSE_ACT_DATE	Date when license became active	Date	Provided by state
LICENSE_EXP_DATE	Date when license expires	Date	Provided by state
LICENSE_INACT_DATE	Date when license became inactive	Date	Provided by state
LICENSE_ISSUE_STATE	State that issued the license	String	Provided by state
STREET_NO	Street number of contractor address	String	Provided by state
STREET	Street name of contractor address	String	Provided by state
CITY	City of contractor address	String	Provided by state
COUNTY	County of contractor address	String	Provided by state
STATE	State of contractor address	String	Provided by state
ZIPCODE	ZIP code of contractor address	String	Provided by state
ZIPCODE_EXT	ZIP+4 extension	String	Provided by state
PHONE	Contractor phone number	String	Provided by state
EMAIL	Contractor email address	String	Provided by state

Field	Description	Type	Source
CONTRACTOR_ID	Unique Shovels ID for each contractor record	String	Created by Shovels
CONTRACTOR_GROUP_ID	Unique Shovels ID for related contractor records	String	Created by Shovels
PERSON_ID	Unique identifier for the individual	String	Created by Shovels
NAME	Full name of the employee/contractor	String	Enhanced by Shovels
STREET_NO	Street number of employee's/contractor's address	Integer	Enhanced by Shovels
STREET	Street name of employee's/contractor's address	String	Enhanced by Shovels
CITY	City of residence	String	Enhanced by Shovels
ZIPCODE	Primary ZIP code (5-digit)	Integer	Enhanced by Shovels
ZIPCODE_EXT	ZIP code extension (4-digit)	Integer	Enhanced by Shovels
STATE	State of residence	String	Enhanced by Shovels
PHONE	Contact phone number from B2B data provider	String	Enhanced by Shovels (third party)
EMAIL	Primary email address	String	Enhanced by Shovels (third party)
EMAIL_VALIDATION_STATUS	Status indicating if the email has been validated	String	Enhanced by Shovels (third party)
EMAIL_LAST_SEEN	Most recent date the email was confirmed active	Date	Enhanced by Shovels (third party)
BUSINESS_EMAIL	Professional email address	String	Enhanced by Shovels (third party)
BUSINESS_EMAIL_VALIDATION_STATUS	Status indicating if the business email has been validated	String	Enhanced by Shovels (third party)
BUSINESS_EMAIL_LAST_SEEN	Most recent date the business email was confirmed active	Date	Enhanced by Shovels (third party)
LINKEDIN_URL	URL to individual's LinkedIn profile	String	Enhanced by Shovels (third party)
HOMEOWNER	Indicates whether the person owns their home. Homeownership is marked as Y (Yes), N (No), or P (Pending).	String	Enhanced by Shovels (third party)
GENDER	Gender of the individual. Gender is recorded as F (Female), M (Male), or U (Unspecified)	String	Enhanced by Shovels (third party)
AGE_RANGE	Age bracket of the individual. The age ranges are 18-24, 25-34, 35-44, 45-54, 55-64, and 65 and older.	String	Enhanced by Shovels (third party)
IS_MARRIED	Marital status indicator. This is a boolean field indicating either true (married) or false (not married).	Boolean	Enhanced by Shovels (third party)
HAS_CHILDREN	Indicates presence of children. This field is a boolean indicating either true (has children) or false (no children).	Boolean	Enhanced by Shovels (third party)
INCOME_RANGE	Annual income bracket. Income ranges from less than $20,000 to $250,000+, with nine distinct brackets.	String	Enhanced by Shovels (third party)
NET_WORTH	Estimated net worth range. Net worth ranges from negative (-$20,000) to more than $1,000,000, with thirteen distinct brackets.	String	Enhanced by Shovels (third party)
JOB_TITLE	Current professional position	String	Enhanced by Shovels (third party)
SENIORITY_LEVEL	Level of seniority in current position. Seniority levels are Staff, Manager, Director, VP, and CXO.	String	Enhanced by Shovels (third party)
DEPARTMENT	Department or division of employment. Departments include Executive, Operations, IT, Sales, Education, Finance, Health Services, Community Services, Engineering, HR, Marketing, Real Estate, Media, Legal, Administrative, Government, Product Management, and Military Services.	String	Enhanced by Shovels (third party)
JOB_TITLE_LAST_UPDATED	Date when job information was last updated	Date	Enhanced by Shovels (third party)
WORK_HISTORY	Employment history details	String	Enhanced by Shovels (third party)
EDUCATION_HISTORY	Educational background information	String	Enhanced by Shovels (third party)

Field	Description	Type	Source
TITLE	Legislative heading with full decision description	String	Created by Shovels
DECISION_DATE	Decision date in YYYY-MM-DD format	Date	Created by Shovels
STREET	Primary street address	String	Enhanced by Shovels
STREET_2	Secondary street address	String	Enhanced by Shovels
CITY	City name	String	Enhanced by Shovels
STATE	State abbreviation (2 letters)	String	Enhanced by Shovels
LATITUDE	Geocoded latitude	Float	Enhanced by Shovels
LONGITUDE	Geocoded longitude	Float	Enhanced by Shovels
ASSET_CLASS	Property classification: Mixed-Use, Multifamily, Specialized Housing, Detached Housing, Commercial, or Land	Enum	Created by Shovels
PROPERTY_TYPE	Specific property type within the asset_class	String	Created by Shovels
CATEGORY	Decision category: Affordable Housing, Annexation, Area Rezoning, City Properties, Contract, Economic Development Incentives, Final Plat, Infrastructure Development, Land Use Planning, Project Amendment, Spot Rezoning, or Zoning Code Modification	Enum	Created by Shovels
SUBCATEGORY	More specific category breakdown	String	Created by Shovels
SUBCATEGORY_TYPE	Sub-classification within subcategory	String	Created by Shovels
DESCRIPTION	Summary of the decision (15 sentences or fewer)	String	Created by Shovels
SOURCE_URL	Full URL to source decision page	String	Created by Shovels
EFFECTIVE_DATE	Date the decision takes effect in YYYY-MM-DD format	Date	Created by Shovels
CASE_NUMBER	Municipal case or file number	String	Created by Shovels
PROJECT_NAME	Project identifier or name	String	Created by Shovels
JURISDICTION	Governing jurisdiction	String	Created by Shovels
ZONING_NEW	New zoning designation after decision	String	Enhanced by Shovels
ZONING_NEW_DESCRIPTION	Description of new zoning designation	String	Enhanced by Shovels
ZONING_PREVIOUS	Previous zoning designation before decision	String	Enhanced by Shovels
OWNER_NAME	Property owner organization name	String	Enhanced by Shovels
OWNER_PERSON	Property owner individual name	String	Enhanced by Shovels
OWNER_EMAIL	Property owner email address	String	Enhanced by Shovels
OWNER_WEBSITE	Property owner website URL	String	Enhanced by Shovels
OWNER_LINKEDIN_URL	Property owner LinkedIn URL	String	Enhanced by Shovels
OWNER_PICTURE	Property owner picture URL	String	Enhanced by Shovels
ARCHITECT_NAME	Architecture firm name	String	Enhanced by Shovels
ARCHITECT_PERSON	Architect individual name	String	Enhanced by Shovels
ARCHITECT_LINKEDIN_URL	Architect LinkedIn URL	String	Enhanced by Shovels
ARCHITECT_EMAIL	Architect email address	String	Enhanced by Shovels
APPLICANT_NAME	Applicant organization name	String	Enhanced by Shovels
APPLICANT_COMPANY	Applicant company name	String	Enhanced by Shovels
APPLICANT_PERSON	Applicant individual name	String	Enhanced by Shovels
APPLICANT_LINKEDIN_URL	Applicant LinkedIn URL	String	Enhanced by Shovels
APPLICANT_PICTURE	Applicant picture URL	String	Enhanced by Shovels
DEVELOPER_NAME	Developer organization name	String	Enhanced by Shovels
DEVELOPER_PERSON	Developer individual name	String	Enhanced by Shovels
DEVELOPER_LINKEDIN_URL	Developer LinkedIn URL	String	Enhanced by Shovels
DEVELOPER_PICTURE	Developer person picture URL	String	Enhanced by Shovels
DEVELOPER_WEBSITE	Developer website URL	String	Enhanced by Shovels
REPRESENTATIVE_NAME	Legal or project representative name	String	Enhanced by Shovels
REPRESENTATIVE_LINKEDIN_URL	Representative LinkedIn URL	String	Enhanced by Shovels
REPRESENTATIVE_EMAIL	Representative email address	String	Enhanced by Shovels
REPRESENTATIVE_PICTURE	Representative picture URL	String	Enhanced by Shovels
ENGINEER_NAME	Engineering firm name	String	Enhanced by Shovels
ENGINEER_PERSON	Engineer individual name	String	Enhanced by Shovels
CONSTRUCTION_NAME	Construction company name	String	Enhanced by Shovels
CONSTRUCTION_WEBSITE	Construction company website URL	String	Enhanced by Shovels
CONSTRUCTION_IMAGE	Construction company image URL	String	Enhanced by Shovels
BUILDING_AREA	Project square footage	Integer	Created by Shovels
LOT_SIZE	Project acreage	Float	Created by Shovels
UNIT_COUNT	Number of dwelling units	Integer	Created by Shovels
PROJECT_VALUE	Project cost or incentive amount in cents	Integer	Created by Shovels
WHY_IT_MATTERS	2-3 sentences explaining significance of the decision	String	Created by Shovels
CANNABIS_RELATED	Whether the decision involves cannabis-related business	Boolean	Created by Shovels
LIQUOR_RELATED	Whether the decision involves liquor-related business	Boolean	Created by Shovels
TAX_INCREMENT_FINANCING	Whether tax increment financing is involved	Boolean	Created by Shovels
TIF_TYPE	Type of TIF if applicable	String	Created by Shovels
TIF_AMOUNT	TIF amount if applicable	String	Created by Shovels
PLANNING_DEP	Whether this is a Planning Department decision	Boolean	Created by Shovels
CITY_COUNCIL	Whether this is a City Council decision	Boolean	Created by Shovels
ASSET_CLASS_CONFIDENCE	Confidence score for asset_class classification (0.0-1.0)	Float	Created by Shovels
PROPERTY_TYPE_CONFIDENCE	Confidence score for property_type classification (0.0-1.0)	Float	Created by Shovels
CATEGORY_CONFIDENCE	Confidence score for category classification (0.0-1.0)	Float	Created by Shovels
SUBCATEGORY_CONFIDENCE	Confidence score for subcategory classification (0.0-1.0)	Float	Created by Shovels
SUBCATEGORY_TYPE_CONFIDENCE	Confidence score for subcategory_type classification (0.0-1.0)	Float	Created by Shovels
NEWSWORTHINESS	Importance score for the decision (0.0-1.0)	Float	Created by Shovels
CONFIDENCE_REASONING	Explanation of confidence scores	String	Created by Shovels
DECISION_ID	Unique identifier assigned by the system	String	Created by Shovels
LOGPROB_SCORE	LLM token probability confidence metric	Float	Created by Shovels
LOGPROB_CATEGORY	Token-level confidence for category	Float	Created by Shovels
LOGPROB_SUBCATEGORY	Token-level confidence for subcategory	Float	Created by Shovels
LOGPROB_ASSET_CLASS	Token-level confidence for asset_class	Float	Created by Shovels
GEO_IDS	Shovels geographic identifiers	Dictionary	Created by Shovels
CONTRACTOR_ID	Shovels contractor identifier	String	Created by Shovels
PLACE_ID	Google Maps place ID for primary address	String	Enhanced by Shovels
PLACE_ID_2	Google Maps place ID for secondary address	String	Enhanced by Shovels

Field	Description	Type	Source
ID	Unique identifier for each resident record	String	Created by Shovels
COMPANY_ID	Unique identifier for the company associated with the resident	String	Created by Shovels
NAME	Full name of the resident	String	Enhanced by Shovels
STREET_NO	Street number of resident's address	Integer	Enhanced by Shovels
STREET	Street name of resident's address	String	Enhanced by Shovels
CITY	City of residence	String	Enhanced by Shovels
ZIPCODE	Primary ZIP code (5-digit)	Integer	Enhanced by Shovels
ZIPCODE_EXT	ZIP code extension (4-digit)	Integer	Enhanced by Shovels
STATE	State of residence	String	Enhanced by Shovels
PHONE	Resident's phone number	String	Enhanced by Shovels
PERSONAL_EMAILS	Personal email addresses of the resident	String	Enhanced by Shovels
PERSONAL_EMAILS_VALIDATION_STATUS	Validation status of personal email addresses	String	Enhanced by Shovels
PERSONAL_EMAILS_LAST_SEEN	Date when personal email was last confirmed active	Date	Enhanced by Shovels
BUSINESS_EMAIL	Professional email address of the resident	String	Enhanced by Shovels
BUSINESS_EMAIL_VALIDATION_STATUS	Validation status of business email address	String	Enhanced by Shovels
BUSINESS_EMAIL_LAST_SEEN	Date when business email was last confirmed active	Date	Enhanced by Shovels
LINKEDIN_URL	URL to resident's LinkedIn profile	String	Enhanced by Shovels
HOMEOWNER	Indicates whether the resident owns their home. Homeownership is marked as Y (Yes), N (No), or P (Probable).	String	Enhanced by Shovels
GENDER	Gender of the resident. Gender is recorded as F (Female), M (Male), or U (Unspecified).	String	Enhanced by Shovels
AGE_RANGE	Age bracket of the resident. The age ranges are 18-24, 25-34, 35-44, 45-54, 55-64, and 65 and older.	String	Enhanced by Shovels
IS_MARRIED	Marital status indicator. This is a boolean field indicating either true (married) or false (not married).	Boolean	Enhanced by Shovels
HAS_CHILDREN	Indicates presence of children. This field is a boolean indicating either true (has children) or false (no children).	Boolean	Enhanced by Shovels
INCOME_RANGE	Annual income bracket. Income ranges from less than $20,000 to $250,000+, with nine distinct brackets: Less than $20,000, $20,000 to $44,999, $45,000 to $59,999, $60,000 to $74,999, $75,000 to $99,999, $100,000 to $149,999, $150,000 to $199,999, $200,000 to $249,999, $250,000+.	String	Enhanced by Shovels
NET_WORTH	Estimated net worth range. Net worth ranges from negative (-$20,000) to more than $1,000,000, with thirteen distinct brackets.	String	Enhanced by Shovels
JOB_TITLE	Current professional position	String	Enhanced by Shovels
SENIORITY_LEVEL	Level of seniority in current position. Seniority levels are Staff, Manager, Director, VP, and CXO.	String	Enhanced by Shovels
DEPARTMENT	Department or division of employment. Departments include Executive, Operations, IT, Sales, Education, Finance, Health Services, Community Services, Engineering, HR, Marketing, Real Estate, Media, Legal, Administrative, Government, Product Management, and Military Services.	String	Enhanced by Shovels
JOB_TITLE_LAST_UPDATED	Date when job information was last updated	Date	Enhanced by Shovels
LAST_UPDATED	Most recent update timestamp for the entire record	Date	Enhanced by Shovels
WORK_HISTORY	Employment history details	String	Enhanced by Shovels
EDUCATION_HISTORY	Educational background information	String	Enhanced by Shovels
SOCIAL_CONNECTIONS	Number or details of professional network connections. Social connection ranges are 1-9, 10-99, 100-249, 250-499, and 500+.	String	Enhanced by Shovels
COMPANY_NAME	Name of employer organization	String	Enhanced by Shovels
COMPANY_DOMAIN	Website domain of the employer	String	Enhanced by Shovels
COMPANY_PHONE	Contact number for the employer	String	Enhanced by Shovels
COMPANY_SIC	Standard Industrial Classification code	String	Enhanced by Shovels
COMPANY_STREET_NO	Street number of company address	Integer	Enhanced by Shovels
COMPANY_STREET	Street name of company address	String	Enhanced by Shovels
COMPANY_CITY	City where company is located	String	Enhanced by Shovels
COMPANY_ZIP	ZIP code of company location	Integer	Enhanced by Shovels
COMPANY_STATE	State where company is located	String	Enhanced by Shovels
COMPANY_LINKEDIN_URL	URL to company's LinkedIn profile	String	Enhanced by Shovels
COMPANY_REVENUE	Revenue range or specific value for the company	String	Enhanced by Shovels
COMPANY_EMPLOYEE_COUNT	Number of employees at the company	String	Enhanced by Shovels
COMPANY_PRIMARY_INDUSTRY	Main industry sector of the company	String	Enhanced by Shovels
COMPANY_DESCRIPTION	Brief description of the company's activities	String	Enhanced by Shovels
COMPANY_NAICS	North American Industry Classification System code	String	Enhanced by Shovels
ADDRESS_ID	Unique Shovels GEO_ID for the residential address	String	Created by Shovels

Field	Description	Type	Source
address_city	The city (e.g. Chicago)	String	Enhanced by Shovels
address_cityaliases	The city aliases	Array	Enhanced by Shovels
address_county	Property address County	String	Enhanced by Shovels
address_countyfipscode	The county FIPS code for the property address	String	Enhanced by Shovels
address_formattedstreet	The street address without the unit number or house number	String	Enhanced by Shovels
address_geostatus	The property's address geo status	String	Enhanced by Shovels
address_geostatuscode	The property's address geo status code	String	Enhanced by Shovels
address_hash	The property's address hash. Used to uniquely identify an address street, city, state and zip.	String	Created by Shovels
address_housenumber	House number of the property address.	String	Enhanced by Shovels
address_latitude	The property's latitude	Number	Enhanced by Shovels
address_localities	The property's localities (e.g. suburb, neighborhood, etc.).	Array	Enhanced by Shovels
address_longitude	The property's longitude	Number	Enhanced by Shovels
address_normalized	The property's normalized address	Boolean	Enhanced by Shovels
address_oldhashes	The property's address old hashes	Array	Enhanced by Shovels
address_state	Property address state (2 letter abbreviation)	String	Enhanced by Shovels
address_street	The street address (e.g. 123 Main Street)	String	Enhanced by Shovels
address_streetnounit	The street address without the unit number	String	Enhanced by Shovels
address_unitnumber	Unit number	String	Enhanced by Shovels
address_unittype	Unit type	String	Enhanced by Shovels
address_zip	Property address zip code.	String	Enhanced by Shovels
address_zipplus4	Property address zip+4 code	String	Enhanced by Shovels
assessment_assessedimprovementvalue	Assessed improvement value	Number	Enhanced by Shovels
assessment_assessedlandvalue	Assessed land value	Number	Enhanced by Shovels
assessment_assessmentyear	Assessment year	Number	Enhanced by Shovels
assessment_improvementmarketvalue	Market value improvement	Number	Enhanced by Shovels
assessment_landmarketvalue	Market value land	Number	Enhanced by Shovels
assessment_marketvalueyear	Market value year	Number	Enhanced by Shovels
assessment_totalassessedvalue	Total assessed value	Number	Enhanced by Shovels
assessment_totalmarketvalue	Total market value	Number	Enhanced by Shovels
building_airconditioningsource	Air Conditioning Source	String	Enhanced by Shovels
building_airconditioningsourcecode	Air Conditioning Source Code	String	Enhanced by Shovels
building_atticfinishedsquarefeet	Attic Finished Square Feet	Number	Enhanced by Shovels
building_atticsquarefeet	Attic Square Feet	Number	Enhanced by Shovels
building_atticunfinishedsquarefeet	Attic Unfinished Square Feet	Number	Enhanced by Shovels
building_basementfinishedsquarefeet	Basement Finished Square Feet	Number	Enhanced by Shovels
building_basementsquarefeet	Basement Square Feet	Number	Enhanced by Shovels
building_basementtype	Basement Type	String	Enhanced by Shovels
building_basementtypecode	Basement Type Code	String	Enhanced by Shovels
building_basementunfinishedsquarefeet	Basement Unfinished Square Feet	Number	Enhanced by Shovels
building_bathfixturecount	Bath Fixture Count	Number	Enhanced by Shovels
building_bathroomcount	Total Bathroom Count	Number	Enhanced by Shovels
building_bedroomcount	Bedroom Count	Number	Enhanced by Shovels
building_buildingclass	Building Class	String	Enhanced by Shovels
building_buildingclasscode	Building Class Code	String	Enhanced by Shovels
building_buildingcondition	Building Condition	String	Enhanced by Shovels
building_buildingconditioncode	Building Condition Code	String	Enhanced by Shovels
building_buildingcount	Building Count	Number	Enhanced by Shovels
building_buildingquality	Building Quality	String	Enhanced by Shovels
building_buildingqualitycode	Building Quality Code	String	Enhanced by Shovels
building_calculatedbathroomcount	Calculated Bathroom Count	Number	Enhanced by Shovels
building_constructiontype	Construction Type	String	Enhanced by Shovels
building_constructiontypecode	Construction Type Code	String	Enhanced by Shovels
building_driveway	Driveway	String	Enhanced by Shovels
building_drivewaycode	Driveway Code	String	Enhanced by Shovels
building_effectiveyearbuilt	Effective year built	Number	Enhanced by Shovels
building_exteriorwalls	Exterior Walls	String	Enhanced by Shovels
building_exteriorwallscode	Exterior Walls Code	String	Enhanced by Shovels
building_features	Features	Array	Enhanced by Shovels
building_fireplacecount	A count indicating the number of fireplaces	Number	Enhanced by Shovels
building_floorcover	Floor Cover	String	Enhanced by Shovels
building_floorcovercode	Floor Cover Code	String	Enhanced by Shovels
building_fullbathroomcount	Full Bathroom Count	Number	Enhanced by Shovels
building_garage	Garage	String	Enhanced by Shovels
building_garagecode	Garage Code	String	Enhanced by Shovels
building_garagefinishedsquarefeet	Garage Finished Square Feet	Number	Enhanced by Shovels
building_garageparkingspacecount	Garage Parking Space Count	Number	Enhanced by Shovels
building_garagesquarefeet	Garage Square Feet	Number	Enhanced by Shovels
building_garageunfinishedsquarefeet	Garage Unfinished Square Feet	Number	Enhanced by Shovels
building_groundfloorareasquarefeet	Ground Floor Area Square Feet	Number	Enhanced by Shovels
building_heatingfueltype	Heating Fuel Type	String	Enhanced by Shovels
building_heatingfueltypecode	Heating Fuel Type Code	String	Enhanced by Shovels
building_heatsource	Heat Source	String	Enhanced by Shovels
building_heatsourcecode	Heat Source Code	String	Enhanced by Shovels
building_interiorwalls	Interior Walls	String	Enhanced by Shovels
building_interiorwallscode	Interior Walls Code	String	Enhanced by Shovels
building_livingareasquarefeet	Living Area Square Feet	Number	Enhanced by Shovels
building_otherrooms	Other rooms	String	Enhanced by Shovels
building_otherroomscode	A code indicating other rooms (e.g. family room, den, mud room, etc.)	String	Enhanced by Shovels
building_partialbathroomcount	Partial Bathroom Count	Number	Enhanced by Shovels
building_patio	Patio	String	Enhanced by Shovels
building_patiocode	Patio Code	String	Enhanced by Shovels
building_pool	Pool	String	Enhanced by Shovels
building_poolcode	Pool Code	String	Enhanced by Shovels
building_porch	Porch	String	Enhanced by Shovels
building_porchcode	Porch Code	String	Enhanced by Shovels
building_residentialunitcount	Residential Unit Count	Number	Enhanced by Shovels
building_roofcover	Roof Cover	String	Enhanced by Shovels
building_roofcovercode	Roof Cover Code	String	Enhanced by Shovels
building_rooftype	Roof Type	String	Enhanced by Shovels
building_rooftypecode	Roof Type Code	String	Enhanced by Shovels
building_roomcount	Room Count	Number	Enhanced by Shovels
building_sewer	Sewer	String	Enhanced by Shovels
building_sewercode	Sewer Code	String	Enhanced by Shovels
building_storycode	Story Code	String	Enhanced by Shovels
building_storycount	Story Count	Number	Enhanced by Shovels
building_storycountdescription	Story Count Description	String	Enhanced by Shovels
building_style	Style	String	Enhanced by Shovels
building_stylecode	Style Code	String	Enhanced by Shovels
building_totalbuildingareacode	Total building Area Code	String	Enhanced by Shovels
building_totalbuildingareacodedescription	Total building Area Code Description	String	Enhanced by Shovels
building_totalbuildingareasquarefeet	Total building square footage	Number	Enhanced by Shovels
building_unitcount	Unit Count	Number	Enhanced by Shovels
building_waterservice	Water Service	String	Enhanced by Shovels
building_waterservicecode	Water Service Code	String	Enhanced by Shovels
building_yearbuilt	The year that the primary building was built	Number	Enhanced by Shovels
general_carrierroute	The property's mail carrier route	String	Enhanced by Shovels
general_censustract	The census tract	String	Enhanced by Shovels
general_congressionaldistrict	Congressional district	String	Enhanced by Shovels
general_daylightsavingstime	Day light savings time	Boolean	Enhanced by Shovels
general_mailingaddressvacant	Mailing address vacant	Boolean	Enhanced by Shovels
general_parcelcount	Parcel count	Number	Enhanced by Shovels
general_primaryparcel	Primary parcel	Boolean	Enhanced by Shovels
general_propertytypecategory	Property type category	String	Enhanced by Shovels
general_propertytypedetail	Property type detail	String	Enhanced by Shovels
general_standardizedlandusecode	Standardized land use code	String	Enhanced by Shovels
general_timezone	Time zone	String	Enhanced by Shovels
general_utcoffset	UTC offset	Number	Enhanced by Shovels
general_vacant	A flag indicating whether the property is vacant	Boolean	Enhanced by Shovels
ids_addresshash	The property's MD5 address hash	String	Created by Shovels
ids_apn	The assessor's parcel number	String	Enhanced by Shovels
ids_fipscode	The county FIPS code	String	Enhanced by Shovels
ids_oldapn	Old APN	String	Enhanced by Shovels
ids_oldapncodedescription	Old APN code description	String	Enhanced by Shovels
ids_taxid	The property's tax ID	String	Enhanced by Shovels
intel_lastsolddate	Property last sold date derived from the assessor and listing data	Date	Enhanced by Shovels
intel_lastsoldprice	Property last sold price derived from the assessor and listing data	Number	Enhanced by Shovels
intel_lengthofresidencemonths	The number of months the owner has lived at the property based on last sale date derived from the assessor and listing data	Number	Enhanced by Shovels
intel_lengthofresidenceyears	The number of years the owner has lived at the property based on last sale date derived from the assessor and listing data	Number	Enhanced by Shovels
legal_assessorsmapreference	The assessors map reference	String	Enhanced by Shovels
legal_block	The block of the subdivision or city in which the property is located	String	Enhanced by Shovels
legal_citytownshipmunicipality	The jurisdiction in which the property is located	String	Enhanced by Shovels
legal_district	The district in which the property is located	String	Enhanced by Shovels
legal_landlot	A large portion or tract of land in which the property is located	String	Enhanced by Shovels
legal_legaldescription	The legal description captured from the municipality assessor	String	Enhanced by Shovels
legal_legalunit	The subdivision unit number	String	Enhanced by Shovels
legal_lotcode	Identifies properties which include more than one lot or partial lots	String	Enhanced by Shovels
legal_lotnumber	The individual lot(s) which comprise the property	String	Enhanced by Shovels
legal_phasenumber	The phase of a subdivision or tract development	String	Enhanced by Shovels
legal_section	The section of the city in which the property is located	String	Enhanced by Shovels
legal_sectiontownshiprangemeridian	The section township range meridian	String	Enhanced by Shovels
legal_subdivisionname	The name of the subdivision or tract in which the property is located	String	Enhanced by Shovels
legal_tractnumber	The number of the tract in which the property is located	String	Enhanced by Shovels
lot_lotdepthfeet	The lot depth in feet	Number	Enhanced by Shovels
lot_lotfrontagefeet	The lot frontage in feet	Number	Enhanced by Shovels
lot_lotsizeacres	The lot size in acres	Number	Enhanced by Shovels
lot_lotsizesquarefeet	The lot size in square feet	Number	Enhanced by Shovels
lot_siteinfluence	The property lot site influence	String	Enhanced by Shovels
lot_siteinfluencecode	The property lot site influence code	String	Enhanced by Shovels
lot_topography	The property lot topography	String	Enhanced by Shovels
lot_topographycode	The property lot topography code	String	Enhanced by Shovels
lot_zoningcode	The property lot zonning code	String	Enhanced by Shovels
owner_fullname	The property owner name(s)	String	Enhanced by Shovels
owner_lengthofresidencemonths	The number of months the owner has lived at the property	Number	Enhanced by Shovels
owner_lengthofresidenceyears	The number of years the owner has lived at the property	Number	Enhanced by Shovels
owner_mailingaddress_city	The city (e.g. Chicago)	String	Enhanced by Shovels
owner_mailingaddress_county	The county (e.g. Cook)	String	Enhanced by Shovels
owner_mailingaddress_formattedstreet	The street address without the unit number or house number	String	Enhanced by Shovels
owner_mailingaddress_hash	The property address hash.	String	Created by Shovels
owner_mailingaddress_housenumber	The house number (e.g. 123)	String	Enhanced by Shovels
owner_mailingaddress_oldhashes	af	Array	Enhanced by Shovels
owner_mailingaddress_state	The state abbreviation (e.g. IL)	String	Enhanced by Shovels
owner_mailingaddress_street	The street address (e.g. 123 Main St Apt 45)	String	Enhanced by Shovels
owner_mailingaddress_streetnounit	The street address without the unit number	String	Enhanced by Shovels
owner_mailingaddress_unitnumber	The unit number of the response address	String	Enhanced by Shovels
owner_mailingaddress_unittype	The unit type of the response address	String	Enhanced by Shovels
owner_mailingaddress_zip	The zip code (e.g. 12345)	String	Enhanced by Shovels
owner_mailingaddress_zipplus4	The zip plus 4 code (e.g. 6789)	String	Enhanced by Shovels
owner_owneroccupied	A flag indicating that the property is occupied by the owner	Boolean	Enhanced by Shovels
owner_ownershiprights	The type of ownership	String	Enhanced by Shovels
owner_ownershiprightscode	The type of ownership	String	Enhanced by Shovels
owner_ownershipstartdate	The date the property owners took ownership	String	Enhanced by Shovels
owner_ownerstatustype	The owner status type	String	Enhanced by Shovels
sale_fliplength	Details about the property's flip length	Number	Enhanced by Shovels
sale_fliplengthcategory	Details about the property's flip length category	Number	Enhanced by Shovels
sale_flipprofit	Details about the property's flip profit	Number	Enhanced by Shovels
sale_lastsale_booknumber	The recorder's book number	String	Enhanced by Shovels
sale_lastsale_documentnumber	The recorder's document number	String	Enhanced by Shovels
sale_lastsale_documenttype	The type of document used to record the sale or transfer of the property	String	Enhanced by Shovels
sale_lastsale_pagenumber	The recorder's page number	String	Enhanced by Shovels
sale_lastsale_price	The transfer price	Number	Enhanced by Shovels
sale_lastsale_pricecode	A code indicating the type of sale price	String	Enhanced by Shovels
sale_lastsale_pricecodedescription	The type of sale price	String	Enhanced by Shovels
sale_lastsale_pricepersquarefoot	The price per square foot value	Number	Enhanced by Shovels
sale_lastsale_recordingdate	The date the transfer was recorded by the county	String	Enhanced by Shovels
sale_lastsale_salebuyers	The names of the buyers	Array	Enhanced by Shovels
sale_lastsale_saledate	The sale date	String	Enhanced by Shovels
sale_lastsale_salepriceisestimated	A flag indicating boolean value if the sale price is estimated.	Boolean	Enhanced by Shovels
sale_lastsale_salesellers	The names of the sellers	Array	Enhanced by Shovels
sale_lasttransfer_booknumber	The recorder's book number	String	Enhanced by Shovels
sale_lasttransfer_documentnumber	The recorder's document number	String	Enhanced by Shovels
sale_lasttransfer_documenttype	The type of document used to record the sale or transfer of the property	String	Enhanced by Shovels
sale_lasttransfer_pagenumber	The recorder's page number	String	Enhanced by Shovels
sale_lasttransfer_price	The transfer price	Number	Enhanced by Shovels
sale_lasttransfer_pricecode	A code indicating the type of sale price	String	Enhanced by Shovels
sale_lasttransfer_pricecodedescription	The type of sale price	String	Enhanced by Shovels
sale_lasttransfer_pricepersquarefoot	The price per square foot value	Number	Enhanced by Shovels
sale_lasttransfer_recordingdate	The date the transfer was recorded by the county	String	Enhanced by Shovels
sale_lasttransfer_saledate	The sale date	String	Enhanced by Shovels
sale_lasttransfer_salepriceisestimated	A flag indicating boolean value if the sale price is estimated.	Boolean	Enhanced by Shovels
sale_priorsale_booknumber	The recorder's book number	String	Enhanced by Shovels
sale_priorsale_documentnumber	The recorder's document number	String	Enhanced by Shovels
sale_priorsale_documenttype	The type of document used to record the sale or transfer of the property	String	Enhanced by Shovels
sale_priorsale_pagenumber	The recorder's page number	String	Enhanced by Shovels
sale_priorsale_price	The transfer price	Number	Enhanced by Shovels
sale_priorsale_pricecode	A code indicating the type of sale price	String	Enhanced by Shovels
sale_priorsale_pricecodedescription	The type of sale price	String	Enhanced by Shovels
sale_priorsale_pricepersquarefoot	The price per square foot value	Number	Enhanced by Shovels
sale_priorsale_recordingdate	The date the transfer was recorded by the county	String	Enhanced by Shovels
sale_priorsale_salebuyers	The names of the buyers	Array	Enhanced by Shovels
sale_priorsale_saledate	The sale date	String	Enhanced by Shovels
sale_priorsale_salepriceisestimated	A flag indicating boolean value if the sale price is estimated.	Boolean	Enhanced by Shovels
sale_priorsale_salesellers	The names of the sellers	Array	Enhanced by Shovels
sale_priortransfer_booknumber	The recorder's book number	String	Enhanced by Shovels
sale_priortransfer_documentnumber	The recorder's document number	String	Enhanced by Shovels
sale_priortransfer_documenttype	The type of document used to record the sale or transfer of the property	String	Enhanced by Shovels
sale_priortransfer_pagenumber	The recorder's page number	String	Enhanced by Shovels
sale_priortransfer_price	The transfer price	Number	Enhanced by Shovels
sale_priortransfer_pricecode	A code indicating the type of sale price	String	Enhanced by Shovels
sale_priortransfer_pricecodedescription	The type of sale price	String	Enhanced by Shovels
sale_priortransfer_pricepersquarefoot	The price per square foot value	Number	Enhanced by Shovels
sale_priortransfer_salepriceisestimated	A flag indicating boolean value if the sale price is estimated.	Boolean	Enhanced by Shovels
tax_schooltaxdistrictcodes	School tax districts	String	Enhanced by Shovels
tax_taxamount	Tax amount	Number	Enhanced by Shovels
tax_taxdelinquentyear	Tax delinquent year	Number	Enhanced by Shovels
tax_taxexemptions	Tax exemption codes	String	Enhanced by Shovels
tax_taxratecodearea	Tax rate code area	String	Enhanced by Shovels
tax_taxyear	Tax year	Number	Enhanced by Shovels