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

799 rows where county = "Yolo" 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 · 799 ✖

fips 1

county 1

  • Yolo · 799 ✖
Link rowid date ▲ county state fips cases deaths
2499818 2499818 2022-05-13 Yolo California 6113 41061 316
2496560 2496560 2022-05-12 Yolo California 6113 40934 316
2493302 2493302 2022-05-11 Yolo California 6113 40934 316
2490044 2490044 2022-05-10 Yolo California 6113 40934 316
2486787 2486787 2022-05-09 Yolo California 6113 40736 315
2483529 2483529 2022-05-08 Yolo California 6113 40736 315
2480271 2480271 2022-05-07 Yolo California 6113 40736 315
2477013 2477013 2022-05-06 Yolo California 6113 40736 315
2473755 2473755 2022-05-05 Yolo California 6113 40596 315
2470498 2470498 2022-05-04 Yolo California 6113 40596 315
2467242 2467242 2022-05-03 Yolo California 6113 40596 315
2463987 2463987 2022-05-02 Yolo California 6113 40425 314
2460731 2460731 2022-05-01 Yolo California 6113 40425 314
2457475 2457475 2022-04-30 Yolo California 6113 40425 314
2454219 2454219 2022-04-29 Yolo California 6113 40425 314
2450963 2450963 2022-04-28 Yolo California 6113 40331 314
2447707 2447707 2022-04-27 Yolo California 6113 40331 314
2444451 2444451 2022-04-26 Yolo California 6113 40331 314
2441195 2441195 2022-04-25 Yolo California 6113 40225 314
2437939 2437939 2022-04-24 Yolo California 6113 40225 314
2434683 2434683 2022-04-23 Yolo California 6113 40225 314
2431427 2431427 2022-04-22 Yolo California 6113 40225 314
2428171 2428171 2022-04-21 Yolo California 6113 40000 311
2424915 2424915 2022-04-20 Yolo California 6113 40000 311
2421659 2421659 2022-04-19 Yolo California 6113 40000 311
2418403 2418403 2022-04-18 Yolo California 6113 39967 312
2415147 2415147 2022-04-17 Yolo California 6113 39967 312
2411891 2411891 2022-04-16 Yolo California 6113 39967 312
2408635 2408635 2022-04-15 Yolo California 6113 39967 312
2405379 2405379 2022-04-14 Yolo California 6113 39899 312
2402124 2402124 2022-04-13 Yolo California 6113 39782 312
2398869 2398869 2022-04-12 Yolo California 6113 39782 312
2395614 2395614 2022-04-11 Yolo California 6113 39782 314
2392358 2392358 2022-04-10 Yolo California 6113 39782 314
2389102 2389102 2022-04-09 Yolo California 6113 39782 314
2385847 2385847 2022-04-08 Yolo California 6113 39782 314
2382592 2382592 2022-04-07 Yolo California 6113 39588 314
2379337 2379337 2022-04-06 Yolo California 6113 39588 314
2376083 2376083 2022-04-05 Yolo California 6113 39588 314
2372831 2372831 2022-04-04 Yolo California 6113 39542 313
2369578 2369578 2022-04-03 Yolo California 6113 39542 313
2366325 2366325 2022-04-02 Yolo California 6113 39542 313
2363072 2363072 2022-04-01 Yolo California 6113 39542 313
2359818 2359818 2022-03-31 Yolo California 6113 39520 313
2356564 2356564 2022-03-30 Yolo California 6113 39473 313
2353311 2353311 2022-03-29 Yolo California 6113 39459 312
2350059 2350059 2022-03-28 Yolo California 6113 39409 312
2346806 2346806 2022-03-27 Yolo California 6113 39411 311
2343553 2343553 2022-03-26 Yolo California 6113 39411 311
2340300 2340300 2022-03-25 Yolo California 6113 39411 311
2337047 2337047 2022-03-24 Yolo California 6113 39374 308
2333793 2333793 2022-03-23 Yolo California 6113 39349 308
2330539 2330539 2022-03-22 Yolo California 6113 39306 307
2327287 2327287 2022-03-21 Yolo California 6113 39300 308
2324034 2324034 2022-03-20 Yolo California 6113 39251 308
2320780 2320780 2022-03-19 Yolo California 6113 39251 308
2317526 2317526 2022-03-18 Yolo California 6113 39251 308
2314273 2314273 2022-03-17 Yolo California 6113 39244 308
2311020 2311020 2022-03-16 Yolo California 6113 39230 308
2307767 2307767 2022-03-15 Yolo California 6113 39210 308
2304516 2304516 2022-03-14 Yolo California 6113 39170 308
2301264 2301264 2022-03-13 Yolo California 6113 39133 308
2298012 2298012 2022-03-12 Yolo California 6113 39133 308
2294760 2294760 2022-03-11 Yolo California 6113 39133 308
2291508 2291508 2022-03-10 Yolo California 6113 39124 308
2288256 2288256 2022-03-09 Yolo California 6113 39055 306
2285005 2285005 2022-03-08 Yolo California 6113 39043 306
2281753 2281753 2022-03-07 Yolo California 6113 38991 306
2278500 2278500 2022-03-06 Yolo California 6113 38965 306
2275247 2275247 2022-03-05 Yolo California 6113 38965 306
2271994 2271994 2022-03-04 Yolo California 6113 38965 306
2268742 2268742 2022-03-03 Yolo California 6113 38908 305
2265489 2265489 2022-03-02 Yolo California 6113 38863 299
2262238 2262238 2022-03-01 Yolo California 6113 38816 299
2258987 2258987 2022-02-28 Yolo California 6113 38806 299
2255736 2255736 2022-02-27 Yolo California 6113 38677 296
2252485 2252485 2022-02-26 Yolo California 6113 38677 296
2249234 2249234 2022-02-25 Yolo California 6113 38677 296
2245983 2245983 2022-02-24 Yolo California 6113 38652 296
2242732 2242732 2022-02-23 Yolo California 6113 38548 293
2239481 2239481 2022-02-22 Yolo California 6113 38539 292
2236230 2236230 2022-02-21 Yolo California 6113 38384 293
2232979 2232979 2022-02-20 Yolo California 6113 38384 293
2229728 2229728 2022-02-19 Yolo California 6113 38384 293
2226477 2226477 2022-02-18 Yolo California 6113 38384 293
2223226 2223226 2022-02-17 Yolo California 6113 38305 292
2219975 2219975 2022-02-16 Yolo California 6113 38342 289
2216724 2216724 2022-02-15 Yolo California 6113 38213 286
2213473 2213473 2022-02-14 Yolo California 6113 38158 286
2210221 2210221 2022-02-13 Yolo California 6113 37874 286
2206968 2206968 2022-02-12 Yolo California 6113 37874 286
2203715 2203715 2022-02-11 Yolo California 6113 37874 286
2200462 2200462 2022-02-10 Yolo California 6113 37689 281
2197208 2197208 2022-02-09 Yolo California 6113 37646 281
2193954 2193954 2022-02-08 Yolo California 6113 37191 281
2190700 2190700 2022-02-07 Yolo California 6113 36968 281
2187447 2187447 2022-02-06 Yolo California 6113 36798 281
2184194 2184194 2022-02-05 Yolo California 6113 36798 281
2180942 2180942 2022-02-04 Yolo California 6113 36798 281
2177691 2177691 2022-02-03 Yolo California 6113 36516 281

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