ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
76 rows where deaths = 1034 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 25
- Texas 14
- Washington 7
- Ohio 6
- Massachusetts 4
- New Jersey 4
- New York 4
- Indiana 3
- Michigan 3
- Nebraska 3
- North Carolina 3
- Pennsylvania 3
- South Carolina 3
- Virginia 3
- Connecticut 2
- Florida 2
- Louisiana 2
- Maryland 2
- Alabama 1
- Arizona 1
- Arkansas 1
- Illinois 1
- Kentucky 1
- Minnesota 1
- Tennessee 1
- Utah 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2466614 | 2466614 | 2022-05-02 | Webb | Texas | 48479 | 95230 | 1034 |
2463359 | 2463359 | 2022-05-01 | Webb | Texas | 48479 | 94121 | 1034 |
2460103 | 2460103 | 2022-04-30 | Webb | Texas | 48479 | 93916 | 1034 |
2456847 | 2456847 | 2022-04-29 | Webb | Texas | 48479 | 93869 | 1034 |
2453591 | 2453591 | 2022-04-28 | Webb | Texas | 48479 | 93823 | 1034 |
2450335 | 2450335 | 2022-04-27 | Webb | Texas | 48479 | 93776 | 1034 |
2447078 | 2447078 | 2022-04-26 | Webb | Texas | 48479 | 93714 | 1034 |
2247853 | 2247853 | 2022-02-24 | Mahoning | Ohio | 39099 | 53008 | 1034 |
2244602 | 2244602 | 2022-02-23 | Mahoning | Ohio | 39099 | 52992 | 1034 |
2241351 | 2241351 | 2022-02-22 | Mahoning | Ohio | 39099 | 52981 | 1034 |
2242330 | 2242330 | 2022-02-22 | Snohomish | Washington | 53061 | 145694 | 1034 |
2239079 | 2239079 | 2022-02-21 | Snohomish | Washington | 53061 | 145694 | 1034 |
2235828 | 2235828 | 2022-02-20 | Snohomish | Washington | 53061 | 145694 | 1034 |
2232577 | 2232577 | 2022-02-19 | Snohomish | Washington | 53061 | 145694 | 1034 |
2229326 | 2229326 | 2022-02-18 | Snohomish | Washington | 53061 | 145694 | 1034 |
2219044 | 2219044 | 2022-02-15 | Hamilton | Tennessee | 47065 | 96473 | 1034 |
2211676 | 2211676 | 2022-02-13 | Douglas | Nebraska | 31055 | 140803 | 1034 |
2208423 | 2208423 | 2022-02-12 | Douglas | Nebraska | 31055 | 140803 | 1034 |
2205170 | 2205170 | 2022-02-11 | Douglas | Nebraska | 31055 | 140803 | 1034 |
2202534 | 2202534 | 2022-02-10 | Northampton | Pennsylvania | 42095 | 77993 | 1034 |
2174365 | 2174365 | 2022-02-02 | Pulaski | Arkansas | 5119 | 98123 | 1034 |
2138512 | 2138512 | 2022-01-22 | Yavapai | Arizona | 4025 | 41871 | 1034 |
2105714 | 2105714 | 2022-01-11 | Pierce | Washington | 53053 | 133208 | 1034 |
2102463 | 2102463 | 2022-01-10 | Pierce | Washington | 53053 | 131637 | 1034 |
1974405 | 1974405 | 2021-12-02 | Mercer | New Jersey | 34021 | 41999 | 1034 |
1944734 | 1944734 | 2021-11-23 | Ramsey | Minnesota | 27123 | 71727 | 1034 |
1913531 | 1913531 | 2021-11-13 | Denton | Texas | 48121 | 109169 | 1034 |
1778893 | 1778893 | 2021-10-03 | Genesee | Michigan | 26049 | 47709 | 1034 |
1775643 | 1775643 | 2021-10-02 | Genesee | Michigan | 26049 | 47709 | 1034 |
1772393 | 1772393 | 2021-10-01 | Genesee | Michigan | 26049 | 47709 | 1034 |
1722036 | 1722036 | 2021-09-15 | Salt Lake | Utah | 49035 | 176831 | 1034 |
1673711 | 1673711 | 2021-09-01 | Mobile | Alabama | 1097 | 64054 | 1034 |
1674800 | 1674800 | 2021-09-01 | East Baton Rouge | Louisiana | 22033 | 59282 | 1034 |
1674809 | 1674809 | 2021-09-01 | Jefferson | Louisiana | 22051 | 66158 | 1034 |
1665884 | 1665884 | 2021-08-29 | Mecklenburg | North Carolina | 37119 | 133843 | 1034 |
1662636 | 1662636 | 2021-08-28 | Mecklenburg | North Carolina | 37119 | 133843 | 1034 |
1659388 | 1659388 | 2021-08-27 | Mecklenburg | North Carolina | 37119 | 133843 | 1034 |
1474740 | 1474740 | 2021-07-01 | Greenville | South Carolina | 45045 | 75688 | 1034 |
1471494 | 1471494 | 2021-06-30 | Greenville | South Carolina | 45045 | 75672 | 1034 |
1468249 | 1468249 | 2021-06-29 | Greenville | South Carolina | 45045 | 75661 | 1034 |
1445945 | 1445945 | 2021-06-22 | Travis | Texas | 48453 | 84383 | 1034 |
1442700 | 1442700 | 2021-06-21 | Travis | Texas | 48453 | 84344 | 1034 |
1439455 | 1439455 | 2021-06-20 | Travis | Texas | 48453 | 84344 | 1034 |
1436208 | 1436208 | 2021-06-19 | Travis | Texas | 48453 | 84344 | 1034 |
1432961 | 1432961 | 2021-06-18 | Travis | Texas | 48453 | 84344 | 1034 |
1362705 | 1362705 | 2021-05-28 | Lake | Indiana | 18089 | 54985 | 1034 |
1359458 | 1359458 | 2021-05-27 | Lake | Indiana | 18089 | 54945 | 1034 |
1352966 | 1352966 | 2021-05-25 | Lake | Indiana | 18089 | 54829 | 1034 |
1275502 | 1275502 | 2021-05-01 | Baltimore city | Maryland | 24510 | 51108 | 1034 |
1233957 | 1233957 | 2021-04-18 | Monroe | New York | 36055 | 61115 | 1034 |
1230709 | 1230709 | 2021-04-17 | Monroe | New York | 36055 | 60882 | 1034 |
1227461 | 1227461 | 2021-04-16 | Monroe | New York | 36055 | 60529 | 1034 |
1222991 | 1222991 | 2021-04-15 | Lake | Illinois | 17097 | 64180 | 1034 |
1224213 | 1224213 | 2021-04-15 | Monroe | New York | 36055 | 60326 | 1034 |
1160348 | 1160348 | 2021-03-26 | Fairfax | Virginia | 51059 | 70678 | 1034 |
1157100 | 1157100 | 2021-03-25 | Fairfax | Virginia | 51059 | 70426 | 1034 |
1150606 | 1150606 | 2021-03-23 | Fairfax | Virginia | 51059 | 70096 | 1034 |
1145453 | 1145453 | 2021-03-22 | Jefferson | Kentucky | 21111 | 76931 | 1034 |
1088051 | 1088051 | 2021-03-04 | Hamilton | Ohio | 39061 | 73684 | 1034 |
1084806 | 1084806 | 2021-03-03 | Hamilton | Ohio | 39061 | 73572 | 1034 |
1081560 | 1081560 | 2021-03-02 | Hamilton | Ohio | 39061 | 73415 | 1034 |
1081767 | 1081767 | 2021-03-02 | Lancaster | Pennsylvania | 42071 | 43809 | 1034 |
977876 | 977876 | 2021-01-29 | Bucks | Pennsylvania | 42017 | 39657 | 1034 |
954695 | 954695 | 2021-01-22 | Morris | New Jersey | 34027 | 29478 | 1034 |
849392 | 849392 | 2020-12-21 | Hillsborough | Florida | 12057 | 70849 | 1034 |
830786 | 830786 | 2020-12-15 | Montgomery | Maryland | 24031 | 40106 | 1034 |
605105 | 605105 | 2020-10-06 | Cameron | Texas | 48061 | 23084 | 1034 |
535657 | 535657 | 2020-09-15 | Norfolk | Massachusetts | 25021 | 9864 | 1034 |
532422 | 532422 | 2020-09-14 | Norfolk | Massachusetts | 25021 | 9845 | 1034 |
523276 | 523276 | 2020-09-11 | Ocean | New Jersey | 34029 | 11719 | 1034 |
520039 | 520039 | 2020-09-10 | Ocean | New Jersey | 34029 | 11662 | 1034 |
454835 | 454835 | 2020-08-21 | Worcester | Massachusetts | 25027 | 13941 | 1034 |
451607 | 451607 | 2020-08-20 | Worcester | Massachusetts | 25027 | 13890 | 1034 |
296896 | 296896 | 2020-07-03 | Miami-Dade | Florida | 12086 | 42310 | 1034 |
231117 | 231117 | 2020-06-12 | New Haven | Connecticut | 9009 | 11979 | 1034 |
133521 | 133521 | 2020-05-11 | Fairfield | Connecticut | 9001 | 13312 | 1034 |
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);