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

795 rows where fips = 6111 and state = "California" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • California · 795 ✖

fips 1

  • 6111 · 795 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2499817 2499817 2022-05-13 Ventura California 6111 186062 1498
2496559 2496559 2022-05-12 Ventura California 6111 185429 1498
2493301 2493301 2022-05-11 Ventura California 6111 185429 1498
2490043 2490043 2022-05-10 Ventura California 6111 185429 1498
2486786 2486786 2022-05-09 Ventura California 6111 184928 1492
2483528 2483528 2022-05-08 Ventura California 6111 184928 1492
2480270 2480270 2022-05-07 Ventura California 6111 184928 1492
2477012 2477012 2022-05-06 Ventura California 6111 184928 1492
2473754 2473754 2022-05-05 Ventura California 6111 184452 1492
2470497 2470497 2022-05-04 Ventura California 6111 184452 1492
2467241 2467241 2022-05-03 Ventura California 6111 184452 1492
2463986 2463986 2022-05-02 Ventura California 6111 184065 1487
2460730 2460730 2022-05-01 Ventura California 6111 184065 1487
2457474 2457474 2022-04-30 Ventura California 6111 184065 1487
2454218 2454218 2022-04-29 Ventura California 6111 184065 1487
2450962 2450962 2022-04-28 Ventura California 6111 183764 1487
2447706 2447706 2022-04-27 Ventura California 6111 183764 1487
2444450 2444450 2022-04-26 Ventura California 6111 183764 1487
2441194 2441194 2022-04-25 Ventura California 6111 183430 1487
2437938 2437938 2022-04-24 Ventura California 6111 183430 1482
2434682 2434682 2022-04-23 Ventura California 6111 183430 1482
2431426 2431426 2022-04-22 Ventura California 6111 183430 1482
2428170 2428170 2022-04-21 Ventura California 6111 183210 1482
2424914 2424914 2022-04-20 Ventura California 6111 183210 1482
2421658 2421658 2022-04-19 Ventura California 6111 183210 1482
2418402 2418402 2022-04-18 Ventura California 6111 182971 1482
2415146 2415146 2022-04-17 Ventura California 6111 182971 1476
2411890 2411890 2022-04-16 Ventura California 6111 182971 1476
2408634 2408634 2022-04-15 Ventura California 6111 182971 1476
2405378 2405378 2022-04-14 Ventura California 6111 182864 1476
2402123 2402123 2022-04-13 Ventura California 6111 182625 1476
2398868 2398868 2022-04-12 Ventura California 6111 182625 1476
2395613 2395613 2022-04-11 Ventura California 6111 182625 1476
2392357 2392357 2022-04-10 Ventura California 6111 182625 1469
2389101 2389101 2022-04-09 Ventura California 6111 182625 1469
2385846 2385846 2022-04-08 Ventura California 6111 182625 1469
2382591 2382591 2022-04-07 Ventura California 6111 182461 1469
2379336 2379336 2022-04-06 Ventura California 6111 182461 1469
2376082 2376082 2022-04-05 Ventura California 6111 182461 1469
2372830 2372830 2022-04-04 Ventura California 6111 182326 1469
2369577 2369577 2022-04-03 Ventura California 6111 182326 1462
2366324 2366324 2022-04-02 Ventura California 6111 182326 1462
2363071 2363071 2022-04-01 Ventura California 6111 182326 1462
2359817 2359817 2022-03-31 Ventura California 6111 182266 1462
2356563 2356563 2022-03-30 Ventura California 6111 182213 1462
2353310 2353310 2022-03-29 Ventura California 6111 182134 1462
2350058 2350058 2022-03-28 Ventura California 6111 182098 1462
2346805 2346805 2022-03-27 Ventura California 6111 181957 1457
2343552 2343552 2022-03-26 Ventura California 6111 181957 1457
2340299 2340299 2022-03-25 Ventura California 6111 181957 1457
2337046 2337046 2022-03-24 Ventura California 6111 181914 1457
2333792 2333792 2022-03-23 Ventura California 6111 181837 1457
2330538 2330538 2022-03-22 Ventura California 6111 181784 1457
2327286 2327286 2022-03-21 Ventura California 6111 181761 1457
2324033 2324033 2022-03-20 Ventura California 6111 181627 1454
2320779 2320779 2022-03-19 Ventura California 6111 181627 1454
2317525 2317525 2022-03-18 Ventura California 6111 181627 1454
2314272 2314272 2022-03-17 Ventura California 6111 181459 1454
2311019 2311019 2022-03-16 Ventura California 6111 181375 1454
2307766 2307766 2022-03-15 Ventura California 6111 181332 1454
2304515 2304515 2022-03-14 Ventura California 6111 181305 1454
2301263 2301263 2022-03-13 Ventura California 6111 181157 1445
2298011 2298011 2022-03-12 Ventura California 6111 181157 1445
2294759 2294759 2022-03-11 Ventura California 6111 181157 1445
2291507 2291507 2022-03-10 Ventura California 6111 181077 1448
2288255 2288255 2022-03-09 Ventura California 6111 180998 1447
2285004 2285004 2022-03-08 Ventura California 6111 181078 1445
2281752 2281752 2022-03-07 Ventura California 6111 181011 1445
2278499 2278499 2022-03-06 Ventura California 6111 180858 1436
2275246 2275246 2022-03-05 Ventura California 6111 180858 1436
2271993 2271993 2022-03-04 Ventura California 6111 180858 1436
2268741 2268741 2022-03-03 Ventura California 6111 180962 1434
2265488 2265488 2022-03-02 Ventura California 6111 180815 1434
2262237 2262237 2022-03-01 Ventura California 6111 180757 1425
2258986 2258986 2022-02-28 Ventura California 6111 180803 1425
2255735 2255735 2022-02-27 Ventura California 6111 180435 1421
2252484 2252484 2022-02-26 Ventura California 6111 180435 1421
2249233 2249233 2022-02-25 Ventura California 6111 180435 1421
2245982 2245982 2022-02-24 Ventura California 6111 180306 1409
2242731 2242731 2022-02-23 Ventura California 6111 180129 1409
2239480 2239480 2022-02-22 Ventura California 6111 180004 1401
2236229 2236229 2022-02-21 Ventura California 6111 179396 1399
2232978 2232978 2022-02-20 Ventura California 6111 179396 1399
2229727 2229727 2022-02-19 Ventura California 6111 179396 1399
2226476 2226476 2022-02-18 Ventura California 6111 179396 1399
2223225 2223225 2022-02-17 Ventura California 6111 179182 1382
2219974 2219974 2022-02-16 Ventura California 6111 179216 1382
2216723 2216723 2022-02-15 Ventura California 6111 178999 1370
2213472 2213472 2022-02-14 Ventura California 6111 178696 1370
2210220 2210220 2022-02-13 Ventura California 6111 178010 1359
2206967 2206967 2022-02-12 Ventura California 6111 178010 1359
2203714 2203714 2022-02-11 Ventura California 6111 178010 1359
2200461 2200461 2022-02-10 Ventura California 6111 177527 1338
2197207 2197207 2022-02-09 Ventura California 6111 177086 1338
2193953 2193953 2022-02-08 Ventura California 6111 176160 1324
2190699 2190699 2022-02-07 Ventura California 6111 175491 1323
2187446 2187446 2022-02-06 Ventura California 6111 174788 1322
2184193 2184193 2022-02-05 Ventura California 6111 174788 1322
2180941 2180941 2022-02-04 Ventura California 6111 174788 1322
2177690 2177690 2022-02-03 Ventura California 6111 174161 1306

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