ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
18,567 rows where county = "Jackson" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 24
- Oregon 592
- Oklahoma 585
- Michigan 582
- Mississippi 582
- Missouri 582
- Illinois 581
- Florida 579
- West Virginia 579
- Alabama 578
- Minnesota 578
- Kansas 577
- Indiana 575
- Georgia 574
- Louisiana 574
- Texas 573
- Iowa 569
- Wisconsin 569
- Tennessee 566
- Kentucky 560
- Ohio 560
- North Carolina 555
- Arkansas 554
- South Dakota 514
- Colorado 481
fips 24
county 1
- Jackson · 13,619 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1830078 | 1830078 | 2021-10-19 | Jackson | Georgia | 13157 | 14647 | 204 |
1830250 | 1830250 | 2021-10-19 | Jackson | Illinois | 17077 | 8087 | 105 |
1830350 | 1830350 | 2021-10-19 | Jackson | Indiana | 18071 | 6951 | 90 |
1830455 | 1830455 | 2021-10-19 | Jackson | Iowa | 19097 | 2710 | 45 |
1830549 | 1830549 | 2021-10-19 | Jackson | Kansas | 20085 | 1941 | 19 |
1830666 | 1830666 | 2021-10-19 | Jackson | Kentucky | 21109 | 2567 | 49 |
1830756 | 1830756 | 2021-10-19 | Jackson | Louisiana | 22049 | 2750 | 63 |
1830891 | 1830891 | 2021-10-19 | Jackson | Michigan | 26075 | 25172 | 354 |
1830969 | 1830969 | 2021-10-19 | Jackson | Minnesota | 27063 | 1456 | 14 |
1831055 | 1831055 | 2021-10-19 | Jackson | Mississippi | 28059 | 24452 | 379 |
1831155 | 1831155 | 2021-10-19 | Jackson | Missouri | 29095 | 55297 | 680 |
1831565 | 1831565 | 2021-10-19 | Jackson | North Carolina | 37099 | 5581 | 70 |
1831711 | 1831711 | 2021-10-19 | Jackson | Ohio | 39079 | 5000 | 71 |
1831793 | 1831793 | 2021-10-19 | Jackson | Oklahoma | 40065 | 3808 | 67 |
1831853 | 1831853 | 2021-10-19 | Jackson | Oregon | 41029 | 22837 | 305 |
1832107 | 1832107 | 2021-10-19 | Jackson | South Dakota | 46071 | 376 | 16 |
1832182 | 1832182 | 2021-10-19 | Jackson | Tennessee | 47087 | 2060 | 40 |
1832354 | 1832354 | 2021-10-19 | Jackson | Texas | 48239 | 2775 | 50 |
1832726 | 1832726 | 2021-10-19 | Jackson | West Virginia | 54035 | 3855 | 80 |
1832790 | 1832790 | 2021-10-19 | Jackson | Wisconsin | 55053 | 3313 | 31 |
1826396 | 1826396 | 2021-10-18 | Jackson | Alabama | 1071 | 9795 | 180 |
1826505 | 1826505 | 2021-10-18 | Jackson | Arkansas | 5067 | 4187 | 42 |
1826635 | 1826635 | 2021-10-18 | Jackson | Colorado | 8057 | 107 | 0 |
1826714 | 1826714 | 2021-10-18 | Jackson | Florida | 12063 | 10035 | 211 |
1826829 | 1826829 | 2021-10-18 | Jackson | Georgia | 13157 | 14637 | 202 |
1827001 | 1827001 | 2021-10-18 | Jackson | Illinois | 17077 | 8083 | 105 |
1827101 | 1827101 | 2021-10-18 | Jackson | Indiana | 18071 | 6945 | 90 |
1827206 | 1827206 | 2021-10-18 | Jackson | Iowa | 19097 | 2710 | 45 |
1827300 | 1827300 | 2021-10-18 | Jackson | Kansas | 20085 | 1941 | 19 |
1827417 | 1827417 | 2021-10-18 | Jackson | Kentucky | 21109 | 2559 | 49 |
1827507 | 1827507 | 2021-10-18 | Jackson | Louisiana | 22049 | 2749 | 63 |
1827642 | 1827642 | 2021-10-18 | Jackson | Michigan | 26075 | 25172 | 354 |
1827720 | 1827720 | 2021-10-18 | Jackson | Minnesota | 27063 | 1448 | 14 |
1827806 | 1827806 | 2021-10-18 | Jackson | Mississippi | 28059 | 24352 | 379 |
1827906 | 1827906 | 2021-10-18 | Jackson | Missouri | 29095 | 55242 | 672 |
1828316 | 1828316 | 2021-10-18 | Jackson | North Carolina | 37099 | 5572 | 70 |
1828462 | 1828462 | 2021-10-18 | Jackson | Ohio | 39079 | 4987 | 70 |
1828544 | 1828544 | 2021-10-18 | Jackson | Oklahoma | 40065 | 3808 | 67 |
1828604 | 1828604 | 2021-10-18 | Jackson | Oregon | 41029 | 22783 | 304 |
1828858 | 1828858 | 2021-10-18 | Jackson | South Dakota | 46071 | 377 | 16 |
1828933 | 1828933 | 2021-10-18 | Jackson | Tennessee | 47087 | 2059 | 40 |
1829105 | 1829105 | 2021-10-18 | Jackson | Texas | 48239 | 2773 | 50 |
1829477 | 1829477 | 2021-10-18 | Jackson | West Virginia | 54035 | 3836 | 80 |
1829541 | 1829541 | 2021-10-18 | Jackson | Wisconsin | 55053 | 3309 | 31 |
1823147 | 1823147 | 2021-10-17 | Jackson | Alabama | 1071 | 9793 | 180 |
1823256 | 1823256 | 2021-10-17 | Jackson | Arkansas | 5067 | 4185 | 42 |
1823386 | 1823386 | 2021-10-17 | Jackson | Colorado | 8057 | 101 | 0 |
1823465 | 1823465 | 2021-10-17 | Jackson | Florida | 12063 | 10035 | 209 |
1823580 | 1823580 | 2021-10-17 | Jackson | Georgia | 13157 | 14602 | 201 |
1823752 | 1823752 | 2021-10-17 | Jackson | Illinois | 17077 | 8065 | 105 |
1823852 | 1823852 | 2021-10-17 | Jackson | Indiana | 18071 | 6921 | 89 |
1823957 | 1823957 | 2021-10-17 | Jackson | Iowa | 19097 | 2710 | 45 |
1824051 | 1824051 | 2021-10-17 | Jackson | Kansas | 20085 | 1936 | 19 |
1824168 | 1824168 | 2021-10-17 | Jackson | Kentucky | 21109 | 2547 | 49 |
1824258 | 1824258 | 2021-10-17 | Jackson | Louisiana | 22049 | 2747 | 63 |
1824393 | 1824393 | 2021-10-17 | Jackson | Michigan | 26075 | 24991 | 352 |
1824471 | 1824471 | 2021-10-17 | Jackson | Minnesota | 27063 | 1441 | 14 |
1824557 | 1824557 | 2021-10-17 | Jackson | Mississippi | 28059 | 24314 | 377 |
1824657 | 1824657 | 2021-10-17 | Jackson | Missouri | 29095 | 55222 | 672 |
1825067 | 1825067 | 2021-10-17 | Jackson | North Carolina | 37099 | 5534 | 70 |
1825213 | 1825213 | 2021-10-17 | Jackson | Ohio | 39079 | 4958 | 70 |
1825295 | 1825295 | 2021-10-17 | Jackson | Oklahoma | 40065 | 3808 | 67 |
1825355 | 1825355 | 2021-10-17 | Jackson | Oregon | 41029 | 22632 | 300 |
1825609 | 1825609 | 2021-10-17 | Jackson | South Dakota | 46071 | 377 | 16 |
1825684 | 1825684 | 2021-10-17 | Jackson | Tennessee | 47087 | 2054 | 40 |
1825856 | 1825856 | 2021-10-17 | Jackson | Texas | 48239 | 2773 | 50 |
1826228 | 1826228 | 2021-10-17 | Jackson | West Virginia | 54035 | 3813 | 79 |
1826292 | 1826292 | 2021-10-17 | Jackson | Wisconsin | 55053 | 3294 | 31 |
1819898 | 1819898 | 2021-10-16 | Jackson | Alabama | 1071 | 9789 | 180 |
1820007 | 1820007 | 2021-10-16 | Jackson | Arkansas | 5067 | 4179 | 42 |
1820137 | 1820137 | 2021-10-16 | Jackson | Colorado | 8057 | 101 | 0 |
1820216 | 1820216 | 2021-10-16 | Jackson | Florida | 12063 | 10035 | 209 |
1820331 | 1820331 | 2021-10-16 | Jackson | Georgia | 13157 | 14602 | 201 |
1820503 | 1820503 | 2021-10-16 | Jackson | Illinois | 17077 | 8065 | 105 |
1820603 | 1820603 | 2021-10-16 | Jackson | Indiana | 18071 | 6921 | 89 |
1820708 | 1820708 | 2021-10-16 | Jackson | Iowa | 19097 | 2710 | 45 |
1820802 | 1820802 | 2021-10-16 | Jackson | Kansas | 20085 | 1936 | 19 |
1820919 | 1820919 | 2021-10-16 | Jackson | Kentucky | 21109 | 2547 | 49 |
1821009 | 1821009 | 2021-10-16 | Jackson | Louisiana | 22049 | 2747 | 63 |
1821144 | 1821144 | 2021-10-16 | Jackson | Michigan | 26075 | 24991 | 352 |
1821222 | 1821222 | 2021-10-16 | Jackson | Minnesota | 27063 | 1441 | 14 |
1821308 | 1821308 | 2021-10-16 | Jackson | Mississippi | 28059 | 24314 | 377 |
1821408 | 1821408 | 2021-10-16 | Jackson | Missouri | 29095 | 55178 | 672 |
1821818 | 1821818 | 2021-10-16 | Jackson | North Carolina | 37099 | 5534 | 70 |
1821964 | 1821964 | 2021-10-16 | Jackson | Ohio | 39079 | 4954 | 70 |
1822046 | 1822046 | 2021-10-16 | Jackson | Oklahoma | 40065 | 3808 | 67 |
1822106 | 1822106 | 2021-10-16 | Jackson | Oregon | 41029 | 22632 | 300 |
1822360 | 1822360 | 2021-10-16 | Jackson | South Dakota | 46071 | 377 | 16 |
1822435 | 1822435 | 2021-10-16 | Jackson | Tennessee | 47087 | 2054 | 40 |
1822607 | 1822607 | 2021-10-16 | Jackson | Texas | 48239 | 2773 | 50 |
1822979 | 1822979 | 2021-10-16 | Jackson | West Virginia | 54035 | 3790 | 79 |
1823043 | 1823043 | 2021-10-16 | Jackson | Wisconsin | 55053 | 3268 | 31 |
1816649 | 1816649 | 2021-10-15 | Jackson | Alabama | 1071 | 9776 | 177 |
1816758 | 1816758 | 2021-10-15 | Jackson | Arkansas | 5067 | 4140 | 42 |
1816888 | 1816888 | 2021-10-15 | Jackson | Colorado | 8057 | 101 | 0 |
1816967 | 1816967 | 2021-10-15 | Jackson | Florida | 12063 | 10035 | 209 |
1817082 | 1817082 | 2021-10-15 | Jackson | Georgia | 13157 | 14602 | 201 |
1817254 | 1817254 | 2021-10-15 | Jackson | Illinois | 17077 | 8065 | 105 |
1817354 | 1817354 | 2021-10-15 | Jackson | Indiana | 18071 | 6921 | 89 |
1817459 | 1817459 | 2021-10-15 | Jackson | Iowa | 19097 | 2710 | 45 |
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);