{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "

| \n", " | Address | \n", "VacantDate | \n", "Dwelling | \n", "Vacant_Building_Category | \n", "Ward | \n", "District | \n", "Census_Tract | \n", "Coordinates | \n", "DistrictCouncilMap | \n", "CouncilWard | \n", "Gunk1 | \n", "Gunk2 | \n", "Latitude | \n", "Longitude | \n", "Datetime | \n", "Year | \n", "Date | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "937 SHERBURNE AVE | \n", "04/30/2019 12:00:00 AM | \n", "Duplex | \n", "2 | \n", "1.0 | \n", "7.0 | \n", "32500.0 | \n", "(44.9567603300828, -93.139762414751) | \n", "10.0 | \n", "7.0 | \n", "55.0 | \n", "47.0 | \n", "44.95676 | \n", "-93.139762 | \n", "2019-04-30 | \n", "2019 | \n", "2019-04-30 | \n", "
| 1 | \n", "535 FOREST ST | \n", "04/26/2019 12:00:00 AM | \n", "Single Family Residential | \n", "2 | \n", "7.0 | \n", "4.0 | \n", "34500.0 | \n", "(44.957410404869, -93.061161243197) | \n", "15.0 | \n", "2.0 | \n", "196.0 | \n", "42.0 | \n", "44.95741 | \n", "-93.061161 | \n", "2019-04-26 | \n", "2019 | \n", "2019-04-26 | \n", "
| \n", " | address | \n", "census_tract | \n", "district | \n", "dwelling_type | \n", "map_location | \n", "sale_review_category | \n", "vacant_as_of | \n", "ward | \n", "
|---|---|---|---|---|---|---|---|---|
| 0 | \n", "937 SHERBURNE AVE | \n", "32500 | \n", "7 | \n", "Duplex | \n", "{'latitude': '44.9567603300828', 'longitude': ... | \n", "2 | \n", "2019-04-30T00:00:00.000 | \n", "1 | \n", "
| 1 | \n", "535 FOREST ST | \n", "34500 | \n", "4 | \n", "Single Family Residential | \n", "{'latitude': '44.957410404869', 'longitude': '... | \n", "2 | \n", "2019-04-26T00:00:00.000 | \n", "7 | \n", "
| 2 | \n", "842 UNIVERSITY AVE W | \n", "33500 | \n", "8 | \n", "Single Family Residential | \n", "{'latitude': '44.9554819820147', 'longitude': ... | \n", "2 | \n", "2019-04-24T00:00:00.000 | \n", "1 | \n", "
| 3 | \n", "996 MARION ST | \n", "30800 | \n", "6 | \n", "Duplex | \n", "{'latitude': '44.97139072308', 'longitude': '-... | \n", "1 | \n", "2019-04-24T00:00:00.000 | \n", "5 | \n", "
| 4 | \n", "652 HALL AVE | \n", "37200 | \n", "3 | \n", "Duplex | \n", "{'latitude': '44.9263735950436', 'longitude': ... | \n", "3 | \n", "2019-04-22T00:00:00.000 | \n", "2 | \n", "
| 5 | \n", "792 DULUTH ST | \n", "31701 | \n", "4 | \n", "Duplex | \n", "{'latitude': '44.965291417806', 'longitude': '... | \n", "2 | \n", "2019-04-22T00:00:00.000 | \n", "6 | \n", "
| 6 | \n", "1400 UNIVERSITY AVE W | \n", "33400 | \n", "13 | \n", "Commercial | \n", "{'latitude': '44.9536084165855', 'longitude': ... | \n", "2 | \n", "2019-04-16T00:00:00.000 | \n", "1 | \n", "
| 7 | \n", "425 RICE ST | \n", "33700 | \n", "17 | \n", "Commercial | \n", "{'latitude': '44.9536181436373', 'longitude': ... | \n", "2 | \n", "2019-04-16T00:00:00.000 | \n", "1 | \n", "
| 8 | \n", "1440 MARSHALL AVE | \n", "33400 | \n", "13 | \n", "Commercial | \n", "{'latitude': '44.9482026685217', 'longitude': ... | \n", "2 | \n", "2019-04-10T00:00:00.000 | \n", "1 | \n", "
| 9 | \n", "218 PASCAL ST N | \n", "33400 | \n", "13 | \n", "Commercial | \n", "{'latitude': '44.9478738971447', 'longitude': ... | \n", "2 | \n", "2019-04-10T00:00:00.000 | \n", "1 | \n", "
| 10 | \n", "1876 MECHANIC AVE | \n", "31801 | \n", "2 | \n", "Single Family Residential | \n", "{'latitude': '44.9728379377429', 'longitude': ... | \n", "1 | \n", "2019-04-09T00:00:00.000 | \n", "6 | \n", "
| 11 | \n", "750 CHATSWORTH ST S | \n", "36700 | \n", "9 | \n", "Duplex | \n", "{'latitude': '44.9189407406274', 'longitude': ... | \n", "2 | \n", "2019-04-05T00:00:00.000 | \n", "2 | \n", "
| 12 | \n", "610 LARPENTEUR AVE E | \n", "30602 | \n", "5 | \n", "Duplex | \n", "{'latitude': '44.9917519986127', 'longitude': ... | \n", "2 | \n", "2019-04-03T00:00:00.000 | \n", "6 | \n", "
| 13 | \n", "25 JESSAMINE AVE E | \n", "30500 | \n", "6 | \n", "Single Family Residential | \n", "{'latitude': '44.9748357438782', 'longitude': ... | \n", "2 | \n", "2019-04-03T00:00:00.000 | \n", "5 | \n", "
| 14 | \n", "1739 CARROLL AVE | \n", "33400 | \n", "13 | \n", "Single Family Residential | \n", "{'latitude': '44.9505108931445', 'longitude': ... | \n", "2 | \n", "2019-04-03T00:00:00.000 | \n", "4 | \n", "
| 15 | \n", "1271 MARION ST | \n", "30800 | \n", "6 | \n", "Single Family Residential | \n", "{'latitude': '44.9795463927248', 'longitude': ... | \n", "1 | \n", "2019-04-01T00:00:00.000 | \n", "5 | \n", "
| 16 | \n", "240 COTTAGE AVE W | \n", "30400 | \n", "6 | \n", "Single Family Residential | \n", "{'latitude': '44.9826352633946', 'longitude': ... | \n", "2 | \n", "2019-03-25T00:00:00.000 | \n", "5 | \n", "
| 17 | \n", "1156 MARYLAND AVE E | \n", "31100 | \n", "5 | \n", "Single Family Residential | \n", "{'latitude': '44.9773487291127', 'longitude': ... | \n", "2 | \n", "2019-03-22T00:00:00.000 | \n", "6 | \n", "
| 18 | \n", "598 LAFOND AVE | \n", "32600 | \n", "7 | \n", "Single Family Residential | \n", "{'latitude': '44.9601196977974', 'longitude': ... | \n", "2 | \n", "2019-03-21T00:00:00.000 | \n", "1 | \n", "
| 19 | \n", "1734 7TH ST E | \n", "31801 | \n", "2 | \n", "Single Family Residential | \n", "{'latitude': '44.9664939992909', 'longitude': ... | \n", "2 | \n", "2019-03-21T00:00:00.000 | \n", "7 | \n", "
| 20 | \n", "1403 HAMLINE AVE N | \n", "30201 | \n", "10 | \n", "Single Family Residential | \n", "{'latitude': '44.9834949793758', 'longitude': ... | \n", "1 | \n", "2019-03-21T00:00:00.000 | \n", "4 | \n", "
| 21 | \n", "65 WINIFRED ST W | \n", "37100 | \n", "3 | \n", "Single Family Residential | \n", "{'latitude': '44.9316620044322', 'longitude': ... | \n", "1 | \n", "2019-03-19T00:00:00.000 | \n", "2 | \n", "
| 22 | \n", "1155 MARION ST | \n", "30800 | \n", "6 | \n", "Single Family Residential | \n", "{'latitude': '44.9759788153959', 'longitude': ... | \n", "2 | \n", "2019-03-19T00:00:00.000 | \n", "5 | \n", "
| 23 | \n", "941 CYPRESS ST | \n", "31600 | \n", "5 | \n", "Single Family Residential | \n", "{'latitude': '44.9697655636952', 'longitude': ... | \n", "2 | \n", "2019-03-14T00:00:00.000 | \n", "6 | \n", "
| 24 | \n", "1311 BURNS AVE | \n", "34601 | \n", "4 | \n", "Single Family Residential | \n", "{'latitude': '44.9488932778155', 'longitude': ... | \n", "1 | \n", "2019-03-14T00:00:00.000 | \n", "7 | \n", "
| 25 | \n", "817 BURR ST | \n", "31500 | \n", "5 | \n", "Multi-family Residential | \n", "{'latitude': '44.965869347891', 'longitude': '... | \n", "2 | \n", "2019-03-13T00:00:00.000 | \n", "5 | \n", "
| 26 | \n", "1144 FAIRMOUNT AVE | \n", "35300 | \n", "16 | \n", "Single Family Residential | \n", "{'latitude': '44.9366493090143', 'longitude': ... | \n", "2 | \n", "2019-03-13T00:00:00.000 | \n", "2 | \n", "
| 27 | \n", "2039 CASE AVE | \n", "31802 | \n", "2 | \n", "Single Family Residential | \n", "{'latitude': '44.9704609360422', 'longitude': ... | \n", "1 | \n", "2019-03-05T00:00:00.000 | \n", "6 | \n", "
| 28 | \n", "1241 6TH ST E | \n", "34601 | \n", "4 | \n", "Duplex | \n", "{'latitude': '44.9605260318585', 'longitude': ... | \n", "2 | \n", "2019-03-05T00:00:00.000 | \n", "7 | \n", "
| 29 | \n", "2060 3RD ST E | \n", "34702 | \n", "1 | \n", "Single Family Residential | \n", "{'latitude': '44.9565683001788', 'longitude': ... | \n", "1 | \n", "2019-03-05T00:00:00.000 | \n", "7 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 507 | \n", "1313 SEMINARY AVE | \n", "32300 | \n", "11 | \n", "Single Family Residential | \n", "{'latitude': '44.964887859907', 'longitude': '... | \n", "2 | \n", "2008-06-05T00:00:00.000 | \n", "4 | \n", "
| 508 | \n", "474 CURTICE ST E | \n", "37200 | \n", "3 | \n", "Single Family Residential | \n", "{'latitude': '44.922858156184', 'longitude': '... | \n", "2 | \n", "2008-03-29T00:00:00.000 | \n", "2 | \n", "
| 509 | \n", "1020 CARROLL AVE | \n", "33800 | \n", "8 | \n", "Single Family Residential | \n", "{'latitude': '44.9501237852992', 'longitude': ... | \n", "2 | \n", "2008-03-12T00:00:00.000 | \n", "1 | \n", "
| 510 | \n", "50 FILLMORE AVE E | \n", "37100 | \n", "3 | \n", "Commercial | \n", "{'latitude': '44.9402142051823', 'longitude': ... | \n", "2 | \n", "2008-02-26T00:00:00.000 | \n", "2 | \n", "
| 511 | \n", "822 VAN BUREN AVE | \n", "32400 | \n", "7 | \n", "Duplex | \n", "{'latitude': '44.9619119910923', 'longitude': ... | \n", "2 | \n", "2007-11-28T00:00:00.000 | \n", "1 | \n", "
| 512 | \n", "575 PARK ST | \n", "42800 | \n", "7 | \n", "Single Family Residential | \n", "{'latitude': '44.9586747280584', 'longitude': ... | \n", "2 | \n", "2007-11-13T00:00:00.000 | \n", "1 | \n", "
| 513 | \n", "383 KING ST W | \n", "37000 | \n", "3 | \n", "Multi-family Residential | \n", "{'latitude': '44.9276700931864', 'longitude': ... | \n", "2 | \n", "2007-08-23T00:00:00.000 | \n", "2 | \n", "
| 514 | \n", "1626 ENGLEWOOD AVE | \n", "32100 | \n", "11 | \n", "Multi-family Residential | \n", "{'latitude': '44.9638769363282', 'longitude': ... | \n", "2 | \n", "2007-08-16T00:00:00.000 | \n", "4 | \n", "
| 515 | \n", "1093 4TH ST E | \n", "34601 | \n", "4 | \n", "Single Family Residential | \n", "{'latitude': '44.9588922296321', 'longitude': ... | \n", "2 | \n", "2007-07-20T00:00:00.000 | \n", "7 | \n", "
| 516 | \n", "287 AVON ST N | \n", "33800 | \n", "8 | \n", "Duplex | \n", "{'latitude': '44.9499427190014', 'longitude': ... | \n", "2 | \n", "2007-07-17T00:00:00.000 | \n", "1 | \n", "
| 517 | \n", "1904 PRINCETON AVE | \n", "35100 | \n", "14 | \n", "Single Family Residential | \n", "{'latitude': '44.9359488142281', 'longitude': ... | \n", "2 | \n", "2007-07-12T00:00:00.000 | \n", "3 | \n", "
| 518 | \n", "55 MANITOBA AVE | \n", "31400 | \n", "6 | \n", "Duplex | \n", "{'latitude': '44.9684623676033', 'longitude': ... | \n", "2 | \n", "2007-06-01T00:00:00.000 | \n", "1 | \n", "
| 519 | \n", "889 AGATE ST | \n", "31400 | \n", "6 | \n", "Multi-family Residential | \n", "{'latitude': '44.9680024783713', 'longitude': ... | \n", "2 | \n", "2007-06-01T00:00:00.000 | \n", "5 | \n", "
| 520 | \n", "380 RANDOLPH AVE | \n", "36000 | \n", "9 | \n", "Commercial | \n", "{'latitude': '44.9267151217236', 'longitude': ... | \n", "2 | \n", "2006-11-21T00:00:00.000 | \n", "2 | \n", "
| 521 | \n", "811 4TH ST E | \n", "34500 | \n", "4 | \n", "Single Family Residential | \n", "{'latitude': '44.9582234042631', 'longitude': ... | \n", "2 | \n", "2006-10-30T00:00:00.000 | \n", "7 | \n", "
| 522 | \n", "667 OHIO ST | \n", "37000 | \n", "3 | \n", "Single Family Residential | \n", "{'latitude': '44.9259319976014', 'longitude': ... | \n", "3 | \n", "2006-05-26T00:00:00.000 | \n", "2 | \n", "
| 523 | \n", "716 WILSON AVE | \n", "34400 | \n", "4 | \n", "Single Family Residential | \n", "{'latitude': '44.9532960197741', 'longitude': ... | \n", "2 | \n", "2005-10-27T00:00:00.000 | \n", "7 | \n", "
| 524 | \n", "587 COOK AVE E | \n", "31000 | \n", "5 | \n", "Duplex | \n", "{'latitude': '44.9730483353299', 'longitude': ... | \n", "2 | \n", "2005-10-14T00:00:00.000 | \n", "6 | \n", "
| 525 | \n", "680 MINNEHAHA AVE E BLDG 3 | \n", "NaN | \n", "NaN | \n", "Multi-family Residential | \n", "NaN | \n", "2 | \n", "2005-07-21T00:00:00.000 | \n", "NaN | \n", "
| 526 | \n", "650 AURORA AVE | \n", "33500 | \n", "8 | \n", "Single Family Residential | \n", "{'latitude': '44.9546496376062', 'longitude': ... | \n", "3 | \n", "2005-01-07T00:00:00.000 | \n", "1 | \n", "
| 527 | \n", "1023 JESSIE ST | \n", "30900 | \n", "5 | \n", "Duplex | \n", "{'latitude': '44.9721671763833', 'longitude': ... | \n", "2 | \n", "2004-12-09T00:00:00.000 | \n", "5 | \n", "
| 528 | \n", "2075 SCUDDER ST | \n", "30100 | \n", "12 | \n", "Single Family Residential | \n", "{'latitude': '44.9787618089353', 'longitude': ... | \n", "2 | \n", "2004-08-05T00:00:00.000 | \n", "4 | \n", "
| 529 | \n", "1253 CLEVELAND AVE N | \n", "30100 | \n", "12 | \n", "Single Family Residential | \n", "{'latitude': '44.9787614519552', 'longitude': ... | \n", "2 | \n", "2004-08-05T00:00:00.000 | \n", "4 | \n", "
| 530 | \n", "1508 COMO AVE | \n", "30201 | \n", "10 | \n", "Duplex | \n", "{'latitude': '44.977126870947', 'longitude': '... | \n", "2 | \n", "2003-07-29T00:00:00.000 | \n", "4 | \n", "
| 531 | \n", "2062 COMO AVE | \n", "30100 | \n", "12 | \n", "Single Family Residential | \n", "{'latitude': '44.9769023417819', 'longitude': ... | \n", "2 | \n", "2001-11-09T00:00:00.000 | \n", "4 | \n", "
| 532 | \n", "1308 VICTORIA ST N | \n", "30300 | \n", "10 | \n", "Single Family Residential | \n", "{'latitude': '44.9806018151037', 'longitude': ... | \n", "2 | \n", "2001-10-30T00:00:00.000 | \n", "5 | \n", "
| 533 | \n", "466 LAUREL AVE | \n", "35500 | \n", "8 | \n", "Single Family Residential | \n", "{'latitude': '44.9452343913786', 'longitude': ... | \n", "3 | \n", "2000-05-03T00:00:00.000 | \n", "1 | \n", "
| 534 | \n", "847 HUDSON ROAD | \n", "34400 | \n", "4 | \n", "Commercial | \n", "{'latitude': '44.9523831474725', 'longitude': ... | \n", "3 | \n", "1999-08-10T00:00:00.000 | \n", "7 | \n", "
| 535 | \n", "395 MICHIGAN ST | \n", "36900 | \n", "9 | \n", "Single Family Residential | \n", "{'latitude': '44.9352600297476', 'longitude': ... | \n", "3 | \n", "1996-05-15T00:00:00.000 | \n", "2 | \n", "
| 536 | \n", "365 MICHIGAN ST | \n", "36000 | \n", "9 | \n", "Single Family Residential | \n", "{'latitude': '44.9349513001028', 'longitude': ... | \n", "2 | \n", "1995-07-12T00:00:00.000 | \n", "2 | \n", "
537 rows × 8 columns
\n", "