ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
108 rows where deaths = 944 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 25
- Florida 10
- New York 10
- South Carolina 10
- Kansas 8
- Michigan 7
- New Jersey 7
- Pennsylvania 7
- Minnesota 6
- Alabama 5
- Ohio 5
- Colorado 4
- Georgia 4
- Illinois 4
- Missouri 4
- Maryland 3
- Washington 3
- California 2
- Texas 2
- Arkansas 1
- Indiana 1
- Louisiana 1
- New Mexico 1
- Oregon 1
- Tennessee 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492234 | 2492234 | 2022-05-10 | Charleston | South Carolina | 45019 | 112523 | 944 |
2488976 | 2488976 | 2022-05-09 | Charleston | South Carolina | 45019 | 112523 | 944 |
2485719 | 2485719 | 2022-05-08 | Charleston | South Carolina | 45019 | 112523 | 944 |
2482461 | 2482461 | 2022-05-07 | Charleston | South Carolina | 45019 | 112523 | 944 |
2479203 | 2479203 | 2022-05-06 | Charleston | South Carolina | 45019 | 112523 | 944 |
2475945 | 2475945 | 2022-05-05 | Charleston | South Carolina | 45019 | 112523 | 944 |
2472688 | 2472688 | 2022-05-04 | Charleston | South Carolina | 45019 | 112523 | 944 |
2469432 | 2469432 | 2022-05-03 | Charleston | South Carolina | 45019 | 112523 | 944 |
2418210 | 2418210 | 2022-04-18 | Montgomery | Alabama | 1101 | 54812 | 944 |
2414954 | 2414954 | 2022-04-17 | Montgomery | Alabama | 1101 | 54812 | 944 |
2411698 | 2411698 | 2022-04-16 | Montgomery | Alabama | 1101 | 54812 | 944 |
2408442 | 2408442 | 2022-04-15 | Montgomery | Alabama | 1101 | 54812 | 944 |
2377156 | 2377156 | 2022-04-05 | Saginaw | Michigan | 26145 | 50290 | 944 |
2373904 | 2373904 | 2022-04-04 | Saginaw | Michigan | 26145 | 50290 | 944 |
2370651 | 2370651 | 2022-04-03 | Saginaw | Michigan | 26145 | 50290 | 944 |
2367398 | 2367398 | 2022-04-02 | Saginaw | Michigan | 26145 | 50290 | 944 |
2364145 | 2364145 | 2022-04-01 | Saginaw | Michigan | 26145 | 50290 | 944 |
2349860 | 2349860 | 2022-03-28 | Madison | Alabama | 1089 | 88988 | 944 |
2328926 | 2328926 | 2022-03-21 | Orange | New York | 36071 | 105944 | 944 |
2325674 | 2325674 | 2022-03-20 | Orange | New York | 36071 | 105931 | 944 |
2322421 | 2322421 | 2022-03-19 | Orange | New York | 36071 | 105904 | 944 |
2319167 | 2319167 | 2022-03-18 | Orange | New York | 36071 | 105885 | 944 |
2315913 | 2315913 | 2022-03-17 | Orange | New York | 36071 | 105830 | 944 |
2312660 | 2312660 | 2022-03-16 | Orange | New York | 36071 | 105823 | 944 |
2307855 | 2307855 | 2022-03-15 | Citrus | Florida | 12017 | 29404 | 944 |
2309407 | 2309407 | 2022-03-15 | Orange | New York | 36071 | 105791 | 944 |
2304604 | 2304604 | 2022-03-14 | Citrus | Florida | 12017 | 29404 | 944 |
2306154 | 2306154 | 2022-03-14 | Orange | New York | 36071 | 105775 | 944 |
2301352 | 2301352 | 2022-03-13 | Citrus | Florida | 12017 | 29404 | 944 |
2302903 | 2302903 | 2022-03-13 | Orange | New York | 36071 | 105761 | 944 |
2298100 | 2298100 | 2022-03-12 | Citrus | Florida | 12017 | 29404 | 944 |
2300058 | 2300058 | 2022-03-12 | Dauphin | Pennsylvania | 42043 | 58887 | 944 |
2294848 | 2294848 | 2022-03-11 | Citrus | Florida | 12017 | 29404 | 944 |
2291596 | 2291596 | 2022-03-10 | Citrus | Florida | 12017 | 29347 | 944 |
2288344 | 2288344 | 2022-03-09 | Citrus | Florida | 12017 | 29347 | 944 |
2260854 | 2260854 | 2022-02-28 | Lorain | Ohio | 39093 | 66152 | 944 |
2257603 | 2257603 | 2022-02-27 | Lorain | Ohio | 39093 | 66143 | 944 |
2254352 | 2254352 | 2022-02-26 | Lorain | Ohio | 39093 | 66122 | 944 |
2251101 | 2251101 | 2022-02-25 | Lorain | Ohio | 39093 | 66103 | 944 |
2247276 | 2247276 | 2022-02-24 | Greene | Missouri | 29077 | 70409 | 944 |
2209372 | 2209372 | 2022-02-12 | Brazoria | Texas | 48039 | 91583 | 944 |
2202012 | 2202012 | 2022-02-10 | Atlantic | New Jersey | 34001 | 67169 | 944 |
2193681 | 2193681 | 2022-02-07 | Waukesha | Wisconsin | 55133 | 109277 | 944 |
2179257 | 2179257 | 2022-02-03 | Somerset | New Jersey | 34035 | 65022 | 944 |
2147169 | 2147169 | 2022-01-24 | Multnomah | Oregon | 41051 | 97106 | 944 |
2140283 | 2140283 | 2022-01-22 | Onondaga | New York | 36067 | 97726 | 944 |
2105070 | 2105070 | 2022-01-11 | Horry | South Carolina | 45051 | 73779 | 944 |
2043142 | 2043142 | 2021-12-23 | Chester | Pennsylvania | 42029 | 62064 | 944 |
2015565 | 2015565 | 2021-12-15 | Allen | Indiana | 18003 | 70725 | 944 |
2008527 | 2008527 | 2021-12-13 | Pulaski | Arkansas | 5119 | 61005 | 944 |
1939932 | 1939932 | 2021-11-21 | Pierce | Washington | 53053 | 97233 | 944 |
1936682 | 1936682 | 2021-11-20 | Pierce | Washington | 53053 | 97233 | 944 |
1933432 | 1933432 | 2021-11-19 | Pierce | Washington | 53053 | 97233 | 944 |
1924088 | 1924088 | 2021-11-17 | Adams | Colorado | 8001 | 82882 | 944 |
1904992 | 1904992 | 2021-11-11 | Kane | Illinois | 17089 | 70234 | 944 |
1901742 | 1901742 | 2021-11-10 | Kane | Illinois | 17089 | 70234 | 944 |
1892288 | 1892288 | 2021-11-07 | Johnson | Kansas | 20091 | 78852 | 944 |
1889038 | 1889038 | 2021-11-06 | Johnson | Kansas | 20091 | 78852 | 944 |
1885788 | 1885788 | 2021-11-05 | Johnson | Kansas | 20091 | 78852 | 944 |
1883900 | 1883900 | 2021-11-04 | Lehigh | Pennsylvania | 42077 | 48932 | 944 |
1875360 | 1875360 | 2021-11-02 | Denver | Colorado | 8031 | 93244 | 944 |
1872111 | 1872111 | 2021-11-01 | Denver | Colorado | 8031 | 93034 | 944 |
1844402 | 1844402 | 2021-10-23 | Burlington | New Jersey | 34005 | 54279 | 944 |
1841152 | 1841152 | 2021-10-22 | Burlington | New Jersey | 34005 | 54194 | 944 |
1810357 | 1810357 | 2021-10-13 | Tulare | California | 6107 | 78346 | 944 |
1801351 | 1801351 | 2021-10-10 | Sedgwick | Kansas | 20173 | 78336 | 944 |
1798102 | 1798102 | 2021-10-09 | Sedgwick | Kansas | 20173 | 78336 | 944 |
1794853 | 1794853 | 2021-10-08 | Sedgwick | Kansas | 20173 | 78336 | 944 |
1791605 | 1791605 | 2021-10-07 | Sedgwick | Kansas | 20173 | 77798 | 944 |
1788356 | 1788356 | 2021-10-06 | Sedgwick | Kansas | 20173 | 77798 | 944 |
1733527 | 1733527 | 2021-09-19 | Ramsey | Minnesota | 27123 | 58542 | 944 |
1730277 | 1730277 | 2021-09-18 | Ramsey | Minnesota | 27123 | 58542 | 944 |
1727027 | 1727027 | 2021-09-17 | Ramsey | Minnesota | 27123 | 58542 | 944 |
1677174 | 1677174 | 2021-09-02 | El Paso | Colorado | 8041 | 83187 | 944 |
1580604 | 1580604 | 2021-08-03 | Jefferson | Louisiana | 22051 | 54658 | 944 |
1379996 | 1379996 | 2021-06-02 | Bernalillo | New Mexico | 35001 | 58514 | 944 |
1359975 | 1359975 | 2021-05-27 | Genesee | Michigan | 26049 | 41539 | 944 |
1337782 | 1337782 | 2021-05-20 | Mercer | New Jersey | 34021 | 33768 | 944 |
1334535 | 1334535 | 2021-05-19 | Mercer | New Jersey | 34021 | 33744 | 944 |
1332032 | 1332032 | 2021-05-18 | Davidson | Tennessee | 47037 | 98937 | 944 |
1238942 | 1238942 | 2021-04-20 | Marion | Florida | 12083 | 30115 | 944 |
1235689 | 1235689 | 2021-04-19 | Lee | Florida | 12071 | 66759 | 944 |
1232442 | 1232442 | 2021-04-18 | Lee | Florida | 12071 | 66553 | 944 |
1214867 | 1214867 | 2021-04-12 | Berks | Pennsylvania | 42011 | 41991 | 944 |
1211620 | 1211620 | 2021-04-11 | Berks | Pennsylvania | 42011 | 41900 | 944 |
1208371 | 1208371 | 2021-04-10 | Berks | Pennsylvania | 42011 | 41773 | 944 |
1193541 | 1193541 | 2021-04-06 | DeKalb | Georgia | 13089 | 62332 | 944 |
1190291 | 1190291 | 2021-04-05 | DeKalb | Georgia | 13089 | 62221 | 944 |
1187044 | 1187044 | 2021-04-04 | DeKalb | Georgia | 13089 | 62100 | 944 |
1183797 | 1183797 | 2021-04-03 | DeKalb | Georgia | 13089 | 62028 | 944 |
1174830 | 1174830 | 2021-03-31 | Baltimore city | Maryland | 24510 | 44651 | 944 |
1171583 | 1171583 | 2021-03-30 | Baltimore city | Maryland | 24510 | 44412 | 944 |
1172814 | 1172814 | 2021-03-30 | Greenville | South Carolina | 45045 | 69241 | 944 |
1063478 | 1063478 | 2021-02-25 | Stanislaus | California | 6099 | 55775 | 944 |
1058842 | 1058842 | 2021-02-23 | Hamilton | Ohio | 39061 | 72486 | 944 |
1000627 | 1000627 | 2021-02-05 | Lancaster | Pennsylvania | 42071 | 39492 | 944 |
985994 | 985994 | 2021-02-01 | Lake | Illinois | 17097 | 56107 | 944 |
843173 | 843173 | 2020-12-19 | DuPage | Illinois | 17043 | 57421 | 944 |
772370 | 772370 | 2020-11-27 | Montgomery | Maryland | 24031 | 32643 | 944 |
759770 | 759770 | 2020-11-23 | St. Louis | Missouri | 29189 | 46954 | 944 |
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);