latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
530 rows where county = "Napa" and fips = 55 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: did_not_update, date (date)
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
31 | 31 | Napa | Napa | 55 | 2021-09-02 | 11706 | 91 | |
92 | 92 | Napa | Napa | 55 | 2021-09-01 | 11674 | 91 | |
153 | 153 | Napa | Napa | 55 | 2021-08-31 | 11626 | 87 | |
214 | 214 | Napa | Napa | 55 | 2021-08-30 | 11604 | 86 | |
275 | 275 | Napa | Napa | 55 | 2021-08-29 | 11487 | 86 | TRUE |
336 | 336 | Napa | Napa | 55 | 2021-08-28 | 11487 | 86 | TRUE |
397 | 397 | Napa | Napa | 55 | 2021-08-27 | 11487 | 86 | |
458 | 458 | Napa | Napa | 55 | 2021-08-26 | 11405 | 85 | |
519 | 519 | Napa | Napa | 55 | 2021-08-25 | 11358 | 85 | |
580 | 580 | Napa | Napa | 55 | 2021-08-24 | 11327 | 85 | |
641 | 641 | Napa | Napa | 55 | 2021-08-23 | 11279 | 85 | |
702 | 702 | Napa | Napa | 55 | 2021-08-22 | 11169 | 84 | TRUE |
763 | 763 | Napa | Napa | 55 | 2021-08-21 | 11169 | 84 | TRUE |
824 | 824 | Napa | Napa | 55 | 2021-08-20 | 11169 | 84 | |
885 | 885 | Napa | Napa | 55 | 2021-08-19 | 11120 | 82 | |
946 | 946 | Napa | Napa | 55 | 2021-08-18 | 11080 | 82 | |
1007 | 1007 | Napa | Napa | 55 | 2021-08-17 | 11021 | 82 | |
1068 | 1068 | Napa | Napa | 55 | 2021-08-16 | 10842 | 81 | TRUE |
1129 | 1129 | Napa | Napa | 55 | 2021-08-15 | 10842 | 81 | TRUE |
1190 | 1190 | Napa | Napa | 55 | 2021-08-14 | 10842 | 81 | TRUE |
1251 | 1251 | Napa | Napa | 55 | 2021-08-13 | 10842 | 81 | |
1312 | 1312 | Napa | Napa | 55 | 2021-08-12 | 10796 | 81 | |
1373 | 1373 | Napa | Napa | 55 | 2021-08-11 | 10755 | 81 | |
1434 | 1434 | Napa | Napa | 55 | 2021-08-10 | 10723 | 81 | |
1495 | 1495 | Napa | Napa | 55 | 2021-08-09 | 10698 | 81 | |
1556 | 1556 | Napa | Napa | 55 | 2021-08-08 | 10640 | 81 | TRUE |
1617 | 1617 | Napa | Napa | 55 | 2021-08-07 | 10640 | 81 | TRUE |
1678 | 1678 | Napa | Napa | 55 | 2021-08-06 | 10640 | 81 | |
1739 | 1739 | Napa | Napa | 55 | 2021-08-05 | 10607 | 81 | |
1800 | 1800 | Napa | Napa | 55 | 2021-08-04 | 10562 | 81 | |
1861 | 1861 | Napa | Napa | 55 | 2021-08-03 | 10552 | 81 | |
1922 | 1922 | Napa | Napa | 55 | 2021-08-02 | 10503 | 81 | |
1983 | 1983 | Napa | Napa | 55 | 2021-08-01 | 10442 | 81 | TRUE |
2044 | 2044 | Napa | Napa | 55 | 2021-07-31 | 10442 | 81 | TRUE |
2105 | 2105 | Napa | Napa | 55 | 2021-07-30 | 10442 | 81 | |
2166 | 2166 | Napa | Napa | 55 | 2021-07-29 | 10420 | 81 | |
2227 | 2227 | Napa | Napa | 55 | 2021-07-28 | 10400 | 81 | |
2288 | 2288 | Napa | Napa | 55 | 2021-07-27 | 10370 | 81 | |
2349 | 2349 | Napa | Napa | 55 | 2021-07-26 | 10346 | 81 | |
2410 | 2410 | Napa | Napa | 55 | 2021-07-25 | 10293 | 81 | TRUE |
2471 | 2471 | Napa | Napa | 55 | 2021-07-24 | 10293 | 81 | TRUE |
2532 | 2532 | Napa | Napa | 55 | 2021-07-23 | 10293 | 81 | |
2593 | 2593 | Napa | Napa | 55 | 2021-07-22 | 10252 | 81 | |
2654 | 2654 | Napa | Napa | 55 | 2021-07-21 | 10231 | 80 | |
2715 | 2715 | Napa | Napa | 55 | 2021-07-20 | 10213 | 80 | |
2776 | 2776 | Napa | Napa | 55 | 2021-07-19 | 10205 | 80 | |
2837 | 2837 | Napa | Napa | 55 | 2021-07-18 | 10159 | 80 | TRUE |
2898 | 2898 | Napa | Napa | 55 | 2021-07-17 | 10159 | 80 | TRUE |
2959 | 2959 | Napa | Napa | 55 | 2021-07-16 | 10159 | 80 | |
3020 | 3020 | Napa | Napa | 55 | 2021-07-15 | 10150 | 80 | |
3081 | 3081 | Napa | Napa | 55 | 2021-07-14 | 10146 | 80 | |
3142 | 3142 | Napa | Napa | 55 | 2021-07-13 | 10143 | 80 | |
3203 | 3203 | Napa | Napa | 55 | 2021-07-12 | 10130 | 80 | |
3264 | 3264 | Napa | Napa | 55 | 2021-07-11 | 10117 | 80 | TRUE |
3325 | 3325 | Napa | Napa | 55 | 2021-07-10 | 10117 | 80 | TRUE |
3386 | 3386 | Napa | Napa | 55 | 2021-07-09 | 10117 | 80 | |
3447 | 3447 | Napa | Napa | 55 | 2021-07-08 | 10097 | 80 | |
3508 | 3508 | Napa | Napa | 55 | 2021-07-07 | 10093 | 80 | |
3569 | 3569 | Napa | Napa | 55 | 2021-07-06 | 10076 | 80 | |
3630 | 3630 | Napa | Napa | 55 | 2021-07-05 | 10060 | 80 | TRUE |
3691 | 3691 | Napa | Napa | 55 | 2021-07-04 | 10060 | 80 | TRUE |
3752 | 3752 | Napa | Napa | 55 | 2021-07-03 | 10060 | 80 | |
3813 | 3813 | Napa | Napa | 55 | 2021-07-02 | 10060 | 80 | |
3874 | 3874 | Napa | Napa | 55 | 2021-07-01 | 10050 | 80 | |
3935 | 3935 | Napa | Napa | 55 | 2021-06-30 | 10044 | 80 | |
3996 | 3996 | Napa | Napa | 55 | 2021-06-29 | 10039 | 80 | TRUE |
4057 | 4057 | Napa | Napa | 55 | 2021-06-28 | 10039 | 80 | |
4118 | 4118 | Napa | Napa | 55 | 2021-06-27 | 10027 | 80 | TRUE |
4179 | 4179 | Napa | Napa | 55 | 2021-06-26 | 10027 | 80 | TRUE |
4240 | 4240 | Napa | Napa | 55 | 2021-06-25 | 10027 | 80 | |
4301 | 4301 | Napa | Napa | 55 | 2021-06-24 | 10025 | 80 | |
4362 | 4362 | Napa | Napa | 55 | 2021-06-23 | 10021 | 79 | |
4423 | 4423 | Napa | Napa | 55 | 2021-06-22 | 10018 | 79 | |
4484 | 4484 | Napa | Napa | 55 | 2021-06-21 | 10015 | 79 | |
4545 | 4545 | Napa | Napa | 55 | 2021-06-20 | 10009 | 79 | TRUE |
4606 | 4606 | Napa | Napa | 55 | 2021-06-19 | 10009 | 79 | TRUE |
4667 | 4667 | Napa | Napa | 55 | 2021-06-18 | 10009 | 79 | |
4728 | 4728 | Napa | Napa | 55 | 2021-06-17 | 10003 | 79 | |
4789 | 4789 | Napa | Napa | 55 | 2021-06-16 | 10001 | 79 | |
4850 | 4850 | Napa | Napa | 55 | 2021-06-15 | 9995 | 79 | |
4911 | 4911 | Napa | Napa | 55 | 2021-06-14 | 9988 | 79 | |
4972 | 4972 | Napa | Napa | 55 | 2021-06-13 | 9967 | 79 | TRUE |
5033 | 5033 | Napa | Napa | 55 | 2021-06-12 | 9967 | 79 | TRUE |
5094 | 5094 | Napa | Napa | 55 | 2021-06-11 | 9967 | 79 | |
5155 | 5155 | Napa | Napa | 55 | 2021-06-10 | 9959 | 79 | |
5216 | 5216 | Napa | Napa | 55 | 2021-06-09 | 9959 | 79 | |
5277 | 5277 | Napa | Napa | 55 | 2021-06-08 | 9951 | 79 | |
5338 | 5338 | Napa | Napa | 55 | 2021-06-07 | 9950 | 79 | |
5399 | 5399 | Napa | Napa | 55 | 2021-06-06 | 9946 | 79 | TRUE |
5460 | 5460 | Napa | Napa | 55 | 2021-06-05 | 9946 | 79 | TRUE |
5521 | 5521 | Napa | Napa | 55 | 2021-06-04 | 9946 | 79 | |
5582 | 5582 | Napa | Napa | 55 | 2021-06-03 | 9939 | 78 | |
5643 | 5643 | Napa | Napa | 55 | 2021-06-02 | 9939 | 78 | |
5704 | 5704 | Napa | Napa | 55 | 2021-06-01 | 9936 | 78 | |
5765 | 5765 | Napa | Napa | 55 | 2021-05-31 | 9929 | 78 | TRUE |
5826 | 5826 | Napa | Napa | 55 | 2021-05-30 | 9929 | 78 | |
5887 | 5887 | Napa | Napa | 55 | 2021-05-29 | 9929 | 78 | TRUE |
5948 | 5948 | Napa | Napa | 55 | 2021-05-28 | 9929 | 78 | |
6009 | 6009 | Napa | Napa | 55 | 2021-05-27 | 9926 | 78 | |
6070 | 6070 | Napa | Napa | 55 | 2021-05-26 | 9926 | 78 | TRUE |
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 );