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 deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 18
- New Jersey 782
- Florida 773
- Georgia 773
- Kentucky 773
- Louisiana 773
- Mississippi 773
- North Carolina 773
- Ohio 773
- Oregon 773
- Pennsylvania 773
- South Carolina 773
- South Dakota 773
- Tennessee 773
- Arkansas 772
- Indiana 770
- Iowa 764
- Illinois 759
- New Mexico 749
fips 18
county 1
- Union · 13,872 ✖
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
24190 | 24190 | 2020-04-01 | Union | Florida | 12125 | 1 | 0 |
24322 | 24322 | 2020-04-01 | Union | Georgia | 13291 | 1 | 0 |
24679 | 24679 | 2020-04-01 | Union | Kentucky | 21225 | 2 | 0 |
24737 | 24737 | 2020-04-01 | Union | Louisiana | 22111 | 11 | 0 |
24991 | 24991 | 2020-04-01 | Union | Mississippi | 28145 | 3 | 0 |
25306 | 25306 | 2020-04-01 | Union | North Carolina | 37179 | 47 | 0 |
25404 | 25404 | 2020-04-01 | Union | Ohio | 39159 | 4 | 0 |
25481 | 25481 | 2020-04-01 | Union | Oregon | 41061 | 1 | 0 |
25539 | 25539 | 2020-04-01 | Union | Pennsylvania | 42119 | 4 | 0 |
25593 | 25593 | 2020-04-01 | Union | South Carolina | 45087 | 3 | 0 |
25623 | 25623 | 2020-04-01 | Union | South Dakota | 46127 | 1 | 0 |
25700 | 25700 | 2020-04-01 | Union | Tennessee | 47173 | 1 | 0 |
26243 | 26243 | 2020-04-02 | Union | Arkansas | 5139 | 10 | 0 |
26420 | 26420 | 2020-04-02 | Union | Florida | 12125 | 1 | 0 |
26554 | 26554 | 2020-04-02 | Union | Georgia | 13291 | 1 | 0 |
26929 | 26929 | 2020-04-02 | Union | Kentucky | 21225 | 2 | 0 |
26988 | 26988 | 2020-04-02 | Union | Louisiana | 22111 | 13 | 0 |
27245 | 27245 | 2020-04-02 | Union | Mississippi | 28145 | 4 | 0 |
27572 | 27572 | 2020-04-02 | Union | North Carolina | 37179 | 55 | 0 |
27672 | 27672 | 2020-04-02 | Union | Ohio | 39159 | 4 | 0 |
27753 | 27753 | 2020-04-02 | Union | Oregon | 41061 | 3 | 0 |
27812 | 27812 | 2020-04-02 | Union | Pennsylvania | 42119 | 4 | 0 |
27869 | 27869 | 2020-04-02 | Union | South Carolina | 45087 | 5 | 0 |
27901 | 27901 | 2020-04-02 | Union | South Dakota | 46127 | 3 | 0 |
27980 | 27980 | 2020-04-02 | Union | Tennessee | 47173 | 1 | 0 |
28542 | 28542 | 2020-04-03 | Union | Arkansas | 5139 | 10 | 0 |
28723 | 28723 | 2020-04-03 | Union | Florida | 12125 | 1 | 0 |
28861 | 28861 | 2020-04-03 | Union | Georgia | 13291 | 1 | 0 |
29245 | 29245 | 2020-04-03 | Union | Kentucky | 21225 | 2 | 0 |
29305 | 29305 | 2020-04-03 | Union | Louisiana | 22111 | 17 | 0 |
29564 | 29564 | 2020-04-03 | Union | Mississippi | 28145 | 5 | 0 |
29899 | 29899 | 2020-04-03 | Union | North Carolina | 37179 | 60 | 0 |
30001 | 30001 | 2020-04-03 | Union | Ohio | 39159 | 5 | 0 |
30086 | 30086 | 2020-04-03 | Union | Oregon | 41061 | 3 | 0 |
30146 | 30146 | 2020-04-03 | Union | Pennsylvania | 42119 | 4 | 0 |
30204 | 30204 | 2020-04-03 | Union | South Carolina | 45087 | 6 | 0 |
30236 | 30236 | 2020-04-03 | Union | South Dakota | 46127 | 3 | 0 |
30315 | 30315 | 2020-04-03 | Union | Tennessee | 47173 | 1 | 0 |
30900 | 30900 | 2020-04-04 | Union | Arkansas | 5139 | 10 | 0 |
31083 | 31083 | 2020-04-04 | Union | Florida | 12125 | 1 | 0 |
31221 | 31221 | 2020-04-04 | Union | Georgia | 13291 | 1 | 0 |
31419 | 31419 | 2020-04-04 | Union | Indiana | 18161 | 2 | 0 |
31623 | 31623 | 2020-04-04 | Union | Kentucky | 21225 | 2 | 0 |
31683 | 31683 | 2020-04-04 | Union | Louisiana | 22111 | 19 | 0 |
31944 | 31944 | 2020-04-04 | Union | Mississippi | 28145 | 6 | 0 |
32286 | 32286 | 2020-04-04 | Union | North Carolina | 37179 | 67 | 0 |
32390 | 32390 | 2020-04-04 | Union | Ohio | 39159 | 7 | 0 |
32476 | 32476 | 2020-04-04 | Union | Oregon | 41061 | 3 | 0 |
32537 | 32537 | 2020-04-04 | Union | Pennsylvania | 42119 | 5 | 0 |
32595 | 32595 | 2020-04-04 | Union | South Carolina | 45087 | 9 | 0 |
32627 | 32627 | 2020-04-04 | Union | South Dakota | 46127 | 3 | 0 |
32707 | 32707 | 2020-04-04 | Union | Tennessee | 47173 | 1 | 0 |
33305 | 33305 | 2020-04-05 | Union | Arkansas | 5139 | 12 | 0 |
33489 | 33489 | 2020-04-05 | Union | Florida | 12125 | 2 | 0 |
33628 | 33628 | 2020-04-05 | Union | Georgia | 13291 | 1 | 0 |
33830 | 33830 | 2020-04-05 | Union | Indiana | 18161 | 3 | 0 |
34048 | 34048 | 2020-04-05 | Union | Kentucky | 21225 | 4 | 0 |
34108 | 34108 | 2020-04-05 | Union | Louisiana | 22111 | 19 | 0 |
34372 | 34372 | 2020-04-05 | Union | Mississippi | 28145 | 6 | 0 |
34718 | 34718 | 2020-04-05 | Union | North Carolina | 37179 | 67 | 0 |
34824 | 34824 | 2020-04-05 | Union | Ohio | 39159 | 8 | 0 |
34911 | 34911 | 2020-04-05 | Union | Oregon | 41061 | 3 | 0 |
34973 | 34973 | 2020-04-05 | Union | Pennsylvania | 42119 | 6 | 0 |
35031 | 35031 | 2020-04-05 | Union | South Carolina | 45087 | 11 | 0 |
35063 | 35063 | 2020-04-05 | Union | South Dakota | 46127 | 3 | 0 |
35144 | 35144 | 2020-04-05 | Union | Tennessee | 47173 | 1 | 0 |
35749 | 35749 | 2020-04-06 | Union | Arkansas | 5139 | 13 | 0 |
35935 | 35935 | 2020-04-06 | Union | Florida | 12125 | 2 | 0 |
36079 | 36079 | 2020-04-06 | Union | Georgia | 13291 | 1 | 0 |
36284 | 36284 | 2020-04-06 | Union | Indiana | 18161 | 3 | 0 |
36506 | 36506 | 2020-04-06 | Union | Kentucky | 21225 | 4 | 0 |
36566 | 36566 | 2020-04-06 | Union | Louisiana | 22111 | 26 | 0 |
36835 | 36835 | 2020-04-06 | Union | Mississippi | 28145 | 6 | 0 |
37187 | 37187 | 2020-04-06 | Union | North Carolina | 37179 | 75 | 0 |
37297 | 37297 | 2020-04-06 | Union | Ohio | 39159 | 8 | 0 |
37386 | 37386 | 2020-04-06 | Union | Oregon | 41061 | 3 | 0 |
37448 | 37448 | 2020-04-06 | Union | Pennsylvania | 42119 | 6 | 0 |
37506 | 37506 | 2020-04-06 | Union | South Carolina | 45087 | 12 | 0 |
37538 | 37538 | 2020-04-06 | Union | South Dakota | 46127 | 3 | 0 |
37620 | 37620 | 2020-04-06 | Union | Tennessee | 47173 | 1 | 0 |
38238 | 38238 | 2020-04-07 | Union | Arkansas | 5139 | 13 | 0 |
38427 | 38427 | 2020-04-07 | Union | Florida | 12125 | 2 | 0 |
38572 | 38572 | 2020-04-07 | Union | Georgia | 13291 | 4 | 0 |
38782 | 38782 | 2020-04-07 | Union | Indiana | 18161 | 3 | 0 |
39014 | 39014 | 2020-04-07 | Union | Kentucky | 21225 | 4 | 0 |
39074 | 39074 | 2020-04-07 | Union | Louisiana | 22111 | 33 | 0 |
39346 | 39346 | 2020-04-07 | Union | Mississippi | 28145 | 6 | 0 |
39703 | 39703 | 2020-04-07 | Union | North Carolina | 37179 | 83 | 0 |
39815 | 39815 | 2020-04-07 | Union | Ohio | 39159 | 8 | 0 |
39907 | 39907 | 2020-04-07 | Union | Oregon | 41061 | 3 | 0 |
39971 | 39971 | 2020-04-07 | Union | Pennsylvania | 42119 | 7 | 0 |
40029 | 40029 | 2020-04-07 | Union | South Carolina | 45087 | 15 | 0 |
40061 | 40061 | 2020-04-07 | Union | South Dakota | 46127 | 3 | 0 |
40143 | 40143 | 2020-04-07 | Union | Tennessee | 47173 | 1 | 0 |
40782 | 40782 | 2020-04-08 | Union | Arkansas | 5139 | 15 | 0 |
40971 | 40971 | 2020-04-08 | Union | Florida | 12125 | 2 | 0 |
41116 | 41116 | 2020-04-08 | Union | Georgia | 13291 | 5 | 0 |
41328 | 41328 | 2020-04-08 | Union | Indiana | 18161 | 5 | 0 |
41564 | 41564 | 2020-04-08 | Union | Kentucky | 21225 | 4 | 0 |
41900 | 41900 | 2020-04-08 | Union | Mississippi | 28145 | 6 | 0 |
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);