ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

82 rows where "date" is on date 2020-08-29 and state = "Mississippi" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

state 1

  • Mississippi · 82 ✖
Link rowid date ▲ county state fips cases deaths
480850 480850 2020-08-29 Adams Mississippi 28001 780 31
480851 480851 2020-08-29 Alcorn Mississippi 28003 616 6
480852 480852 2020-08-29 Amite Mississippi 28005 272 7
480853 480853 2020-08-29 Attala Mississippi 28007 581 25
480854 480854 2020-08-29 Benton Mississippi 28009 193 1
480855 480855 2020-08-29 Bolivar Mississippi 28011 1462 48
480856 480856 2020-08-29 Calhoun Mississippi 28013 468 10
480857 480857 2020-08-29 Carroll Mississippi 28015 289 12
480858 480858 2020-08-29 Chickasaw Mississippi 28017 581 20
480859 480859 2020-08-29 Choctaw Mississippi 28019 154 4
480860 480860 2020-08-29 Claiborne Mississippi 28021 435 16
480861 480861 2020-08-29 Clarke Mississippi 28023 437 30
480862 480862 2020-08-29 Clay Mississippi 28025 469 14
480863 480863 2020-08-29 Coahoma Mississippi 28027 969 17
480864 480864 2020-08-29 Copiah Mississippi 28029 1056 31
480865 480865 2020-08-29 Covington Mississippi 28031 716 17
480866 480866 2020-08-29 DeSoto Mississippi 28033 4548 43
480867 480867 2020-08-29 Forrest Mississippi 28035 2119 61
480868 480868 2020-08-29 Franklin Mississippi 28037 175 3
480869 480869 2020-08-29 George Mississippi 28039 679 12
480870 480870 2020-08-29 Greene Mississippi 28041 290 14
480871 480871 2020-08-29 Grenada Mississippi 28043 934 32
480872 480872 2020-08-29 Hancock Mississippi 28045 487 18
480873 480873 2020-08-29 Harrison Mississippi 28047 3268 53
480874 480874 2020-08-29 Hinds Mississippi 28049 6473 138
480875 480875 2020-08-29 Holmes Mississippi 28051 1039 54
480876 480876 2020-08-29 Humphreys Mississippi 28053 335 14
480877 480877 2020-08-29 Issaquena Mississippi 28055 97 3
480878 480878 2020-08-29 Itawamba Mississippi 28057 545 14
480879 480879 2020-08-29 Jackson Mississippi 28059 2946 59
480880 480880 2020-08-29 Jasper Mississippi 28061 479 13
480881 480881 2020-08-29 Jefferson Mississippi 28063 217 9
480882 480882 2020-08-29 Jefferson Davis Mississippi 28065 302 8
480883 480883 2020-08-29 Jones Mississippi 28067 2146 72
480884 480884 2020-08-29 Kemper Mississippi 28069 269 15
480885 480885 2020-08-29 Lafayette Mississippi 28071 1377 34
480886 480886 2020-08-29 Lamar Mississippi 28073 1432 29
480887 480887 2020-08-29 Lauderdale Mississippi 28075 1737 106
480888 480888 2020-08-29 Lawrence Mississippi 28077 402 10
480889 480889 2020-08-29 Leake Mississippi 28079 878 31
480890 480890 2020-08-29 Lee Mississippi 28081 2139 54
480891 480891 2020-08-29 Leflore Mississippi 28083 1229 75
480892 480892 2020-08-29 Lincoln Mississippi 28085 962 51
480893 480893 2020-08-29 Lowndes Mississippi 28087 1272 53
480894 480894 2020-08-29 Madison Mississippi 28089 2939 83
480895 480895 2020-08-29 Marion Mississippi 28091 775 26
480896 480896 2020-08-29 Marshall Mississippi 28093 934 12
480897 480897 2020-08-29 Monroe Mississippi 28095 1025 57
480898 480898 2020-08-29 Montgomery Mississippi 28097 406 16
480899 480899 2020-08-29 Neshoba Mississippi 28099 1418 99
480900 480900 2020-08-29 Newton Mississippi 28101 660 14
480901 480901 2020-08-29 Noxubee Mississippi 28103 518 14
480902 480902 2020-08-29 Oktibbeha Mississippi 28105 1404 46
480903 480903 2020-08-29 Panola Mississippi 28107 1288 23
480904 480904 2020-08-29 Pearl River Mississippi 28109 743 48
480905 480905 2020-08-29 Perry Mississippi 28111 290 9
480906 480906 2020-08-29 Pike Mississippi 28113 1124 44
480907 480907 2020-08-29 Pontotoc Mississippi 28115 1049 11
480908 480908 2020-08-29 Prentiss Mississippi 28117 612 12
480909 480909 2020-08-29 Quitman Mississippi 28119 319 3
480910 480910 2020-08-29 Rankin Mississippi 28121 2817 62
480911 480911 2020-08-29 Scott Mississippi 28123 1091 22
480912 480912 2020-08-29 Sharkey Mississippi 28125 249 8
480913 480913 2020-08-29 Simpson Mississippi 28127 936 39
480914 480914 2020-08-29 Smith Mississippi 28129 463 13
480915 480915 2020-08-29 Stone Mississippi 28131 310 10
480916 480916 2020-08-29 Sunflower Mississippi 28133 1252 36
480917 480917 2020-08-29 Tallahatchie Mississippi 28135 623 13
480918 480918 2020-08-29 Tate Mississippi 28137 853 32
480919 480919 2020-08-29 Tippah Mississippi 28139 538 15
480920 480920 2020-08-29 Tishomingo Mississippi 28141 547 28
480921 480921 2020-08-29 Tunica Mississippi 28143 448 11
480922 480922 2020-08-29 Union Mississippi 28145 876 21
480923 480923 2020-08-29 Walthall Mississippi 28147 563 24
480924 480924 2020-08-29 Warren Mississippi 28149 1303 46
480925 480925 2020-08-29 Washington Mississippi 28151 1982 60
480926 480926 2020-08-29 Wayne Mississippi 28153 846 21
480927 480927 2020-08-29 Webster Mississippi 28155 298 13
480928 480928 2020-08-29 Wilkinson Mississippi 28157 276 17
480929 480929 2020-08-29 Winston Mississippi 28159 691 19
480930 480930 2020-08-29 Yalobusha Mississippi 28161 359 12
480931 480931 2020-08-29 Yazoo Mississippi 28163 950 21

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);