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