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 deaths
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 |
1782 | 1782 | 2020-03-13 | St. Louis | Missouri | 29189 | 2 | 0 |
2125 | 2125 | 2020-03-14 | Greene | Missouri | 29077 | 2 | 0 |
2126 | 2126 | 2020-03-14 | Henry | Missouri | 29083 | 1 | 0 |
2127 | 2127 | 2020-03-14 | St. Louis | Missouri | 29189 | 2 | 0 |
2532 | 2532 | 2020-03-15 | Greene | Missouri | 29077 | 2 | 0 |
2533 | 2533 | 2020-03-15 | Henry | Missouri | 29083 | 1 | 0 |
2534 | 2534 | 2020-03-15 | St. Louis | Missouri | 29189 | 2 | 0 |
2986 | 2986 | 2020-03-16 | Cass | Missouri | 29037 | 1 | 0 |
2987 | 2987 | 2020-03-16 | Greene | Missouri | 29077 | 3 | 0 |
2988 | 2988 | 2020-03-16 | Henry | Missouri | 29083 | 1 | 0 |
2989 | 2989 | 2020-03-16 | St. Louis | Missouri | 29189 | 4 | 0 |
3493 | 3493 | 2020-03-17 | Boone | Missouri | 29019 | 1 | 0 |
3494 | 3494 | 2020-03-17 | Cass | Missouri | 29037 | 2 | 0 |
3495 | 3495 | 2020-03-17 | Cole | Missouri | 29051 | 1 | 0 |
3496 | 3496 | 2020-03-17 | Greene | Missouri | 29077 | 4 | 0 |
3497 | 3497 | 2020-03-17 | Henry | Missouri | 29083 | 1 | 0 |
3498 | 3498 | 2020-03-17 | Jackson | Missouri | 29095 | 2 | 0 |
3499 | 3499 | 2020-03-17 | St. Louis | Missouri | 29189 | 5 | 0 |
4083 | 4083 | 2020-03-18 | Cass | Missouri | 29037 | 2 | 0 |
4084 | 4084 | 2020-03-18 | Cole | Missouri | 29051 | 2 | 0 |
4085 | 4085 | 2020-03-18 | Greene | Missouri | 29077 | 4 | 0 |
4086 | 4086 | 2020-03-18 | Henry | Missouri | 29083 | 1 | 0 |
4087 | 4087 | 2020-03-18 | Jackson | Missouri | 29095 | 3 | 0 |
4088 | 4088 | 2020-03-18 | St. Charles | Missouri | 29183 | 1 | 0 |
4089 | 4089 | 2020-03-18 | St. Louis | Missouri | 29189 | 6 | 0 |
4090 | 4090 | 2020-03-18 | St. Louis city | Missouri | 29510 | 1 | 0 |
4802 | 4802 | 2020-03-19 | Cass | Missouri | 29037 | 4 | 0 |
4803 | 4803 | 2020-03-19 | Cole | Missouri | 29051 | 2 | 0 |
4804 | 4804 | 2020-03-19 | Greene | Missouri | 29077 | 6 | 0 |
4805 | 4805 | 2020-03-19 | Henry | Missouri | 29083 | 1 | 0 |
4806 | 4806 | 2020-03-19 | Jackson | Missouri | 29095 | 3 | 0 |
4807 | 4807 | 2020-03-19 | St. Charles | Missouri | 29183 | 1 | 0 |
4808 | 4808 | 2020-03-19 | St. Louis | Missouri | 29189 | 10 | 0 |
4809 | 4809 | 2020-03-19 | St. Louis city | Missouri | 29510 | 5 | 0 |
5635 | 5635 | 2020-03-20 | Cass | Missouri | 29037 | 6 | 0 |
5636 | 5636 | 2020-03-20 | Christian | Missouri | 29043 | 2 | 0 |
5637 | 5637 | 2020-03-20 | Cole | Missouri | 29051 | 3 | 0 |
5638 | 5638 | 2020-03-20 | Dunklin | Missouri | 29069 | 1 | 0 |
5639 | 5639 | 2020-03-20 | Greene | Missouri | 29077 | 8 | 0 |
5640 | 5640 | 2020-03-20 | Henry | Missouri | 29083 | 1 | 0 |
5642 | 5642 | 2020-03-20 | Kansas City | Missouri | 12 | 0 | |
5643 | 5643 | 2020-03-20 | Pulaski | Missouri | 29169 | 1 | 0 |
5644 | 5644 | 2020-03-20 | Scott | Missouri | 29201 | 1 | 0 |
5645 | 5645 | 2020-03-20 | St. Charles | Missouri | 29183 | 3 | 0 |
5647 | 5647 | 2020-03-20 | St. Louis city | Missouri | 29510 | 6 | 0 |
5648 | 5648 | 2020-03-20 | Unknown | Missouri | 1 | 0 | |
6621 | 6621 | 2020-03-21 | Bates | Missouri | 29013 | 1 | 0 |
6623 | 6623 | 2020-03-21 | Cass | Missouri | 29037 | 6 | 0 |
6624 | 6624 | 2020-03-21 | Christian | Missouri | 29043 | 2 | 0 |
6625 | 6625 | 2020-03-21 | Cole | Missouri | 29051 | 3 | 0 |
6626 | 6626 | 2020-03-21 | Dunklin | Missouri | 29069 | 1 | 0 |
6627 | 6627 | 2020-03-21 | Greene | Missouri | 29077 | 10 | 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 |
6632 | 6632 | 2020-03-21 | Kansas City | Missouri | 13 | 0 | |
6633 | 6633 | 2020-03-21 | Pulaski | Missouri | 29169 | 1 | 0 |
6634 | 6634 | 2020-03-21 | Scott | Missouri | 29201 | 1 | 0 |
6635 | 6635 | 2020-03-21 | St. Charles | Missouri | 29183 | 3 | 0 |
6637 | 6637 | 2020-03-21 | St. Louis city | Missouri | 29510 | 10 | 0 |
6638 | 6638 | 2020-03-21 | Unknown | Missouri | 1 | 0 | |
7710 | 7710 | 2020-03-22 | Bates | Missouri | 29013 | 1 | 0 |
7712 | 7712 | 2020-03-22 | Cass | Missouri | 29037 | 6 | 0 |
7713 | 7713 | 2020-03-22 | Christian | Missouri | 29043 | 2 | 0 |
7714 | 7714 | 2020-03-22 | Cole | Missouri | 29051 | 3 | 0 |
7715 | 7715 | 2020-03-22 | Dunklin | Missouri | 29069 | 1 | 0 |
7716 | 7716 | 2020-03-22 | Greene | Missouri | 29077 | 10 | 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 |
7721 | 7721 | 2020-03-22 | Kansas City | Missouri | 13 | 0 | |
7722 | 7722 | 2020-03-22 | Pulaski | Missouri | 29169 | 1 | 0 |
7723 | 7723 | 2020-03-22 | Scott | Missouri | 29201 | 1 | 0 |
7724 | 7724 | 2020-03-22 | St. Charles | Missouri | 29183 | 3 | 0 |
7726 | 7726 | 2020-03-22 | St. Louis city | Missouri | 29510 | 14 | 0 |
7727 | 7727 | 2020-03-22 | Unknown | Missouri | 1 | 0 | |
8893 | 8893 | 2020-03-23 | Adair | Missouri | 29001 | 2 | 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 |
8898 | 8898 | 2020-03-23 | Cass | Missouri | 29037 | 6 | 0 |
8899 | 8899 | 2020-03-23 | Christian | Missouri | 29043 | 2 | 0 |
8900 | 8900 | 2020-03-23 | Clay | Missouri | 29047 | 3 | 0 |
8901 | 8901 | 2020-03-23 | Clinton | Missouri | 29049 | 1 | 0 |
8902 | 8902 | 2020-03-23 | Cole | Missouri | 29051 | 5 | 0 |
8903 | 8903 | 2020-03-23 | Dunklin | Missouri | 29069 | 1 | 0 |
8904 | 8904 | 2020-03-23 | Greene | Missouri | 29077 | 17 | 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 |
8909 | 8909 | 2020-03-23 | Kansas City | Missouri | 18 | 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);