ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
122 rows where cases = 3903 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 12
- Georgia 10
- Kansas 10
- Kentucky 10
- Illinois 8
- Alabama 7
- Oklahoma 7
- Virginia 5
- Colorado 4
- Alaska 3
- Indiana 3
- Missouri 3
- New Mexico 3
- Ohio 3
- West Virginia 3
- Wisconsin 3
- Florida 2
- Louisiana 2
- Michigan 2
- Minnesota 2
- Mississippi 2
- Nebraska 2
- Tennessee 2
- California 1
- Delaware 1
- Guam 1
- Idaho 1
- Maryland 1
- Montana 1
- New Hampshire 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497257 | 2497257 | 2022-05-12 | Jackson | Kansas | 20085 | 3903 | 29 |
2493999 | 2493999 | 2022-05-11 | Jackson | Kansas | 20085 | 3903 | 29 |
2490741 | 2490741 | 2022-05-10 | Jackson | Kansas | 20085 | 3903 | 29 |
2487484 | 2487484 | 2022-05-09 | Jackson | Kansas | 20085 | 3903 | 29 |
2484226 | 2484226 | 2022-05-08 | Jackson | Kansas | 20085 | 3903 | 29 |
2480968 | 2480968 | 2022-05-07 | Jackson | Kansas | 20085 | 3903 | 29 |
2477710 | 2477710 | 2022-05-06 | Jackson | Kansas | 20085 | 3903 | 29 |
2420941 | 2420941 | 2022-04-18 | Llano | Texas | 48299 | 3903 | 97 |
2415565 | 2415565 | 2022-04-17 | Mason | Illinois | 17125 | 3903 | 61 |
2412309 | 2412309 | 2022-04-16 | Mason | Illinois | 17125 | 3903 | 61 |
2409053 | 2409053 | 2022-04-15 | Mason | Illinois | 17125 | 3903 | 61 |
2378947 | 2378947 | 2022-04-05 | Braxton | West Virginia | 54007 | 3903 | 42 |
2375693 | 2375693 | 2022-04-04 | Braxton | West Virginia | 54007 | 3903 | 42 |
2370453 | 2370453 | 2022-04-03 | Webster | Kentucky | 21233 | 3903 | 48 |
2367200 | 2367200 | 2022-04-02 | Webster | Kentucky | 21233 | 3903 | 48 |
2363947 | 2363947 | 2022-04-01 | Webster | Kentucky | 21233 | 3903 | 48 |
2360693 | 2360693 | 2022-03-31 | Webster | Kentucky | 21233 | 3903 | 48 |
2362456 | 2362456 | 2022-03-31 | Young | Texas | 48503 | 3903 | 90 |
2357439 | 2357439 | 2022-03-30 | Webster | Kentucky | 21233 | 3903 | 48 |
2354186 | 2354186 | 2022-03-29 | Webster | Kentucky | 21233 | 3903 | 48 |
2356049 | 2356049 | 2022-03-29 | Goochland | Virginia | 51075 | 3903 | 49 |
2350934 | 2350934 | 2022-03-28 | Webster | Kentucky | 21233 | 3903 | 48 |
2328808 | 2328808 | 2022-03-21 | York | Nebraska | 31185 | 3903 | 20 |
2311233 | 2311233 | 2022-03-16 | Greene | Georgia | 13133 | 3903 | 82 |
2307980 | 2307980 | 2022-03-15 | Greene | Georgia | 13133 | 3903 | 82 |
2304729 | 2304729 | 2022-03-14 | Greene | Georgia | 13133 | 3903 | 82 |
2241977 | 2241977 | 2022-02-22 | Houston | Texas | 48225 | 3903 | 105 |
2222953 | 2222953 | 2022-02-16 | Washburn | Wisconsin | 55129 | 3903 | 43 |
2218670 | 2218670 | 2022-02-15 | Kingfisher | Oklahoma | 40073 | 3903 | 59 |
2215419 | 2215419 | 2022-02-14 | Kingfisher | Oklahoma | 40073 | 3903 | 59 |
2212168 | 2212168 | 2022-02-13 | Kingfisher | Oklahoma | 40073 | 3903 | 59 |
2208915 | 2208915 | 2022-02-12 | Kingfisher | Oklahoma | 40073 | 3903 | 59 |
2205662 | 2205662 | 2022-02-11 | Kingfisher | Oklahoma | 40073 | 3903 | 59 |
2202409 | 2202409 | 2022-02-10 | Kingfisher | Oklahoma | 40073 | 3903 | 59 |
2199155 | 2199155 | 2022-02-09 | Kingfisher | Oklahoma | 40073 | 3903 | 59 |
2193338 | 2193338 | 2022-02-07 | Zavala | Texas | 48507 | 3903 | 59 |
2171729 | 2171729 | 2022-02-01 | Vermillion | Indiana | 18165 | 3903 | 67 |
2163593 | 2163593 | 2022-01-29 | Yauco | Puerto Rico | 72153 | 3903 | |
2156286 | 2156286 | 2022-01-27 | Big Horn | Montana | 30003 | 3903 | 87 |
2131615 | 2131615 | 2022-01-19 | Fluvanna | Virginia | 51065 | 3903 | 33 |
2118916 | 2118916 | 2022-01-16 | Hale | Alabama | 1065 | 3903 | 93 |
2119314 | 2119314 | 2022-01-16 | Crisp | Georgia | 13081 | 3903 | 123 |
2116062 | 2116062 | 2022-01-15 | Crisp | Georgia | 13081 | 3903 | 123 |
2112811 | 2112811 | 2022-01-14 | Crisp | Georgia | 13081 | 3903 | 123 |
2103390 | 2103390 | 2022-01-11 | Orange | Indiana | 18117 | 3903 | 86 |
2092393 | 2092393 | 2022-01-07 | Limestone | Texas | 48293 | 3903 | 111 |
2054639 | 2054639 | 2021-12-27 | Spencer | Indiana | 18147 | 3903 | 54 |
2038730 | 2038730 | 2021-12-22 | Wayne | Kentucky | 21231 | 3903 | 73 |
2035480 | 2035480 | 2021-12-21 | Wayne | Kentucky | 21231 | 3903 | 73 |
2035710 | 2035710 | 2021-12-21 | Dodge | Minnesota | 27039 | 3903 | 13 |
2021164 | 2021164 | 2021-12-16 | Waynesboro city | Virginia | 51820 | 3903 | 53 |
1989356 | 1989356 | 2021-12-07 | Pike | Georgia | 13231 | 3903 | 71 |
1970496 | 1970496 | 2021-12-01 | Grant | Louisiana | 22043 | 3903 | 79 |
1930111 | 1930111 | 2021-11-18 | Orange | Virginia | 51137 | 3903 | 61 |
1925628 | 1925628 | 2021-11-17 | Coos | New Hampshire | 33007 | 3903 | 68 |
1861087 | 1861087 | 2021-10-28 | Columbia | Oregon | 41009 | 3903 | 44 |
1826956 | 1826956 | 2021-10-18 | Payette | Idaho | 16075 | 3903 | 57 |
1785689 | 1785689 | 2021-10-05 | Miller | Missouri | 29131 | 3903 | 75 |
1722881 | 1722881 | 2021-09-16 | Monroe | Georgia | 13207 | 3903 | 120 |
1686531 | 1686531 | 2021-09-04 | Logan | West Virginia | 54045 | 3903 | 106 |
1578882 | 1578882 | 2021-08-02 | Cooke | Texas | 48097 | 3903 | 72 |
1574796 | 1574796 | 2021-08-01 | Rio Arriba | New Mexico | 35039 | 3903 | 81 |
1575634 | 1575634 | 2021-08-01 | Cooke | Texas | 48097 | 3903 | 72 |
1571548 | 1571548 | 2021-07-31 | Rio Arriba | New Mexico | 35039 | 3903 | 81 |
1572386 | 1572386 | 2021-07-31 | Cooke | Texas | 48097 | 3903 | 72 |
1568300 | 1568300 | 2021-07-30 | Rio Arriba | New Mexico | 35039 | 3903 | 81 |
1557026 | 1557026 | 2021-07-27 | Summit | Colorado | 8117 | 3903 | 8 |
1553779 | 1553779 | 2021-07-26 | Summit | Colorado | 8117 | 3903 | 8 |
1540891 | 1540891 | 2021-07-22 | Bryan | Georgia | 13029 | 3903 | 41 |
1519883 | 1519883 | 2021-07-15 | Preble | Ohio | 39135 | 3903 | 106 |
1509566 | 1509566 | 2021-07-12 | Lawrence | Missouri | 29109 | 3903 | 89 |
1506320 | 1506320 | 2021-07-11 | Lawrence | Missouri | 29109 | 3903 | 89 |
1418273 | 1418273 | 2021-06-14 | Iberville | Louisiana | 22047 | 3903 | 100 |
1391236 | 1391236 | 2021-06-06 | Bethel Census Area | Alaska | 2050 | 3903 | 22 |
1387991 | 1387991 | 2021-06-05 | Bethel Census Area | Alaska | 2050 | 3903 | 22 |
1384746 | 1384746 | 2021-06-04 | Bethel Census Area | Alaska | 2050 | 3903 | 22 |
1333388 | 1333388 | 2021-05-19 | Logan | Illinois | 17107 | 3903 | 72 |
1307390 | 1307390 | 2021-05-11 | Fulton | Illinois | 17057 | 3903 | 63 |
1287481 | 1287481 | 2021-05-05 | Humboldt | California | 6023 | 3903 | 39 |
1273117 | 1273117 | 2021-04-30 | Brown | Ohio | 39015 | 3903 | 57 |
1241853 | 1241853 | 2021-04-21 | Escambia | Alabama | 1053 | 3903 | 75 |
1238606 | 1238606 | 2021-04-20 | Escambia | Alabama | 1053 | 3903 | 75 |
1235359 | 1235359 | 2021-04-19 | Escambia | Alabama | 1053 | 3903 | 74 |
1232111 | 1232111 | 2021-04-18 | Escambia | Alabama | 1053 | 3903 | 74 |
1228863 | 1228863 | 2021-04-17 | Escambia | Alabama | 1053 | 3903 | 74 |
1210263 | 1210263 | 2021-04-11 | Cowley | Kansas | 20035 | 3903 | 9 |
1207014 | 1207014 | 2021-04-10 | Cowley | Kansas | 20035 | 3903 | 9 |
1203766 | 1203766 | 2021-04-09 | Cowley | Kansas | 20035 | 3903 | 9 |
1203891 | 1203891 | 2021-04-09 | Franklin | Kentucky | 21073 | 3903 | 46 |
1199217 | 1199217 | 2021-04-07 | Waller | Texas | 48473 | 3903 | 46 |
1155517 | 1155517 | 2021-03-25 | Nobles | Minnesota | 27105 | 3903 | 47 |
1102444 | 1102444 | 2021-03-09 | Broomfield | Colorado | 8014 | 3903 | 74 |
1100893 | 1100893 | 2021-03-08 | Haywood | North Carolina | 37087 | 3903 | 88 |
1072315 | 1072315 | 2021-02-27 | Marshall | Tennessee | 47117 | 3903 | 56 |
1041777 | 1041777 | 2021-02-18 | Cass | Michigan | 26027 | 3903 | 63 |
1043463 | 1043463 | 2021-02-18 | Campbell | Virginia | 51031 | 3903 | 33 |
1009530 | 1009530 | 2021-02-08 | Monroe | Mississippi | 28095 | 3903 | 119 |
1005500 | 1005500 | 2021-02-07 | Randolph | Illinois | 17157 | 3903 | 80 |
1001605 | 1001605 | 2021-02-06 | Franklin | Alabama | 1059 | 3903 | 68 |
934885 | 934885 | 2021-01-16 | Oktibbeha | Mississippi | 28105 | 3903 | 80 |
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);