ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Stephenson", fips = 17177 and state = "Illinois" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
7408 | 7408 | 2020-03-22 | Stephenson | Illinois | 17177 | 1 | 0 |
8564 | 8564 | 2020-03-23 | Stephenson | Illinois | 17177 | 1 | 0 |
9828 | 9828 | 2020-03-24 | Stephenson | Illinois | 17177 | 1 | 0 |
11221 | 11221 | 2020-03-25 | Stephenson | Illinois | 17177 | 1 | 0 |
12777 | 12777 | 2020-03-26 | Stephenson | Illinois | 17177 | 2 | 0 |
14455 | 14455 | 2020-03-27 | Stephenson | Illinois | 17177 | 2 | 0 |
16251 | 16251 | 2020-03-28 | Stephenson | Illinois | 17177 | 2 | 0 |
18153 | 18153 | 2020-03-29 | Stephenson | Illinois | 17177 | 3 | 0 |
20158 | 20158 | 2020-03-30 | Stephenson | Illinois | 17177 | 3 | 0 |
22251 | 22251 | 2020-03-31 | Stephenson | Illinois | 17177 | 3 | 0 |
24420 | 24420 | 2020-04-01 | Stephenson | Illinois | 17177 | 3 | 0 |
26658 | 26658 | 2020-04-02 | Stephenson | Illinois | 17177 | 3 | 0 |
28968 | 28968 | 2020-04-03 | Stephenson | Illinois | 17177 | 3 | 0 |
31334 | 31334 | 2020-04-04 | Stephenson | Illinois | 17177 | 3 | 0 |
33744 | 33744 | 2020-04-05 | Stephenson | Illinois | 17177 | 3 | 0 |
36196 | 36196 | 2020-04-06 | Stephenson | Illinois | 17177 | 5 | 0 |
38694 | 38694 | 2020-04-07 | Stephenson | Illinois | 17177 | 6 | 0 |
41240 | 41240 | 2020-04-08 | Stephenson | Illinois | 17177 | 6 | 0 |
43816 | 43816 | 2020-04-09 | Stephenson | Illinois | 17177 | 7 | 0 |
46420 | 46420 | 2020-04-10 | Stephenson | Illinois | 17177 | 8 | 0 |
49053 | 49053 | 2020-04-11 | Stephenson | Illinois | 17177 | 8 | 0 |
51715 | 51715 | 2020-04-12 | Stephenson | Illinois | 17177 | 8 | 0 |
54396 | 54396 | 2020-04-13 | Stephenson | Illinois | 17177 | 8 | 0 |
57089 | 57089 | 2020-04-14 | Stephenson | Illinois | 17177 | 9 | 0 |
59796 | 59796 | 2020-04-15 | Stephenson | Illinois | 17177 | 9 | 0 |
62517 | 62517 | 2020-04-16 | Stephenson | Illinois | 17177 | 9 | 0 |
65250 | 65250 | 2020-04-17 | Stephenson | Illinois | 17177 | 10 | 0 |
67999 | 67999 | 2020-04-18 | Stephenson | Illinois | 17177 | 12 | 0 |
70761 | 70761 | 2020-04-19 | Stephenson | Illinois | 17177 | 12 | 0 |
73531 | 73531 | 2020-04-20 | Stephenson | Illinois | 17177 | 12 | 0 |
76308 | 76308 | 2020-04-21 | Stephenson | Illinois | 17177 | 13 | 0 |
79092 | 79092 | 2020-04-22 | Stephenson | Illinois | 17177 | 13 | 0 |
81885 | 81885 | 2020-04-23 | Stephenson | Illinois | 17177 | 13 | 0 |
84685 | 84685 | 2020-04-24 | Stephenson | Illinois | 17177 | 13 | 0 |
87495 | 87495 | 2020-04-25 | Stephenson | Illinois | 17177 | 16 | 0 |
90311 | 90311 | 2020-04-26 | Stephenson | Illinois | 17177 | 16 | 0 |
93130 | 93130 | 2020-04-27 | Stephenson | Illinois | 17177 | 16 | 0 |
95962 | 95962 | 2020-04-28 | Stephenson | Illinois | 17177 | 22 | 0 |
98806 | 98806 | 2020-04-29 | Stephenson | Illinois | 17177 | 29 | 0 |
101657 | 101657 | 2020-04-30 | Stephenson | Illinois | 17177 | 35 | 0 |
104513 | 104513 | 2020-05-01 | Stephenson | Illinois | 17177 | 45 | 0 |
107378 | 107378 | 2020-05-02 | Stephenson | Illinois | 17177 | 53 | 0 |
110248 | 110248 | 2020-05-03 | Stephenson | Illinois | 17177 | 63 | 0 |
113123 | 113123 | 2020-05-04 | Stephenson | Illinois | 17177 | 71 | 0 |
116006 | 116006 | 2020-05-05 | Stephenson | Illinois | 17177 | 70 | 0 |
118966 | 118966 | 2020-05-06 | Stephenson | Illinois | 17177 | 72 | 0 |
121936 | 121936 | 2020-05-07 | Stephenson | Illinois | 17177 | 78 | 0 |
124916 | 124916 | 2020-05-08 | Stephenson | Illinois | 17177 | 84 | 0 |
127903 | 127903 | 2020-05-09 | Stephenson | Illinois | 17177 | 88 | 0 |
130894 | 130894 | 2020-05-10 | Stephenson | Illinois | 17177 | 97 | 0 |
133885 | 133885 | 2020-05-11 | Stephenson | Illinois | 17177 | 99 | 0 |
136874 | 136874 | 2020-05-12 | Stephenson | Illinois | 17177 | 110 | 0 |
139866 | 139866 | 2020-05-13 | Stephenson | Illinois | 17177 | 118 | 0 |
142862 | 142862 | 2020-05-14 | Stephenson | Illinois | 17177 | 119 | 0 |
145862 | 145862 | 2020-05-15 | Stephenson | Illinois | 17177 | 135 | 0 |
148866 | 148866 | 2020-05-16 | Stephenson | Illinois | 17177 | 136 | 0 |
151875 | 151875 | 2020-05-17 | Stephenson | Illinois | 17177 | 150 | 1 |
154887 | 154887 | 2020-05-18 | Stephenson | Illinois | 17177 | 156 | 1 |
157903 | 157903 | 2020-05-19 | Stephenson | Illinois | 17177 | 160 | 1 |
160929 | 160929 | 2020-05-20 | Stephenson | Illinois | 17177 | 161 | 1 |
163957 | 163957 | 2020-05-21 | Stephenson | Illinois | 17177 | 167 | 2 |
166990 | 166990 | 2020-05-22 | Stephenson | Illinois | 17177 | 173 | 2 |
170027 | 170027 | 2020-05-23 | Stephenson | Illinois | 17177 | 176 | 2 |
173068 | 173068 | 2020-05-24 | Stephenson | Illinois | 17177 | 187 | 2 |
176112 | 176112 | 2020-05-25 | Stephenson | Illinois | 17177 | 190 | 2 |
179156 | 179156 | 2020-05-26 | Stephenson | Illinois | 17177 | 195 | 2 |
182200 | 182200 | 2020-05-27 | Stephenson | Illinois | 17177 | 194 | 2 |
185254 | 185254 | 2020-05-28 | Stephenson | Illinois | 17177 | 199 | 2 |
188312 | 188312 | 2020-05-29 | Stephenson | Illinois | 17177 | 199 | 2 |
191377 | 191377 | 2020-05-30 | Stephenson | Illinois | 17177 | 201 | 2 |
194444 | 194444 | 2020-05-31 | Stephenson | Illinois | 17177 | 206 | 2 |
197514 | 197514 | 2020-06-01 | Stephenson | Illinois | 17177 | 209 | 2 |
200587 | 200587 | 2020-06-02 | Stephenson | Illinois | 17177 | 211 | 2 |
203663 | 203663 | 2020-06-03 | Stephenson | Illinois | 17177 | 210 | 5 |
206743 | 206743 | 2020-06-04 | Stephenson | Illinois | 17177 | 209 | 5 |
209824 | 209824 | 2020-06-05 | Stephenson | Illinois | 17177 | 211 | 5 |
212909 | 212909 | 2020-06-06 | Stephenson | Illinois | 17177 | 214 | 5 |
215996 | 215996 | 2020-06-07 | Stephenson | Illinois | 17177 | 216 | 5 |
219087 | 219087 | 2020-06-08 | Stephenson | Illinois | 17177 | 219 | 5 |
222182 | 222182 | 2020-06-09 | Stephenson | Illinois | 17177 | 220 | 5 |
225277 | 225277 | 2020-06-10 | Stephenson | Illinois | 17177 | 222 | 5 |
228379 | 228379 | 2020-06-11 | Stephenson | Illinois | 17177 | 223 | 5 |
231482 | 231482 | 2020-06-12 | Stephenson | Illinois | 17177 | 226 | 5 |
234588 | 234588 | 2020-06-13 | Stephenson | Illinois | 17177 | 228 | 5 |
237695 | 237695 | 2020-06-14 | Stephenson | Illinois | 17177 | 231 | 5 |
240803 | 240803 | 2020-06-15 | Stephenson | Illinois | 17177 | 231 | 5 |
243914 | 243914 | 2020-06-16 | Stephenson | Illinois | 17177 | 231 | 5 |
247027 | 247027 | 2020-06-17 | Stephenson | Illinois | 17177 | 233 | 5 |
250139 | 250139 | 2020-06-18 | Stephenson | Illinois | 17177 | 236 | 5 |
253254 | 253254 | 2020-06-19 | Stephenson | Illinois | 17177 | 242 | 5 |
256374 | 256374 | 2020-06-20 | Stephenson | Illinois | 17177 | 249 | 5 |
259500 | 259500 | 2020-06-21 | Stephenson | Illinois | 17177 | 249 | 5 |
262627 | 262627 | 2020-06-22 | Stephenson | Illinois | 17177 | 248 | 5 |
265755 | 265755 | 2020-06-23 | Stephenson | Illinois | 17177 | 255 | 5 |
268885 | 268885 | 2020-06-24 | Stephenson | Illinois | 17177 | 257 | 5 |
272022 | 272022 | 2020-06-25 | Stephenson | Illinois | 17177 | 261 | 5 |
275164 | 275164 | 2020-06-26 | Stephenson | Illinois | 17177 | 265 | 5 |
278312 | 278312 | 2020-06-27 | Stephenson | Illinois | 17177 | 268 | 5 |
281460 | 281460 | 2020-06-28 | Stephenson | Illinois | 17177 | 268 | 5 |
284605 | 284605 | 2020-06-29 | Stephenson | Illinois | 17177 | 268 | 5 |
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);