Enterprise Data License

Permits

Field Name	Data Type	Description	Example	Source
id	`string`	The Shovels ID for the permit.	”caf3b9d5ce317d53”	Shovels
permit_number	`string`	The jurisdiction permit number	”RE2303928”	Permit Jurisdiction
apn	`string`	Parcel Number	”3209567”	Shovels
county_fips	`string`	Federal FIPS code for the county	”06193”	Gov (Fed)
state_fips	`string`	Federal FIPS code for the state	”06”	Gov (Fed)
cbsa	`string`	Core Based Statistical Area	”San Francisco-Oakland-Berkeley, CA”	Gov (Fed)
cbsa_fips	`string`	Core Based Statistical Area FIPS code	”41869”	Gov (Fed)
status	`string`	The status of the permit (active, in_review, in_active, or final)	“active”	Shovels
start_date	`date`	The earliest date on record for the permit	”2023-01-01”	Shovels
end_date	`date`	The last date on record for the permit	”2024-12-31”	Shovels
issue_date	`date`	The date the permit was issued	”2023-01-31”	Permit Jurisdiction
file_date	`date`	The date the permit was filed with the permit office	”2023-01-01”	Permit Jurisdiction
final_date	`date`	The date the permit (and underlying project) was completed	”2024-12-31”	Permit Jurisdiction
type	`string`	The type of permit (or project) as determined by the jurisdiction	”Residential accessory structure”	Permit Jurisdiction
subtype	`string`	The sub-type of permit (or project) as determined by the jurisdiction	”garage”	Permit Jurisdiction
approval_duration	`integer`	The number of days it took to approve the permit	”30”	Shovels
construction_duration	`integer`	The number of days between permit approval and completion	”700”	Shovels
total_duration	`integer`	The total number of days between permit filing and completion	”730”	Shovels
fees	`decimal`	The total reported fees paid for the permit	”1000.00”	Permit Jurisdiction
job_value	`decimal`	The total reported job value, as self-reported by the applicant	”100000.00”	Permit Jurisdiction
inspection_pass_rate	`double`	The ratio of passed inspections against total inspections for the permit	”50(%)“	Shovels
inspection_passed	`boolean`	`TRUE` if the permit passed ANY inspection	”TRUE”	Shovels
description	`string`	The long-form description of the permit, as reported by the jurisdiction	”single car garage”	Permit Jurisdiction
owner_name	`string`	The name of the property owner	”John Doe”	Permit Jurisdiction
owner_street	`string`	The street address of the property owner	”123 Main St”	Permit Jurisdiction
owner_city	`string`	The city of the property owner	”San Francisco”	Permit Jurisdiction
owner_state	`string`	The state of the property owner	”CA”	Permit Jurisdiction
owner_zipcode	`string`	The zipcode of the property owner	”94101”	Permit Jurisdiction
owner_email	`string`	The email address of the property owner	”john.doe@example.com”	Permit Jurisdiction
owner_phone	`string`	The phone number of the property owner	”123-456-7890”	Permit Jurisdiction
applicant_name	`string`	The name of the permit applicant	”John Smith”	Permit Jurisdiction
applicant_street	`string`	The street address of the permit applicant	”789 A St”	Permit Jurisdiction
applicant_city	`string`	The city of the permit applicant	”San Francisco”	Permit Jurisdiction
applicant_state	`string`	The state of the permit applicant	”CA”	Permit Jurisdiction
applicant_zipcode	`string`	The zipcode of the permit applicant	”94101”	Permit Jurisdiction
applicant_email	`string`	The email address of the permit applicant	”john.smith@example.com”	Permit Jurisdiction
applicant_phone	`string`	The phone number of the permit applicant	”123-456-7890”	Permit Jurisdiction
window_door	`boolean`	`TRUE` if the permit includes a window or door	”TRUE”	Shovels
street_no	`string`	The street number of the property	”123”	Permit Jurisdiction
street	`string`	The street name of the property	”Main St”	Permit Jurisdiction
city	`string`	The city of the property	”San Francisco”	Permit Jurisdiction
zipcode	`string`	The zipcode of the property	”94101”	Permit Jurisdiction
zipcode_ext	`string`	The zipcode extension of the property	”1234”	Permit Jurisdiction
jurisdiction	`string`	The jurisdiction that issued the permit	”San Francisco”	Permit Jurisdiction
county	`string`	The county of the property	”San Francisco”	Permit Jurisdiction
state	`string`	The state of the property	”CA”	Permit Jurisdiction
lat	`decimal`	The latitude of the property	”37.7749”	Shovels
long	`decimal`	The longitude of the property	”-122.4194”	Shovels
address_id	`string`	The Shovels `geo_ID` for the address	”caf3b9d5ce317d53”	Shovels
city_id	`string`	The Shovels `geo_ID` for the city	”KLais31”	Shovels
jurisdiction_id	`string`	The Shovels `geo_ID` for the jurisdiction	”ALa2s33”	Shovels
county_id	`string`	The Shovels `geo_ID` for the county	”BLa2s33”	Shovels
addition	`boolean`	`TRUE` if the permit includes an addition	”TRUE”	Shovels
adu	`boolean`	`TRUE` if the permit includes an Additional Dwelling Unit (ADU)	“FALSE”	Shovels
bathroom	`boolean`	`TRUE` if the permit includes a bathroom	”FALSE”	Shovels
battery	`boolean`	`TRUE` if the permit includes a battery	”FALSE”	Shovels
demolition	`boolean`	`TRUE` if the permit includes demolition	”FALSE”	Shovels
electric_meter	`boolean`	`TRUE` if the permit includes an electric meter	”FALSE”	Shovels
electrical	`boolean`	`TRUE` if the permit includes electrical work	”TRUE”	Shovels
ev_charger	`boolean`	`TRUE` if the permit includes an EV charger	”TRUE”	Shovels
fire_sprinkler	`boolean`	`TRUE` if the permit includes a fire sprinkler	”TRUE”	Shovels
gas	`boolean`	`TRUE` if the permit includes gas work	”FALSE”	Shovels
generator	`boolean`	`TRUE` if the permit includes a generator	”FALSE”	Shovels
grading	`boolean`	`TRUE` if the permit includes grading	”FALSE”	Shovels
heat_pump	`boolean`	`TRUE` if the permit includes a heat pump	”FALSE”	Shovels
hvac	`boolean`	`TRUE` if the permit includes HVAC work	”FALSE”	Shovels
kitchen	`boolean`	`TRUE` if the permit includes a kitchen	”FALSE”	Shovels
new_construction	`boolean`	`TRUE` if the permit includes new construction	”FALSE”	Shovels
plumbing	`boolean`	`TRUE` if the permit includes plumbing work	”FALSE”	Shovels
pool_and_hot_tub	`boolean`	`TRUE` if the permit includes a pool or hot tub	”FALSE”	Shovels
remodel	`boolean`	`TRUE` if the permit includes remodeling work	”FALSE”	Shovels
roofing	`boolean`	`TRUE` if the permit includes roofing work	”FALSE”	Shovels
solar	`boolean`	`TRUE` if the permit includes solar work	”TRUE”	Shovels
water_heater	`boolean`	`TRUE` if the permit includes a water heater	”FALSE”	Shovels
property_year_built	`integer`	The year the property was built	”1980”	Shovels
property_lot_size	`integer`	The size of the property lot in square feet	”1000”	Shovels
property_story_count	`integer`	The number of stories on the property	”2”	Shovels
property_unit_count	`integer`	The number of units on the property	”1”	Shovels
property_assess_market_value	`integer`	The assessed market value of the property (in USD)	“19000000.00”	Shovels
property_type	`string`	The type of property	”Residential”	Shovels
property_type_detail	`string`	The detailed type of property	”Single Family Home”	Shovels
property_building_area	`integer`	The total building area of the property (in square feet)	“1000”	Shovels
property_legal_owner	`string`	The name of the legal owner of the property	”John Doe”	Shovels
property_owner_type	`string`	The type of owner of the property	”Individual”	Shovels
property_census_tract	`string`	The property’s census tract number	”06075000100”	Gov (Fed)
property_congressional_district	`string`	The property’s congressional district number	”11”	Gov (Fed)
contractor_id	`string`	The Shovels ID for the contractor (if any) associated with this permit	”John Smith Construction, LLC”	Shovels
contractor_group_id	`string`	The Shovels ID for the highest level contractor entity associated with this permit	”Smith & Brothers, LLC”	Shovels

Contractors

Field Name	Data Type	Description	Example	Source
biz_name	`string`	The business name of the contractor	”John Smith Construction, LLC”	Permit Jurisdiction
biz_type	`string`	The type of business: Joint Venture, Corporation, Partnership, Limited Liability, Sole Owner	”General Contractor”	Shovels
name	`string`	The name of the contractor associated with the business, if available	”John Smith”	Permit Jurisdiction
dba	`string`	The “Doing Business As” name of the contractor, as recorded on the permit	”John Smith Construction, LLC”	Shovels
classification	`array`	The type of license(s) issued to the contractor	`["General Contractor", "Plumbing"]`	Shovels
license	`string`	The license number of the contractor	”1234567890”	Shovels
license_act_date	`date`	The activation date of the contractor’s license	”2022-01-04”	Shovels
license_exp_date	`date`	The expiration date of the contractor’s license	”2026-12-31”	Shovels
license_inact_date	`date`	The inactivation date of the contractor’s license	”NULL”	Shovels
license_issue_date	`date`	The issue date of the contractor’s license	”2022-01-01”	Shovels
first_seen_date	`date`	The date the contractor was first seen in the Shovels database	”2023-01-01”	Shovels
sic	`string`	The Standard Industrial Classification (SIC) code of the contractor	”1234”	Shovels
naics	`string`	The North American Industry Classification System (NAICS) code of the contractor	”123456”	Shovels
phone	`string`	The phone number of the contractor	”123-456-7890”	Permit Jurisdiction
email	`string`	The email address of the contractor	”john.smith@example.com”	Permit Jurisdiction
primary_industry	`string`	The primary industry of the contractor	”Construction”	Shovels
primary_phone	`string`	The most relevant phone number of the contractor, based on recent permits	”123-456-7890”	Shovels
primary_email	`string`	The most relevant email address of the contractor, based on recent permits	”john.smith@example.com”	Shovels
linkedin_url	`string`	The LinkedIn URL of the contractor	”www.linkedin.com/in/johnsmith”	Shovels
website	`string`	The website of the contractor	”www.johnsmithconstruction.com”	Shovels
revenue	`integer`	The annual revenue of the contractor (in USD)	“1000000”	Shovels
street	`string`	The street address of the contractor	”A St”	Shovels
street_no	`string`	The street number of the contractor	”789”	Shovels
city	`string`	The city of the contractor	”San Francisco”	Shovels
county	`string`	The county of the contractor	”San Francisco”	Shovels
state	`string`	The state of the contractor	”CA”	Shovels
zipcode	`integer`	The zipcode of the contractor	”94101”	Shovels
zipcode_ext	`integer`	The zipcode extension of the contractor	”1234”	Shovels
lat	`decimal`	The latitude of the contractor’s address	”37.7749”	Shovels
lng	`decimal`	The longitude of the contractor’s address	”-122.4194”	Shovels

Employees

Field Name	Data Type	Description	Example	Source
contractor_id	`string`	Unique Shovels ID for each contractor record.	”e79c3393ad”	Shovels
contractor_group_id	`string`	Unique Shovels ID for related contractor records.	”a894slk74382siv2”	Shovels
person_id	`string`	Unique ID for the individual contractor or employee.	”aa145cd32c95f69b95e9233f6a957a32”	Shovels
name	`string`	The name of the individual.	”Jane Smith”	Shovels
street_no	`string`	The street number of the individual’s address.	”789”	Shovels
street	`string`	The street name of the individual’s address.	”A St”	Shovels
city	`string`	The city of the individual’s address.	”San Francisco”	Shovels
zipcode	`string`	The zipcode of the individual’s address.	”94101”	Shovels
zipcode_ext	`string`	The zipcode extension of the individual’s address.	”1234”	Shovels
state	`string`	The state of the individual’s address.	”CA”	Shovels
phone	`string`	The phone number of the individual.	”123-456-7890”	Shovels
email	`string`	The personal email address of the individual.	”jane.smith@example.com”	Shovels
email_validation_status	`string`	State of whether the email address is validated.	”Valid (Digital)“	Shovels
email_last_seen	`date`	Most recent date the email was confirmed active.	”2025-02-07”	Shovels
business_email	`string`	The business email of the individual.	”jane.smith@johnsmithconstruction.com”	Shovels
business_email_validation_status	`string`	State of whether the business email is validated.	”Valid (Digital)“	Shovels
business_email_last_seen	`date`	Most recent date the business email was confirmed active.	”2025-02-02”	Shovels
linkedin_url	`string`	The LinkedIn URL of the individual.	”www.linkedin.com/in/jane-smith-construction”	Shovels
homeowner	`string`	Indicates whether the individual owns their home.	”Y”	Shovels
gender	`string`	Indicates the gender of the individual.	”F”	Shovels
age_range	`string`	The age bracket of the individual.	”35-44”	Shovels
is_married	`boolean`	`TRUE` if the individual is married.	”TRUE”	Shovels
has_children	`boolean`	`TRUE` if the individual has children.	”FALSE”	Shovels
income_range	`string`	The annual income bracket of the individual (in USD).	“60,000 to 74,999”	Shovels
net_worth	`string`	The net worth bracket of the individual (in USD).	“1,000,000 to 2,499,999”	Shovels
job_title	`string`	Current professional position.	”Revenue Analyst”	Shovels
seniority_level	`string`	Current seniority level in the individual’s position.	”Staff”	Shovels
department	`string`	Current department or division of employment.	”Revenue Operations”	Shovels
job_title_last_updated	`date`	The date the job title information was last updated.	”2025-01-01”	Shovels
work_history	`array`	The individual’s employment history details.	`[{"company_name": "John Smith Construction, LLC", "duration": "3 years 5 months", "end_time": "Present"}]`	Shovels
education_history	`array`	The individual’s education history.	`[{"degree": "Bachelors of Arts, Marketing", "institution_name": "University of California, Berkeley", "end_time": "2014-06-01", etc}]`	Shovels

Residents

Field Name	Data Type	Description	Example	Source
id	`string`	Unique ID for each resident record.	”we8lsd25l08”	Shovels
company_id	`string`	Unique ID for the company associated with the resident.	”82lsdsso4800x25lk”	Shovels
name	`string`	The full name of the resident.	”John Doe”	Shovels
street_no	`string`	The street number of the resident’s address.	”123”	Shovels
street	`string`	The street name of the resident’s address.	”Main St”	Shovels
city	`string`	The city of the resident’s address.	”San Francisco”	Shovels
zipcode	`string`	The zipcode of the resident’s address.	”94101”	Shovels
zipcode_ext	`string`	The zipcode extension of the resident’s address.	”1234”	Shovels
state	`string`	The state of the resident’s address.	”CA”	Shovels
phone	`string`	The phone number of the resident.	”123-456-7890”	Shovels
personal_emails	`string`	The personal email addresses of the resident.	”john.doe@example.com”	Shovels
personal_emails_validation_status	`string`	State of whether the personal email address is validated.	”Valid (Digital)“	Shovels
personal_emails_last_seen	`date`	Most recent date the personal email was confirmed active.	”2025-01-28”	Shovels
business_email	`string`	The business email of the resident.	”john.doe@acme.com”	Shovels
business_email_validation_status	`string`	State of whether the business email is validated.	”Valid (Digital)“	Shovels
business_email_last_seen	`date`	Most recent date the business email was confirmed active.	”2025-02-08”	Shovels
linkedin_url	`string`	The LinkedIn URL of the resident.	”www.linkedin.com/in/john-doe-acme”	Shovels
homeowner	`string`	Indicates whether the resident owns their home.	”Y”	Shovels
gender	`string`	Indicates the gender of the resident.	”M”	Shovels
age_range	`string`	The age bracket of the resident.	”55-64”	Shovels
is_married	`boolean`	`TRUE` if the resident is married.	”TRUE”	Shovels
has_children	`boolean`	`TRUE` if the resident has children.	”FALSE”	Shovels
income_range	`string`	The income bracket of the resident.	”100,000 to 124,999”	Shovels
net_worth	`string`	The net worth bracket of the resident.	”2,500,000 to 3,749,999”	Shovels
job_title	`string`	The current professional position of the resident.	”Senior Project Manager”	Shovels
seniority_level	`string`	The current seniority level of the resident in their position.	”Staff”	Shovels
department	`string`	The current department or division of employment for the resident.	”Operations”	Shovels
job_title_last_updated	`date`	The date the job title information was last updated.	”2025-02-01”	Shovels
work_history	`string`	The resident’s employment history.	`[{"company_name": "Acme, LLC", "duration": "14 years 9 months", "end_time": "Present"}]`	Shovels
education_history	`string`	The resident’s education history.	`[{"degree": "Bachelors of Science, Electrical Engineering", "institution_name": "University of California, San Diego", "end_time": "1972-06-10", etc}]`	Shovels
social_connections	`string`	The number or details of the residents professional network connections.	”500+“	Shovels
company_name	`string`	The name of the company the resident works for.	”Acme, LLC”	Shovels
company_domain	`string`	The domain of the company the resident works for.	”acme.com”	Shovels
company_phone	`string`	The primary phone number of the resident’s company.	”102-040-5060”	Shovels
company_sic	`string`	The Standard Industrial Classification (SIC) code of the resident’s company.	”1234”	Shovels
company_street_no	`string`	The company’s primary location’s street address number.	”111”	Shovels
company_street	`string`	The company’s primary location’s street address.	”Acme St”	Shovels
company_city	`string`	The company’s primary location’s city.	”San Francisco”	Shovels
company_zip	`string`	The company’s primary location’s zipcode.	”94101”	Shovels
company_state	`string`	The company’s primary location’s state.	”CA”	Shovels
company_linkedin_url	`string`	The LinkedIn URL of the company.	”www.linkedin.com/company/acme”	Shovels
company_revenue	`string`	The annual revenue bracket of the company (in USD).	“1 Billion and over”	Shovels
company_employee_count	`string`	The number of employees of the company.	”150,000”	Shovels
company_primary_industry	`string`	The primary industry of the company.	”Manufacturing”	Shovels
company_description	`string`	The description of the company.	”Acme is a leading manufacturer of cartoon mousetraps.”	Shovels
company_naics	`string`	The North American Industry Classification System (NAICS) code of the company.	”123456”	Shovels
address_id	`string`	The Shovels ID for the address of the resident.	”we8lsd25l08”	Shovels

Parcels (coming soon)

Field Name	Data Type	Description	Example	Source
Stay	Tuned	And	Check	Soon!

Shovels Online

Shovels API

Tutorials

Troubleshooting

Platform Reference

Shovels Foundations