ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
797 rows where county = "Johnson" and state = "Iowa" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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 |
188469 | 188469 | 2020-05-29 | Johnson | Iowa | 19103 | 612 | 9 |
191534 | 191534 | 2020-05-30 | Johnson | Iowa | 19103 | 614 | 9 |
194601 | 194601 | 2020-05-31 | Johnson | Iowa | 19103 | 615 | 9 |
197671 | 197671 | 2020-06-01 | Johnson | Iowa | 19103 | 614 | 9 |
200744 | 200744 | 2020-06-02 | Johnson | Iowa | 19103 | 615 | 9 |
203820 | 203820 | 2020-06-03 | Johnson | Iowa | 19103 | 616 | 9 |
206900 | 206900 | 2020-06-04 | Johnson | Iowa | 19103 | 619 | 9 |
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 |
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);