ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Lee" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387387 | 387387 | 2020-07-31 | Lee | Mississippi | 28081 | 1162 | 29 |
384169 | 384169 | 2020-07-30 | Lee | Mississippi | 28081 | 1115 | 28 |
380952 | 380952 | 2020-07-29 | Lee | Mississippi | 28081 | 1069 | 28 |
377735 | 377735 | 2020-07-28 | Lee | Mississippi | 28081 | 1050 | 28 |
374520 | 374520 | 2020-07-27 | Lee | Mississippi | 28081 | 1020 | 26 |
371308 | 371308 | 2020-07-26 | Lee | Mississippi | 28081 | 1002 | 26 |
368098 | 368098 | 2020-07-25 | Lee | Mississippi | 28081 | 968 | 26 |
364890 | 364890 | 2020-07-24 | Lee | Mississippi | 28081 | 941 | 26 |
361683 | 361683 | 2020-07-23 | Lee | Mississippi | 28081 | 896 | 26 |
358478 | 358478 | 2020-07-22 | Lee | Mississippi | 28081 | 879 | 26 |
355275 | 355275 | 2020-07-21 | Lee | Mississippi | 28081 | 863 | 25 |
352073 | 352073 | 2020-07-20 | Lee | Mississippi | 28081 | 820 | 24 |
348873 | 348873 | 2020-07-19 | Lee | Mississippi | 28081 | 768 | 24 |
345672 | 345672 | 2020-07-18 | Lee | Mississippi | 28081 | 747 | 24 |
342472 | 342472 | 2020-07-17 | Lee | Mississippi | 28081 | 728 | 23 |
339276 | 339276 | 2020-07-16 | Lee | Mississippi | 28081 | 695 | 23 |
336080 | 336080 | 2020-07-15 | Lee | Mississippi | 28081 | 662 | 23 |
332887 | 332887 | 2020-07-14 | Lee | Mississippi | 28081 | 640 | 23 |
329700 | 329700 | 2020-07-13 | Lee | Mississippi | 28081 | 630 | 22 |
326514 | 326514 | 2020-07-12 | Lee | Mississippi | 28081 | 628 | 22 |
323331 | 323331 | 2020-07-11 | Lee | Mississippi | 28081 | 612 | 22 |
320152 | 320152 | 2020-07-10 | Lee | Mississippi | 28081 | 600 | 22 |
316977 | 316977 | 2020-07-09 | Lee | Mississippi | 28081 | 586 | 21 |
313803 | 313803 | 2020-07-08 | Lee | Mississippi | 28081 | 575 | 21 |
310633 | 310633 | 2020-07-07 | Lee | Mississippi | 28081 | 562 | 20 |
307465 | 307465 | 2020-07-06 | Lee | Mississippi | 28081 | 552 | 19 |
304298 | 304298 | 2020-07-05 | Lee | Mississippi | 28081 | 547 | 18 |
301134 | 301134 | 2020-07-04 | Lee | Mississippi | 28081 | 547 | 18 |
297971 | 297971 | 2020-07-03 | Lee | Mississippi | 28081 | 532 | 18 |
294813 | 294813 | 2020-07-02 | Lee | Mississippi | 28081 | 518 | 16 |
291659 | 291659 | 2020-07-01 | Lee | Mississippi | 28081 | 493 | 16 |
288508 | 288508 | 2020-06-30 | Lee | Mississippi | 28081 | 477 | 16 |
285358 | 285358 | 2020-06-29 | Lee | Mississippi | 28081 | 460 | 15 |
282213 | 282213 | 2020-06-28 | Lee | Mississippi | 28081 | 452 | 15 |
279065 | 279065 | 2020-06-27 | Lee | Mississippi | 28081 | 447 | 15 |
275917 | 275917 | 2020-06-26 | Lee | Mississippi | 28081 | 437 | 15 |
272774 | 272774 | 2020-06-25 | Lee | Mississippi | 28081 | 429 | 15 |
269636 | 269636 | 2020-06-24 | Lee | Mississippi | 28081 | 403 | 15 |
266503 | 266503 | 2020-06-23 | Lee | Mississippi | 28081 | 388 | 14 |
263377 | 263377 | 2020-06-22 | Lee | Mississippi | 28081 | 374 | 14 |
260248 | 260248 | 2020-06-21 | Lee | Mississippi | 28081 | 330 | 14 |
257122 | 257122 | 2020-06-20 | Lee | Mississippi | 28081 | 330 | 14 |
254002 | 254002 | 2020-06-19 | Lee | Mississippi | 28081 | 330 | 14 |
250887 | 250887 | 2020-06-18 | Lee | Mississippi | 28081 | 330 | 14 |
247775 | 247775 | 2020-06-17 | Lee | Mississippi | 28081 | 330 | 14 |
244662 | 244662 | 2020-06-16 | Lee | Mississippi | 28081 | 310 | 12 |
241551 | 241551 | 2020-06-15 | Lee | Mississippi | 28081 | 301 | 11 |
238442 | 238442 | 2020-06-14 | Lee | Mississippi | 28081 | 296 | 11 |
235335 | 235335 | 2020-06-13 | Lee | Mississippi | 28081 | 292 | 11 |
232229 | 232229 | 2020-06-12 | Lee | Mississippi | 28081 | 287 | 11 |
229125 | 229125 | 2020-06-11 | Lee | Mississippi | 28081 | 261 | 11 |
226023 | 226023 | 2020-06-10 | Lee | Mississippi | 28081 | 261 | 11 |
222925 | 222925 | 2020-06-09 | Lee | Mississippi | 28081 | 248 | 9 |
219830 | 219830 | 2020-06-08 | Lee | Mississippi | 28081 | 237 | 9 |
216738 | 216738 | 2020-06-07 | Lee | Mississippi | 28081 | 224 | 8 |
213650 | 213650 | 2020-06-06 | Lee | Mississippi | 28081 | 220 | 8 |
210566 | 210566 | 2020-06-05 | Lee | Mississippi | 28081 | 197 | 8 |
207485 | 207485 | 2020-06-04 | Lee | Mississippi | 28081 | 194 | 8 |
204404 | 204404 | 2020-06-03 | Lee | Mississippi | 28081 | 185 | 7 |
201327 | 201327 | 2020-06-02 | Lee | Mississippi | 28081 | 165 | 7 |
198254 | 198254 | 2020-06-01 | Lee | Mississippi | 28081 | 154 | 6 |
195183 | 195183 | 2020-05-31 | Lee | Mississippi | 28081 | 153 | 6 |
192115 | 192115 | 2020-05-30 | Lee | Mississippi | 28081 | 149 | 6 |
189051 | 189051 | 2020-05-29 | Lee | Mississippi | 28081 | 139 | 6 |
185993 | 185993 | 2020-05-28 | Lee | Mississippi | 28081 | 124 | 5 |
182937 | 182937 | 2020-05-27 | Lee | Mississippi | 28081 | 117 | 5 |
179891 | 179891 | 2020-05-26 | Lee | Mississippi | 28081 | 113 | 5 |
176847 | 176847 | 2020-05-25 | Lee | Mississippi | 28081 | 108 | 5 |
173804 | 173804 | 2020-05-24 | Lee | Mississippi | 28081 | 104 | 5 |
170762 | 170762 | 2020-05-23 | Lee | Mississippi | 28081 | 101 | 5 |
167724 | 167724 | 2020-05-22 | Lee | Mississippi | 28081 | 99 | 5 |
164688 | 164688 | 2020-05-21 | Lee | Mississippi | 28081 | 97 | 5 |
161659 | 161659 | 2020-05-20 | Lee | Mississippi | 28081 | 95 | 5 |
158633 | 158633 | 2020-05-19 | Lee | Mississippi | 28081 | 96 | 5 |
155615 | 155615 | 2020-05-18 | Lee | Mississippi | 28081 | 93 | 4 |
152601 | 152601 | 2020-05-17 | Lee | Mississippi | 28081 | 93 | 4 |
149590 | 149590 | 2020-05-16 | Lee | Mississippi | 28081 | 89 | 4 |
146585 | 146585 | 2020-05-15 | Lee | Mississippi | 28081 | 85 | 4 |
143585 | 143585 | 2020-05-14 | Lee | Mississippi | 28081 | 83 | 4 |
140590 | 140590 | 2020-05-13 | Lee | Mississippi | 28081 | 81 | 4 |
137596 | 137596 | 2020-05-12 | Lee | Mississippi | 28081 | 81 | 4 |
134606 | 134606 | 2020-05-11 | Lee | Mississippi | 28081 | 80 | 4 |
131615 | 131615 | 2020-05-10 | Lee | Mississippi | 28081 | 77 | 4 |
128625 | 128625 | 2020-05-09 | Lee | Mississippi | 28081 | 78 | 4 |
125638 | 125638 | 2020-05-08 | Lee | Mississippi | 28081 | 77 | 4 |
122656 | 122656 | 2020-05-07 | Lee | Mississippi | 28081 | 73 | 4 |
119682 | 119682 | 2020-05-06 | Lee | Mississippi | 28081 | 73 | 4 |
116722 | 116722 | 2020-05-05 | Lee | Mississippi | 28081 | 75 | 4 |
113840 | 113840 | 2020-05-04 | Lee | Mississippi | 28081 | 72 | 4 |
110961 | 110961 | 2020-05-03 | Lee | Mississippi | 28081 | 71 | 4 |
108090 | 108090 | 2020-05-02 | Lee | Mississippi | 28081 | 71 | 4 |
105225 | 105225 | 2020-05-01 | Lee | Mississippi | 28081 | 71 | 4 |
102364 | 102364 | 2020-04-30 | Lee | Mississippi | 28081 | 69 | 4 |
99512 | 99512 | 2020-04-29 | Lee | Mississippi | 28081 | 70 | 4 |
96666 | 96666 | 2020-04-28 | Lee | Mississippi | 28081 | 71 | 4 |
93830 | 93830 | 2020-04-27 | Lee | Mississippi | 28081 | 70 | 4 |
91009 | 91009 | 2020-04-26 | Lee | Mississippi | 28081 | 72 | 5 |
88193 | 88193 | 2020-04-25 | Lee | Mississippi | 28081 | 72 | 5 |
85383 | 85383 | 2020-04-24 | Lee | Mississippi | 28081 | 70 | 4 |
82579 | 82579 | 2020-04-23 | Lee | Mississippi | 28081 | 66 | 4 |
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);