ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
70 rows where cases = 5880 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 26
- South Dakota 7
- Tennessee 6
- Texas 6
- New York 5
- Missouri 4
- New Mexico 4
- West Virginia 4
- Alabama 3
- Indiana 3
- Louisiana 3
- North Carolina 3
- Wisconsin 3
- Arkansas 2
- Georgia 2
- Maine 2
- Michigan 2
- Ohio 2
- California 1
- Florida 1
- Minnesota 1
- Mississippi 1
- Pennsylvania 1
- Puerto Rico 1
- South Carolina 1
- Vermont 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2489460 | 2489460 | 2022-05-09 | Addison | Vermont | 50001 | 5880 | 17 |
2473375 | 2473375 | 2022-05-04 | Hampshire | West Virginia | 54027 | 5880 | 72 |
2470118 | 2470118 | 2022-05-03 | Hampshire | West Virginia | 54027 | 5880 | 72 |
2453433 | 2453433 | 2022-04-28 | Frio | Texas | 48163 | 5880 | 93 |
2449307 | 2449307 | 2022-04-27 | San Miguel | New Mexico | 35047 | 5880 | 58 |
2446050 | 2446050 | 2022-04-26 | San Miguel | New Mexico | 35047 | 5880 | 58 |
2442795 | 2442795 | 2022-04-25 | San Miguel | New Mexico | 35047 | 5880 | 58 |
2439563 | 2439563 | 2022-04-24 | Essex | New York | 36031 | 5880 | 59 |
2401111 | 2401111 | 2022-04-12 | Davison | South Dakota | 46035 | 5880 | 78 |
2397856 | 2397856 | 2022-04-11 | Davison | South Dakota | 46035 | 5880 | 78 |
2394601 | 2394601 | 2022-04-10 | Davison | South Dakota | 46035 | 5880 | 78 |
2391345 | 2391345 | 2022-04-09 | Davison | South Dakota | 46035 | 5880 | 78 |
2388089 | 2388089 | 2022-04-08 | Davison | South Dakota | 46035 | 5880 | 78 |
2384834 | 2384834 | 2022-04-07 | Davison | South Dakota | 46035 | 5880 | 78 |
2381579 | 2381579 | 2022-04-06 | Davison | South Dakota | 46035 | 5880 | 78 |
2291708 | 2291708 | 2022-03-10 | Emanuel | Georgia | 13107 | 5880 | 154 |
2287207 | 2287207 | 2022-03-08 | Jasper | South Carolina | 45053 | 5880 | 93 |
2202130 | 2202130 | 2022-02-10 | Ashe | North Carolina | 37009 | 5880 | 68 |
2192421 | 2192421 | 2022-02-07 | Martin | North Carolina | 37117 | 5880 | 81 |
2183056 | 2183056 | 2022-02-04 | Corozal | Puerto Rico | 72047 | 5880 | |
2088229 | 2088229 | 2022-01-06 | Delaware | New York | 36025 | 5880 | 59 |
2074947 | 2074947 | 2022-01-02 | Pulaski | Missouri | 29169 | 5880 | 100 |
2071696 | 2071696 | 2022-01-01 | Pulaski | Missouri | 29169 | 5880 | 100 |
2068445 | 2068445 | 2021-12-31 | Pulaski | Missouri | 29169 | 5880 | 100 |
2065194 | 2065194 | 2021-12-30 | Pulaski | Missouri | 29169 | 5880 | 100 |
2034371 | 2034371 | 2021-12-21 | Chambers | Alabama | 1017 | 5880 | 145 |
1993959 | 1993959 | 2021-12-08 | Chenango | New York | 36017 | 5880 | 98 |
1990127 | 1990127 | 2021-12-07 | Huron | Michigan | 26063 | 5880 | 108 |
1986877 | 1986877 | 2021-12-06 | Huron | Michigan | 26063 | 5880 | 108 |
1980959 | 1980959 | 2021-12-04 | Columbia | New York | 36021 | 5880 | 115 |
1972087 | 1972087 | 2021-12-01 | Hill | Texas | 48217 | 5880 | 169 |
1972092 | 1972092 | 2021-12-01 | Howard | Texas | 48227 | 5880 | 143 |
1972491 | 1972491 | 2021-12-01 | Preston | West Virginia | 54077 | 5880 | 103 |
1962185 | 1962185 | 2021-11-28 | Marion | Tennessee | 47115 | 5880 | 58 |
1958934 | 1958934 | 2021-11-27 | Marion | Tennessee | 47115 | 5880 | 58 |
1955683 | 1955683 | 2021-11-26 | Marion | Tennessee | 47115 | 5880 | 58 |
1952432 | 1952432 | 2021-11-25 | Marion | Tennessee | 47115 | 5880 | 58 |
1948879 | 1948879 | 2021-11-24 | Clinton | Pennsylvania | 42035 | 5880 | 86 |
1949181 | 1949181 | 2021-11-24 | Marion | Tennessee | 47115 | 5880 | 58 |
1861951 | 1861951 | 2021-10-28 | Whitman | Washington | 53075 | 5880 | 79 |
1747757 | 1747757 | 2021-09-23 | Weakley | Tennessee | 47183 | 5880 | 77 |
1642308 | 1642308 | 2021-08-22 | Avoyelles | Louisiana | 22009 | 5880 | 138 |
1639058 | 1639058 | 2021-08-21 | Avoyelles | Louisiana | 22009 | 5880 | 138 |
1635808 | 1635808 | 2021-08-20 | Avoyelles | Louisiana | 22009 | 5880 | 138 |
1584609 | 1584609 | 2021-08-04 | Wayne | New York | 36117 | 5880 | 73 |
1523143 | 1523143 | 2021-07-16 | Union | Ohio | 39159 | 5880 | 49 |
1519895 | 1519895 | 2021-07-15 | Union | Ohio | 39159 | 5880 | 49 |
1380980 | 1380980 | 2021-06-02 | Navarro | Texas | 48349 | 5880 | 154 |
1372412 | 1372412 | 2021-05-31 | Dearborn | Indiana | 18029 | 5880 | 81 |
1369167 | 1369167 | 2021-05-30 | Dearborn | Indiana | 18029 | 5880 | 81 |
1291720 | 1291720 | 2021-05-06 | Kennebec | Maine | 23011 | 5880 | 69 |
1277451 | 1277451 | 2021-05-01 | Barron | Wisconsin | 55005 | 5880 | 83 |
1213785 | 1213785 | 2021-04-12 | Androscoggin | Maine | 23001 | 5880 | 59 |
1205992 | 1205992 | 2021-04-09 | Raleigh | West Virginia | 54081 | 5880 | 74 |
1199579 | 1199579 | 2021-04-07 | Waupaca | Wisconsin | 55135 | 5880 | 161 |
1180245 | 1180245 | 2021-04-02 | Crittenden | Arkansas | 5035 | 5880 | 95 |
1089582 | 1089582 | 2021-03-05 | Putnam | Florida | 12107 | 5880 | 128 |
1077675 | 1077675 | 2021-03-01 | Lamar | Mississippi | 28073 | 5880 | 80 |
1064575 | 1064575 | 2021-02-25 | Blue Earth | Minnesota | 27013 | 5880 | 35 |
1015316 | 1015316 | 2021-02-10 | Morgan | Indiana | 18109 | 5880 | 129 |
1008084 | 1008084 | 2021-02-08 | Colbert | Alabama | 1033 | 5880 | 111 |
933482 | 933482 | 2021-01-16 | Walker | Alabama | 1127 | 5880 | 174 |
881447 | 881447 | 2020-12-30 | Portage | Wisconsin | 55097 | 5880 | 54 |
831394 | 831394 | 2020-12-15 | Lea | New Mexico | 35025 | 5880 | 69 |
799082 | 799082 | 2020-12-05 | Onslow | North Carolina | 37133 | 5880 | 45 |
541295 | 541295 | 2020-09-17 | Bibb | Georgia | 13021 | 5880 | 154 |
427954 | 427954 | 2020-08-13 | Pulaski | Arkansas | 5119 | 5880 | 88 |
420841 | 420841 | 2020-08-10 | Jefferson | Texas | 48245 | 5880 | 84 |
417620 | 417620 | 2020-08-09 | Jefferson | Texas | 48245 | 5880 | 84 |
370088 | 370088 | 2020-07-26 | Santa Barbara | California | 6083 | 5880 | 32 |
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);