ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Atascosa" and state = "Texas" 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 |
---|---|---|---|---|---|---|---|
12111 | 12111 | 2020-03-25 | Atascosa | Texas | 48013 | 2 | 0 |
13739 | 13739 | 2020-03-26 | Atascosa | Texas | 48013 | 2 | 0 |
15492 | 15492 | 2020-03-27 | Atascosa | Texas | 48013 | 2 | 0 |
17359 | 17359 | 2020-03-28 | Atascosa | Texas | 48013 | 2 | 0 |
19309 | 19309 | 2020-03-29 | Atascosa | Texas | 48013 | 2 | 0 |
21368 | 21368 | 2020-03-30 | Atascosa | Texas | 48013 | 2 | 0 |
23507 | 23507 | 2020-03-31 | Atascosa | Texas | 48013 | 2 | 0 |
25711 | 25711 | 2020-04-01 | Atascosa | Texas | 48013 | 2 | 0 |
27991 | 27991 | 2020-04-02 | Atascosa | Texas | 48013 | 2 | 0 |
30326 | 30326 | 2020-04-03 | Atascosa | Texas | 48013 | 2 | 0 |
32719 | 32719 | 2020-04-04 | Atascosa | Texas | 48013 | 2 | 0 |
35157 | 35157 | 2020-04-05 | Atascosa | Texas | 48013 | 2 | 0 |
37633 | 37633 | 2020-04-06 | Atascosa | Texas | 48013 | 4 | 0 |
40155 | 40155 | 2020-04-07 | Atascosa | Texas | 48013 | 4 | 0 |
42717 | 42717 | 2020-04-08 | Atascosa | Texas | 48013 | 5 | 0 |
45305 | 45305 | 2020-04-09 | Atascosa | Texas | 48013 | 5 | 0 |
47923 | 47923 | 2020-04-10 | Atascosa | Texas | 48013 | 8 | 0 |
50580 | 50580 | 2020-04-11 | Atascosa | Texas | 48013 | 8 | 0 |
53255 | 53255 | 2020-04-12 | Atascosa | Texas | 48013 | 9 | 0 |
55943 | 55943 | 2020-04-13 | Atascosa | Texas | 48013 | 9 | 0 |
58647 | 58647 | 2020-04-14 | Atascosa | Texas | 48013 | 9 | 0 |
61363 | 61363 | 2020-04-15 | Atascosa | Texas | 48013 | 9 | 0 |
64090 | 64090 | 2020-04-16 | Atascosa | Texas | 48013 | 9 | 0 |
66837 | 66837 | 2020-04-17 | Atascosa | Texas | 48013 | 9 | 0 |
69596 | 69596 | 2020-04-18 | Atascosa | Texas | 48013 | 10 | 1 |
72363 | 72363 | 2020-04-19 | Atascosa | Texas | 48013 | 10 | 1 |
75138 | 75138 | 2020-04-20 | Atascosa | Texas | 48013 | 12 | 1 |
77920 | 77920 | 2020-04-21 | Atascosa | Texas | 48013 | 14 | 1 |
80710 | 80710 | 2020-04-22 | Atascosa | Texas | 48013 | 14 | 1 |
83509 | 83509 | 2020-04-23 | Atascosa | Texas | 48013 | 14 | 1 |
86314 | 86314 | 2020-04-24 | Atascosa | Texas | 48013 | 14 | 1 |
89129 | 89129 | 2020-04-25 | Atascosa | Texas | 48013 | 14 | 1 |
91946 | 91946 | 2020-04-26 | Atascosa | Texas | 48013 | 14 | 1 |
94774 | 94774 | 2020-04-27 | Atascosa | Texas | 48013 | 14 | 1 |
97614 | 97614 | 2020-04-28 | Atascosa | Texas | 48013 | 16 | 1 |
100464 | 100464 | 2020-04-29 | Atascosa | Texas | 48013 | 16 | 1 |
103317 | 103317 | 2020-04-30 | Atascosa | Texas | 48013 | 19 | 1 |
106180 | 106180 | 2020-05-01 | Atascosa | Texas | 48013 | 19 | 1 |
109047 | 109047 | 2020-05-02 | Atascosa | Texas | 48013 | 19 | 1 |
111921 | 111921 | 2020-05-03 | Atascosa | Texas | 48013 | 19 | 1 |
114803 | 114803 | 2020-05-04 | Atascosa | Texas | 48013 | 19 | 1 |
117759 | 117759 | 2020-05-05 | Atascosa | Texas | 48013 | 19 | 1 |
120723 | 120723 | 2020-05-06 | Atascosa | Texas | 48013 | 21 | 1 |
123702 | 123702 | 2020-05-07 | Atascosa | Texas | 48013 | 22 | 1 |
126685 | 126685 | 2020-05-08 | Atascosa | Texas | 48013 | 22 | 1 |
129674 | 129674 | 2020-05-09 | Atascosa | Texas | 48013 | 22 | 1 |
132664 | 132664 | 2020-05-10 | Atascosa | Texas | 48013 | 22 | 1 |
135655 | 135655 | 2020-05-11 | Atascosa | Texas | 48013 | 24 | 1 |
138645 | 138645 | 2020-05-12 | Atascosa | Texas | 48013 | 27 | 1 |
141641 | 141641 | 2020-05-13 | Atascosa | Texas | 48013 | 27 | 1 |
144638 | 144638 | 2020-05-14 | Atascosa | Texas | 48013 | 27 | 1 |
147640 | 147640 | 2020-05-15 | Atascosa | Texas | 48013 | 30 | 1 |
150648 | 150648 | 2020-05-16 | Atascosa | Texas | 48013 | 30 | 1 |
153659 | 153659 | 2020-05-17 | Atascosa | Texas | 48013 | 30 | 1 |
156676 | 156676 | 2020-05-18 | Atascosa | Texas | 48013 | 30 | 1 |
159698 | 159698 | 2020-05-19 | Atascosa | Texas | 48013 | 32 | 1 |
162725 | 162725 | 2020-05-20 | Atascosa | Texas | 48013 | 32 | 1 |
165754 | 165754 | 2020-05-21 | Atascosa | Texas | 48013 | 35 | 1 |
168790 | 168790 | 2020-05-22 | Atascosa | Texas | 48013 | 35 | 1 |
171829 | 171829 | 2020-05-23 | Atascosa | Texas | 48013 | 36 | 1 |
174872 | 174872 | 2020-05-24 | Atascosa | Texas | 48013 | 36 | 2 |
177916 | 177916 | 2020-05-25 | Atascosa | Texas | 48013 | 36 | 2 |
180959 | 180959 | 2020-05-26 | Atascosa | Texas | 48013 | 36 | 2 |
184009 | 184009 | 2020-05-27 | Atascosa | Texas | 48013 | 36 | 2 |
187066 | 187066 | 2020-05-28 | Atascosa | Texas | 48013 | 36 | 2 |
190130 | 190130 | 2020-05-29 | Atascosa | Texas | 48013 | 36 | 2 |
193195 | 193195 | 2020-05-30 | Atascosa | Texas | 48013 | 36 | 2 |
196265 | 196265 | 2020-05-31 | Atascosa | Texas | 48013 | 37 | 2 |
199338 | 199338 | 2020-06-01 | Atascosa | Texas | 48013 | 37 | 2 |
202413 | 202413 | 2020-06-02 | Atascosa | Texas | 48013 | 37 | 2 |
205492 | 205492 | 2020-06-03 | Atascosa | Texas | 48013 | 37 | 2 |
208574 | 208574 | 2020-06-04 | Atascosa | Texas | 48013 | 38 | 2 |
211656 | 211656 | 2020-06-05 | Atascosa | Texas | 48013 | 41 | 2 |
214743 | 214743 | 2020-06-06 | Atascosa | Texas | 48013 | 41 | 2 |
217833 | 217833 | 2020-06-07 | Atascosa | Texas | 48013 | 42 | 2 |
220925 | 220925 | 2020-06-08 | Atascosa | Texas | 48013 | 42 | 2 |
224020 | 224020 | 2020-06-09 | Atascosa | Texas | 48013 | 42 | 2 |
227120 | 227120 | 2020-06-10 | Atascosa | Texas | 48013 | 45 | 2 |
230224 | 230224 | 2020-06-11 | Atascosa | Texas | 48013 | 43 | 2 |
233328 | 233328 | 2020-06-12 | Atascosa | Texas | 48013 | 43 | 2 |
236434 | 236434 | 2020-06-13 | Atascosa | Texas | 48013 | 42 | 2 |
239542 | 239542 | 2020-06-14 | Atascosa | Texas | 48013 | 42 | 2 |
242652 | 242652 | 2020-06-15 | Atascosa | Texas | 48013 | 42 | 2 |
245764 | 245764 | 2020-06-16 | Atascosa | Texas | 48013 | 42 | 2 |
248877 | 248877 | 2020-06-17 | Atascosa | Texas | 48013 | 42 | 2 |
251992 | 251992 | 2020-06-18 | Atascosa | Texas | 48013 | 45 | 2 |
255107 | 255107 | 2020-06-19 | Atascosa | Texas | 48013 | 62 | 2 |
258233 | 258233 | 2020-06-20 | Atascosa | Texas | 48013 | 69 | 2 |
261360 | 261360 | 2020-06-21 | Atascosa | Texas | 48013 | 70 | 2 |
264488 | 264488 | 2020-06-22 | Atascosa | Texas | 48013 | 70 | 2 |
267616 | 267616 | 2020-06-23 | Atascosa | Texas | 48013 | 79 | 2 |
270750 | 270750 | 2020-06-24 | Atascosa | Texas | 48013 | 84 | 2 |
273889 | 273889 | 2020-06-25 | Atascosa | Texas | 48013 | 87 | 2 |
277036 | 277036 | 2020-06-26 | Atascosa | Texas | 48013 | 85 | 2 |
280184 | 280184 | 2020-06-27 | Atascosa | Texas | 48013 | 87 | 2 |
283330 | 283330 | 2020-06-28 | Atascosa | Texas | 48013 | 90 | 2 |
286476 | 286476 | 2020-06-29 | Atascosa | Texas | 48013 | 90 | 2 |
289626 | 289626 | 2020-06-30 | Atascosa | Texas | 48013 | 106 | 2 |
292779 | 292779 | 2020-07-01 | Atascosa | Texas | 48013 | 108 | 2 |
295934 | 295934 | 2020-07-02 | Atascosa | Texas | 48013 | 116 | 2 |
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);