ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where "date" is on date 2020-11-20 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
748620 | 748620 | 2020-11-20 | Alameda | California | 6001 | 27244 | 499 |
748621 | 748621 | 2020-11-20 | Alpine | California | 6003 | 20 | 0 |
748622 | 748622 | 2020-11-20 | Amador | California | 6005 | 435 | 16 |
748623 | 748623 | 2020-11-20 | Butte | California | 6007 | 3624 | 59 |
748624 | 748624 | 2020-11-20 | Calaveras | California | 6009 | 422 | 21 |
748625 | 748625 | 2020-11-20 | Colusa | California | 6011 | 639 | 6 |
748626 | 748626 | 2020-11-20 | Contra Costa | California | 6013 | 22191 | 257 |
748627 | 748627 | 2020-11-20 | Del Norte | California | 6015 | 251 | 1 |
748628 | 748628 | 2020-11-20 | El Dorado | California | 6017 | 1825 | 4 |
748629 | 748629 | 2020-11-20 | Fresno | California | 6019 | 35711 | 471 |
748630 | 748630 | 2020-11-20 | Glenn | California | 6021 | 806 | 6 |
748631 | 748631 | 2020-11-20 | Humboldt | California | 6023 | 730 | 9 |
748632 | 748632 | 2020-11-20 | Imperial | California | 6025 | 14720 | 352 |
748633 | 748633 | 2020-11-20 | Inyo | California | 6027 | 262 | 16 |
748634 | 748634 | 2020-11-20 | Kern | California | 6029 | 37982 | 440 |
748635 | 748635 | 2020-11-20 | Kings | California | 6031 | 9922 | 86 |
748636 | 748636 | 2020-11-20 | Lake | California | 6033 | 809 | 18 |
748637 | 748637 | 2020-11-20 | Lassen | California | 6035 | 1355 | 2 |
748638 | 748638 | 2020-11-20 | Los Angeles | California | 6037 | 357541 | 7396 |
748639 | 748639 | 2020-11-20 | Madera | California | 6039 | 5714 | 80 |
748640 | 748640 | 2020-11-20 | Marin | California | 6041 | 7506 | 128 |
748641 | 748641 | 2020-11-20 | Mariposa | California | 6043 | 94 | 2 |
748642 | 748642 | 2020-11-20 | Mendocino | California | 6045 | 1385 | 22 |
748643 | 748643 | 2020-11-20 | Merced | California | 6047 | 10986 | 176 |
748644 | 748644 | 2020-11-20 | Modoc | California | 6049 | 108 | 0 |
748645 | 748645 | 2020-11-20 | Mono | California | 6051 | 499 | 3 |
748646 | 748646 | 2020-11-20 | Monterey | California | 6053 | 13524 | 113 |
748647 | 748647 | 2020-11-20 | Napa | California | 6055 | 2696 | 17 |
748648 | 748648 | 2020-11-20 | Nevada | California | 6057 | 1015 | 9 |
748649 | 748649 | 2020-11-20 | Orange | California | 6059 | 70593 | 1540 |
748650 | 748650 | 2020-11-20 | Placer | California | 6061 | 5687 | 67 |
748651 | 748651 | 2020-11-20 | Plumas | California | 6063 | 158 | 0 |
748652 | 748652 | 2020-11-20 | Riverside | California | 6065 | 78535 | 1400 |
748653 | 748653 | 2020-11-20 | Sacramento | California | 6067 | 32864 | 546 |
748654 | 748654 | 2020-11-20 | San Benito | California | 6069 | 1694 | 15 |
748655 | 748655 | 2020-11-20 | San Bernardino | California | 6071 | 81328 | 1125 |
748656 | 748656 | 2020-11-20 | San Diego | California | 6073 | 69294 | 960 |
748657 | 748657 | 2020-11-20 | San Francisco | California | 6075 | 14254 | 156 |
748658 | 748658 | 2020-11-20 | San Joaquin | California | 6077 | 24649 | 504 |
748659 | 748659 | 2020-11-20 | San Luis Obispo | California | 6079 | 5607 | 35 |
748660 | 748660 | 2020-11-20 | San Mateo | California | 6081 | 12988 | 169 |
748661 | 748661 | 2020-11-20 | Santa Barbara | California | 6083 | 10839 | 133 |
748662 | 748662 | 2020-11-20 | Santa Clara | California | 6085 | 30025 | 464 |
748663 | 748663 | 2020-11-20 | Santa Cruz | California | 6087 | 3819 | 27 |
748664 | 748664 | 2020-11-20 | Shasta | California | 6089 | 3897 | 42 |
748665 | 748665 | 2020-11-20 | Sierra | California | 6091 | 11 | 0 |
748666 | 748666 | 2020-11-20 | Siskiyou | California | 6093 | 495 | 1 |
748667 | 748667 | 2020-11-20 | Solano | California | 6095 | 9354 | 80 |
748668 | 748668 | 2020-11-20 | Sonoma | California | 6097 | 11363 | 155 |
748669 | 748669 | 2020-11-20 | Stanislaus | California | 6099 | 21110 | 416 |
748670 | 748670 | 2020-11-20 | Sutter | California | 6101 | 2638 | 13 |
748671 | 748671 | 2020-11-20 | Tehama | California | 6103 | 1373 | 23 |
748672 | 748672 | 2020-11-20 | Trinity | California | 6105 | 98 | 0 |
748673 | 748673 | 2020-11-20 | Tulare | California | 6107 | 19673 | 303 |
748674 | 748674 | 2020-11-20 | Tuolumne | California | 6109 | 708 | 8 |
748675 | 748675 | 2020-11-20 | Ventura | California | 6111 | 17575 | 174 |
748676 | 748676 | 2020-11-20 | Yolo | California | 6113 | 4050 | 74 |
748677 | 748677 | 2020-11-20 | Yuba | California | 6115 | 1732 | 10 |
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);