latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
541 rows where agency = "Pasadena" sorted by date
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 |
---|---|---|---|---|---|---|---|---|
32427 | 32427 | Pasadena | Los Angeles | 37 | 2020-03-11 | 1 | 0 | |
32397 | 32397 | Pasadena | Los Angeles | 37 | 2020-03-12 | 1 | 0 | |
32367 | 32367 | Pasadena | Los Angeles | 37 | 2020-03-13 | 1 | 0 | |
32335 | 32335 | Pasadena | Los Angeles | 37 | 2020-03-14 | 1 | 0 | |
32301 | 32301 | Pasadena | Los Angeles | 37 | 2020-03-15 | 1 | 0 | |
32266 | 32266 | Pasadena | Los Angeles | 37 | 2020-03-16 | 2 | 0 | |
32230 | 32230 | Pasadena | Los Angeles | 37 | 2020-03-17 | 2 | 0 | |
32192 | 32192 | Pasadena | Los Angeles | 37 | 2020-03-18 | 2 | 0 | TRUE |
32154 | 32154 | Pasadena | Los Angeles | 37 | 2020-03-19 | 2 | 0 | |
32116 | 32116 | Pasadena | Los Angeles | 37 | 2020-03-20 | 3 | 0 | |
32074 | 32074 | Pasadena | Los Angeles | 37 | 2020-03-21 | 3 | 0 | |
32029 | 32029 | Pasadena | Los Angeles | 37 | 2020-03-22 | 3 | 0 | |
31984 | 31984 | Pasadena | Los Angeles | 37 | 2020-03-23 | 6 | 0 | |
31939 | 31939 | Pasadena | Los Angeles | 37 | 2020-03-24 | 7 | 0 | |
31893 | 31893 | Pasadena | Los Angeles | 37 | 2020-03-25 | 9 | 0 | |
31846 | 31846 | Pasadena | Los Angeles | 37 | 2020-03-26 | 10 | 0 | |
31799 | 31799 | Pasadena | Los Angeles | 37 | 2020-03-27 | 10 | 0 | |
31749 | 31749 | Pasadena | Los Angeles | 37 | 2020-03-28 | 10 | 0 | |
31699 | 31699 | Pasadena | Los Angeles | 37 | 2020-03-29 | 10 | 0 | |
31648 | 31648 | Pasadena | Los Angeles | 37 | 2020-03-30 | 25 | 0 | |
31595 | 31595 | Pasadena | Los Angeles | 37 | 2020-03-31 | 33 | 0 | |
31541 | 31541 | Pasadena | Los Angeles | 37 | 2020-04-01 | 37 | 0 | |
31487 | 31487 | Pasadena | Los Angeles | 37 | 2020-04-02 | 49 | 1 | |
31432 | 31432 | Pasadena | Los Angeles | 37 | 2020-04-03 | 58 | 2 | |
31377 | 31377 | Pasadena | Los Angeles | 37 | 2020-04-04 | 58 | 2 | |
31322 | 31322 | Pasadena | Los Angeles | 37 | 2020-04-05 | 58 | 2 | |
31266 | 31266 | Pasadena | Los Angeles | 37 | 2020-04-06 | 72 | 2 | |
31210 | 31210 | Pasadena | Los Angeles | 37 | 2020-04-07 | 80 | 3 | |
31154 | 31154 | Pasadena | Los Angeles | 37 | 2020-04-08 | 94 | 4 | |
31098 | 31098 | Pasadena | Los Angeles | 37 | 2020-04-09 | 107 | 5 | |
31042 | 31042 | Pasadena | Los Angeles | 37 | 2020-04-10 | 117 | 7 | |
30986 | 30986 | Pasadena | Los Angeles | 37 | 2020-04-11 | 117 | 7 | |
30930 | 30930 | Pasadena | Los Angeles | 37 | 2020-04-12 | 117 | 7 | |
30874 | 30874 | Pasadena | Los Angeles | 37 | 2020-04-13 | 164 | 9 | |
30818 | 30818 | Pasadena | Los Angeles | 37 | 2020-04-14 | 179 | 12 | |
30762 | 30762 | Pasadena | Los Angeles | 37 | 2020-04-15 | 184 | 14 | |
30706 | 30706 | Pasadena | Los Angeles | 37 | 2020-04-16 | 198 | 16 | |
30650 | 30650 | Pasadena | Los Angeles | 37 | 2020-04-17 | 215 | 20 | |
30594 | 30594 | Pasadena | Los Angeles | 37 | 2020-04-18 | 215 | 20 | |
30538 | 30538 | Pasadena | Los Angeles | 37 | 2020-04-19 | 215 | 20 | |
30482 | 30482 | Pasadena | Los Angeles | 37 | 2020-04-20 | 215 | 20 | |
30426 | 30426 | Pasadena | Los Angeles | 37 | 2020-04-21 | 261 | 28 | |
30370 | 30370 | Pasadena | Los Angeles | 37 | 2020-04-22 | 263 | 28 | |
30314 | 30314 | Pasadena | Los Angeles | 37 | 2020-04-23 | 293 | 29 | |
30258 | 30258 | Pasadena | Los Angeles | 37 | 2020-04-24 | 299 | 29 | |
30202 | 30202 | Pasadena | Los Angeles | 37 | 2020-04-25 | 325 | 30 | |
30146 | 30146 | Pasadena | Los Angeles | 37 | 2020-04-26 | 325 | 30 | |
30090 | 30090 | Pasadena | Los Angeles | 37 | 2020-04-27 | 362 | 34 | |
30033 | 30033 | Pasadena | Los Angeles | 37 | 2020-04-28 | 383 | 36 | |
29973 | 29973 | Pasadena | Los Angeles | 37 | 2020-04-29 | 393 | 42 | |
29912 | 29912 | Pasadena | Los Angeles | 37 | 2020-04-30 | 406 | 50 | |
29851 | 29851 | Pasadena | Los Angeles | 37 | 2020-05-01 | 411 | 52 | |
29790 | 29790 | Pasadena | Los Angeles | 37 | 2020-05-02 | 417 | 54 | |
29729 | 29729 | Pasadena | Los Angeles | 37 | 2020-05-03 | 439 | 56 | |
29668 | 29668 | Pasadena | Los Angeles | 37 | 2020-05-04 | 452 | 60 | |
29607 | 29607 | Pasadena | Los Angeles | 37 | 2020-05-05 | 482 | 61 | |
29546 | 29546 | Pasadena | Los Angeles | 37 | 2020-05-06 | 501 | 63 | |
29485 | 29485 | Pasadena | Los Angeles | 37 | 2020-05-07 | 516 | 65 | |
29424 | 29424 | Pasadena | Los Angeles | 37 | 2020-05-08 | 531 | 65 | |
29363 | 29363 | Pasadena | Los Angeles | 37 | 2020-05-09 | 542 | 65 | |
29302 | 29302 | Pasadena | Los Angeles | 37 | 2020-05-10 | 551 | 65 | |
29241 | 29241 | Pasadena | Los Angeles | 37 | 2020-05-11 | 557 | 65 | |
29180 | 29180 | Pasadena | Los Angeles | 37 | 2020-05-12 | 593 | 66 | |
29119 | 29119 | Pasadena | Los Angeles | 37 | 2020-05-13 | 607 | 69 | |
29058 | 29058 | Pasadena | Los Angeles | 37 | 2020-05-14 | 662 | 69 | |
28997 | 28997 | Pasadena | Los Angeles | 37 | 2020-05-15 | 670 | 69 | |
28936 | 28936 | Pasadena | Los Angeles | 37 | 2020-05-16 | 684 | 69 | |
28875 | 28875 | Pasadena | Los Angeles | 37 | 2020-05-17 | 694 | 69 | |
28814 | 28814 | Pasadena | Los Angeles | 37 | 2020-05-18 | 702 | 71 | |
28753 | 28753 | Pasadena | Los Angeles | 37 | 2020-05-19 | 704 | 74 | |
28692 | 28692 | Pasadena | Los Angeles | 37 | 2020-05-20 | 784 | 77 | |
28631 | 28631 | Pasadena | Los Angeles | 37 | 2020-05-21 | 790 | 79 | |
28570 | 28570 | Pasadena | Los Angeles | 37 | 2020-05-22 | 805 | 79 | |
28509 | 28509 | Pasadena | Los Angeles | 37 | 2020-05-23 | 831 | 80 | |
28448 | 28448 | Pasadena | Los Angeles | 37 | 2020-05-24 | 848 | 82 | |
28387 | 28387 | Pasadena | Los Angeles | 37 | 2020-05-25 | 853 | 82 | |
28326 | 28326 | Pasadena | Los Angeles | 37 | 2020-05-26 | 883 | 82 | |
28265 | 28265 | Pasadena | Los Angeles | 37 | 2020-05-27 | 900 | 82 | |
28204 | 28204 | Pasadena | Los Angeles | 37 | 2020-05-28 | 911 | 82 | |
28143 | 28143 | Pasadena | Los Angeles | 37 | 2020-05-29 | 918 | 82 | |
28082 | 28082 | Pasadena | Los Angeles | 37 | 2020-05-30 | 923 | 83 | |
28021 | 28021 | Pasadena | Los Angeles | 37 | 2020-05-31 | 928 | 83 | |
27960 | 27960 | Pasadena | Los Angeles | 37 | 2020-06-01 | 934 | 83 | |
27899 | 27899 | Pasadena | Los Angeles | 37 | 2020-06-02 | 937 | 83 | |
27838 | 27838 | Pasadena | Los Angeles | 37 | 2020-06-03 | 943 | 83 | |
27777 | 27777 | Pasadena | Los Angeles | 37 | 2020-06-04 | 968 | 83 | |
27716 | 27716 | Pasadena | Los Angeles | 37 | 2020-06-05 | 974 | 83 | |
27655 | 27655 | Pasadena | Los Angeles | 37 | 2020-06-06 | 981 | 83 | |
27594 | 27594 | Pasadena | Los Angeles | 37 | 2020-06-07 | 987 | 84 | |
27533 | 27533 | Pasadena | Los Angeles | 37 | 2020-06-08 | 996 | 84 | |
27472 | 27472 | Pasadena | Los Angeles | 37 | 2020-06-09 | 1008 | 84 | |
27411 | 27411 | Pasadena | Los Angeles | 37 | 2020-06-10 | 1015 | 84 | |
27350 | 27350 | Pasadena | Los Angeles | 37 | 2020-06-11 | 1023 | 84 | |
27289 | 27289 | Pasadena | Los Angeles | 37 | 2020-06-12 | 1028 | 84 | |
27228 | 27228 | Pasadena | Los Angeles | 37 | 2020-06-13 | 1037 | 84 | |
27167 | 27167 | Pasadena | Los Angeles | 37 | 2020-06-14 | 1042 | 84 | |
27106 | 27106 | Pasadena | Los Angeles | 37 | 2020-06-15 | 1048 | 84 | |
27045 | 27045 | Pasadena | Los Angeles | 37 | 2020-06-16 | 1058 | 85 | |
26984 | 26984 | Pasadena | Los Angeles | 37 | 2020-06-17 | 1083 | 86 | |
26923 | 26923 | Pasadena | Los Angeles | 37 | 2020-06-18 | 1099 | 86 |
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 );