ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
89,600 rows where state = "Missouri" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
county 118
- St. Louis 798
- Greene 793
- Henry 792
- Cass 789
- Boone 788
- Cole 788
- Jackson 788
- St. Charles 787
- St. Louis city 787
- Christian 785
- Dunklin 785
- Kansas City 785
- Pulaski 785
- Scott 785
- Bates 784
- Jasper 784
- Johnson 784
- Adair 782
- Callaway 782
- Camden 782
- Clay 782
- Clinton 782
- Lafayette 782
- Moniteau 782
- Perry 782
- St. Francois 782
- Taney 782
- Cape Girardeau 781
- Franklin 781
- Jefferson 781
- Pemiscot 781
- Cooper 780
- McDonald 780
- Montgomery 780
- Newton 780
- Platte 780
- Ralls 780
- Randolph 780
- Shelby 780
- Benton 779
- Bollinger 779
- Carter 779
- Stoddard 779
- Atchison 778
- Barry 778
- Buchanan 778
- Chariton 778
- Lincoln 778
- Pettis 778
- Ray 778
- Wright 778
- Ripley 777
- Warren 777
- Cedar 775
- Crawford 775
- Livingston 775
- Macon 775
- Maries 775
- Morgan 775
- Osage 775
- Pike 775
- Reynolds 775
- Stone 775
- Webster 775
- Harrison 774
- Ste. Genevieve 774
- Butler 773
- Caldwell 773
- DeKalb 773
- Gasconade 773
- Howell 772
- New Madrid 772
- Clark 771
- Linn 771
- Saline 771
- Nodaway 770
- Gentry 768
- Madison 768
- Phelps 768
- Worth 768
- Dallas 767
- Howard 767
- Oregon 767
- Polk 767
- Scotland 767
- Washington 766
- St. Clair 765
- Vernon 765
- Andrew 763
- Iron 763
- Daviess 759
- Holt 759
- Miller 759
- Lewis 756
- Marion 756
- Audrain 755
- Carroll 752
- Mississippi 752
- Lawrence 741
- Sullivan 741
- Laclede 735
- Dent 729
- Schuyler 728
- Grundy 721
- Monroe 717
- Shannon 717
- Texas 715
- Douglas 713
- Mercer 713
- Putnam 706
- Knox 703
- Barton 702
- Dade 698
- Ozark 693
- Wayne 693
- Joplin 688
- Hickory 675
- Unknown 38
fips 116
- - 1,511
- 29189 798
- 29077 793
- 29083 792
- 29037 789
- 29019 788
- 29051 788
- 29095 788
- 29183 787
- 29510 787
- 29043 785
- 29069 785
- 29169 785
- 29201 785
- 29013 784
- 29097 784
- 29101 784
- 29001 782
- 29027 782
- 29029 782
- 29047 782
- 29049 782
- 29107 782
- 29135 782
- 29157 782
- 29187 782
- 29213 782
- 29031 781
- 29071 781
- 29099 781
- 29155 781
- 29053 780
- 29119 780
- 29139 780
- 29145 780
- 29165 780
- 29173 780
- 29175 780
- 29205 780
- 29015 779
- 29017 779
- 29035 779
- 29207 779
- 29005 778
- 29009 778
- 29021 778
- 29041 778
- 29113 778
- 29159 778
- 29177 778
- 29229 778
- 29181 777
- 29219 777
- 29039 775
- 29055 775
- 29117 775
- 29121 775
- 29125 775
- 29141 775
- 29151 775
- 29163 775
- 29179 775
- 29209 775
- 29225 775
- 29081 774
- 29186 774
- 29023 773
- 29025 773
- 29063 773
- 29073 773
- 29091 772
- 29143 772
- 29045 771
- 29115 771
- 29195 771
- 29147 770
- 29075 768
- 29123 768
- 29161 768
- 29227 768
- 29059 767
- 29089 767
- 29149 767
- 29167 767
- 29199 767
- 29221 766
- 29185 765
- 29217 765
- 29003 763
- 29093 763
- 29061 759
- 29087 759
- 29131 759
- 29111 756
- 29127 756
- 29007 755
- 29033 752
- 29133 752
- 29109 741
- 29211 741
- 29105 735
- 29065 729
- 29197 728
- 29079 721
- 29137 717
- 29203 717
- 29215 715
- 29067 713
- 29129 713
- 29171 706
- 29103 703
- 29011 702
- 29057 698
- 29153 693
- 29223 693
- 29085 675
state 1
- Missouri · 89,600 ✖
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
707 | 707 | 2020-03-07 | St. Louis | Missouri | 29189 | 1 | 0 |
811 | 811 | 2020-03-08 | St. Louis | Missouri | 29189 | 1 | 0 |
935 | 935 | 2020-03-09 | St. Louis | Missouri | 29189 | 1 | 0 |
1085 | 1085 | 2020-03-10 | St. Louis | Missouri | 29189 | 1 | 0 |
1267 | 1267 | 2020-03-11 | St. Louis | Missouri | 29189 | 1 | 0 |
1493 | 1493 | 2020-03-12 | Greene | Missouri | 29077 | 1 | 0 |
1494 | 1494 | 2020-03-12 | St. Louis | Missouri | 29189 | 1 | 0 |
1780 | 1780 | 2020-03-13 | Greene | Missouri | 29077 | 1 | 0 |
1781 | 1781 | 2020-03-13 | Henry | Missouri | 29083 | 1 | 0 |
2126 | 2126 | 2020-03-14 | Henry | Missouri | 29083 | 1 | 0 |
2533 | 2533 | 2020-03-15 | Henry | Missouri | 29083 | 1 | 0 |
2986 | 2986 | 2020-03-16 | Cass | Missouri | 29037 | 1 | 0 |
2988 | 2988 | 2020-03-16 | Henry | Missouri | 29083 | 1 | 0 |
3493 | 3493 | 2020-03-17 | Boone | Missouri | 29019 | 1 | 0 |
3495 | 3495 | 2020-03-17 | Cole | Missouri | 29051 | 1 | 0 |
3497 | 3497 | 2020-03-17 | Henry | Missouri | 29083 | 1 | 0 |
4082 | 4082 | 2020-03-18 | Boone | Missouri | 29019 | 1 | 1 |
4086 | 4086 | 2020-03-18 | Henry | Missouri | 29083 | 1 | 0 |
4088 | 4088 | 2020-03-18 | St. Charles | Missouri | 29183 | 1 | 0 |
4090 | 4090 | 2020-03-18 | St. Louis city | Missouri | 29510 | 1 | 0 |
4805 | 4805 | 2020-03-19 | Henry | Missouri | 29083 | 1 | 0 |
4807 | 4807 | 2020-03-19 | St. Charles | Missouri | 29183 | 1 | 0 |
5638 | 5638 | 2020-03-20 | Dunklin | Missouri | 29069 | 1 | 0 |
5640 | 5640 | 2020-03-20 | Henry | Missouri | 29083 | 1 | 0 |
5643 | 5643 | 2020-03-20 | Pulaski | Missouri | 29169 | 1 | 0 |
5644 | 5644 | 2020-03-20 | Scott | Missouri | 29201 | 1 | 0 |
5648 | 5648 | 2020-03-20 | Unknown | Missouri | 1 | 0 | |
6621 | 6621 | 2020-03-21 | Bates | Missouri | 29013 | 1 | 0 |
6626 | 6626 | 2020-03-21 | Dunklin | Missouri | 29069 | 1 | 0 |
6628 | 6628 | 2020-03-21 | Henry | Missouri | 29083 | 1 | 0 |
6630 | 6630 | 2020-03-21 | Jasper | Missouri | 29097 | 1 | 0 |
6631 | 6631 | 2020-03-21 | Johnson | Missouri | 29101 | 1 | 0 |
6633 | 6633 | 2020-03-21 | Pulaski | Missouri | 29169 | 1 | 0 |
6634 | 6634 | 2020-03-21 | Scott | Missouri | 29201 | 1 | 0 |
6638 | 6638 | 2020-03-21 | Unknown | Missouri | 1 | 0 | |
7710 | 7710 | 2020-03-22 | Bates | Missouri | 29013 | 1 | 0 |
7715 | 7715 | 2020-03-22 | Dunklin | Missouri | 29069 | 1 | 0 |
7717 | 7717 | 2020-03-22 | Henry | Missouri | 29083 | 1 | 0 |
7719 | 7719 | 2020-03-22 | Jasper | Missouri | 29097 | 1 | 0 |
7720 | 7720 | 2020-03-22 | Johnson | Missouri | 29101 | 1 | 0 |
7722 | 7722 | 2020-03-22 | Pulaski | Missouri | 29169 | 1 | 0 |
7723 | 7723 | 2020-03-22 | Scott | Missouri | 29201 | 1 | 0 |
7727 | 7727 | 2020-03-22 | Unknown | Missouri | 1 | 0 | |
8894 | 8894 | 2020-03-23 | Bates | Missouri | 29013 | 1 | 0 |
8896 | 8896 | 2020-03-23 | Callaway | Missouri | 29027 | 1 | 0 |
8897 | 8897 | 2020-03-23 | Camden | Missouri | 29029 | 1 | 0 |
8901 | 8901 | 2020-03-23 | Clinton | Missouri | 29049 | 1 | 0 |
8903 | 8903 | 2020-03-23 | Dunklin | Missouri | 29069 | 1 | 0 |
8905 | 8905 | 2020-03-23 | Henry | Missouri | 29083 | 1 | 0 |
8907 | 8907 | 2020-03-23 | Jasper | Missouri | 29097 | 1 | 0 |
8908 | 8908 | 2020-03-23 | Johnson | Missouri | 29101 | 1 | 0 |
8910 | 8910 | 2020-03-23 | Lafayette | Missouri | 29107 | 1 | 0 |
8911 | 8911 | 2020-03-23 | Moniteau | Missouri | 29135 | 1 | 0 |
8912 | 8912 | 2020-03-23 | Perry | Missouri | 29157 | 1 | 0 |
8913 | 8913 | 2020-03-23 | Pulaski | Missouri | 29169 | 1 | 0 |
8914 | 8914 | 2020-03-23 | Scott | Missouri | 29201 | 1 | 0 |
8916 | 8916 | 2020-03-23 | St. Francois | Missouri | 29187 | 1 | 0 |
8919 | 8919 | 2020-03-23 | Taney | Missouri | 29213 | 1 | 0 |
8920 | 8920 | 2020-03-23 | Unknown | Missouri | 1 | 0 | |
10192 | 10192 | 2020-03-24 | Bates | Missouri | 29013 | 1 | 0 |
10195 | 10195 | 2020-03-24 | Camden | Missouri | 29029 | 1 | 0 |
10196 | 10196 | 2020-03-24 | Cape Girardeau | Missouri | 29031 | 1 | 0 |
10200 | 10200 | 2020-03-24 | Clinton | Missouri | 29049 | 1 | 0 |
10202 | 10202 | 2020-03-24 | Dunklin | Missouri | 29069 | 1 | 0 |
10203 | 10203 | 2020-03-24 | Franklin | Missouri | 29071 | 1 | 0 |
10205 | 10205 | 2020-03-24 | Henry | Missouri | 29083 | 1 | 0 |
10207 | 10207 | 2020-03-24 | Jasper | Missouri | 29097 | 1 | 0 |
10209 | 10209 | 2020-03-24 | Johnson | Missouri | 29101 | 1 | 0 |
10211 | 10211 | 2020-03-24 | Lafayette | Missouri | 29107 | 1 | 0 |
10212 | 10212 | 2020-03-24 | Moniteau | Missouri | 29135 | 1 | 0 |
10213 | 10213 | 2020-03-24 | Pemiscot | Missouri | 29155 | 1 | 0 |
10216 | 10216 | 2020-03-24 | Scott | Missouri | 29201 | 1 | 0 |
10218 | 10218 | 2020-03-24 | St. Francois | Missouri | 29187 | 1 | 0 |
10221 | 10221 | 2020-03-24 | Taney | Missouri | 29213 | 1 | 0 |
11613 | 11613 | 2020-03-25 | Bates | Missouri | 29013 | 1 | 0 |
11616 | 11616 | 2020-03-25 | Camden | Missouri | 29029 | 1 | 0 |
11621 | 11621 | 2020-03-25 | Clinton | Missouri | 29049 | 1 | 0 |
11623 | 11623 | 2020-03-25 | Cooper | Missouri | 29053 | 1 | 0 |
11624 | 11624 | 2020-03-25 | Dunklin | Missouri | 29069 | 1 | 0 |
11627 | 11627 | 2020-03-25 | Henry | Missouri | 29083 | 1 | 0 |
11634 | 11634 | 2020-03-25 | McDonald | Missouri | 29119 | 1 | 0 |
11636 | 11636 | 2020-03-25 | Montgomery | Missouri | 29139 | 1 | 0 |
11637 | 11637 | 2020-03-25 | Newton | Missouri | 29145 | 1 | 0 |
11638 | 11638 | 2020-03-25 | Pemiscot | Missouri | 29155 | 1 | 0 |
11642 | 11642 | 2020-03-25 | Ralls | Missouri | 29173 | 1 | 0 |
11643 | 11643 | 2020-03-25 | Randolph | Missouri | 29175 | 1 | 0 |
11644 | 11644 | 2020-03-25 | Scott | Missouri | 29201 | 1 | 0 |
11645 | 11645 | 2020-03-25 | Shelby | Missouri | 29205 | 1 | 0 |
11650 | 11650 | 2020-03-25 | Taney | Missouri | 29213 | 1 | 0 |
13208 | 13208 | 2020-03-26 | Bates | Missouri | 29013 | 1 | 0 |
13209 | 13209 | 2020-03-26 | Benton | Missouri | 29015 | 1 | 0 |
13210 | 13210 | 2020-03-26 | Bollinger | Missouri | 29017 | 1 | 0 |
13213 | 13213 | 2020-03-26 | Camden | Missouri | 29029 | 1 | 0 |
13215 | 13215 | 2020-03-26 | Carter | Missouri | 29035 | 1 | 0 |
13219 | 13219 | 2020-03-26 | Clinton | Missouri | 29049 | 1 | 0 |
13221 | 13221 | 2020-03-26 | Cooper | Missouri | 29053 | 1 | 0 |
13225 | 13225 | 2020-03-26 | Henry | Missouri | 29083 | 1 | 0 |
13232 | 13232 | 2020-03-26 | McDonald | Missouri | 29119 | 1 | 0 |
13236 | 13236 | 2020-03-26 | Pemiscot | Missouri | 29155 | 1 | 0 |
13240 | 13240 | 2020-03-26 | Ralls | Missouri | 29173 | 1 | 0 |
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);