ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
85 rows where deaths = 1099 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 25
- Illinois 22
- Texas 10
- Iowa 7
- Colorado 6
- California 4
- District of Columbia 4
- Arkansas 3
- New Jersey 3
- Ohio 3
- Washington 3
- Arizona 2
- Indiana 2
- Maryland 2
- Massachusetts 2
- Pennsylvania 2
- Connecticut 1
- Florida 1
- Georgia 1
- Louisiana 1
- Nebraska 1
- Nevada 1
- New Mexico 1
- Oregon 1
- South Carolina 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2445082 | 2445082 | 2022-04-26 | Polk | Iowa | 19153 | 125021 | 1099 |
2441826 | 2441826 | 2022-04-25 | Polk | Iowa | 19153 | 125021 | 1099 |
2438570 | 2438570 | 2022-04-24 | Polk | Iowa | 19153 | 125021 | 1099 |
2435314 | 2435314 | 2022-04-23 | Polk | Iowa | 19153 | 125021 | 1099 |
2432058 | 2432058 | 2022-04-22 | Polk | Iowa | 19153 | 125021 | 1099 |
2428802 | 2428802 | 2022-04-21 | Polk | Iowa | 19153 | 125021 | 1099 |
2425546 | 2425546 | 2022-04-20 | Polk | Iowa | 19153 | 125021 | 1099 |
2331995 | 2331995 | 2022-03-22 | Douglas | Nebraska | 31055 | 150084 | 1099 |
2333391 | 2333391 | 2022-03-22 | Snohomish | Washington | 53061 | 148496 | 1099 |
2330137 | 2330137 | 2022-03-21 | Snohomish | Washington | 53061 | 148496 | 1099 |
2306529 | 2306529 | 2022-03-14 | Multnomah | Oregon | 41051 | 111911 | 1099 |
2269656 | 2269656 | 2022-03-03 | Orleans | Louisiana | 22071 | 86480 | 1099 |
2270571 | 2270571 | 2022-03-03 | Butler | Ohio | 39017 | 90591 | 1099 |
2267319 | 2267319 | 2022-03-02 | Butler | Ohio | 39017 | 90512 | 1099 |
2267691 | 2267691 | 2022-03-02 | Horry | South Carolina | 45051 | 95781 | 1099 |
2264066 | 2264066 | 2022-03-01 | Butler | Ohio | 39017 | 90458 | 1099 |
2236157 | 2236157 | 2022-02-21 | Pulaski | Arkansas | 5119 | 101308 | 1099 |
2232906 | 2232906 | 2022-02-20 | Pulaski | Arkansas | 5119 | 101254 | 1099 |
2229655 | 2229655 | 2022-02-19 | Pulaski | Arkansas | 5119 | 101164 | 1099 |
2197671 | 2197671 | 2022-02-09 | Allen | Indiana | 18003 | 101942 | 1099 |
2194417 | 2194417 | 2022-02-08 | Allen | Indiana | 18003 | 101942 | 1099 |
2173647 | 2173647 | 2022-02-01 | Fort Bend | Texas | 48157 | 165988 | 1099 |
2170395 | 2170395 | 2022-01-31 | Fort Bend | Texas | 48157 | 165211 | 1099 |
2073624 | 2073624 | 2022-01-02 | Denver | Colorado | 8031 | 117579 | 1099 |
2076140 | 2076140 | 2022-01-02 | Lubbock | Texas | 48303 | 71724 | 1099 |
2070357 | 2070357 | 2022-01-01 | Adams | Colorado | 8001 | 95323 | 1099 |
2070373 | 2070373 | 2022-01-01 | Denver | Colorado | 8031 | 117579 | 1099 |
2072889 | 2072889 | 2022-01-01 | Lubbock | Texas | 48303 | 71724 | 1099 |
2067106 | 2067106 | 2021-12-31 | Adams | Colorado | 8001 | 95323 | 1099 |
2067122 | 2067122 | 2021-12-31 | Denver | Colorado | 8031 | 117579 | 1099 |
2069638 | 2069638 | 2021-12-31 | Lubbock | Texas | 48303 | 71724 | 1099 |
2066387 | 2066387 | 2021-12-30 | Lubbock | Texas | 48303 | 71724 | 1099 |
2057386 | 2057386 | 2021-12-28 | Jefferson | Colorado | 8059 | 79857 | 1099 |
2051305 | 2051305 | 2021-12-26 | Unknown | Illinois | 0 | 1099 | |
2048055 | 2048055 | 2021-12-25 | Unknown | Illinois | 0 | 1099 | |
2044805 | 2044805 | 2021-12-24 | Unknown | Illinois | 0 | 1099 | |
2041556 | 2041556 | 2021-12-23 | Unknown | Illinois | 0 | 1099 | |
2011712 | 2011712 | 2021-12-14 | Mohave | Arizona | 4015 | 37367 | 1099 |
1975694 | 1975694 | 2021-12-02 | Spokane | Washington | 53063 | 78463 | 1099 |
1969593 | 1969593 | 2021-12-01 | Tulare | California | 6107 | 86137 | 1099 |
1923388 | 1923388 | 2021-11-16 | Montgomery | Texas | 48339 | 88759 | 1099 |
1878455 | 1878455 | 2021-11-03 | Pinal | Arizona | 4021 | 74434 | 1099 |
1828176 | 1828176 | 2021-10-18 | Bernalillo | New Mexico | 35001 | 74239 | 1099 |
1789642 | 1789642 | 2021-10-06 | Berks | Pennsylvania | 42011 | 55550 | 1099 |
1602852 | 1602852 | 2021-08-10 | Lake | Illinois | 17097 | 70530 | 1099 |
1599603 | 1599603 | 2021-08-09 | Lake | Illinois | 17097 | 70430 | 1099 |
1595940 | 1595940 | 2021-08-08 | Stanislaus | California | 6099 | 67115 | 1099 |
1596355 | 1596355 | 2021-08-08 | Lake | Illinois | 17097 | 70075 | 1099 |
1592691 | 1592691 | 2021-08-07 | Stanislaus | California | 6099 | 67115 | 1099 |
1593106 | 1593106 | 2021-08-07 | Lake | Illinois | 17097 | 70075 | 1099 |
1589442 | 1589442 | 2021-08-06 | Stanislaus | California | 6099 | 67115 | 1099 |
1589857 | 1589857 | 2021-08-06 | Lake | Illinois | 17097 | 70075 | 1099 |
1586608 | 1586608 | 2021-08-05 | Lake | Illinois | 17097 | 69922 | 1099 |
1583358 | 1583358 | 2021-08-04 | Lake | Illinois | 17097 | 69812 | 1099 |
1580108 | 1580108 | 2021-08-03 | Lake | Illinois | 17097 | 69715 | 1099 |
1576859 | 1576859 | 2021-08-02 | Lake | Illinois | 17097 | 69614 | 1099 |
1573611 | 1573611 | 2021-08-01 | Lake | Illinois | 17097 | 69363 | 1099 |
1570363 | 1570363 | 2021-07-31 | Lake | Illinois | 17097 | 69363 | 1099 |
1567115 | 1567115 | 2021-07-30 | Lake | Illinois | 17097 | 69363 | 1099 |
1563867 | 1563867 | 2021-07-29 | Lake | Illinois | 17097 | 69258 | 1099 |
1427290 | 1427290 | 2021-06-17 | Cobb | Georgia | 13067 | 80369 | 1099 |
1408093 | 1408093 | 2021-06-11 | Will | Illinois | 17197 | 76851 | 1099 |
1404847 | 1404847 | 2021-06-10 | Will | Illinois | 17197 | 76834 | 1099 |
1401602 | 1401602 | 2021-06-09 | Will | Illinois | 17197 | 76817 | 1099 |
1398357 | 1398357 | 2021-06-08 | Will | Illinois | 17197 | 76794 | 1099 |
1371409 | 1371409 | 2021-05-30 | Fairfax | Virginia | 51059 | 76995 | 1099 |
1337186 | 1337186 | 2021-05-20 | Baltimore city | Maryland | 24510 | 52464 | 1099 |
1258383 | 1258383 | 2021-04-26 | District of Columbia | District of Columbia | 11001 | 47378 | 1099 |
1255136 | 1255136 | 2021-04-25 | District of Columbia | District of Columbia | 11001 | 47323 | 1099 |
1251889 | 1251889 | 2021-04-24 | District of Columbia | District of Columbia | 11001 | 47219 | 1099 |
1248642 | 1248642 | 2021-04-23 | District of Columbia | District of Columbia | 11001 | 47141 | 1099 |
1039070 | 1039070 | 2021-02-17 | Camden | New Jersey | 34007 | 42802 | 1099 |
1039080 | 1039080 | 2021-02-17 | Morris | New Jersey | 34027 | 35755 | 1099 |
957341 | 957341 | 2021-01-23 | Baltimore | Maryland | 24005 | 45491 | 1099 |
908079 | 908079 | 2021-01-08 | DuPage | Illinois | 17043 | 65385 | 1099 |
903229 | 903229 | 2021-01-06 | Allegheny | Pennsylvania | 42003 | 57708 | 1099 |
806443 | 806443 | 2020-12-07 | Tarrant | Texas | 48439 | 111865 | 1099 |
803198 | 803198 | 2020-12-06 | Tarrant | Texas | 48439 | 110015 | 1099 |
759976 | 759976 | 2020-11-23 | Ocean | New Jersey | 34029 | 20392 | 1099 |
725122 | 725122 | 2020-11-12 | Cameron | Texas | 48061 | 24895 | 1099 |
658841 | 658841 | 2020-10-23 | Norfolk | Massachusetts | 25021 | 11397 | 1099 |
476576 | 476576 | 2020-08-28 | Palm Beach | Florida | 12099 | 41556 | 1099 |
474731 | 474731 | 2020-08-27 | Clark | Nevada | 32003 | 57756 | 1099 |
376598 | 376598 | 2020-07-28 | New Haven | Connecticut | 9009 | 12965 | 1099 |
281992 | 281992 | 2020-06-28 | Essex | Massachusetts | 25009 | 16053 | 1099 |
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);