ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,316 rows where county = "Cook" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
county 1
- Cook · 2,316 ✖
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4 | 4 | 2020-01-24 | Cook | Illinois | 17031 | 1 | 0 |
7 | 7 | 2020-01-25 | Cook | Illinois | 17031 | 1 | 0 |
12 | 12 | 2020-01-26 | Cook | Illinois | 17031 | 1 | 0 |
17 | 17 | 2020-01-27 | Cook | Illinois | 17031 | 1 | 0 |
22 | 22 | 2020-01-28 | Cook | Illinois | 17031 | 1 | 0 |
27 | 27 | 2020-01-29 | Cook | Illinois | 17031 | 1 | 0 |
32 | 32 | 2020-01-30 | Cook | Illinois | 17031 | 2 | 0 |
38 | 38 | 2020-01-31 | Cook | Illinois | 17031 | 2 | 0 |
44 | 44 | 2020-02-01 | Cook | Illinois | 17031 | 2 | 0 |
52 | 52 | 2020-02-02 | Cook | Illinois | 17031 | 2 | 0 |
60 | 60 | 2020-02-03 | Cook | Illinois | 17031 | 2 | 0 |
68 | 68 | 2020-02-04 | Cook | Illinois | 17031 | 2 | 0 |
76 | 76 | 2020-02-05 | Cook | Illinois | 17031 | 2 | 0 |
85 | 85 | 2020-02-06 | Cook | Illinois | 17031 | 2 | 0 |
94 | 94 | 2020-02-07 | Cook | Illinois | 17031 | 2 | 0 |
103 | 103 | 2020-02-08 | Cook | Illinois | 17031 | 2 | 0 |
112 | 112 | 2020-02-09 | Cook | Illinois | 17031 | 2 | 0 |
122 | 122 | 2020-02-10 | Cook | Illinois | 17031 | 2 | 0 |
132 | 132 | 2020-02-11 | Cook | Illinois | 17031 | 2 | 0 |
142 | 142 | 2020-02-12 | Cook | Illinois | 17031 | 2 | 0 |
153 | 153 | 2020-02-13 | Cook | Illinois | 17031 | 2 | 0 |
164 | 164 | 2020-02-14 | Cook | Illinois | 17031 | 2 | 0 |
175 | 175 | 2020-02-15 | Cook | Illinois | 17031 | 2 | 0 |
186 | 186 | 2020-02-16 | Cook | Illinois | 17031 | 2 | 0 |
197 | 197 | 2020-02-17 | Cook | Illinois | 17031 | 2 | 0 |
209 | 209 | 2020-02-18 | Cook | Illinois | 17031 | 2 | 0 |
221 | 221 | 2020-02-19 | Cook | Illinois | 17031 | 2 | 0 |
234 | 234 | 2020-02-20 | Cook | Illinois | 17031 | 2 | 0 |
248 | 248 | 2020-02-21 | Cook | Illinois | 17031 | 2 | 0 |
262 | 262 | 2020-02-22 | Cook | Illinois | 17031 | 2 | 0 |
276 | 276 | 2020-02-23 | Cook | Illinois | 17031 | 2 | 0 |
291 | 291 | 2020-02-24 | Cook | Illinois | 17031 | 2 | 0 |
307 | 307 | 2020-02-25 | Cook | Illinois | 17031 | 2 | 0 |
327 | 327 | 2020-02-26 | Cook | Illinois | 17031 | 2 | 0 |
347 | 347 | 2020-02-27 | Cook | Illinois | 17031 | 2 | 0 |
367 | 367 | 2020-02-28 | Cook | Illinois | 17031 | 2 | 0 |
389 | 389 | 2020-02-29 | Cook | Illinois | 17031 | 3 | 0 |
414 | 414 | 2020-03-01 | Cook | Illinois | 17031 | 3 | 0 |
444 | 444 | 2020-03-02 | Cook | Illinois | 17031 | 4 | 0 |
478 | 478 | 2020-03-03 | Cook | Illinois | 17031 | 4 | 0 |
513 | 513 | 2020-03-04 | Cook | Illinois | 17031 | 4 | 0 |
555 | 555 | 2020-03-05 | Cook | Illinois | 17031 | 5 | 0 |
613 | 613 | 2020-03-06 | Cook | Illinois | 17031 | 6 | 0 |
697 | 697 | 2020-03-07 | Cook | Illinois | 17031 | 6 | 0 |
794 | 794 | 2020-03-08 | Cook | Illinois | 17031 | 7 | 0 |
914 | 914 | 2020-03-09 | Cook | Illinois | 17031 | 11 | 0 |
1055 | 1055 | 2020-03-10 | Cook | Illinois | 17031 | 17 | 0 |
1229 | 1229 | 2020-03-11 | Cook | Illinois | 17031 | 22 | 0 |
1443 | 1443 | 2020-03-12 | Cook | Illinois | 17031 | 27 | 0 |
1714 | 1714 | 2020-03-13 | Cook | Illinois | 17031 | 40 | 0 |
2040 | 2040 | 2020-03-14 | Cook | Illinois | 17031 | 51 | 0 |
2431 | 2431 | 2020-03-15 | Cook | Illinois | 17031 | 76 | 0 |
2872 | 2872 | 2020-03-16 | Cook | Illinois | 17031 | 76 | 0 |
3361 | 3361 | 2020-03-17 | Cook | Illinois | 17031 | 107 | 1 |
3924 | 3924 | 2020-03-18 | Cook | Illinois | 17031 | 179 | 1 |
4600 | 4600 | 2020-03-19 | Cook | Illinois | 17031 | 279 | 2 |
5405 | 5405 | 2020-03-20 | Cook | Illinois | 17031 | 412 | 3 |
6339 | 6339 | 2020-03-21 | Cook | Illinois | 17031 | 548 | 4 |
7389 | 7389 | 2020-03-22 | Cook | Illinois | 17031 | 805 | 6 |
8544 | 8544 | 2020-03-23 | Cook | Illinois | 17031 | 922 | 9 |
9807 | 9807 | 2020-03-24 | Cook | Illinois | 17031 | 1194 | 12 |
11197 | 11197 | 2020-03-25 | Cook | Illinois | 17031 | 1418 | 13 |
12752 | 12752 | 2020-03-26 | Cook | Illinois | 17031 | 1904 | 18 |
14428 | 14428 | 2020-03-27 | Cook | Illinois | 17031 | 2239 | 20 |
16222 | 16222 | 2020-03-28 | Cook | Illinois | 17031 | 2613 | 28 |
18121 | 18121 | 2020-03-29 | Cook | Illinois | 17031 | 3445 | 40 |
19987 | 19987 | 2020-03-30 | Cook | Georgia | 13075 | 1 | 0 |
20122 | 20122 | 2020-03-30 | Cook | Illinois | 17031 | 3727 | 44 |
22066 | 22066 | 2020-03-31 | Cook | Georgia | 13075 | 1 | 0 |
22213 | 22213 | 2020-03-31 | Cook | Illinois | 17031 | 4496 | 61 |
24229 | 24229 | 2020-04-01 | Cook | Georgia | 13075 | 1 | 0 |
24381 | 24381 | 2020-04-01 | Cook | Illinois | 17031 | 5152 | 95 |
26460 | 26460 | 2020-04-02 | Cook | Georgia | 13075 | 1 | 0 |
26614 | 26614 | 2020-04-02 | Cook | Illinois | 17031 | 5575 | 107 |
28763 | 28763 | 2020-04-03 | Cook | Georgia | 13075 | 1 | 0 |
28921 | 28921 | 2020-04-03 | Cook | Illinois | 17031 | 6473 | 141 |
31123 | 31123 | 2020-04-04 | Cook | Georgia | 13075 | 1 | 0 |
31283 | 31283 | 2020-04-04 | Cook | Illinois | 17031 | 7439 | 167 |
33529 | 33529 | 2020-04-05 | Cook | Georgia | 13075 | 1 | 0 |
33692 | 33692 | 2020-04-05 | Cook | Illinois | 17031 | 8043 | 186 |
35977 | 35977 | 2020-04-06 | Cook | Georgia | 13075 | 2 | 0 |
36143 | 36143 | 2020-04-06 | Cook | Illinois | 17031 | 8728 | 209 |
38469 | 38469 | 2020-04-07 | Cook | Georgia | 13075 | 4 | 0 |
38638 | 38638 | 2020-04-07 | Cook | Illinois | 17031 | 9509 | 249 |
41013 | 41013 | 2020-04-08 | Cook | Georgia | 13075 | 4 | 0 |
41182 | 41182 | 2020-04-08 | Cook | Illinois | 17031 | 10520 | 312 |
43587 | 43587 | 2020-04-09 | Cook | Georgia | 13075 | 6 | 0 |
43756 | 43756 | 2020-04-09 | Cook | Illinois | 17031 | 11415 | 351 |
46189 | 46189 | 2020-04-10 | Cook | Georgia | 13075 | 6 | 0 |
46358 | 46358 | 2020-04-10 | Cook | Illinois | 17031 | 12472 | 398 |
48819 | 48819 | 2020-04-11 | Cook | Georgia | 13075 | 6 | 0 |
48989 | 48989 | 2020-04-11 | Cook | Illinois | 17031 | 13417 | 453 |
51480 | 51480 | 2020-04-12 | Cook | Georgia | 13075 | 7 | 0 |
51651 | 51651 | 2020-04-12 | Cook | Illinois | 17031 | 14585 | 485 |
54160 | 54160 | 2020-04-13 | Cook | Georgia | 13075 | 7 | 0 |
54331 | 54331 | 2020-04-13 | Cook | Illinois | 17031 | 15474 | 543 |
56852 | 56852 | 2020-04-14 | Cook | Georgia | 13075 | 7 | 0 |
57024 | 57024 | 2020-04-14 | Cook | Illinois | 17031 | 16323 | 577 |
59559 | 59559 | 2020-04-15 | Cook | Georgia | 13075 | 9 | 0 |
59731 | 59731 | 2020-04-15 | Cook | Illinois | 17031 | 17306 | 630 |
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);