ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
31 rows where cases = 9570 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 18
- North Carolina 5
- Missouri 4
- California 2
- Indiana 2
- Michigan 2
- New York 2
- Texas 2
- West Virginia 2
- Alabama 1
- Arkansas 1
- Colorado 1
- Connecticut 1
- Georgia 1
- Louisiana 1
- New Jersey 1
- Ohio 1
- Oregon 1
- Tennessee 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2397238 | 2397238 | 2022-04-11 | Franklin | New York | 36033 | 9570 | 44 |
2391727 | 2391727 | 2022-04-09 | Waller | Texas | 48473 | 9570 | 107 |
2375712 | 2375712 | 2022-04-04 | Logan | West Virginia | 54045 | 9570 | 183 |
2223763 | 2223763 | 2022-02-17 | Steuben | Indiana | 18151 | 9570 | 117 |
2052161 | 2052161 | 2021-12-26 | Joplin | Missouri | 9570 | 189 | |
2048911 | 2048911 | 2021-12-25 | Joplin | Missouri | 9570 | 189 | |
2045661 | 2045661 | 2021-12-24 | Joplin | Missouri | 9570 | 189 | |
2042411 | 2042411 | 2021-12-23 | Joplin | Missouri | 9570 | 189 | |
1938802 | 1938802 | 2021-11-21 | Lee | North Carolina | 37105 | 9570 | 110 |
1935552 | 1935552 | 2021-11-20 | Lee | North Carolina | 37105 | 9570 | 110 |
1932302 | 1932302 | 2021-11-19 | Lee | North Carolina | 37105 | 9570 | 110 |
1924110 | 1924110 | 2021-11-17 | Fremont | Colorado | 8043 | 9570 | 111 |
1906304 | 1906304 | 2021-11-11 | Lenoir | North Carolina | 37107 | 9570 | 166 |
1903055 | 1903055 | 2021-11-10 | Lenoir | North Carolina | 37107 | 9570 | 166 |
1815955 | 1815955 | 2021-10-14 | Monroe | Tennessee | 47123 | 9570 | 118 |
1727721 | 1727721 | 2021-09-17 | Erie | Ohio | 39043 | 9570 | 171 |
1677446 | 1677446 | 2021-09-02 | Walker | Georgia | 13295 | 9570 | 96 |
1566649 | 1566649 | 2021-07-30 | White | Arkansas | 5145 | 9570 | 133 |
1400941 | 1400941 | 2021-06-09 | Lauderdale | Alabama | 1077 | 9570 | 248 |
1324279 | 1324279 | 2021-05-16 | Lapeer | Michigan | 26087 | 9570 | 198 |
1321033 | 1321033 | 2021-05-15 | Lapeer | Michigan | 26087 | 9570 | 198 |
1209564 | 1209564 | 2021-04-11 | Napa | California | 6055 | 9570 | 79 |
1203067 | 1203067 | 2021-04-09 | Napa | California | 6055 | 9570 | 80 |
1205096 | 1205096 | 2021-04-09 | Jackson | Oregon | 41029 | 9570 | 126 |
1153559 | 1153559 | 2021-03-24 | Comal | Texas | 48091 | 9570 | 305 |
1133295 | 1133295 | 2021-03-18 | Rensselaer | New York | 36083 | 9570 | 133 |
1053357 | 1053357 | 2021-02-21 | Berkeley | West Virginia | 54003 | 9570 | 98 |
944276 | 944276 | 2021-01-19 | Ascension | Louisiana | 22005 | 9570 | 132 |
892015 | 892015 | 2021-01-03 | Vigo | Indiana | 18167 | 9570 | 165 |
695081 | 695081 | 2020-11-03 | Mercer | New Jersey | 34021 | 9570 | 641 |
139505 | 139505 | 2020-05-13 | New Haven | Connecticut | 9009 | 9570 | 745 |
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);