Data_Dictionary_Permits.xlsx

	A	B	C	D
1	RecordType	FieldName	Type	Description

2	LOCATION	State	VARCHAR	State where permit is filed
3	LOCATION	County	VARCHAR	County where permit is filed
4	LOCATION	City	VARCHAR	City where permit is filed
5	PROJECT INFORMATION	Sector	VARCHAR	Residential \| Commercial
6	PROJECT INFORMATION	Construction_Type	VARCHAR	New \| Remodel or Renovation
7	PROJECT INFORMATION	Permit_Number	VARCHAR	Permit ID
8	PROJECT INFORMATION	Permit_Type	VARCHAR	Addition \| Renovation \| Electrical \| Plumbing and more
9	PROJECT INFORMATION	Permit_Status	VARCHAR	Open \| Processing \| Approved \| Closed
10	PROJECT INFORMATION	Status_Date	DATE	Date when status was updated
11	PROJECT INFORMATION	Project_Title	VARCHAR	Title of project
12	PROJECT INFORMATION	Project_Description	VARCHAR	Description of project
13	PROJECT INFORMATION	Project_Address	VARCHAR	Address of project
14	PROJECT INFORMATION	Project_Cost	VARCHAR	Estimated cost of project
15	PROJECT INFORMATION	Parcel_Number	VARCHAR	Parcel number for the property
16	PROJECT INFORMATION	Building_Type	VARCHAR	Type of structure being built or renovated
17	CONTACT	Contact_Name	VARCHAR	Contact name
18	CONTACT	Contact_Company	VARCHAR	Company name
19	CONTACT	Contact_Address	VARCHAR	Company addreess
20	CONTACT	Contact_Phone	VARCHAR	Phone
21	CONTACT	Contact_Email	VARCHAR	Email
22	CONTACT	Contact_Type	VARCHAR	Contractor \| Applicant \| Property Owner \| Developer
23	CONTRACTOR	Contractor_Name	VARCHAR	Contractor name
24	CONTRACTOR	Contractor_Company	VARCHAR	Company name
25	CONTRACTOR	Contractor_Address	VARCHAR	Company addreess
26	CONTRACTOR	Contractor_Phone	VARCHAR	Phone
27	CONTRACTOR	Contractor_Email	VARCHAR	Email
28	DEVELOPER / OWNER	Owner_Name	VARCHAR	Owner or Developer name or company name
29	DEVELOPER / OWNER	Owner_Email	VARCHAR	Email
30	DEVELOPER / OWNER	Owner_Info	VARCHAR	Address or other information
31	AREA / TYPE OF WORK	Addition	CHAR	Indicator - work area or type
32	AREA / TYPE OF WORK	Alteration	CHAR	Indicator - work area or type
33	AREA / TYPE OF WORK	Bath	CHAR	Indicator - work area or type
34	AREA / TYPE OF WORK	Deck	CHAR	Indicator - work area or type
35	AREA / TYPE OF WORK	Demolition	CHAR	Indicator - work area or type
36	AREA / TYPE OF WORK	Door	CHAR	Indicator - work area or type
37	AREA / TYPE OF WORK	Electrical	CHAR	Indicator - work area or type
38	AREA / TYPE OF WORK	Elevator	CHAR	Indicator - work area or type
39	AREA / TYPE OF WORK	Exterior	CHAR	Indicator - work area or type
40	AREA / TYPE OF WORK	Flooring	CHAR	Indicator - work area or type
41	AREA / TYPE OF WORK	Garage	CHAR	Indicator - work area or type
42	AREA / TYPE OF WORK	Gas	CHAR	Indicator - work area or type
43	AREA / TYPE OF WORK	Generator	CHAR	Indicator - work area or type
44	AREA / TYPE OF WORK	HVAC	CHAR	Indicator - work area or type
45	AREA / TYPE OF WORK	Insulation	CHAR	Indicator - work area or type
46	AREA / TYPE OF WORK	Interior	CHAR	Indicator - work area or type
47	AREA / TYPE OF WORK	Kitchen	CHAR	Indicator - work area or type
48	AREA / TYPE OF WORK	Landscape	CHAR	Indicator - work area or type
49	AREA / TYPE OF WORK	Mechanical	CHAR	Indicator - work area or type
50	AREA / TYPE OF WORK	New	CHAR	Indicator - work area or type
51	AREA / TYPE OF WORK	Painting	CHAR	Indicator - work area or type
52	AREA / TYPE OF WORK	Panel	CHAR	Indicator - work area or type
53	AREA / TYPE OF WORK	Patio	CHAR	Indicator - work area or type
54	AREA / TYPE OF WORK	Plumbing	CHAR	Indicator - work area or type
55	AREA / TYPE OF WORK	Pool	CHAR	Indicator - work area or type
56	AREA / TYPE OF WORK	Porch	CHAR	Indicator - work area or type
57	AREA / TYPE OF WORK	Remodel	CHAR	Indicator - work area or type
58	AREA / TYPE OF WORK	Renovation	CHAR	Indicator - work area or type
59	AREA / TYPE OF WORK	Repair	CHAR	Indicator - work area or type
60	AREA / TYPE OF WORK	Roof	CHAR	Indicator - work area or type
61	AREA / TYPE OF WORK	Solar	CHAR	Indicator - work area or type
62	AREA / TYPE OF WORK	Wall	CHAR	Indicator - work area or type
63	AREA / TYPE OF WORK	Window	CHAR	Indicator - work area or type
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100