ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Yuba" and state = "California" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
6184 | 6184 | 2020-03-21 | Yuba | California | 6115 | 2 | 0 |
7219 | 7219 | 2020-03-22 | Yuba | California | 6115 | 2 | 0 |
8362 | 8362 | 2020-03-23 | Yuba | California | 6115 | 3 | 0 |
9604 | 9604 | 2020-03-24 | Yuba | California | 6115 | 3 | 0 |
10977 | 10977 | 2020-03-25 | Yuba | California | 6115 | 3 | 0 |
12522 | 12522 | 2020-03-26 | Yuba | California | 6115 | 3 | 0 |
14188 | 14188 | 2020-03-27 | Yuba | California | 6115 | 3 | 0 |
15970 | 15970 | 2020-03-28 | Yuba | California | 6115 | 3 | 0 |
17860 | 17860 | 2020-03-29 | Yuba | California | 6115 | 3 | 0 |
19837 | 19837 | 2020-03-30 | Yuba | California | 6115 | 6 | 0 |
21912 | 21912 | 2020-03-31 | Yuba | California | 6115 | 7 | 0 |
24071 | 24071 | 2020-04-01 | Yuba | California | 6115 | 7 | 0 |
26300 | 26300 | 2020-04-02 | Yuba | California | 6115 | 8 | 0 |
28600 | 28600 | 2020-04-03 | Yuba | California | 6115 | 9 | 0 |
30957 | 30957 | 2020-04-04 | Yuba | California | 6115 | 9 | 0 |
33363 | 33363 | 2020-04-05 | Yuba | California | 6115 | 10 | 0 |
35808 | 35808 | 2020-04-06 | Yuba | California | 6115 | 11 | 0 |
38298 | 38298 | 2020-04-07 | Yuba | California | 6115 | 13 | 0 |
40841 | 40841 | 2020-04-08 | Yuba | California | 6115 | 15 | 2 |
43413 | 43413 | 2020-04-09 | Yuba | California | 6115 | 15 | 3 |
46013 | 46013 | 2020-04-10 | Yuba | California | 6115 | 15 | 1 |
48643 | 48643 | 2020-04-11 | Yuba | California | 6115 | 15 | 1 |
51305 | 51305 | 2020-04-12 | Yuba | California | 6115 | 15 | 1 |
53984 | 53984 | 2020-04-13 | Yuba | California | 6115 | 15 | 1 |
56676 | 56676 | 2020-04-14 | Yuba | California | 6115 | 15 | 1 |
59384 | 59384 | 2020-04-15 | Yuba | California | 6115 | 15 | 1 |
62103 | 62103 | 2020-04-16 | Yuba | California | 6115 | 15 | 1 |
64836 | 64836 | 2020-04-17 | Yuba | California | 6115 | 15 | 1 |
67584 | 67584 | 2020-04-18 | Yuba | California | 6115 | 16 | 1 |
70346 | 70346 | 2020-04-19 | Yuba | California | 6115 | 16 | 1 |
73115 | 73115 | 2020-04-20 | Yuba | California | 6115 | 16 | 1 |
75891 | 75891 | 2020-04-21 | Yuba | California | 6115 | 16 | 1 |
78675 | 78675 | 2020-04-22 | Yuba | California | 6115 | 16 | 1 |
81469 | 81469 | 2020-04-23 | Yuba | California | 6115 | 16 | 1 |
84269 | 84269 | 2020-04-24 | Yuba | California | 6115 | 16 | 1 |
87077 | 87077 | 2020-04-25 | Yuba | California | 6115 | 16 | 1 |
89894 | 89894 | 2020-04-26 | Yuba | California | 6115 | 16 | 1 |
92712 | 92712 | 2020-04-27 | Yuba | California | 6115 | 16 | 1 |
95544 | 95544 | 2020-04-28 | Yuba | California | 6115 | 17 | 1 |
98389 | 98389 | 2020-04-29 | Yuba | California | 6115 | 17 | 1 |
101239 | 101239 | 2020-04-30 | Yuba | California | 6115 | 18 | 1 |
104094 | 104094 | 2020-05-01 | Yuba | California | 6115 | 19 | 1 |
106959 | 106959 | 2020-05-02 | Yuba | California | 6115 | 19 | 1 |
109828 | 109828 | 2020-05-03 | Yuba | California | 6115 | 19 | 1 |
112703 | 112703 | 2020-05-04 | Yuba | California | 6115 | 19 | 1 |
115586 | 115586 | 2020-05-05 | Yuba | California | 6115 | 19 | 1 |
118545 | 118545 | 2020-05-06 | Yuba | California | 6115 | 19 | 1 |
121512 | 121512 | 2020-05-07 | Yuba | California | 6115 | 20 | 1 |
124492 | 124492 | 2020-05-08 | Yuba | California | 6115 | 20 | 1 |
127478 | 127478 | 2020-05-09 | Yuba | California | 6115 | 20 | 1 |
130468 | 130468 | 2020-05-10 | Yuba | California | 6115 | 20 | 1 |
133459 | 133459 | 2020-05-11 | Yuba | California | 6115 | 21 | 1 |
136448 | 136448 | 2020-05-12 | Yuba | California | 6115 | 23 | 1 |
139439 | 139439 | 2020-05-13 | Yuba | California | 6115 | 25 | 1 |
142435 | 142435 | 2020-05-14 | Yuba | California | 6115 | 25 | 1 |
145435 | 145435 | 2020-05-15 | Yuba | California | 6115 | 25 | 1 |
148438 | 148438 | 2020-05-16 | Yuba | California | 6115 | 25 | 1 |
151447 | 151447 | 2020-05-17 | Yuba | California | 6115 | 26 | 1 |
154459 | 154459 | 2020-05-18 | Yuba | California | 6115 | 28 | 1 |
157475 | 157475 | 2020-05-19 | Yuba | California | 6115 | 28 | 1 |
160501 | 160501 | 2020-05-20 | Yuba | California | 6115 | 28 | 1 |
163529 | 163529 | 2020-05-21 | Yuba | California | 6115 | 28 | 1 |
166562 | 166562 | 2020-05-22 | Yuba | California | 6115 | 28 | 1 |
169599 | 169599 | 2020-05-23 | Yuba | California | 6115 | 28 | 1 |
172640 | 172640 | 2020-05-24 | Yuba | California | 6115 | 28 | 1 |
175684 | 175684 | 2020-05-25 | Yuba | California | 6115 | 28 | 1 |
178728 | 178728 | 2020-05-26 | Yuba | California | 6115 | 28 | 1 |
181772 | 181772 | 2020-05-27 | Yuba | California | 6115 | 28 | 1 |
184826 | 184826 | 2020-05-28 | Yuba | California | 6115 | 29 | 1 |
187882 | 187882 | 2020-05-29 | Yuba | California | 6115 | 29 | 1 |
190947 | 190947 | 2020-05-30 | Yuba | California | 6115 | 30 | 1 |
194014 | 194014 | 2020-05-31 | Yuba | California | 6115 | 30 | 1 |
197084 | 197084 | 2020-06-01 | Yuba | California | 6115 | 30 | 1 |
200157 | 200157 | 2020-06-02 | Yuba | California | 6115 | 31 | 1 |
203233 | 203233 | 2020-06-03 | Yuba | California | 6115 | 31 | 1 |
206313 | 206313 | 2020-06-04 | Yuba | California | 6115 | 31 | 1 |
209394 | 209394 | 2020-06-05 | Yuba | California | 6115 | 32 | 1 |
212479 | 212479 | 2020-06-06 | Yuba | California | 6115 | 32 | 1 |
215566 | 215566 | 2020-06-07 | Yuba | California | 6115 | 32 | 1 |
218657 | 218657 | 2020-06-08 | Yuba | California | 6115 | 32 | 1 |
221752 | 221752 | 2020-06-09 | Yuba | California | 6115 | 32 | 1 |
224847 | 224847 | 2020-06-10 | Yuba | California | 6115 | 33 | 1 |
227949 | 227949 | 2020-06-11 | Yuba | California | 6115 | 34 | 1 |
231052 | 231052 | 2020-06-12 | Yuba | California | 6115 | 35 | 1 |
234158 | 234158 | 2020-06-13 | Yuba | California | 6115 | 35 | 1 |
237265 | 237265 | 2020-06-14 | Yuba | California | 6115 | 35 | 1 |
240373 | 240373 | 2020-06-15 | Yuba | California | 6115 | 36 | 1 |
243484 | 243484 | 2020-06-16 | Yuba | California | 6115 | 37 | 1 |
246597 | 246597 | 2020-06-17 | Yuba | California | 6115 | 39 | 1 |
249709 | 249709 | 2020-06-18 | Yuba | California | 6115 | 39 | 1 |
252824 | 252824 | 2020-06-19 | Yuba | California | 6115 | 39 | 1 |
255943 | 255943 | 2020-06-20 | Yuba | California | 6115 | 42 | 1 |
259070 | 259070 | 2020-06-21 | Yuba | California | 6115 | 42 | 1 |
262197 | 262197 | 2020-06-22 | Yuba | California | 6115 | 43 | 1 |
265325 | 265325 | 2020-06-23 | Yuba | California | 6115 | 43 | 1 |
268455 | 268455 | 2020-06-24 | Yuba | California | 6115 | 49 | 1 |
271590 | 271590 | 2020-06-25 | Yuba | California | 6115 | 51 | 1 |
274730 | 274730 | 2020-06-26 | Yuba | California | 6115 | 57 | 1 |
277878 | 277878 | 2020-06-27 | Yuba | California | 6115 | 61 | 1 |
281025 | 281025 | 2020-06-28 | Yuba | California | 6115 | 65 | 1 |
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);