ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where date = "2020-10-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 |
---|---|---|---|---|---|---|---|
677767 | 677767 | 2020-10-29 | Adams | Indiana | 18001 | 634 | 8 |
677768 | 677768 | 2020-10-29 | Allen | Indiana | 18003 | 9158 | 246 |
677769 | 677769 | 2020-10-29 | Bartholomew | Indiana | 18005 | 1547 | 63 |
677770 | 677770 | 2020-10-29 | Benton | Indiana | 18007 | 116 | 0 |
677771 | 677771 | 2020-10-29 | Blackford | Indiana | 18009 | 266 | 5 |
677772 | 677772 | 2020-10-29 | Boone | Indiana | 18011 | 1367 | 53 |
677773 | 677773 | 2020-10-29 | Brown | Indiana | 18013 | 152 | 3 |
677774 | 677774 | 2020-10-29 | Carroll | Indiana | 18015 | 364 | 13 |
677775 | 677775 | 2020-10-29 | Cass | Indiana | 18017 | 2348 | 27 |
677776 | 677776 | 2020-10-29 | Clark | Indiana | 18019 | 3207 | 72 |
677777 | 677777 | 2020-10-29 | Clay | Indiana | 18021 | 492 | 7 |
677778 | 677778 | 2020-10-29 | Clinton | Indiana | 18023 | 982 | 20 |
677779 | 677779 | 2020-10-29 | Crawford | Indiana | 18025 | 170 | 2 |
677780 | 677780 | 2020-10-29 | Daviess | Indiana | 18027 | 962 | 38 |
677781 | 677781 | 2020-10-29 | DeKalb | Indiana | 18033 | 826 | 14 |
677782 | 677782 | 2020-10-29 | Dearborn | Indiana | 18029 | 1104 | 30 |
677783 | 677783 | 2020-10-29 | Decatur | Indiana | 18031 | 591 | 42 |
677784 | 677784 | 2020-10-29 | Delaware | Indiana | 18035 | 3269 | 79 |
677785 | 677785 | 2020-10-29 | Dubois | Indiana | 18037 | 1557 | 27 |
677786 | 677786 | 2020-10-29 | Elkhart | Indiana | 18039 | 9875 | 150 |
677787 | 677787 | 2020-10-29 | Fayette | Indiana | 18041 | 972 | 22 |
677788 | 677788 | 2020-10-29 | Floyd | Indiana | 18043 | 1939 | 72 |
677789 | 677789 | 2020-10-29 | Fountain | Indiana | 18045 | 365 | 3 |
677790 | 677790 | 2020-10-29 | Franklin | Indiana | 18047 | 407 | 26 |
677791 | 677791 | 2020-10-29 | Fulton | Indiana | 18049 | 417 | 9 |
677792 | 677792 | 2020-10-29 | Gibson | Indiana | 18051 | 984 | 12 |
677793 | 677793 | 2020-10-29 | Grant | Indiana | 18053 | 1821 | 43 |
677794 | 677794 | 2020-10-29 | Greene | Indiana | 18055 | 613 | 41 |
677795 | 677795 | 2020-10-29 | Hamilton | Indiana | 18057 | 6730 | 129 |
677796 | 677796 | 2020-10-29 | Hancock | Indiana | 18059 | 1319 | 47 |
677797 | 677797 | 2020-10-29 | Harrison | Indiana | 18061 | 838 | 26 |
677798 | 677798 | 2020-10-29 | Hendricks | Indiana | 18063 | 3568 | 156 |
677799 | 677799 | 2020-10-29 | Henry | Indiana | 18065 | 1418 | 31 |
677800 | 677800 | 2020-10-29 | Howard | Indiana | 18067 | 1770 | 70 |
677801 | 677801 | 2020-10-29 | Huntington | Indiana | 18069 | 501 | 5 |
677802 | 677802 | 2020-10-29 | Jackson | Indiana | 18071 | 1258 | 21 |
677803 | 677803 | 2020-10-29 | Jasper | Indiana | 18073 | 741 | 6 |
677804 | 677804 | 2020-10-29 | Jay | Indiana | 18075 | 390 | 7 |
677805 | 677805 | 2020-10-29 | Jefferson | Indiana | 18077 | 417 | 5 |
677806 | 677806 | 2020-10-29 | Jennings | Indiana | 18079 | 405 | 15 |
677807 | 677807 | 2020-10-29 | Johnson | Indiana | 18081 | 3479 | 141 |
677808 | 677808 | 2020-10-29 | Knox | Indiana | 18083 | 893 | 10 |
677809 | 677809 | 2020-10-29 | Kosciusko | Indiana | 18085 | 2214 | 30 |
677810 | 677810 | 2020-10-29 | LaGrange | Indiana | 18087 | 855 | 16 |
677811 | 677811 | 2020-10-29 | LaPorte | Indiana | 18091 | 2492 | 67 |
677812 | 677812 | 2020-10-29 | Lake | Indiana | 18089 | 15134 | 389 |
677813 | 677813 | 2020-10-29 | Lawrence | Indiana | 18093 | 1044 | 40 |
677814 | 677814 | 2020-10-29 | Madison | Indiana | 18095 | 2721 | 109 |
677815 | 677815 | 2020-10-29 | Marion | Indiana | 18097 | 26979 | 850 |
677816 | 677816 | 2020-10-29 | Marshall | Indiana | 18099 | 1549 | 30 |
677817 | 677817 | 2020-10-29 | Martin | Indiana | 18101 | 208 | 0 |
677818 | 677818 | 2020-10-29 | Miami | Indiana | 18103 | 725 | 5 |
677819 | 677819 | 2020-10-29 | Monroe | Indiana | 18105 | 3455 | 42 |
677820 | 677820 | 2020-10-29 | Montgomery | Indiana | 18107 | 668 | 23 |
677821 | 677821 | 2020-10-29 | Morgan | Indiana | 18109 | 1043 | 43 |
677822 | 677822 | 2020-10-29 | Newton | Indiana | 18111 | 245 | 12 |
677823 | 677823 | 2020-10-29 | Noble | Indiana | 18113 | 1297 | 36 |
677824 | 677824 | 2020-10-29 | Ohio | Indiana | 18115 | 145 | 7 |
677825 | 677825 | 2020-10-29 | Orange | Indiana | 18117 | 438 | 27 |
677826 | 677826 | 2020-10-29 | Owen | Indiana | 18119 | 226 | 2 |
677827 | 677827 | 2020-10-29 | Parke | Indiana | 18121 | 285 | 4 |
677828 | 677828 | 2020-10-29 | Perry | Indiana | 18123 | 432 | 15 |
677829 | 677829 | 2020-10-29 | Pike | Indiana | 18125 | 370 | 18 |
677830 | 677830 | 2020-10-29 | Porter | Indiana | 18127 | 3735 | 53 |
677831 | 677831 | 2020-10-29 | Posey | Indiana | 18129 | 805 | 8 |
677832 | 677832 | 2020-10-29 | Pulaski | Indiana | 18131 | 189 | 4 |
677833 | 677833 | 2020-10-29 | Putnam | Indiana | 18133 | 807 | 17 |
677834 | 677834 | 2020-10-29 | Randolph | Indiana | 18135 | 479 | 11 |
677835 | 677835 | 2020-10-29 | Ripley | Indiana | 18137 | 518 | 8 |
677836 | 677836 | 2020-10-29 | Rush | Indiana | 18139 | 319 | 4 |
677837 | 677837 | 2020-10-29 | Scott | Indiana | 18143 | 585 | 18 |
677838 | 677838 | 2020-10-29 | Shelby | Indiana | 18145 | 1477 | 45 |
677839 | 677839 | 2020-10-29 | Spencer | Indiana | 18147 | 446 | 6 |
677840 | 677840 | 2020-10-29 | St. Joseph | Indiana | 18141 | 10114 | 182 |
677841 | 677841 | 2020-10-29 | Starke | Indiana | 18149 | 494 | 10 |
677842 | 677842 | 2020-10-29 | Steuben | Indiana | 18151 | 710 | 9 |
677843 | 677843 | 2020-10-29 | Sullivan | Indiana | 18153 | 486 | 14 |
677844 | 677844 | 2020-10-29 | Switzerland | Indiana | 18155 | 109 | 0 |
677845 | 677845 | 2020-10-29 | Tippecanoe | Indiana | 18157 | 4249 | 17 |
677846 | 677846 | 2020-10-29 | Tipton | Indiana | 18159 | 299 | 26 |
677847 | 677847 | 2020-10-29 | Union | Indiana | 18161 | 155 | 0 |
677848 | 677848 | 2020-10-29 | Vanderburgh | Indiana | 18163 | 6409 | 72 |
677849 | 677849 | 2020-10-29 | Vermillion | Indiana | 18165 | 292 | 1 |
677850 | 677850 | 2020-10-29 | Vigo | Indiana | 18167 | 2937 | 43 |
677851 | 677851 | 2020-10-29 | Wabash | Indiana | 18169 | 512 | 9 |
677852 | 677852 | 2020-10-29 | Warren | Indiana | 18171 | 103 | 1 |
677853 | 677853 | 2020-10-29 | Warrick | Indiana | 18173 | 2123 | 68 |
677854 | 677854 | 2020-10-29 | Washington | Indiana | 18175 | 414 | 3 |
677855 | 677855 | 2020-10-29 | Wayne | Indiana | 18177 | 1960 | 34 |
677856 | 677856 | 2020-10-29 | Wells | Indiana | 18179 | 528 | 14 |
677857 | 677857 | 2020-10-29 | White | Indiana | 18181 | 658 | 16 |
677858 | 677858 | 2020-10-29 | Whitley | Indiana | 18183 | 521 | 6 |
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);