ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
76 rows where cases = 5356 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 26
- Texas 8
- Florida 7
- New York 6
- Kentucky 5
- Ohio 5
- Washington 5
- Minnesota 4
- Illinois 3
- Missouri 3
- Nebraska 3
- Puerto Rico 3
- Tennessee 3
- Arkansas 2
- Georgia 2
- Indiana 2
- Iowa 2
- Mississippi 2
- West Virginia 2
- Wisconsin 2
- Alabama 1
- California 1
- Idaho 1
- North Carolina 1
- South Dakota 1
- Vermont 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2486664 | 2486664 | 2022-05-09 | Clark | Arkansas | 5019 | 5356 | 79 |
2284340 | 2284340 | 2022-03-07 | San Jacinto | Texas | 48407 | 5356 | 100 |
2265973 | 2265973 | 2022-03-02 | Fountain | Indiana | 18045 | 5356 | 97 |
2260269 | 2260269 | 2022-02-28 | Crawford | Missouri | 29055 | 5356 | 96 |
2224845 | 2224845 | 2022-02-17 | Essex | New York | 36031 | 5356 | 54 |
2196636 | 2196636 | 2022-02-08 | Windham | Vermont | 50025 | 5356 | 33 |
2190458 | 2190458 | 2022-02-07 | Barbour | Alabama | 1005 | 5356 | 85 |
2146395 | 2146395 | 2022-01-24 | Sunflower | Mississippi | 28133 | 5356 | 111 |
2063488 | 2063488 | 2021-12-29 | Mineral | West Virginia | 54057 | 5356 | 135 |
2054904 | 2054904 | 2021-12-27 | Grant | Kentucky | 21081 | 5356 | 46 |
2055336 | 2055336 | 2021-12-27 | Prentiss | Mississippi | 28117 | 5356 | 87 |
2018435 | 2018435 | 2021-12-16 | Bradford | Florida | 12007 | 5356 | 125 |
2020828 | 2020828 | 2021-12-16 | Grimes | Texas | 48185 | 5356 | 109 |
2015185 | 2015185 | 2021-12-15 | Bradford | Florida | 12007 | 5356 | 125 |
2016725 | 2016725 | 2021-12-15 | Greene | New York | 36039 | 5356 | 93 |
2011934 | 2011934 | 2021-12-14 | Bradford | Florida | 12007 | 5356 | 125 |
2012988 | 2012988 | 2021-12-14 | Nobles | Minnesota | 27105 | 5356 | 55 |
2008683 | 2008683 | 2021-12-13 | Bradford | Florida | 12007 | 5356 | 125 |
2005432 | 2005432 | 2021-12-12 | Bradford | Florida | 12007 | 5356 | 125 |
2002181 | 2002181 | 2021-12-11 | Bradford | Florida | 12007 | 5356 | 125 |
1998931 | 1998931 | 2021-12-10 | Bradford | Florida | 12007 | 5356 | 125 |
1996739 | 1996739 | 2021-12-09 | Pine | Minnesota | 27115 | 5356 | 44 |
1973622 | 1973622 | 2021-12-02 | Calloway | Kentucky | 21035 | 5356 | 64 |
1971257 | 1971257 | 2021-12-01 | Wyoming | New York | 36121 | 5356 | 67 |
1972446 | 1972446 | 2021-12-01 | Stevens | Washington | 53065 | 5356 | 103 |
1969196 | 1969196 | 2021-11-30 | Stevens | Washington | 53065 | 5356 | 103 |
1933776 | 1933776 | 2021-11-20 | Unknown | Arkansas | 5356 | 0 | |
1925700 | 1925700 | 2021-11-17 | Columbia | New York | 36021 | 5356 | 113 |
1892372 | 1892372 | 2021-11-07 | Clark | Kentucky | 21049 | 5356 | 40 |
1889122 | 1889122 | 2021-11-06 | Clark | Kentucky | 21049 | 5356 | 40 |
1889680 | 1889680 | 2021-11-06 | Pulaski | Missouri | 29169 | 5356 | 79 |
1885872 | 1885872 | 2021-11-05 | Clark | Kentucky | 21049 | 5356 | 40 |
1836720 | 1836720 | 2021-10-21 | Christian | Illinois | 17021 | 5356 | 100 |
1779354 | 1779354 | 2021-10-03 | Madison | Nebraska | 31119 | 5356 | 44 |
1776104 | 1776104 | 2021-10-02 | Madison | Nebraska | 31119 | 5356 | 44 |
1772854 | 1772854 | 2021-10-01 | Madison | Nebraska | 31119 | 5356 | 44 |
1770498 | 1770498 | 2021-09-30 | White | Tennessee | 47185 | 5356 | 87 |
1737260 | 1737260 | 2021-09-20 | Madison | New York | 36053 | 5356 | 97 |
1737777 | 1737777 | 2021-09-20 | Ponce | Puerto Rico | 72113 | 5356 | |
1738251 | 1738251 | 2021-09-20 | Washington | Texas | 48477 | 5356 | 115 |
1735001 | 1735001 | 2021-09-19 | Washington | Texas | 48477 | 5356 | 115 |
1731751 | 1731751 | 2021-09-18 | Washington | Texas | 48477 | 5356 | 114 |
1707763 | 1707763 | 2021-09-11 | Webster | Missouri | 29225 | 5356 | 82 |
1702275 | 1702275 | 2021-09-09 | Weakley | Tennessee | 47183 | 5356 | 74 |
1696358 | 1696358 | 2021-09-07 | Pierce | Wisconsin | 55093 | 5356 | 44 |
1662738 | 1662738 | 2021-08-28 | Auglaize | Ohio | 39011 | 5356 | 87 |
1653684 | 1653684 | 2021-08-25 | Kerr | Texas | 48265 | 5356 | 102 |
1644256 | 1644256 | 2021-08-22 | Grays Harbor | Washington | 53027 | 5356 | 86 |
1641006 | 1641006 | 2021-08-21 | Grays Harbor | Washington | 53027 | 5356 | 86 |
1637756 | 1637756 | 2021-08-20 | Grays Harbor | Washington | 53027 | 5356 | 86 |
1617262 | 1617262 | 2021-08-14 | Athens | Ohio | 39009 | 5356 | 60 |
1537223 | 1537223 | 2021-07-20 | Fremont | Wyoming | 56013 | 5356 | 87 |
1511151 | 1511151 | 2021-07-12 | Putnam | West Virginia | 54079 | 5356 | 94 |
1497163 | 1497163 | 2021-07-08 | Seneca | Ohio | 39147 | 5356 | 128 |
1407817 | 1407817 | 2021-06-11 | Coffee | Georgia | 13069 | 5356 | 174 |
1401326 | 1401326 | 2021-06-09 | Coffee | Georgia | 13069 | 5356 | 174 |
1305593 | 1305593 | 2021-05-10 | Darke | Ohio | 39037 | 5356 | 123 |
1302347 | 1302347 | 2021-05-09 | Darke | Ohio | 39037 | 5356 | 123 |
1288095 | 1288095 | 2021-05-05 | Cerro Gordo | Iowa | 19033 | 5356 | 89 |
1207441 | 1207441 | 2021-04-10 | Chisago | Minnesota | 27025 | 5356 | 48 |
1198824 | 1198824 | 2021-04-07 | Brown | South Dakota | 46013 | 5356 | 91 |
1138518 | 1138518 | 2021-03-20 | Coles | Illinois | 17029 | 5356 | 95 |
1139247 | 1139247 | 2021-03-20 | Crow Wing | Minnesota | 27035 | 5356 | 85 |
1065870 | 1065870 | 2021-02-25 | Atascosa | Texas | 48013 | 5356 | 134 |
977487 | 977487 | 2021-01-29 | Oswego | New York | 36075 | 5356 | 82 |
948928 | 948928 | 2021-01-20 | Bedford | Tennessee | 47003 | 5356 | 90 |
901555 | 901555 | 2021-01-06 | Madison | Idaho | 16065 | 5356 | 21 |
841221 | 841221 | 2020-12-18 | Burke | North Carolina | 37023 | 5356 | 73 |
813251 | 813251 | 2020-12-09 | Chippewa | Wisconsin | 55017 | 5356 | 59 |
708592 | 708592 | 2020-11-07 | Bayamon | Puerto Rico | 72021 | 5356 | |
705349 | 705349 | 2020-11-06 | Bayamon | Puerto Rico | 72021 | 5356 | |
567691 | 567691 | 2020-09-25 | Woodbury | Iowa | 19193 | 5356 | 64 |
454319 | 454319 | 2020-08-21 | Elkhart | Indiana | 18039 | 5356 | 99 |
440226 | 440226 | 2020-08-16 | McLennan | Texas | 48309 | 5356 | 72 |
331678 | 331678 | 2020-07-14 | Stanislaus | California | 6099 | 5356 | 57 |
185264 | 185264 | 2020-05-28 | Will | Illinois | 17197 | 5356 | 268 |
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);