ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where county = "Warren" and fips = 28149 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054995 | 1054995 | 2021-02-22 | Warren | Mississippi | 28149 | 4090 | 113 |
1051748 | 1051748 | 2021-02-21 | Warren | Mississippi | 28149 | 4087 | 113 |
1048501 | 1048501 | 2021-02-20 | Warren | Mississippi | 28149 | 4083 | 113 |
1045255 | 1045255 | 2021-02-19 | Warren | Mississippi | 28149 | 4083 | 113 |
1042010 | 1042010 | 2021-02-18 | Warren | Mississippi | 28149 | 4080 | 113 |
1038765 | 1038765 | 2021-02-17 | Warren | Mississippi | 28149 | 4080 | 113 |
1035520 | 1035520 | 2021-02-16 | Warren | Mississippi | 28149 | 4073 | 113 |
1032275 | 1032275 | 2021-02-15 | Warren | Mississippi | 28149 | 4061 | 113 |
1029028 | 1029028 | 2021-02-14 | Warren | Mississippi | 28149 | 4055 | 113 |
1025782 | 1025782 | 2021-02-13 | Warren | Mississippi | 28149 | 4044 | 114 |
1022537 | 1022537 | 2021-02-12 | Warren | Mississippi | 28149 | 4034 | 114 |
1019292 | 1019292 | 2021-02-11 | Warren | Mississippi | 28149 | 4021 | 113 |
1016047 | 1016047 | 2021-02-10 | Warren | Mississippi | 28149 | 4010 | 113 |
1012802 | 1012802 | 2021-02-09 | Warren | Mississippi | 28149 | 4002 | 110 |
1009557 | 1009557 | 2021-02-08 | Warren | Mississippi | 28149 | 3990 | 110 |
1006310 | 1006310 | 2021-02-07 | Warren | Mississippi | 28149 | 3986 | 110 |
1003064 | 1003064 | 2021-02-06 | Warren | Mississippi | 28149 | 3972 | 110 |
999819 | 999819 | 2021-02-05 | Warren | Mississippi | 28149 | 3951 | 110 |
996573 | 996573 | 2021-02-04 | Warren | Mississippi | 28149 | 3940 | 110 |
993327 | 993327 | 2021-02-03 | Warren | Mississippi | 28149 | 3916 | 110 |
990081 | 990081 | 2021-02-02 | Warren | Mississippi | 28149 | 3900 | 110 |
986834 | 986834 | 2021-02-01 | Warren | Mississippi | 28149 | 3899 | 109 |
983587 | 983587 | 2021-01-31 | Warren | Mississippi | 28149 | 3888 | 109 |
980341 | 980341 | 2021-01-30 | Warren | Mississippi | 28149 | 3871 | 107 |
977095 | 977095 | 2021-01-29 | Warren | Mississippi | 28149 | 3839 | 105 |
973850 | 973850 | 2021-01-28 | Warren | Mississippi | 28149 | 3802 | 104 |
970605 | 970605 | 2021-01-27 | Warren | Mississippi | 28149 | 3766 | 103 |
967360 | 967360 | 2021-01-26 | Warren | Mississippi | 28149 | 3716 | 103 |
964116 | 964116 | 2021-01-25 | Warren | Mississippi | 28149 | 3698 | 103 |
960871 | 960871 | 2021-01-24 | Warren | Mississippi | 28149 | 3685 | 103 |
957625 | 957625 | 2021-01-23 | Warren | Mississippi | 28149 | 3674 | 103 |
954380 | 954380 | 2021-01-22 | Warren | Mississippi | 28149 | 3649 | 103 |
951135 | 951135 | 2021-01-21 | Warren | Mississippi | 28149 | 3619 | 101 |
947889 | 947889 | 2021-01-20 | Warren | Mississippi | 28149 | 3569 | 100 |
944642 | 944642 | 2021-01-19 | Warren | Mississippi | 28149 | 3548 | 98 |
941397 | 941397 | 2021-01-18 | Warren | Mississippi | 28149 | 3534 | 98 |
938152 | 938152 | 2021-01-17 | Warren | Mississippi | 28149 | 3484 | 98 |
934907 | 934907 | 2021-01-16 | Warren | Mississippi | 28149 | 3445 | 97 |
931662 | 931662 | 2021-01-15 | Warren | Mississippi | 28149 | 3378 | 95 |
928417 | 928417 | 2021-01-14 | Warren | Mississippi | 28149 | 3346 | 92 |
925171 | 925171 | 2021-01-13 | Warren | Mississippi | 28149 | 3305 | 91 |
921926 | 921926 | 2021-01-12 | Warren | Mississippi | 28149 | 3279 | 91 |
918681 | 918681 | 2021-01-11 | Warren | Mississippi | 28149 | 3252 | 90 |
915436 | 915436 | 2021-01-10 | Warren | Mississippi | 28149 | 3236 | 88 |
912191 | 912191 | 2021-01-09 | Warren | Mississippi | 28149 | 3166 | 88 |
908946 | 908946 | 2021-01-08 | Warren | Mississippi | 28149 | 3075 | 85 |
905700 | 905700 | 2021-01-07 | Warren | Mississippi | 28149 | 3042 | 84 |
902455 | 902455 | 2021-01-06 | Warren | Mississippi | 28149 | 2997 | 81 |
899210 | 899210 | 2021-01-05 | Warren | Mississippi | 28149 | 2914 | 80 |
895965 | 895965 | 2021-01-04 | Warren | Mississippi | 28149 | 2891 | 79 |
892718 | 892718 | 2021-01-03 | Warren | Mississippi | 28149 | 2872 | 79 |
889472 | 889472 | 2021-01-02 | Warren | Mississippi | 28149 | 2842 | 79 |
886226 | 886226 | 2021-01-01 | Warren | Mississippi | 28149 | 2773 | 79 |
882981 | 882981 | 2020-12-31 | Warren | Mississippi | 28149 | 2743 | 78 |
879736 | 879736 | 2020-12-30 | Warren | Mississippi | 28149 | 2692 | 78 |
876491 | 876491 | 2020-12-29 | Warren | Mississippi | 28149 | 2604 | 78 |
873246 | 873246 | 2020-12-28 | Warren | Mississippi | 28149 | 2566 | 77 |
870001 | 870001 | 2020-12-27 | Warren | Mississippi | 28149 | 2518 | 77 |
866756 | 866756 | 2020-12-26 | Warren | Mississippi | 28149 | 2487 | 75 |
863511 | 863511 | 2020-12-25 | Warren | Mississippi | 28149 | 2460 | 75 |
860266 | 860266 | 2020-12-24 | Warren | Mississippi | 28149 | 2443 | 74 |
857021 | 857021 | 2020-12-23 | Warren | Mississippi | 28149 | 2406 | 74 |
853776 | 853776 | 2020-12-22 | Warren | Mississippi | 28149 | 2349 | 74 |
850531 | 850531 | 2020-12-21 | Warren | Mississippi | 28149 | 2327 | 69 |
847286 | 847286 | 2020-12-20 | Warren | Mississippi | 28149 | 2318 | 69 |
844040 | 844040 | 2020-12-19 | Warren | Mississippi | 28149 | 2302 | 68 |
840795 | 840795 | 2020-12-18 | Warren | Mississippi | 28149 | 2269 | 68 |
837550 | 837550 | 2020-12-17 | Warren | Mississippi | 28149 | 2243 | 67 |
834304 | 834304 | 2020-12-16 | Warren | Mississippi | 28149 | 2219 | 67 |
831057 | 831057 | 2020-12-15 | Warren | Mississippi | 28149 | 2187 | 67 |
827811 | 827811 | 2020-12-14 | Warren | Mississippi | 28149 | 2162 | 65 |
824564 | 824564 | 2020-12-13 | Warren | Mississippi | 28149 | 2146 | 65 |
821318 | 821318 | 2020-12-12 | Warren | Mississippi | 28149 | 2108 | 64 |
818072 | 818072 | 2020-12-11 | Warren | Mississippi | 28149 | 2070 | 64 |
814826 | 814826 | 2020-12-10 | Warren | Mississippi | 28149 | 2025 | 62 |
811581 | 811581 | 2020-12-09 | Warren | Mississippi | 28149 | 2004 | 60 |
808336 | 808336 | 2020-12-08 | Warren | Mississippi | 28149 | 1975 | 60 |
805091 | 805091 | 2020-12-07 | Warren | Mississippi | 28149 | 1957 | 59 |
801846 | 801846 | 2020-12-06 | Warren | Mississippi | 28149 | 1949 | 59 |
798601 | 798601 | 2020-12-05 | Warren | Mississippi | 28149 | 1930 | 59 |
795356 | 795356 | 2020-12-04 | Warren | Mississippi | 28149 | 1895 | 59 |
792111 | 792111 | 2020-12-03 | Warren | Mississippi | 28149 | 1849 | 58 |
788866 | 788866 | 2020-12-02 | Warren | Mississippi | 28149 | 1830 | 58 |
785621 | 785621 | 2020-12-01 | Warren | Mississippi | 28149 | 1802 | 58 |
782377 | 782377 | 2020-11-30 | Warren | Mississippi | 28149 | 1787 | 57 |
779131 | 779131 | 2020-11-29 | Warren | Mississippi | 28149 | 1777 | 57 |
775886 | 775886 | 2020-11-28 | Warren | Mississippi | 28149 | 1768 | 57 |
772641 | 772641 | 2020-11-27 | Warren | Mississippi | 28149 | 1753 | 57 |
769396 | 769396 | 2020-11-26 | Warren | Mississippi | 28149 | 1741 | 57 |
766150 | 766150 | 2020-11-25 | Warren | Mississippi | 28149 | 1726 | 57 |
762905 | 762905 | 2020-11-24 | Warren | Mississippi | 28149 | 1722 | 57 |
759660 | 759660 | 2020-11-23 | Warren | Mississippi | 28149 | 1721 | 57 |
756413 | 756413 | 2020-11-22 | Warren | Mississippi | 28149 | 1717 | 57 |
753167 | 753167 | 2020-11-21 | Warren | Mississippi | 28149 | 1707 | 56 |
749921 | 749921 | 2020-11-20 | Warren | Mississippi | 28149 | 1691 | 56 |
746675 | 746675 | 2020-11-19 | Warren | Mississippi | 28149 | 1681 | 56 |
743428 | 743428 | 2020-11-18 | Warren | Mississippi | 28149 | 1670 | 56 |
740181 | 740181 | 2020-11-17 | Warren | Mississippi | 28149 | 1663 | 56 |
736937 | 736937 | 2020-11-16 | Warren | Mississippi | 28149 | 1660 | 56 |
733691 | 733691 | 2020-11-15 | Warren | Mississippi | 28149 | 1657 | 56 |
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);