ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
115 rows where cases = 5032 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 28
- Georgia 13
- Indiana 12
- North Carolina 11
- Idaho 9
- Florida 8
- Alabama 7
- Wisconsin 6
- Illinois 5
- Texas 5
- Kansas 4
- Pennsylvania 4
- Minnesota 3
- Missouri 3
- New York 3
- Ohio 3
- South Carolina 3
- Kentucky 2
- Tennessee 2
- Virginia 2
- Washington 2
- Arkansas 1
- Iowa 1
- Louisiana 1
- Maine 1
- Nebraska 1
- North Dakota 1
- Puerto Rico 1
- Vermont 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500148 | 2500148 | 2022-05-13 | Cassia | Idaho | 16031 | 5032 | 52 |
2496890 | 2496890 | 2022-05-12 | Cassia | Idaho | 16031 | 5032 | 52 |
2493632 | 2493632 | 2022-05-11 | Cassia | Idaho | 16031 | 5032 | 52 |
2483859 | 2483859 | 2022-05-08 | Cassia | Idaho | 16031 | 5032 | 52 |
2480601 | 2480601 | 2022-05-07 | Cassia | Idaho | 16031 | 5032 | 52 |
2477343 | 2477343 | 2022-05-06 | Cassia | Idaho | 16031 | 5032 | 52 |
2474085 | 2474085 | 2022-05-05 | Cassia | Idaho | 16031 | 5032 | 52 |
2475093 | 2475093 | 2022-05-05 | Perry | Missouri | 29157 | 5032 | 46 |
2470828 | 2470828 | 2022-05-04 | Cassia | Idaho | 16031 | 5032 | 52 |
2465494 | 2465494 | 2022-05-02 | Saunders | Nebraska | 31155 | 5032 | 30 |
2415667 | 2415667 | 2022-04-17 | Orange | Indiana | 18117 | 5032 | 96 |
2412411 | 2412411 | 2022-04-16 | Orange | Indiana | 18117 | 5032 | 96 |
2409155 | 2409155 | 2022-04-15 | Orange | Indiana | 18117 | 5032 | 96 |
2405899 | 2405899 | 2022-04-14 | Orange | Indiana | 18117 | 5032 | 96 |
2402644 | 2402644 | 2022-04-13 | Orange | Indiana | 18117 | 5032 | 96 |
2399389 | 2399389 | 2022-04-12 | Orange | Indiana | 18117 | 5032 | 96 |
2396134 | 2396134 | 2022-04-11 | Orange | Indiana | 18117 | 5032 | 96 |
2354266 | 2354266 | 2022-03-29 | Sagadahoc | Maine | 23023 | 5032 | 29 |
2334313 | 2334313 | 2022-03-23 | Orange | Indiana | 18117 | 5032 | 96 |
2331059 | 2331059 | 2022-03-22 | Orange | Indiana | 18117 | 5032 | 96 |
2327617 | 2327617 | 2022-03-21 | Cassia | Idaho | 16031 | 5032 | 52 |
2327807 | 2327807 | 2022-03-21 | Orange | Indiana | 18117 | 5032 | 96 |
2270831 | 2270831 | 2022-03-03 | Wyoming | Pennsylvania | 42131 | 5032 | 100 |
2258896 | 2258896 | 2022-02-28 | Logan | Arkansas | 5083 | 5032 | 69 |
2258672 | 2258672 | 2022-02-27 | Green Lake | Wisconsin | 55047 | 5032 | 58 |
2255421 | 2255421 | 2022-02-26 | Green Lake | Wisconsin | 55047 | 5032 | 58 |
2252170 | 2252170 | 2022-02-25 | Green Lake | Wisconsin | 55047 | 5032 | 58 |
2245746 | 2245746 | 2022-02-24 | Butler | Alabama | 1013 | 5032 | 116 |
2248660 | 2248660 | 2022-02-24 | Orleans | Vermont | 50019 | 5032 | 33 |
2248919 | 2248919 | 2022-02-24 | Green Lake | Wisconsin | 55047 | 5032 | 58 |
2229540 | 2229540 | 2022-02-19 | Randolph | Alabama | 1111 | 5032 | 72 |
2222992 | 2222992 | 2022-02-17 | Cherokee | Alabama | 1019 | 5032 | 77 |
2223946 | 2223946 | 2022-02-17 | Neosho | Kansas | 20133 | 5032 | 62 |
2220695 | 2220695 | 2022-02-16 | Neosho | Kansas | 20133 | 5032 | 62 |
2208827 | 2208827 | 2022-02-12 | Holmes | Ohio | 39075 | 5032 | 172 |
2194713 | 2194713 | 2022-02-08 | Adair | Kentucky | 21001 | 5032 | 95 |
2183411 | 2183411 | 2022-02-04 | Gillespie | Texas | 48171 | 5032 | 97 |
2106370 | 2106370 | 2022-01-12 | Monroe | Georgia | 13207 | 5032 | 154 |
2012403 | 2012403 | 2021-12-14 | White | Indiana | 18181 | 5032 | 73 |
1994199 | 1994199 | 2021-12-08 | Hardin | Ohio | 39065 | 5032 | 104 |
1973940 | 1973940 | 2021-12-02 | Cass | Minnesota | 27021 | 5032 | 53 |
1940580 | 1940580 | 2021-11-22 | Madison | Georgia | 13195 | 5032 | 80 |
1853292 | 1853292 | 2021-10-26 | Harvey | Kansas | 20079 | 5032 | 80 |
1850043 | 1850043 | 2021-10-25 | Harvey | Kansas | 20079 | 5032 | 80 |
1839191 | 1839191 | 2021-10-21 | Okanogan | Washington | 53047 | 5032 | 78 |
1816038 | 1816038 | 2021-10-14 | Cooke | Texas | 48097 | 5032 | 94 |
1760865 | 1760865 | 2021-09-27 | Hopkins | Texas | 48223 | 5032 | 135 |
1761079 | 1761079 | 2021-09-27 | Charlottesville city | Virginia | 51540 | 5032 | 56 |
1757617 | 1757617 | 2021-09-26 | Hopkins | Texas | 48223 | 5032 | 135 |
1753195 | 1753195 | 2021-09-25 | Marion | Missouri | 29127 | 5032 | 58 |
1754369 | 1754369 | 2021-09-25 | Hopkins | Texas | 48223 | 5032 | 135 |
1736761 | 1736761 | 2021-09-20 | McLeod | Minnesota | 27085 | 5032 | 63 |
1737262 | 1737262 | 2021-09-20 | Montgomery | New York | 36057 | 5032 | 133 |
1732806 | 1732806 | 2021-09-19 | Monroe | Illinois | 17133 | 5032 | 99 |
1729556 | 1729556 | 2021-09-18 | Monroe | Illinois | 17133 | 5032 | 99 |
1726306 | 1726306 | 2021-09-17 | Monroe | Illinois | 17133 | 5032 | 99 |
1650959 | 1650959 | 2021-08-25 | Franklin | Alabama | 1059 | 5032 | 86 |
1647710 | 1647710 | 2021-08-24 | Franklin | Alabama | 1059 | 5032 | 86 |
1644461 | 1644461 | 2021-08-23 | Franklin | Alabama | 1059 | 5032 | 86 |
1540833 | 1540833 | 2021-07-22 | Hendry | Florida | 12051 | 5032 | 87 |
1537586 | 1537586 | 2021-07-21 | Hendry | Florida | 12051 | 5032 | 87 |
1534338 | 1534338 | 2021-07-20 | Hendry | Florida | 12051 | 5032 | 87 |
1531091 | 1531091 | 2021-07-19 | Hendry | Florida | 12051 | 5032 | 87 |
1527844 | 1527844 | 2021-07-18 | Hendry | Florida | 12051 | 5032 | 87 |
1528024 | 1528024 | 2021-07-18 | Tift | Georgia | 13277 | 5032 | 132 |
1529495 | 1529495 | 2021-07-18 | Watauga | North Carolina | 37189 | 5032 | 33 |
1524597 | 1524597 | 2021-07-17 | Hendry | Florida | 12051 | 5032 | 87 |
1524777 | 1524777 | 2021-07-17 | Tift | Georgia | 13277 | 5032 | 132 |
1526248 | 1526248 | 2021-07-17 | Watauga | North Carolina | 37189 | 5032 | 33 |
1521349 | 1521349 | 2021-07-16 | Hendry | Florida | 12051 | 5032 | 87 |
1521529 | 1521529 | 2021-07-16 | Tift | Georgia | 13277 | 5032 | 132 |
1523001 | 1523001 | 2021-07-16 | Watauga | North Carolina | 37189 | 5032 | 33 |
1515046 | 1515046 | 2021-07-14 | Ware | Georgia | 13299 | 5032 | 182 |
1496119 | 1496119 | 2021-07-08 | Nelson | Kentucky | 21179 | 5032 | 63 |
1498080 | 1498080 | 2021-07-08 | Washington | Virginia | 51191 | 5032 | 111 |
1471114 | 1471114 | 2021-06-30 | Williams | North Dakota | 38105 | 5032 | 40 |
1471122 | 1471122 | 2021-06-30 | Auglaize | Ohio | 39011 | 5032 | 87 |
1372188 | 1372188 | 2021-05-31 | Murray | Georgia | 13213 | 5032 | 89 |
1368943 | 1368943 | 2021-05-30 | Murray | Georgia | 13213 | 5032 | 89 |
1365697 | 1365697 | 2021-05-29 | Murray | Georgia | 13213 | 5032 | 89 |
1362451 | 1362451 | 2021-05-28 | Murray | Georgia | 13213 | 5032 | 89 |
1359204 | 1359204 | 2021-05-27 | Murray | Georgia | 13213 | 5032 | 88 |
1197527 | 1197527 | 2021-04-07 | St. Martin | Louisiana | 22099 | 5032 | 115 |
1195661 | 1195661 | 2021-04-06 | Franklin | Tennessee | 47051 | 5032 | 87 |
1188586 | 1188586 | 2021-04-04 | Pender | North Carolina | 37141 | 5032 | 69 |
1185339 | 1185339 | 2021-04-03 | Pender | North Carolina | 37141 | 5032 | 69 |
1182092 | 1182092 | 2021-04-02 | Pender | North Carolina | 37141 | 5032 | 69 |
1178845 | 1178845 | 2021-04-01 | Pender | North Carolina | 37141 | 5032 | 69 |
1175560 | 1175560 | 2021-03-31 | Edgecombe | North Carolina | 37065 | 5032 | 102 |
1172339 | 1172339 | 2021-03-30 | McDowell | North Carolina | 37111 | 5032 | 63 |
1115824 | 1115824 | 2021-03-13 | Knox | Illinois | 17095 | 5032 | 164 |
1113508 | 1113508 | 2021-03-12 | Pettis | Missouri | 29159 | 5032 | 77 |
1103010 | 1103010 | 2021-03-09 | Clinton | Iowa | 19045 | 5032 | 86 |
1099404 | 1099404 | 2021-03-08 | Habersham | Georgia | 13137 | 5032 | 145 |
1097645 | 1097645 | 2021-03-07 | Halifax | North Carolina | 37083 | 5032 | 99 |
1094397 | 1094397 | 2021-03-06 | Halifax | North Carolina | 37083 | 5032 | 99 |
1041281 | 1041281 | 2021-02-18 | Noble | Indiana | 18113 | 5032 | 78 |
1008491 | 1008491 | 2021-02-08 | Coffee | Georgia | 13069 | 5032 | 133 |
1009412 | 1009412 | 2021-02-08 | Crow Wing | Minnesota | 27035 | 5032 | 80 |
1006672 | 1006672 | 2021-02-07 | Cayuga | New York | 36011 | 5032 | 83 |
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);