ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Luquillo" 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 |
---|---|---|---|---|---|---|---|
919566 | 919566 | 2021-01-11 | Luquillo | Puerto Rico | 72089 | 556 | |
916321 | 916321 | 2021-01-10 | Luquillo | Puerto Rico | 72089 | 555 | |
913076 | 913076 | 2021-01-09 | Luquillo | Puerto Rico | 72089 | 553 | |
909831 | 909831 | 2021-01-08 | Luquillo | Puerto Rico | 72089 | 553 | |
906586 | 906586 | 2021-01-07 | Luquillo | Puerto Rico | 72089 | 535 | |
903340 | 903340 | 2021-01-06 | Luquillo | Puerto Rico | 72089 | 531 | |
900095 | 900095 | 2021-01-05 | Luquillo | Puerto Rico | 72089 | 530 | |
896850 | 896850 | 2021-01-04 | Luquillo | Puerto Rico | 72089 | 526 | |
893604 | 893604 | 2021-01-03 | Luquillo | Puerto Rico | 72089 | 517 | |
890358 | 890358 | 2021-01-02 | Luquillo | Puerto Rico | 72089 | 514 | |
887111 | 887111 | 2021-01-01 | Luquillo | Puerto Rico | 72089 | 509 | |
883866 | 883866 | 2020-12-31 | Luquillo | Puerto Rico | 72089 | 504 | |
880621 | 880621 | 2020-12-30 | Luquillo | Puerto Rico | 72089 | 493 | |
877376 | 877376 | 2020-12-29 | Luquillo | Puerto Rico | 72089 | 487 | |
874131 | 874131 | 2020-12-28 | Luquillo | Puerto Rico | 72089 | 484 | |
870886 | 870886 | 2020-12-27 | Luquillo | Puerto Rico | 72089 | 480 | |
867641 | 867641 | 2020-12-26 | Luquillo | Puerto Rico | 72089 | 478 | |
864396 | 864396 | 2020-12-25 | Luquillo | Puerto Rico | 72089 | 470 | |
861151 | 861151 | 2020-12-24 | Luquillo | Puerto Rico | 72089 | 470 | |
857906 | 857906 | 2020-12-23 | Luquillo | Puerto Rico | 72089 | 467 | |
854661 | 854661 | 2020-12-22 | Luquillo | Puerto Rico | 72089 | 462 | |
851416 | 851416 | 2020-12-21 | Luquillo | Puerto Rico | 72089 | 456 | |
848171 | 848171 | 2020-12-20 | Luquillo | Puerto Rico | 72089 | 452 | |
844926 | 844926 | 2020-12-19 | Luquillo | Puerto Rico | 72089 | 437 | |
841680 | 841680 | 2020-12-18 | Luquillo | Puerto Rico | 72089 | 434 | |
838435 | 838435 | 2020-12-17 | Luquillo | Puerto Rico | 72089 | 430 | |
835189 | 835189 | 2020-12-16 | Luquillo | Puerto Rico | 72089 | 426 | |
831943 | 831943 | 2020-12-15 | Luquillo | Puerto Rico | 72089 | 426 | |
828696 | 828696 | 2020-12-14 | Luquillo | Puerto Rico | 72089 | 426 | |
825450 | 825450 | 2020-12-13 | Luquillo | Puerto Rico | 72089 | 425 | |
822203 | 822203 | 2020-12-12 | Luquillo | Puerto Rico | 72089 | 425 | |
818957 | 818957 | 2020-12-11 | Luquillo | Puerto Rico | 72089 | 423 | |
815711 | 815711 | 2020-12-10 | Luquillo | Puerto Rico | 72089 | 421 | |
812465 | 812465 | 2020-12-09 | Luquillo | Puerto Rico | 72089 | 416 | |
809221 | 809221 | 2020-12-08 | Luquillo | Puerto Rico | 72089 | 416 | |
805976 | 805976 | 2020-12-07 | Luquillo | Puerto Rico | 72089 | 413 | |
802731 | 802731 | 2020-12-06 | Luquillo | Puerto Rico | 72089 | 411 | |
799486 | 799486 | 2020-12-05 | Luquillo | Puerto Rico | 72089 | 410 | |
796241 | 796241 | 2020-12-04 | Luquillo | Puerto Rico | 72089 | 408 | |
792996 | 792996 | 2020-12-03 | Luquillo | Puerto Rico | 72089 | 405 | |
789751 | 789751 | 2020-12-02 | Luquillo | Puerto Rico | 72089 | 398 | |
786506 | 786506 | 2020-12-01 | Luquillo | Puerto Rico | 72089 | 398 | |
783262 | 783262 | 2020-11-30 | Luquillo | Puerto Rico | 72089 | 393 | |
780017 | 780017 | 2020-11-29 | Luquillo | Puerto Rico | 72089 | 390 | |
776771 | 776771 | 2020-11-28 | Luquillo | Puerto Rico | 72089 | 389 | |
773526 | 773526 | 2020-11-27 | Luquillo | Puerto Rico | 72089 | 388 | |
770281 | 770281 | 2020-11-26 | Luquillo | Puerto Rico | 72089 | 387 | |
767035 | 767035 | 2020-11-25 | Luquillo | Puerto Rico | 72089 | 387 | |
763790 | 763790 | 2020-11-24 | Luquillo | Puerto Rico | 72089 | 386 | |
760545 | 760545 | 2020-11-23 | Luquillo | Puerto Rico | 72089 | 379 | |
757300 | 757300 | 2020-11-22 | Luquillo | Puerto Rico | 72089 | 378 | |
754053 | 754053 | 2020-11-21 | Luquillo | Puerto Rico | 72089 | 377 | |
750807 | 750807 | 2020-11-20 | Luquillo | Puerto Rico | 72089 | 371 | |
747561 | 747561 | 2020-11-19 | Luquillo | Puerto Rico | 72089 | 366 | |
744315 | 744315 | 2020-11-18 | Luquillo | Puerto Rico | 72089 | 365 | |
741068 | 741068 | 2020-11-17 | Luquillo | Puerto Rico | 72089 | 364 | |
737822 | 737822 | 2020-11-16 | Luquillo | Puerto Rico | 72089 | 363 | |
734578 | 734578 | 2020-11-15 | Luquillo | Puerto Rico | 72089 | 362 | |
731332 | 731332 | 2020-11-14 | Luquillo | Puerto Rico | 72089 | 360 | |
728088 | 728088 | 2020-11-13 | Luquillo | Puerto Rico | 72089 | 360 | |
724844 | 724844 | 2020-11-12 | Luquillo | Puerto Rico | 72089 | 358 | |
721601 | 721601 | 2020-11-11 | Luquillo | Puerto Rico | 72089 | 357 | |
718358 | 718358 | 2020-11-10 | Luquillo | Puerto Rico | 72089 | 356 | |
715115 | 715115 | 2020-11-09 | Luquillo | Puerto Rico | 72089 | 356 | |
711871 | 711871 | 2020-11-08 | Luquillo | Puerto Rico | 72089 | 356 | |
708627 | 708627 | 2020-11-07 | Luquillo | Puerto Rico | 72089 | 352 | |
705384 | 705384 | 2020-11-06 | Luquillo | Puerto Rico | 72089 | 352 | |
702141 | 702141 | 2020-11-05 | Luquillo | Puerto Rico | 72089 | 352 | |
698897 | 698897 | 2020-11-04 | Luquillo | Puerto Rico | 72089 | 346 | |
695654 | 695654 | 2020-11-03 | Luquillo | Puerto Rico | 72089 | 346 | |
692412 | 692412 | 2020-11-02 | Luquillo | Puerto Rico | 72089 | 340 | |
689168 | 689168 | 2020-11-01 | Luquillo | Puerto Rico | 72089 | 334 | |
685923 | 685923 | 2020-10-31 | Luquillo | Puerto Rico | 72089 | 332 | |
682680 | 682680 | 2020-10-30 | Luquillo | Puerto Rico | 72089 | 332 | |
679437 | 679437 | 2020-10-29 | Luquillo | Puerto Rico | 72089 | 330 | |
676194 | 676194 | 2020-10-28 | Luquillo | Puerto Rico | 72089 | 324 | |
672951 | 672951 | 2020-10-27 | Luquillo | Puerto Rico | 72089 | 324 | |
669709 | 669709 | 2020-10-26 | Luquillo | Puerto Rico | 72089 | 322 | |
666465 | 666465 | 2020-10-25 | Luquillo | Puerto Rico | 72089 | 319 | |
663220 | 663220 | 2020-10-24 | Luquillo | Puerto Rico | 72089 | 314 | |
659976 | 659976 | 2020-10-23 | Luquillo | Puerto Rico | 72089 | 313 | |
656732 | 656732 | 2020-10-22 | Luquillo | Puerto Rico | 72089 | 310 | |
653487 | 653487 | 2020-10-21 | Luquillo | Puerto Rico | 72089 | 309 | |
650242 | 650242 | 2020-10-20 | Luquillo | Puerto Rico | 72089 | 309 | |
646998 | 646998 | 2020-10-19 | Luquillo | Puerto Rico | 72089 | 305 | |
643752 | 643752 | 2020-10-18 | Luquillo | Puerto Rico | 72089 | 303 | |
640504 | 640504 | 2020-10-17 | Luquillo | Puerto Rico | 72089 | 295 | |
637258 | 637258 | 2020-10-16 | Luquillo | Puerto Rico | 72089 | 295 | |
634012 | 634012 | 2020-10-15 | Luquillo | Puerto Rico | 72089 | 293 | |
630767 | 630767 | 2020-10-14 | Luquillo | Puerto Rico | 72089 | 291 | |
627523 | 627523 | 2020-10-13 | Luquillo | Puerto Rico | 72089 | 288 | |
624281 | 624281 | 2020-10-12 | Luquillo | Puerto Rico | 72089 | 288 | |
621038 | 621038 | 2020-10-11 | Luquillo | Puerto Rico | 72089 | 282 | |
617795 | 617795 | 2020-10-10 | Luquillo | Puerto Rico | 72089 | 281 | |
614553 | 614553 | 2020-10-09 | Luquillo | Puerto Rico | 72089 | 279 | |
611312 | 611312 | 2020-10-08 | Luquillo | Puerto Rico | 72089 | 279 | |
608070 | 608070 | 2020-10-07 | Luquillo | Puerto Rico | 72089 | 278 | |
604827 | 604827 | 2020-10-06 | Luquillo | Puerto Rico | 72089 | 278 | |
601585 | 601585 | 2020-10-05 | Luquillo | Puerto Rico | 72089 | 278 | |
598342 | 598342 | 2020-10-04 | Luquillo | Puerto Rico | 72089 | 276 |
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);