ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
33 rows where cases = 329 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 25
county 25
- Schuyler 4
- Reynolds 3
- Mercer 2
- Texas 2
- Worth 2
- Cape Girardeau 1
- Daviess 1
- Gasconade 1
- Greene 1
- Harrison 1
- Hickory 1
- Howell 1
- Iron 1
- Jackson 1
- Kansas City 1
- Laclede 1
- Linn 1
- Miller 1
- Mississippi 1
- Montgomery 1
- Pulaski 1
- Shannon 1
- Shelby 1
- Warren 1
- Washington 1
state 1
- Missouri · 33 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2087983 | 2087983 | 2022-01-06 | Worth | Missouri | 29227 | 329 | 3 |
2084731 | 2084731 | 2022-01-05 | Worth | Missouri | 29227 | 329 | 3 |
1587521 | 1587521 | 2021-08-05 | Mercer | Missouri | 29129 | 329 | 2 |
1584270 | 1584270 | 2021-08-04 | Mercer | Missouri | 29129 | 329 | 2 |
1155729 | 1155729 | 2021-03-25 | Schuyler | Missouri | 29197 | 329 | 5 |
1152482 | 1152482 | 2021-03-24 | Schuyler | Missouri | 29197 | 329 | 5 |
1149235 | 1149235 | 2021-03-23 | Schuyler | Missouri | 29197 | 329 | 5 |
1145988 | 1145988 | 2021-03-22 | Schuyler | Missouri | 29197 | 329 | 5 |
941503 | 941503 | 2021-01-18 | Shelby | Missouri | 29205 | 329 | 4 |
847340 | 847340 | 2020-12-20 | Iron | Missouri | 29093 | 329 | 1 |
811680 | 811680 | 2020-12-09 | Reynolds | Missouri | 29179 | 329 | 2 |
808435 | 808435 | 2020-12-08 | Reynolds | Missouri | 29179 | 329 | 2 |
805190 | 805190 | 2020-12-07 | Reynolds | Missouri | 29179 | 329 | 2 |
788933 | 788933 | 2020-12-02 | Linn | Missouri | 29115 | 329 | 11 |
772679 | 772679 | 2020-11-27 | Daviess | Missouri | 29061 | 329 | 8 |
766229 | 766229 | 2020-11-25 | Montgomery | Missouri | 29139 | 329 | 5 |
766255 | 766255 | 2020-11-25 | Shannon | Missouri | 29203 | 329 | 9 |
743476 | 743476 | 2020-11-18 | Harrison | Missouri | 29081 | 329 | 1 |
736987 | 736987 | 2020-11-16 | Hickory | Missouri | 29085 | 329 | 4 |
711030 | 711030 | 2020-11-08 | Gasconade | Missouri | 29073 | 329 | 24 |
610504 | 610504 | 2020-10-08 | Mississippi | Missouri | 29133 | 329 | 3 |
581371 | 581371 | 2020-09-29 | Texas | Missouri | 29215 | 329 | 2 |
578130 | 578130 | 2020-09-28 | Texas | Missouri | 29215 | 329 | 2 |
548976 | 548976 | 2020-09-19 | Washington | Missouri | 29221 | 329 | 5 |
519803 | 519803 | 2020-09-10 | Miller | Missouri | 29131 | 329 | 1 |
510089 | 510089 | 2020-09-07 | Laclede | Missouri | 29105 | 329 | 1 |
506847 | 506847 | 2020-09-06 | Howell | Missouri | 29091 | 329 | 3 |
481043 | 481043 | 2020-08-29 | Warren | Missouri | 29219 | 329 | 0 |
458404 | 458404 | 2020-08-22 | Pulaski | Missouri | 29169 | 329 | 1 |
323388 | 323388 | 2020-07-11 | Cape Girardeau | Missouri | 29031 | 329 | 3 |
291739 | 291739 | 2020-07-01 | Greene | Missouri | 29077 | 329 | 8 |
105308 | 105308 | 2020-05-01 | Jackson | Missouri | 29095 | 329 | 14 |
55138 | 55138 | 2020-04-13 | Kansas City | Missouri | 329 | 8 |
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);