ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 37167 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 |
---|---|---|---|---|---|---|---|
1195096 | 1195096 | 2021-04-06 | Stanly | North Carolina | 37167 | 7358 | 112 |
1191848 | 1191848 | 2021-04-05 | Stanly | North Carolina | 37167 | 7354 | 112 |
1188599 | 1188599 | 2021-04-04 | Stanly | North Carolina | 37167 | 7312 | 112 |
1185352 | 1185352 | 2021-04-03 | Stanly | North Carolina | 37167 | 7312 | 112 |
1182105 | 1182105 | 2021-04-02 | Stanly | North Carolina | 37167 | 7312 | 112 |
1178858 | 1178858 | 2021-04-01 | Stanly | North Carolina | 37167 | 7312 | 112 |
1175611 | 1175611 | 2021-03-31 | Stanly | North Carolina | 37167 | 7293 | 112 |
1172364 | 1172364 | 2021-03-30 | Stanly | North Carolina | 37167 | 7279 | 112 |
1169117 | 1169117 | 2021-03-29 | Stanly | North Carolina | 37167 | 7269 | 112 |
1165869 | 1165869 | 2021-03-28 | Stanly | North Carolina | 37167 | 7220 | 112 |
1162621 | 1162621 | 2021-03-27 | Stanly | North Carolina | 37167 | 7220 | 112 |
1159372 | 1159372 | 2021-03-26 | Stanly | North Carolina | 37167 | 7220 | 112 |
1156125 | 1156125 | 2021-03-25 | Stanly | North Carolina | 37167 | 7200 | 112 |
1152878 | 1152878 | 2021-03-24 | Stanly | North Carolina | 37167 | 7182 | 112 |
1149631 | 1149631 | 2021-03-23 | Stanly | North Carolina | 37167 | 7167 | 112 |
1146384 | 1146384 | 2021-03-22 | Stanly | North Carolina | 37167 | 7159 | 112 |
1143137 | 1143137 | 2021-03-21 | Stanly | North Carolina | 37167 | 7133 | 112 |
1139890 | 1139890 | 2021-03-20 | Stanly | North Carolina | 37167 | 7133 | 112 |
1136644 | 1136644 | 2021-03-19 | Stanly | North Carolina | 37167 | 7112 | 112 |
1133398 | 1133398 | 2021-03-18 | Stanly | North Carolina | 37167 | 7101 | 112 |
1130150 | 1130150 | 2021-03-17 | Stanly | North Carolina | 37167 | 7087 | 112 |
1126903 | 1126903 | 2021-03-16 | Stanly | North Carolina | 37167 | 7072 | 111 |
1123657 | 1123657 | 2021-03-15 | Stanly | North Carolina | 37167 | 7052 | 112 |
1120411 | 1120411 | 2021-03-14 | Stanly | North Carolina | 37167 | 7011 | 112 |
1117164 | 1117164 | 2021-03-13 | Stanly | North Carolina | 37167 | 7011 | 112 |
1113917 | 1113917 | 2021-03-12 | Stanly | North Carolina | 37167 | 7007 | 111 |
1110671 | 1110671 | 2021-03-11 | Stanly | North Carolina | 37167 | 6992 | 111 |
1107425 | 1107425 | 2021-03-10 | Stanly | North Carolina | 37167 | 6964 | 111 |
1104179 | 1104179 | 2021-03-09 | Stanly | North Carolina | 37167 | 6947 | 111 |
1100933 | 1100933 | 2021-03-08 | Stanly | North Carolina | 37167 | 6936 | 111 |
1097687 | 1097687 | 2021-03-07 | Stanly | North Carolina | 37167 | 6917 | 111 |
1094439 | 1094439 | 2021-03-06 | Stanly | North Carolina | 37167 | 6917 | 111 |
1091193 | 1091193 | 2021-03-05 | Stanly | North Carolina | 37167 | 6904 | 111 |
1087948 | 1087948 | 2021-03-04 | Stanly | North Carolina | 37167 | 6888 | 111 |
1084703 | 1084703 | 2021-03-03 | Stanly | North Carolina | 37167 | 6868 | 111 |
1081457 | 1081457 | 2021-03-02 | Stanly | North Carolina | 37167 | 6849 | 111 |
1078211 | 1078211 | 2021-03-01 | Stanly | North Carolina | 37167 | 6832 | 111 |
1074966 | 1074966 | 2021-02-28 | Stanly | North Carolina | 37167 | 6795 | 111 |
1071720 | 1071720 | 2021-02-27 | Stanly | North Carolina | 37167 | 6795 | 111 |
1068474 | 1068474 | 2021-02-26 | Stanly | North Carolina | 37167 | 6782 | 111 |
1065229 | 1065229 | 2021-02-25 | Stanly | North Carolina | 37167 | 6759 | 111 |
1061985 | 1061985 | 2021-02-24 | Stanly | North Carolina | 37167 | 6719 | 111 |
1058739 | 1058739 | 2021-02-23 | Stanly | North Carolina | 37167 | 6686 | 111 |
1055493 | 1055493 | 2021-02-22 | Stanly | North Carolina | 37167 | 6668 | 111 |
1052247 | 1052247 | 2021-02-21 | Stanly | North Carolina | 37167 | 6652 | 111 |
1049000 | 1049000 | 2021-02-20 | Stanly | North Carolina | 37167 | 6613 | 111 |
1045753 | 1045753 | 2021-02-19 | Stanly | North Carolina | 37167 | 6568 | 105 |
1042508 | 1042508 | 2021-02-18 | Stanly | North Carolina | 37167 | 6534 | 105 |
1039263 | 1039263 | 2021-02-17 | Stanly | North Carolina | 37167 | 6500 | 104 |
1036018 | 1036018 | 2021-02-16 | Stanly | North Carolina | 37167 | 6472 | 104 |
1032773 | 1032773 | 2021-02-15 | Stanly | North Carolina | 37167 | 6452 | 103 |
1029527 | 1029527 | 2021-02-14 | Stanly | North Carolina | 37167 | 6424 | 103 |
1026280 | 1026280 | 2021-02-13 | Stanly | North Carolina | 37167 | 6401 | 103 |
1023035 | 1023035 | 2021-02-12 | Stanly | North Carolina | 37167 | 6375 | 103 |
1019790 | 1019790 | 2021-02-11 | Stanly | North Carolina | 37167 | 6347 | 103 |
1016545 | 1016545 | 2021-02-10 | Stanly | North Carolina | 37167 | 6310 | 103 |
1013300 | 1013300 | 2021-02-09 | Stanly | North Carolina | 37167 | 6287 | 103 |
1010055 | 1010055 | 2021-02-08 | Stanly | North Carolina | 37167 | 6265 | 103 |
1006809 | 1006809 | 2021-02-07 | Stanly | North Carolina | 37167 | 6237 | 103 |
1003563 | 1003563 | 2021-02-06 | Stanly | North Carolina | 37167 | 6207 | 102 |
1000317 | 1000317 | 2021-02-05 | Stanly | North Carolina | 37167 | 6176 | 100 |
997071 | 997071 | 2021-02-04 | Stanly | North Carolina | 37167 | 6136 | 100 |
993825 | 993825 | 2021-02-03 | Stanly | North Carolina | 37167 | 6098 | 96 |
990579 | 990579 | 2021-02-02 | Stanly | North Carolina | 37167 | 6055 | 96 |
987333 | 987333 | 2021-02-01 | Stanly | North Carolina | 37167 | 6024 | 93 |
984086 | 984086 | 2021-01-31 | Stanly | North Carolina | 37167 | 5985 | 93 |
980839 | 980839 | 2021-01-30 | Stanly | North Carolina | 37167 | 5918 | 92 |
977593 | 977593 | 2021-01-29 | Stanly | North Carolina | 37167 | 5918 | 92 |
974348 | 974348 | 2021-01-28 | Stanly | North Carolina | 37167 | 5867 | 92 |
971103 | 971103 | 2021-01-27 | Stanly | North Carolina | 37167 | 5840 | 92 |
967858 | 967858 | 2021-01-26 | Stanly | North Carolina | 37167 | 5812 | 92 |
964614 | 964614 | 2021-01-25 | Stanly | North Carolina | 37167 | 5770 | 92 |
961369 | 961369 | 2021-01-24 | Stanly | North Carolina | 37167 | 5738 | 92 |
958124 | 958124 | 2021-01-23 | Stanly | North Carolina | 37167 | 5713 | 92 |
954878 | 954878 | 2021-01-22 | Stanly | North Carolina | 37167 | 5668 | 92 |
951633 | 951633 | 2021-01-21 | Stanly | North Carolina | 37167 | 5602 | 92 |
948388 | 948388 | 2021-01-20 | Stanly | North Carolina | 37167 | 5562 | 92 |
945141 | 945141 | 2021-01-19 | Stanly | North Carolina | 37167 | 5470 | 92 |
941895 | 941895 | 2021-01-18 | Stanly | North Carolina | 37167 | 5406 | 92 |
938650 | 938650 | 2021-01-17 | Stanly | North Carolina | 37167 | 5406 | 92 |
935405 | 935405 | 2021-01-16 | Stanly | North Carolina | 37167 | 5373 | 92 |
932160 | 932160 | 2021-01-15 | Stanly | North Carolina | 37167 | 5295 | 92 |
928915 | 928915 | 2021-01-14 | Stanly | North Carolina | 37167 | 5226 | 92 |
925670 | 925670 | 2021-01-13 | Stanly | North Carolina | 37167 | 5147 | 92 |
922424 | 922424 | 2021-01-12 | Stanly | North Carolina | 37167 | 5114 | 92 |
919179 | 919179 | 2021-01-11 | Stanly | North Carolina | 37167 | 5078 | 92 |
915934 | 915934 | 2021-01-10 | Stanly | North Carolina | 37167 | 5029 | 92 |
912689 | 912689 | 2021-01-09 | Stanly | North Carolina | 37167 | 4937 | 92 |
909444 | 909444 | 2021-01-08 | Stanly | North Carolina | 37167 | 4850 | 92 |
906199 | 906199 | 2021-01-07 | Stanly | North Carolina | 37167 | 4777 | 84 |
902953 | 902953 | 2021-01-06 | Stanly | North Carolina | 37167 | 4696 | 78 |
899708 | 899708 | 2021-01-05 | Stanly | North Carolina | 37167 | 4647 | 78 |
896463 | 896463 | 2021-01-04 | Stanly | North Carolina | 37167 | 4607 | 78 |
893217 | 893217 | 2021-01-03 | Stanly | North Carolina | 37167 | 4529 | 78 |
889971 | 889971 | 2021-01-02 | Stanly | North Carolina | 37167 | 4460 | 78 |
886724 | 886724 | 2021-01-01 | Stanly | North Carolina | 37167 | 4331 | 78 |
883479 | 883479 | 2020-12-31 | Stanly | North Carolina | 37167 | 4331 | 78 |
880234 | 880234 | 2020-12-30 | Stanly | North Carolina | 37167 | 4287 | 78 |
876989 | 876989 | 2020-12-29 | Stanly | North Carolina | 37167 | 4190 | 78 |
873744 | 873744 | 2020-12-28 | Stanly | North Carolina | 37167 | 4161 | 78 |
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);