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 193,264
- Georgia 124,569
- Virginia 102,995
- Kentucky 92,332
- Missouri 89,483
- Illinois 79,296
- Kansas 79,082
- North Carolina 77,709
- Iowa 76,870
- Tennessee 74,623
- Indiana 71,735
- Nebraska 69,161
- Ohio 69,012
- Minnesota 67,707
- Michigan 65,034
- Mississippi 64,047
- Oklahoma 59,845
- Arkansas 58,880
- Puerto Rico 58,318
- Wisconsin 55,921
- Florida 53,226
- Pennsylvania 52,374
- Alabama 52,178
- Louisiana 50,772
- South Dakota 49,486
- Colorado 49,399
- New York 45,634
- California 45,577
- West Virginia 42,183
- Montana 40,600
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497752 | 2497752 | 2022-05-12 | Forrest | Mississippi | 28035 | 22076 | 315 |
2497753 | 2497753 | 2022-05-12 | Franklin | Mississippi | 28037 | 1927 | 38 |
2497754 | 2497754 | 2022-05-12 | George | Mississippi | 28039 | 7163 | 87 |
2497755 | 2497755 | 2022-05-12 | Greene | Mississippi | 28041 | 3198 | 59 |
2497756 | 2497756 | 2022-05-12 | Grenada | Mississippi | 28043 | 5533 | 131 |
2497757 | 2497757 | 2022-05-12 | Hancock | Mississippi | 28045 | 12277 | 152 |
2497758 | 2497758 | 2022-05-12 | Harrison | Mississippi | 28047 | 53859 | 665 |
2497759 | 2497759 | 2022-05-12 | Hinds | Mississippi | 28049 | 52682 | 791 |
2497760 | 2497760 | 2022-05-12 | Holmes | Mississippi | 28051 | 4455 | 104 |
2497761 | 2497761 | 2022-05-12 | Humphreys | Mississippi | 28053 | 2030 | 46 |
2497762 | 2497762 | 2022-05-12 | Issaquena | Mississippi | 28055 | 262 | 9 |
2497763 | 2497763 | 2022-05-12 | Itawamba | Mississippi | 28057 | 7430 | 144 |
2497764 | 2497764 | 2022-05-12 | Jackson | Mississippi | 28059 | 37055 | 463 |
2497765 | 2497765 | 2022-05-12 | Jasper | Mississippi | 28061 | 4943 | 75 |
2497766 | 2497766 | 2022-05-12 | Jefferson | Mississippi | 28063 | 1494 | 37 |
2497767 | 2497767 | 2022-05-12 | Jefferson Davis | Mississippi | 28065 | 2865 | 53 |
2497768 | 2497768 | 2022-05-12 | Jones | Mississippi | 28067 | 21234 | 295 |
2497769 | 2497769 | 2022-05-12 | Kemper | Mississippi | 28069 | 2187 | 48 |
2497770 | 2497770 | 2022-05-12 | Lafayette | Mississippi | 28071 | 15364 | 179 |
2497771 | 2497771 | 2022-05-12 | Lamar | Mississippi | 28073 | 17441 | 160 |
2497772 | 2497772 | 2022-05-12 | Lauderdale | Mississippi | 28075 | 18898 | 367 |
2497773 | 2497773 | 2022-05-12 | Lawrence | Mississippi | 28077 | 3590 | 56 |
2497774 | 2497774 | 2022-05-12 | Leake | Mississippi | 28079 | 6427 | 120 |
2497775 | 2497775 | 2022-05-12 | Lee | Mississippi | 28081 | 26783 | 301 |
2497776 | 2497776 | 2022-05-12 | Leflore | Mississippi | 28083 | 7326 | 169 |
2497777 | 2497777 | 2022-05-12 | Lincoln | Mississippi | 28085 | 8324 | 157 |
2497778 | 2497778 | 2022-05-12 | Lowndes | Mississippi | 28087 | 17528 | 238 |
2497779 | 2497779 | 2022-05-12 | Madison | Mississippi | 28089 | 24189 | 329 |
2497780 | 2497780 | 2022-05-12 | Marion | Mississippi | 28091 | 6974 | 135 |
2497781 | 2497781 | 2022-05-12 | Marshall | Mississippi | 28093 | 9941 | 174 |
2497782 | 2497782 | 2022-05-12 | Monroe | Mississippi | 28095 | 10997 | 220 |
2497783 | 2497783 | 2022-05-12 | Montgomery | Mississippi | 28097 | 2963 | 77 |
2497784 | 2497784 | 2022-05-12 | Neshoba | Mississippi | 28099 | 10622 | 241 |
2497785 | 2497785 | 2022-05-12 | Newton | Mississippi | 28101 | 6059 | 98 |
2497786 | 2497786 | 2022-05-12 | Noxubee | Mississippi | 28103 | 2730 | 48 |
2497787 | 2497787 | 2022-05-12 | Oktibbeha | Mississippi | 28105 | 11127 | 162 |
2497788 | 2497788 | 2022-05-12 | Panola | Mississippi | 28107 | 10566 | 169 |
2497789 | 2497789 | 2022-05-12 | Pearl River | Mississippi | 28109 | 15151 | 275 |
2497790 | 2497790 | 2022-05-12 | Perry | Mississippi | 28111 | 3048 | 64 |
2497791 | 2497791 | 2022-05-12 | Pike | Mississippi | 28113 | 9751 | 189 |
2497792 | 2497792 | 2022-05-12 | Pontotoc | Mississippi | 28115 | 10364 | 145 |
2497793 | 2497793 | 2022-05-12 | Prentiss | Mississippi | 28117 | 8245 | 103 |
2497794 | 2497794 | 2022-05-12 | Quitman | Mississippi | 28119 | 1579 | 31 |
2497795 | 2497795 | 2022-05-12 | Rankin | Mississippi | 28121 | 36738 | 489 |
2497796 | 2497796 | 2022-05-12 | Scott | Mississippi | 28123 | 6559 | 119 |
2497797 | 2497797 | 2022-05-12 | Sharkey | Mississippi | 28125 | 953 | 26 |
2497798 | 2497798 | 2022-05-12 | Simpson | Mississippi | 28127 | 7026 | 149 |
2497799 | 2497799 | 2022-05-12 | Smith | Mississippi | 28129 | 4127 | 68 |
2497800 | 2497800 | 2022-05-12 | Stone | Mississippi | 28131 | 5409 | 71 |
2497801 | 2497801 | 2022-05-12 | Sunflower | Mississippi | 28133 | 5773 | 125 |
2497802 | 2497802 | 2022-05-12 | Tallahatchie | Mississippi | 28135 | 3203 | 60 |
2497803 | 2497803 | 2022-05-12 | Tate | Mississippi | 28137 | 7396 | 143 |
2497804 | 2497804 | 2022-05-12 | Tippah | Mississippi | 28139 | 7361 | 109 |
2497805 | 2497805 | 2022-05-12 | Tishomingo | Mississippi | 28141 | 6172 | 122 |
2497806 | 2497806 | 2022-05-12 | Tunica | Mississippi | 28143 | 2559 | 48 |
2497807 | 2497807 | 2022-05-12 | Union | Mississippi | 28145 | 9487 | 122 |
2497808 | 2497808 | 2022-05-12 | Unknown | Mississippi | 1218 | 3 | |
2497809 | 2497809 | 2022-05-12 | Walthall | Mississippi | 28147 | 3622 | 79 |
2497810 | 2497810 | 2022-05-12 | Warren | Mississippi | 28149 | 10250 | 202 |
2497811 | 2497811 | 2022-05-12 | Washington | Mississippi | 28151 | 10470 | 199 |
2497812 | 2497812 | 2022-05-12 | Wayne | Mississippi | 28153 | 6008 | 87 |
2497813 | 2497813 | 2022-05-12 | Webster | Mississippi | 28155 | 3388 | 70 |
2497814 | 2497814 | 2022-05-12 | Wilkinson | Mississippi | 28157 | 1804 | 46 |
2497815 | 2497815 | 2022-05-12 | Winston | Mississippi | 28159 | 5231 | 104 |
2497816 | 2497816 | 2022-05-12 | Yalobusha | Mississippi | 28161 | 4114 | 57 |
2497817 | 2497817 | 2022-05-12 | Yazoo | Mississippi | 28163 | 8054 | 107 |
2497818 | 2497818 | 2022-05-12 | Adair | Missouri | 29001 | 6095 | 63 |
2497819 | 2497819 | 2022-05-12 | Andrew | Missouri | 29003 | 4810 | 58 |
2497820 | 2497820 | 2022-05-12 | Atchison | Missouri | 29005 | 1385 | 23 |
2497821 | 2497821 | 2022-05-12 | Audrain | Missouri | 29007 | 5718 | 110 |
2497822 | 2497822 | 2022-05-12 | Barry | Missouri | 29009 | 6641 | 131 |
2497823 | 2497823 | 2022-05-12 | Barton | Missouri | 29011 | 2857 | 52 |
2497824 | 2497824 | 2022-05-12 | Bates | Missouri | 29013 | 3756 | 96 |
2497825 | 2497825 | 2022-05-12 | Benton | Missouri | 29015 | 4240 | 107 |
2497826 | 2497826 | 2022-05-12 | Bollinger | Missouri | 29017 | 2625 | 41 |
2497827 | 2497827 | 2022-05-12 | Boone | Missouri | 29019 | 44976 | 250 |
2497828 | 2497828 | 2022-05-12 | Buchanan | Missouri | 29021 | 24863 | 317 |
2497829 | 2497829 | 2022-05-12 | Butler | Missouri | 29023 | 10177 | 169 |
2497830 | 2497830 | 2022-05-12 | Caldwell | Missouri | 29025 | 1697 | 39 |
2497831 | 2497831 | 2022-05-12 | Callaway | Missouri | 29027 | 12120 | 129 |
2497832 | 2497832 | 2022-05-12 | Camden | Missouri | 29029 | 9314 | 180 |
2497833 | 2497833 | 2022-05-12 | Cape Girardeau | Missouri | 29031 | 18882 | 245 |
2497834 | 2497834 | 2022-05-12 | Carroll | Missouri | 29033 | 2225 | 44 |
2497835 | 2497835 | 2022-05-12 | Carter | Missouri | 29035 | 1500 | 24 |
2497836 | 2497836 | 2022-05-12 | Cass | Missouri | 29037 | 25185 | 315 |
2497837 | 2497837 | 2022-05-12 | Cedar | Missouri | 29039 | 2932 | 57 |
2497838 | 2497838 | 2022-05-12 | Chariton | Missouri | 29041 | 1717 | 38 |
2497839 | 2497839 | 2022-05-12 | Christian | Missouri | 29043 | 20920 | 262 |
2497840 | 2497840 | 2022-05-12 | Clark | Missouri | 29045 | 1593 | 37 |
2497841 | 2497841 | 2022-05-12 | Clay | Missouri | 29047 | 27246 | 361 |
2497842 | 2497842 | 2022-05-12 | Clinton | Missouri | 29049 | 4818 | 119 |
2497843 | 2497843 | 2022-05-12 | Cole | Missouri | 29051 | 20170 | 286 |
2497844 | 2497844 | 2022-05-12 | Cooper | Missouri | 29053 | 4133 | 77 |
2497845 | 2497845 | 2022-05-12 | Crawford | Missouri | 29055 | 5393 | 102 |
2497846 | 2497846 | 2022-05-12 | Dade | Missouri | 29057 | 1447 | 42 |
2497847 | 2497847 | 2022-05-12 | Dallas | Missouri | 29059 | 3819 | 72 |
2497848 | 2497848 | 2022-05-12 | Daviess | Missouri | 29061 | 1727 | 29 |
2497849 | 2497849 | 2022-05-12 | DeKalb | Missouri | 29063 | 2216 | 47 |
2497850 | 2497850 | 2022-05-12 | Dent | Missouri | 29065 | 3257 | 83 |
2497851 | 2497851 | 2022-05-12 | Douglas | Missouri | 29067 | 2551 | 80 |
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);