ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 48321 and state = "Texas" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3149 | 3149 | 2020-03-16 | Matagorda | Texas | 48321 | 2 | 1 |
3685 | 3685 | 2020-03-17 | Matagorda | Texas | 48321 | 2 | 1 |
4309 | 4309 | 2020-03-18 | Matagorda | Texas | 48321 | 2 | 1 |
5064 | 5064 | 2020-03-19 | Matagorda | Texas | 48321 | 3 | 1 |
5957 | 5957 | 2020-03-20 | Matagorda | Texas | 48321 | 3 | 1 |
6977 | 6977 | 2020-03-21 | Matagorda | Texas | 48321 | 4 | 1 |
8107 | 8107 | 2020-03-22 | Matagorda | Texas | 48321 | 4 | 1 |
9325 | 9325 | 2020-03-23 | Matagorda | Texas | 48321 | 4 | 1 |
10665 | 10665 | 2020-03-24 | Matagorda | Texas | 48321 | 4 | 1 |
12166 | 12166 | 2020-03-25 | Matagorda | Texas | 48321 | 6 | 1 |
13798 | 13798 | 2020-03-26 | Matagorda | Texas | 48321 | 9 | 1 |
15554 | 15554 | 2020-03-27 | Matagorda | Texas | 48321 | 9 | 1 |
17425 | 17425 | 2020-03-28 | Matagorda | Texas | 48321 | 10 | 1 |
19380 | 19380 | 2020-03-29 | Matagorda | Texas | 48321 | 12 | 1 |
21441 | 21441 | 2020-03-30 | Matagorda | Texas | 48321 | 13 | 1 |
23580 | 23580 | 2020-03-31 | Matagorda | Texas | 48321 | 27 | 2 |
25792 | 25792 | 2020-04-01 | Matagorda | Texas | 48321 | 29 | 2 |
28078 | 28078 | 2020-04-02 | Matagorda | Texas | 48321 | 32 | 2 |
30414 | 30414 | 2020-04-03 | Matagorda | Texas | 48321 | 36 | 2 |
32810 | 32810 | 2020-04-04 | Matagorda | Texas | 48321 | 39 | 2 |
35248 | 35248 | 2020-04-05 | Matagorda | Texas | 48321 | 41 | 3 |
37724 | 37724 | 2020-04-06 | Matagorda | Texas | 48321 | 42 | 3 |
40252 | 40252 | 2020-04-07 | Matagorda | Texas | 48321 | 42 | 3 |
42820 | 42820 | 2020-04-08 | Matagorda | Texas | 48321 | 44 | 3 |
45411 | 45411 | 2020-04-09 | Matagorda | Texas | 48321 | 45 | 3 |
48032 | 48032 | 2020-04-10 | Matagorda | Texas | 48321 | 49 | 3 |
50690 | 50690 | 2020-04-11 | Matagorda | Texas | 48321 | 49 | 3 |
53365 | 53365 | 2020-04-12 | Matagorda | Texas | 48321 | 49 | 3 |
56053 | 56053 | 2020-04-13 | Matagorda | Texas | 48321 | 50 | 3 |
58758 | 58758 | 2020-04-14 | Matagorda | Texas | 48321 | 51 | 3 |
61476 | 61476 | 2020-04-15 | Matagorda | Texas | 48321 | 51 | 3 |
64205 | 64205 | 2020-04-16 | Matagorda | Texas | 48321 | 51 | 3 |
66952 | 66952 | 2020-04-17 | Matagorda | Texas | 48321 | 51 | 3 |
69712 | 69712 | 2020-04-18 | Matagorda | Texas | 48321 | 51 | 3 |
72481 | 72481 | 2020-04-19 | Matagorda | Texas | 48321 | 54 | 3 |
75257 | 75257 | 2020-04-20 | Matagorda | Texas | 48321 | 55 | 3 |
78039 | 78039 | 2020-04-21 | Matagorda | Texas | 48321 | 56 | 3 |
80830 | 80830 | 2020-04-22 | Matagorda | Texas | 48321 | 57 | 3 |
83631 | 83631 | 2020-04-23 | Matagorda | Texas | 48321 | 58 | 3 |
86436 | 86436 | 2020-04-24 | Matagorda | Texas | 48321 | 59 | 3 |
89251 | 89251 | 2020-04-25 | Matagorda | Texas | 48321 | 61 | 3 |
92068 | 92068 | 2020-04-26 | Matagorda | Texas | 48321 | 63 | 3 |
94897 | 94897 | 2020-04-27 | Matagorda | Texas | 48321 | 63 | 3 |
97738 | 97738 | 2020-04-28 | Matagorda | Texas | 48321 | 63 | 3 |
100588 | 100588 | 2020-04-29 | Matagorda | Texas | 48321 | 63 | 3 |
103443 | 103443 | 2020-04-30 | Matagorda | Texas | 48321 | 63 | 3 |
106307 | 106307 | 2020-05-01 | Matagorda | Texas | 48321 | 64 | 3 |
109176 | 109176 | 2020-05-02 | Matagorda | Texas | 48321 | 64 | 3 |
112050 | 112050 | 2020-05-03 | Matagorda | Texas | 48321 | 64 | 3 |
114932 | 114932 | 2020-05-04 | Matagorda | Texas | 48321 | 64 | 3 |
117891 | 117891 | 2020-05-05 | Matagorda | Texas | 48321 | 64 | 3 |
120855 | 120855 | 2020-05-06 | Matagorda | Texas | 48321 | 64 | 3 |
123834 | 123834 | 2020-05-07 | Matagorda | Texas | 48321 | 64 | 5 |
126818 | 126818 | 2020-05-08 | Matagorda | Texas | 48321 | 64 | 5 |
129807 | 129807 | 2020-05-09 | Matagorda | Texas | 48321 | 64 | 5 |
132797 | 132797 | 2020-05-10 | Matagorda | Texas | 48321 | 64 | 5 |
135788 | 135788 | 2020-05-11 | Matagorda | Texas | 48321 | 64 | 5 |
138778 | 138778 | 2020-05-12 | Matagorda | Texas | 48321 | 64 | 5 |
141774 | 141774 | 2020-05-13 | Matagorda | Texas | 48321 | 64 | 5 |
144771 | 144771 | 2020-05-14 | Matagorda | Texas | 48321 | 65 | 5 |
147775 | 147775 | 2020-05-15 | Matagorda | Texas | 48321 | 66 | 5 |
150783 | 150783 | 2020-05-16 | Matagorda | Texas | 48321 | 66 | 5 |
153794 | 153794 | 2020-05-17 | Matagorda | Texas | 48321 | 66 | 5 |
156811 | 156811 | 2020-05-18 | Matagorda | Texas | 48321 | 66 | 5 |
159833 | 159833 | 2020-05-19 | Matagorda | Texas | 48321 | 66 | 5 |
162861 | 162861 | 2020-05-20 | Matagorda | Texas | 48321 | 66 | 5 |
165890 | 165890 | 2020-05-21 | Matagorda | Texas | 48321 | 66 | 5 |
168926 | 168926 | 2020-05-22 | Matagorda | Texas | 48321 | 67 | 5 |
171966 | 171966 | 2020-05-23 | Matagorda | Texas | 48321 | 67 | 5 |
175009 | 175009 | 2020-05-24 | Matagorda | Texas | 48321 | 67 | 5 |
178053 | 178053 | 2020-05-25 | Matagorda | Texas | 48321 | 68 | 5 |
181097 | 181097 | 2020-05-26 | Matagorda | Texas | 48321 | 69 | 5 |
184147 | 184147 | 2020-05-27 | Matagorda | Texas | 48321 | 69 | 5 |
187204 | 187204 | 2020-05-28 | Matagorda | Texas | 48321 | 70 | 5 |
190268 | 190268 | 2020-05-29 | Matagorda | Texas | 48321 | 70 | 5 |
193334 | 193334 | 2020-05-30 | Matagorda | Texas | 48321 | 70 | 5 |
196404 | 196404 | 2020-05-31 | Matagorda | Texas | 48321 | 70 | 5 |
199477 | 199477 | 2020-06-01 | Matagorda | Texas | 48321 | 70 | 5 |
202553 | 202553 | 2020-06-02 | Matagorda | Texas | 48321 | 70 | 5 |
205632 | 205632 | 2020-06-03 | Matagorda | Texas | 48321 | 71 | 5 |
208714 | 208714 | 2020-06-04 | Matagorda | Texas | 48321 | 71 | 5 |
211798 | 211798 | 2020-06-05 | Matagorda | Texas | 48321 | 71 | 5 |
214885 | 214885 | 2020-06-06 | Matagorda | Texas | 48321 | 71 | 5 |
217975 | 217975 | 2020-06-07 | Matagorda | Texas | 48321 | 71 | 5 |
221067 | 221067 | 2020-06-08 | Matagorda | Texas | 48321 | 77 | 5 |
224162 | 224162 | 2020-06-09 | Matagorda | Texas | 48321 | 77 | 5 |
227262 | 227262 | 2020-06-10 | Matagorda | Texas | 48321 | 77 | 5 |
230366 | 230366 | 2020-06-11 | Matagorda | Texas | 48321 | 77 | 5 |
233470 | 233470 | 2020-06-12 | Matagorda | Texas | 48321 | 77 | 5 |
236576 | 236576 | 2020-06-13 | Matagorda | Texas | 48321 | 78 | 5 |
239684 | 239684 | 2020-06-14 | Matagorda | Texas | 48321 | 80 | 5 |
242794 | 242794 | 2020-06-15 | Matagorda | Texas | 48321 | 81 | 5 |
245906 | 245906 | 2020-06-16 | Matagorda | Texas | 48321 | 85 | 5 |
249019 | 249019 | 2020-06-17 | Matagorda | Texas | 48321 | 94 | 5 |
252134 | 252134 | 2020-06-18 | Matagorda | Texas | 48321 | 96 | 5 |
255249 | 255249 | 2020-06-19 | Matagorda | Texas | 48321 | 104 | 5 |
258376 | 258376 | 2020-06-20 | Matagorda | Texas | 48321 | 105 | 5 |
261503 | 261503 | 2020-06-21 | Matagorda | Texas | 48321 | 109 | 5 |
264631 | 264631 | 2020-06-22 | Matagorda | Texas | 48321 | 110 | 5 |
267759 | 267759 | 2020-06-23 | Matagorda | Texas | 48321 | 117 | 5 |
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);