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, 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
APN	The assessor's parcel number, as recorded by the county. Formats vary by state.	String	Provided by jurisdiction
ASSESSMENT_YEAR	Assessment year	Number	Enhanced by Shovels
ASSESS_IMPROVEMENT_VALUE	Assessed improvement value, in dollars	Number	Enhanced by Shovels
ASSESS_LAND_VALUE	Assessed land value, in dollars	Number	Enhanced by Shovels
ASSESS_MARKET_VALUE	Total market value, in dollars	Number	Provided by jurisdiction
ASSESS_TOTAL_VALUE	Total assessed value, in dollars	Number	Enhanced by Shovels
BASEMENT_TYPE	Basement type	String	Enhanced by Shovels
BATHROOM_COUNT	Total bathroom count. Half baths are reported as fractions, so this value may be fractional.	Number	Enhanced by Shovels
BEDROOM_COUNT	Bedroom count	Number	Enhanced by Shovels
BLOCK	The block of the subdivision or city in which the property is located	String	Enhanced by Shovels
BUILDING_AREA	Total building square footage	Number	Provided by jurisdiction
BUILDING_CLASS	Building class	String	Enhanced by Shovels
BUILDING_STYLE	Building style	String	Enhanced by Shovels
CENSUS_TRACT	The 11-digit census tract GEOID (state + county + tract)	String	Enhanced by Shovels
CONGRESSIONAL_DISTRICT	Congressional district. Reserved column, not currently populated.	String	Enhanced by Shovels
CONSTRUCTION_TYPE	Construction type	String	Enhanced by Shovels
COOLING_TYPE	Cooling type	String	Enhanced by Shovels
EFFECTIVE_YEAR_BUILT	Effective year built	Number	Enhanced by Shovels
EXTERIOR_WALL_TYPE	Exterior wall type	String	Enhanced by Shovels
FIREPLACE_COUNT	A count indicating the number of fireplaces	Number	Enhanced by Shovels
HEATING_TYPE	Heating type	String	Enhanced by Shovels
ID	The Shovels address ID. Uniquely identifies the property and joins to ADDRESS_ID on the Permits table.	String	Created by Shovels
LAST_SALE_DATE	The sale date, as reported by the county source	String	Enhanced by Shovels
LAST_SALE_DOCUMENT_TYPE	The type of document used to record the sale or transfer of the property	String	Enhanced by Shovels
LAST_SALE_PRICE	The sale price, in dollars	Number	Enhanced by Shovels
LEGAL_DESCRIPTION	The legal description captured from the municipality assessor	String	Enhanced by Shovels
LEGAL_OWNER	The property owner name. Null where the county redacts owner information.	String	Provided by jurisdiction
LEGAL_OWNER_2	The second property owner name, where the county records more than one owner. Null where the county redacts owner information.	String	Provided by jurisdiction
LIVING_AREA	Living area in square feet. Distinct from BUILDING_AREA, which covers total building square footage.	Number	Enhanced by Shovels
LOT	The individual lot(s) which comprise the property	String	Enhanced by Shovels
LOT_DEPTH	The lot depth in feet	Number	Enhanced by Shovels
LOT_FRONTAGE	The lot frontage in feet	Number	Enhanced by Shovels
LOT_SIZE	The lot size in square feet. Falls back to lot acreage converted to square feet where the county reports only acres.	Number	Enhanced by Shovels
MUNICIPALITY	The jurisdiction in which the property is located	String	Enhanced by Shovels
OWNER_MAILING_ADDRESS	The owner's mailing street address, without the unit number or house number	String	Enhanced by Shovels
OWNER_MAILING_CITY	The owner's mailing city (e.g. Chicago)	String	Enhanced by Shovels
OWNER_MAILING_STATE	The owner's mailing state abbreviation (e.g. IL)	String	Enhanced by Shovels
OWNER_MAILING_ZIP	The owner's mailing zip code (e.g. 12345)	String	Enhanced by Shovels
OWNER_TYPE	Owner classification: individual or company_owned	String	Enhanced by Shovels
PARTIAL_BATHROOM_COUNT	Partial bathroom count	Number	Enhanced by Shovels
POOL_TYPE	Pool type	String	Enhanced by Shovels
PROPERTY_TYPE	Property type category, in snake_case (e.g. single_family, multi_family, commercial, vacant_land, miscellaneous)	String	Enhanced by Shovels
PROPERTY_TYPE_DETAIL	Property type detail, in snake_case (e.g. condo, townhouse, apartment, mobile_home)	String	Enhanced by Shovels
ROOF_TYPE	Roof type	String	Enhanced by Shovels
SCHOOL_DISTRICT	School tax district code(s)	String	Enhanced by Shovels
SECTION	The section of the city in which the property is located	String	Enhanced by Shovels
SEWER_TYPE	Sewer type	String	Enhanced by Shovels
STATE	Property address state (2 letter abbreviation). Also the dataset partition key.	String	Provided by jurisdiction
STORY_COUNT	Story Count	Number	Provided by jurisdiction
STRUCTURE_COUNT	Count of structures on the parcel	Number	Enhanced by Shovels
SUBDIVISION	The name of the subdivision or tract in which the property is located	String	Enhanced by Shovels
TAX_ACCOUNT_ID	The property's tax ID	String	Enhanced by Shovels
TAX_AMOUNT	Tax amount, in dollars	Number	Enhanced by Shovels
UNIT_COUNT	Unit Count	Number	Provided by jurisdiction
WATER_SOURCE	Water source	String	Enhanced by Shovels
YEAR_BUILT	The year that the primary building was built	Number	Provided by jurisdiction
ZONING	The property lot zoning code	String	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	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	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
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
EMAIL	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
email	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

Data Dictionary

Features

Features