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 679
- 18063 677
- 18113 676
- 18001 675
- 18011 675
- 18067 674
- 18081 674
- 18141 674
- 18091 671
- 18179 671
- 18057 670
- 18005 669
- 18043 669
- 18047 668
- 18089 668
- 18019 667
- 18041 667
- 18079 667
- 18095 667
- 18119 666
- 18157 666
- 18177 666
- 18003 665
- 18053 665
- 18145 665
- 18163 665
- 18167 665
- 18035 664
- 18039 664
- 18059 664
- 18061 664
- 18103 664
- 18175 664
- 18105 663
- 18109 663
- 18133 663
- 18137 663
- 18143 663
- 18159 663
- 18037 662
- 18013 661
- 18029 661
- 18031 661
- 18051 661
- 18071 661
- 18093 661
- 18107 661
- 18115 661
- 18127 661
- 18149 661
- 18153 661
- 18173 661
- 18033 660
- 18073 660
- 18139 660
- 18045 659
- 18099 659
- 18117 659
- 18129 659
- 18171 659
- 18015 658
- 18023 658
- 18049 658
- 18065 658
- 18069 658
- 18085 658
- 18087 658
- 18135 658
- 18183 658
- 18025 657
- 18111 657
- 18155 657
- 18165 657
- 18169 657
- 18181 657
- 18021 656
- 18055 656
- 18083 656
- 18151 656
- 18017 654
- 18077 654
- 18075 653
- 18009 652
- 18147 652
- 18121 651
- 18101 650
- 18161 650
- 18027 649
- 18131 648
- 18123 644
- 18007 642
- 18125 642
- - 5
county 93
- Marion 679
- Hendricks 677
- Noble 676
- Adams 675
- Boone 675
- Howard 674
- Johnson 674
- St. Joseph 674
- LaPorte 671
- Wells 671
- Hamilton 670
- Bartholomew 669
- Floyd 669
- Franklin 668
- Lake 668
- Clark 667
- Fayette 667
- Jennings 667
- Madison 667
- Owen 666
- Tippecanoe 666
- Wayne 666
- Allen 665
- Grant 665
- Shelby 665
- Vanderburgh 665
- Vigo 665
- Delaware 664
- Elkhart 664
- Hancock 664
- Harrison 664
- Miami 664
- Washington 664
- Monroe 663
- Morgan 663
- Putnam 663
- Ripley 663
- Scott 663
- Tipton 663
- Dubois 662
- Brown 661
- Dearborn 661
- Decatur 661
- Gibson 661
- Jackson 661
- Lawrence 661
- Montgomery 661
- Ohio 661
- Porter 661
- Starke 661
- Sullivan 661
- Warrick 661
- DeKalb 660
- Jasper 660
- Rush 660
- Fountain 659
- Marshall 659
- Orange 659
- Posey 659
- Warren 659
- Carroll 658
- Clinton 658
- Fulton 658
- Henry 658
- Huntington 658
- Kosciusko 658
- LaGrange 658
- Randolph 658
- Whitley 658
- Crawford 657
- Newton 657
- Switzerland 657
- Vermillion 657
- Wabash 657
- White 657
- Clay 656
- Greene 656
- Knox 656
- Steuben 656
- Cass 654
- Jefferson 654
- Jay 653
- Blackford 652
- Spencer 652
- Parke 651
- Martin 650
- Union 650
- Daviess 649
- Pulaski 648
- Perry 644
- Benton 642
- Pike 642
- Unknown 5
state 1
- Indiana · 60,846 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2109834 | 2109834 | 2022-01-13 | Adams | Indiana | 18001 | 6395 | 101 |
2109835 | 2109835 | 2022-01-13 | Allen | Indiana | 18003 | 86748 | 1031 |
2109836 | 2109836 | 2022-01-13 | Bartholomew | Indiana | 18005 | 16648 | 216 |
2109837 | 2109837 | 2022-01-13 | Benton | Indiana | 18007 | 2053 | 21 |
2109838 | 2109838 | 2022-01-13 | Blackford | Indiana | 18009 | 2612 | 57 |
2109839 | 2109839 | 2022-01-13 | Boone | Indiana | 18011 | 12761 | 144 |
2109840 | 2109840 | 2022-01-13 | Brown | Indiana | 18013 | 2170 | 56 |
2109841 | 2109841 | 2022-01-13 | Carroll | Indiana | 18015 | 3588 | 53 |
2109842 | 2109842 | 2022-01-13 | Cass | Indiana | 18017 | 9516 | 146 |
2109843 | 2109843 | 2022-01-13 | Clark | Indiana | 18019 | 24334 | 331 |
2109844 | 2109844 | 2022-01-13 | Clay | Indiana | 18021 | 5704 | 74 |
2109845 | 2109845 | 2022-01-13 | Clinton | Indiana | 18023 | 7740 | 100 |
2109846 | 2109846 | 2022-01-13 | Crawford | Indiana | 18025 | 2038 | 32 |
2109847 | 2109847 | 2022-01-13 | Daviess | Indiana | 18027 | 6060 | 128 |
2109848 | 2109848 | 2022-01-13 | DeKalb | Indiana | 18033 | 9607 | 130 |
2109849 | 2109849 | 2022-01-13 | Dearborn | Indiana | 18029 | 10965 | 120 |
2109850 | 2109850 | 2022-01-13 | Decatur | Indiana | 18031 | 5652 | 125 |
2109851 | 2109851 | 2022-01-13 | Delaware | Indiana | 18035 | 20404 | 376 |
2109852 | 2109852 | 2022-01-13 | Dubois | Indiana | 18037 | 10378 | 153 |
2109853 | 2109853 | 2022-01-13 | Elkhart | Indiana | 18039 | 47050 | 655 |
2109854 | 2109854 | 2022-01-13 | Fayette | Indiana | 18041 | 5648 | 123 |
2109855 | 2109855 | 2022-01-13 | Floyd | Indiana | 18043 | 14815 | 260 |
2109856 | 2109856 | 2022-01-13 | Fountain | Indiana | 18045 | 4534 | 82 |
2109857 | 2109857 | 2022-01-13 | Franklin | Indiana | 18047 | 3644 | 55 |
2109858 | 2109858 | 2022-01-13 | Fulton | Indiana | 18049 | 4174 | 92 |
2109859 | 2109859 | 2022-01-13 | Gibson | Indiana | 18051 | 8710 | 130 |
2109860 | 2109860 | 2022-01-13 | Grant | Indiana | 18053 | 14903 | 299 |
2109861 | 2109861 | 2022-01-13 | Greene | Indiana | 18055 | 5728 | 115 |
2109862 | 2109862 | 2022-01-13 | Hamilton | Indiana | 18057 | 67950 | 569 |
2109863 | 2109863 | 2022-01-13 | Hancock | Indiana | 18059 | 17424 | 221 |
2109864 | 2109864 | 2022-01-13 | Harrison | Indiana | 18061 | 8357 | 115 |
2109865 | 2109865 | 2022-01-13 | Hendricks | Indiana | 18063 | 33536 | 472 |
2109866 | 2109866 | 2022-01-13 | Henry | Indiana | 18065 | 11028 | 203 |
2109867 | 2109867 | 2022-01-13 | Howard | Indiana | 18067 | 20615 | 377 |
2109868 | 2109868 | 2022-01-13 | Huntington | Indiana | 18069 | 9501 | 140 |
2109869 | 2109869 | 2022-01-13 | Jackson | Indiana | 18071 | 9696 | 107 |
2109870 | 2109870 | 2022-01-13 | Jasper | Indiana | 18073 | 7857 | 118 |
2109871 | 2109871 | 2022-01-13 | Jay | Indiana | 18075 | 3925 | 71 |
2109872 | 2109872 | 2022-01-13 | Jefferson | Indiana | 18077 | 7350 | 128 |
2109873 | 2109873 | 2022-01-13 | Jennings | Indiana | 18079 | 5534 | 81 |
2109874 | 2109874 | 2022-01-13 | Johnson | Indiana | 18081 | 35635 | 536 |
2109875 | 2109875 | 2022-01-13 | Knox | Indiana | 18083 | 8364 | 127 |
2109876 | 2109876 | 2022-01-13 | Kosciusko | Indiana | 18085 | 17146 | 204 |
2109877 | 2109877 | 2022-01-13 | LaGrange | Indiana | 18087 | 4962 | 97 |
2109878 | 2109878 | 2022-01-13 | LaPorte | Indiana | 18091 | 22210 | 306 |
2109879 | 2109879 | 2022-01-13 | Lake | Indiana | 18089 | 97013 | 1499 |
2109880 | 2109880 | 2022-01-13 | Lawrence | Indiana | 18093 | 9548 | 220 |
2109881 | 2109881 | 2022-01-13 | Madison | Indiana | 18095 | 27184 | 552 |
2109882 | 2109882 | 2022-01-13 | Marion | Indiana | 18097 | 192862 | 2564 |
2109883 | 2109883 | 2022-01-13 | Marshall | Indiana | 18099 | 10835 | 173 |
2109884 | 2109884 | 2022-01-13 | Martin | Indiana | 18101 | 1752 | 21 |
2109885 | 2109885 | 2022-01-13 | Miami | Indiana | 18103 | 7671 | 135 |
2109886 | 2109886 | 2022-01-13 | Monroe | Indiana | 18105 | 21142 | 242 |
2109887 | 2109887 | 2022-01-13 | Montgomery | Indiana | 18107 | 8645 | 142 |
2109888 | 2109888 | 2022-01-13 | Morgan | Indiana | 18109 | 13230 | 240 |
2109889 | 2109889 | 2022-01-13 | Newton | Indiana | 18111 | 2213 | 61 |
2109890 | 2109890 | 2022-01-13 | Noble | Indiana | 18113 | 11033 | 142 |
2109891 | 2109891 | 2022-01-13 | Ohio | Indiana | 18115 | 1109 | 16 |
2109892 | 2109892 | 2022-01-13 | Orange | Indiana | 18117 | 3966 | 87 |
2109893 | 2109893 | 2022-01-13 | Owen | Indiana | 18119 | 4525 | 96 |
2109894 | 2109894 | 2022-01-13 | Parke | Indiana | 18121 | 2961 | 40 |
2109895 | 2109895 | 2022-01-13 | Perry | Indiana | 18123 | 3537 | 61 |
2109896 | 2109896 | 2022-01-13 | Pike | Indiana | 18125 | 2992 | 46 |
2109897 | 2109897 | 2022-01-13 | Porter | Indiana | 18127 | 33175 | 472 |
2109898 | 2109898 | 2022-01-13 | Posey | Indiana | 18129 | 5018 | 46 |
2109899 | 2109899 | 2022-01-13 | Pulaski | Indiana | 18131 | 2586 | 74 |
2109900 | 2109900 | 2022-01-13 | Putnam | Indiana | 18133 | 7728 | 101 |
2109901 | 2109901 | 2022-01-13 | Randolph | Indiana | 18135 | 4841 | 129 |
2109902 | 2109902 | 2022-01-13 | Ripley | Indiana | 18137 | 6799 | 114 |
2109903 | 2109903 | 2022-01-13 | Rush | Indiana | 18139 | 3873 | 36 |
2109904 | 2109904 | 2022-01-13 | Scott | Indiana | 18143 | 6057 | 88 |
2109905 | 2109905 | 2022-01-13 | Shelby | Indiana | 18145 | 11909 | 162 |
2109906 | 2109906 | 2022-01-13 | Spencer | Indiana | 18147 | 4274 | 58 |
2109907 | 2109907 | 2022-01-13 | St. Joseph | Indiana | 18141 | 61447 | 765 |
2109908 | 2109908 | 2022-01-13 | Starke | Indiana | 18149 | 4270 | 88 |
2109909 | 2109909 | 2022-01-13 | Steuben | Indiana | 18151 | 8063 | 104 |
2109910 | 2109910 | 2022-01-13 | Sullivan | Indiana | 18153 | 4169 | 65 |
2109911 | 2109911 | 2022-01-13 | Switzerland | Indiana | 18155 | 1817 | 14 |
2109912 | 2109912 | 2022-01-13 | Tippecanoe | Indiana | 18157 | 40222 | 334 |
2109913 | 2109913 | 2022-01-13 | Tipton | Indiana | 18159 | 3002 | 77 |
2109914 | 2109914 | 2022-01-13 | Union | Indiana | 18161 | 1587 | 20 |
2109915 | 2109915 | 2022-01-13 | Vanderburgh | Indiana | 18163 | 43638 | 537 |
2109916 | 2109916 | 2022-01-13 | Vermillion | Indiana | 18165 | 3369 | 62 |
2109917 | 2109917 | 2022-01-13 | Vigo | Indiana | 18167 | 24043 | 346 |
2109918 | 2109918 | 2022-01-13 | Wabash | Indiana | 18169 | 7383 | 137 |
2109919 | 2109919 | 2022-01-13 | Warren | Indiana | 18171 | 1663 | 22 |
2109920 | 2109920 | 2022-01-13 | Warrick | Indiana | 18173 | 15234 | 214 |
2109921 | 2109921 | 2022-01-13 | Washington | Indiana | 18175 | 4615 | 67 |
2109922 | 2109922 | 2022-01-13 | Wayne | Indiana | 18177 | 15491 | 303 |
2109923 | 2109923 | 2022-01-13 | Wells | Indiana | 18179 | 5712 | 122 |
2109924 | 2109924 | 2022-01-13 | White | Indiana | 18181 | 5820 | 80 |
2109925 | 2109925 | 2022-01-13 | Whitley | Indiana | 18183 | 8133 | 72 |
2106583 | 2106583 | 2022-01-12 | Adams | Indiana | 18001 | 6362 | 101 |
2106584 | 2106584 | 2022-01-12 | Allen | Indiana | 18003 | 85606 | 1025 |
2106585 | 2106585 | 2022-01-12 | Bartholomew | Indiana | 18005 | 16362 | 216 |
2106586 | 2106586 | 2022-01-12 | Benton | Indiana | 18007 | 2023 | 21 |
2106587 | 2106587 | 2022-01-12 | Blackford | Indiana | 18009 | 2601 | 57 |
2106588 | 2106588 | 2022-01-12 | Boone | Indiana | 18011 | 12565 | 143 |
2106589 | 2106589 | 2022-01-12 | Brown | Indiana | 18013 | 2145 | 56 |
2106590 | 2106590 | 2022-01-12 | Carroll | Indiana | 18015 | 3540 | 53 |
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);