ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
86 rows where deaths = 127 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 12
state 1
- California · 86 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499790 | 2499790 | 2022-05-13 | Nevada | California | 6057 | 17503 | 127 |
2496532 | 2496532 | 2022-05-12 | Nevada | California | 6057 | 17475 | 127 |
2493274 | 2493274 | 2022-05-11 | Nevada | California | 6057 | 17475 | 127 |
2490016 | 2490016 | 2022-05-10 | Nevada | California | 6057 | 17475 | 127 |
2486759 | 2486759 | 2022-05-09 | Nevada | California | 6057 | 17416 | 127 |
2483501 | 2483501 | 2022-05-08 | Nevada | California | 6057 | 17416 | 127 |
2480243 | 2480243 | 2022-05-07 | Nevada | California | 6057 | 17416 | 127 |
2476985 | 2476985 | 2022-05-06 | Nevada | California | 6057 | 17416 | 127 |
2473727 | 2473727 | 2022-05-05 | Nevada | California | 6057 | 17369 | 127 |
2470470 | 2470470 | 2022-05-04 | Nevada | California | 6057 | 17369 | 127 |
2467214 | 2467214 | 2022-05-03 | Nevada | California | 6057 | 17369 | 127 |
2463959 | 2463959 | 2022-05-02 | Nevada | California | 6057 | 17333 | 127 |
2460703 | 2460703 | 2022-05-01 | Nevada | California | 6057 | 17333 | 127 |
2457447 | 2457447 | 2022-04-30 | Nevada | California | 6057 | 17333 | 127 |
2454191 | 2454191 | 2022-04-29 | Nevada | California | 6057 | 17333 | 127 |
2450935 | 2450935 | 2022-04-28 | Nevada | California | 6057 | 17301 | 127 |
2447679 | 2447679 | 2022-04-27 | Nevada | California | 6057 | 17301 | 127 |
2444423 | 2444423 | 2022-04-26 | Nevada | California | 6057 | 17301 | 127 |
2441167 | 2441167 | 2022-04-25 | Nevada | California | 6057 | 17273 | 127 |
2437911 | 2437911 | 2022-04-24 | Nevada | California | 6057 | 17273 | 127 |
2434655 | 2434655 | 2022-04-23 | Nevada | California | 6057 | 17273 | 127 |
2431399 | 2431399 | 2022-04-22 | Nevada | California | 6057 | 17273 | 127 |
2428143 | 2428143 | 2022-04-21 | Nevada | California | 6057 | 17250 | 127 |
2424887 | 2424887 | 2022-04-20 | Nevada | California | 6057 | 17250 | 127 |
2421631 | 2421631 | 2022-04-19 | Nevada | California | 6057 | 17250 | 127 |
2236201 | 2236201 | 2022-02-21 | Napa | California | 6055 | 25903 | 127 |
2232950 | 2232950 | 2022-02-20 | Napa | California | 6055 | 25903 | 127 |
2229699 | 2229699 | 2022-02-19 | Napa | California | 6055 | 25903 | 127 |
2226448 | 2226448 | 2022-02-18 | Napa | California | 6055 | 25903 | 127 |
2219946 | 2219946 | 2022-02-16 | Napa | California | 6055 | 25772 | 127 |
2216695 | 2216695 | 2022-02-15 | Napa | California | 6055 | 25716 | 127 |
2213444 | 2213444 | 2022-02-14 | Napa | California | 6055 | 25683 | 127 |
1943583 | 1943583 | 2021-11-23 | Tehama | California | 6103 | 10224 | 127 |
1940333 | 1940333 | 2021-11-22 | Tehama | California | 6103 | 10224 | 127 |
1745330 | 1745330 | 2021-09-23 | El Dorado | California | 6017 | 16158 | 127 |
1742081 | 1742081 | 2021-09-22 | El Dorado | California | 6017 | 16070 | 127 |
1738832 | 1738832 | 2021-09-21 | El Dorado | California | 6017 | 16037 | 127 |
1735583 | 1735583 | 2021-09-20 | El Dorado | California | 6017 | 16004 | 127 |
1732333 | 1732333 | 2021-09-19 | El Dorado | California | 6017 | 15964 | 127 |
1729083 | 1729083 | 2021-09-18 | El Dorado | California | 6017 | 15913 | 127 |
1725833 | 1725833 | 2021-09-17 | El Dorado | California | 6017 | 15864 | 127 |
1722584 | 1722584 | 2021-09-16 | El Dorado | California | 6017 | 15801 | 127 |
1592692 | 1592692 | 2021-08-07 | Sutter | California | 6101 | 10459 | 127 |
1589443 | 1589443 | 2021-08-06 | Sutter | California | 6101 | 10459 | 127 |
1586194 | 1586194 | 2021-08-05 | Sutter | California | 6101 | 10436 | 127 |
1582944 | 1582944 | 2021-08-04 | Sutter | California | 6101 | 10392 | 127 |
1579694 | 1579694 | 2021-08-03 | Sutter | California | 6101 | 10320 | 127 |
1576446 | 1576446 | 2021-08-02 | Sutter | California | 6101 | 10311 | 127 |
1573198 | 1573198 | 2021-08-01 | Sutter | California | 6101 | 10203 | 127 |
1569950 | 1569950 | 2021-07-31 | Sutter | California | 6101 | 10203 | 127 |
1566702 | 1566702 | 2021-07-30 | Sutter | California | 6101 | 10203 | 127 |
988825 | 988825 | 2021-02-02 | Solano | California | 6095 | 28295 | 127 |
917435 | 917435 | 2021-01-11 | Yolo | California | 6113 | 9610 | 127 |
914190 | 914190 | 2021-01-10 | Yolo | California | 6113 | 9524 | 127 |
910945 | 910945 | 2021-01-09 | Yolo | California | 6113 | 9391 | 127 |
907700 | 907700 | 2021-01-08 | Yolo | California | 6113 | 9207 | 127 |
735656 | 735656 | 2020-11-16 | Marin | California | 6041 | 7409 | 127 |
732410 | 732410 | 2020-11-15 | Marin | California | 6041 | 7378 | 127 |
729165 | 729165 | 2020-11-14 | Marin | California | 6041 | 7358 | 127 |
725922 | 725922 | 2020-11-13 | Marin | California | 6041 | 7344 | 127 |
722679 | 722679 | 2020-11-12 | Marin | California | 6041 | 7325 | 127 |
719436 | 719436 | 2020-11-11 | Marin | California | 6041 | 7294 | 127 |
716193 | 716193 | 2020-11-10 | Marin | California | 6041 | 7284 | 127 |
712949 | 712949 | 2020-11-09 | Marin | California | 6041 | 7270 | 127 |
709705 | 709705 | 2020-11-08 | Marin | California | 6041 | 7254 | 127 |
706461 | 706461 | 2020-11-07 | Marin | California | 6041 | 7241 | 127 |
703218 | 703218 | 2020-11-06 | Marin | California | 6041 | 7233 | 127 |
699975 | 699975 | 2020-11-05 | Marin | California | 6041 | 7205 | 127 |
696731 | 696731 | 2020-11-04 | Marin | California | 6041 | 7197 | 127 |
693489 | 693489 | 2020-11-03 | Marin | California | 6041 | 7181 | 127 |
690246 | 690246 | 2020-11-02 | Marin | California | 6041 | 7167 | 127 |
687001 | 687001 | 2020-11-01 | Marin | California | 6041 | 7155 | 127 |
683757 | 683757 | 2020-10-31 | Marin | California | 6041 | 7145 | 127 |
680514 | 680514 | 2020-10-30 | Marin | California | 6041 | 7131 | 127 |
677271 | 677271 | 2020-10-29 | Marin | California | 6041 | 7121 | 127 |
674028 | 674028 | 2020-10-28 | Marin | California | 6041 | 7107 | 127 |
651320 | 651320 | 2020-10-21 | Marin | California | 6041 | 7038 | 127 |
648076 | 648076 | 2020-10-20 | Marin | California | 6041 | 7036 | 127 |
528160 | 528160 | 2020-09-13 | Merced | California | 6047 | 8541 | 127 |
524924 | 524924 | 2020-09-12 | Merced | California | 6047 | 8541 | 127 |
521688 | 521688 | 2020-09-11 | Merced | California | 6047 | 8541 | 127 |
450597 | 450597 | 2020-08-20 | San Mateo | California | 6081 | 7382 | 127 |
447369 | 447369 | 2020-08-19 | San Mateo | California | 6081 | 7321 | 127 |
444142 | 444142 | 2020-08-18 | San Mateo | California | 6081 | 7228 | 127 |
395781 | 395781 | 2020-08-03 | Contra Costa | California | 6013 | 8033 | 127 |
382940 | 382940 | 2020-07-30 | Sacramento | California | 6067 | 9663 | 127 |
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);