ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
743 rows where fips = 19185 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054394 | 1054394 | 2021-02-22 | Wayne | Iowa | 19185 | 443 | 21 |
1051147 | 1051147 | 2021-02-21 | Wayne | Iowa | 19185 | 443 | 21 |
1047900 | 1047900 | 2021-02-20 | Wayne | Iowa | 19185 | 443 | 21 |
1044655 | 1044655 | 2021-02-19 | Wayne | Iowa | 19185 | 443 | 21 |
1041410 | 1041410 | 2021-02-18 | Wayne | Iowa | 19185 | 443 | 21 |
1038165 | 1038165 | 2021-02-17 | Wayne | Iowa | 19185 | 442 | 21 |
1034920 | 1034920 | 2021-02-16 | Wayne | Iowa | 19185 | 440 | 21 |
1031674 | 1031674 | 2021-02-15 | Wayne | Iowa | 19185 | 439 | 21 |
1028427 | 1028427 | 2021-02-14 | Wayne | Iowa | 19185 | 438 | 21 |
1025182 | 1025182 | 2021-02-13 | Wayne | Iowa | 19185 | 437 | 21 |
1021937 | 1021937 | 2021-02-12 | Wayne | Iowa | 19185 | 437 | 21 |
1018692 | 1018692 | 2021-02-11 | Wayne | Iowa | 19185 | 437 | 21 |
1015447 | 1015447 | 2021-02-10 | Wayne | Iowa | 19185 | 437 | 21 |
1012202 | 1012202 | 2021-02-09 | Wayne | Iowa | 19185 | 436 | 21 |
1008956 | 1008956 | 2021-02-08 | Wayne | Iowa | 19185 | 433 | 21 |
1005710 | 1005710 | 2021-02-07 | Wayne | Iowa | 19185 | 431 | 21 |
1002464 | 1002464 | 2021-02-06 | Wayne | Iowa | 19185 | 431 | 21 |
999218 | 999218 | 2021-02-05 | Wayne | Iowa | 19185 | 431 | 21 |
995972 | 995972 | 2021-02-04 | Wayne | Iowa | 19185 | 427 | 21 |
992726 | 992726 | 2021-02-03 | Wayne | Iowa | 19185 | 427 | 21 |
989480 | 989480 | 2021-02-02 | Wayne | Iowa | 19185 | 427 | 21 |
986233 | 986233 | 2021-02-01 | Wayne | Iowa | 19185 | 427 | 21 |
982986 | 982986 | 2021-01-31 | Wayne | Iowa | 19185 | 426 | 21 |
979740 | 979740 | 2021-01-30 | Wayne | Iowa | 19185 | 425 | 21 |
976494 | 976494 | 2021-01-29 | Wayne | Iowa | 19185 | 422 | 21 |
973249 | 973249 | 2021-01-28 | Wayne | Iowa | 19185 | 422 | 21 |
970004 | 970004 | 2021-01-27 | Wayne | Iowa | 19185 | 422 | 21 |
966760 | 966760 | 2021-01-26 | Wayne | Iowa | 19185 | 420 | 21 |
963515 | 963515 | 2021-01-25 | Wayne | Iowa | 19185 | 420 | 21 |
960270 | 960270 | 2021-01-24 | Wayne | Iowa | 19185 | 420 | 21 |
957024 | 957024 | 2021-01-23 | Wayne | Iowa | 19185 | 419 | 21 |
953779 | 953779 | 2021-01-22 | Wayne | Iowa | 19185 | 418 | 21 |
950534 | 950534 | 2021-01-21 | Wayne | Iowa | 19185 | 417 | 21 |
947288 | 947288 | 2021-01-20 | Wayne | Iowa | 19185 | 417 | 21 |
944041 | 944041 | 2021-01-19 | Wayne | Iowa | 19185 | 414 | 21 |
940796 | 940796 | 2021-01-18 | Wayne | Iowa | 19185 | 414 | 21 |
937551 | 937551 | 2021-01-17 | Wayne | Iowa | 19185 | 414 | 21 |
934306 | 934306 | 2021-01-16 | Wayne | Iowa | 19185 | 414 | 21 |
931061 | 931061 | 2021-01-15 | Wayne | Iowa | 19185 | 414 | 21 |
927816 | 927816 | 2021-01-14 | Wayne | Iowa | 19185 | 413 | 21 |
924570 | 924570 | 2021-01-13 | Wayne | Iowa | 19185 | 413 | 21 |
921325 | 921325 | 2021-01-12 | Wayne | Iowa | 19185 | 412 | 21 |
918080 | 918080 | 2021-01-11 | Wayne | Iowa | 19185 | 411 | 21 |
914835 | 914835 | 2021-01-10 | Wayne | Iowa | 19185 | 411 | 21 |
911590 | 911590 | 2021-01-09 | Wayne | Iowa | 19185 | 411 | 21 |
908345 | 908345 | 2021-01-08 | Wayne | Iowa | 19185 | 409 | 21 |
905099 | 905099 | 2021-01-07 | Wayne | Iowa | 19185 | 407 | 21 |
901854 | 901854 | 2021-01-06 | Wayne | Iowa | 19185 | 399 | 21 |
898609 | 898609 | 2021-01-05 | Wayne | Iowa | 19185 | 394 | 21 |
895364 | 895364 | 2021-01-04 | Wayne | Iowa | 19185 | 390 | 21 |
892117 | 892117 | 2021-01-03 | Wayne | Iowa | 19185 | 389 | 21 |
888871 | 888871 | 2021-01-02 | Wayne | Iowa | 19185 | 386 | 21 |
885625 | 885625 | 2021-01-01 | Wayne | Iowa | 19185 | 384 | 21 |
882380 | 882380 | 2020-12-31 | Wayne | Iowa | 19185 | 381 | 21 |
879135 | 879135 | 2020-12-30 | Wayne | Iowa | 19185 | 373 | 21 |
875890 | 875890 | 2020-12-29 | Wayne | Iowa | 19185 | 369 | 21 |
872645 | 872645 | 2020-12-28 | Wayne | Iowa | 19185 | 366 | 21 |
869400 | 869400 | 2020-12-27 | Wayne | Iowa | 19185 | 364 | 21 |
866155 | 866155 | 2020-12-26 | Wayne | Iowa | 19185 | 363 | 21 |
862910 | 862910 | 2020-12-25 | Wayne | Iowa | 19185 | 362 | 21 |
859665 | 859665 | 2020-12-24 | Wayne | Iowa | 19185 | 360 | 21 |
856420 | 856420 | 2020-12-23 | Wayne | Iowa | 19185 | 357 | 21 |
853175 | 853175 | 2020-12-22 | Wayne | Iowa | 19185 | 354 | 21 |
849930 | 849930 | 2020-12-21 | Wayne | Iowa | 19185 | 353 | 21 |
846685 | 846685 | 2020-12-20 | Wayne | Iowa | 19185 | 352 | 21 |
843439 | 843439 | 2020-12-19 | Wayne | Iowa | 19185 | 352 | 21 |
840194 | 840194 | 2020-12-18 | Wayne | Iowa | 19185 | 346 | 21 |
836949 | 836949 | 2020-12-17 | Wayne | Iowa | 19185 | 340 | 21 |
833703 | 833703 | 2020-12-16 | Wayne | Iowa | 19185 | 338 | 21 |
830456 | 830456 | 2020-12-15 | Wayne | Iowa | 19185 | 338 | 21 |
827210 | 827210 | 2020-12-14 | Wayne | Iowa | 19185 | 337 | 21 |
823963 | 823963 | 2020-12-13 | Wayne | Iowa | 19185 | 336 | 21 |
820717 | 820717 | 2020-12-12 | Wayne | Iowa | 19185 | 334 | 21 |
817471 | 817471 | 2020-12-11 | Wayne | Iowa | 19185 | 332 | 21 |
814225 | 814225 | 2020-12-10 | Wayne | Iowa | 19185 | 327 | 21 |
810980 | 810980 | 2020-12-09 | Wayne | Iowa | 19185 | 320 | 21 |
807735 | 807735 | 2020-12-08 | Wayne | Iowa | 19185 | 320 | 21 |
804490 | 804490 | 2020-12-07 | Wayne | Iowa | 19185 | 319 | 7 |
801245 | 801245 | 2020-12-06 | Wayne | Iowa | 19185 | 316 | 7 |
798000 | 798000 | 2020-12-05 | Wayne | Iowa | 19185 | 310 | 7 |
794755 | 794755 | 2020-12-04 | Wayne | Iowa | 19185 | 309 | 7 |
791510 | 791510 | 2020-12-03 | Wayne | Iowa | 19185 | 308 | 7 |
788265 | 788265 | 2020-12-02 | Wayne | Iowa | 19185 | 307 | 7 |
785021 | 785021 | 2020-12-01 | Wayne | Iowa | 19185 | 304 | 7 |
781776 | 781776 | 2020-11-30 | Wayne | Iowa | 19185 | 302 | 7 |
778530 | 778530 | 2020-11-29 | Wayne | Iowa | 19185 | 300 | 7 |
775285 | 775285 | 2020-11-28 | Wayne | Iowa | 19185 | 298 | 7 |
772040 | 772040 | 2020-11-27 | Wayne | Iowa | 19185 | 295 | 7 |
768795 | 768795 | 2020-11-26 | Wayne | Iowa | 19185 | 295 | 7 |
765549 | 765549 | 2020-11-25 | Wayne | Iowa | 19185 | 293 | 6 |
762304 | 762304 | 2020-11-24 | Wayne | Iowa | 19185 | 289 | 6 |
759059 | 759059 | 2020-11-23 | Wayne | Iowa | 19185 | 287 | 6 |
755812 | 755812 | 2020-11-22 | Wayne | Iowa | 19185 | 283 | 6 |
752566 | 752566 | 2020-11-21 | Wayne | Iowa | 19185 | 280 | 6 |
749320 | 749320 | 2020-11-20 | Wayne | Iowa | 19185 | 279 | 6 |
746074 | 746074 | 2020-11-19 | Wayne | Iowa | 19185 | 268 | 6 |
742827 | 742827 | 2020-11-18 | Wayne | Iowa | 19185 | 268 | 6 |
739580 | 739580 | 2020-11-17 | Wayne | Iowa | 19185 | 265 | 6 |
736336 | 736336 | 2020-11-16 | Wayne | Iowa | 19185 | 263 | 6 |
733090 | 733090 | 2020-11-15 | Wayne | Iowa | 19185 | 259 | 6 |
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);