ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
47 rows where cases = 8060 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 22
- Kansas 9
- Texas 4
- California 3
- Indiana 3
- New Mexico 3
- Ohio 3
- Tennessee 3
- Arkansas 2
- Minnesota 2
- Pennsylvania 2
- Wisconsin 2
- Alabama 1
- Arizona 1
- Florida 1
- Maine 1
- Maryland 1
- Missouri 1
- New York 1
- North Carolina 1
- North Dakota 1
- Puerto Rico 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2294022 | 2294022 | 2022-03-10 | Kendall | Texas | 48259 | 8060 | 116 |
2290335 | 2290335 | 2022-03-09 | Snyder | Pennsylvania | 42109 | 8060 | 154 |
2182603 | 2182603 | 2022-02-04 | Wyoming | New York | 36121 | 8060 | 81 |
2156795 | 2156795 | 2022-01-27 | Ottawa | Ohio | 39123 | 8060 | 124 |
2128757 | 2128757 | 2022-01-19 | Boone | Arkansas | 5009 | 8060 | 145 |
2110324 | 2110324 | 2022-01-13 | Oxford | Maine | 23017 | 8060 | 112 |
2108628 | 2108628 | 2022-01-12 | Jim Wells | Texas | 48249 | 8060 | 184 |
2060280 | 2060280 | 2021-12-28 | Douglas | Wisconsin | 55031 | 8060 | 71 |
1983103 | 1983103 | 2021-12-05 | Lawrence | Indiana | 18093 | 8060 | 188 |
1979853 | 1979853 | 2021-12-04 | Lawrence | Indiana | 18093 | 8060 | 188 |
1976603 | 1976603 | 2021-12-03 | Lawrence | Indiana | 18093 | 8060 | 188 |
1970864 | 1970864 | 2021-12-01 | Callaway | Missouri | 29027 | 8060 | 93 |
1963775 | 1963775 | 2021-11-29 | Finney | Kansas | 20055 | 8060 | 94 |
1960524 | 1960524 | 2021-11-28 | Finney | Kansas | 20055 | 8060 | 93 |
1957273 | 1957273 | 2021-11-27 | Finney | Kansas | 20055 | 8060 | 93 |
1954022 | 1954022 | 2021-11-26 | Finney | Kansas | 20055 | 8060 | 93 |
1950771 | 1950771 | 2021-11-25 | Finney | Kansas | 20055 | 8060 | 93 |
1947520 | 1947520 | 2021-11-24 | Finney | Kansas | 20055 | 8060 | 93 |
1946591 | 1946591 | 2021-11-23 | Sweetwater | Wyoming | 56037 | 8060 | 97 |
1880398 | 1880398 | 2021-11-03 | Stark | North Dakota | 38089 | 8060 | 70 |
1811457 | 1811457 | 2021-10-13 | Chisago | Minnesota | 27025 | 8060 | 61 |
1801349 | 1801349 | 2021-10-10 | Saline | Kansas | 20169 | 8060 | 169 |
1798100 | 1798100 | 2021-10-09 | Saline | Kansas | 20169 | 8060 | 169 |
1794851 | 1794851 | 2021-10-08 | Saline | Kansas | 20169 | 8060 | 169 |
1775586 | 1775586 | 2021-10-02 | Cecil | Maryland | 24015 | 8060 | 166 |
1666659 | 1666659 | 2021-08-29 | Hunt | Texas | 48231 | 8060 | 198 |
1656724 | 1656724 | 2021-08-26 | Dickson | Tennessee | 47043 | 8060 | 131 |
1649013 | 1649013 | 2021-08-24 | Blue Earth | Minnesota | 27013 | 8060 | 45 |
1620266 | 1620266 | 2021-08-15 | Eddy | New Mexico | 35015 | 8060 | 152 |
1617018 | 1617018 | 2021-08-14 | Eddy | New Mexico | 35015 | 8060 | 152 |
1613770 | 1613770 | 2021-08-13 | Eddy | New Mexico | 35015 | 8060 | 152 |
1604876 | 1604876 | 2021-08-10 | Coryell | Texas | 48099 | 8060 | 94 |
1471138 | 1471138 | 2021-06-30 | Erie | Ohio | 39043 | 8060 | 165 |
1467893 | 1467893 | 2021-06-29 | Erie | Ohio | 39043 | 8060 | 165 |
1410746 | 1410746 | 2021-06-12 | Santa Cruz | Arizona | 4023 | 8060 | 180 |
1306929 | 1306929 | 2021-05-11 | Pope | Arkansas | 5115 | 8060 | 107 |
1212659 | 1212659 | 2021-04-12 | Talladega | Alabama | 1121 | 8060 | 171 |
1120769 | 1120769 | 2021-03-14 | Carolina | Puerto Rico | 72031 | 8060 | |
997042 | 997042 | 2021-02-04 | Lincoln | North Carolina | 37109 | 8060 | 54 |
981154 | 981154 | 2021-01-30 | Lycoming | Pennsylvania | 42081 | 8060 | 207 |
966067 | 966067 | 2021-01-26 | El Dorado | California | 6017 | 8060 | 62 |
884968 | 884968 | 2021-01-01 | Shasta | California | 6089 | 8060 | 78 |
881723 | 881723 | 2020-12-31 | Shasta | California | 6089 | 8060 | 78 |
848328 | 848328 | 2020-12-20 | Bradley | Tennessee | 47011 | 8060 | 60 |
841889 | 841889 | 2020-12-18 | Maury | Tennessee | 47119 | 8060 | 94 |
651089 | 651089 | 2020-10-20 | Winnebago | Wisconsin | 55139 | 8060 | 51 |
570364 | 570364 | 2020-09-26 | Alachua | Florida | 12001 | 8060 | 55 |
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);