ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
45 rows where cases = 10035 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 15
- Mississippi 11
- Florida 10
- Virginia 4
- Michigan 3
- Pennsylvania 3
- Illinois 2
- North Carolina 2
- Ohio 2
- Tennessee 2
- California 1
- Indiana 1
- Kentucky 1
- Maryland 1
- New Mexico 1
- Oregon 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2396789 | 2396789 | 2022-04-11 | Alcorn | Mississippi | 28003 | 10035 | 159 |
2393534 | 2393534 | 2022-04-10 | Alcorn | Mississippi | 28003 | 10035 | 159 |
2390278 | 2390278 | 2022-04-09 | Alcorn | Mississippi | 28003 | 10035 | 159 |
2387022 | 2387022 | 2022-04-08 | Alcorn | Mississippi | 28003 | 10035 | 159 |
2383767 | 2383767 | 2022-04-07 | Alcorn | Mississippi | 28003 | 10035 | 159 |
2380512 | 2380512 | 2022-04-06 | Alcorn | Mississippi | 28003 | 10035 | 159 |
2377257 | 2377257 | 2022-04-05 | Alcorn | Mississippi | 28003 | 10035 | 159 |
2374005 | 2374005 | 2022-04-04 | Alcorn | Mississippi | 28003 | 10035 | 159 |
2296848 | 2296848 | 2022-03-11 | Wayne | Pennsylvania | 42127 | 10035 | 167 |
2294317 | 2294317 | 2022-03-10 | Tazewell | Virginia | 51185 | 10035 | 159 |
2259834 | 2259834 | 2022-02-28 | Muhlenberg | Kentucky | 21177 | 10035 | 117 |
2190177 | 2190177 | 2022-02-06 | Franklin | Virginia | 51067 | 10035 | 145 |
2186924 | 2186924 | 2022-02-05 | Franklin | Virginia | 51067 | 10035 | 145 |
2182776 | 2182776 | 2022-02-04 | Clinton | Ohio | 39027 | 10035 | 141 |
2183671 | 2183671 | 2022-02-04 | Franklin | Virginia | 51067 | 10035 | 145 |
2109744 | 2109744 | 2022-01-13 | Clinton | Illinois | 17027 | 10035 | 117 |
2107799 | 2107799 | 2022-01-12 | Carteret | North Carolina | 37031 | 10035 | 83 |
2010623 | 2010623 | 2021-12-13 | Yamhill | Oregon | 41071 | 10035 | 150 |
1974436 | 1974436 | 2021-12-02 | Otero | New Mexico | 35035 | 10035 | 126 |
1908798 | 1908798 | 2021-11-12 | Allegany | Maryland | 24001 | 10035 | 259 |
1836461 | 1836461 | 2021-10-21 | Jackson | Florida | 12063 | 10035 | 211 |
1833212 | 1833212 | 2021-10-20 | Jackson | Florida | 12063 | 10035 | 211 |
1829963 | 1829963 | 2021-10-19 | Jackson | Florida | 12063 | 10035 | 211 |
1826714 | 1826714 | 2021-10-18 | Jackson | Florida | 12063 | 10035 | 211 |
1823465 | 1823465 | 2021-10-17 | Jackson | Florida | 12063 | 10035 | 209 |
1820216 | 1820216 | 2021-10-16 | Jackson | Florida | 12063 | 10035 | 209 |
1816967 | 1816967 | 2021-10-15 | Jackson | Florida | 12063 | 10035 | 209 |
1783425 | 1783425 | 2021-10-04 | Dickson | Tennessee | 47043 | 10035 | 159 |
1770414 | 1770414 | 2021-09-30 | Carter | Tennessee | 47019 | 10035 | 203 |
1678882 | 1678882 | 2021-09-02 | Orange | North Carolina | 37135 | 10035 | 102 |
1610964 | 1610964 | 2021-08-12 | Adams | Pennsylvania | 42001 | 10035 | 190 |
1440545 | 1440545 | 2021-06-21 | Vermilion | Illinois | 17183 | 10035 | 160 |
1340492 | 1340492 | 2021-05-21 | Eaton | Michigan | 26045 | 10035 | 205 |
1279002 | 1279002 | 2021-05-02 | Madison | Mississippi | 28089 | 10035 | 215 |
1275755 | 1275755 | 2021-05-01 | Madison | Mississippi | 28089 | 10035 | 215 |
1272508 | 1272508 | 2021-04-30 | Madison | Mississippi | 28089 | 10035 | 215 |
1141870 | 1141870 | 2021-03-21 | Delaware | Indiana | 18035 | 10035 | 188 |
1125247 | 1125247 | 2021-03-16 | Citrus | Florida | 12017 | 10035 | 419 |
1084830 | 1084830 | 2021-03-03 | Miami | Ohio | 39109 | 10035 | 189 |
1028828 | 1028828 | 2021-02-14 | Livingston | Michigan | 26093 | 10035 | 134 |
1025582 | 1025582 | 2021-02-13 | Livingston | Michigan | 26093 | 10035 | 134 |
1021412 | 1021412 | 2021-02-12 | Martin | Florida | 12085 | 10035 | 262 |
919481 | 919481 | 2021-01-11 | Franklin | Pennsylvania | 42055 | 10035 | 261 |
431211 | 431211 | 2020-08-14 | Imperial | California | 6025 | 10035 | 256 |
428121 | 428121 | 2020-08-13 | Escambia | Florida | 12033 | 10035 | 141 |
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);