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 date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Orange 264
- Los Angeles 263
- Santa Clara 259
- San Francisco 256
- San Diego 248
- Humboldt 238
- Sacramento 237
- Solano 235
- Sonoma 233
- Marin 232
- Napa 232
- Alameda 228
- Placer 227
- San Mateo 227
- Contra Costa 226
- Yolo 224
- Santa Cruz 223
- Fresno 222
- Madera 222
- Riverside 222
- Shasta 221
- Ventura 220
- San Joaquin 219
- Stanislaus 219
- Tulare 218
- San Benito 216
- San Luis Obispo 215
- San Bernardino 214
- Santa Barbara 214
- Nevada 213
- …
state 1
- California · 12,293 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
631867 | 631867 | 2020-10-15 | Santa Clara | California | 6085 | 22859 | 368 |
631868 | 631868 | 2020-10-15 | Santa Cruz | California | 6087 | 2670 | 23 |
631869 | 631869 | 2020-10-15 | Shasta | California | 6089 | 1640 | 28 |
631870 | 631870 | 2020-10-15 | Sierra | California | 6091 | 6 | 0 |
631871 | 631871 | 2020-10-15 | Siskiyou | California | 6093 | 183 | 0 |
631872 | 631872 | 2020-10-15 | Solano | California | 6095 | 6956 | 74 |
631873 | 631873 | 2020-10-15 | Sonoma | California | 6097 | 8684 | 128 |
631874 | 631874 | 2020-10-15 | Stanislaus | California | 6099 | 17160 | 389 |
631875 | 631875 | 2020-10-15 | Sutter | California | 6101 | 1793 | 12 |
631876 | 631876 | 2020-10-15 | Tehama | California | 6103 | 721 | 8 |
631877 | 631877 | 2020-10-15 | Trinity | California | 6105 | 21 | 0 |
631878 | 631878 | 2020-10-15 | Tulare | California | 6107 | 17072 | 274 |
631879 | 631879 | 2020-10-15 | Tuolumne | California | 6109 | 244 | 4 |
631880 | 631880 | 2020-10-15 | Ventura | California | 6111 | 13697 | 159 |
631881 | 631881 | 2020-10-15 | Yolo | California | 6113 | 3015 | 56 |
631882 | 631882 | 2020-10-15 | Yuba | California | 6115 | 1246 | 10 |
628581 | 628581 | 2020-10-14 | Alameda | California | 6001 | 22346 | 442 |
628582 | 628582 | 2020-10-14 | Alpine | California | 6003 | 3 | 0 |
628583 | 628583 | 2020-10-14 | Amador | California | 6005 | 305 | 16 |
628584 | 628584 | 2020-10-14 | Butte | California | 6007 | 2992 | 50 |
628585 | 628585 | 2020-10-14 | Calaveras | California | 6009 | 331 | 16 |
628586 | 628586 | 2020-10-14 | Colusa | California | 6011 | 545 | 6 |
628587 | 628587 | 2020-10-14 | Contra Costa | California | 6013 | 17783 | 231 |
628588 | 628588 | 2020-10-14 | Del Norte | California | 6015 | 171 | 1 |
628589 | 628589 | 2020-10-14 | El Dorado | California | 6017 | 1262 | 4 |
628590 | 628590 | 2020-10-14 | Fresno | California | 6019 | 29579 | 424 |
628591 | 628591 | 2020-10-14 | Glenn | California | 6021 | 629 | 3 |
628592 | 628592 | 2020-10-14 | Humboldt | California | 6023 | 542 | 8 |
628593 | 628593 | 2020-10-14 | Imperial | California | 6025 | 12334 | 334 |
628594 | 628594 | 2020-10-14 | Inyo | California | 6027 | 207 | 15 |
628595 | 628595 | 2020-10-14 | Kern | California | 6029 | 33145 | 406 |
628596 | 628596 | 2020-10-14 | Kings | California | 6031 | 8111 | 82 |
628597 | 628597 | 2020-10-14 | Lake | California | 6033 | 639 | 14 |
628598 | 628598 | 2020-10-14 | Lassen | California | 6035 | 752 | 1 |
628599 | 628599 | 2020-10-14 | Los Angeles | California | 6037 | 285016 | 6812 |
628600 | 628600 | 2020-10-14 | Madera | California | 6039 | 4808 | 73 |
628601 | 628601 | 2020-10-14 | Marin | California | 6041 | 6940 | 124 |
628602 | 628602 | 2020-10-14 | Mariposa | California | 6043 | 77 | 2 |
628603 | 628603 | 2020-10-14 | Mendocino | California | 6045 | 1063 | 21 |
628604 | 628604 | 2020-10-14 | Merced | California | 6047 | 9286 | 152 |
628605 | 628605 | 2020-10-14 | Modoc | California | 6049 | 28 | 0 |
628606 | 628606 | 2020-10-14 | Mono | California | 6051 | 173 | 2 |
628607 | 628607 | 2020-10-14 | Monterey | California | 6053 | 10827 | 81 |
628608 | 628608 | 2020-10-14 | Napa | California | 6055 | 1833 | 14 |
628609 | 628609 | 2020-10-14 | Nevada | California | 6057 | 576 | 8 |
628610 | 628610 | 2020-10-14 | Orange | California | 6059 | 58021 | 1360 |
628611 | 628611 | 2020-10-14 | Placer | California | 6061 | 3845 | 51 |
628612 | 628612 | 2020-10-14 | Plumas | California | 6063 | 51 | 0 |
628613 | 628613 | 2020-10-14 | Riverside | California | 6065 | 62900 | 1264 |
628614 | 628614 | 2020-10-14 | Sacramento | California | 6067 | 24059 | 462 |
628615 | 628615 | 2020-10-14 | San Benito | California | 6069 | 1390 | 13 |
628616 | 628616 | 2020-10-14 | San Bernardino | California | 6071 | 58936 | 986 |
628617 | 628617 | 2020-10-14 | San Diego | California | 6073 | 51390 | 844 |
628618 | 628618 | 2020-10-14 | San Francisco | California | 6075 | 11715 | 123 |
628619 | 628619 | 2020-10-14 | San Joaquin | California | 6077 | 20828 | 477 |
628620 | 628620 | 2020-10-14 | San Luis Obispo | California | 6079 | 3933 | 32 |
628621 | 628621 | 2020-10-14 | San Mateo | California | 6081 | 10622 | 155 |
628622 | 628622 | 2020-10-14 | Santa Barbara | California | 6083 | 9520 | 117 |
628623 | 628623 | 2020-10-14 | Santa Clara | California | 6085 | 22801 | 364 |
628624 | 628624 | 2020-10-14 | Santa Cruz | California | 6087 | 2633 | 23 |
628625 | 628625 | 2020-10-14 | Shasta | California | 6089 | 1623 | 28 |
628626 | 628626 | 2020-10-14 | Sierra | California | 6091 | 6 | 0 |
628627 | 628627 | 2020-10-14 | Siskiyou | California | 6093 | 183 | 0 |
628628 | 628628 | 2020-10-14 | Solano | California | 6095 | 6913 | 74 |
628629 | 628629 | 2020-10-14 | Sonoma | California | 6097 | 8615 | 128 |
628630 | 628630 | 2020-10-14 | Stanislaus | California | 6099 | 17130 | 388 |
628631 | 628631 | 2020-10-14 | Sutter | California | 6101 | 1785 | 12 |
628632 | 628632 | 2020-10-14 | Tehama | California | 6103 | 717 | 8 |
628633 | 628633 | 2020-10-14 | Trinity | California | 6105 | 20 | 0 |
628634 | 628634 | 2020-10-14 | Tulare | California | 6107 | 17015 | 273 |
628635 | 628635 | 2020-10-14 | Tuolumne | California | 6109 | 242 | 4 |
628636 | 628636 | 2020-10-14 | Ventura | California | 6111 | 13645 | 158 |
628637 | 628637 | 2020-10-14 | Yolo | California | 6113 | 3010 | 56 |
628638 | 628638 | 2020-10-14 | Yuba | California | 6115 | 1243 | 10 |
625338 | 625338 | 2020-10-13 | Alameda | California | 6001 | 22300 | 431 |
625339 | 625339 | 2020-10-13 | Alpine | California | 6003 | 3 | 0 |
625340 | 625340 | 2020-10-13 | Amador | California | 6005 | 304 | 16 |
625341 | 625341 | 2020-10-13 | Butte | California | 6007 | 2975 | 48 |
625342 | 625342 | 2020-10-13 | Calaveras | California | 6009 | 331 | 16 |
625343 | 625343 | 2020-10-13 | Colusa | California | 6011 | 543 | 6 |
625344 | 625344 | 2020-10-13 | Contra Costa | California | 6013 | 17728 | 230 |
625345 | 625345 | 2020-10-13 | Del Norte | California | 6015 | 170 | 1 |
625346 | 625346 | 2020-10-13 | El Dorado | California | 6017 | 1254 | 4 |
625347 | 625347 | 2020-10-13 | Fresno | California | 6019 | 29523 | 424 |
625348 | 625348 | 2020-10-13 | Glenn | California | 6021 | 626 | 3 |
625349 | 625349 | 2020-10-13 | Humboldt | California | 6023 | 534 | 8 |
625350 | 625350 | 2020-10-13 | Imperial | California | 6025 | 12290 | 329 |
625351 | 625351 | 2020-10-13 | Inyo | California | 6027 | 201 | 15 |
625352 | 625352 | 2020-10-13 | Kern | California | 6029 | 33089 | 397 |
625353 | 625353 | 2020-10-13 | Kings | California | 6031 | 8106 | 82 |
625354 | 625354 | 2020-10-13 | Lake | California | 6033 | 633 | 13 |
625355 | 625355 | 2020-10-13 | Lassen | California | 6035 | 752 | 1 |
625356 | 625356 | 2020-10-13 | Los Angeles | California | 6037 | 283750 | 6790 |
625357 | 625357 | 2020-10-13 | Madera | California | 6039 | 4796 | 71 |
625358 | 625358 | 2020-10-13 | Marin | California | 6041 | 6934 | 124 |
625359 | 625359 | 2020-10-13 | Mariposa | California | 6043 | 77 | 2 |
625360 | 625360 | 2020-10-13 | Mendocino | California | 6045 | 1055 | 21 |
625361 | 625361 | 2020-10-13 | Merced | California | 6047 | 9265 | 152 |
625362 | 625362 | 2020-10-13 | Modoc | California | 6049 | 27 | 0 |
625363 | 625363 | 2020-10-13 | Mono | California | 6051 | 173 | 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);