ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
949 rows where cases = 233 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 103
- Nebraska 61
- Georgia 52
- Kansas 50
- Colorado 46
- Virginia 45
- Kentucky 39
- Alaska 35
- Northern Mariana Islands 33
- Missouri 31
- North Dakota 27
- Ohio 27
- Indiana 24
- Mississippi 24
- Puerto Rico 23
- Arkansas 20
- Michigan 18
- North Carolina 18
- Illinois 17
- Oklahoma 17
- Idaho 16
- Tennessee 16
- Florida 15
- Iowa 15
- South Dakota 15
- Minnesota 14
- West Virginia 13
- Wisconsin 13
- Oregon 12
- California 11
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2486829 | 2486829 | 2022-05-09 | Mineral | Colorado | 8079 | 233 | 2 |
2483571 | 2483571 | 2022-05-08 | Mineral | Colorado | 8079 | 233 | 2 |
2480313 | 2480313 | 2022-05-07 | Mineral | Colorado | 8079 | 233 | 2 |
2477055 | 2477055 | 2022-05-06 | Mineral | Colorado | 8079 | 233 | 2 |
2473797 | 2473797 | 2022-05-05 | Mineral | Colorado | 8079 | 233 | 2 |
2470540 | 2470540 | 2022-05-04 | Mineral | Colorado | 8079 | 233 | 2 |
2467284 | 2467284 | 2022-05-03 | Mineral | Colorado | 8079 | 233 | 2 |
2464029 | 2464029 | 2022-05-02 | Mineral | Colorado | 8079 | 233 | 2 |
2460773 | 2460773 | 2022-05-01 | Mineral | Colorado | 8079 | 233 | 2 |
2457517 | 2457517 | 2022-04-30 | Mineral | Colorado | 8079 | 233 | 2 |
2454261 | 2454261 | 2022-04-29 | Mineral | Colorado | 8079 | 233 | 2 |
2451005 | 2451005 | 2022-04-28 | Mineral | Colorado | 8079 | 233 | 2 |
2447749 | 2447749 | 2022-04-27 | Mineral | Colorado | 8079 | 233 | 2 |
2444493 | 2444493 | 2022-04-26 | Mineral | Colorado | 8079 | 233 | 2 |
2441237 | 2441237 | 2022-04-25 | Mineral | Colorado | 8079 | 233 | 2 |
2437981 | 2437981 | 2022-04-24 | Mineral | Colorado | 8079 | 233 | 2 |
2434725 | 2434725 | 2022-04-23 | Mineral | Colorado | 8079 | 233 | 2 |
2431469 | 2431469 | 2022-04-22 | Mineral | Colorado | 8079 | 233 | 2 |
2428213 | 2428213 | 2022-04-21 | Mineral | Colorado | 8079 | 233 | 2 |
2424957 | 2424957 | 2022-04-20 | Mineral | Colorado | 8079 | 233 | 1 |
2361640 | 2361640 | 2022-03-31 | Tinian | Northern Mariana Islands | 69120 | 233 | 0 |
2358386 | 2358386 | 2022-03-30 | Tinian | Northern Mariana Islands | 69120 | 233 | 0 |
2355132 | 2355132 | 2022-03-29 | Tinian | Northern Mariana Islands | 69120 | 233 | 0 |
2351879 | 2351879 | 2022-03-28 | Tinian | Northern Mariana Islands | 69120 | 233 | 0 |
2348627 | 2348627 | 2022-03-27 | Tinian | Northern Mariana Islands | 69120 | 233 | 0 |
2345374 | 2345374 | 2022-03-26 | Tinian | Northern Mariana Islands | 69120 | 233 | 0 |
2342121 | 2342121 | 2022-03-25 | Tinian | Northern Mariana Islands | 69120 | 233 | 0 |
2338868 | 2338868 | 2022-03-24 | Tinian | Northern Mariana Islands | 69120 | 233 | 0 |
2335614 | 2335614 | 2022-03-23 | Tinian | Northern Mariana Islands | 69120 | 233 | 0 |
2332360 | 2332360 | 2022-03-22 | Tinian | Northern Mariana Islands | 69120 | 233 | 0 |
2329107 | 2329107 | 2022-03-21 | Tinian | Northern Mariana Islands | 69120 | 233 | 0 |
2325855 | 2325855 | 2022-03-20 | Tinian | Northern Mariana Islands | 69120 | 233 | 0 |
2322602 | 2322602 | 2022-03-19 | Tinian | Northern Mariana Islands | 69120 | 233 | 0 |
2319348 | 2319348 | 2022-03-18 | Tinian | Northern Mariana Islands | 69120 | 233 | 0 |
2316094 | 2316094 | 2022-03-17 | Tinian | Northern Mariana Islands | 69120 | 233 | 0 |
2312841 | 2312841 | 2022-03-16 | Tinian | Northern Mariana Islands | 69120 | 233 | 0 |
2309588 | 2309588 | 2022-03-15 | Tinian | Northern Mariana Islands | 69120 | 233 | 0 |
2306335 | 2306335 | 2022-03-14 | Tinian | Northern Mariana Islands | 69120 | 233 | 0 |
2303084 | 2303084 | 2022-03-13 | Tinian | Northern Mariana Islands | 69120 | 233 | 0 |
2299832 | 2299832 | 2022-03-12 | Tinian | Northern Mariana Islands | 69120 | 233 | 0 |
2296580 | 2296580 | 2022-03-11 | Tinian | Northern Mariana Islands | 69120 | 233 | 0 |
2293328 | 2293328 | 2022-03-10 | Tinian | Northern Mariana Islands | 69120 | 233 | 0 |
2290076 | 2290076 | 2022-03-09 | Tinian | Northern Mariana Islands | 69120 | 233 | 0 |
2286824 | 2286824 | 2022-03-08 | Tinian | Northern Mariana Islands | 69120 | 233 | 0 |
2283572 | 2283572 | 2022-03-07 | Tinian | Northern Mariana Islands | 69120 | 233 | 0 |
2280320 | 2280320 | 2022-03-06 | Tinian | Northern Mariana Islands | 69120 | 233 | 0 |
2277067 | 2277067 | 2022-03-05 | Tinian | Northern Mariana Islands | 69120 | 233 | 0 |
2273814 | 2273814 | 2022-03-04 | Tinian | Northern Mariana Islands | 69120 | 233 | 0 |
2270561 | 2270561 | 2022-03-03 | Tinian | Northern Mariana Islands | 69120 | 233 | 0 |
2267309 | 2267309 | 2022-03-02 | Tinian | Northern Mariana Islands | 69120 | 233 | 0 |
2264057 | 2264057 | 2022-03-01 | Tinian | Northern Mariana Islands | 69120 | 233 | 0 |
2260806 | 2260806 | 2022-02-28 | Tinian | Northern Mariana Islands | 69120 | 233 | 0 |
2151938 | 2151938 | 2022-01-26 | Taliaferro | Georgia | 13265 | 233 | 3 |
2146567 | 2146567 | 2022-01-24 | Prairie | Montana | 30079 | 233 | 3 |
2143917 | 2143917 | 2022-01-23 | Sherman | Oregon | 41055 | 233 | 3 |
2140662 | 2140662 | 2022-01-22 | Sherman | Oregon | 41055 | 233 | 3 |
2137406 | 2137406 | 2022-01-21 | Sherman | Oregon | 41055 | 233 | 3 |
2134152 | 2134152 | 2022-01-20 | Sherman | Oregon | 41055 | 233 | 3 |
2127862 | 2127862 | 2022-01-18 | Campbell | South Dakota | 46021 | 233 | 6 |
2107940 | 2107940 | 2022-01-12 | Unknown | Northern Mariana Islands | 233 | 2 | |
2086602 | 2086602 | 2022-01-06 | Sierra | California | 6091 | 233 | 0 |
2066598 | 2066598 | 2021-12-30 | Highland | Virginia | 51091 | 233 | 4 |
2036410 | 2036410 | 2021-12-21 | Sheridan | North Dakota | 38083 | 233 | 5 |
1972678 | 1972678 | 2021-12-02 | Haines Borough | Alaska | 2100 | 233 | 1 |
1969428 | 1969428 | 2021-12-01 | Haines Borough | Alaska | 2100 | 233 | 1 |
1972195 | 1972195 | 2021-12-01 | Stonewall | Texas | 48433 | 233 | 6 |
1966178 | 1966178 | 2021-11-30 | Haines Borough | Alaska | 2100 | 233 | 1 |
1968945 | 1968945 | 2021-11-30 | Stonewall | Texas | 48433 | 233 | 6 |
1962926 | 1962926 | 2021-11-29 | Haines Borough | Alaska | 2100 | 233 | 1 |
1965694 | 1965694 | 2021-11-29 | Stonewall | Texas | 48433 | 233 | 6 |
1962442 | 1962442 | 2021-11-28 | Stonewall | Texas | 48433 | 233 | 6 |
1959191 | 1959191 | 2021-11-27 | Stonewall | Texas | 48433 | 233 | 6 |
1955940 | 1955940 | 2021-11-26 | Stonewall | Texas | 48433 | 233 | 6 |
1951885 | 1951885 | 2021-11-25 | Oliver | North Dakota | 38065 | 233 | 3 |
1952689 | 1952689 | 2021-11-25 | Stonewall | Texas | 48433 | 233 | 6 |
1946850 | 1946850 | 2021-11-24 | Cheyenne | Colorado | 8017 | 233 | 7 |
1949438 | 1949438 | 2021-11-24 | Stonewall | Texas | 48433 | 233 | 6 |
1925614 | 1925614 | 2021-11-17 | Eureka | Nevada | 32011 | 233 | 1 |
1922207 | 1922207 | 2021-11-16 | Worth | Missouri | 29227 | 233 | 2 |
1919992 | 1919992 | 2021-11-15 | Briscoe | Texas | 48045 | 233 | 7 |
1916742 | 1916742 | 2021-11-14 | Briscoe | Texas | 48045 | 233 | 7 |
1913492 | 1913492 | 2021-11-13 | Briscoe | Texas | 48045 | 233 | 7 |
1910242 | 1910242 | 2021-11-12 | Briscoe | Texas | 48045 | 233 | 7 |
1906993 | 1906993 | 2021-11-11 | Briscoe | Texas | 48045 | 233 | 7 |
1903744 | 1903744 | 2021-11-10 | Briscoe | Texas | 48045 | 233 | 7 |
1900494 | 1900494 | 2021-11-09 | Briscoe | Texas | 48045 | 233 | 7 |
1897244 | 1897244 | 2021-11-08 | Briscoe | Texas | 48045 | 233 | 7 |
1893994 | 1893994 | 2021-11-07 | Briscoe | Texas | 48045 | 233 | 7 |
1890744 | 1890744 | 2021-11-06 | Briscoe | Texas | 48045 | 233 | 7 |
1872126 | 1872126 | 2021-11-01 | Kiowa | Colorado | 8061 | 233 | 4 |
1854034 | 1854034 | 2021-10-26 | Boyd | Nebraska | 31015 | 233 | 3 |
1850785 | 1850785 | 2021-10-25 | Boyd | Nebraska | 31015 | 233 | 3 |
1852002 | 1852002 | 2021-10-25 | Rich | Utah | 49033 | 233 | 0 |
1846795 | 1846795 | 2021-10-24 | Hodgeman | Kansas | 20083 | 233 | 10 |
1847535 | 1847535 | 2021-10-24 | Boyd | Nebraska | 31015 | 233 | 3 |
1843545 | 1843545 | 2021-10-23 | Hodgeman | Kansas | 20083 | 233 | 10 |
1844285 | 1844285 | 2021-10-23 | Boyd | Nebraska | 31015 | 233 | 3 |
1840295 | 1840295 | 2021-10-22 | Hodgeman | Kansas | 20083 | 233 | 10 |
1841035 | 1841035 | 2021-10-22 | Boyd | Nebraska | 31015 | 233 | 3 |
1836370 | 1836370 | 2021-10-21 | Dolores | Colorado | 8033 | 233 | 2 |
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);