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 |
---|---|---|---|---|---|---|---|
1093101 | 1093101 | 2021-03-06 | LaSalle | Illinois | 17099 | 10910 | 277 |
1089855 | 1089855 | 2021-03-05 | LaSalle | Illinois | 17099 | 10884 | 277 |
1086610 | 1086610 | 2021-03-04 | LaSalle | Illinois | 17099 | 10861 | 276 |
1083364 | 1083364 | 2021-03-03 | LaSalle | Illinois | 17099 | 10845 | 275 |
1080118 | 1080118 | 2021-03-02 | LaSalle | Illinois | 17099 | 10823 | 274 |
1076873 | 1076873 | 2021-03-01 | LaSalle | Illinois | 17099 | 10810 | 274 |
1073627 | 1073627 | 2021-02-28 | LaSalle | Illinois | 17099 | 10798 | 274 |
1070381 | 1070381 | 2021-02-27 | LaSalle | Illinois | 17099 | 10786 | 274 |
1067136 | 1067136 | 2021-02-26 | LaSalle | Illinois | 17099 | 10764 | 274 |
1063891 | 1063891 | 2021-02-25 | LaSalle | Illinois | 17099 | 10746 | 273 |
1060646 | 1060646 | 2021-02-24 | LaSalle | Illinois | 17099 | 10706 | 273 |
1057400 | 1057400 | 2021-02-23 | LaSalle | Illinois | 17099 | 10681 | 271 |
1054154 | 1054154 | 2021-02-22 | LaSalle | Illinois | 17099 | 10665 | 271 |
1050907 | 1050907 | 2021-02-21 | LaSalle | Illinois | 17099 | 10648 | 270 |
1047660 | 1047660 | 2021-02-20 | LaSalle | Illinois | 17099 | 10601 | 269 |
1044415 | 1044415 | 2021-02-19 | LaSalle | Illinois | 17099 | 10582 | 269 |
1041170 | 1041170 | 2021-02-18 | LaSalle | Illinois | 17099 | 10562 | 269 |
1037925 | 1037925 | 2021-02-17 | LaSalle | Illinois | 17099 | 10535 | 267 |
1034680 | 1034680 | 2021-02-16 | LaSalle | Illinois | 17099 | 10509 | 267 |
1031434 | 1031434 | 2021-02-15 | LaSalle | Illinois | 17099 | 10491 | 267 |
1028187 | 1028187 | 2021-02-14 | LaSalle | Illinois | 17099 | 10478 | 267 |
1024942 | 1024942 | 2021-02-13 | LaSalle | Illinois | 17099 | 10451 | 266 |
1021697 | 1021697 | 2021-02-12 | LaSalle | Illinois | 17099 | 10418 | 265 |
1018452 | 1018452 | 2021-02-11 | LaSalle | Illinois | 17099 | 10390 | 265 |
1015207 | 1015207 | 2021-02-10 | LaSalle | Illinois | 17099 | 10353 | 265 |
1011962 | 1011962 | 2021-02-09 | LaSalle | Illinois | 17099 | 10325 | 263 |
1008716 | 1008716 | 2021-02-08 | LaSalle | Illinois | 17099 | 10310 | 260 |
1005470 | 1005470 | 2021-02-07 | LaSalle | Illinois | 17099 | 10286 | 260 |
1002224 | 1002224 | 2021-02-06 | LaSalle | Illinois | 17099 | 10264 | 258 |
998978 | 998978 | 2021-02-05 | LaSalle | Illinois | 17099 | 10234 | 257 |
995732 | 995732 | 2021-02-04 | LaSalle | Illinois | 17099 | 10191 | 257 |
992486 | 992486 | 2021-02-03 | LaSalle | Illinois | 17099 | 10148 | 257 |
989240 | 989240 | 2021-02-02 | LaSalle | Illinois | 17099 | 10128 | 257 |
985993 | 985993 | 2021-02-01 | LaSalle | Illinois | 17099 | 10104 | 257 |
982746 | 982746 | 2021-01-31 | LaSalle | Illinois | 17099 | 10088 | 255 |
979500 | 979500 | 2021-01-30 | LaSalle | Illinois | 17099 | 10056 | 255 |
976255 | 976255 | 2021-01-29 | LaSalle | Illinois | 17099 | 10016 | 255 |
973010 | 973010 | 2021-01-28 | LaSalle | Illinois | 17099 | 9971 | 252 |
969765 | 969765 | 2021-01-27 | LaSalle | Illinois | 17099 | 9901 | 252 |
966521 | 966521 | 2021-01-26 | LaSalle | Illinois | 17099 | 9834 | 250 |
963276 | 963276 | 2021-01-25 | LaSalle | Illinois | 17099 | 9807 | 250 |
960031 | 960031 | 2021-01-24 | LaSalle | Illinois | 17099 | 9791 | 250 |
956785 | 956785 | 2021-01-23 | LaSalle | Illinois | 17099 | 9757 | 250 |
953540 | 953540 | 2021-01-22 | LaSalle | Illinois | 17099 | 9704 | 249 |
950295 | 950295 | 2021-01-21 | LaSalle | Illinois | 17099 | 9595 | 248 |
947049 | 947049 | 2021-01-20 | LaSalle | Illinois | 17099 | 9537 | 247 |
943802 | 943802 | 2021-01-19 | LaSalle | Illinois | 17099 | 9478 | 247 |
940557 | 940557 | 2021-01-18 | LaSalle | Illinois | 17099 | 9427 | 247 |
937312 | 937312 | 2021-01-17 | LaSalle | Illinois | 17099 | 9392 | 247 |
934067 | 934067 | 2021-01-16 | LaSalle | Illinois | 17099 | 9328 | 247 |
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 |
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);