ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Humphreys" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387373 | 387373 | 2020-07-31 | Humphreys | Mississippi | 28053 | 262 | 11 |
384155 | 384155 | 2020-07-30 | Humphreys | Mississippi | 28053 | 257 | 11 |
380938 | 380938 | 2020-07-29 | Humphreys | Mississippi | 28053 | 255 | 10 |
377721 | 377721 | 2020-07-28 | Humphreys | Mississippi | 28053 | 253 | 10 |
374506 | 374506 | 2020-07-27 | Humphreys | Mississippi | 28053 | 248 | 10 |
371294 | 371294 | 2020-07-26 | Humphreys | Mississippi | 28053 | 245 | 10 |
368084 | 368084 | 2020-07-25 | Humphreys | Mississippi | 28053 | 241 | 10 |
364876 | 364876 | 2020-07-24 | Humphreys | Mississippi | 28053 | 235 | 10 |
361669 | 361669 | 2020-07-23 | Humphreys | Mississippi | 28053 | 229 | 10 |
358464 | 358464 | 2020-07-22 | Humphreys | Mississippi | 28053 | 227 | 10 |
355261 | 355261 | 2020-07-21 | Humphreys | Mississippi | 28053 | 222 | 10 |
352059 | 352059 | 2020-07-20 | Humphreys | Mississippi | 28053 | 209 | 10 |
348859 | 348859 | 2020-07-19 | Humphreys | Mississippi | 28053 | 203 | 10 |
345658 | 345658 | 2020-07-18 | Humphreys | Mississippi | 28053 | 202 | 10 |
342458 | 342458 | 2020-07-17 | Humphreys | Mississippi | 28053 | 192 | 10 |
339262 | 339262 | 2020-07-16 | Humphreys | Mississippi | 28053 | 188 | 10 |
336066 | 336066 | 2020-07-15 | Humphreys | Mississippi | 28053 | 184 | 10 |
332873 | 332873 | 2020-07-14 | Humphreys | Mississippi | 28053 | 178 | 10 |
329686 | 329686 | 2020-07-13 | Humphreys | Mississippi | 28053 | 174 | 10 |
326500 | 326500 | 2020-07-12 | Humphreys | Mississippi | 28053 | 169 | 10 |
323317 | 323317 | 2020-07-11 | Humphreys | Mississippi | 28053 | 163 | 10 |
320138 | 320138 | 2020-07-10 | Humphreys | Mississippi | 28053 | 161 | 10 |
316963 | 316963 | 2020-07-09 | Humphreys | Mississippi | 28053 | 159 | 10 |
313789 | 313789 | 2020-07-08 | Humphreys | Mississippi | 28053 | 156 | 9 |
310619 | 310619 | 2020-07-07 | Humphreys | Mississippi | 28053 | 156 | 9 |
307451 | 307451 | 2020-07-06 | Humphreys | Mississippi | 28053 | 150 | 9 |
304284 | 304284 | 2020-07-05 | Humphreys | Mississippi | 28053 | 147 | 9 |
301120 | 301120 | 2020-07-04 | Humphreys | Mississippi | 28053 | 147 | 9 |
297957 | 297957 | 2020-07-03 | Humphreys | Mississippi | 28053 | 132 | 9 |
294799 | 294799 | 2020-07-02 | Humphreys | Mississippi | 28053 | 130 | 9 |
291645 | 291645 | 2020-07-01 | Humphreys | Mississippi | 28053 | 123 | 9 |
288494 | 288494 | 2020-06-30 | Humphreys | Mississippi | 28053 | 120 | 9 |
285344 | 285344 | 2020-06-29 | Humphreys | Mississippi | 28053 | 115 | 9 |
282199 | 282199 | 2020-06-28 | Humphreys | Mississippi | 28053 | 111 | 9 |
279051 | 279051 | 2020-06-27 | Humphreys | Mississippi | 28053 | 111 | 9 |
275903 | 275903 | 2020-06-26 | Humphreys | Mississippi | 28053 | 109 | 9 |
272760 | 272760 | 2020-06-25 | Humphreys | Mississippi | 28053 | 107 | 9 |
269623 | 269623 | 2020-06-24 | Humphreys | Mississippi | 28053 | 101 | 9 |
266490 | 266490 | 2020-06-23 | Humphreys | Mississippi | 28053 | 95 | 9 |
263364 | 263364 | 2020-06-22 | Humphreys | Mississippi | 28053 | 93 | 9 |
260235 | 260235 | 2020-06-21 | Humphreys | Mississippi | 28053 | 83 | 8 |
257109 | 257109 | 2020-06-20 | Humphreys | Mississippi | 28053 | 83 | 8 |
253989 | 253989 | 2020-06-19 | Humphreys | Mississippi | 28053 | 83 | 8 |
250874 | 250874 | 2020-06-18 | Humphreys | Mississippi | 28053 | 83 | 8 |
247762 | 247762 | 2020-06-17 | Humphreys | Mississippi | 28053 | 83 | 8 |
244649 | 244649 | 2020-06-16 | Humphreys | Mississippi | 28053 | 83 | 8 |
241538 | 241538 | 2020-06-15 | Humphreys | Mississippi | 28053 | 82 | 8 |
238429 | 238429 | 2020-06-14 | Humphreys | Mississippi | 28053 | 80 | 8 |
235322 | 235322 | 2020-06-13 | Humphreys | Mississippi | 28053 | 80 | 8 |
232216 | 232216 | 2020-06-12 | Humphreys | Mississippi | 28053 | 80 | 8 |
229112 | 229112 | 2020-06-11 | Humphreys | Mississippi | 28053 | 78 | 8 |
226010 | 226010 | 2020-06-10 | Humphreys | Mississippi | 28053 | 78 | 8 |
222912 | 222912 | 2020-06-09 | Humphreys | Mississippi | 28053 | 75 | 8 |
219817 | 219817 | 2020-06-08 | Humphreys | Mississippi | 28053 | 74 | 7 |
216725 | 216725 | 2020-06-07 | Humphreys | Mississippi | 28053 | 70 | 7 |
213637 | 213637 | 2020-06-06 | Humphreys | Mississippi | 28053 | 69 | 7 |
210553 | 210553 | 2020-06-05 | Humphreys | Mississippi | 28053 | 64 | 7 |
207472 | 207472 | 2020-06-04 | Humphreys | Mississippi | 28053 | 63 | 7 |
204391 | 204391 | 2020-06-03 | Humphreys | Mississippi | 28053 | 60 | 7 |
201314 | 201314 | 2020-06-02 | Humphreys | Mississippi | 28053 | 59 | 7 |
198241 | 198241 | 2020-06-01 | Humphreys | Mississippi | 28053 | 59 | 7 |
195170 | 195170 | 2020-05-31 | Humphreys | Mississippi | 28053 | 59 | 7 |
192102 | 192102 | 2020-05-30 | Humphreys | Mississippi | 28053 | 60 | 7 |
189038 | 189038 | 2020-05-29 | Humphreys | Mississippi | 28053 | 59 | 7 |
185980 | 185980 | 2020-05-28 | Humphreys | Mississippi | 28053 | 58 | 7 |
182924 | 182924 | 2020-05-27 | Humphreys | Mississippi | 28053 | 53 | 7 |
179878 | 179878 | 2020-05-26 | Humphreys | Mississippi | 28053 | 52 | 7 |
176834 | 176834 | 2020-05-25 | Humphreys | Mississippi | 28053 | 53 | 7 |
173791 | 173791 | 2020-05-24 | Humphreys | Mississippi | 28053 | 53 | 7 |
170749 | 170749 | 2020-05-23 | Humphreys | Mississippi | 28053 | 52 | 7 |
167711 | 167711 | 2020-05-22 | Humphreys | Mississippi | 28053 | 50 | 6 |
164675 | 164675 | 2020-05-21 | Humphreys | Mississippi | 28053 | 49 | 5 |
161646 | 161646 | 2020-05-20 | Humphreys | Mississippi | 28053 | 49 | 5 |
158620 | 158620 | 2020-05-19 | Humphreys | Mississippi | 28053 | 49 | 5 |
155602 | 155602 | 2020-05-18 | Humphreys | Mississippi | 28053 | 46 | 5 |
152588 | 152588 | 2020-05-17 | Humphreys | Mississippi | 28053 | 45 | 5 |
149577 | 149577 | 2020-05-16 | Humphreys | Mississippi | 28053 | 44 | 5 |
146572 | 146572 | 2020-05-15 | Humphreys | Mississippi | 28053 | 42 | 5 |
143572 | 143572 | 2020-05-14 | Humphreys | Mississippi | 28053 | 39 | 5 |
140577 | 140577 | 2020-05-13 | Humphreys | Mississippi | 28053 | 39 | 4 |
137583 | 137583 | 2020-05-12 | Humphreys | Mississippi | 28053 | 38 | 4 |
134593 | 134593 | 2020-05-11 | Humphreys | Mississippi | 28053 | 34 | 4 |
131602 | 131602 | 2020-05-10 | Humphreys | Mississippi | 28053 | 30 | 4 |
128612 | 128612 | 2020-05-09 | Humphreys | Mississippi | 28053 | 30 | 4 |
125625 | 125625 | 2020-05-08 | Humphreys | Mississippi | 28053 | 28 | 4 |
122643 | 122643 | 2020-05-07 | Humphreys | Mississippi | 28053 | 28 | 4 |
119669 | 119669 | 2020-05-06 | Humphreys | Mississippi | 28053 | 27 | 4 |
116709 | 116709 | 2020-05-05 | Humphreys | Mississippi | 28053 | 26 | 4 |
113827 | 113827 | 2020-05-04 | Humphreys | Mississippi | 28053 | 25 | 4 |
110948 | 110948 | 2020-05-03 | Humphreys | Mississippi | 28053 | 24 | 4 |
108077 | 108077 | 2020-05-02 | Humphreys | Mississippi | 28053 | 25 | 4 |
105212 | 105212 | 2020-05-01 | Humphreys | Mississippi | 28053 | 24 | 3 |
102351 | 102351 | 2020-04-30 | Humphreys | Mississippi | 28053 | 23 | 3 |
99499 | 99499 | 2020-04-29 | Humphreys | Mississippi | 28053 | 22 | 3 |
96653 | 96653 | 2020-04-28 | Humphreys | Mississippi | 28053 | 18 | 3 |
93817 | 93817 | 2020-04-27 | Humphreys | Mississippi | 28053 | 18 | 3 |
90996 | 90996 | 2020-04-26 | Humphreys | Mississippi | 28053 | 14 | 3 |
88180 | 88180 | 2020-04-25 | Humphreys | Mississippi | 28053 | 14 | 3 |
85370 | 85370 | 2020-04-24 | Humphreys | Mississippi | 28053 | 14 | 3 |
82566 | 82566 | 2020-04-23 | Humphreys | Mississippi | 28053 | 14 | 3 |
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);