ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 28101 and state = "Mississippi" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
10167 | 10167 | 2020-03-24 | Newton | Mississippi | 28101 | 1 | 0 |
11587 | 11587 | 2020-03-25 | Newton | Mississippi | 28101 | 1 | 0 |
13180 | 13180 | 2020-03-26 | Newton | Mississippi | 28101 | 1 | 0 |
14899 | 14899 | 2020-03-27 | Newton | Mississippi | 28101 | 1 | 0 |
16723 | 16723 | 2020-03-28 | Newton | Mississippi | 28101 | 1 | 0 |
18645 | 18645 | 2020-03-29 | Newton | Mississippi | 28101 | 1 | 0 |
20669 | 20669 | 2020-03-30 | Newton | Mississippi | 28101 | 2 | 0 |
22786 | 22786 | 2020-03-31 | Newton | Mississippi | 28101 | 2 | 0 |
24970 | 24970 | 2020-04-01 | Newton | Mississippi | 28101 | 2 | 0 |
27224 | 27224 | 2020-04-02 | Newton | Mississippi | 28101 | 4 | 0 |
29543 | 29543 | 2020-04-03 | Newton | Mississippi | 28101 | 4 | 0 |
31923 | 31923 | 2020-04-04 | Newton | Mississippi | 28101 | 6 | 0 |
34350 | 34350 | 2020-04-05 | Newton | Mississippi | 28101 | 7 | 0 |
36813 | 36813 | 2020-04-06 | Newton | Mississippi | 28101 | 7 | 0 |
39324 | 39324 | 2020-04-07 | Newton | Mississippi | 28101 | 7 | 0 |
41878 | 41878 | 2020-04-08 | Newton | Mississippi | 28101 | 7 | 0 |
44455 | 44455 | 2020-04-09 | Newton | Mississippi | 28101 | 8 | 0 |
47064 | 47064 | 2020-04-10 | Newton | Mississippi | 28101 | 10 | 0 |
49710 | 49710 | 2020-04-11 | Newton | Mississippi | 28101 | 12 | 0 |
52383 | 52383 | 2020-04-12 | Newton | Mississippi | 28101 | 10 | 0 |
55065 | 55065 | 2020-04-13 | Newton | Mississippi | 28101 | 10 | 0 |
57763 | 57763 | 2020-04-14 | Newton | Mississippi | 28101 | 14 | 0 |
60474 | 60474 | 2020-04-15 | Newton | Mississippi | 28101 | 14 | 0 |
63196 | 63196 | 2020-04-16 | Newton | Mississippi | 28101 | 16 | 0 |
65936 | 65936 | 2020-04-17 | Newton | Mississippi | 28101 | 19 | 0 |
68688 | 68688 | 2020-04-18 | Newton | Mississippi | 28101 | 21 | 0 |
71454 | 71454 | 2020-04-19 | Newton | Mississippi | 28101 | 26 | 0 |
74227 | 74227 | 2020-04-20 | Newton | Mississippi | 28101 | 30 | 0 |
77008 | 77008 | 2020-04-21 | Newton | Mississippi | 28101 | 32 | 0 |
79793 | 79793 | 2020-04-22 | Newton | Mississippi | 28101 | 33 | 0 |
82589 | 82589 | 2020-04-23 | Newton | Mississippi | 28101 | 45 | 0 |
85393 | 85393 | 2020-04-24 | Newton | Mississippi | 28101 | 51 | 0 |
88203 | 88203 | 2020-04-25 | Newton | Mississippi | 28101 | 58 | 0 |
91019 | 91019 | 2020-04-26 | Newton | Mississippi | 28101 | 61 | 0 |
93840 | 93840 | 2020-04-27 | Newton | Mississippi | 28101 | 64 | 0 |
96676 | 96676 | 2020-04-28 | Newton | Mississippi | 28101 | 73 | 0 |
99522 | 99522 | 2020-04-29 | Newton | Mississippi | 28101 | 78 | 0 |
102374 | 102374 | 2020-04-30 | Newton | Mississippi | 28101 | 81 | 0 |
105235 | 105235 | 2020-05-01 | Newton | Mississippi | 28101 | 87 | 0 |
108100 | 108100 | 2020-05-02 | Newton | Mississippi | 28101 | 88 | 0 |
110971 | 110971 | 2020-05-03 | Newton | Mississippi | 28101 | 93 | 0 |
113850 | 113850 | 2020-05-04 | Newton | Mississippi | 28101 | 93 | 0 |
116732 | 116732 | 2020-05-05 | Newton | Mississippi | 28101 | 106 | 0 |
119692 | 119692 | 2020-05-06 | Newton | Mississippi | 28101 | 113 | 0 |
122666 | 122666 | 2020-05-07 | Newton | Mississippi | 28101 | 121 | 0 |
125648 | 125648 | 2020-05-08 | Newton | Mississippi | 28101 | 130 | 0 |
128635 | 128635 | 2020-05-09 | Newton | Mississippi | 28101 | 137 | 1 |
131625 | 131625 | 2020-05-10 | Newton | Mississippi | 28101 | 138 | 1 |
134616 | 134616 | 2020-05-11 | Newton | Mississippi | 28101 | 142 | 1 |
137606 | 137606 | 2020-05-12 | Newton | Mississippi | 28101 | 147 | 1 |
140600 | 140600 | 2020-05-13 | Newton | Mississippi | 28101 | 155 | 1 |
143595 | 143595 | 2020-05-14 | Newton | Mississippi | 28101 | 161 | 2 |
146595 | 146595 | 2020-05-15 | Newton | Mississippi | 28101 | 172 | 2 |
149600 | 149600 | 2020-05-16 | Newton | Mississippi | 28101 | 186 | 2 |
152611 | 152611 | 2020-05-17 | Newton | Mississippi | 28101 | 187 | 2 |
155625 | 155625 | 2020-05-18 | Newton | Mississippi | 28101 | 192 | 3 |
158643 | 158643 | 2020-05-19 | Newton | Mississippi | 28101 | 196 | 3 |
161669 | 161669 | 2020-05-20 | Newton | Mississippi | 28101 | 206 | 3 |
164698 | 164698 | 2020-05-21 | Newton | Mississippi | 28101 | 210 | 3 |
167734 | 167734 | 2020-05-22 | Newton | Mississippi | 28101 | 214 | 3 |
170772 | 170772 | 2020-05-23 | Newton | Mississippi | 28101 | 221 | 3 |
173814 | 173814 | 2020-05-24 | Newton | Mississippi | 28101 | 224 | 3 |
176857 | 176857 | 2020-05-25 | Newton | Mississippi | 28101 | 227 | 3 |
179901 | 179901 | 2020-05-26 | Newton | Mississippi | 28101 | 231 | 4 |
182947 | 182947 | 2020-05-27 | Newton | Mississippi | 28101 | 250 | 4 |
186003 | 186003 | 2020-05-28 | Newton | Mississippi | 28101 | 256 | 4 |
189061 | 189061 | 2020-05-29 | Newton | Mississippi | 28101 | 263 | 4 |
192125 | 192125 | 2020-05-30 | Newton | Mississippi | 28101 | 271 | 4 |
195193 | 195193 | 2020-05-31 | Newton | Mississippi | 28101 | 270 | 4 |
198264 | 198264 | 2020-06-01 | Newton | Mississippi | 28101 | 278 | 4 |
201337 | 201337 | 2020-06-02 | Newton | Mississippi | 28101 | 282 | 4 |
204414 | 204414 | 2020-06-03 | Newton | Mississippi | 28101 | 283 | 4 |
207495 | 207495 | 2020-06-04 | Newton | Mississippi | 28101 | 288 | 4 |
210576 | 210576 | 2020-06-05 | Newton | Mississippi | 28101 | 292 | 4 |
213660 | 213660 | 2020-06-06 | Newton | Mississippi | 28101 | 297 | 4 |
216748 | 216748 | 2020-06-07 | Newton | Mississippi | 28101 | 298 | 4 |
219840 | 219840 | 2020-06-08 | Newton | Mississippi | 28101 | 301 | 5 |
222935 | 222935 | 2020-06-09 | Newton | Mississippi | 28101 | 307 | 5 |
226033 | 226033 | 2020-06-10 | Newton | Mississippi | 28101 | 313 | 6 |
229135 | 229135 | 2020-06-11 | Newton | Mississippi | 28101 | 313 | 6 |
232239 | 232239 | 2020-06-12 | Newton | Mississippi | 28101 | 320 | 6 |
235345 | 235345 | 2020-06-13 | Newton | Mississippi | 28101 | 321 | 6 |
238452 | 238452 | 2020-06-14 | Newton | Mississippi | 28101 | 321 | 6 |
241561 | 241561 | 2020-06-15 | Newton | Mississippi | 28101 | 322 | 6 |
244672 | 244672 | 2020-06-16 | Newton | Mississippi | 28101 | 324 | 7 |
247785 | 247785 | 2020-06-17 | Newton | Mississippi | 28101 | 325 | 8 |
250897 | 250897 | 2020-06-18 | Newton | Mississippi | 28101 | 325 | 8 |
254012 | 254012 | 2020-06-19 | Newton | Mississippi | 28101 | 325 | 8 |
257132 | 257132 | 2020-06-20 | Newton | Mississippi | 28101 | 325 | 8 |
260258 | 260258 | 2020-06-21 | Newton | Mississippi | 28101 | 325 | 8 |
263387 | 263387 | 2020-06-22 | Newton | Mississippi | 28101 | 323 | 8 |
266513 | 266513 | 2020-06-23 | Newton | Mississippi | 28101 | 324 | 8 |
269646 | 269646 | 2020-06-24 | Newton | Mississippi | 28101 | 326 | 8 |
272784 | 272784 | 2020-06-25 | Newton | Mississippi | 28101 | 325 | 8 |
275927 | 275927 | 2020-06-26 | Newton | Mississippi | 28101 | 326 | 8 |
279075 | 279075 | 2020-06-27 | Newton | Mississippi | 28101 | 330 | 8 |
282223 | 282223 | 2020-06-28 | Newton | Mississippi | 28101 | 330 | 8 |
285368 | 285368 | 2020-06-29 | Newton | Mississippi | 28101 | 329 | 9 |
288518 | 288518 | 2020-06-30 | Newton | Mississippi | 28101 | 329 | 9 |
291669 | 291669 | 2020-07-01 | Newton | Mississippi | 28101 | 328 | 9 |
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);