ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,502,832 rows sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: date
state >30
- Texas 193,519
- Georgia 124,889
- Virginia 103,128
- Kentucky 92,572
- Missouri 89,600
- Illinois 79,502
- Kansas 79,294
- North Carolina 77,809
- Iowa 77,070
- Tennessee 74,719
- Indiana 71,921
- Nebraska 69,255
- Ohio 69,101
- Minnesota 67,883
- Michigan 65,202
- Mississippi 64,147
- Oklahoma 59,923
- Arkansas 59,032
- Puerto Rico 58,397
- Wisconsin 55,993
- Florida 53,362
- Pennsylvania 52,441
- Alabama 52,312
- Louisiana 50,902
- South Dakota 49,552
- Colorado 49,527
- California 45,693
- New York 45,692
- West Virginia 42,238
- Montana 40,656
- …
fips >30
county >30
- Washington 24,215
- Unknown 21,401
- Jefferson 20,291
- Franklin 19,457
- Jackson 18,567
- Lincoln 18,529
- Madison 15,570
- Montgomery 14,081
- Union 13,972
- Clay 13,908
- Marion 13,212
- Monroe 13,177
- Wayne 12,212
- Grant 11,402
- Greene 10,908
- Warren 10,902
- Carroll 10,132
- Johnson 9,366
- Douglas 9,352
- Polk 9,348
- Lee 9,322
- Clark 9,259
- Lake 9,229
- Marshall 9,222
- Adams 9,212
- Fayette 8,612
- Morgan 8,549
- Crawford 8,543
- Lawrence 8,522
- Scott 8,478
- …
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1620 | 1620 | 2020-03-13 | Elmore | Alabama | 1051 | 1 | 0 |
1621 | 1621 | 2020-03-13 | Jefferson | Alabama | 1073 | 2 | 0 |
1622 | 1622 | 2020-03-13 | Limestone | Alabama | 1083 | 1 | 0 |
1623 | 1623 | 2020-03-13 | Montgomery | Alabama | 1101 | 1 | 0 |
1624 | 1624 | 2020-03-13 | Tuscaloosa | Alabama | 1125 | 1 | 0 |
1935 | 1935 | 2020-03-14 | Baldwin | Alabama | 1003 | 1 | 0 |
1936 | 1936 | 2020-03-14 | Elmore | Alabama | 1051 | 1 | 0 |
1937 | 1937 | 2020-03-14 | Jefferson | Alabama | 1073 | 6 | 0 |
1938 | 1938 | 2020-03-14 | Limestone | Alabama | 1083 | 1 | 0 |
1939 | 1939 | 2020-03-14 | Montgomery | Alabama | 1101 | 1 | 0 |
1940 | 1940 | 2020-03-14 | Tuscaloosa | Alabama | 1125 | 2 | 0 |
2310 | 2310 | 2020-03-15 | Baldwin | Alabama | 1003 | 1 | 0 |
2311 | 2311 | 2020-03-15 | Elmore | Alabama | 1051 | 1 | 0 |
2312 | 2312 | 2020-03-15 | Jefferson | Alabama | 1073 | 13 | 0 |
2313 | 2313 | 2020-03-15 | Lee | Alabama | 1081 | 1 | 0 |
2314 | 2314 | 2020-03-15 | Limestone | Alabama | 1083 | 1 | 0 |
2315 | 2315 | 2020-03-15 | Montgomery | Alabama | 1101 | 1 | 0 |
2316 | 2316 | 2020-03-15 | Shelby | Alabama | 1117 | 2 | 0 |
2317 | 2317 | 2020-03-15 | Tuscaloosa | Alabama | 1125 | 3 | 0 |
2739 | 2739 | 2020-03-16 | Baldwin | Alabama | 1003 | 1 | 0 |
2740 | 2740 | 2020-03-16 | Elmore | Alabama | 1051 | 1 | 0 |
2741 | 2741 | 2020-03-16 | Jefferson | Alabama | 1073 | 17 | 0 |
2742 | 2742 | 2020-03-16 | Lee | Alabama | 1081 | 1 | 0 |
2743 | 2743 | 2020-03-16 | Limestone | Alabama | 1083 | 1 | 0 |
2744 | 2744 | 2020-03-16 | Montgomery | Alabama | 1101 | 2 | 0 |
2745 | 2745 | 2020-03-16 | Shelby | Alabama | 1117 | 3 | 0 |
2746 | 2746 | 2020-03-16 | Tuscaloosa | Alabama | 1125 | 3 | 0 |
3215 | 3215 | 2020-03-17 | Baldwin | Alabama | 1003 | 1 | 0 |
3216 | 3216 | 2020-03-17 | Elmore | Alabama | 1051 | 2 | 0 |
3217 | 3217 | 2020-03-17 | Jefferson | Alabama | 1073 | 21 | 0 |
3218 | 3218 | 2020-03-17 | Lee | Alabama | 1081 | 3 | 0 |
3219 | 3219 | 2020-03-17 | Limestone | Alabama | 1083 | 1 | 0 |
3220 | 3220 | 2020-03-17 | Madison | Alabama | 1089 | 1 | 0 |
3221 | 3221 | 2020-03-17 | Montgomery | Alabama | 1101 | 2 | 0 |
3222 | 3222 | 2020-03-17 | Shelby | Alabama | 1117 | 4 | 0 |
3223 | 3223 | 2020-03-17 | St. Clair | Alabama | 1115 | 1 | 0 |
3224 | 3224 | 2020-03-17 | Tuscaloosa | Alabama | 1125 | 3 | 0 |
3761 | 3761 | 2020-03-18 | Baldwin | Alabama | 1003 | 1 | 0 |
3762 | 3762 | 2020-03-18 | Calhoun | Alabama | 1015 | 1 | 0 |
3763 | 3763 | 2020-03-18 | Elmore | Alabama | 1051 | 4 | 0 |
3764 | 3764 | 2020-03-18 | Jefferson | Alabama | 1073 | 25 | 0 |
3765 | 3765 | 2020-03-18 | Lee | Alabama | 1081 | 7 | 0 |
3766 | 3766 | 2020-03-18 | Limestone | Alabama | 1083 | 1 | 0 |
3767 | 3767 | 2020-03-18 | Madison | Alabama | 1089 | 1 | 0 |
3768 | 3768 | 2020-03-18 | Montgomery | Alabama | 1101 | 2 | 0 |
3769 | 3769 | 2020-03-18 | Shelby | Alabama | 1117 | 4 | 0 |
3770 | 3770 | 2020-03-18 | St. Clair | Alabama | 1115 | 1 | 0 |
3771 | 3771 | 2020-03-18 | Talladega | Alabama | 1121 | 1 | 0 |
3772 | 3772 | 2020-03-18 | Tuscaloosa | Alabama | 1125 | 3 | 0 |
4401 | 4401 | 2020-03-19 | Baldwin | Alabama | 1003 | 1 | 0 |
4402 | 4402 | 2020-03-19 | Calhoun | Alabama | 1015 | 1 | 0 |
4403 | 4403 | 2020-03-19 | Chambers | Alabama | 1017 | 1 | 0 |
4404 | 4404 | 2020-03-19 | Elmore | Alabama | 1051 | 5 | 0 |
4405 | 4405 | 2020-03-19 | Jefferson | Alabama | 1073 | 34 | 0 |
4406 | 4406 | 2020-03-19 | Lee | Alabama | 1081 | 10 | 0 |
4407 | 4407 | 2020-03-19 | Limestone | Alabama | 1083 | 1 | 0 |
4408 | 4408 | 2020-03-19 | Madison | Alabama | 1089 | 5 | 0 |
4409 | 4409 | 2020-03-19 | Mobile | Alabama | 1097 | 1 | 0 |
4410 | 4410 | 2020-03-19 | Montgomery | Alabama | 1101 | 3 | 0 |
4411 | 4411 | 2020-03-19 | Shelby | Alabama | 1117 | 9 | 0 |
4412 | 4412 | 2020-03-19 | St. Clair | Alabama | 1115 | 1 | 0 |
4413 | 4413 | 2020-03-19 | Talladega | Alabama | 1121 | 1 | 0 |
4414 | 4414 | 2020-03-19 | Tuscaloosa | Alabama | 1125 | 4 | 0 |
4415 | 4415 | 2020-03-19 | Walker | Alabama | 1127 | 1 | 0 |
5167 | 5167 | 2020-03-20 | Baldwin | Alabama | 1003 | 2 | 0 |
5168 | 5168 | 2020-03-20 | Calhoun | Alabama | 1015 | 1 | 0 |
5169 | 5169 | 2020-03-20 | Chambers | Alabama | 1017 | 1 | 0 |
5170 | 5170 | 2020-03-20 | Cullman | Alabama | 1043 | 1 | 0 |
5171 | 5171 | 2020-03-20 | Elmore | Alabama | 1051 | 6 | 0 |
5172 | 5172 | 2020-03-20 | Jackson | Alabama | 1071 | 1 | 0 |
5173 | 5173 | 2020-03-20 | Jefferson | Alabama | 1073 | 50 | 0 |
5174 | 5174 | 2020-03-20 | Lamar | Alabama | 1075 | 1 | 0 |
5175 | 5175 | 2020-03-20 | Lauderdale | Alabama | 1077 | 1 | 0 |
5176 | 5176 | 2020-03-20 | Lee | Alabama | 1081 | 11 | 0 |
5177 | 5177 | 2020-03-20 | Limestone | Alabama | 1083 | 1 | 0 |
5178 | 5178 | 2020-03-20 | Madison | Alabama | 1089 | 7 | 0 |
5179 | 5179 | 2020-03-20 | Mobile | Alabama | 1097 | 2 | 0 |
5180 | 5180 | 2020-03-20 | Montgomery | Alabama | 1101 | 3 | 0 |
5181 | 5181 | 2020-03-20 | Shelby | Alabama | 1117 | 10 | 0 |
5182 | 5182 | 2020-03-20 | St. Clair | Alabama | 1115 | 1 | 0 |
5183 | 5183 | 2020-03-20 | Talladega | Alabama | 1121 | 1 | 0 |
5184 | 5184 | 2020-03-20 | Tuscaloosa | Alabama | 1125 | 4 | 0 |
5185 | 5185 | 2020-03-20 | Walker | Alabama | 1127 | 1 | 0 |
5186 | 5186 | 2020-03-20 | Washington | Alabama | 1129 | 1 | 0 |
6083 | 6083 | 2020-03-21 | Baldwin | Alabama | 1003 | 2 | 0 |
6084 | 6084 | 2020-03-21 | Calhoun | Alabama | 1015 | 1 | 0 |
6085 | 6085 | 2020-03-21 | Chambers | Alabama | 1017 | 1 | 0 |
6086 | 6086 | 2020-03-21 | Cullman | Alabama | 1043 | 2 | 0 |
6087 | 6087 | 2020-03-21 | Elmore | Alabama | 1051 | 6 | 0 |
6088 | 6088 | 2020-03-21 | Jackson | Alabama | 1071 | 1 | 0 |
6089 | 6089 | 2020-03-21 | Jefferson | Alabama | 1073 | 61 | 0 |
6090 | 6090 | 2020-03-21 | Lamar | Alabama | 1075 | 1 | 0 |
6091 | 6091 | 2020-03-21 | Lauderdale | Alabama | 1077 | 2 | 0 |
6092 | 6092 | 2020-03-21 | Lee | Alabama | 1081 | 12 | 0 |
6093 | 6093 | 2020-03-21 | Limestone | Alabama | 1083 | 1 | 0 |
6094 | 6094 | 2020-03-21 | Madison | Alabama | 1089 | 9 | 0 |
6095 | 6095 | 2020-03-21 | Marion | Alabama | 1093 | 1 | 0 |
6096 | 6096 | 2020-03-21 | Mobile | Alabama | 1097 | 2 | 0 |
6097 | 6097 | 2020-03-21 | Montgomery | Alabama | 1101 | 3 | 0 |
6098 | 6098 | 2020-03-21 | Shelby | Alabama | 1117 | 16 | 0 |
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);