ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where date = "2020-11-14" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
729660 | 729660 | 2020-11-14 | Adams | Indiana | 18001 | 1235 | 16 |
729661 | 729661 | 2020-11-14 | Allen | Indiana | 18003 | 13812 | 276 |
729662 | 729662 | 2020-11-14 | Bartholomew | Indiana | 18005 | 2279 | 65 |
729663 | 729663 | 2020-11-14 | Benton | Indiana | 18007 | 217 | 1 |
729664 | 729664 | 2020-11-14 | Blackford | Indiana | 18009 | 389 | 10 |
729665 | 729665 | 2020-11-14 | Boone | Indiana | 18011 | 1934 | 56 |
729666 | 729666 | 2020-11-14 | Brown | Indiana | 18013 | 242 | 3 |
729667 | 729667 | 2020-11-14 | Carroll | Indiana | 18015 | 541 | 13 |
729668 | 729668 | 2020-11-14 | Cass | Indiana | 18017 | 2705 | 28 |
729669 | 729669 | 2020-11-14 | Clark | Indiana | 18019 | 4170 | 79 |
729670 | 729670 | 2020-11-14 | Clay | Indiana | 18021 | 818 | 21 |
729671 | 729671 | 2020-11-14 | Clinton | Indiana | 18023 | 1432 | 23 |
729672 | 729672 | 2020-11-14 | Crawford | Indiana | 18025 | 227 | 2 |
729673 | 729673 | 2020-11-14 | Daviess | Indiana | 18027 | 1228 | 44 |
729674 | 729674 | 2020-11-14 | DeKalb | Indiana | 18033 | 1339 | 18 |
729675 | 729675 | 2020-11-14 | Dearborn | Indiana | 18029 | 1635 | 30 |
729676 | 729676 | 2020-11-14 | Decatur | Indiana | 18031 | 1030 | 43 |
729677 | 729677 | 2020-11-14 | Delaware | Indiana | 18035 | 4061 | 99 |
729678 | 729678 | 2020-11-14 | Dubois | Indiana | 18037 | 2045 | 30 |
729679 | 729679 | 2020-11-14 | Elkhart | Indiana | 18039 | 14073 | 190 |
729680 | 729680 | 2020-11-14 | Fayette | Indiana | 18041 | 1350 | 27 |
729681 | 729681 | 2020-11-14 | Floyd | Indiana | 18043 | 2607 | 77 |
729682 | 729682 | 2020-11-14 | Fountain | Indiana | 18045 | 586 | 8 |
729683 | 729683 | 2020-11-14 | Franklin | Indiana | 18047 | 536 | 26 |
729684 | 729684 | 2020-11-14 | Fulton | Indiana | 18049 | 655 | 14 |
729685 | 729685 | 2020-11-14 | Gibson | Indiana | 18051 | 1394 | 18 |
729686 | 729686 | 2020-11-14 | Grant | Indiana | 18053 | 2392 | 48 |
729687 | 729687 | 2020-11-14 | Greene | Indiana | 18055 | 829 | 52 |
729688 | 729688 | 2020-11-14 | Hamilton | Indiana | 18057 | 9925 | 163 |
729689 | 729689 | 2020-11-14 | Hancock | Indiana | 18059 | 1949 | 50 |
729690 | 729690 | 2020-11-14 | Harrison | Indiana | 18061 | 1120 | 26 |
729691 | 729691 | 2020-11-14 | Hendricks | Indiana | 18063 | 4677 | 165 |
729692 | 729692 | 2020-11-14 | Henry | Indiana | 18065 | 1982 | 33 |
729693 | 729693 | 2020-11-14 | Howard | Indiana | 18067 | 2389 | 74 |
729694 | 729694 | 2020-11-14 | Huntington | Indiana | 18069 | 870 | 7 |
729695 | 729695 | 2020-11-14 | Jackson | Indiana | 18071 | 1679 | 30 |
729696 | 729696 | 2020-11-14 | Jasper | Indiana | 18073 | 1116 | 8 |
729697 | 729697 | 2020-11-14 | Jay | Indiana | 18075 | 711 | 10 |
729698 | 729698 | 2020-11-14 | Jefferson | Indiana | 18077 | 781 | 11 |
729699 | 729699 | 2020-11-14 | Jennings | Indiana | 18079 | 633 | 15 |
729700 | 729700 | 2020-11-14 | Johnson | Indiana | 18081 | 4872 | 169 |
729701 | 729701 | 2020-11-14 | Knox | Indiana | 18083 | 1399 | 13 |
729702 | 729702 | 2020-11-14 | Kosciusko | Indiana | 18085 | 3403 | 38 |
729703 | 729703 | 2020-11-14 | LaGrange | Indiana | 18087 | 1196 | 24 |
729704 | 729704 | 2020-11-14 | LaPorte | Indiana | 18091 | 3633 | 82 |
729705 | 729705 | 2020-11-14 | Lake | Indiana | 18089 | 22097 | 430 |
729706 | 729706 | 2020-11-14 | Lawrence | Indiana | 18093 | 1479 | 45 |
729707 | 729707 | 2020-11-14 | Madison | Indiana | 18095 | 3804 | 125 |
729708 | 729708 | 2020-11-14 | Marion | Indiana | 18097 | 34807 | 872 |
729709 | 729709 | 2020-11-14 | Marshall | Indiana | 18099 | 2392 | 34 |
729710 | 729710 | 2020-11-14 | Martin | Indiana | 18101 | 283 | 2 |
729711 | 729711 | 2020-11-14 | Miami | Indiana | 18103 | 1143 | 9 |
729712 | 729712 | 2020-11-14 | Monroe | Indiana | 18105 | 4316 | 46 |
729713 | 729713 | 2020-11-14 | Montgomery | Indiana | 18107 | 1063 | 25 |
729714 | 729714 | 2020-11-14 | Morgan | Indiana | 18109 | 1595 | 45 |
729715 | 729715 | 2020-11-14 | Newton | Indiana | 18111 | 444 | 13 |
729716 | 729716 | 2020-11-14 | Noble | Indiana | 18113 | 1971 | 42 |
729717 | 729717 | 2020-11-14 | Ohio | Indiana | 18115 | 186 | 7 |
729718 | 729718 | 2020-11-14 | Orange | Indiana | 18117 | 572 | 29 |
729719 | 729719 | 2020-11-14 | Owen | Indiana | 18119 | 438 | 3 |
729720 | 729720 | 2020-11-14 | Parke | Indiana | 18121 | 427 | 6 |
729721 | 729721 | 2020-11-14 | Perry | Indiana | 18123 | 722 | 21 |
729722 | 729722 | 2020-11-14 | Pike | Indiana | 18125 | 444 | 18 |
729723 | 729723 | 2020-11-14 | Porter | Indiana | 18127 | 6175 | 69 |
729724 | 729724 | 2020-11-14 | Posey | Indiana | 18129 | 1026 | 13 |
729725 | 729725 | 2020-11-14 | Pulaski | Indiana | 18131 | 322 | 10 |
729726 | 729726 | 2020-11-14 | Putnam | Indiana | 18133 | 1002 | 24 |
729727 | 729727 | 2020-11-14 | Randolph | Indiana | 18135 | 949 | 13 |
729728 | 729728 | 2020-11-14 | Ripley | Indiana | 18137 | 917 | 12 |
729729 | 729729 | 2020-11-14 | Rush | Indiana | 18139 | 476 | 6 |
729730 | 729730 | 2020-11-14 | Scott | Indiana | 18143 | 763 | 19 |
729731 | 729731 | 2020-11-14 | Shelby | Indiana | 18145 | 1996 | 56 |
729732 | 729732 | 2020-11-14 | Spencer | Indiana | 18147 | 661 | 7 |
729733 | 729733 | 2020-11-14 | St. Joseph | Indiana | 18141 | 13883 | 203 |
729734 | 729734 | 2020-11-14 | Starke | Indiana | 18149 | 740 | 17 |
729735 | 729735 | 2020-11-14 | Steuben | Indiana | 18151 | 1111 | 11 |
729736 | 729736 | 2020-11-14 | Sullivan | Indiana | 18153 | 660 | 15 |
729737 | 729737 | 2020-11-14 | Switzerland | Indiana | 18155 | 203 | 1 |
729738 | 729738 | 2020-11-14 | Tippecanoe | Indiana | 18157 | 6421 | 24 |
729739 | 729739 | 2020-11-14 | Tipton | Indiana | 18159 | 433 | 26 |
729740 | 729740 | 2020-11-14 | Union | Indiana | 18161 | 245 | 1 |
729741 | 729741 | 2020-11-14 | Vanderburgh | Indiana | 18163 | 8073 | 100 |
729742 | 729742 | 2020-11-14 | Vermillion | Indiana | 18165 | 440 | 2 |
729743 | 729743 | 2020-11-14 | Vigo | Indiana | 18167 | 4593 | 66 |
729744 | 729744 | 2020-11-14 | Wabash | Indiana | 18169 | 1056 | 16 |
729745 | 729745 | 2020-11-14 | Warren | Indiana | 18171 | 175 | 1 |
729746 | 729746 | 2020-11-14 | Warrick | Indiana | 18173 | 2707 | 71 |
729747 | 729747 | 2020-11-14 | Washington | Indiana | 18175 | 552 | 5 |
729748 | 729748 | 2020-11-14 | Wayne | Indiana | 18177 | 2752 | 45 |
729749 | 729749 | 2020-11-14 | Wells | Indiana | 18179 | 924 | 22 |
729750 | 729750 | 2020-11-14 | White | Indiana | 18181 | 954 | 19 |
729751 | 729751 | 2020-11-14 | Whitley | Indiana | 18183 | 978 | 7 |
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);