ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
134 rows where cases = 4661 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Georgia 31
- Tennessee 16
- Oklahoma 8
- Wisconsin 8
- North Carolina 6
- Ohio 6
- Texas 6
- Virginia 6
- Arkansas 5
- Indiana 5
- Kansas 5
- Illinois 4
- Kentucky 3
- Mississippi 3
- New York 3
- Wyoming 3
- North Dakota 2
- Utah 2
- California 1
- Colorado 1
- Florida 1
- Idaho 1
- Maryland 1
- Michigan 1
- Minnesota 1
- Missouri 1
- New Hampshire 1
- Puerto Rico 1
- South Carolina 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2444758 | 2444758 | 2022-04-26 | Worth | Georgia | 13321 | 4661 | 117 |
2446746 | 2446746 | 2022-04-26 | Bledsoe | Tennessee | 47007 | 4661 | 57 |
2441502 | 2441502 | 2022-04-25 | Worth | Georgia | 13321 | 4661 | 117 |
2443491 | 2443491 | 2022-04-25 | Bledsoe | Tennessee | 47007 | 4661 | 57 |
2438246 | 2438246 | 2022-04-24 | Worth | Georgia | 13321 | 4661 | 117 |
2440235 | 2440235 | 2022-04-24 | Bledsoe | Tennessee | 47007 | 4661 | 57 |
2434990 | 2434990 | 2022-04-23 | Worth | Georgia | 13321 | 4661 | 117 |
2436979 | 2436979 | 2022-04-23 | Bledsoe | Tennessee | 47007 | 4661 | 57 |
2431734 | 2431734 | 2022-04-22 | Worth | Georgia | 13321 | 4661 | 117 |
2433723 | 2433723 | 2022-04-22 | Bledsoe | Tennessee | 47007 | 4661 | 57 |
2428478 | 2428478 | 2022-04-21 | Worth | Georgia | 13321 | 4661 | 117 |
2430467 | 2430467 | 2022-04-21 | Bledsoe | Tennessee | 47007 | 4661 | 57 |
2425222 | 2425222 | 2022-04-20 | Worth | Georgia | 13321 | 4661 | 117 |
2427211 | 2427211 | 2022-04-20 | Bledsoe | Tennessee | 47007 | 4661 | 57 |
2421910 | 2421910 | 2022-04-19 | Morgan | Georgia | 13211 | 4661 | 67 |
2421966 | 2421966 | 2022-04-19 | Worth | Georgia | 13321 | 4661 | 116 |
2423955 | 2423955 | 2022-04-19 | Bledsoe | Tennessee | 47007 | 4661 | 56 |
2418654 | 2418654 | 2022-04-18 | Morgan | Georgia | 13211 | 4661 | 67 |
2418710 | 2418710 | 2022-04-18 | Worth | Georgia | 13321 | 4661 | 116 |
2420699 | 2420699 | 2022-04-18 | Bledsoe | Tennessee | 47007 | 4661 | 56 |
2415398 | 2415398 | 2022-04-17 | Morgan | Georgia | 13211 | 4661 | 67 |
2415454 | 2415454 | 2022-04-17 | Worth | Georgia | 13321 | 4661 | 116 |
2417443 | 2417443 | 2022-04-17 | Bledsoe | Tennessee | 47007 | 4661 | 56 |
2412142 | 2412142 | 2022-04-16 | Morgan | Georgia | 13211 | 4661 | 67 |
2412198 | 2412198 | 2022-04-16 | Worth | Georgia | 13321 | 4661 | 116 |
2414187 | 2414187 | 2022-04-16 | Bledsoe | Tennessee | 47007 | 4661 | 56 |
2408886 | 2408886 | 2022-04-15 | Morgan | Georgia | 13211 | 4661 | 67 |
2408942 | 2408942 | 2022-04-15 | Worth | Georgia | 13321 | 4661 | 116 |
2410931 | 2410931 | 2022-04-15 | Bledsoe | Tennessee | 47007 | 4661 | 56 |
2407675 | 2407675 | 2022-04-14 | Bledsoe | Tennessee | 47007 | 4661 | 56 |
2402431 | 2402431 | 2022-04-13 | Worth | Georgia | 13321 | 4661 | 116 |
2404419 | 2404419 | 2022-04-13 | Bledsoe | Tennessee | 47007 | 4661 | 56 |
2399176 | 2399176 | 2022-04-12 | Worth | Georgia | 13321 | 4661 | 116 |
2401425 | 2401425 | 2022-04-12 | Montague | Texas | 48337 | 4661 | 127 |
2395865 | 2395865 | 2022-04-11 | Morgan | Georgia | 13211 | 4661 | 67 |
2395921 | 2395921 | 2022-04-11 | Worth | Georgia | 13321 | 4661 | 116 |
2398170 | 2398170 | 2022-04-11 | Montague | Texas | 48337 | 4661 | 127 |
2324557 | 2324557 | 2022-03-20 | Perry | Indiana | 18123 | 4661 | 68 |
2321303 | 2321303 | 2022-03-19 | Perry | Indiana | 18123 | 4661 | 68 |
2318049 | 2318049 | 2022-03-18 | Perry | Indiana | 18123 | 4661 | 68 |
2314460 | 2314460 | 2022-03-17 | Crisp | Georgia | 13081 | 4661 | 134 |
2311207 | 2311207 | 2022-03-16 | Crisp | Georgia | 13081 | 4661 | 134 |
2285192 | 2285192 | 2022-03-08 | Crisp | Georgia | 13081 | 4661 | 133 |
2281940 | 2281940 | 2022-03-07 | Crisp | Georgia | 13081 | 4661 | 131 |
2236116 | 2236116 | 2022-02-21 | Cross | Arkansas | 5037 | 4661 | 75 |
2232865 | 2232865 | 2022-02-20 | Cross | Arkansas | 5037 | 4661 | 75 |
2229614 | 2229614 | 2022-02-19 | Cross | Arkansas | 5037 | 4661 | 75 |
2214283 | 2214283 | 2022-02-14 | Henry | Kentucky | 21103 | 4661 | 45 |
2215162 | 2215162 | 2022-02-14 | Currituck | North Carolina | 37053 | 4661 | 32 |
2174937 | 2174937 | 2022-02-02 | Jay | Indiana | 18075 | 4661 | 75 |
2144881 | 2144881 | 2022-01-23 | Vilas | Wisconsin | 55125 | 4661 | 83 |
2141626 | 2141626 | 2022-01-22 | Vilas | Wisconsin | 55125 | 4661 | 83 |
2138370 | 2138370 | 2022-01-21 | Vilas | Wisconsin | 55125 | 4661 | 83 |
2126913 | 2126913 | 2022-01-18 | Crawford | Missouri | 29055 | 4661 | 83 |
2099838 | 2099838 | 2022-01-10 | Harris | Georgia | 13145 | 4661 | 96 |
2086664 | 2086664 | 2022-01-06 | Pitkin | Colorado | 8097 | 4661 | 6 |
2063095 | 2063095 | 2021-12-29 | Hockley | Texas | 48219 | 4661 | 140 |
1969992 | 1969992 | 2021-12-01 | Iroquois | Illinois | 17075 | 4661 | 85 |
1936991 | 1936991 | 2021-11-21 | Johnson | Arkansas | 5071 | 4661 | 58 |
1929179 | 1929179 | 2021-11-18 | Fayette | Ohio | 39047 | 4661 | 67 |
1925247 | 1925247 | 2021-11-17 | Todd | Minnesota | 27153 | 4661 | 40 |
1925895 | 1925895 | 2021-11-17 | Stutsman | North Dakota | 38093 | 4661 | 90 |
1917930 | 1917930 | 2021-11-15 | Latah | Idaho | 16057 | 4661 | 37 |
1896521 | 1896521 | 2021-11-08 | Cherokee | North Carolina | 37039 | 4661 | 77 |
1880808 | 1880808 | 2021-11-03 | Union | South Carolina | 45087 | 4661 | 106 |
1859040 | 1859040 | 2021-10-28 | Yell | Arkansas | 5149 | 4661 | 78 |
1860974 | 1860974 | 2021-10-28 | Morrow | Ohio | 39117 | 4661 | 58 |
1849515 | 1849515 | 2021-10-25 | Butts | Georgia | 13035 | 4661 | 113 |
1844456 | 1844456 | 2021-10-23 | Allegany | New York | 36003 | 4661 | 98 |
1823544 | 1823544 | 2021-10-17 | Dawson | Georgia | 13085 | 4661 | 66 |
1820295 | 1820295 | 2021-10-16 | Dawson | Georgia | 13085 | 4661 | 66 |
1817046 | 1817046 | 2021-10-15 | Dawson | Georgia | 13085 | 4661 | 66 |
1786021 | 1786021 | 2021-10-05 | Tioga | New York | 36107 | 4661 | 68 |
1778561 | 1778561 | 2021-10-03 | Harvey | Kansas | 20079 | 4661 | 78 |
1780868 | 1780868 | 2021-10-03 | Sheridan | Wyoming | 56033 | 4661 | 41 |
1775311 | 1775311 | 2021-10-02 | Harvey | Kansas | 20079 | 4661 | 78 |
1777618 | 1777618 | 2021-10-02 | Sheridan | Wyoming | 56033 | 4661 | 41 |
1772061 | 1772061 | 2021-10-01 | Harvey | Kansas | 20079 | 4661 | 78 |
1774368 | 1774368 | 2021-10-01 | Sheridan | Wyoming | 56033 | 4661 | 41 |
1739306 | 1739306 | 2021-09-21 | Montgomery | Illinois | 17135 | 4661 | 82 |
1717676 | 1717676 | 2021-09-14 | Cheshire | New Hampshire | 33005 | 4661 | 42 |
1702604 | 1702604 | 2021-09-09 | Charlottesville city | Virginia | 51540 | 4661 | 58 |
1653014 | 1653014 | 2021-08-25 | Fulton | Ohio | 39051 | 4661 | 78 |
1626835 | 1626835 | 2021-08-17 | Tompkins | New York | 36109 | 4661 | 54 |
1556068 | 1556068 | 2021-07-26 | Obion | Tennessee | 47131 | 4661 | 97 |
1520511 | 1520511 | 2021-07-15 | Kerr | Texas | 48265 | 4661 | 93 |
1498150 | 1498150 | 2021-07-08 | Marion | West Virginia | 54049 | 4661 | 52 |
1468597 | 1468597 | 2021-06-29 | Medina | Texas | 48325 | 4661 | 107 |
1438072 | 1438072 | 2021-06-20 | Oktibbeha | Mississippi | 28105 | 4661 | 98 |
1434825 | 1434825 | 2021-06-19 | Oktibbeha | Mississippi | 28105 | 4661 | 98 |
1431578 | 1431578 | 2021-06-18 | Oktibbeha | Mississippi | 28105 | 4661 | 98 |
1394148 | 1394148 | 2021-06-06 | Henry | Virginia | 51089 | 4661 | 124 |
1390903 | 1390903 | 2021-06-05 | Henry | Virginia | 51089 | 4661 | 124 |
1377107 | 1377107 | 2021-06-01 | Delaware | Oklahoma | 40041 | 4661 | 94 |
1373861 | 1373861 | 2021-05-31 | Delaware | Oklahoma | 40041 | 4661 | 94 |
1370616 | 1370616 | 2021-05-30 | Delaware | Oklahoma | 40041 | 4661 | 94 |
1367370 | 1367370 | 2021-05-29 | Delaware | Oklahoma | 40041 | 4661 | 94 |
1364124 | 1364124 | 2021-05-28 | Delaware | Oklahoma | 40041 | 4661 | 94 |
1360878 | 1360878 | 2021-05-27 | Delaware | Oklahoma | 40041 | 4661 | 94 |
1356213 | 1356213 | 2021-05-26 | Lawrence | Indiana | 18093 | 4661 | 124 |
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);