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 304
- Ohio 293
- Oregon 293
- Mississippi 292
- North Carolina 291
- Arkansas 288
- Louisiana 288
- South Carolina 288
- Kentucky 287
- South Dakota 286
- Tennessee 285
- Pennsylvania 283
- Florida 281
- Georgia 280
- Indiana 278
- Iowa 272
- Illinois 267
- New Mexico 257
fips 18
county 1
- Union · 5,113 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
901657 | 901657 | 2021-01-06 | Union | Illinois | 17181 | 1797 | 32 |
901749 | 901749 | 2021-01-06 | Union | Indiana | 18161 | 573 | 2 |
901848 | 901848 | 2021-01-06 | Union | Iowa | 19175 | 1048 | 19 |
902079 | 902079 | 2021-01-06 | Union | Kentucky | 21225 | 992 | 9 |
902142 | 902142 | 2021-01-06 | Union | Louisiana | 22111 | 1942 | 67 |
902453 | 902453 | 2021-01-06 | Union | Mississippi | 28145 | 3078 | 48 |
902776 | 902776 | 2021-01-06 | Union | New Jersey | 34039 | 42921 | 1577 |
902810 | 902810 | 2021-01-06 | Union | New Mexico | 35059 | 358 | 7 |
902959 | 902959 | 2021-01-06 | Union | North Carolina | 37179 | 13755 | 106 |
903105 | 903105 | 2021-01-06 | Union | Ohio | 39159 | 3843 | 21 |
903222 | 903222 | 2021-01-06 | Union | Oregon | 41061 | 998 | 16 |
903287 | 903287 | 2021-01-06 | Union | Pennsylvania | 42119 | 3102 | 47 |
903423 | 903423 | 2021-01-06 | Union | South Carolina | 45087 | 1656 | 43 |
903488 | 903488 | 2021-01-06 | Union | South Dakota | 46127 | 1655 | 30 |
903578 | 903578 | 2021-01-06 | Union | Tennessee | 47173 | 1289 | 19 |
897901 | 897901 | 2021-01-05 | Union | Arkansas | 5139 | 2584 | 73 |
898106 | 898106 | 2021-01-05 | Union | Florida | 12125 | 1490 | 65 |
898255 | 898255 | 2021-01-05 | Union | Georgia | 13291 | 1531 | 43 |
898412 | 898412 | 2021-01-05 | Union | Illinois | 17181 | 1774 | 32 |
898504 | 898504 | 2021-01-05 | Union | Indiana | 18161 | 564 | 2 |
898603 | 898603 | 2021-01-05 | Union | Iowa | 19175 | 1039 | 19 |
898834 | 898834 | 2021-01-05 | Union | Kentucky | 21225 | 986 | 9 |
898897 | 898897 | 2021-01-05 | Union | Louisiana | 22111 | 1906 | 66 |
899208 | 899208 | 2021-01-05 | Union | Mississippi | 28145 | 3033 | 46 |
899531 | 899531 | 2021-01-05 | Union | New Jersey | 34039 | 42658 | 1569 |
899565 | 899565 | 2021-01-05 | Union | New Mexico | 35059 | 358 | 7 |
899714 | 899714 | 2021-01-05 | Union | North Carolina | 37179 | 13554 | 103 |
899860 | 899860 | 2021-01-05 | Union | Ohio | 39159 | 3777 | 20 |
899977 | 899977 | 2021-01-05 | Union | Oregon | 41061 | 995 | 16 |
900042 | 900042 | 2021-01-05 | Union | Pennsylvania | 42119 | 3049 | 44 |
900178 | 900178 | 2021-01-05 | Union | South Carolina | 45087 | 1638 | 43 |
900243 | 900243 | 2021-01-05 | Union | South Dakota | 46127 | 1644 | 30 |
900333 | 900333 | 2021-01-05 | Union | Tennessee | 47173 | 1279 | 18 |
894656 | 894656 | 2021-01-04 | Union | Arkansas | 5139 | 2577 | 73 |
894861 | 894861 | 2021-01-04 | Union | Florida | 12125 | 1481 | 65 |
895010 | 895010 | 2021-01-04 | Union | Georgia | 13291 | 1521 | 42 |
895167 | 895167 | 2021-01-04 | Union | Illinois | 17181 | 1751 | 31 |
895259 | 895259 | 2021-01-04 | Union | Indiana | 18161 | 557 | 2 |
895358 | 895358 | 2021-01-04 | Union | Iowa | 19175 | 1037 | 19 |
895589 | 895589 | 2021-01-04 | Union | Kentucky | 21225 | 985 | 9 |
895652 | 895652 | 2021-01-04 | Union | Louisiana | 22111 | 1863 | 66 |
895963 | 895963 | 2021-01-04 | Union | Mississippi | 28145 | 2999 | 44 |
896286 | 896286 | 2021-01-04 | Union | New Jersey | 34039 | 42340 | 1564 |
896320 | 896320 | 2021-01-04 | Union | New Mexico | 35059 | 356 | 7 |
896469 | 896469 | 2021-01-04 | Union | North Carolina | 37179 | 13382 | 102 |
896615 | 896615 | 2021-01-04 | Union | Ohio | 39159 | 3743 | 19 |
896732 | 896732 | 2021-01-04 | Union | Oregon | 41061 | 992 | 15 |
896797 | 896797 | 2021-01-04 | Union | Pennsylvania | 42119 | 3001 | 44 |
896933 | 896933 | 2021-01-04 | Union | South Carolina | 45087 | 1635 | 43 |
896998 | 896998 | 2021-01-04 | Union | South Dakota | 46127 | 1641 | 30 |
897088 | 897088 | 2021-01-04 | Union | Tennessee | 47173 | 1269 | 17 |
891409 | 891409 | 2021-01-03 | Union | Arkansas | 5139 | 2569 | 73 |
891614 | 891614 | 2021-01-03 | Union | Florida | 12125 | 1480 | 65 |
891763 | 891763 | 2021-01-03 | Union | Georgia | 13291 | 1506 | 42 |
891920 | 891920 | 2021-01-03 | Union | Illinois | 17181 | 1738 | 31 |
892012 | 892012 | 2021-01-03 | Union | Indiana | 18161 | 552 | 2 |
892111 | 892111 | 2021-01-03 | Union | Iowa | 19175 | 1035 | 19 |
892342 | 892342 | 2021-01-03 | Union | Kentucky | 21225 | 973 | 9 |
892405 | 892405 | 2021-01-03 | Union | Louisiana | 22111 | 1864 | 66 |
892716 | 892716 | 2021-01-03 | Union | Mississippi | 28145 | 2949 | 43 |
893039 | 893039 | 2021-01-03 | Union | New Jersey | 34039 | 37479 | 1561 |
893073 | 893073 | 2021-01-03 | Union | New Mexico | 35059 | 355 | 7 |
893223 | 893223 | 2021-01-03 | Union | North Carolina | 37179 | 13215 | 101 |
893369 | 893369 | 2021-01-03 | Union | Ohio | 39159 | 3725 | 19 |
893486 | 893486 | 2021-01-03 | Union | Oregon | 41061 | 988 | 15 |
893551 | 893551 | 2021-01-03 | Union | Pennsylvania | 42119 | 2983 | 43 |
893687 | 893687 | 2021-01-03 | Union | South Carolina | 45087 | 1618 | 43 |
893752 | 893752 | 2021-01-03 | Union | South Dakota | 46127 | 1638 | 30 |
893842 | 893842 | 2021-01-03 | Union | Tennessee | 47173 | 1259 | 17 |
888162 | 888162 | 2021-01-02 | Union | Arkansas | 5139 | 2554 | 73 |
888367 | 888367 | 2021-01-02 | Union | Florida | 12125 | 1473 | 65 |
888516 | 888516 | 2021-01-02 | Union | Georgia | 13291 | 1479 | 42 |
888673 | 888673 | 2021-01-02 | Union | Illinois | 17181 | 1717 | 31 |
888766 | 888766 | 2021-01-02 | Union | Indiana | 18161 | 548 | 2 |
888865 | 888865 | 2021-01-02 | Union | Iowa | 19175 | 1035 | 19 |
889096 | 889096 | 2021-01-02 | Union | Kentucky | 21225 | 966 | 9 |
889159 | 889159 | 2021-01-02 | Union | Louisiana | 22111 | 1842 | 66 |
889470 | 889470 | 2021-01-02 | Union | Mississippi | 28145 | 2907 | 43 |
889793 | 889793 | 2021-01-02 | Union | New Jersey | 34039 | 37339 | 1560 |
889827 | 889827 | 2021-01-02 | Union | New Mexico | 35059 | 353 | 7 |
889977 | 889977 | 2021-01-02 | Union | North Carolina | 37179 | 13039 | 101 |
890123 | 890123 | 2021-01-02 | Union | Ohio | 39159 | 3701 | 19 |
890240 | 890240 | 2021-01-02 | Union | Oregon | 41061 | 982 | 14 |
890305 | 890305 | 2021-01-02 | Union | Pennsylvania | 42119 | 2953 | 43 |
890441 | 890441 | 2021-01-02 | Union | South Carolina | 45087 | 1563 | 42 |
890506 | 890506 | 2021-01-02 | Union | South Dakota | 46127 | 1616 | 30 |
890596 | 890596 | 2021-01-02 | Union | Tennessee | 47173 | 1255 | 17 |
884917 | 884917 | 2021-01-01 | Union | Arkansas | 5139 | 2523 | 73 |
885122 | 885122 | 2021-01-01 | Union | Florida | 12125 | 1439 | 65 |
885271 | 885271 | 2021-01-01 | Union | Georgia | 13291 | 1467 | 42 |
885428 | 885428 | 2021-01-01 | Union | Illinois | 17181 | 1697 | 31 |
885520 | 885520 | 2021-01-01 | Union | Indiana | 18161 | 537 | 2 |
885619 | 885619 | 2021-01-01 | Union | Iowa | 19175 | 1034 | 19 |
885850 | 885850 | 2021-01-01 | Union | Kentucky | 21225 | 954 | 9 |
885913 | 885913 | 2021-01-01 | Union | Louisiana | 22111 | 1842 | 66 |
886224 | 886224 | 2021-01-01 | Union | Mississippi | 28145 | 2865 | 42 |
886547 | 886547 | 2021-01-01 | Union | New Jersey | 34039 | 37015 | 1559 |
886581 | 886581 | 2021-01-01 | Union | New Mexico | 35059 | 354 | 7 |
886730 | 886730 | 2021-01-01 | Union | North Carolina | 37179 | 12505 | 98 |
886876 | 886876 | 2021-01-01 | Union | Ohio | 39159 | 3597 | 19 |
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);