ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Madison" and fips = 17119 sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3933 | 3933 | 2020-03-18 | Madison | Illinois | 17119 | 1 | 0 |
4609 | 4609 | 2020-03-19 | Madison | Illinois | 17119 | 1 | 0 |
5414 | 5414 | 2020-03-20 | Madison | Illinois | 17119 | 1 | 0 |
6349 | 6349 | 2020-03-21 | Madison | Illinois | 17119 | 2 | 0 |
7401 | 7401 | 2020-03-22 | Madison | Illinois | 17119 | 2 | 0 |
8556 | 8556 | 2020-03-23 | Madison | Illinois | 17119 | 3 | 0 |
9820 | 9820 | 2020-03-24 | Madison | Illinois | 17119 | 3 | 0 |
11211 | 11211 | 2020-03-25 | Madison | Illinois | 17119 | 3 | 0 |
12767 | 12767 | 2020-03-26 | Madison | Illinois | 17119 | 6 | 0 |
14445 | 14445 | 2020-03-27 | Madison | Illinois | 17119 | 8 | 0 |
16241 | 16241 | 2020-03-28 | Madison | Illinois | 17119 | 10 | 0 |
18141 | 18141 | 2020-03-29 | Madison | Illinois | 17119 | 12 | 0 |
20143 | 20143 | 2020-03-30 | Madison | Illinois | 17119 | 13 | 0 |
22235 | 22235 | 2020-03-31 | Madison | Illinois | 17119 | 16 | 0 |
24403 | 24403 | 2020-04-01 | Madison | Illinois | 17119 | 25 | 0 |
26638 | 26638 | 2020-04-02 | Madison | Illinois | 17119 | 29 | 0 |
28948 | 28948 | 2020-04-03 | Madison | Illinois | 17119 | 31 | 0 |
31312 | 31312 | 2020-04-04 | Madison | Illinois | 17119 | 47 | 0 |
33722 | 33722 | 2020-04-05 | Madison | Illinois | 17119 | 48 | 0 |
36174 | 36174 | 2020-04-06 | Madison | Illinois | 17119 | 52 | 0 |
38670 | 38670 | 2020-04-07 | Madison | Illinois | 17119 | 63 | 1 |
41215 | 41215 | 2020-04-08 | Madison | Illinois | 17119 | 82 | 2 |
43789 | 43789 | 2020-04-09 | Madison | Illinois | 17119 | 89 | 2 |
46393 | 46393 | 2020-04-10 | Madison | Illinois | 17119 | 101 | 2 |
49024 | 49024 | 2020-04-11 | Madison | Illinois | 17119 | 103 | 2 |
51686 | 51686 | 2020-04-12 | Madison | Illinois | 17119 | 110 | 2 |
54367 | 54367 | 2020-04-13 | Madison | Illinois | 17119 | 115 | 2 |
57060 | 57060 | 2020-04-14 | Madison | Illinois | 17119 | 128 | 2 |
59767 | 59767 | 2020-04-15 | Madison | Illinois | 17119 | 135 | 2 |
62488 | 62488 | 2020-04-16 | Madison | Illinois | 17119 | 151 | 3 |
65221 | 65221 | 2020-04-17 | Madison | Illinois | 17119 | 157 | 5 |
67970 | 67970 | 2020-04-18 | Madison | Illinois | 17119 | 169 | 5 |
70732 | 70732 | 2020-04-19 | Madison | Illinois | 17119 | 180 | 8 |
73502 | 73502 | 2020-04-20 | Madison | Illinois | 17119 | 184 | 8 |
76279 | 76279 | 2020-04-21 | Madison | Illinois | 17119 | 190 | 10 |
79063 | 79063 | 2020-04-22 | Madison | Illinois | 17119 | 226 | 13 |
81856 | 81856 | 2020-04-23 | Madison | Illinois | 17119 | 235 | 13 |
84656 | 84656 | 2020-04-24 | Madison | Illinois | 17119 | 268 | 15 |
87466 | 87466 | 2020-04-25 | Madison | Illinois | 17119 | 280 | 16 |
90282 | 90282 | 2020-04-26 | Madison | Illinois | 17119 | 305 | 16 |
93101 | 93101 | 2020-04-27 | Madison | Illinois | 17119 | 306 | 17 |
95933 | 95933 | 2020-04-28 | Madison | Illinois | 17119 | 318 | 18 |
98777 | 98777 | 2020-04-29 | Madison | Illinois | 17119 | 324 | 19 |
101628 | 101628 | 2020-04-30 | Madison | Illinois | 17119 | 333 | 21 |
104484 | 104484 | 2020-05-01 | Madison | Illinois | 17119 | 335 | 22 |
107349 | 107349 | 2020-05-02 | Madison | Illinois | 17119 | 337 | 22 |
110219 | 110219 | 2020-05-03 | Madison | Illinois | 17119 | 365 | 24 |
113094 | 113094 | 2020-05-04 | Madison | Illinois | 17119 | 365 | 26 |
115977 | 115977 | 2020-05-05 | Madison | Illinois | 17119 | 369 | 27 |
118937 | 118937 | 2020-05-06 | Madison | Illinois | 17119 | 374 | 28 |
121907 | 121907 | 2020-05-07 | Madison | Illinois | 17119 | 396 | 28 |
124886 | 124886 | 2020-05-08 | Madison | Illinois | 17119 | 401 | 30 |
127873 | 127873 | 2020-05-09 | Madison | Illinois | 17119 | 414 | 31 |
130864 | 130864 | 2020-05-10 | Madison | Illinois | 17119 | 427 | 31 |
133855 | 133855 | 2020-05-11 | Madison | Illinois | 17119 | 435 | 31 |
136844 | 136844 | 2020-05-12 | Madison | Illinois | 17119 | 445 | 32 |
139836 | 139836 | 2020-05-13 | Madison | Illinois | 17119 | 449 | 35 |
142832 | 142832 | 2020-05-14 | Madison | Illinois | 17119 | 461 | 35 |
145832 | 145832 | 2020-05-15 | Madison | Illinois | 17119 | 464 | 38 |
148835 | 148835 | 2020-05-16 | Madison | Illinois | 17119 | 481 | 39 |
151844 | 151844 | 2020-05-17 | Madison | Illinois | 17119 | 490 | 42 |
154856 | 154856 | 2020-05-18 | Madison | Illinois | 17119 | 493 | 42 |
157872 | 157872 | 2020-05-19 | Madison | Illinois | 17119 | 499 | 45 |
160898 | 160898 | 2020-05-20 | Madison | Illinois | 17119 | 502 | 46 |
163926 | 163926 | 2020-05-21 | Madison | Illinois | 17119 | 506 | 48 |
166959 | 166959 | 2020-05-22 | Madison | Illinois | 17119 | 516 | 49 |
169996 | 169996 | 2020-05-23 | Madison | Illinois | 17119 | 528 | 53 |
173037 | 173037 | 2020-05-24 | Madison | Illinois | 17119 | 535 | 54 |
176081 | 176081 | 2020-05-25 | Madison | Illinois | 17119 | 539 | 57 |
179125 | 179125 | 2020-05-26 | Madison | Illinois | 17119 | 545 | 57 |
182169 | 182169 | 2020-05-27 | Madison | Illinois | 17119 | 551 | 58 |
185223 | 185223 | 2020-05-28 | Madison | Illinois | 17119 | 558 | 58 |
188281 | 188281 | 2020-05-29 | Madison | Illinois | 17119 | 569 | 58 |
191346 | 191346 | 2020-05-30 | Madison | Illinois | 17119 | 578 | 60 |
194413 | 194413 | 2020-05-31 | Madison | Illinois | 17119 | 582 | 60 |
197483 | 197483 | 2020-06-01 | Madison | Illinois | 17119 | 597 | 62 |
200556 | 200556 | 2020-06-02 | Madison | Illinois | 17119 | 600 | 62 |
203632 | 203632 | 2020-06-03 | Madison | Illinois | 17119 | 608 | 65 |
206712 | 206712 | 2020-06-04 | Madison | Illinois | 17119 | 615 | 65 |
209793 | 209793 | 2020-06-05 | Madison | Illinois | 17119 | 629 | 65 |
212878 | 212878 | 2020-06-06 | Madison | Illinois | 17119 | 636 | 65 |
215965 | 215965 | 2020-06-07 | Madison | Illinois | 17119 | 640 | 65 |
219056 | 219056 | 2020-06-08 | Madison | Illinois | 17119 | 644 | 65 |
222151 | 222151 | 2020-06-09 | Madison | Illinois | 17119 | 652 | 65 |
225246 | 225246 | 2020-06-10 | Madison | Illinois | 17119 | 665 | 65 |
228348 | 228348 | 2020-06-11 | Madison | Illinois | 17119 | 682 | 65 |
231451 | 231451 | 2020-06-12 | Madison | Illinois | 17119 | 686 | 65 |
234557 | 234557 | 2020-06-13 | Madison | Illinois | 17119 | 707 | 65 |
237664 | 237664 | 2020-06-14 | Madison | Illinois | 17119 | 720 | 65 |
240772 | 240772 | 2020-06-15 | Madison | Illinois | 17119 | 733 | 66 |
243883 | 243883 | 2020-06-16 | Madison | Illinois | 17119 | 740 | 66 |
246996 | 246996 | 2020-06-17 | Madison | Illinois | 17119 | 752 | 66 |
250108 | 250108 | 2020-06-18 | Madison | Illinois | 17119 | 771 | 66 |
253223 | 253223 | 2020-06-19 | Madison | Illinois | 17119 | 790 | 66 |
256343 | 256343 | 2020-06-20 | Madison | Illinois | 17119 | 802 | 66 |
259469 | 259469 | 2020-06-21 | Madison | Illinois | 17119 | 813 | 66 |
262596 | 262596 | 2020-06-22 | Madison | Illinois | 17119 | 816 | 67 |
265724 | 265724 | 2020-06-23 | Madison | Illinois | 17119 | 829 | 67 |
268854 | 268854 | 2020-06-24 | Madison | Illinois | 17119 | 852 | 68 |
271991 | 271991 | 2020-06-25 | Madison | Illinois | 17119 | 877 | 68 |
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);