ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,261 rows where cases = 48 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
These facets timed out: county, fips
state >30
- Texas 139
- Nebraska 110
- Virginia 106
- Georgia 105
- Kansas 101
- Colorado 95
- Tennessee 78
- Missouri 75
- Minnesota 74
- Puerto Rico 73
- Iowa 69
- Kentucky 69
- Ohio 64
- Oklahoma 62
- Pennsylvania 59
- Illinois 53
- West Virginia 51
- New York 49
- California 48
- Montana 48
- Indiana 47
- Michigan 47
- South Dakota 45
- Arkansas 44
- Wisconsin 43
- Wyoming 39
- Idaho 37
- North Dakota 35
- Alaska 34
- Mississippi 33
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2484488 | 2484488 | 2022-05-08 | Unknown | Maine | 48 | 0 | |
2481230 | 2481230 | 2022-05-07 | Unknown | Maine | 48 | 0 | |
2006781 | 2006781 | 2021-12-12 | Blaine | Nebraska | 31009 | 48 | 1 |
2003530 | 2003530 | 2021-12-11 | Blaine | Nebraska | 31009 | 48 | 1 |
2000280 | 2000280 | 2021-12-10 | Blaine | Nebraska | 31009 | 48 | 1 |
1925669 | 1925669 | 2021-11-17 | Harding | New Mexico | 35021 | 48 | 3 |
1922420 | 1922420 | 2021-11-16 | Harding | New Mexico | 35021 | 48 | 3 |
1919170 | 1919170 | 2021-11-15 | Harding | New Mexico | 35021 | 48 | 3 |
1886895 | 1886895 | 2021-11-05 | Slope | North Dakota | 38087 | 48 | 0 |
1883646 | 1883646 | 2021-11-04 | Slope | North Dakota | 38087 | 48 | 0 |
1792295 | 1792295 | 2021-10-07 | Banner | Nebraska | 31007 | 48 | 0 |
1769629 | 1769629 | 2021-09-30 | Sioux | Nebraska | 31165 | 48 | 1 |
1766397 | 1766397 | 2021-09-29 | Esmeralda | Nevada | 32009 | 48 | 0 |
1763148 | 1763148 | 2021-09-28 | Esmeralda | Nevada | 32009 | 48 | 0 |
1759857 | 1759857 | 2021-09-27 | Loup | Nebraska | 31115 | 48 | 0 |
1759899 | 1759899 | 2021-09-27 | Esmeralda | Nevada | 32009 | 48 | 0 |
1756651 | 1756651 | 2021-09-26 | Esmeralda | Nevada | 32009 | 48 | 0 |
1753403 | 1753403 | 2021-09-25 | Esmeralda | Nevada | 32009 | 48 | 0 |
1750155 | 1750155 | 2021-09-24 | Esmeralda | Nevada | 32009 | 48 | 0 |
1746905 | 1746905 | 2021-09-23 | Esmeralda | Nevada | 32009 | 48 | 0 |
1743656 | 1743656 | 2021-09-22 | Esmeralda | Nevada | 32009 | 48 | 0 |
1721496 | 1721496 | 2021-09-15 | Culebra | Puerto Rico | 72049 | 48 | |
1718248 | 1718248 | 2021-09-14 | Culebra | Puerto Rico | 72049 | 48 | |
1715000 | 1715000 | 2021-09-13 | Culebra | Puerto Rico | 72049 | 48 | |
1711754 | 1711754 | 2021-09-12 | Culebra | Puerto Rico | 72049 | 48 | |
1708507 | 1708507 | 2021-09-11 | Culebra | Puerto Rico | 72049 | 48 | |
1705260 | 1705260 | 2021-09-10 | Culebra | Puerto Rico | 72049 | 48 | |
1702010 | 1702010 | 2021-09-09 | Culebra | Puerto Rico | 72049 | 48 | |
1698761 | 1698761 | 2021-09-08 | Culebra | Puerto Rico | 72049 | 48 | |
1693429 | 1693429 | 2021-09-07 | Hinsdale | Colorado | 8053 | 48 | 0 |
1670503 | 1670503 | 2021-08-31 | Skagway Municipality | Alaska | 2230 | 48 | 0 |
1667256 | 1667256 | 2021-08-30 | Skagway Municipality | Alaska | 2230 | 48 | 0 |
1664008 | 1664008 | 2021-08-29 | Skagway Municipality | Alaska | 2230 | 48 | 0 |
1664192 | 1664192 | 2021-08-29 | Hinsdale | Colorado | 8053 | 48 | 0 |
1660760 | 1660760 | 2021-08-28 | Skagway Municipality | Alaska | 2230 | 48 | 0 |
1660944 | 1660944 | 2021-08-28 | Hinsdale | Colorado | 8053 | 48 | 0 |
1657512 | 1657512 | 2021-08-27 | Skagway Municipality | Alaska | 2230 | 48 | 0 |
1657696 | 1657696 | 2021-08-27 | Hinsdale | Colorado | 8053 | 48 | 0 |
1654264 | 1654264 | 2021-08-26 | Skagway Municipality | Alaska | 2230 | 48 | 0 |
1653682 | 1653682 | 2021-08-25 | Kenedy | Texas | 48261 | 48 | 2 |
1583008 | 1583008 | 2021-08-04 | San Juan | Colorado | 8111 | 48 | 0 |
1443398 | 1443398 | 2021-06-22 | San Juan | Colorado | 8111 | 48 | 0 |
1440153 | 1440153 | 2021-06-21 | San Juan | Colorado | 8111 | 48 | 0 |
1436906 | 1436906 | 2021-06-20 | San Juan | Colorado | 8111 | 48 | 0 |
1433659 | 1433659 | 2021-06-19 | San Juan | Colorado | 8111 | 48 | 0 |
1430413 | 1430413 | 2021-06-18 | San Juan | Colorado | 8111 | 48 | 0 |
1427168 | 1427168 | 2021-06-17 | San Juan | Colorado | 8111 | 48 | 0 |
1423923 | 1423923 | 2021-06-16 | San Juan | Colorado | 8111 | 48 | 0 |
1420675 | 1420675 | 2021-06-15 | San Juan | Colorado | 8111 | 48 | 0 |
1417430 | 1417430 | 2021-06-14 | San Juan | Colorado | 8111 | 48 | 0 |
1414184 | 1414184 | 2021-06-13 | San Juan | Colorado | 8111 | 48 | 0 |
1410939 | 1410939 | 2021-06-12 | San Juan | Colorado | 8111 | 48 | 0 |
1407694 | 1407694 | 2021-06-11 | San Juan | Colorado | 8111 | 48 | 0 |
1397958 | 1397958 | 2021-06-08 | San Juan | Colorado | 8111 | 48 | 0 |
1394711 | 1394711 | 2021-06-07 | San Juan | Colorado | 8111 | 48 | 0 |
1391466 | 1391466 | 2021-06-06 | San Juan | Colorado | 8111 | 48 | 0 |
1287584 | 1287584 | 2021-05-05 | San Juan | Colorado | 8111 | 48 | 0 |
1271350 | 1271350 | 2021-04-30 | San Juan | Colorado | 8111 | 48 | 0 |
1268103 | 1268103 | 2021-04-29 | San Juan | Colorado | 8111 | 48 | 0 |
1264856 | 1264856 | 2021-04-28 | San Juan | Colorado | 8111 | 48 | 0 |
1261609 | 1261609 | 2021-04-27 | San Juan | Colorado | 8111 | 48 | 0 |
1258362 | 1258362 | 2021-04-26 | San Juan | Colorado | 8111 | 48 | 0 |
1255115 | 1255115 | 2021-04-25 | San Juan | Colorado | 8111 | 48 | 0 |
1251868 | 1251868 | 2021-04-24 | San Juan | Colorado | 8111 | 48 | 0 |
1112162 | 1112162 | 2021-03-12 | Sierra | California | 6091 | 48 | 0 |
1108916 | 1108916 | 2021-03-11 | Sierra | California | 6091 | 48 | 0 |
1110405 | 1110405 | 2021-03-11 | Keya Paha | Nebraska | 31103 | 48 | 0 |
1105670 | 1105670 | 2021-03-10 | Sierra | California | 6091 | 48 | 0 |
1107159 | 1107159 | 2021-03-10 | Keya Paha | Nebraska | 31103 | 48 | 0 |
1102424 | 1102424 | 2021-03-09 | Sierra | California | 6091 | 48 | 0 |
1103913 | 1103913 | 2021-03-09 | Keya Paha | Nebraska | 31103 | 48 | 0 |
1099178 | 1099178 | 2021-03-08 | Sierra | California | 6091 | 48 | 0 |
1100667 | 1100667 | 2021-03-08 | Keya Paha | Nebraska | 31103 | 48 | 0 |
1095930 | 1095930 | 2021-03-07 | Sierra | California | 6091 | 48 | 0 |
1097420 | 1097420 | 2021-03-07 | Keya Paha | Nebraska | 31103 | 48 | 0 |
1092684 | 1092684 | 2021-03-06 | Sierra | California | 6091 | 48 | 0 |
1094173 | 1094173 | 2021-03-06 | Keya Paha | Nebraska | 31103 | 48 | 0 |
1089438 | 1089438 | 2021-03-05 | Sierra | California | 6091 | 48 | 0 |
1090927 | 1090927 | 2021-03-05 | Keya Paha | Nebraska | 31103 | 48 | 0 |
1086193 | 1086193 | 2021-03-04 | Sierra | California | 6091 | 48 | 0 |
1087682 | 1087682 | 2021-03-04 | Keya Paha | Nebraska | 31103 | 48 | 0 |
1082947 | 1082947 | 2021-03-03 | Sierra | California | 6091 | 48 | 0 |
1079701 | 1079701 | 2021-03-02 | Sierra | California | 6091 | 48 | 0 |
1076456 | 1076456 | 2021-03-01 | Sierra | California | 6091 | 48 | 0 |
1073210 | 1073210 | 2021-02-28 | Sierra | California | 6091 | 48 | 0 |
1068208 | 1068208 | 2021-02-26 | Keya Paha | Nebraska | 31103 | 48 | 0 |
1064963 | 1064963 | 2021-02-25 | Keya Paha | Nebraska | 31103 | 48 | 0 |
1061719 | 1061719 | 2021-02-24 | Keya Paha | Nebraska | 31103 | 48 | 0 |
1050344 | 1050344 | 2021-02-21 | Petersburg Borough | Alaska | 2195 | 48 | 0 |
1047097 | 1047097 | 2021-02-20 | Petersburg Borough | Alaska | 2195 | 48 | 0 |
1043852 | 1043852 | 2021-02-19 | Petersburg Borough | Alaska | 2195 | 48 | 0 |
1037550 | 1037550 | 2021-02-17 | Jackson | Colorado | 8057 | 48 | 0 |
1034305 | 1034305 | 2021-02-16 | Jackson | Colorado | 8057 | 48 | 0 |
1031059 | 1031059 | 2021-02-15 | Jackson | Colorado | 8057 | 48 | 0 |
1027812 | 1027812 | 2021-02-14 | Jackson | Colorado | 8057 | 48 | 0 |
1024567 | 1024567 | 2021-02-13 | Jackson | Colorado | 8057 | 48 | 0 |
1021322 | 1021322 | 2021-02-12 | Jackson | Colorado | 8057 | 48 | 0 |
1022817 | 1022817 | 2021-02-12 | Eureka | Nevada | 32011 | 48 | 0 |
1018077 | 1018077 | 2021-02-11 | Jackson | Colorado | 8057 | 48 | 0 |
1019572 | 1019572 | 2021-02-11 | Eureka | Nevada | 32011 | 48 | 0 |
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);