ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where fips = 19155 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054378 | 1054378 | 2021-02-22 | Pottawattamie | Iowa | 19155 | 9666 | 140 |
1051131 | 1051131 | 2021-02-21 | Pottawattamie | Iowa | 19155 | 9666 | 140 |
1047884 | 1047884 | 2021-02-20 | Pottawattamie | Iowa | 19155 | 9666 | 140 |
1044639 | 1044639 | 2021-02-19 | Pottawattamie | Iowa | 19155 | 9666 | 140 |
1041394 | 1041394 | 2021-02-18 | Pottawattamie | Iowa | 19155 | 9662 | 140 |
1038149 | 1038149 | 2021-02-17 | Pottawattamie | Iowa | 19155 | 9647 | 140 |
1034904 | 1034904 | 2021-02-16 | Pottawattamie | Iowa | 19155 | 9627 | 140 |
1031658 | 1031658 | 2021-02-15 | Pottawattamie | Iowa | 19155 | 9612 | 139 |
1028411 | 1028411 | 2021-02-14 | Pottawattamie | Iowa | 19155 | 9597 | 139 |
1025166 | 1025166 | 2021-02-13 | Pottawattamie | Iowa | 19155 | 9596 | 139 |
1021921 | 1021921 | 2021-02-12 | Pottawattamie | Iowa | 19155 | 9588 | 139 |
1018676 | 1018676 | 2021-02-11 | Pottawattamie | Iowa | 19155 | 9538 | 138 |
1015431 | 1015431 | 2021-02-10 | Pottawattamie | Iowa | 19155 | 9538 | 138 |
1012186 | 1012186 | 2021-02-09 | Pottawattamie | Iowa | 19155 | 9502 | 136 |
1008940 | 1008940 | 2021-02-08 | Pottawattamie | Iowa | 19155 | 9484 | 135 |
1005694 | 1005694 | 2021-02-07 | Pottawattamie | Iowa | 19155 | 9466 | 134 |
1002448 | 1002448 | 2021-02-06 | Pottawattamie | Iowa | 19155 | 9460 | 134 |
999202 | 999202 | 2021-02-05 | Pottawattamie | Iowa | 19155 | 9454 | 130 |
995956 | 995956 | 2021-02-04 | Pottawattamie | Iowa | 19155 | 9439 | 130 |
992710 | 992710 | 2021-02-03 | Pottawattamie | Iowa | 19155 | 9416 | 129 |
989464 | 989464 | 2021-02-02 | Pottawattamie | Iowa | 19155 | 9388 | 126 |
986217 | 986217 | 2021-02-01 | Pottawattamie | Iowa | 19155 | 9358 | 126 |
982970 | 982970 | 2021-01-31 | Pottawattamie | Iowa | 19155 | 9332 | 126 |
979724 | 979724 | 2021-01-30 | Pottawattamie | Iowa | 19155 | 9328 | 120 |
976478 | 976478 | 2021-01-29 | Pottawattamie | Iowa | 19155 | 9275 | 115 |
973233 | 973233 | 2021-01-28 | Pottawattamie | Iowa | 19155 | 9254 | 115 |
969988 | 969988 | 2021-01-27 | Pottawattamie | Iowa | 19155 | 9225 | 115 |
966744 | 966744 | 2021-01-26 | Pottawattamie | Iowa | 19155 | 9204 | 115 |
963499 | 963499 | 2021-01-25 | Pottawattamie | Iowa | 19155 | 9182 | 115 |
960254 | 960254 | 2021-01-24 | Pottawattamie | Iowa | 19155 | 9166 | 115 |
957008 | 957008 | 2021-01-23 | Pottawattamie | Iowa | 19155 | 9146 | 115 |
953763 | 953763 | 2021-01-22 | Pottawattamie | Iowa | 19155 | 9111 | 115 |
950518 | 950518 | 2021-01-21 | Pottawattamie | Iowa | 19155 | 9086 | 114 |
947272 | 947272 | 2021-01-20 | Pottawattamie | Iowa | 19155 | 9047 | 113 |
944025 | 944025 | 2021-01-19 | Pottawattamie | Iowa | 19155 | 8992 | 112 |
940780 | 940780 | 2021-01-18 | Pottawattamie | Iowa | 19155 | 8959 | 112 |
937535 | 937535 | 2021-01-17 | Pottawattamie | Iowa | 19155 | 8942 | 112 |
934290 | 934290 | 2021-01-16 | Pottawattamie | Iowa | 19155 | 8934 | 112 |
931045 | 931045 | 2021-01-15 | Pottawattamie | Iowa | 19155 | 8896 | 112 |
927800 | 927800 | 2021-01-14 | Pottawattamie | Iowa | 19155 | 8863 | 112 |
924554 | 924554 | 2021-01-13 | Pottawattamie | Iowa | 19155 | 8843 | 111 |
921309 | 921309 | 2021-01-12 | Pottawattamie | Iowa | 19155 | 8797 | 111 |
918064 | 918064 | 2021-01-11 | Pottawattamie | Iowa | 19155 | 8757 | 104 |
914819 | 914819 | 2021-01-10 | Pottawattamie | Iowa | 19155 | 8740 | 104 |
911574 | 911574 | 2021-01-09 | Pottawattamie | Iowa | 19155 | 8715 | 104 |
908329 | 908329 | 2021-01-08 | Pottawattamie | Iowa | 19155 | 8661 | 104 |
905083 | 905083 | 2021-01-07 | Pottawattamie | Iowa | 19155 | 8629 | 102 |
901838 | 901838 | 2021-01-06 | Pottawattamie | Iowa | 19155 | 8569 | 102 |
898593 | 898593 | 2021-01-05 | Pottawattamie | Iowa | 19155 | 8485 | 102 |
895348 | 895348 | 2021-01-04 | Pottawattamie | Iowa | 19155 | 8459 | 102 |
892101 | 892101 | 2021-01-03 | Pottawattamie | Iowa | 19155 | 8390 | 98 |
888855 | 888855 | 2021-01-02 | Pottawattamie | Iowa | 19155 | 8383 | 98 |
885609 | 885609 | 2021-01-01 | Pottawattamie | Iowa | 19155 | 8327 | 95 |
882364 | 882364 | 2020-12-31 | Pottawattamie | Iowa | 19155 | 8270 | 95 |
879119 | 879119 | 2020-12-30 | Pottawattamie | Iowa | 19155 | 8244 | 93 |
875874 | 875874 | 2020-12-29 | Pottawattamie | Iowa | 19155 | 8141 | 93 |
872629 | 872629 | 2020-12-28 | Pottawattamie | Iowa | 19155 | 8107 | 90 |
869384 | 869384 | 2020-12-27 | Pottawattamie | Iowa | 19155 | 8078 | 90 |
866139 | 866139 | 2020-12-26 | Pottawattamie | Iowa | 19155 | 8074 | 90 |
862894 | 862894 | 2020-12-25 | Pottawattamie | Iowa | 19155 | 8065 | 90 |
859649 | 859649 | 2020-12-24 | Pottawattamie | Iowa | 19155 | 8056 | 89 |
856404 | 856404 | 2020-12-23 | Pottawattamie | Iowa | 19155 | 8010 | 87 |
853159 | 853159 | 2020-12-22 | Pottawattamie | Iowa | 19155 | 7911 | 87 |
849914 | 849914 | 2020-12-21 | Pottawattamie | Iowa | 19155 | 7861 | 87 |
846669 | 846669 | 2020-12-20 | Pottawattamie | Iowa | 19155 | 7813 | 87 |
843423 | 843423 | 2020-12-19 | Pottawattamie | Iowa | 19155 | 7799 | 85 |
840178 | 840178 | 2020-12-18 | Pottawattamie | Iowa | 19155 | 7730 | 83 |
836933 | 836933 | 2020-12-17 | Pottawattamie | Iowa | 19155 | 7641 | 83 |
833687 | 833687 | 2020-12-16 | Pottawattamie | Iowa | 19155 | 7598 | 82 |
830440 | 830440 | 2020-12-15 | Pottawattamie | Iowa | 19155 | 7508 | 79 |
827194 | 827194 | 2020-12-14 | Pottawattamie | Iowa | 19155 | 7475 | 78 |
823947 | 823947 | 2020-12-13 | Pottawattamie | Iowa | 19155 | 7455 | 73 |
820701 | 820701 | 2020-12-12 | Pottawattamie | Iowa | 19155 | 7395 | 73 |
817455 | 817455 | 2020-12-11 | Pottawattamie | Iowa | 19155 | 7312 | 72 |
814209 | 814209 | 2020-12-10 | Pottawattamie | Iowa | 19155 | 7233 | 70 |
810964 | 810964 | 2020-12-09 | Pottawattamie | Iowa | 19155 | 7121 | 69 |
807719 | 807719 | 2020-12-08 | Pottawattamie | Iowa | 19155 | 7059 | 69 |
804474 | 804474 | 2020-12-07 | Pottawattamie | Iowa | 19155 | 7057 | 82 |
801229 | 801229 | 2020-12-06 | Pottawattamie | Iowa | 19155 | 7044 | 82 |
797984 | 797984 | 2020-12-05 | Pottawattamie | Iowa | 19155 | 7016 | 81 |
794739 | 794739 | 2020-12-04 | Pottawattamie | Iowa | 19155 | 6926 | 76 |
791494 | 791494 | 2020-12-03 | Pottawattamie | Iowa | 19155 | 6824 | 74 |
788249 | 788249 | 2020-12-02 | Pottawattamie | Iowa | 19155 | 6648 | 71 |
785005 | 785005 | 2020-12-01 | Pottawattamie | Iowa | 19155 | 6505 | 71 |
781760 | 781760 | 2020-11-30 | Pottawattamie | Iowa | 19155 | 6440 | 70 |
778514 | 778514 | 2020-11-29 | Pottawattamie | Iowa | 19155 | 6319 | 70 |
775269 | 775269 | 2020-11-28 | Pottawattamie | Iowa | 19155 | 6245 | 70 |
772024 | 772024 | 2020-11-27 | Pottawattamie | Iowa | 19155 | 6170 | 69 |
768779 | 768779 | 2020-11-26 | Pottawattamie | Iowa | 19155 | 6124 | 69 |
765533 | 765533 | 2020-11-25 | Pottawattamie | Iowa | 19155 | 6029 | 67 |
762288 | 762288 | 2020-11-24 | Pottawattamie | Iowa | 19155 | 5891 | 67 |
759043 | 759043 | 2020-11-23 | Pottawattamie | Iowa | 19155 | 5851 | 66 |
755796 | 755796 | 2020-11-22 | Pottawattamie | Iowa | 19155 | 5746 | 66 |
752550 | 752550 | 2020-11-21 | Pottawattamie | Iowa | 19155 | 5670 | 65 |
749304 | 749304 | 2020-11-20 | Pottawattamie | Iowa | 19155 | 5544 | 64 |
746058 | 746058 | 2020-11-19 | Pottawattamie | Iowa | 19155 | 5392 | 62 |
742811 | 742811 | 2020-11-18 | Pottawattamie | Iowa | 19155 | 5234 | 61 |
739564 | 739564 | 2020-11-17 | Pottawattamie | Iowa | 19155 | 5080 | 58 |
736320 | 736320 | 2020-11-16 | Pottawattamie | Iowa | 19155 | 5027 | 56 |
733074 | 733074 | 2020-11-15 | Pottawattamie | Iowa | 19155 | 4759 | 55 |
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);