ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,556 rows where county = "Panola" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
6605 | 6605 | 2020-03-21 | Panola | Mississippi | 28107 | 1 | 0 |
7690 | 7690 | 2020-03-22 | Panola | Mississippi | 28107 | 2 | 0 |
8872 | 8872 | 2020-03-23 | Panola | Mississippi | 28107 | 2 | 0 |
10170 | 10170 | 2020-03-24 | Panola | Mississippi | 28107 | 2 | 0 |
11590 | 11590 | 2020-03-25 | Panola | Mississippi | 28107 | 2 | 0 |
13183 | 13183 | 2020-03-26 | Panola | Mississippi | 28107 | 4 | 0 |
14902 | 14902 | 2020-03-27 | Panola | Mississippi | 28107 | 4 | 0 |
16726 | 16726 | 2020-03-28 | Panola | Mississippi | 28107 | 4 | 0 |
18648 | 18648 | 2020-03-29 | Panola | Mississippi | 28107 | 5 | 0 |
20672 | 20672 | 2020-03-30 | Panola | Mississippi | 28107 | 6 | 0 |
22789 | 22789 | 2020-03-31 | Panola | Mississippi | 28107 | 7 | 1 |
24973 | 24973 | 2020-04-01 | Panola | Mississippi | 28107 | 8 | 1 |
27227 | 27227 | 2020-04-02 | Panola | Mississippi | 28107 | 8 | 1 |
29546 | 29546 | 2020-04-03 | Panola | Mississippi | 28107 | 8 | 1 |
31926 | 31926 | 2020-04-04 | Panola | Mississippi | 28107 | 10 | 1 |
34353 | 34353 | 2020-04-05 | Panola | Mississippi | 28107 | 17 | 1 |
36816 | 36816 | 2020-04-06 | Panola | Mississippi | 28107 | 17 | 1 |
39327 | 39327 | 2020-04-07 | Panola | Mississippi | 28107 | 19 | 1 |
41881 | 41881 | 2020-04-08 | Panola | Mississippi | 28107 | 19 | 1 |
44458 | 44458 | 2020-04-09 | Panola | Mississippi | 28107 | 21 | 1 |
47067 | 47067 | 2020-04-10 | Panola | Mississippi | 28107 | 22 | 1 |
49713 | 49713 | 2020-04-11 | Panola | Mississippi | 28107 | 22 | 2 |
52386 | 52386 | 2020-04-12 | Panola | Mississippi | 28107 | 22 | 2 |
55068 | 55068 | 2020-04-13 | Panola | Mississippi | 28107 | 23 | 2 |
57766 | 57766 | 2020-04-14 | Panola | Mississippi | 28107 | 26 | 2 |
60477 | 60477 | 2020-04-15 | Panola | Mississippi | 28107 | 26 | 2 |
63199 | 63199 | 2020-04-16 | Panola | Mississippi | 28107 | 27 | 2 |
65939 | 65939 | 2020-04-17 | Panola | Mississippi | 28107 | 27 | 2 |
68691 | 68691 | 2020-04-18 | Panola | Mississippi | 28107 | 30 | 2 |
71457 | 71457 | 2020-04-19 | Panola | Mississippi | 28107 | 35 | 2 |
74230 | 74230 | 2020-04-20 | Panola | Mississippi | 28107 | 36 | 2 |
77011 | 77011 | 2020-04-21 | Panola | Mississippi | 28107 | 37 | 2 |
79796 | 79796 | 2020-04-22 | Panola | Mississippi | 28107 | 37 | 2 |
82592 | 82592 | 2020-04-23 | Panola | Mississippi | 28107 | 38 | 2 |
85396 | 85396 | 2020-04-24 | Panola | Mississippi | 28107 | 38 | 2 |
88206 | 88206 | 2020-04-25 | Panola | Mississippi | 28107 | 36 | 2 |
91022 | 91022 | 2020-04-26 | Panola | Mississippi | 28107 | 37 | 2 |
93843 | 93843 | 2020-04-27 | Panola | Mississippi | 28107 | 38 | 2 |
96679 | 96679 | 2020-04-28 | Panola | Mississippi | 28107 | 38 | 2 |
99525 | 99525 | 2020-04-29 | Panola | Mississippi | 28107 | 38 | 2 |
102377 | 102377 | 2020-04-30 | Panola | Mississippi | 28107 | 39 | 2 |
105238 | 105238 | 2020-05-01 | Panola | Mississippi | 28107 | 39 | 2 |
108103 | 108103 | 2020-05-02 | Panola | Mississippi | 28107 | 39 | 2 |
110974 | 110974 | 2020-05-03 | Panola | Mississippi | 28107 | 40 | 2 |
113853 | 113853 | 2020-05-04 | Panola | Mississippi | 28107 | 40 | 2 |
116735 | 116735 | 2020-05-05 | Panola | Mississippi | 28107 | 40 | 2 |
119695 | 119695 | 2020-05-06 | Panola | Mississippi | 28107 | 42 | 2 |
122669 | 122669 | 2020-05-07 | Panola | Mississippi | 28107 | 43 | 2 |
125651 | 125651 | 2020-05-08 | Panola | Mississippi | 28107 | 43 | 2 |
128638 | 128638 | 2020-05-09 | Panola | Mississippi | 28107 | 43 | 2 |
131628 | 131628 | 2020-05-10 | Panola | Mississippi | 28107 | 43 | 2 |
134619 | 134619 | 2020-05-11 | Panola | Mississippi | 28107 | 43 | 2 |
137609 | 137609 | 2020-05-12 | Panola | Mississippi | 28107 | 45 | 2 |
140603 | 140603 | 2020-05-13 | Panola | Mississippi | 28107 | 45 | 2 |
143598 | 143598 | 2020-05-14 | Panola | Mississippi | 28107 | 46 | 2 |
146598 | 146598 | 2020-05-15 | Panola | Mississippi | 28107 | 47 | 2 |
149603 | 149603 | 2020-05-16 | Panola | Mississippi | 28107 | 50 | 2 |
152614 | 152614 | 2020-05-17 | Panola | Mississippi | 28107 | 50 | 2 |
155628 | 155628 | 2020-05-18 | Panola | Mississippi | 28107 | 50 | 2 |
158646 | 158646 | 2020-05-19 | Panola | Mississippi | 28107 | 52 | 2 |
161672 | 161672 | 2020-05-20 | Panola | Mississippi | 28107 | 54 | 2 |
164701 | 164701 | 2020-05-21 | Panola | Mississippi | 28107 | 58 | 2 |
167737 | 167737 | 2020-05-22 | Panola | Mississippi | 28107 | 59 | 2 |
170775 | 170775 | 2020-05-23 | Panola | Mississippi | 28107 | 61 | 2 |
173817 | 173817 | 2020-05-24 | Panola | Mississippi | 28107 | 62 | 2 |
176860 | 176860 | 2020-05-25 | Panola | Mississippi | 28107 | 62 | 2 |
179904 | 179904 | 2020-05-26 | Panola | Mississippi | 28107 | 64 | 2 |
182950 | 182950 | 2020-05-27 | Panola | Mississippi | 28107 | 64 | 3 |
186006 | 186006 | 2020-05-28 | Panola | Mississippi | 28107 | 64 | 3 |
189064 | 189064 | 2020-05-29 | Panola | Mississippi | 28107 | 66 | 3 |
192128 | 192128 | 2020-05-30 | Panola | Mississippi | 28107 | 70 | 3 |
195196 | 195196 | 2020-05-31 | Panola | Mississippi | 28107 | 71 | 3 |
198267 | 198267 | 2020-06-01 | Panola | Mississippi | 28107 | 71 | 3 |
201340 | 201340 | 2020-06-02 | Panola | Mississippi | 28107 | 84 | 3 |
204417 | 204417 | 2020-06-03 | Panola | Mississippi | 28107 | 85 | 3 |
207498 | 207498 | 2020-06-04 | Panola | Mississippi | 28107 | 84 | 3 |
210579 | 210579 | 2020-06-05 | Panola | Mississippi | 28107 | 87 | 3 |
213663 | 213663 | 2020-06-06 | Panola | Mississippi | 28107 | 93 | 3 |
216751 | 216751 | 2020-06-07 | Panola | Mississippi | 28107 | 96 | 3 |
219843 | 219843 | 2020-06-08 | Panola | Mississippi | 28107 | 102 | 3 |
222938 | 222938 | 2020-06-09 | Panola | Mississippi | 28107 | 105 | 3 |
226036 | 226036 | 2020-06-10 | Panola | Mississippi | 28107 | 110 | 3 |
229138 | 229138 | 2020-06-11 | Panola | Mississippi | 28107 | 110 | 3 |
232242 | 232242 | 2020-06-12 | Panola | Mississippi | 28107 | 118 | 3 |
235348 | 235348 | 2020-06-13 | Panola | Mississippi | 28107 | 121 | 3 |
238455 | 238455 | 2020-06-14 | Panola | Mississippi | 28107 | 122 | 3 |
241564 | 241564 | 2020-06-15 | Panola | Mississippi | 28107 | 127 | 4 |
244675 | 244675 | 2020-06-16 | Panola | Mississippi | 28107 | 137 | 4 |
247788 | 247788 | 2020-06-17 | Panola | Mississippi | 28107 | 146 | 4 |
250900 | 250900 | 2020-06-18 | Panola | Mississippi | 28107 | 146 | 4 |
254015 | 254015 | 2020-06-19 | Panola | Mississippi | 28107 | 146 | 4 |
257135 | 257135 | 2020-06-20 | Panola | Mississippi | 28107 | 146 | 4 |
260261 | 260261 | 2020-06-21 | Panola | Mississippi | 28107 | 146 | 4 |
263390 | 263390 | 2020-06-22 | Panola | Mississippi | 28107 | 179 | 5 |
266516 | 266516 | 2020-06-23 | Panola | Mississippi | 28107 | 190 | 5 |
269649 | 269649 | 2020-06-24 | Panola | Mississippi | 28107 | 204 | 5 |
272787 | 272787 | 2020-06-25 | Panola | Mississippi | 28107 | 221 | 5 |
275930 | 275930 | 2020-06-26 | Panola | Mississippi | 28107 | 227 | 5 |
279078 | 279078 | 2020-06-27 | Panola | Mississippi | 28107 | 237 | 6 |
282226 | 282226 | 2020-06-28 | Panola | Mississippi | 28107 | 240 | 6 |
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);