ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
71 rows where cases = 5130 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Georgia 10
- Oklahoma 8
- Kentucky 5
- Arkansas 4
- New York 4
- Alabama 3
- Illinois 3
- Ohio 3
- Texas 3
- Iowa 2
- Michigan 2
- Minnesota 2
- Puerto Rico 2
- Utah 2
- Virginia 2
- Washington 2
- Arizona 1
- Delaware 1
- Florida 1
- Maine 1
- Maryland 1
- Mississippi 1
- Missouri 1
- New Jersey 1
- North Carolina 1
- North Dakota 1
- Oregon 1
- Pennsylvania 1
- South Carolina 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499727 | 2499727 | 2022-05-13 | Logan | Arkansas | 5083 | 5130 | 80 |
2496469 | 2496469 | 2022-05-12 | Logan | Arkansas | 5083 | 5130 | 80 |
2489810 | 2489810 | 2022-05-10 | Cherokee | Alabama | 1019 | 5130 | 86 |
2462836 | 2462836 | 2022-05-01 | Barranquitas | Puerto Rico | 72019 | 5130 | |
2438141 | 2438141 | 2022-04-24 | Fannin | Georgia | 13111 | 5130 | 156 |
2434885 | 2434885 | 2022-04-23 | Fannin | Georgia | 13111 | 5130 | 156 |
2431629 | 2431629 | 2022-04-22 | Fannin | Georgia | 13111 | 5130 | 156 |
2428373 | 2428373 | 2022-04-21 | Fannin | Georgia | 13111 | 5130 | 156 |
2425117 | 2425117 | 2022-04-20 | Fannin | Georgia | 13111 | 5130 | 156 |
2397638 | 2397638 | 2022-04-11 | Wasco | Oregon | 41065 | 5130 | 60 |
2341251 | 2341251 | 2022-03-25 | Lincoln | Maine | 23015 | 5130 | 32 |
2337428 | 2337428 | 2022-03-24 | Edgar | Illinois | 17045 | 5130 | 79 |
2293643 | 2293643 | 2022-03-10 | Las Piedras | Puerto Rico | 72085 | 5130 | |
2253464 | 2253464 | 2022-02-26 | Somerset | Maryland | 24039 | 5130 | 69 |
2223664 | 2223664 | 2022-02-17 | Richland | Illinois | 17159 | 5130 | 81 |
2177855 | 2177855 | 2022-02-03 | Burke | Georgia | 13033 | 5130 | 92 |
2175602 | 2175602 | 2022-02-02 | Wabasha | Minnesota | 27157 | 5130 | 14 |
2175619 | 2175619 | 2022-02-02 | Chickasaw | Mississippi | 28017 | 5130 | 84 |
2170592 | 2170592 | 2022-01-31 | Sevier | Utah | 49041 | 5130 | 23 |
2091153 | 2091153 | 2022-01-07 | Dunklin | Missouri | 29069 | 5130 | 93 |
2080959 | 2080959 | 2022-01-04 | Ohio | Kentucky | 21183 | 5130 | 91 |
2073401 | 2073401 | 2022-01-02 | Lawrence | Alabama | 1079 | 5130 | 136 |
2064042 | 2064042 | 2021-12-30 | Dawson | Georgia | 13085 | 5130 | 80 |
2064155 | 2064155 | 2021-12-30 | White | Georgia | 13311 | 5130 | 135 |
2038098 | 2038098 | 2021-12-22 | Madison | Georgia | 13195 | 5130 | 82 |
1898918 | 1898918 | 2021-11-09 | Logan | Kentucky | 21141 | 5130 | 84 |
1859035 | 1859035 | 2021-10-28 | Unknown | Arkansas | 5130 | 0 | |
1841254 | 1841254 | 2021-10-22 | Tioga | New York | 36107 | 5130 | 72 |
1842074 | 1842074 | 2021-10-22 | Grimes | Texas | 48185 | 5130 | 105 |
1837127 | 1837127 | 2021-10-21 | Calloway | Kentucky | 21035 | 5130 | 60 |
1828675 | 1828675 | 2021-10-18 | Perry | Pennsylvania | 42099 | 5130 | 116 |
1788748 | 1788748 | 2021-10-06 | Morrison | Minnesota | 27097 | 5130 | 63 |
1781887 | 1781887 | 2021-10-04 | Boyle | Kentucky | 21021 | 5130 | 80 |
1703084 | 1703084 | 2021-09-10 | Union | Arkansas | 5139 | 5130 | 121 |
1624996 | 1624996 | 2021-08-17 | Russell | Alabama | 1113 | 5130 | 51 |
1607509 | 1607509 | 2021-08-11 | Williams | North Dakota | 38105 | 5130 | 40 |
1604409 | 1604409 | 2021-08-10 | Osage | Oklahoma | 40113 | 5130 | 84 |
1601160 | 1601160 | 2021-08-09 | Osage | Oklahoma | 40113 | 5130 | 84 |
1597912 | 1597912 | 2021-08-08 | Osage | Oklahoma | 40113 | 5130 | 84 |
1594663 | 1594663 | 2021-08-07 | Osage | Oklahoma | 40113 | 5130 | 84 |
1591414 | 1591414 | 2021-08-06 | Osage | Oklahoma | 40113 | 5130 | 84 |
1588025 | 1588025 | 2021-08-05 | Auglaize | Ohio | 39011 | 5130 | 87 |
1588165 | 1588165 | 2021-08-05 | Osage | Oklahoma | 40113 | 5130 | 84 |
1584915 | 1584915 | 2021-08-04 | Osage | Oklahoma | 40113 | 5130 | 84 |
1563642 | 1563642 | 2021-07-29 | Colquitt | Georgia | 13071 | 5130 | 131 |
1536443 | 1536443 | 2021-07-20 | Newberry | South Carolina | 45071 | 5130 | 108 |
1492422 | 1492422 | 2021-07-07 | Jackson | Illinois | 17077 | 5130 | 76 |
1346614 | 1346614 | 2021-05-23 | Webster | Iowa | 19187 | 5130 | 94 |
1343366 | 1343366 | 2021-05-22 | Webster | Iowa | 19187 | 5130 | 94 |
1341095 | 1341095 | 2021-05-21 | Herkimer | New York | 36043 | 5130 | 107 |
1339074 | 1339074 | 2021-05-20 | Walla Walla | Washington | 53071 | 5130 | 65 |
1215477 | 1215477 | 2021-04-12 | Box Elder | Utah | 49003 | 5130 | 50 |
1205920 | 1205920 | 2021-04-09 | Cowlitz | Washington | 53015 | 5130 | 77 |
1162712 | 1162712 | 2021-03-27 | Darke | Ohio | 39037 | 5130 | 121 |
1115139 | 1115139 | 2021-03-12 | Shawano | Wisconsin | 55115 | 5130 | 81 |
1086344 | 1086344 | 2021-03-04 | Suwannee | Florida | 12121 | 5130 | 133 |
1056438 | 1056438 | 2021-02-22 | Augusta | Virginia | 51015 | 5130 | 54 |
1045704 | 1045704 | 2021-02-19 | Franklin | North Carolina | 37069 | 5130 | 42 |
1045869 | 1045869 | 2021-02-19 | Lawrence | Ohio | 39087 | 5130 | 74 |
974534 | 974534 | 2021-01-28 | Grady | Oklahoma | 40051 | 5130 | 55 |
915223 | 915223 | 2021-01-10 | Ionia | Michigan | 26067 | 5130 | 53 |
911978 | 911978 | 2021-01-09 | Ionia | Michigan | 26067 | 5130 | 53 |
873643 | 873643 | 2020-12-28 | Saratoga | New York | 36091 | 5130 | 36 |
843581 | 843581 | 2020-12-19 | Daviess | Kentucky | 21059 | 5130 | 76 |
812758 | 812758 | 2020-12-09 | Comal | Texas | 48091 | 5130 | 133 |
722157 | 722157 | 2020-11-11 | Arlington | Virginia | 51013 | 5130 | 155 |
695971 | 695971 | 2020-11-03 | Ellis | Texas | 48139 | 5130 | 83 |
581621 | 581621 | 2020-09-29 | Dutchess | New York | 36027 | 5130 | 156 |
379608 | 379608 | 2020-07-29 | Navajo | Arizona | 4017 | 5130 | 180 |
331760 | 331760 | 2020-07-14 | Sussex | Delaware | 10005 | 5130 | 177 |
276220 | 276220 | 2020-06-26 | Burlington | New Jersey | 34005 | 5130 | 414 |
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);