ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
117 rows where "date" is on date 2022-01-05 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2084616 | 2084616 | 2022-01-05 | Adair | Missouri | 29001 | 4528 | 53 |
2084617 | 2084617 | 2022-01-05 | Andrew | Missouri | 29003 | 3612 | 42 |
2084618 | 2084618 | 2022-01-05 | Atchison | Missouri | 29005 | 995 | 19 |
2084619 | 2084619 | 2022-01-05 | Audrain | Missouri | 29007 | 4529 | 89 |
2084620 | 2084620 | 2022-01-05 | Barry | Missouri | 29009 | 5034 | 97 |
2084621 | 2084621 | 2022-01-05 | Barton | Missouri | 29011 | 2102 | 42 |
2084622 | 2084622 | 2022-01-05 | Bates | Missouri | 29013 | 2851 | 65 |
2084623 | 2084623 | 2022-01-05 | Benton | Missouri | 29015 | 3109 | 77 |
2084624 | 2084624 | 2022-01-05 | Bollinger | Missouri | 29017 | 2026 | 36 |
2084625 | 2084625 | 2022-01-05 | Boone | Missouri | 29019 | 30033 | 204 |
2084626 | 2084626 | 2022-01-05 | Buchanan | Missouri | 29021 | 18396 | 261 |
2084627 | 2084627 | 2022-01-05 | Butler | Missouri | 29023 | 7535 | 134 |
2084628 | 2084628 | 2022-01-05 | Caldwell | Missouri | 29025 | 1381 | 27 |
2084629 | 2084629 | 2022-01-05 | Callaway | Missouri | 29027 | 8851 | 98 |
2084630 | 2084630 | 2022-01-05 | Camden | Missouri | 29029 | 7204 | 151 |
2084631 | 2084631 | 2022-01-05 | Cape Girardeau | Missouri | 29031 | 14171 | 205 |
2084632 | 2084632 | 2022-01-05 | Carroll | Missouri | 29033 | 1744 | 39 |
2084633 | 2084633 | 2022-01-05 | Carter | Missouri | 29035 | 1189 | 19 |
2084634 | 2084634 | 2022-01-05 | Cass | Missouri | 29037 | 18284 | 231 |
2084635 | 2084635 | 2022-01-05 | Cedar | Missouri | 29039 | 2160 | 42 |
2084636 | 2084636 | 2022-01-05 | Chariton | Missouri | 29041 | 1306 | 32 |
2084637 | 2084637 | 2022-01-05 | Christian | Missouri | 29043 | 15318 | 213 |
2084638 | 2084638 | 2022-01-05 | Clark | Missouri | 29045 | 1298 | 28 |
2084639 | 2084639 | 2022-01-05 | Clay | Missouri | 29047 | 19726 | 280 |
2084640 | 2084640 | 2022-01-05 | Clinton | Missouri | 29049 | 3691 | 100 |
2084641 | 2084641 | 2022-01-05 | Cole | Missouri | 29051 | 15106 | 242 |
2084642 | 2084642 | 2022-01-05 | Cooper | Missouri | 29053 | 3309 | 63 |
2084643 | 2084643 | 2022-01-05 | Crawford | Missouri | 29055 | 4255 | 80 |
2084644 | 2084644 | 2022-01-05 | Dade | Missouri | 29057 | 1036 | 38 |
2084645 | 2084645 | 2022-01-05 | Dallas | Missouri | 29059 | 2771 | 62 |
2084646 | 2084646 | 2022-01-05 | Daviess | Missouri | 29061 | 1323 | 18 |
2084647 | 2084647 | 2022-01-05 | DeKalb | Missouri | 29063 | 1775 | 38 |
2084648 | 2084648 | 2022-01-05 | Dent | Missouri | 29065 | 2402 | 64 |
2084649 | 2084649 | 2022-01-05 | Douglas | Missouri | 29067 | 1997 | 67 |
2084650 | 2084650 | 2022-01-05 | Dunklin | Missouri | 29069 | 5023 | 93 |
2084651 | 2084651 | 2022-01-05 | Franklin | Missouri | 29071 | 18012 | 277 |
2084652 | 2084652 | 2022-01-05 | Gasconade | Missouri | 29073 | 2580 | 87 |
2084653 | 2084653 | 2022-01-05 | Gentry | Missouri | 29075 | 1727 | 28 |
2084654 | 2084654 | 2022-01-05 | Greene | Missouri | 29077 | 51335 | 851 |
2084655 | 2084655 | 2022-01-05 | Grundy | Missouri | 29079 | 1909 | 58 |
2084656 | 2084656 | 2022-01-05 | Harrison | Missouri | 29081 | 1505 | 25 |
2084657 | 2084657 | 2022-01-05 | Henry | Missouri | 29083 | 4202 | 67 |
2084658 | 2084658 | 2022-01-05 | Hickory | Missouri | 29085 | 1393 | 45 |
2084659 | 2084659 | 2022-01-05 | Holt | Missouri | 29087 | 830 | 24 |
2084660 | 2084660 | 2022-01-05 | Howard | Missouri | 29089 | 1695 | 19 |
2084661 | 2084661 | 2022-01-05 | Howell | Missouri | 29091 | 6684 | 175 |
2084662 | 2084662 | 2022-01-05 | Iron | Missouri | 29093 | 1660 | 31 |
2084663 | 2084663 | 2022-01-05 | Jackson | Missouri | 29095 | 70830 | 901 |
2084664 | 2084664 | 2022-01-05 | Jasper | Missouri | 29097 | 15597 | 265 |
2084665 | 2084665 | 2022-01-05 | Jefferson | Missouri | 29099 | 41279 | 470 |
2084666 | 2084666 | 2022-01-05 | Johnson | Missouri | 29101 | 8955 | 117 |
2084667 | 2084667 | 2022-01-05 | Joplin | Missouri | 10020 | 191 | |
2084668 | 2084668 | 2022-01-05 | Kansas City | Missouri | 82240 | 1006 | |
2084669 | 2084669 | 2022-01-05 | Knox | Missouri | 29103 | 751 | 8 |
2084670 | 2084670 | 2022-01-05 | Laclede | Missouri | 29105 | 6147 | 154 |
2084671 | 2084671 | 2022-01-05 | Lafayette | Missouri | 29107 | 6034 | 95 |
2084672 | 2084672 | 2022-01-05 | Lawrence | Missouri | 29109 | 5936 | 140 |
2084673 | 2084673 | 2022-01-05 | Lewis | Missouri | 29111 | 2062 | 31 |
2084674 | 2084674 | 2022-01-05 | Lincoln | Missouri | 29113 | 11826 | 100 |
2084675 | 2084675 | 2022-01-05 | Linn | Missouri | 29115 | 2060 | 58 |
2084676 | 2084676 | 2022-01-05 | Livingston | Missouri | 29117 | 2914 | 81 |
2084677 | 2084677 | 2022-01-05 | Macon | Missouri | 29121 | 2719 | 37 |
2084678 | 2084678 | 2022-01-05 | Madison | Missouri | 29123 | 2711 | 42 |
2084679 | 2084679 | 2022-01-05 | Maries | Missouri | 29125 | 1196 | 23 |
2084680 | 2084680 | 2022-01-05 | Marion | Missouri | 29127 | 6328 | 105 |
2084681 | 2084681 | 2022-01-05 | McDonald | Missouri | 29119 | 4371 | 64 |
2084682 | 2084682 | 2022-01-05 | Mercer | Missouri | 29129 | 548 | 11 |
2084683 | 2084683 | 2022-01-05 | Miller | Missouri | 29131 | 4625 | 104 |
2084684 | 2084684 | 2022-01-05 | Mississippi | Missouri | 29133 | 2572 | 50 |
2084685 | 2084685 | 2022-01-05 | Moniteau | Missouri | 29135 | 3008 | 46 |
2084686 | 2084686 | 2022-01-05 | Monroe | Missouri | 29137 | 1677 | 35 |
2084687 | 2084687 | 2022-01-05 | Montgomery | Missouri | 29139 | 1838 | 34 |
2084688 | 2084688 | 2022-01-05 | Morgan | Missouri | 29141 | 3131 | 75 |
2084689 | 2084689 | 2022-01-05 | New Madrid | Missouri | 29143 | 3608 | 71 |
2084690 | 2084690 | 2022-01-05 | Newton | Missouri | 29145 | 8782 | 169 |
2084691 | 2084691 | 2022-01-05 | Nodaway | Missouri | 29147 | 4496 | 39 |
2084692 | 2084692 | 2022-01-05 | Oregon | Missouri | 29149 | 1600 | 27 |
2084693 | 2084693 | 2022-01-05 | Osage | Missouri | 29151 | 2490 | 37 |
2084694 | 2084694 | 2022-01-05 | Ozark | Missouri | 29153 | 1378 | 47 |
2084695 | 2084695 | 2022-01-05 | Pemiscot | Missouri | 29155 | 2266 | 59 |
2084696 | 2084696 | 2022-01-05 | Perry | Missouri | 29157 | 3798 | 41 |
2084697 | 2084697 | 2022-01-05 | Pettis | Missouri | 29159 | 8697 | 131 |
2084698 | 2084698 | 2022-01-05 | Phelps | Missouri | 29161 | 7711 | 204 |
2084699 | 2084699 | 2022-01-05 | Pike | Missouri | 29163 | 3260 | 54 |
2084700 | 2084700 | 2022-01-05 | Platte | Missouri | 29165 | 7591 | 78 |
2084701 | 2084701 | 2022-01-05 | Polk | Missouri | 29167 | 6021 | 83 |
2084702 | 2084702 | 2022-01-05 | Pulaski | Missouri | 29169 | 6003 | 101 |
2084703 | 2084703 | 2022-01-05 | Putnam | Missouri | 29171 | 782 | 20 |
2084704 | 2084704 | 2022-01-05 | Ralls | Missouri | 29173 | 1949 | 19 |
2084705 | 2084705 | 2022-01-05 | Randolph | Missouri | 29175 | 4401 | 86 |
2084706 | 2084706 | 2022-01-05 | Ray | Missouri | 29177 | 3893 | 69 |
2084707 | 2084707 | 2022-01-05 | Reynolds | Missouri | 29179 | 863 | 17 |
2084708 | 2084708 | 2022-01-05 | Ripley | Missouri | 29181 | 2194 | 52 |
2084709 | 2084709 | 2022-01-05 | Saline | Missouri | 29195 | 4809 | 89 |
2084710 | 2084710 | 2022-01-05 | Schuyler | Missouri | 29197 | 562 | 22 |
2084711 | 2084711 | 2022-01-05 | Scotland | Missouri | 29199 | 522 | 17 |
2084712 | 2084712 | 2022-01-05 | Scott | Missouri | 29201 | 8166 | 136 |
2084713 | 2084713 | 2022-01-05 | Shannon | Missouri | 29203 | 1209 | 30 |
2084714 | 2084714 | 2022-01-05 | Shelby | Missouri | 29205 | 1164 | 13 |
2084715 | 2084715 | 2022-01-05 | St. Charles | Missouri | 29183 | 77648 | 760 |
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);