ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
45 rows where cases = 366 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1581049 | 1581049 | 2021-08-03 | Schuyler | Missouri | 29197 | 366 | 7 |
1577800 | 1577800 | 2021-08-02 | Schuyler | Missouri | 29197 | 366 | 7 |
1574552 | 1574552 | 2021-08-01 | Schuyler | Missouri | 29197 | 366 | 7 |
1571304 | 1571304 | 2021-07-31 | Schuyler | Missouri | 29197 | 366 | 7 |
1568056 | 1568056 | 2021-07-30 | Schuyler | Missouri | 29197 | 366 | 7 |
1564808 | 1564808 | 2021-07-29 | Schuyler | Missouri | 29197 | 366 | 7 |
1561560 | 1561560 | 2021-07-28 | Schuyler | Missouri | 29197 | 366 | 7 |
1558312 | 1558312 | 2021-07-27 | Schuyler | Missouri | 29197 | 366 | 7 |
1555065 | 1555065 | 2021-07-26 | Schuyler | Missouri | 29197 | 366 | 7 |
1551818 | 1551818 | 2021-07-25 | Schuyler | Missouri | 29197 | 366 | 7 |
1077764 | 1077764 | 2021-03-01 | Holt | Missouri | 29087 | 366 | 10 |
1074518 | 1074518 | 2021-02-28 | Holt | Missouri | 29087 | 366 | 10 |
1071272 | 1071272 | 2021-02-27 | Holt | Missouri | 29087 | 366 | 10 |
1068027 | 1068027 | 2021-02-26 | Holt | Missouri | 29087 | 366 | 10 |
1064782 | 1064782 | 2021-02-25 | Holt | Missouri | 29087 | 366 | 10 |
1061538 | 1061538 | 2021-02-24 | Holt | Missouri | 29087 | 366 | 10 |
1058292 | 1058292 | 2021-02-23 | Holt | Missouri | 29087 | 366 | 10 |
1055046 | 1055046 | 2021-02-22 | Holt | Missouri | 29087 | 366 | 10 |
1051799 | 1051799 | 2021-02-21 | Holt | Missouri | 29087 | 366 | 10 |
1048552 | 1048552 | 2021-02-20 | Holt | Missouri | 29087 | 366 | 10 |
1045306 | 1045306 | 2021-02-19 | Holt | Missouri | 29087 | 366 | 10 |
876521 | 876521 | 2020-12-29 | Clark | Missouri | 29045 | 366 | 4 |
873271 | 873271 | 2020-12-28 | Carter | Missouri | 29035 | 366 | 6 |
870026 | 870026 | 2020-12-27 | Carter | Missouri | 29035 | 366 | 6 |
866781 | 866781 | 2020-12-26 | Carter | Missouri | 29035 | 366 | 6 |
818177 | 818177 | 2020-12-11 | Shannon | Missouri | 29203 | 366 | 9 |
814931 | 814931 | 2020-12-10 | Shannon | Missouri | 29203 | 366 | 9 |
798680 | 798680 | 2020-12-05 | Montgomery | Missouri | 29139 | 366 | 6 |
795464 | 795464 | 2020-12-04 | St. Clair | Missouri | 29185 | 366 | 1 |
779181 | 779181 | 2020-11-29 | Hickory | Missouri | 29085 | 366 | 6 |
775936 | 775936 | 2020-11-28 | Hickory | Missouri | 29085 | 366 | 6 |
775970 | 775970 | 2020-11-28 | Oregon | Missouri | 29149 | 366 | 0 |
766228 | 766228 | 2020-11-25 | Monroe | Missouri | 29137 | 366 | 3 |
607202 | 607202 | 2020-10-07 | Bollinger | Missouri | 29017 | 366 | 1 |
607263 | 607263 | 2020-10-07 | Moniteau | Missouri | 29135 | 366 | 5 |
581262 | 581262 | 2020-09-29 | Adair | Missouri | 29001 | 366 | 0 |
510120 | 510120 | 2020-09-07 | Polk | Missouri | 29167 | 366 | 1 |
506887 | 506887 | 2020-09-06 | Polk | Missouri | 29167 | 366 | 1 |
503654 | 503654 | 2020-09-05 | Polk | Missouri | 29167 | 366 | 1 |
500420 | 500420 | 2020-09-04 | Polk | Missouri | 29167 | 366 | 1 |
497186 | 497186 | 2020-09-03 | Polk | Missouri | 29167 | 366 | 1 |
477711 | 477711 | 2020-08-28 | Butler | Missouri | 29023 | 366 | 2 |
474553 | 474553 | 2020-08-27 | Pulaski | Missouri | 29169 | 366 | 1 |
260354 | 260354 | 2020-06-21 | McDonald | Missouri | 29119 | 366 | 0 |
20754 | 20754 | 2020-03-30 | St. Louis | Missouri | 29189 | 366 | 2 |
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);