ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
40 rows where deaths = 1493 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 13
- Ohio 15
- Maryland 5
- Texas 4
- Pennsylvania 3
- Georgia 2
- Massachusetts 2
- New Jersey 2
- New York 2
- Alabama 1
- California 1
- Illinois 1
- Nevada 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2450273 | 2450273 | 2022-04-27 | Nueces | Texas | 48355 | 93176 | 1493 |
2447016 | 2447016 | 2022-04-26 | Nueces | Texas | 48355 | 93167 | 1493 |
2407474 | 2407474 | 2022-04-14 | York | Pennsylvania | 42133 | 118736 | 1493 |
2362247 | 2362247 | 2022-03-31 | Collin | Texas | 48085 | 209695 | 1493 |
2182572 | 2182572 | 2022-02-04 | Monroe | New York | 36055 | 146549 | 1493 |
2173214 | 2173214 | 2022-02-01 | Berks | Pennsylvania | 42011 | 99196 | 1493 |
2033965 | 2033965 | 2021-12-20 | Travis | Texas | 48453 | 126275 | 1493 |
1997150 | 1997150 | 2021-12-09 | Camden | New Jersey | 34007 | 74347 | 1493 |
1993899 | 1993899 | 2021-12-08 | Camden | New Jersey | 34007 | 74012 | 1493 |
1969976 | 1969976 | 2021-12-01 | DuPage | Illinois | 17043 | 118195 | 1493 |
1921051 | 1921051 | 2021-11-16 | Gwinnett | Georgia | 13135 | 134900 | 1493 |
1919437 | 1919437 | 2021-11-15 | Hamilton | Ohio | 39061 | 109220 | 1493 |
1916187 | 1916187 | 2021-11-14 | Hamilton | Ohio | 39061 | 109052 | 1493 |
1912937 | 1912937 | 2021-11-13 | Hamilton | Ohio | 39061 | 108892 | 1493 |
1909687 | 1909687 | 2021-11-12 | Hamilton | Ohio | 39061 | 108716 | 1493 |
1838395 | 1838395 | 2021-10-21 | Delaware | Pennsylvania | 42045 | 61404 | 1493 |
1765867 | 1765867 | 2021-09-29 | Plymouth | Massachusetts | 25023 | 56380 | 1493 |
1583157 | 1583157 | 2021-08-04 | Fulton | Georgia | 13121 | 105074 | 1493 |
1578295 | 1578295 | 2021-08-02 | Franklin | Ohio | 39049 | 131111 | 1493 |
1575047 | 1575047 | 2021-08-01 | Franklin | Ohio | 39049 | 131036 | 1493 |
1571799 | 1571799 | 2021-07-31 | Franklin | Ohio | 39049 | 130973 | 1493 |
1568551 | 1568551 | 2021-07-30 | Franklin | Ohio | 39049 | 130816 | 1493 |
1565303 | 1565303 | 2021-07-29 | Franklin | Ohio | 39049 | 130709 | 1493 |
1562055 | 1562055 | 2021-07-28 | Franklin | Ohio | 39049 | 130563 | 1493 |
1558807 | 1558807 | 2021-07-27 | Franklin | Ohio | 39049 | 130433 | 1493 |
1555560 | 1555560 | 2021-07-26 | Franklin | Ohio | 39049 | 130291 | 1493 |
1552313 | 1552313 | 2021-07-25 | Franklin | Ohio | 39049 | 130214 | 1493 |
1549066 | 1549066 | 2021-07-24 | Franklin | Ohio | 39049 | 130169 | 1493 |
1545819 | 1545819 | 2021-07-23 | Franklin | Ohio | 39049 | 130071 | 1493 |
1294979 | 1294979 | 2021-05-07 | Baltimore | Maryland | 24005 | 64361 | 1493 |
1267989 | 1267989 | 2021-04-29 | Alameda | California | 6001 | 86411 | 1493 |
1225625 | 1225625 | 2021-04-16 | Jefferson | Alabama | 1073 | 75406 | 1493 |
1225416 | 1225416 | 2021-04-15 | King | Washington | 53033 | 95784 | 1493 |
1220312 | 1220312 | 2021-04-14 | Montgomery | Maryland | 24031 | 68423 | 1493 |
1217064 | 1217064 | 2021-04-13 | Montgomery | Maryland | 24031 | 68306 | 1493 |
1213817 | 1213817 | 2021-04-12 | Montgomery | Maryland | 24031 | 68190 | 1493 |
1210569 | 1210569 | 2021-04-11 | Montgomery | Maryland | 24031 | 68088 | 1493 |
1070962 | 1070962 | 2021-02-27 | Bristol | Massachusetts | 25005 | 55604 | 1493 |
743841 | 743841 | 2020-11-18 | Westchester | New York | 36119 | 45334 | 1493 |
669101 | 669101 | 2020-10-26 | Clark | Nevada | 32003 | 79240 | 1493 |
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);