ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "LaSalle" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
930822 | 930822 | 2021-01-15 | LaSalle | Illinois | 17099 | 9271 | 247 |
927577 | 927577 | 2021-01-14 | LaSalle | Illinois | 17099 | 9212 | 247 |
924331 | 924331 | 2021-01-13 | LaSalle | Illinois | 17099 | 9113 | 245 |
921086 | 921086 | 2021-01-12 | LaSalle | Illinois | 17099 | 9031 | 244 |
917841 | 917841 | 2021-01-11 | LaSalle | Illinois | 17099 | 8991 | 244 |
914596 | 914596 | 2021-01-10 | LaSalle | Illinois | 17099 | 8955 | 240 |
911351 | 911351 | 2021-01-09 | LaSalle | Illinois | 17099 | 8906 | 240 |
908106 | 908106 | 2021-01-08 | LaSalle | Illinois | 17099 | 8848 | 239 |
904860 | 904860 | 2021-01-07 | LaSalle | Illinois | 17099 | 8763 | 237 |
901615 | 901615 | 2021-01-06 | LaSalle | Illinois | 17099 | 8660 | 237 |
898370 | 898370 | 2021-01-05 | LaSalle | Illinois | 17099 | 8566 | 235 |
895125 | 895125 | 2021-01-04 | LaSalle | Illinois | 17099 | 8536 | 230 |
891878 | 891878 | 2021-01-03 | LaSalle | Illinois | 17099 | 8512 | 230 |
888631 | 888631 | 2021-01-02 | LaSalle | Illinois | 17099 | 8471 | 230 |
885386 | 885386 | 2021-01-01 | LaSalle | Illinois | 17099 | 8363 | 230 |
882141 | 882141 | 2020-12-31 | LaSalle | Illinois | 17099 | 8363 | 230 |
878896 | 878896 | 2020-12-30 | LaSalle | Illinois | 17099 | 8292 | 230 |
875651 | 875651 | 2020-12-29 | LaSalle | Illinois | 17099 | 8199 | 222 |
872406 | 872406 | 2020-12-28 | LaSalle | Illinois | 17099 | 8160 | 221 |
869161 | 869161 | 2020-12-27 | LaSalle | Illinois | 17099 | 8135 | 219 |
865916 | 865916 | 2020-12-26 | LaSalle | Illinois | 17099 | 8108 | 219 |
862671 | 862671 | 2020-12-25 | LaSalle | Illinois | 17099 | 8059 | 219 |
859426 | 859426 | 2020-12-24 | LaSalle | Illinois | 17099 | 8008 | 217 |
856181 | 856181 | 2020-12-23 | LaSalle | Illinois | 17099 | 7951 | 212 |
852936 | 852936 | 2020-12-22 | LaSalle | Illinois | 17099 | 7868 | 210 |
849691 | 849691 | 2020-12-21 | LaSalle | Illinois | 17099 | 7828 | 202 |
846446 | 846446 | 2020-12-20 | LaSalle | Illinois | 17099 | 7810 | 200 |
843200 | 843200 | 2020-12-19 | LaSalle | Illinois | 17099 | 7762 | 199 |
839955 | 839955 | 2020-12-18 | LaSalle | Illinois | 17099 | 7727 | 192 |
836710 | 836710 | 2020-12-17 | LaSalle | Illinois | 17099 | 7679 | 189 |
833464 | 833464 | 2020-12-16 | LaSalle | Illinois | 17099 | 7629 | 184 |
830217 | 830217 | 2020-12-15 | LaSalle | Illinois | 17099 | 7542 | 182 |
826971 | 826971 | 2020-12-14 | LaSalle | Illinois | 17099 | 7504 | 178 |
823724 | 823724 | 2020-12-13 | LaSalle | Illinois | 17099 | 7430 | 177 |
820478 | 820478 | 2020-12-12 | LaSalle | Illinois | 17099 | 7364 | 176 |
817232 | 817232 | 2020-12-11 | LaSalle | Illinois | 17099 | 7274 | 169 |
813986 | 813986 | 2020-12-10 | LaSalle | Illinois | 17099 | 7157 | 167 |
810741 | 810741 | 2020-12-09 | LaSalle | Illinois | 17099 | 7041 | 163 |
807496 | 807496 | 2020-12-08 | LaSalle | Illinois | 17099 | 6971 | 160 |
804251 | 804251 | 2020-12-07 | LaSalle | Illinois | 17099 | 6885 | 153 |
801006 | 801006 | 2020-12-06 | LaSalle | Illinois | 17099 | 6797 | 153 |
797761 | 797761 | 2020-12-05 | LaSalle | Illinois | 17099 | 6728 | 153 |
794516 | 794516 | 2020-12-04 | LaSalle | Illinois | 17099 | 6587 | 149 |
791271 | 791271 | 2020-12-03 | LaSalle | Illinois | 17099 | 6471 | 144 |
788026 | 788026 | 2020-12-02 | LaSalle | Illinois | 17099 | 6358 | 144 |
784782 | 784782 | 2020-12-01 | LaSalle | Illinois | 17099 | 6274 | 139 |
781537 | 781537 | 2020-11-30 | LaSalle | Illinois | 17099 | 6161 | 136 |
778291 | 778291 | 2020-11-29 | LaSalle | Illinois | 17099 | 6108 | 134 |
775046 | 775046 | 2020-11-28 | LaSalle | Illinois | 17099 | 6041 | 133 |
771801 | 771801 | 2020-11-27 | LaSalle | Illinois | 17099 | 5975 | 133 |
768556 | 768556 | 2020-11-26 | LaSalle | Illinois | 17099 | 5907 | 132 |
765310 | 765310 | 2020-11-25 | LaSalle | Illinois | 17099 | 5808 | 130 |
762065 | 762065 | 2020-11-24 | LaSalle | Illinois | 17099 | 5687 | 127 |
758820 | 758820 | 2020-11-23 | LaSalle | Illinois | 17099 | 5608 | 119 |
755573 | 755573 | 2020-11-22 | LaSalle | Illinois | 17099 | 5548 | 119 |
752327 | 752327 | 2020-11-21 | LaSalle | Illinois | 17099 | 5450 | 119 |
749081 | 749081 | 2020-11-20 | LaSalle | Illinois | 17099 | 5331 | 116 |
745835 | 745835 | 2020-11-19 | LaSalle | Illinois | 17099 | 5187 | 111 |
742588 | 742588 | 2020-11-18 | LaSalle | Illinois | 17099 | 5059 | 107 |
739341 | 739341 | 2020-11-17 | LaSalle | Illinois | 17099 | 4885 | 100 |
736097 | 736097 | 2020-11-16 | LaSalle | Illinois | 17099 | 4775 | 100 |
732851 | 732851 | 2020-11-15 | LaSalle | Illinois | 17099 | 4658 | 95 |
729606 | 729606 | 2020-11-14 | LaSalle | Illinois | 17099 | 4559 | 91 |
726363 | 726363 | 2020-11-13 | LaSalle | Illinois | 17099 | 4386 | 90 |
723120 | 723120 | 2020-11-12 | LaSalle | Illinois | 17099 | 4174 | 88 |
719877 | 719877 | 2020-11-11 | LaSalle | Illinois | 17099 | 4046 | 87 |
716634 | 716634 | 2020-11-10 | LaSalle | Illinois | 17099 | 3891 | 87 |
713390 | 713390 | 2020-11-09 | LaSalle | Illinois | 17099 | 3763 | 82 |
710146 | 710146 | 2020-11-08 | LaSalle | Illinois | 17099 | 3606 | 81 |
706902 | 706902 | 2020-11-07 | LaSalle | Illinois | 17099 | 3490 | 80 |
703659 | 703659 | 2020-11-06 | LaSalle | Illinois | 17099 | 3356 | 79 |
700416 | 700416 | 2020-11-05 | LaSalle | Illinois | 17099 | 3136 | 73 |
697172 | 697172 | 2020-11-04 | LaSalle | Illinois | 17099 | 2997 | 70 |
693930 | 693930 | 2020-11-03 | LaSalle | Illinois | 17099 | 2937 | 70 |
690687 | 690687 | 2020-11-02 | LaSalle | Illinois | 17099 | 2842 | 69 |
687442 | 687442 | 2020-11-01 | LaSalle | Illinois | 17099 | 2776 | 69 |
684198 | 684198 | 2020-10-31 | LaSalle | Illinois | 17099 | 2652 | 68 |
680955 | 680955 | 2020-10-30 | LaSalle | Illinois | 17099 | 2652 | 68 |
677712 | 677712 | 2020-10-29 | LaSalle | Illinois | 17099 | 2584 | 67 |
674469 | 674469 | 2020-10-28 | LaSalle | Illinois | 17099 | 2554 | 65 |
671227 | 671227 | 2020-10-27 | LaSalle | Illinois | 17099 | 2473 | 65 |
667984 | 667984 | 2020-10-26 | LaSalle | Illinois | 17099 | 2426 | 63 |
664740 | 664740 | 2020-10-25 | LaSalle | Illinois | 17099 | 2408 | 63 |
661495 | 661495 | 2020-10-24 | LaSalle | Illinois | 17099 | 2378 | 63 |
658251 | 658251 | 2020-10-23 | LaSalle | Illinois | 17099 | 2320 | 63 |
655006 | 655006 | 2020-10-22 | LaSalle | Illinois | 17099 | 2281 | 61 |
651761 | 651761 | 2020-10-21 | LaSalle | Illinois | 17099 | 2235 | 60 |
648517 | 648517 | 2020-10-20 | LaSalle | Illinois | 17099 | 2207 | 60 |
645272 | 645272 | 2020-10-19 | LaSalle | Illinois | 17099 | 2184 | 60 |
642025 | 642025 | 2020-10-18 | LaSalle | Illinois | 17099 | 2157 | 59 |
638778 | 638778 | 2020-10-17 | LaSalle | Illinois | 17099 | 2128 | 59 |
635532 | 635532 | 2020-10-16 | LaSalle | Illinois | 17099 | 2100 | 58 |
632286 | 632286 | 2020-10-15 | LaSalle | Illinois | 17099 | 2069 | 58 |
629042 | 629042 | 2020-10-14 | LaSalle | Illinois | 17099 | 2041 | 58 |
625799 | 625799 | 2020-10-13 | LaSalle | Illinois | 17099 | 2004 | 58 |
622557 | 622557 | 2020-10-12 | LaSalle | Illinois | 17099 | 1995 | 58 |
619313 | 619313 | 2020-10-11 | LaSalle | Illinois | 17099 | 1974 | 58 |
616071 | 616071 | 2020-10-10 | LaSalle | Illinois | 17099 | 1947 | 58 |
612830 | 612830 | 2020-10-09 | LaSalle | Illinois | 17099 | 1926 | 57 |
609588 | 609588 | 2020-10-08 | LaSalle | Illinois | 17099 | 1910 | 57 |
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);