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 county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
deaths 774 ✖
- 16 28
- 12 27
- 20 26
- 61 26
- 8 25
- 28 25
- 9 24
- 29 24
- 49 23
- 52 23
- 35 22
- 36 22
- 46 22
- 7 21
- 11 21
- 14 21
- 18 21
- 24 21
- 54 21
- 3 20
- 44 20
- 48 20
- 62 20
- 13 19
- 58 19
- 70 19
- 21 18
- 31 18
- 33 18
- 39 18
- 0 17
- 2 17
- 17 17
- 23 17
- 25 17
- 30 17
- 50 17
- 59 17
- 68 17
- 73 17
- 74 17
- 75 17
- 6 16
- 10 16
- 15 16
- 32 16
- 37 16
- 43 16
- 47 16
- 57 16
- 69 16
- 93 16
- 1 15
- 26 15
- 27 15
- 34 15
- 41 15
- 60 15
- 71 15
- 85 15
- 86 15
- 87 15
- 102 15
- 19 14
- 22 14
- 38 14
- 53 14
- 78 14
- 106 14
- 122 14
- 4 13
- 42 13
- 55 13
- 56 13
- 65 13
- 66 13
- 72 13
- 104 13
- 110 13
- 160 13
- 5 12
- 40 12
- 79 12
- 101 12
- 108 12
- 109 12
- 121 12
- 124 12
- 130 12
- 145 12
- 45 11
- 51 11
- 64 11
- 80 11
- 90 11
- 96 11
- 97 11
- 98 11
- 144 11
- 148 11
- 157 11
- 107 10
- 113 10
- 120 10
- 125 10
- 134 10
- 139 10
- 63 9
- 67 9
- 77 9
- 92 9
- 94 9
- 105 9
- 127 9
- 132 9
- 140 9
- 149 9
- 169 9
- 76 8
- 84 8
- 88 8
- 103 8
- 116 8
- 128 8
- 129 8
- 138 8
- 153 8
- 154 8
- 159 8
- 176 8
- 178 8
- 82 7
- 83 7
- 89 7
- 99 7
- 111 7
- 117 7
- 119 7
- 123 7
- 131 7
- 135 7
- 142 7
- 146 7
- 152 7
- 164 7
- 171 7
- 186 7
- 187 7
- 91 6
- 95 6
- 100 6
- 115 6
- 118 6
- 136 6
- 137 6
- 141 6
- 150 6
- 180 6
- 188 6
- 210 6
- 222 6
- 246 6
- 81 5
- 112 5
- 114 5
- 126 5
- 143 5
- 163 5
- 167 5
- 170 5
- 175 5
- 179 5
- 193 5
- 199 5
- 205 5
- 207 5
- 239 5
- 261 5
- 263 5
- 293 5
- 295 5
- 305 5
- 147 4
- 162 4
- 168 4
- 174 4
- 177 4
- 181 4
- 182 4
- 183 4
- 184 4
- 189 4
- 191 4
- 192 4
- 203 4
- 206 4
- 208 4
- 211 4
- 212 4
- 215 4
- 231 4
- 232 4
- 238 4
- 241 4
- 243 4
- 249 4
- 275 4
- 277 4
- 280 4
- 281 4
- 282 4
- 286 4
- 294 4
- 301 4
- 316 4
- 339 4
- 151 3
- 158 3
- 161 3
- 166 3
- 173 3
- 185 3
- 198 3
- 201 3
- 202 3
- 216 3
- 217 3
- 218 3
- 226 3
- 230 3
- 233 3
- 234 3
- 236 3
- 240 3
- 244 3
- 245 3
- 247 3
- 253 3
- 256 3
- 259 3
- 264 3
- 266 3
- 267 3
- 268 3
- 276 3
- 296 3
- 302 3
- 315 3
- 321 3
- 322 3
- 330 3
- 338 3
- 341 3
- 342 3
- 343 3
- 348 3
- 367 3
- 373 3
- 394 3
- 396 3
- 404 3
- 415 3
- 424 3
- 427 3
- 447 3
- 450 3
- 478 3
- 481 3
- 496 3
- 498 3
- 500 3
- 968 3
- 155 2
- 156 2
- 165 2
- 190 2
- 195 2
- 196 2
- 197 2
- 204 2
- 214 2
- 220 2
- 221 2
- 224 2
- 227 2
- 228 2
- 235 2
- 237 2
- 250 2
- 251 2
- 252 2
- 254 2
- 258 2
- 260 2
- 262 2
- 265 2
- 270 2
- 273 2
- 287 2
- 291 2
- 303 2
- 304 2
- 309 2
- 319 2
- 327 2
- 328 2
- 329 2
- 331 2
- 347 2
- 353 2
- 354 2
- 355 2
- 363 2
- 365 2
- 366 2
- 372 2
- 376 2
- 378 2
- 390 2
- 395 2
- 397 2
- 401 2
- 402 2
- 405 2
- 406 2
- 413 2
- 416 2
- 432 2
- 434 2
- 439 2
- 440 2
- 444 2
- 451 2
- 452 2
- 460 2
- 463 2
- 466 2
- 475 2
- 476 2
- 490 2
- 491 2
- 494 2
- 505 2
- 508 2
- 513 2
- 516 2
- 518 2
- 520 2
- 522 2
- 523 2
- 526 2
- 551 2
- 554 2
- 582 2
- 584 2
- 586 2
- 594 2
- 616 2
- 630 2
- 631 2
- 632 2
- 650 2
- 653 2
- 654 2
- 665 2
- 675 2
- 688 2
- 703 2
- 721 2
- 755 2
- 760 2
- 776 2
- 791 2
- 823 2
- 824 2
- 866 2
- 916 2
- 1119 2
- 1378 2
- 1424 2
- 2163 2
- 133 1
- 172 1
- 194 1
- 209 1
- 219 1
- 223 1
- 225 1
- 242 1
- 255 1
- 257 1
- 269 1
- 272 1
- 274 1
- 278 1
- 284 1
- 285 1
- 288 1
- 290 1
- 292 1
- 297 1
- 299 1
- 307 1
- 308 1
- 311 1
- 313 1
- 317 1
- 318 1
- 320 1
- 324 1
- 332 1
- 333 1
- 334 1
- 335 1
- 336 1
- 337 1
- 340 1
- 344 1
- 345 1
- 346 1
- 349 1
- 350 1
- 351 1
- 356 1
- 358 1
- 359 1
- 362 1
- 364 1
- 368 1
- 374 1
- 375 1
- 377 1
- 379 1
- 380 1
- 381 1
- 382 1
- 383 1
- 387 1
- 389 1
- 391 1
- 392 1
- 398 1
- 400 1
- 408 1
- 409 1
- 414 1
- 417 1
- 418 1
- 419 1
- 420 1
- 421 1
- 430 1
- 431 1
- 433 1
- 436 1
- 437 1
- 442 1
- 443 1
- 449 1
- 457 1
- 461 1
- 469 1
- 472 1
- 480 1
- 483 1
- 484 1
- 486 1
- 488 1
- 489 1
- 497 1
- 506 1
- 507 1
- 510 1
- 511 1
- 515 1
- 519 1
- 524 1
- 525 1
- 533 1
- 534 1
- 535 1
- 536 1
- 538 1
- 541 1
- 542 1
- 553 1
- 555 1
- 557 1
- 560 1
- 561 1
- 564 1
- 565 1
- 567 1
- 573 1
- 575 1
- 576 1
- 577 1
- 579 1
- 581 1
- 583 1
- 585 1
- 588 1
- 589 1
- 590 1
- 593 1
- 599 1
- 600 1
- 605 1
- 609 1
- 614 1
- 615 1
- 620 1
- 621 1
- 627 1
- 628 1
- 633 1
- 636 1
- 640 1
- 648 1
- 651 1
- 659 1
- 661 1
- 662 1
- 663 1
- 674 1
- 678 1
- 679 1
- 681 1
- 685 1
- 686 1
- 687 1
- 690 1
- 693 1
- 695 1
- 706 1
- 724 1
- 725 1
- 729 1
- 732 1
- 734 1
- 735 1
- 737 1
- 739 1
- 743 1
- 744 1
- 745 1
- 748 1
- 754 1
- 769 1
- 773 1
- 775 1
- 780 1
- 785 1
- 786 1
- 788 1
- 790 1
- 797 1
- 802 1
- 803 1
- 804 1
- 812 1
- 822 1
- 827 1
- 835 1
- 843 1
- 844 1
- 849 1
- 850 1
- 851 1
- 853 1
- 855 1
- 856 1
- 857 1
- 872 1
- 874 1
- 886 1
- 892 1
- 895 1
- 897 1
- 901 1
- 902 1
- 904 1
- 909 1
- 934 1
- 935 1
- 938 1
- 941 1
- 945 1
- 947 1
- 948 1
- 954 1
- 956 1
- 964 1
- 975 1
- 976 1
- 977 1
- 981 1
- 983 1
- 997 1
- 998 1
- 1000 1
- 1022 1
- 1036 1
- 1040 1
- 1063 1
- 1073 1
- 1078 1
- 1089 1
- 1093 1
- 1095 1
- 1096 1
- 1097 1
- 1105 1
- 1109 1
- 1145 1
- 1147 1
- 1151 1
- 1156 1
- 1157 1
- 1159 1
- 1164 1
- 1179 1
- 1181 1
- 1186 1
- 1188 1
- 1202 1
- 1207 1
- 1208 1
- 1210 1
- 1212 1
- 1217 1
- 1219 1
- 1221 1
- 1246 1
- 1260 1
- 1261 1
- 1284 1
- 1291 1
- 1301 1
- 1311 1
- 1329 1
- 1340 1
- 1341 1
- 1348 1
- 1349 1
- 1354 1
- 1356 1
- 1360 1
- 1366 1
- 1380 1
- 1385 1
- 1409 1
- 1420 1
- 1434 1
- 1453 1
- 1454 1
- 1466 1
- 1469 1
- 1494 1
- 1498 1
- 1501 1
- 1502 1
- 1507 1
- 1533 1
- 1548 1
- 1550 1
- 1587 1
- 1595 1
- 1612 1
- 1620 1
- 1621 1
- 1637 1
- 1653 1
- 1666 1
- 1676 1
- 1685 1
- 1694 1
- 1695 1
- 1710 1
- 1718 1
- 1720 1
- 1735 1
- 1746 1
- 1777 1
- 1804 1
- 1806 1
- 1807 1
- 1819 1
- 1834 1
- 1854 1
- 1868 1
- 1875 1
- 1886 1
- 1890 1
- 1900 1
- 1901 1
- 1905 1
- 1988 1
- 2006 1
- 2008 1
- 2019 1
- 2032 1
- 2044 1
- 2069 1
- 2100 1
- 2105 1
- 2158 1
- 2180 1
- 2183 1
- 2236 1
- 2292 1
- 2298 1
- 2329 1
- 2337 1
- 2343 1
- 2355 1
- 2357 1
- 2373 1
- 2427 1
- 2467 1
- 2484 1
- 2535 1
- 2593 1
- 2596 1
- 2610 1
- 2651 1
- 2720 1
- 2721 1
- 2733 1
- 2757 1
- 2758 1
- 2774 1
- 2835 1
- 2839 1
- 2877 1
- 2975 1
- 2991 1
- 3000 1
- 3157 1
- 3159 1
- 3307 1
- 3323 1
- 3341 1
- 3356 1
- 3410 1
- 3458 1
- 3614 1
- 3734 1
- 3793 1
- 3794 1
- 3850 1
- 3851 1
- 3853 1
- 3909 1
- 3970 1
- 3998 1
- 4399 1
- 5059 1
- 5110 1
- 5271 1
- 5852 1
- 5925 1
- 6131 1
- 6527 1
- 6772 1
- 7023 1
- 7423 1
- 7975 1
- 8458 1
- 10921 1
- 10972 1
- 14936 1
- 17326 1
- 32022 1
state 51
- 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
- South Carolina 46
- Idaho 44
- Washington 39
- Oregon 36
- New Mexico 33
- Utah 29
- Alaska 24
- Maryland 24
- Wyoming 23
- New Jersey 21
- Nevada 17
- Maine 16
- Arizona 15
- Massachusetts 14
- Vermont 14
- New Hampshire 10
- Connecticut 8
- Hawaii 5
- Rhode Island 5
- Delaware 3
- District of Columbia 1
date | county ▼ | state | fips | cases | deaths | population | deaths_per_million | cases_per_million |
---|---|---|---|---|---|---|---|---|
2022-05-13 | Abbeville | South Carolina | 45001 | 6655 | 69 | 24527 | 2813 | 271333 |
2022-05-13 | Acadia | Louisiana | 22001 | 15906 | 294 | 62045 | 4738 | 256362 |
2022-05-13 | Accomack | Virginia | 51001 | 7054 | 106 | 32316 | 3280 | 218281 |
2022-05-13 | Ada | Idaho | 16001 | 135259 | 1022 | 481587 | 2122 | 280860 |
2022-05-13 | Adair | Iowa | 19001 | 1588 | 50 | 7152 | 6991 | 222035 |
2022-05-13 | Adair | Kentucky | 21001 | 5929 | 107 | 19202 | 5572 | 308769 |
2022-05-13 | Adair | Oklahoma | 40001 | 8001 | 75 | 22194 | 3379 | 360502 |
2022-05-13 | Adair | Missouri | 29001 | 6095 | 63 | 25343 | 2485 | 240500 |
2022-05-13 | Adams | Ohio | 39001 | 7022 | 148 | 27698 | 5343 | 253520 |
2022-05-13 | Adams | Mississippi | 28001 | 7224 | 143 | 30693 | 4659 | 235363 |
2022-05-13 | Adams | North Dakota | 38001 | 598 | 10 | 2216 | 4512 | 269855 |
2022-05-13 | Adams | Iowa | 19003 | 820 | 14 | 3602 | 3886 | 227651 |
2022-05-13 | Adams | Illinois | 17001 | 22525 | 238 | 65435 | 3637 | 344234 |
2022-05-13 | Adams | Pennsylvania | 42001 | 25114 | 364 | 103009 | 3533 | 243803 |
2022-05-13 | Adams | Idaho | 16003 | 704 | 15 | 4294 | 3493 | 163949 |
2022-05-13 | Adams | Indiana | 18001 | 7288 | 112 | 35777 | 3130 | 203706 |
2022-05-13 | Adams | Wisconsin | 55001 | 4738 | 61 | 20220 | 3016 | 234322 |
2022-05-13 | Adams | Colorado | 8001 | 137720 | 1380 | 517421 | 2667 | 266166 |
2022-05-13 | Adams | Nebraska | 31001 | 6541 | 73 | 31363 | 2327 | 208557 |
2022-05-13 | Adams | Washington | 53001 | 4926 | 39 | 19983 | 1951 | 246509 |
2022-05-13 | Addison | Vermont | 50001 | 5939 | 18 | 36777 | 489 | 161486 |
2022-05-13 | Aiken | South Carolina | 45003 | 41767 | 437 | 170872 | 2557 | 244434 |
2022-05-13 | Aitkin | Minnesota | 27001 | 3049 | 62 | 15886 | 3902 | 191930 |
2022-05-13 | Alachua | Florida | 12001 | 69008 | 665 | 269043 | 2471 | 256494 |
2022-05-13 | Alamance | North Carolina | 37001 | 47756 | 488 | 169509 | 2878 | 281731 |
2022-05-13 | Alameda | California | 6001 | 284054 | 1868 | 1671329 | 1117 | 169956 |
2022-05-13 | Alamosa | Colorado | 8003 | 4560 | 62 | 16233 | 3819 | 280909 |
2022-05-13 | Albany | New York | 36001 | 63461 | 523 | 305506 | 1711 | 207724 |
2022-05-13 | Albany | Wyoming | 56001 | 9934 | 49 | 38880 | 1260 | 255504 |
2022-05-13 | Albemarle | Virginia | 51003 | 18671 | 163 | 109330 | 1490 | 170776 |
2022-05-13 | Alcona | Michigan | 26001 | 1745 | 71 | 10405 | 6823 | 167707 |
2022-05-13 | Alcorn | Mississippi | 28003 | 10080 | 160 | 36953 | 4329 | 272778 |
2022-05-13 | Aleutians East Borough | Alaska | 2013 | 1101 | 3 | 3337 | 899 | 329937 |
2022-05-13 | Aleutians West Census Area | Alaska | 2016 | 1685 | 1 | 5634 | 177 | 299077 |
2022-05-13 | Alexander | North Carolina | 37003 | 10479 | 139 | 37497 | 3706 | 279462 |
2022-05-13 | Alexander | Illinois | 17003 | 1288 | 15 | 5761 | 2603 | 223572 |
2022-05-13 | Alexandria city | Virginia | 51510 | 32647 | 188 | 159428 | 1179 | 204775 |
2022-05-13 | Alfalfa | Oklahoma | 40003 | 1716 | 15 | 5702 | 2630 | 300947 |
2022-05-13 | Alger | Michigan | 26003 | 1880 | 13 | 9108 | 1427 | 206411 |
2022-05-13 | Allamakee | Iowa | 19005 | 2890 | 60 | 13687 | 4383 | 211149 |
2022-05-13 | Allegan | Michigan | 26005 | 27448 | 348 | 118081 | 2947 | 232450 |
2022-05-13 | Allegany | Maryland | 24001 | 17291 | 362 | 70416 | 5140 | 245554 |
2022-05-13 | Allegany | New York | 36003 | 9275 | 155 | 46091 | 3362 | 201232 |
2022-05-13 | Alleghany | Virginia | 51005 | 3364 | 98 | 14860 | 6594 | 226379 |
2022-05-13 | Alleghany | North Carolina | 37005 | 2981 | 16 | 11137 | 1436 | 267666 |
2022-05-13 | Allegheny | Pennsylvania | 42003 | 271427 | 3323 | 1216045 | 2732 | 223204 |
2022-05-13 | Allen | Louisiana | 22003 | 7880 | 141 | 25627 | 5502 | 307488 |
2022-05-13 | Allen | Kentucky | 21003 | 6601 | 107 | 21315 | 5019 | 309688 |
2022-05-13 | Allen | Ohio | 39003 | 27636 | 478 | 102351 | 4670 | 270012 |
2022-05-13 | Allen | Kansas | 20001 | 3989 | 53 | 12369 | 4284 | 322499 |
2022-05-13 | Allen | Indiana | 18003 | 104713 | 1188 | 379299 | 3132 | 276069 |
2022-05-13 | Allendale | South Carolina | 45005 | 2093 | 24 | 8688 | 2762 | 240906 |
2022-05-13 | Alpena | Michigan | 26007 | 5809 | 139 | 28405 | 4893 | 204506 |
2022-05-13 | Alpine | California | 6003 | 126 | 0 | 1129 | 0 | 111603 |
2022-05-13 | Amador | California | 6005 | 9242 | 86 | 39752 | 2163 | 232491 |
2022-05-13 | Amelia | Virginia | 51007 | 2683 | 61 | 13145 | 4640 | 204108 |
2022-05-13 | Amherst | Virginia | 51009 | 7316 | 89 | 31605 | 2816 | 231482 |
2022-05-13 | Amite | Mississippi | 28005 | 3259 | 69 | 12297 | 5611 | 265023 |
2022-05-13 | Anchorage | Alaska | 2020 | 105418 | 526 | 288000 | 1826 | 366034 |
2022-05-13 | Anderson | South Carolina | 45007 | 58025 | 998 | 202558 | 4926 | 286461 |
2022-05-13 | Anderson | Tennessee | 47001 | 22228 | 334 | 76978 | 4338 | 288757 |
2022-05-13 | Anderson | Texas | 48001 | 9691 | 239 | 57735 | 4139 | 167853 |
2022-05-13 | Anderson | Kansas | 20003 | 2133 | 29 | 7858 | 3690 | 271443 |
2022-05-13 | Anderson | Kentucky | 21005 | 6620 | 70 | 22747 | 3077 | 291027 |
2022-05-13 | Andrew | Missouri | 29003 | 4828 | 58 | 17712 | 3274 | 272583 |
2022-05-13 | Andrews | Texas | 48003 | 3822 | 72 | 18705 | 3849 | 204330 |
2022-05-13 | Androscoggin | Maine | 23001 | 23257 | 285 | 108277 | 2632 | 214791 |
2022-05-13 | Angelina | Texas | 48005 | 15501 | 481 | 86715 | 5546 | 178758 |
2022-05-13 | Anne Arundel | Maryland | 24003 | 92830 | 1078 | 579234 | 1861 | 160263 |
2022-05-13 | Anoka | Minnesota | 27003 | 100743 | 797 | 356921 | 2232 | 282255 |
2022-05-13 | Anson | North Carolina | 37007 | 6567 | 101 | 24446 | 4131 | 268632 |
2022-05-13 | Antelope | Nebraska | 31003 | 1081 | 14 | 6298 | 2222 | 171641 |
2022-05-13 | Antrim | Michigan | 26009 | 4470 | 66 | 23324 | 2829 | 191648 |
2022-05-13 | Apache | Arizona | 4001 | 22540 | 614 | 71887 | 8541 | 313547 |
2022-05-13 | Appanoose | Iowa | 19007 | 2927 | 68 | 12426 | 5472 | 235554 |
2022-05-13 | Appling | Georgia | 13001 | 4833 | 128 | 18386 | 6961 | 262863 |
2022-05-13 | Appomattox | Virginia | 51011 | 3817 | 53 | 15911 | 3331 | 239896 |
2022-05-13 | Aransas | Texas | 48007 | 4177 | 86 | 23510 | 3658 | 177669 |
2022-05-13 | Arapahoe | Colorado | 8005 | 158561 | 1284 | 656590 | 1955 | 241491 |
2022-05-13 | Archer | Texas | 48009 | 2213 | 28 | 8553 | 3273 | 258739 |
2022-05-13 | Archuleta | Colorado | 8007 | 2926 | 16 | 14029 | 1140 | 208567 |
2022-05-13 | Arenac | Michigan | 26011 | 3267 | 67 | 14883 | 4501 | 219512 |
2022-05-13 | Arkansas | Arkansas | 5001 | 5696 | 79 | 17486 | 4517 | 325746 |
2022-05-13 | Arlington | Virginia | 51013 | 46198 | 322 | 236842 | 1359 | 195058 |
2022-05-13 | Armstrong | Pennsylvania | 42005 | 15397 | 343 | 64735 | 5298 | 237846 |
2022-05-13 | Armstrong | Texas | 48011 | 555 | 9 | 1887 | 4769 | 294117 |
2022-05-13 | Aroostook | Maine | 23003 | 14393 | 166 | 67055 | 2475 | 214644 |
2022-05-13 | Arthur | Nebraska | 31005 | 31 | 1 | 463 | 2159 | 66954 |
2022-05-13 | Ascension | Louisiana | 22005 | 35030 | 293 | 126604 | 2314 | 276689 |
2022-05-13 | Ashe | North Carolina | 37009 | 6471 | 78 | 27203 | 2867 | 237878 |
2022-05-13 | Ashland | Ohio | 39005 | 12109 | 218 | 53484 | 4075 | 226404 |
2022-05-13 | Ashland | Wisconsin | 55003 | 3364 | 36 | 15562 | 2313 | 216167 |
2022-05-13 | Ashley | Arkansas | 5003 | 5115 | 66 | 19657 | 3357 | 260212 |
2022-05-13 | Ashtabula | Ohio | 39007 | 20537 | 431 | 97241 | 4432 | 211196 |
2022-05-13 | Asotin | Washington | 53003 | 4554 | 66 | 22582 | 2922 | 201665 |
2022-05-13 | Assumption | Louisiana | 22007 | 5575 | 70 | 21891 | 3197 | 254670 |
2022-05-13 | Atascosa | Texas | 48013 | 13647 | 231 | 51153 | 4515 | 266787 |
2022-05-13 | Atchison | Missouri | 29005 | 1387 | 23 | 5143 | 4472 | 269686 |
2022-05-13 | Atchison | Kansas | 20005 | 4323 | 34 | 16073 | 2115 | 268960 |
2022-05-13 | Athens | Ohio | 39009 | 14852 | 142 | 65327 | 2173 | 227348 |
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;