ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 19169 sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
284796 | 284796 | 2020-06-29 | Story | Iowa | 19169 | 679 | 3 |
287945 | 287945 | 2020-06-30 | Story | Iowa | 19169 | 699 | 3 |
291095 | 291095 | 2020-07-01 | Story | Iowa | 19169 | 723 | 3 |
294249 | 294249 | 2020-07-02 | Story | Iowa | 19169 | 746 | 3 |
297407 | 297407 | 2020-07-03 | Story | Iowa | 19169 | 752 | 3 |
300569 | 300569 | 2020-07-04 | Story | Iowa | 19169 | 764 | 3 |
303733 | 303733 | 2020-07-05 | Story | Iowa | 19169 | 777 | 3 |
306898 | 306898 | 2020-07-06 | Story | Iowa | 19169 | 779 | 3 |
310066 | 310066 | 2020-07-07 | Story | Iowa | 19169 | 806 | 3 |
313236 | 313236 | 2020-07-08 | Story | Iowa | 19169 | 822 | 4 |
316410 | 316410 | 2020-07-09 | Story | Iowa | 19169 | 827 | 4 |
319583 | 319583 | 2020-07-10 | Story | Iowa | 19169 | 854 | 5 |
322762 | 322762 | 2020-07-11 | Story | Iowa | 19169 | 858 | 5 |
325943 | 325943 | 2020-07-12 | Story | Iowa | 19169 | 872 | 6 |
329129 | 329129 | 2020-07-13 | Story | Iowa | 19169 | 877 | 8 |
332316 | 332316 | 2020-07-14 | Story | Iowa | 19169 | 883 | 8 |
335509 | 335509 | 2020-07-15 | Story | Iowa | 19169 | 897 | 8 |
338705 | 338705 | 2020-07-16 | Story | Iowa | 19169 | 912 | 8 |
341901 | 341901 | 2020-07-17 | Story | Iowa | 19169 | 926 | 8 |
345101 | 345101 | 2020-07-18 | Story | Iowa | 19169 | 929 | 8 |
348302 | 348302 | 2020-07-19 | Story | Iowa | 19169 | 934 | 8 |
351502 | 351502 | 2020-07-20 | Story | Iowa | 19169 | 947 | 9 |
354704 | 354704 | 2020-07-21 | Story | Iowa | 19169 | 970 | 10 |
357906 | 357906 | 2020-07-22 | Story | Iowa | 19169 | 983 | 10 |
361111 | 361111 | 2020-07-23 | Story | Iowa | 19169 | 998 | 10 |
364318 | 364318 | 2020-07-24 | Story | Iowa | 19169 | 1026 | 11 |
367525 | 367525 | 2020-07-25 | Story | Iowa | 19169 | 1035 | 11 |
370735 | 370735 | 2020-07-26 | Story | Iowa | 19169 | 1045 | 11 |
373947 | 373947 | 2020-07-27 | Story | Iowa | 19169 | 1055 | 11 |
377162 | 377162 | 2020-07-28 | Story | Iowa | 19169 | 1057 | 11 |
380379 | 380379 | 2020-07-29 | Story | Iowa | 19169 | 1075 | 13 |
383596 | 383596 | 2020-07-30 | Story | Iowa | 19169 | 1084 | 13 |
386814 | 386814 | 2020-07-31 | Story | Iowa | 19169 | 1088 | 13 |
390031 | 390031 | 2020-08-01 | Story | Iowa | 19169 | 1101 | 13 |
393248 | 393248 | 2020-08-02 | Story | Iowa | 19169 | 1110 | 13 |
396464 | 396464 | 2020-08-03 | Story | Iowa | 19169 | 1109 | 14 |
399680 | 399680 | 2020-08-04 | Story | Iowa | 19169 | 1117 | 14 |
402896 | 402896 | 2020-08-05 | Story | Iowa | 19169 | 1126 | 14 |
406114 | 406114 | 2020-08-06 | Story | Iowa | 19169 | 1141 | 14 |
409334 | 409334 | 2020-08-07 | Story | Iowa | 19169 | 1149 | 14 |
412553 | 412553 | 2020-08-08 | Story | Iowa | 19169 | 1157 | 14 |
415773 | 415773 | 2020-08-09 | Story | Iowa | 19169 | 1166 | 14 |
418994 | 418994 | 2020-08-10 | Story | Iowa | 19169 | 1167 | 14 |
422217 | 422217 | 2020-08-11 | Story | Iowa | 19169 | 1173 | 15 |
425438 | 425438 | 2020-08-12 | Story | Iowa | 19169 | 1181 | 15 |
428662 | 428662 | 2020-08-13 | Story | Iowa | 19169 | 1192 | 15 |
431890 | 431890 | 2020-08-14 | Story | Iowa | 19169 | 1204 | 15 |
435115 | 435115 | 2020-08-15 | Story | Iowa | 19169 | 1382 | 15 |
438341 | 438341 | 2020-08-16 | Story | Iowa | 19169 | 1398 | 15 |
441567 | 441567 | 2020-08-17 | Story | Iowa | 19169 | 1413 | 15 |
444793 | 444793 | 2020-08-18 | Story | Iowa | 19169 | 1420 | 16 |
448020 | 448020 | 2020-08-19 | Story | Iowa | 19169 | 1441 | 16 |
451248 | 451248 | 2020-08-20 | Story | Iowa | 19169 | 1477 | 16 |
454476 | 454476 | 2020-08-21 | Story | Iowa | 19169 | 1531 | 16 |
457704 | 457704 | 2020-08-22 | Story | Iowa | 19169 | 1564 | 16 |
460931 | 460931 | 2020-08-23 | Story | Iowa | 19169 | 1569 | 16 |
464160 | 464160 | 2020-08-24 | Story | Iowa | 19169 | 1609 | 16 |
467389 | 467389 | 2020-08-25 | Story | Iowa | 19169 | 1705 | 16 |
470618 | 470618 | 2020-08-26 | Story | Iowa | 19169 | 1870 | 16 |
473850 | 473850 | 2020-08-27 | Story | Iowa | 19169 | 2079 | 16 |
477083 | 477083 | 2020-08-28 | Story | Iowa | 19169 | 2225 | 16 |
480316 | 480316 | 2020-08-29 | Story | Iowa | 19169 | 2338 | 16 |
483550 | 483550 | 2020-08-30 | Story | Iowa | 19169 | 2362 | 16 |
486785 | 486785 | 2020-08-31 | Story | Iowa | 19169 | 2452 | 16 |
490018 | 490018 | 2020-09-01 | Story | Iowa | 19169 | 2534 | 16 |
493251 | 493251 | 2020-09-02 | Story | Iowa | 19169 | 2584 | 16 |
496485 | 496485 | 2020-09-03 | Story | Iowa | 19169 | 2733 | 16 |
499718 | 499718 | 2020-09-04 | Story | Iowa | 19169 | 2818 | 16 |
502952 | 502952 | 2020-09-05 | Story | Iowa | 19169 | 2875 | 16 |
506186 | 506186 | 2020-09-06 | Story | Iowa | 19169 | 2910 | 16 |
509418 | 509418 | 2020-09-07 | Story | Iowa | 19169 | 2941 | 16 |
512651 | 512651 | 2020-09-08 | Story | Iowa | 19169 | 2966 | 16 |
515884 | 515884 | 2020-09-09 | Story | Iowa | 19169 | 2992 | 16 |
519119 | 519119 | 2020-09-10 | Story | Iowa | 19169 | 3044 | 16 |
522356 | 522356 | 2020-09-11 | Story | Iowa | 19169 | 3090 | 17 |
525592 | 525592 | 2020-09-12 | Story | Iowa | 19169 | 3112 | 17 |
528828 | 528828 | 2020-09-13 | Story | Iowa | 19169 | 3124 | 17 |
532065 | 532065 | 2020-09-14 | Story | Iowa | 19169 | 3154 | 17 |
535300 | 535300 | 2020-09-15 | Story | Iowa | 19169 | 3175 | 17 |
538536 | 538536 | 2020-09-16 | Story | Iowa | 19169 | 3201 | 17 |
541773 | 541773 | 2020-09-17 | Story | Iowa | 19169 | 3238 | 17 |
545009 | 545009 | 2020-09-18 | Story | Iowa | 19169 | 3263 | 17 |
548247 | 548247 | 2020-09-19 | Story | Iowa | 19169 | 3279 | 17 |
551486 | 551486 | 2020-09-20 | Story | Iowa | 19169 | 3286 | 17 |
554725 | 554725 | 2020-09-21 | Story | Iowa | 19169 | 3315 | 17 |
557962 | 557962 | 2020-09-22 | Story | Iowa | 19169 | 3342 | 17 |
561198 | 561198 | 2020-09-23 | Story | Iowa | 19169 | 3374 | 17 |
564438 | 564438 | 2020-09-24 | Story | Iowa | 19169 | 3405 | 17 |
567678 | 567678 | 2020-09-25 | Story | Iowa | 19169 | 3429 | 17 |
570920 | 570920 | 2020-09-26 | Story | Iowa | 19169 | 3444 | 17 |
574163 | 574163 | 2020-09-27 | Story | Iowa | 19169 | 3453 | 17 |
577405 | 577405 | 2020-09-28 | Story | Iowa | 19169 | 3462 | 17 |
580646 | 580646 | 2020-09-29 | Story | Iowa | 19169 | 3485 | 17 |
583885 | 583885 | 2020-09-30 | Story | Iowa | 19169 | 3507 | 17 |
587125 | 587125 | 2020-10-01 | Story | Iowa | 19169 | 3525 | 17 |
590366 | 590366 | 2020-10-02 | Story | Iowa | 19169 | 3545 | 17 |
593607 | 593607 | 2020-10-03 | Story | Iowa | 19169 | 3551 | 17 |
596849 | 596849 | 2020-10-04 | Story | Iowa | 19169 | 3556 | 17 |
600091 | 600091 | 2020-10-05 | Story | Iowa | 19169 | 3576 | 17 |
603334 | 603334 | 2020-10-06 | Story | Iowa | 19169 | 3595 | 17 |
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);