ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
586 rows where cases = 788 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- South Dakota 53
- Texas 50
- Georgia 37
- Iowa 32
- Kansas 30
- Virginia 28
- Mississippi 27
- Oklahoma 23
- Montana 21
- Nebraska 21
- Illinois 19
- Puerto Rico 18
- Kentucky 17
- Tennessee 17
- North Carolina 14
- Alaska 12
- Arkansas 12
- Colorado 12
- Michigan 12
- Minnesota 12
- Missouri 10
- Ohio 10
- West Virginia 10
- Wisconsin 10
- Alabama 7
- Indiana 7
- Washington 7
- Idaho 6
- Louisiana 6
- Pennsylvania 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500517 | 2500517 | 2022-05-13 | Jewell | Kansas | 20089 | 788 | 13 |
2497259 | 2497259 | 2022-05-12 | Jewell | Kansas | 20089 | 788 | 13 |
2494001 | 2494001 | 2022-05-11 | Jewell | Kansas | 20089 | 788 | 13 |
2490743 | 2490743 | 2022-05-10 | Jewell | Kansas | 20089 | 788 | 13 |
2492273 | 2492273 | 2022-05-10 | Bennett | South Dakota | 46007 | 788 | 14 |
2487486 | 2487486 | 2022-05-09 | Jewell | Kansas | 20089 | 788 | 13 |
2489015 | 2489015 | 2022-05-09 | Bennett | South Dakota | 46007 | 788 | 14 |
2484228 | 2484228 | 2022-05-08 | Jewell | Kansas | 20089 | 788 | 13 |
2485758 | 2485758 | 2022-05-08 | Bennett | South Dakota | 46007 | 788 | 14 |
2480970 | 2480970 | 2022-05-07 | Jewell | Kansas | 20089 | 788 | 13 |
2482500 | 2482500 | 2022-05-07 | Bennett | South Dakota | 46007 | 788 | 14 |
2477712 | 2477712 | 2022-05-06 | Jewell | Kansas | 20089 | 788 | 13 |
2479242 | 2479242 | 2022-05-06 | Bennett | South Dakota | 46007 | 788 | 14 |
2475984 | 2475984 | 2022-05-05 | Bennett | South Dakota | 46007 | 788 | 14 |
2472727 | 2472727 | 2022-05-04 | Bennett | South Dakota | 46007 | 788 | 14 |
2469471 | 2469471 | 2022-05-03 | Bennett | South Dakota | 46007 | 788 | 14 |
2469511 | 2469511 | 2022-05-03 | Marshall | South Dakota | 46091 | 788 | 13 |
2466215 | 2466215 | 2022-05-02 | Bennett | South Dakota | 46007 | 788 | 14 |
2466255 | 2466255 | 2022-05-02 | Marshall | South Dakota | 46091 | 788 | 13 |
2462960 | 2462960 | 2022-05-01 | Bennett | South Dakota | 46007 | 788 | 14 |
2463000 | 2463000 | 2022-05-01 | Marshall | South Dakota | 46091 | 788 | 13 |
2459704 | 2459704 | 2022-04-30 | Bennett | South Dakota | 46007 | 788 | 14 |
2459744 | 2459744 | 2022-04-30 | Marshall | South Dakota | 46091 | 788 | 13 |
2456448 | 2456448 | 2022-04-29 | Bennett | South Dakota | 46007 | 788 | 14 |
2456488 | 2456488 | 2022-04-29 | Marshall | South Dakota | 46091 | 788 | 13 |
2453192 | 2453192 | 2022-04-28 | Bennett | South Dakota | 46007 | 788 | 14 |
2453232 | 2453232 | 2022-04-28 | Marshall | South Dakota | 46091 | 788 | 13 |
2449936 | 2449936 | 2022-04-27 | Bennett | South Dakota | 46007 | 788 | 14 |
2449976 | 2449976 | 2022-04-27 | Marshall | South Dakota | 46091 | 788 | 13 |
2446679 | 2446679 | 2022-04-26 | Bennett | South Dakota | 46007 | 788 | 14 |
2443424 | 2443424 | 2022-04-25 | Bennett | South Dakota | 46007 | 788 | 14 |
2440168 | 2440168 | 2022-04-24 | Bennett | South Dakota | 46007 | 788 | 14 |
2436912 | 2436912 | 2022-04-23 | Bennett | South Dakota | 46007 | 788 | 14 |
2433656 | 2433656 | 2022-04-22 | Bennett | South Dakota | 46007 | 788 | 14 |
2430400 | 2430400 | 2022-04-21 | Bennett | South Dakota | 46007 | 788 | 14 |
2427144 | 2427144 | 2022-04-20 | Bennett | South Dakota | 46007 | 788 | 14 |
2423888 | 2423888 | 2022-04-19 | Bennett | South Dakota | 46007 | 788 | 14 |
2420632 | 2420632 | 2022-04-18 | Bennett | South Dakota | 46007 | 788 | 14 |
2417376 | 2417376 | 2022-04-17 | Bennett | South Dakota | 46007 | 788 | 14 |
2414120 | 2414120 | 2022-04-16 | Bennett | South Dakota | 46007 | 788 | 14 |
2410864 | 2410864 | 2022-04-15 | Bennett | South Dakota | 46007 | 788 | 14 |
2407608 | 2407608 | 2022-04-14 | Bennett | South Dakota | 46007 | 788 | 14 |
2404352 | 2404352 | 2022-04-13 | Bennett | South Dakota | 46007 | 788 | 14 |
2401097 | 2401097 | 2022-04-12 | Bennett | South Dakota | 46007 | 788 | 14 |
2397842 | 2397842 | 2022-04-11 | Bennett | South Dakota | 46007 | 788 | 14 |
2394587 | 2394587 | 2022-04-10 | Bennett | South Dakota | 46007 | 788 | 14 |
2391331 | 2391331 | 2022-04-09 | Bennett | South Dakota | 46007 | 788 | 14 |
2388075 | 2388075 | 2022-04-08 | Bennett | South Dakota | 46007 | 788 | 14 |
2384820 | 2384820 | 2022-04-07 | Bennett | South Dakota | 46007 | 788 | 14 |
2381565 | 2381565 | 2022-04-06 | Bennett | South Dakota | 46007 | 788 | 14 |
2262066 | 2262066 | 2022-03-01 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 788 | 1 |
2262995 | 2262995 | 2022-03-01 | Woodson | Kansas | 20207 | 788 | 12 |
2258815 | 2258815 | 2022-02-28 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 788 | 1 |
2259744 | 2259744 | 2022-02-28 | Woodson | Kansas | 20207 | 788 | 12 |
2256460 | 2256460 | 2022-02-27 | Osborne | Kansas | 20141 | 788 | 16 |
2256493 | 2256493 | 2022-02-27 | Woodson | Kansas | 20207 | 788 | 12 |
2253209 | 2253209 | 2022-02-26 | Osborne | Kansas | 20141 | 788 | 16 |
2253242 | 2253242 | 2022-02-26 | Woodson | Kansas | 20207 | 788 | 12 |
2249958 | 2249958 | 2022-02-25 | Osborne | Kansas | 20141 | 788 | 16 |
2249991 | 2249991 | 2022-02-25 | Woodson | Kansas | 20207 | 788 | 12 |
2202235 | 2202235 | 2022-02-10 | Cavalier | North Dakota | 38019 | 788 | 7 |
2203039 | 2203039 | 2022-02-10 | Real | Texas | 48385 | 788 | 24 |
2198370 | 2198370 | 2022-02-09 | Traverse | Minnesota | 27155 | 788 | 9 |
2195990 | 2195990 | 2022-02-08 | Cameron | Pennsylvania | 42023 | 788 | 19 |
2193096 | 2193096 | 2022-02-07 | Baylor | Texas | 48023 | 788 | 28 |
2189842 | 2189842 | 2022-02-06 | Baylor | Texas | 48023 | 788 | 28 |
2186589 | 2186589 | 2022-02-05 | Baylor | Texas | 48023 | 788 | 28 |
2177537 | 2177537 | 2022-02-03 | Unknown | Alaska | 788 | 1 | |
2174284 | 2174284 | 2022-02-02 | Unknown | Alaska | 788 | 1 | |
2154335 | 2154335 | 2022-01-26 | Grand Isle | Vermont | 50013 | 788 | 4 |
2150321 | 2150321 | 2022-01-25 | Beaver | Oklahoma | 40007 | 788 | 10 |
2147069 | 2147069 | 2022-01-24 | Beaver | Oklahoma | 40007 | 788 | 10 |
2143815 | 2143815 | 2022-01-23 | Beaver | Oklahoma | 40007 | 788 | 10 |
2140560 | 2140560 | 2022-01-22 | Beaver | Oklahoma | 40007 | 788 | 10 |
2137304 | 2137304 | 2022-01-21 | Beaver | Oklahoma | 40007 | 788 | 10 |
2134050 | 2134050 | 2022-01-20 | Beaver | Oklahoma | 40007 | 788 | 10 |
2130637 | 2130637 | 2022-01-19 | Tyrrell | North Carolina | 37177 | 788 | 7 |
2130798 | 2130798 | 2022-01-19 | Beaver | Oklahoma | 40007 | 788 | 10 |
2125828 | 2125828 | 2022-01-18 | Echols | Georgia | 13101 | 788 | 11 |
2106899 | 2106899 | 2022-01-12 | Carlisle | Kentucky | 21039 | 788 | 14 |
2102948 | 2102948 | 2022-01-11 | Unknown | Delaware | 788 | 0 | |
2104272 | 2104272 | 2022-01-11 | Mineral | Montana | 30061 | 788 | 14 |
2102407 | 2102407 | 2022-01-10 | Rappahannock | Virginia | 51157 | 788 | 7 |
2097844 | 2097844 | 2022-01-09 | Johnson | Nebraska | 31097 | 788 | 10 |
2094592 | 2094592 | 2022-01-08 | Johnson | Nebraska | 31097 | 788 | 10 |
2091340 | 2091340 | 2022-01-07 | Johnson | Nebraska | 31097 | 788 | 10 |
2089327 | 2089327 | 2022-01-06 | Craig | Virginia | 51045 | 788 | 11 |
2040562 | 2040562 | 2021-12-22 | Charles City | Virginia | 51036 | 788 | 22 |
2035985 | 2035985 | 2021-12-21 | Chouteau | Montana | 30015 | 788 | 9 |
2032735 | 2032735 | 2021-12-20 | Chouteau | Montana | 30015 | 788 | 9 |
2029484 | 2029484 | 2021-12-19 | Chouteau | Montana | 30015 | 788 | 9 |
2026233 | 2026233 | 2021-12-18 | Chouteau | Montana | 30015 | 788 | 9 |
2022982 | 2022982 | 2021-12-17 | Chouteau | Montana | 30015 | 788 | 9 |
2019731 | 2019731 | 2021-12-16 | Chouteau | Montana | 30015 | 788 | 9 |
2016481 | 2016481 | 2021-12-15 | Chouteau | Montana | 30015 | 788 | 9 |
2017253 | 2017253 | 2021-12-15 | Sabana Grande | Puerto Rico | 72121 | 788 | |
1991032 | 1991032 | 2021-12-07 | Greer | Oklahoma | 40055 | 788 | 26 |
1987781 | 1987781 | 2021-12-06 | Greer | Oklahoma | 40055 | 788 | 26 |
1984531 | 1984531 | 2021-12-05 | Greer | Oklahoma | 40055 | 788 | 26 |
1985266 | 1985266 | 2021-12-05 | Essex | Vermont | 50009 | 788 | 2 |
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);