ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
37 rows where deaths = 1206 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 18
- California 8
- District of Columbia 3
- Ohio 3
- Texas 3
- Florida 2
- Georgia 2
- Maryland 2
- Michigan 2
- Nevada 2
- New Jersey 2
- Alabama 1
- Delaware 1
- Illinois 1
- Indiana 1
- New Mexico 1
- New York 1
- Oregon 1
- Pennsylvania 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2498578 | 2498578 | 2022-05-12 | Multnomah | Oregon | 41051 | 123448 | 1206 |
2478569 | 2478569 | 2022-05-06 | Burlington | New Jersey | 34005 | 105285 | 1206 |
2183387 | 2183387 | 2022-02-04 | Denton | Texas | 48121 | 165595 | 1206 |
2180243 | 2180243 | 2022-02-03 | Montgomery | Texas | 48339 | 130653 | 1206 |
2138722 | 2138722 | 2022-01-22 | New Castle | Delaware | 10003 | 135915 | 1206 |
2057353 | 2057353 | 2021-12-28 | Ventura | California | 6111 | 109915 | 1206 |
2054104 | 2054104 | 2021-12-27 | Ventura | California | 6111 | 108201 | 1206 |
2050854 | 2050854 | 2021-12-26 | Ventura | California | 6111 | 108201 | 1206 |
2047604 | 2047604 | 2021-12-25 | Ventura | California | 6111 | 108201 | 1206 |
2044354 | 2044354 | 2021-12-24 | Ventura | California | 6111 | 108201 | 1206 |
2041105 | 2041105 | 2021-12-23 | Ventura | California | 6111 | 107792 | 1206 |
2028184 | 2028184 | 2021-12-19 | District of Columbia | District of Columbia | 11001 | 71219 | 1206 |
2024933 | 2024933 | 2021-12-18 | District of Columbia | District of Columbia | 11001 | 71219 | 1206 |
2021682 | 2021682 | 2021-12-17 | District of Columbia | District of Columbia | 11001 | 71219 | 1206 |
1993918 | 1993918 | 2021-12-08 | Bernalillo | New Mexico | 35001 | 91133 | 1206 |
1883470 | 1883470 | 2021-11-04 | Monroe | New York | 36055 | 87446 | 1206 |
1853057 | 1853057 | 2021-10-26 | Will | Illinois | 17197 | 91970 | 1206 |
1768309 | 1768309 | 2021-09-30 | DeKalb | Georgia | 13089 | 88488 | 1206 |
1741934 | 1741934 | 2021-09-22 | Mobile | Alabama | 1097 | 70465 | 1206 |
1430569 | 1430569 | 2021-06-18 | Gwinnett | Georgia | 13135 | 103126 | 1206 |
1315344 | 1315344 | 2021-05-13 | Hamilton | Ohio | 39061 | 80284 | 1206 |
1312098 | 1312098 | 2021-05-12 | Hamilton | Ohio | 39061 | 80230 | 1206 |
1308851 | 1308851 | 2021-05-11 | Hamilton | Ohio | 39061 | 80149 | 1206 |
1224613 | 1224613 | 2021-04-15 | Bucks | Pennsylvania | 42017 | 55150 | 1206 |
1157585 | 1157585 | 2021-03-26 | Kern | California | 6029 | 105912 | 1206 |
1123464 | 1123464 | 2021-03-15 | Camden | New Jersey | 34007 | 45994 | 1206 |
967090 | 967090 | 2021-01-26 | Prince George's | Maryland | 24033 | 66231 | 1206 |
963846 | 963846 | 2021-01-25 | Prince George's | Maryland | 24033 | 65933 | 1206 |
946774 | 946774 | 2021-01-20 | Pinellas | Florida | 12103 | 55241 | 1206 |
882243 | 882243 | 2020-12-31 | Marion | Indiana | 18097 | 70801 | 1206 |
590792 | 590792 | 2020-10-02 | Oakland | Michigan | 26125 | 20993 | 1206 |
587551 | 587551 | 2020-10-01 | Oakland | Michigan | 26125 | 20922 | 1206 |
576745 | 576745 | 2020-09-28 | Riverside | California | 6065 | 58932 | 1206 |
513531 | 513531 | 2020-09-08 | Clark | Nevada | 32003 | 61543 | 1206 |
510298 | 510298 | 2020-09-07 | Clark | Nevada | 32003 | 61476 | 1206 |
495934 | 495934 | 2020-09-03 | Broward | Florida | 12011 | 72634 | 1206 |
385418 | 385418 | 2020-07-30 | Harris | Texas | 48201 | 70850 | 1206 |
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);