ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
763 rows where county = "Perry" and state = "Illinois" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
49040 | 49040 | 2020-04-11 | Perry | Illinois | 17145 | 1 | 0 |
51702 | 51702 | 2020-04-12 | Perry | Illinois | 17145 | 1 | 0 |
54383 | 54383 | 2020-04-13 | Perry | Illinois | 17145 | 1 | 0 |
57076 | 57076 | 2020-04-14 | Perry | Illinois | 17145 | 1 | 0 |
59783 | 59783 | 2020-04-15 | Perry | Illinois | 17145 | 1 | 0 |
62504 | 62504 | 2020-04-16 | Perry | Illinois | 17145 | 1 | 0 |
65237 | 65237 | 2020-04-17 | Perry | Illinois | 17145 | 1 | 0 |
67986 | 67986 | 2020-04-18 | Perry | Illinois | 17145 | 1 | 0 |
70748 | 70748 | 2020-04-19 | Perry | Illinois | 17145 | 1 | 0 |
73518 | 73518 | 2020-04-20 | Perry | Illinois | 17145 | 1 | 0 |
76295 | 76295 | 2020-04-21 | Perry | Illinois | 17145 | 1 | 0 |
79079 | 79079 | 2020-04-22 | Perry | Illinois | 17145 | 2 | 0 |
81872 | 81872 | 2020-04-23 | Perry | Illinois | 17145 | 3 | 0 |
84672 | 84672 | 2020-04-24 | Perry | Illinois | 17145 | 3 | 0 |
87482 | 87482 | 2020-04-25 | Perry | Illinois | 17145 | 7 | 0 |
90298 | 90298 | 2020-04-26 | Perry | Illinois | 17145 | 8 | 0 |
93117 | 93117 | 2020-04-27 | Perry | Illinois | 17145 | 9 | 0 |
95949 | 95949 | 2020-04-28 | Perry | Illinois | 17145 | 13 | 0 |
98793 | 98793 | 2020-04-29 | Perry | Illinois | 17145 | 18 | 0 |
101644 | 101644 | 2020-04-30 | Perry | Illinois | 17145 | 21 | 0 |
104500 | 104500 | 2020-05-01 | Perry | Illinois | 17145 | 24 | 0 |
107365 | 107365 | 2020-05-02 | Perry | Illinois | 17145 | 31 | 0 |
110235 | 110235 | 2020-05-03 | Perry | Illinois | 17145 | 34 | 0 |
113110 | 113110 | 2020-05-04 | Perry | Illinois | 17145 | 34 | 0 |
115993 | 115993 | 2020-05-05 | Perry | Illinois | 17145 | 32 | 0 |
118953 | 118953 | 2020-05-06 | Perry | Illinois | 17145 | 35 | 0 |
121923 | 121923 | 2020-05-07 | Perry | Illinois | 17145 | 36 | 0 |
124902 | 124902 | 2020-05-08 | Perry | Illinois | 17145 | 36 | 0 |
127889 | 127889 | 2020-05-09 | Perry | Illinois | 17145 | 36 | 0 |
130880 | 130880 | 2020-05-10 | Perry | Illinois | 17145 | 38 | 0 |
133871 | 133871 | 2020-05-11 | Perry | Illinois | 17145 | 38 | 0 |
136860 | 136860 | 2020-05-12 | Perry | Illinois | 17145 | 38 | 0 |
139852 | 139852 | 2020-05-13 | Perry | Illinois | 17145 | 38 | 0 |
142848 | 142848 | 2020-05-14 | Perry | Illinois | 17145 | 38 | 0 |
145848 | 145848 | 2020-05-15 | Perry | Illinois | 17145 | 38 | 0 |
148851 | 148851 | 2020-05-16 | Perry | Illinois | 17145 | 38 | 0 |
151860 | 151860 | 2020-05-17 | Perry | Illinois | 17145 | 39 | 0 |
154872 | 154872 | 2020-05-18 | Perry | Illinois | 17145 | 39 | 0 |
157888 | 157888 | 2020-05-19 | Perry | Illinois | 17145 | 40 | 0 |
160914 | 160914 | 2020-05-20 | Perry | Illinois | 17145 | 40 | 0 |
163942 | 163942 | 2020-05-21 | Perry | Illinois | 17145 | 40 | 0 |
166975 | 166975 | 2020-05-22 | Perry | Illinois | 17145 | 40 | 0 |
170012 | 170012 | 2020-05-23 | Perry | Illinois | 17145 | 40 | 0 |
173053 | 173053 | 2020-05-24 | Perry | Illinois | 17145 | 41 | 0 |
176097 | 176097 | 2020-05-25 | Perry | Illinois | 17145 | 41 | 0 |
179141 | 179141 | 2020-05-26 | Perry | Illinois | 17145 | 41 | 0 |
182185 | 182185 | 2020-05-27 | Perry | Illinois | 17145 | 41 | 0 |
185239 | 185239 | 2020-05-28 | Perry | Illinois | 17145 | 41 | 0 |
188297 | 188297 | 2020-05-29 | Perry | Illinois | 17145 | 42 | 0 |
191362 | 191362 | 2020-05-30 | Perry | Illinois | 17145 | 42 | 0 |
194429 | 194429 | 2020-05-31 | Perry | Illinois | 17145 | 41 | 0 |
197499 | 197499 | 2020-06-01 | Perry | Illinois | 17145 | 41 | 0 |
200572 | 200572 | 2020-06-02 | Perry | Illinois | 17145 | 41 | 0 |
203648 | 203648 | 2020-06-03 | Perry | Illinois | 17145 | 42 | 0 |
206728 | 206728 | 2020-06-04 | Perry | Illinois | 17145 | 42 | 0 |
209809 | 209809 | 2020-06-05 | Perry | Illinois | 17145 | 42 | 0 |
212894 | 212894 | 2020-06-06 | Perry | Illinois | 17145 | 42 | 0 |
215981 | 215981 | 2020-06-07 | Perry | Illinois | 17145 | 42 | 0 |
219072 | 219072 | 2020-06-08 | Perry | Illinois | 17145 | 42 | 0 |
222167 | 222167 | 2020-06-09 | Perry | Illinois | 17145 | 42 | 0 |
225262 | 225262 | 2020-06-10 | Perry | Illinois | 17145 | 43 | 0 |
228364 | 228364 | 2020-06-11 | Perry | Illinois | 17145 | 43 | 0 |
231467 | 231467 | 2020-06-12 | Perry | Illinois | 17145 | 43 | 0 |
234573 | 234573 | 2020-06-13 | Perry | Illinois | 17145 | 43 | 0 |
237680 | 237680 | 2020-06-14 | Perry | Illinois | 17145 | 44 | 0 |
240788 | 240788 | 2020-06-15 | Perry | Illinois | 17145 | 44 | 0 |
243899 | 243899 | 2020-06-16 | Perry | Illinois | 17145 | 44 | 0 |
247012 | 247012 | 2020-06-17 | Perry | Illinois | 17145 | 44 | 0 |
250124 | 250124 | 2020-06-18 | Perry | Illinois | 17145 | 44 | 0 |
253239 | 253239 | 2020-06-19 | Perry | Illinois | 17145 | 44 | 0 |
256359 | 256359 | 2020-06-20 | Perry | Illinois | 17145 | 44 | 0 |
259485 | 259485 | 2020-06-21 | Perry | Illinois | 17145 | 44 | 0 |
262612 | 262612 | 2020-06-22 | Perry | Illinois | 17145 | 44 | 0 |
265740 | 265740 | 2020-06-23 | Perry | Illinois | 17145 | 44 | 0 |
268870 | 268870 | 2020-06-24 | Perry | Illinois | 17145 | 46 | 0 |
272007 | 272007 | 2020-06-25 | Perry | Illinois | 17145 | 46 | 0 |
275149 | 275149 | 2020-06-26 | Perry | Illinois | 17145 | 47 | 0 |
278297 | 278297 | 2020-06-27 | Perry | Illinois | 17145 | 49 | 0 |
281445 | 281445 | 2020-06-28 | Perry | Illinois | 17145 | 49 | 0 |
284590 | 284590 | 2020-06-29 | Perry | Illinois | 17145 | 50 | 1 |
287739 | 287739 | 2020-06-30 | Perry | Illinois | 17145 | 51 | 1 |
290889 | 290889 | 2020-07-01 | Perry | Illinois | 17145 | 54 | 1 |
294043 | 294043 | 2020-07-02 | Perry | Illinois | 17145 | 54 | 1 |
297200 | 297200 | 2020-07-03 | Perry | Illinois | 17145 | 56 | 1 |
300362 | 300362 | 2020-07-04 | Perry | Illinois | 17145 | 56 | 1 |
303526 | 303526 | 2020-07-05 | Perry | Illinois | 17145 | 57 | 1 |
306691 | 306691 | 2020-07-06 | Perry | Illinois | 17145 | 58 | 1 |
309859 | 309859 | 2020-07-07 | Perry | Illinois | 17145 | 58 | 1 |
313029 | 313029 | 2020-07-08 | Perry | Illinois | 17145 | 59 | 1 |
316203 | 316203 | 2020-07-09 | Perry | Illinois | 17145 | 60 | 1 |
319376 | 319376 | 2020-07-10 | Perry | Illinois | 17145 | 61 | 1 |
322555 | 322555 | 2020-07-11 | Perry | Illinois | 17145 | 61 | 1 |
325736 | 325736 | 2020-07-12 | Perry | Illinois | 17145 | 61 | 1 |
328922 | 328922 | 2020-07-13 | Perry | Illinois | 17145 | 61 | 1 |
332109 | 332109 | 2020-07-14 | Perry | Illinois | 17145 | 61 | 1 |
335302 | 335302 | 2020-07-15 | Perry | Illinois | 17145 | 63 | 1 |
338498 | 338498 | 2020-07-16 | Perry | Illinois | 17145 | 63 | 1 |
341694 | 341694 | 2020-07-17 | Perry | Illinois | 17145 | 63 | 1 |
344894 | 344894 | 2020-07-18 | Perry | Illinois | 17145 | 67 | 1 |
348095 | 348095 | 2020-07-19 | Perry | Illinois | 17145 | 67 | 1 |
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);