ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,453 rows where cases = 108 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 160
- Virginia 84
- Idaho 74
- Montana 57
- Georgia 52
- Nebraska 51
- Iowa 44
- Missouri 44
- Oklahoma 44
- Kentucky 43
- South Dakota 42
- Kansas 39
- Indiana 38
- Minnesota 37
- Mississippi 37
- California 36
- Puerto Rico 36
- Colorado 35
- Michigan 34
- North Carolina 30
- Ohio 30
- Utah 29
- Illinois 28
- New York 27
- Washington 26
- Arkansas 21
- Tennessee 21
- Oregon 20
- New Mexico 19
- Pennsylvania 19
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2468772 | 2468772 | 2022-05-03 | Esmeralda | Nevada | 32009 | 108 | 3 |
2465516 | 2465516 | 2022-05-02 | Esmeralda | Nevada | 32009 | 108 | 3 |
2462261 | 2462261 | 2022-05-01 | Esmeralda | Nevada | 32009 | 108 | 3 |
2459005 | 2459005 | 2022-04-30 | Esmeralda | Nevada | 32009 | 108 | 3 |
2455749 | 2455749 | 2022-04-29 | Esmeralda | Nevada | 32009 | 108 | 3 |
2452493 | 2452493 | 2022-04-28 | Esmeralda | Nevada | 32009 | 108 | 3 |
2449237 | 2449237 | 2022-04-27 | Esmeralda | Nevada | 32009 | 108 | 3 |
2327618 | 2327618 | 2022-03-21 | Clark | Idaho | 16033 | 108 | 0 |
2324365 | 2324365 | 2022-03-20 | Clark | Idaho | 16033 | 108 | 0 |
2321111 | 2321111 | 2022-03-19 | Clark | Idaho | 16033 | 108 | 0 |
2317857 | 2317857 | 2022-03-18 | Clark | Idaho | 16033 | 108 | 0 |
2314604 | 2314604 | 2022-03-17 | Clark | Idaho | 16033 | 108 | 0 |
2311351 | 2311351 | 2022-03-16 | Clark | Idaho | 16033 | 108 | 0 |
2308098 | 2308098 | 2022-03-15 | Clark | Idaho | 16033 | 108 | 0 |
2304847 | 2304847 | 2022-03-14 | Clark | Idaho | 16033 | 108 | 0 |
2301595 | 2301595 | 2022-03-13 | Clark | Idaho | 16033 | 108 | 0 |
2298343 | 2298343 | 2022-03-12 | Clark | Idaho | 16033 | 108 | 0 |
2295091 | 2295091 | 2022-03-11 | Clark | Idaho | 16033 | 108 | 0 |
2291839 | 2291839 | 2022-03-10 | Clark | Idaho | 16033 | 108 | 0 |
2288587 | 2288587 | 2022-03-09 | Clark | Idaho | 16033 | 108 | 0 |
2285336 | 2285336 | 2022-03-08 | Clark | Idaho | 16033 | 108 | 0 |
2282084 | 2282084 | 2022-03-07 | Clark | Idaho | 16033 | 108 | 0 |
2278831 | 2278831 | 2022-03-06 | Clark | Idaho | 16033 | 108 | 0 |
2275578 | 2275578 | 2022-03-05 | Clark | Idaho | 16033 | 108 | 0 |
2272325 | 2272325 | 2022-03-04 | Clark | Idaho | 16033 | 108 | 0 |
2269073 | 2269073 | 2022-03-03 | Clark | Idaho | 16033 | 108 | 0 |
2265820 | 2265820 | 2022-03-02 | Clark | Idaho | 16033 | 108 | 0 |
2262569 | 2262569 | 2022-03-01 | Clark | Idaho | 16033 | 108 | 0 |
2259318 | 2259318 | 2022-02-28 | Clark | Idaho | 16033 | 108 | 0 |
2256067 | 2256067 | 2022-02-27 | Clark | Idaho | 16033 | 108 | 0 |
2252816 | 2252816 | 2022-02-26 | Clark | Idaho | 16033 | 108 | 0 |
2249565 | 2249565 | 2022-02-25 | Clark | Idaho | 16033 | 108 | 0 |
2246314 | 2246314 | 2022-02-24 | Clark | Idaho | 16033 | 108 | 0 |
2243063 | 2243063 | 2022-02-23 | Clark | Idaho | 16033 | 108 | 0 |
2239812 | 2239812 | 2022-02-22 | Clark | Idaho | 16033 | 108 | 0 |
2211694 | 2211694 | 2022-02-13 | Hooker | Nebraska | 31091 | 108 | 5 |
2208441 | 2208441 | 2022-02-12 | Hooker | Nebraska | 31091 | 108 | 5 |
2205188 | 2205188 | 2022-02-11 | Hooker | Nebraska | 31091 | 108 | 5 |
2201935 | 2201935 | 2022-02-10 | Hooker | Nebraska | 31091 | 108 | 5 |
2198681 | 2198681 | 2022-02-09 | Hooker | Nebraska | 31091 | 108 | 5 |
2195427 | 2195427 | 2022-02-08 | Hooker | Nebraska | 31091 | 108 | 5 |
2192173 | 2192173 | 2022-02-07 | Hooker | Nebraska | 31091 | 108 | 5 |
2188920 | 2188920 | 2022-02-06 | Hooker | Nebraska | 31091 | 108 | 5 |
2185667 | 2185667 | 2022-02-05 | Hooker | Nebraska | 31091 | 108 | 5 |
2182415 | 2182415 | 2022-02-04 | Hooker | Nebraska | 31091 | 108 | 5 |
2179163 | 2179163 | 2022-02-03 | Hooker | Nebraska | 31091 | 108 | 5 |
2175911 | 2175911 | 2022-02-02 | Hooker | Nebraska | 31091 | 108 | 5 |
2172658 | 2172658 | 2022-02-01 | Hooker | Nebraska | 31091 | 108 | 5 |
2172664 | 2172664 | 2022-02-01 | Keya Paha | Nebraska | 31103 | 108 | 0 |
2169405 | 2169405 | 2022-01-31 | Hooker | Nebraska | 31091 | 108 | 3 |
2169411 | 2169411 | 2022-01-31 | Keya Paha | Nebraska | 31103 | 108 | 0 |
2034933 | 2034933 | 2021-12-21 | Camas | Idaho | 16025 | 108 | 1 |
2031414 | 2031414 | 2021-12-20 | San Juan | Colorado | 8111 | 108 | 0 |
2031683 | 2031683 | 2021-12-20 | Camas | Idaho | 16025 | 108 | 1 |
2028432 | 2028432 | 2021-12-19 | Camas | Idaho | 16025 | 108 | 1 |
2025181 | 2025181 | 2021-12-18 | Camas | Idaho | 16025 | 108 | 1 |
2021930 | 2021930 | 2021-12-17 | Camas | Idaho | 16025 | 108 | 1 |
2018679 | 2018679 | 2021-12-16 | Camas | Idaho | 16025 | 108 | 1 |
2015429 | 2015429 | 2021-12-15 | Camas | Idaho | 16025 | 108 | 1 |
2012178 | 2012178 | 2021-12-14 | Camas | Idaho | 16025 | 108 | 1 |
2008658 | 2008658 | 2021-12-13 | San Juan | Colorado | 8111 | 108 | 0 |
2008927 | 2008927 | 2021-12-13 | Camas | Idaho | 16025 | 108 | 1 |
2005407 | 2005407 | 2021-12-12 | San Juan | Colorado | 8111 | 108 | 0 |
2005676 | 2005676 | 2021-12-12 | Camas | Idaho | 16025 | 108 | 1 |
2002156 | 2002156 | 2021-12-11 | San Juan | Colorado | 8111 | 108 | 0 |
2002425 | 2002425 | 2021-12-11 | Camas | Idaho | 16025 | 108 | 1 |
1998906 | 1998906 | 2021-12-10 | San Juan | Colorado | 8111 | 108 | 0 |
1999175 | 1999175 | 2021-12-10 | Camas | Idaho | 16025 | 108 | 1 |
1995542 | 1995542 | 2021-12-09 | Alpine | California | 6003 | 108 | 0 |
1995655 | 1995655 | 2021-12-09 | San Juan | Colorado | 8111 | 108 | 0 |
1995924 | 1995924 | 2021-12-09 | Camas | Idaho | 16025 | 108 | 1 |
1992291 | 1992291 | 2021-12-08 | Alpine | California | 6003 | 108 | 0 |
1992673 | 1992673 | 2021-12-08 | Camas | Idaho | 16025 | 108 | 1 |
1989040 | 1989040 | 2021-12-07 | Alpine | California | 6003 | 108 | 0 |
1989422 | 1989422 | 2021-12-07 | Camas | Idaho | 16025 | 108 | 1 |
1991675 | 1991675 | 2021-12-07 | Roberts | Texas | 48393 | 108 | 1 |
1985790 | 1985790 | 2021-12-06 | Alpine | California | 6003 | 108 | 0 |
1986172 | 1986172 | 2021-12-06 | Camas | Idaho | 16025 | 108 | 1 |
1988424 | 1988424 | 2021-12-06 | Roberts | Texas | 48393 | 108 | 1 |
1982540 | 1982540 | 2021-12-05 | Alpine | California | 6003 | 108 | 0 |
1982922 | 1982922 | 2021-12-05 | Camas | Idaho | 16025 | 108 | 1 |
1985174 | 1985174 | 2021-12-05 | Roberts | Texas | 48393 | 108 | 1 |
1979290 | 1979290 | 2021-12-04 | Alpine | California | 6003 | 108 | 0 |
1979672 | 1979672 | 2021-12-04 | Camas | Idaho | 16025 | 108 | 1 |
1981924 | 1981924 | 2021-12-04 | Roberts | Texas | 48393 | 108 | 1 |
1982023 | 1982023 | 2021-12-04 | Unknown | Vermont | 108 | 0 | |
1976040 | 1976040 | 2021-12-03 | Alpine | California | 6003 | 108 | 0 |
1976422 | 1976422 | 2021-12-03 | Camas | Idaho | 16025 | 108 | 1 |
1978674 | 1978674 | 2021-12-03 | Roberts | Texas | 48393 | 108 | 1 |
1972791 | 1972791 | 2021-12-02 | Alpine | California | 6003 | 108 | 0 |
1973173 | 1973173 | 2021-12-02 | Camas | Idaho | 16025 | 108 | 1 |
1969541 | 1969541 | 2021-12-01 | Alpine | California | 6003 | 108 | 0 |
1969923 | 1969923 | 2021-12-01 | Camas | Idaho | 16025 | 108 | 1 |
1971362 | 1971362 | 2021-12-01 | Billings | North Dakota | 38007 | 108 | 1 |
1966291 | 1966291 | 2021-11-30 | Alpine | California | 6003 | 108 | 0 |
1966673 | 1966673 | 2021-11-30 | Camas | Idaho | 16025 | 108 | 1 |
1968112 | 1968112 | 2021-11-30 | Billings | North Dakota | 38007 | 108 | 1 |
1963039 | 1963039 | 2021-11-29 | Alpine | California | 6003 | 108 | 0 |
1963421 | 1963421 | 2021-11-29 | Camas | Idaho | 16025 | 108 | 1 |
1960170 | 1960170 | 2021-11-28 | Camas | Idaho | 16025 | 108 | 1 |
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);