latimes_agency_totals
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
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
6133 | 6133 | Orange | Orange | 59 | 2021-05-25 | 255070 | 5054 | |
6194 | 6194 | Orange | Orange | 59 | 2021-05-24 | 255048 | 5052 | |
6255 | 6255 | Orange | Orange | 59 | 2021-05-23 | 255022 | 5049 | |
6316 | 6316 | Orange | Orange | 59 | 2021-05-22 | 254975 | 5047 | |
6377 | 6377 | Orange | Orange | 59 | 2021-05-21 | 254946 | 5042 | |
6438 | 6438 | Orange | Orange | 59 | 2021-05-20 | 254919 | 5038 | |
6499 | 6499 | Orange | Orange | 59 | 2021-05-19 | 254882 | 5034 | |
6560 | 6560 | Orange | Orange | 59 | 2021-05-18 | 254831 | 5031 | |
6621 | 6621 | Orange | Orange | 59 | 2021-05-17 | 254783 | 5031 | |
6682 | 6682 | Orange | Orange | 59 | 2021-05-16 | 254744 | 5031 | |
6743 | 6743 | Orange | Orange | 59 | 2021-05-15 | 254692 | 5030 | |
6804 | 6804 | Orange | Orange | 59 | 2021-05-14 | 254637 | 5028 | |
6865 | 6865 | Orange | Orange | 59 | 2021-05-13 | 254492 | 5026 | |
6926 | 6926 | Orange | Orange | 59 | 2021-05-12 | 254457 | 5023 | |
6987 | 6987 | Orange | Orange | 59 | 2021-05-11 | 254415 | 5017 | |
7048 | 7048 | Orange | Orange | 59 | 2021-05-10 | 254357 | 5008 | |
7109 | 7109 | Orange | Orange | 59 | 2021-05-09 | 254311 | 5008 | |
7170 | 7170 | Orange | Orange | 59 | 2021-05-08 | 254278 | 5005 | |
7231 | 7231 | Orange | Orange | 59 | 2021-05-07 | 254231 | 5000 | |
7292 | 7292 | Orange | Orange | 59 | 2021-05-06 | 254201 | 4992 | |
7353 | 7353 | Orange | Orange | 59 | 2021-05-05 | 254163 | 4979 | |
7414 | 7414 | Orange | Orange | 59 | 2021-05-04 | 254116 | 4978 | |
7475 | 7475 | Orange | Orange | 59 | 2021-05-03 | 254044 | 4969 | |
7536 | 7536 | Orange | Orange | 59 | 2021-05-02 | 253989 | 4969 | |
7597 | 7597 | Orange | Orange | 59 | 2021-05-01 | 253914 | 4965 | |
7658 | 7658 | Orange | Orange | 59 | 2021-04-30 | 253848 | 4957 | |
7719 | 7719 | Orange | Orange | 59 | 2021-04-29 | 253780 | 4948 | |
7780 | 7780 | Orange | Orange | 59 | 2021-04-28 | 253737 | 4944 | |
7841 | 7841 | Orange | Orange | 59 | 2021-04-27 | 253664 | 4939 | |
7902 | 7902 | Orange | Orange | 59 | 2021-04-26 | 253574 | 4933 | |
7963 | 7963 | Orange | Orange | 59 | 2021-04-25 | 253494 | 4933 | |
8024 | 8024 | Orange | Orange | 59 | 2021-04-24 | 253425 | 4924 | |
8085 | 8085 | Orange | Orange | 59 | 2021-04-23 | 253340 | 4918 | |
8146 | 8146 | Orange | Orange | 59 | 2021-04-22 | 253275 | 4910 | |
8207 | 8207 | Orange | Orange | 59 | 2021-04-21 | 253206 | 4902 | |
8268 | 8268 | Orange | Orange | 59 | 2021-04-20 | 253153 | 4900 | |
8329 | 8329 | Orange | Orange | 59 | 2021-04-19 | 253026 | 4896 | |
8390 | 8390 | Orange | Orange | 59 | 2021-04-18 | 252963 | 4896 | |
8451 | 8451 | Orange | Orange | 59 | 2021-04-17 | 252884 | 4891 | |
8512 | 8512 | Orange | Orange | 59 | 2021-04-16 | 252804 | 4886 | |
8573 | 8573 | Orange | Orange | 59 | 2021-04-15 | 252692 | 4869 | |
8634 | 8634 | Orange | Orange | 59 | 2021-04-14 | 252627 | 4862 | |
8695 | 8695 | Orange | Orange | 59 | 2021-04-13 | 252538 | 4849 | |
8756 | 8756 | Orange | Orange | 59 | 2021-04-12 | 252436 | 4839 | |
8817 | 8817 | Orange | Orange | 59 | 2021-04-11 | 252316 | 4839 | |
8878 | 8878 | Orange | Orange | 59 | 2021-04-10 | 252120 | 4831 | |
8939 | 8939 | Orange | Orange | 59 | 2021-04-09 | 251698 | 4826 | |
9000 | 9000 | Orange | Orange | 59 | 2021-04-08 | 251611 | 4810 | |
9061 | 9061 | Orange | Orange | 59 | 2021-04-07 | 251516 | 4791 | |
9122 | 9122 | Orange | Orange | 59 | 2021-04-06 | 251441 | 4784 | |
9183 | 9183 | Orange | Orange | 59 | 2021-04-05 | 251310 | 4772 | |
9244 | 9244 | Orange | Orange | 59 | 2021-04-04 | 251102 | 4768 | TRUE |
9305 | 9305 | Orange | Orange | 59 | 2021-04-03 | 251102 | 4768 | |
9366 | 9366 | Orange | Orange | 59 | 2021-04-02 | 250854 | 4761 | |
9427 | 9427 | Orange | Orange | 59 | 2021-04-01 | 250764 | 4755 | |
9488 | 9488 | Orange | Orange | 59 | 2021-03-31 | 250683 | 4744 | |
9549 | 9549 | Orange | Orange | 59 | 2021-03-30 | 250537 | 4740 | |
9610 | 9610 | Orange | Orange | 59 | 2021-03-29 | 250431 | 4726 | |
9671 | 9671 | Orange | Orange | 59 | 2021-03-28 | 250308 | 4725 | |
9732 | 9732 | Orange | Orange | 59 | 2021-03-27 | 250189 | 4711 | |
9793 | 9793 | Orange | Orange | 59 | 2021-03-26 | 250095 | 4684 | |
9854 | 9854 | Orange | Orange | 59 | 2021-03-25 | 249939 | 4665 | |
9915 | 9915 | Orange | Orange | 59 | 2021-03-24 | 249842 | 4646 | |
9976 | 9976 | Orange | Orange | 59 | 2021-03-23 | 249760 | 4635 | |
10037 | 10037 | Orange | Orange | 59 | 2021-03-22 | 249641 | 4608 | |
10098 | 10098 | Orange | Orange | 59 | 2021-03-21 | 249539 | 4607 | |
10159 | 10159 | Orange | Orange | 59 | 2021-03-20 | 249426 | 4562 | |
10220 | 10220 | Orange | Orange | 59 | 2021-03-19 | 249308 | 4536 | |
10281 | 10281 | Orange | Orange | 59 | 2021-03-18 | 249181 | 4522 | |
10342 | 10342 | Orange | Orange | 59 | 2021-03-17 | 249067 | 4511 | |
10403 | 10403 | Orange | Orange | 59 | 2021-03-16 | 248904 | 4486 | |
10464 | 10464 | Orange | Orange | 59 | 2021-03-15 | 248881 | 4486 | |
10525 | 10525 | Orange | Orange | 59 | 2021-03-14 | 248712 | 4465 | |
10586 | 10586 | Orange | Orange | 59 | 2021-03-13 | 248561 | 4434 | |
10647 | 10647 | Orange | Orange | 59 | 2021-03-12 | 248389 | 4408 | |
10708 | 10708 | Orange | Orange | 59 | 2021-03-11 | 248217 | 4379 | |
10769 | 10769 | Orange | Orange | 59 | 2021-03-10 | 248078 | 4346 | |
10830 | 10830 | Orange | Orange | 59 | 2021-03-09 | 248022 | 4313 | |
10891 | 10891 | Orange | Orange | 59 | 2021-03-08 | 247914 | 4252 | |
10952 | 10952 | Orange | Orange | 59 | 2021-03-07 | 247751 | 4226 | |
11013 | 11013 | Orange | Orange | 59 | 2021-03-06 | 247641 | 4173 | |
11074 | 11074 | Orange | Orange | 59 | 2021-03-05 | 247372 | 4075 | |
11135 | 11135 | Orange | Orange | 59 | 2021-03-04 | 247140 | 4013 | |
11196 | 11196 | Orange | Orange | 59 | 2021-03-03 | 246980 | 3966 | |
11257 | 11257 | Orange | Orange | 59 | 2021-03-02 | 246820 | 3952 | |
11318 | 11318 | Orange | Orange | 59 | 2021-03-01 | 246634 | 3921 | |
11379 | 11379 | Orange | Orange | 59 | 2021-02-28 | 246455 | 3917 | |
11440 | 11440 | Orange | Orange | 59 | 2021-02-27 | 246264 | 3904 | |
11501 | 11501 | Orange | Orange | 59 | 2021-02-26 | 245983 | 3892 | |
11562 | 11562 | Orange | Orange | 59 | 2021-02-25 | 245634 | 3889 | |
11623 | 11623 | Orange | Orange | 59 | 2021-02-24 | 245460 | 3848 | |
11684 | 11684 | Orange | Orange | 59 | 2021-02-23 | 245135 | 3848 | |
11745 | 11745 | Orange | Orange | 59 | 2021-02-22 | 244885 | 3848 | |
11806 | 11806 | Orange | Orange | 59 | 2021-02-21 | 244632 | 3810 | |
11867 | 11867 | Orange | Orange | 59 | 2021-02-20 | 244380 | 3770 | |
11928 | 11928 | Orange | Orange | 59 | 2021-02-19 | 243989 | 3726 | |
11989 | 11989 | Orange | Orange | 59 | 2021-02-18 | 243665 | 3685 | |
12050 | 12050 | Orange | Orange | 59 | 2021-02-17 | 243329 | 3644 | |
12111 | 12111 | Orange | Orange | 59 | 2021-02-16 | 243163 | 3617 | |
12172 | 12172 | Orange | Orange | 59 | 2021-02-15 | 242505 | 3577 | 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 );