ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
113 rows where cases = 5741 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 28
- Missouri 36
- Iowa 7
- Illinois 6
- Tennessee 6
- Puerto Rico 5
- Texas 5
- Washington 4
- Arkansas 3
- Kansas 3
- Michigan 3
- Minnesota 3
- Mississippi 3
- North Carolina 3
- Pennsylvania 3
- West Virginia 3
- Alabama 2
- Indiana 2
- Kentucky 2
- Louisiana 2
- Nebraska 2
- New Jersey 2
- Ohio 2
- New Mexico 1
- New York 1
- North Dakota 1
- South Dakota 1
- Utah 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2475054 | 2475054 | 2022-05-05 | Henry | Missouri | 29083 | 5741 | 86 |
2471797 | 2471797 | 2022-05-04 | Henry | Missouri | 29083 | 5741 | 83 |
2468541 | 2468541 | 2022-05-03 | Henry | Missouri | 29083 | 5741 | 83 |
2465285 | 2465285 | 2022-05-02 | Henry | Missouri | 29083 | 5741 | 83 |
2462030 | 2462030 | 2022-05-01 | Henry | Missouri | 29083 | 5741 | 83 |
2458774 | 2458774 | 2022-04-30 | Henry | Missouri | 29083 | 5741 | 83 |
2455518 | 2455518 | 2022-04-29 | Henry | Missouri | 29083 | 5741 | 83 |
2451692 | 2451692 | 2022-04-28 | Pottawatomie | Kansas | 20149 | 5741 | 57 |
2452262 | 2452262 | 2022-04-28 | Henry | Missouri | 29083 | 5741 | 83 |
2448436 | 2448436 | 2022-04-27 | Pottawatomie | Kansas | 20149 | 5741 | 57 |
2449006 | 2449006 | 2022-04-27 | Henry | Missouri | 29083 | 5741 | 83 |
2445180 | 2445180 | 2022-04-26 | Pottawatomie | Kansas | 20149 | 5741 | 56 |
2445749 | 2445749 | 2022-04-26 | Henry | Missouri | 29083 | 5741 | 83 |
2442494 | 2442494 | 2022-04-25 | Henry | Missouri | 29083 | 5741 | 83 |
2439238 | 2439238 | 2022-04-24 | Henry | Missouri | 29083 | 5741 | 83 |
2435982 | 2435982 | 2022-04-23 | Henry | Missouri | 29083 | 5741 | 83 |
2432726 | 2432726 | 2022-04-22 | Henry | Missouri | 29083 | 5741 | 83 |
2429470 | 2429470 | 2022-04-21 | Henry | Missouri | 29083 | 5741 | 83 |
2426214 | 2426214 | 2022-04-20 | Henry | Missouri | 29083 | 5741 | 83 |
2422958 | 2422958 | 2022-04-19 | Henry | Missouri | 29083 | 5741 | 83 |
2419701 | 2419701 | 2022-04-18 | Henry | Missouri | 29083 | 5741 | 83 |
2416446 | 2416446 | 2022-04-17 | Henry | Missouri | 29083 | 5741 | 83 |
2413190 | 2413190 | 2022-04-16 | Henry | Missouri | 29083 | 5741 | 83 |
2409934 | 2409934 | 2022-04-15 | Henry | Missouri | 29083 | 5741 | 83 |
2406678 | 2406678 | 2022-04-14 | Henry | Missouri | 29083 | 5741 | 83 |
2403422 | 2403422 | 2022-04-13 | Henry | Missouri | 29083 | 5741 | 83 |
2400167 | 2400167 | 2022-04-12 | Henry | Missouri | 29083 | 5741 | 83 |
2396912 | 2396912 | 2022-04-11 | Henry | Missouri | 29083 | 5741 | 83 |
2393657 | 2393657 | 2022-04-10 | Henry | Missouri | 29083 | 5741 | 83 |
2390401 | 2390401 | 2022-04-09 | Henry | Missouri | 29083 | 5741 | 83 |
2387145 | 2387145 | 2022-04-08 | Henry | Missouri | 29083 | 5741 | 83 |
2383890 | 2383890 | 2022-04-07 | Henry | Missouri | 29083 | 5741 | 83 |
2380635 | 2380635 | 2022-04-06 | Henry | Missouri | 29083 | 5741 | 83 |
2377380 | 2377380 | 2022-04-05 | Henry | Missouri | 29083 | 5741 | 83 |
2374127 | 2374127 | 2022-04-04 | Henry | Missouri | 29083 | 5741 | 83 |
2370875 | 2370875 | 2022-04-03 | Henry | Missouri | 29083 | 5741 | 83 |
2367622 | 2367622 | 2022-04-02 | Henry | Missouri | 29083 | 5741 | 83 |
2364369 | 2364369 | 2022-04-01 | Henry | Missouri | 29083 | 5741 | 83 |
2361115 | 2361115 | 2022-03-31 | Henry | Missouri | 29083 | 5741 | 83 |
2342431 | 2342431 | 2022-03-25 | Juana Diaz | Puerto Rico | 72075 | 5741 | |
2339178 | 2339178 | 2022-03-24 | Juana Diaz | Puerto Rico | 72075 | 5741 | |
2280203 | 2280203 | 2022-03-06 | Greene | North Carolina | 37079 | 5741 | 56 |
2276950 | 2276950 | 2022-03-05 | Greene | North Carolina | 37079 | 5741 | 56 |
2273697 | 2273697 | 2022-03-04 | Greene | North Carolina | 37079 | 5741 | 56 |
2245916 | 2245916 | 2022-02-24 | Sevier | Arkansas | 5133 | 5741 | 67 |
2217641 | 2217641 | 2022-02-15 | Pointe Coupee | Louisiana | 22077 | 5741 | 87 |
2153824 | 2153824 | 2022-01-26 | Vega Alta | Puerto Rico | 72143 | 5741 | |
2087755 | 2087755 | 2022-01-06 | Pine | Minnesota | 27115 | 5741 | 48 |
2077993 | 2077993 | 2022-01-03 | Nicollet | Minnesota | 27103 | 5741 | 62 |
2031004 | 2031004 | 2021-12-19 | Randolph | West Virginia | 54083 | 5741 | 60 |
2003760 | 2003760 | 2021-12-11 | Wyoming | New York | 36121 | 5741 | 71 |
1952237 | 1952237 | 2021-11-25 | Ponce | Puerto Rico | 72113 | 5741 | |
1932627 | 1932627 | 2021-11-19 | Clinton | Pennsylvania | 42035 | 5741 | 86 |
1898936 | 1898936 | 2021-11-09 | Muhlenberg | Kentucky | 21177 | 5741 | 93 |
1875979 | 1875979 | 2021-11-02 | Sioux | Iowa | 19167 | 5741 | 77 |
1872730 | 1872730 | 2021-11-01 | Sioux | Iowa | 19167 | 5741 | 77 |
1869481 | 1869481 | 2021-10-31 | Sioux | Iowa | 19167 | 5741 | 77 |
1866232 | 1866232 | 2021-10-30 | Sioux | Iowa | 19167 | 5741 | 77 |
1867081 | 1867081 | 2021-10-30 | Madison | Nebraska | 31119 | 5741 | 47 |
1862983 | 1862983 | 2021-10-29 | Sioux | Iowa | 19167 | 5741 | 77 |
1863832 | 1863832 | 2021-10-29 | Madison | Nebraska | 31119 | 5741 | 47 |
1859734 | 1859734 | 2021-10-28 | Sioux | Iowa | 19167 | 5741 | 77 |
1856485 | 1856485 | 2021-10-27 | Sioux | Iowa | 19167 | 5741 | 77 |
1851691 | 1851691 | 2021-10-25 | Marion | Tennessee | 47115 | 5741 | 53 |
1848441 | 1848441 | 2021-10-24 | Marion | Tennessee | 47115 | 5741 | 53 |
1845191 | 1845191 | 2021-10-23 | Marion | Tennessee | 47115 | 5741 | 53 |
1841941 | 1841941 | 2021-10-22 | Marion | Tennessee | 47115 | 5741 | 53 |
1838846 | 1838846 | 2021-10-21 | Howard | Texas | 48227 | 5741 | 130 |
1800481 | 1800481 | 2021-10-10 | Baxter | Arkansas | 5005 | 5741 | 173 |
1800227 | 1800227 | 2021-10-09 | Fayette | West Virginia | 54019 | 5741 | 110 |
1782227 | 1782227 | 2021-10-04 | Goodhue | Minnesota | 27049 | 5741 | 81 |
1783780 | 1783780 | 2021-10-04 | Wasatch | Utah | 49051 | 5741 | 27 |
1755536 | 1755536 | 2021-09-26 | Livingston | Illinois | 17105 | 5741 | 108 |
1756369 | 1756369 | 2021-09-26 | Union | Mississippi | 28145 | 5741 | 86 |
1752288 | 1752288 | 2021-09-25 | Livingston | Illinois | 17105 | 5741 | 108 |
1753121 | 1753121 | 2021-09-25 | Union | Mississippi | 28145 | 5741 | 86 |
1749039 | 1749039 | 2021-09-24 | Livingston | Illinois | 17105 | 5741 | 108 |
1749873 | 1749873 | 2021-09-24 | Union | Mississippi | 28145 | 5741 | 86 |
1706026 | 1706026 | 2021-09-10 | Marion | West Virginia | 54049 | 5741 | 63 |
1695465 | 1695465 | 2021-09-07 | Mifflin | Pennsylvania | 42087 | 5741 | 183 |
1653395 | 1653395 | 2021-08-25 | Brown | South Dakota | 46013 | 5741 | 95 |
1587279 | 1587279 | 2021-08-05 | Tuscola | Michigan | 26157 | 5741 | 176 |
1584028 | 1584028 | 2021-08-04 | Tuscola | Michigan | 26157 | 5741 | 176 |
1585789 | 1585789 | 2021-08-04 | Lewis | Washington | 53041 | 5741 | 83 |
1580779 | 1580779 | 2021-08-03 | Tuscola | Michigan | 26157 | 5741 | 176 |
1448444 | 1448444 | 2021-06-23 | Lawrence | Ohio | 39087 | 5741 | 102 |
1306237 | 1306237 | 2021-05-10 | Hardin | Texas | 48199 | 5741 | 111 |
1302991 | 1302991 | 2021-05-09 | Hardin | Texas | 48199 | 5741 | 111 |
1299744 | 1299744 | 2021-05-08 | Hardin | Texas | 48199 | 5741 | 111 |
1284651 | 1284651 | 2021-05-04 | Clinton | Illinois | 17027 | 5741 | 99 |
1276562 | 1276562 | 2021-05-01 | Armstrong | Pennsylvania | 42005 | 5741 | 131 |
1265267 | 1265267 | 2021-04-28 | Cass | Indiana | 18017 | 5741 | 105 |
1263375 | 1263375 | 2021-04-27 | Belmont | Ohio | 39013 | 5741 | 162 |
1246881 | 1246881 | 2021-04-22 | Salem | New Jersey | 34033 | 5741 | 174 |
1221658 | 1221658 | 2021-04-14 | Hawkins | Tennessee | 47073 | 5741 | 106 |
1167285 | 1167285 | 2021-03-29 | Mississippi | Arkansas | 5093 | 5741 | 106 |
1147159 | 1147159 | 2021-03-22 | Lamar | Texas | 48277 | 5741 | 151 |
1104763 | 1104763 | 2021-03-09 | Jefferson | Tennessee | 47089 | 5741 | 119 |
983122 | 983122 | 2021-01-31 | Christian | Kentucky | 21047 | 5741 | 74 |
961194 | 961194 | 2021-01-24 | Warren | New Jersey | 34041 | 5741 | 194 |
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);