ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
113 rows where county = "Cass", deaths = 11 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
713350 | 713350 | 2020-11-09 | Cass | Illinois | 17017 | 572 | 11 |
710106 | 710106 | 2020-11-08 | Cass | Illinois | 17017 | 570 | 11 |
706862 | 706862 | 2020-11-07 | Cass | Illinois | 17017 | 564 | 11 |
703619 | 703619 | 2020-11-06 | Cass | Illinois | 17017 | 533 | 11 |
700376 | 700376 | 2020-11-05 | Cass | Illinois | 17017 | 484 | 11 |
697132 | 697132 | 2020-11-04 | Cass | Illinois | 17017 | 481 | 11 |
693890 | 693890 | 2020-11-03 | Cass | Illinois | 17017 | 478 | 11 |
690647 | 690647 | 2020-11-02 | Cass | Illinois | 17017 | 476 | 11 |
687402 | 687402 | 2020-11-01 | Cass | Illinois | 17017 | 476 | 11 |
684158 | 684158 | 2020-10-31 | Cass | Illinois | 17017 | 474 | 11 |
680915 | 680915 | 2020-10-30 | Cass | Illinois | 17017 | 474 | 11 |
677672 | 677672 | 2020-10-29 | Cass | Illinois | 17017 | 470 | 11 |
674429 | 674429 | 2020-10-28 | Cass | Illinois | 17017 | 468 | 11 |
671187 | 671187 | 2020-10-27 | Cass | Illinois | 17017 | 464 | 11 |
667944 | 667944 | 2020-10-26 | Cass | Illinois | 17017 | 463 | 11 |
664700 | 664700 | 2020-10-25 | Cass | Illinois | 17017 | 462 | 11 |
661455 | 661455 | 2020-10-24 | Cass | Illinois | 17017 | 460 | 11 |
658211 | 658211 | 2020-10-23 | Cass | Illinois | 17017 | 459 | 11 |
654966 | 654966 | 2020-10-22 | Cass | Illinois | 17017 | 455 | 11 |
651721 | 651721 | 2020-10-21 | Cass | Illinois | 17017 | 453 | 11 |
648477 | 648477 | 2020-10-20 | Cass | Illinois | 17017 | 450 | 11 |
645232 | 645232 | 2020-10-19 | Cass | Illinois | 17017 | 449 | 11 |
641985 | 641985 | 2020-10-18 | Cass | Illinois | 17017 | 449 | 11 |
638738 | 638738 | 2020-10-17 | Cass | Illinois | 17017 | 447 | 11 |
635492 | 635492 | 2020-10-16 | Cass | Illinois | 17017 | 445 | 11 |
632246 | 632246 | 2020-10-15 | Cass | Illinois | 17017 | 442 | 11 |
629002 | 629002 | 2020-10-14 | Cass | Illinois | 17017 | 435 | 11 |
625759 | 625759 | 2020-10-13 | Cass | Illinois | 17017 | 434 | 11 |
622517 | 622517 | 2020-10-12 | Cass | Illinois | 17017 | 433 | 11 |
619273 | 619273 | 2020-10-11 | Cass | Illinois | 17017 | 431 | 11 |
616031 | 616031 | 2020-10-10 | Cass | Illinois | 17017 | 428 | 11 |
612790 | 612790 | 2020-10-09 | Cass | Illinois | 17017 | 424 | 11 |
609548 | 609548 | 2020-10-08 | Cass | Illinois | 17017 | 421 | 11 |
606305 | 606305 | 2020-10-07 | Cass | Illinois | 17017 | 418 | 11 |
603063 | 603063 | 2020-10-06 | Cass | Illinois | 17017 | 415 | 11 |
599820 | 599820 | 2020-10-05 | Cass | Illinois | 17017 | 414 | 11 |
596578 | 596578 | 2020-10-04 | Cass | Illinois | 17017 | 414 | 11 |
593336 | 593336 | 2020-10-03 | Cass | Illinois | 17017 | 412 | 11 |
590095 | 590095 | 2020-10-02 | Cass | Illinois | 17017 | 412 | 11 |
586854 | 586854 | 2020-10-01 | Cass | Illinois | 17017 | 409 | 11 |
583614 | 583614 | 2020-09-30 | Cass | Illinois | 17017 | 404 | 11 |
580375 | 580375 | 2020-09-29 | Cass | Illinois | 17017 | 398 | 11 |
577134 | 577134 | 2020-09-28 | Cass | Illinois | 17017 | 398 | 11 |
573892 | 573892 | 2020-09-27 | Cass | Illinois | 17017 | 398 | 11 |
570649 | 570649 | 2020-09-26 | Cass | Illinois | 17017 | 395 | 11 |
567407 | 567407 | 2020-09-25 | Cass | Illinois | 17017 | 393 | 11 |
564167 | 564167 | 2020-09-24 | Cass | Illinois | 17017 | 393 | 11 |
560927 | 560927 | 2020-09-23 | Cass | Illinois | 17017 | 389 | 11 |
557691 | 557691 | 2020-09-22 | Cass | Illinois | 17017 | 384 | 11 |
554454 | 554454 | 2020-09-21 | Cass | Illinois | 17017 | 384 | 11 |
551215 | 551215 | 2020-09-20 | Cass | Illinois | 17017 | 384 | 11 |
547976 | 547976 | 2020-09-19 | Cass | Illinois | 17017 | 380 | 11 |
544738 | 544738 | 2020-09-18 | Cass | Illinois | 17017 | 372 | 11 |
541502 | 541502 | 2020-09-17 | Cass | Illinois | 17017 | 370 | 11 |
538265 | 538265 | 2020-09-16 | Cass | Illinois | 17017 | 363 | 11 |
535029 | 535029 | 2020-09-15 | Cass | Illinois | 17017 | 353 | 11 |
531794 | 531794 | 2020-09-14 | Cass | Illinois | 17017 | 350 | 11 |
528557 | 528557 | 2020-09-13 | Cass | Illinois | 17017 | 351 | 11 |
525321 | 525321 | 2020-09-12 | Cass | Illinois | 17017 | 348 | 11 |
522085 | 522085 | 2020-09-11 | Cass | Illinois | 17017 | 345 | 11 |
518848 | 518848 | 2020-09-10 | Cass | Illinois | 17017 | 341 | 11 |
515613 | 515613 | 2020-09-09 | Cass | Illinois | 17017 | 337 | 11 |
512380 | 512380 | 2020-09-08 | Cass | Illinois | 17017 | 337 | 11 |
509147 | 509147 | 2020-09-07 | Cass | Illinois | 17017 | 337 | 11 |
505915 | 505915 | 2020-09-06 | Cass | Illinois | 17017 | 337 | 11 |
502681 | 502681 | 2020-09-05 | Cass | Illinois | 17017 | 332 | 11 |
499447 | 499447 | 2020-09-04 | Cass | Illinois | 17017 | 332 | 11 |
496214 | 496214 | 2020-09-03 | Cass | Illinois | 17017 | 313 | 11 |
492980 | 492980 | 2020-09-02 | Cass | Illinois | 17017 | 309 | 11 |
489747 | 489747 | 2020-09-01 | Cass | Illinois | 17017 | 299 | 11 |
486514 | 486514 | 2020-08-31 | Cass | Illinois | 17017 | 299 | 11 |
483279 | 483279 | 2020-08-30 | Cass | Illinois | 17017 | 297 | 11 |
480045 | 480045 | 2020-08-29 | Cass | Illinois | 17017 | 298 | 11 |
476812 | 476812 | 2020-08-28 | Cass | Illinois | 17017 | 296 | 11 |
473579 | 473579 | 2020-08-27 | Cass | Illinois | 17017 | 297 | 11 |
470347 | 470347 | 2020-08-26 | Cass | Illinois | 17017 | 296 | 11 |
467118 | 467118 | 2020-08-25 | Cass | Illinois | 17017 | 290 | 11 |
463889 | 463889 | 2020-08-24 | Cass | Illinois | 17017 | 287 | 11 |
460660 | 460660 | 2020-08-23 | Cass | Illinois | 17017 | 287 | 11 |
457433 | 457433 | 2020-08-22 | Cass | Illinois | 17017 | 283 | 11 |
454205 | 454205 | 2020-08-21 | Cass | Illinois | 17017 | 278 | 11 |
450977 | 450977 | 2020-08-20 | Cass | Illinois | 17017 | 272 | 11 |
447749 | 447749 | 2020-08-19 | Cass | Illinois | 17017 | 265 | 11 |
444522 | 444522 | 2020-08-18 | Cass | Illinois | 17017 | 259 | 11 |
441296 | 441296 | 2020-08-17 | Cass | Illinois | 17017 | 258 | 11 |
438070 | 438070 | 2020-08-16 | Cass | Illinois | 17017 | 257 | 11 |
434844 | 434844 | 2020-08-15 | Cass | Illinois | 17017 | 251 | 11 |
431619 | 431619 | 2020-08-14 | Cass | Illinois | 17017 | 252 | 11 |
428391 | 428391 | 2020-08-13 | Cass | Illinois | 17017 | 245 | 11 |
425167 | 425167 | 2020-08-12 | Cass | Illinois | 17017 | 238 | 11 |
421946 | 421946 | 2020-08-11 | Cass | Illinois | 17017 | 233 | 11 |
418723 | 418723 | 2020-08-10 | Cass | Illinois | 17017 | 231 | 11 |
415502 | 415502 | 2020-08-09 | Cass | Illinois | 17017 | 231 | 11 |
412282 | 412282 | 2020-08-08 | Cass | Illinois | 17017 | 230 | 11 |
409063 | 409063 | 2020-08-07 | Cass | Illinois | 17017 | 223 | 11 |
405843 | 405843 | 2020-08-06 | Cass | Illinois | 17017 | 219 | 11 |
402625 | 402625 | 2020-08-05 | Cass | Illinois | 17017 | 214 | 11 |
399409 | 399409 | 2020-08-04 | Cass | Illinois | 17017 | 203 | 11 |
396193 | 396193 | 2020-08-03 | Cass | Illinois | 17017 | 202 | 11 |
392977 | 392977 | 2020-08-02 | Cass | Illinois | 17017 | 202 | 11 |
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);