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 56
- Texas 168,366
- Georgia 109,002
- Virginia 89,958
- Kentucky 80,692
- Missouri 78,017
- Illinois 69,305
- Kansas 68,863
- North Carolina 67,909
- Iowa 67,170
- Tennessee 65,215
- Indiana 62,778
- Ohio 60,290
- Nebraska 59,949
- Minnesota 59,171
- Michigan 56,886
- Mississippi 55,972
- Oklahoma 52,201
- Arkansas 51,432
- Puerto Rico 50,576
- Wisconsin 48,865
- Florida 46,562
- Pennsylvania 45,808
- Alabama 45,612
- Louisiana 44,467
- Colorado 43,127
- South Dakota 43,018
- New York 39,950
- California 39,892
- West Virginia 36,793
- North Dakota 35,153
- Montana 35,112
- South Carolina 31,537
- Idaho 28,828
- Washington 27,022
- Oregon 24,219
- New Mexico 22,120
- Utah 19,949
- Alaska 17,770
- Maryland 17,170
- Wyoming 15,538
- New Jersey 15,239
- Maine 11,414
- Nevada 11,124
- Massachusetts 10,429
- Arizona 10,419
- Vermont 10,273
- New Hampshire 7,523
- Connecticut 6,191
- Rhode Island 4,110
- Hawaii 3,388
- Delaware 2,731
- Virgin Islands 2,184
- Northern Mariana Islands 1,441
- District of Columbia 698
- Guam 691
- American Samoa 139
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177886 | 2177886 | 2022-02-03 | Douglas | Georgia | 13097 | 33850 | 346 |
2177887 | 2177887 | 2022-02-03 | Early | Georgia | 13099 | 2674 | 59 |
2177888 | 2177888 | 2022-02-03 | Echols | Georgia | 13101 | 914 | 11 |
2177889 | 2177889 | 2022-02-03 | Effingham | Georgia | 13103 | 12450 | 179 |
2177890 | 2177890 | 2022-02-03 | Elbert | Georgia | 13105 | 4473 | 97 |
2177891 | 2177891 | 2022-02-03 | Emanuel | Georgia | 13107 | 5730 | 146 |
2177892 | 2177892 | 2022-02-03 | Evans | Georgia | 13109 | 2191 | 61 |
2177893 | 2177893 | 2022-02-03 | Fannin | Georgia | 13111 | 4916 | 127 |
2177894 | 2177894 | 2022-02-03 | Fayette | Georgia | 13113 | 21285 | 283 |
2177895 | 2177895 | 2022-02-03 | Floyd | Georgia | 13115 | 26106 | 439 |
2177896 | 2177896 | 2022-02-03 | Forsyth | Georgia | 13117 | 52051 | 327 |
2177897 | 2177897 | 2022-02-03 | Franklin | Georgia | 13119 | 5207 | 92 |
2177898 | 2177898 | 2022-02-03 | Fulton | Georgia | 13121 | 206779 | 1996 |
2177899 | 2177899 | 2022-02-03 | Gilmer | Georgia | 13123 | 6440 | 153 |
2177900 | 2177900 | 2022-02-03 | Glascock | Georgia | 13125 | 583 | 23 |
2177901 | 2177901 | 2022-02-03 | Glynn | Georgia | 13127 | 21770 | 362 |
2177902 | 2177902 | 2022-02-03 | Gordon | Georgia | 13129 | 14935 | 233 |
2177903 | 2177903 | 2022-02-03 | Grady | Georgia | 13131 | 5498 | 98 |
2177904 | 2177904 | 2022-02-03 | Greene | Georgia | 13133 | 3790 | 75 |
2177905 | 2177905 | 2022-02-03 | Gwinnett | Georgia | 13135 | 200072 | 1675 |
2177906 | 2177906 | 2022-02-03 | Habersham | Georgia | 13137 | 9714 | 234 |
2177907 | 2177907 | 2022-02-03 | Hall | Georgia | 13139 | 51998 | 738 |
2177908 | 2177908 | 2022-02-03 | Hancock | Georgia | 13141 | 1523 | 86 |
2177909 | 2177909 | 2022-02-03 | Haralson | Georgia | 13143 | 5287 | 146 |
2177910 | 2177910 | 2022-02-03 | Harris | Georgia | 13145 | 5860 | 99 |
2177911 | 2177911 | 2022-02-03 | Hart | Georgia | 13147 | 4734 | 79 |
2177912 | 2177912 | 2022-02-03 | Heard | Georgia | 13149 | 2096 | 44 |
2177913 | 2177913 | 2022-02-03 | Henry | Georgia | 13151 | 56009 | 590 |
2177914 | 2177914 | 2022-02-03 | Houston | Georgia | 13153 | 37870 | 443 |
2177915 | 2177915 | 2022-02-03 | Irwin | Georgia | 13155 | 1831 | 42 |
2177916 | 2177916 | 2022-02-03 | Jackson | Georgia | 13157 | 20654 | 252 |
2177917 | 2177917 | 2022-02-03 | Jasper | Georgia | 13159 | 3027 | 68 |
2177918 | 2177918 | 2022-02-03 | Jeff Davis | Georgia | 13161 | 3748 | 66 |
2177919 | 2177919 | 2022-02-03 | Jefferson | Georgia | 13163 | 3538 | 100 |
2177920 | 2177920 | 2022-02-03 | Jenkins | Georgia | 13165 | 1460 | 64 |
2177921 | 2177921 | 2022-02-03 | Johnson | Georgia | 13167 | 2186 | 66 |
2177922 | 2177922 | 2022-02-03 | Jones | Georgia | 13169 | 4821 | 103 |
2177923 | 2177923 | 2022-02-03 | Lamar | Georgia | 13171 | 4703 | 105 |
2177924 | 2177924 | 2022-02-03 | Lanier | Georgia | 13173 | 2209 | 18 |
2177925 | 2177925 | 2022-02-03 | Laurens | Georgia | 13175 | 13478 | 270 |
2177926 | 2177926 | 2022-02-03 | Lee | Georgia | 13177 | 6910 | 92 |
2177927 | 2177927 | 2022-02-03 | Liberty | Georgia | 13179 | 11734 | 142 |
2177928 | 2177928 | 2022-02-03 | Lincoln | Georgia | 13181 | 1552 | 35 |
2177929 | 2177929 | 2022-02-03 | Long | Georgia | 13183 | 2632 | 29 |
2177930 | 2177930 | 2022-02-03 | Lowndes | Georgia | 13185 | 29910 | 341 |
2177931 | 2177931 | 2022-02-03 | Lumpkin | Georgia | 13187 | 6873 | 114 |
2177932 | 2177932 | 2022-02-03 | Macon | Georgia | 13193 | 2068 | 47 |
2177933 | 2177933 | 2022-02-03 | Madison | Georgia | 13195 | 6790 | 86 |
2177934 | 2177934 | 2022-02-03 | Marion | Georgia | 13197 | 1458 | 43 |
2177935 | 2177935 | 2022-02-03 | McDuffie | Georgia | 13189 | 4867 | 85 |
2177936 | 2177936 | 2022-02-03 | McIntosh | Georgia | 13191 | 2273 | 35 |
2177937 | 2177937 | 2022-02-03 | Meriwether | Georgia | 13199 | 4325 | 128 |
2177938 | 2177938 | 2022-02-03 | Miller | Georgia | 13201 | 1658 | 26 |
2177939 | 2177939 | 2022-02-03 | Mitchell | Georgia | 13205 | 5013 | 104 |
2177940 | 2177940 | 2022-02-03 | Monroe | Georgia | 13207 | 5668 | 157 |
2177941 | 2177941 | 2022-02-03 | Montgomery | Georgia | 13209 | 1941 | 47 |
2177942 | 2177942 | 2022-02-03 | Morgan | Georgia | 13211 | 4441 | 53 |
2177943 | 2177943 | 2022-02-03 | Murray | Georgia | 13213 | 10910 | 160 |
2177944 | 2177944 | 2022-02-03 | Muscogee | Georgia | 13215 | 36569 | 708 |
2177945 | 2177945 | 2022-02-03 | Newton | Georgia | 13217 | 23779 | 403 |
2177946 | 2177946 | 2022-02-03 | Oconee | Georgia | 13219 | 8496 | 92 |
2177947 | 2177947 | 2022-02-03 | Oglethorpe | Georgia | 13221 | 3132 | 47 |
2177948 | 2177948 | 2022-02-03 | Paulding | Georgia | 13223 | 36758 | 381 |
2177949 | 2177949 | 2022-02-03 | Peach | Georgia | 13225 | 5886 | 118 |
2177950 | 2177950 | 2022-02-03 | Pickens | Georgia | 13227 | 7889 | 142 |
2177951 | 2177951 | 2022-02-03 | Pierce | Georgia | 13229 | 5291 | 109 |
2177952 | 2177952 | 2022-02-03 | Pike | Georgia | 13231 | 5194 | 79 |
2177953 | 2177953 | 2022-02-03 | Polk | Georgia | 13233 | 11411 | 172 |
2177954 | 2177954 | 2022-02-03 | Pulaski | Georgia | 13235 | 2126 | 69 |
2177955 | 2177955 | 2022-02-03 | Putnam | Georgia | 13237 | 4334 | 92 |
2177956 | 2177956 | 2022-02-03 | Quitman | Georgia | 13239 | 398 | 4 |
2177957 | 2177957 | 2022-02-03 | Rabun | Georgia | 13241 | 3515 | 86 |
2177958 | 2177958 | 2022-02-03 | Randolph | Georgia | 13243 | 1414 | 47 |
2177959 | 2177959 | 2022-02-03 | Richmond | Georgia | 13245 | 48103 | 791 |
2177960 | 2177960 | 2022-02-03 | Rockdale | Georgia | 13247 | 17749 | 285 |
2177961 | 2177961 | 2022-02-03 | Schley | Georgia | 13249 | 1105 | 8 |
2177962 | 2177962 | 2022-02-03 | Screven | Georgia | 13251 | 2550 | 62 |
2177963 | 2177963 | 2022-02-03 | Seminole | Georgia | 13253 | 2091 | 27 |
2177964 | 2177964 | 2022-02-03 | Spalding | Georgia | 13255 | 15378 | 365 |
2177965 | 2177965 | 2022-02-03 | Stephens | Georgia | 13257 | 6044 | 132 |
2177966 | 2177966 | 2022-02-03 | Stewart | Georgia | 13259 | 2020 | 31 |
2177967 | 2177967 | 2022-02-03 | Sumter | Georgia | 13261 | 6535 | 147 |
2177968 | 2177968 | 2022-02-03 | Talbot | Georgia | 13263 | 1112 | 31 |
2177969 | 2177969 | 2022-02-03 | Taliaferro | Georgia | 13265 | 260 | 3 |
2177970 | 2177970 | 2022-02-03 | Tattnall | Georgia | 13267 | 4760 | 122 |
2177971 | 2177971 | 2022-02-03 | Taylor | Georgia | 13269 | 1911 | 48 |
2177972 | 2177972 | 2022-02-03 | Telfair | Georgia | 13271 | 2945 | 76 |
2177973 | 2177973 | 2022-02-03 | Terrell | Georgia | 13273 | 1959 | 59 |
2177974 | 2177974 | 2022-02-03 | Thomas | Georgia | 13275 | 11365 | 189 |
2177975 | 2177975 | 2022-02-03 | Tift | Georgia | 13277 | 11242 | 200 |
2177976 | 2177976 | 2022-02-03 | Toombs | Georgia | 13279 | 6680 | 180 |
2177977 | 2177977 | 2022-02-03 | Towns | Georgia | 13281 | 2226 | 94 |
2177978 | 2177978 | 2022-02-03 | Treutlen | Georgia | 13283 | 1579 | 57 |
2177979 | 2177979 | 2022-02-03 | Troup | Georgia | 13285 | 15099 | 348 |
2177980 | 2177980 | 2022-02-03 | Turner | Georgia | 13287 | 2470 | 50 |
2177981 | 2177981 | 2022-02-03 | Twiggs | Georgia | 13289 | 1480 | 64 |
2177982 | 2177982 | 2022-02-03 | Union | Georgia | 13291 | 4530 | 140 |
2177983 | 2177983 | 2022-02-03 | Unknown | Georgia | 11415 | 11 | |
2177984 | 2177984 | 2022-02-03 | Upson | Georgia | 13293 | 7477 | 207 |
2177985 | 2177985 | 2022-02-03 | Walker | Georgia | 13295 | 15582 | 198 |
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);