ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where fips = 48349 and state = "Texas" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
15564 | 15564 | 2020-03-27 | Navarro | Texas | 48349 | 1 | 0 |
17435 | 17435 | 2020-03-28 | Navarro | Texas | 48349 | 1 | 0 |
19390 | 19390 | 2020-03-29 | Navarro | Texas | 48349 | 1 | 0 |
21452 | 21452 | 2020-03-30 | Navarro | Texas | 48349 | 3 | 0 |
23591 | 23591 | 2020-03-31 | Navarro | Texas | 48349 | 3 | 0 |
25803 | 25803 | 2020-04-01 | Navarro | Texas | 48349 | 4 | 0 |
28089 | 28089 | 2020-04-02 | Navarro | Texas | 48349 | 4 | 1 |
30425 | 30425 | 2020-04-03 | Navarro | Texas | 48349 | 5 | 1 |
32821 | 32821 | 2020-04-04 | Navarro | Texas | 48349 | 5 | 1 |
35259 | 35259 | 2020-04-05 | Navarro | Texas | 48349 | 7 | 2 |
37735 | 37735 | 2020-04-06 | Navarro | Texas | 48349 | 8 | 2 |
40264 | 40264 | 2020-04-07 | Navarro | Texas | 48349 | 8 | 2 |
42832 | 42832 | 2020-04-08 | Navarro | Texas | 48349 | 8 | 2 |
45424 | 45424 | 2020-04-09 | Navarro | Texas | 48349 | 11 | 2 |
48045 | 48045 | 2020-04-10 | Navarro | Texas | 48349 | 11 | 2 |
50703 | 50703 | 2020-04-11 | Navarro | Texas | 48349 | 12 | 2 |
53378 | 53378 | 2020-04-12 | Navarro | Texas | 48349 | 12 | 2 |
56067 | 56067 | 2020-04-13 | Navarro | Texas | 48349 | 12 | 2 |
58772 | 58772 | 2020-04-14 | Navarro | Texas | 48349 | 16 | 2 |
61490 | 61490 | 2020-04-15 | Navarro | Texas | 48349 | 16 | 2 |
64219 | 64219 | 2020-04-16 | Navarro | Texas | 48349 | 18 | 2 |
66966 | 66966 | 2020-04-17 | Navarro | Texas | 48349 | 20 | 2 |
69726 | 69726 | 2020-04-18 | Navarro | Texas | 48349 | 20 | 2 |
72495 | 72495 | 2020-04-19 | Navarro | Texas | 48349 | 20 | 2 |
75271 | 75271 | 2020-04-20 | Navarro | Texas | 48349 | 20 | 2 |
78053 | 78053 | 2020-04-21 | Navarro | Texas | 48349 | 23 | 2 |
80844 | 80844 | 2020-04-22 | Navarro | Texas | 48349 | 24 | 2 |
83645 | 83645 | 2020-04-23 | Navarro | Texas | 48349 | 25 | 2 |
86450 | 86450 | 2020-04-24 | Navarro | Texas | 48349 | 26 | 2 |
89265 | 89265 | 2020-04-25 | Navarro | Texas | 48349 | 28 | 2 |
92082 | 92082 | 2020-04-26 | Navarro | Texas | 48349 | 28 | 2 |
94911 | 94911 | 2020-04-27 | Navarro | Texas | 48349 | 28 | 2 |
97752 | 97752 | 2020-04-28 | Navarro | Texas | 48349 | 28 | 2 |
100602 | 100602 | 2020-04-29 | Navarro | Texas | 48349 | 30 | 2 |
103457 | 103457 | 2020-04-30 | Navarro | Texas | 48349 | 30 | 2 |
106321 | 106321 | 2020-05-01 | Navarro | Texas | 48349 | 31 | 2 |
109190 | 109190 | 2020-05-02 | Navarro | Texas | 48349 | 31 | 2 |
112064 | 112064 | 2020-05-03 | Navarro | Texas | 48349 | 31 | 2 |
114946 | 114946 | 2020-05-04 | Navarro | Texas | 48349 | 31 | 2 |
117905 | 117905 | 2020-05-05 | Navarro | Texas | 48349 | 31 | 2 |
120869 | 120869 | 2020-05-06 | Navarro | Texas | 48349 | 33 | 2 |
123848 | 123848 | 2020-05-07 | Navarro | Texas | 48349 | 34 | 2 |
126832 | 126832 | 2020-05-08 | Navarro | Texas | 48349 | 36 | 2 |
129821 | 129821 | 2020-05-09 | Navarro | Texas | 48349 | 36 | 2 |
132811 | 132811 | 2020-05-10 | Navarro | Texas | 48349 | 36 | 2 |
135802 | 135802 | 2020-05-11 | Navarro | Texas | 48349 | 36 | 2 |
138792 | 138792 | 2020-05-12 | Navarro | Texas | 48349 | 36 | 2 |
141788 | 141788 | 2020-05-13 | Navarro | Texas | 48349 | 37 | 2 |
144785 | 144785 | 2020-05-14 | Navarro | Texas | 48349 | 37 | 2 |
147789 | 147789 | 2020-05-15 | Navarro | Texas | 48349 | 38 | 2 |
150797 | 150797 | 2020-05-16 | Navarro | Texas | 48349 | 38 | 2 |
153808 | 153808 | 2020-05-17 | Navarro | Texas | 48349 | 38 | 2 |
156825 | 156825 | 2020-05-18 | Navarro | Texas | 48349 | 38 | 2 |
159848 | 159848 | 2020-05-19 | Navarro | Texas | 48349 | 38 | 2 |
162876 | 162876 | 2020-05-20 | Navarro | Texas | 48349 | 40 | 2 |
165905 | 165905 | 2020-05-21 | Navarro | Texas | 48349 | 40 | 2 |
168941 | 168941 | 2020-05-22 | Navarro | Texas | 48349 | 40 | 2 |
171981 | 171981 | 2020-05-23 | Navarro | Texas | 48349 | 44 | 2 |
175024 | 175024 | 2020-05-24 | Navarro | Texas | 48349 | 44 | 2 |
178068 | 178068 | 2020-05-25 | Navarro | Texas | 48349 | 44 | 2 |
181112 | 181112 | 2020-05-26 | Navarro | Texas | 48349 | 45 | 2 |
184162 | 184162 | 2020-05-27 | Navarro | Texas | 48349 | 49 | 2 |
187219 | 187219 | 2020-05-28 | Navarro | Texas | 48349 | 49 | 2 |
190283 | 190283 | 2020-05-29 | Navarro | Texas | 48349 | 50 | 2 |
193349 | 193349 | 2020-05-30 | Navarro | Texas | 48349 | 55 | 2 |
196419 | 196419 | 2020-05-31 | Navarro | Texas | 48349 | 56 | 2 |
199492 | 199492 | 2020-06-01 | Navarro | Texas | 48349 | 56 | 2 |
202568 | 202568 | 2020-06-02 | Navarro | Texas | 48349 | 57 | 2 |
205647 | 205647 | 2020-06-03 | Navarro | Texas | 48349 | 58 | 2 |
208729 | 208729 | 2020-06-04 | Navarro | Texas | 48349 | 61 | 2 |
211813 | 211813 | 2020-06-05 | Navarro | Texas | 48349 | 64 | 2 |
214900 | 214900 | 2020-06-06 | Navarro | Texas | 48349 | 66 | 2 |
217990 | 217990 | 2020-06-07 | Navarro | Texas | 48349 | 66 | 2 |
221082 | 221082 | 2020-06-08 | Navarro | Texas | 48349 | 66 | 2 |
224177 | 224177 | 2020-06-09 | Navarro | Texas | 48349 | 70 | 2 |
227277 | 227277 | 2020-06-10 | Navarro | Texas | 48349 | 70 | 3 |
230381 | 230381 | 2020-06-11 | Navarro | Texas | 48349 | 74 | 3 |
233485 | 233485 | 2020-06-12 | Navarro | Texas | 48349 | 84 | 3 |
236591 | 236591 | 2020-06-13 | Navarro | Texas | 48349 | 87 | 3 |
239699 | 239699 | 2020-06-14 | Navarro | Texas | 48349 | 87 | 3 |
242809 | 242809 | 2020-06-15 | Navarro | Texas | 48349 | 87 | 3 |
245921 | 245921 | 2020-06-16 | Navarro | Texas | 48349 | 98 | 4 |
249034 | 249034 | 2020-06-17 | Navarro | Texas | 48349 | 98 | 4 |
252149 | 252149 | 2020-06-18 | Navarro | Texas | 48349 | 101 | 4 |
255264 | 255264 | 2020-06-19 | Navarro | Texas | 48349 | 116 | 4 |
258391 | 258391 | 2020-06-20 | Navarro | Texas | 48349 | 120 | 4 |
261518 | 261518 | 2020-06-21 | Navarro | Texas | 48349 | 120 | 4 |
264647 | 264647 | 2020-06-22 | Navarro | Texas | 48349 | 120 | 4 |
267775 | 267775 | 2020-06-23 | Navarro | Texas | 48349 | 148 | 4 |
270909 | 270909 | 2020-06-24 | Navarro | Texas | 48349 | 156 | 4 |
274049 | 274049 | 2020-06-25 | Navarro | Texas | 48349 | 170 | 5 |
277197 | 277197 | 2020-06-26 | Navarro | Texas | 48349 | 177 | 5 |
280345 | 280345 | 2020-06-27 | Navarro | Texas | 48349 | 185 | 6 |
283491 | 283491 | 2020-06-28 | Navarro | Texas | 48349 | 185 | 6 |
286637 | 286637 | 2020-06-29 | Navarro | Texas | 48349 | 185 | 6 |
289787 | 289787 | 2020-06-30 | Navarro | Texas | 48349 | 230 | 6 |
292940 | 292940 | 2020-07-01 | Navarro | Texas | 48349 | 276 | 6 |
296095 | 296095 | 2020-07-02 | Navarro | Texas | 48349 | 295 | 6 |
299256 | 299256 | 2020-07-03 | Navarro | Texas | 48349 | 323 | 6 |
302420 | 302420 | 2020-07-04 | Navarro | Texas | 48349 | 323 | 6 |
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);