ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72031 and state = "Puerto Rico" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
117502 | 117502 | 2020-05-05 | Carolina | Puerto Rico | 72031 | 87 | |
120464 | 120464 | 2020-05-06 | Carolina | Puerto Rico | 72031 | 88 | |
123441 | 123441 | 2020-05-07 | Carolina | Puerto Rico | 72031 | 90 | |
126424 | 126424 | 2020-05-08 | Carolina | Puerto Rico | 72031 | 93 | |
129413 | 129413 | 2020-05-09 | Carolina | Puerto Rico | 72031 | 93 | |
132402 | 132402 | 2020-05-10 | Carolina | Puerto Rico | 72031 | 95 | |
135393 | 135393 | 2020-05-11 | Carolina | Puerto Rico | 72031 | 97 | |
138383 | 138383 | 2020-05-12 | Carolina | Puerto Rico | 72031 | 99 | |
141379 | 141379 | 2020-05-13 | Carolina | Puerto Rico | 72031 | 100 | |
144375 | 144375 | 2020-05-14 | Carolina | Puerto Rico | 72031 | 104 | |
147376 | 147376 | 2020-05-15 | Carolina | Puerto Rico | 72031 | 108 | |
150383 | 150383 | 2020-05-16 | Carolina | Puerto Rico | 72031 | 109 | |
153394 | 153394 | 2020-05-17 | Carolina | Puerto Rico | 72031 | 110 | |
156411 | 156411 | 2020-05-18 | Carolina | Puerto Rico | 72031 | 112 | |
159432 | 159432 | 2020-05-19 | Carolina | Puerto Rico | 72031 | 115 | |
162459 | 162459 | 2020-05-20 | Carolina | Puerto Rico | 72031 | 117 | |
165488 | 165488 | 2020-05-21 | Carolina | Puerto Rico | 72031 | 119 | |
168524 | 168524 | 2020-05-22 | Carolina | Puerto Rico | 72031 | 125 | |
171563 | 171563 | 2020-05-23 | Carolina | Puerto Rico | 72031 | 130 | |
174605 | 174605 | 2020-05-24 | Carolina | Puerto Rico | 72031 | 133 | |
177649 | 177649 | 2020-05-25 | Carolina | Puerto Rico | 72031 | 137 | |
180692 | 180692 | 2020-05-26 | Carolina | Puerto Rico | 72031 | 138 | |
183742 | 183742 | 2020-05-27 | Carolina | Puerto Rico | 72031 | 140 | |
186799 | 186799 | 2020-05-28 | Carolina | Puerto Rico | 72031 | 143 | |
189860 | 189860 | 2020-05-29 | Carolina | Puerto Rico | 72031 | 154 | |
192925 | 192925 | 2020-05-30 | Carolina | Puerto Rico | 72031 | 159 | |
195994 | 195994 | 2020-05-31 | Carolina | Puerto Rico | 72031 | 160 | |
199067 | 199067 | 2020-06-01 | Carolina | Puerto Rico | 72031 | 167 | |
202142 | 202142 | 2020-06-02 | Carolina | Puerto Rico | 72031 | 168 | |
205219 | 205219 | 2020-06-03 | Carolina | Puerto Rico | 72031 | 172 | |
208300 | 208300 | 2020-06-04 | Carolina | Puerto Rico | 72031 | 191 | |
211382 | 211382 | 2020-06-05 | Carolina | Puerto Rico | 72031 | 204 | |
214468 | 214468 | 2020-06-06 | Carolina | Puerto Rico | 72031 | 226 | |
217558 | 217558 | 2020-06-07 | Carolina | Puerto Rico | 72031 | 232 | |
220650 | 220650 | 2020-06-08 | Carolina | Puerto Rico | 72031 | 235 | |
223745 | 223745 | 2020-06-09 | Carolina | Puerto Rico | 72031 | 245 | |
226845 | 226845 | 2020-06-10 | Carolina | Puerto Rico | 72031 | 250 | |
229949 | 229949 | 2020-06-11 | Carolina | Puerto Rico | 72031 | 251 | |
233054 | 233054 | 2020-06-12 | Carolina | Puerto Rico | 72031 | 256 | |
236159 | 236159 | 2020-06-13 | Carolina | Puerto Rico | 72031 | 262 | |
239267 | 239267 | 2020-06-14 | Carolina | Puerto Rico | 72031 | 267 | |
242376 | 242376 | 2020-06-15 | Carolina | Puerto Rico | 72031 | 273 | |
245488 | 245488 | 2020-06-16 | Carolina | Puerto Rico | 72031 | 277 | |
248601 | 248601 | 2020-06-17 | Carolina | Puerto Rico | 72031 | 281 | |
251716 | 251716 | 2020-06-18 | Carolina | Puerto Rico | 72031 | 283 | |
254831 | 254831 | 2020-06-19 | Carolina | Puerto Rico | 72031 | 288 | |
257957 | 257957 | 2020-06-20 | Carolina | Puerto Rico | 72031 | 296 | |
261084 | 261084 | 2020-06-21 | Carolina | Puerto Rico | 72031 | 297 | |
264212 | 264212 | 2020-06-22 | Carolina | Puerto Rico | 72031 | 298 | |
267340 | 267340 | 2020-06-23 | Carolina | Puerto Rico | 72031 | 304 | |
270474 | 270474 | 2020-06-24 | Carolina | Puerto Rico | 72031 | 307 | |
273613 | 273613 | 2020-06-25 | Carolina | Puerto Rico | 72031 | 307 | |
276760 | 276760 | 2020-06-26 | Carolina | Puerto Rico | 72031 | 307 | |
279908 | 279908 | 2020-06-27 | Carolina | Puerto Rico | 72031 | 318 | |
283054 | 283054 | 2020-06-28 | Carolina | Puerto Rico | 72031 | 323 | |
286199 | 286199 | 2020-06-29 | Carolina | Puerto Rico | 72031 | 328 | |
292502 | 292502 | 2020-07-01 | Carolina | Puerto Rico | 72031 | 339 | |
289350 | 289350 | 2020-06-30 | Carolina | Puerto Rico | 72031 | 340 | |
295658 | 295658 | 2020-07-02 | Carolina | Puerto Rico | 72031 | 345 | |
298817 | 298817 | 2020-07-03 | Carolina | Puerto Rico | 72031 | 352 | |
301981 | 301981 | 2020-07-04 | Carolina | Puerto Rico | 72031 | 357 | |
305144 | 305144 | 2020-07-05 | Carolina | Puerto Rico | 72031 | 359 | |
308311 | 308311 | 2020-07-06 | Carolina | Puerto Rico | 72031 | 383 | |
311480 | 311480 | 2020-07-07 | Carolina | Puerto Rico | 72031 | 390 | |
314652 | 314652 | 2020-07-08 | Carolina | Puerto Rico | 72031 | 391 | |
317825 | 317825 | 2020-07-09 | Carolina | Puerto Rico | 72031 | 409 | |
321003 | 321003 | 2020-07-10 | Carolina | Puerto Rico | 72031 | 425 | |
324183 | 324183 | 2020-07-11 | Carolina | Puerto Rico | 72031 | 429 | |
327368 | 327368 | 2020-07-12 | Carolina | Puerto Rico | 72031 | 444 | |
330554 | 330554 | 2020-07-13 | Carolina | Puerto Rico | 72031 | 462 | |
333746 | 333746 | 2020-07-14 | Carolina | Puerto Rico | 72031 | 464 | |
336940 | 336940 | 2020-07-15 | Carolina | Puerto Rico | 72031 | 481 | |
340137 | 340137 | 2020-07-16 | Carolina | Puerto Rico | 72031 | 491 | |
343335 | 343335 | 2020-07-17 | Carolina | Puerto Rico | 72031 | 523 | |
346535 | 346535 | 2020-07-18 | Carolina | Puerto Rico | 72031 | 544 | |
349735 | 349735 | 2020-07-19 | Carolina | Puerto Rico | 72031 | 583 | |
352938 | 352938 | 2020-07-20 | Carolina | Puerto Rico | 72031 | 614 | |
356141 | 356141 | 2020-07-21 | Carolina | Puerto Rico | 72031 | 636 | |
359345 | 359345 | 2020-07-22 | Carolina | Puerto Rico | 72031 | 647 | |
362551 | 362551 | 2020-07-23 | Carolina | Puerto Rico | 72031 | 676 | |
365757 | 365757 | 2020-07-24 | Carolina | Puerto Rico | 72031 | 698 | |
368966 | 368966 | 2020-07-25 | Carolina | Puerto Rico | 72031 | 740 | |
372178 | 372178 | 2020-07-26 | Carolina | Puerto Rico | 72031 | 759 | |
375391 | 375391 | 2020-07-27 | Carolina | Puerto Rico | 72031 | 779 | |
378607 | 378607 | 2020-07-28 | Carolina | Puerto Rico | 72031 | 797 | |
381824 | 381824 | 2020-07-29 | Carolina | Puerto Rico | 72031 | 813 | |
385042 | 385042 | 2020-07-30 | Carolina | Puerto Rico | 72031 | 841 | |
388259 | 388259 | 2020-07-31 | Carolina | Puerto Rico | 72031 | 848 | |
391476 | 391476 | 2020-08-01 | Carolina | Puerto Rico | 72031 | 941 | |
394692 | 394692 | 2020-08-02 | Carolina | Puerto Rico | 72031 | 981 | |
397909 | 397909 | 2020-08-03 | Carolina | Puerto Rico | 72031 | 1015 | |
401124 | 401124 | 2020-08-04 | Carolina | Puerto Rico | 72031 | 1068 | |
404342 | 404342 | 2020-08-05 | Carolina | Puerto Rico | 72031 | 1103 | |
407561 | 407561 | 2020-08-06 | Carolina | Puerto Rico | 72031 | 1122 | |
410781 | 410781 | 2020-08-07 | Carolina | Puerto Rico | 72031 | 1184 | |
414001 | 414001 | 2020-08-08 | Carolina | Puerto Rico | 72031 | 1213 | |
417222 | 417222 | 2020-08-09 | Carolina | Puerto Rico | 72031 | 1263 | |
420442 | 420442 | 2020-08-10 | Carolina | Puerto Rico | 72031 | 1302 | |
423665 | 423665 | 2020-08-11 | Carolina | Puerto Rico | 72031 | 1337 | |
426888 | 426888 | 2020-08-12 | Carolina | Puerto Rico | 72031 | 1389 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);