ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
89 rows where deaths = 62 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2245937 | 2245937 | 2022-02-24 | Glenn | California | 6021 | 6440 | 62 |
2193914 | 2193914 | 2022-02-08 | Lassen | California | 6035 | 9919 | 62 |
2190661 | 2190661 | 2022-02-07 | Lassen | California | 6035 | 9919 | 62 |
2187408 | 2187408 | 2022-02-06 | Lassen | California | 6035 | 9919 | 62 |
2184155 | 2184155 | 2022-02-05 | Lassen | California | 6035 | 9919 | 62 |
2180903 | 2180903 | 2022-02-04 | Lassen | California | 6035 | 9893 | 62 |
2177652 | 2177652 | 2022-02-03 | Lassen | California | 6035 | 9849 | 62 |
2174399 | 2174399 | 2022-02-02 | Lassen | California | 6035 | 9823 | 62 |
2171146 | 2171146 | 2022-02-01 | Lassen | California | 6035 | 9801 | 62 |
1846090 | 1846090 | 2021-10-24 | Siskiyou | California | 6093 | 4652 | 62 |
1842840 | 1842840 | 2021-10-23 | Siskiyou | California | 6093 | 4652 | 62 |
1839590 | 1839590 | 2021-10-22 | Siskiyou | California | 6093 | 4652 | 62 |
1836341 | 1836341 | 2021-10-21 | Siskiyou | California | 6093 | 4652 | 62 |
1833092 | 1833092 | 2021-10-20 | Siskiyou | California | 6093 | 4637 | 62 |
1829843 | 1829843 | 2021-10-19 | Siskiyou | California | 6093 | 4614 | 62 |
1826594 | 1826594 | 2021-10-18 | Siskiyou | California | 6093 | 4614 | 62 |
1807057 | 1807057 | 2021-10-12 | Amador | California | 6005 | 5344 | 62 |
1803806 | 1803806 | 2021-10-11 | Amador | California | 6005 | 5336 | 62 |
1800557 | 1800557 | 2021-10-10 | Amador | California | 6005 | 5295 | 62 |
1797308 | 1797308 | 2021-10-09 | Amador | California | 6005 | 5295 | 62 |
1794059 | 1794059 | 2021-10-08 | Amador | California | 6005 | 5295 | 62 |
1790811 | 1790811 | 2021-10-07 | Amador | California | 6005 | 5263 | 62 |
1755126 | 1755126 | 2021-09-26 | Yuba | California | 6115 | 9755 | 62 |
1751878 | 1751878 | 2021-09-25 | Yuba | California | 6115 | 9755 | 62 |
1748629 | 1748629 | 2021-09-24 | Yuba | California | 6115 | 9755 | 62 |
1745379 | 1745379 | 2021-09-23 | Yuba | California | 6115 | 9720 | 62 |
1706396 | 1706396 | 2021-09-11 | Yuba | California | 6115 | 9222 | 62 |
1647878 | 1647878 | 2021-08-24 | Humboldt | California | 6023 | 6696 | 62 |
1644630 | 1644630 | 2021-08-23 | Humboldt | California | 6023 | 6681 | 62 |
1485491 | 1485491 | 2021-07-05 | Lake | California | 6033 | 3623 | 62 |
1482245 | 1482245 | 2021-07-04 | Lake | California | 6033 | 3623 | 62 |
1478998 | 1478998 | 2021-07-03 | Lake | California | 6033 | 3623 | 62 |
1475752 | 1475752 | 2021-07-02 | Lake | California | 6033 | 3623 | 62 |
1313492 | 1313492 | 2021-05-13 | Tehama | California | 6103 | 4989 | 62 |
1310245 | 1310245 | 2021-05-12 | Tehama | California | 6103 | 4985 | 62 |
1306999 | 1306999 | 2021-05-11 | Tehama | California | 6103 | 4980 | 62 |
1303753 | 1303753 | 2021-05-10 | Tehama | California | 6103 | 4979 | 62 |
1300506 | 1300506 | 2021-05-09 | Tehama | California | 6103 | 4977 | 62 |
1216066 | 1216066 | 2021-04-13 | San Benito | California | 6069 | 5942 | 62 |
1212819 | 1212819 | 2021-04-12 | San Benito | California | 6069 | 5941 | 62 |
1209571 | 1209571 | 2021-04-11 | San Benito | California | 6069 | 5932 | 62 |
1206322 | 1206322 | 2021-04-10 | San Benito | California | 6069 | 5925 | 62 |
1203074 | 1203074 | 2021-04-09 | San Benito | California | 6069 | 5914 | 62 |
1199826 | 1199826 | 2021-04-08 | San Benito | California | 6069 | 5912 | 62 |
1196577 | 1196577 | 2021-04-07 | San Benito | California | 6069 | 5907 | 62 |
1193329 | 1193329 | 2021-04-06 | San Benito | California | 6069 | 5904 | 62 |
1190079 | 1190079 | 2021-04-05 | San Benito | California | 6069 | 5901 | 62 |
1190099 | 1190099 | 2021-04-05 | Tuolumne | California | 6109 | 4044 | 62 |
1186852 | 1186852 | 2021-04-04 | Tuolumne | California | 6109 | 4043 | 62 |
1183605 | 1183605 | 2021-04-03 | Tuolumne | California | 6109 | 4043 | 62 |
1180358 | 1180358 | 2021-04-02 | Tuolumne | California | 6109 | 4043 | 62 |
1177111 | 1177111 | 2021-04-01 | Tuolumne | California | 6109 | 4040 | 62 |
1173864 | 1173864 | 2021-03-31 | Tuolumne | California | 6109 | 4036 | 62 |
1170617 | 1170617 | 2021-03-30 | Tuolumne | California | 6109 | 4034 | 62 |
1167369 | 1167369 | 2021-03-29 | Tuolumne | California | 6109 | 4031 | 62 |
1164121 | 1164121 | 2021-03-28 | Tuolumne | California | 6109 | 4024 | 62 |
1160873 | 1160873 | 2021-03-27 | Tuolumne | California | 6109 | 4024 | 62 |
1157625 | 1157625 | 2021-03-26 | Tuolumne | California | 6109 | 4024 | 62 |
1154378 | 1154378 | 2021-03-25 | Tuolumne | California | 6109 | 4020 | 62 |
1151131 | 1151131 | 2021-03-24 | Tuolumne | California | 6109 | 4020 | 62 |
1147884 | 1147884 | 2021-03-23 | Tuolumne | California | 6109 | 4017 | 62 |
1144637 | 1144637 | 2021-03-22 | Tuolumne | California | 6109 | 4014 | 62 |
1034245 | 1034245 | 2021-02-16 | Napa | California | 6055 | 8838 | 62 |
1030999 | 1030999 | 2021-02-15 | Napa | California | 6055 | 8827 | 62 |
1027752 | 1027752 | 2021-02-14 | Napa | California | 6055 | 8810 | 62 |
1024507 | 1024507 | 2021-02-13 | Napa | California | 6055 | 8786 | 62 |
1021262 | 1021262 | 2021-02-12 | Napa | California | 6055 | 8778 | 62 |
966067 | 966067 | 2021-01-26 | El Dorado | California | 6017 | 8060 | 62 |
897958 | 897958 | 2021-01-05 | Sutter | California | 6101 | 6797 | 62 |
807038 | 807038 | 2020-12-08 | Butte | California | 6007 | 4706 | 62 |
803793 | 803793 | 2020-12-07 | Butte | California | 6007 | 4638 | 62 |
722689 | 722689 | 2020-11-12 | Placer | California | 6061 | 5056 | 62 |
700011 | 700011 | 2020-11-05 | Yolo | California | 6113 | 3395 | 62 |
696767 | 696767 | 2020-11-04 | Yolo | California | 6113 | 3363 | 62 |
554053 | 554053 | 2020-09-21 | Madera | California | 6039 | 4391 | 62 |
518454 | 518454 | 2020-09-10 | Monterey | California | 6053 | 8738 | 62 |
515219 | 515219 | 2020-09-09 | Monterey | California | 6053 | 8698 | 62 |
511986 | 511986 | 2020-09-08 | Monterey | California | 6053 | 8661 | 62 |
424762 | 424762 | 2020-08-12 | Kings | California | 6031 | 5127 | 62 |
421541 | 421541 | 2020-08-11 | Kings | California | 6031 | 5067 | 62 |
405448 | 405448 | 2020-08-06 | Merced | California | 6047 | 4855 | 62 |
402244 | 402244 | 2020-08-05 | San Francisco | California | 6075 | 7084 | 62 |
354070 | 354070 | 2020-07-21 | Ventura | California | 6111 | 5955 | 62 |
265275 | 265275 | 2020-06-23 | Contra Costa | California | 6013 | 2454 | 62 |
262147 | 262147 | 2020-06-22 | Contra Costa | California | 6013 | 2369 | 62 |
259020 | 259020 | 2020-06-21 | Contra Costa | California | 6013 | 2294 | 62 |
249662 | 249662 | 2020-06-18 | Fresno | California | 6019 | 3058 | 62 |
224823 | 224823 | 2020-06-10 | Sacramento | California | 6067 | 1641 | 62 |
127462 | 127462 | 2020-05-09 | San Mateo | California | 6081 | 1425 | 62 |
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);