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

153 rows where fips = 6073 sorted by date descending

View and edit SQL

Suggested facets: date (date)

state

fips

  • 6073 · 153

county

Link rowid date ▲ county state fips cases deaths
316667 2020-07-11 San Diego California 6073 19434 422
313569 2020-07-10 San Diego California 6073 18926 420
310477 2020-07-09 San Diego California 6073 18465 415
307382 2020-07-08 San Diego California 6073 17905 406
304292 2020-07-07 San Diego California 6073 17641 399
301204 2020-07-06 San Diego California 6073 17063 387
298120 2020-07-05 San Diego California 6073 16789 387
295036 2020-07-04 San Diego California 6073 16227 387
291954 2020-07-03 San Diego California 6073 15759 387
288878 2020-07-02 San Diego California 6073 15270 377
285804 2020-07-01 San Diego California 6073 14686 372
282733 2020-06-30 San Diego California 6073 14212 365
279666 2020-06-29 San Diego California 6073 13895 361
276599 2020-06-28 San Diego California 6073 13397 361
273531 2020-06-27 San Diego California 6073 12900 360
270463 2020-06-26 San Diego California 6073 12464 358
267403 2020-06-25 San Diego California 6073 12024 352
264348 2020-06-24 San Diego California 6073 11689 347
261298 2020-06-23 San Diego California 6073 11357 341
258249 2020-06-22 San Diego California 6073 11159 338
255202 2020-06-21 San Diego California 6073 10857 338
252155 2020-06-20 San Diego California 6073 10547 338
249116 2020-06-19 San Diego California 6073 10413 332
246081 2020-06-18 San Diego California 6073 10155 331
243049 2020-06-17 San Diego California 6073 9917 327
240016 2020-06-16 San Diego California 6073 9793 323
236985 2020-06-15 San Diego California 6073 9673 320
233957 2020-06-14 San Diego California 6073 9503 320
230930 2020-06-13 San Diego California 6073 9377 319
227904 2020-06-12 San Diego California 6073 9193 313
224880 2020-06-11 San Diego California 6073 9061 312
221858 2020-06-10 San Diego California 6073 8900 312
218842 2020-06-09 San Diego California 6073 8792 312
215827 2020-06-08 San Diego California 6073 8682 312
212816 2020-06-07 San Diego California 6073 8539 312
209809 2020-06-06 San Diego California 6073 8408 312
206804 2020-06-05 San Diego California 6073 8243 312
203803 2020-06-04 San Diego California 6073 8003 312
200804 2020-06-03 San Diego California 6073 7861 312
197809 2020-06-02 San Diego California 6073 7737 312
194817 2020-06-01 San Diego California 6073 7617 312
191828 2020-05-31 San Diego California 6073 7544 312
188842 2020-05-30 San Diego California 6073 7448 312
185858 2020-05-29 San Diego California 6073 7303 307
182882 2020-05-28 San Diego California 6073 7163 297
179908 2020-05-27 San Diego California 6073 7046 290
176944 2020-05-26 San Diego California 6073 6945 275
173980 2020-05-25 San Diego California 6073 6860 275
171016 2020-05-24 San Diego California 6073 6764 275
168055 2020-05-23 San Diego California 6073 6622 271
165098 2020-05-22 San Diego California 6073 6497 262
162146 2020-05-21 San Diego California 6073 6378 262
159198 2020-05-20 San Diego California 6073 6203 242
156252 2020-05-19 San Diego California 6073 6089 242
153316 2020-05-18 San Diego California 6073 6009 242
150384 2020-05-17 San Diego California 6073 5899 235
147455 2020-05-16 San Diego California 6073 5725 235
144530 2020-05-15 San Diego California 6073 5586 231
141610 2020-05-14 San Diego California 6073 5454 223
138693 2020-05-13 San Diego California 6073 5341 217
135781 2020-05-12 San Diego California 6073 5224 204
132870 2020-05-11 San Diego California 6073 5128 194
129959 2020-05-10 San Diego California 6073 4989 194
127048 2020-05-09 San Diego California 6073 4839 194
124142 2020-05-08 San Diego California 6073 4725 189
121241 2020-05-07 San Diego California 6073 4492 186
118353 2020-05-06 San Diego California 6073 4382 173
115473 2020-05-05 San Diego California 6073 4223 162
112594 2020-05-04 San Diego California 6073 4083 150
109723 2020-05-03 San Diego California 6073 3990 150
106858 2020-05-02 San Diego California 6073 3905 150
103997 2020-05-01 San Diego California 6073 3774 143
101146 2020-04-30 San Diego California 6073 3627 140
98300 2020-04-29 San Diego California 6073 3432 133
95459 2020-04-28 San Diego California 6073 3378 128
92630 2020-04-27 San Diego California 6073 3141 123
89815 2020-04-26 San Diego California 6073 3043 111
87001 2020-04-25 San Diego California 6073 2943 111
84196 2020-04-24 San Diego California 6073 2826 102
81399 2020-04-23 San Diego California 6073 2643 112
78608 2020-04-22 San Diego California 6073 2491 96
75827 2020-04-21 San Diego California 6073 2434 87
73054 2020-04-20 San Diego California 6073 2325 72
70288 2020-04-19 San Diego California 6073 2268 71
67529 2020-04-18 San Diego California 6073 2213 71
64784 2020-04-17 San Diego California 6073 2158 70
62054 2020-04-16 San Diego California 6073 2087 63
59338 2020-04-15 San Diego California 6073 2012 60
56633 2020-04-14 San Diego California 6073 1930 53
53944 2020-04-13 San Diego California 6073 1847 47
51268 2020-04-12 San Diego California 6073 1804 45
48609 2020-04-11 San Diego California 6073 1761 45
45982 2020-04-10 San Diego California 6073 1696 44
43385 2020-04-09 San Diego California 6073 1628 40
40816 2020-04-08 San Diego California 6073 1530 36
38275 2020-04-07 San Diego California 6073 1454 31
35789 2020-04-06 San Diego California 6073 1404 19
33344 2020-04-05 San Diego California 6073 1326 19
30938 2020-04-04 San Diego California 6073 1209 18
28580 2020-04-03 San Diego California 6073 1112 17

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