ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Clinton", fips = 17027 and state = "Illinois" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2430 | 2430 | 2020-03-15 | Clinton | Illinois | 17027 | 1 | 0 |
2871 | 2871 | 2020-03-16 | Clinton | Illinois | 17027 | 1 | 0 |
3360 | 3360 | 2020-03-17 | Clinton | Illinois | 17027 | 2 | 0 |
3923 | 3923 | 2020-03-18 | Clinton | Illinois | 17027 | 3 | 0 |
4599 | 4599 | 2020-03-19 | Clinton | Illinois | 17027 | 3 | 0 |
5404 | 5404 | 2020-03-20 | Clinton | Illinois | 17027 | 3 | 0 |
6338 | 6338 | 2020-03-21 | Clinton | Illinois | 17027 | 3 | 0 |
7388 | 7388 | 2020-03-22 | Clinton | Illinois | 17027 | 3 | 0 |
8543 | 8543 | 2020-03-23 | Clinton | Illinois | 17027 | 3 | 0 |
9806 | 9806 | 2020-03-24 | Clinton | Illinois | 17027 | 3 | 0 |
11196 | 11196 | 2020-03-25 | Clinton | Illinois | 17027 | 4 | 0 |
12751 | 12751 | 2020-03-26 | Clinton | Illinois | 17027 | 5 | 0 |
14427 | 14427 | 2020-03-27 | Clinton | Illinois | 17027 | 5 | 0 |
16221 | 16221 | 2020-03-28 | Clinton | Illinois | 17027 | 5 | 0 |
18120 | 18120 | 2020-03-29 | Clinton | Illinois | 17027 | 6 | 0 |
20121 | 20121 | 2020-03-30 | Clinton | Illinois | 17027 | 6 | 0 |
22212 | 22212 | 2020-03-31 | Clinton | Illinois | 17027 | 7 | 0 |
24380 | 24380 | 2020-04-01 | Clinton | Illinois | 17027 | 8 | 0 |
26613 | 26613 | 2020-04-02 | Clinton | Illinois | 17027 | 8 | 0 |
28920 | 28920 | 2020-04-03 | Clinton | Illinois | 17027 | 8 | 0 |
31282 | 31282 | 2020-04-04 | Clinton | Illinois | 17027 | 10 | 0 |
33691 | 33691 | 2020-04-05 | Clinton | Illinois | 17027 | 10 | 0 |
36142 | 36142 | 2020-04-06 | Clinton | Illinois | 17027 | 11 | 0 |
38636 | 38636 | 2020-04-07 | Clinton | Illinois | 17027 | 11 | 0 |
41180 | 41180 | 2020-04-08 | Clinton | Illinois | 17027 | 13 | 0 |
43754 | 43754 | 2020-04-09 | Clinton | Illinois | 17027 | 31 | 0 |
46356 | 46356 | 2020-04-10 | Clinton | Illinois | 17027 | 32 | 0 |
48987 | 48987 | 2020-04-11 | Clinton | Illinois | 17027 | 37 | 0 |
51649 | 51649 | 2020-04-12 | Clinton | Illinois | 17027 | 37 | 0 |
54329 | 54329 | 2020-04-13 | Clinton | Illinois | 17027 | 38 | 0 |
57022 | 57022 | 2020-04-14 | Clinton | Illinois | 17027 | 38 | 0 |
59729 | 59729 | 2020-04-15 | Clinton | Illinois | 17027 | 39 | 0 |
62450 | 62450 | 2020-04-16 | Clinton | Illinois | 17027 | 39 | 0 |
65182 | 65182 | 2020-04-17 | Clinton | Illinois | 17027 | 42 | 0 |
67930 | 67930 | 2020-04-18 | Clinton | Illinois | 17027 | 44 | 0 |
70692 | 70692 | 2020-04-19 | Clinton | Illinois | 17027 | 45 | 0 |
73462 | 73462 | 2020-04-20 | Clinton | Illinois | 17027 | 45 | 0 |
76238 | 76238 | 2020-04-21 | Clinton | Illinois | 17027 | 46 | 0 |
79022 | 79022 | 2020-04-22 | Clinton | Illinois | 17027 | 49 | 0 |
81815 | 81815 | 2020-04-23 | Clinton | Illinois | 17027 | 51 | 0 |
84615 | 84615 | 2020-04-24 | Clinton | Illinois | 17027 | 73 | 1 |
87425 | 87425 | 2020-04-25 | Clinton | Illinois | 17027 | 82 | 1 |
90241 | 90241 | 2020-04-26 | Clinton | Illinois | 17027 | 84 | 1 |
93060 | 93060 | 2020-04-27 | Clinton | Illinois | 17027 | 85 | 1 |
95892 | 95892 | 2020-04-28 | Clinton | Illinois | 17027 | 90 | 1 |
98736 | 98736 | 2020-04-29 | Clinton | Illinois | 17027 | 101 | 1 |
101587 | 101587 | 2020-04-30 | Clinton | Illinois | 17027 | 106 | 3 |
104443 | 104443 | 2020-05-01 | Clinton | Illinois | 17027 | 110 | 4 |
107308 | 107308 | 2020-05-02 | Clinton | Illinois | 17027 | 110 | 5 |
110178 | 110178 | 2020-05-03 | Clinton | Illinois | 17027 | 112 | 5 |
113053 | 113053 | 2020-05-04 | Clinton | Illinois | 17027 | 114 | 5 |
115936 | 115936 | 2020-05-05 | Clinton | Illinois | 17027 | 115 | 7 |
118896 | 118896 | 2020-05-06 | Clinton | Illinois | 17027 | 116 | 7 |
121866 | 121866 | 2020-05-07 | Clinton | Illinois | 17027 | 122 | 8 |
124845 | 124845 | 2020-05-08 | Clinton | Illinois | 17027 | 125 | 8 |
127832 | 127832 | 2020-05-09 | Clinton | Illinois | 17027 | 126 | 10 |
130823 | 130823 | 2020-05-10 | Clinton | Illinois | 17027 | 126 | 10 |
133814 | 133814 | 2020-05-11 | Clinton | Illinois | 17027 | 127 | 10 |
136803 | 136803 | 2020-05-12 | Clinton | Illinois | 17027 | 128 | 12 |
139794 | 139794 | 2020-05-13 | Clinton | Illinois | 17027 | 142 | 13 |
142790 | 142790 | 2020-05-14 | Clinton | Illinois | 17027 | 155 | 13 |
145790 | 145790 | 2020-05-15 | Clinton | Illinois | 17027 | 159 | 13 |
148793 | 148793 | 2020-05-16 | Clinton | Illinois | 17027 | 162 | 14 |
151802 | 151802 | 2020-05-17 | Clinton | Illinois | 17027 | 161 | 14 |
154814 | 154814 | 2020-05-18 | Clinton | Illinois | 17027 | 161 | 14 |
157830 | 157830 | 2020-05-19 | Clinton | Illinois | 17027 | 165 | 14 |
160856 | 160856 | 2020-05-20 | Clinton | Illinois | 17027 | 167 | 16 |
163884 | 163884 | 2020-05-21 | Clinton | Illinois | 17027 | 169 | 16 |
166917 | 166917 | 2020-05-22 | Clinton | Illinois | 17027 | 173 | 16 |
169954 | 169954 | 2020-05-23 | Clinton | Illinois | 17027 | 176 | 16 |
172995 | 172995 | 2020-05-24 | Clinton | Illinois | 17027 | 176 | 16 |
176039 | 176039 | 2020-05-25 | Clinton | Illinois | 17027 | 177 | 16 |
179083 | 179083 | 2020-05-26 | Clinton | Illinois | 17027 | 178 | 16 |
182127 | 182127 | 2020-05-27 | Clinton | Illinois | 17027 | 178 | 17 |
185181 | 185181 | 2020-05-28 | Clinton | Illinois | 17027 | 180 | 17 |
188238 | 188238 | 2020-05-29 | Clinton | Illinois | 17027 | 181 | 17 |
191303 | 191303 | 2020-05-30 | Clinton | Illinois | 17027 | 186 | 17 |
194370 | 194370 | 2020-05-31 | Clinton | Illinois | 17027 | 186 | 17 |
197440 | 197440 | 2020-06-01 | Clinton | Illinois | 17027 | 186 | 17 |
200513 | 200513 | 2020-06-02 | Clinton | Illinois | 17027 | 188 | 17 |
203589 | 203589 | 2020-06-03 | Clinton | Illinois | 17027 | 188 | 17 |
206669 | 206669 | 2020-06-04 | Clinton | Illinois | 17027 | 189 | 17 |
209750 | 209750 | 2020-06-05 | Clinton | Illinois | 17027 | 190 | 17 |
212835 | 212835 | 2020-06-06 | Clinton | Illinois | 17027 | 193 | 17 |
215922 | 215922 | 2020-06-07 | Clinton | Illinois | 17027 | 193 | 17 |
219013 | 219013 | 2020-06-08 | Clinton | Illinois | 17027 | 193 | 17 |
222108 | 222108 | 2020-06-09 | Clinton | Illinois | 17027 | 196 | 17 |
225203 | 225203 | 2020-06-10 | Clinton | Illinois | 17027 | 197 | 17 |
228305 | 228305 | 2020-06-11 | Clinton | Illinois | 17027 | 198 | 17 |
231408 | 231408 | 2020-06-12 | Clinton | Illinois | 17027 | 203 | 17 |
234514 | 234514 | 2020-06-13 | Clinton | Illinois | 17027 | 207 | 17 |
237621 | 237621 | 2020-06-14 | Clinton | Illinois | 17027 | 209 | 17 |
240729 | 240729 | 2020-06-15 | Clinton | Illinois | 17027 | 213 | 17 |
243840 | 243840 | 2020-06-16 | Clinton | Illinois | 17027 | 214 | 17 |
246953 | 246953 | 2020-06-17 | Clinton | Illinois | 17027 | 216 | 17 |
250065 | 250065 | 2020-06-18 | Clinton | Illinois | 17027 | 220 | 17 |
253180 | 253180 | 2020-06-19 | Clinton | Illinois | 17027 | 220 | 17 |
256300 | 256300 | 2020-06-20 | Clinton | Illinois | 17027 | 223 | 17 |
259426 | 259426 | 2020-06-21 | Clinton | Illinois | 17027 | 224 | 17 |
262553 | 262553 | 2020-06-22 | Clinton | Illinois | 17027 | 224 | 17 |
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);