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 79,702
- Georgia 53,049
- Virginia 43,536
- Kentucky 38,812
- Missouri 37,183
- Illinois 33,263
- North Carolina 33,009
- Iowa 32,270
- Kansas 32,161
- Tennessee 31,711
- Indiana 30,670
- Ohio 29,242
- Minnesota 28,459
- Michigan 27,570
- Mississippi 27,354
- Nebraska 27,233
- Oklahoma 24,980
- Arkansas 24,908
- Wisconsin 23,735
- Puerto Rico 23,005
- Florida 22,830
- Pennsylvania 22,425
- Alabama 22,229
- Louisiana 21,783
- Colorado 20,791
- South Dakota 19,984
- New York 19,708
- California 19,643
- West Virginia 17,596
- North Dakota 16,307
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1044462 | 1044462 | 2021-02-19 | Washington | Illinois | 17189 | 1568 | 29 |
1044463 | 1044463 | 2021-02-19 | Wayne | Illinois | 17191 | 1656 | 47 |
1044464 | 1044464 | 2021-02-19 | White | Illinois | 17193 | 1587 | 35 |
1044465 | 1044465 | 2021-02-19 | Whiteside | Illinois | 17195 | 5914 | 187 |
1044466 | 1044466 | 2021-02-19 | Will | Illinois | 17197 | 63994 | 952 |
1044467 | 1044467 | 2021-02-19 | Williamson | Illinois | 17199 | 6731 | 129 |
1044468 | 1044468 | 2021-02-19 | Winnebago | Illinois | 17201 | 28110 | 458 |
1044469 | 1044469 | 2021-02-19 | Woodford | Illinois | 17203 | 3634 | 73 |
1044470 | 1044470 | 2021-02-19 | Adams | Indiana | 18001 | 3187 | 50 |
1044471 | 1044471 | 2021-02-19 | Allen | Indiana | 18003 | 35355 | 655 |
1044472 | 1044472 | 2021-02-19 | Bartholomew | Indiana | 18005 | 7317 | 152 |
1044473 | 1044473 | 2021-02-19 | Benton | Indiana | 18007 | 908 | 13 |
1044474 | 1044474 | 2021-02-19 | Blackford | Indiana | 18009 | 1210 | 27 |
1044475 | 1044475 | 2021-02-19 | Boone | Indiana | 18011 | 6025 | 93 |
1044476 | 1044476 | 2021-02-19 | Brown | Indiana | 18013 | 938 | 39 |
1044477 | 1044477 | 2021-02-19 | Carroll | Indiana | 18015 | 1745 | 20 |
1044478 | 1044478 | 2021-02-19 | Cass | Indiana | 18017 | 5267 | 99 |
1044479 | 1044479 | 2021-02-19 | Clark | Indiana | 18019 | 11783 | 187 |
1044480 | 1044480 | 2021-02-19 | Clay | Indiana | 18021 | 2376 | 43 |
1044481 | 1044481 | 2021-02-19 | Clinton | Indiana | 18023 | 3909 | 57 |
1044482 | 1044482 | 2021-02-19 | Crawford | Indiana | 18025 | 897 | 14 |
1044483 | 1044483 | 2021-02-19 | Daviess | Indiana | 18027 | 2837 | 97 |
1044484 | 1044484 | 2021-02-19 | DeKalb | Indiana | 18033 | 3807 | 81 |
1044485 | 1044485 | 2021-02-19 | Dearborn | Indiana | 18029 | 5354 | 67 |
1044486 | 1044486 | 2021-02-19 | Decatur | Indiana | 18031 | 2737 | 92 |
1044487 | 1044487 | 2021-02-19 | Delaware | Indiana | 18035 | 9768 | 183 |
1044488 | 1044488 | 2021-02-19 | Dubois | Indiana | 18037 | 5851 | 107 |
1044489 | 1044489 | 2021-02-19 | Elkhart | Indiana | 18039 | 25270 | 426 |
1044490 | 1044490 | 2021-02-19 | Fayette | Indiana | 18041 | 2826 | 55 |
1044491 | 1044491 | 2021-02-19 | Floyd | Indiana | 18043 | 7114 | 168 |
1044492 | 1044492 | 2021-02-19 | Fountain | Indiana | 18045 | 1989 | 40 |
1044493 | 1044493 | 2021-02-19 | Franklin | Indiana | 18047 | 1600 | 36 |
1044494 | 1044494 | 2021-02-19 | Fulton | Indiana | 18049 | 1756 | 38 |
1044495 | 1044495 | 2021-02-19 | Gibson | Indiana | 18051 | 3995 | 84 |
1044496 | 1044496 | 2021-02-19 | Grant | Indiana | 18053 | 6787 | 161 |
1044497 | 1044497 | 2021-02-19 | Greene | Indiana | 18055 | 2596 | 82 |
1044498 | 1044498 | 2021-02-19 | Hamilton | Indiana | 18057 | 31595 | 394 |
1044499 | 1044499 | 2021-02-19 | Hancock | Indiana | 18059 | 7375 | 132 |
1044500 | 1044500 | 2021-02-19 | Harrison | Indiana | 18061 | 3924 | 62 |
1044501 | 1044501 | 2021-02-19 | Hendricks | Indiana | 18063 | 15678 | 314 |
1044502 | 1044502 | 2021-02-19 | Henry | Indiana | 18065 | 5385 | 91 |
1044503 | 1044503 | 2021-02-19 | Howard | Indiana | 18067 | 9002 | 194 |
1044504 | 1044504 | 2021-02-19 | Huntington | Indiana | 18069 | 3335 | 77 |
1044505 | 1044505 | 2021-02-19 | Jackson | Indiana | 18071 | 4612 | 61 |
1044506 | 1044506 | 2021-02-19 | Jasper | Indiana | 18073 | 3116 | 44 |
1044507 | 1044507 | 2021-02-19 | Jay | Indiana | 18075 | 1777 | 30 |
1044508 | 1044508 | 2021-02-19 | Jefferson | Indiana | 18077 | 2914 | 73 |
1044509 | 1044509 | 2021-02-19 | Jennings | Indiana | 18079 | 2127 | 46 |
1044510 | 1044510 | 2021-02-19 | Johnson | Indiana | 18081 | 16227 | 360 |
1044511 | 1044511 | 2021-02-19 | Knox | Indiana | 18083 | 3542 | 82 |
1044512 | 1044512 | 2021-02-19 | Kosciusko | Indiana | 18085 | 8492 | 111 |
1044513 | 1044513 | 2021-02-19 | LaGrange | Indiana | 18087 | 2402 | 72 |
1044514 | 1044514 | 2021-02-19 | LaPorte | Indiana | 18091 | 9682 | 197 |
1044515 | 1044515 | 2021-02-19 | Lake | Indiana | 18089 | 47978 | 889 |
1044516 | 1044516 | 2021-02-19 | Lawrence | Indiana | 18093 | 4135 | 114 |
1044517 | 1044517 | 2021-02-19 | Madison | Indiana | 18095 | 11660 | 331 |
1044518 | 1044518 | 2021-02-19 | Marion | Indiana | 18097 | 89906 | 1685 |
1044519 | 1044519 | 2021-02-19 | Marshall | Indiana | 18099 | 5370 | 105 |
1044520 | 1044520 | 2021-02-19 | Martin | Indiana | 18101 | 797 | 14 |
1044521 | 1044521 | 2021-02-19 | Miami | Indiana | 18103 | 3528 | 62 |
1044522 | 1044522 | 2021-02-19 | Monroe | Indiana | 18105 | 10171 | 161 |
1044523 | 1044523 | 2021-02-19 | Montgomery | Indiana | 18107 | 3775 | 83 |
1044524 | 1044524 | 2021-02-19 | Morgan | Indiana | 18109 | 6014 | 129 |
1044525 | 1044525 | 2021-02-19 | Newton | Indiana | 18111 | 966 | 33 |
1044526 | 1044526 | 2021-02-19 | Noble | Indiana | 18113 | 5037 | 78 |
1044527 | 1044527 | 2021-02-19 | Ohio | Indiana | 18115 | 523 | 11 |
1044528 | 1044528 | 2021-02-19 | Orange | Indiana | 18117 | 1708 | 53 |
1044529 | 1044529 | 2021-02-19 | Owen | Indiana | 18119 | 1817 | 54 |
1044530 | 1044530 | 2021-02-19 | Parke | Indiana | 18121 | 1388 | 15 |
1044531 | 1044531 | 2021-02-19 | Perry | Indiana | 18123 | 1723 | 36 |
1044532 | 1044532 | 2021-02-19 | Pike | Indiana | 18125 | 1266 | 32 |
1044533 | 1044533 | 2021-02-19 | Porter | Indiana | 18127 | 15769 | 276 |
1044534 | 1044534 | 2021-02-19 | Posey | Indiana | 18129 | 2586 | 31 |
1044535 | 1044535 | 2021-02-19 | Pulaski | Indiana | 18131 | 1048 | 42 |
1044536 | 1044536 | 2021-02-19 | Putnam | Indiana | 18133 | 3240 | 58 |
1044537 | 1044537 | 2021-02-19 | Randolph | Indiana | 18135 | 2285 | 76 |
1044538 | 1044538 | 2021-02-19 | Ripley | Indiana | 18137 | 3235 | 60 |
1044539 | 1044539 | 2021-02-19 | Rush | Indiana | 18139 | 1689 | 22 |
1044540 | 1044540 | 2021-02-19 | Scott | Indiana | 18143 | 2471 | 48 |
1044541 | 1044541 | 2021-02-19 | Shelby | Indiana | 18145 | 5478 | 100 |
1044542 | 1044542 | 2021-02-19 | Spencer | Indiana | 18147 | 2146 | 29 |
1044543 | 1044543 | 2021-02-19 | St. Joseph | Indiana | 18141 | 29298 | 522 |
1044544 | 1044544 | 2021-02-19 | Starke | Indiana | 18149 | 1851 | 53 |
1044545 | 1044545 | 2021-02-19 | Steuben | Indiana | 18151 | 3345 | 57 |
1044546 | 1044546 | 2021-02-19 | Sullivan | Indiana | 18153 | 2019 | 38 |
1044547 | 1044547 | 2021-02-19 | Switzerland | Indiana | 18155 | 749 | 7 |
1044548 | 1044548 | 2021-02-19 | Tippecanoe | Indiana | 18157 | 19603 | 197 |
1044549 | 1044549 | 2021-02-19 | Tipton | Indiana | 18159 | 1456 | 44 |
1044550 | 1044550 | 2021-02-19 | Union | Indiana | 18161 | 692 | 10 |
1044551 | 1044551 | 2021-02-19 | Vanderburgh | Indiana | 18163 | 21024 | 376 |
1044552 | 1044552 | 2021-02-19 | Vermillion | Indiana | 18165 | 1578 | 40 |
1044553 | 1044553 | 2021-02-19 | Vigo | Indiana | 18167 | 11455 | 233 |
1044554 | 1044554 | 2021-02-19 | Wabash | Indiana | 18169 | 3276 | 75 |
1044555 | 1044555 | 2021-02-19 | Warren | Indiana | 18171 | 743 | 13 |
1044556 | 1044556 | 2021-02-19 | Warrick | Indiana | 18173 | 7336 | 146 |
1044557 | 1044557 | 2021-02-19 | Washington | Indiana | 18175 | 2050 | 27 |
1044558 | 1044558 | 2021-02-19 | Wayne | Indiana | 18177 | 6952 | 190 |
1044559 | 1044559 | 2021-02-19 | Wells | Indiana | 18179 | 2553 | 78 |
1044560 | 1044560 | 2021-02-19 | White | Indiana | 18181 | 2926 | 51 |
1044561 | 1044561 | 2021-02-19 | Whitley | Indiana | 18183 | 3429 | 35 |
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);