ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Kane" and state = "Illinois" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
1056 | 1056 | 2020-03-10 | Kane | Illinois | 17089 | 1 | 0 |
1230 | 1230 | 2020-03-11 | Kane | Illinois | 17089 | 1 | 0 |
1444 | 1444 | 2020-03-12 | Kane | Illinois | 17089 | 2 | 0 |
1715 | 1715 | 2020-03-13 | Kane | Illinois | 17089 | 2 | 0 |
2043 | 2043 | 2020-03-14 | Kane | Illinois | 17089 | 3 | 0 |
2434 | 2434 | 2020-03-15 | Kane | Illinois | 17089 | 3 | 0 |
2875 | 2875 | 2020-03-16 | Kane | Illinois | 17089 | 3 | 0 |
3364 | 3364 | 2020-03-17 | Kane | Illinois | 17089 | 3 | 0 |
3928 | 3928 | 2020-03-18 | Kane | Illinois | 17089 | 4 | 0 |
4604 | 4604 | 2020-03-19 | Kane | Illinois | 17089 | 6 | 0 |
5409 | 5409 | 2020-03-20 | Kane | Illinois | 17089 | 8 | 0 |
6344 | 6344 | 2020-03-21 | Kane | Illinois | 17089 | 8 | 0 |
7395 | 7395 | 2020-03-22 | Kane | Illinois | 17089 | 13 | 0 |
8550 | 8550 | 2020-03-23 | Kane | Illinois | 17089 | 23 | 0 |
9814 | 9814 | 2020-03-24 | Kane | Illinois | 17089 | 24 | 0 |
11205 | 11205 | 2020-03-25 | Kane | Illinois | 17089 | 38 | 1 |
12761 | 12761 | 2020-03-26 | Kane | Illinois | 17089 | 57 | 1 |
14439 | 14439 | 2020-03-27 | Kane | Illinois | 17089 | 77 | 2 |
16234 | 16234 | 2020-03-28 | Kane | Illinois | 17089 | 90 | 4 |
18133 | 18133 | 2020-03-29 | Kane | Illinois | 17089 | 100 | 7 |
20135 | 20135 | 2020-03-30 | Kane | Illinois | 17089 | 113 | 7 |
22227 | 22227 | 2020-03-31 | Kane | Illinois | 17089 | 128 | 7 |
24395 | 24395 | 2020-04-01 | Kane | Illinois | 17089 | 142 | 8 |
26628 | 26628 | 2020-04-02 | Kane | Illinois | 17089 | 154 | 8 |
28938 | 28938 | 2020-04-03 | Kane | Illinois | 17089 | 176 | 9 |
31301 | 31301 | 2020-04-04 | Kane | Illinois | 17089 | 207 | 12 |
33711 | 33711 | 2020-04-05 | Kane | Illinois | 17089 | 220 | 15 |
36163 | 36163 | 2020-04-06 | Kane | Illinois | 17089 | 234 | 15 |
38658 | 38658 | 2020-04-07 | Kane | Illinois | 17089 | 255 | 18 |
41203 | 41203 | 2020-04-08 | Kane | Illinois | 17089 | 296 | 19 |
43777 | 43777 | 2020-04-09 | Kane | Illinois | 17089 | 318 | 20 |
46381 | 46381 | 2020-04-10 | Kane | Illinois | 17089 | 339 | 22 |
49012 | 49012 | 2020-04-11 | Kane | Illinois | 17089 | 376 | 22 |
51674 | 51674 | 2020-04-12 | Kane | Illinois | 17089 | 403 | 23 |
54355 | 54355 | 2020-04-13 | Kane | Illinois | 17089 | 421 | 24 |
57048 | 57048 | 2020-04-14 | Kane | Illinois | 17089 | 448 | 24 |
59755 | 59755 | 2020-04-15 | Kane | Illinois | 17089 | 463 | 24 |
62476 | 62476 | 2020-04-16 | Kane | Illinois | 17089 | 490 | 25 |
65209 | 65209 | 2020-04-17 | Kane | Illinois | 17089 | 538 | 28 |
67958 | 67958 | 2020-04-18 | Kane | Illinois | 17089 | 582 | 30 |
70720 | 70720 | 2020-04-19 | Kane | Illinois | 17089 | 605 | 30 |
73490 | 73490 | 2020-04-20 | Kane | Illinois | 17089 | 638 | 31 |
76267 | 76267 | 2020-04-21 | Kane | Illinois | 17089 | 684 | 33 |
79051 | 79051 | 2020-04-22 | Kane | Illinois | 17089 | 764 | 37 |
81844 | 81844 | 2020-04-23 | Kane | Illinois | 17089 | 863 | 39 |
84644 | 84644 | 2020-04-24 | Kane | Illinois | 17089 | 962 | 39 |
87454 | 87454 | 2020-04-25 | Kane | Illinois | 17089 | 1049 | 39 |
90270 | 90270 | 2020-04-26 | Kane | Illinois | 17089 | 1109 | 39 |
93089 | 93089 | 2020-04-27 | Kane | Illinois | 17089 | 1185 | 39 |
95921 | 95921 | 2020-04-28 | Kane | Illinois | 17089 | 1308 | 41 |
98765 | 98765 | 2020-04-29 | Kane | Illinois | 17089 | 1412 | 45 |
101616 | 101616 | 2020-04-30 | Kane | Illinois | 17089 | 1526 | 48 |
104472 | 104472 | 2020-05-01 | Kane | Illinois | 17089 | 1677 | 52 |
107337 | 107337 | 2020-05-02 | Kane | Illinois | 17089 | 1803 | 57 |
110207 | 110207 | 2020-05-03 | Kane | Illinois | 17089 | 1935 | 57 |
113082 | 113082 | 2020-05-04 | Kane | Illinois | 17089 | 2115 | 57 |
115965 | 115965 | 2020-05-05 | Kane | Illinois | 17089 | 2206 | 65 |
118925 | 118925 | 2020-05-06 | Kane | Illinois | 17089 | 2331 | 74 |
121895 | 121895 | 2020-05-07 | Kane | Illinois | 17089 | 2498 | 78 |
124874 | 124874 | 2020-05-08 | Kane | Illinois | 17089 | 2668 | 84 |
127861 | 127861 | 2020-05-09 | Kane | Illinois | 17089 | 2818 | 88 |
130852 | 130852 | 2020-05-10 | Kane | Illinois | 17089 | 3003 | 89 |
133843 | 133843 | 2020-05-11 | Kane | Illinois | 17089 | 3126 | 90 |
136832 | 136832 | 2020-05-12 | Kane | Illinois | 17089 | 3592 | 93 |
139824 | 139824 | 2020-05-13 | Kane | Illinois | 17089 | 3744 | 98 |
142820 | 142820 | 2020-05-14 | Kane | Illinois | 17089 | 3995 | 104 |
145820 | 145820 | 2020-05-15 | Kane | Illinois | 17089 | 4159 | 107 |
148823 | 148823 | 2020-05-16 | Kane | Illinois | 17089 | 4263 | 109 |
151832 | 151832 | 2020-05-17 | Kane | Illinois | 17089 | 4396 | 115 |
154844 | 154844 | 2020-05-18 | Kane | Illinois | 17089 | 4584 | 115 |
157860 | 157860 | 2020-05-19 | Kane | Illinois | 17089 | 4682 | 120 |
160886 | 160886 | 2020-05-20 | Kane | Illinois | 17089 | 4813 | 136 |
163914 | 163914 | 2020-05-21 | Kane | Illinois | 17089 | 4981 | 145 |
166947 | 166947 | 2020-05-22 | Kane | Illinois | 17089 | 5327 | 150 |
169984 | 169984 | 2020-05-23 | Kane | Illinois | 17089 | 5575 | 152 |
173025 | 173025 | 2020-05-24 | Kane | Illinois | 17089 | 5703 | 152 |
176069 | 176069 | 2020-05-25 | Kane | Illinois | 17089 | 5846 | 152 |
179113 | 179113 | 2020-05-26 | Kane | Illinois | 17089 | 5920 | 155 |
182157 | 182157 | 2020-05-27 | Kane | Illinois | 17089 | 6000 | 163 |
185211 | 185211 | 2020-05-28 | Kane | Illinois | 17089 | 6145 | 167 |
188269 | 188269 | 2020-05-29 | Kane | Illinois | 17089 | 6235 | 170 |
191334 | 191334 | 2020-05-30 | Kane | Illinois | 17089 | 6327 | 176 |
194401 | 194401 | 2020-05-31 | Kane | Illinois | 17089 | 6408 | 178 |
197471 | 197471 | 2020-06-01 | Kane | Illinois | 17089 | 6461 | 178 |
200544 | 200544 | 2020-06-02 | Kane | Illinois | 17089 | 6514 | 188 |
203620 | 203620 | 2020-06-03 | Kane | Illinois | 17089 | 6590 | 194 |
206700 | 206700 | 2020-06-04 | Kane | Illinois | 17089 | 6638 | 198 |
209781 | 209781 | 2020-06-05 | Kane | Illinois | 17089 | 6736 | 207 |
212866 | 212866 | 2020-06-06 | Kane | Illinois | 17089 | 6793 | 215 |
215953 | 215953 | 2020-06-07 | Kane | Illinois | 17089 | 6859 | 215 |
219044 | 219044 | 2020-06-08 | Kane | Illinois | 17089 | 6906 | 215 |
222139 | 222139 | 2020-06-09 | Kane | Illinois | 17089 | 6956 | 221 |
225234 | 225234 | 2020-06-10 | Kane | Illinois | 17089 | 6956 | 221 |
228336 | 228336 | 2020-06-11 | Kane | Illinois | 17089 | 7053 | 227 |
231439 | 231439 | 2020-06-12 | Kane | Illinois | 17089 | 7074 | 228 |
234545 | 234545 | 2020-06-13 | Kane | Illinois | 17089 | 7126 | 230 |
237652 | 237652 | 2020-06-14 | Kane | Illinois | 17089 | 7154 | 231 |
240760 | 240760 | 2020-06-15 | Kane | Illinois | 17089 | 7175 | 234 |
243871 | 243871 | 2020-06-16 | Kane | Illinois | 17089 | 7223 | 234 |
246984 | 246984 | 2020-06-17 | Kane | Illinois | 17089 | 7246 | 240 |
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);