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
- Georgia 1,633
- Texas 1,613
- California 1,243
- Virginia 1,133
- Mississippi 1,031
- New York 1,028
- North Carolina 1,028
- Tennessee 1,016
- Indiana 983
- Ohio 969
- Florida 963
- Michigan 884
- Pennsylvania 858
- Louisiana 803
- Washington 797
- Missouri 751
- Colorado 746
- Illinois 727
- Minnesota 719
- Wisconsin 716
- Kentucky 715
- Alabama 670
- South Carolina 668
- Arkansas 653
- Iowa 625
- Oklahoma 566
- New Jersey 477
- Oregon 467
- Kansas 443
- Maryland 382
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
29365 | 29365 | 2020-04-03 | Plymouth | Massachusetts | 25023 | 745 | 7 |
29366 | 29366 | 2020-04-03 | Suffolk | Massachusetts | 25025 | 2183 | 23 |
29367 | 29367 | 2020-04-03 | Unknown | Massachusetts | 213 | 0 | |
29368 | 29368 | 2020-04-03 | Worcester | Massachusetts | 25027 | 825 | 15 |
29369 | 29369 | 2020-04-03 | Allegan | Michigan | 26005 | 6 | 0 |
29370 | 29370 | 2020-04-03 | Antrim | Michigan | 26009 | 4 | 0 |
29371 | 29371 | 2020-04-03 | Arenac | Michigan | 26011 | 2 | 0 |
29372 | 29372 | 2020-04-03 | Barry | Michigan | 26015 | 5 | 0 |
29373 | 29373 | 2020-04-03 | Bay | Michigan | 26017 | 18 | 0 |
29374 | 29374 | 2020-04-03 | Berrien | Michigan | 26021 | 52 | 1 |
29375 | 29375 | 2020-04-03 | Branch | Michigan | 26023 | 6 | 0 |
29376 | 29376 | 2020-04-03 | Calhoun | Michigan | 26025 | 31 | 1 |
29377 | 29377 | 2020-04-03 | Cass | Michigan | 26027 | 6 | 1 |
29378 | 29378 | 2020-04-03 | Charlevoix | Michigan | 26029 | 5 | 0 |
29379 | 29379 | 2020-04-03 | Cheboygan | Michigan | 26031 | 6 | 0 |
29380 | 29380 | 2020-04-03 | Chippewa | Michigan | 26033 | 1 | 0 |
29381 | 29381 | 2020-04-03 | Clare | Michigan | 26035 | 2 | 0 |
29382 | 29382 | 2020-04-03 | Clinton | Michigan | 26037 | 49 | 1 |
29383 | 29383 | 2020-04-03 | Crawford | Michigan | 26039 | 1 | 0 |
29384 | 29384 | 2020-04-03 | Delta | Michigan | 26041 | 5 | 0 |
29385 | 29385 | 2020-04-03 | Dickinson | Michigan | 26043 | 1 | 1 |
29386 | 29386 | 2020-04-03 | Eaton | Michigan | 26045 | 47 | 2 |
29387 | 29387 | 2020-04-03 | Emmet | Michigan | 26047 | 6 | 2 |
29388 | 29388 | 2020-04-03 | Genesee | Michigan | 26049 | 422 | 11 |
29389 | 29389 | 2020-04-03 | Gladwin | Michigan | 26051 | 2 | 0 |
29390 | 29390 | 2020-04-03 | Gogebic | Michigan | 26053 | 3 | 1 |
29391 | 29391 | 2020-04-03 | Grand Traverse | Michigan | 26055 | 11 | 2 |
29392 | 29392 | 2020-04-03 | Gratiot | Michigan | 26057 | 5 | 0 |
29393 | 29393 | 2020-04-03 | Hillsdale | Michigan | 26059 | 26 | 2 |
29394 | 29394 | 2020-04-03 | Houghton | Michigan | 26061 | 1 | 0 |
29395 | 29395 | 2020-04-03 | Huron | Michigan | 26063 | 4 | 0 |
29396 | 29396 | 2020-04-03 | Ingham | Michigan | 26065 | 152 | 1 |
29397 | 29397 | 2020-04-03 | Ionia | Michigan | 26067 | 6 | 0 |
29398 | 29398 | 2020-04-03 | Iosco | Michigan | 26069 | 1 | 0 |
29399 | 29399 | 2020-04-03 | Isabella | Michigan | 26073 | 9 | 2 |
29400 | 29400 | 2020-04-03 | Jackson | Michigan | 26075 | 69 | 3 |
29401 | 29401 | 2020-04-03 | Kalamazoo | Michigan | 26077 | 40 | 1 |
29402 | 29402 | 2020-04-03 | Kalkaska | Michigan | 26079 | 8 | 1 |
29403 | 29403 | 2020-04-03 | Kent | Michigan | 26081 | 136 | 2 |
29404 | 29404 | 2020-04-03 | Lapeer | Michigan | 26087 | 22 | 0 |
29405 | 29405 | 2020-04-03 | Leelanau | Michigan | 26089 | 1 | 0 |
29406 | 29406 | 2020-04-03 | Lenawee | Michigan | 26091 | 24 | 0 |
29407 | 29407 | 2020-04-03 | Livingston | Michigan | 26093 | 121 | 2 |
29408 | 29408 | 2020-04-03 | Luce | Michigan | 26095 | 1 | 0 |
29409 | 29409 | 2020-04-03 | Mackinac | Michigan | 26097 | 2 | 0 |
29410 | 29410 | 2020-04-03 | Macomb | Michigan | 26099 | 1560 | 65 |
29411 | 29411 | 2020-04-03 | Manistee | Michigan | 26101 | 1 | 0 |
29412 | 29412 | 2020-04-03 | Marquette | Michigan | 26103 | 7 | 0 |
29413 | 29413 | 2020-04-03 | Mecosta | Michigan | 26107 | 4 | 1 |
29414 | 29414 | 2020-04-03 | Midland | Michigan | 26111 | 16 | 0 |
29415 | 29415 | 2020-04-03 | Missaukee | Michigan | 26113 | 1 | 1 |
29416 | 29416 | 2020-04-03 | Monroe | Michigan | 26115 | 95 | 0 |
29417 | 29417 | 2020-04-03 | Montcalm | Michigan | 26117 | 12 | 0 |
29418 | 29418 | 2020-04-03 | Muskegon | Michigan | 26121 | 30 | 2 |
29419 | 29419 | 2020-04-03 | Newaygo | Michigan | 26123 | 2 | 0 |
29420 | 29420 | 2020-04-03 | Oakland | Michigan | 26125 | 2540 | 136 |
29421 | 29421 | 2020-04-03 | Oceana | Michigan | 26127 | 3 | 0 |
29422 | 29422 | 2020-04-03 | Ogemaw | Michigan | 26129 | 2 | 0 |
29423 | 29423 | 2020-04-03 | Osceola | Michigan | 26133 | 3 | 0 |
29424 | 29424 | 2020-04-03 | Oscoda | Michigan | 26135 | 2 | 0 |
29425 | 29425 | 2020-04-03 | Otsego | Michigan | 26137 | 20 | 0 |
29426 | 29426 | 2020-04-03 | Ottawa | Michigan | 26139 | 37 | 0 |
29427 | 29427 | 2020-04-03 | Roscommon | Michigan | 26143 | 2 | 0 |
29428 | 29428 | 2020-04-03 | Saginaw | Michigan | 26145 | 90 | 0 |
29429 | 29429 | 2020-04-03 | Sanilac | Michigan | 26151 | 10 | 1 |
29430 | 29430 | 2020-04-03 | Shiawassee | Michigan | 26155 | 18 | 0 |
29431 | 29431 | 2020-04-03 | St. Clair | Michigan | 26147 | 66 | 0 |
29432 | 29432 | 2020-04-03 | St. Joseph | Michigan | 26149 | 10 | 0 |
29433 | 29433 | 2020-04-03 | Tuscola | Michigan | 26157 | 15 | 2 |
29434 | 29434 | 2020-04-03 | Unknown | Michigan | 215 | 1 | |
29435 | 29435 | 2020-04-03 | Van Buren | Michigan | 26159 | 12 | 1 |
29436 | 29436 | 2020-04-03 | Washtenaw | Michigan | 26161 | 477 | 8 |
29437 | 29437 | 2020-04-03 | Wayne | Michigan | 26163 | 6096 | 223 |
29438 | 29438 | 2020-04-03 | Wexford | Michigan | 26165 | 4 | 0 |
29439 | 29439 | 2020-04-03 | Anoka | Minnesota | 27003 | 34 | 0 |
29440 | 29440 | 2020-04-03 | Beltrami | Minnesota | 27007 | 4 | 0 |
29441 | 29441 | 2020-04-03 | Benton | Minnesota | 27009 | 1 | 0 |
29442 | 29442 | 2020-04-03 | Big Stone | Minnesota | 27011 | 1 | 0 |
29443 | 29443 | 2020-04-03 | Blue Earth | Minnesota | 27013 | 10 | 0 |
29444 | 29444 | 2020-04-03 | Brown | Minnesota | 27015 | 2 | 0 |
29445 | 29445 | 2020-04-03 | Carlton | Minnesota | 27017 | 5 | 0 |
29446 | 29446 | 2020-04-03 | Carver | Minnesota | 27019 | 11 | 0 |
29447 | 29447 | 2020-04-03 | Cass | Minnesota | 27021 | 1 | 0 |
29448 | 29448 | 2020-04-03 | Chisago | Minnesota | 27025 | 4 | 1 |
29449 | 29449 | 2020-04-03 | Clay | Minnesota | 27027 | 8 | 0 |
29450 | 29450 | 2020-04-03 | Clearwater | Minnesota | 27029 | 2 | 0 |
29451 | 29451 | 2020-04-03 | Cottonwood | Minnesota | 27033 | 5 | 0 |
29452 | 29452 | 2020-04-03 | Crow Wing | Minnesota | 27035 | 3 | 0 |
29453 | 29453 | 2020-04-03 | Dakota | Minnesota | 27037 | 54 | 1 |
29454 | 29454 | 2020-04-03 | Dodge | Minnesota | 27039 | 10 | 0 |
29455 | 29455 | 2020-04-03 | Douglas | Minnesota | 27041 | 1 | 0 |
29456 | 29456 | 2020-04-03 | Faribault | Minnesota | 27043 | 3 | 0 |
29457 | 29457 | 2020-04-03 | Fillmore | Minnesota | 27045 | 9 | 0 |
29458 | 29458 | 2020-04-03 | Freeborn | Minnesota | 27047 | 7 | 0 |
29459 | 29459 | 2020-04-03 | Goodhue | Minnesota | 27049 | 5 | 0 |
29460 | 29460 | 2020-04-03 | Hennepin | Minnesota | 27053 | 242 | 9 |
29461 | 29461 | 2020-04-03 | Isanti | Minnesota | 27059 | 2 | 0 |
29462 | 29462 | 2020-04-03 | Itasca | Minnesota | 27061 | 2 | 0 |
29463 | 29463 | 2020-04-03 | Jackson | Minnesota | 27063 | 1 | 0 |
29464 | 29464 | 2020-04-03 | Kandiyohi | Minnesota | 27067 | 2 | 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);