ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Jackson" and fips = 28059 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
282202 | 282202 | 2020-06-28 | Jackson | Mississippi | 28059 | 475 | 16 |
279054 | 279054 | 2020-06-27 | Jackson | Mississippi | 28059 | 473 | 16 |
275906 | 275906 | 2020-06-26 | Jackson | Mississippi | 28059 | 471 | 16 |
272763 | 272763 | 2020-06-25 | Jackson | Mississippi | 28059 | 458 | 16 |
269625 | 269625 | 2020-06-24 | Jackson | Mississippi | 28059 | 439 | 16 |
266492 | 266492 | 2020-06-23 | Jackson | Mississippi | 28059 | 425 | 16 |
263366 | 263366 | 2020-06-22 | Jackson | Mississippi | 28059 | 402 | 16 |
260237 | 260237 | 2020-06-21 | Jackson | Mississippi | 28059 | 385 | 16 |
257111 | 257111 | 2020-06-20 | Jackson | Mississippi | 28059 | 385 | 16 |
253991 | 253991 | 2020-06-19 | Jackson | Mississippi | 28059 | 385 | 16 |
250876 | 250876 | 2020-06-18 | Jackson | Mississippi | 28059 | 385 | 16 |
247764 | 247764 | 2020-06-17 | Jackson | Mississippi | 28059 | 385 | 16 |
244651 | 244651 | 2020-06-16 | Jackson | Mississippi | 28059 | 378 | 16 |
241540 | 241540 | 2020-06-15 | Jackson | Mississippi | 28059 | 367 | 16 |
238431 | 238431 | 2020-06-14 | Jackson | Mississippi | 28059 | 356 | 16 |
235324 | 235324 | 2020-06-13 | Jackson | Mississippi | 28059 | 350 | 16 |
232218 | 232218 | 2020-06-12 | Jackson | Mississippi | 28059 | 344 | 16 |
229114 | 229114 | 2020-06-11 | Jackson | Mississippi | 28059 | 339 | 16 |
226012 | 226012 | 2020-06-10 | Jackson | Mississippi | 28059 | 339 | 16 |
222914 | 222914 | 2020-06-09 | Jackson | Mississippi | 28059 | 338 | 16 |
219819 | 219819 | 2020-06-08 | Jackson | Mississippi | 28059 | 329 | 16 |
216727 | 216727 | 2020-06-07 | Jackson | Mississippi | 28059 | 321 | 15 |
213639 | 213639 | 2020-06-06 | Jackson | Mississippi | 28059 | 317 | 15 |
210555 | 210555 | 2020-06-05 | Jackson | Mississippi | 28059 | 314 | 15 |
207474 | 207474 | 2020-06-04 | Jackson | Mississippi | 28059 | 314 | 15 |
204393 | 204393 | 2020-06-03 | Jackson | Mississippi | 28059 | 309 | 14 |
201316 | 201316 | 2020-06-02 | Jackson | Mississippi | 28059 | 308 | 13 |
198243 | 198243 | 2020-06-01 | Jackson | Mississippi | 28059 | 307 | 13 |
195172 | 195172 | 2020-05-31 | Jackson | Mississippi | 28059 | 308 | 13 |
192104 | 192104 | 2020-05-30 | Jackson | Mississippi | 28059 | 305 | 13 |
189040 | 189040 | 2020-05-29 | Jackson | Mississippi | 28059 | 302 | 13 |
185982 | 185982 | 2020-05-28 | Jackson | Mississippi | 28059 | 303 | 13 |
182926 | 182926 | 2020-05-27 | Jackson | Mississippi | 28059 | 300 | 13 |
179880 | 179880 | 2020-05-26 | Jackson | Mississippi | 28059 | 296 | 13 |
176836 | 176836 | 2020-05-25 | Jackson | Mississippi | 28059 | 296 | 13 |
173793 | 173793 | 2020-05-24 | Jackson | Mississippi | 28059 | 296 | 13 |
170751 | 170751 | 2020-05-23 | Jackson | Mississippi | 28059 | 296 | 13 |
167713 | 167713 | 2020-05-22 | Jackson | Mississippi | 28059 | 291 | 13 |
164677 | 164677 | 2020-05-21 | Jackson | Mississippi | 28059 | 291 | 13 |
161648 | 161648 | 2020-05-20 | Jackson | Mississippi | 28059 | 288 | 13 |
158622 | 158622 | 2020-05-19 | Jackson | Mississippi | 28059 | 287 | 13 |
155604 | 155604 | 2020-05-18 | Jackson | Mississippi | 28059 | 287 | 13 |
152590 | 152590 | 2020-05-17 | Jackson | Mississippi | 28059 | 286 | 13 |
149579 | 149579 | 2020-05-16 | Jackson | Mississippi | 28059 | 284 | 13 |
146574 | 146574 | 2020-05-15 | Jackson | Mississippi | 28059 | 283 | 13 |
143574 | 143574 | 2020-05-14 | Jackson | Mississippi | 28059 | 280 | 13 |
140579 | 140579 | 2020-05-13 | Jackson | Mississippi | 28059 | 278 | 13 |
137585 | 137585 | 2020-05-12 | Jackson | Mississippi | 28059 | 276 | 13 |
134595 | 134595 | 2020-05-11 | Jackson | Mississippi | 28059 | 276 | 11 |
131604 | 131604 | 2020-05-10 | Jackson | Mississippi | 28059 | 275 | 11 |
128614 | 128614 | 2020-05-09 | Jackson | Mississippi | 28059 | 275 | 11 |
125627 | 125627 | 2020-05-08 | Jackson | Mississippi | 28059 | 273 | 11 |
122645 | 122645 | 2020-05-07 | Jackson | Mississippi | 28059 | 272 | 11 |
119671 | 119671 | 2020-05-06 | Jackson | Mississippi | 28059 | 271 | 10 |
116711 | 116711 | 2020-05-05 | Jackson | Mississippi | 28059 | 270 | 9 |
113829 | 113829 | 2020-05-04 | Jackson | Mississippi | 28059 | 267 | 7 |
110950 | 110950 | 2020-05-03 | Jackson | Mississippi | 28059 | 267 | 7 |
108079 | 108079 | 2020-05-02 | Jackson | Mississippi | 28059 | 267 | 7 |
105214 | 105214 | 2020-05-01 | Jackson | Mississippi | 28059 | 267 | 6 |
102353 | 102353 | 2020-04-30 | Jackson | Mississippi | 28059 | 259 | 6 |
99501 | 99501 | 2020-04-29 | Jackson | Mississippi | 28059 | 255 | 6 |
96655 | 96655 | 2020-04-28 | Jackson | Mississippi | 28059 | 252 | 6 |
93819 | 93819 | 2020-04-27 | Jackson | Mississippi | 28059 | 240 | 6 |
90998 | 90998 | 2020-04-26 | Jackson | Mississippi | 28059 | 238 | 6 |
88182 | 88182 | 2020-04-25 | Jackson | Mississippi | 28059 | 237 | 6 |
85372 | 85372 | 2020-04-24 | Jackson | Mississippi | 28059 | 235 | 6 |
82568 | 82568 | 2020-04-23 | Jackson | Mississippi | 28059 | 228 | 6 |
79772 | 79772 | 2020-04-22 | Jackson | Mississippi | 28059 | 221 | 6 |
76987 | 76987 | 2020-04-21 | Jackson | Mississippi | 28059 | 211 | 6 |
74206 | 74206 | 2020-04-20 | Jackson | Mississippi | 28059 | 209 | 6 |
71433 | 71433 | 2020-04-19 | Jackson | Mississippi | 28059 | 205 | 6 |
68667 | 68667 | 2020-04-18 | Jackson | Mississippi | 28059 | 201 | 6 |
65915 | 65915 | 2020-04-17 | Jackson | Mississippi | 28059 | 196 | 6 |
63175 | 63175 | 2020-04-16 | Jackson | Mississippi | 28059 | 189 | 5 |
60453 | 60453 | 2020-04-15 | Jackson | Mississippi | 28059 | 182 | 5 |
57742 | 57742 | 2020-04-14 | Jackson | Mississippi | 28059 | 157 | 5 |
55044 | 55044 | 2020-04-13 | Jackson | Mississippi | 28059 | 147 | 5 |
52362 | 52362 | 2020-04-12 | Jackson | Mississippi | 28059 | 140 | 5 |
49689 | 49689 | 2020-04-11 | Jackson | Mississippi | 28059 | 139 | 5 |
47043 | 47043 | 2020-04-10 | Jackson | Mississippi | 28059 | 135 | 5 |
44434 | 44434 | 2020-04-09 | Jackson | Mississippi | 28059 | 122 | 5 |
41858 | 41858 | 2020-04-08 | Jackson | Mississippi | 28059 | 111 | 5 |
39304 | 39304 | 2020-04-07 | Jackson | Mississippi | 28059 | 108 | 5 |
36793 | 36793 | 2020-04-06 | Jackson | Mississippi | 28059 | 98 | 5 |
34330 | 34330 | 2020-04-05 | Jackson | Mississippi | 28059 | 86 | 3 |
31903 | 31903 | 2020-04-04 | Jackson | Mississippi | 28059 | 79 | 1 |
29523 | 29523 | 2020-04-03 | Jackson | Mississippi | 28059 | 75 | 1 |
27204 | 27204 | 2020-04-02 | Jackson | Mississippi | 28059 | 57 | 1 |
24950 | 24950 | 2020-04-01 | Jackson | Mississippi | 28059 | 52 | 0 |
22767 | 22767 | 2020-03-31 | Jackson | Mississippi | 28059 | 40 | 0 |
20650 | 20650 | 2020-03-30 | Jackson | Mississippi | 28059 | 39 | 0 |
18626 | 18626 | 2020-03-29 | Jackson | Mississippi | 28059 | 34 | 0 |
16704 | 16704 | 2020-03-28 | Jackson | Mississippi | 28059 | 33 | 0 |
14880 | 14880 | 2020-03-27 | Jackson | Mississippi | 28059 | 24 | 0 |
13164 | 13164 | 2020-03-26 | Jackson | Mississippi | 28059 | 16 | 0 |
11572 | 11572 | 2020-03-25 | Jackson | Mississippi | 28059 | 12 | 0 |
10152 | 10152 | 2020-03-24 | Jackson | Mississippi | 28059 | 10 | 0 |
8856 | 8856 | 2020-03-23 | Jackson | Mississippi | 28059 | 7 | 0 |
7676 | 7676 | 2020-03-22 | Jackson | Mississippi | 28059 | 5 | 0 |
6593 | 6593 | 2020-03-21 | Jackson | Mississippi | 28059 | 5 | 0 |
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);