ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "El Dorado" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
6150 | 6150 | 2020-03-21 | El Dorado | California | 6017 | 2 | 0 |
7184 | 7184 | 2020-03-22 | El Dorado | California | 6017 | 2 | 0 |
8327 | 8327 | 2020-03-23 | El Dorado | California | 6017 | 2 | 0 |
9568 | 9568 | 2020-03-24 | El Dorado | California | 6017 | 3 | 0 |
10939 | 10939 | 2020-03-25 | El Dorado | California | 6017 | 3 | 0 |
12484 | 12484 | 2020-03-26 | El Dorado | California | 6017 | 9 | 0 |
14149 | 14149 | 2020-03-27 | El Dorado | California | 6017 | 12 | 0 |
15930 | 15930 | 2020-03-28 | El Dorado | California | 6017 | 12 | 0 |
17819 | 17819 | 2020-03-29 | El Dorado | California | 6017 | 12 | 0 |
19796 | 19796 | 2020-03-30 | El Dorado | California | 6017 | 15 | 0 |
21870 | 21870 | 2020-03-31 | El Dorado | California | 6017 | 18 | 0 |
24028 | 24028 | 2020-04-01 | El Dorado | California | 6017 | 18 | 0 |
26257 | 26257 | 2020-04-02 | El Dorado | California | 6017 | 19 | 0 |
28556 | 28556 | 2020-04-03 | El Dorado | California | 6017 | 22 | 0 |
30914 | 30914 | 2020-04-04 | El Dorado | California | 6017 | 22 | 0 |
33320 | 33320 | 2020-04-05 | El Dorado | California | 6017 | 22 | 0 |
35764 | 35764 | 2020-04-06 | El Dorado | California | 6017 | 25 | 0 |
38253 | 38253 | 2020-04-07 | El Dorado | California | 6017 | 28 | 0 |
40797 | 40797 | 2020-04-08 | El Dorado | California | 6017 | 29 | 0 |
43369 | 43369 | 2020-04-09 | El Dorado | California | 6017 | 30 | 0 |
45969 | 45969 | 2020-04-10 | El Dorado | California | 6017 | 32 | 0 |
48599 | 48599 | 2020-04-11 | El Dorado | California | 6017 | 32 | 0 |
51261 | 51261 | 2020-04-12 | El Dorado | California | 6017 | 32 | 0 |
53940 | 53940 | 2020-04-13 | El Dorado | California | 6017 | 34 | 0 |
56632 | 56632 | 2020-04-14 | El Dorado | California | 6017 | 35 | 0 |
59340 | 59340 | 2020-04-15 | El Dorado | California | 6017 | 35 | 0 |
62059 | 62059 | 2020-04-16 | El Dorado | California | 6017 | 35 | 0 |
64792 | 64792 | 2020-04-17 | El Dorado | California | 6017 | 36 | 0 |
67540 | 67540 | 2020-04-18 | El Dorado | California | 6017 | 36 | 0 |
70302 | 70302 | 2020-04-19 | El Dorado | California | 6017 | 36 | 0 |
73071 | 73071 | 2020-04-20 | El Dorado | California | 6017 | 38 | 0 |
75847 | 75847 | 2020-04-21 | El Dorado | California | 6017 | 39 | 0 |
78631 | 78631 | 2020-04-22 | El Dorado | California | 6017 | 39 | 0 |
81425 | 81425 | 2020-04-23 | El Dorado | California | 6017 | 40 | 0 |
84225 | 84225 | 2020-04-24 | El Dorado | California | 6017 | 42 | 0 |
87033 | 87033 | 2020-04-25 | El Dorado | California | 6017 | 42 | 0 |
89850 | 89850 | 2020-04-26 | El Dorado | California | 6017 | 42 | 0 |
92668 | 92668 | 2020-04-27 | El Dorado | California | 6017 | 43 | 0 |
95499 | 95499 | 2020-04-28 | El Dorado | California | 6017 | 44 | 0 |
98344 | 98344 | 2020-04-29 | El Dorado | California | 6017 | 44 | 0 |
101194 | 101194 | 2020-04-30 | El Dorado | California | 6017 | 44 | 0 |
104049 | 104049 | 2020-05-01 | El Dorado | California | 6017 | 47 | 0 |
106914 | 106914 | 2020-05-02 | El Dorado | California | 6017 | 47 | 0 |
109783 | 109783 | 2020-05-03 | El Dorado | California | 6017 | 47 | 0 |
112658 | 112658 | 2020-05-04 | El Dorado | California | 6017 | 53 | 0 |
115541 | 115541 | 2020-05-05 | El Dorado | California | 6017 | 53 | 0 |
118500 | 118500 | 2020-05-06 | El Dorado | California | 6017 | 54 | 0 |
121467 | 121467 | 2020-05-07 | El Dorado | California | 6017 | 54 | 0 |
124447 | 124447 | 2020-05-08 | El Dorado | California | 6017 | 54 | 0 |
127432 | 127432 | 2020-05-09 | El Dorado | California | 6017 | 54 | 0 |
130422 | 130422 | 2020-05-10 | El Dorado | California | 6017 | 54 | 0 |
133412 | 133412 | 2020-05-11 | El Dorado | California | 6017 | 56 | 0 |
136402 | 136402 | 2020-05-12 | El Dorado | California | 6017 | 60 | 0 |
139393 | 139393 | 2020-05-13 | El Dorado | California | 6017 | 60 | 0 |
142389 | 142389 | 2020-05-14 | El Dorado | California | 6017 | 62 | 0 |
145388 | 145388 | 2020-05-15 | El Dorado | California | 6017 | 64 | 0 |
148392 | 148392 | 2020-05-16 | El Dorado | California | 6017 | 64 | 0 |
151401 | 151401 | 2020-05-17 | El Dorado | California | 6017 | 65 | 0 |
154413 | 154413 | 2020-05-18 | El Dorado | California | 6017 | 67 | 0 |
157429 | 157429 | 2020-05-19 | El Dorado | California | 6017 | 67 | 0 |
160455 | 160455 | 2020-05-20 | El Dorado | California | 6017 | 67 | 0 |
163483 | 163483 | 2020-05-21 | El Dorado | California | 6017 | 67 | 0 |
166515 | 166515 | 2020-05-22 | El Dorado | California | 6017 | 74 | 0 |
169551 | 169551 | 2020-05-23 | El Dorado | California | 6017 | 74 | 0 |
172592 | 172592 | 2020-05-24 | El Dorado | California | 6017 | 74 | 0 |
175636 | 175636 | 2020-05-25 | El Dorado | California | 6017 | 78 | 0 |
178680 | 178680 | 2020-05-26 | El Dorado | California | 6017 | 80 | 0 |
181724 | 181724 | 2020-05-27 | El Dorado | California | 6017 | 81 | 0 |
184778 | 184778 | 2020-05-28 | El Dorado | California | 6017 | 84 | 0 |
187834 | 187834 | 2020-05-29 | El Dorado | California | 6017 | 90 | 0 |
190899 | 190899 | 2020-05-30 | El Dorado | California | 6017 | 90 | 0 |
193966 | 193966 | 2020-05-31 | El Dorado | California | 6017 | 90 | 0 |
197036 | 197036 | 2020-06-01 | El Dorado | California | 6017 | 96 | 0 |
200109 | 200109 | 2020-06-02 | El Dorado | California | 6017 | 96 | 0 |
203185 | 203185 | 2020-06-03 | El Dorado | California | 6017 | 98 | 0 |
206265 | 206265 | 2020-06-04 | El Dorado | California | 6017 | 102 | 0 |
209346 | 209346 | 2020-06-05 | El Dorado | California | 6017 | 106 | 0 |
212431 | 212431 | 2020-06-06 | El Dorado | California | 6017 | 106 | 0 |
215518 | 215518 | 2020-06-07 | El Dorado | California | 6017 | 106 | 0 |
218609 | 218609 | 2020-06-08 | El Dorado | California | 6017 | 109 | 0 |
221704 | 221704 | 2020-06-09 | El Dorado | California | 6017 | 111 | 0 |
224799 | 224799 | 2020-06-10 | El Dorado | California | 6017 | 111 | 0 |
227901 | 227901 | 2020-06-11 | El Dorado | California | 6017 | 111 | 0 |
231004 | 231004 | 2020-06-12 | El Dorado | California | 6017 | 113 | 0 |
234110 | 234110 | 2020-06-13 | El Dorado | California | 6017 | 113 | 0 |
237217 | 237217 | 2020-06-14 | El Dorado | California | 6017 | 113 | 0 |
240325 | 240325 | 2020-06-15 | El Dorado | California | 6017 | 117 | 0 |
243436 | 243436 | 2020-06-16 | El Dorado | California | 6017 | 118 | 0 |
246549 | 246549 | 2020-06-17 | El Dorado | California | 6017 | 121 | 0 |
249661 | 249661 | 2020-06-18 | El Dorado | California | 6017 | 125 | 0 |
252776 | 252776 | 2020-06-19 | El Dorado | California | 6017 | 130 | 0 |
255895 | 255895 | 2020-06-20 | El Dorado | California | 6017 | 130 | 0 |
259022 | 259022 | 2020-06-21 | El Dorado | California | 6017 | 130 | 0 |
262149 | 262149 | 2020-06-22 | El Dorado | California | 6017 | 145 | 0 |
265277 | 265277 | 2020-06-23 | El Dorado | California | 6017 | 150 | 0 |
268407 | 268407 | 2020-06-24 | El Dorado | California | 6017 | 153 | 0 |
271542 | 271542 | 2020-06-25 | El Dorado | California | 6017 | 158 | 0 |
274682 | 274682 | 2020-06-26 | El Dorado | California | 6017 | 158 | 0 |
277830 | 277830 | 2020-06-27 | El Dorado | California | 6017 | 159 | 0 |
280977 | 280977 | 2020-06-28 | El Dorado | California | 6017 | 159 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);