ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
70 rows where cases = 4972 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 24
- Alabama 5
- California 5
- Ohio 5
- Virginia 5
- Arkansas 4
- Illinois 4
- North Carolina 4
- Texas 4
- Georgia 3
- Indiana 3
- Michigan 3
- New York 3
- North Dakota 3
- Puerto Rico 3
- Wisconsin 3
- Louisiana 2
- New Mexico 2
- Pennsylvania 2
- West Virginia 2
- Colorado 1
- Idaho 1
- Mississippi 1
- Missouri 1
- Oklahoma 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2378230 | 2378230 | 2022-04-05 | Naranjito | Puerto Rico | 72105 | 4972 | |
2374976 | 2374976 | 2022-04-04 | Naranjito | Puerto Rico | 72105 | 4972 | |
2349844 | 2349844 | 2022-03-28 | Fayette | Alabama | 1057 | 4972 | 94 |
2351707 | 2351707 | 2022-03-28 | Schoharie | New York | 36095 | 4972 | 35 |
2346591 | 2346591 | 2022-03-27 | Fayette | Alabama | 1057 | 4972 | 94 |
2348455 | 2348455 | 2022-03-27 | Schoharie | New York | 36095 | 4972 | 35 |
2343338 | 2343338 | 2022-03-26 | Fayette | Alabama | 1057 | 4972 | 94 |
2340085 | 2340085 | 2022-03-25 | Fayette | Alabama | 1057 | 4972 | 94 |
2336832 | 2336832 | 2022-03-24 | Fayette | Alabama | 1057 | 4972 | 94 |
2315340 | 2315340 | 2022-03-17 | Osceola | Michigan | 26133 | 4972 | 80 |
2312087 | 2312087 | 2022-03-16 | Osceola | Michigan | 26133 | 4972 | 80 |
2304015 | 2304015 | 2022-03-13 | King George | Virginia | 51099 | 4972 | 36 |
2300763 | 2300763 | 2022-03-12 | King George | Virginia | 51099 | 4972 | 36 |
2297511 | 2297511 | 2022-03-11 | King George | Virginia | 51099 | 4972 | 36 |
2289851 | 2289851 | 2022-03-09 | Roosevelt | New Mexico | 35041 | 4972 | 92 |
2213993 | 2213993 | 2022-02-14 | Orange | Indiana | 18117 | 4972 | 92 |
2198101 | 2198101 | 2022-02-09 | Concordia | Louisiana | 22029 | 4972 | 88 |
2168387 | 2168387 | 2022-01-31 | Wayne | Illinois | 17191 | 4972 | 74 |
2166536 | 2166536 | 2022-01-30 | Holmes | Ohio | 39075 | 4972 | 167 |
2138265 | 2138265 | 2022-01-21 | Hampshire | West Virginia | 54027 | 4972 | 62 |
2129219 | 2129219 | 2022-01-19 | Elmore | Idaho | 16039 | 4972 | 54 |
2081049 | 2081049 | 2022-01-04 | West Baton Rouge | Louisiana | 22121 | 4972 | 79 |
2027419 | 2027419 | 2021-12-18 | Palo Pinto | Texas | 48363 | 4972 | 126 |
2016677 | 2016677 | 2021-12-15 | Cibola | New Mexico | 35006 | 4972 | 153 |
1984438 | 1984438 | 2021-12-05 | Fayette | Ohio | 39047 | 4972 | 72 |
1917997 | 1917997 | 2021-11-15 | Lee | Illinois | 17103 | 4972 | 104 |
1861905 | 1861905 | 2021-10-28 | Warren | Virginia | 51187 | 4972 | 84 |
1856090 | 1856090 | 2021-10-27 | Madison | Georgia | 13195 | 4972 | 74 |
1765416 | 1765416 | 2021-09-29 | Wabash | Indiana | 18169 | 4972 | 93 |
1766757 | 1766757 | 2021-09-29 | Putnam | Ohio | 39137 | 4972 | 107 |
1735247 | 1735247 | 2021-09-19 | Fayette | West Virginia | 54019 | 4972 | 97 |
1713314 | 1713314 | 2021-09-13 | Monroe | Illinois | 17133 | 4972 | 98 |
1678781 | 1678781 | 2021-09-02 | Madison | New York | 36053 | 4972 | 90 |
1679298 | 1679298 | 2021-09-02 | Ponce | Puerto Rico | 72113 | 4972 | |
1679772 | 1679772 | 2021-09-02 | Washington | Texas | 48477 | 4972 | 104 |
1610167 | 1610167 | 2021-08-12 | Panola | Mississippi | 28107 | 4972 | 112 |
1605607 | 1605607 | 2021-08-11 | Miller | Arkansas | 5091 | 4972 | 37 |
1607587 | 1607587 | 2021-08-11 | Shelby | Ohio | 39149 | 4972 | 98 |
1604113 | 1604113 | 2021-08-10 | Beaufort | North Carolina | 37013 | 4972 | 103 |
1581051 | 1581051 | 2021-08-03 | Scott | Missouri | 29201 | 4972 | 88 |
1532724 | 1532724 | 2021-07-19 | Richmond | North Carolina | 37153 | 4972 | 98 |
1440379 | 1440379 | 2021-06-21 | Tift | Georgia | 13277 | 4972 | 130 |
1396468 | 1396468 | 2021-06-07 | Williams | North Dakota | 38105 | 4972 | 40 |
1393221 | 1393221 | 2021-06-06 | Williams | North Dakota | 38105 | 4972 | 40 |
1378105 | 1378105 | 2021-06-01 | Douglas | Wisconsin | 55031 | 4972 | 58 |
1374859 | 1374859 | 2021-05-31 | Douglas | Wisconsin | 55031 | 4972 | 58 |
1355416 | 1355416 | 2021-05-25 | Pierce | Wisconsin | 55093 | 4972 | 43 |
1280329 | 1280329 | 2021-05-02 | Medina | Texas | 48325 | 4972 | 103 |
1277082 | 1277082 | 2021-05-01 | Medina | Texas | 48325 | 4972 | 103 |
1200860 | 1200860 | 2021-04-08 | Branch | Michigan | 26023 | 4972 | 113 |
1172521 | 1172521 | 2021-03-30 | Washington | Ohio | 39167 | 4972 | 105 |
1130196 | 1130196 | 2021-03-17 | Morton | North Dakota | 38059 | 4972 | 97 |
1065187 | 1065187 | 2021-02-25 | Halifax | North Carolina | 37083 | 4972 | 96 |
1037908 | 1037908 | 2021-02-17 | Grundy | Illinois | 17063 | 4972 | 65 |
1036324 | 1036324 | 2021-02-16 | Indiana | Pennsylvania | 42063 | 4972 | 154 |
1018563 | 1018563 | 2021-02-11 | Noble | Indiana | 18113 | 4972 | 77 |
929094 | 929094 | 2021-01-14 | Creek | Oklahoma | 40037 | 4972 | 73 |
914151 | 914151 | 2021-01-10 | Lassen | California | 6035 | 4972 | 12 |
910906 | 910906 | 2021-01-09 | Lassen | California | 6035 | 4972 | 11 |
907661 | 907661 | 2021-01-08 | Lassen | California | 6035 | 4972 | 11 |
894913 | 894913 | 2021-01-04 | Dougherty | Georgia | 13095 | 4972 | 213 |
823265 | 823265 | 2020-12-13 | Butte | California | 6007 | 4972 | 67 |
815263 | 815263 | 2020-12-10 | Cleveland | North Carolina | 37045 | 4972 | 116 |
751824 | 751824 | 2020-11-21 | Jefferson | Arkansas | 5069 | 4972 | 107 |
722698 | 722698 | 2020-11-12 | San Luis Obispo | California | 6079 | 4972 | 33 |
690165 | 690165 | 2020-11-02 | Craighead | Arkansas | 5031 | 4972 | 50 |
680482 | 680482 | 2020-10-30 | Sebastian | Arkansas | 5131 | 4972 | 95 |
683252 | 683252 | 2020-10-30 | Chesapeake city | Virginia | 51550 | 4972 | 79 |
637193 | 637193 | 2020-10-16 | Northampton | Pennsylvania | 42095 | 4972 | 309 |
338075 | 338075 | 2020-07-16 | Adams | Colorado | 8001 | 4972 | 159 |
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);