ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Linn" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054357 | 1054357 | 2021-02-22 | Linn | Iowa | 19113 | 19202 | 309 |
1051110 | 1051110 | 2021-02-21 | Linn | Iowa | 19113 | 19202 | 305 |
1047863 | 1047863 | 2021-02-20 | Linn | Iowa | 19113 | 19202 | 305 |
1044618 | 1044618 | 2021-02-19 | Linn | Iowa | 19113 | 19202 | 305 |
1041373 | 1041373 | 2021-02-18 | Linn | Iowa | 19113 | 19197 | 305 |
1038128 | 1038128 | 2021-02-17 | Linn | Iowa | 19113 | 19175 | 305 |
1034883 | 1034883 | 2021-02-16 | Linn | Iowa | 19113 | 19149 | 305 |
1031637 | 1031637 | 2021-02-15 | Linn | Iowa | 19113 | 19127 | 305 |
1028390 | 1028390 | 2021-02-14 | Linn | Iowa | 19113 | 19099 | 305 |
1025145 | 1025145 | 2021-02-13 | Linn | Iowa | 19113 | 19083 | 305 |
1021900 | 1021900 | 2021-02-12 | Linn | Iowa | 19113 | 19056 | 305 |
1018655 | 1018655 | 2021-02-11 | Linn | Iowa | 19113 | 18997 | 303 |
1015410 | 1015410 | 2021-02-10 | Linn | Iowa | 19113 | 18985 | 303 |
1012165 | 1012165 | 2021-02-09 | Linn | Iowa | 19113 | 18946 | 301 |
1008919 | 1008919 | 2021-02-08 | Linn | Iowa | 19113 | 18908 | 300 |
1005673 | 1005673 | 2021-02-07 | Linn | Iowa | 19113 | 18868 | 300 |
1002427 | 1002427 | 2021-02-06 | Linn | Iowa | 19113 | 18841 | 300 |
999181 | 999181 | 2021-02-05 | Linn | Iowa | 19113 | 18813 | 299 |
995935 | 995935 | 2021-02-04 | Linn | Iowa | 19113 | 18790 | 299 |
992689 | 992689 | 2021-02-03 | Linn | Iowa | 19113 | 18715 | 295 |
989443 | 989443 | 2021-02-02 | Linn | Iowa | 19113 | 18645 | 294 |
986196 | 986196 | 2021-02-01 | Linn | Iowa | 19113 | 18583 | 293 |
982949 | 982949 | 2021-01-31 | Linn | Iowa | 19113 | 18522 | 293 |
979703 | 979703 | 2021-01-30 | Linn | Iowa | 19113 | 18494 | 284 |
976457 | 976457 | 2021-01-29 | Linn | Iowa | 19113 | 18357 | 282 |
973212 | 973212 | 2021-01-28 | Linn | Iowa | 19113 | 18329 | 281 |
969967 | 969967 | 2021-01-27 | Linn | Iowa | 19113 | 18252 | 280 |
966723 | 966723 | 2021-01-26 | Linn | Iowa | 19113 | 18187 | 280 |
963478 | 963478 | 2021-01-25 | Linn | Iowa | 19113 | 18111 | 279 |
960233 | 960233 | 2021-01-24 | Linn | Iowa | 19113 | 18065 | 279 |
956987 | 956987 | 2021-01-23 | Linn | Iowa | 19113 | 18037 | 279 |
953742 | 953742 | 2021-01-22 | Linn | Iowa | 19113 | 17979 | 279 |
950497 | 950497 | 2021-01-21 | Linn | Iowa | 19113 | 17914 | 278 |
947251 | 947251 | 2021-01-20 | Linn | Iowa | 19113 | 17864 | 278 |
944004 | 944004 | 2021-01-19 | Linn | Iowa | 19113 | 17795 | 275 |
940759 | 940759 | 2021-01-18 | Linn | Iowa | 19113 | 17741 | 274 |
937514 | 937514 | 2021-01-17 | Linn | Iowa | 19113 | 17695 | 274 |
934269 | 934269 | 2021-01-16 | Linn | Iowa | 19113 | 17674 | 274 |
931024 | 931024 | 2021-01-15 | Linn | Iowa | 19113 | 17617 | 270 |
927779 | 927779 | 2021-01-14 | Linn | Iowa | 19113 | 17568 | 269 |
924533 | 924533 | 2021-01-13 | Linn | Iowa | 19113 | 17509 | 269 |
921288 | 921288 | 2021-01-12 | Linn | Iowa | 19113 | 17444 | 268 |
918043 | 918043 | 2021-01-11 | Linn | Iowa | 19113 | 17383 | 264 |
914798 | 914798 | 2021-01-10 | Linn | Iowa | 19113 | 17320 | 264 |
911553 | 911553 | 2021-01-09 | Linn | Iowa | 19113 | 17295 | 264 |
908308 | 908308 | 2021-01-08 | Linn | Iowa | 19113 | 17216 | 264 |
905062 | 905062 | 2021-01-07 | Linn | Iowa | 19113 | 17163 | 258 |
901817 | 901817 | 2021-01-06 | Linn | Iowa | 19113 | 17071 | 258 |
898572 | 898572 | 2021-01-05 | Linn | Iowa | 19113 | 16958 | 250 |
895327 | 895327 | 2021-01-04 | Linn | Iowa | 19113 | 16846 | 251 |
892080 | 892080 | 2021-01-03 | Linn | Iowa | 19113 | 16752 | 249 |
888834 | 888834 | 2021-01-02 | Linn | Iowa | 19113 | 16719 | 249 |
885588 | 885588 | 2021-01-01 | Linn | Iowa | 19113 | 16659 | 245 |
882343 | 882343 | 2020-12-31 | Linn | Iowa | 19113 | 16607 | 245 |
879098 | 879098 | 2020-12-30 | Linn | Iowa | 19113 | 16534 | 243 |
875853 | 875853 | 2020-12-29 | Linn | Iowa | 19113 | 16481 | 243 |
872608 | 872608 | 2020-12-28 | Linn | Iowa | 19113 | 16419 | 240 |
869363 | 869363 | 2020-12-27 | Linn | Iowa | 19113 | 16370 | 240 |
866118 | 866118 | 2020-12-26 | Linn | Iowa | 19113 | 16349 | 240 |
862873 | 862873 | 2020-12-25 | Linn | Iowa | 19113 | 16313 | 240 |
859628 | 859628 | 2020-12-24 | Linn | Iowa | 19113 | 16292 | 240 |
856383 | 856383 | 2020-12-23 | Linn | Iowa | 19113 | 16216 | 234 |
853138 | 853138 | 2020-12-22 | Linn | Iowa | 19113 | 16132 | 232 |
849893 | 849893 | 2020-12-21 | Linn | Iowa | 19113 | 16060 | 231 |
846648 | 846648 | 2020-12-20 | Linn | Iowa | 19113 | 15991 | 231 |
843402 | 843402 | 2020-12-19 | Linn | Iowa | 19113 | 15965 | 229 |
840157 | 840157 | 2020-12-18 | Linn | Iowa | 19113 | 15842 | 228 |
836912 | 836912 | 2020-12-17 | Linn | Iowa | 19113 | 15685 | 228 |
833666 | 833666 | 2020-12-16 | Linn | Iowa | 19113 | 15634 | 221 |
830419 | 830419 | 2020-12-15 | Linn | Iowa | 19113 | 15539 | 221 |
827173 | 827173 | 2020-12-14 | Linn | Iowa | 19113 | 15489 | 217 |
823926 | 823926 | 2020-12-13 | Linn | Iowa | 19113 | 15461 | 215 |
820680 | 820680 | 2020-12-12 | Linn | Iowa | 19113 | 15419 | 215 |
817434 | 817434 | 2020-12-11 | Linn | Iowa | 19113 | 15369 | 214 |
814188 | 814188 | 2020-12-10 | Linn | Iowa | 19113 | 15279 | 211 |
810943 | 810943 | 2020-12-09 | Linn | Iowa | 19113 | 15201 | 207 |
807698 | 807698 | 2020-12-08 | Linn | Iowa | 19113 | 15109 | 204 |
804453 | 804453 | 2020-12-07 | Linn | Iowa | 19113 | 15094 | 173 |
801208 | 801208 | 2020-12-06 | Linn | Iowa | 19113 | 15032 | 173 |
797963 | 797963 | 2020-12-05 | Linn | Iowa | 19113 | 14983 | 171 |
794718 | 794718 | 2020-12-04 | Linn | Iowa | 19113 | 14908 | 170 |
791473 | 791473 | 2020-12-03 | Linn | Iowa | 19113 | 14788 | 169 |
788228 | 788228 | 2020-12-02 | Linn | Iowa | 19113 | 14655 | 168 |
784984 | 784984 | 2020-12-01 | Linn | Iowa | 19113 | 14513 | 166 |
781739 | 781739 | 2020-11-30 | Linn | Iowa | 19113 | 14343 | 166 |
778493 | 778493 | 2020-11-29 | Linn | Iowa | 19113 | 14350 | 165 |
775248 | 775248 | 2020-11-28 | Linn | Iowa | 19113 | 14206 | 164 |
772003 | 772003 | 2020-11-27 | Linn | Iowa | 19113 | 13993 | 164 |
768758 | 768758 | 2020-11-26 | Linn | Iowa | 19113 | 13877 | 164 |
765512 | 765512 | 2020-11-25 | Linn | Iowa | 19113 | 13799 | 164 |
762267 | 762267 | 2020-11-24 | Linn | Iowa | 19113 | 13583 | 162 |
759022 | 759022 | 2020-11-23 | Linn | Iowa | 19113 | 13444 | 161 |
755775 | 755775 | 2020-11-22 | Linn | Iowa | 19113 | 13252 | 158 |
752529 | 752529 | 2020-11-21 | Linn | Iowa | 19113 | 13080 | 154 |
749283 | 749283 | 2020-11-20 | Linn | Iowa | 19113 | 12844 | 152 |
746037 | 746037 | 2020-11-19 | Linn | Iowa | 19113 | 12621 | 150 |
742790 | 742790 | 2020-11-18 | Linn | Iowa | 19113 | 12407 | 150 |
739543 | 739543 | 2020-11-17 | Linn | Iowa | 19113 | 12158 | 150 |
736299 | 736299 | 2020-11-16 | Linn | Iowa | 19113 | 11811 | 150 |
733053 | 733053 | 2020-11-15 | Linn | Iowa | 19113 | 11586 | 149 |
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);