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 |
---|---|---|---|---|---|---|---|
1054377 | 1054377 | 2021-02-22 | Polk | Iowa | 19153 | 50544 | 542 |
1051130 | 1051130 | 2021-02-21 | Polk | Iowa | 19153 | 50544 | 537 |
1047883 | 1047883 | 2021-02-20 | Polk | Iowa | 19153 | 50544 | 537 |
1044638 | 1044638 | 2021-02-19 | Polk | Iowa | 19153 | 50544 | 537 |
1041393 | 1041393 | 2021-02-18 | Polk | Iowa | 19153 | 50504 | 535 |
1038148 | 1038148 | 2021-02-17 | Polk | Iowa | 19153 | 50379 | 533 |
1034903 | 1034903 | 2021-02-16 | Polk | Iowa | 19153 | 50260 | 527 |
1031657 | 1031657 | 2021-02-15 | Polk | Iowa | 19153 | 50132 | 524 |
1028410 | 1028410 | 2021-02-14 | Polk | Iowa | 19153 | 49982 | 524 |
1025165 | 1025165 | 2021-02-13 | Polk | Iowa | 19153 | 49945 | 524 |
1021920 | 1021920 | 2021-02-12 | Polk | Iowa | 19153 | 49829 | 522 |
1018675 | 1018675 | 2021-02-11 | Polk | Iowa | 19153 | 49589 | 520 |
1015430 | 1015430 | 2021-02-10 | Polk | Iowa | 19153 | 49503 | 514 |
1012185 | 1012185 | 2021-02-09 | Polk | Iowa | 19153 | 49367 | 514 |
1008939 | 1008939 | 2021-02-08 | Polk | Iowa | 19153 | 49200 | 513 |
1005693 | 1005693 | 2021-02-07 | Polk | Iowa | 19153 | 49067 | 513 |
1002447 | 1002447 | 2021-02-06 | Polk | Iowa | 19153 | 49016 | 513 |
999201 | 999201 | 2021-02-05 | Polk | Iowa | 19153 | 48890 | 510 |
995955 | 995955 | 2021-02-04 | Polk | Iowa | 19153 | 48748 | 509 |
992709 | 992709 | 2021-02-03 | Polk | Iowa | 19153 | 48567 | 503 |
989463 | 989463 | 2021-02-02 | Polk | Iowa | 19153 | 48378 | 500 |
986216 | 986216 | 2021-02-01 | Polk | Iowa | 19153 | 48137 | 500 |
982969 | 982969 | 2021-01-31 | Polk | Iowa | 19153 | 47978 | 500 |
979723 | 979723 | 2021-01-30 | Polk | Iowa | 19153 | 47914 | 480 |
976477 | 976477 | 2021-01-29 | Polk | Iowa | 19153 | 47639 | 472 |
973232 | 973232 | 2021-01-28 | Polk | Iowa | 19153 | 47536 | 468 |
969987 | 969987 | 2021-01-27 | Polk | Iowa | 19153 | 47367 | 465 |
966743 | 966743 | 2021-01-26 | Polk | Iowa | 19153 | 47198 | 465 |
963498 | 963498 | 2021-01-25 | Polk | Iowa | 19153 | 46980 | 465 |
960253 | 960253 | 2021-01-24 | Polk | Iowa | 19153 | 46841 | 465 |
957007 | 957007 | 2021-01-23 | Polk | Iowa | 19153 | 46760 | 465 |
953762 | 953762 | 2021-01-22 | Polk | Iowa | 19153 | 46587 | 464 |
950517 | 950517 | 2021-01-21 | Polk | Iowa | 19153 | 46317 | 460 |
947271 | 947271 | 2021-01-20 | Polk | Iowa | 19153 | 46016 | 457 |
944024 | 944024 | 2021-01-19 | Polk | Iowa | 19153 | 45751 | 449 |
940779 | 940779 | 2021-01-18 | Polk | Iowa | 19153 | 45573 | 448 |
937534 | 937534 | 2021-01-17 | Polk | Iowa | 19153 | 45397 | 448 |
934289 | 934289 | 2021-01-16 | Polk | Iowa | 19153 | 45332 | 447 |
931044 | 931044 | 2021-01-15 | Polk | Iowa | 19153 | 45207 | 441 |
927799 | 927799 | 2021-01-14 | Polk | Iowa | 19153 | 44945 | 440 |
924553 | 924553 | 2021-01-13 | Polk | Iowa | 19153 | 44653 | 436 |
921308 | 921308 | 2021-01-12 | Polk | Iowa | 19153 | 44385 | 434 |
918063 | 918063 | 2021-01-11 | Polk | Iowa | 19153 | 44034 | 426 |
914818 | 914818 | 2021-01-10 | Polk | Iowa | 19153 | 43843 | 426 |
911573 | 911573 | 2021-01-09 | Polk | Iowa | 19153 | 43790 | 424 |
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 |
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);