ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
57 rows where cases = 7166 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
- Virginia 11
- Oklahoma 7
- Maryland 3
- Mississippi 3
- Texas 3
- Alaska 2
- Arkansas 2
- Florida 2
- Indiana 2
- Kansas 2
- New Jersey 2
- Ohio 2
- Pennsylvania 2
- California 1
- Connecticut 1
- Georgia 1
- Illinois 1
- Kentucky 1
- Minnesota 1
- Missouri 1
- New York 1
- North Carolina 1
- Oregon 1
- South Carolina 1
- Tennessee 1
- Washington 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497704 | 2497704 | 2022-05-12 | Pine | Minnesota | 27115 | 7166 | 67 |
2493237 | 2493237 | 2022-05-11 | St. Francis | Arkansas | 5123 | 7166 | 96 |
2461711 | 2461711 | 2022-05-01 | Queen Anne's | Maryland | 24035 | 7166 | 110 |
2458455 | 2458455 | 2022-04-30 | Queen Anne's | Maryland | 24035 | 7166 | 110 |
2455199 | 2455199 | 2022-04-29 | Queen Anne's | Maryland | 24035 | 7166 | 110 |
2326727 | 2326727 | 2022-03-20 | Amherst | Virginia | 51009 | 7166 | 84 |
2323474 | 2323474 | 2022-03-19 | Amherst | Virginia | 51009 | 7166 | 84 |
2320220 | 2320220 | 2022-03-18 | Amherst | Virginia | 51009 | 7166 | 84 |
2287008 | 2287008 | 2022-03-08 | Jefferson | Oregon | 41031 | 7166 | 84 |
2281993 | 2281993 | 2022-03-07 | Lumpkin | Georgia | 13187 | 7166 | 127 |
2267922 | 2267922 | 2022-03-02 | Cooke | Texas | 48097 | 7166 | 130 |
2262727 | 2262727 | 2022-03-01 | Greene | Indiana | 18055 | 7166 | 137 |
2240723 | 2240723 | 2022-02-22 | Tippah | Mississippi | 28139 | 7166 | 104 |
2235714 | 2235714 | 2022-02-20 | Gloucester | Virginia | 51073 | 7166 | 96 |
2232463 | 2232463 | 2022-02-19 | Gloucester | Virginia | 51073 | 7166 | 96 |
2229212 | 2229212 | 2022-02-18 | Gloucester | Virginia | 51073 | 7166 | 96 |
2225961 | 2225961 | 2022-02-17 | Gloucester | Virginia | 51073 | 7166 | 96 |
2219541 | 2219541 | 2022-02-15 | Wythe | Virginia | 51197 | 7166 | 129 |
2192587 | 2192587 | 2022-02-07 | Pike | Ohio | 39131 | 7166 | 94 |
2177523 | 2177523 | 2022-02-03 | Juneau City and Borough | Alaska | 2110 | 7166 | 16 |
2174270 | 2174270 | 2022-02-02 | Juneau City and Borough | Alaska | 2110 | 7166 | 16 |
2095171 | 2095171 | 2022-01-08 | Jefferson | Pennsylvania | 42065 | 7166 | 187 |
2040208 | 2040208 | 2021-12-22 | Obion | Tennessee | 47131 | 7166 | 129 |
1878734 | 1878734 | 2021-11-03 | Unknown | Florida | 7166 | 22 | |
1876567 | 1876567 | 2021-11-02 | Oktibbeha | Mississippi | 28105 | 7166 | 133 |
1857470 | 1857470 | 2021-10-27 | Genesee | New York | 36037 | 7166 | 132 |
1853418 | 1853418 | 2021-10-26 | Knox | Kentucky | 21121 | 7166 | 53 |
1854542 | 1854542 | 2021-10-26 | Kay | Oklahoma | 40071 | 7166 | 164 |
1851293 | 1851293 | 2021-10-25 | Kay | Oklahoma | 40071 | 7166 | 164 |
1848043 | 1848043 | 2021-10-24 | Kay | Oklahoma | 40071 | 7166 | 164 |
1844793 | 1844793 | 2021-10-23 | Kay | Oklahoma | 40071 | 7166 | 164 |
1841543 | 1841543 | 2021-10-22 | Kay | Oklahoma | 40071 | 7166 | 164 |
1838294 | 1838294 | 2021-10-21 | Kay | Oklahoma | 40071 | 7166 | 164 |
1835045 | 1835045 | 2021-10-20 | Kay | Oklahoma | 40071 | 7166 | 164 |
1818749 | 1818749 | 2021-10-15 | Seneca | Ohio | 39147 | 7166 | 144 |
1780277 | 1780277 | 2021-10-03 | Burnet | Texas | 48053 | 7166 | 107 |
1777027 | 1777027 | 2021-10-02 | Burnet | Texas | 48053 | 7166 | 107 |
1761599 | 1761599 | 2021-09-28 | San Benito | California | 6069 | 7166 | 67 |
1739350 | 1739350 | 2021-09-21 | Cass | Indiana | 18017 | 7166 | 119 |
1705200 | 1705200 | 2021-09-10 | Indiana | Pennsylvania | 42063 | 7166 | 185 |
1613503 | 1613503 | 2021-08-13 | Lincoln | Missouri | 29113 | 7166 | 54 |
1588396 | 1588396 | 2021-08-05 | Georgetown | South Carolina | 45043 | 7166 | 144 |
1407520 | 1407520 | 2021-06-11 | Crawford | Arkansas | 5033 | 7166 | 119 |
1262255 | 1262255 | 2021-04-27 | Leavenworth | Kansas | 20103 | 7166 | 91 |
1259008 | 1259008 | 2021-04-26 | Leavenworth | Kansas | 20103 | 7166 | 91 |
1260046 | 1260046 | 2021-04-26 | Rutherford | North Carolina | 37161 | 7166 | 206 |
1216546 | 1216546 | 2021-04-13 | Williamson | Illinois | 17199 | 7166 | 137 |
1105827 | 1105827 | 2021-03-10 | Walton | Florida | 12131 | 7166 | 81 |
1095675 | 1095675 | 2021-03-06 | Wood | Wisconsin | 55141 | 7166 | 87 |
1053290 | 1053290 | 2021-02-21 | Roanoke | Virginia | 51161 | 7166 | 94 |
980300 | 980300 | 2021-01-30 | Jones | Mississippi | 28067 | 7166 | 122 |
901278 | 901278 | 2021-01-06 | Middlesex | Connecticut | 9007 | 7166 | 263 |
751492 | 751492 | 2020-11-20 | Benton | Washington | 53005 | 7166 | 143 |
731939 | 731939 | 2020-11-14 | Henrico | Virginia | 51087 | 7166 | 243 |
575074 | 575074 | 2020-09-27 | Burlington | New Jersey | 34005 | 7166 | 496 |
280568 | 280568 | 2020-06-27 | Prince William | Virginia | 51153 | 7166 | 139 |
217031 | 217031 | 2020-06-07 | Mercer | New Jersey | 34021 | 7166 | 501 |
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);