ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
646 rows where cases = 616 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kansas 80
- Texas 55
- Nebraska 53
- Virginia 49
- Iowa 45
- Georgia 40
- Missouri 23
- New Mexico 18
- Mississippi 17
- Colorado 15
- Puerto Rico 15
- Kentucky 14
- Michigan 14
- Indiana 13
- Tennessee 13
- Alaska 11
- North Dakota 11
- Arkansas 10
- North Carolina 10
- Ohio 10
- Pennsylvania 10
- West Virginia 10
- Florida 9
- Idaho 9
- Illinois 9
- Alabama 8
- Minnesota 8
- New York 7
- South Dakota 7
- Oklahoma 6
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2474429 | 2474429 | 2022-05-05 | Decatur | Kansas | 20039 | 616 | 20 |
2471172 | 2471172 | 2022-05-04 | Decatur | Kansas | 20039 | 616 | 20 |
2467916 | 2467916 | 2022-05-03 | Decatur | Kansas | 20039 | 616 | 20 |
2464661 | 2464661 | 2022-05-02 | Decatur | Kansas | 20039 | 616 | 20 |
2461405 | 2461405 | 2022-05-01 | Decatur | Kansas | 20039 | 616 | 20 |
2458149 | 2458149 | 2022-04-30 | Decatur | Kansas | 20039 | 616 | 20 |
2454893 | 2454893 | 2022-04-29 | Decatur | Kansas | 20039 | 616 | 20 |
2451637 | 2451637 | 2022-04-28 | Decatur | Kansas | 20039 | 616 | 20 |
2448381 | 2448381 | 2022-04-27 | Decatur | Kansas | 20039 | 616 | 20 |
2445125 | 2445125 | 2022-04-26 | Decatur | Kansas | 20039 | 616 | 20 |
2441869 | 2441869 | 2022-04-25 | Decatur | Kansas | 20039 | 616 | 20 |
2438613 | 2438613 | 2022-04-24 | Decatur | Kansas | 20039 | 616 | 20 |
2435357 | 2435357 | 2022-04-23 | Decatur | Kansas | 20039 | 616 | 20 |
2432101 | 2432101 | 2022-04-22 | Decatur | Kansas | 20039 | 616 | 20 |
2428845 | 2428845 | 2022-04-21 | Decatur | Kansas | 20039 | 616 | 20 |
2425589 | 2425589 | 2022-04-20 | Decatur | Kansas | 20039 | 616 | 20 |
2422333 | 2422333 | 2022-04-19 | Decatur | Kansas | 20039 | 616 | 20 |
2419077 | 2419077 | 2022-04-18 | Decatur | Kansas | 20039 | 616 | 20 |
2415821 | 2415821 | 2022-04-17 | Decatur | Kansas | 20039 | 616 | 20 |
2412565 | 2412565 | 2022-04-16 | Decatur | Kansas | 20039 | 616 | 20 |
2409309 | 2409309 | 2022-04-15 | Decatur | Kansas | 20039 | 616 | 20 |
2406053 | 2406053 | 2022-04-14 | Decatur | Kansas | 20039 | 616 | 20 |
2402797 | 2402797 | 2022-04-13 | Decatur | Kansas | 20039 | 616 | 20 |
2399543 | 2399543 | 2022-04-12 | Decatur | Kansas | 20039 | 616 | 20 |
2396287 | 2396287 | 2022-04-11 | Decatur | Kansas | 20039 | 616 | 20 |
2393032 | 2393032 | 2022-04-10 | Decatur | Kansas | 20039 | 616 | 20 |
2389776 | 2389776 | 2022-04-09 | Decatur | Kansas | 20039 | 616 | 20 |
2386520 | 2386520 | 2022-04-08 | Decatur | Kansas | 20039 | 616 | 20 |
2383266 | 2383266 | 2022-04-07 | Decatur | Kansas | 20039 | 616 | 20 |
2380011 | 2380011 | 2022-04-06 | Decatur | Kansas | 20039 | 616 | 20 |
2376756 | 2376756 | 2022-04-05 | Decatur | Kansas | 20039 | 616 | 20 |
2373504 | 2373504 | 2022-04-04 | Decatur | Kansas | 20039 | 616 | 20 |
2370251 | 2370251 | 2022-04-03 | Decatur | Kansas | 20039 | 616 | 20 |
2366998 | 2366998 | 2022-04-02 | Decatur | Kansas | 20039 | 616 | 20 |
2363745 | 2363745 | 2022-04-01 | Decatur | Kansas | 20039 | 616 | 20 |
2360491 | 2360491 | 2022-03-31 | Decatur | Kansas | 20039 | 616 | 20 |
2357237 | 2357237 | 2022-03-30 | Decatur | Kansas | 20039 | 616 | 20 |
2353984 | 2353984 | 2022-03-29 | Decatur | Kansas | 20039 | 616 | 20 |
2350732 | 2350732 | 2022-03-28 | Decatur | Kansas | 20039 | 616 | 20 |
2347479 | 2347479 | 2022-03-27 | Decatur | Kansas | 20039 | 616 | 20 |
2344226 | 2344226 | 2022-03-26 | Decatur | Kansas | 20039 | 616 | 20 |
2340973 | 2340973 | 2022-03-25 | Decatur | Kansas | 20039 | 616 | 20 |
2337720 | 2337720 | 2022-03-24 | Decatur | Kansas | 20039 | 616 | 20 |
2334466 | 2334466 | 2022-03-23 | Decatur | Kansas | 20039 | 616 | 20 |
2216740 | 2216740 | 2022-02-15 | Custer | Colorado | 8027 | 616 | 18 |
2202273 | 2202273 | 2022-02-10 | Towner | North Dakota | 38095 | 616 | 12 |
2170525 | 2170525 | 2022-01-31 | Shackelford | Texas | 48417 | 616 | 12 |
2160596 | 2160596 | 2022-01-28 | Collingsworth | Texas | 48087 | 616 | 13 |
2152981 | 2152981 | 2022-01-26 | Mercer | Missouri | 29129 | 616 | 12 |
2146746 | 2146746 | 2022-01-24 | Mora | New Mexico | 35033 | 616 | 14 |
2125459 | 2125459 | 2022-01-18 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 616 | 1 |
2122207 | 2122207 | 2022-01-17 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 616 | 1 |
2118955 | 2118955 | 2022-01-16 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 616 | 1 |
2115703 | 2115703 | 2022-01-15 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 616 | 1 |
2112451 | 2112451 | 2022-01-14 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 616 | 1 |
2110123 | 2110123 | 2022-01-13 | Trego | Kansas | 20195 | 616 | 9 |
2111636 | 2111636 | 2022-01-13 | Marshall | South Dakota | 46091 | 616 | 8 |
2106872 | 2106872 | 2022-01-12 | Trego | Kansas | 20195 | 616 | 9 |
2077668 | 2077668 | 2022-01-03 | Hickman | Kentucky | 21105 | 616 | 22 |
2078634 | 2078634 | 2022-01-03 | Emmons | North Dakota | 38029 | 616 | 16 |
2073632 | 2073632 | 2022-01-02 | Gilpin | Colorado | 8047 | 616 | 3 |
2070381 | 2070381 | 2022-01-01 | Gilpin | Colorado | 8047 | 616 | 3 |
2067130 | 2067130 | 2021-12-31 | Gilpin | Colorado | 8047 | 616 | 3 |
2068728 | 2068728 | 2021-12-31 | Hamilton | New York | 36041 | 616 | 4 |
2063903 | 2063903 | 2021-12-30 | Phillips | Colorado | 8095 | 616 | 15 |
2062354 | 2062354 | 2021-12-29 | Tyrrell | North Carolina | 37177 | 616 | 7 |
2059148 | 2059148 | 2021-12-28 | Nelson | North Dakota | 38063 | 616 | 16 |
2051540 | 2051540 | 2021-12-26 | Gove | Kansas | 20063 | 616 | 23 |
2048290 | 2048290 | 2021-12-25 | Gove | Kansas | 20063 | 616 | 23 |
2045040 | 2045040 | 2021-12-24 | Gove | Kansas | 20063 | 616 | 23 |
2046149 | 2046149 | 2021-12-24 | Nelson | North Dakota | 38063 | 616 | 16 |
2040980 | 2040980 | 2021-12-23 | Calhoun | Arkansas | 5013 | 616 | 8 |
2041791 | 2041791 | 2021-12-23 | Gove | Kansas | 20063 | 616 | 23 |
2038541 | 2038541 | 2021-12-22 | Gove | Kansas | 20063 | 616 | 23 |
2017599 | 2017599 | 2021-12-15 | Hudspeth | Texas | 48229 | 616 | 14 |
2013013 | 2013013 | 2021-12-14 | Traverse | Minnesota | 27155 | 616 | 6 |
2014349 | 2014349 | 2021-12-14 | Hudspeth | Texas | 48229 | 616 | 14 |
2004133 | 2004133 | 2021-12-11 | Cameron | Pennsylvania | 42023 | 616 | 13 |
1939876 | 1939876 | 2021-11-21 | Rappahannock | Virginia | 51157 | 616 | 5 |
1936626 | 1936626 | 2021-11-20 | Rappahannock | Virginia | 51157 | 616 | 5 |
1933187 | 1933187 | 2021-11-19 | Sutton | Texas | 48435 | 616 | 11 |
1933376 | 1933376 | 2021-11-19 | Rappahannock | Virginia | 51157 | 616 | 5 |
1929936 | 1929936 | 2021-11-18 | Sutton | Texas | 48435 | 616 | 11 |
1926686 | 1926686 | 2021-11-17 | Sutton | Texas | 48435 | 616 | 11 |
1923436 | 1923436 | 2021-11-16 | Sutton | Texas | 48435 | 616 | 11 |
1920187 | 1920187 | 2021-11-15 | Sutton | Texas | 48435 | 616 | 11 |
1915921 | 1915921 | 2021-11-14 | Hidalgo | New Mexico | 35023 | 616 | 11 |
1916937 | 1916937 | 2021-11-14 | Sutton | Texas | 48435 | 616 | 11 |
1917110 | 1917110 | 2021-11-14 | Norton city | Virginia | 51720 | 616 | 15 |
1912671 | 1912671 | 2021-11-13 | Hidalgo | New Mexico | 35023 | 616 | 11 |
1913166 | 1913166 | 2021-11-13 | Sullivan | Pennsylvania | 42113 | 616 | 24 |
1913860 | 1913860 | 2021-11-13 | Norton city | Virginia | 51720 | 616 | 15 |
1909421 | 1909421 | 2021-11-12 | Hidalgo | New Mexico | 35023 | 616 | 11 |
1910610 | 1910610 | 2021-11-12 | Norton city | Virginia | 51720 | 616 | 15 |
1904063 | 1904063 | 2021-11-10 | Falls Church city | Virginia | 51610 | 616 | 13 |
1881395 | 1881395 | 2021-11-03 | Surry | Virginia | 51181 | 616 | 10 |
1876489 | 1876489 | 2021-11-02 | Red Lake | Minnesota | 27125 | 616 | 9 |
1878146 | 1878146 | 2021-11-02 | Surry | Virginia | 51181 | 616 | 10 |
1870375 | 1870375 | 2021-10-31 | Lincoln | Nevada | 32017 | 616 | 5 |
1870659 | 1870659 | 2021-10-31 | Wells | North Dakota | 38103 | 616 | 9 |
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);