I need a csv file which contains information crime rate and housing price in chicago.i have link for crime rate from where you can download all the crime data but i am not having housing data in that particular area(sold houses).
https://data.cityofchicago.org/Public-Safety/Crimes-2022/9hwr-2zxp/data
this data need to merge with the sold houses data so that i can predict the housing rate for the are where there is more crime rate
Sheet1 IDCase NumberDateBlockIUCRPrimary TypeDescriptionLocation DescriptionArrestDomesticBeatDistrictWardCommunity AreaFBI CodeX CoordinateY CoordinateYearUpdated OnLatitudeLongitudeLocationUnnamed: 0zpididproviderListingIdimgSrchasImagedetailUrlstatusTypestatusTextcountryCurrencysoldPriceunformattedPriceaddressaddressStreetaddressCityaddressStateaddressZipcodeisUndisclosedAddressbedsbathsarealatLong_latitudelatLong_longitudeisZillowOwnedvariableData_typebadgeInfohdpData_homeInfo_zpidhdpData_homeInfo_streetAddresshdpData_homeInfo_zipcodehdpData_homeInfo_cityhdpData_homeInfo_statehdpData_homeInfo_latitudehdpData_homeInfo_longitudehdpData_homeInfo_pricehdpData_homeInfo_dateSoldhdpData_homeInfo_bathroomshdpData_homeInfo_bedroomshdpData_homeInfo_livingAreahdpData_homeInfo_homeTypehdpData_homeInfo_homeStatushdpData_homeInfo_daysOnZillowhdpData_homeInfo_isFeaturedhdpData_homeInfo_shouldHighlighthdpData_homeInfo_zestimatehdpData_homeInfo_rentZestimatehdpData_homeInfo_isUnmappablehdpData_homeInfo_isPreforeclosureAuctionhdpData_homeInfo_homeStatusForHDPhdpData_homeInfo_priceForHDPhdpData_homeInfo_isNonOwnerOccupiedhdpData_homeInfo_isPremierBuilderhdpData_homeInfo_isZillowOwnedhdpData_homeInfo_currencyhdpData_homeInfo_countryhdpData_homeInfo_taxAssessedValuehdpData_homeInfo_lotAreaValuehdpData_homeInfo_lotAreaUnitisSavedisUserClaimingOwnerisUserConfirmedClaimpgaptsgaptzestimateshouldShowZestimateAsPricehas3DModelhasVideoisHomeRecinfo1StringbrokerNamehasAdditionalAttributionsisFeaturedListingavailabilityDatelistrelaxedhdpData_homeInfo_unithdpData_homeInfo_videoCount 012896339JF47891911/10/22132XX S ST LAWRENCE AVE810THEFTOVER $500RESIDENCEFALSEFALSE5335954611825901817499202211/20/22 15:4641.6544226-87.60755573(41.654422603, -87.607555732)79939472653947265https://photos.zillowstatic.com/fp/28d9c9905c7bc15e12d2b24c28a06f92-p_e.jpgTRUEhttps://www.zillow.com/homedetails/6307-S-Nashville-Ave-3N-Chicago-IL-60638/3947265_zpid/SOLDClosed$$130,0001300006307 S Nashville Ave #3N, Chicago, IL 606386307 S Nashville Ave #3NChicagoIL60638FALSE2290041.77736-87.78588FALSERECENTLY_SOLD39472656307 S Nashville Ave #3N60638ChicagoIL41.77736-87.78588130000166807000000022900CONDORECENTLY_SOLD-1FALSEFALSE1301001669FALSEFALSERECENTLY_SOLD130000TRUEFALSEFALSEUSDUSA95520FALSEFALSEFALSERecentlySoldRecentChange130100FALSEFALSEFALSEFALSEMLS ID #11642530Coldwell Banker RealtyTRUEFALSETRUEFALSE# 3N 112896339JF47891911/10/22132XX S ST LAWRENCE AVE810THEFTOVER $500RESIDENCEFALSEFALSE5335954611825901817499202211/20/22 15:4641.6544226-87.60755573(41.654422603, -87.607555732)73420774090342077409034https://photos.zillowstatic.com/fp/55ef094e98b7237057c24fbd2e14d607-p_e.jpgTRUEhttps://www.zillow.com/homedetails/3352-N-Avers-Ave-Chicago-IL-60618/2077409034_zpid/SOLDClosed$$600,0006000003352 N Avers Ave, Chicago, IL 606183352 N Avers AveChicagoIL60618FALSE6541.942486-87.72397FALSERECENTLY_SOLD20774090343352 N Avers Ave60618ChicagoIL41.942486-87.72397600000166807000000056MULTI_FAMILYRECENTLY_SOLD-1FALSEFALSE1699FALSEFALSERECENTLY_SOLD600000TRUEFALSEFALSEUSDUSA3750sqftFALSEFALSEFALSERecentlySoldRecentChangeFALSEFALSEFALSEFALSEMLS ID #11480674Main Street Real Estate GroupTRUEFALSETRUEFALSE 212896339JF47891911/10/22132XX S ST LAWRENCE AVE810THEFTOVER $500RESIDENCEFALSEFALSE5335954611825901817499202211/20/22 15:4641.6544226-87.60755573(41.654422603, -87.607555732)73520852976022085297602https://photos.zillowstatic.com/fp/77c4d4060b7592c224c762c8479be96f-p_e.jpgTRUEhttps://www.zillow.com/homedetails/711-S-Dearborn-St-UNIT-305-Chicago-IL-60605/2085297602_zpid/SOLDClosed$$405,000405000711 S Dearborn St UNIT 305, Chicago, IL 60605711 S Dearborn St UNIT 305ChicagoIL60605FALSE22160041.87294-87.62887FALSERECENTLY_SOLD2085297602711 S Dearborn St UNIT 30560605ChicagoIL41.87294-87.628874050001668070000000221600CONDORECENTLY_SOLD-1FALSEFALSE3211FALSEFALSERECENTLY_SOLD405000TRUEFALSEFALSEUSDUSAFALSEFALSEFALSERecentlySoldUnknown Listed ByFALSEFALSEFALSEFALSEMLS ID #11613207CompassTRUEFALSETRUEFALSEUnit 305 312896339JF47891911/10/22132XX S ST LAWRENCE AVE810THEFTOVER $500RESIDENCEFALSEFALSE5335954611825901817499202211/20/22 15:4641.6544226-87.60755573(41.654422603, -87.607555732)73620978562772097856277https://photos.zillowstatic.com/fp/b95d0ee6434917d252671049cfa8190d-p_e.jpgTRUEhttps://www.zillow.com/homedetails/4820-N-Kildare-Ave-Chicago-IL-60630/2097856277_zpid/SOLDClosed$$560,0005600004820 N Kildare Ave, Chicago, IL 606304820 N Kildare AveChicagoIL60630FALSE7441.96884-87.73581FALSERECENTLY_SOLD20978562774820 N Kildare Ave60630ChicagoIL41.96884-87.73581560000166807000000047MULTI_FAMILYRECENTLY_SOLD-1FALSEFALSE1379FALSEFALSERECENTLY_SOLD560000TRUEFALSEFALSEUSDUSA3804sqftFALSEFALSEFALSERecentlySoldUnknown Listed ByFALSEFALSEFALSEFALSEMLS ID #11424637Artizen Realty LLCTRUEFALSETRUEFALSE 412896339JF47891911/10/22132XX S ST LAWRENCE AVE810THEFTOVER $500RESIDENCEFALSEFALSE5335954611825901817499202211/20/22 15:4641.6544226-87.60755573(41.654422603, -87.607555732)73720995234882099523488https://photos.zillowstatic.com/fp/bed408eacfebd5e99cdb02c7ed317ed3-p_e.jpgTRUEhttps://www.zillow.com/homedetails/3900-N-Lake-Shore-Dr-Chicago-IL-60613/2099523488_zpid/SOLDSold$$165,0001650003900 N Lake Shore Dr, Chicago, IL 606133900 N Lake Shore DrChicagoIL60613FALSE1141.9533-87.64557FALSERECENTLY_SOLD20995234883900 N Lake Shore Dr60613ChicagoIL41.9533-87.64557165000166807000000011CONDORECENTLY_SOLD-1FALSEFALSE1796001924FALSEFALSERECENTLY_SOLD165000TRUEFALSEFALSEUSDUSAFALSEFALSEFALSERecentlySoldUnknown Listed By179600FALSEFALSEFALSEFALSEFALSEFALSETRUEFALSE 512896339JF47891911/10/22132XX S ST LAWRENCE AVE810THEFTOVER $500RESIDENCEFALSEFALSE5335954611825901817499202211/20/22 15:4641.6544226-87.60755573(41.654422603, -87.607555732)73821031288692103128869https://photos.zillowstatic.com/fp/e238d4c4b4dc4ef0e23a3f096fe5f8de-p_e.jpgTRUEhttps://www.zillow.com/homedetails/676-N-Kingsbury-St-204-Chicago-IL-60654/2103128869_zpid/SOLDClosed$$1.61M1610000676 N Kingsbury St #204, Chicago, IL 60654676 N Kingsbury St #204ChicagoIL60654FALSE453081FALSERECENTLY_SOLD2103128869676 N Kingsbury St #20460654ChicagoIL16100001668070000000543081CONDORECENTLY_SOLD-1FALSEFALSEFALSEFALSERECENTLY_SOLD1610000TRUEFALSEFALSEUSDUSAFALSEFALSEFALSERecentlySoldRecentChangeFALSEFALSEFALSEFALSEMLS ID #11296816CompassTRUEFALSETRUEFALSE# 204 612896339JF47891911/10/22132XX S ST LAWRENCE AVE810THEFTOVER $500RESIDENCEFALSEFALSE5335954611825901817499202211/20/22 15:4641.6544226-87.60755573(41.654422603, -87.607555732)73921117554552111755455https://photos.zillowstatic.com/fp/b161684e9320f90800aad0313612ad18-p_e.jpgTRUEhttps://www.zillow.com/homedetails/1453-W-Irving-Park-Rd-APT-202-Chicago-IL-60613/2111755455_zpid/SOLDClosed$$549,0005490001453 W Irving Park Rd APT 202, Chicago, IL 606131453 W Irving Park Rd APT 202ChicagoIL60613FALSE22182541.954327-87.666176FALSERECENTLY_SOLD21117554551453 W Irving Park Rd APT 20260613ChicagoIL41.954327-87.6661765490001668070000000221825CONDORECENTLY_SOLD-1FALSEFALSE3249FALSEFALSERECENTLY_SOLD549000TRUEFALSEFALSEUSDUSAFALSEFALSEFALSERecentlySoldUnknown Listed ByFALSEFALSEFALSEFALSEMLS ID #11630178Keller Williams ONEChicagoTRUEFALSETRUEFALSEApt 202 712896339JF47891911/10/22132XX S ST LAWRENCE AVE810THEFTOVER $500RESIDENCEFALSEFALSE5335954611825901817499202211/20/22 15:4641.6544226-87.60755573(41.654422603, -87.607555732)74021129828472112982847https://photos.zillowstatic.com/fp/67a0fb9ef70f680d2b9353037497f59c-p_e.jpgTRUEhttps://www.zillow.com/homedetails/10717-S-Indiana-Ave-Chicago-IL-60628/2112982847_zpid/SOLDClosed$$280,00028000010717 S Indiana Ave, Chicago, IL 6062810717 S Indiana AveChicagoIL60628FALSE4241.699413-87.61807FALSERECENTLY_SOLD211298284710717 S Indiana Ave60628ChicagoIL41.699413-87.61807280000166807000000024MULTI_FAMILYRECENTLY_SOLD-1FALSEFALSE1165FALSEFALSERECENTLY_SOLD280000TRUEFALSEFALSEUSDUSA6250sqftFALSEFALSEFALSERecentlySoldUnknown Listed ByFALSEFALSEFALSEFALSEMLS ID #11651603Blue Door Dave IncTRUEFALSETRUEFALSE