Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals
This data as json, yaml, copyable, CSV (advanced)
Suggested facets: note, x, y, date (date)
place
fips
county
| Link | rowid | date ▲ | county | fips | place | confirmed_cases | note | x | y |
|---|---|---|---|---|---|---|---|---|---|
| 875 | 875 | 2020-10-23 | Santa Clara | 85 | Campbell | 420 | -121.955 | 37.283889 | |
| 876 | 876 | 2020-10-23 | Santa Clara | 85 | Cupertino | 140 | -122.031944 | 37.323056 | |
| 877 | 877 | 2020-10-23 | Santa Clara | 85 | Gilroy | 1671 | -121.58 | 37.011944 | |
| 878 | 878 | 2020-10-23 | Santa Clara | 85 | Los Altos | 131 | -122.0975 | 37.368056 | |
| 879 | 879 | 2020-10-23 | Santa Clara | 85 | Los Altos Hills | 38 | -122.1375 | 37.371389 | |
| 880 | 880 | 2020-10-23 | Santa Clara | 85 | Los Gatos | 198 | -121.961667 | 37.236111 | |
| 881 | 881 | 2020-10-23 | Santa Clara | 85 | Milpitas | 618 | -121.895 | 37.434722 | |
| 882 | 882 | 2020-10-23 | Santa Clara | 85 | Monte Sereno | 19 | -121.989444 | 37.238056 | |
| 883 | 883 | 2020-10-23 | Santa Clara | 85 | Morgan Hill | 656 | -121.654444 | 37.130556 | |
| 884 | 884 | 2020-10-23 | Santa Clara | 85 | Mountain View | 646 | -122.081944 | 37.389444 | |
| 885 | 885 | 2020-10-23 | Santa Clara | 85 | Palo Alto | 324 | -122.138056 | 37.429167 | |
| 886 | 886 | 2020-10-23 | Santa Clara | 85 | San Jose | 15609 | -121.9 | 37.333333 | |
| 887 | 887 | 2020-10-23 | Santa Clara | 85 | Santa Clara | 1128 | -121.969167 | 37.354444 | |
| 888 | 888 | 2020-10-23 | Santa Clara | 85 | Saratoga | 127 | -122.019444 | 37.2725 | |
| 889 | 889 | 2020-10-23 | Santa Clara | 85 | Sunnyvale | 1043 | -122.0375 | 37.371111 | |
| 1844 | 1844 | 2020-10-22 | Santa Clara | 85 | Campbell | 416 | -121.955 | 37.283889 | |
| 1845 | 1845 | 2020-10-22 | Santa Clara | 85 | Cupertino | 141 | -122.031944 | 37.323056 | |
| 1846 | 1846 | 2020-10-22 | Santa Clara | 85 | Gilroy | 1667 | -121.58 | 37.011944 | |
| 1847 | 1847 | 2020-10-22 | Santa Clara | 85 | Los Altos | 131 | -122.0975 | 37.368056 | |
| 1848 | 1848 | 2020-10-22 | Santa Clara | 85 | Los Altos Hills | 38 | -122.1375 | 37.371389 | |
| 1849 | 1849 | 2020-10-22 | Santa Clara | 85 | Los Gatos | 197 | -121.961667 | 37.236111 | |
| 1850 | 1850 | 2020-10-22 | Santa Clara | 85 | Milpitas | 616 | -121.895 | 37.434722 | |
| 1851 | 1851 | 2020-10-22 | Santa Clara | 85 | Monte Sereno | 19 | -121.989444 | 37.238056 | |
| 1852 | 1852 | 2020-10-22 | Santa Clara | 85 | Morgan Hill | 654 | -121.654444 | 37.130556 | |
| 1853 | 1853 | 2020-10-22 | Santa Clara | 85 | Mountain View | 643 | -122.081944 | 37.389444 | |
| 1854 | 1854 | 2020-10-22 | Santa Clara | 85 | Palo Alto | 322 | -122.138056 | 37.429167 | |
| 1855 | 1855 | 2020-10-22 | Santa Clara | 85 | San Jose | 15551 | -121.9 | 37.333333 | |
| 1856 | 1856 | 2020-10-22 | Santa Clara | 85 | Santa Clara | 1121 | -121.969167 | 37.354444 | |
| 1857 | 1857 | 2020-10-22 | Santa Clara | 85 | Saratoga | 127 | -122.019444 | 37.2725 | |
| 1858 | 1858 | 2020-10-22 | Santa Clara | 85 | Sunnyvale | 1041 | -122.0375 | 37.371111 | |
| 2818 | 2818 | 2020-10-21 | Santa Clara | 85 | Campbell | 416 | -121.955 | 37.283889 | |
| 2819 | 2819 | 2020-10-21 | Santa Clara | 85 | Cupertino | 141 | -122.031944 | 37.323056 | |
| 2820 | 2820 | 2020-10-21 | Santa Clara | 85 | Gilroy | 1667 | -121.58 | 37.011944 | |
| 2821 | 2821 | 2020-10-21 | Santa Clara | 85 | Los Altos | 131 | -122.0975 | 37.368056 | |
| 2822 | 2822 | 2020-10-21 | Santa Clara | 85 | Los Altos Hills | 38 | -122.1375 | 37.371389 | |
| 2823 | 2823 | 2020-10-21 | Santa Clara | 85 | Los Gatos | 197 | -121.961667 | 37.236111 | |
| 2824 | 2824 | 2020-10-21 | Santa Clara | 85 | Milpitas | 616 | -121.895 | 37.434722 | |
| 2825 | 2825 | 2020-10-21 | Santa Clara | 85 | Monte Sereno | 19 | -121.989444 | 37.238056 | |
| 2826 | 2826 | 2020-10-21 | Santa Clara | 85 | Morgan Hill | 654 | -121.654444 | 37.130556 | |
| 2827 | 2827 | 2020-10-21 | Santa Clara | 85 | Mountain View | 643 | -122.081944 | 37.389444 | |
| 2828 | 2828 | 2020-10-21 | Santa Clara | 85 | Palo Alto | 322 | -122.138056 | 37.429167 | |
| 2829 | 2829 | 2020-10-21 | Santa Clara | 85 | San Jose | 15551 | -121.9 | 37.333333 | |
| 2830 | 2830 | 2020-10-21 | Santa Clara | 85 | Santa Clara | 1121 | -121.969167 | 37.354444 | |
| 2831 | 2831 | 2020-10-21 | Santa Clara | 85 | Saratoga | 127 | -122.019444 | 37.2725 | |
| 2832 | 2832 | 2020-10-21 | Santa Clara | 85 | Sunnyvale | 1041 | -122.0375 | 37.371111 | |
| 3829 | 3829 | 2020-10-20 | Santa Clara | 85 | Campbell | 414 | -121.955 | 37.283889 | |
| 3830 | 3830 | 2020-10-20 | Santa Clara | 85 | Cupertino | 140 | -122.031944 | 37.323056 | |
| 3831 | 3831 | 2020-10-20 | Santa Clara | 85 | Gilroy | 1659 | -121.58 | 37.011944 | |
| 3832 | 3832 | 2020-10-20 | Santa Clara | 85 | Los Altos | 131 | -122.0975 | 37.368056 | |
| 3833 | 3833 | 2020-10-20 | Santa Clara | 85 | Los Altos Hills | 38 | -122.1375 | 37.371389 | |
| 3834 | 3834 | 2020-10-20 | Santa Clara | 85 | Los Gatos | 199 | -121.961667 | 37.236111 | |
| 3835 | 3835 | 2020-10-20 | Santa Clara | 85 | Milpitas | 614 | -121.895 | 37.434722 | |
| 3836 | 3836 | 2020-10-20 | Santa Clara | 85 | Monte Sereno | 19 | -121.989444 | 37.238056 | |
| 3837 | 3837 | 2020-10-20 | Santa Clara | 85 | Morgan Hill | 653 | -121.654444 | 37.130556 | |
| 3838 | 3838 | 2020-10-20 | Santa Clara | 85 | Mountain View | 638 | -122.081944 | 37.389444 | |
| 3839 | 3839 | 2020-10-20 | Santa Clara | 85 | Palo Alto | 320 | -122.138056 | 37.429167 | |
| 3840 | 3840 | 2020-10-20 | Santa Clara | 85 | San Jose | 15450 | -121.9 | 37.333333 | |
| 3841 | 3841 | 2020-10-20 | Santa Clara | 85 | Santa Clara | 1115 | -121.969167 | 37.354444 | |
| 3842 | 3842 | 2020-10-20 | Santa Clara | 85 | Saratoga | 126 | -122.019444 | 37.2725 | |
| 3843 | 3843 | 2020-10-20 | Santa Clara | 85 | Sunnyvale | 1038 | -122.0375 | 37.371111 | |
| 4736 | 4736 | 2020-10-19 | Santa Clara | 85 | Campbell | 411 | -121.955 | 37.283889 | |
| 4737 | 4737 | 2020-10-19 | Santa Clara | 85 | Cupertino | 138 | -122.031944 | 37.323056 | |
| 4738 | 4738 | 2020-10-19 | Santa Clara | 85 | Gilroy | 1655 | -121.58 | 37.011944 | |
| 4739 | 4739 | 2020-10-19 | Santa Clara | 85 | Los Altos | 129 | -122.0975 | 37.368056 | |
| 4740 | 4740 | 2020-10-19 | Santa Clara | 85 | Los Altos Hills | 38 | -122.1375 | 37.371389 | |
| 4741 | 4741 | 2020-10-19 | Santa Clara | 85 | Los Gatos | 197 | -121.961667 | 37.236111 | |
| 4742 | 4742 | 2020-10-19 | Santa Clara | 85 | Milpitas | 614 | -121.895 | 37.434722 | |
| 4743 | 4743 | 2020-10-19 | Santa Clara | 85 | Monte Sereno | 19 | -121.989444 | 37.238056 | |
| 4744 | 4744 | 2020-10-19 | Santa Clara | 85 | Morgan Hill | 650 | -121.654444 | 37.130556 | |
| 4745 | 4745 | 2020-10-19 | Santa Clara | 85 | Mountain View | 633 | -122.081944 | 37.389444 | |
| 4746 | 4746 | 2020-10-19 | Santa Clara | 85 | Palo Alto | 320 | -122.138056 | 37.429167 | |
| 4747 | 4747 | 2020-10-19 | Santa Clara | 85 | San Jose | 15379 | -121.9 | 37.333333 | |
| 4748 | 4748 | 2020-10-19 | Santa Clara | 85 | Santa Clara | 1110 | -121.969167 | 37.354444 | |
| 4749 | 4749 | 2020-10-19 | Santa Clara | 85 | Saratoga | 125 | -122.019444 | 37.2725 | |
| 4750 | 4750 | 2020-10-19 | Santa Clara | 85 | Sunnyvale | 1032 | -122.0375 | 37.371111 | |
| 5378 | 5378 | 2020-10-18 | Santa Clara | 85 | Campbell | 400 | -121.955 | 37.283889 | |
| 5379 | 5379 | 2020-10-18 | Santa Clara | 85 | Cupertino | 138 | -122.031944 | 37.323056 | |
| 5380 | 5380 | 2020-10-18 | Santa Clara | 85 | Gilroy | 1649 | -121.58 | 37.011944 | |
| 5381 | 5381 | 2020-10-18 | Santa Clara | 85 | Los Altos | 128 | -122.0975 | 37.368056 | |
| 5382 | 5382 | 2020-10-18 | Santa Clara | 85 | Los Altos Hills | 37 | -122.1375 | 37.371389 | |
| 5383 | 5383 | 2020-10-18 | Santa Clara | 85 | Los Gatos | 196 | -121.961667 | 37.236111 | |
| 5384 | 5384 | 2020-10-18 | Santa Clara | 85 | Milpitas | 613 | -121.895 | 37.434722 | |
| 5385 | 5385 | 2020-10-18 | Santa Clara | 85 | Monte Sereno | 19 | -121.989444 | 37.238056 | |
| 5386 | 5386 | 2020-10-18 | Santa Clara | 85 | Morgan Hill | 647 | -121.654444 | 37.130556 | |
| 5387 | 5387 | 2020-10-18 | Santa Clara | 85 | Mountain View | 628 | -122.081944 | 37.389444 | |
| 5388 | 5388 | 2020-10-18 | Santa Clara | 85 | Palo Alto | 320 | -122.138056 | 37.429167 | |
| 5389 | 5389 | 2020-10-18 | Santa Clara | 85 | San Jose | 15305 | -121.9 | 37.333333 | |
| 5390 | 5390 | 2020-10-18 | Santa Clara | 85 | Santa Clara | 1099 | -121.969167 | 37.354444 | |
| 5391 | 5391 | 2020-10-18 | Santa Clara | 85 | Saratoga | 123 | -122.019444 | 37.2725 | |
| 5392 | 5392 | 2020-10-18 | Santa Clara | 85 | Sunnyvale | 1027 | -122.0375 | 37.371111 | |
| 6059 | 6059 | 2020-10-17 | Santa Clara | 85 | Campbell | 377 | -121.955 | 37.283889 | |
| 6060 | 6060 | 2020-10-17 | Santa Clara | 85 | Cupertino | 137 | -122.031944 | 37.323056 | |
| 6061 | 6061 | 2020-10-17 | Santa Clara | 85 | Gilroy | 1643 | -121.58 | 37.011944 | |
| 6062 | 6062 | 2020-10-17 | Santa Clara | 85 | Los Altos | 128 | -122.0975 | 37.368056 | |
| 6063 | 6063 | 2020-10-17 | Santa Clara | 85 | Los Altos Hills | 37 | -122.1375 | 37.371389 | |
| 6064 | 6064 | 2020-10-17 | Santa Clara | 85 | Los Gatos | 193 | -121.961667 | 37.236111 | |
| 6065 | 6065 | 2020-10-17 | Santa Clara | 85 | Milpitas | 607 | -121.895 | 37.434722 | |
| 6066 | 6066 | 2020-10-17 | Santa Clara | 85 | Monte Sereno | 19 | -121.989444 | 37.238056 | |
| 6067 | 6067 | 2020-10-17 | Santa Clara | 85 | Morgan Hill | 642 | -121.654444 | 37.130556 | |
| 6068 | 6068 | 2020-10-17 | Santa Clara | 85 | Mountain View | 624 | -122.081944 | 37.389444 |
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_place_totals] ( [date] TEXT, [county] TEXT, [fips] INTEGER, [place] TEXT, [confirmed_cases] INTEGER, [note] TEXT, [x] TEXT, [y] TEXT );