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 = 6097 sorted by date descending

View and edit SQL

Suggested facets: deaths, date (date)

state

fips

  • 6097 · 137

county

Link rowid date ▲ county state fips cases deaths
316679 2020-07-11 Sonoma California 6097 1650 14
313581 2020-07-10 Sonoma California 6097 1650 14
310489 2020-07-09 Sonoma California 6097 1561 14
307394 2020-07-08 Sonoma California 6097 1519 14
304304 2020-07-07 Sonoma California 6097 1487 14
301216 2020-07-06 Sonoma California 6097 1466 12
298132 2020-07-05 Sonoma California 6097 1370 11
295048 2020-07-04 Sonoma California 6097 1359 11
291966 2020-07-03 Sonoma California 6097 1267 11
288890 2020-07-02 Sonoma California 6097 1267 10
285816 2020-07-01 Sonoma California 6097 1229 9
282745 2020-06-30 Sonoma California 6097 1185 7
279678 2020-06-29 Sonoma California 6097 1136 7
276611 2020-06-28 Sonoma California 6097 1118 5
273543 2020-06-27 Sonoma California 6097 1092 5
270475 2020-06-26 Sonoma California 6097 1006 5
267415 2020-06-25 Sonoma California 6097 1006 5
264360 2020-06-24 Sonoma California 6097 974 5
261310 2020-06-23 Sonoma California 6097 956 5
258261 2020-06-22 Sonoma California 6097 935 5
255214 2020-06-21 Sonoma California 6097 885 5
252167 2020-06-20 Sonoma California 6097 835 4
249128 2020-06-19 Sonoma California 6097 835 4
246093 2020-06-18 Sonoma California 6097 822 4
243061 2020-06-17 Sonoma California 6097 803 4
240028 2020-06-16 Sonoma California 6097 774 4
236997 2020-06-15 Sonoma California 6097 765 4
233969 2020-06-14 Sonoma California 6097 758 4
230942 2020-06-13 Sonoma California 6097 752 4
227916 2020-06-12 Sonoma California 6097 722 4
224892 2020-06-11 Sonoma California 6097 701 4
221870 2020-06-10 Sonoma California 6097 671 4
218854 2020-06-09 Sonoma California 6097 671 4
215839 2020-06-08 Sonoma California 6097 664 4
212828 2020-06-07 Sonoma California 6097 653 4
209821 2020-06-06 Sonoma California 6097 642 4
206816 2020-06-05 Sonoma California 6097 624 4
203815 2020-06-04 Sonoma California 6097 610 4
200816 2020-06-03 Sonoma California 6097 593 4
197821 2020-06-02 Sonoma California 6097 579 4
194829 2020-06-01 Sonoma California 6097 566 4
191840 2020-05-31 Sonoma California 6097 564 4
188854 2020-05-30 Sonoma California 6097 553 4
185870 2020-05-29 Sonoma California 6097 548 4
182894 2020-05-28 Sonoma California 6097 531 4
179920 2020-05-27 Sonoma California 6097 530 4
176956 2020-05-26 Sonoma California 6097 524 4
173992 2020-05-25 Sonoma California 6097 515 4
171028 2020-05-24 Sonoma California 6097 500 4
168067 2020-05-23 Sonoma California 6097 482 4
165110 2020-05-22 Sonoma California 6097 467 4
162157 2020-05-21 Sonoma California 6097 433 4
159209 2020-05-20 Sonoma California 6097 411 4
156263 2020-05-19 Sonoma California 6097 411 4
153327 2020-05-18 Sonoma California 6097 391 4
150395 2020-05-17 Sonoma California 6097 387 4
147466 2020-05-16 Sonoma California 6097 373 4
144541 2020-05-15 Sonoma California 6097 364 4
141621 2020-05-14 Sonoma California 6097 351 4
138704 2020-05-13 Sonoma California 6097 337 4
135792 2020-05-12 Sonoma California 6097 312 5
132881 2020-05-11 Sonoma California 6097 312 4
129970 2020-05-10 Sonoma California 6097 309 4
127059 2020-05-09 Sonoma California 6097 309 4
124153 2020-05-08 Sonoma California 6097 300 4
121252 2020-05-07 Sonoma California 6097 292 4
118364 2020-05-06 Sonoma California 6097 286 4
115484 2020-05-05 Sonoma California 6097 261 4
112605 2020-05-04 Sonoma California 6097 261 4
109734 2020-05-03 Sonoma California 6097 257 3
106869 2020-05-02 Sonoma California 6097 252 3
104008 2020-05-01 Sonoma California 6097 248 3
101157 2020-04-30 Sonoma California 6097 244 2
98311 2020-04-29 Sonoma California 6097 232 2
95470 2020-04-28 Sonoma California 6097 228 2
92641 2020-04-27 Sonoma California 6097 222 2
89826 2020-04-26 Sonoma California 6097 220 2
87012 2020-04-25 Sonoma California 6097 218 2
84207 2020-04-24 Sonoma California 6097 217 2
81410 2020-04-23 Sonoma California 6097 216 2
78619 2020-04-22 Sonoma California 6097 194 2
75838 2020-04-21 Sonoma California 6097 192 2
73065 2020-04-20 Sonoma California 6097 182 2
70299 2020-04-19 Sonoma California 6097 181 2
67540 2020-04-18 Sonoma California 6097 180 2
64795 2020-04-17 Sonoma California 6097 180 2
62065 2020-04-16 Sonoma California 6097 172 2
59349 2020-04-15 Sonoma California 6097 163 2
56644 2020-04-14 Sonoma California 6097 160 2
53955 2020-04-13 Sonoma California 6097 152 2
51279 2020-04-12 Sonoma California 6097 147 2
48620 2020-04-11 Sonoma California 6097 145 2
45993 2020-04-10 Sonoma California 6097 145 2
43396 2020-04-09 Sonoma California 6097 136 1
40827 2020-04-08 Sonoma California 6097 123 1
38286 2020-04-07 Sonoma California 6097 120 1
35800 2020-04-06 Sonoma California 6097 115 1
33355 2020-04-05 Sonoma California 6097 107 1
30949 2020-04-04 Sonoma California 6097 105 1
28591 2020-04-03 Sonoma California 6097 100 1

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