ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "San Patricio" 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 |
---|---|---|---|---|---|---|---|
12181 | 12181 | 2020-03-25 | San Patricio | Texas | 48409 | 1 | 0 |
13815 | 13815 | 2020-03-26 | San Patricio | Texas | 48409 | 1 | 0 |
15574 | 15574 | 2020-03-27 | San Patricio | Texas | 48409 | 1 | 0 |
17445 | 17445 | 2020-03-28 | San Patricio | Texas | 48409 | 1 | 0 |
19402 | 19402 | 2020-03-29 | San Patricio | Texas | 48409 | 1 | 0 |
21464 | 21464 | 2020-03-30 | San Patricio | Texas | 48409 | 1 | 0 |
23603 | 23603 | 2020-03-31 | San Patricio | Texas | 48409 | 1 | 0 |
25817 | 25817 | 2020-04-01 | San Patricio | Texas | 48409 | 2 | 0 |
28105 | 28105 | 2020-04-02 | San Patricio | Texas | 48409 | 2 | 0 |
30441 | 30441 | 2020-04-03 | San Patricio | Texas | 48409 | 3 | 0 |
32837 | 32837 | 2020-04-04 | San Patricio | Texas | 48409 | 4 | 0 |
35275 | 35275 | 2020-04-05 | San Patricio | Texas | 48409 | 5 | 0 |
37752 | 37752 | 2020-04-06 | San Patricio | Texas | 48409 | 7 | 0 |
40281 | 40281 | 2020-04-07 | San Patricio | Texas | 48409 | 7 | 0 |
42849 | 42849 | 2020-04-08 | San Patricio | Texas | 48409 | 7 | 0 |
45442 | 45442 | 2020-04-09 | San Patricio | Texas | 48409 | 7 | 0 |
48064 | 48064 | 2020-04-10 | San Patricio | Texas | 48409 | 7 | 0 |
50722 | 50722 | 2020-04-11 | San Patricio | Texas | 48409 | 7 | 0 |
53397 | 53397 | 2020-04-12 | San Patricio | Texas | 48409 | 7 | 0 |
56086 | 56086 | 2020-04-13 | San Patricio | Texas | 48409 | 7 | 0 |
61509 | 61509 | 2020-04-15 | San Patricio | Texas | 48409 | 8 | 0 |
64240 | 64240 | 2020-04-16 | San Patricio | Texas | 48409 | 8 | 0 |
66987 | 66987 | 2020-04-17 | San Patricio | Texas | 48409 | 8 | 0 |
69747 | 69747 | 2020-04-18 | San Patricio | Texas | 48409 | 8 | 0 |
72517 | 72517 | 2020-04-19 | San Patricio | Texas | 48409 | 8 | 0 |
75293 | 75293 | 2020-04-20 | San Patricio | Texas | 48409 | 8 | 0 |
78075 | 78075 | 2020-04-21 | San Patricio | Texas | 48409 | 8 | 0 |
58791 | 58791 | 2020-04-14 | San Patricio | Texas | 48409 | 9 | 0 |
80866 | 80866 | 2020-04-22 | San Patricio | Texas | 48409 | 9 | 0 |
83667 | 83667 | 2020-04-23 | San Patricio | Texas | 48409 | 11 | 0 |
86474 | 86474 | 2020-04-24 | San Patricio | Texas | 48409 | 11 | 0 |
89289 | 89289 | 2020-04-25 | San Patricio | Texas | 48409 | 12 | 0 |
92106 | 92106 | 2020-04-26 | San Patricio | Texas | 48409 | 12 | 0 |
94935 | 94935 | 2020-04-27 | San Patricio | Texas | 48409 | 12 | 0 |
100627 | 100627 | 2020-04-29 | San Patricio | Texas | 48409 | 12 | 0 |
103482 | 103482 | 2020-04-30 | San Patricio | Texas | 48409 | 12 | 0 |
106346 | 106346 | 2020-05-01 | San Patricio | Texas | 48409 | 12 | 0 |
109215 | 109215 | 2020-05-02 | San Patricio | Texas | 48409 | 12 | 0 |
112089 | 112089 | 2020-05-03 | San Patricio | Texas | 48409 | 12 | 0 |
97777 | 97777 | 2020-04-28 | San Patricio | Texas | 48409 | 13 | 0 |
114972 | 114972 | 2020-05-04 | San Patricio | Texas | 48409 | 13 | 0 |
117931 | 117931 | 2020-05-05 | San Patricio | Texas | 48409 | 13 | 0 |
120895 | 120895 | 2020-05-06 | San Patricio | Texas | 48409 | 14 | 0 |
123874 | 123874 | 2020-05-07 | San Patricio | Texas | 48409 | 16 | 0 |
126859 | 126859 | 2020-05-08 | San Patricio | Texas | 48409 | 16 | 0 |
129848 | 129848 | 2020-05-09 | San Patricio | Texas | 48409 | 18 | 0 |
132838 | 132838 | 2020-05-10 | San Patricio | Texas | 48409 | 20 | 0 |
135829 | 135829 | 2020-05-11 | San Patricio | Texas | 48409 | 22 | 0 |
138819 | 138819 | 2020-05-12 | San Patricio | Texas | 48409 | 22 | 0 |
141815 | 141815 | 2020-05-13 | San Patricio | Texas | 48409 | 22 | 0 |
144812 | 144812 | 2020-05-14 | San Patricio | Texas | 48409 | 23 | 0 |
147816 | 147816 | 2020-05-15 | San Patricio | Texas | 48409 | 25 | 0 |
150824 | 150824 | 2020-05-16 | San Patricio | Texas | 48409 | 25 | 0 |
153835 | 153835 | 2020-05-17 | San Patricio | Texas | 48409 | 26 | 0 |
156852 | 156852 | 2020-05-18 | San Patricio | Texas | 48409 | 26 | 0 |
159875 | 159875 | 2020-05-19 | San Patricio | Texas | 48409 | 26 | 0 |
162903 | 162903 | 2020-05-20 | San Patricio | Texas | 48409 | 26 | 0 |
165932 | 165932 | 2020-05-21 | San Patricio | Texas | 48409 | 28 | 0 |
168968 | 168968 | 2020-05-22 | San Patricio | Texas | 48409 | 28 | 0 |
172008 | 172008 | 2020-05-23 | San Patricio | Texas | 48409 | 28 | 0 |
175051 | 175051 | 2020-05-24 | San Patricio | Texas | 48409 | 28 | 0 |
178096 | 178096 | 2020-05-25 | San Patricio | Texas | 48409 | 28 | 0 |
181140 | 181140 | 2020-05-26 | San Patricio | Texas | 48409 | 28 | 0 |
184191 | 184191 | 2020-05-27 | San Patricio | Texas | 48409 | 29 | 0 |
187248 | 187248 | 2020-05-28 | San Patricio | Texas | 48409 | 32 | 0 |
190312 | 190312 | 2020-05-29 | San Patricio | Texas | 48409 | 33 | 0 |
193378 | 193378 | 2020-05-30 | San Patricio | Texas | 48409 | 33 | 0 |
196448 | 196448 | 2020-05-31 | San Patricio | Texas | 48409 | 33 | 0 |
199521 | 199521 | 2020-06-01 | San Patricio | Texas | 48409 | 33 | 0 |
202597 | 202597 | 2020-06-02 | San Patricio | Texas | 48409 | 36 | 0 |
205676 | 205676 | 2020-06-03 | San Patricio | Texas | 48409 | 36 | 0 |
208758 | 208758 | 2020-06-04 | San Patricio | Texas | 48409 | 36 | 0 |
211843 | 211843 | 2020-06-05 | San Patricio | Texas | 48409 | 38 | 0 |
214930 | 214930 | 2020-06-06 | San Patricio | Texas | 48409 | 38 | 0 |
218020 | 218020 | 2020-06-07 | San Patricio | Texas | 48409 | 39 | 0 |
221112 | 221112 | 2020-06-08 | San Patricio | Texas | 48409 | 39 | 0 |
224207 | 224207 | 2020-06-09 | San Patricio | Texas | 48409 | 41 | 0 |
227307 | 227307 | 2020-06-10 | San Patricio | Texas | 48409 | 41 | 0 |
230411 | 230411 | 2020-06-11 | San Patricio | Texas | 48409 | 41 | 0 |
233515 | 233515 | 2020-06-12 | San Patricio | Texas | 48409 | 41 | 0 |
236621 | 236621 | 2020-06-13 | San Patricio | Texas | 48409 | 41 | 0 |
239729 | 239729 | 2020-06-14 | San Patricio | Texas | 48409 | 41 | 0 |
242839 | 242839 | 2020-06-15 | San Patricio | Texas | 48409 | 41 | 0 |
245951 | 245951 | 2020-06-16 | San Patricio | Texas | 48409 | 48 | 0 |
249064 | 249064 | 2020-06-17 | San Patricio | Texas | 48409 | 48 | 0 |
252179 | 252179 | 2020-06-18 | San Patricio | Texas | 48409 | 62 | 0 |
255294 | 255294 | 2020-06-19 | San Patricio | Texas | 48409 | 66 | 0 |
258421 | 258421 | 2020-06-20 | San Patricio | Texas | 48409 | 66 | 0 |
261548 | 261548 | 2020-06-21 | San Patricio | Texas | 48409 | 66 | 0 |
264677 | 264677 | 2020-06-22 | San Patricio | Texas | 48409 | 66 | 0 |
267805 | 267805 | 2020-06-23 | San Patricio | Texas | 48409 | 80 | 0 |
270939 | 270939 | 2020-06-24 | San Patricio | Texas | 48409 | 85 | 0 |
274079 | 274079 | 2020-06-25 | San Patricio | Texas | 48409 | 96 | 0 |
277227 | 277227 | 2020-06-26 | San Patricio | Texas | 48409 | 101 | 0 |
280375 | 280375 | 2020-06-27 | San Patricio | Texas | 48409 | 109 | 0 |
283521 | 283521 | 2020-06-28 | San Patricio | Texas | 48409 | 109 | 0 |
286667 | 286667 | 2020-06-29 | San Patricio | Texas | 48409 | 109 | 0 |
289817 | 289817 | 2020-06-30 | San Patricio | Texas | 48409 | 133 | 0 |
292970 | 292970 | 2020-07-01 | San Patricio | Texas | 48409 | 161 | 0 |
296125 | 296125 | 2020-07-02 | San Patricio | Texas | 48409 | 177 | 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);