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

139 rows where fips = 6095 sorted by date descending

View and edit SQL

Suggested facets: deaths, date (date)

state

fips

  • 6095 · 139

county

Link rowid date ▲ county state fips cases deaths
316678 2020-07-11 Solano California 6095 2080 28
313580 2020-07-10 Solano California 6095 2080 28
310488 2020-07-09 Solano California 6095 1990 27
307393 2020-07-08 Solano California 6095 1927 27
304303 2020-07-07 Solano California 6095 1831 27
301215 2020-07-06 Solano California 6095 1745 25
298131 2020-07-05 Solano California 6095 1553 25
295047 2020-07-04 Solano California 6095 1501 25
291965 2020-07-03 Solano California 6095 1481 25
288889 2020-07-02 Solano California 6095 1481 25
285815 2020-07-01 Solano California 6095 1407 25
282744 2020-06-30 Solano California 6095 1293 24
279677 2020-06-29 Solano California 6095 1131 24
276610 2020-06-28 Solano California 6095 1123 23
273542 2020-06-27 Solano California 6095 1073 23
270474 2020-06-26 Solano California 6095 1039 23
267414 2020-06-25 Solano California 6095 984 23
264359 2020-06-24 Solano California 6095 946 23
261309 2020-06-23 Solano California 6095 865 23
258260 2020-06-22 Solano California 6095 865 23
255213 2020-06-21 Solano California 6095 865 23
252166 2020-06-20 Solano California 6095 865 23
249127 2020-06-19 Solano California 6095 865 23
246092 2020-06-18 Solano California 6095 816 23
243060 2020-06-17 Solano California 6095 797 23
240027 2020-06-16 Solano California 6095 692 23
236996 2020-06-15 Solano California 6095 690 23
233968 2020-06-14 Solano California 6095 662 23
230941 2020-06-13 Solano California 6095 662 23
227915 2020-06-12 Solano California 6095 662 23
224891 2020-06-11 Solano California 6095 648 23
221869 2020-06-10 Solano California 6095 622 23
218853 2020-06-09 Solano California 6095 615 23
215838 2020-06-08 Solano California 6095 595 23
212827 2020-06-07 Solano California 6095 571 23
209820 2020-06-06 Solano California 6095 571 23
206815 2020-06-05 Solano California 6095 571 23
203814 2020-06-04 Solano California 6095 570 22
200815 2020-06-03 Solano California 6095 564 22
197820 2020-06-02 Solano California 6095 552 22
194828 2020-06-01 Solano California 6095 551 22
191839 2020-05-31 Solano California 6095 522 22
188853 2020-05-30 Solano California 6095 522 22
185869 2020-05-29 Solano California 6095 522 22
182893 2020-05-28 Solano California 6095 514 22
179919 2020-05-27 Solano California 6095 507 21
176955 2020-05-26 Solano California 6095 504 20
173991 2020-05-25 Solano California 6095 460 20
171027 2020-05-24 Solano California 6095 460 20
168066 2020-05-23 Solano California 6095 460 20
165109 2020-05-22 Solano California 6095 460 20
162156 2020-05-21 Solano California 6095 454 19
159208 2020-05-20 Solano California 6095 440 18
156262 2020-05-19 Solano California 6095 435 16
153326 2020-05-18 Solano California 6095 429 16
150394 2020-05-17 Solano California 6095 415 16
147465 2020-05-16 Solano California 6095 415 16
144540 2020-05-15 Solano California 6095 415 16
141620 2020-05-14 Solano California 6095 413 14
138703 2020-05-13 Solano California 6095 402 12
135791 2020-05-12 Solano California 6095 393 11
132880 2020-05-11 Solano California 6095 384 10
129969 2020-05-10 Solano California 6095 356 7
127058 2020-05-09 Solano California 6095 356 7
124152 2020-05-08 Solano California 6095 356 7
121251 2020-05-07 Solano California 6095 347 7
118363 2020-05-06 Solano California 6095 342 7
115483 2020-05-05 Solano California 6095 330 6
112604 2020-05-04 Solano California 6095 325 6
109733 2020-05-03 Solano California 6095 271 5
106868 2020-05-02 Solano California 6095 271 5
104007 2020-05-01 Solano California 6095 271 5
101156 2020-04-30 Solano California 6095 268 5
98310 2020-04-29 Solano California 6095 254 5
95469 2020-04-28 Solano California 6095 254 4
92640 2020-04-27 Solano California 6095 231 4
89825 2020-04-26 Solano California 6095 204 4
87011 2020-04-25 Solano California 6095 204 4
84206 2020-04-24 Solano California 6095 199 4
81409 2020-04-23 Solano California 6095 195 4
78618 2020-04-22 Solano California 6095 186 3
75837 2020-04-21 Solano California 6095 186 3
73064 2020-04-20 Solano California 6095 185 2
70298 2020-04-19 Solano California 6095 174 2
67539 2020-04-18 Solano California 6095 174 2
64794 2020-04-17 Solano California 6095 174 2
62064 2020-04-16 Solano California 6095 161 2
59348 2020-04-15 Solano California 6095 146 2
56643 2020-04-14 Solano California 6095 145 2
53954 2020-04-13 Solano California 6095 140 2
51278 2020-04-12 Solano California 6095 126 2
48619 2020-04-11 Solano California 6095 126 2
45992 2020-04-10 Solano California 6095 126 2
43395 2020-04-09 Solano California 6095 120 2
40826 2020-04-08 Solano California 6095 117 2
38285 2020-04-07 Solano California 6095 104 2
35799 2020-04-06 Solano California 6095 93 1
33354 2020-04-05 Solano California 6095 78 1
30948 2020-04-04 Solano California 6095 78 1
28590 2020-04-03 Solano California 6095 78 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 1059.235ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette