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 date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535292 | 535292 | 2020-09-15 | Polk | Iowa | 19153 | 14830 | 253 |
532057 | 532057 | 2020-09-14 | Polk | Iowa | 19153 | 14746 | 253 |
528820 | 528820 | 2020-09-13 | Polk | Iowa | 19153 | 14698 | 252 |
525584 | 525584 | 2020-09-12 | Polk | Iowa | 19153 | 14618 | 252 |
522348 | 522348 | 2020-09-11 | Polk | Iowa | 19153 | 14471 | 251 |
519111 | 519111 | 2020-09-10 | Polk | Iowa | 19153 | 14343 | 248 |
515876 | 515876 | 2020-09-09 | Polk | Iowa | 19153 | 14219 | 248 |
512643 | 512643 | 2020-09-08 | Polk | Iowa | 19153 | 14158 | 246 |
509410 | 509410 | 2020-09-07 | Polk | Iowa | 19153 | 14110 | 243 |
506178 | 506178 | 2020-09-06 | Polk | Iowa | 19153 | 14072 | 243 |
502944 | 502944 | 2020-09-05 | Polk | Iowa | 19153 | 13993 | 243 |
499710 | 499710 | 2020-09-04 | Polk | Iowa | 19153 | 13859 | 240 |
496477 | 496477 | 2020-09-03 | Polk | Iowa | 19153 | 13733 | 227 |
493243 | 493243 | 2020-09-02 | Polk | Iowa | 19153 | 13547 | 227 |
490010 | 490010 | 2020-09-01 | Polk | Iowa | 19153 | 13465 | 226 |
486777 | 486777 | 2020-08-31 | Polk | Iowa | 19153 | 13385 | 225 |
483542 | 483542 | 2020-08-30 | Polk | Iowa | 19153 | 13292 | 225 |
480308 | 480308 | 2020-08-29 | Polk | Iowa | 19153 | 13179 | 225 |
477075 | 477075 | 2020-08-28 | Polk | Iowa | 19153 | 13039 | 226 |
473842 | 473842 | 2020-08-27 | Polk | Iowa | 19153 | 12792 | 222 |
470610 | 470610 | 2020-08-26 | Polk | Iowa | 19153 | 12087 | 221 |
467381 | 467381 | 2020-08-25 | Polk | Iowa | 19153 | 11954 | 218 |
464152 | 464152 | 2020-08-24 | Polk | Iowa | 19153 | 11841 | 217 |
460923 | 460923 | 2020-08-23 | Polk | Iowa | 19153 | 11751 | 214 |
457696 | 457696 | 2020-08-22 | Polk | Iowa | 19153 | 11653 | 214 |
454468 | 454468 | 2020-08-21 | Polk | Iowa | 19153 | 11546 | 214 |
451240 | 451240 | 2020-08-20 | Polk | Iowa | 19153 | 11436 | 212 |
448012 | 448012 | 2020-08-19 | Polk | Iowa | 19153 | 11226 | 212 |
444785 | 444785 | 2020-08-18 | Polk | Iowa | 19153 | 11101 | 212 |
441559 | 441559 | 2020-08-17 | Polk | Iowa | 19153 | 11036 | 211 |
438333 | 438333 | 2020-08-16 | Polk | Iowa | 19153 | 10983 | 211 |
435107 | 435107 | 2020-08-15 | Polk | Iowa | 19153 | 10921 | 211 |
431882 | 431882 | 2020-08-14 | Polk | Iowa | 19153 | 10806 | 210 |
428654 | 428654 | 2020-08-13 | Polk | Iowa | 19153 | 10673 | 210 |
425430 | 425430 | 2020-08-12 | Polk | Iowa | 19153 | 10535 | 208 |
422209 | 422209 | 2020-08-11 | Polk | Iowa | 19153 | 10444 | 208 |
418986 | 418986 | 2020-08-10 | Polk | Iowa | 19153 | 10351 | 207 |
415765 | 415765 | 2020-08-09 | Polk | Iowa | 19153 | 10309 | 207 |
412545 | 412545 | 2020-08-08 | Polk | Iowa | 19153 | 10159 | 207 |
409326 | 409326 | 2020-08-07 | Polk | Iowa | 19153 | 10118 | 206 |
406106 | 406106 | 2020-08-06 | Polk | Iowa | 19153 | 10032 | 206 |
402888 | 402888 | 2020-08-05 | Polk | Iowa | 19153 | 9874 | 204 |
399672 | 399672 | 2020-08-04 | Polk | Iowa | 19153 | 9781 | 203 |
396456 | 396456 | 2020-08-03 | Polk | Iowa | 19153 | 9723 | 203 |
393240 | 393240 | 2020-08-02 | Polk | Iowa | 19153 | 9709 | 202 |
390023 | 390023 | 2020-08-01 | Polk | Iowa | 19153 | 9609 | 202 |
386806 | 386806 | 2020-07-31 | Polk | Iowa | 19153 | 9479 | 201 |
383588 | 383588 | 2020-07-30 | Polk | Iowa | 19153 | 9388 | 201 |
380371 | 380371 | 2020-07-29 | Polk | Iowa | 19153 | 9262 | 193 |
377154 | 377154 | 2020-07-28 | Polk | Iowa | 19153 | 9126 | 193 |
373939 | 373939 | 2020-07-27 | Polk | Iowa | 19153 | 9109 | 193 |
370727 | 370727 | 2020-07-26 | Polk | Iowa | 19153 | 9080 | 191 |
367517 | 367517 | 2020-07-25 | Polk | Iowa | 19153 | 8985 | 191 |
364310 | 364310 | 2020-07-24 | Polk | Iowa | 19153 | 8906 | 191 |
361103 | 361103 | 2020-07-23 | Polk | Iowa | 19153 | 8786 | 191 |
357898 | 357898 | 2020-07-22 | Polk | Iowa | 19153 | 8644 | 191 |
354696 | 354696 | 2020-07-21 | Polk | Iowa | 19153 | 8557 | 189 |
351494 | 351494 | 2020-07-20 | Polk | Iowa | 19153 | 8465 | 189 |
348294 | 348294 | 2020-07-19 | Polk | Iowa | 19153 | 8354 | 189 |
345093 | 345093 | 2020-07-18 | Polk | Iowa | 19153 | 8244 | 189 |
341893 | 341893 | 2020-07-17 | Polk | Iowa | 19153 | 8121 | 188 |
338697 | 338697 | 2020-07-16 | Polk | Iowa | 19153 | 8001 | 188 |
335501 | 335501 | 2020-07-15 | Polk | Iowa | 19153 | 7803 | 188 |
332308 | 332308 | 2020-07-14 | Polk | Iowa | 19153 | 7679 | 186 |
329121 | 329121 | 2020-07-13 | Polk | Iowa | 19153 | 7611 | 185 |
325935 | 325935 | 2020-07-12 | Polk | Iowa | 19153 | 7538 | 185 |
322754 | 322754 | 2020-07-11 | Polk | Iowa | 19153 | 7334 | 184 |
319575 | 319575 | 2020-07-10 | Polk | Iowa | 19153 | 7212 | 184 |
316402 | 316402 | 2020-07-09 | Polk | Iowa | 19153 | 7002 | 182 |
313228 | 313228 | 2020-07-08 | Polk | Iowa | 19153 | 6846 | 182 |
310058 | 310058 | 2020-07-07 | Polk | Iowa | 19153 | 6739 | 181 |
306890 | 306890 | 2020-07-06 | Polk | Iowa | 19153 | 6638 | 180 |
303725 | 303725 | 2020-07-05 | Polk | Iowa | 19153 | 6614 | 179 |
300561 | 300561 | 2020-07-04 | Polk | Iowa | 19153 | 6494 | 179 |
297399 | 297399 | 2020-07-03 | Polk | Iowa | 19153 | 6366 | 179 |
294241 | 294241 | 2020-07-02 | Polk | Iowa | 19153 | 6275 | 178 |
291087 | 291087 | 2020-07-01 | Polk | Iowa | 19153 | 6139 | 178 |
287937 | 287937 | 2020-06-30 | Polk | Iowa | 19153 | 6046 | 177 |
284788 | 284788 | 2020-06-29 | Polk | Iowa | 19153 | 6007 | 177 |
281643 | 281643 | 2020-06-28 | Polk | Iowa | 19153 | 5947 | 174 |
278495 | 278495 | 2020-06-27 | Polk | Iowa | 19153 | 5881 | 174 |
275347 | 275347 | 2020-06-26 | Polk | Iowa | 19153 | 5800 | 174 |
272205 | 272205 | 2020-06-25 | Polk | Iowa | 19153 | 5738 | 174 |
269068 | 269068 | 2020-06-24 | Polk | Iowa | 19153 | 5645 | 171 |
265938 | 265938 | 2020-06-23 | Polk | Iowa | 19153 | 5582 | 169 |
262810 | 262810 | 2020-06-22 | Polk | Iowa | 19153 | 5548 | 168 |
259683 | 259683 | 2020-06-21 | Polk | Iowa | 19153 | 5508 | 167 |
256557 | 256557 | 2020-06-20 | Polk | Iowa | 19153 | 5436 | 166 |
253437 | 253437 | 2020-06-19 | Polk | Iowa | 19153 | 5410 | 165 |
250322 | 250322 | 2020-06-18 | Polk | Iowa | 19153 | 5323 | 165 |
247210 | 247210 | 2020-06-17 | Polk | Iowa | 19153 | 5276 | 164 |
244097 | 244097 | 2020-06-16 | Polk | Iowa | 19153 | 5210 | 163 |
240986 | 240986 | 2020-06-15 | Polk | Iowa | 19153 | 5180 | 163 |
237878 | 237878 | 2020-06-14 | Polk | Iowa | 19153 | 5169 | 161 |
234771 | 234771 | 2020-06-13 | Polk | Iowa | 19153 | 5119 | 160 |
231665 | 231665 | 2020-06-12 | Polk | Iowa | 19153 | 5046 | 159 |
228562 | 228562 | 2020-06-11 | Polk | Iowa | 19153 | 4991 | 156 |
225460 | 225460 | 2020-06-10 | Polk | Iowa | 19153 | 4924 | 155 |
222365 | 222365 | 2020-06-09 | Polk | Iowa | 19153 | 4868 | 151 |
219270 | 219270 | 2020-06-08 | Polk | Iowa | 19153 | 4841 | 150 |
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);