ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79 rows where cases = 5737 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kansas 10
- Virginia 8
- Oklahoma 7
- Kentucky 5
- Texas 5
- Georgia 4
- Maine 4
- California 3
- Mississippi 3
- Pennsylvania 3
- Puerto Rico 3
- Wisconsin 3
- Illinois 2
- New York 2
- Arkansas 1
- Colorado 1
- Florida 1
- Indiana 1
- Iowa 1
- Maryland 1
- Minnesota 1
- Missouri 1
- Montana 1
- Nevada 1
- North Carolina 1
- Ohio 1
- Oregon 1
- South Carolina 1
- Tennessee 1
- Vermont 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502628 | 2502628 | 2022-05-13 | Staunton city | Virginia | 51790 | 5737 | 115 |
2489589 | 2489589 | 2022-05-09 | Salem city | Virginia | 51775 | 5737 | 97 |
2422608 | 2422608 | 2022-04-19 | Franklin | Maine | 23007 | 5737 | 59 |
2419352 | 2419352 | 2022-04-18 | Franklin | Maine | 23007 | 5737 | 59 |
2416096 | 2416096 | 2022-04-17 | Franklin | Maine | 23007 | 5737 | 59 |
2412840 | 2412840 | 2022-04-16 | Franklin | Maine | 23007 | 5737 | 59 |
2406108 | 2406108 | 2022-04-14 | Pottawatomie | Kansas | 20149 | 5737 | 55 |
2402852 | 2402852 | 2022-04-13 | Pottawatomie | Kansas | 20149 | 5737 | 55 |
2399598 | 2399598 | 2022-04-12 | Pottawatomie | Kansas | 20149 | 5737 | 55 |
2396342 | 2396342 | 2022-04-11 | Pottawatomie | Kansas | 20149 | 5737 | 55 |
2393087 | 2393087 | 2022-04-10 | Pottawatomie | Kansas | 20149 | 5737 | 55 |
2389831 | 2389831 | 2022-04-09 | Pottawatomie | Kansas | 20149 | 5737 | 55 |
2386575 | 2386575 | 2022-04-08 | Pottawatomie | Kansas | 20149 | 5737 | 55 |
2354608 | 2354608 | 2022-03-29 | Henry | Missouri | 29083 | 5737 | 83 |
2326165 | 2326165 | 2022-03-20 | Juana Diaz | Puerto Rico | 72075 | 5737 | |
2319994 | 2319994 | 2022-03-18 | Frio | Texas | 48163 | 5737 | 92 |
2297208 | 2297208 | 2022-03-11 | Dimmit | Texas | 48127 | 5737 | 51 |
2279739 | 2279739 | 2022-03-06 | Sunflower | Mississippi | 28133 | 5737 | 120 |
2276486 | 2276486 | 2022-03-05 | Sunflower | Mississippi | 28133 | 5737 | 120 |
2273233 | 2273233 | 2022-03-04 | Sunflower | Mississippi | 28133 | 5737 | 120 |
2157043 | 2157043 | 2022-01-27 | Juncos | Puerto Rico | 72077 | 5737 | |
2129980 | 2129980 | 2022-01-19 | Cass | Minnesota | 27021 | 5737 | 69 |
2109756 | 2109756 | 2022-01-13 | Fayette | Illinois | 17051 | 5737 | 81 |
2076384 | 2076384 | 2022-01-02 | Petersburg city | Virginia | 51730 | 5737 | 109 |
2073133 | 2073133 | 2022-01-01 | Petersburg city | Virginia | 51730 | 5737 | 109 |
2069882 | 2069882 | 2021-12-31 | Petersburg city | Virginia | 51730 | 5737 | 109 |
1994428 | 1994428 | 2021-12-08 | Tioga | Pennsylvania | 42117 | 5737 | 157 |
1982022 | 1982022 | 2021-12-04 | Rutland | Vermont | 50021 | 5737 | 32 |
1975726 | 1975726 | 2021-12-02 | Marshall | West Virginia | 54051 | 5737 | 119 |
1966605 | 1966605 | 2021-11-30 | Pickens | Georgia | 13227 | 5737 | 120 |
1959789 | 1959789 | 2021-11-28 | Amador | California | 6005 | 5737 | 66 |
1956538 | 1956538 | 2021-11-27 | Amador | California | 6005 | 5737 | 66 |
1953287 | 1953287 | 2021-11-26 | Amador | California | 6005 | 5737 | 66 |
1937797 | 1937797 | 2021-11-21 | Lyon | Kansas | 20111 | 5737 | 94 |
1939234 | 1939234 | 2021-11-21 | Ponce | Puerto Rico | 72113 | 5737 | |
1934547 | 1934547 | 2021-11-20 | Lyon | Kansas | 20111 | 5737 | 94 |
1931296 | 1931296 | 2021-11-19 | Lyon | Kansas | 20111 | 5737 | 94 |
1895686 | 1895686 | 2021-11-08 | Muhlenberg | Kentucky | 21177 | 5737 | 93 |
1882095 | 1882095 | 2021-11-04 | Oconee | Georgia | 13219 | 5737 | 82 |
1876307 | 1876307 | 2021-11-02 | Calvert | Maryland | 24009 | 5737 | 101 |
1861717 | 1861717 | 2021-10-28 | Washington | Texas | 48477 | 5737 | 128 |
1858468 | 1858468 | 2021-10-27 | Washington | Texas | 48477 | 5737 | 128 |
1810037 | 1810037 | 2021-10-12 | Douglas | Wisconsin | 55031 | 5737 | 66 |
1797232 | 1797232 | 2021-10-09 | Baxter | Arkansas | 5005 | 5737 | 172 |
1766742 | 1766742 | 2021-09-29 | Mercer | Ohio | 39107 | 5737 | 90 |
1764579 | 1764579 | 2021-09-28 | Pierce | Wisconsin | 55093 | 5737 | 44 |
1689605 | 1689605 | 2021-09-05 | Campbell | Virginia | 51031 | 5737 | 115 |
1686355 | 1686355 | 2021-09-04 | Campbell | Virginia | 51031 | 5737 | 115 |
1683104 | 1683104 | 2021-09-03 | Campbell | Virginia | 51031 | 5737 | 115 |
1513420 | 1513420 | 2021-07-13 | Cherokee | Oklahoma | 40021 | 5737 | 79 |
1510174 | 1510174 | 2021-07-12 | Cherokee | Oklahoma | 40021 | 5737 | 79 |
1506927 | 1506927 | 2021-07-11 | Cherokee | Oklahoma | 40021 | 5737 | 79 |
1503681 | 1503681 | 2021-07-10 | Cherokee | Oklahoma | 40021 | 5737 | 79 |
1500435 | 1500435 | 2021-07-09 | Cherokee | Oklahoma | 40021 | 5737 | 79 |
1497189 | 1497189 | 2021-07-08 | Cherokee | Oklahoma | 40021 | 5737 | 79 |
1493942 | 1493942 | 2021-07-07 | Cherokee | Oklahoma | 40021 | 5737 | 79 |
1388425 | 1388425 | 2021-06-05 | Polk | Georgia | 13233 | 5737 | 97 |
1363855 | 1363855 | 2021-05-28 | Wayne | New York | 36117 | 5737 | 68 |
1360609 | 1360609 | 2021-05-27 | Wayne | New York | 36117 | 5737 | 68 |
1333075 | 1333075 | 2021-05-19 | Gadsden | Florida | 12039 | 5737 | 99 |
1292799 | 1292799 | 2021-05-06 | Bradford | Pennsylvania | 42015 | 5737 | 89 |
1278157 | 1278157 | 2021-05-02 | Clinton | Illinois | 17027 | 5737 | 99 |
1216112 | 1216112 | 2021-04-13 | Fremont | Colorado | 8043 | 5737 | 53 |
1201563 | 1201563 | 2021-04-08 | Lee | North Carolina | 37105 | 5737 | 75 |
996847 | 996847 | 2021-02-04 | Carson City | Nevada | 32510 | 5737 | 106 |
989349 | 989349 | 2021-02-02 | Morgan | Indiana | 18109 | 5737 | 107 |
986360 | 986360 | 2021-02-01 | Bullitt | Kentucky | 21029 | 5737 | 39 |
982609 | 982609 | 2021-01-31 | Rockdale | Georgia | 13247 | 5737 | 112 |
961663 | 961663 | 2021-01-24 | Crawford | Pennsylvania | 42039 | 5737 | 121 |
885767 | 885767 | 2021-01-01 | Daviess | Kentucky | 21059 | 5737 | 92 |
882522 | 882522 | 2020-12-31 | Daviess | Kentucky | 21059 | 5737 | 92 |
879277 | 879277 | 2020-12-30 | Daviess | Kentucky | 21059 | 5737 | 90 |
858389 | 858389 | 2020-12-23 | Walker | Texas | 48471 | 5737 | 79 |
831814 | 831814 | 2020-12-15 | Lane | Oregon | 41039 | 5737 | 73 |
764012 | 764012 | 2020-11-24 | Putnam | Tennessee | 47141 | 5737 | 79 |
753306 | 753306 | 2020-11-21 | Flathead | Montana | 30029 | 5737 | 30 |
737863 | 737863 | 2020-11-16 | Aiken | South Carolina | 45003 | 5737 | 92 |
699693 | 699693 | 2020-11-04 | Fond du Lac | Wisconsin | 55039 | 5737 | 24 |
671380 | 671380 | 2020-10-27 | Black Hawk | Iowa | 19013 | 5737 | 101 |
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);