ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Pike" and state = "Mississippi" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5625 | 5625 | 2020-03-20 | Pike | Mississippi | 28113 | 1 | 0 |
6608 | 6608 | 2020-03-21 | Pike | Mississippi | 28113 | 2 | 0 |
7693 | 7693 | 2020-03-22 | Pike | Mississippi | 28113 | 3 | 0 |
8875 | 8875 | 2020-03-23 | Pike | Mississippi | 28113 | 4 | 0 |
10173 | 10173 | 2020-03-24 | Pike | Mississippi | 28113 | 7 | 0 |
11593 | 11593 | 2020-03-25 | Pike | Mississippi | 28113 | 10 | 0 |
13186 | 13186 | 2020-03-26 | Pike | Mississippi | 28113 | 12 | 0 |
14905 | 14905 | 2020-03-27 | Pike | Mississippi | 28113 | 12 | 0 |
16729 | 16729 | 2020-03-28 | Pike | Mississippi | 28113 | 12 | 0 |
18651 | 18651 | 2020-03-29 | Pike | Mississippi | 28113 | 14 | 0 |
20675 | 20675 | 2020-03-30 | Pike | Mississippi | 28113 | 16 | 0 |
22792 | 22792 | 2020-03-31 | Pike | Mississippi | 28113 | 17 | 0 |
24976 | 24976 | 2020-04-01 | Pike | Mississippi | 28113 | 20 | 0 |
27230 | 27230 | 2020-04-02 | Pike | Mississippi | 28113 | 21 | 0 |
29549 | 29549 | 2020-04-03 | Pike | Mississippi | 28113 | 21 | 0 |
31929 | 31929 | 2020-04-04 | Pike | Mississippi | 28113 | 23 | 0 |
34356 | 34356 | 2020-04-05 | Pike | Mississippi | 28113 | 26 | 0 |
36819 | 36819 | 2020-04-06 | Pike | Mississippi | 28113 | 28 | 0 |
39330 | 39330 | 2020-04-07 | Pike | Mississippi | 28113 | 31 | 0 |
41884 | 41884 | 2020-04-08 | Pike | Mississippi | 28113 | 33 | 1 |
44461 | 44461 | 2020-04-09 | Pike | Mississippi | 28113 | 35 | 1 |
47070 | 47070 | 2020-04-10 | Pike | Mississippi | 28113 | 39 | 1 |
49716 | 49716 | 2020-04-11 | Pike | Mississippi | 28113 | 47 | 1 |
52389 | 52389 | 2020-04-12 | Pike | Mississippi | 28113 | 54 | 1 |
55071 | 55071 | 2020-04-13 | Pike | Mississippi | 28113 | 59 | 1 |
57769 | 57769 | 2020-04-14 | Pike | Mississippi | 28113 | 62 | 1 |
60480 | 60480 | 2020-04-15 | Pike | Mississippi | 28113 | 72 | 2 |
63202 | 63202 | 2020-04-16 | Pike | Mississippi | 28113 | 82 | 2 |
65942 | 65942 | 2020-04-17 | Pike | Mississippi | 28113 | 93 | 2 |
68694 | 68694 | 2020-04-18 | Pike | Mississippi | 28113 | 97 | 2 |
71460 | 71460 | 2020-04-19 | Pike | Mississippi | 28113 | 104 | 2 |
74233 | 74233 | 2020-04-20 | Pike | Mississippi | 28113 | 115 | 2 |
77014 | 77014 | 2020-04-21 | Pike | Mississippi | 28113 | 118 | 3 |
79799 | 79799 | 2020-04-22 | Pike | Mississippi | 28113 | 118 | 3 |
82595 | 82595 | 2020-04-23 | Pike | Mississippi | 28113 | 126 | 3 |
85399 | 85399 | 2020-04-24 | Pike | Mississippi | 28113 | 127 | 4 |
88209 | 88209 | 2020-04-25 | Pike | Mississippi | 28113 | 133 | 5 |
91025 | 91025 | 2020-04-26 | Pike | Mississippi | 28113 | 136 | 5 |
93846 | 93846 | 2020-04-27 | Pike | Mississippi | 28113 | 136 | 5 |
96682 | 96682 | 2020-04-28 | Pike | Mississippi | 28113 | 142 | 7 |
99528 | 99528 | 2020-04-29 | Pike | Mississippi | 28113 | 143 | 7 |
102380 | 102380 | 2020-04-30 | Pike | Mississippi | 28113 | 148 | 7 |
105241 | 105241 | 2020-05-01 | Pike | Mississippi | 28113 | 149 | 7 |
108106 | 108106 | 2020-05-02 | Pike | Mississippi | 28113 | 153 | 7 |
110977 | 110977 | 2020-05-03 | Pike | Mississippi | 28113 | 155 | 7 |
113856 | 113856 | 2020-05-04 | Pike | Mississippi | 28113 | 155 | 7 |
116738 | 116738 | 2020-05-05 | Pike | Mississippi | 28113 | 160 | 9 |
119698 | 119698 | 2020-05-06 | Pike | Mississippi | 28113 | 159 | 9 |
122672 | 122672 | 2020-05-07 | Pike | Mississippi | 28113 | 162 | 9 |
125654 | 125654 | 2020-05-08 | Pike | Mississippi | 28113 | 163 | 10 |
128641 | 128641 | 2020-05-09 | Pike | Mississippi | 28113 | 168 | 10 |
131631 | 131631 | 2020-05-10 | Pike | Mississippi | 28113 | 168 | 10 |
134622 | 134622 | 2020-05-11 | Pike | Mississippi | 28113 | 170 | 10 |
137612 | 137612 | 2020-05-12 | Pike | Mississippi | 28113 | 173 | 10 |
140606 | 140606 | 2020-05-13 | Pike | Mississippi | 28113 | 173 | 10 |
143601 | 143601 | 2020-05-14 | Pike | Mississippi | 28113 | 173 | 10 |
146601 | 146601 | 2020-05-15 | Pike | Mississippi | 28113 | 174 | 10 |
149606 | 149606 | 2020-05-16 | Pike | Mississippi | 28113 | 176 | 11 |
152617 | 152617 | 2020-05-17 | Pike | Mississippi | 28113 | 176 | 11 |
155631 | 155631 | 2020-05-18 | Pike | Mississippi | 28113 | 178 | 11 |
158649 | 158649 | 2020-05-19 | Pike | Mississippi | 28113 | 184 | 11 |
161675 | 161675 | 2020-05-20 | Pike | Mississippi | 28113 | 186 | 11 |
164704 | 164704 | 2020-05-21 | Pike | Mississippi | 28113 | 188 | 11 |
167740 | 167740 | 2020-05-22 | Pike | Mississippi | 28113 | 190 | 11 |
170778 | 170778 | 2020-05-23 | Pike | Mississippi | 28113 | 194 | 11 |
173820 | 173820 | 2020-05-24 | Pike | Mississippi | 28113 | 196 | 11 |
176863 | 176863 | 2020-05-25 | Pike | Mississippi | 28113 | 200 | 11 |
179907 | 179907 | 2020-05-26 | Pike | Mississippi | 28113 | 201 | 11 |
182953 | 182953 | 2020-05-27 | Pike | Mississippi | 28113 | 202 | 11 |
186009 | 186009 | 2020-05-28 | Pike | Mississippi | 28113 | 203 | 11 |
189067 | 189067 | 2020-05-29 | Pike | Mississippi | 28113 | 202 | 11 |
192131 | 192131 | 2020-05-30 | Pike | Mississippi | 28113 | 202 | 11 |
195199 | 195199 | 2020-05-31 | Pike | Mississippi | 28113 | 203 | 11 |
198270 | 198270 | 2020-06-01 | Pike | Mississippi | 28113 | 203 | 11 |
201343 | 201343 | 2020-06-02 | Pike | Mississippi | 28113 | 204 | 11 |
204420 | 204420 | 2020-06-03 | Pike | Mississippi | 28113 | 205 | 11 |
207501 | 207501 | 2020-06-04 | Pike | Mississippi | 28113 | 204 | 11 |
210582 | 210582 | 2020-06-05 | Pike | Mississippi | 28113 | 204 | 11 |
213666 | 213666 | 2020-06-06 | Pike | Mississippi | 28113 | 204 | 11 |
216754 | 216754 | 2020-06-07 | Pike | Mississippi | 28113 | 207 | 11 |
219846 | 219846 | 2020-06-08 | Pike | Mississippi | 28113 | 211 | 11 |
222941 | 222941 | 2020-06-09 | Pike | Mississippi | 28113 | 211 | 11 |
226039 | 226039 | 2020-06-10 | Pike | Mississippi | 28113 | 213 | 11 |
229141 | 229141 | 2020-06-11 | Pike | Mississippi | 28113 | 213 | 11 |
232245 | 232245 | 2020-06-12 | Pike | Mississippi | 28113 | 220 | 11 |
235351 | 235351 | 2020-06-13 | Pike | Mississippi | 28113 | 224 | 11 |
238458 | 238458 | 2020-06-14 | Pike | Mississippi | 28113 | 226 | 11 |
241567 | 241567 | 2020-06-15 | Pike | Mississippi | 28113 | 244 | 11 |
244678 | 244678 | 2020-06-16 | Pike | Mississippi | 28113 | 247 | 11 |
247791 | 247791 | 2020-06-17 | Pike | Mississippi | 28113 | 248 | 11 |
250903 | 250903 | 2020-06-18 | Pike | Mississippi | 28113 | 248 | 11 |
254018 | 254018 | 2020-06-19 | Pike | Mississippi | 28113 | 248 | 11 |
257138 | 257138 | 2020-06-20 | Pike | Mississippi | 28113 | 248 | 11 |
260264 | 260264 | 2020-06-21 | Pike | Mississippi | 28113 | 248 | 11 |
263393 | 263393 | 2020-06-22 | Pike | Mississippi | 28113 | 278 | 11 |
266519 | 266519 | 2020-06-23 | Pike | Mississippi | 28113 | 289 | 11 |
269652 | 269652 | 2020-06-24 | Pike | Mississippi | 28113 | 298 | 11 |
272790 | 272790 | 2020-06-25 | Pike | Mississippi | 28113 | 321 | 11 |
275933 | 275933 | 2020-06-26 | Pike | Mississippi | 28113 | 328 | 11 |
279081 | 279081 | 2020-06-27 | Pike | Mississippi | 28113 | 331 | 11 |
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);