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 county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 18
- New Jersey 796
- Ohio 785
- Oregon 785
- Mississippi 784
- North Carolina 783
- Arkansas 781
- Louisiana 780
- South Carolina 780
- Kentucky 779
- South Dakota 778
- Tennessee 777
- Pennsylvania 775
- Florida 774
- Georgia 773
- Indiana 770
- Iowa 764
- Illinois 759
- New Mexico 749
fips 18
county 1
- Union · 13,972 ✖
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
946 | 946 | 2020-03-09 | Union | New Jersey | 34039 | 1 | 0 |
1097 | 1097 | 2020-03-10 | Union | New Jersey | 34039 | 1 | 0 |
1280 | 1280 | 2020-03-11 | Union | New Jersey | 34039 | 1 | 0 |
1511 | 1511 | 2020-03-12 | Union | New Jersey | 34039 | 1 | 0 |
1804 | 1804 | 2020-03-13 | Union | New Jersey | 34039 | 1 | 0 |
2151 | 2151 | 2020-03-14 | Union | New Jersey | 34039 | 1 | 0 |
2559 | 2559 | 2020-03-15 | Union | New Jersey | 34039 | 4 | 0 |
3017 | 3017 | 2020-03-16 | Union | New Jersey | 34039 | 8 | 0 |
3530 | 3530 | 2020-03-17 | Union | New Jersey | 34039 | 22 | 0 |
4126 | 4126 | 2020-03-18 | Union | New Jersey | 34039 | 26 | 0 |
4854 | 4854 | 2020-03-19 | Union | New Jersey | 34039 | 29 | 0 |
5698 | 5698 | 2020-03-20 | Union | New Jersey | 34039 | 43 | 0 |
5814 | 5814 | 2020-03-20 | Union | Ohio | 39159 | 1 | 0 |
5843 | 5843 | 2020-03-20 | Union | Oregon | 41061 | 1 | 0 |
6615 | 6615 | 2020-03-21 | Union | Mississippi | 28145 | 1 | 0 |
6691 | 6691 | 2020-03-21 | Union | New Jersey | 34039 | 81 | 0 |
6815 | 6815 | 2020-03-21 | Union | Ohio | 39159 | 1 | 0 |
6845 | 6845 | 2020-03-21 | Union | Oregon | 41061 | 1 | 0 |
7703 | 7703 | 2020-03-22 | Union | Mississippi | 28145 | 1 | 0 |
7783 | 7783 | 2020-03-22 | Union | New Jersey | 34039 | 124 | 0 |
7879 | 7879 | 2020-03-22 | Union | North Carolina | 37179 | 9 | 0 |
7927 | 7927 | 2020-03-22 | Union | Ohio | 39159 | 1 | 0 |
7960 | 7960 | 2020-03-22 | Union | Oregon | 41061 | 1 | 0 |
8886 | 8886 | 2020-03-23 | Union | Mississippi | 28145 | 1 | 0 |
8979 | 8979 | 2020-03-23 | Union | New Jersey | 34039 | 189 | 1 |
9080 | 9080 | 2020-03-23 | Union | North Carolina | 37179 | 12 | 0 |
9134 | 9134 | 2020-03-23 | Union | Ohio | 39159 | 1 | 0 |
9170 | 9170 | 2020-03-23 | Union | Oregon | 41061 | 1 | 0 |
9557 | 9557 | 2020-03-24 | Union | Arkansas | 5139 | 1 | 0 |
10184 | 10184 | 2020-03-24 | Union | Mississippi | 28145 | 1 | 0 |
10283 | 10283 | 2020-03-24 | Union | New Jersey | 34039 | 246 | 2 |
10391 | 10391 | 2020-03-24 | Union | North Carolina | 37179 | 13 | 0 |
10450 | 10450 | 2020-03-24 | Union | Ohio | 39159 | 2 | 0 |
10489 | 10489 | 2020-03-24 | Union | Oregon | 41061 | 1 | 0 |
10928 | 10928 | 2020-03-25 | Union | Arkansas | 5139 | 2 | 0 |
11416 | 11416 | 2020-03-25 | Union | Louisiana | 22111 | 2 | 0 |
11605 | 11605 | 2020-03-25 | Union | Mississippi | 28145 | 2 | 0 |
11715 | 11715 | 2020-03-25 | Union | New Jersey | 34039 | 262 | 3 |
11836 | 11836 | 2020-03-25 | Union | North Carolina | 37179 | 16 | 0 |
11902 | 11902 | 2020-03-25 | Union | Ohio | 39159 | 3 | 0 |
11951 | 11951 | 2020-03-25 | Union | Oregon | 41061 | 1 | 0 |
12041 | 12041 | 2020-03-25 | Union | South Carolina | 45087 | 1 | 0 |
12473 | 12473 | 2020-03-26 | Union | Arkansas | 5139 | 2 | 0 |
12944 | 12944 | 2020-03-26 | Union | Kentucky | 21225 | 1 | 0 |
12995 | 12995 | 2020-03-26 | Union | Louisiana | 22111 | 2 | 0 |
13199 | 13199 | 2020-03-26 | Union | Mississippi | 28145 | 2 | 0 |
13318 | 13318 | 2020-03-26 | Union | New Jersey | 34039 | 432 | 3 |
13440 | 13440 | 2020-03-26 | Union | North Carolina | 37179 | 24 | 0 |
13511 | 13511 | 2020-03-26 | Union | Ohio | 39159 | 3 | 0 |
13568 | 13568 | 2020-03-26 | Union | Oregon | 41061 | 1 | 0 |
13663 | 13663 | 2020-03-26 | Union | South Carolina | 45087 | 1 | 0 |
14137 | 14137 | 2020-03-27 | Union | Arkansas | 5139 | 2 | 0 |
14650 | 14650 | 2020-03-27 | Union | Kentucky | 21225 | 1 | 0 |
14702 | 14702 | 2020-03-27 | Union | Louisiana | 22111 | 4 | 0 |
14919 | 14919 | 2020-03-27 | Union | Mississippi | 28145 | 3 | 0 |
15050 | 15050 | 2020-03-27 | Union | New Jersey | 34039 | 519 | 3 |
15177 | 15177 | 2020-03-27 | Union | North Carolina | 37179 | 27 | 0 |
15250 | 15250 | 2020-03-27 | Union | Ohio | 39159 | 3 | 0 |
15314 | 15314 | 2020-03-27 | Union | Oregon | 41061 | 1 | 0 |
15410 | 15410 | 2020-03-27 | Union | South Carolina | 45087 | 1 | 0 |
15431 | 15431 | 2020-03-27 | Union | South Dakota | 46127 | 1 | 0 |
15918 | 15918 | 2020-03-28 | Union | Arkansas | 5139 | 5 | 0 |
16467 | 16467 | 2020-03-28 | Union | Kentucky | 21225 | 1 | 0 |
16522 | 16522 | 2020-03-28 | Union | Louisiana | 22111 | 7 | 0 |
16743 | 16743 | 2020-03-28 | Union | Mississippi | 28145 | 3 | 0 |
16879 | 16879 | 2020-03-28 | Union | New Jersey | 34039 | 742 | 10 |
17011 | 17011 | 2020-03-28 | Union | North Carolina | 37179 | 30 | 0 |
17094 | 17094 | 2020-03-28 | Union | Ohio | 39159 | 3 | 0 |
17161 | 17161 | 2020-03-28 | Union | Oregon | 41061 | 1 | 0 |
17265 | 17265 | 2020-03-28 | Union | South Carolina | 45087 | 1 | 0 |
17289 | 17289 | 2020-03-28 | Union | South Dakota | 46127 | 1 | 0 |
17351 | 17351 | 2020-03-28 | Union | Tennessee | 47173 | 1 | 0 |
17807 | 17807 | 2020-03-29 | Union | Arkansas | 5139 | 6 | 0 |
18379 | 18379 | 2020-03-29 | Union | Kentucky | 21225 | 1 | 0 |
18436 | 18436 | 2020-03-29 | Union | Louisiana | 22111 | 9 | 0 |
18665 | 18665 | 2020-03-29 | Union | Mississippi | 28145 | 3 | 0 |
18803 | 18803 | 2020-03-29 | Union | New Jersey | 34039 | 896 | 10 |
18943 | 18943 | 2020-03-29 | Union | North Carolina | 37179 | 38 | 0 |
19028 | 19028 | 2020-03-29 | Union | Ohio | 39159 | 3 | 0 |
19099 | 19099 | 2020-03-29 | Union | Oregon | 41061 | 1 | 0 |
19205 | 19205 | 2020-03-29 | Union | South Carolina | 45087 | 1 | 0 |
19234 | 19234 | 2020-03-29 | Union | South Dakota | 46127 | 1 | 0 |
19301 | 19301 | 2020-03-29 | Union | Tennessee | 47173 | 1 | 0 |
19783 | 19783 | 2020-03-30 | Union | Arkansas | 5139 | 8 | 0 |
20395 | 20395 | 2020-03-30 | Union | Kentucky | 21225 | 1 | 0 |
20452 | 20452 | 2020-03-30 | Union | Louisiana | 22111 | 9 | 0 |
20689 | 20689 | 2020-03-30 | Union | Mississippi | 28145 | 3 | 0 |
20841 | 20841 | 2020-03-30 | Union | New Jersey | 34039 | 1213 | 15 |
20984 | 20984 | 2020-03-30 | Union | North Carolina | 37179 | 38 | 0 |
21075 | 21075 | 2020-03-30 | Union | Ohio | 39159 | 4 | 0 |
21149 | 21149 | 2020-03-30 | Union | Oregon | 41061 | 1 | 0 |
21205 | 21205 | 2020-03-30 | Union | Pennsylvania | 42119 | 4 | 0 |
21257 | 21257 | 2020-03-30 | Union | South Carolina | 45087 | 3 | 0 |
21287 | 21287 | 2020-03-30 | Union | South Dakota | 46127 | 1 | 0 |
21358 | 21358 | 2020-03-30 | Union | Tennessee | 47173 | 1 | 0 |
21857 | 21857 | 2020-03-31 | Union | Arkansas | 5139 | 8 | 0 |
22027 | 22027 | 2020-03-31 | Union | Florida | 12125 | 1 | 0 |
22503 | 22503 | 2020-03-31 | Union | Kentucky | 21225 | 2 | 0 |
22561 | 22561 | 2020-03-31 | Union | Louisiana | 22111 | 9 | 0 |
22807 | 22807 | 2020-03-31 | Union | Mississippi | 28145 | 3 | 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);