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 date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388770 | 388770 | 2020-07-31 | Washington | Texas | 48477 | 465 | 38 |
385553 | 385553 | 2020-07-30 | Washington | Texas | 48477 | 452 | 37 |
382335 | 382335 | 2020-07-29 | Washington | Texas | 48477 | 452 | 38 |
379118 | 379118 | 2020-07-28 | Washington | Texas | 48477 | 450 | 37 |
375902 | 375902 | 2020-07-27 | Washington | Texas | 48477 | 441 | 35 |
372689 | 372689 | 2020-07-26 | Washington | Texas | 48477 | 441 | 34 |
369477 | 369477 | 2020-07-25 | Washington | Texas | 48477 | 441 | 34 |
366268 | 366268 | 2020-07-24 | Washington | Texas | 48477 | 439 | 34 |
363062 | 363062 | 2020-07-23 | Washington | Texas | 48477 | 439 | 34 |
359855 | 359855 | 2020-07-22 | Washington | Texas | 48477 | 426 | 34 |
356650 | 356650 | 2020-07-21 | Washington | Texas | 48477 | 400 | 34 |
353447 | 353447 | 2020-07-20 | Washington | Texas | 48477 | 400 | 34 |
350245 | 350245 | 2020-07-19 | Washington | Texas | 48477 | 391 | 34 |
347045 | 347045 | 2020-07-18 | Washington | Texas | 48477 | 391 | 33 |
343844 | 343844 | 2020-07-17 | Washington | Texas | 48477 | 391 | 33 |
340645 | 340645 | 2020-07-16 | Washington | Texas | 48477 | 373 | 33 |
337449 | 337449 | 2020-07-15 | Washington | Texas | 48477 | 373 | 33 |
334254 | 334254 | 2020-07-14 | Washington | Texas | 48477 | 365 | 33 |
331061 | 331061 | 2020-07-13 | Washington | Texas | 48477 | 365 | 33 |
327875 | 327875 | 2020-07-12 | Washington | Texas | 48477 | 351 | 33 |
324690 | 324690 | 2020-07-11 | Washington | Texas | 48477 | 351 | 33 |
321509 | 321509 | 2020-07-10 | Washington | Texas | 48477 | 349 | 32 |
318330 | 318330 | 2020-07-09 | Washington | Texas | 48477 | 337 | 32 |
315157 | 315157 | 2020-07-08 | Washington | Texas | 48477 | 335 | 32 |
311983 | 311983 | 2020-07-07 | Washington | Texas | 48477 | 318 | 31 |
308814 | 308814 | 2020-07-06 | Washington | Texas | 48477 | 318 | 31 |
305646 | 305646 | 2020-07-05 | Washington | Texas | 48477 | 296 | 31 |
302482 | 302482 | 2020-07-04 | Washington | Texas | 48477 | 296 | 31 |
299318 | 299318 | 2020-07-03 | Washington | Texas | 48477 | 282 | 31 |
296156 | 296156 | 2020-07-02 | Washington | Texas | 48477 | 280 | 31 |
293001 | 293001 | 2020-07-01 | Washington | Texas | 48477 | 275 | 31 |
289848 | 289848 | 2020-06-30 | Washington | Texas | 48477 | 267 | 31 |
286698 | 286698 | 2020-06-29 | Washington | Texas | 48477 | 265 | 31 |
283552 | 283552 | 2020-06-28 | Washington | Texas | 48477 | 261 | 31 |
280406 | 280406 | 2020-06-27 | Washington | Texas | 48477 | 260 | 31 |
277258 | 277258 | 2020-06-26 | Washington | Texas | 48477 | 247 | 31 |
274110 | 274110 | 2020-06-25 | Washington | Texas | 48477 | 244 | 27 |
270970 | 270970 | 2020-06-24 | Washington | Texas | 48477 | 241 | 27 |
267836 | 267836 | 2020-06-23 | Washington | Texas | 48477 | 239 | 27 |
264707 | 264707 | 2020-06-22 | Washington | Texas | 48477 | 235 | 27 |
261578 | 261578 | 2020-06-21 | Washington | Texas | 48477 | 229 | 26 |
258451 | 258451 | 2020-06-20 | Washington | Texas | 48477 | 224 | 26 |
255324 | 255324 | 2020-06-19 | Washington | Texas | 48477 | 222 | 26 |
252207 | 252207 | 2020-06-18 | Washington | Texas | 48477 | 222 | 26 |
249092 | 249092 | 2020-06-17 | Washington | Texas | 48477 | 219 | 26 |
245979 | 245979 | 2020-06-16 | Washington | Texas | 48477 | 218 | 26 |
242867 | 242867 | 2020-06-15 | Washington | Texas | 48477 | 218 | 26 |
239757 | 239757 | 2020-06-14 | Washington | Texas | 48477 | 218 | 26 |
236649 | 236649 | 2020-06-13 | Washington | Texas | 48477 | 218 | 26 |
233542 | 233542 | 2020-06-12 | Washington | Texas | 48477 | 216 | 26 |
230438 | 230438 | 2020-06-11 | Washington | Texas | 48477 | 214 | 25 |
227334 | 227334 | 2020-06-10 | Washington | Texas | 48477 | 213 | 25 |
224234 | 224234 | 2020-06-09 | Washington | Texas | 48477 | 208 | 25 |
221138 | 221138 | 2020-06-08 | Washington | Texas | 48477 | 207 | 25 |
218046 | 218046 | 2020-06-07 | Washington | Texas | 48477 | 207 | 25 |
214956 | 214956 | 2020-06-06 | Washington | Texas | 48477 | 206 | 25 |
211869 | 211869 | 2020-06-05 | Washington | Texas | 48477 | 206 | 25 |
208784 | 208784 | 2020-06-04 | Washington | Texas | 48477 | 206 | 25 |
205702 | 205702 | 2020-06-03 | Washington | Texas | 48477 | 204 | 25 |
202623 | 202623 | 2020-06-02 | Washington | Texas | 48477 | 205 | 25 |
199547 | 199547 | 2020-06-01 | Washington | Texas | 48477 | 202 | 25 |
196474 | 196474 | 2020-05-31 | Washington | Texas | 48477 | 202 | 25 |
193404 | 193404 | 2020-05-30 | Washington | Texas | 48477 | 202 | 25 |
190338 | 190338 | 2020-05-29 | Washington | Texas | 48477 | 198 | 25 |
187274 | 187274 | 2020-05-28 | Washington | Texas | 48477 | 197 | 23 |
184217 | 184217 | 2020-05-27 | Washington | Texas | 48477 | 196 | 23 |
181166 | 181166 | 2020-05-26 | Washington | Texas | 48477 | 193 | 23 |
178122 | 178122 | 2020-05-25 | Washington | Texas | 48477 | 193 | 23 |
175077 | 175077 | 2020-05-24 | Washington | Texas | 48477 | 193 | 23 |
172034 | 172034 | 2020-05-23 | Washington | Texas | 48477 | 193 | 23 |
168993 | 168993 | 2020-05-22 | Washington | Texas | 48477 | 187 | 22 |
165957 | 165957 | 2020-05-21 | Washington | Texas | 48477 | 187 | 22 |
162928 | 162928 | 2020-05-20 | Washington | Texas | 48477 | 186 | 22 |
159900 | 159900 | 2020-05-19 | Washington | Texas | 48477 | 184 | 22 |
156876 | 156876 | 2020-05-18 | Washington | Texas | 48477 | 181 | 22 |
153859 | 153859 | 2020-05-17 | Washington | Texas | 48477 | 181 | 22 |
150848 | 150848 | 2020-05-16 | Washington | Texas | 48477 | 181 | 22 |
147840 | 147840 | 2020-05-15 | Washington | Texas | 48477 | 179 | 22 |
144836 | 144836 | 2020-05-14 | Washington | Texas | 48477 | 175 | 22 |
141839 | 141839 | 2020-05-13 | Washington | Texas | 48477 | 175 | 22 |
138843 | 138843 | 2020-05-12 | Washington | Texas | 48477 | 170 | 22 |
135853 | 135853 | 2020-05-11 | Washington | Texas | 48477 | 164 | 18 |
132862 | 132862 | 2020-05-10 | Washington | Texas | 48477 | 164 | 18 |
129872 | 129872 | 2020-05-09 | Washington | Texas | 48477 | 164 | 18 |
126883 | 126883 | 2020-05-08 | Washington | Texas | 48477 | 156 | 18 |
123898 | 123898 | 2020-05-07 | Washington | Texas | 48477 | 153 | 18 |
120918 | 120918 | 2020-05-06 | Washington | Texas | 48477 | 150 | 18 |
117954 | 117954 | 2020-05-05 | Washington | Texas | 48477 | 147 | 18 |
114995 | 114995 | 2020-05-04 | Washington | Texas | 48477 | 145 | 18 |
112112 | 112112 | 2020-05-03 | Washington | Texas | 48477 | 145 | 18 |
109238 | 109238 | 2020-05-02 | Washington | Texas | 48477 | 145 | 15 |
106369 | 106369 | 2020-05-01 | Washington | Texas | 48477 | 144 | 15 |
103505 | 103505 | 2020-04-30 | Washington | Texas | 48477 | 142 | 15 |
100650 | 100650 | 2020-04-29 | Washington | Texas | 48477 | 140 | 14 |
97800 | 97800 | 2020-04-28 | Washington | Texas | 48477 | 136 | 11 |
94958 | 94958 | 2020-04-27 | Washington | Texas | 48477 | 113 | 11 |
92129 | 92129 | 2020-04-26 | Washington | Texas | 48477 | 113 | 11 |
89312 | 89312 | 2020-04-25 | Washington | Texas | 48477 | 103 | 11 |
86497 | 86497 | 2020-04-24 | Washington | Texas | 48477 | 78 | 6 |
83690 | 83690 | 2020-04-23 | Washington | Texas | 48477 | 77 | 6 |
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);