ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
51 rows where deaths = 1175 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 17
- Louisiana 8
- Florida 7
- Illinois 7
- Kansas 5
- California 4
- Massachusetts 4
- Texas 3
- Arkansas 2
- Georgia 2
- Indiana 2
- Colorado 1
- Connecticut 1
- Missouri 1
- New York 1
- Ohio 1
- Pennsylvania 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2405306 | 2405306 | 2022-04-14 | Pulaski | Arkansas | 5119 | 103120 | 1175 |
2402051 | 2402051 | 2022-04-13 | Pulaski | Arkansas | 5119 | 103097 | 1175 |
2399272 | 2399272 | 2022-04-12 | Kane | Illinois | 17089 | 126514 | 1175 |
2383055 | 2383055 | 2022-04-07 | Allen | Indiana | 18003 | 103712 | 1175 |
2379800 | 2379800 | 2022-04-06 | Allen | Indiana | 18003 | 103712 | 1175 |
2171925 | 2171925 | 2022-02-01 | Sedgwick | Kansas | 20173 | 138916 | 1175 |
2168672 | 2168672 | 2022-01-31 | Sedgwick | Kansas | 20173 | 138916 | 1175 |
2165417 | 2165417 | 2022-01-30 | Sedgwick | Kansas | 20173 | 137653 | 1175 |
2162162 | 2162162 | 2022-01-29 | Sedgwick | Kansas | 20173 | 137653 | 1175 |
2158907 | 2158907 | 2022-01-28 | Sedgwick | Kansas | 20173 | 137653 | 1175 |
2029000 | 2029000 | 2021-12-19 | East Baton Rouge | Louisiana | 22033 | 65255 | 1175 |
2025749 | 2025749 | 2021-12-18 | East Baton Rouge | Louisiana | 22033 | 65255 | 1175 |
2022498 | 2022498 | 2021-12-17 | East Baton Rouge | Louisiana | 22033 | 65255 | 1175 |
2019247 | 2019247 | 2021-12-16 | East Baton Rouge | Louisiana | 22033 | 65201 | 1175 |
1988270 | 1988270 | 2021-12-06 | Collin | Texas | 48085 | 133653 | 1175 |
1985020 | 1985020 | 2021-12-05 | Collin | Texas | 48085 | 133492 | 1175 |
1930058 | 1930058 | 2021-11-18 | Fairfax | Virginia | 51059 | 93462 | 1175 |
1924494 | 1924494 | 2021-11-17 | Lake | Illinois | 17097 | 83912 | 1175 |
1921245 | 1921245 | 2021-11-16 | Lake | Illinois | 17097 | 83723 | 1175 |
1917995 | 1917995 | 2021-11-15 | Lake | Illinois | 17097 | 83557 | 1175 |
1901361 | 1901361 | 2021-11-10 | El Paso | Colorado | 8041 | 107376 | 1175 |
1898993 | 1898993 | 2021-11-09 | Jefferson | Louisiana | 22051 | 69897 | 1175 |
1892493 | 1892493 | 2021-11-07 | Jefferson | Louisiana | 22051 | 69813 | 1175 |
1889243 | 1889243 | 2021-11-06 | Jefferson | Louisiana | 22051 | 69813 | 1175 |
1885993 | 1885993 | 2021-11-05 | Jefferson | Louisiana | 22051 | 69813 | 1175 |
1805490 | 1805490 | 2021-10-11 | Monroe | New York | 36055 | 82092 | 1175 |
1778326 | 1778326 | 2021-10-03 | Will | Illinois | 17197 | 88614 | 1175 |
1775076 | 1775076 | 2021-10-02 | Will | Illinois | 17197 | 88614 | 1175 |
1771826 | 1771826 | 2021-10-01 | Will | Illinois | 17197 | 88614 | 1175 |
1585008 | 1585008 | 2021-08-04 | Lancaster | Pennsylvania | 42071 | 56223 | 1175 |
1359166 | 1359166 | 2021-05-27 | Gwinnett | Georgia | 13135 | 102513 | 1175 |
1355920 | 1355920 | 2021-05-26 | Gwinnett | Georgia | 13135 | 102439 | 1175 |
1096073 | 1096073 | 2021-03-07 | Polk | Florida | 12105 | 58116 | 1175 |
1076561 | 1076561 | 2021-03-01 | Duval | Florida | 12031 | 88825 | 1175 |
1047198 | 1047198 | 2021-02-20 | Alameda | California | 6001 | 79492 | 1175 |
1042605 | 1042605 | 2021-02-18 | Franklin | Ohio | 39049 | 109830 | 1175 |
963861 | 963861 | 2021-01-25 | Hampden | Massachusetts | 25013 | 35489 | 1175 |
960616 | 960616 | 2021-01-24 | Hampden | Massachusetts | 25013 | 35170 | 1175 |
937013 | 937013 | 2021-01-17 | Hillsborough | Florida | 12057 | 92438 | 1175 |
937037 | 937037 | 2021-01-17 | Pinellas | Florida | 12103 | 54212 | 1175 |
933768 | 933768 | 2021-01-16 | Hillsborough | Florida | 12057 | 91632 | 1175 |
831167 | 831167 | 2020-12-15 | St. Louis | Missouri | 29189 | 61500 | 1175 |
822670 | 822670 | 2020-12-12 | Tarrant | Texas | 48439 | 118207 | 1175 |
800580 | 800580 | 2020-12-06 | San Bernardino | California | 6071 | 106770 | 1175 |
797335 | 797335 | 2020-12-05 | San Bernardino | California | 6071 | 103911 | 1175 |
794090 | 794090 | 2020-12-04 | San Bernardino | California | 6071 | 100787 | 1175 |
684792 | 684792 | 2020-10-31 | Worcester | Massachusetts | 25027 | 16894 | 1175 |
476532 | 476532 | 2020-08-28 | Broward | Florida | 12011 | 70513 | 1175 |
380729 | 380729 | 2020-07-29 | Essex | Massachusetts | 25009 | 17119 | 1175 |
331805 | 331805 | 2020-07-14 | Miami-Dade | Florida | 12086 | 69802 | 1175 |
172703 | 172703 | 2020-05-24 | Hartford | Connecticut | 9003 | 9686 | 1175 |
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);