ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
752 rows where county = "Brooks" and fips = 48047 sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
80722 | 80722 | 2020-04-22 | Brooks | Texas | 48047 | 1 | 0 |
83521 | 83521 | 2020-04-23 | Brooks | Texas | 48047 | 1 | 0 |
86326 | 86326 | 2020-04-24 | Brooks | Texas | 48047 | 1 | 0 |
89141 | 89141 | 2020-04-25 | Brooks | Texas | 48047 | 1 | 0 |
91958 | 91958 | 2020-04-26 | Brooks | Texas | 48047 | 1 | 0 |
94786 | 94786 | 2020-04-27 | Brooks | Texas | 48047 | 1 | 0 |
97626 | 97626 | 2020-04-28 | Brooks | Texas | 48047 | 1 | 0 |
100476 | 100476 | 2020-04-29 | Brooks | Texas | 48047 | 1 | 0 |
103329 | 103329 | 2020-04-30 | Brooks | Texas | 48047 | 1 | 0 |
106193 | 106193 | 2020-05-01 | Brooks | Texas | 48047 | 1 | 0 |
109061 | 109061 | 2020-05-02 | Brooks | Texas | 48047 | 1 | 0 |
111935 | 111935 | 2020-05-03 | Brooks | Texas | 48047 | 1 | 0 |
114817 | 114817 | 2020-05-04 | Brooks | Texas | 48047 | 1 | 0 |
117774 | 117774 | 2020-05-05 | Brooks | Texas | 48047 | 1 | 0 |
120738 | 120738 | 2020-05-06 | Brooks | Texas | 48047 | 1 | 0 |
123717 | 123717 | 2020-05-07 | Brooks | Texas | 48047 | 1 | 0 |
126700 | 126700 | 2020-05-08 | Brooks | Texas | 48047 | 1 | 0 |
129689 | 129689 | 2020-05-09 | Brooks | Texas | 48047 | 1 | 0 |
132679 | 132679 | 2020-05-10 | Brooks | Texas | 48047 | 1 | 0 |
135670 | 135670 | 2020-05-11 | Brooks | Texas | 48047 | 1 | 0 |
138660 | 138660 | 2020-05-12 | Brooks | Texas | 48047 | 1 | 0 |
141656 | 141656 | 2020-05-13 | Brooks | Texas | 48047 | 1 | 0 |
144653 | 144653 | 2020-05-14 | Brooks | Texas | 48047 | 1 | 0 |
147655 | 147655 | 2020-05-15 | Brooks | Texas | 48047 | 1 | 0 |
150663 | 150663 | 2020-05-16 | Brooks | Texas | 48047 | 1 | 0 |
153674 | 153674 | 2020-05-17 | Brooks | Texas | 48047 | 1 | 0 |
156691 | 156691 | 2020-05-18 | Brooks | Texas | 48047 | 1 | 0 |
159713 | 159713 | 2020-05-19 | Brooks | Texas | 48047 | 1 | 0 |
162740 | 162740 | 2020-05-20 | Brooks | Texas | 48047 | 1 | 0 |
165769 | 165769 | 2020-05-21 | Brooks | Texas | 48047 | 1 | 0 |
168805 | 168805 | 2020-05-22 | Brooks | Texas | 48047 | 1 | 0 |
171844 | 171844 | 2020-05-23 | Brooks | Texas | 48047 | 1 | 0 |
174887 | 174887 | 2020-05-24 | Brooks | Texas | 48047 | 1 | 0 |
177931 | 177931 | 2020-05-25 | Brooks | Texas | 48047 | 1 | 0 |
180974 | 180974 | 2020-05-26 | Brooks | Texas | 48047 | 1 | 0 |
184024 | 184024 | 2020-05-27 | Brooks | Texas | 48047 | 1 | 0 |
187081 | 187081 | 2020-05-28 | Brooks | Texas | 48047 | 1 | 0 |
190145 | 190145 | 2020-05-29 | Brooks | Texas | 48047 | 1 | 0 |
193210 | 193210 | 2020-05-30 | Brooks | Texas | 48047 | 1 | 0 |
196280 | 196280 | 2020-05-31 | Brooks | Texas | 48047 | 1 | 0 |
199353 | 199353 | 2020-06-01 | Brooks | Texas | 48047 | 1 | 0 |
202428 | 202428 | 2020-06-02 | Brooks | Texas | 48047 | 1 | 0 |
205507 | 205507 | 2020-06-03 | Brooks | Texas | 48047 | 1 | 0 |
208589 | 208589 | 2020-06-04 | Brooks | Texas | 48047 | 1 | 0 |
211672 | 211672 | 2020-06-05 | Brooks | Texas | 48047 | 1 | 0 |
214759 | 214759 | 2020-06-06 | Brooks | Texas | 48047 | 1 | 0 |
217849 | 217849 | 2020-06-07 | Brooks | Texas | 48047 | 1 | 0 |
220941 | 220941 | 2020-06-08 | Brooks | Texas | 48047 | 1 | 0 |
224036 | 224036 | 2020-06-09 | Brooks | Texas | 48047 | 1 | 0 |
227136 | 227136 | 2020-06-10 | Brooks | Texas | 48047 | 1 | 0 |
230240 | 230240 | 2020-06-11 | Brooks | Texas | 48047 | 1 | 0 |
233344 | 233344 | 2020-06-12 | Brooks | Texas | 48047 | 1 | 0 |
236450 | 236450 | 2020-06-13 | Brooks | Texas | 48047 | 1 | 0 |
239558 | 239558 | 2020-06-14 | Brooks | Texas | 48047 | 2 | 0 |
242668 | 242668 | 2020-06-15 | Brooks | Texas | 48047 | 2 | 0 |
245780 | 245780 | 2020-06-16 | Brooks | Texas | 48047 | 2 | 0 |
248893 | 248893 | 2020-06-17 | Brooks | Texas | 48047 | 2 | 0 |
252008 | 252008 | 2020-06-18 | Brooks | Texas | 48047 | 2 | 0 |
255123 | 255123 | 2020-06-19 | Brooks | Texas | 48047 | 2 | 0 |
258249 | 258249 | 2020-06-20 | Brooks | Texas | 48047 | 2 | 0 |
261376 | 261376 | 2020-06-21 | Brooks | Texas | 48047 | 3 | 0 |
264504 | 264504 | 2020-06-22 | Brooks | Texas | 48047 | 3 | 0 |
267632 | 267632 | 2020-06-23 | Brooks | Texas | 48047 | 3 | 0 |
270766 | 270766 | 2020-06-24 | Brooks | Texas | 48047 | 3 | 0 |
273905 | 273905 | 2020-06-25 | Brooks | Texas | 48047 | 3 | 0 |
277052 | 277052 | 2020-06-26 | Brooks | Texas | 48047 | 3 | 0 |
280200 | 280200 | 2020-06-27 | Brooks | Texas | 48047 | 3 | 0 |
283346 | 283346 | 2020-06-28 | Brooks | Texas | 48047 | 3 | 0 |
286492 | 286492 | 2020-06-29 | Brooks | Texas | 48047 | 3 | 0 |
289642 | 289642 | 2020-06-30 | Brooks | Texas | 48047 | 3 | 0 |
292795 | 292795 | 2020-07-01 | Brooks | Texas | 48047 | 3 | 0 |
295950 | 295950 | 2020-07-02 | Brooks | Texas | 48047 | 6 | 0 |
299110 | 299110 | 2020-07-03 | Brooks | Texas | 48047 | 6 | 0 |
302274 | 302274 | 2020-07-04 | Brooks | Texas | 48047 | 9 | 0 |
305438 | 305438 | 2020-07-05 | Brooks | Texas | 48047 | 9 | 0 |
308606 | 308606 | 2020-07-06 | Brooks | Texas | 48047 | 10 | 0 |
311775 | 311775 | 2020-07-07 | Brooks | Texas | 48047 | 11 | 0 |
314949 | 314949 | 2020-07-08 | Brooks | Texas | 48047 | 18 | 0 |
318122 | 318122 | 2020-07-09 | Brooks | Texas | 48047 | 29 | 0 |
321300 | 321300 | 2020-07-10 | Brooks | Texas | 48047 | 35 | 0 |
324481 | 324481 | 2020-07-11 | Brooks | Texas | 48047 | 37 | 0 |
327666 | 327666 | 2020-07-12 | Brooks | Texas | 48047 | 41 | 0 |
330852 | 330852 | 2020-07-13 | Brooks | Texas | 48047 | 41 | 0 |
334043 | 334043 | 2020-07-14 | Brooks | Texas | 48047 | 41 | 0 |
337238 | 337238 | 2020-07-15 | Brooks | Texas | 48047 | 45 | 0 |
340434 | 340434 | 2020-07-16 | Brooks | Texas | 48047 | 53 | 0 |
343633 | 343633 | 2020-07-17 | Brooks | Texas | 48047 | 53 | 0 |
346833 | 346833 | 2020-07-18 | Brooks | Texas | 48047 | 55 | 0 |
350033 | 350033 | 2020-07-19 | Brooks | Texas | 48047 | 56 | 0 |
353235 | 353235 | 2020-07-20 | Brooks | Texas | 48047 | 56 | 0 |
356438 | 356438 | 2020-07-21 | Brooks | Texas | 48047 | 56 | 0 |
359643 | 359643 | 2020-07-22 | Brooks | Texas | 48047 | 57 | 0 |
362850 | 362850 | 2020-07-23 | Brooks | Texas | 48047 | 57 | 0 |
366056 | 366056 | 2020-07-24 | Brooks | Texas | 48047 | 58 | 0 |
369265 | 369265 | 2020-07-25 | Brooks | Texas | 48047 | 65 | 1 |
372477 | 372477 | 2020-07-26 | Brooks | Texas | 48047 | 76 | 1 |
375690 | 375690 | 2020-07-27 | Brooks | Texas | 48047 | 77 | 1 |
378906 | 378906 | 2020-07-28 | Brooks | Texas | 48047 | 79 | 1 |
382123 | 382123 | 2020-07-29 | Brooks | Texas | 48047 | 80 | 1 |
385341 | 385341 | 2020-07-30 | Brooks | Texas | 48047 | 81 | 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);