ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
87 rows where cases = 4792 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- New Mexico 8
- North Carolina 8
- Virginia 7
- Wisconsin 6
- Illinois 5
- Louisiana 4
- Mississippi 4
- Montana 4
- Arkansas 3
- Georgia 3
- Idaho 3
- Kansas 3
- Michigan 2
- Minnesota 2
- Missouri 2
- New York 2
- North Dakota 2
- South Carolina 2
- Tennessee 2
- Texas 2
- Alabama 1
- Arizona 1
- California 1
- Colorado 1
- Indiana 1
- Iowa 1
- Kentucky 1
- Ohio 1
- Oklahoma 1
- Pennsylvania 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2482734 | 2482734 | 2022-05-07 | Fayette | Texas | 48149 | 4792 | 105 |
2362993 | 2362993 | 2022-04-01 | Phillips | Arkansas | 5107 | 4792 | 97 |
2359739 | 2359739 | 2022-03-31 | Phillips | Arkansas | 5107 | 4792 | 97 |
2324708 | 2324708 | 2022-03-20 | Dickinson | Kansas | 20041 | 4792 | 75 |
2321454 | 2321454 | 2022-03-19 | Dickinson | Kansas | 20041 | 4792 | 75 |
2318200 | 2318200 | 2022-03-18 | Dickinson | Kansas | 20041 | 4792 | 75 |
2266692 | 2266692 | 2022-03-02 | Jasper | Mississippi | 28061 | 4792 | 73 |
2263441 | 2263441 | 2022-03-01 | Jasper | Mississippi | 28061 | 4792 | 73 |
2261960 | 2261960 | 2022-02-28 | Taylor | Wisconsin | 55119 | 4792 | 68 |
2246353 | 2246353 | 2022-02-24 | Clark | Illinois | 17023 | 4792 | 58 |
2222703 | 2222703 | 2022-02-16 | Fluvanna | Virginia | 51065 | 4792 | 37 |
2155115 | 2155115 | 2022-01-27 | Fannin | Georgia | 13111 | 4792 | 126 |
2099310 | 2099310 | 2022-01-09 | Kewaunee | Wisconsin | 55061 | 4792 | 51 |
2096059 | 2096059 | 2022-01-08 | Kewaunee | Wisconsin | 55061 | 4792 | 51 |
2092807 | 2092807 | 2022-01-07 | Kewaunee | Wisconsin | 55061 | 4792 | 51 |
2052250 | 2052250 | 2021-12-26 | Lake | Montana | 30047 | 4792 | 86 |
2049000 | 2049000 | 2021-12-25 | Lake | Montana | 30047 | 4792 | 86 |
2045750 | 2045750 | 2021-12-24 | Lake | Montana | 30047 | 4792 | 86 |
2042500 | 2042500 | 2021-12-23 | Lake | Montana | 30047 | 4792 | 86 |
2029693 | 2029693 | 2021-12-19 | Luna | New Mexico | 35029 | 4792 | 101 |
2029830 | 2029830 | 2021-12-19 | Montgomery | North Carolina | 37123 | 4792 | 110 |
2026442 | 2026442 | 2021-12-18 | Luna | New Mexico | 35029 | 4792 | 101 |
2026579 | 2026579 | 2021-12-18 | Montgomery | North Carolina | 37123 | 4792 | 110 |
2027534 | 2027534 | 2021-12-18 | Washington | Vermont | 50023 | 4792 | 31 |
2023191 | 2023191 | 2021-12-17 | Luna | New Mexico | 35029 | 4792 | 101 |
2023328 | 2023328 | 2021-12-17 | Montgomery | North Carolina | 37123 | 4792 | 110 |
2009814 | 2009814 | 2021-12-13 | Leflore | Mississippi | 28083 | 4792 | 144 |
1970495 | 1970495 | 2021-12-01 | Franklin | Louisiana | 22041 | 4792 | 140 |
1971171 | 1971171 | 2021-12-01 | Cibola | New Mexico | 35006 | 4792 | 149 |
1943284 | 1943284 | 2021-11-22 | Lincoln | Wisconsin | 55069 | 4792 | 113 |
1872894 | 1872894 | 2021-11-01 | Grayson | Kentucky | 21085 | 4792 | 91 |
1851401 | 1851401 | 2021-10-25 | Greene | Pennsylvania | 42059 | 4792 | 53 |
1847693 | 1847693 | 2021-10-24 | Rio Arriba | New Mexico | 35039 | 4792 | 83 |
1844443 | 1844443 | 2021-10-23 | Rio Arriba | New Mexico | 35039 | 4792 | 83 |
1841193 | 1841193 | 2021-10-22 | Rio Arriba | New Mexico | 35039 | 4792 | 83 |
1814716 | 1814716 | 2021-10-14 | Freeborn | Minnesota | 27047 | 4792 | 42 |
1698973 | 1698973 | 2021-09-08 | Henry | Tennessee | 47079 | 4792 | 76 |
1672875 | 1672875 | 2021-08-31 | Williamsburg | South Carolina | 45089 | 4792 | 109 |
1587126 | 1587126 | 2021-08-05 | St. John the Baptist | Louisiana | 22095 | 4792 | 147 |
1575918 | 1575918 | 2021-08-01 | Culpeper | Virginia | 51047 | 4792 | 69 |
1572670 | 1572670 | 2021-07-31 | Culpeper | Virginia | 51047 | 4792 | 69 |
1569422 | 1569422 | 2021-07-30 | Culpeper | Virginia | 51047 | 4792 | 69 |
1558068 | 1558068 | 2021-07-27 | Douglas | Minnesota | 27041 | 4792 | 81 |
1534616 | 1534616 | 2021-07-20 | Effingham | Illinois | 17049 | 4792 | 85 |
1516642 | 1516642 | 2021-07-14 | Shelby | Ohio | 39149 | 4792 | 97 |
1513182 | 1513182 | 2021-07-13 | Chatham | North Carolina | 37037 | 4792 | 89 |
1438586 | 1438586 | 2021-06-20 | Richmond | North Carolina | 37153 | 4792 | 97 |
1435339 | 1435339 | 2021-06-19 | Richmond | North Carolina | 37153 | 4792 | 97 |
1432092 | 1432092 | 2021-06-18 | Richmond | North Carolina | 37153 | 4792 | 97 |
1388345 | 1388345 | 2021-06-05 | Colquitt | Georgia | 13071 | 4792 | 125 |
1357413 | 1357413 | 2021-05-26 | Hoke | North Carolina | 37093 | 4792 | 56 |
1347028 | 1347028 | 2021-05-23 | Newaygo | Michigan | 26123 | 4792 | 66 |
1343780 | 1343780 | 2021-05-22 | Newaygo | Michigan | 26123 | 4792 | 66 |
1344023 | 1344023 | 2021-05-22 | Johnson | Missouri | 29101 | 4792 | 54 |
1300146 | 1300146 | 2021-05-08 | Mercer | West Virginia | 54055 | 4792 | 115 |
1289340 | 1289340 | 2021-05-05 | Williams | North Dakota | 38105 | 4792 | 38 |
1232647 | 1232647 | 2021-04-18 | Bingham | Idaho | 16011 | 4792 | 73 |
1229398 | 1229398 | 2021-04-17 | Bingham | Idaho | 16011 | 4792 | 73 |
1226150 | 1226150 | 2021-04-16 | Bingham | Idaho | 16011 | 4792 | 73 |
1201439 | 1201439 | 2021-04-08 | Otero | New Mexico | 35035 | 4792 | 74 |
1193747 | 1193747 | 2021-04-06 | Jackson | Illinois | 17077 | 4792 | 73 |
1190096 | 1190096 | 2021-04-05 | Tehama | California | 6103 | 4792 | 52 |
1183286 | 1183286 | 2021-04-02 | Dunn | Wisconsin | 55033 | 4792 | 31 |
1172226 | 1172226 | 2021-03-30 | Cattaraugus | New York | 36009 | 4792 | 79 |
1103702 | 1103702 | 2021-03-09 | Callaway | Missouri | 29027 | 4792 | 46 |
1104744 | 1104744 | 2021-03-09 | Franklin | Tennessee | 47051 | 4792 | 85 |
1086840 | 1086840 | 2021-03-04 | Sioux | Iowa | 19167 | 4792 | 69 |
1053489 | 1053489 | 2021-02-21 | Fremont | Wyoming | 56013 | 4792 | 81 |
1048182 | 1048182 | 2021-02-20 | St. Martin | Louisiana | 22099 | 4792 | 110 |
1044937 | 1044937 | 2021-02-19 | St. Martin | Louisiana | 22099 | 4792 | 110 |
991524 | 991524 | 2021-02-02 | Augusta | Virginia | 51015 | 4792 | 48 |
982745 | 982745 | 2021-01-31 | Knox | Illinois | 17095 | 4792 | 149 |
953368 | 953368 | 2021-01-22 | Laurens | Georgia | 13175 | 4792 | 131 |
951804 | 951804 | 2021-01-21 | Cherokee | Oklahoma | 40021 | 4792 | 27 |
948434 | 948434 | 2021-01-20 | Morton | North Dakota | 38059 | 4792 | 92 |
897506 | 897506 | 2021-01-04 | Roanoke | Virginia | 51161 | 4792 | 68 |
845965 | 845965 | 2020-12-20 | Pope | Arkansas | 5115 | 4792 | 50 |
847229 | 847229 | 2020-12-20 | Forrest | Mississippi | 28035 | 4792 | 93 |
843280 | 843280 | 2020-12-19 | Grant | Indiana | 18053 | 4792 | 86 |
753526 | 753526 | 2020-11-21 | Broome | New York | 36007 | 4792 | 129 |
703039 | 703039 | 2020-11-06 | Etowah | Alabama | 1055 | 4792 | 57 |
608723 | 608723 | 2020-10-07 | Richmond city | Virginia | 51760 | 4792 | 62 |
590149 | 590149 | 2020-10-02 | McHenry | Illinois | 17111 | 4792 | 123 |
486182 | 486182 | 2020-08-31 | Jefferson | Colorado | 8059 | 4792 | 237 |
481851 | 481851 | 2020-08-29 | Berkeley | South Carolina | 45015 | 4792 | 78 |
350252 | 350252 | 2020-07-19 | Williamson | Texas | 48491 | 4792 | 72 |
309300 | 309300 | 2020-07-07 | Pinal | Arizona | 4021 | 4792 | 81 |
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);