latimes_agency_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_agency_totals

586 rows where fips = 59 sorted by date descending

✎ View and edit SQL

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

Suggested facets: did_not_update, date (date)

fips 1

  • 59 · 586 ✖

county 1

agency 1

Link rowid agency county fips date ▲ confirmed_cases deaths did_not_update
33 33 Orange Orange 59 2021-09-02 286536 5236  
94 94 Orange Orange 59 2021-09-01 286099 5229  
155 155 Orange Orange 59 2021-08-31 285453 5225  
216 216 Orange Orange 59 2021-08-30 285098 5220  
277 277 Orange Orange 59 2021-08-29 283573 5202 TRUE
338 338 Orange Orange 59 2021-08-28 283573 5202 TRUE
399 399 Orange Orange 59 2021-08-27 283573 5202  
460 460 Orange Orange 59 2021-08-26 282643 5197  
521 521 Orange Orange 59 2021-08-25 282166 5190  
582 582 Orange Orange 59 2021-08-24 281609 5184  
643 643 Orange Orange 59 2021-08-23 281092 5178  
704 704 Orange Orange 59 2021-08-22 279237 5176 TRUE
765 765 Orange Orange 59 2021-08-21 279237 5176 TRUE
826 826 Orange Orange 59 2021-08-20 279237 5176  
887 887 Orange Orange 59 2021-08-19 278417 5169  
948 948 Orange Orange 59 2021-08-18 277845 5165  
1009 1009 Orange Orange 59 2021-08-17 276632 5161  
1070 1070 Orange Orange 59 2021-08-16 275964 5158  
1131 1131 Orange Orange 59 2021-08-15 273847 5156 TRUE
1192 1192 Orange Orange 59 2021-08-14 273847 5156 TRUE
1253 1253 Orange Orange 59 2021-08-13 273847 5156  
1314 1314 Orange Orange 59 2021-08-12 272914 5154  
1375 1375 Orange Orange 59 2021-08-11 272449 5152  
1436 1436 Orange Orange 59 2021-08-10 271837 5152  
1497 1497 Orange Orange 59 2021-08-09 271197 5150  
1558 1558 Orange Orange 59 2021-08-08 269016 5148 TRUE
1619 1619 Orange Orange 59 2021-08-07 269016 5148 TRUE
1680 1680 Orange Orange 59 2021-08-06 269016 5148  
1741 1741 Orange Orange 59 2021-08-05 267908 5146  
1802 1802 Orange Orange 59 2021-08-04 267131 5143  
1863 1863 Orange Orange 59 2021-08-03 267039 5143  
1924 1924 Orange Orange 59 2021-08-02 266167 5143  
1985 1985 Orange Orange 59 2021-08-01 264171 5141 TRUE
2046 2046 Orange Orange 59 2021-07-31 264171 5141 TRUE
2107 2107 Orange Orange 59 2021-07-30 264171 5141  
2168 2168 Orange Orange 59 2021-07-29 263578 5141  
2229 2229 Orange Orange 59 2021-07-28 263056 5140  
2290 2290 Orange Orange 59 2021-07-27 262524 5140  
2351 2351 Orange Orange 59 2021-07-26 262071 5139  
2412 2412 Orange Orange 59 2021-07-25 260720 5138 TRUE
2473 2473 Orange Orange 59 2021-07-24 260720 5138 TRUE
2534 2534 Orange Orange 59 2021-07-23 260720 5138  
2595 2595 Orange Orange 59 2021-07-22 260289 5138  
2656 2656 Orange Orange 59 2021-07-21 259985 5136  
2717 2717 Orange Orange 59 2021-07-20 259695 5136  
2778 2778 Orange Orange 59 2021-07-19 259380 5135  
2839 2839 Orange Orange 59 2021-07-18 257826 5133 TRUE
2900 2900 Orange Orange 59 2021-07-17 257826 5133 TRUE
2961 2961 Orange Orange 59 2021-07-16 257826 5133 TRUE
3022 3022 Orange Orange 59 2021-07-15 257826 5133  
3083 3083 Orange Orange 59 2021-07-14 257826 5133 TRUE
3144 3144 Orange Orange 59 2021-07-13 257826 5133  
3205 3205 Orange Orange 59 2021-07-12 256776 5124 TRUE
3266 3266 Orange Orange 59 2021-07-11 256776 5124 TRUE
3327 3327 Orange Orange 59 2021-07-10 256776 5124 TRUE
3388 3388 Orange Orange 59 2021-07-09 256776 5124  
3449 3449 Orange Orange 59 2021-07-08 256776 5124 TRUE
3510 3510 Orange Orange 59 2021-07-07 256776 5124 TRUE
3571 3571 Orange Orange 59 2021-07-06 256776 5124  
3632 3632 Orange Orange 59 2021-07-05 256445 5123 TRUE
3693 3693 Orange Orange 59 2021-07-04 256445 5123 TRUE
3754 3754 Orange Orange 59 2021-07-03 256445 5123 TRUE
3815 3815 Orange Orange 59 2021-07-02 256445 5123  
3876 3876 Orange Orange 59 2021-07-01 256371 5122  
3937 3937 Orange Orange 59 2021-06-30 256317 5121  
3998 3998 Orange Orange 59 2021-06-29 256266 5120  
4059 4059 Orange Orange 59 2021-06-28 256222 5118  
4120 4120 Orange Orange 59 2021-06-27 256052 5114 TRUE
4181 4181 Orange Orange 59 2021-06-26 256052 5114 TRUE
4242 4242 Orange Orange 59 2021-06-25 256052 5114  
4303 4303 Orange Orange 59 2021-06-24 256008 5112  
4364 4364 Orange Orange 59 2021-06-23 255977 5111  
4425 4425 Orange Orange 59 2021-06-22 255958 5109  
4486 4486 Orange Orange 59 2021-06-21 255922 5107  
4547 4547 Orange Orange 59 2021-06-20 255810 5103 TRUE
4608 4608 Orange Orange 59 2021-06-19 255810 5103 TRUE
4669 4669 Orange Orange 59 2021-06-18 255810 5103  
4730 4730 Orange Orange 59 2021-06-17 255771 5102  
4791 4791 Orange Orange 59 2021-06-16 255728 5101  
4852 4852 Orange Orange 59 2021-06-15 255695 5099  
4913 4913 Orange Orange 59 2021-06-14 255663 5097  
4974 4974 Orange Orange 59 2021-06-13 255588 5095 TRUE
5035 5035 Orange Orange 59 2021-06-12 255588 5095 TRUE
5096 5096 Orange Orange 59 2021-06-11 255588 5095  
5157 5157 Orange Orange 59 2021-06-10 255570 5092  
5218 5218 Orange Orange 59 2021-06-09 255530 5090  
5279 5279 Orange Orange 59 2021-06-08 255504 5088  
5340 5340 Orange Orange 59 2021-06-07 255473 5083  
5401 5401 Orange Orange 59 2021-06-06 255454 5083  
5462 5462 Orange Orange 59 2021-06-05 255413 5078  
5523 5523 Orange Orange 59 2021-06-04 255371 5073  
5584 5584 Orange Orange 59 2021-06-03 255347 5070  
5645 5645 Orange Orange 59 2021-06-02 255322 5068  
5706 5706 Orange Orange 59 2021-06-01 255291 5065  
5767 5767 Orange Orange 59 2021-05-31 255241 5065 TRUE
5828 5828 Orange Orange 59 2021-05-30 255241 5065  
5889 5889 Orange Orange 59 2021-05-29 255220 5063  
5950 5950 Orange Orange 59 2021-05-28 255164 5059  
6011 6011 Orange Orange 59 2021-05-27 255109 5056  
6072 6072 Orange Orange 59 2021-05-26 255081 5055  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [latimes_agency_totals] (
   [agency] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [date] TEXT,
   [confirmed_cases] INTEGER,
   [deaths] INTEGER,
   [did_not_update] TEXT
);