ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
37 rows where deaths = 1369 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 17
- Washington 8
- North Carolina 4
- Maryland 3
- Massachusetts 3
- New Jersey 3
- Arizona 2
- California 2
- Connecticut 2
- Pennsylvania 2
- Colorado 1
- Florida 1
- Georgia 1
- Illinois 1
- New York 1
- South Carolina 1
- Tennessee 1
- Utah 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2463586 | 2463586 | 2022-05-01 | Spokane | Washington | 53063 | 125079 | 1369 |
2460330 | 2460330 | 2022-04-30 | Spokane | Washington | 53063 | 125079 | 1369 |
2457074 | 2457074 | 2022-04-29 | Spokane | Washington | 53063 | 125079 | 1369 |
2440794 | 2440794 | 2022-04-24 | Spokane | Washington | 53063 | 124569 | 1369 |
2437538 | 2437538 | 2022-04-23 | Spokane | Washington | 53063 | 124569 | 1369 |
2434282 | 2434282 | 2022-04-22 | Spokane | Washington | 53063 | 124569 | 1369 |
2404216 | 2404216 | 2022-04-13 | Westmoreland | Pennsylvania | 42129 | 79792 | 1369 |
2400961 | 2400961 | 2022-04-12 | Westmoreland | Pennsylvania | 42129 | 79759 | 1369 |
2339894 | 2339894 | 2022-03-24 | Pierce | Washington | 53053 | 190726 | 1369 |
2336641 | 2336641 | 2022-03-23 | Pierce | Washington | 53053 | 190726 | 1369 |
2242593 | 2242593 | 2022-02-23 | Mohave | Arizona | 4015 | 56703 | 1369 |
2239342 | 2239342 | 2022-02-22 | Mohave | Arizona | 4015 | 56647 | 1369 |
2179907 | 2179907 | 2022-02-03 | Spartanburg | South Carolina | 45083 | 90634 | 1369 |
2124102 | 2124102 | 2022-01-17 | Mecklenburg | North Carolina | 37119 | 216517 | 1369 |
2120850 | 2120850 | 2022-01-16 | Mecklenburg | North Carolina | 37119 | 216517 | 1369 |
2117598 | 2117598 | 2022-01-15 | Mecklenburg | North Carolina | 37119 | 216517 | 1369 |
2114347 | 2114347 | 2022-01-14 | Mecklenburg | North Carolina | 37119 | 216517 | 1369 |
2109822 | 2109822 | 2022-01-13 | Unknown | Illinois | 0 | 1369 | |
2104433 | 2104433 | 2022-01-11 | Morris | New Jersey | 34027 | 99829 | 1369 |
2102273 | 2102273 | 2022-01-10 | Salt Lake | Utah | 49035 | 258942 | 1369 |
2094746 | 2094746 | 2022-01-08 | Monroe | New York | 36055 | 125928 | 1369 |
2056409 | 2056409 | 2021-12-27 | Davidson | Tennessee | 47037 | 140061 | 1369 |
2037878 | 2037878 | 2021-12-22 | El Paso | Colorado | 8041 | 120465 | 1369 |
1931551 | 1931551 | 2021-11-19 | Baltimore city | Maryland | 24510 | 63263 | 1369 |
1928300 | 1928300 | 2021-11-18 | Baltimore city | Maryland | 24510 | 63137 | 1369 |
1925050 | 1925050 | 2021-11-17 | Baltimore city | Maryland | 24510 | 63051 | 1369 |
1791079 | 1791079 | 2021-10-07 | Gwinnett | Georgia | 13135 | 130046 | 1369 |
1694953 | 1694953 | 2021-09-07 | Camden | New Jersey | 34007 | 61195 | 1369 |
1144583 | 1144583 | 2021-03-22 | Alameda | California | 6001 | 82705 | 1369 |
1141336 | 1141336 | 2021-03-21 | Alameda | California | 6001 | 82635 | 1369 |
921675 | 921675 | 2021-01-12 | Norfolk | Massachusetts | 25021 | 32853 | 1369 |
879487 | 879487 | 2020-12-30 | Suffolk | Massachusetts | 25025 | 53695 | 1369 |
710729 | 710729 | 2020-11-08 | Essex | Massachusetts | 25009 | 26490 | 1369 |
672387 | 672387 | 2020-10-27 | Union | New Jersey | 34039 | 20085 | 1369 |
583378 | 583378 | 2020-09-30 | Palm Beach | Florida | 12099 | 46550 | 1369 |
281088 | 281088 | 2020-06-28 | Hartford | Connecticut | 9003 | 11587 | 1369 |
277941 | 277941 | 2020-06-27 | Hartford | Connecticut | 9003 | 11558 | 1369 |
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);