Complete field definitions for Shovels datasets including permits, contractors, residents, decisions, and property data.
| 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, in dollars | 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 |
| FIRST_SEEN_DATE | The date Shovels first saw the permit in the jurisdiction's portal | Date | 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 | Integer | 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, in dollars | 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, in dollars | Integer | Enhanced by Shovels |
| PROPERTY_BUILDING_AREA | The total building area in square feet | Integer | Enhanced by Shovels |
| PROPERTY_CENSUS_TRACT | The census tract number | String | Enhanced by Shovels |
| PROPERTY_CONGRESSIONAL_DISTRICT | The number of the congressional district | String | Enhanced by Shovels |
| PROPERTY_LEGAL_OWNER | The owner according to the tax assessor | String | Enhanced by Shovels |
| PROPERTY_LOT_SIZE | The total lot size in square feet | Integer | Enhanced by Shovels |
| PROPERTY_OWNER_TYPE | The type of entity the owner is according to the tax assessor | String | Enhanced by Shovels |
| PROPERTY_STORY_COUNT | The number of stories on the property | Integer | Enhanced by Shovels |
| PROPERTY_TYPE | The type of property according to the tax assessor | String | Enhanced by Shovels |
| PROPERTY_TYPE_DETAIL | The subtype of property according to the tax assessor | String | Enhanced by Shovels |
| PROPERTY_UNIT_COUNT | The number of units on the property | Integer | Enhanced by Shovels |
| PROPERTY_YEAR_BUILT | The year the property was constructed | Integer | Enhanced by Shovels |
| 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 |
| TELECOM | TRUE if the permit involved telecom work | Boolean | Created 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 |
| Field | Description | Type | Source |
|---|---|---|---|
| address.city | The city name | String | Enhanced by Shovels |
| address.county | The county name | String | Enhanced by Shovels |
| address.jurisdiction | The name of the permit jurisdiction | String | Enhanced by Shovels |
| address.latlng | The [latitude, longitude] coordinate pair of the permit address | Array | Enhanced by Shovels |
| address.state | The two-character state abbreviation | String | Enhanced by Shovels |
| address.street | The street name | String | Enhanced by Shovels |
| address.street_no | The street number | String | Enhanced by Shovels |
| address.zip_code | The five-digit ZIP code | String | Enhanced by Shovels |
| address.zip_code_ext | The four-digit ZIP code extension | String | Enhanced by Shovels |
| approval_duration | The number of days between the file date and the issue date | Integer | Created by Shovels |
| construction_duration | The number of days between the issue date and the final date | Integer | Created by Shovels |
| contractor_id | The Shovels ID of the individual contractor | String | Created by Shovels |
| description | The long-form description of the permit according to the jurisdiction | String | Provided by jurisdiction |
| end_date | The latest date on the permit | Date | Created by Shovels |
| fees | The permit fees collected by the jurisdiction, in cents (divide by 100 for dollars) | 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 |
| geo_ids.address_id | The Shovels geo_ID of the address | String | Created by Shovels |
| geo_ids.city_id | The geo_ID of the city | String | Created by Shovels |
| geo_ids.county_id | The geo_ID of the county | String | Created by Shovels |
| geo_ids.jurisdiction_id | The geo_ID of the permit jurisdiction | String | 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 | Integer | 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, in cents (divide by 100 for dollars) | Integer | Provided by jurisdiction |
| jurisdiction | The name of the permit jurisdiction | String | Enhanced by Shovels |
| 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 |
| property_assess_market_value | The market value of the property, in cents (divide by 100 for dollars) | Integer | Enhanced by Shovels |
| property_building_area | The total building area in square feet | Integer | Enhanced by Shovels |
| property_census_tract | The census tract number | String | Enhanced by Shovels |
| property_congressional_district | The number of the congressional district | String | Enhanced by Shovels |
| property_legal_owner | The owner according to the tax assessor | String | Enhanced by Shovels |
| property_lot_size | The total lot size in square feet | Integer | Enhanced by Shovels |
| property_owner_type | The type of entity the owner is according to the tax assessor | String | Enhanced by Shovels |
| property_story_count | The number of stories on the property | Integer | Enhanced by Shovels |
| property_type | The type of property according to the tax assessor | String | Enhanced by Shovels |
| property_type_detail | The subtype of property according to the tax assessor | String | Enhanced by Shovels |
| property_unit_count | The number of units on the property | Integer | Enhanced by Shovels |
| property_year_built | The year the property was constructed | Integer | Enhanced by Shovels |
| start_date | The earliest date on the permit | Date | Created by Shovels |
| status | The permit status (final, in_review, in_active, or active) | String | Enhanced by Shovels |
| subtype | The subtype of the permit according to the jurisdiction | String | Provided by jurisdiction |
| tags | Array of tags describing the work involved in the permit. Each value corresponds to a boolean field on the EDL Permits table: addition, adu, battery, demolition, electric_meter, electrical, ev_charger, fire_sprinkler, gas, generator, grading, heat_pump, hvac, kitchen, new_construction, plumbing, pool_and_hot_tub, remodel, roofing, solar, telecom, water_heater, window_door | Array | Created 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 |
| 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. |
| TELECOM | Telecom-related work including fiber, phone/cable drops, utility ROW installs, cell towers, small cells, 5G, antennas, cable installation, conduit, trenching, boring, and related infrastructure. |
| WATER_HEATER | Installation or replacement of a water heater. |
| Field | Description | Type | Source |
|---|---|---|---|
| ADDRESS_CITY | The city (e.g. Chicago) | String | Provided by jurisdiction |
| ADDRESS_CITYALIASES | The city aliases | Array | Enhanced by Shovels |
| ADDRESS_COUNTY | Property address County | String | Provided by jurisdiction |
| 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 | Provided by jurisdiction |
| 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 | Provided by jurisdiction |
| ADDRESS_ZIPPLUS4 | Property address zip+4 code | String | Provided by jurisdiction |
| 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 | Provided by jurisdiction |
| 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 | Provided by jurisdiction |
| 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 | Provided by jurisdiction |
| BUILDING_UNITCOUNT | Unit Count | Number | Provided by jurisdiction |
| 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 | Provided by jurisdiction |
| 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 | Provided by jurisdiction |
| 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 | Provided by jurisdiction |
| 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 | Provided by jurisdiction |
| 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 |
| Field | Description | Type | Source |
|---|---|---|---|
| apn | The assessor parcel number | String | Provided by jurisdiction |
| assess_market_value | The assessed market value of the property, in cents (divide by 100 for dollars) | Integer | Provided by jurisdiction |
| building_area | The total building area in square feet | Integer | Provided by jurisdiction |
| city | The city of the address | String | Provided by jurisdiction |
| city_id | The base64 geo handle of the city | String | Created by Shovels |
| contractor_count | The number of distinct contractors across the address's permits | Integer | Created by Shovels |
| county | The county of the address | String | Provided by jurisdiction |
| county_id | The base64 geo handle of the county | String | Created by Shovels |
| id | The base64 address handle, which is the property's public ID | String | Created by Shovels |
| last_date_by_pair | Map of tag:status pair to the latest permit start date | Dictionary | Created by Shovels |
| last_date_by_status | Map of status to the latest permit start date | Dictionary | Created by Shovels |
| last_date_by_tag | Map of tag to the latest permit start date | Dictionary | Created by Shovels |
| last_permit_date | The latest permit start date across all of the address's permits, or null when the address has never been permitted | Date | Created by Shovels |
| last_unfinaled_date_by_tag | Map of tag to the latest permit start date that has not reached a final status | Dictionary | Created by Shovels |
| lat | The latitude of the address | Number | Enhanced by Shovels |
| legal_owner | The owner according to the tax assessor | String | Provided by jurisdiction |
| long | The longitude of the address | Number | Enhanced by Shovels |
| lot_size | The total lot size in square feet | Integer | Provided by jurisdiction |
| next_cursor | The cursor for retrieving the next page of results | String | Created by Shovels |
| owner_type | The type of entity the owner is according to the tax assessor | String | Enhanced by Shovels |
| permit_count | The number of permits linked to the address | Integer | Created by Shovels |
| property_type | The type of property according to the tax assessor | String | Enhanced by Shovels |
| property_type_detail | The subtype of property according to the tax assessor | String | Enhanced by Shovels |
| size | The number of items returned in the response | Integer | Created by Shovels |
| state | The two-character state abbreviation of the address | String | Provided by jurisdiction |
| statuses | Array of the distinct permit statuses on the address's permits, including unknown for permits with no status | Array | Created by Shovels |
| story_count | The number of stories on the property | Integer | Provided by jurisdiction |
| street | The street name of the address | String | Enhanced by Shovels |
| street_no | The street number of the address | String | Enhanced by Shovels |
| tag_status_pairs | Array of the distinct tag:status pairs on the address's permits, with status folded to unknown when the permit has no status | Array | Created by Shovels |
| tag_tally | Map of tag to the number of permits carrying it | Dictionary | Created by Shovels |
| tags | Array of the distinct tags present on the address's permits | Array | Created by Shovels |
| total_count.relation | eq when the count is exact, gte when the true count exceeds the cap | Enum | Created by Shovels |
| total_count.value | The total result count, capped at 10,000. Returned on the first page when include_count is true, and null when the count query times out | Integer | Created by Shovels |
| total_job_value | The sum of the job values on the address's permits, in cents (divide by 100 for dollars) | Integer | Created by Shovels |
| trust.coverage_tier | The coverage bucket for the jurisdiction of the address (high, medium, or low, at 90% and 50% cutoffs) | Enum | Created by Shovels |
| trust.data_horizon | The most recent permit start date past which an absence claim is under-observed. Never null | Date | Created by Shovels |
| trust.flags | Array of honesty flags on the row, such as since_d_beyond_horizon or trust_row_missing | Array | Created by Shovels |
| trust.footprint_basis | Whether footprint suppression resolved the geo scope of the row (matched or unknown) | Enum | Created by Shovels |
| trust.horizon_basis | How data_horizon was estimated: from a measured cohort, a pooled fallback, or the state prior | Enum | Created by Shovels |
| trust.trust_jurisdiction_basis | Whether the trust join used the jurisdiction of the address (own), the dominant jurisdiction of its ZIP (dominant), or none (unknown) | Enum | Created by Shovels |
| trust.trust_jurisdiction_error_bar | The measured error rate of the trust jurisdiction: 0.0613 on a dominant basis, 0 on an own or unknown basis | Number | Created by Shovels |
| trust.unresolved_rate | The share of the jurisdiction's permits carrying the tag that never linked to an address | Number | Created by Shovels |
| trust_summary.expected_miss_rate | The estimated share of true matches missing from the response because of ingestion lag | Number | Created by Shovels |
| trust_summary.row_weighted_unresolved_rate | The row-weighted mean unresolved_rate across the page | Number | Created by Shovels |
| trust_summary.rows_flagged | The number of rows on the page carrying a trust flag | Integer | Created by Shovels |
| trust_summary.suppressed_scopes | The number of footprint scopes excluded from the response by suppression | Integer | Created by Shovels |
| unit_count | The number of units on the property | Integer | Provided by jurisdiction |
| untagged_permit_count | The number of the address's permits carrying no tag | Integer | Created by Shovels |
| year_built | The year the property was constructed | Integer | Provided by jurisdiction |
| zip_code | The five-digit ZIP code of the address | String | Provided by jurisdiction |
| zip_code_ext | The four-digit ZIP code extension of the address | String | Provided by jurisdiction |
| 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 |
| 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 |
| 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 |
| ZONING_NEW | New zoning designation after decision | String | Enhanced by Shovels |
| ZONING_PREVIOUS | Previous zoning designation before decision | String | Enhanced by Shovels |
| ALLOWED_USES | Number of land uses permitted under the new zoning designation. Not currently populated | Integer | Created by Shovels |
| OWNER_NAME | Property owner organization name | String | Enhanced by Shovels |
| APPLICANT_NAME | Applicant organization name | String | Enhanced by Shovels |
| DEVELOPER_NAME | Developer organization name | String | Enhanced by Shovels |
| REPRESENTATIVE_NAME | Legal or project representative name | String | Enhanced by Shovels |
| LOT_SIZE | Project acreage | Float | Created by Shovels |
| PROJECT_VALUE | Project cost or incentive amount in cents | Float | Created by Shovels |
| WHY_IT_MATTERS | 2-3 sentences explaining significance of the decision | String | Created by Shovels |
| ID | Unique identifier assigned by the system | String | Created by Shovels |
| GEO_ID_ADDRESS | The Shovels geo_ID of the decision's address, if matched | String | Created by Shovels |
| GEO_ID_CITY | The Shovels geo_ID of the city | String | Created by Shovels |
| GEO_ID_COUNTY | The Shovels geo_ID of the county | String | Created by Shovels |
| GEO_ID_JURISDICTION | The Shovels geo_ID of the jurisdiction | String | Created by Shovels |
| Field | Description | Type | Source |
|---|---|---|---|
| address_id | The Shovels geo_ID of the decision's address, if matched | String | Created by Shovels |
| allowed_uses | Number of land uses permitted under the new zoning designation. Not currently populated | Integer | Created by Shovels |
| applicant_name | Applicant organization name | String | Enhanced by Shovels |
| asset_class | Property classification: Mixed-Use, Multifamily, Specialized Housing, Detached Housing, Commercial, or Land | Enum | 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 |
| city | City name | String | Enhanced by Shovels |
| city_id | The Shovels geo_ID of the city | String | Created by Shovels |
| county_id | The Shovels geo_ID of the county | String | Created by Shovels |
| decision_date | Decision date in YYYY-MM-DD format | Date | Created by Shovels |
| description | Summary of the decision (15 sentences or fewer) | String | Created by Shovels |
| developer_name | Developer organization name | String | Enhanced by Shovels |
| id | Unique identifier assigned by the system | String | Created by Shovels |
| jurisdiction_id | The Shovels geo_ID of the jurisdiction | String | Created by Shovels |
| latitude | Geocoded latitude | Float | Enhanced by Shovels |
| longitude | Geocoded longitude | Float | Enhanced by Shovels |
| lot_size | Project acreage | Float | Created by Shovels |
| owner_name | Property owner organization name | String | Enhanced by Shovels |
| project_value | Project cost or incentive amount in cents | Float | Created by Shovels |
| property_type | Specific property type within the asset_class | String | Created by Shovels |
| representative_name | Legal or project representative name | String | Enhanced by Shovels |
| source_url | Full URL to source decision page | String | Created by Shovels |
| state | State abbreviation (2 letters) | String | Enhanced by Shovels |
| street | Primary street address | String | Enhanced by Shovels |
| subcategory | More specific category breakdown | String | Created by Shovels |
| title | Legislative heading with full decision description | String | Created by Shovels |
| why_it_matters | 2-3 sentences explaining significance of the decision | String | Created by Shovels |
| zoning_new | New zoning designation after decision | String | Enhanced by Shovels |
| zoning_previous | Previous zoning designation before decision | String | Enhanced by Shovels |
| Field | Description | Type | Source |
|---|---|---|---|
| ADDRESS_ID | The Shovels geo_ID of the contractor address | String | Created 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 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 |
| LAT | The latitude of the contractor's address | Float | 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 |
| LONG | The longitude of the contractor's address | Float | 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 |
| 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 | Float | 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 |
| 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 |
| 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 |
|---|---|---|---|
| address.city | The city of the contractor's address | String | Enhanced by Shovels |
| address.county | The county of the contractor's address | String | Enhanced by Shovels |
| address.jurisdiction | The jurisdiction of the contractor's address | String | Created by Shovels |
| address.latlng | The latitude and longitude of the contractor's address | Array | Enhanced by Shovels |
| address.state | The two-character state code of the contractor's address | String | Enhanced by Shovels |
| address.street | The name of the street of the contractor's address | String | Enhanced by Shovels |
| address.street_no | The number of the street of the contractor's address | String | Enhanced by Shovels |
| address.zip_code | The zip code of the contractor's address | String | Enhanced by Shovels |
| address.zip_code_ext | The +4 of the zipcode | String | Enhanced 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, in cents (divide by 100 for dollars) | Integer | Enhanced by Shovels |
| business_name | The business name of the contractor | String | Provided by jurisdiction |
| business_type | The type of business: JointVenture, Corporation, Partnership, Limited Liability, Sole Owner | 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 |
| dba | "Doing Business As" (DBA) name associated with a contractor or business as recorded on a permit | String | Enhanced by Shovels |
| 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 |
| id | The unique persistent Shovels ID that joins to Permits on contractor_id | String | Created 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 |
| 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 | Float | 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 |
| status_tally | The summary of all status counts for contractors' work, keyed by status (active, final, unknown, inactive, in_review) | Dictionary | Provided by jurisdiction |
| tag_tally | The summary of all tag counts for contractors' work, keyed by tag | Dictionary | Created by Shovels |
| total_job_value | Total job values across all the permits pulled by the contractor, in cents (divide by 100 for dollars) | Integer | Enhanced by Shovels |
| website | The website domain for the contractor's business | String | Enhanced by Shovels |
| Field | Description | Type | Source |
|---|---|---|---|
| NAME | Individual person name associated with the contractor license | String | Provided by state |
| business_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 |
| business_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 |
| 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 |
| Primary email address | String | Enhanced by Shovels | |
| EMAIL_VALIDATION_STATUS | Status indicating if the email has been validated | String | Enhanced by Shovels |
| EMAIL_LAST_SEEN | Most recent date the email was confirmed active | Date | Enhanced by Shovels |
| BUSINESS_EMAIL | Professional email address | String | Enhanced by Shovels |
| BUSINESS_EMAIL_VALIDATION_STATUS | Status indicating if the business email has been validated | String | Enhanced by Shovels |
| BUSINESS_EMAIL_LAST_SEEN | Most recent date the business email was confirmed active | Date | Enhanced by Shovels |
| LINKEDIN_URL | URL to individual's LinkedIn profile | String | Enhanced by Shovels |
| HOMEOWNER | Indicates whether the person owns their home. Homeownership is marked as Y (Yes), N (No), or P (Pending). | String | Enhanced by Shovels |
| GENDER | Gender of the individual. Gender is recorded as F (Female), M (Male), or U (Unspecified) | String | Enhanced by Shovels |
| 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 |
| 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. | 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 |
| WORK_HISTORY | Employment history details | String | Enhanced by Shovels |
| EDUCATION_HISTORY | Educational background information | String | Enhanced by Shovels |
| Field | Description | Type | Source |
|---|---|---|---|
| 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 |
| business_email | Professional email address | String | Enhanced by Shovels |
| city | City of residence | String | Enhanced by Shovels |
| contractor_id | The Shovels ID of the contractor the employee is associated with | String | Created 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 |
| Primary personal email address | String | Enhanced by Shovels | |
| gender | Gender of the individual. Gender is recorded as F (Female), M (Male), or U (Unspecified). | String | 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 |
| homeowner | Indicates whether the person owns their home. Homeownership is marked as Y (Yes), N (No), or P (Pending). | String | Enhanced by Shovels |
| id | Unique identifier for the individual | String | Created by Shovels |
| income_range | Annual income bracket of the individual | 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 |
| job_title | Current professional position | String | Enhanced by Shovels |
| linkedin_url | URL to individual's LinkedIn profile | String | Enhanced by Shovels |
| name | Full name of the employee | String | Enhanced by Shovels |
| net_worth | Estimated net worth range of the individual | String | Enhanced by Shovels |
| phone | Contact phone number from B2B data provider | String | Enhanced by Shovels |
| seniority_level | Level of seniority in current position | String | Enhanced by Shovels |
| state | State of residence | String | Enhanced by Shovels |
| street | Street name of the employee's address | String | Enhanced by Shovels |
| street_no | Street number of the employee's address | String | Enhanced by Shovels |
| zip_code | Primary ZIP code (5-digit) | String | Enhanced by Shovels |
| zip_code_ext | ZIP code extension (4-digit) | 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 |
| is_homeowner | Whether the resident is a homeowner | Boolean | 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 |
|---|---|---|---|
| city | City of residence | String | Enhanced by Shovels |
| income_range | Annual income bracket of the resident | String | Enhanced by Shovels |
| is_homeowner | Whether the resident is a homeowner | Boolean | Enhanced by Shovels |
| linkedin_url | URL to resident's LinkedIn profile | String | Enhanced by Shovels |
| name | Full name of the resident | String | Enhanced by Shovels |
| net_worth | Estimated net worth range of the resident | String | Enhanced by Shovels |
| personal_emails | Personal email addresses of the resident | String | Enhanced by Shovels |
| phone | Resident's phone number | String | Enhanced by Shovels |
| state | State of residence | String | Enhanced by Shovels |
| street | Street name of resident's address | String | Enhanced by Shovels |
| street_no | Street number of resident's address | String | Enhanced by Shovels |
| zip_code | Primary ZIP code (5-digit) | String | Enhanced by Shovels |
| zip_code_ext | ZIP code extension (4-digit) | String | Enhanced by Shovels |
