ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 6027 and state = "California" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
10943 | 10943 | 2020-03-25 | Inyo | California | 6027 | 1 | 0 |
12488 | 12488 | 2020-03-26 | Inyo | California | 6027 | 2 | 0 |
14153 | 14153 | 2020-03-27 | Inyo | California | 6027 | 5 | 0 |
15935 | 15935 | 2020-03-28 | Inyo | California | 6027 | 5 | 0 |
17824 | 17824 | 2020-03-29 | Inyo | California | 6027 | 8 | 0 |
19801 | 19801 | 2020-03-30 | Inyo | California | 6027 | 8 | 0 |
21875 | 21875 | 2020-03-31 | Inyo | California | 6027 | 8 | 0 |
24033 | 24033 | 2020-04-01 | Inyo | California | 6027 | 9 | 0 |
26262 | 26262 | 2020-04-02 | Inyo | California | 6027 | 10 | 1 |
28561 | 28561 | 2020-04-03 | Inyo | California | 6027 | 10 | 0 |
30919 | 30919 | 2020-04-04 | Inyo | California | 6027 | 10 | 0 |
33325 | 33325 | 2020-04-05 | Inyo | California | 6027 | 11 | 0 |
35769 | 35769 | 2020-04-06 | Inyo | California | 6027 | 11 | 0 |
38258 | 38258 | 2020-04-07 | Inyo | California | 6027 | 11 | 0 |
40802 | 40802 | 2020-04-08 | Inyo | California | 6027 | 11 | 0 |
43374 | 43374 | 2020-04-09 | Inyo | California | 6027 | 11 | 0 |
45974 | 45974 | 2020-04-10 | Inyo | California | 6027 | 12 | 0 |
48604 | 48604 | 2020-04-11 | Inyo | California | 6027 | 12 | 0 |
51266 | 51266 | 2020-04-12 | Inyo | California | 6027 | 12 | 0 |
53945 | 53945 | 2020-04-13 | Inyo | California | 6027 | 12 | 0 |
56637 | 56637 | 2020-04-14 | Inyo | California | 6027 | 12 | 0 |
59345 | 59345 | 2020-04-15 | Inyo | California | 6027 | 17 | 0 |
62064 | 62064 | 2020-04-16 | Inyo | California | 6027 | 17 | 0 |
64797 | 64797 | 2020-04-17 | Inyo | California | 6027 | 18 | 0 |
67545 | 67545 | 2020-04-18 | Inyo | California | 6027 | 18 | 0 |
70307 | 70307 | 2020-04-19 | Inyo | California | 6027 | 18 | 0 |
73076 | 73076 | 2020-04-20 | Inyo | California | 6027 | 18 | 0 |
75852 | 75852 | 2020-04-21 | Inyo | California | 6027 | 18 | 0 |
78636 | 78636 | 2020-04-22 | Inyo | California | 6027 | 19 | 0 |
81430 | 81430 | 2020-04-23 | Inyo | California | 6027 | 19 | 0 |
84230 | 84230 | 2020-04-24 | Inyo | California | 6027 | 19 | 1 |
87038 | 87038 | 2020-04-25 | Inyo | California | 6027 | 19 | 1 |
89855 | 89855 | 2020-04-26 | Inyo | California | 6027 | 19 | 1 |
92673 | 92673 | 2020-04-27 | Inyo | California | 6027 | 20 | 1 |
95504 | 95504 | 2020-04-28 | Inyo | California | 6027 | 20 | 1 |
98349 | 98349 | 2020-04-29 | Inyo | California | 6027 | 20 | 1 |
101199 | 101199 | 2020-04-30 | Inyo | California | 6027 | 20 | 1 |
104054 | 104054 | 2020-05-01 | Inyo | California | 6027 | 20 | 1 |
106919 | 106919 | 2020-05-02 | Inyo | California | 6027 | 20 | 1 |
109788 | 109788 | 2020-05-03 | Inyo | California | 6027 | 20 | 1 |
112663 | 112663 | 2020-05-04 | Inyo | California | 6027 | 20 | 1 |
115546 | 115546 | 2020-05-05 | Inyo | California | 6027 | 20 | 1 |
118505 | 118505 | 2020-05-06 | Inyo | California | 6027 | 20 | 1 |
121472 | 121472 | 2020-05-07 | Inyo | California | 6027 | 20 | 1 |
124452 | 124452 | 2020-05-08 | Inyo | California | 6027 | 20 | 1 |
127437 | 127437 | 2020-05-09 | Inyo | California | 6027 | 20 | 1 |
130427 | 130427 | 2020-05-10 | Inyo | California | 6027 | 20 | 1 |
133417 | 133417 | 2020-05-11 | Inyo | California | 6027 | 20 | 1 |
136407 | 136407 | 2020-05-12 | Inyo | California | 6027 | 20 | 1 |
139398 | 139398 | 2020-05-13 | Inyo | California | 6027 | 20 | 1 |
142394 | 142394 | 2020-05-14 | Inyo | California | 6027 | 20 | 1 |
145393 | 145393 | 2020-05-15 | Inyo | California | 6027 | 20 | 1 |
148397 | 148397 | 2020-05-16 | Inyo | California | 6027 | 20 | 1 |
151406 | 151406 | 2020-05-17 | Inyo | California | 6027 | 20 | 1 |
154418 | 154418 | 2020-05-18 | Inyo | California | 6027 | 20 | 1 |
157434 | 157434 | 2020-05-19 | Inyo | California | 6027 | 20 | 1 |
160460 | 160460 | 2020-05-20 | Inyo | California | 6027 | 20 | 1 |
163488 | 163488 | 2020-05-21 | Inyo | California | 6027 | 20 | 1 |
166520 | 166520 | 2020-05-22 | Inyo | California | 6027 | 20 | 1 |
169556 | 169556 | 2020-05-23 | Inyo | California | 6027 | 20 | 1 |
172597 | 172597 | 2020-05-24 | Inyo | California | 6027 | 20 | 1 |
175641 | 175641 | 2020-05-25 | Inyo | California | 6027 | 20 | 1 |
178685 | 178685 | 2020-05-26 | Inyo | California | 6027 | 20 | 1 |
181729 | 181729 | 2020-05-27 | Inyo | California | 6027 | 20 | 1 |
184783 | 184783 | 2020-05-28 | Inyo | California | 6027 | 20 | 1 |
187839 | 187839 | 2020-05-29 | Inyo | California | 6027 | 20 | 1 |
190904 | 190904 | 2020-05-30 | Inyo | California | 6027 | 20 | 1 |
193971 | 193971 | 2020-05-31 | Inyo | California | 6027 | 20 | 1 |
197041 | 197041 | 2020-06-01 | Inyo | California | 6027 | 20 | 1 |
200114 | 200114 | 2020-06-02 | Inyo | California | 6027 | 20 | 1 |
203190 | 203190 | 2020-06-03 | Inyo | California | 6027 | 20 | 1 |
206270 | 206270 | 2020-06-04 | Inyo | California | 6027 | 20 | 1 |
209351 | 209351 | 2020-06-05 | Inyo | California | 6027 | 20 | 1 |
212436 | 212436 | 2020-06-06 | Inyo | California | 6027 | 21 | 1 |
215523 | 215523 | 2020-06-07 | Inyo | California | 6027 | 21 | 1 |
218614 | 218614 | 2020-06-08 | Inyo | California | 6027 | 21 | 1 |
221709 | 221709 | 2020-06-09 | Inyo | California | 6027 | 22 | 1 |
224804 | 224804 | 2020-06-10 | Inyo | California | 6027 | 22 | 1 |
227906 | 227906 | 2020-06-11 | Inyo | California | 6027 | 23 | 1 |
231009 | 231009 | 2020-06-12 | Inyo | California | 6027 | 23 | 1 |
234115 | 234115 | 2020-06-13 | Inyo | California | 6027 | 23 | 1 |
237222 | 237222 | 2020-06-14 | Inyo | California | 6027 | 23 | 1 |
240330 | 240330 | 2020-06-15 | Inyo | California | 6027 | 23 | 1 |
243441 | 243441 | 2020-06-16 | Inyo | California | 6027 | 23 | 1 |
246554 | 246554 | 2020-06-17 | Inyo | California | 6027 | 24 | 1 |
249666 | 249666 | 2020-06-18 | Inyo | California | 6027 | 25 | 1 |
252781 | 252781 | 2020-06-19 | Inyo | California | 6027 | 25 | 1 |
255900 | 255900 | 2020-06-20 | Inyo | California | 6027 | 26 | 1 |
259027 | 259027 | 2020-06-21 | Inyo | California | 6027 | 26 | 1 |
262154 | 262154 | 2020-06-22 | Inyo | California | 6027 | 26 | 1 |
265282 | 265282 | 2020-06-23 | Inyo | California | 6027 | 26 | 1 |
268412 | 268412 | 2020-06-24 | Inyo | California | 6027 | 26 | 1 |
274687 | 274687 | 2020-06-26 | Inyo | California | 6027 | 27 | 1 |
271547 | 271547 | 2020-06-25 | Inyo | California | 6027 | 28 | 1 |
277835 | 277835 | 2020-06-27 | Inyo | California | 6027 | 29 | 1 |
280982 | 280982 | 2020-06-28 | Inyo | California | 6027 | 29 | 1 |
284128 | 284128 | 2020-06-29 | Inyo | California | 6027 | 29 | 1 |
287274 | 287274 | 2020-06-30 | Inyo | California | 6027 | 29 | 1 |
296735 | 296735 | 2020-07-03 | Inyo | California | 6027 | 29 | 1 |
290425 | 290425 | 2020-07-01 | Inyo | California | 6027 | 30 | 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);