ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
804 rows where fips = 6001 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 |
---|---|---|---|---|---|---|---|
2499762 | 2499762 | 2022-05-13 | Alameda | California | 6001 | 284054 | 1868 |
2496504 | 2496504 | 2022-05-12 | Alameda | California | 6001 | 282539 | 1868 |
2493246 | 2493246 | 2022-05-11 | Alameda | California | 6001 | 282539 | 1865 |
2489988 | 2489988 | 2022-05-10 | Alameda | California | 6001 | 282539 | 1896 |
2486731 | 2486731 | 2022-05-09 | Alameda | California | 6001 | 279755 | 1894 |
2483473 | 2483473 | 2022-05-08 | Alameda | California | 6001 | 279755 | 1894 |
2480215 | 2480215 | 2022-05-07 | Alameda | California | 6001 | 279755 | 1892 |
2476957 | 2476957 | 2022-05-06 | Alameda | California | 6001 | 279755 | 1892 |
2473699 | 2473699 | 2022-05-05 | Alameda | California | 6001 | 278392 | 1892 |
2470442 | 2470442 | 2022-05-04 | Alameda | California | 6001 | 278392 | 1890 |
2467186 | 2467186 | 2022-05-03 | Alameda | California | 6001 | 278392 | 1888 |
2463931 | 2463931 | 2022-05-02 | Alameda | California | 6001 | 276683 | 1889 |
2460675 | 2460675 | 2022-05-01 | Alameda | California | 6001 | 276683 | 1889 |
2457419 | 2457419 | 2022-04-30 | Alameda | California | 6001 | 276683 | 1886 |
2454163 | 2454163 | 2022-04-29 | Alameda | California | 6001 | 276683 | 1886 |
2450907 | 2450907 | 2022-04-28 | Alameda | California | 6001 | 275311 | 1886 |
2447651 | 2447651 | 2022-04-27 | Alameda | California | 6001 | 275311 | 1879 |
2444395 | 2444395 | 2022-04-26 | Alameda | California | 6001 | 275311 | 1879 |
2441139 | 2441139 | 2022-04-25 | Alameda | California | 6001 | 274059 | 1875 |
2437883 | 2437883 | 2022-04-24 | Alameda | California | 6001 | 274059 | 1871 |
2434627 | 2434627 | 2022-04-23 | Alameda | California | 6001 | 274059 | 1871 |
2431371 | 2431371 | 2022-04-22 | Alameda | California | 6001 | 274059 | 1871 |
2428115 | 2428115 | 2022-04-21 | Alameda | California | 6001 | 273111 | 1869 |
2424859 | 2424859 | 2022-04-20 | Alameda | California | 6001 | 273111 | 1865 |
2421603 | 2421603 | 2022-04-19 | Alameda | California | 6001 | 273111 | 1862 |
2418347 | 2418347 | 2022-04-18 | Alameda | California | 6001 | 272274 | 1862 |
2415091 | 2415091 | 2022-04-17 | Alameda | California | 6001 | 272274 | 1862 |
2411835 | 2411835 | 2022-04-16 | Alameda | California | 6001 | 272274 | 1858 |
2408579 | 2408579 | 2022-04-15 | Alameda | California | 6001 | 272274 | 1858 |
2405323 | 2405323 | 2022-04-14 | Alameda | California | 6001 | 271817 | 1859 |
2402068 | 2402068 | 2022-04-13 | Alameda | California | 6001 | 270550 | 1860 |
2398813 | 2398813 | 2022-04-12 | Alameda | California | 6001 | 270550 | 1860 |
2395558 | 2395558 | 2022-04-11 | Alameda | California | 6001 | 270550 | 1858 |
2392302 | 2392302 | 2022-04-10 | Alameda | California | 6001 | 270550 | 1858 |
2389046 | 2389046 | 2022-04-09 | Alameda | California | 6001 | 270550 | 1849 |
2385791 | 2385791 | 2022-04-08 | Alameda | California | 6001 | 270550 | 1849 |
2382536 | 2382536 | 2022-04-07 | Alameda | California | 6001 | 270044 | 1845 |
2379281 | 2379281 | 2022-04-06 | Alameda | California | 6001 | 270044 | 1844 |
2376027 | 2376027 | 2022-04-05 | Alameda | California | 6001 | 270044 | 1842 |
2372775 | 2372775 | 2022-04-04 | Alameda | California | 6001 | 269551 | 1830 |
2369522 | 2369522 | 2022-04-03 | Alameda | California | 6001 | 269551 | 1830 |
2366269 | 2366269 | 2022-04-02 | Alameda | California | 6001 | 269551 | 1830 |
2363016 | 2363016 | 2022-04-01 | Alameda | California | 6001 | 269551 | 1830 |
2359762 | 2359762 | 2022-03-31 | Alameda | California | 6001 | 269368 | 1830 |
2356508 | 2356508 | 2022-03-30 | Alameda | California | 6001 | 269044 | 1826 |
2353255 | 2353255 | 2022-03-29 | Alameda | California | 6001 | 268975 | 1825 |
2350003 | 2350003 | 2022-03-28 | Alameda | California | 6001 | 268915 | 1824 |
2346750 | 2346750 | 2022-03-27 | Alameda | California | 6001 | 268474 | 1824 |
2343497 | 2343497 | 2022-03-26 | Alameda | California | 6001 | 268474 | 1823 |
2340244 | 2340244 | 2022-03-25 | Alameda | California | 6001 | 268474 | 1823 |
2336991 | 2336991 | 2022-03-24 | Alameda | California | 6001 | 268342 | 1818 |
2333737 | 2333737 | 2022-03-23 | Alameda | California | 6001 | 268206 | 1818 |
2330483 | 2330483 | 2022-03-22 | Alameda | California | 6001 | 268093 | 1815 |
2327231 | 2327231 | 2022-03-21 | Alameda | California | 6001 | 268032 | 1815 |
2323978 | 2323978 | 2022-03-20 | Alameda | California | 6001 | 267675 | 1815 |
2320724 | 2320724 | 2022-03-19 | Alameda | California | 6001 | 267675 | 1810 |
2317470 | 2317470 | 2022-03-18 | Alameda | California | 6001 | 267675 | 1810 |
2314217 | 2314217 | 2022-03-17 | Alameda | California | 6001 | 267531 | 1810 |
2310964 | 2310964 | 2022-03-16 | Alameda | California | 6001 | 267385 | 1807 |
2307711 | 2307711 | 2022-03-15 | Alameda | California | 6001 | 267320 | 1806 |
2304460 | 2304460 | 2022-03-14 | Alameda | California | 6001 | 267238 | 1804 |
2301208 | 2301208 | 2022-03-13 | Alameda | California | 6001 | 266770 | 1800 |
2297956 | 2297956 | 2022-03-12 | Alameda | California | 6001 | 266770 | 1800 |
2294704 | 2294704 | 2022-03-11 | Alameda | California | 6001 | 266770 | 1792 |
2291452 | 2291452 | 2022-03-10 | Alameda | California | 6001 | 266584 | 1792 |
2288200 | 2288200 | 2022-03-09 | Alameda | California | 6001 | 266367 | 1792 |
2284949 | 2284949 | 2022-03-08 | Alameda | California | 6001 | 266201 | 1781 |
2281697 | 2281697 | 2022-03-07 | Alameda | California | 6001 | 266083 | 1777 |
2278444 | 2278444 | 2022-03-06 | Alameda | California | 6001 | 265611 | 1776 |
2275191 | 2275191 | 2022-03-05 | Alameda | California | 6001 | 265611 | 1774 |
2271938 | 2271938 | 2022-03-04 | Alameda | California | 6001 | 265611 | 1774 |
2268686 | 2268686 | 2022-03-03 | Alameda | California | 6001 | 265509 | 1768 |
2265433 | 2265433 | 2022-03-02 | Alameda | California | 6001 | 265363 | 1768 |
2262182 | 2262182 | 2022-03-01 | Alameda | California | 6001 | 265247 | 1758 |
2258931 | 2258931 | 2022-02-28 | Alameda | California | 6001 | 265157 | 1752 |
2255680 | 2255680 | 2022-02-27 | Alameda | California | 6001 | 264400 | 1734 |
2252429 | 2252429 | 2022-02-26 | Alameda | California | 6001 | 264400 | 1734 |
2249178 | 2249178 | 2022-02-25 | Alameda | California | 6001 | 264400 | 1734 |
2245927 | 2245927 | 2022-02-24 | Alameda | California | 6001 | 261219 | 1722 |
2242676 | 2242676 | 2022-02-23 | Alameda | California | 6001 | 260696 | 1722 |
2239425 | 2239425 | 2022-02-22 | Alameda | California | 6001 | 260696 | 1715 |
2236174 | 2236174 | 2022-02-21 | Alameda | California | 6001 | 259290 | 1713 |
2232923 | 2232923 | 2022-02-20 | Alameda | California | 6001 | 259290 | 1713 |
2229672 | 2229672 | 2022-02-19 | Alameda | California | 6001 | 259290 | 1700 |
2226421 | 2226421 | 2022-02-18 | Alameda | California | 6001 | 259290 | 1700 |
2223170 | 2223170 | 2022-02-17 | Alameda | California | 6001 | 258924 | 1691 |
2219919 | 2219919 | 2022-02-16 | Alameda | California | 6001 | 260114 | 1683 |
2216668 | 2216668 | 2022-02-15 | Alameda | California | 6001 | 259164 | 1681 |
2213417 | 2213417 | 2022-02-14 | Alameda | California | 6001 | 258530 | 1687 |
2210165 | 2210165 | 2022-02-13 | Alameda | California | 6001 | 256986 | 1687 |
2206912 | 2206912 | 2022-02-12 | Alameda | California | 6001 | 256986 | 1678 |
2203659 | 2203659 | 2022-02-11 | Alameda | California | 6001 | 256986 | 1678 |
2200406 | 2200406 | 2022-02-10 | Alameda | California | 6001 | 255990 | 1678 |
2197152 | 2197152 | 2022-02-09 | Alameda | California | 6001 | 255675 | 1660 |
2193897 | 2193897 | 2022-02-08 | Alameda | California | 6001 | 253766 | 1660 |
2190644 | 2190644 | 2022-02-07 | Alameda | California | 6001 | 252276 | 1652 |
2187391 | 2187391 | 2022-02-06 | Alameda | California | 6001 | 250786 | 1652 |
2184138 | 2184138 | 2022-02-05 | Alameda | California | 6001 | 250786 | 1649 |
2180886 | 2180886 | 2022-02-04 | Alameda | California | 6001 | 250786 | 1649 |
2177635 | 2177635 | 2022-02-03 | Alameda | California | 6001 | 249388 | 1649 |
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);