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 |
---|---|---|---|---|---|---|---|
1053608 | 1053608 | 2021-02-22 | Maricopa | Arizona | 4013 | 506046 | 8833 |
1050361 | 1050361 | 2021-02-21 | Maricopa | Arizona | 4013 | 504992 | 8835 |
1047114 | 1047114 | 2021-02-20 | Maricopa | Arizona | 4013 | 504383 | 8816 |
1043869 | 1043869 | 2021-02-19 | Maricopa | Arizona | 4013 | 503012 | 8783 |
1040624 | 1040624 | 2021-02-18 | Maricopa | Arizona | 4013 | 501792 | 8694 |
1037379 | 1037379 | 2021-02-17 | Maricopa | Arizona | 4013 | 500907 | 8580 |
1034134 | 1034134 | 2021-02-16 | Maricopa | Arizona | 4013 | 499865 | 8505 |
1030888 | 1030888 | 2021-02-15 | Maricopa | Arizona | 4013 | 499105 | 8505 |
1027641 | 1027641 | 2021-02-14 | Maricopa | Arizona | 4013 | 498297 | 8505 |
1024396 | 1024396 | 2021-02-13 | Maricopa | Arizona | 4013 | 497541 | 8487 |
1021151 | 1021151 | 2021-02-12 | Maricopa | Arizona | 4013 | 496426 | 8423 |
1017906 | 1017906 | 2021-02-11 | Maricopa | Arizona | 4013 | 495621 | 8334 |
1014661 | 1014661 | 2021-02-10 | Maricopa | Arizona | 4013 | 493720 | 8254 |
1011416 | 1011416 | 2021-02-09 | Maricopa | Arizona | 4013 | 492492 | 8125 |
1008170 | 1008170 | 2021-02-08 | Maricopa | Arizona | 4013 | 488687 | 7979 |
1004924 | 1004924 | 2021-02-07 | Maricopa | Arizona | 4013 | 487042 | 7971 |
1001678 | 1001678 | 2021-02-06 | Maricopa | Arizona | 4013 | 486922 | 7960 |
998432 | 998432 | 2021-02-05 | Maricopa | Arizona | 4013 | 484880 | 7902 |
995186 | 995186 | 2021-02-04 | Maricopa | Arizona | 4013 | 482845 | 7807 |
991940 | 991940 | 2021-02-03 | Maricopa | Arizona | 4013 | 479978 | 7689 |
988694 | 988694 | 2021-02-02 | Maricopa | Arizona | 4013 | 478097 | 7612 |
985447 | 985447 | 2021-02-01 | Maricopa | Arizona | 4013 | 475261 | 7462 |
982200 | 982200 | 2021-01-31 | Maricopa | Arizona | 4013 | 472760 | 7462 |
978954 | 978954 | 2021-01-30 | Maricopa | Arizona | 4013 | 471686 | 7455 |
975709 | 975709 | 2021-01-29 | Maricopa | Arizona | 4013 | 468090 | 7400 |
972464 | 972464 | 2021-01-28 | Maricopa | Arizona | 4013 | 465009 | 7313 |
969219 | 969219 | 2021-01-27 | Maricopa | Arizona | 4013 | 461280 | 7199 |
965975 | 965975 | 2021-01-26 | Maricopa | Arizona | 4013 | 457555 | 7094 |
962730 | 962730 | 2021-01-25 | Maricopa | Arizona | 4013 | 452925 | 6951 |
959485 | 959485 | 2021-01-24 | Maricopa | Arizona | 4013 | 449162 | 6950 |
956239 | 956239 | 2021-01-23 | Maricopa | Arizona | 4013 | 446652 | 6891 |
952994 | 952994 | 2021-01-22 | Maricopa | Arizona | 4013 | 441779 | 6819 |
949749 | 949749 | 2021-01-21 | Maricopa | Arizona | 4013 | 437492 | 6724 |
946503 | 946503 | 2021-01-20 | Maricopa | Arizona | 4013 | 431491 | 6584 |
943256 | 943256 | 2021-01-19 | Maricopa | Arizona | 4013 | 425844 | 6443 |
940011 | 940011 | 2021-01-18 | Maricopa | Arizona | 4013 | 421551 | 6443 |
936766 | 936766 | 2021-01-17 | Maricopa | Arizona | 4013 | 417839 | 6444 |
933521 | 933521 | 2021-01-16 | Maricopa | Arizona | 4013 | 416480 | 6437 |
930276 | 930276 | 2021-01-15 | Maricopa | Arizona | 4013 | 411703 | 6340 |
927031 | 927031 | 2021-01-14 | Maricopa | Arizona | 4013 | 406226 | 6233 |
923785 | 923785 | 2021-01-13 | Maricopa | Arizona | 4013 | 398820 | 6131 |
920540 | 920540 | 2021-01-12 | Maricopa | Arizona | 4013 | 396147 | 6067 |
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 |
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);