Week_12_Assignment
Sekhar Mekala
Thursday, April 23, 2015
Creating a JSON file to be inserted into a mongodb collection
The following R code gets a JSON document from nytimes.com website, via API. This JSON document contains a books categories available at nytimes.com website
R Code to fetch books categories
library(RCurl)## Loading required package: bitopslibrary(jsonlite)##
## Attaching package: 'jsonlite'
##
## The following object is masked from 'package:utils':
##
## Viewurl <- "http://api.nytimes.com/svc/books/v3/lists/names.json?api-key=ae3ebf8d2c14b1623769762cea332b83:0:71863562"
web_data <- getURL(url)
categories_df <- fromJSON(web_data)$results
print(categories_df)## list_name
## 1 Combined Print and E-Book Fiction
## 2 Combined Print and E-Book Nonfiction
## 3 Hardcover Fiction
## 4 Hardcover Nonfiction
## 5 Trade Fiction Paperback
## 6 Mass Market Paperback
## 7 Paperback Nonfiction
## 8 E-Book Fiction
## 9 E-Book Nonfiction
## 10 Hardcover Advice
## 11 Paperback Advice
## 12 Advice How-To and Miscellaneous
## 13 Picture Books
## 14 Chapter Books
## 15 Childrens Middle Grade
## 16 Young Adult
## 17 Paperback Books
## 18 Series Books
## 19 Hardcover Graphic Books
## 20 Paperback Graphic Books
## 21 Manga
## 22 Combined Print Fiction
## 23 Combined Print Nonfiction
## 24 Animals
## 25 Business Books
## 26 Celebrities
## 27 Crime and Punishment
## 28 Culture
## 29 Education
## 30 Espionage
## 31 Expeditions Disasters and Adventures
## 32 Family
## 33 Fashion Manners and Customs
## 34 Food and Fitness
## 35 Games and Activities
## 36 Hardcover Business Books
## 37 Health
## 38 Humor
## 39 Indigenous Americans
## 40 Paperback Business Books
## 41 Hardcover Political Books
## 42 Race and Civil Rights
## 43 Relationships
## 44 Religion Spirituality and Faith
## 45 Science
## 46 Sports
## 47 Travel
## display_name
## 1 Combined Print & E-Book Fiction
## 2 Combined Print & E-Book Nonfiction
## 3 Hardcover Fiction
## 4 Hardcover Nonfiction
## 5 Paperback Trade Fiction
## 6 Paperback Mass-Market Fiction
## 7 Paperback Nonfiction
## 8 E-Book Fiction
## 9 E-Book Nonfiction
## 10 Hardcover Advice & Misc.
## 11 Paperback Advice & Misc.
## 12 Advice, How-To & Miscellaneous
## 13 Children's Picture Books
## 14 Children's Chapter Books
## 15 Children's Middle Grade
## 16 Young Adult
## 17 Children's Paperback Books
## 18 Children's Series
## 19 Hardcover Graphic Books
## 20 Paperback Graphic Books
## 21 Manga
## 22 Combined Hardcover & Paperback Fiction
## 23 Combined Hardcover & Paperback Nonfiction
## 24 Animals
## 25 Business
## 26 Celebrities
## 27 Crime and Punishment
## 28 Culture
## 29 Education
## 30 Espionage
## 31 Expeditions, Disasters and Adventures
## 32 Family
## 33 Fashion, Manners and Customs
## 34 Food and Fitness
## 35 Games and Activities
## 36 Hardcover Business Books
## 37 Health
## 38 Humor
## 39 Indigenous Americans
## 40 Paperback Business Books
## 41 Politics
## 42 Race and Civil Rights
## 43 Relationships
## 44 Religion, Spirituality and Faith
## 45 Science
## 46 Sports
## 47 Travel
## list_name_encoded oldest_published_date
## 1 combined-print-and-e-book-fiction 2011-02-13
## 2 combined-print-and-e-book-nonfiction 2011-02-13
## 3 hardcover-fiction 2008-06-08
## 4 hardcover-nonfiction 2008-06-08
## 5 trade-fiction-paperback 2008-06-08
## 6 mass-market-paperback 2008-06-08
## 7 paperback-nonfiction 2008-06-08
## 8 e-book-fiction 2011-02-13
## 9 e-book-nonfiction 2011-02-13
## 10 hardcover-advice 2008-06-08
## 11 paperback-advice 2008-06-08
## 12 advice-how-to-and-miscellaneous 2013-04-28
## 13 picture-books 2008-06-08
## 14 chapter-books 2008-06-08
## 15 childrens-middle-grade 2012-12-16
## 16 young-adult 2012-12-16
## 17 paperback-books 2008-06-08
## 18 series-books 2008-06-08
## 19 hardcover-graphic-books 2009-03-15
## 20 paperback-graphic-books 2009-03-15
## 21 manga 2009-03-15
## 22 combined-print-fiction 2011-02-13
## 23 combined-print-nonfiction 2011-02-13
## 24 animals 2014-09-07
## 25 business-books 2013-11-03
## 26 celebrities 2014-09-07
## 27 crime-and-punishment 2014-10-12
## 28 culture 2014-10-12
## 29 education 2014-10-12
## 30 espionage 2014-12-14
## 31 expeditions-disasters-and-adventures 2014-12-14
## 32 family 2014-09-07
## 33 fashion-manners-and-customs 2014-10-12
## 34 food-and-fitness 2013-09-01
## 35 games-and-activities 2014-10-12
## 36 hardcover-business-books 2011-07-03
## 37 health 2014-10-12
## 38 humor 2014-09-07
## 39 indigenous-americans 2014-12-14
## 40 paperback-business-books 2011-07-03
## 41 hardcover-political-books 2011-07-03
## 42 race-and-civil-rights 2014-12-14
## 43 relationships 2014-09-07
## 44 religion-spirituality-and-faith 2014-09-07
## 45 science 2013-04-14
## 46 sports 2014-03-02
## 47 travel 2014-09-07
## newest_published_date updated
## 1 2015-04-26 WEEKLY
## 2 2015-04-26 WEEKLY
## 3 2015-04-26 WEEKLY
## 4 2015-04-26 WEEKLY
## 5 2015-04-26 WEEKLY
## 6 2015-04-26 WEEKLY
## 7 2015-04-26 WEEKLY
## 8 2015-04-26 WEEKLY
## 9 2015-04-26 WEEKLY
## 10 2013-04-21 WEEKLY
## 11 2013-04-21 WEEKLY
## 12 2015-04-26 WEEKLY
## 13 2015-04-26 WEEKLY
## 14 2012-12-09 WEEKLY
## 15 2015-04-26 WEEKLY
## 16 2015-04-26 WEEKLY
## 17 2012-12-09 WEEKLY
## 18 2015-04-26 WEEKLY
## 19 2015-04-26 WEEKLY
## 20 2015-04-26 WEEKLY
## 21 2015-04-26 WEEKLY
## 22 2013-05-12 WEEKLY
## 23 2013-05-12 WEEKLY
## 24 2015-04-12 MONTHLY
## 25 2015-04-12 MONTHLY
## 26 2015-04-12 MONTHLY
## 27 2015-04-12 MONTHLY
## 28 2015-04-12 MONTHLY
## 29 2015-04-12 MONTHLY
## 30 2015-04-12 MONTHLY
## 31 2015-04-12 MONTHLY
## 32 2015-04-12 MONTHLY
## 33 2015-04-12 MONTHLY
## 34 2015-04-12 MONTHLY
## 35 2015-04-12 MONTHLY
## 36 2013-10-13 MONTHLY
## 37 2015-04-12 MONTHLY
## 38 2015-04-12 MONTHLY
## 39 2015-04-12 MONTHLY
## 40 2013-10-13 MONTHLY
## 41 2015-04-12 MONTHLY
## 42 2015-04-12 MONTHLY
## 43 2015-03-15 MONTHLY
## 44 2015-04-12 MONTHLY
## 45 2015-04-12 MONTHLY
## 46 2015-04-12 MONTHLY
## 47 2015-04-12 MONTHLYLet us convert back the data frame (categories_df) to a JSON document. In the following R code the JSON document is placed at “C:/Users/Sekhar/Documents/CUNY/MongoDB/books.json”
categories_json <- toJSON(categories_df)
fileconn <- file("C:/Users/Sekhar/Documents/CUNY/MongoDB/books.json")
writeLines(categories_json, fileconn)
close(fileconn)Using mongoimport to read the JSON file (books.json) to a mongodb collection
The following code can be executed from the dos command prompt (depending on the directory where you install the mongodb. The idea is to use the mongoimport program to load the json file)
“C:Files (x86)2.6 Standard” –db nytimes –collection bookCategories –file “C:.json” –jsonArray
The above command loads the json file (books.json) data to bookCategories collection (in mongodb’s nytimes database)
Checking the contents of the collection
Execute the mongo.exe using the following command (the location of mongo.exe might change in your installation)
“C:Files (x86)2.6 Standard.exe”
At the mongo.exe prompt, enter the following commands, to check the available collections:
use nytimes
db.getCollectionNames()
The first command connects to nytimes database, and the second command displays the available collection names in the database. See the display below:
The command db.bookCategories.find().pretty().limit(5) will display the first 5 documents of the collection bookCategories. See the below display (NOTE that the number of documents display is restricted to just 5, using the limit(5) option so that we are able to display the command along with the results in a single dos window. If you use db.bookCategories.find().pretty() command, then all the results of the collection are displayed:
Connecting to the local mongodb and reading a collection’s documents to a R dataframe
NOTE There is an excellent document on rmongodb usage at the website: http://cran.r-project.org/web/packages/rmongodb/vignettes/rmongodb_introduction.html
Most of the commands I used below were taken from that website.
#Install rmongodb package, if the package is not installed
#install.packages("rmongodb")
library(rmongodb)
library(data.table)
#Create a connection to the mongodb() process
mongo <- mongo.create()
#Get the collections we have in the "nytimes" database
mongo.get.database.collections(mongo, "nytimes")## [1] "nytimes.a" "nytimes.bookCategories"#We will use the "bookCategories" collection name in "nytimes" database, to read its documents
# Note how we referenced the collection name qualified with database name
coll <- "nytimes.bookCategories"
x <- mongo.find.all(mongo, coll)
#Converting the collection's documents to a data frame in R
books_df <- data.frame(rbindlist(lapply(x,as.list)))
print(books_df)## X_id list_name
## 1 5539bd59e5c4ef70c3eed1e1 Combined Print and E-Book Fiction
## 2 5539bd59e5c4ef70c3eed1e2 Combined Print and E-Book Nonfiction
## 3 5539bd59e5c4ef70c3eed1e3 Hardcover Fiction
## 4 5539c2e8e5c4ef70c3eed1e4 Combined Print and E-Book Fiction
## 5 5539c2e8e5c4ef70c3eed1e5 Combined Print and E-Book Nonfiction
## 6 5539c2e8e5c4ef70c3eed1e6 Hardcover Fiction
## 7 5539c2e8e5c4ef70c3eed1e7 Hardcover Nonfiction
## 8 5539c2e8e5c4ef70c3eed1e8 Trade Fiction Paperback
## 9 5539c2e8e5c4ef70c3eed1e9 Mass Market Paperback
## 10 5539c2e8e5c4ef70c3eed1ea Paperback Nonfiction
## 11 5539c2e8e5c4ef70c3eed1eb E-Book Fiction
## 12 5539c2e8e5c4ef70c3eed1ec E-Book Nonfiction
## 13 5539c2e8e5c4ef70c3eed1ed Hardcover Advice
## 14 5539c2e8e5c4ef70c3eed1ee Paperback Advice
## 15 5539c2e8e5c4ef70c3eed1ef Advice How-To and Miscellaneous
## 16 5539c2e8e5c4ef70c3eed1f0 Picture Books
## 17 5539c2e8e5c4ef70c3eed1f1 Chapter Books
## 18 5539c2e8e5c4ef70c3eed1f2 Childrens Middle Grade
## 19 5539c2e8e5c4ef70c3eed1f3 Young Adult
## 20 5539c2e8e5c4ef70c3eed1f4 Paperback Books
## 21 5539c2e8e5c4ef70c3eed1f5 Series Books
## 22 5539c2e8e5c4ef70c3eed1f6 Hardcover Graphic Books
## 23 5539c2e8e5c4ef70c3eed1f7 Paperback Graphic Books
## 24 5539c2e8e5c4ef70c3eed1f8 Manga
## 25 5539c2e8e5c4ef70c3eed1f9 Combined Print Fiction
## 26 5539c2e8e5c4ef70c3eed1fa Combined Print Nonfiction
## 27 5539c2e8e5c4ef70c3eed1fb Animals
## 28 5539c2e8e5c4ef70c3eed1fc Business Books
## 29 5539c2e8e5c4ef70c3eed1fd Celebrities
## 30 5539c2e8e5c4ef70c3eed1fe Crime and Punishment
## 31 5539c2e8e5c4ef70c3eed1ff Culture
## 32 5539c2e8e5c4ef70c3eed200 Education
## 33 5539c2e8e5c4ef70c3eed201 Espionage
## 34 5539c2e8e5c4ef70c3eed202 Expeditions Disasters and Adventures
## 35 5539c2e8e5c4ef70c3eed203 Family
## 36 5539c2e8e5c4ef70c3eed204 Fashion Manners and Customs
## 37 5539c2e8e5c4ef70c3eed205 Food and Fitness
## 38 5539c2e8e5c4ef70c3eed206 Games and Activities
## 39 5539c2e8e5c4ef70c3eed207 Hardcover Business Books
## 40 5539c2e8e5c4ef70c3eed208 Health
## 41 5539c2e8e5c4ef70c3eed209 Humor
## 42 5539c2e8e5c4ef70c3eed20a Indigenous Americans
## 43 5539c2e8e5c4ef70c3eed20b Paperback Business Books
## 44 5539c2e8e5c4ef70c3eed20c Hardcover Political Books
## 45 5539c2e8e5c4ef70c3eed20d Race and Civil Rights
## 46 5539c2e8e5c4ef70c3eed20e Relationships
## 47 5539c2e8e5c4ef70c3eed20f Religion Spirituality and Faith
## 48 5539c2e8e5c4ef70c3eed210 Science
## 49 5539c2e8e5c4ef70c3eed211 Sports
## 50 5539c2e8e5c4ef70c3eed212 Travel
## 51 5539c509e5c4ef70c3eed213 Combined Print and E-Book Fiction
## 52 5539c509e5c4ef70c3eed214 Combined Print and E-Book Nonfiction
## 53 5539c509e5c4ef70c3eed215 Hardcover Fiction
## 54 5539c509e5c4ef70c3eed216 Hardcover Nonfiction
## 55 5539c509e5c4ef70c3eed217 Trade Fiction Paperback
## 56 5539c509e5c4ef70c3eed218 Mass Market Paperback
## 57 5539c509e5c4ef70c3eed219 Paperback Nonfiction
## 58 5539c509e5c4ef70c3eed21a E-Book Fiction
## 59 5539c509e5c4ef70c3eed21b E-Book Nonfiction
## 60 5539c509e5c4ef70c3eed21c Hardcover Advice
## 61 5539c509e5c4ef70c3eed21d Paperback Advice
## 62 5539c509e5c4ef70c3eed21e Advice How-To and Miscellaneous
## 63 5539c509e5c4ef70c3eed21f Picture Books
## 64 5539c509e5c4ef70c3eed220 Chapter Books
## 65 5539c509e5c4ef70c3eed221 Childrens Middle Grade
## 66 5539c509e5c4ef70c3eed222 Young Adult
## 67 5539c509e5c4ef70c3eed223 Paperback Books
## 68 5539c509e5c4ef70c3eed224 Series Books
## 69 5539c509e5c4ef70c3eed225 Hardcover Graphic Books
## 70 5539c509e5c4ef70c3eed226 Paperback Graphic Books
## 71 5539c509e5c4ef70c3eed227 Manga
## 72 5539c509e5c4ef70c3eed228 Combined Print Fiction
## 73 5539c509e5c4ef70c3eed229 Combined Print Nonfiction
## 74 5539c509e5c4ef70c3eed22a Animals
## 75 5539c509e5c4ef70c3eed22b Business Books
## 76 5539c509e5c4ef70c3eed22c Celebrities
## 77 5539c509e5c4ef70c3eed22d Crime and Punishment
## 78 5539c509e5c4ef70c3eed22e Culture
## 79 5539c509e5c4ef70c3eed22f Education
## 80 5539c509e5c4ef70c3eed230 Espionage
## 81 5539c509e5c4ef70c3eed231 Expeditions Disasters and Adventures
## 82 5539c509e5c4ef70c3eed232 Family
## 83 5539c509e5c4ef70c3eed233 Fashion Manners and Customs
## 84 5539c509e5c4ef70c3eed234 Food and Fitness
## 85 5539c509e5c4ef70c3eed235 Games and Activities
## 86 5539c509e5c4ef70c3eed236 Hardcover Business Books
## 87 5539c509e5c4ef70c3eed237 Health
## 88 5539c509e5c4ef70c3eed238 Humor
## 89 5539c509e5c4ef70c3eed239 Indigenous Americans
## 90 5539c509e5c4ef70c3eed23a Paperback Business Books
## 91 5539c509e5c4ef70c3eed23b Hardcover Political Books
## 92 5539c509e5c4ef70c3eed23c Race and Civil Rights
## 93 5539c509e5c4ef70c3eed23d Relationships
## 94 5539c509e5c4ef70c3eed23e Religion Spirituality and Faith
## 95 5539c509e5c4ef70c3eed23f Science
## 96 5539c509e5c4ef70c3eed240 Sports
## 97 5539c509e5c4ef70c3eed241 Travel
## 98 5539c5e6e5c4ef70c3eed242 Combined Print and E-Book Fiction
## 99 5539c5e6e5c4ef70c3eed243 Combined Print and E-Book Nonfiction
## 100 5539c5e6e5c4ef70c3eed244 Hardcover Fiction
## 101 5539c5e6e5c4ef70c3eed245 Hardcover Nonfiction
## 102 5539c5e6e5c4ef70c3eed246 Trade Fiction Paperback
## 103 5539c5e6e5c4ef70c3eed247 Mass Market Paperback
## 104 5539c5e6e5c4ef70c3eed248 Paperback Nonfiction
## 105 5539c5e6e5c4ef70c3eed249 E-Book Fiction
## 106 5539c5e6e5c4ef70c3eed24a E-Book Nonfiction
## 107 5539c5e6e5c4ef70c3eed24b Hardcover Advice
## 108 5539c5e6e5c4ef70c3eed24c Paperback Advice
## 109 5539c5e6e5c4ef70c3eed24d Advice How-To and Miscellaneous
## 110 5539c5e6e5c4ef70c3eed24e Picture Books
## 111 5539c5e6e5c4ef70c3eed24f Chapter Books
## 112 5539c5e6e5c4ef70c3eed250 Childrens Middle Grade
## 113 5539c5e6e5c4ef70c3eed251 Young Adult
## 114 5539c5e6e5c4ef70c3eed252 Paperback Books
## 115 5539c5e6e5c4ef70c3eed253 Series Books
## 116 5539c5e6e5c4ef70c3eed254 Hardcover Graphic Books
## 117 5539c5e6e5c4ef70c3eed256 Manga
## 118 5539c5e6e5c4ef70c3eed255 Paperback Graphic Books
## 119 5539c5e6e5c4ef70c3eed257 Combined Print Fiction
## 120 5539c5e6e5c4ef70c3eed258 Combined Print Nonfiction
## 121 5539c5e6e5c4ef70c3eed259 Animals
## 122 5539c5e6e5c4ef70c3eed25a Business Books
## 123 5539c5e6e5c4ef70c3eed25b Celebrities
## 124 5539c5e6e5c4ef70c3eed25c Crime and Punishment
## 125 5539c5e6e5c4ef70c3eed25d Culture
## 126 5539c5e6e5c4ef70c3eed25e Education
## 127 5539c5e6e5c4ef70c3eed25f Espionage
## 128 5539c5e6e5c4ef70c3eed260 Expeditions Disasters and Adventures
## 129 5539c5e6e5c4ef70c3eed261 Family
## 130 5539c5e6e5c4ef70c3eed262 Fashion Manners and Customs
## 131 5539c5e6e5c4ef70c3eed263 Food and Fitness
## 132 5539c5e6e5c4ef70c3eed264 Games and Activities
## 133 5539c5e6e5c4ef70c3eed265 Hardcover Business Books
## 134 5539c5e6e5c4ef70c3eed266 Health
## 135 5539c5e6e5c4ef70c3eed267 Humor
## 136 5539c5e6e5c4ef70c3eed268 Indigenous Americans
## 137 5539c5e6e5c4ef70c3eed269 Paperback Business Books
## 138 5539c5e6e5c4ef70c3eed26a Hardcover Political Books
## 139 5539c5e6e5c4ef70c3eed26b Race and Civil Rights
## 140 5539c5e6e5c4ef70c3eed26c Relationships
## 141 5539c5e6e5c4ef70c3eed26d Religion Spirituality and Faith
## 142 5539c5e6e5c4ef70c3eed26e Science
## 143 5539c5e6e5c4ef70c3eed26f Sports
## 144 5539c5e6e5c4ef70c3eed270 Travel
## 145 5539d1e5e5c4ef70c3eed271 Combined Print and E-Book Fiction
## 146 5539d1e5e5c4ef70c3eed272 Combined Print and E-Book Nonfiction
## 147 5539d1e5e5c4ef70c3eed273 Hardcover Fiction
## 148 5539d1e5e5c4ef70c3eed274 Hardcover Nonfiction
## 149 5539d1e5e5c4ef70c3eed275 Trade Fiction Paperback
## 150 5539d1e5e5c4ef70c3eed276 Mass Market Paperback
## 151 5539d1e5e5c4ef70c3eed277 Paperback Nonfiction
## 152 5539d1e5e5c4ef70c3eed278 E-Book Fiction
## 153 5539d1e5e5c4ef70c3eed279 E-Book Nonfiction
## 154 5539d1e5e5c4ef70c3eed27a Hardcover Advice
## 155 5539d1e5e5c4ef70c3eed27b Paperback Advice
## 156 5539d1e5e5c4ef70c3eed27c Advice How-To and Miscellaneous
## 157 5539d1e5e5c4ef70c3eed27d Picture Books
## 158 5539d1e5e5c4ef70c3eed27e Chapter Books
## 159 5539d1e5e5c4ef70c3eed27f Childrens Middle Grade
## 160 5539d1e5e5c4ef70c3eed280 Young Adult
## 161 5539d1e5e5c4ef70c3eed281 Paperback Books
## 162 5539d1e5e5c4ef70c3eed282 Series Books
## 163 5539d1e5e5c4ef70c3eed283 Hardcover Graphic Books
## 164 5539d1e5e5c4ef70c3eed284 Paperback Graphic Books
## 165 5539d1e5e5c4ef70c3eed285 Manga
## 166 5539d1e5e5c4ef70c3eed286 Combined Print Fiction
## 167 5539d1e5e5c4ef70c3eed287 Combined Print Nonfiction
## 168 5539d1e5e5c4ef70c3eed288 Animals
## 169 5539d1e5e5c4ef70c3eed289 Business Books
## 170 5539d1e5e5c4ef70c3eed28a Celebrities
## 171 5539d1e5e5c4ef70c3eed28b Crime and Punishment
## 172 5539d1e5e5c4ef70c3eed28c Culture
## 173 5539d1e5e5c4ef70c3eed28d Education
## 174 5539d1e5e5c4ef70c3eed28e Espionage
## 175 5539d1e5e5c4ef70c3eed28f Expeditions Disasters and Adventures
## 176 5539d1e5e5c4ef70c3eed290 Family
## 177 5539d1e5e5c4ef70c3eed291 Fashion Manners and Customs
## 178 5539d1e5e5c4ef70c3eed292 Food and Fitness
## 179 5539d1e5e5c4ef70c3eed293 Games and Activities
## 180 5539d1e5e5c4ef70c3eed294 Hardcover Business Books
## 181 5539d1e5e5c4ef70c3eed295 Health
## 182 5539d1e5e5c4ef70c3eed296 Humor
## 183 5539d1e5e5c4ef70c3eed297 Indigenous Americans
## 184 5539d1e5e5c4ef70c3eed298 Paperback Business Books
## 185 5539d1e5e5c4ef70c3eed299 Hardcover Political Books
## 186 5539d1e5e5c4ef70c3eed29a Race and Civil Rights
## 187 5539d1e5e5c4ef70c3eed29b Relationships
## 188 5539d1e5e5c4ef70c3eed29c Religion Spirituality and Faith
## 189 5539d1e5e5c4ef70c3eed29d Science
## 190 5539d1e5e5c4ef70c3eed29e Sports
## 191 5539d1e5e5c4ef70c3eed29f Travel
## 192 5539d203e5c4ef70c3eed2a0 Combined Print and E-Book Fiction
## 193 5539d203e5c4ef70c3eed2a1 Combined Print and E-Book Nonfiction
## 194 5539d203e5c4ef70c3eed2a2 Hardcover Fiction
## 195 5539d203e5c4ef70c3eed2a3 Hardcover Nonfiction
## 196 5539d203e5c4ef70c3eed2a4 Trade Fiction Paperback
## 197 5539d203e5c4ef70c3eed2a5 Mass Market Paperback
## 198 5539d203e5c4ef70c3eed2a6 Paperback Nonfiction
## 199 5539d203e5c4ef70c3eed2a7 E-Book Fiction
## 200 5539d203e5c4ef70c3eed2a8 E-Book Nonfiction
## 201 5539d203e5c4ef70c3eed2a9 Hardcover Advice
## 202 5539d203e5c4ef70c3eed2aa Paperback Advice
## 203 5539d203e5c4ef70c3eed2ab Advice How-To and Miscellaneous
## 204 5539d203e5c4ef70c3eed2ac Picture Books
## 205 5539d203e5c4ef70c3eed2ad Chapter Books
## 206 5539d203e5c4ef70c3eed2ae Childrens Middle Grade
## 207 5539d203e5c4ef70c3eed2af Young Adult
## 208 5539d203e5c4ef70c3eed2b0 Paperback Books
## 209 5539d203e5c4ef70c3eed2b1 Series Books
## 210 5539d203e5c4ef70c3eed2b2 Hardcover Graphic Books
## 211 5539d203e5c4ef70c3eed2b3 Paperback Graphic Books
## 212 5539d203e5c4ef70c3eed2b4 Manga
## 213 5539d203e5c4ef70c3eed2b5 Combined Print Fiction
## 214 5539d203e5c4ef70c3eed2b6 Combined Print Nonfiction
## 215 5539d203e5c4ef70c3eed2b7 Animals
## 216 5539d203e5c4ef70c3eed2b8 Business Books
## 217 5539d203e5c4ef70c3eed2b9 Celebrities
## 218 5539d203e5c4ef70c3eed2ba Crime and Punishment
## 219 5539d203e5c4ef70c3eed2bb Culture
## 220 5539d203e5c4ef70c3eed2bc Education
## 221 5539d203e5c4ef70c3eed2bd Espionage
## 222 5539d203e5c4ef70c3eed2be Expeditions Disasters and Adventures
## 223 5539d203e5c4ef70c3eed2bf Family
## 224 5539d203e5c4ef70c3eed2c0 Fashion Manners and Customs
## 225 5539d203e5c4ef70c3eed2c1 Food and Fitness
## 226 5539d203e5c4ef70c3eed2c2 Games and Activities
## 227 5539d203e5c4ef70c3eed2c3 Hardcover Business Books
## 228 5539d203e5c4ef70c3eed2c4 Health
## 229 5539d203e5c4ef70c3eed2c5 Humor
## 230 5539d203e5c4ef70c3eed2c6 Indigenous Americans
## 231 5539d203e5c4ef70c3eed2c7 Paperback Business Books
## 232 5539d203e5c4ef70c3eed2c8 Hardcover Political Books
## 233 5539d203e5c4ef70c3eed2c9 Race and Civil Rights
## 234 5539d203e5c4ef70c3eed2ca Relationships
## 235 5539d203e5c4ef70c3eed2cb Religion Spirituality and Faith
## 236 5539d203e5c4ef70c3eed2cc Science
## 237 5539d203e5c4ef70c3eed2cd Sports
## 238 5539d203e5c4ef70c3eed2ce Travel
## display_name
## 1 Combined Print & E-Book Fiction
## 2 Combined Print & E-Book Nonfiction
## 3 Hardcover Fiction
## 4 Combined Print & E-Book Fiction
## 5 Combined Print & E-Book Nonfiction
## 6 Hardcover Fiction
## 7 Hardcover Nonfiction
## 8 Paperback Trade Fiction
## 9 Paperback Mass-Market Fiction
## 10 Paperback Nonfiction
## 11 E-Book Fiction
## 12 E-Book Nonfiction
## 13 Hardcover Advice & Misc.
## 14 Paperback Advice & Misc.
## 15 Advice, How-To & Miscellaneous
## 16 Children's Picture Books
## 17 Children's Chapter Books
## 18 Children's Middle Grade
## 19 Young Adult
## 20 Children's Paperback Books
## 21 Children's Series
## 22 Hardcover Graphic Books
## 23 Paperback Graphic Books
## 24 Manga
## 25 Combined Hardcover & Paperback Fiction
## 26 Combined Hardcover & Paperback Nonfiction
## 27 Animals
## 28 Business
## 29 Celebrities
## 30 Crime and Punishment
## 31 Culture
## 32 Education
## 33 Espionage
## 34 Expeditions, Disasters and Adventures
## 35 Family
## 36 Fashion, Manners and Customs
## 37 Food and Fitness
## 38 Games and Activities
## 39 Hardcover Business Books
## 40 Health
## 41 Humor
## 42 Indigenous Americans
## 43 Paperback Business Books
## 44 Politics
## 45 Race and Civil Rights
## 46 Relationships
## 47 Religion, Spirituality and Faith
## 48 Science
## 49 Sports
## 50 Travel
## 51 Combined Print & E-Book Fiction
## 52 Combined Print & E-Book Nonfiction
## 53 Hardcover Fiction
## 54 Hardcover Nonfiction
## 55 Paperback Trade Fiction
## 56 Paperback Mass-Market Fiction
## 57 Paperback Nonfiction
## 58 E-Book Fiction
## 59 E-Book Nonfiction
## 60 Hardcover Advice & Misc.
## 61 Paperback Advice & Misc.
## 62 Advice, How-To & Miscellaneous
## 63 Children's Picture Books
## 64 Children's Chapter Books
## 65 Children's Middle Grade
## 66 Young Adult
## 67 Children's Paperback Books
## 68 Children's Series
## 69 Hardcover Graphic Books
## 70 Paperback Graphic Books
## 71 Manga
## 72 Combined Hardcover & Paperback Fiction
## 73 Combined Hardcover & Paperback Nonfiction
## 74 Animals
## 75 Business
## 76 Celebrities
## 77 Crime and Punishment
## 78 Culture
## 79 Education
## 80 Espionage
## 81 Expeditions, Disasters and Adventures
## 82 Family
## 83 Fashion, Manners and Customs
## 84 Food and Fitness
## 85 Games and Activities
## 86 Hardcover Business Books
## 87 Health
## 88 Humor
## 89 Indigenous Americans
## 90 Paperback Business Books
## 91 Politics
## 92 Race and Civil Rights
## 93 Relationships
## 94 Religion, Spirituality and Faith
## 95 Science
## 96 Sports
## 97 Travel
## 98 Combined Print & E-Book Fiction
## 99 Combined Print & E-Book Nonfiction
## 100 Hardcover Fiction
## 101 Hardcover Nonfiction
## 102 Paperback Trade Fiction
## 103 Paperback Mass-Market Fiction
## 104 Paperback Nonfiction
## 105 E-Book Fiction
## 106 E-Book Nonfiction
## 107 Hardcover Advice & Misc.
## 108 Paperback Advice & Misc.
## 109 Advice, How-To & Miscellaneous
## 110 Children's Picture Books
## 111 Children's Chapter Books
## 112 Children's Middle Grade
## 113 Young Adult
## 114 Children's Paperback Books
## 115 Children's Series
## 116 Hardcover Graphic Books
## 117 Manga
## 118 Paperback Graphic Books
## 119 Combined Hardcover & Paperback Fiction
## 120 Combined Hardcover & Paperback Nonfiction
## 121 Animals
## 122 Business
## 123 Celebrities
## 124 Crime and Punishment
## 125 Culture
## 126 Education
## 127 Espionage
## 128 Expeditions, Disasters and Adventures
## 129 Family
## 130 Fashion, Manners and Customs
## 131 Food and Fitness
## 132 Games and Activities
## 133 Hardcover Business Books
## 134 Health
## 135 Humor
## 136 Indigenous Americans
## 137 Paperback Business Books
## 138 Politics
## 139 Race and Civil Rights
## 140 Relationships
## 141 Religion, Spirituality and Faith
## 142 Science
## 143 Sports
## 144 Travel
## 145 Combined Print & E-Book Fiction
## 146 Combined Print & E-Book Nonfiction
## 147 Hardcover Fiction
## 148 Hardcover Nonfiction
## 149 Paperback Trade Fiction
## 150 Paperback Mass-Market Fiction
## 151 Paperback Nonfiction
## 152 E-Book Fiction
## 153 E-Book Nonfiction
## 154 Hardcover Advice & Misc.
## 155 Paperback Advice & Misc.
## 156 Advice, How-To & Miscellaneous
## 157 Children's Picture Books
## 158 Children's Chapter Books
## 159 Children's Middle Grade
## 160 Young Adult
## 161 Children's Paperback Books
## 162 Children's Series
## 163 Hardcover Graphic Books
## 164 Paperback Graphic Books
## 165 Manga
## 166 Combined Hardcover & Paperback Fiction
## 167 Combined Hardcover & Paperback Nonfiction
## 168 Animals
## 169 Business
## 170 Celebrities
## 171 Crime and Punishment
## 172 Culture
## 173 Education
## 174 Espionage
## 175 Expeditions, Disasters and Adventures
## 176 Family
## 177 Fashion, Manners and Customs
## 178 Food and Fitness
## 179 Games and Activities
## 180 Hardcover Business Books
## 181 Health
## 182 Humor
## 183 Indigenous Americans
## 184 Paperback Business Books
## 185 Politics
## 186 Race and Civil Rights
## 187 Relationships
## 188 Religion, Spirituality and Faith
## 189 Science
## 190 Sports
## 191 Travel
## 192 Combined Print & E-Book Fiction
## 193 Combined Print & E-Book Nonfiction
## 194 Hardcover Fiction
## 195 Hardcover Nonfiction
## 196 Paperback Trade Fiction
## 197 Paperback Mass-Market Fiction
## 198 Paperback Nonfiction
## 199 E-Book Fiction
## 200 E-Book Nonfiction
## 201 Hardcover Advice & Misc.
## 202 Paperback Advice & Misc.
## 203 Advice, How-To & Miscellaneous
## 204 Children's Picture Books
## 205 Children's Chapter Books
## 206 Children's Middle Grade
## 207 Young Adult
## 208 Children's Paperback Books
## 209 Children's Series
## 210 Hardcover Graphic Books
## 211 Paperback Graphic Books
## 212 Manga
## 213 Combined Hardcover & Paperback Fiction
## 214 Combined Hardcover & Paperback Nonfiction
## 215 Animals
## 216 Business
## 217 Celebrities
## 218 Crime and Punishment
## 219 Culture
## 220 Education
## 221 Espionage
## 222 Expeditions, Disasters and Adventures
## 223 Family
## 224 Fashion, Manners and Customs
## 225 Food and Fitness
## 226 Games and Activities
## 227 Hardcover Business Books
## 228 Health
## 229 Humor
## 230 Indigenous Americans
## 231 Paperback Business Books
## 232 Politics
## 233 Race and Civil Rights
## 234 Relationships
## 235 Religion, Spirituality and Faith
## 236 Science
## 237 Sports
## 238 Travel
## list_name_encoded oldest_published_date
## 1 combined-print-and-e-book-fiction 2011-02-13
## 2 combined-print-and-e-book-nonfiction 2011-02-13
## 3 hardcover-fiction 2008-06-08
## 4 combined-print-and-e-book-fiction 2011-02-13
## 5 combined-print-and-e-book-nonfiction 2011-02-13
## 6 hardcover-fiction 2008-06-08
## 7 hardcover-nonfiction 2008-06-08
## 8 trade-fiction-paperback 2008-06-08
## 9 mass-market-paperback 2008-06-08
## 10 paperback-nonfiction 2008-06-08
## 11 e-book-fiction 2011-02-13
## 12 e-book-nonfiction 2011-02-13
## 13 hardcover-advice 2008-06-08
## 14 paperback-advice 2008-06-08
## 15 advice-how-to-and-miscellaneous 2013-04-28
## 16 picture-books 2008-06-08
## 17 chapter-books 2008-06-08
## 18 childrens-middle-grade 2012-12-16
## 19 young-adult 2012-12-16
## 20 paperback-books 2008-06-08
## 21 series-books 2008-06-08
## 22 hardcover-graphic-books 2009-03-15
## 23 paperback-graphic-books 2009-03-15
## 24 manga 2009-03-15
## 25 combined-print-fiction 2011-02-13
## 26 combined-print-nonfiction 2011-02-13
## 27 animals 2014-09-07
## 28 business-books 2013-11-03
## 29 celebrities 2014-09-07
## 30 crime-and-punishment 2014-10-12
## 31 culture 2014-10-12
## 32 education 2014-10-12
## 33 espionage 2014-12-14
## 34 expeditions-disasters-and-adventures 2014-12-14
## 35 family 2014-09-07
## 36 fashion-manners-and-customs 2014-10-12
## 37 food-and-fitness 2013-09-01
## 38 games-and-activities 2014-10-12
## 39 hardcover-business-books 2011-07-03
## 40 health 2014-10-12
## 41 humor 2014-09-07
## 42 indigenous-americans 2014-12-14
## 43 paperback-business-books 2011-07-03
## 44 hardcover-political-books 2011-07-03
## 45 race-and-civil-rights 2014-12-14
## 46 relationships 2014-09-07
## 47 religion-spirituality-and-faith 2014-09-07
## 48 science 2013-04-14
## 49 sports 2014-03-02
## 50 travel 2014-09-07
## 51 combined-print-and-e-book-fiction 2011-02-13
## 52 combined-print-and-e-book-nonfiction 2011-02-13
## 53 hardcover-fiction 2008-06-08
## 54 hardcover-nonfiction 2008-06-08
## 55 trade-fiction-paperback 2008-06-08
## 56 mass-market-paperback 2008-06-08
## 57 paperback-nonfiction 2008-06-08
## 58 e-book-fiction 2011-02-13
## 59 e-book-nonfiction 2011-02-13
## 60 hardcover-advice 2008-06-08
## 61 paperback-advice 2008-06-08
## 62 advice-how-to-and-miscellaneous 2013-04-28
## 63 picture-books 2008-06-08
## 64 chapter-books 2008-06-08
## 65 childrens-middle-grade 2012-12-16
## 66 young-adult 2012-12-16
## 67 paperback-books 2008-06-08
## 68 series-books 2008-06-08
## 69 hardcover-graphic-books 2009-03-15
## 70 paperback-graphic-books 2009-03-15
## 71 manga 2009-03-15
## 72 combined-print-fiction 2011-02-13
## 73 combined-print-nonfiction 2011-02-13
## 74 animals 2014-09-07
## 75 business-books 2013-11-03
## 76 celebrities 2014-09-07
## 77 crime-and-punishment 2014-10-12
## 78 culture 2014-10-12
## 79 education 2014-10-12
## 80 espionage 2014-12-14
## 81 expeditions-disasters-and-adventures 2014-12-14
## 82 family 2014-09-07
## 83 fashion-manners-and-customs 2014-10-12
## 84 food-and-fitness 2013-09-01
## 85 games-and-activities 2014-10-12
## 86 hardcover-business-books 2011-07-03
## 87 health 2014-10-12
## 88 humor 2014-09-07
## 89 indigenous-americans 2014-12-14
## 90 paperback-business-books 2011-07-03
## 91 hardcover-political-books 2011-07-03
## 92 race-and-civil-rights 2014-12-14
## 93 relationships 2014-09-07
## 94 religion-spirituality-and-faith 2014-09-07
## 95 science 2013-04-14
## 96 sports 2014-03-02
## 97 travel 2014-09-07
## 98 combined-print-and-e-book-fiction 2011-02-13
## 99 combined-print-and-e-book-nonfiction 2011-02-13
## 100 hardcover-fiction 2008-06-08
## 101 hardcover-nonfiction 2008-06-08
## 102 trade-fiction-paperback 2008-06-08
## 103 mass-market-paperback 2008-06-08
## 104 paperback-nonfiction 2008-06-08
## 105 e-book-fiction 2011-02-13
## 106 e-book-nonfiction 2011-02-13
## 107 hardcover-advice 2008-06-08
## 108 paperback-advice 2008-06-08
## 109 advice-how-to-and-miscellaneous 2013-04-28
## 110 picture-books 2008-06-08
## 111 chapter-books 2008-06-08
## 112 childrens-middle-grade 2012-12-16
## 113 young-adult 2012-12-16
## 114 paperback-books 2008-06-08
## 115 series-books 2008-06-08
## 116 hardcover-graphic-books 2009-03-15
## 117 manga 2009-03-15
## 118 paperback-graphic-books 2009-03-15
## 119 combined-print-fiction 2011-02-13
## 120 combined-print-nonfiction 2011-02-13
## 121 animals 2014-09-07
## 122 business-books 2013-11-03
## 123 celebrities 2014-09-07
## 124 crime-and-punishment 2014-10-12
## 125 culture 2014-10-12
## 126 education 2014-10-12
## 127 espionage 2014-12-14
## 128 expeditions-disasters-and-adventures 2014-12-14
## 129 family 2014-09-07
## 130 fashion-manners-and-customs 2014-10-12
## 131 food-and-fitness 2013-09-01
## 132 games-and-activities 2014-10-12
## 133 hardcover-business-books 2011-07-03
## 134 health 2014-10-12
## 135 humor 2014-09-07
## 136 indigenous-americans 2014-12-14
## 137 paperback-business-books 2011-07-03
## 138 hardcover-political-books 2011-07-03
## 139 race-and-civil-rights 2014-12-14
## 140 relationships 2014-09-07
## 141 religion-spirituality-and-faith 2014-09-07
## 142 science 2013-04-14
## 143 sports 2014-03-02
## 144 travel 2014-09-07
## 145 combined-print-and-e-book-fiction 2011-02-13
## 146 combined-print-and-e-book-nonfiction 2011-02-13
## 147 hardcover-fiction 2008-06-08
## 148 hardcover-nonfiction 2008-06-08
## 149 trade-fiction-paperback 2008-06-08
## 150 mass-market-paperback 2008-06-08
## 151 paperback-nonfiction 2008-06-08
## 152 e-book-fiction 2011-02-13
## 153 e-book-nonfiction 2011-02-13
## 154 hardcover-advice 2008-06-08
## 155 paperback-advice 2008-06-08
## 156 advice-how-to-and-miscellaneous 2013-04-28
## 157 picture-books 2008-06-08
## 158 chapter-books 2008-06-08
## 159 childrens-middle-grade 2012-12-16
## 160 young-adult 2012-12-16
## 161 paperback-books 2008-06-08
## 162 series-books 2008-06-08
## 163 hardcover-graphic-books 2009-03-15
## 164 paperback-graphic-books 2009-03-15
## 165 manga 2009-03-15
## 166 combined-print-fiction 2011-02-13
## 167 combined-print-nonfiction 2011-02-13
## 168 animals 2014-09-07
## 169 business-books 2013-11-03
## 170 celebrities 2014-09-07
## 171 crime-and-punishment 2014-10-12
## 172 culture 2014-10-12
## 173 education 2014-10-12
## 174 espionage 2014-12-14
## 175 expeditions-disasters-and-adventures 2014-12-14
## 176 family 2014-09-07
## 177 fashion-manners-and-customs 2014-10-12
## 178 food-and-fitness 2013-09-01
## 179 games-and-activities 2014-10-12
## 180 hardcover-business-books 2011-07-03
## 181 health 2014-10-12
## 182 humor 2014-09-07
## 183 indigenous-americans 2014-12-14
## 184 paperback-business-books 2011-07-03
## 185 hardcover-political-books 2011-07-03
## 186 race-and-civil-rights 2014-12-14
## 187 relationships 2014-09-07
## 188 religion-spirituality-and-faith 2014-09-07
## 189 science 2013-04-14
## 190 sports 2014-03-02
## 191 travel 2014-09-07
## 192 combined-print-and-e-book-fiction 2011-02-13
## 193 combined-print-and-e-book-nonfiction 2011-02-13
## 194 hardcover-fiction 2008-06-08
## 195 hardcover-nonfiction 2008-06-08
## 196 trade-fiction-paperback 2008-06-08
## 197 mass-market-paperback 2008-06-08
## 198 paperback-nonfiction 2008-06-08
## 199 e-book-fiction 2011-02-13
## 200 e-book-nonfiction 2011-02-13
## 201 hardcover-advice 2008-06-08
## 202 paperback-advice 2008-06-08
## 203 advice-how-to-and-miscellaneous 2013-04-28
## 204 picture-books 2008-06-08
## 205 chapter-books 2008-06-08
## 206 childrens-middle-grade 2012-12-16
## 207 young-adult 2012-12-16
## 208 paperback-books 2008-06-08
## 209 series-books 2008-06-08
## 210 hardcover-graphic-books 2009-03-15
## 211 paperback-graphic-books 2009-03-15
## 212 manga 2009-03-15
## 213 combined-print-fiction 2011-02-13
## 214 combined-print-nonfiction 2011-02-13
## 215 animals 2014-09-07
## 216 business-books 2013-11-03
## 217 celebrities 2014-09-07
## 218 crime-and-punishment 2014-10-12
## 219 culture 2014-10-12
## 220 education 2014-10-12
## 221 espionage 2014-12-14
## 222 expeditions-disasters-and-adventures 2014-12-14
## 223 family 2014-09-07
## 224 fashion-manners-and-customs 2014-10-12
## 225 food-and-fitness 2013-09-01
## 226 games-and-activities 2014-10-12
## 227 hardcover-business-books 2011-07-03
## 228 health 2014-10-12
## 229 humor 2014-09-07
## 230 indigenous-americans 2014-12-14
## 231 paperback-business-books 2011-07-03
## 232 hardcover-political-books 2011-07-03
## 233 race-and-civil-rights 2014-12-14
## 234 relationships 2014-09-07
## 235 religion-spirituality-and-faith 2014-09-07
## 236 science 2013-04-14
## 237 sports 2014-03-02
## 238 travel 2014-09-07
## newest_published_date updated
## 1 2015-04-26 WEEKLY
## 2 2015-04-26 WEEKLY
## 3 2015-04-26 WEEKLY
## 4 2015-04-26 WEEKLY
## 5 2015-04-26 WEEKLY
## 6 2015-04-26 WEEKLY
## 7 2015-04-26 WEEKLY
## 8 2015-04-26 WEEKLY
## 9 2015-04-26 WEEKLY
## 10 2015-04-26 WEEKLY
## 11 2015-04-26 WEEKLY
## 12 2015-04-26 WEEKLY
## 13 2013-04-21 WEEKLY
## 14 2013-04-21 WEEKLY
## 15 2015-04-26 WEEKLY
## 16 2015-04-26 WEEKLY
## 17 2012-12-09 WEEKLY
## 18 2015-04-26 WEEKLY
## 19 2015-04-26 WEEKLY
## 20 2012-12-09 WEEKLY
## 21 2015-04-26 WEEKLY
## 22 2015-04-26 WEEKLY
## 23 2015-04-26 WEEKLY
## 24 2015-04-26 WEEKLY
## 25 2013-05-12 WEEKLY
## 26 2013-05-12 WEEKLY
## 27 2015-04-12 MONTHLY
## 28 2015-04-12 MONTHLY
## 29 2015-04-12 MONTHLY
## 30 2015-04-12 MONTHLY
## 31 2015-04-12 MONTHLY
## 32 2015-04-12 MONTHLY
## 33 2015-04-12 MONTHLY
## 34 2015-04-12 MONTHLY
## 35 2015-04-12 MONTHLY
## 36 2015-04-12 MONTHLY
## 37 2015-04-12 MONTHLY
## 38 2015-04-12 MONTHLY
## 39 2013-10-13 MONTHLY
## 40 2015-04-12 MONTHLY
## 41 2015-04-12 MONTHLY
## 42 2015-04-12 MONTHLY
## 43 2013-10-13 MONTHLY
## 44 2015-04-12 MONTHLY
## 45 2015-04-12 MONTHLY
## 46 2015-03-15 MONTHLY
## 47 2015-04-12 MONTHLY
## 48 2015-04-12 MONTHLY
## 49 2015-04-12 MONTHLY
## 50 2015-04-12 MONTHLY
## 51 2015-04-26 WEEKLY
## 52 2015-04-26 WEEKLY
## 53 2015-04-26 WEEKLY
## 54 2015-04-26 WEEKLY
## 55 2015-04-26 WEEKLY
## 56 2015-04-26 WEEKLY
## 57 2015-04-26 WEEKLY
## 58 2015-04-26 WEEKLY
## 59 2015-04-26 WEEKLY
## 60 2013-04-21 WEEKLY
## 61 2013-04-21 WEEKLY
## 62 2015-04-26 WEEKLY
## 63 2015-04-26 WEEKLY
## 64 2012-12-09 WEEKLY
## 65 2015-04-26 WEEKLY
## 66 2015-04-26 WEEKLY
## 67 2012-12-09 WEEKLY
## 68 2015-04-26 WEEKLY
## 69 2015-04-26 WEEKLY
## 70 2015-04-26 WEEKLY
## 71 2015-04-26 WEEKLY
## 72 2013-05-12 WEEKLY
## 73 2013-05-12 WEEKLY
## 74 2015-04-12 MONTHLY
## 75 2015-04-12 MONTHLY
## 76 2015-04-12 MONTHLY
## 77 2015-04-12 MONTHLY
## 78 2015-04-12 MONTHLY
## 79 2015-04-12 MONTHLY
## 80 2015-04-12 MONTHLY
## 81 2015-04-12 MONTHLY
## 82 2015-04-12 MONTHLY
## 83 2015-04-12 MONTHLY
## 84 2015-04-12 MONTHLY
## 85 2015-04-12 MONTHLY
## 86 2013-10-13 MONTHLY
## 87 2015-04-12 MONTHLY
## 88 2015-04-12 MONTHLY
## 89 2015-04-12 MONTHLY
## 90 2013-10-13 MONTHLY
## 91 2015-04-12 MONTHLY
## 92 2015-04-12 MONTHLY
## 93 2015-03-15 MONTHLY
## 94 2015-04-12 MONTHLY
## 95 2015-04-12 MONTHLY
## 96 2015-04-12 MONTHLY
## 97 2015-04-12 MONTHLY
## 98 2015-04-26 WEEKLY
## 99 2015-04-26 WEEKLY
## 100 2015-04-26 WEEKLY
## 101 2015-04-26 WEEKLY
## 102 2015-04-26 WEEKLY
## 103 2015-04-26 WEEKLY
## 104 2015-04-26 WEEKLY
## 105 2015-04-26 WEEKLY
## 106 2015-04-26 WEEKLY
## 107 2013-04-21 WEEKLY
## 108 2013-04-21 WEEKLY
## 109 2015-04-26 WEEKLY
## 110 2015-04-26 WEEKLY
## 111 2012-12-09 WEEKLY
## 112 2015-04-26 WEEKLY
## 113 2015-04-26 WEEKLY
## 114 2012-12-09 WEEKLY
## 115 2015-04-26 WEEKLY
## 116 2015-04-26 WEEKLY
## 117 2015-04-26 WEEKLY
## 118 2015-04-26 WEEKLY
## 119 2013-05-12 WEEKLY
## 120 2013-05-12 WEEKLY
## 121 2015-04-12 MONTHLY
## 122 2015-04-12 MONTHLY
## 123 2015-04-12 MONTHLY
## 124 2015-04-12 MONTHLY
## 125 2015-04-12 MONTHLY
## 126 2015-04-12 MONTHLY
## 127 2015-04-12 MONTHLY
## 128 2015-04-12 MONTHLY
## 129 2015-04-12 MONTHLY
## 130 2015-04-12 MONTHLY
## 131 2015-04-12 MONTHLY
## 132 2015-04-12 MONTHLY
## 133 2013-10-13 MONTHLY
## 134 2015-04-12 MONTHLY
## 135 2015-04-12 MONTHLY
## 136 2015-04-12 MONTHLY
## 137 2013-10-13 MONTHLY
## 138 2015-04-12 MONTHLY
## 139 2015-04-12 MONTHLY
## 140 2015-03-15 MONTHLY
## 141 2015-04-12 MONTHLY
## 142 2015-04-12 MONTHLY
## 143 2015-04-12 MONTHLY
## 144 2015-04-12 MONTHLY
## 145 2015-04-26 WEEKLY
## 146 2015-04-26 WEEKLY
## 147 2015-04-26 WEEKLY
## 148 2015-04-26 WEEKLY
## 149 2015-04-26 WEEKLY
## 150 2015-04-26 WEEKLY
## 151 2015-04-26 WEEKLY
## 152 2015-04-26 WEEKLY
## 153 2015-04-26 WEEKLY
## 154 2013-04-21 WEEKLY
## 155 2013-04-21 WEEKLY
## 156 2015-04-26 WEEKLY
## 157 2015-04-26 WEEKLY
## 158 2012-12-09 WEEKLY
## 159 2015-04-26 WEEKLY
## 160 2015-04-26 WEEKLY
## 161 2012-12-09 WEEKLY
## 162 2015-04-26 WEEKLY
## 163 2015-04-26 WEEKLY
## 164 2015-04-26 WEEKLY
## 165 2015-04-26 WEEKLY
## 166 2013-05-12 WEEKLY
## 167 2013-05-12 WEEKLY
## 168 2015-04-12 MONTHLY
## 169 2015-04-12 MONTHLY
## 170 2015-04-12 MONTHLY
## 171 2015-04-12 MONTHLY
## 172 2015-04-12 MONTHLY
## 173 2015-04-12 MONTHLY
## 174 2015-04-12 MONTHLY
## 175 2015-04-12 MONTHLY
## 176 2015-04-12 MONTHLY
## 177 2015-04-12 MONTHLY
## 178 2015-04-12 MONTHLY
## 179 2015-04-12 MONTHLY
## 180 2013-10-13 MONTHLY
## 181 2015-04-12 MONTHLY
## 182 2015-04-12 MONTHLY
## 183 2015-04-12 MONTHLY
## 184 2013-10-13 MONTHLY
## 185 2015-04-12 MONTHLY
## 186 2015-04-12 MONTHLY
## 187 2015-03-15 MONTHLY
## 188 2015-04-12 MONTHLY
## 189 2015-04-12 MONTHLY
## 190 2015-04-12 MONTHLY
## 191 2015-04-12 MONTHLY
## 192 2015-04-26 WEEKLY
## 193 2015-04-26 WEEKLY
## 194 2015-04-26 WEEKLY
## 195 2015-04-26 WEEKLY
## 196 2015-04-26 WEEKLY
## 197 2015-04-26 WEEKLY
## 198 2015-04-26 WEEKLY
## 199 2015-04-26 WEEKLY
## 200 2015-04-26 WEEKLY
## 201 2013-04-21 WEEKLY
## 202 2013-04-21 WEEKLY
## 203 2015-04-26 WEEKLY
## 204 2015-04-26 WEEKLY
## 205 2012-12-09 WEEKLY
## 206 2015-04-26 WEEKLY
## 207 2015-04-26 WEEKLY
## 208 2012-12-09 WEEKLY
## 209 2015-04-26 WEEKLY
## 210 2015-04-26 WEEKLY
## 211 2015-04-26 WEEKLY
## 212 2015-04-26 WEEKLY
## 213 2013-05-12 WEEKLY
## 214 2013-05-12 WEEKLY
## 215 2015-04-12 MONTHLY
## 216 2015-04-12 MONTHLY
## 217 2015-04-12 MONTHLY
## 218 2015-04-12 MONTHLY
## 219 2015-04-12 MONTHLY
## 220 2015-04-12 MONTHLY
## 221 2015-04-12 MONTHLY
## 222 2015-04-12 MONTHLY
## 223 2015-04-12 MONTHLY
## 224 2015-04-12 MONTHLY
## 225 2015-04-12 MONTHLY
## 226 2015-04-12 MONTHLY
## 227 2013-10-13 MONTHLY
## 228 2015-04-12 MONTHLY
## 229 2015-04-12 MONTHLY
## 230 2015-04-12 MONTHLY
## 231 2013-10-13 MONTHLY
## 232 2015-04-12 MONTHLY
## 233 2015-04-12 MONTHLY
## 234 2015-03-15 MONTHLY
## 235 2015-04-12 MONTHLY
## 236 2015-04-12 MONTHLY
## 237 2015-04-12 MONTHLY
## 238 2015-04-12 MONTHLYThe above code connects to mongodb, reads the documents of a collection present in nytimes database, and finally converts the documents to a R data frame.
You may optionally execute the following R code to remove the _ID column from the data frame
books_df[1] <- NULL
head(books_df)## list_name display_name
## 1 Combined Print and E-Book Fiction Combined Print & E-Book Fiction
## 2 Combined Print and E-Book Nonfiction Combined Print & E-Book Nonfiction
## 3 Hardcover Fiction Hardcover Fiction
## 4 Combined Print and E-Book Fiction Combined Print & E-Book Fiction
## 5 Combined Print and E-Book Nonfiction Combined Print & E-Book Nonfiction
## 6 Hardcover Fiction Hardcover Fiction
## list_name_encoded oldest_published_date
## 1 combined-print-and-e-book-fiction 2011-02-13
## 2 combined-print-and-e-book-nonfiction 2011-02-13
## 3 hardcover-fiction 2008-06-08
## 4 combined-print-and-e-book-fiction 2011-02-13
## 5 combined-print-and-e-book-nonfiction 2011-02-13
## 6 hardcover-fiction 2008-06-08
## newest_published_date updated
## 1 2015-04-26 WEEKLY
## 2 2015-04-26 WEEKLY
## 3 2015-04-26 WEEKLY
## 4 2015-04-26 WEEKLY
## 5 2015-04-26 WEEKLY
## 6 2015-04-26 WEEKLY-~-End of Assignment-~-