ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
53 rows where cases = 7233 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 24
- Kentucky 5
- Minnesota 5
- Ohio 4
- Oregon 4
- Wisconsin 4
- Arkansas 3
- New Mexico 3
- Puerto Rico 3
- Tennessee 3
- Indiana 2
- Maine 2
- Pennsylvania 2
- Texas 2
- Alabama 1
- California 1
- Colorado 1
- Georgia 1
- Iowa 1
- Kansas 1
- Louisiana 1
- Massachusetts 1
- Mississippi 1
- Missouri 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2459596 | 2459596 | 2022-04-30 | Dorado | Puerto Rico | 72051 | 7233 | |
2440439 | 2440439 | 2022-04-24 | Hopkins | Texas | 48223 | 7233 | 178 |
2419537 | 2419537 | 2022-04-18 | Mille Lacs | Minnesota | 27095 | 7233 | 114 |
2420410 | 2420410 | 2022-04-18 | Jefferson | Oregon | 41031 | 7233 | 91 |
2417155 | 2417155 | 2022-04-17 | Jefferson | Oregon | 41031 | 7233 | 91 |
2413899 | 2413899 | 2022-04-16 | Jefferson | Oregon | 41031 | 7233 | 91 |
2410643 | 2410643 | 2022-04-15 | Jefferson | Oregon | 41031 | 7233 | 91 |
2319961 | 2319961 | 2022-03-18 | Cooke | Texas | 48097 | 7233 | 131 |
2287156 | 2287156 | 2022-03-08 | Rio Grande | Puerto Rico | 72119 | 7233 | |
2283904 | 2283904 | 2022-03-07 | Rio Grande | Puerto Rico | 72119 | 7233 | |
2256578 | 2256578 | 2022-02-27 | Mercer | Kentucky | 21167 | 7233 | 99 |
2253327 | 2253327 | 2022-02-26 | Mercer | Kentucky | 21167 | 7233 | 99 |
2250076 | 2250076 | 2022-02-25 | Mercer | Kentucky | 21167 | 7233 | 99 |
2240331 | 2240331 | 2022-02-22 | Ohio | Kentucky | 21183 | 7233 | 95 |
2202349 | 2202349 | 2022-02-10 | Pike | Ohio | 39131 | 7233 | 98 |
2195168 | 2195168 | 2022-02-08 | Leflore | Mississippi | 28083 | 7233 | 159 |
2035943 | 2035943 | 2021-12-21 | Phelps | Missouri | 29161 | 7233 | 198 |
1983725 | 1983725 | 2021-12-05 | McLeod | Minnesota | 27085 | 7233 | 84 |
1980475 | 1980475 | 2021-12-04 | McLeod | Minnesota | 27085 | 7233 | 84 |
1977225 | 1977225 | 2021-12-03 | McLeod | Minnesota | 27085 | 7233 | 84 |
1974681 | 1974681 | 2021-12-02 | Crawford | Ohio | 39033 | 7233 | 150 |
1917596 | 1917596 | 2021-11-15 | Broomfield | Colorado | 8014 | 7233 | 84 |
1882640 | 1882640 | 2021-11-04 | Graves | Kentucky | 21083 | 7233 | 126 |
1862050 | 1862050 | 2021-10-28 | Oconto | Wisconsin | 55083 | 7233 | 76 |
1858140 | 1858140 | 2021-10-27 | Campbell | Tennessee | 47013 | 7233 | 80 |
1831745 | 1831745 | 2021-10-19 | Seneca | Ohio | 39147 | 7233 | 144 |
1828913 | 1828913 | 2021-10-18 | Fayette | Tennessee | 47047 | 7233 | 100 |
1824932 | 1824932 | 2021-10-17 | Curry | New Mexico | 35009 | 7233 | 113 |
1821683 | 1821683 | 2021-10-16 | Curry | New Mexico | 35009 | 7233 | 113 |
1818434 | 1818434 | 2021-10-15 | Curry | New Mexico | 35009 | 7233 | 113 |
1802640 | 1802640 | 2021-10-10 | Bradford | Pennsylvania | 42015 | 7233 | 110 |
1723150 | 1723150 | 2021-09-16 | Noble | Indiana | 18113 | 7233 | 103 |
1655404 | 1655404 | 2021-08-26 | Berkshire | Massachusetts | 25003 | 7233 | 303 |
1556727 | 1556727 | 2021-07-27 | Blount | Alabama | 1009 | 7233 | 139 |
1559271 | 1559271 | 2021-07-27 | Dickson | Tennessee | 47043 | 7233 | 115 |
1261263 | 1261263 | 2021-04-26 | Portage | Wisconsin | 55097 | 7233 | 71 |
1254967 | 1254967 | 2021-04-25 | Lonoke | Arkansas | 5085 | 7233 | 119 |
1258016 | 1258016 | 2021-04-25 | Portage | Wisconsin | 55097 | 7233 | 71 |
1251720 | 1251720 | 2021-04-24 | Lonoke | Arkansas | 5085 | 7233 | 119 |
1210142 | 1210142 | 2021-04-11 | Wayne | Indiana | 18177 | 7233 | 200 |
1183876 | 1183876 | 2021-04-03 | Rockdale | Georgia | 13247 | 7233 | 164 |
1176594 | 1176594 | 2021-03-31 | Frederick | Virginia | 51069 | 7233 | 94 |
1082629 | 1082629 | 2021-03-02 | Chippewa | Wisconsin | 55017 | 7233 | 94 |
932475 | 932475 | 2021-01-15 | Lycoming | Pennsylvania | 42081 | 7233 | 174 |
918109 | 918109 | 2021-01-11 | Douglas | Kansas | 20045 | 7233 | 36 |
885925 | 885925 | 2021-01-01 | Cumberland | Maine | 23005 | 7233 | 97 |
882680 | 882680 | 2020-12-31 | Cumberland | Maine | 23005 | 7233 | 97 |
814209 | 814209 | 2020-12-10 | Pottawattamie | Iowa | 19155 | 7233 | 70 |
744076 | 744076 | 2020-11-18 | Stark | Ohio | 39151 | 7233 | 194 |
703218 | 703218 | 2020-11-06 | Marin | California | 6041 | 7233 | 127 |
622022 | 622022 | 2020-10-12 | Benton | Arkansas | 5007 | 7233 | 102 |
406619 | 406619 | 2020-08-06 | Ramsey | Minnesota | 27123 | 7233 | 261 |
170462 | 170462 | 2020-05-23 | Jefferson | Louisiana | 22051 | 7233 | 432 |
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);