ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
841 rows where fips = 17031 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
38638 | 38638 | 2020-04-07 | Cook | Illinois | 17031 | 9509 | 249 |
36143 | 36143 | 2020-04-06 | Cook | Illinois | 17031 | 8728 | 209 |
33692 | 33692 | 2020-04-05 | Cook | Illinois | 17031 | 8043 | 186 |
31283 | 31283 | 2020-04-04 | Cook | Illinois | 17031 | 7439 | 167 |
28921 | 28921 | 2020-04-03 | Cook | Illinois | 17031 | 6473 | 141 |
26614 | 26614 | 2020-04-02 | Cook | Illinois | 17031 | 5575 | 107 |
24381 | 24381 | 2020-04-01 | Cook | Illinois | 17031 | 5152 | 95 |
22213 | 22213 | 2020-03-31 | Cook | Illinois | 17031 | 4496 | 61 |
20122 | 20122 | 2020-03-30 | Cook | Illinois | 17031 | 3727 | 44 |
18121 | 18121 | 2020-03-29 | Cook | Illinois | 17031 | 3445 | 40 |
16222 | 16222 | 2020-03-28 | Cook | Illinois | 17031 | 2613 | 28 |
14428 | 14428 | 2020-03-27 | Cook | Illinois | 17031 | 2239 | 20 |
12752 | 12752 | 2020-03-26 | Cook | Illinois | 17031 | 1904 | 18 |
11197 | 11197 | 2020-03-25 | Cook | Illinois | 17031 | 1418 | 13 |
9807 | 9807 | 2020-03-24 | Cook | Illinois | 17031 | 1194 | 12 |
8544 | 8544 | 2020-03-23 | Cook | Illinois | 17031 | 922 | 9 |
7389 | 7389 | 2020-03-22 | Cook | Illinois | 17031 | 805 | 6 |
6339 | 6339 | 2020-03-21 | Cook | Illinois | 17031 | 548 | 4 |
5405 | 5405 | 2020-03-20 | Cook | Illinois | 17031 | 412 | 3 |
4600 | 4600 | 2020-03-19 | Cook | Illinois | 17031 | 279 | 2 |
3924 | 3924 | 2020-03-18 | Cook | Illinois | 17031 | 179 | 1 |
3361 | 3361 | 2020-03-17 | Cook | Illinois | 17031 | 107 | 1 |
2872 | 2872 | 2020-03-16 | Cook | Illinois | 17031 | 76 | 0 |
2431 | 2431 | 2020-03-15 | Cook | Illinois | 17031 | 76 | 0 |
2040 | 2040 | 2020-03-14 | Cook | Illinois | 17031 | 51 | 0 |
1714 | 1714 | 2020-03-13 | Cook | Illinois | 17031 | 40 | 0 |
1443 | 1443 | 2020-03-12 | Cook | Illinois | 17031 | 27 | 0 |
1229 | 1229 | 2020-03-11 | Cook | Illinois | 17031 | 22 | 0 |
1055 | 1055 | 2020-03-10 | Cook | Illinois | 17031 | 17 | 0 |
914 | 914 | 2020-03-09 | Cook | Illinois | 17031 | 11 | 0 |
794 | 794 | 2020-03-08 | Cook | Illinois | 17031 | 7 | 0 |
697 | 697 | 2020-03-07 | Cook | Illinois | 17031 | 6 | 0 |
613 | 613 | 2020-03-06 | Cook | Illinois | 17031 | 6 | 0 |
555 | 555 | 2020-03-05 | Cook | Illinois | 17031 | 5 | 0 |
513 | 513 | 2020-03-04 | Cook | Illinois | 17031 | 4 | 0 |
478 | 478 | 2020-03-03 | Cook | Illinois | 17031 | 4 | 0 |
444 | 444 | 2020-03-02 | Cook | Illinois | 17031 | 4 | 0 |
414 | 414 | 2020-03-01 | Cook | Illinois | 17031 | 3 | 0 |
389 | 389 | 2020-02-29 | Cook | Illinois | 17031 | 3 | 0 |
367 | 367 | 2020-02-28 | Cook | Illinois | 17031 | 2 | 0 |
347 | 347 | 2020-02-27 | Cook | Illinois | 17031 | 2 | 0 |
327 | 327 | 2020-02-26 | Cook | Illinois | 17031 | 2 | 0 |
307 | 307 | 2020-02-25 | Cook | Illinois | 17031 | 2 | 0 |
291 | 291 | 2020-02-24 | Cook | Illinois | 17031 | 2 | 0 |
276 | 276 | 2020-02-23 | Cook | Illinois | 17031 | 2 | 0 |
262 | 262 | 2020-02-22 | Cook | Illinois | 17031 | 2 | 0 |
248 | 248 | 2020-02-21 | Cook | Illinois | 17031 | 2 | 0 |
234 | 234 | 2020-02-20 | Cook | Illinois | 17031 | 2 | 0 |
221 | 221 | 2020-02-19 | Cook | Illinois | 17031 | 2 | 0 |
209 | 209 | 2020-02-18 | Cook | Illinois | 17031 | 2 | 0 |
197 | 197 | 2020-02-17 | Cook | Illinois | 17031 | 2 | 0 |
186 | 186 | 2020-02-16 | Cook | Illinois | 17031 | 2 | 0 |
175 | 175 | 2020-02-15 | Cook | Illinois | 17031 | 2 | 0 |
164 | 164 | 2020-02-14 | Cook | Illinois | 17031 | 2 | 0 |
153 | 153 | 2020-02-13 | Cook | Illinois | 17031 | 2 | 0 |
142 | 142 | 2020-02-12 | Cook | Illinois | 17031 | 2 | 0 |
132 | 132 | 2020-02-11 | Cook | Illinois | 17031 | 2 | 0 |
122 | 122 | 2020-02-10 | Cook | Illinois | 17031 | 2 | 0 |
112 | 112 | 2020-02-09 | Cook | Illinois | 17031 | 2 | 0 |
103 | 103 | 2020-02-08 | Cook | Illinois | 17031 | 2 | 0 |
94 | 94 | 2020-02-07 | Cook | Illinois | 17031 | 2 | 0 |
85 | 85 | 2020-02-06 | Cook | Illinois | 17031 | 2 | 0 |
76 | 76 | 2020-02-05 | Cook | Illinois | 17031 | 2 | 0 |
68 | 68 | 2020-02-04 | Cook | Illinois | 17031 | 2 | 0 |
60 | 60 | 2020-02-03 | Cook | Illinois | 17031 | 2 | 0 |
52 | 52 | 2020-02-02 | Cook | Illinois | 17031 | 2 | 0 |
44 | 44 | 2020-02-01 | Cook | Illinois | 17031 | 2 | 0 |
38 | 38 | 2020-01-31 | Cook | Illinois | 17031 | 2 | 0 |
32 | 32 | 2020-01-30 | Cook | Illinois | 17031 | 2 | 0 |
27 | 27 | 2020-01-29 | Cook | Illinois | 17031 | 1 | 0 |
22 | 22 | 2020-01-28 | Cook | Illinois | 17031 | 1 | 0 |
17 | 17 | 2020-01-27 | Cook | Illinois | 17031 | 1 | 0 |
12 | 12 | 2020-01-26 | Cook | Illinois | 17031 | 1 | 0 |
7 | 7 | 2020-01-25 | Cook | Illinois | 17031 | 1 | 0 |
4 | 4 | 2020-01-24 | Cook | Illinois | 17031 | 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);