ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
412 rows where cases = 1198 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Louisiana 54
- Texas 45
- Virginia 29
- Georgia 26
- Minnesota 21
- Puerto Rico 15
- Idaho 14
- Kansas 14
- Kentucky 14
- Missouri 13
- Mississippi 12
- Iowa 11
- Michigan 11
- Nebraska 11
- Arkansas 9
- North Carolina 9
- North Dakota 9
- Oklahoma 9
- Illinois 8
- South Dakota 8
- Alabama 7
- Indiana 5
- Montana 5
- Pennsylvania 5
- West Virginia 5
- South Carolina 4
- Wyoming 4
- Florida 3
- Maine 3
- Oregon 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501320 | 2501320 | 2022-05-13 | Polk | Nebraska | 31143 | 1198 | 18 |
2474647 | 2474647 | 2022-05-05 | Cameron | Louisiana | 22023 | 1198 | 8 |
2470555 | 2470555 | 2022-05-04 | Saguache | Colorado | 8109 | 1198 | 12 |
2471390 | 2471390 | 2022-05-04 | Cameron | Louisiana | 22023 | 1198 | 8 |
2468134 | 2468134 | 2022-05-03 | Cameron | Louisiana | 22023 | 1198 | 8 |
2464879 | 2464879 | 2022-05-02 | Cameron | Louisiana | 22023 | 1198 | 8 |
2461623 | 2461623 | 2022-05-01 | Cameron | Louisiana | 22023 | 1198 | 8 |
2458367 | 2458367 | 2022-04-30 | Cameron | Louisiana | 22023 | 1198 | 8 |
2455111 | 2455111 | 2022-04-29 | Cameron | Louisiana | 22023 | 1198 | 8 |
2451855 | 2451855 | 2022-04-28 | Cameron | Louisiana | 22023 | 1198 | 8 |
2452419 | 2452419 | 2022-04-28 | Dixon | Nebraska | 31051 | 1198 | 11 |
2448599 | 2448599 | 2022-04-27 | Cameron | Louisiana | 22023 | 1198 | 8 |
2445343 | 2445343 | 2022-04-26 | Cameron | Louisiana | 22023 | 1198 | 8 |
2442087 | 2442087 | 2022-04-25 | Cameron | Louisiana | 22023 | 1198 | 8 |
2438831 | 2438831 | 2022-04-24 | Cameron | Louisiana | 22023 | 1198 | 8 |
2435575 | 2435575 | 2022-04-23 | Cameron | Louisiana | 22023 | 1198 | 8 |
2432319 | 2432319 | 2022-04-22 | Cameron | Louisiana | 22023 | 1198 | 8 |
2429063 | 2429063 | 2022-04-21 | Cameron | Louisiana | 22023 | 1198 | 8 |
2425807 | 2425807 | 2022-04-20 | Cameron | Louisiana | 22023 | 1198 | 8 |
2422551 | 2422551 | 2022-04-19 | Cameron | Louisiana | 22023 | 1198 | 8 |
2419295 | 2419295 | 2022-04-18 | Cameron | Louisiana | 22023 | 1198 | 8 |
2416039 | 2416039 | 2022-04-17 | Cameron | Louisiana | 22023 | 1198 | 8 |
2412783 | 2412783 | 2022-04-16 | Cameron | Louisiana | 22023 | 1198 | 8 |
2409527 | 2409527 | 2022-04-15 | Cameron | Louisiana | 22023 | 1198 | 8 |
2406271 | 2406271 | 2022-04-14 | Cameron | Louisiana | 22023 | 1198 | 8 |
2403015 | 2403015 | 2022-04-13 | Cameron | Louisiana | 22023 | 1198 | 8 |
2399761 | 2399761 | 2022-04-12 | Cameron | Louisiana | 22023 | 1198 | 8 |
2396505 | 2396505 | 2022-04-11 | Cameron | Louisiana | 22023 | 1198 | 8 |
2393250 | 2393250 | 2022-04-10 | Cameron | Louisiana | 22023 | 1198 | 8 |
2389994 | 2389994 | 2022-04-09 | Cameron | Louisiana | 22023 | 1198 | 8 |
2386738 | 2386738 | 2022-04-08 | Cameron | Louisiana | 22023 | 1198 | 8 |
2383483 | 2383483 | 2022-04-07 | Cameron | Louisiana | 22023 | 1198 | 8 |
2380228 | 2380228 | 2022-04-06 | Cameron | Louisiana | 22023 | 1198 | 8 |
2376973 | 2376973 | 2022-04-05 | Cameron | Louisiana | 22023 | 1198 | 8 |
2378557 | 2378557 | 2022-04-05 | Goliad | Texas | 48175 | 1198 | 32 |
2373721 | 2373721 | 2022-04-04 | Cameron | Louisiana | 22023 | 1198 | 8 |
2370468 | 2370468 | 2022-04-03 | Cameron | Louisiana | 22023 | 1198 | 8 |
2367215 | 2367215 | 2022-04-02 | Cameron | Louisiana | 22023 | 1198 | 8 |
2363962 | 2363962 | 2022-04-01 | Cameron | Louisiana | 22023 | 1198 | 8 |
2360708 | 2360708 | 2022-03-31 | Cameron | Louisiana | 22023 | 1198 | 8 |
2357454 | 2357454 | 2022-03-30 | Cameron | Louisiana | 22023 | 1198 | 8 |
2354201 | 2354201 | 2022-03-29 | Cameron | Louisiana | 22023 | 1198 | 8 |
2350949 | 2350949 | 2022-03-28 | Cameron | Louisiana | 22023 | 1198 | 8 |
2347696 | 2347696 | 2022-03-27 | Cameron | Louisiana | 22023 | 1198 | 8 |
2344443 | 2344443 | 2022-03-26 | Cameron | Louisiana | 22023 | 1198 | 8 |
2341190 | 2341190 | 2022-03-25 | Cameron | Louisiana | 22023 | 1198 | 8 |
2337937 | 2337937 | 2022-03-24 | Cameron | Louisiana | 22023 | 1198 | 8 |
2334683 | 2334683 | 2022-03-23 | Cameron | Louisiana | 22023 | 1198 | 8 |
2331429 | 2331429 | 2022-03-22 | Cameron | Louisiana | 22023 | 1198 | 8 |
2328177 | 2328177 | 2022-03-21 | Cameron | Louisiana | 22023 | 1198 | 8 |
2324924 | 2324924 | 2022-03-20 | Cameron | Louisiana | 22023 | 1198 | 8 |
2321670 | 2321670 | 2022-03-19 | Cameron | Louisiana | 22023 | 1198 | 8 |
2318416 | 2318416 | 2022-03-18 | Cameron | Louisiana | 22023 | 1198 | 8 |
2315163 | 2315163 | 2022-03-17 | Cameron | Louisiana | 22023 | 1198 | 8 |
2311910 | 2311910 | 2022-03-16 | Cameron | Louisiana | 22023 | 1198 | 8 |
2308657 | 2308657 | 2022-03-15 | Cameron | Louisiana | 22023 | 1198 | 8 |
2305406 | 2305406 | 2022-03-14 | Cameron | Louisiana | 22023 | 1198 | 8 |
2256861 | 2256861 | 2022-02-27 | Lincoln | Minnesota | 27081 | 1198 | 6 |
2253610 | 2253610 | 2022-02-26 | Lincoln | Minnesota | 27081 | 1198 | 6 |
2250359 | 2250359 | 2022-02-25 | Lincoln | Minnesota | 27081 | 1198 | 6 |
2247108 | 2247108 | 2022-02-24 | Lincoln | Minnesota | 27081 | 1198 | 6 |
2240606 | 2240606 | 2022-02-22 | Lincoln | Minnesota | 27081 | 1198 | 6 |
2237355 | 2237355 | 2022-02-21 | Lincoln | Minnesota | 27081 | 1198 | 6 |
2238947 | 2238947 | 2022-02-21 | Cumberland | Virginia | 51049 | 1198 | 22 |
2234104 | 2234104 | 2022-02-20 | Lincoln | Minnesota | 27081 | 1198 | 6 |
2230853 | 2230853 | 2022-02-19 | Lincoln | Minnesota | 27081 | 1198 | 6 |
2227602 | 2227602 | 2022-02-18 | Lincoln | Minnesota | 27081 | 1198 | 6 |
2203238 | 2203238 | 2022-02-10 | Norton city | Virginia | 51720 | 1198 | 21 |
2192122 | 2192122 | 2022-02-07 | Toole | Montana | 30101 | 1198 | 22 |
2172606 | 2172606 | 2022-02-01 | Teton | Montana | 30099 | 1198 | 18 |
2168276 | 2168276 | 2022-01-31 | Lemhi | Idaho | 16059 | 1198 | 25 |
2150693 | 2150693 | 2022-01-25 | Walworth | South Dakota | 46129 | 1198 | 20 |
2127431 | 2127431 | 2022-01-18 | Ransom | North Dakota | 38073 | 1198 | 23 |
2122732 | 2122732 | 2022-01-17 | Power | Idaho | 16077 | 1198 | 17 |
2119480 | 2119480 | 2022-01-16 | Power | Idaho | 16077 | 1198 | 17 |
2116228 | 2116228 | 2022-01-15 | Power | Idaho | 16077 | 1198 | 17 |
2112977 | 2112977 | 2022-01-14 | Power | Idaho | 16077 | 1198 | 17 |
2109725 | 2109725 | 2022-01-13 | Power | Idaho | 16077 | 1198 | 17 |
2107571 | 2107571 | 2022-01-12 | Dawes | Nebraska | 31045 | 1198 | 21 |
2108348 | 2108348 | 2022-01-12 | Brule | South Dakota | 46015 | 1198 | 18 |
2097846 | 2097846 | 2022-01-09 | Keith | Nebraska | 31101 | 1198 | 12 |
2094594 | 2094594 | 2022-01-08 | Keith | Nebraska | 31101 | 1198 | 12 |
2091342 | 2091342 | 2022-01-07 | Keith | Nebraska | 31101 | 1198 | 12 |
2086127 | 2086127 | 2022-01-05 | Middlesex | Virginia | 51119 | 1198 | 34 |
2081882 | 2081882 | 2022-01-04 | Dickey | North Dakota | 38021 | 1198 | 38 |
2076773 | 2076773 | 2022-01-03 | Montgomery | Arkansas | 5097 | 1198 | 53 |
2075752 | 2075752 | 2022-01-02 | Penuelas | Puerto Rico | 72111 | 1198 | |
2058429 | 2058429 | 2021-12-28 | Schoolcraft | Michigan | 26153 | 1198 | 8 |
2055180 | 2055180 | 2021-12-27 | Schoolcraft | Michigan | 26153 | 1198 | 8 |
2028334 | 2028334 | 2021-12-19 | Jenkins | Georgia | 13165 | 1198 | 61 |
2025083 | 2025083 | 2021-12-18 | Jenkins | Georgia | 13165 | 1198 | 61 |
2021832 | 2021832 | 2021-12-17 | Jenkins | Georgia | 13165 | 1198 | 61 |
2018581 | 2018581 | 2021-12-16 | Jenkins | Georgia | 13165 | 1198 | 61 |
2019044 | 2019044 | 2021-12-16 | Harper | Kansas | 20077 | 1198 | 25 |
2019354 | 2019354 | 2021-12-16 | Alger | Michigan | 26003 | 1198 | 9 |
2015331 | 2015331 | 2021-12-15 | Jenkins | Georgia | 13165 | 1198 | 60 |
2015794 | 2015794 | 2021-12-15 | Harper | Kansas | 20077 | 1198 | 25 |
2016104 | 2016104 | 2021-12-15 | Alger | Michigan | 26003 | 1198 | 9 |
2012080 | 2012080 | 2021-12-14 | Jenkins | Georgia | 13165 | 1198 | 60 |
2008829 | 2008829 | 2021-12-13 | Jenkins | Georgia | 13165 | 1198 | 60 |
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);