ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

13,972 rows where county = "Union" sorted by state

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips 18

county 1

  • Union · 13,972 ✖
Link rowid date county state ▼ cases deaths
9557 9557 2020-03-24 Union Arkansas 1 0
10928 10928 2020-03-25 Union Arkansas 2 0
12473 12473 2020-03-26 Union Arkansas 2 0
14137 14137 2020-03-27 Union Arkansas 2 0
15918 15918 2020-03-28 Union Arkansas 5 0
17807 17807 2020-03-29 Union Arkansas 6 0
19783 19783 2020-03-30 Union Arkansas 8 0
21857 21857 2020-03-31 Union Arkansas 8 0
24015 24015 2020-04-01 Union Arkansas 9 0
26243 26243 2020-04-02 Union Arkansas 10 0
28542 28542 2020-04-03 Union Arkansas 10 0
30900 30900 2020-04-04 Union Arkansas 10 0
33305 33305 2020-04-05 Union Arkansas 12 0
35749 35749 2020-04-06 Union Arkansas 13 0
38238 38238 2020-04-07 Union Arkansas 13 0
40782 40782 2020-04-08 Union Arkansas 15 0
43354 43354 2020-04-09 Union Arkansas 16 0
45954 45954 2020-04-10 Union Arkansas 17 0
48584 48584 2020-04-11 Union Arkansas 18 0
51246 51246 2020-04-12 Union Arkansas 18 0
53925 53925 2020-04-13 Union Arkansas 17 0
56617 56617 2020-04-14 Union Arkansas 17 0
59325 59325 2020-04-15 Union Arkansas 18 0
62044 62044 2020-04-16 Union Arkansas 19 0
64777 64777 2020-04-17 Union Arkansas 20 0
67525 67525 2020-04-18 Union Arkansas 24 0
70287 70287 2020-04-19 Union Arkansas 24 0
73056 73056 2020-04-20 Union Arkansas 26 0
75832 75832 2020-04-21 Union Arkansas 26 0
78616 78616 2020-04-22 Union Arkansas 28 0
81410 81410 2020-04-23 Union Arkansas 29 0
84210 84210 2020-04-24 Union Arkansas 30 0
87018 87018 2020-04-25 Union Arkansas 32 0
89835 89835 2020-04-26 Union Arkansas 33 0
92653 92653 2020-04-27 Union Arkansas 38 0
95484 95484 2020-04-28 Union Arkansas 43 0
98329 98329 2020-04-29 Union Arkansas 45 0
101179 101179 2020-04-30 Union Arkansas 50 0
104034 104034 2020-05-01 Union Arkansas 54 0
106899 106899 2020-05-02 Union Arkansas 54 0
109768 109768 2020-05-03 Union Arkansas 60 0
112643 112643 2020-05-04 Union Arkansas 62 0
115526 115526 2020-05-05 Union Arkansas 62 0
118485 118485 2020-05-06 Union Arkansas 67 1
121452 121452 2020-05-07 Union Arkansas 73 1
124432 124432 2020-05-08 Union Arkansas 73 1
127417 127417 2020-05-09 Union Arkansas 73 1
130407 130407 2020-05-10 Union Arkansas 76 2
133397 133397 2020-05-11 Union Arkansas 76 4
136387 136387 2020-05-12 Union Arkansas 80 4
139378 139378 2020-05-13 Union Arkansas 84 4
142374 142374 2020-05-14 Union Arkansas 105 4
145373 145373 2020-05-15 Union Arkansas 105 4
148377 148377 2020-05-16 Union Arkansas 107 4
151386 151386 2020-05-17 Union Arkansas 107 4
154398 154398 2020-05-18 Union Arkansas 107 4
157414 157414 2020-05-19 Union Arkansas 117 4
160440 160440 2020-05-20 Union Arkansas 121 4
163468 163468 2020-05-21 Union Arkansas 140 4
166500 166500 2020-05-22 Union Arkansas 144 4
169536 169536 2020-05-23 Union Arkansas 152 5
172577 172577 2020-05-24 Union Arkansas 157 6
175621 175621 2020-05-25 Union Arkansas 160 6
178665 178665 2020-05-26 Union Arkansas 162 6
181709 181709 2020-05-27 Union Arkansas 162 6
184763 184763 2020-05-28 Union Arkansas 164 8
187819 187819 2020-05-29 Union Arkansas 166 8
190884 190884 2020-05-30 Union Arkansas 171 8
193951 193951 2020-05-31 Union Arkansas 173 8
197021 197021 2020-06-01 Union Arkansas 173 8
200094 200094 2020-06-02 Union Arkansas 173 9
203170 203170 2020-06-03 Union Arkansas 177 10
206250 206250 2020-06-04 Union Arkansas 179 11
209331 209331 2020-06-05 Union Arkansas 185 11
212416 212416 2020-06-06 Union Arkansas 188 11
215503 215503 2020-06-07 Union Arkansas 188 11
218594 218594 2020-06-08 Union Arkansas 188 11
221689 221689 2020-06-09 Union Arkansas 190 11
224784 224784 2020-06-10 Union Arkansas 190 11
227886 227886 2020-06-11 Union Arkansas 194 11
230989 230989 2020-06-12 Union Arkansas 199 11
234095 234095 2020-06-13 Union Arkansas 202 11
237202 237202 2020-06-14 Union Arkansas 203 11
240310 240310 2020-06-15 Union Arkansas 208 11
243421 243421 2020-06-16 Union Arkansas 209 11
246534 246534 2020-06-17 Union Arkansas 213 11
249646 249646 2020-06-18 Union Arkansas 218 13
252761 252761 2020-06-19 Union Arkansas 220 13
255880 255880 2020-06-20 Union Arkansas 223 13
259007 259007 2020-06-21 Union Arkansas 224 13
262134 262134 2020-06-22 Union Arkansas 227 13
265262 265262 2020-06-23 Union Arkansas 232 13
268392 268392 2020-06-24 Union Arkansas 232 13
271527 271527 2020-06-25 Union Arkansas 237 13
274667 274667 2020-06-26 Union Arkansas 243 13
277815 277815 2020-06-27 Union Arkansas 245 13
280962 280962 2020-06-28 Union Arkansas 245 13
284108 284108 2020-06-29 Union Arkansas 247 13
287254 287254 2020-06-30 Union Arkansas 248 13
290405 290405 2020-07-01 Union Arkansas 249 13

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);