ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Washington" and fips = 18175 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635674 | 635674 | 2020-10-16 | Washington | Indiana | 18175 | 339 | 2 |
632428 | 632428 | 2020-10-15 | Washington | Indiana | 18175 | 322 | 2 |
629184 | 629184 | 2020-10-14 | Washington | Indiana | 18175 | 317 | 2 |
625941 | 625941 | 2020-10-13 | Washington | Indiana | 18175 | 314 | 2 |
622699 | 622699 | 2020-10-12 | Washington | Indiana | 18175 | 310 | 2 |
619455 | 619455 | 2020-10-11 | Washington | Indiana | 18175 | 308 | 2 |
616213 | 616213 | 2020-10-10 | Washington | Indiana | 18175 | 305 | 2 |
612972 | 612972 | 2020-10-09 | Washington | Indiana | 18175 | 304 | 2 |
609730 | 609730 | 2020-10-08 | Washington | Indiana | 18175 | 298 | 2 |
606487 | 606487 | 2020-10-07 | Washington | Indiana | 18175 | 292 | 2 |
603245 | 603245 | 2020-10-06 | Washington | Indiana | 18175 | 290 | 2 |
600002 | 600002 | 2020-10-05 | Washington | Indiana | 18175 | 288 | 2 |
596760 | 596760 | 2020-10-04 | Washington | Indiana | 18175 | 287 | 2 |
593518 | 593518 | 2020-10-03 | Washington | Indiana | 18175 | 284 | 2 |
590277 | 590277 | 2020-10-02 | Washington | Indiana | 18175 | 278 | 2 |
587036 | 587036 | 2020-10-01 | Washington | Indiana | 18175 | 273 | 2 |
583796 | 583796 | 2020-09-30 | Washington | Indiana | 18175 | 270 | 2 |
580557 | 580557 | 2020-09-29 | Washington | Indiana | 18175 | 270 | 2 |
577316 | 577316 | 2020-09-28 | Washington | Indiana | 18175 | 270 | 1 |
574074 | 574074 | 2020-09-27 | Washington | Indiana | 18175 | 269 | 1 |
570831 | 570831 | 2020-09-26 | Washington | Indiana | 18175 | 266 | 1 |
567589 | 567589 | 2020-09-25 | Washington | Indiana | 18175 | 265 | 1 |
564349 | 564349 | 2020-09-24 | Washington | Indiana | 18175 | 263 | 1 |
561109 | 561109 | 2020-09-23 | Washington | Indiana | 18175 | 261 | 1 |
557873 | 557873 | 2020-09-22 | Washington | Indiana | 18175 | 261 | 1 |
554636 | 554636 | 2020-09-21 | Washington | Indiana | 18175 | 259 | 1 |
551397 | 551397 | 2020-09-20 | Washington | Indiana | 18175 | 258 | 1 |
548158 | 548158 | 2020-09-19 | Washington | Indiana | 18175 | 257 | 1 |
544920 | 544920 | 2020-09-18 | Washington | Indiana | 18175 | 251 | 1 |
541684 | 541684 | 2020-09-17 | Washington | Indiana | 18175 | 249 | 1 |
538447 | 538447 | 2020-09-16 | Washington | Indiana | 18175 | 249 | 1 |
535211 | 535211 | 2020-09-15 | Washington | Indiana | 18175 | 248 | 1 |
531976 | 531976 | 2020-09-14 | Washington | Indiana | 18175 | 245 | 1 |
528739 | 528739 | 2020-09-13 | Washington | Indiana | 18175 | 243 | 1 |
525503 | 525503 | 2020-09-12 | Washington | Indiana | 18175 | 243 | 1 |
522267 | 522267 | 2020-09-11 | Washington | Indiana | 18175 | 244 | 1 |
519030 | 519030 | 2020-09-10 | Washington | Indiana | 18175 | 243 | 1 |
515795 | 515795 | 2020-09-09 | Washington | Indiana | 18175 | 243 | 1 |
512562 | 512562 | 2020-09-08 | Washington | Indiana | 18175 | 240 | 1 |
509329 | 509329 | 2020-09-07 | Washington | Indiana | 18175 | 240 | 1 |
506097 | 506097 | 2020-09-06 | Washington | Indiana | 18175 | 239 | 1 |
502863 | 502863 | 2020-09-05 | Washington | Indiana | 18175 | 239 | 1 |
499629 | 499629 | 2020-09-04 | Washington | Indiana | 18175 | 239 | 1 |
496396 | 496396 | 2020-09-03 | Washington | Indiana | 18175 | 237 | 1 |
493162 | 493162 | 2020-09-02 | Washington | Indiana | 18175 | 234 | 1 |
489929 | 489929 | 2020-09-01 | Washington | Indiana | 18175 | 229 | 1 |
486696 | 486696 | 2020-08-31 | Washington | Indiana | 18175 | 225 | 1 |
483461 | 483461 | 2020-08-30 | Washington | Indiana | 18175 | 218 | 1 |
480227 | 480227 | 2020-08-29 | Washington | Indiana | 18175 | 214 | 1 |
476994 | 476994 | 2020-08-28 | Washington | Indiana | 18175 | 207 | 1 |
473761 | 473761 | 2020-08-27 | Washington | Indiana | 18175 | 205 | 1 |
470529 | 470529 | 2020-08-26 | Washington | Indiana | 18175 | 199 | 1 |
467300 | 467300 | 2020-08-25 | Washington | Indiana | 18175 | 195 | 1 |
464071 | 464071 | 2020-08-24 | Washington | Indiana | 18175 | 190 | 1 |
460842 | 460842 | 2020-08-23 | Washington | Indiana | 18175 | 184 | 1 |
457615 | 457615 | 2020-08-22 | Washington | Indiana | 18175 | 179 | 1 |
454387 | 454387 | 2020-08-21 | Washington | Indiana | 18175 | 170 | 1 |
451159 | 451159 | 2020-08-20 | Washington | Indiana | 18175 | 167 | 1 |
447931 | 447931 | 2020-08-19 | Washington | Indiana | 18175 | 163 | 1 |
444704 | 444704 | 2020-08-18 | Washington | Indiana | 18175 | 162 | 1 |
441478 | 441478 | 2020-08-17 | Washington | Indiana | 18175 | 162 | 1 |
438252 | 438252 | 2020-08-16 | Washington | Indiana | 18175 | 159 | 1 |
435026 | 435026 | 2020-08-15 | Washington | Indiana | 18175 | 159 | 1 |
431801 | 431801 | 2020-08-14 | Washington | Indiana | 18175 | 153 | 1 |
428573 | 428573 | 2020-08-13 | Washington | Indiana | 18175 | 148 | 1 |
425349 | 425349 | 2020-08-12 | Washington | Indiana | 18175 | 144 | 1 |
422128 | 422128 | 2020-08-11 | Washington | Indiana | 18175 | 142 | 1 |
418905 | 418905 | 2020-08-10 | Washington | Indiana | 18175 | 142 | 1 |
415684 | 415684 | 2020-08-09 | Washington | Indiana | 18175 | 140 | 1 |
412464 | 412464 | 2020-08-08 | Washington | Indiana | 18175 | 139 | 1 |
409245 | 409245 | 2020-08-07 | Washington | Indiana | 18175 | 131 | 1 |
406025 | 406025 | 2020-08-06 | Washington | Indiana | 18175 | 121 | 1 |
402807 | 402807 | 2020-08-05 | Washington | Indiana | 18175 | 117 | 1 |
399591 | 399591 | 2020-08-04 | Washington | Indiana | 18175 | 117 | 1 |
396375 | 396375 | 2020-08-03 | Washington | Indiana | 18175 | 116 | 1 |
393159 | 393159 | 2020-08-02 | Washington | Indiana | 18175 | 115 | 1 |
389942 | 389942 | 2020-08-01 | Washington | Indiana | 18175 | 107 | 1 |
386725 | 386725 | 2020-07-31 | Washington | Indiana | 18175 | 104 | 1 |
383507 | 383507 | 2020-07-30 | Washington | Indiana | 18175 | 99 | 1 |
380290 | 380290 | 2020-07-29 | Washington | Indiana | 18175 | 96 | 1 |
377073 | 377073 | 2020-07-28 | Washington | Indiana | 18175 | 91 | 1 |
373858 | 373858 | 2020-07-27 | Washington | Indiana | 18175 | 88 | 1 |
370646 | 370646 | 2020-07-26 | Washington | Indiana | 18175 | 87 | 1 |
367436 | 367436 | 2020-07-25 | Washington | Indiana | 18175 | 84 | 1 |
364229 | 364229 | 2020-07-24 | Washington | Indiana | 18175 | 82 | 1 |
361022 | 361022 | 2020-07-23 | Washington | Indiana | 18175 | 78 | 1 |
357817 | 357817 | 2020-07-22 | Washington | Indiana | 18175 | 77 | 1 |
354615 | 354615 | 2020-07-21 | Washington | Indiana | 18175 | 77 | 1 |
351413 | 351413 | 2020-07-20 | Washington | Indiana | 18175 | 77 | 1 |
348213 | 348213 | 2020-07-19 | Washington | Indiana | 18175 | 78 | 1 |
345012 | 345012 | 2020-07-18 | Washington | Indiana | 18175 | 74 | 1 |
341812 | 341812 | 2020-07-17 | Washington | Indiana | 18175 | 72 | 1 |
338616 | 338616 | 2020-07-16 | Washington | Indiana | 18175 | 70 | 1 |
335420 | 335420 | 2020-07-15 | Washington | Indiana | 18175 | 70 | 1 |
332227 | 332227 | 2020-07-14 | Washington | Indiana | 18175 | 68 | 1 |
329040 | 329040 | 2020-07-13 | Washington | Indiana | 18175 | 68 | 1 |
325854 | 325854 | 2020-07-12 | Washington | Indiana | 18175 | 68 | 1 |
322673 | 322673 | 2020-07-11 | Washington | Indiana | 18175 | 68 | 1 |
319494 | 319494 | 2020-07-10 | Washington | Indiana | 18175 | 68 | 1 |
316321 | 316321 | 2020-07-09 | Washington | Indiana | 18175 | 67 | 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);