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 rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 363 ✖
- 1069 16
- 2290 15
- 1068 11
- 11 10
- 10 8
- 13 8
- 263 8
- 2294 8
- 32 7
- 897 7
- 908 7
- 2278 7
- 2296 7
- 8 6
- 903 6
- 983 6
- 1370 6
- 33 5
- 241 5
- 768 5
- 857 5
- 900 5
- 905 5
- 922 5
- 976 5
- 1043 5
- 1274 5
- 2262 5
- 2295 5
- 147 4
- 209 4
- 214 4
- 236 4
- 289 4
- 393 4
- 711 4
- 794 4
- 849 4
- 899 4
- 929 4
- 975 4
- 982 4
- 987 4
- 996 4
- 1023 4
- 1070 4
- 1125 4
- 1142 4
- 1161 4
- 1218 4
- 1233 4
- 1462 4
- 1483 4
- 2238 4
- 2251 4
- 2260 4
- 2280 4
- 2283 4
- 1 3
- 15 3
- 22 3
- 23 3
- 27 3
- 35 3
- 42 3
- 51 3
- 74 3
- 99 3
- 120 3
- 146 3
- 170 3
- 200 3
- 205 3
- 227 3
- 249 3
- 257 3
- 301 3
- 311 3
- 320 3
- 349 3
- 466 3
- 746 3
- 824 3
- 831 3
- 844 3
- 895 3
- 898 3
- 923 3
- 966 3
- 995 3
- 998 3
- 1012 3
- 1081 3
- 1090 3
- 1102 3
- 1116 3
- 1202 3
- 1252 3
- 1256 3
- 1294 3
- 1312 3
- 1320 3
- 1332 3
- 1348 3
- 1355 3
- 1364 3
- 1458 3
- 2124 3
- 2257 3
- 2258 3
- 18 2
- 28 2
- 29 2
- 34 2
- 37 2
- 48 2
- 142 2
- 210 2
- 229 2
- 231 2
- 239 2
- 250 2
- 251 2
- 274 2
- 276 2
- 287 2
- 339 2
- 378 2
- 439 2
- 462 2
- 504 2
- 829 2
- 836 2
- 847 2
- 953 2
- 981 2
- 984 2
- 989 2
- 1011 2
- 1072 2
- 1088 2
- 1120 2
- 1131 2
- 1137 2
- 1212 2
- 1229 2
- 1271 2
- 1290 2
- 1306 2
- 1307 2
- 1342 2
- 1349 2
- 1350 2
- 1358 2
- 1385 2
- 1402 2
- 1436 2
- 1446 2
- 2165 2
- 2188 2
- 2210 2
- 2215 2
- 2255 2
- 2279 2
- 2291 2
- 2297 2
- 2 1
- 3 1
- 6 1
- 7 1
- 9 1
- 12 1
- 20 1
- 24 1
- 25 1
- 26 1
- 36 1
- 39 1
- 50 1
- 58 1
- 63 1
- 65 1
- 70 1
- 73 1
- 75 1
- 87 1
- 93 1
- 97 1
- 107 1
- 108 1
- 110 1
- 112 1
- 121 1
- 130 1
- 135 1
- 138 1
- 145 1
- 160 1
- 161 1
- 163 1
- 167 1
- 182 1
- 188 1
- 190 1
- 197 1
- 206 1
- 219 1
- 220 1
- 221 1
- 223 1
- 242 1
- 243 1
- 247 1
- 259 1
- 262 1
- 267 1
- 271 1
- 277 1
- 278 1
- 285 1
- 318 1
- 323 1
- 325 1
- 374 1
- 407 1
- 413 1
- 414 1
- 427 1
- 440 1
- 442 1
- 446 1
- 472 1
- 476 1
- 494 1
- 496 1
- 505 1
- 507 1
- 514 1
- 517 1
- 706 1
- 713 1
- 732 1
- 742 1
- 750 1
- 767 1
- 773 1
- 777 1
- 781 1
- 796 1
- 813 1
- 819 1
- 823 1
- 825 1
- 827 1
- 832 1
- 842 1
- 848 1
- 853 1
- 856 1
- 864 1
- 901 1
- 913 1
- 921 1
- 930 1
- 938 1
- 985 1
- 988 1
- 990 1
- 1002 1
- 1004 1
- 1008 1
- 1015 1
- 1020 1
- 1037 1
- 1039 1
- 1040 1
- 1045 1
- 1047 1
- 1054 1
- 1077 1
- 1079 1
- 1083 1
- 1084 1
- 1094 1
- 1095 1
- 1100 1
- 1101 1
- 1105 1
- 1107 1
- 1108 1
- 1111 1
- 1122 1
- 1154 1
- 1159 1
- 1160 1
- 1191 1
- 1194 1
- 1197 1
- 1215 1
- 1227 1
- 1243 1
- 1270 1
- 1293 1
- 1329 1
- 1341 1
- 1347 1
- 1356 1
- 1362 1
- 1384 1
- 1386 1
- 1398 1
- 1406 1
- 1411 1
- 1414 1
- 1422 1
- 1428 1
- 1429 1
- 1430 1
- 1437 1
- 1440 1
- 1459 1
- 1479 1
- 1480 1
- 1481 1
- 1506 1
- 1507 1
- 1508 1
- 1514 1
- 1536 1
- 1552 1
- 1554 1
- 1573 1
- 1588 1
- 1590 1
- 1597 1
- 1881 1
- 1921 1
- 1923 1
- 1997 1
- 2002 1
- 2006 1
- 2010 1
- 2068 1
- 2070 1
- 2072 1
- 2125 1
- 2137 1
- 2191 1
- 2205 1
- 2214 1
- 2218 1
- 2231 1
- 2235 1
- 2240 1
- 2243 1
- 2246 1
- 2256 1
- 2259 1
- 2261 1
- 2266 1
- 2272 1
- 2281 1
- 2293 1
state 1
- Texas 784
fips 1
- 48069 784
county 1
- Castro · 784 ✖
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);