ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
433 rows where cases = 1134 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Idaho 44
- Virginia 31
- Kansas 26
- Kentucky 26
- Nebraska 25
- Texas 20
- Puerto Rico 19
- Georgia 17
- Mississippi 17
- Illinois 16
- Oklahoma 15
- Iowa 14
- Missouri 13
- North Carolina 12
- Arkansas 11
- Alabama 10
- Michigan 8
- Indiana 7
- Minnesota 7
- Montana 7
- South Dakota 7
- Colorado 6
- Louisiana 6
- Ohio 6
- Oregon 6
- Pennsylvania 6
- South Carolina 6
- West Virginia 6
- Florida 5
- Guam 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500163 | 2500163 | 2022-05-13 | Lewis | Idaho | 16061 | 1134 | 29 |
2496905 | 2496905 | 2022-05-12 | Lewis | Idaho | 16061 | 1134 | 29 |
2493647 | 2493647 | 2022-05-11 | Lewis | Idaho | 16061 | 1134 | 29 |
2490389 | 2490389 | 2022-05-10 | Lewis | Idaho | 16061 | 1134 | 29 |
2487132 | 2487132 | 2022-05-09 | Lewis | Idaho | 16061 | 1134 | 29 |
2483874 | 2483874 | 2022-05-08 | Lewis | Idaho | 16061 | 1134 | 29 |
2486287 | 2486287 | 2022-05-08 | King and Queen | Virginia | 51097 | 1134 | 12 |
2480616 | 2480616 | 2022-05-07 | Lewis | Idaho | 16061 | 1134 | 29 |
2483029 | 2483029 | 2022-05-07 | King and Queen | Virginia | 51097 | 1134 | 12 |
2477358 | 2477358 | 2022-05-06 | Lewis | Idaho | 16061 | 1134 | 29 |
2479771 | 2479771 | 2022-05-06 | King and Queen | Virginia | 51097 | 1134 | 12 |
2474100 | 2474100 | 2022-05-05 | Lewis | Idaho | 16061 | 1134 | 29 |
2476513 | 2476513 | 2022-05-05 | King and Queen | Virginia | 51097 | 1134 | 12 |
2470843 | 2470843 | 2022-05-04 | Lewis | Idaho | 16061 | 1134 | 29 |
2473255 | 2473255 | 2022-05-04 | King and Queen | Virginia | 51097 | 1134 | 12 |
2467587 | 2467587 | 2022-05-03 | Lewis | Idaho | 16061 | 1134 | 29 |
2464332 | 2464332 | 2022-05-02 | Lewis | Idaho | 16061 | 1134 | 29 |
2461076 | 2461076 | 2022-05-01 | Lewis | Idaho | 16061 | 1134 | 29 |
2457820 | 2457820 | 2022-04-30 | Lewis | Idaho | 16061 | 1134 | 29 |
2454564 | 2454564 | 2022-04-29 | Lewis | Idaho | 16061 | 1134 | 29 |
2451308 | 2451308 | 2022-04-28 | Lewis | Idaho | 16061 | 1134 | 29 |
2448052 | 2448052 | 2022-04-27 | Lewis | Idaho | 16061 | 1134 | 29 |
2444796 | 2444796 | 2022-04-26 | Lewis | Idaho | 16061 | 1134 | 29 |
2446588 | 2446588 | 2022-04-26 | Las Marias | Puerto Rico | 72083 | 1134 | |
2441540 | 2441540 | 2022-04-25 | Lewis | Idaho | 16061 | 1134 | 29 |
2438284 | 2438284 | 2022-04-24 | Lewis | Idaho | 16061 | 1134 | 29 |
2435028 | 2435028 | 2022-04-23 | Lewis | Idaho | 16061 | 1134 | 29 |
2431772 | 2431772 | 2022-04-22 | Lewis | Idaho | 16061 | 1134 | 29 |
2428516 | 2428516 | 2022-04-21 | Lewis | Idaho | 16061 | 1134 | 29 |
2425260 | 2425260 | 2022-04-20 | Lewis | Idaho | 16061 | 1134 | 29 |
2422004 | 2422004 | 2022-04-19 | Lewis | Idaho | 16061 | 1134 | 29 |
2418748 | 2418748 | 2022-04-18 | Lewis | Idaho | 16061 | 1134 | 29 |
2415492 | 2415492 | 2022-04-17 | Lewis | Idaho | 16061 | 1134 | 29 |
2412236 | 2412236 | 2022-04-16 | Lewis | Idaho | 16061 | 1134 | 29 |
2408980 | 2408980 | 2022-04-15 | Lewis | Idaho | 16061 | 1134 | 29 |
2405724 | 2405724 | 2022-04-14 | Lewis | Idaho | 16061 | 1134 | 29 |
2402469 | 2402469 | 2022-04-13 | Lewis | Idaho | 16061 | 1134 | 29 |
2399503 | 2399503 | 2022-04-12 | Ringgold | Iowa | 19159 | 1134 | 33 |
2396247 | 2396247 | 2022-04-11 | Ringgold | Iowa | 19159 | 1134 | 33 |
2392992 | 2392992 | 2022-04-10 | Ringgold | Iowa | 19159 | 1134 | 33 |
2389736 | 2389736 | 2022-04-09 | Ringgold | Iowa | 19159 | 1134 | 33 |
2386480 | 2386480 | 2022-04-08 | Ringgold | Iowa | 19159 | 1134 | 33 |
2383226 | 2383226 | 2022-04-07 | Ringgold | Iowa | 19159 | 1134 | 33 |
2379773 | 2379773 | 2022-04-06 | Putnam | Illinois | 17155 | 1134 | 10 |
2379971 | 2379971 | 2022-04-06 | Ringgold | Iowa | 19159 | 1134 | 33 |
2376519 | 2376519 | 2022-04-05 | Putnam | Illinois | 17155 | 1134 | 10 |
2373267 | 2373267 | 2022-04-04 | Putnam | Illinois | 17155 | 1134 | 10 |
2370014 | 2370014 | 2022-04-03 | Putnam | Illinois | 17155 | 1134 | 10 |
2366761 | 2366761 | 2022-04-02 | Putnam | Illinois | 17155 | 1134 | 10 |
2363508 | 2363508 | 2022-04-01 | Putnam | Illinois | 17155 | 1134 | 10 |
2360254 | 2360254 | 2022-03-31 | Putnam | Illinois | 17155 | 1134 | 10 |
2339763 | 2339763 | 2022-03-24 | Covington city | Virginia | 51580 | 1134 | 25 |
2315019 | 2315019 | 2022-03-17 | Stafford | Kansas | 20185 | 1134 | 26 |
2311766 | 2311766 | 2022-03-16 | Stafford | Kansas | 20185 | 1134 | 26 |
2308513 | 2308513 | 2022-03-15 | Stafford | Kansas | 20185 | 1134 | 26 |
2305262 | 2305262 | 2022-03-14 | Stafford | Kansas | 20185 | 1134 | 26 |
2302010 | 2302010 | 2022-03-13 | Stafford | Kansas | 20185 | 1134 | 26 |
2298758 | 2298758 | 2022-03-12 | Stafford | Kansas | 20185 | 1134 | 26 |
2295506 | 2295506 | 2022-03-11 | Stafford | Kansas | 20185 | 1134 | 26 |
2292254 | 2292254 | 2022-03-10 | Stafford | Kansas | 20185 | 1134 | 26 |
2289002 | 2289002 | 2022-03-09 | Stafford | Kansas | 20185 | 1134 | 26 |
2285751 | 2285751 | 2022-03-08 | Stafford | Kansas | 20185 | 1134 | 26 |
2282499 | 2282499 | 2022-03-07 | Stafford | Kansas | 20185 | 1134 | 26 |
2248472 | 2248472 | 2022-02-24 | Hemphill | Texas | 48211 | 1134 | 6 |
2248829 | 2248829 | 2022-02-24 | San Juan | Washington | 53055 | 1134 | 1 |
2245578 | 2245578 | 2022-02-23 | San Juan | Washington | 53055 | 1134 | 1 |
2239875 | 2239875 | 2022-02-22 | Henderson | Illinois | 17071 | 1134 | 26 |
2240827 | 2240827 | 2022-02-22 | Reynolds | Missouri | 29179 | 1134 | 20 |
2238937 | 2238937 | 2022-02-21 | Charles City | Virginia | 51036 | 1134 | 26 |
2235686 | 2235686 | 2022-02-20 | Charles City | Virginia | 51036 | 1134 | 26 |
2232435 | 2232435 | 2022-02-19 | Charles City | Virginia | 51036 | 1134 | 26 |
2229184 | 2229184 | 2022-02-18 | Charles City | Virginia | 51036 | 1134 | 26 |
2198707 | 2198707 | 2022-02-09 | Polk | Nebraska | 31143 | 1134 | 18 |
2188936 | 2188936 | 2022-02-06 | Morrill | Nebraska | 31123 | 1134 | 17 |
2185683 | 2185683 | 2022-02-05 | Morrill | Nebraska | 31123 | 1134 | 17 |
2182431 | 2182431 | 2022-02-04 | Morrill | Nebraska | 31123 | 1134 | 17 |
2171910 | 2171910 | 2022-02-01 | Ottawa | Kansas | 20143 | 1134 | 16 |
2168657 | 2168657 | 2022-01-31 | Ottawa | Kansas | 20143 | 1134 | 16 |
2143339 | 2143339 | 2022-01-23 | Burt | Nebraska | 31021 | 1134 | 14 |
2140084 | 2140084 | 2022-01-22 | Burt | Nebraska | 31021 | 1134 | 14 |
2136828 | 2136828 | 2022-01-21 | Burt | Nebraska | 31021 | 1134 | 14 |
2132482 | 2132482 | 2022-01-20 | Lemhi | Idaho | 16059 | 1134 | 25 |
2127916 | 2127916 | 2022-01-18 | Walworth | South Dakota | 46129 | 1134 | 20 |
2110099 | 2110099 | 2022-01-13 | Phillips | Kansas | 20147 | 1134 | 28 |
2110510 | 2110510 | 2022-01-13 | Norman | Minnesota | 27107 | 1134 | 11 |
2106848 | 2106848 | 2022-01-12 | Phillips | Kansas | 20147 | 1134 | 28 |
2105274 | 2105274 | 2022-01-11 | Brewster | Texas | 48043 | 1134 | 24 |
2085451 | 2085451 | 2022-01-05 | Adjuntas | Puerto Rico | 72001 | 1134 | |
2085752 | 2085752 | 2022-01-05 | Bailey | Texas | 48017 | 1134 | 31 |
2055550 | 2055550 | 2021-12-27 | Clay | Nebraska | 31035 | 1134 | 17 |
2051208 | 2051208 | 2021-12-26 | Power | Idaho | 16077 | 1134 | 17 |
2052300 | 2052300 | 2021-12-26 | Clay | Nebraska | 31035 | 1134 | 17 |
2052853 | 2052853 | 2021-12-26 | Grant | Oregon | 41023 | 1134 | 17 |
2047958 | 2047958 | 2021-12-25 | Power | Idaho | 16077 | 1134 | 17 |
2049050 | 2049050 | 2021-12-25 | Clay | Nebraska | 31035 | 1134 | 17 |
2049603 | 2049603 | 2021-12-25 | Grant | Oregon | 41023 | 1134 | 17 |
2044708 | 2044708 | 2021-12-24 | Power | Idaho | 16077 | 1134 | 17 |
2045800 | 2045800 | 2021-12-24 | Clay | Nebraska | 31035 | 1134 | 17 |
2046353 | 2046353 | 2021-12-24 | Grant | Oregon | 41023 | 1134 | 17 |
2041459 | 2041459 | 2021-12-23 | Power | Idaho | 16077 | 1134 | 17 |
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);