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

808 rows where fips = 6055 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • California 808

fips 1

  • 6055 · 808 ✖

county 1

  • Napa 808
Link rowid date ▲ county state fips cases deaths
2499789 2499789 2022-05-13 Napa California 6055 27765 143
2496531 2496531 2022-05-12 Napa California 6055 27708 143
2493273 2493273 2022-05-11 Napa California 6055 27708 143
2490015 2490015 2022-05-10 Napa California 6055 27708 143
2486758 2486758 2022-05-09 Napa California 6055 27572 143
2483500 2483500 2022-05-08 Napa California 6055 27572 143
2480242 2480242 2022-05-07 Napa California 6055 27572 143
2476984 2476984 2022-05-06 Napa California 6055 27572 143
2473726 2473726 2022-05-05 Napa California 6055 27463 143
2470469 2470469 2022-05-04 Napa California 6055 27463 143
2467213 2467213 2022-05-03 Napa California 6055 27463 143
2463958 2463958 2022-05-02 Napa California 6055 27348 143
2460702 2460702 2022-05-01 Napa California 6055 27348 143
2457446 2457446 2022-04-30 Napa California 6055 27348 143
2454190 2454190 2022-04-29 Napa California 6055 27348 143
2450934 2450934 2022-04-28 Napa California 6055 27215 143
2447678 2447678 2022-04-27 Napa California 6055 27215 143
2444422 2444422 2022-04-26 Napa California 6055 27215 143
2441166 2441166 2022-04-25 Napa California 6055 27098 143
2437910 2437910 2022-04-24 Napa California 6055 27098 143
2434654 2434654 2022-04-23 Napa California 6055 27098 143
2431398 2431398 2022-04-22 Napa California 6055 27098 143
2428142 2428142 2022-04-21 Napa California 6055 26994 143
2424886 2424886 2022-04-20 Napa California 6055 26994 143
2421630 2421630 2022-04-19 Napa California 6055 26994 143
2418374 2418374 2022-04-18 Napa California 6055 26907 143
2415118 2415118 2022-04-17 Napa California 6055 26907 143
2411862 2411862 2022-04-16 Napa California 6055 26907 143
2408606 2408606 2022-04-15 Napa California 6055 26907 143
2405350 2405350 2022-04-14 Napa California 6055 26870 143
2402095 2402095 2022-04-13 Napa California 6055 26793 144
2398840 2398840 2022-04-12 Napa California 6055 26793 144
2395585 2395585 2022-04-11 Napa California 6055 26793 144
2392329 2392329 2022-04-10 Napa California 6055 26793 144
2389073 2389073 2022-04-09 Napa California 6055 26793 144
2385818 2385818 2022-04-08 Napa California 6055 26793 144
2382563 2382563 2022-04-07 Napa California 6055 26759 143
2379308 2379308 2022-04-06 Napa California 6055 26759 143
2376054 2376054 2022-04-05 Napa California 6055 26759 143
2372802 2372802 2022-04-04 Napa California 6055 26726 143
2369549 2369549 2022-04-03 Napa California 6055 26726 143
2366296 2366296 2022-04-02 Napa California 6055 26726 143
2363043 2363043 2022-04-01 Napa California 6055 26726 143
2359789 2359789 2022-03-31 Napa California 6055 26714 141
2356535 2356535 2022-03-30 Napa California 6055 26696 141
2353282 2353282 2022-03-29 Napa California 6055 26687 140
2350030 2350030 2022-03-28 Napa California 6055 26687 140
2346777 2346777 2022-03-27 Napa California 6055 26665 139
2343524 2343524 2022-03-26 Napa California 6055 26665 139
2340271 2340271 2022-03-25 Napa California 6055 26665 139
2337018 2337018 2022-03-24 Napa California 6055 26655 139
2333764 2333764 2022-03-23 Napa California 6055 26647 139
2330510 2330510 2022-03-22 Napa California 6055 26643 138
2327258 2327258 2022-03-21 Napa California 6055 26641 138
2324005 2324005 2022-03-20 Napa California 6055 26613 138
2320751 2320751 2022-03-19 Napa California 6055 26613 138
2317497 2317497 2022-03-18 Napa California 6055 26613 138
2314244 2314244 2022-03-17 Napa California 6055 26597 138
2310991 2310991 2022-03-16 Napa California 6055 26620 138
2307738 2307738 2022-03-15 Napa California 6055 26612 138
2304487 2304487 2022-03-14 Napa California 6055 26602 138
2301235 2301235 2022-03-13 Napa California 6055 26547 138
2297983 2297983 2022-03-12 Napa California 6055 26547 138
2294731 2294731 2022-03-11 Napa California 6055 26547 138
2291479 2291479 2022-03-10 Napa California 6055 26524 138
2288227 2288227 2022-03-09 Napa California 6055 26489 137
2284976 2284976 2022-03-08 Napa California 6055 26461 136
2281724 2281724 2022-03-07 Napa California 6055 26418 136
2278471 2278471 2022-03-06 Napa California 6055 26366 134
2275218 2275218 2022-03-05 Napa California 6055 26366 134
2271965 2271965 2022-03-04 Napa California 6055 26366 134
2268713 2268713 2022-03-03 Napa California 6055 26343 134
2265460 2265460 2022-03-02 Napa California 6055 26295 134
2262209 2262209 2022-03-01 Napa California 6055 26268 129
2258958 2258958 2022-02-28 Napa California 6055 26267 129
2255707 2255707 2022-02-27 Napa California 6055 26172 130
2252456 2252456 2022-02-26 Napa California 6055 26172 130
2249205 2249205 2022-02-25 Napa California 6055 26172 130
2245954 2245954 2022-02-24 Napa California 6055 26136 128
2242703 2242703 2022-02-23 Napa California 6055 26084 128
2239452 2239452 2022-02-22 Napa California 6055 26059 128
2236201 2236201 2022-02-21 Napa California 6055 25903 127
2232950 2232950 2022-02-20 Napa California 6055 25903 127
2229699 2229699 2022-02-19 Napa California 6055 25903 127
2226448 2226448 2022-02-18 Napa California 6055 25903 127
2223197 2223197 2022-02-17 Napa California 6055 25830 128
2219946 2219946 2022-02-16 Napa California 6055 25772 127
2216695 2216695 2022-02-15 Napa California 6055 25716 127
2213444 2213444 2022-02-14 Napa California 6055 25683 127
2210192 2210192 2022-02-13 Napa California 6055 25470 124
2206939 2206939 2022-02-12 Napa California 6055 25470 124
2203686 2203686 2022-02-11 Napa California 6055 25470 124
2200433 2200433 2022-02-10 Napa California 6055 25369 121
2197179 2197179 2022-02-09 Napa California 6055 25257 121
2193924 2193924 2022-02-08 Napa California 6055 24148 120
2190671 2190671 2022-02-07 Napa California 6055 24141 120
2187418 2187418 2022-02-06 Napa California 6055 23884 118
2184165 2184165 2022-02-05 Napa California 6055 23884 118
2180913 2180913 2022-02-04 Napa California 6055 23884 118
2177662 2177662 2022-02-03 Napa California 6055 23770 117

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 63.32ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette