ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
24 rows where date = "2020-03-20" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5402 | 5402 | 2020-03-20 | Adams | Illinois | 17001 | 1 | 0 |
5403 | 5403 | 2020-03-20 | Christian | Illinois | 17021 | 1 | 0 |
5404 | 5404 | 2020-03-20 | Clinton | Illinois | 17027 | 3 | 0 |
5405 | 5405 | 2020-03-20 | Cook | Illinois | 17031 | 412 | 3 |
5406 | 5406 | 2020-03-20 | Cumberland | Illinois | 17035 | 1 | 0 |
5407 | 5407 | 2020-03-20 | DuPage | Illinois | 17043 | 57 | 0 |
5408 | 5408 | 2020-03-20 | Jackson | Illinois | 17077 | 1 | 0 |
5409 | 5409 | 2020-03-20 | Kane | Illinois | 17089 | 8 | 0 |
5410 | 5410 | 2020-03-20 | Kankakee | Illinois | 17091 | 1 | 0 |
5411 | 5411 | 2020-03-20 | Kendall | Illinois | 17093 | 3 | 0 |
5412 | 5412 | 2020-03-20 | LaSalle | Illinois | 17099 | 1 | 0 |
5413 | 5413 | 2020-03-20 | Lake | Illinois | 17097 | 52 | 0 |
5414 | 5414 | 2020-03-20 | Madison | Illinois | 17119 | 1 | 0 |
5415 | 5415 | 2020-03-20 | McHenry | Illinois | 17111 | 8 | 0 |
5416 | 5416 | 2020-03-20 | McLean | Illinois | 17113 | 4 | 0 |
5417 | 5417 | 2020-03-20 | Peoria | Illinois | 17143 | 3 | 0 |
5418 | 5418 | 2020-03-20 | Sangamon | Illinois | 17167 | 4 | 1 |
5419 | 5419 | 2020-03-20 | St. Clair | Illinois | 17163 | 3 | 0 |
5420 | 5420 | 2020-03-20 | Washington | Illinois | 17189 | 1 | 0 |
5421 | 5421 | 2020-03-20 | Whiteside | Illinois | 17195 | 1 | 0 |
5422 | 5422 | 2020-03-20 | Will | Illinois | 17197 | 12 | 1 |
5423 | 5423 | 2020-03-20 | Williamson | Illinois | 17199 | 1 | 0 |
5424 | 5424 | 2020-03-20 | Winnebago | Illinois | 17201 | 2 | 0 |
5425 | 5425 | 2020-03-20 | Woodford | Illinois | 17203 | 2 | 0 |
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);