ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Cayey" and state = "Puerto Rico" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
430115 | 430115 | 2020-08-13 | Cayey | Puerto Rico | 72035 | 206 | |
433341 | 433341 | 2020-08-14 | Cayey | Puerto Rico | 72035 | 215 | |
436568 | 436568 | 2020-08-15 | Cayey | Puerto Rico | 72035 | 222 | |
439793 | 439793 | 2020-08-16 | Cayey | Puerto Rico | 72035 | 223 | |
443020 | 443020 | 2020-08-17 | Cayey | Puerto Rico | 72035 | 227 | |
446246 | 446246 | 2020-08-18 | Cayey | Puerto Rico | 72035 | 229 | |
449474 | 449474 | 2020-08-19 | Cayey | Puerto Rico | 72035 | 229 | |
452702 | 452702 | 2020-08-20 | Cayey | Puerto Rico | 72035 | 232 | |
455930 | 455930 | 2020-08-21 | Cayey | Puerto Rico | 72035 | 237 | |
459158 | 459158 | 2020-08-22 | Cayey | Puerto Rico | 72035 | 242 | |
462386 | 462386 | 2020-08-23 | Cayey | Puerto Rico | 72035 | 243 | |
465615 | 465615 | 2020-08-24 | Cayey | Puerto Rico | 72035 | 245 | |
468843 | 468843 | 2020-08-25 | Cayey | Puerto Rico | 72035 | 246 | |
472075 | 472075 | 2020-08-26 | Cayey | Puerto Rico | 72035 | 246 | |
475309 | 475309 | 2020-08-27 | Cayey | Puerto Rico | 72035 | 251 | |
478542 | 478542 | 2020-08-28 | Cayey | Puerto Rico | 72035 | 258 | |
481776 | 481776 | 2020-08-29 | Cayey | Puerto Rico | 72035 | 261 | |
485011 | 485011 | 2020-08-30 | Cayey | Puerto Rico | 72035 | 265 | |
488244 | 488244 | 2020-08-31 | Cayey | Puerto Rico | 72035 | 269 | |
491477 | 491477 | 2020-09-01 | Cayey | Puerto Rico | 72035 | 271 | |
501178 | 501178 | 2020-09-04 | Cayey | Puerto Rico | 72035 | 271 | |
494711 | 494711 | 2020-09-02 | Cayey | Puerto Rico | 72035 | 272 | |
497944 | 497944 | 2020-09-03 | Cayey | Puerto Rico | 72035 | 272 | |
504412 | 504412 | 2020-09-05 | Cayey | Puerto Rico | 72035 | 274 | |
507644 | 507644 | 2020-09-06 | Cayey | Puerto Rico | 72035 | 274 | |
510877 | 510877 | 2020-09-07 | Cayey | Puerto Rico | 72035 | 280 | |
514110 | 514110 | 2020-09-08 | Cayey | Puerto Rico | 72035 | 281 | |
517345 | 517345 | 2020-09-09 | Cayey | Puerto Rico | 72035 | 281 | |
520581 | 520581 | 2020-09-10 | Cayey | Puerto Rico | 72035 | 283 | |
523817 | 523817 | 2020-09-11 | Cayey | Puerto Rico | 72035 | 286 | |
527053 | 527053 | 2020-09-12 | Cayey | Puerto Rico | 72035 | 295 | |
530290 | 530290 | 2020-09-13 | Cayey | Puerto Rico | 72035 | 297 | |
533525 | 533525 | 2020-09-14 | Cayey | Puerto Rico | 72035 | 302 | |
536761 | 536761 | 2020-09-15 | Cayey | Puerto Rico | 72035 | 304 | |
539998 | 539998 | 2020-09-16 | Cayey | Puerto Rico | 72035 | 304 | |
543234 | 543234 | 2020-09-17 | Cayey | Puerto Rico | 72035 | 308 | |
546471 | 546471 | 2020-09-18 | Cayey | Puerto Rico | 72035 | 312 | |
549710 | 549710 | 2020-09-19 | Cayey | Puerto Rico | 72035 | 320 | |
552949 | 552949 | 2020-09-20 | Cayey | Puerto Rico | 72035 | 328 | |
556186 | 556186 | 2020-09-21 | Cayey | Puerto Rico | 72035 | 331 | |
559423 | 559423 | 2020-09-22 | Cayey | Puerto Rico | 72035 | 331 | |
562660 | 562660 | 2020-09-23 | Cayey | Puerto Rico | 72035 | 331 | |
565901 | 565901 | 2020-09-24 | Cayey | Puerto Rico | 72035 | 336 | |
569142 | 569142 | 2020-09-25 | Cayey | Puerto Rico | 72035 | 345 | |
572384 | 572384 | 2020-09-26 | Cayey | Puerto Rico | 72035 | 350 | |
575628 | 575628 | 2020-09-27 | Cayey | Puerto Rico | 72035 | 354 | |
578869 | 578869 | 2020-09-28 | Cayey | Puerto Rico | 72035 | 357 | |
582109 | 582109 | 2020-09-29 | Cayey | Puerto Rico | 72035 | 363 | |
585349 | 585349 | 2020-09-30 | Cayey | Puerto Rico | 72035 | 363 | |
588589 | 588589 | 2020-10-01 | Cayey | Puerto Rico | 72035 | 370 | |
591830 | 591830 | 2020-10-02 | Cayey | Puerto Rico | 72035 | 373 | |
595071 | 595071 | 2020-10-03 | Cayey | Puerto Rico | 72035 | 381 | |
598314 | 598314 | 2020-10-04 | Cayey | Puerto Rico | 72035 | 381 | |
601557 | 601557 | 2020-10-05 | Cayey | Puerto Rico | 72035 | 385 | |
604799 | 604799 | 2020-10-06 | Cayey | Puerto Rico | 72035 | 388 | |
608042 | 608042 | 2020-10-07 | Cayey | Puerto Rico | 72035 | 388 | |
611284 | 611284 | 2020-10-08 | Cayey | Puerto Rico | 72035 | 390 | |
614525 | 614525 | 2020-10-09 | Cayey | Puerto Rico | 72035 | 394 | |
617767 | 617767 | 2020-10-10 | Cayey | Puerto Rico | 72035 | 401 | |
621010 | 621010 | 2020-10-11 | Cayey | Puerto Rico | 72035 | 406 | |
624253 | 624253 | 2020-10-12 | Cayey | Puerto Rico | 72035 | 418 | |
627495 | 627495 | 2020-10-13 | Cayey | Puerto Rico | 72035 | 425 | |
630739 | 630739 | 2020-10-14 | Cayey | Puerto Rico | 72035 | 427 | |
633984 | 633984 | 2020-10-15 | Cayey | Puerto Rico | 72035 | 429 | |
637230 | 637230 | 2020-10-16 | Cayey | Puerto Rico | 72035 | 434 | |
640476 | 640476 | 2020-10-17 | Cayey | Puerto Rico | 72035 | 439 | |
643724 | 643724 | 2020-10-18 | Cayey | Puerto Rico | 72035 | 446 | |
646970 | 646970 | 2020-10-19 | Cayey | Puerto Rico | 72035 | 452 | |
650214 | 650214 | 2020-10-20 | Cayey | Puerto Rico | 72035 | 452 | |
653459 | 653459 | 2020-10-21 | Cayey | Puerto Rico | 72035 | 452 | |
656704 | 656704 | 2020-10-22 | Cayey | Puerto Rico | 72035 | 461 | |
663192 | 663192 | 2020-10-24 | Cayey | Puerto Rico | 72035 | 481 | |
659948 | 659948 | 2020-10-23 | Cayey | Puerto Rico | 72035 | 484 | |
666437 | 666437 | 2020-10-25 | Cayey | Puerto Rico | 72035 | 488 | |
669681 | 669681 | 2020-10-26 | Cayey | Puerto Rico | 72035 | 491 | |
672923 | 672923 | 2020-10-27 | Cayey | Puerto Rico | 72035 | 496 | |
676166 | 676166 | 2020-10-28 | Cayey | Puerto Rico | 72035 | 497 | |
679409 | 679409 | 2020-10-29 | Cayey | Puerto Rico | 72035 | 510 | |
682652 | 682652 | 2020-10-30 | Cayey | Puerto Rico | 72035 | 524 | |
685895 | 685895 | 2020-10-31 | Cayey | Puerto Rico | 72035 | 533 | |
689140 | 689140 | 2020-11-01 | Cayey | Puerto Rico | 72035 | 541 | |
692384 | 692384 | 2020-11-02 | Cayey | Puerto Rico | 72035 | 550 | |
695626 | 695626 | 2020-11-03 | Cayey | Puerto Rico | 72035 | 556 | |
698869 | 698869 | 2020-11-04 | Cayey | Puerto Rico | 72035 | 556 | |
702113 | 702113 | 2020-11-05 | Cayey | Puerto Rico | 72035 | 562 | |
705356 | 705356 | 2020-11-06 | Cayey | Puerto Rico | 72035 | 563 | |
708599 | 708599 | 2020-11-07 | Cayey | Puerto Rico | 72035 | 563 | |
711843 | 711843 | 2020-11-08 | Cayey | Puerto Rico | 72035 | 572 | |
715087 | 715087 | 2020-11-09 | Cayey | Puerto Rico | 72035 | 575 | |
718330 | 718330 | 2020-11-10 | Cayey | Puerto Rico | 72035 | 577 | |
721573 | 721573 | 2020-11-11 | Cayey | Puerto Rico | 72035 | 577 | |
724816 | 724816 | 2020-11-12 | Cayey | Puerto Rico | 72035 | 593 | |
728060 | 728060 | 2020-11-13 | Cayey | Puerto Rico | 72035 | 597 | |
731304 | 731304 | 2020-11-14 | Cayey | Puerto Rico | 72035 | 606 | |
734550 | 734550 | 2020-11-15 | Cayey | Puerto Rico | 72035 | 612 | |
737794 | 737794 | 2020-11-16 | Cayey | Puerto Rico | 72035 | 616 | |
741040 | 741040 | 2020-11-17 | Cayey | Puerto Rico | 72035 | 625 | |
744287 | 744287 | 2020-11-18 | Cayey | Puerto Rico | 72035 | 625 | |
747533 | 747533 | 2020-11-19 | Cayey | Puerto Rico | 72035 | 633 | |
750779 | 750779 | 2020-11-20 | Cayey | Puerto Rico | 72035 | 640 |
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);