ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 4027 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 332 ✖
- 1 26
- 0 24
- 1167 21
- 848 13
- 849 12
- 1126 12
- 853 11
- 852 10
- 354 8
- 824 8
- 834 8
- 857 8
- 909 8
- 347 7
- 365 7
- 845 7
- 897 7
- 903 7
- 1135 7
- 1147 7
- 1155 7
- 1162 7
- 1172 7
- 1180 7
- 4 6
- 345 6
- 348 6
- 830 6
- 833 6
- 838 6
- 839 6
- 3 5
- 305 5
- 344 5
- 353 5
- 809 5
- 843 5
- 923 5
- 1088 5
- 337 4
- 363 4
- 498 4
- 697 4
- 799 4
- 827 4
- 847 4
- 855 4
- 870 4
- 896 4
- 905 4
- 927 4
- 954 4
- 1109 4
- 15 3
- 297 3
- 321 3
- 330 3
- 331 3
- 358 3
- 375 3
- 392 3
- 409 3
- 423 3
- 465 3
- 528 3
- 633 3
- 738 3
- 758 3
- 789 3
- 812 3
- 819 3
- 821 3
- 825 3
- 829 3
- 836 3
- 837 3
- 851 3
- 867 3
- 871 3
- 878 3
- 881 3
- 890 3
- 908 3
- 914 3
- 921 3
- 926 3
- 942 3
- 982 3
- 985 3
- 1028 3
- 1051 3
- 1069 3
- 1181 3
- 9 2
- 10 2
- 28 2
- 154 2
- 290 2
- 291 2
- 315 2
- 319 2
- 342 2
- 361 2
- 380 2
- 578 2
- 673 2
- 770 2
- 774 2
- 797 2
- 816 2
- 822 2
- 831 2
- 841 2
- 846 2
- 850 2
- 856 2
- 860 2
- 889 2
- 899 2
- 911 2
- 918 2
- 922 2
- 930 2
- 931 2
- 938 2
- 969 2
- 987 2
- 998 2
- 1010 2
- 1016 2
- 1022 2
- 1024 2
- 1060 2
- 1080 2
- 1085 2
- 5 1
- 6 1
- 7 1
- 8 1
- 11 1
- 13 1
- 14 1
- 19 1
- 20 1
- 22 1
- 24 1
- 25 1
- 26 1
- 31 1
- 45 1
- 47 1
- 49 1
- 51 1
- 53 1
- 55 1
- 58 1
- 61 1
- 63 1
- 65 1
- 67 1
- 69 1
- 72 1
- 73 1
- 77 1
- 81 1
- 86 1
- 90 1
- 94 1
- 98 1
- 103 1
- 107 1
- 110 1
- 114 1
- 117 1
- 120 1
- 124 1
- 129 1
- 134 1
- 139 1
- 159 1
- 165 1
- 172 1
- 178 1
- 183 1
- 188 1
- 192 1
- 201 1
- 206 1
- 210 1
- 216 1
- 221 1
- 227 1
- 232 1
- 238 1
- 242 1
- 248 1
- 255 1
- 260 1
- 263 1
- 265 1
- 270 1
- 276 1
- 278 1
- 284 1
- 289 1
- 293 1
- 295 1
- 300 1
- 302 1
- 303 1
- 323 1
- 326 1
- 327 1
- 332 1
- 335 1
- 341 1
- 346 1
- 349 1
- 351 1
- 352 1
- 359 1
- 360 1
- 368 1
- 369 1
- 371 1
- 377 1
- 378 1
- 388 1
- 396 1
- 401 1
- 407 1
- 410 1
- 415 1
- 417 1
- 420 1
- 427 1
- 435 1
- 448 1
- 455 1
- 480 1
- 482 1
- 486 1
- 504 1
- 510 1
- 519 1
- 527 1
- 543 1
- 549 1
- 565 1
- 573 1
- 574 1
- 591 1
- 601 1
- 610 1
- 614 1
- 632 1
- 648 1
- 656 1
- 665 1
- 672 1
- 681 1
- 685 1
- 691 1
- 715 1
- 719 1
- 729 1
- 734 1
- 741 1
- 745 1
- 750 1
- 754 1
- 760 1
- 762 1
- 767 1
- 769 1
- 771 1
- 781 1
- 783 1
- 793 1
- 794 1
- 803 1
- 804 1
- 806 1
- 810 1
- 811 1
- 817 1
- 818 1
- 820 1
- 842 1
- 854 1
- 858 1
- 859 1
- 862 1
- 864 1
- 866 1
- 877 1
- 885 1
- 888 1
- 901 1
- 912 1
- 919 1
- 920 1
- 925 1
- 928 1
- 935 1
- 939 1
- 941 1
- 945 1
- 948 1
- 949 1
- 962 1
- 964 1
- 965 1
- 966 1
- 970 1
- 979 1
- 989 1
- 991 1
- 995 1
- 1012 1
- 1013 1
- 1017 1
- 1023 1
- 1042 1
- 1043 1
- 1046 1
- 1062 1
- 1064 1
- 1101 1
- 1121 1
- 1122 1
- 1127 1
state 1
- Arizona 785
fips 1
- 4027 · 785 ✖
county 1
- Yuma 785
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499685 | 2499685 | 2022-05-13 | Yuma | Arizona | 4027 | 62751 | 1181 |
2496427 | 2496427 | 2022-05-12 | Yuma | Arizona | 4027 | 62751 | 1181 |
2493169 | 2493169 | 2022-05-11 | Yuma | Arizona | 4027 | 62751 | 1181 |
2489911 | 2489911 | 2022-05-10 | Yuma | Arizona | 4027 | 62716 | 1180 |
2486654 | 2486654 | 2022-05-09 | Yuma | Arizona | 4027 | 62716 | 1180 |
2483396 | 2483396 | 2022-05-08 | Yuma | Arizona | 4027 | 62716 | 1180 |
2480138 | 2480138 | 2022-05-07 | Yuma | Arizona | 4027 | 62716 | 1180 |
2476880 | 2476880 | 2022-05-06 | Yuma | Arizona | 4027 | 62716 | 1180 |
2473622 | 2473622 | 2022-05-05 | Yuma | Arizona | 4027 | 62716 | 1180 |
2470365 | 2470365 | 2022-05-04 | Yuma | Arizona | 4027 | 62716 | 1180 |
2467109 | 2467109 | 2022-05-03 | Yuma | Arizona | 4027 | 62685 | 1172 |
2463854 | 2463854 | 2022-05-02 | Yuma | Arizona | 4027 | 62685 | 1172 |
2460598 | 2460598 | 2022-05-01 | Yuma | Arizona | 4027 | 62685 | 1172 |
2457342 | 2457342 | 2022-04-30 | Yuma | Arizona | 4027 | 62685 | 1172 |
2454086 | 2454086 | 2022-04-29 | Yuma | Arizona | 4027 | 62685 | 1172 |
2450830 | 2450830 | 2022-04-28 | Yuma | Arizona | 4027 | 62685 | 1172 |
2447574 | 2447574 | 2022-04-27 | Yuma | Arizona | 4027 | 62685 | 1172 |
2444318 | 2444318 | 2022-04-26 | Yuma | Arizona | 4027 | 62659 | 1167 |
2441062 | 2441062 | 2022-04-25 | Yuma | Arizona | 4027 | 62659 | 1167 |
2437806 | 2437806 | 2022-04-24 | Yuma | Arizona | 4027 | 62659 | 1167 |
2434550 | 2434550 | 2022-04-23 | Yuma | Arizona | 4027 | 62659 | 1167 |
2431294 | 2431294 | 2022-04-22 | Yuma | Arizona | 4027 | 62659 | 1167 |
2428038 | 2428038 | 2022-04-21 | Yuma | Arizona | 4027 | 62659 | 1167 |
2424782 | 2424782 | 2022-04-20 | Yuma | Arizona | 4027 | 62659 | 1167 |
2421526 | 2421526 | 2022-04-19 | Yuma | Arizona | 4027 | 62636 | 1167 |
2418270 | 2418270 | 2022-04-18 | Yuma | Arizona | 4027 | 62636 | 1167 |
2415014 | 2415014 | 2022-04-17 | Yuma | Arizona | 4027 | 62636 | 1167 |
2411758 | 2411758 | 2022-04-16 | Yuma | Arizona | 4027 | 62636 | 1167 |
2408502 | 2408502 | 2022-04-15 | Yuma | Arizona | 4027 | 62636 | 1167 |
2405246 | 2405246 | 2022-04-14 | Yuma | Arizona | 4027 | 62636 | 1167 |
2401991 | 2401991 | 2022-04-13 | Yuma | Arizona | 4027 | 62636 | 1167 |
2398736 | 2398736 | 2022-04-12 | Yuma | Arizona | 4027 | 62610 | 1167 |
2395481 | 2395481 | 2022-04-11 | Yuma | Arizona | 4027 | 62610 | 1167 |
2392225 | 2392225 | 2022-04-10 | Yuma | Arizona | 4027 | 62610 | 1167 |
2388969 | 2388969 | 2022-04-09 | Yuma | Arizona | 4027 | 62610 | 1167 |
2385714 | 2385714 | 2022-04-08 | Yuma | Arizona | 4027 | 62610 | 1167 |
2382459 | 2382459 | 2022-04-07 | Yuma | Arizona | 4027 | 62610 | 1167 |
2379204 | 2379204 | 2022-04-06 | Yuma | Arizona | 4027 | 62610 | 1167 |
2375950 | 2375950 | 2022-04-05 | Yuma | Arizona | 4027 | 62571 | 1162 |
2372698 | 2372698 | 2022-04-04 | Yuma | Arizona | 4027 | 62571 | 1162 |
2369445 | 2369445 | 2022-04-03 | Yuma | Arizona | 4027 | 62571 | 1162 |
2366192 | 2366192 | 2022-04-02 | Yuma | Arizona | 4027 | 62571 | 1162 |
2362939 | 2362939 | 2022-04-01 | Yuma | Arizona | 4027 | 62571 | 1162 |
2359685 | 2359685 | 2022-03-31 | Yuma | Arizona | 4027 | 62571 | 1162 |
2356431 | 2356431 | 2022-03-30 | Yuma | Arizona | 4027 | 62571 | 1162 |
2353178 | 2353178 | 2022-03-29 | Yuma | Arizona | 4027 | 62517 | 1155 |
2349926 | 2349926 | 2022-03-28 | Yuma | Arizona | 4027 | 62517 | 1155 |
2346673 | 2346673 | 2022-03-27 | Yuma | Arizona | 4027 | 62517 | 1155 |
2343420 | 2343420 | 2022-03-26 | Yuma | Arizona | 4027 | 62517 | 1155 |
2340167 | 2340167 | 2022-03-25 | Yuma | Arizona | 4027 | 62517 | 1155 |
2336914 | 2336914 | 2022-03-24 | Yuma | Arizona | 4027 | 62517 | 1155 |
2333660 | 2333660 | 2022-03-23 | Yuma | Arizona | 4027 | 62517 | 1155 |
2330406 | 2330406 | 2022-03-22 | Yuma | Arizona | 4027 | 62389 | 1147 |
2327154 | 2327154 | 2022-03-21 | Yuma | Arizona | 4027 | 62389 | 1147 |
2323901 | 2323901 | 2022-03-20 | Yuma | Arizona | 4027 | 62389 | 1147 |
2320647 | 2320647 | 2022-03-19 | Yuma | Arizona | 4027 | 62389 | 1147 |
2317393 | 2317393 | 2022-03-18 | Yuma | Arizona | 4027 | 62389 | 1147 |
2314140 | 2314140 | 2022-03-17 | Yuma | Arizona | 4027 | 62389 | 1147 |
2310887 | 2310887 | 2022-03-16 | Yuma | Arizona | 4027 | 62389 | 1147 |
2307634 | 2307634 | 2022-03-15 | Yuma | Arizona | 4027 | 62297 | 1135 |
2304383 | 2304383 | 2022-03-14 | Yuma | Arizona | 4027 | 62297 | 1135 |
2301131 | 2301131 | 2022-03-13 | Yuma | Arizona | 4027 | 62297 | 1135 |
2297879 | 2297879 | 2022-03-12 | Yuma | Arizona | 4027 | 62297 | 1135 |
2294627 | 2294627 | 2022-03-11 | Yuma | Arizona | 4027 | 62297 | 1135 |
2291375 | 2291375 | 2022-03-10 | Yuma | Arizona | 4027 | 62297 | 1135 |
2288123 | 2288123 | 2022-03-09 | Yuma | Arizona | 4027 | 62297 | 1135 |
2284872 | 2284872 | 2022-03-08 | Yuma | Arizona | 4027 | 62171 | 1126 |
2281620 | 2281620 | 2022-03-07 | Yuma | Arizona | 4027 | 62171 | 1126 |
2278367 | 2278367 | 2022-03-06 | Yuma | Arizona | 4027 | 62171 | 1126 |
2275114 | 2275114 | 2022-03-05 | Yuma | Arizona | 4027 | 62171 | 1126 |
2271861 | 2271861 | 2022-03-04 | Yuma | Arizona | 4027 | 62171 | 1126 |
2268609 | 2268609 | 2022-03-03 | Yuma | Arizona | 4027 | 62171 | 1126 |
2265356 | 2265356 | 2022-03-02 | Yuma | Arizona | 4027 | 62171 | 1126 |
2262105 | 2262105 | 2022-03-01 | Yuma | Arizona | 4027 | 62086 | 1126 |
2258854 | 2258854 | 2022-02-28 | Yuma | Arizona | 4027 | 62086 | 1126 |
2255603 | 2255603 | 2022-02-27 | Yuma | Arizona | 4027 | 62086 | 1126 |
2252352 | 2252352 | 2022-02-26 | Yuma | Arizona | 4027 | 62086 | 1126 |
2249101 | 2249101 | 2022-02-25 | Yuma | Arizona | 4027 | 62057 | 1127 |
2245850 | 2245850 | 2022-02-24 | Yuma | Arizona | 4027 | 62008 | 1126 |
2242599 | 2242599 | 2022-02-23 | Yuma | Arizona | 4027 | 61986 | 1122 |
2239348 | 2239348 | 2022-02-22 | Yuma | Arizona | 4027 | 61968 | 1121 |
2236097 | 2236097 | 2022-02-21 | Yuma | Arizona | 4027 | 61867 | 1109 |
2232846 | 2232846 | 2022-02-20 | Yuma | Arizona | 4027 | 61868 | 1109 |
2229595 | 2229595 | 2022-02-19 | Yuma | Arizona | 4027 | 61823 | 1109 |
2226344 | 2226344 | 2022-02-18 | Yuma | Arizona | 4027 | 61761 | 1109 |
2223093 | 2223093 | 2022-02-17 | Yuma | Arizona | 4027 | 61676 | 1101 |
2219842 | 2219842 | 2022-02-16 | Yuma | Arizona | 4027 | 61622 | 1088 |
2216591 | 2216591 | 2022-02-15 | Yuma | Arizona | 4027 | 61558 | 1088 |
2213340 | 2213340 | 2022-02-14 | Yuma | Arizona | 4027 | 61497 | 1088 |
2210088 | 2210088 | 2022-02-13 | Yuma | Arizona | 4027 | 61412 | 1088 |
2206835 | 2206835 | 2022-02-12 | Yuma | Arizona | 4027 | 61303 | 1088 |
2203582 | 2203582 | 2022-02-11 | Yuma | Arizona | 4027 | 61161 | 1085 |
2200329 | 2200329 | 2022-02-10 | Yuma | Arizona | 4027 | 61098 | 1085 |
2197075 | 2197075 | 2022-02-09 | Yuma | Arizona | 4027 | 60852 | 1080 |
2193820 | 2193820 | 2022-02-08 | Yuma | Arizona | 4027 | 60770 | 1080 |
2190567 | 2190567 | 2022-02-07 | Yuma | Arizona | 4027 | 60657 | 1069 |
2187314 | 2187314 | 2022-02-06 | Yuma | Arizona | 4027 | 60492 | 1069 |
2184061 | 2184061 | 2022-02-05 | Yuma | Arizona | 4027 | 60302 | 1069 |
2180809 | 2180809 | 2022-02-04 | Yuma | Arizona | 4027 | 60096 | 1064 |
2177558 | 2177558 | 2022-02-03 | Yuma | Arizona | 4027 | 59797 | 1062 |
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);