ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where county = "Fresno" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174391 | 2174391 | 2022-02-02 | Fresno | California | 6019 | 228842 | 2464 |
2171138 | 2171138 | 2022-02-01 | Fresno | California | 6019 | 228079 | 2464 |
2167885 | 2167885 | 2022-01-31 | Fresno | California | 6019 | 227135 | 2463 |
2164630 | 2164630 | 2022-01-30 | Fresno | California | 6019 | 220181 | 2457 |
2161375 | 2161375 | 2022-01-29 | Fresno | California | 6019 | 220181 | 2457 |
2158119 | 2158119 | 2022-01-28 | Fresno | California | 6019 | 220181 | 2457 |
2154866 | 2154866 | 2022-01-27 | Fresno | California | 6019 | 217179 | 2452 |
2151613 | 2151613 | 2022-01-26 | Fresno | California | 6019 | 214050 | 2434 |
2148361 | 2148361 | 2022-01-25 | Fresno | California | 6019 | 211880 | 2430 |
2145109 | 2145109 | 2022-01-24 | Fresno | California | 6019 | 209430 | 2430 |
2141854 | 2141854 | 2022-01-23 | Fresno | California | 6019 | 201080 | 2429 |
2138599 | 2138599 | 2022-01-22 | Fresno | California | 6019 | 201080 | 2429 |
2135343 | 2135343 | 2022-01-21 | Fresno | California | 6019 | 201080 | 2429 |
2132091 | 2132091 | 2022-01-20 | Fresno | California | 6019 | 197314 | 2430 |
2128838 | 2128838 | 2022-01-19 | Fresno | California | 6019 | 193234 | 2425 |
2125584 | 2125584 | 2022-01-18 | Fresno | California | 6019 | 191271 | 2426 |
2122332 | 2122332 | 2022-01-17 | Fresno | California | 6019 | 189130 | 2425 |
2119080 | 2119080 | 2022-01-16 | Fresno | California | 6019 | 181673 | 2415 |
2115828 | 2115828 | 2022-01-15 | Fresno | California | 6019 | 181673 | 2415 |
2112577 | 2112577 | 2022-01-14 | Fresno | California | 6019 | 181673 | 2415 |
2109325 | 2109325 | 2022-01-13 | Fresno | California | 6019 | 179628 | 2413 |
2106074 | 2106074 | 2022-01-12 | Fresno | California | 6019 | 176980 | 2404 |
2102823 | 2102823 | 2022-01-11 | Fresno | California | 6019 | 175064 | 2404 |
2099572 | 2099572 | 2022-01-10 | Fresno | California | 6019 | 173460 | 2405 |
2096321 | 2096321 | 2022-01-09 | Fresno | California | 6019 | 168865 | 2393 |
2093069 | 2093069 | 2022-01-08 | Fresno | California | 6019 | 168865 | 2393 |
2089817 | 2089817 | 2022-01-07 | Fresno | California | 6019 | 168865 | 2393 |
2086566 | 2086566 | 2022-01-06 | Fresno | California | 6019 | 166504 | 2377 |
2083314 | 2083314 | 2022-01-05 | Fresno | California | 6019 | 166384 | 2380 |
2080062 | 2080062 | 2022-01-04 | Fresno | California | 6019 | 165814 | 2379 |
2076810 | 2076810 | 2022-01-03 | Fresno | California | 6019 | 163067 | 2379 |
2073559 | 2073559 | 2022-01-02 | Fresno | California | 6019 | 163067 | 2379 |
2070308 | 2070308 | 2022-01-01 | Fresno | California | 6019 | 163067 | 2379 |
2067057 | 2067057 | 2021-12-31 | Fresno | California | 6019 | 163067 | 2379 |
2063806 | 2063806 | 2021-12-30 | Fresno | California | 6019 | 162458 | 2364 |
2060556 | 2060556 | 2021-12-29 | Fresno | California | 6019 | 161993 | 2365 |
2057307 | 2057307 | 2021-12-28 | Fresno | California | 6019 | 161832 | 2364 |
2054058 | 2054058 | 2021-12-27 | Fresno | California | 6019 | 161033 | 2358 |
2050808 | 2050808 | 2021-12-26 | Fresno | California | 6019 | 161033 | 2358 |
2047558 | 2047558 | 2021-12-25 | Fresno | California | 6019 | 161033 | 2358 |
2044308 | 2044308 | 2021-12-24 | Fresno | California | 6019 | 161033 | 2358 |
2041059 | 2041059 | 2021-12-23 | Fresno | California | 6019 | 160844 | 2349 |
2037809 | 2037809 | 2021-12-22 | Fresno | California | 6019 | 160594 | 2341 |
2034559 | 2034559 | 2021-12-21 | Fresno | California | 6019 | 160492 | 2341 |
2031309 | 2031309 | 2021-12-20 | Fresno | California | 6019 | 160392 | 2341 |
2028058 | 2028058 | 2021-12-19 | Fresno | California | 6019 | 159925 | 2335 |
2024807 | 2024807 | 2021-12-18 | Fresno | California | 6019 | 159925 | 2335 |
2021556 | 2021556 | 2021-12-17 | Fresno | California | 6019 | 159925 | 2335 |
2018305 | 2018305 | 2021-12-16 | Fresno | California | 6019 | 159746 | 2319 |
2015055 | 2015055 | 2021-12-15 | Fresno | California | 6019 | 159570 | 2316 |
2011804 | 2011804 | 2021-12-14 | Fresno | California | 6019 | 159455 | 2312 |
2008553 | 2008553 | 2021-12-13 | Fresno | California | 6019 | 159332 | 2310 |
2005302 | 2005302 | 2021-12-12 | Fresno | California | 6019 | 158802 | 2294 |
2002051 | 2002051 | 2021-12-11 | Fresno | California | 6019 | 158802 | 2294 |
1998801 | 1998801 | 2021-12-10 | Fresno | California | 6019 | 158802 | 2294 |
1995550 | 1995550 | 2021-12-09 | Fresno | California | 6019 | 158644 | 2293 |
1992299 | 1992299 | 2021-12-08 | Fresno | California | 6019 | 158450 | 2289 |
1989048 | 1989048 | 2021-12-07 | Fresno | California | 6019 | 158274 | 2285 |
1985798 | 1985798 | 2021-12-06 | Fresno | California | 6019 | 158187 | 2284 |
1982548 | 1982548 | 2021-12-05 | Fresno | California | 6019 | 157469 | 2270 |
1979298 | 1979298 | 2021-12-04 | Fresno | California | 6019 | 157469 | 2270 |
1976048 | 1976048 | 2021-12-03 | Fresno | California | 6019 | 157469 | 2270 |
1972799 | 1972799 | 2021-12-02 | Fresno | California | 6019 | 157242 | 2264 |
1969549 | 1969549 | 2021-12-01 | Fresno | California | 6019 | 156897 | 2259 |
1966299 | 1966299 | 2021-11-30 | Fresno | California | 6019 | 156795 | 2254 |
1963047 | 1963047 | 2021-11-29 | Fresno | California | 6019 | 156677 | 2252 |
1959796 | 1959796 | 2021-11-28 | Fresno | California | 6019 | 155899 | 2246 |
1956545 | 1956545 | 2021-11-27 | Fresno | California | 6019 | 155899 | 2246 |
1953294 | 1953294 | 2021-11-26 | Fresno | California | 6019 | 155899 | 2246 |
1950043 | 1950043 | 2021-11-25 | Fresno | California | 6019 | 155899 | 2246 |
1946792 | 1946792 | 2021-11-24 | Fresno | California | 6019 | 155899 | 2246 |
1943541 | 1943541 | 2021-11-23 | Fresno | California | 6019 | 155803 | 2243 |
1940291 | 1940291 | 2021-11-22 | Fresno | California | 6019 | 155716 | 2242 |
1937041 | 1937041 | 2021-11-21 | Fresno | California | 6019 | 155092 | 2233 |
1933791 | 1933791 | 2021-11-20 | Fresno | California | 6019 | 155092 | 2233 |
1930539 | 1930539 | 2021-11-19 | Fresno | California | 6019 | 155092 | 2233 |
1927289 | 1927289 | 2021-11-18 | Fresno | California | 6019 | 154879 | 2230 |
1924039 | 1924039 | 2021-11-17 | Fresno | California | 6019 | 154588 | 2218 |
1920790 | 1920790 | 2021-11-16 | Fresno | California | 6019 | 154403 | 2210 |
1917540 | 1917540 | 2021-11-15 | Fresno | California | 6019 | 154257 | 2209 |
1914290 | 1914290 | 2021-11-14 | Fresno | California | 6019 | 153840 | 2205 |
1911040 | 1911040 | 2021-11-13 | Fresno | California | 6019 | 153840 | 2205 |
1907791 | 1907791 | 2021-11-12 | Fresno | California | 6019 | 153221 | 2202 |
1904542 | 1904542 | 2021-11-11 | Fresno | California | 6019 | 153221 | 2202 |
1901292 | 1901292 | 2021-11-10 | Fresno | California | 6019 | 152930 | 2188 |
1898042 | 1898042 | 2021-11-09 | Fresno | California | 6019 | 152730 | 2179 |
1894792 | 1894792 | 2021-11-08 | Fresno | California | 6019 | 152527 | 2179 |
1891542 | 1891542 | 2021-11-07 | Fresno | California | 6019 | 151513 | 2170 |
1888292 | 1888292 | 2021-11-06 | Fresno | California | 6019 | 151513 | 2170 |
1885042 | 1885042 | 2021-11-05 | Fresno | California | 6019 | 151513 | 2170 |
1881793 | 1881793 | 2021-11-04 | Fresno | California | 6019 | 151137 | 2166 |
1878544 | 1878544 | 2021-11-03 | Fresno | California | 6019 | 150681 | 2158 |
1875295 | 1875295 | 2021-11-02 | Fresno | California | 6019 | 150458 | 2149 |
1872046 | 1872046 | 2021-11-01 | Fresno | California | 6019 | 150202 | 2147 |
1868797 | 1868797 | 2021-10-31 | Fresno | California | 6019 | 148938 | 2131 |
1865548 | 1865548 | 2021-10-30 | Fresno | California | 6019 | 148938 | 2131 |
1862299 | 1862299 | 2021-10-29 | Fresno | California | 6019 | 148938 | 2131 |
1859050 | 1859050 | 2021-10-28 | Fresno | California | 6019 | 148484 | 2128 |
1855801 | 1855801 | 2021-10-27 | Fresno | California | 6019 | 148063 | 2122 |
1852552 | 1852552 | 2021-10-26 | Fresno | California | 6019 | 147826 | 2112 |
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);