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 216
- Ohio 206
- Oregon 206
- Mississippi 204
- North Carolina 204
- Arkansas 201
- South Carolina 201
- Louisiana 200
- Kentucky 199
- South Dakota 199
- Tennessee 198
- Pennsylvania 196
- Florida 194
- Georgia 193
- Indiana 190
- Iowa 184
- Illinois 179
- New Mexico 170
fips 18
county 1
- Union · 3,540 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
620508 | 620508 | 2020-10-11 | Union | New Mexico | 35059 | 42 | 2 |
620657 | 620657 | 2020-10-11 | Union | North Carolina | 37179 | 5347 | 60 |
620803 | 620803 | 2020-10-11 | Union | Ohio | 39159 | 660 | 2 |
620920 | 620920 | 2020-10-11 | Union | Oregon | 41061 | 451 | 2 |
620985 | 620985 | 2020-10-11 | Union | Pennsylvania | 42119 | 600 | 7 |
621121 | 621121 | 2020-10-11 | Union | South Carolina | 45087 | 655 | 15 |
621186 | 621186 | 2020-10-11 | Union | South Dakota | 46127 | 555 | 10 |
621276 | 621276 | 2020-10-11 | Union | Tennessee | 47173 | 453 | 2 |
615603 | 615603 | 2020-10-10 | Union | Arkansas | 5139 | 1007 | 47 |
615808 | 615808 | 2020-10-10 | Union | Florida | 12125 | 1016 | 24 |
615957 | 615957 | 2020-10-10 | Union | Georgia | 13291 | 845 | 22 |
616113 | 616113 | 2020-10-10 | Union | Illinois | 17181 | 642 | 25 |
616206 | 616206 | 2020-10-10 | Union | Indiana | 18161 | 110 | 0 |
616305 | 616305 | 2020-10-10 | Union | Iowa | 19175 | 177 | 3 |
616535 | 616535 | 2020-10-10 | Union | Kentucky | 21225 | 417 | 5 |
616598 | 616598 | 2020-10-10 | Union | Louisiana | 22111 | 1020 | 46 |
616909 | 616909 | 2020-10-10 | Union | Mississippi | 28145 | 1087 | 24 |
617232 | 617232 | 2020-10-10 | Union | New Jersey | 34039 | 18330 | 1361 |
617266 | 617266 | 2020-10-10 | Union | New Mexico | 35059 | 42 | 2 |
617415 | 617415 | 2020-10-10 | Union | North Carolina | 37179 | 5324 | 60 |
617561 | 617561 | 2020-10-10 | Union | Ohio | 39159 | 647 | 2 |
617678 | 617678 | 2020-10-10 | Union | Oregon | 41061 | 451 | 2 |
617742 | 617742 | 2020-10-10 | Union | Pennsylvania | 42119 | 597 | 7 |
617878 | 617878 | 2020-10-10 | Union | South Carolina | 45087 | 650 | 15 |
617943 | 617943 | 2020-10-10 | Union | South Dakota | 46127 | 539 | 10 |
618033 | 618033 | 2020-10-10 | Union | Tennessee | 47173 | 448 | 2 |
612362 | 612362 | 2020-10-09 | Union | Arkansas | 5139 | 1002 | 47 |
612567 | 612567 | 2020-10-09 | Union | Florida | 12125 | 1016 | 24 |
612716 | 612716 | 2020-10-09 | Union | Georgia | 13291 | 843 | 22 |
612872 | 612872 | 2020-10-09 | Union | Illinois | 17181 | 618 | 24 |
612965 | 612965 | 2020-10-09 | Union | Indiana | 18161 | 110 | 0 |
613064 | 613064 | 2020-10-09 | Union | Iowa | 19175 | 177 | 3 |
613294 | 613294 | 2020-10-09 | Union | Kentucky | 21225 | 406 | 3 |
613357 | 613357 | 2020-10-09 | Union | Louisiana | 22111 | 1020 | 46 |
613668 | 613668 | 2020-10-09 | Union | Mississippi | 28145 | 1073 | 24 |
613990 | 613990 | 2020-10-09 | Union | New Jersey | 34039 | 18276 | 1360 |
614024 | 614024 | 2020-10-09 | Union | New Mexico | 35059 | 42 | 2 |
614173 | 614173 | 2020-10-09 | Union | North Carolina | 37179 | 5277 | 60 |
614319 | 614319 | 2020-10-09 | Union | Ohio | 39159 | 644 | 2 |
614436 | 614436 | 2020-10-09 | Union | Oregon | 41061 | 451 | 2 |
614500 | 614500 | 2020-10-09 | Union | Pennsylvania | 42119 | 586 | 7 |
614636 | 614636 | 2020-10-09 | Union | South Carolina | 45087 | 644 | 14 |
614701 | 614701 | 2020-10-09 | Union | South Dakota | 46127 | 526 | 10 |
614791 | 614791 | 2020-10-09 | Union | Tennessee | 47173 | 444 | 2 |
609120 | 609120 | 2020-10-08 | Union | Arkansas | 5139 | 983 | 47 |
609325 | 609325 | 2020-10-08 | Union | Florida | 12125 | 1012 | 23 |
609474 | 609474 | 2020-10-08 | Union | Georgia | 13291 | 837 | 21 |
609630 | 609630 | 2020-10-08 | Union | Illinois | 17181 | 607 | 24 |
609723 | 609723 | 2020-10-08 | Union | Indiana | 18161 | 110 | 0 |
609822 | 609822 | 2020-10-08 | Union | Iowa | 19175 | 174 | 3 |
610052 | 610052 | 2020-10-08 | Union | Kentucky | 21225 | 399 | 3 |
610115 | 610115 | 2020-10-08 | Union | Louisiana | 22111 | 1019 | 46 |
610426 | 610426 | 2020-10-08 | Union | Mississippi | 28145 | 1068 | 24 |
610749 | 610749 | 2020-10-08 | Union | New Jersey | 34039 | 18228 | 1360 |
610783 | 610783 | 2020-10-08 | Union | New Mexico | 35059 | 39 | 2 |
610932 | 610932 | 2020-10-08 | Union | North Carolina | 37179 | 5232 | 59 |
611078 | 611078 | 2020-10-08 | Union | Ohio | 39159 | 627 | 2 |
611195 | 611195 | 2020-10-08 | Union | Oregon | 41061 | 449 | 2 |
611259 | 611259 | 2020-10-08 | Union | Pennsylvania | 42119 | 577 | 7 |
611395 | 611395 | 2020-10-08 | Union | South Carolina | 45087 | 634 | 14 |
611460 | 611460 | 2020-10-08 | Union | South Dakota | 46127 | 514 | 10 |
611550 | 611550 | 2020-10-08 | Union | Tennessee | 47173 | 437 | 2 |
605877 | 605877 | 2020-10-07 | Union | Arkansas | 5139 | 960 | 47 |
606082 | 606082 | 2020-10-07 | Union | Florida | 12125 | 1009 | 23 |
606231 | 606231 | 2020-10-07 | Union | Georgia | 13291 | 836 | 21 |
606387 | 606387 | 2020-10-07 | Union | Illinois | 17181 | 597 | 24 |
606480 | 606480 | 2020-10-07 | Union | Indiana | 18161 | 109 | 0 |
606579 | 606579 | 2020-10-07 | Union | Iowa | 19175 | 160 | 3 |
606810 | 606810 | 2020-10-07 | Union | Kentucky | 21225 | 392 | 3 |
606873 | 606873 | 2020-10-07 | Union | Louisiana | 22111 | 1015 | 46 |
607184 | 607184 | 2020-10-07 | Union | Mississippi | 28145 | 1065 | 24 |
607507 | 607507 | 2020-10-07 | Union | New Jersey | 34039 | 18145 | 1361 |
607541 | 607541 | 2020-10-07 | Union | New Mexico | 35059 | 34 | 2 |
607690 | 607690 | 2020-10-07 | Union | North Carolina | 37179 | 5200 | 59 |
607836 | 607836 | 2020-10-07 | Union | Ohio | 39159 | 618 | 2 |
607953 | 607953 | 2020-10-07 | Union | Oregon | 41061 | 447 | 2 |
608017 | 608017 | 2020-10-07 | Union | Pennsylvania | 42119 | 576 | 7 |
608153 | 608153 | 2020-10-07 | Union | South Carolina | 45087 | 631 | 14 |
608218 | 608218 | 2020-10-07 | Union | South Dakota | 46127 | 485 | 10 |
608308 | 608308 | 2020-10-07 | Union | Tennessee | 47173 | 429 | 2 |
602635 | 602635 | 2020-10-06 | Union | Arkansas | 5139 | 948 | 47 |
602840 | 602840 | 2020-10-06 | Union | Florida | 12125 | 1001 | 23 |
602989 | 602989 | 2020-10-06 | Union | Georgia | 13291 | 825 | 21 |
603145 | 603145 | 2020-10-06 | Union | Illinois | 17181 | 585 | 24 |
603238 | 603238 | 2020-10-06 | Union | Indiana | 18161 | 108 | 0 |
603337 | 603337 | 2020-10-06 | Union | Iowa | 19175 | 158 | 3 |
603568 | 603568 | 2020-10-06 | Union | Kentucky | 21225 | 388 | 3 |
603631 | 603631 | 2020-10-06 | Union | Louisiana | 22111 | 1011 | 46 |
603941 | 603941 | 2020-10-06 | Union | Mississippi | 28145 | 1062 | 24 |
604264 | 604264 | 2020-10-06 | Union | New Jersey | 34039 | 18111 | 1360 |
604298 | 604298 | 2020-10-06 | Union | New Mexico | 35059 | 33 | 2 |
604447 | 604447 | 2020-10-06 | Union | North Carolina | 37179 | 5141 | 59 |
604593 | 604593 | 2020-10-06 | Union | Ohio | 39159 | 606 | 2 |
604710 | 604710 | 2020-10-06 | Union | Oregon | 41061 | 447 | 2 |
604774 | 604774 | 2020-10-06 | Union | Pennsylvania | 42119 | 571 | 7 |
604910 | 604910 | 2020-10-06 | Union | South Carolina | 45087 | 628 | 13 |
604975 | 604975 | 2020-10-06 | Union | South Dakota | 46127 | 462 | 9 |
605065 | 605065 | 2020-10-06 | Union | Tennessee | 47173 | 420 | 2 |
599392 | 599392 | 2020-10-05 | Union | Arkansas | 5139 | 945 | 47 |
599597 | 599597 | 2020-10-05 | Union | Florida | 12125 | 1000 | 18 |
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);