ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where fips = 28035 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535851 | 535851 | 2020-09-15 | Forrest | Mississippi | 28035 | 2284 | 68 |
532616 | 532616 | 2020-09-14 | Forrest | Mississippi | 28035 | 2281 | 68 |
529380 | 529380 | 2020-09-13 | Forrest | Mississippi | 28035 | 2277 | 68 |
526144 | 526144 | 2020-09-12 | Forrest | Mississippi | 28035 | 2272 | 68 |
522908 | 522908 | 2020-09-11 | Forrest | Mississippi | 28035 | 2269 | 68 |
519671 | 519671 | 2020-09-10 | Forrest | Mississippi | 28035 | 2248 | 68 |
516436 | 516436 | 2020-09-09 | Forrest | Mississippi | 28035 | 2242 | 68 |
513202 | 513202 | 2020-09-08 | Forrest | Mississippi | 28035 | 2234 | 68 |
509970 | 509970 | 2020-09-07 | Forrest | Mississippi | 28035 | 2233 | 68 |
506737 | 506737 | 2020-09-06 | Forrest | Mississippi | 28035 | 2232 | 68 |
503504 | 503504 | 2020-09-05 | Forrest | Mississippi | 28035 | 2224 | 68 |
500270 | 500270 | 2020-09-04 | Forrest | Mississippi | 28035 | 2219 | 68 |
497036 | 497036 | 2020-09-03 | Forrest | Mississippi | 28035 | 2203 | 67 |
493803 | 493803 | 2020-09-02 | Forrest | Mississippi | 28035 | 2165 | 66 |
490569 | 490569 | 2020-09-01 | Forrest | Mississippi | 28035 | 2140 | 63 |
487336 | 487336 | 2020-08-31 | Forrest | Mississippi | 28035 | 2128 | 62 |
484102 | 484102 | 2020-08-30 | Forrest | Mississippi | 28035 | 2125 | 61 |
480867 | 480867 | 2020-08-29 | Forrest | Mississippi | 28035 | 2119 | 61 |
477635 | 477635 | 2020-08-28 | Forrest | Mississippi | 28035 | 2104 | 61 |
474402 | 474402 | 2020-08-27 | Forrest | Mississippi | 28035 | 2098 | 61 |
471170 | 471170 | 2020-08-26 | Forrest | Mississippi | 28035 | 2063 | 62 |
467940 | 467940 | 2020-08-25 | Forrest | Mississippi | 28035 | 2043 | 61 |
464711 | 464711 | 2020-08-24 | Forrest | Mississippi | 28035 | 2047 | 61 |
461480 | 461480 | 2020-08-23 | Forrest | Mississippi | 28035 | 2035 | 60 |
458253 | 458253 | 2020-08-22 | Forrest | Mississippi | 28035 | 2002 | 60 |
455025 | 455025 | 2020-08-21 | Forrest | Mississippi | 28035 | 1976 | 59 |
451797 | 451797 | 2020-08-20 | Forrest | Mississippi | 28035 | 1964 | 59 |
448569 | 448569 | 2020-08-19 | Forrest | Mississippi | 28035 | 1947 | 59 |
445343 | 445343 | 2020-08-18 | Forrest | Mississippi | 28035 | 1937 | 59 |
442117 | 442117 | 2020-08-17 | Forrest | Mississippi | 28035 | 1924 | 57 |
438890 | 438890 | 2020-08-16 | Forrest | Mississippi | 28035 | 1914 | 57 |
435665 | 435665 | 2020-08-15 | Forrest | Mississippi | 28035 | 1905 | 57 |
432439 | 432439 | 2020-08-14 | Forrest | Mississippi | 28035 | 1889 | 57 |
429212 | 429212 | 2020-08-13 | Forrest | Mississippi | 28035 | 1865 | 57 |
425988 | 425988 | 2020-08-12 | Forrest | Mississippi | 28035 | 1858 | 57 |
422766 | 422766 | 2020-08-11 | Forrest | Mississippi | 28035 | 1826 | 56 |
419544 | 419544 | 2020-08-10 | Forrest | Mississippi | 28035 | 1820 | 56 |
416323 | 416323 | 2020-08-09 | Forrest | Mississippi | 28035 | 1806 | 56 |
413103 | 413103 | 2020-08-08 | Forrest | Mississippi | 28035 | 1778 | 56 |
409883 | 409883 | 2020-08-07 | Forrest | Mississippi | 28035 | 1758 | 55 |
406663 | 406663 | 2020-08-06 | Forrest | Mississippi | 28035 | 1721 | 55 |
403445 | 403445 | 2020-08-05 | Forrest | Mississippi | 28035 | 1701 | 55 |
400228 | 400228 | 2020-08-04 | Forrest | Mississippi | 28035 | 1653 | 53 |
397014 | 397014 | 2020-08-03 | Forrest | Mississippi | 28035 | 1640 | 53 |
393798 | 393798 | 2020-08-02 | Forrest | Mississippi | 28035 | 1631 | 53 |
390581 | 390581 | 2020-08-01 | Forrest | Mississippi | 28035 | 1615 | 51 |
387364 | 387364 | 2020-07-31 | Forrest | Mississippi | 28035 | 1564 | 50 |
384146 | 384146 | 2020-07-30 | Forrest | Mississippi | 28035 | 1540 | 50 |
380929 | 380929 | 2020-07-29 | Forrest | Mississippi | 28035 | 1491 | 48 |
377712 | 377712 | 2020-07-28 | Forrest | Mississippi | 28035 | 1464 | 48 |
374497 | 374497 | 2020-07-27 | Forrest | Mississippi | 28035 | 1428 | 46 |
371285 | 371285 | 2020-07-26 | Forrest | Mississippi | 28035 | 1405 | 46 |
368075 | 368075 | 2020-07-25 | Forrest | Mississippi | 28035 | 1373 | 46 |
364867 | 364867 | 2020-07-24 | Forrest | Mississippi | 28035 | 1353 | 46 |
361660 | 361660 | 2020-07-23 | Forrest | Mississippi | 28035 | 1294 | 45 |
358455 | 358455 | 2020-07-22 | Forrest | Mississippi | 28035 | 1267 | 45 |
355252 | 355252 | 2020-07-21 | Forrest | Mississippi | 28035 | 1232 | 45 |
352050 | 352050 | 2020-07-20 | Forrest | Mississippi | 28035 | 1197 | 45 |
348850 | 348850 | 2020-07-19 | Forrest | Mississippi | 28035 | 1161 | 45 |
345649 | 345649 | 2020-07-18 | Forrest | Mississippi | 28035 | 1140 | 45 |
342449 | 342449 | 2020-07-17 | Forrest | Mississippi | 28035 | 1162 | 45 |
339253 | 339253 | 2020-07-16 | Forrest | Mississippi | 28035 | 1140 | 45 |
336057 | 336057 | 2020-07-15 | Forrest | Mississippi | 28035 | 1105 | 44 |
332864 | 332864 | 2020-07-14 | Forrest | Mississippi | 28035 | 1071 | 43 |
329677 | 329677 | 2020-07-13 | Forrest | Mississippi | 28035 | 1043 | 43 |
326491 | 326491 | 2020-07-12 | Forrest | Mississippi | 28035 | 1038 | 43 |
323308 | 323308 | 2020-07-11 | Forrest | Mississippi | 28035 | 993 | 43 |
320129 | 320129 | 2020-07-10 | Forrest | Mississippi | 28035 | 972 | 43 |
316954 | 316954 | 2020-07-09 | Forrest | Mississippi | 28035 | 939 | 43 |
313780 | 313780 | 2020-07-08 | Forrest | Mississippi | 28035 | 927 | 43 |
310610 | 310610 | 2020-07-07 | Forrest | Mississippi | 28035 | 916 | 43 |
307442 | 307442 | 2020-07-06 | Forrest | Mississippi | 28035 | 878 | 42 |
304275 | 304275 | 2020-07-05 | Forrest | Mississippi | 28035 | 869 | 42 |
301111 | 301111 | 2020-07-04 | Forrest | Mississippi | 28035 | 860 | 42 |
297948 | 297948 | 2020-07-03 | Forrest | Mississippi | 28035 | 851 | 42 |
294790 | 294790 | 2020-07-02 | Forrest | Mississippi | 28035 | 829 | 42 |
291636 | 291636 | 2020-07-01 | Forrest | Mississippi | 28035 | 814 | 42 |
288485 | 288485 | 2020-06-30 | Forrest | Mississippi | 28035 | 798 | 42 |
285335 | 285335 | 2020-06-29 | Forrest | Mississippi | 28035 | 786 | 42 |
282190 | 282190 | 2020-06-28 | Forrest | Mississippi | 28035 | 777 | 42 |
279042 | 279042 | 2020-06-27 | Forrest | Mississippi | 28035 | 775 | 42 |
275894 | 275894 | 2020-06-26 | Forrest | Mississippi | 28035 | 767 | 42 |
272751 | 272751 | 2020-06-25 | Forrest | Mississippi | 28035 | 759 | 42 |
269614 | 269614 | 2020-06-24 | Forrest | Mississippi | 28035 | 742 | 42 |
266481 | 266481 | 2020-06-23 | Forrest | Mississippi | 28035 | 737 | 42 |
263355 | 263355 | 2020-06-22 | Forrest | Mississippi | 28035 | 729 | 42 |
260226 | 260226 | 2020-06-21 | Forrest | Mississippi | 28035 | 697 | 41 |
257100 | 257100 | 2020-06-20 | Forrest | Mississippi | 28035 | 697 | 41 |
253980 | 253980 | 2020-06-19 | Forrest | Mississippi | 28035 | 697 | 41 |
250865 | 250865 | 2020-06-18 | Forrest | Mississippi | 28035 | 697 | 41 |
247753 | 247753 | 2020-06-17 | Forrest | Mississippi | 28035 | 697 | 41 |
244640 | 244640 | 2020-06-16 | Forrest | Mississippi | 28035 | 689 | 41 |
241529 | 241529 | 2020-06-15 | Forrest | Mississippi | 28035 | 681 | 41 |
238420 | 238420 | 2020-06-14 | Forrest | Mississippi | 28035 | 679 | 41 |
235313 | 235313 | 2020-06-13 | Forrest | Mississippi | 28035 | 678 | 41 |
232207 | 232207 | 2020-06-12 | Forrest | Mississippi | 28035 | 672 | 41 |
229103 | 229103 | 2020-06-11 | Forrest | Mississippi | 28035 | 667 | 41 |
226001 | 226001 | 2020-06-10 | Forrest | Mississippi | 28035 | 667 | 41 |
222903 | 222903 | 2020-06-09 | Forrest | Mississippi | 28035 | 649 | 40 |
219808 | 219808 | 2020-06-08 | Forrest | Mississippi | 28035 | 635 | 40 |
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);