ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
121 rows where cases = 4733 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Illinois 18
- Texas 13
- Indiana 6
- Kentucky 6
- Minnesota 6
- Missouri 6
- Ohio 6
- Wisconsin 6
- Arkansas 4
- Georgia 4
- Alabama 3
- Connecticut 3
- Michigan 3
- Mississippi 3
- North Carolina 3
- Wyoming 3
- Idaho 2
- Kansas 2
- Louisiana 2
- Maine 2
- New York 2
- Pennsylvania 2
- Virginia 2
- West Virginia 2
- California 1
- Colorado 1
- Florida 1
- Iowa 1
- Maryland 1
- Nebraska 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2489833 | 2489833 | 2022-05-10 | Hale | Alabama | 1065 | 4733 | 106 |
2486576 | 2486576 | 2022-05-09 | Hale | Alabama | 1065 | 4733 | 106 |
2418774 | 2418774 | 2022-04-18 | Clay | Illinois | 17025 | 4733 | 73 |
2415518 | 2415518 | 2022-04-17 | Clay | Illinois | 17025 | 4733 | 73 |
2412262 | 2412262 | 2022-04-16 | Clay | Illinois | 17025 | 4733 | 73 |
2409006 | 2409006 | 2022-04-15 | Clay | Illinois | 17025 | 4733 | 73 |
2395985 | 2395985 | 2022-04-11 | Clay | Illinois | 17025 | 4733 | 73 |
2392729 | 2392729 | 2022-04-10 | Clay | Illinois | 17025 | 4733 | 73 |
2389473 | 2389473 | 2022-04-09 | Clay | Illinois | 17025 | 4733 | 73 |
2386218 | 2386218 | 2022-04-08 | Clay | Illinois | 17025 | 4733 | 73 |
2379708 | 2379708 | 2022-04-06 | Clay | Illinois | 17025 | 4733 | 73 |
2376454 | 2376454 | 2022-04-05 | Clay | Illinois | 17025 | 4733 | 73 |
2373202 | 2373202 | 2022-04-04 | Clay | Illinois | 17025 | 4733 | 73 |
2369949 | 2369949 | 2022-04-03 | Clay | Illinois | 17025 | 4733 | 73 |
2366696 | 2366696 | 2022-04-02 | Clay | Illinois | 17025 | 4733 | 73 |
2363443 | 2363443 | 2022-04-01 | Clay | Illinois | 17025 | 4733 | 73 |
2325141 | 2325141 | 2022-03-20 | Fillmore | Minnesota | 27045 | 4733 | 24 |
2325291 | 2325291 | 2022-03-20 | Andrew | Missouri | 29003 | 4733 | 56 |
2321887 | 2321887 | 2022-03-19 | Fillmore | Minnesota | 27045 | 4733 | 24 |
2322037 | 2322037 | 2022-03-19 | Andrew | Missouri | 29003 | 4733 | 56 |
2318633 | 2318633 | 2022-03-18 | Fillmore | Minnesota | 27045 | 4733 | 24 |
2318783 | 2318783 | 2022-03-18 | Andrew | Missouri | 29003 | 4733 | 56 |
2279298 | 2279298 | 2022-03-06 | Garrard | Kentucky | 21079 | 4733 | 71 |
2276045 | 2276045 | 2022-03-05 | Garrard | Kentucky | 21079 | 4733 | 71 |
2277706 | 2277706 | 2022-03-05 | Fayette | Texas | 48149 | 4733 | 99 |
2272792 | 2272792 | 2022-03-04 | Garrard | Kentucky | 21079 | 4733 | 71 |
2269552 | 2269552 | 2022-03-03 | Henry | Kentucky | 21103 | 4733 | 46 |
2262159 | 2262159 | 2022-03-01 | Phillips | Arkansas | 5107 | 4733 | 94 |
2217927 | 2217927 | 2022-02-15 | Jasper | Mississippi | 28061 | 4733 | 70 |
2190932 | 2190932 | 2022-02-07 | Lamar | Georgia | 13171 | 4733 | 105 |
2182589 | 2182589 | 2022-02-04 | Schoharie | New York | 36095 | 4733 | 33 |
2174924 | 2174924 | 2022-02-02 | Fulton | Indiana | 18049 | 4733 | 100 |
2148749 | 2148749 | 2022-01-25 | Jerome | Idaho | 16053 | 4733 | 58 |
2121999 | 2121999 | 2022-01-16 | Hampshire | West Virginia | 54027 | 4733 | 60 |
2107787 | 2107787 | 2022-01-12 | Anson | North Carolina | 37007 | 4733 | 86 |
2012291 | 2012291 | 2021-12-14 | Saline | Illinois | 17165 | 4733 | 90 |
2009101 | 2009101 | 2021-12-13 | Jennings | Indiana | 18079 | 4733 | 70 |
1969939 | 1969939 | 2021-12-01 | Latah | Idaho | 16057 | 4733 | 40 |
1955193 | 1955193 | 2021-11-26 | Hardin | Ohio | 39065 | 4733 | 99 |
1940870 | 1940870 | 2021-11-22 | Scott | Indiana | 18143 | 4733 | 80 |
1879471 | 1879471 | 2021-11-03 | Allen | Louisiana | 22003 | 4733 | 115 |
1872328 | 1872328 | 2021-11-01 | Lee | Georgia | 13177 | 4733 | 80 |
1857079 | 1857079 | 2021-10-27 | Prentiss | Mississippi | 28117 | 4733 | 82 |
1847712 | 1847712 | 2021-10-24 | Chenango | New York | 36017 | 4733 | 88 |
1831687 | 1831687 | 2021-10-19 | Coshocton | Ohio | 39031 | 4733 | 83 |
1793704 | 1793704 | 2021-10-07 | Okanogan | Washington | 53047 | 4733 | 64 |
1762047 | 1762047 | 2021-09-28 | Montgomery | Illinois | 17135 | 4733 | 82 |
1743262 | 1743262 | 2021-09-22 | Morrison | Minnesota | 27097 | 4733 | 63 |
1721270 | 1721270 | 2021-09-15 | Putnam | Ohio | 39137 | 4733 | 106 |
1681365 | 1681365 | 2021-09-03 | Calvert | Maryland | 24009 | 4733 | 90 |
1677090 | 1677090 | 2021-09-02 | Unknown | Arkansas | 4733 | 0 | |
1672328 | 1672328 | 2021-08-31 | Bladen | North Carolina | 37017 | 4733 | 73 |
1673225 | 1673225 | 2021-08-31 | Polk | Texas | 48373 | 4733 | 137 |
1669977 | 1669977 | 2021-08-30 | Polk | Texas | 48373 | 4733 | 137 |
1666730 | 1666730 | 2021-08-29 | Polk | Texas | 48373 | 4733 | 136 |
1663482 | 1663482 | 2021-08-28 | Polk | Texas | 48373 | 4733 | 136 |
1610171 | 1610171 | 2021-08-12 | Pontotoc | Mississippi | 28115 | 4733 | 74 |
1606208 | 1606208 | 2021-08-11 | Montgomery | Indiana | 18107 | 4733 | 95 |
1591310 | 1591310 | 2021-08-06 | Knox | Ohio | 39083 | 4733 | 112 |
1573117 | 1573117 | 2021-08-01 | Miller | Arkansas | 5091 | 4733 | 37 |
1566408 | 1566408 | 2021-07-29 | Marinette | Wisconsin | 55075 | 4733 | 75 |
1563160 | 1563160 | 2021-07-28 | Marinette | Wisconsin | 55075 | 4733 | 75 |
1536729 | 1536729 | 2021-07-20 | Howard | Texas | 48227 | 4733 | 102 |
1468715 | 1468715 | 2021-06-29 | Wasatch | Utah | 49051 | 4733 | 22 |
1445881 | 1445881 | 2021-06-22 | Medina | Texas | 48325 | 4733 | 107 |
1442636 | 1442636 | 2021-06-21 | Medina | Texas | 48325 | 4733 | 107 |
1439391 | 1439391 | 2021-06-20 | Medina | Texas | 48325 | 4733 | 107 |
1436144 | 1436144 | 2021-06-19 | Medina | Texas | 48325 | 4733 | 107 |
1429651 | 1429651 | 2021-06-17 | Medina | Texas | 48325 | 4733 | 107 |
1420321 | 1420321 | 2021-06-14 | Monroe | Wisconsin | 55081 | 4733 | 42 |
1379776 | 1379776 | 2021-06-02 | Scott | Missouri | 29201 | 4733 | 86 |
1376860 | 1376860 | 2021-06-01 | Chatham | North Carolina | 37037 | 4733 | 89 |
1363302 | 1363302 | 2021-05-28 | Douglas | Minnesota | 27041 | 4733 | 80 |
1361107 | 1361107 | 2021-05-27 | Toa Alta | Puerto Rico | 72135 | 4733 | |
1332687 | 1332687 | 2021-05-18 | Polk | Wisconsin | 55095 | 4733 | 60 |
1327543 | 1327543 | 2021-05-17 | Newaygo | Michigan | 26123 | 4733 | 62 |
1311178 | 1311178 | 2021-05-12 | St. Mary | Louisiana | 22101 | 4733 | 138 |
1307675 | 1307675 | 2021-05-11 | Crawford | Kansas | 20037 | 4733 | 83 |
1304429 | 1304429 | 2021-05-10 | Crawford | Kansas | 20037 | 4733 | 83 |
1300957 | 1300957 | 2021-05-09 | Stephenson | Illinois | 17177 | 4733 | 100 |
1283915 | 1283915 | 2021-05-03 | Mercer | West Virginia | 54055 | 4733 | 116 |
1279592 | 1279592 | 2021-05-02 | Stark | North Dakota | 38089 | 4733 | 51 |
1249867 | 1249867 | 2021-04-23 | Johnson | Missouri | 29101 | 4733 | 50 |
1240693 | 1240693 | 2021-04-20 | Mercer | Ohio | 39107 | 4733 | 85 |
1218571 | 1218571 | 2021-04-13 | Harrison | Texas | 48203 | 4733 | 105 |
1197613 | 1197613 | 2021-04-07 | Cass | Michigan | 26027 | 4733 | 69 |
1191054 | 1191054 | 2021-04-05 | Penobscot | Maine | 23019 | 4733 | 88 |
1183859 | 1183859 | 2021-04-03 | Murray | Georgia | 13213 | 4733 | 78 |
1167987 | 1167987 | 2021-03-29 | Marshall | Iowa | 19127 | 4733 | 74 |
1168219 | 1168219 | 2021-03-29 | Nelson | Kentucky | 21179 | 4733 | 50 |
1167108 | 1167108 | 2021-03-28 | Campbell | Wyoming | 56005 | 4733 | 59 |
1161171 | 1161171 | 2021-03-27 | Ware | Georgia | 13299 | 4733 | 157 |
1163860 | 1163860 | 2021-03-27 | Campbell | Wyoming | 56005 | 4733 | 59 |
1160612 | 1160612 | 2021-03-26 | Campbell | Wyoming | 56005 | 4733 | 59 |
1142160 | 1142160 | 2021-03-21 | Boyd | Kentucky | 21019 | 4733 | 64 |
1142846 | 1142846 | 2021-03-21 | Dodge | Nebraska | 31053 | 4733 | 56 |
1108457 | 1108457 | 2021-03-10 | Pittsylvania | Virginia | 51143 | 4733 | 70 |
1095646 | 1095646 | 2021-03-06 | Oconto | Wisconsin | 55083 | 4733 | 55 |
1069505 | 1069505 | 2021-02-26 | Pittsylvania | Virginia | 51143 | 4733 | 62 |
1061184 | 1061184 | 2021-02-24 | Androscoggin | Maine | 23001 | 4733 | 55 |
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);