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 |
---|---|---|---|---|---|---|---|
535359 | 535359 | 2020-09-15 | Jefferson | Kansas | 20087 | 167 | 1 |
532124 | 532124 | 2020-09-14 | Jefferson | Kansas | 20087 | 161 | 0 |
528887 | 528887 | 2020-09-13 | Jefferson | Kansas | 20087 | 145 | 0 |
525651 | 525651 | 2020-09-12 | Jefferson | Kansas | 20087 | 145 | 0 |
522415 | 522415 | 2020-09-11 | Jefferson | Kansas | 20087 | 144 | 0 |
519178 | 519178 | 2020-09-10 | Jefferson | Kansas | 20087 | 144 | 0 |
515943 | 515943 | 2020-09-09 | Jefferson | Kansas | 20087 | 139 | 0 |
512710 | 512710 | 2020-09-08 | Jefferson | Kansas | 20087 | 135 | 0 |
509477 | 509477 | 2020-09-07 | Jefferson | Kansas | 20087 | 135 | 0 |
506245 | 506245 | 2020-09-06 | Jefferson | Kansas | 20087 | 129 | 0 |
503011 | 503011 | 2020-09-05 | Jefferson | Kansas | 20087 | 129 | 0 |
499777 | 499777 | 2020-09-04 | Jefferson | Kansas | 20087 | 129 | 0 |
496544 | 496544 | 2020-09-03 | Jefferson | Kansas | 20087 | 125 | 0 |
493310 | 493310 | 2020-09-02 | Jefferson | Kansas | 20087 | 125 | 0 |
490077 | 490077 | 2020-09-01 | Jefferson | Kansas | 20087 | 122 | 0 |
486844 | 486844 | 2020-08-31 | Jefferson | Kansas | 20087 | 120 | 0 |
483609 | 483609 | 2020-08-30 | Jefferson | Kansas | 20087 | 117 | 0 |
480375 | 480375 | 2020-08-29 | Jefferson | Kansas | 20087 | 117 | 0 |
477142 | 477142 | 2020-08-28 | Jefferson | Kansas | 20087 | 117 | 0 |
473909 | 473909 | 2020-08-27 | Jefferson | Kansas | 20087 | 112 | 0 |
470677 | 470677 | 2020-08-26 | Jefferson | Kansas | 20087 | 112 | 0 |
467448 | 467448 | 2020-08-25 | Jefferson | Kansas | 20087 | 106 | 0 |
464219 | 464219 | 2020-08-24 | Jefferson | Kansas | 20087 | 106 | 0 |
460990 | 460990 | 2020-08-23 | Jefferson | Kansas | 20087 | 103 | 0 |
457763 | 457763 | 2020-08-22 | Jefferson | Kansas | 20087 | 103 | 0 |
454535 | 454535 | 2020-08-21 | Jefferson | Kansas | 20087 | 103 | 0 |
451307 | 451307 | 2020-08-20 | Jefferson | Kansas | 20087 | 100 | 0 |
448079 | 448079 | 2020-08-19 | Jefferson | Kansas | 20087 | 100 | 0 |
444852 | 444852 | 2020-08-18 | Jefferson | Kansas | 20087 | 96 | 0 |
441626 | 441626 | 2020-08-17 | Jefferson | Kansas | 20087 | 96 | 0 |
438399 | 438399 | 2020-08-16 | Jefferson | Kansas | 20087 | 91 | 0 |
435174 | 435174 | 2020-08-15 | Jefferson | Kansas | 20087 | 91 | 0 |
431949 | 431949 | 2020-08-14 | Jefferson | Kansas | 20087 | 91 | 0 |
428721 | 428721 | 2020-08-13 | Jefferson | Kansas | 20087 | 88 | 0 |
425497 | 425497 | 2020-08-12 | Jefferson | Kansas | 20087 | 88 | 0 |
422276 | 422276 | 2020-08-11 | Jefferson | Kansas | 20087 | 87 | 0 |
419053 | 419053 | 2020-08-10 | Jefferson | Kansas | 20087 | 86 | 0 |
415832 | 415832 | 2020-08-09 | Jefferson | Kansas | 20087 | 80 | 0 |
412612 | 412612 | 2020-08-08 | Jefferson | Kansas | 20087 | 80 | 0 |
409392 | 409392 | 2020-08-07 | Jefferson | Kansas | 20087 | 80 | 0 |
406173 | 406173 | 2020-08-06 | Jefferson | Kansas | 20087 | 79 | 0 |
402955 | 402955 | 2020-08-05 | Jefferson | Kansas | 20087 | 78 | 0 |
399738 | 399738 | 2020-08-04 | Jefferson | Kansas | 20087 | 77 | 0 |
396523 | 396523 | 2020-08-03 | Jefferson | Kansas | 20087 | 73 | 0 |
393307 | 393307 | 2020-08-02 | Jefferson | Kansas | 20087 | 61 | 0 |
390090 | 390090 | 2020-08-01 | Jefferson | Kansas | 20087 | 61 | 0 |
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 |
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);