ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
13,972 rows where county = "Union" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 18
- New Jersey 697
- Ohio 686
- Oregon 686
- Mississippi 685
- North Carolina 684
- Arkansas 681
- Louisiana 681
- South Carolina 681
- Kentucky 680
- South Dakota 679
- Tennessee 678
- Pennsylvania 676
- Florida 674
- Georgia 673
- Indiana 671
- Iowa 665
- Illinois 659
- New Mexico 650
fips 18
county 1
- Union · 12,186 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2178233 | 2178233 | 2022-02-03 | Union | Indiana | 18161 | 1967 | 21 |
2178332 | 2178332 | 2022-02-03 | Union | Iowa | 19175 | 2581 | 46 |
2178562 | 2178562 | 2022-02-03 | Union | Kentucky | 21225 | 4033 | 52 |
2178625 | 2178625 | 2022-02-03 | Union | Louisiana | 22111 | 6599 | 119 |
2178935 | 2178935 | 2022-02-03 | Union | Mississippi | 28145 | 8897 | 109 |
2179259 | 2179259 | 2022-02-03 | Union | New Jersey | 34039 | 137975 | 2233 |
2179293 | 2179293 | 2022-02-03 | Union | New Mexico | 35059 | 948 | 12 |
2179442 | 2179442 | 2022-02-03 | Union | North Carolina | 37179 | 58415 | 426 |
2179590 | 2179590 | 2022-02-03 | Union | Ohio | 39159 | 15013 | 85 |
2179708 | 2179708 | 2022-02-03 | Union | Oregon | 41061 | 4726 | 67 |
2179773 | 2179773 | 2022-02-03 | Union | Pennsylvania | 42119 | 11128 | 139 |
2179909 | 2179909 | 2022-02-03 | Union | South Carolina | 45087 | 7223 | 132 |
2179974 | 2179974 | 2022-02-03 | Union | South Dakota | 46127 | 3907 | 49 |
2180064 | 2180064 | 2022-02-03 | Union | Tennessee | 47173 | 4778 | 68 |
2174375 | 2174375 | 2022-02-02 | Union | Arkansas | 5139 | 8762 | 159 |
2174580 | 2174580 | 2022-02-02 | Union | Florida | 12125 | 4022 | 104 |
2174729 | 2174729 | 2022-02-02 | Union | Georgia | 13291 | 4516 | 140 |
2174887 | 2174887 | 2022-02-02 | Union | Illinois | 17181 | 5112 | 65 |
2174980 | 2174980 | 2022-02-02 | Union | Indiana | 18161 | 1954 | 21 |
2175079 | 2175079 | 2022-02-02 | Union | Iowa | 19175 | 2581 | 46 |
2175309 | 2175309 | 2022-02-02 | Union | Kentucky | 21225 | 4008 | 52 |
2175372 | 2175372 | 2022-02-02 | Union | Louisiana | 22111 | 6570 | 119 |
2175683 | 2175683 | 2022-02-02 | Union | Mississippi | 28145 | 8832 | 109 |
2176007 | 2176007 | 2022-02-02 | Union | New Jersey | 34039 | 137767 | 2228 |
2176041 | 2176041 | 2022-02-02 | Union | New Mexico | 35059 | 944 | 12 |
2176191 | 2176191 | 2022-02-02 | Union | North Carolina | 37179 | 58141 | 425 |
2176339 | 2176339 | 2022-02-02 | Union | Ohio | 39159 | 14964 | 85 |
2176457 | 2176457 | 2022-02-02 | Union | Oregon | 41061 | 4690 | 66 |
2176522 | 2176522 | 2022-02-02 | Union | Pennsylvania | 42119 | 11090 | 139 |
2176658 | 2176658 | 2022-02-02 | Union | South Carolina | 45087 | 7185 | 130 |
2176723 | 2176723 | 2022-02-02 | Union | South Dakota | 46127 | 3900 | 49 |
2176813 | 2176813 | 2022-02-02 | Union | Tennessee | 47173 | 4778 | 68 |
2171122 | 2171122 | 2022-02-01 | Union | Arkansas | 5139 | 8728 | 159 |
2171327 | 2171327 | 2022-02-01 | Union | Florida | 12125 | 4022 | 104 |
2171476 | 2171476 | 2022-02-01 | Union | Georgia | 13291 | 4500 | 139 |
2171634 | 2171634 | 2022-02-01 | Union | Illinois | 17181 | 5084 | 64 |
2171727 | 2171727 | 2022-02-01 | Union | Indiana | 18161 | 1933 | 21 |
2171826 | 2171826 | 2022-02-01 | Union | Iowa | 19175 | 2506 | 46 |
2172056 | 2172056 | 2022-02-01 | Union | Kentucky | 21225 | 3979 | 52 |
2172119 | 2172119 | 2022-02-01 | Union | Louisiana | 22111 | 6512 | 119 |
2172430 | 2172430 | 2022-02-01 | Union | Mississippi | 28145 | 8734 | 107 |
2172754 | 2172754 | 2022-02-01 | Union | New Jersey | 34039 | 137515 | 2224 |
2172788 | 2172788 | 2022-02-01 | Union | New Mexico | 35059 | 944 | 12 |
2172938 | 2172938 | 2022-02-01 | Union | North Carolina | 37179 | 57841 | 425 |
2173085 | 2173085 | 2022-02-01 | Union | Ohio | 39159 | 14895 | 85 |
2173203 | 2173203 | 2022-02-01 | Union | Oregon | 41061 | 4647 | 66 |
2173268 | 2173268 | 2022-02-01 | Union | Pennsylvania | 42119 | 11062 | 139 |
2173404 | 2173404 | 2022-02-01 | Union | South Carolina | 45087 | 7162 | 127 |
2173469 | 2173469 | 2022-02-01 | Union | South Dakota | 46127 | 3890 | 49 |
2173559 | 2173559 | 2022-02-01 | Union | Tennessee | 47173 | 4469 | 68 |
2167869 | 2167869 | 2022-01-31 | Union | Arkansas | 5139 | 8700 | 159 |
2168074 | 2168074 | 2022-01-31 | Union | Florida | 12125 | 4022 | 104 |
2168223 | 2168223 | 2022-01-31 | Union | Georgia | 13291 | 4478 | 139 |
2168381 | 2168381 | 2022-01-31 | Union | Illinois | 17181 | 5041 | 64 |
2168474 | 2168474 | 2022-01-31 | Union | Indiana | 18161 | 1927 | 21 |
2168573 | 2168573 | 2022-01-31 | Union | Iowa | 19175 | 2506 | 46 |
2168803 | 2168803 | 2022-01-31 | Union | Kentucky | 21225 | 3951 | 52 |
2168866 | 2168866 | 2022-01-31 | Union | Louisiana | 22111 | 6475 | 119 |
2169177 | 2169177 | 2022-01-31 | Union | Mississippi | 28145 | 8658 | 106 |
2169501 | 2169501 | 2022-01-31 | Union | New Jersey | 34039 | 137326 | 2217 |
2169535 | 2169535 | 2022-01-31 | Union | New Mexico | 35059 | 933 | 12 |
2169685 | 2169685 | 2022-01-31 | Union | North Carolina | 37179 | 57632 | 423 |
2169833 | 2169833 | 2022-01-31 | Union | Ohio | 39159 | 14801 | 84 |
2169951 | 2169951 | 2022-01-31 | Union | Oregon | 41061 | 4649 | 66 |
2170016 | 2170016 | 2022-01-31 | Union | Pennsylvania | 42119 | 11036 | 137 |
2170152 | 2170152 | 2022-01-31 | Union | South Carolina | 45087 | 7155 | 126 |
2170217 | 2170217 | 2022-01-31 | Union | South Dakota | 46127 | 3872 | 48 |
2170307 | 2170307 | 2022-01-31 | Union | Tennessee | 47173 | 4469 | 68 |
2164614 | 2164614 | 2022-01-30 | Union | Arkansas | 5139 | 8613 | 159 |
2164819 | 2164819 | 2022-01-30 | Union | Florida | 12125 | 4022 | 104 |
2164968 | 2164968 | 2022-01-30 | Union | Georgia | 13291 | 4444 | 139 |
2165126 | 2165126 | 2022-01-30 | Union | Illinois | 17181 | 4955 | 63 |
2165219 | 2165219 | 2022-01-30 | Union | Indiana | 18161 | 1887 | 21 |
2165318 | 2165318 | 2022-01-30 | Union | Iowa | 19175 | 2506 | 46 |
2165548 | 2165548 | 2022-01-30 | Union | Kentucky | 21225 | 3891 | 52 |
2165611 | 2165611 | 2022-01-30 | Union | Louisiana | 22111 | 6381 | 119 |
2165922 | 2165922 | 2022-01-30 | Union | Mississippi | 28145 | 8573 | 106 |
2166246 | 2166246 | 2022-01-30 | Union | New Jersey | 34039 | 137232 | 2216 |
2166280 | 2166280 | 2022-01-30 | Union | New Mexico | 35059 | 919 | 12 |
2166430 | 2166430 | 2022-01-30 | Union | North Carolina | 37179 | 56693 | 420 |
2166578 | 2166578 | 2022-01-30 | Union | Ohio | 39159 | 14742 | 84 |
2166696 | 2166696 | 2022-01-30 | Union | Oregon | 41061 | 4545 | 66 |
2166762 | 2166762 | 2022-01-30 | Union | Pennsylvania | 42119 | 11015 | 137 |
2166898 | 2166898 | 2022-01-30 | Union | South Carolina | 45087 | 7087 | 121 |
2166963 | 2166963 | 2022-01-30 | Union | South Dakota | 46127 | 3848 | 47 |
2167053 | 2167053 | 2022-01-30 | Union | Tennessee | 47173 | 4469 | 68 |
2161359 | 2161359 | 2022-01-29 | Union | Arkansas | 5139 | 8613 | 159 |
2161564 | 2161564 | 2022-01-29 | Union | Florida | 12125 | 4022 | 104 |
2161713 | 2161713 | 2022-01-29 | Union | Georgia | 13291 | 4444 | 139 |
2161871 | 2161871 | 2022-01-29 | Union | Illinois | 17181 | 4955 | 63 |
2161964 | 2161964 | 2022-01-29 | Union | Indiana | 18161 | 1887 | 21 |
2162063 | 2162063 | 2022-01-29 | Union | Iowa | 19175 | 2506 | 46 |
2162293 | 2162293 | 2022-01-29 | Union | Kentucky | 21225 | 3891 | 52 |
2162356 | 2162356 | 2022-01-29 | Union | Louisiana | 22111 | 6381 | 119 |
2162667 | 2162667 | 2022-01-29 | Union | Mississippi | 28145 | 8573 | 106 |
2162991 | 2162991 | 2022-01-29 | Union | New Jersey | 34039 | 137171 | 2213 |
2163025 | 2163025 | 2022-01-29 | Union | New Mexico | 35059 | 919 | 12 |
2163175 | 2163175 | 2022-01-29 | Union | North Carolina | 37179 | 56693 | 420 |
2163323 | 2163323 | 2022-01-29 | Union | Ohio | 39159 | 14697 | 84 |
2163441 | 2163441 | 2022-01-29 | Union | Oregon | 41061 | 4545 | 66 |
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);