ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
181 rows where cases = 3387 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Mississippi 31
- Texas 18
- Kentucky 8
- Alabama 7
- Arkansas 7
- Indiana 7
- Iowa 7
- Michigan 7
- Missouri 7
- North Carolina 7
- Tennessee 7
- Georgia 6
- Minnesota 6
- Ohio 6
- Oregon 5
- South Carolina 5
- Louisiana 4
- Pennsylvania 4
- Puerto Rico 4
- Virginia 4
- Florida 3
- New Mexico 3
- Colorado 2
- Illinois 2
- Massachusetts 2
- New York 2
- North Dakota 2
- Idaho 1
- Maryland 1
- Nebraska 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2484782 | 2484782 | 2022-05-08 | Webster | Mississippi | 28155 | 3387 | 70 |
2481524 | 2481524 | 2022-05-07 | Webster | Mississippi | 28155 | 3387 | 70 |
2478266 | 2478266 | 2022-05-06 | Webster | Mississippi | 28155 | 3387 | 70 |
2475008 | 2475008 | 2022-05-05 | Webster | Mississippi | 28155 | 3387 | 70 |
2471751 | 2471751 | 2022-05-04 | Webster | Mississippi | 28155 | 3387 | 70 |
2468495 | 2468495 | 2022-05-03 | Webster | Mississippi | 28155 | 3387 | 70 |
2465239 | 2465239 | 2022-05-02 | Webster | Mississippi | 28155 | 3387 | 70 |
2461984 | 2461984 | 2022-05-01 | Webster | Mississippi | 28155 | 3387 | 70 |
2458728 | 2458728 | 2022-04-30 | Webster | Mississippi | 28155 | 3387 | 70 |
2455472 | 2455472 | 2022-04-29 | Webster | Mississippi | 28155 | 3387 | 70 |
2452216 | 2452216 | 2022-04-28 | Webster | Mississippi | 28155 | 3387 | 70 |
2448960 | 2448960 | 2022-04-27 | Webster | Mississippi | 28155 | 3387 | 70 |
2445703 | 2445703 | 2022-04-26 | Webster | Mississippi | 28155 | 3387 | 70 |
2442448 | 2442448 | 2022-04-25 | Webster | Mississippi | 28155 | 3387 | 70 |
2439192 | 2439192 | 2022-04-24 | Webster | Mississippi | 28155 | 3387 | 70 |
2435936 | 2435936 | 2022-04-23 | Webster | Mississippi | 28155 | 3387 | 70 |
2432680 | 2432680 | 2022-04-22 | Webster | Mississippi | 28155 | 3387 | 70 |
2429424 | 2429424 | 2022-04-21 | Webster | Mississippi | 28155 | 3387 | 70 |
2424943 | 2424943 | 2022-04-20 | Gunnison | Colorado | 8051 | 3387 | 14 |
2426168 | 2426168 | 2022-04-20 | Webster | Mississippi | 28155 | 3387 | 70 |
2422912 | 2422912 | 2022-04-19 | Webster | Mississippi | 28155 | 3387 | 70 |
2419655 | 2419655 | 2022-04-18 | Webster | Mississippi | 28155 | 3387 | 70 |
2421020 | 2421020 | 2022-04-18 | Tyler | Texas | 48457 | 3387 | 87 |
2421097 | 2421097 | 2022-04-18 | Alleghany | Virginia | 51005 | 3387 | 98 |
2416400 | 2416400 | 2022-04-17 | Webster | Mississippi | 28155 | 3387 | 70 |
2417764 | 2417764 | 2022-04-17 | Tyler | Texas | 48457 | 3387 | 87 |
2413144 | 2413144 | 2022-04-16 | Webster | Mississippi | 28155 | 3387 | 70 |
2414508 | 2414508 | 2022-04-16 | Tyler | Texas | 48457 | 3387 | 87 |
2409888 | 2409888 | 2022-04-15 | Webster | Mississippi | 28155 | 3387 | 70 |
2411252 | 2411252 | 2022-04-15 | Tyler | Texas | 48457 | 3387 | 87 |
2406632 | 2406632 | 2022-04-14 | Webster | Mississippi | 28155 | 3387 | 70 |
2407996 | 2407996 | 2022-04-14 | Tyler | Texas | 48457 | 3387 | 87 |
2403376 | 2403376 | 2022-04-13 | Webster | Mississippi | 28155 | 3387 | 70 |
2404740 | 2404740 | 2022-04-13 | Tyler | Texas | 48457 | 3387 | 86 |
2400121 | 2400121 | 2022-04-12 | Webster | Mississippi | 28155 | 3387 | 70 |
2401485 | 2401485 | 2022-04-12 | Tyler | Texas | 48457 | 3387 | 86 |
2398230 | 2398230 | 2022-04-11 | Tyler | Texas | 48457 | 3387 | 86 |
2394975 | 2394975 | 2022-04-10 | Tyler | Texas | 48457 | 3387 | 86 |
2389014 | 2389014 | 2022-04-09 | Marion | Arkansas | 5089 | 3387 | 88 |
2391719 | 2391719 | 2022-04-09 | Tyler | Texas | 48457 | 3387 | 86 |
2385759 | 2385759 | 2022-04-08 | Marion | Arkansas | 5089 | 3387 | 88 |
2388463 | 2388463 | 2022-04-08 | Tyler | Texas | 48457 | 3387 | 86 |
2385208 | 2385208 | 2022-04-07 | Tyler | Texas | 48457 | 3387 | 86 |
2381953 | 2381953 | 2022-04-06 | Tyler | Texas | 48457 | 3387 | 86 |
2377748 | 2377748 | 2022-04-05 | Yates | New York | 36123 | 3387 | 39 |
2269731 | 2269731 | 2022-03-03 | Dukes | Massachusetts | 25007 | 3387 | 0 |
2263227 | 2263227 | 2022-03-01 | Dukes | Massachusetts | 25007 | 3387 | 0 |
2263248 | 2263248 | 2022-03-01 | Benzie | Michigan | 26019 | 3387 | 64 |
2259997 | 2259997 | 2022-02-28 | Benzie | Michigan | 26019 | 3387 | 64 |
2247732 | 2247732 | 2022-02-24 | Swain | North Carolina | 37173 | 3387 | 35 |
2248163 | 2248163 | 2022-02-24 | Bamberg | South Carolina | 45009 | 3387 | 71 |
2244912 | 2244912 | 2022-02-23 | Bamberg | South Carolina | 45009 | 3387 | 71 |
2239935 | 2239935 | 2022-02-22 | Washington | Illinois | 17189 | 3387 | 40 |
2220777 | 2220777 | 2022-02-16 | Green | Kentucky | 21087 | 3387 | 40 |
2220844 | 2220844 | 2022-02-16 | Trigg | Kentucky | 21221 | 3387 | 40 |
2219360 | 2219360 | 2022-02-15 | Zapata | Texas | 48505 | 3387 | 49 |
2201579 | 2201579 | 2022-02-10 | Kanabec | Minnesota | 27065 | 3387 | 54 |
2189245 | 2189245 | 2022-02-06 | Ramsey | North Dakota | 38071 | 3387 | 49 |
2185992 | 2185992 | 2022-02-05 | Ramsey | North Dakota | 38071 | 3387 | 49 |
2155435 | 2155435 | 2022-01-27 | Parke | Indiana | 18121 | 3387 | 41 |
2149692 | 2149692 | 2022-01-25 | Dallas | Missouri | 29059 | 3387 | 64 |
2142714 | 2142714 | 2022-01-23 | Jackson | Kentucky | 21109 | 3387 | 60 |
2139459 | 2139459 | 2022-01-22 | Jackson | Kentucky | 21109 | 3387 | 60 |
2135190 | 2135190 | 2022-01-21 | Macon | Alabama | 1087 | 3387 | 69 |
2136203 | 2136203 | 2022-01-21 | Jackson | Kentucky | 21109 | 3387 | 60 |
2112192 | 2112192 | 2022-01-13 | Asotin | Washington | 53003 | 3387 | 54 |
2095785 | 2095785 | 2022-01-08 | Caledonia | Vermont | 50005 | 3387 | 21 |
2087664 | 2087664 | 2022-01-06 | Manistee | Michigan | 26101 | 3387 | 64 |
2084412 | 2084412 | 2022-01-05 | Manistee | Michigan | 26101 | 3387 | 64 |
2073540 | 2073540 | 2022-01-02 | Sharp | Arkansas | 5135 | 3387 | 78 |
2075739 | 2075739 | 2022-01-02 | Las Piedras | Puerto Rico | 72085 | 3387 | |
2053890 | 2053890 | 2021-12-27 | Fayette | Alabama | 1057 | 3387 | 86 |
2050640 | 2050640 | 2021-12-26 | Fayette | Alabama | 1057 | 3387 | 86 |
2029699 | 2029699 | 2021-12-19 | Roosevelt | New Mexico | 35041 | 3387 | 75 |
2026448 | 2026448 | 2021-12-18 | Roosevelt | New Mexico | 35041 | 3387 | 75 |
2027005 | 2027005 | 2021-12-18 | Rio Grande | Puerto Rico | 72119 | 3387 | |
2023197 | 2023197 | 2021-12-17 | Roosevelt | New Mexico | 35041 | 3387 | 75 |
1996942 | 1996942 | 2021-12-09 | Ray | Missouri | 29177 | 3387 | 61 |
1994435 | 1994435 | 2021-12-08 | Wyoming | Pennsylvania | 42131 | 3387 | 69 |
1975972 | 1975972 | 2021-12-03 | Clark | Arkansas | 5019 | 3387 | 61 |
1967522 | 1967522 | 2021-11-30 | Attala | Mississippi | 28007 | 3387 | 90 |
1968363 | 1968363 | 2021-11-30 | Union | Oregon | 41061 | 3387 | 55 |
1962216 | 1962216 | 2021-11-28 | Union | Tennessee | 47173 | 3387 | 50 |
1958965 | 1958965 | 2021-11-27 | Union | Tennessee | 47173 | 3387 | 50 |
1955714 | 1955714 | 2021-11-26 | Union | Tennessee | 47173 | 3387 | 50 |
1952463 | 1952463 | 2021-11-25 | Union | Tennessee | 47173 | 3387 | 50 |
1949212 | 1949212 | 2021-11-24 | Union | Tennessee | 47173 | 3387 | 50 |
1938916 | 1938916 | 2021-11-21 | Carroll | Ohio | 39019 | 3387 | 76 |
1914242 | 1914242 | 2021-11-14 | Lawrence | Arkansas | 5075 | 3387 | 58 |
1914823 | 1914823 | 2021-11-14 | Fulton | Indiana | 18049 | 3387 | 69 |
1910850 | 1910850 | 2021-11-13 | Butler | Alabama | 1013 | 3387 | 99 |
1911573 | 1911573 | 2021-11-13 | Fulton | Indiana | 18049 | 3387 | 69 |
1907601 | 1907601 | 2021-11-12 | Butler | Alabama | 1013 | 3387 | 99 |
1908324 | 1908324 | 2021-11-12 | Fulton | Indiana | 18049 | 3387 | 69 |
1904352 | 1904352 | 2021-11-11 | Butler | Alabama | 1013 | 3387 | 99 |
1889311 | 1889311 | 2021-11-06 | Garrett | Maryland | 24023 | 3387 | 83 |
1884970 | 1884970 | 2021-11-05 | Columbia | Arkansas | 5027 | 3387 | 74 |
1852113 | 1852113 | 2021-10-25 | Mecklenburg | Virginia | 51117 | 3387 | 82 |
1833863 | 1833863 | 2021-10-20 | Anderson | Kentucky | 21005 | 3387 | 40 |
1807672 | 1807672 | 2021-10-12 | Boone | Iowa | 19015 | 3387 | 36 |
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);