ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,502,832 rows sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 81,226
- Georgia 54,009
- Virginia 44,334
- Kentucky 39,412
- Missouri 37,768
- Illinois 33,873
- North Carolina 33,509
- Iowa 32,770
- Kansas 32,691
- Tennessee 32,287
- Indiana 31,130
- Ohio 29,682
- Minnesota 28,899
- Michigan 27,990
- Mississippi 27,764
- Nebraska 27,698
- Oklahoma 25,369
- Arkansas 25,364
- Wisconsin 24,167
- Puerto Rico 23,458
- Florida 23,238
- Pennsylvania 22,760
- Alabama 22,631
- Louisiana 22,108
- Colorado 21,175
- South Dakota 20,380
- New York 19,998
- California 19,991
- West Virginia 17,926
- North Dakota 16,577
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1065592 | 1065592 | 2021-02-25 | Coamo | Puerto Rico | 72043 | 943 | |
1065593 | 1065593 | 2021-02-25 | Comerio | Puerto Rico | 72045 | 675 | |
1065594 | 1065594 | 2021-02-25 | Corozal | Puerto Rico | 72047 | 1597 | |
1065595 | 1065595 | 2021-02-25 | Culebra | Puerto Rico | 72049 | 28 | |
1065596 | 1065596 | 2021-02-25 | Dorado | Puerto Rico | 72051 | 2144 | |
1065597 | 1065597 | 2021-02-25 | Fajardo | Puerto Rico | 72053 | 1270 | |
1065598 | 1065598 | 2021-02-25 | Florida | Puerto Rico | 72054 | 675 | |
1065599 | 1065599 | 2021-02-25 | Guanica | Puerto Rico | 72055 | 248 | |
1065600 | 1065600 | 2021-02-25 | Guayama | Puerto Rico | 72057 | 808 | |
1065601 | 1065601 | 2021-02-25 | Guayanilla | Puerto Rico | 72059 | 428 | |
1065602 | 1065602 | 2021-02-25 | Guaynabo | Puerto Rico | 72061 | 4365 | |
1065603 | 1065603 | 2021-02-25 | Gurabo | Puerto Rico | 72063 | 1839 | |
1065604 | 1065604 | 2021-02-25 | Hatillo | Puerto Rico | 72065 | 1040 | |
1065605 | 1065605 | 2021-02-25 | Hormigueros | Puerto Rico | 72067 | 409 | |
1065606 | 1065606 | 2021-02-25 | Humacao | Puerto Rico | 72069 | 1646 | |
1065607 | 1065607 | 2021-02-25 | Isabela | Puerto Rico | 72071 | 1218 | |
1065608 | 1065608 | 2021-02-25 | Jayuya | Puerto Rico | 72073 | 413 | |
1065609 | 1065609 | 2021-02-25 | Juana Diaz | Puerto Rico | 72075 | 1088 | |
1065610 | 1065610 | 2021-02-25 | Juncos | Puerto Rico | 72077 | 1726 | |
1065611 | 1065611 | 2021-02-25 | Lajas | Puerto Rico | 72079 | 411 | |
1065612 | 1065612 | 2021-02-25 | Lares | Puerto Rico | 72081 | 873 | |
1065613 | 1065613 | 2021-02-25 | Las Marias | Puerto Rico | 72083 | 203 | |
1065614 | 1065614 | 2021-02-25 | Las Piedras | Puerto Rico | 72085 | 1418 | |
1065615 | 1065615 | 2021-02-25 | Loiza | Puerto Rico | 72087 | 985 | |
1065616 | 1065616 | 2021-02-25 | Luquillo | Puerto Rico | 72089 | 665 | |
1065617 | 1065617 | 2021-02-25 | Manati | Puerto Rico | 72091 | 1538 | |
1065618 | 1065618 | 2021-02-25 | Maricao | Puerto Rico | 72093 | 117 | |
1065619 | 1065619 | 2021-02-25 | Maunabo | Puerto Rico | 72095 | 321 | |
1065620 | 1065620 | 2021-02-25 | Mayaguez | Puerto Rico | 72097 | 1956 | |
1065621 | 1065621 | 2021-02-25 | Moca | Puerto Rico | 72099 | 1375 | |
1065622 | 1065622 | 2021-02-25 | Morovis | Puerto Rico | 72101 | 1327 | |
1065623 | 1065623 | 2021-02-25 | Naguabo | Puerto Rico | 72103 | 780 | |
1065624 | 1065624 | 2021-02-25 | Naranjito | Puerto Rico | 72105 | 1578 | |
1065625 | 1065625 | 2021-02-25 | Orocovis | Puerto Rico | 72107 | 792 | |
1065626 | 1065626 | 2021-02-25 | Patillas | Puerto Rico | 72109 | 366 | |
1065627 | 1065627 | 2021-02-25 | Penuelas | Puerto Rico | 72111 | 527 | |
1065628 | 1065628 | 2021-02-25 | Ponce | Puerto Rico | 72113 | 3050 | |
1065629 | 1065629 | 2021-02-25 | Quebradillas | Puerto Rico | 72115 | 708 | |
1065630 | 1065630 | 2021-02-25 | Rincon | Puerto Rico | 72117 | 445 | |
1065631 | 1065631 | 2021-02-25 | Rio Grande | Puerto Rico | 72119 | 1774 | |
1065632 | 1065632 | 2021-02-25 | Sabana Grande | Puerto Rico | 72121 | 409 | |
1065633 | 1065633 | 2021-02-25 | Salinas | Puerto Rico | 72123 | 1010 | |
1065634 | 1065634 | 2021-02-25 | San German | Puerto Rico | 72125 | 609 | |
1065635 | 1065635 | 2021-02-25 | San Juan | Puerto Rico | 72127 | 17830 | |
1065636 | 1065636 | 2021-02-25 | San Lorenzo | Puerto Rico | 72129 | 1455 | |
1065637 | 1065637 | 2021-02-25 | San Sebastian | Puerto Rico | 72131 | 1646 | |
1065638 | 1065638 | 2021-02-25 | Santa Isabel | Puerto Rico | 72133 | 559 | |
1065639 | 1065639 | 2021-02-25 | Toa Alta | Puerto Rico | 72135 | 3666 | |
1065640 | 1065640 | 2021-02-25 | Toa Baja | Puerto Rico | 72137 | 3823 | |
1065641 | 1065641 | 2021-02-25 | Trujillo Alto | Puerto Rico | 72139 | 2885 | |
1065642 | 1065642 | 2021-02-25 | Unknown | Puerto Rico | 4418 | 2016 | |
1065643 | 1065643 | 2021-02-25 | Utuado | Puerto Rico | 72141 | 851 | |
1065644 | 1065644 | 2021-02-25 | Vega Alta | Puerto Rico | 72143 | 1819 | |
1065645 | 1065645 | 2021-02-25 | Vega Baja | Puerto Rico | 72145 | 2684 | |
1065646 | 1065646 | 2021-02-25 | Vieques | Puerto Rico | 72147 | 195 | |
1065647 | 1065647 | 2021-02-25 | Villalba | Puerto Rico | 72149 | 752 | |
1065648 | 1065648 | 2021-02-25 | Yabucoa | Puerto Rico | 72151 | 1006 | |
1065649 | 1065649 | 2021-02-25 | Yauco | Puerto Rico | 72153 | 996 | |
1065650 | 1065650 | 2021-02-25 | Bristol | Rhode Island | 44001 | 4172 | 130 |
1065651 | 1065651 | 2021-02-25 | Kent | Rhode Island | 44003 | 15199 | 316 |
1065652 | 1065652 | 2021-02-25 | Newport | Rhode Island | 44005 | 5116 | 34 |
1065653 | 1065653 | 2021-02-25 | Providence | Rhode Island | 44007 | 81582 | 1815 |
1065654 | 1065654 | 2021-02-25 | Unknown | Rhode Island | 11491 | 47 | |
1065655 | 1065655 | 2021-02-25 | Washington | Rhode Island | 44009 | 7625 | 154 |
1065656 | 1065656 | 2021-02-25 | Abbeville | South Carolina | 45001 | 2207 | 35 |
1065657 | 1065657 | 2021-02-25 | Aiken | South Carolina | 45003 | 15573 | 202 |
1065658 | 1065658 | 2021-02-25 | Allendale | South Carolina | 45005 | 839 | 15 |
1065659 | 1065659 | 2021-02-25 | Anderson | South Carolina | 45007 | 20148 | 453 |
1065660 | 1065660 | 2021-02-25 | Bamberg | South Carolina | 45009 | 1447 | 48 |
1065661 | 1065661 | 2021-02-25 | Barnwell | South Carolina | 45011 | 2367 | 48 |
1065662 | 1065662 | 2021-02-25 | Beaufort | South Carolina | 45013 | 15263 | 178 |
1065663 | 1065663 | 2021-02-25 | Berkeley | South Carolina | 45015 | 14733 | 167 |
1065664 | 1065664 | 2021-02-25 | Calhoun | South Carolina | 45017 | 1209 | 35 |
1065665 | 1065665 | 2021-02-25 | Charleston | South Carolina | 45019 | 37773 | 447 |
1065666 | 1065666 | 2021-02-25 | Cherokee | South Carolina | 45021 | 5343 | 132 |
1065667 | 1065667 | 2021-02-25 | Chester | South Carolina | 45023 | 3652 | 65 |
1065668 | 1065668 | 2021-02-25 | Chesterfield | South Carolina | 45025 | 4227 | 96 |
1065669 | 1065669 | 2021-02-25 | Clarendon | South Carolina | 45027 | 2956 | 100 |
1065670 | 1065670 | 2021-02-25 | Colleton | South Carolina | 45029 | 3196 | 111 |
1065671 | 1065671 | 2021-02-25 | Darlington | South Carolina | 45031 | 7760 | 163 |
1065672 | 1065672 | 2021-02-25 | Dillon | South Carolina | 45033 | 3894 | 78 |
1065673 | 1065673 | 2021-02-25 | Dorchester | South Carolina | 45035 | 14928 | 185 |
1065674 | 1065674 | 2021-02-25 | Edgefield | South Carolina | 45037 | 2741 | 37 |
1065675 | 1065675 | 2021-02-25 | Fairfield | South Carolina | 45039 | 2084 | 72 |
1065676 | 1065676 | 2021-02-25 | Florence | South Carolina | 45041 | 16511 | 379 |
1065677 | 1065677 | 2021-02-25 | Georgetown | South Carolina | 45043 | 6136 | 133 |
1065678 | 1065678 | 2021-02-25 | Greenville | South Carolina | 45045 | 63241 | 852 |
1065679 | 1065679 | 2021-02-25 | Greenwood | South Carolina | 45047 | 6991 | 158 |
1065680 | 1065680 | 2021-02-25 | Hampton | South Carolina | 45049 | 1658 | 43 |
1065681 | 1065681 | 2021-02-25 | Horry | South Carolina | 45051 | 34075 | 523 |
1065682 | 1065682 | 2021-02-25 | Jasper | South Carolina | 45053 | 2123 | 41 |
1065683 | 1065683 | 2021-02-25 | Kershaw | South Carolina | 45055 | 6649 | 120 |
1065684 | 1065684 | 2021-02-25 | Lancaster | South Carolina | 45057 | 9458 | 142 |
1065685 | 1065685 | 2021-02-25 | Laurens | South Carolina | 45059 | 6218 | 156 |
1065686 | 1065686 | 2021-02-25 | Lee | South Carolina | 45061 | 1760 | 56 |
1065687 | 1065687 | 2021-02-25 | Lexington | South Carolina | 45063 | 29543 | 428 |
1065688 | 1065688 | 2021-02-25 | Marion | South Carolina | 45067 | 3229 | 96 |
1065689 | 1065689 | 2021-02-25 | Marlboro | South Carolina | 45069 | 2970 | 50 |
1065690 | 1065690 | 2021-02-25 | McCormick | South Carolina | 45065 | 898 | 26 |
1065691 | 1065691 | 2021-02-25 | Newberry | South Carolina | 45071 | 4348 | 92 |
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);