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 = "Noble" 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 · 783 ✖

fips 1

county 1

  • Noble · 783 ✖
Link rowid date ▲ county state fips cases deaths
2501784 2501784 2022-05-13 Noble Oklahoma 40103 3050 39
2498526 2498526 2022-05-12 Noble Oklahoma 40103 3050 39
2495268 2495268 2022-05-11 Noble Oklahoma 40103 3044 39
2492010 2492010 2022-05-10 Noble Oklahoma 40103 3044 39
2488752 2488752 2022-05-09 Noble Oklahoma 40103 3044 39
2485495 2485495 2022-05-08 Noble Oklahoma 40103 3044 39
2482237 2482237 2022-05-07 Noble Oklahoma 40103 3044 39
2478979 2478979 2022-05-06 Noble Oklahoma 40103 3044 39
2475721 2475721 2022-05-05 Noble Oklahoma 40103 3044 39
2472464 2472464 2022-05-04 Noble Oklahoma 40103 3041 39
2469208 2469208 2022-05-03 Noble Oklahoma 40103 3041 39
2465952 2465952 2022-05-02 Noble Oklahoma 40103 3041 39
2462697 2462697 2022-05-01 Noble Oklahoma 40103 3041 39
2459441 2459441 2022-04-30 Noble Oklahoma 40103 3041 39
2456185 2456185 2022-04-29 Noble Oklahoma 40103 3041 39
2452929 2452929 2022-04-28 Noble Oklahoma 40103 3041 39
2449673 2449673 2022-04-27 Noble Oklahoma 40103 3034 39
2446416 2446416 2022-04-26 Noble Oklahoma 40103 3034 39
2443161 2443161 2022-04-25 Noble Oklahoma 40103 3034 39
2439905 2439905 2022-04-24 Noble Oklahoma 40103 3034 39
2436649 2436649 2022-04-23 Noble Oklahoma 40103 3034 39
2433393 2433393 2022-04-22 Noble Oklahoma 40103 3034 39
2430137 2430137 2022-04-21 Noble Oklahoma 40103 3034 39
2426881 2426881 2022-04-20 Noble Oklahoma 40103 3026 38
2423625 2423625 2022-04-19 Noble Oklahoma 40103 3026 38
2420368 2420368 2022-04-18 Noble Oklahoma 40103 3026 38
2417113 2417113 2022-04-17 Noble Oklahoma 40103 3026 38
2413857 2413857 2022-04-16 Noble Oklahoma 40103 3026 38
2410601 2410601 2022-04-15 Noble Oklahoma 40103 3026 38
2407345 2407345 2022-04-14 Noble Oklahoma 40103 3026 38
2404089 2404089 2022-04-13 Noble Oklahoma 40103 3025 38
2400834 2400834 2022-04-12 Noble Oklahoma 40103 3025 38
2397579 2397579 2022-04-11 Noble Oklahoma 40103 3025 38
2394324 2394324 2022-04-10 Noble Oklahoma 40103 3025 38
2391068 2391068 2022-04-09 Noble Oklahoma 40103 3025 38
2387812 2387812 2022-04-08 Noble Oklahoma 40103 3025 38
2384557 2384557 2022-04-07 Noble Oklahoma 40103 3025 38
2381302 2381302 2022-04-06 Noble Oklahoma 40103 3023 38
2378047 2378047 2022-04-05 Noble Oklahoma 40103 3023 38
2374793 2374793 2022-04-04 Noble Oklahoma 40103 3023 38
2371541 2371541 2022-04-03 Noble Oklahoma 40103 3023 38
2368288 2368288 2022-04-02 Noble Oklahoma 40103 3023 38
2365035 2365035 2022-04-01 Noble Oklahoma 40103 3023 38
2361782 2361782 2022-03-31 Noble Oklahoma 40103 3023 38
2358528 2358528 2022-03-30 Noble Oklahoma 40103 3024 37
2355274 2355274 2022-03-29 Noble Oklahoma 40103 3024 37
2352021 2352021 2022-03-28 Noble Oklahoma 40103 3024 37
2348769 2348769 2022-03-27 Noble Oklahoma 40103 3024 37
2345516 2345516 2022-03-26 Noble Oklahoma 40103 3024 37
2342263 2342263 2022-03-25 Noble Oklahoma 40103 3024 37
2339010 2339010 2022-03-24 Noble Oklahoma 40103 3024 37
2335756 2335756 2022-03-23 Noble Oklahoma 40103 3021 36
2332502 2332502 2022-03-22 Noble Oklahoma 40103 3021 36
2329249 2329249 2022-03-21 Noble Oklahoma 40103 3021 36
2325997 2325997 2022-03-20 Noble Oklahoma 40103 3021 36
2322744 2322744 2022-03-19 Noble Oklahoma 40103 3021 36
2319490 2319490 2022-03-18 Noble Oklahoma 40103 3021 36
2316236 2316236 2022-03-17 Noble Oklahoma 40103 3021 36
2312983 2312983 2022-03-16 Noble Oklahoma 40103 3022 36
2309730 2309730 2022-03-15 Noble Oklahoma 40103 3022 36
2306477 2306477 2022-03-14 Noble Oklahoma 40103 3022 36
2303226 2303226 2022-03-13 Noble Oklahoma 40103 3022 36
2299974 2299974 2022-03-12 Noble Oklahoma 40103 3022 36
2296722 2296722 2022-03-11 Noble Oklahoma 40103 3022 36
2293470 2293470 2022-03-10 Noble Oklahoma 40103 3022 36
2290218 2290218 2022-03-09 Noble Oklahoma 40103 3004 36
2286966 2286966 2022-03-08 Noble Oklahoma 40103 3004 36
2283714 2283714 2022-03-07 Noble Oklahoma 40103 3004 36
2280462 2280462 2022-03-06 Noble Oklahoma 40103 3004 36
2277209 2277209 2022-03-05 Noble Oklahoma 40103 3004 36
2273956 2273956 2022-03-04 Noble Oklahoma 40103 3004 36
2270703 2270703 2022-03-03 Noble Oklahoma 40103 3004 36
2267451 2267451 2022-03-02 Noble Oklahoma 40103 3004 36
2264198 2264198 2022-03-01 Noble Oklahoma 40103 2991 36
2260948 2260948 2022-02-28 Noble Oklahoma 40103 2991 36
2257697 2257697 2022-02-27 Noble Oklahoma 40103 2991 36
2254446 2254446 2022-02-26 Noble Oklahoma 40103 2991 36
2251195 2251195 2022-02-25 Noble Oklahoma 40103 2991 36
2247944 2247944 2022-02-24 Noble Oklahoma 40103 2991 36
2244693 2244693 2022-02-23 Noble Oklahoma 40103 2991 36
2241442 2241442 2022-02-22 Noble Oklahoma 40103 2963 36
2238191 2238191 2022-02-21 Noble Oklahoma 40103 2963 36
2234940 2234940 2022-02-20 Noble Oklahoma 40103 2963 36
2231689 2231689 2022-02-19 Noble Oklahoma 40103 2963 36
2228438 2228438 2022-02-18 Noble Oklahoma 40103 2963 36
2225187 2225187 2022-02-17 Noble Oklahoma 40103 2963 36
2221936 2221936 2022-02-16 Noble Oklahoma 40103 2963 36
2218685 2218685 2022-02-15 Noble Oklahoma 40103 2905 33
2215434 2215434 2022-02-14 Noble Oklahoma 40103 2905 33
2212183 2212183 2022-02-13 Noble Oklahoma 40103 2905 33
2208930 2208930 2022-02-12 Noble Oklahoma 40103 2905 33
2205677 2205677 2022-02-11 Noble Oklahoma 40103 2905 33
2202424 2202424 2022-02-10 Noble Oklahoma 40103 2905 33
2199170 2199170 2022-02-09 Noble Oklahoma 40103 2905 33
2195916 2195916 2022-02-08 Noble Oklahoma 40103 2826 33
2192662 2192662 2022-02-07 Noble Oklahoma 40103 2826 33
2189408 2189408 2022-02-06 Noble Oklahoma 40103 2826 33
2186155 2186155 2022-02-05 Noble Oklahoma 40103 2826 33
2182903 2182903 2022-02-04 Noble Oklahoma 40103 2826 33
2179651 2179651 2022-02-03 Noble Oklahoma 40103 2826 33

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