latimes_county_totals

Table actions
⚠️ 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_county_totals

559 rows where fips = 97 sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: new_deaths, date (date)

fips 1

  • 97 · 559 ✖

county 1

Link rowid date ▲ county fips confirmed_cases deaths new_confirmed_cases new_deaths
49 49 2021-09-02 Sonoma 97 37055 356 249 0
107 107 2021-09-01 Sonoma 97 36806 356 291 3
165 165 2021-08-31 Sonoma 97 36515 353 17 0
223 223 2021-08-30 Sonoma 97 36498 353 0 0
281 281 2021-08-29 Sonoma 97 36498 353 0 0
339 339 2021-08-28 Sonoma 97 36498 353 340 4
397 397 2021-08-27 Sonoma 97 36158 349 0 0
455 455 2021-08-26 Sonoma 97 36158 349 342 2
513 513 2021-08-25 Sonoma 97 35816 347 152 3
571 571 2021-08-24 Sonoma 97 35664 344 0 0
629 629 2021-08-23 Sonoma 97 35664 344 102 0
687 687 2021-08-22 Sonoma 97 35562 344 4 0
745 745 2021-08-21 Sonoma 97 35558 344 348 0
803 803 2021-08-20 Sonoma 97 35210 344 0 0
861 861 2021-08-19 Sonoma 97 35210 344 117 0
919 919 2021-08-18 Sonoma 97 35093 344 101 4
977 977 2021-08-17 Sonoma 97 34992 340 153 2
1035 1035 2021-08-16 Sonoma 97 34839 338 153 0
1093 1093 2021-08-15 Sonoma 97 34686 338 0 0
1151 1151 2021-08-14 Sonoma 97 34686 338 292 1
1209 1209 2021-08-13 Sonoma 97 34394 337 0 0
1267 1267 2021-08-12 Sonoma 97 34394 337 98 0
1325 1325 2021-08-11 Sonoma 97 34296 337 273 0
1383 1383 2021-08-10 Sonoma 97 34023 337 0 0
1441 1441 2021-08-09 Sonoma 97 34023 337 270 3
1499 1499 2021-08-08 Sonoma 97 33753 334 134 0
1557 1557 2021-08-07 Sonoma 97 33619 334 55 0
1615 1615 2021-08-06 Sonoma 97 33564 334 0 0
1673 1673 2021-08-05 Sonoma 97 33564 334 150 3
1731 1731 2021-08-04 Sonoma 97 33414 331 447 0
1789 1789 2021-08-03 Sonoma 97 32967 331 87 1
1847 1847 2021-08-02 Sonoma 97 32880 330 0 0
1905 1905 2021-08-01 Sonoma 97 32880 330 63 0
1963 1963 2021-07-31 Sonoma 97 32817 330 152 0
2021 2021 2021-07-30 Sonoma 97 32665 330 0 0
2079 2079 2021-07-29 Sonoma 97 32665 330 139 1
2137 2137 2021-07-28 Sonoma 97 32526 329 201 0
2195 2195 2021-07-27 Sonoma 97 32325 329 0 0
2253 2253 2021-07-26 Sonoma 97 32325 329 129 0
2311 2311 2021-07-25 Sonoma 97 32196 329 72 1
2369 2369 2021-07-24 Sonoma 97 32124 328 159 0
2427 2427 2021-07-23 Sonoma 97 31965 328 60 0
2485 2485 2021-07-22 Sonoma 97 31905 328 30 1
2543 2543 2021-07-21 Sonoma 97 31875 327 92 0
2601 2601 2021-07-20 Sonoma 97 31783 327 20 0
2659 2659 2021-07-19 Sonoma 97 31763 327 0 0
2717 2717 2021-07-18 Sonoma 97 31763 327 60 0
2775 2775 2021-07-17 Sonoma 97 31703 327 0 0
2833 2833 2021-07-16 Sonoma 97 31703 327 62 4
2891 2891 2021-07-15 Sonoma 97 31641 323 94 0
2949 2949 2021-07-14 Sonoma 97 31547 323 112 0
3007 3007 2021-07-13 Sonoma 97 31435 323 0 0
3065 3065 2021-07-12 Sonoma 97 31435 323 0 0
3123 3123 2021-07-11 Sonoma 97 31435 323 61 0
3181 3181 2021-07-10 Sonoma 97 31374 323 67 4
3239 3239 2021-07-09 Sonoma 97 31307 319 37 0
3297 3297 2021-07-08 Sonoma 97 31270 319 110 1
3355 3355 2021-07-07 Sonoma 97 31160 318 0 0
3413 3413 2021-07-06 Sonoma 97 31160 318 0 0
3471 3471 2021-07-05 Sonoma 97 31160 318 44 0
3529 3529 2021-07-04 Sonoma 97 31116 318 0 0
3587 3587 2021-07-03 Sonoma 97 31116 318 26 0
3645 3645 2021-07-02 Sonoma 97 31090 318 64 0
3703 3703 2021-07-01 Sonoma 97 31026 318 0 0
3761 3761 2021-06-30 Sonoma 97 31026 318 85 1
3819 3819 2021-06-29 Sonoma 97 30941 317 0 0
3877 3877 2021-06-28 Sonoma 97 30941 317 0 0
3935 3935 2021-06-27 Sonoma 97 30941 317 0 0
3993 3993 2021-06-26 Sonoma 97 30941 317 0 0
4051 4051 2021-06-25 Sonoma 97 30941 317 0 0
4109 4109 2021-06-24 Sonoma 97 30941 317 0 0
4167 4167 2021-06-23 Sonoma 97 30941 317 0 0
4225 4225 2021-06-22 Sonoma 97 30941 317 73 0
4283 4283 2021-06-21 Sonoma 97 30868 317 0 0
4341 4341 2021-06-20 Sonoma 97 30868 317 24 1
4399 4399 2021-06-19 Sonoma 97 30844 316 19 0
4457 4457 2021-06-18 Sonoma 97 30825 316 0 0
4515 4515 2021-06-17 Sonoma 97 30825 316 42 0
4573 4573 2021-06-16 Sonoma 97 30783 316 95 0
4631 4631 2021-06-15 Sonoma 97 30688 316 0 0
4689 4689 2021-06-14 Sonoma 97 30688 316 0 0
4747 4747 2021-06-13 Sonoma 97 30688 316 0 0
4805 4805 2021-06-12 Sonoma 97 30688 316 29 0
4863 4863 2021-06-11 Sonoma 97 30659 316 73 0
4921 4921 2021-06-10 Sonoma 97 30586 316 0 0
4979 4979 2021-06-09 Sonoma 97 30586 316 17 0
5037 5037 2021-06-08 Sonoma 97 30569 316 76 1
5095 5095 2021-06-07 Sonoma 97 30493 315 0 0
5153 5153 2021-06-06 Sonoma 97 30493 315 39 0
5211 5211 2021-06-05 Sonoma 97 30454 315 0 0
5269 5269 2021-06-04 Sonoma 97 30454 315 32 0
5327 5327 2021-06-03 Sonoma 97 30422 315 29 0
5385 5385 2021-06-02 Sonoma 97 30393 315 57 0
5443 5443 2021-06-01 Sonoma 97 30336 315 0 0
5501 5501 2021-05-31 Sonoma 97 30336 315 0 0
5559 5559 2021-05-30 Sonoma 97 30336 315 38 0
5617 5617 2021-05-29 Sonoma 97 30298 315 29 0
5675 5675 2021-05-28 Sonoma 97 30269 315 12 0
5733 5733 2021-05-27 Sonoma 97 30257 315 0 0
5791 5791 2021-05-26 Sonoma 97 30257 315 87 0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [latimes_county_totals] (
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [confirmed_cases] INTEGER,
   [deaths] INTEGER,
   [new_confirmed_cases] INTEGER,
   [new_deaths] INTEGER
);