ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 17111 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193771 | 1193771 | 2021-04-06 | McHenry | Illinois | 17111 | 25920 | 299 |
1190521 | 1190521 | 2021-04-05 | McHenry | Illinois | 17111 | 25812 | 299 |
1187274 | 1187274 | 2021-04-04 | McHenry | Illinois | 17111 | 25782 | 299 |
1184027 | 1184027 | 2021-04-03 | McHenry | Illinois | 17111 | 25754 | 299 |
1180780 | 1180780 | 2021-04-02 | McHenry | Illinois | 17111 | 25708 | 299 |
1177533 | 1177533 | 2021-04-01 | McHenry | Illinois | 17111 | 25658 | 299 |
1174286 | 1174286 | 2021-03-31 | McHenry | Illinois | 17111 | 25586 | 299 |
1171039 | 1171039 | 2021-03-30 | McHenry | Illinois | 17111 | 25545 | 299 |
1167791 | 1167791 | 2021-03-29 | McHenry | Illinois | 17111 | 25501 | 298 |
1164543 | 1164543 | 2021-03-28 | McHenry | Illinois | 17111 | 25477 | 298 |
1161295 | 1161295 | 2021-03-27 | McHenry | Illinois | 17111 | 25450 | 297 |
1158047 | 1158047 | 2021-03-26 | McHenry | Illinois | 17111 | 25407 | 297 |
1154800 | 1154800 | 2021-03-25 | McHenry | Illinois | 17111 | 25353 | 298 |
1151553 | 1151553 | 2021-03-24 | McHenry | Illinois | 17111 | 25307 | 297 |
1148306 | 1148306 | 2021-03-23 | McHenry | Illinois | 17111 | 25225 | 295 |
1145059 | 1145059 | 2021-03-22 | McHenry | Illinois | 17111 | 25187 | 295 |
1141812 | 1141812 | 2021-03-21 | McHenry | Illinois | 17111 | 25160 | 295 |
1138566 | 1138566 | 2021-03-20 | McHenry | Illinois | 17111 | 25149 | 295 |
1135320 | 1135320 | 2021-03-19 | McHenry | Illinois | 17111 | 25104 | 294 |
1132073 | 1132073 | 2021-03-18 | McHenry | Illinois | 17111 | 25061 | 295 |
1128825 | 1128825 | 2021-03-17 | McHenry | Illinois | 17111 | 24992 | 295 |
1125579 | 1125579 | 2021-03-16 | McHenry | Illinois | 17111 | 24963 | 294 |
1122333 | 1122333 | 2021-03-15 | McHenry | Illinois | 17111 | 24919 | 294 |
1119086 | 1119086 | 2021-03-14 | McHenry | Illinois | 17111 | 24900 | 294 |
1115839 | 1115839 | 2021-03-13 | McHenry | Illinois | 17111 | 24865 | 294 |
1112593 | 1112593 | 2021-03-12 | McHenry | Illinois | 17111 | 24828 | 294 |
1109347 | 1109347 | 2021-03-11 | McHenry | Illinois | 17111 | 24806 | 293 |
1106101 | 1106101 | 2021-03-10 | McHenry | Illinois | 17111 | 24763 | 293 |
1102855 | 1102855 | 2021-03-09 | McHenry | Illinois | 17111 | 24736 | 293 |
1099609 | 1099609 | 2021-03-08 | McHenry | Illinois | 17111 | 24699 | 292 |
1096361 | 1096361 | 2021-03-07 | McHenry | Illinois | 17111 | 24669 | 292 |
1093115 | 1093115 | 2021-03-06 | McHenry | Illinois | 17111 | 24644 | 292 |
1089869 | 1089869 | 2021-03-05 | McHenry | Illinois | 17111 | 24580 | 292 |
1086624 | 1086624 | 2021-03-04 | McHenry | Illinois | 17111 | 24554 | 292 |
1083378 | 1083378 | 2021-03-03 | McHenry | Illinois | 17111 | 24521 | 292 |
1080132 | 1080132 | 2021-03-02 | McHenry | Illinois | 17111 | 24404 | 291 |
1076887 | 1076887 | 2021-03-01 | McHenry | Illinois | 17111 | 24336 | 291 |
1073641 | 1073641 | 2021-02-28 | McHenry | Illinois | 17111 | 24315 | 291 |
1070395 | 1070395 | 2021-02-27 | McHenry | Illinois | 17111 | 24290 | 291 |
1067150 | 1067150 | 2021-02-26 | McHenry | Illinois | 17111 | 24249 | 291 |
1063905 | 1063905 | 2021-02-25 | McHenry | Illinois | 17111 | 24190 | 289 |
1060660 | 1060660 | 2021-02-24 | McHenry | Illinois | 17111 | 24128 | 289 |
1057414 | 1057414 | 2021-02-23 | McHenry | Illinois | 17111 | 24076 | 287 |
1054168 | 1054168 | 2021-02-22 | McHenry | Illinois | 17111 | 24021 | 287 |
1050921 | 1050921 | 2021-02-21 | McHenry | Illinois | 17111 | 24003 | 287 |
1047674 | 1047674 | 2021-02-20 | McHenry | Illinois | 17111 | 23967 | 287 |
1044429 | 1044429 | 2021-02-19 | McHenry | Illinois | 17111 | 23914 | 286 |
1041184 | 1041184 | 2021-02-18 | McHenry | Illinois | 17111 | 23853 | 286 |
1037939 | 1037939 | 2021-02-17 | McHenry | Illinois | 17111 | 23799 | 285 |
1034694 | 1034694 | 2021-02-16 | McHenry | Illinois | 17111 | 23724 | 285 |
1031448 | 1031448 | 2021-02-15 | McHenry | Illinois | 17111 | 23686 | 285 |
1028201 | 1028201 | 2021-02-14 | McHenry | Illinois | 17111 | 23638 | 285 |
1024956 | 1024956 | 2021-02-13 | McHenry | Illinois | 17111 | 23595 | 283 |
1021711 | 1021711 | 2021-02-12 | McHenry | Illinois | 17111 | 23561 | 283 |
1018466 | 1018466 | 2021-02-11 | McHenry | Illinois | 17111 | 23497 | 282 |
1015221 | 1015221 | 2021-02-10 | McHenry | Illinois | 17111 | 23429 | 282 |
1011976 | 1011976 | 2021-02-09 | McHenry | Illinois | 17111 | 23361 | 281 |
1008730 | 1008730 | 2021-02-08 | McHenry | Illinois | 17111 | 23302 | 280 |
1005484 | 1005484 | 2021-02-07 | McHenry | Illinois | 17111 | 23253 | 280 |
1002238 | 1002238 | 2021-02-06 | McHenry | Illinois | 17111 | 23215 | 278 |
998992 | 998992 | 2021-02-05 | McHenry | Illinois | 17111 | 23135 | 278 |
995746 | 995746 | 2021-02-04 | McHenry | Illinois | 17111 | 23044 | 277 |
992500 | 992500 | 2021-02-03 | McHenry | Illinois | 17111 | 22976 | 276 |
989254 | 989254 | 2021-02-02 | McHenry | Illinois | 17111 | 22892 | 273 |
986007 | 986007 | 2021-02-01 | McHenry | Illinois | 17111 | 22837 | 272 |
982760 | 982760 | 2021-01-31 | McHenry | Illinois | 17111 | 22765 | 268 |
979514 | 979514 | 2021-01-30 | McHenry | Illinois | 17111 | 22706 | 268 |
976269 | 976269 | 2021-01-29 | McHenry | Illinois | 17111 | 22626 | 268 |
973024 | 973024 | 2021-01-28 | McHenry | Illinois | 17111 | 22533 | 264 |
969779 | 969779 | 2021-01-27 | McHenry | Illinois | 17111 | 22435 | 263 |
966535 | 966535 | 2021-01-26 | McHenry | Illinois | 17111 | 22372 | 260 |
963290 | 963290 | 2021-01-25 | McHenry | Illinois | 17111 | 22290 | 260 |
960045 | 960045 | 2021-01-24 | McHenry | Illinois | 17111 | 22214 | 258 |
956799 | 956799 | 2021-01-23 | McHenry | Illinois | 17111 | 22153 | 256 |
953554 | 953554 | 2021-01-22 | McHenry | Illinois | 17111 | 22050 | 253 |
950309 | 950309 | 2021-01-21 | McHenry | Illinois | 17111 | 21916 | 251 |
947063 | 947063 | 2021-01-20 | McHenry | Illinois | 17111 | 21807 | 249 |
943816 | 943816 | 2021-01-19 | McHenry | Illinois | 17111 | 21712 | 248 |
940571 | 940571 | 2021-01-18 | McHenry | Illinois | 17111 | 21591 | 248 |
937326 | 937326 | 2021-01-17 | McHenry | Illinois | 17111 | 21498 | 248 |
934081 | 934081 | 2021-01-16 | McHenry | Illinois | 17111 | 21395 | 248 |
930836 | 930836 | 2021-01-15 | McHenry | Illinois | 17111 | 21268 | 244 |
927591 | 927591 | 2021-01-14 | McHenry | Illinois | 17111 | 21132 | 238 |
924345 | 924345 | 2021-01-13 | McHenry | Illinois | 17111 | 20995 | 235 |
921100 | 921100 | 2021-01-12 | McHenry | Illinois | 17111 | 20894 | 234 |
917855 | 917855 | 2021-01-11 | McHenry | Illinois | 17111 | 20747 | 233 |
914610 | 914610 | 2021-01-10 | McHenry | Illinois | 17111 | 20603 | 233 |
911365 | 911365 | 2021-01-09 | McHenry | Illinois | 17111 | 20467 | 232 |
908120 | 908120 | 2021-01-08 | McHenry | Illinois | 17111 | 20308 | 232 |
904874 | 904874 | 2021-01-07 | McHenry | Illinois | 17111 | 20118 | 230 |
901629 | 901629 | 2021-01-06 | McHenry | Illinois | 17111 | 19885 | 224 |
898384 | 898384 | 2021-01-05 | McHenry | Illinois | 17111 | 19766 | 223 |
895139 | 895139 | 2021-01-04 | McHenry | Illinois | 17111 | 19653 | 222 |
891892 | 891892 | 2021-01-03 | McHenry | Illinois | 17111 | 19533 | 222 |
888645 | 888645 | 2021-01-02 | McHenry | Illinois | 17111 | 19422 | 222 |
885400 | 885400 | 2021-01-01 | McHenry | Illinois | 17111 | 19128 | 217 |
882155 | 882155 | 2020-12-31 | McHenry | Illinois | 17111 | 19128 | 217 |
878910 | 878910 | 2020-12-30 | McHenry | Illinois | 17111 | 18949 | 217 |
875665 | 875665 | 2020-12-29 | McHenry | Illinois | 17111 | 18794 | 214 |
872420 | 872420 | 2020-12-28 | McHenry | Illinois | 17111 | 18692 | 211 |
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);