ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
446 rows where cases = 976 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Nebraska 37
- Georgia 35
- Texas 33
- Missouri 24
- Kansas 22
- Oklahoma 22
- Mississippi 18
- Puerto Rico 18
- Minnesota 16
- Montana 15
- Arkansas 13
- Kentucky 12
- Michigan 11
- North Dakota 11
- Pennsylvania 11
- Virginia 11
- Tennessee 10
- Indiana 9
- Utah 9
- Colorado 8
- Iowa 7
- Louisiana 7
- North Carolina 7
- Ohio 7
- Oregon 6
- South Dakota 6
- Wisconsin 6
- New Mexico 5
- Vermont 5
- West Virginia 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2498055 | 2498055 | 2022-05-12 | Nuckolls | Nebraska | 31129 | 976 | 13 |
2494797 | 2494797 | 2022-05-11 | Nuckolls | Nebraska | 31129 | 976 | 13 |
2442690 | 2442690 | 2022-04-25 | Nuckolls | Nebraska | 31129 | 976 | 13 |
2439434 | 2439434 | 2022-04-24 | Nuckolls | Nebraska | 31129 | 976 | 13 |
2436178 | 2436178 | 2022-04-23 | Nuckolls | Nebraska | 31129 | 976 | 13 |
2432922 | 2432922 | 2022-04-22 | Nuckolls | Nebraska | 31129 | 976 | 13 |
2429666 | 2429666 | 2022-04-21 | Nuckolls | Nebraska | 31129 | 976 | 13 |
2426410 | 2426410 | 2022-04-20 | Nuckolls | Nebraska | 31129 | 976 | 13 |
2423154 | 2423154 | 2022-04-19 | Nuckolls | Nebraska | 31129 | 976 | 13 |
2419897 | 2419897 | 2022-04-18 | Nuckolls | Nebraska | 31129 | 976 | 13 |
2416642 | 2416642 | 2022-04-17 | Nuckolls | Nebraska | 31129 | 976 | 13 |
2413386 | 2413386 | 2022-04-16 | Nuckolls | Nebraska | 31129 | 976 | 13 |
2410130 | 2410130 | 2022-04-15 | Nuckolls | Nebraska | 31129 | 976 | 13 |
2406874 | 2406874 | 2022-04-14 | Nuckolls | Nebraska | 31129 | 976 | 13 |
2403618 | 2403618 | 2022-04-13 | Nuckolls | Nebraska | 31129 | 976 | 13 |
2354620 | 2354620 | 2022-03-29 | Knox | Missouri | 29103 | 976 | 13 |
2348299 | 2348299 | 2022-03-27 | Nuckolls | Nebraska | 31129 | 976 | 13 |
2345046 | 2345046 | 2022-03-26 | Nuckolls | Nebraska | 31129 | 976 | 13 |
2341793 | 2341793 | 2022-03-25 | Nuckolls | Nebraska | 31129 | 976 | 13 |
2342874 | 2342874 | 2022-03-25 | Presidio | Texas | 48377 | 976 | 36 |
2338540 | 2338540 | 2022-03-24 | Nuckolls | Nebraska | 31129 | 976 | 13 |
2302644 | 2302644 | 2022-03-13 | Chouteau | Montana | 30015 | 976 | 14 |
2299392 | 2299392 | 2022-03-12 | Chouteau | Montana | 30015 | 976 | 14 |
2296140 | 2296140 | 2022-03-11 | Chouteau | Montana | 30015 | 976 | 14 |
2292888 | 2292888 | 2022-03-10 | Chouteau | Montana | 30015 | 976 | 14 |
2289636 | 2289636 | 2022-03-09 | Chouteau | Montana | 30015 | 976 | 14 |
2265457 | 2265457 | 2022-03-02 | Modoc | California | 6049 | 976 | 7 |
2267268 | 2267268 | 2022-03-02 | Foster | North Dakota | 38031 | 976 | 22 |
2263580 | 2263580 | 2022-03-01 | Putnam | Missouri | 29171 | 976 | 22 |
2264016 | 2264016 | 2022-03-01 | Foster | North Dakota | 38031 | 976 | 22 |
2260772 | 2260772 | 2022-02-28 | LaMoure | North Dakota | 38045 | 976 | 19 |
2257521 | 2257521 | 2022-02-27 | LaMoure | North Dakota | 38045 | 976 | 19 |
2254270 | 2254270 | 2022-02-26 | LaMoure | North Dakota | 38045 | 976 | 19 |
2247325 | 2247325 | 2022-02-24 | Putnam | Missouri | 29171 | 976 | 22 |
2244510 | 2244510 | 2022-02-23 | Foster | North Dakota | 38031 | 976 | 22 |
2218327 | 2218327 | 2022-02-15 | Union | New Mexico | 35059 | 976 | 12 |
2176242 | 2176242 | 2022-02-02 | Sargent | North Dakota | 38081 | 976 | 9 |
2172961 | 2172961 | 2022-02-01 | Dunn | North Dakota | 38025 | 976 | 8 |
2153740 | 2153740 | 2022-01-26 | Sullivan | Pennsylvania | 42113 | 976 | 32 |
2154091 | 2154091 | 2022-01-26 | Concho | Texas | 48095 | 976 | 10 |
2154593 | 2154593 | 2022-01-26 | Florence | Wisconsin | 55037 | 976 | 15 |
2150205 | 2150205 | 2022-01-25 | Pierce | North Dakota | 38069 | 976 | 30 |
2134810 | 2134810 | 2022-01-20 | Essex | Vermont | 50009 | 976 | 3 |
2131558 | 2131558 | 2022-01-19 | Essex | Vermont | 50009 | 976 | 3 |
2122545 | 2122545 | 2022-01-17 | Calhoun | Georgia | 13037 | 976 | 22 |
2111083 | 2111083 | 2022-01-13 | Hyde | North Carolina | 37095 | 976 | 13 |
2104359 | 2104359 | 2022-01-11 | Morrill | Nebraska | 31123 | 976 | 17 |
2100007 | 2100007 | 2022-01-10 | Gallatin | Illinois | 17059 | 976 | 11 |
2084838 | 2084838 | 2022-01-05 | Kearney | Nebraska | 31099 | 976 | 7 |
2084943 | 2084943 | 2022-01-05 | Guadalupe | New Mexico | 35019 | 976 | 15 |
2082051 | 2082051 | 2022-01-04 | Jefferson | Oklahoma | 40067 | 976 | 20 |
2078295 | 2078295 | 2022-01-03 | Burt | Nebraska | 31021 | 976 | 13 |
2078799 | 2078799 | 2022-01-03 | Jefferson | Oklahoma | 40067 | 976 | 20 |
2075548 | 2075548 | 2022-01-02 | Jefferson | Oklahoma | 40067 | 976 | 20 |
2072297 | 2072297 | 2022-01-01 | Jefferson | Oklahoma | 40067 | 976 | 20 |
2069046 | 2069046 | 2021-12-31 | Jefferson | Oklahoma | 40067 | 976 | 20 |
2065795 | 2065795 | 2021-12-30 | Jefferson | Oklahoma | 40067 | 976 | 20 |
2062545 | 2062545 | 2021-12-29 | Jefferson | Oklahoma | 40067 | 976 | 20 |
2059623 | 2059623 | 2021-12-28 | Moody | South Dakota | 46101 | 976 | 25 |
2040341 | 2040341 | 2021-12-22 | Hartley | Texas | 48205 | 976 | 2 |
2035125 | 2035125 | 2021-12-21 | Ohio | Indiana | 18115 | 976 | 14 |
2036548 | 2036548 | 2021-12-21 | Jefferson | Oklahoma | 40067 | 976 | 20 |
2032853 | 2032853 | 2021-12-20 | Pierce | Nebraska | 31139 | 976 | 21 |
2033298 | 2033298 | 2021-12-20 | Jefferson | Oklahoma | 40067 | 976 | 20 |
2033940 | 2033940 | 2021-12-20 | Sabine | Texas | 48403 | 976 | 77 |
2028837 | 2028837 | 2021-12-19 | Republic | Kansas | 20157 | 976 | 14 |
2029309 | 2029309 | 2021-12-19 | Jefferson | Mississippi | 28063 | 976 | 34 |
2030048 | 2030048 | 2021-12-19 | Jefferson | Oklahoma | 40067 | 976 | 20 |
2030540 | 2030540 | 2021-12-19 | Crane | Texas | 48103 | 976 | 19 |
2025586 | 2025586 | 2021-12-18 | Republic | Kansas | 20157 | 976 | 14 |
2026058 | 2026058 | 2021-12-18 | Jefferson | Mississippi | 28063 | 976 | 34 |
2026797 | 2026797 | 2021-12-18 | Jefferson | Oklahoma | 40067 | 976 | 20 |
2027289 | 2027289 | 2021-12-18 | Crane | Texas | 48103 | 976 | 19 |
2022335 | 2022335 | 2021-12-17 | Republic | Kansas | 20157 | 976 | 14 |
2022807 | 2022807 | 2021-12-17 | Jefferson | Mississippi | 28063 | 976 | 34 |
2023546 | 2023546 | 2021-12-17 | Jefferson | Oklahoma | 40067 | 976 | 20 |
2019849 | 2019849 | 2021-12-16 | Pierce | Nebraska | 31139 | 976 | 21 |
2020295 | 2020295 | 2021-12-16 | Jefferson | Oklahoma | 40067 | 976 | 20 |
2017044 | 2017044 | 2021-12-15 | Jefferson | Oklahoma | 40067 | 976 | 20 |
2006439 | 2006439 | 2021-12-12 | Big Stone | Minnesota | 27011 | 976 | 6 |
2006824 | 2006824 | 2021-12-12 | Jefferson | Nebraska | 31095 | 976 | 3 |
2003188 | 2003188 | 2021-12-11 | Big Stone | Minnesota | 27011 | 976 | 6 |
2003573 | 2003573 | 2021-12-11 | Jefferson | Nebraska | 31095 | 976 | 3 |
1999938 | 1999938 | 2021-12-10 | Big Stone | Minnesota | 27011 | 976 | 6 |
2000323 | 2000323 | 2021-12-10 | Jefferson | Nebraska | 31095 | 976 | 3 |
1994574 | 1994574 | 2021-12-08 | Brule | South Dakota | 46015 | 976 | 14 |
1983970 | 1983970 | 2021-12-05 | Broadwater | Montana | 30007 | 976 | 17 |
1980720 | 1980720 | 2021-12-04 | Broadwater | Montana | 30007 | 976 | 17 |
1977470 | 1977470 | 2021-12-03 | Broadwater | Montana | 30007 | 976 | 17 |
1960570 | 1960570 | 2021-11-28 | Phillips | Kansas | 20147 | 976 | 28 |
1957319 | 1957319 | 2021-11-27 | Phillips | Kansas | 20147 | 976 | 28 |
1954068 | 1954068 | 2021-11-26 | Phillips | Kansas | 20147 | 976 | 28 |
1950817 | 1950817 | 2021-11-25 | Phillips | Kansas | 20147 | 976 | 28 |
1951889 | 1951889 | 2021-11-25 | Ransom | North Dakota | 38073 | 976 | 21 |
1947566 | 1947566 | 2021-11-24 | Phillips | Kansas | 20147 | 976 | 28 |
1929985 | 1929985 | 2021-11-18 | Kane | Utah | 49025 | 976 | 12 |
1919032 | 1919032 | 2021-11-15 | Clay | Nebraska | 31035 | 976 | 17 |
1904832 | 1904832 | 2021-11-11 | Marion | Georgia | 13197 | 976 | 39 |
1901582 | 1901582 | 2021-11-10 | Marion | Georgia | 13197 | 976 | 39 |
1898332 | 1898332 | 2021-11-09 | Marion | Georgia | 13197 | 976 | 39 |
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);