ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Spotsylvania" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280585 | 1280585 | 2021-05-02 | Spotsylvania | Virginia | 51177 | 9733 | 115 |
1277338 | 1277338 | 2021-05-01 | Spotsylvania | Virginia | 51177 | 9717 | 114 |
1274091 | 1274091 | 2021-04-30 | Spotsylvania | Virginia | 51177 | 9693 | 114 |
1270844 | 1270844 | 2021-04-29 | Spotsylvania | Virginia | 51177 | 9675 | 114 |
1267597 | 1267597 | 2021-04-28 | Spotsylvania | Virginia | 51177 | 9639 | 113 |
1264350 | 1264350 | 2021-04-27 | Spotsylvania | Virginia | 51177 | 9596 | 113 |
1261103 | 1261103 | 2021-04-26 | Spotsylvania | Virginia | 51177 | 9572 | 113 |
1257856 | 1257856 | 2021-04-25 | Spotsylvania | Virginia | 51177 | 9561 | 113 |
1254609 | 1254609 | 2021-04-24 | Spotsylvania | Virginia | 51177 | 9545 | 113 |
1251362 | 1251362 | 2021-04-23 | Spotsylvania | Virginia | 51177 | 9524 | 113 |
1248115 | 1248115 | 2021-04-22 | Spotsylvania | Virginia | 51177 | 9503 | 113 |
1244868 | 1244868 | 2021-04-21 | Spotsylvania | Virginia | 51177 | 9473 | 113 |
1241621 | 1241621 | 2021-04-20 | Spotsylvania | Virginia | 51177 | 9449 | 113 |
1238374 | 1238374 | 2021-04-19 | Spotsylvania | Virginia | 51177 | 9411 | 113 |
1235127 | 1235127 | 2021-04-18 | Spotsylvania | Virginia | 51177 | 9395 | 113 |
1231879 | 1231879 | 2021-04-17 | Spotsylvania | Virginia | 51177 | 9358 | 113 |
1228631 | 1228631 | 2021-04-16 | Spotsylvania | Virginia | 51177 | 9324 | 112 |
1225383 | 1225383 | 2021-04-15 | Spotsylvania | Virginia | 51177 | 9296 | 110 |
1222136 | 1222136 | 2021-04-14 | Spotsylvania | Virginia | 51177 | 9260 | 110 |
1218888 | 1218888 | 2021-04-13 | Spotsylvania | Virginia | 51177 | 9230 | 110 |
1215640 | 1215640 | 2021-04-12 | Spotsylvania | Virginia | 51177 | 9204 | 110 |
1212393 | 1212393 | 2021-04-11 | Spotsylvania | Virginia | 51177 | 9174 | 109 |
1209144 | 1209144 | 2021-04-10 | Spotsylvania | Virginia | 51177 | 9136 | 109 |
1205896 | 1205896 | 2021-04-09 | Spotsylvania | Virginia | 51177 | 9091 | 109 |
1202648 | 1202648 | 2021-04-08 | Spotsylvania | Virginia | 51177 | 9061 | 109 |
1199400 | 1199400 | 2021-04-07 | Spotsylvania | Virginia | 51177 | 9017 | 109 |
1196151 | 1196151 | 2021-04-06 | Spotsylvania | Virginia | 51177 | 8993 | 109 |
1192903 | 1192903 | 2021-04-05 | Spotsylvania | Virginia | 51177 | 8965 | 109 |
1189653 | 1189653 | 2021-04-04 | Spotsylvania | Virginia | 51177 | 8950 | 109 |
1186406 | 1186406 | 2021-04-03 | Spotsylvania | Virginia | 51177 | 8922 | 108 |
1183159 | 1183159 | 2021-04-02 | Spotsylvania | Virginia | 51177 | 8894 | 108 |
1179912 | 1179912 | 2021-04-01 | Spotsylvania | Virginia | 51177 | 8876 | 108 |
1176665 | 1176665 | 2021-03-31 | Spotsylvania | Virginia | 51177 | 8845 | 108 |
1173418 | 1173418 | 2021-03-30 | Spotsylvania | Virginia | 51177 | 8840 | 107 |
1170171 | 1170171 | 2021-03-29 | Spotsylvania | Virginia | 51177 | 8818 | 107 |
1166923 | 1166923 | 2021-03-28 | Spotsylvania | Virginia | 51177 | 8790 | 107 |
1163675 | 1163675 | 2021-03-27 | Spotsylvania | Virginia | 51177 | 8769 | 107 |
1160427 | 1160427 | 2021-03-26 | Spotsylvania | Virginia | 51177 | 8737 | 107 |
1157179 | 1157179 | 2021-03-25 | Spotsylvania | Virginia | 51177 | 8702 | 107 |
1153932 | 1153932 | 2021-03-24 | Spotsylvania | Virginia | 51177 | 8678 | 107 |
1150685 | 1150685 | 2021-03-23 | Spotsylvania | Virginia | 51177 | 8655 | 107 |
1147438 | 1147438 | 2021-03-22 | Spotsylvania | Virginia | 51177 | 8641 | 107 |
1144191 | 1144191 | 2021-03-21 | Spotsylvania | Virginia | 51177 | 8623 | 107 |
1140944 | 1140944 | 2021-03-20 | Spotsylvania | Virginia | 51177 | 8616 | 107 |
1137698 | 1137698 | 2021-03-19 | Spotsylvania | Virginia | 51177 | 8598 | 107 |
1134452 | 1134452 | 2021-03-18 | Spotsylvania | Virginia | 51177 | 8581 | 107 |
1131204 | 1131204 | 2021-03-17 | Spotsylvania | Virginia | 51177 | 8578 | 106 |
1127957 | 1127957 | 2021-03-16 | Spotsylvania | Virginia | 51177 | 8565 | 106 |
1124711 | 1124711 | 2021-03-15 | Spotsylvania | Virginia | 51177 | 8562 | 106 |
1121465 | 1121465 | 2021-03-14 | Spotsylvania | Virginia | 51177 | 8551 | 106 |
1118218 | 1118218 | 2021-03-13 | Spotsylvania | Virginia | 51177 | 8548 | 106 |
1114971 | 1114971 | 2021-03-12 | Spotsylvania | Virginia | 51177 | 8540 | 104 |
1111725 | 1111725 | 2021-03-11 | Spotsylvania | Virginia | 51177 | 8519 | 104 |
1108479 | 1108479 | 2021-03-10 | Spotsylvania | Virginia | 51177 | 8502 | 103 |
1105233 | 1105233 | 2021-03-09 | Spotsylvania | Virginia | 51177 | 8472 | 103 |
1101987 | 1101987 | 2021-03-08 | Spotsylvania | Virginia | 51177 | 8445 | 103 |
1098741 | 1098741 | 2021-03-07 | Spotsylvania | Virginia | 51177 | 8439 | 102 |
1095493 | 1095493 | 2021-03-06 | Spotsylvania | Virginia | 51177 | 8418 | 102 |
1092247 | 1092247 | 2021-03-05 | Spotsylvania | Virginia | 51177 | 8402 | 102 |
1089001 | 1089001 | 2021-03-04 | Spotsylvania | Virginia | 51177 | 8385 | 102 |
1085756 | 1085756 | 2021-03-03 | Spotsylvania | Virginia | 51177 | 8367 | 102 |
1082510 | 1082510 | 2021-03-02 | Spotsylvania | Virginia | 51177 | 8341 | 100 |
1079264 | 1079264 | 2021-03-01 | Spotsylvania | Virginia | 51177 | 8300 | 100 |
1076019 | 1076019 | 2021-02-28 | Spotsylvania | Virginia | 51177 | 8281 | 99 |
1072773 | 1072773 | 2021-02-27 | Spotsylvania | Virginia | 51177 | 8270 | 98 |
1069527 | 1069527 | 2021-02-26 | Spotsylvania | Virginia | 51177 | 8251 | 97 |
1066282 | 1066282 | 2021-02-25 | Spotsylvania | Virginia | 51177 | 8221 | 96 |
1063037 | 1063037 | 2021-02-24 | Spotsylvania | Virginia | 51177 | 8190 | 95 |
1059792 | 1059792 | 2021-02-23 | Spotsylvania | Virginia | 51177 | 8156 | 93 |
1056546 | 1056546 | 2021-02-22 | Spotsylvania | Virginia | 51177 | 8140 | 89 |
1053300 | 1053300 | 2021-02-21 | Spotsylvania | Virginia | 51177 | 8121 | 88 |
1050053 | 1050053 | 2021-02-20 | Spotsylvania | Virginia | 51177 | 8094 | 88 |
1046806 | 1046806 | 2021-02-19 | Spotsylvania | Virginia | 51177 | 8070 | 88 |
1043561 | 1043561 | 2021-02-18 | Spotsylvania | Virginia | 51177 | 8043 | 88 |
1040316 | 1040316 | 2021-02-17 | Spotsylvania | Virginia | 51177 | 8011 | 88 |
1037071 | 1037071 | 2021-02-16 | Spotsylvania | Virginia | 51177 | 7975 | 88 |
1033826 | 1033826 | 2021-02-15 | Spotsylvania | Virginia | 51177 | 7935 | 88 |
1030580 | 1030580 | 2021-02-14 | Spotsylvania | Virginia | 51177 | 7920 | 88 |
1027333 | 1027333 | 2021-02-13 | Spotsylvania | Virginia | 51177 | 7884 | 88 |
1024088 | 1024088 | 2021-02-12 | Spotsylvania | Virginia | 51177 | 7852 | 87 |
1020843 | 1020843 | 2021-02-11 | Spotsylvania | Virginia | 51177 | 7799 | 87 |
1017598 | 1017598 | 2021-02-10 | Spotsylvania | Virginia | 51177 | 7744 | 87 |
1014353 | 1014353 | 2021-02-09 | Spotsylvania | Virginia | 51177 | 7705 | 87 |
1011108 | 1011108 | 2021-02-08 | Spotsylvania | Virginia | 51177 | 7641 | 87 |
1007862 | 1007862 | 2021-02-07 | Spotsylvania | Virginia | 51177 | 7611 | 87 |
1004616 | 1004616 | 2021-02-06 | Spotsylvania | Virginia | 51177 | 7576 | 87 |
1001370 | 1001370 | 2021-02-05 | Spotsylvania | Virginia | 51177 | 7486 | 87 |
998124 | 998124 | 2021-02-04 | Spotsylvania | Virginia | 51177 | 7380 | 84 |
994878 | 994878 | 2021-02-03 | Spotsylvania | Virginia | 51177 | 7322 | 83 |
991632 | 991632 | 2021-02-02 | Spotsylvania | Virginia | 51177 | 7282 | 83 |
988386 | 988386 | 2021-02-01 | Spotsylvania | Virginia | 51177 | 7246 | 82 |
985139 | 985139 | 2021-01-31 | Spotsylvania | Virginia | 51177 | 7194 | 82 |
981892 | 981892 | 2021-01-30 | Spotsylvania | Virginia | 51177 | 7150 | 82 |
978646 | 978646 | 2021-01-29 | Spotsylvania | Virginia | 51177 | 7077 | 81 |
975401 | 975401 | 2021-01-28 | Spotsylvania | Virginia | 51177 | 6974 | 80 |
972156 | 972156 | 2021-01-27 | Spotsylvania | Virginia | 51177 | 6879 | 80 |
968911 | 968911 | 2021-01-26 | Spotsylvania | Virginia | 51177 | 6820 | 79 |
965667 | 965667 | 2021-01-25 | Spotsylvania | Virginia | 51177 | 6697 | 78 |
962422 | 962422 | 2021-01-24 | Spotsylvania | Virginia | 51177 | 6600 | 78 |
959177 | 959177 | 2021-01-23 | Spotsylvania | Virginia | 51177 | 6551 | 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);