ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
113 rows where deaths = 41 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1898046 | 1898046 | 2021-11-09 | Inyo | California | 6027 | 2436 | 41 |
1894796 | 1894796 | 2021-11-08 | Inyo | California | 6027 | 2432 | 41 |
1891546 | 1891546 | 2021-11-07 | Inyo | California | 6027 | 2391 | 41 |
1888296 | 1888296 | 2021-11-06 | Inyo | California | 6027 | 2391 | 41 |
1885046 | 1885046 | 2021-11-05 | Inyo | California | 6027 | 2391 | 41 |
1881797 | 1881797 | 2021-11-04 | Inyo | California | 6027 | 2382 | 41 |
1878548 | 1878548 | 2021-11-03 | Inyo | California | 6027 | 2360 | 41 |
1875299 | 1875299 | 2021-11-02 | Inyo | California | 6027 | 2343 | 41 |
1872050 | 1872050 | 2021-11-01 | Inyo | California | 6027 | 2345 | 41 |
1868801 | 1868801 | 2021-10-31 | Inyo | California | 6027 | 2285 | 41 |
1865552 | 1865552 | 2021-10-30 | Inyo | California | 6027 | 2285 | 41 |
1862303 | 1862303 | 2021-10-29 | Inyo | California | 6027 | 2285 | 41 |
1859054 | 1859054 | 2021-10-28 | Inyo | California | 6027 | 2272 | 41 |
1855805 | 1855805 | 2021-10-27 | Inyo | California | 6027 | 2234 | 41 |
1852556 | 1852556 | 2021-10-26 | Inyo | California | 6027 | 2217 | 41 |
1849307 | 1849307 | 2021-10-25 | Inyo | California | 6027 | 2142 | 41 |
1846057 | 1846057 | 2021-10-24 | Inyo | California | 6027 | 2142 | 41 |
1842807 | 1842807 | 2021-10-23 | Inyo | California | 6027 | 2142 | 41 |
1839557 | 1839557 | 2021-10-22 | Inyo | California | 6027 | 2142 | 41 |
1829804 | 1829804 | 2021-10-19 | Del Norte | California | 6015 | 3672 | 41 |
1829807 | 1829807 | 2021-10-19 | Glenn | California | 6021 | 4342 | 41 |
1826555 | 1826555 | 2021-10-18 | Del Norte | California | 6015 | 3669 | 41 |
1826558 | 1826558 | 2021-10-18 | Glenn | California | 6021 | 4336 | 41 |
1823306 | 1823306 | 2021-10-17 | Del Norte | California | 6015 | 3657 | 41 |
1823309 | 1823309 | 2021-10-17 | Glenn | California | 6021 | 4303 | 41 |
1820057 | 1820057 | 2021-10-16 | Del Norte | California | 6015 | 3657 | 41 |
1820060 | 1820060 | 2021-10-16 | Glenn | California | 6021 | 4303 | 41 |
1816808 | 1816808 | 2021-10-15 | Del Norte | California | 6015 | 3657 | 41 |
1816811 | 1816811 | 2021-10-15 | Glenn | California | 6021 | 4303 | 41 |
1690141 | 1690141 | 2021-09-06 | Siskiyou | California | 6093 | 3506 | 41 |
1686891 | 1686891 | 2021-09-05 | Siskiyou | California | 6093 | 3506 | 41 |
1683641 | 1683641 | 2021-09-04 | Siskiyou | California | 6093 | 3506 | 41 |
1680390 | 1680390 | 2021-09-03 | Siskiyou | California | 6093 | 3506 | 41 |
1677142 | 1677142 | 2021-09-02 | Siskiyou | California | 6093 | 3443 | 41 |
1673895 | 1673895 | 2021-09-01 | Siskiyou | California | 6093 | 3402 | 41 |
1670647 | 1670647 | 2021-08-31 | Siskiyou | California | 6093 | 3346 | 41 |
1313452 | 1313452 | 2021-05-13 | Humboldt | California | 6023 | 4046 | 41 |
1310205 | 1310205 | 2021-05-12 | Humboldt | California | 6023 | 4002 | 41 |
1112119 | 1112119 | 2021-03-12 | Amador | California | 6005 | 3497 | 41 |
1108873 | 1108873 | 2021-03-11 | Amador | California | 6005 | 3495 | 41 |
1105627 | 1105627 | 2021-03-10 | Amador | California | 6005 | 3493 | 41 |
1102381 | 1102381 | 2021-03-09 | Amador | California | 6005 | 3489 | 41 |
1099135 | 1099135 | 2021-03-08 | Amador | California | 6005 | 3488 | 41 |
1099149 | 1099149 | 2021-03-08 | Lake | California | 6033 | 3192 | 41 |
1095887 | 1095887 | 2021-03-07 | Amador | California | 6005 | 3486 | 41 |
1095901 | 1095901 | 2021-03-07 | Lake | California | 6033 | 3189 | 41 |
1092641 | 1092641 | 2021-03-06 | Amador | California | 6005 | 3483 | 41 |
1092655 | 1092655 | 2021-03-06 | Lake | California | 6033 | 3185 | 41 |
1089395 | 1089395 | 2021-03-05 | Amador | California | 6005 | 3479 | 41 |
1089409 | 1089409 | 2021-03-05 | Lake | California | 6033 | 3181 | 41 |
1086150 | 1086150 | 2021-03-04 | Amador | California | 6005 | 3477 | 41 |
1086164 | 1086164 | 2021-03-04 | Lake | California | 6033 | 3175 | 41 |
1082904 | 1082904 | 2021-03-03 | Amador | California | 6005 | 3473 | 41 |
1082918 | 1082918 | 2021-03-03 | Lake | California | 6033 | 3169 | 41 |
1079658 | 1079658 | 2021-03-02 | Amador | California | 6005 | 3468 | 41 |
1079672 | 1079672 | 2021-03-02 | Lake | California | 6033 | 3164 | 41 |
1076413 | 1076413 | 2021-03-01 | Amador | California | 6005 | 3465 | 41 |
1076427 | 1076427 | 2021-03-01 | Lake | California | 6033 | 3164 | 41 |
1073167 | 1073167 | 2021-02-28 | Amador | California | 6005 | 3462 | 41 |
1073181 | 1073181 | 2021-02-28 | Lake | California | 6033 | 3156 | 41 |
1069921 | 1069921 | 2021-02-27 | Amador | California | 6005 | 3456 | 41 |
1069935 | 1069935 | 2021-02-27 | Lake | California | 6033 | 3153 | 41 |
1040730 | 1040730 | 2021-02-18 | Mendocino | California | 6045 | 3750 | 41 |
1037485 | 1037485 | 2021-02-17 | Mendocino | California | 6045 | 3743 | 41 |
966113 | 966113 | 2021-01-26 | Tuolumne | California | 6109 | 3512 | 41 |
927149 | 927149 | 2021-01-14 | San Benito | California | 6069 | 4698 | 41 |
923903 | 923903 | 2021-01-13 | San Benito | California | 6069 | 4596 | 41 |
923920 | 923920 | 2021-01-13 | Tehama | California | 6103 | 3567 | 41 |
920675 | 920675 | 2021-01-12 | Tehama | California | 6103 | 3524 | 41 |
917430 | 917430 | 2021-01-11 | Tehama | California | 6103 | 3504 | 41 |
914185 | 914185 | 2021-01-10 | Tehama | California | 6103 | 3451 | 41 |
554064 | 554064 | 2020-09-21 | Placer | California | 6061 | 3488 | 41 |
550825 | 550825 | 2020-09-20 | Placer | California | 6061 | 3466 | 41 |
547586 | 547586 | 2020-09-19 | Placer | California | 6061 | 3428 | 41 |
544348 | 544348 | 2020-09-18 | Placer | California | 6061 | 3407 | 41 |
541112 | 541112 | 2020-09-17 | Placer | California | 6061 | 3385 | 41 |
440923 | 440923 | 2020-08-17 | Solano | California | 6095 | 4772 | 41 |
437697 | 437697 | 2020-08-16 | Solano | California | 6095 | 4601 | 41 |
434471 | 434471 | 2020-08-15 | Solano | California | 6095 | 4601 | 41 |
431225 | 431225 | 2020-08-14 | Monterey | California | 6053 | 5925 | 41 |
431246 | 431246 | 2020-08-14 | Solano | California | 6095 | 4601 | 41 |
428018 | 428018 | 2020-08-13 | Solano | California | 6095 | 4539 | 41 |
424794 | 424794 | 2020-08-12 | Solano | California | 6095 | 4419 | 41 |
421573 | 421573 | 2020-08-11 | Solano | California | 6095 | 4343 | 41 |
418352 | 418352 | 2020-08-10 | Solano | California | 6095 | 4279 | 41 |
386181 | 386181 | 2020-07-31 | Yolo | California | 6113 | 1511 | 41 |
382963 | 382963 | 2020-07-30 | Yolo | California | 6113 | 1494 | 41 |
379746 | 379746 | 2020-07-29 | Yolo | California | 6113 | 1477 | 41 |
347628 | 347628 | 2020-07-19 | Kings | California | 6031 | 3280 | 41 |
344428 | 344428 | 2020-07-18 | Kings | California | 6031 | 3247 | 41 |
341229 | 341229 | 2020-07-17 | Kings | California | 6031 | 3209 | 41 |
338033 | 338033 | 2020-07-16 | Kings | California | 6031 | 3172 | 41 |
334838 | 334838 | 2020-07-15 | Kings | California | 6031 | 3108 | 41 |
284163 | 284163 | 2020-06-29 | Stanislaus | California | 6099 | 2376 | 41 |
281017 | 281017 | 2020-06-28 | Stanislaus | California | 6099 | 2244 | 41 |
246595 | 246595 | 2020-06-17 | Ventura | California | 6111 | 1706 | 41 |
243482 | 243482 | 2020-06-16 | Ventura | California | 6111 | 1656 | 41 |
240371 | 240371 | 2020-06-15 | Ventura | California | 6111 | 1633 | 41 |
190927 | 190927 | 2020-05-30 | San Francisco | California | 6075 | 2535 | 41 |
187862 | 187862 | 2020-05-29 | San Francisco | California | 6075 | 2476 | 41 |
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);