ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
514 rows where cases = 806 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Idaho 53
- Kansas 40
- Texas 33
- Georgia 32
- Virginia 32
- Indiana 21
- Iowa 18
- Mississippi 17
- Nebraska 17
- Michigan 16
- South Dakota 16
- Illinois 15
- Missouri 15
- Kentucky 14
- Tennessee 14
- Oklahoma 12
- Puerto Rico 12
- Colorado 11
- Minnesota 11
- Arkansas 10
- Louisiana 9
- Montana 9
- West Virginia 9
- Washington 8
- Alabama 7
- South Carolina 7
- Utah 7
- North Carolina 6
- North Dakota 6
- Ohio 6
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501805 | 2501805 | 2022-05-13 | Unknown | Oklahoma | 806 | 0 | |
2498547 | 2498547 | 2022-05-12 | Unknown | Oklahoma | 806 | 0 | |
2487137 | 2487137 | 2022-05-09 | Oneida | Idaho | 16071 | 806 | 11 |
2483879 | 2483879 | 2022-05-08 | Oneida | Idaho | 16071 | 806 | 11 |
2480621 | 2480621 | 2022-05-07 | Oneida | Idaho | 16071 | 806 | 11 |
2477363 | 2477363 | 2022-05-06 | Oneida | Idaho | 16071 | 806 | 11 |
2474105 | 2474105 | 2022-05-05 | Oneida | Idaho | 16071 | 806 | 11 |
2470848 | 2470848 | 2022-05-04 | Oneida | Idaho | 16071 | 806 | 11 |
2467592 | 2467592 | 2022-05-03 | Oneida | Idaho | 16071 | 806 | 11 |
2464337 | 2464337 | 2022-05-02 | Oneida | Idaho | 16071 | 806 | 11 |
2461081 | 2461081 | 2022-05-01 | Oneida | Idaho | 16071 | 806 | 11 |
2457825 | 2457825 | 2022-04-30 | Oneida | Idaho | 16071 | 806 | 11 |
2454569 | 2454569 | 2022-04-29 | Oneida | Idaho | 16071 | 806 | 11 |
2451313 | 2451313 | 2022-04-28 | Oneida | Idaho | 16071 | 806 | 11 |
2448057 | 2448057 | 2022-04-27 | Oneida | Idaho | 16071 | 806 | 11 |
2444801 | 2444801 | 2022-04-26 | Oneida | Idaho | 16071 | 806 | 11 |
2441545 | 2441545 | 2022-04-25 | Oneida | Idaho | 16071 | 806 | 11 |
2438289 | 2438289 | 2022-04-24 | Oneida | Idaho | 16071 | 806 | 11 |
2435033 | 2435033 | 2022-04-23 | Oneida | Idaho | 16071 | 806 | 11 |
2431777 | 2431777 | 2022-04-22 | Oneida | Idaho | 16071 | 806 | 11 |
2428521 | 2428521 | 2022-04-21 | Oneida | Idaho | 16071 | 806 | 11 |
2425265 | 2425265 | 2022-04-20 | Oneida | Idaho | 16071 | 806 | 11 |
2422009 | 2422009 | 2022-04-19 | Oneida | Idaho | 16071 | 806 | 11 |
2418753 | 2418753 | 2022-04-18 | Oneida | Idaho | 16071 | 806 | 11 |
2415497 | 2415497 | 2022-04-17 | Oneida | Idaho | 16071 | 806 | 11 |
2412241 | 2412241 | 2022-04-16 | Oneida | Idaho | 16071 | 806 | 11 |
2408985 | 2408985 | 2022-04-15 | Oneida | Idaho | 16071 | 806 | 11 |
2383329 | 2383329 | 2022-04-07 | Rush | Kansas | 20165 | 806 | 18 |
2379687 | 2379687 | 2022-04-06 | Oneida | Idaho | 16071 | 806 | 11 |
2380074 | 2380074 | 2022-04-06 | Rush | Kansas | 20165 | 806 | 18 |
2376433 | 2376433 | 2022-04-05 | Oneida | Idaho | 16071 | 806 | 11 |
2376819 | 2376819 | 2022-04-05 | Rush | Kansas | 20165 | 806 | 18 |
2373181 | 2373181 | 2022-04-04 | Oneida | Idaho | 16071 | 806 | 11 |
2373567 | 2373567 | 2022-04-04 | Rush | Kansas | 20165 | 806 | 18 |
2369928 | 2369928 | 2022-04-03 | Oneida | Idaho | 16071 | 806 | 11 |
2370314 | 2370314 | 2022-04-03 | Rush | Kansas | 20165 | 806 | 18 |
2366675 | 2366675 | 2022-04-02 | Oneida | Idaho | 16071 | 806 | 11 |
2367061 | 2367061 | 2022-04-02 | Rush | Kansas | 20165 | 806 | 18 |
2363422 | 2363422 | 2022-04-01 | Oneida | Idaho | 16071 | 806 | 11 |
2363808 | 2363808 | 2022-04-01 | Rush | Kansas | 20165 | 806 | 18 |
2360168 | 2360168 | 2022-03-31 | Oneida | Idaho | 16071 | 806 | 11 |
2360554 | 2360554 | 2022-03-31 | Rush | Kansas | 20165 | 806 | 18 |
2356914 | 2356914 | 2022-03-30 | Oneida | Idaho | 16071 | 806 | 11 |
2357300 | 2357300 | 2022-03-30 | Rush | Kansas | 20165 | 806 | 18 |
2353661 | 2353661 | 2022-03-29 | Oneida | Idaho | 16071 | 806 | 11 |
2354047 | 2354047 | 2022-03-29 | Rush | Kansas | 20165 | 806 | 18 |
2350409 | 2350409 | 2022-03-28 | Oneida | Idaho | 16071 | 806 | 11 |
2350795 | 2350795 | 2022-03-28 | Rush | Kansas | 20165 | 806 | 18 |
2347156 | 2347156 | 2022-03-27 | Oneida | Idaho | 16071 | 806 | 11 |
2347542 | 2347542 | 2022-03-27 | Rush | Kansas | 20165 | 806 | 18 |
2343903 | 2343903 | 2022-03-26 | Oneida | Idaho | 16071 | 806 | 11 |
2344289 | 2344289 | 2022-03-26 | Rush | Kansas | 20165 | 806 | 18 |
2340650 | 2340650 | 2022-03-25 | Oneida | Idaho | 16071 | 806 | 11 |
2341036 | 2341036 | 2022-03-25 | Rush | Kansas | 20165 | 806 | 18 |
2337397 | 2337397 | 2022-03-24 | Oneida | Idaho | 16071 | 806 | 11 |
2337783 | 2337783 | 2022-03-24 | Rush | Kansas | 20165 | 806 | 18 |
2334143 | 2334143 | 2022-03-23 | Oneida | Idaho | 16071 | 806 | 11 |
2334529 | 2334529 | 2022-03-23 | Rush | Kansas | 20165 | 806 | 18 |
2330889 | 2330889 | 2022-03-22 | Oneida | Idaho | 16071 | 806 | 11 |
2331275 | 2331275 | 2022-03-22 | Rush | Kansas | 20165 | 806 | 18 |
2327637 | 2327637 | 2022-03-21 | Oneida | Idaho | 16071 | 806 | 11 |
2328023 | 2328023 | 2022-03-21 | Rush | Kansas | 20165 | 806 | 18 |
2324384 | 2324384 | 2022-03-20 | Oneida | Idaho | 16071 | 806 | 11 |
2324770 | 2324770 | 2022-03-20 | Rush | Kansas | 20165 | 806 | 18 |
2321130 | 2321130 | 2022-03-19 | Oneida | Idaho | 16071 | 806 | 11 |
2321516 | 2321516 | 2022-03-19 | Rush | Kansas | 20165 | 806 | 18 |
2317876 | 2317876 | 2022-03-18 | Oneida | Idaho | 16071 | 806 | 11 |
2318262 | 2318262 | 2022-03-18 | Rush | Kansas | 20165 | 806 | 18 |
2314623 | 2314623 | 2022-03-17 | Oneida | Idaho | 16071 | 806 | 11 |
2315009 | 2315009 | 2022-03-17 | Rush | Kansas | 20165 | 806 | 18 |
2311756 | 2311756 | 2022-03-16 | Rush | Kansas | 20165 | 806 | 18 |
2303841 | 2303841 | 2022-03-13 | Real | Texas | 48385 | 806 | 24 |
2300589 | 2300589 | 2022-03-12 | Real | Texas | 48385 | 806 | 24 |
2297337 | 2297337 | 2022-03-11 | Real | Texas | 48385 | 806 | 24 |
2294085 | 2294085 | 2022-03-10 | Real | Texas | 48385 | 806 | 24 |
2290833 | 2290833 | 2022-03-09 | Real | Texas | 48385 | 806 | 24 |
2287581 | 2287581 | 2022-03-08 | Real | Texas | 48385 | 806 | 24 |
2284329 | 2284329 | 2022-03-07 | Real | Texas | 48385 | 806 | 24 |
2281077 | 2281077 | 2022-03-06 | Real | Texas | 48385 | 806 | 24 |
2277824 | 2277824 | 2022-03-05 | Real | Texas | 48385 | 806 | 24 |
2248378 | 2248378 | 2022-02-24 | Baylor | Texas | 48023 | 806 | 32 |
2242738 | 2242738 | 2022-02-23 | Baca | Colorado | 8009 | 806 | 8 |
2245127 | 2245127 | 2022-02-23 | Baylor | Texas | 48023 | 806 | 32 |
2239487 | 2239487 | 2022-02-22 | Baca | Colorado | 8009 | 806 | 8 |
2240217 | 2240217 | 2022-02-22 | Rush | Kansas | 20165 | 806 | 18 |
2236966 | 2236966 | 2022-02-21 | Rush | Kansas | 20165 | 806 | 18 |
2238265 | 2238265 | 2022-02-21 | Cameron | Pennsylvania | 42023 | 806 | 19 |
2233715 | 2233715 | 2022-02-20 | Rush | Kansas | 20165 | 806 | 18 |
2235014 | 2235014 | 2022-02-20 | Cameron | Pennsylvania | 42023 | 806 | 19 |
2230464 | 2230464 | 2022-02-19 | Rush | Kansas | 20165 | 806 | 18 |
2227213 | 2227213 | 2022-02-18 | Rush | Kansas | 20165 | 806 | 18 |
2206330 | 2206330 | 2022-02-11 | Upton | Texas | 48461 | 806 | 17 |
2195579 | 2195579 | 2022-02-08 | Hamilton | New York | 36041 | 806 | 5 |
2189215 | 2189215 | 2022-02-06 | Bowman | North Dakota | 38011 | 806 | 9 |
2185962 | 2185962 | 2022-02-05 | Bowman | North Dakota | 38011 | 806 | 9 |
2174488 | 2174488 | 2022-02-02 | Phillips | Colorado | 8095 | 806 | 15 |
2146303 | 2146303 | 2022-01-24 | Red Lake | Minnesota | 27125 | 806 | 11 |
2122725 | 2122725 | 2022-01-17 | Lincoln | Idaho | 16063 | 806 | 14 |
2119473 | 2119473 | 2022-01-16 | Lincoln | Idaho | 16063 | 806 | 14 |
2116221 | 2116221 | 2022-01-15 | Lincoln | Idaho | 16063 | 806 | 14 |
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);