ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,872 rows where county = "White" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
county 1
- White · 3,872 ✖
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
9561 | 9561 | 2020-03-24 | White | Arkansas | 5145 | 4 | 0 |
10932 | 10932 | 2020-03-25 | White | Arkansas | 5145 | 4 | 0 |
12477 | 12477 | 2020-03-26 | White | Arkansas | 5145 | 6 | 0 |
14141 | 14141 | 2020-03-27 | White | Arkansas | 5145 | 6 | 0 |
15922 | 15922 | 2020-03-28 | White | Arkansas | 5145 | 6 | 0 |
17811 | 17811 | 2020-03-29 | White | Arkansas | 5145 | 6 | 0 |
19787 | 19787 | 2020-03-30 | White | Arkansas | 5145 | 9 | 0 |
21861 | 21861 | 2020-03-31 | White | Arkansas | 5145 | 11 | 0 |
24019 | 24019 | 2020-04-01 | White | Arkansas | 5145 | 15 | 0 |
26247 | 26247 | 2020-04-02 | White | Arkansas | 5145 | 22 | 0 |
28546 | 28546 | 2020-04-03 | White | Arkansas | 5145 | 23 | 0 |
30904 | 30904 | 2020-04-04 | White | Arkansas | 5145 | 23 | 0 |
33309 | 33309 | 2020-04-05 | White | Arkansas | 5145 | 25 | 0 |
35753 | 35753 | 2020-04-06 | White | Arkansas | 5145 | 27 | 0 |
38242 | 38242 | 2020-04-07 | White | Arkansas | 5145 | 27 | 0 |
40786 | 40786 | 2020-04-08 | White | Arkansas | 5145 | 27 | 0 |
43358 | 43358 | 2020-04-09 | White | Arkansas | 5145 | 27 | 0 |
45958 | 45958 | 2020-04-10 | White | Arkansas | 5145 | 28 | 0 |
48588 | 48588 | 2020-04-11 | White | Arkansas | 5145 | 28 | 0 |
51250 | 51250 | 2020-04-12 | White | Arkansas | 5145 | 28 | 0 |
53929 | 53929 | 2020-04-13 | White | Arkansas | 5145 | 28 | 0 |
56621 | 56621 | 2020-04-14 | White | Arkansas | 5145 | 28 | 0 |
59329 | 59329 | 2020-04-15 | White | Arkansas | 5145 | 28 | 0 |
62048 | 62048 | 2020-04-16 | White | Arkansas | 5145 | 28 | 0 |
64781 | 64781 | 2020-04-17 | White | Arkansas | 5145 | 29 | 0 |
67529 | 67529 | 2020-04-18 | White | Arkansas | 5145 | 29 | 0 |
70291 | 70291 | 2020-04-19 | White | Arkansas | 5145 | 29 | 0 |
73060 | 73060 | 2020-04-20 | White | Arkansas | 5145 | 29 | 1 |
75836 | 75836 | 2020-04-21 | White | Arkansas | 5145 | 29 | 1 |
78620 | 78620 | 2020-04-22 | White | Arkansas | 5145 | 29 | 1 |
81414 | 81414 | 2020-04-23 | White | Arkansas | 5145 | 29 | 1 |
84214 | 84214 | 2020-04-24 | White | Arkansas | 5145 | 30 | 1 |
87022 | 87022 | 2020-04-25 | White | Arkansas | 5145 | 31 | 1 |
89839 | 89839 | 2020-04-26 | White | Arkansas | 5145 | 31 | 1 |
92657 | 92657 | 2020-04-27 | White | Arkansas | 5145 | 31 | 1 |
95488 | 95488 | 2020-04-28 | White | Arkansas | 5145 | 31 | 1 |
98333 | 98333 | 2020-04-29 | White | Arkansas | 5145 | 33 | 1 |
101183 | 101183 | 2020-04-30 | White | Arkansas | 5145 | 34 | 1 |
104038 | 104038 | 2020-05-01 | White | Arkansas | 5145 | 34 | 1 |
106903 | 106903 | 2020-05-02 | White | Arkansas | 5145 | 34 | 1 |
109772 | 109772 | 2020-05-03 | White | Arkansas | 5145 | 35 | 1 |
112647 | 112647 | 2020-05-04 | White | Arkansas | 5145 | 35 | 1 |
115530 | 115530 | 2020-05-05 | White | Arkansas | 5145 | 35 | 1 |
118489 | 118489 | 2020-05-06 | White | Arkansas | 5145 | 35 | 1 |
121456 | 121456 | 2020-05-07 | White | Arkansas | 5145 | 35 | 1 |
124436 | 124436 | 2020-05-08 | White | Arkansas | 5145 | 35 | 1 |
127421 | 127421 | 2020-05-09 | White | Arkansas | 5145 | 35 | 1 |
130411 | 130411 | 2020-05-10 | White | Arkansas | 5145 | 36 | 1 |
133401 | 133401 | 2020-05-11 | White | Arkansas | 5145 | 36 | 1 |
136391 | 136391 | 2020-05-12 | White | Arkansas | 5145 | 37 | 1 |
139382 | 139382 | 2020-05-13 | White | Arkansas | 5145 | 36 | 1 |
142378 | 142378 | 2020-05-14 | White | Arkansas | 5145 | 36 | 1 |
145377 | 145377 | 2020-05-15 | White | Arkansas | 5145 | 36 | 1 |
148381 | 148381 | 2020-05-16 | White | Arkansas | 5145 | 36 | 1 |
151390 | 151390 | 2020-05-17 | White | Arkansas | 5145 | 36 | 1 |
154402 | 154402 | 2020-05-18 | White | Arkansas | 5145 | 37 | 1 |
157418 | 157418 | 2020-05-19 | White | Arkansas | 5145 | 37 | 1 |
160444 | 160444 | 2020-05-20 | White | Arkansas | 5145 | 37 | 1 |
163472 | 163472 | 2020-05-21 | White | Arkansas | 5145 | 37 | 1 |
166504 | 166504 | 2020-05-22 | White | Arkansas | 5145 | 37 | 1 |
169540 | 169540 | 2020-05-23 | White | Arkansas | 5145 | 38 | 1 |
172581 | 172581 | 2020-05-24 | White | Arkansas | 5145 | 40 | 1 |
175625 | 175625 | 2020-05-25 | White | Arkansas | 5145 | 40 | 1 |
178669 | 178669 | 2020-05-26 | White | Arkansas | 5145 | 40 | 1 |
181713 | 181713 | 2020-05-27 | White | Arkansas | 5145 | 42 | 1 |
184767 | 184767 | 2020-05-28 | White | Arkansas | 5145 | 43 | 1 |
187823 | 187823 | 2020-05-29 | White | Arkansas | 5145 | 43 | 1 |
190888 | 190888 | 2020-05-30 | White | Arkansas | 5145 | 44 | 1 |
193955 | 193955 | 2020-05-31 | White | Arkansas | 5145 | 44 | 1 |
197025 | 197025 | 2020-06-01 | White | Arkansas | 5145 | 44 | 1 |
200098 | 200098 | 2020-06-02 | White | Arkansas | 5145 | 46 | 1 |
203174 | 203174 | 2020-06-03 | White | Arkansas | 5145 | 48 | 1 |
206254 | 206254 | 2020-06-04 | White | Arkansas | 5145 | 48 | 1 |
209335 | 209335 | 2020-06-05 | White | Arkansas | 5145 | 48 | 1 |
212420 | 212420 | 2020-06-06 | White | Arkansas | 5145 | 49 | 1 |
215507 | 215507 | 2020-06-07 | White | Arkansas | 5145 | 49 | 1 |
218598 | 218598 | 2020-06-08 | White | Arkansas | 5145 | 50 | 1 |
221693 | 221693 | 2020-06-09 | White | Arkansas | 5145 | 50 | 1 |
224788 | 224788 | 2020-06-10 | White | Arkansas | 5145 | 52 | 1 |
227890 | 227890 | 2020-06-11 | White | Arkansas | 5145 | 55 | 1 |
230993 | 230993 | 2020-06-12 | White | Arkansas | 5145 | 54 | 1 |
234099 | 234099 | 2020-06-13 | White | Arkansas | 5145 | 56 | 1 |
237206 | 237206 | 2020-06-14 | White | Arkansas | 5145 | 58 | 1 |
240314 | 240314 | 2020-06-15 | White | Arkansas | 5145 | 59 | 1 |
243425 | 243425 | 2020-06-16 | White | Arkansas | 5145 | 61 | 1 |
246538 | 246538 | 2020-06-17 | White | Arkansas | 5145 | 65 | 1 |
249650 | 249650 | 2020-06-18 | White | Arkansas | 5145 | 69 | 1 |
252765 | 252765 | 2020-06-19 | White | Arkansas | 5145 | 70 | 1 |
255884 | 255884 | 2020-06-20 | White | Arkansas | 5145 | 73 | 1 |
259011 | 259011 | 2020-06-21 | White | Arkansas | 5145 | 73 | 1 |
262138 | 262138 | 2020-06-22 | White | Arkansas | 5145 | 76 | 1 |
265266 | 265266 | 2020-06-23 | White | Arkansas | 5145 | 76 | 1 |
268396 | 268396 | 2020-06-24 | White | Arkansas | 5145 | 80 | 1 |
271531 | 271531 | 2020-06-25 | White | Arkansas | 5145 | 79 | 1 |
274671 | 274671 | 2020-06-26 | White | Arkansas | 5145 | 80 | 1 |
277819 | 277819 | 2020-06-27 | White | Arkansas | 5145 | 82 | 1 |
280966 | 280966 | 2020-06-28 | White | Arkansas | 5145 | 84 | 1 |
284112 | 284112 | 2020-06-29 | White | Arkansas | 5145 | 85 | 1 |
287258 | 287258 | 2020-06-30 | White | Arkansas | 5145 | 86 | 1 |
290409 | 290409 | 2020-07-01 | White | Arkansas | 5145 | 87 | 1 |
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);