ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Polk" and fips = 19153 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635755 | 635755 | 2020-10-16 | Polk | Iowa | 19153 | 17754 | 281 |
632509 | 632509 | 2020-10-15 | Polk | Iowa | 19153 | 17587 | 281 |
629265 | 629265 | 2020-10-14 | Polk | Iowa | 19153 | 17467 | 278 |
626022 | 626022 | 2020-10-13 | Polk | Iowa | 19153 | 17348 | 277 |
622780 | 622780 | 2020-10-12 | Polk | Iowa | 19153 | 17239 | 277 |
619536 | 619536 | 2020-10-11 | Polk | Iowa | 19153 | 17184 | 276 |
616294 | 616294 | 2020-10-10 | Polk | Iowa | 19153 | 17085 | 276 |
613053 | 613053 | 2020-10-09 | Polk | Iowa | 19153 | 16947 | 276 |
609811 | 609811 | 2020-10-08 | Polk | Iowa | 19153 | 16828 | 272 |
606568 | 606568 | 2020-10-07 | Polk | Iowa | 19153 | 16709 | 271 |
603326 | 603326 | 2020-10-06 | Polk | Iowa | 19153 | 16587 | 271 |
600083 | 600083 | 2020-10-05 | Polk | Iowa | 19153 | 16534 | 271 |
596841 | 596841 | 2020-10-04 | Polk | Iowa | 19153 | 16484 | 271 |
593599 | 593599 | 2020-10-03 | Polk | Iowa | 19153 | 16450 | 270 |
590358 | 590358 | 2020-10-02 | Polk | Iowa | 19153 | 16406 | 270 |
587117 | 587117 | 2020-10-01 | Polk | Iowa | 19153 | 16304 | 266 |
583877 | 583877 | 2020-09-30 | Polk | Iowa | 19153 | 16203 | 264 |
580638 | 580638 | 2020-09-29 | Polk | Iowa | 19153 | 16113 | 264 |
577397 | 577397 | 2020-09-28 | Polk | Iowa | 19153 | 16011 | 262 |
574155 | 574155 | 2020-09-27 | Polk | Iowa | 19153 | 15962 | 262 |
570912 | 570912 | 2020-09-26 | Polk | Iowa | 19153 | 15872 | 262 |
567670 | 567670 | 2020-09-25 | Polk | Iowa | 19153 | 15779 | 262 |
564430 | 564430 | 2020-09-24 | Polk | Iowa | 19153 | 15697 | 261 |
561190 | 561190 | 2020-09-23 | Polk | Iowa | 19153 | 15581 | 261 |
557954 | 557954 | 2020-09-22 | Polk | Iowa | 19153 | 15409 | 259 |
554717 | 554717 | 2020-09-21 | Polk | Iowa | 19153 | 15366 | 259 |
551478 | 551478 | 2020-09-20 | Polk | Iowa | 19153 | 15319 | 256 |
548239 | 548239 | 2020-09-19 | Polk | Iowa | 19153 | 15227 | 256 |
545001 | 545001 | 2020-09-18 | Polk | Iowa | 19153 | 15132 | 256 |
541765 | 541765 | 2020-09-17 | Polk | Iowa | 19153 | 15048 | 256 |
538528 | 538528 | 2020-09-16 | Polk | Iowa | 19153 | 14933 | 255 |
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 |
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);