⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

6,124 rows where county = "Union" sorted by date descending

View and edit SQL

Suggested facets: date (date)

fips

county

  • Union · 6,124
Link rowid date ▲ county state fips cases deaths
1082895 2021-03-03 Union Arkansas 5139 3744 100
1083100 2021-03-03 Union Florida 12125 1740 70
1083249 2021-03-03 Union Georgia 13291 2102 65
1083406 2021-03-03 Union Illinois 17181 2198 42
1083499 2021-03-03 Union Indiana 18161 701 11
1083598 2021-03-03 Union Iowa 19175 1177 31
1083829 2021-03-03 Union Kentucky 21225 1270 13
1083892 2021-03-03 Union Louisiana 22111 2304 76
1084203 2021-03-03 Union Mississippi 28145 3961 74
1084526 2021-03-03 Union New Jersey 34039 57442 1772
1084560 2021-03-03 Union New Mexico 35059 403 9
1084709 2021-03-03 Union North Carolina 37179 20846 198
1084855 2021-03-03 Union Ohio 39159 5135 37
1084972 2021-03-03 Union Oregon 41061 1295 19
1085037 2021-03-03 Union Pennsylvania 42119 5273 81
1085173 2021-03-03 Union South Carolina 45087 2641 75
1085238 2021-03-03 Union South Dakota 46127 1989 39
1085328 2021-03-03 Union Tennessee 47173 1725 33
1079649 2021-03-02 Union Arkansas 5139 3729 100
1079854 2021-03-02 Union Florida 12125 1740 70
1080003 2021-03-02 Union Georgia 13291 2079 65
1080160 2021-03-02 Union Illinois 17181 2191 42
1080253 2021-03-02 Union Indiana 18161 700 11
1080352 2021-03-02 Union Iowa 19175 1177 31
1080583 2021-03-02 Union Kentucky 21225 1269 13
1080646 2021-03-02 Union Louisiana 22111 2300 76
1080957 2021-03-02 Union Mississippi 28145 3956 74
1081280 2021-03-02 Union New Jersey 34039 57196 1768
1081314 2021-03-02 Union New Mexico 35059 403 9
1081463 2021-03-02 Union North Carolina 37179 20784 198
1081609 2021-03-02 Union Ohio 39159 5129 37
1081726 2021-03-02 Union Oregon 41061 1285 19
1081791 2021-03-02 Union Pennsylvania 42119 5261 81
1081927 2021-03-02 Union South Carolina 45087 2629 75
1081992 2021-03-02 Union South Dakota 46127 1987 39
1082082 2021-03-02 Union Tennessee 47173 1722 33
1076404 2021-03-01 Union Arkansas 5139 3727 100
1076609 2021-03-01 Union Florida 12125 1740 70
1076758 2021-03-01 Union Georgia 13291 2071 65
1076915 2021-03-01 Union Illinois 17181 2185 41
1077008 2021-03-01 Union Indiana 18161 699 11
1077107 2021-03-01 Union Iowa 19175 1177 31
1077338 2021-03-01 Union Kentucky 21225 1269 13
1077401 2021-03-01 Union Louisiana 22111 2298 76
1077711 2021-03-01 Union Mississippi 28145 3953 74
1078034 2021-03-01 Union New Jersey 34039 56976 1766
1078068 2021-03-01 Union New Mexico 35059 403 9
1078217 2021-03-01 Union North Carolina 37179 20743 197
1078363 2021-03-01 Union Ohio 39159 5123 52
1078480 2021-03-01 Union Oregon 41061 1284 19
1078545 2021-03-01 Union Pennsylvania 42119 5264 81
1078681 2021-03-01 Union South Carolina 45087 2627 75
1078746 2021-03-01 Union South Dakota 46127 1981 39
1078836 2021-03-01 Union Tennessee 47173 1719 33
1073158 2021-02-28 Union Arkansas 5139 3708 100
1073363 2021-02-28 Union Florida 12125 1740 70
1073512 2021-02-28 Union Georgia 13291 2071 65
1073669 2021-02-28 Union Illinois 17181 2185 40
1073762 2021-02-28 Union Indiana 18161 699 11
1073861 2021-02-28 Union Iowa 19175 1177 31
1074092 2021-02-28 Union Kentucky 21225 1269 13
1074155 2021-02-28 Union Louisiana 22111 2297 76
1074465 2021-02-28 Union Mississippi 28145 3951 74
1074788 2021-02-28 Union New Jersey 34039 56756 1766
1074822 2021-02-28 Union New Mexico 35059 403 9
1074972 2021-02-28 Union North Carolina 37179 20652 196
1075118 2021-02-28 Union Ohio 39159 5112 52
1075235 2021-02-28 Union Oregon 41061 1284 19
1075300 2021-02-28 Union Pennsylvania 42119 5261 81
1075436 2021-02-28 Union South Carolina 45087 2619 75
1075501 2021-02-28 Union South Dakota 46127 1981 39
1075591 2021-02-28 Union Tennessee 47173 1719 33
1069912 2021-02-27 Union Arkansas 5139 3662 102
1070117 2021-02-27 Union Florida 12125 1741 70
1070266 2021-02-27 Union Georgia 13291 2071 65
1070423 2021-02-27 Union Illinois 17181 2185 40
1070516 2021-02-27 Union Indiana 18161 699 11
1070615 2021-02-27 Union Iowa 19175 1177 31
1070846 2021-02-27 Union Kentucky 21225 1269 13
1070909 2021-02-27 Union Louisiana 22111 2294 76
1071219 2021-02-27 Union Mississippi 28145 3949 74
1071542 2021-02-27 Union New Jersey 34039 56591 1764
1071576 2021-02-27 Union New Mexico 35059 403 9
1071726 2021-02-27 Union North Carolina 37179 20652 196
1071872 2021-02-27 Union Ohio 39159 5097 52
1071989 2021-02-27 Union Oregon 41061 1284 19
1072054 2021-02-27 Union Pennsylvania 42119 5281 81
1072190 2021-02-27 Union South Carolina 45087 2612 75
1072255 2021-02-27 Union South Dakota 46127 1978 39
1072345 2021-02-27 Union Tennessee 47173 1715 33
1066667 2021-02-26 Union Arkansas 5139 3661 102
1066872 2021-02-26 Union Florida 12125 1740 70
1067021 2021-02-26 Union Georgia 13291 2067 65
1067178 2021-02-26 Union Illinois 17181 2184 40
1067271 2021-02-26 Union Indiana 18161 697 11
1067370 2021-02-26 Union Iowa 19175 1177 31
1067601 2021-02-26 Union Kentucky 21225 1267 13
1067664 2021-02-26 Union Louisiana 22111 2294 76
1067974 2021-02-26 Union Mississippi 28145 3936 73
1068297 2021-02-26 Union New Jersey 34039 56275 1761

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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]);