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

146 rows where fips = 6067 sorted by date descending

View and edit SQL

Suggested facets: date (date)

state

fips

  • 6067 · 146

county

Link rowid date ▲ county state fips cases deaths
334593 2020-07-15 Sacramento California 6067 6173 92
331402 2020-07-14 Sacramento California 6067 5937 91
328218 2020-07-13 Sacramento California 6067 5713 83
325034 2020-07-12 Sacramento California 6067 5488 83
321855 2020-07-11 Sacramento California 6067 5338 81
318678 2020-07-10 Sacramento California 6067 5151 79
315507 2020-07-09 Sacramento California 6067 4931 78
312334 2020-07-08 Sacramento California 6067 4775 78
309166 2020-07-07 Sacramento California 6067 4565 76
306000 2020-07-06 Sacramento California 6067 4394 74
302838 2020-07-05 Sacramento California 6067 4235 69
299676 2020-07-04 Sacramento California 6067 4003 69
296516 2020-07-03 Sacramento California 6067 3670 69
293362 2020-07-02 Sacramento California 6067 3558 69
290210 2020-07-01 Sacramento California 6067 3396 68
287061 2020-06-30 Sacramento California 6067 3222 68
283916 2020-06-29 Sacramento California 6067 3003 68
280771 2020-06-28 Sacramento California 6067 2775 66
277625 2020-06-27 Sacramento California 6067 2686 66
274479 2020-06-26 Sacramento California 6067 2665 66
271341 2020-06-25 Sacramento California 6067 2511 66
268208 2020-06-24 Sacramento California 6067 2439 66
265080 2020-06-23 Sacramento California 6067 2373 66
261953 2020-06-22 Sacramento California 6067 2242 67
258828 2020-06-21 Sacramento California 6067 2159 67
255703 2020-06-20 Sacramento California 6067 2068 67
252586 2020-06-19 Sacramento California 6067 1975 67
249473 2020-06-18 Sacramento California 6067 1939 67
246363 2020-06-17 Sacramento California 6067 1891 67
243252 2020-06-16 Sacramento California 6067 1824 63
240143 2020-06-15 Sacramento California 6067 1793 63
237037 2020-06-14 Sacramento California 6067 1752 63
233932 2020-06-13 Sacramento California 6067 1715 63
230828 2020-06-12 Sacramento California 6067 1703 63
227726 2020-06-11 Sacramento California 6067 1669 63
224626 2020-06-10 Sacramento California 6067 1641 62
221532 2020-06-09 Sacramento California 6067 1623 61
218439 2020-06-08 Sacramento California 6067 1587 61
215350 2020-06-07 Sacramento California 6067 1568 59
212265 2020-06-06 Sacramento California 6067 1536 59
209182 2020-06-05 Sacramento California 6067 1518 59
206103 2020-06-04 Sacramento California 6067 1489 58
203026 2020-06-03 Sacramento California 6067 1462 58
199953 2020-06-02 Sacramento California 6067 1438 58
196883 2020-06-01 Sacramento California 6067 1428 58
193816 2020-05-31 Sacramento California 6067 1414 57
190752 2020-05-30 Sacramento California 6067 1399 57
187690 2020-05-29 Sacramento California 6067 1372 57
184637 2020-05-28 Sacramento California 6067 1348 57
181586 2020-05-27 Sacramento California 6067 1318 57
178545 2020-05-26 Sacramento California 6067 1309 57
175504 2020-05-25 Sacramento California 6067 1301 57
172463 2020-05-24 Sacramento California 6067 1292 57
169425 2020-05-23 Sacramento California 6067 1288 57
166391 2020-05-22 Sacramento California 6067 1271 57
163362 2020-05-21 Sacramento California 6067 1265 57
160337 2020-05-20 Sacramento California 6067 1254 57
157314 2020-05-19 Sacramento California 6067 1249 56
154301 2020-05-18 Sacramento California 6067 1244 56
151292 2020-05-17 Sacramento California 6067 1236 55
148286 2020-05-16 Sacramento California 6067 1221 55
145285 2020-05-15 Sacramento California 6067 1210 54
142289 2020-05-14 Sacramento California 6067 1193 54
139296 2020-05-13 Sacramento California 6067 1182 52
136308 2020-05-12 Sacramento California 6067 1180 52
133321 2020-05-11 Sacramento California 6067 1172 52
130334 2020-05-10 Sacramento California 6067 1166 52
127347 2020-05-09 Sacramento California 6067 1164 51
124365 2020-05-08 Sacramento California 6067 1159 50
121388 2020-05-07 Sacramento California 6067 1132 49
118425 2020-05-06 Sacramento California 6067 1132 47
115470 2020-05-05 Sacramento California 6067 1132 47
112591 2020-05-04 Sacramento California 6067 1126 47
109720 2020-05-03 Sacramento California 6067 1116 43
106855 2020-05-02 Sacramento California 6067 1106 43
103994 2020-05-01 Sacramento California 6067 1090 43
101143 2020-04-30 Sacramento California 6067 1077 43
98297 2020-04-29 Sacramento California 6067 1068 42
95456 2020-04-28 Sacramento California 6067 1053 41
92627 2020-04-27 Sacramento California 6067 1045 41
89812 2020-04-26 Sacramento California 6067 1037 41
86998 2020-04-25 Sacramento California 6067 1025 41
84193 2020-04-24 Sacramento California 6067 1019 41
81396 2020-04-23 Sacramento California 6067 987 41
78605 2020-04-22 Sacramento California 6067 971 36
75824 2020-04-21 Sacramento California 6067 954 35
73051 2020-04-20 Sacramento California 6067 940 34
70285 2020-04-19 Sacramento California 6067 925 34
67526 2020-04-18 Sacramento California 6067 914 33
64781 2020-04-17 Sacramento California 6067 896 32
62051 2020-04-16 Sacramento California 6067 879 32
59335 2020-04-15 Sacramento California 6067 853 32
56630 2020-04-14 Sacramento California 6067 816 28
53941 2020-04-13 Sacramento California 6067 739 27
51265 2020-04-12 Sacramento California 6067 707 26
48606 2020-04-11 Sacramento California 6067 699 26
45979 2020-04-10 Sacramento California 6067 652 24
43382 2020-04-09 Sacramento California 6067 612 22
40813 2020-04-08 Sacramento California 6067 579 22
38272 2020-04-07 Sacramento California 6067 524 21

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