ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
28 rows where deaths = 2152 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 12
- Florida 8
- New Jersey 6
- Washington 4
- New York 2
- California 1
- Connecticut 1
- Maryland 1
- Massachusetts 1
- Minnesota 1
- Puerto Rico 1
- Texas 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2467356 | 2467356 | 2022-05-03 | Lee | Florida | 12071 | 190313 | 2152 |
2468221 | 2468221 | 2022-05-03 | Prince George's | Maryland | 24033 | 173373 | 2152 |
2464101 | 2464101 | 2022-05-02 | Lee | Florida | 12071 | 190313 | 2152 |
2460845 | 2460845 | 2022-05-01 | Lee | Florida | 12071 | 190313 | 2152 |
2457589 | 2457589 | 2022-04-30 | Lee | Florida | 12071 | 190313 | 2152 |
2454333 | 2454333 | 2022-04-29 | Lee | Florida | 12071 | 190313 | 2152 |
2451077 | 2451077 | 2022-04-28 | Lee | Florida | 12071 | 190313 | 2152 |
2447821 | 2447821 | 2022-04-27 | Lee | Florida | 12071 | 190313 | 2152 |
2293071 | 2293071 | 2022-03-10 | Monmouth | New Jersey | 34025 | 161980 | 2152 |
2294462 | 2294462 | 2022-03-10 | Milwaukee | Wisconsin | 55079 | 267008 | 2152 |
2055216 | 2055216 | 2021-12-27 | Hennepin | Minnesota | 27053 | 196397 | 2152 |
2053689 | 2053689 | 2021-12-26 | King | Washington | 53033 | 185916 | 2152 |
2050439 | 2050439 | 2021-12-25 | King | Washington | 53033 | 185916 | 2152 |
2047189 | 2047189 | 2021-12-24 | King | Washington | 53033 | 185916 | 2152 |
2043939 | 2043939 | 2021-12-23 | King | Washington | 53033 | 185916 | 2152 |
1761598 | 1761598 | 2021-09-28 | Sacramento | California | 6067 | 153026 | 2152 |
1376743 | 1376743 | 2021-06-01 | Ocean | New Jersey | 34029 | 75754 | 2152 |
1245382 | 1245382 | 2021-04-22 | Fairfield | Connecticut | 9001 | 96797 | 2152 |
1208504 | 1208504 | 2021-04-10 | Unknown | Puerto Rico | 4795 | 2152 | |
1126817 | 1126817 | 2021-03-16 | Westchester | New York | 36119 | 113576 | 2152 |
1120225 | 1120225 | 2021-03-14 | Middlesex | New Jersey | 34023 | 76797 | 2152 |
1116978 | 1116978 | 2021-03-13 | Middlesex | New Jersey | 34023 | 76532 | 2152 |
1070964 | 1070964 | 2021-02-27 | Essex | Massachusetts | 25009 | 83624 | 2152 |
997775 | 997775 | 2021-02-04 | El Paso | Texas | 48141 | 115300 | 2152 |
972733 | 972733 | 2021-01-28 | Palm Beach | Florida | 12099 | 104691 | 2152 |
704807 | 704807 | 2020-11-06 | Essex | New Jersey | 34013 | 26838 | 2152 |
701564 | 701564 | 2020-11-05 | Essex | New Jersey | 34013 | 26545 | 2152 |
27467 | 27467 | 2020-04-02 | New York City | New York | 52400 | 2152 |
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);