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 191
- Ohio 180
- Oregon 180
- Mississippi 179
- North Carolina 178
- Arkansas 176
- Louisiana 175
- South Carolina 175
- Kentucky 174
- South Dakota 173
- Tennessee 172
- Pennsylvania 170
- Florida 169
- Georgia 168
- Indiana 165
- Iowa 159
- Illinois 154
- New Mexico 144
fips 18
county 1
- Union · 3,082 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
534602 | 534602 | 2020-09-15 | Union | Arkansas | 5139 | 816 | 31 |
534806 | 534806 | 2020-09-15 | Union | Florida | 12125 | 820 | 8 |
534955 | 534955 | 2020-09-15 | Union | Georgia | 13291 | 608 | 17 |
535111 | 535111 | 2020-09-15 | Union | Illinois | 17181 | 476 | 24 |
535204 | 535204 | 2020-09-15 | Union | Indiana | 18161 | 99 | 0 |
535303 | 535303 | 2020-09-15 | Union | Iowa | 19175 | 105 | 3 |
535533 | 535533 | 2020-09-15 | Union | Kentucky | 21225 | 216 | 1 |
535596 | 535596 | 2020-09-15 | Union | Louisiana | 22111 | 919 | 41 |
535906 | 535906 | 2020-09-15 | Union | Mississippi | 28145 | 957 | 23 |
536224 | 536224 | 2020-09-15 | Union | New Jersey | 34039 | 17503 | 1356 |
536258 | 536258 | 2020-09-15 | Union | New Mexico | 35059 | 32 | 2 |
536408 | 536408 | 2020-09-15 | Union | North Carolina | 37179 | 4474 | 56 |
536555 | 536555 | 2020-09-15 | Union | Ohio | 39159 | 444 | 2 |
536672 | 536672 | 2020-09-15 | Union | Oregon | 41061 | 433 | 2 |
536736 | 536736 | 2020-09-15 | Union | Pennsylvania | 42119 | 439 | 6 |
536872 | 536872 | 2020-09-15 | Union | South Carolina | 45087 | 514 | 10 |
536937 | 536937 | 2020-09-15 | Union | South Dakota | 46127 | 332 | 5 |
537027 | 537027 | 2020-09-15 | Union | Tennessee | 47173 | 284 | 1 |
531367 | 531367 | 2020-09-14 | Union | Arkansas | 5139 | 801 | 25 |
531571 | 531571 | 2020-09-14 | Union | Florida | 12125 | 795 | 7 |
531720 | 531720 | 2020-09-14 | Union | Georgia | 13291 | 603 | 17 |
531876 | 531876 | 2020-09-14 | Union | Illinois | 17181 | 473 | 24 |
531969 | 531969 | 2020-09-14 | Union | Indiana | 18161 | 99 | 0 |
532068 | 532068 | 2020-09-14 | Union | Iowa | 19175 | 105 | 3 |
532298 | 532298 | 2020-09-14 | Union | Kentucky | 21225 | 213 | 1 |
532361 | 532361 | 2020-09-14 | Union | Louisiana | 22111 | 913 | 41 |
532671 | 532671 | 2020-09-14 | Union | Mississippi | 28145 | 952 | 23 |
532989 | 532989 | 2020-09-14 | Union | New Jersey | 34039 | 17490 | 1355 |
533023 | 533023 | 2020-09-14 | Union | New Mexico | 35059 | 32 | 2 |
533172 | 533172 | 2020-09-14 | Union | North Carolina | 37179 | 4474 | 56 |
533319 | 533319 | 2020-09-14 | Union | Ohio | 39159 | 443 | 2 |
533436 | 533436 | 2020-09-14 | Union | Oregon | 41061 | 432 | 2 |
533500 | 533500 | 2020-09-14 | Union | Pennsylvania | 42119 | 435 | 6 |
533636 | 533636 | 2020-09-14 | Union | South Carolina | 45087 | 507 | 10 |
533701 | 533701 | 2020-09-14 | Union | South Dakota | 46127 | 329 | 5 |
533791 | 533791 | 2020-09-14 | Union | Tennessee | 47173 | 281 | 1 |
528130 | 528130 | 2020-09-13 | Union | Arkansas | 5139 | 796 | 25 |
528334 | 528334 | 2020-09-13 | Union | Florida | 12125 | 798 | 7 |
528483 | 528483 | 2020-09-13 | Union | Georgia | 13291 | 599 | 17 |
528639 | 528639 | 2020-09-13 | Union | Illinois | 17181 | 471 | 24 |
528732 | 528732 | 2020-09-13 | Union | Indiana | 18161 | 97 | 0 |
528831 | 528831 | 2020-09-13 | Union | Iowa | 19175 | 104 | 3 |
529061 | 529061 | 2020-09-13 | Union | Kentucky | 21225 | 210 | 1 |
529124 | 529124 | 2020-09-13 | Union | Louisiana | 22111 | 909 | 41 |
529435 | 529435 | 2020-09-13 | Union | Mississippi | 28145 | 952 | 23 |
529753 | 529753 | 2020-09-13 | Union | New Jersey | 34039 | 17481 | 1355 |
529787 | 529787 | 2020-09-13 | Union | New Mexico | 35059 | 32 | 2 |
529937 | 529937 | 2020-09-13 | Union | North Carolina | 37179 | 4371 | 56 |
530084 | 530084 | 2020-09-13 | Union | Ohio | 39159 | 437 | 2 |
530201 | 530201 | 2020-09-13 | Union | Oregon | 41061 | 431 | 2 |
530265 | 530265 | 2020-09-13 | Union | Pennsylvania | 42119 | 425 | 6 |
530401 | 530401 | 2020-09-13 | Union | South Carolina | 45087 | 507 | 10 |
530466 | 530466 | 2020-09-13 | Union | South Dakota | 46127 | 319 | 5 |
530556 | 530556 | 2020-09-13 | Union | Tennessee | 47173 | 272 | 1 |
524894 | 524894 | 2020-09-12 | Union | Arkansas | 5139 | 785 | 25 |
525098 | 525098 | 2020-09-12 | Union | Florida | 12125 | 790 | 7 |
525247 | 525247 | 2020-09-12 | Union | Georgia | 13291 | 599 | 17 |
525403 | 525403 | 2020-09-12 | Union | Illinois | 17181 | 464 | 24 |
525496 | 525496 | 2020-09-12 | Union | Indiana | 18161 | 96 | 0 |
525595 | 525595 | 2020-09-12 | Union | Iowa | 19175 | 104 | 3 |
525825 | 525825 | 2020-09-12 | Union | Kentucky | 21225 | 202 | 1 |
525888 | 525888 | 2020-09-12 | Union | Louisiana | 22111 | 898 | 41 |
526199 | 526199 | 2020-09-12 | Union | Mississippi | 28145 | 951 | 23 |
526517 | 526517 | 2020-09-12 | Union | New Jersey | 34039 | 17465 | 1354 |
526551 | 526551 | 2020-09-12 | Union | New Mexico | 35059 | 32 | 2 |
526700 | 526700 | 2020-09-12 | Union | North Carolina | 37179 | 4371 | 56 |
526847 | 526847 | 2020-09-12 | Union | Ohio | 39159 | 435 | 2 |
526964 | 526964 | 2020-09-12 | Union | Oregon | 41061 | 431 | 2 |
527028 | 527028 | 2020-09-12 | Union | Pennsylvania | 42119 | 425 | 6 |
527164 | 527164 | 2020-09-12 | Union | South Carolina | 45087 | 505 | 10 |
527229 | 527229 | 2020-09-12 | Union | South Dakota | 46127 | 318 | 5 |
527319 | 527319 | 2020-09-12 | Union | Tennessee | 47173 | 268 | 1 |
521658 | 521658 | 2020-09-11 | Union | Arkansas | 5139 | 770 | 25 |
521862 | 521862 | 2020-09-11 | Union | Florida | 12125 | 779 | 6 |
522011 | 522011 | 2020-09-11 | Union | Georgia | 13291 | 582 | 16 |
522167 | 522167 | 2020-09-11 | Union | Illinois | 17181 | 460 | 24 |
522260 | 522260 | 2020-09-11 | Union | Indiana | 18161 | 95 | 0 |
522359 | 522359 | 2020-09-11 | Union | Iowa | 19175 | 96 | 3 |
522589 | 522589 | 2020-09-11 | Union | Kentucky | 21225 | 195 | 1 |
522652 | 522652 | 2020-09-11 | Union | Louisiana | 22111 | 898 | 41 |
522963 | 522963 | 2020-09-11 | Union | Mississippi | 28145 | 943 | 23 |
523281 | 523281 | 2020-09-11 | Union | New Jersey | 34039 | 17452 | 1354 |
523315 | 523315 | 2020-09-11 | Union | New Mexico | 35059 | 32 | 2 |
523464 | 523464 | 2020-09-11 | Union | North Carolina | 37179 | 4371 | 56 |
523611 | 523611 | 2020-09-11 | Union | Ohio | 39159 | 430 | 2 |
523728 | 523728 | 2020-09-11 | Union | Oregon | 41061 | 429 | 2 |
523792 | 523792 | 2020-09-11 | Union | Pennsylvania | 42119 | 420 | 6 |
523928 | 523928 | 2020-09-11 | Union | South Carolina | 45087 | 499 | 10 |
523993 | 523993 | 2020-09-11 | Union | South Dakota | 46127 | 302 | 5 |
524083 | 524083 | 2020-09-11 | Union | Tennessee | 47173 | 261 | 1 |
518421 | 518421 | 2020-09-10 | Union | Arkansas | 5139 | 755 | 25 |
518625 | 518625 | 2020-09-10 | Union | Florida | 12125 | 731 | 5 |
518774 | 518774 | 2020-09-10 | Union | Georgia | 13291 | 542 | 16 |
518930 | 518930 | 2020-09-10 | Union | Illinois | 17181 | 455 | 24 |
519023 | 519023 | 2020-09-10 | Union | Indiana | 18161 | 95 | 0 |
519122 | 519122 | 2020-09-10 | Union | Iowa | 19175 | 97 | 3 |
519352 | 519352 | 2020-09-10 | Union | Kentucky | 21225 | 188 | 1 |
519415 | 519415 | 2020-09-10 | Union | Louisiana | 22111 | 896 | 40 |
519726 | 519726 | 2020-09-10 | Union | Mississippi | 28145 | 938 | 23 |
520044 | 520044 | 2020-09-10 | Union | New Jersey | 34039 | 17433 | 1354 |
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);