ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Imperial" 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 |
---|---|---|---|---|---|---|---|
5232 | 5232 | 2020-03-20 | Imperial | California | 6025 | 4 | 0 |
6153 | 6153 | 2020-03-21 | Imperial | California | 6025 | 4 | 0 |
7187 | 7187 | 2020-03-22 | Imperial | California | 6025 | 4 | 0 |
8330 | 8330 | 2020-03-23 | Imperial | California | 6025 | 4 | 0 |
9571 | 9571 | 2020-03-24 | Imperial | California | 6025 | 9 | 0 |
10942 | 10942 | 2020-03-25 | Imperial | California | 6025 | 9 | 0 |
12487 | 12487 | 2020-03-26 | Imperial | California | 6025 | 17 | 0 |
14152 | 14152 | 2020-03-27 | Imperial | California | 6025 | 21 | 0 |
15934 | 15934 | 2020-03-28 | Imperial | California | 6025 | 25 | 0 |
17823 | 17823 | 2020-03-29 | Imperial | California | 6025 | 25 | 0 |
19800 | 19800 | 2020-03-30 | Imperial | California | 6025 | 33 | 0 |
21874 | 21874 | 2020-03-31 | Imperial | California | 6025 | 38 | 0 |
24032 | 24032 | 2020-04-01 | Imperial | California | 6025 | 43 | 0 |
26261 | 26261 | 2020-04-02 | Imperial | California | 6025 | 50 | 0 |
28560 | 28560 | 2020-04-03 | Imperial | California | 6025 | 55 | 0 |
30918 | 30918 | 2020-04-04 | Imperial | California | 6025 | 55 | 0 |
33324 | 33324 | 2020-04-05 | Imperial | California | 6025 | 57 | 1 |
35768 | 35768 | 2020-04-06 | Imperial | California | 6025 | 68 | 3 |
38257 | 38257 | 2020-04-07 | Imperial | California | 6025 | 73 | 2 |
40801 | 40801 | 2020-04-08 | Imperial | California | 6025 | 75 | 3 |
43373 | 43373 | 2020-04-09 | Imperial | California | 6025 | 79 | 2 |
45973 | 45973 | 2020-04-10 | Imperial | California | 6025 | 79 | 2 |
48603 | 48603 | 2020-04-11 | Imperial | California | 6025 | 87 | 2 |
51265 | 51265 | 2020-04-12 | Imperial | California | 6025 | 87 | 2 |
53944 | 53944 | 2020-04-13 | Imperial | California | 6025 | 87 | 2 |
56636 | 56636 | 2020-04-14 | Imperial | California | 6025 | 117 | 2 |
59344 | 59344 | 2020-04-15 | Imperial | California | 6025 | 127 | 2 |
62063 | 62063 | 2020-04-16 | Imperial | California | 6025 | 143 | 2 |
64796 | 64796 | 2020-04-17 | Imperial | California | 6025 | 155 | 2 |
67544 | 67544 | 2020-04-18 | Imperial | California | 6025 | 155 | 2 |
70306 | 70306 | 2020-04-19 | Imperial | California | 6025 | 160 | 2 |
73075 | 73075 | 2020-04-20 | Imperial | California | 6025 | 160 | 2 |
75851 | 75851 | 2020-04-21 | Imperial | California | 6025 | 195 | 4 |
78635 | 78635 | 2020-04-22 | Imperial | California | 6025 | 214 | 4 |
81429 | 81429 | 2020-04-23 | Imperial | California | 6025 | 232 | 8 |
84229 | 84229 | 2020-04-24 | Imperial | California | 6025 | 251 | 8 |
87037 | 87037 | 2020-04-25 | Imperial | California | 6025 | 251 | 7 |
89854 | 89854 | 2020-04-26 | Imperial | California | 6025 | 251 | 7 |
92672 | 92672 | 2020-04-27 | Imperial | California | 6025 | 284 | 7 |
95503 | 95503 | 2020-04-28 | Imperial | California | 6025 | 304 | 8 |
98348 | 98348 | 2020-04-29 | Imperial | California | 6025 | 319 | 8 |
101198 | 101198 | 2020-04-30 | Imperial | California | 6025 | 333 | 8 |
104053 | 104053 | 2020-05-01 | Imperial | California | 6025 | 358 | 8 |
106918 | 106918 | 2020-05-02 | Imperial | California | 6025 | 358 | 8 |
109787 | 109787 | 2020-05-03 | Imperial | California | 6025 | 358 | 8 |
112662 | 112662 | 2020-05-04 | Imperial | California | 6025 | 379 | 8 |
115545 | 115545 | 2020-05-05 | Imperial | California | 6025 | 400 | 8 |
118504 | 118504 | 2020-05-06 | Imperial | California | 6025 | 419 | 8 |
121471 | 121471 | 2020-05-07 | Imperial | California | 6025 | 455 | 8 |
124451 | 124451 | 2020-05-08 | Imperial | California | 6025 | 512 | 11 |
127436 | 127436 | 2020-05-09 | Imperial | California | 6025 | 512 | 11 |
130426 | 130426 | 2020-05-10 | Imperial | California | 6025 | 512 | 11 |
133416 | 133416 | 2020-05-11 | Imperial | California | 6025 | 564 | 11 |
136406 | 136406 | 2020-05-12 | Imperial | California | 6025 | 603 | 12 |
139397 | 139397 | 2020-05-13 | Imperial | California | 6025 | 647 | 13 |
142393 | 142393 | 2020-05-14 | Imperial | California | 6025 | 712 | 14 |
145392 | 145392 | 2020-05-15 | Imperial | California | 6025 | 786 | 14 |
148396 | 148396 | 2020-05-16 | Imperial | California | 6025 | 786 | 14 |
151405 | 151405 | 2020-05-17 | Imperial | California | 6025 | 786 | 14 |
154417 | 154417 | 2020-05-18 | Imperial | California | 6025 | 876 | 14 |
157433 | 157433 | 2020-05-19 | Imperial | California | 6025 | 902 | 17 |
160459 | 160459 | 2020-05-20 | Imperial | California | 6025 | 1012 | 18 |
163487 | 163487 | 2020-05-21 | Imperial | California | 6025 | 1076 | 20 |
166519 | 166519 | 2020-05-22 | Imperial | California | 6025 | 1145 | 22 |
169555 | 169555 | 2020-05-23 | Imperial | California | 6025 | 1214 | 22 |
172596 | 172596 | 2020-05-24 | Imperial | California | 6025 | 1283 | 22 |
175640 | 175640 | 2020-05-25 | Imperial | California | 6025 | 1369 | 22 |
178684 | 178684 | 2020-05-26 | Imperial | California | 6025 | 1369 | 23 |
181728 | 181728 | 2020-05-27 | Imperial | California | 6025 | 1443 | 25 |
184782 | 184782 | 2020-05-28 | Imperial | California | 6025 | 1545 | 25 |
187838 | 187838 | 2020-05-29 | Imperial | California | 6025 | 1634 | 26 |
190903 | 190903 | 2020-05-30 | Imperial | California | 6025 | 1634 | 26 |
193970 | 193970 | 2020-05-31 | Imperial | California | 6025 | 2091 | 26 |
197040 | 197040 | 2020-06-01 | Imperial | California | 6025 | 2197 | 28 |
200113 | 200113 | 2020-06-02 | Imperial | California | 6025 | 2366 | 28 |
203189 | 203189 | 2020-06-03 | Imperial | California | 6025 | 2459 | 28 |
206269 | 206269 | 2020-06-04 | Imperial | California | 6025 | 2540 | 28 |
209350 | 209350 | 2020-06-05 | Imperial | California | 6025 | 2631 | 29 |
212435 | 212435 | 2020-06-06 | Imperial | California | 6025 | 2778 | 32 |
215522 | 215522 | 2020-06-07 | Imperial | California | 6025 | 3047 | 32 |
218613 | 218613 | 2020-06-08 | Imperial | California | 6025 | 3048 | 37 |
221708 | 221708 | 2020-06-09 | Imperial | California | 6025 | 3133 | 37 |
224803 | 224803 | 2020-06-10 | Imperial | California | 6025 | 3386 | 40 |
227905 | 227905 | 2020-06-11 | Imperial | California | 6025 | 3454 | 42 |
231008 | 231008 | 2020-06-12 | Imperial | California | 6025 | 3724 | 42 |
234114 | 234114 | 2020-06-13 | Imperial | California | 6025 | 4157 | 42 |
237221 | 237221 | 2020-06-14 | Imperial | California | 6025 | 4157 | 42 |
240329 | 240329 | 2020-06-15 | Imperial | California | 6025 | 4298 | 46 |
243440 | 243440 | 2020-06-16 | Imperial | California | 6025 | 4389 | 51 |
246553 | 246553 | 2020-06-17 | Imperial | California | 6025 | 4478 | 53 |
249665 | 249665 | 2020-06-18 | Imperial | California | 6025 | 4659 | 59 |
252780 | 252780 | 2020-06-19 | Imperial | California | 6025 | 4744 | 63 |
255899 | 255899 | 2020-06-20 | Imperial | California | 6025 | 4800 | 63 |
259026 | 259026 | 2020-06-21 | Imperial | California | 6025 | 4800 | 63 |
262153 | 262153 | 2020-06-22 | Imperial | California | 6025 | 4800 | 63 |
265281 | 265281 | 2020-06-23 | Imperial | California | 6025 | 5270 | 67 |
268411 | 268411 | 2020-06-24 | Imperial | California | 6025 | 5549 | 69 |
271546 | 271546 | 2020-06-25 | Imperial | California | 6025 | 5744 | 72 |
274686 | 274686 | 2020-06-26 | Imperial | California | 6025 | 5838 | 72 |
277834 | 277834 | 2020-06-27 | Imperial | California | 6025 | 6041 | 80 |
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);