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 168,366
- Georgia 108,889
- Virginia 89,958
- Kentucky 80,572
- Missouri 77,900
- Illinois 69,202
- Kansas 68,758
- North Carolina 67,909
- Iowa 67,070
- Tennessee 65,215
- Indiana 62,686
- Ohio 60,290
- Nebraska 59,921
- Minnesota 59,083
- Michigan 56,802
- Mississippi 55,890
- Oklahoma 52,201
- Arkansas 51,432
- Puerto Rico 50,576
- Wisconsin 48,865
- Florida 46,562
- Pennsylvania 45,808
- Alabama 45,612
- Louisiana 44,402
- Colorado 43,127
- South Dakota 43,018
- New York 39,950
- California 39,892
- West Virginia 36,793
- North Dakota 35,153
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2179146 | 2179146 | 2022-02-03 | Dundy | Nebraska | 31057 | 333 | 6 |
2179147 | 2179147 | 2022-02-03 | Fillmore | Nebraska | 31059 | 1071 | 13 |
2179148 | 2179148 | 2022-02-03 | Franklin | Nebraska | 31061 | 390 | 9 |
2179149 | 2179149 | 2022-02-03 | Frontier | Nebraska | 31063 | 510 | 2 |
2179150 | 2179150 | 2022-02-03 | Furnas | Nebraska | 31065 | 1045 | 6 |
2179151 | 2179151 | 2022-02-03 | Gage | Nebraska | 31067 | 3402 | 37 |
2179152 | 2179152 | 2022-02-03 | Garden | Nebraska | 31069 | 345 | 1 |
2179153 | 2179153 | 2022-02-03 | Garfield | Nebraska | 31071 | 372 | 2 |
2179154 | 2179154 | 2022-02-03 | Gosper | Nebraska | 31073 | 348 | 7 |
2179155 | 2179155 | 2022-02-03 | Grant | Nebraska | 31075 | 101 | 5 |
2179156 | 2179156 | 2022-02-03 | Greeley | Nebraska | 31077 | 382 | 2 |
2179157 | 2179157 | 2022-02-03 | Hall | Nebraska | 31079 | 15304 | 120 |
2179158 | 2179158 | 2022-02-03 | Hamilton | Nebraska | 31081 | 2092 | 22 |
2179159 | 2179159 | 2022-02-03 | Harlan | Nebraska | 31083 | 375 | 2 |
2179160 | 2179160 | 2022-02-03 | Hayes | Nebraska | 31085 | 100 | 0 |
2179161 | 2179161 | 2022-02-03 | Hitchcock | Nebraska | 31087 | 487 | 6 |
2179162 | 2179162 | 2022-02-03 | Holt | Nebraska | 31089 | 1974 | 18 |
2179163 | 2179163 | 2022-02-03 | Hooker | Nebraska | 31091 | 108 | 5 |
2179164 | 2179164 | 2022-02-03 | Howard | Nebraska | 31093 | 1116 | 15 |
2179165 | 2179165 | 2022-02-03 | Jefferson | Nebraska | 31095 | 1167 | 6 |
2179166 | 2179166 | 2022-02-03 | Johnson | Nebraska | 31097 | 859 | 10 |
2179167 | 2179167 | 2022-02-03 | Kearney | Nebraska | 31099 | 1151 | 7 |
2179168 | 2179168 | 2022-02-03 | Keith | Nebraska | 31101 | 1426 | 14 |
2179169 | 2179169 | 2022-02-03 | Keya Paha | Nebraska | 31103 | 113 | 0 |
2179170 | 2179170 | 2022-02-03 | Kimball | Nebraska | 31105 | 709 | 9 |
2179171 | 2179171 | 2022-02-03 | Knox | Nebraska | 31107 | 1561 | 13 |
2179172 | 2179172 | 2022-02-03 | Lancaster | Nebraska | 31109 | 71511 | 397 |
2179173 | 2179173 | 2022-02-03 | Lincoln | Nebraska | 31111 | 8033 | 102 |
2179174 | 2179174 | 2022-02-03 | Logan | Nebraska | 31113 | 137 | 0 |
2179175 | 2179175 | 2022-02-03 | Loup | Nebraska | 31115 | 87 | 0 |
2179176 | 2179176 | 2022-02-03 | Madison | Nebraska | 31119 | 9111 | 58 |
2179177 | 2179177 | 2022-02-03 | McPherson | Nebraska | 31117 | 66 | 1 |
2179178 | 2179178 | 2022-02-03 | Merrick | Nebraska | 31121 | 1618 | 15 |
2179179 | 2179179 | 2022-02-03 | Morrill | Nebraska | 31123 | 1128 | 17 |
2179180 | 2179180 | 2022-02-03 | Nance | Nebraska | 31125 | 752 | 10 |
2179181 | 2179181 | 2022-02-03 | Nemaha | Nebraska | 31127 | 1427 | 18 |
2179182 | 2179182 | 2022-02-03 | Nuckolls | Nebraska | 31129 | 896 | 13 |
2179183 | 2179183 | 2022-02-03 | Otoe | Nebraska | 31131 | 3131 | 17 |
2179184 | 2179184 | 2022-02-03 | Pawnee | Nebraska | 31133 | 388 | 4 |
2179185 | 2179185 | 2022-02-03 | Perkins | Nebraska | 31135 | 513 | 12 |
2179186 | 2179186 | 2022-02-03 | Phelps | Nebraska | 31137 | 2162 | 11 |
2179187 | 2179187 | 2022-02-03 | Pierce | Nebraska | 31139 | 1216 | 21 |
2179188 | 2179188 | 2022-02-03 | Platte | Nebraska | 31141 | 8080 | 70 |
2179189 | 2179189 | 2022-02-03 | Polk | Nebraska | 31143 | 1119 | 18 |
2179190 | 2179190 | 2022-02-03 | Red Willow | Nebraska | 31145 | 2164 | 19 |
2179191 | 2179191 | 2022-02-03 | Richardson | Nebraska | 31147 | 1679 | 24 |
2179192 | 2179192 | 2022-02-03 | Rock | Nebraska | 31149 | 168 | 2 |
2179193 | 2179193 | 2022-02-03 | Saline | Nebraska | 31151 | 3554 | 8 |
2179194 | 2179194 | 2022-02-03 | Sarpy | Nebraska | 31153 | 47158 | 223 |
2179195 | 2179195 | 2022-02-03 | Saunders | Nebraska | 31155 | 4673 | 26 |
2179196 | 2179196 | 2022-02-03 | Scotts Bluff | Nebraska | 31157 | 9624 | 102 |
2179197 | 2179197 | 2022-02-03 | Seward | Nebraska | 31159 | 3014 | 40 |
2179198 | 2179198 | 2022-02-03 | Sheridan | Nebraska | 31161 | 961 | 23 |
2179199 | 2179199 | 2022-02-03 | Sherman | Nebraska | 31163 | 548 | 4 |
2179200 | 2179200 | 2022-02-03 | Sioux | Nebraska | 31165 | 75 | 1 |
2179201 | 2179201 | 2022-02-03 | Stanton | Nebraska | 31167 | 685 | 11 |
2179202 | 2179202 | 2022-02-03 | Thayer | Nebraska | 31169 | 1033 | 8 |
2179203 | 2179203 | 2022-02-03 | Thomas | Nebraska | 31171 | 98 | 1 |
2179204 | 2179204 | 2022-02-03 | Thurston | Nebraska | 31173 | 1627 | 19 |
2179205 | 2179205 | 2022-02-03 | Unknown | Nebraska | 2770 | 361 | |
2179206 | 2179206 | 2022-02-03 | Valley | Nebraska | 31175 | 698 | 6 |
2179207 | 2179207 | 2022-02-03 | Washington | Nebraska | 31177 | 4294 | 33 |
2179208 | 2179208 | 2022-02-03 | Wayne | Nebraska | 31179 | 1656 | 11 |
2179209 | 2179209 | 2022-02-03 | Webster | Nebraska | 31181 | 683 | 9 |
2179210 | 2179210 | 2022-02-03 | Wheeler | Nebraska | 31183 | 118 | 0 |
2179211 | 2179211 | 2022-02-03 | York | Nebraska | 31185 | 3530 | 19 |
2179212 | 2179212 | 2022-02-03 | Carson City | Nevada | 32510 | 13808 | 189 |
2179213 | 2179213 | 2022-02-03 | Churchill | Nevada | 32001 | 5987 | 95 |
2179214 | 2179214 | 2022-02-03 | Clark | Nevada | 32003 | 497970 | 6993 |
2179215 | 2179215 | 2022-02-03 | Douglas | Nevada | 32005 | 7466 | 81 |
2179216 | 2179216 | 2022-02-03 | Elko | Nevada | 32007 | 11893 | 127 |
2179217 | 2179217 | 2022-02-03 | Esmeralda | Nevada | 32009 | 87 | 3 |
2179218 | 2179218 | 2022-02-03 | Eureka | Nevada | 32011 | 295 | 1 |
2179219 | 2179219 | 2022-02-03 | Humboldt | Nevada | 32013 | 4223 | 46 |
2179220 | 2179220 | 2022-02-03 | Lander | Nevada | 32015 | 1048 | 16 |
2179221 | 2179221 | 2022-02-03 | Lincoln | Nevada | 32017 | 929 | 5 |
2179222 | 2179222 | 2022-02-03 | Lyon | Nevada | 32019 | 10066 | 155 |
2179223 | 2179223 | 2022-02-03 | Mineral | Nevada | 32021 | 902 | 15 |
2179224 | 2179224 | 2022-02-03 | Nye | Nevada | 32023 | 6491 | 214 |
2179225 | 2179225 | 2022-02-03 | Pershing | Nevada | 32027 | 1368 | 29 |
2179226 | 2179226 | 2022-02-03 | Storey | Nevada | 32029 | 312 | 9 |
2179227 | 2179227 | 2022-02-03 | Washoe | Nevada | 32031 | 98428 | 1088 |
2179228 | 2179228 | 2022-02-03 | White Pine | Nevada | 32033 | 1834 | 18 |
2179229 | 2179229 | 2022-02-03 | Belknap | New Hampshire | 33001 | 12397 | 159 |
2179230 | 2179230 | 2022-02-03 | Carroll | New Hampshire | 33003 | 8472 | 50 |
2179231 | 2179231 | 2022-02-03 | Cheshire | New Hampshire | 33005 | 13027 | 92 |
2179232 | 2179232 | 2022-02-03 | Coos | New Hampshire | 33007 | 6267 | 93 |
2179233 | 2179233 | 2022-02-03 | Grafton | New Hampshire | 33009 | 15246 | 54 |
2179234 | 2179234 | 2022-02-03 | Hillsborough | New Hampshire | 33011 | 90820 | 838 |
2179235 | 2179235 | 2022-02-03 | Merrimack | New Hampshire | 33013 | 29460 | 202 |
2179236 | 2179236 | 2022-02-03 | Rockingham | New Hampshire | 33015 | 61978 | 473 |
2179237 | 2179237 | 2022-02-03 | Strafford | New Hampshire | 33017 | 25832 | 189 |
2179238 | 2179238 | 2022-02-03 | Sullivan | New Hampshire | 33019 | 8320 | 62 |
2179239 | 2179239 | 2022-02-03 | Unknown | New Hampshire | 8023 | 27 | |
2179240 | 2179240 | 2022-02-03 | Atlantic | New Jersey | 34001 | 66594 | 928 |
2179241 | 2179241 | 2022-02-03 | Bergen | New Jersey | 34003 | 214015 | 3325 |
2179242 | 2179242 | 2022-02-03 | Burlington | New Jersey | 34005 | 98068 | 1107 |
2179243 | 2179243 | 2022-02-03 | Camden | New Jersey | 34007 | 121581 | 1688 |
2179244 | 2179244 | 2022-02-03 | Cape May | New Jersey | 34009 | 21258 | 277 |
2179245 | 2179245 | 2022-02-03 | Cumberland | New Jersey | 34011 | 37137 | 562 |
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);