ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where fips = 18165 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
281557 | 281557 | 2020-06-28 | Vermillion | Indiana | 18165 | 14 | 0 |
278409 | 278409 | 2020-06-27 | Vermillion | Indiana | 18165 | 14 | 0 |
275261 | 275261 | 2020-06-26 | Vermillion | Indiana | 18165 | 14 | 0 |
272119 | 272119 | 2020-06-25 | Vermillion | Indiana | 18165 | 14 | 0 |
268982 | 268982 | 2020-06-24 | Vermillion | Indiana | 18165 | 14 | 0 |
265852 | 265852 | 2020-06-23 | Vermillion | Indiana | 18165 | 14 | 0 |
262724 | 262724 | 2020-06-22 | Vermillion | Indiana | 18165 | 14 | 0 |
259597 | 259597 | 2020-06-21 | Vermillion | Indiana | 18165 | 14 | 0 |
256471 | 256471 | 2020-06-20 | Vermillion | Indiana | 18165 | 14 | 0 |
253351 | 253351 | 2020-06-19 | Vermillion | Indiana | 18165 | 14 | 0 |
250236 | 250236 | 2020-06-18 | Vermillion | Indiana | 18165 | 14 | 0 |
247124 | 247124 | 2020-06-17 | Vermillion | Indiana | 18165 | 13 | 0 |
244011 | 244011 | 2020-06-16 | Vermillion | Indiana | 18165 | 13 | 0 |
240900 | 240900 | 2020-06-15 | Vermillion | Indiana | 18165 | 12 | 0 |
237792 | 237792 | 2020-06-14 | Vermillion | Indiana | 18165 | 12 | 0 |
234685 | 234685 | 2020-06-13 | Vermillion | Indiana | 18165 | 12 | 0 |
231579 | 231579 | 2020-06-12 | Vermillion | Indiana | 18165 | 12 | 0 |
228476 | 228476 | 2020-06-11 | Vermillion | Indiana | 18165 | 11 | 0 |
225374 | 225374 | 2020-06-10 | Vermillion | Indiana | 18165 | 11 | 0 |
222279 | 222279 | 2020-06-09 | Vermillion | Indiana | 18165 | 11 | 0 |
219184 | 219184 | 2020-06-08 | Vermillion | Indiana | 18165 | 11 | 0 |
216092 | 216092 | 2020-06-07 | Vermillion | Indiana | 18165 | 11 | 0 |
213005 | 213005 | 2020-06-06 | Vermillion | Indiana | 18165 | 11 | 0 |
209920 | 209920 | 2020-06-05 | Vermillion | Indiana | 18165 | 11 | 0 |
206839 | 206839 | 2020-06-04 | Vermillion | Indiana | 18165 | 11 | 0 |
203759 | 203759 | 2020-06-03 | Vermillion | Indiana | 18165 | 11 | 0 |
200683 | 200683 | 2020-06-02 | Vermillion | Indiana | 18165 | 11 | 0 |
197610 | 197610 | 2020-06-01 | Vermillion | Indiana | 18165 | 11 | 0 |
194540 | 194540 | 2020-05-31 | Vermillion | Indiana | 18165 | 11 | 0 |
191473 | 191473 | 2020-05-30 | Vermillion | Indiana | 18165 | 11 | 0 |
188408 | 188408 | 2020-05-29 | Vermillion | Indiana | 18165 | 11 | 0 |
185350 | 185350 | 2020-05-28 | Vermillion | Indiana | 18165 | 11 | 0 |
182296 | 182296 | 2020-05-27 | Vermillion | Indiana | 18165 | 11 | 0 |
179252 | 179252 | 2020-05-26 | Vermillion | Indiana | 18165 | 10 | 0 |
176208 | 176208 | 2020-05-25 | Vermillion | Indiana | 18165 | 10 | 0 |
173164 | 173164 | 2020-05-24 | Vermillion | Indiana | 18165 | 10 | 0 |
170123 | 170123 | 2020-05-23 | Vermillion | Indiana | 18165 | 9 | 0 |
167086 | 167086 | 2020-05-22 | Vermillion | Indiana | 18165 | 9 | 0 |
164053 | 164053 | 2020-05-21 | Vermillion | Indiana | 18165 | 9 | 0 |
161025 | 161025 | 2020-05-20 | Vermillion | Indiana | 18165 | 9 | 0 |
157999 | 157999 | 2020-05-19 | Vermillion | Indiana | 18165 | 8 | 0 |
154983 | 154983 | 2020-05-18 | Vermillion | Indiana | 18165 | 8 | 0 |
151971 | 151971 | 2020-05-17 | Vermillion | Indiana | 18165 | 8 | 0 |
148962 | 148962 | 2020-05-16 | Vermillion | Indiana | 18165 | 8 | 0 |
145958 | 145958 | 2020-05-15 | Vermillion | Indiana | 18165 | 8 | 0 |
142958 | 142958 | 2020-05-14 | Vermillion | Indiana | 18165 | 8 | 0 |
139962 | 139962 | 2020-05-13 | Vermillion | Indiana | 18165 | 8 | 0 |
136970 | 136970 | 2020-05-12 | Vermillion | Indiana | 18165 | 8 | 0 |
133981 | 133981 | 2020-05-11 | Vermillion | Indiana | 18165 | 8 | 0 |
130991 | 130991 | 2020-05-10 | Vermillion | Indiana | 18165 | 8 | 0 |
128000 | 128000 | 2020-05-09 | Vermillion | Indiana | 18165 | 8 | 0 |
125013 | 125013 | 2020-05-08 | Vermillion | Indiana | 18165 | 8 | 0 |
122033 | 122033 | 2020-05-07 | Vermillion | Indiana | 18165 | 8 | 0 |
119063 | 119063 | 2020-05-06 | Vermillion | Indiana | 18165 | 8 | 0 |
116103 | 116103 | 2020-05-05 | Vermillion | Indiana | 18165 | 8 | 0 |
113220 | 113220 | 2020-05-04 | Vermillion | Indiana | 18165 | 8 | 0 |
110345 | 110345 | 2020-05-03 | Vermillion | Indiana | 18165 | 8 | 0 |
107475 | 107475 | 2020-05-02 | Vermillion | Indiana | 18165 | 8 | 0 |
104610 | 104610 | 2020-05-01 | Vermillion | Indiana | 18165 | 8 | 0 |
101754 | 101754 | 2020-04-30 | Vermillion | Indiana | 18165 | 8 | 0 |
98903 | 98903 | 2020-04-29 | Vermillion | Indiana | 18165 | 8 | 0 |
96059 | 96059 | 2020-04-28 | Vermillion | Indiana | 18165 | 8 | 0 |
93227 | 93227 | 2020-04-27 | Vermillion | Indiana | 18165 | 7 | 0 |
90408 | 90408 | 2020-04-26 | Vermillion | Indiana | 18165 | 7 | 0 |
87592 | 87592 | 2020-04-25 | Vermillion | Indiana | 18165 | 7 | 0 |
84782 | 84782 | 2020-04-24 | Vermillion | Indiana | 18165 | 7 | 0 |
81982 | 81982 | 2020-04-23 | Vermillion | Indiana | 18165 | 7 | 0 |
79189 | 79189 | 2020-04-22 | Vermillion | Indiana | 18165 | 7 | 0 |
76405 | 76405 | 2020-04-21 | Vermillion | Indiana | 18165 | 6 | 0 |
73628 | 73628 | 2020-04-20 | Vermillion | Indiana | 18165 | 6 | 0 |
70857 | 70857 | 2020-04-19 | Vermillion | Indiana | 18165 | 6 | 0 |
68095 | 68095 | 2020-04-18 | Vermillion | Indiana | 18165 | 5 | 0 |
65346 | 65346 | 2020-04-17 | Vermillion | Indiana | 18165 | 5 | 0 |
62612 | 62612 | 2020-04-16 | Vermillion | Indiana | 18165 | 4 | 0 |
59891 | 59891 | 2020-04-15 | Vermillion | Indiana | 18165 | 4 | 0 |
57183 | 57183 | 2020-04-14 | Vermillion | Indiana | 18165 | 3 | 0 |
54490 | 54490 | 2020-04-13 | Vermillion | Indiana | 18165 | 3 | 0 |
51809 | 51809 | 2020-04-12 | Vermillion | Indiana | 18165 | 3 | 0 |
49145 | 49145 | 2020-04-11 | Vermillion | Indiana | 18165 | 3 | 0 |
46511 | 46511 | 2020-04-10 | Vermillion | Indiana | 18165 | 3 | 0 |
43906 | 43906 | 2020-04-09 | Vermillion | Indiana | 18165 | 3 | 0 |
41330 | 41330 | 2020-04-08 | Vermillion | Indiana | 18165 | 2 | 0 |
38784 | 38784 | 2020-04-07 | Vermillion | Indiana | 18165 | 2 | 0 |
36286 | 36286 | 2020-04-06 | Vermillion | Indiana | 18165 | 2 | 0 |
33833 | 33833 | 2020-04-05 | Vermillion | Indiana | 18165 | 2 | 0 |
31422 | 31422 | 2020-04-04 | Vermillion | Indiana | 18165 | 2 | 0 |
29054 | 29054 | 2020-04-03 | Vermillion | Indiana | 18165 | 2 | 0 |
26743 | 26743 | 2020-04-02 | Vermillion | Indiana | 18165 | 1 | 0 |
24503 | 24503 | 2020-04-01 | Vermillion | Indiana | 18165 | 1 | 0 |
22331 | 22331 | 2020-03-31 | Vermillion | Indiana | 18165 | 1 | 0 |
20236 | 20236 | 2020-03-30 | Vermillion | Indiana | 18165 | 1 | 0 |
18230 | 18230 | 2020-03-29 | Vermillion | Indiana | 18165 | 1 | 0 |
16325 | 16325 | 2020-03-28 | Vermillion | Indiana | 18165 | 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);