ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
89 rows where cases = 5726 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
- Kentucky 15
- Michigan 7
- Maryland 6
- Minnesota 5
- Puerto Rico 5
- Virginia 5
- Illinois 4
- North Carolina 4
- Wisconsin 4
- Arkansas 3
- Georgia 3
- Missouri 3
- Ohio 3
- Oklahoma 3
- Alabama 2
- Louisiana 2
- Mississippi 2
- New York 2
- South Carolina 2
- Texas 2
- California 1
- Florida 1
- Idaho 1
- Indiana 1
- New Mexico 1
- Pennsylvania 1
- South Dakota 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2496248 | 2496248 | 2022-05-11 | Jackson | Wisconsin | 55053 | 5726 | 43 |
2484369 | 2484369 | 2022-05-08 | McCreary | Kentucky | 21147 | 5726 | 82 |
2481111 | 2481111 | 2022-05-07 | McCreary | Kentucky | 21147 | 5726 | 82 |
2477853 | 2477853 | 2022-05-06 | McCreary | Kentucky | 21147 | 5726 | 82 |
2474595 | 2474595 | 2022-05-05 | McCreary | Kentucky | 21147 | 5726 | 82 |
2471338 | 2471338 | 2022-05-04 | McCreary | Kentucky | 21147 | 5726 | 82 |
2468082 | 2468082 | 2022-05-03 | McCreary | Kentucky | 21147 | 5726 | 82 |
2464827 | 2464827 | 2022-05-02 | McCreary | Kentucky | 21147 | 5726 | 82 |
2438913 | 2438913 | 2022-04-24 | Garrett | Maryland | 24023 | 5726 | 116 |
2435657 | 2435657 | 2022-04-23 | Garrett | Maryland | 24023 | 5726 | 116 |
2432401 | 2432401 | 2022-04-22 | Garrett | Maryland | 24023 | 5726 | 116 |
2429145 | 2429145 | 2022-04-21 | Garrett | Maryland | 24023 | 5726 | 116 |
2425889 | 2425889 | 2022-04-20 | Garrett | Maryland | 24023 | 5726 | 116 |
2408182 | 2408182 | 2022-04-14 | Scott | Virginia | 51169 | 5726 | 111 |
2316404 | 2316404 | 2022-03-17 | Juana Diaz | Puerto Rico | 72075 | 5726 | |
2286601 | 2286601 | 2022-03-08 | San Miguel | New Mexico | 35047 | 5726 | 51 |
2262450 | 2262450 | 2022-03-01 | Grady | Georgia | 13131 | 5726 | 105 |
2260689 | 2260689 | 2022-02-28 | Greene | North Carolina | 37079 | 5726 | 55 |
2240406 | 2240406 | 2022-02-22 | St. James | Louisiana | 22093 | 5726 | 75 |
2202600 | 2202600 | 2022-02-10 | Manati | Puerto Rico | 72091 | 5726 | |
2203439 | 2203439 | 2022-02-10 | Vernon | Wisconsin | 55123 | 5726 | 85 |
2197457 | 2197457 | 2022-02-09 | Monroe | Georgia | 13207 | 5726 | 159 |
2133037 | 2133037 | 2022-01-20 | Franklin | Louisiana | 22041 | 5726 | 145 |
2126865 | 2126865 | 2022-01-18 | Scott | Mississippi | 28123 | 5726 | 101 |
2102565 | 2102565 | 2022-01-10 | Lincoln | Wisconsin | 55069 | 5726 | 125 |
2097167 | 2097167 | 2022-01-09 | Grant | Kentucky | 21081 | 5726 | 46 |
2093915 | 2093915 | 2022-01-08 | Grant | Kentucky | 21081 | 5726 | 46 |
2090663 | 2090663 | 2022-01-07 | Grant | Kentucky | 21081 | 5726 | 46 |
2012313 | 2012313 | 2021-12-14 | Adams | Indiana | 18001 | 5726 | 85 |
2006690 | 2006690 | 2021-12-12 | Pulaski | Missouri | 29169 | 5726 | 97 |
1990977 | 1990977 | 2021-12-07 | Ottawa | Ohio | 39123 | 5726 | 102 |
1971785 | 1971785 | 2021-12-01 | Colleton | South Carolina | 45029 | 5726 | 190 |
1945652 | 1945652 | 2021-11-23 | McKean | Pennsylvania | 42083 | 5726 | 101 |
1906242 | 1906242 | 2021-11-11 | Tioga | New York | 36107 | 5726 | 73 |
1892676 | 1892676 | 2021-11-07 | Becker | Minnesota | 27005 | 5726 | 68 |
1889426 | 1889426 | 2021-11-06 | Becker | Minnesota | 27005 | 5726 | 68 |
1886176 | 1886176 | 2021-11-05 | Becker | Minnesota | 27005 | 5726 | 68 |
1851507 | 1851507 | 2021-10-25 | Toa Alta | Puerto Rico | 72135 | 5726 | |
1848257 | 1848257 | 2021-10-24 | Toa Alta | Puerto Rico | 72135 | 5726 | |
1845007 | 1845007 | 2021-10-23 | Toa Alta | Puerto Rico | 72135 | 5726 | |
1829790 | 1829790 | 2021-10-19 | Union | Arkansas | 5139 | 5726 | 136 |
1822601 | 1822601 | 2021-10-16 | Howard | Texas | 48227 | 5726 | 130 |
1814070 | 1814070 | 2021-10-14 | Woodford | Illinois | 17203 | 5726 | 105 |
1779849 | 1779849 | 2021-10-03 | Unknown | Oklahoma | 5726 | 0 | |
1776599 | 1776599 | 2021-10-02 | Unknown | Oklahoma | 5726 | 0 | |
1773349 | 1773349 | 2021-10-01 | Unknown | Oklahoma | 5726 | 0 | |
1766040 | 1766040 | 2021-09-29 | Winona | Minnesota | 27169 | 5726 | 52 |
1748095 | 1748095 | 2021-09-23 | Danville city | Virginia | 51590 | 5726 | 166 |
1676920 | 1676920 | 2021-09-02 | Chilton | Alabama | 1021 | 5726 | 120 |
1673682 | 1673682 | 2021-09-01 | Covington | Alabama | 1039 | 5726 | 148 |
1650148 | 1650148 | 2021-08-24 | Brown | South Dakota | 46013 | 5726 | 95 |
1577530 | 1577530 | 2021-08-02 | Tuscola | Michigan | 26157 | 5726 | 174 |
1574282 | 1574282 | 2021-08-01 | Tuscola | Michigan | 26157 | 5726 | 174 |
1571034 | 1571034 | 2021-07-31 | Tuscola | Michigan | 26157 | 5726 | 174 |
1567786 | 1567786 | 2021-07-30 | Tuscola | Michigan | 26157 | 5726 | 174 |
1454403 | 1454403 | 2021-06-25 | Newton | Missouri | 29145 | 5726 | 80 |
1437703 | 1437703 | 2021-06-20 | Pike | Kentucky | 21195 | 5726 | 106 |
1437859 | 1437859 | 2021-06-20 | Branch | Michigan | 26023 | 5726 | 120 |
1434456 | 1434456 | 2021-06-19 | Pike | Kentucky | 21195 | 5726 | 106 |
1434612 | 1434612 | 2021-06-19 | Branch | Michigan | 26023 | 5726 | 120 |
1431210 | 1431210 | 2021-06-18 | Pike | Kentucky | 21195 | 5726 | 106 |
1431365 | 1431365 | 2021-06-18 | Branch | Michigan | 26023 | 5726 | 120 |
1428471 | 1428471 | 2021-06-17 | Taney | Missouri | 29213 | 5726 | 97 |
1428969 | 1428969 | 2021-06-17 | Lawrence | Ohio | 39087 | 5726 | 102 |
1355667 | 1355667 | 2021-05-26 | Lassen | California | 6035 | 5726 | 24 |
1356078 | 1356078 | 2021-05-26 | Coles | Illinois | 17029 | 5726 | 101 |
1304896 | 1304896 | 2021-05-10 | Otter Tail | Minnesota | 27111 | 5726 | 78 |
1283724 | 1283724 | 2021-05-03 | Augusta | Virginia | 51015 | 5726 | 70 |
1280477 | 1280477 | 2021-05-02 | Augusta | Virginia | 51015 | 5726 | 70 |
1261922 | 1261922 | 2021-04-27 | Clinton | Illinois | 17027 | 5726 | 99 |
1258675 | 1258675 | 2021-04-26 | Clinton | Illinois | 17027 | 5726 | 99 |
1249542 | 1249542 | 2021-04-23 | St. Mary's | Maryland | 24037 | 5726 | 123 |
1221052 | 1221052 | 2021-04-14 | Lenoir | North Carolina | 37107 | 5726 | 110 |
1195065 | 1195065 | 2021-04-06 | Lee | North Carolina | 37105 | 5726 | 75 |
1191817 | 1191817 | 2021-04-05 | Lee | North Carolina | 37105 | 5726 | 75 |
1100837 | 1100837 | 2021-03-08 | St. Lawrence | New York | 36089 | 5726 | 91 |
1017941 | 1017941 | 2021-02-11 | Greene | Arkansas | 5055 | 5726 | 72 |
1010503 | 1010503 | 2021-02-08 | Georgetown | South Carolina | 45043 | 5726 | 130 |
979876 | 979876 | 2021-01-30 | Christian | Kentucky | 21047 | 5726 | 74 |
891397 | 891397 | 2021-01-03 | Pope | Arkansas | 5115 | 5726 | 59 |
818042 | 818042 | 2020-12-11 | Madison | Mississippi | 28089 | 5726 | 121 |
818693 | 818693 | 2020-12-11 | Marion | Ohio | 39101 | 5726 | 74 |
804103 | 804103 | 2020-12-07 | Paulding | Georgia | 13223 | 5726 | 87 |
686735 | 686735 | 2020-10-31 | Marathon | Wisconsin | 55073 | 5726 | 61 |
647313 | 647313 | 2020-10-19 | Ector | Texas | 48135 | 5726 | 112 |
622288 | 622288 | 2020-10-12 | St. Johns | Florida | 12109 | 5726 | 76 |
618401 | 618401 | 2020-10-10 | Henrico | Virginia | 51087 | 5726 | 221 |
486939 | 486939 | 2020-08-31 | Fayette | Kentucky | 21067 | 5726 | 56 |
412244 | 412244 | 2020-08-08 | Canyon | Idaho | 16027 | 5726 | 48 |
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);