ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
65 rows where deaths = 1124 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 22
- Virginia 8
- Oklahoma 7
- Georgia 6
- Colorado 4
- Illinois 4
- Massachusetts 4
- Pennsylvania 4
- Texas 4
- New Jersey 3
- Ohio 3
- California 2
- Florida 2
- Kansas 2
- Louisiana 2
- Maryland 2
- New York 2
- Alabama 1
- Arkansas 1
- District of Columbia 1
- Indiana 1
- New Mexico 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2311907 | 2311907 | 2022-03-16 | Caddo | Louisiana | 22017 | 67123 | 1124 |
2287043 | 2287043 | 2022-03-08 | Chester | Pennsylvania | 42029 | 90850 | 1124 |
2265416 | 2265416 | 2022-03-02 | Pulaski | Arkansas | 5119 | 101901 | 1124 |
2194653 | 2194653 | 2022-02-08 | Johnson | Kansas | 20091 | 140035 | 1124 |
2191399 | 2191399 | 2022-02-07 | Johnson | Kansas | 20091 | 140035 | 1124 |
2128076 | 2128076 | 2022-01-18 | Denton | Texas | 48121 | 144701 | 1124 |
2111907 | 2111907 | 2022-01-13 | Lubbock | Texas | 48303 | 81551 | 1124 |
2096400 | 2096400 | 2022-01-09 | Jefferson | Colorado | 8059 | 88641 | 1124 |
2093148 | 2093148 | 2022-01-08 | Jefferson | Colorado | 8059 | 88641 | 1124 |
2089896 | 2089896 | 2022-01-07 | Jefferson | Colorado | 8059 | 88641 | 1124 |
1906483 | 1906483 | 2021-11-11 | Stark | Ohio | 39151 | 49014 | 1124 |
1903234 | 1903234 | 2021-11-10 | Stark | Ohio | 39151 | 48876 | 1124 |
1899984 | 1899984 | 2021-11-09 | Stark | Ohio | 39151 | 48707 | 1124 |
1872115 | 1872115 | 2021-11-01 | El Paso | Colorado | 8041 | 103484 | 1124 |
1873665 | 1873665 | 2021-11-01 | Bernalillo | New Mexico | 35001 | 77181 | 1124 |
1828631 | 1828631 | 2021-10-18 | Berks | Pennsylvania | 42011 | 57123 | 1124 |
1765774 | 1765774 | 2021-09-29 | Jefferson | Louisiana | 22051 | 68382 | 1124 |
1742128 | 1742128 | 2021-09-22 | Ventura | California | 6111 | 98017 | 1124 |
1719791 | 1719791 | 2021-09-15 | Lake | Illinois | 17097 | 76122 | 1124 |
1716642 | 1716642 | 2021-09-14 | Lake | Indiana | 18089 | 62254 | 1124 |
1709448 | 1709448 | 2021-09-12 | Mobile | Alabama | 1097 | 68902 | 1124 |
1639804 | 1639804 | 2021-08-21 | Monroe | New York | 36055 | 72552 | 1124 |
1636554 | 1636554 | 2021-08-20 | Monroe | New York | 36055 | 72377 | 1124 |
1628886 | 1628886 | 2021-08-18 | Will | Illinois | 17197 | 81220 | 1124 |
1625639 | 1625639 | 2021-08-17 | Will | Illinois | 17197 | 81033 | 1124 |
1622392 | 1622392 | 2021-08-16 | Will | Illinois | 17197 | 80864 | 1124 |
1576632 | 1576632 | 2021-08-02 | Cobb | Georgia | 13067 | 83692 | 1124 |
1573384 | 1573384 | 2021-08-01 | Cobb | Georgia | 13067 | 83362 | 1124 |
1570136 | 1570136 | 2021-07-31 | Cobb | Georgia | 13067 | 83362 | 1124 |
1566888 | 1566888 | 2021-07-30 | Cobb | Georgia | 13067 | 83362 | 1124 |
1563640 | 1563640 | 2021-07-29 | Cobb | Georgia | 13067 | 83219 | 1124 |
1543450 | 1543450 | 2021-07-22 | Fairfax | Virginia | 51059 | 77754 | 1124 |
1540202 | 1540202 | 2021-07-21 | Fairfax | Virginia | 51059 | 77680 | 1124 |
1536955 | 1536955 | 2021-07-20 | Fairfax | Virginia | 51059 | 77612 | 1124 |
1533707 | 1533707 | 2021-07-19 | Fairfax | Virginia | 51059 | 77569 | 1124 |
1530460 | 1530460 | 2021-07-18 | Fairfax | Virginia | 51059 | 77465 | 1124 |
1527213 | 1527213 | 2021-07-17 | Fairfax | Virginia | 51059 | 77465 | 1124 |
1523966 | 1523966 | 2021-07-16 | Fairfax | Virginia | 51059 | 77465 | 1124 |
1520718 | 1520718 | 2021-07-15 | Fairfax | Virginia | 51059 | 77419 | 1124 |
1495415 | 1495415 | 2021-07-08 | Unknown | Florida | 13173 | 1124 | |
1468032 | 1468032 | 2021-06-29 | Tulsa | Oklahoma | 40143 | 76043 | 1124 |
1464787 | 1464787 | 2021-06-28 | Tulsa | Oklahoma | 40143 | 76043 | 1124 |
1461542 | 1461542 | 2021-06-27 | Tulsa | Oklahoma | 40143 | 76043 | 1124 |
1458297 | 1458297 | 2021-06-26 | Tulsa | Oklahoma | 40143 | 76043 | 1124 |
1455052 | 1455052 | 2021-06-25 | Tulsa | Oklahoma | 40143 | 76043 | 1124 |
1451807 | 1451807 | 2021-06-24 | Tulsa | Oklahoma | 40143 | 76043 | 1124 |
1448561 | 1448561 | 2021-06-23 | Tulsa | Oklahoma | 40143 | 76043 | 1124 |
1353422 | 1353422 | 2021-05-25 | Baltimore city | Maryland | 24510 | 52772 | 1124 |
1333056 | 1333056 | 2021-05-19 | District of Columbia | District of Columbia | 11001 | 48634 | 1124 |
1309059 | 1309059 | 2021-05-11 | Lancaster | Pennsylvania | 42071 | 54211 | 1124 |
1248777 | 1248777 | 2021-04-23 | Gwinnett | Georgia | 13135 | 99977 | 1124 |
1092822 | 1092822 | 2021-03-06 | Orange | Florida | 12095 | 116128 | 1124 |
1081274 | 1081274 | 2021-03-02 | Morris | New Jersey | 34027 | 37892 | 1124 |
1058546 | 1058546 | 2021-02-23 | Camden | New Jersey | 34007 | 43503 | 1124 |
954130 | 954130 | 2021-01-22 | Plymouth | Massachusetts | 25023 | 33371 | 1124 |
931407 | 931407 | 2021-01-15 | Hampden | Massachusetts | 25013 | 32211 | 1124 |
923510 | 923510 | 2021-01-12 | King | Washington | 53033 | 70547 | 1124 |
882710 | 882710 | 2020-12-31 | Montgomery | Maryland | 24031 | 46243 | 1124 |
877309 | 877309 | 2020-12-29 | Montgomery | Pennsylvania | 42091 | 35086 | 1124 |
776202 | 776202 | 2020-11-28 | Ocean | New Jersey | 34029 | 21525 | 1124 |
745409 | 745409 | 2020-11-19 | San Bernardino | California | 6071 | 80318 | 1124 |
603696 | 603696 | 2020-10-06 | Worcester | Massachusetts | 25027 | 14791 | 1124 |
579201 | 579201 | 2020-09-28 | Dallas | Texas | 48113 | 85410 | 1124 |
575960 | 575960 | 2020-09-27 | Dallas | Texas | 48113 | 85099 | 1124 |
545369 | 545369 | 2020-09-18 | Suffolk | Massachusetts | 25025 | 23552 | 1124 |
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);