ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
49 rows where deaths = 1125 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 20
- Virginia 13
- California 4
- Pennsylvania 4
- Arizona 3
- District of Columbia 3
- Michigan 3
- Florida 2
- Illinois 2
- Massachusetts 2
- New Jersey 2
- South Carolina 2
- Colorado 1
- Connecticut 1
- Georgia 1
- Indiana 1
- Kentucky 1
- New York 1
- Ohio 1
- Texas 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2290295 | 2290295 | 2022-03-09 | Chester | Pennsylvania | 42029 | 90881 | 1125 |
2202014 | 2202014 | 2022-02-10 | Burlington | New Jersey | 34005 | 99292 | 1125 |
2111435 | 2111435 | 2022-01-13 | Luzerne | Pennsylvania | 42079 | 62483 | 1125 |
2099651 | 2099651 | 2022-01-10 | Jefferson | Colorado | 8059 | 93829 | 1125 |
2031217 | 2031217 | 2021-12-20 | Mohave | Arizona | 4015 | 37919 | 1125 |
2027966 | 2027966 | 2021-12-19 | Mohave | Arizona | 4015 | 37824 | 1125 |
2024715 | 2024715 | 2021-12-18 | Mohave | Arizona | 4015 | 37809 | 1125 |
2017191 | 2017191 | 2021-12-15 | York | Pennsylvania | 42133 | 76049 | 1125 |
2014701 | 2014701 | 2021-12-14 | Spokane | Washington | 53063 | 79565 | 1125 |
1831880 | 1831880 | 2021-10-19 | Berks | Pennsylvania | 42011 | 57240 | 1125 |
1723040 | 1723040 | 2021-09-16 | Lake | Illinois | 17097 | 76320 | 1125 |
1698844 | 1698844 | 2021-09-08 | Greenville | South Carolina | 45045 | 91301 | 1125 |
1695596 | 1695596 | 2021-09-07 | Greenville | South Carolina | 45045 | 90991 | 1125 |
1651165 | 1651165 | 2021-08-25 | Stanislaus | California | 6099 | 72186 | 1125 |
1643054 | 1643054 | 2021-08-22 | Monroe | New York | 36055 | 72716 | 1125 |
1632133 | 1632133 | 2021-08-19 | Will | Illinois | 17197 | 81365 | 1125 |
1585673 | 1585673 | 2021-08-04 | Fairfax | Virginia | 51059 | 78841 | 1125 |
1579880 | 1579880 | 2021-08-03 | Cobb | Georgia | 13067 | 84274 | 1125 |
1582423 | 1582423 | 2021-08-03 | Fairfax | Virginia | 51059 | 78728 | 1125 |
1579173 | 1579173 | 2021-08-02 | Fairfax | Virginia | 51059 | 78633 | 1125 |
1575925 | 1575925 | 2021-08-01 | Fairfax | Virginia | 51059 | 78317 | 1125 |
1572677 | 1572677 | 2021-07-31 | Fairfax | Virginia | 51059 | 78317 | 1125 |
1569429 | 1569429 | 2021-07-30 | Fairfax | Virginia | 51059 | 78317 | 1125 |
1566181 | 1566181 | 2021-07-29 | Fairfax | Virginia | 51059 | 78246 | 1125 |
1562933 | 1562933 | 2021-07-28 | Fairfax | Virginia | 51059 | 78159 | 1125 |
1559685 | 1559685 | 2021-07-27 | Fairfax | Virginia | 51059 | 78078 | 1125 |
1556438 | 1556438 | 2021-07-26 | Fairfax | Virginia | 51059 | 78026 | 1125 |
1553191 | 1553191 | 2021-07-25 | Fairfax | Virginia | 51059 | 77838 | 1125 |
1549944 | 1549944 | 2021-07-24 | Fairfax | Virginia | 51059 | 77838 | 1125 |
1546697 | 1546697 | 2021-07-23 | Fairfax | Virginia | 51059 | 77838 | 1125 |
1342798 | 1342798 | 2021-05-22 | District of Columbia | District of Columbia | 11001 | 48727 | 1125 |
1339550 | 1339550 | 2021-05-21 | District of Columbia | District of Columbia | 11001 | 48689 | 1125 |
1336303 | 1336303 | 2021-05-20 | District of Columbia | District of Columbia | 11001 | 48662 | 1125 |
1213655 | 1213655 | 2021-04-12 | Jefferson | Kentucky | 21111 | 78937 | 1125 |
1099316 | 1099316 | 2021-03-08 | Orange | Florida | 12095 | 116528 | 1125 |
1096068 | 1096068 | 2021-03-07 | Orange | Florida | 12095 | 116366 | 1125 |
1037463 | 1037463 | 2021-02-17 | Alameda | California | 6001 | 79037 | 1125 |
958214 | 958214 | 2021-01-23 | Cuyahoga | Ohio | 39035 | 85571 | 1125 |
856283 | 856283 | 2020-12-23 | Marion | Indiana | 18097 | 65901 | 1125 |
786784 | 786784 | 2020-12-01 | Cameron | Texas | 48061 | 26290 | 1125 |
779447 | 779447 | 2020-11-29 | Ocean | New Jersey | 34029 | 21816 | 1125 |
748655 | 748655 | 2020-11-20 | San Bernardino | California | 6071 | 81328 | 1125 |
710789 | 710789 | 2020-11-08 | Macomb | Michigan | 26099 | 22913 | 1125 |
707491 | 707491 | 2020-11-07 | Norfolk | Massachusetts | 25021 | 12697 | 1125 |
707545 | 707545 | 2020-11-07 | Macomb | Michigan | 26099 | 22913 | 1125 |
606939 | 606939 | 2020-10-07 | Worcester | Massachusetts | 25027 | 14864 | 1125 |
534641 | 534641 | 2020-09-15 | Riverside | California | 6065 | 55986 | 1125 |
364741 | 364741 | 2020-07-24 | Oakland | Michigan | 26125 | 13782 | 1125 |
148500 | 148500 | 2020-05-16 | Fairfield | Connecticut | 9001 | 14140 | 1125 |
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);