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 county descending
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 |
---|---|---|---|---|---|---|---|
14531 | 14531 | 2020-03-27 | Whitley | Indiana | 18183 | 1 | 0 |
16334 | 16334 | 2020-03-28 | Whitley | Indiana | 18183 | 1 | 0 |
18239 | 18239 | 2020-03-29 | Whitley | Indiana | 18183 | 1 | 0 |
20245 | 20245 | 2020-03-30 | Whitley | Indiana | 18183 | 1 | 0 |
22340 | 22340 | 2020-03-31 | Whitley | Indiana | 18183 | 2 | 0 |
24512 | 24512 | 2020-04-01 | Whitley | Indiana | 18183 | 3 | 0 |
26752 | 26752 | 2020-04-02 | Whitley | Indiana | 18183 | 3 | 0 |
29063 | 29063 | 2020-04-03 | Whitley | Indiana | 18183 | 4 | 0 |
31431 | 31431 | 2020-04-04 | Whitley | Indiana | 18183 | 5 | 0 |
33842 | 33842 | 2020-04-05 | Whitley | Indiana | 18183 | 6 | 1 |
36295 | 36295 | 2020-04-06 | Whitley | Indiana | 18183 | 8 | 1 |
38793 | 38793 | 2020-04-07 | Whitley | Indiana | 18183 | 8 | 1 |
41339 | 41339 | 2020-04-08 | Whitley | Indiana | 18183 | 8 | 1 |
43915 | 43915 | 2020-04-09 | Whitley | Indiana | 18183 | 8 | 1 |
46520 | 46520 | 2020-04-10 | Whitley | Indiana | 18183 | 10 | 1 |
49154 | 49154 | 2020-04-11 | Whitley | Indiana | 18183 | 11 | 1 |
51818 | 51818 | 2020-04-12 | Whitley | Indiana | 18183 | 12 | 1 |
54499 | 54499 | 2020-04-13 | Whitley | Indiana | 18183 | 13 | 1 |
57192 | 57192 | 2020-04-14 | Whitley | Indiana | 18183 | 14 | 1 |
59900 | 59900 | 2020-04-15 | Whitley | Indiana | 18183 | 14 | 1 |
62621 | 62621 | 2020-04-16 | Whitley | Indiana | 18183 | 15 | 1 |
65355 | 65355 | 2020-04-17 | Whitley | Indiana | 18183 | 14 | 1 |
68104 | 68104 | 2020-04-18 | Whitley | Indiana | 18183 | 15 | 1 |
70866 | 70866 | 2020-04-19 | Whitley | Indiana | 18183 | 16 | 1 |
73637 | 73637 | 2020-04-20 | Whitley | Indiana | 18183 | 16 | 1 |
76414 | 76414 | 2020-04-21 | Whitley | Indiana | 18183 | 16 | 1 |
79198 | 79198 | 2020-04-22 | Whitley | Indiana | 18183 | 16 | 1 |
81991 | 81991 | 2020-04-23 | Whitley | Indiana | 18183 | 16 | 1 |
84791 | 84791 | 2020-04-24 | Whitley | Indiana | 18183 | 16 | 1 |
87601 | 87601 | 2020-04-25 | Whitley | Indiana | 18183 | 16 | 1 |
90417 | 90417 | 2020-04-26 | Whitley | Indiana | 18183 | 16 | 1 |
93236 | 93236 | 2020-04-27 | Whitley | Indiana | 18183 | 16 | 1 |
96068 | 96068 | 2020-04-28 | Whitley | Indiana | 18183 | 16 | 1 |
98912 | 98912 | 2020-04-29 | Whitley | Indiana | 18183 | 16 | 1 |
101763 | 101763 | 2020-04-30 | Whitley | Indiana | 18183 | 19 | 1 |
104619 | 104619 | 2020-05-01 | Whitley | Indiana | 18183 | 20 | 1 |
107484 | 107484 | 2020-05-02 | Whitley | Indiana | 18183 | 21 | 1 |
110354 | 110354 | 2020-05-03 | Whitley | Indiana | 18183 | 21 | 1 |
113229 | 113229 | 2020-05-04 | Whitley | Indiana | 18183 | 21 | 1 |
116112 | 116112 | 2020-05-05 | Whitley | Indiana | 18183 | 22 | 1 |
119072 | 119072 | 2020-05-06 | Whitley | Indiana | 18183 | 22 | 1 |
122042 | 122042 | 2020-05-07 | Whitley | Indiana | 18183 | 22 | 1 |
125022 | 125022 | 2020-05-08 | Whitley | Indiana | 18183 | 22 | 1 |
128009 | 128009 | 2020-05-09 | Whitley | Indiana | 18183 | 22 | 1 |
131000 | 131000 | 2020-05-10 | Whitley | Indiana | 18183 | 22 | 1 |
133990 | 133990 | 2020-05-11 | Whitley | Indiana | 18183 | 22 | 1 |
136979 | 136979 | 2020-05-12 | Whitley | Indiana | 18183 | 23 | 1 |
139971 | 139971 | 2020-05-13 | Whitley | Indiana | 18183 | 23 | 1 |
142967 | 142967 | 2020-05-14 | Whitley | Indiana | 18183 | 27 | 1 |
145967 | 145967 | 2020-05-15 | Whitley | Indiana | 18183 | 28 | 2 |
148971 | 148971 | 2020-05-16 | Whitley | Indiana | 18183 | 28 | 2 |
151980 | 151980 | 2020-05-17 | Whitley | Indiana | 18183 | 28 | 2 |
154992 | 154992 | 2020-05-18 | Whitley | Indiana | 18183 | 28 | 2 |
158008 | 158008 | 2020-05-19 | Whitley | Indiana | 18183 | 27 | 2 |
161034 | 161034 | 2020-05-20 | Whitley | Indiana | 18183 | 28 | 2 |
164062 | 164062 | 2020-05-21 | Whitley | Indiana | 18183 | 29 | 2 |
167095 | 167095 | 2020-05-22 | Whitley | Indiana | 18183 | 31 | 2 |
170132 | 170132 | 2020-05-23 | Whitley | Indiana | 18183 | 34 | 2 |
173173 | 173173 | 2020-05-24 | Whitley | Indiana | 18183 | 34 | 2 |
176217 | 176217 | 2020-05-25 | Whitley | Indiana | 18183 | 39 | 2 |
179261 | 179261 | 2020-05-26 | Whitley | Indiana | 18183 | 40 | 2 |
182305 | 182305 | 2020-05-27 | Whitley | Indiana | 18183 | 41 | 2 |
185359 | 185359 | 2020-05-28 | Whitley | Indiana | 18183 | 38 | 3 |
188417 | 188417 | 2020-05-29 | Whitley | Indiana | 18183 | 39 | 3 |
191482 | 191482 | 2020-05-30 | Whitley | Indiana | 18183 | 41 | 3 |
194549 | 194549 | 2020-05-31 | Whitley | Indiana | 18183 | 42 | 3 |
197619 | 197619 | 2020-06-01 | Whitley | Indiana | 18183 | 43 | 3 |
200692 | 200692 | 2020-06-02 | Whitley | Indiana | 18183 | 43 | 3 |
203768 | 203768 | 2020-06-03 | Whitley | Indiana | 18183 | 44 | 3 |
206848 | 206848 | 2020-06-04 | Whitley | Indiana | 18183 | 45 | 3 |
209929 | 209929 | 2020-06-05 | Whitley | Indiana | 18183 | 45 | 3 |
213014 | 213014 | 2020-06-06 | Whitley | Indiana | 18183 | 48 | 3 |
216101 | 216101 | 2020-06-07 | Whitley | Indiana | 18183 | 50 | 3 |
219193 | 219193 | 2020-06-08 | Whitley | Indiana | 18183 | 51 | 3 |
222288 | 222288 | 2020-06-09 | Whitley | Indiana | 18183 | 55 | 3 |
225383 | 225383 | 2020-06-10 | Whitley | Indiana | 18183 | 58 | 3 |
228485 | 228485 | 2020-06-11 | Whitley | Indiana | 18183 | 62 | 3 |
231588 | 231588 | 2020-06-12 | Whitley | Indiana | 18183 | 60 | 3 |
234694 | 234694 | 2020-06-13 | Whitley | Indiana | 18183 | 61 | 3 |
237801 | 237801 | 2020-06-14 | Whitley | Indiana | 18183 | 62 | 3 |
240909 | 240909 | 2020-06-15 | Whitley | Indiana | 18183 | 64 | 3 |
244020 | 244020 | 2020-06-16 | Whitley | Indiana | 18183 | 64 | 3 |
247133 | 247133 | 2020-06-17 | Whitley | Indiana | 18183 | 65 | 3 |
250245 | 250245 | 2020-06-18 | Whitley | Indiana | 18183 | 65 | 3 |
253360 | 253360 | 2020-06-19 | Whitley | Indiana | 18183 | 69 | 4 |
256480 | 256480 | 2020-06-20 | Whitley | Indiana | 18183 | 71 | 4 |
259606 | 259606 | 2020-06-21 | Whitley | Indiana | 18183 | 71 | 4 |
262733 | 262733 | 2020-06-22 | Whitley | Indiana | 18183 | 72 | 4 |
265861 | 265861 | 2020-06-23 | Whitley | Indiana | 18183 | 71 | 4 |
268991 | 268991 | 2020-06-24 | Whitley | Indiana | 18183 | 72 | 4 |
272128 | 272128 | 2020-06-25 | Whitley | Indiana | 18183 | 74 | 4 |
275270 | 275270 | 2020-06-26 | Whitley | Indiana | 18183 | 75 | 4 |
278418 | 278418 | 2020-06-27 | Whitley | Indiana | 18183 | 77 | 4 |
281566 | 281566 | 2020-06-28 | Whitley | Indiana | 18183 | 78 | 4 |
284711 | 284711 | 2020-06-29 | Whitley | Indiana | 18183 | 79 | 4 |
287860 | 287860 | 2020-06-30 | Whitley | Indiana | 18183 | 79 | 4 |
291010 | 291010 | 2020-07-01 | Whitley | Indiana | 18183 | 81 | 4 |
294164 | 294164 | 2020-07-02 | Whitley | Indiana | 18183 | 81 | 4 |
297322 | 297322 | 2020-07-03 | Whitley | Indiana | 18183 | 88 | 4 |
300484 | 300484 | 2020-07-04 | Whitley | Indiana | 18183 | 90 | 5 |
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);