Enterprise Data License

The exhaustive list of all fields in the Shovels platform, sorted by table.

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	”[e-mail]”	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	”[e-mail]”	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	”[e-mail]”	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	”[e-mail]”	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.	”[e-mail]”	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.	”[e-mail]”	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.	”[e-mail]”	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.	”[e-mail]”	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!