ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Unknown" and state = "Massachusetts" 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 |
---|---|---|---|---|---|---|---|
2500819 | 2500819 | 2022-05-13 | Unknown | Massachusetts | 147062 | 22 | |
2497561 | 2497561 | 2022-05-12 | Unknown | Massachusetts | 146235 | 22 | |
2494303 | 2494303 | 2022-05-11 | Unknown | Massachusetts | 145286 | 22 | |
2491045 | 2491045 | 2022-05-10 | Unknown | Massachusetts | 144701 | 22 | |
2487788 | 2487788 | 2022-05-09 | Unknown | Massachusetts | 144011 | 22 | |
2484530 | 2484530 | 2022-05-08 | Unknown | Massachusetts | 143325 | 22 | |
2481272 | 2481272 | 2022-05-07 | Unknown | Massachusetts | 143325 | 22 | |
2478014 | 2478014 | 2022-05-06 | Unknown | Massachusetts | 143325 | 22 | |
2474756 | 2474756 | 2022-05-05 | Unknown | Massachusetts | 142646 | 22 | |
2471499 | 2471499 | 2022-05-04 | Unknown | Massachusetts | 142005 | 22 | |
2468243 | 2468243 | 2022-05-03 | Unknown | Massachusetts | 141515 | 24 | |
2464988 | 2464988 | 2022-05-02 | Unknown | Massachusetts | 141264 | 22 | |
2461732 | 2461732 | 2022-05-01 | Unknown | Massachusetts | 140783 | 22 | |
2458476 | 2458476 | 2022-04-30 | Unknown | Massachusetts | 140783 | 22 | |
2455220 | 2455220 | 2022-04-29 | Unknown | Massachusetts | 140783 | 22 | |
2451964 | 2451964 | 2022-04-28 | Unknown | Massachusetts | 140390 | 22 | |
2448708 | 2448708 | 2022-04-27 | Unknown | Massachusetts | 139992 | 22 | |
2445452 | 2445452 | 2022-04-26 | Unknown | Massachusetts | 139630 | 23 | |
2442196 | 2442196 | 2022-04-25 | Unknown | Massachusetts | 139399 | 23 | |
2438940 | 2438940 | 2022-04-24 | Unknown | Massachusetts | 139095 | 22 | |
2435684 | 2435684 | 2022-04-23 | Unknown | Massachusetts | 139095 | 22 | |
2432428 | 2432428 | 2022-04-22 | Unknown | Massachusetts | 139095 | 22 | |
2429172 | 2429172 | 2022-04-21 | Unknown | Massachusetts | 138925 | 22 | |
2425916 | 2425916 | 2022-04-20 | Unknown | Massachusetts | 138844 | 22 | |
2422660 | 2422660 | 2022-04-19 | Unknown | Massachusetts | 138730 | 22 | |
2419404 | 2419404 | 2022-04-18 | Unknown | Massachusetts | 138456 | 22 | |
2416148 | 2416148 | 2022-04-17 | Unknown | Massachusetts | 138456 | 22 | |
2412892 | 2412892 | 2022-04-16 | Unknown | Massachusetts | 138456 | 22 | |
2409636 | 2409636 | 2022-04-15 | Unknown | Massachusetts | 138456 | 22 | |
2406380 | 2406380 | 2022-04-14 | Unknown | Massachusetts | 138203 | 22 | |
2403124 | 2403124 | 2022-04-13 | Unknown | Massachusetts | 137918 | 22 | |
2399870 | 2399870 | 2022-04-12 | Unknown | Massachusetts | 137667 | 22 | |
2396614 | 2396614 | 2022-04-11 | Unknown | Massachusetts | 137415 | 22 | |
2393359 | 2393359 | 2022-04-10 | Unknown | Massachusetts | 137147 | 22 | |
2390103 | 2390103 | 2022-04-09 | Unknown | Massachusetts | 137147 | 22 | |
2386847 | 2386847 | 2022-04-08 | Unknown | Massachusetts | 137147 | 22 | |
2383592 | 2383592 | 2022-04-07 | Unknown | Massachusetts | 137030 | 22 | |
2380337 | 2380337 | 2022-04-06 | Unknown | Massachusetts | 136808 | 22 | |
2377082 | 2377082 | 2022-04-05 | Unknown | Massachusetts | 136629 | 22 | |
2373830 | 2373830 | 2022-04-04 | Unknown | Massachusetts | 136542 | 22 | |
2370577 | 2370577 | 2022-04-03 | Unknown | Massachusetts | 136323 | 22 | |
2367324 | 2367324 | 2022-04-02 | Unknown | Massachusetts | 136323 | 22 | |
2364071 | 2364071 | 2022-04-01 | Unknown | Massachusetts | 136323 | 22 | |
2360817 | 2360817 | 2022-03-31 | Unknown | Massachusetts | 136176 | 22 | |
2357563 | 2357563 | 2022-03-30 | Unknown | Massachusetts | 136051 | 22 | |
2354310 | 2354310 | 2022-03-29 | Unknown | Massachusetts | 135906 | 22 | |
2351058 | 2351058 | 2022-03-28 | Unknown | Massachusetts | 135850 | 22 | |
2347805 | 2347805 | 2022-03-27 | Unknown | Massachusetts | 135654 | 22 | |
2344552 | 2344552 | 2022-03-26 | Unknown | Massachusetts | 135654 | 22 | |
2341299 | 2341299 | 2022-03-25 | Unknown | Massachusetts | 135654 | 22 | |
2338046 | 2338046 | 2022-03-24 | Unknown | Massachusetts | 135578 | 22 | |
2334792 | 2334792 | 2022-03-23 | Unknown | Massachusetts | 135441 | 22 | |
2331538 | 2331538 | 2022-03-22 | Unknown | Massachusetts | 135314 | 22 | |
2328286 | 2328286 | 2022-03-21 | Unknown | Massachusetts | 135284 | 22 | |
2325033 | 2325033 | 2022-03-20 | Unknown | Massachusetts | 135191 | 22 | |
2321779 | 2321779 | 2022-03-19 | Unknown | Massachusetts | 135191 | 22 | |
2318525 | 2318525 | 2022-03-18 | Unknown | Massachusetts | 135191 | 22 | |
2315272 | 2315272 | 2022-03-17 | Unknown | Massachusetts | 135125 | 22 | |
2312019 | 2312019 | 2022-03-16 | Unknown | Massachusetts | 135008 | 22 | |
2308766 | 2308766 | 2022-03-15 | Unknown | Massachusetts | 134939 | 22 | |
2305515 | 2305515 | 2022-03-14 | Unknown | Massachusetts | 134913 | 22 | |
2302263 | 2302263 | 2022-03-13 | Unknown | Massachusetts | 134408 | 22 | |
2299011 | 2299011 | 2022-03-12 | Unknown | Massachusetts | 134408 | 22 | |
2295759 | 2295759 | 2022-03-11 | Unknown | Massachusetts | 134408 | 22 | |
2292507 | 2292507 | 2022-03-10 | Unknown | Massachusetts | 134353 | 22 | |
2289255 | 2289255 | 2022-03-09 | Unknown | Massachusetts | 134266 | 22 | |
2286004 | 2286004 | 2022-03-08 | Unknown | Massachusetts | 134275 | 23 | |
2282752 | 2282752 | 2022-03-07 | Unknown | Massachusetts | 134269 | 23 | |
2279499 | 2279499 | 2022-03-06 | Unknown | Massachusetts | 134121 | 23 | |
2276246 | 2276246 | 2022-03-05 | Unknown | Massachusetts | 134121 | 23 | |
2272993 | 2272993 | 2022-03-04 | Unknown | Massachusetts | 134121 | 23 | |
2269741 | 2269741 | 2022-03-03 | Unknown | Massachusetts | 134064 | 23 | |
2266488 | 2266488 | 2022-03-02 | Unknown | Massachusetts | 133968 | 23 | |
2263237 | 2263237 | 2022-03-01 | Unknown | Massachusetts | 133885 | 23 | |
2259986 | 2259986 | 2022-02-28 | Unknown | Massachusetts | 133798 | 24 | |
2256735 | 2256735 | 2022-02-27 | Unknown | Massachusetts | 133726 | 24 | |
2253484 | 2253484 | 2022-02-26 | Unknown | Massachusetts | 133726 | 24 | |
2250233 | 2250233 | 2022-02-25 | Unknown | Massachusetts | 133726 | 24 | |
2246982 | 2246982 | 2022-02-24 | Unknown | Massachusetts | 133733 | 25 | |
2243731 | 2243731 | 2022-02-23 | Unknown | Massachusetts | 133667 | 23 | |
2240480 | 2240480 | 2022-02-22 | Unknown | Massachusetts | 133599 | 23 | |
2237229 | 2237229 | 2022-02-21 | Unknown | Massachusetts | 133353 | 22 | |
2233978 | 2233978 | 2022-02-20 | Unknown | Massachusetts | 133353 | 22 | |
2230727 | 2230727 | 2022-02-19 | Unknown | Massachusetts | 133353 | 22 | |
2227476 | 2227476 | 2022-02-18 | Unknown | Massachusetts | 133353 | 22 | |
2224225 | 2224225 | 2022-02-17 | Unknown | Massachusetts | 133228 | 22 | |
2220974 | 2220974 | 2022-02-16 | Unknown | Massachusetts | 132904 | 24 | |
2217723 | 2217723 | 2022-02-15 | Unknown | Massachusetts | 132691 | 23 | |
2214472 | 2214472 | 2022-02-14 | Unknown | Massachusetts | 132466 | 23 | |
2211220 | 2211220 | 2022-02-13 | Unknown | Massachusetts | 132151 | 22 | |
2207967 | 2207967 | 2022-02-12 | Unknown | Massachusetts | 132151 | 22 | |
2204714 | 2204714 | 2022-02-11 | Unknown | Massachusetts | 132151 | 22 | |
2201461 | 2201461 | 2022-02-10 | Unknown | Massachusetts | 131812 | 22 | |
2198207 | 2198207 | 2022-02-09 | Unknown | Massachusetts | 131512 | 21 | |
2194953 | 2194953 | 2022-02-08 | Unknown | Massachusetts | 131080 | 20 | |
2191699 | 2191699 | 2022-02-07 | Unknown | Massachusetts | 130783 | 20 | |
2188446 | 2188446 | 2022-02-06 | Unknown | Massachusetts | 130442 | 19 | |
2185193 | 2185193 | 2022-02-05 | Unknown | Massachusetts | 130442 | 19 | |
2181941 | 2181941 | 2022-02-04 | Unknown | Massachusetts | 130442 | 19 | |
2178689 | 2178689 | 2022-02-03 | Unknown | Massachusetts | 129879 | 19 |
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);