﻿_id	Field Name	Data Type	Field Description	Example	Notes
1	1907_03_01/1907_12_31	Date	This shows the range of time in which the violations were corrected. Here it is from March 1st 1907 until December 31st 1907.		
2	1908_01_01/1908_12_31	Date	This shows the range of time in which the violations were corrected. Here it is from January 1st 1908 until December 31st 1908.		
3	1909_01_01/1909_12_31	Date	This shows the range of time in which the violations were corrected. Here it is from January 1st 1909 until December 31st 1909.		
4	1910_01_01/1910_12_31	Date	This shows the range of time in which the violations were corrected. Here it is from January 1st 1910 until December 31st 1910.		
5	1911_01_01/1911_12_31	Date	This shows the range of time in which the violations were corrected. Here it is from January 1st 1911 until December 31st 1911.		
6	1912_01_01/1912_12_31	Date	This shows the range of time in which the violations were corrected. Here it is from January 1st 1912 until December 31st 1912.		
7	1913_01_01/1913_12_31	Date	This shows the range of time in which the violations were corrected. Here it is from January 1st 1913 until December 31st 1913.		
8	Alleys_And_Areaways_Cleaned 	Number	Indicates how many times in a year alleys and areaways were cleaned such as removing debris, garbage and other filth.	89	
9	Animals_Removed	Number	Indicates how many times in a year animals were removed from apartments or tenement houses.	26	
10	Cellars_Cleaned 	Number	Indicates how many times in a year a cellar was cleaned in a house such as removing debris and garbage and other filth.	238	
11	Cellars_Concreted	Number	Indicates how many times in a year a cellar had concrete applied to its floor or walls.	11	
12	Cellars_Water_Removed_From	Number	Indicates how many times in a year water was removed from a cellar.	35	
13	Cellars_Vacated_For_Living_Purposes	Number	Indicates how many times in a year occupants were removed from living within cellars	48	
14	Ceilings_Painted_Or_Papered	Number	Indicates how many times in a year ceilings were either painted or had wall paper applied	207	
15	Ceilings_Plastered	Number	Indicates how many times in a year ceilings had plaster applied.	140	
16	Ceilings_Whitewashed	Number	Indicates how many times in a year ceilings were painted with whitewash	298	Whitewash is a lime solution used for painting surfaces white.
17	Chimneys_Repaired 	Number	Indicates how many times a year a chimney was repaired such as fixing loose bricks or cracks	7	
18	Conductors_Provided	Number	Indicates how many times in a year a conductor was provided for a tenement house.	14	"""Conductors"" connect roof gutters to downspouts, and are used to collect storm water."
19	Conductors_Repaired	Number	Indicates how many times a year a conductor was repaired	62	"""Conductors"" connect roof gutters to downspouts, and are used to collect storm water."
20	Conductors_Sewered	Number	Indicates how many times a year a conductor was connected to a sewer system.	133	Conductors connect roof gutters to downspouts, and are used to collect storm water.
21	Dark_Rooms_Abandoned	Number	Indicates how many times a year a dark room was abandoned in a house.	0	"""Dark rooms"" were rooms that had no natural light or ventalation in them. Here abandons indates these dark rooms were no longer in use."
22	Doors_Repaired	Number	Indicates how many times a year a door was repaired in a house such as it being cracked or off its hinges or otherwise damaged.	101	
23	Fire_Escapes_Obstructions_Removed_From	Number	Indicates how many times a year a fire escape had debris or other obstructions removed from it.	130	
24	Fire_Escapes_Erected	Number	Indicates how many times a year a fire escpae was added to a tenement house.	0	
25	Fire_Escapes_Repaired	Number	Indicates how many times a year a fire escape was repaired such as loose or degraded steps and railing.	0	
26	Floors_Repaired	Number	Indicates how many times a year floor were repaired such are fixing general wear and tear or other damages.	71	
27	Garbage_And_Ash_Cans_Provided	Number	Indicates how many times a year garbage and ash cans were given to a tenement house.	292	Ash cans are for any garbage that is burned by tenants.
28	Garbage_Chutes_And_Cans_Cleaned	Number	Indicates how many times a year a garbage chute or can was clear such are clearing accumulated filth.	59	
29	Glass_Replaced	Number	Indicates how many times a year glass was replace in windows that were broken.	42	
30	Halls_Cleaned	Number	Indicates how many times a year halls within the house were cleaned of dirt and garbage and other filth.	273	
31	Halls_Lighted_And_Ventilated 	Number	Indicates how many times a year a hall was provided with adequate lighting whether electric or natural as well as ventilation for clean air flow.	32	
32	Halls_Painted_And_Papered 	Number	Indicates how many times a year a hall was either painted or had wallpaper applied.	208	
33	Halls_Plastered	Number	Indicates how many times a year a hall had plaster applied when nessicary on cracks or other blemishes.	55	
34	Halls_Whitewashed	Number	Indicates how many times a year a hall had whitewash applied to its walls.	57	Whitewash is a lime solution used for painting surfaces white.
35	Houses_Abandoned	Number	Indicates how many times in a year a tenement house was abandoned.	0	Here abandoned means the owner left the house.
36	Houses_Torn_Down	Number	Indicates how many times in a year a tenement house was torn down as directed by the Bureau of Public Health	6	
37	Houses_Vacated_As_Tenements	Number	Indicates how many times in a year a house was vacated as tenements meaning it no longer being used a tenement by the owner.	58	
38	Paper_Unclean_Removed	Number	Indicates how many times in a year wall paper was removed for being unclean or damp or otherwise damaged.	39	
39	Plaster_Repairs	Number	Indicates how many times in a year plaster was repaired in a house for cracks or other damages.	197	
40	Plumbing_Repairs	Number	Indicates how many times in a year repairs were made to the plumbing within the house.	39	
41	Porches_Cleaned	Number	Indicates how many times in a year porches were cleaned of any dirt or garbage or other filth.	50	
42	Porches_Repaired	Number	Indicates how many times in a year porches were repaired of damages.	64	
43	Privy_Vaults_Cleaned	Number	Indicates how many times in a year a privy vault was cleaned.	2	Privy vaults are waterless toilets.
44	Privy_Vaults_Removed	Number	Indicates how many times in a year a privy vault was removed from a tenement house.	242	Privy vaults are waterless toilets.
45	Roofs_Cleaned 	Number	Indicates how many times in a year roofs were cleaned of any debree (change to debris) or filth.	16	
46	Roofs_Repaired	Number	Indicates how many times in a year a roof was repaired such as loose shingles or holes or leaks and etc.	69	
47	Rooms_Cleaned	Number	Indicates how many times in a year a room within the house was cleaned of any excessive filth.	242	
48	Rooms_Lighted_And_Ventilated	Number	Indicates how many times a year a room within the house was provided with adequate lighting whether electric or natural as well as ventilation for clean air flow.	37	
49	Rooms_Overcrowded_Corrected	Number	Indicates how many times a year overcrowded was corrected in a room by removing or relocating tenants	11	
50	Rooms_Painted_And_Papered	Number	Indicates how many times a year a room within the house was either painted or had wallpaper applied.	763	
51	Rooms_Plastered	Number	Indicates how many times a year a room within the house had plaster applied when necessary on cracks or other blemishes.	144	
52	Rooms_Whitewashed	Number	Indicates how many times a year a room within the house had whitewash applied to its walls.	36	Whitewash is a lime solution used for painting surfaces white.
53	Sinks_Provided	Number	Indicates how many times a year a sink was provided to a tenement house or apartment.	259	
54	Sinks_Removed	Number	Indicates how many times a year a sink was removed for unsanitary conditions.	42	
55	Sinks_Repaired	Number	Indicates how many times a year a sink was repaired	46	
56	Sinks_Trapped_And_Vented	Number	Indicates how many time a year traps and vents were applied to sinks.	987	Sink Traps prevent sewer gas from passing from the drain pipes back into the building. Sink vents equalize pressure in the pipes and prevent a vacuum from forming as the fixture drains.
57	Sinks_Woodwork_Removed	Number	Indicates how many time a year sinks had woodwork removed to comply with santitary conditions.	548	
58	Stairs_Cleaned_And_Repaired	Number	Indicates how many time a year a stairway was cleaned of any filth and repaired of any damages such a loose steps.	134	
59	Stairs_Lighted	Number	Indicates how many time a year a stair case was provided with adequate lighting whether electric or natural.	17	
60	Stairs_Hand_Rails_Repaired	Number	Indicates how many time a year the hand rails of stairs were repaired of any loose joints or wear and tear and other damages.	30	
61	Stairways_Painted_And_Papered	Number	Indicates how many time a year stairways were painted or had wallpaper applied to them.	55	
62	Stairways_Plastered_And_Whitewashed	Number	Indicates how many time a year a stairway had plasted or whitewash applied to them.	46	Whitewash is a lime solution used for painting surfaces white.
63	Skylights_Repaired	Number	Indicates how many time a year a skylight was repaired of any broken glass or other damage	20	
64	Sewer_Obstructions_Removed	Number	Indicates how many time a year debris or other obstructions were removed from a sewer.	33	
65	Sewer_Repaired	Number	Indicates how many time a year a sewer was repaired such as repair crack or crumbling concrete or other damages.	10	
66	Soil_Pipe_Repaired	Number	Indicates how many times a year a soil pipe was repaired	3	Soil pipes carry soiled water from the toilet, urinal or bidet to the sewer. 
67	Walls_Cleaned_And_Plastered	Number	Indicates how many times a year walls of the house was cleaned of any dirt or filth and had plaster applied on any cracks or other damages.	89	
68	Walls_Whitewashed	Number	Indicates how many times a year walls of the house had whitewash applied to its walls.	34	Whitewash is a lime solution used for painting surfaces white.
69	Waste_Pipes_Repaired	Number	Indicates how many time a year a waste pipe was repaired of any leaks or cracks or other damages.	54	
70	Water_Closets_Cleaned	Number	Indicates how many time a year a water closet was cleaned of any filth	63	
71	Water_Closets_In_House	Number	Indicates how many water closets were located in the house.	254	
72	Water_Closets_In_Yard	Number	Indicates how many water closets were located outside the house in the yard.	498	
73	Water_Closets_Illegal_Removed	Number	Indicates how many time a year illegal water closet were removed.	103	Illegal water closets include unsanitary condition or water closet construsted without a plan.
74	Water_Closets_Obstructions_Removed	Number	Indicates how many time a year debree or other obstructions were taken out of a water closet.	56	
75	Water_Closets_Repaired	Number	Indicates how many time a year was repaired of any damages.	122	
76	Water_Closets_Ventilated	Number	Indicates how many time a year a water closet was provided with air ventilation	46	
77	Water_Pipes_Repaired	Number	Indicates how many time a year a water pipe was repaired of any leaks or cracks or other damages.	32	
78	Water_Supply_Enlarged	Number	Indicates how many time a year the water supply was enlarged in an apartment or tenement house	29	Water supply are the pumps, pipes, and faucets that provide water to a building. There are regulations for how big these need to be.
79	Yards_Cleaned	Number	Indicates how many times a year a yard was cleaned of any debris or garbage or filth or other objects.	553	
80	Yards_Concreted	Number	Indicates how many times a year a yard had concrete poured in it.	8	
81	Miscellaneous	Number	Can include work done outside of this list such as work on the foundation of the tenement house or the outer brick walls and etc.	107	
