ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
814 rows where fips = "" 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 |
---|---|---|---|---|---|---|---|
636758 | 636758 | 2020-10-16 | New York City | New York | 257642 | 23915 | |
633512 | 633512 | 2020-10-15 | New York City | New York | 256986 | 23915 | |
630267 | 630267 | 2020-10-14 | New York City | New York | 256474 | 23905 | |
627023 | 627023 | 2020-10-13 | New York City | New York | 256007 | 23895 | |
623781 | 623781 | 2020-10-12 | New York City | New York | 255464 | 23890 | |
620538 | 620538 | 2020-10-11 | New York City | New York | 255068 | 23883 | |
617296 | 617296 | 2020-10-10 | New York City | New York | 254599 | 23882 | |
614054 | 614054 | 2020-10-09 | New York City | New York | 254023 | 23879 | |
610813 | 610813 | 2020-10-08 | New York City | New York | 253398 | 23874 | |
607571 | 607571 | 2020-10-07 | New York City | New York | 252703 | 23873 | |
604328 | 604328 | 2020-10-06 | New York City | New York | 252159 | 23866 | |
601086 | 601086 | 2020-10-05 | New York City | New York | 251591 | 23861 | |
597843 | 597843 | 2020-10-04 | New York City | New York | 251119 | 23852 | |
594600 | 594600 | 2020-10-03 | New York City | New York | 250583 | 23844 | |
591359 | 591359 | 2020-10-02 | New York City | New York | 249874 | 23846 | |
588118 | 588118 | 2020-10-01 | New York City | New York | 249272 | 23829 | |
584878 | 584878 | 2020-09-30 | New York City | New York | 248738 | 23823 | |
581637 | 581637 | 2020-09-29 | New York City | New York | 248287 | 23814 | |
578397 | 578397 | 2020-09-28 | New York City | New York | 247765 | 23810 | |
575156 | 575156 | 2020-09-27 | New York City | New York | 247384 | 23801 | |
571912 | 571912 | 2020-09-26 | New York City | New York | 247000 | 23795 | |
568670 | 568670 | 2020-09-25 | New York City | New York | 246570 | 23792 | |
565429 | 565429 | 2020-09-24 | New York City | New York | 246198 | 23785 | |
562188 | 562188 | 2020-09-23 | New York City | New York | 245776 | 23780 | |
558951 | 558951 | 2020-09-22 | New York City | New York | 245495 | 23780 | |
555714 | 555714 | 2020-09-21 | New York City | New York | 245147 | 23782 | |
552477 | 552477 | 2020-09-20 | New York City | New York | 244885 | 23777 | |
549238 | 549238 | 2020-09-19 | New York City | New York | 244484 | 23771 | |
545999 | 545999 | 2020-09-18 | New York City | New York | 243995 | 23775 | |
542762 | 542762 | 2020-09-17 | New York City | New York | 243644 | 23767 | |
539526 | 539526 | 2020-09-16 | New York City | New York | 243314 | 23762 | |
536289 | 536289 | 2020-09-15 | New York City | New York | 243061 | 23758 | |
533053 | 533053 | 2020-09-14 | New York City | New York | 242754 | 23750 | |
529818 | 529818 | 2020-09-13 | New York City | New York | 242486 | 23743 | |
526581 | 526581 | 2020-09-12 | New York City | New York | 242242 | 23743 | |
523345 | 523345 | 2020-09-11 | New York City | New York | 241936 | 23739 | |
520109 | 520109 | 2020-09-10 | New York City | New York | 241686 | 23741 | |
516873 | 516873 | 2020-09-09 | New York City | New York | 241351 | 23741 | |
513638 | 513638 | 2020-09-08 | New York City | New York | 241141 | 23744 | |
510405 | 510405 | 2020-09-07 | New York City | New York | 240919 | 23736 | |
507172 | 507172 | 2020-09-06 | New York City | New York | 240711 | 23721 | |
503940 | 503940 | 2020-09-05 | New York City | New York | 240416 | 23721 | |
500706 | 500706 | 2020-09-04 | New York City | New York | 240139 | 23716 | |
497472 | 497472 | 2020-09-03 | New York City | New York | 239815 | 23710 | |
494239 | 494239 | 2020-09-02 | New York City | New York | 239512 | 23708 | |
491005 | 491005 | 2020-09-01 | New York City | New York | 239246 | 23703 | |
487772 | 487772 | 2020-08-31 | New York City | New York | 238938 | 23695 | |
484539 | 484539 | 2020-08-30 | New York City | New York | 238677 | 23689 | |
481304 | 481304 | 2020-08-29 | New York City | New York | 238385 | 23683 | |
478071 | 478071 | 2020-08-28 | New York City | New York | 238107 | 23680 | |
474838 | 474838 | 2020-08-27 | New York City | New York | 237838 | 23674 | |
471604 | 471604 | 2020-08-26 | New York City | New York | 237525 | 23669 | |
468372 | 468372 | 2020-08-25 | New York City | New York | 237263 | 23666 | |
465144 | 465144 | 2020-08-24 | New York City | New York | 237032 | 23662 | |
461915 | 461915 | 2020-08-23 | New York City | New York | 236822 | 23658 | |
458687 | 458687 | 2020-08-22 | New York City | New York | 236534 | 23646 | |
455459 | 455459 | 2020-08-21 | New York City | New York | 236269 | 23641 | |
452231 | 452231 | 2020-08-20 | New York City | New York | 235985 | 23639 | |
449003 | 449003 | 2020-08-19 | New York City | New York | 235714 | 23643 | |
445775 | 445775 | 2020-08-18 | New York City | New York | 235446 | 23642 | |
442549 | 442549 | 2020-08-17 | New York City | New York | 235155 | 23634 | |
439322 | 439322 | 2020-08-16 | New York City | New York | 234918 | 23628 | |
436097 | 436097 | 2020-08-15 | New York City | New York | 234609 | 23621 | |
432871 | 432871 | 2020-08-14 | New York City | New York | 234223 | 23615 | |
429645 | 429645 | 2020-08-13 | New York City | New York | 233859 | 23610 | |
426420 | 426420 | 2020-08-12 | New York City | New York | 233422 | 23602 | |
423197 | 423197 | 2020-08-11 | New York City | New York | 233030 | 23592 | |
419974 | 419974 | 2020-08-10 | New York City | New York | 232756 | 23586 | |
416754 | 416754 | 2020-08-09 | New York City | New York | 232517 | 23580 | |
413533 | 413533 | 2020-08-08 | New York City | New York | 232271 | 23575 | |
410313 | 410313 | 2020-08-07 | New York City | New York | 231942 | 23567 | |
407093 | 407093 | 2020-08-06 | New York City | New York | 231600 | 23563 | |
403874 | 403874 | 2020-08-05 | New York City | New York | 231268 | 23034 | |
400656 | 400656 | 2020-08-04 | New York City | New York | 230964 | 23027 | |
397441 | 397441 | 2020-08-03 | New York City | New York | 230648 | 23021 | |
394224 | 394224 | 2020-08-02 | New York City | New York | 230410 | 23012 | |
391008 | 391008 | 2020-08-01 | New York City | New York | 230147 | 23007 | |
387791 | 387791 | 2020-07-31 | New York City | New York | 229834 | 23002 | |
384574 | 384574 | 2020-07-30 | New York City | New York | 229551 | 22996 | |
381356 | 381356 | 2020-07-29 | New York City | New York | 229237 | 22982 | |
378139 | 378139 | 2020-07-28 | New York City | New York | 228939 | 22977 | |
374923 | 374923 | 2020-07-27 | New York City | New York | 228740 | 22970 | |
371711 | 371711 | 2020-07-26 | New York City | New York | 228445 | 22956 | |
368499 | 368499 | 2020-07-25 | New York City | New York | 228220 | 22947 | |
365290 | 365290 | 2020-07-24 | New York City | New York | 227882 | 22936 | |
362084 | 362084 | 2020-07-23 | New York City | New York | 227517 | 22934 | |
358878 | 358878 | 2020-07-22 | New York City | New York | 227130 | 22899 | |
355674 | 355674 | 2020-07-21 | New York City | New York | 226779 | 22895 | |
352471 | 352471 | 2020-07-20 | New York City | New York | 226388 | 22882 | |
349268 | 349268 | 2020-07-19 | New York City | New York | 226104 | 22872 | |
346067 | 346067 | 2020-07-18 | New York City | New York | 225799 | 22859 | |
342868 | 342868 | 2020-07-17 | New York City | New York | 225414 | 22848 | |
339670 | 339670 | 2020-07-16 | New York City | New York | 225045 | 22842 | |
336474 | 336474 | 2020-07-15 | New York City | New York | 224662 | 22825 | |
333280 | 333280 | 2020-07-14 | New York City | New York | 224293 | 22808 | |
330090 | 330090 | 2020-07-13 | New York City | New York | 223977 | 22795 | |
326903 | 326903 | 2020-07-12 | New York City | New York | 223725 | 22755 | |
323719 | 323719 | 2020-07-11 | New York City | New York | 223382 | 22750 | |
320539 | 320539 | 2020-07-10 | New York City | New York | 223078 | 22739 | |
317362 | 317362 | 2020-07-09 | New York City | New York | 222723 | 22719 |
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);