ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Orange" 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 |
---|---|---|---|---|---|---|---|
948280 | 948280 | 2021-01-20 | Orange | New York | 36071 | 29093 | 574 |
945033 | 945033 | 2021-01-19 | Orange | New York | 36071 | 28863 | 572 |
941787 | 941787 | 2021-01-18 | Orange | New York | 36071 | 28589 | 571 |
938542 | 938542 | 2021-01-17 | Orange | New York | 36071 | 28401 | 568 |
935297 | 935297 | 2021-01-16 | Orange | New York | 36071 | 28183 | 564 |
932052 | 932052 | 2021-01-15 | Orange | New York | 36071 | 27877 | 562 |
928807 | 928807 | 2021-01-14 | Orange | New York | 36071 | 27487 | 558 |
925562 | 925562 | 2021-01-13 | Orange | New York | 36071 | 27175 | 556 |
922316 | 922316 | 2021-01-12 | Orange | New York | 36071 | 26802 | 553 |
919071 | 919071 | 2021-01-11 | Orange | New York | 36071 | 26503 | 551 |
915826 | 915826 | 2021-01-10 | Orange | New York | 36071 | 26275 | 546 |
912581 | 912581 | 2021-01-09 | Orange | New York | 36071 | 25953 | 540 |
909336 | 909336 | 2021-01-08 | Orange | New York | 36071 | 25698 | 540 |
906091 | 906091 | 2021-01-07 | Orange | New York | 36071 | 25269 | 535 |
902845 | 902845 | 2021-01-06 | Orange | New York | 36071 | 24868 | 528 |
899600 | 899600 | 2021-01-05 | Orange | New York | 36071 | 24594 | 526 |
896355 | 896355 | 2021-01-04 | Orange | New York | 36071 | 24385 | 521 |
893109 | 893109 | 2021-01-03 | Orange | New York | 36071 | 24212 | 518 |
889863 | 889863 | 2021-01-02 | Orange | New York | 36071 | 24048 | 515 |
886616 | 886616 | 2021-01-01 | Orange | New York | 36071 | 23694 | 513 |
883371 | 883371 | 2020-12-31 | Orange | New York | 36071 | 23372 | 510 |
880126 | 880126 | 2020-12-30 | Orange | New York | 36071 | 23034 | 508 |
876881 | 876881 | 2020-12-29 | Orange | New York | 36071 | 22698 | 505 |
873636 | 873636 | 2020-12-28 | Orange | New York | 36071 | 22521 | 503 |
870391 | 870391 | 2020-12-27 | Orange | New York | 36071 | 22357 | 503 |
867146 | 867146 | 2020-12-26 | Orange | New York | 36071 | 22228 | 500 |
863901 | 863901 | 2020-12-25 | Orange | New York | 36071 | 22047 | 497 |
860656 | 860656 | 2020-12-24 | Orange | New York | 36071 | 21837 | 493 |
857411 | 857411 | 2020-12-23 | Orange | New York | 36071 | 21564 | 490 |
854166 | 854166 | 2020-12-22 | Orange | New York | 36071 | 21342 | 486 |
850921 | 850921 | 2020-12-21 | Orange | New York | 36071 | 21163 | 484 |
847676 | 847676 | 2020-12-20 | Orange | New York | 36071 | 21087 | 481 |
844431 | 844431 | 2020-12-19 | Orange | New York | 36071 | 20891 | 478 |
841185 | 841185 | 2020-12-18 | Orange | New York | 36071 | 20732 | 474 |
837940 | 837940 | 2020-12-17 | Orange | New York | 36071 | 20339 | 471 |
834694 | 834694 | 2020-12-16 | Orange | New York | 36071 | 20129 | 470 |
831448 | 831448 | 2020-12-15 | Orange | New York | 36071 | 19907 | 469 |
828201 | 828201 | 2020-12-14 | Orange | New York | 36071 | 19771 | 467 |
824955 | 824955 | 2020-12-13 | Orange | New York | 36071 | 19551 | 464 |
821708 | 821708 | 2020-12-12 | Orange | New York | 36071 | 19345 | 460 |
818462 | 818462 | 2020-12-11 | Orange | New York | 36071 | 19161 | 457 |
815216 | 815216 | 2020-12-10 | Orange | New York | 36071 | 18938 | 455 |
811971 | 811971 | 2020-12-09 | Orange | New York | 36071 | 18735 | 453 |
808726 | 808726 | 2020-12-08 | Orange | New York | 36071 | 18549 | 450 |
805481 | 805481 | 2020-12-07 | Orange | New York | 36071 | 18364 | 448 |
802236 | 802236 | 2020-12-06 | Orange | New York | 36071 | 18234 | 446 |
798991 | 798991 | 2020-12-05 | Orange | New York | 36071 | 18033 | 445 |
795746 | 795746 | 2020-12-04 | Orange | New York | 36071 | 17731 | 444 |
792501 | 792501 | 2020-12-03 | Orange | New York | 36071 | 17511 | 442 |
789256 | 789256 | 2020-12-02 | Orange | New York | 36071 | 17298 | 440 |
786011 | 786011 | 2020-12-01 | Orange | New York | 36071 | 17090 | 439 |
782767 | 782767 | 2020-11-30 | Orange | New York | 36071 | 16906 | 435 |
779521 | 779521 | 2020-11-29 | Orange | New York | 36071 | 16816 | 434 |
776276 | 776276 | 2020-11-28 | Orange | New York | 36071 | 16665 | 433 |
773031 | 773031 | 2020-11-27 | Orange | New York | 36071 | 16570 | 433 |
769786 | 769786 | 2020-11-26 | Orange | New York | 36071 | 16420 | 431 |
766540 | 766540 | 2020-11-25 | Orange | New York | 36071 | 16243 | 431 |
763295 | 763295 | 2020-11-24 | Orange | New York | 36071 | 16108 | 431 |
760050 | 760050 | 2020-11-23 | Orange | New York | 36071 | 16002 | 428 |
756804 | 756804 | 2020-11-22 | Orange | New York | 36071 | 15887 | 428 |
753557 | 753557 | 2020-11-21 | Orange | New York | 36071 | 15814 | 428 |
750311 | 750311 | 2020-11-20 | Orange | New York | 36071 | 15692 | 427 |
747065 | 747065 | 2020-11-19 | Orange | New York | 36071 | 15581 | 427 |
743819 | 743819 | 2020-11-18 | Orange | New York | 36071 | 15427 | 426 |
740572 | 740572 | 2020-11-17 | Orange | New York | 36071 | 15298 | 425 |
737327 | 737327 | 2020-11-16 | Orange | New York | 36071 | 15197 | 425 |
734083 | 734083 | 2020-11-15 | Orange | New York | 36071 | 15139 | 425 |
730837 | 730837 | 2020-11-14 | Orange | New York | 36071 | 15046 | 425 |
727593 | 727593 | 2020-11-13 | Orange | New York | 36071 | 14925 | 425 |
724349 | 724349 | 2020-11-12 | Orange | New York | 36071 | 14818 | 423 |
721106 | 721106 | 2020-11-11 | Orange | New York | 36071 | 14716 | 423 |
717863 | 717863 | 2020-11-10 | Orange | New York | 36071 | 14568 | 423 |
714620 | 714620 | 2020-11-09 | Orange | New York | 36071 | 14480 | 423 |
711376 | 711376 | 2020-11-08 | Orange | New York | 36071 | 14384 | 421 |
708132 | 708132 | 2020-11-07 | Orange | New York | 36071 | 14316 | 421 |
704889 | 704889 | 2020-11-06 | Orange | New York | 36071 | 14236 | 421 |
701646 | 701646 | 2020-11-05 | Orange | New York | 36071 | 14150 | 421 |
698402 | 698402 | 2020-11-04 | Orange | New York | 36071 | 14070 | 421 |
695159 | 695159 | 2020-11-03 | Orange | New York | 36071 | 14013 | 420 |
691917 | 691917 | 2020-11-02 | Orange | New York | 36071 | 13948 | 420 |
688673 | 688673 | 2020-11-01 | Orange | New York | 36071 | 13904 | 420 |
685428 | 685428 | 2020-10-31 | Orange | New York | 36071 | 13845 | 420 |
682185 | 682185 | 2020-10-30 | Orange | New York | 36071 | 13758 | 420 |
678942 | 678942 | 2020-10-29 | Orange | New York | 36071 | 13687 | 420 |
675699 | 675699 | 2020-10-28 | Orange | New York | 36071 | 13612 | 420 |
672456 | 672456 | 2020-10-27 | Orange | New York | 36071 | 13563 | 420 |
669214 | 669214 | 2020-10-26 | Orange | New York | 36071 | 13490 | 420 |
665970 | 665970 | 2020-10-25 | Orange | New York | 36071 | 13472 | 420 |
662725 | 662725 | 2020-10-24 | Orange | New York | 36071 | 13428 | 419 |
659481 | 659481 | 2020-10-23 | Orange | New York | 36071 | 13357 | 419 |
656237 | 656237 | 2020-10-22 | Orange | New York | 36071 | 13318 | 418 |
652992 | 652992 | 2020-10-21 | Orange | New York | 36071 | 13273 | 417 |
649747 | 649747 | 2020-10-20 | Orange | New York | 36071 | 13233 | 417 |
646503 | 646503 | 2020-10-19 | Orange | New York | 36071 | 13197 | 417 |
643257 | 643257 | 2020-10-18 | Orange | New York | 36071 | 13184 | 417 |
640009 | 640009 | 2020-10-17 | Orange | New York | 36071 | 13154 | 417 |
636763 | 636763 | 2020-10-16 | Orange | New York | 36071 | 13113 | 416 |
633517 | 633517 | 2020-10-15 | Orange | New York | 36071 | 13048 | 416 |
630272 | 630272 | 2020-10-14 | Orange | New York | 36071 | 12998 | 416 |
627028 | 627028 | 2020-10-13 | Orange | New York | 36071 | 12945 | 416 |
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);