ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
141 rows where cases = 4179 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 29
- Missouri 40
- Texas 12
- Oklahoma 8
- Arkansas 7
- Virginia 7
- North Carolina 6
- Mississippi 5
- Montana 5
- South Carolina 4
- West Virginia 4
- Wyoming 4
- California 3
- Illinois 3
- Indiana 3
- Kentucky 3
- Louisiana 3
- Minnesota 3
- New York 3
- Ohio 3
- Puerto Rico 3
- Florida 2
- Idaho 2
- Iowa 2
- Colorado 1
- Georgia 1
- Michigan 1
- New Hampshire 1
- Tennessee 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2488886 | 2488886 | 2022-05-09 | Aibonito | Puerto Rico | 72009 | 4179 | |
2471763 | 2471763 | 2022-05-04 | Benton | Missouri | 29015 | 4179 | 103 |
2468507 | 2468507 | 2022-05-03 | Benton | Missouri | 29015 | 4179 | 103 |
2465251 | 2465251 | 2022-05-02 | Benton | Missouri | 29015 | 4179 | 103 |
2461996 | 2461996 | 2022-05-01 | Benton | Missouri | 29015 | 4179 | 103 |
2458740 | 2458740 | 2022-04-30 | Benton | Missouri | 29015 | 4179 | 103 |
2455484 | 2455484 | 2022-04-29 | Benton | Missouri | 29015 | 4179 | 103 |
2452228 | 2452228 | 2022-04-28 | Benton | Missouri | 29015 | 4179 | 103 |
2448972 | 2448972 | 2022-04-27 | Benton | Missouri | 29015 | 4179 | 103 |
2445715 | 2445715 | 2022-04-26 | Benton | Missouri | 29015 | 4179 | 103 |
2442460 | 2442460 | 2022-04-25 | Benton | Missouri | 29015 | 4179 | 103 |
2439204 | 2439204 | 2022-04-24 | Benton | Missouri | 29015 | 4179 | 103 |
2435948 | 2435948 | 2022-04-23 | Benton | Missouri | 29015 | 4179 | 103 |
2432692 | 2432692 | 2022-04-22 | Benton | Missouri | 29015 | 4179 | 103 |
2429436 | 2429436 | 2022-04-21 | Benton | Missouri | 29015 | 4179 | 103 |
2426180 | 2426180 | 2022-04-20 | Benton | Missouri | 29015 | 4179 | 103 |
2422924 | 2422924 | 2022-04-19 | Benton | Missouri | 29015 | 4179 | 103 |
2419667 | 2419667 | 2022-04-18 | Benton | Missouri | 29015 | 4179 | 103 |
2421281 | 2421281 | 2022-04-18 | Hardy | West Virginia | 54031 | 4179 | 49 |
2416412 | 2416412 | 2022-04-17 | Benton | Missouri | 29015 | 4179 | 103 |
2413156 | 2413156 | 2022-04-16 | Benton | Missouri | 29015 | 4179 | 103 |
2409900 | 2409900 | 2022-04-15 | Benton | Missouri | 29015 | 4179 | 103 |
2406644 | 2406644 | 2022-04-14 | Benton | Missouri | 29015 | 4179 | 103 |
2403388 | 2403388 | 2022-04-13 | Benton | Missouri | 29015 | 4179 | 103 |
2400133 | 2400133 | 2022-04-12 | Benton | Missouri | 29015 | 4179 | 103 |
2396878 | 2396878 | 2022-04-11 | Benton | Missouri | 29015 | 4179 | 103 |
2393623 | 2393623 | 2022-04-10 | Benton | Missouri | 29015 | 4179 | 103 |
2393766 | 2393766 | 2022-04-10 | Park | Montana | 30067 | 4179 | 35 |
2390367 | 2390367 | 2022-04-09 | Benton | Missouri | 29015 | 4179 | 103 |
2390510 | 2390510 | 2022-04-09 | Park | Montana | 30067 | 4179 | 35 |
2387111 | 2387111 | 2022-04-08 | Benton | Missouri | 29015 | 4179 | 103 |
2387254 | 2387254 | 2022-04-08 | Park | Montana | 30067 | 4179 | 35 |
2383856 | 2383856 | 2022-04-07 | Benton | Missouri | 29015 | 4179 | 103 |
2383999 | 2383999 | 2022-04-07 | Park | Montana | 30067 | 4179 | 35 |
2380601 | 2380601 | 2022-04-06 | Benton | Missouri | 29015 | 4179 | 103 |
2377346 | 2377346 | 2022-04-05 | Benton | Missouri | 29015 | 4179 | 103 |
2374093 | 2374093 | 2022-04-04 | Benton | Missouri | 29015 | 4179 | 103 |
2370841 | 2370841 | 2022-04-03 | Benton | Missouri | 29015 | 4179 | 103 |
2367588 | 2367588 | 2022-04-02 | Benton | Missouri | 29015 | 4179 | 103 |
2364335 | 2364335 | 2022-04-01 | Benton | Missouri | 29015 | 4179 | 103 |
2361081 | 2361081 | 2022-03-31 | Benton | Missouri | 29015 | 4179 | 103 |
2248873 | 2248873 | 2022-02-24 | Morgan | West Virginia | 54065 | 4179 | 66 |
2243098 | 2243098 | 2022-02-23 | Carroll | Illinois | 17015 | 4179 | 47 |
2234734 | 2234734 | 2022-02-20 | Warren | North Carolina | 37185 | 4179 | 39 |
2231483 | 2231483 | 2022-02-19 | Warren | North Carolina | 37185 | 4179 | 39 |
2228232 | 2228232 | 2022-02-18 | Warren | North Carolina | 37185 | 4179 | 39 |
2215679 | 2215679 | 2022-02-14 | Lee | South Carolina | 45061 | 4179 | 89 |
2176551 | 2176551 | 2022-02-02 | Coamo | Puerto Rico | 72043 | 4179 | |
2167203 | 2167203 | 2022-01-30 | Lamb | Texas | 48279 | 4179 | 104 |
2111506 | 2111506 | 2022-01-13 | Las Piedras | Puerto Rico | 72085 | 4179 | |
2092275 | 2092275 | 2022-01-07 | Calhoun | Texas | 48057 | 4179 | 40 |
2082084 | 2082084 | 2022-01-04 | Seminole | Oklahoma | 40133 | 4179 | 107 |
2078832 | 2078832 | 2022-01-03 | Seminole | Oklahoma | 40133 | 4179 | 107 |
2075581 | 2075581 | 2022-01-02 | Seminole | Oklahoma | 40133 | 4179 | 107 |
2072330 | 2072330 | 2022-01-01 | Seminole | Oklahoma | 40133 | 4179 | 107 |
2069079 | 2069079 | 2021-12-31 | Seminole | Oklahoma | 40133 | 4179 | 107 |
2065828 | 2065828 | 2021-12-30 | Seminole | Oklahoma | 40133 | 4179 | 107 |
2062578 | 2062578 | 2021-12-29 | Seminole | Oklahoma | 40133 | 4179 | 107 |
2031289 | 2031289 | 2021-12-20 | Sevier | Arkansas | 5133 | 4179 | 63 |
2027737 | 2027737 | 2021-12-18 | Mason | West Virginia | 54053 | 4179 | 64 |
2016171 | 2016171 | 2021-12-15 | Otsego | Michigan | 26137 | 4179 | 74 |
1973679 | 1973679 | 2021-12-02 | Marion | Kentucky | 21155 | 4179 | 53 |
1974387 | 1974387 | 2021-12-02 | Coos | New Hampshire | 33007 | 4179 | 74 |
1972293 | 1972293 | 2021-12-01 | Botetourt | Virginia | 51023 | 4179 | 57 |
1904244 | 1904244 | 2021-11-10 | Upshur | West Virginia | 54097 | 4179 | 66 |
1895191 | 1895191 | 2021-11-08 | Payette | Idaho | 16075 | 4179 | 66 |
1851169 | 1851169 | 2021-10-25 | Adams | Ohio | 39001 | 4179 | 95 |
1829095 | 1829095 | 2021-10-18 | Hockley | Texas | 48219 | 4179 | 130 |
1823696 | 1823696 | 2021-10-17 | Jerome | Idaho | 16053 | 4179 | 44 |
1824975 | 1824975 | 2021-10-17 | Franklin | New York | 36033 | 4179 | 20 |
1825846 | 1825846 | 2021-10-17 | Hockley | Texas | 48219 | 4179 | 130 |
1820007 | 1820007 | 2021-10-16 | Jackson | Arkansas | 5067 | 4179 | 42 |
1822597 | 1822597 | 2021-10-16 | Hockley | Texas | 48219 | 4179 | 130 |
1792082 | 1792082 | 2021-10-07 | Marion | Mississippi | 28091 | 4179 | 106 |
1775877 | 1775877 | 2021-10-02 | Barry | Missouri | 29009 | 4179 | 59 |
1762061 | 1762061 | 2021-09-28 | Saline | Illinois | 17165 | 4179 | 83 |
1758248 | 1758248 | 2021-09-27 | Carroll | Arkansas | 5015 | 4179 | 67 |
1755000 | 1755000 | 2021-09-26 | Carroll | Arkansas | 5015 | 4179 | 67 |
1649809 | 1649809 | 2021-08-24 | Preble | Ohio | 39135 | 4179 | 108 |
1645450 | 1645450 | 2021-08-23 | Calloway | Kentucky | 21035 | 4179 | 53 |
1644428 | 1644428 | 2021-08-22 | Teton | Wyoming | 56039 | 4179 | 11 |
1641178 | 1641178 | 2021-08-21 | Teton | Wyoming | 56039 | 4179 | 11 |
1637928 | 1637928 | 2021-08-20 | Teton | Wyoming | 56039 | 4179 | 11 |
1628474 | 1628474 | 2021-08-18 | Montrose | Colorado | 8085 | 4179 | 72 |
1623070 | 1623070 | 2021-08-16 | Nobles | Minnesota | 27105 | 4179 | 50 |
1619624 | 1619624 | 2021-08-15 | Vernon | Louisiana | 22115 | 4179 | 121 |
1616376 | 1616376 | 2021-08-14 | Vernon | Louisiana | 22115 | 4179 | 121 |
1613127 | 1613127 | 2021-08-13 | Vernon | Louisiana | 22115 | 4179 | 121 |
1611649 | 1611649 | 2021-08-12 | Charlottesville city | Virginia | 51540 | 4179 | 58 |
1582014 | 1582014 | 2021-08-03 | Giles | Tennessee | 47055 | 4179 | 99 |
1564012 | 1564012 | 2021-07-29 | Whitley | Indiana | 18183 | 4179 | 45 |
1541949 | 1541949 | 2021-07-22 | Neshoba | Mississippi | 28099 | 4179 | 180 |
1542145 | 1542145 | 2021-07-22 | Silver Bow | Montana | 30093 | 4179 | 86 |
1527677 | 1527677 | 2021-07-18 | Union | Arkansas | 5139 | 4179 | 116 |
1524430 | 1524430 | 2021-07-17 | Union | Arkansas | 5139 | 4179 | 116 |
1521182 | 1521182 | 2021-07-16 | Union | Arkansas | 5139 | 4179 | 116 |
1473765 | 1473765 | 2021-07-01 | Monroe | Mississippi | 28095 | 4179 | 136 |
1474236 | 1474236 | 2021-07-01 | Davie | North Carolina | 37059 | 4179 | 40 |
1470519 | 1470519 | 2021-06-30 | Monroe | Mississippi | 28095 | 4179 | 136 |
1470990 | 1470990 | 2021-06-30 | Davie | North Carolina | 37059 | 4179 | 40 |
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);