ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
81 rows where cases = 5121 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
- Oklahoma 8
- Iowa 7
- Georgia 6
- Illinois 5
- Ohio 5
- Arkansas 4
- Mississippi 4
- Missouri 4
- New York 4
- Tennessee 4
- Wisconsin 4
- Maryland 3
- Puerto Rico 3
- West Virginia 3
- Indiana 2
- Kentucky 2
- North Carolina 2
- Virginia 2
- Alabama 1
- Arizona 1
- Minnesota 1
- New Hampshire 1
- New Mexico 1
- North Dakota 1
- Oregon 1
- Texas 1
- Vermont 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2463896 | 2463896 | 2022-05-02 | Logan | Arkansas | 5083 | 5121 | 80 |
2460640 | 2460640 | 2022-05-01 | Logan | Arkansas | 5083 | 5121 | 80 |
2457384 | 2457384 | 2022-04-30 | Logan | Arkansas | 5083 | 5121 | 80 |
2433079 | 2433079 | 2022-04-22 | Schoharie | New York | 36095 | 5121 | 36 |
2392560 | 2392560 | 2022-04-10 | Fannin | Georgia | 13111 | 5121 | 154 |
2389304 | 2389304 | 2022-04-09 | Fannin | Georgia | 13111 | 5121 | 154 |
2386049 | 2386049 | 2022-04-08 | Fannin | Georgia | 13111 | 5121 | 154 |
2274129 | 2274129 | 2022-03-04 | Las Piedras | Puerto Rico | 72085 | 5121 | |
2244318 | 2244318 | 2022-02-23 | Lincoln | New Mexico | 35027 | 5121 | 63 |
2235916 | 2235916 | 2022-02-20 | Iowa | Wisconsin | 55049 | 5121 | 25 |
2232665 | 2232665 | 2022-02-19 | Iowa | Wisconsin | 55049 | 5121 | 25 |
2229414 | 2229414 | 2022-02-18 | Iowa | Wisconsin | 55049 | 5121 | 25 |
2213911 | 2213911 | 2022-02-14 | Richland | Illinois | 17159 | 5121 | 80 |
2203343 | 2203343 | 2022-02-10 | Lincoln | West Virginia | 54043 | 5121 | 63 |
2118914 | 2118914 | 2022-01-16 | Geneva | Alabama | 1061 | 5121 | 140 |
2071325 | 2071325 | 2022-01-01 | Dorchester | Maryland | 24019 | 5121 | 92 |
2068074 | 2068074 | 2021-12-31 | Dorchester | Maryland | 24019 | 5121 | 92 |
2064823 | 2064823 | 2021-12-30 | Dorchester | Maryland | 24019 | 5121 | 92 |
2063282 | 2063282 | 2021-12-29 | Washington | Vermont | 50023 | 5121 | 32 |
2015653 | 2015653 | 2021-12-15 | Wells | Indiana | 18179 | 5121 | 113 |
2013012 | 2013012 | 2021-12-14 | Todd | Minnesota | 27153 | 5121 | 48 |
2006541 | 2006541 | 2021-12-12 | George | Mississippi | 28039 | 5121 | 80 |
2003290 | 2003290 | 2021-12-11 | George | Mississippi | 28039 | 5121 | 80 |
2004985 | 2004985 | 2021-12-11 | Mingo | West Virginia | 54059 | 5121 | 93 |
2000040 | 2000040 | 2021-12-10 | George | Mississippi | 28039 | 5121 | 80 |
1996789 | 1996789 | 2021-12-09 | George | Mississippi | 28039 | 5121 | 80 |
1987155 | 1987155 | 2021-12-06 | Lafayette | Missouri | 29107 | 5121 | 88 |
1968064 | 1968064 | 2021-11-30 | Macon | North Carolina | 37113 | 5121 | 80 |
1964813 | 1964813 | 2021-11-29 | Macon | North Carolina | 37113 | 5121 | 80 |
1825237 | 1825237 | 2021-10-17 | Perry | Ohio | 39127 | 5121 | 61 |
1793198 | 1793198 | 2021-10-07 | Lauderdale | Tennessee | 47097 | 5121 | 62 |
1788422 | 1788422 | 2021-10-06 | Harlan | Kentucky | 21095 | 5121 | 119 |
1784794 | 1784794 | 2021-10-05 | Morgan | Illinois | 17137 | 5121 | 118 |
1770417 | 1770417 | 2021-09-30 | Claiborne | Tennessee | 47025 | 5121 | 90 |
1748244 | 1748244 | 2021-09-23 | Fayette | West Virginia | 54019 | 5121 | 98 |
1743993 | 1743993 | 2021-09-22 | Logan | Ohio | 39091 | 5121 | 82 |
1739489 | 1739489 | 2021-09-21 | Lee | Iowa | 19111 | 5121 | 78 |
1736240 | 1736240 | 2021-09-20 | Lee | Iowa | 19111 | 5121 | 78 |
1732990 | 1732990 | 2021-09-19 | Lee | Iowa | 19111 | 5121 | 78 |
1729740 | 1729740 | 2021-09-18 | Lee | Iowa | 19111 | 5121 | 78 |
1726490 | 1726490 | 2021-09-17 | Lee | Iowa | 19111 | 5121 | 78 |
1723241 | 1723241 | 2021-09-16 | Lee | Iowa | 19111 | 5121 | 78 |
1719992 | 1719992 | 2021-09-15 | Lee | Iowa | 19111 | 5121 | 78 |
1693573 | 1693573 | 2021-09-07 | Chattahoochee | Georgia | 13053 | 5121 | 17 |
1695349 | 1695349 | 2021-09-07 | Logan | Oklahoma | 40083 | 5121 | 72 |
1692101 | 1692101 | 2021-09-06 | Logan | Oklahoma | 40083 | 5121 | 72 |
1688852 | 1688852 | 2021-09-05 | Logan | Oklahoma | 40083 | 5121 | 72 |
1685602 | 1685602 | 2021-09-04 | Logan | Oklahoma | 40083 | 5121 | 72 |
1682351 | 1682351 | 2021-09-03 | Logan | Oklahoma | 40083 | 5121 | 72 |
1679101 | 1679101 | 2021-09-02 | Logan | Oklahoma | 40083 | 5121 | 72 |
1675853 | 1675853 | 2021-09-01 | Logan | Oklahoma | 40083 | 5121 | 72 |
1657131 | 1657131 | 2021-08-26 | Culpeper | Virginia | 51047 | 5121 | 70 |
1646042 | 1646042 | 2021-08-23 | Webster | Missouri | 29225 | 5121 | 78 |
1634634 | 1634634 | 2021-08-19 | Pierce | Wisconsin | 55093 | 5121 | 44 |
1620844 | 1620844 | 2021-08-15 | Toa Alta | Puerto Rico | 72135 | 5121 | |
1584775 | 1584775 | 2021-08-04 | Auglaize | Ohio | 39011 | 5121 | 87 |
1472943 | 1472943 | 2021-07-01 | Jackson | Illinois | 17077 | 5121 | 76 |
1460832 | 1460832 | 2021-06-27 | Callaway | Missouri | 29027 | 5121 | 51 |
1457587 | 1457587 | 2021-06-26 | Callaway | Missouri | 29027 | 5121 | 51 |
1450597 | 1450597 | 2021-06-24 | Boyd | Kentucky | 21019 | 5121 | 76 |
1334600 | 1334600 | 2021-05-19 | Herkimer | New York | 36043 | 5121 | 107 |
1303655 | 1303655 | 2021-05-10 | Hot Spring | Arkansas | 5059 | 5121 | 72 |
1263670 | 1263670 | 2021-04-27 | Guaynabo | Puerto Rico | 72061 | 5121 | |
1263861 | 1263861 | 2021-04-27 | Franklin | Tennessee | 47051 | 5121 | 89 |
1256879 | 1256879 | 2021-04-25 | Athens | Ohio | 39009 | 5121 | 57 |
1234119 | 1234119 | 2021-04-18 | Morton | North Dakota | 38059 | 5121 | 98 |
1200063 | 1200063 | 2021-04-08 | Habersham | Georgia | 13137 | 5121 | 152 |
1191961 | 1191961 | 2021-04-05 | Jefferson | Ohio | 39081 | 5121 | 144 |
1171024 | 1171024 | 2021-03-30 | Knox | Illinois | 17095 | 5121 | 166 |
1149511 | 1149511 | 2021-03-23 | Jefferson | New York | 36045 | 5121 | 63 |
1059401 | 1059401 | 2021-02-23 | Caldwell | Texas | 48055 | 5121 | 80 |
971289 | 971289 | 2021-01-27 | Grady | Oklahoma | 40051 | 5121 | 55 |
949434 | 949434 | 2021-01-20 | Rockingham | Virginia | 51165 | 5121 | 64 |
896262 | 896262 | 2021-01-04 | Merrimack | New Hampshire | 33013 | 5121 | 68 |
844807 | 844807 | 2020-12-19 | Umatilla | Oregon | 41059 | 5121 | 54 |
783491 | 783491 | 2020-11-30 | Sevier | Tennessee | 47155 | 5121 | 33 |
765090 | 765090 | 2020-11-25 | Coweta | Georgia | 13077 | 5121 | 71 |
670677 | 670677 | 2020-10-27 | Coconino | Arizona | 4005 | 5121 | 147 |
652990 | 652990 | 2020-10-21 | Onondaga | New York | 36067 | 5121 | 182 |
136811 | 136811 | 2020-05-12 | DuPage | Illinois | 17043 | 5121 | 258 |
96025 | 96025 | 2020-04-28 | Marion | Indiana | 18097 | 5121 | 304 |
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);