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 rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
430111 | 430111 | 2020-08-13 | Camuy | Puerto Rico | 72027 | 145 | |
433337 | 433337 | 2020-08-14 | Camuy | Puerto Rico | 72027 | 151 | |
436564 | 436564 | 2020-08-15 | Camuy | Puerto Rico | 72027 | 157 | |
439789 | 439789 | 2020-08-16 | Camuy | Puerto Rico | 72027 | 158 | |
443016 | 443016 | 2020-08-17 | Camuy | Puerto Rico | 72027 | 164 | |
446242 | 446242 | 2020-08-18 | Camuy | Puerto Rico | 72027 | 169 | |
449470 | 449470 | 2020-08-19 | Camuy | Puerto Rico | 72027 | 169 | |
452698 | 452698 | 2020-08-20 | Camuy | Puerto Rico | 72027 | 172 | |
455926 | 455926 | 2020-08-21 | Camuy | Puerto Rico | 72027 | 176 | |
459154 | 459154 | 2020-08-22 | Camuy | Puerto Rico | 72027 | 185 | |
462382 | 462382 | 2020-08-23 | Camuy | Puerto Rico | 72027 | 186 | |
465611 | 465611 | 2020-08-24 | Camuy | Puerto Rico | 72027 | 186 | |
468839 | 468839 | 2020-08-25 | Camuy | Puerto Rico | 72027 | 186 | |
472071 | 472071 | 2020-08-26 | Camuy | Puerto Rico | 72027 | 187 | |
475305 | 475305 | 2020-08-27 | Camuy | Puerto Rico | 72027 | 188 | |
478538 | 478538 | 2020-08-28 | Camuy | Puerto Rico | 72027 | 190 | |
481772 | 481772 | 2020-08-29 | Camuy | Puerto Rico | 72027 | 191 | |
485007 | 485007 | 2020-08-30 | Camuy | Puerto Rico | 72027 | 191 | |
488240 | 488240 | 2020-08-31 | Camuy | Puerto Rico | 72027 | 191 | |
491473 | 491473 | 2020-09-01 | Camuy | Puerto Rico | 72027 | 193 | |
494707 | 494707 | 2020-09-02 | Camuy | Puerto Rico | 72027 | 196 | |
497940 | 497940 | 2020-09-03 | Camuy | Puerto Rico | 72027 | 196 | |
501174 | 501174 | 2020-09-04 | Camuy | Puerto Rico | 72027 | 196 | |
504408 | 504408 | 2020-09-05 | Camuy | Puerto Rico | 72027 | 197 | |
507640 | 507640 | 2020-09-06 | Camuy | Puerto Rico | 72027 | 197 | |
510873 | 510873 | 2020-09-07 | Camuy | Puerto Rico | 72027 | 201 | |
514106 | 514106 | 2020-09-08 | Camuy | Puerto Rico | 72027 | 200 | |
517341 | 517341 | 2020-09-09 | Camuy | Puerto Rico | 72027 | 200 | |
520577 | 520577 | 2020-09-10 | Camuy | Puerto Rico | 72027 | 206 | |
523813 | 523813 | 2020-09-11 | Camuy | Puerto Rico | 72027 | 207 | |
527049 | 527049 | 2020-09-12 | Camuy | Puerto Rico | 72027 | 210 | |
530286 | 530286 | 2020-09-13 | Camuy | Puerto Rico | 72027 | 210 | |
533521 | 533521 | 2020-09-14 | Camuy | Puerto Rico | 72027 | 211 | |
536757 | 536757 | 2020-09-15 | Camuy | Puerto Rico | 72027 | 212 | |
539994 | 539994 | 2020-09-16 | Camuy | Puerto Rico | 72027 | 214 | |
543230 | 543230 | 2020-09-17 | Camuy | Puerto Rico | 72027 | 221 | |
546467 | 546467 | 2020-09-18 | Camuy | Puerto Rico | 72027 | 227 | |
549706 | 549706 | 2020-09-19 | Camuy | Puerto Rico | 72027 | 233 | |
552945 | 552945 | 2020-09-20 | Camuy | Puerto Rico | 72027 | 241 | |
556182 | 556182 | 2020-09-21 | Camuy | Puerto Rico | 72027 | 248 | |
559419 | 559419 | 2020-09-22 | Camuy | Puerto Rico | 72027 | 249 | |
562656 | 562656 | 2020-09-23 | Camuy | Puerto Rico | 72027 | 249 | |
565897 | 565897 | 2020-09-24 | Camuy | Puerto Rico | 72027 | 262 | |
569138 | 569138 | 2020-09-25 | Camuy | Puerto Rico | 72027 | 269 | |
572380 | 572380 | 2020-09-26 | Camuy | Puerto Rico | 72027 | 278 | |
575624 | 575624 | 2020-09-27 | Camuy | Puerto Rico | 72027 | 283 | |
578865 | 578865 | 2020-09-28 | Camuy | Puerto Rico | 72027 | 290 | |
582105 | 582105 | 2020-09-29 | Camuy | Puerto Rico | 72027 | 295 | |
585345 | 585345 | 2020-09-30 | Camuy | Puerto Rico | 72027 | 297 | |
588585 | 588585 | 2020-10-01 | Camuy | Puerto Rico | 72027 | 303 | |
591826 | 591826 | 2020-10-02 | Camuy | Puerto Rico | 72027 | 307 | |
595067 | 595067 | 2020-10-03 | Camuy | Puerto Rico | 72027 | 308 | |
598310 | 598310 | 2020-10-04 | Camuy | Puerto Rico | 72027 | 310 | |
601553 | 601553 | 2020-10-05 | Camuy | Puerto Rico | 72027 | 315 | |
604795 | 604795 | 2020-10-06 | Camuy | Puerto Rico | 72027 | 317 | |
608038 | 608038 | 2020-10-07 | Camuy | Puerto Rico | 72027 | 317 | |
611280 | 611280 | 2020-10-08 | Camuy | Puerto Rico | 72027 | 320 | |
614521 | 614521 | 2020-10-09 | Camuy | Puerto Rico | 72027 | 326 | |
617763 | 617763 | 2020-10-10 | Camuy | Puerto Rico | 72027 | 326 | |
621006 | 621006 | 2020-10-11 | Camuy | Puerto Rico | 72027 | 326 | |
624249 | 624249 | 2020-10-12 | Camuy | Puerto Rico | 72027 | 326 | |
627491 | 627491 | 2020-10-13 | Camuy | Puerto Rico | 72027 | 326 | |
630735 | 630735 | 2020-10-14 | Camuy | Puerto Rico | 72027 | 332 | |
633980 | 633980 | 2020-10-15 | Camuy | Puerto Rico | 72027 | 335 | |
637226 | 637226 | 2020-10-16 | Camuy | Puerto Rico | 72027 | 335 | |
640472 | 640472 | 2020-10-17 | Camuy | Puerto Rico | 72027 | 336 | |
643720 | 643720 | 2020-10-18 | Camuy | Puerto Rico | 72027 | 336 | |
646966 | 646966 | 2020-10-19 | Camuy | Puerto Rico | 72027 | 342 | |
650210 | 650210 | 2020-10-20 | Camuy | Puerto Rico | 72027 | 344 | |
653455 | 653455 | 2020-10-21 | Camuy | Puerto Rico | 72027 | 344 | |
656700 | 656700 | 2020-10-22 | Camuy | Puerto Rico | 72027 | 346 | |
659944 | 659944 | 2020-10-23 | Camuy | Puerto Rico | 72027 | 359 | |
663188 | 663188 | 2020-10-24 | Camuy | Puerto Rico | 72027 | 363 | |
666433 | 666433 | 2020-10-25 | Camuy | Puerto Rico | 72027 | 371 | |
669677 | 669677 | 2020-10-26 | Camuy | Puerto Rico | 72027 | 374 | |
672919 | 672919 | 2020-10-27 | Camuy | Puerto Rico | 72027 | 375 | |
676162 | 676162 | 2020-10-28 | Camuy | Puerto Rico | 72027 | 375 | |
679405 | 679405 | 2020-10-29 | Camuy | Puerto Rico | 72027 | 380 | |
682648 | 682648 | 2020-10-30 | Camuy | Puerto Rico | 72027 | 388 | |
685891 | 685891 | 2020-10-31 | Camuy | Puerto Rico | 72027 | 392 | |
689136 | 689136 | 2020-11-01 | Camuy | Puerto Rico | 72027 | 393 | |
692380 | 692380 | 2020-11-02 | Camuy | Puerto Rico | 72027 | 421 | |
695622 | 695622 | 2020-11-03 | Camuy | Puerto Rico | 72027 | 426 | |
698865 | 698865 | 2020-11-04 | Camuy | Puerto Rico | 72027 | 426 | |
702109 | 702109 | 2020-11-05 | Camuy | Puerto Rico | 72027 | 428 | |
705352 | 705352 | 2020-11-06 | Camuy | Puerto Rico | 72027 | 451 | |
708595 | 708595 | 2020-11-07 | Camuy | Puerto Rico | 72027 | 451 | |
711839 | 711839 | 2020-11-08 | Camuy | Puerto Rico | 72027 | 463 | |
715083 | 715083 | 2020-11-09 | Camuy | Puerto Rico | 72027 | 464 | |
718326 | 718326 | 2020-11-10 | Camuy | Puerto Rico | 72027 | 464 | |
721569 | 721569 | 2020-11-11 | Camuy | Puerto Rico | 72027 | 470 | |
724812 | 724812 | 2020-11-12 | Camuy | Puerto Rico | 72027 | 483 | |
728056 | 728056 | 2020-11-13 | Camuy | Puerto Rico | 72027 | 493 | |
731300 | 731300 | 2020-11-14 | Camuy | Puerto Rico | 72027 | 497 | |
734546 | 734546 | 2020-11-15 | Camuy | Puerto Rico | 72027 | 505 | |
737790 | 737790 | 2020-11-16 | Camuy | Puerto Rico | 72027 | 508 | |
741036 | 741036 | 2020-11-17 | Camuy | Puerto Rico | 72027 | 524 | |
744283 | 744283 | 2020-11-18 | Camuy | Puerto Rico | 72027 | 530 | |
747529 | 747529 | 2020-11-19 | Camuy | Puerto Rico | 72027 | 542 | |
750775 | 750775 | 2020-11-20 | Camuy | Puerto Rico | 72027 | 553 |
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);