ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
757 rows where cases = 432 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- North Dakota 151
- Kansas 89
- Texas 56
- Georgia 39
- Virginia 26
- Colorado 22
- Illinois 22
- Missouri 20
- Puerto Rico 18
- Kentucky 17
- Michigan 17
- Minnesota 16
- North Carolina 16
- Louisiana 15
- Indiana 14
- Montana 14
- South Dakota 14
- Oklahoma 13
- Mississippi 12
- Ohio 12
- Alaska 11
- Arkansas 11
- Nebraska 11
- New York 11
- Wisconsin 10
- Alabama 9
- Idaho 9
- Iowa 8
- Vermont 8
- West Virginia 8
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2475529 | 2475529 | 2022-05-05 | Burke | North Dakota | 38013 | 432 | 3 |
2472272 | 2472272 | 2022-05-04 | Burke | North Dakota | 38013 | 432 | 3 |
2469016 | 2469016 | 2022-05-03 | Burke | North Dakota | 38013 | 432 | 3 |
2465760 | 2465760 | 2022-05-02 | Burke | North Dakota | 38013 | 432 | 3 |
2462505 | 2462505 | 2022-05-01 | Burke | North Dakota | 38013 | 432 | 3 |
2459249 | 2459249 | 2022-04-30 | Burke | North Dakota | 38013 | 432 | 3 |
2455993 | 2455993 | 2022-04-29 | Burke | North Dakota | 38013 | 432 | 3 |
2452737 | 2452737 | 2022-04-28 | Burke | North Dakota | 38013 | 432 | 3 |
2449481 | 2449481 | 2022-04-27 | Burke | North Dakota | 38013 | 432 | 3 |
2446224 | 2446224 | 2022-04-26 | Burke | North Dakota | 38013 | 432 | 3 |
2442969 | 2442969 | 2022-04-25 | Burke | North Dakota | 38013 | 432 | 3 |
2439713 | 2439713 | 2022-04-24 | Burke | North Dakota | 38013 | 432 | 3 |
2436457 | 2436457 | 2022-04-23 | Burke | North Dakota | 38013 | 432 | 3 |
2433201 | 2433201 | 2022-04-22 | Burke | North Dakota | 38013 | 432 | 3 |
2429945 | 2429945 | 2022-04-21 | Burke | North Dakota | 38013 | 432 | 3 |
2426689 | 2426689 | 2022-04-20 | Burke | North Dakota | 38013 | 432 | 3 |
2423433 | 2423433 | 2022-04-19 | Burke | North Dakota | 38013 | 432 | 3 |
2420176 | 2420176 | 2022-04-18 | Burke | North Dakota | 38013 | 432 | 3 |
2416921 | 2416921 | 2022-04-17 | Burke | North Dakota | 38013 | 432 | 3 |
2413665 | 2413665 | 2022-04-16 | Burke | North Dakota | 38013 | 432 | 3 |
2410409 | 2410409 | 2022-04-15 | Burke | North Dakota | 38013 | 432 | 3 |
2407153 | 2407153 | 2022-04-14 | Burke | North Dakota | 38013 | 432 | 3 |
2403897 | 2403897 | 2022-04-13 | Burke | North Dakota | 38013 | 432 | 3 |
2400642 | 2400642 | 2022-04-12 | Burke | North Dakota | 38013 | 432 | 3 |
2397387 | 2397387 | 2022-04-11 | Burke | North Dakota | 38013 | 432 | 3 |
2394132 | 2394132 | 2022-04-10 | Burke | North Dakota | 38013 | 432 | 3 |
2390876 | 2390876 | 2022-04-09 | Burke | North Dakota | 38013 | 432 | 3 |
2387620 | 2387620 | 2022-04-08 | Burke | North Dakota | 38013 | 432 | 3 |
2384365 | 2384365 | 2022-04-07 | Burke | North Dakota | 38013 | 432 | 3 |
2381110 | 2381110 | 2022-04-06 | Burke | North Dakota | 38013 | 432 | 3 |
2377855 | 2377855 | 2022-04-05 | Burke | North Dakota | 38013 | 432 | 3 |
2374602 | 2374602 | 2022-04-04 | Burke | North Dakota | 38013 | 432 | 3 |
2371350 | 2371350 | 2022-04-03 | Burke | North Dakota | 38013 | 432 | 3 |
2368097 | 2368097 | 2022-04-02 | Burke | North Dakota | 38013 | 432 | 3 |
2364844 | 2364844 | 2022-04-01 | Burke | North Dakota | 38013 | 432 | 3 |
2361590 | 2361590 | 2022-03-31 | Burke | North Dakota | 38013 | 432 | 3 |
2358336 | 2358336 | 2022-03-30 | Burke | North Dakota | 38013 | 432 | 3 |
2355082 | 2355082 | 2022-03-29 | Burke | North Dakota | 38013 | 432 | 3 |
2351829 | 2351829 | 2022-03-28 | Burke | North Dakota | 38013 | 432 | 3 |
2348577 | 2348577 | 2022-03-27 | Burke | North Dakota | 38013 | 432 | 3 |
2345324 | 2345324 | 2022-03-26 | Burke | North Dakota | 38013 | 432 | 3 |
2342071 | 2342071 | 2022-03-25 | Burke | North Dakota | 38013 | 432 | 3 |
2338818 | 2338818 | 2022-03-24 | Burke | North Dakota | 38013 | 432 | 3 |
2335564 | 2335564 | 2022-03-23 | Burke | North Dakota | 38013 | 432 | 3 |
2332310 | 2332310 | 2022-03-22 | Burke | North Dakota | 38013 | 432 | 3 |
2329057 | 2329057 | 2022-03-21 | Burke | North Dakota | 38013 | 432 | 3 |
2325805 | 2325805 | 2022-03-20 | Burke | North Dakota | 38013 | 432 | 3 |
2322552 | 2322552 | 2022-03-19 | Burke | North Dakota | 38013 | 432 | 3 |
2319298 | 2319298 | 2022-03-18 | Burke | North Dakota | 38013 | 432 | 3 |
2316044 | 2316044 | 2022-03-17 | Burke | North Dakota | 38013 | 432 | 3 |
2312791 | 2312791 | 2022-03-16 | Burke | North Dakota | 38013 | 432 | 3 |
2309538 | 2309538 | 2022-03-15 | Burke | North Dakota | 38013 | 432 | 3 |
2306285 | 2306285 | 2022-03-14 | Burke | North Dakota | 38013 | 432 | 3 |
2303034 | 2303034 | 2022-03-13 | Burke | North Dakota | 38013 | 432 | 3 |
2299782 | 2299782 | 2022-03-12 | Burke | North Dakota | 38013 | 432 | 3 |
2296530 | 2296530 | 2022-03-11 | Burke | North Dakota | 38013 | 432 | 3 |
2267276 | 2267276 | 2022-03-02 | Logan | North Dakota | 38047 | 432 | 12 |
2264024 | 2264024 | 2022-03-01 | Logan | North Dakota | 38047 | 432 | 12 |
2246730 | 2246730 | 2022-02-24 | Stanton | Kansas | 20187 | 432 | 9 |
2243479 | 2243479 | 2022-02-23 | Stanton | Kansas | 20187 | 432 | 9 |
2245398 | 2245398 | 2022-02-23 | Wayne | Utah | 49055 | 432 | 0 |
2240228 | 2240228 | 2022-02-22 | Stanton | Kansas | 20187 | 432 | 8 |
2242147 | 2242147 | 2022-02-22 | Wayne | Utah | 49055 | 432 | 0 |
2236977 | 2236977 | 2022-02-21 | Stanton | Kansas | 20187 | 432 | 8 |
2233726 | 2233726 | 2022-02-20 | Stanton | Kansas | 20187 | 432 | 8 |
2230475 | 2230475 | 2022-02-19 | Stanton | Kansas | 20187 | 432 | 8 |
2227224 | 2227224 | 2022-02-18 | Stanton | Kansas | 20187 | 432 | 8 |
2223979 | 2223979 | 2022-02-17 | Wallace | Kansas | 20199 | 432 | 5 |
2220728 | 2220728 | 2022-02-16 | Wallace | Kansas | 20199 | 432 | 5 |
2210070 | 2210070 | 2022-02-13 | Wrangell City and Borough | Alaska | 2275 | 432 | 1 |
2206817 | 2206817 | 2022-02-12 | Wrangell City and Borough | Alaska | 2275 | 432 | 1 |
2203564 | 2203564 | 2022-02-11 | Wrangell City and Borough | Alaska | 2275 | 432 | 1 |
2206217 | 2206217 | 2022-02-11 | Irion | Texas | 48235 | 432 | 3 |
2200310 | 2200310 | 2022-02-10 | Wrangell City and Borough | Alaska | 2275 | 432 | 1 |
2197056 | 2197056 | 2022-02-09 | Wrangell City and Borough | Alaska | 2275 | 432 | 1 |
2177522 | 2177522 | 2022-02-03 | Haines Borough | Alaska | 2100 | 432 | 1 |
2174269 | 2174269 | 2022-02-02 | Haines Borough | Alaska | 2100 | 432 | 1 |
2167992 | 2167992 | 2022-01-31 | Sedgwick | Colorado | 8115 | 432 | 8 |
2164737 | 2164737 | 2022-01-30 | Sedgwick | Colorado | 8115 | 432 | 8 |
2158226 | 2158226 | 2022-01-28 | Sedgwick | Colorado | 8115 | 432 | 8 |
2133919 | 2133919 | 2022-01-20 | Grant | North Dakota | 38037 | 432 | 11 |
2134727 | 2134727 | 2022-01-20 | Schleicher | Texas | 48413 | 432 | 9 |
2131154 | 2131154 | 2022-01-19 | Miner | South Dakota | 46097 | 432 | 12 |
2126309 | 2126309 | 2022-01-18 | Elk | Kansas | 20049 | 432 | 7 |
2127769 | 2127769 | 2022-01-18 | Maricao | Puerto Rico | 72093 | 432 | |
2123057 | 2123057 | 2022-01-17 | Elk | Kansas | 20049 | 432 | 7 |
2124164 | 2124164 | 2022-01-17 | Kidder | North Dakota | 38043 | 432 | 13 |
2124517 | 2124517 | 2022-01-17 | Maricao | Puerto Rico | 72093 | 432 | |
2119805 | 2119805 | 2022-01-16 | Elk | Kansas | 20049 | 432 | 7 |
2116553 | 2116553 | 2022-01-15 | Elk | Kansas | 20049 | 432 | 7 |
2113302 | 2113302 | 2022-01-14 | Elk | Kansas | 20049 | 432 | 7 |
2103203 | 2103203 | 2022-01-11 | Custer | Idaho | 16037 | 432 | 7 |
2101010 | 2101010 | 2022-01-10 | Granite | Montana | 30039 | 432 | 6 |
2086186 | 2086186 | 2022-01-05 | Columbia | Washington | 53013 | 432 | 10 |
2013322 | 2013322 | 2021-12-14 | Hitchcock | Nebraska | 31087 | 432 | 5 |
1989797 | 1989797 | 2021-12-07 | Kiowa | Kansas | 20097 | 432 | 6 |
1986547 | 1986547 | 2021-12-06 | Kiowa | Kansas | 20097 | 432 | 6 |
1984104 | 1984104 | 2021-12-05 | Sherman | Nebraska | 31163 | 432 | 4 |
1980854 | 1980854 | 2021-12-04 | Sherman | Nebraska | 31163 | 432 | 4 |
1977604 | 1977604 | 2021-12-03 | Sherman | Nebraska | 31163 | 432 | 4 |
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);