Downloading JSON data into R
library(RJSONIO)library(RCurl)# grab the dataraw_data <- getURL("http://api.crunchbase.com/v/1/companies.js")# Then covert from JSON into a list in Rdata <- fromJSON(raw_data)length(data)[1] 101782# We can coerce this to a data.frame final_data <- do.call(rbind, data) # Then write it to a flat csv file write.csv(final_data, "final_data.csv")> head(final_data) name permalink category_code[1,] "Wetpaint" "wetpaint" "web" [2,] "AdventNet" "adventnet" "enterprise" [3,] "Zoho" "zoho" "software" [4,] "Digg" "digg" "web" [5,] "Facebook" "facebook" "web" [6,] "Photobucket, Inc." "photobucket" "web"