ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Warren" 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 |
---|---|---|---|---|---|---|---|
636782 | 636782 | 2020-10-16 | Warren | New York | 36113 | 437 | 30 |
633536 | 633536 | 2020-10-15 | Warren | New York | 36113 | 434 | 30 |
630291 | 630291 | 2020-10-14 | Warren | New York | 36113 | 432 | 30 |
627047 | 627047 | 2020-10-13 | Warren | New York | 36113 | 431 | 30 |
623805 | 623805 | 2020-10-12 | Warren | New York | 36113 | 430 | 30 |
620562 | 620562 | 2020-10-11 | Warren | New York | 36113 | 429 | 30 |
617320 | 617320 | 2020-10-10 | Warren | New York | 36113 | 429 | 30 |
614078 | 614078 | 2020-10-09 | Warren | New York | 36113 | 429 | 30 |
610837 | 610837 | 2020-10-08 | Warren | New York | 36113 | 427 | 30 |
607595 | 607595 | 2020-10-07 | Warren | New York | 36113 | 425 | 30 |
604352 | 604352 | 2020-10-06 | Warren | New York | 36113 | 419 | 30 |
601110 | 601110 | 2020-10-05 | Warren | New York | 36113 | 416 | 30 |
597867 | 597867 | 2020-10-04 | Warren | New York | 36113 | 413 | 30 |
594624 | 594624 | 2020-10-03 | Warren | New York | 36113 | 407 | 30 |
591383 | 591383 | 2020-10-02 | Warren | New York | 36113 | 395 | 30 |
588142 | 588142 | 2020-10-01 | Warren | New York | 36113 | 391 | 30 |
584902 | 584902 | 2020-09-30 | Warren | New York | 36113 | 391 | 30 |
581661 | 581661 | 2020-09-29 | Warren | New York | 36113 | 386 | 30 |
578421 | 578421 | 2020-09-28 | Warren | New York | 36113 | 383 | 30 |
575180 | 575180 | 2020-09-27 | Warren | New York | 36113 | 381 | 30 |
571936 | 571936 | 2020-09-26 | Warren | New York | 36113 | 377 | 30 |
568694 | 568694 | 2020-09-25 | Warren | New York | 36113 | 371 | 30 |
565453 | 565453 | 2020-09-24 | Warren | New York | 36113 | 369 | 30 |
562212 | 562212 | 2020-09-23 | Warren | New York | 36113 | 366 | 30 |
558975 | 558975 | 2020-09-22 | Warren | New York | 36113 | 363 | 30 |
555738 | 555738 | 2020-09-21 | Warren | New York | 36113 | 363 | 30 |
552501 | 552501 | 2020-09-20 | Warren | New York | 36113 | 360 | 30 |
549262 | 549262 | 2020-09-19 | Warren | New York | 36113 | 356 | 30 |
546023 | 546023 | 2020-09-18 | Warren | New York | 36113 | 354 | 30 |
542786 | 542786 | 2020-09-17 | Warren | New York | 36113 | 352 | 30 |
539550 | 539550 | 2020-09-16 | Warren | New York | 36113 | 351 | 30 |
536313 | 536313 | 2020-09-15 | Warren | New York | 36113 | 348 | 30 |
533077 | 533077 | 2020-09-14 | Warren | New York | 36113 | 348 | 30 |
529842 | 529842 | 2020-09-13 | Warren | New York | 36113 | 348 | 30 |
526605 | 526605 | 2020-09-12 | Warren | New York | 36113 | 348 | 30 |
523369 | 523369 | 2020-09-11 | Warren | New York | 36113 | 341 | 30 |
520133 | 520133 | 2020-09-10 | Warren | New York | 36113 | 332 | 30 |
516897 | 516897 | 2020-09-09 | Warren | New York | 36113 | 331 | 30 |
513662 | 513662 | 2020-09-08 | Warren | New York | 36113 | 331 | 30 |
510429 | 510429 | 2020-09-07 | Warren | New York | 36113 | 326 | 30 |
507196 | 507196 | 2020-09-06 | Warren | New York | 36113 | 326 | 30 |
503964 | 503964 | 2020-09-05 | Warren | New York | 36113 | 325 | 30 |
500730 | 500730 | 2020-09-04 | Warren | New York | 36113 | 324 | 30 |
497496 | 497496 | 2020-09-03 | Warren | New York | 36113 | 323 | 30 |
494263 | 494263 | 2020-09-02 | Warren | New York | 36113 | 322 | 30 |
491029 | 491029 | 2020-09-01 | Warren | New York | 36113 | 322 | 30 |
487796 | 487796 | 2020-08-31 | Warren | New York | 36113 | 321 | 30 |
484563 | 484563 | 2020-08-30 | Warren | New York | 36113 | 321 | 30 |
481328 | 481328 | 2020-08-29 | Warren | New York | 36113 | 321 | 30 |
478095 | 478095 | 2020-08-28 | Warren | New York | 36113 | 320 | 30 |
474862 | 474862 | 2020-08-27 | Warren | New York | 36113 | 318 | 30 |
471628 | 471628 | 2020-08-26 | Warren | New York | 36113 | 316 | 30 |
468396 | 468396 | 2020-08-25 | Warren | New York | 36113 | 316 | 30 |
465168 | 465168 | 2020-08-24 | Warren | New York | 36113 | 315 | 30 |
461939 | 461939 | 2020-08-23 | Warren | New York | 36113 | 315 | 30 |
458711 | 458711 | 2020-08-22 | Warren | New York | 36113 | 315 | 30 |
455483 | 455483 | 2020-08-21 | Warren | New York | 36113 | 314 | 30 |
452255 | 452255 | 2020-08-20 | Warren | New York | 36113 | 313 | 30 |
449027 | 449027 | 2020-08-19 | Warren | New York | 36113 | 313 | 30 |
445799 | 445799 | 2020-08-18 | Warren | New York | 36113 | 313 | 30 |
442573 | 442573 | 2020-08-17 | Warren | New York | 36113 | 312 | 30 |
439346 | 439346 | 2020-08-16 | Warren | New York | 36113 | 312 | 30 |
436121 | 436121 | 2020-08-15 | Warren | New York | 36113 | 312 | 30 |
432895 | 432895 | 2020-08-14 | Warren | New York | 36113 | 312 | 30 |
429669 | 429669 | 2020-08-13 | Warren | New York | 36113 | 312 | 30 |
426444 | 426444 | 2020-08-12 | Warren | New York | 36113 | 312 | 30 |
423221 | 423221 | 2020-08-11 | Warren | New York | 36113 | 312 | 30 |
419998 | 419998 | 2020-08-10 | Warren | New York | 36113 | 312 | 30 |
416778 | 416778 | 2020-08-09 | Warren | New York | 36113 | 308 | 30 |
413557 | 413557 | 2020-08-08 | Warren | New York | 36113 | 308 | 30 |
410337 | 410337 | 2020-08-07 | Warren | New York | 36113 | 307 | 30 |
407117 | 407117 | 2020-08-06 | Warren | New York | 36113 | 304 | 30 |
403898 | 403898 | 2020-08-05 | Warren | New York | 36113 | 304 | 31 |
400680 | 400680 | 2020-08-04 | Warren | New York | 36113 | 302 | 31 |
397465 | 397465 | 2020-08-03 | Warren | New York | 36113 | 300 | 31 |
394248 | 394248 | 2020-08-02 | Warren | New York | 36113 | 300 | 31 |
391032 | 391032 | 2020-08-01 | Warren | New York | 36113 | 300 | 31 |
387815 | 387815 | 2020-07-31 | Warren | New York | 36113 | 300 | 31 |
384598 | 384598 | 2020-07-30 | Warren | New York | 36113 | 298 | 31 |
381380 | 381380 | 2020-07-29 | Warren | New York | 36113 | 298 | 31 |
378163 | 378163 | 2020-07-28 | Warren | New York | 36113 | 298 | 31 |
374947 | 374947 | 2020-07-27 | Warren | New York | 36113 | 294 | 31 |
371735 | 371735 | 2020-07-26 | Warren | New York | 36113 | 294 | 31 |
368523 | 368523 | 2020-07-25 | Warren | New York | 36113 | 293 | 31 |
365314 | 365314 | 2020-07-24 | Warren | New York | 36113 | 292 | 31 |
362108 | 362108 | 2020-07-23 | Warren | New York | 36113 | 290 | 31 |
358902 | 358902 | 2020-07-22 | Warren | New York | 36113 | 288 | 31 |
355698 | 355698 | 2020-07-21 | Warren | New York | 36113 | 288 | 31 |
352495 | 352495 | 2020-07-20 | Warren | New York | 36113 | 287 | 31 |
349292 | 349292 | 2020-07-19 | Warren | New York | 36113 | 287 | 31 |
346091 | 346091 | 2020-07-18 | Warren | New York | 36113 | 286 | 31 |
342892 | 342892 | 2020-07-17 | Warren | New York | 36113 | 286 | 31 |
339694 | 339694 | 2020-07-16 | Warren | New York | 36113 | 285 | 31 |
336498 | 336498 | 2020-07-15 | Warren | New York | 36113 | 284 | 31 |
333304 | 333304 | 2020-07-14 | Warren | New York | 36113 | 280 | 31 |
330114 | 330114 | 2020-07-13 | Warren | New York | 36113 | 280 | 31 |
326927 | 326927 | 2020-07-12 | Warren | New York | 36113 | 277 | 31 |
323743 | 323743 | 2020-07-11 | Warren | New York | 36113 | 274 | 31 |
320563 | 320563 | 2020-07-10 | Warren | New York | 36113 | 274 | 31 |
317386 | 317386 | 2020-07-09 | Warren | New York | 36113 | 273 | 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);