ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
314 rows where cases = 2003 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 26
- Iowa 23
- Georgia 19
- Arkansas 15
- Oklahoma 15
- Illinois 13
- Nebraska 12
- Florida 11
- Kentucky 11
- Missouri 11
- Tennessee 11
- Kansas 9
- New Mexico 9
- Virginia 9
- West Virginia 9
- Wisconsin 9
- Michigan 8
- Minnesota 8
- North Carolina 8
- Indiana 7
- Montana 7
- Alabama 6
- Colorado 6
- Ohio 6
- Utah 6
- Mississippi 5
- Pennsylvania 5
- New York 4
- Puerto Rico 4
- Idaho 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500098 | 2500098 | 2022-05-13 | Taylor | Georgia | 13269 | 2003 | 54 |
2496840 | 2496840 | 2022-05-12 | Taylor | Georgia | 13269 | 2003 | 54 |
2493582 | 2493582 | 2022-05-11 | Taylor | Georgia | 13269 | 2003 | 54 |
2485125 | 2485125 | 2022-05-08 | Quay | New Mexico | 35037 | 2003 | 54 |
2481867 | 2481867 | 2022-05-07 | Quay | New Mexico | 35037 | 2003 | 54 |
2478609 | 2478609 | 2022-05-06 | Quay | New Mexico | 35037 | 2003 | 54 |
2475351 | 2475351 | 2022-05-05 | Quay | New Mexico | 35037 | 2003 | 54 |
2462327 | 2462327 | 2022-05-01 | Quay | New Mexico | 35037 | 2003 | 52 |
2459071 | 2459071 | 2022-04-30 | Quay | New Mexico | 35037 | 2003 | 52 |
2455815 | 2455815 | 2022-04-29 | Quay | New Mexico | 35037 | 2003 | 52 |
2452559 | 2452559 | 2022-04-28 | Quay | New Mexico | 35037 | 2003 | 52 |
2440848 | 2440848 | 2022-04-24 | Tucker | West Virginia | 54093 | 2003 | 37 |
2437592 | 2437592 | 2022-04-23 | Tucker | West Virginia | 54093 | 2003 | 37 |
2434336 | 2434336 | 2022-04-22 | Tucker | West Virginia | 54093 | 2003 | 37 |
2391253 | 2391253 | 2022-04-09 | Patillas | Puerto Rico | 72109 | 2003 | |
2373135 | 2373135 | 2022-04-04 | Wilcox | Georgia | 13315 | 2003 | 69 |
2369882 | 2369882 | 2022-04-03 | Wilcox | Georgia | 13315 | 2003 | 69 |
2366629 | 2366629 | 2022-04-02 | Wilcox | Georgia | 13315 | 2003 | 69 |
2363376 | 2363376 | 2022-04-01 | Wilcox | Georgia | 13315 | 2003 | 69 |
2360122 | 2360122 | 2022-03-31 | Wilcox | Georgia | 13315 | 2003 | 69 |
2356868 | 2356868 | 2022-03-30 | Wilcox | Georgia | 13315 | 2003 | 69 |
2353615 | 2353615 | 2022-03-29 | Wilcox | Georgia | 13315 | 2003 | 69 |
2350363 | 2350363 | 2022-03-28 | Wilcox | Georgia | 13315 | 2003 | 69 |
2313917 | 2313917 | 2022-03-16 | Pocahontas | West Virginia | 54075 | 2003 | 27 |
2310664 | 2310664 | 2022-03-15 | Pocahontas | West Virginia | 54075 | 2003 | 27 |
2245751 | 2245751 | 2022-02-24 | Choctaw | Alabama | 1023 | 2003 | 34 |
2246769 | 2246769 | 2022-02-24 | Crittenden | Kentucky | 21055 | 2003 | 43 |
2243518 | 2243518 | 2022-02-23 | Crittenden | Kentucky | 21055 | 2003 | 43 |
2244108 | 2244108 | 2022-02-23 | Carbon | Montana | 30009 | 2003 | 28 |
2244331 | 2244331 | 2022-02-23 | Sierra | New Mexico | 35051 | 2003 | 70 |
2224425 | 2224425 | 2022-02-17 | Humphreys | Mississippi | 28053 | 2003 | 44 |
2221174 | 2221174 | 2022-02-16 | Humphreys | Mississippi | 28053 | 2003 | 44 |
2219618 | 2219618 | 2022-02-15 | Pleasants | West Virginia | 54073 | 2003 | 34 |
2211693 | 2211693 | 2022-02-13 | Holt | Nebraska | 31089 | 2003 | 18 |
2208440 | 2208440 | 2022-02-12 | Holt | Nebraska | 31089 | 2003 | 18 |
2205187 | 2205187 | 2022-02-11 | Holt | Nebraska | 31089 | 2003 | 18 |
2199337 | 2199337 | 2022-02-09 | Jayuya | Puerto Rico | 72073 | 2003 | |
2170321 | 2170321 | 2022-01-31 | Archer | Texas | 48009 | 2003 | 24 |
2157445 | 2157445 | 2022-01-27 | Live Oak | Texas | 48297 | 2003 | 40 |
2128199 | 2128199 | 2022-01-18 | Parmer | Texas | 48369 | 2003 | 45 |
2118889 | 2118889 | 2022-01-16 | Bullock | Alabama | 1011 | 2003 | 46 |
2109379 | 2109379 | 2022-01-13 | Bent | Colorado | 8011 | 2003 | 45 |
2110105 | 2110105 | 2022-01-13 | Rice | Kansas | 20159 | 2003 | 17 |
2110757 | 2110757 | 2022-01-13 | Fergus | Montana | 30027 | 2003 | 52 |
2110872 | 2110872 | 2022-01-13 | Red Willow | Nebraska | 31145 | 2003 | 18 |
2106854 | 2106854 | 2022-01-12 | Rice | Kansas | 20159 | 2003 | 17 |
2080697 | 2080697 | 2022-01-04 | Franklin | Iowa | 19069 | 2003 | 35 |
2077445 | 2077445 | 2022-01-03 | Franklin | Iowa | 19069 | 2003 | 35 |
2074194 | 2074194 | 2022-01-02 | Franklin | Iowa | 19069 | 2003 | 35 |
2075934 | 2075934 | 2022-01-02 | Houston | Tennessee | 47083 | 2003 | 52 |
2070943 | 2070943 | 2022-01-01 | Franklin | Iowa | 19069 | 2003 | 35 |
2072683 | 2072683 | 2022-01-01 | Houston | Tennessee | 47083 | 2003 | 52 |
2067692 | 2067692 | 2021-12-31 | Franklin | Iowa | 19069 | 2003 | 35 |
2069432 | 2069432 | 2021-12-31 | Houston | Tennessee | 47083 | 2003 | 52 |
2064441 | 2064441 | 2021-12-30 | Franklin | Iowa | 19069 | 2003 | 35 |
2066181 | 2066181 | 2021-12-30 | Houston | Tennessee | 47083 | 2003 | 52 |
2061191 | 2061191 | 2021-12-29 | Franklin | Iowa | 19069 | 2003 | 35 |
2058526 | 2058526 | 2021-12-28 | Yellow Medicine | Minnesota | 27173 | 2003 | 25 |
2054869 | 2054869 | 2021-12-27 | Bath | Kentucky | 21011 | 2003 | 34 |
2055365 | 2055365 | 2021-12-27 | Barton | Missouri | 29011 | 2003 | 40 |
2028041 | 2028041 | 2021-12-19 | Stone | Arkansas | 5137 | 2003 | 46 |
2017113 | 2017113 | 2021-12-15 | Morrow | Oregon | 41049 | 2003 | 25 |
2011903 | 2011903 | 2021-12-14 | Prowers | Colorado | 8099 | 2003 | 42 |
1982623 | 1982623 | 2021-12-05 | Gunnison | Colorado | 8051 | 2003 | 12 |
1979373 | 1979373 | 2021-12-04 | Gunnison | Colorado | 8051 | 2003 | 12 |
1976123 | 1976123 | 2021-12-03 | Gunnison | Colorado | 8051 | 2003 | 12 |
1972216 | 1972216 | 2021-12-01 | Ward | Texas | 48475 | 2003 | 35 |
1968289 | 1968289 | 2021-11-30 | Johnston | Oklahoma | 40069 | 2003 | 47 |
1965038 | 1965038 | 2021-11-29 | Johnston | Oklahoma | 40069 | 2003 | 47 |
1961786 | 1961786 | 2021-11-28 | Johnston | Oklahoma | 40069 | 2003 | 47 |
1958535 | 1958535 | 2021-11-27 | Johnston | Oklahoma | 40069 | 2003 | 47 |
1955284 | 1955284 | 2021-11-26 | Johnston | Oklahoma | 40069 | 2003 | 47 |
1952033 | 1952033 | 2021-11-25 | Johnston | Oklahoma | 40069 | 2003 | 47 |
1948782 | 1948782 | 2021-11-24 | Johnston | Oklahoma | 40069 | 2003 | 47 |
1940001 | 1940001 | 2021-11-21 | Ashland | Wisconsin | 55003 | 2003 | 19 |
1936751 | 1936751 | 2021-11-20 | Ashland | Wisconsin | 55003 | 2003 | 19 |
1933501 | 1933501 | 2021-11-19 | Ashland | Wisconsin | 55003 | 2003 | 19 |
1924921 | 1924921 | 2021-11-17 | Martin | Kentucky | 21159 | 2003 | 36 |
1925037 | 1925037 | 2021-11-17 | Lincoln | Maine | 23015 | 2003 | 8 |
1912964 | 1912964 | 2021-11-13 | Morgan | Ohio | 39115 | 2003 | 37 |
1869567 | 1869567 | 2021-10-31 | Osage | Kansas | 20139 | 2003 | 37 |
1866318 | 1866318 | 2021-10-30 | Osage | Kansas | 20139 | 2003 | 37 |
1863069 | 1863069 | 2021-10-29 | Osage | Kansas | 20139 | 2003 | 37 |
1861831 | 1861831 | 2021-10-28 | Goochland | Virginia | 51075 | 2003 | 30 |
1852334 | 1852334 | 2021-10-25 | Big Horn | Wyoming | 56003 | 2003 | 50 |
1844729 | 1844729 | 2021-10-23 | Noble | Ohio | 39121 | 2003 | 47 |
1824735 | 1824735 | 2021-10-17 | Custer | Montana | 30017 | 2003 | 29 |
1821486 | 1821486 | 2021-10-16 | Custer | Montana | 30017 | 2003 | 29 |
1818237 | 1818237 | 2021-10-15 | Custer | Montana | 30017 | 2003 | 29 |
1819745 | 1819745 | 2021-10-15 | Morgan | West Virginia | 54065 | 2003 | 40 |
1806987 | 1806987 | 2021-10-12 | Chicot | Arkansas | 5017 | 2003 | 44 |
1807535 | 1807535 | 2021-10-12 | Mercer | Illinois | 17131 | 2003 | 35 |
1807676 | 1807676 | 2021-10-12 | Butler | Iowa | 19023 | 2003 | 37 |
1807712 | 1807712 | 2021-10-12 | Iowa | Iowa | 19095 | 2003 | 27 |
1803736 | 1803736 | 2021-10-11 | Chicot | Arkansas | 5017 | 2003 | 44 |
1804425 | 1804425 | 2021-10-11 | Butler | Iowa | 19023 | 2003 | 37 |
1804461 | 1804461 | 2021-10-11 | Iowa | Iowa | 19095 | 2003 | 27 |
1800487 | 1800487 | 2021-10-10 | Chicot | Arkansas | 5017 | 2003 | 44 |
1801176 | 1801176 | 2021-10-10 | Butler | Iowa | 19023 | 2003 | 37 |
1801212 | 1801212 | 2021-10-10 | Iowa | Iowa | 19095 | 2003 | 27 |
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);