ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Rowan" 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 |
---|---|---|---|---|---|---|---|
1195092 | 1195092 | 2021-04-06 | Rowan | North Carolina | 37159 | 15845 | 297 |
1191844 | 1191844 | 2021-04-05 | Rowan | North Carolina | 37159 | 15832 | 297 |
1188595 | 1188595 | 2021-04-04 | Rowan | North Carolina | 37159 | 15722 | 297 |
1185348 | 1185348 | 2021-04-03 | Rowan | North Carolina | 37159 | 15722 | 297 |
1182101 | 1182101 | 2021-04-02 | Rowan | North Carolina | 37159 | 15722 | 297 |
1178854 | 1178854 | 2021-04-01 | Rowan | North Carolina | 37159 | 15722 | 297 |
1175607 | 1175607 | 2021-03-31 | Rowan | North Carolina | 37159 | 15684 | 297 |
1172360 | 1172360 | 2021-03-30 | Rowan | North Carolina | 37159 | 15655 | 297 |
1169113 | 1169113 | 2021-03-29 | Rowan | North Carolina | 37159 | 15631 | 297 |
1165865 | 1165865 | 2021-03-28 | Rowan | North Carolina | 37159 | 15546 | 294 |
1162617 | 1162617 | 2021-03-27 | Rowan | North Carolina | 37159 | 15546 | 294 |
1159368 | 1159368 | 2021-03-26 | Rowan | North Carolina | 37159 | 15546 | 294 |
1156121 | 1156121 | 2021-03-25 | Rowan | North Carolina | 37159 | 15514 | 294 |
1152874 | 1152874 | 2021-03-24 | Rowan | North Carolina | 37159 | 15481 | 293 |
1149627 | 1149627 | 2021-03-23 | Rowan | North Carolina | 37159 | 15457 | 292 |
1146380 | 1146380 | 2021-03-22 | Rowan | North Carolina | 37159 | 15440 | 292 |
1143133 | 1143133 | 2021-03-21 | Rowan | North Carolina | 37159 | 15406 | 292 |
1139886 | 1139886 | 2021-03-20 | Rowan | North Carolina | 37159 | 15406 | 292 |
1136640 | 1136640 | 2021-03-19 | Rowan | North Carolina | 37159 | 15375 | 291 |
1133394 | 1133394 | 2021-03-18 | Rowan | North Carolina | 37159 | 15354 | 291 |
1130146 | 1130146 | 2021-03-17 | Rowan | North Carolina | 37159 | 15316 | 291 |
1126899 | 1126899 | 2021-03-16 | Rowan | North Carolina | 37159 | 15288 | 291 |
1123653 | 1123653 | 2021-03-15 | Rowan | North Carolina | 37159 | 15278 | 291 |
1120407 | 1120407 | 2021-03-14 | Rowan | North Carolina | 37159 | 15207 | 291 |
1117160 | 1117160 | 2021-03-13 | Rowan | North Carolina | 37159 | 15207 | 291 |
1113913 | 1113913 | 2021-03-12 | Rowan | North Carolina | 37159 | 15195 | 291 |
1110667 | 1110667 | 2021-03-11 | Rowan | North Carolina | 37159 | 15159 | 291 |
1107421 | 1107421 | 2021-03-10 | Rowan | North Carolina | 37159 | 15132 | 291 |
1104175 | 1104175 | 2021-03-09 | Rowan | North Carolina | 37159 | 15105 | 291 |
1100929 | 1100929 | 2021-03-08 | Rowan | North Carolina | 37159 | 15089 | 291 |
1097683 | 1097683 | 2021-03-07 | Rowan | North Carolina | 37159 | 15041 | 290 |
1094435 | 1094435 | 2021-03-06 | Rowan | North Carolina | 37159 | 15041 | 290 |
1091189 | 1091189 | 2021-03-05 | Rowan | North Carolina | 37159 | 15004 | 289 |
1087944 | 1087944 | 2021-03-04 | Rowan | North Carolina | 37159 | 14983 | 288 |
1084699 | 1084699 | 2021-03-03 | Rowan | North Carolina | 37159 | 14957 | 286 |
1081453 | 1081453 | 2021-03-02 | Rowan | North Carolina | 37159 | 14928 | 283 |
1078207 | 1078207 | 2021-03-01 | Rowan | North Carolina | 37159 | 14908 | 282 |
1074962 | 1074962 | 2021-02-28 | Rowan | North Carolina | 37159 | 14838 | 282 |
1071716 | 1071716 | 2021-02-27 | Rowan | North Carolina | 37159 | 14838 | 282 |
1068470 | 1068470 | 2021-02-26 | Rowan | North Carolina | 37159 | 14786 | 277 |
1065225 | 1065225 | 2021-02-25 | Rowan | North Carolina | 37159 | 14744 | 275 |
1061981 | 1061981 | 2021-02-24 | Rowan | North Carolina | 37159 | 14683 | 273 |
1058735 | 1058735 | 2021-02-23 | Rowan | North Carolina | 37159 | 14636 | 270 |
1055489 | 1055489 | 2021-02-22 | Rowan | North Carolina | 37159 | 14613 | 269 |
1052243 | 1052243 | 2021-02-21 | Rowan | North Carolina | 37159 | 14567 | 269 |
1048996 | 1048996 | 2021-02-20 | Rowan | North Carolina | 37159 | 14542 | 269 |
1045749 | 1045749 | 2021-02-19 | Rowan | North Carolina | 37159 | 14479 | 269 |
1042504 | 1042504 | 2021-02-18 | Rowan | North Carolina | 37159 | 14426 | 269 |
1039259 | 1039259 | 2021-02-17 | Rowan | North Carolina | 37159 | 14360 | 267 |
1036014 | 1036014 | 2021-02-16 | Rowan | North Carolina | 37159 | 14318 | 265 |
1032769 | 1032769 | 2021-02-15 | Rowan | North Carolina | 37159 | 14278 | 265 |
1029523 | 1029523 | 2021-02-14 | Rowan | North Carolina | 37159 | 14231 | 265 |
1026276 | 1026276 | 2021-02-13 | Rowan | North Carolina | 37159 | 14165 | 265 |
1023031 | 1023031 | 2021-02-12 | Rowan | North Carolina | 37159 | 14070 | 264 |
1019786 | 1019786 | 2021-02-11 | Rowan | North Carolina | 37159 | 14011 | 259 |
1016541 | 1016541 | 2021-02-10 | Rowan | North Carolina | 37159 | 13935 | 259 |
1013296 | 1013296 | 2021-02-09 | Rowan | North Carolina | 37159 | 13862 | 259 |
1010051 | 1010051 | 2021-02-08 | Rowan | North Carolina | 37159 | 13829 | 258 |
1006805 | 1006805 | 2021-02-07 | Rowan | North Carolina | 37159 | 13776 | 258 |
1003559 | 1003559 | 2021-02-06 | Rowan | North Carolina | 37159 | 13663 | 258 |
1000313 | 1000313 | 2021-02-05 | Rowan | North Carolina | 37159 | 13614 | 256 |
997067 | 997067 | 2021-02-04 | Rowan | North Carolina | 37159 | 13544 | 254 |
993821 | 993821 | 2021-02-03 | Rowan | North Carolina | 37159 | 13464 | 252 |
990575 | 990575 | 2021-02-02 | Rowan | North Carolina | 37159 | 13140 | 248 |
987329 | 987329 | 2021-02-01 | Rowan | North Carolina | 37159 | 13080 | 246 |
984082 | 984082 | 2021-01-31 | Rowan | North Carolina | 37159 | 12997 | 246 |
980835 | 980835 | 2021-01-30 | Rowan | North Carolina | 37159 | 12770 | 246 |
977589 | 977589 | 2021-01-29 | Rowan | North Carolina | 37159 | 12770 | 244 |
974344 | 974344 | 2021-01-28 | Rowan | North Carolina | 37159 | 12709 | 241 |
971099 | 971099 | 2021-01-27 | Rowan | North Carolina | 37159 | 12602 | 240 |
967854 | 967854 | 2021-01-26 | Rowan | North Carolina | 37159 | 12476 | 238 |
964610 | 964610 | 2021-01-25 | Rowan | North Carolina | 37159 | 12390 | 236 |
961365 | 961365 | 2021-01-24 | Rowan | North Carolina | 37159 | 12301 | 236 |
958120 | 958120 | 2021-01-23 | Rowan | North Carolina | 37159 | 12179 | 236 |
954874 | 954874 | 2021-01-22 | Rowan | North Carolina | 37159 | 12074 | 231 |
951629 | 951629 | 2021-01-21 | Rowan | North Carolina | 37159 | 11977 | 231 |
948384 | 948384 | 2021-01-20 | Rowan | North Carolina | 37159 | 11878 | 224 |
945137 | 945137 | 2021-01-19 | Rowan | North Carolina | 37159 | 11745 | 217 |
941891 | 941891 | 2021-01-18 | Rowan | North Carolina | 37159 | 11619 | 217 |
938646 | 938646 | 2021-01-17 | Rowan | North Carolina | 37159 | 11619 | 217 |
935401 | 935401 | 2021-01-16 | Rowan | North Carolina | 37159 | 11487 | 217 |
932156 | 932156 | 2021-01-15 | Rowan | North Carolina | 37159 | 11313 | 210 |
928911 | 928911 | 2021-01-14 | Rowan | North Carolina | 37159 | 11144 | 203 |
925666 | 925666 | 2021-01-13 | Rowan | North Carolina | 37159 | 10941 | 200 |
922420 | 922420 | 2021-01-12 | Rowan | North Carolina | 37159 | 10859 | 194 |
919175 | 919175 | 2021-01-11 | Rowan | North Carolina | 37159 | 10731 | 190 |
915930 | 915930 | 2021-01-10 | Rowan | North Carolina | 37159 | 10624 | 190 |
912685 | 912685 | 2021-01-09 | Rowan | North Carolina | 37159 | 10486 | 190 |
909440 | 909440 | 2021-01-08 | Rowan | North Carolina | 37159 | 10263 | 189 |
906195 | 906195 | 2021-01-07 | Rowan | North Carolina | 37159 | 10089 | 186 |
902949 | 902949 | 2021-01-06 | Rowan | North Carolina | 37159 | 9949 | 178 |
899704 | 899704 | 2021-01-05 | Rowan | North Carolina | 37159 | 9852 | 178 |
896459 | 896459 | 2021-01-04 | Rowan | North Carolina | 37159 | 9747 | 173 |
893213 | 893213 | 2021-01-03 | Rowan | North Carolina | 37159 | 9615 | 173 |
889967 | 889967 | 2021-01-02 | Rowan | North Carolina | 37159 | 9488 | 173 |
886720 | 886720 | 2021-01-01 | Rowan | North Carolina | 37159 | 9103 | 173 |
883475 | 883475 | 2020-12-31 | Rowan | North Carolina | 37159 | 9017 | 172 |
880230 | 880230 | 2020-12-30 | Rowan | North Carolina | 37159 | 8881 | 167 |
876985 | 876985 | 2020-12-29 | Rowan | North Carolina | 37159 | 8713 | 164 |
873740 | 873740 | 2020-12-28 | Rowan | North Carolina | 37159 | 8665 | 164 |
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);