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 deaths 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 | Maricopa | Arizona | 4013 | 1283590 | 17326 | 4485414 | 3862 | 286169 |
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 | Miami-Dade | Florida | 12086 | 1209302 | 10921 | 2716940 | 4019 | 445097 |
2022-05-13 | Clark | Nevada | 32003 | 543811 | 8458 | 2266715 | 3731 | 239911 |
2022-05-13 | Wayne | Michigan | 26163 | 416604 | 7975 | 1749343 | 4558 | 238148 |
2022-05-13 | San Bernardino | California | 6071 | 597377 | 7423 | 2180085 | 3404 | 274015 |
2022-05-13 | Orange | California | 6059 | 600384 | 7023 | 3175692 | 2211 | 189056 |
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 | Bexar | Texas | 48029 | 565111 | 6131 | 2003554 | 3060 | 282054 |
2022-05-13 | Tarrant | Texas | 48439 | 569281 | 5925 | 2102515 | 2818 | 270761 |
2022-05-13 | Broward | Florida | 12011 | 614436 | 5852 | 1952778 | 2996 | 314647 |
2022-05-13 | San Diego | California | 6073 | 824586 | 5271 | 3338330 | 1578 | 247005 |
2022-05-13 | Philadelphia | Pennsylvania | 42101 | 317808 | 5110 | 1584064 | 3225 | 200628 |
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 | Middlesex | Massachusetts | 25017 | 352032 | 3998 | 1611699 | 2480 | 218422 |
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 | Nassau | New York | 36059 | 425386 | 3853 | 1356924 | 2839 | 313492 |
2022-05-13 | Oakland | Michigan | 26125 | 300744 | 3851 | 1257584 | 3062 | 239144 |
2022-05-13 | Pima | Arizona | 4019 | 255688 | 3850 | 1047279 | 3676 | 244145 |
2022-05-13 | Cuyahoga | Ohio | 39035 | 276160 | 3794 | 1235072 | 3071 | 223598 |
2022-05-13 | Hillsborough | Florida | 12057 | 379994 | 3793 | 1471968 | 2576 | 258153 |
2022-05-13 | El Paso | Texas | 48141 | 208635 | 3734 | 839238 | 4449 | 248600 |
2022-05-13 | Essex | New Jersey | 34013 | 222558 | 3614 | 798975 | 4523 | 278554 |
2022-05-13 | Bergen | New Jersey | 34003 | 239353 | 3458 | 932202 | 3709 | 256760 |
2022-05-13 | Duval | Florida | 12031 | 255189 | 3410 | 957755 | 3560 | 266444 |
2022-05-13 | Pinellas | Florida | 12103 | 212746 | 3356 | 974996 | 3442 | 218201 |
2022-05-13 | St. Louis | Missouri | 29189 | 227453 | 3341 | 994205 | 3360 | 228778 |
2022-05-13 | Allegheny | Pennsylvania | 42003 | 271427 | 3323 | 1216045 | 2732 | 223204 |
2022-05-13 | Shelby | Tennessee | 47157 | 240841 | 3307 | 937166 | 3528 | 256988 |
2022-05-13 | Sacramento | California | 6067 | 314407 | 3159 | 1552058 | 2035 | 202574 |
2022-05-13 | Hartford | Connecticut | 9003 | 187284 | 3157 | 891720 | 3540 | 210025 |
2022-05-13 | Marion | Indiana | 18097 | 227486 | 3000 | 964582 | 3110 | 235838 |
2022-05-13 | Polk | Florida | 12105 | 202456 | 2991 | 724777 | 4126 | 279335 |
2022-05-13 | Ocean | New Jersey | 34029 | 168238 | 2975 | 607186 | 4899 | 277078 |
2022-05-13 | Middlesex | New Jersey | 34023 | 204363 | 2877 | 825062 | 3487 | 247694 |
2022-05-13 | New Haven | Connecticut | 9009 | 205522 | 2839 | 854757 | 3321 | 240444 |
2022-05-13 | Orange | Florida | 12095 | 383010 | 2835 | 1393452 | 2034 | 274864 |
2022-05-13 | King | Washington | 53033 | 410322 | 2774 | 2252782 | 1231 | 182140 |
2022-05-13 | Essex | Massachusetts | 25009 | 214332 | 2758 | 789034 | 3495 | 271638 |
2022-05-13 | Fresno | California | 6019 | 257611 | 2757 | 999101 | 2759 | 257842 |
2022-05-13 | Fairfield | Connecticut | 9001 | 214106 | 2733 | 943332 | 2897 | 226967 |
2022-05-13 | Hudson | New Jersey | 34017 | 179135 | 2721 | 672391 | 4046 | 266414 |
2022-05-13 | Westchester | New York | 36119 | 264447 | 2720 | 967506 | 2811 | 273328 |
2022-05-13 | Erie | New York | 36029 | 227059 | 2651 | 918702 | 2885 | 247151 |
2022-05-13 | Franklin | Ohio | 39049 | 296037 | 2610 | 1316756 | 1982 | 224822 |
2022-05-13 | Worcester | Massachusetts | 25027 | 201669 | 2596 | 830622 | 3125 | 242792 |
2022-05-13 | Hennepin | Minnesota | 27053 | 312909 | 2593 | 1265843 | 2048 | 247194 |
2022-05-13 | Providence | Rhode Island | 44007 | 229262 | 2535 | 638931 | 3967 | 358821 |
2022-05-13 | Baltimore | Maryland | 24005 | 136295 | 2484 | 827370 | 3002 | 164732 |
2022-05-13 | Oklahoma | Oklahoma | 40109 | 199990 | 2467 | 797434 | 3093 | 250791 |
2022-05-13 | Kern | California | 6029 | 244681 | 2427 | 900202 | 2696 | 271806 |
2022-05-13 | Jefferson | Alabama | 1073 | 185930 | 2373 | 658573 | 3603 | 282322 |
2022-05-13 | Jefferson | Kentucky | 21111 | 234899 | 2357 | 766757 | 3073 | 306353 |
2022-05-13 | Union | New Jersey | 34039 | 151057 | 2355 | 556341 | 4233 | 271518 |
2022-05-13 | Fulton | Georgia | 13121 | 222488 | 2343 | 1063937 | 2202 | 209117 |
2022-05-13 | Passaic | New Jersey | 34031 | 149761 | 2337 | 501826 | 4656 | 298432 |
2022-05-13 | Montgomery | Pennsylvania | 42091 | 158154 | 2329 | 830915 | 2802 | 190337 |
2022-05-13 | Santa Clara | California | 6085 | 342015 | 2298 | 1927852 | 1192 | 177407 |
2022-05-13 | Milwaukee | Wisconsin | 55079 | 277430 | 2292 | 945726 | 2423 | 293351 |
2022-05-13 | San Joaquin | California | 6077 | 178501 | 2236 | 762148 | 2933 | 234207 |
2022-05-13 | Tulsa | Oklahoma | 40143 | 172585 | 2183 | 651552 | 3350 | 264882 |
2022-05-13 | Monmouth | New Jersey | 34025 | 172251 | 2180 | 618795 | 3522 | 278365 |
2022-05-13 | Bristol | Massachusetts | 25005 | 154820 | 2163 | 565217 | 3826 | 273912 |
2022-05-13 | Prince George's | Maryland | 24033 | 175401 | 2163 | 909327 | 2378 | 192891 |
2022-05-13 | Lee | Florida | 12071 | 191963 | 2158 | 770577 | 2800 | 249115 |
2022-05-13 | Marion | Florida | 12083 | 84120 | 2105 | 365579 | 5757 | 230100 |
2022-05-13 | Brevard | Florida | 12009 | 135740 | 2100 | 601942 | 3488 | 225503 |
2022-05-13 | Hamilton | Ohio | 39061 | 191030 | 2069 | 817473 | 2530 | 233683 |
2022-05-13 | Montgomery | Maryland | 24031 | 178052 | 2044 | 1050688 | 1945 | 169462 |
2022-05-13 | Cameron | Texas | 48061 | 105092 | 2032 | 423163 | 4801 | 248348 |
2022-05-13 | Montgomery | Ohio | 39113 | 128090 | 2019 | 531687 | 3797 | 240912 |
2022-05-13 | Greenville | South Carolina | 45045 | 173338 | 2008 | 523542 | 3835 | 331087 |
2022-05-13 | Suffolk | Massachusetts | 25025 | 226017 | 2006 | 803907 | 2495 | 281148 |
2022-05-13 | Volusia | Florida | 12127 | 118119 | 1988 | 553284 | 3593 | 213487 |
2022-05-13 | Bucks | Pennsylvania | 42017 | 126504 | 1905 | 628270 | 3032 | 201352 |
2022-05-13 | Norfolk | Massachusetts | 25021 | 141128 | 1901 | 706775 | 2689 | 199678 |
2022-05-13 | Pasco | Florida | 12101 | 123993 | 1900 | 553947 | 3429 | 223835 |
2022-05-13 | Lancaster | Pennsylvania | 42071 | 122794 | 1890 | 545724 | 3463 | 225011 |
2022-05-13 | Gwinnett | Georgia | 13135 | 210364 | 1886 | 936250 | 2014 | 224687 |
2022-05-13 | Delaware | Pennsylvania | 42045 | 113339 | 1875 | 566747 | 3308 | 199981 |
2022-05-13 | Alameda | California | 6001 | 284054 | 1868 | 1671329 | 1117 | 169956 |
2022-05-13 | Bernalillo | New Mexico | 35001 | 149543 | 1854 | 679121 | 2729 | 220200 |
2022-05-13 | Lake | Indiana | 18089 | 108660 | 1834 | 485493 | 3777 | 223813 |
2022-05-13 | Cobb | Georgia | 13067 | 176832 | 1819 | 760141 | 2392 | 232630 |
2022-05-13 | Camden | New Jersey | 34007 | 130289 | 1807 | 506471 | 3567 | 257248 |
2022-05-13 | DuPage | Illinois | 17043 | 224631 | 1806 | 922921 | 1956 | 243391 |
2022-05-13 | Hampden | Massachusetts | 25013 | 139047 | 1804 | 466372 | 3868 | 298146 |
2022-05-13 | Baltimore city | Maryland | 24510 | 116724 | 1777 | 593490 | 2994 | 196673 |
2022-05-13 | DeKalb | Georgia | 13089 | 153194 | 1746 | 759297 | 2299 | 201757 |
2022-05-13 | Travis | Texas | 48453 | 227227 | 1735 | 1273954 | 1361 | 178363 |
2022-05-13 | Genesee | Michigan | 26049 | 103601 | 1720 | 405813 | 4238 | 255292 |
2022-05-13 | Stark | Ohio | 39151 | 80794 | 1718 | 370606 | 4635 | 218005 |
2022-05-13 | Summit | Ohio | 39153 | 115094 | 1710 | 541013 | 3160 | 212737 |
2022-05-13 | El Paso | Colorado | 8041 | 190541 | 1695 | 720403 | 2352 | 264492 |
2022-05-13 | Stanislaus | California | 6099 | 136645 | 1694 | 550660 | 3076 | 248147 |
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;