ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
69 rows where cases = 6399 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 8
- Oklahoma 7
- Illinois 4
- North Carolina 4
- Texas 4
- Wisconsin 4
- Ohio 3
- Virginia 3
- Arkansas 2
- Idaho 2
- Indiana 2
- Kansas 2
- Louisiana 2
- Maine 2
- Oregon 2
- Pennsylvania 2
- Washington 2
- Arizona 1
- California 1
- Colorado 1
- Florida 1
- Georgia 1
- Maryland 1
- Minnesota 1
- Mississippi 1
- New Jersey 1
- New Mexico 1
- North Dakota 1
- Puerto Rico 1
- Tennessee 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2491004 | 2491004 | 2022-05-10 | Waldo | Maine | 23027 | 6399 | 57 |
2440101 | 2440101 | 2022-04-24 | San Sebastian | Puerto Rico | 72131 | 6399 | |
2393193 | 2393193 | 2022-04-10 | Marion | Kentucky | 21155 | 6399 | 82 |
2389937 | 2389937 | 2022-04-09 | Marion | Kentucky | 21155 | 6399 | 82 |
2386681 | 2386681 | 2022-04-08 | Marion | Kentucky | 21155 | 6399 | 82 |
2383426 | 2383426 | 2022-04-07 | Marion | Kentucky | 21155 | 6399 | 82 |
2380171 | 2380171 | 2022-04-06 | Marion | Kentucky | 21155 | 6399 | 82 |
2376916 | 2376916 | 2022-04-05 | Marion | Kentucky | 21155 | 6399 | 82 |
2373664 | 2373664 | 2022-04-04 | Marion | Kentucky | 21155 | 6399 | 82 |
2305432 | 2305432 | 2022-03-14 | Plaquemines | Louisiana | 22075 | 6399 | 44 |
2236609 | 2236609 | 2022-02-21 | Douglas | Illinois | 17041 | 6399 | 58 |
2233358 | 2233358 | 2022-02-20 | Douglas | Illinois | 17041 | 6399 | 58 |
2230107 | 2230107 | 2022-02-19 | Douglas | Illinois | 17041 | 6399 | 58 |
2226856 | 2226856 | 2022-02-18 | Douglas | Illinois | 17041 | 6399 | 58 |
2218666 | 2218666 | 2022-02-15 | Jackson | Oklahoma | 40065 | 6399 | 94 |
2213647 | 2213647 | 2022-02-14 | Chattooga | Georgia | 13055 | 6399 | 124 |
2215415 | 2215415 | 2022-02-14 | Jackson | Oklahoma | 40065 | 6399 | 94 |
2212164 | 2212164 | 2022-02-13 | Jackson | Oklahoma | 40065 | 6399 | 94 |
2208911 | 2208911 | 2022-02-12 | Jackson | Oklahoma | 40065 | 6399 | 94 |
2205658 | 2205658 | 2022-02-11 | Jackson | Oklahoma | 40065 | 6399 | 94 |
2202405 | 2202405 | 2022-02-10 | Jackson | Oklahoma | 40065 | 6399 | 94 |
2199151 | 2199151 | 2022-02-09 | Jackson | Oklahoma | 40065 | 6399 | 94 |
2187790 | 2187790 | 2022-02-06 | Latah | Idaho | 16057 | 6399 | 46 |
2184537 | 2184537 | 2022-02-05 | Latah | Idaho | 16057 | 6399 | 46 |
2163232 | 2163232 | 2022-01-29 | Stutsman | North Dakota | 38093 | 6399 | 94 |
2156905 | 2156905 | 2022-01-27 | Columbia | Oregon | 41009 | 6399 | 68 |
2149609 | 2149609 | 2022-01-25 | Itawamba | Mississippi | 28057 | 6399 | 115 |
2081992 | 2081992 | 2022-01-04 | Perry | Ohio | 39127 | 6399 | 94 |
2061559 | 2061559 | 2021-12-29 | Somerset | Maine | 23025 | 6399 | 71 |
2010641 | 2010641 | 2021-12-13 | Clinton | Pennsylvania | 42035 | 6399 | 97 |
1974606 | 1974606 | 2021-12-02 | Yadkin | North Carolina | 37197 | 6399 | 76 |
1970522 | 1970522 | 2021-12-01 | St. John the Baptist | Louisiana | 22095 | 6399 | 173 |
1943460 | 1943460 | 2021-11-23 | Boone | Arkansas | 5009 | 6399 | 130 |
1870679 | 1870679 | 2021-10-31 | Crawford | Ohio | 39033 | 6399 | 135 |
1790825 | 1790825 | 2021-10-07 | Lake | California | 6033 | 6399 | 97 |
1791352 | 1791352 | 2021-10-07 | Gibson | Indiana | 18051 | 6399 | 114 |
1786120 | 1786120 | 2021-10-05 | Vance | North Carolina | 37181 | 6399 | 94 |
1787241 | 1787241 | 2021-10-05 | Jefferson | West Virginia | 54037 | 6399 | 76 |
1722192 | 1722192 | 2021-09-15 | Washington | Virginia | 51191 | 6399 | 120 |
1671338 | 1671338 | 2021-08-31 | Ford | Kansas | 20057 | 6399 | 84 |
1668091 | 1668091 | 2021-08-30 | Ford | Kansas | 20057 | 6399 | 84 |
1556198 | 1556198 | 2021-07-26 | Hardin | Texas | 48199 | 6399 | 118 |
1552951 | 1552951 | 2021-07-25 | Hardin | Texas | 48199 | 6399 | 118 |
1549704 | 1549704 | 2021-07-24 | Hardin | Texas | 48199 | 6399 | 118 |
1539803 | 1539803 | 2021-07-21 | Hawkins | Tennessee | 47073 | 6399 | 115 |
1508278 | 1508278 | 2021-07-12 | Eagle | Colorado | 8037 | 6399 | 23 |
1464842 | 1464842 | 2021-06-28 | Carbon | Pennsylvania | 42025 | 6399 | 176 |
1407212 | 1407212 | 2021-06-10 | Cowlitz | Washington | 53015 | 6399 | 84 |
1396338 | 1396338 | 2021-06-07 | Columbus | North Carolina | 37047 | 6399 | 151 |
1325929 | 1325929 | 2021-05-16 | Bedford | Virginia | 51019 | 6399 | 102 |
1274209 | 1274209 | 2021-04-30 | Calumet | Wisconsin | 55015 | 6399 | 51 |
1246152 | 1246152 | 2021-04-22 | McCracken | Kentucky | 21145 | 6399 | 119 |
1248056 | 1248056 | 2021-04-22 | Harrisonburg city | Virginia | 51660 | 6399 | 94 |
1214599 | 1214599 | 2021-04-12 | Wilkes | North Carolina | 37193 | 6399 | 107 |
1180826 | 1180826 | 2021-04-02 | Boone | Indiana | 18011 | 6399 | 103 |
1173110 | 1173110 | 2021-03-30 | Hood | Texas | 48221 | 6399 | 122 |
1073077 | 1073077 | 2021-02-28 | Gila | Arizona | 4007 | 6399 | 214 |
1061201 | 1061201 | 2021-02-24 | Allegany | Maryland | 24001 | 6399 | 198 |
1061843 | 1061843 | 2021-02-24 | Valencia | New Mexico | 35061 | 6399 | 93 |
1043614 | 1043614 | 2021-02-18 | Whatcom | Washington | 53073 | 6399 | 81 |
980933 | 980933 | 2021-01-30 | Erie | Ohio | 39043 | 6399 | 131 |
946767 | 946767 | 2021-01-20 | Nassau | Florida | 12089 | 6399 | 75 |
928737 | 928737 | 2021-01-14 | Sussex | New Jersey | 34037 | 6399 | 237 |
926905 | 926905 | 2021-01-13 | Wood | Wisconsin | 55141 | 6399 | 70 |
836002 | 836002 | 2020-12-16 | Manitowoc | Wisconsin | 55071 | 6399 | 53 |
772533 | 772533 | 2020-11-27 | Olmsted | Minnesota | 27109 | 6399 | 34 |
728895 | 728895 | 2020-11-13 | La Crosse | Wisconsin | 55063 | 6399 | 28 |
560434 | 560434 | 2020-09-23 | Benton | Arkansas | 5007 | 6399 | 82 |
520487 | 520487 | 2020-09-10 | Multnomah | Oregon | 41051 | 6399 | 127 |
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);