ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Pontotoc" and state = "Mississippi" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
7694 | 7694 | 2020-03-22 | Pontotoc | Mississippi | 28115 | 1 | 0 |
8876 | 8876 | 2020-03-23 | Pontotoc | Mississippi | 28115 | 1 | 0 |
10174 | 10174 | 2020-03-24 | Pontotoc | Mississippi | 28115 | 2 | 0 |
11594 | 11594 | 2020-03-25 | Pontotoc | Mississippi | 28115 | 2 | 0 |
13187 | 13187 | 2020-03-26 | Pontotoc | Mississippi | 28115 | 3 | 0 |
14906 | 14906 | 2020-03-27 | Pontotoc | Mississippi | 28115 | 4 | 0 |
16730 | 16730 | 2020-03-28 | Pontotoc | Mississippi | 28115 | 4 | 0 |
18652 | 18652 | 2020-03-29 | Pontotoc | Mississippi | 28115 | 4 | 0 |
20676 | 20676 | 2020-03-30 | Pontotoc | Mississippi | 28115 | 5 | 0 |
22793 | 22793 | 2020-03-31 | Pontotoc | Mississippi | 28115 | 5 | 0 |
24977 | 24977 | 2020-04-01 | Pontotoc | Mississippi | 28115 | 6 | 0 |
27231 | 27231 | 2020-04-02 | Pontotoc | Mississippi | 28115 | 10 | 0 |
29550 | 29550 | 2020-04-03 | Pontotoc | Mississippi | 28115 | 11 | 1 |
31930 | 31930 | 2020-04-04 | Pontotoc | Mississippi | 28115 | 12 | 1 |
34357 | 34357 | 2020-04-05 | Pontotoc | Mississippi | 28115 | 12 | 1 |
36820 | 36820 | 2020-04-06 | Pontotoc | Mississippi | 28115 | 12 | 1 |
39331 | 39331 | 2020-04-07 | Pontotoc | Mississippi | 28115 | 12 | 1 |
41885 | 41885 | 2020-04-08 | Pontotoc | Mississippi | 28115 | 13 | 1 |
44462 | 44462 | 2020-04-09 | Pontotoc | Mississippi | 28115 | 14 | 1 |
47071 | 47071 | 2020-04-10 | Pontotoc | Mississippi | 28115 | 14 | 1 |
49717 | 49717 | 2020-04-11 | Pontotoc | Mississippi | 28115 | 14 | 1 |
52390 | 52390 | 2020-04-12 | Pontotoc | Mississippi | 28115 | 15 | 1 |
55072 | 55072 | 2020-04-13 | Pontotoc | Mississippi | 28115 | 15 | 1 |
57770 | 57770 | 2020-04-14 | Pontotoc | Mississippi | 28115 | 15 | 2 |
60481 | 60481 | 2020-04-15 | Pontotoc | Mississippi | 28115 | 15 | 2 |
63203 | 63203 | 2020-04-16 | Pontotoc | Mississippi | 28115 | 16 | 2 |
65943 | 65943 | 2020-04-17 | Pontotoc | Mississippi | 28115 | 17 | 2 |
68695 | 68695 | 2020-04-18 | Pontotoc | Mississippi | 28115 | 17 | 2 |
71461 | 71461 | 2020-04-19 | Pontotoc | Mississippi | 28115 | 18 | 2 |
74234 | 74234 | 2020-04-20 | Pontotoc | Mississippi | 28115 | 18 | 2 |
77015 | 77015 | 2020-04-21 | Pontotoc | Mississippi | 28115 | 18 | 2 |
79800 | 79800 | 2020-04-22 | Pontotoc | Mississippi | 28115 | 18 | 2 |
82596 | 82596 | 2020-04-23 | Pontotoc | Mississippi | 28115 | 18 | 2 |
85400 | 85400 | 2020-04-24 | Pontotoc | Mississippi | 28115 | 18 | 2 |
88210 | 88210 | 2020-04-25 | Pontotoc | Mississippi | 28115 | 18 | 2 |
91026 | 91026 | 2020-04-26 | Pontotoc | Mississippi | 28115 | 18 | 2 |
93847 | 93847 | 2020-04-27 | Pontotoc | Mississippi | 28115 | 18 | 2 |
96683 | 96683 | 2020-04-28 | Pontotoc | Mississippi | 28115 | 18 | 2 |
99529 | 99529 | 2020-04-29 | Pontotoc | Mississippi | 28115 | 18 | 2 |
102381 | 102381 | 2020-04-30 | Pontotoc | Mississippi | 28115 | 18 | 2 |
105242 | 105242 | 2020-05-01 | Pontotoc | Mississippi | 28115 | 18 | 2 |
108107 | 108107 | 2020-05-02 | Pontotoc | Mississippi | 28115 | 20 | 2 |
110978 | 110978 | 2020-05-03 | Pontotoc | Mississippi | 28115 | 22 | 2 |
113857 | 113857 | 2020-05-04 | Pontotoc | Mississippi | 28115 | 22 | 2 |
116739 | 116739 | 2020-05-05 | Pontotoc | Mississippi | 28115 | 22 | 2 |
119699 | 119699 | 2020-05-06 | Pontotoc | Mississippi | 28115 | 22 | 2 |
122673 | 122673 | 2020-05-07 | Pontotoc | Mississippi | 28115 | 22 | 2 |
125655 | 125655 | 2020-05-08 | Pontotoc | Mississippi | 28115 | 22 | 2 |
128642 | 128642 | 2020-05-09 | Pontotoc | Mississippi | 28115 | 24 | 2 |
131632 | 131632 | 2020-05-10 | Pontotoc | Mississippi | 28115 | 24 | 2 |
134623 | 134623 | 2020-05-11 | Pontotoc | Mississippi | 28115 | 23 | 2 |
137613 | 137613 | 2020-05-12 | Pontotoc | Mississippi | 28115 | 23 | 2 |
140607 | 140607 | 2020-05-13 | Pontotoc | Mississippi | 28115 | 24 | 2 |
143602 | 143602 | 2020-05-14 | Pontotoc | Mississippi | 28115 | 25 | 2 |
146602 | 146602 | 2020-05-15 | Pontotoc | Mississippi | 28115 | 25 | 2 |
149607 | 149607 | 2020-05-16 | Pontotoc | Mississippi | 28115 | 25 | 2 |
152618 | 152618 | 2020-05-17 | Pontotoc | Mississippi | 28115 | 25 | 2 |
155632 | 155632 | 2020-05-18 | Pontotoc | Mississippi | 28115 | 25 | 2 |
158650 | 158650 | 2020-05-19 | Pontotoc | Mississippi | 28115 | 25 | 2 |
161676 | 161676 | 2020-05-20 | Pontotoc | Mississippi | 28115 | 26 | 2 |
164705 | 164705 | 2020-05-21 | Pontotoc | Mississippi | 28115 | 26 | 2 |
167741 | 167741 | 2020-05-22 | Pontotoc | Mississippi | 28115 | 26 | 2 |
170779 | 170779 | 2020-05-23 | Pontotoc | Mississippi | 28115 | 26 | 3 |
173821 | 173821 | 2020-05-24 | Pontotoc | Mississippi | 28115 | 25 | 3 |
176864 | 176864 | 2020-05-25 | Pontotoc | Mississippi | 28115 | 26 | 3 |
179908 | 179908 | 2020-05-26 | Pontotoc | Mississippi | 28115 | 26 | 3 |
182954 | 182954 | 2020-05-27 | Pontotoc | Mississippi | 28115 | 28 | 3 |
186010 | 186010 | 2020-05-28 | Pontotoc | Mississippi | 28115 | 29 | 3 |
189068 | 189068 | 2020-05-29 | Pontotoc | Mississippi | 28115 | 29 | 3 |
192132 | 192132 | 2020-05-30 | Pontotoc | Mississippi | 28115 | 32 | 3 |
195200 | 195200 | 2020-05-31 | Pontotoc | Mississippi | 28115 | 35 | 3 |
198271 | 198271 | 2020-06-01 | Pontotoc | Mississippi | 28115 | 36 | 3 |
201344 | 201344 | 2020-06-02 | Pontotoc | Mississippi | 28115 | 43 | 3 |
204421 | 204421 | 2020-06-03 | Pontotoc | Mississippi | 28115 | 45 | 3 |
207502 | 207502 | 2020-06-04 | Pontotoc | Mississippi | 28115 | 47 | 3 |
210583 | 210583 | 2020-06-05 | Pontotoc | Mississippi | 28115 | 49 | 3 |
213667 | 213667 | 2020-06-06 | Pontotoc | Mississippi | 28115 | 52 | 3 |
216755 | 216755 | 2020-06-07 | Pontotoc | Mississippi | 28115 | 55 | 3 |
219847 | 219847 | 2020-06-08 | Pontotoc | Mississippi | 28115 | 60 | 3 |
222942 | 222942 | 2020-06-09 | Pontotoc | Mississippi | 28115 | 62 | 3 |
226040 | 226040 | 2020-06-10 | Pontotoc | Mississippi | 28115 | 64 | 3 |
229142 | 229142 | 2020-06-11 | Pontotoc | Mississippi | 28115 | 64 | 3 |
232246 | 232246 | 2020-06-12 | Pontotoc | Mississippi | 28115 | 70 | 3 |
235352 | 235352 | 2020-06-13 | Pontotoc | Mississippi | 28115 | 71 | 3 |
238459 | 238459 | 2020-06-14 | Pontotoc | Mississippi | 28115 | 74 | 3 |
241568 | 241568 | 2020-06-15 | Pontotoc | Mississippi | 28115 | 77 | 3 |
244679 | 244679 | 2020-06-16 | Pontotoc | Mississippi | 28115 | 79 | 3 |
247792 | 247792 | 2020-06-17 | Pontotoc | Mississippi | 28115 | 93 | 3 |
250904 | 250904 | 2020-06-18 | Pontotoc | Mississippi | 28115 | 93 | 3 |
254019 | 254019 | 2020-06-19 | Pontotoc | Mississippi | 28115 | 93 | 3 |
257139 | 257139 | 2020-06-20 | Pontotoc | Mississippi | 28115 | 93 | 3 |
260265 | 260265 | 2020-06-21 | Pontotoc | Mississippi | 28115 | 93 | 3 |
263394 | 263394 | 2020-06-22 | Pontotoc | Mississippi | 28115 | 128 | 3 |
266520 | 266520 | 2020-06-23 | Pontotoc | Mississippi | 28115 | 146 | 3 |
269653 | 269653 | 2020-06-24 | Pontotoc | Mississippi | 28115 | 156 | 3 |
272791 | 272791 | 2020-06-25 | Pontotoc | Mississippi | 28115 | 175 | 3 |
275934 | 275934 | 2020-06-26 | Pontotoc | Mississippi | 28115 | 189 | 3 |
279082 | 279082 | 2020-06-27 | Pontotoc | Mississippi | 28115 | 194 | 3 |
282230 | 282230 | 2020-06-28 | Pontotoc | Mississippi | 28115 | 202 | 3 |
285375 | 285375 | 2020-06-29 | Pontotoc | Mississippi | 28115 | 203 | 3 |
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);