ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where fips = 6063 and state = "California" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
21889 | 21889 | 2020-03-31 | Plumas | California | 6063 | 1 | 0 |
24047 | 24047 | 2020-04-01 | Plumas | California | 6063 | 1 | 0 |
26276 | 26276 | 2020-04-02 | Plumas | California | 6063 | 1 | 0 |
28575 | 28575 | 2020-04-03 | Plumas | California | 6063 | 2 | 0 |
30933 | 30933 | 2020-04-04 | Plumas | California | 6063 | 3 | 0 |
33339 | 33339 | 2020-04-05 | Plumas | California | 6063 | 3 | 0 |
35784 | 35784 | 2020-04-06 | Plumas | California | 6063 | 3 | 0 |
38273 | 38273 | 2020-04-07 | Plumas | California | 6063 | 3 | 0 |
40817 | 40817 | 2020-04-08 | Plumas | California | 6063 | 3 | 0 |
43389 | 43389 | 2020-04-09 | Plumas | California | 6063 | 3 | 0 |
45989 | 45989 | 2020-04-10 | Plumas | California | 6063 | 4 | 0 |
48619 | 48619 | 2020-04-11 | Plumas | California | 6063 | 4 | 0 |
51281 | 51281 | 2020-04-12 | Plumas | California | 6063 | 4 | 0 |
53960 | 53960 | 2020-04-13 | Plumas | California | 6063 | 4 | 0 |
56652 | 56652 | 2020-04-14 | Plumas | California | 6063 | 4 | 0 |
59360 | 59360 | 2020-04-15 | Plumas | California | 6063 | 4 | 0 |
62079 | 62079 | 2020-04-16 | Plumas | California | 6063 | 4 | 0 |
64812 | 64812 | 2020-04-17 | Plumas | California | 6063 | 4 | 0 |
67560 | 67560 | 2020-04-18 | Plumas | California | 6063 | 4 | 0 |
70322 | 70322 | 2020-04-19 | Plumas | California | 6063 | 4 | 0 |
73091 | 73091 | 2020-04-20 | Plumas | California | 6063 | 4 | 0 |
75867 | 75867 | 2020-04-21 | Plumas | California | 6063 | 4 | 0 |
78651 | 78651 | 2020-04-22 | Plumas | California | 6063 | 4 | 0 |
81445 | 81445 | 2020-04-23 | Plumas | California | 6063 | 4 | 0 |
84245 | 84245 | 2020-04-24 | Plumas | California | 6063 | 4 | 0 |
87053 | 87053 | 2020-04-25 | Plumas | California | 6063 | 4 | 0 |
89870 | 89870 | 2020-04-26 | Plumas | California | 6063 | 4 | 0 |
92688 | 92688 | 2020-04-27 | Plumas | California | 6063 | 4 | 0 |
95520 | 95520 | 2020-04-28 | Plumas | California | 6063 | 4 | 0 |
98365 | 98365 | 2020-04-29 | Plumas | California | 6063 | 4 | 0 |
101215 | 101215 | 2020-04-30 | Plumas | California | 6063 | 4 | 0 |
104070 | 104070 | 2020-05-01 | Plumas | California | 6063 | 4 | 0 |
106935 | 106935 | 2020-05-02 | Plumas | California | 6063 | 4 | 0 |
109804 | 109804 | 2020-05-03 | Plumas | California | 6063 | 4 | 0 |
112679 | 112679 | 2020-05-04 | Plumas | California | 6063 | 4 | 0 |
115562 | 115562 | 2020-05-05 | Plumas | California | 6063 | 4 | 0 |
118521 | 118521 | 2020-05-06 | Plumas | California | 6063 | 4 | 0 |
121488 | 121488 | 2020-05-07 | Plumas | California | 6063 | 4 | 0 |
124468 | 124468 | 2020-05-08 | Plumas | California | 6063 | 4 | 0 |
127453 | 127453 | 2020-05-09 | Plumas | California | 6063 | 4 | 0 |
130443 | 130443 | 2020-05-10 | Plumas | California | 6063 | 4 | 0 |
133433 | 133433 | 2020-05-11 | Plumas | California | 6063 | 4 | 0 |
136423 | 136423 | 2020-05-12 | Plumas | California | 6063 | 4 | 0 |
139414 | 139414 | 2020-05-13 | Plumas | California | 6063 | 4 | 0 |
142410 | 142410 | 2020-05-14 | Plumas | California | 6063 | 4 | 0 |
145409 | 145409 | 2020-05-15 | Plumas | California | 6063 | 4 | 0 |
148413 | 148413 | 2020-05-16 | Plumas | California | 6063 | 4 | 0 |
151422 | 151422 | 2020-05-17 | Plumas | California | 6063 | 4 | 0 |
154434 | 154434 | 2020-05-18 | Plumas | California | 6063 | 4 | 0 |
157450 | 157450 | 2020-05-19 | Plumas | California | 6063 | 5 | 0 |
160476 | 160476 | 2020-05-20 | Plumas | California | 6063 | 5 | 0 |
163504 | 163504 | 2020-05-21 | Plumas | California | 6063 | 4 | 0 |
166536 | 166536 | 2020-05-22 | Plumas | California | 6063 | 4 | 0 |
169573 | 169573 | 2020-05-23 | Plumas | California | 6063 | 4 | 0 |
172614 | 172614 | 2020-05-24 | Plumas | California | 6063 | 4 | 0 |
175658 | 175658 | 2020-05-25 | Plumas | California | 6063 | 4 | 0 |
178702 | 178702 | 2020-05-26 | Plumas | California | 6063 | 4 | 0 |
181746 | 181746 | 2020-05-27 | Plumas | California | 6063 | 4 | 0 |
184800 | 184800 | 2020-05-28 | Plumas | California | 6063 | 4 | 0 |
187856 | 187856 | 2020-05-29 | Plumas | California | 6063 | 4 | 0 |
190921 | 190921 | 2020-05-30 | Plumas | California | 6063 | 4 | 0 |
193988 | 193988 | 2020-05-31 | Plumas | California | 6063 | 4 | 0 |
197058 | 197058 | 2020-06-01 | Plumas | California | 6063 | 4 | 0 |
200131 | 200131 | 2020-06-02 | Plumas | California | 6063 | 4 | 0 |
203207 | 203207 | 2020-06-03 | Plumas | California | 6063 | 4 | 0 |
206287 | 206287 | 2020-06-04 | Plumas | California | 6063 | 4 | 0 |
209368 | 209368 | 2020-06-05 | Plumas | California | 6063 | 4 | 0 |
212453 | 212453 | 2020-06-06 | Plumas | California | 6063 | 4 | 0 |
215540 | 215540 | 2020-06-07 | Plumas | California | 6063 | 4 | 0 |
218631 | 218631 | 2020-06-08 | Plumas | California | 6063 | 4 | 0 |
221726 | 221726 | 2020-06-09 | Plumas | California | 6063 | 4 | 0 |
224821 | 224821 | 2020-06-10 | Plumas | California | 6063 | 4 | 0 |
227923 | 227923 | 2020-06-11 | Plumas | California | 6063 | 4 | 0 |
231026 | 231026 | 2020-06-12 | Plumas | California | 6063 | 4 | 0 |
234132 | 234132 | 2020-06-13 | Plumas | California | 6063 | 4 | 0 |
237239 | 237239 | 2020-06-14 | Plumas | California | 6063 | 4 | 0 |
240347 | 240347 | 2020-06-15 | Plumas | California | 6063 | 4 | 0 |
243458 | 243458 | 2020-06-16 | Plumas | California | 6063 | 4 | 0 |
246571 | 246571 | 2020-06-17 | Plumas | California | 6063 | 5 | 0 |
249683 | 249683 | 2020-06-18 | Plumas | California | 6063 | 5 | 0 |
252798 | 252798 | 2020-06-19 | Plumas | California | 6063 | 5 | 0 |
255917 | 255917 | 2020-06-20 | Plumas | California | 6063 | 5 | 0 |
259044 | 259044 | 2020-06-21 | Plumas | California | 6063 | 6 | 0 |
262171 | 262171 | 2020-06-22 | Plumas | California | 6063 | 6 | 0 |
265299 | 265299 | 2020-06-23 | Plumas | California | 6063 | 6 | 0 |
268429 | 268429 | 2020-06-24 | Plumas | California | 6063 | 6 | 0 |
271564 | 271564 | 2020-06-25 | Plumas | California | 6063 | 6 | 0 |
274704 | 274704 | 2020-06-26 | Plumas | California | 6063 | 6 | 0 |
277852 | 277852 | 2020-06-27 | Plumas | California | 6063 | 6 | 0 |
280999 | 280999 | 2020-06-28 | Plumas | California | 6063 | 6 | 0 |
284145 | 284145 | 2020-06-29 | Plumas | California | 6063 | 6 | 0 |
287291 | 287291 | 2020-06-30 | Plumas | California | 6063 | 6 | 0 |
290442 | 290442 | 2020-07-01 | Plumas | California | 6063 | 8 | 0 |
293596 | 293596 | 2020-07-02 | Plumas | California | 6063 | 8 | 0 |
296752 | 296752 | 2020-07-03 | Plumas | California | 6063 | 8 | 0 |
299914 | 299914 | 2020-07-04 | Plumas | California | 6063 | 11 | 0 |
303078 | 303078 | 2020-07-05 | Plumas | California | 6063 | 11 | 0 |
306242 | 306242 | 2020-07-06 | Plumas | California | 6063 | 11 | 0 |
309410 | 309410 | 2020-07-07 | Plumas | California | 6063 | 11 | 0 |
312580 | 312580 | 2020-07-08 | Plumas | California | 6063 | 12 | 0 |
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);