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

169 rows where fips = 6059 sorted by date descending

View and edit SQL

state

fips

  • 6059 · 169

county

Link rowid date ▲ county state fips cases deaths
316660 2020-07-11 Orange California 6059 23692 412
313562 2020-07-10 Orange California 6059 22960 402
310470 2020-07-09 Orange California 6059 22088 376
307375 2020-07-08 Orange California 6059 21741 369
304285 2020-07-07 Orange California 6059 20167 366
301197 2020-07-06 Orange California 6059 19430 366
298113 2020-07-05 Orange California 6059 19247 363
295029 2020-07-04 Orange California 6059 18819 360
291947 2020-07-03 Orange California 6059 17056 360
288871 2020-07-02 Orange California 6059 15662 354
285797 2020-07-01 Orange California 6059 14413 345
282726 2020-06-30 Orange California 6059 13843 340
279659 2020-06-29 Orange California 6059 13213 330
276592 2020-06-28 Orange California 6059 12951 326
273524 2020-06-27 Orange California 6059 12659 323
270456 2020-06-26 Orange California 6059 12221 323
267396 2020-06-25 Orange California 6059 11804 306
264341 2020-06-24 Orange California 6059 11071 299
261291 2020-06-23 Orange California 6059 10737 275
258242 2020-06-22 Orange California 6059 10595 269
255195 2020-06-21 Orange California 6059 10422 269
252148 2020-06-20 Orange California 6059 9988 267
249109 2020-06-19 Orange California 6059 9597 257
246074 2020-06-18 Orange California 6059 9292 250
243042 2020-06-17 Orange California 6059 9197 243
240009 2020-06-16 Orange California 6059 8999 233
236978 2020-06-15 Orange California 6059 8759 221
233950 2020-06-14 Orange California 6059 8581 221
230923 2020-06-13 Orange California 6059 8440 217
227897 2020-06-12 Orange California 6059 8304 210
224873 2020-06-11 Orange California 6059 8222 202
221851 2020-06-10 Orange California 6059 7991 198
218835 2020-06-09 Orange California 6059 7786 185
215820 2020-06-08 Orange California 6059 7643 177
212809 2020-06-07 Orange California 6059 7576 177
209802 2020-06-06 Orange California 6059 7391 176
206797 2020-06-05 Orange California 6059 7192 174
203796 2020-06-04 Orange California 6059 6939 165
200797 2020-06-03 Orange California 6059 6790 158
197802 2020-06-02 Orange California 6059 6640 150
194810 2020-06-01 Orange California 6059 6532 147
191821 2020-05-31 Orange California 6059 6354 147
188835 2020-05-30 Orange California 6059 6176 146
185851 2020-05-29 Orange California 6059 6045 145
182875 2020-05-28 Orange California 6059 5849 142
179901 2020-05-27 Orange California 6059 5651 136
176937 2020-05-26 Orange California 6059 5601 131
173973 2020-05-25 Orange California 6059 5469 131
171009 2020-05-24 Orange California 6059 5336 131
168048 2020-05-23 Orange California 6059 5157 130
165091 2020-05-22 Orange California 6059 4975 118
162139 2020-05-21 Orange California 6059 4866 112
159191 2020-05-20 Orange California 6059 4746 98
156245 2020-05-19 Orange California 6059 4558 88
153309 2020-05-18 Orange California 6059 4466 88
150377 2020-05-17 Orange California 6059 4396 88
147448 2020-05-16 Orange California 6059 4281 86
144523 2020-05-15 Orange California 6059 4163 84
141603 2020-05-14 Orange California 6059 4025 80
138686 2020-05-13 Orange California 6059 3843 80
135774 2020-05-12 Orange California 6059 3699 78
132863 2020-05-11 Orange California 6059 3627 76
129952 2020-05-10 Orange California 6059 3506 76
127041 2020-05-09 Orange California 6059 3395 74
124135 2020-05-08 Orange California 6059 3283 71
121234 2020-05-07 Orange California 6059 3156 66
118346 2020-05-06 Orange California 6059 3041 65
115466 2020-05-05 Orange California 6059 2931 61
112587 2020-05-04 Orange California 6059 2859 57
109716 2020-05-03 Orange California 6059 2774 52
106851 2020-05-02 Orange California 6059 2660 52
103990 2020-05-01 Orange California 6059 2591 50
101139 2020-04-30 Orange California 6059 2421 45
98293 2020-04-29 Orange California 6059 2324 44
95452 2020-04-28 Orange California 6059 2198 42
92623 2020-04-27 Orange California 6059 2126 40
89808 2020-04-26 Orange California 6059 2074 39
86994 2020-04-25 Orange California 6059 1969 38
84189 2020-04-24 Orange California 6059 1845 36
81392 2020-04-23 Orange California 6059 1827 36
78601 2020-04-22 Orange California 6059 1753 34
75820 2020-04-21 Orange California 6059 1691 33
73047 2020-04-20 Orange California 6059 1676 33
70281 2020-04-19 Orange California 6059 1636 32
67522 2020-04-18 Orange California 6059 1556 32
64777 2020-04-17 Orange California 6059 1501 28
62047 2020-04-16 Orange California 6059 1425 25
59331 2020-04-15 Orange California 6059 1376 22
56626 2020-04-14 Orange California 6059 1299 19
53937 2020-04-13 Orange California 6059 1283 19
51261 2020-04-12 Orange California 6059 1277 19
48602 2020-04-11 Orange California 6059 1221 18
45975 2020-04-10 Orange California 6059 1138 17
43378 2020-04-09 Orange California 6059 1079 17
40809 2020-04-08 Orange California 6059 1016 17
38268 2020-04-07 Orange California 6059 931 15
35782 2020-04-06 Orange California 6059 882 14
33337 2020-04-05 Orange California 6059 834 14
30931 2020-04-04 Orange California 6059 786 14
28573 2020-04-03 Orange California 6059 711 13

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