ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
69 rows where cases = 5282 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 25
- Missouri 8
- Georgia 7
- Mississippi 7
- North Carolina 5
- Tennessee 5
- West Virginia 4
- Alabama 3
- Virginia 3
- Arkansas 2
- Indiana 2
- Kansas 2
- Maryland 2
- Minnesota 2
- Ohio 2
- Pennsylvania 2
- Puerto Rico 2
- Texas 2
- Wisconsin 2
- Illinois 1
- Kentucky 1
- Maine 1
- New Mexico 1
- Oregon 1
- South Dakota 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2352792 | 2352792 | 2022-03-28 | Fredericksburg city | Virginia | 51630 | 5282 | 38 |
2347982 | 2347982 | 2022-03-27 | Attala | Mississippi | 28007 | 5282 | 112 |
2344729 | 2344729 | 2022-03-26 | Attala | Mississippi | 28007 | 5282 | 112 |
2341476 | 2341476 | 2022-03-25 | Attala | Mississippi | 28007 | 5282 | 112 |
2338223 | 2338223 | 2022-03-24 | Attala | Mississippi | 28007 | 5282 | 112 |
2334969 | 2334969 | 2022-03-23 | Attala | Mississippi | 28007 | 5282 | 112 |
2331715 | 2331715 | 2022-03-22 | Attala | Mississippi | 28007 | 5282 | 112 |
2328463 | 2328463 | 2022-03-21 | Attala | Mississippi | 28007 | 5282 | 112 |
2320657 | 2320657 | 2022-03-19 | Clark | Arkansas | 5019 | 5282 | 78 |
2304680 | 2304680 | 2022-03-14 | Burke | Georgia | 13033 | 5282 | 104 |
2213957 | 2213957 | 2022-02-14 | Fountain | Indiana | 18045 | 5282 | 95 |
2200008 | 2200008 | 2022-02-09 | Scott | Virginia | 51169 | 5282 | 95 |
2191681 | 2191681 | 2022-02-07 | Talbot | Maryland | 24041 | 5282 | 76 |
2181890 | 2181890 | 2022-02-04 | Hancock | Maine | 23009 | 5282 | 72 |
2166380 | 2166380 | 2022-01-30 | Greene | North Carolina | 37079 | 5282 | 56 |
2163125 | 2163125 | 2022-01-29 | Greene | North Carolina | 37079 | 5282 | 56 |
2159870 | 2159870 | 2022-01-28 | Greene | North Carolina | 37079 | 5282 | 56 |
2143231 | 2143231 | 2022-01-23 | Nodaway | Missouri | 29147 | 5282 | 41 |
2139976 | 2139976 | 2022-01-22 | Nodaway | Missouri | 29147 | 5282 | 41 |
2140755 | 2140755 | 2022-01-22 | Cayey | Puerto Rico | 72035 | 5282 | |
2136720 | 2136720 | 2022-01-21 | Nodaway | Missouri | 29147 | 5282 | 41 |
2060843 | 2060843 | 2021-12-29 | Lumpkin | Georgia | 13187 | 5282 | 111 |
2057165 | 2057165 | 2021-12-28 | Pike | Alabama | 1109 | 5282 | 111 |
2015577 | 2015577 | 2021-12-15 | Daviess | Indiana | 18027 | 5282 | 122 |
1941114 | 1941114 | 2021-11-22 | Calloway | Kentucky | 21035 | 5282 | 64 |
1942562 | 1942562 | 2021-11-22 | Brookings | South Dakota | 46011 | 5282 | 39 |
1905907 | 1905907 | 2021-11-11 | Marion | Missouri | 29127 | 5282 | 64 |
1902658 | 1902658 | 2021-11-10 | Marion | Missouri | 29127 | 5282 | 64 |
1866936 | 1866936 | 2021-10-30 | Pulaski | Missouri | 29169 | 5282 | 79 |
1834189 | 1834189 | 2021-10-20 | Becker | Minnesota | 27005 | 5282 | 62 |
1816002 | 1816002 | 2021-10-14 | Bee | Texas | 48025 | 5282 | 124 |
1809505 | 1809505 | 2021-10-12 | Bee | Texas | 48025 | 5282 | 120 |
1791574 | 1791574 | 2021-10-07 | Lyon | Kansas | 20111 | 5282 | 91 |
1793769 | 1793769 | 2021-10-07 | Wayne | West Virginia | 54099 | 5282 | 64 |
1788325 | 1788325 | 2021-10-06 | Lyon | Kansas | 20111 | 5282 | 91 |
1789623 | 1789623 | 2021-10-06 | Malheur | Oregon | 41045 | 5282 | 72 |
1762751 | 1762751 | 2021-09-28 | McLeod | Minnesota | 27085 | 5282 | 65 |
1691520 | 1691520 | 2021-09-06 | Webster | Missouri | 29225 | 5282 | 82 |
1667041 | 1667041 | 2021-08-29 | Marion | West Virginia | 54049 | 5282 | 59 |
1647793 | 1647793 | 2021-08-24 | Baxter | Arkansas | 5005 | 5282 | 144 |
1636977 | 1636977 | 2021-08-20 | Huntingdon | Pennsylvania | 42061 | 5282 | 137 |
1617597 | 1617597 | 2021-08-14 | Toa Baja | Puerto Rico | 72137 | 5282 | |
1599479 | 1599479 | 2021-08-09 | Thomas | Georgia | 13275 | 5282 | 129 |
1602123 | 1602123 | 2021-08-09 | Dunn | Wisconsin | 55033 | 5282 | 35 |
1584659 | 1584659 | 2021-08-04 | Hoke | North Carolina | 37093 | 5282 | 56 |
1566343 | 1566343 | 2021-07-29 | Mercer | West Virginia | 54055 | 5282 | 129 |
1557180 | 1557180 | 2021-07-27 | Habersham | Georgia | 13137 | 5282 | 165 |
1556702 | 1556702 | 2021-07-26 | Campbell | Wyoming | 56005 | 5282 | 61 |
1299154 | 1299154 | 2021-05-08 | Seneca | Ohio | 39147 | 5282 | 121 |
1205968 | 1205968 | 2021-04-09 | Harrison | West Virginia | 54033 | 5282 | 81 |
1190282 | 1190282 | 2021-04-05 | Coffee | Georgia | 13069 | 5282 | 166 |
1162700 | 1162700 | 2021-03-27 | Belmont | Ohio | 39013 | 5282 | 159 |
1122302 | 1122302 | 2021-03-15 | Grundy | Illinois | 17063 | 5282 | 70 |
1073483 | 1073483 | 2021-02-28 | Polk | Georgia | 13233 | 5282 | 79 |
1046381 | 1046381 | 2021-02-19 | Warren | Tennessee | 47177 | 5282 | 73 |
1042478 | 1042478 | 2021-02-18 | Lenoir | North Carolina | 37107 | 5282 | 103 |
1039891 | 1039891 | 2021-02-17 | Warren | Tennessee | 47177 | 5282 | 73 |
1036646 | 1036646 | 2021-02-16 | Warren | Tennessee | 47177 | 5282 | 73 |
1033401 | 1033401 | 2021-02-15 | Warren | Tennessee | 47177 | 5282 | 73 |
952244 | 952244 | 2021-01-21 | Roane | Tennessee | 47145 | 5282 | 79 |
896321 | 896321 | 2021-01-04 | Valencia | New Mexico | 35061 | 5282 | 68 |
797138 | 797138 | 2020-12-05 | DeKalb | Alabama | 1049 | 5282 | 43 |
795465 | 795465 | 2020-12-04 | St. Francois | Missouri | 29187 | 5282 | 47 |
779942 | 779942 | 2020-11-29 | Lebanon | Pennsylvania | 42075 | 5282 | 106 |
719237 | 719237 | 2020-11-11 | Calhoun | Alabama | 1015 | 5282 | 77 |
706680 | 706680 | 2020-11-07 | Columbia | Georgia | 13073 | 5282 | 71 |
660610 | 660610 | 2020-10-23 | Norfolk city | Virginia | 51710 | 5282 | 85 |
603670 | 603670 | 2020-10-06 | Howard | Maryland | 24027 | 5282 | 123 |
573239 | 573239 | 2020-09-26 | Racine | Wisconsin | 55101 | 5282 | 95 |
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);