ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
63 rows where deaths = 1218 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 17
- Florida 17
- New Jersey 8
- Ohio 6
- Pennsylvania 5
- Illinois 4
- Virginia 4
- Louisiana 3
- Massachusetts 3
- Indiana 2
- Maryland 2
- Michigan 2
- Washington 2
- Arizona 1
- California 1
- District of Columbia 1
- Georgia 1
- Texas 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2444589 | 2444589 | 2022-04-26 | St. Lucie | Florida | 12111 | 74544 | 1218 |
2441333 | 2441333 | 2022-04-25 | St. Lucie | Florida | 12111 | 74544 | 1218 |
2438077 | 2438077 | 2022-04-24 | St. Lucie | Florida | 12111 | 74544 | 1218 |
2434821 | 2434821 | 2022-04-23 | St. Lucie | Florida | 12111 | 74544 | 1218 |
2431565 | 2431565 | 2022-04-22 | St. Lucie | Florida | 12111 | 74544 | 1218 |
2428309 | 2428309 | 2022-04-21 | St. Lucie | Florida | 12111 | 74163 | 1218 |
2425053 | 2425053 | 2022-04-20 | St. Lucie | Florida | 12111 | 74163 | 1218 |
2376221 | 2376221 | 2022-04-05 | St. Lucie | Florida | 12111 | 73954 | 1218 |
2372969 | 2372969 | 2022-04-04 | St. Lucie | Florida | 12111 | 73954 | 1218 |
2369716 | 2369716 | 2022-04-03 | St. Lucie | Florida | 12111 | 73954 | 1218 |
2366463 | 2366463 | 2022-04-02 | St. Lucie | Florida | 12111 | 73954 | 1218 |
2363210 | 2363210 | 2022-04-01 | St. Lucie | Florida | 12111 | 73954 | 1218 |
2359956 | 2359956 | 2022-03-31 | St. Lucie | Florida | 12111 | 73954 | 1218 |
2356702 | 2356702 | 2022-03-30 | St. Lucie | Florida | 12111 | 73954 | 1218 |
2261049 | 2261049 | 2022-02-28 | Lehigh | Pennsylvania | 42077 | 88773 | 1218 |
2257798 | 2257798 | 2022-02-27 | Lehigh | Pennsylvania | 42077 | 88760 | 1218 |
2254547 | 2254547 | 2022-02-26 | Lehigh | Pennsylvania | 42077 | 88749 | 1218 |
2179558 | 2179558 | 2022-02-03 | Lucas | Ohio | 39095 | 96516 | 1218 |
2180540 | 2180540 | 2022-02-03 | Spokane | Washington | 53063 | 116250 | 1218 |
2176307 | 2176307 | 2022-02-02 | Lucas | Ohio | 39095 | 96400 | 1218 |
2177289 | 2177289 | 2022-02-02 | Spokane | Washington | 53063 | 116250 | 1218 |
2173053 | 2173053 | 2022-02-01 | Lucas | Ohio | 39095 | 96014 | 1218 |
2142805 | 2142805 | 2022-01-23 | Jefferson | Louisiana | 22051 | 100790 | 1218 |
2144627 | 2144627 | 2022-01-23 | Fairfax | Virginia | 51059 | 158184 | 1218 |
2139550 | 2139550 | 2022-01-22 | Jefferson | Louisiana | 22051 | 100790 | 1218 |
2141372 | 2141372 | 2022-01-22 | Fairfax | Virginia | 51059 | 158184 | 1218 |
2136294 | 2136294 | 2022-01-21 | Jefferson | Louisiana | 22051 | 100790 | 1218 |
2138116 | 2138116 | 2022-01-21 | Fairfax | Virginia | 51059 | 158184 | 1218 |
2134862 | 2134862 | 2022-01-20 | Fairfax | Virginia | 51059 | 156641 | 1218 |
2076936 | 2076936 | 2022-01-03 | District of Columbia | District of Columbia | 11001 | 103487 | 1218 |
2074014 | 2074014 | 2022-01-02 | Lake | Illinois | 17097 | 101282 | 1218 |
2070763 | 2070763 | 2022-01-01 | Lake | Illinois | 17097 | 101282 | 1218 |
2067512 | 2067512 | 2021-12-31 | Lake | Illinois | 17097 | 101282 | 1218 |
2064261 | 2064261 | 2021-12-30 | Lake | Illinois | 17097 | 101282 | 1218 |
2001962 | 2001962 | 2021-12-11 | Pinal | Arizona | 4021 | 84661 | 1218 |
1853106 | 1853106 | 2021-10-26 | Lake | Indiana | 18089 | 66818 | 1218 |
1740937 | 1740937 | 2021-09-21 | Lancaster | Pennsylvania | 42071 | 63666 | 1218 |
1579914 | 1579914 | 2021-08-03 | Gwinnett | Georgia | 13135 | 106804 | 1218 |
1359914 | 1359914 | 2021-05-27 | Baltimore city | Maryland | 24510 | 52809 | 1218 |
1338071 | 1338071 | 2021-05-20 | Hamilton | Ohio | 39061 | 80582 | 1218 |
1334824 | 1334824 | 2021-05-19 | Hamilton | Ohio | 39061 | 80521 | 1218 |
1331577 | 1331577 | 2021-05-18 | Hamilton | Ohio | 39061 | 80476 | 1218 |
1311812 | 1311812 | 2021-05-12 | Morris | New Jersey | 34027 | 49714 | 1218 |
1308565 | 1308565 | 2021-05-11 | Morris | New Jersey | 34027 | 49711 | 1218 |
1305319 | 1305319 | 2021-05-10 | Morris | New Jersey | 34027 | 49669 | 1218 |
1302073 | 1302073 | 2021-05-09 | Morris | New Jersey | 34027 | 49653 | 1218 |
1240851 | 1240851 | 2021-04-20 | Bucks | Pennsylvania | 42017 | 56408 | 1218 |
1168923 | 1168923 | 2021-03-29 | Camden | New Jersey | 34007 | 48400 | 1218 |
1159179 | 1159179 | 2021-03-26 | Camden | New Jersey | 34007 | 47853 | 1218 |
1141524 | 1141524 | 2021-03-21 | Polk | Florida | 12105 | 59767 | 1218 |
1138278 | 1138278 | 2021-03-20 | Polk | Florida | 12105 | 59654 | 1218 |
1102529 | 1102529 | 2021-03-09 | Duval | Florida | 12031 | 89953 | 1218 |
1060184 | 1060184 | 2021-02-24 | Alameda | California | 6001 | 79969 | 1218 |
973580 | 973580 | 2021-01-28 | Prince George's | Maryland | 24033 | 66915 | 1218 |
926335 | 926335 | 2021-01-13 | Cameron | Texas | 48061 | 31473 | 1218 |
885488 | 885488 | 2021-01-01 | Marion | Indiana | 18097 | 71677 | 1218 |
827560 | 827560 | 2020-12-14 | Norfolk | Massachusetts | 25021 | 20909 | 1218 |
756216 | 756216 | 2020-11-22 | Macomb | Michigan | 26099 | 32074 | 1218 |
752970 | 752970 | 2020-11-21 | Macomb | Michigan | 26099 | 32074 | 1218 |
746426 | 746426 | 2020-11-19 | Suffolk | Massachusetts | 25025 | 33994 | 1218 |
733444 | 733444 | 2020-11-15 | Worcester | Massachusetts | 25027 | 20375 | 1218 |
320472 | 320472 | 2020-07-10 | Passaic | New Jersey | 34031 | 17188 | 1218 |
217029 | 217029 | 2020-06-07 | Hudson | New Jersey | 34017 | 18565 | 1218 |
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);