ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Stafford" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280586 | 1280586 | 2021-05-02 | Stafford | Virginia | 51179 | 11106 | 75 |
1277339 | 1277339 | 2021-05-01 | Stafford | Virginia | 51179 | 11092 | 75 |
1274092 | 1274092 | 2021-04-30 | Stafford | Virginia | 51179 | 11067 | 75 |
1270845 | 1270845 | 2021-04-29 | Stafford | Virginia | 51179 | 11031 | 75 |
1267598 | 1267598 | 2021-04-28 | Stafford | Virginia | 51179 | 11007 | 75 |
1264351 | 1264351 | 2021-04-27 | Stafford | Virginia | 51179 | 10979 | 74 |
1261104 | 1261104 | 2021-04-26 | Stafford | Virginia | 51179 | 10958 | 74 |
1257857 | 1257857 | 2021-04-25 | Stafford | Virginia | 51179 | 10946 | 74 |
1254610 | 1254610 | 2021-04-24 | Stafford | Virginia | 51179 | 10922 | 74 |
1251363 | 1251363 | 2021-04-23 | Stafford | Virginia | 51179 | 10906 | 74 |
1248116 | 1248116 | 2021-04-22 | Stafford | Virginia | 51179 | 10867 | 73 |
1244869 | 1244869 | 2021-04-21 | Stafford | Virginia | 51179 | 10831 | 72 |
1241622 | 1241622 | 2021-04-20 | Stafford | Virginia | 51179 | 10789 | 72 |
1238375 | 1238375 | 2021-04-19 | Stafford | Virginia | 51179 | 10754 | 72 |
1235128 | 1235128 | 2021-04-18 | Stafford | Virginia | 51179 | 10739 | 72 |
1231880 | 1231880 | 2021-04-17 | Stafford | Virginia | 51179 | 10705 | 72 |
1228632 | 1228632 | 2021-04-16 | Stafford | Virginia | 51179 | 10658 | 72 |
1225384 | 1225384 | 2021-04-15 | Stafford | Virginia | 51179 | 10630 | 72 |
1222137 | 1222137 | 2021-04-14 | Stafford | Virginia | 51179 | 10599 | 72 |
1218889 | 1218889 | 2021-04-13 | Stafford | Virginia | 51179 | 10560 | 72 |
1215641 | 1215641 | 2021-04-12 | Stafford | Virginia | 51179 | 10519 | 71 |
1212394 | 1212394 | 2021-04-11 | Stafford | Virginia | 51179 | 10476 | 71 |
1209145 | 1209145 | 2021-04-10 | Stafford | Virginia | 51179 | 10454 | 71 |
1205897 | 1205897 | 2021-04-09 | Stafford | Virginia | 51179 | 10418 | 71 |
1202649 | 1202649 | 2021-04-08 | Stafford | Virginia | 51179 | 10393 | 71 |
1199401 | 1199401 | 2021-04-07 | Stafford | Virginia | 51179 | 10359 | 71 |
1196152 | 1196152 | 2021-04-06 | Stafford | Virginia | 51179 | 10332 | 70 |
1192904 | 1192904 | 2021-04-05 | Stafford | Virginia | 51179 | 10299 | 70 |
1189654 | 1189654 | 2021-04-04 | Stafford | Virginia | 51179 | 10284 | 70 |
1186407 | 1186407 | 2021-04-03 | Stafford | Virginia | 51179 | 10264 | 69 |
1183160 | 1183160 | 2021-04-02 | Stafford | Virginia | 51179 | 10241 | 69 |
1179913 | 1179913 | 2021-04-01 | Stafford | Virginia | 51179 | 10197 | 69 |
1176666 | 1176666 | 2021-03-31 | Stafford | Virginia | 51179 | 10150 | 69 |
1173419 | 1173419 | 2021-03-30 | Stafford | Virginia | 51179 | 10132 | 69 |
1170172 | 1170172 | 2021-03-29 | Stafford | Virginia | 51179 | 10109 | 69 |
1166924 | 1166924 | 2021-03-28 | Stafford | Virginia | 51179 | 10093 | 68 |
1163676 | 1163676 | 2021-03-27 | Stafford | Virginia | 51179 | 10081 | 68 |
1160428 | 1160428 | 2021-03-26 | Stafford | Virginia | 51179 | 10059 | 68 |
1157180 | 1157180 | 2021-03-25 | Stafford | Virginia | 51179 | 10036 | 68 |
1153933 | 1153933 | 2021-03-24 | Stafford | Virginia | 51179 | 9998 | 68 |
1150686 | 1150686 | 2021-03-23 | Stafford | Virginia | 51179 | 9970 | 68 |
1147439 | 1147439 | 2021-03-22 | Stafford | Virginia | 51179 | 9947 | 68 |
1144192 | 1144192 | 2021-03-21 | Stafford | Virginia | 51179 | 9928 | 68 |
1140945 | 1140945 | 2021-03-20 | Stafford | Virginia | 51179 | 9915 | 68 |
1137699 | 1137699 | 2021-03-19 | Stafford | Virginia | 51179 | 9891 | 68 |
1134453 | 1134453 | 2021-03-18 | Stafford | Virginia | 51179 | 9876 | 69 |
1131205 | 1131205 | 2021-03-17 | Stafford | Virginia | 51179 | 9858 | 69 |
1127958 | 1127958 | 2021-03-16 | Stafford | Virginia | 51179 | 9837 | 69 |
1124712 | 1124712 | 2021-03-15 | Stafford | Virginia | 51179 | 9843 | 70 |
1121466 | 1121466 | 2021-03-14 | Stafford | Virginia | 51179 | 9828 | 70 |
1118219 | 1118219 | 2021-03-13 | Stafford | Virginia | 51179 | 9802 | 69 |
1114972 | 1114972 | 2021-03-12 | Stafford | Virginia | 51179 | 9778 | 69 |
1111726 | 1111726 | 2021-03-11 | Stafford | Virginia | 51179 | 9754 | 69 |
1108480 | 1108480 | 2021-03-10 | Stafford | Virginia | 51179 | 9736 | 68 |
1105234 | 1105234 | 2021-03-09 | Stafford | Virginia | 51179 | 9715 | 69 |
1101988 | 1101988 | 2021-03-08 | Stafford | Virginia | 51179 | 9687 | 68 |
1098742 | 1098742 | 2021-03-07 | Stafford | Virginia | 51179 | 9671 | 68 |
1095494 | 1095494 | 2021-03-06 | Stafford | Virginia | 51179 | 9659 | 68 |
1092248 | 1092248 | 2021-03-05 | Stafford | Virginia | 51179 | 9649 | 68 |
1089002 | 1089002 | 2021-03-04 | Stafford | Virginia | 51179 | 9653 | 68 |
1085757 | 1085757 | 2021-03-03 | Stafford | Virginia | 51179 | 9644 | 68 |
1082511 | 1082511 | 2021-03-02 | Stafford | Virginia | 51179 | 9620 | 68 |
1079265 | 1079265 | 2021-03-01 | Stafford | Virginia | 51179 | 9582 | 67 |
1076020 | 1076020 | 2021-02-28 | Stafford | Virginia | 51179 | 9555 | 67 |
1072774 | 1072774 | 2021-02-27 | Stafford | Virginia | 51179 | 9491 | 66 |
1069528 | 1069528 | 2021-02-26 | Stafford | Virginia | 51179 | 9479 | 66 |
1066283 | 1066283 | 2021-02-25 | Stafford | Virginia | 51179 | 9448 | 65 |
1063038 | 1063038 | 2021-02-24 | Stafford | Virginia | 51179 | 9418 | 65 |
1059793 | 1059793 | 2021-02-23 | Stafford | Virginia | 51179 | 9368 | 64 |
1056547 | 1056547 | 2021-02-22 | Stafford | Virginia | 51179 | 9341 | 61 |
1053301 | 1053301 | 2021-02-21 | Stafford | Virginia | 51179 | 9333 | 58 |
1050054 | 1050054 | 2021-02-20 | Stafford | Virginia | 51179 | 9320 | 55 |
1046807 | 1046807 | 2021-02-19 | Stafford | Virginia | 51179 | 9312 | 55 |
1043562 | 1043562 | 2021-02-18 | Stafford | Virginia | 51179 | 9290 | 55 |
1040317 | 1040317 | 2021-02-17 | Stafford | Virginia | 51179 | 9252 | 54 |
1037072 | 1037072 | 2021-02-16 | Stafford | Virginia | 51179 | 9199 | 54 |
1033827 | 1033827 | 2021-02-15 | Stafford | Virginia | 51179 | 9159 | 54 |
1030581 | 1030581 | 2021-02-14 | Stafford | Virginia | 51179 | 9140 | 54 |
1027334 | 1027334 | 2021-02-13 | Stafford | Virginia | 51179 | 9061 | 54 |
1024089 | 1024089 | 2021-02-12 | Stafford | Virginia | 51179 | 9015 | 54 |
1020844 | 1020844 | 2021-02-11 | Stafford | Virginia | 51179 | 8839 | 53 |
1017599 | 1017599 | 2021-02-10 | Stafford | Virginia | 51179 | 8727 | 53 |
1014354 | 1014354 | 2021-02-09 | Stafford | Virginia | 51179 | 8623 | 53 |
1011109 | 1011109 | 2021-02-08 | Stafford | Virginia | 51179 | 8554 | 52 |
1007863 | 1007863 | 2021-02-07 | Stafford | Virginia | 51179 | 8525 | 52 |
1004617 | 1004617 | 2021-02-06 | Stafford | Virginia | 51179 | 8490 | 52 |
1001371 | 1001371 | 2021-02-05 | Stafford | Virginia | 51179 | 8299 | 51 |
998125 | 998125 | 2021-02-04 | Stafford | Virginia | 51179 | 8183 | 50 |
994879 | 994879 | 2021-02-03 | Stafford | Virginia | 51179 | 8123 | 50 |
991633 | 991633 | 2021-02-02 | Stafford | Virginia | 51179 | 8058 | 50 |
988387 | 988387 | 2021-02-01 | Stafford | Virginia | 51179 | 8005 | 48 |
985140 | 985140 | 2021-01-31 | Stafford | Virginia | 51179 | 7956 | 48 |
981893 | 981893 | 2021-01-30 | Stafford | Virginia | 51179 | 7909 | 48 |
978647 | 978647 | 2021-01-29 | Stafford | Virginia | 51179 | 7766 | 46 |
975402 | 975402 | 2021-01-28 | Stafford | Virginia | 51179 | 7687 | 46 |
972157 | 972157 | 2021-01-27 | Stafford | Virginia | 51179 | 7586 | 45 |
968912 | 968912 | 2021-01-26 | Stafford | Virginia | 51179 | 7489 | 44 |
965668 | 965668 | 2021-01-25 | Stafford | Virginia | 51179 | 7341 | 42 |
962423 | 962423 | 2021-01-24 | Stafford | Virginia | 51179 | 7210 | 42 |
959178 | 959178 | 2021-01-23 | Stafford | Virginia | 51179 | 7169 | 42 |
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);