ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where "date" is on date 2021-01-06 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
901669 | 901669 | 2021-01-06 | Adams | Indiana | 18001 | 2744 | 35 |
901670 | 901670 | 2021-01-06 | Allen | Indiana | 18003 | 29418 | 534 |
901671 | 901671 | 2021-01-06 | Bartholomew | Indiana | 18005 | 5760 | 96 |
901672 | 901672 | 2021-01-06 | Benton | Indiana | 18007 | 777 | 9 |
901673 | 901673 | 2021-01-06 | Blackford | Indiana | 18009 | 981 | 22 |
901674 | 901674 | 2021-01-06 | Boone | Indiana | 18011 | 4845 | 68 |
901675 | 901675 | 2021-01-06 | Brown | Indiana | 18013 | 779 | 10 |
901676 | 901676 | 2021-01-06 | Carroll | Indiana | 18015 | 1420 | 16 |
901677 | 901677 | 2021-01-06 | Cass | Indiana | 18017 | 4379 | 47 |
901678 | 901678 | 2021-01-06 | Clark | Indiana | 18019 | 9104 | 127 |
901679 | 901679 | 2021-01-06 | Clay | Indiana | 18021 | 1961 | 32 |
901680 | 901680 | 2021-01-06 | Clinton | Indiana | 18023 | 3376 | 39 |
901681 | 901681 | 2021-01-06 | Crawford | Indiana | 18025 | 640 | 10 |
901682 | 901682 | 2021-01-06 | Daviess | Indiana | 18027 | 2379 | 73 |
901683 | 901683 | 2021-01-06 | DeKalb | Indiana | 18033 | 3162 | 63 |
901684 | 901684 | 2021-01-06 | Dearborn | Indiana | 18029 | 4075 | 43 |
901685 | 901685 | 2021-01-06 | Decatur | Indiana | 18031 | 2265 | 81 |
901686 | 901686 | 2021-01-06 | Delaware | Indiana | 18035 | 8051 | 131 |
901687 | 901687 | 2021-01-06 | Dubois | Indiana | 18037 | 4952 | 63 |
901688 | 901688 | 2021-01-06 | Elkhart | Indiana | 18039 | 23295 | 341 |
901689 | 901689 | 2021-01-06 | Fayette | Indiana | 18041 | 2410 | 45 |
901690 | 901690 | 2021-01-06 | Floyd | Indiana | 18043 | 5445 | 107 |
901691 | 901691 | 2021-01-06 | Fountain | Indiana | 18045 | 1608 | 26 |
901692 | 901692 | 2021-01-06 | Franklin | Indiana | 18047 | 1316 | 31 |
901693 | 901693 | 2021-01-06 | Fulton | Indiana | 18049 | 1458 | 28 |
901694 | 901694 | 2021-01-06 | Gibson | Indiana | 18051 | 3212 | 57 |
901695 | 901695 | 2021-01-06 | Grant | Indiana | 18053 | 5707 | 108 |
901696 | 901696 | 2021-01-06 | Greene | Indiana | 18055 | 2076 | 61 |
901697 | 901697 | 2021-01-06 | Hamilton | Indiana | 18057 | 25457 | 305 |
901698 | 901698 | 2021-01-06 | Hancock | Indiana | 18059 | 5651 | 91 |
901699 | 901699 | 2021-01-06 | Harrison | Indiana | 18061 | 2866 | 39 |
901700 | 901700 | 2021-01-06 | Hendricks | Indiana | 18063 | 12340 | 246 |
901701 | 901701 | 2021-01-06 | Henry | Indiana | 18065 | 4528 | 61 |
901702 | 901702 | 2021-01-06 | Howard | Indiana | 18067 | 7090 | 132 |
901703 | 901703 | 2021-01-06 | Huntington | Indiana | 18069 | 2583 | 51 |
901704 | 901704 | 2021-01-06 | Jackson | Indiana | 18071 | 3892 | 45 |
901705 | 901705 | 2021-01-06 | Jasper | Indiana | 18073 | 2578 | 33 |
901706 | 901706 | 2021-01-06 | Jay | Indiana | 18075 | 1553 | 23 |
901707 | 901707 | 2021-01-06 | Jefferson | Indiana | 18077 | 2259 | 42 |
901708 | 901708 | 2021-01-06 | Jennings | Indiana | 18079 | 1755 | 36 |
901709 | 901709 | 2021-01-06 | Johnson | Indiana | 18081 | 12973 | 265 |
901710 | 901710 | 2021-01-06 | Knox | Indiana | 18083 | 3033 | 39 |
901711 | 901711 | 2021-01-06 | Kosciusko | Indiana | 18085 | 7174 | 77 |
901712 | 901712 | 2021-01-06 | LaGrange | Indiana | 18087 | 2107 | 60 |
901713 | 901713 | 2021-01-06 | LaPorte | Indiana | 18091 | 7956 | 146 |
901714 | 901714 | 2021-01-06 | Lake | Indiana | 18089 | 41501 | 661 |
901715 | 901715 | 2021-01-06 | Lawrence | Indiana | 18093 | 3505 | 68 |
901716 | 901716 | 2021-01-06 | Madison | Indiana | 18095 | 9593 | 212 |
901717 | 901717 | 2021-01-06 | Marion | Indiana | 18097 | 74627 | 1268 |
901718 | 901718 | 2021-01-06 | Marshall | Indiana | 18099 | 4651 | 82 |
901719 | 901719 | 2021-01-06 | Martin | Indiana | 18101 | 634 | 13 |
901720 | 901720 | 2021-01-06 | Miami | Indiana | 18103 | 2855 | 38 |
901721 | 901721 | 2021-01-06 | Monroe | Indiana | 18105 | 8376 | 104 |
901722 | 901722 | 2021-01-06 | Montgomery | Indiana | 18107 | 2992 | 51 |
901723 | 901723 | 2021-01-06 | Morgan | Indiana | 18109 | 4586 | 87 |
901724 | 901724 | 2021-01-06 | Newton | Indiana | 18111 | 847 | 20 |
901725 | 901725 | 2021-01-06 | Noble | Indiana | 18113 | 4286 | 59 |
901726 | 901726 | 2021-01-06 | Ohio | Indiana | 18115 | 415 | 7 |
901727 | 901727 | 2021-01-06 | Orange | Indiana | 18117 | 1339 | 35 |
901728 | 901728 | 2021-01-06 | Owen | Indiana | 18119 | 1432 | 34 |
901729 | 901729 | 2021-01-06 | Parke | Indiana | 18121 | 1223 | 8 |
901730 | 901730 | 2021-01-06 | Perry | Indiana | 18123 | 1279 | 26 |
901731 | 901731 | 2021-01-06 | Pike | Indiana | 18125 | 1007 | 27 |
901732 | 901732 | 2021-01-06 | Porter | Indiana | 18127 | 13382 | 161 |
901733 | 901733 | 2021-01-06 | Posey | Indiana | 18129 | 2062 | 26 |
901734 | 901734 | 2021-01-06 | Pulaski | Indiana | 18131 | 880 | 34 |
901735 | 901735 | 2021-01-06 | Putnam | Indiana | 18133 | 2591 | 41 |
901736 | 901736 | 2021-01-06 | Randolph | Indiana | 18135 | 1948 | 38 |
901737 | 901737 | 2021-01-06 | Ripley | Indiana | 18137 | 2637 | 42 |
901738 | 901738 | 2021-01-06 | Rush | Indiana | 18139 | 1377 | 15 |
901739 | 901739 | 2021-01-06 | Scott | Indiana | 18143 | 2002 | 39 |
901740 | 901740 | 2021-01-06 | Shelby | Indiana | 18145 | 4436 | 84 |
901741 | 901741 | 2021-01-06 | Spencer | Indiana | 18147 | 1615 | 14 |
901742 | 901742 | 2021-01-06 | St. Joseph | Indiana | 18141 | 25130 | 377 |
901743 | 901743 | 2021-01-06 | Starke | Indiana | 18149 | 1607 | 44 |
901744 | 901744 | 2021-01-06 | Steuben | Indiana | 18151 | 2820 | 37 |
901745 | 901745 | 2021-01-06 | Sullivan | Indiana | 18153 | 1759 | 30 |
901746 | 901746 | 2021-01-06 | Switzerland | Indiana | 18155 | 542 | 5 |
901747 | 901747 | 2021-01-06 | Tippecanoe | Indiana | 18157 | 15873 | 102 |
901748 | 901748 | 2021-01-06 | Tipton | Indiana | 18159 | 1175 | 34 |
901749 | 901749 | 2021-01-06 | Union | Indiana | 18161 | 573 | 2 |
901750 | 901750 | 2021-01-06 | Vanderburgh | Indiana | 18163 | 16719 | 211 |
901751 | 901751 | 2021-01-06 | Vermillion | Indiana | 18165 | 1317 | 32 |
901752 | 901752 | 2021-01-06 | Vigo | Indiana | 18167 | 9746 | 167 |
901753 | 901753 | 2021-01-06 | Wabash | Indiana | 18169 | 2707 | 44 |
901754 | 901754 | 2021-01-06 | Warren | Indiana | 18171 | 593 | 8 |
901755 | 901755 | 2021-01-06 | Warrick | Indiana | 18173 | 5662 | 89 |
901756 | 901756 | 2021-01-06 | Washington | Indiana | 18175 | 1544 | 16 |
901757 | 901757 | 2021-01-06 | Wayne | Indiana | 18177 | 5835 | 151 |
901758 | 901758 | 2021-01-06 | Wells | Indiana | 18179 | 2077 | 48 |
901759 | 901759 | 2021-01-06 | White | Indiana | 18181 | 2471 | 35 |
901760 | 901760 | 2021-01-06 | Whitley | Indiana | 18183 | 2617 | 23 |
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);