ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
841 rows where county = "Cook" and fips = 17031 sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-01-24 1
- 2020-01-25 1
- 2020-01-26 1
- 2020-01-27 1
- 2020-01-28 1
- 2020-01-29 1
- 2020-01-30 1
- 2020-01-31 1
- 2020-02-01 1
- 2020-02-02 1
- 2020-02-03 1
- 2020-02-04 1
- 2020-02-05 1
- 2020-02-06 1
- 2020-02-07 1
- 2020-02-08 1
- 2020-02-09 1
- 2020-02-10 1
- 2020-02-11 1
- 2020-02-12 1
- 2020-02-13 1
- 2020-02-14 1
- 2020-02-15 1
- 2020-02-16 1
- 2020-02-17 1
- 2020-02-18 1
- 2020-02-19 1
- 2020-02-20 1
- 2020-02-21 1
- 2020-02-22 1
- …
state 1
- Illinois 841
fips 1
- 17031 · 841 ✖
county 1
- Cook · 841 ✖
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 |
20122 | 20122 | 2020-03-30 | Cook | Illinois | 17031 | 3727 | 44 |
22213 | 22213 | 2020-03-31 | Cook | Illinois | 17031 | 4496 | 61 |
24381 | 24381 | 2020-04-01 | Cook | Illinois | 17031 | 5152 | 95 |
26614 | 26614 | 2020-04-02 | Cook | Illinois | 17031 | 5575 | 107 |
28921 | 28921 | 2020-04-03 | Cook | Illinois | 17031 | 6473 | 141 |
31283 | 31283 | 2020-04-04 | Cook | Illinois | 17031 | 7439 | 167 |
33692 | 33692 | 2020-04-05 | Cook | Illinois | 17031 | 8043 | 186 |
36143 | 36143 | 2020-04-06 | Cook | Illinois | 17031 | 8728 | 209 |
38638 | 38638 | 2020-04-07 | Cook | Illinois | 17031 | 9509 | 249 |
41182 | 41182 | 2020-04-08 | Cook | Illinois | 17031 | 10520 | 312 |
43756 | 43756 | 2020-04-09 | Cook | Illinois | 17031 | 11415 | 351 |
46358 | 46358 | 2020-04-10 | Cook | Illinois | 17031 | 12472 | 398 |
48989 | 48989 | 2020-04-11 | Cook | Illinois | 17031 | 13417 | 453 |
51651 | 51651 | 2020-04-12 | Cook | Illinois | 17031 | 14585 | 485 |
54331 | 54331 | 2020-04-13 | Cook | Illinois | 17031 | 15474 | 543 |
57024 | 57024 | 2020-04-14 | Cook | Illinois | 17031 | 16323 | 577 |
59731 | 59731 | 2020-04-15 | Cook | Illinois | 17031 | 17306 | 630 |
62452 | 62452 | 2020-04-16 | Cook | Illinois | 17031 | 18087 | 722 |
65184 | 65184 | 2020-04-17 | Cook | Illinois | 17031 | 19391 | 760 |
67932 | 67932 | 2020-04-18 | Cook | Illinois | 17031 | 20395 | 860 |
70694 | 70694 | 2020-04-19 | Cook | Illinois | 17031 | 21272 | 877 |
73464 | 73464 | 2020-04-20 | Cook | Illinois | 17031 | 22101 | 915 |
76240 | 76240 | 2020-04-21 | Cook | Illinois | 17031 | 23181 | 1002 |
79024 | 79024 | 2020-04-22 | Cook | Illinois | 17031 | 24546 | 1072 |
81817 | 81817 | 2020-04-23 | Cook | Illinois | 17031 | 25811 | 1142 |
84617 | 84617 | 2020-04-24 | Cook | Illinois | 17031 | 27616 | 1220 |
87427 | 87427 | 2020-04-25 | Cook | Illinois | 17031 | 29058 | 1267 |
90243 | 90243 | 2020-04-26 | Cook | Illinois | 17031 | 30574 | 1313 |
93062 | 93062 | 2020-04-27 | Cook | Illinois | 17031 | 31953 | 1347 |
95894 | 95894 | 2020-04-28 | Cook | Illinois | 17031 | 33449 | 1457 |
98738 | 98738 | 2020-04-29 | Cook | Illinois | 17031 | 34880 | 1516 |
101589 | 101589 | 2020-04-30 | Cook | Illinois | 17031 | 36513 | 1607 |
104445 | 104445 | 2020-05-01 | Cook | Illinois | 17031 | 38668 | 1673 |
107310 | 107310 | 2020-05-02 | Cook | Illinois | 17031 | 40227 | 1743 |
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);