Chicago housing

http://www.huaren.us/dispbbs.asp?boardid=337&Id=1154674

TCGA Breast Cancer

http://www.nature.com/nature/journal/v490/n7418/full/nature11412.html#/supplementary-information


Datasets:
https://tcga-data.nci.nih.gov/docs/publications/brca_2012/

Chciago crime rate

http://www.city-data.com/crime/crime-Elmhurst-Illinois.html

http://www.city-data.com/crime/crime-Brookfield-Illinois.html

http://www.topix.com/crime/north-riverside-il

http://www.clrsearch.com/North_Riverside_Demographics/IL/Crime-Rate?compare=Riverside+IL

http://www.greatschools.org/illinois/chicago/

http://www.education.com/schoolfinder/school-boundaries/


http://www.city-data.com/forum/chicago-suburbs/936111-north-riverside-good-place-buy.html


School boundary:

http://illinois.hometownlocator.com/schools/profiles,n,a%20f%20ames%20elem%20school,z,60546,t,pb,i,1040159.cfm


http://illinois.hometownlocator.com/schools/sorted-by-zip,zip,60546.cfm


http://illinois.hometownlocator.com/schools/

zip code: 60546; 60513

GEOmetadb

login Steve's web server
run ~/R.2.12.2.2/bin/R

library(GEOmetadb)
#getSQLiteFile()  #run this line if you want to update the GEOmetadb database file
file.info("GEOmetadb.sqlite")


con <- dbConnect(SQLite(), "GEOmetadb.sqlite")

cancer <- "astric"
treatment <- "luorouracil"
sql <- "select gse, title from gse where (title like '%CANCER%' or summary like '%CANCER%' or overall_design like '%CANCER%') and  (title like '%TREATMENT%' or summary like '%TREATMENT%' or overall_design like '%TREATMENT%') "
sql <- gsub("CANCER", cancer, sql)
sql <- gsub("TREATMENT", treatment, sql)

rs <- dbGetQuery(con, sql)
rs
dbDisconnect(con)

Induced pluripotent stem cell

check the gene expression of Oct-3/4, SOX2, c-Myc, and Klf4 in three subtypes