ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Carroll" and state = "Illinois" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
16218 | 16218 | 2020-03-28 | Carroll | Illinois | 17015 | 1 | 0 |
18117 | 18117 | 2020-03-29 | Carroll | Illinois | 17015 | 1 | 0 |
20117 | 20117 | 2020-03-30 | Carroll | Illinois | 17015 | 1 | 1 |
22208 | 22208 | 2020-03-31 | Carroll | Illinois | 17015 | 2 | 1 |
24376 | 24376 | 2020-04-01 | Carroll | Illinois | 17015 | 3 | 1 |
26609 | 26609 | 2020-04-02 | Carroll | Illinois | 17015 | 4 | 1 |
28916 | 28916 | 2020-04-03 | Carroll | Illinois | 17015 | 4 | 1 |
31278 | 31278 | 2020-04-04 | Carroll | Illinois | 17015 | 4 | 1 |
33687 | 33687 | 2020-04-05 | Carroll | Illinois | 17015 | 4 | 1 |
36138 | 36138 | 2020-04-06 | Carroll | Illinois | 17015 | 4 | 1 |
38632 | 38632 | 2020-04-07 | Carroll | Illinois | 17015 | 5 | 1 |
41176 | 41176 | 2020-04-08 | Carroll | Illinois | 17015 | 5 | 1 |
43750 | 43750 | 2020-04-09 | Carroll | Illinois | 17015 | 5 | 1 |
46352 | 46352 | 2020-04-10 | Carroll | Illinois | 17015 | 5 | 1 |
48983 | 48983 | 2020-04-11 | Carroll | Illinois | 17015 | 5 | 1 |
51645 | 51645 | 2020-04-12 | Carroll | Illinois | 17015 | 5 | 1 |
54325 | 54325 | 2020-04-13 | Carroll | Illinois | 17015 | 5 | 1 |
57017 | 57017 | 2020-04-14 | Carroll | Illinois | 17015 | 5 | 1 |
59724 | 59724 | 2020-04-15 | Carroll | Illinois | 17015 | 5 | 1 |
62445 | 62445 | 2020-04-16 | Carroll | Illinois | 17015 | 5 | 1 |
65177 | 65177 | 2020-04-17 | Carroll | Illinois | 17015 | 5 | 1 |
67925 | 67925 | 2020-04-18 | Carroll | Illinois | 17015 | 6 | 1 |
70687 | 70687 | 2020-04-19 | Carroll | Illinois | 17015 | 6 | 1 |
73456 | 73456 | 2020-04-20 | Carroll | Illinois | 17015 | 6 | 1 |
76232 | 76232 | 2020-04-21 | Carroll | Illinois | 17015 | 7 | 2 |
79016 | 79016 | 2020-04-22 | Carroll | Illinois | 17015 | 7 | 2 |
81809 | 81809 | 2020-04-23 | Carroll | Illinois | 17015 | 7 | 2 |
84609 | 84609 | 2020-04-24 | Carroll | Illinois | 17015 | 7 | 2 |
87419 | 87419 | 2020-04-25 | Carroll | Illinois | 17015 | 9 | 2 |
90235 | 90235 | 2020-04-26 | Carroll | Illinois | 17015 | 9 | 2 |
93054 | 93054 | 2020-04-27 | Carroll | Illinois | 17015 | 9 | 2 |
95886 | 95886 | 2020-04-28 | Carroll | Illinois | 17015 | 9 | 2 |
98730 | 98730 | 2020-04-29 | Carroll | Illinois | 17015 | 9 | 2 |
101581 | 101581 | 2020-04-30 | Carroll | Illinois | 17015 | 9 | 2 |
104437 | 104437 | 2020-05-01 | Carroll | Illinois | 17015 | 9 | 2 |
107302 | 107302 | 2020-05-02 | Carroll | Illinois | 17015 | 9 | 2 |
110172 | 110172 | 2020-05-03 | Carroll | Illinois | 17015 | 10 | 2 |
113047 | 113047 | 2020-05-04 | Carroll | Illinois | 17015 | 10 | 2 |
115930 | 115930 | 2020-05-05 | Carroll | Illinois | 17015 | 10 | 2 |
118890 | 118890 | 2020-05-06 | Carroll | Illinois | 17015 | 10 | 2 |
121860 | 121860 | 2020-05-07 | Carroll | Illinois | 17015 | 10 | 2 |
124839 | 124839 | 2020-05-08 | Carroll | Illinois | 17015 | 10 | 2 |
127826 | 127826 | 2020-05-09 | Carroll | Illinois | 17015 | 10 | 2 |
130817 | 130817 | 2020-05-10 | Carroll | Illinois | 17015 | 11 | 2 |
133808 | 133808 | 2020-05-11 | Carroll | Illinois | 17015 | 11 | 2 |
136797 | 136797 | 2020-05-12 | Carroll | Illinois | 17015 | 12 | 2 |
139788 | 139788 | 2020-05-13 | Carroll | Illinois | 17015 | 12 | 2 |
142784 | 142784 | 2020-05-14 | Carroll | Illinois | 17015 | 12 | 2 |
145784 | 145784 | 2020-05-15 | Carroll | Illinois | 17015 | 12 | 2 |
148787 | 148787 | 2020-05-16 | Carroll | Illinois | 17015 | 13 | 2 |
151796 | 151796 | 2020-05-17 | Carroll | Illinois | 17015 | 14 | 2 |
154808 | 154808 | 2020-05-18 | Carroll | Illinois | 17015 | 14 | 2 |
157824 | 157824 | 2020-05-19 | Carroll | Illinois | 17015 | 14 | 2 |
160850 | 160850 | 2020-05-20 | Carroll | Illinois | 17015 | 13 | 2 |
163878 | 163878 | 2020-05-21 | Carroll | Illinois | 17015 | 13 | 2 |
166911 | 166911 | 2020-05-22 | Carroll | Illinois | 17015 | 13 | 2 |
169948 | 169948 | 2020-05-23 | Carroll | Illinois | 17015 | 13 | 2 |
172989 | 172989 | 2020-05-24 | Carroll | Illinois | 17015 | 13 | 2 |
176033 | 176033 | 2020-05-25 | Carroll | Illinois | 17015 | 13 | 2 |
179077 | 179077 | 2020-05-26 | Carroll | Illinois | 17015 | 13 | 2 |
182121 | 182121 | 2020-05-27 | Carroll | Illinois | 17015 | 14 | 2 |
185175 | 185175 | 2020-05-28 | Carroll | Illinois | 17015 | 14 | 2 |
188232 | 188232 | 2020-05-29 | Carroll | Illinois | 17015 | 14 | 2 |
191297 | 191297 | 2020-05-30 | Carroll | Illinois | 17015 | 16 | 2 |
194364 | 194364 | 2020-05-31 | Carroll | Illinois | 17015 | 15 | 2 |
197434 | 197434 | 2020-06-01 | Carroll | Illinois | 17015 | 15 | 2 |
200507 | 200507 | 2020-06-02 | Carroll | Illinois | 17015 | 15 | 2 |
203583 | 203583 | 2020-06-03 | Carroll | Illinois | 17015 | 15 | 2 |
206663 | 206663 | 2020-06-04 | Carroll | Illinois | 17015 | 15 | 2 |
209744 | 209744 | 2020-06-05 | Carroll | Illinois | 17015 | 17 | 2 |
212829 | 212829 | 2020-06-06 | Carroll | Illinois | 17015 | 17 | 2 |
215916 | 215916 | 2020-06-07 | Carroll | Illinois | 17015 | 17 | 2 |
219007 | 219007 | 2020-06-08 | Carroll | Illinois | 17015 | 18 | 2 |
222102 | 222102 | 2020-06-09 | Carroll | Illinois | 17015 | 19 | 2 |
225197 | 225197 | 2020-06-10 | Carroll | Illinois | 17015 | 19 | 2 |
228299 | 228299 | 2020-06-11 | Carroll | Illinois | 17015 | 18 | 2 |
231402 | 231402 | 2020-06-12 | Carroll | Illinois | 17015 | 18 | 2 |
234508 | 234508 | 2020-06-13 | Carroll | Illinois | 17015 | 19 | 2 |
237615 | 237615 | 2020-06-14 | Carroll | Illinois | 17015 | 19 | 2 |
240723 | 240723 | 2020-06-15 | Carroll | Illinois | 17015 | 20 | 2 |
243834 | 243834 | 2020-06-16 | Carroll | Illinois | 17015 | 20 | 2 |
246947 | 246947 | 2020-06-17 | Carroll | Illinois | 17015 | 20 | 2 |
250059 | 250059 | 2020-06-18 | Carroll | Illinois | 17015 | 18 | 2 |
253174 | 253174 | 2020-06-19 | Carroll | Illinois | 17015 | 18 | 2 |
256294 | 256294 | 2020-06-20 | Carroll | Illinois | 17015 | 18 | 2 |
259420 | 259420 | 2020-06-21 | Carroll | Illinois | 17015 | 19 | 2 |
262547 | 262547 | 2020-06-22 | Carroll | Illinois | 17015 | 19 | 2 |
265675 | 265675 | 2020-06-23 | Carroll | Illinois | 17015 | 19 | 2 |
268805 | 268805 | 2020-06-24 | Carroll | Illinois | 17015 | 21 | 2 |
271942 | 271942 | 2020-06-25 | Carroll | Illinois | 17015 | 21 | 2 |
275084 | 275084 | 2020-06-26 | Carroll | Illinois | 17015 | 21 | 2 |
278232 | 278232 | 2020-06-27 | Carroll | Illinois | 17015 | 21 | 2 |
281380 | 281380 | 2020-06-28 | Carroll | Illinois | 17015 | 21 | 2 |
284525 | 284525 | 2020-06-29 | Carroll | Illinois | 17015 | 21 | 2 |
287674 | 287674 | 2020-06-30 | Carroll | Illinois | 17015 | 21 | 2 |
290824 | 290824 | 2020-07-01 | Carroll | Illinois | 17015 | 21 | 2 |
293978 | 293978 | 2020-07-02 | Carroll | Illinois | 17015 | 21 | 2 |
297135 | 297135 | 2020-07-03 | Carroll | Illinois | 17015 | 22 | 2 |
300297 | 300297 | 2020-07-04 | Carroll | Illinois | 17015 | 22 | 2 |
303461 | 303461 | 2020-07-05 | Carroll | Illinois | 17015 | 21 | 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);