ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
63 rows where cases = 7656 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 23
- Texas 12
- Oklahoma 10
- Tennessee 8
- Ohio 4
- Alabama 3
- Georgia 3
- California 2
- Florida 2
- Indiana 2
- Maryland 2
- New York 2
- Wisconsin 2
- Arizona 1
- Arkansas 1
- Illinois 1
- Massachusetts 1
- Michigan 1
- Mississippi 1
- Montana 1
- North Carolina 1
- Pennsylvania 1
- Puerto Rico 1
- South Carolina 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492396 | 2492396 | 2022-05-10 | McNairy | Tennessee | 47109 | 7656 | 120 |
2489138 | 2489138 | 2022-05-09 | McNairy | Tennessee | 47109 | 7656 | 120 |
2485881 | 2485881 | 2022-05-08 | McNairy | Tennessee | 47109 | 7656 | 120 |
2482623 | 2482623 | 2022-05-07 | McNairy | Tennessee | 47109 | 7656 | 120 |
2479365 | 2479365 | 2022-05-06 | McNairy | Tennessee | 47109 | 7656 | 120 |
2476107 | 2476107 | 2022-05-05 | McNairy | Tennessee | 47109 | 7656 | 120 |
2472850 | 2472850 | 2022-05-04 | McNairy | Tennessee | 47109 | 7656 | 120 |
2473426 | 2473426 | 2022-05-04 | Clark | Wisconsin | 55019 | 7656 | 122 |
2392154 | 2392154 | 2022-04-10 | Lawrence | Alabama | 1079 | 7656 | 155 |
2388898 | 2388898 | 2022-04-09 | Lawrence | Alabama | 1079 | 7656 | 155 |
2385643 | 2385643 | 2022-04-08 | Lawrence | Alabama | 1079 | 7656 | 155 |
2259957 | 2259957 | 2022-02-28 | Dorchester | Maryland | 24019 | 7656 | 105 |
2253455 | 2253455 | 2022-02-26 | Dorchester | Maryland | 24019 | 7656 | 105 |
2202307 | 2202307 | 2022-02-10 | Fayette | Ohio | 39047 | 7656 | 101 |
2126177 | 2126177 | 2022-01-18 | Wabash | Indiana | 18169 | 7656 | 140 |
2055353 | 2055353 | 2021-12-27 | Washington | Mississippi | 28151 | 7656 | 170 |
1997785 | 1997785 | 2021-12-09 | Chesterfield | South Carolina | 45025 | 7656 | 149 |
1994241 | 1994241 | 2021-12-08 | Shelby | Ohio | 39149 | 7656 | 135 |
1969832 | 1969832 | 2021-12-01 | Liberty | Georgia | 13179 | 7656 | 131 |
1907816 | 1907816 | 2021-11-12 | San Benito | California | 6069 | 7656 | 76 |
1904567 | 1904567 | 2021-11-11 | San Benito | California | 6069 | 7656 | 76 |
1654589 | 1654589 | 2021-08-26 | Catoosa | Georgia | 13047 | 7656 | 78 |
1605406 | 1605406 | 2021-08-10 | Portage | Wisconsin | 55097 | 7656 | 77 |
1580250 | 1580250 | 2021-08-03 | Wayne | Indiana | 18177 | 7656 | 205 |
1526131 | 1526131 | 2021-07-17 | Oswego | New York | 36075 | 7656 | 93 |
1470318 | 1470318 | 2021-06-30 | Clinton | Michigan | 26037 | 7656 | 92 |
1443250 | 1443250 | 2021-06-22 | Lonoke | Arkansas | 5085 | 7656 | 124 |
1442465 | 1442465 | 2021-06-21 | Unknown | Tennessee | 7656 | 92 | |
1149816 | 1149816 | 2021-03-23 | Garfield | Oklahoma | 40047 | 7656 | 82 |
1146569 | 1146569 | 2021-03-22 | Garfield | Oklahoma | 40047 | 7656 | 82 |
1143322 | 1143322 | 2021-03-21 | Garfield | Oklahoma | 40047 | 7656 | 82 |
1140075 | 1140075 | 2021-03-20 | Garfield | Oklahoma | 40047 | 7656 | 82 |
1136829 | 1136829 | 2021-03-19 | Garfield | Oklahoma | 40047 | 7656 | 82 |
1133583 | 1133583 | 2021-03-18 | Garfield | Oklahoma | 40047 | 7656 | 82 |
1130335 | 1130335 | 2021-03-17 | Garfield | Oklahoma | 40047 | 7656 | 82 |
1127088 | 1127088 | 2021-03-16 | Garfield | Oklahoma | 40047 | 7656 | 82 |
1123842 | 1123842 | 2021-03-15 | Garfield | Oklahoma | 40047 | 7656 | 82 |
1120596 | 1120596 | 2021-03-14 | Garfield | Oklahoma | 40047 | 7656 | 82 |
1095806 | 1095806 | 2021-03-07 | Santa Cruz | Arizona | 4023 | 7656 | 170 |
1058372 | 1058372 | 2021-02-23 | Cascade | Montana | 30013 | 7656 | 149 |
1052884 | 1052884 | 2021-02-21 | Angelina | Texas | 48005 | 7656 | 245 |
1049637 | 1049637 | 2021-02-20 | Angelina | Texas | 48005 | 7656 | 245 |
1046390 | 1046390 | 2021-02-19 | Angelina | Texas | 48005 | 7656 | 243 |
1043145 | 1043145 | 2021-02-18 | Angelina | Texas | 48005 | 7656 | 241 |
1039900 | 1039900 | 2021-02-17 | Angelina | Texas | 48005 | 7656 | 241 |
1036655 | 1036655 | 2021-02-16 | Angelina | Texas | 48005 | 7656 | 241 |
1033410 | 1033410 | 2021-02-15 | Angelina | Texas | 48005 | 7656 | 241 |
1030164 | 1030164 | 2021-02-14 | Angelina | Texas | 48005 | 7656 | 241 |
1026917 | 1026917 | 2021-02-13 | Angelina | Texas | 48005 | 7656 | 241 |
1023672 | 1023672 | 2021-02-12 | Angelina | Texas | 48005 | 7656 | 240 |
1020427 | 1020427 | 2021-02-11 | Angelina | Texas | 48005 | 7656 | 240 |
1017182 | 1017182 | 2021-02-10 | Angelina | Texas | 48005 | 7656 | 234 |
1013196 | 1013196 | 2021-02-09 | Putnam | New York | 36079 | 7656 | 83 |
1003695 | 1003695 | 2021-02-06 | Muskingum | Ohio | 39119 | 7656 | 43 |
953359 | 953359 | 2021-01-22 | Jackson | Georgia | 13157 | 7656 | 96 |
893229 | 893229 | 2021-01-03 | Wayne | North Carolina | 37191 | 7656 | 150 |
872121 | 872121 | 2020-12-28 | Martin | Florida | 12085 | 7656 | 207 |
851381 | 851381 | 2020-12-21 | Bayamon | Puerto Rico | 72021 | 7656 | |
646900 | 646900 | 2020-10-19 | Chester | Pennsylvania | 42029 | 7656 | 374 |
611046 | 611046 | 2020-10-08 | Lucas | Ohio | 39095 | 7656 | 369 |
508866 | 508866 | 2020-09-07 | Brevard | Florida | 12009 | 7656 | 235 |
278269 | 278269 | 2020-06-27 | Kane | Illinois | 17089 | 7656 | 265 |
182729 | 182729 | 2020-05-27 | Plymouth | Massachusetts | 25023 | 7656 | 530 |
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);