ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
152 rows where cases = 3712 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 23
- Pennsylvania 22
- Virginia 12
- Nebraska 9
- Illinois 8
- Kentucky 8
- Alabama 7
- Mississippi 7
- Indiana 6
- North Carolina 6
- Missouri 5
- Tennessee 5
- Ohio 4
- Iowa 3
- Michigan 3
- New York 3
- Arkansas 2
- Florida 2
- Georgia 2
- Minnesota 2
- North Dakota 2
- South Dakota 2
- Colorado 1
- Louisiana 1
- Maine 1
- New Mexico 1
- Oklahoma 1
- Puerto Rico 1
- South Carolina 1
- Utah 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2463372 | 2463372 | 2022-05-01 | Zapata | Texas | 48505 | 3712 | 55 |
2440695 | 2440695 | 2022-04-24 | King William | Virginia | 51101 | 3712 | 42 |
2437439 | 2437439 | 2022-04-23 | King William | Virginia | 51101 | 3712 | 42 |
2434183 | 2434183 | 2022-04-22 | King William | Virginia | 51101 | 3712 | 42 |
2405831 | 2405831 | 2022-04-14 | Wabash | Illinois | 17185 | 3712 | 31 |
2396066 | 2396066 | 2022-04-11 | Wabash | Illinois | 17185 | 3712 | 31 |
2391644 | 2391644 | 2022-04-09 | Madison | Texas | 48313 | 3712 | 54 |
2376535 | 2376535 | 2022-04-05 | Wabash | Illinois | 17185 | 3712 | 31 |
2378847 | 2378847 | 2022-04-05 | Manassas Park city | Virginia | 51685 | 3712 | 25 |
2375593 | 2375593 | 2022-04-04 | Manassas Park city | Virginia | 51685 | 3712 | 25 |
2372341 | 2372341 | 2022-04-03 | Manassas Park city | Virginia | 51685 | 3712 | 25 |
2369088 | 2369088 | 2022-04-02 | Manassas Park city | Virginia | 51685 | 3712 | 25 |
2365835 | 2365835 | 2022-04-01 | Manassas Park city | Virginia | 51685 | 3712 | 25 |
2350511 | 2350511 | 2022-03-28 | Wabash | Illinois | 17185 | 3712 | 30 |
2346600 | 2346600 | 2022-03-27 | Lamar | Alabama | 1075 | 3712 | 63 |
2347626 | 2347626 | 2022-03-27 | Larue | Kentucky | 21123 | 3712 | 69 |
2343347 | 2343347 | 2022-03-26 | Lamar | Alabama | 1075 | 3712 | 63 |
2344373 | 2344373 | 2022-03-26 | Larue | Kentucky | 21123 | 3712 | 69 |
2340094 | 2340094 | 2022-03-25 | Lamar | Alabama | 1075 | 3712 | 63 |
2341120 | 2341120 | 2022-03-25 | Larue | Kentucky | 21123 | 3712 | 69 |
2337867 | 2337867 | 2022-03-24 | Larue | Kentucky | 21123 | 3712 | 69 |
2334245 | 2334245 | 2022-03-23 | Wabash | Illinois | 17185 | 3712 | 30 |
2334613 | 2334613 | 2022-03-23 | Larue | Kentucky | 21123 | 3712 | 69 |
2331359 | 2331359 | 2022-03-22 | Larue | Kentucky | 21123 | 3712 | 69 |
2328107 | 2328107 | 2022-03-21 | Larue | Kentucky | 21123 | 3712 | 69 |
2247244 | 2247244 | 2022-02-24 | Bates | Missouri | 29013 | 3712 | 82 |
2239379 | 2239379 | 2022-02-22 | Howard | Arkansas | 5061 | 3712 | 47 |
2221712 | 2221712 | 2022-02-16 | Polk | North Carolina | 37149 | 3712 | 49 |
2215210 | 2215210 | 2022-02-14 | Polk | North Carolina | 37149 | 3712 | 49 |
2196984 | 2196984 | 2022-02-09 | Crenshaw | Alabama | 1041 | 3712 | 84 |
2198083 | 2198083 | 2022-02-09 | Webster | Kentucky | 21233 | 3712 | 46 |
2133866 | 2133866 | 2022-01-20 | Northampton | North Carolina | 37131 | 3712 | 66 |
2107485 | 2107485 | 2022-01-12 | Texas | Missouri | 29215 | 3712 | 76 |
2097553 | 2097553 | 2022-01-09 | Clay | Mississippi | 28025 | 3712 | 78 |
2094301 | 2094301 | 2022-01-08 | Clay | Mississippi | 28025 | 3712 | 78 |
2091049 | 2091049 | 2022-01-07 | Clay | Mississippi | 28025 | 3712 | 78 |
2059795 | 2059795 | 2021-12-28 | Deaf Smith | Texas | 48117 | 3712 | 98 |
2055610 | 2055610 | 2021-12-27 | Saunders | Nebraska | 31155 | 3712 | 23 |
2056901 | 2056901 | 2021-12-27 | Scott | Virginia | 51169 | 3712 | 89 |
2052360 | 2052360 | 2021-12-26 | Saunders | Nebraska | 31155 | 3712 | 23 |
2049110 | 2049110 | 2021-12-25 | Saunders | Nebraska | 31155 | 3712 | 23 |
2045860 | 2045860 | 2021-12-24 | Saunders | Nebraska | 31155 | 3712 | 23 |
2042610 | 2042610 | 2021-12-23 | Saunders | Nebraska | 31155 | 3712 | 23 |
2043745 | 2043745 | 2021-12-23 | Carbon | Utah | 49007 | 3712 | 41 |
2019387 | 2019387 | 2021-12-16 | Iosco | Michigan | 26069 | 3712 | 112 |
2015984 | 2015984 | 2021-12-15 | Assumption | Louisiana | 22007 | 3712 | 57 |
2016137 | 2016137 | 2021-12-15 | Iosco | Michigan | 26069 | 3712 | 112 |
2017570 | 2017570 | 2021-12-15 | Gillespie | Texas | 48171 | 3712 | 82 |
2017631 | 2017631 | 2021-12-15 | Limestone | Texas | 48293 | 3712 | 111 |
2014381 | 2014381 | 2021-12-14 | Limestone | Texas | 48293 | 3712 | 111 |
1995809 | 1995809 | 2021-12-09 | Grady | Georgia | 13131 | 3712 | 92 |
1992105 | 1992105 | 2021-12-08 | Barbour | Alabama | 1005 | 3712 | 80 |
1915777 | 1915777 | 2021-11-14 | Cass | Nebraska | 31025 | 3712 | 21 |
1912527 | 1912527 | 2021-11-13 | Cass | Nebraska | 31025 | 3712 | 21 |
1909277 | 1909277 | 2021-11-12 | Cass | Nebraska | 31025 | 3712 | 21 |
1851586 | 1851586 | 2021-10-25 | Davison | South Dakota | 46035 | 3712 | 70 |
1793597 | 1793597 | 2021-10-07 | Gloucester | Virginia | 51073 | 3712 | 64 |
1763944 | 1763944 | 2021-09-28 | Haywood | Tennessee | 47075 | 3712 | 70 |
1750267 | 1750267 | 2021-09-24 | Orleans | New York | 36073 | 3712 | 84 |
1737473 | 1737473 | 2021-09-20 | Fayette | Ohio | 39047 | 3712 | 52 |
1704507 | 1704507 | 2021-09-10 | Stoddard | Missouri | 29207 | 3712 | 57 |
1697180 | 1697180 | 2021-09-08 | Scott | Indiana | 18143 | 3712 | 64 |
1667311 | 1667311 | 2021-08-30 | Jackson | Arkansas | 5067 | 3712 | 41 |
1669770 | 1669770 | 2021-08-30 | Scott | Tennessee | 47151 | 3712 | 50 |
1652263 | 1652263 | 2021-08-25 | Carlton | Minnesota | 27017 | 3712 | 59 |
1629681 | 1629681 | 2021-08-18 | Yazoo | Mississippi | 28163 | 3712 | 80 |
1619945 | 1619945 | 2021-08-15 | Barry | Missouri | 29009 | 3712 | 51 |
1609442 | 1609442 | 2021-08-12 | Jefferson | Indiana | 18077 | 3712 | 88 |
1587152 | 1587152 | 2021-08-05 | Oxford | Maine | 23017 | 3712 | 70 |
1572974 | 1572974 | 2021-08-01 | Clarke | Alabama | 1025 | 3712 | 63 |
1523284 | 1523284 | 2021-07-16 | Clinton | Pennsylvania | 42035 | 3712 | 68 |
1520036 | 1520036 | 2021-07-15 | Clinton | Pennsylvania | 42035 | 3712 | 68 |
1516788 | 1516788 | 2021-07-14 | Clinton | Pennsylvania | 42035 | 3712 | 68 |
1513541 | 1513541 | 2021-07-13 | Clinton | Pennsylvania | 42035 | 3712 | 68 |
1510295 | 1510295 | 2021-07-12 | Clinton | Pennsylvania | 42035 | 3712 | 68 |
1507048 | 1507048 | 2021-07-11 | Clinton | Pennsylvania | 42035 | 3712 | 68 |
1503802 | 1503802 | 2021-07-10 | Clinton | Pennsylvania | 42035 | 3712 | 68 |
1500556 | 1500556 | 2021-07-09 | Clinton | Pennsylvania | 42035 | 3712 | 68 |
1497310 | 1497310 | 2021-07-08 | Clinton | Pennsylvania | 42035 | 3712 | 67 |
1494063 | 1494063 | 2021-07-07 | Clinton | Pennsylvania | 42035 | 3712 | 67 |
1490816 | 1490816 | 2021-07-06 | Clinton | Pennsylvania | 42035 | 3712 | 67 |
1487569 | 1487569 | 2021-07-05 | Clinton | Pennsylvania | 42035 | 3712 | 67 |
1484322 | 1484322 | 2021-07-04 | Clinton | Pennsylvania | 42035 | 3712 | 67 |
1481076 | 1481076 | 2021-07-03 | Clinton | Pennsylvania | 42035 | 3712 | 67 |
1477829 | 1477829 | 2021-07-02 | Clinton | Pennsylvania | 42035 | 3712 | 67 |
1474583 | 1474583 | 2021-07-01 | Clinton | Pennsylvania | 42035 | 3712 | 67 |
1471337 | 1471337 | 2021-06-30 | Clinton | Pennsylvania | 42035 | 3712 | 67 |
1468092 | 1468092 | 2021-06-29 | Clinton | Pennsylvania | 42035 | 3712 | 67 |
1464847 | 1464847 | 2021-06-28 | Clinton | Pennsylvania | 42035 | 3712 | 67 |
1461602 | 1461602 | 2021-06-27 | Clinton | Pennsylvania | 42035 | 3712 | 67 |
1448876 | 1448876 | 2021-06-23 | Carroll | Tennessee | 47017 | 3712 | 83 |
1445631 | 1445631 | 2021-06-22 | Carroll | Tennessee | 47017 | 3712 | 83 |
1402735 | 1402735 | 2021-06-09 | Rio Arriba | New Mexico | 35039 | 3712 | 76 |
1329791 | 1329791 | 2021-05-18 | Summit | Colorado | 8117 | 3712 | 8 |
1320488 | 1320488 | 2021-05-15 | Jasper | Indiana | 18073 | 3712 | 50 |
1299869 | 1299869 | 2021-05-08 | Titus | Texas | 48449 | 3712 | 83 |
1295848 | 1295848 | 2021-05-07 | Clinton | Ohio | 39027 | 3712 | 63 |
1293586 | 1293586 | 2021-05-06 | York | Virginia | 51199 | 3712 | 52 |
1286708 | 1286708 | 2021-05-04 | Cooke | Texas | 48097 | 3712 | 72 |
1275147 | 1275147 | 2021-05-01 | Lee | Iowa | 19111 | 3712 | 55 |
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);