ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
510 rows where cases = 753 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kansas 57
- Nebraska 41
- Texas 28
- Georgia 24
- Virginia 24
- Arkansas 20
- North Carolina 20
- Iowa 19
- Tennessee 19
- Virgin Islands 15
- West Virginia 15
- Kentucky 14
- Michigan 14
- Minnesota 14
- Indiana 13
- Missouri 13
- Colorado 12
- North Dakota 12
- Montana 10
- Wisconsin 10
- Alabama 9
- South Dakota 9
- Illinois 8
- Louisiana 8
- Mississippi 8
- Rhode Island 7
- Pennsylvania 6
- Alaska 5
- Florida 5
- Idaho 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2491563 | 2491563 | 2022-05-10 | Valley | Nebraska | 31175 | 753 | 6 |
2488305 | 2488305 | 2022-05-09 | Valley | Nebraska | 31175 | 753 | 6 |
2485048 | 2485048 | 2022-05-08 | Valley | Nebraska | 31175 | 753 | 6 |
2481790 | 2481790 | 2022-05-07 | Valley | Nebraska | 31175 | 753 | 6 |
2478532 | 2478532 | 2022-05-06 | Valley | Nebraska | 31175 | 753 | 6 |
2475274 | 2475274 | 2022-05-05 | Valley | Nebraska | 31175 | 753 | 6 |
2451715 | 2451715 | 2022-04-28 | Trego | Kansas | 20195 | 753 | 10 |
2448459 | 2448459 | 2022-04-27 | Trego | Kansas | 20195 | 753 | 10 |
2445203 | 2445203 | 2022-04-26 | Trego | Kansas | 20195 | 753 | 10 |
2441947 | 2441947 | 2022-04-25 | Trego | Kansas | 20195 | 753 | 10 |
2438691 | 2438691 | 2022-04-24 | Trego | Kansas | 20195 | 753 | 10 |
2435435 | 2435435 | 2022-04-23 | Trego | Kansas | 20195 | 753 | 10 |
2432179 | 2432179 | 2022-04-22 | Trego | Kansas | 20195 | 753 | 10 |
2428923 | 2428923 | 2022-04-21 | Trego | Kansas | 20195 | 753 | 10 |
2425667 | 2425667 | 2022-04-20 | Trego | Kansas | 20195 | 753 | 10 |
2422411 | 2422411 | 2022-04-19 | Trego | Kansas | 20195 | 753 | 10 |
2419155 | 2419155 | 2022-04-18 | Trego | Kansas | 20195 | 753 | 10 |
2419921 | 2419921 | 2022-04-18 | Valley | Nebraska | 31175 | 753 | 6 |
2415899 | 2415899 | 2022-04-17 | Trego | Kansas | 20195 | 753 | 10 |
2416666 | 2416666 | 2022-04-17 | Valley | Nebraska | 31175 | 753 | 6 |
2412643 | 2412643 | 2022-04-16 | Trego | Kansas | 20195 | 753 | 10 |
2413410 | 2413410 | 2022-04-16 | Valley | Nebraska | 31175 | 753 | 6 |
2409387 | 2409387 | 2022-04-15 | Trego | Kansas | 20195 | 753 | 10 |
2410154 | 2410154 | 2022-04-15 | Valley | Nebraska | 31175 | 753 | 6 |
2406131 | 2406131 | 2022-04-14 | Trego | Kansas | 20195 | 753 | 10 |
2406898 | 2406898 | 2022-04-14 | Valley | Nebraska | 31175 | 753 | 6 |
2402875 | 2402875 | 2022-04-13 | Trego | Kansas | 20195 | 753 | 10 |
2403642 | 2403642 | 2022-04-13 | Valley | Nebraska | 31175 | 753 | 6 |
2399621 | 2399621 | 2022-04-12 | Trego | Kansas | 20195 | 753 | 10 |
2400387 | 2400387 | 2022-04-12 | Valley | Nebraska | 31175 | 753 | 6 |
2396365 | 2396365 | 2022-04-11 | Trego | Kansas | 20195 | 753 | 10 |
2397132 | 2397132 | 2022-04-11 | Valley | Nebraska | 31175 | 753 | 6 |
2393110 | 2393110 | 2022-04-10 | Trego | Kansas | 20195 | 753 | 10 |
2393877 | 2393877 | 2022-04-10 | Valley | Nebraska | 31175 | 753 | 6 |
2389854 | 2389854 | 2022-04-09 | Trego | Kansas | 20195 | 753 | 10 |
2390621 | 2390621 | 2022-04-09 | Valley | Nebraska | 31175 | 753 | 6 |
2386598 | 2386598 | 2022-04-08 | Trego | Kansas | 20195 | 753 | 10 |
2387365 | 2387365 | 2022-04-08 | Valley | Nebraska | 31175 | 753 | 6 |
2383344 | 2383344 | 2022-04-07 | Trego | Kansas | 20195 | 753 | 10 |
2384110 | 2384110 | 2022-04-07 | Valley | Nebraska | 31175 | 753 | 6 |
2380089 | 2380089 | 2022-04-06 | Trego | Kansas | 20195 | 753 | 10 |
2380855 | 2380855 | 2022-04-06 | Valley | Nebraska | 31175 | 753 | 6 |
2376834 | 2376834 | 2022-04-05 | Trego | Kansas | 20195 | 753 | 10 |
2377600 | 2377600 | 2022-04-05 | Valley | Nebraska | 31175 | 753 | 6 |
2373582 | 2373582 | 2022-04-04 | Trego | Kansas | 20195 | 753 | 10 |
2374347 | 2374347 | 2022-04-04 | Valley | Nebraska | 31175 | 753 | 6 |
2370329 | 2370329 | 2022-04-03 | Trego | Kansas | 20195 | 753 | 10 |
2371095 | 2371095 | 2022-04-03 | Valley | Nebraska | 31175 | 753 | 6 |
2367076 | 2367076 | 2022-04-02 | Trego | Kansas | 20195 | 753 | 10 |
2367842 | 2367842 | 2022-04-02 | Valley | Nebraska | 31175 | 753 | 6 |
2363823 | 2363823 | 2022-04-01 | Trego | Kansas | 20195 | 753 | 10 |
2364589 | 2364589 | 2022-04-01 | Valley | Nebraska | 31175 | 753 | 6 |
2361335 | 2361335 | 2022-03-31 | Valley | Nebraska | 31175 | 753 | 6 |
2354062 | 2354062 | 2022-03-29 | Trego | Kansas | 20195 | 753 | 10 |
2350810 | 2350810 | 2022-03-28 | Trego | Kansas | 20195 | 753 | 10 |
2347557 | 2347557 | 2022-03-27 | Trego | Kansas | 20195 | 753 | 10 |
2344304 | 2344304 | 2022-03-26 | Trego | Kansas | 20195 | 753 | 10 |
2341051 | 2341051 | 2022-03-25 | Trego | Kansas | 20195 | 753 | 10 |
2306106 | 2306106 | 2022-03-14 | Mora | New Mexico | 35033 | 753 | 16 |
2290941 | 2290941 | 2022-03-09 | St. John | Virgin Islands | 78020 | 753 | 5 |
2287689 | 2287689 | 2022-03-08 | St. John | Virgin Islands | 78020 | 753 | 5 |
2284437 | 2284437 | 2022-03-07 | St. John | Virgin Islands | 78020 | 753 | 5 |
2281185 | 2281185 | 2022-03-06 | St. John | Virgin Islands | 78020 | 753 | 5 |
2277932 | 2277932 | 2022-03-05 | St. John | Virgin Islands | 78020 | 753 | 5 |
2274679 | 2274679 | 2022-03-04 | St. John | Virgin Islands | 78020 | 753 | 5 |
2269865 | 2269865 | 2022-03-03 | Lake of the Woods | Minnesota | 27077 | 753 | 6 |
2271426 | 2271426 | 2022-03-03 | St. John | Virgin Islands | 78020 | 753 | 5 |
2266612 | 2266612 | 2022-03-02 | Lake of the Woods | Minnesota | 27077 | 753 | 6 |
2268174 | 2268174 | 2022-03-02 | St. John | Virgin Islands | 78020 | 753 | 5 |
2263361 | 2263361 | 2022-03-01 | Lake of the Woods | Minnesota | 27077 | 753 | 6 |
2264921 | 2264921 | 2022-03-01 | St. John | Virgin Islands | 78020 | 753 | 5 |
2261671 | 2261671 | 2022-02-28 | St. John | Virgin Islands | 78020 | 753 | 5 |
2258420 | 2258420 | 2022-02-27 | St. John | Virgin Islands | 78020 | 753 | 5 |
2255169 | 2255169 | 2022-02-26 | St. John | Virgin Islands | 78020 | 753 | 5 |
2251918 | 2251918 | 2022-02-25 | St. John | Virgin Islands | 78020 | 753 | 5 |
2247759 | 2247759 | 2022-02-24 | Eddy | North Dakota | 38027 | 753 | 6 |
2248667 | 2248667 | 2022-02-24 | St. John | Virgin Islands | 78020 | 753 | 5 |
2241257 | 2241257 | 2022-02-22 | Eddy | North Dakota | 38027 | 753 | 6 |
2211641 | 2211641 | 2022-02-13 | Sweet Grass | Montana | 30097 | 753 | 8 |
2208388 | 2208388 | 2022-02-12 | Sweet Grass | Montana | 30097 | 753 | 8 |
2205135 | 2205135 | 2022-02-11 | Sweet Grass | Montana | 30097 | 753 | 8 |
2187274 | 2187274 | 2022-02-06 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 753 | 1 |
2184021 | 2184021 | 2022-02-05 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 753 | 1 |
2180769 | 2180769 | 2022-02-04 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 753 | 1 |
2178415 | 2178415 | 2022-02-03 | Osborne | Kansas | 20141 | 753 | 16 |
2175162 | 2175162 | 2022-02-02 | Osborne | Kansas | 20141 | 753 | 16 |
2156696 | 2156696 | 2022-01-27 | Hettinger | North Dakota | 38041 | 753 | 7 |
2154055 | 2154055 | 2022-01-26 | Baylor | Texas | 48023 | 753 | 28 |
2150803 | 2150803 | 2022-01-25 | Baylor | Texas | 48023 | 753 | 27 |
2128933 | 2128933 | 2022-01-19 | Ouray | Colorado | 8091 | 753 | 6 |
2128055 | 2128055 | 2022-01-18 | Coke | Texas | 48081 | 753 | 18 |
2128118 | 2128118 | 2022-01-18 | Haskell | Texas | 48207 | 753 | 37 |
2105112 | 2105112 | 2022-01-11 | Edmunds | South Dakota | 46045 | 753 | 14 |
2084892 | 2084892 | 2022-01-05 | Lincoln | Nevada | 32017 | 753 | 5 |
2033591 | 2033591 | 2021-12-20 | Corson | South Dakota | 46031 | 753 | 15 |
2020168 | 2020168 | 2021-12-16 | Wells | North Dakota | 38103 | 753 | 11 |
2006825 | 2006825 | 2021-12-12 | Johnson | Nebraska | 31097 | 753 | 10 |
2003574 | 2003574 | 2021-12-11 | Johnson | Nebraska | 31097 | 753 | 10 |
2000324 | 2000324 | 2021-12-10 | Johnson | Nebraska | 31097 | 753 | 10 |
1990881 | 1990881 | 2021-12-07 | LaMoure | North Dakota | 38045 | 753 | 17 |
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);