ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 37135 and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1094423 | 1094423 | 2021-03-06 | Orange | North Carolina | 37135 | 7827 | 95 |
1091177 | 1091177 | 2021-03-05 | Orange | North Carolina | 37135 | 7817 | 95 |
1087932 | 1087932 | 2021-03-04 | Orange | North Carolina | 37135 | 7793 | 95 |
1084687 | 1084687 | 2021-03-03 | Orange | North Carolina | 37135 | 7767 | 93 |
1081441 | 1081441 | 2021-03-02 | Orange | North Carolina | 37135 | 7753 | 93 |
1078195 | 1078195 | 2021-03-01 | Orange | North Carolina | 37135 | 7743 | 93 |
1074950 | 1074950 | 2021-02-28 | Orange | North Carolina | 37135 | 7702 | 93 |
1071704 | 1071704 | 2021-02-27 | Orange | North Carolina | 37135 | 7702 | 93 |
1068458 | 1068458 | 2021-02-26 | Orange | North Carolina | 37135 | 7669 | 93 |
1065213 | 1065213 | 2021-02-25 | Orange | North Carolina | 37135 | 7657 | 93 |
1061969 | 1061969 | 2021-02-24 | Orange | North Carolina | 37135 | 7623 | 93 |
1058723 | 1058723 | 2021-02-23 | Orange | North Carolina | 37135 | 7601 | 93 |
1055477 | 1055477 | 2021-02-22 | Orange | North Carolina | 37135 | 7586 | 93 |
1052231 | 1052231 | 2021-02-21 | Orange | North Carolina | 37135 | 7565 | 93 |
1048984 | 1048984 | 2021-02-20 | Orange | North Carolina | 37135 | 7555 | 93 |
1045737 | 1045737 | 2021-02-19 | Orange | North Carolina | 37135 | 7541 | 92 |
1042492 | 1042492 | 2021-02-18 | Orange | North Carolina | 37135 | 7515 | 92 |
1039247 | 1039247 | 2021-02-17 | Orange | North Carolina | 37135 | 7467 | 91 |
1036002 | 1036002 | 2021-02-16 | Orange | North Carolina | 37135 | 7438 | 90 |
1032757 | 1032757 | 2021-02-15 | Orange | North Carolina | 37135 | 7422 | 90 |
1029511 | 1029511 | 2021-02-14 | Orange | North Carolina | 37135 | 7381 | 90 |
1026264 | 1026264 | 2021-02-13 | Orange | North Carolina | 37135 | 7360 | 90 |
1023019 | 1023019 | 2021-02-12 | Orange | North Carolina | 37135 | 7323 | 90 |
1019774 | 1019774 | 2021-02-11 | Orange | North Carolina | 37135 | 7279 | 89 |
1016529 | 1016529 | 2021-02-10 | Orange | North Carolina | 37135 | 7218 | 87 |
1013284 | 1013284 | 2021-02-09 | Orange | North Carolina | 37135 | 7189 | 87 |
1010039 | 1010039 | 2021-02-08 | Orange | North Carolina | 37135 | 7152 | 87 |
1006793 | 1006793 | 2021-02-07 | Orange | North Carolina | 37135 | 7127 | 87 |
1003547 | 1003547 | 2021-02-06 | Orange | North Carolina | 37135 | 7094 | 86 |
1000301 | 1000301 | 2021-02-05 | Orange | North Carolina | 37135 | 7050 | 85 |
997055 | 997055 | 2021-02-04 | Orange | North Carolina | 37135 | 6992 | 85 |
993809 | 993809 | 2021-02-03 | Orange | North Carolina | 37135 | 6949 | 83 |
990563 | 990563 | 2021-02-02 | Orange | North Carolina | 37135 | 6848 | 82 |
987317 | 987317 | 2021-02-01 | Orange | North Carolina | 37135 | 6823 | 82 |
984070 | 984070 | 2021-01-31 | Orange | North Carolina | 37135 | 6760 | 82 |
980823 | 980823 | 2021-01-30 | Orange | North Carolina | 37135 | 6632 | 82 |
977577 | 977577 | 2021-01-29 | Orange | North Carolina | 37135 | 6632 | 82 |
974332 | 974332 | 2021-01-28 | Orange | North Carolina | 37135 | 6552 | 81 |
971087 | 971087 | 2021-01-27 | Orange | North Carolina | 37135 | 6501 | 80 |
967842 | 967842 | 2021-01-26 | Orange | North Carolina | 37135 | 6440 | 80 |
964598 | 964598 | 2021-01-25 | Orange | North Carolina | 37135 | 6420 | 79 |
961353 | 961353 | 2021-01-24 | Orange | North Carolina | 37135 | 6380 | 77 |
958108 | 958108 | 2021-01-23 | Orange | North Carolina | 37135 | 6334 | 76 |
954862 | 954862 | 2021-01-22 | Orange | North Carolina | 37135 | 6282 | 76 |
951617 | 951617 | 2021-01-21 | Orange | North Carolina | 37135 | 6211 | 70 |
948372 | 948372 | 2021-01-20 | Orange | North Carolina | 37135 | 6159 | 70 |
945125 | 945125 | 2021-01-19 | Orange | North Carolina | 37135 | 6117 | 69 |
941879 | 941879 | 2021-01-18 | Orange | North Carolina | 37135 | 6079 | 69 |
938634 | 938634 | 2021-01-17 | Orange | North Carolina | 37135 | 6079 | 69 |
935389 | 935389 | 2021-01-16 | Orange | North Carolina | 37135 | 6016 | 69 |
932144 | 932144 | 2021-01-15 | Orange | North Carolina | 37135 | 5954 | 69 |
928899 | 928899 | 2021-01-14 | Orange | North Carolina | 37135 | 5883 | 68 |
925654 | 925654 | 2021-01-13 | Orange | North Carolina | 37135 | 5839 | 68 |
922408 | 922408 | 2021-01-12 | Orange | North Carolina | 37135 | 5792 | 68 |
919163 | 919163 | 2021-01-11 | Orange | North Carolina | 37135 | 5744 | 68 |
915918 | 915918 | 2021-01-10 | Orange | North Carolina | 37135 | 5682 | 68 |
912673 | 912673 | 2021-01-09 | Orange | North Carolina | 37135 | 5614 | 68 |
909428 | 909428 | 2021-01-08 | Orange | North Carolina | 37135 | 5530 | 68 |
906183 | 906183 | 2021-01-07 | Orange | North Carolina | 37135 | 5431 | 66 |
902937 | 902937 | 2021-01-06 | Orange | North Carolina | 37135 | 5359 | 66 |
899692 | 899692 | 2021-01-05 | Orange | North Carolina | 37135 | 5326 | 66 |
896447 | 896447 | 2021-01-04 | Orange | North Carolina | 37135 | 5272 | 65 |
893201 | 893201 | 2021-01-03 | Orange | North Carolina | 37135 | 5227 | 65 |
889955 | 889955 | 2021-01-02 | Orange | North Carolina | 37135 | 5192 | 65 |
886708 | 886708 | 2021-01-01 | Orange | North Carolina | 37135 | 5046 | 65 |
883463 | 883463 | 2020-12-31 | Orange | North Carolina | 37135 | 5046 | 65 |
880218 | 880218 | 2020-12-30 | Orange | North Carolina | 37135 | 4989 | 64 |
876973 | 876973 | 2020-12-29 | Orange | North Carolina | 37135 | 4949 | 63 |
873728 | 873728 | 2020-12-28 | Orange | North Carolina | 37135 | 4932 | 63 |
870483 | 870483 | 2020-12-27 | Orange | North Carolina | 37135 | 4891 | 63 |
867238 | 867238 | 2020-12-26 | Orange | North Carolina | 37135 | 4882 | 63 |
863993 | 863993 | 2020-12-25 | Orange | North Carolina | 37135 | 4738 | 63 |
860748 | 860748 | 2020-12-24 | Orange | North Carolina | 37135 | 4738 | 63 |
857503 | 857503 | 2020-12-23 | Orange | North Carolina | 37135 | 4738 | 63 |
854258 | 854258 | 2020-12-22 | Orange | North Carolina | 37135 | 4703 | 63 |
851013 | 851013 | 2020-12-21 | Orange | North Carolina | 37135 | 4681 | 63 |
847768 | 847768 | 2020-12-20 | Orange | North Carolina | 37135 | 4660 | 62 |
844523 | 844523 | 2020-12-19 | Orange | North Carolina | 37135 | 4604 | 62 |
841277 | 841277 | 2020-12-18 | Orange | North Carolina | 37135 | 4593 | 62 |
838032 | 838032 | 2020-12-17 | Orange | North Carolina | 37135 | 4528 | 62 |
834786 | 834786 | 2020-12-16 | Orange | North Carolina | 37135 | 4514 | 62 |
831540 | 831540 | 2020-12-15 | Orange | North Carolina | 37135 | 4485 | 62 |
828293 | 828293 | 2020-12-14 | Orange | North Carolina | 37135 | 4443 | 62 |
825047 | 825047 | 2020-12-13 | Orange | North Carolina | 37135 | 4405 | 62 |
821800 | 821800 | 2020-12-12 | Orange | North Carolina | 37135 | 4363 | 62 |
818554 | 818554 | 2020-12-11 | Orange | North Carolina | 37135 | 4316 | 62 |
815308 | 815308 | 2020-12-10 | Orange | North Carolina | 37135 | 4253 | 62 |
812063 | 812063 | 2020-12-09 | Orange | North Carolina | 37135 | 4215 | 62 |
808818 | 808818 | 2020-12-08 | Orange | North Carolina | 37135 | 4191 | 62 |
805573 | 805573 | 2020-12-07 | Orange | North Carolina | 37135 | 4163 | 62 |
802328 | 802328 | 2020-12-06 | Orange | North Carolina | 37135 | 4132 | 62 |
799083 | 799083 | 2020-12-05 | Orange | North Carolina | 37135 | 4080 | 62 |
795838 | 795838 | 2020-12-04 | Orange | North Carolina | 37135 | 4045 | 62 |
792593 | 792593 | 2020-12-03 | Orange | North Carolina | 37135 | 3993 | 62 |
789348 | 789348 | 2020-12-02 | Orange | North Carolina | 37135 | 3969 | 62 |
786103 | 786103 | 2020-12-01 | Orange | North Carolina | 37135 | 3934 | 62 |
782859 | 782859 | 2020-11-30 | Orange | North Carolina | 37135 | 3913 | 62 |
779613 | 779613 | 2020-11-29 | Orange | North Carolina | 37135 | 3889 | 62 |
776368 | 776368 | 2020-11-28 | Orange | North Carolina | 37135 | 3863 | 62 |
773123 | 773123 | 2020-11-27 | Orange | North Carolina | 37135 | 3831 | 62 |
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);