latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
559 rows where fips = 1 sorted by confirmed_cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: new_deaths, date (date)
Link | rowid | date | county | fips | confirmed_cases ▼ | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
31307 | 31307 | 2020-01-31 | Alameda | 1 | 0 | 0 | 0 | 0 |
31341 | 31341 | 2020-01-26 | Alameda | 1 | 0 | 0 | ||
31123 | 31123 | 2020-02-26 | Alameda | 1 | 1 | 0 | 0 | 0 |
31170 | 31170 | 2020-02-21 | Alameda | 1 | 1 | 0 | 0 | 0 |
31192 | 31192 | 2020-02-20 | Alameda | 1 | 1 | 0 | 0 | 0 |
31282 | 31282 | 2020-02-02 | Alameda | 1 | 1 | 0 | 1 | 0 |
30925 | 30925 | 2020-03-06 | Alameda | 1 | 3 | 0 | 0 | 0 |
30949 | 30949 | 2020-03-05 | Alameda | 1 | 3 | 0 | 0 | 0 |
30973 | 30973 | 2020-03-04 | Alameda | 1 | 3 | 0 | 0 | 0 |
30997 | 30997 | 2020-03-03 | Alameda | 1 | 3 | 0 | 0 | 0 |
31021 | 31021 | 2020-03-02 | Alameda | 1 | 3 | 0 | 0 | 0 |
31045 | 31045 | 2020-03-01 | Alameda | 1 | 3 | 0 | 0 | 0 |
31069 | 31069 | 2020-02-29 | Alameda | 1 | 3 | 0 | 0 | 0 |
31092 | 31092 | 2020-02-28 | Alameda | 1 | 3 | 0 | 2 | 0 |
30875 | 30875 | 2020-03-08 | Alameda | 1 | 4 | 0 | 0 | 0 |
30900 | 30900 | 2020-03-07 | Alameda | 1 | 4 | 0 | 1 | 0 |
30825 | 30825 | 2020-03-10 | Alameda | 1 | 5 | 0 | 0 | 0 |
30850 | 30850 | 2020-03-09 | Alameda | 1 | 5 | 0 | 1 | 0 |
30798 | 30798 | 2020-03-11 | Alameda | 1 | 12 | 0 | 7 | 0 |
30771 | 30771 | 2020-03-12 | Alameda | 1 | 13 | 0 | 1 | 0 |
30743 | 30743 | 2020-03-13 | Alameda | 1 | 16 | 0 | 3 | 0 |
30714 | 30714 | 2020-03-14 | Alameda | 1 | 24 | 0 | 8 | 0 |
30651 | 30651 | 2020-03-16 | Alameda | 1 | 34 | 0 | 0 | 0 |
30683 | 30683 | 2020-03-15 | Alameda | 1 | 34 | 0 | 10 | 0 |
30617 | 30617 | 2020-03-17 | Alameda | 1 | 46 | 0 | 12 | 0 |
30582 | 30582 | 2020-03-18 | Alameda | 1 | 55 | 0 | 9 | 0 |
30547 | 30547 | 2020-03-19 | Alameda | 1 | 67 | 3 | 12 | 3 |
30511 | 30511 | 2020-03-20 | Alameda | 1 | 76 | 4 | 9 | 1 |
30471 | 30471 | 2020-03-21 | Alameda | 1 | 97 | 6 | 21 | 2 |
30429 | 30429 | 2020-03-22 | Alameda | 1 | 113 | 7 | 16 | 1 |
30387 | 30387 | 2020-03-23 | Alameda | 1 | 140 | 8 | 27 | 1 |
30345 | 30345 | 2020-03-24 | Alameda | 1 | 164 | 10 | 24 | 2 |
30301 | 30301 | 2020-03-25 | Alameda | 1 | 186 | 15 | 22 | 5 |
30257 | 30257 | 2020-03-26 | Alameda | 1 | 224 | 16 | 38 | 1 |
30210 | 30210 | 2020-03-27 | Alameda | 1 | 262 | 19 | 38 | 3 |
30163 | 30163 | 2020-03-28 | Alameda | 1 | 298 | 19 | 36 | 0 |
30116 | 30116 | 2020-03-29 | Alameda | 1 | 315 | 21 | 17 | 2 |
30067 | 30067 | 2020-03-30 | Alameda | 1 | 324 | 25 | 9 | 4 |
30017 | 30017 | 2020-03-31 | Alameda | 1 | 373 | 28 | 49 | 3 |
29966 | 29966 | 2020-04-01 | Alameda | 1 | 415 | 31 | 42 | 3 |
29914 | 29914 | 2020-04-02 | Alameda | 1 | 458 | 39 | 43 | 8 |
29862 | 29862 | 2020-04-03 | Alameda | 1 | 509 | 47 | 51 | 8 |
29810 | 29810 | 2020-04-04 | Alameda | 1 | 581 | 48 | 72 | 1 |
29757 | 29757 | 2020-04-05 | Alameda | 1 | 611 | 50 | 30 | 2 |
29704 | 29704 | 2020-04-06 | Alameda | 1 | 640 | 51 | 29 | 1 |
29651 | 29651 | 2020-04-07 | Alameda | 1 | 683 | 51 | 43 | 0 |
29598 | 29598 | 2020-04-08 | Alameda | 1 | 712 | 55 | 29 | 4 |
29545 | 29545 | 2020-04-09 | Alameda | 1 | 752 | 59 | 40 | 4 |
29492 | 29492 | 2020-04-10 | Alameda | 1 | 810 | 60 | 58 | 1 |
29439 | 29439 | 2020-04-11 | Alameda | 1 | 840 | 63 | 30 | 3 |
29386 | 29386 | 2020-04-12 | Alameda | 1 | 887 | 68 | 47 | 5 |
29333 | 29333 | 2020-04-13 | Alameda | 1 | 939 | 71 | 52 | 3 |
29280 | 29280 | 2020-04-14 | Alameda | 1 | 970 | 73 | 31 | 2 |
29227 | 29227 | 2020-04-15 | Alameda | 1 | 999 | 74 | 29 | 1 |
29174 | 29174 | 2020-04-16 | Alameda | 1 | 1078 | 76 | 79 | 2 |
29121 | 29121 | 2020-04-17 | Alameda | 1 | 1117 | 79 | 39 | 3 |
29068 | 29068 | 2020-04-18 | Alameda | 1 | 1171 | 81 | 54 | 2 |
29015 | 29015 | 2020-04-19 | Alameda | 1 | 1226 | 83 | 55 | 2 |
28962 | 28962 | 2020-04-20 | Alameda | 1 | 1259 | 84 | 33 | 1 |
28909 | 28909 | 2020-04-21 | Alameda | 1 | 1301 | 84 | 42 | 0 |
28856 | 28856 | 2020-04-22 | Alameda | 1 | 1340 | 84 | 39 | 0 |
28803 | 28803 | 2020-04-23 | Alameda | 1 | 1381 | 88 | 41 | 4 |
28750 | 28750 | 2020-04-24 | Alameda | 1 | 1433 | 91 | 52 | 3 |
28697 | 28697 | 2020-04-25 | Alameda | 1 | 1458 | 91 | 25 | 0 |
28644 | 28644 | 2020-04-26 | Alameda | 1 | 1488 | 92 | 30 | 1 |
28591 | 28591 | 2020-04-27 | Alameda | 1 | 1525 | 94 | 37 | 2 |
28537 | 28537 | 2020-04-28 | Alameda | 1 | 1552 | 94 | 27 | 0 |
28479 | 28479 | 2020-04-29 | Alameda | 1 | 1582 | 94 | 30 | 0 |
28421 | 28421 | 2020-04-30 | Alameda | 1 | 1617 | 96 | 35 | 2 |
28363 | 28363 | 2020-05-01 | Alameda | 1 | 1658 | 98 | 41 | 2 |
28305 | 28305 | 2020-05-02 | Alameda | 1 | 1722 | 98 | 64 | 0 |
28247 | 28247 | 2020-05-03 | Alameda | 1 | 1768 | 99 | 46 | 1 |
28189 | 28189 | 2020-05-04 | Alameda | 1 | 1792 | 101 | 24 | 2 |
28131 | 28131 | 2020-05-05 | Alameda | 1 | 1828 | 103 | 36 | 2 |
28073 | 28073 | 2020-05-06 | Alameda | 1 | 1874 | 103 | 46 | 0 |
28015 | 28015 | 2020-05-07 | Alameda | 1 | 1930 | 104 | 56 | 1 |
27957 | 27957 | 2020-05-08 | Alameda | 1 | 1975 | 104 | 45 | 0 |
27899 | 27899 | 2020-05-09 | Alameda | 1 | 2039 | 105 | 64 | 1 |
27841 | 27841 | 2020-05-10 | Alameda | 1 | 2072 | 106 | 33 | 1 |
27783 | 27783 | 2020-05-11 | Alameda | 1 | 2106 | 109 | 34 | 3 |
27725 | 27725 | 2020-05-12 | Alameda | 1 | 2138 | 110 | 32 | 1 |
27667 | 27667 | 2020-05-13 | Alameda | 1 | 2178 | 111 | 40 | 1 |
27609 | 27609 | 2020-05-14 | Alameda | 1 | 2243 | 112 | 65 | 1 |
27551 | 27551 | 2020-05-15 | Alameda | 1 | 2299 | 112 | 56 | 0 |
27493 | 27493 | 2020-05-16 | Alameda | 1 | 2361 | 114 | 62 | 2 |
27435 | 27435 | 2020-05-17 | Alameda | 1 | 2416 | 114 | 55 | 0 |
27377 | 27377 | 2020-05-18 | Alameda | 1 | 2453 | 117 | 37 | 3 |
27319 | 27319 | 2020-05-19 | Alameda | 1 | 2514 | 119 | 61 | 2 |
27261 | 27261 | 2020-05-20 | Alameda | 1 | 2564 | 120 | 50 | 1 |
27203 | 27203 | 2020-05-21 | Alameda | 1 | 2639 | 120 | 75 | 0 |
27145 | 27145 | 2020-05-22 | Alameda | 1 | 2722 | 120 | 83 | 0 |
27087 | 27087 | 2020-05-23 | Alameda | 1 | 2796 | 121 | 74 | 1 |
27029 | 27029 | 2020-05-24 | Alameda | 1 | 2860 | 122 | 64 | 1 |
26971 | 26971 | 2020-05-25 | Alameda | 1 | 2931 | 122 | 71 | 0 |
26913 | 26913 | 2020-05-26 | Alameda | 1 | 2992 | 123 | 61 | 1 |
26855 | 26855 | 2020-05-27 | Alameda | 1 | 3050 | 123 | 58 | 0 |
26797 | 26797 | 2020-05-28 | Alameda | 1 | 3104 | 125 | 54 | 2 |
26739 | 26739 | 2020-05-29 | Alameda | 1 | 3215 | 127 | 111 | 2 |
26681 | 26681 | 2020-05-30 | Alameda | 1 | 3323 | 129 | 108 | 2 |
26623 | 26623 | 2020-05-31 | Alameda | 1 | 3429 | 129 | 106 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_county_totals] ( [date] TEXT, [county] TEXT, [fips] INTEGER, [confirmed_cases] INTEGER, [deaths] INTEGER, [new_confirmed_cases] INTEGER, [new_deaths] INTEGER );