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
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 93
- 18097 799
- 18063 797
- 18113 796
- 18001 795
- 18011 795
- 18067 794
- 18081 794
- 18141 794
- 18091 791
- 18179 791
- 18057 790
- 18005 789
- 18043 789
- 18047 788
- 18089 788
- 18019 787
- 18041 787
- 18079 787
- 18095 787
- 18119 786
- 18157 786
- 18177 786
- 18003 785
- 18053 785
- 18145 785
- 18163 785
- 18167 785
- 18035 784
- 18039 784
- 18059 784
- 18061 784
- 18103 784
- 18175 784
- 18105 783
- 18109 783
- 18133 783
- 18137 783
- 18143 783
- 18159 783
- 18037 782
- 18013 781
- 18029 781
- 18031 781
- 18051 781
- 18071 781
- 18093 781
- 18107 781
- 18115 781
- 18127 781
- 18149 781
- 18153 781
- 18173 781
- 18033 780
- 18073 780
- 18139 780
- 18045 779
- 18099 779
- 18117 779
- 18129 779
- 18171 779
- 18015 778
- 18023 778
- 18049 778
- 18065 778
- 18069 778
- 18085 778
- 18087 778
- 18135 778
- 18183 778
- 18025 777
- 18111 777
- 18155 777
- 18165 777
- 18169 777
- 18181 777
- 18021 776
- 18055 776
- 18083 776
- 18151 776
- 18017 774
- 18077 774
- 18075 773
- 18009 772
- 18147 772
- 18121 771
- 18101 770
- 18161 770
- 18027 769
- 18131 768
- 18123 764
- 18007 762
- 18125 762
- - 40
county 93
- Marion 799
- Hendricks 797
- Noble 796
- Adams 795
- Boone 795
- Howard 794
- Johnson 794
- St. Joseph 794
- LaPorte 791
- Wells 791
- Hamilton 790
- Bartholomew 789
- Floyd 789
- Franklin 788
- Lake 788
- Clark 787
- Fayette 787
- Jennings 787
- Madison 787
- Owen 786
- Tippecanoe 786
- Wayne 786
- Allen 785
- Grant 785
- Shelby 785
- Vanderburgh 785
- Vigo 785
- Delaware 784
- Elkhart 784
- Hancock 784
- Harrison 784
- Miami 784
- Washington 784
- Monroe 783
- Morgan 783
- Putnam 783
- Ripley 783
- Scott 783
- Tipton 783
- Dubois 782
- Brown 781
- Dearborn 781
- Decatur 781
- Gibson 781
- Jackson 781
- Lawrence 781
- Montgomery 781
- Ohio 781
- Porter 781
- Starke 781
- Sullivan 781
- Warrick 781
- DeKalb 780
- Jasper 780
- Rush 780
- Fountain 779
- Marshall 779
- Orange 779
- Posey 779
- Warren 779
- Carroll 778
- Clinton 778
- Fulton 778
- Henry 778
- Huntington 778
- Kosciusko 778
- LaGrange 778
- Randolph 778
- Whitley 778
- Crawford 777
- Newton 777
- Switzerland 777
- Vermillion 777
- Wabash 777
- White 777
- Clay 776
- Greene 776
- Knox 776
- Steuben 776
- Cass 774
- Jefferson 774
- Jay 773
- Blackford 772
- Spencer 772
- Parke 771
- Martin 770
- Union 770
- Daviess 769
- Pulaski 768
- Perry 764
- Benton 762
- Pike 762
- Unknown 40
state 1
- Indiana · 71,921 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
614 | 614 | 2020-03-06 | Marion | Indiana | 18097 | 1 | 0 |
698 | 698 | 2020-03-07 | Marion | Indiana | 18097 | 1 | 0 |
795 | 795 | 2020-03-08 | Hendricks | Indiana | 18063 | 1 | 0 |
796 | 796 | 2020-03-08 | Marion | Indiana | 18097 | 1 | 0 |
915 | 915 | 2020-03-09 | Hendricks | Indiana | 18063 | 2 | 0 |
916 | 916 | 2020-03-09 | Marion | Indiana | 18097 | 1 | 0 |
917 | 917 | 2020-03-09 | Noble | Indiana | 18113 | 1 | 0 |
1058 | 1058 | 2020-03-10 | Adams | Indiana | 18001 | 1 | 0 |
1059 | 1059 | 2020-03-10 | Boone | Indiana | 18011 | 1 | 0 |
1060 | 1060 | 2020-03-10 | Hendricks | Indiana | 18063 | 2 | 0 |
1061 | 1061 | 2020-03-10 | Marion | Indiana | 18097 | 1 | 0 |
1062 | 1062 | 2020-03-10 | Noble | Indiana | 18113 | 1 | 0 |
1233 | 1233 | 2020-03-11 | Adams | Indiana | 18001 | 1 | 0 |
1234 | 1234 | 2020-03-11 | Boone | Indiana | 18011 | 1 | 0 |
1235 | 1235 | 2020-03-11 | Hendricks | Indiana | 18063 | 2 | 0 |
1236 | 1236 | 2020-03-11 | Howard | Indiana | 18067 | 1 | 0 |
1237 | 1237 | 2020-03-11 | Johnson | Indiana | 18081 | 3 | 0 |
1238 | 1238 | 2020-03-11 | Marion | Indiana | 18097 | 1 | 0 |
1239 | 1239 | 2020-03-11 | Noble | Indiana | 18113 | 1 | 0 |
1240 | 1240 | 2020-03-11 | St. Joseph | Indiana | 18141 | 1 | 0 |
1447 | 1447 | 2020-03-12 | Adams | Indiana | 18001 | 1 | 0 |
1448 | 1448 | 2020-03-12 | Boone | Indiana | 18011 | 1 | 0 |
1449 | 1449 | 2020-03-12 | Hendricks | Indiana | 18063 | 2 | 0 |
1450 | 1450 | 2020-03-12 | Howard | Indiana | 18067 | 1 | 0 |
1451 | 1451 | 2020-03-12 | Johnson | Indiana | 18081 | 3 | 0 |
1452 | 1452 | 2020-03-12 | Marion | Indiana | 18097 | 2 | 0 |
1453 | 1453 | 2020-03-12 | Noble | Indiana | 18113 | 1 | 0 |
1454 | 1454 | 2020-03-12 | St. Joseph | Indiana | 18141 | 1 | 0 |
1718 | 1718 | 2020-03-13 | Adams | Indiana | 18001 | 1 | 0 |
1719 | 1719 | 2020-03-13 | Boone | Indiana | 18011 | 1 | 0 |
1720 | 1720 | 2020-03-13 | Hendricks | Indiana | 18063 | 2 | 0 |
1721 | 1721 | 2020-03-13 | Howard | Indiana | 18067 | 1 | 0 |
1722 | 1722 | 2020-03-13 | Johnson | Indiana | 18081 | 3 | 0 |
1723 | 1723 | 2020-03-13 | Marion | Indiana | 18097 | 2 | 0 |
1724 | 1724 | 2020-03-13 | Noble | Indiana | 18113 | 1 | 0 |
1725 | 1725 | 2020-03-13 | St. Joseph | Indiana | 18141 | 1 | 0 |
2049 | 2049 | 2020-03-14 | Adams | Indiana | 18001 | 1 | 0 |
2050 | 2050 | 2020-03-14 | Boone | Indiana | 18011 | 1 | 0 |
2051 | 2051 | 2020-03-14 | Hendricks | Indiana | 18063 | 2 | 0 |
2052 | 2052 | 2020-03-14 | Howard | Indiana | 18067 | 1 | 0 |
2053 | 2053 | 2020-03-14 | Johnson | Indiana | 18081 | 3 | 0 |
2054 | 2054 | 2020-03-14 | LaPorte | Indiana | 18091 | 1 | 0 |
2055 | 2055 | 2020-03-14 | Marion | Indiana | 18097 | 3 | 0 |
2056 | 2056 | 2020-03-14 | Noble | Indiana | 18113 | 1 | 0 |
2057 | 2057 | 2020-03-14 | St. Joseph | Indiana | 18141 | 1 | 0 |
2058 | 2058 | 2020-03-14 | Wells | Indiana | 18179 | 1 | 0 |
2442 | 2442 | 2020-03-15 | Adams | Indiana | 18001 | 1 | 0 |
2443 | 2443 | 2020-03-15 | Boone | Indiana | 18011 | 1 | 0 |
2444 | 2444 | 2020-03-15 | Hamilton | Indiana | 18057 | 1 | 0 |
2445 | 2445 | 2020-03-15 | Hendricks | Indiana | 18063 | 2 | 0 |
2446 | 2446 | 2020-03-15 | Howard | Indiana | 18067 | 1 | 0 |
2447 | 2447 | 2020-03-15 | Johnson | Indiana | 18081 | 3 | 0 |
2448 | 2448 | 2020-03-15 | LaPorte | Indiana | 18091 | 1 | 0 |
2449 | 2449 | 2020-03-15 | Marion | Indiana | 18097 | 6 | 0 |
2450 | 2450 | 2020-03-15 | Noble | Indiana | 18113 | 1 | 0 |
2451 | 2451 | 2020-03-15 | St. Joseph | Indiana | 18141 | 1 | 0 |
2452 | 2452 | 2020-03-15 | Wells | Indiana | 18179 | 1 | 0 |
2885 | 2885 | 2020-03-16 | Adams | Indiana | 18001 | 1 | 0 |
2886 | 2886 | 2020-03-16 | Bartholomew | Indiana | 18005 | 1 | 0 |
2887 | 2887 | 2020-03-16 | Boone | Indiana | 18011 | 1 | 0 |
2888 | 2888 | 2020-03-16 | Floyd | Indiana | 18043 | 1 | 0 |
2889 | 2889 | 2020-03-16 | Hamilton | Indiana | 18057 | 1 | 0 |
2890 | 2890 | 2020-03-16 | Hendricks | Indiana | 18063 | 3 | 0 |
2891 | 2891 | 2020-03-16 | Howard | Indiana | 18067 | 2 | 0 |
2892 | 2892 | 2020-03-16 | Johnson | Indiana | 18081 | 3 | 0 |
2893 | 2893 | 2020-03-16 | LaPorte | Indiana | 18091 | 1 | 0 |
2894 | 2894 | 2020-03-16 | Marion | Indiana | 18097 | 7 | 1 |
2895 | 2895 | 2020-03-16 | Noble | Indiana | 18113 | 1 | 0 |
2896 | 2896 | 2020-03-16 | St. Joseph | Indiana | 18141 | 1 | 0 |
2897 | 2897 | 2020-03-16 | Wells | Indiana | 18179 | 1 | 0 |
3374 | 3374 | 2020-03-17 | Adams | Indiana | 18001 | 1 | 0 |
3375 | 3375 | 2020-03-17 | Bartholomew | Indiana | 18005 | 1 | 0 |
3376 | 3376 | 2020-03-17 | Boone | Indiana | 18011 | 1 | 0 |
3377 | 3377 | 2020-03-17 | Floyd | Indiana | 18043 | 1 | 0 |
3378 | 3378 | 2020-03-17 | Franklin | Indiana | 18047 | 2 | 0 |
3379 | 3379 | 2020-03-17 | Hamilton | Indiana | 18057 | 1 | 0 |
3380 | 3380 | 2020-03-17 | Hendricks | Indiana | 18063 | 3 | 0 |
3381 | 3381 | 2020-03-17 | Howard | Indiana | 18067 | 2 | 0 |
3382 | 3382 | 2020-03-17 | Johnson | Indiana | 18081 | 3 | 1 |
3383 | 3383 | 2020-03-17 | LaPorte | Indiana | 18091 | 1 | 0 |
3384 | 3384 | 2020-03-17 | Lake | Indiana | 18089 | 2 | 0 |
3385 | 3385 | 2020-03-17 | Marion | Indiana | 18097 | 9 | 1 |
3386 | 3386 | 2020-03-17 | Noble | Indiana | 18113 | 1 | 0 |
3387 | 3387 | 2020-03-17 | St. Joseph | Indiana | 18141 | 1 | 0 |
3388 | 3388 | 2020-03-17 | Wells | Indiana | 18179 | 1 | 0 |
3944 | 3944 | 2020-03-18 | Adams | Indiana | 18001 | 1 | 0 |
3945 | 3945 | 2020-03-18 | Bartholomew | Indiana | 18005 | 1 | 0 |
3946 | 3946 | 2020-03-18 | Boone | Indiana | 18011 | 1 | 0 |
3947 | 3947 | 2020-03-18 | Clark | Indiana | 18019 | 1 | 0 |
3948 | 3948 | 2020-03-18 | Fayette | Indiana | 18041 | 1 | 0 |
3949 | 3949 | 2020-03-18 | Floyd | Indiana | 18043 | 1 | 0 |
3950 | 3950 | 2020-03-18 | Franklin | Indiana | 18047 | 2 | 0 |
3951 | 3951 | 2020-03-18 | Hamilton | Indiana | 18057 | 2 | 0 |
3952 | 3952 | 2020-03-18 | Hendricks | Indiana | 18063 | 4 | 0 |
3953 | 3953 | 2020-03-18 | Howard | Indiana | 18067 | 2 | 0 |
3954 | 3954 | 2020-03-18 | Jennings | Indiana | 18079 | 1 | 0 |
3955 | 3955 | 2020-03-18 | Johnson | Indiana | 18081 | 3 | 1 |
3956 | 3956 | 2020-03-18 | LaPorte | Indiana | 18091 | 1 | 0 |
3957 | 3957 | 2020-03-18 | Lake | Indiana | 18089 | 3 | 0 |
3958 | 3958 | 2020-03-18 | Madison | Indiana | 18095 | 1 | 0 |
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);