ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Caldwell" and state = "Texas" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
17371 | 17371 | 2020-03-28 | Caldwell | Texas | 48055 | 1 | 0 |
19321 | 19321 | 2020-03-29 | Caldwell | Texas | 48055 | 1 | 0 |
21380 | 21380 | 2020-03-30 | Caldwell | Texas | 48055 | 1 | 0 |
23519 | 23519 | 2020-03-31 | Caldwell | Texas | 48055 | 1 | 0 |
25723 | 25723 | 2020-04-01 | Caldwell | Texas | 48055 | 1 | 0 |
28003 | 28003 | 2020-04-02 | Caldwell | Texas | 48055 | 1 | 0 |
30338 | 30338 | 2020-04-03 | Caldwell | Texas | 48055 | 2 | 0 |
32731 | 32731 | 2020-04-04 | Caldwell | Texas | 48055 | 3 | 0 |
35169 | 35169 | 2020-04-05 | Caldwell | Texas | 48055 | 3 | 0 |
37645 | 37645 | 2020-04-06 | Caldwell | Texas | 48055 | 3 | 0 |
40167 | 40167 | 2020-04-07 | Caldwell | Texas | 48055 | 5 | 0 |
42730 | 42730 | 2020-04-08 | Caldwell | Texas | 48055 | 5 | 0 |
45319 | 45319 | 2020-04-09 | Caldwell | Texas | 48055 | 5 | 0 |
47937 | 47937 | 2020-04-10 | Caldwell | Texas | 48055 | 6 | 0 |
50594 | 50594 | 2020-04-11 | Caldwell | Texas | 48055 | 6 | 0 |
53269 | 53269 | 2020-04-12 | Caldwell | Texas | 48055 | 6 | 0 |
55957 | 55957 | 2020-04-13 | Caldwell | Texas | 48055 | 6 | 0 |
58661 | 58661 | 2020-04-14 | Caldwell | Texas | 48055 | 6 | 0 |
61378 | 61378 | 2020-04-15 | Caldwell | Texas | 48055 | 6 | 0 |
64105 | 64105 | 2020-04-16 | Caldwell | Texas | 48055 | 7 | 0 |
66852 | 66852 | 2020-04-17 | Caldwell | Texas | 48055 | 7 | 0 |
69611 | 69611 | 2020-04-18 | Caldwell | Texas | 48055 | 7 | 0 |
72378 | 72378 | 2020-04-19 | Caldwell | Texas | 48055 | 7 | 0 |
75153 | 75153 | 2020-04-20 | Caldwell | Texas | 48055 | 8 | 0 |
77935 | 77935 | 2020-04-21 | Caldwell | Texas | 48055 | 9 | 0 |
80726 | 80726 | 2020-04-22 | Caldwell | Texas | 48055 | 8 | 0 |
83525 | 83525 | 2020-04-23 | Caldwell | Texas | 48055 | 10 | 0 |
86330 | 86330 | 2020-04-24 | Caldwell | Texas | 48055 | 10 | 0 |
89145 | 89145 | 2020-04-25 | Caldwell | Texas | 48055 | 10 | 0 |
91962 | 91962 | 2020-04-26 | Caldwell | Texas | 48055 | 11 | 0 |
94790 | 94790 | 2020-04-27 | Caldwell | Texas | 48055 | 11 | 0 |
97630 | 97630 | 2020-04-28 | Caldwell | Texas | 48055 | 11 | 0 |
100480 | 100480 | 2020-04-29 | Caldwell | Texas | 48055 | 11 | 0 |
103333 | 103333 | 2020-04-30 | Caldwell | Texas | 48055 | 14 | 0 |
106197 | 106197 | 2020-05-01 | Caldwell | Texas | 48055 | 14 | 0 |
109065 | 109065 | 2020-05-02 | Caldwell | Texas | 48055 | 20 | 0 |
111939 | 111939 | 2020-05-03 | Caldwell | Texas | 48055 | 20 | 0 |
114821 | 114821 | 2020-05-04 | Caldwell | Texas | 48055 | 21 | 0 |
117778 | 117778 | 2020-05-05 | Caldwell | Texas | 48055 | 23 | 0 |
120742 | 120742 | 2020-05-06 | Caldwell | Texas | 48055 | 24 | 0 |
123721 | 123721 | 2020-05-07 | Caldwell | Texas | 48055 | 25 | 0 |
126704 | 126704 | 2020-05-08 | Caldwell | Texas | 48055 | 25 | 0 |
129693 | 129693 | 2020-05-09 | Caldwell | Texas | 48055 | 26 | 0 |
132683 | 132683 | 2020-05-10 | Caldwell | Texas | 48055 | 27 | 0 |
135674 | 135674 | 2020-05-11 | Caldwell | Texas | 48055 | 30 | 0 |
138664 | 138664 | 2020-05-12 | Caldwell | Texas | 48055 | 31 | 0 |
141660 | 141660 | 2020-05-13 | Caldwell | Texas | 48055 | 33 | 0 |
144657 | 144657 | 2020-05-14 | Caldwell | Texas | 48055 | 33 | 0 |
147659 | 147659 | 2020-05-15 | Caldwell | Texas | 48055 | 35 | 0 |
150667 | 150667 | 2020-05-16 | Caldwell | Texas | 48055 | 36 | 0 |
153678 | 153678 | 2020-05-17 | Caldwell | Texas | 48055 | 36 | 0 |
156695 | 156695 | 2020-05-18 | Caldwell | Texas | 48055 | 36 | 0 |
159717 | 159717 | 2020-05-19 | Caldwell | Texas | 48055 | 39 | 0 |
162744 | 162744 | 2020-05-20 | Caldwell | Texas | 48055 | 39 | 0 |
165773 | 165773 | 2020-05-21 | Caldwell | Texas | 48055 | 41 | 0 |
168809 | 168809 | 2020-05-22 | Caldwell | Texas | 48055 | 41 | 0 |
171848 | 171848 | 2020-05-23 | Caldwell | Texas | 48055 | 50 | 0 |
174891 | 174891 | 2020-05-24 | Caldwell | Texas | 48055 | 50 | 0 |
177935 | 177935 | 2020-05-25 | Caldwell | Texas | 48055 | 50 | 0 |
180978 | 180978 | 2020-05-26 | Caldwell | Texas | 48055 | 51 | 0 |
184028 | 184028 | 2020-05-27 | Caldwell | Texas | 48055 | 52 | 0 |
187085 | 187085 | 2020-05-28 | Caldwell | Texas | 48055 | 57 | 0 |
190149 | 190149 | 2020-05-29 | Caldwell | Texas | 48055 | 63 | 0 |
193214 | 193214 | 2020-05-30 | Caldwell | Texas | 48055 | 64 | 0 |
196284 | 196284 | 2020-05-31 | Caldwell | Texas | 48055 | 65 | 0 |
199357 | 199357 | 2020-06-01 | Caldwell | Texas | 48055 | 66 | 0 |
202432 | 202432 | 2020-06-02 | Caldwell | Texas | 48055 | 67 | 0 |
205511 | 205511 | 2020-06-03 | Caldwell | Texas | 48055 | 73 | 0 |
208593 | 208593 | 2020-06-04 | Caldwell | Texas | 48055 | 73 | 0 |
211676 | 211676 | 2020-06-05 | Caldwell | Texas | 48055 | 74 | 0 |
214763 | 214763 | 2020-06-06 | Caldwell | Texas | 48055 | 76 | 0 |
217853 | 217853 | 2020-06-07 | Caldwell | Texas | 48055 | 77 | 0 |
220945 | 220945 | 2020-06-08 | Caldwell | Texas | 48055 | 77 | 0 |
224040 | 224040 | 2020-06-09 | Caldwell | Texas | 48055 | 79 | 0 |
227140 | 227140 | 2020-06-10 | Caldwell | Texas | 48055 | 81 | 0 |
230244 | 230244 | 2020-06-11 | Caldwell | Texas | 48055 | 85 | 0 |
233348 | 233348 | 2020-06-12 | Caldwell | Texas | 48055 | 87 | 0 |
236454 | 236454 | 2020-06-13 | Caldwell | Texas | 48055 | 95 | 0 |
239562 | 239562 | 2020-06-14 | Caldwell | Texas | 48055 | 147 | 0 |
242672 | 242672 | 2020-06-15 | Caldwell | Texas | 48055 | 147 | 0 |
245784 | 245784 | 2020-06-16 | Caldwell | Texas | 48055 | 157 | 0 |
248897 | 248897 | 2020-06-17 | Caldwell | Texas | 48055 | 170 | 1 |
252012 | 252012 | 2020-06-18 | Caldwell | Texas | 48055 | 190 | 1 |
255127 | 255127 | 2020-06-19 | Caldwell | Texas | 48055 | 197 | 1 |
258253 | 258253 | 2020-06-20 | Caldwell | Texas | 48055 | 208 | 1 |
261380 | 261380 | 2020-06-21 | Caldwell | Texas | 48055 | 216 | 1 |
264508 | 264508 | 2020-06-22 | Caldwell | Texas | 48055 | 226 | 1 |
267636 | 267636 | 2020-06-23 | Caldwell | Texas | 48055 | 275 | 1 |
270770 | 270770 | 2020-06-24 | Caldwell | Texas | 48055 | 286 | 1 |
273909 | 273909 | 2020-06-25 | Caldwell | Texas | 48055 | 286 | 1 |
277056 | 277056 | 2020-06-26 | Caldwell | Texas | 48055 | 297 | 1 |
280204 | 280204 | 2020-06-27 | Caldwell | Texas | 48055 | 303 | 1 |
283350 | 283350 | 2020-06-28 | Caldwell | Texas | 48055 | 307 | 2 |
286496 | 286496 | 2020-06-29 | Caldwell | Texas | 48055 | 332 | 2 |
289646 | 289646 | 2020-06-30 | Caldwell | Texas | 48055 | 336 | 2 |
292799 | 292799 | 2020-07-01 | Caldwell | Texas | 48055 | 346 | 2 |
295954 | 295954 | 2020-07-02 | Caldwell | Texas | 48055 | 377 | 2 |
299114 | 299114 | 2020-07-03 | Caldwell | Texas | 48055 | 383 | 2 |
302278 | 302278 | 2020-07-04 | Caldwell | Texas | 48055 | 437 | 2 |
305442 | 305442 | 2020-07-05 | Caldwell | Texas | 48055 | 437 | 2 |
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);