ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 51085 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 179 ✖
- 0 40
- 35 21
- 168 18
- 25 17
- 30 16
- 201 16
- 166 15
- 169 15
- 208 15
- 24 13
- 31 13
- 19 12
- 167 12
- 209 12
- 33 11
- 40 11
- 147 11
- 148 11
- 171 10
- 196 10
- 199 10
- 202 10
- 150 9
- 186 9
- 280 9
- 104 8
- 155 8
- 161 8
- 277 8
- 284 8
- 32 7
- 44 7
- 54 7
- 158 7
- 164 7
- 165 7
- 274 7
- 34 6
- 36 6
- 39 6
- 42 6
- 48 6
- 83 6
- 154 6
- 188 6
- 283 6
- 285 6
- 7 5
- 69 5
- 144 5
- 193 5
- 279 5
- 26 4
- 29 4
- 37 4
- 46 4
- 51 4
- 56 4
- 79 4
- 101 4
- 105 4
- 145 4
- 152 4
- 170 4
- 175 4
- 178 4
- 181 4
- 185 4
- 191 4
- 195 4
- 198 4
- 205 4
- 207 4
- 212 4
- 254 4
- 260 4
- 275 4
- 9 3
- 12 3
- 16 3
- 38 3
- 45 3
- 47 3
- 60 3
- 65 3
- 77 3
- 78 3
- 95 3
- 103 3
- 138 3
- 149 3
- 162 3
- 176 3
- 182 3
- 211 3
- 222 3
- 244 3
- 255 3
- 256 3
- 259 3
- 267 3
- 6 2
- 13 2
- 15 2
- 17 2
- 27 2
- 41 2
- 58 2
- 59 2
- 61 2
- 64 2
- 67 2
- 71 2
- 102 2
- 137 2
- 143 2
- 146 2
- 173 2
- 179 2
- 192 2
- 215 2
- 266 2
- 269 2
- 286 2
- 11 1
- 18 1
- 22 1
- 43 1
- 49 1
- 52 1
- 53 1
- 72 1
- 74 1
- 80 1
- 82 1
- 88 1
- 91 1
- 93 1
- 96 1
- 97 1
- 98 1
- 100 1
- 107 1
- 110 1
- 114 1
- 116 1
- 118 1
- 119 1
- 121 1
- 123 1
- 125 1
- 128 1
- 134 1
- 140 1
- 156 1
- 157 1
- 160 1
- 174 1
- 180 1
- 189 1
- 190 1
- 197 1
- 200 1
- 216 1
- 218 1
- 235 1
- 237 1
- 238 1
- 239 1
- 249 1
- 251 1
- 252 1
- 253 1
- 263 1
- 265 1
- 272 1
- 273 1
- 276 1
- 281 1
state 1
- Virginia 793
fips 1
- 51085 · 793 ✖
county 1
- Hanover 793
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502566 | 2502566 | 2022-05-13 | Hanover | Virginia | 51085 | 22386 | 286 |
2499308 | 2499308 | 2022-05-12 | Hanover | Virginia | 51085 | 22343 | 286 |
2496050 | 2496050 | 2022-05-11 | Hanover | Virginia | 51085 | 22319 | 285 |
2492792 | 2492792 | 2022-05-10 | Hanover | Virginia | 51085 | 22273 | 285 |
2489534 | 2489534 | 2022-05-09 | Hanover | Virginia | 51085 | 22228 | 285 |
2486277 | 2486277 | 2022-05-08 | Hanover | Virginia | 51085 | 22160 | 285 |
2483019 | 2483019 | 2022-05-07 | Hanover | Virginia | 51085 | 22160 | 285 |
2479761 | 2479761 | 2022-05-06 | Hanover | Virginia | 51085 | 22160 | 285 |
2476503 | 2476503 | 2022-05-05 | Hanover | Virginia | 51085 | 22129 | 284 |
2473245 | 2473245 | 2022-05-04 | Hanover | Virginia | 51085 | 22101 | 284 |
2469989 | 2469989 | 2022-05-03 | Hanover | Virginia | 51085 | 22055 | 284 |
2466733 | 2466733 | 2022-05-02 | Hanover | Virginia | 51085 | 22012 | 284 |
2463478 | 2463478 | 2022-05-01 | Hanover | Virginia | 51085 | 21983 | 284 |
2460222 | 2460222 | 2022-04-30 | Hanover | Virginia | 51085 | 21983 | 284 |
2456966 | 2456966 | 2022-04-29 | Hanover | Virginia | 51085 | 21983 | 284 |
2453710 | 2453710 | 2022-04-28 | Hanover | Virginia | 51085 | 21960 | 284 |
2450454 | 2450454 | 2022-04-27 | Hanover | Virginia | 51085 | 21940 | 283 |
2447197 | 2447197 | 2022-04-26 | Hanover | Virginia | 51085 | 21922 | 283 |
2443942 | 2443942 | 2022-04-25 | Hanover | Virginia | 51085 | 21909 | 283 |
2440686 | 2440686 | 2022-04-24 | Hanover | Virginia | 51085 | 21861 | 283 |
2437430 | 2437430 | 2022-04-23 | Hanover | Virginia | 51085 | 21861 | 283 |
2434174 | 2434174 | 2022-04-22 | Hanover | Virginia | 51085 | 21861 | 283 |
2430918 | 2430918 | 2022-04-21 | Hanover | Virginia | 51085 | 21848 | 281 |
2427662 | 2427662 | 2022-04-20 | Hanover | Virginia | 51085 | 21834 | 280 |
2424406 | 2424406 | 2022-04-19 | Hanover | Virginia | 51085 | 21818 | 280 |
2421150 | 2421150 | 2022-04-18 | Hanover | Virginia | 51085 | 21819 | 280 |
2417894 | 2417894 | 2022-04-17 | Hanover | Virginia | 51085 | 21791 | 280 |
2414638 | 2414638 | 2022-04-16 | Hanover | Virginia | 51085 | 21791 | 280 |
2411382 | 2411382 | 2022-04-15 | Hanover | Virginia | 51085 | 21791 | 280 |
2408126 | 2408126 | 2022-04-14 | Hanover | Virginia | 51085 | 21755 | 280 |
2404870 | 2404870 | 2022-04-13 | Hanover | Virginia | 51085 | 21740 | 280 |
2401615 | 2401615 | 2022-04-12 | Hanover | Virginia | 51085 | 21727 | 280 |
2398360 | 2398360 | 2022-04-11 | Hanover | Virginia | 51085 | 21720 | 279 |
2395105 | 2395105 | 2022-04-10 | Hanover | Virginia | 51085 | 21702 | 279 |
2391849 | 2391849 | 2022-04-09 | Hanover | Virginia | 51085 | 21702 | 279 |
2388593 | 2388593 | 2022-04-08 | Hanover | Virginia | 51085 | 21702 | 279 |
2385338 | 2385338 | 2022-04-07 | Hanover | Virginia | 51085 | 21702 | 279 |
2382083 | 2382083 | 2022-04-06 | Hanover | Virginia | 51085 | 21697 | 277 |
2378828 | 2378828 | 2022-04-05 | Hanover | Virginia | 51085 | 21687 | 277 |
2375574 | 2375574 | 2022-04-04 | Hanover | Virginia | 51085 | 21688 | 277 |
2372322 | 2372322 | 2022-04-03 | Hanover | Virginia | 51085 | 21665 | 277 |
2369069 | 2369069 | 2022-04-02 | Hanover | Virginia | 51085 | 21665 | 277 |
2365816 | 2365816 | 2022-04-01 | Hanover | Virginia | 51085 | 21665 | 277 |
2362563 | 2362563 | 2022-03-31 | Hanover | Virginia | 51085 | 21653 | 277 |
2359309 | 2359309 | 2022-03-30 | Hanover | Virginia | 51085 | 21649 | 277 |
2356055 | 2356055 | 2022-03-29 | Hanover | Virginia | 51085 | 21639 | 276 |
2352802 | 2352802 | 2022-03-28 | Hanover | Virginia | 51085 | 21629 | 275 |
2349550 | 2349550 | 2022-03-27 | Hanover | Virginia | 51085 | 21620 | 275 |
2346297 | 2346297 | 2022-03-26 | Hanover | Virginia | 51085 | 21620 | 275 |
2343044 | 2343044 | 2022-03-25 | Hanover | Virginia | 51085 | 21620 | 275 |
2339791 | 2339791 | 2022-03-24 | Hanover | Virginia | 51085 | 21605 | 274 |
2336537 | 2336537 | 2022-03-23 | Hanover | Virginia | 51085 | 21606 | 274 |
2333283 | 2333283 | 2022-03-22 | Hanover | Virginia | 51085 | 21592 | 274 |
2330030 | 2330030 | 2022-03-21 | Hanover | Virginia | 51085 | 21592 | 274 |
2326778 | 2326778 | 2022-03-20 | Hanover | Virginia | 51085 | 21581 | 274 |
2323525 | 2323525 | 2022-03-19 | Hanover | Virginia | 51085 | 21581 | 274 |
2320271 | 2320271 | 2022-03-18 | Hanover | Virginia | 51085 | 21581 | 274 |
2317017 | 2317017 | 2022-03-17 | Hanover | Virginia | 51085 | 21557 | 273 |
2313764 | 2313764 | 2022-03-16 | Hanover | Virginia | 51085 | 21533 | 272 |
2310511 | 2310511 | 2022-03-15 | Hanover | Virginia | 51085 | 21520 | 269 |
2307258 | 2307258 | 2022-03-14 | Hanover | Virginia | 51085 | 21508 | 269 |
2304007 | 2304007 | 2022-03-13 | Hanover | Virginia | 51085 | 21505 | 267 |
2300755 | 2300755 | 2022-03-12 | Hanover | Virginia | 51085 | 21505 | 267 |
2297503 | 2297503 | 2022-03-11 | Hanover | Virginia | 51085 | 21505 | 267 |
2294251 | 2294251 | 2022-03-10 | Hanover | Virginia | 51085 | 21497 | 266 |
2290999 | 2290999 | 2022-03-09 | Hanover | Virginia | 51085 | 21478 | 266 |
2287747 | 2287747 | 2022-03-08 | Hanover | Virginia | 51085 | 21461 | 265 |
2284495 | 2284495 | 2022-03-07 | Hanover | Virginia | 51085 | 21451 | 263 |
2281243 | 2281243 | 2022-03-06 | Hanover | Virginia | 51085 | 21407 | 260 |
2277990 | 2277990 | 2022-03-05 | Hanover | Virginia | 51085 | 21407 | 260 |
2274737 | 2274737 | 2022-03-04 | Hanover | Virginia | 51085 | 21407 | 260 |
2271484 | 2271484 | 2022-03-03 | Hanover | Virginia | 51085 | 21387 | 260 |
2268232 | 2268232 | 2022-03-02 | Hanover | Virginia | 51085 | 21366 | 259 |
2264979 | 2264979 | 2022-03-01 | Hanover | Virginia | 51085 | 21340 | 259 |
2261729 | 2261729 | 2022-02-28 | Hanover | Virginia | 51085 | 21310 | 259 |
2258478 | 2258478 | 2022-02-27 | Hanover | Virginia | 51085 | 21173 | 256 |
2255227 | 2255227 | 2022-02-26 | Hanover | Virginia | 51085 | 21173 | 256 |
2251976 | 2251976 | 2022-02-25 | Hanover | Virginia | 51085 | 21173 | 256 |
2248725 | 2248725 | 2022-02-24 | Hanover | Virginia | 51085 | 21154 | 255 |
2245474 | 2245474 | 2022-02-23 | Hanover | Virginia | 51085 | 21118 | 255 |
2242223 | 2242223 | 2022-02-22 | Hanover | Virginia | 51085 | 21095 | 255 |
2238972 | 2238972 | 2022-02-21 | Hanover | Virginia | 51085 | 21053 | 254 |
2235721 | 2235721 | 2022-02-20 | Hanover | Virginia | 51085 | 20983 | 254 |
2232470 | 2232470 | 2022-02-19 | Hanover | Virginia | 51085 | 20983 | 254 |
2229219 | 2229219 | 2022-02-18 | Hanover | Virginia | 51085 | 20983 | 254 |
2225968 | 2225968 | 2022-02-17 | Hanover | Virginia | 51085 | 20970 | 253 |
2222717 | 2222717 | 2022-02-16 | Hanover | Virginia | 51085 | 20932 | 252 |
2219466 | 2219466 | 2022-02-15 | Hanover | Virginia | 51085 | 20909 | 251 |
2216216 | 2216216 | 2022-02-14 | Hanover | Virginia | 51085 | 20865 | 249 |
2212965 | 2212965 | 2022-02-13 | Hanover | Virginia | 51085 | 20736 | 244 |
2209712 | 2209712 | 2022-02-12 | Hanover | Virginia | 51085 | 20736 | 244 |
2206459 | 2206459 | 2022-02-11 | Hanover | Virginia | 51085 | 20736 | 244 |
2203206 | 2203206 | 2022-02-10 | Hanover | Virginia | 51085 | 20667 | 239 |
2199952 | 2199952 | 2022-02-09 | Hanover | Virginia | 51085 | 20610 | 238 |
2196698 | 2196698 | 2022-02-08 | Hanover | Virginia | 51085 | 20537 | 237 |
2193443 | 2193443 | 2022-02-07 | Hanover | Virginia | 51085 | 20484 | 235 |
2190190 | 2190190 | 2022-02-06 | Hanover | Virginia | 51085 | 20274 | 222 |
2186937 | 2186937 | 2022-02-05 | Hanover | Virginia | 51085 | 20274 | 222 |
2183684 | 2183684 | 2022-02-04 | Hanover | Virginia | 51085 | 20274 | 222 |
2180432 | 2180432 | 2022-02-03 | Hanover | Virginia | 51085 | 20193 | 218 |
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);