ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
88 rows where cases = 4942 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 14
- Oklahoma 7
- North Carolina 6
- North Dakota 5
- Texas 5
- Virginia 5
- California 4
- Ohio 4
- South Dakota 4
- Missouri 3
- Wyoming 3
- Alabama 2
- Kansas 2
- Maryland 2
- Minnesota 2
- New Mexico 2
- Pennsylvania 2
- Tennessee 2
- Colorado 1
- Florida 1
- Idaho 1
- Illinois 1
- Indiana 1
- Kentucky 1
- Louisiana 1
- Michigan 1
- Mississippi 1
- New York 1
- Oregon 1
- Washington 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2489505 | 2489505 | 2022-05-09 | Colonial Heights city | Virginia | 51570 | 4942 | 97 |
2467399 | 2467399 | 2022-05-03 | Berrien | Georgia | 13019 | 4942 | 83 |
2464144 | 2464144 | 2022-05-02 | Berrien | Georgia | 13019 | 4942 | 83 |
2460888 | 2460888 | 2022-05-01 | Berrien | Georgia | 13019 | 4942 | 83 |
2463285 | 2463285 | 2022-05-01 | Milam | Texas | 48331 | 4942 | 102 |
2457632 | 2457632 | 2022-04-30 | Berrien | Georgia | 13019 | 4942 | 83 |
2460029 | 2460029 | 2022-04-30 | Milam | Texas | 48331 | 4942 | 102 |
2454376 | 2454376 | 2022-04-29 | Berrien | Georgia | 13019 | 4942 | 83 |
2451120 | 2451120 | 2022-04-28 | Berrien | Georgia | 13019 | 4942 | 83 |
2447864 | 2447864 | 2022-04-27 | Berrien | Georgia | 13019 | 4942 | 83 |
2419518 | 2419518 | 2022-04-18 | Hubbard | Minnesota | 27057 | 4942 | 59 |
2331875 | 2331875 | 2022-03-22 | Perry | Missouri | 29157 | 4942 | 45 |
2328977 | 2328977 | 2022-03-21 | Currituck | North Carolina | 37053 | 4942 | 32 |
2225244 | 2225244 | 2022-02-17 | Union | Oregon | 41061 | 4942 | 71 |
2191679 | 2191679 | 2022-02-07 | Somerset | Maryland | 24039 | 4942 | 67 |
2193231 | 2193231 | 2022-02-07 | Limestone | Texas | 48293 | 4942 | 116 |
2178043 | 2178043 | 2022-02-03 | Payette | Idaho | 16075 | 4942 | 78 |
2132184 | 2132184 | 2022-01-20 | Morgan | Colorado | 8087 | 4942 | 128 |
2075866 | 2075866 | 2022-01-02 | Lawrence | South Dakota | 46081 | 4942 | 76 |
2072615 | 2072615 | 2022-01-01 | Lawrence | South Dakota | 46081 | 4942 | 76 |
2069364 | 2069364 | 2021-12-31 | Lawrence | South Dakota | 46081 | 4942 | 76 |
2066113 | 2066113 | 2021-12-30 | Lawrence | South Dakota | 46081 | 4942 | 76 |
1979335 | 1979335 | 2021-12-04 | Siskiyou | California | 6093 | 4942 | 74 |
1976085 | 1976085 | 2021-12-03 | Siskiyou | California | 6093 | 4942 | 74 |
1972836 | 1972836 | 2021-12-02 | Siskiyou | California | 6093 | 4942 | 74 |
1969232 | 1969232 | 2021-11-30 | Mingo | West Virginia | 54059 | 4942 | 84 |
1932465 | 1932465 | 2021-11-19 | Morrow | Ohio | 39117 | 4942 | 63 |
1877000 | 1877000 | 2021-11-02 | Washington | New York | 36115 | 4942 | 69 |
1854317 | 1854317 | 2021-10-26 | Macon | North Carolina | 37113 | 4942 | 67 |
1827016 | 1827016 | 2021-10-18 | Logan | Illinois | 17107 | 4942 | 87 |
1813412 | 1813412 | 2021-10-14 | Marion | Alabama | 1093 | 4942 | 126 |
1811194 | 1811194 | 2021-10-13 | Marshall | Kentucky | 21157 | 4942 | 76 |
1806621 | 1806621 | 2021-10-11 | Manassas city | Virginia | 51683 | 4942 | 51 |
1803371 | 1803371 | 2021-10-10 | Manassas city | Virginia | 51683 | 4942 | 51 |
1800122 | 1800122 | 2021-10-09 | Manassas city | Virginia | 51683 | 4942 | 51 |
1796873 | 1796873 | 2021-10-08 | Manassas city | Virginia | 51683 | 4942 | 51 |
1763469 | 1763469 | 2021-09-28 | Guernsey | Ohio | 39059 | 4942 | 64 |
1733721 | 1733721 | 2021-09-19 | Polk | Missouri | 29167 | 4942 | 52 |
1719642 | 1719642 | 2021-09-15 | Pickens | Georgia | 13227 | 4942 | 92 |
1700190 | 1700190 | 2021-09-09 | Upson | Georgia | 13293 | 4942 | 138 |
1701568 | 1701568 | 2021-09-09 | Bladen | North Carolina | 37017 | 4942 | 84 |
1690406 | 1690406 | 2021-09-06 | Oconee | Georgia | 13219 | 4942 | 75 |
1687156 | 1687156 | 2021-09-05 | Oconee | Georgia | 13219 | 4942 | 75 |
1683906 | 1683906 | 2021-09-04 | Oconee | Georgia | 13219 | 4942 | 75 |
1680655 | 1680655 | 2021-09-03 | Oconee | Georgia | 13219 | 4942 | 75 |
1608727 | 1608727 | 2021-08-12 | Escambia | Alabama | 1053 | 4942 | 84 |
1604410 | 1604410 | 2021-08-10 | Ottawa | Oklahoma | 40115 | 4942 | 76 |
1601161 | 1601161 | 2021-08-09 | Ottawa | Oklahoma | 40115 | 4942 | 76 |
1597913 | 1597913 | 2021-08-08 | Ottawa | Oklahoma | 40115 | 4942 | 76 |
1594664 | 1594664 | 2021-08-07 | Ottawa | Oklahoma | 40115 | 4942 | 76 |
1590818 | 1590818 | 2021-08-06 | Webster | Missouri | 29225 | 4942 | 67 |
1591415 | 1591415 | 2021-08-06 | Ottawa | Oklahoma | 40115 | 4942 | 76 |
1588073 | 1588073 | 2021-08-05 | Mercer | Ohio | 39107 | 4942 | 85 |
1588166 | 1588166 | 2021-08-05 | Ottawa | Oklahoma | 40115 | 4942 | 76 |
1584916 | 1584916 | 2021-08-04 | Ottawa | Oklahoma | 40115 | 4942 | 76 |
1562840 | 1562840 | 2021-07-28 | Wilson | Texas | 48493 | 4942 | 72 |
1495943 | 1495943 | 2021-07-08 | Crawford | Kansas | 20037 | 4942 | 83 |
1492697 | 1492697 | 2021-07-07 | Crawford | Kansas | 20037 | 4942 | 83 |
1441899 | 1441899 | 2021-06-21 | Stark | North Dakota | 38089 | 4942 | 51 |
1438654 | 1438654 | 2021-06-20 | Stark | North Dakota | 38089 | 4942 | 51 |
1435407 | 1435407 | 2021-06-19 | Stark | North Dakota | 38089 | 4942 | 51 |
1432160 | 1432160 | 2021-06-18 | Stark | North Dakota | 38089 | 4942 | 51 |
1422372 | 1422372 | 2021-06-15 | Watauga | North Carolina | 37189 | 4942 | 32 |
1419126 | 1419126 | 2021-06-14 | Watauga | North Carolina | 37189 | 4942 | 32 |
1352138 | 1352138 | 2021-05-24 | Douglas | Wisconsin | 55031 | 4942 | 58 |
1346251 | 1346251 | 2021-05-23 | Tift | Georgia | 13277 | 4942 | 126 |
1175905 | 1175905 | 2021-03-31 | Columbia | Pennsylvania | 42037 | 4942 | 128 |
1121654 | 1121654 | 2021-03-14 | Fremont | Wyoming | 56013 | 4942 | 82 |
1118407 | 1118407 | 2021-03-13 | Fremont | Wyoming | 56013 | 4942 | 82 |
1115160 | 1115160 | 2021-03-12 | Fremont | Wyoming | 56013 | 4942 | 82 |
1094727 | 1094727 | 2021-03-06 | Carbon | Pennsylvania | 42025 | 4942 | 152 |
1091024 | 1091024 | 2021-03-05 | Curry | New Mexico | 35009 | 4942 | 68 |
1081503 | 1081503 | 2021-03-02 | Morton | North Dakota | 38059 | 4942 | 94 |
1081536 | 1081536 | 2021-03-02 | Belmont | Ohio | 39013 | 4942 | 59 |
1028749 | 1028749 | 2021-02-14 | Cecil | Maryland | 24015 | 4942 | 114 |
978154 | 978154 | 2021-01-29 | Dyer | Tennessee | 47045 | 4942 | 87 |
947174 | 947174 | 2021-01-20 | Shelby | Indiana | 18145 | 4942 | 90 |
944439 | 944439 | 2021-01-19 | Lapeer | Michigan | 26087 | 4942 | 116 |
938113 | 938113 | 2021-01-17 | Lafayette | Mississippi | 28071 | 4942 | 92 |
919727 | 919727 | 2021-01-11 | Carter | Tennessee | 47019 | 4942 | 103 |
772991 | 772991 | 2020-11-27 | Santa Fe | New Mexico | 35049 | 4942 | 35 |
670400 | 670400 | 2020-10-26 | Franklin | Washington | 53021 | 4942 | 68 |
659506 | 659506 | 2020-10-23 | Alamance | North Carolina | 37001 | 4942 | 72 |
636293 | 636293 | 2020-10-16 | Washington | Minnesota | 27163 | 4942 | 66 |
586610 | 586610 | 2020-10-01 | Martin | Florida | 12085 | 4942 | 143 |
498233 | 498233 | 2020-09-03 | Bell | Texas | 48027 | 4942 | 65 |
453833 | 453833 | 2020-08-21 | Sonoma | California | 6097 | 4942 | 70 |
39055 | 39055 | 2020-04-07 | Orleans | Louisiana | 22071 | 4942 | 185 |
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);