ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
74 rows where deaths = 1143 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 20
- Florida 15
- Louisiana 10
- Illinois 8
- Pennsylvania 7
- District of Columbia 4
- Massachusetts 4
- New Jersey 4
- Georgia 3
- Nevada 3
- North Carolina 3
- Michigan 2
- Texas 2
- Virginia 2
- Arizona 1
- Arkansas 1
- California 1
- Colorado 1
- Kentucky 1
- Missouri 1
- Utah 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2467370 | 2467370 | 2022-05-03 | Osceola | Florida | 12097 | 114270 | 1143 |
2464115 | 2464115 | 2022-05-02 | Osceola | Florida | 12097 | 114270 | 1143 |
2460859 | 2460859 | 2022-05-01 | Osceola | Florida | 12097 | 114270 | 1143 |
2457603 | 2457603 | 2022-04-30 | Osceola | Florida | 12097 | 114270 | 1143 |
2454347 | 2454347 | 2022-04-29 | Osceola | Florida | 12097 | 114270 | 1143 |
2451091 | 2451091 | 2022-04-28 | Osceola | Florida | 12097 | 114270 | 1143 |
2447835 | 2447835 | 2022-04-27 | Osceola | Florida | 12097 | 114270 | 1143 |
2444579 | 2444579 | 2022-04-26 | Osceola | Florida | 12097 | 114270 | 1143 |
2441323 | 2441323 | 2022-04-25 | Osceola | Florida | 12097 | 114270 | 1143 |
2438067 | 2438067 | 2022-04-24 | Osceola | Florida | 12097 | 114270 | 1143 |
2434811 | 2434811 | 2022-04-23 | Osceola | Florida | 12097 | 114270 | 1143 |
2431555 | 2431555 | 2022-04-22 | Osceola | Florida | 12097 | 114270 | 1143 |
2428299 | 2428299 | 2022-04-21 | Osceola | Florida | 12097 | 113641 | 1143 |
2425043 | 2425043 | 2022-04-20 | Osceola | Florida | 12097 | 113641 | 1143 |
2399758 | 2399758 | 2022-04-12 | Caddo | Louisiana | 22017 | 67224 | 1143 |
2396502 | 2396502 | 2022-04-11 | Caddo | Louisiana | 22017 | 67220 | 1143 |
2393247 | 2393247 | 2022-04-10 | Caddo | Louisiana | 22017 | 67209 | 1143 |
2394401 | 2394401 | 2022-04-10 | Chester | Pennsylvania | 42029 | 91940 | 1143 |
2389991 | 2389991 | 2022-04-09 | Caddo | Louisiana | 22017 | 67209 | 1143 |
2391145 | 2391145 | 2022-04-09 | Chester | Pennsylvania | 42029 | 91895 | 1143 |
2386735 | 2386735 | 2022-04-08 | Caddo | Louisiana | 22017 | 67209 | 1143 |
2383480 | 2383480 | 2022-04-07 | Caddo | Louisiana | 22017 | 67205 | 1143 |
2380225 | 2380225 | 2022-04-06 | Caddo | Louisiana | 22017 | 67197 | 1143 |
2376970 | 2376970 | 2022-04-05 | Caddo | Louisiana | 22017 | 67192 | 1143 |
2373718 | 2373718 | 2022-04-04 | Caddo | Louisiana | 22017 | 67191 | 1143 |
2291435 | 2291435 | 2022-03-10 | Pulaski | Arkansas | 5119 | 102261 | 1143 |
2257273 | 2257273 | 2022-02-27 | Washoe | Nevada | 32031 | 102276 | 1143 |
2254022 | 2254022 | 2022-02-26 | Washoe | Nevada | 32031 | 102276 | 1143 |
2250771 | 2250771 | 2022-02-25 | Washoe | Nevada | 32031 | 102276 | 1143 |
2243135 | 2243135 | 2022-02-23 | Kane | Illinois | 17089 | 124147 | 1143 |
2221527 | 2221527 | 2022-02-16 | Burlington | New Jersey | 34005 | 100072 | 1143 |
2153722 | 2153722 | 2022-01-26 | Lehigh | Pennsylvania | 42077 | 85673 | 1143 |
2136950 | 2136950 | 2022-01-21 | Mercer | New Jersey | 34021 | 69857 | 1143 |
2122411 | 2122411 | 2022-01-17 | Jefferson | Colorado | 8059 | 102004 | 1143 |
2088699 | 2088699 | 2022-01-06 | Westmoreland | Pennsylvania | 42129 | 62037 | 1143 |
2085913 | 2085913 | 2022-01-05 | Montgomery | Texas | 48339 | 102903 | 1143 |
2061053 | 2061053 | 2021-12-29 | Unknown | Illinois | 0 | 1143 | |
2037717 | 2037717 | 2021-12-22 | Mohave | Arizona | 4015 | 38145 | 1143 |
1990136 | 1990136 | 2021-12-07 | Kent | Michigan | 26081 | 113281 | 1143 |
1986886 | 1986886 | 2021-12-06 | Kent | Michigan | 26081 | 113281 | 1143 |
1852003 | 1852003 | 2021-10-25 | Salt Lake | Utah | 49035 | 193145 | 1143 |
1804268 | 1804268 | 2021-10-11 | Lake | Illinois | 17097 | 78886 | 1143 |
1804764 | 1804764 | 2021-10-11 | Jefferson | Louisiana | 22051 | 68939 | 1143 |
1801019 | 1801019 | 2021-10-10 | Lake | Illinois | 17097 | 78886 | 1143 |
1797770 | 1797770 | 2021-10-09 | Lake | Illinois | 17097 | 78886 | 1143 |
1794521 | 1794521 | 2021-10-08 | Lake | Illinois | 17097 | 78886 | 1143 |
1791273 | 1791273 | 2021-10-07 | Lake | Illinois | 17097 | 78768 | 1143 |
1788024 | 1788024 | 2021-10-06 | Lake | Illinois | 17097 | 78631 | 1143 |
1756846 | 1756846 | 2021-09-26 | Mecklenburg | North Carolina | 37119 | 148228 | 1143 |
1753598 | 1753598 | 2021-09-25 | Mecklenburg | North Carolina | 37119 | 148228 | 1143 |
1750350 | 1750350 | 2021-09-24 | Mecklenburg | North Carolina | 37119 | 148228 | 1143 |
1718856 | 1718856 | 2021-09-14 | Fairfax | Virginia | 51059 | 85432 | 1143 |
1715608 | 1715608 | 2021-09-13 | Fairfax | Virginia | 51059 | 85236 | 1143 |
1505090 | 1505090 | 2021-07-11 | District of Columbia | District of Columbia | 11001 | 49455 | 1143 |
1501844 | 1501844 | 2021-07-10 | District of Columbia | District of Columbia | 11001 | 49455 | 1143 |
1498598 | 1498598 | 2021-07-09 | District of Columbia | District of Columbia | 11001 | 49455 | 1143 |
1495351 | 1495351 | 2021-07-08 | District of Columbia | District of Columbia | 11001 | 49434 | 1143 |
1341527 | 1341527 | 2021-05-21 | Lancaster | Pennsylvania | 42071 | 54797 | 1143 |
1278000 | 1278000 | 2021-05-02 | Gwinnett | Georgia | 13135 | 100961 | 1143 |
1274753 | 1274753 | 2021-05-01 | Gwinnett | Georgia | 13135 | 100888 | 1143 |
1271506 | 1271506 | 2021-04-30 | Gwinnett | Georgia | 13135 | 100777 | 1143 |
1239635 | 1239635 | 2021-04-20 | Jefferson | Kentucky | 21111 | 79829 | 1143 |
1094723 | 1094723 | 2021-03-06 | Bucks | Pennsylvania | 42017 | 46019 | 1143 |
1068281 | 1068281 | 2021-02-26 | Camden | New Jersey | 34007 | 43889 | 1143 |
909720 | 909720 | 2021-01-08 | Allegheny | Pennsylvania | 42003 | 59339 | 1143 |
814936 | 814936 | 2020-12-10 | St. Louis | Missouri | 29189 | 58197 | 1143 |
815989 | 815989 | 2020-12-10 | Cameron | Texas | 48061 | 27178 | 1143 |
610179 | 610179 | 2020-10-08 | Suffolk | Massachusetts | 25025 | 25273 | 1143 |
606937 | 606937 | 2020-10-07 | Suffolk | Massachusetts | 25025 | 25200 | 1143 |
541114 | 541114 | 2020-09-17 | Riverside | California | 6065 | 56374 | 1143 |
351851 | 351851 | 2020-07-20 | Essex | Massachusetts | 25009 | 16757 | 1143 |
348651 | 348651 | 2020-07-19 | Essex | Massachusetts | 25009 | 16733 | 1143 |
328618 | 328618 | 2020-07-13 | Miami-Dade | Florida | 12086 | 67712 | 1143 |
180170 | 180170 | 2020-05-26 | Hudson | New Jersey | 34017 | 18096 | 1143 |
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);