ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
130 rows where cases = 4281 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 15
- Kentucky 11
- Florida 9
- Texas 9
- North Carolina 8
- Illinois 7
- Minnesota 6
- Mississippi 6
- Ohio 6
- Colorado 4
- Missouri 4
- New York 4
- Virginia 4
- Wisconsin 4
- Arkansas 3
- Indiana 3
- Pennsylvania 3
- Tennessee 3
- Utah 3
- Alabama 2
- California 2
- Maryland 2
- Nebraska 2
- Oregon 2
- West Virginia 2
- Idaho 1
- Louisiana 1
- Montana 1
- Nevada 1
- Puerto Rico 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492975 | 2492975 | 2022-05-10 | Crawford | Wisconsin | 55023 | 4281 | 28 |
2484344 | 2484344 | 2022-05-08 | Jackson | Kentucky | 21109 | 4281 | 80 |
2481086 | 2481086 | 2022-05-07 | Jackson | Kentucky | 21109 | 4281 | 80 |
2477828 | 2477828 | 2022-05-06 | Jackson | Kentucky | 21109 | 4281 | 80 |
2474570 | 2474570 | 2022-05-05 | Jackson | Kentucky | 21109 | 4281 | 80 |
2471313 | 2471313 | 2022-05-04 | Jackson | Kentucky | 21109 | 4281 | 80 |
2468057 | 2468057 | 2022-05-03 | Jackson | Kentucky | 21109 | 4281 | 80 |
2464802 | 2464802 | 2022-05-02 | Jackson | Kentucky | 21109 | 4281 | 80 |
2349470 | 2349470 | 2022-03-27 | Unknown | Utah | 4281 | 96 | |
2346217 | 2346217 | 2022-03-26 | Unknown | Utah | 4281 | 96 | |
2342964 | 2342964 | 2022-03-25 | Unknown | Utah | 4281 | 96 | |
2255746 | 2255746 | 2022-02-27 | Chaffee | Colorado | 8015 | 4281 | 42 |
2252495 | 2252495 | 2022-02-26 | Chaffee | Colorado | 8015 | 4281 | 42 |
2249244 | 2249244 | 2022-02-25 | Chaffee | Colorado | 8015 | 4281 | 42 |
2236607 | 2236607 | 2022-02-21 | De Witt | Illinois | 17039 | 4281 | 42 |
2233356 | 2233356 | 2022-02-20 | De Witt | Illinois | 17039 | 4281 | 42 |
2230105 | 2230105 | 2022-02-19 | De Witt | Illinois | 17039 | 4281 | 42 |
2226854 | 2226854 | 2022-02-18 | De Witt | Illinois | 17039 | 4281 | 42 |
2205828 | 2205828 | 2022-02-11 | Coamo | Puerto Rico | 72043 | 4281 | |
2200561 | 2200561 | 2022-02-10 | Gilchrist | Florida | 12041 | 4281 | 71 |
2197307 | 2197307 | 2022-02-09 | Gilchrist | Florida | 12041 | 4281 | 71 |
2194053 | 2194053 | 2022-02-08 | Gilchrist | Florida | 12041 | 4281 | 71 |
2190799 | 2190799 | 2022-02-07 | Gilchrist | Florida | 12041 | 4281 | 71 |
2191185 | 2191185 | 2022-02-07 | Franklin | Indiana | 18047 | 4281 | 60 |
2192229 | 2192229 | 2022-02-07 | Humboldt | Nevada | 32013 | 4281 | 48 |
2187546 | 2187546 | 2022-02-06 | Gilchrist | Florida | 12041 | 4281 | 71 |
2184293 | 2184293 | 2022-02-05 | Gilchrist | Florida | 12041 | 4281 | 71 |
2181041 | 2181041 | 2022-02-04 | Gilchrist | Florida | 12041 | 4281 | 71 |
2147174 | 2147174 | 2022-01-24 | Union | Oregon | 41061 | 4281 | 65 |
2142192 | 2142192 | 2022-01-23 | Union | Georgia | 13291 | 4281 | 135 |
2138937 | 2138937 | 2022-01-22 | Union | Georgia | 13291 | 4281 | 135 |
2135681 | 2135681 | 2022-01-21 | Union | Georgia | 13291 | 4281 | 135 |
2136725 | 2136725 | 2022-01-21 | Perry | Missouri | 29157 | 4281 | 44 |
2125394 | 2125394 | 2022-01-18 | Butler | Alabama | 1013 | 4281 | 102 |
2128431 | 2128431 | 2022-01-18 | Scott | Virginia | 51169 | 4281 | 93 |
2128495 | 2128495 | 2022-01-18 | Brooke | West Virginia | 54009 | 4281 | 88 |
2121848 | 2121848 | 2022-01-16 | Dinwiddie | Virginia | 51053 | 4281 | 63 |
2118596 | 2118596 | 2022-01-15 | Dinwiddie | Virginia | 51053 | 4281 | 63 |
2115344 | 2115344 | 2022-01-14 | Dinwiddie | Virginia | 51053 | 4281 | 63 |
2096574 | 2096574 | 2022-01-09 | Franklin | Georgia | 13119 | 4281 | 85 |
2093322 | 2093322 | 2022-01-08 | Franklin | Georgia | 13119 | 4281 | 85 |
2090070 | 2090070 | 2022-01-07 | Franklin | Georgia | 13119 | 4281 | 85 |
2086819 | 2086819 | 2022-01-06 | Franklin | Georgia | 13119 | 4281 | 85 |
2083567 | 2083567 | 2022-01-05 | Franklin | Georgia | 13119 | 4281 | 85 |
2080042 | 2080042 | 2022-01-04 | Sevier | Arkansas | 5133 | 4281 | 63 |
2061815 | 2061815 | 2021-12-29 | Leake | Mississippi | 28079 | 4281 | 92 |
2058805 | 2058805 | 2021-12-28 | Dawson | Nebraska | 31047 | 4281 | 37 |
2054865 | 2054865 | 2021-12-27 | Allen | Kentucky | 21003 | 4281 | 80 |
1964442 | 1964442 | 2021-11-29 | Saline | Missouri | 29195 | 4281 | 83 |
1925056 | 1925056 | 2021-11-17 | Dorchester | Maryland | 24019 | 4281 | 84 |
1891849 | 1891849 | 2021-11-07 | Pierce | Georgia | 13229 | 4281 | 103 |
1888599 | 1888599 | 2021-11-06 | Pierce | Georgia | 13229 | 4281 | 103 |
1885349 | 1885349 | 2021-11-05 | Pierce | Georgia | 13229 | 4281 | 103 |
1871853 | 1871853 | 2021-11-01 | Bibb | Alabama | 1007 | 4281 | 87 |
1867446 | 1867446 | 2021-10-30 | Hardin | Ohio | 39065 | 4281 | 84 |
1858998 | 1858998 | 2021-10-28 | Jackson | Arkansas | 5067 | 4281 | 43 |
1849839 | 1849839 | 2021-10-25 | Greene | Indiana | 18055 | 4281 | 100 |
1837610 | 1837610 | 2021-10-21 | Barry | Missouri | 29009 | 4281 | 60 |
1813993 | 1813993 | 2021-10-14 | Fayette | Illinois | 17051 | 4281 | 66 |
1794456 | 1794456 | 2021-10-08 | Latah | Idaho | 16057 | 4281 | 26 |
1763345 | 1763345 | 2021-09-28 | Montgomery | North Carolina | 37123 | 4281 | 106 |
1739088 | 1739088 | 2021-09-21 | Gilmer | Georgia | 13123 | 4281 | 110 |
1736571 | 1736571 | 2021-09-20 | West Baton Rouge | Louisiana | 22121 | 4281 | 71 |
1736818 | 1736818 | 2021-09-20 | Copiah | Mississippi | 28029 | 4281 | 87 |
1735302 | 1735302 | 2021-09-19 | Clark | Wisconsin | 55019 | 4281 | 69 |
1732052 | 1732052 | 2021-09-18 | Clark | Wisconsin | 55019 | 4281 | 69 |
1728802 | 1728802 | 2021-09-17 | Clark | Wisconsin | 55019 | 4281 | 69 |
1716300 | 1716300 | 2021-09-14 | Butts | Georgia | 13035 | 4281 | 93 |
1714197 | 1714197 | 2021-09-13 | Lafayette | Missouri | 29107 | 4281 | 67 |
1699840 | 1699840 | 2021-09-09 | Yell | Arkansas | 5149 | 4281 | 73 |
1700132 | 1700132 | 2021-09-09 | Lee | Georgia | 13177 | 4281 | 74 |
1673950 | 1673950 | 2021-09-01 | Montrose | Colorado | 8085 | 4281 | 74 |
1663407 | 1663407 | 2021-08-28 | Hopkins | Texas | 48223 | 4281 | 125 |
1652882 | 1652882 | 2021-08-25 | Jackson | North Carolina | 37099 | 4281 | 58 |
1646756 | 1646756 | 2021-08-23 | Venango | Pennsylvania | 42121 | 4281 | 105 |
1632044 | 1632044 | 2021-08-19 | Christian | Illinois | 17021 | 4281 | 94 |
1614017 | 1614017 | 2021-08-13 | Brown | Ohio | 39015 | 4281 | 63 |
1574425 | 1574425 | 2021-08-01 | Neshoba | Mississippi | 28099 | 4281 | 181 |
1571177 | 1571177 | 2021-07-31 | Neshoba | Mississippi | 28099 | 4281 | 181 |
1567929 | 1567929 | 2021-07-30 | Neshoba | Mississippi | 28099 | 4281 | 181 |
1557840 | 1557840 | 2021-07-27 | Whitley | Kentucky | 21235 | 4281 | 62 |
1558594 | 1558594 | 2021-07-27 | Montgomery | New York | 36057 | 4281 | 128 |
1555347 | 1555347 | 2021-07-26 | Montgomery | New York | 36057 | 4281 | 128 |
1542475 | 1542475 | 2021-07-22 | Stokes | North Carolina | 37169 | 4281 | 81 |
1475083 | 1475083 | 2021-07-01 | Matagorda | Texas | 48321 | 4281 | 114 |
1471920 | 1471920 | 2021-06-30 | Wharton | Texas | 48481 | 4281 | 117 |
1382471 | 1382471 | 2021-06-03 | Graves | Kentucky | 21083 | 4281 | 96 |
1379555 | 1379555 | 2021-06-02 | McLeod | Minnesota | 27085 | 4281 | 61 |
1376310 | 1376310 | 2021-06-01 | McLeod | Minnesota | 27085 | 4281 | 61 |
1373064 | 1373064 | 2021-05-31 | McLeod | Minnesota | 27085 | 4281 | 61 |
1369819 | 1369819 | 2021-05-30 | McLeod | Minnesota | 27085 | 4281 | 61 |
1366573 | 1366573 | 2021-05-29 | McLeod | Minnesota | 27085 | 4281 | 61 |
1363327 | 1363327 | 2021-05-28 | McLeod | Minnesota | 27085 | 4281 | 60 |
1338066 | 1338066 | 2021-05-20 | Fulton | Ohio | 39051 | 4281 | 70 |
1307402 | 1307402 | 2021-05-11 | Jefferson | Illinois | 17081 | 4281 | 121 |
1306262 | 1306262 | 2021-05-10 | Jim Wells | Texas | 48249 | 4281 | 101 |
1303016 | 1303016 | 2021-05-09 | Jim Wells | Texas | 48249 | 4281 | 101 |
1295637 | 1295637 | 2021-05-07 | Fulton | New York | 36035 | 4281 | 90 |
1250569 | 1250569 | 2021-04-23 | Linn | Oregon | 41043 | 4281 | 64 |
1222210 | 1222210 | 2021-04-14 | Jefferson | West Virginia | 54037 | 4281 | 48 |
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);