ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
211 rows where cases = 3533 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Oklahoma 25
- Texas 25
- Missouri 14
- Indiana 13
- Michigan 11
- Georgia 9
- West Virginia 8
- Alabama 7
- Mississippi 7
- Tennessee 7
- Wisconsin 7
- Arkansas 6
- Colorado 6
- Minnesota 6
- Oregon 6
- Virginia 6
- Kentucky 5
- Nebraska 5
- New Mexico 4
- Puerto Rico 4
- Illinois 3
- Kansas 3
- Louisiana 3
- New York 3
- North Carolina 3
- Ohio 3
- Maryland 2
- Wyoming 2
- California 1
- Florida 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501786 | 2501786 | 2022-05-13 | Okfuskee | Oklahoma | 40107 | 3533 | 62 |
2498528 | 2498528 | 2022-05-12 | Okfuskee | Oklahoma | 40107 | 3533 | 62 |
2472466 | 2472466 | 2022-05-04 | Okfuskee | Oklahoma | 40107 | 3533 | 61 |
2467783 | 2467783 | 2022-05-03 | Tipton | Indiana | 18159 | 3533 | 87 |
2469210 | 2469210 | 2022-05-03 | Okfuskee | Oklahoma | 40107 | 3533 | 61 |
2464528 | 2464528 | 2022-05-02 | Tipton | Indiana | 18159 | 3533 | 87 |
2465954 | 2465954 | 2022-05-02 | Okfuskee | Oklahoma | 40107 | 3533 | 61 |
2461272 | 2461272 | 2022-05-01 | Tipton | Indiana | 18159 | 3533 | 87 |
2462699 | 2462699 | 2022-05-01 | Okfuskee | Oklahoma | 40107 | 3533 | 61 |
2458016 | 2458016 | 2022-04-30 | Tipton | Indiana | 18159 | 3533 | 87 |
2459443 | 2459443 | 2022-04-30 | Okfuskee | Oklahoma | 40107 | 3533 | 61 |
2454760 | 2454760 | 2022-04-29 | Tipton | Indiana | 18159 | 3533 | 87 |
2456187 | 2456187 | 2022-04-29 | Okfuskee | Oklahoma | 40107 | 3533 | 61 |
2452931 | 2452931 | 2022-04-28 | Okfuskee | Oklahoma | 40107 | 3533 | 61 |
2449675 | 2449675 | 2022-04-27 | Okfuskee | Oklahoma | 40107 | 3533 | 61 |
2446418 | 2446418 | 2022-04-26 | Okfuskee | Oklahoma | 40107 | 3533 | 61 |
2443163 | 2443163 | 2022-04-25 | Okfuskee | Oklahoma | 40107 | 3533 | 61 |
2439907 | 2439907 | 2022-04-24 | Okfuskee | Oklahoma | 40107 | 3533 | 61 |
2436651 | 2436651 | 2022-04-23 | Okfuskee | Oklahoma | 40107 | 3533 | 61 |
2433395 | 2433395 | 2022-04-22 | Okfuskee | Oklahoma | 40107 | 3533 | 61 |
2430139 | 2430139 | 2022-04-21 | Okfuskee | Oklahoma | 40107 | 3533 | 61 |
2422701 | 2422701 | 2022-04-19 | Kalkaska | Michigan | 26079 | 3533 | 60 |
2419445 | 2419445 | 2022-04-18 | Kalkaska | Michigan | 26079 | 3533 | 60 |
2416189 | 2416189 | 2022-04-17 | Kalkaska | Michigan | 26079 | 3533 | 60 |
2412933 | 2412933 | 2022-04-16 | Kalkaska | Michigan | 26079 | 3533 | 60 |
2409677 | 2409677 | 2022-04-15 | Kalkaska | Michigan | 26079 | 3533 | 60 |
2406421 | 2406421 | 2022-04-14 | Kalkaska | Michigan | 26079 | 3533 | 60 |
2403165 | 2403165 | 2022-04-13 | Kalkaska | Michigan | 26079 | 3533 | 60 |
2404091 | 2404091 | 2022-04-13 | Okfuskee | Oklahoma | 40107 | 3533 | 61 |
2400836 | 2400836 | 2022-04-12 | Okfuskee | Oklahoma | 40107 | 3533 | 61 |
2397581 | 2397581 | 2022-04-11 | Okfuskee | Oklahoma | 40107 | 3533 | 61 |
2394326 | 2394326 | 2022-04-10 | Okfuskee | Oklahoma | 40107 | 3533 | 61 |
2391070 | 2391070 | 2022-04-09 | Okfuskee | Oklahoma | 40107 | 3533 | 61 |
2387814 | 2387814 | 2022-04-08 | Okfuskee | Oklahoma | 40107 | 3533 | 61 |
2384559 | 2384559 | 2022-04-07 | Okfuskee | Oklahoma | 40107 | 3533 | 61 |
2381436 | 2381436 | 2022-04-06 | Aibonito | Puerto Rico | 72009 | 3533 | |
2352061 | 2352061 | 2022-03-28 | Hood River | Oregon | 41027 | 3533 | 42 |
2348809 | 2348809 | 2022-03-27 | Hood River | Oregon | 41027 | 3533 | 42 |
2345556 | 2345556 | 2022-03-26 | Hood River | Oregon | 41027 | 3533 | 42 |
2342303 | 2342303 | 2022-03-25 | Hood River | Oregon | 41027 | 3533 | 42 |
2324072 | 2324072 | 2022-03-20 | Las Animas | Colorado | 8071 | 3533 | 41 |
2320818 | 2320818 | 2022-03-19 | Las Animas | Colorado | 8071 | 3533 | 41 |
2317564 | 2317564 | 2022-03-18 | Las Animas | Colorado | 8071 | 3533 | 41 |
2314311 | 2314311 | 2022-03-17 | Las Animas | Colorado | 8071 | 3533 | 41 |
2311058 | 2311058 | 2022-03-16 | Las Animas | Colorado | 8071 | 3533 | 41 |
2269787 | 2269787 | 2022-03-03 | Leelanau | Michigan | 26089 | 3533 | 50 |
2271520 | 2271520 | 2022-03-03 | Patrick | Virginia | 51141 | 3533 | 86 |
2266534 | 2266534 | 2022-03-02 | Leelanau | Michigan | 26089 | 3533 | 50 |
2262009 | 2262009 | 2022-03-01 | Cleburne | Alabama | 1029 | 3533 | 68 |
2226218 | 2226218 | 2022-02-17 | Goshen | Wyoming | 56015 | 3533 | 54 |
2217873 | 2217873 | 2022-02-15 | Renville | Minnesota | 27129 | 3533 | 54 |
2202595 | 2202595 | 2022-02-10 | Lares | Puerto Rico | 72081 | 3533 | |
2185509 | 2185509 | 2022-02-05 | Livingston | Missouri | 29117 | 3533 | 86 |
2168280 | 2168280 | 2022-01-31 | Minidoka | Idaho | 16067 | 3533 | 55 |
2147856 | 2147856 | 2022-01-24 | Bristol city | Virginia | 51520 | 3533 | 61 |
2128506 | 2128506 | 2022-01-18 | Hardy | West Virginia | 54031 | 3533 | 43 |
2107319 | 2107319 | 2022-01-12 | Holmes | Mississippi | 28051 | 3533 | 94 |
2097475 | 2097475 | 2022-01-09 | Fillmore | Minnesota | 27045 | 3533 | 17 |
2094223 | 2094223 | 2022-01-08 | Fillmore | Minnesota | 27045 | 3533 | 17 |
2090971 | 2090971 | 2022-01-07 | Fillmore | Minnesota | 27045 | 3533 | 17 |
2081756 | 2081756 | 2022-01-04 | Schoharie | New York | 36095 | 3533 | 29 |
2074970 | 2074970 | 2022-01-02 | Texas | Missouri | 29215 | 3533 | 73 |
2071719 | 2071719 | 2022-01-01 | Texas | Missouri | 29215 | 3533 | 73 |
2068468 | 2068468 | 2021-12-31 | Texas | Missouri | 29215 | 3533 | 73 |
2065217 | 2065217 | 2021-12-30 | Texas | Missouri | 29215 | 3533 | 73 |
2061931 | 2061931 | 2021-12-29 | New Madrid | Missouri | 29143 | 3533 | 71 |
2049487 | 2049487 | 2021-12-25 | Paulding | Ohio | 39125 | 3533 | 61 |
2046237 | 2046237 | 2021-12-24 | Paulding | Ohio | 39125 | 3533 | 61 |
2008505 | 2008505 | 2021-12-13 | Lawrence | Arkansas | 5075 | 3533 | 62 |
2000904 | 2000904 | 2021-12-10 | Juniata | Pennsylvania | 42067 | 3533 | 134 |
1990430 | 1990430 | 2021-12-07 | Perry | Missouri | 29157 | 3533 | 39 |
1988067 | 1988067 | 2021-12-06 | Beadle | South Dakota | 46005 | 3533 | 47 |
1975287 | 1975287 | 2021-12-02 | Deaf Smith | Texas | 48117 | 3533 | 87 |
1949958 | 1949958 | 2021-11-25 | Arkansas | Arkansas | 5001 | 3533 | 60 |
1921677 | 1921677 | 2021-11-16 | Meade | Kentucky | 21163 | 3533 | 40 |
1907056 | 1907056 | 2021-11-11 | Gillespie | Texas | 48171 | 3533 | 80 |
1903807 | 1903807 | 2021-11-10 | Gillespie | Texas | 48171 | 3533 | 80 |
1903892 | 1903892 | 2021-11-10 | Moore | Texas | 48341 | 3533 | 88 |
1900557 | 1900557 | 2021-11-09 | Gillespie | Texas | 48171 | 3533 | 80 |
1900642 | 1900642 | 2021-11-09 | Moore | Texas | 48341 | 3533 | 88 |
1897137 | 1897137 | 2021-11-08 | Chester | Tennessee | 47023 | 3533 | 75 |
1897307 | 1897307 | 2021-11-08 | Gillespie | Texas | 48171 | 3533 | 80 |
1893887 | 1893887 | 2021-11-07 | Chester | Tennessee | 47023 | 3533 | 75 |
1894057 | 1894057 | 2021-11-07 | Gillespie | Texas | 48171 | 3533 | 79 |
1890637 | 1890637 | 2021-11-06 | Chester | Tennessee | 47023 | 3533 | 75 |
1890807 | 1890807 | 2021-11-06 | Gillespie | Texas | 48171 | 3533 | 79 |
1887387 | 1887387 | 2021-11-05 | Chester | Tennessee | 47023 | 3533 | 75 |
1887557 | 1887557 | 2021-11-05 | Gillespie | Texas | 48171 | 3533 | 79 |
1884307 | 1884307 | 2021-11-04 | Gillespie | Texas | 48171 | 3533 | 79 |
1881058 | 1881058 | 2021-11-03 | Gillespie | Texas | 48171 | 3533 | 79 |
1877809 | 1877809 | 2021-11-02 | Gillespie | Texas | 48171 | 3533 | 78 |
1877865 | 1877865 | 2021-11-02 | Lampasas | Texas | 48281 | 3533 | 65 |
1874482 | 1874482 | 2021-11-01 | Austin | Texas | 48015 | 3533 | 52 |
1874560 | 1874560 | 2021-11-01 | Gillespie | Texas | 48171 | 3533 | 78 |
1874616 | 1874616 | 2021-11-01 | Lampasas | Texas | 48281 | 3533 | 65 |
1871311 | 1871311 | 2021-10-31 | Gillespie | Texas | 48171 | 3533 | 78 |
1868062 | 1868062 | 2021-10-30 | Gillespie | Texas | 48171 | 3533 | 78 |
1864813 | 1864813 | 2021-10-29 | Gillespie | Texas | 48171 | 3533 | 78 |
1859905 | 1859905 | 2021-10-28 | Hart | Kentucky | 21099 | 3533 | 63 |
1856292 | 1856292 | 2021-10-27 | Shelby | Illinois | 17173 | 3533 | 52 |
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);