ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Petersburg city" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502603 | 2502603 | 2022-05-13 | Petersburg city | Virginia | 51730 | 8297 | 140 |
2499345 | 2499345 | 2022-05-12 | Petersburg city | Virginia | 51730 | 8300 | 140 |
2496087 | 2496087 | 2022-05-11 | Petersburg city | Virginia | 51730 | 8301 | 140 |
2492829 | 2492829 | 2022-05-10 | Petersburg city | Virginia | 51730 | 8299 | 140 |
2489571 | 2489571 | 2022-05-09 | Petersburg city | Virginia | 51730 | 8291 | 140 |
2486314 | 2486314 | 2022-05-08 | Petersburg city | Virginia | 51730 | 8278 | 140 |
2483056 | 2483056 | 2022-05-07 | Petersburg city | Virginia | 51730 | 8278 | 140 |
2479798 | 2479798 | 2022-05-06 | Petersburg city | Virginia | 51730 | 8278 | 140 |
2476540 | 2476540 | 2022-05-05 | Petersburg city | Virginia | 51730 | 8279 | 140 |
2473282 | 2473282 | 2022-05-04 | Petersburg city | Virginia | 51730 | 8273 | 140 |
2470026 | 2470026 | 2022-05-03 | Petersburg city | Virginia | 51730 | 8274 | 140 |
2466770 | 2466770 | 2022-05-02 | Petersburg city | Virginia | 51730 | 8278 | 140 |
2463515 | 2463515 | 2022-05-01 | Petersburg city | Virginia | 51730 | 8269 | 139 |
2460259 | 2460259 | 2022-04-30 | Petersburg city | Virginia | 51730 | 8269 | 139 |
2457003 | 2457003 | 2022-04-29 | Petersburg city | Virginia | 51730 | 8269 | 139 |
2453747 | 2453747 | 2022-04-28 | Petersburg city | Virginia | 51730 | 8266 | 139 |
2450491 | 2450491 | 2022-04-27 | Petersburg city | Virginia | 51730 | 8263 | 139 |
2447234 | 2447234 | 2022-04-26 | Petersburg city | Virginia | 51730 | 8269 | 139 |
2443979 | 2443979 | 2022-04-25 | Petersburg city | Virginia | 51730 | 8270 | 139 |
2440723 | 2440723 | 2022-04-24 | Petersburg city | Virginia | 51730 | 8271 | 139 |
2437467 | 2437467 | 2022-04-23 | Petersburg city | Virginia | 51730 | 8271 | 139 |
2434211 | 2434211 | 2022-04-22 | Petersburg city | Virginia | 51730 | 8271 | 139 |
2430955 | 2430955 | 2022-04-21 | Petersburg city | Virginia | 51730 | 8270 | 139 |
2427699 | 2427699 | 2022-04-20 | Petersburg city | Virginia | 51730 | 8270 | 139 |
2424443 | 2424443 | 2022-04-19 | Petersburg city | Virginia | 51730 | 8269 | 139 |
2421187 | 2421187 | 2022-04-18 | Petersburg city | Virginia | 51730 | 8272 | 138 |
2417931 | 2417931 | 2022-04-17 | Petersburg city | Virginia | 51730 | 8281 | 138 |
2414675 | 2414675 | 2022-04-16 | Petersburg city | Virginia | 51730 | 8281 | 138 |
2411419 | 2411419 | 2022-04-15 | Petersburg city | Virginia | 51730 | 8281 | 138 |
2408163 | 2408163 | 2022-04-14 | Petersburg city | Virginia | 51730 | 8291 | 138 |
2404907 | 2404907 | 2022-04-13 | Petersburg city | Virginia | 51730 | 8287 | 138 |
2401652 | 2401652 | 2022-04-12 | Petersburg city | Virginia | 51730 | 8293 | 137 |
2398397 | 2398397 | 2022-04-11 | Petersburg city | Virginia | 51730 | 8290 | 137 |
2395142 | 2395142 | 2022-04-10 | Petersburg city | Virginia | 51730 | 8283 | 137 |
2391886 | 2391886 | 2022-04-09 | Petersburg city | Virginia | 51730 | 8283 | 137 |
2388630 | 2388630 | 2022-04-08 | Petersburg city | Virginia | 51730 | 8283 | 137 |
2385375 | 2385375 | 2022-04-07 | Petersburg city | Virginia | 51730 | 8282 | 137 |
2382120 | 2382120 | 2022-04-06 | Petersburg city | Virginia | 51730 | 8286 | 137 |
2378865 | 2378865 | 2022-04-05 | Petersburg city | Virginia | 51730 | 8295 | 137 |
2375611 | 2375611 | 2022-04-04 | Petersburg city | Virginia | 51730 | 8295 | 137 |
2372359 | 2372359 | 2022-04-03 | Petersburg city | Virginia | 51730 | 8292 | 137 |
2369106 | 2369106 | 2022-04-02 | Petersburg city | Virginia | 51730 | 8292 | 137 |
2365853 | 2365853 | 2022-04-01 | Petersburg city | Virginia | 51730 | 8292 | 137 |
2362600 | 2362600 | 2022-03-31 | Petersburg city | Virginia | 51730 | 8293 | 137 |
2359346 | 2359346 | 2022-03-30 | Petersburg city | Virginia | 51730 | 8292 | 137 |
2356092 | 2356092 | 2022-03-29 | Petersburg city | Virginia | 51730 | 8284 | 137 |
2352839 | 2352839 | 2022-03-28 | Petersburg city | Virginia | 51730 | 8284 | 136 |
2349587 | 2349587 | 2022-03-27 | Petersburg city | Virginia | 51730 | 8275 | 136 |
2346334 | 2346334 | 2022-03-26 | Petersburg city | Virginia | 51730 | 8275 | 136 |
2343081 | 2343081 | 2022-03-25 | Petersburg city | Virginia | 51730 | 8275 | 136 |
2339828 | 2339828 | 2022-03-24 | Petersburg city | Virginia | 51730 | 8278 | 136 |
2336574 | 2336574 | 2022-03-23 | Petersburg city | Virginia | 51730 | 8283 | 137 |
2333320 | 2333320 | 2022-03-22 | Petersburg city | Virginia | 51730 | 8273 | 138 |
2330067 | 2330067 | 2022-03-21 | Petersburg city | Virginia | 51730 | 8273 | 138 |
2326815 | 2326815 | 2022-03-20 | Petersburg city | Virginia | 51730 | 8275 | 138 |
2323562 | 2323562 | 2022-03-19 | Petersburg city | Virginia | 51730 | 8275 | 138 |
2320308 | 2320308 | 2022-03-18 | Petersburg city | Virginia | 51730 | 8275 | 138 |
2317054 | 2317054 | 2022-03-17 | Petersburg city | Virginia | 51730 | 8275 | 139 |
2313801 | 2313801 | 2022-03-16 | Petersburg city | Virginia | 51730 | 8275 | 139 |
2310548 | 2310548 | 2022-03-15 | Petersburg city | Virginia | 51730 | 8279 | 139 |
2307295 | 2307295 | 2022-03-14 | Petersburg city | Virginia | 51730 | 8279 | 140 |
2304044 | 2304044 | 2022-03-13 | Petersburg city | Virginia | 51730 | 8282 | 138 |
2300792 | 2300792 | 2022-03-12 | Petersburg city | Virginia | 51730 | 8282 | 138 |
2297540 | 2297540 | 2022-03-11 | Petersburg city | Virginia | 51730 | 8282 | 138 |
2294288 | 2294288 | 2022-03-10 | Petersburg city | Virginia | 51730 | 8293 | 138 |
2291036 | 2291036 | 2022-03-09 | Petersburg city | Virginia | 51730 | 8299 | 137 |
2287784 | 2287784 | 2022-03-08 | Petersburg city | Virginia | 51730 | 8299 | 137 |
2284532 | 2284532 | 2022-03-07 | Petersburg city | Virginia | 51730 | 8301 | 137 |
2281280 | 2281280 | 2022-03-06 | Petersburg city | Virginia | 51730 | 8302 | 135 |
2278027 | 2278027 | 2022-03-05 | Petersburg city | Virginia | 51730 | 8302 | 135 |
2274774 | 2274774 | 2022-03-04 | Petersburg city | Virginia | 51730 | 8302 | 135 |
2271521 | 2271521 | 2022-03-03 | Petersburg city | Virginia | 51730 | 8301 | 135 |
2268269 | 2268269 | 2022-03-02 | Petersburg city | Virginia | 51730 | 8278 | 134 |
2265016 | 2265016 | 2022-03-01 | Petersburg city | Virginia | 51730 | 8272 | 134 |
2261766 | 2261766 | 2022-02-28 | Petersburg city | Virginia | 51730 | 8268 | 133 |
2258515 | 2258515 | 2022-02-27 | Petersburg city | Virginia | 51730 | 8252 | 131 |
2255264 | 2255264 | 2022-02-26 | Petersburg city | Virginia | 51730 | 8252 | 131 |
2252013 | 2252013 | 2022-02-25 | Petersburg city | Virginia | 51730 | 8252 | 131 |
2248762 | 2248762 | 2022-02-24 | Petersburg city | Virginia | 51730 | 8257 | 131 |
2245511 | 2245511 | 2022-02-23 | Petersburg city | Virginia | 51730 | 8254 | 131 |
2242260 | 2242260 | 2022-02-22 | Petersburg city | Virginia | 51730 | 8241 | 131 |
2239009 | 2239009 | 2022-02-21 | Petersburg city | Virginia | 51730 | 8234 | 129 |
2235758 | 2235758 | 2022-02-20 | Petersburg city | Virginia | 51730 | 8179 | 129 |
2232507 | 2232507 | 2022-02-19 | Petersburg city | Virginia | 51730 | 8179 | 129 |
2229256 | 2229256 | 2022-02-18 | Petersburg city | Virginia | 51730 | 8179 | 129 |
2226005 | 2226005 | 2022-02-17 | Petersburg city | Virginia | 51730 | 8169 | 129 |
2222754 | 2222754 | 2022-02-16 | Petersburg city | Virginia | 51730 | 8155 | 128 |
2219503 | 2219503 | 2022-02-15 | Petersburg city | Virginia | 51730 | 8154 | 128 |
2216253 | 2216253 | 2022-02-14 | Petersburg city | Virginia | 51730 | 8145 | 125 |
2213002 | 2213002 | 2022-02-13 | Petersburg city | Virginia | 51730 | 8109 | 125 |
2209749 | 2209749 | 2022-02-12 | Petersburg city | Virginia | 51730 | 8109 | 125 |
2206496 | 2206496 | 2022-02-11 | Petersburg city | Virginia | 51730 | 8109 | 125 |
2203243 | 2203243 | 2022-02-10 | Petersburg city | Virginia | 51730 | 8091 | 125 |
2199989 | 2199989 | 2022-02-09 | Petersburg city | Virginia | 51730 | 8079 | 124 |
2196735 | 2196735 | 2022-02-08 | Petersburg city | Virginia | 51730 | 8064 | 123 |
2193480 | 2193480 | 2022-02-07 | Petersburg city | Virginia | 51730 | 8046 | 121 |
2190227 | 2190227 | 2022-02-06 | Petersburg city | Virginia | 51730 | 8001 | 118 |
2186974 | 2186974 | 2022-02-05 | Petersburg city | Virginia | 51730 | 8001 | 118 |
2183721 | 2183721 | 2022-02-04 | Petersburg city | Virginia | 51730 | 8001 | 118 |
2180469 | 2180469 | 2022-02-03 | Petersburg city | Virginia | 51730 | 7997 | 118 |
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);