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,545 rows where fips = 107 sorted by date descending

View and edit SQL

Suggested facets: note, date (date)

fips

  • 107 · 2,545

county

Link rowid date ▲ county fips place confirmed_cases note x y
922 2020-10-27 Tulare 107 Alpaugh: 93201 28   -119.49352 35.889586
923 2020-10-27 Tulare 107 Corcoran, Angiola: 93212 5   -119.496497 36.04429
924 2020-10-27 Tulare 107 Cutler: 93615 373   -119.286666 36.510523
925 2020-10-27 Tulare 107 Dinuba: 93618 1900   -119.394955 36.517096
926 2020-10-27 Tulare 107 Earlimart: 93219 709   -119.27 35.8825
927 2020-10-27 Tulare 107 Exeter: 93221 360   -119.067431 36.325222
928 2020-10-27 Tulare 107 Farmersville: 93223 528   -119.2077 36.297669
929 2020-10-27 Tulare 107 Goshen: 93227 45   -119.419358 36.349117
930 2020-10-27 Tulare 107 Ivanhoe: 93235 188   -119.224883 36.399684
931 2020-10-27 Tulare 107 Lindsay: 93247 694   -119.078949 36.210707
932 2020-10-27 Tulare 107 Mountain: 93265 51   -118.76204 36.150892
933 2020-10-27 Tulare 107 Orosi: 93647 650   -119.162323 36.590272
934 2020-10-27 Tulare 107 Orosi: 93654 14   -119.394714 36.64647
935 2020-10-27 Tulare 107 Pixley: 93256 312   -119.290833 35.970278
936 2020-10-27 Tulare 107 Porterville: 93257 2940   -119.007909 36.064283
937 2020-10-27 Tulare 107 Richgrove: 93215 139   -119.106667 35.796667
938 2020-10-27 Tulare 107 Strathmore: 93267 255   -119.059692 36.14489
939 2020-10-27 Tulare 107 Terra Bella: 93270 182   -119.040833 35.961389
940 2020-10-27 Tulare 107 Tipton: 93272 103   -119.310278 36.059167
941 2020-10-27 Tulare 107 Traver: 93631 90   -119.533971 36.49031
942 2020-10-27 Tulare 107 Traver: 93646 4   -119.301801 36.631989
943 2020-10-27 Tulare 107 Tulare: 93274 2834   -119.344294 36.206855
944 2020-10-27 Tulare 107 Visalia: 93277 1453   -119.383103 36.303352
945 2020-10-27 Tulare 107 Visalia: 93291 2159   -119.394714 36.369601
946 2020-10-27 Tulare 107 Visalia: 93292 1213   -119.255323 36.32768
947 2020-10-27 Tulare 107 Woodlake: 93286 307   -119.096931 36.413681
2591 2020-10-25 Tulare 107 Alpaugh: 93201 28   -119.49352 35.889586
2592 2020-10-25 Tulare 107 Corcoran, Angiola: 93212 5   -119.496497 36.04429
2593 2020-10-25 Tulare 107 Cutler: 93615 372   -119.286666 36.510523
2594 2020-10-25 Tulare 107 Dinuba: 93618 1893   -119.394955 36.517096
2595 2020-10-25 Tulare 107 Earlimart: 93219 709   -119.27 35.8825
2596 2020-10-25 Tulare 107 Exeter: 93221 359   -119.067431 36.325222
2597 2020-10-25 Tulare 107 Farmersville: 93223 525   -119.2077 36.297669
2598 2020-10-25 Tulare 107 Goshen: 93227 45   -119.419358 36.349117
2599 2020-10-25 Tulare 107 Ivanhoe: 93235 187   -119.224883 36.399684
2600 2020-10-25 Tulare 107 Lindsay: 93247 693   -119.078949 36.210707
2601 2020-10-25 Tulare 107 Mountain: 93265 51   -118.76204 36.150892
2602 2020-10-25 Tulare 107 Orosi: 93647 648   -119.162323 36.590272
2603 2020-10-25 Tulare 107 Orosi: 93654 14   -119.394714 36.64647
2604 2020-10-25 Tulare 107 Pixley: 93256 312   -119.290833 35.970278
2605 2020-10-25 Tulare 107 Porterville: 93257 2913   -119.007909 36.064283
2606 2020-10-25 Tulare 107 Richgrove: 93215 140   -119.106667 35.796667
2607 2020-10-25 Tulare 107 Strathmore: 93267 250   -119.059692 36.14489
2608 2020-10-25 Tulare 107 Terra Bella: 93270 181   -119.040833 35.961389
2609 2020-10-25 Tulare 107 Tipton: 93272 101   -119.310278 36.059167
2610 2020-10-25 Tulare 107 Traver: 93631 87   -119.533971 36.49031
2611 2020-10-25 Tulare 107 Traver: 93646 4   -119.301801 36.631989
2612 2020-10-25 Tulare 107 Tulare: 93274 2825   -119.344294 36.206855
2613 2020-10-25 Tulare 107 Visalia: 93277 1447   -119.383103 36.303352
2614 2020-10-25 Tulare 107 Visalia: 93291 2144   -119.394714 36.369601
2615 2020-10-25 Tulare 107 Visalia: 93292 1207   -119.255323 36.32768
2616 2020-10-25 Tulare 107 Woodlake: 93286 307   -119.096931 36.413681
3189 2020-10-24 Tulare 107 Alpaugh: 93201 28   -119.49352 35.889586
3190 2020-10-24 Tulare 107 Corcoran, Angiola: 93212 5   -119.496497 36.04429
3191 2020-10-24 Tulare 107 Cutler: 93615 372   -119.286666 36.510523
3192 2020-10-24 Tulare 107 Dinuba: 93618 1892   -119.394955 36.517096
3193 2020-10-24 Tulare 107 Earlimart: 93219 708   -119.27 35.8825
3194 2020-10-24 Tulare 107 Exeter: 93221 359   -119.067431 36.325222
3195 2020-10-24 Tulare 107 Farmersville: 93223 524   -119.2077 36.297669
3196 2020-10-24 Tulare 107 Goshen: 93227 45   -119.419358 36.349117
3197 2020-10-24 Tulare 107 Ivanhoe: 93235 185   -119.224883 36.399684
3198 2020-10-24 Tulare 107 Lindsay: 93247 693   -119.078949 36.210707
3199 2020-10-24 Tulare 107 Mountain: 93265 51   -118.76204 36.150892
3200 2020-10-24 Tulare 107 Orosi: 93647 648   -119.162323 36.590272
3201 2020-10-24 Tulare 107 Orosi: 93654 14   -119.394714 36.64647
3202 2020-10-24 Tulare 107 Pixley: 93256 312   -119.290833 35.970278
3203 2020-10-24 Tulare 107 Porterville: 93257 2903   -119.007909 36.064283
3204 2020-10-24 Tulare 107 Richgrove: 93215 140   -119.106667 35.796667
3205 2020-10-24 Tulare 107 Strathmore: 93267 250   -119.059692 36.14489
3206 2020-10-24 Tulare 107 Terra Bella: 93270 182   -119.040833 35.961389
3207 2020-10-24 Tulare 107 Tipton: 93272 100   -119.310278 36.059167
3208 2020-10-24 Tulare 107 Traver: 93631 87   -119.533971 36.49031
3209 2020-10-24 Tulare 107 Traver: 93646 4   -119.301801 36.631989
3210 2020-10-24 Tulare 107 Tulare: 93274 2822   -119.344294 36.206855
3211 2020-10-24 Tulare 107 Visalia: 93277 1447   -119.383103 36.303352
3212 2020-10-24 Tulare 107 Visalia: 93291 2140   -119.394714 36.369601
3213 2020-10-24 Tulare 107 Visalia: 93292 1207   -119.255323 36.32768
3214 2020-10-24 Tulare 107 Woodlake: 93286 307   -119.096931 36.413681
4216 2020-10-23 Tulare 107 Alpaugh: 93201 28   -119.49352 35.889586
4217 2020-10-23 Tulare 107 Corcoran, Angiola: 93212 5   -119.496497 36.04429
4218 2020-10-23 Tulare 107 Cutler: 93615 371   -119.286666 36.510523
4219 2020-10-23 Tulare 107 Dinuba: 93618 1888   -119.394955 36.517096
4220 2020-10-23 Tulare 107 Earlimart: 93219 707   -119.27 35.8825
4221 2020-10-23 Tulare 107 Exeter: 93221 357   -119.067431 36.325222
4222 2020-10-23 Tulare 107 Farmersville: 93223 523   -119.2077 36.297669
4223 2020-10-23 Tulare 107 Goshen: 93227 45   -119.419358 36.349117
4224 2020-10-23 Tulare 107 Ivanhoe: 93235 185   -119.224883 36.399684
4225 2020-10-23 Tulare 107 Lindsay: 93247 690   -119.078949 36.210707
4226 2020-10-23 Tulare 107 Mountain: 93265 51   -118.76204 36.150892
4227 2020-10-23 Tulare 107 Orosi: 93647 640   -119.162323 36.590272
4228 2020-10-23 Tulare 107 Orosi: 93654 13   -119.394714 36.64647
4229 2020-10-23 Tulare 107 Pixley: 93256 312   -119.290833 35.970278
4230 2020-10-23 Tulare 107 Porterville: 93257 2883   -119.007909 36.064283
4231 2020-10-23 Tulare 107 Richgrove: 93215 140   -119.106667 35.796667
4232 2020-10-23 Tulare 107 Strathmore: 93267 250   -119.059692 36.14489
4233 2020-10-23 Tulare 107 Terra Bella: 93270 183   -119.040833 35.961389
4234 2020-10-23 Tulare 107 Tipton: 93272 100   -119.310278 36.059167
4235 2020-10-23 Tulare 107 Traver: 93631 87   -119.533971 36.49031
4236 2020-10-23 Tulare 107 Traver: 93646 4   -119.301801 36.631989
4237 2020-10-23 Tulare 107 Tulare: 93274 2809   -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 929.648ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals