DD_Permits.xlsx

	B	C	D
1	FieldName	Type	Description

2	LOCATION
3	State	VARCHAR	State where permit is filed
4	County	VARCHAR	County where permit is filed
5	City	VARCHAR	City where permit is filed
6	PROJECT INFORMATION
7	Sector	VARCHAR	Residential \| Commercial (Derived)
8	Construction_Type	VARCHAR	New \| Remodel or Renovation (Derived)
9	Permit_Number	VARCHAR	Permit ID
10	Permit_Type	VARCHAR	Addition \| Renovation \| Electrical \| Plumbing and more
11	Permit_Status	VARCHAR	Open \| Processing \| Approved \| Closed
12	Start_Date	VARCHAR	Date when permit was filed.
13	Status_Date	DATE	Date when status was updated
14	Project_Title	VARCHAR	Title of project
15	Project_Description	VARCHAR	Description of project
16	Project_Address	VARCHAR	Address of project
17	Project_Cost	VARCHAR	Estimated cost of project
18	Parcel_Number	VARCHAR	Parcel number for the property
19	Building_Type	VARCHAR	Type of structure being built or renovated (Derived)
20	Permit_Stages	VARCHAR	Permit key phase updates and corressponding dates
21	Elapsed_Days	VARCHAR	Days elapsed from permit filing to the current status
22	Address_Count	VARCHAR	Number of addresses associated with the permit (min. 1)
23	LIST OF RELATED ADDRESSES
24	Related_Addresses	LIST	List of additional addresses associated with the permit. (1..n)
25	Project_Address	VARCHAR	Address of project
26	Permit_Type	VARCHAR	Addition \| Renovation \| Electrical \| Plumbing and more
27	Permit_Status	VARCHAR	Open \| Processing \| Approved \| Closed
28	Project_Cost	VARCHAR	Estimated cost of project
29	Project_Title	VARCHAR	Title of project
30	Project_Description	VARCHAR	Description of project
31	Construction_Type	VARCHAR	New \| Remodel or Renovation (Derived)
32	Building_Type	VARCHAR	Type of structure being built or renovated (Derived)
33	LIST OF CONTACTS
34	Name	VARCHAR	Contact name
35	Company	VARCHAR	Contact Company name
36	Address	VARCHAR	Contact Company addreess
37	Phone	VARCHAR	Contact Phone
38	Email	VARCHAR	Contact Email
39	Type	VARCHAR	Contractor \| Applicant \| Developer
40	AREA / TYPE OF WORK - INDICATORS (Y/N)
41	Addition	CHAR	Indicator - work area or type
42	Alteration	CHAR	Indicator - work area or type
43	Bath	CHAR	Indicator - work area or type
44	Deck	CHAR	Indicator - work area or type
45	Demolition	CHAR	Indicator - work area or type
46	Door	CHAR	Indicator - work area or type
47	Electrical	CHAR	Indicator - work area or type
48	Elevator	CHAR	Indicator - work area or type
49	Exterior	CHAR	Indicator - work area or type
50	Flooring	CHAR	Indicator - work area or type
51	Garage	CHAR	Indicator - work area or type
52	Gas	CHAR	Indicator - work area or type
53	Generator	CHAR	Indicator - work area or type
54	HVAC	CHAR	Indicator - work area or type
55	Insulation	CHAR	Indicator - work area or type
56	Interior	CHAR	Indicator - work area or type
57	Kitchen	CHAR	Indicator - work area or type
58	Landscape	CHAR	Indicator - work area or type
59	Mechanical	CHAR	Indicator - work area or type
60	New	CHAR	Indicator - work area or type
61	Painting	CHAR	Indicator - work area or type
62	Panel	CHAR	Indicator - work area or type
63	Patio	CHAR	Indicator - work area or type
64	Plumbing	CHAR	Indicator - work area or type
65	Pool	CHAR	Indicator - work area or type
66	Porch	CHAR	Indicator - work area or type
67	Remodel	CHAR	Indicator - work area or type
68	Renovation	CHAR	Indicator - work area or type
69	Repair	CHAR	Indicator - work area or type
70	Roof	CHAR	Indicator - work area or type
71	Solar	CHAR	Indicator - work area or type
72	Wall	CHAR	Indicator - work area or type
73	Window	CHAR	Indicator - work area or type
998
999
1000
1001
1002
1003
1004
1005
1006
1007