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 139,392
- Georgia 90,649
- Virginia 74,793
- Kentucky 67,012
- Missouri 64,679
- Illinois 57,563
- Kansas 56,893
- North Carolina 56,509
- Iowa 55,770
- Tennessee 54,271
- Indiana 52,290
- Ohio 50,144
- Nebraska 49,233
- Minnesota 49,139
- Michigan 47,310
- Mississippi 46,624
- Oklahoma 43,309
- Arkansas 42,768
- Puerto Rico 41,570
- Wisconsin 40,657
- Florida 38,810
- Pennsylvania 38,170
- Alabama 37,974
- Louisiana 37,057
- Colorado 35,831
- South Dakota 35,494
- New York 33,338
- California 33,280
- West Virginia 30,523
- North Dakota 28,997
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1807420 | 1807420 | 2021-10-12 | Hawaii | Hawaii | 15001 | 10498 | 105 |
1807421 | 1807421 | 2021-10-12 | Honolulu | Hawaii | 15003 | 56553 | 635 |
1807422 | 1807422 | 2021-10-12 | Kalawao | Hawaii | 15005 | 1 | 0 |
1807423 | 1807423 | 2021-10-12 | Kauai | Hawaii | 15007 | 2431 | 8 |
1807424 | 1807424 | 2021-10-12 | Maui | Hawaii | 15009 | 9659 | 92 |
1807425 | 1807425 | 2021-10-12 | Unknown | Hawaii | 0 | 2 | |
1807426 | 1807426 | 2021-10-12 | Ada | Idaho | 16001 | 75566 | 698 |
1807427 | 1807427 | 2021-10-12 | Adams | Idaho | 16003 | 483 | 8 |
1807428 | 1807428 | 2021-10-12 | Bannock | Idaho | 16005 | 12493 | 166 |
1807429 | 1807429 | 2021-10-12 | Bear Lake | Idaho | 16007 | 629 | 12 |
1807430 | 1807430 | 2021-10-12 | Benewah | Idaho | 16009 | 1093 | 18 |
1807431 | 1807431 | 2021-10-12 | Bingham | Idaho | 16011 | 6368 | 103 |
1807432 | 1807432 | 2021-10-12 | Blaine | Idaho | 16013 | 2878 | 22 |
1807433 | 1807433 | 2021-10-12 | Boise | Idaho | 16015 | 689 | 8 |
1807434 | 1807434 | 2021-10-12 | Bonner | Idaho | 16017 | 4916 | 80 |
1807435 | 1807435 | 2021-10-12 | Bonneville | Idaho | 16019 | 18739 | 203 |
1807436 | 1807436 | 2021-10-12 | Boundary | Idaho | 16021 | 1288 | 23 |
1807437 | 1807437 | 2021-10-12 | Butte | Idaho | 16023 | 317 | 3 |
1807438 | 1807438 | 2021-10-12 | Camas | Idaho | 16025 | 106 | 1 |
1807439 | 1807439 | 2021-10-12 | Canyon | Idaho | 16027 | 38851 | 459 |
1807440 | 1807440 | 2021-10-12 | Caribou | Idaho | 16029 | 948 | 15 |
1807441 | 1807441 | 2021-10-12 | Cassia | Idaho | 16031 | 3654 | 34 |
1807442 | 1807442 | 2021-10-12 | Clark | Idaho | 16033 | 77 | 0 |
1807443 | 1807443 | 2021-10-12 | Clearwater | Idaho | 16035 | 1578 | 25 |
1807444 | 1807444 | 2021-10-12 | Custer | Idaho | 16037 | 352 | 5 |
1807445 | 1807445 | 2021-10-12 | Elmore | Idaho | 16039 | 3788 | 39 |
1807446 | 1807446 | 2021-10-12 | Franklin | Idaho | 16041 | 1521 | 21 |
1807447 | 1807447 | 2021-10-12 | Fremont | Idaho | 16043 | 1446 | 15 |
1807448 | 1807448 | 2021-10-12 | Gem | Idaho | 16045 | 2606 | 54 |
1807449 | 1807449 | 2021-10-12 | Gooding | Idaho | 16047 | 2170 | 37 |
1807450 | 1807450 | 2021-10-12 | Idaho | Idaho | 16049 | 2008 | 30 |
1807451 | 1807451 | 2021-10-12 | Jefferson | Idaho | 16051 | 3812 | 40 |
1807452 | 1807452 | 2021-10-12 | Jerome | Idaho | 16053 | 4095 | 42 |
1807453 | 1807453 | 2021-10-12 | Kootenai | Idaho | 16055 | 26247 | 344 |
1807454 | 1807454 | 2021-10-12 | Latah | Idaho | 16057 | 4304 | 28 |
1807455 | 1807455 | 2021-10-12 | Lemhi | Idaho | 16059 | 761 | 16 |
1807456 | 1807456 | 2021-10-12 | Lewis | Idaho | 16061 | 718 | 18 |
1807457 | 1807457 | 2021-10-12 | Lincoln | Idaho | 16063 | 648 | 12 |
1807458 | 1807458 | 2021-10-12 | Madison | Idaho | 16065 | 8337 | 36 |
1807459 | 1807459 | 2021-10-12 | Minidoka | Idaho | 16067 | 2998 | 40 |
1807460 | 1807460 | 2021-10-12 | Nez Perce | Idaho | 16069 | 5897 | 92 |
1807461 | 1807461 | 2021-10-12 | Oneida | Idaho | 16071 | 506 | 6 |
1807462 | 1807462 | 2021-10-12 | Owyhee | Idaho | 16073 | 1513 | 38 |
1807463 | 1807463 | 2021-10-12 | Payette | Idaho | 16075 | 3751 | 56 |
1807464 | 1807464 | 2021-10-12 | Power | Idaho | 16077 | 962 | 12 |
1807465 | 1807465 | 2021-10-12 | Shoshone | Idaho | 16079 | 1796 | 56 |
1807466 | 1807466 | 2021-10-12 | Teton | Idaho | 16081 | 1565 | 5 |
1807467 | 1807467 | 2021-10-12 | Twin Falls | Idaho | 16083 | 15098 | 197 |
1807468 | 1807468 | 2021-10-12 | Valley | Idaho | 16085 | 1378 | 10 |
1807469 | 1807469 | 2021-10-12 | Washington | Idaho | 16087 | 1753 | 41 |
1807470 | 1807470 | 2021-10-12 | Adams | Illinois | 17001 | 13028 | 181 |
1807471 | 1807471 | 2021-10-12 | Alexander | Illinois | 17003 | 703 | 11 |
1807472 | 1807472 | 2021-10-12 | Bond | Illinois | 17005 | 2527 | 30 |
1807473 | 1807473 | 2021-10-12 | Boone | Illinois | 17007 | 7828 | 95 |
1807474 | 1807474 | 2021-10-12 | Brown | Illinois | 17009 | 1057 | 15 |
1807475 | 1807475 | 2021-10-12 | Bureau | Illinois | 17011 | 4384 | 102 |
1807476 | 1807476 | 2021-10-12 | Calhoun | Illinois | 17013 | 677 | 5 |
1807477 | 1807477 | 2021-10-12 | Carroll | Illinois | 17015 | 2340 | 39 |
1807478 | 1807478 | 2021-10-12 | Cass | Illinois | 17017 | 2633 | 38 |
1807479 | 1807479 | 2021-10-12 | Champaign | Illinois | 17019 | 26734 | 201 |
1807480 | 1807480 | 2021-10-12 | Christian | Illinois | 17021 | 5175 | 100 |
1807481 | 1807481 | 2021-10-12 | Clark | Illinois | 17023 | 2635 | 47 |
1807482 | 1807482 | 2021-10-12 | Clay | Illinois | 17025 | 2549 | 56 |
1807483 | 1807483 | 2021-10-12 | Clinton | Illinois | 17027 | 7036 | 111 |
1807484 | 1807484 | 2021-10-12 | Coles | Illinois | 17029 | 7785 | 122 |
1807485 | 1807485 | 2021-10-12 | Cook | Illinois | 17031 | 628979 | 11682 |
1807486 | 1807486 | 2021-10-12 | Crawford | Illinois | 17033 | 3270 | 46 |
1807487 | 1807487 | 2021-10-12 | Cumberland | Illinois | 17035 | 1878 | 38 |
1807488 | 1807488 | 2021-10-12 | De Witt | Illinois | 17039 | 2036 | 37 |
1807489 | 1807489 | 2021-10-12 | DeKalb | Illinois | 17037 | 12253 | 138 |
1807490 | 1807490 | 2021-10-12 | Douglas | Illinois | 17041 | 3208 | 43 |
1807491 | 1807491 | 2021-10-12 | DuPage | Illinois | 17043 | 106932 | 1459 |
1807492 | 1807492 | 2021-10-12 | Edgar | Illinois | 17045 | 2523 | 69 |
1807493 | 1807493 | 2021-10-12 | Edwards | Illinois | 17047 | 1018 | 18 |
1807494 | 1807494 | 2021-10-12 | Effingham | Illinois | 17049 | 6510 | 108 |
1807495 | 1807495 | 2021-10-12 | Fayette | Illinois | 17051 | 4261 | 64 |
1807496 | 1807496 | 2021-10-12 | Ford | Illinois | 17053 | 2413 | 66 |
1807497 | 1807497 | 2021-10-12 | Franklin | Illinois | 17055 | 7249 | 123 |
1807498 | 1807498 | 2021-10-12 | Fulton | Illinois | 17057 | 5165 | 81 |
1807499 | 1807499 | 2021-10-12 | Gallatin | Illinois | 17059 | 784 | 8 |
1807500 | 1807500 | 2021-10-12 | Greene | Illinois | 17061 | 2036 | 53 |
1807501 | 1807501 | 2021-10-12 | Grundy | Illinois | 17063 | 7279 | 88 |
1807502 | 1807502 | 2021-10-12 | Hamilton | Illinois | 17065 | 1326 | 25 |
1807503 | 1807503 | 2021-10-12 | Hancock | Illinois | 17067 | 2712 | 45 |
1807504 | 1807504 | 2021-10-12 | Hardin | Illinois | 17069 | 585 | 16 |
1807505 | 1807505 | 2021-10-12 | Henderson | Illinois | 17071 | 692 | 23 |
1807506 | 1807506 | 2021-10-12 | Henry | Illinois | 17073 | 6538 | 105 |
1807507 | 1807507 | 2021-10-12 | Iroquois | Illinois | 17075 | 4159 | 78 |
1807508 | 1807508 | 2021-10-12 | Jackson | Illinois | 17077 | 8035 | 104 |
1807509 | 1807509 | 2021-10-12 | Jasper | Illinois | 17079 | 1595 | 23 |
1807510 | 1807510 | 2021-10-12 | Jefferson | Illinois | 17081 | 6427 | 140 |
1807511 | 1807511 | 2021-10-12 | Jersey | Illinois | 17083 | 3332 | 72 |
1807512 | 1807512 | 2021-10-12 | Jo Daviess | Illinois | 17085 | 2136 | 31 |
1807513 | 1807513 | 2021-10-12 | Johnson | Illinois | 17087 | 2231 | 37 |
1807514 | 1807514 | 2021-10-12 | Kane | Illinois | 17089 | 67675 | 918 |
1807515 | 1807515 | 2021-10-12 | Kankakee | Illinois | 17091 | 17707 | 252 |
1807516 | 1807516 | 2021-10-12 | Kendall | Illinois | 17093 | 16770 | 120 |
1807517 | 1807517 | 2021-10-12 | Knox | Illinois | 17095 | 7130 | 200 |
1807518 | 1807518 | 2021-10-12 | LaSalle | Illinois | 17099 | 14894 | 338 |
1807519 | 1807519 | 2021-10-12 | Lake | Illinois | 17097 | 79242 | 1144 |
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);