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

783 rows where county = "Pontotoc" 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 · 783 ✖

fips 1

county 1

  • Pontotoc · 783 ✖
Link rowid date ▲ county state fips cases deaths
2501050 2501050 2022-05-13 Pontotoc Mississippi 28115 10364 145
2497792 2497792 2022-05-12 Pontotoc Mississippi 28115 10364 145
2494534 2494534 2022-05-11 Pontotoc Mississippi 28115 10364 145
2491276 2491276 2022-05-10 Pontotoc Mississippi 28115 10364 145
2488019 2488019 2022-05-09 Pontotoc Mississippi 28115 10364 145
2484761 2484761 2022-05-08 Pontotoc Mississippi 28115 10354 145
2481503 2481503 2022-05-07 Pontotoc Mississippi 28115 10354 145
2478245 2478245 2022-05-06 Pontotoc Mississippi 28115 10354 145
2474987 2474987 2022-05-05 Pontotoc Mississippi 28115 10354 145
2471730 2471730 2022-05-04 Pontotoc Mississippi 28115 10354 145
2468474 2468474 2022-05-03 Pontotoc Mississippi 28115 10354 145
2465219 2465219 2022-05-02 Pontotoc Mississippi 28115 10354 145
2461963 2461963 2022-05-01 Pontotoc Mississippi 28115 10342 144
2458707 2458707 2022-04-30 Pontotoc Mississippi 28115 10342 144
2455451 2455451 2022-04-29 Pontotoc Mississippi 28115 10342 144
2452195 2452195 2022-04-28 Pontotoc Mississippi 28115 10342 144
2448939 2448939 2022-04-27 Pontotoc Mississippi 28115 10342 144
2445683 2445683 2022-04-26 Pontotoc Mississippi 28115 10342 144
2442427 2442427 2022-04-25 Pontotoc Mississippi 28115 10336 144
2439171 2439171 2022-04-24 Pontotoc Mississippi 28115 10336 144
2435915 2435915 2022-04-23 Pontotoc Mississippi 28115 10336 144
2432659 2432659 2022-04-22 Pontotoc Mississippi 28115 10336 144
2429403 2429403 2022-04-21 Pontotoc Mississippi 28115 10336 144
2426147 2426147 2022-04-20 Pontotoc Mississippi 28115 10336 144
2422891 2422891 2022-04-19 Pontotoc Mississippi 28115 10336 144
2419635 2419635 2022-04-18 Pontotoc Mississippi 28115 10336 144
2416379 2416379 2022-04-17 Pontotoc Mississippi 28115 10332 144
2413123 2413123 2022-04-16 Pontotoc Mississippi 28115 10332 144
2409867 2409867 2022-04-15 Pontotoc Mississippi 28115 10332 144
2406611 2406611 2022-04-14 Pontotoc Mississippi 28115 10332 144
2403355 2403355 2022-04-13 Pontotoc Mississippi 28115 10332 144
2400101 2400101 2022-04-12 Pontotoc Mississippi 28115 10332 144
2396845 2396845 2022-04-11 Pontotoc Mississippi 28115 10328 144
2393590 2393590 2022-04-10 Pontotoc Mississippi 28115 10328 144
2390334 2390334 2022-04-09 Pontotoc Mississippi 28115 10328 144
2387078 2387078 2022-04-08 Pontotoc Mississippi 28115 10328 144
2383823 2383823 2022-04-07 Pontotoc Mississippi 28115 10328 144
2380568 2380568 2022-04-06 Pontotoc Mississippi 28115 10328 144
2377313 2377313 2022-04-05 Pontotoc Mississippi 28115 10328 144
2374061 2374061 2022-04-04 Pontotoc Mississippi 28115 10328 144
2370808 2370808 2022-04-03 Pontotoc Mississippi 28115 10321 144
2367555 2367555 2022-04-02 Pontotoc Mississippi 28115 10321 144
2364302 2364302 2022-04-01 Pontotoc Mississippi 28115 10321 144
2361048 2361048 2022-03-31 Pontotoc Mississippi 28115 10321 144
2357794 2357794 2022-03-30 Pontotoc Mississippi 28115 10321 144
2354541 2354541 2022-03-29 Pontotoc Mississippi 28115 10321 144
2351289 2351289 2022-03-28 Pontotoc Mississippi 28115 10321 144
2348036 2348036 2022-03-27 Pontotoc Mississippi 28115 10318 144
2344783 2344783 2022-03-26 Pontotoc Mississippi 28115 10318 144
2341530 2341530 2022-03-25 Pontotoc Mississippi 28115 10318 144
2338277 2338277 2022-03-24 Pontotoc Mississippi 28115 10318 144
2335023 2335023 2022-03-23 Pontotoc Mississippi 28115 10318 144
2331769 2331769 2022-03-22 Pontotoc Mississippi 28115 10318 144
2328517 2328517 2022-03-21 Pontotoc Mississippi 28115 10318 144
2325264 2325264 2022-03-20 Pontotoc Mississippi 28115 10316 143
2322010 2322010 2022-03-19 Pontotoc Mississippi 28115 10316 143
2318756 2318756 2022-03-18 Pontotoc Mississippi 28115 10316 143
2315503 2315503 2022-03-17 Pontotoc Mississippi 28115 10316 143
2312250 2312250 2022-03-16 Pontotoc Mississippi 28115 10316 143
2308997 2308997 2022-03-15 Pontotoc Mississippi 28115 10316 143
2305746 2305746 2022-03-14 Pontotoc Mississippi 28115 10316 143
2302494 2302494 2022-03-13 Pontotoc Mississippi 28115 10314 141
2299242 2299242 2022-03-12 Pontotoc Mississippi 28115 10314 141
2295990 2295990 2022-03-11 Pontotoc Mississippi 28115 10314 141
2292738 2292738 2022-03-10 Pontotoc Mississippi 28115 10314 141
2289486 2289486 2022-03-09 Pontotoc Mississippi 28115 10314 141
2286235 2286235 2022-03-08 Pontotoc Mississippi 28115 10314 141
2282983 2282983 2022-03-07 Pontotoc Mississippi 28115 10314 139
2279730 2279730 2022-03-06 Pontotoc Mississippi 28115 10276 139
2276477 2276477 2022-03-05 Pontotoc Mississippi 28115 10276 139
2273224 2273224 2022-03-04 Pontotoc Mississippi 28115 10276 139
2269972 2269972 2022-03-03 Pontotoc Mississippi 28115 10274 137
2266719 2266719 2022-03-02 Pontotoc Mississippi 28115 10241 137
2263468 2263468 2022-03-01 Pontotoc Mississippi 28115 10240 137
2260217 2260217 2022-02-28 Pontotoc Mississippi 28115 10238 136
2256966 2256966 2022-02-27 Pontotoc Mississippi 28115 10210 134
2253715 2253715 2022-02-26 Pontotoc Mississippi 28115 10210 134
2250464 2250464 2022-02-25 Pontotoc Mississippi 28115 10210 134
2247213 2247213 2022-02-24 Pontotoc Mississippi 28115 10206 132
2243962 2243962 2022-02-23 Pontotoc Mississippi 28115 10205 132
2240711 2240711 2022-02-22 Pontotoc Mississippi 28115 10194 131
2237460 2237460 2022-02-21 Pontotoc Mississippi 28115 10147 131
2234209 2234209 2022-02-20 Pontotoc Mississippi 28115 10147 131
2230958 2230958 2022-02-19 Pontotoc Mississippi 28115 10147 131
2227707 2227707 2022-02-18 Pontotoc Mississippi 28115 10147 131
2224456 2224456 2022-02-17 Pontotoc Mississippi 28115 10132 131
2221205 2221205 2022-02-16 Pontotoc Mississippi 28115 10131 131
2217954 2217954 2022-02-15 Pontotoc Mississippi 28115 10116 130
2214703 2214703 2022-02-14 Pontotoc Mississippi 28115 10081 129
2211451 2211451 2022-02-13 Pontotoc Mississippi 28115 10061 127
2208198 2208198 2022-02-12 Pontotoc Mississippi 28115 10061 127
2204945 2204945 2022-02-11 Pontotoc Mississippi 28115 10061 127
2201692 2201692 2022-02-10 Pontotoc Mississippi 28115 10048 127
2198438 2198438 2022-02-09 Pontotoc Mississippi 28115 10033 126
2195184 2195184 2022-02-08 Pontotoc Mississippi 28115 10019 126
2191930 2191930 2022-02-07 Pontotoc Mississippi 28115 9937 125
2188677 2188677 2022-02-06 Pontotoc Mississippi 28115 9703 125
2185424 2185424 2022-02-05 Pontotoc Mississippi 28115 9703 125
2182172 2182172 2022-02-04 Pontotoc Mississippi 28115 9703 125
2178920 2178920 2022-02-03 Pontotoc Mississippi 28115 9594 123

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