ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
107 rows where cases = 3373 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 9
- Puerto Rico 8
- Georgia 6
- Minnesota 6
- Nebraska 6
- Illinois 5
- Indiana 5
- Kentucky 5
- Louisiana 5
- Missouri 5
- Mississippi 4
- Oregon 4
- Pennsylvania 4
- Tennessee 4
- Arkansas 3
- Massachusetts 3
- Michigan 3
- Virginia 3
- Alabama 2
- Kansas 2
- North Carolina 2
- Ohio 2
- Wyoming 2
- Arizona 1
- California 1
- Colorado 1
- Iowa 1
- New York 1
- North Dakota 1
- South Carolina 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2472498 | 2472498 | 2022-05-04 | Curry | Oregon | 41015 | 3373 | 54 |
2419912 | 2419912 | 2022-04-18 | Seward | Nebraska | 31159 | 3373 | 41 |
2416657 | 2416657 | 2022-04-17 | Seward | Nebraska | 31159 | 3373 | 41 |
2413401 | 2413401 | 2022-04-16 | Seward | Nebraska | 31159 | 3373 | 41 |
2410145 | 2410145 | 2022-04-15 | Seward | Nebraska | 31159 | 3373 | 41 |
2406889 | 2406889 | 2022-04-14 | Seward | Nebraska | 31159 | 3373 | 41 |
2403633 | 2403633 | 2022-04-13 | Seward | Nebraska | 31159 | 3373 | 41 |
2347801 | 2347801 | 2022-03-27 | Nantucket | Massachusetts | 25019 | 3373 | 0 |
2344548 | 2344548 | 2022-03-26 | Nantucket | Massachusetts | 25019 | 3373 | 0 |
2341295 | 2341295 | 2022-03-25 | Nantucket | Massachusetts | 25019 | 3373 | 0 |
2320692 | 2320692 | 2022-03-19 | Marion | Arkansas | 5089 | 3373 | 87 |
2297373 | 2297373 | 2022-03-11 | Tyler | Texas | 48457 | 3373 | 83 |
2287158 | 2287158 | 2022-03-08 | Salinas | Puerto Rico | 72123 | 3373 | |
2283906 | 2283906 | 2022-03-07 | Salinas | Puerto Rico | 72123 | 3373 | |
2280654 | 2280654 | 2022-03-06 | Salinas | Puerto Rico | 72123 | 3373 | |
2214342 | 2214342 | 2022-02-14 | Trigg | Kentucky | 21221 | 3373 | 40 |
2183335 | 2183335 | 2022-02-04 | Bandera | Texas | 48019 | 3373 | 70 |
2183569 | 2183569 | 2022-02-04 | Wilbarger | Texas | 48487 | 3373 | 79 |
2172029 | 2172029 | 2022-02-01 | Monroe | Kentucky | 21171 | 3373 | 69 |
2168873 | 2168873 | 2022-01-31 | West Carroll | Louisiana | 22123 | 3373 | 53 |
2152975 | 2152975 | 2022-01-26 | Livingston | Missouri | 29117 | 3373 | 85 |
2131662 | 2131662 | 2022-01-19 | Nottoway | Virginia | 51135 | 3373 | 72 |
2097649 | 2097649 | 2022-01-09 | Cooper | Missouri | 29053 | 3373 | 63 |
2089600 | 2089600 | 2022-01-06 | Carbon | Wyoming | 56007 | 3373 | 47 |
2082128 | 2082128 | 2022-01-04 | Wasco | Oregon | 41065 | 3373 | 48 |
2077342 | 2077342 | 2022-01-03 | Franklin | Indiana | 18047 | 3373 | 54 |
2039008 | 2039008 | 2021-12-22 | Roseau | Minnesota | 27135 | 3373 | 34 |
2013130 | 2013130 | 2021-12-14 | Clinton | Missouri | 29049 | 3373 | 95 |
2009055 | 2009055 | 2021-12-13 | Wayne | Illinois | 17191 | 3373 | 67 |
1972658 | 1972658 | 2021-12-02 | Randolph | Alabama | 1111 | 3373 | 67 |
1971398 | 1971398 | 2021-12-01 | Rolette | North Dakota | 38079 | 3373 | 36 |
1941513 | 1941513 | 2021-11-22 | Attala | Mississippi | 28007 | 3373 | 90 |
1916640 | 1916640 | 2021-11-14 | Crockett | Tennessee | 47033 | 3373 | 62 |
1913390 | 1913390 | 2021-11-13 | Crockett | Tennessee | 47033 | 3373 | 62 |
1910140 | 1910140 | 2021-11-12 | Crockett | Tennessee | 47033 | 3373 | 62 |
1904968 | 1904968 | 2021-11-11 | Douglas | Illinois | 17041 | 3373 | 44 |
1901718 | 1901718 | 2021-11-10 | Douglas | Illinois | 17041 | 3373 | 44 |
1831967 | 1831967 | 2021-10-19 | Dorado | Puerto Rico | 72051 | 3373 | |
1828718 | 1828718 | 2021-10-18 | Dorado | Puerto Rico | 72051 | 3373 | |
1825469 | 1825469 | 2021-10-17 | Dorado | Puerto Rico | 72051 | 3373 | |
1807030 | 1807030 | 2021-10-12 | Ouachita | Arkansas | 5103 | 3373 | 81 |
1807343 | 1807343 | 2021-10-12 | Lamar | Georgia | 13171 | 3373 | 84 |
1800530 | 1800530 | 2021-10-10 | Ouachita | Arkansas | 5103 | 3373 | 81 |
1756050 | 1756050 | 2021-09-26 | St. James | Louisiana | 22093 | 3373 | 67 |
1752802 | 1752802 | 2021-09-25 | St. James | Louisiana | 22093 | 3373 | 67 |
1749553 | 1749553 | 2021-09-24 | St. James | Louisiana | 22093 | 3373 | 67 |
1746203 | 1746203 | 2021-09-23 | Letcher | Kentucky | 21133 | 3373 | 54 |
1727163 | 1727163 | 2021-09-17 | Crawford | Missouri | 29055 | 3373 | 49 |
1717166 | 1717166 | 2021-09-14 | Houghton | Michigan | 26061 | 3373 | 46 |
1713918 | 1713918 | 2021-09-13 | Houghton | Michigan | 26061 | 3373 | 46 |
1693661 | 1693661 | 2021-09-07 | Pike | Georgia | 13231 | 3373 | 52 |
1667829 | 1667829 | 2021-08-30 | McDonough | Illinois | 17109 | 3373 | 65 |
1667881 | 1667881 | 2021-08-30 | Clay | Indiana | 18021 | 3373 | 51 |
1607411 | 1607411 | 2021-08-11 | Macon | North Carolina | 37113 | 3373 | 41 |
1591298 | 1591298 | 2021-08-06 | Guernsey | Ohio | 39059 | 3373 | 54 |
1585951 | 1585951 | 2021-08-04 | Sheridan | Wyoming | 56033 | 3373 | 31 |
1551611 | 1551611 | 2021-07-25 | Pine | Minnesota | 27115 | 3373 | 23 |
1548364 | 1548364 | 2021-07-24 | Pine | Minnesota | 27115 | 3373 | 23 |
1545117 | 1545117 | 2021-07-23 | Pine | Minnesota | 27115 | 3373 | 23 |
1468546 | 1468546 | 2021-06-29 | Hopkins | Texas | 48223 | 3373 | 114 |
1444567 | 1444567 | 2021-06-22 | Pike | Mississippi | 28113 | 3373 | 111 |
1442703 | 1442703 | 2021-06-21 | Upshur | Texas | 48459 | 3373 | 77 |
1439458 | 1439458 | 2021-06-20 | Upshur | Texas | 48459 | 3373 | 77 |
1337461 | 1337461 | 2021-05-20 | Sunflower | Mississippi | 28133 | 3373 | 91 |
1271821 | 1271821 | 2021-04-30 | Ripley | Indiana | 18137 | 3373 | 70 |
1252578 | 1252578 | 2021-04-24 | Boyle | Kentucky | 21021 | 3373 | 69 |
1235834 | 1235834 | 2021-04-19 | Pickens | Georgia | 13227 | 3373 | 74 |
1231862 | 1231862 | 2021-04-17 | Prince George | Virginia | 51149 | 3373 | 26 |
1211664 | 1211664 | 2021-04-11 | Perry | Pennsylvania | 42099 | 3373 | 94 |
1201994 | 1201994 | 2021-04-08 | Ponce | Puerto Rico | 72113 | 3373 | |
1178227 | 1178227 | 2021-04-01 | Isanti | Minnesota | 27059 | 3373 | 59 |
1175950 | 1175950 | 2021-03-31 | Wayne | Pennsylvania | 42127 | 3373 | 71 |
1144931 | 1144931 | 2021-03-22 | Unknown | Georgia | 3373 | 11 | |
1132368 | 1132368 | 2021-03-18 | Montgomery | Kansas | 20125 | 3373 | 6 |
1129120 | 1129120 | 2021-03-17 | Montgomery | Kansas | 20125 | 3373 | 6 |
1125458 | 1125458 | 2021-03-16 | Wayne | Georgia | 13305 | 3373 | 79 |
1119029 | 1119029 | 2021-03-14 | Bureau | Illinois | 17011 | 3373 | 91 |
1120673 | 1120673 | 2021-03-14 | Malheur | Oregon | 41045 | 3373 | 58 |
1117426 | 1117426 | 2021-03-13 | Malheur | Oregon | 41045 | 3373 | 58 |
1077554 | 1077554 | 2021-03-01 | Beltrami | Minnesota | 27007 | 3373 | 51 |
1021843 | 1021843 | 2021-02-12 | Whitley | Indiana | 18183 | 3373 | 35 |
1023901 | 1023901 | 2021-02-12 | Uvalde | Texas | 48463 | 3373 | 57 |
1005990 | 1005990 | 2021-02-07 | St. John the Baptist | Louisiana | 22095 | 3373 | 130 |
995145 | 995145 | 2021-02-04 | Tallapoosa | Alabama | 1123 | 3373 | 123 |
972613 | 972613 | 2021-01-28 | Broomfield | Colorado | 8014 | 3373 | 69 |
941757 | 941757 | 2021-01-18 | Cattaraugus | New York | 36009 | 3373 | 61 |
929837 | 929837 | 2021-01-14 | Chittenden | Vermont | 50007 | 3373 | 78 |
912213 | 912213 | 2021-01-09 | Camden | Missouri | 29029 | 3373 | 65 |
912845 | 912845 | 2021-01-09 | Washington | Ohio | 39167 | 3373 | 39 |
913751 | 913751 | 2021-01-09 | Washington | Virginia | 51191 | 3373 | 58 |
909749 | 909749 | 2021-01-08 | Huntingdon | Pennsylvania | 42061 | 3373 | 90 |
905481 | 905481 | 2021-01-07 | Grand Traverse | Michigan | 26055 | 3373 | 50 |
879667 | 879667 | 2020-12-30 | Bolivar | Mississippi | 28011 | 3373 | 95 |
843644 | 843644 | 2020-12-19 | Oldham | Kentucky | 21185 | 3373 | 48 |
844912 | 844912 | 2020-12-19 | Guaynabo | Puerto Rico | 72061 | 3373 | |
833701 | 833701 | 2020-12-16 | Warren | Iowa | 19181 | 3373 | 25 |
828615 | 828615 | 2020-12-14 | Indiana | Pennsylvania | 42063 | 3373 | 79 |
787259 | 787259 | 2020-12-01 | Monongalia | West Virginia | 54061 | 3373 | 7 |
661581 | 661581 | 2020-10-24 | Hendricks | Indiana | 18063 | 3373 | 150 |
637340 | 637340 | 2020-10-16 | Sumter | South Carolina | 45085 | 3373 | 84 |
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);