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)
fips >30
county >30
- St. Louis 792
- Greene 791
- Cass 788
- Jackson 788
- Cole 787
- Boone 786
- St. Louis city 786
- Christian 785
- Kansas City 785
- St. Charles 785
- Adair 782
- Clay 782
- Callaway 781
- Jefferson 781
- Perry 781
- Pulaski 781
- Cape Girardeau 780
- Franklin 780
- Jasper 780
- Johnson 780
- Lafayette 780
- Moniteau 780
- Platte 780
- St. Francois 780
- Dunklin 779
- Montgomery 779
- Newton 779
- Randolph 779
- Scott 779
- Shelby 779
- …
state 1
- Missouri · 89,500 ✖
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
13241 | 13241 | 2020-03-26 | Randolph | Missouri | 29175 | 1 | 0 |
13242 | 13242 | 2020-03-26 | Scott | Missouri | 29201 | 1 | 0 |
13243 | 13243 | 2020-03-26 | Shelby | Missouri | 29205 | 1 | 0 |
13248 | 13248 | 2020-03-26 | Stoddard | Missouri | 29207 | 1 | 0 |
13249 | 13249 | 2020-03-26 | Taney | Missouri | 29213 | 1 | 0 |
14929 | 14929 | 2020-03-27 | Atchison | Missouri | 29005 | 1 | 0 |
14930 | 14930 | 2020-03-27 | Barry | Missouri | 29009 | 1 | 0 |
14931 | 14931 | 2020-03-27 | Bates | Missouri | 29013 | 1 | 0 |
14932 | 14932 | 2020-03-27 | Benton | Missouri | 29015 | 1 | 0 |
14933 | 14933 | 2020-03-27 | Bollinger | Missouri | 29017 | 1 | 0 |
14937 | 14937 | 2020-03-27 | Camden | Missouri | 29029 | 1 | 0 |
14939 | 14939 | 2020-03-27 | Carter | Missouri | 29035 | 1 | 0 |
14941 | 14941 | 2020-03-27 | Chariton | Missouri | 29041 | 1 | 0 |
14944 | 14944 | 2020-03-27 | Clinton | Missouri | 29049 | 1 | 0 |
14946 | 14946 | 2020-03-27 | Cooper | Missouri | 29053 | 1 | 0 |
14950 | 14950 | 2020-03-27 | Henry | Missouri | 29083 | 1 | 0 |
14958 | 14958 | 2020-03-27 | McDonald | Missouri | 29119 | 1 | 0 |
14962 | 14962 | 2020-03-27 | Pemiscot | Missouri | 29155 | 1 | 0 |
14964 | 14964 | 2020-03-27 | Pettis | Missouri | 29159 | 1 | 0 |
14967 | 14967 | 2020-03-27 | Ralls | Missouri | 29173 | 1 | 0 |
14968 | 14968 | 2020-03-27 | Randolph | Missouri | 29175 | 1 | 0 |
14969 | 14969 | 2020-03-27 | Ray | Missouri | 29177 | 1 | 0 |
14970 | 14970 | 2020-03-27 | Scott | Missouri | 29201 | 1 | 0 |
14971 | 14971 | 2020-03-27 | Shelby | Missouri | 29205 | 1 | 0 |
14976 | 14976 | 2020-03-27 | Stoddard | Missouri | 29207 | 1 | 0 |
14977 | 14977 | 2020-03-27 | Taney | Missouri | 29213 | 1 | 0 |
14979 | 14979 | 2020-03-27 | Wright | Missouri | 29229 | 1 | 0 |
16753 | 16753 | 2020-03-28 | Atchison | Missouri | 29005 | 1 | 0 |
16754 | 16754 | 2020-03-28 | Barry | Missouri | 29009 | 1 | 0 |
16755 | 16755 | 2020-03-28 | Bates | Missouri | 29013 | 1 | 0 |
16756 | 16756 | 2020-03-28 | Benton | Missouri | 29015 | 1 | 0 |
16757 | 16757 | 2020-03-28 | Bollinger | Missouri | 29017 | 1 | 0 |
16765 | 16765 | 2020-03-28 | Chariton | Missouri | 29041 | 1 | 0 |
16768 | 16768 | 2020-03-28 | Clinton | Missouri | 29049 | 1 | 0 |
16770 | 16770 | 2020-03-28 | Cooper | Missouri | 29053 | 1 | 0 |
16774 | 16774 | 2020-03-28 | Henry | Missouri | 29083 | 1 | 0 |
16782 | 16782 | 2020-03-28 | McDonald | Missouri | 29119 | 1 | 0 |
16786 | 16786 | 2020-03-28 | Pemiscot | Missouri | 29155 | 1 | 0 |
16788 | 16788 | 2020-03-28 | Pettis | Missouri | 29159 | 1 | 0 |
16791 | 16791 | 2020-03-28 | Ralls | Missouri | 29173 | 1 | 0 |
16792 | 16792 | 2020-03-28 | Randolph | Missouri | 29175 | 1 | 0 |
16793 | 16793 | 2020-03-28 | Ray | Missouri | 29177 | 1 | 0 |
16794 | 16794 | 2020-03-28 | Ripley | Missouri | 29181 | 1 | 0 |
16796 | 16796 | 2020-03-28 | Shelby | Missouri | 29205 | 1 | 0 |
16801 | 16801 | 2020-03-28 | Stoddard | Missouri | 29207 | 1 | 0 |
16804 | 16804 | 2020-03-28 | Warren | Missouri | 29219 | 1 | 0 |
16805 | 16805 | 2020-03-28 | Wright | Missouri | 29229 | 1 | 0 |
18675 | 18675 | 2020-03-29 | Atchison | Missouri | 29005 | 1 | 0 |
18676 | 18676 | 2020-03-29 | Barry | Missouri | 29009 | 1 | 0 |
18678 | 18678 | 2020-03-29 | Benton | Missouri | 29015 | 1 | 0 |
18679 | 18679 | 2020-03-29 | Bollinger | Missouri | 29017 | 1 | 0 |
18687 | 18687 | 2020-03-29 | Chariton | Missouri | 29041 | 1 | 0 |
18690 | 18690 | 2020-03-29 | Clinton | Missouri | 29049 | 1 | 0 |
18692 | 18692 | 2020-03-29 | Cooper | Missouri | 29053 | 1 | 0 |
18696 | 18696 | 2020-03-29 | Henry | Missouri | 29083 | 1 | 1 |
18704 | 18704 | 2020-03-29 | McDonald | Missouri | 29119 | 1 | 0 |
18708 | 18708 | 2020-03-29 | Pemiscot | Missouri | 29155 | 1 | 0 |
18710 | 18710 | 2020-03-29 | Pettis | Missouri | 29159 | 1 | 0 |
18713 | 18713 | 2020-03-29 | Ralls | Missouri | 29173 | 1 | 0 |
18714 | 18714 | 2020-03-29 | Randolph | Missouri | 29175 | 1 | 0 |
18715 | 18715 | 2020-03-29 | Ray | Missouri | 29177 | 1 | 0 |
18718 | 18718 | 2020-03-29 | Shelby | Missouri | 29205 | 1 | 0 |
20699 | 20699 | 2020-03-30 | Atchison | Missouri | 29005 | 1 | 0 |
20700 | 20700 | 2020-03-30 | Barry | Missouri | 29009 | 1 | 0 |
20701 | 20701 | 2020-03-30 | Bates | Missouri | 29013 | 1 | 0 |
20702 | 20702 | 2020-03-30 | Benton | Missouri | 29015 | 1 | 0 |
20703 | 20703 | 2020-03-30 | Bollinger | Missouri | 29017 | 1 | 0 |
20717 | 20717 | 2020-03-30 | Cooper | Missouri | 29053 | 1 | 0 |
20718 | 20718 | 2020-03-30 | Crawford | Missouri | 29055 | 1 | 0 |
20722 | 20722 | 2020-03-30 | Henry | Missouri | 29083 | 1 | 1 |
20730 | 20730 | 2020-03-30 | Livingston | Missouri | 29117 | 1 | 0 |
20731 | 20731 | 2020-03-30 | Macon | Missouri | 29121 | 1 | 0 |
20732 | 20732 | 2020-03-30 | Maries | Missouri | 29125 | 1 | 0 |
20736 | 20736 | 2020-03-30 | Morgan | Missouri | 29141 | 1 | 0 |
20738 | 20738 | 2020-03-30 | Osage | Missouri | 29151 | 1 | 0 |
20741 | 20741 | 2020-03-30 | Pettis | Missouri | 29159 | 1 | 0 |
20742 | 20742 | 2020-03-30 | Pike | Missouri | 29163 | 1 | 0 |
20745 | 20745 | 2020-03-30 | Ralls | Missouri | 29173 | 1 | 0 |
20746 | 20746 | 2020-03-30 | Randolph | Missouri | 29175 | 1 | 0 |
20747 | 20747 | 2020-03-30 | Ray | Missouri | 29177 | 1 | 0 |
20751 | 20751 | 2020-03-30 | Shelby | Missouri | 29205 | 1 | 0 |
20757 | 20757 | 2020-03-30 | Stone | Missouri | 29209 | 1 | 0 |
20761 | 20761 | 2020-03-30 | Webster | Missouri | 29225 | 1 | 0 |
22817 | 22817 | 2020-03-31 | Atchison | Missouri | 29005 | 1 | 0 |
22818 | 22818 | 2020-03-31 | Barry | Missouri | 29009 | 1 | 0 |
22819 | 22819 | 2020-03-31 | Bates | Missouri | 29013 | 1 | 0 |
22821 | 22821 | 2020-03-31 | Bollinger | Missouri | 29017 | 1 | 0 |
22836 | 22836 | 2020-03-31 | Crawford | Missouri | 29055 | 1 | 0 |
22840 | 22840 | 2020-03-31 | Harrison | Missouri | 29081 | 1 | 0 |
22841 | 22841 | 2020-03-31 | Henry | Missouri | 29083 | 1 | 1 |
22849 | 22849 | 2020-03-31 | Livingston | Missouri | 29117 | 1 | 0 |
22851 | 22851 | 2020-03-31 | Maries | Missouri | 29125 | 1 | 0 |
22855 | 22855 | 2020-03-31 | Morgan | Missouri | 29141 | 1 | 0 |
22857 | 22857 | 2020-03-31 | Osage | Missouri | 29151 | 1 | 0 |
22860 | 22860 | 2020-03-31 | Pettis | Missouri | 29159 | 1 | 0 |
22861 | 22861 | 2020-03-31 | Pike | Missouri | 29163 | 1 | 0 |
22864 | 22864 | 2020-03-31 | Ralls | Missouri | 29173 | 1 | 0 |
22866 | 22866 | 2020-03-31 | Ray | Missouri | 29177 | 1 | 0 |
22870 | 22870 | 2020-03-31 | Shelby | Missouri | 29205 | 1 | 0 |
22877 | 22877 | 2020-03-31 | Stone | Missouri | 29209 | 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);