ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
32 rows where deaths = 2015 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 9
- New Jersey 8
- New York 7
- Texas 4
- Connecticut 3
- Maryland 3
- Massachusetts 2
- Minnesota 2
- Pennsylvania 2
- Georgia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2341276 | 2341276 | 2022-03-25 | Montgomery | Maryland | 24031 | 166723 | 2015 |
2338023 | 2338023 | 2022-03-24 | Montgomery | Maryland | 24031 | 166632 | 2015 |
2334769 | 2334769 | 2022-03-23 | Montgomery | Maryland | 24031 | 166545 | 2015 |
2194161 | 2194161 | 2022-02-08 | Fulton | Georgia | 13121 | 208905 | 2015 |
2176000 | 2176000 | 2022-02-02 | Monmouth | New Jersey | 34025 | 158191 | 2015 |
2035594 | 2035594 | 2021-12-21 | Bristol | Massachusetts | 25005 | 98301 | 2015 |
2011014 | 2011014 | 2021-12-13 | Cameron | Texas | 48061 | 67417 | 2015 |
2007763 | 2007763 | 2021-12-12 | Cameron | Texas | 48061 | 67401 | 2015 |
2004512 | 2004512 | 2021-12-11 | Cameron | Texas | 48061 | 67385 | 2015 |
1951201 | 1951201 | 2021-11-25 | Hennepin | Minnesota | 27053 | 174365 | 2015 |
1947950 | 1947950 | 2021-11-24 | Hennepin | Minnesota | 27053 | 174365 | 2015 |
1873658 | 1873658 | 2021-11-01 | Passaic | New Jersey | 34031 | 81958 | 2015 |
1870409 | 1870409 | 2021-10-31 | Passaic | New Jersey | 34031 | 81923 | 2015 |
1867160 | 1867160 | 2021-10-30 | Passaic | New Jersey | 34031 | 81867 | 2015 |
1733950 | 1733950 | 2021-09-19 | Union | New Jersey | 34039 | 77514 | 2015 |
1471321 | 1471321 | 2021-06-30 | Allegheny | Pennsylvania | 42003 | 101898 | 2015 |
1209663 | 1209663 | 2021-04-11 | New Haven | Connecticut | 9009 | 84116 | 2015 |
1206414 | 1206414 | 2021-04-10 | New Haven | Connecticut | 9009 | 84116 | 2015 |
1203166 | 1203166 | 2021-04-09 | New Haven | Connecticut | 9009 | 84116 | 2015 |
1084515 | 1084515 | 2021-03-03 | Hudson | New Jersey | 34017 | 70202 | 2015 |
1026194 | 1026194 | 2021-02-13 | Westchester | New York | 36119 | 101014 | 2015 |
1019605 | 1019605 | 2021-02-11 | Middlesex | New Jersey | 34023 | 67872 | 2015 |
1002807 | 1002807 | 2021-02-06 | Essex | Massachusetts | 25009 | 79118 | 2015 |
776709 | 776709 | 2020-11-28 | Philadelphia | Pennsylvania | 42101 | 65484 | 2015 |
744670 | 744670 | 2020-11-18 | Hidalgo | Texas | 48215 | 38628 | 2015 |
601105 | 601105 | 2020-10-05 | Suffolk | New York | 36103 | 46891 | 2015 |
597862 | 597862 | 2020-10-04 | Suffolk | New York | 36103 | 46842 | 2015 |
594619 | 594619 | 2020-10-03 | Suffolk | New York | 36103 | 46770 | 2015 |
591378 | 591378 | 2020-10-02 | Suffolk | New York | 36103 | 46667 | 2015 |
588137 | 588137 | 2020-10-01 | Suffolk | New York | 36103 | 46563 | 2015 |
584897 | 584897 | 2020-09-30 | Suffolk | New York | 36103 | 46517 | 2015 |
276224 | 276224 | 2020-06-26 | Essex | New Jersey | 34013 | 18903 | 2015 |
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);