ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
797 rows where county = "Johnson" and fips = 19103 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535267 | 535267 | 2020-09-15 | Johnson | Iowa | 19103 | 4858 | 27 |
532032 | 532032 | 2020-09-14 | Johnson | Iowa | 19103 | 4834 | 27 |
528795 | 528795 | 2020-09-13 | Johnson | Iowa | 19103 | 4810 | 26 |
525559 | 525559 | 2020-09-12 | Johnson | Iowa | 19103 | 4790 | 26 |
522323 | 522323 | 2020-09-11 | Johnson | Iowa | 19103 | 4766 | 26 |
519086 | 519086 | 2020-09-10 | Johnson | Iowa | 19103 | 4722 | 26 |
515851 | 515851 | 2020-09-09 | Johnson | Iowa | 19103 | 4671 | 26 |
512618 | 512618 | 2020-09-08 | Johnson | Iowa | 19103 | 4617 | 26 |
509385 | 509385 | 2020-09-07 | Johnson | Iowa | 19103 | 4581 | 26 |
506153 | 506153 | 2020-09-06 | Johnson | Iowa | 19103 | 4556 | 26 |
502919 | 502919 | 2020-09-05 | Johnson | Iowa | 19103 | 4487 | 26 |
499685 | 499685 | 2020-09-04 | Johnson | Iowa | 19103 | 4421 | 26 |
496452 | 496452 | 2020-09-03 | Johnson | Iowa | 19103 | 4302 | 26 |
493218 | 493218 | 2020-09-02 | Johnson | Iowa | 19103 | 4164 | 26 |
489985 | 489985 | 2020-09-01 | Johnson | Iowa | 19103 | 4051 | 26 |
486752 | 486752 | 2020-08-31 | Johnson | Iowa | 19103 | 3938 | 26 |
483517 | 483517 | 2020-08-30 | Johnson | Iowa | 19103 | 3828 | 26 |
480283 | 480283 | 2020-08-29 | Johnson | Iowa | 19103 | 3644 | 26 |
477050 | 477050 | 2020-08-28 | Johnson | Iowa | 19103 | 3443 | 26 |
473817 | 473817 | 2020-08-27 | Johnson | Iowa | 19103 | 3219 | 26 |
470585 | 470585 | 2020-08-26 | Johnson | Iowa | 19103 | 2944 | 26 |
467356 | 467356 | 2020-08-25 | Johnson | Iowa | 19103 | 2707 | 24 |
464127 | 464127 | 2020-08-24 | Johnson | Iowa | 19103 | 2597 | 24 |
460898 | 460898 | 2020-08-23 | Johnson | Iowa | 19103 | 2538 | 24 |
457671 | 457671 | 2020-08-22 | Johnson | Iowa | 19103 | 2454 | 24 |
454443 | 454443 | 2020-08-21 | Johnson | Iowa | 19103 | 2370 | 24 |
451215 | 451215 | 2020-08-20 | Johnson | Iowa | 19103 | 2311 | 24 |
447987 | 447987 | 2020-08-19 | Johnson | Iowa | 19103 | 2281 | 22 |
444760 | 444760 | 2020-08-18 | Johnson | Iowa | 19103 | 2255 | 22 |
441534 | 441534 | 2020-08-17 | Johnson | Iowa | 19103 | 2208 | 21 |
438308 | 438308 | 2020-08-16 | Johnson | Iowa | 19103 | 2191 | 21 |
435082 | 435082 | 2020-08-15 | Johnson | Iowa | 19103 | 2182 | 21 |
431857 | 431857 | 2020-08-14 | Johnson | Iowa | 19103 | 2165 | 21 |
428629 | 428629 | 2020-08-13 | Johnson | Iowa | 19103 | 2146 | 21 |
425405 | 425405 | 2020-08-12 | Johnson | Iowa | 19103 | 2123 | 20 |
422184 | 422184 | 2020-08-11 | Johnson | Iowa | 19103 | 2118 | 19 |
418961 | 418961 | 2020-08-10 | Johnson | Iowa | 19103 | 2107 | 19 |
415740 | 415740 | 2020-08-09 | Johnson | Iowa | 19103 | 2096 | 19 |
412520 | 412520 | 2020-08-08 | Johnson | Iowa | 19103 | 2063 | 19 |
409301 | 409301 | 2020-08-07 | Johnson | Iowa | 19103 | 2050 | 16 |
406081 | 406081 | 2020-08-06 | Johnson | Iowa | 19103 | 2021 | 16 |
402863 | 402863 | 2020-08-05 | Johnson | Iowa | 19103 | 2002 | 16 |
399647 | 399647 | 2020-08-04 | Johnson | Iowa | 19103 | 1959 | 15 |
396431 | 396431 | 2020-08-03 | Johnson | Iowa | 19103 | 1933 | 15 |
393215 | 393215 | 2020-08-02 | Johnson | Iowa | 19103 | 1918 | 15 |
389998 | 389998 | 2020-08-01 | Johnson | Iowa | 19103 | 1901 | 15 |
386781 | 386781 | 2020-07-31 | Johnson | Iowa | 19103 | 1881 | 15 |
383563 | 383563 | 2020-07-30 | Johnson | Iowa | 19103 | 1856 | 14 |
380346 | 380346 | 2020-07-29 | Johnson | Iowa | 19103 | 1822 | 14 |
377129 | 377129 | 2020-07-28 | Johnson | Iowa | 19103 | 1781 | 12 |
373914 | 373914 | 2020-07-27 | Johnson | Iowa | 19103 | 1766 | 12 |
370702 | 370702 | 2020-07-26 | Johnson | Iowa | 19103 | 1751 | 10 |
367492 | 367492 | 2020-07-25 | Johnson | Iowa | 19103 | 1735 | 10 |
364285 | 364285 | 2020-07-24 | Johnson | Iowa | 19103 | 1720 | 10 |
361078 | 361078 | 2020-07-23 | Johnson | Iowa | 19103 | 1700 | 10 |
357873 | 357873 | 2020-07-22 | Johnson | Iowa | 19103 | 1676 | 10 |
354671 | 354671 | 2020-07-21 | Johnson | Iowa | 19103 | 1651 | 10 |
351469 | 351469 | 2020-07-20 | Johnson | Iowa | 19103 | 1636 | 10 |
348269 | 348269 | 2020-07-19 | Johnson | Iowa | 19103 | 1628 | 10 |
345068 | 345068 | 2020-07-18 | Johnson | Iowa | 19103 | 1609 | 9 |
341868 | 341868 | 2020-07-17 | Johnson | Iowa | 19103 | 1598 | 9 |
338672 | 338672 | 2020-07-16 | Johnson | Iowa | 19103 | 1575 | 9 |
335476 | 335476 | 2020-07-15 | Johnson | Iowa | 19103 | 1543 | 8 |
332283 | 332283 | 2020-07-14 | Johnson | Iowa | 19103 | 1500 | 8 |
329096 | 329096 | 2020-07-13 | Johnson | Iowa | 19103 | 1487 | 8 |
325910 | 325910 | 2020-07-12 | Johnson | Iowa | 19103 | 1479 | 8 |
322729 | 322729 | 2020-07-11 | Johnson | Iowa | 19103 | 1428 | 8 |
319550 | 319550 | 2020-07-10 | Johnson | Iowa | 19103 | 1406 | 8 |
316377 | 316377 | 2020-07-09 | Johnson | Iowa | 19103 | 1385 | 8 |
313203 | 313203 | 2020-07-08 | Johnson | Iowa | 19103 | 1365 | 8 |
310033 | 310033 | 2020-07-07 | Johnson | Iowa | 19103 | 1340 | 8 |
306865 | 306865 | 2020-07-06 | Johnson | Iowa | 19103 | 1314 | 8 |
303700 | 303700 | 2020-07-05 | Johnson | Iowa | 19103 | 1297 | 8 |
300536 | 300536 | 2020-07-04 | Johnson | Iowa | 19103 | 1269 | 8 |
297374 | 297374 | 2020-07-03 | Johnson | Iowa | 19103 | 1243 | 8 |
294216 | 294216 | 2020-07-02 | Johnson | Iowa | 19103 | 1231 | 8 |
291062 | 291062 | 2020-07-01 | Johnson | Iowa | 19103 | 1186 | 8 |
287912 | 287912 | 2020-06-30 | Johnson | Iowa | 19103 | 1150 | 8 |
284763 | 284763 | 2020-06-29 | Johnson | Iowa | 19103 | 1119 | 8 |
281618 | 281618 | 2020-06-28 | Johnson | Iowa | 19103 | 1033 | 8 |
278470 | 278470 | 2020-06-27 | Johnson | Iowa | 19103 | 1016 | 8 |
275322 | 275322 | 2020-06-26 | Johnson | Iowa | 19103 | 964 | 8 |
272180 | 272180 | 2020-06-25 | Johnson | Iowa | 19103 | 914 | 9 |
269043 | 269043 | 2020-06-24 | Johnson | Iowa | 19103 | 858 | 9 |
265913 | 265913 | 2020-06-23 | Johnson | Iowa | 19103 | 811 | 8 |
262785 | 262785 | 2020-06-22 | Johnson | Iowa | 19103 | 781 | 8 |
259658 | 259658 | 2020-06-21 | Johnson | Iowa | 19103 | 760 | 8 |
256532 | 256532 | 2020-06-20 | Johnson | Iowa | 19103 | 725 | 8 |
253412 | 253412 | 2020-06-19 | Johnson | Iowa | 19103 | 721 | 8 |
250297 | 250297 | 2020-06-18 | Johnson | Iowa | 19103 | 696 | 8 |
247185 | 247185 | 2020-06-17 | Johnson | Iowa | 19103 | 674 | 8 |
244072 | 244072 | 2020-06-16 | Johnson | Iowa | 19103 | 653 | 8 |
240961 | 240961 | 2020-06-15 | Johnson | Iowa | 19103 | 644 | 8 |
237853 | 237853 | 2020-06-14 | Johnson | Iowa | 19103 | 638 | 8 |
234746 | 234746 | 2020-06-13 | Johnson | Iowa | 19103 | 638 | 8 |
231640 | 231640 | 2020-06-12 | Johnson | Iowa | 19103 | 636 | 8 |
228537 | 228537 | 2020-06-11 | Johnson | Iowa | 19103 | 630 | 8 |
225435 | 225435 | 2020-06-10 | Johnson | Iowa | 19103 | 625 | 8 |
222340 | 222340 | 2020-06-09 | Johnson | Iowa | 19103 | 630 | 8 |
219245 | 219245 | 2020-06-08 | Johnson | Iowa | 19103 | 627 | 8 |
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);