ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
667 rows where county = "Unknown" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193800 | 1193800 | 2021-04-06 | Unknown | Illinois | 0 | 262 | |
1190550 | 1190550 | 2021-04-05 | Unknown | Illinois | 0 | 265 | |
1187303 | 1187303 | 2021-04-04 | Unknown | Illinois | 0 | 269 | |
1184056 | 1184056 | 2021-04-03 | Unknown | Illinois | 0 | 262 | |
1180809 | 1180809 | 2021-04-02 | Unknown | Illinois | 0 | 265 | |
1177562 | 1177562 | 2021-04-01 | Unknown | Illinois | 0 | 263 | |
1174315 | 1174315 | 2021-03-31 | Unknown | Illinois | 0 | 266 | |
1171068 | 1171068 | 2021-03-30 | Unknown | Illinois | 0 | 257 | |
1167820 | 1167820 | 2021-03-29 | Unknown | Illinois | 0 | 259 | |
1164572 | 1164572 | 2021-03-28 | Unknown | Illinois | 0 | 258 | |
1161324 | 1161324 | 2021-03-27 | Unknown | Illinois | 0 | 257 | |
1158076 | 1158076 | 2021-03-26 | Unknown | Illinois | 0 | 256 | |
1154829 | 1154829 | 2021-03-25 | Unknown | Illinois | 0 | 257 | |
1151582 | 1151582 | 2021-03-24 | Unknown | Illinois | 0 | 258 | |
1148335 | 1148335 | 2021-03-23 | Unknown | Illinois | 0 | 261 | |
1145088 | 1145088 | 2021-03-22 | Unknown | Illinois | 0 | 265 | |
1141841 | 1141841 | 2021-03-21 | Unknown | Illinois | 0 | 265 | |
1138595 | 1138595 | 2021-03-20 | Unknown | Illinois | 0 | 259 | |
1135349 | 1135349 | 2021-03-19 | Unknown | Illinois | 0 | 259 | |
1132102 | 1132102 | 2021-03-18 | Unknown | Illinois | 0 | 253 | |
1128854 | 1128854 | 2021-03-17 | Unknown | Illinois | 0 | 255 | |
1125608 | 1125608 | 2021-03-16 | Unknown | Illinois | 0 | 250 | |
1122362 | 1122362 | 2021-03-15 | Unknown | Illinois | 0 | 248 | |
1119115 | 1119115 | 2021-03-14 | Unknown | Illinois | 0 | 250 | |
1115868 | 1115868 | 2021-03-13 | Unknown | Illinois | 0 | 251 | |
1112622 | 1112622 | 2021-03-12 | Unknown | Illinois | 0 | 250 | |
1109376 | 1109376 | 2021-03-11 | Unknown | Illinois | 0 | 245 | |
1106130 | 1106130 | 2021-03-10 | Unknown | Illinois | 0 | 242 | |
1102884 | 1102884 | 2021-03-09 | Unknown | Illinois | 0 | 245 | |
1099638 | 1099638 | 2021-03-08 | Unknown | Illinois | 0 | 239 | |
1096390 | 1096390 | 2021-03-07 | Unknown | Illinois | 0 | 237 | |
1093144 | 1093144 | 2021-03-06 | Unknown | Illinois | 0 | 237 | |
1089898 | 1089898 | 2021-03-05 | Unknown | Illinois | 0 | 231 | |
1086653 | 1086653 | 2021-03-04 | Unknown | Illinois | 0 | 218 | |
1083407 | 1083407 | 2021-03-03 | Unknown | Illinois | 0 | 209 | |
1080161 | 1080161 | 2021-03-02 | Unknown | Illinois | 0 | 202 | |
1076916 | 1076916 | 2021-03-01 | Unknown | Illinois | 0 | 206 | |
1073670 | 1073670 | 2021-02-28 | Unknown | Illinois | 0 | 208 | |
1070424 | 1070424 | 2021-02-27 | Unknown | Illinois | 0 | 205 | |
1067179 | 1067179 | 2021-02-26 | Unknown | Illinois | 0 | 204 | |
1063934 | 1063934 | 2021-02-25 | Unknown | Illinois | 0 | 190 | |
1060689 | 1060689 | 2021-02-24 | Unknown | Illinois | 0 | 190 | |
1057443 | 1057443 | 2021-02-23 | Unknown | Illinois | 0 | 187 | |
1054197 | 1054197 | 2021-02-22 | Unknown | Illinois | 0 | 192 | |
1050950 | 1050950 | 2021-02-21 | Unknown | Illinois | 0 | 186 | |
1047703 | 1047703 | 2021-02-20 | Unknown | Illinois | 0 | 181 | |
1044458 | 1044458 | 2021-02-19 | Unknown | Illinois | 0 | 166 | |
1041213 | 1041213 | 2021-02-18 | Unknown | Illinois | 0 | 158 | |
1037968 | 1037968 | 2021-02-17 | Unknown | Illinois | 0 | 157 | |
1034723 | 1034723 | 2021-02-16 | Unknown | Illinois | 0 | 154 | |
1031477 | 1031477 | 2021-02-15 | Unknown | Illinois | 0 | 154 | |
1028230 | 1028230 | 2021-02-14 | Unknown | Illinois | 0 | 150 | |
1024985 | 1024985 | 2021-02-13 | Unknown | Illinois | 0 | 151 | |
1021740 | 1021740 | 2021-02-12 | Unknown | Illinois | 0 | 144 | |
1018495 | 1018495 | 2021-02-11 | Unknown | Illinois | 0 | 134 | |
1015250 | 1015250 | 2021-02-10 | Unknown | Illinois | 0 | 121 | |
1012005 | 1012005 | 2021-02-09 | Unknown | Illinois | 0 | 107 | |
1008759 | 1008759 | 2021-02-08 | Unknown | Illinois | 0 | 102 | |
1005513 | 1005513 | 2021-02-07 | Unknown | Illinois | 0 | 95 | |
1002267 | 1002267 | 2021-02-06 | Unknown | Illinois | 0 | 81 | |
999021 | 999021 | 2021-02-05 | Unknown | Illinois | 0 | 67 | |
995775 | 995775 | 2021-02-04 | Unknown | Illinois | 0 | 43 | |
992529 | 992529 | 2021-02-03 | Unknown | Illinois | 0 | 35 | |
989283 | 989283 | 2021-02-02 | Unknown | Illinois | 0 | 21 | |
986036 | 986036 | 2021-02-01 | Unknown | Illinois | 0 | 6 | |
982789 | 982789 | 2021-01-31 | Unknown | Illinois | 0 | 106 | |
979543 | 979543 | 2021-01-30 | Unknown | Illinois | 0 | 66 | |
888674 | 888674 | 2021-01-02 | Unknown | Illinois | 0 | 3 | |
700459 | 700459 | 2020-11-05 | Unknown | Illinois | 5932 | 278 | |
697215 | 697215 | 2020-11-04 | Unknown | Illinois | 6087 | 278 | |
693973 | 693973 | 2020-11-03 | Unknown | Illinois | 6034 | 278 | |
690730 | 690730 | 2020-11-02 | Unknown | Illinois | 6034 | 278 | |
687485 | 687485 | 2020-11-01 | Unknown | Illinois | 6061 | 278 | |
684241 | 684241 | 2020-10-31 | Unknown | Illinois | 12048 | 292 | |
680998 | 680998 | 2020-10-30 | Unknown | Illinois | 6061 | 278 | |
677755 | 677755 | 2020-10-29 | Unknown | Illinois | 4529 | 265 | |
674512 | 674512 | 2020-10-28 | Unknown | Illinois | 4553 | 265 | |
671270 | 671270 | 2020-10-27 | Unknown | Illinois | 4560 | 265 | |
668027 | 668027 | 2020-10-26 | Unknown | Illinois | 4574 | 265 | |
664783 | 664783 | 2020-10-25 | Unknown | Illinois | 4577 | 265 | |
661538 | 661538 | 2020-10-24 | Unknown | Illinois | 4577 | 265 | |
658294 | 658294 | 2020-10-23 | Unknown | Illinois | 4577 | 265 | |
655049 | 655049 | 2020-10-22 | Unknown | Illinois | 3458 | 255 | |
651804 | 651804 | 2020-10-21 | Unknown | Illinois | 3458 | 255 | |
648560 | 648560 | 2020-10-20 | Unknown | Illinois | 3462 | 255 | |
645315 | 645315 | 2020-10-19 | Unknown | Illinois | 3467 | 255 | |
642068 | 642068 | 2020-10-18 | Unknown | Illinois | 3477 | 255 | |
638821 | 638821 | 2020-10-17 | Unknown | Illinois | 3477 | 255 | |
635575 | 635575 | 2020-10-16 | Unknown | Illinois | 3477 | 255 | |
632329 | 632329 | 2020-10-15 | Unknown | Illinois | 2939 | 241 | |
629085 | 629085 | 2020-10-14 | Unknown | Illinois | 2941 | 241 | |
625842 | 625842 | 2020-10-13 | Unknown | Illinois | 2943 | 241 | |
622600 | 622600 | 2020-10-12 | Unknown | Illinois | 2652 | 244 | |
619356 | 619356 | 2020-10-11 | Unknown | Illinois | 2652 | 244 | |
616114 | 616114 | 2020-10-10 | Unknown | Illinois | 2652 | 244 | |
612873 | 612873 | 2020-10-09 | Unknown | Illinois | 2652 | 244 | |
609631 | 609631 | 2020-10-08 | Unknown | Illinois | 2654 | 244 | |
606388 | 606388 | 2020-10-07 | Unknown | Illinois | 2658 | 244 | |
603146 | 603146 | 2020-10-06 | Unknown | Illinois | 2659 | 244 | |
599903 | 599903 | 2020-10-05 | Unknown | Illinois | 2659 | 245 |
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);