ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where county = "Crosby" 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 |
---|---|---|---|---|---|---|---|
40183 | 40183 | 2020-04-07 | Crosby | Texas | 48107 | 1 | 0 |
42746 | 42746 | 2020-04-08 | Crosby | Texas | 48107 | 1 | 0 |
45335 | 45335 | 2020-04-09 | Crosby | Texas | 48107 | 1 | 0 |
47955 | 47955 | 2020-04-10 | Crosby | Texas | 48107 | 1 | 0 |
50612 | 50612 | 2020-04-11 | Crosby | Texas | 48107 | 1 | 0 |
53287 | 53287 | 2020-04-12 | Crosby | Texas | 48107 | 1 | 0 |
55975 | 55975 | 2020-04-13 | Crosby | Texas | 48107 | 1 | 0 |
58679 | 58679 | 2020-04-14 | Crosby | Texas | 48107 | 1 | 0 |
61396 | 61396 | 2020-04-15 | Crosby | Texas | 48107 | 1 | 1 |
64123 | 64123 | 2020-04-16 | Crosby | Texas | 48107 | 1 | 1 |
66870 | 66870 | 2020-04-17 | Crosby | Texas | 48107 | 1 | 1 |
69630 | 69630 | 2020-04-18 | Crosby | Texas | 48107 | 1 | 1 |
72398 | 72398 | 2020-04-19 | Crosby | Texas | 48107 | 1 | 1 |
75173 | 75173 | 2020-04-20 | Crosby | Texas | 48107 | 1 | 1 |
77955 | 77955 | 2020-04-21 | Crosby | Texas | 48107 | 1 | 1 |
80746 | 80746 | 2020-04-22 | Crosby | Texas | 48107 | 1 | 1 |
83546 | 83546 | 2020-04-23 | Crosby | Texas | 48107 | 1 | 1 |
86351 | 86351 | 2020-04-24 | Crosby | Texas | 48107 | 2 | 1 |
89166 | 89166 | 2020-04-25 | Crosby | Texas | 48107 | 2 | 1 |
91983 | 91983 | 2020-04-26 | Crosby | Texas | 48107 | 2 | 1 |
94812 | 94812 | 2020-04-27 | Crosby | Texas | 48107 | 2 | 1 |
97652 | 97652 | 2020-04-28 | Crosby | Texas | 48107 | 2 | 1 |
100502 | 100502 | 2020-04-29 | Crosby | Texas | 48107 | 2 | 1 |
103355 | 103355 | 2020-04-30 | Crosby | Texas | 48107 | 2 | 1 |
106219 | 106219 | 2020-05-01 | Crosby | Texas | 48107 | 2 | 1 |
109088 | 109088 | 2020-05-02 | Crosby | Texas | 48107 | 2 | 1 |
111962 | 111962 | 2020-05-03 | Crosby | Texas | 48107 | 2 | 1 |
114844 | 114844 | 2020-05-04 | Crosby | Texas | 48107 | 2 | 1 |
117803 | 117803 | 2020-05-05 | Crosby | Texas | 48107 | 2 | 1 |
120767 | 120767 | 2020-05-06 | Crosby | Texas | 48107 | 2 | 1 |
123746 | 123746 | 2020-05-07 | Crosby | Texas | 48107 | 2 | 1 |
126729 | 126729 | 2020-05-08 | Crosby | Texas | 48107 | 2 | 1 |
129718 | 129718 | 2020-05-09 | Crosby | Texas | 48107 | 2 | 1 |
132708 | 132708 | 2020-05-10 | Crosby | Texas | 48107 | 2 | 1 |
135699 | 135699 | 2020-05-11 | Crosby | Texas | 48107 | 2 | 1 |
138689 | 138689 | 2020-05-12 | Crosby | Texas | 48107 | 2 | 1 |
141685 | 141685 | 2020-05-13 | Crosby | Texas | 48107 | 2 | 1 |
144682 | 144682 | 2020-05-14 | Crosby | Texas | 48107 | 2 | 1 |
147684 | 147684 | 2020-05-15 | Crosby | Texas | 48107 | 2 | 1 |
150692 | 150692 | 2020-05-16 | Crosby | Texas | 48107 | 2 | 1 |
153703 | 153703 | 2020-05-17 | Crosby | Texas | 48107 | 3 | 1 |
156720 | 156720 | 2020-05-18 | Crosby | Texas | 48107 | 3 | 1 |
159742 | 159742 | 2020-05-19 | Crosby | Texas | 48107 | 3 | 1 |
162769 | 162769 | 2020-05-20 | Crosby | Texas | 48107 | 3 | 1 |
165798 | 165798 | 2020-05-21 | Crosby | Texas | 48107 | 3 | 1 |
168834 | 168834 | 2020-05-22 | Crosby | Texas | 48107 | 3 | 1 |
171873 | 171873 | 2020-05-23 | Crosby | Texas | 48107 | 3 | 1 |
174916 | 174916 | 2020-05-24 | Crosby | Texas | 48107 | 3 | 1 |
177960 | 177960 | 2020-05-25 | Crosby | Texas | 48107 | 3 | 1 |
181003 | 181003 | 2020-05-26 | Crosby | Texas | 48107 | 3 | 1 |
184053 | 184053 | 2020-05-27 | Crosby | Texas | 48107 | 3 | 1 |
187110 | 187110 | 2020-05-28 | Crosby | Texas | 48107 | 3 | 1 |
190174 | 190174 | 2020-05-29 | Crosby | Texas | 48107 | 3 | 1 |
193239 | 193239 | 2020-05-30 | Crosby | Texas | 48107 | 4 | 1 |
196309 | 196309 | 2020-05-31 | Crosby | Texas | 48107 | 4 | 1 |
199382 | 199382 | 2020-06-01 | Crosby | Texas | 48107 | 4 | 1 |
202457 | 202457 | 2020-06-02 | Crosby | Texas | 48107 | 4 | 1 |
205536 | 205536 | 2020-06-03 | Crosby | Texas | 48107 | 3 | 1 |
208618 | 208618 | 2020-06-04 | Crosby | Texas | 48107 | 3 | 1 |
211702 | 211702 | 2020-06-05 | Crosby | Texas | 48107 | 3 | 1 |
214789 | 214789 | 2020-06-06 | Crosby | Texas | 48107 | 3 | 1 |
217879 | 217879 | 2020-06-07 | Crosby | Texas | 48107 | 3 | 1 |
220971 | 220971 | 2020-06-08 | Crosby | Texas | 48107 | 3 | 1 |
224066 | 224066 | 2020-06-09 | Crosby | Texas | 48107 | 3 | 1 |
227166 | 227166 | 2020-06-10 | Crosby | Texas | 48107 | 4 | 1 |
230270 | 230270 | 2020-06-11 | Crosby | Texas | 48107 | 4 | 1 |
233374 | 233374 | 2020-06-12 | Crosby | Texas | 48107 | 4 | 1 |
236480 | 236480 | 2020-06-13 | Crosby | Texas | 48107 | 4 | 1 |
239588 | 239588 | 2020-06-14 | Crosby | Texas | 48107 | 4 | 1 |
242698 | 242698 | 2020-06-15 | Crosby | Texas | 48107 | 4 | 1 |
245810 | 245810 | 2020-06-16 | Crosby | Texas | 48107 | 7 | 1 |
248923 | 248923 | 2020-06-17 | Crosby | Texas | 48107 | 8 | 1 |
252038 | 252038 | 2020-06-18 | Crosby | Texas | 48107 | 8 | 1 |
255153 | 255153 | 2020-06-19 | Crosby | Texas | 48107 | 8 | 1 |
258279 | 258279 | 2020-06-20 | Crosby | Texas | 48107 | 8 | 1 |
261406 | 261406 | 2020-06-21 | Crosby | Texas | 48107 | 8 | 1 |
264534 | 264534 | 2020-06-22 | Crosby | Texas | 48107 | 8 | 1 |
267662 | 267662 | 2020-06-23 | Crosby | Texas | 48107 | 9 | 1 |
270796 | 270796 | 2020-06-24 | Crosby | Texas | 48107 | 13 | 1 |
273935 | 273935 | 2020-06-25 | Crosby | Texas | 48107 | 13 | 1 |
277082 | 277082 | 2020-06-26 | Crosby | Texas | 48107 | 15 | 1 |
280230 | 280230 | 2020-06-27 | Crosby | Texas | 48107 | 15 | 1 |
283376 | 283376 | 2020-06-28 | Crosby | Texas | 48107 | 15 | 1 |
286522 | 286522 | 2020-06-29 | Crosby | Texas | 48107 | 15 | 1 |
289672 | 289672 | 2020-06-30 | Crosby | Texas | 48107 | 21 | 1 |
292825 | 292825 | 2020-07-01 | Crosby | Texas | 48107 | 25 | 1 |
295980 | 295980 | 2020-07-02 | Crosby | Texas | 48107 | 26 | 1 |
299140 | 299140 | 2020-07-03 | Crosby | Texas | 48107 | 26 | 1 |
302304 | 302304 | 2020-07-04 | Crosby | Texas | 48107 | 26 | 1 |
305468 | 305468 | 2020-07-05 | Crosby | Texas | 48107 | 26 | 1 |
308636 | 308636 | 2020-07-06 | Crosby | Texas | 48107 | 26 | 1 |
311805 | 311805 | 2020-07-07 | Crosby | Texas | 48107 | 28 | 1 |
314979 | 314979 | 2020-07-08 | Crosby | Texas | 48107 | 30 | 1 |
318152 | 318152 | 2020-07-09 | Crosby | Texas | 48107 | 34 | 1 |
321330 | 321330 | 2020-07-10 | Crosby | Texas | 48107 | 33 | 1 |
324511 | 324511 | 2020-07-11 | Crosby | Texas | 48107 | 35 | 2 |
327696 | 327696 | 2020-07-12 | Crosby | Texas | 48107 | 35 | 2 |
330882 | 330882 | 2020-07-13 | Crosby | Texas | 48107 | 35 | 2 |
334073 | 334073 | 2020-07-14 | Crosby | Texas | 48107 | 35 | 2 |
337268 | 337268 | 2020-07-15 | Crosby | Texas | 48107 | 35 | 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);