ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Castro" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
6958 | 6958 | 2020-03-21 | Castro | Texas | 48069 | 1 | 0 |
8088 | 8088 | 2020-03-22 | Castro | Texas | 48069 | 1 | 0 |
9306 | 9306 | 2020-03-23 | Castro | Texas | 48069 | 1 | 0 |
10640 | 10640 | 2020-03-24 | Castro | Texas | 48069 | 2 | 0 |
12124 | 12124 | 2020-03-25 | Castro | Texas | 48069 | 3 | 0 |
13753 | 13753 | 2020-03-26 | Castro | Texas | 48069 | 6 | 0 |
15506 | 15506 | 2020-03-27 | Castro | Texas | 48069 | 7 | 0 |
17375 | 17375 | 2020-03-28 | Castro | Texas | 48069 | 8 | 0 |
19325 | 19325 | 2020-03-29 | Castro | Texas | 48069 | 8 | 0 |
21384 | 21384 | 2020-03-30 | Castro | Texas | 48069 | 8 | 0 |
23523 | 23523 | 2020-03-31 | Castro | Texas | 48069 | 8 | 0 |
25728 | 25728 | 2020-04-01 | Castro | Texas | 48069 | 8 | 0 |
28008 | 28008 | 2020-04-02 | Castro | Texas | 48069 | 8 | 0 |
30343 | 30343 | 2020-04-03 | Castro | Texas | 48069 | 9 | 0 |
32736 | 32736 | 2020-04-04 | Castro | Texas | 48069 | 10 | 1 |
35174 | 35174 | 2020-04-05 | Castro | Texas | 48069 | 10 | 1 |
37650 | 37650 | 2020-04-06 | Castro | Texas | 48069 | 10 | 1 |
40173 | 40173 | 2020-04-07 | Castro | Texas | 48069 | 10 | 1 |
42736 | 42736 | 2020-04-08 | Castro | Texas | 48069 | 10 | 1 |
45325 | 45325 | 2020-04-09 | Castro | Texas | 48069 | 10 | 1 |
47943 | 47943 | 2020-04-10 | Castro | Texas | 48069 | 10 | 1 |
50600 | 50600 | 2020-04-11 | Castro | Texas | 48069 | 10 | 1 |
53275 | 53275 | 2020-04-12 | Castro | Texas | 48069 | 11 | 1 |
55963 | 55963 | 2020-04-13 | Castro | Texas | 48069 | 11 | 1 |
58667 | 58667 | 2020-04-14 | Castro | Texas | 48069 | 11 | 1 |
61384 | 61384 | 2020-04-15 | Castro | Texas | 48069 | 11 | 1 |
64111 | 64111 | 2020-04-16 | Castro | Texas | 48069 | 11 | 1 |
66858 | 66858 | 2020-04-17 | Castro | Texas | 48069 | 11 | 1 |
69618 | 69618 | 2020-04-18 | Castro | Texas | 48069 | 11 | 1 |
72385 | 72385 | 2020-04-19 | Castro | Texas | 48069 | 11 | 1 |
75160 | 75160 | 2020-04-20 | Castro | Texas | 48069 | 11 | 1 |
77942 | 77942 | 2020-04-21 | Castro | Texas | 48069 | 11 | 1 |
80733 | 80733 | 2020-04-22 | Castro | Texas | 48069 | 12 | 1 |
83532 | 83532 | 2020-04-23 | Castro | Texas | 48069 | 13 | 1 |
86337 | 86337 | 2020-04-24 | Castro | Texas | 48069 | 13 | 1 |
89152 | 89152 | 2020-04-25 | Castro | Texas | 48069 | 13 | 1 |
91969 | 91969 | 2020-04-26 | Castro | Texas | 48069 | 13 | 1 |
94797 | 94797 | 2020-04-27 | Castro | Texas | 48069 | 13 | 1 |
97637 | 97637 | 2020-04-28 | Castro | Texas | 48069 | 13 | 1 |
100487 | 100487 | 2020-04-29 | Castro | Texas | 48069 | 13 | 1 |
103340 | 103340 | 2020-04-30 | Castro | Texas | 48069 | 13 | 1 |
106204 | 106204 | 2020-05-01 | Castro | Texas | 48069 | 15 | 1 |
109072 | 109072 | 2020-05-02 | Castro | Texas | 48069 | 15 | 1 |
111946 | 111946 | 2020-05-03 | Castro | Texas | 48069 | 15 | 1 |
114828 | 114828 | 2020-05-04 | Castro | Texas | 48069 | 18 | 1 |
117785 | 117785 | 2020-05-05 | Castro | Texas | 48069 | 18 | 1 |
120749 | 120749 | 2020-05-06 | Castro | Texas | 48069 | 20 | 1 |
123728 | 123728 | 2020-05-07 | Castro | Texas | 48069 | 22 | 1 |
126711 | 126711 | 2020-05-08 | Castro | Texas | 48069 | 22 | 1 |
129700 | 129700 | 2020-05-09 | Castro | Texas | 48069 | 22 | 1 |
132690 | 132690 | 2020-05-10 | Castro | Texas | 48069 | 23 | 1 |
135681 | 135681 | 2020-05-11 | Castro | Texas | 48069 | 23 | 1 |
138671 | 138671 | 2020-05-12 | Castro | Texas | 48069 | 23 | 1 |
141667 | 141667 | 2020-05-13 | Castro | Texas | 48069 | 24 | 1 |
144664 | 144664 | 2020-05-14 | Castro | Texas | 48069 | 25 | 1 |
147666 | 147666 | 2020-05-15 | Castro | Texas | 48069 | 27 | 1 |
150674 | 150674 | 2020-05-16 | Castro | Texas | 48069 | 26 | 1 |
153685 | 153685 | 2020-05-17 | Castro | Texas | 48069 | 27 | 1 |
156702 | 156702 | 2020-05-18 | Castro | Texas | 48069 | 27 | 1 |
159724 | 159724 | 2020-05-19 | Castro | Texas | 48069 | 28 | 1 |
162751 | 162751 | 2020-05-20 | Castro | Texas | 48069 | 28 | 1 |
165780 | 165780 | 2020-05-21 | Castro | Texas | 48069 | 29 | 1 |
168816 | 168816 | 2020-05-22 | Castro | Texas | 48069 | 29 | 1 |
171855 | 171855 | 2020-05-23 | Castro | Texas | 48069 | 32 | 1 |
174898 | 174898 | 2020-05-24 | Castro | Texas | 48069 | 32 | 1 |
177942 | 177942 | 2020-05-25 | Castro | Texas | 48069 | 32 | 1 |
180985 | 180985 | 2020-05-26 | Castro | Texas | 48069 | 32 | 1 |
184035 | 184035 | 2020-05-27 | Castro | Texas | 48069 | 32 | 1 |
187092 | 187092 | 2020-05-28 | Castro | Texas | 48069 | 32 | 1 |
190156 | 190156 | 2020-05-29 | Castro | Texas | 48069 | 32 | 1 |
193221 | 193221 | 2020-05-30 | Castro | Texas | 48069 | 33 | 1 |
196291 | 196291 | 2020-05-31 | Castro | Texas | 48069 | 33 | 1 |
199364 | 199364 | 2020-06-01 | Castro | Texas | 48069 | 33 | 1 |
202439 | 202439 | 2020-06-02 | Castro | Texas | 48069 | 33 | 1 |
205518 | 205518 | 2020-06-03 | Castro | Texas | 48069 | 33 | 1 |
208600 | 208600 | 2020-06-04 | Castro | Texas | 48069 | 34 | 1 |
211683 | 211683 | 2020-06-05 | Castro | Texas | 48069 | 34 | 1 |
214770 | 214770 | 2020-06-06 | Castro | Texas | 48069 | 35 | 1 |
217860 | 217860 | 2020-06-07 | Castro | Texas | 48069 | 35 | 1 |
220952 | 220952 | 2020-06-08 | Castro | Texas | 48069 | 35 | 1 |
224047 | 224047 | 2020-06-09 | Castro | Texas | 48069 | 36 | 1 |
227147 | 227147 | 2020-06-10 | Castro | Texas | 48069 | 37 | 1 |
230251 | 230251 | 2020-06-11 | Castro | Texas | 48069 | 37 | 1 |
233355 | 233355 | 2020-06-12 | Castro | Texas | 48069 | 39 | 1 |
236461 | 236461 | 2020-06-13 | Castro | Texas | 48069 | 42 | 1 |
239569 | 239569 | 2020-06-14 | Castro | Texas | 48069 | 42 | 1 |
242679 | 242679 | 2020-06-15 | Castro | Texas | 48069 | 42 | 1 |
245791 | 245791 | 2020-06-16 | Castro | Texas | 48069 | 48 | 1 |
248904 | 248904 | 2020-06-17 | Castro | Texas | 48069 | 48 | 1 |
252019 | 252019 | 2020-06-18 | Castro | Texas | 48069 | 50 | 1 |
255134 | 255134 | 2020-06-19 | Castro | Texas | 48069 | 51 | 1 |
258260 | 258260 | 2020-06-20 | Castro | Texas | 48069 | 51 | 1 |
261387 | 261387 | 2020-06-21 | Castro | Texas | 48069 | 51 | 1 |
264515 | 264515 | 2020-06-22 | Castro | Texas | 48069 | 58 | 1 |
267643 | 267643 | 2020-06-23 | Castro | Texas | 48069 | 63 | 1 |
270777 | 270777 | 2020-06-24 | Castro | Texas | 48069 | 65 | 1 |
273916 | 273916 | 2020-06-25 | Castro | Texas | 48069 | 70 | 1 |
277063 | 277063 | 2020-06-26 | Castro | Texas | 48069 | 73 | 1 |
280211 | 280211 | 2020-06-27 | Castro | Texas | 48069 | 74 | 1 |
283357 | 283357 | 2020-06-28 | Castro | Texas | 48069 | 74 | 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);