ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
130 rows where cases = 4002 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Virginia 14
- Kentucky 13
- Illinois 9
- Minnesota 8
- Alabama 7
- North Carolina 7
- Oklahoma 7
- Mississippi 6
- Missouri 6
- Tennessee 5
- Texas 5
- Indiana 4
- New Mexico 4
- New York 4
- Georgia 3
- Idaho 3
- Iowa 3
- Ohio 3
- Arkansas 2
- California 2
- Louisiana 2
- Pennsylvania 2
- Puerto Rico 2
- South Carolina 2
- Colorado 1
- Maryland 1
- North Dakota 1
- Oregon 1
- Washington 1
- Wisconsin 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502459 | 2502459 | 2022-05-13 | Young | Texas | 48503 | 4002 | 94 |
2461602 | 2461602 | 2022-05-01 | Trigg | Kentucky | 21221 | 4002 | 44 |
2458346 | 2458346 | 2022-04-30 | Trigg | Kentucky | 21221 | 4002 | 44 |
2455090 | 2455090 | 2022-04-29 | Trigg | Kentucky | 21221 | 4002 | 44 |
2451834 | 2451834 | 2022-04-28 | Trigg | Kentucky | 21221 | 4002 | 44 |
2448578 | 2448578 | 2022-04-27 | Trigg | Kentucky | 21221 | 4002 | 44 |
2445322 | 2445322 | 2022-04-26 | Trigg | Kentucky | 21221 | 4002 | 44 |
2442066 | 2442066 | 2022-04-25 | Trigg | Kentucky | 21221 | 4002 | 44 |
2408120 | 2408120 | 2022-04-14 | Goochland | Virginia | 51075 | 4002 | 51 |
2370002 | 2370002 | 2022-04-03 | Mercer | Illinois | 17131 | 4002 | 47 |
2366749 | 2366749 | 2022-04-02 | Mercer | Illinois | 17131 | 4002 | 47 |
2363496 | 2363496 | 2022-04-01 | Mercer | Illinois | 17131 | 4002 | 47 |
2326774 | 2326774 | 2022-03-20 | Greene | Virginia | 51079 | 4002 | 61 |
2323521 | 2323521 | 2022-03-19 | Greene | Virginia | 51079 | 4002 | 61 |
2320267 | 2320267 | 2022-03-18 | Greene | Virginia | 51079 | 4002 | 61 |
2246774 | 2246774 | 2022-02-24 | Estill | Kentucky | 21065 | 4002 | 41 |
2243523 | 2243523 | 2022-02-23 | Estill | Kentucky | 21065 | 4002 | 41 |
2218692 | 2218692 | 2022-02-15 | Pawnee | Oklahoma | 40117 | 4002 | 74 |
2215441 | 2215441 | 2022-02-14 | Pawnee | Oklahoma | 40117 | 4002 | 74 |
2212190 | 2212190 | 2022-02-13 | Pawnee | Oklahoma | 40117 | 4002 | 74 |
2208937 | 2208937 | 2022-02-12 | Pawnee | Oklahoma | 40117 | 4002 | 74 |
2203593 | 2203593 | 2022-02-11 | Clay | Arkansas | 5021 | 4002 | 81 |
2205684 | 2205684 | 2022-02-11 | Pawnee | Oklahoma | 40117 | 4002 | 74 |
2202431 | 2202431 | 2022-02-10 | Pawnee | Oklahoma | 40117 | 4002 | 74 |
2199177 | 2199177 | 2022-02-09 | Pawnee | Oklahoma | 40117 | 4002 | 74 |
2195066 | 2195066 | 2022-02-08 | Houston | Minnesota | 27055 | 4002 | 18 |
2155305 | 2155305 | 2022-01-27 | Hancock | Illinois | 17067 | 4002 | 53 |
2145454 | 2145454 | 2022-01-24 | Washington | Georgia | 13303 | 4002 | 128 |
2130575 | 2130575 | 2022-01-19 | Currituck | North Carolina | 37053 | 4002 | 31 |
2107707 | 2107707 | 2022-01-12 | Lincoln | New Mexico | 35027 | 4002 | 50 |
2099132 | 2099132 | 2022-01-09 | Mecklenburg | Virginia | 51117 | 4002 | 98 |
2095881 | 2095881 | 2022-01-08 | Mecklenburg | Virginia | 51117 | 4002 | 98 |
2092629 | 2092629 | 2022-01-07 | Mecklenburg | Virginia | 51117 | 4002 | 98 |
2081829 | 2081829 | 2022-01-04 | Martin | North Carolina | 37117 | 4002 | 76 |
1986175 | 1986175 | 2021-12-06 | Cassia | Idaho | 16031 | 4002 | 43 |
1965594 | 1965594 | 2021-11-29 | Hutchinson | Texas | 48233 | 4002 | 94 |
1889700 | 1889700 | 2021-11-06 | Stone | Missouri | 29209 | 4002 | 86 |
1860031 | 1860031 | 2021-10-28 | Union | Louisiana | 22111 | 4002 | 105 |
1853921 | 1853921 | 2021-10-26 | Miller | Missouri | 29131 | 4002 | 77 |
1789254 | 1789254 | 2021-10-06 | Orleans | New York | 36073 | 4002 | 86 |
1725472 | 1725472 | 2021-09-16 | Okanogan | Washington | 53047 | 4002 | 50 |
1719180 | 1719180 | 2021-09-15 | Lawrence | Alabama | 1079 | 4002 | 101 |
1701509 | 1701509 | 2021-09-09 | Chenango | New York | 36017 | 4002 | 85 |
1699000 | 1699000 | 2021-09-08 | Overton | Tennessee | 47133 | 4002 | 65 |
1675809 | 1675809 | 2021-09-01 | Williams | Ohio | 39171 | 4002 | 80 |
1583299 | 1583299 | 2021-08-04 | Nez Perce | Idaho | 16069 | 4002 | 60 |
1532143 | 1532143 | 2021-07-19 | Steele | Minnesota | 27147 | 4002 | 19 |
1528896 | 1528896 | 2021-07-18 | Steele | Minnesota | 27147 | 4002 | 19 |
1525649 | 1525649 | 2021-07-17 | Steele | Minnesota | 27147 | 4002 | 19 |
1522402 | 1522402 | 2021-07-16 | Steele | Minnesota | 27147 | 4002 | 19 |
1472958 | 1472958 | 2021-07-01 | Logan | Illinois | 17107 | 4002 | 77 |
1413910 | 1413910 | 2021-06-13 | Escambia | Alabama | 1053 | 4002 | 80 |
1410665 | 1410665 | 2021-06-12 | Escambia | Alabama | 1053 | 4002 | 80 |
1407420 | 1407420 | 2021-06-11 | Escambia | Alabama | 1053 | 4002 | 80 |
1355746 | 1355746 | 2021-05-26 | Logan | Colorado | 8075 | 4002 | 68 |
1351794 | 1351794 | 2021-05-24 | Rusk | Texas | 48401 | 4002 | 108 |
1336776 | 1336776 | 2021-05-20 | Whitley | Indiana | 18183 | 4002 | 39 |
1325381 | 1325381 | 2021-05-16 | Ponce | Puerto Rico | 72113 | 4002 | |
1310205 | 1310205 | 2021-05-12 | Humboldt | California | 6023 | 4002 | 41 |
1296723 | 1296723 | 2021-05-07 | Charlottesville city | Virginia | 51540 | 4002 | 56 |
1288153 | 1288153 | 2021-05-05 | Plymouth | Iowa | 19149 | 4002 | 79 |
1277605 | 1277605 | 2021-05-02 | Tallapoosa | Alabama | 1123 | 4002 | 150 |
1275333 | 1275333 | 2021-05-01 | Franklin | Kentucky | 21073 | 4002 | 46 |
1269736 | 1269736 | 2021-04-29 | Davie | North Carolina | 37059 | 4002 | 37 |
1261488 | 1261488 | 2021-04-27 | Union | Arkansas | 5139 | 4002 | 113 |
1230216 | 1230216 | 2021-04-17 | Nobles | Minnesota | 27105 | 4002 | 48 |
1220249 | 1220249 | 2021-04-14 | Natchitoches | Louisiana | 22069 | 4002 | 85 |
1218466 | 1218466 | 2021-04-13 | Weakley | Tennessee | 47183 | 4002 | 61 |
1215637 | 1215637 | 2021-04-12 | Shenandoah | Virginia | 51171 | 4002 | 129 |
1172776 | 1172776 | 2021-03-30 | Toa Baja | Puerto Rico | 72137 | 4002 | |
1168616 | 1168616 | 2021-03-29 | Union | Mississippi | 28145 | 4002 | 74 |
1170372 | 1170372 | 2021-03-29 | Sweetwater | Wyoming | 56037 | 4002 | 36 |
1165368 | 1165368 | 2021-03-28 | Union | Mississippi | 28145 | 4002 | 74 |
1162120 | 1162120 | 2021-03-27 | Union | Mississippi | 28145 | 4002 | 74 |
1158872 | 1158872 | 2021-03-26 | Union | Mississippi | 28145 | 4002 | 74 |
1150227 | 1150227 | 2021-03-23 | Marshall | Tennessee | 47117 | 4002 | 57 |
1146251 | 1146251 | 2021-03-22 | Clinton | New York | 36019 | 4002 | 30 |
1135414 | 1135414 | 2021-03-19 | Montgomery | Indiana | 18107 | 4002 | 85 |
1126263 | 1126263 | 2021-03-16 | Douglas | Minnesota | 27041 | 4002 | 70 |
1113835 | 1113835 | 2021-03-12 | Alexander | North Carolina | 37003 | 4002 | 82 |
1099587 | 1099587 | 2021-03-08 | Jefferson | Illinois | 17081 | 4002 | 118 |
1075979 | 1075979 | 2021-02-28 | Manassas city | Virginia | 51683 | 4002 | 39 |
1061003 | 1061003 | 2021-02-24 | Barren | Kentucky | 21009 | 4002 | 71 |
1061374 | 1061374 | 2021-02-24 | Mower | Minnesota | 27099 | 4002 | 31 |
1054234 | 1054234 | 2021-02-22 | Gibson | Indiana | 18051 | 4002 | 84 |
1036457 | 1036457 | 2021-02-16 | Chesterfield | South Carolina | 45025 | 4002 | 91 |
1012802 | 1012802 | 2021-02-09 | Warren | Mississippi | 28149 | 4002 | 110 |
1002682 | 1002682 | 2021-02-06 | Shelby | Kentucky | 21211 | 4002 | 35 |
990424 | 990424 | 2021-02-02 | Otero | New Mexico | 35035 | 4002 | 50 |
987943 | 987943 | 2021-02-01 | Rhea | Tennessee | 47143 | 4002 | 64 |
975410 | 975410 | 2021-01-28 | Washington | Virginia | 51191 | 4002 | 77 |
956792 | 956792 | 2021-01-23 | Macoupin | Illinois | 17117 | 4002 | 96 |
938968 | 938968 | 2021-01-17 | Mifflin | Pennsylvania | 42087 | 4002 | 136 |
926617 | 926617 | 2021-01-13 | Bedford | Virginia | 51019 | 4002 | 32 |
921076 | 921076 | 2021-01-12 | Jackson | Illinois | 17077 | 4002 | 67 |
917114 | 917114 | 2021-01-10 | Dunn | Wisconsin | 55033 | 4002 | 25 |
903701 | 903701 | 2021-01-06 | Howard | Texas | 48227 | 4002 | 68 |
899778 | 899778 | 2021-01-05 | Williams | North Dakota | 38105 | 4002 | 33 |
868264 | 868264 | 2020-12-26 | Lynchburg city | Virginia | 51680 | 4002 | 48 |
856349 | 856349 | 2020-12-23 | Clinton | Iowa | 19045 | 4002 | 52 |
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);