ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
15 rows where "date" is on date 2021-12-16 and state = "Massachusetts" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2019338 | 2019338 | 2021-12-16 | Barnstable | Massachusetts | 25001 | 21807 | 543 |
2019339 | 2019339 | 2021-12-16 | Berkshire | Massachusetts | 25003 | 11918 | 336 |
2019340 | 2019340 | 2021-12-16 | Bristol | Massachusetts | 25005 | 95730 | 1990 |
2019341 | 2019341 | 2021-12-16 | Dukes | Massachusetts | 25007 | 2148 | 0 |
2019342 | 2019342 | 2021-12-16 | Essex | Massachusetts | 25009 | 132127 | 2655 |
2019343 | 2019343 | 2021-12-16 | Franklin | Massachusetts | 25011 | 4662 | 127 |
2019344 | 2019344 | 2021-12-16 | Hampden | Massachusetts | 25013 | 76390 | 1727 |
2019345 | 2019345 | 2021-12-16 | Hampshire | Massachusetts | 25015 | 14034 | 334 |
2019346 | 2019346 | 2021-12-16 | Middlesex | Massachusetts | 25017 | 185583 | 4045 |
2019347 | 2019347 | 2021-12-16 | Nantucket | Massachusetts | 25019 | 2092 | 0 |
2019348 | 2019348 | 2021-12-16 | Norfolk | Massachusetts | 25021 | 74358 | 1921 |
2019349 | 2019349 | 2021-12-16 | Plymouth | Massachusetts | 25023 | 70980 | 1621 |
2019350 | 2019350 | 2021-12-16 | Suffolk | Massachusetts | 25025 | 120054 | 1966 |
2019351 | 2019351 | 2021-12-16 | Unknown | Massachusetts | 71911 | 12 | |
2019352 | 2019352 | 2021-12-16 | Worcester | Massachusetts | 25027 | 114606 | 2506 |
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);