ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
72 rows where cases = 5504 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Virginia 8
- Oklahoma 7
- South Carolina 7
- Kentucky 5
- Michigan 4
- Texas 4
- Ohio 3
- Alabama 2
- California 2
- Florida 2
- Iowa 2
- Kansas 2
- Maine 2
- North Carolina 2
- Tennessee 2
- Wisconsin 2
- Arkansas 1
- Georgia 1
- Indiana 1
- Louisiana 1
- Maryland 1
- Minnesota 1
- Missouri 1
- Nebraska 1
- Nevada 1
- New York 1
- North Dakota 1
- Oregon 1
- Pennsylvania 1
- Puerto Rico 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2446579 | 2446579 | 2022-04-26 | Hatillo | Puerto Rico | 72065 | 5504 | |
2307070 | 2307070 | 2022-03-14 | Moore | Texas | 48341 | 5504 | 110 |
2303819 | 2303819 | 2022-03-13 | Moore | Texas | 48341 | 5504 | 110 |
2300567 | 2300567 | 2022-03-12 | Moore | Texas | 48341 | 5504 | 110 |
2287530 | 2287530 | 2022-03-08 | Lampasas | Texas | 48281 | 5504 | 87 |
2259934 | 2259934 | 2022-02-28 | Franklin | Maine | 23007 | 5504 | 56 |
2260116 | 2260116 | 2022-02-28 | Martin | Minnesota | 27091 | 5504 | 60 |
2256683 | 2256683 | 2022-02-27 | Franklin | Maine | 23007 | 5504 | 56 |
2224108 | 2224108 | 2022-02-17 | Assumption | Louisiana | 22007 | 5504 | 66 |
2194682 | 2194682 | 2022-02-08 | Pottawatomie | Kansas | 20149 | 5504 | 53 |
2191428 | 2191428 | 2022-02-07 | Pottawatomie | Kansas | 20149 | 5504 | 53 |
2146478 | 2146478 | 2022-01-24 | Miller | Missouri | 29131 | 5504 | 105 |
2144610 | 2144610 | 2022-01-23 | Carroll | Virginia | 51035 | 5504 | 114 |
2141355 | 2141355 | 2022-01-22 | Carroll | Virginia | 51035 | 5504 | 114 |
2138099 | 2138099 | 2022-01-21 | Carroll | Virginia | 51035 | 5504 | 114 |
2099115 | 2099115 | 2022-01-09 | Isle of Wight | Virginia | 51093 | 5504 | 93 |
2095864 | 2095864 | 2022-01-08 | Isle of Wight | Virginia | 51093 | 5504 | 93 |
2092612 | 2092612 | 2022-01-07 | Isle of Wight | Virginia | 51093 | 5504 | 93 |
1986138 | 1986138 | 2021-12-06 | Upson | Georgia | 13293 | 5504 | 189 |
1874909 | 1874909 | 2021-11-01 | York | Virginia | 51199 | 5504 | 77 |
1825440 | 1825440 | 2021-10-17 | Wayne | Pennsylvania | 42127 | 5504 | 103 |
1814476 | 1814476 | 2021-10-14 | Taylor | Kentucky | 21217 | 5504 | 81 |
1811227 | 1811227 | 2021-10-13 | Taylor | Kentucky | 21217 | 5504 | 81 |
1780087 | 1780087 | 2021-10-03 | Williamsburg | South Carolina | 45089 | 5504 | 120 |
1776837 | 1776837 | 2021-10-02 | Williamsburg | South Carolina | 45089 | 5504 | 120 |
1773587 | 1773587 | 2021-10-01 | Williamsburg | South Carolina | 45089 | 5504 | 120 |
1762149 | 1762149 | 2021-09-28 | Putnam | Indiana | 18133 | 5504 | 71 |
1759826 | 1759826 | 2021-09-27 | Dodge | Nebraska | 31053 | 5504 | 83 |
1725591 | 1725591 | 2021-09-16 | Polk | Wisconsin | 55095 | 5504 | 69 |
1718100 | 1718100 | 2021-09-14 | Ottawa | Oklahoma | 40115 | 5504 | 85 |
1714852 | 1714852 | 2021-09-13 | Ottawa | Oklahoma | 40115 | 5504 | 85 |
1711606 | 1711606 | 2021-09-12 | Ottawa | Oklahoma | 40115 | 5504 | 85 |
1708359 | 1708359 | 2021-09-11 | Ottawa | Oklahoma | 40115 | 5504 | 85 |
1705112 | 1705112 | 2021-09-10 | Ottawa | Oklahoma | 40115 | 5504 | 85 |
1701862 | 1701862 | 2021-09-09 | Ottawa | Oklahoma | 40115 | 5504 | 85 |
1698613 | 1698613 | 2021-09-08 | Ottawa | Oklahoma | 40115 | 5504 | 85 |
1691976 | 1691976 | 2021-09-06 | Auglaize | Ohio | 39011 | 5504 | 87 |
1630320 | 1630320 | 2021-08-18 | Seneca | Ohio | 39147 | 5504 | 128 |
1592653 | 1592653 | 2021-08-07 | Humboldt | California | 6023 | 5504 | 56 |
1589404 | 1589404 | 2021-08-06 | Humboldt | California | 6023 | 5504 | 56 |
1566488 | 1566488 | 2021-07-30 | Dale | Alabama | 1045 | 5504 | 117 |
1563240 | 1563240 | 2021-07-29 | Dale | Alabama | 1045 | 5504 | 117 |
1512366 | 1512366 | 2021-07-13 | Scott | Kentucky | 21209 | 5504 | 36 |
1486544 | 1486544 | 2021-07-05 | Cass | Michigan | 26027 | 5504 | 77 |
1483298 | 1483298 | 2021-07-04 | Cass | Michigan | 26027 | 5504 | 77 |
1480052 | 1480052 | 2021-07-03 | Cass | Michigan | 26027 | 5504 | 77 |
1476805 | 1476805 | 2021-07-02 | Cass | Michigan | 26027 | 5504 | 77 |
1463673 | 1463673 | 2021-06-28 | Scott | Kentucky | 21209 | 5504 | 36 |
1416131 | 1416131 | 2021-06-13 | Linn | Oregon | 41043 | 5504 | 79 |
1382241 | 1382241 | 2021-06-03 | Cerro Gordo | Iowa | 19033 | 5504 | 90 |
1383527 | 1383527 | 2021-06-03 | Huron | Ohio | 39077 | 5504 | 121 |
1280442 | 1280442 | 2021-05-02 | Summit | Utah | 49043 | 5504 | 12 |
1224958 | 1224958 | 2021-04-15 | Warren | Tennessee | 47177 | 5504 | 81 |
1133261 | 1133261 | 2021-03-18 | Cayuga | New York | 36011 | 5504 | 90 |
1118764 | 1118764 | 2021-03-14 | Gadsden | Florida | 12039 | 5504 | 90 |
1107863 | 1107863 | 2021-03-10 | Cherokee | South Carolina | 45021 | 5504 | 138 |
1022975 | 1022975 | 2021-02-12 | Columbus | North Carolina | 37047 | 5504 | 133 |
1017539 | 1017539 | 2021-02-10 | Harrisonburg city | Virginia | 51660 | 5504 | 67 |
948838 | 948838 | 2021-01-20 | Greenwood | South Carolina | 45047 | 5504 | 111 |
919621 | 919621 | 2021-01-11 | Darlington | South Carolina | 45031 | 5504 | 105 |
889186 | 889186 | 2021-01-02 | Allegany | Maryland | 24001 | 5504 | 155 |
846844 | 846844 | 2020-12-20 | Hardin | Kentucky | 21093 | 5504 | 41 |
820181 | 820181 | 2020-12-12 | Indian River | Florida | 12061 | 5504 | 147 |
800530 | 800530 | 2020-12-06 | Saline | Arkansas | 5125 | 5504 | 62 |
744393 | 744393 | 2020-11-18 | Pickens | South Carolina | 45077 | 5504 | 74 |
744548 | 744548 | 2020-11-18 | Sullivan | Tennessee | 47163 | 5504 | 79 |
717900 | 717900 | 2020-11-10 | Cabarrus | North Carolina | 37025 | 5504 | 95 |
705031 | 705031 | 2020-11-06 | Grand Forks | North Dakota | 38035 | 5504 | 25 |
625997 | 625997 | 2020-10-13 | Johnson | Iowa | 19103 | 5504 | 30 |
605674 | 605674 | 2020-10-06 | Winnebago | Wisconsin | 55139 | 5504 | 37 |
403779 | 403779 | 2020-08-05 | Washoe | Nevada | 32031 | 5504 | 116 |
236878 | 236878 | 2020-06-13 | Yakima | Washington | 53077 | 5504 | 117 |
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);