ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Amherst" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502515 | 2502515 | 2022-05-13 | Amherst | Virginia | 51009 | 7316 | 89 |
2499257 | 2499257 | 2022-05-12 | Amherst | Virginia | 51009 | 7309 | 89 |
2495999 | 2495999 | 2022-05-11 | Amherst | Virginia | 51009 | 7306 | 89 |
2492741 | 2492741 | 2022-05-10 | Amherst | Virginia | 51009 | 7300 | 89 |
2489483 | 2489483 | 2022-05-09 | Amherst | Virginia | 51009 | 7300 | 88 |
2486226 | 2486226 | 2022-05-08 | Amherst | Virginia | 51009 | 7292 | 88 |
2482968 | 2482968 | 2022-05-07 | Amherst | Virginia | 51009 | 7292 | 88 |
2479710 | 2479710 | 2022-05-06 | Amherst | Virginia | 51009 | 7292 | 88 |
2476452 | 2476452 | 2022-05-05 | Amherst | Virginia | 51009 | 7283 | 88 |
2473194 | 2473194 | 2022-05-04 | Amherst | Virginia | 51009 | 7280 | 88 |
2469938 | 2469938 | 2022-05-03 | Amherst | Virginia | 51009 | 7273 | 88 |
2466682 | 2466682 | 2022-05-02 | Amherst | Virginia | 51009 | 7272 | 88 |
2463427 | 2463427 | 2022-05-01 | Amherst | Virginia | 51009 | 7264 | 88 |
2460171 | 2460171 | 2022-04-30 | Amherst | Virginia | 51009 | 7264 | 88 |
2456915 | 2456915 | 2022-04-29 | Amherst | Virginia | 51009 | 7264 | 88 |
2453659 | 2453659 | 2022-04-28 | Amherst | Virginia | 51009 | 7256 | 88 |
2450403 | 2450403 | 2022-04-27 | Amherst | Virginia | 51009 | 7250 | 88 |
2447146 | 2447146 | 2022-04-26 | Amherst | Virginia | 51009 | 7248 | 88 |
2443891 | 2443891 | 2022-04-25 | Amherst | Virginia | 51009 | 7241 | 88 |
2440635 | 2440635 | 2022-04-24 | Amherst | Virginia | 51009 | 7237 | 88 |
2437379 | 2437379 | 2022-04-23 | Amherst | Virginia | 51009 | 7237 | 88 |
2434123 | 2434123 | 2022-04-22 | Amherst | Virginia | 51009 | 7237 | 88 |
2430867 | 2430867 | 2022-04-21 | Amherst | Virginia | 51009 | 7229 | 88 |
2427611 | 2427611 | 2022-04-20 | Amherst | Virginia | 51009 | 7227 | 88 |
2424355 | 2424355 | 2022-04-19 | Amherst | Virginia | 51009 | 7222 | 88 |
2421099 | 2421099 | 2022-04-18 | Amherst | Virginia | 51009 | 7221 | 88 |
2417843 | 2417843 | 2022-04-17 | Amherst | Virginia | 51009 | 7216 | 88 |
2414587 | 2414587 | 2022-04-16 | Amherst | Virginia | 51009 | 7216 | 88 |
2411331 | 2411331 | 2022-04-15 | Amherst | Virginia | 51009 | 7216 | 88 |
2408075 | 2408075 | 2022-04-14 | Amherst | Virginia | 51009 | 7213 | 88 |
2404819 | 2404819 | 2022-04-13 | Amherst | Virginia | 51009 | 7208 | 88 |
2401564 | 2401564 | 2022-04-12 | Amherst | Virginia | 51009 | 7205 | 88 |
2398309 | 2398309 | 2022-04-11 | Amherst | Virginia | 51009 | 7201 | 88 |
2395054 | 2395054 | 2022-04-10 | Amherst | Virginia | 51009 | 7198 | 87 |
2391798 | 2391798 | 2022-04-09 | Amherst | Virginia | 51009 | 7198 | 87 |
2388542 | 2388542 | 2022-04-08 | Amherst | Virginia | 51009 | 7198 | 87 |
2385287 | 2385287 | 2022-04-07 | Amherst | Virginia | 51009 | 7201 | 86 |
2382032 | 2382032 | 2022-04-06 | Amherst | Virginia | 51009 | 7199 | 86 |
2378777 | 2378777 | 2022-04-05 | Amherst | Virginia | 51009 | 7198 | 86 |
2375523 | 2375523 | 2022-04-04 | Amherst | Virginia | 51009 | 7198 | 86 |
2372271 | 2372271 | 2022-04-03 | Amherst | Virginia | 51009 | 7193 | 86 |
2369018 | 2369018 | 2022-04-02 | Amherst | Virginia | 51009 | 7193 | 86 |
2365765 | 2365765 | 2022-04-01 | Amherst | Virginia | 51009 | 7193 | 86 |
2362512 | 2362512 | 2022-03-31 | Amherst | Virginia | 51009 | 7191 | 86 |
2359258 | 2359258 | 2022-03-30 | Amherst | Virginia | 51009 | 7189 | 86 |
2356004 | 2356004 | 2022-03-29 | Amherst | Virginia | 51009 | 7183 | 85 |
2352751 | 2352751 | 2022-03-28 | Amherst | Virginia | 51009 | 7182 | 85 |
2349499 | 2349499 | 2022-03-27 | Amherst | Virginia | 51009 | 7179 | 84 |
2346246 | 2346246 | 2022-03-26 | Amherst | Virginia | 51009 | 7179 | 84 |
2342993 | 2342993 | 2022-03-25 | Amherst | Virginia | 51009 | 7179 | 84 |
2339740 | 2339740 | 2022-03-24 | Amherst | Virginia | 51009 | 7176 | 84 |
2336486 | 2336486 | 2022-03-23 | Amherst | Virginia | 51009 | 7176 | 84 |
2333232 | 2333232 | 2022-03-22 | Amherst | Virginia | 51009 | 7170 | 84 |
2329979 | 2329979 | 2022-03-21 | Amherst | Virginia | 51009 | 7170 | 84 |
2326727 | 2326727 | 2022-03-20 | Amherst | Virginia | 51009 | 7166 | 84 |
2323474 | 2323474 | 2022-03-19 | Amherst | Virginia | 51009 | 7166 | 84 |
2320220 | 2320220 | 2022-03-18 | Amherst | Virginia | 51009 | 7166 | 84 |
2316966 | 2316966 | 2022-03-17 | Amherst | Virginia | 51009 | 7147 | 84 |
2313713 | 2313713 | 2022-03-16 | Amherst | Virginia | 51009 | 7128 | 84 |
2310460 | 2310460 | 2022-03-15 | Amherst | Virginia | 51009 | 7096 | 84 |
2307207 | 2307207 | 2022-03-14 | Amherst | Virginia | 51009 | 7073 | 84 |
2303956 | 2303956 | 2022-03-13 | Amherst | Virginia | 51009 | 7052 | 84 |
2300704 | 2300704 | 2022-03-12 | Amherst | Virginia | 51009 | 7052 | 84 |
2297452 | 2297452 | 2022-03-11 | Amherst | Virginia | 51009 | 7052 | 84 |
2294200 | 2294200 | 2022-03-10 | Amherst | Virginia | 51009 | 7041 | 84 |
2290948 | 2290948 | 2022-03-09 | Amherst | Virginia | 51009 | 7036 | 83 |
2287696 | 2287696 | 2022-03-08 | Amherst | Virginia | 51009 | 7023 | 83 |
2284444 | 2284444 | 2022-03-07 | Amherst | Virginia | 51009 | 7014 | 83 |
2281192 | 2281192 | 2022-03-06 | Amherst | Virginia | 51009 | 6991 | 83 |
2277939 | 2277939 | 2022-03-05 | Amherst | Virginia | 51009 | 6991 | 83 |
2274686 | 2274686 | 2022-03-04 | Amherst | Virginia | 51009 | 6991 | 83 |
2271433 | 2271433 | 2022-03-03 | Amherst | Virginia | 51009 | 6973 | 83 |
2268181 | 2268181 | 2022-03-02 | Amherst | Virginia | 51009 | 6952 | 83 |
2264928 | 2264928 | 2022-03-01 | Amherst | Virginia | 51009 | 6929 | 83 |
2261678 | 2261678 | 2022-02-28 | Amherst | Virginia | 51009 | 6917 | 83 |
2258427 | 2258427 | 2022-02-27 | Amherst | Virginia | 51009 | 6887 | 83 |
2255176 | 2255176 | 2022-02-26 | Amherst | Virginia | 51009 | 6887 | 83 |
2251925 | 2251925 | 2022-02-25 | Amherst | Virginia | 51009 | 6887 | 83 |
2248674 | 2248674 | 2022-02-24 | Amherst | Virginia | 51009 | 6869 | 82 |
2245423 | 2245423 | 2022-02-23 | Amherst | Virginia | 51009 | 6840 | 82 |
2242172 | 2242172 | 2022-02-22 | Amherst | Virginia | 51009 | 6827 | 80 |
2238921 | 2238921 | 2022-02-21 | Amherst | Virginia | 51009 | 6796 | 80 |
2235670 | 2235670 | 2022-02-20 | Amherst | Virginia | 51009 | 6753 | 79 |
2232419 | 2232419 | 2022-02-19 | Amherst | Virginia | 51009 | 6753 | 79 |
2229168 | 2229168 | 2022-02-18 | Amherst | Virginia | 51009 | 6753 | 79 |
2225917 | 2225917 | 2022-02-17 | Amherst | Virginia | 51009 | 6721 | 79 |
2222666 | 2222666 | 2022-02-16 | Amherst | Virginia | 51009 | 6692 | 79 |
2219415 | 2219415 | 2022-02-15 | Amherst | Virginia | 51009 | 6654 | 79 |
2216165 | 2216165 | 2022-02-14 | Amherst | Virginia | 51009 | 6632 | 77 |
2212914 | 2212914 | 2022-02-13 | Amherst | Virginia | 51009 | 6586 | 76 |
2209661 | 2209661 | 2022-02-12 | Amherst | Virginia | 51009 | 6586 | 76 |
2206408 | 2206408 | 2022-02-11 | Amherst | Virginia | 51009 | 6586 | 76 |
2203155 | 2203155 | 2022-02-10 | Amherst | Virginia | 51009 | 6552 | 76 |
2199901 | 2199901 | 2022-02-09 | Amherst | Virginia | 51009 | 6520 | 76 |
2196647 | 2196647 | 2022-02-08 | Amherst | Virginia | 51009 | 6476 | 76 |
2193392 | 2193392 | 2022-02-07 | Amherst | Virginia | 51009 | 6448 | 75 |
2190139 | 2190139 | 2022-02-06 | Amherst | Virginia | 51009 | 6385 | 74 |
2186886 | 2186886 | 2022-02-05 | Amherst | Virginia | 51009 | 6385 | 74 |
2183633 | 2183633 | 2022-02-04 | Amherst | Virginia | 51009 | 6385 | 74 |
2180381 | 2180381 | 2022-02-03 | Amherst | Virginia | 51009 | 6331 | 71 |
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);