ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Champaign" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
930783 | 930783 | 2021-01-15 | Champaign | Illinois | 17019 | 15239 | 95 |
927538 | 927538 | 2021-01-14 | Champaign | Illinois | 17019 | 15148 | 93 |
924292 | 924292 | 2021-01-13 | Champaign | Illinois | 17019 | 15044 | 93 |
921047 | 921047 | 2021-01-12 | Champaign | Illinois | 17019 | 14974 | 93 |
917802 | 917802 | 2021-01-11 | Champaign | Illinois | 17019 | 14893 | 92 |
914557 | 914557 | 2021-01-10 | Champaign | Illinois | 17019 | 14810 | 92 |
911312 | 911312 | 2021-01-09 | Champaign | Illinois | 17019 | 14756 | 92 |
908067 | 908067 | 2021-01-08 | Champaign | Illinois | 17019 | 14665 | 92 |
904821 | 904821 | 2021-01-07 | Champaign | Illinois | 17019 | 14537 | 92 |
901576 | 901576 | 2021-01-06 | Champaign | Illinois | 17019 | 14417 | 91 |
898331 | 898331 | 2021-01-05 | Champaign | Illinois | 17019 | 14298 | 90 |
895086 | 895086 | 2021-01-04 | Champaign | Illinois | 17019 | 14192 | 90 |
891839 | 891839 | 2021-01-03 | Champaign | Illinois | 17019 | 14160 | 89 |
888592 | 888592 | 2021-01-02 | Champaign | Illinois | 17019 | 14057 | 88 |
885347 | 885347 | 2021-01-01 | Champaign | Illinois | 17019 | 13954 | 88 |
882102 | 882102 | 2020-12-31 | Champaign | Illinois | 17019 | 13839 | 88 |
878857 | 878857 | 2020-12-30 | Champaign | Illinois | 17019 | 13789 | 88 |
875612 | 875612 | 2020-12-29 | Champaign | Illinois | 17019 | 13658 | 88 |
872367 | 872367 | 2020-12-28 | Champaign | Illinois | 17019 | 13582 | 87 |
869122 | 869122 | 2020-12-27 | Champaign | Illinois | 17019 | 13544 | 87 |
865877 | 865877 | 2020-12-26 | Champaign | Illinois | 17019 | 13468 | 87 |
862632 | 862632 | 2020-12-25 | Champaign | Illinois | 17019 | 13403 | 86 |
859387 | 859387 | 2020-12-24 | Champaign | Illinois | 17019 | 13335 | 85 |
856142 | 856142 | 2020-12-23 | Champaign | Illinois | 17019 | 13255 | 85 |
852897 | 852897 | 2020-12-22 | Champaign | Illinois | 17019 | 13174 | 83 |
849652 | 849652 | 2020-12-21 | Champaign | Illinois | 17019 | 13093 | 81 |
846407 | 846407 | 2020-12-20 | Champaign | Illinois | 17019 | 13015 | 79 |
843161 | 843161 | 2020-12-19 | Champaign | Illinois | 17019 | 12938 | 79 |
839916 | 839916 | 2020-12-18 | Champaign | Illinois | 17019 | 12820 | 78 |
836671 | 836671 | 2020-12-17 | Champaign | Illinois | 17019 | 12735 | 78 |
833425 | 833425 | 2020-12-16 | Champaign | Illinois | 17019 | 12631 | 77 |
830178 | 830178 | 2020-12-15 | Champaign | Illinois | 17019 | 12562 | 76 |
826932 | 826932 | 2020-12-14 | Champaign | Illinois | 17019 | 12503 | 75 |
823685 | 823685 | 2020-12-13 | Champaign | Illinois | 17019 | 12436 | 75 |
820439 | 820439 | 2020-12-12 | Champaign | Illinois | 17019 | 12327 | 75 |
817193 | 817193 | 2020-12-11 | Champaign | Illinois | 17019 | 12244 | 75 |
813947 | 813947 | 2020-12-10 | Champaign | Illinois | 17019 | 12151 | 73 |
810702 | 810702 | 2020-12-09 | Champaign | Illinois | 17019 | 12026 | 72 |
807457 | 807457 | 2020-12-08 | Champaign | Illinois | 17019 | 11928 | 70 |
804212 | 804212 | 2020-12-07 | Champaign | Illinois | 17019 | 11795 | 70 |
800967 | 800967 | 2020-12-06 | Champaign | Illinois | 17019 | 11698 | 69 |
797722 | 797722 | 2020-12-05 | Champaign | Illinois | 17019 | 11597 | 68 |
794477 | 794477 | 2020-12-04 | Champaign | Illinois | 17019 | 11436 | 63 |
791232 | 791232 | 2020-12-03 | Champaign | Illinois | 17019 | 11336 | 60 |
787987 | 787987 | 2020-12-02 | Champaign | Illinois | 17019 | 11181 | 60 |
784743 | 784743 | 2020-12-01 | Champaign | Illinois | 17019 | 11030 | 60 |
781498 | 781498 | 2020-11-30 | Champaign | Illinois | 17019 | 10906 | 58 |
778252 | 778252 | 2020-11-29 | Champaign | Illinois | 17019 | 10798 | 58 |
775007 | 775007 | 2020-11-28 | Champaign | Illinois | 17019 | 10686 | 57 |
771762 | 771762 | 2020-11-27 | Champaign | Illinois | 17019 | 10619 | 57 |
768517 | 768517 | 2020-11-26 | Champaign | Illinois | 17019 | 10538 | 57 |
765271 | 765271 | 2020-11-25 | Champaign | Illinois | 17019 | 10429 | 54 |
762026 | 762026 | 2020-11-24 | Champaign | Illinois | 17019 | 10316 | 52 |
758781 | 758781 | 2020-11-23 | Champaign | Illinois | 17019 | 10151 | 48 |
755534 | 755534 | 2020-11-22 | Champaign | Illinois | 17019 | 10068 | 47 |
752288 | 752288 | 2020-11-21 | Champaign | Illinois | 17019 | 9974 | 45 |
749042 | 749042 | 2020-11-20 | Champaign | Illinois | 17019 | 9813 | 43 |
745796 | 745796 | 2020-11-19 | Champaign | Illinois | 17019 | 9649 | 42 |
742549 | 742549 | 2020-11-18 | Champaign | Illinois | 17019 | 9429 | 41 |
739302 | 739302 | 2020-11-17 | Champaign | Illinois | 17019 | 9310 | 41 |
736058 | 736058 | 2020-11-16 | Champaign | Illinois | 17019 | 9117 | 40 |
732812 | 732812 | 2020-11-15 | Champaign | Illinois | 17019 | 8959 | 40 |
729567 | 729567 | 2020-11-14 | Champaign | Illinois | 17019 | 8849 | 40 |
726324 | 726324 | 2020-11-13 | Champaign | Illinois | 17019 | 8728 | 39 |
723081 | 723081 | 2020-11-12 | Champaign | Illinois | 17019 | 8558 | 37 |
719838 | 719838 | 2020-11-11 | Champaign | Illinois | 17019 | 8413 | 37 |
716595 | 716595 | 2020-11-10 | Champaign | Illinois | 17019 | 8180 | 37 |
713351 | 713351 | 2020-11-09 | Champaign | Illinois | 17019 | 8003 | 33 |
710107 | 710107 | 2020-11-08 | Champaign | Illinois | 17019 | 7866 | 33 |
706863 | 706863 | 2020-11-07 | Champaign | Illinois | 17019 | 7744 | 31 |
703620 | 703620 | 2020-11-06 | Champaign | Illinois | 17019 | 7572 | 30 |
700377 | 700377 | 2020-11-05 | Champaign | Illinois | 17019 | 7308 | 29 |
697133 | 697133 | 2020-11-04 | Champaign | Illinois | 17019 | 7114 | 29 |
693891 | 693891 | 2020-11-03 | Champaign | Illinois | 17019 | 6999 | 29 |
690648 | 690648 | 2020-11-02 | Champaign | Illinois | 17019 | 6906 | 29 |
687403 | 687403 | 2020-11-01 | Champaign | Illinois | 17019 | 6824 | 28 |
684159 | 684159 | 2020-10-31 | Champaign | Illinois | 17019 | 6585 | 28 |
680916 | 680916 | 2020-10-30 | Champaign | Illinois | 17019 | 6585 | 28 |
677673 | 677673 | 2020-10-29 | Champaign | Illinois | 17019 | 6462 | 28 |
674430 | 674430 | 2020-10-28 | Champaign | Illinois | 17019 | 6390 | 28 |
671188 | 671188 | 2020-10-27 | Champaign | Illinois | 17019 | 6285 | 29 |
667945 | 667945 | 2020-10-26 | Champaign | Illinois | 17019 | 6172 | 29 |
664701 | 664701 | 2020-10-25 | Champaign | Illinois | 17019 | 6091 | 29 |
661456 | 661456 | 2020-10-24 | Champaign | Illinois | 17019 | 6048 | 29 |
658212 | 658212 | 2020-10-23 | Champaign | Illinois | 17019 | 5945 | 28 |
654967 | 654967 | 2020-10-22 | Champaign | Illinois | 17019 | 5893 | 28 |
651722 | 651722 | 2020-10-21 | Champaign | Illinois | 17019 | 5819 | 28 |
648478 | 648478 | 2020-10-20 | Champaign | Illinois | 17019 | 5741 | 28 |
645233 | 645233 | 2020-10-19 | Champaign | Illinois | 17019 | 5680 | 28 |
641986 | 641986 | 2020-10-18 | Champaign | Illinois | 17019 | 5660 | 28 |
638739 | 638739 | 2020-10-17 | Champaign | Illinois | 17019 | 5634 | 28 |
635493 | 635493 | 2020-10-16 | Champaign | Illinois | 17019 | 5596 | 28 |
632247 | 632247 | 2020-10-15 | Champaign | Illinois | 17019 | 5559 | 28 |
629003 | 629003 | 2020-10-14 | Champaign | Illinois | 17019 | 5525 | 27 |
625760 | 625760 | 2020-10-13 | Champaign | Illinois | 17019 | 5434 | 27 |
622518 | 622518 | 2020-10-12 | Champaign | Illinois | 17019 | 5389 | 27 |
619274 | 619274 | 2020-10-11 | Champaign | Illinois | 17019 | 5352 | 27 |
616032 | 616032 | 2020-10-10 | Champaign | Illinois | 17019 | 5286 | 27 |
612791 | 612791 | 2020-10-09 | Champaign | Illinois | 17019 | 5270 | 27 |
609549 | 609549 | 2020-10-08 | Champaign | Illinois | 17019 | 5227 | 27 |
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);