ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
694 rows where deaths = 296 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- North Carolina 57
- Texas 56
- Pennsylvania 53
- Alabama 51
- Georgia 31
- Illinois 30
- Minnesota 29
- California 27
- New York 25
- Tennessee 25
- Florida 23
- Louisiana 21
- Maryland 19
- South Carolina 18
- Virginia 18
- Wisconsin 17
- Michigan 16
- Indiana 14
- Mississippi 14
- New Jersey 14
- Ohio 14
- Oregon 14
- Kentucky 11
- Missouri 11
- Washington 11
- Colorado 8
- Connecticut 8
- Oklahoma 8
- Idaho 7
- Montana 7
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500174 | 2500174 | 2022-05-13 | Twin Falls | Idaho | 16083 | 24129 | 296 |
2500186 | 2500186 | 2022-05-13 | Champaign | Illinois | 17019 | 67086 | 296 |
2501177 | 2501177 | 2022-05-13 | St. Francois | Missouri | 29187 | 19117 | 296 |
2496928 | 2496928 | 2022-05-12 | Champaign | Illinois | 17019 | 66959 | 296 |
2493670 | 2493670 | 2022-05-11 | Champaign | Illinois | 17019 | 66809 | 296 |
2490412 | 2490412 | 2022-05-10 | Champaign | Illinois | 17019 | 66675 | 296 |
2487155 | 2487155 | 2022-05-09 | Champaign | Illinois | 17019 | 66475 | 296 |
2483897 | 2483897 | 2022-05-08 | Champaign | Illinois | 17019 | 66133 | 296 |
2480639 | 2480639 | 2022-05-07 | Champaign | Illinois | 17019 | 66133 | 296 |
2477381 | 2477381 | 2022-05-06 | Champaign | Illinois | 17019 | 66133 | 296 |
2470866 | 2470866 | 2022-05-04 | Champaign | Illinois | 17019 | 65795 | 296 |
2467610 | 2467610 | 2022-05-03 | Champaign | Illinois | 17019 | 65668 | 296 |
2468954 | 2468954 | 2022-05-03 | Henderson | North Carolina | 37089 | 25080 | 296 |
2464355 | 2464355 | 2022-05-02 | Champaign | Illinois | 17019 | 65544 | 296 |
2465698 | 2465698 | 2022-05-02 | Henderson | North Carolina | 37089 | 25080 | 296 |
2461099 | 2461099 | 2022-05-01 | Champaign | Illinois | 17019 | 65310 | 296 |
2462443 | 2462443 | 2022-05-01 | Henderson | North Carolina | 37089 | 25080 | 296 |
2457843 | 2457843 | 2022-04-30 | Champaign | Illinois | 17019 | 65310 | 296 |
2459187 | 2459187 | 2022-04-30 | Henderson | North Carolina | 37089 | 25080 | 296 |
2454587 | 2454587 | 2022-04-29 | Champaign | Illinois | 17019 | 65310 | 296 |
2455931 | 2455931 | 2022-04-29 | Henderson | North Carolina | 37089 | 25080 | 296 |
2451331 | 2451331 | 2022-04-28 | Champaign | Illinois | 17019 | 65134 | 296 |
2452675 | 2452675 | 2022-04-28 | Henderson | North Carolina | 37089 | 25080 | 296 |
2448075 | 2448075 | 2022-04-27 | Champaign | Illinois | 17019 | 65055 | 296 |
2449419 | 2449419 | 2022-04-27 | Henderson | North Carolina | 37089 | 25080 | 296 |
2444819 | 2444819 | 2022-04-26 | Champaign | Illinois | 17019 | 64904 | 296 |
2446162 | 2446162 | 2022-04-26 | Henderson | North Carolina | 37089 | 25006 | 296 |
2441563 | 2441563 | 2022-04-25 | Champaign | Illinois | 17019 | 64771 | 296 |
2442907 | 2442907 | 2022-04-25 | Henderson | North Carolina | 37089 | 25006 | 296 |
2438307 | 2438307 | 2022-04-24 | Champaign | Illinois | 17019 | 64564 | 296 |
2439651 | 2439651 | 2022-04-24 | Henderson | North Carolina | 37089 | 25006 | 296 |
2435051 | 2435051 | 2022-04-23 | Champaign | Illinois | 17019 | 64564 | 296 |
2436395 | 2436395 | 2022-04-23 | Henderson | North Carolina | 37089 | 25006 | 296 |
2431795 | 2431795 | 2022-04-22 | Champaign | Illinois | 17019 | 64564 | 296 |
2433139 | 2433139 | 2022-04-22 | Henderson | North Carolina | 37089 | 25006 | 296 |
2428539 | 2428539 | 2022-04-21 | Champaign | Illinois | 17019 | 64437 | 296 |
2429883 | 2429883 | 2022-04-21 | Henderson | North Carolina | 37089 | 25006 | 296 |
2431031 | 2431031 | 2022-04-21 | Whatcom | Washington | 53073 | 37792 | 296 |
2426627 | 2426627 | 2022-04-20 | Henderson | North Carolina | 37089 | 25006 | 296 |
2426811 | 2426811 | 2022-04-20 | Ross | Ohio | 39141 | 19247 | 296 |
2427775 | 2427775 | 2022-04-20 | Whatcom | Washington | 53073 | 37792 | 296 |
2423555 | 2423555 | 2022-04-19 | Ross | Ohio | 39141 | 19247 | 296 |
2420298 | 2420298 | 2022-04-18 | Ross | Ohio | 39141 | 19247 | 296 |
2417043 | 2417043 | 2022-04-17 | Ross | Ohio | 39141 | 19247 | 296 |
2413787 | 2413787 | 2022-04-16 | Ross | Ohio | 39141 | 19247 | 296 |
2410531 | 2410531 | 2022-04-15 | Ross | Ohio | 39141 | 19247 | 296 |
2407275 | 2407275 | 2022-04-14 | Ross | Ohio | 39141 | 19247 | 296 |
2404930 | 2404930 | 2022-04-13 | Spotsylvania | Virginia | 51177 | 26919 | 296 |
2401234 | 2401234 | 2022-04-12 | Robertson | Tennessee | 47147 | 21521 | 296 |
2397979 | 2397979 | 2022-04-11 | Robertson | Tennessee | 47147 | 21521 | 296 |
2394724 | 2394724 | 2022-04-10 | Robertson | Tennessee | 47147 | 21521 | 296 |
2391468 | 2391468 | 2022-04-09 | Robertson | Tennessee | 47147 | 21521 | 296 |
2388212 | 2388212 | 2022-04-08 | Robertson | Tennessee | 47147 | 21521 | 296 |
2382826 | 2382826 | 2022-04-07 | Laurens | Georgia | 13175 | 13765 | 296 |
2384957 | 2384957 | 2022-04-07 | Robertson | Tennessee | 47147 | 21521 | 296 |
2381702 | 2381702 | 2022-04-06 | Robertson | Tennessee | 47147 | 21521 | 296 |
2354867 | 2354867 | 2022-03-29 | Cape May | New Jersey | 34009 | 21783 | 296 |
2355039 | 2355039 | 2022-03-29 | Nash | North Carolina | 37127 | 26730 | 296 |
2350542 | 2350542 | 2022-03-28 | Floyd | Indiana | 18043 | 18913 | 296 |
2351786 | 2351786 | 2022-03-28 | Nash | North Carolina | 37127 | 26749 | 296 |
2345109 | 2345109 | 2022-03-26 | Cape May | New Jersey | 34009 | 21777 | 296 |
2341856 | 2341856 | 2022-03-25 | Cape May | New Jersey | 34009 | 21776 | 296 |
2341912 | 2341912 | 2022-03-25 | Chautauqua | New York | 36013 | 23489 | 296 |
2342918 | 2342918 | 2022-03-25 | Val Verde | Texas | 48465 | 14291 | 296 |
2338603 | 2338603 | 2022-03-24 | Cape May | New Jersey | 34009 | 21775 | 296 |
2338659 | 2338659 | 2022-03-24 | Chautauqua | New York | 36013 | 23483 | 296 |
2339665 | 2339665 | 2022-03-24 | Val Verde | Texas | 48465 | 14291 | 296 |
2335349 | 2335349 | 2022-03-23 | Cape May | New Jersey | 34009 | 21765 | 296 |
2335405 | 2335405 | 2022-03-23 | Chautauqua | New York | 36013 | 23475 | 296 |
2336411 | 2336411 | 2022-03-23 | Val Verde | Texas | 48465 | 14290 | 296 |
2332095 | 2332095 | 2022-03-22 | Cape May | New Jersey | 34009 | 21759 | 296 |
2332151 | 2332151 | 2022-03-22 | Chautauqua | New York | 36013 | 23463 | 296 |
2333157 | 2333157 | 2022-03-22 | Val Verde | Texas | 48465 | 14290 | 296 |
2327361 | 2327361 | 2022-03-21 | Windham | Connecticut | 9015 | 25511 | 296 |
2328842 | 2328842 | 2022-03-21 | Cape May | New Jersey | 34009 | 21751 | 296 |
2328898 | 2328898 | 2022-03-21 | Chautauqua | New York | 36013 | 23457 | 296 |
2329487 | 2329487 | 2022-03-21 | Greenwood | South Carolina | 45047 | 22457 | 296 |
2324108 | 2324108 | 2022-03-20 | Windham | Connecticut | 9015 | 25496 | 296 |
2325247 | 2325247 | 2022-03-20 | Lee | Mississippi | 28081 | 26601 | 296 |
2325646 | 2325646 | 2022-03-20 | Chautauqua | New York | 36013 | 23454 | 296 |
2326235 | 2326235 | 2022-03-20 | Greenwood | South Carolina | 45047 | 22457 | 296 |
2320854 | 2320854 | 2022-03-19 | Windham | Connecticut | 9015 | 25496 | 296 |
2321993 | 2321993 | 2022-03-19 | Lee | Mississippi | 28081 | 26601 | 296 |
2322982 | 2322982 | 2022-03-19 | Greenwood | South Carolina | 45047 | 22457 | 296 |
2317600 | 2317600 | 2022-03-18 | Windham | Connecticut | 9015 | 25496 | 296 |
2318739 | 2318739 | 2022-03-18 | Lee | Mississippi | 28081 | 26601 | 296 |
2319728 | 2319728 | 2022-03-18 | Greenwood | South Carolina | 45047 | 22457 | 296 |
2314347 | 2314347 | 2022-03-17 | Windham | Connecticut | 9015 | 25492 | 296 |
2315486 | 2315486 | 2022-03-17 | Lee | Mississippi | 28081 | 26601 | 296 |
2315951 | 2315951 | 2022-03-17 | Caldwell | North Carolina | 37027 | 22084 | 296 |
2316474 | 2316474 | 2022-03-17 | Greenwood | South Carolina | 45047 | 22457 | 296 |
2311094 | 2311094 | 2022-03-16 | Windham | Connecticut | 9015 | 25484 | 296 |
2312233 | 2312233 | 2022-03-16 | Lee | Mississippi | 28081 | 26601 | 296 |
2313221 | 2313221 | 2022-03-16 | Greenwood | South Carolina | 45047 | 22457 | 296 |
2307841 | 2307841 | 2022-03-15 | Windham | Connecticut | 9015 | 25479 | 296 |
2308980 | 2308980 | 2022-03-15 | Lee | Mississippi | 28081 | 26601 | 296 |
2309415 | 2309415 | 2022-03-15 | Schenectady | New York | 36093 | 32534 | 296 |
2309445 | 2309445 | 2022-03-15 | Caldwell | North Carolina | 37027 | 22132 | 296 |
2309968 | 2309968 | 2022-03-15 | Greenwood | South Carolina | 45047 | 22457 | 296 |
2305729 | 2305729 | 2022-03-14 | Lee | Mississippi | 28081 | 26601 | 296 |
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);