ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 6071 and state = "California" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2340 | 2340 | 2020-03-15 | San Bernardino | California | 6071 | 1 | 0 |
2775 | 2775 | 2020-03-16 | San Bernardino | California | 6071 | 2 | 0 |
3257 | 3257 | 2020-03-17 | San Bernardino | California | 6071 | 3 | 0 |
3811 | 3811 | 2020-03-18 | San Bernardino | California | 6071 | 5 | 0 |
4471 | 4471 | 2020-03-19 | San Bernardino | California | 6071 | 5 | 0 |
5246 | 5246 | 2020-03-20 | San Bernardino | California | 6071 | 9 | 0 |
6167 | 6167 | 2020-03-21 | San Bernardino | California | 6071 | 9 | 0 |
7201 | 7201 | 2020-03-22 | San Bernardino | California | 6071 | 17 | 0 |
8344 | 8344 | 2020-03-23 | San Bernardino | California | 6071 | 17 | 0 |
9587 | 9587 | 2020-03-24 | San Bernardino | California | 6071 | 38 | 1 |
10959 | 10959 | 2020-03-25 | San Bernardino | California | 6071 | 54 | 2 |
12504 | 12504 | 2020-03-26 | San Bernardino | California | 6071 | 55 | 3 |
14170 | 14170 | 2020-03-27 | San Bernardino | California | 6071 | 64 | 3 |
15952 | 15952 | 2020-03-28 | San Bernardino | California | 6071 | 64 | 3 |
17841 | 17841 | 2020-03-29 | San Bernardino | California | 6071 | 111 | 3 |
19818 | 19818 | 2020-03-30 | San Bernardino | California | 6071 | 111 | 3 |
21893 | 21893 | 2020-03-31 | San Bernardino | California | 6071 | 183 | 6 |
24051 | 24051 | 2020-04-01 | San Bernardino | California | 6071 | 254 | 6 |
26280 | 26280 | 2020-04-02 | San Bernardino | California | 6071 | 304 | 8 |
28579 | 28579 | 2020-04-03 | San Bernardino | California | 6071 | 353 | 13 |
30937 | 30937 | 2020-04-04 | San Bernardino | California | 6071 | 353 | 13 |
33343 | 33343 | 2020-04-05 | San Bernardino | California | 6071 | 372 | 13 |
35788 | 35788 | 2020-04-06 | San Bernardino | California | 6071 | 530 | 16 |
38277 | 38277 | 2020-04-07 | San Bernardino | California | 6071 | 547 | 17 |
40821 | 40821 | 2020-04-08 | San Bernardino | California | 6071 | 641 | 20 |
43393 | 43393 | 2020-04-09 | San Bernardino | California | 6071 | 729 | 24 |
45993 | 45993 | 2020-04-10 | San Bernardino | California | 6071 | 810 | 25 |
48623 | 48623 | 2020-04-11 | San Bernardino | California | 6071 | 810 | 25 |
51285 | 51285 | 2020-04-12 | San Bernardino | California | 6071 | 887 | 31 |
53964 | 53964 | 2020-04-13 | San Bernardino | California | 6071 | 977 | 31 |
56656 | 56656 | 2020-04-14 | San Bernardino | California | 6071 | 977 | 31 |
59364 | 59364 | 2020-04-15 | San Bernardino | California | 6071 | 996 | 39 |
62083 | 62083 | 2020-04-16 | San Bernardino | California | 6071 | 1032 | 47 |
64816 | 64816 | 2020-04-17 | San Bernardino | California | 6071 | 1096 | 55 |
67564 | 67564 | 2020-04-18 | San Bernardino | California | 6071 | 1219 | 57 |
70326 | 70326 | 2020-04-19 | San Bernardino | California | 6071 | 1286 | 57 |
73095 | 73095 | 2020-04-20 | San Bernardino | California | 6071 | 1406 | 60 |
75871 | 75871 | 2020-04-21 | San Bernardino | California | 6071 | 1489 | 67 |
78655 | 78655 | 2020-04-22 | San Bernardino | California | 6071 | 1489 | 67 |
81449 | 81449 | 2020-04-23 | San Bernardino | California | 6071 | 1564 | 72 |
84249 | 84249 | 2020-04-24 | San Bernardino | California | 6071 | 1666 | 80 |
87057 | 87057 | 2020-04-25 | San Bernardino | California | 6071 | 1732 | 82 |
89874 | 89874 | 2020-04-26 | San Bernardino | California | 6071 | 1751 | 82 |
92692 | 92692 | 2020-04-27 | San Bernardino | California | 6071 | 1772 | 82 |
95524 | 95524 | 2020-04-28 | San Bernardino | California | 6071 | 1827 | 85 |
98369 | 98369 | 2020-04-29 | San Bernardino | California | 6071 | 1928 | 89 |
101219 | 101219 | 2020-04-30 | San Bernardino | California | 6071 | 2058 | 93 |
104074 | 104074 | 2020-05-01 | San Bernardino | California | 6071 | 2113 | 96 |
106939 | 106939 | 2020-05-02 | San Bernardino | California | 6071 | 2182 | 98 |
109808 | 109808 | 2020-05-03 | San Bernardino | California | 6071 | 2182 | 99 |
112683 | 112683 | 2020-05-04 | San Bernardino | California | 6071 | 2182 | 99 |
115566 | 115566 | 2020-05-05 | San Bernardino | California | 6071 | 2329 | 101 |
118525 | 118525 | 2020-05-06 | San Bernardino | California | 6071 | 2432 | 104 |
121492 | 121492 | 2020-05-07 | San Bernardino | California | 6071 | 2562 | 108 |
124472 | 124472 | 2020-05-08 | San Bernardino | California | 6071 | 2629 | 111 |
127457 | 127457 | 2020-05-09 | San Bernardino | California | 6071 | 2902 | 119 |
130447 | 130447 | 2020-05-10 | San Bernardino | California | 6071 | 2964 | 121 |
133437 | 133437 | 2020-05-11 | San Bernardino | California | 6071 | 3015 | 121 |
136427 | 136427 | 2020-05-12 | San Bernardino | California | 6071 | 3078 | 121 |
139418 | 139418 | 2020-05-13 | San Bernardino | California | 6071 | 3153 | 138 |
142414 | 142414 | 2020-05-14 | San Bernardino | California | 6071 | 3198 | 139 |
145413 | 145413 | 2020-05-15 | San Bernardino | California | 6071 | 3311 | 150 |
148417 | 148417 | 2020-05-16 | San Bernardino | California | 6071 | 3463 | 155 |
151426 | 151426 | 2020-05-17 | San Bernardino | California | 6071 | 3511 | 155 |
154438 | 154438 | 2020-05-18 | San Bernardino | California | 6071 | 3593 | 155 |
157454 | 157454 | 2020-05-19 | San Bernardino | California | 6071 | 3707 | 157 |
160480 | 160480 | 2020-05-20 | San Bernardino | California | 6071 | 3795 | 158 |
163508 | 163508 | 2020-05-21 | San Bernardino | California | 6071 | 3984 | 164 |
166540 | 166540 | 2020-05-22 | San Bernardino | California | 6071 | 4146 | 173 |
169577 | 169577 | 2020-05-23 | San Bernardino | California | 6071 | 4315 | 176 |
172618 | 172618 | 2020-05-24 | San Bernardino | California | 6071 | 4365 | 176 |
175662 | 175662 | 2020-05-25 | San Bernardino | California | 6071 | 4365 | 176 |
178706 | 178706 | 2020-05-26 | San Bernardino | California | 6071 | 4567 | 176 |
181750 | 181750 | 2020-05-27 | San Bernardino | California | 6071 | 4777 | 183 |
184804 | 184804 | 2020-05-28 | San Bernardino | California | 6071 | 4914 | 190 |
187860 | 187860 | 2020-05-29 | San Bernardino | California | 6071 | 5034 | 199 |
190925 | 190925 | 2020-05-30 | San Bernardino | California | 6071 | 5200 | 204 |
193992 | 193992 | 2020-05-31 | San Bernardino | California | 6071 | 5246 | 204 |
197062 | 197062 | 2020-06-01 | San Bernardino | California | 6071 | 5355 | 204 |
200135 | 200135 | 2020-06-02 | San Bernardino | California | 6071 | 5501 | 208 |
203211 | 203211 | 2020-06-03 | San Bernardino | California | 6071 | 5650 | 209 |
206291 | 206291 | 2020-06-04 | San Bernardino | California | 6071 | 5793 | 210 |
209372 | 209372 | 2020-06-05 | San Bernardino | California | 6071 | 5930 | 217 |
212457 | 212457 | 2020-06-06 | San Bernardino | California | 6071 | 6040 | 224 |
215544 | 215544 | 2020-06-07 | San Bernardino | California | 6071 | 6040 | 224 |
218635 | 218635 | 2020-06-08 | San Bernardino | California | 6071 | 6247 | 224 |
221730 | 221730 | 2020-06-09 | San Bernardino | California | 6071 | 6417 | 224 |
224825 | 224825 | 2020-06-10 | San Bernardino | California | 6071 | 6593 | 225 |
227927 | 227927 | 2020-06-11 | San Bernardino | California | 6071 | 6742 | 227 |
231030 | 231030 | 2020-06-12 | San Bernardino | California | 6071 | 6976 | 229 |
234136 | 234136 | 2020-06-13 | San Bernardino | California | 6071 | 7161 | 229 |
237243 | 237243 | 2020-06-14 | San Bernardino | California | 6071 | 7359 | 229 |
240351 | 240351 | 2020-06-15 | San Bernardino | California | 6071 | 7515 | 229 |
243462 | 243462 | 2020-06-16 | San Bernardino | California | 6071 | 7796 | 229 |
246575 | 246575 | 2020-06-17 | San Bernardino | California | 6071 | 8014 | 229 |
249687 | 249687 | 2020-06-18 | San Bernardino | California | 6071 | 8454 | 230 |
252802 | 252802 | 2020-06-19 | San Bernardino | California | 6071 | 8714 | 230 |
255921 | 255921 | 2020-06-20 | San Bernardino | California | 6071 | 8959 | 233 |
259048 | 259048 | 2020-06-21 | San Bernardino | California | 6071 | 9156 | 233 |
262175 | 262175 | 2020-06-22 | San Bernardino | California | 6071 | 9361 | 234 |
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);