ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,502,832 rows sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 46,213
- Georgia 31,929
- Virginia 25,980
- Kentucky 22,852
- Missouri 21,739
- North Carolina 19,808
- Illinois 19,743
- Tennessee 19,052
- Iowa 18,970
- Indiana 18,434
- Kansas 18,071
- Ohio 17,626
- Minnesota 16,774
- Mississippi 16,529
- Michigan 16,398
- Nebraska 14,934
- Arkansas 14,876
- Oklahoma 14,684
- Wisconsin 14,221
- Florida 13,854
- Pennsylvania 13,581
- Alabama 13,385
- Louisiana 13,138
- Puerto Rico 12,577
- Colorado 12,343
- New York 12,052
- California 11,987
- South Dakota 11,272
- West Virginia 10,336
- South Carolina 9,411
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
616818 | 616818 | 2020-10-10 | Sherburne | Minnesota | 27141 | 1330 | 16 |
616819 | 616819 | 2020-10-10 | Sibley | Minnesota | 27143 | 221 | 3 |
616820 | 616820 | 2020-10-10 | St. Louis | Minnesota | 27137 | 2157 | 55 |
616821 | 616821 | 2020-10-10 | Stearns | Minnesota | 27145 | 4634 | 30 |
616822 | 616822 | 2020-10-10 | Steele | Minnesota | 27147 | 635 | 2 |
616823 | 616823 | 2020-10-10 | Stevens | Minnesota | 27149 | 142 | 1 |
616824 | 616824 | 2020-10-10 | Swift | Minnesota | 27151 | 166 | 1 |
616825 | 616825 | 2020-10-10 | Todd | Minnesota | 27153 | 577 | 2 |
616826 | 616826 | 2020-10-10 | Traverse | Minnesota | 27155 | 43 | 0 |
616827 | 616827 | 2020-10-10 | Unknown | Minnesota | 236 | 53 | |
616828 | 616828 | 2020-10-10 | Wabasha | Minnesota | 27157 | 264 | 0 |
616829 | 616829 | 2020-10-10 | Wadena | Minnesota | 27159 | 113 | 0 |
616830 | 616830 | 2020-10-10 | Waseca | Minnesota | 27161 | 852 | 9 |
616831 | 616831 | 2020-10-10 | Washington | Minnesota | 27163 | 4447 | 62 |
616832 | 616832 | 2020-10-10 | Watonwan | Minnesota | 27165 | 550 | 4 |
616833 | 616833 | 2020-10-10 | Wilkin | Minnesota | 27167 | 96 | 3 |
616834 | 616834 | 2020-10-10 | Winona | Minnesota | 27169 | 1063 | 18 |
616835 | 616835 | 2020-10-10 | Wright | Minnesota | 27171 | 1986 | 10 |
616836 | 616836 | 2020-10-10 | Yellow Medicine | Minnesota | 27173 | 238 | 3 |
616837 | 616837 | 2020-10-10 | Adams | Mississippi | 28001 | 991 | 40 |
616838 | 616838 | 2020-10-10 | Alcorn | Mississippi | 28003 | 895 | 12 |
616839 | 616839 | 2020-10-10 | Amite | Mississippi | 28005 | 375 | 10 |
616840 | 616840 | 2020-10-10 | Attala | Mississippi | 28007 | 703 | 25 |
616841 | 616841 | 2020-10-10 | Benton | Mississippi | 28009 | 275 | 4 |
616842 | 616842 | 2020-10-10 | Bolivar | Mississippi | 28011 | 1942 | 75 |
616843 | 616843 | 2020-10-10 | Calhoun | Mississippi | 28013 | 571 | 12 |
616844 | 616844 | 2020-10-10 | Carroll | Mississippi | 28015 | 343 | 12 |
616845 | 616845 | 2020-10-10 | Chickasaw | Mississippi | 28017 | 773 | 24 |
616846 | 616846 | 2020-10-10 | Choctaw | Mississippi | 28019 | 196 | 6 |
616847 | 616847 | 2020-10-10 | Claiborne | Mississippi | 28021 | 518 | 16 |
616848 | 616848 | 2020-10-10 | Clarke | Mississippi | 28023 | 657 | 48 |
616849 | 616849 | 2020-10-10 | Clay | Mississippi | 28025 | 631 | 20 |
616850 | 616850 | 2020-10-10 | Coahoma | Mississippi | 28027 | 1207 | 34 |
616851 | 616851 | 2020-10-10 | Copiah | Mississippi | 28029 | 1281 | 35 |
616852 | 616852 | 2020-10-10 | Covington | Mississippi | 28031 | 877 | 25 |
616853 | 616853 | 2020-10-10 | DeSoto | Mississippi | 28033 | 6123 | 75 |
616854 | 616854 | 2020-10-10 | Forrest | Mississippi | 28035 | 2813 | 76 |
616855 | 616855 | 2020-10-10 | Franklin | Mississippi | 28037 | 211 | 3 |
616856 | 616856 | 2020-10-10 | George | Mississippi | 28039 | 867 | 16 |
616857 | 616857 | 2020-10-10 | Greene | Mississippi | 28041 | 426 | 17 |
616858 | 616858 | 2020-10-10 | Grenada | Mississippi | 28043 | 1158 | 36 |
616859 | 616859 | 2020-10-10 | Hancock | Mississippi | 28045 | 687 | 26 |
616860 | 616860 | 2020-10-10 | Harrison | Mississippi | 28047 | 4370 | 79 |
616861 | 616861 | 2020-10-10 | Hinds | Mississippi | 28049 | 7465 | 167 |
616862 | 616862 | 2020-10-10 | Holmes | Mississippi | 28051 | 1116 | 60 |
616863 | 616863 | 2020-10-10 | Humphreys | Mississippi | 28053 | 384 | 16 |
616864 | 616864 | 2020-10-10 | Issaquena | Mississippi | 28055 | 106 | 3 |
616865 | 616865 | 2020-10-10 | Itawamba | Mississippi | 28057 | 998 | 24 |
616866 | 616866 | 2020-10-10 | Jackson | Mississippi | 28059 | 4002 | 74 |
616867 | 616867 | 2020-10-10 | Jasper | Mississippi | 28061 | 632 | 16 |
616868 | 616868 | 2020-10-10 | Jefferson | Mississippi | 28063 | 252 | 10 |
616869 | 616869 | 2020-10-10 | Jefferson Davis | Mississippi | 28065 | 376 | 11 |
616870 | 616870 | 2020-10-10 | Jones | Mississippi | 28067 | 2679 | 81 |
616871 | 616871 | 2020-10-10 | Kemper | Mississippi | 28069 | 306 | 15 |
616872 | 616872 | 2020-10-10 | Lafayette | Mississippi | 28071 | 2341 | 41 |
616873 | 616873 | 2020-10-10 | Lamar | Mississippi | 28073 | 1982 | 37 |
616874 | 616874 | 2020-10-10 | Lauderdale | Mississippi | 28075 | 2223 | 128 |
616875 | 616875 | 2020-10-10 | Lawrence | Mississippi | 28077 | 465 | 14 |
616876 | 616876 | 2020-10-10 | Leake | Mississippi | 28079 | 1053 | 39 |
616877 | 616877 | 2020-10-10 | Lee | Mississippi | 28081 | 3181 | 76 |
616878 | 616878 | 2020-10-10 | Leflore | Mississippi | 28083 | 1513 | 82 |
616879 | 616879 | 2020-10-10 | Lincoln | Mississippi | 28085 | 1236 | 53 |
616880 | 616880 | 2020-10-10 | Lowndes | Mississippi | 28087 | 1687 | 59 |
616881 | 616881 | 2020-10-10 | Madison | Mississippi | 28089 | 3501 | 92 |
616882 | 616882 | 2020-10-10 | Marion | Mississippi | 28091 | 906 | 41 |
616883 | 616883 | 2020-10-10 | Marshall | Mississippi | 28093 | 1180 | 22 |
616884 | 616884 | 2020-10-10 | Monroe | Mississippi | 28095 | 1347 | 71 |
616885 | 616885 | 2020-10-10 | Montgomery | Mississippi | 28097 | 511 | 22 |
616886 | 616886 | 2020-10-10 | Neshoba | Mississippi | 28099 | 1712 | 109 |
616887 | 616887 | 2020-10-10 | Newton | Mississippi | 28101 | 819 | 27 |
616888 | 616888 | 2020-10-10 | Noxubee | Mississippi | 28103 | 581 | 16 |
616889 | 616889 | 2020-10-10 | Oktibbeha | Mississippi | 28105 | 1899 | 54 |
616890 | 616890 | 2020-10-10 | Panola | Mississippi | 28107 | 1599 | 35 |
616891 | 616891 | 2020-10-10 | Pearl River | Mississippi | 28109 | 1001 | 54 |
616892 | 616892 | 2020-10-10 | Perry | Mississippi | 28111 | 458 | 21 |
616893 | 616893 | 2020-10-10 | Pike | Mississippi | 28113 | 1297 | 55 |
616894 | 616894 | 2020-10-10 | Pontotoc | Mississippi | 28115 | 1397 | 18 |
616895 | 616895 | 2020-10-10 | Prentiss | Mississippi | 28117 | 945 | 19 |
616896 | 616896 | 2020-10-10 | Quitman | Mississippi | 28119 | 405 | 6 |
616897 | 616897 | 2020-10-10 | Rankin | Mississippi | 28121 | 3592 | 83 |
616898 | 616898 | 2020-10-10 | Scott | Mississippi | 28123 | 1198 | 29 |
616899 | 616899 | 2020-10-10 | Sharkey | Mississippi | 28125 | 271 | 14 |
616900 | 616900 | 2020-10-10 | Simpson | Mississippi | 28127 | 1143 | 48 |
616901 | 616901 | 2020-10-10 | Smith | Mississippi | 28129 | 567 | 15 |
616902 | 616902 | 2020-10-10 | Stone | Mississippi | 28131 | 419 | 14 |
616903 | 616903 | 2020-10-10 | Sunflower | Mississippi | 28133 | 1536 | 49 |
616904 | 616904 | 2020-10-10 | Tallahatchie | Mississippi | 28135 | 798 | 24 |
616905 | 616905 | 2020-10-10 | Tate | Mississippi | 28137 | 1079 | 38 |
616906 | 616906 | 2020-10-10 | Tippah | Mississippi | 28139 | 782 | 19 |
616907 | 616907 | 2020-10-10 | Tishomingo | Mississippi | 28141 | 752 | 39 |
616908 | 616908 | 2020-10-10 | Tunica | Mississippi | 28143 | 512 | 17 |
616909 | 616909 | 2020-10-10 | Union | Mississippi | 28145 | 1087 | 24 |
616910 | 616910 | 2020-10-10 | Walthall | Mississippi | 28147 | 617 | 27 |
616911 | 616911 | 2020-10-10 | Warren | Mississippi | 28149 | 1467 | 53 |
616912 | 616912 | 2020-10-10 | Washington | Mississippi | 28151 | 2389 | 88 |
616913 | 616913 | 2020-10-10 | Wayne | Mississippi | 28153 | 952 | 21 |
616914 | 616914 | 2020-10-10 | Webster | Mississippi | 28155 | 359 | 13 |
616915 | 616915 | 2020-10-10 | Wilkinson | Mississippi | 28157 | 316 | 19 |
616916 | 616916 | 2020-10-10 | Winston | Mississippi | 28159 | 790 | 21 |
616917 | 616917 | 2020-10-10 | Yalobusha | Mississippi | 28161 | 466 | 14 |
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);