ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,552 rows where county = "Hampshire" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2338040 | 2338040 | 2022-03-24 | Hampshire | Massachusetts | 25015 | 27397 | 349 |
2339920 | 2339920 | 2022-03-24 | Hampshire | West Virginia | 54027 | 5811 | 71 |
2334786 | 2334786 | 2022-03-23 | Hampshire | Massachusetts | 25015 | 27353 | 349 |
2336667 | 2336667 | 2022-03-23 | Hampshire | West Virginia | 54027 | 5811 | 70 |
2331532 | 2331532 | 2022-03-22 | Hampshire | Massachusetts | 25015 | 27303 | 349 |
2333413 | 2333413 | 2022-03-22 | Hampshire | West Virginia | 54027 | 5810 | 70 |
2328280 | 2328280 | 2022-03-21 | Hampshire | Massachusetts | 25015 | 27287 | 349 |
2330159 | 2330159 | 2022-03-21 | Hampshire | West Virginia | 54027 | 5806 | 70 |
2325027 | 2325027 | 2022-03-20 | Hampshire | Massachusetts | 25015 | 27229 | 349 |
2326907 | 2326907 | 2022-03-20 | Hampshire | West Virginia | 54027 | 5803 | 70 |
2321773 | 2321773 | 2022-03-19 | Hampshire | Massachusetts | 25015 | 27229 | 349 |
2323654 | 2323654 | 2022-03-19 | Hampshire | West Virginia | 54027 | 5803 | 70 |
2318519 | 2318519 | 2022-03-18 | Hampshire | Massachusetts | 25015 | 27229 | 349 |
2320400 | 2320400 | 2022-03-18 | Hampshire | West Virginia | 54027 | 5803 | 70 |
2315266 | 2315266 | 2022-03-17 | Hampshire | Massachusetts | 25015 | 27215 | 349 |
2317146 | 2317146 | 2022-03-17 | Hampshire | West Virginia | 54027 | 5801 | 70 |
2312013 | 2312013 | 2022-03-16 | Hampshire | Massachusetts | 25015 | 27180 | 349 |
2313893 | 2313893 | 2022-03-16 | Hampshire | West Virginia | 54027 | 5800 | 70 |
2308760 | 2308760 | 2022-03-15 | Hampshire | Massachusetts | 25015 | 27154 | 347 |
2310640 | 2310640 | 2022-03-15 | Hampshire | West Virginia | 54027 | 5799 | 69 |
2305509 | 2305509 | 2022-03-14 | Hampshire | Massachusetts | 25015 | 27144 | 347 |
2307387 | 2307387 | 2022-03-14 | Hampshire | West Virginia | 54027 | 5795 | 69 |
2302257 | 2302257 | 2022-03-13 | Hampshire | Massachusetts | 25015 | 27084 | 413 |
2304136 | 2304136 | 2022-03-13 | Hampshire | West Virginia | 54027 | 5793 | 69 |
2299005 | 2299005 | 2022-03-12 | Hampshire | Massachusetts | 25015 | 27084 | 413 |
2300884 | 2300884 | 2022-03-12 | Hampshire | West Virginia | 54027 | 5793 | 69 |
2295753 | 2295753 | 2022-03-11 | Hampshire | Massachusetts | 25015 | 27084 | 413 |
2297632 | 2297632 | 2022-03-11 | Hampshire | West Virginia | 54027 | 5793 | 69 |
2292501 | 2292501 | 2022-03-10 | Hampshire | Massachusetts | 25015 | 27055 | 413 |
2294380 | 2294380 | 2022-03-10 | Hampshire | West Virginia | 54027 | 5796 | 69 |
2289249 | 2289249 | 2022-03-09 | Hampshire | Massachusetts | 25015 | 27025 | 412 |
2291128 | 2291128 | 2022-03-09 | Hampshire | West Virginia | 54027 | 5788 | 68 |
2285998 | 2285998 | 2022-03-08 | Hampshire | Massachusetts | 25015 | 27003 | 412 |
2287876 | 2287876 | 2022-03-08 | Hampshire | West Virginia | 54027 | 5784 | 68 |
2282746 | 2282746 | 2022-03-07 | Hampshire | Massachusetts | 25015 | 26982 | 411 |
2284624 | 2284624 | 2022-03-07 | Hampshire | West Virginia | 54027 | 5783 | 68 |
2279493 | 2279493 | 2022-03-06 | Hampshire | Massachusetts | 25015 | 26897 | 410 |
2281372 | 2281372 | 2022-03-06 | Hampshire | West Virginia | 54027 | 5780 | 67 |
2276240 | 2276240 | 2022-03-05 | Hampshire | Massachusetts | 25015 | 26897 | 410 |
2278119 | 2278119 | 2022-03-05 | Hampshire | West Virginia | 54027 | 5780 | 67 |
2272987 | 2272987 | 2022-03-04 | Hampshire | Massachusetts | 25015 | 26897 | 410 |
2274866 | 2274866 | 2022-03-04 | Hampshire | West Virginia | 54027 | 5780 | 67 |
2269735 | 2269735 | 2022-03-03 | Hampshire | Massachusetts | 25015 | 26859 | 410 |
2271613 | 2271613 | 2022-03-03 | Hampshire | West Virginia | 54027 | 5772 | 67 |
2266482 | 2266482 | 2022-03-02 | Hampshire | Massachusetts | 25015 | 26810 | 410 |
2268361 | 2268361 | 2022-03-02 | Hampshire | West Virginia | 54027 | 5765 | 67 |
2263231 | 2263231 | 2022-03-01 | Hampshire | Massachusetts | 25015 | 26770 | 410 |
2265108 | 2265108 | 2022-03-01 | Hampshire | West Virginia | 54027 | 5756 | 67 |
2259980 | 2259980 | 2022-02-28 | Hampshire | Massachusetts | 25015 | 26733 | 409 |
2261858 | 2261858 | 2022-02-28 | Hampshire | West Virginia | 54027 | 5753 | 67 |
2256729 | 2256729 | 2022-02-27 | Hampshire | Massachusetts | 25015 | 26639 | 407 |
2258607 | 2258607 | 2022-02-27 | Hampshire | West Virginia | 54027 | 5738 | 67 |
2253478 | 2253478 | 2022-02-26 | Hampshire | Massachusetts | 25015 | 26639 | 407 |
2255356 | 2255356 | 2022-02-26 | Hampshire | West Virginia | 54027 | 5738 | 67 |
2250227 | 2250227 | 2022-02-25 | Hampshire | Massachusetts | 25015 | 26639 | 407 |
2252105 | 2252105 | 2022-02-25 | Hampshire | West Virginia | 54027 | 5738 | 67 |
2246976 | 2246976 | 2022-02-24 | Hampshire | Massachusetts | 25015 | 26538 | 409 |
2248854 | 2248854 | 2022-02-24 | Hampshire | West Virginia | 54027 | 5732 | 65 |
2243725 | 2243725 | 2022-02-23 | Hampshire | Massachusetts | 25015 | 26460 | 408 |
2245603 | 2245603 | 2022-02-23 | Hampshire | West Virginia | 54027 | 5710 | 64 |
2240474 | 2240474 | 2022-02-22 | Hampshire | Massachusetts | 25015 | 26418 | 404 |
2242352 | 2242352 | 2022-02-22 | Hampshire | West Virginia | 54027 | 5707 | 64 |
2237223 | 2237223 | 2022-02-21 | Hampshire | Massachusetts | 25015 | 26204 | 403 |
2239101 | 2239101 | 2022-02-21 | Hampshire | West Virginia | 54027 | 5702 | 64 |
2233972 | 2233972 | 2022-02-20 | Hampshire | Massachusetts | 25015 | 26204 | 403 |
2235850 | 2235850 | 2022-02-20 | Hampshire | West Virginia | 54027 | 5680 | 64 |
2230721 | 2230721 | 2022-02-19 | Hampshire | Massachusetts | 25015 | 26204 | 403 |
2232599 | 2232599 | 2022-02-19 | Hampshire | West Virginia | 54027 | 5680 | 64 |
2227470 | 2227470 | 2022-02-18 | Hampshire | Massachusetts | 25015 | 26204 | 403 |
2229348 | 2229348 | 2022-02-18 | Hampshire | West Virginia | 54027 | 5680 | 64 |
2224219 | 2224219 | 2022-02-17 | Hampshire | Massachusetts | 25015 | 26098 | 403 |
2226097 | 2226097 | 2022-02-17 | Hampshire | West Virginia | 54027 | 5667 | 64 |
2220968 | 2220968 | 2022-02-16 | Hampshire | Massachusetts | 25015 | 25915 | 402 |
2222846 | 2222846 | 2022-02-16 | Hampshire | West Virginia | 54027 | 5648 | 64 |
2217717 | 2217717 | 2022-02-15 | Hampshire | Massachusetts | 25015 | 25845 | 399 |
2219595 | 2219595 | 2022-02-15 | Hampshire | West Virginia | 54027 | 5633 | 64 |
2214466 | 2214466 | 2022-02-14 | Hampshire | Massachusetts | 25015 | 25781 | 396 |
2216345 | 2216345 | 2022-02-14 | Hampshire | West Virginia | 54027 | 5613 | 64 |
2211214 | 2211214 | 2022-02-13 | Hampshire | Massachusetts | 25015 | 25524 | 395 |
2213094 | 2213094 | 2022-02-13 | Hampshire | West Virginia | 54027 | 5605 | 64 |
2207961 | 2207961 | 2022-02-12 | Hampshire | Massachusetts | 25015 | 25524 | 395 |
2209841 | 2209841 | 2022-02-12 | Hampshire | West Virginia | 54027 | 5596 | 64 |
2204708 | 2204708 | 2022-02-11 | Hampshire | Massachusetts | 25015 | 25524 | 395 |
2206588 | 2206588 | 2022-02-11 | Hampshire | West Virginia | 54027 | 5589 | 64 |
2201455 | 2201455 | 2022-02-10 | Hampshire | Massachusetts | 25015 | 25363 | 393 |
2203335 | 2203335 | 2022-02-10 | Hampshire | West Virginia | 54027 | 5580 | 64 |
2198201 | 2198201 | 2022-02-09 | Hampshire | Massachusetts | 25015 | 25164 | 390 |
2200081 | 2200081 | 2022-02-09 | Hampshire | West Virginia | 54027 | 5555 | 64 |
2194947 | 2194947 | 2022-02-08 | Hampshire | Massachusetts | 25015 | 24990 | 388 |
2196827 | 2196827 | 2022-02-08 | Hampshire | West Virginia | 54027 | 5533 | 64 |
2191693 | 2191693 | 2022-02-07 | Hampshire | Massachusetts | 25015 | 24930 | 383 |
2193572 | 2193572 | 2022-02-07 | Hampshire | West Virginia | 54027 | 5507 | 64 |
2188440 | 2188440 | 2022-02-06 | Hampshire | Massachusetts | 25015 | 24715 | 381 |
2190319 | 2190319 | 2022-02-06 | Hampshire | West Virginia | 54027 | 5494 | 64 |
2185187 | 2185187 | 2022-02-05 | Hampshire | Massachusetts | 25015 | 24715 | 381 |
2187066 | 2187066 | 2022-02-05 | Hampshire | West Virginia | 54027 | 5475 | 64 |
2181935 | 2181935 | 2022-02-04 | Hampshire | Massachusetts | 25015 | 24715 | 381 |
2183813 | 2183813 | 2022-02-04 | Hampshire | West Virginia | 54027 | 5441 | 64 |
2178683 | 2178683 | 2022-02-03 | Hampshire | Massachusetts | 25015 | 24552 | 381 |
2180561 | 2180561 | 2022-02-03 | Hampshire | West Virginia | 54027 | 5420 | 64 |
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);