ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
81 rows where cases = 5592 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 28
- Puerto Rico 7
- Missouri 6
- Texas 6
- Michigan 5
- Minnesota 5
- Ohio 5
- Georgia 4
- Kentucky 4
- North Carolina 4
- Wisconsin 4
- Alabama 3
- Kansas 3
- Maryland 3
- Arizona 2
- Illinois 2
- Indiana 2
- New York 2
- South Carolina 2
- Utah 2
- West Virginia 2
- Arkansas 1
- Connecticut 1
- Iowa 1
- Louisiana 1
- New Mexico 1
- South Dakota 1
- Virginia 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2469834 | 2469834 | 2022-05-03 | San Jacinto | Texas | 48407 | 5592 | 101 |
2466578 | 2466578 | 2022-05-02 | San Jacinto | Texas | 48407 | 5592 | 101 |
2463323 | 2463323 | 2022-05-01 | San Jacinto | Texas | 48407 | 5592 | 101 |
2460067 | 2460067 | 2022-04-30 | San Jacinto | Texas | 48407 | 5592 | 101 |
2356197 | 2356197 | 2022-03-29 | McDowell | West Virginia | 54047 | 5592 | 71 |
2287396 | 2287396 | 2022-03-08 | Austin | Texas | 48015 | 5592 | 71 |
2279365 | 2279365 | 2022-03-06 | Simpson | Kentucky | 21213 | 5592 | 87 |
2276112 | 2276112 | 2022-03-05 | Simpson | Kentucky | 21213 | 5592 | 87 |
2272859 | 2272859 | 2022-03-04 | Simpson | Kentucky | 21213 | 5592 | 87 |
2269607 | 2269607 | 2022-03-03 | Simpson | Kentucky | 21213 | 5592 | 84 |
2211541 | 2211541 | 2022-02-13 | McDonald | Missouri | 29119 | 5592 | 64 |
2208288 | 2208288 | 2022-02-12 | McDonald | Missouri | 29119 | 5592 | 64 |
2205035 | 2205035 | 2022-02-11 | McDonald | Missouri | 29119 | 5592 | 64 |
2201782 | 2201782 | 2022-02-10 | McDonald | Missouri | 29119 | 5592 | 64 |
2198528 | 2198528 | 2022-02-09 | McDonald | Missouri | 29119 | 5592 | 64 |
2155879 | 2155879 | 2022-01-27 | Caroline | Maryland | 24011 | 5592 | 63 |
2157151 | 2157151 | 2022-01-27 | Davison | South Dakota | 46035 | 5592 | 78 |
2123540 | 2123540 | 2022-01-17 | Todd | Minnesota | 27153 | 5592 | 54 |
2120288 | 2120288 | 2022-01-16 | Todd | Minnesota | 27153 | 5592 | 54 |
2117036 | 2117036 | 2022-01-15 | Todd | Minnesota | 27153 | 5592 | 54 |
2113785 | 2113785 | 2022-01-14 | Todd | Minnesota | 27153 | 5592 | 54 |
2087583 | 2087583 | 2022-01-06 | Dorchester | Maryland | 24019 | 5592 | 93 |
2016413 | 2016413 | 2021-12-15 | Lawrence | Missouri | 29109 | 5592 | 137 |
1992808 | 1992808 | 2021-12-08 | Adams | Indiana | 18001 | 5592 | 82 |
1988553 | 1988553 | 2021-12-06 | Charlottesville city | Virginia | 51540 | 5592 | 62 |
1966284 | 1966284 | 2021-11-30 | Unknown | Arkansas | 5592 | 0 | |
1939969 | 1939969 | 2021-11-21 | Marshall | West Virginia | 54051 | 5592 | 117 |
1872530 | 1872530 | 2021-11-01 | Randolph | Illinois | 17157 | 5592 | 109 |
1832692 | 1832692 | 2021-10-19 | Mason | Washington | 53045 | 5592 | 66 |
1766724 | 1766724 | 2021-09-29 | Highland | Ohio | 39071 | 5592 | 83 |
1758072 | 1758072 | 2021-09-26 | Marinette | Wisconsin | 55075 | 5592 | 77 |
1754824 | 1754824 | 2021-09-25 | Marinette | Wisconsin | 55075 | 5592 | 77 |
1751576 | 1751576 | 2021-09-24 | Marinette | Wisconsin | 55075 | 5592 | 77 |
1724525 | 1724525 | 2021-09-16 | Shelby | Ohio | 39149 | 5592 | 99 |
1646295 | 1646295 | 2021-08-23 | Genesee | New York | 36037 | 5592 | 124 |
1640078 | 1640078 | 2021-08-21 | Washington | Ohio | 39167 | 5592 | 111 |
1550652 | 1550652 | 2021-07-25 | Coffee | Georgia | 13069 | 5592 | 182 |
1547405 | 1547405 | 2021-07-24 | Coffee | Georgia | 13069 | 5592 | 182 |
1544158 | 1544158 | 2021-07-23 | Coffee | Georgia | 13069 | 5592 | 182 |
1510113 | 1510113 | 2021-07-12 | Huron | Ohio | 39077 | 5592 | 122 |
1487690 | 1487690 | 2021-07-05 | Unknown | Puerto Rico | 5592 | 2552 | |
1477950 | 1477950 | 2021-07-02 | Unknown | Puerto Rico | 5592 | 2550 | |
1474704 | 1474704 | 2021-07-01 | Unknown | Puerto Rico | 5592 | 2549 | |
1446442 | 1446442 | 2021-06-23 | Graham | Arizona | 4009 | 5592 | 84 |
1448742 | 1448742 | 2021-06-23 | Unknown | Puerto Rico | 5592 | 2543 | |
1420026 | 1420026 | 2021-06-14 | Summit | Utah | 49043 | 5592 | 13 |
1416284 | 1416284 | 2021-06-13 | Unknown | Puerto Rico | 5592 | 2530 | |
1382688 | 1382688 | 2021-06-03 | Chippewa | Michigan | 26033 | 5592 | 49 |
1379442 | 1379442 | 2021-06-02 | Chippewa | Michigan | 26033 | 5592 | 49 |
1380584 | 1380584 | 2021-06-02 | Unknown | Puerto Rico | 5592 | 2509 | |
1376197 | 1376197 | 2021-06-01 | Chippewa | Michigan | 26033 | 5592 | 49 |
1342491 | 1342491 | 2021-05-22 | Coffee | Alabama | 1031 | 5592 | 120 |
1343124 | 1343124 | 2021-05-22 | Knox | Illinois | 17095 | 5592 | 181 |
1335996 | 1335996 | 2021-05-20 | Coffee | Alabama | 1031 | 5592 | 118 |
1332749 | 1332749 | 2021-05-19 | Coffee | Alabama | 1031 | 5592 | 118 |
1294252 | 1294252 | 2021-05-07 | Laurens | Georgia | 13175 | 5592 | 167 |
1294535 | 1294535 | 2021-05-07 | Noble | Indiana | 18113 | 5592 | 86 |
1293179 | 1293179 | 2021-05-06 | Caldwell | Texas | 48055 | 5592 | 97 |
1285286 | 1285286 | 2021-05-04 | Barry | Michigan | 26015 | 5592 | 64 |
1242713 | 1242713 | 2021-04-21 | Warren | Iowa | 19181 | 5592 | 86 |
1165732 | 1165732 | 2021-03-28 | Cayuga | New York | 36011 | 5592 | 90 |
1143106 | 1143106 | 2021-03-21 | Lee | North Carolina | 37105 | 5592 | 73 |
1143107 | 1143107 | 2021-03-21 | Lenoir | North Carolina | 37107 | 5592 | 109 |
1139859 | 1139859 | 2021-03-20 | Lee | North Carolina | 37105 | 5592 | 73 |
1139860 | 1139860 | 2021-03-20 | Lenoir | North Carolina | 37107 | 5592 | 109 |
1108645 | 1108645 | 2021-03-10 | Sauk | Wisconsin | 55111 | 5592 | 49 |
1096622 | 1096622 | 2021-03-07 | Ford | Kansas | 20057 | 5592 | 10 |
1093376 | 1093376 | 2021-03-06 | Ford | Kansas | 20057 | 5592 | 10 |
1090130 | 1090130 | 2021-03-05 | Ford | Kansas | 20057 | 5592 | 10 |
1059093 | 1059093 | 2021-02-23 | Caguas | Puerto Rico | 72025 | 5592 | |
996417 | 996417 | 2021-02-04 | Blue Earth | Minnesota | 27013 | 5592 | 34 |
984540 | 984540 | 2021-01-31 | Kershaw | South Carolina | 45055 | 5592 | 94 |
949299 | 949299 | 2021-01-20 | Tooele | Utah | 49045 | 5592 | 17 |
919037 | 919037 | 2021-01-11 | Valencia | New Mexico | 35061 | 5592 | 70 |
905420 | 905420 | 2021-01-07 | Carroll | Maryland | 24013 | 5592 | 177 |
867411 | 867411 | 2020-12-26 | Wayne | Ohio | 39169 | 5592 | 139 |
758486 | 758486 | 2020-11-23 | New London | Connecticut | 9011 | 5592 | 163 |
746466 | 746466 | 2020-11-19 | Jackson | Michigan | 26075 | 5592 | 109 |
608117 | 608117 | 2020-10-07 | Berkeley | South Carolina | 45015 | 5592 | 90 |
479543 | 479543 | 2020-08-29 | Navajo | Arizona | 4017 | 5592 | 219 |
71151 | 71151 | 2020-04-19 | Jefferson | Louisiana | 22051 | 5592 | 282 |
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);