ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where county = "Bond" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
281375 | 281375 | 2020-06-28 | Bond | Illinois | 17005 | 13 | 1 |
278227 | 278227 | 2020-06-27 | Bond | Illinois | 17005 | 13 | 1 |
275079 | 275079 | 2020-06-26 | Bond | Illinois | 17005 | 12 | 1 |
271937 | 271937 | 2020-06-25 | Bond | Illinois | 17005 | 12 | 1 |
268800 | 268800 | 2020-06-24 | Bond | Illinois | 17005 | 12 | 1 |
265670 | 265670 | 2020-06-23 | Bond | Illinois | 17005 | 12 | 1 |
262542 | 262542 | 2020-06-22 | Bond | Illinois | 17005 | 12 | 1 |
259415 | 259415 | 2020-06-21 | Bond | Illinois | 17005 | 12 | 1 |
256289 | 256289 | 2020-06-20 | Bond | Illinois | 17005 | 12 | 1 |
253169 | 253169 | 2020-06-19 | Bond | Illinois | 17005 | 12 | 1 |
250054 | 250054 | 2020-06-18 | Bond | Illinois | 17005 | 12 | 1 |
246942 | 246942 | 2020-06-17 | Bond | Illinois | 17005 | 12 | 1 |
243829 | 243829 | 2020-06-16 | Bond | Illinois | 17005 | 12 | 1 |
240718 | 240718 | 2020-06-15 | Bond | Illinois | 17005 | 12 | 1 |
237610 | 237610 | 2020-06-14 | Bond | Illinois | 17005 | 12 | 1 |
234503 | 234503 | 2020-06-13 | Bond | Illinois | 17005 | 12 | 1 |
231397 | 231397 | 2020-06-12 | Bond | Illinois | 17005 | 12 | 1 |
228294 | 228294 | 2020-06-11 | Bond | Illinois | 17005 | 12 | 1 |
225192 | 225192 | 2020-06-10 | Bond | Illinois | 17005 | 12 | 1 |
222097 | 222097 | 2020-06-09 | Bond | Illinois | 17005 | 12 | 1 |
219002 | 219002 | 2020-06-08 | Bond | Illinois | 17005 | 12 | 1 |
215911 | 215911 | 2020-06-07 | Bond | Illinois | 17005 | 12 | 1 |
212824 | 212824 | 2020-06-06 | Bond | Illinois | 17005 | 12 | 1 |
209739 | 209739 | 2020-06-05 | Bond | Illinois | 17005 | 12 | 1 |
206658 | 206658 | 2020-06-04 | Bond | Illinois | 17005 | 12 | 1 |
203578 | 203578 | 2020-06-03 | Bond | Illinois | 17005 | 12 | 1 |
200502 | 200502 | 2020-06-02 | Bond | Illinois | 17005 | 12 | 1 |
197429 | 197429 | 2020-06-01 | Bond | Illinois | 17005 | 12 | 1 |
194359 | 194359 | 2020-05-31 | Bond | Illinois | 17005 | 12 | 1 |
191292 | 191292 | 2020-05-30 | Bond | Illinois | 17005 | 12 | 1 |
188227 | 188227 | 2020-05-29 | Bond | Illinois | 17005 | 12 | 1 |
185170 | 185170 | 2020-05-28 | Bond | Illinois | 17005 | 12 | 1 |
182116 | 182116 | 2020-05-27 | Bond | Illinois | 17005 | 10 | 1 |
179072 | 179072 | 2020-05-26 | Bond | Illinois | 17005 | 10 | 1 |
176028 | 176028 | 2020-05-25 | Bond | Illinois | 17005 | 10 | 1 |
172984 | 172984 | 2020-05-24 | Bond | Illinois | 17005 | 10 | 1 |
169943 | 169943 | 2020-05-23 | Bond | Illinois | 17005 | 10 | 1 |
166906 | 166906 | 2020-05-22 | Bond | Illinois | 17005 | 10 | 1 |
163873 | 163873 | 2020-05-21 | Bond | Illinois | 17005 | 12 | 1 |
160845 | 160845 | 2020-05-20 | Bond | Illinois | 17005 | 12 | 1 |
157819 | 157819 | 2020-05-19 | Bond | Illinois | 17005 | 12 | 1 |
154803 | 154803 | 2020-05-18 | Bond | Illinois | 17005 | 11 | 1 |
151791 | 151791 | 2020-05-17 | Bond | Illinois | 17005 | 11 | 1 |
148782 | 148782 | 2020-05-16 | Bond | Illinois | 17005 | 11 | 1 |
145779 | 145779 | 2020-05-15 | Bond | Illinois | 17005 | 11 | 1 |
142779 | 142779 | 2020-05-14 | Bond | Illinois | 17005 | 10 | 1 |
139783 | 139783 | 2020-05-13 | Bond | Illinois | 17005 | 10 | 1 |
136792 | 136792 | 2020-05-12 | Bond | Illinois | 17005 | 9 | 1 |
133803 | 133803 | 2020-05-11 | Bond | Illinois | 17005 | 9 | 1 |
130812 | 130812 | 2020-05-10 | Bond | Illinois | 17005 | 8 | 1 |
127821 | 127821 | 2020-05-09 | Bond | Illinois | 17005 | 8 | 1 |
124834 | 124834 | 2020-05-08 | Bond | Illinois | 17005 | 8 | 1 |
121855 | 121855 | 2020-05-07 | Bond | Illinois | 17005 | 8 | 1 |
118885 | 118885 | 2020-05-06 | Bond | Illinois | 17005 | 8 | 1 |
115925 | 115925 | 2020-05-05 | Bond | Illinois | 17005 | 7 | 1 |
113042 | 113042 | 2020-05-04 | Bond | Illinois | 17005 | 6 | 1 |
110167 | 110167 | 2020-05-03 | Bond | Illinois | 17005 | 6 | 1 |
107297 | 107297 | 2020-05-02 | Bond | Illinois | 17005 | 6 | 1 |
104432 | 104432 | 2020-05-01 | Bond | Illinois | 17005 | 6 | 1 |
101577 | 101577 | 2020-04-30 | Bond | Illinois | 17005 | 6 | 1 |
98726 | 98726 | 2020-04-29 | Bond | Illinois | 17005 | 6 | 1 |
95882 | 95882 | 2020-04-28 | Bond | Illinois | 17005 | 5 | 1 |
93050 | 93050 | 2020-04-27 | Bond | Illinois | 17005 | 5 | 1 |
90231 | 90231 | 2020-04-26 | Bond | Illinois | 17005 | 5 | 1 |
87415 | 87415 | 2020-04-25 | Bond | Illinois | 17005 | 5 | 1 |
84605 | 84605 | 2020-04-24 | Bond | Illinois | 17005 | 4 | 1 |
81805 | 81805 | 2020-04-23 | Bond | Illinois | 17005 | 4 | 1 |
79012 | 79012 | 2020-04-22 | Bond | Illinois | 17005 | 4 | 1 |
76228 | 76228 | 2020-04-21 | Bond | Illinois | 17005 | 4 | 1 |
73452 | 73452 | 2020-04-20 | Bond | Illinois | 17005 | 4 | 1 |
70683 | 70683 | 2020-04-19 | Bond | Illinois | 17005 | 4 | 1 |
67921 | 67921 | 2020-04-18 | Bond | Illinois | 17005 | 4 | 1 |
65173 | 65173 | 2020-04-17 | Bond | Illinois | 17005 | 4 | 1 |
62441 | 62441 | 2020-04-16 | Bond | Illinois | 17005 | 4 | 1 |
59720 | 59720 | 2020-04-15 | Bond | Illinois | 17005 | 4 | 0 |
57013 | 57013 | 2020-04-14 | Bond | Illinois | 17005 | 4 | 0 |
54321 | 54321 | 2020-04-13 | Bond | Illinois | 17005 | 4 | 0 |
51641 | 51641 | 2020-04-12 | Bond | Illinois | 17005 | 4 | 0 |
48979 | 48979 | 2020-04-11 | Bond | Illinois | 17005 | 4 | 0 |
46348 | 46348 | 2020-04-10 | Bond | Illinois | 17005 | 4 | 0 |
43746 | 43746 | 2020-04-09 | Bond | Illinois | 17005 | 4 | 0 |
41172 | 41172 | 2020-04-08 | Bond | Illinois | 17005 | 3 | 0 |
38628 | 38628 | 2020-04-07 | Bond | Illinois | 17005 | 3 | 0 |
36134 | 36134 | 2020-04-06 | Bond | Illinois | 17005 | 3 | 0 |
33683 | 33683 | 2020-04-05 | Bond | Illinois | 17005 | 3 | 0 |
31276 | 31276 | 2020-04-04 | Bond | Illinois | 17005 | 3 | 0 |
28914 | 28914 | 2020-04-03 | Bond | Illinois | 17005 | 3 | 0 |
26607 | 26607 | 2020-04-02 | Bond | Illinois | 17005 | 3 | 0 |
24374 | 24374 | 2020-04-01 | Bond | Illinois | 17005 | 2 | 0 |
22206 | 22206 | 2020-03-31 | Bond | Illinois | 17005 | 2 | 0 |
20115 | 20115 | 2020-03-30 | Bond | Illinois | 17005 | 2 | 0 |
18115 | 18115 | 2020-03-29 | Bond | Illinois | 17005 | 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);