ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
304 rows where cases = 2219 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 28
- Kansas 20
- Missouri 18
- Georgia 15
- North Carolina 14
- Alabama 12
- Florida 12
- Kentucky 12
- Tennessee 12
- Virginia 12
- Michigan 11
- Mississippi 10
- Puerto Rico 10
- Iowa 9
- Minnesota 9
- South Carolina 9
- Arkansas 8
- Colorado 8
- Illinois 8
- Indiana 7
- Pennsylvania 7
- Idaho 6
- Louisiana 6
- Ohio 6
- Utah 5
- Wisconsin 5
- Nebraska 4
- Maine 3
- New York 3
- Washington 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500487 | 2500487 | 2022-05-13 | Cloud | Kansas | 20029 | 2219 | 36 |
2497229 | 2497229 | 2022-05-12 | Cloud | Kansas | 20029 | 2219 | 36 |
2499406 | 2499406 | 2022-05-12 | Lincoln | Washington | 53043 | 2219 | 28 |
2493971 | 2493971 | 2022-05-11 | Cloud | Kansas | 20029 | 2219 | 36 |
2496148 | 2496148 | 2022-05-11 | Lincoln | Washington | 53043 | 2219 | 28 |
2490713 | 2490713 | 2022-05-10 | Cloud | Kansas | 20029 | 2219 | 36 |
2491053 | 2491053 | 2022-05-10 | Baraga | Michigan | 26013 | 2219 | 54 |
2487456 | 2487456 | 2022-05-09 | Cloud | Kansas | 20029 | 2219 | 36 |
2487796 | 2487796 | 2022-05-09 | Baraga | Michigan | 26013 | 2219 | 54 |
2484198 | 2484198 | 2022-05-08 | Cloud | Kansas | 20029 | 2219 | 36 |
2484538 | 2484538 | 2022-05-08 | Baraga | Michigan | 26013 | 2219 | 54 |
2480940 | 2480940 | 2022-05-07 | Cloud | Kansas | 20029 | 2219 | 36 |
2481280 | 2481280 | 2022-05-07 | Baraga | Michigan | 26013 | 2219 | 54 |
2477682 | 2477682 | 2022-05-06 | Cloud | Kansas | 20029 | 2219 | 36 |
2478022 | 2478022 | 2022-05-06 | Baraga | Michigan | 26013 | 2219 | 54 |
2474424 | 2474424 | 2022-05-05 | Cloud | Kansas | 20029 | 2219 | 36 |
2474764 | 2474764 | 2022-05-05 | Baraga | Michigan | 26013 | 2219 | 54 |
2471167 | 2471167 | 2022-05-04 | Cloud | Kansas | 20029 | 2219 | 36 |
2471507 | 2471507 | 2022-05-04 | Baraga | Michigan | 26013 | 2219 | 54 |
2467911 | 2467911 | 2022-05-03 | Cloud | Kansas | 20029 | 2219 | 36 |
2468961 | 2468961 | 2022-05-03 | Jones | North Carolina | 37103 | 2219 | 38 |
2464656 | 2464656 | 2022-05-02 | Cloud | Kansas | 20029 | 2219 | 36 |
2465705 | 2465705 | 2022-05-02 | Jones | North Carolina | 37103 | 2219 | 38 |
2461400 | 2461400 | 2022-05-01 | Cloud | Kansas | 20029 | 2219 | 36 |
2462450 | 2462450 | 2022-05-01 | Jones | North Carolina | 37103 | 2219 | 38 |
2458144 | 2458144 | 2022-04-30 | Cloud | Kansas | 20029 | 2219 | 36 |
2459194 | 2459194 | 2022-04-30 | Jones | North Carolina | 37103 | 2219 | 38 |
2454888 | 2454888 | 2022-04-29 | Cloud | Kansas | 20029 | 2219 | 36 |
2455938 | 2455938 | 2022-04-29 | Jones | North Carolina | 37103 | 2219 | 38 |
2452682 | 2452682 | 2022-04-28 | Jones | North Carolina | 37103 | 2219 | 38 |
2449426 | 2449426 | 2022-04-27 | Jones | North Carolina | 37103 | 2219 | 38 |
2345702 | 2345702 | 2022-03-26 | Penuelas | Puerto Rico | 72111 | 2219 | |
2329498 | 2329498 | 2022-03-21 | McCormick | South Carolina | 45065 | 2219 | 38 |
2326246 | 2326246 | 2022-03-20 | McCormick | South Carolina | 45065 | 2219 | 38 |
2322993 | 2322993 | 2022-03-19 | McCormick | South Carolina | 45065 | 2219 | 38 |
2319739 | 2319739 | 2022-03-18 | McCormick | South Carolina | 45065 | 2219 | 38 |
2316485 | 2316485 | 2022-03-17 | McCormick | South Carolina | 45065 | 2219 | 38 |
2313232 | 2313232 | 2022-03-16 | McCormick | South Carolina | 45065 | 2219 | 38 |
2309979 | 2309979 | 2022-03-15 | McCormick | South Carolina | 45065 | 2219 | 38 |
2310070 | 2310070 | 2022-03-15 | Clay | Tennessee | 47027 | 2219 | 47 |
2306817 | 2306817 | 2022-03-14 | Clay | Tennessee | 47027 | 2219 | 47 |
2303566 | 2303566 | 2022-03-13 | Clay | Tennessee | 47027 | 2219 | 47 |
2300314 | 2300314 | 2022-03-12 | Clay | Tennessee | 47027 | 2219 | 47 |
2297062 | 2297062 | 2022-03-11 | Clay | Tennessee | 47027 | 2219 | 47 |
2293661 | 2293661 | 2022-03-10 | Sabana Grande | Puerto Rico | 72121 | 2219 | |
2293719 | 2293719 | 2022-03-10 | McCormick | South Carolina | 45065 | 2219 | 38 |
2293810 | 2293810 | 2022-03-10 | Clay | Tennessee | 47027 | 2219 | 47 |
2294417 | 2294417 | 2022-03-10 | Webster | West Virginia | 54101 | 2219 | 29 |
2290558 | 2290558 | 2022-03-09 | Clay | Tennessee | 47027 | 2219 | 47 |
2283024 | 2283024 | 2022-03-07 | Carroll | Missouri | 29033 | 2219 | 42 |
2279771 | 2279771 | 2022-03-06 | Carroll | Missouri | 29033 | 2219 | 42 |
2276518 | 2276518 | 2022-03-05 | Carroll | Missouri | 29033 | 2219 | 42 |
2273265 | 2273265 | 2022-03-04 | Carroll | Missouri | 29033 | 2219 | 42 |
2270013 | 2270013 | 2022-03-03 | Carroll | Missouri | 29033 | 2219 | 42 |
2265548 | 2265548 | 2022-03-02 | San Miguel | Colorado | 8113 | 2219 | 8 |
2266760 | 2266760 | 2022-03-02 | Carroll | Missouri | 29033 | 2219 | 42 |
2263509 | 2263509 | 2022-03-01 | Carroll | Missouri | 29033 | 2219 | 42 |
2256087 | 2256087 | 2022-02-27 | Owyhee | Idaho | 16073 | 2219 | 49 |
2252836 | 2252836 | 2022-02-26 | Owyhee | Idaho | 16073 | 2219 | 49 |
2249585 | 2249585 | 2022-02-25 | Owyhee | Idaho | 16073 | 2219 | 49 |
2251811 | 2251811 | 2022-02-25 | Red River | Texas | 48387 | 2219 | 64 |
2238280 | 2238280 | 2022-02-21 | Forest | Pennsylvania | 42053 | 2219 | 34 |
2238952 | 2238952 | 2022-02-21 | Essex | Virginia | 51057 | 2219 | 26 |
2235029 | 2235029 | 2022-02-20 | Forest | Pennsylvania | 42053 | 2219 | 34 |
2231778 | 2231778 | 2022-02-19 | Forest | Pennsylvania | 42053 | 2219 | 34 |
2222558 | 2222558 | 2022-02-16 | Runnels | Texas | 48399 | 2219 | 62 |
2216604 | 2216604 | 2022-02-15 | Cleveland | Arkansas | 5025 | 2219 | 33 |
2212869 | 2212869 | 2022-02-13 | Grand | Utah | 49019 | 2219 | 6 |
2209616 | 2209616 | 2022-02-12 | Grand | Utah | 49019 | 2219 | 6 |
2206363 | 2206363 | 2022-02-11 | Grand | Utah | 49019 | 2219 | 6 |
2194187 | 2194187 | 2022-02-08 | Lanier | Georgia | 13173 | 2219 | 19 |
2174724 | 2174724 | 2022-02-02 | Towns | Georgia | 13281 | 2219 | 94 |
2177220 | 2177220 | 2022-02-02 | Poquoson city | Virginia | 51735 | 2219 | 24 |
2168886 | 2168886 | 2022-01-31 | Piscataquis | Maine | 23021 | 2219 | 25 |
2165631 | 2165631 | 2022-01-30 | Piscataquis | Maine | 23021 | 2219 | 25 |
2162376 | 2162376 | 2022-01-29 | Piscataquis | Maine | 23021 | 2219 | 25 |
2159535 | 2159535 | 2022-01-28 | Wayne | Missouri | 29223 | 2219 | 42 |
2157031 | 2157031 | 2022-01-27 | Florida | Puerto Rico | 72054 | 2219 | |
2150829 | 2150829 | 2022-01-25 | Childress | Texas | 48075 | 2219 | 26 |
2076765 | 2076765 | 2022-01-03 | Little River | Arkansas | 5081 | 2219 | 84 |
2034832 | 2034832 | 2021-12-21 | Jasper | Georgia | 13159 | 2219 | 59 |
2016389 | 2016389 | 2021-12-15 | Dent | Missouri | 29065 | 2219 | 63 |
2006560 | 2006560 | 2021-12-12 | Lawrence | Mississippi | 28077 | 2219 | 43 |
2003309 | 2003309 | 2021-12-11 | Lawrence | Mississippi | 28077 | 2219 | 43 |
2000059 | 2000059 | 2021-12-10 | Lawrence | Mississippi | 28077 | 2219 | 43 |
1996808 | 1996808 | 2021-12-09 | Lawrence | Mississippi | 28077 | 2219 | 42 |
1998038 | 1998038 | 2021-12-09 | Dawson | Texas | 48115 | 2219 | 80 |
1987568 | 1987568 | 2021-12-06 | Mitchell | North Carolina | 37121 | 2219 | 24 |
1987725 | 1987725 | 2021-12-06 | Noble | Ohio | 39121 | 2219 | 49 |
1972045 | 1972045 | 2021-12-01 | Eastland | Texas | 48133 | 2219 | 82 |
1946477 | 1946477 | 2021-11-23 | Monroe | West Virginia | 54063 | 2219 | 27 |
1930024 | 1930024 | 2021-11-18 | Alleghany | Virginia | 51005 | 2219 | 82 |
1915206 | 1915206 | 2021-11-14 | Trigg | Kentucky | 21221 | 2219 | 23 |
1911956 | 1911956 | 2021-11-13 | Trigg | Kentucky | 21221 | 2219 | 23 |
1908707 | 1908707 | 2021-11-12 | Trigg | Kentucky | 21221 | 2219 | 23 |
1904701 | 1904701 | 2021-11-11 | Lafayette | Florida | 12067 | 2219 | 51 |
1901451 | 1901451 | 2021-11-10 | Lafayette | Florida | 12067 | 2219 | 51 |
1898201 | 1898201 | 2021-11-09 | Lafayette | Florida | 12067 | 2219 | 51 |
1898345 | 1898345 | 2021-11-09 | Oglethorpe | Georgia | 13221 | 2219 | 42 |
1894951 | 1894951 | 2021-11-08 | Lafayette | Florida | 12067 | 2219 | 51 |
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);