ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where fips = 48177 and state = "Texas" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
25755 | 25755 | 2020-04-01 | Gonzales | Texas | 48177 | 1 | 0 |
28038 | 28038 | 2020-04-02 | Gonzales | Texas | 48177 | 1 | 0 |
30373 | 30373 | 2020-04-03 | Gonzales | Texas | 48177 | 1 | 0 |
32766 | 32766 | 2020-04-04 | Gonzales | Texas | 48177 | 1 | 0 |
35204 | 35204 | 2020-04-05 | Gonzales | Texas | 48177 | 1 | 0 |
37680 | 37680 | 2020-04-06 | Gonzales | Texas | 48177 | 1 | 0 |
40205 | 40205 | 2020-04-07 | Gonzales | Texas | 48177 | 1 | 0 |
42772 | 42772 | 2020-04-08 | Gonzales | Texas | 48177 | 1 | 0 |
45361 | 45361 | 2020-04-09 | Gonzales | Texas | 48177 | 2 | 0 |
47981 | 47981 | 2020-04-10 | Gonzales | Texas | 48177 | 2 | 0 |
50639 | 50639 | 2020-04-11 | Gonzales | Texas | 48177 | 2 | 0 |
53314 | 53314 | 2020-04-12 | Gonzales | Texas | 48177 | 2 | 0 |
56002 | 56002 | 2020-04-13 | Gonzales | Texas | 48177 | 2 | 0 |
58707 | 58707 | 2020-04-14 | Gonzales | Texas | 48177 | 2 | 0 |
61425 | 61425 | 2020-04-15 | Gonzales | Texas | 48177 | 2 | 0 |
64152 | 64152 | 2020-04-16 | Gonzales | Texas | 48177 | 2 | 0 |
66899 | 66899 | 2020-04-17 | Gonzales | Texas | 48177 | 2 | 0 |
69659 | 69659 | 2020-04-18 | Gonzales | Texas | 48177 | 2 | 0 |
72427 | 72427 | 2020-04-19 | Gonzales | Texas | 48177 | 2 | 0 |
75202 | 75202 | 2020-04-20 | Gonzales | Texas | 48177 | 2 | 0 |
77984 | 77984 | 2020-04-21 | Gonzales | Texas | 48177 | 2 | 0 |
80775 | 80775 | 2020-04-22 | Gonzales | Texas | 48177 | 3 | 0 |
83575 | 83575 | 2020-04-23 | Gonzales | Texas | 48177 | 4 | 0 |
86380 | 86380 | 2020-04-24 | Gonzales | Texas | 48177 | 4 | 0 |
89195 | 89195 | 2020-04-25 | Gonzales | Texas | 48177 | 8 | 1 |
92012 | 92012 | 2020-04-26 | Gonzales | Texas | 48177 | 12 | 1 |
94841 | 94841 | 2020-04-27 | Gonzales | Texas | 48177 | 12 | 1 |
97681 | 97681 | 2020-04-28 | Gonzales | Texas | 48177 | 14 | 2 |
100531 | 100531 | 2020-04-29 | Gonzales | Texas | 48177 | 18 | 2 |
103386 | 103386 | 2020-04-30 | Gonzales | Texas | 48177 | 20 | 2 |
106250 | 106250 | 2020-05-01 | Gonzales | Texas | 48177 | 21 | 2 |
109119 | 109119 | 2020-05-02 | Gonzales | Texas | 48177 | 23 | 2 |
111993 | 111993 | 2020-05-03 | Gonzales | Texas | 48177 | 27 | 2 |
114875 | 114875 | 2020-05-04 | Gonzales | Texas | 48177 | 30 | 2 |
117834 | 117834 | 2020-05-05 | Gonzales | Texas | 48177 | 31 | 2 |
120798 | 120798 | 2020-05-06 | Gonzales | Texas | 48177 | 31 | 2 |
123777 | 123777 | 2020-05-07 | Gonzales | Texas | 48177 | 31 | 2 |
126760 | 126760 | 2020-05-08 | Gonzales | Texas | 48177 | 31 | 2 |
129749 | 129749 | 2020-05-09 | Gonzales | Texas | 48177 | 40 | 2 |
132739 | 132739 | 2020-05-10 | Gonzales | Texas | 48177 | 53 | 2 |
135730 | 135730 | 2020-05-11 | Gonzales | Texas | 48177 | 59 | 2 |
138720 | 138720 | 2020-05-12 | Gonzales | Texas | 48177 | 59 | 2 |
141716 | 141716 | 2020-05-13 | Gonzales | Texas | 48177 | 62 | 2 |
144713 | 144713 | 2020-05-14 | Gonzales | Texas | 48177 | 70 | 2 |
147716 | 147716 | 2020-05-15 | Gonzales | Texas | 48177 | 73 | 2 |
150724 | 150724 | 2020-05-16 | Gonzales | Texas | 48177 | 75 | 2 |
153735 | 153735 | 2020-05-17 | Gonzales | Texas | 48177 | 79 | 2 |
156752 | 156752 | 2020-05-18 | Gonzales | Texas | 48177 | 85 | 2 |
159774 | 159774 | 2020-05-19 | Gonzales | Texas | 48177 | 86 | 2 |
162801 | 162801 | 2020-05-20 | Gonzales | Texas | 48177 | 88 | 2 |
165830 | 165830 | 2020-05-21 | Gonzales | Texas | 48177 | 90 | 2 |
168866 | 168866 | 2020-05-22 | Gonzales | Texas | 48177 | 90 | 2 |
171905 | 171905 | 2020-05-23 | Gonzales | Texas | 48177 | 91 | 2 |
174948 | 174948 | 2020-05-24 | Gonzales | Texas | 48177 | 91 | 2 |
177992 | 177992 | 2020-05-25 | Gonzales | Texas | 48177 | 91 | 2 |
181035 | 181035 | 2020-05-26 | Gonzales | Texas | 48177 | 91 | 2 |
184085 | 184085 | 2020-05-27 | Gonzales | Texas | 48177 | 100 | 2 |
187142 | 187142 | 2020-05-28 | Gonzales | Texas | 48177 | 111 | 2 |
190206 | 190206 | 2020-05-29 | Gonzales | Texas | 48177 | 118 | 2 |
193271 | 193271 | 2020-05-30 | Gonzales | Texas | 48177 | 121 | 2 |
196341 | 196341 | 2020-05-31 | Gonzales | Texas | 48177 | 129 | 2 |
199414 | 199414 | 2020-06-01 | Gonzales | Texas | 48177 | 129 | 2 |
202489 | 202489 | 2020-06-02 | Gonzales | Texas | 48177 | 132 | 2 |
205568 | 205568 | 2020-06-03 | Gonzales | Texas | 48177 | 143 | 3 |
208650 | 208650 | 2020-06-04 | Gonzales | Texas | 48177 | 144 | 3 |
211734 | 211734 | 2020-06-05 | Gonzales | Texas | 48177 | 147 | 3 |
214821 | 214821 | 2020-06-06 | Gonzales | Texas | 48177 | 149 | 3 |
217911 | 217911 | 2020-06-07 | Gonzales | Texas | 48177 | 151 | 3 |
221003 | 221003 | 2020-06-08 | Gonzales | Texas | 48177 | 151 | 3 |
224098 | 224098 | 2020-06-09 | Gonzales | Texas | 48177 | 153 | 3 |
227198 | 227198 | 2020-06-10 | Gonzales | Texas | 48177 | 155 | 3 |
230302 | 230302 | 2020-06-11 | Gonzales | Texas | 48177 | 157 | 4 |
233406 | 233406 | 2020-06-12 | Gonzales | Texas | 48177 | 157 | 4 |
236512 | 236512 | 2020-06-13 | Gonzales | Texas | 48177 | 165 | 4 |
239620 | 239620 | 2020-06-14 | Gonzales | Texas | 48177 | 166 | 4 |
242730 | 242730 | 2020-06-15 | Gonzales | Texas | 48177 | 166 | 4 |
245842 | 245842 | 2020-06-16 | Gonzales | Texas | 48177 | 169 | 4 |
248955 | 248955 | 2020-06-17 | Gonzales | Texas | 48177 | 172 | 4 |
252070 | 252070 | 2020-06-18 | Gonzales | Texas | 48177 | 175 | 4 |
255185 | 255185 | 2020-06-19 | Gonzales | Texas | 48177 | 203 | 4 |
258312 | 258312 | 2020-06-20 | Gonzales | Texas | 48177 | 213 | 4 |
261439 | 261439 | 2020-06-21 | Gonzales | Texas | 48177 | 215 | 4 |
264567 | 264567 | 2020-06-22 | Gonzales | Texas | 48177 | 215 | 4 |
267695 | 267695 | 2020-06-23 | Gonzales | Texas | 48177 | 217 | 4 |
270829 | 270829 | 2020-06-24 | Gonzales | Texas | 48177 | 231 | 4 |
273969 | 273969 | 2020-06-25 | Gonzales | Texas | 48177 | 235 | 4 |
277116 | 277116 | 2020-06-26 | Gonzales | Texas | 48177 | 244 | 4 |
280264 | 280264 | 2020-06-27 | Gonzales | Texas | 48177 | 247 | 4 |
283410 | 283410 | 2020-06-28 | Gonzales | Texas | 48177 | 248 | 4 |
286556 | 286556 | 2020-06-29 | Gonzales | Texas | 48177 | 248 | 4 |
289706 | 289706 | 2020-06-30 | Gonzales | Texas | 48177 | 260 | 4 |
292859 | 292859 | 2020-07-01 | Gonzales | Texas | 48177 | 261 | 4 |
296014 | 296014 | 2020-07-02 | Gonzales | Texas | 48177 | 297 | 4 |
299174 | 299174 | 2020-07-03 | Gonzales | Texas | 48177 | 301 | 4 |
302338 | 302338 | 2020-07-04 | Gonzales | Texas | 48177 | 306 | 4 |
305502 | 305502 | 2020-07-05 | Gonzales | Texas | 48177 | 306 | 4 |
308670 | 308670 | 2020-07-06 | Gonzales | Texas | 48177 | 307 | 4 |
311839 | 311839 | 2020-07-07 | Gonzales | Texas | 48177 | 314 | 4 |
315013 | 315013 | 2020-07-08 | Gonzales | Texas | 48177 | 314 | 4 |
318186 | 318186 | 2020-07-09 | Gonzales | Texas | 48177 | 316 | 4 |
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);