ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 51003 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280470 | 1280470 | 2021-05-02 | Albemarle | Virginia | 51003 | 5708 | 83 |
1277223 | 1277223 | 2021-05-01 | Albemarle | Virginia | 51003 | 5705 | 83 |
1273976 | 1273976 | 2021-04-30 | Albemarle | Virginia | 51003 | 5704 | 83 |
1270729 | 1270729 | 2021-04-29 | Albemarle | Virginia | 51003 | 5698 | 82 |
1267482 | 1267482 | 2021-04-28 | Albemarle | Virginia | 51003 | 5677 | 82 |
1264235 | 1264235 | 2021-04-27 | Albemarle | Virginia | 51003 | 5673 | 82 |
1260988 | 1260988 | 2021-04-26 | Albemarle | Virginia | 51003 | 5666 | 82 |
1257741 | 1257741 | 2021-04-25 | Albemarle | Virginia | 51003 | 5661 | 82 |
1254494 | 1254494 | 2021-04-24 | Albemarle | Virginia | 51003 | 5652 | 82 |
1251247 | 1251247 | 2021-04-23 | Albemarle | Virginia | 51003 | 5646 | 82 |
1248000 | 1248000 | 2021-04-22 | Albemarle | Virginia | 51003 | 5635 | 82 |
1244753 | 1244753 | 2021-04-21 | Albemarle | Virginia | 51003 | 5620 | 82 |
1241506 | 1241506 | 2021-04-20 | Albemarle | Virginia | 51003 | 5555 | 82 |
1238259 | 1238259 | 2021-04-19 | Albemarle | Virginia | 51003 | 5535 | 82 |
1235012 | 1235012 | 2021-04-18 | Albemarle | Virginia | 51003 | 5526 | 82 |
1231764 | 1231764 | 2021-04-17 | Albemarle | Virginia | 51003 | 5515 | 82 |
1228516 | 1228516 | 2021-04-16 | Albemarle | Virginia | 51003 | 5506 | 82 |
1225268 | 1225268 | 2021-04-15 | Albemarle | Virginia | 51003 | 5491 | 82 |
1222021 | 1222021 | 2021-04-14 | Albemarle | Virginia | 51003 | 5470 | 82 |
1218773 | 1218773 | 2021-04-13 | Albemarle | Virginia | 51003 | 5448 | 82 |
1215525 | 1215525 | 2021-04-12 | Albemarle | Virginia | 51003 | 5424 | 82 |
1212278 | 1212278 | 2021-04-11 | Albemarle | Virginia | 51003 | 5420 | 82 |
1209029 | 1209029 | 2021-04-10 | Albemarle | Virginia | 51003 | 5409 | 82 |
1205781 | 1205781 | 2021-04-09 | Albemarle | Virginia | 51003 | 5402 | 82 |
1202533 | 1202533 | 2021-04-08 | Albemarle | Virginia | 51003 | 5393 | 82 |
1199285 | 1199285 | 2021-04-07 | Albemarle | Virginia | 51003 | 5379 | 78 |
1196036 | 1196036 | 2021-04-06 | Albemarle | Virginia | 51003 | 5348 | 78 |
1192788 | 1192788 | 2021-04-05 | Albemarle | Virginia | 51003 | 5335 | 77 |
1189538 | 1189538 | 2021-04-04 | Albemarle | Virginia | 51003 | 5328 | 77 |
1186291 | 1186291 | 2021-04-03 | Albemarle | Virginia | 51003 | 5313 | 77 |
1183044 | 1183044 | 2021-04-02 | Albemarle | Virginia | 51003 | 5296 | 77 |
1179797 | 1179797 | 2021-04-01 | Albemarle | Virginia | 51003 | 5284 | 77 |
1176550 | 1176550 | 2021-03-31 | Albemarle | Virginia | 51003 | 5275 | 77 |
1173303 | 1173303 | 2021-03-30 | Albemarle | Virginia | 51003 | 5267 | 77 |
1170056 | 1170056 | 2021-03-29 | Albemarle | Virginia | 51003 | 5260 | 76 |
1166808 | 1166808 | 2021-03-28 | Albemarle | Virginia | 51003 | 5258 | 76 |
1163560 | 1163560 | 2021-03-27 | Albemarle | Virginia | 51003 | 5237 | 76 |
1160312 | 1160312 | 2021-03-26 | Albemarle | Virginia | 51003 | 5220 | 76 |
1157064 | 1157064 | 2021-03-25 | Albemarle | Virginia | 51003 | 5210 | 76 |
1153817 | 1153817 | 2021-03-24 | Albemarle | Virginia | 51003 | 5197 | 76 |
1150570 | 1150570 | 2021-03-23 | Albemarle | Virginia | 51003 | 5176 | 76 |
1147323 | 1147323 | 2021-03-22 | Albemarle | Virginia | 51003 | 5170 | 76 |
1144076 | 1144076 | 2021-03-21 | Albemarle | Virginia | 51003 | 5161 | 76 |
1140829 | 1140829 | 2021-03-20 | Albemarle | Virginia | 51003 | 5137 | 76 |
1137583 | 1137583 | 2021-03-19 | Albemarle | Virginia | 51003 | 5125 | 76 |
1134337 | 1134337 | 2021-03-18 | Albemarle | Virginia | 51003 | 5102 | 76 |
1131089 | 1131089 | 2021-03-17 | Albemarle | Virginia | 51003 | 5081 | 77 |
1127842 | 1127842 | 2021-03-16 | Albemarle | Virginia | 51003 | 5063 | 77 |
1124596 | 1124596 | 2021-03-15 | Albemarle | Virginia | 51003 | 5055 | 77 |
1121350 | 1121350 | 2021-03-14 | Albemarle | Virginia | 51003 | 5045 | 76 |
1118103 | 1118103 | 2021-03-13 | Albemarle | Virginia | 51003 | 5039 | 76 |
1114856 | 1114856 | 2021-03-12 | Albemarle | Virginia | 51003 | 5025 | 76 |
1111610 | 1111610 | 2021-03-11 | Albemarle | Virginia | 51003 | 5010 | 74 |
1108364 | 1108364 | 2021-03-10 | Albemarle | Virginia | 51003 | 4988 | 74 |
1105118 | 1105118 | 2021-03-09 | Albemarle | Virginia | 51003 | 4979 | 74 |
1101872 | 1101872 | 2021-03-08 | Albemarle | Virginia | 51003 | 4977 | 74 |
1098626 | 1098626 | 2021-03-07 | Albemarle | Virginia | 51003 | 4973 | 72 |
1095378 | 1095378 | 2021-03-06 | Albemarle | Virginia | 51003 | 4964 | 72 |
1092132 | 1092132 | 2021-03-05 | Albemarle | Virginia | 51003 | 4946 | 71 |
1088886 | 1088886 | 2021-03-04 | Albemarle | Virginia | 51003 | 4925 | 70 |
1085641 | 1085641 | 2021-03-03 | Albemarle | Virginia | 51003 | 4898 | 69 |
1082395 | 1082395 | 2021-03-02 | Albemarle | Virginia | 51003 | 4867 | 62 |
1079149 | 1079149 | 2021-03-01 | Albemarle | Virginia | 51003 | 4850 | 62 |
1075904 | 1075904 | 2021-02-28 | Albemarle | Virginia | 51003 | 4840 | 60 |
1072658 | 1072658 | 2021-02-27 | Albemarle | Virginia | 51003 | 4821 | 57 |
1069412 | 1069412 | 2021-02-26 | Albemarle | Virginia | 51003 | 4807 | 54 |
1066167 | 1066167 | 2021-02-25 | Albemarle | Virginia | 51003 | 4796 | 50 |
1062922 | 1062922 | 2021-02-24 | Albemarle | Virginia | 51003 | 4759 | 48 |
1059677 | 1059677 | 2021-02-23 | Albemarle | Virginia | 51003 | 4679 | 44 |
1056431 | 1056431 | 2021-02-22 | Albemarle | Virginia | 51003 | 4641 | 43 |
1053185 | 1053185 | 2021-02-21 | Albemarle | Virginia | 51003 | 4630 | 39 |
1049938 | 1049938 | 2021-02-20 | Albemarle | Virginia | 51003 | 4579 | 39 |
1046691 | 1046691 | 2021-02-19 | Albemarle | Virginia | 51003 | 4530 | 39 |
1043446 | 1043446 | 2021-02-18 | Albemarle | Virginia | 51003 | 4454 | 39 |
1040201 | 1040201 | 2021-02-17 | Albemarle | Virginia | 51003 | 4319 | 39 |
1036956 | 1036956 | 2021-02-16 | Albemarle | Virginia | 51003 | 4251 | 39 |
1033711 | 1033711 | 2021-02-15 | Albemarle | Virginia | 51003 | 4235 | 39 |
1030465 | 1030465 | 2021-02-14 | Albemarle | Virginia | 51003 | 4220 | 39 |
1027218 | 1027218 | 2021-02-13 | Albemarle | Virginia | 51003 | 4210 | 39 |
1023973 | 1023973 | 2021-02-12 | Albemarle | Virginia | 51003 | 4181 | 39 |
1020728 | 1020728 | 2021-02-11 | Albemarle | Virginia | 51003 | 4164 | 39 |
1017483 | 1017483 | 2021-02-10 | Albemarle | Virginia | 51003 | 4132 | 39 |
1014238 | 1014238 | 2021-02-09 | Albemarle | Virginia | 51003 | 4102 | 39 |
1010993 | 1010993 | 2021-02-08 | Albemarle | Virginia | 51003 | 4088 | 38 |
1007747 | 1007747 | 2021-02-07 | Albemarle | Virginia | 51003 | 4082 | 38 |
1004501 | 1004501 | 2021-02-06 | Albemarle | Virginia | 51003 | 4048 | 38 |
1001255 | 1001255 | 2021-02-05 | Albemarle | Virginia | 51003 | 4016 | 37 |
998009 | 998009 | 2021-02-04 | Albemarle | Virginia | 51003 | 3979 | 37 |
994763 | 994763 | 2021-02-03 | Albemarle | Virginia | 51003 | 3966 | 36 |
991517 | 991517 | 2021-02-02 | Albemarle | Virginia | 51003 | 3958 | 35 |
988271 | 988271 | 2021-02-01 | Albemarle | Virginia | 51003 | 3946 | 35 |
985024 | 985024 | 2021-01-31 | Albemarle | Virginia | 51003 | 3924 | 35 |
981777 | 981777 | 2021-01-30 | Albemarle | Virginia | 51003 | 3901 | 35 |
978531 | 978531 | 2021-01-29 | Albemarle | Virginia | 51003 | 3887 | 35 |
975286 | 975286 | 2021-01-28 | Albemarle | Virginia | 51003 | 3859 | 35 |
972041 | 972041 | 2021-01-27 | Albemarle | Virginia | 51003 | 3789 | 35 |
968796 | 968796 | 2021-01-26 | Albemarle | Virginia | 51003 | 3757 | 35 |
965552 | 965552 | 2021-01-25 | Albemarle | Virginia | 51003 | 3746 | 35 |
962307 | 962307 | 2021-01-24 | Albemarle | Virginia | 51003 | 3711 | 35 |
959062 | 959062 | 2021-01-23 | Albemarle | Virginia | 51003 | 3689 | 35 |
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);