ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
100 rows where deaths = 247 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
county 12
state 1
- California · 100 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1917551 | 1917551 | 2021-11-15 | Marin | California | 6041 | 18186 | 247 |
1914301 | 1914301 | 2021-11-14 | Marin | California | 6041 | 18158 | 247 |
1911051 | 1911051 | 2021-11-13 | Marin | California | 6041 | 18158 | 247 |
1907802 | 1907802 | 2021-11-12 | Marin | California | 6041 | 18113 | 247 |
1904553 | 1904553 | 2021-11-11 | Marin | California | 6041 | 18113 | 247 |
1901303 | 1901303 | 2021-11-10 | Marin | California | 6041 | 18086 | 247 |
1898053 | 1898053 | 2021-11-09 | Marin | California | 6041 | 18073 | 247 |
1894803 | 1894803 | 2021-11-08 | Marin | California | 6041 | 18050 | 247 |
1891553 | 1891553 | 2021-11-07 | Marin | California | 6041 | 17976 | 247 |
1888303 | 1888303 | 2021-11-06 | Marin | California | 6041 | 17976 | 247 |
1885053 | 1885053 | 2021-11-05 | Marin | California | 6041 | 17976 | 247 |
1881804 | 1881804 | 2021-11-04 | Marin | California | 6041 | 17947 | 247 |
1878555 | 1878555 | 2021-11-03 | Marin | California | 6041 | 17929 | 247 |
1875306 | 1875306 | 2021-11-02 | Marin | California | 6041 | 17907 | 247 |
1872057 | 1872057 | 2021-11-01 | Marin | California | 6041 | 17890 | 247 |
1868808 | 1868808 | 2021-10-31 | Marin | California | 6041 | 17827 | 247 |
1865559 | 1865559 | 2021-10-30 | Marin | California | 6041 | 17827 | 247 |
1862310 | 1862310 | 2021-10-29 | Marin | California | 6041 | 17827 | 247 |
1859061 | 1859061 | 2021-10-28 | Marin | California | 6041 | 17809 | 247 |
1823355 | 1823355 | 2021-10-17 | Yolo | California | 6113 | 20147 | 247 |
1820106 | 1820106 | 2021-10-16 | Yolo | California | 6113 | 20147 | 247 |
1816857 | 1816857 | 2021-10-15 | Yolo | California | 6113 | 20147 | 247 |
1813609 | 1813609 | 2021-10-14 | Yolo | California | 6113 | 20092 | 247 |
1810360 | 1810360 | 2021-10-13 | Yolo | California | 6113 | 20028 | 247 |
1807111 | 1807111 | 2021-10-12 | Yolo | California | 6113 | 20018 | 247 |
1803860 | 1803860 | 2021-10-11 | Yolo | California | 6113 | 19993 | 247 |
1800611 | 1800611 | 2021-10-10 | Yolo | California | 6113 | 19891 | 247 |
1797362 | 1797362 | 2021-10-09 | Yolo | California | 6113 | 19891 | 247 |
1794113 | 1794113 | 2021-10-08 | Yolo | California | 6113 | 19891 | 247 |
1790812 | 1790812 | 2021-10-07 | Butte | California | 6007 | 22831 | 247 |
1790865 | 1790865 | 2021-10-07 | Yolo | California | 6113 | 19856 | 247 |
1625170 | 1625170 | 2021-08-17 | Shasta | California | 6089 | 15882 | 247 |
1491984 | 1491984 | 2021-07-07 | Kings | California | 6031 | 23134 | 247 |
1488737 | 1488737 | 2021-07-06 | Kings | California | 6031 | 23134 | 247 |
1485490 | 1485490 | 2021-07-05 | Kings | California | 6031 | 23121 | 247 |
1482244 | 1482244 | 2021-07-04 | Kings | California | 6031 | 23119 | 247 |
1478997 | 1478997 | 2021-07-03 | Kings | California | 6031 | 23117 | 247 |
1475751 | 1475751 | 2021-07-02 | Kings | California | 6031 | 23115 | 247 |
1472505 | 1472505 | 2021-07-01 | Kings | California | 6031 | 23107 | 247 |
1469260 | 1469260 | 2021-06-30 | Kings | California | 6031 | 23096 | 247 |
1466015 | 1466015 | 2021-06-29 | Kings | California | 6031 | 23134 | 247 |
1462770 | 1462770 | 2021-06-28 | Kings | California | 6031 | 23236 | 247 |
1459525 | 1459525 | 2021-06-27 | Kings | California | 6031 | 23234 | 247 |
1456280 | 1456280 | 2021-06-26 | Kings | California | 6031 | 23230 | 247 |
1453035 | 1453035 | 2021-06-25 | Kings | California | 6031 | 23220 | 247 |
1449789 | 1449789 | 2021-06-24 | Kings | California | 6031 | 23214 | 247 |
1446544 | 1446544 | 2021-06-23 | Kings | California | 6031 | 23209 | 247 |
1443299 | 1443299 | 2021-06-22 | Kings | California | 6031 | 23202 | 247 |
1440054 | 1440054 | 2021-06-21 | Kings | California | 6031 | 23195 | 247 |
1436807 | 1436807 | 2021-06-20 | Kings | California | 6031 | 23192 | 247 |
1433560 | 1433560 | 2021-06-19 | Kings | California | 6031 | 23192 | 247 |
1430314 | 1430314 | 2021-06-18 | Kings | California | 6031 | 23189 | 247 |
1427069 | 1427069 | 2021-06-17 | Kings | California | 6031 | 23185 | 247 |
1423824 | 1423824 | 2021-06-16 | Kings | California | 6031 | 23178 | 247 |
1420576 | 1420576 | 2021-06-15 | Kings | California | 6031 | 23175 | 247 |
1417331 | 1417331 | 2021-06-14 | Kings | California | 6031 | 23170 | 247 |
1414085 | 1414085 | 2021-06-13 | Kings | California | 6031 | 23168 | 247 |
1410840 | 1410840 | 2021-06-12 | Kings | California | 6031 | 23166 | 247 |
1407595 | 1407595 | 2021-06-11 | Kings | California | 6031 | 23168 | 247 |
1404349 | 1404349 | 2021-06-10 | Kings | California | 6031 | 23170 | 247 |
1401104 | 1401104 | 2021-06-09 | Kings | California | 6031 | 23164 | 247 |
1397859 | 1397859 | 2021-06-08 | Kings | California | 6031 | 23137 | 247 |
1394612 | 1394612 | 2021-06-07 | Kings | California | 6031 | 23124 | 247 |
1391367 | 1391367 | 2021-06-06 | Kings | California | 6031 | 23122 | 247 |
1388122 | 1388122 | 2021-06-05 | Kings | California | 6031 | 23119 | 247 |
1384877 | 1384877 | 2021-06-04 | Kings | California | 6031 | 23102 | 247 |
1381631 | 1381631 | 2021-06-03 | Kings | California | 6031 | 23081 | 247 |
1378386 | 1378386 | 2021-06-02 | Kings | California | 6031 | 23076 | 247 |
1375140 | 1375140 | 2021-06-01 | Kings | California | 6031 | 23076 | 247 |
1371895 | 1371895 | 2021-05-31 | Kings | California | 6031 | 23077 | 247 |
1368650 | 1368650 | 2021-05-30 | Kings | California | 6031 | 23072 | 247 |
1365404 | 1365404 | 2021-05-29 | Kings | California | 6031 | 23067 | 247 |
1362158 | 1362158 | 2021-05-28 | Kings | California | 6031 | 23059 | 247 |
1358911 | 1358911 | 2021-05-27 | Kings | California | 6031 | 23050 | 247 |
1355665 | 1355665 | 2021-05-26 | Kings | California | 6031 | 23047 | 247 |
1352419 | 1352419 | 2021-05-25 | Kings | California | 6031 | 23042 | 247 |
1349173 | 1349173 | 2021-05-24 | Kings | California | 6031 | 23038 | 247 |
1345926 | 1345926 | 2021-05-23 | Kings | California | 6031 | 23038 | 247 |
1342678 | 1342678 | 2021-05-22 | Kings | California | 6031 | 23035 | 247 |
1339430 | 1339430 | 2021-05-21 | Kings | California | 6031 | 23026 | 247 |
1336183 | 1336183 | 2021-05-20 | Kings | California | 6031 | 23020 | 247 |
1332936 | 1332936 | 2021-05-19 | Kings | California | 6031 | 23019 | 247 |
1329689 | 1329689 | 2021-05-18 | Kings | California | 6031 | 23016 | 247 |
1261542 | 1261542 | 2021-04-27 | Solano | California | 6095 | 32350 | 247 |
1258295 | 1258295 | 2021-04-26 | Solano | California | 6095 | 32318 | 247 |
1255048 | 1255048 | 2021-04-25 | Solano | California | 6095 | 32131 | 247 |
1251801 | 1251801 | 2021-04-24 | Solano | California | 6095 | 32131 | 247 |
1248554 | 1248554 | 2021-04-23 | Solano | California | 6095 | 32131 | 247 |
1099172 | 1099172 | 2021-03-08 | San Luis Obispo | California | 6079 | 19860 | 247 |
959617 | 959617 | 2021-01-24 | Sonoma | California | 6097 | 24935 | 247 |
956371 | 956371 | 2021-01-23 | Sonoma | California | 6097 | 24761 | 247 |
920650 | 920650 | 2021-01-12 | Monterey | California | 6053 | 33761 | 247 |
696717 | 696717 | 2020-11-04 | Contra Costa | California | 6013 | 19416 | 247 |
693475 | 693475 | 2020-11-03 | Contra Costa | California | 6013 | 19339 | 247 |
690232 | 690232 | 2020-11-02 | Contra Costa | California | 6013 | 19246 | 247 |
528190 | 528190 | 2020-09-13 | Tulare | California | 6107 | 15114 | 247 |
524954 | 524954 | 2020-09-12 | Tulare | California | 6107 | 15114 | 247 |
521718 | 521718 | 2020-09-11 | Tulare | California | 6107 | 15114 | 247 |
479625 | 479625 | 2020-08-29 | Alameda | California | 6001 | 17868 | 247 |
476392 | 476392 | 2020-08-28 | Alameda | California | 6001 | 17868 | 247 |
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);