latest_ny_times_counties_with_populations (view)
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,131 rows sorted by population descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state >30
- Texas 254
- Georgia 159
- Virginia 133
- Kentucky 120
- Missouri 115
- Kansas 105
- Illinois 102
- North Carolina 100
- Iowa 99
- Tennessee 95
- Nebraska 93
- Indiana 92
- Ohio 88
- Minnesota 87
- Michigan 83
- Mississippi 82
- Oklahoma 77
- Arkansas 75
- Wisconsin 72
- Alabama 67
- Florida 67
- Pennsylvania 67
- South Dakota 65
- Colorado 64
- Louisiana 64
- California 58
- New York 57
- Montana 56
- West Virginia 55
- North Dakota 53
- …
date | county | state | fips | cases | deaths | population ▲ | deaths_per_million | cases_per_million |
---|---|---|---|---|---|---|---|---|
2022-05-13 | Los Angeles | California | 6037 | 2908425 | 32022 | 10039107 | 3189 | 289709 |
2022-05-13 | Cook | Illinois | 17031 | 1193914 | 14936 | 5150233 | 2900 | 231817 |
2022-05-13 | Harris | Texas | 48201 | 1032781 | 10972 | 4713325 | 2327 | 219119 |
2022-05-13 | Maricopa | Arizona | 4013 | 1283590 | 17326 | 4485414 | 3862 | 286169 |
2022-05-13 | San Diego | California | 6073 | 824586 | 5271 | 3338330 | 1578 | 247005 |
2022-05-13 | Orange | California | 6059 | 600384 | 7023 | 3175692 | 2211 | 189056 |
2022-05-13 | Miami-Dade | Florida | 12086 | 1209302 | 10921 | 2716940 | 4019 | 445097 |
2022-05-13 | Dallas | Texas | 48113 | 573644 | 6772 | 2635516 | 2569 | 217659 |
2022-05-13 | Riverside | California | 6065 | 626695 | 6527 | 2470546 | 2641 | 253666 |
2022-05-13 | Clark | Nevada | 32003 | 543811 | 8458 | 2266715 | 3731 | 239911 |
2022-05-13 | King | Washington | 53033 | 410322 | 2774 | 2252782 | 1231 | 182140 |
2022-05-13 | San Bernardino | California | 6071 | 597377 | 7423 | 2180085 | 3404 | 274015 |
2022-05-13 | Tarrant | Texas | 48439 | 569281 | 5925 | 2102515 | 2818 | 270761 |
2022-05-13 | Bexar | Texas | 48029 | 565111 | 6131 | 2003554 | 3060 | 282054 |
2022-05-13 | Broward | Florida | 12011 | 614436 | 5852 | 1952778 | 2996 | 314647 |
2022-05-13 | Santa Clara | California | 6085 | 342015 | 2298 | 1927852 | 1192 | 177407 |
2022-05-13 | Wayne | Michigan | 26163 | 416604 | 7975 | 1749343 | 4558 | 238148 |
2022-05-13 | Alameda | California | 6001 | 284054 | 1868 | 1671329 | 1117 | 169956 |
2022-05-13 | Middlesex | Massachusetts | 25017 | 352032 | 3998 | 1611699 | 2480 | 218422 |
2022-05-13 | Philadelphia | Pennsylvania | 42101 | 317808 | 5110 | 1584064 | 3225 | 200628 |
2022-05-13 | Sacramento | California | 6067 | 314407 | 3159 | 1552058 | 2035 | 202574 |
2022-05-13 | Palm Beach | Florida | 12099 | 375184 | 5059 | 1496770 | 3379 | 250662 |
2022-05-13 | Suffolk | New York | 36103 | 444799 | 4399 | 1476601 | 2979 | 301231 |
2022-05-13 | Hillsborough | Florida | 12057 | 379994 | 3793 | 1471968 | 2576 | 258153 |
2022-05-13 | Orange | Florida | 12095 | 383010 | 2835 | 1393452 | 2034 | 274864 |
2022-05-13 | Nassau | New York | 36059 | 425386 | 3853 | 1356924 | 2839 | 313492 |
2022-05-13 | Franklin | Ohio | 39049 | 296037 | 2610 | 1316756 | 1982 | 224822 |
2022-05-13 | Travis | Texas | 48453 | 227227 | 1735 | 1273954 | 1361 | 178363 |
2022-05-13 | Hennepin | Minnesota | 27053 | 312909 | 2593 | 1265843 | 2048 | 247194 |
2022-05-13 | Oakland | Michigan | 26125 | 300744 | 3851 | 1257584 | 3062 | 239144 |
2022-05-13 | Cuyahoga | Ohio | 39035 | 276160 | 3794 | 1235072 | 3071 | 223598 |
2022-05-13 | Allegheny | Pennsylvania | 42003 | 271427 | 3323 | 1216045 | 2732 | 223204 |
2022-05-13 | Salt Lake | Utah | 49035 | 346815 | 1637 | 1160437 | 1410 | 298865 |
2022-05-13 | Contra Costa | California | 6013 | 209958 | 1301 | 1153526 | 1127 | 182014 |
2022-05-13 | Fairfax | Virginia | 51059 | 188156 | 1453 | 1147532 | 1266 | 163965 |
2022-05-13 | Wake | North Carolina | 37183 | 300453 | 1119 | 1111761 | 1006 | 270249 |
2022-05-13 | Mecklenburg | North Carolina | 37119 | 284986 | 1621 | 1110356 | 1459 | 256661 |
2022-05-13 | Fulton | Georgia | 13121 | 222488 | 2343 | 1063937 | 2202 | 209117 |
2022-05-13 | Montgomery | Maryland | 24031 | 178052 | 2044 | 1050688 | 1945 | 169462 |
2022-05-13 | Pima | Arizona | 4019 | 255688 | 3850 | 1047279 | 3676 | 244145 |
2022-05-13 | Collin | Texas | 48085 | 215831 | 1507 | 1034730 | 1456 | 208586 |
2022-05-13 | Fresno | California | 6019 | 257611 | 2757 | 999101 | 2759 | 257842 |
2022-05-13 | St. Louis | Missouri | 29189 | 227453 | 3341 | 994205 | 3360 | 228778 |
2022-05-13 | Pinellas | Florida | 12103 | 212746 | 3356 | 974996 | 3442 | 218201 |
2022-05-13 | Honolulu | Hawaii | 15003 | 178469 | 1063 | 974563 | 1090 | 183127 |
2022-05-13 | Westchester | New York | 36119 | 264447 | 2720 | 967506 | 2811 | 273328 |
2022-05-13 | Marion | Indiana | 18097 | 227486 | 3000 | 964582 | 3110 | 235838 |
2022-05-13 | Duval | Florida | 12031 | 255189 | 3410 | 957755 | 3560 | 266444 |
2022-05-13 | Milwaukee | Wisconsin | 55079 | 277430 | 2292 | 945726 | 2423 | 293351 |
2022-05-13 | Fairfield | Connecticut | 9001 | 214106 | 2733 | 943332 | 2897 | 226967 |
2022-05-13 | Shelby | Tennessee | 47157 | 240841 | 3307 | 937166 | 3528 | 256988 |
2022-05-13 | Gwinnett | Georgia | 13135 | 210364 | 1886 | 936250 | 2014 | 224687 |
2022-05-13 | Bergen | New Jersey | 34003 | 239353 | 3458 | 932202 | 3709 | 256760 |
2022-05-13 | DuPage | Illinois | 17043 | 224631 | 1806 | 922921 | 1956 | 243391 |
2022-05-13 | Erie | New York | 36029 | 227059 | 2651 | 918702 | 2885 | 247151 |
2022-05-13 | Prince George's | Maryland | 24033 | 175401 | 2163 | 909327 | 2378 | 192891 |
2022-05-13 | Pierce | Washington | 53053 | 198375 | 1409 | 904980 | 1556 | 219203 |
2022-05-13 | Kern | California | 6029 | 244681 | 2427 | 900202 | 2696 | 271806 |
2022-05-13 | Hartford | Connecticut | 9003 | 187284 | 3157 | 891720 | 3540 | 210025 |
2022-05-13 | Denton | Texas | 48121 | 181158 | 1354 | 887207 | 1526 | 204189 |
2022-05-13 | San Francisco | California | 6075 | 143959 | 866 | 881549 | 982 | 163302 |
2022-05-13 | Macomb | Michigan | 26099 | 238947 | 3970 | 873972 | 4542 | 273403 |
2022-05-13 | Hidalgo | Texas | 48215 | 207289 | 3909 | 868707 | 4499 | 238617 |
2022-05-13 | New Haven | Connecticut | 9009 | 205522 | 2839 | 854757 | 3321 | 240444 |
2022-05-13 | Ventura | California | 6111 | 186062 | 1498 | 846006 | 1770 | 219929 |
2022-05-13 | El Paso | Texas | 48141 | 208635 | 3734 | 839238 | 4449 | 248600 |
2022-05-13 | Montgomery | Pennsylvania | 42091 | 158154 | 2329 | 830915 | 2802 | 190337 |
2022-05-13 | Worcester | Massachusetts | 25027 | 201669 | 2596 | 830622 | 3125 | 242792 |
2022-05-13 | Baltimore | Maryland | 24005 | 136295 | 2484 | 827370 | 3002 | 164732 |
2022-05-13 | Middlesex | New Jersey | 34023 | 204363 | 2877 | 825062 | 3487 | 247694 |
2022-05-13 | Snohomish | Washington | 53061 | 159246 | 1145 | 822083 | 1392 | 193710 |
2022-05-13 | Hamilton | Ohio | 39061 | 191030 | 2069 | 817473 | 2530 | 233683 |
2022-05-13 | Multnomah | Oregon | 41051 | 123906 | 1207 | 812855 | 1484 | 152433 |
2022-05-13 | Fort Bend | Texas | 48157 | 189442 | 1260 | 811688 | 1552 | 233392 |
2022-05-13 | Suffolk | Massachusetts | 25025 | 226017 | 2006 | 803907 | 2495 | 281148 |
2022-05-13 | Essex | New Jersey | 34013 | 222558 | 3614 | 798975 | 4523 | 278554 |
2022-05-13 | Oklahoma | Oklahoma | 40109 | 199990 | 2467 | 797434 | 3093 | 250791 |
2022-05-13 | Essex | Massachusetts | 25009 | 214332 | 2758 | 789034 | 3495 | 271638 |
2022-05-13 | Lee | Florida | 12071 | 191963 | 2158 | 770577 | 2800 | 249115 |
2022-05-13 | Jefferson | Kentucky | 21111 | 234899 | 2357 | 766757 | 3073 | 306353 |
2022-05-13 | San Mateo | California | 6081 | 137238 | 755 | 766573 | 984 | 179027 |
2022-05-13 | San Joaquin | California | 6077 | 178501 | 2236 | 762148 | 2933 | 234207 |
2022-05-13 | Cobb | Georgia | 13067 | 176832 | 1819 | 760141 | 2392 | 232630 |
2022-05-13 | DeKalb | Georgia | 13089 | 153194 | 1746 | 759297 | 2299 | 201757 |
2022-05-13 | Monroe | New York | 36055 | 163464 | 1587 | 741770 | 2139 | 220370 |
2022-05-13 | Denver | Colorado | 8031 | 177033 | 1360 | 727211 | 1870 | 243441 |
2022-05-13 | Polk | Florida | 12105 | 202456 | 2991 | 724777 | 4126 | 279335 |
2022-05-13 | El Paso | Colorado | 8041 | 190541 | 1695 | 720403 | 2352 | 264492 |
2022-05-13 | Norfolk | Massachusetts | 25021 | 141128 | 1901 | 706775 | 2689 | 199678 |
2022-05-13 | District of Columbia | District of Columbia | 11001 | 143943 | 1340 | 705749 | 1898 | 203957 |
2022-05-13 | Jackson | Missouri | 29095 | 97164 | 1217 | 703011 | 1731 | 138211 |
2022-05-13 | Lake | Illinois | 17097 | 159179 | 1466 | 696535 | 2104 | 228529 |
2022-05-13 | Davidson | Tennessee | 47037 | 210855 | 1676 | 694144 | 2414 | 303762 |
2022-05-13 | Will | Illinois | 17197 | 169447 | 1612 | 690743 | 2333 | 245311 |
2022-05-13 | Bernalillo | New Mexico | 35001 | 149543 | 1854 | 679121 | 2729 | 220200 |
2022-05-13 | Hudson | New Jersey | 34017 | 179135 | 2721 | 672391 | 4046 | 266414 |
2022-05-13 | Jefferson | Alabama | 1073 | 185930 | 2373 | 658573 | 3603 | 282322 |
2022-05-13 | Kent | Michigan | 26081 | 170251 | 1533 | 656955 | 2333 | 259151 |
2022-05-13 | Arapahoe | Colorado | 8005 | 158561 | 1284 | 656590 | 1955 | 241491 |
2022-05-13 | Tulsa | Oklahoma | 40143 | 172585 | 2183 | 651552 | 3350 | 264882 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW latest_ny_times_counties_with_populations AS select ny_times_us_counties.date, ny_times_us_counties.county, ny_times_us_counties.state, ny_times_us_counties.fips, ny_times_us_counties.cases, ny_times_us_counties.deaths, us_census_county_populations_2019.population, 1000000 * ny_times_us_counties.deaths / us_census_county_populations_2019.population as deaths_per_million, 1000000 * ny_times_us_counties.cases / us_census_county_populations_2019.population as cases_per_million from ny_times_us_counties join us_census_county_populations_2019 on ny_times_us_counties.fips = us_census_county_populations_2019.fips where "date" = ( select max(date) from ny_times_us_counties ) order by deaths_per_million desc;