ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
110 rows where cases = 4849 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 15
- Alabama 8
- Illinois 8
- Tennessee 8
- Virginia 7
- North Carolina 6
- Texas 6
- Indiana 5
- Colorado 4
- Pennsylvania 4
- Kentucky 3
- Louisiana 3
- Washington 3
- Wisconsin 3
- California 2
- Iowa 2
- Maine 2
- Michigan 2
- Mississippi 2
- Missouri 2
- Puerto Rico 2
- West Virginia 2
- Arkansas 1
- Florida 1
- Idaho 1
- Maryland 1
- Minnesota 1
- Nebraska 1
- North Dakota 1
- Ohio 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492379 | 2492379 | 2022-05-10 | Humphreys | Tennessee | 47085 | 4849 | 74 |
2489121 | 2489121 | 2022-05-09 | Humphreys | Tennessee | 47085 | 4849 | 74 |
2484060 | 2484060 | 2022-05-08 | Rush | Indiana | 18139 | 4849 | 58 |
2485864 | 2485864 | 2022-05-08 | Humphreys | Tennessee | 47085 | 4849 | 74 |
2480802 | 2480802 | 2022-05-07 | Rush | Indiana | 18139 | 4849 | 58 |
2482606 | 2482606 | 2022-05-07 | Humphreys | Tennessee | 47085 | 4849 | 74 |
2477544 | 2477544 | 2022-05-06 | Rush | Indiana | 18139 | 4849 | 58 |
2479348 | 2479348 | 2022-05-06 | Humphreys | Tennessee | 47085 | 4849 | 74 |
2474286 | 2474286 | 2022-05-05 | Rush | Indiana | 18139 | 4849 | 58 |
2476090 | 2476090 | 2022-05-05 | Humphreys | Tennessee | 47085 | 4849 | 74 |
2471029 | 2471029 | 2022-05-04 | Rush | Indiana | 18139 | 4849 | 58 |
2472833 | 2472833 | 2022-05-04 | Humphreys | Tennessee | 47085 | 4849 | 74 |
2470220 | 2470220 | 2022-05-03 | Taylor | Wisconsin | 55119 | 4849 | 72 |
2466964 | 2466964 | 2022-05-02 | Taylor | Wisconsin | 55119 | 4849 | 72 |
2438001 | 2438001 | 2022-04-24 | Teller | Colorado | 8119 | 4849 | 58 |
2434745 | 2434745 | 2022-04-23 | Teller | Colorado | 8119 | 4849 | 58 |
2431489 | 2431489 | 2022-04-22 | Teller | Colorado | 8119 | 4849 | 58 |
2369948 | 2369948 | 2022-04-03 | Clark | Illinois | 17023 | 4849 | 60 |
2366695 | 2366695 | 2022-04-02 | Clark | Illinois | 17023 | 4849 | 60 |
2363442 | 2363442 | 2022-04-01 | Clark | Illinois | 17023 | 4849 | 60 |
2360188 | 2360188 | 2022-03-31 | Clark | Illinois | 17023 | 4849 | 60 |
2316951 | 2316951 | 2022-03-17 | Orange | Vermont | 50017 | 4849 | 14 |
2301555 | 2301555 | 2022-03-13 | Union | Georgia | 13291 | 4849 | 149 |
2298303 | 2298303 | 2022-03-12 | Union | Georgia | 13291 | 4849 | 149 |
2295051 | 2295051 | 2022-03-11 | Union | Georgia | 13291 | 4849 | 149 |
2194111 | 2194111 | 2022-02-08 | Berrien | Georgia | 13019 | 4849 | 73 |
2192803 | 2192803 | 2022-02-07 | Cabo Rojo | Puerto Rico | 72023 | 4849 | |
2176563 | 2176563 | 2022-02-02 | Hatillo | Puerto Rico | 72065 | 4849 | |
2167479 | 2167479 | 2022-01-30 | Scott | Virginia | 51169 | 4849 | 93 |
2164224 | 2164224 | 2022-01-29 | Scott | Virginia | 51169 | 4849 | 93 |
2160969 | 2160969 | 2022-01-28 | Scott | Virginia | 51169 | 4849 | 93 |
2151852 | 2151852 | 2022-01-26 | Dodge | Georgia | 13091 | 4849 | 138 |
2150933 | 2150933 | 2022-01-25 | Lampasas | Texas | 48281 | 4849 | 74 |
2097302 | 2097302 | 2022-01-09 | Union | Louisiana | 22111 | 4849 | 114 |
2094050 | 2094050 | 2022-01-08 | Union | Louisiana | 22111 | 4849 | 114 |
2090798 | 2090798 | 2022-01-07 | Union | Louisiana | 22111 | 4849 | 114 |
2021426 | 2021426 | 2021-12-17 | Winston | Alabama | 1133 | 4849 | 111 |
2005584 | 2005584 | 2021-12-12 | Lee | Georgia | 13177 | 4849 | 82 |
2002333 | 2002333 | 2021-12-11 | Lee | Georgia | 13177 | 4849 | 82 |
1999083 | 1999083 | 2021-12-10 | Lee | Georgia | 13177 | 4849 | 82 |
1975409 | 1975409 | 2021-12-02 | Palo Pinto | Texas | 48363 | 4849 | 123 |
1966554 | 1966554 | 2021-11-30 | Gilmer | Georgia | 13123 | 4849 | 137 |
1962863 | 1962863 | 2021-11-29 | Clarke | Alabama | 1025 | 4849 | 86 |
1959612 | 1959612 | 2021-11-28 | Clarke | Alabama | 1025 | 4849 | 86 |
1956361 | 1956361 | 2021-11-27 | Clarke | Alabama | 1025 | 4849 | 86 |
1953110 | 1953110 | 2021-11-26 | Clarke | Alabama | 1025 | 4849 | 86 |
1949859 | 1949859 | 2021-11-25 | Clarke | Alabama | 1025 | 4849 | 86 |
1917861 | 1917861 | 2021-11-15 | Stephens | Georgia | 13257 | 4849 | 115 |
1906669 | 1906669 | 2021-11-11 | Tioga | Pennsylvania | 42117 | 4849 | 138 |
1895079 | 1895079 | 2021-11-08 | Lumpkin | Georgia | 13187 | 4849 | 107 |
1867632 | 1867632 | 2021-10-30 | Clarion | Pennsylvania | 42031 | 4849 | 124 |
1853736 | 1853736 | 2021-10-26 | Nobles | Minnesota | 27105 | 4849 | 52 |
1830805 | 1830805 | 2021-10-19 | Oxford | Maine | 23017 | 4849 | 77 |
1797010 | 1797010 | 2021-10-08 | Randolph | West Virginia | 54083 | 4849 | 39 |
1770630 | 1770630 | 2021-09-30 | Kendall | Texas | 48259 | 4849 | 90 |
1697075 | 1697075 | 2021-09-08 | Morgan | Illinois | 17137 | 4849 | 117 |
1684991 | 1684991 | 2021-09-04 | Polk | Missouri | 29167 | 4849 | 52 |
1586014 | 1586014 | 2021-08-05 | Russell | Alabama | 1113 | 4849 | 43 |
1559838 | 1559838 | 2021-07-27 | Jefferson | West Virginia | 54037 | 4849 | 60 |
1553194 | 1553194 | 2021-07-25 | Fauquier | Virginia | 51061 | 4849 | 69 |
1549947 | 1549947 | 2021-07-24 | Fauquier | Virginia | 51061 | 4849 | 69 |
1546700 | 1546700 | 2021-07-23 | Fauquier | Virginia | 51061 | 4849 | 69 |
1543453 | 1543453 | 2021-07-22 | Fauquier | Virginia | 51061 | 4849 | 69 |
1515561 | 1515561 | 2021-07-14 | Hopkins | Kentucky | 21107 | 4849 | 151 |
1489955 | 1489955 | 2021-07-06 | Bolivar | Mississippi | 28011 | 4849 | 134 |
1467232 | 1467232 | 2021-06-29 | Bolivar | Mississippi | 28011 | 4849 | 134 |
1460026 | 1460026 | 2021-06-27 | Woodford | Illinois | 17203 | 4849 | 96 |
1456781 | 1456781 | 2021-06-26 | Woodford | Illinois | 17203 | 4849 | 96 |
1453536 | 1453536 | 2021-06-25 | Woodford | Illinois | 17203 | 4849 | 96 |
1440277 | 1440277 | 2021-06-21 | Colquitt | Georgia | 13071 | 4849 | 128 |
1437030 | 1437030 | 2021-06-20 | Colquitt | Georgia | 13071 | 4849 | 128 |
1431658 | 1431658 | 2021-06-18 | Johnson | Missouri | 29101 | 4849 | 57 |
1391380 | 1391380 | 2021-06-06 | Nevada | California | 6057 | 4849 | 75 |
1393162 | 1393162 | 2021-06-06 | Watauga | North Carolina | 37189 | 4849 | 31 |
1389917 | 1389917 | 2021-06-05 | Watauga | North Carolina | 37189 | 4849 | 31 |
1386672 | 1386672 | 2021-06-04 | Watauga | North Carolina | 37189 | 4849 | 31 |
1376242 | 1376242 | 2021-06-01 | Newaygo | Michigan | 26123 | 4849 | 66 |
1359056 | 1359056 | 2021-05-27 | Hendry | Florida | 12051 | 4849 | 86 |
1346583 | 1346583 | 2021-05-23 | Marshall | Iowa | 19127 | 4849 | 76 |
1343335 | 1343335 | 2021-05-22 | Marshall | Iowa | 19127 | 4849 | 76 |
1339480 | 1339480 | 2021-05-21 | Broomfield | Colorado | 8014 | 4849 | 75 |
1245600 | 1245600 | 2021-04-22 | Tift | Georgia | 13277 | 4849 | 125 |
1244485 | 1244485 | 2021-04-21 | Chambers | Texas | 48071 | 4849 | 48 |
1241238 | 1241238 | 2021-04-20 | Chambers | Texas | 48071 | 4849 | 48 |
1236342 | 1236342 | 2021-04-19 | Boyd | Kentucky | 21019 | 4849 | 72 |
1136593 | 1136593 | 2021-03-19 | Edgecombe | North Carolina | 37065 | 4849 | 100 |
1124222 | 1124222 | 2021-03-15 | Franklin | Tennessee | 47051 | 4849 | 85 |
1083902 | 1083902 | 2021-03-03 | Androscoggin | Maine | 23001 | 4849 | 56 |
1009366 | 1009366 | 2021-02-08 | Midland | Michigan | 26111 | 4849 | 61 |
1003715 | 1003715 | 2021-02-06 | Union | Ohio | 39159 | 4849 | 33 |
990271 | 990271 | 2021-02-02 | Buffalo | Nebraska | 31019 | 4849 | 54 |
929695 | 929695 | 2021-01-14 | Liberty | Texas | 48291 | 4849 | 107 |
906194 | 906194 | 2021-01-07 | Rockingham | North Carolina | 37157 | 4849 | 30 |
897726 | 897726 | 2021-01-05 | Blount | Alabama | 1009 | 4849 | 63 |
883809 | 883809 | 2020-12-31 | Somerset | Pennsylvania | 42111 | 4849 | 81 |
700365 | 700365 | 2020-11-05 | Twin Falls | Idaho | 16083 | 4849 | 54 |
670754 | 670754 | 2020-10-27 | Sebastian | Arkansas | 5131 | 4849 | 93 |
641824 | 641824 | 2020-10-18 | Forsyth | Georgia | 13117 | 4849 | 51 |
581756 | 581756 | 2020-09-29 | Union | North Carolina | 37179 | 4849 | 59 |
562326 | 562326 | 2020-09-23 | Cass | North Dakota | 38017 | 4849 | 77 |
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);