ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,536 rows where county = "Guadalupe" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
12147 | 12147 | 2020-03-25 | Guadalupe | Texas | 48187 | 4 | 0 |
13776 | 13776 | 2020-03-26 | Guadalupe | Texas | 48187 | 8 | 0 |
15530 | 15530 | 2020-03-27 | Guadalupe | Texas | 48187 | 8 | 0 |
17399 | 17399 | 2020-03-28 | Guadalupe | Texas | 48187 | 8 | 0 |
19352 | 19352 | 2020-03-29 | Guadalupe | Texas | 48187 | 10 | 0 |
21411 | 21411 | 2020-03-30 | Guadalupe | Texas | 48187 | 13 | 0 |
23550 | 23550 | 2020-03-31 | Guadalupe | Texas | 48187 | 15 | 0 |
25760 | 25760 | 2020-04-01 | Guadalupe | Texas | 48187 | 17 | 0 |
28043 | 28043 | 2020-04-02 | Guadalupe | Texas | 48187 | 20 | 0 |
30378 | 30378 | 2020-04-03 | Guadalupe | Texas | 48187 | 23 | 0 |
32771 | 32771 | 2020-04-04 | Guadalupe | Texas | 48187 | 26 | 0 |
35209 | 35209 | 2020-04-05 | Guadalupe | Texas | 48187 | 28 | 0 |
37685 | 37685 | 2020-04-06 | Guadalupe | Texas | 48187 | 28 | 0 |
40210 | 40210 | 2020-04-07 | Guadalupe | Texas | 48187 | 39 | 0 |
42777 | 42777 | 2020-04-08 | Guadalupe | Texas | 48187 | 45 | 0 |
45366 | 45366 | 2020-04-09 | Guadalupe | Texas | 48187 | 45 | 0 |
47986 | 47986 | 2020-04-10 | Guadalupe | Texas | 48187 | 47 | 0 |
50644 | 50644 | 2020-04-11 | Guadalupe | Texas | 48187 | 47 | 0 |
53319 | 53319 | 2020-04-12 | Guadalupe | Texas | 48187 | 49 | 0 |
56007 | 56007 | 2020-04-13 | Guadalupe | Texas | 48187 | 49 | 0 |
58712 | 58712 | 2020-04-14 | Guadalupe | Texas | 48187 | 50 | 0 |
61430 | 61430 | 2020-04-15 | Guadalupe | Texas | 48187 | 50 | 0 |
64157 | 64157 | 2020-04-16 | Guadalupe | Texas | 48187 | 53 | 0 |
66904 | 66904 | 2020-04-17 | Guadalupe | Texas | 48187 | 53 | 0 |
68950 | 68950 | 2020-04-18 | Guadalupe | New Mexico | 35019 | 1 | 0 |
69664 | 69664 | 2020-04-18 | Guadalupe | Texas | 48187 | 53 | 0 |
71717 | 71717 | 2020-04-19 | Guadalupe | New Mexico | 35019 | 1 | 0 |
72432 | 72432 | 2020-04-19 | Guadalupe | Texas | 48187 | 57 | 0 |
74492 | 74492 | 2020-04-20 | Guadalupe | New Mexico | 35019 | 1 | 0 |
75207 | 75207 | 2020-04-20 | Guadalupe | Texas | 48187 | 58 | 0 |
77273 | 77273 | 2020-04-21 | Guadalupe | New Mexico | 35019 | 1 | 0 |
77989 | 77989 | 2020-04-21 | Guadalupe | Texas | 48187 | 60 | 0 |
80062 | 80062 | 2020-04-22 | Guadalupe | New Mexico | 35019 | 2 | 0 |
80780 | 80780 | 2020-04-22 | Guadalupe | Texas | 48187 | 63 | 0 |
82860 | 82860 | 2020-04-23 | Guadalupe | New Mexico | 35019 | 3 | 0 |
83580 | 83580 | 2020-04-23 | Guadalupe | Texas | 48187 | 64 | 0 |
85664 | 85664 | 2020-04-24 | Guadalupe | New Mexico | 35019 | 7 | 0 |
86385 | 86385 | 2020-04-24 | Guadalupe | Texas | 48187 | 64 | 0 |
88475 | 88475 | 2020-04-25 | Guadalupe | New Mexico | 35019 | 12 | 0 |
89200 | 89200 | 2020-04-25 | Guadalupe | Texas | 48187 | 67 | 0 |
91290 | 91290 | 2020-04-26 | Guadalupe | New Mexico | 35019 | 13 | 0 |
92017 | 92017 | 2020-04-26 | Guadalupe | Texas | 48187 | 68 | 0 |
94114 | 94114 | 2020-04-27 | Guadalupe | New Mexico | 35019 | 13 | 0 |
94846 | 94846 | 2020-04-27 | Guadalupe | Texas | 48187 | 69 | 0 |
96950 | 96950 | 2020-04-28 | Guadalupe | New Mexico | 35019 | 13 | 0 |
97686 | 97686 | 2020-04-28 | Guadalupe | Texas | 48187 | 69 | 0 |
99797 | 99797 | 2020-04-29 | Guadalupe | New Mexico | 35019 | 14 | 0 |
100536 | 100536 | 2020-04-29 | Guadalupe | Texas | 48187 | 80 | 0 |
102650 | 102650 | 2020-04-30 | Guadalupe | New Mexico | 35019 | 14 | 0 |
103391 | 103391 | 2020-04-30 | Guadalupe | Texas | 48187 | 80 | 0 |
105512 | 105512 | 2020-05-01 | Guadalupe | New Mexico | 35019 | 14 | 0 |
106255 | 106255 | 2020-05-01 | Guadalupe | Texas | 48187 | 81 | 0 |
108378 | 108378 | 2020-05-02 | Guadalupe | New Mexico | 35019 | 14 | 0 |
109124 | 109124 | 2020-05-02 | Guadalupe | Texas | 48187 | 85 | 0 |
111251 | 111251 | 2020-05-03 | Guadalupe | New Mexico | 35019 | 15 | 0 |
111998 | 111998 | 2020-05-03 | Guadalupe | Texas | 48187 | 85 | 0 |
114132 | 114132 | 2020-05-04 | Guadalupe | New Mexico | 35019 | 15 | 0 |
114880 | 114880 | 2020-05-04 | Guadalupe | Texas | 48187 | 86 | 0 |
117013 | 117013 | 2020-05-05 | Guadalupe | New Mexico | 35019 | 15 | 0 |
117839 | 117839 | 2020-05-05 | Guadalupe | Texas | 48187 | 87 | 0 |
119974 | 119974 | 2020-05-06 | Guadalupe | New Mexico | 35019 | 15 | 0 |
120803 | 120803 | 2020-05-06 | Guadalupe | Texas | 48187 | 88 | 0 |
122949 | 122949 | 2020-05-07 | Guadalupe | New Mexico | 35019 | 15 | 0 |
123782 | 123782 | 2020-05-07 | Guadalupe | Texas | 48187 | 90 | 0 |
125932 | 125932 | 2020-05-08 | Guadalupe | New Mexico | 35019 | 15 | 0 |
126765 | 126765 | 2020-05-08 | Guadalupe | Texas | 48187 | 92 | 0 |
128921 | 128921 | 2020-05-09 | Guadalupe | New Mexico | 35019 | 15 | 0 |
129754 | 129754 | 2020-05-09 | Guadalupe | Texas | 48187 | 92 | 0 |
131910 | 131910 | 2020-05-10 | Guadalupe | New Mexico | 35019 | 15 | 0 |
132744 | 132744 | 2020-05-10 | Guadalupe | Texas | 48187 | 95 | 0 |
134901 | 134901 | 2020-05-11 | Guadalupe | New Mexico | 35019 | 15 | 0 |
135735 | 135735 | 2020-05-11 | Guadalupe | Texas | 48187 | 97 | 0 |
137891 | 137891 | 2020-05-12 | Guadalupe | New Mexico | 35019 | 17 | 0 |
138725 | 138725 | 2020-05-12 | Guadalupe | Texas | 48187 | 99 | 0 |
140887 | 140887 | 2020-05-13 | Guadalupe | New Mexico | 35019 | 17 | 0 |
141721 | 141721 | 2020-05-13 | Guadalupe | Texas | 48187 | 99 | 0 |
143882 | 143882 | 2020-05-14 | Guadalupe | New Mexico | 35019 | 17 | 0 |
144718 | 144718 | 2020-05-14 | Guadalupe | Texas | 48187 | 101 | 0 |
146883 | 146883 | 2020-05-15 | Guadalupe | New Mexico | 35019 | 19 | 0 |
147721 | 147721 | 2020-05-15 | Guadalupe | Texas | 48187 | 106 | 0 |
149890 | 149890 | 2020-05-16 | Guadalupe | New Mexico | 35019 | 19 | 0 |
150729 | 150729 | 2020-05-16 | Guadalupe | Texas | 48187 | 109 | 0 |
152900 | 152900 | 2020-05-17 | Guadalupe | New Mexico | 35019 | 19 | 0 |
153740 | 153740 | 2020-05-17 | Guadalupe | Texas | 48187 | 110 | 0 |
155916 | 155916 | 2020-05-18 | Guadalupe | New Mexico | 35019 | 19 | 0 |
156757 | 156757 | 2020-05-18 | Guadalupe | Texas | 48187 | 110 | 0 |
158934 | 158934 | 2020-05-19 | Guadalupe | New Mexico | 35019 | 19 | 0 |
159779 | 159779 | 2020-05-19 | Guadalupe | Texas | 48187 | 110 | 0 |
161960 | 161960 | 2020-05-20 | Guadalupe | New Mexico | 35019 | 19 | 0 |
162806 | 162806 | 2020-05-20 | Guadalupe | Texas | 48187 | 114 | 0 |
164989 | 164989 | 2020-05-21 | Guadalupe | New Mexico | 35019 | 19 | 0 |
165835 | 165835 | 2020-05-21 | Guadalupe | Texas | 48187 | 116 | 0 |
168025 | 168025 | 2020-05-22 | Guadalupe | New Mexico | 35019 | 19 | 0 |
168871 | 168871 | 2020-05-22 | Guadalupe | Texas | 48187 | 116 | 0 |
171064 | 171064 | 2020-05-23 | Guadalupe | New Mexico | 35019 | 19 | 0 |
171910 | 171910 | 2020-05-23 | Guadalupe | Texas | 48187 | 122 | 0 |
174106 | 174106 | 2020-05-24 | Guadalupe | New Mexico | 35019 | 19 | 0 |
174953 | 174953 | 2020-05-24 | Guadalupe | Texas | 48187 | 122 | 0 |
177149 | 177149 | 2020-05-25 | Guadalupe | New Mexico | 35019 | 19 | 0 |
177997 | 177997 | 2020-05-25 | Guadalupe | Texas | 48187 | 122 | 0 |
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);