ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
36 rows where deaths = 1508 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 10
- New Jersey 14
- Massachusetts 6
- Maryland 4
- Ohio 3
- California 2
- Florida 2
- Texas 2
- Alabama 1
- Georgia 1
- Nevada 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2244295 | 2244295 | 2022-02-23 | Morris | New Jersey | 34027 | 115937 | 1508 |
2200266 | 2200266 | 2022-02-10 | Mobile | Alabama | 1097 | 110188 | 1508 |
2190843 | 2190843 | 2022-02-07 | Unknown | Florida | 70590 | 1508 | |
2171328 | 2171328 | 2022-02-01 | Unknown | Florida | 77204 | 1508 | |
2092473 | 2092473 | 2022-01-07 | Travis | Texas | 48453 | 153005 | 1508 |
2089221 | 2089221 | 2022-01-06 | Travis | Texas | 48453 | 150505 | 1508 |
1824352 | 1824352 | 2021-10-17 | Plymouth | Massachusetts | 25023 | 58039 | 1508 |
1821103 | 1821103 | 2021-10-16 | Plymouth | Massachusetts | 25023 | 58039 | 1508 |
1817854 | 1817854 | 2021-10-15 | Plymouth | Massachusetts | 25023 | 58039 | 1508 |
1814605 | 1814605 | 2021-10-14 | Plymouth | Massachusetts | 25023 | 57917 | 1508 |
1656260 | 1656260 | 2021-08-26 | Franklin | Ohio | 39049 | 137735 | 1508 |
1651154 | 1651154 | 2021-08-25 | San Joaquin | California | 6077 | 88151 | 1508 |
1653013 | 1653013 | 2021-08-25 | Franklin | Ohio | 39049 | 137270 | 1508 |
1649766 | 1649766 | 2021-08-24 | Franklin | Ohio | 39049 | 136889 | 1508 |
1628636 | 1628636 | 2021-08-18 | Fulton | Georgia | 13121 | 110883 | 1508 |
1330720 | 1330720 | 2021-05-18 | Hampden | Massachusetts | 25013 | 51856 | 1508 |
1327444 | 1327444 | 2021-05-17 | Baltimore | Maryland | 24005 | 65051 | 1508 |
1324198 | 1324198 | 2021-05-16 | Baltimore | Maryland | 24005 | 65023 | 1508 |
1320952 | 1320952 | 2021-05-15 | Baltimore | Maryland | 24005 | 64967 | 1508 |
1274483 | 1274483 | 2021-05-01 | Alameda | California | 6001 | 86623 | 1508 |
1249538 | 1249538 | 2021-04-23 | Montgomery | Maryland | 24031 | 69284 | 1508 |
1188415 | 1188415 | 2021-04-04 | Monmouth | New Jersey | 34025 | 69268 | 1508 |
1185168 | 1185168 | 2021-04-03 | Monmouth | New Jersey | 34025 | 69024 | 1508 |
954131 | 954131 | 2021-01-22 | Suffolk | Massachusetts | 25025 | 67729 | 1508 |
792424 | 792424 | 2020-12-03 | Middlesex | New Jersey | 34023 | 32233 | 1508 |
678829 | 678829 | 2020-10-29 | Clark | Nevada | 32003 | 80794 | 1508 |
497398 | 497398 | 2020-09-03 | Hudson | New Jersey | 34017 | 20366 | 1508 |
494165 | 494165 | 2020-09-02 | Hudson | New Jersey | 34017 | 20357 | 1508 |
490931 | 490931 | 2020-09-01 | Hudson | New Jersey | 34017 | 20323 | 1508 |
487698 | 487698 | 2020-08-31 | Hudson | New Jersey | 34017 | 20304 | 1508 |
442475 | 442475 | 2020-08-17 | Hudson | New Jersey | 34017 | 20078 | 1508 |
439248 | 439248 | 2020-08-16 | Hudson | New Jersey | 34017 | 20059 | 1508 |
436023 | 436023 | 2020-08-15 | Hudson | New Jersey | 34017 | 20033 | 1508 |
432797 | 432797 | 2020-08-14 | Hudson | New Jersey | 34017 | 19997 | 1508 |
429570 | 429570 | 2020-08-13 | Hudson | New Jersey | 34017 | 19959 | 1508 |
164959 | 164959 | 2020-05-21 | Bergen | New Jersey | 34003 | 17583 | 1508 |
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);