ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
18 rows where cases = 1621 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 12
county 12
- Pulaski 3
- Ford 2
- Jasper 2
- Sangamon 2
- Washington 2
- Carroll 1
- Jo Daviess 1
- Lake 1
- Moultrie 1
- Richland 1
- Warren 1
- Williamson 1
state 1
- Illinois · 18 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2165112 | 2165112 | 2022-01-30 | Pulaski | Illinois | 17153 | 1621 | 15 |
2161857 | 2161857 | 2022-01-29 | Pulaski | Illinois | 17153 | 1621 | 15 |
2158602 | 2158602 | 2022-01-28 | Pulaski | Illinois | 17153 | 1621 | 15 |
1856246 | 1856246 | 2021-10-27 | Jasper | Illinois | 17079 | 1621 | 23 |
1852997 | 1852997 | 2021-10-26 | Jasper | Illinois | 17079 | 1621 | 23 |
1359379 | 1359379 | 2021-05-27 | Moultrie | Illinois | 17139 | 1621 | 36 |
1210046 | 1210046 | 2021-04-11 | Washington | Illinois | 17189 | 1621 | 31 |
1206797 | 1206797 | 2021-04-10 | Washington | Illinois | 17189 | 1621 | 31 |
1157992 | 1157992 | 2021-03-26 | Carroll | Illinois | 17015 | 1621 | 36 |
1122297 | 1122297 | 2021-03-15 | Ford | Illinois | 17053 | 1621 | 54 |
1119050 | 1119050 | 2021-03-14 | Ford | Illinois | 17053 | 1621 | 54 |
1109327 | 1109327 | 2021-03-11 | Jo Daviess | Illinois | 17085 | 1621 | 25 |
1015238 | 1015238 | 2021-02-10 | Richland | Illinois | 17159 | 1621 | 47 |
979546 | 979546 | 2021-01-30 | Warren | Illinois | 17187 | 1621 | 46 |
632338 | 632338 | 2020-10-15 | Williamson | Illinois | 17199 | 1621 | 56 |
457507 | 457507 | 2020-08-22 | Sangamon | Illinois | 17167 | 1621 | 38 |
454279 | 454279 | 2020-08-21 | Sangamon | Illinois | 17167 | 1621 | 38 |
57053 | 57053 | 2020-04-14 | Lake | Illinois | 17097 | 1621 | 58 |
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);