ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where deaths = 1049 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 17
- Florida 10
- Pennsylvania 6
- South Carolina 6
- Kansas 5
- New Jersey 5
- Louisiana 4
- Tennessee 4
- Ohio 3
- Texas 3
- Georgia 2
- Illinois 2
- Indiana 2
- Virginia 2
- Alabama 1
- Arizona 1
- District of Columbia 1
- New York 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2429812 | 2429812 | 2022-04-21 | Onondaga | New York | 36067 | 117302 | 1049 |
2188334 | 2188334 | 2022-02-06 | Caddo | Louisiana | 22017 | 65555 | 1049 |
2185081 | 2185081 | 2022-02-05 | Caddo | Louisiana | 22017 | 65555 | 1049 |
2181829 | 2181829 | 2022-02-04 | Caddo | Louisiana | 22017 | 65555 | 1049 |
2126330 | 2126330 | 2022-01-18 | Johnson | Kansas | 20091 | 114647 | 1049 |
2123078 | 2123078 | 2022-01-17 | Johnson | Kansas | 20091 | 114647 | 1049 |
2119826 | 2119826 | 2022-01-16 | Johnson | Kansas | 20091 | 114647 | 1049 |
2116574 | 2116574 | 2022-01-15 | Johnson | Kansas | 20091 | 114647 | 1049 |
2113323 | 2113323 | 2022-01-14 | Johnson | Kansas | 20091 | 114647 | 1049 |
2078918 | 2078918 | 2022-01-03 | Lehigh | Pennsylvania | 42077 | 66613 | 1049 |
2053188 | 2053188 | 2021-12-26 | Knox | Tennessee | 47093 | 83647 | 1049 |
2049938 | 2049938 | 2021-12-25 | Knox | Tennessee | 47093 | 83647 | 1049 |
2046688 | 2046688 | 2021-12-24 | Knox | Tennessee | 47093 | 83647 | 1049 |
2043167 | 2043167 | 2021-12-23 | Luzerne | Pennsylvania | 42079 | 50896 | 1049 |
2043438 | 2043438 | 2021-12-23 | Knox | Tennessee | 47093 | 83647 | 1049 |
2013411 | 2013411 | 2021-12-14 | Mercer | New Jersey | 34021 | 43744 | 1049 |
2010160 | 2010160 | 2021-12-13 | Mercer | New Jersey | 34021 | 43619 | 1049 |
1968880 | 1968880 | 2021-11-30 | Lubbock | Texas | 48303 | 67996 | 1049 |
1851901 | 1851901 | 2021-10-25 | Montgomery | Texas | 48339 | 87429 | 1049 |
1846195 | 1846195 | 2021-10-24 | Escambia | Florida | 12033 | 53492 | 1049 |
1842945 | 1842945 | 2021-10-23 | Escambia | Florida | 12033 | 53492 | 1049 |
1839695 | 1839695 | 2021-10-22 | Escambia | Florida | 12033 | 53492 | 1049 |
1836446 | 1836446 | 2021-10-21 | Escambia | Florida | 12033 | 53282 | 1049 |
1833197 | 1833197 | 2021-10-20 | Escambia | Florida | 12033 | 53282 | 1049 |
1829948 | 1829948 | 2021-10-19 | Escambia | Florida | 12033 | 53282 | 1049 |
1826699 | 1826699 | 2021-10-18 | Escambia | Florida | 12033 | 53282 | 1049 |
1697543 | 1697543 | 2021-09-08 | East Baton Rouge | Louisiana | 22033 | 60063 | 1049 |
1620883 | 1620883 | 2021-08-15 | Greenville | South Carolina | 45045 | 80207 | 1049 |
1617635 | 1617635 | 2021-08-14 | Greenville | South Carolina | 45045 | 80207 | 1049 |
1614387 | 1614387 | 2021-08-13 | Greenville | South Carolina | 45045 | 80207 | 1049 |
1611138 | 1611138 | 2021-08-12 | Greenville | South Carolina | 45045 | 79861 | 1049 |
1607890 | 1607890 | 2021-08-11 | Greenville | South Carolina | 45045 | 79622 | 1049 |
1604641 | 1604641 | 2021-08-10 | Greenville | South Carolina | 45045 | 79436 | 1049 |
1562820 | 1562820 | 2021-07-28 | Travis | Texas | 48453 | 87946 | 1049 |
1451703 | 1451703 | 2021-06-24 | Montgomery | Ohio | 39113 | 52594 | 1049 |
1448457 | 1448457 | 2021-06-23 | Montgomery | Ohio | 39113 | 52586 | 1049 |
1445212 | 1445212 | 2021-06-22 | Montgomery | Ohio | 39113 | 52574 | 1049 |
1437354 | 1437354 | 2021-06-20 | Lake | Indiana | 18089 | 55772 | 1049 |
1434107 | 1434107 | 2021-06-19 | Lake | Indiana | 18089 | 55772 | 1049 |
1290952 | 1290952 | 2021-05-06 | Cobb | Georgia | 13067 | 78596 | 1049 |
1287933 | 1287933 | 2021-05-05 | Lake | Illinois | 17097 | 66448 | 1049 |
1265255 | 1265255 | 2021-04-28 | Will | Illinois | 17197 | 73407 | 1049 |
1202569 | 1202569 | 2021-04-08 | Fairfax | Virginia | 51059 | 72781 | 1049 |
1199321 | 1199321 | 2021-04-07 | Fairfax | Virginia | 51059 | 72551 | 1049 |
1138225 | 1138225 | 2021-03-20 | District of Columbia | District of Columbia | 11001 | 43175 | 1049 |
1094750 | 1094750 | 2021-03-06 | Lancaster | Pennsylvania | 42071 | 44383 | 1049 |
1024743 | 1024743 | 2021-02-13 | Fulton | Georgia | 13121 | 81845 | 1049 |
1000124 | 1000124 | 2021-02-05 | Camden | New Jersey | 34007 | 41113 | 1049 |
965909 | 965909 | 2021-01-26 | Jefferson | Alabama | 1073 | 65189 | 1049 |
929212 | 929212 | 2021-01-14 | Delaware | Pennsylvania | 42045 | 33696 | 1049 |
925967 | 925967 | 2021-01-13 | Delaware | Pennsylvania | 42045 | 33407 | 1049 |
885111 | 885111 | 2021-01-01 | Pinellas | Florida | 12103 | 44975 | 1049 |
886540 | 886540 | 2021-01-01 | Monmouth | New Jersey | 34025 | 32442 | 1049 |
881866 | 881866 | 2020-12-31 | Pinellas | Florida | 12103 | 44975 | 1049 |
841613 | 841613 | 2020-12-18 | Montgomery | Pennsylvania | 42091 | 30755 | 1049 |
584809 | 584809 | 2020-09-30 | Ocean | New Jersey | 34029 | 13730 | 1049 |
447469 | 447469 | 2020-08-19 | Broward | Florida | 12011 | 67534 | 1049 |
318814 | 318814 | 2020-07-10 | Maricopa | Arizona | 4013 | 76328 | 1049 |
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);