{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "
\n", "
\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", "\n", " | Address | \n", "Census_Tract | \n", "District | \n", "Dwelling | \n", "Coordinates | \n", "Vacant_Building_Category | \n", "VacantDate | \n", "Ward | \n", "
---|---|---|---|---|---|---|---|---|
0 | \n", "398 TOTEM ROAD | \n", "37403.0 | \n", "1.0 | \n", "Multi-family Residential | \n", "{'latitude': '44.925292830328', 'longitude': '... | \n", "1 | \n", "2019-11-25T00:00:00.000 | \n", "7.0 | \n", "
1 | \n", "1971 NORTONIA AVE | \n", "31802.0 | \n", "2.0 | \n", "Duplex | \n", "{'latitude': '44.9650944591901', 'longitude': ... | \n", "2 | \n", "2019-11-22T00:00:00.000 | \n", "7.0 | \n", "