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

1,565 rows where county = "Pontotoc" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 2

fips 2

county 1

  • Pontotoc · 1,565 ✖
Link rowid date ▲ county state fips cases deaths
2501050 2501050 2022-05-13 Pontotoc Mississippi 28115 10364 145
2501794 2501794 2022-05-13 Pontotoc Oklahoma 40123 12132 150
2497792 2497792 2022-05-12 Pontotoc Mississippi 28115 10364 145
2498536 2498536 2022-05-12 Pontotoc Oklahoma 40123 12132 150
2494534 2494534 2022-05-11 Pontotoc Mississippi 28115 10364 145
2495278 2495278 2022-05-11 Pontotoc Oklahoma 40123 12121 149
2491276 2491276 2022-05-10 Pontotoc Mississippi 28115 10364 145
2492020 2492020 2022-05-10 Pontotoc Oklahoma 40123 12121 149
2488019 2488019 2022-05-09 Pontotoc Mississippi 28115 10364 145
2488762 2488762 2022-05-09 Pontotoc Oklahoma 40123 12121 149
2484761 2484761 2022-05-08 Pontotoc Mississippi 28115 10354 145
2485505 2485505 2022-05-08 Pontotoc Oklahoma 40123 12121 149
2481503 2481503 2022-05-07 Pontotoc Mississippi 28115 10354 145
2482247 2482247 2022-05-07 Pontotoc Oklahoma 40123 12121 149
2478245 2478245 2022-05-06 Pontotoc Mississippi 28115 10354 145
2478989 2478989 2022-05-06 Pontotoc Oklahoma 40123 12121 149
2474987 2474987 2022-05-05 Pontotoc Mississippi 28115 10354 145
2475731 2475731 2022-05-05 Pontotoc Oklahoma 40123 12121 149
2471730 2471730 2022-05-04 Pontotoc Mississippi 28115 10354 145
2472474 2472474 2022-05-04 Pontotoc Oklahoma 40123 12092 147
2468474 2468474 2022-05-03 Pontotoc Mississippi 28115 10354 145
2469218 2469218 2022-05-03 Pontotoc Oklahoma 40123 12092 147
2465219 2465219 2022-05-02 Pontotoc Mississippi 28115 10354 145
2465962 2465962 2022-05-02 Pontotoc Oklahoma 40123 12092 147
2461963 2461963 2022-05-01 Pontotoc Mississippi 28115 10342 144
2462707 2462707 2022-05-01 Pontotoc Oklahoma 40123 12092 147
2458707 2458707 2022-04-30 Pontotoc Mississippi 28115 10342 144
2459451 2459451 2022-04-30 Pontotoc Oklahoma 40123 12092 147
2455451 2455451 2022-04-29 Pontotoc Mississippi 28115 10342 144
2456195 2456195 2022-04-29 Pontotoc Oklahoma 40123 12092 147
2452195 2452195 2022-04-28 Pontotoc Mississippi 28115 10342 144
2452939 2452939 2022-04-28 Pontotoc Oklahoma 40123 12092 147
2448939 2448939 2022-04-27 Pontotoc Mississippi 28115 10342 144
2449683 2449683 2022-04-27 Pontotoc Oklahoma 40123 12076 145
2445683 2445683 2022-04-26 Pontotoc Mississippi 28115 10342 144
2446426 2446426 2022-04-26 Pontotoc Oklahoma 40123 12076 145
2442427 2442427 2022-04-25 Pontotoc Mississippi 28115 10336 144
2443171 2443171 2022-04-25 Pontotoc Oklahoma 40123 12076 145
2439171 2439171 2022-04-24 Pontotoc Mississippi 28115 10336 144
2439915 2439915 2022-04-24 Pontotoc Oklahoma 40123 12076 145
2435915 2435915 2022-04-23 Pontotoc Mississippi 28115 10336 144
2436659 2436659 2022-04-23 Pontotoc Oklahoma 40123 12076 145
2432659 2432659 2022-04-22 Pontotoc Mississippi 28115 10336 144
2433403 2433403 2022-04-22 Pontotoc Oklahoma 40123 12076 145
2429403 2429403 2022-04-21 Pontotoc Mississippi 28115 10336 144
2430147 2430147 2022-04-21 Pontotoc Oklahoma 40123 12076 145
2426147 2426147 2022-04-20 Pontotoc Mississippi 28115 10336 144
2426891 2426891 2022-04-20 Pontotoc Oklahoma 40123 12066 145
2422891 2422891 2022-04-19 Pontotoc Mississippi 28115 10336 144
2423635 2423635 2022-04-19 Pontotoc Oklahoma 40123 12066 145
2419635 2419635 2022-04-18 Pontotoc Mississippi 28115 10336 144
2420378 2420378 2022-04-18 Pontotoc Oklahoma 40123 12066 145
2416379 2416379 2022-04-17 Pontotoc Mississippi 28115 10332 144
2417123 2417123 2022-04-17 Pontotoc Oklahoma 40123 12066 145
2413123 2413123 2022-04-16 Pontotoc Mississippi 28115 10332 144
2413867 2413867 2022-04-16 Pontotoc Oklahoma 40123 12066 145
2409867 2409867 2022-04-15 Pontotoc Mississippi 28115 10332 144
2410611 2410611 2022-04-15 Pontotoc Oklahoma 40123 12066 145
2406611 2406611 2022-04-14 Pontotoc Mississippi 28115 10332 144
2407355 2407355 2022-04-14 Pontotoc Oklahoma 40123 12066 145
2403355 2403355 2022-04-13 Pontotoc Mississippi 28115 10332 144
2404099 2404099 2022-04-13 Pontotoc Oklahoma 40123 12032 144
2400101 2400101 2022-04-12 Pontotoc Mississippi 28115 10332 144
2400844 2400844 2022-04-12 Pontotoc Oklahoma 40123 12032 144
2396845 2396845 2022-04-11 Pontotoc Mississippi 28115 10328 144
2397589 2397589 2022-04-11 Pontotoc Oklahoma 40123 12032 144
2393590 2393590 2022-04-10 Pontotoc Mississippi 28115 10328 144
2394334 2394334 2022-04-10 Pontotoc Oklahoma 40123 12032 144
2390334 2390334 2022-04-09 Pontotoc Mississippi 28115 10328 144
2391078 2391078 2022-04-09 Pontotoc Oklahoma 40123 12032 144
2387078 2387078 2022-04-08 Pontotoc Mississippi 28115 10328 144
2387822 2387822 2022-04-08 Pontotoc Oklahoma 40123 12032 144
2383823 2383823 2022-04-07 Pontotoc Mississippi 28115 10328 144
2384567 2384567 2022-04-07 Pontotoc Oklahoma 40123 12032 144
2380568 2380568 2022-04-06 Pontotoc Mississippi 28115 10328 144
2381312 2381312 2022-04-06 Pontotoc Oklahoma 40123 11990 142
2377313 2377313 2022-04-05 Pontotoc Mississippi 28115 10328 144
2378057 2378057 2022-04-05 Pontotoc Oklahoma 40123 11990 142
2374061 2374061 2022-04-04 Pontotoc Mississippi 28115 10328 144
2374803 2374803 2022-04-04 Pontotoc Oklahoma 40123 11990 142
2370808 2370808 2022-04-03 Pontotoc Mississippi 28115 10321 144
2371551 2371551 2022-04-03 Pontotoc Oklahoma 40123 11990 142
2367555 2367555 2022-04-02 Pontotoc Mississippi 28115 10321 144
2368298 2368298 2022-04-02 Pontotoc Oklahoma 40123 11990 142
2364302 2364302 2022-04-01 Pontotoc Mississippi 28115 10321 144
2365045 2365045 2022-04-01 Pontotoc Oklahoma 40123 11990 142
2361048 2361048 2022-03-31 Pontotoc Mississippi 28115 10321 144
2361792 2361792 2022-03-31 Pontotoc Oklahoma 40123 11990 142
2357794 2357794 2022-03-30 Pontotoc Mississippi 28115 10321 144
2358538 2358538 2022-03-30 Pontotoc Oklahoma 40123 11981 138
2354541 2354541 2022-03-29 Pontotoc Mississippi 28115 10321 144
2355284 2355284 2022-03-29 Pontotoc Oklahoma 40123 11981 138
2351289 2351289 2022-03-28 Pontotoc Mississippi 28115 10321 144
2352031 2352031 2022-03-28 Pontotoc Oklahoma 40123 11981 138
2348036 2348036 2022-03-27 Pontotoc Mississippi 28115 10318 144
2348779 2348779 2022-03-27 Pontotoc Oklahoma 40123 11981 138
2344783 2344783 2022-03-26 Pontotoc Mississippi 28115 10318 144
2345526 2345526 2022-03-26 Pontotoc Oklahoma 40123 11981 138
2341530 2341530 2022-03-25 Pontotoc Mississippi 28115 10318 144
2342273 2342273 2022-03-25 Pontotoc Oklahoma 40123 11981 138

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