ABCDEFGHIJKLMNOPQRSTUVWX
1
FieldNameDescriptionType
2
BUSINESS INFORMATION
3
Business_NameCompany NameVARCHAR
4
CONSTRUCTION PROFILE
5
Total_ProjectsTotal number of active, upcoming and historical projects VARCHAR
6
StatesMarkets where business is active (States)VARCHAR
7
CountiesMarkets where business is active (Counties)VARCHAR
8
SectorResidential | Commercial SectorVARCHAR
9
Project_TypeType of projectsVARCHAR
10
YearProjects history by YearVARCHAR
11
Year-MonthProjects history by Year-MonthsVARCHAR
12
LIST OF PROJECTS
13
Permit_NumberPermit IDVARCHAR
14
Permit_TypeAddition | Renovation | Electrical | Plumbing and moreVARCHAR
15
Permit_StatusOpen | Processing | Approved | ClosedVARCHAR
16
Open_DateDate when permit was filed.DATE
17
Status_DateDate when status was updatedDATE
18
Update_DateDate when last updatedDATE
19
Project_TitleTitle of projectVARCHAR
20
Project_DescriptionDescription of projectVARCHAR
21
CostEstimated cost of the projectVARCHAR
22
LIST OF CONTACTS
23
NameContact nameVARCHAR
24
CompanyContact Company nameVARCHAR
25
AddressContact Company addreessVARCHAR
26
PhoneContact PhoneVARCHAR
27
EmailContact EmailVARCHAR
28
TypeContractor | Applicant | Developer VARCHAR
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
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