ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Wilson" and state = "Texas" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
12195 | 12195 | 2020-03-25 | Wilson | Texas | 48493 | 1 | 0 |
13830 | 13830 | 2020-03-26 | Wilson | Texas | 48493 | 1 | 0 |
15594 | 15594 | 2020-03-27 | Wilson | Texas | 48493 | 1 | 0 |
17466 | 17466 | 2020-03-28 | Wilson | Texas | 48493 | 2 | 0 |
19425 | 19425 | 2020-03-29 | Wilson | Texas | 48493 | 2 | 0 |
21487 | 21487 | 2020-03-30 | Wilson | Texas | 48493 | 2 | 0 |
23626 | 23626 | 2020-03-31 | Wilson | Texas | 48493 | 3 | 0 |
25840 | 25840 | 2020-04-01 | Wilson | Texas | 48493 | 5 | 0 |
28128 | 28128 | 2020-04-02 | Wilson | Texas | 48493 | 5 | 0 |
30465 | 30465 | 2020-04-03 | Wilson | Texas | 48493 | 6 | 0 |
32863 | 32863 | 2020-04-04 | Wilson | Texas | 48493 | 6 | 0 |
35301 | 35301 | 2020-04-05 | Wilson | Texas | 48493 | 6 | 0 |
37778 | 37778 | 2020-04-06 | Wilson | Texas | 48493 | 6 | 0 |
40307 | 40307 | 2020-04-07 | Wilson | Texas | 48493 | 7 | 0 |
42875 | 42875 | 2020-04-08 | Wilson | Texas | 48493 | 7 | 0 |
45469 | 45469 | 2020-04-09 | Wilson | Texas | 48493 | 9 | 0 |
48092 | 48092 | 2020-04-10 | Wilson | Texas | 48493 | 10 | 0 |
50750 | 50750 | 2020-04-11 | Wilson | Texas | 48493 | 10 | 0 |
53425 | 53425 | 2020-04-12 | Wilson | Texas | 48493 | 11 | 0 |
56114 | 56114 | 2020-04-13 | Wilson | Texas | 48493 | 11 | 0 |
58820 | 58820 | 2020-04-14 | Wilson | Texas | 48493 | 11 | 1 |
61538 | 61538 | 2020-04-15 | Wilson | Texas | 48493 | 12 | 1 |
64270 | 64270 | 2020-04-16 | Wilson | Texas | 48493 | 13 | 1 |
67017 | 67017 | 2020-04-17 | Wilson | Texas | 48493 | 19 | 1 |
69777 | 69777 | 2020-04-18 | Wilson | Texas | 48493 | 19 | 1 |
72547 | 72547 | 2020-04-19 | Wilson | Texas | 48493 | 21 | 1 |
75323 | 75323 | 2020-04-20 | Wilson | Texas | 48493 | 21 | 1 |
78105 | 78105 | 2020-04-21 | Wilson | Texas | 48493 | 22 | 1 |
80897 | 80897 | 2020-04-22 | Wilson | Texas | 48493 | 23 | 2 |
83698 | 83698 | 2020-04-23 | Wilson | Texas | 48493 | 25 | 2 |
86505 | 86505 | 2020-04-24 | Wilson | Texas | 48493 | 25 | 2 |
89320 | 89320 | 2020-04-25 | Wilson | Texas | 48493 | 26 | 2 |
92137 | 92137 | 2020-04-26 | Wilson | Texas | 48493 | 29 | 2 |
94966 | 94966 | 2020-04-27 | Wilson | Texas | 48493 | 29 | 2 |
97808 | 97808 | 2020-04-28 | Wilson | Texas | 48493 | 29 | 2 |
100658 | 100658 | 2020-04-29 | Wilson | Texas | 48493 | 31 | 2 |
103513 | 103513 | 2020-04-30 | Wilson | Texas | 48493 | 32 | 3 |
106377 | 106377 | 2020-05-01 | Wilson | Texas | 48493 | 32 | 3 |
109246 | 109246 | 2020-05-02 | Wilson | Texas | 48493 | 33 | 3 |
112120 | 112120 | 2020-05-03 | Wilson | Texas | 48493 | 33 | 3 |
115003 | 115003 | 2020-05-04 | Wilson | Texas | 48493 | 33 | 3 |
117962 | 117962 | 2020-05-05 | Wilson | Texas | 48493 | 34 | 3 |
120926 | 120926 | 2020-05-06 | Wilson | Texas | 48493 | 34 | 4 |
123906 | 123906 | 2020-05-07 | Wilson | Texas | 48493 | 34 | 4 |
126891 | 126891 | 2020-05-08 | Wilson | Texas | 48493 | 34 | 4 |
129880 | 129880 | 2020-05-09 | Wilson | Texas | 48493 | 34 | 4 |
132870 | 132870 | 2020-05-10 | Wilson | Texas | 48493 | 35 | 4 |
135861 | 135861 | 2020-05-11 | Wilson | Texas | 48493 | 36 | 4 |
138851 | 138851 | 2020-05-12 | Wilson | Texas | 48493 | 36 | 4 |
141847 | 141847 | 2020-05-13 | Wilson | Texas | 48493 | 36 | 4 |
144844 | 144844 | 2020-05-14 | Wilson | Texas | 48493 | 36 | 4 |
147848 | 147848 | 2020-05-15 | Wilson | Texas | 48493 | 36 | 4 |
150856 | 150856 | 2020-05-16 | Wilson | Texas | 48493 | 36 | 4 |
153867 | 153867 | 2020-05-17 | Wilson | Texas | 48493 | 36 | 5 |
156884 | 156884 | 2020-05-18 | Wilson | Texas | 48493 | 36 | 5 |
159908 | 159908 | 2020-05-19 | Wilson | Texas | 48493 | 37 | 5 |
162936 | 162936 | 2020-05-20 | Wilson | Texas | 48493 | 37 | 5 |
165965 | 165965 | 2020-05-21 | Wilson | Texas | 48493 | 38 | 5 |
169001 | 169001 | 2020-05-22 | Wilson | Texas | 48493 | 38 | 5 |
172042 | 172042 | 2020-05-23 | Wilson | Texas | 48493 | 38 | 5 |
175085 | 175085 | 2020-05-24 | Wilson | Texas | 48493 | 38 | 5 |
178130 | 178130 | 2020-05-25 | Wilson | Texas | 48493 | 38 | 5 |
181174 | 181174 | 2020-05-26 | Wilson | Texas | 48493 | 38 | 5 |
184225 | 184225 | 2020-05-27 | Wilson | Texas | 48493 | 38 | 5 |
187282 | 187282 | 2020-05-28 | Wilson | Texas | 48493 | 38 | 5 |
190346 | 190346 | 2020-05-29 | Wilson | Texas | 48493 | 38 | 5 |
193412 | 193412 | 2020-05-30 | Wilson | Texas | 48493 | 38 | 5 |
196482 | 196482 | 2020-05-31 | Wilson | Texas | 48493 | 38 | 5 |
199555 | 199555 | 2020-06-01 | Wilson | Texas | 48493 | 38 | 5 |
202631 | 202631 | 2020-06-02 | Wilson | Texas | 48493 | 40 | 5 |
205710 | 205710 | 2020-06-03 | Wilson | Texas | 48493 | 41 | 5 |
208792 | 208792 | 2020-06-04 | Wilson | Texas | 48493 | 41 | 5 |
211877 | 211877 | 2020-06-05 | Wilson | Texas | 48493 | 44 | 5 |
214964 | 214964 | 2020-06-06 | Wilson | Texas | 48493 | 44 | 5 |
218054 | 218054 | 2020-06-07 | Wilson | Texas | 48493 | 45 | 5 |
221146 | 221146 | 2020-06-08 | Wilson | Texas | 48493 | 45 | 5 |
224242 | 224242 | 2020-06-09 | Wilson | Texas | 48493 | 45 | 5 |
227342 | 227342 | 2020-06-10 | Wilson | Texas | 48493 | 46 | 5 |
230446 | 230446 | 2020-06-11 | Wilson | Texas | 48493 | 46 | 5 |
233550 | 233550 | 2020-06-12 | Wilson | Texas | 48493 | 50 | 5 |
236657 | 236657 | 2020-06-13 | Wilson | Texas | 48493 | 52 | 5 |
239765 | 239765 | 2020-06-14 | Wilson | Texas | 48493 | 52 | 5 |
242875 | 242875 | 2020-06-15 | Wilson | Texas | 48493 | 52 | 5 |
245987 | 245987 | 2020-06-16 | Wilson | Texas | 48493 | 53 | 5 |
249100 | 249100 | 2020-06-17 | Wilson | Texas | 48493 | 53 | 5 |
252215 | 252215 | 2020-06-18 | Wilson | Texas | 48493 | 55 | 5 |
255332 | 255332 | 2020-06-19 | Wilson | Texas | 48493 | 65 | 5 |
258459 | 258459 | 2020-06-20 | Wilson | Texas | 48493 | 69 | 5 |
261586 | 261586 | 2020-06-21 | Wilson | Texas | 48493 | 72 | 5 |
264715 | 264715 | 2020-06-22 | Wilson | Texas | 48493 | 72 | 5 |
267844 | 267844 | 2020-06-23 | Wilson | Texas | 48493 | 76 | 5 |
270978 | 270978 | 2020-06-24 | Wilson | Texas | 48493 | 80 | 5 |
274118 | 274118 | 2020-06-25 | Wilson | Texas | 48493 | 83 | 5 |
277266 | 277266 | 2020-06-26 | Wilson | Texas | 48493 | 83 | 5 |
283560 | 283560 | 2020-06-28 | Wilson | Texas | 48493 | 86 | 5 |
286706 | 286706 | 2020-06-29 | Wilson | Texas | 48493 | 86 | 5 |
280414 | 280414 | 2020-06-27 | Wilson | Texas | 48493 | 88 | 5 |
289856 | 289856 | 2020-06-30 | Wilson | Texas | 48493 | 98 | 5 |
293009 | 293009 | 2020-07-01 | Wilson | Texas | 48493 | 101 | 5 |
296164 | 296164 | 2020-07-02 | Wilson | Texas | 48493 | 111 | 5 |
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);