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

155 rows where fips = 6085 sorted by date descending

View and edit SQL

Suggested facets: date (date)

state

fips

  • 6085 · 155

county

Link rowid date ▲ county state fips cases deaths
291986 2020-07-03 Santa Clara California 6085 4849 161
288909 2020-07-02 Santa Clara California 6085 4750 160
285834 2020-07-01 Santa Clara California 6085 4572 159
282761 2020-06-30 Santa Clara California 6085 4231 157
279692 2020-06-29 Santa Clara California 6085 4162 156
276624 2020-06-28 Santa Clara California 6085 4162 156
273555 2020-06-27 Santa Clara California 6085 3984 156
270486 2020-06-26 Santa Clara California 6085 3984 156
267425 2020-06-25 Santa Clara California 6085 3888 156
264369 2020-06-24 Santa Clara California 6085 3832 156
261318 2020-06-23 Santa Clara California 6085 3727 155
258269 2020-06-22 Santa Clara California 6085 3606 155
255222 2020-06-21 Santa Clara California 6085 3547 155
252175 2020-06-20 Santa Clara California 6085 3458 153
249136 2020-06-19 Santa Clara California 6085 3398 153
246101 2020-06-18 Santa Clara California 6085 3363 153
243069 2020-06-17 Santa Clara California 6085 3288 153
240036 2020-06-16 Santa Clara California 6085 3254 153
237004 2020-06-15 Santa Clara California 6085 3230 152
233976 2020-06-14 Santa Clara California 6085 3197 152
230949 2020-06-13 Santa Clara California 6085 3157 151
227923 2020-06-12 Santa Clara California 6085 3117 151
224899 2020-06-11 Santa Clara California 6085 3063 150
221877 2020-06-10 Santa Clara California 6085 3032 150
218861 2020-06-09 Santa Clara California 6085 3017 150
215846 2020-06-08 Santa Clara California 6085 2973 146
212835 2020-06-07 Santa Clara California 6085 2942 145
209828 2020-06-06 Santa Clara California 6085 2920 145
206822 2020-06-05 Santa Clara California 6085 2892 145
203821 2020-06-04 Santa Clara California 6085 2850 145
200821 2020-06-03 Santa Clara California 6085 2832 145
197825 2020-06-02 Santa Clara California 6085 2819 145
194833 2020-06-01 Santa Clara California 6085 2805 145
191844 2020-05-31 Santa Clara California 6085 2776 142
188858 2020-05-30 Santa Clara California 6085 2731 142
185874 2020-05-29 Santa Clara California 6085 2707 142
182897 2020-05-28 Santa Clara California 6085 2701 142
179922 2020-05-27 Santa Clara California 6085 2688 141
176956 2020-05-26 Santa Clara California 6085 2675 141
173990 2020-05-25 Santa Clara California 6085 2652 140
171025 2020-05-24 Santa Clara California 6085 2617 140
168063 2020-05-23 Santa Clara California 6085 2571 140
165105 2020-05-22 Santa Clara California 6085 2546 140
162152 2020-05-21 Santa Clara California 6085 2508 140
159204 2020-05-20 Santa Clara California 6085 2492 140
156258 2020-05-19 Santa Clara California 6085 2483 138
153322 2020-05-18 Santa Clara California 6085 2453 137
150390 2020-05-17 Santa Clara California 6085 2453 137
147461 2020-05-16 Santa Clara California 6085 2418 137
144536 2020-05-15 Santa Clara California 6085 2403 136
141616 2020-05-14 Santa Clara California 6085 2391 136
138699 2020-05-13 Santa Clara California 6085 2364 134
135787 2020-05-12 Santa Clara California 6085 2364 134
132876 2020-05-11 Santa Clara California 6085 2341 131
129965 2020-05-10 Santa Clara California 6085 2339 131
127054 2020-05-09 Santa Clara California 6085 2307 131
124148 2020-05-08 Santa Clara California 6085 2290 129
121247 2020-05-07 Santa Clara California 6085 2281 122
118359 2020-05-06 Santa Clara California 6085 2268 122
115479 2020-05-05 Santa Clara California 6085 2255 122
112600 2020-05-04 Santa Clara California 6085 2244 118
109729 2020-05-03 Santa Clara California 6085 2231 116
106864 2020-05-02 Santa Clara California 6085 2204 115
104003 2020-05-01 Santa Clara California 6085 2179 114
101152 2020-04-30 Santa Clara California 6085 2163 112
98306 2020-04-29 Santa Clara California 6085 2134 108
95465 2020-04-28 Santa Clara California 6085 2122 107
92636 2020-04-27 Santa Clara California 6085 2105 104
89821 2020-04-26 Santa Clara California 6085 2084 101
87007 2020-04-25 Santa Clara California 6085 2040 100
84202 2020-04-24 Santa Clara California 6085 2018 99
81405 2020-04-23 Santa Clara California 6085 1987 96
78614 2020-04-22 Santa Clara California 6085 1962 95
75833 2020-04-21 Santa Clara California 6085 1946 89
73060 2020-04-20 Santa Clara California 6085 1922 84
70294 2020-04-19 Santa Clara California 6085 1870 74
67535 2020-04-18 Santa Clara California 6085 1870 74
64790 2020-04-17 Santa Clara California 6085 1870 74
62060 2020-04-16 Santa Clara California 6085 1833 70
59344 2020-04-15 Santa Clara California 6085 1793 66
56639 2020-04-14 Santa Clara California 6085 1666 61
53950 2020-04-13 Santa Clara California 6085 1666 61
51274 2020-04-12 Santa Clara California 6085 1621 54
48615 2020-04-11 Santa Clara California 6085 1566 52
45988 2020-04-10 Santa Clara California 6085 1484 50
43391 2020-04-09 Santa Clara California 6085 1442 48
40822 2020-04-08 Santa Clara California 6085 1380 47
38281 2020-04-07 Santa Clara California 6085 1285 44
35795 2020-04-06 Santa Clara California 6085 1224 40
33350 2020-04-05 Santa Clara California 6085 1207 40
30944 2020-04-04 Santa Clara California 6085 1148 40
28586 2020-04-03 Santa Clara California 6085 1094 39
26287 2020-04-02 Santa Clara California 6085 1019 37
24058 2020-04-01 Santa Clara California 6085 956 33
21900 2020-03-31 Santa Clara California 6085 890 31
19825 2020-03-30 Santa Clara California 6085 848 29
17848 2020-03-29 Santa Clara California 6085 646 26
15959 2020-03-28 Santa Clara California 6085 591 26
14177 2020-03-27 Santa Clara California 6085 574 21
12511 2020-03-26 Santa Clara California 6085 542 20

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