ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
417 rows where cases = 1387 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 55
- Texas 41
- Kentucky 29
- Indiana 19
- Missouri 18
- Virginia 16
- Puerto Rico 15
- Illinois 13
- South Dakota 13
- Tennessee 13
- Minnesota 11
- Montana 11
- Kansas 10
- North Carolina 10
- Georgia 9
- Michigan 8
- Nebraska 8
- Idaho 7
- Nevada 7
- New Mexico 7
- Pennsylvania 7
- California 6
- Ohio 6
- Washington 6
- Alabama 5
- New York 5
- Oklahoma 5
- Utah 5
- Arkansas 4
- Mississippi 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500408 | 2500408 | 2022-05-13 | Fremont | Iowa | 19071 | 1387 | 25 |
2500582 | 2500582 | 2022-05-13 | Ballard | Kentucky | 21007 | 1387 | 29 |
2501078 | 2501078 | 2022-05-13 | Atchison | Missouri | 29005 | 1387 | 23 |
2497150 | 2497150 | 2022-05-12 | Fremont | Iowa | 19071 | 1387 | 25 |
2497324 | 2497324 | 2022-05-12 | Ballard | Kentucky | 21007 | 1387 | 29 |
2493892 | 2493892 | 2022-05-11 | Fremont | Iowa | 19071 | 1387 | 25 |
2494066 | 2494066 | 2022-05-11 | Ballard | Kentucky | 21007 | 1387 | 29 |
2490634 | 2490634 | 2022-05-10 | Fremont | Iowa | 19071 | 1387 | 25 |
2490808 | 2490808 | 2022-05-10 | Ballard | Kentucky | 21007 | 1387 | 29 |
2487377 | 2487377 | 2022-05-09 | Fremont | Iowa | 19071 | 1387 | 25 |
2487551 | 2487551 | 2022-05-09 | Ballard | Kentucky | 21007 | 1387 | 29 |
2484119 | 2484119 | 2022-05-08 | Fremont | Iowa | 19071 | 1387 | 25 |
2484982 | 2484982 | 2022-05-08 | Dawes | Nebraska | 31045 | 1387 | 21 |
2480861 | 2480861 | 2022-05-07 | Fremont | Iowa | 19071 | 1387 | 25 |
2481724 | 2481724 | 2022-05-07 | Dawes | Nebraska | 31045 | 1387 | 21 |
2477603 | 2477603 | 2022-05-06 | Fremont | Iowa | 19071 | 1387 | 25 |
2478466 | 2478466 | 2022-05-06 | Dawes | Nebraska | 31045 | 1387 | 21 |
2474345 | 2474345 | 2022-05-05 | Fremont | Iowa | 19071 | 1387 | 25 |
2475208 | 2475208 | 2022-05-05 | Dawes | Nebraska | 31045 | 1387 | 21 |
2471088 | 2471088 | 2022-05-04 | Fremont | Iowa | 19071 | 1387 | 25 |
2471951 | 2471951 | 2022-05-04 | Dawes | Nebraska | 31045 | 1387 | 21 |
2467832 | 2467832 | 2022-05-03 | Fremont | Iowa | 19071 | 1387 | 25 |
2464577 | 2464577 | 2022-05-02 | Fremont | Iowa | 19071 | 1387 | 25 |
2461321 | 2461321 | 2022-05-01 | Fremont | Iowa | 19071 | 1387 | 25 |
2458065 | 2458065 | 2022-04-30 | Fremont | Iowa | 19071 | 1387 | 25 |
2454809 | 2454809 | 2022-04-29 | Fremont | Iowa | 19071 | 1387 | 25 |
2451553 | 2451553 | 2022-04-28 | Fremont | Iowa | 19071 | 1387 | 25 |
2448297 | 2448297 | 2022-04-27 | Fremont | Iowa | 19071 | 1387 | 25 |
2445041 | 2445041 | 2022-04-26 | Fremont | Iowa | 19071 | 1387 | 25 |
2441785 | 2441785 | 2022-04-25 | Fremont | Iowa | 19071 | 1387 | 25 |
2438529 | 2438529 | 2022-04-24 | Fremont | Iowa | 19071 | 1387 | 25 |
2435273 | 2435273 | 2022-04-23 | Fremont | Iowa | 19071 | 1387 | 25 |
2432017 | 2432017 | 2022-04-22 | Fremont | Iowa | 19071 | 1387 | 25 |
2428761 | 2428761 | 2022-04-21 | Fremont | Iowa | 19071 | 1387 | 25 |
2425505 | 2425505 | 2022-04-20 | Fremont | Iowa | 19071 | 1387 | 25 |
2419495 | 2419495 | 2022-04-18 | Big Stone | Minnesota | 27011 | 1387 | 8 |
2293515 | 2293515 | 2022-03-10 | Lake | Oregon | 41037 | 1387 | 25 |
2224761 | 2224761 | 2022-02-17 | Pershing | Nevada | 32027 | 1387 | 29 |
2226054 | 2226054 | 2022-02-17 | Ferry | Washington | 53019 | 1387 | 25 |
2221510 | 2221510 | 2022-02-16 | Pershing | Nevada | 32027 | 1387 | 29 |
2222803 | 2222803 | 2022-02-16 | Ferry | Washington | 53019 | 1387 | 25 |
2218259 | 2218259 | 2022-02-15 | Pershing | Nevada | 32027 | 1387 | 29 |
2215008 | 2215008 | 2022-02-14 | Pershing | Nevada | 32027 | 1387 | 29 |
2211756 | 2211756 | 2022-02-13 | Pershing | Nevada | 32027 | 1387 | 29 |
2208503 | 2208503 | 2022-02-12 | Pershing | Nevada | 32027 | 1387 | 29 |
2205250 | 2205250 | 2022-02-11 | Pershing | Nevada | 32027 | 1387 | 29 |
2188162 | 2188162 | 2022-02-06 | Mitchell | Kansas | 20123 | 1387 | 19 |
2184909 | 2184909 | 2022-02-05 | Mitchell | Kansas | 20123 | 1387 | 19 |
2181657 | 2181657 | 2022-02-04 | Mitchell | Kansas | 20123 | 1387 | 19 |
2183061 | 2183061 | 2022-02-04 | Guanica | Puerto Rico | 72055 | 1387 | |
2175883 | 2175883 | 2022-02-02 | Clay | Nebraska | 31035 | 1387 | 20 |
2170349 | 2170349 | 2022-01-31 | Carson | Texas | 48065 | 1387 | 31 |
2157853 | 2157853 | 2022-01-27 | Iron | Wisconsin | 55051 | 1387 | 44 |
2151416 | 2151416 | 2022-01-25 | Weston | Wyoming | 56045 | 1387 | 16 |
2103117 | 2103117 | 2022-01-11 | Miller | Georgia | 13201 | 1387 | 24 |
2098045 | 2098045 | 2022-01-09 | Camden | North Carolina | 37029 | 1387 | 9 |
2094793 | 2094793 | 2022-01-08 | Camden | North Carolina | 37029 | 1387 | 9 |
2091541 | 2091541 | 2022-01-07 | Camden | North Carolina | 37029 | 1387 | 9 |
2059832 | 2059832 | 2021-12-28 | Hamilton | Texas | 48193 | 1387 | 29 |
2056583 | 2056583 | 2021-12-27 | Hamilton | Texas | 48193 | 1387 | 29 |
2051397 | 2051397 | 2021-12-26 | Union | Indiana | 18161 | 1387 | 18 |
2048147 | 2048147 | 2021-12-25 | Union | Indiana | 18161 | 1387 | 18 |
2044897 | 2044897 | 2021-12-24 | Union | Indiana | 18161 | 1387 | 18 |
2041648 | 2041648 | 2021-12-23 | Union | Indiana | 18161 | 1387 | 18 |
2038398 | 2038398 | 2021-12-22 | Union | Indiana | 18161 | 1387 | 18 |
2035273 | 2035273 | 2021-12-21 | Clay | Kansas | 20027 | 1387 | 31 |
2032023 | 2032023 | 2021-12-20 | Clay | Kansas | 20027 | 1387 | 31 |
2032711 | 2032711 | 2021-12-20 | St. Clair | Missouri | 29185 | 1387 | 27 |
2015872 | 2015872 | 2021-12-15 | Bracken | Kentucky | 21023 | 1387 | 19 |
2016284 | 2016284 | 2021-12-15 | Choctaw | Mississippi | 28019 | 1387 | 27 |
2013275 | 2013275 | 2021-12-14 | Valley | Montana | 30105 | 1387 | 31 |
2014014 | 2014014 | 2021-12-14 | Utuado | Puerto Rico | 72141 | 1387 | |
2014810 | 2014810 | 2021-12-14 | Pepin | Wisconsin | 55091 | 1387 | 12 |
2010763 | 2010763 | 2021-12-13 | Utuado | Puerto Rico | 72141 | 1387 | |
2005195 | 2005195 | 2021-12-12 | Southeast Fairbanks Census Area | Alaska | 2240 | 1387 | 12 |
2006135 | 2006135 | 2021-12-12 | Crittenden | Kentucky | 21055 | 1387 | 37 |
2007512 | 2007512 | 2021-12-12 | Utuado | Puerto Rico | 72141 | 1387 | |
2001944 | 2001944 | 2021-12-11 | Southeast Fairbanks Census Area | Alaska | 2240 | 1387 | 12 |
2002884 | 2002884 | 2021-12-11 | Crittenden | Kentucky | 21055 | 1387 | 37 |
2004247 | 2004247 | 2021-12-11 | Quebradillas | Puerto Rico | 72115 | 1387 | |
1998694 | 1998694 | 2021-12-10 | Southeast Fairbanks Census Area | Alaska | 2240 | 1387 | 12 |
1999634 | 1999634 | 2021-12-10 | Crittenden | Kentucky | 21055 | 1387 | 37 |
2000996 | 2000996 | 2021-12-10 | Quebradillas | Puerto Rico | 72115 | 1387 | |
1996394 | 1996394 | 2021-12-09 | Gallatin | Kentucky | 21077 | 1387 | 44 |
1970995 | 1970995 | 2021-12-01 | Madison | Montana | 30057 | 1387 | 19 |
1968060 | 1968060 | 2021-11-30 | Jones | North Carolina | 37103 | 1387 | 35 |
1960633 | 1960633 | 2021-11-28 | Elliott | Kentucky | 21063 | 1387 | 10 |
1957382 | 1957382 | 2021-11-27 | Elliott | Kentucky | 21063 | 1387 | 10 |
1954131 | 1954131 | 2021-11-26 | Elliott | Kentucky | 21063 | 1387 | 10 |
1950880 | 1950880 | 2021-11-25 | Elliott | Kentucky | 21063 | 1387 | 10 |
1947629 | 1947629 | 2021-11-24 | Elliott | Kentucky | 21063 | 1387 | 10 |
1927409 | 1927409 | 2021-11-18 | Unknown | Connecticut | 1387 | 2 | |
1928710 | 1928710 | 2021-11-18 | Blaine | Montana | 30005 | 1387 | 27 |
1926295 | 1926295 | 2021-11-17 | McCormick | South Carolina | 45065 | 1387 | 30 |
1926788 | 1926788 | 2021-11-17 | Buena Vista city | Virginia | 51530 | 1387 | 28 |
1917978 | 1917978 | 2021-11-15 | Hamilton | Illinois | 17065 | 1387 | 25 |
1919035 | 1919035 | 2021-11-15 | Custer | Nebraska | 31041 | 1387 | 21 |
1905859 | 1905859 | 2021-11-11 | Carroll | Missouri | 29033 | 1387 | 27 |
1902610 | 1902610 | 2021-11-10 | Carroll | Missouri | 29033 | 1387 | 27 |
1892748 | 1892748 | 2021-11-07 | Stevens | Minnesota | 27149 | 1387 | 11 |
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);