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 139,392
- Georgia 90,649
- Virginia 74,793
- Kentucky 67,012
- Missouri 64,679
- Illinois 57,467
- Kansas 56,893
- North Carolina 56,509
- Iowa 55,770
- Tennessee 54,271
- Indiana 52,290
- Ohio 50,144
- Nebraska 49,233
- Minnesota 49,139
- Michigan 47,310
- Mississippi 46,624
- Oklahoma 43,309
- Arkansas 42,768
- Puerto Rico 41,570
- Wisconsin 40,657
- Florida 38,810
- Pennsylvania 38,170
- Alabama 37,974
- Louisiana 37,057
- Colorado 35,831
- South Dakota 35,494
- New York 33,338
- California 33,280
- West Virginia 30,523
- North Dakota 28,997
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1807566 | 1807566 | 2021-10-12 | Wayne | Illinois | 17191 | 2958 | 62 |
1807567 | 1807567 | 2021-10-12 | White | Illinois | 17193 | 2760 | 43 |
1807568 | 1807568 | 2021-10-12 | Whiteside | Illinois | 17195 | 8321 | 222 |
1807569 | 1807569 | 2021-10-12 | Will | Illinois | 17197 | 90216 | 1190 |
1807570 | 1807570 | 2021-10-12 | Williamson | Illinois | 17199 | 11949 | 185 |
1807571 | 1807571 | 2021-10-12 | Winnebago | Illinois | 17201 | 40513 | 587 |
1807572 | 1807572 | 2021-10-12 | Woodford | Illinois | 17203 | 5698 | 105 |
1807573 | 1807573 | 2021-10-12 | Adams | Indiana | 18001 | 4735 | 74 |
1807574 | 1807574 | 2021-10-12 | Allen | Indiana | 18003 | 56648 | 814 |
1807575 | 1807575 | 2021-10-12 | Bartholomew | Indiana | 18005 | 11362 | 183 |
1807576 | 1807576 | 2021-10-12 | Benton | Indiana | 18007 | 1494 | 16 |
1807577 | 1807577 | 2021-10-12 | Blackford | Indiana | 18009 | 1862 | 39 |
1807578 | 1807578 | 2021-10-12 | Boone | Indiana | 18011 | 8771 | 121 |
1807579 | 1807579 | 2021-10-12 | Brown | Indiana | 18013 | 1418 | 47 |
1807580 | 1807580 | 2021-10-12 | Carroll | Indiana | 18015 | 2565 | 34 |
1807581 | 1807581 | 2021-10-12 | Cass | Indiana | 18017 | 7417 | 121 |
1807582 | 1807582 | 2021-10-12 | Clark | Indiana | 18019 | 18279 | 256 |
1807583 | 1807583 | 2021-10-12 | Clay | Indiana | 18021 | 4139 | 61 |
1807584 | 1807584 | 2021-10-12 | Clinton | Indiana | 18023 | 5613 | 74 |
1807585 | 1807585 | 2021-10-12 | Crawford | Indiana | 18025 | 1568 | 23 |
1807586 | 1807586 | 2021-10-12 | Daviess | Indiana | 18027 | 4540 | 114 |
1807587 | 1807587 | 2021-10-12 | DeKalb | Indiana | 18033 | 6173 | 99 |
1807588 | 1807588 | 2021-10-12 | Dearborn | Indiana | 18029 | 8106 | 96 |
1807589 | 1807589 | 2021-10-12 | Decatur | Indiana | 18031 | 4135 | 105 |
1807590 | 1807590 | 2021-10-12 | Delaware | Indiana | 18035 | 14873 | 262 |
1807591 | 1807591 | 2021-10-12 | Dubois | Indiana | 18037 | 8160 | 130 |
1807592 | 1807592 | 2021-10-12 | Elkhart | Indiana | 18039 | 35382 | 518 |
1807593 | 1807593 | 2021-10-12 | Fayette | Indiana | 18041 | 4135 | 89 |
1807594 | 1807594 | 2021-10-12 | Floyd | Indiana | 18043 | 10919 | 220 |
1807595 | 1807595 | 2021-10-12 | Fountain | Indiana | 18045 | 3297 | 60 |
1807596 | 1807596 | 2021-10-12 | Franklin | Indiana | 18047 | 2619 | 45 |
1807597 | 1807597 | 2021-10-12 | Fulton | Indiana | 18049 | 3016 | 65 |
1807598 | 1807598 | 2021-10-12 | Gibson | Indiana | 18051 | 6435 | 115 |
1807599 | 1807599 | 2021-10-12 | Grant | Indiana | 18053 | 10180 | 224 |
1807600 | 1807600 | 2021-10-12 | Greene | Indiana | 18055 | 4182 | 100 |
1807601 | 1807601 | 2021-10-12 | Hamilton | Indiana | 18057 | 45745 | 479 |
1807602 | 1807602 | 2021-10-12 | Hancock | Indiana | 18059 | 11559 | 180 |
1807603 | 1807603 | 2021-10-12 | Harrison | Indiana | 18061 | 6375 | 94 |
1807604 | 1807604 | 2021-10-12 | Hendricks | Indiana | 18063 | 23554 | 372 |
1807605 | 1807605 | 2021-10-12 | Henry | Indiana | 18065 | 8070 | 153 |
1807606 | 1807606 | 2021-10-12 | Howard | Indiana | 18067 | 14477 | 290 |
1807607 | 1807607 | 2021-10-12 | Huntington | Indiana | 18069 | 6264 | 99 |
1807608 | 1807608 | 2021-10-12 | Jackson | Indiana | 18071 | 6867 | 88 |
1807609 | 1807609 | 2021-10-12 | Jasper | Indiana | 18073 | 5135 | 77 |
1807610 | 1807610 | 2021-10-12 | Jay | Indiana | 18075 | 2770 | 49 |
1807611 | 1807611 | 2021-10-12 | Jefferson | Indiana | 18077 | 5010 | 98 |
1807612 | 1807612 | 2021-10-12 | Jennings | Indiana | 18079 | 3807 | 61 |
1807613 | 1807613 | 2021-10-12 | Johnson | Indiana | 18081 | 24730 | 456 |
1807614 | 1807614 | 2021-10-12 | Knox | Indiana | 18083 | 6189 | 105 |
1807615 | 1807615 | 2021-10-12 | Kosciusko | Indiana | 18085 | 12020 | 151 |
1807616 | 1807616 | 2021-10-12 | LaGrange | Indiana | 18087 | 3478 | 79 |
1807617 | 1807617 | 2021-10-12 | LaPorte | Indiana | 18091 | 14911 | 251 |
1807618 | 1807618 | 2021-10-12 | Lake | Indiana | 18089 | 65555 | 1189 |
1807619 | 1807619 | 2021-10-12 | Lawrence | Indiana | 18093 | 7339 | 170 |
1807620 | 1807620 | 2021-10-12 | Madison | Indiana | 18095 | 18380 | 423 |
1807621 | 1807621 | 2021-10-12 | Marion | Indiana | 18097 | 133860 | 2164 |
1807622 | 1807622 | 2021-10-12 | Marshall | Indiana | 18099 | 7715 | 137 |
1807623 | 1807623 | 2021-10-12 | Martin | Indiana | 18101 | 1369 | 20 |
1807624 | 1807624 | 2021-10-12 | Miami | Indiana | 18103 | 5819 | 95 |
1807625 | 1807625 | 2021-10-12 | Monroe | Indiana | 18105 | 15039 | 199 |
1807626 | 1807626 | 2021-10-12 | Montgomery | Indiana | 18107 | 6144 | 110 |
1807627 | 1807627 | 2021-10-12 | Morgan | Indiana | 18109 | 9318 | 181 |
1807628 | 1807628 | 2021-10-12 | Newton | Indiana | 18111 | 1540 | 50 |
1807629 | 1807629 | 2021-10-12 | Noble | Indiana | 18113 | 7841 | 107 |
1807630 | 1807630 | 2021-10-12 | Ohio | Indiana | 18115 | 837 | 12 |
1807631 | 1807631 | 2021-10-12 | Orange | Indiana | 18117 | 2880 | 66 |
1807632 | 1807632 | 2021-10-12 | Owen | Indiana | 18119 | 3071 | 69 |
1807633 | 1807633 | 2021-10-12 | Parke | Indiana | 18121 | 2299 | 25 |
1807634 | 1807634 | 2021-10-12 | Perry | Indiana | 18123 | 2638 | 55 |
1807635 | 1807635 | 2021-10-12 | Pike | Indiana | 18125 | 2263 | 44 |
1807636 | 1807636 | 2021-10-12 | Porter | Indiana | 18127 | 22612 | 372 |
1807637 | 1807637 | 2021-10-12 | Posey | Indiana | 18129 | 3715 | 42 |
1807638 | 1807638 | 2021-10-12 | Pulaski | Indiana | 18131 | 1786 | 53 |
1807639 | 1807639 | 2021-10-12 | Putnam | Indiana | 18133 | 5712 | 79 |
1807640 | 1807640 | 2021-10-12 | Randolph | Indiana | 18135 | 3407 | 98 |
1807641 | 1807641 | 2021-10-12 | Ripley | Indiana | 18137 | 4891 | 85 |
1807642 | 1807642 | 2021-10-12 | Rush | Indiana | 18139 | 2614 | 32 |
1807643 | 1807643 | 2021-10-12 | Scott | Indiana | 18143 | 4319 | 70 |
1807644 | 1807644 | 2021-10-12 | Shelby | Indiana | 18145 | 8077 | 125 |
1807645 | 1807645 | 2021-10-12 | Spencer | Indiana | 18147 | 3348 | 41 |
1807646 | 1807646 | 2021-10-12 | St. Joseph | Indiana | 18141 | 43728 | 621 |
1807647 | 1807647 | 2021-10-12 | Starke | Indiana | 18149 | 3081 | 70 |
1807648 | 1807648 | 2021-10-12 | Steuben | Indiana | 18151 | 5417 | 72 |
1807649 | 1807649 | 2021-10-12 | Sullivan | Indiana | 18153 | 3255 | 54 |
1807650 | 1807650 | 2021-10-12 | Switzerland | Indiana | 18155 | 1330 | 11 |
1807651 | 1807651 | 2021-10-12 | Tippecanoe | Indiana | 18157 | 27561 | 258 |
1807652 | 1807652 | 2021-10-12 | Tipton | Indiana | 18159 | 2243 | 59 |
1807653 | 1807653 | 2021-10-12 | Union | Indiana | 18161 | 1080 | 16 |
1807654 | 1807654 | 2021-10-12 | Vanderburgh | Indiana | 18163 | 31672 | 481 |
1807655 | 1807655 | 2021-10-12 | Vermillion | Indiana | 18165 | 2517 | 54 |
1807656 | 1807656 | 2021-10-12 | Vigo | Indiana | 18167 | 17139 | 302 |
1807657 | 1807657 | 2021-10-12 | Wabash | Indiana | 18169 | 5189 | 100 |
1807658 | 1807658 | 2021-10-12 | Warren | Indiana | 18171 | 1193 | 18 |
1807659 | 1807659 | 2021-10-12 | Warrick | Indiana | 18173 | 11120 | 190 |
1807660 | 1807660 | 2021-10-12 | Washington | Indiana | 18175 | 3490 | 49 |
1807661 | 1807661 | 2021-10-12 | Wayne | Indiana | 18177 | 11102 | 250 |
1807662 | 1807662 | 2021-10-12 | Wells | Indiana | 18179 | 4157 | 88 |
1807663 | 1807663 | 2021-10-12 | White | Indiana | 18181 | 4107 | 61 |
1807664 | 1807664 | 2021-10-12 | Whitley | Indiana | 18183 | 5526 | 55 |
1807665 | 1807665 | 2021-10-12 | Adair | Iowa | 19001 | 1010 | 34 |
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);