ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 48285 and state = "Texas" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4307 | 4307 | 2020-03-18 | Lavaca | Texas | 48285 | 1 | 0 |
5062 | 5062 | 2020-03-19 | Lavaca | Texas | 48285 | 1 | 0 |
5955 | 5955 | 2020-03-20 | Lavaca | Texas | 48285 | 1 | 0 |
6975 | 6975 | 2020-03-21 | Lavaca | Texas | 48285 | 1 | 0 |
8105 | 8105 | 2020-03-22 | Lavaca | Texas | 48285 | 1 | 0 |
9323 | 9323 | 2020-03-23 | Lavaca | Texas | 48285 | 1 | 0 |
10663 | 10663 | 2020-03-24 | Lavaca | Texas | 48285 | 1 | 0 |
12161 | 12161 | 2020-03-25 | Lavaca | Texas | 48285 | 1 | 0 |
13792 | 13792 | 2020-03-26 | Lavaca | Texas | 48285 | 1 | 0 |
15548 | 15548 | 2020-03-27 | Lavaca | Texas | 48285 | 1 | 0 |
17418 | 17418 | 2020-03-28 | Lavaca | Texas | 48285 | 3 | 0 |
19373 | 19373 | 2020-03-29 | Lavaca | Texas | 48285 | 1 | 0 |
21433 | 21433 | 2020-03-30 | Lavaca | Texas | 48285 | 1 | 0 |
23572 | 23572 | 2020-03-31 | Lavaca | Texas | 48285 | 1 | 0 |
25783 | 25783 | 2020-04-01 | Lavaca | Texas | 48285 | 1 | 0 |
28068 | 28068 | 2020-04-02 | Lavaca | Texas | 48285 | 1 | 0 |
30404 | 30404 | 2020-04-03 | Lavaca | Texas | 48285 | 1 | 0 |
32799 | 32799 | 2020-04-04 | Lavaca | Texas | 48285 | 2 | 0 |
35237 | 35237 | 2020-04-05 | Lavaca | Texas | 48285 | 2 | 0 |
37713 | 37713 | 2020-04-06 | Lavaca | Texas | 48285 | 2 | 0 |
40241 | 40241 | 2020-04-07 | Lavaca | Texas | 48285 | 2 | 0 |
42809 | 42809 | 2020-04-08 | Lavaca | Texas | 48285 | 2 | 0 |
45399 | 45399 | 2020-04-09 | Lavaca | Texas | 48285 | 4 | 0 |
48020 | 48020 | 2020-04-10 | Lavaca | Texas | 48285 | 4 | 0 |
50678 | 50678 | 2020-04-11 | Lavaca | Texas | 48285 | 4 | 0 |
53353 | 53353 | 2020-04-12 | Lavaca | Texas | 48285 | 4 | 0 |
56041 | 56041 | 2020-04-13 | Lavaca | Texas | 48285 | 4 | 0 |
58746 | 58746 | 2020-04-14 | Lavaca | Texas | 48285 | 4 | 0 |
61464 | 61464 | 2020-04-15 | Lavaca | Texas | 48285 | 4 | 0 |
64192 | 64192 | 2020-04-16 | Lavaca | Texas | 48285 | 4 | 0 |
66939 | 66939 | 2020-04-17 | Lavaca | Texas | 48285 | 4 | 0 |
69699 | 69699 | 2020-04-18 | Lavaca | Texas | 48285 | 4 | 0 |
72468 | 72468 | 2020-04-19 | Lavaca | Texas | 48285 | 4 | 0 |
75244 | 75244 | 2020-04-20 | Lavaca | Texas | 48285 | 4 | 0 |
78026 | 78026 | 2020-04-21 | Lavaca | Texas | 48285 | 4 | 0 |
80817 | 80817 | 2020-04-22 | Lavaca | Texas | 48285 | 4 | 0 |
83618 | 83618 | 2020-04-23 | Lavaca | Texas | 48285 | 5 | 0 |
86423 | 86423 | 2020-04-24 | Lavaca | Texas | 48285 | 5 | 0 |
89238 | 89238 | 2020-04-25 | Lavaca | Texas | 48285 | 5 | 1 |
92055 | 92055 | 2020-04-26 | Lavaca | Texas | 48285 | 5 | 1 |
94884 | 94884 | 2020-04-27 | Lavaca | Texas | 48285 | 5 | 1 |
97724 | 97724 | 2020-04-28 | Lavaca | Texas | 48285 | 5 | 1 |
100574 | 100574 | 2020-04-29 | Lavaca | Texas | 48285 | 5 | 1 |
103429 | 103429 | 2020-04-30 | Lavaca | Texas | 48285 | 6 | 1 |
106293 | 106293 | 2020-05-01 | Lavaca | Texas | 48285 | 6 | 1 |
109162 | 109162 | 2020-05-02 | Lavaca | Texas | 48285 | 6 | 1 |
112036 | 112036 | 2020-05-03 | Lavaca | Texas | 48285 | 6 | 1 |
114918 | 114918 | 2020-05-04 | Lavaca | Texas | 48285 | 6 | 1 |
117877 | 117877 | 2020-05-05 | Lavaca | Texas | 48285 | 6 | 1 |
120841 | 120841 | 2020-05-06 | Lavaca | Texas | 48285 | 6 | 1 |
123820 | 123820 | 2020-05-07 | Lavaca | Texas | 48285 | 6 | 1 |
126804 | 126804 | 2020-05-08 | Lavaca | Texas | 48285 | 6 | 1 |
129793 | 129793 | 2020-05-09 | Lavaca | Texas | 48285 | 6 | 1 |
132783 | 132783 | 2020-05-10 | Lavaca | Texas | 48285 | 6 | 1 |
135774 | 135774 | 2020-05-11 | Lavaca | Texas | 48285 | 6 | 1 |
138764 | 138764 | 2020-05-12 | Lavaca | Texas | 48285 | 6 | 1 |
141760 | 141760 | 2020-05-13 | Lavaca | Texas | 48285 | 7 | 1 |
144757 | 144757 | 2020-05-14 | Lavaca | Texas | 48285 | 7 | 1 |
147761 | 147761 | 2020-05-15 | Lavaca | Texas | 48285 | 7 | 1 |
150769 | 150769 | 2020-05-16 | Lavaca | Texas | 48285 | 8 | 1 |
153780 | 153780 | 2020-05-17 | Lavaca | Texas | 48285 | 8 | 1 |
156797 | 156797 | 2020-05-18 | Lavaca | Texas | 48285 | 8 | 1 |
159819 | 159819 | 2020-05-19 | Lavaca | Texas | 48285 | 8 | 1 |
162847 | 162847 | 2020-05-20 | Lavaca | Texas | 48285 | 8 | 1 |
165876 | 165876 | 2020-05-21 | Lavaca | Texas | 48285 | 8 | 1 |
168912 | 168912 | 2020-05-22 | Lavaca | Texas | 48285 | 8 | 1 |
171952 | 171952 | 2020-05-23 | Lavaca | Texas | 48285 | 8 | 1 |
174995 | 174995 | 2020-05-24 | Lavaca | Texas | 48285 | 9 | 1 |
178039 | 178039 | 2020-05-25 | Lavaca | Texas | 48285 | 9 | 1 |
181083 | 181083 | 2020-05-26 | Lavaca | Texas | 48285 | 9 | 1 |
184133 | 184133 | 2020-05-27 | Lavaca | Texas | 48285 | 11 | 1 |
187190 | 187190 | 2020-05-28 | Lavaca | Texas | 48285 | 11 | 1 |
190254 | 190254 | 2020-05-29 | Lavaca | Texas | 48285 | 11 | 1 |
193320 | 193320 | 2020-05-30 | Lavaca | Texas | 48285 | 12 | 1 |
196390 | 196390 | 2020-05-31 | Lavaca | Texas | 48285 | 12 | 1 |
199463 | 199463 | 2020-06-01 | Lavaca | Texas | 48285 | 12 | 1 |
202539 | 202539 | 2020-06-02 | Lavaca | Texas | 48285 | 13 | 1 |
205618 | 205618 | 2020-06-03 | Lavaca | Texas | 48285 | 14 | 1 |
208700 | 208700 | 2020-06-04 | Lavaca | Texas | 48285 | 17 | 1 |
211784 | 211784 | 2020-06-05 | Lavaca | Texas | 48285 | 18 | 1 |
214871 | 214871 | 2020-06-06 | Lavaca | Texas | 48285 | 19 | 1 |
217961 | 217961 | 2020-06-07 | Lavaca | Texas | 48285 | 19 | 1 |
221053 | 221053 | 2020-06-08 | Lavaca | Texas | 48285 | 19 | 1 |
224148 | 224148 | 2020-06-09 | Lavaca | Texas | 48285 | 19 | 1 |
227248 | 227248 | 2020-06-10 | Lavaca | Texas | 48285 | 20 | 1 |
230352 | 230352 | 2020-06-11 | Lavaca | Texas | 48285 | 21 | 1 |
233456 | 233456 | 2020-06-12 | Lavaca | Texas | 48285 | 21 | 1 |
236562 | 236562 | 2020-06-13 | Lavaca | Texas | 48285 | 22 | 1 |
239670 | 239670 | 2020-06-14 | Lavaca | Texas | 48285 | 22 | 1 |
242780 | 242780 | 2020-06-15 | Lavaca | Texas | 48285 | 22 | 1 |
245892 | 245892 | 2020-06-16 | Lavaca | Texas | 48285 | 22 | 1 |
249005 | 249005 | 2020-06-17 | Lavaca | Texas | 48285 | 22 | 1 |
252120 | 252120 | 2020-06-18 | Lavaca | Texas | 48285 | 22 | 1 |
255235 | 255235 | 2020-06-19 | Lavaca | Texas | 48285 | 43 | 1 |
258362 | 258362 | 2020-06-20 | Lavaca | Texas | 48285 | 68 | 1 |
261489 | 261489 | 2020-06-21 | Lavaca | Texas | 48285 | 85 | 1 |
264617 | 264617 | 2020-06-22 | Lavaca | Texas | 48285 | 85 | 1 |
267745 | 267745 | 2020-06-23 | Lavaca | Texas | 48285 | 86 | 1 |
270879 | 270879 | 2020-06-24 | Lavaca | Texas | 48285 | 99 | 1 |
274019 | 274019 | 2020-06-25 | Lavaca | Texas | 48285 | 108 | 1 |
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);