ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where fips = 51013 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1196042 | 1196042 | 2021-04-06 | Arlington | Virginia | 51013 | 14464 | 249 |
1192794 | 1192794 | 2021-04-05 | Arlington | Virginia | 51013 | 14436 | 247 |
1189544 | 1189544 | 2021-04-04 | Arlington | Virginia | 51013 | 14412 | 246 |
1186297 | 1186297 | 2021-04-03 | Arlington | Virginia | 51013 | 14364 | 246 |
1183050 | 1183050 | 2021-04-02 | Arlington | Virginia | 51013 | 14319 | 246 |
1179803 | 1179803 | 2021-04-01 | Arlington | Virginia | 51013 | 14273 | 246 |
1176556 | 1176556 | 2021-03-31 | Arlington | Virginia | 51013 | 14227 | 246 |
1173309 | 1173309 | 2021-03-30 | Arlington | Virginia | 51013 | 14188 | 245 |
1170062 | 1170062 | 2021-03-29 | Arlington | Virginia | 51013 | 14156 | 245 |
1166814 | 1166814 | 2021-03-28 | Arlington | Virginia | 51013 | 14126 | 245 |
1163566 | 1163566 | 2021-03-27 | Arlington | Virginia | 51013 | 14081 | 245 |
1160318 | 1160318 | 2021-03-26 | Arlington | Virginia | 51013 | 14042 | 244 |
1157070 | 1157070 | 2021-03-25 | Arlington | Virginia | 51013 | 13997 | 244 |
1153823 | 1153823 | 2021-03-24 | Arlington | Virginia | 51013 | 13952 | 244 |
1150576 | 1150576 | 2021-03-23 | Arlington | Virginia | 51013 | 13915 | 243 |
1147329 | 1147329 | 2021-03-22 | Arlington | Virginia | 51013 | 13897 | 243 |
1144082 | 1144082 | 2021-03-21 | Arlington | Virginia | 51013 | 13882 | 242 |
1140835 | 1140835 | 2021-03-20 | Arlington | Virginia | 51013 | 13856 | 242 |
1137589 | 1137589 | 2021-03-19 | Arlington | Virginia | 51013 | 13811 | 242 |
1134343 | 1134343 | 2021-03-18 | Arlington | Virginia | 51013 | 13770 | 243 |
1131095 | 1131095 | 2021-03-17 | Arlington | Virginia | 51013 | 13729 | 243 |
1127848 | 1127848 | 2021-03-16 | Arlington | Virginia | 51013 | 13683 | 242 |
1124602 | 1124602 | 2021-03-15 | Arlington | Virginia | 51013 | 13655 | 242 |
1121356 | 1121356 | 2021-03-14 | Arlington | Virginia | 51013 | 13638 | 242 |
1118109 | 1118109 | 2021-03-13 | Arlington | Virginia | 51013 | 13603 | 242 |
1114862 | 1114862 | 2021-03-12 | Arlington | Virginia | 51013 | 13559 | 242 |
1111616 | 1111616 | 2021-03-11 | Arlington | Virginia | 51013 | 13526 | 241 |
1108370 | 1108370 | 2021-03-10 | Arlington | Virginia | 51013 | 13501 | 240 |
1105124 | 1105124 | 2021-03-09 | Arlington | Virginia | 51013 | 13481 | 240 |
1101878 | 1101878 | 2021-03-08 | Arlington | Virginia | 51013 | 13456 | 239 |
1098632 | 1098632 | 2021-03-07 | Arlington | Virginia | 51013 | 13433 | 237 |
1095384 | 1095384 | 2021-03-06 | Arlington | Virginia | 51013 | 13391 | 237 |
1092138 | 1092138 | 2021-03-05 | Arlington | Virginia | 51013 | 13342 | 236 |
1088892 | 1088892 | 2021-03-04 | Arlington | Virginia | 51013 | 13294 | 235 |
1085647 | 1085647 | 2021-03-03 | Arlington | Virginia | 51013 | 13255 | 235 |
1082401 | 1082401 | 2021-03-02 | Arlington | Virginia | 51013 | 13215 | 232 |
1079155 | 1079155 | 2021-03-01 | Arlington | Virginia | 51013 | 13182 | 229 |
1075910 | 1075910 | 2021-02-28 | Arlington | Virginia | 51013 | 13151 | 227 |
1072664 | 1072664 | 2021-02-27 | Arlington | Virginia | 51013 | 13112 | 223 |
1069418 | 1069418 | 2021-02-26 | Arlington | Virginia | 51013 | 13060 | 221 |
1066173 | 1066173 | 2021-02-25 | Arlington | Virginia | 51013 | 13020 | 219 |
1062928 | 1062928 | 2021-02-24 | Arlington | Virginia | 51013 | 12974 | 217 |
1059683 | 1059683 | 2021-02-23 | Arlington | Virginia | 51013 | 12922 | 217 |
1056437 | 1056437 | 2021-02-22 | Arlington | Virginia | 51013 | 12894 | 214 |
1053191 | 1053191 | 2021-02-21 | Arlington | Virginia | 51013 | 12870 | 213 |
1049944 | 1049944 | 2021-02-20 | Arlington | Virginia | 51013 | 12805 | 212 |
1046697 | 1046697 | 2021-02-19 | Arlington | Virginia | 51013 | 12768 | 212 |
1043452 | 1043452 | 2021-02-18 | Arlington | Virginia | 51013 | 12726 | 211 |
1040207 | 1040207 | 2021-02-17 | Arlington | Virginia | 51013 | 12684 | 210 |
1036962 | 1036962 | 2021-02-16 | Arlington | Virginia | 51013 | 12653 | 210 |
1033717 | 1033717 | 2021-02-15 | Arlington | Virginia | 51013 | 12611 | 209 |
1030471 | 1030471 | 2021-02-14 | Arlington | Virginia | 51013 | 12589 | 209 |
1027224 | 1027224 | 2021-02-13 | Arlington | Virginia | 51013 | 12550 | 209 |
1023979 | 1023979 | 2021-02-12 | Arlington | Virginia | 51013 | 12504 | 209 |
1020734 | 1020734 | 2021-02-11 | Arlington | Virginia | 51013 | 12440 | 209 |
1017489 | 1017489 | 2021-02-10 | Arlington | Virginia | 51013 | 12364 | 209 |
1014244 | 1014244 | 2021-02-09 | Arlington | Virginia | 51013 | 12306 | 208 |
1010999 | 1010999 | 2021-02-08 | Arlington | Virginia | 51013 | 12262 | 207 |
1007753 | 1007753 | 2021-02-07 | Arlington | Virginia | 51013 | 12221 | 206 |
1004507 | 1004507 | 2021-02-06 | Arlington | Virginia | 51013 | 12150 | 205 |
1001261 | 1001261 | 2021-02-05 | Arlington | Virginia | 51013 | 12034 | 205 |
998015 | 998015 | 2021-02-04 | Arlington | Virginia | 51013 | 11928 | 204 |
994769 | 994769 | 2021-02-03 | Arlington | Virginia | 51013 | 11867 | 203 |
991523 | 991523 | 2021-02-02 | Arlington | Virginia | 51013 | 11806 | 203 |
988277 | 988277 | 2021-02-01 | Arlington | Virginia | 51013 | 11769 | 201 |
985030 | 985030 | 2021-01-31 | Arlington | Virginia | 51013 | 11691 | 201 |
981783 | 981783 | 2021-01-30 | Arlington | Virginia | 51013 | 11648 | 201 |
978537 | 978537 | 2021-01-29 | Arlington | Virginia | 51013 | 11555 | 200 |
975292 | 975292 | 2021-01-28 | Arlington | Virginia | 51013 | 11487 | 199 |
972047 | 972047 | 2021-01-27 | Arlington | Virginia | 51013 | 11414 | 197 |
968802 | 968802 | 2021-01-26 | Arlington | Virginia | 51013 | 11341 | 197 |
965558 | 965558 | 2021-01-25 | Arlington | Virginia | 51013 | 11269 | 197 |
962313 | 962313 | 2021-01-24 | Arlington | Virginia | 51013 | 11149 | 197 |
959068 | 959068 | 2021-01-23 | Arlington | Virginia | 51013 | 11093 | 196 |
955822 | 955822 | 2021-01-22 | Arlington | Virginia | 51013 | 11006 | 196 |
952577 | 952577 | 2021-01-21 | Arlington | Virginia | 51013 | 10954 | 195 |
949332 | 949332 | 2021-01-20 | Arlington | Virginia | 51013 | 10913 | 192 |
946086 | 946086 | 2021-01-19 | Arlington | Virginia | 51013 | 10860 | 189 |
942839 | 942839 | 2021-01-18 | Arlington | Virginia | 51013 | 10790 | 188 |
939594 | 939594 | 2021-01-17 | Arlington | Virginia | 51013 | 10677 | 188 |
936349 | 936349 | 2021-01-16 | Arlington | Virginia | 51013 | 10520 | 187 |
933104 | 933104 | 2021-01-15 | Arlington | Virginia | 51013 | 10426 | 187 |
929859 | 929859 | 2021-01-14 | Arlington | Virginia | 51013 | 10359 | 187 |
926614 | 926614 | 2021-01-13 | Arlington | Virginia | 51013 | 10277 | 187 |
923368 | 923368 | 2021-01-12 | Arlington | Virginia | 51013 | 10202 | 186 |
920123 | 920123 | 2021-01-11 | Arlington | Virginia | 51013 | 10117 | 186 |
916878 | 916878 | 2021-01-10 | Arlington | Virginia | 51013 | 9997 | 185 |
913633 | 913633 | 2021-01-09 | Arlington | Virginia | 51013 | 9847 | 185 |
910388 | 910388 | 2021-01-08 | Arlington | Virginia | 51013 | 9654 | 185 |
907143 | 907143 | 2021-01-07 | Arlington | Virginia | 51013 | 9541 | 184 |
903897 | 903897 | 2021-01-06 | Arlington | Virginia | 51013 | 9420 | 184 |
900652 | 900652 | 2021-01-05 | Arlington | Virginia | 51013 | 9338 | 184 |
897407 | 897407 | 2021-01-04 | Arlington | Virginia | 51013 | 9290 | 182 |
894161 | 894161 | 2021-01-03 | Arlington | Virginia | 51013 | 9250 | 183 |
890915 | 890915 | 2021-01-02 | Arlington | Virginia | 51013 | 9145 | 181 |
887668 | 887668 | 2021-01-01 | Arlington | Virginia | 51013 | 8993 | 180 |
884423 | 884423 | 2020-12-31 | Arlington | Virginia | 51013 | 8872 | 180 |
881178 | 881178 | 2020-12-30 | Arlington | Virginia | 51013 | 8786 | 181 |
877933 | 877933 | 2020-12-29 | Arlington | Virginia | 51013 | 8687 | 180 |
874688 | 874688 | 2020-12-28 | Arlington | Virginia | 51013 | 8631 | 177 |
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);