ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
641 rows where cases = 543 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Nebraska 58
- Texas 48
- Missouri 45
- West Virginia 42
- Iowa 40
- Oklahoma 37
- Kansas 29
- Puerto Rico 21
- Virginia 20
- Georgia 19
- Indiana 18
- Kentucky 18
- Alabama 16
- Illinois 16
- Michigan 16
- North Dakota 16
- Louisiana 13
- Mississippi 13
- Arkansas 12
- Colorado 12
- Montana 12
- Minnesota 11
- New Mexico 10
- California 9
- North Carolina 9
- Pennsylvania 8
- Ohio 7
- Idaho 6
- South Dakota 6
- Florida 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501280 | 2501280 | 2022-05-13 | Frontier | Nebraska | 31063 | 543 | 3 |
2498022 | 2498022 | 2022-05-12 | Frontier | Nebraska | 31063 | 543 | 3 |
2494764 | 2494764 | 2022-05-11 | Frontier | Nebraska | 31063 | 543 | 3 |
2491506 | 2491506 | 2022-05-10 | Frontier | Nebraska | 31063 | 543 | 3 |
2488248 | 2488248 | 2022-05-09 | Frontier | Nebraska | 31063 | 543 | 3 |
2484975 | 2484975 | 2022-05-08 | Cherry | Nebraska | 31031 | 543 | 10 |
2484991 | 2484991 | 2022-05-08 | Frontier | Nebraska | 31063 | 543 | 3 |
2481717 | 2481717 | 2022-05-07 | Cherry | Nebraska | 31031 | 543 | 10 |
2481733 | 2481733 | 2022-05-07 | Frontier | Nebraska | 31063 | 543 | 3 |
2478459 | 2478459 | 2022-05-06 | Cherry | Nebraska | 31031 | 543 | 10 |
2478475 | 2478475 | 2022-05-06 | Frontier | Nebraska | 31063 | 543 | 3 |
2475201 | 2475201 | 2022-05-05 | Cherry | Nebraska | 31031 | 543 | 10 |
2475217 | 2475217 | 2022-05-05 | Frontier | Nebraska | 31063 | 543 | 3 |
2471944 | 2471944 | 2022-05-04 | Cherry | Nebraska | 31031 | 543 | 10 |
2471960 | 2471960 | 2022-05-04 | Frontier | Nebraska | 31063 | 543 | 3 |
2468704 | 2468704 | 2022-05-03 | Frontier | Nebraska | 31063 | 543 | 3 |
2465448 | 2465448 | 2022-05-02 | Frontier | Nebraska | 31063 | 543 | 3 |
2462193 | 2462193 | 2022-05-01 | Frontier | Nebraska | 31063 | 543 | 3 |
2458937 | 2458937 | 2022-04-30 | Frontier | Nebraska | 31063 | 543 | 3 |
2455681 | 2455681 | 2022-04-29 | Frontier | Nebraska | 31063 | 543 | 3 |
2452425 | 2452425 | 2022-04-28 | Frontier | Nebraska | 31063 | 543 | 3 |
2449169 | 2449169 | 2022-04-27 | Frontier | Nebraska | 31063 | 543 | 3 |
2445912 | 2445912 | 2022-04-26 | Frontier | Nebraska | 31063 | 543 | 3 |
2442641 | 2442641 | 2022-04-25 | Cherry | Nebraska | 31031 | 543 | 10 |
2442657 | 2442657 | 2022-04-25 | Frontier | Nebraska | 31063 | 543 | 3 |
2439385 | 2439385 | 2022-04-24 | Cherry | Nebraska | 31031 | 543 | 10 |
2439401 | 2439401 | 2022-04-24 | Frontier | Nebraska | 31063 | 543 | 3 |
2436129 | 2436129 | 2022-04-23 | Cherry | Nebraska | 31031 | 543 | 10 |
2436145 | 2436145 | 2022-04-23 | Frontier | Nebraska | 31063 | 543 | 3 |
2432873 | 2432873 | 2022-04-22 | Cherry | Nebraska | 31031 | 543 | 10 |
2432889 | 2432889 | 2022-04-22 | Frontier | Nebraska | 31063 | 543 | 3 |
2429633 | 2429633 | 2022-04-21 | Frontier | Nebraska | 31063 | 543 | 3 |
2426377 | 2426377 | 2022-04-20 | Frontier | Nebraska | 31063 | 543 | 3 |
2423121 | 2423121 | 2022-04-19 | Frontier | Nebraska | 31063 | 543 | 3 |
2358024 | 2358024 | 2022-03-30 | Frontier | Nebraska | 31063 | 543 | 2 |
2354771 | 2354771 | 2022-03-29 | Frontier | Nebraska | 31063 | 543 | 2 |
2351518 | 2351518 | 2022-03-28 | Frontier | Nebraska | 31063 | 543 | 2 |
2329270 | 2329270 | 2022-03-21 | Unknown | Oklahoma | 543 | 1 | |
2326018 | 2326018 | 2022-03-20 | Unknown | Oklahoma | 543 | 1 | |
2322765 | 2322765 | 2022-03-19 | Unknown | Oklahoma | 543 | 1 | |
2319511 | 2319511 | 2022-03-18 | Unknown | Oklahoma | 543 | 1 | |
2316257 | 2316257 | 2022-03-17 | Unknown | Oklahoma | 543 | 1 | |
2283212 | 2283212 | 2022-03-07 | Frontier | Nebraska | 31063 | 543 | 2 |
2279959 | 2279959 | 2022-03-06 | Frontier | Nebraska | 31063 | 543 | 2 |
2276706 | 2276706 | 2022-03-05 | Frontier | Nebraska | 31063 | 543 | 2 |
2273453 | 2273453 | 2022-03-04 | Frontier | Nebraska | 31063 | 543 | 2 |
2270201 | 2270201 | 2022-03-03 | Frontier | Nebraska | 31063 | 543 | 2 |
2271305 | 2271305 | 2022-03-03 | Oldham | Texas | 48359 | 543 | 6 |
2266948 | 2266948 | 2022-03-02 | Frontier | Nebraska | 31063 | 543 | 2 |
2268053 | 2268053 | 2022-03-02 | Oldham | Texas | 48359 | 543 | 6 |
2263697 | 2263697 | 2022-03-01 | Frontier | Nebraska | 31063 | 543 | 2 |
2264800 | 2264800 | 2022-03-01 | Oldham | Texas | 48359 | 543 | 6 |
2260446 | 2260446 | 2022-02-28 | Frontier | Nebraska | 31063 | 543 | 2 |
2172694 | 2172694 | 2022-02-01 | Sherman | Nebraska | 31163 | 543 | 4 |
2173667 | 2173667 | 2022-02-01 | Hardeman | Texas | 48197 | 543 | 14 |
2169441 | 2169441 | 2022-01-31 | Sherman | Nebraska | 31163 | 543 | 4 |
2170415 | 2170415 | 2022-01-31 | Hardeman | Texas | 48197 | 543 | 14 |
2165354 | 2165354 | 2022-01-30 | Edwards | Kansas | 20047 | 543 | 13 |
2167161 | 2167161 | 2022-01-30 | Hardeman | Texas | 48197 | 543 | 14 |
2162099 | 2162099 | 2022-01-29 | Edwards | Kansas | 20047 | 543 | 13 |
2158844 | 2158844 | 2022-01-28 | Edwards | Kansas | 20047 | 543 | 13 |
2097041 | 2097041 | 2022-01-09 | Decatur | Kansas | 20039 | 543 | 16 |
2098886 | 2098886 | 2022-01-09 | Kinney | Texas | 48271 | 543 | 10 |
2093789 | 2093789 | 2022-01-08 | Decatur | Kansas | 20039 | 543 | 16 |
2090537 | 2090537 | 2022-01-07 | Decatur | Kansas | 20039 | 543 | 16 |
2063276 | 2063276 | 2021-12-29 | Grand Isle | Vermont | 50013 | 543 | 3 |
2012602 | 2012602 | 2021-12-14 | Trego | Kansas | 20195 | 543 | 9 |
2009351 | 2009351 | 2021-12-13 | Trego | Kansas | 20195 | 543 | 9 |
2000472 | 2000472 | 2021-12-10 | Hamilton | New York | 36041 | 543 | 3 |
1989121 | 1989121 | 2021-12-07 | Gilpin | Colorado | 8047 | 543 | 4 |
1982423 | 1982423 | 2021-12-05 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 543 | 1 |
1979173 | 1979173 | 2021-12-04 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 543 | 1 |
1975923 | 1975923 | 2021-12-03 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 543 | 1 |
1977878 | 1977878 | 2021-12-03 | Hettinger | North Dakota | 38041 | 543 | 7 |
1964511 | 1964511 | 2021-11-29 | Sheridan | Montana | 30091 | 543 | 8 |
1948409 | 1948409 | 2021-11-24 | Unknown | New Jersey | 543 | 0 | |
1940344 | 1940344 | 2021-11-22 | Baca | Colorado | 8009 | 543 | 5 |
1937831 | 1937831 | 2021-11-21 | Sheridan | Kansas | 20179 | 543 | 16 |
1934581 | 1934581 | 2021-11-20 | Sheridan | Kansas | 20179 | 543 | 16 |
1931330 | 1931330 | 2021-11-19 | Sheridan | Kansas | 20179 | 543 | 16 |
1928072 | 1928072 | 2021-11-18 | Rush | Kansas | 20165 | 543 | 16 |
1924822 | 1924822 | 2021-11-17 | Rush | Kansas | 20165 | 543 | 16 |
1921153 | 1921153 | 2021-11-16 | Adams | Idaho | 16003 | 543 | 12 |
1922145 | 1922145 | 2021-11-16 | Knox | Missouri | 29103 | 543 | 3 |
1909871 | 1909871 | 2021-11-12 | Cameron | Pennsylvania | 42023 | 543 | 11 |
1896611 | 1896611 | 2021-11-08 | Cavalier | North Dakota | 38019 | 543 | 5 |
1896615 | 1896615 | 2021-11-08 | Eddy | North Dakota | 38027 | 543 | 6 |
1893361 | 1893361 | 2021-11-07 | Cavalier | North Dakota | 38019 | 543 | 5 |
1890111 | 1890111 | 2021-11-06 | Cavalier | North Dakota | 38019 | 543 | 5 |
1886861 | 1886861 | 2021-11-05 | Cavalier | North Dakota | 38019 | 543 | 5 |
1873255 | 1873255 | 2021-11-01 | Traverse | Minnesota | 27155 | 543 | 5 |
1870286 | 1870286 | 2021-10-31 | Chase | Nebraska | 31029 | 543 | 5 |
1864140 | 1864140 | 2021-10-29 | Nelson | North Dakota | 38063 | 543 | 16 |
1860891 | 1860891 | 2021-10-28 | Nelson | North Dakota | 38063 | 543 | 16 |
1857642 | 1857642 | 2021-10-27 | Nelson | North Dakota | 38063 | 543 | 16 |
1858068 | 1858068 | 2021-10-27 | Aurora | South Dakota | 46003 | 543 | 17 |
1854019 | 1854019 | 2021-10-26 | Sweet Grass | Montana | 30097 | 543 | 7 |
1854819 | 1854819 | 2021-10-26 | Aurora | South Dakota | 46003 | 543 | 17 |
1848823 | 1848823 | 2021-10-24 | Falls Church city | Virginia | 51610 | 543 | 8 |
1845573 | 1845573 | 2021-10-23 | Falls Church city | Virginia | 51610 | 543 | 8 |
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);