ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
36 rows where cases = 9104 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 20
- Indiana 6
- Minnesota 3
- Missouri 3
- Tennessee 3
- Texas 3
- Kansas 2
- Ohio 2
- Pennsylvania 2
- Arkansas 1
- California 1
- Georgia 1
- Louisiana 1
- Massachusetts 1
- Nebraska 1
- New York 1
- North Carolina 1
- Oklahoma 1
- South Carolina 1
- Washington 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2484027 | 2484027 | 2022-05-08 | Jasper | Indiana | 18073 | 9104 | 149 |
2480769 | 2480769 | 2022-05-07 | Jasper | Indiana | 18073 | 9104 | 149 |
2477511 | 2477511 | 2022-05-06 | Jasper | Indiana | 18073 | 9104 | 149 |
2474253 | 2474253 | 2022-05-05 | Jasper | Indiana | 18073 | 9104 | 149 |
2470996 | 2470996 | 2022-05-04 | Jasper | Indiana | 18073 | 9104 | 149 |
2372993 | 2372993 | 2022-04-04 | Bryan | Georgia | 13029 | 9104 | 90 |
2330485 | 2330485 | 2022-03-22 | Amador | California | 6005 | 9104 | 85 |
2153166 | 2153166 | 2022-01-26 | Scotts Bluff | Nebraska | 31157 | 9104 | 102 |
1867648 | 1867648 | 2021-10-30 | Indiana | Pennsylvania | 42063 | 9104 | 228 |
1811997 | 1811997 | 2021-10-13 | Ontario | New York | 36069 | 9104 | 108 |
1733531 | 1733531 | 2021-09-19 | Rice | Minnesota | 27131 | 9104 | 120 |
1730281 | 1730281 | 2021-09-18 | Rice | Minnesota | 27131 | 9104 | 120 |
1727031 | 1727031 | 2021-09-17 | Rice | Minnesota | 27131 | 9104 | 120 |
1711942 | 1711942 | 2021-09-12 | Coffee | Tennessee | 47031 | 9104 | 136 |
1708695 | 1708695 | 2021-09-11 | Coffee | Tennessee | 47031 | 9104 | 136 |
1705448 | 1705448 | 2021-09-10 | Coffee | Tennessee | 47031 | 9104 | 136 |
1539359 | 1539359 | 2021-07-21 | Muskingum | Ohio | 39119 | 9104 | 137 |
1403046 | 1403046 | 2021-06-09 | Wayne | Ohio | 39169 | 9104 | 221 |
1327474 | 1327474 | 2021-05-17 | Hampshire | Massachusetts | 25015 | 9104 | 294 |
1324515 | 1324515 | 2021-05-16 | Cole | Missouri | 29051 | 9104 | 124 |
1321269 | 1321269 | 2021-05-15 | Cole | Missouri | 29051 | 9104 | 124 |
1287128 | 1287128 | 2021-05-04 | Thurston | Washington | 53067 | 9104 | 97 |
1271000 | 1271000 | 2021-04-29 | Ozaukee | Wisconsin | 55089 | 9104 | 91 |
1239497 | 1239497 | 2021-04-20 | Douglas | Kansas | 20045 | 9104 | 87 |
1236250 | 1236250 | 2021-04-19 | Douglas | Kansas | 20045 | 9104 | 87 |
1223863 | 1223863 | 2021-04-15 | Cole | Missouri | 29051 | 9104 | 122 |
1084914 | 1084914 | 2021-03-03 | Muskogee | Oklahoma | 40101 | 9104 | 106 |
1055421 | 1055421 | 2021-02-22 | Burke | North Carolina | 37023 | 9104 | 136 |
1046222 | 1046222 | 2021-02-19 | Sumter | South Carolina | 45085 | 9104 | 164 |
920570 | 920570 | 2021-01-12 | Faulkner | Arkansas | 5045 | 9104 | 109 |
901678 | 901678 | 2021-01-06 | Clark | Indiana | 18019 | 9104 | 127 |
895649 | 895649 | 2021-01-04 | Tangipahoa | Louisiana | 22105 | 9104 | 184 |
783197 | 783197 | 2020-11-30 | Northampton | Pennsylvania | 42095 | 9104 | 333 |
621529 | 621529 | 2020-10-11 | Williamson | Texas | 48491 | 9104 | 146 |
618286 | 618286 | 2020-10-10 | Williamson | Texas | 48491 | 9104 | 146 |
615044 | 615044 | 2020-10-09 | Williamson | Texas | 48491 | 9104 | 145 |
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);