ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
93 rows where date = "2022-04-29" 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 |
---|---|---|---|---|---|---|---|
2454681 | 2454681 | 2022-04-29 | Adams | Indiana | 18001 | 7275 | 112 |
2454682 | 2454682 | 2022-04-29 | Allen | Indiana | 18003 | 104168 | 1186 |
2454683 | 2454683 | 2022-04-29 | Bartholomew | Indiana | 18005 | 21410 | 249 |
2454684 | 2454684 | 2022-04-29 | Benton | Indiana | 18007 | 2487 | 21 |
2454685 | 2454685 | 2022-04-29 | Blackford | Indiana | 18009 | 3115 | 69 |
2454686 | 2454686 | 2022-04-29 | Boone | Indiana | 18011 | 15328 | 183 |
2454687 | 2454687 | 2022-04-29 | Brown | Indiana | 18013 | 2591 | 62 |
2454688 | 2454688 | 2022-04-29 | Carroll | Indiana | 18015 | 4249 | 68 |
2454689 | 2454689 | 2022-04-29 | Cass | Indiana | 18017 | 11689 | 163 |
2454690 | 2454690 | 2022-04-29 | Clark | Indiana | 18019 | 31287 | 396 |
2454691 | 2454691 | 2022-04-29 | Clay | Indiana | 18021 | 6835 | 88 |
2454692 | 2454692 | 2022-04-29 | Clinton | Indiana | 18023 | 9215 | 126 |
2454693 | 2454693 | 2022-04-29 | Crawford | Indiana | 18025 | 2554 | 40 |
2454694 | 2454694 | 2022-04-29 | Daviess | Indiana | 18027 | 7482 | 154 |
2454695 | 2454695 | 2022-04-29 | DeKalb | Indiana | 18033 | 11374 | 152 |
2454696 | 2454696 | 2022-04-29 | Dearborn | Indiana | 18029 | 13495 | 140 |
2454697 | 2454697 | 2022-04-29 | Decatur | Indiana | 18031 | 7011 | 145 |
2454698 | 2454698 | 2022-04-29 | Delaware | Indiana | 18035 | 24935 | 443 |
2454699 | 2454699 | 2022-04-29 | Dubois | Indiana | 18037 | 12877 | 165 |
2454700 | 2454700 | 2022-04-29 | Elkhart | Indiana | 18039 | 54197 | 733 |
2454701 | 2454701 | 2022-04-29 | Fayette | Indiana | 18041 | 6744 | 146 |
2454702 | 2454702 | 2022-04-29 | Floyd | Indiana | 18043 | 19047 | 301 |
2454703 | 2454703 | 2022-04-29 | Fountain | Indiana | 18045 | 5456 | 103 |
2454704 | 2454704 | 2022-04-29 | Franklin | Indiana | 18047 | 4377 | 65 |
2454705 | 2454705 | 2022-04-29 | Fulton | Indiana | 18049 | 4927 | 103 |
2454706 | 2454706 | 2022-04-29 | Gibson | Indiana | 18051 | 11680 | 146 |
2454707 | 2454707 | 2022-04-29 | Grant | Indiana | 18053 | 17347 | 351 |
2454708 | 2454708 | 2022-04-29 | Greene | Indiana | 18055 | 7230 | 139 |
2454709 | 2454709 | 2022-04-29 | Hamilton | Indiana | 18057 | 82492 | 661 |
2454710 | 2454710 | 2022-04-29 | Hancock | Indiana | 18059 | 20741 | 258 |
2454711 | 2454711 | 2022-04-29 | Harrison | Indiana | 18061 | 10839 | 138 |
2454712 | 2454712 | 2022-04-29 | Hendricks | Indiana | 18063 | 40867 | 554 |
2454713 | 2454713 | 2022-04-29 | Henry | Indiana | 18065 | 13008 | 231 |
2454714 | 2454714 | 2022-04-29 | Howard | Indiana | 18067 | 25457 | 449 |
2454715 | 2454715 | 2022-04-29 | Huntington | Indiana | 18069 | 11525 | 157 |
2454716 | 2454716 | 2022-04-29 | Jackson | Indiana | 18071 | 12544 | 130 |
2454717 | 2454717 | 2022-04-29 | Jasper | Indiana | 18073 | 9079 | 149 |
2454718 | 2454718 | 2022-04-29 | Jay | Indiana | 18075 | 4855 | 78 |
2454719 | 2454719 | 2022-04-29 | Jefferson | Indiana | 18077 | 9350 | 159 |
2454720 | 2454720 | 2022-04-29 | Jennings | Indiana | 18079 | 6953 | 108 |
2454721 | 2454721 | 2022-04-29 | Johnson | Indiana | 18081 | 42546 | 614 |
2454722 | 2454722 | 2022-04-29 | Knox | Indiana | 18083 | 10761 | 153 |
2454723 | 2454723 | 2022-04-29 | Kosciusko | Indiana | 18085 | 19782 | 237 |
2454724 | 2454724 | 2022-04-29 | LaGrange | Indiana | 18087 | 5851 | 102 |
2454725 | 2454725 | 2022-04-29 | LaPorte | Indiana | 18091 | 25653 | 368 |
2454726 | 2454726 | 2022-04-29 | Lake | Indiana | 18089 | 107252 | 1825 |
2454727 | 2454727 | 2022-04-29 | Lawrence | Indiana | 18093 | 11941 | 260 |
2454728 | 2454728 | 2022-04-29 | Madison | Indiana | 18095 | 32763 | 652 |
2454729 | 2454729 | 2022-04-29 | Marion | Indiana | 18097 | 226157 | 2995 |
2454730 | 2454730 | 2022-04-29 | Marshall | Indiana | 18099 | 12394 | 197 |
2454731 | 2454731 | 2022-04-29 | Martin | Indiana | 18101 | 2165 | 25 |
2454732 | 2454732 | 2022-04-29 | Miami | Indiana | 18103 | 9270 | 159 |
2454733 | 2454733 | 2022-04-29 | Monroe | Indiana | 18105 | 28305 | 280 |
2454734 | 2454734 | 2022-04-29 | Montgomery | Indiana | 18107 | 10700 | 164 |
2454735 | 2454735 | 2022-04-29 | Morgan | Indiana | 18109 | 16507 | 287 |
2454736 | 2454736 | 2022-04-29 | Newton | Indiana | 18111 | 2577 | 68 |
2454737 | 2454737 | 2022-04-29 | Noble | Indiana | 18113 | 13090 | 157 |
2454738 | 2454738 | 2022-04-29 | Ohio | Indiana | 18115 | 1448 | 19 |
2454739 | 2454739 | 2022-04-29 | Orange | Indiana | 18117 | 5045 | 96 |
2454740 | 2454740 | 2022-04-29 | Owen | Indiana | 18119 | 5871 | 121 |
2454741 | 2454741 | 2022-04-29 | Parke | Indiana | 18121 | 3597 | 46 |
2454742 | 2454742 | 2022-04-29 | Perry | Indiana | 18123 | 4656 | 69 |
2454743 | 2454743 | 2022-04-29 | Pike | Indiana | 18125 | 3735 | 49 |
2454744 | 2454744 | 2022-04-29 | Porter | Indiana | 18127 | 38064 | 562 |
2454745 | 2454745 | 2022-04-29 | Posey | Indiana | 18129 | 6552 | 58 |
2454746 | 2454746 | 2022-04-29 | Pulaski | Indiana | 18131 | 3080 | 86 |
2454747 | 2454747 | 2022-04-29 | Putnam | Indiana | 18133 | 9367 | 129 |
2454748 | 2454748 | 2022-04-29 | Randolph | Indiana | 18135 | 5912 | 148 |
2454749 | 2454749 | 2022-04-29 | Ripley | Indiana | 18137 | 8317 | 138 |
2454750 | 2454750 | 2022-04-29 | Rush | Indiana | 18139 | 4845 | 58 |
2454751 | 2454751 | 2022-04-29 | Scott | Indiana | 18143 | 7877 | 106 |
2454752 | 2454752 | 2022-04-29 | Shelby | Indiana | 18145 | 13611 | 182 |
2454753 | 2454753 | 2022-04-29 | Spencer | Indiana | 18147 | 5232 | 61 |
2454754 | 2454754 | 2022-04-29 | St. Joseph | Indiana | 18141 | 71191 | 872 |
2454755 | 2454755 | 2022-04-29 | Starke | Indiana | 18149 | 4762 | 99 |
2454756 | 2454756 | 2022-04-29 | Steuben | Indiana | 18151 | 9627 | 121 |
2454757 | 2454757 | 2022-04-29 | Sullivan | Indiana | 18153 | 5285 | 76 |
2454758 | 2454758 | 2022-04-29 | Switzerland | Indiana | 18155 | 2312 | 20 |
2454759 | 2454759 | 2022-04-29 | Tippecanoe | Indiana | 18157 | 50955 | 396 |
2454760 | 2454760 | 2022-04-29 | Tipton | Indiana | 18159 | 3533 | 87 |
2454761 | 2454761 | 2022-04-29 | Union | Indiana | 18161 | 2021 | 21 |
2454762 | 2454762 | 2022-04-29 | Unknown | Indiana | 0 | 4 | |
2454763 | 2454763 | 2022-04-29 | Vanderburgh | Indiana | 18163 | 57478 | 635 |
2454764 | 2454764 | 2022-04-29 | Vermillion | Indiana | 18165 | 4089 | 75 |
2454765 | 2454765 | 2022-04-29 | Vigo | Indiana | 18167 | 28931 | 413 |
2454766 | 2454766 | 2022-04-29 | Wabash | Indiana | 18169 | 8730 | 156 |
2454767 | 2454767 | 2022-04-29 | Warren | Indiana | 18171 | 2102 | 30 |
2454768 | 2454768 | 2022-04-29 | Warrick | Indiana | 18173 | 20313 | 239 |
2454769 | 2454769 | 2022-04-29 | Washington | Indiana | 18175 | 5999 | 85 |
2454770 | 2454770 | 2022-04-29 | Wayne | Indiana | 18177 | 18856 | 337 |
2454771 | 2454771 | 2022-04-29 | Wells | Indiana | 18179 | 6506 | 132 |
2454772 | 2454772 | 2022-04-29 | White | Indiana | 18181 | 6905 | 96 |
2454773 | 2454773 | 2022-04-29 | Whitley | Indiana | 18183 | 9682 | 84 |
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);