ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Sangamon" and state = "Illinois" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2046 | 2046 | 2020-03-14 | Sangamon | Illinois | 17167 | 2 | 0 |
2437 | 2437 | 2020-03-15 | Sangamon | Illinois | 17167 | 2 | 0 |
2879 | 2879 | 2020-03-16 | Sangamon | Illinois | 17167 | 3 | 0 |
3368 | 3368 | 2020-03-17 | Sangamon | Illinois | 17167 | 3 | 0 |
3936 | 3936 | 2020-03-18 | Sangamon | Illinois | 17167 | 4 | 0 |
4612 | 4612 | 2020-03-19 | Sangamon | Illinois | 17167 | 4 | 1 |
5418 | 5418 | 2020-03-20 | Sangamon | Illinois | 17167 | 4 | 1 |
6353 | 6353 | 2020-03-21 | Sangamon | Illinois | 17167 | 4 | 1 |
7406 | 7406 | 2020-03-22 | Sangamon | Illinois | 17167 | 4 | 1 |
8562 | 8562 | 2020-03-23 | Sangamon | Illinois | 17167 | 4 | 1 |
9826 | 9826 | 2020-03-24 | Sangamon | Illinois | 17167 | 5 | 1 |
11219 | 11219 | 2020-03-25 | Sangamon | Illinois | 17167 | 5 | 1 |
12775 | 12775 | 2020-03-26 | Sangamon | Illinois | 17167 | 7 | 1 |
14453 | 14453 | 2020-03-27 | Sangamon | Illinois | 17167 | 7 | 1 |
16249 | 16249 | 2020-03-28 | Sangamon | Illinois | 17167 | 8 | 1 |
18151 | 18151 | 2020-03-29 | Sangamon | Illinois | 17167 | 9 | 1 |
20156 | 20156 | 2020-03-30 | Sangamon | Illinois | 17167 | 16 | 2 |
22249 | 22249 | 2020-03-31 | Sangamon | Illinois | 17167 | 16 | 2 |
24418 | 24418 | 2020-04-01 | Sangamon | Illinois | 17167 | 17 | 2 |
26656 | 26656 | 2020-04-02 | Sangamon | Illinois | 17167 | 23 | 2 |
28966 | 28966 | 2020-04-03 | Sangamon | Illinois | 17167 | 23 | 2 |
31332 | 31332 | 2020-04-04 | Sangamon | Illinois | 17167 | 31 | 2 |
33742 | 33742 | 2020-04-05 | Sangamon | Illinois | 17167 | 33 | 2 |
36194 | 36194 | 2020-04-06 | Sangamon | Illinois | 17167 | 35 | 2 |
38691 | 38691 | 2020-04-07 | Sangamon | Illinois | 17167 | 32 | 2 |
41236 | 41236 | 2020-04-08 | Sangamon | Illinois | 17167 | 33 | 2 |
43811 | 43811 | 2020-04-09 | Sangamon | Illinois | 17167 | 39 | 2 |
46415 | 46415 | 2020-04-10 | Sangamon | Illinois | 17167 | 42 | 2 |
49048 | 49048 | 2020-04-11 | Sangamon | Illinois | 17167 | 43 | 3 |
51710 | 51710 | 2020-04-12 | Sangamon | Illinois | 17167 | 43 | 3 |
54391 | 54391 | 2020-04-13 | Sangamon | Illinois | 17167 | 48 | 3 |
57084 | 57084 | 2020-04-14 | Sangamon | Illinois | 17167 | 50 | 3 |
59791 | 59791 | 2020-04-15 | Sangamon | Illinois | 17167 | 50 | 3 |
62512 | 62512 | 2020-04-16 | Sangamon | Illinois | 17167 | 54 | 4 |
65245 | 65245 | 2020-04-17 | Sangamon | Illinois | 17167 | 58 | 4 |
67994 | 67994 | 2020-04-18 | Sangamon | Illinois | 17167 | 61 | 5 |
70756 | 70756 | 2020-04-19 | Sangamon | Illinois | 17167 | 62 | 5 |
73526 | 73526 | 2020-04-20 | Sangamon | Illinois | 17167 | 64 | 5 |
76303 | 76303 | 2020-04-21 | Sangamon | Illinois | 17167 | 68 | 5 |
79087 | 79087 | 2020-04-22 | Sangamon | Illinois | 17167 | 69 | 5 |
81880 | 81880 | 2020-04-23 | Sangamon | Illinois | 17167 | 76 | 5 |
84680 | 84680 | 2020-04-24 | Sangamon | Illinois | 17167 | 81 | 6 |
87490 | 87490 | 2020-04-25 | Sangamon | Illinois | 17167 | 95 | 6 |
90306 | 90306 | 2020-04-26 | Sangamon | Illinois | 17167 | 104 | 6 |
93125 | 93125 | 2020-04-27 | Sangamon | Illinois | 17167 | 113 | 8 |
95957 | 95957 | 2020-04-28 | Sangamon | Illinois | 17167 | 159 | 8 |
98801 | 98801 | 2020-04-29 | Sangamon | Illinois | 17167 | 169 | 9 |
101652 | 101652 | 2020-04-30 | Sangamon | Illinois | 17167 | 178 | 9 |
104508 | 104508 | 2020-05-01 | Sangamon | Illinois | 17167 | 195 | 12 |
107373 | 107373 | 2020-05-02 | Sangamon | Illinois | 17167 | 207 | 12 |
110243 | 110243 | 2020-05-03 | Sangamon | Illinois | 17167 | 208 | 13 |
113118 | 113118 | 2020-05-04 | Sangamon | Illinois | 17167 | 212 | 13 |
116001 | 116001 | 2020-05-05 | Sangamon | Illinois | 17167 | 216 | 14 |
118961 | 118961 | 2020-05-06 | Sangamon | Illinois | 17167 | 231 | 14 |
121931 | 121931 | 2020-05-07 | Sangamon | Illinois | 17167 | 237 | 19 |
124911 | 124911 | 2020-05-08 | Sangamon | Illinois | 17167 | 253 | 19 |
127898 | 127898 | 2020-05-09 | Sangamon | Illinois | 17167 | 256 | 19 |
130889 | 130889 | 2020-05-10 | Sangamon | Illinois | 17167 | 258 | 24 |
133880 | 133880 | 2020-05-11 | Sangamon | Illinois | 17167 | 275 | 25 |
136869 | 136869 | 2020-05-12 | Sangamon | Illinois | 17167 | 286 | 25 |
139861 | 139861 | 2020-05-13 | Sangamon | Illinois | 17167 | 292 | 25 |
142857 | 142857 | 2020-05-14 | Sangamon | Illinois | 17167 | 292 | 25 |
145857 | 145857 | 2020-05-15 | Sangamon | Illinois | 17167 | 300 | 25 |
148861 | 148861 | 2020-05-16 | Sangamon | Illinois | 17167 | 314 | 26 |
151870 | 151870 | 2020-05-17 | Sangamon | Illinois | 17167 | 318 | 27 |
154882 | 154882 | 2020-05-18 | Sangamon | Illinois | 17167 | 319 | 27 |
157898 | 157898 | 2020-05-19 | Sangamon | Illinois | 17167 | 323 | 28 |
160924 | 160924 | 2020-05-20 | Sangamon | Illinois | 17167 | 323 | 28 |
163952 | 163952 | 2020-05-21 | Sangamon | Illinois | 17167 | 324 | 28 |
166985 | 166985 | 2020-05-22 | Sangamon | Illinois | 17167 | 334 | 28 |
170022 | 170022 | 2020-05-23 | Sangamon | Illinois | 17167 | 335 | 28 |
173063 | 173063 | 2020-05-24 | Sangamon | Illinois | 17167 | 336 | 28 |
176107 | 176107 | 2020-05-25 | Sangamon | Illinois | 17167 | 336 | 28 |
179151 | 179151 | 2020-05-26 | Sangamon | Illinois | 17167 | 338 | 29 |
182195 | 182195 | 2020-05-27 | Sangamon | Illinois | 17167 | 343 | 30 |
185249 | 185249 | 2020-05-28 | Sangamon | Illinois | 17167 | 349 | 30 |
188307 | 188307 | 2020-05-29 | Sangamon | Illinois | 17167 | 353 | 31 |
191372 | 191372 | 2020-05-30 | Sangamon | Illinois | 17167 | 354 | 31 |
194439 | 194439 | 2020-05-31 | Sangamon | Illinois | 17167 | 354 | 31 |
197509 | 197509 | 2020-06-01 | Sangamon | Illinois | 17167 | 356 | 31 |
200582 | 200582 | 2020-06-02 | Sangamon | Illinois | 17167 | 357 | 31 |
203658 | 203658 | 2020-06-03 | Sangamon | Illinois | 17167 | 359 | 31 |
206738 | 206738 | 2020-06-04 | Sangamon | Illinois | 17167 | 363 | 31 |
209819 | 209819 | 2020-06-05 | Sangamon | Illinois | 17167 | 365 | 31 |
212904 | 212904 | 2020-06-06 | Sangamon | Illinois | 17167 | 365 | 32 |
215991 | 215991 | 2020-06-07 | Sangamon | Illinois | 17167 | 365 | 32 |
219082 | 219082 | 2020-06-08 | Sangamon | Illinois | 17167 | 367 | 32 |
222177 | 222177 | 2020-06-09 | Sangamon | Illinois | 17167 | 371 | 33 |
225272 | 225272 | 2020-06-10 | Sangamon | Illinois | 17167 | 371 | 33 |
228374 | 228374 | 2020-06-11 | Sangamon | Illinois | 17167 | 377 | 33 |
231477 | 231477 | 2020-06-12 | Sangamon | Illinois | 17167 | 377 | 33 |
234583 | 234583 | 2020-06-13 | Sangamon | Illinois | 17167 | 377 | 33 |
237690 | 237690 | 2020-06-14 | Sangamon | Illinois | 17167 | 378 | 33 |
240798 | 240798 | 2020-06-15 | Sangamon | Illinois | 17167 | 383 | 33 |
243909 | 243909 | 2020-06-16 | Sangamon | Illinois | 17167 | 384 | 33 |
247022 | 247022 | 2020-06-17 | Sangamon | Illinois | 17167 | 386 | 33 |
250134 | 250134 | 2020-06-18 | Sangamon | Illinois | 17167 | 387 | 33 |
253249 | 253249 | 2020-06-19 | Sangamon | Illinois | 17167 | 389 | 33 |
256369 | 256369 | 2020-06-20 | Sangamon | Illinois | 17167 | 389 | 33 |
259495 | 259495 | 2020-06-21 | Sangamon | Illinois | 17167 | 389 | 33 |
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);