ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where cases = 5048 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 26
- Georgia 11
- Ohio 11
- Texas 11
- Mississippi 5
- Alabama 4
- Iowa 4
- Kentucky 4
- South Dakota 4
- Indiana 3
- Michigan 3
- Missouri 3
- North Carolina 3
- California 2
- North Dakota 2
- Pennsylvania 2
- Washington 2
- Arizona 1
- Arkansas 1
- Maine 1
- Maryland 1
- Minnesota 1
- Oklahoma 1
- Tennessee 1
- Utah 1
- Wisconsin 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502232 | 2502232 | 2022-05-13 | Burleson | Texas | 48051 | 5048 | 66 |
2490564 | 2490564 | 2022-05-10 | Orange | Indiana | 18117 | 5048 | 96 |
2487307 | 2487307 | 2022-05-09 | Orange | Indiana | 18117 | 5048 | 96 |
2360049 | 2360049 | 2022-03-31 | Jones | Georgia | 13169 | 5048 | 108 |
2346569 | 2346569 | 2022-03-27 | Butler | Alabama | 1013 | 5048 | 127 |
2343316 | 2343316 | 2022-03-26 | Butler | Alabama | 1013 | 5048 | 127 |
2340063 | 2340063 | 2022-03-25 | Butler | Alabama | 1013 | 5048 | 127 |
2336810 | 2336810 | 2022-03-24 | Butler | Alabama | 1013 | 5048 | 127 |
2309858 | 2309858 | 2022-03-15 | Wyoming | Pennsylvania | 42131 | 5048 | 103 |
2259266 | 2259266 | 2022-02-28 | Tattnall | Georgia | 13267 | 5048 | 129 |
2242601 | 2242601 | 2022-02-23 | Ashley | Arkansas | 5003 | 5048 | 59 |
2210080 | 2210080 | 2022-02-13 | La Paz | Arizona | 4012 | 5048 | 128 |
2160560 | 2160560 | 2022-01-28 | Austin | Texas | 48015 | 5048 | 60 |
2156195 | 2156195 | 2022-01-27 | Crawford | Missouri | 29055 | 5048 | 87 |
2150317 | 2150317 | 2022-01-25 | Wyandot | Ohio | 39175 | 5048 | 94 |
2124617 | 2124617 | 2022-01-17 | Davison | South Dakota | 46035 | 5048 | 75 |
2121365 | 2121365 | 2022-01-16 | Davison | South Dakota | 46035 | 5048 | 75 |
2118113 | 2118113 | 2022-01-15 | Davison | South Dakota | 46035 | 5048 | 75 |
2114862 | 2114862 | 2022-01-14 | Davison | South Dakota | 46035 | 5048 | 75 |
2103923 | 2103923 | 2022-01-11 | Mason | Michigan | 26105 | 5048 | 74 |
2100672 | 2100672 | 2022-01-10 | Mason | Michigan | 26105 | 5048 | 74 |
2080951 | 2080951 | 2022-01-04 | Mercer | Kentucky | 21167 | 5048 | 94 |
2076170 | 2076170 | 2022-01-02 | Palo Pinto | Texas | 48363 | 5048 | 130 |
2072919 | 2072919 | 2022-01-01 | Palo Pinto | Texas | 48363 | 5048 | 130 |
2069668 | 2069668 | 2021-12-31 | Palo Pinto | Texas | 48363 | 5048 | 130 |
2066417 | 2066417 | 2021-12-30 | Palo Pinto | Texas | 48363 | 5048 | 130 |
2059254 | 2059254 | 2021-12-28 | Van Wert | Ohio | 39161 | 5048 | 109 |
1870036 | 1870036 | 2021-10-31 | George | Mississippi | 28039 | 5048 | 79 |
1866787 | 1866787 | 2021-10-30 | George | Mississippi | 28039 | 5048 | 79 |
1863538 | 1863538 | 2021-10-29 | George | Mississippi | 28039 | 5048 | 79 |
1809016 | 1809016 | 2021-10-12 | Williams | Ohio | 39171 | 5048 | 84 |
1784865 | 1784865 | 2021-10-05 | Jasper | Indiana | 18073 | 5048 | 69 |
1780343 | 1780343 | 2021-10-03 | Grimes | Texas | 48185 | 5048 | 98 |
1775929 | 1775929 | 2021-10-02 | Lawrence | Missouri | 29109 | 5048 | 104 |
1777093 | 1777093 | 2021-10-02 | Grimes | Texas | 48185 | 5048 | 97 |
1653660 | 1653660 | 2021-08-25 | Hill | Texas | 48217 | 5048 | 116 |
1649167 | 1649167 | 2021-08-24 | Union | Mississippi | 28145 | 5048 | 84 |
1611604 | 1611604 | 2021-08-12 | Wasatch | Utah | 49051 | 5048 | 22 |
1589202 | 1589202 | 2021-08-05 | Sweetwater | Wyoming | 56037 | 5048 | 45 |
1557776 | 1557776 | 2021-07-27 | Hopkins | Kentucky | 21107 | 5048 | 152 |
1539237 | 1539237 | 2021-07-21 | Watauga | North Carolina | 37189 | 5048 | 33 |
1528036 | 1528036 | 2021-07-18 | Ware | Georgia | 13299 | 5048 | 182 |
1524789 | 1524789 | 2021-07-17 | Ware | Georgia | 13299 | 5048 | 182 |
1521541 | 1521541 | 2021-07-16 | Ware | Georgia | 13299 | 5048 | 182 |
1515597 | 1515597 | 2021-07-14 | Nelson | Kentucky | 21179 | 5048 | 63 |
1510080 | 1510080 | 2021-07-12 | Auglaize | Ohio | 39011 | 5048 | 87 |
1506833 | 1506833 | 2021-07-11 | Auglaize | Ohio | 39011 | 5048 | 87 |
1503587 | 1503587 | 2021-07-10 | Auglaize | Ohio | 39011 | 5048 | 87 |
1500332 | 1500332 | 2021-07-09 | Williams | North Dakota | 38105 | 5048 | 40 |
1500341 | 1500341 | 2021-07-09 | Auglaize | Ohio | 39011 | 5048 | 87 |
1485784 | 1485784 | 2021-07-05 | Murray | Georgia | 13213 | 5048 | 92 |
1482538 | 1482538 | 2021-07-04 | Murray | Georgia | 13213 | 5048 | 92 |
1479291 | 1479291 | 2021-07-03 | Murray | Georgia | 13213 | 5048 | 92 |
1476045 | 1476045 | 2021-07-02 | Murray | Georgia | 13213 | 5048 | 92 |
1355701 | 1355701 | 2021-05-26 | Tehama | California | 6103 | 5048 | 63 |
1346842 | 1346842 | 2021-05-23 | Whitley | Kentucky | 21235 | 5048 | 57 |
1332272 | 1332272 | 2021-05-18 | Medina | Texas | 48325 | 5048 | 104 |
1235172 | 1235172 | 2021-04-18 | Skagit | Washington | 53057 | 5048 | 67 |
1230032 | 1230032 | 2021-04-17 | Penobscot | Maine | 23019 | 5048 | 89 |
1231924 | 1231924 | 2021-04-17 | Skagit | Washington | 53057 | 5048 | 67 |
1219972 | 1219972 | 2021-04-14 | Sioux | Iowa | 19167 | 5048 | 73 |
1208236 | 1208236 | 2021-04-10 | Seneca | Ohio | 39147 | 5048 | 118 |
1201888 | 1201888 | 2021-04-08 | Columbia | Pennsylvania | 42037 | 5048 | 129 |
1198391 | 1198391 | 2021-04-07 | Morton | North Dakota | 38059 | 5048 | 98 |
1184254 | 1184254 | 2021-04-03 | Webster | Iowa | 19187 | 5048 | 90 |
1181007 | 1181007 | 2021-04-02 | Webster | Iowa | 19187 | 5048 | 89 |
1152211 | 1152211 | 2021-03-24 | St. Joseph | Michigan | 26149 | 5048 | 88 |
1122482 | 1122482 | 2021-03-15 | Cerro Gordo | Iowa | 19033 | 5048 | 85 |
1109142 | 1109142 | 2021-03-11 | Habersham | Georgia | 13137 | 5048 | 144 |
1090416 | 1090416 | 2021-03-05 | Cecil | Maryland | 24015 | 5048 | 123 |
1052443 | 1052443 | 2021-02-21 | Kay | Oklahoma | 40071 | 5048 | 73 |
1023151 | 1023151 | 2021-02-12 | Lawrence | Ohio | 39087 | 5048 | 69 |
995496 | 995496 | 2021-02-04 | Catoosa | Georgia | 13047 | 5048 | 54 |
996574 | 996574 | 2021-02-04 | Washington | Mississippi | 28151 | 5048 | 125 |
954825 | 954825 | 2021-01-22 | Duplin | North Carolina | 37061 | 5048 | 86 |
952407 | 952407 | 2021-01-21 | Lamar | Texas | 48277 | 5048 | 117 |
923886 | 923886 | 2021-01-13 | Lassen | California | 6035 | 5048 | 12 |
874370 | 874370 | 2020-12-28 | Unknown | Tennessee | 5048 | 41 | |
825150 | 825150 | 2020-12-13 | Columbiana | Ohio | 39029 | 5048 | 110 |
788897 | 788897 | 2020-12-02 | Clay | Missouri | 29047 | 5048 | 77 |
753759 | 753759 | 2020-11-21 | Delaware | Ohio | 39041 | 5048 | 34 |
665995 | 665995 | 2020-10-25 | Alamance | North Carolina | 37001 | 5048 | 74 |
654293 | 654293 | 2020-10-21 | Kenosha | Wisconsin | 55059 | 5048 | 76 |
451710 | 451710 | 2020-08-20 | Dakota | Minnesota | 27037 | 5048 | 108 |
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);