ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
797 rows where fips = 19103 sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 498 ✖
- 14669 7
- 14686 7
- 14736 7
- 14795 7
- 14904 7
- 15066 7
- 15340 7
- 15545 7
- 15885 7
- 16222 7
- 16619 7
- 17004 7
- 17358 7
- 17624 7
- 17809 7
- 18003 7
- 18184 7
- 18461 7
- 18877 7
- 19309 7
- 19840 7
- 20215 7
- 20664 7
- 21083 7
- 21585 7
- 22358 7
- 24040 7
- 26588 7
- 28987 7
- 30972 7
- 32095 7
- 32830 7
- 33279 7
- 33520 7
- 33682 7
- 33776 7
- 33854 7
- 33891 7
- 33934 7
- 34048 7
- 34193 7
- 34367 7
- 34672 7
- 35039 7
- 12906 6
- 14647 4
- 14 3
- 13036 3
- 13138 3
- 14622 3
- 14636 3
- 35541 3
- 15 2
- 22 2
- 574 2
- 591 2
- 607 2
- 614 2
- 615 2
- 625 2
- 630 2
- 638 2
- 14572 2
- 14612 2
- 14613 2
- 14626 2
- 14632 2
- 3 1
- 7 1
- 12 1
- 13 1
- 18 1
- 21 1
- 27 1
- 32 1
- 35 1
- 37 1
- 43 1
- 49 1
- 58 1
- 61 1
- 65 1
- 70 1
- 73 1
- 76 1
- 80 1
- 83 1
- 96 1
- 106 1
- 118 1
- 134 1
- 147 1
- 171 1
- 185 1
- 194 1
- 203 1
- 210 1
- 216 1
- 226 1
- 234 1
- 246 1
- 265 1
- 294 1
- 311 1
- 380 1
- 396 1
- 399 1
- 418 1
- 426 1
- 434 1
- 437 1
- 448 1
- 453 1
- 461 1
- 475 1
- 487 1
- 498 1
- 505 1
- 518 1
- 530 1
- 543 1
- 546 1
- 549 1
- 551 1
- 555 1
- 558 1
- 559 1
- 562 1
- 565 1
- 567 1
- 569 1
- 579 1
- 585 1
- 599 1
- 603 1
- 605 1
- 612 1
- 616 1
- 619 1
- 622 1
- 626 1
- 627 1
- 636 1
- 644 1
- 653 1
- 674 1
- 696 1
- 721 1
- 725 1
- 760 1
- 781 1
- 811 1
- 858 1
- 914 1
- 964 1
- 1016 1
- 1033 1
- 1119 1
- 1150 1
- 1186 1
- 1231 1
- 1243 1
- 1269 1
- 1297 1
- 1314 1
- 1340 1
- 1365 1
- 1385 1
- 1406 1
- 1428 1
- 1479 1
- 1487 1
- 1500 1
- 1543 1
- 1575 1
- 1598 1
- 1609 1
- 1628 1
- 1636 1
- 1651 1
- 1676 1
- 1700 1
- 1720 1
- 1735 1
- 1751 1
- 1766 1
- 1781 1
- 1822 1
- 1856 1
- 1881 1
- 1901 1
- 1918 1
- 1933 1
- 1959 1
- 2002 1
- 2021 1
- 2050 1
- 2063 1
- 2096 1
- 2107 1
- 2118 1
- 2123 1
- 2146 1
- 2165 1
- 2182 1
- 2191 1
- 2208 1
- 2255 1
- 2281 1
- 2311 1
- 2370 1
- 2454 1
- 2538 1
- 2597 1
- 2707 1
- 2944 1
- 3219 1
- 3443 1
- 3644 1
- 3828 1
- 3938 1
- 4051 1
- 4164 1
- 4302 1
- 4421 1
- 4487 1
- 4556 1
- 4581 1
- 4617 1
- 4671 1
- 4722 1
- 4766 1
- 4790 1
- 4810 1
- 4834 1
- 4858 1
- 4891 1
- 4936 1
- 4963 1
- 4985 1
- 4995 1
- 5011 1
- 5029 1
- 5074 1
- 5085 1
- 5100 1
- 5126 1
- 5147 1
- 5170 1
- 5179 1
- 5203 1
- 5220 1
- 5243 1
- 5258 1
- 5264 1
- 5286 1
- 5307 1
- 5345 1
- 5379 1
- 5415 1
- 5445 1
- 5461 1
- 5487 1
- 5504 1
- 5531 1
- 5565 1
- 5586 1
- 5609 1
- 5623 1
- 5638 1
- 5660 1
- 5683 1
- 5735 1
- 5776 1
- 5804 1
- 5844 1
- 5862 1
- 5912 1
- 5969 1
- 6025 1
- 6113 1
- 6189 1
- 6266 1
- 6313 1
- 6375 1
- 6453 1
- 6615 1
- 6726 1
- 6878 1
- 7085 1
- 7335 1
- 7505 1
- 7662 1
- 7829 1
- 7980 1
- 8125 1
- 8198 1
- 8316 1
- 8433 1
- 8555 1
- 8700 1
- 8820 1
- 8954 1
- 9008 1
- 9117 1
- 9207 1
- 9324 1
- 9355 1
- 9401 1
- 9487 1
- 9552 1
- 9643 1
- 9713 1
- 9793 1
- 9855 1
- 9937 1
- 9976 1
- 10009 1
- 10062 1
- 10071 1
- 10128 1
- 10210 1
- 10267 1
- 10310 1
- 10336 1
- 10355 1
- 10391 1
- 10440 1
- 10476 1
- 10529 1
- 10594 1
- 10607 1
- 10649 1
- 10698 1
- 10744 1
- 10779 1
- 10790 1
- 10817 1
- 10854 1
- 10930 1
- 11007 1
- 11071 1
- 11147 1
- 11186 1
- 11234 1
- 11277 1
- 11339 1
- 11397 1
- 11472 1
- 11531 1
- 11590 1
- 11661 1
- 11684 1
- 11743 1
- 11786 1
- 11856 1
- 11917 1
- 11987 1
- 12022 1
- 12047 1
- 12076 1
- 12118 1
- 12160 1
- 12200 1
- 12246 1
- 12285 1
- 12300 1
- 12317 1
- 12344 1
- 12385 1
- 12404 1
- 12414 1
- 12457 1
- 12470 1
- 12494 1
- 12539 1
- 12582 1
- 12614 1
- 12629 1
- 12653 1
- 12669 1
- 12693 1
- 12716 1
- 12752 1
- 12758 1
- 12797 1
- 12811 1
- 12830 1
- 12840 1
- 12863 1
- 12882 1
- 12902 1
- 13013 1
- 13065 1
- 13092 1
- 13109 1
- 13131 1
- 13178 1
- 13190 1
- 13212 1
- 13224 1
- 13233 1
- 13239 1
- 13241 1
- 13259 1
- 13273 1
- 13282 1
- 13297 1
- 13309 1
- 13319 1
- 13335 1
- 13349 1
- 13379 1
- 13402 1
- 13436 1
- 13454 1
- 13473 1
- 13484 1
- 13515 1
- 13544 1
- 13561 1
- 13591 1
- 13630 1
- 13649 1
- 13664 1
- 13688 1
- 13719 1
- 13735 1
- 13778 1
- 13799 1
- 13828 1
- 13867 1
- 13876 1
- 13912 1
- 13956 1
- 13978 1
- 14017 1
- 14042 1
- 14060 1
- 14084 1
- 14113 1
- 14155 1
- 14185 1
- 14206 1
- 14222 1
- 14226 1
- 14243 1
- 14259 1
- 14294 1
- 14320 1
- 14339 1
- 14360 1
- 14367 1
- 14374 1
- 14378 1
- 14394 1
- 14410 1
- 14425 1
- 14438 1
- 14440 1
- 14446 1
- 14454 1
- 14471 1
- 14475 1
- 14483 1
- 14491 1
- 14498 1
- 14502 1
- 14508 1
- 14515 1
- 14521 1
- 14523 1
- 14530 1
- 14532 1
- 14535 1
- 14546 1
- 14554 1
- 14555 1
- 14560 1
- 14566 1
- 14569 1
- 14570 1
- 14577 1
- 14586 1
- 14588 1
- 14590 1
- 14592 1
- 14595 1
- 14596 1
- 14598 1
- 14602 1
- 14605 1
- 14606 1
- 14617 1
- 14623 1
- 14642 1
- 14646 1
- 14650 1
state 1
- Iowa 797
fips 1
- 19103 · 797 ✖
county 1
- Johnson 797
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
797 | 797 | 2020-03-08 | Johnson | Iowa | 19103 | 3 | 0 |
918 | 918 | 2020-03-09 | Johnson | Iowa | 19103 | 7 | 0 |
1063 | 1063 | 2020-03-10 | Johnson | Iowa | 19103 | 12 | 0 |
1241 | 1241 | 2020-03-11 | Johnson | Iowa | 19103 | 13 | 0 |
1456 | 1456 | 2020-03-12 | Johnson | Iowa | 19103 | 14 | 0 |
1728 | 1728 | 2020-03-13 | Johnson | Iowa | 19103 | 14 | 0 |
2062 | 2062 | 2020-03-14 | Johnson | Iowa | 19103 | 14 | 0 |
2457 | 2457 | 2020-03-15 | Johnson | Iowa | 19103 | 15 | 0 |
2902 | 2902 | 2020-03-16 | Johnson | Iowa | 19103 | 15 | 0 |
3395 | 3395 | 2020-03-17 | Johnson | Iowa | 19103 | 18 | 0 |
3969 | 3969 | 2020-03-18 | Johnson | Iowa | 19103 | 21 | 0 |
4649 | 4649 | 2020-03-19 | Johnson | Iowa | 19103 | 22 | 0 |
5460 | 5460 | 2020-03-20 | Johnson | Iowa | 19103 | 22 | 0 |
6403 | 6403 | 2020-03-21 | Johnson | Iowa | 19103 | 27 | 0 |
7464 | 7464 | 2020-03-22 | Johnson | Iowa | 19103 | 32 | 0 |
8623 | 8623 | 2020-03-23 | Johnson | Iowa | 19103 | 35 | 0 |
9902 | 9902 | 2020-03-24 | Johnson | Iowa | 19103 | 37 | 0 |
11299 | 11299 | 2020-03-25 | Johnson | Iowa | 19103 | 43 | 0 |
12863 | 12863 | 2020-03-26 | Johnson | Iowa | 19103 | 49 | 0 |
14555 | 14555 | 2020-03-27 | Johnson | Iowa | 19103 | 58 | 0 |
16359 | 16359 | 2020-03-28 | Johnson | Iowa | 19103 | 61 | 0 |
18264 | 18264 | 2020-03-29 | Johnson | Iowa | 19103 | 65 | 0 |
20274 | 20274 | 2020-03-30 | Johnson | Iowa | 19103 | 70 | 0 |
22370 | 22370 | 2020-03-31 | Johnson | Iowa | 19103 | 73 | 0 |
24542 | 24542 | 2020-04-01 | Johnson | Iowa | 19103 | 76 | 0 |
26784 | 26784 | 2020-04-02 | Johnson | Iowa | 19103 | 80 | 0 |
29095 | 29095 | 2020-04-03 | Johnson | Iowa | 19103 | 83 | 0 |
31465 | 31465 | 2020-04-04 | Johnson | Iowa | 19103 | 96 | 0 |
33878 | 33878 | 2020-04-05 | Johnson | Iowa | 19103 | 106 | 1 |
36333 | 36333 | 2020-04-06 | Johnson | Iowa | 19103 | 118 | 1 |
38834 | 38834 | 2020-04-07 | Johnson | Iowa | 19103 | 134 | 1 |
41380 | 41380 | 2020-04-08 | Johnson | Iowa | 19103 | 147 | 1 |
43956 | 43956 | 2020-04-09 | Johnson | Iowa | 19103 | 171 | 1 |
46561 | 46561 | 2020-04-10 | Johnson | Iowa | 19103 | 185 | 1 |
49195 | 49195 | 2020-04-11 | Johnson | Iowa | 19103 | 194 | 2 |
51859 | 51859 | 2020-04-12 | Johnson | Iowa | 19103 | 203 | 2 |
54541 | 54541 | 2020-04-13 | Johnson | Iowa | 19103 | 210 | 2 |
57234 | 57234 | 2020-04-14 | Johnson | Iowa | 19103 | 216 | 2 |
59942 | 59942 | 2020-04-15 | Johnson | Iowa | 19103 | 226 | 3 |
62663 | 62663 | 2020-04-16 | Johnson | Iowa | 19103 | 234 | 3 |
65397 | 65397 | 2020-04-17 | Johnson | Iowa | 19103 | 246 | 3 |
68146 | 68146 | 2020-04-18 | Johnson | Iowa | 19103 | 265 | 3 |
70908 | 70908 | 2020-04-19 | Johnson | Iowa | 19103 | 294 | 3 |
73679 | 73679 | 2020-04-20 | Johnson | Iowa | 19103 | 311 | 3 |
76458 | 76458 | 2020-04-21 | Johnson | Iowa | 19103 | 380 | 3 |
79242 | 79242 | 2020-04-22 | Johnson | Iowa | 19103 | 396 | 3 |
82035 | 82035 | 2020-04-23 | Johnson | Iowa | 19103 | 399 | 3 |
84835 | 84835 | 2020-04-24 | Johnson | Iowa | 19103 | 418 | 3 |
87645 | 87645 | 2020-04-25 | Johnson | Iowa | 19103 | 426 | 4 |
90461 | 90461 | 2020-04-26 | Johnson | Iowa | 19103 | 434 | 6 |
93280 | 93280 | 2020-04-27 | Johnson | Iowa | 19103 | 437 | 6 |
96112 | 96112 | 2020-04-28 | Johnson | Iowa | 19103 | 448 | 6 |
98957 | 98957 | 2020-04-29 | Johnson | Iowa | 19103 | 453 | 6 |
101808 | 101808 | 2020-04-30 | Johnson | Iowa | 19103 | 461 | 6 |
104666 | 104666 | 2020-05-01 | Johnson | Iowa | 19103 | 475 | 6 |
107531 | 107531 | 2020-05-02 | Johnson | Iowa | 19103 | 487 | 6 |
110401 | 110401 | 2020-05-03 | Johnson | Iowa | 19103 | 498 | 6 |
113276 | 113276 | 2020-05-04 | Johnson | Iowa | 19103 | 505 | 6 |
116159 | 116159 | 2020-05-05 | Johnson | Iowa | 19103 | 518 | 6 |
119119 | 119119 | 2020-05-06 | Johnson | Iowa | 19103 | 530 | 6 |
122089 | 122089 | 2020-05-07 | Johnson | Iowa | 19103 | 543 | 6 |
125070 | 125070 | 2020-05-08 | Johnson | Iowa | 19103 | 546 | 6 |
128057 | 128057 | 2020-05-09 | Johnson | Iowa | 19103 | 549 | 7 |
131048 | 131048 | 2020-05-10 | Johnson | Iowa | 19103 | 551 | 7 |
134038 | 134038 | 2020-05-11 | Johnson | Iowa | 19103 | 555 | 7 |
137028 | 137028 | 2020-05-12 | Johnson | Iowa | 19103 | 559 | 7 |
140021 | 140021 | 2020-05-13 | Johnson | Iowa | 19103 | 558 | 7 |
143017 | 143017 | 2020-05-14 | Johnson | Iowa | 19103 | 562 | 7 |
146017 | 146017 | 2020-05-15 | Johnson | Iowa | 19103 | 565 | 7 |
149021 | 149021 | 2020-05-16 | Johnson | Iowa | 19103 | 567 | 7 |
152031 | 152031 | 2020-05-17 | Johnson | Iowa | 19103 | 569 | 7 |
155043 | 155043 | 2020-05-18 | Johnson | Iowa | 19103 | 574 | 7 |
158059 | 158059 | 2020-05-19 | Johnson | Iowa | 19103 | 574 | 7 |
161085 | 161085 | 2020-05-20 | Johnson | Iowa | 19103 | 579 | 7 |
164113 | 164113 | 2020-05-21 | Johnson | Iowa | 19103 | 585 | 7 |
167146 | 167146 | 2020-05-22 | Johnson | Iowa | 19103 | 591 | 7 |
170183 | 170183 | 2020-05-23 | Johnson | Iowa | 19103 | 591 | 7 |
173224 | 173224 | 2020-05-24 | Johnson | Iowa | 19103 | 599 | 7 |
176268 | 176268 | 2020-05-25 | Johnson | Iowa | 19103 | 603 | 7 |
179312 | 179312 | 2020-05-26 | Johnson | Iowa | 19103 | 605 | 7 |
182357 | 182357 | 2020-05-27 | Johnson | Iowa | 19103 | 607 | 8 |
185411 | 185411 | 2020-05-28 | Johnson | Iowa | 19103 | 607 | 8 |
209981 | 209981 | 2020-06-05 | Johnson | Iowa | 19103 | 622 | 8 |
213066 | 213066 | 2020-06-06 | Johnson | Iowa | 19103 | 625 | 8 |
216153 | 216153 | 2020-06-07 | Johnson | Iowa | 19103 | 626 | 8 |
219245 | 219245 | 2020-06-08 | Johnson | Iowa | 19103 | 627 | 8 |
222340 | 222340 | 2020-06-09 | Johnson | Iowa | 19103 | 630 | 8 |
225435 | 225435 | 2020-06-10 | Johnson | Iowa | 19103 | 625 | 8 |
228537 | 228537 | 2020-06-11 | Johnson | Iowa | 19103 | 630 | 8 |
231640 | 231640 | 2020-06-12 | Johnson | Iowa | 19103 | 636 | 8 |
234746 | 234746 | 2020-06-13 | Johnson | Iowa | 19103 | 638 | 8 |
237853 | 237853 | 2020-06-14 | Johnson | Iowa | 19103 | 638 | 8 |
240961 | 240961 | 2020-06-15 | Johnson | Iowa | 19103 | 644 | 8 |
244072 | 244072 | 2020-06-16 | Johnson | Iowa | 19103 | 653 | 8 |
247185 | 247185 | 2020-06-17 | Johnson | Iowa | 19103 | 674 | 8 |
250297 | 250297 | 2020-06-18 | Johnson | Iowa | 19103 | 696 | 8 |
253412 | 253412 | 2020-06-19 | Johnson | Iowa | 19103 | 721 | 8 |
256532 | 256532 | 2020-06-20 | Johnson | Iowa | 19103 | 725 | 8 |
259658 | 259658 | 2020-06-21 | Johnson | Iowa | 19103 | 760 | 8 |
262785 | 262785 | 2020-06-22 | Johnson | Iowa | 19103 | 781 | 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);