ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Jefferson" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386873 | 386873 | 2020-07-31 | Jefferson | Kansas | 20087 | 61 | 0 |
383655 | 383655 | 2020-07-30 | Jefferson | Kansas | 20087 | 56 | 0 |
380438 | 380438 | 2020-07-29 | Jefferson | Kansas | 20087 | 56 | 0 |
377221 | 377221 | 2020-07-28 | Jefferson | Kansas | 20087 | 53 | 0 |
374006 | 374006 | 2020-07-27 | Jefferson | Kansas | 20087 | 51 | 0 |
370794 | 370794 | 2020-07-26 | Jefferson | Kansas | 20087 | 48 | 0 |
367584 | 367584 | 2020-07-25 | Jefferson | Kansas | 20087 | 48 | 0 |
364377 | 364377 | 2020-07-24 | Jefferson | Kansas | 20087 | 48 | 0 |
361170 | 361170 | 2020-07-23 | Jefferson | Kansas | 20087 | 46 | 0 |
357965 | 357965 | 2020-07-22 | Jefferson | Kansas | 20087 | 44 | 0 |
354763 | 354763 | 2020-07-21 | Jefferson | Kansas | 20087 | 44 | 0 |
351561 | 351561 | 2020-07-20 | Jefferson | Kansas | 20087 | 44 | 0 |
348361 | 348361 | 2020-07-19 | Jefferson | Kansas | 20087 | 41 | 0 |
345160 | 345160 | 2020-07-18 | Jefferson | Kansas | 20087 | 41 | 0 |
341960 | 341960 | 2020-07-17 | Jefferson | Kansas | 20087 | 41 | 0 |
338764 | 338764 | 2020-07-16 | Jefferson | Kansas | 20087 | 39 | 0 |
335568 | 335568 | 2020-07-15 | Jefferson | Kansas | 20087 | 39 | 0 |
332375 | 332375 | 2020-07-14 | Jefferson | Kansas | 20087 | 38 | 0 |
329188 | 329188 | 2020-07-13 | Jefferson | Kansas | 20087 | 37 | 0 |
326002 | 326002 | 2020-07-12 | Jefferson | Kansas | 20087 | 38 | 0 |
322819 | 322819 | 2020-07-11 | Jefferson | Kansas | 20087 | 37 | 0 |
319640 | 319640 | 2020-07-10 | Jefferson | Kansas | 20087 | 37 | 0 |
316467 | 316467 | 2020-07-09 | Jefferson | Kansas | 20087 | 33 | 0 |
313293 | 313293 | 2020-07-08 | Jefferson | Kansas | 20087 | 33 | 0 |
310123 | 310123 | 2020-07-07 | Jefferson | Kansas | 20087 | 31 | 0 |
306955 | 306955 | 2020-07-06 | Jefferson | Kansas | 20087 | 31 | 0 |
303789 | 303789 | 2020-07-05 | Jefferson | Kansas | 20087 | 28 | 0 |
300625 | 300625 | 2020-07-04 | Jefferson | Kansas | 20087 | 28 | 0 |
297463 | 297463 | 2020-07-03 | Jefferson | Kansas | 20087 | 28 | 0 |
294305 | 294305 | 2020-07-02 | Jefferson | Kansas | 20087 | 25 | 0 |
291151 | 291151 | 2020-07-01 | Jefferson | Kansas | 20087 | 25 | 0 |
288001 | 288001 | 2020-06-30 | Jefferson | Kansas | 20087 | 25 | 0 |
284852 | 284852 | 2020-06-29 | Jefferson | Kansas | 20087 | 25 | 0 |
281707 | 281707 | 2020-06-28 | Jefferson | Kansas | 20087 | 26 | 0 |
278559 | 278559 | 2020-06-27 | Jefferson | Kansas | 20087 | 26 | 0 |
275411 | 275411 | 2020-06-26 | Jefferson | Kansas | 20087 | 26 | 0 |
272268 | 272268 | 2020-06-25 | Jefferson | Kansas | 20087 | 25 | 0 |
269131 | 269131 | 2020-06-24 | Jefferson | Kansas | 20087 | 25 | 0 |
266001 | 266001 | 2020-06-23 | Jefferson | Kansas | 20087 | 23 | 0 |
262873 | 262873 | 2020-06-22 | Jefferson | Kansas | 20087 | 23 | 0 |
259746 | 259746 | 2020-06-21 | Jefferson | Kansas | 20087 | 23 | 0 |
256620 | 256620 | 2020-06-20 | Jefferson | Kansas | 20087 | 23 | 0 |
253500 | 253500 | 2020-06-19 | Jefferson | Kansas | 20087 | 23 | 0 |
250385 | 250385 | 2020-06-18 | Jefferson | Kansas | 20087 | 23 | 0 |
247273 | 247273 | 2020-06-17 | Jefferson | Kansas | 20087 | 23 | 0 |
244160 | 244160 | 2020-06-16 | Jefferson | Kansas | 20087 | 23 | 0 |
241049 | 241049 | 2020-06-15 | Jefferson | Kansas | 20087 | 23 | 0 |
237940 | 237940 | 2020-06-14 | Jefferson | Kansas | 20087 | 23 | 0 |
234833 | 234833 | 2020-06-13 | Jefferson | Kansas | 20087 | 23 | 0 |
231727 | 231727 | 2020-06-12 | Jefferson | Kansas | 20087 | 23 | 0 |
228624 | 228624 | 2020-06-11 | Jefferson | Kansas | 20087 | 23 | 0 |
225522 | 225522 | 2020-06-10 | Jefferson | Kansas | 20087 | 23 | 0 |
222427 | 222427 | 2020-06-09 | Jefferson | Kansas | 20087 | 23 | 0 |
219332 | 219332 | 2020-06-08 | Jefferson | Kansas | 20087 | 23 | 0 |
216240 | 216240 | 2020-06-07 | Jefferson | Kansas | 20087 | 22 | 0 |
213153 | 213153 | 2020-06-06 | Jefferson | Kansas | 20087 | 22 | 0 |
210068 | 210068 | 2020-06-05 | Jefferson | Kansas | 20087 | 22 | 0 |
206987 | 206987 | 2020-06-04 | Jefferson | Kansas | 20087 | 22 | 0 |
203906 | 203906 | 2020-06-03 | Jefferson | Kansas | 20087 | 22 | 0 |
200830 | 200830 | 2020-06-02 | Jefferson | Kansas | 20087 | 22 | 0 |
197758 | 197758 | 2020-06-01 | Jefferson | Kansas | 20087 | 22 | 0 |
194688 | 194688 | 2020-05-31 | Jefferson | Kansas | 20087 | 22 | 0 |
191620 | 191620 | 2020-05-30 | Jefferson | Kansas | 20087 | 22 | 0 |
188556 | 188556 | 2020-05-29 | Jefferson | Kansas | 20087 | 22 | 0 |
185498 | 185498 | 2020-05-28 | Jefferson | Kansas | 20087 | 22 | 0 |
182444 | 182444 | 2020-05-27 | Jefferson | Kansas | 20087 | 22 | 0 |
179399 | 179399 | 2020-05-26 | Jefferson | Kansas | 20087 | 22 | 0 |
176355 | 176355 | 2020-05-25 | Jefferson | Kansas | 20087 | 22 | 0 |
173311 | 173311 | 2020-05-24 | Jefferson | Kansas | 20087 | 21 | 0 |
170270 | 170270 | 2020-05-23 | Jefferson | Kansas | 20087 | 21 | 0 |
167232 | 167232 | 2020-05-22 | Jefferson | Kansas | 20087 | 21 | 0 |
164198 | 164198 | 2020-05-21 | Jefferson | Kansas | 20087 | 21 | 0 |
161169 | 161169 | 2020-05-20 | Jefferson | Kansas | 20087 | 21 | 0 |
158144 | 158144 | 2020-05-19 | Jefferson | Kansas | 20087 | 20 | 0 |
155127 | 155127 | 2020-05-18 | Jefferson | Kansas | 20087 | 20 | 0 |
152115 | 152115 | 2020-05-17 | Jefferson | Kansas | 20087 | 18 | 0 |
149104 | 149104 | 2020-05-16 | Jefferson | Kansas | 20087 | 18 | 0 |
146100 | 146100 | 2020-05-15 | Jefferson | Kansas | 20087 | 18 | 0 |
143100 | 143100 | 2020-05-14 | Jefferson | Kansas | 20087 | 16 | 0 |
140104 | 140104 | 2020-05-13 | Jefferson | Kansas | 20087 | 16 | 0 |
137111 | 137111 | 2020-05-12 | Jefferson | Kansas | 20087 | 13 | 0 |
134121 | 134121 | 2020-05-11 | Jefferson | Kansas | 20087 | 13 | 0 |
131130 | 131130 | 2020-05-10 | Jefferson | Kansas | 20087 | 12 | 0 |
128140 | 128140 | 2020-05-09 | Jefferson | Kansas | 20087 | 12 | 0 |
125152 | 125152 | 2020-05-08 | Jefferson | Kansas | 20087 | 12 | 0 |
122170 | 122170 | 2020-05-07 | Jefferson | Kansas | 20087 | 12 | 0 |
119200 | 119200 | 2020-05-06 | Jefferson | Kansas | 20087 | 11 | 0 |
116239 | 116239 | 2020-05-05 | Jefferson | Kansas | 20087 | 10 | 0 |
113357 | 113357 | 2020-05-04 | Jefferson | Kansas | 20087 | 10 | 0 |
110480 | 110480 | 2020-05-03 | Jefferson | Kansas | 20087 | 10 | 0 |
107609 | 107609 | 2020-05-02 | Jefferson | Kansas | 20087 | 10 | 0 |
104744 | 104744 | 2020-05-01 | Jefferson | Kansas | 20087 | 9 | 0 |
101884 | 101884 | 2020-04-30 | Jefferson | Kansas | 20087 | 9 | 0 |
99032 | 99032 | 2020-04-29 | Jefferson | Kansas | 20087 | 9 | 0 |
96186 | 96186 | 2020-04-28 | Jefferson | Kansas | 20087 | 8 | 0 |
93354 | 93354 | 2020-04-27 | Jefferson | Kansas | 20087 | 8 | 0 |
90533 | 90533 | 2020-04-26 | Jefferson | Kansas | 20087 | 8 | 0 |
87717 | 87717 | 2020-04-25 | Jefferson | Kansas | 20087 | 8 | 0 |
84908 | 84908 | 2020-04-24 | Jefferson | Kansas | 20087 | 8 | 0 |
82106 | 82106 | 2020-04-23 | Jefferson | Kansas | 20087 | 7 | 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);