ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
37 rows where county = "Macon", deaths = 22 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
380154 | 380154 | 2020-07-29 | Macon | Illinois | 17115 | 406 | 22 |
376937 | 376937 | 2020-07-28 | Macon | Illinois | 17115 | 386 | 22 |
373722 | 373722 | 2020-07-27 | Macon | Illinois | 17115 | 377 | 22 |
370510 | 370510 | 2020-07-26 | Macon | Illinois | 17115 | 354 | 22 |
367300 | 367300 | 2020-07-25 | Macon | Illinois | 17115 | 325 | 22 |
364093 | 364093 | 2020-07-24 | Macon | Illinois | 17115 | 311 | 22 |
360886 | 360886 | 2020-07-23 | Macon | Illinois | 17115 | 297 | 22 |
357681 | 357681 | 2020-07-22 | Macon | Illinois | 17115 | 288 | 22 |
354479 | 354479 | 2020-07-21 | Macon | Illinois | 17115 | 282 | 22 |
351277 | 351277 | 2020-07-20 | Macon | Illinois | 17115 | 282 | 22 |
348077 | 348077 | 2020-07-19 | Macon | Illinois | 17115 | 275 | 22 |
344876 | 344876 | 2020-07-18 | Macon | Illinois | 17115 | 270 | 22 |
341676 | 341676 | 2020-07-17 | Macon | Illinois | 17115 | 265 | 22 |
338480 | 338480 | 2020-07-16 | Macon | Illinois | 17115 | 262 | 22 |
335284 | 335284 | 2020-07-15 | Macon | Illinois | 17115 | 259 | 22 |
332091 | 332091 | 2020-07-14 | Macon | Illinois | 17115 | 254 | 22 |
328904 | 328904 | 2020-07-13 | Macon | Illinois | 17115 | 253 | 22 |
325718 | 325718 | 2020-07-12 | Macon | Illinois | 17115 | 253 | 22 |
322537 | 322537 | 2020-07-11 | Macon | Illinois | 17115 | 250 | 22 |
319358 | 319358 | 2020-07-10 | Macon | Illinois | 17115 | 243 | 22 |
316185 | 316185 | 2020-07-09 | Macon | Illinois | 17115 | 242 | 22 |
313011 | 313011 | 2020-07-08 | Macon | Illinois | 17115 | 241 | 22 |
309841 | 309841 | 2020-07-07 | Macon | Illinois | 17115 | 238 | 22 |
306673 | 306673 | 2020-07-06 | Macon | Illinois | 17115 | 236 | 22 |
303508 | 303508 | 2020-07-05 | Macon | Illinois | 17115 | 235 | 22 |
300344 | 300344 | 2020-07-04 | Macon | Illinois | 17115 | 234 | 22 |
297182 | 297182 | 2020-07-03 | Macon | Illinois | 17115 | 232 | 22 |
294025 | 294025 | 2020-07-02 | Macon | Illinois | 17115 | 232 | 22 |
290871 | 290871 | 2020-07-01 | Macon | Illinois | 17115 | 231 | 22 |
287721 | 287721 | 2020-06-30 | Macon | Illinois | 17115 | 232 | 22 |
284572 | 284572 | 2020-06-29 | Macon | Illinois | 17115 | 228 | 22 |
281427 | 281427 | 2020-06-28 | Macon | Illinois | 17115 | 227 | 22 |
278279 | 278279 | 2020-06-27 | Macon | Illinois | 17115 | 227 | 22 |
275131 | 275131 | 2020-06-26 | Macon | Illinois | 17115 | 227 | 22 |
271989 | 271989 | 2020-06-25 | Macon | Illinois | 17115 | 226 | 22 |
268852 | 268852 | 2020-06-24 | Macon | Illinois | 17115 | 223 | 22 |
265722 | 265722 | 2020-06-23 | Macon | Illinois | 17115 | 220 | 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);