ny_times_us_counties

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

1,894 rows where county = "Union" sorted by date descending

View and edit SQL

Suggested facets: date (date)

fips

county

  • Union · 1,894
Link rowid date ▲ county state fips cases deaths
316625 2020-07-11 Union Arkansas 5139 273 14
316826 2020-07-11 Union Florida 12125 109 2
316975 2020-07-11 Union Georgia 13291 99 4
317128 2020-07-11 Union Illinois 17181 205 19
317221 2020-07-11 Union Indiana 18161 31 0
317320 2020-07-11 Union Iowa 19175 38 0
317545 2020-07-11 Union Kentucky 21225 31 0
317608 2020-07-11 Union Louisiana 22111 474 28
317918 2020-07-11 Union Mississippi 28145 252 11
318211 2020-07-11 Union New Jersey 34039 16655 1343
318244 2020-07-11 Union New Mexico 35059 8 0
318394 2020-07-11 Union North Carolina 37179 1778 25
318535 2020-07-11 Union Ohio 39159 93 1
318651 2020-07-11 Union Oregon 41061 369 2
318715 2020-07-11 Union Pennsylvania 42119 98 2
318773 2020-07-11 Union South Carolina 45087 153 0
318836 2020-07-11 Union South Dakota 46127 150 1
318926 2020-07-11 Union Tennessee 47173 25 0
313527 2020-07-10 Union Arkansas 5139 267 13
313728 2020-07-10 Union Florida 12125 105 2
313877 2020-07-10 Union Georgia 13291 98 3
314030 2020-07-10 Union Illinois 17181 202 19
314123 2020-07-10 Union Indiana 18161 30 0
314222 2020-07-10 Union Iowa 19175 38 0
314447 2020-07-10 Union Kentucky 21225 30 0
314510 2020-07-10 Union Louisiana 22111 471 27
314820 2020-07-10 Union Mississippi 28145 246 11
315112 2020-07-10 Union New Jersey 34039 16644 1341
315145 2020-07-10 Union New Mexico 35059 8 0
315294 2020-07-10 Union North Carolina 37179 1712 25
315435 2020-07-10 Union Ohio 39159 93 1
315551 2020-07-10 Union Oregon 41061 368 2
315615 2020-07-10 Union Pennsylvania 42119 97 2
315673 2020-07-10 Union South Carolina 45087 138 0
315735 2020-07-10 Union South Dakota 46127 148 1
315825 2020-07-10 Union Tennessee 47173 22 0
310435 2020-07-09 Union Arkansas 5139 266 13
310636 2020-07-09 Union Florida 12125 101 2
310785 2020-07-09 Union Georgia 13291 92 3
310938 2020-07-09 Union Illinois 17181 196 19
311031 2020-07-09 Union Indiana 18161 30 0
311130 2020-07-09 Union Iowa 19175 37 0
311353 2020-07-09 Union Kentucky 21225 30 0
311416 2020-07-09 Union Louisiana 22111 463 27
311726 2020-07-09 Union Mississippi 28145 238 11
312017 2020-07-09 Union New Jersey 34039 16646 1341
312049 2020-07-09 Union New Mexico 35059 8 0
312198 2020-07-09 Union North Carolina 37179 1643 25
312339 2020-07-09 Union Ohio 39159 92 1
312454 2020-07-09 Union Oregon 41061 367 1
312518 2020-07-09 Union Pennsylvania 42119 97 2
312576 2020-07-09 Union South Carolina 45087 133 0
312638 2020-07-09 Union South Dakota 46127 140 1
312728 2020-07-09 Union Tennessee 47173 20 0
307340 2020-07-08 Union Arkansas 5139 264 13
307541 2020-07-08 Union Florida 12125 99 2
307690 2020-07-08 Union Georgia 13291 89 3
307844 2020-07-08 Union Illinois 17181 195 19
307937 2020-07-08 Union Indiana 18161 29 0
308036 2020-07-08 Union Iowa 19175 36 0
308259 2020-07-08 Union Kentucky 21225 30 0
308322 2020-07-08 Union Louisiana 22111 452 27
308632 2020-07-08 Union Mississippi 28145 233 11
308923 2020-07-08 Union New Jersey 34039 16618 1330
308955 2020-07-08 Union New Mexico 35059 8 0
309104 2020-07-08 Union North Carolina 37179 1579 25
309247 2020-07-08 Union Ohio 39159 92 1
309362 2020-07-08 Union Oregon 41061 363 1
309426 2020-07-08 Union Pennsylvania 42119 98 2
309484 2020-07-08 Union South Carolina 45087 127 0
309546 2020-07-08 Union South Dakota 46127 138 1
309636 2020-07-08 Union Tennessee 47173 19 0
304250 2020-07-07 Union Arkansas 5139 256 13
304451 2020-07-07 Union Florida 12125 92 2
304600 2020-07-07 Union Georgia 13291 85 3
304754 2020-07-07 Union Illinois 17181 195 19
304847 2020-07-07 Union Indiana 18161 29 0
304946 2020-07-07 Union Iowa 19175 34 0
305169 2020-07-07 Union Kentucky 21225 30 0
305232 2020-07-07 Union Louisiana 22111 447 27
305542 2020-07-07 Union Mississippi 28145 218 10
305832 2020-07-07 Union New Jersey 34039 16625 1331
305864 2020-07-07 Union New Mexico 35059 8 0
306013 2020-07-07 Union North Carolina 37179 1551 25
306155 2020-07-07 Union Ohio 39159 89 1
306270 2020-07-07 Union Oregon 41061 361 1
306334 2020-07-07 Union Pennsylvania 42119 96 2
306392 2020-07-07 Union South Carolina 45087 120 0
306452 2020-07-07 Union South Dakota 46127 137 1
306542 2020-07-07 Union Tennessee 47173 19 0
301162 2020-07-06 Union Arkansas 5139 253 13
301363 2020-07-06 Union Florida 12125 89 2
301512 2020-07-06 Union Georgia 13291 78 3
301666 2020-07-06 Union Illinois 17181 196 19
301759 2020-07-06 Union Indiana 18161 29 0
301858 2020-07-06 Union Iowa 19175 29 0
302081 2020-07-06 Union Kentucky 21225 29 0
302144 2020-07-06 Union Louisiana 22111 445 26
302454 2020-07-06 Union Mississippi 28145 210 9
302744 2020-07-06 Union New Jersey 34039 16607 1328

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
);
Powered by Datasette · Query took 1011.321ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette