ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
63 rows where cases = 6262 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 23
- North Carolina 9
- Indiana 8
- Kentucky 8
- Iowa 7
- New York 3
- Pennsylvania 3
- Washington 3
- Arkansas 2
- California 2
- Illinois 2
- Louisiana 2
- Ohio 2
- Puerto Rico 2
- Alabama 1
- Arizona 1
- Colorado 1
- Florida 1
- Georgia 1
- Michigan 1
- Minnesota 1
- Mississippi 1
- Tennessee 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500262 | 2500262 | 2022-05-13 | Shelby | Illinois | 17173 | 6262 | 80 |
2444851 | 2444851 | 2022-04-26 | Jersey | Illinois | 17083 | 6262 | 91 |
2417266 | 2417266 | 2022-04-17 | Corozal | Puerto Rico | 72047 | 6262 | |
2328204 | 2328204 | 2022-03-21 | Pointe Coupee | Louisiana | 22077 | 6262 | 91 |
2324896 | 2324896 | 2022-03-20 | Russell | Kentucky | 21207 | 6262 | 84 |
2321642 | 2321642 | 2022-03-19 | Russell | Kentucky | 21207 | 6262 | 84 |
2318388 | 2318388 | 2022-03-18 | Russell | Kentucky | 21207 | 6262 | 84 |
2315135 | 2315135 | 2022-03-17 | Russell | Kentucky | 21207 | 6262 | 84 |
2311882 | 2311882 | 2022-03-16 | Russell | Kentucky | 21207 | 6262 | 84 |
2307818 | 2307818 | 2022-03-15 | Pitkin | Colorado | 8097 | 6262 | 6 |
2308629 | 2308629 | 2022-03-15 | Russell | Kentucky | 21207 | 6262 | 84 |
2305378 | 2305378 | 2022-03-14 | Russell | Kentucky | 21207 | 6262 | 84 |
2240109 | 2240109 | 2022-02-22 | Plymouth | Iowa | 19149 | 6262 | 95 |
2236858 | 2236858 | 2022-02-21 | Plymouth | Iowa | 19149 | 6262 | 95 |
2233607 | 2233607 | 2022-02-20 | Plymouth | Iowa | 19149 | 6262 | 95 |
2230356 | 2230356 | 2022-02-19 | Plymouth | Iowa | 19149 | 6262 | 95 |
2227105 | 2227105 | 2022-02-18 | Plymouth | Iowa | 19149 | 6262 | 95 |
2223854 | 2223854 | 2022-02-17 | Plymouth | Iowa | 19149 | 6262 | 95 |
2220603 | 2220603 | 2022-02-16 | Plymouth | Iowa | 19149 | 6262 | 95 |
2178607 | 2178607 | 2022-02-03 | Plaquemines | Louisiana | 22075 | 6262 | 42 |
2121212 | 2121212 | 2022-01-16 | Warren | Pennsylvania | 42123 | 6262 | 188 |
2100712 | 2100712 | 2022-01-10 | Carlton | Minnesota | 27017 | 6262 | 81 |
2023763 | 2023763 | 2021-12-17 | Toa Baja | Puerto Rico | 72137 | 6262 | |
1878463 | 1878463 | 2021-11-03 | Boone | Arkansas | 5009 | 6262 | 128 |
1818683 | 1818683 | 2021-10-15 | Brown | Ohio | 39015 | 6262 | 82 |
1813074 | 1813074 | 2021-10-13 | Culpeper | Virginia | 51047 | 6262 | 79 |
1710139 | 1710139 | 2021-09-12 | Jackson | Indiana | 18071 | 6262 | 80 |
1706892 | 1706892 | 2021-09-11 | Jackson | Indiana | 18071 | 6262 | 80 |
1703644 | 1703644 | 2021-09-10 | Jackson | Indiana | 18071 | 6262 | 80 |
1669268 | 1669268 | 2021-08-30 | Jefferson | Ohio | 39081 | 6262 | 164 |
1656138 | 1656138 | 2021-08-26 | McDowell | North Carolina | 37111 | 6262 | 66 |
1633756 | 1633756 | 2021-08-19 | Union | Pennsylvania | 42119 | 6262 | 90 |
1571581 | 1571581 | 2021-07-31 | Jefferson | New York | 36045 | 6262 | 68 |
1520335 | 1520335 | 2021-07-15 | Loudon | Tennessee | 47105 | 6262 | 71 |
1486042 | 1486042 | 2021-07-05 | Marshall | Indiana | 18099 | 6262 | 118 |
1482796 | 1482796 | 2021-07-04 | Marshall | Indiana | 18099 | 6262 | 118 |
1479549 | 1479549 | 2021-07-03 | Marshall | Indiana | 18099 | 6262 | 118 |
1476303 | 1476303 | 2021-07-02 | Marshall | Indiana | 18099 | 6262 | 118 |
1470377 | 1470377 | 2021-06-30 | St. Joseph | Michigan | 26149 | 6262 | 101 |
1461279 | 1461279 | 2021-06-27 | Lenoir | North Carolina | 37107 | 6262 | 124 |
1458034 | 1458034 | 2021-06-26 | Lenoir | North Carolina | 37107 | 6262 | 124 |
1454789 | 1454789 | 2021-06-25 | Lenoir | North Carolina | 37107 | 6262 | 124 |
1313498 | 1313498 | 2021-05-13 | Yuba | California | 6115 | 6262 | 47 |
1310251 | 1310251 | 2021-05-12 | Yuba | California | 6115 | 6262 | 46 |
1263236 | 1263236 | 2021-04-27 | Columbus | North Carolina | 37047 | 6262 | 150 |
1217785 | 1217785 | 2021-04-13 | Franklin | North Carolina | 37069 | 6262 | 48 |
1210809 | 1210809 | 2021-04-11 | Lowndes | Mississippi | 28087 | 6262 | 144 |
1203933 | 1203933 | 2021-04-09 | McCracken | Kentucky | 21145 | 6262 | 118 |
1162512 | 1162512 | 2021-03-27 | Ontario | New York | 36069 | 6262 | 90 |
1123551 | 1123551 | 2021-03-15 | Oswego | New York | 36075 | 6262 | 89 |
1098761 | 1098761 | 2021-03-07 | Chelan | Washington | 53007 | 6262 | 63 |
1095513 | 1095513 | 2021-03-06 | Chelan | Washington | 53007 | 6262 | 63 |
1092267 | 1092267 | 2021-03-05 | Chelan | Washington | 53007 | 6262 | 63 |
1024830 | 1024830 | 2021-02-13 | Walker | Georgia | 13295 | 6262 | 74 |
987330 | 987330 | 2021-02-01 | Rutherford | North Carolina | 37161 | 6262 | 173 |
896393 | 896393 | 2021-01-04 | Caldwell | North Carolina | 37027 | 6262 | 31 |
891337 | 891337 | 2021-01-03 | Santa Cruz | Arizona | 4023 | 6262 | 101 |
852432 | 852432 | 2020-12-22 | Jefferson | Arkansas | 5069 | 6262 | 124 |
781253 | 781253 | 2020-11-30 | Martin | Florida | 12085 | 6262 | 173 |
761469 | 761469 | 2020-11-24 | Morgan | Alabama | 1103 | 6262 | 47 |
656658 | 656658 | 2020-10-22 | Lehigh | Pennsylvania | 42077 | 6262 | 363 |
630322 | 630322 | 2020-10-14 | Cumberland | North Carolina | 37051 | 6262 | 88 |
351371 | 351371 | 2020-07-20 | Lake | Indiana | 18089 | 6262 | 270 |
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);