ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Sangamon" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193791 | 1193791 | 2021-04-06 | Sangamon | Illinois | 17167 | 17188 | 269 |
1190541 | 1190541 | 2021-04-05 | Sangamon | Illinois | 17167 | 17146 | 269 |
1187294 | 1187294 | 2021-04-04 | Sangamon | Illinois | 17167 | 17121 | 269 |
1184047 | 1184047 | 2021-04-03 | Sangamon | Illinois | 17167 | 17096 | 270 |
1180800 | 1180800 | 2021-04-02 | Sangamon | Illinois | 17167 | 17049 | 270 |
1177553 | 1177553 | 2021-04-01 | Sangamon | Illinois | 17167 | 17021 | 269 |
1174306 | 1174306 | 2021-03-31 | Sangamon | Illinois | 17167 | 16973 | 269 |
1171059 | 1171059 | 2021-03-30 | Sangamon | Illinois | 17167 | 16943 | 268 |
1167811 | 1167811 | 2021-03-29 | Sangamon | Illinois | 17167 | 16914 | 268 |
1164563 | 1164563 | 2021-03-28 | Sangamon | Illinois | 17167 | 16906 | 268 |
1161315 | 1161315 | 2021-03-27 | Sangamon | Illinois | 17167 | 16840 | 268 |
1158067 | 1158067 | 2021-03-26 | Sangamon | Illinois | 17167 | 16810 | 268 |
1154820 | 1154820 | 2021-03-25 | Sangamon | Illinois | 17167 | 16761 | 267 |
1151573 | 1151573 | 2021-03-24 | Sangamon | Illinois | 17167 | 16706 | 266 |
1148326 | 1148326 | 2021-03-23 | Sangamon | Illinois | 17167 | 16682 | 266 |
1145079 | 1145079 | 2021-03-22 | Sangamon | Illinois | 17167 | 16639 | 266 |
1141832 | 1141832 | 2021-03-21 | Sangamon | Illinois | 17167 | 16622 | 266 |
1138586 | 1138586 | 2021-03-20 | Sangamon | Illinois | 17167 | 16591 | 266 |
1135340 | 1135340 | 2021-03-19 | Sangamon | Illinois | 17167 | 16561 | 265 |
1132093 | 1132093 | 2021-03-18 | Sangamon | Illinois | 17167 | 16528 | 265 |
1128845 | 1128845 | 2021-03-17 | Sangamon | Illinois | 17167 | 16471 | 265 |
1125599 | 1125599 | 2021-03-16 | Sangamon | Illinois | 17167 | 16448 | 265 |
1122353 | 1122353 | 2021-03-15 | Sangamon | Illinois | 17167 | 16422 | 266 |
1119106 | 1119106 | 2021-03-14 | Sangamon | Illinois | 17167 | 16413 | 266 |
1115859 | 1115859 | 2021-03-13 | Sangamon | Illinois | 17167 | 16397 | 266 |
1112613 | 1112613 | 2021-03-12 | Sangamon | Illinois | 17167 | 16358 | 265 |
1109367 | 1109367 | 2021-03-11 | Sangamon | Illinois | 17167 | 16335 | 264 |
1106121 | 1106121 | 2021-03-10 | Sangamon | Illinois | 17167 | 16328 | 264 |
1102875 | 1102875 | 2021-03-09 | Sangamon | Illinois | 17167 | 16314 | 264 |
1099629 | 1099629 | 2021-03-08 | Sangamon | Illinois | 17167 | 16306 | 264 |
1096381 | 1096381 | 2021-03-07 | Sangamon | Illinois | 17167 | 16285 | 264 |
1093135 | 1093135 | 2021-03-06 | Sangamon | Illinois | 17167 | 16266 | 264 |
1089889 | 1089889 | 2021-03-05 | Sangamon | Illinois | 17167 | 16243 | 263 |
1086644 | 1086644 | 2021-03-04 | Sangamon | Illinois | 17167 | 16217 | 262 |
1083398 | 1083398 | 2021-03-03 | Sangamon | Illinois | 17167 | 16197 | 260 |
1080152 | 1080152 | 2021-03-02 | Sangamon | Illinois | 17167 | 16170 | 259 |
1076907 | 1076907 | 2021-03-01 | Sangamon | Illinois | 17167 | 16152 | 259 |
1073661 | 1073661 | 2021-02-28 | Sangamon | Illinois | 17167 | 16128 | 258 |
1070415 | 1070415 | 2021-02-27 | Sangamon | Illinois | 17167 | 16121 | 258 |
1067170 | 1067170 | 2021-02-26 | Sangamon | Illinois | 17167 | 16094 | 258 |
1063925 | 1063925 | 2021-02-25 | Sangamon | Illinois | 17167 | 16072 | 257 |
1060680 | 1060680 | 2021-02-24 | Sangamon | Illinois | 17167 | 16050 | 257 |
1057434 | 1057434 | 2021-02-23 | Sangamon | Illinois | 17167 | 16028 | 257 |
1054188 | 1054188 | 2021-02-22 | Sangamon | Illinois | 17167 | 15991 | 257 |
1050941 | 1050941 | 2021-02-21 | Sangamon | Illinois | 17167 | 15960 | 257 |
1047694 | 1047694 | 2021-02-20 | Sangamon | Illinois | 17167 | 15931 | 257 |
1044449 | 1044449 | 2021-02-19 | Sangamon | Illinois | 17167 | 15904 | 255 |
1041204 | 1041204 | 2021-02-18 | Sangamon | Illinois | 17167 | 15874 | 255 |
1037959 | 1037959 | 2021-02-17 | Sangamon | Illinois | 17167 | 15874 | 255 |
1034714 | 1034714 | 2021-02-16 | Sangamon | Illinois | 17167 | 15857 | 255 |
1031468 | 1031468 | 2021-02-15 | Sangamon | Illinois | 17167 | 15832 | 255 |
1028221 | 1028221 | 2021-02-14 | Sangamon | Illinois | 17167 | 15811 | 255 |
1024976 | 1024976 | 2021-02-13 | Sangamon | Illinois | 17167 | 15792 | 255 |
1021731 | 1021731 | 2021-02-12 | Sangamon | Illinois | 17167 | 15757 | 255 |
1018486 | 1018486 | 2021-02-11 | Sangamon | Illinois | 17167 | 15724 | 254 |
1015241 | 1015241 | 2021-02-10 | Sangamon | Illinois | 17167 | 15673 | 253 |
1011996 | 1011996 | 2021-02-09 | Sangamon | Illinois | 17167 | 15623 | 253 |
1008750 | 1008750 | 2021-02-08 | Sangamon | Illinois | 17167 | 15605 | 253 |
1005504 | 1005504 | 2021-02-07 | Sangamon | Illinois | 17167 | 15555 | 253 |
1002258 | 1002258 | 2021-02-06 | Sangamon | Illinois | 17167 | 15517 | 253 |
999012 | 999012 | 2021-02-05 | Sangamon | Illinois | 17167 | 15453 | 253 |
995766 | 995766 | 2021-02-04 | Sangamon | Illinois | 17167 | 15404 | 252 |
992520 | 992520 | 2021-02-03 | Sangamon | Illinois | 17167 | 15370 | 252 |
989274 | 989274 | 2021-02-02 | Sangamon | Illinois | 17167 | 15330 | 251 |
986027 | 986027 | 2021-02-01 | Sangamon | Illinois | 17167 | 15298 | 251 |
982780 | 982780 | 2021-01-31 | Sangamon | Illinois | 17167 | 15262 | 251 |
979534 | 979534 | 2021-01-30 | Sangamon | Illinois | 17167 | 15214 | 251 |
976289 | 976289 | 2021-01-29 | Sangamon | Illinois | 17167 | 15148 | 251 |
973044 | 973044 | 2021-01-28 | Sangamon | Illinois | 17167 | 15090 | 251 |
969799 | 969799 | 2021-01-27 | Sangamon | Illinois | 17167 | 15036 | 250 |
966555 | 966555 | 2021-01-26 | Sangamon | Illinois | 17167 | 14996 | 247 |
963310 | 963310 | 2021-01-25 | Sangamon | Illinois | 17167 | 14956 | 245 |
960065 | 960065 | 2021-01-24 | Sangamon | Illinois | 17167 | 14918 | 242 |
956819 | 956819 | 2021-01-23 | Sangamon | Illinois | 17167 | 14842 | 242 |
953574 | 953574 | 2021-01-22 | Sangamon | Illinois | 17167 | 14767 | 239 |
950329 | 950329 | 2021-01-21 | Sangamon | Illinois | 17167 | 14658 | 236 |
947083 | 947083 | 2021-01-20 | Sangamon | Illinois | 17167 | 14605 | 236 |
943836 | 943836 | 2021-01-19 | Sangamon | Illinois | 17167 | 14548 | 235 |
940591 | 940591 | 2021-01-18 | Sangamon | Illinois | 17167 | 14477 | 234 |
937346 | 937346 | 2021-01-17 | Sangamon | Illinois | 17167 | 14469 | 234 |
934101 | 934101 | 2021-01-16 | Sangamon | Illinois | 17167 | 14406 | 234 |
930856 | 930856 | 2021-01-15 | Sangamon | Illinois | 17167 | 14299 | 232 |
927611 | 927611 | 2021-01-14 | Sangamon | Illinois | 17167 | 14227 | 232 |
924365 | 924365 | 2021-01-13 | Sangamon | Illinois | 17167 | 14139 | 229 |
921120 | 921120 | 2021-01-12 | Sangamon | Illinois | 17167 | 14076 | 226 |
917875 | 917875 | 2021-01-11 | Sangamon | Illinois | 17167 | 14022 | 223 |
914630 | 914630 | 2021-01-10 | Sangamon | Illinois | 17167 | 13963 | 223 |
911385 | 911385 | 2021-01-09 | Sangamon | Illinois | 17167 | 13915 | 223 |
908140 | 908140 | 2021-01-08 | Sangamon | Illinois | 17167 | 13828 | 221 |
904894 | 904894 | 2021-01-07 | Sangamon | Illinois | 17167 | 13767 | 216 |
901649 | 901649 | 2021-01-06 | Sangamon | Illinois | 17167 | 13655 | 213 |
898404 | 898404 | 2021-01-05 | Sangamon | Illinois | 17167 | 13589 | 209 |
895159 | 895159 | 2021-01-04 | Sangamon | Illinois | 17167 | 13515 | 206 |
891912 | 891912 | 2021-01-03 | Sangamon | Illinois | 17167 | 13445 | 204 |
888665 | 888665 | 2021-01-02 | Sangamon | Illinois | 17167 | 13402 | 202 |
885420 | 885420 | 2021-01-01 | Sangamon | Illinois | 17167 | 13219 | 197 |
882175 | 882175 | 2020-12-31 | Sangamon | Illinois | 17167 | 13219 | 197 |
878930 | 878930 | 2020-12-30 | Sangamon | Illinois | 17167 | 13160 | 193 |
875685 | 875685 | 2020-12-29 | Sangamon | Illinois | 17167 | 13093 | 192 |
872440 | 872440 | 2020-12-28 | Sangamon | Illinois | 17167 | 13018 | 190 |
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);