ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Deaf Smith" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
6963 | 6963 | 2020-03-21 | Deaf Smith | Texas | 48117 | 1 | 0 |
8093 | 8093 | 2020-03-22 | Deaf Smith | Texas | 48117 | 1 | 0 |
9311 | 9311 | 2020-03-23 | Deaf Smith | Texas | 48117 | 1 | 0 |
10647 | 10647 | 2020-03-24 | Deaf Smith | Texas | 48117 | 2 | 0 |
12132 | 12132 | 2020-03-25 | Deaf Smith | Texas | 48117 | 2 | 0 |
13761 | 13761 | 2020-03-26 | Deaf Smith | Texas | 48117 | 2 | 0 |
15515 | 15515 | 2020-03-27 | Deaf Smith | Texas | 48117 | 2 | 0 |
17384 | 17384 | 2020-03-28 | Deaf Smith | Texas | 48117 | 2 | 0 |
19335 | 19335 | 2020-03-29 | Deaf Smith | Texas | 48117 | 2 | 0 |
21394 | 21394 | 2020-03-30 | Deaf Smith | Texas | 48117 | 2 | 0 |
23533 | 23533 | 2020-03-31 | Deaf Smith | Texas | 48117 | 2 | 0 |
25741 | 25741 | 2020-04-01 | Deaf Smith | Texas | 48117 | 2 | 0 |
28021 | 28021 | 2020-04-02 | Deaf Smith | Texas | 48117 | 2 | 0 |
30356 | 30356 | 2020-04-03 | Deaf Smith | Texas | 48117 | 3 | 0 |
32749 | 32749 | 2020-04-04 | Deaf Smith | Texas | 48117 | 5 | 0 |
35187 | 35187 | 2020-04-05 | Deaf Smith | Texas | 48117 | 5 | 0 |
37663 | 37663 | 2020-04-06 | Deaf Smith | Texas | 48117 | 5 | 0 |
40188 | 40188 | 2020-04-07 | Deaf Smith | Texas | 48117 | 7 | 0 |
42751 | 42751 | 2020-04-08 | Deaf Smith | Texas | 48117 | 7 | 0 |
45340 | 45340 | 2020-04-09 | Deaf Smith | Texas | 48117 | 7 | 0 |
47960 | 47960 | 2020-04-10 | Deaf Smith | Texas | 48117 | 7 | 0 |
50617 | 50617 | 2020-04-11 | Deaf Smith | Texas | 48117 | 7 | 0 |
53292 | 53292 | 2020-04-12 | Deaf Smith | Texas | 48117 | 7 | 0 |
55980 | 55980 | 2020-04-13 | Deaf Smith | Texas | 48117 | 8 | 0 |
58684 | 58684 | 2020-04-14 | Deaf Smith | Texas | 48117 | 11 | 0 |
61401 | 61401 | 2020-04-15 | Deaf Smith | Texas | 48117 | 11 | 0 |
64128 | 64128 | 2020-04-16 | Deaf Smith | Texas | 48117 | 11 | 0 |
66875 | 66875 | 2020-04-17 | Deaf Smith | Texas | 48117 | 11 | 0 |
69635 | 69635 | 2020-04-18 | Deaf Smith | Texas | 48117 | 11 | 0 |
72403 | 72403 | 2020-04-19 | Deaf Smith | Texas | 48117 | 12 | 0 |
75178 | 75178 | 2020-04-20 | Deaf Smith | Texas | 48117 | 12 | 0 |
77960 | 77960 | 2020-04-21 | Deaf Smith | Texas | 48117 | 14 | 0 |
80751 | 80751 | 2020-04-22 | Deaf Smith | Texas | 48117 | 14 | 0 |
83551 | 83551 | 2020-04-23 | Deaf Smith | Texas | 48117 | 17 | 0 |
86356 | 86356 | 2020-04-24 | Deaf Smith | Texas | 48117 | 21 | 0 |
89171 | 89171 | 2020-04-25 | Deaf Smith | Texas | 48117 | 21 | 0 |
91988 | 91988 | 2020-04-26 | Deaf Smith | Texas | 48117 | 21 | 0 |
94817 | 94817 | 2020-04-27 | Deaf Smith | Texas | 48117 | 25 | 0 |
97657 | 97657 | 2020-04-28 | Deaf Smith | Texas | 48117 | 26 | 0 |
100507 | 100507 | 2020-04-29 | Deaf Smith | Texas | 48117 | 26 | 0 |
103360 | 103360 | 2020-04-30 | Deaf Smith | Texas | 48117 | 31 | 0 |
106224 | 106224 | 2020-05-01 | Deaf Smith | Texas | 48117 | 31 | 0 |
109093 | 109093 | 2020-05-02 | Deaf Smith | Texas | 48117 | 34 | 0 |
111967 | 111967 | 2020-05-03 | Deaf Smith | Texas | 48117 | 35 | 0 |
114849 | 114849 | 2020-05-04 | Deaf Smith | Texas | 48117 | 37 | 0 |
117808 | 117808 | 2020-05-05 | Deaf Smith | Texas | 48117 | 38 | 0 |
120772 | 120772 | 2020-05-06 | Deaf Smith | Texas | 48117 | 41 | 0 |
123751 | 123751 | 2020-05-07 | Deaf Smith | Texas | 48117 | 41 | 0 |
126734 | 126734 | 2020-05-08 | Deaf Smith | Texas | 48117 | 46 | 0 |
129723 | 129723 | 2020-05-09 | Deaf Smith | Texas | 48117 | 46 | 0 |
132713 | 132713 | 2020-05-10 | Deaf Smith | Texas | 48117 | 59 | 0 |
135704 | 135704 | 2020-05-11 | Deaf Smith | Texas | 48117 | 59 | 0 |
138694 | 138694 | 2020-05-12 | Deaf Smith | Texas | 48117 | 67 | 1 |
141690 | 141690 | 2020-05-13 | Deaf Smith | Texas | 48117 | 92 | 2 |
144687 | 144687 | 2020-05-14 | Deaf Smith | Texas | 48117 | 93 | 2 |
147689 | 147689 | 2020-05-15 | Deaf Smith | Texas | 48117 | 119 | 2 |
150697 | 150697 | 2020-05-16 | Deaf Smith | Texas | 48117 | 120 | 6 |
153708 | 153708 | 2020-05-17 | Deaf Smith | Texas | 48117 | 122 | 6 |
156725 | 156725 | 2020-05-18 | Deaf Smith | Texas | 48117 | 122 | 6 |
159747 | 159747 | 2020-05-19 | Deaf Smith | Texas | 48117 | 133 | 7 |
162774 | 162774 | 2020-05-20 | Deaf Smith | Texas | 48117 | 139 | 7 |
165803 | 165803 | 2020-05-21 | Deaf Smith | Texas | 48117 | 141 | 7 |
168839 | 168839 | 2020-05-22 | Deaf Smith | Texas | 48117 | 141 | 7 |
171878 | 171878 | 2020-05-23 | Deaf Smith | Texas | 48117 | 157 | 12 |
174921 | 174921 | 2020-05-24 | Deaf Smith | Texas | 48117 | 157 | 13 |
177965 | 177965 | 2020-05-25 | Deaf Smith | Texas | 48117 | 157 | 13 |
187115 | 187115 | 2020-05-28 | Deaf Smith | Texas | 48117 | 161 | 13 |
190179 | 190179 | 2020-05-29 | Deaf Smith | Texas | 48117 | 162 | 13 |
193244 | 193244 | 2020-05-30 | Deaf Smith | Texas | 48117 | 164 | 13 |
196314 | 196314 | 2020-05-31 | Deaf Smith | Texas | 48117 | 164 | 13 |
199387 | 199387 | 2020-06-01 | Deaf Smith | Texas | 48117 | 164 | 13 |
202462 | 202462 | 2020-06-02 | Deaf Smith | Texas | 48117 | 163 | 13 |
205541 | 205541 | 2020-06-03 | Deaf Smith | Texas | 48117 | 166 | 13 |
208623 | 208623 | 2020-06-04 | Deaf Smith | Texas | 48117 | 166 | 13 |
211707 | 211707 | 2020-06-05 | Deaf Smith | Texas | 48117 | 174 | 13 |
214794 | 214794 | 2020-06-06 | Deaf Smith | Texas | 48117 | 176 | 13 |
217884 | 217884 | 2020-06-07 | Deaf Smith | Texas | 48117 | 176 | 13 |
220976 | 220976 | 2020-06-08 | Deaf Smith | Texas | 48117 | 176 | 13 |
224071 | 224071 | 2020-06-09 | Deaf Smith | Texas | 48117 | 183 | 13 |
227171 | 227171 | 2020-06-10 | Deaf Smith | Texas | 48117 | 190 | 13 |
181008 | 181008 | 2020-05-26 | Deaf Smith | Texas | 48117 | 157 | 14 |
184058 | 184058 | 2020-05-27 | Deaf Smith | Texas | 48117 | 158 | 14 |
230275 | 230275 | 2020-06-11 | Deaf Smith | Texas | 48117 | 192 | 14 |
233379 | 233379 | 2020-06-12 | Deaf Smith | Texas | 48117 | 203 | 14 |
236485 | 236485 | 2020-06-13 | Deaf Smith | Texas | 48117 | 212 | 14 |
239593 | 239593 | 2020-06-14 | Deaf Smith | Texas | 48117 | 212 | 14 |
242703 | 242703 | 2020-06-15 | Deaf Smith | Texas | 48117 | 212 | 14 |
245815 | 245815 | 2020-06-16 | Deaf Smith | Texas | 48117 | 222 | 14 |
375726 | 375726 | 2020-07-27 | Deaf Smith | Texas | 48117 | 510 | 15 |
248928 | 248928 | 2020-06-17 | Deaf Smith | Texas | 48117 | 223 | 16 |
252043 | 252043 | 2020-06-18 | Deaf Smith | Texas | 48117 | 226 | 16 |
255158 | 255158 | 2020-06-19 | Deaf Smith | Texas | 48117 | 233 | 16 |
258285 | 258285 | 2020-06-20 | Deaf Smith | Texas | 48117 | 233 | 16 |
261412 | 261412 | 2020-06-21 | Deaf Smith | Texas | 48117 | 233 | 16 |
264540 | 264540 | 2020-06-22 | Deaf Smith | Texas | 48117 | 242 | 16 |
267668 | 267668 | 2020-06-23 | Deaf Smith | Texas | 48117 | 254 | 16 |
270802 | 270802 | 2020-06-24 | Deaf Smith | Texas | 48117 | 262 | 16 |
273941 | 273941 | 2020-06-25 | Deaf Smith | Texas | 48117 | 268 | 16 |
277088 | 277088 | 2020-06-26 | Deaf Smith | Texas | 48117 | 284 | 16 |
280236 | 280236 | 2020-06-27 | Deaf Smith | Texas | 48117 | 287 | 16 |
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);