ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,150 rows where deaths = 3 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Fayette 127
- Pope 95
- Macoupin 76
- Knox 45
- Woodford 40
- Stark 38
- Pulaski 37
- Gallatin 35
- Hancock 35
- Saline 31
- Bond 29
- McLean 29
- Cumberland 25
- Moultrie 25
- Tazewell 24
- Effingham 23
- Morgan 23
- Shelby 22
- Hamilton 21
- Marshall 20
- Edwards 18
- Livingston 15
- Randolph 15
- Williamson 15
- Brown 13
- Wabash 11
- Douglas 10
- Scott 10
- Whiteside 10
- Clark 9
- …
state 1
- Illinois · 1,150 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1710085 | 1710085 | 2021-09-12 | Scott | Illinois | 17171 | 679 | 3 |
1706838 | 1706838 | 2021-09-11 | Scott | Illinois | 17171 | 679 | 3 |
1703590 | 1703590 | 2021-09-10 | Scott | Illinois | 17171 | 679 | 3 |
1700340 | 1700340 | 2021-09-09 | Scott | Illinois | 17171 | 677 | 3 |
1697091 | 1697091 | 2021-09-08 | Scott | Illinois | 17171 | 675 | 3 |
1693843 | 1693843 | 2021-09-07 | Scott | Illinois | 17171 | 674 | 3 |
1690594 | 1690594 | 2021-09-06 | Scott | Illinois | 17171 | 670 | 3 |
1687344 | 1687344 | 2021-09-05 | Scott | Illinois | 17171 | 670 | 3 |
1684094 | 1684094 | 2021-09-04 | Scott | Illinois | 17171 | 670 | 3 |
1680843 | 1680843 | 2021-09-03 | Scott | Illinois | 17171 | 670 | 3 |
1255490 | 1255490 | 2021-04-25 | Pope | Illinois | 17151 | 307 | 3 |
1252243 | 1252243 | 2021-04-24 | Pope | Illinois | 17151 | 307 | 3 |
1248996 | 1248996 | 2021-04-23 | Pope | Illinois | 17151 | 307 | 3 |
1245749 | 1245749 | 2021-04-22 | Pope | Illinois | 17151 | 307 | 3 |
1242502 | 1242502 | 2021-04-21 | Pope | Illinois | 17151 | 307 | 3 |
1239255 | 1239255 | 2021-04-20 | Pope | Illinois | 17151 | 307 | 3 |
1236008 | 1236008 | 2021-04-19 | Pope | Illinois | 17151 | 306 | 3 |
1232761 | 1232761 | 2021-04-18 | Pope | Illinois | 17151 | 305 | 3 |
1229512 | 1229512 | 2021-04-17 | Pope | Illinois | 17151 | 305 | 3 |
1226264 | 1226264 | 2021-04-16 | Pope | Illinois | 17151 | 305 | 3 |
1223017 | 1223017 | 2021-04-15 | Pope | Illinois | 17151 | 305 | 3 |
1219769 | 1219769 | 2021-04-14 | Pope | Illinois | 17151 | 305 | 3 |
1216521 | 1216521 | 2021-04-13 | Pope | Illinois | 17151 | 304 | 3 |
1213274 | 1213274 | 2021-04-12 | Pope | Illinois | 17151 | 304 | 3 |
1210026 | 1210026 | 2021-04-11 | Pope | Illinois | 17151 | 304 | 3 |
1206777 | 1206777 | 2021-04-10 | Pope | Illinois | 17151 | 303 | 3 |
1203529 | 1203529 | 2021-04-09 | Pope | Illinois | 17151 | 303 | 3 |
1200281 | 1200281 | 2021-04-08 | Pope | Illinois | 17151 | 303 | 3 |
1197032 | 1197032 | 2021-04-07 | Pope | Illinois | 17151 | 302 | 3 |
1193784 | 1193784 | 2021-04-06 | Pope | Illinois | 17151 | 302 | 3 |
1190534 | 1190534 | 2021-04-05 | Pope | Illinois | 17151 | 302 | 3 |
1187287 | 1187287 | 2021-04-04 | Pope | Illinois | 17151 | 302 | 3 |
1184040 | 1184040 | 2021-04-03 | Pope | Illinois | 17151 | 302 | 3 |
1180793 | 1180793 | 2021-04-02 | Pope | Illinois | 17151 | 302 | 3 |
1177546 | 1177546 | 2021-04-01 | Pope | Illinois | 17151 | 302 | 3 |
1174299 | 1174299 | 2021-03-31 | Pope | Illinois | 17151 | 302 | 3 |
1171052 | 1171052 | 2021-03-30 | Pope | Illinois | 17151 | 300 | 3 |
1167804 | 1167804 | 2021-03-29 | Pope | Illinois | 17151 | 298 | 3 |
1164556 | 1164556 | 2021-03-28 | Pope | Illinois | 17151 | 298 | 3 |
1161308 | 1161308 | 2021-03-27 | Pope | Illinois | 17151 | 298 | 3 |
1158060 | 1158060 | 2021-03-26 | Pope | Illinois | 17151 | 298 | 3 |
1154813 | 1154813 | 2021-03-25 | Pope | Illinois | 17151 | 298 | 3 |
1151566 | 1151566 | 2021-03-24 | Pope | Illinois | 17151 | 295 | 3 |
1148319 | 1148319 | 2021-03-23 | Pope | Illinois | 17151 | 295 | 3 |
1145072 | 1145072 | 2021-03-22 | Pope | Illinois | 17151 | 293 | 3 |
1141825 | 1141825 | 2021-03-21 | Pope | Illinois | 17151 | 293 | 3 |
1138579 | 1138579 | 2021-03-20 | Pope | Illinois | 17151 | 293 | 3 |
1135333 | 1135333 | 2021-03-19 | Pope | Illinois | 17151 | 293 | 3 |
1132086 | 1132086 | 2021-03-18 | Pope | Illinois | 17151 | 293 | 3 |
1128838 | 1128838 | 2021-03-17 | Pope | Illinois | 17151 | 292 | 3 |
1125592 | 1125592 | 2021-03-16 | Pope | Illinois | 17151 | 292 | 3 |
1122346 | 1122346 | 2021-03-15 | Pope | Illinois | 17151 | 289 | 3 |
1119099 | 1119099 | 2021-03-14 | Pope | Illinois | 17151 | 288 | 3 |
1115852 | 1115852 | 2021-03-13 | Pope | Illinois | 17151 | 288 | 3 |
1112606 | 1112606 | 2021-03-12 | Pope | Illinois | 17151 | 288 | 3 |
1109360 | 1109360 | 2021-03-11 | Pope | Illinois | 17151 | 288 | 3 |
1106114 | 1106114 | 2021-03-10 | Pope | Illinois | 17151 | 288 | 3 |
1102868 | 1102868 | 2021-03-09 | Pope | Illinois | 17151 | 285 | 3 |
1099622 | 1099622 | 2021-03-08 | Pope | Illinois | 17151 | 284 | 3 |
1096374 | 1096374 | 2021-03-07 | Pope | Illinois | 17151 | 284 | 3 |
1093128 | 1093128 | 2021-03-06 | Pope | Illinois | 17151 | 284 | 3 |
1089882 | 1089882 | 2021-03-05 | Pope | Illinois | 17151 | 284 | 3 |
1086637 | 1086637 | 2021-03-04 | Pope | Illinois | 17151 | 284 | 3 |
1083391 | 1083391 | 2021-03-03 | Pope | Illinois | 17151 | 284 | 3 |
1080145 | 1080145 | 2021-03-02 | Pope | Illinois | 17151 | 282 | 3 |
1076900 | 1076900 | 2021-03-01 | Pope | Illinois | 17151 | 282 | 3 |
1073654 | 1073654 | 2021-02-28 | Pope | Illinois | 17151 | 282 | 3 |
1070408 | 1070408 | 2021-02-27 | Pope | Illinois | 17151 | 282 | 3 |
1067163 | 1067163 | 2021-02-26 | Pope | Illinois | 17151 | 282 | 3 |
1063918 | 1063918 | 2021-02-25 | Pope | Illinois | 17151 | 282 | 3 |
1060673 | 1060673 | 2021-02-24 | Pope | Illinois | 17151 | 280 | 3 |
1057427 | 1057427 | 2021-02-23 | Pope | Illinois | 17151 | 280 | 3 |
1054181 | 1054181 | 2021-02-22 | Pope | Illinois | 17151 | 279 | 3 |
1050934 | 1050934 | 2021-02-21 | Pope | Illinois | 17151 | 279 | 3 |
1047687 | 1047687 | 2021-02-20 | Pope | Illinois | 17151 | 279 | 3 |
1044442 | 1044442 | 2021-02-19 | Pope | Illinois | 17151 | 281 | 3 |
1041197 | 1041197 | 2021-02-18 | Pope | Illinois | 17151 | 281 | 3 |
1037952 | 1037952 | 2021-02-17 | Pope | Illinois | 17151 | 281 | 3 |
1034707 | 1034707 | 2021-02-16 | Pope | Illinois | 17151 | 280 | 3 |
1031461 | 1031461 | 2021-02-15 | Pope | Illinois | 17151 | 279 | 3 |
1028214 | 1028214 | 2021-02-14 | Pope | Illinois | 17151 | 279 | 3 |
1024969 | 1024969 | 2021-02-13 | Pope | Illinois | 17151 | 279 | 3 |
1021724 | 1021724 | 2021-02-12 | Pope | Illinois | 17151 | 278 | 3 |
1018479 | 1018479 | 2021-02-11 | Pope | Illinois | 17151 | 277 | 3 |
1015234 | 1015234 | 2021-02-10 | Pope | Illinois | 17151 | 276 | 3 |
1011989 | 1011989 | 2021-02-09 | Pope | Illinois | 17151 | 273 | 3 |
1008743 | 1008743 | 2021-02-08 | Pope | Illinois | 17151 | 273 | 3 |
1005497 | 1005497 | 2021-02-07 | Pope | Illinois | 17151 | 273 | 3 |
1002251 | 1002251 | 2021-02-06 | Pope | Illinois | 17151 | 271 | 3 |
999005 | 999005 | 2021-02-05 | Pope | Illinois | 17151 | 270 | 3 |
995759 | 995759 | 2021-02-04 | Pope | Illinois | 17151 | 268 | 3 |
992513 | 992513 | 2021-02-03 | Pope | Illinois | 17151 | 267 | 3 |
992514 | 992514 | 2021-02-03 | Pulaski | Illinois | 17153 | 654 | 3 |
989267 | 989267 | 2021-02-02 | Pope | Illinois | 17151 | 266 | 3 |
989268 | 989268 | 2021-02-02 | Pulaski | Illinois | 17153 | 651 | 3 |
986020 | 986020 | 2021-02-01 | Pope | Illinois | 17151 | 264 | 3 |
986021 | 986021 | 2021-02-01 | Pulaski | Illinois | 17153 | 646 | 3 |
982773 | 982773 | 2021-01-31 | Pope | Illinois | 17151 | 264 | 3 |
982774 | 982774 | 2021-01-31 | Pulaski | Illinois | 17153 | 646 | 3 |
982775 | 982775 | 2021-01-31 | Putnam | Illinois | 17155 | 375 | 3 |
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);