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 |
---|---|---|---|---|---|---|---|
1194988 | 1194988 | 2021-04-06 | Orange | New York | 36071 | 44385 | 683 |
1191740 | 1191740 | 2021-04-05 | Orange | New York | 36071 | 44200 | 682 |
1188491 | 1188491 | 2021-04-04 | Orange | New York | 36071 | 44063 | 682 |
1185244 | 1185244 | 2021-04-03 | Orange | New York | 36071 | 43908 | 682 |
1181997 | 1181997 | 2021-04-02 | Orange | New York | 36071 | 43701 | 680 |
1178750 | 1178750 | 2021-04-01 | Orange | New York | 36071 | 43498 | 677 |
1175503 | 1175503 | 2021-03-31 | Orange | New York | 36071 | 43246 | 672 |
1172256 | 1172256 | 2021-03-30 | Orange | New York | 36071 | 43030 | 670 |
1169009 | 1169009 | 2021-03-29 | Orange | New York | 36071 | 42784 | 670 |
1165761 | 1165761 | 2021-03-28 | Orange | New York | 36071 | 42550 | 669 |
1162513 | 1162513 | 2021-03-27 | Orange | New York | 36071 | 42343 | 668 |
1159264 | 1159264 | 2021-03-26 | Orange | New York | 36071 | 42082 | 665 |
1156017 | 1156017 | 2021-03-25 | Orange | New York | 36071 | 41840 | 665 |
1152770 | 1152770 | 2021-03-24 | Orange | New York | 36071 | 41642 | 664 |
1149523 | 1149523 | 2021-03-23 | Orange | New York | 36071 | 41385 | 664 |
1146276 | 1146276 | 2021-03-22 | Orange | New York | 36071 | 41152 | 664 |
1143029 | 1143029 | 2021-03-21 | Orange | New York | 36071 | 41008 | 664 |
1139782 | 1139782 | 2021-03-20 | Orange | New York | 36071 | 40795 | 664 |
1136536 | 1136536 | 2021-03-19 | Orange | New York | 36071 | 40514 | 663 |
1133290 | 1133290 | 2021-03-18 | Orange | New York | 36071 | 40292 | 661 |
1130042 | 1130042 | 2021-03-17 | Orange | New York | 36071 | 40045 | 661 |
1126795 | 1126795 | 2021-03-16 | Orange | New York | 36071 | 39810 | 661 |
1123549 | 1123549 | 2021-03-15 | Orange | New York | 36071 | 39590 | 661 |
1120303 | 1120303 | 2021-03-14 | Orange | New York | 36071 | 39477 | 659 |
1117056 | 1117056 | 2021-03-13 | Orange | New York | 36071 | 39303 | 657 |
1113809 | 1113809 | 2021-03-12 | Orange | New York | 36071 | 39146 | 657 |
1110563 | 1110563 | 2021-03-11 | Orange | New York | 36071 | 38874 | 655 |
1107317 | 1107317 | 2021-03-10 | Orange | New York | 36071 | 38675 | 653 |
1104071 | 1104071 | 2021-03-09 | Orange | New York | 36071 | 38468 | 652 |
1100825 | 1100825 | 2021-03-08 | Orange | New York | 36071 | 38322 | 648 |
1097579 | 1097579 | 2021-03-07 | Orange | New York | 36071 | 38209 | 648 |
1094331 | 1094331 | 2021-03-06 | Orange | New York | 36071 | 38044 | 646 |
1091085 | 1091085 | 2021-03-05 | Orange | New York | 36071 | 37862 | 646 |
1087840 | 1087840 | 2021-03-04 | Orange | New York | 36071 | 37646 | 645 |
1084595 | 1084595 | 2021-03-03 | Orange | New York | 36071 | 37456 | 643 |
1081349 | 1081349 | 2021-03-02 | Orange | New York | 36071 | 37247 | 641 |
1078103 | 1078103 | 2021-03-01 | Orange | New York | 36071 | 37074 | 640 |
1074858 | 1074858 | 2021-02-28 | Orange | New York | 36071 | 36967 | 638 |
1071612 | 1071612 | 2021-02-27 | Orange | New York | 36071 | 36762 | 638 |
1068366 | 1068366 | 2021-02-26 | Orange | New York | 36071 | 36571 | 637 |
1065121 | 1065121 | 2021-02-25 | Orange | New York | 36071 | 36349 | 635 |
1061877 | 1061877 | 2021-02-24 | Orange | New York | 36071 | 36117 | 634 |
1058631 | 1058631 | 2021-02-23 | Orange | New York | 36071 | 35940 | 633 |
1055385 | 1055385 | 2021-02-22 | Orange | New York | 36071 | 35770 | 632 |
1052139 | 1052139 | 2021-02-21 | Orange | New York | 36071 | 35663 | 631 |
1048892 | 1048892 | 2021-02-20 | Orange | New York | 36071 | 35511 | 629 |
1045645 | 1045645 | 2021-02-19 | Orange | New York | 36071 | 35370 | 627 |
1042400 | 1042400 | 2021-02-18 | Orange | New York | 36071 | 35225 | 622 |
1039155 | 1039155 | 2021-02-17 | Orange | New York | 36071 | 35050 | 620 |
1035910 | 1035910 | 2021-02-16 | Orange | New York | 36071 | 34913 | 618 |
1032665 | 1032665 | 2021-02-15 | Orange | New York | 36071 | 34744 | 615 |
1029419 | 1029419 | 2021-02-14 | Orange | New York | 36071 | 34603 | 611 |
1026172 | 1026172 | 2021-02-13 | Orange | New York | 36071 | 34457 | 609 |
1022927 | 1022927 | 2021-02-12 | Orange | New York | 36071 | 34260 | 608 |
1019682 | 1019682 | 2021-02-11 | Orange | New York | 36071 | 34072 | 607 |
1016437 | 1016437 | 2021-02-10 | Orange | New York | 36071 | 33924 | 606 |
1013192 | 1013192 | 2021-02-09 | Orange | New York | 36071 | 33749 | 605 |
1009947 | 1009947 | 2021-02-08 | Orange | New York | 36071 | 33614 | 602 |
1006701 | 1006701 | 2021-02-07 | Orange | New York | 36071 | 33440 | 601 |
1003455 | 1003455 | 2021-02-06 | Orange | New York | 36071 | 33261 | 601 |
1000209 | 1000209 | 2021-02-05 | Orange | New York | 36071 | 33057 | 601 |
996963 | 996963 | 2021-02-04 | Orange | New York | 36071 | 32845 | 598 |
993717 | 993717 | 2021-02-03 | Orange | New York | 36071 | 32679 | 594 |
990471 | 990471 | 2021-02-02 | Orange | New York | 36071 | 32595 | 593 |
987225 | 987225 | 2021-02-01 | Orange | New York | 36071 | 32422 | 591 |
983978 | 983978 | 2021-01-31 | Orange | New York | 36071 | 32254 | 587 |
980731 | 980731 | 2021-01-30 | Orange | New York | 36071 | 32082 | 586 |
977485 | 977485 | 2021-01-29 | Orange | New York | 36071 | 31641 | 586 |
974240 | 974240 | 2021-01-28 | Orange | New York | 36071 | 31393 | 586 |
970995 | 970995 | 2021-01-27 | Orange | New York | 36071 | 31152 | 586 |
967750 | 967750 | 2021-01-26 | Orange | New York | 36071 | 30924 | 583 |
964506 | 964506 | 2021-01-25 | Orange | New York | 36071 | 30560 | 582 |
961261 | 961261 | 2021-01-24 | Orange | New York | 36071 | 30303 | 579 |
958016 | 958016 | 2021-01-23 | Orange | New York | 36071 | 30027 | 577 |
954770 | 954770 | 2021-01-22 | Orange | New York | 36071 | 29768 | 575 |
951525 | 951525 | 2021-01-21 | Orange | New York | 36071 | 29421 | 574 |
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 |
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);