ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 6069 and state = "California" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1643 | 1643 | 2020-03-13 | San Benito | California | 6069 | 1 | 0 |
1960 | 1960 | 2020-03-14 | San Benito | California | 6069 | 1 | 0 |
2339 | 2339 | 2020-03-15 | San Benito | California | 6069 | 1 | 0 |
2774 | 2774 | 2020-03-16 | San Benito | California | 6069 | 1 | 0 |
3256 | 3256 | 2020-03-17 | San Benito | California | 6069 | 2 | 1 |
3810 | 3810 | 2020-03-18 | San Benito | California | 6069 | 5 | 1 |
4470 | 4470 | 2020-03-19 | San Benito | California | 6069 | 5 | 1 |
5245 | 5245 | 2020-03-20 | San Benito | California | 6069 | 5 | 1 |
6166 | 6166 | 2020-03-21 | San Benito | California | 6069 | 5 | 1 |
7200 | 7200 | 2020-03-22 | San Benito | California | 6069 | 5 | 1 |
8343 | 8343 | 2020-03-23 | San Benito | California | 6069 | 6 | 1 |
9586 | 9586 | 2020-03-24 | San Benito | California | 6069 | 7 | 1 |
10958 | 10958 | 2020-03-25 | San Benito | California | 6069 | 9 | 1 |
12503 | 12503 | 2020-03-26 | San Benito | California | 6069 | 9 | 1 |
14169 | 14169 | 2020-03-27 | San Benito | California | 6069 | 11 | 1 |
15951 | 15951 | 2020-03-28 | San Benito | California | 6069 | 11 | 1 |
17840 | 17840 | 2020-03-29 | San Benito | California | 6069 | 14 | 1 |
19817 | 19817 | 2020-03-30 | San Benito | California | 6069 | 17 | 1 |
21892 | 21892 | 2020-03-31 | San Benito | California | 6069 | 21 | 1 |
24050 | 24050 | 2020-04-01 | San Benito | California | 6069 | 23 | 1 |
26279 | 26279 | 2020-04-02 | San Benito | California | 6069 | 23 | 1 |
28578 | 28578 | 2020-04-03 | San Benito | California | 6069 | 23 | 2 |
30936 | 30936 | 2020-04-04 | San Benito | California | 6069 | 23 | 2 |
33342 | 33342 | 2020-04-05 | San Benito | California | 6069 | 23 | 2 |
35787 | 35787 | 2020-04-06 | San Benito | California | 6069 | 30 | 2 |
38276 | 38276 | 2020-04-07 | San Benito | California | 6069 | 31 | 2 |
40820 | 40820 | 2020-04-08 | San Benito | California | 6069 | 33 | 2 |
43392 | 43392 | 2020-04-09 | San Benito | California | 6069 | 34 | 2 |
45992 | 45992 | 2020-04-10 | San Benito | California | 6069 | 35 | 2 |
48622 | 48622 | 2020-04-11 | San Benito | California | 6069 | 35 | 2 |
51284 | 51284 | 2020-04-12 | San Benito | California | 6069 | 35 | 2 |
53963 | 53963 | 2020-04-13 | San Benito | California | 6069 | 38 | 2 |
56655 | 56655 | 2020-04-14 | San Benito | California | 6069 | 39 | 2 |
59363 | 59363 | 2020-04-15 | San Benito | California | 6069 | 41 | 2 |
62082 | 62082 | 2020-04-16 | San Benito | California | 6069 | 42 | 2 |
64815 | 64815 | 2020-04-17 | San Benito | California | 6069 | 44 | 2 |
67563 | 67563 | 2020-04-18 | San Benito | California | 6069 | 44 | 2 |
70325 | 70325 | 2020-04-19 | San Benito | California | 6069 | 44 | 2 |
73094 | 73094 | 2020-04-20 | San Benito | California | 6069 | 44 | 2 |
75870 | 75870 | 2020-04-21 | San Benito | California | 6069 | 45 | 2 |
78654 | 78654 | 2020-04-22 | San Benito | California | 6069 | 46 | 2 |
81448 | 81448 | 2020-04-23 | San Benito | California | 6069 | 47 | 2 |
84248 | 84248 | 2020-04-24 | San Benito | California | 6069 | 47 | 2 |
87056 | 87056 | 2020-04-25 | San Benito | California | 6069 | 47 | 2 |
89873 | 89873 | 2020-04-26 | San Benito | California | 6069 | 47 | 2 |
92691 | 92691 | 2020-04-27 | San Benito | California | 6069 | 48 | 2 |
95523 | 95523 | 2020-04-28 | San Benito | California | 6069 | 50 | 2 |
98368 | 98368 | 2020-04-29 | San Benito | California | 6069 | 50 | 2 |
101218 | 101218 | 2020-04-30 | San Benito | California | 6069 | 51 | 2 |
104073 | 104073 | 2020-05-01 | San Benito | California | 6069 | 51 | 2 |
106938 | 106938 | 2020-05-02 | San Benito | California | 6069 | 51 | 2 |
109807 | 109807 | 2020-05-03 | San Benito | California | 6069 | 51 | 2 |
112682 | 112682 | 2020-05-04 | San Benito | California | 6069 | 52 | 2 |
115565 | 115565 | 2020-05-05 | San Benito | California | 6069 | 53 | 2 |
118524 | 118524 | 2020-05-06 | San Benito | California | 6069 | 53 | 2 |
121491 | 121491 | 2020-05-07 | San Benito | California | 6069 | 54 | 2 |
124471 | 124471 | 2020-05-08 | San Benito | California | 6069 | 55 | 2 |
127456 | 127456 | 2020-05-09 | San Benito | California | 6069 | 55 | 2 |
130446 | 130446 | 2020-05-10 | San Benito | California | 6069 | 55 | 2 |
133436 | 133436 | 2020-05-11 | San Benito | California | 6069 | 56 | 2 |
136426 | 136426 | 2020-05-12 | San Benito | California | 6069 | 58 | 2 |
139417 | 139417 | 2020-05-13 | San Benito | California | 6069 | 58 | 2 |
142413 | 142413 | 2020-05-14 | San Benito | California | 6069 | 59 | 2 |
145412 | 145412 | 2020-05-15 | San Benito | California | 6069 | 60 | 2 |
148416 | 148416 | 2020-05-16 | San Benito | California | 6069 | 61 | 2 |
151425 | 151425 | 2020-05-17 | San Benito | California | 6069 | 61 | 2 |
154437 | 154437 | 2020-05-18 | San Benito | California | 6069 | 61 | 2 |
157453 | 157453 | 2020-05-19 | San Benito | California | 6069 | 63 | 2 |
160479 | 160479 | 2020-05-20 | San Benito | California | 6069 | 64 | 2 |
163507 | 163507 | 2020-05-21 | San Benito | California | 6069 | 66 | 2 |
166539 | 166539 | 2020-05-22 | San Benito | California | 6069 | 69 | 2 |
169576 | 169576 | 2020-05-23 | San Benito | California | 6069 | 69 | 2 |
172617 | 172617 | 2020-05-24 | San Benito | California | 6069 | 70 | 2 |
175661 | 175661 | 2020-05-25 | San Benito | California | 6069 | 72 | 2 |
178705 | 178705 | 2020-05-26 | San Benito | California | 6069 | 76 | 2 |
181749 | 181749 | 2020-05-27 | San Benito | California | 6069 | 83 | 2 |
184803 | 184803 | 2020-05-28 | San Benito | California | 6069 | 85 | 2 |
187859 | 187859 | 2020-05-29 | San Benito | California | 6069 | 87 | 2 |
190924 | 190924 | 2020-05-30 | San Benito | California | 6069 | 87 | 2 |
193991 | 193991 | 2020-05-31 | San Benito | California | 6069 | 87 | 2 |
197061 | 197061 | 2020-06-01 | San Benito | California | 6069 | 88 | 2 |
200134 | 200134 | 2020-06-02 | San Benito | California | 6069 | 90 | 2 |
203210 | 203210 | 2020-06-03 | San Benito | California | 6069 | 96 | 2 |
206290 | 206290 | 2020-06-04 | San Benito | California | 6069 | 102 | 2 |
209371 | 209371 | 2020-06-05 | San Benito | California | 6069 | 105 | 2 |
212456 | 212456 | 2020-06-06 | San Benito | California | 6069 | 105 | 2 |
215543 | 215543 | 2020-06-07 | San Benito | California | 6069 | 107 | 2 |
218634 | 218634 | 2020-06-08 | San Benito | California | 6069 | 109 | 2 |
221729 | 221729 | 2020-06-09 | San Benito | California | 6069 | 109 | 2 |
224824 | 224824 | 2020-06-10 | San Benito | California | 6069 | 109 | 2 |
227926 | 227926 | 2020-06-11 | San Benito | California | 6069 | 112 | 2 |
231029 | 231029 | 2020-06-12 | San Benito | California | 6069 | 118 | 2 |
234135 | 234135 | 2020-06-13 | San Benito | California | 6069 | 121 | 2 |
237242 | 237242 | 2020-06-14 | San Benito | California | 6069 | 125 | 2 |
240350 | 240350 | 2020-06-15 | San Benito | California | 6069 | 129 | 2 |
243461 | 243461 | 2020-06-16 | San Benito | California | 6069 | 136 | 2 |
246574 | 246574 | 2020-06-17 | San Benito | California | 6069 | 140 | 2 |
249686 | 249686 | 2020-06-18 | San Benito | California | 6069 | 153 | 2 |
252801 | 252801 | 2020-06-19 | San Benito | California | 6069 | 161 | 2 |
255920 | 255920 | 2020-06-20 | San Benito | California | 6069 | 164 | 2 |
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);