ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 48133 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
324524 | 324524 | 2020-07-11 | Eastland | Texas | 48133 | 20 | 0 |
321343 | 321343 | 2020-07-10 | Eastland | Texas | 48133 | 17 | 0 |
318165 | 318165 | 2020-07-09 | Eastland | Texas | 48133 | 17 | 0 |
314992 | 314992 | 2020-07-08 | Eastland | Texas | 48133 | 13 | 0 |
311818 | 311818 | 2020-07-07 | Eastland | Texas | 48133 | 11 | 0 |
308649 | 308649 | 2020-07-06 | Eastland | Texas | 48133 | 11 | 0 |
305481 | 305481 | 2020-07-05 | Eastland | Texas | 48133 | 11 | 0 |
302317 | 302317 | 2020-07-04 | Eastland | Texas | 48133 | 11 | 0 |
299153 | 299153 | 2020-07-03 | Eastland | Texas | 48133 | 11 | 0 |
295993 | 295993 | 2020-07-02 | Eastland | Texas | 48133 | 10 | 0 |
292838 | 292838 | 2020-07-01 | Eastland | Texas | 48133 | 10 | 0 |
289685 | 289685 | 2020-06-30 | Eastland | Texas | 48133 | 10 | 0 |
286535 | 286535 | 2020-06-29 | Eastland | Texas | 48133 | 9 | 0 |
283389 | 283389 | 2020-06-28 | Eastland | Texas | 48133 | 9 | 0 |
280243 | 280243 | 2020-06-27 | Eastland | Texas | 48133 | 9 | 0 |
277095 | 277095 | 2020-06-26 | Eastland | Texas | 48133 | 8 | 0 |
273948 | 273948 | 2020-06-25 | Eastland | Texas | 48133 | 8 | 0 |
270809 | 270809 | 2020-06-24 | Eastland | Texas | 48133 | 8 | 0 |
267675 | 267675 | 2020-06-23 | Eastland | Texas | 48133 | 7 | 0 |
264547 | 264547 | 2020-06-22 | Eastland | Texas | 48133 | 7 | 0 |
261419 | 261419 | 2020-06-21 | Eastland | Texas | 48133 | 7 | 0 |
258292 | 258292 | 2020-06-20 | Eastland | Texas | 48133 | 7 | 0 |
255165 | 255165 | 2020-06-19 | Eastland | Texas | 48133 | 7 | 0 |
252050 | 252050 | 2020-06-18 | Eastland | Texas | 48133 | 7 | 0 |
248935 | 248935 | 2020-06-17 | Eastland | Texas | 48133 | 7 | 0 |
245822 | 245822 | 2020-06-16 | Eastland | Texas | 48133 | 7 | 0 |
242710 | 242710 | 2020-06-15 | Eastland | Texas | 48133 | 7 | 0 |
239600 | 239600 | 2020-06-14 | Eastland | Texas | 48133 | 7 | 0 |
236492 | 236492 | 2020-06-13 | Eastland | Texas | 48133 | 7 | 0 |
233386 | 233386 | 2020-06-12 | Eastland | Texas | 48133 | 7 | 0 |
230282 | 230282 | 2020-06-11 | Eastland | Texas | 48133 | 7 | 0 |
227178 | 227178 | 2020-06-10 | Eastland | Texas | 48133 | 7 | 0 |
224078 | 224078 | 2020-06-09 | Eastland | Texas | 48133 | 7 | 0 |
220983 | 220983 | 2020-06-08 | Eastland | Texas | 48133 | 7 | 0 |
217891 | 217891 | 2020-06-07 | Eastland | Texas | 48133 | 7 | 0 |
214801 | 214801 | 2020-06-06 | Eastland | Texas | 48133 | 7 | 0 |
211714 | 211714 | 2020-06-05 | Eastland | Texas | 48133 | 7 | 0 |
208630 | 208630 | 2020-06-04 | Eastland | Texas | 48133 | 7 | 0 |
205548 | 205548 | 2020-06-03 | Eastland | Texas | 48133 | 7 | 0 |
202469 | 202469 | 2020-06-02 | Eastland | Texas | 48133 | 6 | 0 |
199394 | 199394 | 2020-06-01 | Eastland | Texas | 48133 | 6 | 0 |
196321 | 196321 | 2020-05-31 | Eastland | Texas | 48133 | 6 | 0 |
193251 | 193251 | 2020-05-30 | Eastland | Texas | 48133 | 6 | 0 |
190186 | 190186 | 2020-05-29 | Eastland | Texas | 48133 | 6 | 0 |
187122 | 187122 | 2020-05-28 | Eastland | Texas | 48133 | 6 | 0 |
184065 | 184065 | 2020-05-27 | Eastland | Texas | 48133 | 6 | 0 |
181015 | 181015 | 2020-05-26 | Eastland | Texas | 48133 | 5 | 0 |
177972 | 177972 | 2020-05-25 | Eastland | Texas | 48133 | 5 | 0 |
174928 | 174928 | 2020-05-24 | Eastland | Texas | 48133 | 5 | 0 |
171885 | 171885 | 2020-05-23 | Eastland | Texas | 48133 | 5 | 0 |
168846 | 168846 | 2020-05-22 | Eastland | Texas | 48133 | 5 | 0 |
165810 | 165810 | 2020-05-21 | Eastland | Texas | 48133 | 5 | 0 |
162781 | 162781 | 2020-05-20 | Eastland | Texas | 48133 | 5 | 0 |
159754 | 159754 | 2020-05-19 | Eastland | Texas | 48133 | 5 | 0 |
156732 | 156732 | 2020-05-18 | Eastland | Texas | 48133 | 5 | 0 |
153715 | 153715 | 2020-05-17 | Eastland | Texas | 48133 | 5 | 0 |
150704 | 150704 | 2020-05-16 | Eastland | Texas | 48133 | 5 | 0 |
147696 | 147696 | 2020-05-15 | Eastland | Texas | 48133 | 4 | 0 |
144694 | 144694 | 2020-05-14 | Eastland | Texas | 48133 | 4 | 0 |
141697 | 141697 | 2020-05-13 | Eastland | Texas | 48133 | 3 | 0 |
138701 | 138701 | 2020-05-12 | Eastland | Texas | 48133 | 3 | 0 |
135711 | 135711 | 2020-05-11 | Eastland | Texas | 48133 | 3 | 0 |
132720 | 132720 | 2020-05-10 | Eastland | Texas | 48133 | 3 | 0 |
129730 | 129730 | 2020-05-09 | Eastland | Texas | 48133 | 3 | 0 |
126741 | 126741 | 2020-05-08 | Eastland | Texas | 48133 | 3 | 0 |
123758 | 123758 | 2020-05-07 | Eastland | Texas | 48133 | 3 | 0 |
120779 | 120779 | 2020-05-06 | Eastland | Texas | 48133 | 3 | 0 |
117815 | 117815 | 2020-05-05 | Eastland | Texas | 48133 | 3 | 0 |
114856 | 114856 | 2020-05-04 | Eastland | Texas | 48133 | 3 | 0 |
111974 | 111974 | 2020-05-03 | Eastland | Texas | 48133 | 3 | 0 |
109100 | 109100 | 2020-05-02 | Eastland | Texas | 48133 | 3 | 0 |
106231 | 106231 | 2020-05-01 | Eastland | Texas | 48133 | 3 | 0 |
103367 | 103367 | 2020-04-30 | Eastland | Texas | 48133 | 3 | 0 |
100514 | 100514 | 2020-04-29 | Eastland | Texas | 48133 | 3 | 0 |
97664 | 97664 | 2020-04-28 | Eastland | Texas | 48133 | 3 | 0 |
94824 | 94824 | 2020-04-27 | Eastland | Texas | 48133 | 3 | 0 |
91995 | 91995 | 2020-04-26 | Eastland | Texas | 48133 | 3 | 0 |
89178 | 89178 | 2020-04-25 | Eastland | Texas | 48133 | 3 | 0 |
86363 | 86363 | 2020-04-24 | Eastland | Texas | 48133 | 3 | 0 |
83558 | 83558 | 2020-04-23 | Eastland | Texas | 48133 | 3 | 0 |
80758 | 80758 | 2020-04-22 | Eastland | Texas | 48133 | 3 | 0 |
77967 | 77967 | 2020-04-21 | Eastland | Texas | 48133 | 3 | 0 |
75185 | 75185 | 2020-04-20 | Eastland | Texas | 48133 | 3 | 0 |
72410 | 72410 | 2020-04-19 | Eastland | Texas | 48133 | 3 | 0 |
69642 | 69642 | 2020-04-18 | Eastland | Texas | 48133 | 3 | 0 |
66882 | 66882 | 2020-04-17 | Eastland | Texas | 48133 | 3 | 0 |
64135 | 64135 | 2020-04-16 | Eastland | Texas | 48133 | 3 | 0 |
61408 | 61408 | 2020-04-15 | Eastland | Texas | 48133 | 3 | 0 |
58691 | 58691 | 2020-04-14 | Eastland | Texas | 48133 | 3 | 0 |
55986 | 55986 | 2020-04-13 | Eastland | Texas | 48133 | 3 | 0 |
53298 | 53298 | 2020-04-12 | Eastland | Texas | 48133 | 3 | 0 |
50623 | 50623 | 2020-04-11 | Eastland | Texas | 48133 | 3 | 0 |
47965 | 47965 | 2020-04-10 | Eastland | Texas | 48133 | 3 | 0 |
45345 | 45345 | 2020-04-09 | Eastland | Texas | 48133 | 3 | 0 |
42756 | 42756 | 2020-04-08 | Eastland | Texas | 48133 | 3 | 0 |
40191 | 40191 | 2020-04-07 | Eastland | Texas | 48133 | 3 | 0 |
37666 | 37666 | 2020-04-06 | Eastland | Texas | 48133 | 3 | 0 |
35190 | 35190 | 2020-04-05 | Eastland | Texas | 48133 | 3 | 0 |
32752 | 32752 | 2020-04-04 | Eastland | Texas | 48133 | 3 | 0 |
30359 | 30359 | 2020-04-03 | Eastland | Texas | 48133 | 3 | 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);