ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Karnes" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
324585 | 324585 | 2020-07-11 | Karnes | Texas | 48255 | 80 | 0 |
321404 | 321404 | 2020-07-10 | Karnes | Texas | 48255 | 66 | 0 |
318225 | 318225 | 2020-07-09 | Karnes | Texas | 48255 | 62 | 0 |
315052 | 315052 | 2020-07-08 | Karnes | Texas | 48255 | 60 | 0 |
311878 | 311878 | 2020-07-07 | Karnes | Texas | 48255 | 58 | 0 |
308709 | 308709 | 2020-07-06 | Karnes | Texas | 48255 | 53 | 0 |
305541 | 305541 | 2020-07-05 | Karnes | Texas | 48255 | 53 | 0 |
302377 | 302377 | 2020-07-04 | Karnes | Texas | 48255 | 53 | 0 |
299213 | 299213 | 2020-07-03 | Karnes | Texas | 48255 | 52 | 0 |
296053 | 296053 | 2020-07-02 | Karnes | Texas | 48255 | 51 | 0 |
292898 | 292898 | 2020-07-01 | Karnes | Texas | 48255 | 48 | 0 |
289745 | 289745 | 2020-06-30 | Karnes | Texas | 48255 | 29 | 0 |
286595 | 286595 | 2020-06-29 | Karnes | Texas | 48255 | 21 | 0 |
283449 | 283449 | 2020-06-28 | Karnes | Texas | 48255 | 21 | 0 |
280303 | 280303 | 2020-06-27 | Karnes | Texas | 48255 | 21 | 0 |
277155 | 277155 | 2020-06-26 | Karnes | Texas | 48255 | 19 | 0 |
274007 | 274007 | 2020-06-25 | Karnes | Texas | 48255 | 17 | 0 |
270867 | 270867 | 2020-06-24 | Karnes | Texas | 48255 | 15 | 0 |
267733 | 267733 | 2020-06-23 | Karnes | Texas | 48255 | 14 | 0 |
264605 | 264605 | 2020-06-22 | Karnes | Texas | 48255 | 14 | 0 |
261477 | 261477 | 2020-06-21 | Karnes | Texas | 48255 | 14 | 0 |
258350 | 258350 | 2020-06-20 | Karnes | Texas | 48255 | 14 | 0 |
255223 | 255223 | 2020-06-19 | Karnes | Texas | 48255 | 11 | 0 |
252108 | 252108 | 2020-06-18 | Karnes | Texas | 48255 | 7 | 0 |
248993 | 248993 | 2020-06-17 | Karnes | Texas | 48255 | 7 | 0 |
245880 | 245880 | 2020-06-16 | Karnes | Texas | 48255 | 4 | 0 |
242768 | 242768 | 2020-06-15 | Karnes | Texas | 48255 | 4 | 0 |
239658 | 239658 | 2020-06-14 | Karnes | Texas | 48255 | 4 | 0 |
236550 | 236550 | 2020-06-13 | Karnes | Texas | 48255 | 4 | 0 |
233444 | 233444 | 2020-06-12 | Karnes | Texas | 48255 | 4 | 0 |
230340 | 230340 | 2020-06-11 | Karnes | Texas | 48255 | 4 | 0 |
227236 | 227236 | 2020-06-10 | Karnes | Texas | 48255 | 4 | 0 |
224136 | 224136 | 2020-06-09 | Karnes | Texas | 48255 | 4 | 0 |
221041 | 221041 | 2020-06-08 | Karnes | Texas | 48255 | 4 | 0 |
217949 | 217949 | 2020-06-07 | Karnes | Texas | 48255 | 4 | 0 |
214859 | 214859 | 2020-06-06 | Karnes | Texas | 48255 | 4 | 0 |
211772 | 211772 | 2020-06-05 | Karnes | Texas | 48255 | 4 | 0 |
208688 | 208688 | 2020-06-04 | Karnes | Texas | 48255 | 4 | 0 |
205606 | 205606 | 2020-06-03 | Karnes | Texas | 48255 | 4 | 0 |
202527 | 202527 | 2020-06-02 | Karnes | Texas | 48255 | 4 | 0 |
199451 | 199451 | 2020-06-01 | Karnes | Texas | 48255 | 4 | 0 |
196378 | 196378 | 2020-05-31 | Karnes | Texas | 48255 | 4 | 0 |
193308 | 193308 | 2020-05-30 | Karnes | Texas | 48255 | 4 | 0 |
190243 | 190243 | 2020-05-29 | Karnes | Texas | 48255 | 4 | 0 |
187179 | 187179 | 2020-05-28 | Karnes | Texas | 48255 | 4 | 0 |
184122 | 184122 | 2020-05-27 | Karnes | Texas | 48255 | 4 | 0 |
181072 | 181072 | 2020-05-26 | Karnes | Texas | 48255 | 4 | 0 |
178028 | 178028 | 2020-05-25 | Karnes | Texas | 48255 | 4 | 0 |
174984 | 174984 | 2020-05-24 | Karnes | Texas | 48255 | 4 | 0 |
171941 | 171941 | 2020-05-23 | Karnes | Texas | 48255 | 4 | 0 |
168901 | 168901 | 2020-05-22 | Karnes | Texas | 48255 | 4 | 0 |
165865 | 165865 | 2020-05-21 | Karnes | Texas | 48255 | 4 | 0 |
162836 | 162836 | 2020-05-20 | Karnes | Texas | 48255 | 4 | 0 |
159808 | 159808 | 2020-05-19 | Karnes | Texas | 48255 | 4 | 0 |
156786 | 156786 | 2020-05-18 | Karnes | Texas | 48255 | 3 | 0 |
153769 | 153769 | 2020-05-17 | Karnes | Texas | 48255 | 3 | 0 |
150758 | 150758 | 2020-05-16 | Karnes | Texas | 48255 | 3 | 0 |
147750 | 147750 | 2020-05-15 | Karnes | Texas | 48255 | 4 | 0 |
144746 | 144746 | 2020-05-14 | Karnes | Texas | 48255 | 4 | 0 |
141749 | 141749 | 2020-05-13 | Karnes | Texas | 48255 | 4 | 0 |
138753 | 138753 | 2020-05-12 | Karnes | Texas | 48255 | 3 | 0 |
135763 | 135763 | 2020-05-11 | Karnes | Texas | 48255 | 3 | 0 |
132772 | 132772 | 2020-05-10 | Karnes | Texas | 48255 | 3 | 0 |
129782 | 129782 | 2020-05-09 | Karnes | Texas | 48255 | 3 | 0 |
126793 | 126793 | 2020-05-08 | Karnes | Texas | 48255 | 3 | 0 |
123810 | 123810 | 2020-05-07 | Karnes | Texas | 48255 | 3 | 0 |
120831 | 120831 | 2020-05-06 | Karnes | Texas | 48255 | 3 | 0 |
117867 | 117867 | 2020-05-05 | Karnes | Texas | 48255 | 3 | 0 |
114908 | 114908 | 2020-05-04 | Karnes | Texas | 48255 | 3 | 0 |
112026 | 112026 | 2020-05-03 | Karnes | Texas | 48255 | 3 | 0 |
109152 | 109152 | 2020-05-02 | Karnes | Texas | 48255 | 3 | 0 |
106283 | 106283 | 2020-05-01 | Karnes | Texas | 48255 | 3 | 0 |
103419 | 103419 | 2020-04-30 | Karnes | Texas | 48255 | 3 | 0 |
100564 | 100564 | 2020-04-29 | Karnes | Texas | 48255 | 3 | 0 |
97714 | 97714 | 2020-04-28 | Karnes | Texas | 48255 | 3 | 0 |
94874 | 94874 | 2020-04-27 | Karnes | Texas | 48255 | 3 | 0 |
92045 | 92045 | 2020-04-26 | Karnes | Texas | 48255 | 3 | 0 |
89228 | 89228 | 2020-04-25 | Karnes | Texas | 48255 | 3 | 0 |
86413 | 86413 | 2020-04-24 | Karnes | Texas | 48255 | 3 | 0 |
83608 | 83608 | 2020-04-23 | Karnes | Texas | 48255 | 3 | 0 |
80807 | 80807 | 2020-04-22 | Karnes | Texas | 48255 | 3 | 0 |
78016 | 78016 | 2020-04-21 | Karnes | Texas | 48255 | 3 | 0 |
75234 | 75234 | 2020-04-20 | Karnes | Texas | 48255 | 3 | 0 |
72458 | 72458 | 2020-04-19 | Karnes | Texas | 48255 | 3 | 0 |
69689 | 69689 | 2020-04-18 | Karnes | Texas | 48255 | 3 | 0 |
66929 | 66929 | 2020-04-17 | Karnes | Texas | 48255 | 3 | 0 |
64182 | 64182 | 2020-04-16 | Karnes | Texas | 48255 | 3 | 0 |
61455 | 61455 | 2020-04-15 | Karnes | Texas | 48255 | 3 | 0 |
58737 | 58737 | 2020-04-14 | Karnes | Texas | 48255 | 3 | 0 |
56032 | 56032 | 2020-04-13 | Karnes | Texas | 48255 | 2 | 0 |
53344 | 53344 | 2020-04-12 | Karnes | Texas | 48255 | 2 | 0 |
50669 | 50669 | 2020-04-11 | Karnes | Texas | 48255 | 2 | 0 |
48011 | 48011 | 2020-04-10 | Karnes | Texas | 48255 | 2 | 0 |
45390 | 45390 | 2020-04-09 | Karnes | Texas | 48255 | 2 | 0 |
42800 | 42800 | 2020-04-08 | Karnes | Texas | 48255 | 2 | 0 |
40232 | 40232 | 2020-04-07 | Karnes | Texas | 48255 | 2 | 0 |
37705 | 37705 | 2020-04-06 | Karnes | Texas | 48255 | 2 | 0 |
35229 | 35229 | 2020-04-05 | Karnes | Texas | 48255 | 2 | 0 |
32791 | 32791 | 2020-04-04 | Karnes | Texas | 48255 | 2 | 0 |
30396 | 30396 | 2020-04-03 | Karnes | Texas | 48255 | 2 | 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);