ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
31 rows where cases = 1167, fips = 17079 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1528137 | 1528137 | 2021-07-18 | Jasper | Illinois | 17079 | 1167 | 20 |
1524890 | 1524890 | 2021-07-17 | Jasper | Illinois | 17079 | 1167 | 20 |
1521642 | 1521642 | 2021-07-16 | Jasper | Illinois | 17079 | 1167 | 20 |
1518394 | 1518394 | 2021-07-15 | Jasper | Illinois | 17079 | 1167 | 20 |
1515147 | 1515147 | 2021-07-14 | Jasper | Illinois | 17079 | 1167 | 20 |
1511901 | 1511901 | 2021-07-13 | Jasper | Illinois | 17079 | 1167 | 20 |
1508654 | 1508654 | 2021-07-12 | Jasper | Illinois | 17079 | 1167 | 20 |
1505408 | 1505408 | 2021-07-11 | Jasper | Illinois | 17079 | 1167 | 20 |
1502162 | 1502162 | 2021-07-10 | Jasper | Illinois | 17079 | 1167 | 20 |
1498916 | 1498916 | 2021-07-09 | Jasper | Illinois | 17079 | 1167 | 20 |
1495669 | 1495669 | 2021-07-08 | Jasper | Illinois | 17079 | 1167 | 20 |
1492423 | 1492423 | 2021-07-07 | Jasper | Illinois | 17079 | 1167 | 20 |
1489176 | 1489176 | 2021-07-06 | Jasper | Illinois | 17079 | 1167 | 20 |
1485929 | 1485929 | 2021-07-05 | Jasper | Illinois | 17079 | 1167 | 20 |
1482683 | 1482683 | 2021-07-04 | Jasper | Illinois | 17079 | 1167 | 20 |
1479436 | 1479436 | 2021-07-03 | Jasper | Illinois | 17079 | 1167 | 20 |
1476190 | 1476190 | 2021-07-02 | Jasper | Illinois | 17079 | 1167 | 20 |
1472944 | 1472944 | 2021-07-01 | Jasper | Illinois | 17079 | 1167 | 20 |
1469698 | 1469698 | 2021-06-30 | Jasper | Illinois | 17079 | 1167 | 20 |
1466453 | 1466453 | 2021-06-29 | Jasper | Illinois | 17079 | 1167 | 20 |
1463208 | 1463208 | 2021-06-28 | Jasper | Illinois | 17079 | 1167 | 20 |
1459963 | 1459963 | 2021-06-27 | Jasper | Illinois | 17079 | 1167 | 20 |
1456718 | 1456718 | 2021-06-26 | Jasper | Illinois | 17079 | 1167 | 20 |
1453473 | 1453473 | 2021-06-25 | Jasper | Illinois | 17079 | 1167 | 20 |
1450227 | 1450227 | 2021-06-24 | Jasper | Illinois | 17079 | 1167 | 20 |
1446982 | 1446982 | 2021-06-23 | Jasper | Illinois | 17079 | 1167 | 20 |
1443737 | 1443737 | 2021-06-22 | Jasper | Illinois | 17079 | 1167 | 20 |
1440492 | 1440492 | 2021-06-21 | Jasper | Illinois | 17079 | 1167 | 20 |
1437245 | 1437245 | 2021-06-20 | Jasper | Illinois | 17079 | 1167 | 20 |
1433998 | 1433998 | 2021-06-19 | Jasper | Illinois | 17079 | 1167 | 20 |
1430752 | 1430752 | 2021-06-18 | Jasper | Illinois | 17079 | 1167 | 20 |
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);