{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Property Listing","New Complaints","974 Sheridan Ave","2415 Creston Ave","170 Vermilyea Ave","160 Vermilyea Ave","154 Vermilyea Ave","150 Vermilyea Ave","554 West 148 Street","522 West 148 Street","510 West 148 Street","507 West 139 Street","516 West 136 Street"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":59,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Property Listing","index":0,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["RENTAL PROPERTY LISTING"]
[null,null,null,null,null,null,null,null,null,null,null,"Borough","Website Reference"]
["Borough","Website Ref","House #","Street Name","Bin #",null,null,null,null,null,null,"Manhattan",1]
["Bronx",{"$f":"VLOOKUP(A4,$L$3:$M$7,2,FALSE)","v":2},974,"Sheridan Ave",2002710,null,null,null,null,null,null,"Bronx",2]
["Bronx",{"$f":"VLOOKUP(A5,$L$3:$M$7,2,FALSE)","v":2},2415,"Creston Ave",2013913,null,null,null,null,null,null,"Brooklyn",3]
["Manhattan",1,170,"Vermilyea Ave",1064860,null,null,null,null,null,null,"Queens",4]
["Manhattan",1,160,"Vermilyea Ave",1064929,null,null,null,null,null,null,"Staten Island",5]
["Manhattan",1,154,"Vermilyea Ave",1064930]
["Manhattan",1,150,"Vermilyea Ave",1064931]
["Manhattan",1,522,"West 148 Street",1061995]
["Manhattan",1,554,"West 148 Street",1062004]
["Manhattan",1,510,"West 148 Street",1061992]
["Manhattan",1,507,"West 139 Street",1061734]
["Manhattan",1,516,"West 136 Street",1059805]

{"sheet":"New Complaints","index":1,"n_rows":3,"n_cols":15,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Complaint Date","Complaint #","Apt #","Complaint Condition","Condition Detail","Location","Address",null,"Complaint Number","Address","Date Entered","Category","Inspection Date","Disposition","Status"]
["2010-04-12",5139758,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING","170 Vermilyea Ave"]
["2010-04-10",5138976,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING","170 Vermilyea Ave"]

{"sheet":"974 Sheridan Ave","index":2,"n_rows":61,"n_cols":14,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
["Complaint Date","Complaint#","Apt#","Complaint Condition","Condtion Detail","Location",null,"Looking for a list of complaint category codes or disposition codes?"]
["2010-03-29",5127180,"2E","WATER-LEAKS","CONT ABOVE APT","BATHROOM",null,"(Adobe Acrobat Reader required)"]
["2010-03-29",5127180,"2E","WATER-LEAKS","CONT ABOVE APT","BEDROOM",null,"Complaint","Address","Date","Category","Inspection","Disposition","Status"]
["2010-02-24",5088069,"6E","VERMIN","MICE","ENTIRE APT",null,"Number",null,"Entered",null,"Date"]
["2010-02-24",5088069,"6E","RADIATOR","CRACKED/MISSING","ENTIRE APT",null,2138620,"974 SHERIDAN AVENUE","2009-12-01",45,"2009-12-28","A8","RES"]
["2010-02-24",5088069,"6E","WALLS","HOLE","BEDROOM",null,2138078,"974 SHERIDAN AVENUE","2009-11-17",10,"2009-11-18","A8","RES"]
["2010-02-24",5088069,"6E","MOLD","MOLD","ENTIRE APT",null,2135516,"974 SHERIDAN AVENUE","2009-09-12",45,"2009-12-11","C2","CLS"]
["2010-02-18",5079840,"3H","LIGHTING","WATER-PRESENT","BATHROOM",null,2117457,"974 SHERIDAN AVENUE","2008-07-22",63,"2008-08-19","A1","RES"]
["2010-02-18",5079840,"3H","HEAT","NO HEAT","ENTIRE APT",null,2117424,"974 SHERIDAN AVENUE","2008-07-21",63,"2008-08-19","H1","RES"]
["2010-02-18",5079840,"3H","WATER-LEAKS","CONT ABOVE APT","BATHROOM",null,2117262,"974 SHERIDAN AVENUE","2008-07-17",63,"2008-08-19","H1","RES"]
["2010-02-09",5067328,"5G","HEAT","NO HEAT","ENTIRE APT",null,2106663,"974 SHERIDAN AVENUE","2007-11-07",63,"2007-11-14","I2","RES"]
["2010-02-07",5064672,"5G","HEAT","NO HEAT","ENTIRE APT",null,2102735,"974 SHERIDAN AVENUE","2007-08-06",63,"2007-09-13","I2","RES"]
["2010-01-22",5033504,"1B","HEAT","NO HEAT","ENTIRE APT",null,2093046,"974 SHERIDAN AVENUE","2006-12-20",63,"2007-02-05","A1","RES"]
["2010-01-02",4993333,"5G","HEAT","NO HEAT","ENTIRE APT",null,2091721,"974 SHERIDAN AVENUE","2006-11-16",59,"2006-11-16","A1","RES"]
["2009-12-30",4989399,"5G","RADIATOR","CRACKED/MISSING","BATHROOM",null,2091544,"974 SHERIDAN AVENUE","2006-11-13",63,"2006-12-11","I2","RES"]
["2009-12-30",4989399,"5G","FLOOR","BROKE / DEF","KITCHEN",null,2091084,"974 SHERIDAN AVENUE","2006-10-31",59,"2006-11-08","A1","RES"]
["2009-12-30",4989399,"5G","RADIATOR","CRACKED/MISSING","BEDROOM",null,2090931,"974 SHERIDAN AVENUE","2006-10-26",63,"2006-12-14","A1","RES"]
["2009-12-30",4987201,"6E","HEAT","NO HEAT","ENTIRE APT",null,2089873,"974 SHERIDAN AVENUE","2006-10-04",63,"2006-10-06","I2","RES"]
["2009-12-29",4985750,"3H","HEAT","NO HEAT","ENTIRE APT",null,2089871,"974 SHERIDAN AVENUE","2006-10-04",63,"2006-10-06","H1","RES"]
["2009-12-23",4974026,"1B","HEAT","NO HEAT","ENTIRE APT",null,2089549,"974 SHERIDAN AVENUE","2006-09-27",63,"2006-10-06","H1","RES"]
["2009-12-18",4960788,"1B","HEAT","NO HEAT","ENTIRE APT",null,2089125,"974 SHERIDAN AVENUE","2006-09-15",63,"2006-10-04","I2","RES"]
["2009-12-18",4960756,"1B","HEAT","NO HEAT","ENTIRE APT",null,2087685,"974 SHERIDAN AVENUE","2006-08-10",63,"2006-08-21","A1","RES"]
["2009-12-17",4956662,"4F","HEAT","NO HEAT","ENTIRE APT",null,2087580,"974 SHERIDAN AVENUE","2006-08-08",63,"2006-08-21","H1","RES"]
["2009-12-09",4939387,"5G","RADIATOR","CRACKED/MISSING","BEDROOM",null,2087399,"974 SHERIDAN AVENUE","2006-08-04",63,"2006-09-05","A1","RES"]
["2009-12-09",4939387,"5G","FLOOR","SAGGING","KITCHEN",null,2085663,"974 SHERIDAN AVENUE","2006-06-26",63,"2006-07-07","A1","RES"]
["2009-12-09",4939387,"5G","MOLD","MOLD","BATHROOM",null,2085569,"974 SHERIDAN AVENUE","2006-06-22",63,"2006-07-07","H1","RES"]
["2009-11-24",4913137,"6E","HEAT","NO HEAT","ENTIRE APT",null,2084805,"974 SHERIDAN AVENUE","2006-06-04",63,"2006-06-13","I2","RES"]
["2009-11-17",4903871,"5H","VERMIN","ROACHES","ENTIRE APT",null,2084450,"974 SHERIDAN AVENUE","2006-05-26",63,"2006-06-02","A1","RES"]
["2009-11-17",4903871,"5H","CEILING","HOLE","BATHROOM",null,2081941,"974 SHERIDAN AVENUE","2006-03-25",63,"2006-04-05","I2","RES"]
["2009-11-17",4903871,"5H","WATER-LEAKS","CONT ABOVE APT","BATHROOM",null,2077144,"974 SHERIDAN AVENUE","2005-10-25",63,"2005-11-01","I2","RES"]
["2009-11-12",4894205,"5C","HEAT","NO HEAT","ENTIRE APT",null,2076138,"974 SHERIDAN AVENUE","2005-09-30",63,"2005-09-30","H1","RES"]
["2009-11-09",4891498,"2E","HEAT","NO HEAT","ENTIRE BUILDING",null,2075538,"974 SHERIDAN AVENUE","2005-09-15",63,"2005-09-30","I2","RES"]
["2009-11-08",4890366,"5H","VERMIN","MICE","ENTIRE APT",null,2070601,"974 SHERIDAN AVENUE","2005-05-23",63,"2005-06-06","H1","RES"]
["2009-11-08",4890366,"5H","WALLS","PEELING","ENTIRE APT",null,2070103,"974 SHERIDAN AVENUE","2005-05-10",63,"2005-05-17","H1","RES"]
["2009-11-08",4890366,"5H","BASIN/SINK","BASIN BKN OR DE","BATHROOM",null,2070036,"974 SHERIDAN AVENUE","2005-05-09",63,"2005-06-06","I1","RES"]
["2009-11-08",4890366,"5H","CEILING","COLLAPSING","BATHROOM",null,2069372,"974 SHERIDAN AVENUE","2005-04-18",63,"2005-05-17","A1","RES"]
["2009-11-08",4890024,"5C","VERMIN","MICE","ENTIRE APT",null,2066039,"974 SHERIDAN AVENUE","2005-01-04",63,"2005-03-15","I2","RES"]
["2009-11-08",4890021,"5C","HEAT","NO HEAT","ENTIRE APT",null,2065992,"974 SHERIDAN AVENUE","2005-01-02",63,"2005-03-15","I2","RES"]
["2009-11-04",4881113,"5C","HEAT","NO HEAT","ENTIRE APT",null,2065877,"974 SHERIDAN AVENUE","2004-12-27",63,"2004-12-27","J2","RES"]
["2009-11-03",4879647,"6E","WALLS","HOLE","ENTRANCE",null,2065711,"974 SHERIDAN AVENUE","2004-12-19",63,"2004-12-27","I2","RES"]
["2009-11-03",4879647,"6E","FLOOR","FLOOR-TORN","ENTIRE APT",null,2055777,"974 SHERIDAN AVENUE","2003-11-12",63,"2004-02-12","J2","RES"]
["2009-11-03",4879647,"6E","MOLD","MOLD","ENTIRE APT",null,2054038,"974 SHERIDAN AVENUE","2003-08-22",45,"2003-08-27","A9","RES"]
["2009-11-03",4879647,"6E","VERMIN","MICE","ENTIRE APT",null,2050185,"974 SHERIDAN AVENUE","2003-02-03",63,"2003-04-30","A1","RES"]
["2009-11-03",4879647,"6E","WALLS","PEELING","ENTIRE APT",null,2046203,"974 SHERIDAN AVENUE","2002-06-11",95,"2002-06-20","I2","RES"]
["2009-11-02",4877660,"5C","HEAT","NO HEAT","ENTIRE BUILDING",null,2045297,"974 SHERIDAN AVENUE","2002-04-23",95,"2002-04-29","A1","RES"]
["2009-10-23",4864940,"2F","CEILING","BULGING/LOOSE","BEDROOM",null,2043431,"974 SHERIDAN AVENUE","2002-01-23",95,"2002-03-01","A9","RES"]
["2009-10-23",4864940,"2F","WALLS","HOLE","BEDROOM",null,2042780,"974 SHERIDAN AVENUE","2001-12-11",10,"2001-12-11","A9","RES"]
["2009-10-23",4864940,"2F","VERMIN","MICE","ENTIRE APT",null,2042300,"974 SHERIDAN AVENUE","2001-11-29",63,"2001-12-10","A1","RES"]
["2009-10-16",4850054,"5C","VERMIN","RATS","ENTIRE APT",null,2041494,"974 SHERIDAN AVENUE","2001-10-16",63,"2001-11-02","A1","RES"]
["2009-10-16",4850054,"5C","HEAT","NO HEAT","ENTIRE APT",null,2035660,"974 SHERIDAN AVENUE","2000-09-12",63,"2000-09-15","A1","RES"]
["2009-10-14",4844623,"1B","HEAT","NO HEAT","ENTIRE APT",null,2017731,"974 SHERIDAN AVENUE","1996-01-02",63,"1997-12-09","J2","RES"]
["2009-09-08",4813772,"5A","DOORS","BROKEN","ENTIRE BUILDING"]
["2009-09-08",4813772,"5A","TOILET","FLUSHOMETER","BATHROOM"]
["2009-06-29",4766716,"1A","CEILING","HOLE","BEDROOM"]
["2009-06-29",4766716,"1A","CEILING","HOLE","PRIVATE HALL"]
["2009-06-29",4766716,"1A","MOLD","MOLD","PRIVATE HALL"]
["2009-06-29",4766716,"1A","MOLD","MOLD","BATHROOM"]
["2009-06-24",4764062,"1A","CEILING","COLLAPSING","PRIVATE HALL"]
["2009-06-24",4764062,"1A","CEILING","COLLAPSING","BATHROOM"]
["2009-06-24",4764062,"1A","MOLD","MOLD","BATHROOM"]
["2009-05-19",4740853,"1B","CEILING","HOLE","KITCHEN"]

{"sheet":"2415 Creston Ave","index":3,"n_rows":67,"n_cols":14,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
["Complaint Date","Complaint#","Apt#","Complaint Condition","Condtion Detail","Location",null,"Looking for a list of complaint category codes or disposition codes?"]
["2010-03-31",5130602,41,"HEAT","NO HEAT/WATER","ENTIRE APT",null,"(Adobe Acrobat Reader required)"]
["2010-03-29",5127192,33,"HEAT","NO HEAT/WATER","ENTIRE BUILDING",null,"Complaint","Address","Date","Category","Inspection","Disposition","Status"]
["2010-03-28",5126127,6,"HEAT","NO HEAT/WATER","ENTIRE APT",null,"Number",null,"Entered",null,"Date"]
["2010-03-27",5125003,6,"HEAT","NO HEAT/WATER","ENTIRE APT",null,2143568,"2415 CRESTON AVENUE","2010-04-06",76,null,null,"ACT"]
["2010-02-08",5065431,"BSMT","CARBON MONOXIDE","DEF / MISS","ENTIRE APT",null,2061019,"2415 CRESTON AVENUE","2004-07-06",59,"2005-05-11","XX","RES"]
["2010-01-22",5034020,56,"HEAT","NO HEAT","ENTIRE APT"]
["2010-01-11",5016972,32,"HEAT","NO HEAT/WATER","ENTIRE APT"]
["2010-01-03",4995450,6,"HEAT","NO HEAT/WATER","ENTIRE BUILDING"]
["2009-12-17",4957948,6,"RADIATOR","CRACKED/MISSING","BEDROOM"]
["2009-12-17",4957948,6,"CEILING","CRACKED","BEDROOM"]
["2009-12-17",4957948,6,"HEAT","NO HEAT","ENTIRE APT"]
["2009-12-17",4957948,6,"WALLS","PAINT DIRTY","ENTIRE APT"]
["2009-12-11",4943654,34,"HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-12-11",4943646,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-12-11",4942520,6,"HEAT","NO HEAT","ENTIRE APT"]
["2009-12-06",4931628,54,"HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-11-27",4916635,34,"HEAT","NO HEAT/WATER","ENTIRE APT"]
["2009-11-24",4913529,54,"HEAT","NO HEAT/WATER","ENTIRE BUILDING"]
["2009-11-24",4913529,54,"HEAT-PLANT","BOILER INOP/MIS","ENTIRE BUILDING"]
["2009-11-24",4913529,54,"HEAT","NO HEAT/WATER","ENTIRE APT"]
["2009-11-24",4913269,41,"HEAT-PLANT","BOILER INOP/MIS","ENTIRE BUILDING"]
["2009-11-24",4913269,41,"HEAT","NO HEAT/WATER","ENTIRE APT"]
["2009-11-17",4902696,34,"HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-11-17",4902535,41,"HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-11-12",4895807,45,"HEAT","NO HEAT/WATER","ENTIRE BUILDING"]
["2009-11-12",4895807,45,"FLOOR","BROKE / DEF","KITCHEN"]
["2009-11-12",4895807,45,"ELECTRIC-WIRING","EXPOSED","ENTIRE APT"]
["2009-11-12",4895807,45,"WALLS","PAINT DIRTY","KITCHEN"]
["2009-11-11",4893207,25,"CEILING","COLLAPSING","BATHROOM"]
["2009-11-11",4893207,25,"WATER-LEAKS","CASCADING","BATHROOM"]
["2009-11-11",4893207,25,"HEAT","NO HEAT/WATER","ENTIRE APT"]
["2009-11-09",4890942,41,"HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-11-06",4887656,34,"HEAT","NO HEAT","ENTIRE APT"]
["2009-11-06",4887603,33,"HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-11-04",4882040,6,"HEAT","NO HEAT","ENTIRE APT"]
["2009-10-16",4852376,6,"HEAT","NO HEAT","ENTIRE APT"]
["2009-10-15",4849309,6,"HEAT","NO HEAT","ENTIRE APT"]
["2009-10-03",4832338,6,"WATER-SUPPLY","NO-HOT- WATER","ENTIRE BUILDING"]
["2009-06-23",4763064,6,"CEILING","PLASTER PEELING","BATHROOM"]
["2009-06-23",4763064,6,"CEILING","CRACKED","BATHROOM"]
["2009-06-23",4763064,6,"REFRIGERATOR","INOPERATIVE","KITCHEN"]
["2009-06-23",4763064,6,"FLOOR","FLOOR-TORN","ENTIRE APT"]
["2009-06-23",4763064,6,"TOILET","BOWL-LEAKING","BATHROOM"]
["2009-06-23",4763064,6,"WINDOWS","SASH","ENTIRE APT"]
["2009-06-23",4763064,6,"WALLS","PAINT DIRTY","ENTIRE APT"]
["2009-06-23",4763064,6,"CEILING","PAINT DIRTY","ENTIRE APT"]
["2009-06-23",4763064,6,"WATER-LEAKS","CONT ABOVE APT","BATHROOM"]
["2009-05-13",4736720,5,"FLOOR","FLOOR-TORN","BATHROOM"]
["2009-05-13",4736720,5,"WALLS","PEELING","BATHROOM"]
["2009-05-13",4736720,5,"CEILING","CRACKED","BATHROOM"]
["2009-05-13",4736720,5,"CEILING","PAINT DIRTY","BATHROOM"]
["2009-05-13",4736720,5,"CEILING","PLASTER PEELING","BATHROOM"]
["2009-05-13",4736720,5,"WATER-LEAKS","CONT ABOVE APT","BATHROOM"]
["2009-05-13",4736720,5,"WATER-LEAKS","CONT ABOVE APT","KITCHEN"]
["2009-05-13",4736720,5,"FLOOR","FLOOR-TORN","KITCHEN"]
["2009-05-13",4736720,5,"CEILING","CRACKED","KITCHEN"]
["2009-05-13",4736720,5,"CEILING","HOLE","KITCHEN"]
["2009-05-13",4736720,5,"CEILING","PAINT DIRTY","KITCHEN"]
["2009-05-13",4736720,5,"CEILING","PLASTER PEELING","KITCHEN"]
["2009-05-13",4736720,5,"VERMIN","ROACHES","ENTIRE BUILDING"]
["2009-05-13",4736720,5,"VERMIN","RATS","ENTIRE BUILDING"]
["2009-05-13",4736720,5,"VERMIN","MICE","ENTIRE BUILDING"]
["2009-05-13",4736720,5,"WALLS","PAINT DIRTY","BATHROOM"]
["2009-05-03",4728831,6,"WALLS","PEELING","ENTIRE APT"]
["2009-05-03",4728831,6,"ELECTRIC-SUPPLY","PUBLIC AREA","LOBBY"]
["2009-05-03",4728831,6,"TOILET","BOWL-LEAKING","BATHROOM"]

{"sheet":"170 Vermilyea Ave","index":4,"n_rows":130,"n_cols":14,"rows_kept":130,"cut":false,"hidden":false,"merged":[]}
["Complaint Date","Complaint#","Apt#","Complaint Condition","Condtion Detail","Location",null,"Looking for a list of complaint category codes or disposition codes?"]
["2010-04-12",5139758,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING",null,"(Adobe Acrobat Reader required)"]
["2010-04-10",5138976,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING",null,"Complaint","Address","Date","Category","Inspection","Disposition","Status"]
["2010-04-03",5133775,"5B","HEAT","NO HEAT","ENTIRE BUILDING",null,"Number",null,"Entered",null,"Date"]
["2010-03-29",5127563,"BLDG","HEAT","NO HOT WATER","ENTIRE BUILDING",null,1220447,"170 VERMILYEA AVENUE","2008-03-31",77,"2008-05-13","I2","RES"]
["2010-03-29",5127088,"BLDG","HEAT","NO HEAT/WATER","ENTIRE BUILDING",null,1114682,"170 VERMILYEA AVENUE","2003-11-05",5,"2003-11-12","I2","RES"]
["2010-03-29",5127083,"BLDG","HEAT","NO HEAT/WATER","ENTIRE BUILDING",null,1113014,"170 VERMILYEA AVENUE","2003-10-01",59,"2003-10-02","I1","RES"]
["2010-03-29",5126983,"3B","HEAT","NO HEAT/WATER","ENTIRE BUILDING",null,1102945,"170 VERMILYEA AVENUE","2002-12-12",66,"2002-12-13","I2","RES"]
["2010-03-29",5126877,"BLDG","HEAT","NO HEAT/WATER","ENTIRE BUILDING",null,1096525,"170 VERMILYEA AVENUE","2002-04-30",45,"2002-05-06","C2","CLS"]
["2010-03-28",5126595,"BLDG","HEAT","NO HEAT/WATER","ENTIRE BUILDING",null,1095803,"170 VERMILYEA AVENUE","2002-04-08",45,"2002-04-19","I2","RES"]
["2010-03-28",5126518,"4C","HEAT","NO HEAT/WATER","ENTIRE BUILDING",null,1095805,"170 VERMILYEA AVENUE","2002-04-08",59,"2002-05-06","C2","CLS"]
["2010-03-28",5126518,"4C","HEAT","NO HEAT/WATER","ENTIRE APT",null,1019930,"170 VERMILYEA AVENUE","1992-06-29",48,"1992-08-24","A1","RES"]
["2010-03-27",5124961,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2010-03-26",5124406,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2010-03-26",5124222,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2010-03-26",5123206,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2010-03-26",5123052,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2010-03-23",5119769,"4C","WATER-LEAKS","CONT ABOVE APT","BATHROOM"]
["2010-03-23",5119769,"4C","WATER-LEAKS","CEILING","LIVING ROOM"]
["2010-03-23",5119769,"4C","WATER-LEAKS","CEILING","KITCHEN"]
["2010-03-23",5119769,"4C","WATER-LEAKS","CEILING","BATHROOM"]
["2010-03-23",5119769,"4C","WATER-LEAKS","CASCADING","PUBLIC HALL STA"]
["2010-03-23",5119769,"4C","MAIL-BOX","BROKEN","ENTIRE BUILDING"]
["2010-03-23",5119769,"4C","DOORS","BROKEN","STORAGE ROOM"]
["2010-03-23",5119769,"4C","RUBBISH","ACCUMULATION","STORAGE ROOM"]
["2010-03-23",5119769,"4C","WALLS","PEELING","ENTIRE APT"]
["2010-03-23",5119769,"4C","FLOOR","FLOOR-TORN","ENTIRE APT"]
["2010-03-23",5119769,"4C","FLOOR","FLOOR-TORN","BATHROOM"]
["2010-03-23",5119769,"4C","FLOOR","BROKE / DEF","KITCHEN"]
["2010-03-23",5119387,"BLDG","HEAT","NO HEAT/WATER","ENTIRE BUILDING"]
["2010-03-22",5119168,"4C","WATER-LEAKS","CEILING","ENTIRE BUILDING"]
["2010-03-22",5119168,"4C","WATER-LEAKS","CONT ABOVE APT","ENTIRE APT"]
["2010-03-22",5119168,"4C","WATER-LEAKS","CEILING","ENTIRE APT"]
["2010-03-22",5118117,"3F","HEAT","NO HEAT","ENTIRE APT"]
["2010-03-14",5109719,"4C","WATER-LEAKS","CASCADING","LIVING ROOM"]
["2010-03-12",5106950,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2010-03-11",5106554,"BLDG","HEAT","NO HEAT/WATER","ENTIRE BUILDING"]
["2010-03-10",5104591,"2H","HEAT","NO HEAT","ENTIRE APT"]
["2010-02-28",5093696,"4C","BASIN/SINK","LEAKING","KITCHEN"]
["2010-02-28",5093696,"4C","BASIN/SINK","LEAKING","BATHROOM"]
["2010-02-26",5091686,"BLDG","HEAT","NO HEAT/WATER","ENTIRE BUILDING"]
["2010-02-24",5087877,"BLDG","HEAT","NO HEAT/WATER","ENTIRE BUILDING"]
["2010-02-24",5087756,"3D","HEAT","NO HEAT/WATER","ENTIRE BUILDING"]
["2010-02-24",5087732,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2010-02-23",5086666,"BLDG","HEAT","NO HEAT/WATER","ENTIRE BUILDING"]
["2010-02-22",5083917,"4C","BASIN/SINK","LEAKY PIPE","BATHROOM"]
["2010-02-22",5083917,"4C","BASIN/SINK","LEAKY PIPE","KITCHEN"]
["2010-02-21",5083550,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2010-02-20",5082682,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2010-02-12",5072484,"4C","BASIN/SINK","LEAKING","BATHROOM"]
["2010-02-07",5063997,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2010-02-07",5063799,"1A","CEILING","PAINT DIRTY","ENTIRE APT"]
["2010-02-07",5063799,"1A","WALLS","PAINT DIRTY","ENTIRE APT"]
["2010-02-07",5063790,"1A","HEAT","NO HEAT","ENTIRE APT"]
["2010-02-05",5061033,"4C","BASIN/SINK","LEAKING","BATHROOM"]
["2010-01-29",5045529,"BLDG","HEAT","NO HEAT/WATER","ENTIRE BUILDING"]
["2010-01-29",5045094,"BLDG","HEAT","NO HEAT/WATER","ENTIRE BUILDING"]
["2010-01-23",5035297,"1A","HEAT","NO HEAT","ENTIRE APT"]
["2010-01-23",5034842,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2010-01-18",5028159,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2010-01-10",5014808,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2010-01-10",5014456,"4A","HEAT","NO HEAT","ENTIRE APT"]
["2010-01-10",5013997,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2010-01-07",5008091,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2010-01-06",5006437,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2010-01-06",5005574,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-12-29",4985536,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-12-27",4980599,"BLDG","HEAT","NO HEAT/WATER","ENTIRE BUILDING"]
["2009-12-26",4978617,"5D","HEAT","NO HEAT","ENTIRE APT"]
["2009-12-24",4977485,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-12-23",4974253,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-12-19",4964648,"BLDG","HEAT","NO HEAT/WATER","ENTIRE BUILDING"]
["2009-12-17",4957275,"1H","HEAT","NO HEAT","ENTIRE APT"]
["2009-12-14",4951348,"3F","ELEC/GAS-RANGE","GAS SHUT_OFF VA","ENTIRE APT"]
["2009-12-14",4951348,"3F","REFRIGERATOR","INOPERATIVE","ENTIRE APT"]
["2009-12-06",4931099,"1A","HEAT","NO HEAT","ENTIRE APT"]
["2009-12-06",4930136,"3F","HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-12-04",4928089,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-12-04",4927772,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-11-30",4920666,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-11-29",4919373,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-11-22",4910266,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-11-21",4909356,"1A","HEAT","NO HEAT","ENTIRE APT"]
["2009-11-17",4903604,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-11-17",4903341,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-11-17",4903008,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-11-11",4893928,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-11-11",4893788,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-11-11",4893656,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-11-11",4893509,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-11-07",4889752,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-11-07",4889602,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-11-07",4889216,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-11-06",4887654,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-11-06",4887256,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-11-06",4886941,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-11-06",4886777,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-11-05",4885160,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-11-04",4882759,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-11-04",4882566,"1A","HEAT","NO HEAT","ENTIRE APT"]
["2009-11-03",4880668,"1A","HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-11-03",4879637,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-11-02",4878769,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-11-02",4877837,"5G","VERMIN","ROACHES","ENTIRE APT"]
["2009-11-02",4877837,"5G","VERMIN","MICE","ENTIRE APT"]
["2009-11-02",4877837,"5G","WATER-SUPPLY","NO-HOT- WATER","ENTIRE APT"]
["2009-10-29",4873625,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-10-28",4871620,"5G","HEAT","NO HOT WATER","ENTIRE APT"]
["2009-10-28",4871620,"5G","BASIN/SINK","BASIN BKN OR DE","BATHROOM"]
["2009-10-27",4870196,"1A","HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-10-23",4866313,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-10-16",4853899,"2A","HEAT","NO HEAT","ENTIRE APT"]
["2009-10-16",4851991,"1A","HEAT","NO HEAT","ENTIRE APT"]
["2009-10-16",4851727,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-10-15",4848010,"4C","VERMIN","ROACHES","ENTIRE APT"]
["2009-10-15",4847416,"BLDG","HEAT","NO HEAT/WATER","ENTIRE BUILDING"]
["2009-10-15",4846989,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-10-15",4846974,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-10-15",4846685,"3F","HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-10-15",4846482,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-10-14",4845369,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-10-14",4844919,"3F","HEAT","NO HEAT","ENTIRE APT"]
["2009-10-14",4844782,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-10-14",4844749,"3B","HEAT","NO HEAT","ENTIRE APT"]
["2009-10-14",4844575,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-10-14",4843097,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-10-12",4840598,"4E","HEAT","NO HEAT/WATER","ENTIRE BUILDING"]
["2009-09-09",4814639,"3A","BELL-BUZZER/INT","INOPER/ MISSING","ENTIRE APT"]
["2009-05-19",4740950,"3A","CEILING","PLASTER PEELING","KITCHEN"]
["2009-04-20",4718752,"1C","HEAT","NO HEAT","ENTIRE APT"]

{"sheet":"160 Vermilyea Ave","index":5,"n_rows":52,"n_cols":14,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
["Complaint Date","Complaint#","Apt#","Complaint Condition","Condtion Detail","Location",null,"Looking for a list of complaint category codes or disposition codes?"]
["2010-02-23",5085701,"1E","HEAT-PLANT","HEAT-SMOKING","BASEMENT",null,"(Adobe Acrobat Reader required)"]
["2010-02-23",5085701,"1E","TOILET","BOWL REMOVED","BATHROOM",null,"Complaint","Address","Date","Category","Inspection","Disposition","Status"]
["2010-02-23",5085701,"1E","WATER-SUPPLY","WATER-SUPPLY","ENTIRE APT",null,"Number",null,"Entered",null,"Date"]
["2010-02-23",5085701,"1E","SHOWER-STALL","SHOWER","BATHROOM",null,1241349,"160 VERMILYEA AVENUE","2008-11-06",45,"2008-12-22","C2","CLS"]
["2010-02-23",5085701,"1E","MOLD","MOLD","ENTIRE APT",null,1202469,"160 VERMILYEA AVENUE","2007-08-26",45,"2007-09-14","I2","RES"]
["2010-02-23",5085701,"1E","BASIN/SINK","PIPE-BROKEN","BATHROOM",null,1181436,"160 VERMILYEA AVENUE","2006-12-06",5,"2006-12-08","H1","RES"]
["2010-02-23",5085701,"1E","DOORS","BROKEN","ENTRANCE",null,1181239,"160 VERMILYEA AVENUE","2006-12-04",5,"2007-03-09","L2","RES"]
["2010-02-23",5085701,"1E","CEILING","BULGING/LOOSE","KITCHEN",null,1179551,"160 VERMILYEA AVENUE","2006-11-10",5,"2006-11-22","C2","CLS"]
["2010-02-23",5085701,"1E","HEAT","NO HEAT/WATER","ENTIRE APT",null,1169665,"160 VERMILYEA AVENUE","2006-07-03",58,"2006-10-25","A1","RES"]
["2010-02-23",5085701,"1E","TOILET","TANK-CRACKED","BATHROOM",null,1130001,"160 VERMILYEA AVENUE","2004-10-06",45,"2004-10-14","A9","RES"]
["2010-02-23",5085701,"1E","VERMIN","BEDBUGS","ENTIRE APT",null,1129999,"160 VERMILYEA AVENUE","2004-10-06",73,"2004-10-14","I2","RES"]
["2010-02-23",5085701,"1E","VERMIN","RATS","ENTIRE APT",null,1034320,"158 VERMILYEA AVENUE","1995-04-12",73,"1997-08-05","C2","CLS"]
["2010-02-23",5085701,"1E","DOORS","BROKEN","LOBBY",null,1028535,"158 VERMILYEA AVENUE","1994-03-21",30,"1994-03-22","I2","RES"]
["2010-02-18",5079978,"1E","VERMIN","RATS","ENTIRE APT"]
["2010-02-18",5079978,"1E","VERMIN","ROACHES","ENTIRE APT"]
["2010-02-18",5079978,"1E","TOILET","TANK-CRACKED","BATHROOM"]
["2010-02-18",5079978,"1E","HEAT","NO HEAT/WATER","ENTIRE BUILDING"]
["2010-02-18",5079978,"1E","HEAT-PLANT","BOILER INOP/MIS","ENTIRE BUILDING"]
["2010-02-08",5065642,"3D","VERMIN","RATS","ENTIRE APT"]
["2010-02-08",5065642,"3D","WATER-LEAKS","CONT ABOVE APT","BATHROOM"]
["2010-02-08",5065642,"3D","CEILING","COLLAPSING","BATHROOM"]
["2010-02-08",5065642,"3D","VERMIN","ROACHES","ENTIRE APT"]
["2010-01-28",5042189,"D","CEILING","HOLE","KITCHEN"]
["2010-01-28",5042189,"D","MOLD","MOLD","LIVING ROOM"]
["2010-01-28",5042189,"D","MOLD","MOLD","BATHROOM"]
["2010-01-28",5042189,"D","MOLD","MOLD","KITCHEN"]
["2010-01-28",5042189,"D","WATER-LEAKS","CONT ABOVE APT","KITCHEN"]
["2010-01-28",5042189,"D","SEWER","DRAIN","KITCHEN"]
["2010-01-28",5042175,"D","HEAT","NO HEAT","ENTIRE BUILDING"]
["2010-01-26",5039458,"4E","HEAT","NO HEAT","ENTIRE APT"]
["2010-01-09",5012124,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2010-01-02",4993516,"C","HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-12-29",4986945,"2B","HEAT","NO HEAT","ENTIRE APT"]
["2009-12-29",4984107,"4B","HEAT","NO HEAT","BEDROOM"]
["2009-12-22",4970409,"3A","HEAT","NO HEAT","ENTIRE APT"]
["2009-12-18",4963177,"BSMT","HEAT","NO HEAT","ENTIRE APT"]
["2009-12-13",4950321,"4D","HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-12-13",4950289,"4B","HEAT","NO HEAT","ENTIRE APT"]
["2009-12-13",4950201,"4E","HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-12-11",4943780,"C","HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-12-10",4942199,"4C","HEAT","NO HEAT","ENTIRE APT"]
["2009-12-06",4930190,"4C","HEAT","NO HEAT","ENTIRE APT"]
["2009-12-04",4928263,"4C","HEAT","NO HEAT","ENTIRE APT"]
["2009-11-04",4882834,"2D","HEAT","NO HEAT","ENTIRE APT"]
["2009-10-14",4842762,"2B","HEAT","NO HEAT","ENTIRE APT"]
["2009-06-27",4766215,"BLDG","ROOF","DOOR/SCUTTLE/LO","ENTIRE BUILDING"]
["2009-05-12",4735906,"D","HEAT","NO HOT WATER","ENTIRE APT"]
["2009-05-11",4735194,"D","HEAT","NO HOT WATER","ENTIRE APT"]
["2009-05-08",4733343,"D","HEAT","NO HOT WATER","ENTIRE APT"]
["2009-05-07",4733080,"BLDG","HEAT","NO HOT WATER","ENTIRE BUILDING"]
["2009-04-24",4722527,"D","WATER-LEAKS","CONT ABOVE APT","BATHROOM"]

{"sheet":"154 Vermilyea Ave","index":6,"n_rows":24,"n_cols":14,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Complaint Date","Complaint#","Apt#","Complaint Condition","Condtion Detail","Location",null,"Looking for a list of complaint category codes or disposition codes?"]
["2010-04-03",5133715,2,"VERMIN","MICE","ENTIRE APT",null,"(Adobe Acrobat Reader required)"]
["2010-04-03",5133715,2,"BASIN/SINK","FAUCET-BROKEN","KITCHEN",null,"Complaint","Address","Date","Category","Inspection","Disposition","Status"]
["2010-04-03",5133715,2,"TOILET","BOWL-LEAKING","BATHROOM",null,"Number",null,"Entered",null,"Date"]
["2010-04-03",5133715,2,"BATHTUB","FAUCET","BATHROOM",null,1218073,"154 VERMILYEA AVENUE","2008-03-10",31,"2008-04-16","I2","RES"]
["2010-04-03",5133715,2,"REFRIGERATOR","INOPERATIVE","KITCHEN",null,1218072,"154 VERMILYEA AVENUE","2008-03-10",45,"2008-04-16","I2","RES"]
["2010-04-03",5133715,2,"VERMIN","RATS","BASEMENT",null,1216429,"154 VERMILYEA AVENUE","2008-02-24",5,"2008-03-10","I2","RES"]
["2010-03-04",5099181,22,"HEAT","NO HEAT/WATER","ENTIRE APT",null,1202468,"154 VERMILYEA AVENUE","2007-08-26",45,"2007-09-15","A9","RES"]
["2010-02-27",5092387,2,"HEAT","NO HOT WATER","ENTIRE APT",null,1187113,"154-160 VERMILYEA AVENU","2007-02-26",45,"2007-03-13","I2","RES"]
["2010-02-15",5075154,43,"HEAT","NO HEAT/WATER","ENTIRE APT",null,1130007,"154 VERMILYEA AVENUE","2004-10-06",45,"2004-10-14","I2","RES"]
["2010-02-15",5075066,44,"HEAT","NO HEAT/WATER","ENTIRE BUILDING",null,1130005,"154 VERMILYEA AVENUE","2004-10-06",73,"2004-10-14","I2","RES"]
["2010-02-14",5074291,44,"HEAT","NO HEAT/WATER","ENTIRE APT",null,1053127,"154 VERMILYEA AVENUE","1997-11-03",73,"1997-12-16","C2","CLS"]
["2010-02-14",5074131,51,"HEAT","NO HEAT/WATER","ENTIRE APT",null,1021617,"154 VERMILYEA AVENUE","1992-10-26",56,"1992-10-27","I2","RES"]
["2010-01-18",5028253,2,"HEAT","NO HEAT/WATER","ENTIRE BUILDING",null,1013590,"154 VERMILYEA AVENUE","1991-05-23",73,"1992-09-22","XX","RES"]
["2009-12-21",4969180,24,"BATHTUB","FAUCET","BATHROOM"]
["2009-12-21",4969180,24,"MOLD","MOLD","BATHROOM"]
["2009-12-21",4969180,24,"WATER-SUPPLY","SCALDING","BATHROOM"]
["2009-10-14",4844123,23,"HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-08-11",4794777,25,"BASIN/SINK","LEAKY PIPE","KITCHEN"]
["2009-08-11",4794777,25,"FLOOR","BROKE / DEF","KITCHEN"]
["2009-08-11",4794777,25,"BASIN/SINK","CHIPPING","KITCHEN"]
["2009-04-30",4727426,51,"MOLD","MOLD","BATHROOM"]
["2009-04-15",4714957,55,"BELL-BUZZER/INT","INOPER/ MISSING","ENTIRE BUILDING"]
["2009-04-13",4712217,2,"BELL-BUZZER/INT","INOPER/ MISSING","ENTIRE BUILDING"]

{"sheet":"150 Vermilyea Ave","index":7,"n_rows":48,"n_cols":14,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
["Complaint Date","Complaint#","Apt#","Complaint Condition","Condtion Detail","Location",null,"Looking for a list of complaint category codes or disposition codes?"]
["2010-03-30",5129261,41,"BASIN/SINK","PIPE-BROKEN","BATHROOM",null,"(Adobe Acrobat Reader required)"]
["2010-03-30",5129261,41,"WALLS","PAINT DIRTY","FOYER",null,"Complaint","Address","Date","Category","Inspection","Disposition","Status"]
["2010-03-30",5129261,41,"FLOOR","FLOOR-TORN","LIVING ROOM",null,"Number",null,"Entered",null,"Date"]
["2010-03-30",5129261,41,"WALLS","CRACKED","FOYER",null,1218074,"150 VERMILYEA AVENUE","2008-03-10",45,"2008-04-16","I2","RES"]
["2010-03-30",5129261,41,"BASIN/SINK","FAUCET-BROKEN","KITCHEN",null,1202467,"150 VERMILYEA AVENUE","2007-08-26",45,"2007-09-15","A9","RES"]
["2010-03-30",5129261,41,"BATHTUB","FAUCET","BATHROOM",null,1178854,"150 VERMILYEA AVENUE","2006-11-01",10,"2006-11-01","A9","RES"]
["2010-03-05",5099601,5,"FLOOR","LARGE HOLE","BEDROOM",null,1178423,"150 VERMILYEA AVENUE","2006-10-27",3,"2006-12-06","L2","RES"]
["2010-03-05",5099601,5,"CERAMIC-TILE","MISSING-FLOOR","BATHROOM",null,1078658,"150 VERMILYEA AVENUE","2000-08-15",73,"2000-08-16","C2","CLS"]
["2010-03-05",5099601,5,"CERAMIC-TILE","LOOSE-WALL","BATHROOM",null,1077980,"150 VERMILYEA AVENUE","2000-07-25",73,"2000-08-03","C2","CLS"]
["2010-03-05",5099601,5,"BASIN/SINK","LEAKY PIPE","BATHROOM",null,1073067,"150 VERMILYEA AVENUE","2000-01-21",41,"2000-01-25","A9","RES"]
["2010-03-05",5099601,5,"FLOOR","LARGE-AREA","KITCHEN",null,1012546,"150 VERMILYEA AVENUE","1991-04-05",56,"1991-04-19","A1","RES"]
["2010-03-05",5099601,5,"WINDOWS","BROKEN FRAME","KITCHEN"]
["2010-03-05",5099601,5,"ELEC/GAS-RANGE","PILOT LIGHT INO","KITCHEN"]
["2010-03-05",5099601,5,"RADIATOR","CRACKED/MISSING","ENTIRE APT"]
["2010-02-23",5086537,25,"WATER-LEAKS","CASCADING","BEDROOM"]
["2010-02-22",5084322,25,"WATER-LEAKS","CONT ABOVE APT","BEDROOM"]
["2010-02-22",5084322,25,"CEILING","PLASTER PEELING","BEDROOM"]
["2010-02-07",5064259,24,"HEAT","NO HEAT/WATER","ENTIRE APT"]
["2010-02-04",5059893,33,"HEAT","NO HEAT","ENTIRE APT"]
["2010-02-04",5059600,51,"HEAT","NO HEAT/WATER","ENTIRE APT"]
["2010-02-04",5059600,51,"WATER-LEAKS","ROOF-LEAK","BEDROOM 2"]
["2010-02-04",5059600,51,"MOLD","MOLD","BEDROOM 2"]
["2010-01-31",5050462,33,"HEAT","NO HEAT","ENTIRE BUILDING"]
["2010-01-29",5045065,55,"HEAT","NO HEAT","ENTIRE BUILDING"]
["2010-01-25",5037229,33,"HEAT","NO HEAT","ENTIRE APT"]
["2010-01-15",5025414,24,"HEAT","NO HOT WATER","ENTIRE APT"]
["2010-01-08",5009197,55,"HEAT","NO HEAT/WATER","ENTIRE APT"]
["2010-01-07",5007370,33,"HEAT","NO HEAT","ENTIRE APT"]
["2010-01-05",5002958,33,"HEAT","NO HEAT/WATER","ENTIRE APT"]
["2009-12-24",4976483,33,"HEAT","NO HEAT/WATER","ENTIRE BUILDING"]
["2009-12-23",4973282,1,"HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-12-20",4967475,33,"HEAT","NO HEAT/WATER","ENTIRE APT"]
["2009-12-20",4966911,33,"HEAT","NO HEAT","ENTIRE APT"]
["2009-12-18",4962909,33,"HEAT","NO HEAT","ENTIRE APT"]
["2009-12-17",4959331,5,"HEAT","NO HEAT/WATER","ENTIRE APT"]
["2009-12-13",4950089,25,"HEAT","NO HEAT/WATER","ENTIRE APT"]
["2009-12-11",4945299,25,"HEAT","NO HEAT/WATER","ENTIRE APT"]
["2009-12-11",4945014,25,"HEAT","NO HEAT","ENTIRE APT"]
["2009-12-06",4931356,24,"HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-12-05",4929541,33,"HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-11-06",4888003,33,"HEAT","NO HEAT","ENTIRE APT"]
["2009-08-12",4795276,1,"CEILING","COLLAPSING","LIVING ROOM"]
["2009-08-12",4795276,1,"CEILING","PLASTER PEELING","LIVING ROOM"]
["2009-08-12",4795276,1,"WALLS","PEELING","LIVING ROOM"]
["2009-08-12",4795276,1,"WATER-LEAKS","CEILING","LIVING ROOM"]
["2009-08-12",4795276,1,"LIGHTING","LIGHTS-FLOOR","PUBLIC HALL"]
["2009-08-12",4795276,1,"WINDOWS","FIRE ESCAPE","KITCHEN"]

{"sheet":"554 West 148 Street","index":8,"n_rows":16,"n_cols":14,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Complaint Date","Complaint#","Apt#","Complaint Condition","Condtion Detail","Location",null,"Looking for a list of complaint category codes or disposition codes?"]
["2010-03-27",5124567,23,"HEAT","NO HEAT","ENTIRE APT",null,"(Adobe Acrobat Reader required)"]
["2010-01-28",5043157,22,"HEAT","NO HEAT","ENTIRE APT",null,"Complaint","Address","Date","Category","Inspection","Disposition","Status"]
["2010-01-14",5022809,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING",null,"Number",null,"Entered",null,"Date"]
["2010-01-11",5017016,51,"HEAT","NO HEAT","ENTIRE APT",null,1184407,"554 WEST 148 STREET","2007-01-23",5,"2007-01-27","I2","RES"]
["2010-01-11",5016604,22,"HEAT","NO HEAT","ENTIRE BUILDING",null,1129818,"554 WEST 148 STREET","2004-10-01",45,"2004-10-15","C2","CLS"]
["2009-12-26",4978763,51,"HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-12-25",4978330,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-11-18",4904454,24,"HEAT","NO HEAT","ENTIRE APT"]
["2009-11-13",4898554,52,"HEAT","NO HEAT/WATER","ENTIRE APT"]
["2009-11-13",4898554,52,"HEAT","NO HEAT/WATER","ENTIRE BUILDING"]
["2009-11-13",4898110,"BLDG","HEAT","NO HEAT/WATER","ENTIRE BUILDING"]
["2009-11-11",4893447,2,"HEAT","NO HEAT/WATER","ENTIRE BUILDING"]
["2009-10-30",4875417,41,"HEAT","NO HEAT/WATER","ENTIRE BUILDING"]
["2009-10-13",4841564,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-09-09",4814696,33,"VERMIN","BEDBUGS","ENTIRE APT"]

{"sheet":"522 West 148 Street","index":9,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Complaint Date","Complaint#","Apt#","Complaint Condition","Condtion Detail","Location",null,"Looking for a list of complaint category codes or disposition codes?"]
["2009-12-25",4978432,"2D","HEAT","NO HEAT/WATER","ENTIRE APT",null,"(Adobe Acrobat Reader required)"]
["2009-12-20",4966613,"2D","HEAT","NO HEAT/WATER","ENTIRE BUILDING",null,"Complaint","Address","Date","Category","Inspection","Disposition","Status"]
["2009-12-20",4966081,"A","HEAT","NO HEAT","ENTIRE BUILDING",null,"Number",null,"Entered",null,"Date"]
["2009-12-19",4964626,"1A","HEAT","NO HEAT","ENTIRE APT",null,1054598,"522 WEST 148 STREET","1998-01-13",43,"1998-01-15","C2","CLS"]
["2009-12-17",4959119,"2D","HEAT","NO HEAT/WATER","ENTIRE BUILDING"]
["2009-12-06",4931849,"A","HEAT","NO HEAT","ENTIRE APT"]
["2009-11-30",4920042,"A","HEAT","NO HEAT","ENTIRE APT"]
["2009-11-24",4912382,"A","HEAT","NO HEAT","ENTIRE APT"]
["2009-11-19",4905947,"A","HEAT","NO HEAT","ENTIRE APT"]
["2009-10-17",4855506,"2B","HEAT","NO HEAT","ENTIRE APT"]
["2009-10-15",4849476,"3A","HEAT","NO HEAT","ENTIRE APT"]
["2009-04-20",4718370,"4D","HEAT","NO HOT WATER","ENTIRE APT"]

{"sheet":"510 West 148 Street","index":10,"n_rows":32,"n_cols":14,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Complaint Date","Complaint#","Apt#","Complaint Condition","Condtion Detail","Location",null,"Looking for a list of complaint category codes or disposition codes?"]
["2010-02-26",5090982,8,"HEAT","NO HEAT","ENTIRE BUILDING",null,"(Adobe Acrobat Reader required)"]
["2010-02-26",5090810,6,"HEAT","NO HEAT","ENTIRE APT",null,"Complaint","Address","Date","Category","Inspection","Disposition","Status"]
["2010-02-16",5076845,7,"CEILING","CRACKED","BEDROOM",null,"Number",null,"Entered",null,"Date"]
["2010-02-16",5076845,7,"RADIATOR","RADIATOR-LEAK","BEDROOM",null,1220398,"510 WEST 148 STREET","2008-03-31",5,"2008-05-21","A9","RES"]
["2010-02-16",5076845,7,"WATER-LEAKS","CONT ABOVE APT","BEDROOM",null,1196754,"510 WEST 148 STREET","2007-06-20",45,"2007-07-02","C2","CLS"]
["2010-02-01",5053207,16,"MOLD","MOLD","ENTIRE APT",null,1188813,"510 WEST 148 STREET","2007-03-15",37,"2007-03-17","C2","CLS"]
["2010-01-14",5023092,18,"HEAT","NO HEAT","ENTIRE APT",null,1188811,"510 WEST 148 STREET","2007-03-15","4A",null,null,"ACT"]
["2010-01-06",5005718,16,"HEAT","NO HEAT","ENTIRE APT",null,1187960,"510 WEST 148 STREET","2007-03-06",37,"2007-03-08","C2","CLS"]
["2010-01-06",5005718,16,"CEILING","COLLAPSING","BATHROOM",null,1085550,"510 WEST 148 STREET","2001-03-21",73,"2001-03-27","A9","RES"]
["2009-12-29",4986118,4,"HEAT","NO HEAT","ENTIRE BUILDING",null,1054100,"510 WEST 148 STREET","1997-12-17",73,"1998-04-28","I2","RES"]
["2009-12-24",4977112,8,"HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-12-23",4973536,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-12-21",4969584,16,"MOLD","MOLD","ENTIRE APT"]
["2009-12-21",4969584,16,"HEAT","NO HEAT","ENTIRE APT"]
["2009-12-11",4946571,21,"HEAT","NO HEAT","ENTIRE APT"]
["2009-12-06",4931219,16,"MOLD","MOLD","BEDROOM 2"]
["2009-12-06",4931219,16,"MOLD","MOLD","BEDROOM"]
["2009-12-06",4931219,16,"HEAT","NO HEAT","ENTIRE APT"]
["2009-12-06",4931219,16,"MOLD","MOLD","BEDROOM 3"]
["2009-12-05",4929824,8,"HEAT","NO HEAT","ENTIRE APT"]
["2009-11-23",4912114,1,"HEAT","NO HEAT","ENTIRE APT"]
["2009-11-21",4908652,8,"HEAT","NO HEAT","ENTIRE APT"]
["2009-11-19",4906342,6,"HEAT","NO HEAT","ENTIRE APT"]
["2009-10-19",4860752,6,"HEAT","NO HEAT","ENTIRE APT"]
["2009-10-16",4853476,8,"HEAT","NO HEAT","ENTIRE APT"]
["2009-07-30",4786786,7,"WATER-LEAKS","CONT ABOVE APT","BATHROOM"]
["2009-07-30",4786786,7,"CEILING","PLASTER PEELING","BATHROOM"]
["2009-07-30",4786786,7,"CEILING","PLASTER PEELING","KITCHEN"]
["2009-07-30",4786786,7,"CEILING","CRACKED","KITCHEN"]
["2009-07-30",4786786,7,"VERMIN","ROACHES","KITCHEN"]
["2009-07-30",4786786,7,"CABINETS","DEFECTIVE","KITCHEN"]

{"sheet":"507 West 139 Street","index":11,"n_rows":31,"n_cols":14,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["Complaint Date","Complaint#","Apt#","Complaint Condition","Condtion Detail","Location",null,"Looking for a list of complaint category codes or disposition codes?"]
["2009-12-08",4937186,"4A","HEAT","NO HEAT","ENTIRE BUILDING",null,"(Adobe Acrobat Reader required)"]
["2009-12-08",4937054,"1C","HEAT","NO HEAT","ENTIRE BUILDING",null,"Complaint","Address","Date","Category","Inspection","Disposition","Status"]
["2009-12-07",4934915,"5D","HEAT","NO HEAT","ENTIRE APT",null,"Number",null,"Entered",null,"Date"]
["2009-12-07",4934576,"1A","HEAT","NO HEAT","ENTIRE BUILDING",null,1176364,"507 WEST 139 STREET","2006-10-02",45,"2006-10-12","C2","CLS"]
["2009-12-04",4928384,"5D","HEAT","NO HEAT","ENTIRE APT",null,1098505,"507 WEST 139 STREET","2002-07-05",59,"2002-07-16","A1","RES"]
["2009-05-08",4733520,"BLDG","HEAT","NO HEAT","ENTIRE BUILDING"]
["2009-05-08",4733517,"2B","CEILING","CRACKED","KITCHEN"]
["2009-05-08",4733517,"2B","WATER-LEAKS","CONT ABOVE APT","KITCHEN"]
["2009-05-08",4733517,"2B","CEILING","CRACKED","BEDROOM"]
["2009-05-08",4733515,"4C","WATER-LEAKS","CONT ABOVE APT","LIVING ROOM"]
["2009-05-08",4733515,"4C","MOLD","MOLD","LIVING ROOM"]
["2009-05-08",4733515,"4C","MOLD","MOLD","BEDROOM 2"]
["2009-05-08",4733515,"4C","MOLD","MOLD","BEDROOM"]
["2009-05-08",4733515,"4C","CEILING","HOLE","LIVING ROOM"]
["2009-05-08",4733515,"4C","CEILING","HOLE","BEDROOM 2"]
["2009-05-08",4733515,"4C","CEILING","HOLE","BEDROOM"]
["2009-05-08",4733515,"4C","WATER-LEAKS","CONT ABOVE APT","BEDROOM 2"]
["2009-05-08",4733515,"4C","WATER-LEAKS","CONT ABOVE APT","BEDROOM"]
["2009-05-08",4733510,"1D","WATER-LEAKS","CASCADING","BATHROOM"]
["2009-05-01",4728005,"5A","CARBON MONOXIDE","DEF / MISS","ENTIRE APT"]
["2009-05-01",4728005,"5A","WATER-LEAKS","CASCADING","BEDROOM"]
["2009-05-01",4728005,"5A","SMOKE-DETECTOR","DEFECT/MISSING","ENTIRE APT"]
["2009-05-01",4728005,"5A","CEILING","CRACKED","BEDROOM"]
["2009-05-01",4727998,"5D","VERMIN","ROACHES","ENTIRE APT"]
["2009-05-01",4727998,"5D","MOLD","MOLD","BEDROOM"]
["2009-05-01",4727998,"5D","MOLD","MOLD","KITCHENETTE"]
["2009-05-01",4727998,"5D","WATER-LEAKS","ROOF-LEAK","LIVING ROOM"]
["2009-05-01",4727998,"5D","HEAT","NO HOT WATER","BATHROOM"]
["2009-05-01",4727998,"5D","MOLD","MOLD","BATHROOM"]
["2009-05-01",4727998,"5D","MOLD","MOLD","PRIVATE HALL"]

{"sheet":"516 West 136 Street","index":12,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Complaint Date","Complaint#","Apt#","Complaint Condition","Condtion Detail","Location",null,"Looking for a list of complaint category codes or disposition codes?"]
["2010-01-05",5004312,31,"RADIATOR","RADIATOR-BROKEN","LIVING ROOM",null,"(Adobe Acrobat Reader required)"]
["2010-01-05",5004312,31,"WINDOWS","BROKEN FRAME","BEDROOM 2",null,"Complaint","Address","Date","Category","Inspection","Disposition","Status"]
["2010-01-05",5004312,31,"RADIATOR","RADIATOR-BROKEN","BEDROOM 2",null,"Number",null,"Entered",null,"Date"]
["2010-01-05",5004312,31,"RADIATOR","RADIATOR-BROKEN","BEDROOM",null,1076965,"516 WEST 136 STREET","2000-06-20",43,"2000-06-20","B1","RES"]
["2010-01-05",5004312,31,"WINDOWS","BROKEN FRAME","BEDROOM",null,1069069,"516 WEST 136 STREET","1999-08-05",43,"1999-08-09","I2","RES"]
["2009-12-12",4949027,23,"HEAT","NO HEAT","ENTIRE APT"]
["2009-11-14",4900319,22,"HEAT","NO HOT WATER","ENTIRE APT"]
["2009-11-03",4880220,22,"HEAT","NO HOT WATER","ENTIRE APT"]
["2009-11-03",4879583,22,"HEAT","NO HOT WATER","ENTIRE BUILDING"]