ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
31 rows where deaths = 2100 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 10
- California 11
- Ohio 8
- Florida 3
- New Jersey 3
- Georgia 1
- Illinois 1
- Indiana 1
- Maryland 1
- New York 1
- Puerto Rico 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499902 | 2499902 | 2022-05-13 | Brevard | Florida | 12009 | 135740 | 2100 |
2496644 | 2496644 | 2022-05-12 | Brevard | Florida | 12009 | 135740 | 2100 |
2493386 | 2493386 | 2022-05-11 | Brevard | Florida | 12009 | 135740 | 2100 |
2259437 | 2259437 | 2022-02-28 | Unknown | Illinois | 0 | 2100 | |
2242939 | 2242939 | 2022-02-23 | Fulton | Georgia | 13121 | 212164 | 2100 |
2147001 | 2147001 | 2022-01-24 | Franklin | Ohio | 39049 | 271942 | 2100 |
2143747 | 2143747 | 2022-01-23 | Franklin | Ohio | 39049 | 270793 | 2100 |
2140492 | 2140492 | 2022-01-22 | Franklin | Ohio | 39049 | 269677 | 2100 |
2137236 | 2137236 | 2022-01-21 | Franklin | Ohio | 39049 | 267977 | 2100 |
2110335 | 2110335 | 2022-01-13 | Baltimore | Maryland | 24005 | 116508 | 2100 |
1990714 | 1990714 | 2021-12-07 | Erie | New York | 36029 | 130221 | 2100 |
1768629 | 1768629 | 2021-09-30 | Marion | Indiana | 18097 | 131082 | 2100 |
1573190 | 1573190 | 2021-08-01 | Santa Clara | California | 6085 | 123514 | 2100 |
1569942 | 1569942 | 2021-07-31 | Santa Clara | California | 6085 | 123514 | 2100 |
1566694 | 1566694 | 2021-07-30 | Santa Clara | California | 6085 | 123514 | 2100 |
1563446 | 1563446 | 2021-07-29 | Santa Clara | California | 6085 | 123245 | 2100 |
1560198 | 1560198 | 2021-07-28 | Santa Clara | California | 6085 | 123021 | 2100 |
1556951 | 1556951 | 2021-07-27 | Santa Clara | California | 6085 | 122845 | 2100 |
1553704 | 1553704 | 2021-07-26 | Santa Clara | California | 6085 | 122667 | 2100 |
1550457 | 1550457 | 2021-07-25 | Santa Clara | California | 6085 | 121959 | 2100 |
1547210 | 1547210 | 2021-07-24 | Santa Clara | California | 6085 | 121959 | 2100 |
1543963 | 1543963 | 2021-07-23 | Santa Clara | California | 6085 | 121959 | 2100 |
1540715 | 1540715 | 2021-07-22 | Santa Clara | California | 6085 | 121705 | 2100 |
1282868 | 1282868 | 2021-05-03 | Cuyahoga | Ohio | 39035 | 110922 | 2100 |
1279621 | 1279621 | 2021-05-02 | Cuyahoga | Ohio | 39035 | 110740 | 2100 |
1276374 | 1276374 | 2021-05-01 | Cuyahoga | Ohio | 39035 | 110568 | 2100 |
1273127 | 1273127 | 2021-04-30 | Cuyahoga | Ohio | 39035 | 110285 | 2100 |
1153292 | 1153292 | 2021-03-24 | Unknown | Puerto Rico | 4553 | 2100 | |
1081272 | 1081272 | 2021-03-02 | Middlesex | New Jersey | 34023 | 73117 | 2100 |
384498 | 384498 | 2020-07-30 | Essex | New Jersey | 34013 | 19684 | 2100 |
381280 | 381280 | 2020-07-29 | Essex | New Jersey | 34013 | 19671 | 2100 |
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);