ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Prentiss" and state = "Mississippi" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
11595 | 11595 | 2020-03-25 | Prentiss | Mississippi | 28117 | 1 | 0 |
13188 | 13188 | 2020-03-26 | Prentiss | Mississippi | 28117 | 1 | 0 |
14907 | 14907 | 2020-03-27 | Prentiss | Mississippi | 28117 | 1 | 0 |
16731 | 16731 | 2020-03-28 | Prentiss | Mississippi | 28117 | 2 | 0 |
18653 | 18653 | 2020-03-29 | Prentiss | Mississippi | 28117 | 4 | 0 |
20677 | 20677 | 2020-03-30 | Prentiss | Mississippi | 28117 | 4 | 0 |
22794 | 22794 | 2020-03-31 | Prentiss | Mississippi | 28117 | 4 | 0 |
24978 | 24978 | 2020-04-01 | Prentiss | Mississippi | 28117 | 4 | 0 |
27232 | 27232 | 2020-04-02 | Prentiss | Mississippi | 28117 | 4 | 0 |
29551 | 29551 | 2020-04-03 | Prentiss | Mississippi | 28117 | 9 | 0 |
31931 | 31931 | 2020-04-04 | Prentiss | Mississippi | 28117 | 9 | 0 |
34358 | 34358 | 2020-04-05 | Prentiss | Mississippi | 28117 | 9 | 0 |
36821 | 36821 | 2020-04-06 | Prentiss | Mississippi | 28117 | 10 | 0 |
39332 | 39332 | 2020-04-07 | Prentiss | Mississippi | 28117 | 10 | 0 |
41886 | 41886 | 2020-04-08 | Prentiss | Mississippi | 28117 | 10 | 0 |
44463 | 44463 | 2020-04-09 | Prentiss | Mississippi | 28117 | 10 | 0 |
47072 | 47072 | 2020-04-10 | Prentiss | Mississippi | 28117 | 12 | 0 |
49718 | 49718 | 2020-04-11 | Prentiss | Mississippi | 28117 | 12 | 0 |
52391 | 52391 | 2020-04-12 | Prentiss | Mississippi | 28117 | 13 | 0 |
55073 | 55073 | 2020-04-13 | Prentiss | Mississippi | 28117 | 14 | 0 |
57771 | 57771 | 2020-04-14 | Prentiss | Mississippi | 28117 | 14 | 0 |
60482 | 60482 | 2020-04-15 | Prentiss | Mississippi | 28117 | 15 | 0 |
63204 | 63204 | 2020-04-16 | Prentiss | Mississippi | 28117 | 15 | 0 |
65944 | 65944 | 2020-04-17 | Prentiss | Mississippi | 28117 | 16 | 0 |
68696 | 68696 | 2020-04-18 | Prentiss | Mississippi | 28117 | 16 | 0 |
71462 | 71462 | 2020-04-19 | Prentiss | Mississippi | 28117 | 19 | 0 |
74235 | 74235 | 2020-04-20 | Prentiss | Mississippi | 28117 | 25 | 0 |
77016 | 77016 | 2020-04-21 | Prentiss | Mississippi | 28117 | 27 | 0 |
79801 | 79801 | 2020-04-22 | Prentiss | Mississippi | 28117 | 28 | 0 |
82597 | 82597 | 2020-04-23 | Prentiss | Mississippi | 28117 | 29 | 0 |
85401 | 85401 | 2020-04-24 | Prentiss | Mississippi | 28117 | 29 | 0 |
88211 | 88211 | 2020-04-25 | Prentiss | Mississippi | 28117 | 29 | 1 |
91027 | 91027 | 2020-04-26 | Prentiss | Mississippi | 28117 | 30 | 1 |
93848 | 93848 | 2020-04-27 | Prentiss | Mississippi | 28117 | 32 | 1 |
96684 | 96684 | 2020-04-28 | Prentiss | Mississippi | 28117 | 31 | 1 |
99530 | 99530 | 2020-04-29 | Prentiss | Mississippi | 28117 | 32 | 1 |
102382 | 102382 | 2020-04-30 | Prentiss | Mississippi | 28117 | 32 | 1 |
105243 | 105243 | 2020-05-01 | Prentiss | Mississippi | 28117 | 32 | 1 |
108108 | 108108 | 2020-05-02 | Prentiss | Mississippi | 28117 | 32 | 1 |
110979 | 110979 | 2020-05-03 | Prentiss | Mississippi | 28117 | 32 | 1 |
113858 | 113858 | 2020-05-04 | Prentiss | Mississippi | 28117 | 32 | 1 |
116740 | 116740 | 2020-05-05 | Prentiss | Mississippi | 28117 | 33 | 1 |
119700 | 119700 | 2020-05-06 | Prentiss | Mississippi | 28117 | 33 | 2 |
122674 | 122674 | 2020-05-07 | Prentiss | Mississippi | 28117 | 33 | 2 |
125656 | 125656 | 2020-05-08 | Prentiss | Mississippi | 28117 | 33 | 2 |
128643 | 128643 | 2020-05-09 | Prentiss | Mississippi | 28117 | 35 | 2 |
131633 | 131633 | 2020-05-10 | Prentiss | Mississippi | 28117 | 36 | 2 |
134624 | 134624 | 2020-05-11 | Prentiss | Mississippi | 28117 | 36 | 2 |
137614 | 137614 | 2020-05-12 | Prentiss | Mississippi | 28117 | 36 | 2 |
140608 | 140608 | 2020-05-13 | Prentiss | Mississippi | 28117 | 36 | 2 |
143603 | 143603 | 2020-05-14 | Prentiss | Mississippi | 28117 | 36 | 2 |
146603 | 146603 | 2020-05-15 | Prentiss | Mississippi | 28117 | 36 | 2 |
149608 | 149608 | 2020-05-16 | Prentiss | Mississippi | 28117 | 36 | 3 |
152619 | 152619 | 2020-05-17 | Prentiss | Mississippi | 28117 | 36 | 3 |
155633 | 155633 | 2020-05-18 | Prentiss | Mississippi | 28117 | 36 | 3 |
158651 | 158651 | 2020-05-19 | Prentiss | Mississippi | 28117 | 36 | 3 |
161677 | 161677 | 2020-05-20 | Prentiss | Mississippi | 28117 | 36 | 3 |
164706 | 164706 | 2020-05-21 | Prentiss | Mississippi | 28117 | 37 | 3 |
167742 | 167742 | 2020-05-22 | Prentiss | Mississippi | 28117 | 37 | 3 |
170780 | 170780 | 2020-05-23 | Prentiss | Mississippi | 28117 | 37 | 3 |
173822 | 173822 | 2020-05-24 | Prentiss | Mississippi | 28117 | 38 | 3 |
176865 | 176865 | 2020-05-25 | Prentiss | Mississippi | 28117 | 39 | 3 |
179909 | 179909 | 2020-05-26 | Prentiss | Mississippi | 28117 | 40 | 3 |
182955 | 182955 | 2020-05-27 | Prentiss | Mississippi | 28117 | 41 | 3 |
186011 | 186011 | 2020-05-28 | Prentiss | Mississippi | 28117 | 42 | 3 |
189069 | 189069 | 2020-05-29 | Prentiss | Mississippi | 28117 | 51 | 3 |
192133 | 192133 | 2020-05-30 | Prentiss | Mississippi | 28117 | 52 | 3 |
195201 | 195201 | 2020-05-31 | Prentiss | Mississippi | 28117 | 53 | 3 |
198272 | 198272 | 2020-06-01 | Prentiss | Mississippi | 28117 | 56 | 3 |
201345 | 201345 | 2020-06-02 | Prentiss | Mississippi | 28117 | 51 | 3 |
204422 | 204422 | 2020-06-03 | Prentiss | Mississippi | 28117 | 53 | 3 |
207503 | 207503 | 2020-06-04 | Prentiss | Mississippi | 28117 | 53 | 3 |
210584 | 210584 | 2020-06-05 | Prentiss | Mississippi | 28117 | 53 | 3 |
213668 | 213668 | 2020-06-06 | Prentiss | Mississippi | 28117 | 55 | 3 |
216756 | 216756 | 2020-06-07 | Prentiss | Mississippi | 28117 | 56 | 3 |
219848 | 219848 | 2020-06-08 | Prentiss | Mississippi | 28117 | 57 | 3 |
222943 | 222943 | 2020-06-09 | Prentiss | Mississippi | 28117 | 62 | 3 |
226041 | 226041 | 2020-06-10 | Prentiss | Mississippi | 28117 | 63 | 3 |
229143 | 229143 | 2020-06-11 | Prentiss | Mississippi | 28117 | 63 | 3 |
232247 | 232247 | 2020-06-12 | Prentiss | Mississippi | 28117 | 65 | 3 |
235353 | 235353 | 2020-06-13 | Prentiss | Mississippi | 28117 | 65 | 3 |
238460 | 238460 | 2020-06-14 | Prentiss | Mississippi | 28117 | 66 | 3 |
241569 | 241569 | 2020-06-15 | Prentiss | Mississippi | 28117 | 66 | 3 |
244680 | 244680 | 2020-06-16 | Prentiss | Mississippi | 28117 | 68 | 3 |
247793 | 247793 | 2020-06-17 | Prentiss | Mississippi | 28117 | 70 | 3 |
250905 | 250905 | 2020-06-18 | Prentiss | Mississippi | 28117 | 70 | 3 |
254020 | 254020 | 2020-06-19 | Prentiss | Mississippi | 28117 | 70 | 3 |
257140 | 257140 | 2020-06-20 | Prentiss | Mississippi | 28117 | 70 | 3 |
260266 | 260266 | 2020-06-21 | Prentiss | Mississippi | 28117 | 70 | 3 |
263395 | 263395 | 2020-06-22 | Prentiss | Mississippi | 28117 | 78 | 3 |
266521 | 266521 | 2020-06-23 | Prentiss | Mississippi | 28117 | 80 | 3 |
269654 | 269654 | 2020-06-24 | Prentiss | Mississippi | 28117 | 81 | 3 |
272792 | 272792 | 2020-06-25 | Prentiss | Mississippi | 28117 | 85 | 3 |
275935 | 275935 | 2020-06-26 | Prentiss | Mississippi | 28117 | 90 | 3 |
279083 | 279083 | 2020-06-27 | Prentiss | Mississippi | 28117 | 91 | 3 |
282231 | 282231 | 2020-06-28 | Prentiss | Mississippi | 28117 | 91 | 3 |
285376 | 285376 | 2020-06-29 | Prentiss | Mississippi | 28117 | 94 | 3 |
288526 | 288526 | 2020-06-30 | Prentiss | Mississippi | 28117 | 97 | 3 |
291677 | 291677 | 2020-07-01 | Prentiss | Mississippi | 28117 | 98 | 3 |
294831 | 294831 | 2020-07-02 | Prentiss | Mississippi | 28117 | 100 | 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);