ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
56 rows where deaths = 1254 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 16
- Ohio 17
- New Jersey 9
- Georgia 6
- Texas 5
- Louisiana 4
- South Carolina 4
- Florida 2
- California 1
- Colorado 1
- Connecticut 1
- Illinois 1
- Maryland 1
- Massachusetts 1
- Tennessee 1
- Washington 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2351620 | 2351620 | 2022-03-28 | Mercer | New Jersey | 34021 | 75704 | 1254 |
2348368 | 2348368 | 2022-03-27 | Mercer | New Jersey | 34021 | 75681 | 1254 |
2242034 | 2242034 | 2022-02-22 | Montgomery | Texas | 48339 | 134837 | 1254 |
2219259 | 2219259 | 2022-02-15 | Lubbock | Texas | 48303 | 96548 | 1254 |
2213491 | 2213491 | 2022-02-14 | Denver | Colorado | 8031 | 162441 | 1254 |
2191595 | 2191595 | 2022-02-07 | East Baton Rouge | Louisiana | 22033 | 108053 | 1254 |
2188342 | 2188342 | 2022-02-06 | East Baton Rouge | Louisiana | 22033 | 107417 | 1254 |
2185089 | 2185089 | 2022-02-05 | East Baton Rouge | Louisiana | 22033 | 107417 | 1254 |
2181837 | 2181837 | 2022-02-04 | East Baton Rouge | Louisiana | 22033 | 107417 | 1254 |
2109780 | 2109780 | 2022-01-13 | Lake | Illinois | 17097 | 121134 | 1254 |
2033252 | 2033252 | 2021-12-20 | Summit | Ohio | 39153 | 79589 | 1254 |
2030002 | 2030002 | 2021-12-19 | Summit | Ohio | 39153 | 78999 | 1254 |
2026751 | 2026751 | 2021-12-18 | Summit | Ohio | 39153 | 78423 | 1254 |
2023500 | 2023500 | 2021-12-17 | Summit | Ohio | 39153 | 77763 | 1254 |
2007566 | 2007566 | 2021-12-12 | Spartanburg | South Carolina | 45083 | 63807 | 1254 |
2004315 | 2004315 | 2021-12-11 | Spartanburg | South Carolina | 45083 | 63807 | 1254 |
2001064 | 2001064 | 2021-12-10 | Spartanburg | South Carolina | 45083 | 63807 | 1254 |
1838226 | 1838226 | 2021-10-21 | Montgomery | Ohio | 39113 | 73710 | 1254 |
1834977 | 1834977 | 2021-10-20 | Montgomery | Ohio | 39113 | 73566 | 1254 |
1831728 | 1831728 | 2021-10-19 | Montgomery | Ohio | 39113 | 73307 | 1254 |
1813799 | 1813799 | 2021-10-14 | DeKalb | Georgia | 13089 | 90994 | 1254 |
1763817 | 1763817 | 2021-09-28 | Greenville | South Carolina | 45045 | 99565 | 1254 |
1755305 | 1755305 | 2021-09-26 | Cobb | Georgia | 13067 | 104581 | 1254 |
1752057 | 1752057 | 2021-09-25 | Cobb | Georgia | 13067 | 104581 | 1254 |
1748808 | 1748808 | 2021-09-24 | Cobb | Georgia | 13067 | 104581 | 1254 |
1678715 | 1678715 | 2021-09-02 | Morris | New Jersey | 34027 | 53623 | 1254 |
1670871 | 1670871 | 2021-08-31 | Gwinnett | Georgia | 13135 | 115842 | 1254 |
1497120 | 1497120 | 2021-07-08 | Hamilton | Ohio | 39061 | 81633 | 1254 |
1493873 | 1493873 | 2021-07-07 | Hamilton | Ohio | 39061 | 81604 | 1254 |
1490626 | 1490626 | 2021-07-06 | Hamilton | Ohio | 39061 | 81588 | 1254 |
1487379 | 1487379 | 2021-07-05 | Hamilton | Ohio | 39061 | 81572 | 1254 |
1484132 | 1484132 | 2021-07-04 | Hamilton | Ohio | 39061 | 81566 | 1254 |
1480886 | 1480886 | 2021-07-03 | Hamilton | Ohio | 39061 | 81566 | 1254 |
1477639 | 1477639 | 2021-07-02 | Hamilton | Ohio | 39061 | 81546 | 1254 |
1474393 | 1474393 | 2021-07-01 | Hamilton | Ohio | 39061 | 81533 | 1254 |
1471147 | 1471147 | 2021-06-30 | Hamilton | Ohio | 39061 | 81520 | 1254 |
1467902 | 1467902 | 2021-06-29 | Hamilton | Ohio | 39061 | 81511 | 1254 |
1173998 | 1173998 | 2021-03-31 | Polk | Florida | 12105 | 61175 | 1254 |
1157834 | 1157834 | 2021-03-26 | Fulton | Georgia | 13121 | 91209 | 1254 |
1057957 | 1057957 | 2021-02-23 | Baltimore | Maryland | 24005 | 50228 | 1254 |
1043712 | 1043712 | 2021-02-18 | Milwaukee | Wisconsin | 55079 | 106042 | 1254 |
1011509 | 1011509 | 2021-02-09 | Fresno | California | 6019 | 91430 | 1254 |
988419 | 988419 | 2021-02-01 | King | Washington | 53033 | 78391 | 1254 |
978210 | 978210 | 2021-01-29 | Shelby | Tennessee | 47157 | 82428 | 1254 |
955543 | 955543 | 2021-01-22 | Cameron | Texas | 48061 | 33517 | 1254 |
952298 | 952298 | 2021-01-21 | Cameron | Texas | 48061 | 33517 | 1254 |
847602 | 847602 | 2020-12-20 | Ocean | New Jersey | 34029 | 28708 | 1254 |
682983 | 682983 | 2020-10-30 | Dallas | Texas | 48113 | 101051 | 1254 |
588050 | 588050 | 2020-10-01 | Passaic | New Jersey | 34031 | 19276 | 1254 |
584810 | 584810 | 2020-09-30 | Passaic | New Jersey | 34031 | 19254 | 1254 |
575087 | 575087 | 2020-09-27 | Passaic | New Jersey | 34031 | 19146 | 1254 |
571844 | 571844 | 2020-09-26 | Passaic | New Jersey | 34031 | 19124 | 1254 |
541266 | 541266 | 2020-09-17 | Palm Beach | Florida | 12099 | 44681 | 1254 |
513002 | 513002 | 2020-09-08 | Essex | Massachusetts | 25009 | 18431 | 1254 |
238737 | 238737 | 2020-06-14 | Hudson | New Jersey | 34017 | 18746 | 1254 |
197146 | 197146 | 2020-06-01 | Hartford | Connecticut | 9003 | 10445 | 1254 |
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);