ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,903 rows where county = "Dallas" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
county 1
- Dallas · 3,903 ✖
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
10848 | 10848 | 2020-03-25 | Dallas | Alabama | 1047 | 2 | 0 |
12384 | 12384 | 2020-03-26 | Dallas | Alabama | 1047 | 2 | 0 |
14043 | 14043 | 2020-03-27 | Dallas | Alabama | 1047 | 2 | 0 |
15821 | 15821 | 2020-03-28 | Dallas | Alabama | 1047 | 2 | 0 |
17704 | 17704 | 2020-03-29 | Dallas | Alabama | 1047 | 2 | 0 |
19674 | 19674 | 2020-03-30 | Dallas | Alabama | 1047 | 2 | 0 |
21746 | 21746 | 2020-03-31 | Dallas | Alabama | 1047 | 2 | 0 |
23902 | 23902 | 2020-04-01 | Dallas | Alabama | 1047 | 3 | 0 |
26124 | 26124 | 2020-04-02 | Dallas | Alabama | 1047 | 4 | 0 |
28420 | 28420 | 2020-04-03 | Dallas | Alabama | 1047 | 7 | 0 |
30777 | 30777 | 2020-04-04 | Dallas | Alabama | 1047 | 7 | 0 |
33181 | 33181 | 2020-04-05 | Dallas | Alabama | 1047 | 7 | 0 |
35620 | 35620 | 2020-04-06 | Dallas | Alabama | 1047 | 7 | 0 |
38108 | 38108 | 2020-04-07 | Dallas | Alabama | 1047 | 7 | 0 |
40650 | 40650 | 2020-04-08 | Dallas | Alabama | 1047 | 7 | 0 |
43223 | 43223 | 2020-04-09 | Dallas | Alabama | 1047 | 10 | 0 |
45821 | 45821 | 2020-04-10 | Dallas | Alabama | 1047 | 11 | 0 |
48450 | 48450 | 2020-04-11 | Dallas | Alabama | 1047 | 10 | 0 |
51111 | 51111 | 2020-04-12 | Dallas | Alabama | 1047 | 14 | 0 |
53789 | 53789 | 2020-04-13 | Dallas | Alabama | 1047 | 14 | 0 |
56481 | 56481 | 2020-04-14 | Dallas | Alabama | 1047 | 17 | 0 |
59189 | 59189 | 2020-04-15 | Dallas | Alabama | 1047 | 22 | 2 |
61907 | 61907 | 2020-04-16 | Dallas | Alabama | 1047 | 21 | 2 |
64640 | 64640 | 2020-04-17 | Dallas | Alabama | 1047 | 21 | 2 |
67388 | 67388 | 2020-04-18 | Dallas | Alabama | 1047 | 22 | 2 |
70150 | 70150 | 2020-04-19 | Dallas | Alabama | 1047 | 25 | 2 |
72919 | 72919 | 2020-04-20 | Dallas | Alabama | 1047 | 26 | 2 |
75695 | 75695 | 2020-04-21 | Dallas | Alabama | 1047 | 29 | 2 |
78478 | 78478 | 2020-04-22 | Dallas | Alabama | 1047 | 30 | 2 |
81271 | 81271 | 2020-04-23 | Dallas | Alabama | 1047 | 29 | 2 |
84072 | 84072 | 2020-04-24 | Dallas | Alabama | 1047 | 32 | 2 |
86880 | 86880 | 2020-04-25 | Dallas | Alabama | 1047 | 32 | 2 |
89696 | 89696 | 2020-04-26 | Dallas | Alabama | 1047 | 33 | 2 |
92514 | 92514 | 2020-04-27 | Dallas | Alabama | 1047 | 37 | 3 |
95344 | 95344 | 2020-04-28 | Dallas | Alabama | 1047 | 37 | 3 |
98189 | 98189 | 2020-04-29 | Dallas | Alabama | 1047 | 37 | 3 |
101039 | 101039 | 2020-04-30 | Dallas | Alabama | 1047 | 38 | 3 |
103894 | 103894 | 2020-05-01 | Dallas | Alabama | 1047 | 42 | 3 |
106759 | 106759 | 2020-05-02 | Dallas | Alabama | 1047 | 49 | 3 |
109628 | 109628 | 2020-05-03 | Dallas | Alabama | 1047 | 59 | 3 |
112503 | 112503 | 2020-05-04 | Dallas | Alabama | 1047 | 65 | 3 |
115386 | 115386 | 2020-05-05 | Dallas | Alabama | 1047 | 68 | 3 |
118345 | 118345 | 2020-05-06 | Dallas | Alabama | 1047 | 76 | 3 |
121311 | 121311 | 2020-05-07 | Dallas | Alabama | 1047 | 83 | 3 |
124291 | 124291 | 2020-05-08 | Dallas | Alabama | 1047 | 95 | 3 |
127276 | 127276 | 2020-05-09 | Dallas | Alabama | 1047 | 102 | 3 |
130266 | 130266 | 2020-05-10 | Dallas | Alabama | 1047 | 108 | 3 |
133256 | 133256 | 2020-05-11 | Dallas | Alabama | 1047 | 122 | 3 |
136246 | 136246 | 2020-05-12 | Dallas | Alabama | 1047 | 124 | 3 |
139237 | 139237 | 2020-05-13 | Dallas | Alabama | 1047 | 129 | 3 |
142233 | 142233 | 2020-05-14 | Dallas | Alabama | 1047 | 132 | 3 |
145232 | 145232 | 2020-05-15 | Dallas | Alabama | 1047 | 137 | 3 |
148235 | 148235 | 2020-05-16 | Dallas | Alabama | 1047 | 145 | 3 |
151244 | 151244 | 2020-05-17 | Dallas | Alabama | 1047 | 146 | 3 |
154256 | 154256 | 2020-05-18 | Dallas | Alabama | 1047 | 151 | 3 |
157272 | 157272 | 2020-05-19 | Dallas | Alabama | 1047 | 159 | 3 |
160296 | 160296 | 2020-05-20 | Dallas | Alabama | 1047 | 172 | 3 |
163324 | 163324 | 2020-05-21 | Dallas | Alabama | 1047 | 179 | 3 |
166356 | 166356 | 2020-05-22 | Dallas | Alabama | 1047 | 182 | 3 |
169392 | 169392 | 2020-05-23 | Dallas | Alabama | 1047 | 191 | 3 |
172433 | 172433 | 2020-05-24 | Dallas | Alabama | 1047 | 197 | 3 |
175476 | 175476 | 2020-05-25 | Dallas | Alabama | 1047 | 206 | 3 |
178521 | 178521 | 2020-05-26 | Dallas | Alabama | 1047 | 222 | 3 |
181565 | 181565 | 2020-05-27 | Dallas | Alabama | 1047 | 232 | 3 |
184617 | 184617 | 2020-05-28 | Dallas | Alabama | 1047 | 244 | 3 |
187674 | 187674 | 2020-05-29 | Dallas | Alabama | 1047 | 255 | 3 |
190738 | 190738 | 2020-05-30 | Dallas | Alabama | 1047 | 260 | 3 |
193804 | 193804 | 2020-05-31 | Dallas | Alabama | 1047 | 272 | 3 |
196874 | 196874 | 2020-06-01 | Dallas | Alabama | 1047 | 279 | 3 |
199947 | 199947 | 2020-06-02 | Dallas | Alabama | 1047 | 282 | 3 |
203023 | 203023 | 2020-06-03 | Dallas | Alabama | 1047 | 287 | 3 |
206102 | 206102 | 2020-06-04 | Dallas | Alabama | 1047 | 294 | 3 |
209184 | 209184 | 2020-06-05 | Dallas | Alabama | 1047 | 298 | 3 |
212269 | 212269 | 2020-06-06 | Dallas | Alabama | 1047 | 304 | 3 |
215356 | 215356 | 2020-06-07 | Dallas | Alabama | 1047 | 322 | 3 |
218446 | 218446 | 2020-06-08 | Dallas | Alabama | 1047 | 341 | 4 |
221538 | 221538 | 2020-06-09 | Dallas | Alabama | 1047 | 356 | 5 |
224634 | 224634 | 2020-06-10 | Dallas | Alabama | 1047 | 379 | 6 |
227735 | 227735 | 2020-06-11 | Dallas | Alabama | 1047 | 410 | 6 |
230839 | 230839 | 2020-06-12 | Dallas | Alabama | 1047 | 425 | 6 |
233944 | 233944 | 2020-06-13 | Dallas | Alabama | 1047 | 451 | 6 |
237051 | 237051 | 2020-06-14 | Dallas | Alabama | 1047 | 490 | 6 |
240159 | 240159 | 2020-06-15 | Dallas | Alabama | 1047 | 507 | 6 |
243270 | 243270 | 2020-06-16 | Dallas | Alabama | 1047 | 527 | 6 |
246383 | 246383 | 2020-06-17 | Dallas | Alabama | 1047 | 536 | 6 |
249495 | 249495 | 2020-06-18 | Dallas | Alabama | 1047 | 570 | 6 |
252610 | 252610 | 2020-06-19 | Dallas | Alabama | 1047 | 596 | 6 |
255729 | 255729 | 2020-06-20 | Dallas | Alabama | 1047 | 626 | 6 |
258856 | 258856 | 2020-06-21 | Dallas | Alabama | 1047 | 634 | 6 |
261983 | 261983 | 2020-06-22 | Dallas | Alabama | 1047 | 646 | 6 |
265112 | 265112 | 2020-06-23 | Dallas | Alabama | 1047 | 666 | 6 |
268241 | 268241 | 2020-06-24 | Dallas | Alabama | 1047 | 692 | 7 |
271375 | 271375 | 2020-06-25 | Dallas | Alabama | 1047 | 716 | 7 |
274515 | 274515 | 2020-06-26 | Dallas | Alabama | 1047 | 733 | 8 |
277663 | 277663 | 2020-06-27 | Dallas | Alabama | 1047 | 750 | 8 |
280811 | 280811 | 2020-06-28 | Dallas | Alabama | 1047 | 753 | 8 |
283957 | 283957 | 2020-06-29 | Dallas | Alabama | 1047 | 787 | 8 |
287103 | 287103 | 2020-06-30 | Dallas | Alabama | 1047 | 814 | 8 |
290253 | 290253 | 2020-07-01 | Dallas | Alabama | 1047 | 826 | 8 |
293406 | 293406 | 2020-07-02 | Dallas | Alabama | 1047 | 849 | 9 |
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);