ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where fips = 51775 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502621 | 2502621 | 2022-05-13 | Salem city | Virginia | 51775 | 5745 | 97 |
2499363 | 2499363 | 2022-05-12 | Salem city | Virginia | 51775 | 5746 | 97 |
2496105 | 2496105 | 2022-05-11 | Salem city | Virginia | 51775 | 5745 | 97 |
2492847 | 2492847 | 2022-05-10 | Salem city | Virginia | 51775 | 5738 | 97 |
2489589 | 2489589 | 2022-05-09 | Salem city | Virginia | 51775 | 5737 | 97 |
2486332 | 2486332 | 2022-05-08 | Salem city | Virginia | 51775 | 5725 | 97 |
2483074 | 2483074 | 2022-05-07 | Salem city | Virginia | 51775 | 5725 | 97 |
2479816 | 2479816 | 2022-05-06 | Salem city | Virginia | 51775 | 5725 | 97 |
2476558 | 2476558 | 2022-05-05 | Salem city | Virginia | 51775 | 5712 | 97 |
2473300 | 2473300 | 2022-05-04 | Salem city | Virginia | 51775 | 5709 | 97 |
2470044 | 2470044 | 2022-05-03 | Salem city | Virginia | 51775 | 5708 | 97 |
2466788 | 2466788 | 2022-05-02 | Salem city | Virginia | 51775 | 5713 | 96 |
2463533 | 2463533 | 2022-05-01 | Salem city | Virginia | 51775 | 5694 | 96 |
2460277 | 2460277 | 2022-04-30 | Salem city | Virginia | 51775 | 5694 | 96 |
2457021 | 2457021 | 2022-04-29 | Salem city | Virginia | 51775 | 5694 | 96 |
2453765 | 2453765 | 2022-04-28 | Salem city | Virginia | 51775 | 5688 | 96 |
2450509 | 2450509 | 2022-04-27 | Salem city | Virginia | 51775 | 5686 | 96 |
2447252 | 2447252 | 2022-04-26 | Salem city | Virginia | 51775 | 5682 | 96 |
2443997 | 2443997 | 2022-04-25 | Salem city | Virginia | 51775 | 5684 | 96 |
2440741 | 2440741 | 2022-04-24 | Salem city | Virginia | 51775 | 5673 | 96 |
2437485 | 2437485 | 2022-04-23 | Salem city | Virginia | 51775 | 5673 | 96 |
2434229 | 2434229 | 2022-04-22 | Salem city | Virginia | 51775 | 5673 | 96 |
2430973 | 2430973 | 2022-04-21 | Salem city | Virginia | 51775 | 5671 | 96 |
2427717 | 2427717 | 2022-04-20 | Salem city | Virginia | 51775 | 5669 | 96 |
2424461 | 2424461 | 2022-04-19 | Salem city | Virginia | 51775 | 5669 | 96 |
2421205 | 2421205 | 2022-04-18 | Salem city | Virginia | 51775 | 5669 | 96 |
2417949 | 2417949 | 2022-04-17 | Salem city | Virginia | 51775 | 5657 | 96 |
2414693 | 2414693 | 2022-04-16 | Salem city | Virginia | 51775 | 5657 | 96 |
2411437 | 2411437 | 2022-04-15 | Salem city | Virginia | 51775 | 5657 | 96 |
2408181 | 2408181 | 2022-04-14 | Salem city | Virginia | 51775 | 5652 | 96 |
2404925 | 2404925 | 2022-04-13 | Salem city | Virginia | 51775 | 5648 | 96 |
2401670 | 2401670 | 2022-04-12 | Salem city | Virginia | 51775 | 5646 | 96 |
2398415 | 2398415 | 2022-04-11 | Salem city | Virginia | 51775 | 5646 | 96 |
2395160 | 2395160 | 2022-04-10 | Salem city | Virginia | 51775 | 5645 | 96 |
2391904 | 2391904 | 2022-04-09 | Salem city | Virginia | 51775 | 5645 | 96 |
2388648 | 2388648 | 2022-04-08 | Salem city | Virginia | 51775 | 5645 | 96 |
2385393 | 2385393 | 2022-04-07 | Salem city | Virginia | 51775 | 5647 | 96 |
2382138 | 2382138 | 2022-04-06 | Salem city | Virginia | 51775 | 5637 | 96 |
2378883 | 2378883 | 2022-04-05 | Salem city | Virginia | 51775 | 5643 | 96 |
2375629 | 2375629 | 2022-04-04 | Salem city | Virginia | 51775 | 5642 | 96 |
2372377 | 2372377 | 2022-04-03 | Salem city | Virginia | 51775 | 5634 | 96 |
2369124 | 2369124 | 2022-04-02 | Salem city | Virginia | 51775 | 5634 | 96 |
2365871 | 2365871 | 2022-04-01 | Salem city | Virginia | 51775 | 5634 | 96 |
2362618 | 2362618 | 2022-03-31 | Salem city | Virginia | 51775 | 5636 | 96 |
2359364 | 2359364 | 2022-03-30 | Salem city | Virginia | 51775 | 5630 | 96 |
2356110 | 2356110 | 2022-03-29 | Salem city | Virginia | 51775 | 5620 | 96 |
2352857 | 2352857 | 2022-03-28 | Salem city | Virginia | 51775 | 5623 | 96 |
2349605 | 2349605 | 2022-03-27 | Salem city | Virginia | 51775 | 5616 | 96 |
2346352 | 2346352 | 2022-03-26 | Salem city | Virginia | 51775 | 5616 | 96 |
2343099 | 2343099 | 2022-03-25 | Salem city | Virginia | 51775 | 5616 | 96 |
2339846 | 2339846 | 2022-03-24 | Salem city | Virginia | 51775 | 5612 | 96 |
2336592 | 2336592 | 2022-03-23 | Salem city | Virginia | 51775 | 5609 | 96 |
2333338 | 2333338 | 2022-03-22 | Salem city | Virginia | 51775 | 5611 | 96 |
2330085 | 2330085 | 2022-03-21 | Salem city | Virginia | 51775 | 5611 | 96 |
2326833 | 2326833 | 2022-03-20 | Salem city | Virginia | 51775 | 5604 | 96 |
2323580 | 2323580 | 2022-03-19 | Salem city | Virginia | 51775 | 5604 | 96 |
2320326 | 2320326 | 2022-03-18 | Salem city | Virginia | 51775 | 5604 | 96 |
2317072 | 2317072 | 2022-03-17 | Salem city | Virginia | 51775 | 5596 | 95 |
2313819 | 2313819 | 2022-03-16 | Salem city | Virginia | 51775 | 5595 | 95 |
2310566 | 2310566 | 2022-03-15 | Salem city | Virginia | 51775 | 5602 | 96 |
2307313 | 2307313 | 2022-03-14 | Salem city | Virginia | 51775 | 5602 | 96 |
2304062 | 2304062 | 2022-03-13 | Salem city | Virginia | 51775 | 5600 | 96 |
2300810 | 2300810 | 2022-03-12 | Salem city | Virginia | 51775 | 5600 | 96 |
2297558 | 2297558 | 2022-03-11 | Salem city | Virginia | 51775 | 5600 | 96 |
2294306 | 2294306 | 2022-03-10 | Salem city | Virginia | 51775 | 5629 | 97 |
2291054 | 2291054 | 2022-03-09 | Salem city | Virginia | 51775 | 5632 | 97 |
2287802 | 2287802 | 2022-03-08 | Salem city | Virginia | 51775 | 5632 | 97 |
2284550 | 2284550 | 2022-03-07 | Salem city | Virginia | 51775 | 5638 | 98 |
2281298 | 2281298 | 2022-03-06 | Salem city | Virginia | 51775 | 5638 | 98 |
2278045 | 2278045 | 2022-03-05 | Salem city | Virginia | 51775 | 5638 | 98 |
2274792 | 2274792 | 2022-03-04 | Salem city | Virginia | 51775 | 5638 | 98 |
2271539 | 2271539 | 2022-03-03 | Salem city | Virginia | 51775 | 5659 | 98 |
2268287 | 2268287 | 2022-03-02 | Salem city | Virginia | 51775 | 6049 | 101 |
2265034 | 2265034 | 2022-03-01 | Salem city | Virginia | 51775 | 6296 | 105 |
2261784 | 2261784 | 2022-02-28 | Salem city | Virginia | 51775 | 6430 | 105 |
2258533 | 2258533 | 2022-02-27 | Salem city | Virginia | 51775 | 6577 | 104 |
2255282 | 2255282 | 2022-02-26 | Salem city | Virginia | 51775 | 6577 | 104 |
2252031 | 2252031 | 2022-02-25 | Salem city | Virginia | 51775 | 6577 | 104 |
2248780 | 2248780 | 2022-02-24 | Salem city | Virginia | 51775 | 6716 | 105 |
2245529 | 2245529 | 2022-02-23 | Salem city | Virginia | 51775 | 6725 | 105 |
2242278 | 2242278 | 2022-02-22 | Salem city | Virginia | 51775 | 6713 | 105 |
2239027 | 2239027 | 2022-02-21 | Salem city | Virginia | 51775 | 6730 | 104 |
2235776 | 2235776 | 2022-02-20 | Salem city | Virginia | 51775 | 6730 | 103 |
2232525 | 2232525 | 2022-02-19 | Salem city | Virginia | 51775 | 6730 | 103 |
2229274 | 2229274 | 2022-02-18 | Salem city | Virginia | 51775 | 6730 | 103 |
2226023 | 2226023 | 2022-02-17 | Salem city | Virginia | 51775 | 6717 | 103 |
2222772 | 2222772 | 2022-02-16 | Salem city | Virginia | 51775 | 6700 | 101 |
2219521 | 2219521 | 2022-02-15 | Salem city | Virginia | 51775 | 6660 | 101 |
2216271 | 2216271 | 2022-02-14 | Salem city | Virginia | 51775 | 6613 | 101 |
2213020 | 2213020 | 2022-02-13 | Salem city | Virginia | 51775 | 6566 | 96 |
2209767 | 2209767 | 2022-02-12 | Salem city | Virginia | 51775 | 6566 | 96 |
2206514 | 2206514 | 2022-02-11 | Salem city | Virginia | 51775 | 6566 | 96 |
2203261 | 2203261 | 2022-02-10 | Salem city | Virginia | 51775 | 6545 | 96 |
2200007 | 2200007 | 2022-02-09 | Salem city | Virginia | 51775 | 6527 | 94 |
2196753 | 2196753 | 2022-02-08 | Salem city | Virginia | 51775 | 6504 | 94 |
2193498 | 2193498 | 2022-02-07 | Salem city | Virginia | 51775 | 6476 | 93 |
2190245 | 2190245 | 2022-02-06 | Salem city | Virginia | 51775 | 6422 | 88 |
2186992 | 2186992 | 2022-02-05 | Salem city | Virginia | 51775 | 6422 | 88 |
2183739 | 2183739 | 2022-02-04 | Salem city | Virginia | 51775 | 6422 | 88 |
2180487 | 2180487 | 2022-02-03 | Salem city | Virginia | 51775 | 6388 | 88 |
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);