ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
127 rows where cases = 4885 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Oklahoma 14
- Georgia 12
- Missouri 10
- Illinois 9
- Texas 9
- Pennsylvania 6
- Kansas 5
- Washington 5
- California 4
- Kentucky 4
- Michigan 4
- Minnesota 4
- North Carolina 4
- Virginia 4
- Ohio 3
- Puerto Rico 3
- Alabama 2
- Arkansas 2
- Colorado 2
- Indiana 2
- New Mexico 2
- New York 2
- North Dakota 2
- South Carolina 2
- Tennessee 2
- Idaho 1
- Iowa 1
- Louisiana 1
- Maryland 1
- Mississippi 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2496930 | 2496930 | 2022-05-12 | Clark | Illinois | 17023 | 4885 | 60 |
2490335 | 2490335 | 2022-05-10 | Union | Georgia | 13291 | 4885 | 159 |
2487078 | 2487078 | 2022-05-09 | Union | Georgia | 13291 | 4885 | 159 |
2483820 | 2483820 | 2022-05-08 | Union | Georgia | 13291 | 4885 | 159 |
2484638 | 2484638 | 2022-05-08 | Fillmore | Minnesota | 27045 | 4885 | 24 |
2480562 | 2480562 | 2022-05-07 | Union | Georgia | 13291 | 4885 | 159 |
2481380 | 2481380 | 2022-05-07 | Fillmore | Minnesota | 27045 | 4885 | 24 |
2477304 | 2477304 | 2022-05-06 | Union | Georgia | 13291 | 4885 | 159 |
2478122 | 2478122 | 2022-05-06 | Fillmore | Minnesota | 27045 | 4885 | 24 |
2474046 | 2474046 | 2022-05-05 | Union | Georgia | 13291 | 4885 | 159 |
2470789 | 2470789 | 2022-05-04 | Union | Georgia | 13291 | 4885 | 159 |
2453669 | 2453669 | 2022-04-28 | Buchanan | Virginia | 51027 | 4885 | 120 |
2381299 | 2381299 | 2022-04-06 | McIntosh | Oklahoma | 40091 | 4885 | 123 |
2378044 | 2378044 | 2022-04-05 | McIntosh | Oklahoma | 40091 | 4885 | 123 |
2374790 | 2374790 | 2022-04-04 | McIntosh | Oklahoma | 40091 | 4885 | 123 |
2371538 | 2371538 | 2022-04-03 | McIntosh | Oklahoma | 40091 | 4885 | 123 |
2368285 | 2368285 | 2022-04-02 | McIntosh | Oklahoma | 40091 | 4885 | 123 |
2365032 | 2365032 | 2022-04-01 | McIntosh | Oklahoma | 40091 | 4885 | 123 |
2360038 | 2360038 | 2022-03-31 | Hart | Georgia | 13147 | 4885 | 90 |
2361779 | 2361779 | 2022-03-31 | McIntosh | Oklahoma | 40091 | 4885 | 123 |
2311204 | 2311204 | 2022-03-16 | Cook | Georgia | 13075 | 4885 | 70 |
2312980 | 2312980 | 2022-03-16 | McIntosh | Oklahoma | 40091 | 4885 | 118 |
2309727 | 2309727 | 2022-03-15 | McIntosh | Oklahoma | 40091 | 4885 | 118 |
2306474 | 2306474 | 2022-03-14 | McIntosh | Oklahoma | 40091 | 4885 | 118 |
2303223 | 2303223 | 2022-03-13 | McIntosh | Oklahoma | 40091 | 4885 | 118 |
2299971 | 2299971 | 2022-03-12 | McIntosh | Oklahoma | 40091 | 4885 | 118 |
2296719 | 2296719 | 2022-03-11 | McIntosh | Oklahoma | 40091 | 4885 | 118 |
2293467 | 2293467 | 2022-03-10 | McIntosh | Oklahoma | 40091 | 4885 | 118 |
2259518 | 2259518 | 2022-02-28 | Rush | Indiana | 18139 | 4885 | 56 |
2248711 | 2248711 | 2022-02-24 | Fluvanna | Virginia | 51065 | 4885 | 39 |
2234698 | 2234698 | 2022-02-20 | Madison | North Carolina | 37115 | 4885 | 78 |
2230795 | 2230795 | 2022-02-19 | Osceola | Michigan | 26133 | 4885 | 73 |
2231447 | 2231447 | 2022-02-19 | Madison | North Carolina | 37115 | 4885 | 78 |
2227544 | 2227544 | 2022-02-18 | Osceola | Michigan | 26133 | 4885 | 73 |
2228196 | 2228196 | 2022-02-18 | Madison | North Carolina | 37115 | 4885 | 78 |
2224086 | 2224086 | 2022-02-17 | Rockcastle | Kentucky | 21203 | 4885 | 51 |
2224293 | 2224293 | 2022-02-17 | Osceola | Michigan | 26133 | 4885 | 73 |
2221042 | 2221042 | 2022-02-16 | Osceola | Michigan | 26133 | 4885 | 73 |
2199886 | 2199886 | 2022-02-09 | Orleans | Vermont | 50019 | 4885 | 33 |
2164011 | 2164011 | 2022-01-29 | San Jacinto | Texas | 48407 | 4885 | 90 |
2154864 | 2154864 | 2022-01-27 | Del Norte | California | 6015 | 4885 | 43 |
2139928 | 2139928 | 2022-01-22 | Crawford | Missouri | 29055 | 4885 | 87 |
2123351 | 2123351 | 2022-01-17 | Garrett | Maryland | 24023 | 4885 | 102 |
2117983 | 2117983 | 2022-01-15 | Cayey | Puerto Rico | 72035 | 4885 | |
2099636 | 2099636 | 2022-01-10 | Delta | Colorado | 8029 | 4885 | 123 |
1993921 | 1993921 | 2021-12-08 | Cibola | New Mexico | 35006 | 4885 | 152 |
1969531 | 1969531 | 2021-12-01 | St. Francis | Arkansas | 5123 | 4885 | 69 |
1963368 | 1963368 | 2021-11-29 | Stephens | Georgia | 13257 | 4885 | 120 |
1915021 | 1915021 | 2021-11-14 | Geary | Kansas | 20061 | 4885 | 58 |
1911771 | 1911771 | 2021-11-13 | Geary | Kansas | 20061 | 4885 | 58 |
1908522 | 1908522 | 2021-11-12 | Geary | Kansas | 20061 | 4885 | 58 |
1896916 | 1896916 | 2021-11-08 | Snyder | Pennsylvania | 42109 | 4885 | 106 |
1874914 | 1874914 | 2021-11-01 | Clallam | Washington | 53009 | 4885 | 61 |
1844730 | 1844730 | 2021-10-23 | Ottawa | Ohio | 39123 | 4885 | 86 |
1836813 | 1836813 | 2021-10-21 | Adams | Indiana | 18001 | 4885 | 77 |
1839159 | 1839159 | 2021-10-21 | Warren | Virginia | 51187 | 4885 | 83 |
1816448 | 1816448 | 2021-10-14 | Okanogan | Washington | 53047 | 4885 | 72 |
1802225 | 1802225 | 2021-10-10 | Columbia | New York | 36021 | 4885 | 111 |
1798728 | 1798728 | 2021-10-09 | Warren | Missouri | 29219 | 4885 | 43 |
1791699 | 1791699 | 2021-10-07 | Marshall | Kentucky | 21157 | 4885 | 75 |
1770192 | 1770192 | 2021-09-30 | Pike | Pennsylvania | 42103 | 4885 | 57 |
1765676 | 1765676 | 2021-09-29 | Harlan | Kentucky | 21095 | 4885 | 114 |
1746919 | 1746919 | 2021-09-23 | Cheshire | New Hampshire | 33005 | 4885 | 44 |
1710069 | 1710069 | 2021-09-12 | Morgan | Illinois | 17137 | 4885 | 117 |
1706822 | 1706822 | 2021-09-11 | Morgan | Illinois | 17137 | 4885 | 117 |
1707705 | 1707705 | 2021-09-11 | Lawrence | Missouri | 29109 | 4885 | 100 |
1703574 | 1703574 | 2021-09-10 | Morgan | Illinois | 17137 | 4885 | 117 |
1689514 | 1689514 | 2021-09-05 | Upshur | Texas | 48459 | 4885 | 91 |
1675742 | 1675742 | 2021-09-01 | Defiance | Ohio | 39039 | 4885 | 100 |
1619986 | 1619986 | 2021-08-15 | Howell | Missouri | 29091 | 4885 | 53 |
1609095 | 1609095 | 2021-08-12 | Baldwin | Georgia | 13009 | 4885 | 137 |
1605160 | 1605160 | 2021-08-10 | Culpeper | Virginia | 51047 | 4885 | 69 |
1574816 | 1574816 | 2021-08-01 | Clinton | New York | 36019 | 4885 | 33 |
1515069 | 1515069 | 2021-07-14 | Bingham | Idaho | 16011 | 4885 | 77 |
1508717 | 1508717 | 2021-07-12 | Woodford | Illinois | 17203 | 4885 | 96 |
1477948 | 1477948 | 2021-07-02 | Toa Baja | Puerto Rico | 72137 | 4885 | |
1473218 | 1473218 | 2021-07-01 | Crawford | Kansas | 20037 | 4885 | 83 |
1474702 | 1474702 | 2021-07-01 | Toa Baja | Puerto Rico | 72137 | 4885 | |
1469972 | 1469972 | 2021-06-30 | Crawford | Kansas | 20037 | 4885 | 83 |
1453698 | 1453698 | 2021-06-25 | Muscatine | Iowa | 19139 | 4885 | 106 |
1420589 | 1420589 | 2021-06-15 | Nevada | California | 6057 | 4885 | 75 |
1382082 | 1382082 | 2021-06-03 | Livingston | Illinois | 17105 | 4885 | 100 |
1382600 | 1382600 | 2021-06-03 | St. Mary | Louisiana | 22101 | 4885 | 140 |
1370874 | 1370874 | 2021-05-30 | Chesterfield | South Carolina | 45025 | 4885 | 105 |
1367628 | 1367628 | 2021-05-29 | Chesterfield | South Carolina | 45025 | 4885 | 105 |
1350022 | 1350022 | 2021-05-24 | Henderson | Kentucky | 21101 | 4885 | 75 |
1336003 | 1336003 | 2021-05-20 | Dale | Alabama | 1045 | 4885 | 113 |
1332756 | 1332756 | 2021-05-19 | Dale | Alabama | 1045 | 4885 | 113 |
1328007 | 1328007 | 2021-05-17 | Elko | Nevada | 32007 | 4885 | 56 |
1325718 | 1325718 | 2021-05-16 | Harrison | Texas | 48203 | 4885 | 109 |
1277496 | 1277496 | 2021-05-01 | Pierce | Wisconsin | 55093 | 4885 | 42 |
1269635 | 1269635 | 2021-04-29 | Otero | New Mexico | 35035 | 4885 | 75 |
1239074 | 1239074 | 2021-04-20 | Murray | Georgia | 13213 | 4885 | 82 |
1199452 | 1199452 | 2021-04-07 | Walla Walla | Washington | 53071 | 4885 | 64 |
1089346 | 1089346 | 2021-03-05 | Hot Spring | Arkansas | 5059 | 4885 | 66 |
1085437 | 1085437 | 2021-03-03 | Hardin | Texas | 48199 | 4885 | 95 |
1082191 | 1082191 | 2021-03-02 | Hardin | Texas | 48199 | 4885 | 95 |
1078498 | 1078498 | 2021-03-01 | Carbon | Pennsylvania | 42025 | 4885 | 151 |
1078945 | 1078945 | 2021-03-01 | Hardin | Texas | 48199 | 4885 | 94 |
1075700 | 1075700 | 2021-02-28 | Hardin | Texas | 48199 | 4885 | 94 |
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);