ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
30 rows where cases = 23811 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 6
- Maryland 24
- Wisconsin 2
- Connecticut 1
- Indiana 1
- Mississippi 1
- New Jersey 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2155408 | 2155408 | 2022-01-27 | Howard | Indiana | 18067 | 23811 | 401 |
2148482 | 2148482 | 2022-01-25 | Windham | Connecticut | 9015 | 23811 | 268 |
2055079 | 2055079 | 2021-12-27 | Howard | Maryland | 24027 | 23811 | 287 |
2051829 | 2051829 | 2021-12-26 | Howard | Maryland | 24027 | 23811 | 287 |
2048579 | 2048579 | 2021-12-25 | Howard | Maryland | 24027 | 23811 | 287 |
2045329 | 2045329 | 2021-12-24 | Howard | Maryland | 24027 | 23811 | 287 |
2042079 | 2042079 | 2021-12-23 | Howard | Maryland | 24027 | 23811 | 287 |
2038830 | 2038830 | 2021-12-22 | Howard | Maryland | 24027 | 23811 | 287 |
2035580 | 2035580 | 2021-12-21 | Howard | Maryland | 24027 | 23811 | 287 |
2032330 | 2032330 | 2021-12-20 | Howard | Maryland | 24027 | 23811 | 287 |
2029079 | 2029079 | 2021-12-19 | Howard | Maryland | 24027 | 23811 | 287 |
2025828 | 2025828 | 2021-12-18 | Howard | Maryland | 24027 | 23811 | 287 |
2022577 | 2022577 | 2021-12-17 | Howard | Maryland | 24027 | 23811 | 287 |
2019326 | 2019326 | 2021-12-16 | Howard | Maryland | 24027 | 23811 | 287 |
2016076 | 2016076 | 2021-12-15 | Howard | Maryland | 24027 | 23811 | 287 |
2012825 | 2012825 | 2021-12-14 | Howard | Maryland | 24027 | 23811 | 287 |
2009574 | 2009574 | 2021-12-13 | Howard | Maryland | 24027 | 23811 | 287 |
2006323 | 2006323 | 2021-12-12 | Howard | Maryland | 24027 | 23811 | 287 |
2003072 | 2003072 | 2021-12-11 | Howard | Maryland | 24027 | 23811 | 287 |
1999822 | 1999822 | 2021-12-10 | Howard | Maryland | 24027 | 23811 | 287 |
1996571 | 1996571 | 2021-12-09 | Howard | Maryland | 24027 | 23811 | 287 |
1993320 | 1993320 | 2021-12-08 | Howard | Maryland | 24027 | 23811 | 287 |
1990069 | 1990069 | 2021-12-07 | Howard | Maryland | 24027 | 23811 | 287 |
1986819 | 1986819 | 2021-12-06 | Howard | Maryland | 24027 | 23811 | 287 |
1983569 | 1983569 | 2021-12-05 | Howard | Maryland | 24027 | 23811 | 287 |
1980319 | 1980319 | 2021-12-04 | Howard | Maryland | 24027 | 23811 | 287 |
1610137 | 1610137 | 2021-08-12 | Harrison | Mississippi | 28047 | 23811 | 344 |
1215802 | 1215802 | 2021-04-12 | Racine | Wisconsin | 55101 | 23811 | 364 |
1212555 | 1212555 | 2021-04-11 | Racine | Wisconsin | 55101 | 23811 | 364 |
636676 | 636676 | 2020-10-16 | Bergen | New Jersey | 34003 | 23811 | 2050 |
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);