ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
42 rows where deaths = 1506 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 14
- Oklahoma 7
- Texas 6
- Massachusetts 4
- New Jersey 4
- Washington 4
- California 3
- New York 3
- Wisconsin 3
- Maryland 2
- Pennsylvania 2
- Florida 1
- Georgia 1
- Minnesota 1
- Nevada 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492475 | 2492475 | 2022-05-10 | Collin | Texas | 48085 | 215429 | 1506 |
2489217 | 2489217 | 2022-05-09 | Collin | Texas | 48085 | 215289 | 1506 |
2485960 | 2485960 | 2022-05-08 | Collin | Texas | 48085 | 215177 | 1506 |
2482702 | 2482702 | 2022-05-07 | Collin | Texas | 48085 | 215064 | 1506 |
2479444 | 2479444 | 2022-05-06 | Collin | Texas | 48085 | 214935 | 1506 |
2476186 | 2476186 | 2022-05-05 | Collin | Texas | 48085 | 214778 | 1506 |
2036664 | 2036664 | 2021-12-21 | Lancaster | Pennsylvania | 42071 | 85753 | 1506 |
1927550 | 1927550 | 2021-11-18 | Gwinnett | Georgia | 13135 | 135196 | 1506 |
1808108 | 1808108 | 2021-10-12 | Plymouth | Massachusetts | 25023 | 57684 | 1506 |
1786329 | 1786329 | 2021-10-05 | Oklahoma | Oklahoma | 40109 | 113912 | 1506 |
1783080 | 1783080 | 2021-10-04 | Oklahoma | Oklahoma | 40109 | 113912 | 1506 |
1779831 | 1779831 | 2021-10-03 | Oklahoma | Oklahoma | 40109 | 113912 | 1506 |
1776581 | 1776581 | 2021-10-02 | Oklahoma | Oklahoma | 40109 | 113912 | 1506 |
1773331 | 1773331 | 2021-10-01 | Oklahoma | Oklahoma | 40109 | 113912 | 1506 |
1770081 | 1770081 | 2021-09-30 | Oklahoma | Oklahoma | 40109 | 113912 | 1506 |
1766832 | 1766832 | 2021-09-29 | Oklahoma | Oklahoma | 40109 | 113912 | 1506 |
1712592 | 1712592 | 2021-09-12 | Milwaukee | Wisconsin | 55079 | 134598 | 1506 |
1709345 | 1709345 | 2021-09-11 | Milwaukee | Wisconsin | 55079 | 134598 | 1506 |
1706098 | 1706098 | 2021-09-10 | Milwaukee | Wisconsin | 55079 | 134598 | 1506 |
1317735 | 1317735 | 2021-05-14 | Hampden | Massachusetts | 25013 | 51644 | 1506 |
1257889 | 1257889 | 2021-04-25 | King | Washington | 53033 | 99553 | 1506 |
1254642 | 1254642 | 2021-04-24 | King | Washington | 53033 | 99553 | 1506 |
1251395 | 1251395 | 2021-04-23 | King | Washington | 53033 | 99087 | 1506 |
1246291 | 1246291 | 2021-04-22 | Montgomery | Maryland | 24031 | 69193 | 1506 |
1248148 | 1248148 | 2021-04-22 | King | Washington | 53033 | 98629 | 1506 |
1243044 | 1243044 | 2021-04-21 | Montgomery | Maryland | 24031 | 69095 | 1506 |
1086181 | 1086181 | 2021-03-04 | Sacramento | California | 6067 | 93946 | 1506 |
1042828 | 1042828 | 2021-02-18 | Montgomery | Pennsylvania | 42091 | 52252 | 1506 |
1009927 | 1009927 | 2021-02-08 | Erie | New York | 36029 | 59867 | 1506 |
995312 | 995312 | 2021-02-04 | Santa Clara | California | 6085 | 103748 | 1506 |
967224 | 967224 | 2021-01-26 | Hennepin | Minnesota | 27053 | 94707 | 1506 |
950886 | 950886 | 2021-01-21 | Suffolk | Massachusetts | 25025 | 67004 | 1506 |
879489 | 879489 | 2020-12-30 | Worcester | Massachusetts | 25027 | 41640 | 1506 |
766562 | 766562 | 2020-11-25 | Westchester | New York | 36119 | 47963 | 1506 |
706470 | 706470 | 2020-11-07 | Orange | California | 6059 | 63798 | 1506 |
675586 | 675586 | 2020-10-28 | Clark | Nevada | 32003 | 80104 | 1506 |
638457 | 638457 | 2020-10-17 | Broward | Florida | 12011 | 80820 | 1506 |
481229 | 481229 | 2020-08-29 | Hudson | New Jersey | 34017 | 20276 | 1506 |
477997 | 477997 | 2020-08-28 | Hudson | New Jersey | 34017 | 20260 | 1506 |
474764 | 474764 | 2020-08-27 | Hudson | New Jersey | 34017 | 20248 | 1506 |
471530 | 471530 | 2020-08-26 | Hudson | New Jersey | 34017 | 20228 | 1506 |
201716 | 201716 | 2020-06-02 | Westchester | New York | 36119 | 33632 | 1506 |
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);