ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
6,932 rows where county = "Knox" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 9
county 1
- Knox · 6,932 ✖
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
18136 | 18136 | 2020-03-29 | Knox | Illinois | 17095 | 1 | 0 |
20138 | 20138 | 2020-03-30 | Knox | Illinois | 17095 | 1 | 0 |
22230 | 22230 | 2020-03-31 | Knox | Illinois | 17095 | 1 | 0 |
24398 | 24398 | 2020-04-01 | Knox | Illinois | 17095 | 1 | 0 |
26631 | 26631 | 2020-04-02 | Knox | Illinois | 17095 | 1 | 0 |
28941 | 28941 | 2020-04-03 | Knox | Illinois | 17095 | 1 | 0 |
31304 | 31304 | 2020-04-04 | Knox | Illinois | 17095 | 1 | 0 |
33714 | 33714 | 2020-04-05 | Knox | Illinois | 17095 | 1 | 0 |
36166 | 36166 | 2020-04-06 | Knox | Illinois | 17095 | 1 | 0 |
38661 | 38661 | 2020-04-07 | Knox | Illinois | 17095 | 1 | 0 |
41206 | 41206 | 2020-04-08 | Knox | Illinois | 17095 | 1 | 0 |
43780 | 43780 | 2020-04-09 | Knox | Illinois | 17095 | 1 | 0 |
46384 | 46384 | 2020-04-10 | Knox | Illinois | 17095 | 1 | 0 |
49015 | 49015 | 2020-04-11 | Knox | Illinois | 17095 | 2 | 0 |
51677 | 51677 | 2020-04-12 | Knox | Illinois | 17095 | 2 | 0 |
54358 | 54358 | 2020-04-13 | Knox | Illinois | 17095 | 2 | 0 |
57051 | 57051 | 2020-04-14 | Knox | Illinois | 17095 | 2 | 0 |
59758 | 59758 | 2020-04-15 | Knox | Illinois | 17095 | 2 | 0 |
62479 | 62479 | 2020-04-16 | Knox | Illinois | 17095 | 2 | 0 |
65212 | 65212 | 2020-04-17 | Knox | Illinois | 17095 | 3 | 0 |
67961 | 67961 | 2020-04-18 | Knox | Illinois | 17095 | 5 | 0 |
70723 | 70723 | 2020-04-19 | Knox | Illinois | 17095 | 9 | 0 |
73493 | 73493 | 2020-04-20 | Knox | Illinois | 17095 | 10 | 0 |
76270 | 76270 | 2020-04-21 | Knox | Illinois | 17095 | 11 | 0 |
79054 | 79054 | 2020-04-22 | Knox | Illinois | 17095 | 16 | 0 |
81847 | 81847 | 2020-04-23 | Knox | Illinois | 17095 | 19 | 0 |
84647 | 84647 | 2020-04-24 | Knox | Illinois | 17095 | 24 | 0 |
87457 | 87457 | 2020-04-25 | Knox | Illinois | 17095 | 31 | 0 |
90273 | 90273 | 2020-04-26 | Knox | Illinois | 17095 | 36 | 0 |
93092 | 93092 | 2020-04-27 | Knox | Illinois | 17095 | 36 | 0 |
95924 | 95924 | 2020-04-28 | Knox | Illinois | 17095 | 36 | 0 |
98768 | 98768 | 2020-04-29 | Knox | Illinois | 17095 | 41 | 0 |
101619 | 101619 | 2020-04-30 | Knox | Illinois | 17095 | 46 | 0 |
104475 | 104475 | 2020-05-01 | Knox | Illinois | 17095 | 47 | 0 |
107340 | 107340 | 2020-05-02 | Knox | Illinois | 17095 | 51 | 0 |
110210 | 110210 | 2020-05-03 | Knox | Illinois | 17095 | 51 | 0 |
113085 | 113085 | 2020-05-04 | Knox | Illinois | 17095 | 56 | 0 |
115968 | 115968 | 2020-05-05 | Knox | Illinois | 17095 | 56 | 0 |
118928 | 118928 | 2020-05-06 | Knox | Illinois | 17095 | 61 | 0 |
121898 | 121898 | 2020-05-07 | Knox | Illinois | 17095 | 63 | 0 |
124877 | 124877 | 2020-05-08 | Knox | Illinois | 17095 | 69 | 0 |
127864 | 127864 | 2020-05-09 | Knox | Illinois | 17095 | 71 | 0 |
130855 | 130855 | 2020-05-10 | Knox | Illinois | 17095 | 73 | 0 |
133846 | 133846 | 2020-05-11 | Knox | Illinois | 17095 | 75 | 0 |
136835 | 136835 | 2020-05-12 | Knox | Illinois | 17095 | 77 | 0 |
139827 | 139827 | 2020-05-13 | Knox | Illinois | 17095 | 79 | 0 |
142823 | 142823 | 2020-05-14 | Knox | Illinois | 17095 | 79 | 0 |
145823 | 145823 | 2020-05-15 | Knox | Illinois | 17095 | 84 | 0 |
148826 | 148826 | 2020-05-16 | Knox | Illinois | 17095 | 86 | 0 |
151835 | 151835 | 2020-05-17 | Knox | Illinois | 17095 | 87 | 0 |
154847 | 154847 | 2020-05-18 | Knox | Illinois | 17095 | 89 | 0 |
157863 | 157863 | 2020-05-19 | Knox | Illinois | 17095 | 89 | 0 |
160889 | 160889 | 2020-05-20 | Knox | Illinois | 17095 | 90 | 0 |
163917 | 163917 | 2020-05-21 | Knox | Illinois | 17095 | 90 | 0 |
166950 | 166950 | 2020-05-22 | Knox | Illinois | 17095 | 93 | 0 |
169987 | 169987 | 2020-05-23 | Knox | Illinois | 17095 | 94 | 0 |
173028 | 173028 | 2020-05-24 | Knox | Illinois | 17095 | 94 | 0 |
176072 | 176072 | 2020-05-25 | Knox | Illinois | 17095 | 94 | 0 |
179116 | 179116 | 2020-05-26 | Knox | Illinois | 17095 | 95 | 0 |
182160 | 182160 | 2020-05-27 | Knox | Illinois | 17095 | 94 | 0 |
185214 | 185214 | 2020-05-28 | Knox | Illinois | 17095 | 96 | 0 |
188272 | 188272 | 2020-05-29 | Knox | Illinois | 17095 | 97 | 0 |
191337 | 191337 | 2020-05-30 | Knox | Illinois | 17095 | 98 | 0 |
194404 | 194404 | 2020-05-31 | Knox | Illinois | 17095 | 100 | 0 |
197474 | 197474 | 2020-06-01 | Knox | Illinois | 17095 | 101 | 0 |
200547 | 200547 | 2020-06-02 | Knox | Illinois | 17095 | 101 | 0 |
203623 | 203623 | 2020-06-03 | Knox | Illinois | 17095 | 101 | 0 |
206703 | 206703 | 2020-06-04 | Knox | Illinois | 17095 | 102 | 0 |
209784 | 209784 | 2020-06-05 | Knox | Illinois | 17095 | 102 | 0 |
212869 | 212869 | 2020-06-06 | Knox | Illinois | 17095 | 103 | 0 |
215956 | 215956 | 2020-06-07 | Knox | Illinois | 17095 | 104 | 0 |
219047 | 219047 | 2020-06-08 | Knox | Illinois | 17095 | 105 | 0 |
222142 | 222142 | 2020-06-09 | Knox | Illinois | 17095 | 105 | 0 |
225237 | 225237 | 2020-06-10 | Knox | Illinois | 17095 | 106 | 0 |
228339 | 228339 | 2020-06-11 | Knox | Illinois | 17095 | 107 | 0 |
231442 | 231442 | 2020-06-12 | Knox | Illinois | 17095 | 111 | 0 |
234548 | 234548 | 2020-06-13 | Knox | Illinois | 17095 | 111 | 0 |
237655 | 237655 | 2020-06-14 | Knox | Illinois | 17095 | 113 | 0 |
240763 | 240763 | 2020-06-15 | Knox | Illinois | 17095 | 113 | 0 |
243874 | 243874 | 2020-06-16 | Knox | Illinois | 17095 | 113 | 0 |
246987 | 246987 | 2020-06-17 | Knox | Illinois | 17095 | 113 | 0 |
250099 | 250099 | 2020-06-18 | Knox | Illinois | 17095 | 115 | 0 |
253214 | 253214 | 2020-06-19 | Knox | Illinois | 17095 | 115 | 0 |
256334 | 256334 | 2020-06-20 | Knox | Illinois | 17095 | 117 | 0 |
259460 | 259460 | 2020-06-21 | Knox | Illinois | 17095 | 117 | 0 |
262587 | 262587 | 2020-06-22 | Knox | Illinois | 17095 | 117 | 0 |
265715 | 265715 | 2020-06-23 | Knox | Illinois | 17095 | 117 | 0 |
268845 | 268845 | 2020-06-24 | Knox | Illinois | 17095 | 119 | 0 |
271982 | 271982 | 2020-06-25 | Knox | Illinois | 17095 | 121 | 0 |
275124 | 275124 | 2020-06-26 | Knox | Illinois | 17095 | 123 | 0 |
278272 | 278272 | 2020-06-27 | Knox | Illinois | 17095 | 124 | 0 |
281420 | 281420 | 2020-06-28 | Knox | Illinois | 17095 | 124 | 0 |
284565 | 284565 | 2020-06-29 | Knox | Illinois | 17095 | 125 | 0 |
287714 | 287714 | 2020-06-30 | Knox | Illinois | 17095 | 130 | 0 |
290864 | 290864 | 2020-07-01 | Knox | Illinois | 17095 | 132 | 0 |
294018 | 294018 | 2020-07-02 | Knox | Illinois | 17095 | 134 | 0 |
297175 | 297175 | 2020-07-03 | Knox | Illinois | 17095 | 136 | 0 |
300337 | 300337 | 2020-07-04 | Knox | Illinois | 17095 | 137 | 0 |
303501 | 303501 | 2020-07-05 | Knox | Illinois | 17095 | 140 | 0 |
306666 | 306666 | 2020-07-06 | Knox | Illinois | 17095 | 147 | 0 |
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);