ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
66 rows where cases = 7011 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
- Indiana 8
- Oklahoma 7
- North Dakota 4
- Arkansas 3
- Georgia 3
- Illinois 3
- Louisiana 3
- Michigan 3
- New Mexico 3
- Ohio 3
- Puerto Rico 3
- West Virginia 3
- Kansas 2
- North Carolina 2
- Pennsylvania 2
- Texas 2
- Wisconsin 2
- California 1
- Maryland 1
- Massachusetts 1
- Minnesota 1
- New Jersey 1
- Oregon 1
- South Dakota 1
- Tennessee 1
- Utah 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2490522 | 2490522 | 2022-05-10 | Decatur | Indiana | 18031 | 7011 | 146 |
2487265 | 2487265 | 2022-05-09 | Decatur | Indiana | 18031 | 7011 | 146 |
2470174 | 2470174 | 2022-05-03 | Door | Wisconsin | 55029 | 7011 | 71 |
2466096 | 2466096 | 2022-05-02 | Canovanas | Puerto Rico | 72029 | 7011 | |
2461209 | 2461209 | 2022-05-01 | Decatur | Indiana | 18031 | 7011 | 145 |
2457953 | 2457953 | 2022-04-30 | Decatur | Indiana | 18031 | 7011 | 145 |
2454697 | 2454697 | 2022-04-29 | Decatur | Indiana | 18031 | 7011 | 145 |
2440856 | 2440856 | 2022-04-24 | Wyoming | West Virginia | 54109 | 7011 | 113 |
2437600 | 2437600 | 2022-04-23 | Wyoming | West Virginia | 54109 | 7011 | 113 |
2434344 | 2434344 | 2022-04-22 | Wyoming | West Virginia | 54109 | 7011 | 113 |
2400013 | 2400013 | 2022-04-12 | Pine | Minnesota | 27115 | 7011 | 67 |
2358501 | 2358501 | 2022-03-30 | Garvin | Oklahoma | 40049 | 7011 | 140 |
2355247 | 2355247 | 2022-03-29 | Garvin | Oklahoma | 40049 | 7011 | 140 |
2351994 | 2351994 | 2022-03-28 | Garvin | Oklahoma | 40049 | 7011 | 140 |
2348742 | 2348742 | 2022-03-27 | Garvin | Oklahoma | 40049 | 7011 | 140 |
2345489 | 2345489 | 2022-03-26 | Garvin | Oklahoma | 40049 | 7011 | 140 |
2342236 | 2342236 | 2022-03-25 | Garvin | Oklahoma | 40049 | 7011 | 140 |
2338983 | 2338983 | 2022-03-24 | Garvin | Oklahoma | 40049 | 7011 | 140 |
2313587 | 2313587 | 2022-03-16 | Palo Pinto | Texas | 48363 | 7011 | 152 |
2308851 | 2308851 | 2022-03-15 | Wexford | Michigan | 26165 | 7011 | 104 |
2305600 | 2305600 | 2022-03-14 | Wexford | Michigan | 26165 | 7011 | 104 |
2286814 | 2286814 | 2022-03-08 | Stutsman | North Dakota | 38093 | 7011 | 96 |
2282038 | 2282038 | 2022-03-07 | Toombs | Georgia | 13279 | 7011 | 191 |
2283562 | 2283562 | 2022-03-07 | Stutsman | North Dakota | 38093 | 7011 | 96 |
2280310 | 2280310 | 2022-03-06 | Stutsman | North Dakota | 38093 | 7011 | 96 |
2233457 | 2233457 | 2022-02-20 | Decatur | Indiana | 18031 | 7011 | 141 |
2235102 | 2235102 | 2022-02-20 | Gurabo | Puerto Rico | 72063 | 7011 | |
2230206 | 2230206 | 2022-02-19 | Decatur | Indiana | 18031 | 7011 | 141 |
2226955 | 2226955 | 2022-02-18 | Decatur | Indiana | 18031 | 7011 | 141 |
2223610 | 2223610 | 2022-02-17 | Fayette | Illinois | 17051 | 7011 | 96 |
2193436 | 2193436 | 2022-02-07 | Gloucester | Virginia | 51073 | 7011 | 91 |
2140728 | 2140728 | 2022-01-22 | Susquehanna | Pennsylvania | 42115 | 7011 | 96 |
2059972 | 2059972 | 2021-12-28 | Waller | Texas | 48473 | 7011 | 87 |
2020474 | 2020474 | 2021-12-16 | Guaynabo | Puerto Rico | 72061 | 7011 | |
1985744 | 1985744 | 2021-12-06 | Independence | Arkansas | 5063 | 7011 | 161 |
1971939 | 1971939 | 2021-12-01 | Marshall | Tennessee | 47117 | 7011 | 91 |
1940721 | 1940721 | 2021-11-22 | Effingham | Illinois | 17049 | 7011 | 116 |
1854420 | 1854420 | 2021-10-26 | Ashland | Ohio | 39005 | 7011 | 132 |
1833100 | 1833100 | 2021-10-20 | Tuolumne | California | 6109 | 7011 | 111 |
1830762 | 1830762 | 2021-10-19 | Lincoln | Louisiana | 22061 | 7011 | 115 |
1814291 | 1814291 | 2021-10-14 | Ford | Kansas | 20057 | 7011 | 89 |
1811042 | 1811042 | 2021-10-13 | Ford | Kansas | 20057 | 7011 | 89 |
1804743 | 1804743 | 2021-10-11 | Avoyelles | Louisiana | 22009 | 7011 | 175 |
1655356 | 1655356 | 2021-08-26 | Washington | Louisiana | 22117 | 7011 | 173 |
1626167 | 1626167 | 2021-08-17 | Berkshire | Massachusetts | 25003 | 7011 | 299 |
1552359 | 1552359 | 2021-07-25 | Ross | Ohio | 39141 | 7011 | 165 |
1529318 | 1529318 | 2021-07-18 | Eddy | New Mexico | 35015 | 7011 | 141 |
1526071 | 1526071 | 2021-07-17 | Eddy | New Mexico | 35015 | 7011 | 141 |
1522824 | 1522824 | 2021-07-16 | Eddy | New Mexico | 35015 | 7011 | 141 |
1490627 | 1490627 | 2021-07-06 | Hancock | Ohio | 39063 | 7011 | 134 |
1263591 | 1263591 | 2021-04-27 | Crawford | Pennsylvania | 42039 | 7011 | 147 |
1219220 | 1219220 | 2021-04-14 | Crawford | Arkansas | 5033 | 7011 | 117 |
1215498 | 1215498 | 2021-04-12 | Tooele | Utah | 49045 | 7011 | 41 |
1131922 | 1131922 | 2021-03-18 | Rockdale | Georgia | 13247 | 7011 | 159 |
1120411 | 1120411 | 2021-03-14 | Stanly | North Carolina | 37167 | 7011 | 112 |
1117164 | 1117164 | 2021-03-13 | Stanly | North Carolina | 37167 | 7011 | 112 |
1050695 | 1050695 | 2021-02-21 | Dougherty | Georgia | 13095 | 7011 | 277 |
1030969 | 1030969 | 2021-02-15 | White | Arkansas | 5145 | 7011 | 100 |
1021025 | 1021025 | 2021-02-11 | Wood | Wisconsin | 55141 | 7011 | 84 |
967122 | 967122 | 2021-01-26 | Bay | Michigan | 26017 | 7011 | 258 |
964882 | 964882 | 2021-01-25 | Umatilla | Oregon | 41059 | 7011 | 73 |
948209 | 948209 | 2021-01-20 | Sussex | New Jersey | 34037 | 7011 | 247 |
908058 | 908058 | 2021-01-08 | Adams | Illinois | 17001 | 7011 | 96 |
743155 | 743155 | 2020-11-18 | Howard | Maryland | 24027 | 7011 | 132 |
633650 | 633650 | 2020-10-15 | Cass | North Dakota | 38017 | 7011 | 78 |
591992 | 591992 | 2020-10-02 | Minnehaha | South Dakota | 46099 | 7011 | 82 |
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);