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 181,068
- Georgia 116,889
- Virginia 96,610
- Kentucky 86,572
- Missouri 83,750
- Illinois 74,352
- Kansas 74,008
- North Carolina 72,809
- Iowa 72,070
- Tennessee 69,972
- Indiana 67,286
- Ohio 64,651
- Nebraska 64,555
- Minnesota 63,483
- Michigan 61,002
- Mississippi 60,004
- Oklahoma 56,023
- Arkansas 55,232
- Puerto Rico 54,447
- Wisconsin 52,465
- Florida 49,962
- Pennsylvania 49,091
- Alabama 48,962
- Louisiana 47,652
- Colorado 46,327
- South Dakota 46,252
- California 42,793
- New York 42,792
- West Virginia 39,543
- Montana 37,856
- North Dakota 37,799
- South Carolina 33,791
- Idaho 30,984
- Washington 28,972
- Oregon 25,983
- New Mexico 23,750
- Utah 21,449
- Alaska 19,168
- Maryland 18,395
- Wyoming 16,688
- New Jersey 16,317
- Maine 12,247
- Nevada 11,967
- Arizona 11,184
- Massachusetts 11,164
- Vermont 11,023
- New Hampshire 8,062
- Connecticut 6,641
- Rhode Island 4,404
- Hawaii 3,682
- Delaware 2,931
- Virgin Islands 2,341
- Northern Mariana Islands 1,636
- District of Columbia 748
- Guam 740
- American Samoa 189
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2342633 | 2342633 | 2022-03-25 | Jackson | Tennessee | 47087 | 3202 | 62 |
2342634 | 2342634 | 2022-03-25 | Jefferson | Tennessee | 47089 | 15692 | 259 |
2342635 | 2342635 | 2022-03-25 | Johnson | Tennessee | 47091 | 5139 | 88 |
2342636 | 2342636 | 2022-03-25 | Knox | Tennessee | 47093 | 127542 | 1335 |
2342637 | 2342637 | 2022-03-25 | Lake | Tennessee | 47095 | 2737 | 40 |
2342638 | 2342638 | 2022-03-25 | Lauderdale | Tennessee | 47097 | 7733 | 103 |
2342639 | 2342639 | 2022-03-25 | Lawrence | Tennessee | 47099 | 14258 | 191 |
2342640 | 2342640 | 2022-03-25 | Lewis | Tennessee | 47101 | 3568 | 57 |
2342641 | 2342641 | 2022-03-25 | Lincoln | Tennessee | 47103 | 9973 | 166 |
2342642 | 2342642 | 2022-03-25 | Loudon | Tennessee | 47105 | 14424 | 188 |
2342643 | 2342643 | 2022-03-25 | Macon | Tennessee | 47111 | 8422 | 145 |
2342644 | 2342644 | 2022-03-25 | Madison | Tennessee | 47113 | 29784 | 418 |
2342645 | 2342645 | 2022-03-25 | Marion | Tennessee | 47115 | 8833 | 127 |
2342646 | 2342646 | 2022-03-25 | Marshall | Tennessee | 47117 | 10351 | 119 |
2342647 | 2342647 | 2022-03-25 | Maury | Tennessee | 47119 | 28867 | 330 |
2342648 | 2342648 | 2022-03-25 | McMinn | Tennessee | 47107 | 16652 | 251 |
2342649 | 2342649 | 2022-03-25 | McNairy | Tennessee | 47109 | 7629 | 118 |
2342650 | 2342650 | 2022-03-25 | Meigs | Tennessee | 47121 | 3351 | 55 |
2342651 | 2342651 | 2022-03-25 | Monroe | Tennessee | 47123 | 14482 | 235 |
2342652 | 2342652 | 2022-03-25 | Montgomery | Tennessee | 47125 | 50080 | 561 |
2342653 | 2342653 | 2022-03-25 | Moore | Tennessee | 47127 | 2237 | 40 |
2342654 | 2342654 | 2022-03-25 | Morgan | Tennessee | 47129 | 6158 | 80 |
2342655 | 2342655 | 2022-03-25 | Obion | Tennessee | 47131 | 10753 | 187 |
2342656 | 2342656 | 2022-03-25 | Overton | Tennessee | 47133 | 7147 | 121 |
2342657 | 2342657 | 2022-03-25 | Perry | Tennessee | 47135 | 2328 | 55 |
2342658 | 2342658 | 2022-03-25 | Pickett | Tennessee | 47137 | 1764 | 36 |
2342659 | 2342659 | 2022-03-25 | Polk | Tennessee | 47139 | 4722 | 70 |
2342660 | 2342660 | 2022-03-25 | Putnam | Tennessee | 47141 | 25068 | 302 |
2342661 | 2342661 | 2022-03-25 | Rhea | Tennessee | 47143 | 9959 | 154 |
2342662 | 2342662 | 2022-03-25 | Roane | Tennessee | 47145 | 15764 | 231 |
2342663 | 2342663 | 2022-03-25 | Robertson | Tennessee | 47147 | 21503 | 295 |
2342664 | 2342664 | 2022-03-25 | Rutherford | Tennessee | 47149 | 95505 | 879 |
2342665 | 2342665 | 2022-03-25 | Scott | Tennessee | 47151 | 9029 | 115 |
2342666 | 2342666 | 2022-03-25 | Sequatchie | Tennessee | 47153 | 4204 | 66 |
2342667 | 2342667 | 2022-03-25 | Sevier | Tennessee | 47155 | 30246 | 401 |
2342668 | 2342668 | 2022-03-25 | Shelby | Tennessee | 47157 | 237514 | 3232 |
2342669 | 2342669 | 2022-03-25 | Smith | Tennessee | 47159 | 6157 | 83 |
2342670 | 2342670 | 2022-03-25 | Stewart | Tennessee | 47161 | 3283 | 56 |
2342671 | 2342671 | 2022-03-25 | Sullivan | Tennessee | 47163 | 45676 | 698 |
2342672 | 2342672 | 2022-03-25 | Sumner | Tennessee | 47165 | 53057 | 713 |
2342673 | 2342673 | 2022-03-25 | Tipton | Tennessee | 47167 | 17588 | 230 |
2342674 | 2342674 | 2022-03-25 | Trousdale | Tennessee | 47169 | 4209 | 45 |
2342675 | 2342675 | 2022-03-25 | Unicoi | Tennessee | 47171 | 5156 | 94 |
2342676 | 2342676 | 2022-03-25 | Union | Tennessee | 47173 | 5393 | 72 |
2342677 | 2342677 | 2022-03-25 | Unknown | Tennessee | 18929 | 306 | |
2342678 | 2342678 | 2022-03-25 | Van Buren | Tennessee | 47175 | 1845 | 47 |
2342679 | 2342679 | 2022-03-25 | Warren | Tennessee | 47177 | 12982 | 175 |
2342680 | 2342680 | 2022-03-25 | Washington | Tennessee | 47179 | 38465 | 486 |
2342681 | 2342681 | 2022-03-25 | Wayne | Tennessee | 47181 | 5687 | 63 |
2342682 | 2342682 | 2022-03-25 | Weakley | Tennessee | 47183 | 9491 | 140 |
2342683 | 2342683 | 2022-03-25 | White | Tennessee | 47185 | 8224 | 127 |
2342684 | 2342684 | 2022-03-25 | Williamson | Tennessee | 47187 | 61839 | 395 |
2342685 | 2342685 | 2022-03-25 | Wilson | Tennessee | 47189 | 41556 | 475 |
2342686 | 2342686 | 2022-03-25 | Anderson | Texas | 48001 | 9525 | 234 |
2342687 | 2342687 | 2022-03-25 | Andrews | Texas | 48003 | 3790 | 71 |
2342688 | 2342688 | 2022-03-25 | Angelina | Texas | 48005 | 15297 | 480 |
2342689 | 2342689 | 2022-03-25 | Aransas | Texas | 48007 | 4085 | 81 |
2342690 | 2342690 | 2022-03-25 | Archer | Texas | 48009 | 2122 | 28 |
2342691 | 2342691 | 2022-03-25 | Armstrong | Texas | 48011 | 517 | 9 |
2342692 | 2342692 | 2022-03-25 | Atascosa | Texas | 48013 | 13476 | 231 |
2342693 | 2342693 | 2022-03-25 | Austin | Texas | 48015 | 5684 | 73 |
2342694 | 2342694 | 2022-03-25 | Bailey | Texas | 48017 | 1451 | 39 |
2342695 | 2342695 | 2022-03-25 | Bandera | Texas | 48019 | 3582 | 75 |
2342696 | 2342696 | 2022-03-25 | Bastrop | Texas | 48021 | 21671 | 232 |
2342697 | 2342697 | 2022-03-25 | Baylor | Texas | 48023 | 809 | 32 |
2342698 | 2342698 | 2022-03-25 | Bee | Texas | 48025 | 8265 | 152 |
2342699 | 2342699 | 2022-03-25 | Bell | Texas | 48027 | 66759 | 883 |
2342700 | 2342700 | 2022-03-25 | Bexar | Texas | 48029 | 552514 | 6066 |
2342701 | 2342701 | 2022-03-25 | Blanco | Texas | 48031 | 2524 | 34 |
2342702 | 2342702 | 2022-03-25 | Borden | Texas | 48033 | 98 | 2 |
2342703 | 2342703 | 2022-03-25 | Bosque | Texas | 48035 | 4052 | 70 |
2342704 | 2342704 | 2022-03-25 | Bowie | Texas | 48037 | 20046 | 428 |
2342705 | 2342705 | 2022-03-25 | Brazoria | Texas | 48039 | 93177 | 978 |
2342706 | 2342706 | 2022-03-25 | Brazos | Texas | 48041 | 60151 | 405 |
2342707 | 2342707 | 2022-03-25 | Brewster | Texas | 48043 | 1056 | 29 |
2342708 | 2342708 | 2022-03-25 | Briscoe | Texas | 48045 | 455 | 8 |
2342709 | 2342709 | 2022-03-25 | Brooks | Texas | 48047 | 1610 | 51 |
2342710 | 2342710 | 2022-03-25 | Brown | Texas | 48049 | 11394 | 251 |
2342711 | 2342711 | 2022-03-25 | Burleson | Texas | 48051 | 5001 | 66 |
2342712 | 2342712 | 2022-03-25 | Burnet | Texas | 48053 | 10803 | 166 |
2342713 | 2342713 | 2022-03-25 | Caldwell | Texas | 48055 | 14138 | 175 |
2342714 | 2342714 | 2022-03-25 | Calhoun | Texas | 48057 | 5689 | 48 |
2342715 | 2342715 | 2022-03-25 | Callahan | Texas | 48059 | 2816 | 72 |
2342716 | 2342716 | 2022-03-25 | Cameron | Texas | 48061 | 100912 | 2029 |
2342717 | 2342717 | 2022-03-25 | Camp | Texas | 48063 | 2833 | 74 |
2342718 | 2342718 | 2022-03-25 | Carson | Texas | 48065 | 1520 | 34 |
2342719 | 2342719 | 2022-03-25 | Cass | Texas | 48067 | 7198 | 194 |
2342720 | 2342720 | 2022-03-25 | Castro | Texas | 48069 | 2279 | 47 |
2342721 | 2342721 | 2022-03-25 | Chambers | Texas | 48071 | 11672 | 112 |
2342722 | 2342722 | 2022-03-25 | Cherokee | Texas | 48073 | 7935 | 253 |
2342723 | 2342723 | 2022-03-25 | Childress | Texas | 48075 | 2624 | 31 |
2342724 | 2342724 | 2022-03-25 | Clay | Texas | 48077 | 2054 | 34 |
2342725 | 2342725 | 2022-03-25 | Cochran | Texas | 48079 | 878 | 23 |
2342726 | 2342726 | 2022-03-25 | Coke | Texas | 48081 | 838 | 19 |
2342727 | 2342727 | 2022-03-25 | Coleman | Texas | 48083 | 1622 | 69 |
2342728 | 2342728 | 2022-03-25 | Collin | Texas | 48085 | 208569 | 1484 |
2342729 | 2342729 | 2022-03-25 | Collingsworth | Texas | 48087 | 701 | 16 |
2342730 | 2342730 | 2022-03-25 | Colorado | Texas | 48089 | 3779 | 62 |
2342731 | 2342731 | 2022-03-25 | Comal | Texas | 48091 | 33461 | 545 |
2342732 | 2342732 | 2022-03-25 | Comanche | Texas | 48093 | 3393 | 78 |
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);