ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "San Bernardino" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174417 | 2174417 | 2022-02-02 | San Bernardino | California | 6071 | 557106 | 6311 |
2171164 | 2171164 | 2022-02-01 | San Bernardino | California | 6071 | 555791 | 6302 |
2167911 | 2167911 | 2022-01-31 | San Bernardino | California | 6071 | 554565 | 6302 |
2164656 | 2164656 | 2022-01-30 | San Bernardino | California | 6071 | 545764 | 6297 |
2161401 | 2161401 | 2022-01-29 | San Bernardino | California | 6071 | 545764 | 6297 |
2158145 | 2158145 | 2022-01-28 | San Bernardino | California | 6071 | 545764 | 6297 |
2154892 | 2154892 | 2022-01-27 | San Bernardino | California | 6071 | 542214 | 6291 |
2151639 | 2151639 | 2022-01-26 | San Bernardino | California | 6071 | 537789 | 6288 |
2148387 | 2148387 | 2022-01-25 | San Bernardino | California | 6071 | 534243 | 6285 |
2145135 | 2145135 | 2022-01-24 | San Bernardino | California | 6071 | 531296 | 6281 |
2141880 | 2141880 | 2022-01-23 | San Bernardino | California | 6071 | 513848 | 6267 |
2138625 | 2138625 | 2022-01-22 | San Bernardino | California | 6071 | 513848 | 6267 |
2135369 | 2135369 | 2022-01-21 | San Bernardino | California | 6071 | 513848 | 6267 |
2132117 | 2132117 | 2022-01-20 | San Bernardino | California | 6071 | 506485 | 6265 |
2128864 | 2128864 | 2022-01-19 | San Bernardino | California | 6071 | 499140 | 6259 |
2125610 | 2125610 | 2022-01-18 | San Bernardino | California | 6071 | 495630 | 6259 |
2122358 | 2122358 | 2022-01-17 | San Bernardino | California | 6071 | 489812 | 6259 |
2119106 | 2119106 | 2022-01-16 | San Bernardino | California | 6071 | 469782 | 6233 |
2115854 | 2115854 | 2022-01-15 | San Bernardino | California | 6071 | 469782 | 6233 |
2112603 | 2112603 | 2022-01-14 | San Bernardino | California | 6071 | 469782 | 6233 |
2109351 | 2109351 | 2022-01-13 | San Bernardino | California | 6071 | 463256 | 6222 |
2106100 | 2106100 | 2022-01-12 | San Bernardino | California | 6071 | 456355 | 6198 |
2102849 | 2102849 | 2022-01-11 | San Bernardino | California | 6071 | 450602 | 6184 |
2099598 | 2099598 | 2022-01-10 | San Bernardino | California | 6071 | 443652 | 6180 |
2096347 | 2096347 | 2022-01-09 | San Bernardino | California | 6071 | 425119 | 6122 |
2093095 | 2093095 | 2022-01-08 | San Bernardino | California | 6071 | 425119 | 6122 |
2089843 | 2089843 | 2022-01-07 | San Bernardino | California | 6071 | 425119 | 6122 |
2086592 | 2086592 | 2022-01-06 | San Bernardino | California | 6071 | 418718 | 6085 |
2083340 | 2083340 | 2022-01-05 | San Bernardino | California | 6071 | 417152 | 6060 |
2080088 | 2080088 | 2022-01-04 | San Bernardino | California | 6071 | 414681 | 6056 |
2076836 | 2076836 | 2022-01-03 | San Bernardino | California | 6071 | 399021 | 6051 |
2073585 | 2073585 | 2022-01-02 | San Bernardino | California | 6071 | 399021 | 6051 |
2070334 | 2070334 | 2022-01-01 | San Bernardino | California | 6071 | 399021 | 6051 |
2067083 | 2067083 | 2021-12-31 | San Bernardino | California | 6071 | 399021 | 6051 |
2063832 | 2063832 | 2021-12-30 | San Bernardino | California | 6071 | 395615 | 6049 |
2060582 | 2060582 | 2021-12-29 | San Bernardino | California | 6071 | 393823 | 6047 |
2057333 | 2057333 | 2021-12-28 | San Bernardino | California | 6071 | 393033 | 6047 |
2054084 | 2054084 | 2021-12-27 | San Bernardino | California | 6071 | 388559 | 6043 |
2050834 | 2050834 | 2021-12-26 | San Bernardino | California | 6071 | 388559 | 6043 |
2047584 | 2047584 | 2021-12-25 | San Bernardino | California | 6071 | 388559 | 6043 |
2044334 | 2044334 | 2021-12-24 | San Bernardino | California | 6071 | 388559 | 6043 |
2041085 | 2041085 | 2021-12-23 | San Bernardino | California | 6071 | 387551 | 6039 |
2037835 | 2037835 | 2021-12-22 | San Bernardino | California | 6071 | 386580 | 6026 |
2034585 | 2034585 | 2021-12-21 | San Bernardino | California | 6071 | 386242 | 6023 |
2031335 | 2031335 | 2021-12-20 | San Bernardino | California | 6071 | 385841 | 6023 |
2028084 | 2028084 | 2021-12-19 | San Bernardino | California | 6071 | 384019 | 6017 |
2024833 | 2024833 | 2021-12-18 | San Bernardino | California | 6071 | 384019 | 6017 |
2021582 | 2021582 | 2021-12-17 | San Bernardino | California | 6071 | 384019 | 6017 |
2018331 | 2018331 | 2021-12-16 | San Bernardino | California | 6071 | 383483 | 6013 |
2015081 | 2015081 | 2021-12-15 | San Bernardino | California | 6071 | 382844 | 6013 |
2011830 | 2011830 | 2021-12-14 | San Bernardino | California | 6071 | 382514 | 6011 |
2008579 | 2008579 | 2021-12-13 | San Bernardino | California | 6071 | 382217 | 6011 |
2005328 | 2005328 | 2021-12-12 | San Bernardino | California | 6071 | 380385 | 6007 |
2002077 | 2002077 | 2021-12-11 | San Bernardino | California | 6071 | 380385 | 6007 |
1998827 | 1998827 | 2021-12-10 | San Bernardino | California | 6071 | 380385 | 6007 |
1995576 | 1995576 | 2021-12-09 | San Bernardino | California | 6071 | 379756 | 6006 |
1992325 | 1992325 | 2021-12-08 | San Bernardino | California | 6071 | 379107 | 6007 |
1989074 | 1989074 | 2021-12-07 | San Bernardino | California | 6071 | 378732 | 5998 |
1985824 | 1985824 | 2021-12-06 | San Bernardino | California | 6071 | 378408 | 5998 |
1982574 | 1982574 | 2021-12-05 | San Bernardino | California | 6071 | 376280 | 5983 |
1979324 | 1979324 | 2021-12-04 | San Bernardino | California | 6071 | 376280 | 5983 |
1976074 | 1976074 | 2021-12-03 | San Bernardino | California | 6071 | 376280 | 5983 |
1972825 | 1972825 | 2021-12-02 | San Bernardino | California | 6071 | 375494 | 5973 |
1969575 | 1969575 | 2021-12-01 | San Bernardino | California | 6071 | 374855 | 5967 |
1966325 | 1966325 | 2021-11-30 | San Bernardino | California | 6071 | 374543 | 5962 |
1963073 | 1963073 | 2021-11-29 | San Bernardino | California | 6071 | 374256 | 5958 |
1959822 | 1959822 | 2021-11-28 | San Bernardino | California | 6071 | 371882 | 5944 |
1956571 | 1956571 | 2021-11-27 | San Bernardino | California | 6071 | 371882 | 5944 |
1953320 | 1953320 | 2021-11-26 | San Bernardino | California | 6071 | 371882 | 5944 |
1950069 | 1950069 | 2021-11-25 | San Bernardino | California | 6071 | 371882 | 5944 |
1946818 | 1946818 | 2021-11-24 | San Bernardino | California | 6071 | 371882 | 5944 |
1943567 | 1943567 | 2021-11-23 | San Bernardino | California | 6071 | 371700 | 5926 |
1940317 | 1940317 | 2021-11-22 | San Bernardino | California | 6071 | 371470 | 5912 |
1937067 | 1937067 | 2021-11-21 | San Bernardino | California | 6071 | 370171 | 5901 |
1933817 | 1933817 | 2021-11-20 | San Bernardino | California | 6071 | 370171 | 5901 |
1930565 | 1930565 | 2021-11-19 | San Bernardino | California | 6071 | 370171 | 5901 |
1927315 | 1927315 | 2021-11-18 | San Bernardino | California | 6071 | 369796 | 5898 |
1924065 | 1924065 | 2021-11-17 | San Bernardino | California | 6071 | 369149 | 5901 |
1920816 | 1920816 | 2021-11-16 | San Bernardino | California | 6071 | 368927 | 5898 |
1917566 | 1917566 | 2021-11-15 | San Bernardino | California | 6071 | 368635 | 5897 |
1914316 | 1914316 | 2021-11-14 | San Bernardino | California | 6071 | 367946 | 5873 |
1911066 | 1911066 | 2021-11-13 | San Bernardino | California | 6071 | 367946 | 5873 |
1907817 | 1907817 | 2021-11-12 | San Bernardino | California | 6071 | 367034 | 5849 |
1904568 | 1904568 | 2021-11-11 | San Bernardino | California | 6071 | 367034 | 5849 |
1901318 | 1901318 | 2021-11-10 | San Bernardino | California | 6071 | 366339 | 5839 |
1898068 | 1898068 | 2021-11-09 | San Bernardino | California | 6071 | 366108 | 5836 |
1894818 | 1894818 | 2021-11-08 | San Bernardino | California | 6071 | 365855 | 5832 |
1891568 | 1891568 | 2021-11-07 | San Bernardino | California | 6071 | 364509 | 5815 |
1888318 | 1888318 | 2021-11-06 | San Bernardino | California | 6071 | 364509 | 5815 |
1885068 | 1885068 | 2021-11-05 | San Bernardino | California | 6071 | 364509 | 5815 |
1881819 | 1881819 | 2021-11-04 | San Bernardino | California | 6071 | 363592 | 5815 |
1878570 | 1878570 | 2021-11-03 | San Bernardino | California | 6071 | 363025 | 5813 |
1875321 | 1875321 | 2021-11-02 | San Bernardino | California | 6071 | 362813 | 5815 |
1872072 | 1872072 | 2021-11-01 | San Bernardino | California | 6071 | 362604 | 5810 |
1868823 | 1868823 | 2021-10-31 | San Bernardino | California | 6071 | 361269 | 5777 |
1865574 | 1865574 | 2021-10-30 | San Bernardino | California | 6071 | 361269 | 5777 |
1862325 | 1862325 | 2021-10-29 | San Bernardino | California | 6071 | 361269 | 5777 |
1859076 | 1859076 | 2021-10-28 | San Bernardino | California | 6071 | 360817 | 5777 |
1855827 | 1855827 | 2021-10-27 | San Bernardino | California | 6071 | 360342 | 5771 |
1852578 | 1852578 | 2021-10-26 | San Bernardino | California | 6071 | 360071 | 5754 |
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);