ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where fips = 17115 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 |
---|---|---|---|---|---|---|---|
16240 | 16240 | 2020-03-28 | Macon | Illinois | 17115 | 1 | 0 |
18140 | 18140 | 2020-03-29 | Macon | Illinois | 17115 | 2 | 0 |
20142 | 20142 | 2020-03-30 | Macon | Illinois | 17115 | 2 | 0 |
22234 | 22234 | 2020-03-31 | Macon | Illinois | 17115 | 2 | 0 |
24402 | 24402 | 2020-04-01 | Macon | Illinois | 17115 | 2 | 0 |
26636 | 26636 | 2020-04-02 | Macon | Illinois | 17115 | 2 | 0 |
28946 | 28946 | 2020-04-03 | Macon | Illinois | 17115 | 2 | 0 |
31310 | 31310 | 2020-04-04 | Macon | Illinois | 17115 | 5 | 0 |
33720 | 33720 | 2020-04-05 | Macon | Illinois | 17115 | 6 | 0 |
36172 | 36172 | 2020-04-06 | Macon | Illinois | 17115 | 9 | 0 |
38668 | 38668 | 2020-04-07 | Macon | Illinois | 17115 | 12 | 0 |
41213 | 41213 | 2020-04-08 | Macon | Illinois | 17115 | 13 | 1 |
43787 | 43787 | 2020-04-09 | Macon | Illinois | 17115 | 15 | 1 |
46391 | 46391 | 2020-04-10 | Macon | Illinois | 17115 | 14 | 1 |
49022 | 49022 | 2020-04-11 | Macon | Illinois | 17115 | 23 | 1 |
51684 | 51684 | 2020-04-12 | Macon | Illinois | 17115 | 35 | 1 |
54365 | 54365 | 2020-04-13 | Macon | Illinois | 17115 | 42 | 3 |
57058 | 57058 | 2020-04-14 | Macon | Illinois | 17115 | 45 | 3 |
59765 | 59765 | 2020-04-15 | Macon | Illinois | 17115 | 44 | 5 |
62486 | 62486 | 2020-04-16 | Macon | Illinois | 17115 | 47 | 6 |
65219 | 65219 | 2020-04-17 | Macon | Illinois | 17115 | 47 | 6 |
67968 | 67968 | 2020-04-18 | Macon | Illinois | 17115 | 55 | 7 |
70730 | 70730 | 2020-04-19 | Macon | Illinois | 17115 | 54 | 7 |
73500 | 73500 | 2020-04-20 | Macon | Illinois | 17115 | 55 | 9 |
76277 | 76277 | 2020-04-21 | Macon | Illinois | 17115 | 60 | 9 |
79061 | 79061 | 2020-04-22 | Macon | Illinois | 17115 | 93 | 10 |
81854 | 81854 | 2020-04-23 | Macon | Illinois | 17115 | 96 | 10 |
84654 | 84654 | 2020-04-24 | Macon | Illinois | 17115 | 99 | 10 |
87464 | 87464 | 2020-04-25 | Macon | Illinois | 17115 | 100 | 11 |
90280 | 90280 | 2020-04-26 | Macon | Illinois | 17115 | 102 | 11 |
93099 | 93099 | 2020-04-27 | Macon | Illinois | 17115 | 103 | 11 |
95931 | 95931 | 2020-04-28 | Macon | Illinois | 17115 | 103 | 11 |
98775 | 98775 | 2020-04-29 | Macon | Illinois | 17115 | 105 | 11 |
101626 | 101626 | 2020-04-30 | Macon | Illinois | 17115 | 106 | 12 |
104482 | 104482 | 2020-05-01 | Macon | Illinois | 17115 | 109 | 12 |
107347 | 107347 | 2020-05-02 | Macon | Illinois | 17115 | 119 | 12 |
110217 | 110217 | 2020-05-03 | Macon | Illinois | 17115 | 122 | 12 |
113092 | 113092 | 2020-05-04 | Macon | Illinois | 17115 | 124 | 13 |
115975 | 115975 | 2020-05-05 | Macon | Illinois | 17115 | 126 | 13 |
118935 | 118935 | 2020-05-06 | Macon | Illinois | 17115 | 129 | 13 |
121905 | 121905 | 2020-05-07 | Macon | Illinois | 17115 | 133 | 14 |
124884 | 124884 | 2020-05-08 | Macon | Illinois | 17115 | 138 | 15 |
127871 | 127871 | 2020-05-09 | Macon | Illinois | 17115 | 140 | 15 |
130862 | 130862 | 2020-05-10 | Macon | Illinois | 17115 | 144 | 15 |
133853 | 133853 | 2020-05-11 | Macon | Illinois | 17115 | 146 | 15 |
136842 | 136842 | 2020-05-12 | Macon | Illinois | 17115 | 149 | 16 |
139834 | 139834 | 2020-05-13 | Macon | Illinois | 17115 | 151 | 16 |
142830 | 142830 | 2020-05-14 | Macon | Illinois | 17115 | 154 | 16 |
145830 | 145830 | 2020-05-15 | Macon | Illinois | 17115 | 159 | 17 |
148833 | 148833 | 2020-05-16 | Macon | Illinois | 17115 | 163 | 17 |
151842 | 151842 | 2020-05-17 | Macon | Illinois | 17115 | 165 | 17 |
154854 | 154854 | 2020-05-18 | Macon | Illinois | 17115 | 169 | 17 |
157870 | 157870 | 2020-05-19 | Macon | Illinois | 17115 | 170 | 17 |
160896 | 160896 | 2020-05-20 | Macon | Illinois | 17115 | 176 | 17 |
163924 | 163924 | 2020-05-21 | Macon | Illinois | 17115 | 182 | 17 |
166957 | 166957 | 2020-05-22 | Macon | Illinois | 17115 | 184 | 17 |
169994 | 169994 | 2020-05-23 | Macon | Illinois | 17115 | 187 | 18 |
173035 | 173035 | 2020-05-24 | Macon | Illinois | 17115 | 187 | 19 |
176079 | 176079 | 2020-05-25 | Macon | Illinois | 17115 | 188 | 19 |
179123 | 179123 | 2020-05-26 | Macon | Illinois | 17115 | 188 | 19 |
182167 | 182167 | 2020-05-27 | Macon | Illinois | 17115 | 189 | 19 |
185221 | 185221 | 2020-05-28 | Macon | Illinois | 17115 | 192 | 19 |
188279 | 188279 | 2020-05-29 | Macon | Illinois | 17115 | 195 | 19 |
191344 | 191344 | 2020-05-30 | Macon | Illinois | 17115 | 194 | 19 |
194411 | 194411 | 2020-05-31 | Macon | Illinois | 17115 | 193 | 19 |
197481 | 197481 | 2020-06-01 | Macon | Illinois | 17115 | 194 | 19 |
200554 | 200554 | 2020-06-02 | Macon | Illinois | 17115 | 194 | 19 |
203630 | 203630 | 2020-06-03 | Macon | Illinois | 17115 | 195 | 19 |
206710 | 206710 | 2020-06-04 | Macon | Illinois | 17115 | 199 | 20 |
209791 | 209791 | 2020-06-05 | Macon | Illinois | 17115 | 200 | 20 |
212876 | 212876 | 2020-06-06 | Macon | Illinois | 17115 | 202 | 21 |
215963 | 215963 | 2020-06-07 | Macon | Illinois | 17115 | 202 | 21 |
219054 | 219054 | 2020-06-08 | Macon | Illinois | 17115 | 203 | 21 |
222149 | 222149 | 2020-06-09 | Macon | Illinois | 17115 | 203 | 21 |
225244 | 225244 | 2020-06-10 | Macon | Illinois | 17115 | 204 | 21 |
228346 | 228346 | 2020-06-11 | Macon | Illinois | 17115 | 206 | 21 |
231449 | 231449 | 2020-06-12 | Macon | Illinois | 17115 | 206 | 21 |
234555 | 234555 | 2020-06-13 | Macon | Illinois | 17115 | 207 | 21 |
237662 | 237662 | 2020-06-14 | Macon | Illinois | 17115 | 209 | 21 |
240770 | 240770 | 2020-06-15 | Macon | Illinois | 17115 | 209 | 21 |
243881 | 243881 | 2020-06-16 | Macon | Illinois | 17115 | 212 | 21 |
246994 | 246994 | 2020-06-17 | Macon | Illinois | 17115 | 213 | 21 |
250106 | 250106 | 2020-06-18 | Macon | Illinois | 17115 | 214 | 21 |
253221 | 253221 | 2020-06-19 | Macon | Illinois | 17115 | 216 | 21 |
256341 | 256341 | 2020-06-20 | Macon | Illinois | 17115 | 218 | 21 |
259467 | 259467 | 2020-06-21 | Macon | Illinois | 17115 | 218 | 21 |
262594 | 262594 | 2020-06-22 | Macon | Illinois | 17115 | 219 | 21 |
265722 | 265722 | 2020-06-23 | Macon | Illinois | 17115 | 220 | 22 |
268852 | 268852 | 2020-06-24 | Macon | Illinois | 17115 | 223 | 22 |
271989 | 271989 | 2020-06-25 | Macon | Illinois | 17115 | 226 | 22 |
275131 | 275131 | 2020-06-26 | Macon | Illinois | 17115 | 227 | 22 |
278279 | 278279 | 2020-06-27 | Macon | Illinois | 17115 | 227 | 22 |
281427 | 281427 | 2020-06-28 | Macon | Illinois | 17115 | 227 | 22 |
284572 | 284572 | 2020-06-29 | Macon | Illinois | 17115 | 228 | 22 |
287721 | 287721 | 2020-06-30 | Macon | Illinois | 17115 | 232 | 22 |
290871 | 290871 | 2020-07-01 | Macon | Illinois | 17115 | 231 | 22 |
294025 | 294025 | 2020-07-02 | Macon | Illinois | 17115 | 232 | 22 |
297182 | 297182 | 2020-07-03 | Macon | Illinois | 17115 | 232 | 22 |
300344 | 300344 | 2020-07-04 | Macon | Illinois | 17115 | 234 | 22 |
303508 | 303508 | 2020-07-05 | Macon | Illinois | 17115 | 235 | 22 |
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);