ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Jackson" and fips = 20085 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386872 | 386872 | 2020-07-31 | Jackson | Kansas | 20085 | 144 | 1 |
383654 | 383654 | 2020-07-30 | Jackson | Kansas | 20085 | 142 | 1 |
380437 | 380437 | 2020-07-29 | Jackson | Kansas | 20085 | 138 | 1 |
377220 | 377220 | 2020-07-28 | Jackson | Kansas | 20085 | 136 | 1 |
374005 | 374005 | 2020-07-27 | Jackson | Kansas | 20085 | 136 | 1 |
370793 | 370793 | 2020-07-26 | Jackson | Kansas | 20085 | 131 | 1 |
367583 | 367583 | 2020-07-25 | Jackson | Kansas | 20085 | 131 | 1 |
364376 | 364376 | 2020-07-24 | Jackson | Kansas | 20085 | 131 | 1 |
361169 | 361169 | 2020-07-23 | Jackson | Kansas | 20085 | 131 | 1 |
357964 | 357964 | 2020-07-22 | Jackson | Kansas | 20085 | 131 | 1 |
354762 | 354762 | 2020-07-21 | Jackson | Kansas | 20085 | 130 | 1 |
351560 | 351560 | 2020-07-20 | Jackson | Kansas | 20085 | 130 | 1 |
348360 | 348360 | 2020-07-19 | Jackson | Kansas | 20085 | 126 | 1 |
345159 | 345159 | 2020-07-18 | Jackson | Kansas | 20085 | 126 | 1 |
341959 | 341959 | 2020-07-17 | Jackson | Kansas | 20085 | 126 | 1 |
338763 | 338763 | 2020-07-16 | Jackson | Kansas | 20085 | 126 | 1 |
335567 | 335567 | 2020-07-15 | Jackson | Kansas | 20085 | 124 | 1 |
332374 | 332374 | 2020-07-14 | Jackson | Kansas | 20085 | 124 | 1 |
329187 | 329187 | 2020-07-13 | Jackson | Kansas | 20085 | 123 | 1 |
326001 | 326001 | 2020-07-12 | Jackson | Kansas | 20085 | 117 | 1 |
322818 | 322818 | 2020-07-11 | Jackson | Kansas | 20085 | 117 | 1 |
319639 | 319639 | 2020-07-10 | Jackson | Kansas | 20085 | 117 | 1 |
316466 | 316466 | 2020-07-09 | Jackson | Kansas | 20085 | 117 | 1 |
313292 | 313292 | 2020-07-08 | Jackson | Kansas | 20085 | 117 | 1 |
310122 | 310122 | 2020-07-07 | Jackson | Kansas | 20085 | 117 | 1 |
306954 | 306954 | 2020-07-06 | Jackson | Kansas | 20085 | 116 | 1 |
303788 | 303788 | 2020-07-05 | Jackson | Kansas | 20085 | 115 | 1 |
300624 | 300624 | 2020-07-04 | Jackson | Kansas | 20085 | 115 | 1 |
297462 | 297462 | 2020-07-03 | Jackson | Kansas | 20085 | 115 | 1 |
294304 | 294304 | 2020-07-02 | Jackson | Kansas | 20085 | 113 | 1 |
291150 | 291150 | 2020-07-01 | Jackson | Kansas | 20085 | 113 | 1 |
288000 | 288000 | 2020-06-30 | Jackson | Kansas | 20085 | 112 | 1 |
284851 | 284851 | 2020-06-29 | Jackson | Kansas | 20085 | 109 | 1 |
281706 | 281706 | 2020-06-28 | Jackson | Kansas | 20085 | 108 | 1 |
278558 | 278558 | 2020-06-27 | Jackson | Kansas | 20085 | 107 | 1 |
275410 | 275410 | 2020-06-26 | Jackson | Kansas | 20085 | 107 | 1 |
272267 | 272267 | 2020-06-25 | Jackson | Kansas | 20085 | 105 | 1 |
269130 | 269130 | 2020-06-24 | Jackson | Kansas | 20085 | 105 | 1 |
266000 | 266000 | 2020-06-23 | Jackson | Kansas | 20085 | 105 | 1 |
262872 | 262872 | 2020-06-22 | Jackson | Kansas | 20085 | 104 | 1 |
259745 | 259745 | 2020-06-21 | Jackson | Kansas | 20085 | 104 | 1 |
256619 | 256619 | 2020-06-20 | Jackson | Kansas | 20085 | 104 | 1 |
253499 | 253499 | 2020-06-19 | Jackson | Kansas | 20085 | 104 | 1 |
250384 | 250384 | 2020-06-18 | Jackson | Kansas | 20085 | 104 | 1 |
247272 | 247272 | 2020-06-17 | Jackson | Kansas | 20085 | 103 | 1 |
244159 | 244159 | 2020-06-16 | Jackson | Kansas | 20085 | 103 | 1 |
241048 | 241048 | 2020-06-15 | Jackson | Kansas | 20085 | 103 | 1 |
237939 | 237939 | 2020-06-14 | Jackson | Kansas | 20085 | 103 | 1 |
234832 | 234832 | 2020-06-13 | Jackson | Kansas | 20085 | 103 | 1 |
231726 | 231726 | 2020-06-12 | Jackson | Kansas | 20085 | 103 | 1 |
228623 | 228623 | 2020-06-11 | Jackson | Kansas | 20085 | 102 | 1 |
225521 | 225521 | 2020-06-10 | Jackson | Kansas | 20085 | 102 | 1 |
222426 | 222426 | 2020-06-09 | Jackson | Kansas | 20085 | 103 | 1 |
219331 | 219331 | 2020-06-08 | Jackson | Kansas | 20085 | 103 | 1 |
216239 | 216239 | 2020-06-07 | Jackson | Kansas | 20085 | 103 | 1 |
213152 | 213152 | 2020-06-06 | Jackson | Kansas | 20085 | 103 | 1 |
210067 | 210067 | 2020-06-05 | Jackson | Kansas | 20085 | 103 | 1 |
206986 | 206986 | 2020-06-04 | Jackson | Kansas | 20085 | 102 | 1 |
203905 | 203905 | 2020-06-03 | Jackson | Kansas | 20085 | 102 | 1 |
200829 | 200829 | 2020-06-02 | Jackson | Kansas | 20085 | 102 | 1 |
197757 | 197757 | 2020-06-01 | Jackson | Kansas | 20085 | 100 | 1 |
194687 | 194687 | 2020-05-31 | Jackson | Kansas | 20085 | 100 | 1 |
191619 | 191619 | 2020-05-30 | Jackson | Kansas | 20085 | 96 | 1 |
188555 | 188555 | 2020-05-29 | Jackson | Kansas | 20085 | 96 | 1 |
185497 | 185497 | 2020-05-28 | Jackson | Kansas | 20085 | 93 | 1 |
182443 | 182443 | 2020-05-27 | Jackson | Kansas | 20085 | 93 | 1 |
179398 | 179398 | 2020-05-26 | Jackson | Kansas | 20085 | 93 | 0 |
176354 | 176354 | 2020-05-25 | Jackson | Kansas | 20085 | 92 | 0 |
173310 | 173310 | 2020-05-24 | Jackson | Kansas | 20085 | 92 | 0 |
170269 | 170269 | 2020-05-23 | Jackson | Kansas | 20085 | 92 | 0 |
167231 | 167231 | 2020-05-22 | Jackson | Kansas | 20085 | 84 | 0 |
164197 | 164197 | 2020-05-21 | Jackson | Kansas | 20085 | 36 | 0 |
161168 | 161168 | 2020-05-20 | Jackson | Kansas | 20085 | 33 | 0 |
158143 | 158143 | 2020-05-19 | Jackson | Kansas | 20085 | 32 | 0 |
155126 | 155126 | 2020-05-18 | Jackson | Kansas | 20085 | 28 | 0 |
152114 | 152114 | 2020-05-17 | Jackson | Kansas | 20085 | 25 | 0 |
149103 | 149103 | 2020-05-16 | Jackson | Kansas | 20085 | 24 | 0 |
146099 | 146099 | 2020-05-15 | Jackson | Kansas | 20085 | 23 | 0 |
143099 | 143099 | 2020-05-14 | Jackson | Kansas | 20085 | 12 | 0 |
140103 | 140103 | 2020-05-13 | Jackson | Kansas | 20085 | 12 | 0 |
137110 | 137110 | 2020-05-12 | Jackson | Kansas | 20085 | 7 | 0 |
134120 | 134120 | 2020-05-11 | Jackson | Kansas | 20085 | 4 | 0 |
131129 | 131129 | 2020-05-10 | Jackson | Kansas | 20085 | 4 | 0 |
128139 | 128139 | 2020-05-09 | Jackson | Kansas | 20085 | 3 | 0 |
125151 | 125151 | 2020-05-08 | Jackson | Kansas | 20085 | 2 | 0 |
122169 | 122169 | 2020-05-07 | Jackson | Kansas | 20085 | 2 | 0 |
119199 | 119199 | 2020-05-06 | Jackson | Kansas | 20085 | 2 | 0 |
116238 | 116238 | 2020-05-05 | Jackson | Kansas | 20085 | 2 | 0 |
113356 | 113356 | 2020-05-04 | Jackson | Kansas | 20085 | 2 | 0 |
110479 | 110479 | 2020-05-03 | Jackson | Kansas | 20085 | 2 | 0 |
107608 | 107608 | 2020-05-02 | Jackson | Kansas | 20085 | 2 | 0 |
104743 | 104743 | 2020-05-01 | Jackson | Kansas | 20085 | 2 | 0 |
101883 | 101883 | 2020-04-30 | Jackson | Kansas | 20085 | 2 | 0 |
99031 | 99031 | 2020-04-29 | Jackson | Kansas | 20085 | 2 | 0 |
96185 | 96185 | 2020-04-28 | Jackson | Kansas | 20085 | 2 | 0 |
93353 | 93353 | 2020-04-27 | Jackson | Kansas | 20085 | 2 | 0 |
90532 | 90532 | 2020-04-26 | Jackson | Kansas | 20085 | 2 | 0 |
87716 | 87716 | 2020-04-25 | Jackson | Kansas | 20085 | 1 | 0 |
84907 | 84907 | 2020-04-24 | Jackson | Kansas | 20085 | 1 | 0 |
82105 | 82105 | 2020-04-23 | Jackson | Kansas | 20085 | 1 | 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);