ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Hockley" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
5953 | 5953 | 2020-03-20 | Hockley | Texas | 48219 | 1 | 0 |
6973 | 6973 | 2020-03-21 | Hockley | Texas | 48219 | 2 | 0 |
8103 | 8103 | 2020-03-22 | Hockley | Texas | 48219 | 2 | 0 |
9321 | 9321 | 2020-03-23 | Hockley | Texas | 48219 | 2 | 0 |
10660 | 10660 | 2020-03-24 | Hockley | Texas | 48219 | 3 | 0 |
12153 | 12153 | 2020-03-25 | Hockley | Texas | 48219 | 3 | 0 |
13782 | 13782 | 2020-03-26 | Hockley | Texas | 48219 | 5 | 0 |
15537 | 15537 | 2020-03-27 | Hockley | Texas | 48219 | 5 | 0 |
17406 | 17406 | 2020-03-28 | Hockley | Texas | 48219 | 7 | 0 |
19360 | 19360 | 2020-03-29 | Hockley | Texas | 48219 | 7 | 0 |
21420 | 21420 | 2020-03-30 | Hockley | Texas | 48219 | 7 | 0 |
23559 | 23559 | 2020-03-31 | Hockley | Texas | 48219 | 7 | 0 |
25769 | 25769 | 2020-04-01 | Hockley | Texas | 48219 | 7 | 0 |
28052 | 28052 | 2020-04-02 | Hockley | Texas | 48219 | 7 | 0 |
30387 | 30387 | 2020-04-03 | Hockley | Texas | 48219 | 7 | 1 |
32781 | 32781 | 2020-04-04 | Hockley | Texas | 48219 | 7 | 1 |
35219 | 35219 | 2020-04-05 | Hockley | Texas | 48219 | 10 | 1 |
37695 | 37695 | 2020-04-06 | Hockley | Texas | 48219 | 10 | 1 |
40222 | 40222 | 2020-04-07 | Hockley | Texas | 48219 | 10 | 1 |
42789 | 42789 | 2020-04-08 | Hockley | Texas | 48219 | 10 | 1 |
45378 | 45378 | 2020-04-09 | Hockley | Texas | 48219 | 12 | 1 |
47998 | 47998 | 2020-04-10 | Hockley | Texas | 48219 | 12 | 1 |
50656 | 50656 | 2020-04-11 | Hockley | Texas | 48219 | 13 | 1 |
53331 | 53331 | 2020-04-12 | Hockley | Texas | 48219 | 14 | 1 |
56019 | 56019 | 2020-04-13 | Hockley | Texas | 48219 | 14 | 1 |
58724 | 58724 | 2020-04-14 | Hockley | Texas | 48219 | 14 | 1 |
61442 | 61442 | 2020-04-15 | Hockley | Texas | 48219 | 15 | 1 |
64169 | 64169 | 2020-04-16 | Hockley | Texas | 48219 | 15 | 1 |
66916 | 66916 | 2020-04-17 | Hockley | Texas | 48219 | 15 | 1 |
69676 | 69676 | 2020-04-18 | Hockley | Texas | 48219 | 15 | 1 |
72444 | 72444 | 2020-04-19 | Hockley | Texas | 48219 | 16 | 1 |
75220 | 75220 | 2020-04-20 | Hockley | Texas | 48219 | 16 | 1 |
78002 | 78002 | 2020-04-21 | Hockley | Texas | 48219 | 16 | 1 |
80793 | 80793 | 2020-04-22 | Hockley | Texas | 48219 | 17 | 1 |
83593 | 83593 | 2020-04-23 | Hockley | Texas | 48219 | 18 | 1 |
86398 | 86398 | 2020-04-24 | Hockley | Texas | 48219 | 19 | 1 |
89213 | 89213 | 2020-04-25 | Hockley | Texas | 48219 | 20 | 1 |
92030 | 92030 | 2020-04-26 | Hockley | Texas | 48219 | 20 | 1 |
94859 | 94859 | 2020-04-27 | Hockley | Texas | 48219 | 20 | 1 |
97699 | 97699 | 2020-04-28 | Hockley | Texas | 48219 | 20 | 1 |
100549 | 100549 | 2020-04-29 | Hockley | Texas | 48219 | 20 | 1 |
103404 | 103404 | 2020-04-30 | Hockley | Texas | 48219 | 20 | 1 |
106268 | 106268 | 2020-05-01 | Hockley | Texas | 48219 | 21 | 1 |
109137 | 109137 | 2020-05-02 | Hockley | Texas | 48219 | 20 | 1 |
112011 | 112011 | 2020-05-03 | Hockley | Texas | 48219 | 20 | 1 |
114893 | 114893 | 2020-05-04 | Hockley | Texas | 48219 | 20 | 1 |
117852 | 117852 | 2020-05-05 | Hockley | Texas | 48219 | 20 | 1 |
120816 | 120816 | 2020-05-06 | Hockley | Texas | 48219 | 20 | 1 |
123795 | 123795 | 2020-05-07 | Hockley | Texas | 48219 | 19 | 1 |
126778 | 126778 | 2020-05-08 | Hockley | Texas | 48219 | 20 | 1 |
129767 | 129767 | 2020-05-09 | Hockley | Texas | 48219 | 20 | 1 |
132757 | 132757 | 2020-05-10 | Hockley | Texas | 48219 | 20 | 1 |
135748 | 135748 | 2020-05-11 | Hockley | Texas | 48219 | 20 | 1 |
138738 | 138738 | 2020-05-12 | Hockley | Texas | 48219 | 20 | 1 |
141734 | 141734 | 2020-05-13 | Hockley | Texas | 48219 | 23 | 1 |
144731 | 144731 | 2020-05-14 | Hockley | Texas | 48219 | 22 | 1 |
147735 | 147735 | 2020-05-15 | Hockley | Texas | 48219 | 23 | 1 |
150743 | 150743 | 2020-05-16 | Hockley | Texas | 48219 | 23 | 1 |
153754 | 153754 | 2020-05-17 | Hockley | Texas | 48219 | 23 | 1 |
156771 | 156771 | 2020-05-18 | Hockley | Texas | 48219 | 23 | 1 |
159793 | 159793 | 2020-05-19 | Hockley | Texas | 48219 | 24 | 1 |
162821 | 162821 | 2020-05-20 | Hockley | Texas | 48219 | 27 | 1 |
165850 | 165850 | 2020-05-21 | Hockley | Texas | 48219 | 27 | 1 |
168886 | 168886 | 2020-05-22 | Hockley | Texas | 48219 | 27 | 1 |
171926 | 171926 | 2020-05-23 | Hockley | Texas | 48219 | 27 | 1 |
174969 | 174969 | 2020-05-24 | Hockley | Texas | 48219 | 27 | 1 |
178013 | 178013 | 2020-05-25 | Hockley | Texas | 48219 | 27 | 1 |
181056 | 181056 | 2020-05-26 | Hockley | Texas | 48219 | 27 | 1 |
184106 | 184106 | 2020-05-27 | Hockley | Texas | 48219 | 27 | 1 |
187163 | 187163 | 2020-05-28 | Hockley | Texas | 48219 | 27 | 1 |
190227 | 190227 | 2020-05-29 | Hockley | Texas | 48219 | 27 | 1 |
193292 | 193292 | 2020-05-30 | Hockley | Texas | 48219 | 27 | 1 |
196362 | 196362 | 2020-05-31 | Hockley | Texas | 48219 | 27 | 1 |
199435 | 199435 | 2020-06-01 | Hockley | Texas | 48219 | 27 | 1 |
202510 | 202510 | 2020-06-02 | Hockley | Texas | 48219 | 27 | 1 |
205589 | 205589 | 2020-06-03 | Hockley | Texas | 48219 | 27 | 1 |
208671 | 208671 | 2020-06-04 | Hockley | Texas | 48219 | 27 | 1 |
211755 | 211755 | 2020-06-05 | Hockley | Texas | 48219 | 27 | 1 |
214842 | 214842 | 2020-06-06 | Hockley | Texas | 48219 | 27 | 1 |
217932 | 217932 | 2020-06-07 | Hockley | Texas | 48219 | 27 | 1 |
221024 | 221024 | 2020-06-08 | Hockley | Texas | 48219 | 27 | 1 |
224119 | 224119 | 2020-06-09 | Hockley | Texas | 48219 | 27 | 1 |
227219 | 227219 | 2020-06-10 | Hockley | Texas | 48219 | 27 | 1 |
230323 | 230323 | 2020-06-11 | Hockley | Texas | 48219 | 28 | 1 |
233427 | 233427 | 2020-06-12 | Hockley | Texas | 48219 | 28 | 1 |
236533 | 236533 | 2020-06-13 | Hockley | Texas | 48219 | 28 | 1 |
239641 | 239641 | 2020-06-14 | Hockley | Texas | 48219 | 28 | 1 |
242751 | 242751 | 2020-06-15 | Hockley | Texas | 48219 | 28 | 1 |
245863 | 245863 | 2020-06-16 | Hockley | Texas | 48219 | 28 | 1 |
248976 | 248976 | 2020-06-17 | Hockley | Texas | 48219 | 29 | 1 |
252091 | 252091 | 2020-06-18 | Hockley | Texas | 48219 | 29 | 1 |
255206 | 255206 | 2020-06-19 | Hockley | Texas | 48219 | 29 | 1 |
258333 | 258333 | 2020-06-20 | Hockley | Texas | 48219 | 29 | 1 |
261460 | 261460 | 2020-06-21 | Hockley | Texas | 48219 | 29 | 1 |
264588 | 264588 | 2020-06-22 | Hockley | Texas | 48219 | 30 | 1 |
267716 | 267716 | 2020-06-23 | Hockley | Texas | 48219 | 30 | 1 |
270850 | 270850 | 2020-06-24 | Hockley | Texas | 48219 | 33 | 1 |
273990 | 273990 | 2020-06-25 | Hockley | Texas | 48219 | 33 | 1 |
277137 | 277137 | 2020-06-26 | Hockley | Texas | 48219 | 36 | 1 |
280285 | 280285 | 2020-06-27 | Hockley | Texas | 48219 | 36 | 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);