ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 18119 and state = "Indiana" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-19 1
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- 2020-04-14 1
- 2020-04-15 1
- 2020-04-16 1
- 2020-04-17 1
- …
state 1
- Indiana · 786 ✖
fips 1
- 18119 · 786 ✖
county 1
- Owen 786
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4637 | 4637 | 2020-03-19 | Owen | Indiana | 18119 | 1 | 0 |
5445 | 5445 | 2020-03-20 | Owen | Indiana | 18119 | 1 | 0 |
6385 | 6385 | 2020-03-21 | Owen | Indiana | 18119 | 1 | 0 |
7441 | 7441 | 2020-03-22 | Owen | Indiana | 18119 | 1 | 0 |
8599 | 8599 | 2020-03-23 | Owen | Indiana | 18119 | 2 | 0 |
9871 | 9871 | 2020-03-24 | Owen | Indiana | 18119 | 2 | 0 |
11266 | 11266 | 2020-03-25 | Owen | Indiana | 18119 | 4 | 0 |
12825 | 12825 | 2020-03-26 | Owen | Indiana | 18119 | 4 | 0 |
14510 | 14510 | 2020-03-27 | Owen | Indiana | 18119 | 5 | 0 |
16309 | 16309 | 2020-03-28 | Owen | Indiana | 18119 | 7 | 0 |
18213 | 18213 | 2020-03-29 | Owen | Indiana | 18119 | 9 | 0 |
20219 | 20219 | 2020-03-30 | Owen | Indiana | 18119 | 10 | 0 |
22314 | 22314 | 2020-03-31 | Owen | Indiana | 18119 | 11 | 0 |
24485 | 24485 | 2020-04-01 | Owen | Indiana | 18119 | 12 | 0 |
26724 | 26724 | 2020-04-02 | Owen | Indiana | 18119 | 12 | 0 |
29034 | 29034 | 2020-04-03 | Owen | Indiana | 18119 | 13 | 0 |
31401 | 31401 | 2020-04-04 | Owen | Indiana | 18119 | 13 | 0 |
33812 | 33812 | 2020-04-05 | Owen | Indiana | 18119 | 15 | 0 |
36265 | 36265 | 2020-04-06 | Owen | Indiana | 18119 | 15 | 0 |
38763 | 38763 | 2020-04-07 | Owen | Indiana | 18119 | 17 | 0 |
41309 | 41309 | 2020-04-08 | Owen | Indiana | 18119 | 17 | 0 |
43885 | 43885 | 2020-04-09 | Owen | Indiana | 18119 | 17 | 0 |
46489 | 46489 | 2020-04-10 | Owen | Indiana | 18119 | 18 | 1 |
49123 | 49123 | 2020-04-11 | Owen | Indiana | 18119 | 18 | 1 |
51786 | 51786 | 2020-04-12 | Owen | Indiana | 18119 | 19 | 1 |
54467 | 54467 | 2020-04-13 | Owen | Indiana | 18119 | 19 | 1 |
57160 | 57160 | 2020-04-14 | Owen | Indiana | 18119 | 19 | 1 |
59868 | 59868 | 2020-04-15 | Owen | Indiana | 18119 | 19 | 1 |
62589 | 62589 | 2020-04-16 | Owen | Indiana | 18119 | 21 | 1 |
65323 | 65323 | 2020-04-17 | Owen | Indiana | 18119 | 21 | 1 |
68072 | 68072 | 2020-04-18 | Owen | Indiana | 18119 | 21 | 1 |
70834 | 70834 | 2020-04-19 | Owen | Indiana | 18119 | 21 | 1 |
73605 | 73605 | 2020-04-20 | Owen | Indiana | 18119 | 21 | 1 |
76382 | 76382 | 2020-04-21 | Owen | Indiana | 18119 | 22 | 1 |
79166 | 79166 | 2020-04-22 | Owen | Indiana | 18119 | 22 | 1 |
81959 | 81959 | 2020-04-23 | Owen | Indiana | 18119 | 22 | 1 |
84759 | 84759 | 2020-04-24 | Owen | Indiana | 18119 | 22 | 1 |
87569 | 87569 | 2020-04-25 | Owen | Indiana | 18119 | 22 | 1 |
90385 | 90385 | 2020-04-26 | Owen | Indiana | 18119 | 22 | 1 |
93204 | 93204 | 2020-04-27 | Owen | Indiana | 18119 | 22 | 1 |
96036 | 96036 | 2020-04-28 | Owen | Indiana | 18119 | 22 | 1 |
98880 | 98880 | 2020-04-29 | Owen | Indiana | 18119 | 22 | 1 |
101731 | 101731 | 2020-04-30 | Owen | Indiana | 18119 | 23 | 1 |
104587 | 104587 | 2020-05-01 | Owen | Indiana | 18119 | 23 | 1 |
107452 | 107452 | 2020-05-02 | Owen | Indiana | 18119 | 24 | 1 |
110322 | 110322 | 2020-05-03 | Owen | Indiana | 18119 | 24 | 1 |
113197 | 113197 | 2020-05-04 | Owen | Indiana | 18119 | 25 | 1 |
116080 | 116080 | 2020-05-05 | Owen | Indiana | 18119 | 24 | 1 |
119040 | 119040 | 2020-05-06 | Owen | Indiana | 18119 | 24 | 1 |
122010 | 122010 | 2020-05-07 | Owen | Indiana | 18119 | 24 | 1 |
124990 | 124990 | 2020-05-08 | Owen | Indiana | 18119 | 26 | 1 |
127977 | 127977 | 2020-05-09 | Owen | Indiana | 18119 | 28 | 1 |
130968 | 130968 | 2020-05-10 | Owen | Indiana | 18119 | 28 | 1 |
133958 | 133958 | 2020-05-11 | Owen | Indiana | 18119 | 28 | 1 |
136947 | 136947 | 2020-05-12 | Owen | Indiana | 18119 | 27 | 1 |
139939 | 139939 | 2020-05-13 | Owen | Indiana | 18119 | 27 | 1 |
142935 | 142935 | 2020-05-14 | Owen | Indiana | 18119 | 27 | 1 |
145935 | 145935 | 2020-05-15 | Owen | Indiana | 18119 | 27 | 1 |
148939 | 148939 | 2020-05-16 | Owen | Indiana | 18119 | 27 | 1 |
151948 | 151948 | 2020-05-17 | Owen | Indiana | 18119 | 27 | 1 |
154960 | 154960 | 2020-05-18 | Owen | Indiana | 18119 | 27 | 1 |
157976 | 157976 | 2020-05-19 | Owen | Indiana | 18119 | 27 | 1 |
161002 | 161002 | 2020-05-20 | Owen | Indiana | 18119 | 28 | 1 |
164030 | 164030 | 2020-05-21 | Owen | Indiana | 18119 | 29 | 1 |
167063 | 167063 | 2020-05-22 | Owen | Indiana | 18119 | 29 | 1 |
170100 | 170100 | 2020-05-23 | Owen | Indiana | 18119 | 30 | 1 |
173141 | 173141 | 2020-05-24 | Owen | Indiana | 18119 | 31 | 1 |
176185 | 176185 | 2020-05-25 | Owen | Indiana | 18119 | 31 | 1 |
179229 | 179229 | 2020-05-26 | Owen | Indiana | 18119 | 34 | 1 |
182273 | 182273 | 2020-05-27 | Owen | Indiana | 18119 | 34 | 1 |
185327 | 185327 | 2020-05-28 | Owen | Indiana | 18119 | 35 | 1 |
188385 | 188385 | 2020-05-29 | Owen | Indiana | 18119 | 34 | 1 |
191450 | 191450 | 2020-05-30 | Owen | Indiana | 18119 | 34 | 1 |
194517 | 194517 | 2020-05-31 | Owen | Indiana | 18119 | 35 | 1 |
197587 | 197587 | 2020-06-01 | Owen | Indiana | 18119 | 35 | 1 |
200660 | 200660 | 2020-06-02 | Owen | Indiana | 18119 | 34 | 1 |
203736 | 203736 | 2020-06-03 | Owen | Indiana | 18119 | 34 | 1 |
206816 | 206816 | 2020-06-04 | Owen | Indiana | 18119 | 34 | 1 |
209897 | 209897 | 2020-06-05 | Owen | Indiana | 18119 | 34 | 1 |
212982 | 212982 | 2020-06-06 | Owen | Indiana | 18119 | 36 | 1 |
216069 | 216069 | 2020-06-07 | Owen | Indiana | 18119 | 36 | 1 |
219161 | 219161 | 2020-06-08 | Owen | Indiana | 18119 | 36 | 1 |
222256 | 222256 | 2020-06-09 | Owen | Indiana | 18119 | 36 | 1 |
225351 | 225351 | 2020-06-10 | Owen | Indiana | 18119 | 37 | 1 |
228453 | 228453 | 2020-06-11 | Owen | Indiana | 18119 | 37 | 1 |
231556 | 231556 | 2020-06-12 | Owen | Indiana | 18119 | 37 | 1 |
234662 | 234662 | 2020-06-13 | Owen | Indiana | 18119 | 37 | 1 |
237769 | 237769 | 2020-06-14 | Owen | Indiana | 18119 | 37 | 1 |
240877 | 240877 | 2020-06-15 | Owen | Indiana | 18119 | 37 | 1 |
243988 | 243988 | 2020-06-16 | Owen | Indiana | 18119 | 37 | 1 |
247101 | 247101 | 2020-06-17 | Owen | Indiana | 18119 | 39 | 1 |
250213 | 250213 | 2020-06-18 | Owen | Indiana | 18119 | 40 | 1 |
253328 | 253328 | 2020-06-19 | Owen | Indiana | 18119 | 39 | 1 |
256448 | 256448 | 2020-06-20 | Owen | Indiana | 18119 | 40 | 1 |
259574 | 259574 | 2020-06-21 | Owen | Indiana | 18119 | 40 | 1 |
262701 | 262701 | 2020-06-22 | Owen | Indiana | 18119 | 40 | 1 |
265829 | 265829 | 2020-06-23 | Owen | Indiana | 18119 | 40 | 1 |
268959 | 268959 | 2020-06-24 | Owen | Indiana | 18119 | 40 | 1 |
272096 | 272096 | 2020-06-25 | Owen | Indiana | 18119 | 41 | 1 |
275238 | 275238 | 2020-06-26 | Owen | Indiana | 18119 | 41 | 1 |
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);