ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where fips = 18045 and state = "Indiana" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
12799 | 12799 | 2020-03-26 | Fountain | Indiana | 18045 | 1 | 0 |
14479 | 14479 | 2020-03-27 | Fountain | Indiana | 18045 | 1 | 0 |
16277 | 16277 | 2020-03-28 | Fountain | Indiana | 18045 | 1 | 0 |
18179 | 18179 | 2020-03-29 | Fountain | Indiana | 18045 | 1 | 0 |
20185 | 20185 | 2020-03-30 | Fountain | Indiana | 18045 | 1 | 0 |
22279 | 22279 | 2020-03-31 | Fountain | Indiana | 18045 | 1 | 0 |
24449 | 24449 | 2020-04-01 | Fountain | Indiana | 18045 | 1 | 0 |
26688 | 26688 | 2020-04-02 | Fountain | Indiana | 18045 | 2 | 1 |
28998 | 28998 | 2020-04-03 | Fountain | Indiana | 18045 | 2 | 1 |
31364 | 31364 | 2020-04-04 | Fountain | Indiana | 18045 | 2 | 1 |
33775 | 33775 | 2020-04-05 | Fountain | Indiana | 18045 | 2 | 1 |
36228 | 36228 | 2020-04-06 | Fountain | Indiana | 18045 | 2 | 1 |
38726 | 38726 | 2020-04-07 | Fountain | Indiana | 18045 | 2 | 1 |
41272 | 41272 | 2020-04-08 | Fountain | Indiana | 18045 | 2 | 1 |
43848 | 43848 | 2020-04-09 | Fountain | Indiana | 18045 | 2 | 1 |
46452 | 46452 | 2020-04-10 | Fountain | Indiana | 18045 | 3 | 1 |
49086 | 49086 | 2020-04-11 | Fountain | Indiana | 18045 | 3 | 1 |
51749 | 51749 | 2020-04-12 | Fountain | Indiana | 18045 | 3 | 1 |
54430 | 54430 | 2020-04-13 | Fountain | Indiana | 18045 | 3 | 1 |
57123 | 57123 | 2020-04-14 | Fountain | Indiana | 18045 | 3 | 1 |
59831 | 59831 | 2020-04-15 | Fountain | Indiana | 18045 | 3 | 1 |
62552 | 62552 | 2020-04-16 | Fountain | Indiana | 18045 | 4 | 2 |
65286 | 65286 | 2020-04-17 | Fountain | Indiana | 18045 | 4 | 2 |
68035 | 68035 | 2020-04-18 | Fountain | Indiana | 18045 | 5 | 2 |
70797 | 70797 | 2020-04-19 | Fountain | Indiana | 18045 | 6 | 2 |
73568 | 73568 | 2020-04-20 | Fountain | Indiana | 18045 | 8 | 2 |
76345 | 76345 | 2020-04-21 | Fountain | Indiana | 18045 | 8 | 2 |
79129 | 79129 | 2020-04-22 | Fountain | Indiana | 18045 | 8 | 2 |
81922 | 81922 | 2020-04-23 | Fountain | Indiana | 18045 | 8 | 2 |
84722 | 84722 | 2020-04-24 | Fountain | Indiana | 18045 | 9 | 2 |
87532 | 87532 | 2020-04-25 | Fountain | Indiana | 18045 | 9 | 2 |
90348 | 90348 | 2020-04-26 | Fountain | Indiana | 18045 | 9 | 2 |
93167 | 93167 | 2020-04-27 | Fountain | Indiana | 18045 | 9 | 2 |
95999 | 95999 | 2020-04-28 | Fountain | Indiana | 18045 | 10 | 2 |
98843 | 98843 | 2020-04-29 | Fountain | Indiana | 18045 | 10 | 2 |
101694 | 101694 | 2020-04-30 | Fountain | Indiana | 18045 | 11 | 2 |
104550 | 104550 | 2020-05-01 | Fountain | Indiana | 18045 | 12 | 2 |
107415 | 107415 | 2020-05-02 | Fountain | Indiana | 18045 | 12 | 2 |
110285 | 110285 | 2020-05-03 | Fountain | Indiana | 18045 | 13 | 2 |
113160 | 113160 | 2020-05-04 | Fountain | Indiana | 18045 | 14 | 2 |
116043 | 116043 | 2020-05-05 | Fountain | Indiana | 18045 | 14 | 2 |
119003 | 119003 | 2020-05-06 | Fountain | Indiana | 18045 | 14 | 2 |
121973 | 121973 | 2020-05-07 | Fountain | Indiana | 18045 | 14 | 2 |
124953 | 124953 | 2020-05-08 | Fountain | Indiana | 18045 | 14 | 2 |
127940 | 127940 | 2020-05-09 | Fountain | Indiana | 18045 | 15 | 2 |
130931 | 130931 | 2020-05-10 | Fountain | Indiana | 18045 | 16 | 2 |
133921 | 133921 | 2020-05-11 | Fountain | Indiana | 18045 | 16 | 2 |
136910 | 136910 | 2020-05-12 | Fountain | Indiana | 18045 | 16 | 2 |
139902 | 139902 | 2020-05-13 | Fountain | Indiana | 18045 | 16 | 2 |
142898 | 142898 | 2020-05-14 | Fountain | Indiana | 18045 | 16 | 2 |
145898 | 145898 | 2020-05-15 | Fountain | Indiana | 18045 | 16 | 2 |
148902 | 148902 | 2020-05-16 | Fountain | Indiana | 18045 | 18 | 2 |
151911 | 151911 | 2020-05-17 | Fountain | Indiana | 18045 | 18 | 2 |
154923 | 154923 | 2020-05-18 | Fountain | Indiana | 18045 | 18 | 2 |
157939 | 157939 | 2020-05-19 | Fountain | Indiana | 18045 | 18 | 2 |
160965 | 160965 | 2020-05-20 | Fountain | Indiana | 18045 | 18 | 2 |
163993 | 163993 | 2020-05-21 | Fountain | Indiana | 18045 | 19 | 2 |
167026 | 167026 | 2020-05-22 | Fountain | Indiana | 18045 | 17 | 2 |
170063 | 170063 | 2020-05-23 | Fountain | Indiana | 18045 | 17 | 2 |
173104 | 173104 | 2020-05-24 | Fountain | Indiana | 18045 | 17 | 2 |
176148 | 176148 | 2020-05-25 | Fountain | Indiana | 18045 | 18 | 2 |
179192 | 179192 | 2020-05-26 | Fountain | Indiana | 18045 | 18 | 2 |
182236 | 182236 | 2020-05-27 | Fountain | Indiana | 18045 | 18 | 2 |
185290 | 185290 | 2020-05-28 | Fountain | Indiana | 18045 | 18 | 2 |
188348 | 188348 | 2020-05-29 | Fountain | Indiana | 18045 | 20 | 2 |
191413 | 191413 | 2020-05-30 | Fountain | Indiana | 18045 | 21 | 2 |
194480 | 194480 | 2020-05-31 | Fountain | Indiana | 18045 | 21 | 2 |
197550 | 197550 | 2020-06-01 | Fountain | Indiana | 18045 | 21 | 2 |
200623 | 200623 | 2020-06-02 | Fountain | Indiana | 18045 | 22 | 2 |
203699 | 203699 | 2020-06-03 | Fountain | Indiana | 18045 | 22 | 2 |
206779 | 206779 | 2020-06-04 | Fountain | Indiana | 18045 | 22 | 2 |
209860 | 209860 | 2020-06-05 | Fountain | Indiana | 18045 | 22 | 2 |
212945 | 212945 | 2020-06-06 | Fountain | Indiana | 18045 | 22 | 2 |
216032 | 216032 | 2020-06-07 | Fountain | Indiana | 18045 | 23 | 2 |
219124 | 219124 | 2020-06-08 | Fountain | Indiana | 18045 | 23 | 2 |
222219 | 222219 | 2020-06-09 | Fountain | Indiana | 18045 | 23 | 2 |
225314 | 225314 | 2020-06-10 | Fountain | Indiana | 18045 | 24 | 2 |
228416 | 228416 | 2020-06-11 | Fountain | Indiana | 18045 | 23 | 2 |
231519 | 231519 | 2020-06-12 | Fountain | Indiana | 18045 | 23 | 2 |
234625 | 234625 | 2020-06-13 | Fountain | Indiana | 18045 | 23 | 2 |
237732 | 237732 | 2020-06-14 | Fountain | Indiana | 18045 | 24 | 2 |
240840 | 240840 | 2020-06-15 | Fountain | Indiana | 18045 | 24 | 2 |
243951 | 243951 | 2020-06-16 | Fountain | Indiana | 18045 | 24 | 2 |
247064 | 247064 | 2020-06-17 | Fountain | Indiana | 18045 | 24 | 2 |
250176 | 250176 | 2020-06-18 | Fountain | Indiana | 18045 | 24 | 2 |
253291 | 253291 | 2020-06-19 | Fountain | Indiana | 18045 | 24 | 2 |
256411 | 256411 | 2020-06-20 | Fountain | Indiana | 18045 | 24 | 2 |
259537 | 259537 | 2020-06-21 | Fountain | Indiana | 18045 | 24 | 2 |
262664 | 262664 | 2020-06-22 | Fountain | Indiana | 18045 | 24 | 2 |
265792 | 265792 | 2020-06-23 | Fountain | Indiana | 18045 | 24 | 2 |
268922 | 268922 | 2020-06-24 | Fountain | Indiana | 18045 | 24 | 2 |
272059 | 272059 | 2020-06-25 | Fountain | Indiana | 18045 | 25 | 2 |
275201 | 275201 | 2020-06-26 | Fountain | Indiana | 18045 | 25 | 2 |
278349 | 278349 | 2020-06-27 | Fountain | Indiana | 18045 | 26 | 2 |
281497 | 281497 | 2020-06-28 | Fountain | Indiana | 18045 | 27 | 2 |
284642 | 284642 | 2020-06-29 | Fountain | Indiana | 18045 | 28 | 2 |
287791 | 287791 | 2020-06-30 | Fountain | Indiana | 18045 | 28 | 2 |
290941 | 290941 | 2020-07-01 | Fountain | Indiana | 18045 | 29 | 2 |
294095 | 294095 | 2020-07-02 | Fountain | Indiana | 18045 | 29 | 2 |
297253 | 297253 | 2020-07-03 | Fountain | Indiana | 18045 | 30 | 2 |
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);