ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Newton" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387397 | 387397 | 2020-07-31 | Newton | Mississippi | 28101 | 514 | 11 |
384179 | 384179 | 2020-07-30 | Newton | Mississippi | 28101 | 509 | 11 |
380962 | 380962 | 2020-07-29 | Newton | Mississippi | 28101 | 498 | 10 |
377745 | 377745 | 2020-07-28 | Newton | Mississippi | 28101 | 490 | 10 |
374530 | 374530 | 2020-07-27 | Newton | Mississippi | 28101 | 475 | 10 |
371318 | 371318 | 2020-07-26 | Newton | Mississippi | 28101 | 472 | 10 |
368108 | 368108 | 2020-07-25 | Newton | Mississippi | 28101 | 467 | 10 |
364900 | 364900 | 2020-07-24 | Newton | Mississippi | 28101 | 458 | 10 |
361693 | 361693 | 2020-07-23 | Newton | Mississippi | 28101 | 454 | 10 |
358488 | 358488 | 2020-07-22 | Newton | Mississippi | 28101 | 452 | 10 |
355285 | 355285 | 2020-07-21 | Newton | Mississippi | 28101 | 442 | 10 |
352083 | 352083 | 2020-07-20 | Newton | Mississippi | 28101 | 435 | 10 |
348883 | 348883 | 2020-07-19 | Newton | Mississippi | 28101 | 435 | 10 |
345682 | 345682 | 2020-07-18 | Newton | Mississippi | 28101 | 416 | 10 |
342482 | 342482 | 2020-07-17 | Newton | Mississippi | 28101 | 408 | 11 |
339286 | 339286 | 2020-07-16 | Newton | Mississippi | 28101 | 390 | 11 |
336090 | 336090 | 2020-07-15 | Newton | Mississippi | 28101 | 384 | 10 |
332897 | 332897 | 2020-07-14 | Newton | Mississippi | 28101 | 379 | 10 |
329710 | 329710 | 2020-07-13 | Newton | Mississippi | 28101 | 377 | 10 |
326524 | 326524 | 2020-07-12 | Newton | Mississippi | 28101 | 376 | 10 |
323341 | 323341 | 2020-07-11 | Newton | Mississippi | 28101 | 375 | 10 |
320162 | 320162 | 2020-07-10 | Newton | Mississippi | 28101 | 367 | 10 |
316987 | 316987 | 2020-07-09 | Newton | Mississippi | 28101 | 357 | 10 |
313813 | 313813 | 2020-07-08 | Newton | Mississippi | 28101 | 352 | 10 |
310643 | 310643 | 2020-07-07 | Newton | Mississippi | 28101 | 347 | 9 |
307475 | 307475 | 2020-07-06 | Newton | Mississippi | 28101 | 339 | 9 |
304308 | 304308 | 2020-07-05 | Newton | Mississippi | 28101 | 339 | 9 |
301144 | 301144 | 2020-07-04 | Newton | Mississippi | 28101 | 339 | 9 |
297981 | 297981 | 2020-07-03 | Newton | Mississippi | 28101 | 338 | 9 |
294823 | 294823 | 2020-07-02 | Newton | Mississippi | 28101 | 332 | 9 |
291669 | 291669 | 2020-07-01 | Newton | Mississippi | 28101 | 328 | 9 |
288518 | 288518 | 2020-06-30 | Newton | Mississippi | 28101 | 329 | 9 |
285368 | 285368 | 2020-06-29 | Newton | Mississippi | 28101 | 329 | 9 |
282223 | 282223 | 2020-06-28 | Newton | Mississippi | 28101 | 330 | 8 |
279075 | 279075 | 2020-06-27 | Newton | Mississippi | 28101 | 330 | 8 |
275927 | 275927 | 2020-06-26 | Newton | Mississippi | 28101 | 326 | 8 |
272784 | 272784 | 2020-06-25 | Newton | Mississippi | 28101 | 325 | 8 |
269646 | 269646 | 2020-06-24 | Newton | Mississippi | 28101 | 326 | 8 |
266513 | 266513 | 2020-06-23 | Newton | Mississippi | 28101 | 324 | 8 |
263387 | 263387 | 2020-06-22 | Newton | Mississippi | 28101 | 323 | 8 |
260258 | 260258 | 2020-06-21 | Newton | Mississippi | 28101 | 325 | 8 |
257132 | 257132 | 2020-06-20 | Newton | Mississippi | 28101 | 325 | 8 |
254012 | 254012 | 2020-06-19 | Newton | Mississippi | 28101 | 325 | 8 |
250897 | 250897 | 2020-06-18 | Newton | Mississippi | 28101 | 325 | 8 |
247785 | 247785 | 2020-06-17 | Newton | Mississippi | 28101 | 325 | 8 |
244672 | 244672 | 2020-06-16 | Newton | Mississippi | 28101 | 324 | 7 |
241561 | 241561 | 2020-06-15 | Newton | Mississippi | 28101 | 322 | 6 |
238452 | 238452 | 2020-06-14 | Newton | Mississippi | 28101 | 321 | 6 |
235345 | 235345 | 2020-06-13 | Newton | Mississippi | 28101 | 321 | 6 |
232239 | 232239 | 2020-06-12 | Newton | Mississippi | 28101 | 320 | 6 |
229135 | 229135 | 2020-06-11 | Newton | Mississippi | 28101 | 313 | 6 |
226033 | 226033 | 2020-06-10 | Newton | Mississippi | 28101 | 313 | 6 |
222935 | 222935 | 2020-06-09 | Newton | Mississippi | 28101 | 307 | 5 |
219840 | 219840 | 2020-06-08 | Newton | Mississippi | 28101 | 301 | 5 |
216748 | 216748 | 2020-06-07 | Newton | Mississippi | 28101 | 298 | 4 |
213660 | 213660 | 2020-06-06 | Newton | Mississippi | 28101 | 297 | 4 |
210576 | 210576 | 2020-06-05 | Newton | Mississippi | 28101 | 292 | 4 |
207495 | 207495 | 2020-06-04 | Newton | Mississippi | 28101 | 288 | 4 |
204414 | 204414 | 2020-06-03 | Newton | Mississippi | 28101 | 283 | 4 |
201337 | 201337 | 2020-06-02 | Newton | Mississippi | 28101 | 282 | 4 |
198264 | 198264 | 2020-06-01 | Newton | Mississippi | 28101 | 278 | 4 |
195193 | 195193 | 2020-05-31 | Newton | Mississippi | 28101 | 270 | 4 |
192125 | 192125 | 2020-05-30 | Newton | Mississippi | 28101 | 271 | 4 |
189061 | 189061 | 2020-05-29 | Newton | Mississippi | 28101 | 263 | 4 |
186003 | 186003 | 2020-05-28 | Newton | Mississippi | 28101 | 256 | 4 |
182947 | 182947 | 2020-05-27 | Newton | Mississippi | 28101 | 250 | 4 |
179901 | 179901 | 2020-05-26 | Newton | Mississippi | 28101 | 231 | 4 |
176857 | 176857 | 2020-05-25 | Newton | Mississippi | 28101 | 227 | 3 |
173814 | 173814 | 2020-05-24 | Newton | Mississippi | 28101 | 224 | 3 |
170772 | 170772 | 2020-05-23 | Newton | Mississippi | 28101 | 221 | 3 |
167734 | 167734 | 2020-05-22 | Newton | Mississippi | 28101 | 214 | 3 |
164698 | 164698 | 2020-05-21 | Newton | Mississippi | 28101 | 210 | 3 |
161669 | 161669 | 2020-05-20 | Newton | Mississippi | 28101 | 206 | 3 |
158643 | 158643 | 2020-05-19 | Newton | Mississippi | 28101 | 196 | 3 |
155625 | 155625 | 2020-05-18 | Newton | Mississippi | 28101 | 192 | 3 |
152611 | 152611 | 2020-05-17 | Newton | Mississippi | 28101 | 187 | 2 |
149600 | 149600 | 2020-05-16 | Newton | Mississippi | 28101 | 186 | 2 |
146595 | 146595 | 2020-05-15 | Newton | Mississippi | 28101 | 172 | 2 |
143595 | 143595 | 2020-05-14 | Newton | Mississippi | 28101 | 161 | 2 |
140600 | 140600 | 2020-05-13 | Newton | Mississippi | 28101 | 155 | 1 |
137606 | 137606 | 2020-05-12 | Newton | Mississippi | 28101 | 147 | 1 |
134616 | 134616 | 2020-05-11 | Newton | Mississippi | 28101 | 142 | 1 |
131625 | 131625 | 2020-05-10 | Newton | Mississippi | 28101 | 138 | 1 |
128635 | 128635 | 2020-05-09 | Newton | Mississippi | 28101 | 137 | 1 |
125648 | 125648 | 2020-05-08 | Newton | Mississippi | 28101 | 130 | 0 |
122666 | 122666 | 2020-05-07 | Newton | Mississippi | 28101 | 121 | 0 |
119692 | 119692 | 2020-05-06 | Newton | Mississippi | 28101 | 113 | 0 |
116732 | 116732 | 2020-05-05 | Newton | Mississippi | 28101 | 106 | 0 |
113850 | 113850 | 2020-05-04 | Newton | Mississippi | 28101 | 93 | 0 |
110971 | 110971 | 2020-05-03 | Newton | Mississippi | 28101 | 93 | 0 |
108100 | 108100 | 2020-05-02 | Newton | Mississippi | 28101 | 88 | 0 |
105235 | 105235 | 2020-05-01 | Newton | Mississippi | 28101 | 87 | 0 |
102374 | 102374 | 2020-04-30 | Newton | Mississippi | 28101 | 81 | 0 |
99522 | 99522 | 2020-04-29 | Newton | Mississippi | 28101 | 78 | 0 |
96676 | 96676 | 2020-04-28 | Newton | Mississippi | 28101 | 73 | 0 |
93840 | 93840 | 2020-04-27 | Newton | Mississippi | 28101 | 64 | 0 |
91019 | 91019 | 2020-04-26 | Newton | Mississippi | 28101 | 61 | 0 |
88203 | 88203 | 2020-04-25 | Newton | Mississippi | 28101 | 58 | 0 |
85393 | 85393 | 2020-04-24 | Newton | Mississippi | 28101 | 51 | 0 |
82589 | 82589 | 2020-04-23 | Newton | Mississippi | 28101 | 45 | 0 |
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);