ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 25009 sorted by deaths descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▲ |
---|---|---|---|---|---|---|---|
2295750 | 2295750 | 2022-03-11 | Essex | Massachusetts | 25009 | 202995 | 3163 |
2299002 | 2299002 | 2022-03-12 | Essex | Massachusetts | 25009 | 202995 | 3163 |
2302254 | 2302254 | 2022-03-13 | Essex | Massachusetts | 25009 | 202995 | 3163 |
2292498 | 2292498 | 2022-03-10 | Essex | Massachusetts | 25009 | 202936 | 3160 |
2289246 | 2289246 | 2022-03-09 | Essex | Massachusetts | 25009 | 202872 | 3157 |
2285995 | 2285995 | 2022-03-08 | Essex | Massachusetts | 25009 | 202811 | 3156 |
2282743 | 2282743 | 2022-03-07 | Essex | Massachusetts | 25009 | 202765 | 3149 |
2272984 | 2272984 | 2022-03-04 | Essex | Massachusetts | 25009 | 202654 | 3146 |
2276237 | 2276237 | 2022-03-05 | Essex | Massachusetts | 25009 | 202654 | 3146 |
2279490 | 2279490 | 2022-03-06 | Essex | Massachusetts | 25009 | 202654 | 3146 |
2269732 | 2269732 | 2022-03-03 | Essex | Massachusetts | 25009 | 202589 | 3142 |
2266479 | 2266479 | 2022-03-02 | Essex | Massachusetts | 25009 | 202523 | 3139 |
2263228 | 2263228 | 2022-03-01 | Essex | Massachusetts | 25009 | 202469 | 3135 |
2259977 | 2259977 | 2022-02-28 | Essex | Massachusetts | 25009 | 202395 | 3122 |
2250224 | 2250224 | 2022-02-25 | Essex | Massachusetts | 25009 | 202263 | 3111 |
2253475 | 2253475 | 2022-02-26 | Essex | Massachusetts | 25009 | 202263 | 3111 |
2256726 | 2256726 | 2022-02-27 | Essex | Massachusetts | 25009 | 202263 | 3111 |
2246973 | 2246973 | 2022-02-24 | Essex | Massachusetts | 25009 | 202179 | 3109 |
2243722 | 2243722 | 2022-02-23 | Essex | Massachusetts | 25009 | 202060 | 3105 |
2240471 | 2240471 | 2022-02-22 | Essex | Massachusetts | 25009 | 202013 | 3089 |
2227467 | 2227467 | 2022-02-18 | Essex | Massachusetts | 25009 | 201680 | 3083 |
2230718 | 2230718 | 2022-02-19 | Essex | Massachusetts | 25009 | 201680 | 3083 |
2233969 | 2233969 | 2022-02-20 | Essex | Massachusetts | 25009 | 201680 | 3083 |
2237220 | 2237220 | 2022-02-21 | Essex | Massachusetts | 25009 | 201680 | 3083 |
2224216 | 2224216 | 2022-02-17 | Essex | Massachusetts | 25009 | 201562 | 3075 |
2220965 | 2220965 | 2022-02-16 | Essex | Massachusetts | 25009 | 201384 | 3069 |
2217714 | 2217714 | 2022-02-15 | Essex | Massachusetts | 25009 | 201252 | 3063 |
2214463 | 2214463 | 2022-02-14 | Essex | Massachusetts | 25009 | 201122 | 3051 |
2204705 | 2204705 | 2022-02-11 | Essex | Massachusetts | 25009 | 200813 | 3047 |
2207958 | 2207958 | 2022-02-12 | Essex | Massachusetts | 25009 | 200813 | 3047 |
2211211 | 2211211 | 2022-02-13 | Essex | Massachusetts | 25009 | 200813 | 3047 |
2201452 | 2201452 | 2022-02-10 | Essex | Massachusetts | 25009 | 200603 | 3041 |
2198198 | 2198198 | 2022-02-09 | Essex | Massachusetts | 25009 | 200370 | 3038 |
2194944 | 2194944 | 2022-02-08 | Essex | Massachusetts | 25009 | 200147 | 3027 |
2191690 | 2191690 | 2022-02-07 | Essex | Massachusetts | 25009 | 199977 | 3009 |
2181932 | 2181932 | 2022-02-04 | Essex | Massachusetts | 25009 | 199398 | 3000 |
2185184 | 2185184 | 2022-02-05 | Essex | Massachusetts | 25009 | 199398 | 3000 |
2188437 | 2188437 | 2022-02-06 | Essex | Massachusetts | 25009 | 199398 | 3000 |
2178680 | 2178680 | 2022-02-03 | Essex | Massachusetts | 25009 | 199114 | 2991 |
2175428 | 2175428 | 2022-02-02 | Essex | Massachusetts | 25009 | 198689 | 2985 |
2172175 | 2172175 | 2022-02-01 | Essex | Massachusetts | 25009 | 198216 | 2976 |
2168922 | 2168922 | 2022-01-31 | Essex | Massachusetts | 25009 | 197960 | 2964 |
2159157 | 2159157 | 2022-01-28 | Essex | Massachusetts | 25009 | 196731 | 2951 |
2162412 | 2162412 | 2022-01-29 | Essex | Massachusetts | 25009 | 196731 | 2951 |
2165667 | 2165667 | 2022-01-30 | Essex | Massachusetts | 25009 | 196731 | 2951 |
2155903 | 2155903 | 2022-01-27 | Essex | Massachusetts | 25009 | 196066 | 2945 |
2152650 | 2152650 | 2022-01-26 | Essex | Massachusetts | 25009 | 195242 | 2932 |
2149398 | 2149398 | 2022-01-25 | Essex | Massachusetts | 25009 | 194465 | 2923 |
2146146 | 2146146 | 2022-01-24 | Essex | Massachusetts | 25009 | 193746 | 2903 |
2136380 | 2136380 | 2022-01-21 | Essex | Massachusetts | 25009 | 191083 | 2892 |
2139636 | 2139636 | 2022-01-22 | Essex | Massachusetts | 25009 | 191083 | 2892 |
2142891 | 2142891 | 2022-01-23 | Essex | Massachusetts | 25009 | 191083 | 2892 |
2133128 | 2133128 | 2022-01-20 | Essex | Massachusetts | 25009 | 189729 | 2875 |
2129875 | 2129875 | 2022-01-19 | Essex | Massachusetts | 25009 | 188286 | 2865 |
2126621 | 2126621 | 2022-01-18 | Essex | Massachusetts | 25009 | 186681 | 2838 |
2113614 | 2113614 | 2022-01-14 | Essex | Massachusetts | 25009 | 181006 | 2831 |
2116865 | 2116865 | 2022-01-15 | Essex | Massachusetts | 25009 | 181006 | 2831 |
2120117 | 2120117 | 2022-01-16 | Essex | Massachusetts | 25009 | 181006 | 2831 |
2123369 | 2123369 | 2022-01-17 | Essex | Massachusetts | 25009 | 181006 | 2831 |
2110362 | 2110362 | 2022-01-13 | Essex | Massachusetts | 25009 | 180115 | 2817 |
2107111 | 2107111 | 2022-01-12 | Essex | Massachusetts | 25009 | 177805 | 2811 |
2103860 | 2103860 | 2022-01-11 | Essex | Massachusetts | 25009 | 175240 | 2795 |
2100609 | 2100609 | 2022-01-10 | Essex | Massachusetts | 25009 | 173392 | 2780 |
2090854 | 2090854 | 2022-01-07 | Essex | Massachusetts | 25009 | 166430 | 2769 |
2094106 | 2094106 | 2022-01-08 | Essex | Massachusetts | 25009 | 166430 | 2769 |
2097358 | 2097358 | 2022-01-09 | Essex | Massachusetts | 25009 | 166430 | 2769 |
2087603 | 2087603 | 2022-01-06 | Essex | Massachusetts | 25009 | 162507 | 2759 |
2494294 | 2494294 | 2022-05-11 | Essex | Massachusetts | 25009 | 213261 | 2758 |
2497552 | 2497552 | 2022-05-12 | Essex | Massachusetts | 25009 | 213890 | 2758 |
2500810 | 2500810 | 2022-05-13 | Essex | Massachusetts | 25009 | 214332 | 2758 |
2491036 | 2491036 | 2022-05-10 | Essex | Massachusetts | 25009 | 212871 | 2757 |
2084351 | 2084351 | 2022-01-05 | Essex | Massachusetts | 25009 | 159515 | 2749 |
2478005 | 2478005 | 2022-05-06 | Essex | Massachusetts | 25009 | 211651 | 2748 |
2481263 | 2481263 | 2022-05-07 | Essex | Massachusetts | 25009 | 211651 | 2748 |
2484521 | 2484521 | 2022-05-08 | Essex | Massachusetts | 25009 | 211651 | 2748 |
2474747 | 2474747 | 2022-05-05 | Essex | Massachusetts | 25009 | 211312 | 2747 |
2487779 | 2487779 | 2022-05-09 | Essex | Massachusetts | 25009 | 212536 | 2747 |
2081099 | 2081099 | 2022-01-04 | Essex | Massachusetts | 25009 | 155765 | 2746 |
2471490 | 2471490 | 2022-05-04 | Essex | Massachusetts | 25009 | 210805 | 2745 |
2464979 | 2464979 | 2022-05-02 | Essex | Massachusetts | 25009 | 210295 | 2742 |
2468234 | 2468234 | 2022-05-03 | Essex | Massachusetts | 25009 | 210536 | 2742 |
2455211 | 2455211 | 2022-04-29 | Essex | Massachusetts | 25009 | 209640 | 2740 |
2458467 | 2458467 | 2022-04-30 | Essex | Massachusetts | 25009 | 209640 | 2740 |
2461723 | 2461723 | 2022-05-01 | Essex | Massachusetts | 25009 | 209640 | 2740 |
2451955 | 2451955 | 2022-04-28 | Essex | Massachusetts | 25009 | 209340 | 2739 |
2442187 | 2442187 | 2022-04-25 | Essex | Massachusetts | 25009 | 208519 | 2738 |
2448699 | 2448699 | 2022-04-27 | Essex | Massachusetts | 25009 | 209027 | 2738 |
2445443 | 2445443 | 2022-04-26 | Essex | Massachusetts | 25009 | 208775 | 2737 |
2432419 | 2432419 | 2022-04-22 | Essex | Massachusetts | 25009 | 207962 | 2736 |
2435675 | 2435675 | 2022-04-23 | Essex | Massachusetts | 25009 | 207962 | 2736 |
2438931 | 2438931 | 2022-04-24 | Essex | Massachusetts | 25009 | 207962 | 2736 |
2429163 | 2429163 | 2022-04-21 | Essex | Massachusetts | 25009 | 207770 | 2735 |
2425907 | 2425907 | 2022-04-20 | Essex | Massachusetts | 25009 | 207493 | 2734 |
2399861 | 2399861 | 2022-04-12 | Essex | Massachusetts | 25009 | 205978 | 2731 |
2422651 | 2422651 | 2022-04-19 | Essex | Massachusetts | 25009 | 207319 | 2731 |
2077847 | 2077847 | 2022-01-03 | Essex | Massachusetts | 25009 | 153925 | 2730 |
2403115 | 2403115 | 2022-04-13 | Essex | Massachusetts | 25009 | 206145 | 2730 |
2409627 | 2409627 | 2022-04-15 | Essex | Massachusetts | 25009 | 206639 | 2730 |
2412883 | 2412883 | 2022-04-16 | Essex | Massachusetts | 25009 | 206639 | 2730 |
2416139 | 2416139 | 2022-04-17 | Essex | Massachusetts | 25009 | 206639 | 2730 |
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);