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 |
---|---|---|---|---|---|---|---|
1193757 | 1193757 | 2021-04-06 | LaSalle | Illinois | 17099 | 11407 | 282 |
1190507 | 1190507 | 2021-04-05 | LaSalle | Illinois | 17099 | 11397 | 282 |
1187260 | 1187260 | 2021-04-04 | LaSalle | Illinois | 17099 | 11385 | 282 |
1184013 | 1184013 | 2021-04-03 | LaSalle | Illinois | 17099 | 11364 | 282 |
1180766 | 1180766 | 2021-04-02 | LaSalle | Illinois | 17099 | 11347 | 282 |
1177519 | 1177519 | 2021-04-01 | LaSalle | Illinois | 17099 | 11318 | 282 |
1174272 | 1174272 | 2021-03-31 | LaSalle | Illinois | 17099 | 11283 | 281 |
1171025 | 1171025 | 2021-03-30 | LaSalle | Illinois | 17099 | 11263 | 281 |
1167777 | 1167777 | 2021-03-29 | LaSalle | Illinois | 17099 | 11242 | 281 |
1164529 | 1164529 | 2021-03-28 | LaSalle | Illinois | 17099 | 11232 | 281 |
1161281 | 1161281 | 2021-03-27 | LaSalle | Illinois | 17099 | 11210 | 281 |
1158033 | 1158033 | 2021-03-26 | LaSalle | Illinois | 17099 | 11198 | 280 |
1154786 | 1154786 | 2021-03-25 | LaSalle | Illinois | 17099 | 11178 | 279 |
1151539 | 1151539 | 2021-03-24 | LaSalle | Illinois | 17099 | 11164 | 279 |
1148292 | 1148292 | 2021-03-23 | LaSalle | Illinois | 17099 | 11154 | 279 |
1145045 | 1145045 | 2021-03-22 | LaSalle | Illinois | 17099 | 11140 | 279 |
1141798 | 1141798 | 2021-03-21 | LaSalle | Illinois | 17099 | 11135 | 279 |
1138552 | 1138552 | 2021-03-20 | LaSalle | Illinois | 17099 | 11122 | 279 |
1135306 | 1135306 | 2021-03-19 | LaSalle | Illinois | 17099 | 11110 | 279 |
1132059 | 1132059 | 2021-03-18 | LaSalle | Illinois | 17099 | 11092 | 278 |
1128811 | 1128811 | 2021-03-17 | LaSalle | Illinois | 17099 | 11068 | 278 |
1125565 | 1125565 | 2021-03-16 | LaSalle | Illinois | 17099 | 11044 | 278 |
1122319 | 1122319 | 2021-03-15 | LaSalle | Illinois | 17099 | 11026 | 278 |
1119072 | 1119072 | 2021-03-14 | LaSalle | Illinois | 17099 | 11019 | 278 |
1115825 | 1115825 | 2021-03-13 | LaSalle | Illinois | 17099 | 11010 | 278 |
1112579 | 1112579 | 2021-03-12 | LaSalle | Illinois | 17099 | 11000 | 278 |
1109333 | 1109333 | 2021-03-11 | LaSalle | Illinois | 17099 | 10990 | 278 |
1106087 | 1106087 | 2021-03-10 | LaSalle | Illinois | 17099 | 10967 | 278 |
1102841 | 1102841 | 2021-03-09 | LaSalle | Illinois | 17099 | 10943 | 278 |
1099595 | 1099595 | 2021-03-08 | LaSalle | Illinois | 17099 | 10928 | 277 |
1096347 | 1096347 | 2021-03-07 | LaSalle | Illinois | 17099 | 10924 | 277 |
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 |
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);