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 cases
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 |
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 |
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 |
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 |
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 |
10489 | 10489 | 2020-03-24 | Union | Oregon | 41061 | 1 | 0 |
11951 | 11951 | 2020-03-25 | Union | Oregon | 41061 | 1 | 0 |
12041 | 12041 | 2020-03-25 | Union | South Carolina | 45087 | 1 | 0 |
12944 | 12944 | 2020-03-26 | Union | Kentucky | 21225 | 1 | 0 |
13568 | 13568 | 2020-03-26 | Union | Oregon | 41061 | 1 | 0 |
13663 | 13663 | 2020-03-26 | Union | South Carolina | 45087 | 1 | 0 |
14650 | 14650 | 2020-03-27 | Union | Kentucky | 21225 | 1 | 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 |
16467 | 16467 | 2020-03-28 | Union | Kentucky | 21225 | 1 | 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 |
18379 | 18379 | 2020-03-29 | Union | Kentucky | 21225 | 1 | 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 |
20395 | 20395 | 2020-03-30 | Union | Kentucky | 21225 | 1 | 0 |
21149 | 21149 | 2020-03-30 | Union | Oregon | 41061 | 1 | 0 |
21287 | 21287 | 2020-03-30 | Union | South Dakota | 46127 | 1 | 0 |
21358 | 21358 | 2020-03-30 | Union | Tennessee | 47173 | 1 | 0 |
22027 | 22027 | 2020-03-31 | Union | Florida | 12125 | 1 | 0 |
23283 | 23283 | 2020-03-31 | Union | Oregon | 41061 | 1 | 0 |
23425 | 23425 | 2020-03-31 | Union | South Dakota | 46127 | 1 | 0 |
23497 | 23497 | 2020-03-31 | Union | Tennessee | 47173 | 1 | 0 |
24190 | 24190 | 2020-04-01 | Union | Florida | 12125 | 1 | 0 |
24322 | 24322 | 2020-04-01 | Union | Georgia | 13291 | 1 | 0 |
25481 | 25481 | 2020-04-01 | Union | Oregon | 41061 | 1 | 0 |
25623 | 25623 | 2020-04-01 | Union | South Dakota | 46127 | 1 | 0 |
25700 | 25700 | 2020-04-01 | Union | Tennessee | 47173 | 1 | 0 |
26420 | 26420 | 2020-04-02 | Union | Florida | 12125 | 1 | 0 |
26554 | 26554 | 2020-04-02 | Union | Georgia | 13291 | 1 | 0 |
27980 | 27980 | 2020-04-02 | Union | Tennessee | 47173 | 1 | 0 |
28723 | 28723 | 2020-04-03 | Union | Florida | 12125 | 1 | 0 |
28861 | 28861 | 2020-04-03 | Union | Georgia | 13291 | 1 | 0 |
30315 | 30315 | 2020-04-03 | Union | Tennessee | 47173 | 1 | 0 |
31083 | 31083 | 2020-04-04 | Union | Florida | 12125 | 1 | 0 |
31221 | 31221 | 2020-04-04 | Union | Georgia | 13291 | 1 | 0 |
32707 | 32707 | 2020-04-04 | Union | Tennessee | 47173 | 1 | 0 |
33628 | 33628 | 2020-04-05 | Union | Georgia | 13291 | 1 | 0 |
35144 | 35144 | 2020-04-05 | Union | Tennessee | 47173 | 1 | 0 |
36079 | 36079 | 2020-04-06 | Union | Georgia | 13291 | 1 | 0 |
37620 | 37620 | 2020-04-06 | Union | Tennessee | 47173 | 1 | 0 |
40143 | 40143 | 2020-04-07 | Union | Tennessee | 47173 | 1 | 0 |
46591 | 46591 | 2020-04-10 | Union | Iowa | 19175 | 1 | 0 |
49225 | 49225 | 2020-04-11 | Union | Iowa | 19175 | 1 | 0 |
51889 | 51889 | 2020-04-12 | Union | Iowa | 19175 | 1 | 0 |
54571 | 54571 | 2020-04-13 | Union | Iowa | 19175 | 1 | 0 |
57264 | 57264 | 2020-04-14 | Union | Iowa | 19175 | 1 | 0 |
59972 | 59972 | 2020-04-15 | Union | Iowa | 19175 | 1 | 0 |
62693 | 62693 | 2020-04-16 | Union | Iowa | 19175 | 1 | 0 |
65427 | 65427 | 2020-04-17 | Union | Iowa | 19175 | 1 | 0 |
68176 | 68176 | 2020-04-18 | Union | Iowa | 19175 | 1 | 0 |
70938 | 70938 | 2020-04-19 | Union | Iowa | 19175 | 1 | 0 |
73709 | 73709 | 2020-04-20 | Union | Iowa | 19175 | 1 | 0 |
76488 | 76488 | 2020-04-21 | Union | Iowa | 19175 | 1 | 0 |
79272 | 79272 | 2020-04-22 | Union | Iowa | 19175 | 1 | 0 |
82065 | 82065 | 2020-04-23 | Union | Iowa | 19175 | 1 | 0 |
84865 | 84865 | 2020-04-24 | Union | Iowa | 19175 | 1 | 0 |
87675 | 87675 | 2020-04-25 | Union | Iowa | 19175 | 1 | 0 |
88493 | 88493 | 2020-04-25 | Union | New Mexico | 35059 | 1 | 0 |
90491 | 90491 | 2020-04-26 | Union | Iowa | 19175 | 1 | 0 |
93311 | 93311 | 2020-04-27 | Union | Iowa | 19175 | 1 | 0 |
96143 | 96143 | 2020-04-28 | Union | Iowa | 19175 | 1 | 0 |
98988 | 98988 | 2020-04-29 | Union | Iowa | 19175 | 1 | 0 |
101839 | 101839 | 2020-04-30 | Union | Iowa | 19175 | 1 | 0 |
104698 | 104698 | 2020-05-01 | Union | Iowa | 19175 | 1 | 0 |
107563 | 107563 | 2020-05-02 | Union | Iowa | 19175 | 1 | 0 |
110434 | 110434 | 2020-05-03 | Union | Iowa | 19175 | 1 | 0 |
113309 | 113309 | 2020-05-04 | Union | Iowa | 19175 | 1 | 0 |
116192 | 116192 | 2020-05-05 | Union | Iowa | 19175 | 1 | 0 |
119152 | 119152 | 2020-05-06 | Union | Iowa | 19175 | 1 | 0 |
122122 | 122122 | 2020-05-07 | Union | Iowa | 19175 | 1 | 0 |
125104 | 125104 | 2020-05-08 | Union | Iowa | 19175 | 1 | 0 |
128091 | 128091 | 2020-05-09 | Union | Iowa | 19175 | 1 | 0 |
131082 | 131082 | 2020-05-10 | Union | Iowa | 19175 | 1 | 0 |
143051 | 143051 | 2020-05-14 | Union | Iowa | 19175 | 1 | 0 |
146051 | 146051 | 2020-05-15 | Union | Iowa | 19175 | 1 | 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);