ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
839 rows where fips = 4013 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
768010 | 768010 | 2020-11-26 | Maricopa | Arizona | 4013 | 198822 | 3955 |
764765 | 764765 | 2020-11-25 | Maricopa | Arizona | 4013 | 197580 | 3932 |
761520 | 761520 | 2020-11-24 | Maricopa | Arizona | 4013 | 195377 | 3922 |
758275 | 758275 | 2020-11-23 | Maricopa | Arizona | 4013 | 192255 | 3896 |
755028 | 755028 | 2020-11-22 | Maricopa | Arizona | 4013 | 190067 | 3896 |
751782 | 751782 | 2020-11-21 | Maricopa | Arizona | 4013 | 189291 | 3892 |
748536 | 748536 | 2020-11-20 | Maricopa | Arizona | 4013 | 186564 | 3878 |
745290 | 745290 | 2020-11-19 | Maricopa | Arizona | 4013 | 184533 | 3850 |
742043 | 742043 | 2020-11-18 | Maricopa | Arizona | 4013 | 181920 | 3837 |
738796 | 738796 | 2020-11-17 | Maricopa | Arizona | 4013 | 179970 | 3817 |
735552 | 735552 | 2020-11-16 | Maricopa | Arizona | 4013 | 177070 | 3798 |
732306 | 732306 | 2020-11-15 | Maricopa | Arizona | 4013 | 176283 | 3798 |
729061 | 729061 | 2020-11-14 | Maricopa | Arizona | 4013 | 175298 | 3797 |
725818 | 725818 | 2020-11-13 | Maricopa | Arizona | 4013 | 173772 | 3774 |
722575 | 722575 | 2020-11-12 | Maricopa | Arizona | 4013 | 170842 | 3759 |
719332 | 719332 | 2020-11-11 | Maricopa | Arizona | 4013 | 170207 | 3747 |
716089 | 716089 | 2020-11-10 | Maricopa | Arizona | 4013 | 169309 | 3734 |
712845 | 712845 | 2020-11-09 | Maricopa | Arizona | 4013 | 167907 | 3709 |
709601 | 709601 | 2020-11-08 | Maricopa | Arizona | 4013 | 166880 | 3709 |
706357 | 706357 | 2020-11-07 | Maricopa | Arizona | 4013 | 165702 | 3699 |
703114 | 703114 | 2020-11-06 | Maricopa | Arizona | 4013 | 164355 | 3684 |
699871 | 699871 | 2020-11-05 | Maricopa | Arizona | 4013 | 162958 | 3672 |
696627 | 696627 | 2020-11-04 | Maricopa | Arizona | 4013 | 161725 | 3658 |
693385 | 693385 | 2020-11-03 | Maricopa | Arizona | 4013 | 161154 | 3634 |
690142 | 690142 | 2020-11-02 | Maricopa | Arizona | 4013 | 160264 | 3609 |
686897 | 686897 | 2020-11-01 | Maricopa | Arizona | 4013 | 159781 | 3608 |
683653 | 683653 | 2020-10-31 | Maricopa | Arizona | 4013 | 158765 | 3606 |
680410 | 680410 | 2020-10-30 | Maricopa | Arizona | 4013 | 157728 | 3577 |
677167 | 677167 | 2020-10-29 | Maricopa | Arizona | 4013 | 156736 | 3566 |
673924 | 673924 | 2020-10-28 | Maricopa | Arizona | 4013 | 155985 | 3560 |
670682 | 670682 | 2020-10-27 | Maricopa | Arizona | 4013 | 155458 | 3557 |
667439 | 667439 | 2020-10-26 | Maricopa | Arizona | 4013 | 154902 | 3541 |
664194 | 664194 | 2020-10-25 | Maricopa | Arizona | 4013 | 154214 | 3540 |
660950 | 660950 | 2020-10-24 | Maricopa | Arizona | 4013 | 153282 | 3539 |
657706 | 657706 | 2020-10-23 | Maricopa | Arizona | 4013 | 152695 | 3536 |
654461 | 654461 | 2020-10-22 | Maricopa | Arizona | 4013 | 152101 | 3536 |
651216 | 651216 | 2020-10-21 | Maricopa | Arizona | 4013 | 151527 | 3532 |
647972 | 647972 | 2020-10-20 | Maricopa | Arizona | 4013 | 150881 | 3519 |
644727 | 644727 | 2020-10-19 | Maricopa | Arizona | 4013 | 150280 | 3512 |
641479 | 641479 | 2020-10-18 | Maricopa | Arizona | 4013 | 149720 | 3510 |
638232 | 638232 | 2020-10-17 | Maricopa | Arizona | 4013 | 149202 | 3512 |
634987 | 634987 | 2020-10-16 | Maricopa | Arizona | 4013 | 148612 | 3500 |
631741 | 631741 | 2020-10-15 | Maricopa | Arizona | 4013 | 148152 | 3489 |
628497 | 628497 | 2020-10-14 | Maricopa | Arizona | 4013 | 147551 | 3475 |
625254 | 625254 | 2020-10-13 | Maricopa | Arizona | 4013 | 147010 | 3471 |
622011 | 622011 | 2020-10-12 | Maricopa | Arizona | 4013 | 146574 | 3464 |
618768 | 618768 | 2020-10-11 | Maricopa | Arizona | 4013 | 146278 | 3464 |
615526 | 615526 | 2020-10-10 | Maricopa | Arizona | 4013 | 145847 | 3466 |
612285 | 612285 | 2020-10-09 | Maricopa | Arizona | 4013 | 145298 | 3458 |
609043 | 609043 | 2020-10-08 | Maricopa | Arizona | 4013 | 144867 | 3454 |
605800 | 605800 | 2020-10-07 | Maricopa | Arizona | 4013 | 144342 | 3450 |
602558 | 602558 | 2020-10-06 | Maricopa | Arizona | 4013 | 143917 | 3431 |
599315 | 599315 | 2020-10-05 | Maricopa | Arizona | 4013 | 143411 | 3427 |
596072 | 596072 | 2020-10-04 | Maricopa | Arizona | 4013 | 143183 | 3426 |
592830 | 592830 | 2020-10-03 | Maricopa | Arizona | 4013 | 142968 | 3424 |
589590 | 589590 | 2020-10-02 | Maricopa | Arizona | 4013 | 142566 | 3416 |
586349 | 586349 | 2020-10-01 | Maricopa | Arizona | 4013 | 142287 | 3405 |
583109 | 583109 | 2020-09-30 | Maricopa | Arizona | 4013 | 141856 | 3395 |
579870 | 579870 | 2020-09-29 | Maricopa | Arizona | 4013 | 141738 | 3372 |
576629 | 576629 | 2020-09-28 | Maricopa | Arizona | 4013 | 141377 | 3364 |
573385 | 573385 | 2020-09-27 | Maricopa | Arizona | 4013 | 141211 | 3363 |
570143 | 570143 | 2020-09-26 | Maricopa | Arizona | 4013 | 140963 | 3363 |
566902 | 566902 | 2020-09-25 | Maricopa | Arizona | 4013 | 140753 | 3343 |
563661 | 563661 | 2020-09-24 | Maricopa | Arizona | 4013 | 140584 | 3329 |
560422 | 560422 | 2020-09-23 | Maricopa | Arizona | 4013 | 140409 | 3304 |
557186 | 557186 | 2020-09-22 | Maricopa | Arizona | 4013 | 140314 | 3275 |
553949 | 553949 | 2020-09-21 | Maricopa | Arizona | 4013 | 140006 | 3262 |
550710 | 550710 | 2020-09-20 | Maricopa | Arizona | 4013 | 139856 | 3261 |
547471 | 547471 | 2020-09-19 | Maricopa | Arizona | 4013 | 139586 | 3260 |
544234 | 544234 | 2020-09-18 | Maricopa | Arizona | 4013 | 139963 | 3245 |
540998 | 540998 | 2020-09-17 | Maricopa | Arizona | 4013 | 139051 | 3210 |
537761 | 537761 | 2020-09-16 | Maricopa | Arizona | 4013 | 138151 | 3199 |
534525 | 534525 | 2020-09-15 | Maricopa | Arizona | 4013 | 137870 | 3172 |
531290 | 531290 | 2020-09-14 | Maricopa | Arizona | 4013 | 137589 | 3154 |
528053 | 528053 | 2020-09-13 | Maricopa | Arizona | 4013 | 137507 | 3154 |
524817 | 524817 | 2020-09-12 | Maricopa | Arizona | 4013 | 137292 | 3158 |
521581 | 521581 | 2020-09-11 | Maricopa | Arizona | 4013 | 136887 | 3140 |
518344 | 518344 | 2020-09-10 | Maricopa | Arizona | 4013 | 136571 | 3133 |
515109 | 515109 | 2020-09-09 | Maricopa | Arizona | 4013 | 136324 | 3116 |
511876 | 511876 | 2020-09-08 | Maricopa | Arizona | 4013 | 136040 | 3093 |
508643 | 508643 | 2020-09-07 | Maricopa | Arizona | 4013 | 136004 | 3091 |
505411 | 505411 | 2020-09-06 | Maricopa | Arizona | 4013 | 135964 | 3093 |
502177 | 502177 | 2020-09-05 | Maricopa | Arizona | 4013 | 135856 | 3088 |
498943 | 498943 | 2020-09-04 | Maricopa | Arizona | 4013 | 135495 | 3064 |
495710 | 495710 | 2020-09-03 | Maricopa | Arizona | 4013 | 135109 | 3030 |
492476 | 492476 | 2020-09-02 | Maricopa | Arizona | 4013 | 134346 | 2995 |
489243 | 489243 | 2020-09-01 | Maricopa | Arizona | 4013 | 134004 | 2976 |
486010 | 486010 | 2020-08-31 | Maricopa | Arizona | 4013 | 133728 | 2961 |
482775 | 482775 | 2020-08-30 | Maricopa | Arizona | 4013 | 133641 | 2962 |
479541 | 479541 | 2020-08-29 | Maricopa | Arizona | 4013 | 133389 | 2950 |
476308 | 476308 | 2020-08-28 | Maricopa | Arizona | 4013 | 132986 | 2924 |
473075 | 473075 | 2020-08-27 | Maricopa | Arizona | 4013 | 132704 | 2896 |
469843 | 469843 | 2020-08-26 | Maricopa | Arizona | 4013 | 132434 | 2869 |
466614 | 466614 | 2020-08-25 | Maricopa | Arizona | 4013 | 132290 | 2804 |
463385 | 463385 | 2020-08-24 | Maricopa | Arizona | 4013 | 131962 | 2790 |
460156 | 460156 | 2020-08-23 | Maricopa | Arizona | 4013 | 131787 | 2790 |
456929 | 456929 | 2020-08-22 | Maricopa | Arizona | 4013 | 131685 | 2776 |
453701 | 453701 | 2020-08-21 | Maricopa | Arizona | 4013 | 131166 | 2745 |
450473 | 450473 | 2020-08-20 | Maricopa | Arizona | 4013 | 130800 | 2739 |
447245 | 447245 | 2020-08-19 | Maricopa | Arizona | 4013 | 130384 | 2702 |
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);