ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where county = "Washington" and state = "Idaho" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635483 | 635483 | 2020-10-16 | Washington | Idaho | 16087 | 420 | 7 |
632237 | 632237 | 2020-10-15 | Washington | Idaho | 16087 | 417 | 7 |
628993 | 628993 | 2020-10-14 | Washington | Idaho | 16087 | 411 | 7 |
625750 | 625750 | 2020-10-13 | Washington | Idaho | 16087 | 409 | 7 |
622508 | 622508 | 2020-10-12 | Washington | Idaho | 16087 | 400 | 7 |
619264 | 619264 | 2020-10-11 | Washington | Idaho | 16087 | 400 | 7 |
616022 | 616022 | 2020-10-10 | Washington | Idaho | 16087 | 400 | 7 |
612781 | 612781 | 2020-10-09 | Washington | Idaho | 16087 | 400 | 6 |
609539 | 609539 | 2020-10-08 | Washington | Idaho | 16087 | 395 | 6 |
606296 | 606296 | 2020-10-07 | Washington | Idaho | 16087 | 393 | 6 |
603054 | 603054 | 2020-10-06 | Washington | Idaho | 16087 | 389 | 6 |
599811 | 599811 | 2020-10-05 | Washington | Idaho | 16087 | 389 | 6 |
596569 | 596569 | 2020-10-04 | Washington | Idaho | 16087 | 384 | 6 |
593327 | 593327 | 2020-10-03 | Washington | Idaho | 16087 | 384 | 6 |
590086 | 590086 | 2020-10-02 | Washington | Idaho | 16087 | 384 | 6 |
586845 | 586845 | 2020-10-01 | Washington | Idaho | 16087 | 381 | 6 |
583605 | 583605 | 2020-09-30 | Washington | Idaho | 16087 | 373 | 6 |
580366 | 580366 | 2020-09-29 | Washington | Idaho | 16087 | 367 | 6 |
577125 | 577125 | 2020-09-28 | Washington | Idaho | 16087 | 363 | 6 |
573883 | 573883 | 2020-09-27 | Washington | Idaho | 16087 | 357 | 6 |
570640 | 570640 | 2020-09-26 | Washington | Idaho | 16087 | 357 | 6 |
567398 | 567398 | 2020-09-25 | Washington | Idaho | 16087 | 357 | 6 |
564158 | 564158 | 2020-09-24 | Washington | Idaho | 16087 | 357 | 6 |
560918 | 560918 | 2020-09-23 | Washington | Idaho | 16087 | 349 | 6 |
557682 | 557682 | 2020-09-22 | Washington | Idaho | 16087 | 342 | 5 |
554445 | 554445 | 2020-09-21 | Washington | Idaho | 16087 | 336 | 5 |
551206 | 551206 | 2020-09-20 | Washington | Idaho | 16087 | 333 | 5 |
547967 | 547967 | 2020-09-19 | Washington | Idaho | 16087 | 328 | 4 |
544729 | 544729 | 2020-09-18 | Washington | Idaho | 16087 | 328 | 4 |
541493 | 541493 | 2020-09-17 | Washington | Idaho | 16087 | 324 | 4 |
538256 | 538256 | 2020-09-16 | Washington | Idaho | 16087 | 322 | 4 |
535020 | 535020 | 2020-09-15 | Washington | Idaho | 16087 | 322 | 4 |
531785 | 531785 | 2020-09-14 | Washington | Idaho | 16087 | 321 | 4 |
528548 | 528548 | 2020-09-13 | Washington | Idaho | 16087 | 318 | 4 |
525312 | 525312 | 2020-09-12 | Washington | Idaho | 16087 | 318 | 4 |
522076 | 522076 | 2020-09-11 | Washington | Idaho | 16087 | 318 | 4 |
518839 | 518839 | 2020-09-10 | Washington | Idaho | 16087 | 316 | 4 |
515604 | 515604 | 2020-09-09 | Washington | Idaho | 16087 | 312 | 4 |
512371 | 512371 | 2020-09-08 | Washington | Idaho | 16087 | 308 | 4 |
509138 | 509138 | 2020-09-07 | Washington | Idaho | 16087 | 304 | 4 |
505906 | 505906 | 2020-09-06 | Washington | Idaho | 16087 | 304 | 4 |
502672 | 502672 | 2020-09-05 | Washington | Idaho | 16087 | 303 | 4 |
499438 | 499438 | 2020-09-04 | Washington | Idaho | 16087 | 300 | 4 |
496205 | 496205 | 2020-09-03 | Washington | Idaho | 16087 | 293 | 4 |
492971 | 492971 | 2020-09-02 | Washington | Idaho | 16087 | 288 | 4 |
489738 | 489738 | 2020-09-01 | Washington | Idaho | 16087 | 284 | 4 |
486505 | 486505 | 2020-08-31 | Washington | Idaho | 16087 | 278 | 4 |
483270 | 483270 | 2020-08-30 | Washington | Idaho | 16087 | 271 | 4 |
480036 | 480036 | 2020-08-29 | Washington | Idaho | 16087 | 268 | 4 |
476803 | 476803 | 2020-08-28 | Washington | Idaho | 16087 | 267 | 4 |
473570 | 473570 | 2020-08-27 | Washington | Idaho | 16087 | 263 | 4 |
470338 | 470338 | 2020-08-26 | Washington | Idaho | 16087 | 263 | 4 |
467109 | 467109 | 2020-08-25 | Washington | Idaho | 16087 | 258 | 3 |
463880 | 463880 | 2020-08-24 | Washington | Idaho | 16087 | 257 | 3 |
460651 | 460651 | 2020-08-23 | Washington | Idaho | 16087 | 256 | 3 |
457424 | 457424 | 2020-08-22 | Washington | Idaho | 16087 | 254 | 3 |
454196 | 454196 | 2020-08-21 | Washington | Idaho | 16087 | 253 | 3 |
450968 | 450968 | 2020-08-20 | Washington | Idaho | 16087 | 253 | 3 |
447740 | 447740 | 2020-08-19 | Washington | Idaho | 16087 | 246 | 3 |
444513 | 444513 | 2020-08-18 | Washington | Idaho | 16087 | 244 | 3 |
441287 | 441287 | 2020-08-17 | Washington | Idaho | 16087 | 241 | 3 |
438061 | 438061 | 2020-08-16 | Washington | Idaho | 16087 | 238 | 3 |
434835 | 434835 | 2020-08-15 | Washington | Idaho | 16087 | 234 | 3 |
431610 | 431610 | 2020-08-14 | Washington | Idaho | 16087 | 229 | 3 |
428382 | 428382 | 2020-08-13 | Washington | Idaho | 16087 | 224 | 3 |
425158 | 425158 | 2020-08-12 | Washington | Idaho | 16087 | 217 | 3 |
421937 | 421937 | 2020-08-11 | Washington | Idaho | 16087 | 216 | 3 |
418714 | 418714 | 2020-08-10 | Washington | Idaho | 16087 | 209 | 3 |
415493 | 415493 | 2020-08-09 | Washington | Idaho | 16087 | 205 | 3 |
412273 | 412273 | 2020-08-08 | Washington | Idaho | 16087 | 203 | 3 |
409054 | 409054 | 2020-08-07 | Washington | Idaho | 16087 | 201 | 3 |
405834 | 405834 | 2020-08-06 | Washington | Idaho | 16087 | 200 | 3 |
402616 | 402616 | 2020-08-05 | Washington | Idaho | 16087 | 196 | 3 |
399400 | 399400 | 2020-08-04 | Washington | Idaho | 16087 | 194 | 3 |
396184 | 396184 | 2020-08-03 | Washington | Idaho | 16087 | 191 | 2 |
392968 | 392968 | 2020-08-02 | Washington | Idaho | 16087 | 190 | 2 |
389751 | 389751 | 2020-08-01 | Washington | Idaho | 16087 | 189 | 2 |
386534 | 386534 | 2020-07-31 | Washington | Idaho | 16087 | 183 | 2 |
383316 | 383316 | 2020-07-30 | Washington | Idaho | 16087 | 181 | 2 |
380099 | 380099 | 2020-07-29 | Washington | Idaho | 16087 | 177 | 2 |
376882 | 376882 | 2020-07-28 | Washington | Idaho | 16087 | 171 | 2 |
373667 | 373667 | 2020-07-27 | Washington | Idaho | 16087 | 167 | 2 |
370455 | 370455 | 2020-07-26 | Washington | Idaho | 16087 | 166 | 2 |
367245 | 367245 | 2020-07-25 | Washington | Idaho | 16087 | 162 | 2 |
364038 | 364038 | 2020-07-24 | Washington | Idaho | 16087 | 162 | 2 |
360831 | 360831 | 2020-07-23 | Washington | Idaho | 16087 | 159 | 2 |
357626 | 357626 | 2020-07-22 | Washington | Idaho | 16087 | 159 | 2 |
354424 | 354424 | 2020-07-21 | Washington | Idaho | 16087 | 152 | 2 |
351222 | 351222 | 2020-07-20 | Washington | Idaho | 16087 | 149 | 2 |
348022 | 348022 | 2020-07-19 | Washington | Idaho | 16087 | 147 | 2 |
344821 | 344821 | 2020-07-18 | Washington | Idaho | 16087 | 146 | 2 |
341621 | 341621 | 2020-07-17 | Washington | Idaho | 16087 | 144 | 2 |
338425 | 338425 | 2020-07-16 | Washington | Idaho | 16087 | 138 | 2 |
335229 | 335229 | 2020-07-15 | Washington | Idaho | 16087 | 135 | 2 |
332036 | 332036 | 2020-07-14 | Washington | Idaho | 16087 | 132 | 2 |
328849 | 328849 | 2020-07-13 | Washington | Idaho | 16087 | 131 | 2 |
325663 | 325663 | 2020-07-12 | Washington | Idaho | 16087 | 131 | 2 |
322482 | 322482 | 2020-07-11 | Washington | Idaho | 16087 | 131 | 2 |
319303 | 319303 | 2020-07-10 | Washington | Idaho | 16087 | 130 | 2 |
316130 | 316130 | 2020-07-09 | Washington | Idaho | 16087 | 129 | 2 |
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);