ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Jefferson" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387378 | 387378 | 2020-07-31 | Jefferson | Mississippi | 28063 | 188 | 6 |
384160 | 384160 | 2020-07-30 | Jefferson | Mississippi | 28063 | 185 | 5 |
380943 | 380943 | 2020-07-29 | Jefferson | Mississippi | 28063 | 178 | 5 |
377726 | 377726 | 2020-07-28 | Jefferson | Mississippi | 28063 | 171 | 5 |
374511 | 374511 | 2020-07-27 | Jefferson | Mississippi | 28063 | 166 | 4 |
371299 | 371299 | 2020-07-26 | Jefferson | Mississippi | 28063 | 163 | 4 |
368089 | 368089 | 2020-07-25 | Jefferson | Mississippi | 28063 | 158 | 4 |
364881 | 364881 | 2020-07-24 | Jefferson | Mississippi | 28063 | 154 | 4 |
361674 | 361674 | 2020-07-23 | Jefferson | Mississippi | 28063 | 152 | 4 |
358469 | 358469 | 2020-07-22 | Jefferson | Mississippi | 28063 | 151 | 4 |
355266 | 355266 | 2020-07-21 | Jefferson | Mississippi | 28063 | 145 | 3 |
352064 | 352064 | 2020-07-20 | Jefferson | Mississippi | 28063 | 142 | 3 |
348864 | 348864 | 2020-07-19 | Jefferson | Mississippi | 28063 | 141 | 3 |
345663 | 345663 | 2020-07-18 | Jefferson | Mississippi | 28063 | 138 | 3 |
342463 | 342463 | 2020-07-17 | Jefferson | Mississippi | 28063 | 142 | 3 |
339267 | 339267 | 2020-07-16 | Jefferson | Mississippi | 28063 | 139 | 3 |
336071 | 336071 | 2020-07-15 | Jefferson | Mississippi | 28063 | 135 | 3 |
332878 | 332878 | 2020-07-14 | Jefferson | Mississippi | 28063 | 135 | 3 |
329691 | 329691 | 2020-07-13 | Jefferson | Mississippi | 28063 | 137 | 3 |
326505 | 326505 | 2020-07-12 | Jefferson | Mississippi | 28063 | 128 | 3 |
323322 | 323322 | 2020-07-11 | Jefferson | Mississippi | 28063 | 126 | 3 |
320143 | 320143 | 2020-07-10 | Jefferson | Mississippi | 28063 | 122 | 3 |
316968 | 316968 | 2020-07-09 | Jefferson | Mississippi | 28063 | 117 | 3 |
313794 | 313794 | 2020-07-08 | Jefferson | Mississippi | 28063 | 114 | 3 |
310624 | 310624 | 2020-07-07 | Jefferson | Mississippi | 28063 | 110 | 3 |
307456 | 307456 | 2020-07-06 | Jefferson | Mississippi | 28063 | 108 | 3 |
304289 | 304289 | 2020-07-05 | Jefferson | Mississippi | 28063 | 107 | 3 |
301125 | 301125 | 2020-07-04 | Jefferson | Mississippi | 28063 | 107 | 3 |
297962 | 297962 | 2020-07-03 | Jefferson | Mississippi | 28063 | 99 | 3 |
294804 | 294804 | 2020-07-02 | Jefferson | Mississippi | 28063 | 96 | 3 |
291650 | 291650 | 2020-07-01 | Jefferson | Mississippi | 28063 | 92 | 3 |
288499 | 288499 | 2020-06-30 | Jefferson | Mississippi | 28063 | 84 | 3 |
285349 | 285349 | 2020-06-29 | Jefferson | Mississippi | 28063 | 83 | 3 |
282204 | 282204 | 2020-06-28 | Jefferson | Mississippi | 28063 | 80 | 3 |
279056 | 279056 | 2020-06-27 | Jefferson | Mississippi | 28063 | 78 | 3 |
275908 | 275908 | 2020-06-26 | Jefferson | Mississippi | 28063 | 76 | 3 |
272765 | 272765 | 2020-06-25 | Jefferson | Mississippi | 28063 | 69 | 3 |
269627 | 269627 | 2020-06-24 | Jefferson | Mississippi | 28063 | 65 | 3 |
266494 | 266494 | 2020-06-23 | Jefferson | Mississippi | 28063 | 64 | 2 |
263368 | 263368 | 2020-06-22 | Jefferson | Mississippi | 28063 | 63 | 2 |
260239 | 260239 | 2020-06-21 | Jefferson | Mississippi | 28063 | 57 | 2 |
257113 | 257113 | 2020-06-20 | Jefferson | Mississippi | 28063 | 57 | 2 |
253993 | 253993 | 2020-06-19 | Jefferson | Mississippi | 28063 | 57 | 2 |
250878 | 250878 | 2020-06-18 | Jefferson | Mississippi | 28063 | 57 | 2 |
247766 | 247766 | 2020-06-17 | Jefferson | Mississippi | 28063 | 57 | 2 |
244653 | 244653 | 2020-06-16 | Jefferson | Mississippi | 28063 | 54 | 2 |
241542 | 241542 | 2020-06-15 | Jefferson | Mississippi | 28063 | 55 | 2 |
238433 | 238433 | 2020-06-14 | Jefferson | Mississippi | 28063 | 54 | 2 |
235326 | 235326 | 2020-06-13 | Jefferson | Mississippi | 28063 | 53 | 2 |
232220 | 232220 | 2020-06-12 | Jefferson | Mississippi | 28063 | 52 | 2 |
229116 | 229116 | 2020-06-11 | Jefferson | Mississippi | 28063 | 50 | 2 |
226014 | 226014 | 2020-06-10 | Jefferson | Mississippi | 28063 | 50 | 2 |
222916 | 222916 | 2020-06-09 | Jefferson | Mississippi | 28063 | 49 | 1 |
219821 | 219821 | 2020-06-08 | Jefferson | Mississippi | 28063 | 50 | 1 |
216729 | 216729 | 2020-06-07 | Jefferson | Mississippi | 28063 | 46 | 1 |
213641 | 213641 | 2020-06-06 | Jefferson | Mississippi | 28063 | 46 | 1 |
210557 | 210557 | 2020-06-05 | Jefferson | Mississippi | 28063 | 42 | 1 |
207476 | 207476 | 2020-06-04 | Jefferson | Mississippi | 28063 | 42 | 1 |
204395 | 204395 | 2020-06-03 | Jefferson | Mississippi | 28063 | 42 | 1 |
201318 | 201318 | 2020-06-02 | Jefferson | Mississippi | 28063 | 43 | 1 |
198245 | 198245 | 2020-06-01 | Jefferson | Mississippi | 28063 | 42 | 1 |
195174 | 195174 | 2020-05-31 | Jefferson | Mississippi | 28063 | 42 | 1 |
192106 | 192106 | 2020-05-30 | Jefferson | Mississippi | 28063 | 42 | 1 |
189042 | 189042 | 2020-05-29 | Jefferson | Mississippi | 28063 | 41 | 1 |
185984 | 185984 | 2020-05-28 | Jefferson | Mississippi | 28063 | 40 | 0 |
182928 | 182928 | 2020-05-27 | Jefferson | Mississippi | 28063 | 40 | 0 |
179882 | 179882 | 2020-05-26 | Jefferson | Mississippi | 28063 | 41 | 0 |
176838 | 176838 | 2020-05-25 | Jefferson | Mississippi | 28063 | 40 | 0 |
173795 | 173795 | 2020-05-24 | Jefferson | Mississippi | 28063 | 40 | 0 |
170753 | 170753 | 2020-05-23 | Jefferson | Mississippi | 28063 | 40 | 0 |
167715 | 167715 | 2020-05-22 | Jefferson | Mississippi | 28063 | 40 | 0 |
164679 | 164679 | 2020-05-21 | Jefferson | Mississippi | 28063 | 40 | 0 |
161650 | 161650 | 2020-05-20 | Jefferson | Mississippi | 28063 | 38 | 0 |
158624 | 158624 | 2020-05-19 | Jefferson | Mississippi | 28063 | 38 | 0 |
155606 | 155606 | 2020-05-18 | Jefferson | Mississippi | 28063 | 37 | 0 |
152592 | 152592 | 2020-05-17 | Jefferson | Mississippi | 28063 | 37 | 0 |
149581 | 149581 | 2020-05-16 | Jefferson | Mississippi | 28063 | 35 | 0 |
146576 | 146576 | 2020-05-15 | Jefferson | Mississippi | 28063 | 34 | 0 |
143576 | 143576 | 2020-05-14 | Jefferson | Mississippi | 28063 | 33 | 0 |
140581 | 140581 | 2020-05-13 | Jefferson | Mississippi | 28063 | 32 | 0 |
137587 | 137587 | 2020-05-12 | Jefferson | Mississippi | 28063 | 32 | 0 |
134597 | 134597 | 2020-05-11 | Jefferson | Mississippi | 28063 | 31 | 0 |
131606 | 131606 | 2020-05-10 | Jefferson | Mississippi | 28063 | 30 | 0 |
128616 | 128616 | 2020-05-09 | Jefferson | Mississippi | 28063 | 30 | 0 |
125629 | 125629 | 2020-05-08 | Jefferson | Mississippi | 28063 | 30 | 0 |
122647 | 122647 | 2020-05-07 | Jefferson | Mississippi | 28063 | 30 | 0 |
119673 | 119673 | 2020-05-06 | Jefferson | Mississippi | 28063 | 26 | 0 |
116713 | 116713 | 2020-05-05 | Jefferson | Mississippi | 28063 | 24 | 0 |
113831 | 113831 | 2020-05-04 | Jefferson | Mississippi | 28063 | 23 | 0 |
110952 | 110952 | 2020-05-03 | Jefferson | Mississippi | 28063 | 22 | 0 |
108081 | 108081 | 2020-05-02 | Jefferson | Mississippi | 28063 | 21 | 0 |
105216 | 105216 | 2020-05-01 | Jefferson | Mississippi | 28063 | 20 | 0 |
102355 | 102355 | 2020-04-30 | Jefferson | Mississippi | 28063 | 18 | 0 |
99503 | 99503 | 2020-04-29 | Jefferson | Mississippi | 28063 | 23 | 0 |
96657 | 96657 | 2020-04-28 | Jefferson | Mississippi | 28063 | 16 | 0 |
93821 | 93821 | 2020-04-27 | Jefferson | Mississippi | 28063 | 12 | 0 |
91000 | 91000 | 2020-04-26 | Jefferson | Mississippi | 28063 | 9 | 0 |
88184 | 88184 | 2020-04-25 | Jefferson | Mississippi | 28063 | 8 | 0 |
85374 | 85374 | 2020-04-24 | Jefferson | Mississippi | 28063 | 5 | 0 |
82570 | 82570 | 2020-04-23 | Jefferson | Mississippi | 28063 | 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);