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 >30
- 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
- …
county >30
- 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
- …
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);