home / covid

Menu
  • GraphQL API

ny_times_us_counties

Table actions
  • GraphQL API for ny_times_us_counties
⚠️ 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

813 rows where fips = 6067 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • California 813

fips 1

  • 6067 · 813 ✖

county 1

  • Sacramento 813
Link rowid date ▲ county state fips cases deaths
2499795 2499795 2022-05-13 Sacramento California 6067 314407 3159
2496537 2496537 2022-05-12 Sacramento California 6067 313544 3159
2493279 2493279 2022-05-11 Sacramento California 6067 313543 3159
2490021 2490021 2022-05-10 Sacramento California 6067 313543 3155
2486764 2486764 2022-05-09 Sacramento California 6067 312308 3155
2483506 2483506 2022-05-08 Sacramento California 6067 312308 3155
2480248 2480248 2022-05-07 Sacramento California 6067 312308 3155
2476990 2476990 2022-05-06 Sacramento California 6067 312308 3155
2473732 2473732 2022-05-05 Sacramento California 6067 311588 3155
2470475 2470475 2022-05-04 Sacramento California 6067 311587 3155
2467219 2467219 2022-05-03 Sacramento California 6067 311587 3147
2463964 2463964 2022-05-02 Sacramento California 6067 310696 3147
2460708 2460708 2022-05-01 Sacramento California 6067 310696 3147
2457452 2457452 2022-04-30 Sacramento California 6067 310696 3147
2454196 2454196 2022-04-29 Sacramento California 6067 310696 3147
2450940 2450940 2022-04-28 Sacramento California 6067 309120 3147
2447684 2447684 2022-04-27 Sacramento California 6067 309119 3129
2444428 2444428 2022-04-26 Sacramento California 6067 309119 3129
2441172 2441172 2022-04-25 Sacramento California 6067 307868 3129
2437916 2437916 2022-04-24 Sacramento California 6067 307868 3129
2434660 2434660 2022-04-23 Sacramento California 6067 307868 3129
2431404 2431404 2022-04-22 Sacramento California 6067 307868 3129
2428148 2428148 2022-04-21 Sacramento California 6067 306301 3129
2424892 2424892 2022-04-20 Sacramento California 6067 306300 3129
2421636 2421636 2022-04-19 Sacramento California 6067 306300 3116
2418380 2418380 2022-04-18 Sacramento California 6067 305497 3116
2415124 2415124 2022-04-17 Sacramento California 6067 305497 3116
2411868 2411868 2022-04-16 Sacramento California 6067 305497 3116
2408612 2408612 2022-04-15 Sacramento California 6067 305497 3116
2405356 2405356 2022-04-14 Sacramento California 6067 304840 3116
2402101 2402101 2022-04-13 Sacramento California 6067 304009 3116
2398846 2398846 2022-04-12 Sacramento California 6067 304009 3100
2395591 2395591 2022-04-11 Sacramento California 6067 304008 3100
2392335 2392335 2022-04-10 Sacramento California 6067 304008 3100
2389079 2389079 2022-04-09 Sacramento California 6067 304008 3100
2385824 2385824 2022-04-08 Sacramento California 6067 304008 3100
2382569 2382569 2022-04-07 Sacramento California 6067 303451 3100
2379314 2379314 2022-04-06 Sacramento California 6067 303450 3080
2376060 2376060 2022-04-05 Sacramento California 6067 303450 3080
2372808 2372808 2022-04-04 Sacramento California 6067 303101 3080
2369555 2369555 2022-04-03 Sacramento California 6067 303101 3080
2366302 2366302 2022-04-02 Sacramento California 6067 303101 3080
2363049 2363049 2022-04-01 Sacramento California 6067 303101 3080
2359795 2359795 2022-03-31 Sacramento California 6067 302964 3080
2356541 2356541 2022-03-30 Sacramento California 6067 302877 3068
2353288 2353288 2022-03-29 Sacramento California 6067 302726 3068
2350036 2350036 2022-03-28 Sacramento California 6067 302691 3068
2346783 2346783 2022-03-27 Sacramento California 6067 302366 3068
2343530 2343530 2022-03-26 Sacramento California 6067 302366 3068
2340277 2340277 2022-03-25 Sacramento California 6067 302366 3068
2337024 2337024 2022-03-24 Sacramento California 6067 302235 3043
2333770 2333770 2022-03-23 Sacramento California 6067 302194 3043
2330516 2330516 2022-03-22 Sacramento California 6067 302154 3043
2327264 2327264 2022-03-21 Sacramento California 6067 302137 3043
2324011 2324011 2022-03-20 Sacramento California 6067 301675 3043
2320757 2320757 2022-03-19 Sacramento California 6067 301675 3043
2317503 2317503 2022-03-18 Sacramento California 6067 301675 3043
2314250 2314250 2022-03-17 Sacramento California 6067 301529 3043
2310997 2310997 2022-03-16 Sacramento California 6067 301513 3043
2307744 2307744 2022-03-15 Sacramento California 6067 301479 3013
2304493 2304493 2022-03-14 Sacramento California 6067 301512 3013
2301241 2301241 2022-03-13 Sacramento California 6067 301316 3013
2297989 2297989 2022-03-12 Sacramento California 6067 301316 3013
2294737 2294737 2022-03-11 Sacramento California 6067 301316 3013
2291485 2291485 2022-03-10 Sacramento California 6067 301170 3013
2288233 2288233 2022-03-09 Sacramento California 6067 300969 3013
2284982 2284982 2022-03-08 Sacramento California 6067 300772 2971
2281730 2281730 2022-03-07 Sacramento California 6067 300628 2971
2278477 2278477 2022-03-06 Sacramento California 6067 300180 2971
2275224 2275224 2022-03-05 Sacramento California 6067 300180 2971
2271971 2271971 2022-03-04 Sacramento California 6067 300180 2971
2268719 2268719 2022-03-03 Sacramento California 6067 299984 2971
2265466 2265466 2022-03-02 Sacramento California 6067 299636 2971
2262215 2262215 2022-03-01 Sacramento California 6067 299585 2932
2258964 2258964 2022-02-28 Sacramento California 6067 299474 2932
2255713 2255713 2022-02-27 Sacramento California 6067 298886 2932
2252462 2252462 2022-02-26 Sacramento California 6067 298886 2932
2249211 2249211 2022-02-25 Sacramento California 6067 298886 2932
2245960 2245960 2022-02-24 Sacramento California 6067 298604 2927
2242709 2242709 2022-02-23 Sacramento California 6067 297860 2897
2239458 2239458 2022-02-22 Sacramento California 6067 297659 2887
2236207 2236207 2022-02-21 Sacramento California 6067 296151 2878
2232956 2232956 2022-02-20 Sacramento California 6067 296151 2878
2229705 2229705 2022-02-19 Sacramento California 6067 296151 2878
2226454 2226454 2022-02-18 Sacramento California 6067 296151 2878
2223203 2223203 2022-02-17 Sacramento California 6067 295487 2878
2219952 2219952 2022-02-16 Sacramento California 6067 295431 2847
2216701 2216701 2022-02-15 Sacramento California 6067 295028 2837
2213450 2213450 2022-02-14 Sacramento California 6067 294428 2816
2210198 2210198 2022-02-13 Sacramento California 6067 292828 2802
2206945 2206945 2022-02-12 Sacramento California 6067 292828 2802
2203692 2203692 2022-02-11 Sacramento California 6067 292828 2802
2200439 2200439 2022-02-10 Sacramento California 6067 292105 2802
2197185 2197185 2022-02-09 Sacramento California 6067 290324 2781
2193930 2193930 2022-02-08 Sacramento California 6067 288679 2771
2190677 2190677 2022-02-07 Sacramento California 6067 287198 2746
2187424 2187424 2022-02-06 Sacramento California 6067 285282 2728
2184171 2184171 2022-02-05 Sacramento California 6067 285282 2728
2180919 2180919 2022-02-04 Sacramento California 6067 285282 2728
2177668 2177668 2022-02-03 Sacramento California 6067 283923 2715

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);
Powered by Datasette · Queries took 66.901ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette