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

771 rows where county = "Grant" and state = "Oklahoma" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Oklahoma · 771 ✖

fips 1

county 1

  • Grant · 771 ✖
Link rowid date ▲ county state fips cases deaths
2501759 2501759 2022-05-13 Grant Oklahoma 40053 1036 16
2498501 2498501 2022-05-12 Grant Oklahoma 40053 1036 16
2495243 2495243 2022-05-11 Grant Oklahoma 40053 1035 16
2491985 2491985 2022-05-10 Grant Oklahoma 40053 1035 16
2488727 2488727 2022-05-09 Grant Oklahoma 40053 1035 16
2485470 2485470 2022-05-08 Grant Oklahoma 40053 1035 16
2482212 2482212 2022-05-07 Grant Oklahoma 40053 1035 16
2478954 2478954 2022-05-06 Grant Oklahoma 40053 1035 16
2475696 2475696 2022-05-05 Grant Oklahoma 40053 1035 16
2472439 2472439 2022-05-04 Grant Oklahoma 40053 1034 16
2469183 2469183 2022-05-03 Grant Oklahoma 40053 1034 16
2465927 2465927 2022-05-02 Grant Oklahoma 40053 1034 16
2462672 2462672 2022-05-01 Grant Oklahoma 40053 1034 16
2459416 2459416 2022-04-30 Grant Oklahoma 40053 1034 16
2456160 2456160 2022-04-29 Grant Oklahoma 40053 1034 16
2452904 2452904 2022-04-28 Grant Oklahoma 40053 1034 16
2449648 2449648 2022-04-27 Grant Oklahoma 40053 1032 16
2446391 2446391 2022-04-26 Grant Oklahoma 40053 1032 16
2443136 2443136 2022-04-25 Grant Oklahoma 40053 1032 16
2439880 2439880 2022-04-24 Grant Oklahoma 40053 1032 16
2436624 2436624 2022-04-23 Grant Oklahoma 40053 1032 16
2433368 2433368 2022-04-22 Grant Oklahoma 40053 1032 16
2430112 2430112 2022-04-21 Grant Oklahoma 40053 1032 16
2426856 2426856 2022-04-20 Grant Oklahoma 40053 1031 16
2423600 2423600 2022-04-19 Grant Oklahoma 40053 1031 16
2420343 2420343 2022-04-18 Grant Oklahoma 40053 1031 16
2417088 2417088 2022-04-17 Grant Oklahoma 40053 1031 16
2413832 2413832 2022-04-16 Grant Oklahoma 40053 1031 16
2410576 2410576 2022-04-15 Grant Oklahoma 40053 1031 16
2407320 2407320 2022-04-14 Grant Oklahoma 40053 1031 16
2404064 2404064 2022-04-13 Grant Oklahoma 40053 1031 16
2400809 2400809 2022-04-12 Grant Oklahoma 40053 1031 16
2397554 2397554 2022-04-11 Grant Oklahoma 40053 1031 16
2394299 2394299 2022-04-10 Grant Oklahoma 40053 1031 16
2391043 2391043 2022-04-09 Grant Oklahoma 40053 1031 16
2387787 2387787 2022-04-08 Grant Oklahoma 40053 1031 16
2384532 2384532 2022-04-07 Grant Oklahoma 40053 1031 16
2381277 2381277 2022-04-06 Grant Oklahoma 40053 1031 16
2378022 2378022 2022-04-05 Grant Oklahoma 40053 1031 16
2374768 2374768 2022-04-04 Grant Oklahoma 40053 1031 16
2371516 2371516 2022-04-03 Grant Oklahoma 40053 1031 16
2368263 2368263 2022-04-02 Grant Oklahoma 40053 1031 16
2365010 2365010 2022-04-01 Grant Oklahoma 40053 1031 16
2361757 2361757 2022-03-31 Grant Oklahoma 40053 1031 16
2358503 2358503 2022-03-30 Grant Oklahoma 40053 1031 15
2355249 2355249 2022-03-29 Grant Oklahoma 40053 1031 15
2351996 2351996 2022-03-28 Grant Oklahoma 40053 1031 15
2348744 2348744 2022-03-27 Grant Oklahoma 40053 1031 15
2345491 2345491 2022-03-26 Grant Oklahoma 40053 1031 15
2342238 2342238 2022-03-25 Grant Oklahoma 40053 1031 15
2338985 2338985 2022-03-24 Grant Oklahoma 40053 1031 15
2335731 2335731 2022-03-23 Grant Oklahoma 40053 1028 15
2332477 2332477 2022-03-22 Grant Oklahoma 40053 1028 15
2329224 2329224 2022-03-21 Grant Oklahoma 40053 1028 15
2325972 2325972 2022-03-20 Grant Oklahoma 40053 1028 15
2322719 2322719 2022-03-19 Grant Oklahoma 40053 1028 15
2319465 2319465 2022-03-18 Grant Oklahoma 40053 1028 15
2316211 2316211 2022-03-17 Grant Oklahoma 40053 1028 15
2312958 2312958 2022-03-16 Grant Oklahoma 40053 1028 14
2309705 2309705 2022-03-15 Grant Oklahoma 40053 1028 14
2306452 2306452 2022-03-14 Grant Oklahoma 40053 1028 14
2303201 2303201 2022-03-13 Grant Oklahoma 40053 1028 14
2299949 2299949 2022-03-12 Grant Oklahoma 40053 1028 14
2296697 2296697 2022-03-11 Grant Oklahoma 40053 1028 14
2293445 2293445 2022-03-10 Grant Oklahoma 40053 1028 14
2290193 2290193 2022-03-09 Grant Oklahoma 40053 1027 14
2286941 2286941 2022-03-08 Grant Oklahoma 40053 1027 14
2283689 2283689 2022-03-07 Grant Oklahoma 40053 1027 14
2280437 2280437 2022-03-06 Grant Oklahoma 40053 1027 14
2277184 2277184 2022-03-05 Grant Oklahoma 40053 1027 14
2273931 2273931 2022-03-04 Grant Oklahoma 40053 1027 14
2270678 2270678 2022-03-03 Grant Oklahoma 40053 1027 14
2267426 2267426 2022-03-02 Grant Oklahoma 40053 1027 14
2264173 2264173 2022-03-01 Grant Oklahoma 40053 1021 14
2260923 2260923 2022-02-28 Grant Oklahoma 40053 1021 14
2257672 2257672 2022-02-27 Grant Oklahoma 40053 1021 14
2254421 2254421 2022-02-26 Grant Oklahoma 40053 1021 14
2251170 2251170 2022-02-25 Grant Oklahoma 40053 1021 14
2247919 2247919 2022-02-24 Grant Oklahoma 40053 1021 14
2244668 2244668 2022-02-23 Grant Oklahoma 40053 1021 14
2241417 2241417 2022-02-22 Grant Oklahoma 40053 1019 14
2238166 2238166 2022-02-21 Grant Oklahoma 40053 1019 14
2234915 2234915 2022-02-20 Grant Oklahoma 40053 1019 14
2231664 2231664 2022-02-19 Grant Oklahoma 40053 1019 14
2228413 2228413 2022-02-18 Grant Oklahoma 40053 1019 14
2225162 2225162 2022-02-17 Grant Oklahoma 40053 1019 14
2221911 2221911 2022-02-16 Grant Oklahoma 40053 1019 14
2218660 2218660 2022-02-15 Grant Oklahoma 40053 1009 13
2215409 2215409 2022-02-14 Grant Oklahoma 40053 1009 13
2212158 2212158 2022-02-13 Grant Oklahoma 40053 1009 13
2208905 2208905 2022-02-12 Grant Oklahoma 40053 1009 13
2205652 2205652 2022-02-11 Grant Oklahoma 40053 1009 13
2202399 2202399 2022-02-10 Grant Oklahoma 40053 1009 13
2199145 2199145 2022-02-09 Grant Oklahoma 40053 1009 13
2195891 2195891 2022-02-08 Grant Oklahoma 40053 986 12
2192637 2192637 2022-02-07 Grant Oklahoma 40053 986 12
2189383 2189383 2022-02-06 Grant Oklahoma 40053 986 12
2186130 2186130 2022-02-05 Grant Oklahoma 40053 986 12
2182878 2182878 2022-02-04 Grant Oklahoma 40053 986 12
2179626 2179626 2022-02-03 Grant Oklahoma 40053 986 12

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