ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where county = "Jefferson" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535266 | 535266 | 2020-09-15 | Jefferson | Iowa | 19101 | 129 | 1 |
532031 | 532031 | 2020-09-14 | Jefferson | Iowa | 19101 | 126 | 1 |
528794 | 528794 | 2020-09-13 | Jefferson | Iowa | 19101 | 126 | 1 |
525558 | 525558 | 2020-09-12 | Jefferson | Iowa | 19101 | 126 | 1 |
522322 | 522322 | 2020-09-11 | Jefferson | Iowa | 19101 | 126 | 1 |
519085 | 519085 | 2020-09-10 | Jefferson | Iowa | 19101 | 124 | 1 |
515850 | 515850 | 2020-09-09 | Jefferson | Iowa | 19101 | 123 | 1 |
512617 | 512617 | 2020-09-08 | Jefferson | Iowa | 19101 | 123 | 1 |
509384 | 509384 | 2020-09-07 | Jefferson | Iowa | 19101 | 124 | 1 |
506152 | 506152 | 2020-09-06 | Jefferson | Iowa | 19101 | 124 | 1 |
502918 | 502918 | 2020-09-05 | Jefferson | Iowa | 19101 | 123 | 1 |
499684 | 499684 | 2020-09-04 | Jefferson | Iowa | 19101 | 121 | 1 |
496451 | 496451 | 2020-09-03 | Jefferson | Iowa | 19101 | 120 | 0 |
493217 | 493217 | 2020-09-02 | Jefferson | Iowa | 19101 | 120 | 0 |
489984 | 489984 | 2020-09-01 | Jefferson | Iowa | 19101 | 120 | 0 |
486751 | 486751 | 2020-08-31 | Jefferson | Iowa | 19101 | 118 | 0 |
483516 | 483516 | 2020-08-30 | Jefferson | Iowa | 19101 | 117 | 0 |
480282 | 480282 | 2020-08-29 | Jefferson | Iowa | 19101 | 117 | 0 |
477049 | 477049 | 2020-08-28 | Jefferson | Iowa | 19101 | 116 | 0 |
473816 | 473816 | 2020-08-27 | Jefferson | Iowa | 19101 | 116 | 0 |
470584 | 470584 | 2020-08-26 | Jefferson | Iowa | 19101 | 110 | 0 |
467355 | 467355 | 2020-08-25 | Jefferson | Iowa | 19101 | 107 | 0 |
464126 | 464126 | 2020-08-24 | Jefferson | Iowa | 19101 | 105 | 0 |
460897 | 460897 | 2020-08-23 | Jefferson | Iowa | 19101 | 103 | 0 |
457670 | 457670 | 2020-08-22 | Jefferson | Iowa | 19101 | 103 | 0 |
454442 | 454442 | 2020-08-21 | Jefferson | Iowa | 19101 | 100 | 0 |
451214 | 451214 | 2020-08-20 | Jefferson | Iowa | 19101 | 98 | 0 |
447986 | 447986 | 2020-08-19 | Jefferson | Iowa | 19101 | 95 | 0 |
444759 | 444759 | 2020-08-18 | Jefferson | Iowa | 19101 | 95 | 0 |
441533 | 441533 | 2020-08-17 | Jefferson | Iowa | 19101 | 94 | 0 |
438307 | 438307 | 2020-08-16 | Jefferson | Iowa | 19101 | 91 | 0 |
435081 | 435081 | 2020-08-15 | Jefferson | Iowa | 19101 | 91 | 0 |
431856 | 431856 | 2020-08-14 | Jefferson | Iowa | 19101 | 89 | 0 |
428628 | 428628 | 2020-08-13 | Jefferson | Iowa | 19101 | 88 | 0 |
425404 | 425404 | 2020-08-12 | Jefferson | Iowa | 19101 | 87 | 0 |
422183 | 422183 | 2020-08-11 | Jefferson | Iowa | 19101 | 87 | 0 |
418960 | 418960 | 2020-08-10 | Jefferson | Iowa | 19101 | 86 | 0 |
415739 | 415739 | 2020-08-09 | Jefferson | Iowa | 19101 | 84 | 0 |
412519 | 412519 | 2020-08-08 | Jefferson | Iowa | 19101 | 83 | 0 |
409300 | 409300 | 2020-08-07 | Jefferson | Iowa | 19101 | 82 | 0 |
406080 | 406080 | 2020-08-06 | Jefferson | Iowa | 19101 | 80 | 0 |
402862 | 402862 | 2020-08-05 | Jefferson | Iowa | 19101 | 77 | 0 |
399646 | 399646 | 2020-08-04 | Jefferson | Iowa | 19101 | 77 | 0 |
396430 | 396430 | 2020-08-03 | Jefferson | Iowa | 19101 | 77 | 0 |
393214 | 393214 | 2020-08-02 | Jefferson | Iowa | 19101 | 78 | 0 |
389997 | 389997 | 2020-08-01 | Jefferson | Iowa | 19101 | 76 | 0 |
386780 | 386780 | 2020-07-31 | Jefferson | Iowa | 19101 | 75 | 0 |
383562 | 383562 | 2020-07-30 | Jefferson | Iowa | 19101 | 75 | 0 |
380345 | 380345 | 2020-07-29 | Jefferson | Iowa | 19101 | 72 | 0 |
377128 | 377128 | 2020-07-28 | Jefferson | Iowa | 19101 | 72 | 0 |
373913 | 373913 | 2020-07-27 | Jefferson | Iowa | 19101 | 71 | 0 |
370701 | 370701 | 2020-07-26 | Jefferson | Iowa | 19101 | 71 | 0 |
367491 | 367491 | 2020-07-25 | Jefferson | Iowa | 19101 | 71 | 0 |
364284 | 364284 | 2020-07-24 | Jefferson | Iowa | 19101 | 69 | 0 |
361077 | 361077 | 2020-07-23 | Jefferson | Iowa | 19101 | 68 | 0 |
357872 | 357872 | 2020-07-22 | Jefferson | Iowa | 19101 | 68 | 0 |
354670 | 354670 | 2020-07-21 | Jefferson | Iowa | 19101 | 68 | 0 |
351468 | 351468 | 2020-07-20 | Jefferson | Iowa | 19101 | 67 | 0 |
348268 | 348268 | 2020-07-19 | Jefferson | Iowa | 19101 | 66 | 0 |
345067 | 345067 | 2020-07-18 | Jefferson | Iowa | 19101 | 64 | 0 |
341867 | 341867 | 2020-07-17 | Jefferson | Iowa | 19101 | 64 | 0 |
338671 | 338671 | 2020-07-16 | Jefferson | Iowa | 19101 | 64 | 0 |
335475 | 335475 | 2020-07-15 | Jefferson | Iowa | 19101 | 64 | 0 |
332282 | 332282 | 2020-07-14 | Jefferson | Iowa | 19101 | 63 | 0 |
329095 | 329095 | 2020-07-13 | Jefferson | Iowa | 19101 | 63 | 0 |
325909 | 325909 | 2020-07-12 | Jefferson | Iowa | 19101 | 63 | 0 |
322728 | 322728 | 2020-07-11 | Jefferson | Iowa | 19101 | 62 | 0 |
319549 | 319549 | 2020-07-10 | Jefferson | Iowa | 19101 | 62 | 0 |
316376 | 316376 | 2020-07-09 | Jefferson | Iowa | 19101 | 62 | 0 |
313202 | 313202 | 2020-07-08 | Jefferson | Iowa | 19101 | 62 | 0 |
310032 | 310032 | 2020-07-07 | Jefferson | Iowa | 19101 | 62 | 0 |
306864 | 306864 | 2020-07-06 | Jefferson | Iowa | 19101 | 64 | 0 |
303699 | 303699 | 2020-07-05 | Jefferson | Iowa | 19101 | 64 | 0 |
300535 | 300535 | 2020-07-04 | Jefferson | Iowa | 19101 | 60 | 0 |
297373 | 297373 | 2020-07-03 | Jefferson | Iowa | 19101 | 59 | 0 |
294215 | 294215 | 2020-07-02 | Jefferson | Iowa | 19101 | 58 | 0 |
291061 | 291061 | 2020-07-01 | Jefferson | Iowa | 19101 | 55 | 0 |
287911 | 287911 | 2020-06-30 | Jefferson | Iowa | 19101 | 53 | 0 |
284762 | 284762 | 2020-06-29 | Jefferson | Iowa | 19101 | 52 | 0 |
281617 | 281617 | 2020-06-28 | Jefferson | Iowa | 19101 | 50 | 0 |
278469 | 278469 | 2020-06-27 | Jefferson | Iowa | 19101 | 50 | 0 |
275321 | 275321 | 2020-06-26 | Jefferson | Iowa | 19101 | 50 | 0 |
272179 | 272179 | 2020-06-25 | Jefferson | Iowa | 19101 | 50 | 0 |
269042 | 269042 | 2020-06-24 | Jefferson | Iowa | 19101 | 49 | 0 |
265912 | 265912 | 2020-06-23 | Jefferson | Iowa | 19101 | 49 | 0 |
262784 | 262784 | 2020-06-22 | Jefferson | Iowa | 19101 | 49 | 0 |
259657 | 259657 | 2020-06-21 | Jefferson | Iowa | 19101 | 47 | 0 |
256531 | 256531 | 2020-06-20 | Jefferson | Iowa | 19101 | 46 | 0 |
253411 | 253411 | 2020-06-19 | Jefferson | Iowa | 19101 | 46 | 0 |
250296 | 250296 | 2020-06-18 | Jefferson | Iowa | 19101 | 46 | 0 |
247184 | 247184 | 2020-06-17 | Jefferson | Iowa | 19101 | 46 | 0 |
244071 | 244071 | 2020-06-16 | Jefferson | Iowa | 19101 | 46 | 0 |
240960 | 240960 | 2020-06-15 | Jefferson | Iowa | 19101 | 48 | 0 |
237852 | 237852 | 2020-06-14 | Jefferson | Iowa | 19101 | 45 | 0 |
234745 | 234745 | 2020-06-13 | Jefferson | Iowa | 19101 | 45 | 0 |
231639 | 231639 | 2020-06-12 | Jefferson | Iowa | 19101 | 44 | 0 |
228536 | 228536 | 2020-06-11 | Jefferson | Iowa | 19101 | 43 | 0 |
225434 | 225434 | 2020-06-10 | Jefferson | Iowa | 19101 | 43 | 0 |
222339 | 222339 | 2020-06-09 | Jefferson | Iowa | 19101 | 40 | 0 |
219244 | 219244 | 2020-06-08 | Jefferson | Iowa | 19101 | 38 | 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);