latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
560 rows where county = "Solano" sorted by confirmed_cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | agency | county | fips | date | confirmed_cases ▼ | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
28172 | 28172 | Solano | Solano | 95 | 2020-05-29 | 517 | 22 | |
27989 | 27989 | Solano | Solano | 95 | 2020-06-01 | 546 | 22 | |
27928 | 27928 | Solano | Solano | 95 | 2020-06-02 | 547 | 22 | |
27867 | 27867 | Solano | Solano | 95 | 2020-06-03 | 559 | 22 | |
27806 | 27806 | Solano | Solano | 95 | 2020-06-04 | 565 | 22 | |
27623 | 27623 | Solano | Solano | 95 | 2020-06-07 | 566 | 23 | TRUE |
27684 | 27684 | Solano | Solano | 95 | 2020-06-06 | 566 | 23 | TRUE |
27745 | 27745 | Solano | Solano | 95 | 2020-06-05 | 566 | 23 | |
27562 | 27562 | Solano | Solano | 95 | 2020-06-08 | 590 | 23 | |
27501 | 27501 | Solano | Solano | 95 | 2020-06-09 | 610 | 23 | |
27440 | 27440 | Solano | Solano | 95 | 2020-06-10 | 617 | 23 | |
27379 | 27379 | Solano | Solano | 95 | 2020-06-11 | 643 | 23 | |
27196 | 27196 | Solano | Solano | 95 | 2020-06-14 | 657 | 23 | TRUE |
27257 | 27257 | Solano | Solano | 95 | 2020-06-13 | 657 | 23 | TRUE |
27318 | 27318 | Solano | Solano | 95 | 2020-06-12 | 657 | 23 | |
27135 | 27135 | Solano | Solano | 95 | 2020-06-15 | 685 | 23 | |
27074 | 27074 | Solano | Solano | 95 | 2020-06-16 | 687 | 23 | |
27013 | 27013 | Solano | Solano | 95 | 2020-06-17 | 792 | 23 | |
26952 | 26952 | Solano | Solano | 95 | 2020-06-18 | 811 | 23 | |
26769 | 26769 | Solano | Solano | 95 | 2020-06-21 | 860 | 23 | TRUE |
26830 | 26830 | Solano | Solano | 95 | 2020-06-20 | 860 | 23 | TRUE |
26891 | 26891 | Solano | Solano | 95 | 2020-06-19 | 860 | 23 | |
26708 | 26708 | Solano | Solano | 95 | 2020-06-22 | 933 | 23 | |
26647 | 26647 | Solano | Solano | 95 | 2020-06-23 | 1020 | 23 | |
26586 | 26586 | Solano | Solano | 95 | 2020-06-24 | 1064 | 23 | |
26525 | 26525 | Solano | Solano | 95 | 2020-06-25 | 1094 | 23 | |
26342 | 26342 | Solano | Solano | 95 | 2020-06-28 | 1118 | 23 | TRUE |
26403 | 26403 | Solano | Solano | 95 | 2020-06-27 | 1118 | 23 | TRUE |
26464 | 26464 | Solano | Solano | 95 | 2020-06-26 | 1118 | 23 | |
26281 | 26281 | Solano | Solano | 95 | 2020-06-29 | 1126 | 24 | |
26220 | 26220 | Solano | Solano | 95 | 2020-06-30 | 1288 | 24 | |
26159 | 26159 | Solano | Solano | 95 | 2020-07-01 | 1402 | 25 | |
25915 | 25915 | Solano | Solano | 95 | 2020-07-05 | 1476 | 25 | TRUE |
25976 | 25976 | Solano | Solano | 95 | 2020-07-04 | 1476 | 25 | TRUE |
26037 | 26037 | Solano | Solano | 95 | 2020-07-03 | 1476 | 25 | |
26098 | 26098 | Solano | Solano | 95 | 2020-07-02 | 1476 | 25 | |
25854 | 25854 | Solano | Solano | 95 | 2020-07-06 | 1740 | 25 | |
25793 | 25793 | Solano | Solano | 95 | 2020-07-07 | 1826 | 27 | |
25732 | 25732 | Solano | Solano | 95 | 2020-07-08 | 1922 | 27 | |
25671 | 25671 | Solano | Solano | 95 | 2020-07-09 | 1985 | 27 | |
25488 | 25488 | Solano | Solano | 95 | 2020-07-12 | 2075 | 28 | TRUE |
25549 | 25549 | Solano | Solano | 95 | 2020-07-11 | 2075 | 28 | TRUE |
25610 | 25610 | Solano | Solano | 95 | 2020-07-10 | 2075 | 28 | |
25427 | 25427 | Solano | Solano | 95 | 2020-07-13 | 2219 | 31 | |
25366 | 25366 | Solano | Solano | 95 | 2020-07-14 | 2313 | 31 | |
25305 | 25305 | Solano | Solano | 95 | 2020-07-15 | 2407 | 31 | |
25244 | 25244 | Solano | Solano | 95 | 2020-07-16 | 2483 | 31 | |
25061 | 25061 | Solano | Solano | 95 | 2020-07-19 | 2554 | 31 | TRUE |
25122 | 25122 | Solano | Solano | 95 | 2020-07-18 | 2554 | 31 | TRUE |
25183 | 25183 | Solano | Solano | 95 | 2020-07-17 | 2554 | 31 | |
25000 | 25000 | Solano | Solano | 95 | 2020-07-20 | 2759 | 34 | |
24939 | 24939 | Solano | Solano | 95 | 2020-07-21 | 2857 | 35 | |
24878 | 24878 | Solano | Solano | 95 | 2020-07-22 | 2982 | 35 | |
24817 | 24817 | Solano | Solano | 95 | 2020-07-23 | 3070 | 35 | |
24634 | 24634 | Solano | Solano | 95 | 2020-07-26 | 3129 | 35 | TRUE |
24695 | 24695 | Solano | Solano | 95 | 2020-07-25 | 3129 | 35 | TRUE |
24756 | 24756 | Solano | Solano | 95 | 2020-07-24 | 3129 | 35 | |
24573 | 24573 | Solano | Solano | 95 | 2020-07-27 | 3283 | 36 | |
24512 | 24512 | Solano | Solano | 95 | 2020-07-28 | 3388 | 36 | |
24451 | 24451 | Solano | Solano | 95 | 2020-07-29 | 3462 | 37 | |
24390 | 24390 | Solano | Solano | 95 | 2020-07-30 | 3520 | 37 | |
24207 | 24207 | Solano | Solano | 95 | 2020-08-02 | 3611 | 37 | TRUE |
24268 | 24268 | Solano | Solano | 95 | 2020-08-01 | 3611 | 37 | TRUE |
24329 | 24329 | Solano | Solano | 95 | 2020-07-31 | 3611 | 37 | |
24146 | 24146 | Solano | Solano | 95 | 2020-08-03 | 3721 | 37 | |
24085 | 24085 | Solano | Solano | 95 | 2020-08-04 | 3806 | 38 | |
24024 | 24024 | Solano | Solano | 95 | 2020-08-05 | 3884 | 38 | |
23963 | 23963 | Solano | Solano | 95 | 2020-08-06 | 3959 | 39 | |
23780 | 23780 | Solano | Solano | 95 | 2020-08-09 | 4029 | 40 | TRUE |
23841 | 23841 | Solano | Solano | 95 | 2020-08-08 | 4029 | 40 | TRUE |
23902 | 23902 | Solano | Solano | 95 | 2020-08-07 | 4029 | 40 | |
23719 | 23719 | Solano | Solano | 95 | 2020-08-10 | 4274 | 41 | |
23658 | 23658 | Solano | Solano | 95 | 2020-08-11 | 4338 | 41 | |
23597 | 23597 | Solano | Solano | 95 | 2020-08-12 | 4414 | 41 | |
23536 | 23536 | Solano | Solano | 95 | 2020-08-13 | 4534 | 41 | |
23353 | 23353 | Solano | Solano | 95 | 2020-08-16 | 4596 | 41 | TRUE |
23414 | 23414 | Solano | Solano | 95 | 2020-08-15 | 4596 | 41 | TRUE |
23475 | 23475 | Solano | Solano | 95 | 2020-08-14 | 4596 | 41 | |
23292 | 23292 | Solano | Solano | 95 | 2020-08-17 | 4767 | 41 | |
23231 | 23231 | Solano | Solano | 95 | 2020-08-18 | 4871 | 43 | |
23170 | 23170 | Solano | Solano | 95 | 2020-08-19 | 4943 | 44 | |
23109 | 23109 | Solano | Solano | 95 | 2020-08-20 | 5006 | 44 | |
22926 | 22926 | Solano | Solano | 95 | 2020-08-23 | 5048 | 44 | TRUE |
22987 | 22987 | Solano | Solano | 95 | 2020-08-22 | 5048 | 44 | TRUE |
23048 | 23048 | Solano | Solano | 95 | 2020-08-21 | 5048 | 44 | |
22865 | 22865 | Solano | Solano | 95 | 2020-08-24 | 5206 | 46 | |
22804 | 22804 | Solano | Solano | 95 | 2020-08-25 | 5231 | 46 | |
22743 | 22743 | Solano | Solano | 95 | 2020-08-26 | 5280 | 46 | |
22682 | 22682 | Solano | Solano | 95 | 2020-08-27 | 5328 | 46 | |
22499 | 22499 | Solano | Solano | 95 | 2020-08-30 | 5388 | 46 | TRUE |
22560 | 22560 | Solano | Solano | 95 | 2020-08-29 | 5388 | 46 | TRUE |
22621 | 22621 | Solano | Solano | 95 | 2020-08-28 | 5388 | 46 | |
22438 | 22438 | Solano | Solano | 95 | 2020-08-31 | 5512 | 47 | |
22377 | 22377 | Solano | Solano | 95 | 2020-09-01 | 5547 | 47 | |
22316 | 22316 | Solano | Solano | 95 | 2020-09-02 | 5588 | 47 | |
22255 | 22255 | Solano | Solano | 95 | 2020-09-03 | 5631 | 47 | |
22011 | 22011 | Solano | Solano | 95 | 2020-09-07 | 5671 | 48 | TRUE |
22072 | 22072 | Solano | Solano | 95 | 2020-09-06 | 5671 | 48 | TRUE |
22133 | 22133 | Solano | Solano | 95 | 2020-09-05 | 5671 | 48 | TRUE |
22194 | 22194 | Solano | Solano | 95 | 2020-09-04 | 5671 | 48 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_agency_totals] ( [agency] TEXT, [county] TEXT, [fips] INTEGER, [date] TEXT, [confirmed_cases] INTEGER, [deaths] INTEGER, [did_not_update] TEXT );