ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where fips = 6011 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1810309 | 1810309 | 2021-10-13 | Colusa | California | 6011 | 3002 | 18 |
1807060 | 1807060 | 2021-10-12 | Colusa | California | 6011 | 3001 | 18 |
1803809 | 1803809 | 2021-10-11 | Colusa | California | 6011 | 2999 | 18 |
1800560 | 1800560 | 2021-10-10 | Colusa | California | 6011 | 2993 | 18 |
1797311 | 1797311 | 2021-10-09 | Colusa | California | 6011 | 2993 | 18 |
1794062 | 1794062 | 2021-10-08 | Colusa | California | 6011 | 2993 | 18 |
1790814 | 1790814 | 2021-10-07 | Colusa | California | 6011 | 2988 | 18 |
1787565 | 1787565 | 2021-10-06 | Colusa | California | 6011 | 2979 | 18 |
1784316 | 1784316 | 2021-10-05 | Colusa | California | 6011 | 2979 | 18 |
1781067 | 1781067 | 2021-10-04 | Colusa | California | 6011 | 2978 | 18 |
1777817 | 1777817 | 2021-10-03 | Colusa | California | 6011 | 2968 | 18 |
1774567 | 1774567 | 2021-10-02 | Colusa | California | 6011 | 2968 | 18 |
1771317 | 1771317 | 2021-10-01 | Colusa | California | 6011 | 2968 | 18 |
1768068 | 1768068 | 2021-09-30 | Colusa | California | 6011 | 2966 | 18 |
1764819 | 1764819 | 2021-09-29 | Colusa | California | 6011 | 2951 | 18 |
1761570 | 1761570 | 2021-09-28 | Colusa | California | 6011 | 2945 | 18 |
1758322 | 1758322 | 2021-09-27 | Colusa | California | 6011 | 2944 | 18 |
1755074 | 1755074 | 2021-09-26 | Colusa | California | 6011 | 2939 | 18 |
1751826 | 1751826 | 2021-09-25 | Colusa | California | 6011 | 2939 | 18 |
1748577 | 1748577 | 2021-09-24 | Colusa | California | 6011 | 2939 | 18 |
1745327 | 1745327 | 2021-09-23 | Colusa | California | 6011 | 2936 | 18 |
1742078 | 1742078 | 2021-09-22 | Colusa | California | 6011 | 2912 | 18 |
1738829 | 1738829 | 2021-09-21 | Colusa | California | 6011 | 2910 | 18 |
1735580 | 1735580 | 2021-09-20 | Colusa | California | 6011 | 2909 | 18 |
1732330 | 1732330 | 2021-09-19 | Colusa | California | 6011 | 2907 | 18 |
1729080 | 1729080 | 2021-09-18 | Colusa | California | 6011 | 2903 | 18 |
1725830 | 1725830 | 2021-09-17 | Colusa | California | 6011 | 2897 | 18 |
1722581 | 1722581 | 2021-09-16 | Colusa | California | 6011 | 2886 | 18 |
1719332 | 1719332 | 2021-09-15 | Colusa | California | 6011 | 2857 | 18 |
1716084 | 1716084 | 2021-09-14 | Colusa | California | 6011 | 2859 | 18 |
1712838 | 1712838 | 2021-09-13 | Colusa | California | 6011 | 2857 | 18 |
1709591 | 1709591 | 2021-09-12 | Colusa | California | 6011 | 2851 | 18 |
1706344 | 1706344 | 2021-09-11 | Colusa | California | 6011 | 2840 | 18 |
1703096 | 1703096 | 2021-09-10 | Colusa | California | 6011 | 2834 | 18 |
1699846 | 1699846 | 2021-09-09 | Colusa | California | 6011 | 2821 | 18 |
1696597 | 1696597 | 2021-09-08 | Colusa | California | 6011 | 2804 | 18 |
1693349 | 1693349 | 2021-09-07 | Colusa | California | 6011 | 2804 | 18 |
1690100 | 1690100 | 2021-09-06 | Colusa | California | 6011 | 2803 | 18 |
1686850 | 1686850 | 2021-09-05 | Colusa | California | 6011 | 2799 | 18 |
1683600 | 1683600 | 2021-09-04 | Colusa | California | 6011 | 2793 | 18 |
1680349 | 1680349 | 2021-09-03 | Colusa | California | 6011 | 2788 | 18 |
1677101 | 1677101 | 2021-09-02 | Colusa | California | 6011 | 2779 | 18 |
1673854 | 1673854 | 2021-09-01 | Colusa | California | 6011 | 2754 | 18 |
1670606 | 1670606 | 2021-08-31 | Colusa | California | 6011 | 2729 | 18 |
1667359 | 1667359 | 2021-08-30 | Colusa | California | 6011 | 2718 | 18 |
1664112 | 1664112 | 2021-08-29 | Colusa | California | 6011 | 2710 | 18 |
1660864 | 1660864 | 2021-08-28 | Colusa | California | 6011 | 2698 | 18 |
1657616 | 1657616 | 2021-08-27 | Colusa | California | 6011 | 2692 | 18 |
1654368 | 1654368 | 2021-08-26 | Colusa | California | 6011 | 2685 | 18 |
1651121 | 1651121 | 2021-08-25 | Colusa | California | 6011 | 2655 | 18 |
1647872 | 1647872 | 2021-08-24 | Colusa | California | 6011 | 2639 | 18 |
1644624 | 1644624 | 2021-08-23 | Colusa | California | 6011 | 2634 | 18 |
1641374 | 1641374 | 2021-08-22 | Colusa | California | 6011 | 2625 | 18 |
1638124 | 1638124 | 2021-08-21 | Colusa | California | 6011 | 2611 | 18 |
1634874 | 1634874 | 2021-08-20 | Colusa | California | 6011 | 2600 | 18 |
1631625 | 1631625 | 2021-08-19 | Colusa | California | 6011 | 2593 | 18 |
1628378 | 1628378 | 2021-08-18 | Colusa | California | 6011 | 2522 | 18 |
1625131 | 1625131 | 2021-08-17 | Colusa | California | 6011 | 2513 | 18 |
1621884 | 1621884 | 2021-08-16 | Colusa | California | 6011 | 2506 | 18 |
1618637 | 1618637 | 2021-08-15 | Colusa | California | 6011 | 2500 | 18 |
1615389 | 1615389 | 2021-08-14 | Colusa | California | 6011 | 2489 | 18 |
1612140 | 1612140 | 2021-08-13 | Colusa | California | 6011 | 2477 | 18 |
1608892 | 1608892 | 2021-08-12 | Colusa | California | 6011 | 2467 | 18 |
1605643 | 1605643 | 2021-08-11 | Colusa | California | 6011 | 2459 | 18 |
1602394 | 1602394 | 2021-08-10 | Colusa | California | 6011 | 2441 | 18 |
1599145 | 1599145 | 2021-08-09 | Colusa | California | 6011 | 2436 | 18 |
1595896 | 1595896 | 2021-08-08 | Colusa | California | 6011 | 2433 | 18 |
1592647 | 1592647 | 2021-08-07 | Colusa | California | 6011 | 2402 | 18 |
1589398 | 1589398 | 2021-08-06 | Colusa | California | 6011 | 2402 | 18 |
1586149 | 1586149 | 2021-08-05 | Colusa | California | 6011 | 2391 | 18 |
1582899 | 1582899 | 2021-08-04 | Colusa | California | 6011 | 2381 | 18 |
1579649 | 1579649 | 2021-08-03 | Colusa | California | 6011 | 2371 | 16 |
1576401 | 1576401 | 2021-08-02 | Colusa | California | 6011 | 2366 | 18 |
1573153 | 1573153 | 2021-08-01 | Colusa | California | 6011 | 2358 | 18 |
1569905 | 1569905 | 2021-07-31 | Colusa | California | 6011 | 2358 | 18 |
1566657 | 1566657 | 2021-07-30 | Colusa | California | 6011 | 2358 | 18 |
1563409 | 1563409 | 2021-07-29 | Colusa | California | 6011 | 2353 | 18 |
1560161 | 1560161 | 2021-07-28 | Colusa | California | 6011 | 2347 | 18 |
1556914 | 1556914 | 2021-07-27 | Colusa | California | 6011 | 2344 | 18 |
1553667 | 1553667 | 2021-07-26 | Colusa | California | 6011 | 2344 | 18 |
1550420 | 1550420 | 2021-07-25 | Colusa | California | 6011 | 2340 | 18 |
1547173 | 1547173 | 2021-07-24 | Colusa | California | 6011 | 2340 | 18 |
1543926 | 1543926 | 2021-07-23 | Colusa | California | 6011 | 2340 | 18 |
1540678 | 1540678 | 2021-07-22 | Colusa | California | 6011 | 2336 | 18 |
1537431 | 1537431 | 2021-07-21 | Colusa | California | 6011 | 2322 | 18 |
1534183 | 1534183 | 2021-07-20 | Colusa | California | 6011 | 2322 | 18 |
1530936 | 1530936 | 2021-07-19 | Colusa | California | 6011 | 2322 | 18 |
1527689 | 1527689 | 2021-07-18 | Colusa | California | 6011 | 2322 | 18 |
1524442 | 1524442 | 2021-07-17 | Colusa | California | 6011 | 2322 | 18 |
1521194 | 1521194 | 2021-07-16 | Colusa | California | 6011 | 2322 | 18 |
1517946 | 1517946 | 2021-07-15 | Colusa | California | 6011 | 2308 | 18 |
1514699 | 1514699 | 2021-07-14 | Colusa | California | 6011 | 2308 | 18 |
1511453 | 1511453 | 2021-07-13 | Colusa | California | 6011 | 2308 | 18 |
1508206 | 1508206 | 2021-07-12 | Colusa | California | 6011 | 2305 | 18 |
1504960 | 1504960 | 2021-07-11 | Colusa | California | 6011 | 2303 | 18 |
1501714 | 1501714 | 2021-07-10 | Colusa | California | 6011 | 2303 | 18 |
1498468 | 1498468 | 2021-07-09 | Colusa | California | 6011 | 2303 | 18 |
1495221 | 1495221 | 2021-07-08 | Colusa | California | 6011 | 2303 | 18 |
1491974 | 1491974 | 2021-07-07 | Colusa | California | 6011 | 2298 | 18 |
1488727 | 1488727 | 2021-07-06 | Colusa | California | 6011 | 2298 | 18 |
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);