ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where county = "Comanche" and state = "Texas" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
25735 | 25735 | 2020-04-01 | Comanche | Texas | 48093 | 1 | 0 |
28015 | 28015 | 2020-04-02 | Comanche | Texas | 48093 | 1 | 0 |
30350 | 30350 | 2020-04-03 | Comanche | Texas | 48093 | 1 | 0 |
32743 | 32743 | 2020-04-04 | Comanche | Texas | 48093 | 1 | 0 |
35181 | 35181 | 2020-04-05 | Comanche | Texas | 48093 | 1 | 0 |
37657 | 37657 | 2020-04-06 | Comanche | Texas | 48093 | 1 | 0 |
40180 | 40180 | 2020-04-07 | Comanche | Texas | 48093 | 3 | 0 |
42743 | 42743 | 2020-04-08 | Comanche | Texas | 48093 | 3 | 0 |
45332 | 45332 | 2020-04-09 | Comanche | Texas | 48093 | 3 | 0 |
47950 | 47950 | 2020-04-10 | Comanche | Texas | 48093 | 3 | 0 |
50607 | 50607 | 2020-04-11 | Comanche | Texas | 48093 | 3 | 0 |
53282 | 53282 | 2020-04-12 | Comanche | Texas | 48093 | 3 | 0 |
55970 | 55970 | 2020-04-13 | Comanche | Texas | 48093 | 3 | 0 |
58674 | 58674 | 2020-04-14 | Comanche | Texas | 48093 | 3 | 0 |
61391 | 61391 | 2020-04-15 | Comanche | Texas | 48093 | 3 | 0 |
64118 | 64118 | 2020-04-16 | Comanche | Texas | 48093 | 3 | 0 |
66865 | 66865 | 2020-04-17 | Comanche | Texas | 48093 | 3 | 0 |
69625 | 69625 | 2020-04-18 | Comanche | Texas | 48093 | 3 | 0 |
72393 | 72393 | 2020-04-19 | Comanche | Texas | 48093 | 3 | 0 |
75168 | 75168 | 2020-04-20 | Comanche | Texas | 48093 | 3 | 0 |
77950 | 77950 | 2020-04-21 | Comanche | Texas | 48093 | 3 | 0 |
80741 | 80741 | 2020-04-22 | Comanche | Texas | 48093 | 3 | 0 |
83541 | 83541 | 2020-04-23 | Comanche | Texas | 48093 | 3 | 0 |
86346 | 86346 | 2020-04-24 | Comanche | Texas | 48093 | 3 | 0 |
89161 | 89161 | 2020-04-25 | Comanche | Texas | 48093 | 3 | 0 |
91978 | 91978 | 2020-04-26 | Comanche | Texas | 48093 | 3 | 0 |
94806 | 94806 | 2020-04-27 | Comanche | Texas | 48093 | 3 | 0 |
97646 | 97646 | 2020-04-28 | Comanche | Texas | 48093 | 3 | 0 |
100496 | 100496 | 2020-04-29 | Comanche | Texas | 48093 | 3 | 0 |
103349 | 103349 | 2020-04-30 | Comanche | Texas | 48093 | 3 | 1 |
106213 | 106213 | 2020-05-01 | Comanche | Texas | 48093 | 3 | 1 |
109082 | 109082 | 2020-05-02 | Comanche | Texas | 48093 | 3 | 1 |
111956 | 111956 | 2020-05-03 | Comanche | Texas | 48093 | 3 | 1 |
114838 | 114838 | 2020-05-04 | Comanche | Texas | 48093 | 3 | 1 |
117797 | 117797 | 2020-05-05 | Comanche | Texas | 48093 | 3 | 1 |
120761 | 120761 | 2020-05-06 | Comanche | Texas | 48093 | 3 | 1 |
123740 | 123740 | 2020-05-07 | Comanche | Texas | 48093 | 3 | 1 |
126723 | 126723 | 2020-05-08 | Comanche | Texas | 48093 | 3 | 1 |
129712 | 129712 | 2020-05-09 | Comanche | Texas | 48093 | 3 | 1 |
132702 | 132702 | 2020-05-10 | Comanche | Texas | 48093 | 3 | 1 |
135693 | 135693 | 2020-05-11 | Comanche | Texas | 48093 | 3 | 1 |
138683 | 138683 | 2020-05-12 | Comanche | Texas | 48093 | 3 | 1 |
141679 | 141679 | 2020-05-13 | Comanche | Texas | 48093 | 3 | 1 |
144676 | 144676 | 2020-05-14 | Comanche | Texas | 48093 | 3 | 1 |
147678 | 147678 | 2020-05-15 | Comanche | Texas | 48093 | 3 | 1 |
150686 | 150686 | 2020-05-16 | Comanche | Texas | 48093 | 3 | 1 |
153697 | 153697 | 2020-05-17 | Comanche | Texas | 48093 | 3 | 1 |
156714 | 156714 | 2020-05-18 | Comanche | Texas | 48093 | 3 | 1 |
159736 | 159736 | 2020-05-19 | Comanche | Texas | 48093 | 5 | 1 |
162763 | 162763 | 2020-05-20 | Comanche | Texas | 48093 | 5 | 1 |
165792 | 165792 | 2020-05-21 | Comanche | Texas | 48093 | 5 | 1 |
168828 | 168828 | 2020-05-22 | Comanche | Texas | 48093 | 5 | 1 |
171867 | 171867 | 2020-05-23 | Comanche | Texas | 48093 | 10 | 1 |
174910 | 174910 | 2020-05-24 | Comanche | Texas | 48093 | 10 | 1 |
177954 | 177954 | 2020-05-25 | Comanche | Texas | 48093 | 10 | 1 |
180997 | 180997 | 2020-05-26 | Comanche | Texas | 48093 | 10 | 1 |
184047 | 184047 | 2020-05-27 | Comanche | Texas | 48093 | 10 | 1 |
187104 | 187104 | 2020-05-28 | Comanche | Texas | 48093 | 10 | 1 |
190168 | 190168 | 2020-05-29 | Comanche | Texas | 48093 | 11 | 1 |
193233 | 193233 | 2020-05-30 | Comanche | Texas | 48093 | 12 | 1 |
196303 | 196303 | 2020-05-31 | Comanche | Texas | 48093 | 12 | 1 |
199376 | 199376 | 2020-06-01 | Comanche | Texas | 48093 | 12 | 1 |
202451 | 202451 | 2020-06-02 | Comanche | Texas | 48093 | 12 | 1 |
205530 | 205530 | 2020-06-03 | Comanche | Texas | 48093 | 12 | 1 |
208612 | 208612 | 2020-06-04 | Comanche | Texas | 48093 | 12 | 1 |
211695 | 211695 | 2020-06-05 | Comanche | Texas | 48093 | 12 | 1 |
214782 | 214782 | 2020-06-06 | Comanche | Texas | 48093 | 12 | 1 |
217872 | 217872 | 2020-06-07 | Comanche | Texas | 48093 | 12 | 1 |
220964 | 220964 | 2020-06-08 | Comanche | Texas | 48093 | 12 | 1 |
224059 | 224059 | 2020-06-09 | Comanche | Texas | 48093 | 12 | 1 |
227159 | 227159 | 2020-06-10 | Comanche | Texas | 48093 | 12 | 1 |
230263 | 230263 | 2020-06-11 | Comanche | Texas | 48093 | 12 | 1 |
233367 | 233367 | 2020-06-12 | Comanche | Texas | 48093 | 12 | 1 |
236473 | 236473 | 2020-06-13 | Comanche | Texas | 48093 | 12 | 1 |
239581 | 239581 | 2020-06-14 | Comanche | Texas | 48093 | 12 | 1 |
242691 | 242691 | 2020-06-15 | Comanche | Texas | 48093 | 12 | 1 |
245803 | 245803 | 2020-06-16 | Comanche | Texas | 48093 | 14 | 1 |
248916 | 248916 | 2020-06-17 | Comanche | Texas | 48093 | 14 | 1 |
252031 | 252031 | 2020-06-18 | Comanche | Texas | 48093 | 14 | 1 |
255146 | 255146 | 2020-06-19 | Comanche | Texas | 48093 | 14 | 1 |
258272 | 258272 | 2020-06-20 | Comanche | Texas | 48093 | 14 | 1 |
261399 | 261399 | 2020-06-21 | Comanche | Texas | 48093 | 14 | 1 |
264527 | 264527 | 2020-06-22 | Comanche | Texas | 48093 | 14 | 1 |
267655 | 267655 | 2020-06-23 | Comanche | Texas | 48093 | 14 | 1 |
270789 | 270789 | 2020-06-24 | Comanche | Texas | 48093 | 14 | 1 |
273928 | 273928 | 2020-06-25 | Comanche | Texas | 48093 | 14 | 1 |
277075 | 277075 | 2020-06-26 | Comanche | Texas | 48093 | 14 | 1 |
280223 | 280223 | 2020-06-27 | Comanche | Texas | 48093 | 14 | 1 |
283369 | 283369 | 2020-06-28 | Comanche | Texas | 48093 | 14 | 1 |
286515 | 286515 | 2020-06-29 | Comanche | Texas | 48093 | 14 | 1 |
289665 | 289665 | 2020-06-30 | Comanche | Texas | 48093 | 17 | 1 |
292818 | 292818 | 2020-07-01 | Comanche | Texas | 48093 | 18 | 1 |
295973 | 295973 | 2020-07-02 | Comanche | Texas | 48093 | 19 | 1 |
299133 | 299133 | 2020-07-03 | Comanche | Texas | 48093 | 21 | 1 |
302297 | 302297 | 2020-07-04 | Comanche | Texas | 48093 | 21 | 1 |
305461 | 305461 | 2020-07-05 | Comanche | Texas | 48093 | 21 | 1 |
308629 | 308629 | 2020-07-06 | Comanche | Texas | 48093 | 21 | 1 |
311798 | 311798 | 2020-07-07 | Comanche | Texas | 48093 | 21 | 1 |
314972 | 314972 | 2020-07-08 | Comanche | Texas | 48093 | 25 | 1 |
318145 | 318145 | 2020-07-09 | Comanche | Texas | 48093 | 25 | 1 |
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);