ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
35 rows where cases = 79 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
361661 | 361661 | 2020-07-23 | Franklin | Mississippi | 28037 | 79 | 2 |
355297 | 355297 | 2020-07-21 | Sharkey | Mississippi | 28125 | 79 | 0 |
336049 | 336049 | 2020-07-15 | Choctaw | Mississippi | 28019 | 79 | 4 |
320167 | 320167 | 2020-07-10 | Perry | Mississippi | 28111 | 79 | 4 |
269599 | 269599 | 2020-06-24 | Amite | Mississippi | 28005 | 79 | 2 |
244679 | 244679 | 2020-06-16 | Pontotoc | Mississippi | 28115 | 79 | 3 |
213679 | 213679 | 2020-06-06 | Tippah | Mississippi | 28139 | 79 | 11 |
189077 | 189077 | 2020-05-29 | Sunflower | Mississippi | 28133 | 79 | 3 |
176873 | 176873 | 2020-05-25 | Sunflower | Mississippi | 28133 | 79 | 3 |
167764 | 167764 | 2020-05-22 | Yalobusha | Mississippi | 28161 | 79 | 4 |
164711 | 164711 | 2020-05-21 | Simpson | Mississippi | 28127 | 79 | 0 |
161682 | 161682 | 2020-05-20 | Simpson | Mississippi | 28127 | 79 | 0 |
158621 | 158621 | 2020-05-19 | Itawamba | Mississippi | 28057 | 79 | 7 |
155588 | 155588 | 2020-05-18 | Clay | Mississippi | 28025 | 79 | 3 |
155589 | 155589 | 2020-05-18 | Coahoma | Mississippi | 28027 | 79 | 3 |
155603 | 155603 | 2020-05-18 | Itawamba | Mississippi | 28057 | 79 | 7 |
152574 | 152574 | 2020-05-17 | Clay | Mississippi | 28025 | 79 | 3 |
149563 | 149563 | 2020-05-16 | Clay | Mississippi | 28025 | 79 | 3 |
149573 | 149573 | 2020-05-16 | Hancock | Mississippi | 28045 | 79 | 10 |
143568 | 143568 | 2020-05-14 | Hancock | Mississippi | 28045 | 79 | 10 |
128597 | 128597 | 2020-05-09 | Clarke | Mississippi | 28023 | 79 | 7 |
128628 | 128628 | 2020-05-09 | Lowndes | Mississippi | 28087 | 79 | 3 |
116716 | 116716 | 2020-05-05 | Kemper | Mississippi | 28069 | 79 | 3 |
113834 | 113834 | 2020-05-04 | Kemper | Mississippi | 28069 | 79 | 3 |
110972 | 110972 | 2020-05-03 | Noxubee | Mississippi | 28103 | 79 | 1 |
110985 | 110985 | 2020-05-03 | Smith | Mississippi | 28129 | 79 | 4 |
108101 | 108101 | 2020-05-02 | Noxubee | Mississippi | 28103 | 79 | 1 |
93805 | 93805 | 2020-04-27 | Copiah | Mississippi | 28029 | 79 | 1 |
82575 | 82575 | 2020-04-23 | Lamar | Mississippi | 28073 | 79 | 2 |
79779 | 79779 | 2020-04-22 | Lamar | Mississippi | 28073 | 79 | 2 |
68644 | 68644 | 2020-04-18 | Bolivar | Mississippi | 28011 | 79 | 5 |
60485 | 60485 | 2020-04-15 | Scott | Mississippi | 28123 | 79 | 0 |
41888 | 41888 | 2020-04-08 | Rankin | Mississippi | 28121 | 79 | 2 |
36788 | 36788 | 2020-04-06 | Harrison | Mississippi | 28047 | 79 | 3 |
31903 | 31903 | 2020-04-04 | Jackson | Mississippi | 28059 | 79 | 1 |
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);