ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
572 rows where cases = 556 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Puerto Rico 46
- Kansas 45
- Texas 42
- Georgia 30
- Iowa 28
- Oklahoma 27
- Arkansas 22
- North Dakota 21
- Virginia 21
- Minnesota 20
- Nebraska 19
- Kentucky 18
- Oregon 18
- Illinois 17
- Montana 16
- South Dakota 16
- Louisiana 14
- North Carolina 13
- Missouri 12
- Idaho 11
- Alabama 10
- Indiana 10
- West Virginia 10
- Mississippi 9
- Alaska 7
- Colorado 7
- Michigan 7
- New Mexico 7
- South Carolina 6
- Tennessee 6
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499668 | 2499668 | 2022-05-13 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 556 | 5 |
2500496 | 2500496 | 2022-05-13 | Edwards | Kansas | 20047 | 556 | 13 |
2501623 | 2501623 | 2022-05-13 | Renville | North Dakota | 38075 | 556 | 15 |
2502305 | 2502305 | 2022-05-13 | Hardeman | Texas | 48197 | 556 | 19 |
2496410 | 2496410 | 2022-05-12 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 556 | 5 |
2497238 | 2497238 | 2022-05-12 | Edwards | Kansas | 20047 | 556 | 13 |
2499047 | 2499047 | 2022-05-12 | Hardeman | Texas | 48197 | 556 | 19 |
2493152 | 2493152 | 2022-05-11 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 556 | 5 |
2493980 | 2493980 | 2022-05-11 | Edwards | Kansas | 20047 | 556 | 13 |
2495789 | 2495789 | 2022-05-11 | Hardeman | Texas | 48197 | 556 | 19 |
2490722 | 2490722 | 2022-05-10 | Edwards | Kansas | 20047 | 556 | 13 |
2492531 | 2492531 | 2022-05-10 | Hardeman | Texas | 48197 | 556 | 19 |
2487465 | 2487465 | 2022-05-09 | Edwards | Kansas | 20047 | 556 | 13 |
2489273 | 2489273 | 2022-05-09 | Hardeman | Texas | 48197 | 556 | 19 |
2484207 | 2484207 | 2022-05-08 | Edwards | Kansas | 20047 | 556 | 13 |
2486016 | 2486016 | 2022-05-08 | Hardeman | Texas | 48197 | 556 | 19 |
2480949 | 2480949 | 2022-05-07 | Edwards | Kansas | 20047 | 556 | 13 |
2482758 | 2482758 | 2022-05-07 | Hardeman | Texas | 48197 | 556 | 19 |
2477691 | 2477691 | 2022-05-06 | Edwards | Kansas | 20047 | 556 | 13 |
2479500 | 2479500 | 2022-05-06 | Hardeman | Texas | 48197 | 556 | 19 |
2474433 | 2474433 | 2022-05-05 | Edwards | Kansas | 20047 | 556 | 13 |
2476242 | 2476242 | 2022-05-05 | Hardeman | Texas | 48197 | 556 | 19 |
2471176 | 2471176 | 2022-05-04 | Edwards | Kansas | 20047 | 556 | 13 |
2472985 | 2472985 | 2022-05-04 | Hardeman | Texas | 48197 | 556 | 19 |
2467920 | 2467920 | 2022-05-03 | Edwards | Kansas | 20047 | 556 | 13 |
2469729 | 2469729 | 2022-05-03 | Hardeman | Texas | 48197 | 556 | 19 |
2464665 | 2464665 | 2022-05-02 | Edwards | Kansas | 20047 | 556 | 13 |
2466473 | 2466473 | 2022-05-02 | Hardeman | Texas | 48197 | 556 | 19 |
2461409 | 2461409 | 2022-05-01 | Edwards | Kansas | 20047 | 556 | 13 |
2463218 | 2463218 | 2022-05-01 | Hardeman | Texas | 48197 | 556 | 19 |
2458153 | 2458153 | 2022-04-30 | Edwards | Kansas | 20047 | 556 | 13 |
2459962 | 2459962 | 2022-04-30 | Hardeman | Texas | 48197 | 556 | 19 |
2454897 | 2454897 | 2022-04-29 | Edwards | Kansas | 20047 | 556 | 13 |
2456706 | 2456706 | 2022-04-29 | Hardeman | Texas | 48197 | 556 | 19 |
2451641 | 2451641 | 2022-04-28 | Edwards | Kansas | 20047 | 556 | 13 |
2448385 | 2448385 | 2022-04-27 | Edwards | Kansas | 20047 | 556 | 13 |
2445129 | 2445129 | 2022-04-26 | Edwards | Kansas | 20047 | 556 | 13 |
2441873 | 2441873 | 2022-04-25 | Edwards | Kansas | 20047 | 556 | 13 |
2438617 | 2438617 | 2022-04-24 | Edwards | Kansas | 20047 | 556 | 13 |
2435361 | 2435361 | 2022-04-23 | Edwards | Kansas | 20047 | 556 | 13 |
2432105 | 2432105 | 2022-04-22 | Edwards | Kansas | 20047 | 556 | 13 |
2406481 | 2406481 | 2022-04-14 | Cook | Minnesota | 27031 | 556 | 4 |
2404266 | 2404266 | 2022-04-13 | Maricao | Puerto Rico | 72093 | 556 | |
2401011 | 2401011 | 2022-04-12 | Maricao | Puerto Rico | 72093 | 556 | |
2397756 | 2397756 | 2022-04-11 | Maricao | Puerto Rico | 72093 | 556 | |
2394501 | 2394501 | 2022-04-10 | Maricao | Puerto Rico | 72093 | 556 | |
2241403 | 2241403 | 2022-02-22 | Cimarron | Oklahoma | 40025 | 556 | 5 |
2238152 | 2238152 | 2022-02-21 | Cimarron | Oklahoma | 40025 | 556 | 5 |
2234901 | 2234901 | 2022-02-20 | Cimarron | Oklahoma | 40025 | 556 | 5 |
2231650 | 2231650 | 2022-02-19 | Cimarron | Oklahoma | 40025 | 556 | 5 |
2228399 | 2228399 | 2022-02-18 | Cimarron | Oklahoma | 40025 | 556 | 5 |
2225148 | 2225148 | 2022-02-17 | Cimarron | Oklahoma | 40025 | 556 | 5 |
2221897 | 2221897 | 2022-02-16 | Cimarron | Oklahoma | 40025 | 556 | 5 |
2214982 | 2214982 | 2022-02-14 | Sherman | Nebraska | 31163 | 556 | 4 |
2215723 | 2215723 | 2022-02-14 | Hand | South Dakota | 46059 | 556 | 8 |
2211730 | 2211730 | 2022-02-13 | Sherman | Nebraska | 31163 | 556 | 4 |
2212472 | 2212472 | 2022-02-13 | Hand | South Dakota | 46059 | 556 | 8 |
2208477 | 2208477 | 2022-02-12 | Sherman | Nebraska | 31163 | 556 | 4 |
2209219 | 2209219 | 2022-02-12 | Hand | South Dakota | 46059 | 556 | 8 |
2205224 | 2205224 | 2022-02-11 | Sherman | Nebraska | 31163 | 556 | 4 |
2205966 | 2205966 | 2022-02-11 | Hand | South Dakota | 46059 | 556 | 8 |
2201971 | 2201971 | 2022-02-10 | Sherman | Nebraska | 31163 | 556 | 4 |
2194632 | 2194632 | 2022-02-08 | Elk | Kansas | 20049 | 556 | 8 |
2191378 | 2191378 | 2022-02-07 | Elk | Kansas | 20049 | 556 | 8 |
2182724 | 2182724 | 2022-02-04 | Griggs | North Dakota | 38039 | 556 | 2 |
2179453 | 2179453 | 2022-02-03 | Adams | North Dakota | 38001 | 556 | 9 |
2111891 | 2111891 | 2022-01-13 | Kinney | Texas | 48271 | 556 | 10 |
2108395 | 2108395 | 2022-01-12 | Potter | South Dakota | 46107 | 556 | 5 |
2101407 | 2101407 | 2022-01-10 | McIntosh | North Dakota | 38051 | 556 | 9 |
2082040 | 2082040 | 2022-01-04 | Ellis | Oklahoma | 40045 | 556 | 6 |
2078788 | 2078788 | 2022-01-03 | Ellis | Oklahoma | 40045 | 556 | 6 |
2075537 | 2075537 | 2022-01-02 | Ellis | Oklahoma | 40045 | 556 | 6 |
2075738 | 2075738 | 2022-01-02 | Las Marias | Puerto Rico | 72083 | 556 | |
2072286 | 2072286 | 2022-01-01 | Ellis | Oklahoma | 40045 | 556 | 6 |
2069035 | 2069035 | 2021-12-31 | Ellis | Oklahoma | 40045 | 556 | 6 |
2065784 | 2065784 | 2021-12-30 | Ellis | Oklahoma | 40045 | 556 | 6 |
2062534 | 2062534 | 2021-12-29 | Ellis | Oklahoma | 40045 | 556 | 6 |
2039240 | 2039240 | 2021-12-22 | Fallon | Montana | 30025 | 556 | 10 |
2039639 | 2039639 | 2021-12-22 | Hettinger | North Dakota | 38041 | 556 | 7 |
2034434 | 2034434 | 2021-12-21 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 556 | 1 |
2035729 | 2035729 | 2021-12-21 | Lake of the Woods | Minnesota | 27077 | 556 | 5 |
2035990 | 2035990 | 2021-12-21 | Fallon | Montana | 30025 | 556 | 10 |
2036117 | 2036117 | 2021-12-21 | Stanton | Nebraska | 31167 | 556 | 11 |
2031184 | 2031184 | 2021-12-20 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 556 | 1 |
2032740 | 2032740 | 2021-12-20 | Fallon | Montana | 30025 | 556 | 10 |
2029489 | 2029489 | 2021-12-19 | Fallon | Montana | 30025 | 556 | 10 |
2026238 | 2026238 | 2021-12-18 | Fallon | Montana | 30025 | 556 | 10 |
2022987 | 2022987 | 2021-12-17 | Fallon | Montana | 30025 | 556 | 10 |
2018668 | 2018668 | 2021-12-16 | Adams | Idaho | 16003 | 556 | 14 |
2015418 | 2015418 | 2021-12-15 | Adams | Idaho | 16003 | 556 | 14 |
2012167 | 2012167 | 2021-12-14 | Adams | Idaho | 16003 | 556 | 14 |
2008916 | 2008916 | 2021-12-13 | Adams | Idaho | 16003 | 556 | 14 |
2005665 | 2005665 | 2021-12-12 | Adams | Idaho | 16003 | 556 | 14 |
2002414 | 2002414 | 2021-12-11 | Adams | Idaho | 16003 | 556 | 14 |
1999164 | 1999164 | 2021-12-10 | Adams | Idaho | 16003 | 556 | 14 |
1983325 | 1983325 | 2021-12-05 | Rawlins | Kansas | 20153 | 556 | 7 |
1980075 | 1980075 | 2021-12-04 | Rawlins | Kansas | 20153 | 556 | 7 |
1976825 | 1976825 | 2021-12-03 | Rawlins | Kansas | 20153 | 556 | 7 |
1971372 | 1971372 | 2021-12-01 | Eddy | North Dakota | 38027 | 556 | 6 |
1971837 | 1971837 | 2021-12-01 | Douglas | South Dakota | 46043 | 556 | 9 |
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);