ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
70 rows where cases = 6054 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 29
- Texas 12
- Missouri 8
- Florida 7
- New York 5
- North Carolina 3
- Tennessee 3
- Wyoming 3
- Arkansas 2
- Georgia 2
- Kansas 2
- Louisiana 2
- Ohio 2
- Pennsylvania 2
- Wisconsin 2
- Idaho 1
- Illinois 1
- Indiana 1
- Kentucky 1
- Maine 1
- Maryland 1
- Michigan 1
- Minnesota 1
- Mississippi 1
- Nebraska 1
- New Jersey 1
- Oregon 1
- South Carolina 1
- South Dakota 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2481895 | 2481895 | 2022-05-07 | Essex | New York | 36031 | 6054 | 59 |
2468685 | 2468685 | 2022-05-03 | Cass | Nebraska | 31025 | 6054 | 42 |
2425867 | 2425867 | 2022-04-20 | Knox | Maine | 23013 | 6054 | 34 |
2426914 | 2426914 | 2022-04-20 | Crook | Oregon | 41013 | 6054 | 79 |
2427895 | 2427895 | 2022-04-20 | Vernon | Wisconsin | 55123 | 6054 | 96 |
2400522 | 2400522 | 2022-04-12 | Seneca | New York | 36099 | 6054 | 89 |
2377339 | 2377339 | 2022-04-05 | Adair | Missouri | 29001 | 6054 | 62 |
2374086 | 2374086 | 2022-04-04 | Adair | Missouri | 29001 | 6054 | 62 |
2370834 | 2370834 | 2022-04-03 | Adair | Missouri | 29001 | 6054 | 62 |
2367581 | 2367581 | 2022-04-02 | Adair | Missouri | 29001 | 6054 | 62 |
2364328 | 2364328 | 2022-04-01 | Adair | Missouri | 29001 | 6054 | 62 |
2361074 | 2361074 | 2022-03-31 | Adair | Missouri | 29001 | 6054 | 62 |
2357820 | 2357820 | 2022-03-30 | Adair | Missouri | 29001 | 6054 | 62 |
2354567 | 2354567 | 2022-03-29 | Adair | Missouri | 29001 | 6054 | 62 |
2330880 | 2330880 | 2022-03-22 | Jerome | Idaho | 16053 | 6054 | 64 |
2320681 | 2320681 | 2022-03-19 | Jackson | Arkansas | 5067 | 6054 | 59 |
2274499 | 2274499 | 2022-03-04 | Jasper | Texas | 48241 | 6054 | 181 |
2236488 | 2236488 | 2022-02-21 | Peach | Georgia | 13225 | 6054 | 119 |
2149250 | 2149250 | 2022-01-25 | Mercer | Kentucky | 21167 | 6054 | 95 |
2141147 | 2141147 | 2022-01-22 | Hutchinson | Texas | 48233 | 6054 | 120 |
2131152 | 2131152 | 2022-01-19 | Meade | South Dakota | 46093 | 6054 | 56 |
2079237 | 2079237 | 2022-01-03 | White | Tennessee | 47185 | 6054 | 115 |
2056716 | 2056716 | 2021-12-27 | Upshur | Texas | 48459 | 6054 | 156 |
2035043 | 2035043 | 2021-12-21 | Randolph | Illinois | 17157 | 6054 | 113 |
1958480 | 1958480 | 2021-11-27 | Putnam | Ohio | 39137 | 6054 | 120 |
1859200 | 1859200 | 2021-10-28 | Hardee | Florida | 12049 | 6054 | 100 |
1855951 | 1855951 | 2021-10-27 | Hardee | Florida | 12049 | 6054 | 100 |
1852702 | 1852702 | 2021-10-26 | Hardee | Florida | 12049 | 6054 | 100 |
1849453 | 1849453 | 2021-10-25 | Hardee | Florida | 12049 | 6054 | 100 |
1851889 | 1851889 | 2021-10-25 | Matagorda | Texas | 48321 | 6054 | 156 |
1846203 | 1846203 | 2021-10-24 | Hardee | Florida | 12049 | 6054 | 97 |
1842953 | 1842953 | 2021-10-23 | Hardee | Florida | 12049 | 6054 | 97 |
1839703 | 1839703 | 2021-10-22 | Hardee | Florida | 12049 | 6054 | 97 |
1777740 | 1777740 | 2021-10-03 | Boone | Arkansas | 5009 | 6054 | 114 |
1764234 | 1764234 | 2021-09-28 | Uvalde | Texas | 48463 | 6054 | 90 |
1714556 | 1714556 | 2021-09-13 | Beaufort | North Carolina | 37013 | 6054 | 108 |
1705007 | 1705007 | 2021-09-10 | Knox | Ohio | 39083 | 6054 | 120 |
1694479 | 1694479 | 2021-09-07 | Tuscola | Michigan | 26157 | 6054 | 179 |
1675151 | 1675151 | 2021-09-01 | Warren | Mississippi | 28149 | 6054 | 148 |
1667151 | 1667151 | 2021-08-29 | Fremont | Wyoming | 56013 | 6054 | 91 |
1663903 | 1663903 | 2021-08-28 | Fremont | Wyoming | 56013 | 6054 | 91 |
1659274 | 1659274 | 2021-08-27 | Cattaraugus | New York | 36009 | 6054 | 94 |
1660655 | 1660655 | 2021-08-27 | Fremont | Wyoming | 56013 | 6054 | 91 |
1648594 | 1648594 | 2021-08-24 | Crawford | Kansas | 20037 | 6054 | 96 |
1645346 | 1645346 | 2021-08-23 | Crawford | Kansas | 20037 | 6054 | 96 |
1492495 | 1492495 | 2021-07-07 | Cass | Indiana | 18017 | 6054 | 112 |
1377208 | 1377208 | 2021-06-01 | Bradford | Pennsylvania | 42015 | 6054 | 90 |
1360576 | 1360576 | 2021-05-27 | Jefferson | New York | 36045 | 6054 | 68 |
1355437 | 1355437 | 2021-05-25 | Waupaca | Wisconsin | 55135 | 6054 | 164 |
1330825 | 1330825 | 2021-05-18 | Chisago | Minnesota | 27025 | 6054 | 51 |
1322070 | 1322070 | 2021-05-15 | Union | Pennsylvania | 42119 | 6054 | 86 |
1263888 | 1263888 | 2021-04-27 | Loudon | Tennessee | 47105 | 6054 | 69 |
1216361 | 1216361 | 2021-04-13 | Spalding | Georgia | 13255 | 6054 | 185 |
1198981 | 1198981 | 2021-04-07 | Anderson | Texas | 48001 | 6054 | 115 |
1170065 | 1170065 | 2021-03-29 | Bedford | Virginia | 51019 | 6054 | 97 |
1130041 | 1130041 | 2021-03-17 | Ontario | New York | 36069 | 6054 | 90 |
1104909 | 1104909 | 2021-03-09 | Hale | Texas | 48189 | 6054 | 152 |
1101663 | 1101663 | 2021-03-08 | Hale | Texas | 48189 | 6054 | 152 |
1097700 | 1097700 | 2021-03-07 | Wilkes | North Carolina | 37193 | 6054 | 104 |
1098417 | 1098417 | 2021-03-07 | Hale | Texas | 48189 | 6054 | 152 |
1094452 | 1094452 | 2021-03-06 | Wilkes | North Carolina | 37193 | 6054 | 104 |
1095169 | 1095169 | 2021-03-06 | Hale | Texas | 48189 | 6054 | 152 |
1091923 | 1091923 | 2021-03-05 | Hale | Texas | 48189 | 6054 | 152 |
1070854 | 1070854 | 2021-02-27 | Acadia | Louisiana | 22001 | 6054 | 185 |
1067609 | 1067609 | 2021-02-26 | Acadia | Louisiana | 22001 | 6054 | 185 |
1052803 | 1052803 | 2021-02-21 | Cumberland | Tennessee | 47035 | 6054 | 116 |
757341 | 757341 | 2020-11-22 | Aiken | South Carolina | 45003 | 6054 | 96 |
613988 | 613988 | 2020-10-09 | Somerset | New Jersey | 34035 | 6054 | 582 |
520876 | 520876 | 2020-09-10 | Brazos | Texas | 48041 | 6054 | 59 |
102141 | 102141 | 2020-04-30 | Prince George's | Maryland | 24033 | 6054 | 240 |
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);