Shovels

Data Dictionary

Complete field definitions for Shovels datasets including permits, contractors, residents, decisions, and enhanced property data.

Field Description Type Availability Source
ADDITIONTRUE if the permit adds new square feetBooleanEDLCreated by Shovels
ADDRESS_IDThe Shovels geo_ID of the addressStringBOTHCreated by Shovels
ADUTRUE if the permit is a secondary unit, cottage, in-law suite, or accessory dwelling unitBooleanEDLCreated by Shovels
APNParcel numberStringEDLEnhanced by Shovels
APPLICANT_CITYContact info for the applicantStringEDLProvided by jurisdiction
APPLICANT_EMAILContact info for the applicantStringEDLProvided by jurisdiction
APPLICANT_NAMEContact info for the applicantStringEDLProvided by jurisdiction
APPLICANT_PHONEContact info for the applicantStringEDLProvided by jurisdiction
APPLICANT_STATEContact info for the applicantStringEDLProvided by jurisdiction
APPLICANT_STREETContact info for the applicantStringEDLProvided by jurisdiction
APPLICANT_ZIPCODEContact info for the applicantStringEDLProvided by jurisdiction
APPROVAL_DURATIONThe number of days between the file date and the issue dateIntegerBOTHCreated by Shovels
BATHROOMTRUE if the permit involved a bathroomBooleanEDLCreated by Shovels
BATTERYTRUE if the permit involved a batteryBooleanEDLCreated by Shovels
CBSAThe CBSA value (also known as MSA)StringEDLEnhanced by Shovels
CBSA_FIPSThe CBSA FIPS codeStringEDLEnhanced by Shovels
CITYThe city nameStringBOTHEnhanced by Shovels
CITY_IDThe geo_ID of the cityStringBOTHCreated by Shovels
CONSTRUCTION_DURATIONThe number of days between the issue date and the final dateIntegerBOTHCreated by Shovels
CONTRACTOR_GROUP_IDThe higher level group ID of the contractorStringEDLCreated by Shovels
CONTRACTOR_IDThe Shovels ID of the individual contractorStringBOTHCreated by Shovels
COUNTYThe county nameStringBOTHEnhanced by Shovels
COUNTY_FIPSThe county FIPS codeStringEDLEnhanced by Shovels
COUNTY_IDThe geo_ID of the countyStringBOTHCreated by Shovels
DEMOLITIONTRUE if the permit involved any demolitionBooleanEDLCreated by Shovels
DESCRIPTIONThe long-form description of the permit according to the jurisdictionStringBOTHProvided by jurisdiction
ELECTRIC_METERTRUE if the permit involved an electrical meterBooleanEDLCreated by Shovels
ELECTRICALTRUE if any of the work on the permit was electricalBooleanEDLCreated by Shovels
END_DATEThe latest date on the permitDateBOTHCreated by Shovels
EV_CHARGERTRUE if the permit involved an EV chargerBooleanEDLCreated by Shovels
FEESThe permit fees collected by the jurisdictionIntegerBOTHProvided by jurisdiction
FILE_DATEThe date the permit application was filedDateBOTHEnhanced by Shovels
FINAL_DATEThe date the permit was completedDateBOTHEnhanced by Shovels
FIRE_SPRINKLERTRUE if the permit involved a fire sprinklerBooleanEDLCreated by Shovels
GASTRUE if the permit involved gasBooleanEDLCreated by Shovels
GENERATORTRUE if the permit involved a generatorBooleanEDLCreated by Shovels
GRADINGTRUE if the permit involved gradingBooleanEDLCreated by Shovels
HEAT_PUMPTRUE if the permit involved a mini-split, heat pump, or related technologyBooleanEDLCreated by Shovels
HVACTRUE if the permit involved heating, ventilation, or air conditioningBooleanEDLCreated by Shovels
IDThe Shovels ID of the permitStringBOTHCreated by Shovels
INSPECTION_PASS_RATEThe ratio of the passed inspections to the total inspections on the permitFloatBOTHCreated by Shovels
INSPECTION_PASSEDTRUE if any inspections passed on the permitBooleanEDLCreated by Shovels
ISSUE_DATEThe date the permit application was approvedDateBOTHEnhanced by Shovels
JOB_VALUEThe job value reported on the permitIntegerBOTHProvided by jurisdiction
JURISDICTIONThe name of the permit jurisdictionStringBOTHEnhanced by Shovels
JURISDICTION_IDThe geo_ID of the permit jurisdictionStringBOTHCreated by Shovels
KITCHENTRUE if the permit involved a kitchenBooleanEDLCreated by Shovels
LATThe latitude of the permit addressIntegerBOTHEnhanced by Shovels
LONGThe longitude of the permit addressIntegerBOTHEnhanced by Shovels
NEW_CONSTRUCTIONTRUE if the permit included any new constructionBooleanEDLCreated by Shovels
OWNER_CITYContact info for the owner according to the permitStringEDLProvided by jurisdiction
OWNER_EMAILContact info for the owner according to the permitStringEDLProvided by jurisdiction
OWNER_NAMEContact info for the owner according to the permitStringEDLProvided by jurisdiction
OWNER_PHONEContact info for the owner according to the permitStringEDLProvided by jurisdiction
OWNER_STATEContact info for the owner according to the permitStringEDLProvided by jurisdiction
OWNER_STREETContact info for the owner according to the permitStringEDLProvided by jurisdiction
OWNER_ZIPCODEContact info for the owner according to the permitStringEDLProvided by jurisdiction
PERMIT_NUMBERThe 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 permitsStringBOTHProvided by jurisdiction
PLUMBINGTRUE if the permit involved any type of plumbingBooleanEDLCreated by Shovels
POOL_AND_HOT_TUBTRUE if the permit involved a pool or hot tubBooleanEDLCreated by Shovels
PROPERTY_ASSESS_MARKET_VALUEThe market value of the propertyIntegerBOTHEnhanced by Shovels (third party)
PROPERTY_BUILDING_AREAThe total building area in square feetIntegerBOTHEnhanced by Shovels (third party)
PROPERTY_CENSUS_TRACTThe census tract numberStringBOTHEnhanced by Shovels (third party)
PROPERTY_CONGRESSIONAL_DISTRICTThe number of the congressional districtStringBOTHEnhanced by Shovels (third party)
PROPERTY_LEGAL_OWNERThe owner according to the tax assessorStringBOTHEnhanced by Shovels (third party)
PROPERTY_LOT_SIZEThe total lot size in square feetIntegerBOTHEnhanced by Shovels (third party)
PROPERTY_OWNER_TYPEThe type of entity the owner is according to the tax assessorStringBOTHEnhanced by Shovels (third party)
PROPERTY_STORY_COUNTThe number of stories on the propertyIntegerBOTHEnhanced by Shovels (third party)
PROPERTY_TYPEThe type of property according to the tax assessorStringBOTHEnhanced by Shovels (third party)
PROPERTY_TYPE_DETAILThe subtype of property according to the tax assessorStringBOTHEnhanced by Shovels (third party)
PROPERTY_UNIT_COUNTThe number of units on the propertyIntegerBOTHEnhanced by Shovels (third party)
PROPERTY_YEAR_BUILTThe year the property was constructedIntegerBOTHEnhanced by Shovels (third party)
REMODELTRUE if the permit involved a remodelBooleanEDLCreated by Shovels
ROOFINGTRUE if the permit involved roofingBooleanEDLCreated by Shovels
SOLARTRUE if the permit involved solarBooleanEDLCreated by Shovels
START_DATEThe earliest date on the permitDateBOTHCreated by Shovels
STATEThe two-character state abbreviationStringBOTHEnhanced by Shovels
STATE_FIPSThe state FIPS codeStringEDLEnhanced by Shovels
STATUSThe permit status (final, in_review, in_active, or active)StringBOTHEnhanced by Shovels
STREETThe street nameStringBOTHEnhanced by Shovels
STREET_NOThe street numberStringBOTHEnhanced by Shovels
SUBTYPEThe subtype of the permit according to the jurisdictionStringBOTHProvided by jurisdiction
TAGSList of permit categories (tags) associated with the permitArrayAPIEnhanced by Shovels
TOTAL_DURATIONThe number of days between the start date and the end dateIntegerBOTHCreated by Shovels
TYPEThe type of the permit according to the jurisdictionStringBOTHProvided by jurisdiction
WATER_HEATERTRUE if the permit involved a water heaterBooleanEDLCreated by Shovels
WINDOW_DOORTRUE if the permit involved windows or doorsBooleanEDLCreated by Shovels
ZIPCODEThe five-digit ZIP codeStringBOTHEnhanced by Shovels
ZIPCODE_EXTThe four-digit ZIP code extensionStringBOTHEnhanced by Shovels