ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
763 rows where county = "Warren" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635578 | 635578 | 2020-10-16 | Warren | Illinois | 17187 | 432 | 6 |
632332 | 632332 | 2020-10-15 | Warren | Illinois | 17187 | 428 | 6 |
629088 | 629088 | 2020-10-14 | Warren | Illinois | 17187 | 414 | 6 |
625845 | 625845 | 2020-10-13 | Warren | Illinois | 17187 | 399 | 6 |
622603 | 622603 | 2020-10-12 | Warren | Illinois | 17187 | 394 | 5 |
619359 | 619359 | 2020-10-11 | Warren | Illinois | 17187 | 393 | 5 |
616117 | 616117 | 2020-10-10 | Warren | Illinois | 17187 | 385 | 4 |
612876 | 612876 | 2020-10-09 | Warren | Illinois | 17187 | 376 | 4 |
609634 | 609634 | 2020-10-08 | Warren | Illinois | 17187 | 373 | 3 |
606391 | 606391 | 2020-10-07 | Warren | Illinois | 17187 | 369 | 3 |
603149 | 603149 | 2020-10-06 | Warren | Illinois | 17187 | 363 | 3 |
599906 | 599906 | 2020-10-05 | Warren | Illinois | 17187 | 357 | 3 |
596664 | 596664 | 2020-10-04 | Warren | Illinois | 17187 | 354 | 3 |
593422 | 593422 | 2020-10-03 | Warren | Illinois | 17187 | 351 | 3 |
590181 | 590181 | 2020-10-02 | Warren | Illinois | 17187 | 343 | 3 |
586940 | 586940 | 2020-10-01 | Warren | Illinois | 17187 | 338 | 2 |
583700 | 583700 | 2020-09-30 | Warren | Illinois | 17187 | 334 | 2 |
580461 | 580461 | 2020-09-29 | Warren | Illinois | 17187 | 333 | 2 |
577220 | 577220 | 2020-09-28 | Warren | Illinois | 17187 | 333 | 2 |
573978 | 573978 | 2020-09-27 | Warren | Illinois | 17187 | 332 | 2 |
570735 | 570735 | 2020-09-26 | Warren | Illinois | 17187 | 330 | 2 |
567493 | 567493 | 2020-09-25 | Warren | Illinois | 17187 | 327 | 2 |
564253 | 564253 | 2020-09-24 | Warren | Illinois | 17187 | 319 | 2 |
561013 | 561013 | 2020-09-23 | Warren | Illinois | 17187 | 314 | 2 |
557777 | 557777 | 2020-09-22 | Warren | Illinois | 17187 | 307 | 2 |
554540 | 554540 | 2020-09-21 | Warren | Illinois | 17187 | 305 | 2 |
551301 | 551301 | 2020-09-20 | Warren | Illinois | 17187 | 304 | 2 |
548062 | 548062 | 2020-09-19 | Warren | Illinois | 17187 | 300 | 2 |
544824 | 544824 | 2020-09-18 | Warren | Illinois | 17187 | 294 | 1 |
541588 | 541588 | 2020-09-17 | Warren | Illinois | 17187 | 289 | 1 |
538351 | 538351 | 2020-09-16 | Warren | Illinois | 17187 | 288 | 1 |
535115 | 535115 | 2020-09-15 | Warren | Illinois | 17187 | 288 | 1 |
531880 | 531880 | 2020-09-14 | Warren | Illinois | 17187 | 282 | 1 |
528643 | 528643 | 2020-09-13 | Warren | Illinois | 17187 | 282 | 1 |
525407 | 525407 | 2020-09-12 | Warren | Illinois | 17187 | 282 | 1 |
522171 | 522171 | 2020-09-11 | Warren | Illinois | 17187 | 279 | 1 |
518934 | 518934 | 2020-09-10 | Warren | Illinois | 17187 | 279 | 1 |
515699 | 515699 | 2020-09-09 | Warren | Illinois | 17187 | 277 | 1 |
512466 | 512466 | 2020-09-08 | Warren | Illinois | 17187 | 276 | 1 |
509233 | 509233 | 2020-09-07 | Warren | Illinois | 17187 | 276 | 1 |
506001 | 506001 | 2020-09-06 | Warren | Illinois | 17187 | 273 | 1 |
502767 | 502767 | 2020-09-05 | Warren | Illinois | 17187 | 270 | 1 |
499533 | 499533 | 2020-09-04 | Warren | Illinois | 17187 | 270 | 1 |
496300 | 496300 | 2020-09-03 | Warren | Illinois | 17187 | 265 | 1 |
493066 | 493066 | 2020-09-02 | Warren | Illinois | 17187 | 264 | 1 |
489833 | 489833 | 2020-09-01 | Warren | Illinois | 17187 | 258 | 1 |
486600 | 486600 | 2020-08-31 | Warren | Illinois | 17187 | 258 | 1 |
483365 | 483365 | 2020-08-30 | Warren | Illinois | 17187 | 255 | 1 |
480131 | 480131 | 2020-08-29 | Warren | Illinois | 17187 | 250 | 1 |
476898 | 476898 | 2020-08-28 | Warren | Illinois | 17187 | 247 | 1 |
473665 | 473665 | 2020-08-27 | Warren | Illinois | 17187 | 241 | 1 |
470433 | 470433 | 2020-08-26 | Warren | Illinois | 17187 | 238 | 1 |
467204 | 467204 | 2020-08-25 | Warren | Illinois | 17187 | 231 | 0 |
463975 | 463975 | 2020-08-24 | Warren | Illinois | 17187 | 230 | 0 |
460746 | 460746 | 2020-08-23 | Warren | Illinois | 17187 | 228 | 0 |
457519 | 457519 | 2020-08-22 | Warren | Illinois | 17187 | 226 | 0 |
454291 | 454291 | 2020-08-21 | Warren | Illinois | 17187 | 219 | 0 |
451063 | 451063 | 2020-08-20 | Warren | Illinois | 17187 | 213 | 0 |
447835 | 447835 | 2020-08-19 | Warren | Illinois | 17187 | 210 | 0 |
444608 | 444608 | 2020-08-18 | Warren | Illinois | 17187 | 209 | 0 |
441382 | 441382 | 2020-08-17 | Warren | Illinois | 17187 | 205 | 0 |
438156 | 438156 | 2020-08-16 | Warren | Illinois | 17187 | 203 | 0 |
434930 | 434930 | 2020-08-15 | Warren | Illinois | 17187 | 199 | 0 |
431705 | 431705 | 2020-08-14 | Warren | Illinois | 17187 | 196 | 0 |
428477 | 428477 | 2020-08-13 | Warren | Illinois | 17187 | 196 | 0 |
425253 | 425253 | 2020-08-12 | Warren | Illinois | 17187 | 194 | 0 |
422032 | 422032 | 2020-08-11 | Warren | Illinois | 17187 | 191 | 0 |
418809 | 418809 | 2020-08-10 | Warren | Illinois | 17187 | 191 | 0 |
415588 | 415588 | 2020-08-09 | Warren | Illinois | 17187 | 190 | 0 |
412368 | 412368 | 2020-08-08 | Warren | Illinois | 17187 | 190 | 0 |
409149 | 409149 | 2020-08-07 | Warren | Illinois | 17187 | 189 | 0 |
405929 | 405929 | 2020-08-06 | Warren | Illinois | 17187 | 187 | 0 |
402711 | 402711 | 2020-08-05 | Warren | Illinois | 17187 | 185 | 0 |
399495 | 399495 | 2020-08-04 | Warren | Illinois | 17187 | 184 | 0 |
396279 | 396279 | 2020-08-03 | Warren | Illinois | 17187 | 183 | 0 |
393063 | 393063 | 2020-08-02 | Warren | Illinois | 17187 | 180 | 0 |
389846 | 389846 | 2020-08-01 | Warren | Illinois | 17187 | 180 | 0 |
386629 | 386629 | 2020-07-31 | Warren | Illinois | 17187 | 179 | 0 |
383411 | 383411 | 2020-07-30 | Warren | Illinois | 17187 | 175 | 0 |
380194 | 380194 | 2020-07-29 | Warren | Illinois | 17187 | 175 | 0 |
376977 | 376977 | 2020-07-28 | Warren | Illinois | 17187 | 172 | 0 |
373762 | 373762 | 2020-07-27 | Warren | Illinois | 17187 | 170 | 0 |
370550 | 370550 | 2020-07-26 | Warren | Illinois | 17187 | 170 | 0 |
367340 | 367340 | 2020-07-25 | Warren | Illinois | 17187 | 164 | 0 |
364133 | 364133 | 2020-07-24 | Warren | Illinois | 17187 | 162 | 0 |
360926 | 360926 | 2020-07-23 | Warren | Illinois | 17187 | 160 | 0 |
357721 | 357721 | 2020-07-22 | Warren | Illinois | 17187 | 158 | 0 |
354519 | 354519 | 2020-07-21 | Warren | Illinois | 17187 | 154 | 0 |
351317 | 351317 | 2020-07-20 | Warren | Illinois | 17187 | 153 | 0 |
348117 | 348117 | 2020-07-19 | Warren | Illinois | 17187 | 152 | 0 |
344916 | 344916 | 2020-07-18 | Warren | Illinois | 17187 | 152 | 0 |
341716 | 341716 | 2020-07-17 | Warren | Illinois | 17187 | 150 | 0 |
338520 | 338520 | 2020-07-16 | Warren | Illinois | 17187 | 150 | 0 |
335324 | 335324 | 2020-07-15 | Warren | Illinois | 17187 | 150 | 0 |
332131 | 332131 | 2020-07-14 | Warren | Illinois | 17187 | 150 | 0 |
328944 | 328944 | 2020-07-13 | Warren | Illinois | 17187 | 150 | 0 |
325758 | 325758 | 2020-07-12 | Warren | Illinois | 17187 | 149 | 0 |
322577 | 322577 | 2020-07-11 | Warren | Illinois | 17187 | 149 | 0 |
319398 | 319398 | 2020-07-10 | Warren | Illinois | 17187 | 147 | 0 |
316225 | 316225 | 2020-07-09 | Warren | Illinois | 17187 | 147 | 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);