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 |
---|---|---|---|---|---|---|---|
917295 | 917295 | 2021-01-11 | Maricopa | Arizona | 4013 | 388518 | 5823 |
914050 | 914050 | 2021-01-10 | Maricopa | Arizona | 4013 | 382409 | 5818 |
910805 | 910805 | 2021-01-09 | Maricopa | Arizona | 4013 | 379212 | 5814 |
907560 | 907560 | 2021-01-08 | Maricopa | Arizona | 4013 | 373397 | 5727 |
904314 | 904314 | 2021-01-07 | Maricopa | Arizona | 4013 | 364066 | 5598 |
901069 | 901069 | 2021-01-06 | Maricopa | Arizona | 4013 | 358496 | 5439 |
897824 | 897824 | 2021-01-05 | Maricopa | Arizona | 4013 | 353848 | 5375 |
894578 | 894578 | 2021-01-04 | Maricopa | Arizona | 4013 | 346183 | 5241 |
891332 | 891332 | 2021-01-03 | Maricopa | Arizona | 4013 | 342994 | 5239 |
888085 | 888085 | 2021-01-02 | Maricopa | Arizona | 4013 | 331233 | 5239 |
884840 | 884840 | 2021-01-01 | Maricopa | Arizona | 4013 | 325404 | 5196 |
881595 | 881595 | 2020-12-31 | Maricopa | Arizona | 4013 | 322449 | 5125 |
878350 | 878350 | 2020-12-30 | Maricopa | Arizona | 4013 | 317268 | 5059 |
875105 | 875105 | 2020-12-29 | Maricopa | Arizona | 4013 | 314306 | 5027 |
871860 | 871860 | 2020-12-28 | Maricopa | Arizona | 4013 | 309737 | 4948 |
868615 | 868615 | 2020-12-27 | Maricopa | Arizona | 4013 | 302859 | 4907 |
865370 | 865370 | 2020-12-26 | Maricopa | Arizona | 4013 | 302859 | 4906 |
862125 | 862125 | 2020-12-25 | Maricopa | Arizona | 4013 | 299056 | 4892 |
858880 | 858880 | 2020-12-24 | Maricopa | Arizona | 4013 | 298299 | 4840 |
855635 | 855635 | 2020-12-23 | Maricopa | Arizona | 4013 | 293629 | 4781 |
852390 | 852390 | 2020-12-22 | Maricopa | Arizona | 4013 | 290550 | 4762 |
849145 | 849145 | 2020-12-21 | Maricopa | Arizona | 4013 | 284462 | 4685 |
845900 | 845900 | 2020-12-20 | Maricopa | Arizona | 4013 | 279885 | 4684 |
842654 | 842654 | 2020-12-19 | Maricopa | Arizona | 4013 | 279636 | 4680 |
839409 | 839409 | 2020-12-18 | Maricopa | Arizona | 4013 | 275212 | 4610 |
836164 | 836164 | 2020-12-17 | Maricopa | Arizona | 4013 | 272932 | 4562 |
832918 | 832918 | 2020-12-16 | Maricopa | Arizona | 4013 | 267986 | 4475 |
829671 | 829671 | 2020-12-15 | Maricopa | Arizona | 4013 | 265605 | 4387 |
826425 | 826425 | 2020-12-14 | Maricopa | Arizona | 4013 | 260661 | 4353 |
823178 | 823178 | 2020-12-13 | Maricopa | Arizona | 4013 | 253686 | 4353 |
819932 | 819932 | 2020-12-12 | Maricopa | Arizona | 4013 | 253345 | 4342 |
816686 | 816686 | 2020-12-11 | Maricopa | Arizona | 4013 | 248905 | 4299 |
813440 | 813440 | 2020-12-10 | Maricopa | Arizona | 4013 | 244231 | 4262 |
810196 | 810196 | 2020-12-09 | Maricopa | Arizona | 4013 | 240917 | 4213 |
806951 | 806951 | 2020-12-08 | Maricopa | Arizona | 4013 | 238187 | 4173 |
803706 | 803706 | 2020-12-07 | Maricopa | Arizona | 4013 | 228486 | 4153 |
800461 | 800461 | 2020-12-06 | Maricopa | Arizona | 4013 | 228312 | 4153 |
797216 | 797216 | 2020-12-05 | Maricopa | Arizona | 4013 | 228051 | 4146 |
793971 | 793971 | 2020-12-04 | Maricopa | Arizona | 4013 | 224924 | 4119 |
790726 | 790726 | 2020-12-03 | Maricopa | Arizona | 4013 | 220399 | 4093 |
787481 | 787481 | 2020-12-02 | Maricopa | Arizona | 4013 | 217111 | 4052 |
784237 | 784237 | 2020-12-01 | Maricopa | Arizona | 4013 | 213988 | 4010 |
780992 | 780992 | 2020-11-30 | Maricopa | Arizona | 4013 | 205658 | 3982 |
777746 | 777746 | 2020-11-29 | Maricopa | Arizona | 4013 | 205332 | 3977 |
774501 | 774501 | 2020-11-28 | Maricopa | Arizona | 4013 | 203663 | 3974 |
771256 | 771256 | 2020-11-27 | Maricopa | Arizona | 4013 | 201340 | 3966 |
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 |
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);