ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
70 rows where cases = 6061 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
- Oklahoma 8
- Kentucky 6
- Indiana 5
- Tennessee 5
- Georgia 4
- Illinois 4
- Texas 4
- Maryland 3
- Oregon 3
- Arkansas 2
- Kansas 2
- Missouri 2
- New Jersey 2
- New York 2
- North Carolina 2
- Pennsylvania 2
- Puerto Rico 2
- Virginia 2
- Wisconsin 2
- California 1
- Connecticut 1
- Idaho 1
- Louisiana 1
- Minnesota 1
- Mississippi 1
- Nevada 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2479152 | 2479152 | 2022-05-06 | Las Piedras | Puerto Rico | 72085 | 6061 | |
2439938 | 2439938 | 2022-04-24 | Crook | Oregon | 41013 | 6061 | 79 |
2436682 | 2436682 | 2022-04-23 | Crook | Oregon | 41013 | 6061 | 79 |
2433426 | 2433426 | 2022-04-22 | Crook | Oregon | 41013 | 6061 | 79 |
2431151 | 2431151 | 2022-04-21 | Vernon | Wisconsin | 55123 | 6061 | 96 |
2416115 | 2416115 | 2022-04-17 | Caroline | Maryland | 24011 | 6061 | 80 |
2412859 | 2412859 | 2022-04-16 | Caroline | Maryland | 24011 | 6061 | 80 |
2409603 | 2409603 | 2022-04-15 | Caroline | Maryland | 24011 | 6061 | 80 |
2350400 | 2350400 | 2022-03-28 | Jerome | Idaho | 16053 | 6061 | 64 |
2304391 | 2304391 | 2022-03-14 | Carroll | Arkansas | 5015 | 6061 | 97 |
2301139 | 2301139 | 2022-03-13 | Carroll | Arkansas | 5015 | 6061 | 97 |
2290233 | 2290233 | 2022-03-09 | Seminole | Oklahoma | 40133 | 6061 | 125 |
2286981 | 2286981 | 2022-03-08 | Seminole | Oklahoma | 40133 | 6061 | 125 |
2283729 | 2283729 | 2022-03-07 | Seminole | Oklahoma | 40133 | 6061 | 125 |
2280477 | 2280477 | 2022-03-06 | Seminole | Oklahoma | 40133 | 6061 | 125 |
2277224 | 2277224 | 2022-03-05 | Seminole | Oklahoma | 40133 | 6061 | 125 |
2273971 | 2273971 | 2022-03-04 | Seminole | Oklahoma | 40133 | 6061 | 125 |
2270718 | 2270718 | 2022-03-03 | Seminole | Oklahoma | 40133 | 6061 | 125 |
2267466 | 2267466 | 2022-03-02 | Seminole | Oklahoma | 40133 | 6061 | 125 |
2260347 | 2260347 | 2022-02-28 | Stoddard | Missouri | 29207 | 6061 | 121 |
2256543 | 2256543 | 2022-02-27 | Harrison | Kentucky | 21097 | 6061 | 62 |
2253292 | 2253292 | 2022-02-26 | Harrison | Kentucky | 21097 | 6061 | 62 |
2254958 | 2254958 | 2022-02-26 | Gray | Texas | 48179 | 6061 | 122 |
2250041 | 2250041 | 2022-02-25 | Harrison | Kentucky | 21097 | 6061 | 62 |
2237857 | 2237857 | 2022-02-21 | Lewis | New York | 36049 | 6061 | 47 |
2146690 | 2146690 | 2022-01-24 | Nye | Nevada | 32023 | 6061 | 209 |
2131886 | 2131886 | 2022-01-19 | Park | Wyoming | 56029 | 6061 | 123 |
2085857 | 2085857 | 2022-01-05 | Howard | Texas | 48227 | 6061 | 153 |
2080408 | 2080408 | 2022-01-04 | Wayne | Georgia | 13305 | 6061 | 181 |
2060862 | 2060862 | 2021-12-29 | Pickens | Georgia | 13227 | 6061 | 125 |
2040790 | 2040790 | 2021-12-22 | Green | Wisconsin | 55045 | 6061 | 40 |
1973989 | 1973989 | 2021-12-02 | Polk | Minnesota | 27119 | 6061 | 87 |
1882251 | 1882251 | 2021-11-04 | Livingston | Illinois | 17105 | 6061 | 111 |
1854912 | 1854912 | 2021-10-26 | Giles | Tennessee | 47055 | 6061 | 122 |
1793242 | 1793242 | 2021-10-07 | Weakley | Tennessee | 47183 | 6061 | 84 |
1754494 | 1754494 | 2021-09-25 | Waller | Texas | 48473 | 6061 | 70 |
1739042 | 1739042 | 2021-09-21 | Bryan | Georgia | 13029 | 6061 | 52 |
1611102 | 1611102 | 2021-08-12 | Unknown | Puerto Rico | 6061 | 2643 | |
1596441 | 1596441 | 2021-08-08 | Henry | Indiana | 18065 | 6061 | 113 |
1593192 | 1593192 | 2021-08-07 | Henry | Indiana | 18065 | 6061 | 113 |
1589943 | 1589943 | 2021-08-06 | Henry | Indiana | 18065 | 6061 | 113 |
1584975 | 1584975 | 2021-08-04 | Armstrong | Pennsylvania | 42005 | 6061 | 148 |
1551326 | 1551326 | 2021-07-25 | Pike | Kentucky | 21195 | 6061 | 112 |
1548079 | 1548079 | 2021-07-24 | Pike | Kentucky | 21195 | 6061 | 112 |
1544832 | 1544832 | 2021-07-23 | Pike | Kentucky | 21195 | 6061 | 112 |
1470662 | 1470662 | 2021-06-30 | Taney | Missouri | 29213 | 6061 | 102 |
1357419 | 1357419 | 2021-05-26 | Lee | North Carolina | 37105 | 6061 | 79 |
1347532 | 1347532 | 2021-05-23 | Salem | New Jersey | 34033 | 6061 | 185 |
1344284 | 1344284 | 2021-05-22 | Salem | New Jersey | 34033 | 6061 | 185 |
1338719 | 1338719 | 2021-05-20 | Hunt | Texas | 48231 | 6061 | 172 |
1328562 | 1328562 | 2021-05-17 | Union | Pennsylvania | 42119 | 6061 | 86 |
1234657 | 1234657 | 2021-04-18 | Jefferson | Tennessee | 47089 | 6061 | 121 |
1231409 | 1231409 | 2021-04-17 | Jefferson | Tennessee | 47089 | 6061 | 121 |
1228161 | 1228161 | 2021-04-16 | Jefferson | Tennessee | 47089 | 6061 | 121 |
1224236 | 1224236 | 2021-04-15 | Sullivan | New York | 36105 | 6061 | 68 |
1216567 | 1216567 | 2021-04-13 | Dubois | Indiana | 18037 | 6061 | 118 |
1214533 | 1214533 | 2021-04-12 | Duplin | North Carolina | 37061 | 6061 | 128 |
1199849 | 1199849 | 2021-04-08 | Yuba | California | 6115 | 6061 | 43 |
1155117 | 1155117 | 2021-03-25 | Saline | Kansas | 20169 | 6061 | 108 |
1151870 | 1151870 | 2021-03-24 | Saline | Kansas | 20169 | 6061 | 108 |
1112629 | 1112629 | 2021-03-12 | Whiteside | Illinois | 17195 | 6061 | 192 |
1093910 | 1093910 | 2021-03-06 | Lowndes | Mississippi | 28087 | 6061 | 140 |
1082503 | 1082503 | 2021-03-02 | Rockingham | Virginia | 51165 | 6061 | 93 |
1064364 | 1064364 | 2021-02-25 | Acadia | Louisiana | 22001 | 6061 | 183 |
1060706 | 1060706 | 2021-02-24 | Boone | Indiana | 18011 | 6061 | 93 |
991561 | 991561 | 2021-02-02 | Frederick | Virginia | 51069 | 6061 | 45 |
826633 | 826633 | 2020-12-14 | Litchfield | Connecticut | 9005 | 6061 | 194 |
794306 | 794306 | 2020-12-04 | Douglas | Georgia | 13097 | 6061 | 93 |
687485 | 687485 | 2020-11-01 | Unknown | Illinois | 6061 | 278 | |
680998 | 680998 | 2020-10-30 | Unknown | Illinois | 6061 | 278 |
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);