ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
75 rows where county = "Jasper", deaths = 2 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
369362 | 369362 | 2020-07-25 | Jasper | Texas | 48241 | 254 | 2 |
366153 | 366153 | 2020-07-24 | Jasper | Texas | 48241 | 110 | 2 |
362947 | 362947 | 2020-07-23 | Jasper | Texas | 48241 | 97 | 2 |
359740 | 359740 | 2020-07-22 | Jasper | Texas | 48241 | 95 | 2 |
356535 | 356535 | 2020-07-21 | Jasper | Texas | 48241 | 95 | 2 |
353332 | 353332 | 2020-07-20 | Jasper | Texas | 48241 | 93 | 2 |
350130 | 350130 | 2020-07-19 | Jasper | Texas | 48241 | 92 | 2 |
346930 | 346930 | 2020-07-18 | Jasper | Texas | 48241 | 92 | 2 |
343730 | 343730 | 2020-07-17 | Jasper | Texas | 48241 | 91 | 2 |
340531 | 340531 | 2020-07-16 | Jasper | Texas | 48241 | 91 | 2 |
337335 | 337335 | 2020-07-15 | Jasper | Texas | 48241 | 88 | 2 |
334140 | 334140 | 2020-07-14 | Jasper | Texas | 48241 | 80 | 2 |
330949 | 330949 | 2020-07-13 | Jasper | Texas | 48241 | 71 | 2 |
327763 | 327763 | 2020-07-12 | Jasper | Texas | 48241 | 71 | 2 |
324578 | 324578 | 2020-07-11 | Jasper | Texas | 48241 | 70 | 2 |
321397 | 321397 | 2020-07-10 | Jasper | Texas | 48241 | 70 | 2 |
318218 | 318218 | 2020-07-09 | Jasper | Texas | 48241 | 70 | 2 |
315045 | 315045 | 2020-07-08 | Jasper | Texas | 48241 | 69 | 2 |
311871 | 311871 | 2020-07-07 | Jasper | Texas | 48241 | 69 | 2 |
308702 | 308702 | 2020-07-06 | Jasper | Texas | 48241 | 61 | 2 |
305534 | 305534 | 2020-07-05 | Jasper | Texas | 48241 | 61 | 2 |
302370 | 302370 | 2020-07-04 | Jasper | Texas | 48241 | 60 | 2 |
299206 | 299206 | 2020-07-03 | Jasper | Texas | 48241 | 60 | 2 |
296046 | 296046 | 2020-07-02 | Jasper | Texas | 48241 | 52 | 2 |
292891 | 292891 | 2020-07-01 | Jasper | Texas | 48241 | 52 | 2 |
289738 | 289738 | 2020-06-30 | Jasper | Texas | 48241 | 51 | 2 |
286588 | 286588 | 2020-06-29 | Jasper | Texas | 48241 | 51 | 2 |
283442 | 283442 | 2020-06-28 | Jasper | Texas | 48241 | 51 | 2 |
280296 | 280296 | 2020-06-27 | Jasper | Texas | 48241 | 43 | 2 |
277148 | 277148 | 2020-06-26 | Jasper | Texas | 48241 | 43 | 2 |
274001 | 274001 | 2020-06-25 | Jasper | Texas | 48241 | 43 | 2 |
270861 | 270861 | 2020-06-24 | Jasper | Texas | 48241 | 41 | 2 |
267727 | 267727 | 2020-06-23 | Jasper | Texas | 48241 | 39 | 2 |
264599 | 264599 | 2020-06-22 | Jasper | Texas | 48241 | 36 | 2 |
261471 | 261471 | 2020-06-21 | Jasper | Texas | 48241 | 36 | 2 |
258344 | 258344 | 2020-06-20 | Jasper | Texas | 48241 | 35 | 2 |
255217 | 255217 | 2020-06-19 | Jasper | Texas | 48241 | 34 | 2 |
252102 | 252102 | 2020-06-18 | Jasper | Texas | 48241 | 34 | 2 |
248987 | 248987 | 2020-06-17 | Jasper | Texas | 48241 | 34 | 2 |
245874 | 245874 | 2020-06-16 | Jasper | Texas | 48241 | 34 | 2 |
242762 | 242762 | 2020-06-15 | Jasper | Texas | 48241 | 34 | 2 |
239652 | 239652 | 2020-06-14 | Jasper | Texas | 48241 | 34 | 2 |
236544 | 236544 | 2020-06-13 | Jasper | Texas | 48241 | 34 | 2 |
233438 | 233438 | 2020-06-12 | Jasper | Texas | 48241 | 34 | 2 |
230334 | 230334 | 2020-06-11 | Jasper | Texas | 48241 | 34 | 2 |
227230 | 227230 | 2020-06-10 | Jasper | Texas | 48241 | 34 | 2 |
224130 | 224130 | 2020-06-09 | Jasper | Texas | 48241 | 34 | 2 |
221035 | 221035 | 2020-06-08 | Jasper | Texas | 48241 | 34 | 2 |
217943 | 217943 | 2020-06-07 | Jasper | Texas | 48241 | 34 | 2 |
214853 | 214853 | 2020-06-06 | Jasper | Texas | 48241 | 34 | 2 |
211766 | 211766 | 2020-06-05 | Jasper | Texas | 48241 | 34 | 2 |
208682 | 208682 | 2020-06-04 | Jasper | Texas | 48241 | 34 | 2 |
205600 | 205600 | 2020-06-03 | Jasper | Texas | 48241 | 34 | 2 |
202521 | 202521 | 2020-06-02 | Jasper | Texas | 48241 | 34 | 2 |
199445 | 199445 | 2020-06-01 | Jasper | Texas | 48241 | 34 | 2 |
196372 | 196372 | 2020-05-31 | Jasper | Texas | 48241 | 34 | 2 |
193302 | 193302 | 2020-05-30 | Jasper | Texas | 48241 | 34 | 2 |
190237 | 190237 | 2020-05-29 | Jasper | Texas | 48241 | 34 | 2 |
187173 | 187173 | 2020-05-28 | Jasper | Texas | 48241 | 34 | 2 |
184116 | 184116 | 2020-05-27 | Jasper | Texas | 48241 | 34 | 2 |
181066 | 181066 | 2020-05-26 | Jasper | Texas | 48241 | 34 | 2 |
178022 | 178022 | 2020-05-25 | Jasper | Texas | 48241 | 34 | 2 |
174978 | 174978 | 2020-05-24 | Jasper | Texas | 48241 | 34 | 2 |
171935 | 171935 | 2020-05-23 | Jasper | Texas | 48241 | 34 | 2 |
168895 | 168895 | 2020-05-22 | Jasper | Texas | 48241 | 34 | 2 |
165859 | 165859 | 2020-05-21 | Jasper | Texas | 48241 | 34 | 2 |
162830 | 162830 | 2020-05-20 | Jasper | Texas | 48241 | 34 | 2 |
159802 | 159802 | 2020-05-19 | Jasper | Texas | 48241 | 33 | 2 |
156780 | 156780 | 2020-05-18 | Jasper | Texas | 48241 | 33 | 2 |
153763 | 153763 | 2020-05-17 | Jasper | Texas | 48241 | 33 | 2 |
150752 | 150752 | 2020-05-16 | Jasper | Texas | 48241 | 33 | 2 |
147744 | 147744 | 2020-05-15 | Jasper | Texas | 48241 | 33 | 2 |
144740 | 144740 | 2020-05-14 | Jasper | Texas | 48241 | 33 | 2 |
141743 | 141743 | 2020-05-13 | Jasper | Texas | 48241 | 32 | 2 |
138747 | 138747 | 2020-05-12 | Jasper | Texas | 48241 | 28 | 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);