ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 51700 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280553 | 1280553 | 2021-05-02 | Newport News city | Virginia | 51700 | 13794 | 224 |
1277306 | 1277306 | 2021-05-01 | Newport News city | Virginia | 51700 | 13766 | 224 |
1274059 | 1274059 | 2021-04-30 | Newport News city | Virginia | 51700 | 13740 | 223 |
1270812 | 1270812 | 2021-04-29 | Newport News city | Virginia | 51700 | 13705 | 223 |
1267565 | 1267565 | 2021-04-28 | Newport News city | Virginia | 51700 | 13678 | 223 |
1264318 | 1264318 | 2021-04-27 | Newport News city | Virginia | 51700 | 13653 | 222 |
1261071 | 1261071 | 2021-04-26 | Newport News city | Virginia | 51700 | 13630 | 222 |
1257824 | 1257824 | 2021-04-25 | Newport News city | Virginia | 51700 | 13622 | 222 |
1254577 | 1254577 | 2021-04-24 | Newport News city | Virginia | 51700 | 13596 | 221 |
1251330 | 1251330 | 2021-04-23 | Newport News city | Virginia | 51700 | 13566 | 221 |
1248083 | 1248083 | 2021-04-22 | Newport News city | Virginia | 51700 | 13525 | 220 |
1244836 | 1244836 | 2021-04-21 | Newport News city | Virginia | 51700 | 13499 | 220 |
1241589 | 1241589 | 2021-04-20 | Newport News city | Virginia | 51700 | 13473 | 220 |
1238342 | 1238342 | 2021-04-19 | Newport News city | Virginia | 51700 | 13439 | 219 |
1235095 | 1235095 | 2021-04-18 | Newport News city | Virginia | 51700 | 13414 | 219 |
1231847 | 1231847 | 2021-04-17 | Newport News city | Virginia | 51700 | 13386 | 219 |
1228599 | 1228599 | 2021-04-16 | Newport News city | Virginia | 51700 | 13347 | 219 |
1225351 | 1225351 | 2021-04-15 | Newport News city | Virginia | 51700 | 13310 | 219 |
1222104 | 1222104 | 2021-04-14 | Newport News city | Virginia | 51700 | 13262 | 218 |
1218856 | 1218856 | 2021-04-13 | Newport News city | Virginia | 51700 | 13226 | 217 |
1215608 | 1215608 | 2021-04-12 | Newport News city | Virginia | 51700 | 13160 | 216 |
1212361 | 1212361 | 2021-04-11 | Newport News city | Virginia | 51700 | 13133 | 215 |
1209112 | 1209112 | 2021-04-10 | Newport News city | Virginia | 51700 | 13115 | 215 |
1205864 | 1205864 | 2021-04-09 | Newport News city | Virginia | 51700 | 13086 | 215 |
1202616 | 1202616 | 2021-04-08 | Newport News city | Virginia | 51700 | 13043 | 214 |
1199368 | 1199368 | 2021-04-07 | Newport News city | Virginia | 51700 | 12984 | 214 |
1196119 | 1196119 | 2021-04-06 | Newport News city | Virginia | 51700 | 12944 | 214 |
1192871 | 1192871 | 2021-04-05 | Newport News city | Virginia | 51700 | 12903 | 212 |
1189621 | 1189621 | 2021-04-04 | Newport News city | Virginia | 51700 | 12877 | 211 |
1186374 | 1186374 | 2021-04-03 | Newport News city | Virginia | 51700 | 12842 | 211 |
1183127 | 1183127 | 2021-04-02 | Newport News city | Virginia | 51700 | 12805 | 208 |
1179880 | 1179880 | 2021-04-01 | Newport News city | Virginia | 51700 | 12747 | 208 |
1176633 | 1176633 | 2021-03-31 | Newport News city | Virginia | 51700 | 12687 | 208 |
1173386 | 1173386 | 2021-03-30 | Newport News city | Virginia | 51700 | 12651 | 208 |
1170139 | 1170139 | 2021-03-29 | Newport News city | Virginia | 51700 | 12592 | 208 |
1166891 | 1166891 | 2021-03-28 | Newport News city | Virginia | 51700 | 12564 | 208 |
1163643 | 1163643 | 2021-03-27 | Newport News city | Virginia | 51700 | 12525 | 207 |
1160395 | 1160395 | 2021-03-26 | Newport News city | Virginia | 51700 | 12447 | 204 |
1157147 | 1157147 | 2021-03-25 | Newport News city | Virginia | 51700 | 12400 | 204 |
1153900 | 1153900 | 2021-03-24 | Newport News city | Virginia | 51700 | 12377 | 203 |
1150653 | 1150653 | 2021-03-23 | Newport News city | Virginia | 51700 | 12337 | 203 |
1147406 | 1147406 | 2021-03-22 | Newport News city | Virginia | 51700 | 12303 | 203 |
1144159 | 1144159 | 2021-03-21 | Newport News city | Virginia | 51700 | 12279 | 202 |
1140912 | 1140912 | 2021-03-20 | Newport News city | Virginia | 51700 | 12243 | 202 |
1137666 | 1137666 | 2021-03-19 | Newport News city | Virginia | 51700 | 12201 | 202 |
1134420 | 1134420 | 2021-03-18 | Newport News city | Virginia | 51700 | 12145 | 205 |
1131172 | 1131172 | 2021-03-17 | Newport News city | Virginia | 51700 | 12081 | 204 |
1127925 | 1127925 | 2021-03-16 | Newport News city | Virginia | 51700 | 12038 | 204 |
1124679 | 1124679 | 2021-03-15 | Newport News city | Virginia | 51700 | 12009 | 203 |
1121433 | 1121433 | 2021-03-14 | Newport News city | Virginia | 51700 | 11985 | 202 |
1118186 | 1118186 | 2021-03-13 | Newport News city | Virginia | 51700 | 11951 | 200 |
1114939 | 1114939 | 2021-03-12 | Newport News city | Virginia | 51700 | 11918 | 199 |
1111693 | 1111693 | 2021-03-11 | Newport News city | Virginia | 51700 | 11883 | 199 |
1108447 | 1108447 | 2021-03-10 | Newport News city | Virginia | 51700 | 11838 | 198 |
1105201 | 1105201 | 2021-03-09 | Newport News city | Virginia | 51700 | 11788 | 191 |
1101955 | 1101955 | 2021-03-08 | Newport News city | Virginia | 51700 | 11753 | 190 |
1098709 | 1098709 | 2021-03-07 | Newport News city | Virginia | 51700 | 11735 | 190 |
1095461 | 1095461 | 2021-03-06 | Newport News city | Virginia | 51700 | 11708 | 190 |
1092215 | 1092215 | 2021-03-05 | Newport News city | Virginia | 51700 | 11688 | 190 |
1088969 | 1088969 | 2021-03-04 | Newport News city | Virginia | 51700 | 11619 | 190 |
1085724 | 1085724 | 2021-03-03 | Newport News city | Virginia | 51700 | 11567 | 190 |
1082478 | 1082478 | 2021-03-02 | Newport News city | Virginia | 51700 | 11525 | 182 |
1079232 | 1079232 | 2021-03-01 | Newport News city | Virginia | 51700 | 11489 | 176 |
1075987 | 1075987 | 2021-02-28 | Newport News city | Virginia | 51700 | 11468 | 161 |
1072741 | 1072741 | 2021-02-27 | Newport News city | Virginia | 51700 | 11431 | 158 |
1069495 | 1069495 | 2021-02-26 | Newport News city | Virginia | 51700 | 11384 | 148 |
1066250 | 1066250 | 2021-02-25 | Newport News city | Virginia | 51700 | 11344 | 141 |
1063005 | 1063005 | 2021-02-24 | Newport News city | Virginia | 51700 | 11267 | 140 |
1059760 | 1059760 | 2021-02-23 | Newport News city | Virginia | 51700 | 11214 | 138 |
1056514 | 1056514 | 2021-02-22 | Newport News city | Virginia | 51700 | 11160 | 135 |
1053268 | 1053268 | 2021-02-21 | Newport News city | Virginia | 51700 | 11128 | 132 |
1050021 | 1050021 | 2021-02-20 | Newport News city | Virginia | 51700 | 11051 | 118 |
1046774 | 1046774 | 2021-02-19 | Newport News city | Virginia | 51700 | 10995 | 115 |
1043529 | 1043529 | 2021-02-18 | Newport News city | Virginia | 51700 | 10931 | 116 |
1040284 | 1040284 | 2021-02-17 | Newport News city | Virginia | 51700 | 10900 | 117 |
1037039 | 1037039 | 2021-02-16 | Newport News city | Virginia | 51700 | 10828 | 117 |
1033794 | 1033794 | 2021-02-15 | Newport News city | Virginia | 51700 | 10801 | 117 |
1030548 | 1030548 | 2021-02-14 | Newport News city | Virginia | 51700 | 10744 | 117 |
1027301 | 1027301 | 2021-02-13 | Newport News city | Virginia | 51700 | 10647 | 113 |
1024056 | 1024056 | 2021-02-12 | Newport News city | Virginia | 51700 | 10594 | 113 |
1020811 | 1020811 | 2021-02-11 | Newport News city | Virginia | 51700 | 10546 | 113 |
1017566 | 1017566 | 2021-02-10 | Newport News city | Virginia | 51700 | 10489 | 113 |
1014321 | 1014321 | 2021-02-09 | Newport News city | Virginia | 51700 | 10418 | 113 |
1011076 | 1011076 | 2021-02-08 | Newport News city | Virginia | 51700 | 10344 | 109 |
1007830 | 1007830 | 2021-02-07 | Newport News city | Virginia | 51700 | 10285 | 103 |
1004584 | 1004584 | 2021-02-06 | Newport News city | Virginia | 51700 | 10173 | 103 |
1001338 | 1001338 | 2021-02-05 | Newport News city | Virginia | 51700 | 10102 | 103 |
998092 | 998092 | 2021-02-04 | Newport News city | Virginia | 51700 | 9983 | 101 |
994846 | 994846 | 2021-02-03 | Newport News city | Virginia | 51700 | 9931 | 100 |
991600 | 991600 | 2021-02-02 | Newport News city | Virginia | 51700 | 9895 | 97 |
988354 | 988354 | 2021-02-01 | Newport News city | Virginia | 51700 | 9838 | 97 |
985107 | 985107 | 2021-01-31 | Newport News city | Virginia | 51700 | 9772 | 97 |
981860 | 981860 | 2021-01-30 | Newport News city | Virginia | 51700 | 9728 | 93 |
978614 | 978614 | 2021-01-29 | Newport News city | Virginia | 51700 | 9635 | 89 |
975369 | 975369 | 2021-01-28 | Newport News city | Virginia | 51700 | 9534 | 87 |
972124 | 972124 | 2021-01-27 | Newport News city | Virginia | 51700 | 9401 | 87 |
968879 | 968879 | 2021-01-26 | Newport News city | Virginia | 51700 | 9216 | 87 |
965635 | 965635 | 2021-01-25 | Newport News city | Virginia | 51700 | 9034 | 83 |
962390 | 962390 | 2021-01-24 | Newport News city | Virginia | 51700 | 8818 | 83 |
959145 | 959145 | 2021-01-23 | Newport News city | Virginia | 51700 | 8696 | 83 |
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);