ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Anasco" and state = "Puerto Rico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536749 | 536749 | 2020-09-15 | Anasco | Puerto Rico | 72011 | 206 | |
533513 | 533513 | 2020-09-14 | Anasco | Puerto Rico | 72011 | 202 | |
530278 | 530278 | 2020-09-13 | Anasco | Puerto Rico | 72011 | 201 | |
527041 | 527041 | 2020-09-12 | Anasco | Puerto Rico | 72011 | 200 | |
523805 | 523805 | 2020-09-11 | Anasco | Puerto Rico | 72011 | 198 | |
520569 | 520569 | 2020-09-10 | Anasco | Puerto Rico | 72011 | 196 | |
517333 | 517333 | 2020-09-09 | Anasco | Puerto Rico | 72011 | 194 | |
514098 | 514098 | 2020-09-08 | Anasco | Puerto Rico | 72011 | 194 | |
510865 | 510865 | 2020-09-07 | Anasco | Puerto Rico | 72011 | 194 | |
507632 | 507632 | 2020-09-06 | Anasco | Puerto Rico | 72011 | 194 | |
504400 | 504400 | 2020-09-05 | Anasco | Puerto Rico | 72011 | 194 | |
501166 | 501166 | 2020-09-04 | Anasco | Puerto Rico | 72011 | 193 | |
497932 | 497932 | 2020-09-03 | Anasco | Puerto Rico | 72011 | 193 | |
494699 | 494699 | 2020-09-02 | Anasco | Puerto Rico | 72011 | 192 | |
491465 | 491465 | 2020-09-01 | Anasco | Puerto Rico | 72011 | 193 | |
488232 | 488232 | 2020-08-31 | Anasco | Puerto Rico | 72011 | 192 | |
484999 | 484999 | 2020-08-30 | Anasco | Puerto Rico | 72011 | 192 | |
481764 | 481764 | 2020-08-29 | Anasco | Puerto Rico | 72011 | 191 | |
478530 | 478530 | 2020-08-28 | Anasco | Puerto Rico | 72011 | 188 | |
475297 | 475297 | 2020-08-27 | Anasco | Puerto Rico | 72011 | 182 | |
472063 | 472063 | 2020-08-26 | Anasco | Puerto Rico | 72011 | 180 | |
468831 | 468831 | 2020-08-25 | Anasco | Puerto Rico | 72011 | 180 | |
465603 | 465603 | 2020-08-24 | Anasco | Puerto Rico | 72011 | 179 | |
462374 | 462374 | 2020-08-23 | Anasco | Puerto Rico | 72011 | 177 | |
459146 | 459146 | 2020-08-22 | Anasco | Puerto Rico | 72011 | 175 | |
455918 | 455918 | 2020-08-21 | Anasco | Puerto Rico | 72011 | 169 | |
452690 | 452690 | 2020-08-20 | Anasco | Puerto Rico | 72011 | 166 | |
449462 | 449462 | 2020-08-19 | Anasco | Puerto Rico | 72011 | 166 | |
446234 | 446234 | 2020-08-18 | Anasco | Puerto Rico | 72011 | 166 | |
443008 | 443008 | 2020-08-17 | Anasco | Puerto Rico | 72011 | 161 | |
439781 | 439781 | 2020-08-16 | Anasco | Puerto Rico | 72011 | 156 | |
436556 | 436556 | 2020-08-15 | Anasco | Puerto Rico | 72011 | 153 | |
433329 | 433329 | 2020-08-14 | Anasco | Puerto Rico | 72011 | 151 | |
430103 | 430103 | 2020-08-13 | Anasco | Puerto Rico | 72011 | 150 | |
426878 | 426878 | 2020-08-12 | Anasco | Puerto Rico | 72011 | 150 | |
423655 | 423655 | 2020-08-11 | Anasco | Puerto Rico | 72011 | 147 | |
420432 | 420432 | 2020-08-10 | Anasco | Puerto Rico | 72011 | 145 | |
417212 | 417212 | 2020-08-09 | Anasco | Puerto Rico | 72011 | 142 | |
413991 | 413991 | 2020-08-08 | Anasco | Puerto Rico | 72011 | 134 | |
410771 | 410771 | 2020-08-07 | Anasco | Puerto Rico | 72011 | 131 | |
407551 | 407551 | 2020-08-06 | Anasco | Puerto Rico | 72011 | 131 | |
404332 | 404332 | 2020-08-05 | Anasco | Puerto Rico | 72011 | 130 | |
401114 | 401114 | 2020-08-04 | Anasco | Puerto Rico | 72011 | 128 | |
397899 | 397899 | 2020-08-03 | Anasco | Puerto Rico | 72011 | 125 | |
394682 | 394682 | 2020-08-02 | Anasco | Puerto Rico | 72011 | 124 | |
391466 | 391466 | 2020-08-01 | Anasco | Puerto Rico | 72011 | 122 | |
388249 | 388249 | 2020-07-31 | Anasco | Puerto Rico | 72011 | 108 | |
385032 | 385032 | 2020-07-30 | Anasco | Puerto Rico | 72011 | 108 | |
381814 | 381814 | 2020-07-29 | Anasco | Puerto Rico | 72011 | 105 | |
378597 | 378597 | 2020-07-28 | Anasco | Puerto Rico | 72011 | 105 | |
375381 | 375381 | 2020-07-27 | Anasco | Puerto Rico | 72011 | 103 | |
372168 | 372168 | 2020-07-26 | Anasco | Puerto Rico | 72011 | 101 | |
368956 | 368956 | 2020-07-25 | Anasco | Puerto Rico | 72011 | 99 | |
365747 | 365747 | 2020-07-24 | Anasco | Puerto Rico | 72011 | 97 | |
362541 | 362541 | 2020-07-23 | Anasco | Puerto Rico | 72011 | 97 | |
359335 | 359335 | 2020-07-22 | Anasco | Puerto Rico | 72011 | 92 | |
356131 | 356131 | 2020-07-21 | Anasco | Puerto Rico | 72011 | 92 | |
352928 | 352928 | 2020-07-20 | Anasco | Puerto Rico | 72011 | 89 | |
349725 | 349725 | 2020-07-19 | Anasco | Puerto Rico | 72011 | 88 | |
346525 | 346525 | 2020-07-18 | Anasco | Puerto Rico | 72011 | 85 | |
343325 | 343325 | 2020-07-17 | Anasco | Puerto Rico | 72011 | 84 | |
340127 | 340127 | 2020-07-16 | Anasco | Puerto Rico | 72011 | 82 | |
336930 | 336930 | 2020-07-15 | Anasco | Puerto Rico | 72011 | 83 | |
333736 | 333736 | 2020-07-14 | Anasco | Puerto Rico | 72011 | 78 | |
330544 | 330544 | 2020-07-13 | Anasco | Puerto Rico | 72011 | 77 | |
327358 | 327358 | 2020-07-12 | Anasco | Puerto Rico | 72011 | 75 | |
324173 | 324173 | 2020-07-11 | Anasco | Puerto Rico | 72011 | 70 | |
320993 | 320993 | 2020-07-10 | Anasco | Puerto Rico | 72011 | 66 | |
317815 | 317815 | 2020-07-09 | Anasco | Puerto Rico | 72011 | 66 | |
314642 | 314642 | 2020-07-08 | Anasco | Puerto Rico | 72011 | 63 | |
311470 | 311470 | 2020-07-07 | Anasco | Puerto Rico | 72011 | 63 | |
308301 | 308301 | 2020-07-06 | Anasco | Puerto Rico | 72011 | 60 | |
305134 | 305134 | 2020-07-05 | Anasco | Puerto Rico | 72011 | 49 | |
301971 | 301971 | 2020-07-04 | Anasco | Puerto Rico | 72011 | 47 | |
298807 | 298807 | 2020-07-03 | Anasco | Puerto Rico | 72011 | 46 | |
295648 | 295648 | 2020-07-02 | Anasco | Puerto Rico | 72011 | 46 | |
292492 | 292492 | 2020-07-01 | Anasco | Puerto Rico | 72011 | 46 | |
289340 | 289340 | 2020-06-30 | Anasco | Puerto Rico | 72011 | 45 | |
286189 | 286189 | 2020-06-29 | Anasco | Puerto Rico | 72011 | 45 | |
283044 | 283044 | 2020-06-28 | Anasco | Puerto Rico | 72011 | 45 | |
279898 | 279898 | 2020-06-27 | Anasco | Puerto Rico | 72011 | 44 | |
276750 | 276750 | 2020-06-26 | Anasco | Puerto Rico | 72011 | 43 | |
273603 | 273603 | 2020-06-25 | Anasco | Puerto Rico | 72011 | 43 | |
270464 | 270464 | 2020-06-24 | Anasco | Puerto Rico | 72011 | 37 | |
267330 | 267330 | 2020-06-23 | Anasco | Puerto Rico | 72011 | 37 | |
264202 | 264202 | 2020-06-22 | Anasco | Puerto Rico | 72011 | 37 | |
261074 | 261074 | 2020-06-21 | Anasco | Puerto Rico | 72011 | 37 | |
257947 | 257947 | 2020-06-20 | Anasco | Puerto Rico | 72011 | 37 | |
254821 | 254821 | 2020-06-19 | Anasco | Puerto Rico | 72011 | 37 | |
251706 | 251706 | 2020-06-18 | Anasco | Puerto Rico | 72011 | 37 | |
248591 | 248591 | 2020-06-17 | Anasco | Puerto Rico | 72011 | 37 | |
245478 | 245478 | 2020-06-16 | Anasco | Puerto Rico | 72011 | 37 | |
242366 | 242366 | 2020-06-15 | Anasco | Puerto Rico | 72011 | 37 | |
239257 | 239257 | 2020-06-14 | Anasco | Puerto Rico | 72011 | 37 | |
236149 | 236149 | 2020-06-13 | Anasco | Puerto Rico | 72011 | 37 | |
233044 | 233044 | 2020-06-12 | Anasco | Puerto Rico | 72011 | 37 | |
229939 | 229939 | 2020-06-11 | Anasco | Puerto Rico | 72011 | 37 | |
226835 | 226835 | 2020-06-10 | Anasco | Puerto Rico | 72011 | 37 | |
223735 | 223735 | 2020-06-09 | Anasco | Puerto Rico | 72011 | 37 | |
220640 | 220640 | 2020-06-08 | Anasco | Puerto Rico | 72011 | 34 |
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);