ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,290 rows where deaths = 156 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 227
- Indiana 170
- Tennessee 141
- Pennsylvania 126
- Ohio 116
- Georgia 114
- Mississippi 106
- North Carolina 97
- Virginia 95
- Louisiana 93
- Illinois 92
- Michigan 88
- West Virginia 88
- Alabama 78
- Oklahoma 72
- Florida 52
- New York 52
- South Carolina 46
- Arkansas 38
- Kentucky 37
- Colorado 35
- Washington 34
- California 31
- Wisconsin 28
- Minnesota 24
- New Mexico 23
- New Jersey 22
- Iowa 21
- Maine 14
- Missouri 14
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502119 | 2502119 | 2022-05-13 | Carroll | Tennessee | 47017 | 8978 | 156 |
2502711 | 2502711 | 2022-05-13 | Mineral | West Virginia | 54057 | 7914 | 156 |
2498861 | 2498861 | 2022-05-12 | Carroll | Tennessee | 47017 | 8978 | 156 |
2499376 | 2499376 | 2022-05-12 | Warren | Virginia | 51187 | 8672 | 156 |
2499453 | 2499453 | 2022-05-12 | Mineral | West Virginia | 54057 | 7912 | 156 |
2495603 | 2495603 | 2022-05-11 | Carroll | Tennessee | 47017 | 8978 | 156 |
2496118 | 2496118 | 2022-05-11 | Warren | Virginia | 51187 | 8661 | 156 |
2496195 | 2496195 | 2022-05-11 | Mineral | West Virginia | 54057 | 7907 | 156 |
2490209 | 2490209 | 2022-05-10 | Butts | Georgia | 13035 | 6544 | 156 |
2490591 | 2490591 | 2022-05-10 | Wabash | Indiana | 18169 | 8745 | 156 |
2492345 | 2492345 | 2022-05-10 | Carroll | Tennessee | 47017 | 8972 | 156 |
2492860 | 2492860 | 2022-05-10 | Warren | Virginia | 51187 | 8655 | 156 |
2492937 | 2492937 | 2022-05-10 | Mineral | West Virginia | 54057 | 7902 | 156 |
2486952 | 2486952 | 2022-05-09 | Butts | Georgia | 13035 | 6544 | 156 |
2487334 | 2487334 | 2022-05-09 | Wabash | Indiana | 18169 | 8745 | 156 |
2489087 | 2489087 | 2022-05-09 | Carroll | Tennessee | 47017 | 8972 | 156 |
2489602 | 2489602 | 2022-05-09 | Warren | Virginia | 51187 | 8649 | 156 |
2489679 | 2489679 | 2022-05-09 | Mineral | West Virginia | 54057 | 7902 | 156 |
2483694 | 2483694 | 2022-05-08 | Butts | Georgia | 13035 | 6544 | 156 |
2484076 | 2484076 | 2022-05-08 | Wabash | Indiana | 18169 | 8736 | 156 |
2485830 | 2485830 | 2022-05-08 | Carroll | Tennessee | 47017 | 8972 | 156 |
2486345 | 2486345 | 2022-05-08 | Warren | Virginia | 51187 | 8632 | 156 |
2486422 | 2486422 | 2022-05-08 | Mineral | West Virginia | 54057 | 7893 | 156 |
2480436 | 2480436 | 2022-05-07 | Butts | Georgia | 13035 | 6544 | 156 |
2480818 | 2480818 | 2022-05-07 | Wabash | Indiana | 18169 | 8736 | 156 |
2482572 | 2482572 | 2022-05-07 | Carroll | Tennessee | 47017 | 8972 | 156 |
2483087 | 2483087 | 2022-05-07 | Warren | Virginia | 51187 | 8632 | 156 |
2483164 | 2483164 | 2022-05-07 | Mineral | West Virginia | 54057 | 7893 | 156 |
2477178 | 2477178 | 2022-05-06 | Butts | Georgia | 13035 | 6544 | 156 |
2477560 | 2477560 | 2022-05-06 | Wabash | Indiana | 18169 | 8736 | 156 |
2479314 | 2479314 | 2022-05-06 | Carroll | Tennessee | 47017 | 8972 | 156 |
2479829 | 2479829 | 2022-05-06 | Warren | Virginia | 51187 | 8632 | 156 |
2479906 | 2479906 | 2022-05-06 | Mineral | West Virginia | 54057 | 7893 | 156 |
2473920 | 2473920 | 2022-05-05 | Butts | Georgia | 13035 | 6544 | 156 |
2474302 | 2474302 | 2022-05-05 | Wabash | Indiana | 18169 | 8736 | 156 |
2476056 | 2476056 | 2022-05-05 | Carroll | Tennessee | 47017 | 8972 | 156 |
2476571 | 2476571 | 2022-05-05 | Warren | Virginia | 51187 | 8627 | 156 |
2476648 | 2476648 | 2022-05-05 | Mineral | West Virginia | 54057 | 7892 | 156 |
2470663 | 2470663 | 2022-05-04 | Butts | Georgia | 13035 | 6544 | 156 |
2471045 | 2471045 | 2022-05-04 | Wabash | Indiana | 18169 | 8736 | 156 |
2472392 | 2472392 | 2022-05-04 | Putnam | Ohio | 39137 | 8465 | 156 |
2472799 | 2472799 | 2022-05-04 | Carroll | Tennessee | 47017 | 8972 | 156 |
2473313 | 2473313 | 2022-05-04 | Warren | Virginia | 51187 | 8619 | 156 |
2473390 | 2473390 | 2022-05-04 | Mineral | West Virginia | 54057 | 7890 | 156 |
2467789 | 2467789 | 2022-05-03 | Wabash | Indiana | 18169 | 8732 | 156 |
2469136 | 2469136 | 2022-05-03 | Putnam | Ohio | 39137 | 8465 | 156 |
2469543 | 2469543 | 2022-05-03 | Carroll | Tennessee | 47017 | 8963 | 156 |
2470057 | 2470057 | 2022-05-03 | Warren | Virginia | 51187 | 8611 | 156 |
2470133 | 2470133 | 2022-05-03 | Mineral | West Virginia | 54057 | 7889 | 156 |
2464534 | 2464534 | 2022-05-02 | Wabash | Indiana | 18169 | 8732 | 156 |
2465880 | 2465880 | 2022-05-02 | Putnam | Ohio | 39137 | 8465 | 156 |
2466287 | 2466287 | 2022-05-02 | Carroll | Tennessee | 47017 | 8963 | 156 |
2466801 | 2466801 | 2022-05-02 | Warren | Virginia | 51187 | 8608 | 156 |
2466877 | 2466877 | 2022-05-02 | Mineral | West Virginia | 54057 | 7889 | 156 |
2461278 | 2461278 | 2022-05-01 | Wabash | Indiana | 18169 | 8730 | 156 |
2462625 | 2462625 | 2022-05-01 | Putnam | Ohio | 39137 | 8465 | 156 |
2463032 | 2463032 | 2022-05-01 | Carroll | Tennessee | 47017 | 8963 | 156 |
2463546 | 2463546 | 2022-05-01 | Warren | Virginia | 51187 | 8604 | 156 |
2463622 | 2463622 | 2022-05-01 | Mineral | West Virginia | 54057 | 7886 | 156 |
2458022 | 2458022 | 2022-04-30 | Wabash | Indiana | 18169 | 8730 | 156 |
2459369 | 2459369 | 2022-04-30 | Putnam | Ohio | 39137 | 8465 | 156 |
2459776 | 2459776 | 2022-04-30 | Carroll | Tennessee | 47017 | 8963 | 156 |
2460290 | 2460290 | 2022-04-30 | Warren | Virginia | 51187 | 8604 | 156 |
2460366 | 2460366 | 2022-04-30 | Mineral | West Virginia | 54057 | 7886 | 156 |
2454766 | 2454766 | 2022-04-29 | Wabash | Indiana | 18169 | 8730 | 156 |
2456113 | 2456113 | 2022-04-29 | Putnam | Ohio | 39137 | 8465 | 156 |
2456520 | 2456520 | 2022-04-29 | Carroll | Tennessee | 47017 | 8963 | 156 |
2457034 | 2457034 | 2022-04-29 | Warren | Virginia | 51187 | 8604 | 156 |
2457110 | 2457110 | 2022-04-29 | Mineral | West Virginia | 54057 | 7886 | 156 |
2451510 | 2451510 | 2022-04-28 | Wabash | Indiana | 18169 | 8728 | 156 |
2452857 | 2452857 | 2022-04-28 | Putnam | Ohio | 39137 | 8465 | 156 |
2453264 | 2453264 | 2022-04-28 | Carroll | Tennessee | 47017 | 8963 | 156 |
2453778 | 2453778 | 2022-04-28 | Warren | Virginia | 51187 | 8599 | 156 |
2453854 | 2453854 | 2022-04-28 | Mineral | West Virginia | 54057 | 7886 | 156 |
2448254 | 2448254 | 2022-04-27 | Wabash | Indiana | 18169 | 8728 | 156 |
2449601 | 2449601 | 2022-04-27 | Putnam | Ohio | 39137 | 8462 | 156 |
2450008 | 2450008 | 2022-04-27 | Carroll | Tennessee | 47017 | 8963 | 156 |
2450522 | 2450522 | 2022-04-27 | Warren | Virginia | 51187 | 8592 | 156 |
2450598 | 2450598 | 2022-04-27 | Mineral | West Virginia | 54057 | 7883 | 156 |
2444653 | 2444653 | 2022-04-26 | Fannin | Georgia | 13111 | 5129 | 156 |
2444998 | 2444998 | 2022-04-26 | Wabash | Indiana | 18169 | 8724 | 156 |
2445471 | 2445471 | 2022-04-26 | Clare | Michigan | 26035 | 6748 | 156 |
2446344 | 2446344 | 2022-04-26 | Putnam | Ohio | 39137 | 8462 | 156 |
2446751 | 2446751 | 2022-04-26 | Carroll | Tennessee | 47017 | 8957 | 156 |
2447266 | 2447266 | 2022-04-26 | Warren | Virginia | 51187 | 8592 | 156 |
2447342 | 2447342 | 2022-04-26 | Mineral | West Virginia | 54057 | 7882 | 156 |
2441397 | 2441397 | 2022-04-25 | Fannin | Georgia | 13111 | 5129 | 156 |
2441742 | 2441742 | 2022-04-25 | Wabash | Indiana | 18169 | 8724 | 156 |
2442215 | 2442215 | 2022-04-25 | Clare | Michigan | 26035 | 6748 | 156 |
2443089 | 2443089 | 2022-04-25 | Putnam | Ohio | 39137 | 8462 | 156 |
2443496 | 2443496 | 2022-04-25 | Carroll | Tennessee | 47017 | 8957 | 156 |
2444086 | 2444086 | 2022-04-25 | Mineral | West Virginia | 54057 | 7880 | 156 |
2438141 | 2438141 | 2022-04-24 | Fannin | Georgia | 13111 | 5130 | 156 |
2438486 | 2438486 | 2022-04-24 | Wabash | Indiana | 18169 | 8719 | 156 |
2438959 | 2438959 | 2022-04-24 | Clare | Michigan | 26035 | 6748 | 156 |
2439833 | 2439833 | 2022-04-24 | Putnam | Ohio | 39137 | 8462 | 156 |
2440240 | 2440240 | 2022-04-24 | Carroll | Tennessee | 47017 | 8957 | 156 |
2440830 | 2440830 | 2022-04-24 | Mineral | West Virginia | 54057 | 7875 | 156 |
2434885 | 2434885 | 2022-04-23 | Fannin | Georgia | 13111 | 5130 | 156 |
2435230 | 2435230 | 2022-04-23 | Wabash | Indiana | 18169 | 8719 | 156 |
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);