ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
541 rows where cases = 714 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 67
- Nebraska 42
- Kansas 37
- Oklahoma 36
- Georgia 31
- Virginia 26
- Michigan 24
- Missouri 21
- Montana 18
- Puerto Rico 17
- Kentucky 15
- Minnesota 15
- North Carolina 13
- Illinois 12
- North Dakota 11
- South Dakota 11
- Iowa 10
- Colorado 9
- Idaho 9
- Ohio 9
- Mississippi 8
- Utah 8
- Vermont 8
- Alabama 7
- Arkansas 6
- Oregon 6
- South Carolina 6
- Tennessee 6
- Arizona 5
- Nevada 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501762 | 2501762 | 2022-05-13 | Harper | Oklahoma | 40059 | 714 | 12 |
2502340 | 2502340 | 2022-05-13 | Kimble | Texas | 48267 | 714 | 15 |
2498504 | 2498504 | 2022-05-12 | Harper | Oklahoma | 40059 | 714 | 12 |
2499082 | 2499082 | 2022-05-12 | Kimble | Texas | 48267 | 714 | 15 |
2495246 | 2495246 | 2022-05-11 | Harper | Oklahoma | 40059 | 714 | 12 |
2495824 | 2495824 | 2022-05-11 | Kimble | Texas | 48267 | 714 | 15 |
2491988 | 2491988 | 2022-05-10 | Harper | Oklahoma | 40059 | 714 | 12 |
2492566 | 2492566 | 2022-05-10 | Kimble | Texas | 48267 | 714 | 15 |
2488730 | 2488730 | 2022-05-09 | Harper | Oklahoma | 40059 | 714 | 12 |
2489308 | 2489308 | 2022-05-09 | Kimble | Texas | 48267 | 714 | 15 |
2485473 | 2485473 | 2022-05-08 | Harper | Oklahoma | 40059 | 714 | 12 |
2486051 | 2486051 | 2022-05-08 | Kimble | Texas | 48267 | 714 | 15 |
2482215 | 2482215 | 2022-05-07 | Harper | Oklahoma | 40059 | 714 | 12 |
2478957 | 2478957 | 2022-05-06 | Harper | Oklahoma | 40059 | 714 | 12 |
2475699 | 2475699 | 2022-05-05 | Harper | Oklahoma | 40059 | 714 | 12 |
2472442 | 2472442 | 2022-05-04 | Harper | Oklahoma | 40059 | 714 | 12 |
2469186 | 2469186 | 2022-05-03 | Harper | Oklahoma | 40059 | 714 | 12 |
2465930 | 2465930 | 2022-05-02 | Harper | Oklahoma | 40059 | 714 | 12 |
2462675 | 2462675 | 2022-05-01 | Harper | Oklahoma | 40059 | 714 | 12 |
2459419 | 2459419 | 2022-04-30 | Harper | Oklahoma | 40059 | 714 | 12 |
2456163 | 2456163 | 2022-04-29 | Harper | Oklahoma | 40059 | 714 | 12 |
2452907 | 2452907 | 2022-04-28 | Harper | Oklahoma | 40059 | 714 | 12 |
2449651 | 2449651 | 2022-04-27 | Harper | Oklahoma | 40059 | 714 | 12 |
2446394 | 2446394 | 2022-04-26 | Harper | Oklahoma | 40059 | 714 | 12 |
2443139 | 2443139 | 2022-04-25 | Harper | Oklahoma | 40059 | 714 | 12 |
2439883 | 2439883 | 2022-04-24 | Harper | Oklahoma | 40059 | 714 | 12 |
2436627 | 2436627 | 2022-04-23 | Harper | Oklahoma | 40059 | 714 | 12 |
2433371 | 2433371 | 2022-04-22 | Harper | Oklahoma | 40059 | 714 | 12 |
2430115 | 2430115 | 2022-04-21 | Harper | Oklahoma | 40059 | 714 | 12 |
2404294 | 2404294 | 2022-04-13 | Vieques | Puerto Rico | 72147 | 714 | |
2320060 | 2320060 | 2022-03-18 | Lipscomb | Texas | 48295 | 714 | 16 |
2201942 | 2201942 | 2022-02-10 | Kimball | Nebraska | 31105 | 714 | 9 |
2198688 | 2198688 | 2022-02-09 | Kimball | Nebraska | 31105 | 714 | 9 |
2199728 | 2199728 | 2022-02-09 | Kinney | Texas | 48271 | 714 | 10 |
2196474 | 2196474 | 2022-02-08 | Kinney | Texas | 48271 | 714 | 10 |
2193220 | 2193220 | 2022-02-07 | Kinney | Texas | 48271 | 714 | 10 |
2188889 | 2188889 | 2022-02-06 | Chase | Nebraska | 31029 | 714 | 6 |
2185636 | 2185636 | 2022-02-05 | Chase | Nebraska | 31029 | 714 | 6 |
2182384 | 2182384 | 2022-02-04 | Chase | Nebraska | 31029 | 714 | 6 |
2179132 | 2179132 | 2022-02-03 | Chase | Nebraska | 31029 | 714 | 6 |
2166472 | 2166472 | 2022-01-30 | Nelson | North Dakota | 38063 | 714 | 17 |
2154200 | 2154200 | 2022-01-26 | Mason | Texas | 48319 | 714 | 9 |
2150630 | 2150630 | 2022-01-25 | Aurora | South Dakota | 46003 | 714 | 17 |
2150948 | 2150948 | 2022-01-25 | Mason | Texas | 48319 | 714 | 9 |
2134752 | 2134752 | 2022-01-20 | Upton | Texas | 48461 | 714 | 16 |
2134812 | 2134812 | 2022-01-20 | Grand Isle | Vermont | 50013 | 714 | 4 |
2131560 | 2131560 | 2022-01-19 | Grand Isle | Vermont | 50013 | 714 | 4 |
2123912 | 2123912 | 2022-01-17 | Mineral | Nevada | 32021 | 714 | 14 |
2120660 | 2120660 | 2022-01-16 | Mineral | Nevada | 32021 | 714 | 14 |
2117408 | 2117408 | 2022-01-15 | Mineral | Nevada | 32021 | 714 | 14 |
2114157 | 2114157 | 2022-01-14 | Mineral | Nevada | 32021 | 714 | 14 |
2103805 | 2103805 | 2022-01-11 | Unknown | Louisiana | 714 | 0 | |
2089225 | 2089225 | 2022-01-06 | Upton | Texas | 48461 | 714 | 15 |
2084524 | 2084524 | 2022-01-05 | Unknown | Minnesota | 714 | 140 | |
2080543 | 2080543 | 2022-01-04 | Pope | Illinois | 17151 | 714 | 7 |
2066641 | 2066641 | 2021-12-30 | Rappahannock | Virginia | 51157 | 714 | 7 |
2053000 | 2053000 | 2021-12-26 | Patillas | Puerto Rico | 72109 | 714 | |
2040570 | 2040570 | 2021-12-22 | Craig | Virginia | 51045 | 714 | 11 |
2019844 | 2019844 | 2021-12-16 | Nuckolls | Nebraska | 31129 | 714 | 13 |
2021126 | 2021126 | 2021-12-16 | Norton city | Virginia | 51720 | 714 | 17 |
2016594 | 2016594 | 2021-12-15 | Nuckolls | Nebraska | 31129 | 714 | 13 |
2017226 | 2017226 | 2021-12-15 | Hormigueros | Puerto Rico | 72067 | 714 | |
2013343 | 2013343 | 2021-12-14 | Nuckolls | Nebraska | 31129 | 714 | 12 |
2013976 | 2013976 | 2021-12-14 | Hormigueros | Puerto Rico | 72067 | 714 | |
1997128 | 1997128 | 2021-12-09 | Lincoln | Nevada | 32017 | 714 | 5 |
1997718 | 1997718 | 2021-12-09 | Guayanilla | Puerto Rico | 72059 | 714 | |
1994467 | 1994467 | 2021-12-08 | Guayanilla | Puerto Rico | 72059 | 714 | |
1991216 | 1991216 | 2021-12-07 | Guayanilla | Puerto Rico | 72059 | 714 | |
1970743 | 1970743 | 2021-12-01 | Red Lake | Minnesota | 27125 | 714 | 10 |
1971831 | 1971831 | 2021-12-01 | Corson | South Dakota | 46031 | 714 | 14 |
1968276 | 1968276 | 2021-11-30 | Dewey | Oklahoma | 40043 | 714 | 19 |
1968776 | 1968776 | 2021-11-30 | Concho | Texas | 48095 | 714 | 10 |
1965025 | 1965025 | 2021-11-29 | Dewey | Oklahoma | 40043 | 714 | 19 |
1965525 | 1965525 | 2021-11-29 | Concho | Texas | 48095 | 714 | 10 |
1961773 | 1961773 | 2021-11-28 | Dewey | Oklahoma | 40043 | 714 | 19 |
1962273 | 1962273 | 2021-11-28 | Concho | Texas | 48095 | 714 | 10 |
1962331 | 1962331 | 2021-11-28 | Hemphill | Texas | 48211 | 714 | 3 |
1962514 | 1962514 | 2021-11-28 | Essex | Vermont | 50009 | 714 | 2 |
1958522 | 1958522 | 2021-11-27 | Dewey | Oklahoma | 40043 | 714 | 19 |
1959022 | 1959022 | 2021-11-27 | Concho | Texas | 48095 | 714 | 10 |
1959080 | 1959080 | 2021-11-27 | Hemphill | Texas | 48211 | 714 | 3 |
1959263 | 1959263 | 2021-11-27 | Essex | Vermont | 50009 | 714 | 2 |
1955271 | 1955271 | 2021-11-26 | Dewey | Oklahoma | 40043 | 714 | 19 |
1955771 | 1955771 | 2021-11-26 | Concho | Texas | 48095 | 714 | 10 |
1955829 | 1955829 | 2021-11-26 | Hemphill | Texas | 48211 | 714 | 3 |
1956012 | 1956012 | 2021-11-26 | Essex | Vermont | 50009 | 714 | 2 |
1952020 | 1952020 | 2021-11-25 | Dewey | Oklahoma | 40043 | 714 | 19 |
1952520 | 1952520 | 2021-11-25 | Concho | Texas | 48095 | 714 | 10 |
1952578 | 1952578 | 2021-11-25 | Hemphill | Texas | 48211 | 714 | 3 |
1952761 | 1952761 | 2021-11-25 | Essex | Vermont | 50009 | 714 | 2 |
1948769 | 1948769 | 2021-11-24 | Dewey | Oklahoma | 40043 | 714 | 19 |
1949269 | 1949269 | 2021-11-24 | Concho | Texas | 48095 | 714 | 10 |
1949327 | 1949327 | 2021-11-24 | Hemphill | Texas | 48211 | 714 | 3 |
1949510 | 1949510 | 2021-11-24 | Essex | Vermont | 50009 | 714 | 2 |
1946018 | 1946018 | 2021-11-23 | Concho | Texas | 48095 | 714 | 10 |
1946076 | 1946076 | 2021-11-23 | Hemphill | Texas | 48211 | 714 | 3 |
1942767 | 1942767 | 2021-11-22 | Concho | Texas | 48095 | 714 | 10 |
1942825 | 1942825 | 2021-11-22 | Hemphill | Texas | 48211 | 714 | 3 |
1937434 | 1937434 | 2021-11-21 | Lincoln | Idaho | 16063 | 714 | 14 |
1939517 | 1939517 | 2021-11-21 | Concho | Texas | 48095 | 714 | 10 |
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);