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 state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- 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
- …
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 |
4082 | 4082 | 2020-03-18 | Boone | Missouri | 29019 | 1 | 1 |
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 |
4801 | 4801 | 2020-03-19 | Boone | Missouri | 29019 | 3 | 1 |
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 |
5634 | 5634 | 2020-03-20 | Boone | Missouri | 29019 | 10 | 1 |
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 |
5641 | 5641 | 2020-03-20 | Jackson | Missouri | 29095 | 5 | 1 |
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 |
5646 | 5646 | 2020-03-20 | St. Louis | Missouri | 29189 | 13 | 1 |
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 |
6622 | 6622 | 2020-03-21 | Boone | Missouri | 29019 | 11 | 1 |
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 |
6629 | 6629 | 2020-03-21 | Jackson | Missouri | 29095 | 5 | 1 |
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 |
6636 | 6636 | 2020-03-21 | St. Louis | Missouri | 29189 | 22 | 1 |
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 |
7711 | 7711 | 2020-03-22 | Boone | Missouri | 29019 | 11 | 1 |
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 |
7718 | 7718 | 2020-03-22 | Jackson | Missouri | 29095 | 5 | 1 |
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 |
7725 | 7725 | 2020-03-22 | St. Louis | Missouri | 29189 | 55 | 1 |
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 |
8895 | 8895 | 2020-03-23 | Boone | Missouri | 29019 | 17 | 1 |
8896 | 8896 | 2020-03-23 | Callaway | Missouri | 29027 | 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);