ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
40 rows where deaths = 1492 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 12
- California 7
- Florida 7
- Michigan 7
- Georgia 5
- Texas 5
- Ohio 3
- Maryland 1
- Nevada 1
- New Jersey 1
- New York 1
- Utah 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2486786 | 2486786 | 2022-05-09 | Ventura | California | 6111 | 184928 | 1492 |
2483528 | 2483528 | 2022-05-08 | Ventura | California | 6111 | 184928 | 1492 |
2480270 | 2480270 | 2022-05-07 | Ventura | California | 6111 | 184928 | 1492 |
2477012 | 2477012 | 2022-05-06 | Ventura | California | 6111 | 184928 | 1492 |
2473754 | 2473754 | 2022-05-05 | Ventura | California | 6111 | 184452 | 1492 |
2470497 | 2470497 | 2022-05-04 | Ventura | California | 6111 | 184452 | 1492 |
2467241 | 2467241 | 2022-05-03 | Ventura | California | 6111 | 184452 | 1492 |
2443761 | 2443761 | 2022-04-25 | Nueces | Texas | 48355 | 93155 | 1492 |
2358993 | 2358993 | 2022-03-30 | Collin | Texas | 48085 | 209386 | 1492 |
2353424 | 2353424 | 2022-03-29 | Lake | Florida | 12069 | 84610 | 1492 |
2350172 | 2350172 | 2022-03-28 | Lake | Florida | 12069 | 84610 | 1492 |
2346919 | 2346919 | 2022-03-27 | Lake | Florida | 12069 | 84610 | 1492 |
2343666 | 2343666 | 2022-03-26 | Lake | Florida | 12069 | 84610 | 1492 |
2340413 | 2340413 | 2022-03-25 | Lake | Florida | 12069 | 84610 | 1492 |
2337160 | 2337160 | 2022-03-24 | Lake | Florida | 12069 | 84293 | 1492 |
2308808 | 2308808 | 2022-03-15 | Kent | Michigan | 26081 | 165595 | 1492 |
2305557 | 2305557 | 2022-03-14 | Kent | Michigan | 26081 | 165595 | 1492 |
2302305 | 2302305 | 2022-03-13 | Kent | Michigan | 26081 | 165490 | 1492 |
2299053 | 2299053 | 2022-03-12 | Kent | Michigan | 26081 | 165490 | 1492 |
2295801 | 2295801 | 2022-03-11 | Kent | Michigan | 26081 | 165490 | 1492 |
2292549 | 2292549 | 2022-03-10 | Kent | Michigan | 26081 | 165404 | 1492 |
2289297 | 2289297 | 2022-03-09 | Kent | Michigan | 26081 | 165404 | 1492 |
2215036 | 2215036 | 2022-02-14 | Morris | New Jersey | 34027 | 115158 | 1492 |
2199864 | 2199864 | 2022-02-09 | Salt Lake | Utah | 49035 | 333352 | 1492 |
2107085 | 2107085 | 2022-01-12 | Baltimore city | Maryland | 24510 | 96377 | 1492 |
2030715 | 2030715 | 2021-12-19 | Travis | Texas | 48453 | 125779 | 1492 |
2027464 | 2027464 | 2021-12-18 | Travis | Texas | 48453 | 125440 | 1492 |
1579907 | 1579907 | 2021-08-03 | Fulton | Georgia | 13121 | 104713 | 1492 |
1576659 | 1576659 | 2021-08-02 | Fulton | Georgia | 13121 | 103906 | 1492 |
1573411 | 1573411 | 2021-08-01 | Fulton | Georgia | 13121 | 103372 | 1492 |
1570163 | 1570163 | 2021-07-31 | Fulton | Georgia | 13121 | 103372 | 1492 |
1566915 | 1566915 | 2021-07-30 | Fulton | Georgia | 13121 | 103372 | 1492 |
1542572 | 1542572 | 2021-07-22 | Franklin | Ohio | 39049 | 129993 | 1492 |
1539324 | 1539324 | 2021-07-21 | Franklin | Ohio | 39049 | 129900 | 1492 |
1536077 | 1536077 | 2021-07-20 | Franklin | Ohio | 39049 | 129828 | 1492 |
1222169 | 1222169 | 2021-04-14 | King | Washington | 53033 | 95349 | 1492 |
773788 | 773788 | 2020-11-27 | Bexar | Texas | 48029 | 76762 | 1492 |
665857 | 665857 | 2020-10-25 | Clark | Nevada | 32003 | 78897 | 1492 |
631966 | 631966 | 2020-10-15 | Broward | Florida | 12011 | 80112 | 1492 |
192499 | 192499 | 2020-05-30 | Westchester | New York | 36119 | 33428 | 1492 |
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);