ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where fips = 4021 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
deaths 381 ✖
- 0 34
- 1544 11
- 905 10
- 37 9
- 924 8
- 217 7
- 910 7
- 1051 7
- 1549 7
- 1566 7
- 1582 7
- 1594 7
- 1619 7
- 1645 7
- 1646 7
- 1651 7
- 1665 7
- 212 6
- 862 6
- 876 6
- 936 6
- 9 5
- 39 5
- 41 5
- 888 5
- 903 5
- 926 5
- 5 4
- 13 4
- 19 4
- 156 4
- 186 4
- 207 4
- 228 4
- 239 4
- 346 4
- 709 4
- 858 4
- 868 4
- 901 4
- 904 4
- 908 4
- 919 4
- 921 4
- 951 4
- 1499 4
- 3 3
- 7 3
- 15 3
- 31 3
- 44 3
- 47 3
- 50 3
- 75 3
- 88 3
- 104 3
- 169 3
- 177 3
- 190 3
- 211 3
- 213 3
- 230 3
- 231 3
- 252 3
- 259 3
- 273 3
- 300 3
- 331 3
- 371 3
- 490 3
- 662 3
- 742 3
- 767 3
- 793 3
- 850 3
- 859 3
- 863 3
- 872 3
- 880 3
- 887 3
- 892 3
- 907 3
- 912 3
- 922 3
- 930 3
- 943 3
- 957 3
- 961 3
- 974 3
- 979 3
- 1003 3
- 1022 3
- 1038 3
- 1045 3
- 1087 3
- 1109 3
- 1146 3
- 1163 3
- 1259 3
- 1294 3
- 1320 3
- 1409 3
- 1466 3
- 1666 3
- 4 2
- 8 2
- 11 2
- 20 2
- 28 2
- 40 2
- 42 2
- 63 2
- 81 2
- 114 2
- 122 2
- 123 2
- 141 2
- 164 2
- 171 2
- 176 2
- 180 2
- 183 2
- 188 2
- 191 2
- 195 2
- 196 2
- 203 2
- 208 2
- 209 2
- 210 2
- 215 2
- 216 2
- 234 2
- 251 2
- 418 2
- 612 2
- 814 2
- 821 2
- 834 2
- 852 2
- 864 2
- 865 2
- 871 2
- 873 2
- 877 2
- 902 2
- 920 2
- 933 2
- 998 2
- 1015 2
- 1067 2
- 1071 2
- 1134 2
- 1141 2
- 1155 2
- 1176 2
- 1190 2
- 1204 2
- 1221 2
- 1339 2
- 1348 2
- 1361 2
- 1385 2
- 1399 2
- 1441 2
- 1523 2
- 6 1
- 32 1
- 43 1
- 49 1
- 51 1
- 55 1
- 58 1
- 59 1
- 61 1
- 67 1
- 71 1
- 74 1
- 78 1
- 82 1
- 83 1
- 84 1
- 90 1
- 93 1
- 96 1
- 109 1
- 113 1
- 124 1
- 132 1
- 136 1
- 140 1
- 142 1
- 145 1
- 147 1
- 157 1
- 166 1
- 178 1
- 187 1
- 193 1
- 194 1
- 200 1
- 202 1
- 204 1
- 205 1
- 206 1
- 214 1
- 224 1
- 225 1
- 226 1
- 232 1
- 236 1
- 246 1
- 247 1
- 250 1
- 257 1
- 258 1
- 263 1
- 264 1
- 268 1
- 269 1
- 276 1
- 282 1
- 288 1
- 292 1
- 304 1
- 307 1
- 317 1
- 324 1
- 338 1
- 339 1
- 345 1
- 353 1
- 357 1
- 367 1
- 372 1
- 385 1
- 389 1
- 407 1
- 414 1
- 417 1
- 447 1
- 461 1
- 476 1
- 478 1
- 487 1
- 509 1
- 522 1
- 533 1
- 545 1
- 546 1
- 547 1
- 571 1
- 579 1
- 590 1
- 609 1
- 613 1
- 627 1
- 636 1
- 648 1
- 659 1
- 676 1
- 690 1
- 696 1
- 701 1
- 714 1
- 731 1
- 741 1
- 751 1
- 754 1
- 763 1
- 764 1
- 776 1
- 777 1
- 785 1
- 788 1
- 792 1
- 797 1
- 804 1
- 807 1
- 812 1
- 818 1
- 829 1
- 833 1
- 840 1
- 841 1
- 844 1
- 849 1
- 851 1
- 857 1
- 866 1
- 869 1
- 874 1
- 881 1
- 884 1
- 885 1
- 891 1
- 896 1
- 906 1
- 918 1
- 923 1
- 928 1
- 931 1
- 934 1
- 939 1
- 942 1
- 949 1
- 950 1
- 955 1
- 971 1
- 982 1
- 992 1
- 1012 1
- 1017 1
- 1033 1
- 1063 1
- 1065 1
- 1070 1
- 1075 1
- 1076 1
- 1079 1
- 1083 1
- 1086 1
- 1099 1
- 1100 1
- 1102 1
- 1118 1
- 1121 1
- 1123 1
- 1128 1
- 1133 1
- 1140 1
- 1144 1
- 1150 1
- 1153 1
- 1171 1
- 1173 1
- 1188 1
- 1209 1
- 1214 1
- 1218 1
- 1240 1
- 1253 1
- 1256 1
- 1260 1
- 1273 1
- 1278 1
- 1282 1
- 1289 1
- 1301 1
- 1305 1
- 1306 1
- 1308 1
- 1332 1
- 1333 1
- 1344 1
- 1360 1
- 1367 1
- 1381 1
- 1398 1
- 1403 1
- 1408 1
- 1422 1
- 1425 1
- 1432 1
- 1440 1
- 1447 1
- 1448 1
- 1453 1
- 1457 1
- 1478 1
- 1480 1
- 1491 1
- 1494 1
- 1498 1
- 1516 1
- 1518 1
- 1522 1
- 1530 1
- 1531 1
- 1539 1
- 1542 1
state 1
- Arizona 799
fips 1
- 4021 · 799 ✖
county 1
- Pinal 799
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499682 | 2499682 | 2022-05-13 | Pinal | Arizona | 4021 | 132748 | 1666 |
2496424 | 2496424 | 2022-05-12 | Pinal | Arizona | 4021 | 132748 | 1666 |
2493166 | 2493166 | 2022-05-11 | Pinal | Arizona | 4021 | 132748 | 1666 |
2489908 | 2489908 | 2022-05-10 | Pinal | Arizona | 4021 | 132530 | 1665 |
2486651 | 2486651 | 2022-05-09 | Pinal | Arizona | 4021 | 132530 | 1665 |
2483393 | 2483393 | 2022-05-08 | Pinal | Arizona | 4021 | 132530 | 1665 |
2480135 | 2480135 | 2022-05-07 | Pinal | Arizona | 4021 | 132530 | 1665 |
2476877 | 2476877 | 2022-05-06 | Pinal | Arizona | 4021 | 132530 | 1665 |
2473619 | 2473619 | 2022-05-05 | Pinal | Arizona | 4021 | 132530 | 1665 |
2470362 | 2470362 | 2022-05-04 | Pinal | Arizona | 4021 | 132530 | 1665 |
2467106 | 2467106 | 2022-05-03 | Pinal | Arizona | 4021 | 132365 | 1651 |
2463851 | 2463851 | 2022-05-02 | Pinal | Arizona | 4021 | 132365 | 1651 |
2460595 | 2460595 | 2022-05-01 | Pinal | Arizona | 4021 | 132365 | 1651 |
2457339 | 2457339 | 2022-04-30 | Pinal | Arizona | 4021 | 132365 | 1651 |
2454083 | 2454083 | 2022-04-29 | Pinal | Arizona | 4021 | 132365 | 1651 |
2450827 | 2450827 | 2022-04-28 | Pinal | Arizona | 4021 | 132365 | 1651 |
2447571 | 2447571 | 2022-04-27 | Pinal | Arizona | 4021 | 132365 | 1651 |
2444315 | 2444315 | 2022-04-26 | Pinal | Arizona | 4021 | 132295 | 1645 |
2441059 | 2441059 | 2022-04-25 | Pinal | Arizona | 4021 | 132295 | 1645 |
2437803 | 2437803 | 2022-04-24 | Pinal | Arizona | 4021 | 132295 | 1645 |
2434547 | 2434547 | 2022-04-23 | Pinal | Arizona | 4021 | 132295 | 1645 |
2431291 | 2431291 | 2022-04-22 | Pinal | Arizona | 4021 | 132295 | 1645 |
2428035 | 2428035 | 2022-04-21 | Pinal | Arizona | 4021 | 132295 | 1645 |
2424779 | 2424779 | 2022-04-20 | Pinal | Arizona | 4021 | 132295 | 1645 |
2421523 | 2421523 | 2022-04-19 | Pinal | Arizona | 4021 | 132363 | 1646 |
2418267 | 2418267 | 2022-04-18 | Pinal | Arizona | 4021 | 132363 | 1646 |
2415011 | 2415011 | 2022-04-17 | Pinal | Arizona | 4021 | 132363 | 1646 |
2411755 | 2411755 | 2022-04-16 | Pinal | Arizona | 4021 | 132363 | 1646 |
2408499 | 2408499 | 2022-04-15 | Pinal | Arizona | 4021 | 132363 | 1646 |
2405243 | 2405243 | 2022-04-14 | Pinal | Arizona | 4021 | 132363 | 1646 |
2401988 | 2401988 | 2022-04-13 | Pinal | Arizona | 4021 | 132363 | 1646 |
2398733 | 2398733 | 2022-04-12 | Pinal | Arizona | 4021 | 131381 | 1619 |
2395478 | 2395478 | 2022-04-11 | Pinal | Arizona | 4021 | 131381 | 1619 |
2392222 | 2392222 | 2022-04-10 | Pinal | Arizona | 4021 | 131381 | 1619 |
2388966 | 2388966 | 2022-04-09 | Pinal | Arizona | 4021 | 131381 | 1619 |
2385711 | 2385711 | 2022-04-08 | Pinal | Arizona | 4021 | 131381 | 1619 |
2382456 | 2382456 | 2022-04-07 | Pinal | Arizona | 4021 | 131381 | 1619 |
2379201 | 2379201 | 2022-04-06 | Pinal | Arizona | 4021 | 131381 | 1619 |
2375947 | 2375947 | 2022-04-05 | Pinal | Arizona | 4021 | 130396 | 1594 |
2372695 | 2372695 | 2022-04-04 | Pinal | Arizona | 4021 | 130396 | 1594 |
2369442 | 2369442 | 2022-04-03 | Pinal | Arizona | 4021 | 130396 | 1594 |
2366189 | 2366189 | 2022-04-02 | Pinal | Arizona | 4021 | 130396 | 1594 |
2362936 | 2362936 | 2022-04-01 | Pinal | Arizona | 4021 | 130396 | 1594 |
2359682 | 2359682 | 2022-03-31 | Pinal | Arizona | 4021 | 130396 | 1594 |
2356428 | 2356428 | 2022-03-30 | Pinal | Arizona | 4021 | 130396 | 1594 |
2353175 | 2353175 | 2022-03-29 | Pinal | Arizona | 4021 | 129693 | 1582 |
2349923 | 2349923 | 2022-03-28 | Pinal | Arizona | 4021 | 129693 | 1582 |
2346670 | 2346670 | 2022-03-27 | Pinal | Arizona | 4021 | 129693 | 1582 |
2343417 | 2343417 | 2022-03-26 | Pinal | Arizona | 4021 | 129693 | 1582 |
2340164 | 2340164 | 2022-03-25 | Pinal | Arizona | 4021 | 129693 | 1582 |
2336911 | 2336911 | 2022-03-24 | Pinal | Arizona | 4021 | 129693 | 1582 |
2333657 | 2333657 | 2022-03-23 | Pinal | Arizona | 4021 | 129693 | 1582 |
2330403 | 2330403 | 2022-03-22 | Pinal | Arizona | 4021 | 129486 | 1566 |
2327151 | 2327151 | 2022-03-21 | Pinal | Arizona | 4021 | 129486 | 1566 |
2323898 | 2323898 | 2022-03-20 | Pinal | Arizona | 4021 | 129486 | 1566 |
2320644 | 2320644 | 2022-03-19 | Pinal | Arizona | 4021 | 129486 | 1566 |
2317390 | 2317390 | 2022-03-18 | Pinal | Arizona | 4021 | 129486 | 1566 |
2314137 | 2314137 | 2022-03-17 | Pinal | Arizona | 4021 | 129486 | 1566 |
2310884 | 2310884 | 2022-03-16 | Pinal | Arizona | 4021 | 129486 | 1566 |
2307631 | 2307631 | 2022-03-15 | Pinal | Arizona | 4021 | 129241 | 1549 |
2304380 | 2304380 | 2022-03-14 | Pinal | Arizona | 4021 | 129241 | 1549 |
2301128 | 2301128 | 2022-03-13 | Pinal | Arizona | 4021 | 129241 | 1549 |
2297876 | 2297876 | 2022-03-12 | Pinal | Arizona | 4021 | 129241 | 1549 |
2294624 | 2294624 | 2022-03-11 | Pinal | Arizona | 4021 | 129241 | 1549 |
2291372 | 2291372 | 2022-03-10 | Pinal | Arizona | 4021 | 129241 | 1549 |
2288120 | 2288120 | 2022-03-09 | Pinal | Arizona | 4021 | 129241 | 1549 |
2284868 | 2284868 | 2022-03-08 | Pinal | Arizona | 4021 | 128929 | 1544 |
2281616 | 2281616 | 2022-03-07 | Pinal | Arizona | 4021 | 128929 | 1544 |
2278363 | 2278363 | 2022-03-06 | Pinal | Arizona | 4021 | 128929 | 1544 |
2275110 | 2275110 | 2022-03-05 | Pinal | Arizona | 4021 | 128929 | 1544 |
2271857 | 2271857 | 2022-03-04 | Pinal | Arizona | 4021 | 128929 | 1544 |
2268605 | 2268605 | 2022-03-03 | Pinal | Arizona | 4021 | 128929 | 1544 |
2265352 | 2265352 | 2022-03-02 | Pinal | Arizona | 4021 | 128929 | 1544 |
2262102 | 2262102 | 2022-03-01 | Pinal | Arizona | 4021 | 128726 | 1544 |
2258851 | 2258851 | 2022-02-28 | Pinal | Arizona | 4021 | 128726 | 1544 |
2255600 | 2255600 | 2022-02-27 | Pinal | Arizona | 4021 | 128726 | 1544 |
2252349 | 2252349 | 2022-02-26 | Pinal | Arizona | 4021 | 128726 | 1544 |
2249098 | 2249098 | 2022-02-25 | Pinal | Arizona | 4021 | 128636 | 1542 |
2245847 | 2245847 | 2022-02-24 | Pinal | Arizona | 4021 | 128537 | 1539 |
2242596 | 2242596 | 2022-02-23 | Pinal | Arizona | 4021 | 128467 | 1531 |
2239345 | 2239345 | 2022-02-22 | Pinal | Arizona | 4021 | 128386 | 1530 |
2236094 | 2236094 | 2022-02-21 | Pinal | Arizona | 4021 | 128186 | 1523 |
2232843 | 2232843 | 2022-02-20 | Pinal | Arizona | 4021 | 128181 | 1523 |
2229592 | 2229592 | 2022-02-19 | Pinal | Arizona | 4021 | 128025 | 1522 |
2226341 | 2226341 | 2022-02-18 | Pinal | Arizona | 4021 | 127862 | 1518 |
2223090 | 2223090 | 2022-02-17 | Pinal | Arizona | 4021 | 127706 | 1516 |
2219839 | 2219839 | 2022-02-16 | Pinal | Arizona | 4021 | 127523 | 1498 |
2216588 | 2216588 | 2022-02-15 | Pinal | Arizona | 4021 | 127319 | 1499 |
2213337 | 2213337 | 2022-02-14 | Pinal | Arizona | 4021 | 127193 | 1499 |
2210085 | 2210085 | 2022-02-13 | Pinal | Arizona | 4021 | 126941 | 1499 |
2206832 | 2206832 | 2022-02-12 | Pinal | Arizona | 4021 | 126672 | 1499 |
2203579 | 2203579 | 2022-02-11 | Pinal | Arizona | 4021 | 126437 | 1494 |
2200325 | 2200325 | 2022-02-10 | Pinal | Arizona | 4021 | 126347 | 1491 |
2197071 | 2197071 | 2022-02-09 | Pinal | Arizona | 4021 | 125706 | 1480 |
2193816 | 2193816 | 2022-02-08 | Pinal | Arizona | 4021 | 125376 | 1478 |
2190563 | 2190563 | 2022-02-07 | Pinal | Arizona | 4021 | 125067 | 1466 |
2187310 | 2187310 | 2022-02-06 | Pinal | Arizona | 4021 | 124625 | 1466 |
2184057 | 2184057 | 2022-02-05 | Pinal | Arizona | 4021 | 124304 | 1466 |
2180805 | 2180805 | 2022-02-04 | Pinal | Arizona | 4021 | 123764 | 1457 |
2177554 | 2177554 | 2022-02-03 | Pinal | Arizona | 4021 | 123035 | 1453 |
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);