ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
61 rows where cases = 7030 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 23
- Oklahoma 14
- Minnesota 7
- Ohio 5
- Colorado 4
- Michigan 4
- North Carolina 4
- Alabama 2
- Florida 2
- Georgia 2
- Kentucky 2
- Tennessee 2
- Texas 2
- Arkansas 1
- California 1
- Indiana 1
- Louisiana 1
- Massachusetts 1
- Missouri 1
- Montana 1
- New York 1
- Pennsylvania 1
- South Carolina 1
- South Dakota 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2449646 | 2449646 | 2022-04-27 | Garvin | Oklahoma | 40049 | 7030 | 144 |
2446389 | 2446389 | 2022-04-26 | Garvin | Oklahoma | 40049 | 7030 | 144 |
2443134 | 2443134 | 2022-04-25 | Garvin | Oklahoma | 40049 | 7030 | 144 |
2439083 | 2439083 | 2022-04-24 | Pine | Minnesota | 27115 | 7030 | 67 |
2439878 | 2439878 | 2022-04-24 | Garvin | Oklahoma | 40049 | 7030 | 144 |
2435827 | 2435827 | 2022-04-23 | Pine | Minnesota | 27115 | 7030 | 67 |
2436622 | 2436622 | 2022-04-23 | Garvin | Oklahoma | 40049 | 7030 | 144 |
2432571 | 2432571 | 2022-04-22 | Pine | Minnesota | 27115 | 7030 | 67 |
2433366 | 2433366 | 2022-04-22 | Garvin | Oklahoma | 40049 | 7030 | 144 |
2430110 | 2430110 | 2022-04-21 | Garvin | Oklahoma | 40049 | 7030 | 144 |
2426854 | 2426854 | 2022-04-20 | Garvin | Oklahoma | 40049 | 7030 | 143 |
2423598 | 2423598 | 2022-04-19 | Garvin | Oklahoma | 40049 | 7030 | 143 |
2420341 | 2420341 | 2022-04-18 | Garvin | Oklahoma | 40049 | 7030 | 143 |
2417086 | 2417086 | 2022-04-17 | Garvin | Oklahoma | 40049 | 7030 | 143 |
2413830 | 2413830 | 2022-04-16 | Garvin | Oklahoma | 40049 | 7030 | 143 |
2410574 | 2410574 | 2022-04-15 | Garvin | Oklahoma | 40049 | 7030 | 143 |
2407318 | 2407318 | 2022-04-14 | Garvin | Oklahoma | 40049 | 7030 | 143 |
2374243 | 2374243 | 2022-04-04 | Ravalli | Montana | 30081 | 7030 | 141 |
2334919 | 2334919 | 2022-03-23 | Lyon | Minnesota | 27083 | 7030 | 72 |
2325160 | 2325160 | 2022-03-20 | Lyon | Minnesota | 27083 | 7030 | 72 |
2321906 | 2321906 | 2022-03-19 | Lyon | Minnesota | 27083 | 7030 | 72 |
2318652 | 2318652 | 2022-03-18 | Lyon | Minnesota | 27083 | 7030 | 72 |
2274412 | 2274412 | 2022-03-04 | Cass | Texas | 48067 | 7030 | 189 |
2257589 | 2257589 | 2022-02-27 | Hardin | Ohio | 39065 | 7030 | 146 |
2254338 | 2254338 | 2022-02-26 | Hardin | Ohio | 39065 | 7030 | 146 |
2157132 | 2157132 | 2022-01-27 | Union | South Carolina | 45087 | 7030 | 120 |
2152429 | 2152429 | 2022-01-26 | Boyle | Kentucky | 21021 | 7030 | 118 |
2073651 | 2073651 | 2022-01-02 | Montrose | Colorado | 8085 | 7030 | 144 |
2070400 | 2070400 | 2022-01-01 | Montrose | Colorado | 8085 | 7030 | 144 |
2067149 | 2067149 | 2021-12-31 | Montrose | Colorado | 8085 | 7030 | 144 |
2011627 | 2011627 | 2021-12-14 | Covington | Alabama | 1039 | 7030 | 197 |
1961670 | 1961670 | 2021-11-28 | Brown | Ohio | 39015 | 7030 | 115 |
1932216 | 1932216 | 2021-11-19 | Madison | New York | 36053 | 7030 | 107 |
1837260 | 1837260 | 2021-10-21 | Lincoln | Louisiana | 22061 | 7030 | 115 |
1831562 | 1831562 | 2021-10-19 | Hoke | North Carolina | 37093 | 7030 | 79 |
1808123 | 1808123 | 2021-10-12 | Branch | Michigan | 26023 | 7030 | 135 |
1804872 | 1804872 | 2021-10-11 | Branch | Michigan | 26023 | 7030 | 135 |
1783418 | 1783418 | 2021-10-04 | Cocke | Tennessee | 47029 | 7030 | 104 |
1769171 | 1769171 | 2021-09-30 | Marquette | Michigan | 26103 | 7030 | 71 |
1765922 | 1765922 | 2021-09-29 | Marquette | Michigan | 26103 | 7030 | 71 |
1677333 | 1677333 | 2021-09-02 | Coffee | Georgia | 13069 | 7030 | 192 |
1647944 | 1647944 | 2021-08-24 | Eagle | Colorado | 8037 | 7030 | 26 |
1626509 | 1626509 | 2021-08-17 | Newton | Missouri | 29145 | 7030 | 99 |
1529589 | 1529589 | 2021-07-18 | Hancock | Ohio | 39063 | 7030 | 134 |
1380121 | 1380121 | 2021-06-02 | Franklin | North Carolina | 37069 | 7030 | 51 |
1376876 | 1376876 | 2021-06-01 | Franklin | North Carolina | 37069 | 7030 | 51 |
1335375 | 1335375 | 2021-05-19 | Bowie | Texas | 48037 | 7030 | 216 |
1316867 | 1316867 | 2021-05-14 | Monroe | Florida | 12087 | 7030 | 49 |
1266838 | 1266838 | 2021-04-28 | Crawford | Pennsylvania | 42039 | 7030 | 147 |
1152873 | 1152873 | 2021-03-24 | Rockingham | North Carolina | 37157 | 7030 | 73 |
1124280 | 1124280 | 2021-03-15 | Tipton | Tennessee | 47167 | 7030 | 104 |
1080261 | 1080261 | 2021-03-02 | Wayne | Indiana | 18177 | 7030 | 195 |
966040 | 966040 | 2021-01-26 | Pope | Arkansas | 5115 | 7030 | 83 |
947473 | 947473 | 2021-01-20 | Madison | Kentucky | 21151 | 7030 | 48 |
924220 | 924220 | 2021-01-13 | Walton | Georgia | 13297 | 7030 | 98 |
909957 | 909957 | 2021-01-08 | Lincoln | South Dakota | 46083 | 7030 | 68 |
894500 | 894500 | 2021-01-04 | DeKalb | Alabama | 1049 | 7030 | 62 |
746427 | 746427 | 2020-11-19 | Unknown | Massachusetts | 7030 | 7 | |
644831 | 644831 | 2020-10-19 | Marin | California | 6041 | 7030 | 124 |
431374 | 431374 | 2020-08-14 | Marion | Florida | 12083 | 7030 | 111 |
235905 | 235905 | 2020-06-13 | Franklin | Ohio | 39049 | 7030 | 329 |
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);