ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
10,902 rows where county = "Warren" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 14
- New Jersey 579
- Kentucky 578
- New York 578
- Ohio 576
- Iowa 572
- Pennsylvania 571
- Indiana 570
- Virginia 570
- Missouri 568
- Mississippi 567
- Tennessee 566
- Georgia 565
- North Carolina 561
- Illinois 553
fips 14
county 1
- Warren · 7,974 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1820653 | 1820653 | 2021-10-16 | Warren | Indiana | 18171 | 1204 | 18 |
1820751 | 1820751 | 2021-10-16 | Warren | Iowa | 19181 | 7638 | 96 |
1820978 | 1820978 | 2021-10-16 | Warren | Kentucky | 21227 | 25278 | 240 |
1821353 | 1821353 | 2021-10-16 | Warren | Mississippi | 28149 | 6642 | 176 |
1821472 | 1821472 | 2021-10-16 | Warren | Missouri | 29219 | 4946 | 44 |
1821677 | 1821677 | 2021-10-16 | Warren | New Jersey | 34041 | 11880 | 253 |
1821763 | 1821763 | 2021-10-16 | Warren | New York | 36113 | 5345 | 81 |
1821861 | 1821861 | 2021-10-16 | Warren | North Carolina | 37185 | 2322 | 28 |
1822008 | 1822008 | 2021-10-16 | Warren | Ohio | 39165 | 32373 | 369 |
1822189 | 1822189 | 2021-10-16 | Warren | Pennsylvania | 42123 | 3749 | 117 |
1822481 | 1822481 | 2021-10-16 | Warren | Tennessee | 47177 | 8493 | 113 |
1822914 | 1822914 | 2021-10-16 | Warren | Virginia | 51187 | 4807 | 79 |
1817154 | 1817154 | 2021-10-15 | Warren | Georgia | 13301 | 762 | 23 |
1817310 | 1817310 | 2021-10-15 | Warren | Illinois | 17187 | 2427 | 68 |
1817404 | 1817404 | 2021-10-15 | Warren | Indiana | 18171 | 1204 | 18 |
1817502 | 1817502 | 2021-10-15 | Warren | Iowa | 19181 | 7638 | 96 |
1817729 | 1817729 | 2021-10-15 | Warren | Kentucky | 21227 | 25278 | 240 |
1818104 | 1818104 | 2021-10-15 | Warren | Mississippi | 28149 | 6642 | 176 |
1818223 | 1818223 | 2021-10-15 | Warren | Missouri | 29219 | 4940 | 44 |
1818428 | 1818428 | 2021-10-15 | Warren | New Jersey | 34041 | 11850 | 253 |
1818514 | 1818514 | 2021-10-15 | Warren | New York | 36113 | 5300 | 81 |
1818612 | 1818612 | 2021-10-15 | Warren | North Carolina | 37185 | 2322 | 28 |
1818759 | 1818759 | 2021-10-15 | Warren | Ohio | 39165 | 32293 | 369 |
1818940 | 1818940 | 2021-10-15 | Warren | Pennsylvania | 42123 | 3725 | 117 |
1819232 | 1819232 | 2021-10-15 | Warren | Tennessee | 47177 | 8493 | 113 |
1819665 | 1819665 | 2021-10-15 | Warren | Virginia | 51187 | 4807 | 79 |
1813906 | 1813906 | 2021-10-14 | Warren | Georgia | 13301 | 762 | 23 |
1814062 | 1814062 | 2021-10-14 | Warren | Illinois | 17187 | 2422 | 68 |
1814156 | 1814156 | 2021-10-14 | Warren | Indiana | 18171 | 1202 | 18 |
1814254 | 1814254 | 2021-10-14 | Warren | Iowa | 19181 | 7638 | 96 |
1814481 | 1814481 | 2021-10-14 | Warren | Kentucky | 21227 | 25223 | 238 |
1814855 | 1814855 | 2021-10-14 | Warren | Mississippi | 28149 | 6635 | 175 |
1814974 | 1814974 | 2021-10-14 | Warren | Missouri | 29219 | 4933 | 44 |
1815179 | 1815179 | 2021-10-14 | Warren | New Jersey | 34041 | 11825 | 253 |
1815265 | 1815265 | 2021-10-14 | Warren | New York | 36113 | 5271 | 81 |
1815363 | 1815363 | 2021-10-14 | Warren | North Carolina | 37185 | 2318 | 28 |
1815510 | 1815510 | 2021-10-14 | Warren | Ohio | 39165 | 32183 | 365 |
1815691 | 1815691 | 2021-10-14 | Warren | Pennsylvania | 42123 | 3688 | 117 |
1815983 | 1815983 | 2021-10-14 | Warren | Tennessee | 47177 | 8481 | 113 |
1816416 | 1816416 | 2021-10-14 | Warren | Virginia | 51187 | 4791 | 78 |
1810657 | 1810657 | 2021-10-13 | Warren | Georgia | 13301 | 762 | 23 |
1810813 | 1810813 | 2021-10-13 | Warren | Illinois | 17187 | 2417 | 68 |
1810907 | 1810907 | 2021-10-13 | Warren | Indiana | 18171 | 1193 | 18 |
1811005 | 1811005 | 2021-10-13 | Warren | Iowa | 19181 | 7638 | 96 |
1811232 | 1811232 | 2021-10-13 | Warren | Kentucky | 21227 | 25192 | 236 |
1811607 | 1811607 | 2021-10-13 | Warren | Mississippi | 28149 | 6632 | 175 |
1811726 | 1811726 | 2021-10-13 | Warren | Missouri | 29219 | 4920 | 44 |
1811931 | 1811931 | 2021-10-13 | Warren | New Jersey | 34041 | 11790 | 253 |
1812017 | 1812017 | 2021-10-13 | Warren | New York | 36113 | 5245 | 81 |
1812115 | 1812115 | 2021-10-13 | Warren | North Carolina | 37185 | 2314 | 28 |
1812262 | 1812262 | 2021-10-13 | Warren | Ohio | 39165 | 32071 | 365 |
1812443 | 1812443 | 2021-10-13 | Warren | Pennsylvania | 42123 | 3649 | 117 |
1812735 | 1812735 | 2021-10-13 | Warren | Tennessee | 47177 | 8460 | 113 |
1813168 | 1813168 | 2021-10-13 | Warren | Virginia | 51187 | 4770 | 76 |
1807408 | 1807408 | 2021-10-12 | Warren | Georgia | 13301 | 760 | 23 |
1807564 | 1807564 | 2021-10-12 | Warren | Illinois | 17187 | 2414 | 68 |
1807658 | 1807658 | 2021-10-12 | Warren | Indiana | 18171 | 1193 | 18 |
1807756 | 1807756 | 2021-10-12 | Warren | Iowa | 19181 | 7435 | 96 |
1807983 | 1807983 | 2021-10-12 | Warren | Kentucky | 21227 | 25133 | 236 |
1808358 | 1808358 | 2021-10-12 | Warren | Mississippi | 28149 | 6627 | 173 |
1808477 | 1808477 | 2021-10-12 | Warren | Missouri | 29219 | 4910 | 43 |
1808682 | 1808682 | 2021-10-12 | Warren | New Jersey | 34041 | 11770 | 253 |
1808768 | 1808768 | 2021-10-12 | Warren | New York | 36113 | 5205 | 81 |
1808866 | 1808866 | 2021-10-12 | Warren | North Carolina | 37185 | 2311 | 28 |
1809013 | 1809013 | 2021-10-12 | Warren | Ohio | 39165 | 31985 | 365 |
1809194 | 1809194 | 2021-10-12 | Warren | Pennsylvania | 42123 | 3615 | 117 |
1809486 | 1809486 | 2021-10-12 | Warren | Tennessee | 47177 | 8439 | 113 |
1809919 | 1809919 | 2021-10-12 | Warren | Virginia | 51187 | 4747 | 76 |
1804157 | 1804157 | 2021-10-11 | Warren | Georgia | 13301 | 758 | 23 |
1804313 | 1804313 | 2021-10-11 | Warren | Illinois | 17187 | 2395 | 68 |
1804407 | 1804407 | 2021-10-11 | Warren | Indiana | 18171 | 1190 | 18 |
1804505 | 1804505 | 2021-10-11 | Warren | Iowa | 19181 | 7435 | 96 |
1804732 | 1804732 | 2021-10-11 | Warren | Kentucky | 21227 | 25065 | 236 |
1805107 | 1805107 | 2021-10-11 | Warren | Mississippi | 28149 | 6625 | 173 |
1805226 | 1805226 | 2021-10-11 | Warren | Missouri | 29219 | 4903 | 43 |
1805431 | 1805431 | 2021-10-11 | Warren | New Jersey | 34041 | 11748 | 253 |
1805517 | 1805517 | 2021-10-11 | Warren | New York | 36113 | 5176 | 81 |
1805615 | 1805615 | 2021-10-11 | Warren | North Carolina | 37185 | 2310 | 27 |
1805763 | 1805763 | 2021-10-11 | Warren | Ohio | 39165 | 31925 | 361 |
1805944 | 1805944 | 2021-10-11 | Warren | Pennsylvania | 42123 | 3580 | 117 |
1806236 | 1806236 | 2021-10-11 | Warren | Tennessee | 47177 | 8418 | 110 |
1806670 | 1806670 | 2021-10-11 | Warren | Virginia | 51187 | 4680 | 75 |
1800908 | 1800908 | 2021-10-10 | Warren | Georgia | 13301 | 758 | 23 |
1801064 | 1801064 | 2021-10-10 | Warren | Illinois | 17187 | 2395 | 68 |
1801158 | 1801158 | 2021-10-10 | Warren | Indiana | 18171 | 1184 | 18 |
1801256 | 1801256 | 2021-10-10 | Warren | Iowa | 19181 | 7435 | 96 |
1801483 | 1801483 | 2021-10-10 | Warren | Kentucky | 21227 | 24957 | 235 |
1801858 | 1801858 | 2021-10-10 | Warren | Mississippi | 28149 | 6615 | 173 |
1801977 | 1801977 | 2021-10-10 | Warren | Missouri | 29219 | 4899 | 43 |
1802182 | 1802182 | 2021-10-10 | Warren | New Jersey | 34041 | 11738 | 253 |
1802268 | 1802268 | 2021-10-10 | Warren | New York | 36113 | 5148 | 81 |
1802366 | 1802366 | 2021-10-10 | Warren | North Carolina | 37185 | 2292 | 27 |
1802513 | 1802513 | 2021-10-10 | Warren | Ohio | 39165 | 31892 | 361 |
1802694 | 1802694 | 2021-10-10 | Warren | Pennsylvania | 42123 | 3574 | 117 |
1802986 | 1802986 | 2021-10-10 | Warren | Tennessee | 47177 | 8370 | 109 |
1803419 | 1803419 | 2021-10-10 | Warren | Virginia | 51187 | 4680 | 75 |
1797659 | 1797659 | 2021-10-09 | Warren | Georgia | 13301 | 758 | 23 |
1797815 | 1797815 | 2021-10-09 | Warren | Illinois | 17187 | 2395 | 68 |
1797909 | 1797909 | 2021-10-09 | Warren | Indiana | 18171 | 1184 | 18 |
1798007 | 1798007 | 2021-10-09 | Warren | Iowa | 19181 | 7435 | 96 |
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);