ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
18 rows where cases = 508 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
fips 14
county 14
- Reynolds 5
- Barry 1
- Carroll 1
- Daviess 1
- Henry 1
- Madison 1
- Miller 1
- Mississippi 1
- New Madrid 1
- Ozark 1
- Platte 1
- Stoddard 1
- Sullivan 1
- Washington 1
state 1
- Missouri · 18 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1532331 | 1532331 | 2021-07-19 | Reynolds | Missouri | 29179 | 508 | 4 |
1529084 | 1529084 | 2021-07-18 | Reynolds | Missouri | 29179 | 508 | 4 |
1525837 | 1525837 | 2021-07-17 | Reynolds | Missouri | 29179 | 508 | 4 |
1522590 | 1522590 | 2021-07-16 | Reynolds | Missouri | 29179 | 508 | 4 |
1519341 | 1519341 | 2021-07-15 | Reynolds | Missouri | 29179 | 508 | 4 |
960957 | 960957 | 2021-01-24 | Ozark | Missouri | 29153 | 508 | 7 |
912229 | 912229 | 2021-01-09 | Daviess | Missouri | 29061 | 508 | 9 |
811605 | 811605 | 2020-12-09 | Carroll | Missouri | 29033 | 508 | 8 |
743543 | 743543 | 2020-11-18 | Sullivan | Missouri | 29211 | 508 | 5 |
704575 | 704575 | 2020-11-06 | Mississippi | Missouri | 29133 | 508 | 6 |
701306 | 701306 | 2020-11-05 | Henry | Missouri | 29083 | 508 | 8 |
675380 | 675380 | 2020-10-28 | Madison | Missouri | 29123 | 508 | 3 |
610548 | 610548 | 2020-10-08 | Washington | Missouri | 29221 | 508 | 11 |
587747 | 587747 | 2020-10-01 | Barry | Missouri | 29009 | 508 | 6 |
574847 | 574847 | 2020-09-27 | Miller | Missouri | 29131 | 508 | 1 |
574885 | 574885 | 2020-09-27 | Stoddard | Missouri | 29207 | 508 | 13 |
555414 | 555414 | 2020-09-21 | New Madrid | Missouri | 29143 | 508 | 14 |
490718 | 490718 | 2020-09-01 | Platte | Missouri | 29165 | 508 | 11 |
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);