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 112
- Ohio 101
- Oregon 101
- Mississippi 100
- North Carolina 99
- Arkansas 97
- Louisiana 96
- South Carolina 96
- Kentucky 95
- South Dakota 94
- Tennessee 93
- Pennsylvania 91
- Florida 90
- Georgia 89
- Indiana 86
- Iowa 80
- Illinois 75
- New Mexico 65
fips 18
county 1
- Union · 1,660 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
280962 | 280962 | 2020-06-28 | Union | Arkansas | 5139 | 245 | 13 |
281163 | 281163 | 2020-06-28 | Union | Florida | 12125 | 61 | 2 |
281312 | 281312 | 2020-06-28 | Union | Georgia | 13291 | 68 | 3 |
281462 | 281462 | 2020-06-28 | Union | Illinois | 17181 | 184 | 19 |
281555 | 281555 | 2020-06-28 | Union | Indiana | 18161 | 29 | 0 |
281654 | 281654 | 2020-06-28 | Union | Iowa | 19175 | 26 | 0 |
281873 | 281873 | 2020-06-28 | Union | Kentucky | 21225 | 29 | 0 |
281936 | 281936 | 2020-06-28 | Union | Louisiana | 22111 | 412 | 24 |
282245 | 282245 | 2020-06-28 | Union | Mississippi | 28145 | 161 | 8 |
282532 | 282532 | 2020-06-28 | Union | New Jersey | 34039 | 16548 | 1325 |
282564 | 282564 | 2020-06-28 | Union | New Mexico | 35059 | 7 | 0 |
282713 | 282713 | 2020-06-28 | Union | North Carolina | 37179 | 1151 | 24 |
282854 | 282854 | 2020-06-28 | Union | Ohio | 39159 | 77 | 1 |
282967 | 282967 | 2020-06-28 | Union | Oregon | 41061 | 322 | 1 |
283031 | 283031 | 2020-06-28 | Union | Pennsylvania | 42119 | 90 | 2 |
283167 | 283167 | 2020-06-28 | Union | South Carolina | 45087 | 73 | 0 |
283225 | 283225 | 2020-06-28 | Union | South Dakota | 46127 | 121 | 1 |
283315 | 283315 | 2020-06-28 | Union | Tennessee | 47173 | 11 | 0 |
277815 | 277815 | 2020-06-27 | Union | Arkansas | 5139 | 245 | 13 |
278016 | 278016 | 2020-06-27 | Union | Florida | 12125 | 58 | 2 |
278165 | 278165 | 2020-06-27 | Union | Georgia | 13291 | 67 | 3 |
278314 | 278314 | 2020-06-27 | Union | Illinois | 17181 | 183 | 19 |
278407 | 278407 | 2020-06-27 | Union | Indiana | 18161 | 29 | 0 |
278506 | 278506 | 2020-06-27 | Union | Iowa | 19175 | 24 | 0 |
278725 | 278725 | 2020-06-27 | Union | Kentucky | 21225 | 29 | 0 |
278788 | 278788 | 2020-06-27 | Union | Louisiana | 22111 | 405 | 24 |
279097 | 279097 | 2020-06-27 | Union | Mississippi | 28145 | 160 | 8 |
279385 | 279385 | 2020-06-27 | Union | New Jersey | 34039 | 16533 | 1324 |
279417 | 279417 | 2020-06-27 | Union | New Mexico | 35059 | 7 | 0 |
279567 | 279567 | 2020-06-27 | Union | North Carolina | 37179 | 1123 | 24 |
279708 | 279708 | 2020-06-27 | Union | Ohio | 39159 | 76 | 1 |
279821 | 279821 | 2020-06-27 | Union | Oregon | 41061 | 320 | 1 |
279885 | 279885 | 2020-06-27 | Union | Pennsylvania | 42119 | 90 | 2 |
280021 | 280021 | 2020-06-27 | Union | South Carolina | 45087 | 73 | 0 |
280079 | 280079 | 2020-06-27 | Union | South Dakota | 46127 | 119 | 1 |
280169 | 280169 | 2020-06-27 | Union | Tennessee | 47173 | 11 | 0 |
274667 | 274667 | 2020-06-26 | Union | Arkansas | 5139 | 243 | 13 |
274868 | 274868 | 2020-06-26 | Union | Florida | 12125 | 48 | 2 |
275017 | 275017 | 2020-06-26 | Union | Georgia | 13291 | 67 | 3 |
275166 | 275166 | 2020-06-26 | Union | Illinois | 17181 | 183 | 18 |
275259 | 275259 | 2020-06-26 | Union | Indiana | 18161 | 29 | 0 |
275358 | 275358 | 2020-06-26 | Union | Iowa | 19175 | 17 | 0 |
275577 | 275577 | 2020-06-26 | Union | Kentucky | 21225 | 28 | 0 |
275640 | 275640 | 2020-06-26 | Union | Louisiana | 22111 | 405 | 24 |
275949 | 275949 | 2020-06-26 | Union | Mississippi | 28145 | 157 | 8 |
276237 | 276237 | 2020-06-26 | Union | New Jersey | 34039 | 16536 | 1323 |
276269 | 276269 | 2020-06-26 | Union | New Mexico | 35059 | 7 | 0 |
276419 | 276419 | 2020-06-26 | Union | North Carolina | 37179 | 1114 | 24 |
276560 | 276560 | 2020-06-26 | Union | Ohio | 39159 | 74 | 1 |
276673 | 276673 | 2020-06-26 | Union | Oregon | 41061 | 309 | 1 |
276737 | 276737 | 2020-06-26 | Union | Pennsylvania | 42119 | 90 | 2 |
276873 | 276873 | 2020-06-26 | Union | South Carolina | 45087 | 72 | 0 |
276931 | 276931 | 2020-06-26 | Union | South Dakota | 46127 | 118 | 1 |
277021 | 277021 | 2020-06-26 | Union | Tennessee | 47173 | 11 | 0 |
271527 | 271527 | 2020-06-25 | Union | Arkansas | 5139 | 237 | 13 |
271728 | 271728 | 2020-06-25 | Union | Florida | 12125 | 46 | 2 |
271877 | 271877 | 2020-06-25 | Union | Georgia | 13291 | 62 | 3 |
272024 | 272024 | 2020-06-25 | Union | Illinois | 17181 | 181 | 18 |
272117 | 272117 | 2020-06-25 | Union | Indiana | 18161 | 29 | 0 |
272216 | 272216 | 2020-06-25 | Union | Iowa | 19175 | 17 | 0 |
272434 | 272434 | 2020-06-25 | Union | Kentucky | 21225 | 26 | 0 |
272497 | 272497 | 2020-06-25 | Union | Louisiana | 22111 | 398 | 23 |
272806 | 272806 | 2020-06-25 | Union | Mississippi | 28145 | 150 | 8 |
273092 | 273092 | 2020-06-25 | Union | New Jersey | 34039 | 16514 | 1321 |
273124 | 273124 | 2020-06-25 | Union | New Mexico | 35059 | 6 | 0 |
273273 | 273273 | 2020-06-25 | Union | North Carolina | 37179 | 1042 | 24 |
273413 | 273413 | 2020-06-25 | Union | Ohio | 39159 | 73 | 1 |
273526 | 273526 | 2020-06-25 | Union | Oregon | 41061 | 297 | 0 |
273590 | 273590 | 2020-06-25 | Union | Pennsylvania | 42119 | 89 | 2 |
273726 | 273726 | 2020-06-25 | Union | South Carolina | 45087 | 71 | 0 |
273784 | 273784 | 2020-06-25 | Union | South Dakota | 46127 | 118 | 1 |
273874 | 273874 | 2020-06-25 | Union | Tennessee | 47173 | 10 | 0 |
268392 | 268392 | 2020-06-24 | Union | Arkansas | 5139 | 232 | 13 |
268592 | 268592 | 2020-06-24 | Union | Florida | 12125 | 44 | 2 |
268741 | 268741 | 2020-06-24 | Union | Georgia | 13291 | 62 | 3 |
268887 | 268887 | 2020-06-24 | Union | Illinois | 17181 | 182 | 18 |
268980 | 268980 | 2020-06-24 | Union | Indiana | 18161 | 28 | 0 |
269079 | 269079 | 2020-06-24 | Union | Iowa | 19175 | 15 | 0 |
269298 | 269298 | 2020-06-24 | Union | Kentucky | 21225 | 25 | 0 |
269361 | 269361 | 2020-06-24 | Union | Louisiana | 22111 | 395 | 23 |
269668 | 269668 | 2020-06-24 | Union | Mississippi | 28145 | 138 | 8 |
269953 | 269953 | 2020-06-24 | Union | New Jersey | 34039 | 16330 | 1140 |
269985 | 269985 | 2020-06-24 | Union | New Mexico | 35059 | 6 | 0 |
270134 | 270134 | 2020-06-24 | Union | North Carolina | 37179 | 1032 | 24 |
270274 | 270274 | 2020-06-24 | Union | Ohio | 39159 | 73 | 1 |
270387 | 270387 | 2020-06-24 | Union | Oregon | 41061 | 287 | 0 |
270451 | 270451 | 2020-06-24 | Union | Pennsylvania | 42119 | 89 | 2 |
270587 | 270587 | 2020-06-24 | Union | South Carolina | 45087 | 68 | 0 |
270645 | 270645 | 2020-06-24 | Union | South Dakota | 46127 | 118 | 1 |
270735 | 270735 | 2020-06-24 | Union | Tennessee | 47173 | 9 | 0 |
265262 | 265262 | 2020-06-23 | Union | Arkansas | 5139 | 232 | 13 |
265462 | 265462 | 2020-06-23 | Union | Florida | 12125 | 43 | 2 |
265611 | 265611 | 2020-06-23 | Union | Georgia | 13291 | 60 | 3 |
265757 | 265757 | 2020-06-23 | Union | Illinois | 17181 | 182 | 18 |
265850 | 265850 | 2020-06-23 | Union | Indiana | 18161 | 27 | 0 |
265949 | 265949 | 2020-06-23 | Union | Iowa | 19175 | 14 | 0 |
266165 | 266165 | 2020-06-23 | Union | Kentucky | 21225 | 25 | 0 |
266228 | 266228 | 2020-06-23 | Union | Louisiana | 22111 | 391 | 21 |
266535 | 266535 | 2020-06-23 | Union | Mississippi | 28145 | 131 | 8 |
266818 | 266818 | 2020-06-23 | Union | New Jersey | 34039 | 16341 | 1139 |
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);