ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Leflore" and state = "Mississippi" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-13 1
- 2020-03-14 1
- 2020-03-15 1
- 2020-03-16 1
- 2020-03-17 1
- 2020-03-18 1
- 2020-03-19 1
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- …
state 1
- Mississippi · 792 ✖
fips 1
- 28083 792
county 1
- Leflore · 792 ✖
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
1778 | 1778 | 2020-03-13 | Leflore | Mississippi | 28083 | 1 | 0 |
2123 | 2123 | 2020-03-14 | Leflore | Mississippi | 28083 | 1 | 0 |
2530 | 2530 | 2020-03-15 | Leflore | Mississippi | 28083 | 1 | 0 |
2983 | 2983 | 2020-03-16 | Leflore | Mississippi | 28083 | 1 | 0 |
3490 | 3490 | 2020-03-17 | Leflore | Mississippi | 28083 | 4 | 0 |
4077 | 4077 | 2020-03-18 | Leflore | Mississippi | 28083 | 4 | 0 |
4791 | 4791 | 2020-03-19 | Leflore | Mississippi | 28083 | 4 | 0 |
5619 | 5619 | 2020-03-20 | Leflore | Mississippi | 28083 | 7 | 0 |
6599 | 6599 | 2020-03-21 | Leflore | Mississippi | 28083 | 7 | 0 |
7682 | 7682 | 2020-03-22 | Leflore | Mississippi | 28083 | 8 | 0 |
8863 | 8863 | 2020-03-23 | Leflore | Mississippi | 28083 | 9 | 0 |
10159 | 10159 | 2020-03-24 | Leflore | Mississippi | 28083 | 10 | 0 |
11579 | 11579 | 2020-03-25 | Leflore | Mississippi | 28083 | 13 | 0 |
13172 | 13172 | 2020-03-26 | Leflore | Mississippi | 28083 | 13 | 0 |
14890 | 14890 | 2020-03-27 | Leflore | Mississippi | 28083 | 13 | 0 |
16714 | 16714 | 2020-03-28 | Leflore | Mississippi | 28083 | 15 | 0 |
18636 | 18636 | 2020-03-29 | Leflore | Mississippi | 28083 | 15 | 0 |
20660 | 20660 | 2020-03-30 | Leflore | Mississippi | 28083 | 18 | 1 |
22777 | 22777 | 2020-03-31 | Leflore | Mississippi | 28083 | 19 | 1 |
24961 | 24961 | 2020-04-01 | Leflore | Mississippi | 28083 | 20 | 1 |
27215 | 27215 | 2020-04-02 | Leflore | Mississippi | 28083 | 20 | 1 |
29534 | 29534 | 2020-04-03 | Leflore | Mississippi | 28083 | 21 | 1 |
31914 | 31914 | 2020-04-04 | Leflore | Mississippi | 28083 | 22 | 1 |
34341 | 34341 | 2020-04-05 | Leflore | Mississippi | 28083 | 22 | 3 |
36804 | 36804 | 2020-04-06 | Leflore | Mississippi | 28083 | 23 | 4 |
39315 | 39315 | 2020-04-07 | Leflore | Mississippi | 28083 | 26 | 4 |
41869 | 41869 | 2020-04-08 | Leflore | Mississippi | 28083 | 28 | 4 |
44446 | 44446 | 2020-04-09 | Leflore | Mississippi | 28083 | 32 | 4 |
47055 | 47055 | 2020-04-10 | Leflore | Mississippi | 28083 | 43 | 4 |
49701 | 49701 | 2020-04-11 | Leflore | Mississippi | 28083 | 44 | 4 |
52374 | 52374 | 2020-04-12 | Leflore | Mississippi | 28083 | 45 | 4 |
55056 | 55056 | 2020-04-13 | Leflore | Mississippi | 28083 | 48 | 4 |
57754 | 57754 | 2020-04-14 | Leflore | Mississippi | 28083 | 52 | 6 |
60465 | 60465 | 2020-04-15 | Leflore | Mississippi | 28083 | 55 | 6 |
63187 | 63187 | 2020-04-16 | Leflore | Mississippi | 28083 | 62 | 6 |
65927 | 65927 | 2020-04-17 | Leflore | Mississippi | 28083 | 70 | 6 |
68679 | 68679 | 2020-04-18 | Leflore | Mississippi | 28083 | 75 | 6 |
71445 | 71445 | 2020-04-19 | Leflore | Mississippi | 28083 | 91 | 7 |
74218 | 74218 | 2020-04-20 | Leflore | Mississippi | 28083 | 105 | 10 |
76999 | 76999 | 2020-04-21 | Leflore | Mississippi | 28083 | 109 | 12 |
79784 | 79784 | 2020-04-22 | Leflore | Mississippi | 28083 | 113 | 12 |
82580 | 82580 | 2020-04-23 | Leflore | Mississippi | 28083 | 119 | 13 |
85384 | 85384 | 2020-04-24 | Leflore | Mississippi | 28083 | 124 | 14 |
88194 | 88194 | 2020-04-25 | Leflore | Mississippi | 28083 | 131 | 15 |
91010 | 91010 | 2020-04-26 | Leflore | Mississippi | 28083 | 136 | 15 |
93831 | 93831 | 2020-04-27 | Leflore | Mississippi | 28083 | 137 | 15 |
96667 | 96667 | 2020-04-28 | Leflore | Mississippi | 28083 | 141 | 15 |
99513 | 99513 | 2020-04-29 | Leflore | Mississippi | 28083 | 145 | 16 |
102365 | 102365 | 2020-04-30 | Leflore | Mississippi | 28083 | 148 | 17 |
105226 | 105226 | 2020-05-01 | Leflore | Mississippi | 28083 | 164 | 17 |
108091 | 108091 | 2020-05-02 | Leflore | Mississippi | 28083 | 165 | 17 |
110962 | 110962 | 2020-05-03 | Leflore | Mississippi | 28083 | 168 | 17 |
113841 | 113841 | 2020-05-04 | Leflore | Mississippi | 28083 | 174 | 17 |
116723 | 116723 | 2020-05-05 | Leflore | Mississippi | 28083 | 175 | 18 |
119683 | 119683 | 2020-05-06 | Leflore | Mississippi | 28083 | 177 | 18 |
122657 | 122657 | 2020-05-07 | Leflore | Mississippi | 28083 | 180 | 18 |
125639 | 125639 | 2020-05-08 | Leflore | Mississippi | 28083 | 182 | 18 |
128626 | 128626 | 2020-05-09 | Leflore | Mississippi | 28083 | 185 | 18 |
131616 | 131616 | 2020-05-10 | Leflore | Mississippi | 28083 | 185 | 18 |
134607 | 134607 | 2020-05-11 | Leflore | Mississippi | 28083 | 185 | 18 |
137597 | 137597 | 2020-05-12 | Leflore | Mississippi | 28083 | 191 | 20 |
140591 | 140591 | 2020-05-13 | Leflore | Mississippi | 28083 | 192 | 21 |
143586 | 143586 | 2020-05-14 | Leflore | Mississippi | 28083 | 197 | 22 |
146586 | 146586 | 2020-05-15 | Leflore | Mississippi | 28083 | 199 | 22 |
149591 | 149591 | 2020-05-16 | Leflore | Mississippi | 28083 | 200 | 22 |
152602 | 152602 | 2020-05-17 | Leflore | Mississippi | 28083 | 200 | 22 |
155616 | 155616 | 2020-05-18 | Leflore | Mississippi | 28083 | 200 | 22 |
158634 | 158634 | 2020-05-19 | Leflore | Mississippi | 28083 | 202 | 22 |
161660 | 161660 | 2020-05-20 | Leflore | Mississippi | 28083 | 205 | 23 |
164689 | 164689 | 2020-05-21 | Leflore | Mississippi | 28083 | 206 | 24 |
167725 | 167725 | 2020-05-22 | Leflore | Mississippi | 28083 | 211 | 25 |
173805 | 173805 | 2020-05-24 | Leflore | Mississippi | 28083 | 239 | 25 |
170763 | 170763 | 2020-05-23 | Leflore | Mississippi | 28083 | 240 | 25 |
176848 | 176848 | 2020-05-25 | Leflore | Mississippi | 28083 | 241 | 26 |
179892 | 179892 | 2020-05-26 | Leflore | Mississippi | 28083 | 246 | 27 |
182938 | 182938 | 2020-05-27 | Leflore | Mississippi | 28083 | 250 | 30 |
185994 | 185994 | 2020-05-28 | Leflore | Mississippi | 28083 | 251 | 30 |
189052 | 189052 | 2020-05-29 | Leflore | Mississippi | 28083 | 255 | 30 |
192116 | 192116 | 2020-05-30 | Leflore | Mississippi | 28083 | 258 | 31 |
195184 | 195184 | 2020-05-31 | Leflore | Mississippi | 28083 | 264 | 31 |
198255 | 198255 | 2020-06-01 | Leflore | Mississippi | 28083 | 265 | 32 |
201328 | 201328 | 2020-06-02 | Leflore | Mississippi | 28083 | 273 | 34 |
204405 | 204405 | 2020-06-03 | Leflore | Mississippi | 28083 | 273 | 36 |
207486 | 207486 | 2020-06-04 | Leflore | Mississippi | 28083 | 277 | 36 |
210567 | 210567 | 2020-06-05 | Leflore | Mississippi | 28083 | 282 | 38 |
213651 | 213651 | 2020-06-06 | Leflore | Mississippi | 28083 | 287 | 39 |
216739 | 216739 | 2020-06-07 | Leflore | Mississippi | 28083 | 288 | 40 |
219831 | 219831 | 2020-06-08 | Leflore | Mississippi | 28083 | 309 | 42 |
222926 | 222926 | 2020-06-09 | Leflore | Mississippi | 28083 | 322 | 43 |
226024 | 226024 | 2020-06-10 | Leflore | Mississippi | 28083 | 330 | 44 |
229126 | 229126 | 2020-06-11 | Leflore | Mississippi | 28083 | 330 | 44 |
232230 | 232230 | 2020-06-12 | Leflore | Mississippi | 28083 | 350 | 44 |
235336 | 235336 | 2020-06-13 | Leflore | Mississippi | 28083 | 352 | 45 |
238443 | 238443 | 2020-06-14 | Leflore | Mississippi | 28083 | 358 | 45 |
241552 | 241552 | 2020-06-15 | Leflore | Mississippi | 28083 | 368 | 45 |
244663 | 244663 | 2020-06-16 | Leflore | Mississippi | 28083 | 376 | 45 |
247776 | 247776 | 2020-06-17 | Leflore | Mississippi | 28083 | 385 | 47 |
250888 | 250888 | 2020-06-18 | Leflore | Mississippi | 28083 | 385 | 47 |
254003 | 254003 | 2020-06-19 | Leflore | Mississippi | 28083 | 385 | 47 |
257123 | 257123 | 2020-06-20 | Leflore | Mississippi | 28083 | 385 | 47 |
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);