ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
72 rows where deaths = 1122 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 24
- Ohio 10
- Colorado 9
- Texas 8
- Washington 6
- Georgia 5
- Pennsylvania 5
- Massachusetts 4
- Illinois 3
- Kansas 3
- California 2
- District of Columbia 2
- Michigan 2
- New Jersey 2
- Arizona 1
- Connecticut 1
- Indiana 1
- Kentucky 1
- New Mexico 1
- New York 1
- Oregon 1
- Puerto Rico 1
- South Carolina 1
- Tennessee 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2401722 | 2401722 | 2022-04-12 | Snohomish | Washington | 53061 | 151258 | 1122 |
2398467 | 2398467 | 2022-04-11 | Snohomish | Washington | 53061 | 151258 | 1122 |
2395212 | 2395212 | 2022-04-10 | Snohomish | Washington | 53061 | 151258 | 1122 |
2391956 | 2391956 | 2022-04-09 | Snohomish | Washington | 53061 | 151258 | 1122 |
2388700 | 2388700 | 2022-04-08 | Snohomish | Washington | 53061 | 151258 | 1122 |
2352073 | 2352073 | 2022-03-28 | Multnomah | Oregon | 41051 | 112771 | 1122 |
2335624 | 2335624 | 2022-03-23 | Butler | Ohio | 39017 | 91520 | 1122 |
2332370 | 2332370 | 2022-03-22 | Butler | Ohio | 39017 | 91520 | 1122 |
2329117 | 2329117 | 2022-03-21 | Butler | Ohio | 39017 | 91520 | 1122 |
2325865 | 2325865 | 2022-03-20 | Butler | Ohio | 39017 | 91520 | 1122 |
2322612 | 2322612 | 2022-03-19 | Butler | Ohio | 39017 | 91520 | 1122 |
2319358 | 2319358 | 2022-03-18 | Butler | Ohio | 39017 | 91520 | 1122 |
2316104 | 2316104 | 2022-03-17 | Butler | Ohio | 39017 | 91520 | 1122 |
2283791 | 2283791 | 2022-03-07 | Chester | Pennsylvania | 42029 | 90773 | 1122 |
2280539 | 2280539 | 2022-03-06 | Chester | Pennsylvania | 42029 | 90741 | 1122 |
2242599 | 2242599 | 2022-02-23 | Yuma | Arizona | 4027 | 61986 | 1122 |
2217187 | 2217187 | 2022-02-15 | Allen | Indiana | 18003 | 102658 | 1122 |
2193163 | 2193163 | 2022-02-07 | Fort Bend | Texas | 48157 | 169331 | 1122 |
2188146 | 2188146 | 2022-02-06 | Johnson | Kansas | 20091 | 139089 | 1122 |
2189909 | 2189909 | 2022-02-06 | Fort Bend | Texas | 48157 | 168927 | 1122 |
2184893 | 2184893 | 2022-02-05 | Johnson | Kansas | 20091 | 139089 | 1122 |
2186656 | 2186656 | 2022-02-05 | Fort Bend | Texas | 48157 | 168413 | 1122 |
2181641 | 2181641 | 2022-02-04 | Johnson | Kansas | 20091 | 139089 | 1122 |
2183404 | 2183404 | 2022-02-04 | Fort Bend | Texas | 48157 | 167953 | 1122 |
2141905 | 2141905 | 2022-01-23 | Arapahoe | Colorado | 8005 | 134793 | 1122 |
2138650 | 2138650 | 2022-01-22 | Arapahoe | Colorado | 8005 | 134793 | 1122 |
2135394 | 2135394 | 2022-01-21 | Arapahoe | Colorado | 8005 | 134793 | 1122 |
2132142 | 2132142 | 2022-01-20 | Arapahoe | Colorado | 8005 | 133508 | 1122 |
2119145 | 2119145 | 2022-01-16 | Denver | Colorado | 8031 | 142720 | 1122 |
2115893 | 2115893 | 2022-01-15 | Denver | Colorado | 8031 | 142720 | 1122 |
2112642 | 2112642 | 2022-01-14 | Denver | Colorado | 8031 | 142720 | 1122 |
2102872 | 2102872 | 2022-01-11 | Adams | Colorado | 8001 | 108646 | 1122 |
2086645 | 2086645 | 2022-01-06 | Jefferson | Colorado | 8059 | 87817 | 1122 |
2011153 | 2011153 | 2021-12-13 | Montgomery | Texas | 48339 | 90353 | 1122 |
2011450 | 2011450 | 2021-12-13 | Spokane | Washington | 53063 | 79475 | 1122 |
2007902 | 2007902 | 2021-12-12 | Montgomery | Texas | 48339 | 90255 | 1122 |
2004651 | 2004651 | 2021-12-11 | Montgomery | Texas | 48339 | 90209 | 1122 |
1860669 | 1860669 | 2021-10-28 | Bernalillo | New Mexico | 35001 | 76290 | 1122 |
1861521 | 1861521 | 2021-10-28 | Collin | Texas | 48085 | 129153 | 1122 |
1825382 | 1825382 | 2021-10-17 | Berks | Pennsylvania | 42011 | 57027 | 1122 |
1822133 | 1822133 | 2021-10-16 | Berks | Pennsylvania | 42011 | 56904 | 1122 |
1818884 | 1818884 | 2021-10-15 | Berks | Pennsylvania | 42011 | 56795 | 1122 |
1806165 | 1806165 | 2021-10-11 | Davidson | Tennessee | 47037 | 130442 | 1122 |
1724507 | 1724507 | 2021-09-16 | Montgomery | Ohio | 39113 | 65099 | 1122 |
1721258 | 1721258 | 2021-09-15 | Montgomery | Ohio | 39113 | 64745 | 1122 |
1718010 | 1718010 | 2021-09-14 | Montgomery | Ohio | 39113 | 64425 | 1122 |
1713297 | 1713297 | 2021-09-13 | Lake | Illinois | 17097 | 75843 | 1122 |
1692348 | 1692348 | 2021-09-06 | Greenville | South Carolina | 45045 | 90485 | 1122 |
1633304 | 1633304 | 2021-08-19 | Monroe | New York | 36055 | 72207 | 1122 |
1609400 | 1609400 | 2021-08-12 | Will | Illinois | 17197 | 80221 | 1122 |
1560392 | 1560392 | 2021-07-28 | Cobb | Georgia | 13067 | 82983 | 1122 |
1557145 | 1557145 | 2021-07-27 | Cobb | Georgia | 13067 | 82756 | 1122 |
1553898 | 1553898 | 2021-07-26 | Cobb | Georgia | 13067 | 82516 | 1122 |
1514223 | 1514223 | 2021-07-13 | Fairfax | Virginia | 51059 | 77346 | 1122 |
1329809 | 1329809 | 2021-05-18 | District of Columbia | District of Columbia | 11001 | 48616 | 1122 |
1326562 | 1326562 | 2021-05-17 | District of Columbia | District of Columbia | 11001 | 48590 | 1122 |
1245530 | 1245530 | 2021-04-22 | Gwinnett | Georgia | 13135 | 99797 | 1122 |
1207158 | 1207158 | 2021-04-10 | Jefferson | Kentucky | 21111 | 78660 | 1122 |
1078028 | 1078028 | 2021-03-01 | Morris | New Jersey | 34027 | 37727 | 1122 |
1073428 | 1073428 | 2021-02-28 | Fulton | Georgia | 13121 | 85771 | 1122 |
1074782 | 1074782 | 2021-02-28 | Morris | New Jersey | 34027 | 37542 | 1122 |
1034218 | 1034218 | 2021-02-16 | Alameda | California | 6001 | 78904 | 1122 |
972557 | 972557 | 2021-01-28 | Fresno | California | 6019 | 86886 | 1122 |
924304 | 924304 | 2021-01-13 | DuPage | Illinois | 17043 | 67271 | 1122 |
786532 | 786532 | 2020-12-01 | Unknown | Puerto Rico | 2907 | 1122 | |
654671 | 654671 | 2020-10-22 | New Haven | Connecticut | 9009 | 15952 | 1122 |
600454 | 600454 | 2020-10-05 | Worcester | Massachusetts | 25027 | 14740 | 1122 |
542132 | 542132 | 2020-09-17 | Suffolk | Massachusetts | 25025 | 23464 | 1122 |
538896 | 538896 | 2020-09-16 | Suffolk | Massachusetts | 25025 | 23371 | 1122 |
380802 | 380802 | 2020-07-29 | Oakland | Michigan | 26125 | 14362 | 1122 |
361534 | 361534 | 2020-07-23 | Oakland | Michigan | 26125 | 13711 | 1122 |
307243 | 307243 | 2020-07-06 | Essex | Massachusetts | 25009 | 16283 | 1122 |
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);