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

784 rows where county = "Leake" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

fips 1

county 1

  • Leake · 784 ✖
Link rowid date ▲ county state fips cases deaths
2501032 2501032 2022-05-13 Leake Mississippi 28079 6427 120
2497774 2497774 2022-05-12 Leake Mississippi 28079 6427 120
2494516 2494516 2022-05-11 Leake Mississippi 28079 6427 120
2491258 2491258 2022-05-10 Leake Mississippi 28079 6427 120
2488001 2488001 2022-05-09 Leake Mississippi 28079 6427 120
2484743 2484743 2022-05-08 Leake Mississippi 28079 6417 120
2481485 2481485 2022-05-07 Leake Mississippi 28079 6417 120
2478227 2478227 2022-05-06 Leake Mississippi 28079 6417 120
2474969 2474969 2022-05-05 Leake Mississippi 28079 6417 120
2471712 2471712 2022-05-04 Leake Mississippi 28079 6417 120
2468456 2468456 2022-05-03 Leake Mississippi 28079 6417 120
2465201 2465201 2022-05-02 Leake Mississippi 28079 6417 120
2461945 2461945 2022-05-01 Leake Mississippi 28079 6411 120
2458689 2458689 2022-04-30 Leake Mississippi 28079 6411 120
2455433 2455433 2022-04-29 Leake Mississippi 28079 6411 120
2452177 2452177 2022-04-28 Leake Mississippi 28079 6411 120
2448921 2448921 2022-04-27 Leake Mississippi 28079 6411 120
2445665 2445665 2022-04-26 Leake Mississippi 28079 6411 120
2442409 2442409 2022-04-25 Leake Mississippi 28079 6404 120
2439153 2439153 2022-04-24 Leake Mississippi 28079 6404 120
2435897 2435897 2022-04-23 Leake Mississippi 28079 6404 120
2432641 2432641 2022-04-22 Leake Mississippi 28079 6404 120
2429385 2429385 2022-04-21 Leake Mississippi 28079 6404 120
2426129 2426129 2022-04-20 Leake Mississippi 28079 6404 120
2422873 2422873 2022-04-19 Leake Mississippi 28079 6404 120
2419617 2419617 2022-04-18 Leake Mississippi 28079 6404 120
2416361 2416361 2022-04-17 Leake Mississippi 28079 6403 120
2413105 2413105 2022-04-16 Leake Mississippi 28079 6403 120
2409849 2409849 2022-04-15 Leake Mississippi 28079 6403 120
2406593 2406593 2022-04-14 Leake Mississippi 28079 6403 120
2403337 2403337 2022-04-13 Leake Mississippi 28079 6403 120
2400083 2400083 2022-04-12 Leake Mississippi 28079 6403 120
2396827 2396827 2022-04-11 Leake Mississippi 28079 6396 120
2393572 2393572 2022-04-10 Leake Mississippi 28079 6396 120
2390316 2390316 2022-04-09 Leake Mississippi 28079 6396 120
2387060 2387060 2022-04-08 Leake Mississippi 28079 6396 120
2383805 2383805 2022-04-07 Leake Mississippi 28079 6396 120
2380550 2380550 2022-04-06 Leake Mississippi 28079 6396 120
2377295 2377295 2022-04-05 Leake Mississippi 28079 6396 120
2374043 2374043 2022-04-04 Leake Mississippi 28079 6396 120
2370790 2370790 2022-04-03 Leake Mississippi 28079 6393 120
2367537 2367537 2022-04-02 Leake Mississippi 28079 6393 120
2364284 2364284 2022-04-01 Leake Mississippi 28079 6393 120
2361030 2361030 2022-03-31 Leake Mississippi 28079 6393 120
2357776 2357776 2022-03-30 Leake Mississippi 28079 6393 120
2354523 2354523 2022-03-29 Leake Mississippi 28079 6393 120
2351271 2351271 2022-03-28 Leake Mississippi 28079 6393 120
2348018 2348018 2022-03-27 Leake Mississippi 28079 6391 119
2344765 2344765 2022-03-26 Leake Mississippi 28079 6391 119
2341512 2341512 2022-03-25 Leake Mississippi 28079 6391 119
2338259 2338259 2022-03-24 Leake Mississippi 28079 6391 119
2335005 2335005 2022-03-23 Leake Mississippi 28079 6391 119
2331751 2331751 2022-03-22 Leake Mississippi 28079 6391 119
2328499 2328499 2022-03-21 Leake Mississippi 28079 6391 119
2325246 2325246 2022-03-20 Leake Mississippi 28079 6389 118
2321992 2321992 2022-03-19 Leake Mississippi 28079 6389 118
2318738 2318738 2022-03-18 Leake Mississippi 28079 6389 118
2315485 2315485 2022-03-17 Leake Mississippi 28079 6389 118
2312232 2312232 2022-03-16 Leake Mississippi 28079 6389 118
2308979 2308979 2022-03-15 Leake Mississippi 28079 6389 118
2305728 2305728 2022-03-14 Leake Mississippi 28079 6389 118
2302476 2302476 2022-03-13 Leake Mississippi 28079 6383 115
2299224 2299224 2022-03-12 Leake Mississippi 28079 6383 115
2295972 2295972 2022-03-11 Leake Mississippi 28079 6383 115
2292720 2292720 2022-03-10 Leake Mississippi 28079 6383 115
2289468 2289468 2022-03-09 Leake Mississippi 28079 6383 115
2286217 2286217 2022-03-08 Leake Mississippi 28079 6383 115
2282965 2282965 2022-03-07 Leake Mississippi 28079 6383 115
2279712 2279712 2022-03-06 Leake Mississippi 28079 6373 115
2276459 2276459 2022-03-05 Leake Mississippi 28079 6373 115
2273206 2273206 2022-03-04 Leake Mississippi 28079 6373 115
2269954 2269954 2022-03-03 Leake Mississippi 28079 6370 114
2266701 2266701 2022-03-02 Leake Mississippi 28079 6361 114
2263450 2263450 2022-03-01 Leake Mississippi 28079 6356 114
2260199 2260199 2022-02-28 Leake Mississippi 28079 6356 114
2256948 2256948 2022-02-27 Leake Mississippi 28079 6330 113
2253697 2253697 2022-02-26 Leake Mississippi 28079 6330 113
2250446 2250446 2022-02-25 Leake Mississippi 28079 6330 113
2247195 2247195 2022-02-24 Leake Mississippi 28079 6330 113
2243944 2243944 2022-02-23 Leake Mississippi 28079 6326 111
2240693 2240693 2022-02-22 Leake Mississippi 28079 6324 110
2237442 2237442 2022-02-21 Leake Mississippi 28079 6313 110
2234191 2234191 2022-02-20 Leake Mississippi 28079 6313 110
2230940 2230940 2022-02-19 Leake Mississippi 28079 6313 110
2227689 2227689 2022-02-18 Leake Mississippi 28079 6313 110
2224438 2224438 2022-02-17 Leake Mississippi 28079 6306 110
2221187 2221187 2022-02-16 Leake Mississippi 28079 6303 110
2217936 2217936 2022-02-15 Leake Mississippi 28079 6295 107
2214685 2214685 2022-02-14 Leake Mississippi 28079 6288 107
2211433 2211433 2022-02-13 Leake Mississippi 28079 6137 106
2208180 2208180 2022-02-12 Leake Mississippi 28079 6137 106
2204927 2204927 2022-02-11 Leake Mississippi 28079 6137 106
2201674 2201674 2022-02-10 Leake Mississippi 28079 6113 106
2198420 2198420 2022-02-09 Leake Mississippi 28079 6106 106
2195166 2195166 2022-02-08 Leake Mississippi 28079 6082 106
2191912 2191912 2022-02-07 Leake Mississippi 28079 6073 105
2188659 2188659 2022-02-06 Leake Mississippi 28079 5894 104
2185406 2185406 2022-02-05 Leake Mississippi 28079 5894 104
2182154 2182154 2022-02-04 Leake Mississippi 28079 5894 104
2178902 2178902 2022-02-03 Leake Mississippi 28079 5812 103

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