ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where fips = 28161 and state = "Mississippi" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
13205 | 13205 | 2020-03-26 | Yalobusha | Mississippi | 28161 | 3 | 0 |
14926 | 14926 | 2020-03-27 | Yalobusha | Mississippi | 28161 | 3 | 0 |
16750 | 16750 | 2020-03-28 | Yalobusha | Mississippi | 28161 | 3 | 0 |
18672 | 18672 | 2020-03-29 | Yalobusha | Mississippi | 28161 | 3 | 0 |
20696 | 20696 | 2020-03-30 | Yalobusha | Mississippi | 28161 | 5 | 0 |
22814 | 22814 | 2020-03-31 | Yalobusha | Mississippi | 28161 | 6 | 0 |
24998 | 24998 | 2020-04-01 | Yalobusha | Mississippi | 28161 | 6 | 0 |
27253 | 27253 | 2020-04-02 | Yalobusha | Mississippi | 28161 | 7 | 0 |
29572 | 29572 | 2020-04-03 | Yalobusha | Mississippi | 28161 | 7 | 0 |
31952 | 31952 | 2020-04-04 | Yalobusha | Mississippi | 28161 | 9 | 0 |
34380 | 34380 | 2020-04-05 | Yalobusha | Mississippi | 28161 | 9 | 0 |
36843 | 36843 | 2020-04-06 | Yalobusha | Mississippi | 28161 | 11 | 0 |
39354 | 39354 | 2020-04-07 | Yalobusha | Mississippi | 28161 | 11 | 0 |
41908 | 41908 | 2020-04-08 | Yalobusha | Mississippi | 28161 | 11 | 0 |
44485 | 44485 | 2020-04-09 | Yalobusha | Mississippi | 28161 | 11 | 0 |
47094 | 47094 | 2020-04-10 | Yalobusha | Mississippi | 28161 | 11 | 0 |
49740 | 49740 | 2020-04-11 | Yalobusha | Mississippi | 28161 | 13 | 0 |
52413 | 52413 | 2020-04-12 | Yalobusha | Mississippi | 28161 | 14 | 0 |
55095 | 55095 | 2020-04-13 | Yalobusha | Mississippi | 28161 | 14 | 0 |
57793 | 57793 | 2020-04-14 | Yalobusha | Mississippi | 28161 | 14 | 0 |
60504 | 60504 | 2020-04-15 | Yalobusha | Mississippi | 28161 | 14 | 0 |
63226 | 63226 | 2020-04-16 | Yalobusha | Mississippi | 28161 | 14 | 0 |
65966 | 65966 | 2020-04-17 | Yalobusha | Mississippi | 28161 | 14 | 0 |
68718 | 68718 | 2020-04-18 | Yalobusha | Mississippi | 28161 | 15 | 0 |
71484 | 71484 | 2020-04-19 | Yalobusha | Mississippi | 28161 | 15 | 0 |
74257 | 74257 | 2020-04-20 | Yalobusha | Mississippi | 28161 | 16 | 0 |
77038 | 77038 | 2020-04-21 | Yalobusha | Mississippi | 28161 | 17 | 0 |
79823 | 79823 | 2020-04-22 | Yalobusha | Mississippi | 28161 | 17 | 0 |
82619 | 82619 | 2020-04-23 | Yalobusha | Mississippi | 28161 | 17 | 0 |
85423 | 85423 | 2020-04-24 | Yalobusha | Mississippi | 28161 | 17 | 0 |
88233 | 88233 | 2020-04-25 | Yalobusha | Mississippi | 28161 | 17 | 0 |
91049 | 91049 | 2020-04-26 | Yalobusha | Mississippi | 28161 | 18 | 0 |
93870 | 93870 | 2020-04-27 | Yalobusha | Mississippi | 28161 | 19 | 0 |
96706 | 96706 | 2020-04-28 | Yalobusha | Mississippi | 28161 | 19 | 0 |
99552 | 99552 | 2020-04-29 | Yalobusha | Mississippi | 28161 | 19 | 0 |
102404 | 102404 | 2020-04-30 | Yalobusha | Mississippi | 28161 | 19 | 0 |
105265 | 105265 | 2020-05-01 | Yalobusha | Mississippi | 28161 | 20 | 0 |
108130 | 108130 | 2020-05-02 | Yalobusha | Mississippi | 28161 | 20 | 0 |
111001 | 111001 | 2020-05-03 | Yalobusha | Mississippi | 28161 | 20 | 0 |
113880 | 113880 | 2020-05-04 | Yalobusha | Mississippi | 28161 | 20 | 0 |
116762 | 116762 | 2020-05-05 | Yalobusha | Mississippi | 28161 | 21 | 0 |
119722 | 119722 | 2020-05-06 | Yalobusha | Mississippi | 28161 | 23 | 0 |
122696 | 122696 | 2020-05-07 | Yalobusha | Mississippi | 28161 | 25 | 0 |
125678 | 125678 | 2020-05-08 | Yalobusha | Mississippi | 28161 | 27 | 0 |
128665 | 128665 | 2020-05-09 | Yalobusha | Mississippi | 28161 | 30 | 0 |
131655 | 131655 | 2020-05-10 | Yalobusha | Mississippi | 28161 | 31 | 0 |
134646 | 134646 | 2020-05-11 | Yalobusha | Mississippi | 28161 | 36 | 0 |
137636 | 137636 | 2020-05-12 | Yalobusha | Mississippi | 28161 | 36 | 0 |
140630 | 140630 | 2020-05-13 | Yalobusha | Mississippi | 28161 | 44 | 0 |
143625 | 143625 | 2020-05-14 | Yalobusha | Mississippi | 28161 | 65 | 0 |
146625 | 146625 | 2020-05-15 | Yalobusha | Mississippi | 28161 | 66 | 0 |
149630 | 149630 | 2020-05-16 | Yalobusha | Mississippi | 28161 | 71 | 0 |
152641 | 152641 | 2020-05-17 | Yalobusha | Mississippi | 28161 | 71 | 0 |
155655 | 155655 | 2020-05-18 | Yalobusha | Mississippi | 28161 | 73 | 1 |
158673 | 158673 | 2020-05-19 | Yalobusha | Mississippi | 28161 | 75 | 2 |
161699 | 161699 | 2020-05-20 | Yalobusha | Mississippi | 28161 | 75 | 3 |
164728 | 164728 | 2020-05-21 | Yalobusha | Mississippi | 28161 | 76 | 4 |
167764 | 167764 | 2020-05-22 | Yalobusha | Mississippi | 28161 | 79 | 4 |
170802 | 170802 | 2020-05-23 | Yalobusha | Mississippi | 28161 | 82 | 4 |
173844 | 173844 | 2020-05-24 | Yalobusha | Mississippi | 28161 | 82 | 4 |
176887 | 176887 | 2020-05-25 | Yalobusha | Mississippi | 28161 | 84 | 5 |
179931 | 179931 | 2020-05-26 | Yalobusha | Mississippi | 28161 | 84 | 5 |
182977 | 182977 | 2020-05-27 | Yalobusha | Mississippi | 28161 | 85 | 5 |
186033 | 186033 | 2020-05-28 | Yalobusha | Mississippi | 28161 | 85 | 5 |
189091 | 189091 | 2020-05-29 | Yalobusha | Mississippi | 28161 | 87 | 5 |
192155 | 192155 | 2020-05-30 | Yalobusha | Mississippi | 28161 | 90 | 5 |
195223 | 195223 | 2020-05-31 | Yalobusha | Mississippi | 28161 | 93 | 5 |
198294 | 198294 | 2020-06-01 | Yalobusha | Mississippi | 28161 | 94 | 5 |
201367 | 201367 | 2020-06-02 | Yalobusha | Mississippi | 28161 | 96 | 6 |
204444 | 204444 | 2020-06-03 | Yalobusha | Mississippi | 28161 | 97 | 6 |
207525 | 207525 | 2020-06-04 | Yalobusha | Mississippi | 28161 | 104 | 6 |
210606 | 210606 | 2020-06-05 | Yalobusha | Mississippi | 28161 | 111 | 6 |
213690 | 213690 | 2020-06-06 | Yalobusha | Mississippi | 28161 | 112 | 6 |
216778 | 216778 | 2020-06-07 | Yalobusha | Mississippi | 28161 | 114 | 7 |
219870 | 219870 | 2020-06-08 | Yalobusha | Mississippi | 28161 | 121 | 7 |
222965 | 222965 | 2020-06-09 | Yalobusha | Mississippi | 28161 | 123 | 7 |
226063 | 226063 | 2020-06-10 | Yalobusha | Mississippi | 28161 | 128 | 7 |
229165 | 229165 | 2020-06-11 | Yalobusha | Mississippi | 28161 | 128 | 7 |
232269 | 232269 | 2020-06-12 | Yalobusha | Mississippi | 28161 | 136 | 7 |
235375 | 235375 | 2020-06-13 | Yalobusha | Mississippi | 28161 | 137 | 7 |
238482 | 238482 | 2020-06-14 | Yalobusha | Mississippi | 28161 | 138 | 7 |
241591 | 241591 | 2020-06-15 | Yalobusha | Mississippi | 28161 | 138 | 7 |
244702 | 244702 | 2020-06-16 | Yalobusha | Mississippi | 28161 | 139 | 7 |
247815 | 247815 | 2020-06-17 | Yalobusha | Mississippi | 28161 | 139 | 7 |
250928 | 250928 | 2020-06-18 | Yalobusha | Mississippi | 28161 | 139 | 7 |
254043 | 254043 | 2020-06-19 | Yalobusha | Mississippi | 28161 | 139 | 7 |
257163 | 257163 | 2020-06-20 | Yalobusha | Mississippi | 28161 | 139 | 7 |
260289 | 260289 | 2020-06-21 | Yalobusha | Mississippi | 28161 | 139 | 7 |
263417 | 263417 | 2020-06-22 | Yalobusha | Mississippi | 28161 | 132 | 7 |
266543 | 266543 | 2020-06-23 | Yalobusha | Mississippi | 28161 | 133 | 7 |
269676 | 269676 | 2020-06-24 | Yalobusha | Mississippi | 28161 | 136 | 7 |
272814 | 272814 | 2020-06-25 | Yalobusha | Mississippi | 28161 | 141 | 7 |
275957 | 275957 | 2020-06-26 | Yalobusha | Mississippi | 28161 | 144 | 7 |
279105 | 279105 | 2020-06-27 | Yalobusha | Mississippi | 28161 | 148 | 7 |
282253 | 282253 | 2020-06-28 | Yalobusha | Mississippi | 28161 | 148 | 7 |
285398 | 285398 | 2020-06-29 | Yalobusha | Mississippi | 28161 | 151 | 7 |
288548 | 288548 | 2020-06-30 | Yalobusha | Mississippi | 28161 | 152 | 7 |
291699 | 291699 | 2020-07-01 | Yalobusha | Mississippi | 28161 | 161 | 7 |
294853 | 294853 | 2020-07-02 | Yalobusha | Mississippi | 28161 | 166 | 7 |
298011 | 298011 | 2020-07-03 | Yalobusha | Mississippi | 28161 | 167 | 7 |
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);