ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Washington" and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636783 | 636783 | 2020-10-16 | Washington | New York | 36115 | 325 | 14 |
633537 | 633537 | 2020-10-15 | Washington | New York | 36115 | 324 | 14 |
630292 | 630292 | 2020-10-14 | Washington | New York | 36115 | 322 | 14 |
627048 | 627048 | 2020-10-13 | Washington | New York | 36115 | 319 | 14 |
623806 | 623806 | 2020-10-12 | Washington | New York | 36115 | 318 | 14 |
620563 | 620563 | 2020-10-11 | Washington | New York | 36115 | 317 | 14 |
617321 | 617321 | 2020-10-10 | Washington | New York | 36115 | 317 | 14 |
614079 | 614079 | 2020-10-09 | Washington | New York | 36115 | 317 | 14 |
610838 | 610838 | 2020-10-08 | Washington | New York | 36115 | 314 | 14 |
607596 | 607596 | 2020-10-07 | Washington | New York | 36115 | 311 | 14 |
604353 | 604353 | 2020-10-06 | Washington | New York | 36115 | 310 | 14 |
601111 | 601111 | 2020-10-05 | Washington | New York | 36115 | 307 | 14 |
597868 | 597868 | 2020-10-04 | Washington | New York | 36115 | 307 | 14 |
594625 | 594625 | 2020-10-03 | Washington | New York | 36115 | 307 | 14 |
591384 | 591384 | 2020-10-02 | Washington | New York | 36115 | 305 | 14 |
588143 | 588143 | 2020-10-01 | Washington | New York | 36115 | 302 | 14 |
584903 | 584903 | 2020-09-30 | Washington | New York | 36115 | 302 | 14 |
581662 | 581662 | 2020-09-29 | Washington | New York | 36115 | 301 | 14 |
578422 | 578422 | 2020-09-28 | Washington | New York | 36115 | 299 | 14 |
575181 | 575181 | 2020-09-27 | Washington | New York | 36115 | 296 | 14 |
571937 | 571937 | 2020-09-26 | Washington | New York | 36115 | 296 | 14 |
568695 | 568695 | 2020-09-25 | Washington | New York | 36115 | 294 | 14 |
565454 | 565454 | 2020-09-24 | Washington | New York | 36115 | 294 | 14 |
562213 | 562213 | 2020-09-23 | Washington | New York | 36115 | 289 | 14 |
558976 | 558976 | 2020-09-22 | Washington | New York | 36115 | 288 | 14 |
555739 | 555739 | 2020-09-21 | Washington | New York | 36115 | 287 | 14 |
552502 | 552502 | 2020-09-20 | Washington | New York | 36115 | 287 | 14 |
549263 | 549263 | 2020-09-19 | Washington | New York | 36115 | 287 | 14 |
546024 | 546024 | 2020-09-18 | Washington | New York | 36115 | 287 | 14 |
542787 | 542787 | 2020-09-17 | Washington | New York | 36115 | 287 | 14 |
539551 | 539551 | 2020-09-16 | Washington | New York | 36115 | 286 | 14 |
536314 | 536314 | 2020-09-15 | Washington | New York | 36115 | 284 | 14 |
533078 | 533078 | 2020-09-14 | Washington | New York | 36115 | 284 | 14 |
529843 | 529843 | 2020-09-13 | Washington | New York | 36115 | 284 | 14 |
526606 | 526606 | 2020-09-12 | Washington | New York | 36115 | 283 | 14 |
523370 | 523370 | 2020-09-11 | Washington | New York | 36115 | 275 | 14 |
520134 | 520134 | 2020-09-10 | Washington | New York | 36115 | 272 | 14 |
516898 | 516898 | 2020-09-09 | Washington | New York | 36115 | 272 | 14 |
513663 | 513663 | 2020-09-08 | Washington | New York | 36115 | 271 | 14 |
510430 | 510430 | 2020-09-07 | Washington | New York | 36115 | 270 | 14 |
507197 | 507197 | 2020-09-06 | Washington | New York | 36115 | 270 | 14 |
503965 | 503965 | 2020-09-05 | Washington | New York | 36115 | 269 | 14 |
500731 | 500731 | 2020-09-04 | Washington | New York | 36115 | 269 | 14 |
497497 | 497497 | 2020-09-03 | Washington | New York | 36115 | 268 | 14 |
494264 | 494264 | 2020-09-02 | Washington | New York | 36115 | 268 | 14 |
491030 | 491030 | 2020-09-01 | Washington | New York | 36115 | 268 | 14 |
487797 | 487797 | 2020-08-31 | Washington | New York | 36115 | 267 | 14 |
484564 | 484564 | 2020-08-30 | Washington | New York | 36115 | 267 | 14 |
481329 | 481329 | 2020-08-29 | Washington | New York | 36115 | 267 | 14 |
478096 | 478096 | 2020-08-28 | Washington | New York | 36115 | 267 | 14 |
474863 | 474863 | 2020-08-27 | Washington | New York | 36115 | 266 | 14 |
471629 | 471629 | 2020-08-26 | Washington | New York | 36115 | 266 | 14 |
468397 | 468397 | 2020-08-25 | Washington | New York | 36115 | 266 | 14 |
465169 | 465169 | 2020-08-24 | Washington | New York | 36115 | 266 | 14 |
461940 | 461940 | 2020-08-23 | Washington | New York | 36115 | 266 | 14 |
458712 | 458712 | 2020-08-22 | Washington | New York | 36115 | 266 | 14 |
455484 | 455484 | 2020-08-21 | Washington | New York | 36115 | 264 | 14 |
452256 | 452256 | 2020-08-20 | Washington | New York | 36115 | 264 | 14 |
449028 | 449028 | 2020-08-19 | Washington | New York | 36115 | 262 | 14 |
445800 | 445800 | 2020-08-18 | Washington | New York | 36115 | 262 | 14 |
442574 | 442574 | 2020-08-17 | Washington | New York | 36115 | 261 | 14 |
439347 | 439347 | 2020-08-16 | Washington | New York | 36115 | 261 | 14 |
436122 | 436122 | 2020-08-15 | Washington | New York | 36115 | 261 | 14 |
432896 | 432896 | 2020-08-14 | Washington | New York | 36115 | 260 | 14 |
429670 | 429670 | 2020-08-13 | Washington | New York | 36115 | 260 | 14 |
426445 | 426445 | 2020-08-12 | Washington | New York | 36115 | 260 | 14 |
423222 | 423222 | 2020-08-11 | Washington | New York | 36115 | 260 | 14 |
419999 | 419999 | 2020-08-10 | Washington | New York | 36115 | 260 | 14 |
416779 | 416779 | 2020-08-09 | Washington | New York | 36115 | 259 | 14 |
413558 | 413558 | 2020-08-08 | Washington | New York | 36115 | 257 | 14 |
410338 | 410338 | 2020-08-07 | Washington | New York | 36115 | 256 | 14 |
407118 | 407118 | 2020-08-06 | Washington | New York | 36115 | 256 | 14 |
403899 | 403899 | 2020-08-05 | Washington | New York | 36115 | 255 | 11 |
400681 | 400681 | 2020-08-04 | Washington | New York | 36115 | 255 | 11 |
397466 | 397466 | 2020-08-03 | Washington | New York | 36115 | 255 | 11 |
394249 | 394249 | 2020-08-02 | Washington | New York | 36115 | 255 | 11 |
391033 | 391033 | 2020-08-01 | Washington | New York | 36115 | 255 | 11 |
387816 | 387816 | 2020-07-31 | Washington | New York | 36115 | 254 | 11 |
384599 | 384599 | 2020-07-30 | Washington | New York | 36115 | 254 | 11 |
381381 | 381381 | 2020-07-29 | Washington | New York | 36115 | 254 | 11 |
378164 | 378164 | 2020-07-28 | Washington | New York | 36115 | 254 | 11 |
374948 | 374948 | 2020-07-27 | Washington | New York | 36115 | 254 | 11 |
371736 | 371736 | 2020-07-26 | Washington | New York | 36115 | 253 | 11 |
368524 | 368524 | 2020-07-25 | Washington | New York | 36115 | 252 | 11 |
365315 | 365315 | 2020-07-24 | Washington | New York | 36115 | 252 | 11 |
362109 | 362109 | 2020-07-23 | Washington | New York | 36115 | 252 | 11 |
358903 | 358903 | 2020-07-22 | Washington | New York | 36115 | 251 | 11 |
355699 | 355699 | 2020-07-21 | Washington | New York | 36115 | 250 | 11 |
352496 | 352496 | 2020-07-20 | Washington | New York | 36115 | 250 | 11 |
349293 | 349293 | 2020-07-19 | Washington | New York | 36115 | 250 | 11 |
346092 | 346092 | 2020-07-18 | Washington | New York | 36115 | 250 | 11 |
342893 | 342893 | 2020-07-17 | Washington | New York | 36115 | 250 | 11 |
339695 | 339695 | 2020-07-16 | Washington | New York | 36115 | 250 | 11 |
336499 | 336499 | 2020-07-15 | Washington | New York | 36115 | 250 | 11 |
333305 | 333305 | 2020-07-14 | Washington | New York | 36115 | 250 | 11 |
330115 | 330115 | 2020-07-13 | Washington | New York | 36115 | 249 | 11 |
326928 | 326928 | 2020-07-12 | Washington | New York | 36115 | 249 | 11 |
323744 | 323744 | 2020-07-11 | Washington | New York | 36115 | 249 | 11 |
320564 | 320564 | 2020-07-10 | Washington | New York | 36115 | 249 | 11 |
317387 | 317387 | 2020-07-09 | Washington | New York | 36115 | 248 | 11 |
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);