ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,877 rows where cases = 38 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 192
- Nebraska 168
- Nevada 127
- Georgia 125
- Kentucky 124
- Kansas 115
- Michigan 110
- Puerto Rico 106
- Virginia 99
- Missouri 89
- West Virginia 88
- Iowa 85
- North Dakota 84
- Indiana 71
- Wisconsin 70
- Illinois 65
- Colorado 62
- South Dakota 62
- Arkansas 60
- Wyoming 57
- North Carolina 56
- Pennsylvania 56
- Utah 54
- Mississippi 53
- Ohio 52
- Minnesota 51
- Tennessee 50
- Oklahoma 47
- Idaho 45
- Alaska 43
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2022245 | 2022245 | 2021-12-17 | Unknown | Iowa | 38 | 0 | |
2018994 | 2018994 | 2021-12-16 | Unknown | Iowa | 38 | 0 | |
2015744 | 2015744 | 2021-12-15 | Unknown | Iowa | 38 | 0 | |
1984407 | 1984407 | 2021-12-05 | Unknown | North Dakota | 38 | 38 | |
1981157 | 1981157 | 2021-12-04 | Unknown | North Dakota | 38 | 38 | |
1977907 | 1977907 | 2021-12-03 | Unknown | North Dakota | 38 | 38 | |
1974657 | 1974657 | 2021-12-02 | Unknown | North Dakota | 38 | 38 | |
1971408 | 1971408 | 2021-12-01 | Unknown | North Dakota | 38 | 38 | |
1968158 | 1968158 | 2021-11-30 | Unknown | North Dakota | 38 | 38 | |
1964907 | 1964907 | 2021-11-29 | Unknown | North Dakota | 38 | 38 | |
1961655 | 1961655 | 2021-11-28 | Unknown | North Dakota | 38 | 38 | |
1958404 | 1958404 | 2021-11-27 | Unknown | North Dakota | 38 | 38 | |
1955153 | 1955153 | 2021-11-26 | Unknown | North Dakota | 38 | 38 | |
1951902 | 1951902 | 2021-11-25 | Unknown | North Dakota | 38 | 38 | |
1948651 | 1948651 | 2021-11-24 | Unknown | North Dakota | 38 | 38 | |
1945400 | 1945400 | 2021-11-23 | Unknown | North Dakota | 38 | 38 | |
1854031 | 1854031 | 2021-10-26 | Blaine | Nebraska | 31009 | 38 | 0 |
1855276 | 1855276 | 2021-10-26 | Unknown | Vermont | 38 | 0 | |
1850782 | 1850782 | 2021-10-25 | Blaine | Nebraska | 31009 | 38 | 0 |
1847532 | 1847532 | 2021-10-24 | Blaine | Nebraska | 31009 | 38 | 0 |
1844282 | 1844282 | 2021-10-23 | Blaine | Nebraska | 31009 | 38 | 0 |
1841032 | 1841032 | 2021-10-22 | Blaine | Nebraska | 31009 | 38 | 0 |
1837783 | 1837783 | 2021-10-21 | Blaine | Nebraska | 31009 | 38 | 0 |
1834534 | 1834534 | 2021-10-20 | Blaine | Nebraska | 31009 | 38 | 0 |
1831285 | 1831285 | 2021-10-19 | Blaine | Nebraska | 31009 | 38 | 0 |
1828036 | 1828036 | 2021-10-18 | Blaine | Nebraska | 31009 | 38 | 0 |
1824787 | 1824787 | 2021-10-17 | Blaine | Nebraska | 31009 | 38 | 0 |
1821538 | 1821538 | 2021-10-16 | Blaine | Nebraska | 31009 | 38 | 0 |
1818289 | 1818289 | 2021-10-15 | Blaine | Nebraska | 31009 | 38 | 0 |
1815040 | 1815040 | 2021-10-14 | Blaine | Nebraska | 31009 | 38 | 0 |
1811792 | 1811792 | 2021-10-13 | Blaine | Nebraska | 31009 | 38 | 0 |
1808543 | 1808543 | 2021-10-12 | Blaine | Nebraska | 31009 | 38 | 0 |
1805292 | 1805292 | 2021-10-11 | Blaine | Nebraska | 31009 | 38 | 0 |
1802043 | 1802043 | 2021-10-10 | Blaine | Nebraska | 31009 | 38 | 0 |
1798794 | 1798794 | 2021-10-09 | Blaine | Nebraska | 31009 | 38 | 0 |
1795545 | 1795545 | 2021-10-08 | Blaine | Nebraska | 31009 | 38 | 0 |
1792296 | 1792296 | 2021-10-07 | Blaine | Nebraska | 31009 | 38 | 0 |
1789047 | 1789047 | 2021-10-06 | Blaine | Nebraska | 31009 | 38 | 0 |
1750434 | 1750434 | 2021-09-24 | Slope | North Dakota | 38087 | 38 | 0 |
1628458 | 1628458 | 2021-08-18 | Hinsdale | Colorado | 8053 | 38 | 0 |
1625211 | 1625211 | 2021-08-17 | Hinsdale | Colorado | 8053 | 38 | 0 |
1621964 | 1621964 | 2021-08-16 | Hinsdale | Colorado | 8053 | 38 | 0 |
1562232 | 1562232 | 2021-07-28 | Wheeler | Oregon | 41069 | 38 | 1 |
1516263 | 1516263 | 2021-07-14 | Unknown | Nebraska | 38 | 0 | |
1509781 | 1509781 | 2021-07-12 | Esmeralda | Nevada | 32009 | 38 | 0 |
1506535 | 1506535 | 2021-07-11 | Esmeralda | Nevada | 32009 | 38 | 0 |
1503289 | 1503289 | 2021-07-10 | Esmeralda | Nevada | 32009 | 38 | 0 |
1500043 | 1500043 | 2021-07-09 | Esmeralda | Nevada | 32009 | 38 | 0 |
1496797 | 1496797 | 2021-07-08 | Esmeralda | Nevada | 32009 | 38 | 0 |
1493550 | 1493550 | 2021-07-07 | Esmeralda | Nevada | 32009 | 38 | 0 |
1490303 | 1490303 | 2021-07-06 | Esmeralda | Nevada | 32009 | 38 | 0 |
1487056 | 1487056 | 2021-07-05 | Esmeralda | Nevada | 32009 | 38 | 0 |
1483810 | 1483810 | 2021-07-04 | Esmeralda | Nevada | 32009 | 38 | 0 |
1480564 | 1480564 | 2021-07-03 | Esmeralda | Nevada | 32009 | 38 | 0 |
1477317 | 1477317 | 2021-07-02 | Esmeralda | Nevada | 32009 | 38 | 0 |
1474071 | 1474071 | 2021-07-01 | Esmeralda | Nevada | 32009 | 38 | 0 |
1470825 | 1470825 | 2021-06-30 | Esmeralda | Nevada | 32009 | 38 | 0 |
1467580 | 1467580 | 2021-06-29 | Esmeralda | Nevada | 32009 | 38 | 0 |
1464335 | 1464335 | 2021-06-28 | Esmeralda | Nevada | 32009 | 38 | 0 |
1461090 | 1461090 | 2021-06-27 | Esmeralda | Nevada | 32009 | 38 | 0 |
1457845 | 1457845 | 2021-06-26 | Esmeralda | Nevada | 32009 | 38 | 0 |
1454600 | 1454600 | 2021-06-25 | Esmeralda | Nevada | 32009 | 38 | 0 |
1451355 | 1451355 | 2021-06-24 | Esmeralda | Nevada | 32009 | 38 | 0 |
1448109 | 1448109 | 2021-06-23 | Esmeralda | Nevada | 32009 | 38 | 0 |
1444864 | 1444864 | 2021-06-22 | Esmeralda | Nevada | 32009 | 38 | 0 |
1441619 | 1441619 | 2021-06-21 | Esmeralda | Nevada | 32009 | 38 | 0 |
1438373 | 1438373 | 2021-06-20 | Esmeralda | Nevada | 32009 | 38 | 0 |
1435126 | 1435126 | 2021-06-19 | Esmeralda | Nevada | 32009 | 38 | 0 |
1431879 | 1431879 | 2021-06-18 | Esmeralda | Nevada | 32009 | 38 | 0 |
1428634 | 1428634 | 2021-06-17 | Esmeralda | Nevada | 32009 | 38 | 0 |
1425389 | 1425389 | 2021-06-16 | Esmeralda | Nevada | 32009 | 38 | 0 |
1422141 | 1422141 | 2021-06-15 | Esmeralda | Nevada | 32009 | 38 | 0 |
1418896 | 1418896 | 2021-06-14 | Esmeralda | Nevada | 32009 | 38 | 0 |
1415651 | 1415651 | 2021-06-13 | Esmeralda | Nevada | 32009 | 38 | 0 |
1412405 | 1412405 | 2021-06-12 | Esmeralda | Nevada | 32009 | 38 | 0 |
1409160 | 1409160 | 2021-06-11 | Esmeralda | Nevada | 32009 | 38 | 0 |
1405915 | 1405915 | 2021-06-10 | Esmeralda | Nevada | 32009 | 38 | 0 |
1402669 | 1402669 | 2021-06-09 | Esmeralda | Nevada | 32009 | 38 | 0 |
1399424 | 1399424 | 2021-06-08 | Esmeralda | Nevada | 32009 | 38 | 0 |
1396178 | 1396178 | 2021-06-07 | Esmeralda | Nevada | 32009 | 38 | 0 |
1392932 | 1392932 | 2021-06-06 | Esmeralda | Nevada | 32009 | 38 | 0 |
1389687 | 1389687 | 2021-06-05 | Esmeralda | Nevada | 32009 | 38 | 0 |
1386442 | 1386442 | 2021-06-04 | Esmeralda | Nevada | 32009 | 38 | 0 |
1383197 | 1383197 | 2021-06-03 | Esmeralda | Nevada | 32009 | 38 | 0 |
1379951 | 1379951 | 2021-06-02 | Esmeralda | Nevada | 32009 | 38 | 0 |
1376706 | 1376706 | 2021-06-01 | Esmeralda | Nevada | 32009 | 38 | 0 |
1373460 | 1373460 | 2021-05-31 | Esmeralda | Nevada | 32009 | 38 | 0 |
1370215 | 1370215 | 2021-05-30 | Esmeralda | Nevada | 32009 | 38 | 0 |
1366969 | 1366969 | 2021-05-29 | Esmeralda | Nevada | 32009 | 38 | 0 |
1363723 | 1363723 | 2021-05-28 | Esmeralda | Nevada | 32009 | 38 | 0 |
1360477 | 1360477 | 2021-05-27 | Esmeralda | Nevada | 32009 | 38 | 0 |
1357231 | 1357231 | 2021-05-26 | Esmeralda | Nevada | 32009 | 38 | 0 |
1353985 | 1353985 | 2021-05-25 | Esmeralda | Nevada | 32009 | 38 | 0 |
1350739 | 1350739 | 2021-05-24 | Esmeralda | Nevada | 32009 | 38 | 0 |
1347493 | 1347493 | 2021-05-23 | Esmeralda | Nevada | 32009 | 38 | 0 |
1344245 | 1344245 | 2021-05-22 | Esmeralda | Nevada | 32009 | 38 | 0 |
1340997 | 1340997 | 2021-05-21 | Esmeralda | Nevada | 32009 | 38 | 0 |
1337749 | 1337749 | 2021-05-20 | Esmeralda | Nevada | 32009 | 38 | 0 |
1334502 | 1334502 | 2021-05-19 | Esmeralda | Nevada | 32009 | 38 | 0 |
1331255 | 1331255 | 2021-05-18 | Esmeralda | Nevada | 32009 | 38 | 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);