ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where county = "Polk" and fips = 47139 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1043116 | 1043116 | 2021-02-18 | Polk | Tennessee | 47139 | 1703 | 21 |
1039871 | 1039871 | 2021-02-17 | Polk | Tennessee | 47139 | 1696 | 21 |
1036626 | 1036626 | 2021-02-16 | Polk | Tennessee | 47139 | 1685 | 21 |
1033381 | 1033381 | 2021-02-15 | Polk | Tennessee | 47139 | 1676 | 21 |
1030135 | 1030135 | 2021-02-14 | Polk | Tennessee | 47139 | 1667 | 21 |
1026888 | 1026888 | 2021-02-13 | Polk | Tennessee | 47139 | 1652 | 21 |
1023643 | 1023643 | 2021-02-12 | Polk | Tennessee | 47139 | 1622 | 21 |
1020398 | 1020398 | 2021-02-11 | Polk | Tennessee | 47139 | 1615 | 21 |
1017153 | 1017153 | 2021-02-10 | Polk | Tennessee | 47139 | 1605 | 21 |
1013908 | 1013908 | 2021-02-09 | Polk | Tennessee | 47139 | 1621 | 21 |
1010663 | 1010663 | 2021-02-08 | Polk | Tennessee | 47139 | 1622 | 21 |
1007417 | 1007417 | 2021-02-07 | Polk | Tennessee | 47139 | 1617 | 21 |
1004171 | 1004171 | 2021-02-06 | Polk | Tennessee | 47139 | 1612 | 21 |
1000925 | 1000925 | 2021-02-05 | Polk | Tennessee | 47139 | 1594 | 21 |
997679 | 997679 | 2021-02-04 | Polk | Tennessee | 47139 | 1589 | 21 |
994433 | 994433 | 2021-02-03 | Polk | Tennessee | 47139 | 1578 | 19 |
991187 | 991187 | 2021-02-02 | Polk | Tennessee | 47139 | 1576 | 19 |
987941 | 987941 | 2021-02-01 | Polk | Tennessee | 47139 | 1565 | 19 |
984694 | 984694 | 2021-01-31 | Polk | Tennessee | 47139 | 1563 | 19 |
981447 | 981447 | 2021-01-30 | Polk | Tennessee | 47139 | 1558 | 18 |
978201 | 978201 | 2021-01-29 | Polk | Tennessee | 47139 | 1543 | 18 |
974956 | 974956 | 2021-01-28 | Polk | Tennessee | 47139 | 1533 | 17 |
971711 | 971711 | 2021-01-27 | Polk | Tennessee | 47139 | 1523 | 17 |
968466 | 968466 | 2021-01-26 | Polk | Tennessee | 47139 | 1514 | 17 |
965222 | 965222 | 2021-01-25 | Polk | Tennessee | 47139 | 1505 | 17 |
961977 | 961977 | 2021-01-24 | Polk | Tennessee | 47139 | 1500 | 17 |
958732 | 958732 | 2021-01-23 | Polk | Tennessee | 47139 | 1485 | 17 |
955486 | 955486 | 2021-01-22 | Polk | Tennessee | 47139 | 1478 | 17 |
952241 | 952241 | 2021-01-21 | Polk | Tennessee | 47139 | 1466 | 17 |
948996 | 948996 | 2021-01-20 | Polk | Tennessee | 47139 | 1445 | 17 |
945750 | 945750 | 2021-01-19 | Polk | Tennessee | 47139 | 1438 | 17 |
942503 | 942503 | 2021-01-18 | Polk | Tennessee | 47139 | 1436 | 17 |
939258 | 939258 | 2021-01-17 | Polk | Tennessee | 47139 | 1428 | 17 |
936013 | 936013 | 2021-01-16 | Polk | Tennessee | 47139 | 1418 | 17 |
932768 | 932768 | 2021-01-15 | Polk | Tennessee | 47139 | 1398 | 17 |
929523 | 929523 | 2021-01-14 | Polk | Tennessee | 47139 | 1373 | 17 |
926278 | 926278 | 2021-01-13 | Polk | Tennessee | 47139 | 1366 | 17 |
923032 | 923032 | 2021-01-12 | Polk | Tennessee | 47139 | 1356 | 17 |
919787 | 919787 | 2021-01-11 | Polk | Tennessee | 47139 | 1346 | 17 |
916542 | 916542 | 2021-01-10 | Polk | Tennessee | 47139 | 1338 | 17 |
913297 | 913297 | 2021-01-09 | Polk | Tennessee | 47139 | 1309 | 17 |
910052 | 910052 | 2021-01-08 | Polk | Tennessee | 47139 | 1296 | 17 |
906807 | 906807 | 2021-01-07 | Polk | Tennessee | 47139 | 1279 | 17 |
903561 | 903561 | 2021-01-06 | Polk | Tennessee | 47139 | 1264 | 17 |
900316 | 900316 | 2021-01-05 | Polk | Tennessee | 47139 | 1247 | 16 |
897071 | 897071 | 2021-01-04 | Polk | Tennessee | 47139 | 1235 | 16 |
893825 | 893825 | 2021-01-03 | Polk | Tennessee | 47139 | 1231 | 16 |
890579 | 890579 | 2021-01-02 | Polk | Tennessee | 47139 | 1218 | 16 |
887332 | 887332 | 2021-01-01 | Polk | Tennessee | 47139 | 1174 | 16 |
884087 | 884087 | 2020-12-31 | Polk | Tennessee | 47139 | 1174 | 16 |
880842 | 880842 | 2020-12-30 | Polk | Tennessee | 47139 | 1156 | 16 |
877597 | 877597 | 2020-12-29 | Polk | Tennessee | 47139 | 1132 | 16 |
874352 | 874352 | 2020-12-28 | Polk | Tennessee | 47139 | 1114 | 16 |
871107 | 871107 | 2020-12-27 | Polk | Tennessee | 47139 | 1106 | 16 |
867862 | 867862 | 2020-12-26 | Polk | Tennessee | 47139 | 1104 | 16 |
864617 | 864617 | 2020-12-25 | Polk | Tennessee | 47139 | 1088 | 15 |
861372 | 861372 | 2020-12-24 | Polk | Tennessee | 47139 | 1076 | 15 |
858127 | 858127 | 2020-12-23 | Polk | Tennessee | 47139 | 1067 | 15 |
854882 | 854882 | 2020-12-22 | Polk | Tennessee | 47139 | 1055 | 15 |
851637 | 851637 | 2020-12-21 | Polk | Tennessee | 47139 | 1041 | 15 |
848392 | 848392 | 2020-12-20 | Polk | Tennessee | 47139 | 1022 | 15 |
845147 | 845147 | 2020-12-19 | Polk | Tennessee | 47139 | 1002 | 15 |
841901 | 841901 | 2020-12-18 | Polk | Tennessee | 47139 | 979 | 15 |
838656 | 838656 | 2020-12-17 | Polk | Tennessee | 47139 | 944 | 15 |
835410 | 835410 | 2020-12-16 | Polk | Tennessee | 47139 | 928 | 15 |
832164 | 832164 | 2020-12-15 | Polk | Tennessee | 47139 | 917 | 15 |
828917 | 828917 | 2020-12-14 | Polk | Tennessee | 47139 | 892 | 15 |
825671 | 825671 | 2020-12-13 | Polk | Tennessee | 47139 | 865 | 15 |
822424 | 822424 | 2020-12-12 | Polk | Tennessee | 47139 | 846 | 15 |
819178 | 819178 | 2020-12-11 | Polk | Tennessee | 47139 | 839 | 15 |
815932 | 815932 | 2020-12-10 | Polk | Tennessee | 47139 | 821 | 15 |
812686 | 812686 | 2020-12-09 | Polk | Tennessee | 47139 | 792 | 15 |
809442 | 809442 | 2020-12-08 | Polk | Tennessee | 47139 | 767 | 15 |
806197 | 806197 | 2020-12-07 | Polk | Tennessee | 47139 | 744 | 15 |
802952 | 802952 | 2020-12-06 | Polk | Tennessee | 47139 | 722 | 15 |
799707 | 799707 | 2020-12-05 | Polk | Tennessee | 47139 | 720 | 15 |
796462 | 796462 | 2020-12-04 | Polk | Tennessee | 47139 | 715 | 15 |
793217 | 793217 | 2020-12-03 | Polk | Tennessee | 47139 | 709 | 15 |
789972 | 789972 | 2020-12-02 | Polk | Tennessee | 47139 | 705 | 15 |
786727 | 786727 | 2020-12-01 | Polk | Tennessee | 47139 | 704 | 15 |
783483 | 783483 | 2020-11-30 | Polk | Tennessee | 47139 | 694 | 15 |
780238 | 780238 | 2020-11-29 | Polk | Tennessee | 47139 | 673 | 15 |
776992 | 776992 | 2020-11-28 | Polk | Tennessee | 47139 | 665 | 15 |
773747 | 773747 | 2020-11-27 | Polk | Tennessee | 47139 | 650 | 15 |
770502 | 770502 | 2020-11-26 | Polk | Tennessee | 47139 | 645 | 15 |
767256 | 767256 | 2020-11-25 | Polk | Tennessee | 47139 | 641 | 15 |
764011 | 764011 | 2020-11-24 | Polk | Tennessee | 47139 | 637 | 14 |
760766 | 760766 | 2020-11-23 | Polk | Tennessee | 47139 | 632 | 14 |
757521 | 757521 | 2020-11-22 | Polk | Tennessee | 47139 | 629 | 14 |
754274 | 754274 | 2020-11-21 | Polk | Tennessee | 47139 | 619 | 14 |
751028 | 751028 | 2020-11-20 | Polk | Tennessee | 47139 | 614 | 14 |
747782 | 747782 | 2020-11-19 | Polk | Tennessee | 47139 | 612 | 14 |
744536 | 744536 | 2020-11-18 | Polk | Tennessee | 47139 | 607 | 14 |
741289 | 741289 | 2020-11-17 | Polk | Tennessee | 47139 | 607 | 14 |
738043 | 738043 | 2020-11-16 | Polk | Tennessee | 47139 | 602 | 14 |
734799 | 734799 | 2020-11-15 | Polk | Tennessee | 47139 | 599 | 13 |
731553 | 731553 | 2020-11-14 | Polk | Tennessee | 47139 | 596 | 13 |
728309 | 728309 | 2020-11-13 | Polk | Tennessee | 47139 | 584 | 13 |
725065 | 725065 | 2020-11-12 | Polk | Tennessee | 47139 | 581 | 13 |
721822 | 721822 | 2020-11-11 | Polk | Tennessee | 47139 | 575 | 13 |
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);