ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
11 rows where cases = 2974 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 1
- Mississippi · 11 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1535475 | 1535475 | 2021-07-20 | Tippah | Mississippi | 28139 | 2974 | 68 |
1379661 | 1379661 | 2021-06-02 | Simpson | Mississippi | 28127 | 2974 | 89 |
1353644 | 1353644 | 2021-05-25 | Coahoma | Mississippi | 28027 | 2974 | 81 |
1324422 | 1324422 | 2021-05-16 | Copiah | Mississippi | 28029 | 2974 | 65 |
1321176 | 1321176 | 2021-05-15 | Copiah | Mississippi | 28029 | 2974 | 65 |
1317930 | 1317930 | 2021-05-14 | Copiah | Mississippi | 28029 | 2974 | 65 |
1223784 | 1223784 | 2021-04-15 | Itawamba | Mississippi | 28057 | 2974 | 77 |
1220537 | 1220537 | 2021-04-14 | Itawamba | Mississippi | 28057 | 2974 | 77 |
1204270 | 1204270 | 2021-04-09 | Alcorn | Mississippi | 28003 | 2974 | 64 |
1201022 | 1201022 | 2021-04-08 | Alcorn | Mississippi | 28003 | 2974 | 64 |
1038759 | 1038759 | 2021-02-17 | Tate | Mississippi | 28137 | 2974 | 72 |
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);