ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
45,693 rows where state = "California" sorted by fips descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Orange 840
- Los Angeles 839
- Santa Clara 834
- San Francisco 832
- San Diego 824
- Humboldt 814
- Sacramento 813
- Solano 810
- Marin 808
- Napa 808
- Sonoma 808
- Alameda 804
- Placer 803
- San Mateo 803
- Contra Costa 802
- Yolo 799
- Fresno 798
- Madera 798
- Riverside 798
- Santa Cruz 798
- Shasta 796
- San Joaquin 795
- Ventura 795
- Stanislaus 794
- Tulare 793
- San Benito 792
- San Luis Obispo 791
- San Bernardino 790
- Santa Barbara 790
- Nevada 789
- …
state 1
- California · 45,693 ✖
Link | rowid | date | county | state | fips ▲ | cases | deaths |
---|---|---|---|---|---|---|---|
7216 | 7216 | 2020-03-22 | Unknown | California | 1 | 0 | |
8359 | 8359 | 2020-03-23 | Unknown | California | 2 | 0 | |
24068 | 24068 | 2020-04-01 | Unknown | California | 0 | 1 | |
26297 | 26297 | 2020-04-02 | Unknown | California | 0 | 2 | |
28597 | 28597 | 2020-04-03 | Unknown | California | 1 | 0 | |
38295 | 38295 | 2020-04-07 | Unknown | California | 1 | 0 | |
127475 | 127475 | 2020-05-09 | Unknown | California | 1 | 0 | |
133456 | 133456 | 2020-05-11 | Unknown | California | 1 | 0 | |
145432 | 145432 | 2020-05-15 | Unknown | California | 0 | 1 | |
1472545 | 1472545 | 2021-07-01 | Unknown | California | 33081 | 0 | |
1475791 | 1475791 | 2021-07-02 | Unknown | California | 32847 | 0 | |
1479037 | 1479037 | 2021-07-03 | Unknown | California | 32147 | 0 | |
1482284 | 1482284 | 2021-07-04 | Unknown | California | 31576 | 0 | |
1485530 | 1485530 | 2021-07-05 | Unknown | California | 30956 | 0 | |
1488777 | 1488777 | 2021-07-06 | Unknown | California | 34343 | 0 | |
1492024 | 1492024 | 2021-07-07 | Unknown | California | 32022 | 0 | |
2193952 | 2193952 | 2022-02-08 | Unknown | California | 5479 | 0 | |
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 |
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);