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

136 rows where fips = 6081 sorted by date descending

View and edit SQL

state

fips

  • 6081 · 136

county

Link rowid date ▲ county state fips cases deaths
334600 2020-07-15 San Mateo California 6081 4254 114
331409 2020-07-14 San Mateo California 6081 4168 114
328225 2020-07-13 San Mateo California 6081 4045 112
325041 2020-07-12 San Mateo California 6081 3956 112
321862 2020-07-11 San Mateo California 6081 3949 112
318685 2020-07-10 San Mateo California 6081 3846 112
315514 2020-07-09 San Mateo California 6081 3787 111
312341 2020-07-08 San Mateo California 6081 3743 111
309173 2020-07-07 San Mateo California 6081 3692 111
306007 2020-07-06 San Mateo California 6081 3599 108
302845 2020-07-05 San Mateo California 6081 3536 108
299683 2020-07-04 San Mateo California 6081 3536 108
296523 2020-07-03 San Mateo California 6081 3441 108
293369 2020-07-02 San Mateo California 6081 3376 108
290217 2020-07-01 San Mateo California 6081 3268 108
287068 2020-06-30 San Mateo California 6081 3170 108
283923 2020-06-29 San Mateo California 6081 3124 106
280778 2020-06-28 San Mateo California 6081 3083 106
277632 2020-06-27 San Mateo California 6081 3055 106
274486 2020-06-26 San Mateo California 6081 2996 106
271348 2020-06-25 San Mateo California 6081 2964 104
268215 2020-06-24 San Mateo California 6081 2907 104
265087 2020-06-23 San Mateo California 6081 2813 104
261960 2020-06-22 San Mateo California 6081 2781 103
258835 2020-06-21 San Mateo California 6081 2755 103
255710 2020-06-20 San Mateo California 6081 2713 103
252593 2020-06-19 San Mateo California 6081 2674 103
249480 2020-06-18 San Mateo California 6081 2649 99
246370 2020-06-17 San Mateo California 6081 2618 99
243259 2020-06-16 San Mateo California 6081 2591 99
240150 2020-06-15 San Mateo California 6081 2571 99
237044 2020-06-14 San Mateo California 6081 2553 99
233939 2020-06-13 San Mateo California 6081 2553 99
230835 2020-06-12 San Mateo California 6081 2533 99
227733 2020-06-11 San Mateo California 6081 2494 93
224633 2020-06-10 San Mateo California 6081 2475 93
221539 2020-06-09 San Mateo California 6081 2437 93
218446 2020-06-08 San Mateo California 6081 2399 88
215357 2020-06-07 San Mateo California 6081 2342 88
212272 2020-06-06 San Mateo California 6081 2331 88
209189 2020-06-05 San Mateo California 6081 2299 84
206110 2020-06-04 San Mateo California 6081 2244 84
203033 2020-06-03 San Mateo California 6081 2212 84
199960 2020-06-02 San Mateo California 6081 2190 84
196890 2020-06-01 San Mateo California 6081 2169 84
193823 2020-05-31 San Mateo California 6081 2129 84
190759 2020-05-30 San Mateo California 6081 2104 84
187697 2020-05-29 San Mateo California 6081 2070 84
184644 2020-05-28 San Mateo California 6081 2045 82
181593 2020-05-27 San Mateo California 6081 1967 82
178552 2020-05-26 San Mateo California 6081 1938 82
175511 2020-05-25 San Mateo California 6081 1925 76
172470 2020-05-24 San Mateo California 6081 1862 76
169432 2020-05-23 San Mateo California 6081 1847 76
166398 2020-05-22 San Mateo California 6081 1791 76
163369 2020-05-21 San Mateo California 6081 1739 75
160344 2020-05-20 San Mateo California 6081 1704 75
157321 2020-05-19 San Mateo California 6081 1701 68
154308 2020-05-18 San Mateo California 6081 1680 68
151299 2020-05-17 San Mateo California 6081 1652 68
148293 2020-05-16 San Mateo California 6081 1612 67
145292 2020-05-15 San Mateo California 6081 1588 66
142296 2020-05-14 San Mateo California 6081 1550 66
139303 2020-05-13 San Mateo California 6081 1533 66
136315 2020-05-12 San Mateo California 6081 1499 65
133328 2020-05-11 San Mateo California 6081 1464 65
130341 2020-05-10 San Mateo California 6081 1453 65
127354 2020-05-09 San Mateo California 6081 1425 62
124372 2020-05-08 San Mateo California 6081 1398 57
121395 2020-05-07 San Mateo California 6081 1377 56
118432 2020-05-06 San Mateo California 6081 1341 56
115477 2020-05-05 San Mateo California 6081 1315 53
112598 2020-05-04 San Mateo California 6081 1281 53
109727 2020-05-03 San Mateo California 6081 1272 52
106862 2020-05-02 San Mateo California 6081 1233 52
104001 2020-05-01 San Mateo California 6081 1197 52
101150 2020-04-30 San Mateo California 6081 1177 50
98304 2020-04-29 San Mateo California 6081 1136 48
95463 2020-04-28 San Mateo California 6081 1099 48
92634 2020-04-27 San Mateo California 6081 1080 46
89819 2020-04-26 San Mateo California 6081 1019 41
87005 2020-04-25 San Mateo California 6081 1019 41
84200 2020-04-24 San Mateo California 6081 989 41
81403 2020-04-23 San Mateo California 6081 966 39
78612 2020-04-22 San Mateo California 6081 958 39
75831 2020-04-21 San Mateo California 6081 935 28
73058 2020-04-20 San Mateo California 6081 920 28
70292 2020-04-19 San Mateo California 6081 838 28
67533 2020-04-18 San Mateo California 6081 838 28
64788 2020-04-17 San Mateo California 6081 797 28
62058 2020-04-16 San Mateo California 6081 767 28
59342 2020-04-15 San Mateo California 6081 767 28
56637 2020-04-14 San Mateo California 6081 747 21
53948 2020-04-13 San Mateo California 6081 701 21
51272 2020-04-12 San Mateo California 6081 652 21
48613 2020-04-11 San Mateo California 6081 652 21
45986 2020-04-10 San Mateo California 6081 638 21
43389 2020-04-09 San Mateo California 6081 633 21
40820 2020-04-08 San Mateo California 6081 617 21
38279 2020-04-07 San Mateo California 6081 589 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 1465.39ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette