ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
45 rows where cases = 8914 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 25
- Tennessee 10
- Idaho 5
- Arkansas 4
- New York 3
- Nebraska 2
- North Carolina 2
- Alabama 1
- Florida 1
- Georgia 1
- Illinois 1
- Kentucky 1
- Maryland 1
- Michigan 1
- Minnesota 1
- Mississippi 1
- Missouri 1
- Nevada 1
- New Jersey 1
- North Dakota 1
- Ohio 1
- Pennsylvania 1
- Texas 1
- Washington 1
- West Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2470908 | 2470908 | 2022-05-04 | Lee | Illinois | 17103 | 8914 | 118 |
2465614 | 2465614 | 2022-05-02 | Greene | New York | 36039 | 8914 | 129 |
2429266 | 2429266 | 2022-04-21 | Carlton | Minnesota | 27017 | 8914 | 96 |
2415496 | 2415496 | 2022-04-17 | Nez Perce | Idaho | 16069 | 8914 | 148 |
2412240 | 2412240 | 2022-04-16 | Nez Perce | Idaho | 16069 | 8914 | 148 |
2408984 | 2408984 | 2022-04-15 | Nez Perce | Idaho | 16069 | 8914 | 148 |
2405728 | 2405728 | 2022-04-14 | Nez Perce | Idaho | 16069 | 8914 | 148 |
2402473 | 2402473 | 2022-04-13 | Nez Perce | Idaho | 16069 | 8914 | 148 |
2388343 | 2388343 | 2022-04-08 | Hill | Texas | 48217 | 8914 | 191 |
2361427 | 2361427 | 2022-03-31 | Allegany | New York | 36003 | 8914 | 154 |
2333424 | 2333424 | 2022-03-22 | Marshall | West Virginia | 54051 | 8914 | 153 |
2310065 | 2310065 | 2022-03-15 | Carroll | Tennessee | 47017 | 8914 | 150 |
2306812 | 2306812 | 2022-03-14 | Carroll | Tennessee | 47017 | 8914 | 150 |
2303561 | 2303561 | 2022-03-13 | Carroll | Tennessee | 47017 | 8914 | 150 |
2300309 | 2300309 | 2022-03-12 | Carroll | Tennessee | 47017 | 8914 | 150 |
2297057 | 2297057 | 2022-03-11 | Carroll | Tennessee | 47017 | 8914 | 150 |
2293805 | 2293805 | 2022-03-10 | Carroll | Tennessee | 47017 | 8914 | 150 |
2290553 | 2290553 | 2022-03-09 | Carroll | Tennessee | 47017 | 8914 | 150 |
2271677 | 2271677 | 2022-03-03 | Green | Wisconsin | 55045 | 8914 | 52 |
2262400 | 2262400 | 2022-03-01 | Bryan | Georgia | 13029 | 8914 | 85 |
2228097 | 2228097 | 2022-02-18 | Franklin | New York | 36033 | 8914 | 41 |
2146610 | 2146610 | 2022-01-24 | Dodge | Nebraska | 31053 | 8914 | 84 |
2109269 | 2109269 | 2022-01-13 | Hot Spring | Arkansas | 5059 | 8914 | 113 |
2098160 | 2098160 | 2022-01-09 | Morton | North Dakota | 38059 | 8914 | 131 |
1923210 | 1923210 | 2021-11-16 | Unknown | Tennessee | 8914 | 129 | |
1903713 | 1903713 | 2021-11-10 | Unknown | Tennessee | 8914 | 126 | |
1876864 | 1876864 | 2021-11-02 | Carson City | Nevada | 32510 | 8914 | 156 |
1864380 | 1864380 | 2021-10-29 | Carbon | Pennsylvania | 42025 | 8914 | 202 |
1587930 | 1587930 | 2021-08-05 | Orange | North Carolina | 37135 | 8914 | 101 |
1489555 | 1489555 | 2021-07-06 | Campbell | Kentucky | 21037 | 8914 | 84 |
1458196 | 1458196 | 2021-06-26 | Muskingum | Ohio | 39119 | 8914 | 135 |
1402499 | 1402499 | 2021-06-09 | St. Francois | Missouri | 29187 | 8914 | 116 |
1332879 | 1332879 | 2021-05-19 | Jefferson | Arkansas | 5069 | 8914 | 166 |
1329632 | 1329632 | 2021-05-18 | Jefferson | Arkansas | 5069 | 8914 | 166 |
1331453 | 1331453 | 2021-05-18 | Moore | North Carolina | 37125 | 8914 | 188 |
1200857 | 1200857 | 2021-04-08 | Bay | Michigan | 26017 | 8914 | 309 |
1001617 | 1001617 | 2021-02-06 | Limestone | Alabama | 1083 | 8914 | 117 |
787194 | 787194 | 2020-12-01 | Clark | Washington | 53011 | 8914 | 121 |
772960 | 772960 | 2020-11-27 | Somerset | New Jersey | 34035 | 8914 | 609 |
730396 | 730396 | 2020-11-14 | Hinds | Mississippi | 28049 | 8914 | 186 |
547552 | 547552 | 2020-09-19 | Washington | Arkansas | 5143 | 8914 | 107 |
536987 | 536987 | 2020-09-15 | Knox | Tennessee | 47093 | 8914 | 67 |
460439 | 460439 | 2020-08-23 | Volusia | Florida | 12127 | 8914 | 177 |
355505 | 355505 | 2020-07-21 | Douglas | Nebraska | 31055 | 8914 | 117 |
329451 | 329451 | 2020-07-13 | Baltimore | Maryland | 24005 | 8914 | 496 |
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);