> ## 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 |
| :-------------------------------- | :-------- | :----------------------------------------------------------------------------------------------------- | :-------------------------------------------------------- |
| id | `string` | The Shovels ID for the permit. | "caf3b9d5ce317d53" |
| permit\_number | `string` | The jurisdiction permit number — Source: Permit Jurisdiction | "RE2303928" |
| apn | `string` | Parcel Number | "3209567" |
| county\_fips | `string` | Federal FIPS code for the county — Source: Gov (Fed) | "06193" |
| state\_fips | `string` | Federal FIPS code for the state — Source: Gov (Fed) | "06" |
| cbsa | `string` | Core Based Statistical Area — Source: Gov (Fed) | "San Francisco-Oakland-Berkeley, CA" |
| cbsa\_fips | `string` | Core Based Statistical Area FIPS code — Source: Gov (Fed) | "41869" |
| status | `string` | The status of the permit (active, in\_review, in\_active, or final) | "active" |
| start\_date | `date` | The earliest date on record for the permit | "2023-01-01" |
| end\_date | `date` | The last date on record for the permit | "2024-12-31" |
| issue\_date | `date` | The date the permit was issued — Source: Permit Jurisdiction | "2023-01-31" |
| file\_date | `date` | The date the permit was filed with the permit office — Source: Permit Jurisdiction | "2023-01-01" |
| final\_date | `date` | The date the permit (and underlying project) was completed — Source: Permit Jurisdiction | "2024-12-31" |
| type | `string` | The type of permit (or project) as determined by the jurisdiction — Source: Permit Jurisdiction | "Residential accessory structure" |
| subtype | `string` | The sub-type of permit (or project) as determined by the jurisdiction — Source: Permit Jurisdiction | "garage" |
| approval\_duration | `integer` | The number of days it took to approve the permit | "30" |
| construction\_duration | `integer` | The number of days between permit approval and completion | "700" |
| total\_duration | `integer` | The total number of days between permit filing and completion | "730" |
| fees | `decimal` | The total reported fees paid for the permit — Source: Permit Jurisdiction | "1000.00" |
| job\_value | `decimal` | The total reported job value, as self-reported by the applicant — Source: Permit Jurisdiction | "100000.00" |
| inspection\_pass\_rate | `double` | The ratio of passed inspections against total inspections for the permit | "50(%)" |
| inspection\_passed | `boolean` | `TRUE` if the permit passed ANY inspection | "TRUE" |
| description | `string` | The long-form description of the permit, as reported by the jurisdiction — Source: Permit Jurisdiction | "single car garage" |
| owner\_name | `string` | The name of the property owner — Source: Permit Jurisdiction | "John Doe" |
| owner\_street | `string` | The street address of the property owner — Source: Permit Jurisdiction | "123 Main St" |
| owner\_city | `string` | The city of the property owner — Source: Permit Jurisdiction | "San Francisco" |
| owner\_state | `string` | The state of the property owner — Source: Permit Jurisdiction | "CA" |
| owner\_zipcode | `string` | The zipcode of the property owner — Source: Permit Jurisdiction | "94101" |
| owner\_email | `string` | The email address of the property owner — Source: Permit Jurisdiction | "[john.doe@example.com](mailto:john.doe@example.com)" |
| owner\_phone | `string` | The phone number of the property owner — Source: Permit Jurisdiction | "123-456-7890" |
| applicant\_name | `string` | The name of the permit applicant — Source: Permit Jurisdiction | "John Smith" |
| applicant\_street | `string` | The street address of the permit applicant — Source: Permit Jurisdiction | "789 A St" |
| applicant\_city | `string` | The city of the permit applicant — Source: Permit Jurisdiction | "San Francisco" |
| applicant\_state | `string` | The state of the permit applicant — Source: Permit Jurisdiction | "CA" |
| applicant\_zipcode | `string` | The zipcode of the permit applicant — Source: Permit Jurisdiction | "94101" |
| applicant\_email | `string` | The email address of the permit applicant — Source: Permit Jurisdiction | "[john.smith@example.com](mailto:john.smith@example.com)" |
| applicant\_phone | `string` | The phone number of the permit applicant — Source: Permit Jurisdiction | "123-456-7890" |
| window\_door | `boolean` | `TRUE` if the permit includes a window or door | "TRUE" |
| street\_no | `string` | The street number of the property — Source: Permit Jurisdiction | "123" |
| street | `string` | The street name of the property — Source: Permit Jurisdiction | "Main St" |
| city | `string` | The city of the property — Source: Permit Jurisdiction | "San Francisco" |
| zipcode | `string` | The zipcode of the property — Source: Permit Jurisdiction | "94101" |
| zipcode\_ext | `string` | The zipcode extension of the property — Source: Permit Jurisdiction | "1234" |
| jurisdiction | `string` | The jurisdiction that issued the permit — Source: Permit Jurisdiction | "San Francisco" |
| county | `string` | The county of the property — Source: Permit Jurisdiction | "San Francisco" |
| state | `string` | The state of the property — Source: Permit Jurisdiction | "CA" |
| lat | `decimal` | The latitude of the property | "37.7749" |
| long | `decimal` | The longitude of the property | "-122.4194" |
| address\_id | `string` | The Shovels `geo_ID` for the address | "caf3b9d5ce317d53" |
| city\_id | `string` | The Shovels `geo_ID` for the city | "KLais31" |
| jurisdiction\_id | `string` | The Shovels `geo_ID` for the jurisdiction | "ALa2s33" |
| county\_id | `string` | The Shovels `geo_ID` for the county | "BLa2s33" |
| addition | `boolean` | `TRUE` if the permit includes an addition | "TRUE" |
| adu | `boolean` | `TRUE` if the permit includes an Additional Dwelling Unit (ADU) | "FALSE" |
| bathroom | `boolean` | `TRUE` if the permit includes a bathroom | "FALSE" |
| battery | `boolean` | `TRUE` if the permit includes a battery | "FALSE" |
| demolition | `boolean` | `TRUE` if the permit includes demolition | "FALSE" |
| electric\_meter | `boolean` | `TRUE` if the permit includes an electric meter | "FALSE" |
| electrical | `boolean` | `TRUE` if the permit includes electrical work | "TRUE" |
| ev\_charger | `boolean` | `TRUE` if the permit includes an EV charger | "TRUE" |
| fire\_sprinkler | `boolean` | `TRUE` if the permit includes a fire sprinkler | "TRUE" |
| gas | `boolean` | `TRUE` if the permit includes gas work | "FALSE" |
| generator | `boolean` | `TRUE` if the permit includes a generator | "FALSE" |
| grading | `boolean` | `TRUE` if the permit includes grading | "FALSE" |
| heat\_pump | `boolean` | `TRUE` if the permit includes a heat pump | "FALSE" |
| hvac | `boolean` | `TRUE` if the permit includes HVAC work | "FALSE" |
| kitchen | `boolean` | `TRUE` if the permit includes a kitchen | "FALSE" |
| new\_construction | `boolean` | `TRUE` if the permit includes new construction | "FALSE" |
| plumbing | `boolean` | `TRUE` if the permit includes plumbing work | "FALSE" |
| pool\_and\_hot\_tub | `boolean` | `TRUE` if the permit includes a pool or hot tub | "FALSE" |
| remodel | `boolean` | `TRUE` if the permit includes remodeling work | "FALSE" |
| roofing | `boolean` | `TRUE` if the permit includes roofing work | "FALSE" |
| solar | `boolean` | `TRUE` if the permit includes solar work | "TRUE" |
| water\_heater | `boolean` | `TRUE` if the permit includes a water heater | "FALSE" |
| property\_year\_built | `integer` | The year the property was built | "1980" |
| property\_lot\_size | `integer` | The size of the property lot in square feet | "1000" |
| property\_story\_count | `integer` | The number of stories on the property | "2" |
| property\_unit\_count | `integer` | The number of units on the property | "1" |
| property\_assess\_market\_value | `integer` | The assessed market value of the property (in USD) | "19000000.00" |
| property\_type | `string` | The type of property | "Residential" |
| property\_type\_detail | `string` | The detailed type of property | "Single Family Home" |
| property\_building\_area | `integer` | The total building area of the property (in square feet) | "1000" |
| property\_legal\_owner | `string` | The name of the legal owner of the property | "John Doe" |
| property\_owner\_type | `string` | The type of owner of the property | "Individual" |
| property\_census\_tract | `string` | The property's census tract number — Source: Gov (Fed) | "06075000100" |
| property\_congressional\_district | `string` | The property's congressional district number — Source: Gov (Fed) | "11" |
| contractor\_id | `string` | The Shovels ID for the contractor (if any) associated with this permit | "John Smith Construction, LLC" |
| contractor\_group\_id | `string` | The Shovels ID for the highest level contractor entity associated with this permit | "Smith & Brothers, LLC" |
| Field Name | Data Type | Description | Example |
| :------------------- | :-------- | :-------------------------------------------------------------------------------------------------- | :---------------------------------------------------------------------- |
| biz\_name | `string` | The business name of the contractor — Source: Permit Jurisdiction | "John Smith Construction, LLC" |
| biz\_type | `string` | The type of business: Joint Venture, Corporation, Partnership, Limited Liability, Sole Owner | "General Contractor" |
| name | `string` | The name of the contractor associated with the business, if available — Source: Permit Jurisdiction | "John Smith" |
| dba | `string` | The "Doing Business As" name of the contractor, as recorded on the permit | "John Smith Construction, LLC" |
| classification | `array` | The type of license(s) issued to the contractor | `["General Contractor", "Plumbing"]` |
| license | `string` | The license number of the contractor | "1234567890" |
| license\_act\_date | `date` | The activation date of the contractor's license | "2022-01-04" |
| license\_exp\_date | `date` | The expiration date of the contractor's license | "2026-12-31" |
| license\_inact\_date | `date` | The inactivation date of the contractor's license | "NULL" |
| license\_issue\_date | `date` | The issue date of the contractor's license | "2022-01-01" |
| first\_seen\_date | `date` | The date the contractor was first seen in the Shovels database | "2023-01-01" |
| sic | `string` | The Standard Industrial Classification (SIC) code of the contractor | "1234" |
| naics | `string` | The North American Industry Classification System (NAICS) code of the contractor | "123456" |
| phone | `string` | The phone number of the contractor — Source: Permit Jurisdiction | "123-456-7890" |
| email | `string` | The email address of the contractor — Source: Permit Jurisdiction | "[john.smith@example.com](mailto:john.smith@example.com)" |
| primary\_industry | `string` | The primary industry of the contractor | "Construction" |
| primary\_phone | `string` | The most relevant phone number of the contractor, based on recent permits | "123-456-7890" |
| primary\_email | `string` | The most relevant email address of the contractor, based on recent permits | "[john.smith@example.com](mailto:john.smith@example.com)" |
| linkedin\_url | `string` | The LinkedIn URL of the contractor | "[www.linkedin.com/in/johnsmith](http://www.linkedin.com/in/johnsmith)" |
| website | `string` | The website of the contractor | "[www.johnsmithconstruction.com](http://www.johnsmithconstruction.com)" |
| revenue | `integer` | The annual revenue of the contractor (in USD) | "1000000" |
| street | `string` | The street address of the contractor | "A St" |
| street\_no | `string` | The street number of the contractor | "789" |
| city | `string` | The city of the contractor | "San Francisco" |
| county | `string` | The county of the contractor | "San Francisco" |
| state | `string` | The state of the contractor | "CA" |
| zipcode | `integer` | The zipcode of the contractor | "94101" |
| zipcode\_ext | `integer` | The zipcode extension of the contractor | "1234" |
| lat | `decimal` | The latitude of the contractor's address | "37.7749" |
| lng | `decimal` | The longitude of the contractor's address | "-122.4194" |
| Field Name | Data Type | Description | Example |
| :---------------------------------- | :-------- | :-------------------------------------------------------- | :-------------------------------------------------------------------------------------------------------------------------------------- |
| contractor\_id | `string` | Unique Shovels ID for each contractor record. | "e79c3393ad" |
| contractor\_group\_id | `string` | Unique Shovels ID for related contractor records. | "a894slk74382siv2" |
| person\_id | `string` | Unique ID for the individual contractor or employee. | "aa145cd32c95f69b95e9233f6a957a32" |
| name | `string` | The name of the individual. | "Jane Smith" |
| street\_no | `string` | The street number of the individual's address. | "789" |
| street | `string` | The street name of the individual's address. | "A St" |
| city | `string` | The city of the individual's address. | "San Francisco" |
| zipcode | `string` | The zipcode of the individual's address. | "94101" |
| zipcode\_ext | `string` | The zipcode extension of the individual's address. | "1234" |
| state | `string` | The state of the individual's address. | "CA" |
| phone | `string` | The phone number of the individual. | "123-456-7890" |
| email | `string` | The personal email address of the individual. | "[jane.smith@example.com](mailto:jane.smith@example.com)" |
| email\_validation\_status | `string` | State of whether the email address is validated. | "Valid (Digital)" |
| email\_last\_seen | `date` | Most recent date the email was confirmed active. | "2025-02-07" |
| business\_email | `string` | The business email of the individual. | "[jane.smith@johnsmithconstruction.com](mailto:jane.smith@johnsmithconstruction.com)" |
| business\_email\_validation\_status | `string` | State of whether the business email is validated. | "Valid (Digital)" |
| business\_email\_last\_seen | `date` | Most recent date the business email was confirmed active. | "2025-02-02" |
| linkedin\_url | `string` | The LinkedIn URL of the individual. | "[www.linkedin.com/in/jane-smith-construction](http://www.linkedin.com/in/jane-smith-construction)" |
| homeowner | `string` | Indicates whether the individual owns their home. | "Y" |
| gender | `string` | Indicates the gender of the individual. | "F" |
| age\_range | `string` | The age bracket of the individual. | "35-44" |
| is\_married | `boolean` | `TRUE` if the individual is married. | "TRUE" |
| has\_children | `boolean` | `TRUE` if the individual has children. | "FALSE" |
| income\_range | `string` | The annual income bracket of the individual (in USD). | "60,000 to 74,999" |
| net\_worth | `string` | The net worth bracket of the individual (in USD). | "1,000,000 to 2,499,999" |
| job\_title | `string` | Current professional position. | "Revenue Analyst" |
| seniority\_level | `string` | Current seniority level in the individual's position. | "Staff" |
| department | `string` | Current department or division of employment. | "Revenue Operations" |
| job\_title\_last\_updated | `date` | The date the job title information was last updated. | "2025-01-01" |
| work\_history | `array` | The individual's employment history details. | `[{"company_name": "John Smith Construction, LLC", "duration": "3 years 5 months", "end_time": "Present"}]` |
| 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}]` |
| Field Name | Data Type | Description | Example |
| :----------------------------------- | :-------- | :----------------------------------------------------------------------------- | :------------------------------------------------------------------------------------------------------------------------------------------------------- |
| id | `string` | Unique ID for each resident record. | "we8lsd25l08" |
| company\_id | `string` | Unique ID for the company associated with the resident. | "82lsdsso4800x25lk" |
| name | `string` | The full name of the resident. | "John Doe" |
| street\_no | `string` | The street number of the resident's address. | "123" |
| street | `string` | The street name of the resident's address. | "Main St" |
| city | `string` | The city of the resident's address. | "San Francisco" |
| zipcode | `string` | The zipcode of the resident's address. | "94101" |
| zipcode\_ext | `string` | The zipcode extension of the resident's address. | "1234" |
| state | `string` | The state of the resident's address. | "CA" |
| phone | `string` | The phone number of the resident. | "123-456-7890" |
| personal\_emails | `string` | The personal email addresses of the resident. | "[john.doe@example.com](mailto:john.doe@example.com)" |
| personal\_emails\_validation\_status | `string` | State of whether the personal email address is validated. | "Valid (Digital)" |
| personal\_emails\_last\_seen | `date` | Most recent date the personal email was confirmed active. | "2025-01-28" |
| business\_email | `string` | The business email of the resident. | "[john.doe@acme.com](mailto:john.doe@acme.com)" |
| business\_email\_validation\_status | `string` | State of whether the business email is validated. | "Valid (Digital)" |
| business\_email\_last\_seen | `date` | Most recent date the business email was confirmed active. | "2025-02-08" |
| linkedin\_url | `string` | The LinkedIn URL of the resident. | "[www.linkedin.com/in/john-doe-acme](http://www.linkedin.com/in/john-doe-acme)" |
| homeowner | `string` | Indicates whether the resident owns their home. | "Y" |
| gender | `string` | Indicates the gender of the resident. | "M" |
| age\_range | `string` | The age bracket of the resident. | "55-64" |
| is\_married | `boolean` | `TRUE` if the resident is married. | "TRUE" |
| has\_children | `boolean` | `TRUE` if the resident has children. | "FALSE" |
| income\_range | `string` | The income bracket of the resident. | "100,000 to 124,999" |
| net\_worth | `string` | The net worth bracket of the resident. | "2,500,000 to 3,749,999" |
| job\_title | `string` | The current professional position of the resident. | "Senior Project Manager" |
| seniority\_level | `string` | The current seniority level of the resident in their position. | "Staff" |
| department | `string` | The current department or division of employment for the resident. | "Operations" |
| job\_title\_last\_updated | `date` | The date the job title information was last updated. | "2025-02-01" |
| work\_history | `string` | The resident's employment history. | `[{"company_name": "Acme, LLC", "duration": "14 years 9 months", "end_time": "Present"}]` |
| 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}]` |
| social\_connections | `string` | The number or details of the residents professional network connections. | "500+" |
| company\_name | `string` | The name of the company the resident works for. | "Acme, LLC" |
| company\_domain | `string` | The domain of the company the resident works for. | "acme.com" |
| company\_phone | `string` | The primary phone number of the resident's company. | "102-040-5060" |
| company\_sic | `string` | The Standard Industrial Classification (SIC) code of the resident's company. | "1234" |
| company\_street\_no | `string` | The company's primary location's street address number. | "111" |
| company\_street | `string` | The company's primary location's street address. | "Acme St" |
| company\_city | `string` | The company's primary location's city. | "San Francisco" |
| company\_zip | `string` | The company's primary location's zipcode. | "94101" |
| company\_state | `string` | The company's primary location's state. | "CA" |
| company\_linkedin\_url | `string` | The LinkedIn URL of the company. | "[www.linkedin.com/company/acme](http://www.linkedin.com/company/acme)" |
| company\_revenue | `string` | The annual revenue bracket of the company (in USD). | "1 Billion and over" |
| company\_employee\_count | `string` | The number of employees of the company. | "150,000" |
| company\_primary\_industry | `string` | The primary industry of the company. | "Manufacturing" |
| company\_description | `string` | The description of the company. | "Acme is a leading manufacturer of cartoon mousetraps." |
| company\_naics | `string` | The North American Industry Classification System (NAICS) code of the company. | "123456" |
| address\_id | `string` | The Shovels ID for the address of the resident. | "we8lsd25l08" |