ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
100 rows where cases = 4203 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 11
- Texas 9
- Virginia 8
- Mississippi 6
- North Carolina 6
- Georgia 5
- Indiana 5
- Louisiana 5
- Minnesota 5
- New Hampshire 4
- New York 4
- Missouri 3
- New Mexico 3
- Ohio 3
- Pennsylvania 3
- West Virginia 3
- Iowa 2
- Nevada 2
- Alabama 1
- California 1
- Colorado 1
- Maryland 1
- Massachusetts 1
- Michigan 1
- North Dakota 1
- Puerto Rico 1
- South Carolina 1
- South Dakota 1
- Tennessee 1
- Washington 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2404903 | 2404903 | 2022-04-13 | Nottoway | Virginia | 51135 | 4203 | 88 |
2370359 | 2370359 | 2022-04-03 | Casey | Kentucky | 21045 | 4203 | 72 |
2367106 | 2367106 | 2022-04-02 | Casey | Kentucky | 21045 | 4203 | 72 |
2363853 | 2363853 | 2022-04-01 | Casey | Kentucky | 21045 | 4203 | 72 |
2360599 | 2360599 | 2022-03-31 | Casey | Kentucky | 21045 | 4203 | 72 |
2357345 | 2357345 | 2022-03-30 | Casey | Kentucky | 21045 | 4203 | 72 |
2354092 | 2354092 | 2022-03-29 | Casey | Kentucky | 21045 | 4203 | 72 |
2350840 | 2350840 | 2022-03-28 | Casey | Kentucky | 21045 | 4203 | 72 |
2351224 | 2351224 | 2022-03-28 | Wadena | Minnesota | 27159 | 4203 | 54 |
2347971 | 2347971 | 2022-03-27 | Wadena | Minnesota | 27159 | 4203 | 54 |
2344718 | 2344718 | 2022-03-26 | Wadena | Minnesota | 27159 | 4203 | 54 |
2341465 | 2341465 | 2022-03-25 | Wadena | Minnesota | 27159 | 4203 | 54 |
2279313 | 2279313 | 2022-03-06 | Jackson | Kentucky | 21109 | 4203 | 71 |
2276060 | 2276060 | 2022-03-05 | Jackson | Kentucky | 21109 | 4203 | 71 |
2272807 | 2272807 | 2022-03-04 | Jackson | Kentucky | 21109 | 4203 | 71 |
2271632 | 2271632 | 2022-03-03 | Morgan | West Virginia | 54065 | 4203 | 67 |
2266673 | 2266673 | 2022-03-02 | Clarke | Mississippi | 28023 | 4203 | 104 |
2263908 | 2263908 | 2022-03-01 | Bertie | North Carolina | 37015 | 4203 | 65 |
2259456 | 2259456 | 2022-02-28 | Carroll | Indiana | 18015 | 4203 | 64 |
2244487 | 2244487 | 2022-02-23 | Warren | North Carolina | 37185 | 4203 | 39 |
2186718 | 2186718 | 2022-02-05 | Lamb | Texas | 48279 | 4203 | 107 |
2151293 | 2151293 | 2022-01-25 | McDowell | West Virginia | 54047 | 4203 | 57 |
2139925 | 2139925 | 2022-01-22 | Clinton | Missouri | 29049 | 4203 | 101 |
2111516 | 2111516 | 2022-01-13 | Naranjito | Puerto Rico | 72105 | 4203 | |
2034090 | 2034090 | 2021-12-20 | Gloucester | Virginia | 51073 | 4203 | 83 |
2027327 | 2027327 | 2021-12-18 | Gray | Texas | 48179 | 4203 | 89 |
1992604 | 1992604 | 2021-12-08 | Peach | Georgia | 13225 | 4203 | 115 |
1995086 | 1995086 | 2021-12-08 | Halifax | Virginia | 51083 | 4203 | 115 |
1983529 | 1983529 | 2021-12-05 | Union | Louisiana | 22111 | 4203 | 109 |
1985292 | 1985292 | 2021-12-05 | Botetourt | Virginia | 51023 | 4203 | 57 |
1980279 | 1980279 | 2021-12-04 | Union | Louisiana | 22111 | 4203 | 109 |
1982042 | 1982042 | 2021-12-04 | Botetourt | Virginia | 51023 | 4203 | 57 |
1977029 | 1977029 | 2021-12-03 | Union | Louisiana | 22111 | 4203 | 109 |
1978792 | 1978792 | 2021-12-03 | Botetourt | Virginia | 51023 | 4203 | 57 |
1967973 | 1967973 | 2021-11-30 | Lewis | New York | 36049 | 4203 | 40 |
1952776 | 1952776 | 2021-11-25 | Accomack | Virginia | 51001 | 4203 | 80 |
1892559 | 1892559 | 2021-11-07 | Dorchester | Maryland | 24019 | 4203 | 83 |
1878867 | 1878867 | 2021-11-03 | Sumter | Georgia | 13261 | 4203 | 134 |
1852289 | 1852289 | 2021-10-25 | Juneau | Wisconsin | 55057 | 4203 | 35 |
1827076 | 1827076 | 2021-10-18 | Clay | Indiana | 18021 | 4203 | 61 |
1810620 | 1810620 | 2021-10-13 | Pierce | Georgia | 13229 | 4203 | 100 |
1810849 | 1810849 | 2021-10-13 | Greene | Indiana | 18055 | 4203 | 100 |
1802420 | 1802420 | 2021-10-10 | Stutsman | North Dakota | 38093 | 4203 | 82 |
1788854 | 1788854 | 2021-10-06 | Sunflower | Mississippi | 28133 | 4203 | 104 |
1788904 | 1788904 | 2021-10-06 | Dunklin | Missouri | 29069 | 4203 | 58 |
1743028 | 1743028 | 2021-09-22 | Franklin | Louisiana | 22041 | 4203 | 134 |
1678344 | 1678344 | 2021-09-02 | George | Mississippi | 28039 | 4203 | 63 |
1673675 | 1673675 | 2021-09-01 | Clarke | Alabama | 1025 | 4203 | 68 |
1674810 | 1674810 | 2021-09-01 | Jefferson Davis | Louisiana | 22053 | 4203 | 109 |
1671440 | 1671440 | 2021-08-31 | Clay | Kentucky | 21051 | 4203 | 48 |
1672249 | 1672249 | 2021-08-31 | Rio Arriba | New Mexico | 35039 | 4203 | 82 |
1645172 | 1645172 | 2021-08-23 | Jasper | Indiana | 18073 | 4203 | 60 |
1633507 | 1633507 | 2021-08-19 | Clinton | Ohio | 39027 | 4203 | 69 |
1634492 | 1634492 | 2021-08-19 | York | Virginia | 51199 | 4203 | 60 |
1545275 | 1545275 | 2021-07-23 | Howell | Missouri | 29091 | 4203 | 50 |
1529277 | 1529277 | 2021-07-18 | Belknap | New Hampshire | 33001 | 4203 | 101 |
1526030 | 1526030 | 2021-07-17 | Belknap | New Hampshire | 33001 | 4203 | 101 |
1522783 | 1522783 | 2021-07-16 | Belknap | New Hampshire | 33001 | 4203 | 101 |
1519534 | 1519534 | 2021-07-15 | Belknap | New Hampshire | 33001 | 4203 | 101 |
1462181 | 1462181 | 2021-06-27 | Waller | Texas | 48473 | 4203 | 51 |
1383962 | 1383962 | 2021-06-03 | Campbell | Tennessee | 47013 | 4203 | 63 |
1355879 | 1355879 | 2021-05-26 | Chattahoochee | Georgia | 13053 | 4203 | 16 |
1334108 | 1334108 | 2021-05-19 | Morrison | Minnesota | 27097 | 4203 | 60 |
1321620 | 1321620 | 2021-05-15 | Montgomery | New York | 36057 | 4203 | 123 |
1292994 | 1292994 | 2021-05-06 | Brookings | South Dakota | 46011 | 4203 | 37 |
1288554 | 1288554 | 2021-05-05 | Hillsdale | Michigan | 26059 | 4203 | 87 |
1255571 | 1255571 | 2021-04-25 | Montgomery | Indiana | 18107 | 4203 | 90 |
1197162 | 1197162 | 2021-04-07 | Buena Vista | Iowa | 19021 | 4203 | 40 |
1177122 | 1177122 | 2021-04-01 | Broomfield | Colorado | 8014 | 4203 | 74 |
1158270 | 1158270 | 2021-03-26 | Wapello | Iowa | 19179 | 4203 | 116 |
1154352 | 1154352 | 2021-03-25 | Nevada | California | 6057 | 4203 | 85 |
1136146 | 1136146 | 2021-03-19 | Warren | Mississippi | 28149 | 4203 | 117 |
1072868 | 1072868 | 2021-02-27 | Putnam | West Virginia | 54079 | 4203 | 74 |
1046215 | 1046215 | 2021-02-19 | Newberry | South Carolina | 45071 | 4203 | 92 |
1039125 | 1039125 | 2021-02-17 | Cattaraugus | New York | 36009 | 4203 | 75 |
1032254 | 1032254 | 2021-02-15 | Panola | Mississippi | 28107 | 4203 | 89 |
1029371 | 1029371 | 2021-02-14 | Otero | New Mexico | 35035 | 4203 | 50 |
983965 | 983965 | 2021-01-31 | Herkimer | New York | 36043 | 4203 | 90 |
980797 | 980797 | 2021-01-30 | Halifax | North Carolina | 37083 | 4203 | 80 |
977551 | 977551 | 2021-01-29 | Halifax | North Carolina | 37083 | 4203 | 80 |
957903 | 957903 | 2021-01-23 | Elko | Nevada | 32007 | 4203 | 41 |
954658 | 954658 | 2021-01-22 | Elko | Nevada | 32007 | 4203 | 41 |
916010 | 916010 | 2021-01-10 | Ashtabula | Ohio | 39007 | 4203 | 66 |
907286 | 907286 | 2021-01-07 | Kitsap | Washington | 53035 | 4203 | 47 |
903259 | 903259 | 2021-01-06 | Indiana | Pennsylvania | 42063 | 4203 | 130 |
874611 | 874611 | 2020-12-28 | Val Verde | Texas | 48465 | 4203 | 149 |
871366 | 871366 | 2020-12-27 | Val Verde | Texas | 48465 | 4203 | 149 |
868121 | 868121 | 2020-12-26 | Val Verde | Texas | 48465 | 4203 | 149 |
864876 | 864876 | 2020-12-25 | Val Verde | Texas | 48465 | 4203 | 149 |
861631 | 861631 | 2020-12-24 | Val Verde | Texas | 48465 | 4203 | 149 |
808279 | 808279 | 2020-12-08 | Forrest | Mississippi | 28035 | 4203 | 90 |
809153 | 809153 | 2020-12-08 | Monroe | Pennsylvania | 42089 | 4203 | 160 |
779911 | 779911 | 2020-11-29 | Blair | Pennsylvania | 42013 | 4203 | 63 |
734308 | 734308 | 2020-11-15 | Licking | Ohio | 39089 | 4203 | 70 |
717916 | 717916 | 2020-11-10 | Davidson | North Carolina | 37057 | 4203 | 48 |
703409 | 703409 | 2020-11-06 | Bartow | Georgia | 13015 | 4203 | 100 |
682289 | 682289 | 2020-10-30 | Rowan | North Carolina | 37159 | 4203 | 120 |
487728 | 487728 | 2020-08-31 | McKinley | New Mexico | 35031 | 4203 | 242 |
375771 | 375771 | 2020-07-27 | Hays | Texas | 48209 | 4203 | 28 |
116511 | 116511 | 2020-05-05 | Hampden | Massachusetts | 25013 | 4203 | 415 |
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);