ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Polk" 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 |
---|---|---|---|---|---|---|---|
2458 | 2458 | 2020-03-15 | Polk | Iowa | 19153 | 1 | 0 |
2903 | 2903 | 2020-03-16 | Polk | Iowa | 19153 | 1 | 0 |
3396 | 3396 | 2020-03-17 | Polk | Iowa | 19153 | 1 | 0 |
3970 | 3970 | 2020-03-18 | Polk | Iowa | 19153 | 3 | 0 |
4651 | 4651 | 2020-03-19 | Polk | Iowa | 19153 | 6 | 0 |
5462 | 5462 | 2020-03-20 | Polk | Iowa | 19153 | 6 | 0 |
6406 | 6406 | 2020-03-21 | Polk | Iowa | 19153 | 10 | 0 |
7468 | 7468 | 2020-03-22 | Polk | Iowa | 19153 | 10 | 0 |
8627 | 8627 | 2020-03-23 | Polk | Iowa | 19153 | 12 | 0 |
9906 | 9906 | 2020-03-24 | Polk | Iowa | 19153 | 17 | 0 |
11303 | 11303 | 2020-03-25 | Polk | Iowa | 19153 | 20 | 0 |
12870 | 12870 | 2020-03-26 | Polk | Iowa | 19153 | 24 | 0 |
14564 | 14564 | 2020-03-27 | Polk | Iowa | 19153 | 28 | 0 |
16369 | 16369 | 2020-03-28 | Polk | Iowa | 19153 | 40 | 0 |
18274 | 18274 | 2020-03-29 | Polk | Iowa | 19153 | 50 | 0 |
20285 | 20285 | 2020-03-30 | Polk | Iowa | 19153 | 61 | 0 |
22381 | 22381 | 2020-03-31 | Polk | Iowa | 19153 | 76 | 0 |
24555 | 24555 | 2020-04-01 | Polk | Iowa | 19153 | 81 | 1 |
26798 | 26798 | 2020-04-02 | Polk | Iowa | 19153 | 87 | 1 |
29112 | 29112 | 2020-04-03 | Polk | Iowa | 19153 | 100 | 1 |
31484 | 31484 | 2020-04-04 | Polk | Iowa | 19153 | 109 | 1 |
33897 | 33897 | 2020-04-05 | Polk | Iowa | 19153 | 122 | 5 |
36353 | 36353 | 2020-04-06 | Polk | Iowa | 19153 | 125 | 5 |
38854 | 38854 | 2020-04-07 | Polk | Iowa | 19153 | 127 | 5 |
41400 | 41400 | 2020-04-08 | Polk | Iowa | 19153 | 134 | 5 |
43976 | 43976 | 2020-04-09 | Polk | Iowa | 19153 | 140 | 5 |
46582 | 46582 | 2020-04-10 | Polk | Iowa | 19153 | 147 | 5 |
49216 | 49216 | 2020-04-11 | Polk | Iowa | 19153 | 163 | 5 |
51880 | 51880 | 2020-04-12 | Polk | Iowa | 19153 | 177 | 5 |
54562 | 54562 | 2020-04-13 | Polk | Iowa | 19153 | 195 | 5 |
57255 | 57255 | 2020-04-14 | Polk | Iowa | 19153 | 213 | 5 |
59963 | 59963 | 2020-04-15 | Polk | Iowa | 19153 | 224 | 7 |
62684 | 62684 | 2020-04-16 | Polk | Iowa | 19153 | 256 | 10 |
65418 | 65418 | 2020-04-17 | Polk | Iowa | 19153 | 277 | 10 |
68167 | 68167 | 2020-04-18 | Polk | Iowa | 19153 | 293 | 13 |
70929 | 70929 | 2020-04-19 | Polk | Iowa | 19153 | 333 | 13 |
73700 | 73700 | 2020-04-20 | Polk | Iowa | 19153 | 387 | 13 |
76479 | 76479 | 2020-04-21 | Polk | Iowa | 19153 | 415 | 15 |
79263 | 79263 | 2020-04-22 | Polk | Iowa | 19153 | 438 | 16 |
82056 | 82056 | 2020-04-23 | Polk | Iowa | 19153 | 486 | 20 |
84856 | 84856 | 2020-04-24 | Polk | Iowa | 19153 | 575 | 22 |
87666 | 87666 | 2020-04-25 | Polk | Iowa | 19153 | 660 | 24 |
90482 | 90482 | 2020-04-26 | Polk | Iowa | 19153 | 732 | 24 |
93302 | 93302 | 2020-04-27 | Polk | Iowa | 19153 | 756 | 27 |
96134 | 96134 | 2020-04-28 | Polk | Iowa | 19153 | 813 | 31 |
98979 | 98979 | 2020-04-29 | Polk | Iowa | 19153 | 905 | 32 |
101830 | 101830 | 2020-04-30 | Polk | Iowa | 19153 | 985 | 35 |
104688 | 104688 | 2020-05-01 | Polk | Iowa | 19153 | 1176 | 37 |
107553 | 107553 | 2020-05-02 | Polk | Iowa | 19153 | 1350 | 38 |
110424 | 110424 | 2020-05-03 | Polk | Iowa | 19153 | 1476 | 40 |
113299 | 113299 | 2020-05-04 | Polk | Iowa | 19153 | 1661 | 40 |
116182 | 116182 | 2020-05-05 | Polk | Iowa | 19153 | 1778 | 42 |
119142 | 119142 | 2020-05-06 | Polk | Iowa | 19153 | 1875 | 45 |
122112 | 122112 | 2020-05-07 | Polk | Iowa | 19153 | 2053 | 54 |
125094 | 125094 | 2020-05-08 | Polk | Iowa | 19153 | 2150 | 54 |
128081 | 128081 | 2020-05-09 | Polk | Iowa | 19153 | 2194 | 58 |
131072 | 131072 | 2020-05-10 | Polk | Iowa | 19153 | 2238 | 60 |
134062 | 134062 | 2020-05-11 | Polk | Iowa | 19153 | 2368 | 61 |
137052 | 137052 | 2020-05-12 | Polk | Iowa | 19153 | 2447 | 64 |
140045 | 140045 | 2020-05-13 | Polk | Iowa | 19153 | 2551 | 65 |
143041 | 143041 | 2020-05-14 | Polk | Iowa | 19153 | 2634 | 67 |
146041 | 146041 | 2020-05-15 | Polk | Iowa | 19153 | 2767 | 76 |
149045 | 149045 | 2020-05-16 | Polk | Iowa | 19153 | 2845 | 78 |
152056 | 152056 | 2020-05-17 | Polk | Iowa | 19153 | 2922 | 79 |
155068 | 155068 | 2020-05-18 | Polk | Iowa | 19153 | 3001 | 81 |
158084 | 158084 | 2020-05-19 | Polk | Iowa | 19153 | 3128 | 83 |
161110 | 161110 | 2020-05-20 | Polk | Iowa | 19153 | 3298 | 90 |
164138 | 164138 | 2020-05-21 | Polk | Iowa | 19153 | 3381 | 91 |
167171 | 167171 | 2020-05-22 | Polk | Iowa | 19153 | 3525 | 105 |
170208 | 170208 | 2020-05-23 | Polk | Iowa | 19153 | 3525 | 105 |
173249 | 173249 | 2020-05-24 | Polk | Iowa | 19153 | 3744 | 108 |
176293 | 176293 | 2020-05-25 | Polk | Iowa | 19153 | 3795 | 109 |
179337 | 179337 | 2020-05-26 | Polk | Iowa | 19153 | 3833 | 112 |
182382 | 182382 | 2020-05-27 | Polk | Iowa | 19153 | 3890 | 115 |
185436 | 185436 | 2020-05-28 | Polk | Iowa | 19153 | 3959 | 119 |
188494 | 188494 | 2020-05-29 | Polk | Iowa | 19153 | 4072 | 123 |
191559 | 191559 | 2020-05-30 | Polk | Iowa | 19153 | 4189 | 125 |
194626 | 194626 | 2020-05-31 | Polk | Iowa | 19153 | 4239 | 126 |
197696 | 197696 | 2020-06-01 | Polk | Iowa | 19153 | 4269 | 133 |
200769 | 200769 | 2020-06-02 | Polk | Iowa | 19153 | 4344 | 133 |
203845 | 203845 | 2020-06-03 | Polk | Iowa | 19153 | 4418 | 134 |
206925 | 206925 | 2020-06-04 | Polk | Iowa | 19153 | 4565 | 139 |
210006 | 210006 | 2020-06-05 | Polk | Iowa | 19153 | 4650 | 142 |
213091 | 213091 | 2020-06-06 | Polk | Iowa | 19153 | 4691 | 143 |
216178 | 216178 | 2020-06-07 | Polk | Iowa | 19153 | 4750 | 144 |
219270 | 219270 | 2020-06-08 | Polk | Iowa | 19153 | 4841 | 150 |
222365 | 222365 | 2020-06-09 | Polk | Iowa | 19153 | 4868 | 151 |
225460 | 225460 | 2020-06-10 | Polk | Iowa | 19153 | 4924 | 155 |
228562 | 228562 | 2020-06-11 | Polk | Iowa | 19153 | 4991 | 156 |
231665 | 231665 | 2020-06-12 | Polk | Iowa | 19153 | 5046 | 159 |
234771 | 234771 | 2020-06-13 | Polk | Iowa | 19153 | 5119 | 160 |
237878 | 237878 | 2020-06-14 | Polk | Iowa | 19153 | 5169 | 161 |
240986 | 240986 | 2020-06-15 | Polk | Iowa | 19153 | 5180 | 163 |
244097 | 244097 | 2020-06-16 | Polk | Iowa | 19153 | 5210 | 163 |
247210 | 247210 | 2020-06-17 | Polk | Iowa | 19153 | 5276 | 164 |
250322 | 250322 | 2020-06-18 | Polk | Iowa | 19153 | 5323 | 165 |
253437 | 253437 | 2020-06-19 | Polk | Iowa | 19153 | 5410 | 165 |
256557 | 256557 | 2020-06-20 | Polk | Iowa | 19153 | 5436 | 166 |
259683 | 259683 | 2020-06-21 | Polk | Iowa | 19153 | 5508 | 167 |
262810 | 262810 | 2020-06-22 | Polk | Iowa | 19153 | 5548 | 168 |
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);