ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Washington" and state = "Texas" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
17460 | 17460 | 2020-03-28 | Washington | Texas | 48477 | 5 | 0 |
19419 | 19419 | 2020-03-29 | Washington | Texas | 48477 | 5 | 0 |
21481 | 21481 | 2020-03-30 | Washington | Texas | 48477 | 8 | 0 |
23620 | 23620 | 2020-03-31 | Washington | Texas | 48477 | 8 | 0 |
25834 | 25834 | 2020-04-01 | Washington | Texas | 48477 | 17 | 0 |
28122 | 28122 | 2020-04-02 | Washington | Texas | 48477 | 17 | 0 |
30459 | 30459 | 2020-04-03 | Washington | Texas | 48477 | 17 | 0 |
32857 | 32857 | 2020-04-04 | Washington | Texas | 48477 | 17 | 0 |
35295 | 35295 | 2020-04-05 | Washington | Texas | 48477 | 17 | 1 |
37772 | 37772 | 2020-04-06 | Washington | Texas | 48477 | 21 | 1 |
40301 | 40301 | 2020-04-07 | Washington | Texas | 48477 | 21 | 1 |
42869 | 42869 | 2020-04-08 | Washington | Texas | 48477 | 26 | 1 |
45463 | 45463 | 2020-04-09 | Washington | Texas | 48477 | 29 | 1 |
48086 | 48086 | 2020-04-10 | Washington | Texas | 48477 | 36 | 1 |
50744 | 50744 | 2020-04-11 | Washington | Texas | 48477 | 36 | 1 |
53419 | 53419 | 2020-04-12 | Washington | Texas | 48477 | 37 | 2 |
56108 | 56108 | 2020-04-13 | Washington | Texas | 48477 | 37 | 2 |
58813 | 58813 | 2020-04-14 | Washington | Texas | 48477 | 37 | 2 |
61531 | 61531 | 2020-04-15 | Washington | Texas | 48477 | 41 | 3 |
64263 | 64263 | 2020-04-16 | Washington | Texas | 48477 | 46 | 3 |
67010 | 67010 | 2020-04-17 | Washington | Texas | 48477 | 47 | 4 |
69770 | 69770 | 2020-04-18 | Washington | Texas | 48477 | 50 | 4 |
72540 | 72540 | 2020-04-19 | Washington | Texas | 48477 | 52 | 4 |
75316 | 75316 | 2020-04-20 | Washington | Texas | 48477 | 61 | 4 |
78098 | 78098 | 2020-04-21 | Washington | Texas | 48477 | 67 | 6 |
80889 | 80889 | 2020-04-22 | Washington | Texas | 48477 | 71 | 6 |
83690 | 83690 | 2020-04-23 | Washington | Texas | 48477 | 77 | 6 |
86497 | 86497 | 2020-04-24 | Washington | Texas | 48477 | 78 | 6 |
89312 | 89312 | 2020-04-25 | Washington | Texas | 48477 | 103 | 11 |
92129 | 92129 | 2020-04-26 | Washington | Texas | 48477 | 113 | 11 |
94958 | 94958 | 2020-04-27 | Washington | Texas | 48477 | 113 | 11 |
97800 | 97800 | 2020-04-28 | Washington | Texas | 48477 | 136 | 11 |
100650 | 100650 | 2020-04-29 | Washington | Texas | 48477 | 140 | 14 |
103505 | 103505 | 2020-04-30 | Washington | Texas | 48477 | 142 | 15 |
106369 | 106369 | 2020-05-01 | Washington | Texas | 48477 | 144 | 15 |
109238 | 109238 | 2020-05-02 | Washington | Texas | 48477 | 145 | 15 |
112112 | 112112 | 2020-05-03 | Washington | Texas | 48477 | 145 | 18 |
114995 | 114995 | 2020-05-04 | Washington | Texas | 48477 | 145 | 18 |
117954 | 117954 | 2020-05-05 | Washington | Texas | 48477 | 147 | 18 |
120918 | 120918 | 2020-05-06 | Washington | Texas | 48477 | 150 | 18 |
123898 | 123898 | 2020-05-07 | Washington | Texas | 48477 | 153 | 18 |
126883 | 126883 | 2020-05-08 | Washington | Texas | 48477 | 156 | 18 |
129872 | 129872 | 2020-05-09 | Washington | Texas | 48477 | 164 | 18 |
132862 | 132862 | 2020-05-10 | Washington | Texas | 48477 | 164 | 18 |
135853 | 135853 | 2020-05-11 | Washington | Texas | 48477 | 164 | 18 |
138843 | 138843 | 2020-05-12 | Washington | Texas | 48477 | 170 | 22 |
141839 | 141839 | 2020-05-13 | Washington | Texas | 48477 | 175 | 22 |
144836 | 144836 | 2020-05-14 | Washington | Texas | 48477 | 175 | 22 |
147840 | 147840 | 2020-05-15 | Washington | Texas | 48477 | 179 | 22 |
150848 | 150848 | 2020-05-16 | Washington | Texas | 48477 | 181 | 22 |
153859 | 153859 | 2020-05-17 | Washington | Texas | 48477 | 181 | 22 |
156876 | 156876 | 2020-05-18 | Washington | Texas | 48477 | 181 | 22 |
159900 | 159900 | 2020-05-19 | Washington | Texas | 48477 | 184 | 22 |
162928 | 162928 | 2020-05-20 | Washington | Texas | 48477 | 186 | 22 |
165957 | 165957 | 2020-05-21 | Washington | Texas | 48477 | 187 | 22 |
168993 | 168993 | 2020-05-22 | Washington | Texas | 48477 | 187 | 22 |
172034 | 172034 | 2020-05-23 | Washington | Texas | 48477 | 193 | 23 |
175077 | 175077 | 2020-05-24 | Washington | Texas | 48477 | 193 | 23 |
178122 | 178122 | 2020-05-25 | Washington | Texas | 48477 | 193 | 23 |
181166 | 181166 | 2020-05-26 | Washington | Texas | 48477 | 193 | 23 |
184217 | 184217 | 2020-05-27 | Washington | Texas | 48477 | 196 | 23 |
187274 | 187274 | 2020-05-28 | Washington | Texas | 48477 | 197 | 23 |
190338 | 190338 | 2020-05-29 | Washington | Texas | 48477 | 198 | 25 |
193404 | 193404 | 2020-05-30 | Washington | Texas | 48477 | 202 | 25 |
196474 | 196474 | 2020-05-31 | Washington | Texas | 48477 | 202 | 25 |
199547 | 199547 | 2020-06-01 | Washington | Texas | 48477 | 202 | 25 |
202623 | 202623 | 2020-06-02 | Washington | Texas | 48477 | 205 | 25 |
205702 | 205702 | 2020-06-03 | Washington | Texas | 48477 | 204 | 25 |
208784 | 208784 | 2020-06-04 | Washington | Texas | 48477 | 206 | 25 |
211869 | 211869 | 2020-06-05 | Washington | Texas | 48477 | 206 | 25 |
214956 | 214956 | 2020-06-06 | Washington | Texas | 48477 | 206 | 25 |
218046 | 218046 | 2020-06-07 | Washington | Texas | 48477 | 207 | 25 |
221138 | 221138 | 2020-06-08 | Washington | Texas | 48477 | 207 | 25 |
224234 | 224234 | 2020-06-09 | Washington | Texas | 48477 | 208 | 25 |
227334 | 227334 | 2020-06-10 | Washington | Texas | 48477 | 213 | 25 |
230438 | 230438 | 2020-06-11 | Washington | Texas | 48477 | 214 | 25 |
233542 | 233542 | 2020-06-12 | Washington | Texas | 48477 | 216 | 26 |
236649 | 236649 | 2020-06-13 | Washington | Texas | 48477 | 218 | 26 |
239757 | 239757 | 2020-06-14 | Washington | Texas | 48477 | 218 | 26 |
242867 | 242867 | 2020-06-15 | Washington | Texas | 48477 | 218 | 26 |
245979 | 245979 | 2020-06-16 | Washington | Texas | 48477 | 218 | 26 |
249092 | 249092 | 2020-06-17 | Washington | Texas | 48477 | 219 | 26 |
252207 | 252207 | 2020-06-18 | Washington | Texas | 48477 | 222 | 26 |
255324 | 255324 | 2020-06-19 | Washington | Texas | 48477 | 222 | 26 |
258451 | 258451 | 2020-06-20 | Washington | Texas | 48477 | 224 | 26 |
261578 | 261578 | 2020-06-21 | Washington | Texas | 48477 | 229 | 26 |
264707 | 264707 | 2020-06-22 | Washington | Texas | 48477 | 235 | 27 |
267836 | 267836 | 2020-06-23 | Washington | Texas | 48477 | 239 | 27 |
270970 | 270970 | 2020-06-24 | Washington | Texas | 48477 | 241 | 27 |
274110 | 274110 | 2020-06-25 | Washington | Texas | 48477 | 244 | 27 |
277258 | 277258 | 2020-06-26 | Washington | Texas | 48477 | 247 | 31 |
280406 | 280406 | 2020-06-27 | Washington | Texas | 48477 | 260 | 31 |
283552 | 283552 | 2020-06-28 | Washington | Texas | 48477 | 261 | 31 |
286698 | 286698 | 2020-06-29 | Washington | Texas | 48477 | 265 | 31 |
289848 | 289848 | 2020-06-30 | Washington | Texas | 48477 | 267 | 31 |
293001 | 293001 | 2020-07-01 | Washington | Texas | 48477 | 275 | 31 |
296156 | 296156 | 2020-07-02 | Washington | Texas | 48477 | 280 | 31 |
299318 | 299318 | 2020-07-03 | Washington | Texas | 48477 | 282 | 31 |
302482 | 302482 | 2020-07-04 | Washington | Texas | 48477 | 296 | 31 |
305646 | 305646 | 2020-07-05 | Washington | Texas | 48477 | 296 | 31 |
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);