ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
824 rows where fips = 6073 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174418 | 2174418 | 2022-02-02 | San Diego | California | 6073 | 744116 | 4710 |
2171165 | 2171165 | 2022-02-01 | San Diego | California | 6073 | 741678 | 4686 |
2167912 | 2167912 | 2022-01-31 | San Diego | California | 6073 | 730252 | 4665 |
2164657 | 2164657 | 2022-01-30 | San Diego | California | 6073 | 726134 | 4643 |
2161402 | 2161402 | 2022-01-29 | San Diego | California | 6073 | 726134 | 4643 |
2158146 | 2158146 | 2022-01-28 | San Diego | California | 6073 | 726134 | 4643 |
2154893 | 2154893 | 2022-01-27 | San Diego | California | 6073 | 719499 | 4622 |
2151640 | 2151640 | 2022-01-26 | San Diego | California | 6073 | 708837 | 4604 |
2148388 | 2148388 | 2022-01-25 | San Diego | California | 6073 | 702307 | 4586 |
2145136 | 2145136 | 2022-01-24 | San Diego | California | 6073 | 678942 | 4566 |
2141881 | 2141881 | 2022-01-23 | San Diego | California | 6073 | 667631 | 4559 |
2138626 | 2138626 | 2022-01-22 | San Diego | California | 6073 | 667631 | 4559 |
2135370 | 2135370 | 2022-01-21 | San Diego | California | 6073 | 667631 | 4559 |
2132118 | 2132118 | 2022-01-20 | San Diego | California | 6073 | 653436 | 4553 |
2128865 | 2128865 | 2022-01-19 | San Diego | California | 6073 | 641235 | 4547 |
2125611 | 2125611 | 2022-01-18 | San Diego | California | 6073 | 605339 | 4545 |
2122359 | 2122359 | 2022-01-17 | San Diego | California | 6073 | 605339 | 4545 |
2119107 | 2119107 | 2022-01-16 | San Diego | California | 6073 | 595483 | 4540 |
2115855 | 2115855 | 2022-01-15 | San Diego | California | 6073 | 595483 | 4540 |
2112604 | 2112604 | 2022-01-14 | San Diego | California | 6073 | 595483 | 4540 |
2109352 | 2109352 | 2022-01-13 | San Diego | California | 6073 | 587767 | 4529 |
2106101 | 2106101 | 2022-01-12 | San Diego | California | 6073 | 563128 | 4520 |
2102850 | 2102850 | 2022-01-11 | San Diego | California | 6073 | 556680 | 4500 |
2099599 | 2099599 | 2022-01-10 | San Diego | California | 6073 | 504380 | 4500 |
2096348 | 2096348 | 2022-01-09 | San Diego | California | 6073 | 498447 | 4495 |
2093096 | 2093096 | 2022-01-08 | San Diego | California | 6073 | 498447 | 4495 |
2089844 | 2089844 | 2022-01-07 | San Diego | California | 6073 | 498447 | 4495 |
2086593 | 2086593 | 2022-01-06 | San Diego | California | 6073 | 492776 | 4495 |
2083341 | 2083341 | 2022-01-05 | San Diego | California | 6073 | 482494 | 4487 |
2080089 | 2080089 | 2022-01-04 | San Diego | California | 6073 | 475149 | 4476 |
2076837 | 2076837 | 2022-01-03 | San Diego | California | 6073 | 451082 | 4469 |
2073586 | 2073586 | 2022-01-02 | San Diego | California | 6073 | 451082 | 4469 |
2070335 | 2070335 | 2022-01-01 | San Diego | California | 6073 | 451082 | 4469 |
2067084 | 2067084 | 2021-12-31 | San Diego | California | 6073 | 451082 | 4469 |
2063833 | 2063833 | 2021-12-30 | San Diego | California | 6073 | 445040 | 4461 |
2060583 | 2060583 | 2021-12-29 | San Diego | California | 6073 | 440806 | 4450 |
2057334 | 2057334 | 2021-12-28 | San Diego | California | 6073 | 438391 | 4445 |
2054085 | 2054085 | 2021-12-27 | San Diego | California | 6073 | 430039 | 4442 |
2050835 | 2050835 | 2021-12-26 | San Diego | California | 6073 | 430039 | 4442 |
2047585 | 2047585 | 2021-12-25 | San Diego | California | 6073 | 430039 | 4442 |
2044335 | 2044335 | 2021-12-24 | San Diego | California | 6073 | 430039 | 4442 |
2041086 | 2041086 | 2021-12-23 | San Diego | California | 6073 | 427692 | 4434 |
2037836 | 2037836 | 2021-12-22 | San Diego | California | 6073 | 425456 | 4424 |
2034586 | 2034586 | 2021-12-21 | San Diego | California | 6073 | 424553 | 4412 |
2031336 | 2031336 | 2021-12-20 | San Diego | California | 6073 | 421267 | 4406 |
2028085 | 2028085 | 2021-12-19 | San Diego | California | 6073 | 420200 | 4399 |
2024834 | 2024834 | 2021-12-18 | San Diego | California | 6073 | 420200 | 4399 |
2021583 | 2021583 | 2021-12-17 | San Diego | California | 6073 | 420200 | 4399 |
2018332 | 2018332 | 2021-12-16 | San Diego | California | 6073 | 419616 | 4395 |
2015082 | 2015082 | 2021-12-15 | San Diego | California | 6073 | 418671 | 4393 |
2011831 | 2011831 | 2021-12-14 | San Diego | California | 6073 | 418061 | 4389 |
2008580 | 2008580 | 2021-12-13 | San Diego | California | 6073 | 416102 | 4378 |
2005329 | 2005329 | 2021-12-12 | San Diego | California | 6073 | 415069 | 4374 |
2002078 | 2002078 | 2021-12-11 | San Diego | California | 6073 | 415069 | 4374 |
1998828 | 1998828 | 2021-12-10 | San Diego | California | 6073 | 415069 | 4374 |
1995577 | 1995577 | 2021-12-09 | San Diego | California | 6073 | 414471 | 4369 |
1992326 | 1992326 | 2021-12-08 | San Diego | California | 6073 | 413645 | 4357 |
1989075 | 1989075 | 2021-12-07 | San Diego | California | 6073 | 412924 | 4352 |
1985825 | 1985825 | 2021-12-06 | San Diego | California | 6073 | 410514 | 4351 |
1982575 | 1982575 | 2021-12-05 | San Diego | California | 6073 | 409245 | 4350 |
1979325 | 1979325 | 2021-12-04 | San Diego | California | 6073 | 409245 | 4350 |
1976075 | 1976075 | 2021-12-03 | San Diego | California | 6073 | 409245 | 4350 |
1972826 | 1972826 | 2021-12-02 | San Diego | California | 6073 | 408591 | 4346 |
1969576 | 1969576 | 2021-12-01 | San Diego | California | 6073 | 407542 | 4340 |
1966326 | 1966326 | 2021-11-30 | San Diego | California | 6073 | 406990 | 4335 |
1963074 | 1963074 | 2021-11-29 | San Diego | California | 6073 | 405162 | 4325 |
1959823 | 1959823 | 2021-11-28 | San Diego | California | 6073 | 404771 | 4319 |
1956572 | 1956572 | 2021-11-27 | San Diego | California | 6073 | 404771 | 4319 |
1953321 | 1953321 | 2021-11-26 | San Diego | California | 6073 | 404771 | 4319 |
1950070 | 1950070 | 2021-11-25 | San Diego | California | 6073 | 404771 | 4319 |
1946819 | 1946819 | 2021-11-24 | San Diego | California | 6073 | 404771 | 4319 |
1943568 | 1943568 | 2021-11-23 | San Diego | California | 6073 | 404269 | 4317 |
1940318 | 1940318 | 2021-11-22 | San Diego | California | 6073 | 402884 | 4317 |
1937068 | 1937068 | 2021-11-21 | San Diego | California | 6073 | 402284 | 4311 |
1933818 | 1933818 | 2021-11-20 | San Diego | California | 6073 | 402284 | 4311 |
1930566 | 1930566 | 2021-11-19 | San Diego | California | 6073 | 402284 | 4311 |
1927316 | 1927316 | 2021-11-18 | San Diego | California | 6073 | 401906 | 4301 |
1924066 | 1924066 | 2021-11-17 | San Diego | California | 6073 | 401342 | 4287 |
1920817 | 1920817 | 2021-11-16 | San Diego | California | 6073 | 400752 | 4284 |
1917567 | 1917567 | 2021-11-15 | San Diego | California | 6073 | 399540 | 4280 |
1914317 | 1914317 | 2021-11-14 | San Diego | California | 6073 | 399540 | 4280 |
1911067 | 1911067 | 2021-11-13 | San Diego | California | 6073 | 399540 | 4280 |
1907818 | 1907818 | 2021-11-12 | San Diego | California | 6073 | 398335 | 4272 |
1904569 | 1904569 | 2021-11-11 | San Diego | California | 6073 | 398335 | 4272 |
1901319 | 1901319 | 2021-11-10 | San Diego | California | 6073 | 397700 | 4272 |
1898069 | 1898069 | 2021-11-09 | San Diego | California | 6073 | 397260 | 4259 |
1894819 | 1894819 | 2021-11-08 | San Diego | California | 6073 | 396868 | 4250 |
1891569 | 1891569 | 2021-11-07 | San Diego | California | 6073 | 395126 | 4246 |
1888319 | 1888319 | 2021-11-06 | San Diego | California | 6073 | 395126 | 4246 |
1885069 | 1885069 | 2021-11-05 | San Diego | California | 6073 | 395126 | 4246 |
1881820 | 1881820 | 2021-11-04 | San Diego | California | 6073 | 394654 | 4241 |
1878571 | 1878571 | 2021-11-03 | San Diego | California | 6073 | 393968 | 4232 |
1875322 | 1875322 | 2021-11-02 | San Diego | California | 6073 | 393571 | 4232 |
1872073 | 1872073 | 2021-11-01 | San Diego | California | 6073 | 393131 | 4218 |
1868824 | 1868824 | 2021-10-31 | San Diego | California | 6073 | 391534 | 4213 |
1865575 | 1865575 | 2021-10-30 | San Diego | California | 6073 | 391534 | 4213 |
1862326 | 1862326 | 2021-10-29 | San Diego | California | 6073 | 391534 | 4213 |
1859077 | 1859077 | 2021-10-28 | San Diego | California | 6073 | 391107 | 4207 |
1855828 | 1855828 | 2021-10-27 | San Diego | California | 6073 | 385878 | 4198 |
1852579 | 1852579 | 2021-10-26 | San Diego | California | 6073 | 385221 | 4196 |
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);