latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
532 rows where fips = 17 sorted by new_confirmed_cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed_cases, deaths, new_confirmed_cases, new_deaths, date (date)
Link | rowid | date | county | fips | confirmed_cases | deaths | new_confirmed_cases ▼ | new_deaths |
---|---|---|---|---|---|---|---|---|
241 | 241 | 2021-08-29 | El Dorado | 17 | 13011 | 122 | 0 | 0 |
299 | 299 | 2021-08-28 | El Dorado | 17 | 13011 | 122 | 0 | 0 |
647 | 647 | 2021-08-22 | El Dorado | 17 | 12545 | 122 | 0 | 0 |
705 | 705 | 2021-08-21 | El Dorado | 17 | 12545 | 122 | 0 | 0 |
1053 | 1053 | 2021-08-15 | El Dorado | 17 | 12001 | 122 | 0 | 0 |
1111 | 1111 | 2021-08-14 | El Dorado | 17 | 12001 | 122 | 0 | 0 |
1459 | 1459 | 2021-08-08 | El Dorado | 17 | 11566 | 121 | 0 | 0 |
1517 | 1517 | 2021-08-07 | El Dorado | 17 | 11566 | 121 | 0 | 0 |
1865 | 1865 | 2021-08-01 | El Dorado | 17 | 11125 | 120 | 0 | 0 |
1923 | 1923 | 2021-07-31 | El Dorado | 17 | 11125 | 120 | 0 | 0 |
2271 | 2271 | 2021-07-25 | El Dorado | 17 | 10857 | 120 | 0 | 0 |
2445 | 2445 | 2021-07-22 | El Dorado | 17 | 10774 | 120 | 0 | 0 |
2677 | 2677 | 2021-07-18 | El Dorado | 17 | 10692 | 118 | 0 | 0 |
2735 | 2735 | 2021-07-17 | El Dorado | 17 | 10692 | 118 | 0 | 0 |
2967 | 2967 | 2021-07-13 | El Dorado | 17 | 10604 | 118 | 0 | 0 |
3083 | 3083 | 2021-07-11 | El Dorado | 17 | 10558 | 118 | 0 | 0 |
3141 | 3141 | 2021-07-10 | El Dorado | 17 | 10558 | 118 | 0 | 0 |
3431 | 3431 | 2021-07-05 | El Dorado | 17 | 10479 | 117 | 0 | 0 |
3489 | 3489 | 2021-07-04 | El Dorado | 17 | 10479 | 117 | 0 | 0 |
3547 | 3547 | 2021-07-03 | El Dorado | 17 | 10479 | 117 | 0 | 0 |
3779 | 3779 | 2021-06-29 | El Dorado | 17 | 10440 | 117 | 0 | 0 |
3895 | 3895 | 2021-06-27 | El Dorado | 17 | 10428 | 117 | 0 | 0 |
3953 | 3953 | 2021-06-26 | El Dorado | 17 | 10428 | 117 | 0 | 0 |
4301 | 4301 | 2021-06-20 | El Dorado | 17 | 10371 | 116 | 0 | 0 |
4359 | 4359 | 2021-06-19 | El Dorado | 17 | 10371 | 116 | 0 | 0 |
4707 | 4707 | 2021-06-13 | El Dorado | 17 | 10339 | 116 | 0 | 0 |
4765 | 4765 | 2021-06-12 | El Dorado | 17 | 10339 | 116 | 0 | 0 |
4939 | 4939 | 2021-06-09 | El Dorado | 17 | 10329 | 115 | 0 | 0 |
5345 | 5345 | 2021-06-02 | El Dorado | 17 | 10303 | 113 | 0 | 0 |
5461 | 5461 | 2021-05-31 | El Dorado | 17 | 10296 | 113 | 0 | 0 |
5519 | 5519 | 2021-05-30 | El Dorado | 17 | 10296 | 113 | 0 | 0 |
5577 | 5577 | 2021-05-29 | El Dorado | 17 | 10296 | 113 | 0 | 0 |
5925 | 5925 | 2021-05-23 | El Dorado | 17 | 10247 | 113 | 0 | 0 |
5983 | 5983 | 2021-05-22 | El Dorado | 17 | 10247 | 113 | 0 | 0 |
6273 | 6273 | 2021-05-17 | El Dorado | 17 | 10193 | 113 | 0 | 0 |
6331 | 6331 | 2021-05-16 | El Dorado | 17 | 10193 | 113 | 0 | 0 |
6389 | 6389 | 2021-05-15 | El Dorado | 17 | 10193 | 113 | 0 | 0 |
6505 | 6505 | 2021-05-13 | El Dorado | 17 | 10168 | 112 | 0 | 0 |
6737 | 6737 | 2021-05-09 | El Dorado | 17 | 10111 | 112 | 0 | 0 |
6795 | 6795 | 2021-05-08 | El Dorado | 17 | 10111 | 112 | 0 | 0 |
7143 | 7143 | 2021-05-02 | El Dorado | 17 | 9964 | 110 | 0 | 0 |
7201 | 7201 | 2021-05-01 | El Dorado | 17 | 9964 | 110 | 0 | 0 |
7549 | 7549 | 2021-04-25 | El Dorado | 17 | 9845 | 109 | 0 | 0 |
7607 | 7607 | 2021-04-24 | El Dorado | 17 | 9845 | 109 | 0 | 0 |
7955 | 7955 | 2021-04-18 | El Dorado | 17 | 9719 | 109 | 0 | 0 |
8071 | 8071 | 2021-04-16 | El Dorado | 17 | 9688 | 109 | 0 | 0 |
8361 | 8361 | 2021-04-11 | El Dorado | 17 | 9580 | 108 | 0 | 0 |
8419 | 8419 | 2021-04-10 | El Dorado | 17 | 9580 | 108 | 0 | 0 |
8767 | 8767 | 2021-04-04 | El Dorado | 17 | 9488 | 108 | 0 | 0 |
8825 | 8825 | 2021-04-03 | El Dorado | 17 | 9488 | 108 | 0 | 0 |
9173 | 9173 | 2021-03-28 | El Dorado | 17 | 9417 | 107 | 0 | 0 |
9231 | 9231 | 2021-03-27 | El Dorado | 17 | 9417 | 107 | 0 | 0 |
9579 | 9579 | 2021-03-21 | El Dorado | 17 | 9340 | 107 | 0 | 0 |
9637 | 9637 | 2021-03-20 | El Dorado | 17 | 9340 | 107 | 0 | 0 |
9985 | 9985 | 2021-03-14 | El Dorado | 17 | 9277 | 105 | 0 | 0 |
10043 | 10043 | 2021-03-13 | El Dorado | 17 | 9277 | 105 | 0 | 0 |
10391 | 10391 | 2021-03-07 | El Dorado | 17 | 9204 | 100 | 0 | 0 |
10449 | 10449 | 2021-03-06 | El Dorado | 17 | 9204 | 100 | 0 | 0 |
10797 | 10797 | 2021-02-28 | El Dorado | 17 | 9120 | 100 | 0 | 0 |
10855 | 10855 | 2021-02-27 | El Dorado | 17 | 9120 | 100 | 0 | 0 |
11203 | 11203 | 2021-02-21 | El Dorado | 17 | 9017 | 93 | 0 | 0 |
11261 | 11261 | 2021-02-20 | El Dorado | 17 | 9017 | 93 | 0 | 0 |
11551 | 11551 | 2021-02-15 | El Dorado | 17 | 8855 | 90 | 0 | 0 |
11609 | 11609 | 2021-02-14 | El Dorado | 17 | 8855 | 90 | 0 | 0 |
11667 | 11667 | 2021-02-13 | El Dorado | 17 | 8855 | 90 | 0 | 0 |
12015 | 12015 | 2021-02-07 | El Dorado | 17 | 8647 | 86 | 0 | 0 |
12073 | 12073 | 2021-02-06 | El Dorado | 17 | 8647 | 86 | 0 | 0 |
12421 | 12421 | 2021-01-31 | El Dorado | 17 | 8359 | 79 | 0 | 0 |
12479 | 12479 | 2021-01-30 | El Dorado | 17 | 8359 | 79 | 0 | 0 |
12827 | 12827 | 2021-01-24 | El Dorado | 17 | 8002 | 59 | 0 | 0 |
12885 | 12885 | 2021-01-23 | El Dorado | 17 | 8002 | 59 | 0 | 0 |
13175 | 13175 | 2021-01-18 | El Dorado | 17 | 7515 | 44 | 0 | 0 |
13233 | 13233 | 2021-01-17 | El Dorado | 17 | 7515 | 44 | 0 | 0 |
13291 | 13291 | 2021-01-16 | El Dorado | 17 | 7515 | 44 | 0 | 0 |
13639 | 13639 | 2021-01-10 | El Dorado | 17 | 6642 | 33 | 0 | 0 |
13697 | 13697 | 2021-01-09 | El Dorado | 17 | 6642 | 33 | 0 | 0 |
14045 | 14045 | 2021-01-03 | El Dorado | 17 | 5719 | 24 | 0 | 0 |
14103 | 14103 | 2021-01-02 | El Dorado | 17 | 5719 | 24 | 0 | 0 |
14161 | 14161 | 2021-01-01 | El Dorado | 17 | 5719 | 24 | 0 | 0 |
14451 | 14451 | 2020-12-27 | El Dorado | 17 | 5095 | 13 | 0 | 0 |
14509 | 14509 | 2020-12-26 | El Dorado | 17 | 5095 | 13 | 0 | 0 |
14567 | 14567 | 2020-12-25 | El Dorado | 17 | 5095 | 13 | 0 | 0 |
14857 | 14857 | 2020-12-20 | El Dorado | 17 | 4412 | 8 | 0 | 0 |
14915 | 14915 | 2020-12-19 | El Dorado | 17 | 4412 | 8 | 0 | 0 |
14973 | 14973 | 2020-12-18 | El Dorado | 17 | 4412 | 8 | 0 | 0 |
15263 | 15263 | 2020-12-13 | El Dorado | 17 | 3754 | 8 | 0 | 0 |
15321 | 15321 | 2020-12-12 | El Dorado | 17 | 3754 | 8 | 0 | 0 |
15669 | 15669 | 2020-12-06 | El Dorado | 17 | 2822 | 8 | 0 | 0 |
15727 | 15727 | 2020-12-05 | El Dorado | 17 | 2822 | 8 | 0 | 0 |
16075 | 16075 | 2020-11-29 | El Dorado | 17 | 2315 | 4 | 0 | 0 |
16133 | 16133 | 2020-11-28 | El Dorado | 17 | 2315 | 4 | 0 | 0 |
16249 | 16249 | 2020-11-26 | El Dorado | 17 | 2130 | 4 | 0 | 0 |
16481 | 16481 | 2020-11-22 | El Dorado | 17 | 1930 | 4 | 0 | 0 |
16539 | 16539 | 2020-11-21 | El Dorado | 17 | 1930 | 4 | 0 | 0 |
16887 | 16887 | 2020-11-15 | El Dorado | 17 | 1637 | 4 | 0 | 0 |
16945 | 16945 | 2020-11-14 | El Dorado | 17 | 1637 | 4 | 0 | 0 |
17119 | 17119 | 2020-11-11 | El Dorado | 17 | 1558 | 4 | 0 | 0 |
17293 | 17293 | 2020-11-08 | El Dorado | 17 | 1487 | 4 | 0 | 0 |
17351 | 17351 | 2020-11-07 | El Dorado | 17 | 1487 | 4 | 0 | 0 |
17699 | 17699 | 2020-11-01 | El Dorado | 17 | 1388 | 4 | 0 | 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 );