ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where fips = 6113 and state = "California" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
599 | 599 | 2020-03-06 | Yolo | California | 6113 | 1 | 0 |
677 | 677 | 2020-03-07 | Yolo | California | 6113 | 1 | 0 |
772 | 772 | 2020-03-08 | Yolo | California | 6113 | 1 | 0 |
887 | 887 | 2020-03-09 | Yolo | California | 6113 | 1 | 0 |
1021 | 1021 | 2020-03-10 | Yolo | California | 6113 | 1 | 0 |
1188 | 1188 | 2020-03-11 | Yolo | California | 6113 | 1 | 0 |
1395 | 1395 | 2020-03-12 | Yolo | California | 6113 | 1 | 0 |
1656 | 1656 | 2020-03-13 | Yolo | California | 6113 | 2 | 0 |
1974 | 1974 | 2020-03-14 | Yolo | California | 6113 | 2 | 0 |
2355 | 2355 | 2020-03-15 | Yolo | California | 6113 | 2 | 0 |
2790 | 2790 | 2020-03-16 | Yolo | California | 6113 | 2 | 0 |
3272 | 3272 | 2020-03-17 | Yolo | California | 6113 | 4 | 0 |
3826 | 3826 | 2020-03-18 | Yolo | California | 6113 | 5 | 0 |
4486 | 4486 | 2020-03-19 | Yolo | California | 6113 | 5 | 0 |
5261 | 5261 | 2020-03-20 | Yolo | California | 6113 | 6 | 0 |
6183 | 6183 | 2020-03-21 | Yolo | California | 6113 | 6 | 0 |
7218 | 7218 | 2020-03-22 | Yolo | California | 6113 | 6 | 1 |
8361 | 8361 | 2020-03-23 | Yolo | California | 6113 | 8 | 1 |
9603 | 9603 | 2020-03-24 | Yolo | California | 6113 | 10 | 1 |
10976 | 10976 | 2020-03-25 | Yolo | California | 6113 | 11 | 1 |
12521 | 12521 | 2020-03-26 | Yolo | California | 6113 | 11 | 1 |
14187 | 14187 | 2020-03-27 | Yolo | California | 6113 | 16 | 1 |
15969 | 15969 | 2020-03-28 | Yolo | California | 6113 | 16 | 1 |
17859 | 17859 | 2020-03-29 | Yolo | California | 6113 | 16 | 1 |
19836 | 19836 | 2020-03-30 | Yolo | California | 6113 | 24 | 1 |
21911 | 21911 | 2020-03-31 | Yolo | California | 6113 | 25 | 1 |
24070 | 24070 | 2020-04-01 | Yolo | California | 6113 | 28 | 1 |
26299 | 26299 | 2020-04-02 | Yolo | California | 6113 | 28 | 1 |
28599 | 28599 | 2020-04-03 | Yolo | California | 6113 | 33 | 1 |
30956 | 30956 | 2020-04-04 | Yolo | California | 6113 | 33 | 1 |
33362 | 33362 | 2020-04-05 | Yolo | California | 6113 | 37 | 1 |
35807 | 35807 | 2020-04-06 | Yolo | California | 6113 | 50 | 1 |
38297 | 38297 | 2020-04-07 | Yolo | California | 6113 | 56 | 2 |
40840 | 40840 | 2020-04-08 | Yolo | California | 6113 | 67 | 3 |
43412 | 43412 | 2020-04-09 | Yolo | California | 6113 | 71 | 3 |
46012 | 46012 | 2020-04-10 | Yolo | California | 6113 | 75 | 3 |
48642 | 48642 | 2020-04-11 | Yolo | California | 6113 | 88 | 3 |
51304 | 51304 | 2020-04-12 | Yolo | California | 6113 | 93 | 3 |
53983 | 53983 | 2020-04-13 | Yolo | California | 6113 | 101 | 4 |
56675 | 56675 | 2020-04-14 | Yolo | California | 6113 | 102 | 4 |
59383 | 59383 | 2020-04-15 | Yolo | California | 6113 | 116 | 7 |
62102 | 62102 | 2020-04-16 | Yolo | California | 6113 | 125 | 7 |
64835 | 64835 | 2020-04-17 | Yolo | California | 6113 | 126 | 8 |
67583 | 67583 | 2020-04-18 | Yolo | California | 6113 | 137 | 8 |
70345 | 70345 | 2020-04-19 | Yolo | California | 6113 | 137 | 9 |
73114 | 73114 | 2020-04-20 | Yolo | California | 6113 | 142 | 10 |
75890 | 75890 | 2020-04-21 | Yolo | California | 6113 | 146 | 10 |
78674 | 78674 | 2020-04-22 | Yolo | California | 6113 | 151 | 12 |
81468 | 81468 | 2020-04-23 | Yolo | California | 6113 | 155 | 12 |
84268 | 84268 | 2020-04-24 | Yolo | California | 6113 | 157 | 13 |
87076 | 87076 | 2020-04-25 | Yolo | California | 6113 | 158 | 13 |
89893 | 89893 | 2020-04-26 | Yolo | California | 6113 | 161 | 14 |
92711 | 92711 | 2020-04-27 | Yolo | California | 6113 | 161 | 16 |
95543 | 95543 | 2020-04-28 | Yolo | California | 6113 | 162 | 16 |
98388 | 98388 | 2020-04-29 | Yolo | California | 6113 | 163 | 16 |
101238 | 101238 | 2020-04-30 | Yolo | California | 6113 | 164 | 16 |
104093 | 104093 | 2020-05-01 | Yolo | California | 6113 | 169 | 16 |
106958 | 106958 | 2020-05-02 | Yolo | California | 6113 | 171 | 18 |
109827 | 109827 | 2020-05-03 | Yolo | California | 6113 | 171 | 18 |
112702 | 112702 | 2020-05-04 | Yolo | California | 6113 | 171 | 19 |
115585 | 115585 | 2020-05-05 | Yolo | California | 6113 | 172 | 19 |
118544 | 118544 | 2020-05-06 | Yolo | California | 6113 | 172 | 20 |
121511 | 121511 | 2020-05-07 | Yolo | California | 6113 | 172 | 20 |
124491 | 124491 | 2020-05-08 | Yolo | California | 6113 | 172 | 20 |
127477 | 127477 | 2020-05-09 | Yolo | California | 6113 | 172 | 20 |
130467 | 130467 | 2020-05-10 | Yolo | California | 6113 | 173 | 20 |
133458 | 133458 | 2020-05-11 | Yolo | California | 6113 | 174 | 20 |
136447 | 136447 | 2020-05-12 | Yolo | California | 6113 | 177 | 22 |
139438 | 139438 | 2020-05-13 | Yolo | California | 6113 | 179 | 22 |
142434 | 142434 | 2020-05-14 | Yolo | California | 6113 | 182 | 22 |
145434 | 145434 | 2020-05-15 | Yolo | California | 6113 | 182 | 22 |
148437 | 148437 | 2020-05-16 | Yolo | California | 6113 | 183 | 22 |
151446 | 151446 | 2020-05-17 | Yolo | California | 6113 | 184 | 22 |
154458 | 154458 | 2020-05-18 | Yolo | California | 6113 | 184 | 22 |
157474 | 157474 | 2020-05-19 | Yolo | California | 6113 | 185 | 22 |
160500 | 160500 | 2020-05-20 | Yolo | California | 6113 | 185 | 22 |
163528 | 163528 | 2020-05-21 | Yolo | California | 6113 | 186 | 22 |
166561 | 166561 | 2020-05-22 | Yolo | California | 6113 | 188 | 22 |
169598 | 169598 | 2020-05-23 | Yolo | California | 6113 | 190 | 22 |
172639 | 172639 | 2020-05-24 | Yolo | California | 6113 | 194 | 22 |
175683 | 175683 | 2020-05-25 | Yolo | California | 6113 | 198 | 22 |
178727 | 178727 | 2020-05-26 | Yolo | California | 6113 | 200 | 22 |
181771 | 181771 | 2020-05-27 | Yolo | California | 6113 | 205 | 22 |
184825 | 184825 | 2020-05-28 | Yolo | California | 6113 | 207 | 23 |
187881 | 187881 | 2020-05-29 | Yolo | California | 6113 | 210 | 24 |
190946 | 190946 | 2020-05-30 | Yolo | California | 6113 | 211 | 24 |
194013 | 194013 | 2020-05-31 | Yolo | California | 6113 | 211 | 24 |
197083 | 197083 | 2020-06-01 | Yolo | California | 6113 | 212 | 24 |
200156 | 200156 | 2020-06-02 | Yolo | California | 6113 | 213 | 24 |
203232 | 203232 | 2020-06-03 | Yolo | California | 6113 | 214 | 24 |
206312 | 206312 | 2020-06-04 | Yolo | California | 6113 | 216 | 24 |
209393 | 209393 | 2020-06-05 | Yolo | California | 6113 | 218 | 24 |
212478 | 212478 | 2020-06-06 | Yolo | California | 6113 | 221 | 24 |
215565 | 215565 | 2020-06-07 | Yolo | California | 6113 | 223 | 24 |
218656 | 218656 | 2020-06-08 | Yolo | California | 6113 | 225 | 24 |
221751 | 221751 | 2020-06-09 | Yolo | California | 6113 | 228 | 24 |
224846 | 224846 | 2020-06-10 | Yolo | California | 6113 | 227 | 24 |
227948 | 227948 | 2020-06-11 | Yolo | California | 6113 | 240 | 24 |
231051 | 231051 | 2020-06-12 | Yolo | California | 6113 | 248 | 24 |
234157 | 234157 | 2020-06-13 | Yolo | California | 6113 | 252 | 24 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);