ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where fips = 48275 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 |
---|---|---|---|---|---|---|---|
40237 | 40237 | 2020-04-07 | Knox | Texas | 48275 | 1 | 0 |
42805 | 42805 | 2020-04-08 | Knox | Texas | 48275 | 1 | 0 |
45395 | 45395 | 2020-04-09 | Knox | Texas | 48275 | 1 | 0 |
48016 | 48016 | 2020-04-10 | Knox | Texas | 48275 | 1 | 0 |
50674 | 50674 | 2020-04-11 | Knox | Texas | 48275 | 1 | 0 |
53349 | 53349 | 2020-04-12 | Knox | Texas | 48275 | 1 | 0 |
56037 | 56037 | 2020-04-13 | Knox | Texas | 48275 | 1 | 0 |
58742 | 58742 | 2020-04-14 | Knox | Texas | 48275 | 1 | 0 |
61460 | 61460 | 2020-04-15 | Knox | Texas | 48275 | 1 | 0 |
64187 | 64187 | 2020-04-16 | Knox | Texas | 48275 | 1 | 0 |
66934 | 66934 | 2020-04-17 | Knox | Texas | 48275 | 1 | 0 |
69694 | 69694 | 2020-04-18 | Knox | Texas | 48275 | 1 | 0 |
72463 | 72463 | 2020-04-19 | Knox | Texas | 48275 | 1 | 0 |
75239 | 75239 | 2020-04-20 | Knox | Texas | 48275 | 1 | 0 |
78021 | 78021 | 2020-04-21 | Knox | Texas | 48275 | 1 | 0 |
80812 | 80812 | 2020-04-22 | Knox | Texas | 48275 | 1 | 0 |
83613 | 83613 | 2020-04-23 | Knox | Texas | 48275 | 1 | 0 |
86418 | 86418 | 2020-04-24 | Knox | Texas | 48275 | 1 | 0 |
89233 | 89233 | 2020-04-25 | Knox | Texas | 48275 | 1 | 0 |
92050 | 92050 | 2020-04-26 | Knox | Texas | 48275 | 1 | 0 |
94879 | 94879 | 2020-04-27 | Knox | Texas | 48275 | 1 | 0 |
97719 | 97719 | 2020-04-28 | Knox | Texas | 48275 | 1 | 0 |
100569 | 100569 | 2020-04-29 | Knox | Texas | 48275 | 1 | 0 |
103424 | 103424 | 2020-04-30 | Knox | Texas | 48275 | 1 | 0 |
106288 | 106288 | 2020-05-01 | Knox | Texas | 48275 | 1 | 0 |
109157 | 109157 | 2020-05-02 | Knox | Texas | 48275 | 1 | 0 |
112031 | 112031 | 2020-05-03 | Knox | Texas | 48275 | 1 | 0 |
114913 | 114913 | 2020-05-04 | Knox | Texas | 48275 | 1 | 0 |
117872 | 117872 | 2020-05-05 | Knox | Texas | 48275 | 1 | 0 |
120836 | 120836 | 2020-05-06 | Knox | Texas | 48275 | 1 | 0 |
123815 | 123815 | 2020-05-07 | Knox | Texas | 48275 | 1 | 0 |
126799 | 126799 | 2020-05-08 | Knox | Texas | 48275 | 1 | 0 |
129788 | 129788 | 2020-05-09 | Knox | Texas | 48275 | 1 | 0 |
132778 | 132778 | 2020-05-10 | Knox | Texas | 48275 | 1 | 0 |
135769 | 135769 | 2020-05-11 | Knox | Texas | 48275 | 1 | 0 |
138759 | 138759 | 2020-05-12 | Knox | Texas | 48275 | 1 | 0 |
141755 | 141755 | 2020-05-13 | Knox | Texas | 48275 | 1 | 0 |
144752 | 144752 | 2020-05-14 | Knox | Texas | 48275 | 1 | 0 |
147756 | 147756 | 2020-05-15 | Knox | Texas | 48275 | 1 | 0 |
150764 | 150764 | 2020-05-16 | Knox | Texas | 48275 | 1 | 0 |
153775 | 153775 | 2020-05-17 | Knox | Texas | 48275 | 1 | 0 |
156792 | 156792 | 2020-05-18 | Knox | Texas | 48275 | 1 | 0 |
159814 | 159814 | 2020-05-19 | Knox | Texas | 48275 | 1 | 0 |
162842 | 162842 | 2020-05-20 | Knox | Texas | 48275 | 1 | 0 |
165871 | 165871 | 2020-05-21 | Knox | Texas | 48275 | 1 | 0 |
168907 | 168907 | 2020-05-22 | Knox | Texas | 48275 | 1 | 0 |
171947 | 171947 | 2020-05-23 | Knox | Texas | 48275 | 1 | 0 |
174990 | 174990 | 2020-05-24 | Knox | Texas | 48275 | 1 | 0 |
178034 | 178034 | 2020-05-25 | Knox | Texas | 48275 | 1 | 0 |
181078 | 181078 | 2020-05-26 | Knox | Texas | 48275 | 1 | 0 |
184128 | 184128 | 2020-05-27 | Knox | Texas | 48275 | 1 | 0 |
187185 | 187185 | 2020-05-28 | Knox | Texas | 48275 | 1 | 0 |
190249 | 190249 | 2020-05-29 | Knox | Texas | 48275 | 1 | 0 |
193315 | 193315 | 2020-05-30 | Knox | Texas | 48275 | 1 | 0 |
196385 | 196385 | 2020-05-31 | Knox | Texas | 48275 | 1 | 0 |
199458 | 199458 | 2020-06-01 | Knox | Texas | 48275 | 1 | 0 |
202534 | 202534 | 2020-06-02 | Knox | Texas | 48275 | 1 | 0 |
205613 | 205613 | 2020-06-03 | Knox | Texas | 48275 | 1 | 0 |
208695 | 208695 | 2020-06-04 | Knox | Texas | 48275 | 1 | 0 |
211779 | 211779 | 2020-06-05 | Knox | Texas | 48275 | 1 | 0 |
214866 | 214866 | 2020-06-06 | Knox | Texas | 48275 | 1 | 0 |
217956 | 217956 | 2020-06-07 | Knox | Texas | 48275 | 1 | 0 |
221048 | 221048 | 2020-06-08 | Knox | Texas | 48275 | 1 | 0 |
224143 | 224143 | 2020-06-09 | Knox | Texas | 48275 | 1 | 0 |
227243 | 227243 | 2020-06-10 | Knox | Texas | 48275 | 1 | 0 |
230347 | 230347 | 2020-06-11 | Knox | Texas | 48275 | 1 | 0 |
233451 | 233451 | 2020-06-12 | Knox | Texas | 48275 | 1 | 0 |
236557 | 236557 | 2020-06-13 | Knox | Texas | 48275 | 1 | 0 |
239665 | 239665 | 2020-06-14 | Knox | Texas | 48275 | 1 | 0 |
242775 | 242775 | 2020-06-15 | Knox | Texas | 48275 | 1 | 0 |
245887 | 245887 | 2020-06-16 | Knox | Texas | 48275 | 1 | 0 |
249000 | 249000 | 2020-06-17 | Knox | Texas | 48275 | 1 | 0 |
252115 | 252115 | 2020-06-18 | Knox | Texas | 48275 | 1 | 0 |
255230 | 255230 | 2020-06-19 | Knox | Texas | 48275 | 1 | 0 |
258357 | 258357 | 2020-06-20 | Knox | Texas | 48275 | 1 | 0 |
261484 | 261484 | 2020-06-21 | Knox | Texas | 48275 | 1 | 0 |
264612 | 264612 | 2020-06-22 | Knox | Texas | 48275 | 1 | 0 |
267740 | 267740 | 2020-06-23 | Knox | Texas | 48275 | 1 | 0 |
270874 | 270874 | 2020-06-24 | Knox | Texas | 48275 | 1 | 0 |
274014 | 274014 | 2020-06-25 | Knox | Texas | 48275 | 1 | 0 |
277162 | 277162 | 2020-06-26 | Knox | Texas | 48275 | 1 | 0 |
280310 | 280310 | 2020-06-27 | Knox | Texas | 48275 | 1 | 0 |
283456 | 283456 | 2020-06-28 | Knox | Texas | 48275 | 1 | 0 |
286602 | 286602 | 2020-06-29 | Knox | Texas | 48275 | 1 | 0 |
289752 | 289752 | 2020-06-30 | Knox | Texas | 48275 | 3 | 0 |
292905 | 292905 | 2020-07-01 | Knox | Texas | 48275 | 3 | 0 |
296060 | 296060 | 2020-07-02 | Knox | Texas | 48275 | 3 | 0 |
299221 | 299221 | 2020-07-03 | Knox | Texas | 48275 | 3 | 0 |
302385 | 302385 | 2020-07-04 | Knox | Texas | 48275 | 3 | 0 |
305549 | 305549 | 2020-07-05 | Knox | Texas | 48275 | 3 | 0 |
308717 | 308717 | 2020-07-06 | Knox | Texas | 48275 | 3 | 0 |
311886 | 311886 | 2020-07-07 | Knox | Texas | 48275 | 4 | 0 |
315060 | 315060 | 2020-07-08 | Knox | Texas | 48275 | 5 | 0 |
318233 | 318233 | 2020-07-09 | Knox | Texas | 48275 | 5 | 0 |
321412 | 321412 | 2020-07-10 | Knox | Texas | 48275 | 6 | 0 |
324593 | 324593 | 2020-07-11 | Knox | Texas | 48275 | 6 | 0 |
327778 | 327778 | 2020-07-12 | Knox | Texas | 48275 | 6 | 0 |
330964 | 330964 | 2020-07-13 | Knox | Texas | 48275 | 6 | 0 |
334156 | 334156 | 2020-07-14 | Knox | Texas | 48275 | 10 | 0 |
337351 | 337351 | 2020-07-15 | Knox | Texas | 48275 | 11 | 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);