ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
71,921 rows where state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 18097 397
- 18063 395
- 18113 394
- 18001 393
- 18011 393
- 18067 392
- 18081 392
- 18141 392
- 18091 389
- 18179 389
- 18057 388
- 18005 387
- 18043 387
- 18047 386
- 18089 386
- 18019 385
- 18041 385
- 18079 385
- 18095 385
- 18119 384
- 18157 384
- 18177 384
- 18003 383
- 18053 383
- 18145 383
- 18163 383
- 18167 383
- 18035 382
- 18039 382
- 18059 382
- …
county >30
- Marion 397
- Hendricks 395
- Noble 394
- Adams 393
- Boone 393
- Howard 392
- Johnson 392
- St. Joseph 392
- LaPorte 389
- Wells 389
- Hamilton 388
- Bartholomew 387
- Floyd 387
- Franklin 386
- Lake 386
- Clark 385
- Fayette 385
- Jennings 385
- Madison 385
- Owen 384
- Tippecanoe 384
- Wayne 384
- Allen 383
- Grant 383
- Shelby 383
- Vanderburgh 383
- Vigo 383
- Delaware 382
- Elkhart 382
- Hancock 382
- …
state 1
- Indiana · 34,902 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193812 | 1193812 | 2021-04-06 | Adams | Indiana | 18001 | 3418 | 53 |
1193813 | 1193813 | 2021-04-06 | Allen | Indiana | 18003 | 38233 | 687 |
1193814 | 1193814 | 2021-04-06 | Bartholomew | Indiana | 18005 | 7771 | 157 |
1193815 | 1193815 | 2021-04-06 | Benton | Indiana | 18007 | 938 | 13 |
1193816 | 1193816 | 2021-04-06 | Blackford | Indiana | 18009 | 1320 | 29 |
1193817 | 1193817 | 2021-04-06 | Boone | Indiana | 18011 | 6437 | 103 |
1193818 | 1193818 | 2021-04-06 | Brown | Indiana | 18013 | 973 | 40 |
1193819 | 1193819 | 2021-04-06 | Carroll | Indiana | 18015 | 1829 | 22 |
1193820 | 1193820 | 2021-04-06 | Cass | Indiana | 18017 | 5641 | 103 |
1193821 | 1193821 | 2021-04-06 | Clark | Indiana | 18019 | 12545 | 196 |
1193822 | 1193822 | 2021-04-06 | Clay | Indiana | 18021 | 2487 | 44 |
1193823 | 1193823 | 2021-04-06 | Clinton | Indiana | 18023 | 4098 | 58 |
1193824 | 1193824 | 2021-04-06 | Crawford | Indiana | 18025 | 966 | 14 |
1193825 | 1193825 | 2021-04-06 | Daviess | Indiana | 18027 | 2879 | 100 |
1193826 | 1193826 | 2021-04-06 | DeKalb | Indiana | 18033 | 4001 | 85 |
1193827 | 1193827 | 2021-04-06 | Dearborn | Indiana | 18029 | 5635 | 76 |
1193828 | 1193828 | 2021-04-06 | Decatur | Indiana | 18031 | 2825 | 96 |
1193829 | 1193829 | 2021-04-06 | Delaware | Indiana | 18035 | 10191 | 188 |
1193830 | 1193830 | 2021-04-06 | Dubois | Indiana | 18037 | 6043 | 117 |
1193831 | 1193831 | 2021-04-06 | Elkhart | Indiana | 18039 | 26680 | 444 |
1193832 | 1193832 | 2021-04-06 | Fayette | Indiana | 18041 | 2895 | 63 |
1193833 | 1193833 | 2021-04-06 | Floyd | Indiana | 18043 | 7477 | 180 |
1193834 | 1193834 | 2021-04-06 | Fountain | Indiana | 18045 | 2067 | 45 |
1193835 | 1193835 | 2021-04-06 | Franklin | Indiana | 18047 | 1655 | 36 |
1193836 | 1193836 | 2021-04-06 | Fulton | Indiana | 18049 | 1877 | 39 |
1193837 | 1193837 | 2021-04-06 | Gibson | Indiana | 18051 | 4236 | 90 |
1193838 | 1193838 | 2021-04-06 | Grant | Indiana | 18053 | 7102 | 174 |
1193839 | 1193839 | 2021-04-06 | Greene | Indiana | 18055 | 2685 | 89 |
1193840 | 1193840 | 2021-04-06 | Hamilton | Indiana | 18057 | 33795 | 423 |
1193841 | 1193841 | 2021-04-06 | Hancock | Indiana | 18059 | 7793 | 140 |
1193842 | 1193842 | 2021-04-06 | Harrison | Indiana | 18061 | 4231 | 72 |
1193843 | 1193843 | 2021-04-06 | Hendricks | Indiana | 18063 | 16583 | 327 |
1193844 | 1193844 | 2021-04-06 | Henry | Indiana | 18065 | 5542 | 102 |
1193845 | 1193845 | 2021-04-06 | Howard | Indiana | 18067 | 9510 | 215 |
1193846 | 1193846 | 2021-04-06 | Huntington | Indiana | 18069 | 3700 | 82 |
1193847 | 1193847 | 2021-04-06 | Jackson | Indiana | 18071 | 4871 | 70 |
1193848 | 1193848 | 2021-04-06 | Jasper | Indiana | 18073 | 3381 | 48 |
1193849 | 1193849 | 2021-04-06 | Jay | Indiana | 18075 | 1849 | 30 |
1193850 | 1193850 | 2021-04-06 | Jefferson | Indiana | 18077 | 3035 | 79 |
1193851 | 1193851 | 2021-04-06 | Jennings | Indiana | 18079 | 2234 | 48 |
1193852 | 1193852 | 2021-04-06 | Johnson | Indiana | 18081 | 17257 | 386 |
1193853 | 1193853 | 2021-04-06 | Knox | Indiana | 18083 | 3624 | 88 |
1193854 | 1193854 | 2021-04-06 | Kosciusko | Indiana | 18085 | 8944 | 116 |
1193855 | 1193855 | 2021-04-06 | LaGrange | Indiana | 18087 | 2482 | 72 |
1193856 | 1193856 | 2021-04-06 | LaPorte | Indiana | 18091 | 10459 | 206 |
1193857 | 1193857 | 2021-04-06 | Lake | Indiana | 18089 | 50478 | 962 |
1193858 | 1193858 | 2021-04-06 | Lawrence | Indiana | 18093 | 4271 | 120 |
1193859 | 1193859 | 2021-04-06 | Madison | Indiana | 18095 | 12182 | 354 |
1193860 | 1193860 | 2021-04-06 | Marion | Indiana | 18097 | 94507 | 1763 |
1193861 | 1193861 | 2021-04-06 | Marshall | Indiana | 18099 | 5655 | 109 |
1193862 | 1193862 | 2021-04-06 | Martin | Indiana | 18101 | 820 | 15 |
1193863 | 1193863 | 2021-04-06 | Miami | Indiana | 18103 | 3696 | 66 |
1193864 | 1193864 | 2021-04-06 | Monroe | Indiana | 18105 | 11076 | 168 |
1193865 | 1193865 | 2021-04-06 | Montgomery | Indiana | 18107 | 4109 | 87 |
1193866 | 1193866 | 2021-04-06 | Morgan | Indiana | 18109 | 6330 | 139 |
1193867 | 1193867 | 2021-04-06 | Newton | Indiana | 18111 | 1017 | 35 |
1193868 | 1193868 | 2021-04-06 | Noble | Indiana | 18113 | 5295 | 85 |
1193869 | 1193869 | 2021-04-06 | Ohio | Indiana | 18115 | 552 | 11 |
1193870 | 1193870 | 2021-04-06 | Orange | Indiana | 18117 | 1754 | 55 |
1193871 | 1193871 | 2021-04-06 | Owen | Indiana | 18119 | 1891 | 58 |
1193872 | 1193872 | 2021-04-06 | Parke | Indiana | 18121 | 1443 | 16 |
1193873 | 1193873 | 2021-04-06 | Perry | Indiana | 18123 | 1793 | 37 |
1193874 | 1193874 | 2021-04-06 | Pike | Indiana | 18125 | 1293 | 34 |
1193875 | 1193875 | 2021-04-06 | Porter | Indiana | 18127 | 16836 | 304 |
1193876 | 1193876 | 2021-04-06 | Posey | Indiana | 18129 | 2667 | 33 |
1193877 | 1193877 | 2021-04-06 | Pulaski | Indiana | 18131 | 1113 | 45 |
1193878 | 1193878 | 2021-04-06 | Putnam | Indiana | 18133 | 3502 | 60 |
1193879 | 1193879 | 2021-04-06 | Randolph | Indiana | 18135 | 2364 | 80 |
1193880 | 1193880 | 2021-04-06 | Ripley | Indiana | 18137 | 3317 | 67 |
1193881 | 1193881 | 2021-04-06 | Rush | Indiana | 18139 | 1751 | 24 |
1193882 | 1193882 | 2021-04-06 | Scott | Indiana | 18143 | 2580 | 55 |
1193883 | 1193883 | 2021-04-06 | Shelby | Indiana | 18145 | 5684 | 105 |
1193884 | 1193884 | 2021-04-06 | Spencer | Indiana | 18147 | 2264 | 31 |
1193885 | 1193885 | 2021-04-06 | St. Joseph | Indiana | 18141 | 32817 | 548 |
1193886 | 1193886 | 2021-04-06 | Starke | Indiana | 18149 | 1970 | 54 |
1193887 | 1193887 | 2021-04-06 | Steuben | Indiana | 18151 | 3550 | 59 |
1193888 | 1193888 | 2021-04-06 | Sullivan | Indiana | 18153 | 2071 | 41 |
1193889 | 1193889 | 2021-04-06 | Switzerland | Indiana | 18155 | 766 | 8 |
1193890 | 1193890 | 2021-04-06 | Tippecanoe | Indiana | 18157 | 21196 | 213 |
1193891 | 1193891 | 2021-04-06 | Tipton | Indiana | 18159 | 1596 | 45 |
1193892 | 1193892 | 2021-04-06 | Union | Indiana | 18161 | 720 | 11 |
1193893 | 1193893 | 2021-04-06 | Vanderburgh | Indiana | 18163 | 21856 | 397 |
1193894 | 1193894 | 2021-04-06 | Vermillion | Indiana | 18165 | 1648 | 43 |
1193895 | 1193895 | 2021-04-06 | Vigo | Indiana | 18167 | 12050 | 246 |
1193896 | 1193896 | 2021-04-06 | Wabash | Indiana | 18169 | 3433 | 77 |
1193897 | 1193897 | 2021-04-06 | Warren | Indiana | 18171 | 779 | 16 |
1193898 | 1193898 | 2021-04-06 | Warrick | Indiana | 18173 | 7629 | 158 |
1193899 | 1193899 | 2021-04-06 | Washington | Indiana | 18175 | 2252 | 29 |
1193900 | 1193900 | 2021-04-06 | Wayne | Indiana | 18177 | 7203 | 200 |
1193901 | 1193901 | 2021-04-06 | Wells | Indiana | 18179 | 2837 | 82 |
1193902 | 1193902 | 2021-04-06 | White | Indiana | 18181 | 3045 | 55 |
1193903 | 1193903 | 2021-04-06 | Whitley | Indiana | 18183 | 3680 | 39 |
1190562 | 1190562 | 2021-04-05 | Adams | Indiana | 18001 | 3418 | 53 |
1190563 | 1190563 | 2021-04-05 | Allen | Indiana | 18003 | 38192 | 686 |
1190564 | 1190564 | 2021-04-05 | Bartholomew | Indiana | 18005 | 7767 | 157 |
1190565 | 1190565 | 2021-04-05 | Benton | Indiana | 18007 | 937 | 13 |
1190566 | 1190566 | 2021-04-05 | Blackford | Indiana | 18009 | 1320 | 29 |
1190567 | 1190567 | 2021-04-05 | Boone | Indiana | 18011 | 6433 | 103 |
1190568 | 1190568 | 2021-04-05 | Brown | Indiana | 18013 | 973 | 40 |
1190569 | 1190569 | 2021-04-05 | Carroll | Indiana | 18015 | 1828 | 22 |
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);