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

792 rows where county = "Leflore", fips = 28083 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 · 792 ✖

fips 1

  • 28083 · 792 ✖

county 1

  • Leflore · 792 ✖
Link rowid date ▲ county state fips cases deaths
2501034 2501034 2022-05-13 Leflore Mississippi 28083 7326 169
2497776 2497776 2022-05-12 Leflore Mississippi 28083 7326 169
2494518 2494518 2022-05-11 Leflore Mississippi 28083 7326 169
2491260 2491260 2022-05-10 Leflore Mississippi 28083 7326 169
2488003 2488003 2022-05-09 Leflore Mississippi 28083 7326 169
2484745 2484745 2022-05-08 Leflore Mississippi 28083 7312 169
2481487 2481487 2022-05-07 Leflore Mississippi 28083 7312 169
2478229 2478229 2022-05-06 Leflore Mississippi 28083 7312 169
2474971 2474971 2022-05-05 Leflore Mississippi 28083 7312 169
2471714 2471714 2022-05-04 Leflore Mississippi 28083 7312 169
2468458 2468458 2022-05-03 Leflore Mississippi 28083 7312 169
2465203 2465203 2022-05-02 Leflore Mississippi 28083 7312 169
2461947 2461947 2022-05-01 Leflore Mississippi 28083 7311 169
2458691 2458691 2022-04-30 Leflore Mississippi 28083 7311 169
2455435 2455435 2022-04-29 Leflore Mississippi 28083 7311 169
2452179 2452179 2022-04-28 Leflore Mississippi 28083 7311 169
2448923 2448923 2022-04-27 Leflore Mississippi 28083 7311 169
2445667 2445667 2022-04-26 Leflore Mississippi 28083 7311 169
2442411 2442411 2022-04-25 Leflore Mississippi 28083 7307 169
2439155 2439155 2022-04-24 Leflore Mississippi 28083 7307 169
2435899 2435899 2022-04-23 Leflore Mississippi 28083 7307 169
2432643 2432643 2022-04-22 Leflore Mississippi 28083 7307 169
2429387 2429387 2022-04-21 Leflore Mississippi 28083 7307 169
2426131 2426131 2022-04-20 Leflore Mississippi 28083 7307 169
2422875 2422875 2022-04-19 Leflore Mississippi 28083 7307 169
2419619 2419619 2022-04-18 Leflore Mississippi 28083 7307 169
2416363 2416363 2022-04-17 Leflore Mississippi 28083 7307 169
2413107 2413107 2022-04-16 Leflore Mississippi 28083 7307 169
2409851 2409851 2022-04-15 Leflore Mississippi 28083 7307 169
2406595 2406595 2022-04-14 Leflore Mississippi 28083 7307 169
2403339 2403339 2022-04-13 Leflore Mississippi 28083 7307 169
2400085 2400085 2022-04-12 Leflore Mississippi 28083 7307 169
2396829 2396829 2022-04-11 Leflore Mississippi 28083 7302 169
2393574 2393574 2022-04-10 Leflore Mississippi 28083 7302 169
2390318 2390318 2022-04-09 Leflore Mississippi 28083 7302 169
2387062 2387062 2022-04-08 Leflore Mississippi 28083 7302 169
2383807 2383807 2022-04-07 Leflore Mississippi 28083 7302 169
2380552 2380552 2022-04-06 Leflore Mississippi 28083 7302 169
2377297 2377297 2022-04-05 Leflore Mississippi 28083 7302 169
2374045 2374045 2022-04-04 Leflore Mississippi 28083 7302 169
2370792 2370792 2022-04-03 Leflore Mississippi 28083 7299 169
2367539 2367539 2022-04-02 Leflore Mississippi 28083 7299 169
2364286 2364286 2022-04-01 Leflore Mississippi 28083 7299 169
2361032 2361032 2022-03-31 Leflore Mississippi 28083 7299 169
2357778 2357778 2022-03-30 Leflore Mississippi 28083 7299 169
2354525 2354525 2022-03-29 Leflore Mississippi 28083 7299 169
2351273 2351273 2022-03-28 Leflore Mississippi 28083 7299 169
2348020 2348020 2022-03-27 Leflore Mississippi 28083 7297 167
2344767 2344767 2022-03-26 Leflore Mississippi 28083 7297 167
2341514 2341514 2022-03-25 Leflore Mississippi 28083 7297 167
2338261 2338261 2022-03-24 Leflore Mississippi 28083 7297 167
2335007 2335007 2022-03-23 Leflore Mississippi 28083 7297 167
2331753 2331753 2022-03-22 Leflore Mississippi 28083 7297 167
2328501 2328501 2022-03-21 Leflore Mississippi 28083 7297 167
2325248 2325248 2022-03-20 Leflore Mississippi 28083 7297 167
2321994 2321994 2022-03-19 Leflore Mississippi 28083 7297 167
2318740 2318740 2022-03-18 Leflore Mississippi 28083 7297 167
2315487 2315487 2022-03-17 Leflore Mississippi 28083 7297 167
2312234 2312234 2022-03-16 Leflore Mississippi 28083 7297 167
2308981 2308981 2022-03-15 Leflore Mississippi 28083 7297 167
2305730 2305730 2022-03-14 Leflore Mississippi 28083 7297 167
2302478 2302478 2022-03-13 Leflore Mississippi 28083 7293 167
2299226 2299226 2022-03-12 Leflore Mississippi 28083 7293 167
2295974 2295974 2022-03-11 Leflore Mississippi 28083 7293 167
2292722 2292722 2022-03-10 Leflore Mississippi 28083 7293 167
2289470 2289470 2022-03-09 Leflore Mississippi 28083 7293 167
2286219 2286219 2022-03-08 Leflore Mississippi 28083 7293 167
2282967 2282967 2022-03-07 Leflore Mississippi 28083 7293 167
2279714 2279714 2022-03-06 Leflore Mississippi 28083 7291 167
2276461 2276461 2022-03-05 Leflore Mississippi 28083 7291 167
2273208 2273208 2022-03-04 Leflore Mississippi 28083 7291 167
2269956 2269956 2022-03-03 Leflore Mississippi 28083 7291 166
2266703 2266703 2022-03-02 Leflore Mississippi 28083 7286 166
2263452 2263452 2022-03-01 Leflore Mississippi 28083 7285 166
2260201 2260201 2022-02-28 Leflore Mississippi 28083 7285 166
2256950 2256950 2022-02-27 Leflore Mississippi 28083 7283 166
2253699 2253699 2022-02-26 Leflore Mississippi 28083 7283 166
2250448 2250448 2022-02-25 Leflore Mississippi 28083 7283 166
2247197 2247197 2022-02-24 Leflore Mississippi 28083 7283 166
2243946 2243946 2022-02-23 Leflore Mississippi 28083 7282 165
2240695 2240695 2022-02-22 Leflore Mississippi 28083 7280 164
2237444 2237444 2022-02-21 Leflore Mississippi 28083 7278 164
2234193 2234193 2022-02-20 Leflore Mississippi 28083 7278 164
2230942 2230942 2022-02-19 Leflore Mississippi 28083 7278 164
2227691 2227691 2022-02-18 Leflore Mississippi 28083 7278 164
2224440 2224440 2022-02-17 Leflore Mississippi 28083 7274 164
2221189 2221189 2022-02-16 Leflore Mississippi 28083 7274 164
2217938 2217938 2022-02-15 Leflore Mississippi 28083 7271 164
2214687 2214687 2022-02-14 Leflore Mississippi 28083 7266 164
2211435 2211435 2022-02-13 Leflore Mississippi 28083 7247 160
2208182 2208182 2022-02-12 Leflore Mississippi 28083 7247 160
2204929 2204929 2022-02-11 Leflore Mississippi 28083 7247 160
2201676 2201676 2022-02-10 Leflore Mississippi 28083 7240 160
2198422 2198422 2022-02-09 Leflore Mississippi 28083 7237 160
2195168 2195168 2022-02-08 Leflore Mississippi 28083 7233 159
2191914 2191914 2022-02-07 Leflore Mississippi 28083 7227 157
2188661 2188661 2022-02-06 Leflore Mississippi 28083 7115 156
2185408 2185408 2022-02-05 Leflore Mississippi 28083 7115 156
2182156 2182156 2022-02-04 Leflore Mississippi 28083 7115 156
2178904 2178904 2022-02-03 Leflore Mississippi 28083 7098 154

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