ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
742 rows where fips = 48083 and state = "Texas" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
109078 | 109078 | 2020-05-02 | Coleman | Texas | 48083 | 1 | 0 |
111952 | 111952 | 2020-05-03 | Coleman | Texas | 48083 | 1 | 0 |
114834 | 114834 | 2020-05-04 | Coleman | Texas | 48083 | 1 | 0 |
117792 | 117792 | 2020-05-05 | Coleman | Texas | 48083 | 1 | 0 |
120756 | 120756 | 2020-05-06 | Coleman | Texas | 48083 | 1 | 0 |
123735 | 123735 | 2020-05-07 | Coleman | Texas | 48083 | 2 | 0 |
126718 | 126718 | 2020-05-08 | Coleman | Texas | 48083 | 2 | 0 |
129707 | 129707 | 2020-05-09 | Coleman | Texas | 48083 | 2 | 0 |
132697 | 132697 | 2020-05-10 | Coleman | Texas | 48083 | 2 | 0 |
135688 | 135688 | 2020-05-11 | Coleman | Texas | 48083 | 2 | 0 |
138678 | 138678 | 2020-05-12 | Coleman | Texas | 48083 | 2 | 0 |
141674 | 141674 | 2020-05-13 | Coleman | Texas | 48083 | 2 | 0 |
144671 | 144671 | 2020-05-14 | Coleman | Texas | 48083 | 2 | 0 |
147673 | 147673 | 2020-05-15 | Coleman | Texas | 48083 | 2 | 0 |
150681 | 150681 | 2020-05-16 | Coleman | Texas | 48083 | 2 | 0 |
153692 | 153692 | 2020-05-17 | Coleman | Texas | 48083 | 2 | 0 |
156709 | 156709 | 2020-05-18 | Coleman | Texas | 48083 | 2 | 0 |
159731 | 159731 | 2020-05-19 | Coleman | Texas | 48083 | 2 | 0 |
162758 | 162758 | 2020-05-20 | Coleman | Texas | 48083 | 2 | 0 |
165787 | 165787 | 2020-05-21 | Coleman | Texas | 48083 | 2 | 0 |
168823 | 168823 | 2020-05-22 | Coleman | Texas | 48083 | 2 | 0 |
171862 | 171862 | 2020-05-23 | Coleman | Texas | 48083 | 2 | 0 |
174905 | 174905 | 2020-05-24 | Coleman | Texas | 48083 | 2 | 0 |
177949 | 177949 | 2020-05-25 | Coleman | Texas | 48083 | 2 | 0 |
180992 | 180992 | 2020-05-26 | Coleman | Texas | 48083 | 2 | 0 |
184042 | 184042 | 2020-05-27 | Coleman | Texas | 48083 | 2 | 0 |
187099 | 187099 | 2020-05-28 | Coleman | Texas | 48083 | 3 | 0 |
190163 | 190163 | 2020-05-29 | Coleman | Texas | 48083 | 3 | 0 |
193228 | 193228 | 2020-05-30 | Coleman | Texas | 48083 | 3 | 0 |
196298 | 196298 | 2020-05-31 | Coleman | Texas | 48083 | 3 | 0 |
199371 | 199371 | 2020-06-01 | Coleman | Texas | 48083 | 3 | 0 |
202446 | 202446 | 2020-06-02 | Coleman | Texas | 48083 | 3 | 0 |
205525 | 205525 | 2020-06-03 | Coleman | Texas | 48083 | 4 | 0 |
208607 | 208607 | 2020-06-04 | Coleman | Texas | 48083 | 4 | 0 |
211690 | 211690 | 2020-06-05 | Coleman | Texas | 48083 | 4 | 0 |
214777 | 214777 | 2020-06-06 | Coleman | Texas | 48083 | 3 | 0 |
217867 | 217867 | 2020-06-07 | Coleman | Texas | 48083 | 3 | 0 |
220959 | 220959 | 2020-06-08 | Coleman | Texas | 48083 | 3 | 0 |
224054 | 224054 | 2020-06-09 | Coleman | Texas | 48083 | 3 | 0 |
227154 | 227154 | 2020-06-10 | Coleman | Texas | 48083 | 3 | 0 |
230258 | 230258 | 2020-06-11 | Coleman | Texas | 48083 | 3 | 0 |
233362 | 233362 | 2020-06-12 | Coleman | Texas | 48083 | 3 | 0 |
236468 | 236468 | 2020-06-13 | Coleman | Texas | 48083 | 3 | 0 |
239576 | 239576 | 2020-06-14 | Coleman | Texas | 48083 | 3 | 0 |
242686 | 242686 | 2020-06-15 | Coleman | Texas | 48083 | 3 | 0 |
245798 | 245798 | 2020-06-16 | Coleman | Texas | 48083 | 3 | 0 |
248911 | 248911 | 2020-06-17 | Coleman | Texas | 48083 | 3 | 0 |
252026 | 252026 | 2020-06-18 | Coleman | Texas | 48083 | 3 | 0 |
255141 | 255141 | 2020-06-19 | Coleman | Texas | 48083 | 3 | 0 |
258267 | 258267 | 2020-06-20 | Coleman | Texas | 48083 | 3 | 0 |
261394 | 261394 | 2020-06-21 | Coleman | Texas | 48083 | 3 | 0 |
264522 | 264522 | 2020-06-22 | Coleman | Texas | 48083 | 3 | 0 |
267650 | 267650 | 2020-06-23 | Coleman | Texas | 48083 | 3 | 0 |
270784 | 270784 | 2020-06-24 | Coleman | Texas | 48083 | 3 | 0 |
273923 | 273923 | 2020-06-25 | Coleman | Texas | 48083 | 3 | 0 |
277070 | 277070 | 2020-06-26 | Coleman | Texas | 48083 | 3 | 0 |
280218 | 280218 | 2020-06-27 | Coleman | Texas | 48083 | 3 | 0 |
283364 | 283364 | 2020-06-28 | Coleman | Texas | 48083 | 3 | 0 |
286510 | 286510 | 2020-06-29 | Coleman | Texas | 48083 | 3 | 0 |
289660 | 289660 | 2020-06-30 | Coleman | Texas | 48083 | 3 | 0 |
292813 | 292813 | 2020-07-01 | Coleman | Texas | 48083 | 3 | 0 |
295968 | 295968 | 2020-07-02 | Coleman | Texas | 48083 | 3 | 0 |
299128 | 299128 | 2020-07-03 | Coleman | Texas | 48083 | 3 | 0 |
302292 | 302292 | 2020-07-04 | Coleman | Texas | 48083 | 3 | 0 |
305456 | 305456 | 2020-07-05 | Coleman | Texas | 48083 | 3 | 0 |
308624 | 308624 | 2020-07-06 | Coleman | Texas | 48083 | 3 | 0 |
311793 | 311793 | 2020-07-07 | Coleman | Texas | 48083 | 3 | 0 |
314967 | 314967 | 2020-07-08 | Coleman | Texas | 48083 | 4 | 0 |
318140 | 318140 | 2020-07-09 | Coleman | Texas | 48083 | 4 | 0 |
321318 | 321318 | 2020-07-10 | Coleman | Texas | 48083 | 5 | 0 |
324499 | 324499 | 2020-07-11 | Coleman | Texas | 48083 | 5 | 0 |
327684 | 327684 | 2020-07-12 | Coleman | Texas | 48083 | 5 | 0 |
330870 | 330870 | 2020-07-13 | Coleman | Texas | 48083 | 5 | 0 |
334061 | 334061 | 2020-07-14 | Coleman | Texas | 48083 | 5 | 0 |
337256 | 337256 | 2020-07-15 | Coleman | Texas | 48083 | 5 | 0 |
340452 | 340452 | 2020-07-16 | Coleman | Texas | 48083 | 5 | 0 |
343651 | 343651 | 2020-07-17 | Coleman | Texas | 48083 | 7 | 0 |
346851 | 346851 | 2020-07-18 | Coleman | Texas | 48083 | 7 | 0 |
350051 | 350051 | 2020-07-19 | Coleman | Texas | 48083 | 7 | 0 |
353253 | 353253 | 2020-07-20 | Coleman | Texas | 48083 | 7 | 0 |
356456 | 356456 | 2020-07-21 | Coleman | Texas | 48083 | 7 | 0 |
359661 | 359661 | 2020-07-22 | Coleman | Texas | 48083 | 7 | 0 |
362868 | 362868 | 2020-07-23 | Coleman | Texas | 48083 | 8 | 0 |
366074 | 366074 | 2020-07-24 | Coleman | Texas | 48083 | 8 | 0 |
369283 | 369283 | 2020-07-25 | Coleman | Texas | 48083 | 9 | 0 |
372495 | 372495 | 2020-07-26 | Coleman | Texas | 48083 | 9 | 0 |
375708 | 375708 | 2020-07-27 | Coleman | Texas | 48083 | 9 | 0 |
378924 | 378924 | 2020-07-28 | Coleman | Texas | 48083 | 10 | 0 |
382141 | 382141 | 2020-07-29 | Coleman | Texas | 48083 | 9 | 0 |
385359 | 385359 | 2020-07-30 | Coleman | Texas | 48083 | 11 | 0 |
388576 | 388576 | 2020-07-31 | Coleman | Texas | 48083 | 12 | 0 |
391793 | 391793 | 2020-08-01 | Coleman | Texas | 48083 | 11 | 0 |
395009 | 395009 | 2020-08-02 | Coleman | Texas | 48083 | 11 | 0 |
398225 | 398225 | 2020-08-03 | Coleman | Texas | 48083 | 11 | 0 |
401441 | 401441 | 2020-08-04 | Coleman | Texas | 48083 | 13 | 0 |
404659 | 404659 | 2020-08-05 | Coleman | Texas | 48083 | 16 | 0 |
407879 | 407879 | 2020-08-06 | Coleman | Texas | 48083 | 18 | 0 |
411098 | 411098 | 2020-08-07 | Coleman | Texas | 48083 | 19 | 0 |
414318 | 414318 | 2020-08-08 | Coleman | Texas | 48083 | 19 | 0 |
417539 | 417539 | 2020-08-09 | Coleman | Texas | 48083 | 19 | 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);