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

124 rows where fips = 6061 sorted by date descending

View and edit SQL

Suggested facets: deaths, date (date)

state

fips

  • 6061 · 124

county

Link rowid date ▲ county state fips cases deaths
291974 2020-07-03 Placer California 6061 786 11
288897 2020-07-02 Placer California 6061 754 11
285822 2020-07-01 Placer California 6061 724 11
282749 2020-06-30 Placer California 6061 684 11
279680 2020-06-29 Placer California 6061 643 11
276612 2020-06-28 Placer California 6061 627 11
273543 2020-06-27 Placer California 6061 611 11
270474 2020-06-26 Placer California 6061 593 11
267413 2020-06-25 Placer California 6061 579 10
264357 2020-06-24 Placer California 6061 556 10
261306 2020-06-23 Placer California 6061 534 10
258257 2020-06-22 Placer California 6061 519 9
255210 2020-06-21 Placer California 6061 502 9
252163 2020-06-20 Placer California 6061 490 9
249124 2020-06-19 Placer California 6061 476 9
246089 2020-06-18 Placer California 6061 460 9
243057 2020-06-17 Placer California 6061 432 9
240024 2020-06-16 Placer California 6061 411 9
236992 2020-06-15 Placer California 6061 390 9
233964 2020-06-14 Placer California 6061 372 9
230937 2020-06-13 Placer California 6061 358 9
227911 2020-06-12 Placer California 6061 344 9
224887 2020-06-11 Placer California 6061 327 9
221865 2020-06-10 Placer California 6061 314 9
218849 2020-06-09 Placer California 6061 304 9
215834 2020-06-08 Placer California 6061 294 9
212823 2020-06-07 Placer California 6061 284 9
209816 2020-06-06 Placer California 6061 275 9
206810 2020-06-05 Placer California 6061 265 9
203809 2020-06-04 Placer California 6061 259 9
200809 2020-06-03 Placer California 6061 240 9
197813 2020-06-02 Placer California 6061 228 9
194821 2020-06-01 Placer California 6061 217 9
191832 2020-05-31 Placer California 6061 215 9
188846 2020-05-30 Placer California 6061 214 9
185862 2020-05-29 Placer California 6061 199 9
182885 2020-05-28 Placer California 6061 196 9
179910 2020-05-27 Placer California 6061 194 9
176944 2020-05-26 Placer California 6061 188 9
173978 2020-05-25 Placer California 6061 185 9
171013 2020-05-24 Placer California 6061 184 9
168051 2020-05-23 Placer California 6061 185 9
165093 2020-05-22 Placer California 6061 184 9
162140 2020-05-21 Placer California 6061 176 9
159192 2020-05-20 Placer California 6061 177 9
156246 2020-05-19 Placer California 6061 177 9
153310 2020-05-18 Placer California 6061 175 9
150378 2020-05-17 Placer California 6061 175 9
147449 2020-05-16 Placer California 6061 174 9
144524 2020-05-15 Placer California 6061 174 9
141604 2020-05-14 Placer California 6061 172 9
138687 2020-05-13 Placer California 6061 170 8
135775 2020-05-12 Placer California 6061 170 8
132864 2020-05-11 Placer California 6061 170 8
129953 2020-05-10 Placer California 6061 169 8
127042 2020-05-09 Placer California 6061 168 8
124136 2020-05-08 Placer California 6061 165 8
121235 2020-05-07 Placer California 6061 165 8
118347 2020-05-06 Placer California 6061 163 8
115467 2020-05-05 Placer California 6061 162 8
112588 2020-05-04 Placer California 6061 162 8
109717 2020-05-03 Placer California 6061 159 8
106852 2020-05-02 Placer California 6061 159 8
103991 2020-05-01 Placer California 6061 150 8
101140 2020-04-30 Placer California 6061 147 8
98294 2020-04-29 Placer California 6061 145 8
95453 2020-04-28 Placer California 6061 145 8
92624 2020-04-27 Placer California 6061 143 8
89809 2020-04-26 Placer California 6061 141 8
86995 2020-04-25 Placer California 6061 139 8
84190 2020-04-24 Placer California 6061 139 8
81393 2020-04-23 Placer California 6061 136 8
78602 2020-04-22 Placer California 6061 133 8
75821 2020-04-21 Placer California 6061 133 8
73048 2020-04-20 Placer California 6061 132 8
70282 2020-04-19 Placer California 6061 132 8
67523 2020-04-18 Placer California 6061 131 8
64778 2020-04-17 Placer California 6061 130 8
62048 2020-04-16 Placer California 6061 130 8
59332 2020-04-15 Placer California 6061 129 7
56627 2020-04-14 Placer California 6061 128 5
53938 2020-04-13 Placer California 6061 127 5
51262 2020-04-12 Placer California 6061 124 4
48603 2020-04-11 Placer California 6061 124 4
45976 2020-04-10 Placer California 6061 123 4
43379 2020-04-09 Placer California 6061 120 4
40810 2020-04-08 Placer California 6061 117 4
38269 2020-04-07 Placer California 6061 115 3
35783 2020-04-06 Placer California 6061 106 3
33338 2020-04-05 Placer California 6061 103 3
30932 2020-04-04 Placer California 6061 97 2
28574 2020-04-03 Placer California 6061 97 2
26275 2020-04-02 Placer California 6061 90 2
24046 2020-04-01 Placer California 6061 78 2
21888 2020-03-31 Placer California 6061 67 2
19814 2020-03-30 Placer California 6061 57 2
17837 2020-03-29 Placer California 6061 53 2
15948 2020-03-28 Placer California 6061 44 1
14166 2020-03-27 Placer California 6061 41 1
12500 2020-03-26 Placer California 6061 30 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 1019.619ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette