ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where county = "Piatt" and state = "Illinois" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
26652 | 26652 | 2020-04-02 | Piatt | Illinois | 17147 | 1 | 0 |
28962 | 28962 | 2020-04-03 | Piatt | Illinois | 17147 | 1 | 0 |
31327 | 31327 | 2020-04-04 | Piatt | Illinois | 17147 | 1 | 0 |
33737 | 33737 | 2020-04-05 | Piatt | Illinois | 17147 | 1 | 0 |
36189 | 36189 | 2020-04-06 | Piatt | Illinois | 17147 | 3 | 0 |
38685 | 38685 | 2020-04-07 | Piatt | Illinois | 17147 | 4 | 0 |
41230 | 41230 | 2020-04-08 | Piatt | Illinois | 17147 | 4 | 0 |
43804 | 43804 | 2020-04-09 | Piatt | Illinois | 17147 | 5 | 0 |
46408 | 46408 | 2020-04-10 | Piatt | Illinois | 17147 | 6 | 0 |
49041 | 49041 | 2020-04-11 | Piatt | Illinois | 17147 | 6 | 0 |
51703 | 51703 | 2020-04-12 | Piatt | Illinois | 17147 | 6 | 0 |
54384 | 54384 | 2020-04-13 | Piatt | Illinois | 17147 | 6 | 0 |
57077 | 57077 | 2020-04-14 | Piatt | Illinois | 17147 | 6 | 0 |
59784 | 59784 | 2020-04-15 | Piatt | Illinois | 17147 | 6 | 0 |
62505 | 62505 | 2020-04-16 | Piatt | Illinois | 17147 | 7 | 0 |
65238 | 65238 | 2020-04-17 | Piatt | Illinois | 17147 | 7 | 0 |
67987 | 67987 | 2020-04-18 | Piatt | Illinois | 17147 | 7 | 0 |
70749 | 70749 | 2020-04-19 | Piatt | Illinois | 17147 | 7 | 0 |
73519 | 73519 | 2020-04-20 | Piatt | Illinois | 17147 | 7 | 0 |
76296 | 76296 | 2020-04-21 | Piatt | Illinois | 17147 | 7 | 0 |
79080 | 79080 | 2020-04-22 | Piatt | Illinois | 17147 | 7 | 0 |
81873 | 81873 | 2020-04-23 | Piatt | Illinois | 17147 | 7 | 0 |
84673 | 84673 | 2020-04-24 | Piatt | Illinois | 17147 | 7 | 0 |
87483 | 87483 | 2020-04-25 | Piatt | Illinois | 17147 | 7 | 0 |
90299 | 90299 | 2020-04-26 | Piatt | Illinois | 17147 | 7 | 0 |
93118 | 93118 | 2020-04-27 | Piatt | Illinois | 17147 | 7 | 0 |
95950 | 95950 | 2020-04-28 | Piatt | Illinois | 17147 | 7 | 0 |
98794 | 98794 | 2020-04-29 | Piatt | Illinois | 17147 | 7 | 0 |
101645 | 101645 | 2020-04-30 | Piatt | Illinois | 17147 | 7 | 0 |
104501 | 104501 | 2020-05-01 | Piatt | Illinois | 17147 | 7 | 0 |
107366 | 107366 | 2020-05-02 | Piatt | Illinois | 17147 | 7 | 0 |
110236 | 110236 | 2020-05-03 | Piatt | Illinois | 17147 | 7 | 0 |
113111 | 113111 | 2020-05-04 | Piatt | Illinois | 17147 | 7 | 0 |
115994 | 115994 | 2020-05-05 | Piatt | Illinois | 17147 | 7 | 0 |
118954 | 118954 | 2020-05-06 | Piatt | Illinois | 17147 | 7 | 0 |
121924 | 121924 | 2020-05-07 | Piatt | Illinois | 17147 | 7 | 0 |
124903 | 124903 | 2020-05-08 | Piatt | Illinois | 17147 | 7 | 0 |
127890 | 127890 | 2020-05-09 | Piatt | Illinois | 17147 | 7 | 0 |
130881 | 130881 | 2020-05-10 | Piatt | Illinois | 17147 | 7 | 0 |
133872 | 133872 | 2020-05-11 | Piatt | Illinois | 17147 | 7 | 0 |
136861 | 136861 | 2020-05-12 | Piatt | Illinois | 17147 | 8 | 0 |
139853 | 139853 | 2020-05-13 | Piatt | Illinois | 17147 | 8 | 0 |
142849 | 142849 | 2020-05-14 | Piatt | Illinois | 17147 | 8 | 0 |
145849 | 145849 | 2020-05-15 | Piatt | Illinois | 17147 | 8 | 0 |
148852 | 148852 | 2020-05-16 | Piatt | Illinois | 17147 | 8 | 0 |
151861 | 151861 | 2020-05-17 | Piatt | Illinois | 17147 | 9 | 0 |
154873 | 154873 | 2020-05-18 | Piatt | Illinois | 17147 | 9 | 0 |
157889 | 157889 | 2020-05-19 | Piatt | Illinois | 17147 | 9 | 0 |
160915 | 160915 | 2020-05-20 | Piatt | Illinois | 17147 | 8 | 0 |
163943 | 163943 | 2020-05-21 | Piatt | Illinois | 17147 | 9 | 0 |
166976 | 166976 | 2020-05-22 | Piatt | Illinois | 17147 | 9 | 0 |
170013 | 170013 | 2020-05-23 | Piatt | Illinois | 17147 | 10 | 0 |
173054 | 173054 | 2020-05-24 | Piatt | Illinois | 17147 | 11 | 0 |
176098 | 176098 | 2020-05-25 | Piatt | Illinois | 17147 | 11 | 0 |
179142 | 179142 | 2020-05-26 | Piatt | Illinois | 17147 | 12 | 0 |
182186 | 182186 | 2020-05-27 | Piatt | Illinois | 17147 | 12 | 0 |
185240 | 185240 | 2020-05-28 | Piatt | Illinois | 17147 | 12 | 0 |
188298 | 188298 | 2020-05-29 | Piatt | Illinois | 17147 | 12 | 0 |
191363 | 191363 | 2020-05-30 | Piatt | Illinois | 17147 | 11 | 0 |
194430 | 194430 | 2020-05-31 | Piatt | Illinois | 17147 | 11 | 0 |
197500 | 197500 | 2020-06-01 | Piatt | Illinois | 17147 | 11 | 0 |
200573 | 200573 | 2020-06-02 | Piatt | Illinois | 17147 | 11 | 0 |
203649 | 203649 | 2020-06-03 | Piatt | Illinois | 17147 | 11 | 0 |
206729 | 206729 | 2020-06-04 | Piatt | Illinois | 17147 | 11 | 0 |
209810 | 209810 | 2020-06-05 | Piatt | Illinois | 17147 | 11 | 0 |
212895 | 212895 | 2020-06-06 | Piatt | Illinois | 17147 | 11 | 0 |
215982 | 215982 | 2020-06-07 | Piatt | Illinois | 17147 | 12 | 0 |
219073 | 219073 | 2020-06-08 | Piatt | Illinois | 17147 | 12 | 0 |
222168 | 222168 | 2020-06-09 | Piatt | Illinois | 17147 | 11 | 0 |
225263 | 225263 | 2020-06-10 | Piatt | Illinois | 17147 | 11 | 0 |
228365 | 228365 | 2020-06-11 | Piatt | Illinois | 17147 | 11 | 0 |
231468 | 231468 | 2020-06-12 | Piatt | Illinois | 17147 | 11 | 0 |
234574 | 234574 | 2020-06-13 | Piatt | Illinois | 17147 | 11 | 0 |
237681 | 237681 | 2020-06-14 | Piatt | Illinois | 17147 | 11 | 0 |
240789 | 240789 | 2020-06-15 | Piatt | Illinois | 17147 | 11 | 0 |
243900 | 243900 | 2020-06-16 | Piatt | Illinois | 17147 | 11 | 0 |
247013 | 247013 | 2020-06-17 | Piatt | Illinois | 17147 | 14 | 0 |
250125 | 250125 | 2020-06-18 | Piatt | Illinois | 17147 | 17 | 0 |
253240 | 253240 | 2020-06-19 | Piatt | Illinois | 17147 | 16 | 0 |
256360 | 256360 | 2020-06-20 | Piatt | Illinois | 17147 | 16 | 0 |
259486 | 259486 | 2020-06-21 | Piatt | Illinois | 17147 | 17 | 0 |
262613 | 262613 | 2020-06-22 | Piatt | Illinois | 17147 | 18 | 0 |
265741 | 265741 | 2020-06-23 | Piatt | Illinois | 17147 | 18 | 0 |
268871 | 268871 | 2020-06-24 | Piatt | Illinois | 17147 | 17 | 0 |
272008 | 272008 | 2020-06-25 | Piatt | Illinois | 17147 | 19 | 0 |
275150 | 275150 | 2020-06-26 | Piatt | Illinois | 17147 | 19 | 0 |
278298 | 278298 | 2020-06-27 | Piatt | Illinois | 17147 | 19 | 0 |
281446 | 281446 | 2020-06-28 | Piatt | Illinois | 17147 | 19 | 0 |
284591 | 284591 | 2020-06-29 | Piatt | Illinois | 17147 | 19 | 0 |
287740 | 287740 | 2020-06-30 | Piatt | Illinois | 17147 | 19 | 0 |
290890 | 290890 | 2020-07-01 | Piatt | Illinois | 17147 | 20 | 0 |
294044 | 294044 | 2020-07-02 | Piatt | Illinois | 17147 | 20 | 0 |
297201 | 297201 | 2020-07-03 | Piatt | Illinois | 17147 | 21 | 0 |
300363 | 300363 | 2020-07-04 | Piatt | Illinois | 17147 | 20 | 0 |
303527 | 303527 | 2020-07-05 | Piatt | Illinois | 17147 | 20 | 0 |
306692 | 306692 | 2020-07-06 | Piatt | Illinois | 17147 | 20 | 0 |
309860 | 309860 | 2020-07-07 | Piatt | Illinois | 17147 | 20 | 0 |
313030 | 313030 | 2020-07-08 | Piatt | Illinois | 17147 | 20 | 0 |
316204 | 316204 | 2020-07-09 | Piatt | Illinois | 17147 | 21 | 0 |
319377 | 319377 | 2020-07-10 | Piatt | Illinois | 17147 | 21 | 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);