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

785 rows where fips = 28071 and state = "Mississippi" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Mississippi · 785 ✖

fips 1

  • 28071 · 785 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2501028 2501028 2022-05-13 Lafayette Mississippi 28071 15364 179
2497770 2497770 2022-05-12 Lafayette Mississippi 28071 15364 179
2494512 2494512 2022-05-11 Lafayette Mississippi 28071 15364 179
2491254 2491254 2022-05-10 Lafayette Mississippi 28071 15364 179
2487997 2487997 2022-05-09 Lafayette Mississippi 28071 15364 179
2484739 2484739 2022-05-08 Lafayette Mississippi 28071 15313 179
2481481 2481481 2022-05-07 Lafayette Mississippi 28071 15313 179
2478223 2478223 2022-05-06 Lafayette Mississippi 28071 15313 179
2474965 2474965 2022-05-05 Lafayette Mississippi 28071 15313 179
2471708 2471708 2022-05-04 Lafayette Mississippi 28071 15313 179
2468452 2468452 2022-05-03 Lafayette Mississippi 28071 15313 179
2465197 2465197 2022-05-02 Lafayette Mississippi 28071 15313 179
2461941 2461941 2022-05-01 Lafayette Mississippi 28071 15299 179
2458685 2458685 2022-04-30 Lafayette Mississippi 28071 15299 179
2455429 2455429 2022-04-29 Lafayette Mississippi 28071 15299 179
2452173 2452173 2022-04-28 Lafayette Mississippi 28071 15299 179
2448917 2448917 2022-04-27 Lafayette Mississippi 28071 15299 179
2445661 2445661 2022-04-26 Lafayette Mississippi 28071 15299 179
2442405 2442405 2022-04-25 Lafayette Mississippi 28071 15287 179
2439149 2439149 2022-04-24 Lafayette Mississippi 28071 15287 179
2435893 2435893 2022-04-23 Lafayette Mississippi 28071 15287 179
2432637 2432637 2022-04-22 Lafayette Mississippi 28071 15287 179
2429381 2429381 2022-04-21 Lafayette Mississippi 28071 15287 179
2426125 2426125 2022-04-20 Lafayette Mississippi 28071 15287 179
2422869 2422869 2022-04-19 Lafayette Mississippi 28071 15287 179
2419613 2419613 2022-04-18 Lafayette Mississippi 28071 15287 179
2416357 2416357 2022-04-17 Lafayette Mississippi 28071 15273 178
2413101 2413101 2022-04-16 Lafayette Mississippi 28071 15273 178
2409845 2409845 2022-04-15 Lafayette Mississippi 28071 15273 178
2406589 2406589 2022-04-14 Lafayette Mississippi 28071 15273 178
2403333 2403333 2022-04-13 Lafayette Mississippi 28071 15273 178
2400079 2400079 2022-04-12 Lafayette Mississippi 28071 15273 178
2396823 2396823 2022-04-11 Lafayette Mississippi 28071 15230 178
2393568 2393568 2022-04-10 Lafayette Mississippi 28071 15230 178
2390312 2390312 2022-04-09 Lafayette Mississippi 28071 15230 178
2387056 2387056 2022-04-08 Lafayette Mississippi 28071 15230 178
2383801 2383801 2022-04-07 Lafayette Mississippi 28071 15230 178
2380546 2380546 2022-04-06 Lafayette Mississippi 28071 15230 178
2377291 2377291 2022-04-05 Lafayette Mississippi 28071 15230 178
2374039 2374039 2022-04-04 Lafayette Mississippi 28071 15230 178
2370786 2370786 2022-04-03 Lafayette Mississippi 28071 15195 178
2367533 2367533 2022-04-02 Lafayette Mississippi 28071 15195 178
2364280 2364280 2022-04-01 Lafayette Mississippi 28071 15195 178
2361026 2361026 2022-03-31 Lafayette Mississippi 28071 15195 178
2357772 2357772 2022-03-30 Lafayette Mississippi 28071 15195 178
2354519 2354519 2022-03-29 Lafayette Mississippi 28071 15195 178
2351267 2351267 2022-03-28 Lafayette Mississippi 28071 15195 178
2348014 2348014 2022-03-27 Lafayette Mississippi 28071 15153 178
2344761 2344761 2022-03-26 Lafayette Mississippi 28071 15153 178
2341508 2341508 2022-03-25 Lafayette Mississippi 28071 15153 178
2338255 2338255 2022-03-24 Lafayette Mississippi 28071 15153 178
2335001 2335001 2022-03-23 Lafayette Mississippi 28071 15153 178
2331747 2331747 2022-03-22 Lafayette Mississippi 28071 15153 178
2328495 2328495 2022-03-21 Lafayette Mississippi 28071 15153 178
2325242 2325242 2022-03-20 Lafayette Mississippi 28071 15142 178
2321988 2321988 2022-03-19 Lafayette Mississippi 28071 15142 178
2318734 2318734 2022-03-18 Lafayette Mississippi 28071 15142 178
2315481 2315481 2022-03-17 Lafayette Mississippi 28071 15142 178
2312228 2312228 2022-03-16 Lafayette Mississippi 28071 15142 178
2308975 2308975 2022-03-15 Lafayette Mississippi 28071 15142 178
2305724 2305724 2022-03-14 Lafayette Mississippi 28071 15142 178
2302472 2302472 2022-03-13 Lafayette Mississippi 28071 15115 177
2299220 2299220 2022-03-12 Lafayette Mississippi 28071 15115 177
2295968 2295968 2022-03-11 Lafayette Mississippi 28071 15115 177
2292716 2292716 2022-03-10 Lafayette Mississippi 28071 15115 177
2289464 2289464 2022-03-09 Lafayette Mississippi 28071 15115 177
2286213 2286213 2022-03-08 Lafayette Mississippi 28071 15115 177
2282961 2282961 2022-03-07 Lafayette Mississippi 28071 15113 176
2279708 2279708 2022-03-06 Lafayette Mississippi 28071 15109 176
2276455 2276455 2022-03-05 Lafayette Mississippi 28071 15109 176
2273202 2273202 2022-03-04 Lafayette Mississippi 28071 15109 176
2269950 2269950 2022-03-03 Lafayette Mississippi 28071 15108 176
2266697 2266697 2022-03-02 Lafayette Mississippi 28071 15107 176
2263446 2263446 2022-03-01 Lafayette Mississippi 28071 15098 176
2260195 2260195 2022-02-28 Lafayette Mississippi 28071 15095 175
2256944 2256944 2022-02-27 Lafayette Mississippi 28071 15072 174
2253693 2253693 2022-02-26 Lafayette Mississippi 28071 15072 174
2250442 2250442 2022-02-25 Lafayette Mississippi 28071 15072 174
2247191 2247191 2022-02-24 Lafayette Mississippi 28071 15034 174
2243940 2243940 2022-02-23 Lafayette Mississippi 28071 15028 174
2240689 2240689 2022-02-22 Lafayette Mississippi 28071 15026 174
2237438 2237438 2022-02-21 Lafayette Mississippi 28071 14976 173
2234187 2234187 2022-02-20 Lafayette Mississippi 28071 14976 173
2230936 2230936 2022-02-19 Lafayette Mississippi 28071 14976 173
2227685 2227685 2022-02-18 Lafayette Mississippi 28071 14976 173
2224434 2224434 2022-02-17 Lafayette Mississippi 28071 14960 173
2221183 2221183 2022-02-16 Lafayette Mississippi 28071 14943 173
2217932 2217932 2022-02-15 Lafayette Mississippi 28071 14917 173
2214681 2214681 2022-02-14 Lafayette Mississippi 28071 14904 173
2211429 2211429 2022-02-13 Lafayette Mississippi 28071 14822 172
2208176 2208176 2022-02-12 Lafayette Mississippi 28071 14822 172
2204923 2204923 2022-02-11 Lafayette Mississippi 28071 14822 172
2201670 2201670 2022-02-10 Lafayette Mississippi 28071 14781 171
2198416 2198416 2022-02-09 Lafayette Mississippi 28071 14715 171
2195162 2195162 2022-02-08 Lafayette Mississippi 28071 14608 171
2191908 2191908 2022-02-07 Lafayette Mississippi 28071 14587 170
2188655 2188655 2022-02-06 Lafayette Mississippi 28071 14215 169
2185402 2185402 2022-02-05 Lafayette Mississippi 28071 14215 169
2182150 2182150 2022-02-04 Lafayette Mississippi 28071 14215 169
2178898 2178898 2022-02-03 Lafayette Mississippi 28071 14070 168

Next page

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