ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
348 rows where cases = 1463 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kansas 31
- Kentucky 23
- Arkansas 22
- North Carolina 21
- Georgia 16
- Illinois 16
- Minnesota 16
- Wisconsin 16
- Virginia 14
- Mississippi 13
- Texas 13
- Colorado 11
- Montana 11
- Puerto Rico 11
- Iowa 9
- Indiana 8
- Ohio 7
- California 6
- Louisiana 6
- Tennessee 6
- Florida 5
- South Dakota 5
- Vermont 5
- Alabama 4
- Missouri 4
- New York 4
- North Dakota 4
- South Carolina 4
- West Virginia 4
- Massachusetts 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499245 | 2499245 | 2022-05-12 | Unknown | Vermont | 1463 | 2 | |
2451712 | 2451712 | 2022-04-28 | Stevens | Kansas | 20189 | 1463 | 20 |
2448456 | 2448456 | 2022-04-27 | Stevens | Kansas | 20189 | 1463 | 20 |
2445200 | 2445200 | 2022-04-26 | Stevens | Kansas | 20189 | 1463 | 20 |
2441944 | 2441944 | 2022-04-25 | Stevens | Kansas | 20189 | 1463 | 20 |
2438688 | 2438688 | 2022-04-24 | Stevens | Kansas | 20189 | 1463 | 20 |
2435432 | 2435432 | 2022-04-23 | Stevens | Kansas | 20189 | 1463 | 20 |
2432176 | 2432176 | 2022-04-22 | Stevens | Kansas | 20189 | 1463 | 20 |
2428920 | 2428920 | 2022-04-21 | Stevens | Kansas | 20189 | 1463 | 20 |
2425664 | 2425664 | 2022-04-20 | Stevens | Kansas | 20189 | 1463 | 20 |
2422408 | 2422408 | 2022-04-19 | Stevens | Kansas | 20189 | 1463 | 20 |
2419152 | 2419152 | 2022-04-18 | Stevens | Kansas | 20189 | 1463 | 20 |
2415896 | 2415896 | 2022-04-17 | Stevens | Kansas | 20189 | 1463 | 20 |
2412640 | 2412640 | 2022-04-16 | Stevens | Kansas | 20189 | 1463 | 20 |
2409384 | 2409384 | 2022-04-15 | Stevens | Kansas | 20189 | 1463 | 20 |
2406128 | 2406128 | 2022-04-14 | Stevens | Kansas | 20189 | 1463 | 20 |
2402872 | 2402872 | 2022-04-13 | Stevens | Kansas | 20189 | 1463 | 20 |
2404247 | 2404247 | 2022-04-13 | Guanica | Puerto Rico | 72055 | 1463 | |
2399618 | 2399618 | 2022-04-12 | Stevens | Kansas | 20189 | 1463 | 20 |
2396362 | 2396362 | 2022-04-11 | Stevens | Kansas | 20189 | 1463 | 20 |
2393107 | 2393107 | 2022-04-10 | Stevens | Kansas | 20189 | 1463 | 20 |
2389851 | 2389851 | 2022-04-09 | Stevens | Kansas | 20189 | 1463 | 20 |
2386595 | 2386595 | 2022-04-08 | Stevens | Kansas | 20189 | 1463 | 20 |
2388243 | 2388243 | 2022-04-08 | Bailey | Texas | 48017 | 1463 | 39 |
2384988 | 2384988 | 2022-04-07 | Bailey | Texas | 48017 | 1463 | 39 |
2381733 | 2381733 | 2022-04-06 | Bailey | Texas | 48017 | 1463 | 39 |
2378478 | 2378478 | 2022-04-05 | Bailey | Texas | 48017 | 1463 | 39 |
2375224 | 2375224 | 2022-04-04 | Bailey | Texas | 48017 | 1463 | 39 |
2371972 | 2371972 | 2022-04-03 | Bailey | Texas | 48017 | 1463 | 39 |
2368719 | 2368719 | 2022-04-02 | Bailey | Texas | 48017 | 1463 | 39 |
2338157 | 2338157 | 2022-03-24 | Grant | Minnesota | 27051 | 1463 | 12 |
2339987 | 2339987 | 2022-03-24 | Iron | Wisconsin | 55051 | 1463 | 47 |
2336734 | 2336734 | 2022-03-23 | Iron | Wisconsin | 55051 | 1463 | 47 |
2333480 | 2333480 | 2022-03-22 | Iron | Wisconsin | 55051 | 1463 | 47 |
2330226 | 2330226 | 2022-03-21 | Iron | Wisconsin | 55051 | 1463 | 47 |
2326974 | 2326974 | 2022-03-20 | Iron | Wisconsin | 55051 | 1463 | 47 |
2323721 | 2323721 | 2022-03-19 | Iron | Wisconsin | 55051 | 1463 | 47 |
2320467 | 2320467 | 2022-03-18 | Iron | Wisconsin | 55051 | 1463 | 47 |
2278496 | 2278496 | 2022-03-06 | Trinity | California | 6105 | 1463 | 20 |
2275243 | 2275243 | 2022-03-05 | Trinity | California | 6105 | 1463 | 20 |
2271990 | 2271990 | 2022-03-04 | Trinity | California | 6105 | 1463 | 20 |
2241897 | 2241897 | 2022-02-22 | Carson | Texas | 48065 | 1463 | 34 |
2238646 | 2238646 | 2022-02-21 | Carson | Texas | 48065 | 1463 | 34 |
2211425 | 2211425 | 2022-02-13 | Jefferson | Mississippi | 28063 | 1463 | 36 |
2208172 | 2208172 | 2022-02-12 | Jefferson | Mississippi | 28063 | 1463 | 36 |
2208768 | 2208768 | 2022-02-12 | Ransom | North Dakota | 38073 | 1463 | 27 |
2204919 | 2204919 | 2022-02-11 | Jefferson | Mississippi | 28063 | 1463 | 36 |
2201666 | 2201666 | 2022-02-10 | Jefferson | Mississippi | 28063 | 1463 | 36 |
2198412 | 2198412 | 2022-02-09 | Jefferson | Mississippi | 28063 | 1463 | 36 |
2177703 | 2177703 | 2022-02-03 | Clear Creek | Colorado | 8019 | 1463 | 10 |
2156082 | 2156082 | 2022-01-27 | Wilkin | Minnesota | 27167 | 1463 | 19 |
2145169 | 2145169 | 2022-01-24 | Conejos | Colorado | 8021 | 1463 | 49 |
2123228 | 2123228 | 2022-01-17 | Nicholas | Kentucky | 21181 | 1463 | 29 |
2124079 | 2124079 | 2022-01-17 | Gates | North Carolina | 37073 | 1463 | 18 |
2119976 | 2119976 | 2022-01-16 | Nicholas | Kentucky | 21181 | 1463 | 29 |
2120827 | 2120827 | 2022-01-16 | Gates | North Carolina | 37073 | 1463 | 18 |
2116724 | 2116724 | 2022-01-15 | Nicholas | Kentucky | 21181 | 1463 | 29 |
2117575 | 2117575 | 2022-01-15 | Gates | North Carolina | 37073 | 1463 | 18 |
2113473 | 2113473 | 2022-01-14 | Nicholas | Kentucky | 21181 | 1463 | 29 |
2114324 | 2114324 | 2022-01-14 | Gates | North Carolina | 37073 | 1463 | 18 |
2102249 | 2102249 | 2022-01-10 | Winkler | Texas | 48495 | 1463 | 32 |
2096648 | 2096648 | 2022-01-09 | Taylor | Georgia | 13269 | 1463 | 42 |
2097742 | 2097742 | 2022-01-09 | Blaine | Montana | 30005 | 1463 | 28 |
2098545 | 2098545 | 2022-01-09 | Allendale | South Carolina | 45005 | 1463 | 22 |
2093396 | 2093396 | 2022-01-08 | Taylor | Georgia | 13269 | 1463 | 42 |
2094490 | 2094490 | 2022-01-08 | Blaine | Montana | 30005 | 1463 | 28 |
2095293 | 2095293 | 2022-01-08 | Allendale | South Carolina | 45005 | 1463 | 22 |
2090144 | 2090144 | 2022-01-07 | Taylor | Georgia | 13269 | 1463 | 42 |
2091238 | 2091238 | 2022-01-07 | Blaine | Montana | 30005 | 1463 | 28 |
2092041 | 2092041 | 2022-01-07 | Allendale | South Carolina | 45005 | 1463 | 22 |
2086893 | 2086893 | 2022-01-06 | Taylor | Georgia | 13269 | 1463 | 42 |
2083641 | 2083641 | 2022-01-05 | Taylor | Georgia | 13269 | 1463 | 42 |
2065553 | 2065553 | 2021-12-30 | Graham | North Carolina | 37075 | 1463 | 28 |
2057271 | 2057271 | 2021-12-28 | Nevada | Arkansas | 5099 | 1463 | 42 |
2054170 | 2054170 | 2021-12-27 | Yuma | Colorado | 8125 | 1463 | 21 |
2055227 | 2055227 | 2021-12-27 | Lake | Minnesota | 27075 | 1463 | 26 |
2032146 | 2032146 | 2021-12-20 | Elliott | Kentucky | 21063 | 1463 | 13 |
2032563 | 2032563 | 2021-12-20 | Kemper | Mississippi | 28069 | 1463 | 41 |
2005740 | 2005740 | 2021-12-12 | Hamilton | Illinois | 17065 | 1463 | 26 |
2002489 | 2002489 | 2021-12-11 | Hamilton | Illinois | 17065 | 1463 | 26 |
1999239 | 1999239 | 2021-12-10 | Hamilton | Illinois | 17065 | 1463 | 26 |
1985499 | 1985499 | 2021-12-05 | Tyler | West Virginia | 54095 | 1463 | 25 |
1974997 | 1974997 | 2021-12-02 | Salinas | Puerto Rico | 72123 | 1463 | |
1975195 | 1975195 | 2021-12-02 | Moore | Tennessee | 47127 | 1463 | 25 |
1975612 | 1975612 | 2021-12-02 | Nelson | Virginia | 51125 | 1463 | 20 |
1971748 | 1971748 | 2021-12-01 | Salinas | Puerto Rico | 72123 | 1463 | |
1972463 | 1972463 | 2021-12-01 | Gilmer | West Virginia | 54021 | 1463 | 14 |
1965445 | 1965445 | 2021-11-29 | Moore | Tennessee | 47127 | 1463 | 24 |
1928290 | 1928290 | 2021-11-18 | Piscataquis | Maine | 23021 | 1463 | 13 |
1928479 | 1928479 | 2021-11-18 | Pipestone | Minnesota | 27117 | 1463 | 29 |
1927087 | 1927087 | 2021-11-17 | Sublette | Wyoming | 56035 | 1463 | 22 |
1923547 | 1923547 | 2021-11-16 | Clarke | Virginia | 51043 | 1463 | 26 |
1917048 | 1917048 | 2021-11-14 | Clarke | Virginia | 51043 | 1463 | 25 |
1913798 | 1913798 | 2021-11-13 | Clarke | Virginia | 51043 | 1463 | 25 |
1910548 | 1910548 | 2021-11-12 | Clarke | Virginia | 51043 | 1463 | 25 |
1905101 | 1905101 | 2021-11-11 | Martin | Indiana | 18101 | 1463 | 20 |
1890507 | 1890507 | 2021-11-06 | Yauco | Puerto Rico | 72153 | 1463 | |
1887257 | 1887257 | 2021-11-05 | Yauco | Puerto Rico | 72153 | 1463 | |
1876064 | 1876064 | 2021-11-02 | Norton | Kansas | 20137 | 1463 | 32 |
1872815 | 1872815 | 2021-11-01 | Norton | Kansas | 20137 | 1463 | 32 |
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);