{"rows":[{"cartodb_id":309103,"the_geom":"0101000020E6100000C07BCDDD5AC752C054B7D15CB3FF4340","the_geom_webmercator":"0101000020110F0000CA82C1B0C6E55FC16BDECF9A908F5241","assessment_date":"2026-04-29T15:47:20Z","basements":"D","beginning_point":"58'3\" E OF G ST","book_and_page":"52635363","building_code":"O30","building_code_description":"ROW 2 STY MASONRY","category_code":"1","category_code_description":"SINGLE FAMILY","census_tract":"177","central_air":"N","cross_reference":null,"date_exterior_condition":null,"depth":50,"exempt_building":0,"exempt_land":0,"exterior_condition":"4","fireplaces":0,"frontage":14,"fuel":null,"garage_spaces":0,"garage_type":null,"general_construction":"A","geographic_ward":"33","homestead_exemption":0,"house_extension":null,"house_number":"809","interior_condition":"4","location":"809 E MADISON ST","mailing_address_1":null,"mailing_address_2":null,"mailing_care_of":null,"mailing_city_state":"PHILADELPHIA PA","mailing_street":"2415 N ORIANNA ST","mailing_zip":"19133","market_value":69100,"market_value_date":null,"number_of_bathrooms":1,"number_of_bedrooms":3,"number_of_rooms":null,"number_stories":2,"off_street_open":818,"other_building":null,"owner_1":"REYES MARIA E","owner_2":null,"parcel_number":"331073600","parcel_shape":"E","quality_grade":"C","recording_date":"2013-05-07T04:00:00Z","registry_number":"039N190095","sale_date":"2013-03-18T04:00:00Z","sale_price":1,"separate_utilities":null,"sewer":null,"site_type":null,"state_code":"PA","street_code":"52840","street_designation":"ST","street_direction":"E","street_name":"MADISON","suffix":null,"taxable_building":55280,"taxable_land":13820,"topography":"F","total_area":713,"total_livable_area":1198,"type_heater":"H","unfinished":null,"unit":null,"utility":null,"view_type":"I","year_built":"1920","year_built_estimate":"Y","zip_code":"19134","zoning":"RSA5","pin":1001340998,"building_code_new":"22","building_code_description_new":"ROW TYPICAL","gdb_geomattr_data":null,"objectid":309051}],"time":0.001,"fields":{"cartodb_id":{"type":"number","pgtype":"int8"},"the_geom":{"type":"geometry","wkbtype":"Unknown","dims":2,"srid":4326},"the_geom_webmercator":{"type":"geometry","wkbtype":"Unknown","dims":2,"srid":3857},"assessment_date":{"type":"date","pgtype":"timestamptz"},"basements":{"type":"string","pgtype":"varchar"},"beginning_point":{"type":"string","pgtype":"varchar"},"book_and_page":{"type":"string","pgtype":"varchar"},"building_code":{"type":"string","pgtype":"varchar"},"building_code_description":{"type":"string","pgtype":"varchar"},"category_code":{"type":"string","pgtype":"varchar"},"category_code_description":{"type":"string","pgtype":"varchar"},"census_tract":{"type":"string","pgtype":"varchar"},"central_air":{"type":"string","pgtype":"varchar"},"cross_reference":{"type":"string","pgtype":"varchar"},"date_exterior_condition":{"type":"date","pgtype":"timestamptz"},"depth":{"type":"number","pgtype":"numeric"},"exempt_building":{"type":"number","pgtype":"numeric"},"exempt_land":{"type":"number","pgtype":"numeric"},"exterior_condition":{"type":"string","pgtype":"varchar"},"fireplaces":{"type":"number","pgtype":"int4"},"frontage":{"type":"number","pgtype":"numeric"},"fuel":{"type":"string","pgtype":"varchar"},"garage_spaces":{"type":"number","pgtype":"int4"},"garage_type":{"type":"string","pgtype":"varchar"},"general_construction":{"type":"string","pgtype":"varchar"},"geographic_ward":{"type":"string","pgtype":"varchar"},"homestead_exemption":{"type":"number","pgtype":"int4"},"house_extension":{"type":"string","pgtype":"varchar"},"house_number":{"type":"string","pgtype":"varchar"},"interior_condition":{"type":"string","pgtype":"varchar"},"location":{"type":"string","pgtype":"varchar"},"mailing_address_1":{"type":"string","pgtype":"varchar"},"mailing_address_2":{"type":"string","pgtype":"varchar"},"mailing_care_of":{"type":"string","pgtype":"varchar"},"mailing_city_state":{"type":"string","pgtype":"varchar"},"mailing_street":{"type":"string","pgtype":"varchar"},"mailing_zip":{"type":"string","pgtype":"varchar"},"market_value":{"type":"number","pgtype":"numeric"},"market_value_date":{"type":"date","pgtype":"timestamptz"},"number_of_bathrooms":{"type":"number","pgtype":"int4"},"number_of_bedrooms":{"type":"number","pgtype":"int4"},"number_of_rooms":{"type":"number","pgtype":"int4"},"number_stories":{"type":"number","pgtype":"int4"},"off_street_open":{"type":"number","pgtype":"int4"},"other_building":{"type":"string","pgtype":"varchar"},"owner_1":{"type":"string","pgtype":"varchar"},"owner_2":{"type":"string","pgtype":"varchar"},"parcel_number":{"type":"string","pgtype":"varchar"},"parcel_shape":{"type":"string","pgtype":"varchar"},"quality_grade":{"type":"string","pgtype":"varchar"},"recording_date":{"type":"date","pgtype":"timestamptz"},"registry_number":{"type":"string","pgtype":"varchar"},"sale_date":{"type":"date","pgtype":"timestamptz"},"sale_price":{"type":"number","pgtype":"numeric"},"separate_utilities":{"type":"string","pgtype":"varchar"},"sewer":{"type":"string","pgtype":"varchar"},"site_type":{"type":"string","pgtype":"varchar"},"state_code":{"type":"string","pgtype":"varchar"},"street_code":{"type":"string","pgtype":"varchar"},"street_designation":{"type":"string","pgtype":"varchar"},"street_direction":{"type":"string","pgtype":"varchar"},"street_name":{"type":"string","pgtype":"varchar"},"suffix":{"type":"string","pgtype":"varchar"},"taxable_building":{"type":"number","pgtype":"numeric"},"taxable_land":{"type":"number","pgtype":"numeric"},"topography":{"type":"string","pgtype":"varchar"},"total_area":{"type":"number","pgtype":"numeric"},"total_livable_area":{"type":"number","pgtype":"numeric"},"type_heater":{"type":"string","pgtype":"varchar"},"unfinished":{"type":"string","pgtype":"varchar"},"unit":{"type":"string","pgtype":"varchar"},"utility":{"type":"string","pgtype":"varchar"},"view_type":{"type":"string","pgtype":"varchar"},"year_built":{"type":"string","pgtype":"varchar"},"year_built_estimate":{"type":"string","pgtype":"varchar"},"zip_code":{"type":"string","pgtype":"varchar"},"zoning":{"type":"string","pgtype":"varchar"},"pin":{"type":"number","pgtype":"int4"},"building_code_new":{"type":"string","pgtype":"varchar"},"building_code_description_new":{"type":"string","pgtype":"varchar"},"gdb_geomattr_data":{"type":"bytea","pgtype":"bytea"},"objectid":{"type":"number","pgtype":"int4"}},"total_rows":1}