> ## Documentation Index
> Fetch the complete documentation index at: https://docs.shovels.ai/llms.txt
> Use this file to discover all available pages before exploring further.
# Enterprise Data License
> The exhaustive list of all fields in the Shovels platform, sorted by table.
| 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](mailto: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](mailto: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 |
| 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](mailto: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](mailto:john.smith@example.com)" | Shovels |
| linkedin\_url | `string` | The LinkedIn URL of the contractor | "[www.linkedin.com/in/johnsmith](http://www.linkedin.com/in/johnsmith)" | Shovels |
| website | `string` | The website of the contractor | "[www.johnsmithconstruction.com](http://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 |
| 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](mailto: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](mailto: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](http://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 |
| 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](mailto: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](mailto: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](http://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](http://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 |