ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
52 rows where cases = 10334 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 17
- Tennessee 10
- Ohio 9
- California 6
- Washington 5
- Missouri 4
- Texas 4
- Wisconsin 3
- North Dakota 2
- Alabama 1
- Florida 1
- Georgia 1
- Kentucky 1
- Mississippi 1
- New York 1
- North Carolina 1
- Oklahoma 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2449558 | 2449558 | 2022-04-27 | Fulton | Ohio | 39051 | 10334 | 180 |
2446301 | 2446301 | 2022-04-26 | Fulton | Ohio | 39051 | 10334 | 180 |
2443046 | 2443046 | 2022-04-25 | Fulton | Ohio | 39051 | 10334 | 180 |
2439790 | 2439790 | 2022-04-24 | Fulton | Ohio | 39051 | 10334 | 180 |
2436534 | 2436534 | 2022-04-23 | Fulton | Ohio | 39051 | 10334 | 180 |
2433278 | 2433278 | 2022-04-22 | Fulton | Ohio | 39051 | 10334 | 180 |
2430022 | 2430022 | 2022-04-21 | Fulton | Ohio | 39051 | 10334 | 180 |
2310113 | 2310113 | 2022-03-15 | Marshall | Tennessee | 47117 | 10334 | 116 |
2306860 | 2306860 | 2022-03-14 | Marshall | Tennessee | 47117 | 10334 | 116 |
2303609 | 2303609 | 2022-03-13 | Marshall | Tennessee | 47117 | 10334 | 116 |
2300357 | 2300357 | 2022-03-12 | Marshall | Tennessee | 47117 | 10334 | 116 |
2297105 | 2297105 | 2022-03-11 | Marshall | Tennessee | 47117 | 10334 | 116 |
2293853 | 2293853 | 2022-03-10 | Marshall | Tennessee | 47117 | 10334 | 116 |
2290601 | 2290601 | 2022-03-09 | Marshall | Tennessee | 47117 | 10334 | 116 |
2286620 | 2286620 | 2022-03-08 | Cortland | New York | 36023 | 10334 | 114 |
2193111 | 2193111 | 2022-02-07 | Burnet | Texas | 48053 | 10334 | 145 |
2172536 | 2172536 | 2022-02-01 | Scott | Missouri | 29201 | 10334 | 143 |
2122089 | 2122089 | 2022-01-16 | Polk | Wisconsin | 55095 | 10334 | 111 |
2118837 | 2118837 | 2022-01-15 | Polk | Wisconsin | 55095 | 10334 | 111 |
2115585 | 2115585 | 2022-01-14 | Polk | Wisconsin | 55095 | 10334 | 111 |
2102344 | 2102344 | 2022-01-10 | Fauquier | Virginia | 51061 | 10334 | 95 |
1989090 | 1989090 | 2021-12-07 | Tehama | California | 6103 | 10334 | 133 |
1983908 | 1983908 | 2021-12-05 | Lincoln | Missouri | 29113 | 10334 | 94 |
1859370 | 1859370 | 2021-10-28 | Spalding | Georgia | 13255 | 10334 | 299 |
1838658 | 1838658 | 2021-10-21 | Dickson | Tennessee | 47043 | 10334 | 163 |
1829449 | 1829449 | 2021-10-18 | Skagit | Washington | 53057 | 10334 | 105 |
1826200 | 1826200 | 2021-10-17 | Skagit | Washington | 53057 | 10334 | 105 |
1822951 | 1822951 | 2021-10-16 | Skagit | Washington | 53057 | 10334 | 105 |
1819702 | 1819702 | 2021-10-15 | Skagit | Washington | 53057 | 10334 | 105 |
1770431 | 1770431 | 2021-09-30 | Gibson | Tennessee | 47053 | 10334 | 181 |
1669782 | 1669782 | 2021-08-30 | Unknown | Tennessee | 10334 | 97 | |
1509972 | 1509972 | 2021-07-12 | Lincoln | North Carolina | 37109 | 10334 | 86 |
1414078 | 1414078 | 2021-06-13 | El Dorado | California | 6017 | 10334 | 115 |
1410833 | 1410833 | 2021-06-12 | El Dorado | California | 6017 | 10334 | 115 |
1407588 | 1407588 | 2021-06-11 | El Dorado | California | 6017 | 10334 | 115 |
1404342 | 1404342 | 2021-06-10 | El Dorado | California | 6017 | 10334 | 115 |
1227611 | 1227611 | 2021-04-16 | Grand Forks | North Dakota | 38035 | 10334 | 77 |
1216876 | 1216876 | 2021-04-13 | Daviess | Kentucky | 21059 | 10334 | 177 |
1169911 | 1169911 | 2021-03-29 | Maverick | Texas | 48323 | 10334 | 342 |
1166663 | 1166663 | 2021-03-28 | Maverick | Texas | 48323 | 10334 | 342 |
1162165 | 1162165 | 2021-03-27 | Franklin | Missouri | 29071 | 10334 | 176 |
1163415 | 1163415 | 2021-03-27 | Maverick | Texas | 48323 | 10334 | 341 |
1088090 | 1088090 | 2021-03-04 | Richland | Ohio | 39139 | 10334 | 183 |
987509 | 987509 | 2021-02-01 | Comanche | Oklahoma | 40031 | 10334 | 106 |
928403 | 928403 | 2021-01-14 | Rankin | Mississippi | 28121 | 10334 | 204 |
928999 | 928999 | 2021-01-14 | Clark | Ohio | 39023 | 10334 | 261 |
875054 | 875054 | 2020-12-29 | Morgan | Alabama | 1103 | 10334 | 87 |
813153 | 813153 | 2020-12-09 | Clark | Washington | 53011 | 10334 | 139 |
743951 | 743951 | 2020-11-18 | Burleigh | North Dakota | 38015 | 10334 | 108 |
649464 | 649464 | 2020-10-20 | St. Charles | Missouri | 29183 | 10334 | 148 |
415229 | 415229 | 2020-08-09 | Collier | Florida | 12021 | 10334 | 136 |
405478 | 405478 | 2020-08-06 | Tulare | California | 6107 | 10334 | 196 |
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);