ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
53 rows where cases = 7653 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 23
- Iowa 7
- Texas 5
- Nevada 4
- Wisconsin 4
- Alabama 3
- Arkansas 3
- California 3
- Louisiana 3
- Ohio 3
- Kansas 2
- Oklahoma 2
- Pennsylvania 2
- West Virginia 2
- Alaska 1
- Colorado 1
- Georgia 1
- Indiana 1
- Maine 1
- Michigan 1
- New York 1
- North Carolina 1
- North Dakota 1
- Puerto Rico 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501950 | 2501950 | 2022-05-13 | Isabela | Puerto Rico | 72071 | 7653 | |
2468192 | 2468192 | 2022-05-03 | Hancock | Maine | 23009 | 7653 | 85 |
2369374 | 2369374 | 2022-04-03 | Lawrence | Alabama | 1079 | 7653 | 154 |
2366121 | 2366121 | 2022-04-02 | Lawrence | Alabama | 1079 | 7653 | 154 |
2362868 | 2362868 | 2022-04-01 | Lawrence | Alabama | 1079 | 7653 | 154 |
2352553 | 2352553 | 2022-03-28 | Hockley | Texas | 48219 | 7653 | 161 |
2349301 | 2349301 | 2022-03-27 | Hockley | Texas | 48219 | 7653 | 161 |
2346048 | 2346048 | 2022-03-26 | Hockley | Texas | 48219 | 7653 | 161 |
2192225 | 2192225 | 2022-02-07 | Douglas | Nevada | 32005 | 7653 | 82 |
2188972 | 2188972 | 2022-02-06 | Douglas | Nevada | 32005 | 7653 | 82 |
2185719 | 2185719 | 2022-02-05 | Douglas | Nevada | 32005 | 7653 | 82 |
2182467 | 2182467 | 2022-02-04 | Douglas | Nevada | 32005 | 7653 | 82 |
2163502 | 2163502 | 2022-01-29 | Snyder | Pennsylvania | 42109 | 7653 | 144 |
2147632 | 2147632 | 2022-01-24 | Grimes | Texas | 48185 | 7653 | 111 |
2142785 | 2142785 | 2022-01-23 | Beauregard | Louisiana | 22011 | 7653 | 131 |
2139530 | 2139530 | 2022-01-22 | Beauregard | Louisiana | 22011 | 7653 | 131 |
2136274 | 2136274 | 2022-01-21 | Beauregard | Louisiana | 22011 | 7653 | 131 |
2106649 | 2106649 | 2022-01-12 | Putnam | Indiana | 18133 | 7653 | 100 |
2012499 | 2012499 | 2021-12-14 | Webster | Iowa | 19187 | 7653 | 125 |
2013691 | 2013691 | 2021-12-14 | Defiance | Ohio | 39039 | 7653 | 118 |
2009248 | 2009248 | 2021-12-13 | Webster | Iowa | 19187 | 7653 | 125 |
2005997 | 2005997 | 2021-12-12 | Webster | Iowa | 19187 | 7653 | 125 |
2007186 | 2007186 | 2021-12-12 | Crawford | Ohio | 39033 | 7653 | 154 |
2002746 | 2002746 | 2021-12-11 | Webster | Iowa | 19187 | 7653 | 125 |
1999496 | 1999496 | 2021-12-10 | Webster | Iowa | 19187 | 7653 | 125 |
2001257 | 2001257 | 2021-12-10 | Burnet | Texas | 48053 | 7653 | 132 |
1996245 | 1996245 | 2021-12-09 | Webster | Iowa | 19187 | 7653 | 125 |
1992994 | 1992994 | 2021-12-08 | Webster | Iowa | 19187 | 7653 | 125 |
1982220 | 1982220 | 2021-12-04 | Jefferson | West Virginia | 54037 | 7653 | 92 |
1972855 | 1972855 | 2021-12-02 | Broomfield | Colorado | 8014 | 7653 | 86 |
1975798 | 1975798 | 2021-12-02 | Monroe | Wisconsin | 55081 | 7653 | 58 |
1893381 | 1893381 | 2021-11-07 | Morton | North Dakota | 38059 | 7653 | 119 |
1838391 | 1838391 | 2021-10-21 | Columbia | Pennsylvania | 42037 | 7653 | 150 |
1818680 | 1818680 | 2021-10-15 | Athens | Ohio | 39009 | 7653 | 72 |
1805564 | 1805564 | 2021-10-11 | Halifax | North Carolina | 37083 | 7653 | 133 |
1519636 | 1519636 | 2021-07-15 | Oswego | New York | 36075 | 7653 | 93 |
1466716 | 1466716 | 2021-06-29 | Butler | Kansas | 20015 | 7653 | 91 |
1463471 | 1463471 | 2021-06-28 | Butler | Kansas | 20015 | 7653 | 91 |
1371670 | 1371670 | 2021-05-30 | Wood | Wisconsin | 55141 | 7653 | 94 |
1368424 | 1368424 | 2021-05-29 | Wood | Wisconsin | 55141 | 7653 | 94 |
1362393 | 1362393 | 2021-05-28 | Dougherty | Georgia | 13095 | 7653 | 305 |
1365178 | 1365178 | 2021-05-28 | Wood | Wisconsin | 55141 | 7653 | 94 |
1280865 | 1280865 | 2021-05-03 | Fairbanks North Star Borough | Alaska | 2090 | 7653 | 37 |
1267706 | 1267706 | 2021-04-28 | Wood | West Virginia | 54107 | 7653 | 165 |
1117349 | 1117349 | 2021-03-13 | Garfield | Oklahoma | 40047 | 7653 | 82 |
1113181 | 1113181 | 2021-03-12 | Bay | Michigan | 26017 | 7653 | 297 |
1105622 | 1105622 | 2021-03-10 | White | Arkansas | 5145 | 7653 | 112 |
1056919 | 1056919 | 2021-02-23 | Pope | Arkansas | 5115 | 7653 | 101 |
1036241 | 1036241 | 2021-02-16 | Pottawatomie | Oklahoma | 40125 | 7653 | 69 |
807023 | 807023 | 2020-12-08 | Sebastian | Arkansas | 5131 | 7653 | 127 |
463492 | 463492 | 2020-08-24 | Merced | California | 6047 | 7653 | 106 |
457054 | 457054 | 2020-08-22 | Santa Barbara | California | 6083 | 7653 | 87 |
453826 | 453826 | 2020-08-21 | Santa Barbara | California | 6083 | 7653 | 87 |
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);