ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79 rows where cases = 4940 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Georgia 8
- Iowa 7
- Michigan 6
- Pennsylvania 5
- Wisconsin 5
- Minnesota 4
- New Mexico 4
- Ohio 4
- Wyoming 4
- Missouri 3
- Washington 3
- Arkansas 2
- Mississippi 2
- North Carolina 2
- Puerto Rico 2
- Tennessee 2
- Texas 2
- Vermont 2
- Alabama 1
- Arizona 1
- Colorado 1
- Florida 1
- Illinois 1
- Kentucky 1
- Louisiana 1
- Maine 1
- New York 1
- South Carolina 1
- South Dakota 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2456773 | 2456773 | 2022-04-29 | Milam | Texas | 48331 | 4940 | 102 |
2450500 | 2450500 | 2022-04-27 | Radford city | Virginia | 51750 | 4940 | 53 |
2444608 | 2444608 | 2022-04-26 | Berrien | Georgia | 13019 | 4940 | 83 |
2441352 | 2441352 | 2022-04-25 | Berrien | Georgia | 13019 | 4940 | 83 |
2438096 | 2438096 | 2022-04-24 | Berrien | Georgia | 13019 | 4940 | 83 |
2434840 | 2434840 | 2022-04-23 | Berrien | Georgia | 13019 | 4940 | 83 |
2431584 | 2431584 | 2022-04-22 | Berrien | Georgia | 13019 | 4940 | 83 |
2428328 | 2428328 | 2022-04-21 | Berrien | Georgia | 13019 | 4940 | 83 |
2425072 | 2425072 | 2022-04-20 | Berrien | Georgia | 13019 | 4940 | 83 |
2416262 | 2416262 | 2022-04-17 | Hubbard | Minnesota | 27057 | 4940 | 59 |
2413006 | 2413006 | 2022-04-16 | Hubbard | Minnesota | 27057 | 4940 | 59 |
2409750 | 2409750 | 2022-04-15 | Hubbard | Minnesota | 27057 | 4940 | 59 |
2311975 | 2311975 | 2022-03-16 | Sagadahoc | Maine | 23023 | 4940 | 28 |
2247577 | 2247577 | 2022-02-24 | Roosevelt | New Mexico | 35041 | 4940 | 91 |
2244326 | 2244326 | 2022-02-23 | Roosevelt | New Mexico | 35041 | 4940 | 91 |
2218813 | 2218813 | 2022-02-15 | Wyoming | Pennsylvania | 42131 | 4940 | 97 |
2219401 | 2219401 | 2022-02-15 | Orleans | Vermont | 50019 | 4940 | 33 |
2215562 | 2215562 | 2022-02-14 | Wyoming | Pennsylvania | 42131 | 4940 | 97 |
2169533 | 2169533 | 2022-01-31 | Taos | New Mexico | 35055 | 4940 | 80 |
2170910 | 2170910 | 2022-01-31 | Vilas | Wisconsin | 55125 | 4940 | 83 |
2150564 | 2150564 | 2022-01-25 | San Lorenzo | Puerto Rico | 72129 | 4940 | |
2081021 | 2081021 | 2022-01-04 | Morehouse | Louisiana | 22067 | 4940 | 119 |
2060546 | 2060546 | 2021-12-29 | Yell | Arkansas | 5149 | 4940 | 88 |
2060034 | 2060034 | 2021-12-28 | Windsor | Vermont | 50027 | 4940 | 43 |
2030007 | 2030007 | 2021-12-19 | Van Wert | Ohio | 39161 | 4940 | 105 |
2020571 | 2020571 | 2021-12-16 | Union | South Carolina | 45087 | 4940 | 112 |
2014416 | 2014416 | 2021-12-14 | Palo Pinto | Texas | 48363 | 4940 | 124 |
1989723 | 1989723 | 2021-12-07 | Plymouth | Iowa | 19149 | 4940 | 88 |
1986473 | 1986473 | 2021-12-06 | Plymouth | Iowa | 19149 | 4940 | 88 |
1983223 | 1983223 | 2021-12-05 | Plymouth | Iowa | 19149 | 4940 | 88 |
1979973 | 1979973 | 2021-12-04 | Plymouth | Iowa | 19149 | 4940 | 88 |
1976723 | 1976723 | 2021-12-03 | Plymouth | Iowa | 19149 | 4940 | 88 |
1977938 | 1977938 | 2021-12-03 | Fayette | Ohio | 39047 | 4940 | 72 |
1973474 | 1973474 | 2021-12-02 | Plymouth | Iowa | 19149 | 4940 | 88 |
1970224 | 1970224 | 2021-12-01 | Plymouth | Iowa | 19149 | 4940 | 88 |
1970838 | 1970838 | 2021-12-01 | Tippah | Mississippi | 28139 | 4940 | 83 |
1938118 | 1938118 | 2021-11-21 | Houghton | Michigan | 26061 | 4940 | 59 |
1934868 | 1934868 | 2021-11-20 | Houghton | Michigan | 26061 | 4940 | 59 |
1931618 | 1931618 | 2021-11-19 | Houghton | Michigan | 26061 | 4940 | 59 |
1906665 | 1906665 | 2021-11-11 | Snyder | Pennsylvania | 42109 | 4940 | 107 |
1892643 | 1892643 | 2021-11-07 | Mecosta | Michigan | 26107 | 4940 | 49 |
1889393 | 1889393 | 2021-11-06 | Mecosta | Michigan | 26107 | 4940 | 49 |
1886143 | 1886143 | 2021-11-05 | Mecosta | Michigan | 26107 | 4940 | 49 |
1867646 | 1867646 | 2021-10-30 | Greene | Pennsylvania | 42059 | 4940 | 55 |
1818223 | 1818223 | 2021-10-15 | Warren | Missouri | 29219 | 4940 | 44 |
1812092 | 1812092 | 2021-10-13 | Pasquotank | North Carolina | 37139 | 4940 | 98 |
1813359 | 1813359 | 2021-10-13 | Sheridan | Wyoming | 56033 | 4940 | 45 |
1786102 | 1786102 | 2021-10-05 | Person | North Carolina | 37145 | 4940 | 86 |
1780708 | 1780708 | 2021-10-03 | Mason | Washington | 53045 | 4940 | 57 |
1777458 | 1777458 | 2021-10-02 | Mason | Washington | 53045 | 4940 | 57 |
1774208 | 1774208 | 2021-10-01 | Mason | Washington | 53045 | 4940 | 57 |
1768895 | 1768895 | 2021-09-30 | Calloway | Kentucky | 21035 | 4940 | 59 |
1603553 | 1603553 | 2021-08-10 | Goodhue | Minnesota | 27049 | 4940 | 75 |
1599010 | 1599010 | 2021-08-09 | Russell | Alabama | 1113 | 4940 | 43 |
1588358 | 1588358 | 2021-08-05 | Toa Alta | Puerto Rico | 72135 | 4940 | |
1571306 | 1571306 | 2021-07-31 | Scott | Missouri | 29201 | 4940 | 88 |
1553471 | 1553471 | 2021-07-25 | Sweetwater | Wyoming | 56037 | 4940 | 43 |
1550224 | 1550224 | 2021-07-24 | Sweetwater | Wyoming | 56037 | 4940 | 43 |
1546977 | 1546977 | 2021-07-23 | Sweetwater | Wyoming | 56037 | 4940 | 43 |
1499822 | 1499822 | 2021-07-09 | Johnson | Missouri | 29101 | 4940 | 59 |
1343003 | 1343003 | 2021-05-22 | Tift | Georgia | 13277 | 4940 | 126 |
1309960 | 1309960 | 2021-05-11 | Pierce | Wisconsin | 55093 | 4940 | 43 |
1274244 | 1274244 | 2021-04-30 | Oconto | Wisconsin | 55083 | 4940 | 61 |
1238501 | 1238501 | 2021-04-19 | Dunn | Wisconsin | 55033 | 4940 | 32 |
1128302 | 1128302 | 2021-03-17 | Hot Spring | Arkansas | 5059 | 4940 | 68 |
1087779 | 1087779 | 2021-03-04 | Curry | New Mexico | 35009 | 4940 | 68 |
1057015 | 1057015 | 2021-02-23 | Eagle | Colorado | 8037 | 4940 | 20 |
1019881 | 1019881 | 2021-02-11 | Darke | Ohio | 39037 | 4940 | 102 |
987811 | 987811 | 2021-02-01 | Brown | South Dakota | 46013 | 4940 | 80 |
977498 | 977498 | 2021-01-29 | Steuben | New York | 36101 | 4940 | 134 |
965835 | 965835 | 2021-01-25 | Shawano | Wisconsin | 55115 | 4940 | 79 |
956475 | 956475 | 2021-01-23 | Flagler | Florida | 12035 | 4940 | 60 |
925961 | 925961 | 2021-01-13 | Clearfield | Pennsylvania | 42033 | 4940 | 60 |
916545 | 916545 | 2021-01-10 | Roane | Tennessee | 47145 | 4940 | 70 |
831713 | 831713 | 2020-12-15 | Wayne | Ohio | 39169 | 4940 | 127 |
697204 | 697204 | 2020-11-04 | Rock Island | Illinois | 17161 | 4940 | 106 |
684994 | 684994 | 2020-10-31 | Jackson | Mississippi | 28059 | 4940 | 91 |
540272 | 540272 | 2020-09-16 | Williamson | Tennessee | 47187 | 4940 | 35 |
265193 | 265193 | 2020-06-23 | Yuma | Arizona | 4027 | 4940 | 69 |
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);