ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Lee" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636339 | 636339 | 2020-10-16 | Lee | Mississippi | 28081 | 3354 | 79 |
633093 | 633093 | 2020-10-15 | Lee | Mississippi | 28081 | 3316 | 79 |
629848 | 629848 | 2020-10-14 | Lee | Mississippi | 28081 | 3290 | 78 |
626604 | 626604 | 2020-10-13 | Lee | Mississippi | 28081 | 3239 | 78 |
623362 | 623362 | 2020-10-12 | Lee | Mississippi | 28081 | 3208 | 77 |
620119 | 620119 | 2020-10-11 | Lee | Mississippi | 28081 | 3195 | 77 |
616877 | 616877 | 2020-10-10 | Lee | Mississippi | 28081 | 3181 | 76 |
613636 | 613636 | 2020-10-09 | Lee | Mississippi | 28081 | 3139 | 75 |
610394 | 610394 | 2020-10-08 | Lee | Mississippi | 28081 | 3100 | 75 |
607152 | 607152 | 2020-10-07 | Lee | Mississippi | 28081 | 3080 | 74 |
603909 | 603909 | 2020-10-06 | Lee | Mississippi | 28081 | 3076 | 74 |
600667 | 600667 | 2020-10-05 | Lee | Mississippi | 28081 | 3046 | 73 |
597424 | 597424 | 2020-10-04 | Lee | Mississippi | 28081 | 3040 | 73 |
594183 | 594183 | 2020-10-03 | Lee | Mississippi | 28081 | 3027 | 73 |
590942 | 590942 | 2020-10-02 | Lee | Mississippi | 28081 | 2997 | 73 |
587701 | 587701 | 2020-10-01 | Lee | Mississippi | 28081 | 2967 | 73 |
584461 | 584461 | 2020-09-30 | Lee | Mississippi | 28081 | 2935 | 72 |
581220 | 581220 | 2020-09-29 | Lee | Mississippi | 28081 | 2804 | 71 |
577979 | 577979 | 2020-09-28 | Lee | Mississippi | 28081 | 2764 | 70 |
574738 | 574738 | 2020-09-27 | Lee | Mississippi | 28081 | 2748 | 70 |
571495 | 571495 | 2020-09-26 | Lee | Mississippi | 28081 | 2736 | 70 |
568253 | 568253 | 2020-09-25 | Lee | Mississippi | 28081 | 2714 | 68 |
565013 | 565013 | 2020-09-24 | Lee | Mississippi | 28081 | 2683 | 68 |
561773 | 561773 | 2020-09-23 | Lee | Mississippi | 28081 | 2654 | 68 |
558536 | 558536 | 2020-09-22 | Lee | Mississippi | 28081 | 2633 | 68 |
555299 | 555299 | 2020-09-21 | Lee | Mississippi | 28081 | 2610 | 67 |
552061 | 552061 | 2020-09-20 | Lee | Mississippi | 28081 | 2606 | 67 |
548822 | 548822 | 2020-09-19 | Lee | Mississippi | 28081 | 2585 | 67 |
545584 | 545584 | 2020-09-18 | Lee | Mississippi | 28081 | 2561 | 66 |
542347 | 542347 | 2020-09-17 | Lee | Mississippi | 28081 | 2540 | 66 |
539111 | 539111 | 2020-09-16 | Lee | Mississippi | 28081 | 2515 | 66 |
535874 | 535874 | 2020-09-15 | Lee | Mississippi | 28081 | 2489 | 65 |
532639 | 532639 | 2020-09-14 | Lee | Mississippi | 28081 | 2472 | 64 |
529403 | 529403 | 2020-09-13 | Lee | Mississippi | 28081 | 2460 | 64 |
526167 | 526167 | 2020-09-12 | Lee | Mississippi | 28081 | 2444 | 65 |
522931 | 522931 | 2020-09-11 | Lee | Mississippi | 28081 | 2432 | 65 |
519694 | 519694 | 2020-09-10 | Lee | Mississippi | 28081 | 2415 | 64 |
516459 | 516459 | 2020-09-09 | Lee | Mississippi | 28081 | 2382 | 63 |
513225 | 513225 | 2020-09-08 | Lee | Mississippi | 28081 | 2362 | 61 |
509993 | 509993 | 2020-09-07 | Lee | Mississippi | 28081 | 2346 | 61 |
506760 | 506760 | 2020-09-06 | Lee | Mississippi | 28081 | 2336 | 61 |
503527 | 503527 | 2020-09-05 | Lee | Mississippi | 28081 | 2315 | 61 |
500293 | 500293 | 2020-09-04 | Lee | Mississippi | 28081 | 2294 | 61 |
497059 | 497059 | 2020-09-03 | Lee | Mississippi | 28081 | 2271 | 61 |
493826 | 493826 | 2020-09-02 | Lee | Mississippi | 28081 | 2240 | 60 |
490592 | 490592 | 2020-09-01 | Lee | Mississippi | 28081 | 2211 | 58 |
487359 | 487359 | 2020-08-31 | Lee | Mississippi | 28081 | 2177 | 56 |
484125 | 484125 | 2020-08-30 | Lee | Mississippi | 28081 | 2162 | 54 |
480890 | 480890 | 2020-08-29 | Lee | Mississippi | 28081 | 2139 | 54 |
477658 | 477658 | 2020-08-28 | Lee | Mississippi | 28081 | 2111 | 54 |
474425 | 474425 | 2020-08-27 | Lee | Mississippi | 28081 | 2086 | 51 |
471193 | 471193 | 2020-08-26 | Lee | Mississippi | 28081 | 2066 | 49 |
467963 | 467963 | 2020-08-25 | Lee | Mississippi | 28081 | 2041 | 49 |
464734 | 464734 | 2020-08-24 | Lee | Mississippi | 28081 | 2036 | 48 |
461503 | 461503 | 2020-08-23 | Lee | Mississippi | 28081 | 1982 | 47 |
458276 | 458276 | 2020-08-22 | Lee | Mississippi | 28081 | 1958 | 47 |
455048 | 455048 | 2020-08-21 | Lee | Mississippi | 28081 | 1916 | 46 |
451820 | 451820 | 2020-08-20 | Lee | Mississippi | 28081 | 1885 | 44 |
448592 | 448592 | 2020-08-19 | Lee | Mississippi | 28081 | 1844 | 43 |
445366 | 445366 | 2020-08-18 | Lee | Mississippi | 28081 | 1780 | 43 |
442140 | 442140 | 2020-08-17 | Lee | Mississippi | 28081 | 1737 | 43 |
438913 | 438913 | 2020-08-16 | Lee | Mississippi | 28081 | 1724 | 43 |
435688 | 435688 | 2020-08-15 | Lee | Mississippi | 28081 | 1700 | 43 |
432462 | 432462 | 2020-08-14 | Lee | Mississippi | 28081 | 1657 | 42 |
429235 | 429235 | 2020-08-13 | Lee | Mississippi | 28081 | 1610 | 42 |
426011 | 426011 | 2020-08-12 | Lee | Mississippi | 28081 | 1563 | 42 |
422789 | 422789 | 2020-08-11 | Lee | Mississippi | 28081 | 1521 | 42 |
419567 | 419567 | 2020-08-10 | Lee | Mississippi | 28081 | 1479 | 41 |
416346 | 416346 | 2020-08-09 | Lee | Mississippi | 28081 | 1462 | 41 |
413126 | 413126 | 2020-08-08 | Lee | Mississippi | 28081 | 1428 | 39 |
409906 | 409906 | 2020-08-07 | Lee | Mississippi | 28081 | 1383 | 33 |
406686 | 406686 | 2020-08-06 | Lee | Mississippi | 28081 | 1332 | 32 |
403468 | 403468 | 2020-08-05 | Lee | Mississippi | 28081 | 1297 | 32 |
400251 | 400251 | 2020-08-04 | Lee | Mississippi | 28081 | 1274 | 30 |
397037 | 397037 | 2020-08-03 | Lee | Mississippi | 28081 | 1239 | 30 |
393821 | 393821 | 2020-08-02 | Lee | Mississippi | 28081 | 1232 | 30 |
390604 | 390604 | 2020-08-01 | Lee | Mississippi | 28081 | 1194 | 30 |
387387 | 387387 | 2020-07-31 | Lee | Mississippi | 28081 | 1162 | 29 |
384169 | 384169 | 2020-07-30 | Lee | Mississippi | 28081 | 1115 | 28 |
380952 | 380952 | 2020-07-29 | Lee | Mississippi | 28081 | 1069 | 28 |
377735 | 377735 | 2020-07-28 | Lee | Mississippi | 28081 | 1050 | 28 |
374520 | 374520 | 2020-07-27 | Lee | Mississippi | 28081 | 1020 | 26 |
371308 | 371308 | 2020-07-26 | Lee | Mississippi | 28081 | 1002 | 26 |
368098 | 368098 | 2020-07-25 | Lee | Mississippi | 28081 | 968 | 26 |
364890 | 364890 | 2020-07-24 | Lee | Mississippi | 28081 | 941 | 26 |
361683 | 361683 | 2020-07-23 | Lee | Mississippi | 28081 | 896 | 26 |
358478 | 358478 | 2020-07-22 | Lee | Mississippi | 28081 | 879 | 26 |
355275 | 355275 | 2020-07-21 | Lee | Mississippi | 28081 | 863 | 25 |
352073 | 352073 | 2020-07-20 | Lee | Mississippi | 28081 | 820 | 24 |
348873 | 348873 | 2020-07-19 | Lee | Mississippi | 28081 | 768 | 24 |
345672 | 345672 | 2020-07-18 | Lee | Mississippi | 28081 | 747 | 24 |
342472 | 342472 | 2020-07-17 | Lee | Mississippi | 28081 | 728 | 23 |
339276 | 339276 | 2020-07-16 | Lee | Mississippi | 28081 | 695 | 23 |
336080 | 336080 | 2020-07-15 | Lee | Mississippi | 28081 | 662 | 23 |
332887 | 332887 | 2020-07-14 | Lee | Mississippi | 28081 | 640 | 23 |
329700 | 329700 | 2020-07-13 | Lee | Mississippi | 28081 | 630 | 22 |
326514 | 326514 | 2020-07-12 | Lee | Mississippi | 28081 | 628 | 22 |
323331 | 323331 | 2020-07-11 | Lee | Mississippi | 28081 | 612 | 22 |
320152 | 320152 | 2020-07-10 | Lee | Mississippi | 28081 | 600 | 22 |
316977 | 316977 | 2020-07-09 | Lee | Mississippi | 28081 | 586 | 21 |
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);