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

137 rows where fips = 6055 sorted by date descending

View and edit SQL

Suggested facets: deaths, date (date)

state

fips

  • 6055 · 137

county

Link rowid date ▲ county state fips cases deaths
316658 2020-07-11 Napa California 6055 497 4
313560 2020-07-10 Napa California 6055 478 4
310468 2020-07-09 Napa California 6055 469 4
307373 2020-07-08 Napa California 6055 460 4
304283 2020-07-07 Napa California 6055 455 4
301195 2020-07-06 Napa California 6055 451 4
298111 2020-07-05 Napa California 6055 427 4
295027 2020-07-04 Napa California 6055 389 4
291945 2020-07-03 Napa California 6055 377 4
288869 2020-07-02 Napa California 6055 348 4
285795 2020-07-01 Napa California 6055 343 4
282724 2020-06-30 Napa California 6055 318 4
279657 2020-06-29 Napa California 6055 311 4
276590 2020-06-28 Napa California 6055 283 4
273522 2020-06-27 Napa California 6055 278 4
270454 2020-06-26 Napa California 6055 271 4
267394 2020-06-25 Napa California 6055 259 4
264339 2020-06-24 Napa California 6055 252 4
261289 2020-06-23 Napa California 6055 246 4
258240 2020-06-22 Napa California 6055 240 4
255193 2020-06-21 Napa California 6055 225 4
252146 2020-06-20 Napa California 6055 225 4
249107 2020-06-19 Napa California 6055 217 4
246072 2020-06-18 Napa California 6055 207 4
243040 2020-06-17 Napa California 6055 203 4
240007 2020-06-16 Napa California 6055 200 3
236976 2020-06-15 Napa California 6055 191 3
233948 2020-06-14 Napa California 6055 184 3
230921 2020-06-13 Napa California 6055 184 3
227895 2020-06-12 Napa California 6055 169 3
224871 2020-06-11 Napa California 6055 164 3
221849 2020-06-10 Napa California 6055 162 3
218833 2020-06-09 Napa California 6055 158 3
215818 2020-06-08 Napa California 6055 154 3
212807 2020-06-07 Napa California 6055 142 3
209800 2020-06-06 Napa California 6055 142 3
206795 2020-06-05 Napa California 6055 130 3
203794 2020-06-04 Napa California 6055 127 3
200795 2020-06-03 Napa California 6055 125 3
197800 2020-06-02 Napa California 6055 115 3
194808 2020-06-01 Napa California 6055 115 3
191819 2020-05-31 Napa California 6055 114 3
188833 2020-05-30 Napa California 6055 114 3
185849 2020-05-29 Napa California 6055 114 3
182873 2020-05-28 Napa California 6055 113 3
179899 2020-05-27 Napa California 6055 110 3
176935 2020-05-26 Napa California 6055 110 3
173971 2020-05-25 Napa California 6055 105 3
171007 2020-05-24 Napa California 6055 102 3
168046 2020-05-23 Napa California 6055 102 3
165089 2020-05-22 Napa California 6055 97 3
162137 2020-05-21 Napa California 6055 96 3
159189 2020-05-20 Napa California 6055 95 3
156243 2020-05-19 Napa California 6055 93 3
153307 2020-05-18 Napa California 6055 93 3
150375 2020-05-17 Napa California 6055 91 3
147446 2020-05-16 Napa California 6055 91 3
144521 2020-05-15 Napa California 6055 84 3
141601 2020-05-14 Napa California 6055 84 3
138684 2020-05-13 Napa California 6055 82 3
135772 2020-05-12 Napa California 6055 82 3
132861 2020-05-11 Napa California 6055 80 3
129950 2020-05-10 Napa California 6055 79 2
127039 2020-05-09 Napa California 6055 79 2
124133 2020-05-08 Napa California 6055 79 2
121232 2020-05-07 Napa California 6055 79 2
118344 2020-05-06 Napa California 6055 79 2
115464 2020-05-05 Napa California 6055 76 2
112585 2020-05-04 Napa California 6055 75 2
109714 2020-05-03 Napa California 6055 71 2
106849 2020-05-02 Napa California 6055 71 2
103988 2020-05-01 Napa California 6055 69 2
101137 2020-04-30 Napa California 6055 68 2
98291 2020-04-29 Napa California 6055 67 2
95450 2020-04-28 Napa California 6055 67 2
92621 2020-04-27 Napa California 6055 65 2
89806 2020-04-26 Napa California 6055 61 2
86992 2020-04-25 Napa California 6055 61 2
84187 2020-04-24 Napa California 6055 58 2
81390 2020-04-23 Napa California 6055 58 2
78599 2020-04-22 Napa California 6055 58 2
75818 2020-04-21 Napa California 6055 54 2
73045 2020-04-20 Napa California 6055 49 2
70279 2020-04-19 Napa California 6055 47 2
67520 2020-04-18 Napa California 6055 47 2
64775 2020-04-17 Napa California 6055 45 2
62045 2020-04-16 Napa California 6055 40 2
59329 2020-04-15 Napa California 6055 39 2
56624 2020-04-14 Napa California 6055 39 2
53935 2020-04-13 Napa California 6055 35 2
51259 2020-04-12 Napa California 6055 35 2
48600 2020-04-11 Napa California 6055 35 2
45973 2020-04-10 Napa California 6055 33 2
43376 2020-04-09 Napa California 6055 29 2
40807 2020-04-08 Napa California 6055 26 2
38266 2020-04-07 Napa California 6055 24 2
35780 2020-04-06 Napa California 6055 22 2
33335 2020-04-05 Napa California 6055 21 2
30929 2020-04-04 Napa California 6055 21 2
28571 2020-04-03 Napa California 6055 21 2

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