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

785 rows where fips = 40049 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 · 785 ✖

fips 1

  • 40049 · 785 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2501757 2501757 2022-05-13 Garvin Oklahoma 40049 7068 148
2498499 2498499 2022-05-12 Garvin Oklahoma 40049 7068 148
2495241 2495241 2022-05-11 Garvin Oklahoma 40049 7039 147
2491983 2491983 2022-05-10 Garvin Oklahoma 40049 7039 147
2488725 2488725 2022-05-09 Garvin Oklahoma 40049 7039 147
2485468 2485468 2022-05-08 Garvin Oklahoma 40049 7039 147
2482210 2482210 2022-05-07 Garvin Oklahoma 40049 7039 147
2478952 2478952 2022-05-06 Garvin Oklahoma 40049 7039 147
2475694 2475694 2022-05-05 Garvin Oklahoma 40049 7039 147
2472437 2472437 2022-05-04 Garvin Oklahoma 40049 7029 144
2469181 2469181 2022-05-03 Garvin Oklahoma 40049 7029 144
2465925 2465925 2022-05-02 Garvin Oklahoma 40049 7029 144
2462670 2462670 2022-05-01 Garvin Oklahoma 40049 7029 144
2459414 2459414 2022-04-30 Garvin Oklahoma 40049 7029 144
2456158 2456158 2022-04-29 Garvin Oklahoma 40049 7029 144
2452902 2452902 2022-04-28 Garvin Oklahoma 40049 7029 144
2449646 2449646 2022-04-27 Garvin Oklahoma 40049 7030 144
2446389 2446389 2022-04-26 Garvin Oklahoma 40049 7030 144
2443134 2443134 2022-04-25 Garvin Oklahoma 40049 7030 144
2439878 2439878 2022-04-24 Garvin Oklahoma 40049 7030 144
2436622 2436622 2022-04-23 Garvin Oklahoma 40049 7030 144
2433366 2433366 2022-04-22 Garvin Oklahoma 40049 7030 144
2430110 2430110 2022-04-21 Garvin Oklahoma 40049 7030 144
2426854 2426854 2022-04-20 Garvin Oklahoma 40049 7030 143
2423598 2423598 2022-04-19 Garvin Oklahoma 40049 7030 143
2420341 2420341 2022-04-18 Garvin Oklahoma 40049 7030 143
2417086 2417086 2022-04-17 Garvin Oklahoma 40049 7030 143
2413830 2413830 2022-04-16 Garvin Oklahoma 40049 7030 143
2410574 2410574 2022-04-15 Garvin Oklahoma 40049 7030 143
2407318 2407318 2022-04-14 Garvin Oklahoma 40049 7030 143
2404062 2404062 2022-04-13 Garvin Oklahoma 40049 7024 142
2400807 2400807 2022-04-12 Garvin Oklahoma 40049 7024 142
2397552 2397552 2022-04-11 Garvin Oklahoma 40049 7024 142
2394297 2394297 2022-04-10 Garvin Oklahoma 40049 7024 142
2391041 2391041 2022-04-09 Garvin Oklahoma 40049 7024 142
2387785 2387785 2022-04-08 Garvin Oklahoma 40049 7024 142
2384530 2384530 2022-04-07 Garvin Oklahoma 40049 7024 142
2381275 2381275 2022-04-06 Garvin Oklahoma 40049 7014 141
2378020 2378020 2022-04-05 Garvin Oklahoma 40049 7014 141
2374766 2374766 2022-04-04 Garvin Oklahoma 40049 7014 141
2371514 2371514 2022-04-03 Garvin Oklahoma 40049 7014 141
2368261 2368261 2022-04-02 Garvin Oklahoma 40049 7014 141
2365008 2365008 2022-04-01 Garvin Oklahoma 40049 7014 141
2361755 2361755 2022-03-31 Garvin Oklahoma 40049 7014 141
2358501 2358501 2022-03-30 Garvin Oklahoma 40049 7011 140
2355247 2355247 2022-03-29 Garvin Oklahoma 40049 7011 140
2351994 2351994 2022-03-28 Garvin Oklahoma 40049 7011 140
2348742 2348742 2022-03-27 Garvin Oklahoma 40049 7011 140
2345489 2345489 2022-03-26 Garvin Oklahoma 40049 7011 140
2342236 2342236 2022-03-25 Garvin Oklahoma 40049 7011 140
2338983 2338983 2022-03-24 Garvin Oklahoma 40049 7011 140
2335729 2335729 2022-03-23 Garvin Oklahoma 40049 7000 139
2332475 2332475 2022-03-22 Garvin Oklahoma 40049 7000 139
2329222 2329222 2022-03-21 Garvin Oklahoma 40049 7000 139
2325970 2325970 2022-03-20 Garvin Oklahoma 40049 7000 139
2322717 2322717 2022-03-19 Garvin Oklahoma 40049 7000 139
2319463 2319463 2022-03-18 Garvin Oklahoma 40049 7000 139
2316209 2316209 2022-03-17 Garvin Oklahoma 40049 7000 139
2312956 2312956 2022-03-16 Garvin Oklahoma 40049 6990 134
2309703 2309703 2022-03-15 Garvin Oklahoma 40049 6990 134
2306450 2306450 2022-03-14 Garvin Oklahoma 40049 6990 134
2303199 2303199 2022-03-13 Garvin Oklahoma 40049 6990 134
2299947 2299947 2022-03-12 Garvin Oklahoma 40049 6990 134
2296695 2296695 2022-03-11 Garvin Oklahoma 40049 6990 134
2293443 2293443 2022-03-10 Garvin Oklahoma 40049 6990 134
2290191 2290191 2022-03-09 Garvin Oklahoma 40049 6978 132
2286939 2286939 2022-03-08 Garvin Oklahoma 40049 6978 132
2283687 2283687 2022-03-07 Garvin Oklahoma 40049 6978 132
2280435 2280435 2022-03-06 Garvin Oklahoma 40049 6978 132
2277182 2277182 2022-03-05 Garvin Oklahoma 40049 6978 132
2273929 2273929 2022-03-04 Garvin Oklahoma 40049 6978 132
2270676 2270676 2022-03-03 Garvin Oklahoma 40049 6978 132
2267424 2267424 2022-03-02 Garvin Oklahoma 40049 6978 132
2264171 2264171 2022-03-01 Garvin Oklahoma 40049 6941 129
2260921 2260921 2022-02-28 Garvin Oklahoma 40049 6941 129
2257670 2257670 2022-02-27 Garvin Oklahoma 40049 6941 129
2254419 2254419 2022-02-26 Garvin Oklahoma 40049 6941 129
2251168 2251168 2022-02-25 Garvin Oklahoma 40049 6941 129
2247917 2247917 2022-02-24 Garvin Oklahoma 40049 6941 129
2244666 2244666 2022-02-23 Garvin Oklahoma 40049 6941 129
2241415 2241415 2022-02-22 Garvin Oklahoma 40049 6912 124
2238164 2238164 2022-02-21 Garvin Oklahoma 40049 6912 124
2234913 2234913 2022-02-20 Garvin Oklahoma 40049 6912 124
2231662 2231662 2022-02-19 Garvin Oklahoma 40049 6912 124
2228411 2228411 2022-02-18 Garvin Oklahoma 40049 6912 124
2225160 2225160 2022-02-17 Garvin Oklahoma 40049 6912 124
2221909 2221909 2022-02-16 Garvin Oklahoma 40049 6912 124
2218658 2218658 2022-02-15 Garvin Oklahoma 40049 6852 121
2215407 2215407 2022-02-14 Garvin Oklahoma 40049 6852 121
2212156 2212156 2022-02-13 Garvin Oklahoma 40049 6852 121
2208903 2208903 2022-02-12 Garvin Oklahoma 40049 6852 121
2205650 2205650 2022-02-11 Garvin Oklahoma 40049 6852 121
2202397 2202397 2022-02-10 Garvin Oklahoma 40049 6852 121
2199143 2199143 2022-02-09 Garvin Oklahoma 40049 6852 121
2195889 2195889 2022-02-08 Garvin Oklahoma 40049 6743 120
2192635 2192635 2022-02-07 Garvin Oklahoma 40049 6743 120
2189381 2189381 2022-02-06 Garvin Oklahoma 40049 6743 120
2186128 2186128 2022-02-05 Garvin Oklahoma 40049 6743 120
2182876 2182876 2022-02-04 Garvin Oklahoma 40049 6743 120
2179624 2179624 2022-02-03 Garvin Oklahoma 40049 6743 120

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