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 93
- 18097 466
- 18063 464
- 18113 463
- 18001 462
- 18011 462
- 18067 461
- 18081 461
- 18141 461
- 18091 458
- 18179 458
- 18057 457
- 18005 456
- 18043 456
- 18047 455
- 18089 455
- 18019 454
- 18041 454
- 18079 454
- 18095 454
- 18119 453
- 18157 453
- 18177 453
- 18003 452
- 18053 452
- 18145 452
- 18163 452
- 18167 452
- 18035 451
- 18039 451
- 18059 451
- 18061 451
- 18103 451
- 18175 451
- 18105 450
- 18109 450
- 18133 450
- 18137 450
- 18143 450
- 18159 450
- 18037 449
- 18013 448
- 18029 448
- 18031 448
- 18051 448
- 18071 448
- 18093 448
- 18107 448
- 18115 448
- 18127 448
- 18149 448
- 18153 448
- 18173 448
- 18033 447
- 18073 447
- 18139 447
- 18045 446
- 18099 446
- 18117 446
- 18129 446
- 18171 446
- 18015 445
- 18023 445
- 18049 445
- 18065 445
- 18069 445
- 18085 445
- 18087 445
- 18135 445
- 18183 445
- 18025 444
- 18111 444
- 18155 444
- 18165 444
- 18169 444
- 18181 444
- 18021 443
- 18055 443
- 18083 443
- 18151 443
- 18017 441
- 18077 441
- 18075 440
- 18009 439
- 18147 439
- 18121 438
- 18101 437
- 18161 437
- 18027 436
- 18131 435
- 18123 431
- 18007 429
- 18125 429
- - 5
county 93
- Marion 466
- Hendricks 464
- Noble 463
- Adams 462
- Boone 462
- Howard 461
- Johnson 461
- St. Joseph 461
- LaPorte 458
- Wells 458
- Hamilton 457
- Bartholomew 456
- Floyd 456
- Franklin 455
- Lake 455
- Clark 454
- Fayette 454
- Jennings 454
- Madison 454
- Owen 453
- Tippecanoe 453
- Wayne 453
- Allen 452
- Grant 452
- Shelby 452
- Vanderburgh 452
- Vigo 452
- Delaware 451
- Elkhart 451
- Hancock 451
- Harrison 451
- Miami 451
- Washington 451
- Monroe 450
- Morgan 450
- Putnam 450
- Ripley 450
- Scott 450
- Tipton 450
- Dubois 449
- Brown 448
- Dearborn 448
- Decatur 448
- Gibson 448
- Jackson 448
- Lawrence 448
- Montgomery 448
- Ohio 448
- Porter 448
- Starke 448
- Sullivan 448
- Warrick 448
- DeKalb 447
- Jasper 447
- Rush 447
- Fountain 446
- Marshall 446
- Orange 446
- Posey 446
- Warren 446
- Carroll 445
- Clinton 445
- Fulton 445
- Henry 445
- Huntington 445
- Kosciusko 445
- LaGrange 445
- Randolph 445
- Whitley 445
- Crawford 444
- Newton 444
- Switzerland 444
- Vermillion 444
- Wabash 444
- White 444
- Clay 443
- Greene 443
- Knox 443
- Steuben 443
- Cass 441
- Jefferson 441
- Jay 440
- Blackford 439
- Spencer 439
- Parke 438
- Martin 437
- Union 437
- Daviess 436
- Pulaski 435
- Perry 431
- Benton 429
- Pike 429
- Unknown 5
state 1
- Indiana · 41,250 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1417833 | 1417833 | 2021-06-14 | Adams | Indiana | 18001 | 3513 | 56 |
1417834 | 1417834 | 2021-06-14 | Allen | Indiana | 18003 | 41691 | 712 |
1417835 | 1417835 | 2021-06-14 | Bartholomew | Indiana | 18005 | 8184 | 162 |
1417836 | 1417836 | 2021-06-14 | Benton | Indiana | 18007 | 1010 | 14 |
1417837 | 1417837 | 2021-06-14 | Blackford | Indiana | 18009 | 1373 | 32 |
1417838 | 1417838 | 2021-06-14 | Boone | Indiana | 18011 | 6936 | 107 |
1417839 | 1417839 | 2021-06-14 | Brown | Indiana | 18013 | 1039 | 43 |
1417840 | 1417840 | 2021-06-14 | Carroll | Indiana | 18015 | 1936 | 22 |
1417841 | 1417841 | 2021-06-14 | Cass | Indiana | 18017 | 5996 | 110 |
1417842 | 1417842 | 2021-06-14 | Clark | Indiana | 18019 | 13221 | 202 |
1417843 | 1417843 | 2021-06-14 | Clay | Indiana | 18021 | 2658 | 48 |
1417844 | 1417844 | 2021-06-14 | Clinton | Indiana | 18023 | 4405 | 60 |
1417845 | 1417845 | 2021-06-14 | Crawford | Indiana | 18025 | 1024 | 17 |
1417846 | 1417846 | 2021-06-14 | Daviess | Indiana | 18027 | 3033 | 102 |
1417847 | 1417847 | 2021-06-14 | DeKalb | Indiana | 18033 | 4391 | 88 |
1417848 | 1417848 | 2021-06-14 | Dearborn | Indiana | 18029 | 5898 | 81 |
1417849 | 1417849 | 2021-06-14 | Decatur | Indiana | 18031 | 2955 | 96 |
1417850 | 1417850 | 2021-06-14 | Delaware | Indiana | 18035 | 10962 | 205 |
1417851 | 1417851 | 2021-06-14 | Dubois | Indiana | 18037 | 6212 | 119 |
1417852 | 1417852 | 2021-06-14 | Elkhart | Indiana | 18039 | 29463 | 474 |
1417853 | 1417853 | 2021-06-14 | Fayette | Indiana | 18041 | 2985 | 66 |
1417854 | 1417854 | 2021-06-14 | Floyd | Indiana | 18043 | 7782 | 185 |
1417855 | 1417855 | 2021-06-14 | Fountain | Indiana | 18045 | 2188 | 48 |
1417856 | 1417856 | 2021-06-14 | Franklin | Indiana | 18047 | 1721 | 36 |
1417857 | 1417857 | 2021-06-14 | Fulton | Indiana | 18049 | 2016 | 42 |
1417858 | 1417858 | 2021-06-14 | Gibson | Indiana | 18051 | 4445 | 96 |
1417859 | 1417859 | 2021-06-14 | Grant | Indiana | 18053 | 7641 | 186 |
1417860 | 1417860 | 2021-06-14 | Greene | Indiana | 18055 | 2872 | 89 |
1417861 | 1417861 | 2021-06-14 | Hamilton | Indiana | 18057 | 36573 | 435 |
1417862 | 1417862 | 2021-06-14 | Hancock | Indiana | 18059 | 8573 | 148 |
1417863 | 1417863 | 2021-06-14 | Harrison | Indiana | 18061 | 4410 | 75 |
1417864 | 1417864 | 2021-06-14 | Hendricks | Indiana | 18063 | 17652 | 338 |
1417865 | 1417865 | 2021-06-14 | Henry | Indiana | 18065 | 5908 | 110 |
1417866 | 1417866 | 2021-06-14 | Howard | Indiana | 18067 | 10272 | 228 |
1417867 | 1417867 | 2021-06-14 | Huntington | Indiana | 18069 | 4027 | 83 |
1417868 | 1417868 | 2021-06-14 | Jackson | Indiana | 18071 | 5090 | 75 |
1417869 | 1417869 | 2021-06-14 | Jasper | Indiana | 18073 | 3873 | 56 |
1417870 | 1417870 | 2021-06-14 | Jay | Indiana | 18075 | 2021 | 35 |
1417871 | 1417871 | 2021-06-14 | Jefferson | Indiana | 18077 | 3357 | 86 |
1417872 | 1417872 | 2021-06-14 | Jennings | Indiana | 18079 | 2355 | 51 |
1417873 | 1417873 | 2021-06-14 | Johnson | Indiana | 18081 | 18472 | 405 |
1417874 | 1417874 | 2021-06-14 | Knox | Indiana | 18083 | 3759 | 90 |
1417875 | 1417875 | 2021-06-14 | Kosciusko | Indiana | 18085 | 9635 | 124 |
1417876 | 1417876 | 2021-06-14 | LaGrange | Indiana | 18087 | 2733 | 74 |
1417877 | 1417877 | 2021-06-14 | LaPorte | Indiana | 18091 | 12405 | 223 |
1417878 | 1417878 | 2021-06-14 | Lake | Indiana | 18089 | 55549 | 1046 |
1417879 | 1417879 | 2021-06-14 | Lawrence | Indiana | 18093 | 4735 | 124 |
1417880 | 1417880 | 2021-06-14 | Madison | Indiana | 18095 | 13150 | 364 |
1417881 | 1417881 | 2021-06-14 | Marion | Indiana | 18097 | 103294 | 1840 |
1417882 | 1417882 | 2021-06-14 | Marshall | Indiana | 18099 | 6210 | 118 |
1417883 | 1417883 | 2021-06-14 | Martin | Indiana | 18101 | 916 | 15 |
1417884 | 1417884 | 2021-06-14 | Miami | Indiana | 18103 | 3933 | 69 |
1417885 | 1417885 | 2021-06-14 | Monroe | Indiana | 18105 | 12166 | 177 |
1417886 | 1417886 | 2021-06-14 | Montgomery | Indiana | 18107 | 4349 | 92 |
1417887 | 1417887 | 2021-06-14 | Morgan | Indiana | 18109 | 6753 | 146 |
1417888 | 1417888 | 2021-06-14 | Newton | Indiana | 18111 | 1129 | 38 |
1417889 | 1417889 | 2021-06-14 | Noble | Indiana | 18113 | 5805 | 89 |
1417890 | 1417890 | 2021-06-14 | Ohio | Indiana | 18115 | 578 | 11 |
1417891 | 1417891 | 2021-06-14 | Orange | Indiana | 18117 | 1884 | 58 |
1417892 | 1417892 | 2021-06-14 | Owen | Indiana | 18119 | 2113 | 60 |
1417893 | 1417893 | 2021-06-14 | Parke | Indiana | 18121 | 1504 | 16 |
1417894 | 1417894 | 2021-06-14 | Perry | Indiana | 18123 | 1879 | 38 |
1417895 | 1417895 | 2021-06-14 | Pike | Indiana | 18125 | 1380 | 34 |
1417896 | 1417896 | 2021-06-14 | Porter | Indiana | 18127 | 19351 | 336 |
1417897 | 1417897 | 2021-06-14 | Posey | Indiana | 18129 | 2737 | 35 |
1417898 | 1417898 | 2021-06-14 | Pulaski | Indiana | 18131 | 1204 | 47 |
1417899 | 1417899 | 2021-06-14 | Putnam | Indiana | 18133 | 3730 | 60 |
1417900 | 1417900 | 2021-06-14 | Randolph | Indiana | 18135 | 2487 | 84 |
1417901 | 1417901 | 2021-06-14 | Ripley | Indiana | 18137 | 3468 | 71 |
1417902 | 1417902 | 2021-06-14 | Rush | Indiana | 18139 | 1826 | 26 |
1417903 | 1417903 | 2021-06-14 | Scott | Indiana | 18143 | 2706 | 57 |
1417904 | 1417904 | 2021-06-14 | Shelby | Indiana | 18145 | 5995 | 107 |
1417905 | 1417905 | 2021-06-14 | Spencer | Indiana | 18147 | 2344 | 31 |
1417906 | 1417906 | 2021-06-14 | St. Joseph | Indiana | 18141 | 36982 | 582 |
1417907 | 1417907 | 2021-06-14 | Starke | Indiana | 18149 | 2278 | 60 |
1417908 | 1417908 | 2021-06-14 | Steuben | Indiana | 18151 | 3998 | 61 |
1417909 | 1417909 | 2021-06-14 | Sullivan | Indiana | 18153 | 2143 | 43 |
1417910 | 1417910 | 2021-06-14 | Switzerland | Indiana | 18155 | 810 | 8 |
1417911 | 1417911 | 2021-06-14 | Tippecanoe | Indiana | 18157 | 22867 | 227 |
1417912 | 1417912 | 2021-06-14 | Tipton | Indiana | 18159 | 1662 | 48 |
1417913 | 1417913 | 2021-06-14 | Union | Indiana | 18161 | 756 | 11 |
1417914 | 1417914 | 2021-06-14 | Vanderburgh | Indiana | 18163 | 22551 | 405 |
1417915 | 1417915 | 2021-06-14 | Vermillion | Indiana | 18165 | 1737 | 44 |
1417916 | 1417916 | 2021-06-14 | Vigo | Indiana | 18167 | 12616 | 258 |
1417917 | 1417917 | 2021-06-14 | Wabash | Indiana | 18169 | 3609 | 83 |
1417918 | 1417918 | 2021-06-14 | Warren | Indiana | 18171 | 838 | 16 |
1417919 | 1417919 | 2021-06-14 | Warrick | Indiana | 18173 | 7857 | 159 |
1417920 | 1417920 | 2021-06-14 | Washington | Indiana | 18175 | 2449 | 34 |
1417921 | 1417921 | 2021-06-14 | Wayne | Indiana | 18177 | 7538 | 205 |
1417922 | 1417922 | 2021-06-14 | Wells | Indiana | 18179 | 2977 | 83 |
1417923 | 1417923 | 2021-06-14 | White | Indiana | 18181 | 3303 | 54 |
1417924 | 1417924 | 2021-06-14 | Whitley | Indiana | 18183 | 4060 | 42 |
1414587 | 1414587 | 2021-06-13 | Adams | Indiana | 18001 | 3513 | 56 |
1414588 | 1414588 | 2021-06-13 | Allen | Indiana | 18003 | 41668 | 712 |
1414589 | 1414589 | 2021-06-13 | Bartholomew | Indiana | 18005 | 8180 | 162 |
1414590 | 1414590 | 2021-06-13 | Benton | Indiana | 18007 | 1008 | 14 |
1414591 | 1414591 | 2021-06-13 | Blackford | Indiana | 18009 | 1372 | 32 |
1414592 | 1414592 | 2021-06-13 | Boone | Indiana | 18011 | 6930 | 107 |
1414593 | 1414593 | 2021-06-13 | Brown | Indiana | 18013 | 1039 | 43 |
1414594 | 1414594 | 2021-06-13 | Carroll | Indiana | 18015 | 1936 | 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);