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 |
---|---|---|---|---|---|---|---|
908328 | 908328 | 2021-01-08 | Polk | Iowa | 19153 | 43511 | 424 |
905082 | 905082 | 2021-01-07 | Polk | Iowa | 19153 | 43303 | 421 |
901837 | 901837 | 2021-01-06 | Polk | Iowa | 19153 | 42888 | 421 |
898592 | 898592 | 2021-01-05 | Polk | Iowa | 19153 | 42504 | 419 |
895347 | 895347 | 2021-01-04 | Polk | Iowa | 19153 | 42177 | 419 |
892100 | 892100 | 2021-01-03 | Polk | Iowa | 19153 | 41943 | 413 |
888854 | 888854 | 2021-01-02 | Polk | Iowa | 19153 | 41749 | 413 |
885608 | 885608 | 2021-01-01 | Polk | Iowa | 19153 | 41670 | 412 |
882363 | 882363 | 2020-12-31 | Polk | Iowa | 19153 | 41499 | 410 |
879118 | 879118 | 2020-12-30 | Polk | Iowa | 19153 | 41183 | 408 |
875873 | 875873 | 2020-12-29 | Polk | Iowa | 19153 | 40941 | 407 |
872628 | 872628 | 2020-12-28 | Polk | Iowa | 19153 | 40757 | 406 |
869383 | 869383 | 2020-12-27 | Polk | Iowa | 19153 | 40537 | 406 |
866138 | 866138 | 2020-12-26 | Polk | Iowa | 19153 | 40482 | 406 |
862893 | 862893 | 2020-12-25 | Polk | Iowa | 19153 | 40411 | 406 |
859648 | 859648 | 2020-12-24 | Polk | Iowa | 19153 | 40318 | 406 |
856403 | 856403 | 2020-12-23 | Polk | Iowa | 19153 | 40049 | 401 |
853158 | 853158 | 2020-12-22 | Polk | Iowa | 19153 | 39809 | 400 |
849913 | 849913 | 2020-12-21 | Polk | Iowa | 19153 | 39562 | 396 |
846668 | 846668 | 2020-12-20 | Polk | Iowa | 19153 | 39314 | 396 |
843422 | 843422 | 2020-12-19 | Polk | Iowa | 19153 | 39284 | 393 |
840177 | 840177 | 2020-12-18 | Polk | Iowa | 19153 | 38897 | 385 |
836932 | 836932 | 2020-12-17 | Polk | Iowa | 19153 | 38518 | 385 |
833686 | 833686 | 2020-12-16 | Polk | Iowa | 19153 | 38254 | 380 |
830439 | 830439 | 2020-12-15 | Polk | Iowa | 19153 | 37812 | 379 |
827193 | 827193 | 2020-12-14 | Polk | Iowa | 19153 | 37634 | 371 |
823946 | 823946 | 2020-12-13 | Polk | Iowa | 19153 | 37530 | 368 |
820700 | 820700 | 2020-12-12 | Polk | Iowa | 19153 | 37334 | 368 |
817454 | 817454 | 2020-12-11 | Polk | Iowa | 19153 | 37132 | 368 |
814208 | 814208 | 2020-12-10 | Polk | Iowa | 19153 | 36754 | 362 |
810963 | 810963 | 2020-12-09 | Polk | Iowa | 19153 | 36369 | 360 |
807718 | 807718 | 2020-12-08 | Polk | Iowa | 19153 | 36061 | 355 |
804473 | 804473 | 2020-12-07 | Polk | Iowa | 19153 | 36014 | 357 |
801228 | 801228 | 2020-12-06 | Polk | Iowa | 19153 | 35868 | 357 |
797983 | 797983 | 2020-12-05 | Polk | Iowa | 19153 | 35702 | 353 |
794738 | 794738 | 2020-12-04 | Polk | Iowa | 19153 | 35389 | 352 |
791493 | 791493 | 2020-12-03 | Polk | Iowa | 19153 | 34871 | 347 |
788248 | 788248 | 2020-12-02 | Polk | Iowa | 19153 | 34631 | 341 |
785004 | 785004 | 2020-12-01 | Polk | Iowa | 19153 | 34208 | 339 |
781759 | 781759 | 2020-11-30 | Polk | Iowa | 19153 | 33895 | 336 |
778513 | 778513 | 2020-11-29 | Polk | Iowa | 19153 | 33642 | 336 |
775268 | 775268 | 2020-11-28 | Polk | Iowa | 19153 | 33451 | 334 |
772023 | 772023 | 2020-11-27 | Polk | Iowa | 19153 | 33165 | 333 |
768778 | 768778 | 2020-11-26 | Polk | Iowa | 19153 | 33019 | 331 |
765532 | 765532 | 2020-11-25 | Polk | Iowa | 19153 | 32695 | 327 |
762287 | 762287 | 2020-11-24 | Polk | Iowa | 19153 | 32245 | 325 |
759042 | 759042 | 2020-11-23 | Polk | Iowa | 19153 | 31705 | 324 |
755795 | 755795 | 2020-11-22 | Polk | Iowa | 19153 | 31270 | 322 |
752549 | 752549 | 2020-11-21 | Polk | Iowa | 19153 | 30796 | 322 |
749303 | 749303 | 2020-11-20 | Polk | Iowa | 19153 | 30368 | 319 |
746057 | 746057 | 2020-11-19 | Polk | Iowa | 19153 | 29699 | 317 |
742810 | 742810 | 2020-11-18 | Polk | Iowa | 19153 | 29223 | 315 |
739563 | 739563 | 2020-11-17 | Polk | Iowa | 19153 | 28712 | 310 |
736319 | 736319 | 2020-11-16 | Polk | Iowa | 19153 | 28296 | 308 |
733073 | 733073 | 2020-11-15 | Polk | Iowa | 19153 | 27784 | 304 |
729828 | 729828 | 2020-11-14 | Polk | Iowa | 19153 | 27414 | 304 |
726585 | 726585 | 2020-11-13 | Polk | Iowa | 19153 | 26799 | 304 |
723342 | 723342 | 2020-11-12 | Polk | Iowa | 19153 | 25842 | 302 |
720099 | 720099 | 2020-11-11 | Polk | Iowa | 19153 | 25202 | 301 |
716856 | 716856 | 2020-11-10 | Polk | Iowa | 19153 | 24717 | 300 |
713612 | 713612 | 2020-11-09 | Polk | Iowa | 19153 | 24306 | 299 |
710368 | 710368 | 2020-11-08 | Polk | Iowa | 19153 | 23742 | 297 |
707124 | 707124 | 2020-11-07 | Polk | Iowa | 19153 | 22928 | 297 |
703881 | 703881 | 2020-11-06 | Polk | Iowa | 19153 | 22394 | 297 |
700639 | 700639 | 2020-11-05 | Polk | Iowa | 19153 | 22007 | 296 |
697395 | 697395 | 2020-11-04 | Polk | Iowa | 19153 | 21404 | 296 |
694153 | 694153 | 2020-11-03 | Polk | Iowa | 19153 | 21060 | 294 |
690910 | 690910 | 2020-11-02 | Polk | Iowa | 19153 | 20898 | 291 |
687665 | 687665 | 2020-11-01 | Polk | Iowa | 19153 | 20796 | 290 |
684421 | 684421 | 2020-10-31 | Polk | Iowa | 19153 | 20413 | 290 |
681178 | 681178 | 2020-10-30 | Polk | Iowa | 19153 | 20038 | 290 |
677935 | 677935 | 2020-10-29 | Polk | Iowa | 19153 | 19766 | 289 |
674692 | 674692 | 2020-10-28 | Polk | Iowa | 19153 | 19476 | 289 |
671450 | 671450 | 2020-10-27 | Polk | Iowa | 19153 | 19221 | 289 |
668207 | 668207 | 2020-10-26 | Polk | Iowa | 19153 | 19024 | 288 |
664963 | 664963 | 2020-10-25 | Polk | Iowa | 19153 | 18874 | 288 |
661718 | 661718 | 2020-10-24 | Polk | Iowa | 19153 | 18771 | 288 |
658474 | 658474 | 2020-10-23 | Polk | Iowa | 19153 | 18651 | 286 |
655229 | 655229 | 2020-10-22 | Polk | Iowa | 19153 | 18460 | 285 |
651984 | 651984 | 2020-10-21 | Polk | Iowa | 19153 | 18268 | 283 |
648740 | 648740 | 2020-10-20 | Polk | Iowa | 19153 | 18089 | 283 |
645495 | 645495 | 2020-10-19 | Polk | Iowa | 19153 | 17992 | 282 |
642248 | 642248 | 2020-10-18 | Polk | Iowa | 19153 | 17906 | 281 |
639001 | 639001 | 2020-10-17 | Polk | Iowa | 19153 | 17844 | 281 |
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 |
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);