ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Sharkey" and state = "Mississippi" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
14911 | 14911 | 2020-03-27 | Sharkey | Mississippi | 28125 | 1 | 0 |
16735 | 16735 | 2020-03-28 | Sharkey | Mississippi | 28125 | 1 | 0 |
18657 | 18657 | 2020-03-29 | Sharkey | Mississippi | 28125 | 1 | 0 |
20681 | 20681 | 2020-03-30 | Sharkey | Mississippi | 28125 | 1 | 0 |
22798 | 22798 | 2020-03-31 | Sharkey | Mississippi | 28125 | 1 | 0 |
24982 | 24982 | 2020-04-01 | Sharkey | Mississippi | 28125 | 2 | 0 |
27236 | 27236 | 2020-04-02 | Sharkey | Mississippi | 28125 | 2 | 0 |
29555 | 29555 | 2020-04-03 | Sharkey | Mississippi | 28125 | 2 | 0 |
31935 | 31935 | 2020-04-04 | Sharkey | Mississippi | 28125 | 2 | 0 |
34362 | 34362 | 2020-04-05 | Sharkey | Mississippi | 28125 | 3 | 0 |
36825 | 36825 | 2020-04-06 | Sharkey | Mississippi | 28125 | 3 | 0 |
39336 | 39336 | 2020-04-07 | Sharkey | Mississippi | 28125 | 3 | 0 |
41890 | 41890 | 2020-04-08 | Sharkey | Mississippi | 28125 | 3 | 0 |
44467 | 44467 | 2020-04-09 | Sharkey | Mississippi | 28125 | 3 | 0 |
47076 | 47076 | 2020-04-10 | Sharkey | Mississippi | 28125 | 3 | 0 |
49722 | 49722 | 2020-04-11 | Sharkey | Mississippi | 28125 | 3 | 0 |
52395 | 52395 | 2020-04-12 | Sharkey | Mississippi | 28125 | 3 | 0 |
55077 | 55077 | 2020-04-13 | Sharkey | Mississippi | 28125 | 3 | 0 |
57775 | 57775 | 2020-04-14 | Sharkey | Mississippi | 28125 | 3 | 0 |
60486 | 60486 | 2020-04-15 | Sharkey | Mississippi | 28125 | 3 | 0 |
63208 | 63208 | 2020-04-16 | Sharkey | Mississippi | 28125 | 3 | 0 |
65948 | 65948 | 2020-04-17 | Sharkey | Mississippi | 28125 | 3 | 0 |
68700 | 68700 | 2020-04-18 | Sharkey | Mississippi | 28125 | 3 | 0 |
71466 | 71466 | 2020-04-19 | Sharkey | Mississippi | 28125 | 3 | 0 |
74239 | 74239 | 2020-04-20 | Sharkey | Mississippi | 28125 | 3 | 0 |
77020 | 77020 | 2020-04-21 | Sharkey | Mississippi | 28125 | 3 | 0 |
79805 | 79805 | 2020-04-22 | Sharkey | Mississippi | 28125 | 3 | 0 |
82601 | 82601 | 2020-04-23 | Sharkey | Mississippi | 28125 | 4 | 0 |
85405 | 85405 | 2020-04-24 | Sharkey | Mississippi | 28125 | 4 | 0 |
88215 | 88215 | 2020-04-25 | Sharkey | Mississippi | 28125 | 4 | 0 |
91031 | 91031 | 2020-04-26 | Sharkey | Mississippi | 28125 | 4 | 0 |
93852 | 93852 | 2020-04-27 | Sharkey | Mississippi | 28125 | 5 | 0 |
96688 | 96688 | 2020-04-28 | Sharkey | Mississippi | 28125 | 5 | 0 |
99534 | 99534 | 2020-04-29 | Sharkey | Mississippi | 28125 | 5 | 0 |
102386 | 102386 | 2020-04-30 | Sharkey | Mississippi | 28125 | 5 | 0 |
105247 | 105247 | 2020-05-01 | Sharkey | Mississippi | 28125 | 5 | 0 |
108112 | 108112 | 2020-05-02 | Sharkey | Mississippi | 28125 | 5 | 0 |
110983 | 110983 | 2020-05-03 | Sharkey | Mississippi | 28125 | 5 | 0 |
113862 | 113862 | 2020-05-04 | Sharkey | Mississippi | 28125 | 5 | 0 |
116744 | 116744 | 2020-05-05 | Sharkey | Mississippi | 28125 | 5 | 0 |
119704 | 119704 | 2020-05-06 | Sharkey | Mississippi | 28125 | 5 | 0 |
122678 | 122678 | 2020-05-07 | Sharkey | Mississippi | 28125 | 5 | 0 |
125660 | 125660 | 2020-05-08 | Sharkey | Mississippi | 28125 | 5 | 0 |
128647 | 128647 | 2020-05-09 | Sharkey | Mississippi | 28125 | 5 | 0 |
131637 | 131637 | 2020-05-10 | Sharkey | Mississippi | 28125 | 5 | 0 |
134628 | 134628 | 2020-05-11 | Sharkey | Mississippi | 28125 | 5 | 0 |
137618 | 137618 | 2020-05-12 | Sharkey | Mississippi | 28125 | 5 | 0 |
140612 | 140612 | 2020-05-13 | Sharkey | Mississippi | 28125 | 5 | 0 |
143607 | 143607 | 2020-05-14 | Sharkey | Mississippi | 28125 | 5 | 0 |
146607 | 146607 | 2020-05-15 | Sharkey | Mississippi | 28125 | 5 | 0 |
149612 | 149612 | 2020-05-16 | Sharkey | Mississippi | 28125 | 6 | 0 |
152623 | 152623 | 2020-05-17 | Sharkey | Mississippi | 28125 | 6 | 0 |
155637 | 155637 | 2020-05-18 | Sharkey | Mississippi | 28125 | 6 | 0 |
158655 | 158655 | 2020-05-19 | Sharkey | Mississippi | 28125 | 7 | 0 |
161681 | 161681 | 2020-05-20 | Sharkey | Mississippi | 28125 | 7 | 0 |
164710 | 164710 | 2020-05-21 | Sharkey | Mississippi | 28125 | 7 | 0 |
167746 | 167746 | 2020-05-22 | Sharkey | Mississippi | 28125 | 7 | 0 |
170784 | 170784 | 2020-05-23 | Sharkey | Mississippi | 28125 | 7 | 0 |
173826 | 173826 | 2020-05-24 | Sharkey | Mississippi | 28125 | 7 | 0 |
176869 | 176869 | 2020-05-25 | Sharkey | Mississippi | 28125 | 7 | 0 |
179913 | 179913 | 2020-05-26 | Sharkey | Mississippi | 28125 | 7 | 0 |
182959 | 182959 | 2020-05-27 | Sharkey | Mississippi | 28125 | 7 | 0 |
186015 | 186015 | 2020-05-28 | Sharkey | Mississippi | 28125 | 7 | 0 |
189073 | 189073 | 2020-05-29 | Sharkey | Mississippi | 28125 | 7 | 0 |
192137 | 192137 | 2020-05-30 | Sharkey | Mississippi | 28125 | 7 | 0 |
195205 | 195205 | 2020-05-31 | Sharkey | Mississippi | 28125 | 7 | 0 |
198276 | 198276 | 2020-06-01 | Sharkey | Mississippi | 28125 | 7 | 0 |
201349 | 201349 | 2020-06-02 | Sharkey | Mississippi | 28125 | 7 | 0 |
204426 | 204426 | 2020-06-03 | Sharkey | Mississippi | 28125 | 7 | 0 |
207507 | 207507 | 2020-06-04 | Sharkey | Mississippi | 28125 | 7 | 0 |
210588 | 210588 | 2020-06-05 | Sharkey | Mississippi | 28125 | 7 | 0 |
213672 | 213672 | 2020-06-06 | Sharkey | Mississippi | 28125 | 7 | 0 |
216760 | 216760 | 2020-06-07 | Sharkey | Mississippi | 28125 | 7 | 0 |
219852 | 219852 | 2020-06-08 | Sharkey | Mississippi | 28125 | 7 | 0 |
222947 | 222947 | 2020-06-09 | Sharkey | Mississippi | 28125 | 7 | 0 |
226045 | 226045 | 2020-06-10 | Sharkey | Mississippi | 28125 | 7 | 0 |
229147 | 229147 | 2020-06-11 | Sharkey | Mississippi | 28125 | 7 | 0 |
232251 | 232251 | 2020-06-12 | Sharkey | Mississippi | 28125 | 8 | 0 |
235357 | 235357 | 2020-06-13 | Sharkey | Mississippi | 28125 | 8 | 0 |
238464 | 238464 | 2020-06-14 | Sharkey | Mississippi | 28125 | 8 | 0 |
241573 | 241573 | 2020-06-15 | Sharkey | Mississippi | 28125 | 8 | 0 |
244684 | 244684 | 2020-06-16 | Sharkey | Mississippi | 28125 | 8 | 0 |
247797 | 247797 | 2020-06-17 | Sharkey | Mississippi | 28125 | 9 | 0 |
250909 | 250909 | 2020-06-18 | Sharkey | Mississippi | 28125 | 9 | 0 |
254024 | 254024 | 2020-06-19 | Sharkey | Mississippi | 28125 | 9 | 0 |
257144 | 257144 | 2020-06-20 | Sharkey | Mississippi | 28125 | 9 | 0 |
260270 | 260270 | 2020-06-21 | Sharkey | Mississippi | 28125 | 9 | 0 |
263399 | 263399 | 2020-06-22 | Sharkey | Mississippi | 28125 | 13 | 0 |
266525 | 266525 | 2020-06-23 | Sharkey | Mississippi | 28125 | 16 | 0 |
269658 | 269658 | 2020-06-24 | Sharkey | Mississippi | 28125 | 18 | 0 |
272796 | 272796 | 2020-06-25 | Sharkey | Mississippi | 28125 | 20 | 0 |
275939 | 275939 | 2020-06-26 | Sharkey | Mississippi | 28125 | 21 | 0 |
279087 | 279087 | 2020-06-27 | Sharkey | Mississippi | 28125 | 22 | 0 |
282235 | 282235 | 2020-06-28 | Sharkey | Mississippi | 28125 | 23 | 0 |
285380 | 285380 | 2020-06-29 | Sharkey | Mississippi | 28125 | 24 | 0 |
288530 | 288530 | 2020-06-30 | Sharkey | Mississippi | 28125 | 24 | 0 |
291681 | 291681 | 2020-07-01 | Sharkey | Mississippi | 28125 | 24 | 0 |
294835 | 294835 | 2020-07-02 | Sharkey | Mississippi | 28125 | 27 | 0 |
297993 | 297993 | 2020-07-03 | Sharkey | Mississippi | 28125 | 34 | 0 |
301156 | 301156 | 2020-07-04 | Sharkey | Mississippi | 28125 | 35 | 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);