ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
507 rows where cases = 920 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- South Dakota 36
- Kansas 28
- Kentucky 27
- Georgia 24
- Puerto Rico 23
- Virginia 23
- Delaware 22
- Idaho 21
- Missouri 21
- Texas 20
- Oklahoma 17
- Colorado 15
- Nebraska 15
- North Carolina 15
- Utah 15
- Minnesota 14
- Montana 14
- Iowa 13
- Michigan 12
- Louisiana 10
- Alabama 9
- Tennessee 9
- Wyoming 9
- Arkansas 8
- Mississippi 8
- North Dakota 8
- Ohio 8
- Wisconsin 7
- Illinois 6
- Indiana 6
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2366403 | 2366403 | 2022-04-02 | Unknown | Delaware | 920 | 0 | |
2363150 | 2363150 | 2022-04-01 | Unknown | Delaware | 920 | 0 | |
2359896 | 2359896 | 2022-03-31 | Unknown | Delaware | 920 | 0 | |
2353389 | 2353389 | 2022-03-29 | Unknown | Delaware | 920 | 0 | |
2350137 | 2350137 | 2022-03-28 | Unknown | Delaware | 920 | 0 | |
2346884 | 2346884 | 2022-03-27 | Unknown | Delaware | 920 | 0 | |
2343631 | 2343631 | 2022-03-26 | Unknown | Delaware | 920 | 0 | |
2340378 | 2340378 | 2022-03-25 | Unknown | Delaware | 920 | 0 | |
2337125 | 2337125 | 2022-03-24 | Unknown | Delaware | 920 | 0 | |
2333871 | 2333871 | 2022-03-23 | Unknown | Delaware | 920 | 0 | |
2327365 | 2327365 | 2022-03-21 | Unknown | Delaware | 920 | 0 | |
2329934 | 2329934 | 2022-03-21 | Garfield | Utah | 49017 | 920 | 14 |
2324112 | 2324112 | 2022-03-20 | Unknown | Delaware | 920 | 0 | |
2326682 | 2326682 | 2022-03-20 | Garfield | Utah | 49017 | 920 | 14 |
2323429 | 2323429 | 2022-03-19 | Garfield | Utah | 49017 | 920 | 14 |
2320175 | 2320175 | 2022-03-18 | Garfield | Utah | 49017 | 920 | 14 |
2316921 | 2316921 | 2022-03-17 | Garfield | Utah | 49017 | 920 | 14 |
2313668 | 2313668 | 2022-03-16 | Garfield | Utah | 49017 | 920 | 14 |
2310415 | 2310415 | 2022-03-15 | Garfield | Utah | 49017 | 920 | 14 |
2291586 | 2291586 | 2022-03-10 | Unknown | Delaware | 920 | 0 | |
2272072 | 2272072 | 2022-03-04 | Unknown | Delaware | 920 | 0 | |
2268820 | 2268820 | 2022-03-03 | Unknown | Delaware | 920 | 0 | |
2269060 | 2269060 | 2022-03-03 | Bear Lake | Idaho | 16007 | 920 | 15 |
2265567 | 2265567 | 2022-03-02 | Unknown | Delaware | 920 | 0 | |
2265807 | 2265807 | 2022-03-02 | Bear Lake | Idaho | 16007 | 920 | 15 |
2262316 | 2262316 | 2022-03-01 | Unknown | Delaware | 920 | 0 | |
2262556 | 2262556 | 2022-03-01 | Bear Lake | Idaho | 16007 | 920 | 15 |
2259065 | 2259065 | 2022-02-28 | Unknown | Delaware | 920 | 0 | |
2259305 | 2259305 | 2022-02-28 | Bear Lake | Idaho | 16007 | 920 | 15 |
2255762 | 2255762 | 2022-02-27 | Gilpin | Colorado | 8047 | 920 | 4 |
2255814 | 2255814 | 2022-02-27 | Unknown | Delaware | 920 | 0 | |
2256054 | 2256054 | 2022-02-27 | Bear Lake | Idaho | 16007 | 920 | 15 |
2252511 | 2252511 | 2022-02-26 | Gilpin | Colorado | 8047 | 920 | 4 |
2252563 | 2252563 | 2022-02-26 | Unknown | Delaware | 920 | 0 | |
2252803 | 2252803 | 2022-02-26 | Bear Lake | Idaho | 16007 | 920 | 15 |
2249260 | 2249260 | 2022-02-25 | Gilpin | Colorado | 8047 | 920 | 4 |
2249312 | 2249312 | 2022-02-25 | Unknown | Delaware | 920 | 0 | |
2249552 | 2249552 | 2022-02-25 | Bear Lake | Idaho | 16007 | 920 | 15 |
2246061 | 2246061 | 2022-02-24 | Unknown | Delaware | 920 | 0 | |
2246301 | 2246301 | 2022-02-24 | Bear Lake | Idaho | 16007 | 920 | 15 |
2243050 | 2243050 | 2022-02-23 | Bear Lake | Idaho | 16007 | 920 | 15 |
2239799 | 2239799 | 2022-02-22 | Bear Lake | Idaho | 16007 | 920 | 15 |
2236548 | 2236548 | 2022-02-21 | Bear Lake | Idaho | 16007 | 920 | 15 |
2233297 | 2233297 | 2022-02-20 | Bear Lake | Idaho | 16007 | 920 | 15 |
2230046 | 2230046 | 2022-02-19 | Bear Lake | Idaho | 16007 | 920 | 15 |
2226795 | 2226795 | 2022-02-18 | Bear Lake | Idaho | 16007 | 920 | 15 |
2202706 | 2202706 | 2022-02-10 | Edmunds | South Dakota | 46045 | 920 | 16 |
2197176 | 2197176 | 2022-02-09 | Modoc | California | 6049 | 920 | 6 |
2198741 | 2198741 | 2022-02-09 | Mineral | Nevada | 32021 | 920 | 15 |
2178125 | 2178125 | 2022-02-03 | Pope | Illinois | 17151 | 920 | 7 |
2174872 | 2174872 | 2022-02-02 | Pope | Illinois | 17151 | 920 | 7 |
2172964 | 2172964 | 2022-02-01 | Foster | North Dakota | 38031 | 920 | 20 |
2173900 | 2173900 | 2022-02-01 | Covington city | Virginia | 51580 | 920 | 21 |
2165371 | 2165371 | 2022-01-30 | Haskell | Kansas | 20081 | 920 | 11 |
2162116 | 2162116 | 2022-01-29 | Haskell | Kansas | 20081 | 920 | 11 |
2158861 | 2158861 | 2022-01-28 | Haskell | Kansas | 20081 | 920 | 11 |
2155570 | 2155570 | 2022-01-27 | Barber | Kansas | 20007 | 920 | 8 |
2152317 | 2152317 | 2022-01-26 | Barber | Kansas | 20007 | 920 | 8 |
2154108 | 2154108 | 2022-01-26 | Donley | Texas | 48129 | 920 | 20 |
2135070 | 2135070 | 2022-01-20 | Florence | Wisconsin | 55037 | 920 | 15 |
2130292 | 2130292 | 2022-01-19 | Phillips | Montana | 30071 | 920 | 28 |
2127447 | 2127447 | 2022-01-18 | Wells | North Dakota | 38103 | 920 | 11 |
2110118 | 2110118 | 2022-01-13 | Stafford | Kansas | 20185 | 920 | 24 |
2106867 | 2106867 | 2022-01-12 | Stafford | Kansas | 20185 | 920 | 24 |
2102720 | 2102720 | 2022-01-11 | Yukon-Koyukuk Census Area | Alaska | 2290 | 920 | 8 |
2103583 | 2103583 | 2022-01-11 | Meade | Kansas | 20119 | 920 | 15 |
2099469 | 2099469 | 2022-01-10 | Yukon-Koyukuk Census Area | Alaska | 2290 | 920 | 8 |
2100332 | 2100332 | 2022-01-10 | Meade | Kansas | 20119 | 920 | 15 |
2097867 | 2097867 | 2022-01-09 | Polk | Nebraska | 31143 | 920 | 18 |
2094615 | 2094615 | 2022-01-08 | Polk | Nebraska | 31143 | 920 | 18 |
2091363 | 2091363 | 2022-01-07 | Polk | Nebraska | 31143 | 920 | 18 |
2063327 | 2063327 | 2021-12-29 | Falls Church city | Virginia | 51610 | 920 | 14 |
2051570 | 2051570 | 2021-12-26 | Mitchell | Kansas | 20123 | 920 | 17 |
2048320 | 2048320 | 2021-12-25 | Mitchell | Kansas | 20123 | 920 | 17 |
2045070 | 2045070 | 2021-12-24 | Mitchell | Kansas | 20123 | 920 | 17 |
2041821 | 2041821 | 2021-12-23 | Mitchell | Kansas | 20123 | 920 | 17 |
2038571 | 2038571 | 2021-12-22 | Mitchell | Kansas | 20123 | 920 | 17 |
2008612 | 2008612 | 2021-12-13 | Clear Creek | Colorado | 8019 | 920 | 7 |
1997035 | 1997035 | 2021-12-09 | Burt | Nebraska | 31021 | 920 | 13 |
1985166 | 1985166 | 2021-12-05 | Presidio | Texas | 48377 | 920 | 28 |
1967835 | 1967835 | 2021-11-30 | Morrill | Nebraska | 31123 | 920 | 16 |
1907606 | 1907606 | 2021-11-12 | Choctaw | Alabama | 1023 | 920 | 28 |
1897776 | 1897776 | 2021-11-08 | Iron | Wisconsin | 55051 | 920 | 42 |
1880854 | 1880854 | 2021-11-03 | McCook | South Dakota | 46087 | 920 | 25 |
1876094 | 1876094 | 2021-11-02 | Wabaunsee | Kansas | 20197 | 920 | 18 |
1872845 | 1872845 | 2021-11-01 | Wabaunsee | Kansas | 20197 | 920 | 18 |
1859789 | 1859789 | 2021-10-28 | Harper | Kansas | 20077 | 920 | 20 |
1856540 | 1856540 | 2021-10-27 | Harper | Kansas | 20077 | 920 | 20 |
1854398 | 1854398 | 2021-10-26 | Ransom | North Dakota | 38073 | 920 | 19 |
1841748 | 1841748 | 2021-10-22 | Rincon | Puerto Rico | 72117 | 920 | |
1838499 | 1838499 | 2021-10-21 | Rincon | Puerto Rico | 72117 | 920 | |
1834455 | 1834455 | 2021-10-20 | Shelby | Missouri | 29205 | 920 | 9 |
1835250 | 1835250 | 2021-10-20 | Rincon | Puerto Rico | 72117 | 920 | |
1830896 | 1830896 | 2021-10-19 | Lake | Michigan | 26085 | 920 | 20 |
1831794 | 1831794 | 2021-10-19 | Jefferson | Oklahoma | 40067 | 920 | 18 |
1832001 | 1832001 | 2021-10-19 | Rincon | Puerto Rico | 72117 | 920 | |
1827647 | 1827647 | 2021-10-18 | Lake | Michigan | 26085 | 920 | 20 |
1828545 | 1828545 | 2021-10-18 | Jefferson | Oklahoma | 40067 | 920 | 18 |
1828752 | 1828752 | 2021-10-18 | Rincon | Puerto Rico | 72117 | 920 | |
1829252 | 1829252 | 2021-10-18 | Kane | Utah | 49025 | 920 | 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);