ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 17099 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
79055 | 79055 | 2020-04-22 | LaSalle | Illinois | 17099 | 38 | 1 |
76271 | 76271 | 2020-04-21 | LaSalle | Illinois | 17099 | 33 | 1 |
73494 | 73494 | 2020-04-20 | LaSalle | Illinois | 17099 | 30 | 1 |
70724 | 70724 | 2020-04-19 | LaSalle | Illinois | 17099 | 28 | 1 |
67962 | 67962 | 2020-04-18 | LaSalle | Illinois | 17099 | 27 | 1 |
65213 | 65213 | 2020-04-17 | LaSalle | Illinois | 17099 | 27 | 1 |
62480 | 62480 | 2020-04-16 | LaSalle | Illinois | 17099 | 25 | 1 |
59759 | 59759 | 2020-04-15 | LaSalle | Illinois | 17099 | 24 | 1 |
57052 | 57052 | 2020-04-14 | LaSalle | Illinois | 17099 | 23 | 1 |
54359 | 54359 | 2020-04-13 | LaSalle | Illinois | 17099 | 21 | 1 |
51678 | 51678 | 2020-04-12 | LaSalle | Illinois | 17099 | 20 | 1 |
49016 | 49016 | 2020-04-11 | LaSalle | Illinois | 17099 | 18 | 1 |
46385 | 46385 | 2020-04-10 | LaSalle | Illinois | 17099 | 19 | 1 |
43781 | 43781 | 2020-04-09 | LaSalle | Illinois | 17099 | 17 | 1 |
41207 | 41207 | 2020-04-08 | LaSalle | Illinois | 17099 | 17 | 1 |
38662 | 38662 | 2020-04-07 | LaSalle | Illinois | 17099 | 15 | 1 |
36167 | 36167 | 2020-04-06 | LaSalle | Illinois | 17099 | 11 | 1 |
33715 | 33715 | 2020-04-05 | LaSalle | Illinois | 17099 | 8 | 1 |
31305 | 31305 | 2020-04-04 | LaSalle | Illinois | 17099 | 7 | 1 |
28942 | 28942 | 2020-04-03 | LaSalle | Illinois | 17099 | 6 | 1 |
26632 | 26632 | 2020-04-02 | LaSalle | Illinois | 17099 | 6 | 1 |
24399 | 24399 | 2020-04-01 | LaSalle | Illinois | 17099 | 6 | 1 |
22231 | 22231 | 2020-03-31 | LaSalle | Illinois | 17099 | 6 | 1 |
20139 | 20139 | 2020-03-30 | LaSalle | Illinois | 17099 | 5 | 2 |
18137 | 18137 | 2020-03-29 | LaSalle | Illinois | 17099 | 4 | 2 |
16237 | 16237 | 2020-03-28 | LaSalle | Illinois | 17099 | 4 | 1 |
14442 | 14442 | 2020-03-27 | LaSalle | Illinois | 17099 | 3 | 0 |
12764 | 12764 | 2020-03-26 | LaSalle | Illinois | 17099 | 3 | 0 |
11208 | 11208 | 2020-03-25 | LaSalle | Illinois | 17099 | 3 | 0 |
9817 | 9817 | 2020-03-24 | LaSalle | Illinois | 17099 | 3 | 0 |
8553 | 8553 | 2020-03-23 | LaSalle | Illinois | 17099 | 2 | 0 |
7398 | 7398 | 2020-03-22 | LaSalle | Illinois | 17099 | 1 | 0 |
6347 | 6347 | 2020-03-21 | LaSalle | Illinois | 17099 | 1 | 0 |
5412 | 5412 | 2020-03-20 | LaSalle | Illinois | 17099 | 1 | 0 |
4607 | 4607 | 2020-03-19 | LaSalle | Illinois | 17099 | 1 | 0 |
3931 | 3931 | 2020-03-18 | LaSalle | Illinois | 17099 | 1 | 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);