latimes_place_totals

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals

2,623 rows where county = "Tulare" sorted by date descending

View and edit SQL

Suggested facets: note, date (date)

fips

county

  • Tulare · 2,623
Link rowid date ▲ county fips place confirmed_cases note x y
971 2020-10-30 Tulare 107 Alpaugh: 93201 28   -119.49352 35.889586
972 2020-10-30 Tulare 107 Corcoran, Angiola: 93212 5   -119.496497 36.04429
973 2020-10-30 Tulare 107 Cutler: 93615 375   -119.286666 36.510523
974 2020-10-30 Tulare 107 Dinuba: 93618 1914   -119.394955 36.517096
975 2020-10-30 Tulare 107 Earlimart: 93219 712   -119.27 35.8825
976 2020-10-30 Tulare 107 Exeter: 93221 365   -119.067431 36.325222
977 2020-10-30 Tulare 107 Farmersville: 93223 540   -119.2077 36.297669
978 2020-10-30 Tulare 107 Goshen: 93227 46   -119.419358 36.349117
979 2020-10-30 Tulare 107 Ivanhoe: 93235 190   -119.224883 36.399684
980 2020-10-30 Tulare 107 Lindsay: 93247 699   -119.078949 36.210707
981 2020-10-30 Tulare 107 Mountain: 93265 51   -118.76204 36.150892
982 2020-10-30 Tulare 107 Orosi: 93647 657   -119.162323 36.590272
983 2020-10-30 Tulare 107 Orosi: 93654 14   -119.394714 36.64647
984 2020-10-30 Tulare 107 Pixley: 93256 313   -119.290833 35.970278
985 2020-10-30 Tulare 107 Porterville: 93257 2976   -119.007909 36.064283
986 2020-10-30 Tulare 107 Richgrove: 93215 140   -119.106667 35.796667
987 2020-10-30 Tulare 107 Strathmore: 93267 257   -119.059692 36.14489
988 2020-10-30 Tulare 107 Terra Bella: 93270 181   -119.040833 35.961389
989 2020-10-30 Tulare 107 Tipton: 93272 104   -119.310278 36.059167
990 2020-10-30 Tulare 107 Traver: 93631 91   -119.533971 36.49031
991 2020-10-30 Tulare 107 Traver: 93646 4   -119.301801 36.631989
992 2020-10-30 Tulare 107 Tulare: 93274 2858   -119.344294 36.206855
993 2020-10-30 Tulare 107 Visalia: 93277 1469   -119.383103 36.303352
994 2020-10-30 Tulare 107 Visalia: 93291 2176   -119.394714 36.369601
995 2020-10-30 Tulare 107 Visalia: 93292 1233   -119.255323 36.32768
996 2020-10-30 Tulare 107 Woodlake: 93286 311   -119.096931 36.413681
1976 2020-10-29 Tulare 107 Alpaugh: 93201 28   -119.49352 35.889586
1977 2020-10-29 Tulare 107 Corcoran, Angiola: 93212 5   -119.496497 36.04429
1978 2020-10-29 Tulare 107 Cutler: 93615 375   -119.286666 36.510523
1979 2020-10-29 Tulare 107 Dinuba: 93618 1912   -119.394955 36.517096
1980 2020-10-29 Tulare 107 Earlimart: 93219 712   -119.27 35.8825
1981 2020-10-29 Tulare 107 Exeter: 93221 363   -119.067431 36.325222
1982 2020-10-29 Tulare 107 Farmersville: 93223 535   -119.2077 36.297669
1983 2020-10-29 Tulare 107 Goshen: 93227 45   -119.419358 36.349117
1984 2020-10-29 Tulare 107 Ivanhoe: 93235 188   -119.224883 36.399684
1985 2020-10-29 Tulare 107 Lindsay: 93247 699   -119.078949 36.210707
1986 2020-10-29 Tulare 107 Mountain: 93265 51   -118.76204 36.150892
1987 2020-10-29 Tulare 107 Orosi: 93647 657   -119.162323 36.590272
1988 2020-10-29 Tulare 107 Orosi: 93654 14   -119.394714 36.64647
1989 2020-10-29 Tulare 107 Pixley: 93256 313   -119.290833 35.970278
1990 2020-10-29 Tulare 107 Porterville: 93257 2966   -119.007909 36.064283
1991 2020-10-29 Tulare 107 Richgrove: 93215 139   -119.106667 35.796667
1992 2020-10-29 Tulare 107 Strathmore: 93267 257   -119.059692 36.14489
1993 2020-10-29 Tulare 107 Terra Bella: 93270 181   -119.040833 35.961389
1994 2020-10-29 Tulare 107 Tipton: 93272 104   -119.310278 36.059167
1995 2020-10-29 Tulare 107 Traver: 93631 92   -119.533971 36.49031
1996 2020-10-29 Tulare 107 Traver: 93646 4   -119.301801 36.631989
1997 2020-10-29 Tulare 107 Tulare: 93274 2848   -119.344294 36.206855
1998 2020-10-29 Tulare 107 Visalia: 93277 1463   -119.383103 36.303352
1999 2020-10-29 Tulare 107 Visalia: 93291 2172   -119.394714 36.369601
2000 2020-10-29 Tulare 107 Visalia: 93292 1227   -119.255323 36.32768
2001 2020-10-29 Tulare 107 Woodlake: 93286 309   -119.096931 36.413681
2928 2020-10-28 Tulare 107 Alpaugh: 93201 28   -119.49352 35.889586
2929 2020-10-28 Tulare 107 Corcoran, Angiola: 93212 5   -119.496497 36.04429
2930 2020-10-28 Tulare 107 Cutler: 93615 373   -119.286666 36.510523
2931 2020-10-28 Tulare 107 Dinuba: 93618 1906   -119.394955 36.517096
2932 2020-10-28 Tulare 107 Earlimart: 93219 709   -119.27 35.8825
2933 2020-10-28 Tulare 107 Exeter: 93221 361   -119.067431 36.325222
2934 2020-10-28 Tulare 107 Farmersville: 93223 535   -119.2077 36.297669
2935 2020-10-28 Tulare 107 Goshen: 93227 45   -119.419358 36.349117
2936 2020-10-28 Tulare 107 Ivanhoe: 93235 188   -119.224883 36.399684
2937 2020-10-28 Tulare 107 Lindsay: 93247 694   -119.078949 36.210707
2938 2020-10-28 Tulare 107 Mountain: 93265 51   -118.76204 36.150892
2939 2020-10-28 Tulare 107 Orosi: 93647 653   -119.162323 36.590272
2940 2020-10-28 Tulare 107 Orosi: 93654 14   -119.394714 36.64647
2941 2020-10-28 Tulare 107 Pixley: 93256 312   -119.290833 35.970278
2942 2020-10-28 Tulare 107 Porterville: 93257 2946   -119.007909 36.064283
2943 2020-10-28 Tulare 107 Richgrove: 93215 139   -119.106667 35.796667
2944 2020-10-28 Tulare 107 Strathmore: 93267 257   -119.059692 36.14489
2945 2020-10-28 Tulare 107 Terra Bella: 93270 182   -119.040833 35.961389
2946 2020-10-28 Tulare 107 Tipton: 93272 102   -119.310278 36.059167
2947 2020-10-28 Tulare 107 Traver: 93631 90   -119.533971 36.49031
2948 2020-10-28 Tulare 107 Traver: 93646 4   -119.301801 36.631989
2949 2020-10-28 Tulare 107 Tulare: 93274 2839   -119.344294 36.206855
2950 2020-10-28 Tulare 107 Visalia: 93277 1463   -119.383103 36.303352
2951 2020-10-28 Tulare 107 Visalia: 93291 2164   -119.394714 36.369601
2952 2020-10-28 Tulare 107 Visalia: 93292 1221   -119.255323 36.32768
2953 2020-10-28 Tulare 107 Woodlake: 93286 307   -119.096931 36.413681
3904 2020-10-27 Tulare 107 Alpaugh: 93201 28   -119.49352 35.889586
3905 2020-10-27 Tulare 107 Corcoran, Angiola: 93212 5   -119.496497 36.04429
3906 2020-10-27 Tulare 107 Cutler: 93615 373   -119.286666 36.510523
3907 2020-10-27 Tulare 107 Dinuba: 93618 1900   -119.394955 36.517096
3908 2020-10-27 Tulare 107 Earlimart: 93219 709   -119.27 35.8825
3909 2020-10-27 Tulare 107 Exeter: 93221 360   -119.067431 36.325222
3910 2020-10-27 Tulare 107 Farmersville: 93223 528   -119.2077 36.297669
3911 2020-10-27 Tulare 107 Goshen: 93227 45   -119.419358 36.349117
3912 2020-10-27 Tulare 107 Ivanhoe: 93235 188   -119.224883 36.399684
3913 2020-10-27 Tulare 107 Lindsay: 93247 694   -119.078949 36.210707
3914 2020-10-27 Tulare 107 Mountain: 93265 51   -118.76204 36.150892
3915 2020-10-27 Tulare 107 Orosi: 93647 650   -119.162323 36.590272
3916 2020-10-27 Tulare 107 Orosi: 93654 14   -119.394714 36.64647
3917 2020-10-27 Tulare 107 Pixley: 93256 312   -119.290833 35.970278
3918 2020-10-27 Tulare 107 Porterville: 93257 2940   -119.007909 36.064283
3919 2020-10-27 Tulare 107 Richgrove: 93215 139   -119.106667 35.796667
3920 2020-10-27 Tulare 107 Strathmore: 93267 255   -119.059692 36.14489
3921 2020-10-27 Tulare 107 Terra Bella: 93270 182   -119.040833 35.961389
3922 2020-10-27 Tulare 107 Tipton: 93272 103   -119.310278 36.059167
3923 2020-10-27 Tulare 107 Traver: 93631 90   -119.533971 36.49031
3924 2020-10-27 Tulare 107 Traver: 93646 4   -119.301801 36.631989
3925 2020-10-27 Tulare 107 Tulare: 93274 2834   -119.344294 36.206855

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [latimes_place_totals] (
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [place] TEXT,
   [confirmed_cases] INTEGER,
   [note] TEXT,
   [x] TEXT,
   [y] TEXT
);
Powered by Datasette · Query took 827.866ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals