ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
40 rows where deaths = 155 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 11
- San Mateo 8
- Merced 7
- Sonoma 5
- Tuolumne 5
- Sutter 4
- San Bernardino 3
- Santa Clara 3
- Santa Cruz 2
- Imperial 1
- Sacramento 1
- San Francisco 1
state 1
- California · 40 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2141899 | 2141899 | 2022-01-23 | Tuolumne | California | 6109 | 10495 | 155 |
2138644 | 2138644 | 2022-01-22 | Tuolumne | California | 6109 | 10495 | 155 |
2135388 | 2135388 | 2022-01-21 | Tuolumne | California | 6109 | 10495 | 155 |
2132136 | 2132136 | 2022-01-20 | Tuolumne | California | 6109 | 10248 | 155 |
2128883 | 2128883 | 2022-01-19 | Tuolumne | California | 6109 | 10124 | 155 |
1768113 | 1768113 | 2021-09-30 | Sutter | California | 6101 | 13413 | 155 |
1764864 | 1764864 | 2021-09-29 | Sutter | California | 6101 | 13354 | 155 |
1761615 | 1761615 | 2021-09-28 | Sutter | California | 6101 | 13334 | 155 |
1758367 | 1758367 | 2021-09-27 | Sutter | California | 6101 | 13311 | 155 |
998559 | 998559 | 2021-02-05 | Santa Cruz | California | 6087 | 13790 | 155 |
995313 | 995313 | 2021-02-04 | Santa Cruz | California | 6087 | 13790 | 155 |
761652 | 761652 | 2020-11-24 | Sonoma | California | 6097 | 11608 | 155 |
758407 | 758407 | 2020-11-23 | Sonoma | California | 6097 | 11608 | 155 |
755160 | 755160 | 2020-11-22 | Sonoma | California | 6097 | 11486 | 155 |
751914 | 751914 | 2020-11-21 | Sonoma | California | 6097 | 11428 | 155 |
748668 | 748668 | 2020-11-20 | Sonoma | California | 6097 | 11363 | 155 |
729182 | 729182 | 2020-11-14 | San Francisco | California | 6075 | 13519 | 155 |
677274 | 677274 | 2020-10-29 | Merced | California | 6047 | 9623 | 155 |
674031 | 674031 | 2020-10-28 | Merced | California | 6047 | 9588 | 155 |
670789 | 670789 | 2020-10-27 | Merced | California | 6047 | 9572 | 155 |
667546 | 667546 | 2020-10-26 | Merced | California | 6047 | 9531 | 155 |
664301 | 664301 | 2020-10-25 | Merced | California | 6047 | 9465 | 155 |
661057 | 661057 | 2020-10-24 | Merced | California | 6047 | 9465 | 155 |
657813 | 657813 | 2020-10-23 | Merced | California | 6047 | 9465 | 155 |
635111 | 635111 | 2020-10-16 | San Mateo | California | 6081 | 10687 | 155 |
631865 | 631865 | 2020-10-15 | San Mateo | California | 6081 | 10655 | 155 |
628621 | 628621 | 2020-10-14 | San Mateo | California | 6081 | 10622 | 155 |
625378 | 625378 | 2020-10-13 | San Mateo | California | 6081 | 10601 | 155 |
622135 | 622135 | 2020-10-12 | San Mateo | California | 6081 | 10510 | 155 |
618892 | 618892 | 2020-10-11 | San Mateo | California | 6081 | 10510 | 155 |
615650 | 615650 | 2020-10-10 | San Mateo | California | 6081 | 10510 | 155 |
612409 | 612409 | 2020-10-09 | San Mateo | California | 6081 | 10452 | 155 |
405458 | 405458 | 2020-08-06 | Sacramento | California | 6067 | 10543 | 155 |
341226 | 341226 | 2020-07-17 | Imperial | California | 6025 | 8397 | 155 |
265310 | 265310 | 2020-06-23 | Santa Clara | California | 6085 | 3727 | 155 |
262182 | 262182 | 2020-06-22 | Santa Clara | California | 6085 | 3606 | 155 |
259055 | 259055 | 2020-06-21 | Santa Clara | California | 6085 | 3547 | 155 |
154438 | 154438 | 2020-05-18 | San Bernardino | California | 6071 | 3593 | 155 |
151426 | 151426 | 2020-05-17 | San Bernardino | California | 6071 | 3511 | 155 |
148417 | 148417 | 2020-05-16 | San Bernardino | California | 6071 | 3463 | 155 |
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);