ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
480 rows where cases = 744 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Nebraska 39
- Texas 38
- Georgia 27
- Kansas 25
- Kentucky 25
- Montana 21
- Missouri 19
- North Carolina 14
- South Dakota 14
- Arkansas 13
- Virginia 13
- Alabama 12
- Louisiana 12
- New Mexico 12
- Oklahoma 12
- Iowa 11
- Michigan 11
- Minnesota 11
- Tennessee 11
- Indiana 10
- Mississippi 9
- California 8
- Colorado 8
- North Dakota 8
- Puerto Rico 8
- Wisconsin 8
- Wyoming 8
- Illinois 7
- Ohio 7
- West Virginia 7
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2468687 | 2468687 | 2022-05-03 | Chase | Nebraska | 31029 | 744 | 7 |
2465431 | 2465431 | 2022-05-02 | Chase | Nebraska | 31029 | 744 | 7 |
2462176 | 2462176 | 2022-05-01 | Chase | Nebraska | 31029 | 744 | 7 |
2458920 | 2458920 | 2022-04-30 | Chase | Nebraska | 31029 | 744 | 7 |
2455664 | 2455664 | 2022-04-29 | Chase | Nebraska | 31029 | 744 | 7 |
2452408 | 2452408 | 2022-04-28 | Chase | Nebraska | 31029 | 744 | 7 |
2449152 | 2449152 | 2022-04-27 | Chase | Nebraska | 31029 | 744 | 7 |
2445895 | 2445895 | 2022-04-26 | Chase | Nebraska | 31029 | 744 | 7 |
2442640 | 2442640 | 2022-04-25 | Chase | Nebraska | 31029 | 744 | 7 |
2439384 | 2439384 | 2022-04-24 | Chase | Nebraska | 31029 | 744 | 7 |
2436128 | 2436128 | 2022-04-23 | Chase | Nebraska | 31029 | 744 | 7 |
2432872 | 2432872 | 2022-04-22 | Chase | Nebraska | 31029 | 744 | 7 |
2429616 | 2429616 | 2022-04-21 | Chase | Nebraska | 31029 | 744 | 7 |
2426360 | 2426360 | 2022-04-20 | Chase | Nebraska | 31029 | 744 | 7 |
2423104 | 2423104 | 2022-04-19 | Chase | Nebraska | 31029 | 744 | 7 |
2419847 | 2419847 | 2022-04-18 | Chase | Nebraska | 31029 | 744 | 7 |
2416592 | 2416592 | 2022-04-17 | Chase | Nebraska | 31029 | 744 | 7 |
2413336 | 2413336 | 2022-04-16 | Chase | Nebraska | 31029 | 744 | 7 |
2410080 | 2410080 | 2022-04-15 | Chase | Nebraska | 31029 | 744 | 7 |
2406824 | 2406824 | 2022-04-14 | Chase | Nebraska | 31029 | 744 | 7 |
2403568 | 2403568 | 2022-04-13 | Chase | Nebraska | 31029 | 744 | 7 |
2376725 | 2376725 | 2022-04-05 | Unknown | Iowa | 744 | 0 | |
2358076 | 2358076 | 2022-03-30 | Stanton | Nebraska | 31167 | 744 | 11 |
2354754 | 2354754 | 2022-03-29 | Chase | Nebraska | 31029 | 744 | 6 |
2354823 | 2354823 | 2022-03-29 | Stanton | Nebraska | 31167 | 744 | 11 |
2351501 | 2351501 | 2022-03-28 | Chase | Nebraska | 31029 | 744 | 6 |
2338490 | 2338490 | 2022-03-24 | Chase | Nebraska | 31029 | 744 | 6 |
2286521 | 2286521 | 2022-03-08 | Valley | Nebraska | 31175 | 744 | 6 |
2270258 | 2270258 | 2022-03-03 | Valley | Nebraska | 31175 | 744 | 6 |
2263754 | 2263754 | 2022-03-01 | Valley | Nebraska | 31175 | 744 | 6 |
2260498 | 2260498 | 2022-02-28 | Stanton | Nebraska | 31167 | 744 | 11 |
2260577 | 2260577 | 2022-02-28 | Mora | New Mexico | 35033 | 744 | 16 |
2215249 | 2215249 | 2022-02-14 | Eddy | North Dakota | 38027 | 744 | 6 |
2188867 | 2188867 | 2022-02-06 | Sweet Grass | Montana | 30097 | 744 | 8 |
2189671 | 2189671 | 2022-02-06 | Bennett | South Dakota | 46007 | 744 | 11 |
2185614 | 2185614 | 2022-02-05 | Sweet Grass | Montana | 30097 | 744 | 8 |
2186418 | 2186418 | 2022-02-05 | Bennett | South Dakota | 46007 | 744 | 11 |
2182362 | 2182362 | 2022-02-04 | Sweet Grass | Montana | 30097 | 744 | 8 |
2183166 | 2183166 | 2022-02-04 | Bennett | South Dakota | 46007 | 744 | 11 |
2170534 | 2170534 | 2022-01-31 | Sutton | Texas | 48435 | 744 | 11 |
2164524 | 2164524 | 2022-01-30 | Unknown | Alaska | 744 | 1 | |
2161269 | 2161269 | 2022-01-29 | Unknown | Alaska | 744 | 1 | |
2158013 | 2158013 | 2022-01-28 | Unknown | Alaska | 744 | 1 | |
2155656 | 2155656 | 2022-01-27 | Sheridan | Kansas | 20179 | 744 | 18 |
2152403 | 2152403 | 2022-01-26 | Sheridan | Kansas | 20179 | 744 | 18 |
2149144 | 2149144 | 2022-01-25 | Rush | Kansas | 20165 | 744 | 17 |
2145892 | 2145892 | 2022-01-24 | Rush | Kansas | 20165 | 744 | 17 |
2124004 | 2124004 | 2022-01-17 | Hamilton | New York | 36041 | 744 | 4 |
2118299 | 2118299 | 2022-01-15 | Coke | Texas | 48081 | 744 | 18 |
2101861 | 2101861 | 2022-01-10 | Edmunds | South Dakota | 46045 | 744 | 14 |
2098838 | 2098838 | 2022-01-09 | Goliad | Texas | 48175 | 744 | 28 |
2089942 | 2089942 | 2022-01-07 | Unknown | Delaware | 744 | 0 | |
2077054 | 2077054 | 2022-01-03 | Echols | Georgia | 13101 | 744 | 11 |
2078349 | 2078349 | 2022-01-03 | Nuckolls | Nebraska | 31129 | 744 | 13 |
2079646 | 2079646 | 2022-01-03 | Rappahannock | Virginia | 51157 | 744 | 7 |
2073803 | 2073803 | 2022-01-02 | Echols | Georgia | 13101 | 744 | 11 |
2070552 | 2070552 | 2022-01-01 | Echols | Georgia | 13101 | 744 | 11 |
2067301 | 2067301 | 2021-12-31 | Echols | Georgia | 13101 | 744 | 11 |
2062206 | 2062206 | 2021-12-29 | Union | New Mexico | 35059 | 744 | 12 |
2033446 | 2033446 | 2021-12-20 | Adjuntas | Puerto Rico | 72001 | 744 | |
2011031 | 2011031 | 2021-12-13 | Concho | Texas | 48095 | 744 | 10 |
2007780 | 2007780 | 2021-12-12 | Concho | Texas | 48095 | 744 | 10 |
2004529 | 2004529 | 2021-12-11 | Concho | Texas | 48095 | 744 | 10 |
2001278 | 2001278 | 2021-12-10 | Concho | Texas | 48095 | 744 | 10 |
1967108 | 1967108 | 2021-11-30 | Ballard | Kentucky | 21007 | 744 | 22 |
1960120 | 1960120 | 2021-11-28 | Talbot | Georgia | 13263 | 744 | 28 |
1962310 | 1962310 | 2021-11-28 | Garza | Texas | 48169 | 744 | 22 |
1956869 | 1956869 | 2021-11-27 | Talbot | Georgia | 13263 | 744 | 28 |
1959059 | 1959059 | 2021-11-27 | Garza | Texas | 48169 | 744 | 22 |
1953618 | 1953618 | 2021-11-26 | Talbot | Georgia | 13263 | 744 | 28 |
1955808 | 1955808 | 2021-11-26 | Garza | Texas | 48169 | 744 | 22 |
1950367 | 1950367 | 2021-11-25 | Talbot | Georgia | 13263 | 744 | 28 |
1952557 | 1952557 | 2021-11-25 | Garza | Texas | 48169 | 744 | 22 |
1947116 | 1947116 | 2021-11-24 | Talbot | Georgia | 13263 | 744 | 28 |
1949306 | 1949306 | 2021-11-24 | Garza | Texas | 48169 | 744 | 22 |
1944301 | 1944301 | 2021-11-23 | Meade | Kansas | 20119 | 744 | 14 |
1946055 | 1946055 | 2021-11-23 | Garza | Texas | 48169 | 744 | 22 |
1941051 | 1941051 | 2021-11-22 | Meade | Kansas | 20119 | 744 | 14 |
1937801 | 1937801 | 2021-11-21 | Meade | Kansas | 20119 | 744 | 14 |
1934551 | 1934551 | 2021-11-20 | Meade | Kansas | 20119 | 744 | 14 |
1931300 | 1931300 | 2021-11-19 | Meade | Kansas | 20119 | 744 | 14 |
1904646 | 1904646 | 2021-11-11 | Saguache | Colorado | 8109 | 744 | 8 |
1905967 | 1905967 | 2021-11-11 | Chouteau | Montana | 30015 | 744 | 8 |
1902718 | 1902718 | 2021-11-10 | Chouteau | Montana | 30015 | 744 | 8 |
1893851 | 1893851 | 2021-11-07 | Lyman | South Dakota | 46085 | 744 | 11 |
1890601 | 1890601 | 2021-11-06 | Lyman | South Dakota | 46085 | 744 | 11 |
1887351 | 1887351 | 2021-11-05 | Lyman | South Dakota | 46085 | 744 | 11 |
1876067 | 1876067 | 2021-11-02 | Ottawa | Kansas | 20143 | 744 | 13 |
1872818 | 1872818 | 2021-11-01 | Ottawa | Kansas | 20143 | 744 | 13 |
1854534 | 1854534 | 2021-10-26 | Greer | Oklahoma | 40055 | 744 | 25 |
1851285 | 1851285 | 2021-10-25 | Greer | Oklahoma | 40055 | 744 | 25 |
1848035 | 1848035 | 2021-10-24 | Greer | Oklahoma | 40055 | 744 | 25 |
1844785 | 1844785 | 2021-10-23 | Greer | Oklahoma | 40055 | 744 | 25 |
1841535 | 1841535 | 2021-10-22 | Greer | Oklahoma | 40055 | 744 | 25 |
1837051 | 1837051 | 2021-10-21 | Kearny | Kansas | 20093 | 744 | 12 |
1838286 | 1838286 | 2021-10-21 | Greer | Oklahoma | 40055 | 744 | 25 |
1839197 | 1839197 | 2021-10-21 | Skamania | Washington | 53059 | 744 | 6 |
1833802 | 1833802 | 2021-10-20 | Kearny | Kansas | 20093 | 744 | 12 |
1835037 | 1835037 | 2021-10-20 | Greer | Oklahoma | 40055 | 744 | 25 |
1824763 | 1824763 | 2021-10-17 | Pondera | Montana | 30073 | 744 | 4 |
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);