ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72027 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 |
---|---|---|---|---|---|---|---|
637226 | 637226 | 2020-10-16 | Camuy | Puerto Rico | 72027 | 335 | |
633980 | 633980 | 2020-10-15 | Camuy | Puerto Rico | 72027 | 335 | |
630735 | 630735 | 2020-10-14 | Camuy | Puerto Rico | 72027 | 332 | |
627491 | 627491 | 2020-10-13 | Camuy | Puerto Rico | 72027 | 326 | |
624249 | 624249 | 2020-10-12 | Camuy | Puerto Rico | 72027 | 326 | |
621006 | 621006 | 2020-10-11 | Camuy | Puerto Rico | 72027 | 326 | |
617763 | 617763 | 2020-10-10 | Camuy | Puerto Rico | 72027 | 326 | |
614521 | 614521 | 2020-10-09 | Camuy | Puerto Rico | 72027 | 326 | |
611280 | 611280 | 2020-10-08 | Camuy | Puerto Rico | 72027 | 320 | |
608038 | 608038 | 2020-10-07 | Camuy | Puerto Rico | 72027 | 317 | |
604795 | 604795 | 2020-10-06 | Camuy | Puerto Rico | 72027 | 317 | |
601553 | 601553 | 2020-10-05 | Camuy | Puerto Rico | 72027 | 315 | |
598310 | 598310 | 2020-10-04 | Camuy | Puerto Rico | 72027 | 310 | |
595067 | 595067 | 2020-10-03 | Camuy | Puerto Rico | 72027 | 308 | |
591826 | 591826 | 2020-10-02 | Camuy | Puerto Rico | 72027 | 307 | |
588585 | 588585 | 2020-10-01 | Camuy | Puerto Rico | 72027 | 303 | |
585345 | 585345 | 2020-09-30 | Camuy | Puerto Rico | 72027 | 297 | |
582105 | 582105 | 2020-09-29 | Camuy | Puerto Rico | 72027 | 295 | |
578865 | 578865 | 2020-09-28 | Camuy | Puerto Rico | 72027 | 290 | |
575624 | 575624 | 2020-09-27 | Camuy | Puerto Rico | 72027 | 283 | |
572380 | 572380 | 2020-09-26 | Camuy | Puerto Rico | 72027 | 278 | |
569138 | 569138 | 2020-09-25 | Camuy | Puerto Rico | 72027 | 269 | |
565897 | 565897 | 2020-09-24 | Camuy | Puerto Rico | 72027 | 262 | |
562656 | 562656 | 2020-09-23 | Camuy | Puerto Rico | 72027 | 249 | |
559419 | 559419 | 2020-09-22 | Camuy | Puerto Rico | 72027 | 249 | |
556182 | 556182 | 2020-09-21 | Camuy | Puerto Rico | 72027 | 248 | |
552945 | 552945 | 2020-09-20 | Camuy | Puerto Rico | 72027 | 241 | |
549706 | 549706 | 2020-09-19 | Camuy | Puerto Rico | 72027 | 233 | |
546467 | 546467 | 2020-09-18 | Camuy | Puerto Rico | 72027 | 227 | |
543230 | 543230 | 2020-09-17 | Camuy | Puerto Rico | 72027 | 221 | |
539994 | 539994 | 2020-09-16 | Camuy | Puerto Rico | 72027 | 214 | |
536757 | 536757 | 2020-09-15 | Camuy | Puerto Rico | 72027 | 212 | |
533521 | 533521 | 2020-09-14 | Camuy | Puerto Rico | 72027 | 211 | |
530286 | 530286 | 2020-09-13 | Camuy | Puerto Rico | 72027 | 210 | |
527049 | 527049 | 2020-09-12 | Camuy | Puerto Rico | 72027 | 210 | |
523813 | 523813 | 2020-09-11 | Camuy | Puerto Rico | 72027 | 207 | |
520577 | 520577 | 2020-09-10 | Camuy | Puerto Rico | 72027 | 206 | |
517341 | 517341 | 2020-09-09 | Camuy | Puerto Rico | 72027 | 200 | |
514106 | 514106 | 2020-09-08 | Camuy | Puerto Rico | 72027 | 200 | |
510873 | 510873 | 2020-09-07 | Camuy | Puerto Rico | 72027 | 201 | |
507640 | 507640 | 2020-09-06 | Camuy | Puerto Rico | 72027 | 197 | |
504408 | 504408 | 2020-09-05 | Camuy | Puerto Rico | 72027 | 197 | |
501174 | 501174 | 2020-09-04 | Camuy | Puerto Rico | 72027 | 196 | |
497940 | 497940 | 2020-09-03 | Camuy | Puerto Rico | 72027 | 196 | |
494707 | 494707 | 2020-09-02 | Camuy | Puerto Rico | 72027 | 196 | |
491473 | 491473 | 2020-09-01 | Camuy | Puerto Rico | 72027 | 193 | |
488240 | 488240 | 2020-08-31 | Camuy | Puerto Rico | 72027 | 191 | |
485007 | 485007 | 2020-08-30 | Camuy | Puerto Rico | 72027 | 191 | |
481772 | 481772 | 2020-08-29 | Camuy | Puerto Rico | 72027 | 191 | |
478538 | 478538 | 2020-08-28 | Camuy | Puerto Rico | 72027 | 190 | |
475305 | 475305 | 2020-08-27 | Camuy | Puerto Rico | 72027 | 188 | |
472071 | 472071 | 2020-08-26 | Camuy | Puerto Rico | 72027 | 187 | |
468839 | 468839 | 2020-08-25 | Camuy | Puerto Rico | 72027 | 186 | |
465611 | 465611 | 2020-08-24 | Camuy | Puerto Rico | 72027 | 186 | |
462382 | 462382 | 2020-08-23 | Camuy | Puerto Rico | 72027 | 186 | |
459154 | 459154 | 2020-08-22 | Camuy | Puerto Rico | 72027 | 185 | |
455926 | 455926 | 2020-08-21 | Camuy | Puerto Rico | 72027 | 176 | |
452698 | 452698 | 2020-08-20 | Camuy | Puerto Rico | 72027 | 172 | |
449470 | 449470 | 2020-08-19 | Camuy | Puerto Rico | 72027 | 169 | |
446242 | 446242 | 2020-08-18 | Camuy | Puerto Rico | 72027 | 169 | |
443016 | 443016 | 2020-08-17 | Camuy | Puerto Rico | 72027 | 164 | |
439789 | 439789 | 2020-08-16 | Camuy | Puerto Rico | 72027 | 158 | |
436564 | 436564 | 2020-08-15 | Camuy | Puerto Rico | 72027 | 157 | |
433337 | 433337 | 2020-08-14 | Camuy | Puerto Rico | 72027 | 151 | |
430111 | 430111 | 2020-08-13 | Camuy | Puerto Rico | 72027 | 145 | |
426886 | 426886 | 2020-08-12 | Camuy | Puerto Rico | 72027 | 145 | |
423663 | 423663 | 2020-08-11 | Camuy | Puerto Rico | 72027 | 144 | |
420440 | 420440 | 2020-08-10 | Camuy | Puerto Rico | 72027 | 143 | |
417220 | 417220 | 2020-08-09 | Camuy | Puerto Rico | 72027 | 139 | |
413999 | 413999 | 2020-08-08 | Camuy | Puerto Rico | 72027 | 138 | |
410779 | 410779 | 2020-08-07 | Camuy | Puerto Rico | 72027 | 132 | |
407559 | 407559 | 2020-08-06 | Camuy | Puerto Rico | 72027 | 129 | |
404340 | 404340 | 2020-08-05 | Camuy | Puerto Rico | 72027 | 118 | |
401122 | 401122 | 2020-08-04 | Camuy | Puerto Rico | 72027 | 115 | |
397907 | 397907 | 2020-08-03 | Camuy | Puerto Rico | 72027 | 113 | |
394690 | 394690 | 2020-08-02 | Camuy | Puerto Rico | 72027 | 107 | |
391474 | 391474 | 2020-08-01 | Camuy | Puerto Rico | 72027 | 103 | |
388257 | 388257 | 2020-07-31 | Camuy | Puerto Rico | 72027 | 96 | |
385040 | 385040 | 2020-07-30 | Camuy | Puerto Rico | 72027 | 96 | |
381822 | 381822 | 2020-07-29 | Camuy | Puerto Rico | 72027 | 88 | |
378605 | 378605 | 2020-07-28 | Camuy | Puerto Rico | 72027 | 88 | |
375389 | 375389 | 2020-07-27 | Camuy | Puerto Rico | 72027 | 87 | |
372176 | 372176 | 2020-07-26 | Camuy | Puerto Rico | 72027 | 79 | |
368964 | 368964 | 2020-07-25 | Camuy | Puerto Rico | 72027 | 78 | |
365755 | 365755 | 2020-07-24 | Camuy | Puerto Rico | 72027 | 75 | |
362549 | 362549 | 2020-07-23 | Camuy | Puerto Rico | 72027 | 70 | |
359343 | 359343 | 2020-07-22 | Camuy | Puerto Rico | 72027 | 70 | |
356139 | 356139 | 2020-07-21 | Camuy | Puerto Rico | 72027 | 69 | |
352936 | 352936 | 2020-07-20 | Camuy | Puerto Rico | 72027 | 69 | |
349733 | 349733 | 2020-07-19 | Camuy | Puerto Rico | 72027 | 68 | |
346533 | 346533 | 2020-07-18 | Camuy | Puerto Rico | 72027 | 65 | |
343333 | 343333 | 2020-07-17 | Camuy | Puerto Rico | 72027 | 64 | |
340135 | 340135 | 2020-07-16 | Camuy | Puerto Rico | 72027 | 60 | |
336938 | 336938 | 2020-07-15 | Camuy | Puerto Rico | 72027 | 59 | |
333744 | 333744 | 2020-07-14 | Camuy | Puerto Rico | 72027 | 56 | |
330552 | 330552 | 2020-07-13 | Camuy | Puerto Rico | 72027 | 55 | |
327366 | 327366 | 2020-07-12 | Camuy | Puerto Rico | 72027 | 55 | |
324181 | 324181 | 2020-07-11 | Camuy | Puerto Rico | 72027 | 53 | |
321001 | 321001 | 2020-07-10 | Camuy | Puerto Rico | 72027 | 51 | |
317823 | 317823 | 2020-07-09 | Camuy | Puerto Rico | 72027 | 45 |
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);