⚠️ 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

5,314 rows where county = "Union" sorted by date descending

View and edit SQL

Suggested facets: date (date)

fips

county

  • Union · 5,314
Link rowid date ▲ county state fips cases deaths
936923 2021-01-17 Union Arkansas 5139 2977 82
937128 2021-01-17 Union Florida 12125 1610 69
937277 2021-01-17 Union Georgia 13291 1725 48
937434 2021-01-17 Union Illinois 17181 1973 32
937526 2021-01-17 Union Indiana 18161 638 3
937625 2021-01-17 Union Iowa 19175 1081 22
937856 2021-01-17 Union Kentucky 21225 1099 9
937919 2021-01-17 Union Louisiana 22111 2115 69
938230 2021-01-17 Union Mississippi 28145 3430 60
938553 2021-01-17 Union New Jersey 34039 47363 1615
938587 2021-01-17 Union New Mexico 35059 373 7
938736 2021-01-17 Union North Carolina 37179 16184 128
938882 2021-01-17 Union Ohio 39159 4306 28
938999 2021-01-17 Union Oregon 41061 1114 16
939064 2021-01-17 Union Pennsylvania 42119 3667 61
939200 2021-01-17 Union South Carolina 45087 1860 53
939265 2021-01-17 Union South Dakota 46127 1806 34
939355 2021-01-17 Union Tennessee 47173 1387 21
933678 2021-01-16 Union Arkansas 5139 2969 81
933883 2021-01-16 Union Florida 12125 1609 69
934032 2021-01-16 Union Georgia 13291 1716 48
934189 2021-01-16 Union Illinois 17181 1968 32
934281 2021-01-16 Union Indiana 18161 633 3
934380 2021-01-16 Union Iowa 19175 1081 22
934611 2021-01-16 Union Kentucky 21225 1092 9
934674 2021-01-16 Union Louisiana 22111 2091 69
934985 2021-01-16 Union Mississippi 28145 3414 58
935308 2021-01-16 Union New Jersey 34039 47079 1613
935342 2021-01-16 Union New Mexico 35059 373 7
935491 2021-01-16 Union North Carolina 37179 16036 125
935637 2021-01-16 Union Ohio 39159 4292 28
935754 2021-01-16 Union Oregon 41061 1104 16
935819 2021-01-16 Union Pennsylvania 42119 3647 60
935955 2021-01-16 Union South Carolina 45087 1837 51
936020 2021-01-16 Union South Dakota 46127 1795 32
936110 2021-01-16 Union Tennessee 47173 1377 21
930433 2021-01-15 Union Arkansas 5139 2926 80
930638 2021-01-15 Union Florida 12125 1602 68
930787 2021-01-15 Union Georgia 13291 1691 47
930944 2021-01-15 Union Illinois 17181 1957 32
931036 2021-01-15 Union Indiana 18161 633 3
931135 2021-01-15 Union Iowa 19175 1081 22
931366 2021-01-15 Union Kentucky 21225 1079 9
931429 2021-01-15 Union Louisiana 22111 2091 69
931740 2021-01-15 Union Mississippi 28145 3374 57
932063 2021-01-15 Union New Jersey 34039 46716 1610
932097 2021-01-15 Union New Mexico 35059 372 7
932246 2021-01-15 Union North Carolina 37179 15829 125
932392 2021-01-15 Union Ohio 39159 4245 28
932509 2021-01-15 Union Oregon 41061 1095 16
932574 2021-01-15 Union Pennsylvania 42119 3613 59
932710 2021-01-15 Union South Carolina 45087 1823 51
932775 2021-01-15 Union South Dakota 46127 1784 32
932865 2021-01-15 Union Tennessee 47173 1368 21
927188 2021-01-14 Union Arkansas 5139 2876 79
927393 2021-01-14 Union Florida 12125 1592 68
927542 2021-01-14 Union Georgia 13291 1681 47
927699 2021-01-14 Union Illinois 17181 1946 32
927791 2021-01-14 Union Indiana 18161 630 3
927890 2021-01-14 Union Iowa 19175 1079 22
928121 2021-01-14 Union Kentucky 21225 1067 9
928184 2021-01-14 Union Louisiana 22111 2079 69
928495 2021-01-14 Union Mississippi 28145 3347 55
928818 2021-01-14 Union New Jersey 34039 46352 1610
928852 2021-01-14 Union New Mexico 35059 370 7
929001 2021-01-14 Union North Carolina 37179 15650 125
929147 2021-01-14 Union Ohio 39159 4223 27
929264 2021-01-14 Union Oregon 41061 1089 16
929329 2021-01-14 Union Pennsylvania 42119 3589 55
929465 2021-01-14 Union South Carolina 45087 1813 51
929530 2021-01-14 Union South Dakota 46127 1763 30
929620 2021-01-14 Union Tennessee 47173 1361 21
923942 2021-01-13 Union Arkansas 5139 2849 79
924147 2021-01-13 Union Florida 12125 1578 68
924296 2021-01-13 Union Georgia 13291 1671 47
924453 2021-01-13 Union Illinois 17181 1919 32
924545 2021-01-13 Union Indiana 18161 627 3
924644 2021-01-13 Union Iowa 19175 1078 22
924875 2021-01-13 Union Kentucky 21225 1055 9
924938 2021-01-13 Union Louisiana 22111 2058 69
925249 2021-01-13 Union Mississippi 28145 3330 55
925572 2021-01-13 Union New Jersey 34039 45916 1607
925606 2021-01-13 Union New Mexico 35059 370 7
925756 2021-01-13 Union North Carolina 37179 15368 124
925902 2021-01-13 Union Ohio 39159 4172 25
926019 2021-01-13 Union Oregon 41061 1070 16
926084 2021-01-13 Union Pennsylvania 42119 3560 54
926220 2021-01-13 Union South Carolina 45087 1790 51
926285 2021-01-13 Union South Dakota 46127 1739 30
926375 2021-01-13 Union Tennessee 47173 1350 20
920697 2021-01-12 Union Arkansas 5139 2812 77
920902 2021-01-12 Union Florida 12125 1574 66
921051 2021-01-12 Union Georgia 13291 1665 46
921208 2021-01-12 Union Illinois 17181 1903 32
921300 2021-01-12 Union Indiana 18161 624 2
921399 2021-01-12 Union Iowa 19175 1075 22
921630 2021-01-12 Union Kentucky 21225 1043 9
921693 2021-01-12 Union Louisiana 22111 2050 69
922004 2021-01-12 Union Mississippi 28145 3295 55
922327 2021-01-12 Union New Jersey 34039 45409 1601

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