Shovels Data Dictionary

	A	B	C
1	Field	Description	Type

2	ID	The Shovels ID of the permit	TEXT
3	ADDRESS_ID	The Shovels geo_ID of the address	TEXT
4	APN	Parcel number	TEXT
5	APPLICANT_CITY	Contact info for the applicant	TEXT
6	APPLICANT_EMAIL	Contact info for the applicant	TEXT
7	APPLICANT_NAME	Contact info for the applicant	TEXT
8	APPLICANT_PHONE	Contact info for the applicant	TEXT
9	APPLICANT_STATE	Contact info for the applicant	TEXT
10	APPLICANT_STREET	Contact info for the applicant	TEXT
11	APPLICANT_ZIPCODE	Contact info for the applicant	TEXT
12	STREET_NO	The street number	TEXT
13	STREET	The street name	TEXT
14	CITY	The city name	TEXT
15	CITY_ID	The geo_ID of the city	TEXT
16	COUNTY	The county name	TEXT
17	COUNTY_FIPS	The county FIPS code	TEXT
18	COUNTY_ID	The geo_ID of the county	TEXT
19	STATE	The two-character state abbreviation	TEXT
20	STATE_FIPS	The state FIPS code	TEXT
21	ZIPCODE	The five-digit ZIP code	TEXT
22	ZIPCODE_EXT	The four-digit ZIP code extension	TEXT
23	JURISDICTION	The name of the permit jurisdiction	TEXT
24	JURISDICTION_ID	The geo_ID of the permit jurisdiction	TEXT
25	CBSA	The CBSA value (also known as MSA)	TEXT
26	CBSA_FIPS	The CBSA FIPS code	TEXT
27	OWNER_CITY	Contact info for the owner according to the permit	TEXT
28	OWNER_EMAIL	Contact info for the owner according to the permit	TEXT
29	OWNER_NAME	Contact info for the owner according to the permit	TEXT
30	OWNER_PHONE	Contact info for the owner according to the permit	TEXT
31	OWNER_STATE	Contact info for the owner according to the permit	TEXT
32	OWNER_STREET	Contact info for the owner according to the permit	TEXT
33	OWNER_ZIPCODE	Contact info for the owner according to the permit	TEXT
34	PERMIT_NUMBER	The jurisdiction permit number	TEXT
35	PROPERTY_CENSUS_TRACT	The census tract number	TEXT
36	PROPERTY_CONGRESSIONAL_DISTRICT	The number of the congressional district	TEXT
37	PROPERTY_LEGAL_OWNER	The owner according to the tax assessor	TEXT
38	PROPERTY_OWNER_TYPE	The type of entity the owner is according to the tax assessor	TEXT
39	PROPERTY_TYPE	The type of property according to the tax assessor	TEXT
40	PROPERTY_TYPE_DETAIL	The subtype of property according to the tax assessor	TEXT
41	STATUS	The permit status (final, in_review, in_active, or active)	TEXT
42	TYPE	The type of the permit according to the jurisdiction	TEXT
43	SUBTYPE	The subtype of the permit according to the jurisdiction	TEXT
44	DESCRIPTION	The long-form description of the permit according to the jurisdiction	TEXT
45	INSPECTION_PASS_RATE	The ratio of the passed inspections to the total inspections on the permit	REAL
46	INSPECTION_PASSED	TRUE if any inspections passed on the permit	BOOLEAN
47	FEES	The permit fees collected by the jurisdiction	FIXED
48	JOB_VALUE	The job value reported on the permit	FIXED
49	LAT	The latitude of the permit address	FIXED
50	LONG	The longitude of the permit address	FIXED
51	PROPERTY_ASSESS_MARKET_VALUE	The market value of the property	FIXED
52	PROPERTY_BUILDING_AREA	The total building area in square feet	FIXED
53	PROPERTY_LOT_SIZE	The total lot size in square feet	FIXED
54	PROPERTY_STORY_COUNT	The number of stories on the property	FIXED
55	PROPERTY_UNIT_COUNT	The number of units on the property	FIXED
56	PROPERTY_YEAR_BUILT	The year the property was constructed	FIXED
57	TOTAL_DURATION	The number of days between the start date and the end date	FIXED
58	APPROVAL_DURATION	The number of days between the file date and the issue date	FIXED
59	CONSTRUCTION_DURATION	The number of days between the issue date and the final date	FIXED
60	START_DATE	The earliest date on the permit	DATE
61	END_DATE	The latest date on the permit	DATE
62	FILE_DATE	The date the permit application was filed	DATE
63	FINAL_DATE	The date the permit was completed	DATE
64	ISSUE_DATE	The date the permit application was approved	DATE
65	ADDITION	TRUE if the permit adds new square feet	BOOLEAN
66	ADU	TRUE if the permit is a secondary unit, cottage, in-law suite, or accessory dwelling unit	BOOLEAN
67	BATHROOM	TRUE if the permit involved a bathroom	BOOLEAN
68	BATTERY	TRUE if the permit involved a battery	BOOLEAN
69	DEMOLITION	TRUE if the permit involved any demolition	BOOLEAN
70	ELECTRIC_METER	TRUE if the permit involved an electrical meter	BOOLEAN
71	ELECTRICAL	TRUE if any of the work on the permit was electrical	BOOLEAN
72	EV_CHARGER	TRUE if the permit involved an EV charger	BOOLEAN
73	FIRE_SPRINKLER	TRUE if the permit involved a fire sprinkler	BOOLEAN
74	GAS	TRUE if the permit involved gas	BOOLEAN
75	GENERATOR	TRUE if the permit involved a generator	BOOLEAN
76	GRADING	TRUE if the permit involved grading	BOOLEAN
77	HEAT_PUMP	TRUE if the permit involved a mini-split, heat pump, or related technology	BOOLEAN
78	HVAC	TRUE if the permit involved heating, ventilation, or air condititioning	BOOLEAN
79	KITCHEN	TRUE if the permit involved a kitchen	BOOLEAN
80	NEW_CONSTRUCTION	TRUE if the permit included any new construction	BOOLEAN
81	PLUMBING	TRUE if the permit involved any type of plumbing	BOOLEAN
82	POOL_AND_HOT_TUB	TRUE if the permit involved a pool or hot tob	BOOLEAN
83	REMODEL	TRUE if the permit involved a remodel	BOOLEAN
84	ROOFING	TRUE if the permit involved roofing	BOOLEAN
85	SOLAR	TRUE if the permit involved solar	BOOLEAN
86	WATER_HEATER	TRUE if the permit involved a water heater	BOOLEAN
87	WINDOW_DOOR	TRUE if the permit involved windows or doors	BOOLEAN
88	CONTRACTOR_GROUP_ID	The higher level group ID of the contractor	TEXT
89	CONTRACTOR_ID	The Shovels ID of the individual contractor	TEXT